Ad Hoc Formulas

[jrobinson]

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.

[Robbo]

Sorry not answering the question but my name is John Robinson but im from Manchester England is ur j for John??

[HarryW]

Umm... there is a MS scripting control, if that helps. It does pretty much what you're asking for, allows you to evaluate expressions.