Can a Stored Procedure may be accessed directly from an Active Server Page document where submitted form field values are a necessary query variable.It is possible but as far as I am aware variables must be read in as a string and then separated out at server end.
Basically create a form which will post to another form containing user entry. have a database connection which sends the users input to the stored procedure whcih will run a query and return the results via the open connection.
sorry i can't be of more help, I'm just leaning this atmstored procs can be called by straight sql statements.
example:
exec some_storedProcedure(parameter1, parameter2)
now, coldfusion has a cfstoredproc tag. Not sure if asp does (I doubt it). Just try running it with the sql statement. Also, blurring all the parameters into one character string is not a good idea. Let the sproc work for you. Just pass the arguments in as parameters, and if your proc is set up to handle parameters... all will be good.Cheers, I'll give this a try
Basically create a form which will post to another form containing user entry. have a database connection which sends the users input to the stored procedure whcih will run a query and return the results via the open connection.
sorry i can't be of more help, I'm just leaning this atmstored procs can be called by straight sql statements.
example:
exec some_storedProcedure(parameter1, parameter2)
now, coldfusion has a cfstoredproc tag. Not sure if asp does (I doubt it). Just try running it with the sql statement. Also, blurring all the parameters into one character string is not a good idea. Let the sproc work for you. Just pass the arguments in as parameters, and if your proc is set up to handle parameters... all will be good.Cheers, I'll give this a try