ASP Forum
passing parameters at run time
change | Posted 7:19am 13. December 2007 Server Time |

scribes
have a query that takes a param at run time but it returns the following error although the value is there when i do a response.write this is the code.....

query = "SELECT * FROM CONTRACTORS WHERE CONTRACTORS.NAME = " & request.Form("sltcontractor")

Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
Fredde | Posted 11:31am 13. December 2007 Server Time |

try

query = "SELECT * FROM CONTRACTORS WHERE CONTRACTORS.NAME = '" & request.Form("sltcontractor") & "'"


Reply to Post passing parameters at run time



Back to Forum Page