Forums

This topic is locked

Passing Parameters to SQL procedure

Posted 14 Apr 2005 21:22:32
1
has voted
14 Apr 2005 21:22:32 Dennis Lordemann posted:
I am working on Dreamweaver MX 2004 v7.0.1 and SQL server 2000. I am trying to pass a parameter selected by the user from a menu (tied to SQL table) to a SQL procedure that narrows the scope of the list being displayed. I keep getting error messages when I define the variable in the record set. In the SQL procedure the Parameter name is @CollegeName, when I define the variable using that name I get "@CollegeName is an invalid variable name" When I change the name to something like VCollegeName I get "VCollegeName is an invalid variable name; it does not appear in the SQL". In the SQL procedure I can only define the parameter using the @ as the first character.

Reply to this topic