Using MagicCell to calculate value

[Tim Davidge]

I remember seeing an example somewhere of using MagicCell to apply math calculations rather than in the SQL statement, or perhaps even using a VB script. Can anyone point me at a few examples or provide the syntax for such as I can't find them again .. sorry in advance.

And if it is possible, can it take two fields and apply multiplication or division of each as in dividing field A by B ?

Tim

[Mark]

Hi Tim,
Maybe you are thinking of Programming Examples 63a, 63b, and 78 at our examples site: http://208.196.181.86/apps/
I hope that helps.
Mark.


------------
Tim Davidge at 3/12/01 2:46:13 AM


I remember seeing an example somewhere of using MagicCell to apply math calculations rather than in the SQL statement, or perhaps even using a VB script. Can anyone point me at a few examples or provide the syntax for such as I can't find them again .. sorry in advance.

And if it is possible, can it take two fields and apply multiplication or division of each as in dividing field A by B ?

Tim

[Mark]

Tim,
Also look at eample 32 at:
http://208.196.181.86/apps
Mark.


------------
Mark at 3/12/01 10:05:09 AM

Hi Tim,
Maybe you are thinking of Programming Examples 63a, 63b, and 78 at our examples site: http://208.196.181.86/apps/
I hope that helps.
Mark.


------------
Tim Davidge at 3/12/01 2:46:13 AM


I remember seeing an example somewhere of using MagicCell to apply math calculations rather than in the SQL statement, or perhaps even using a VB script. Can anyone point me at a few examples or provide the syntax for such as I can't find them again .. sorry in advance.

And if it is possible, can it take two fields and apply multiplication or division of each as in dividing field A by B ?

Tim

[Tim]

Hi Mark,

Yes I remember these examples, thanks for that. Unfortunately I was looking for a simple script that would do some simple math of two SQL fields that already have been calculated [in SQL] but due to SQL syntax I cannot display the fields I want as it requires the field to be included in the GROUP by clause if I do. I have no idea how to write VB scripts .. siiiigh

Now are there any examples that if I save the values as exported variables, can we apply some math to them either on another page or in later <% %> declarations ?

I&#39;m really wanting to get the records without first displaying them, then calculating another value and then displaying the result.

I&#39;m sure I&#39;m making this far more complex than it really is as it all sounds very complicated reading this.

Thanks,

Tim
------------
Mark at 3/12/01 10:12:49 AM

Tim,
Also look at eample 32 at:
http://208.196.181.86/apps
Mark.


------------
Mark at 3/12/01 10:05:09 AM

Hi Tim,
Maybe you are thinking of Programming Examples 63a, 63b, and 78 at our examples site: http://208.196.181.86/apps/
I hope that helps.
Mark.


------------
Tim Davidge at 3/12/01 2:46:13 AM


I remember seeing an example somewhere of using MagicCell to apply math calculations rather than in the SQL statement, or perhaps even using a VB script. Can anyone point me at a few examples or provide the syntax for such as I can&#39;t find them again .. sorry in advance.

And if it is possible, can it take two fields and apply multiplication or division of each as in dividing field A by B ?

Tim