|
-
Jan 31st, 2001, 05:44 PM
#1
Thread Starter
New Member
I've got a design dilema. I need to add the capabilites to a web site to allow the users to input metric conversion formulas into SQL server, extract the formulas from the database and use them with values passed to an ASP page. The problem I'm having is I don't know how to get either SQL Server or the ASP page (vbscript) to use the formula extracted from the database as a mathematical function.
If there is a solution in Visual Basic, I can easily add an ActiveX control to the web page to get the desired result.
There probably is no alternative to parsing the string of characters extracted from the database, but if someone does know how to get either SQL Server, VBScript or Visual Basic to recognize the string as mathematical operators that would be ideal. Of course, if anyone has a formula parser, that would work too.
Many thanks for any help
-
Feb 1st, 2001, 08:26 AM
#2
Frenzied Member
use eval()
eg:
Code:
<%@ Language=VBScript %>
<html>
<head>
<body>
<% dim strFormula
strFormula = "26*32"
response.write strFormula & "= " & eval(strFormula)
%>
</body>
</html>
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote