Hi,

This is probably a stupid question but it is bothering me.

I am retrieving an equation from a database, the datatype of the column is varchar.

       tmpEq = ((A + E) * 3.141) + C

The equation is then stored in a variable. I then replace the alpha characters with the corresponding numeric values (retrieved from another database table) the variable would then look like this;

      tmpEq = ((cint(10) + cint(10)) * 3.141) + cint(10)

The problem is when I write the tmpEq variable <%=tmpEq%> it writes the string instead of the result of the calculation.

Like I said this is probably a dumb question, but any help would be great.

Thanks,

Adam

(Oh this is classic asp and not .net)

Hi Adam,

If you're using VBScript You could use the Execute method...

Dim result
Execute "result = " & tmpEq
Response.Write result

Or for JScript you could do similar using eval().

HTH,

Chris

Sounds a little confusing. I'm sure you have a good reason to store characters you intend to calculate as a varChar, are some of these characters not numbers?
More information would be good:
;;tmpEq = ((A + E) * 3.141) + C
what's A, E and C
;;The problem is when I write the tmpEq variable <%=tmpEq%> it writes the string
what exactly is 'the string'

run some data type functions on your values to determine what they are:
EG if your values A = 2
                    E = 5
are strings A + E = 25 of course if they are numbers will = 7

Wind is your friend
Matt