Stored Procedures in SMS database

[Christopher]

Hi all,

Yes it worked !! No prb executing the procedure but haw can i put a variable into:

Mydb.dbStoredProc="sp_info,'P87640a'&# 34;

Now the 'P87640a' must be a variable which comes from the user inputting it in a form.

Any ideas??

Christopher

PS SMS is case sensitive !!!!!

[Frank]

Chris,
What is SMS database ? MS-SQL ?? If so, MS-SQL is case sensitive anyway in filter text, fieldnames etc.... You can use Tables, ACCESS Queries (well behave), SQL Views and SPs in ASPDB. Select * From Table or Select * from View has no difference. why a problem to put a form variable into the property string ?

x=request.form("VarName&#34
Mydb.dbStoredProc="sp_info," & "'" & x & "'"

Still, you have to be more specific to get mor especific help.

Frank


On 2/11/99 12:02:29 PM, Christopher wrote:
> Hi all,

Yes it worked !! No prb executing the procedure but haw can i
> put a variable
> into:

Mydb.dbStoredProc="sp_info,'P87640a'&# 34;

Now the
> 'P87640a' must be a variable which comes from the user inputting it
> in a form.

Any ideas??

Christopher

PS SMS is case sensitive !!!!!