Pigdogmonster
asked on
Store ASP formular in SQL
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.CreateOb ject("ADOD B.recordse t")
sqltext99a="Select * from MM2_LU_UOM_Conversion where BUOM ='"&varBUOM&"' AND AUOM='"&varAUOM&"'"
oRSeofd99a.open sqltext99a, "dsn=*;uid=*;pwd=*"
varDemonitor=oRSeofd99a("C onversionX ")
'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!
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.CreateOb
sqltext99a="Select * from MM2_LU_UOM_Conversion where BUOM ='"&varBUOM&"' AND AUOM='"&varAUOM&"'"
oRSeofd99a.open sqltext99a, "dsn=*;uid=*;pwd=*"
varDemonitor=oRSeofd99a("C
'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!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.