Store ASP formular in SQL
Posted on 2004-09-28
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.
In my table I have the following stored as a string:-
When I do my sql query:-
sqltext99a="Select * from MM2_LU_UOM_Conversion where BUOM ='"&varBUOM&"' AND AUOM='"&varAUOM&"'"
oRSeofd99a.open sqltext99a, "dsn=*;uid=*;pwd=*"
'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?