Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Store ASP formular in SQL

Posted on 2004-09-28
1
Medium Priority
?
209 Views
Last Modified: 2011-10-03
Hi,

This is quite simple and I'm sure it can be done (I hope!)

I simply want to store a formular in my table then retreive this and use it in my ASP page.

e.g.

In my table I have the following stored as a string:-

varLength*100

When I do my sql query:-


varLength=2.4

set oRSeofd99a=Server.CreateObject("ADODB.recordset")
sqltext99a="Select * from MM2_LU_UOM_Conversion where BUOM ='"&varBUOM&"' AND AUOM='"&varAUOM&"'"
oRSeofd99a.open sqltext99a, "dsn=*;uid=*;pwd=*"
 
varDemonitor=oRSeofd99a("ConversionX")

'if I print varDemonitor it prints as "varLength*100"  I want it to print as "240"

'I'm sure its just the way I call it from the DB,  

Can anyone help?

many thanks!

0
Comment
Question by:Pigdogmonster
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 1

Accepted Solution

by:
cheluto2 earned 160 total points
ID: 12171081
Depending on what version of IIS you are using, you can use the "eval" method to display the results, like this:

varDemonitor= oRSeofd99a("ConversionX")

Response.Write eval(varDemonitor)


This will evaluate whatever expression is in the variable and execute it as code, if possible.  You may need to add error handling just in case, too.

Hope this helps.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:   The Exchange of informatio…
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question