On Sat, Apr 9, 2011 at 5:55 PM, David Kanter <[email protected]> wrote: > I get a General SQL Error with the following message: "Parameter @id > was not defined for stored procedure rwtadmin.xcursus_getthread." THe > SQL State is S1093.
Which driver are you using? If you're using the MS driver have you tried the jTDS driver instead or vice-versa? As an aside, I do believe you have to delete the datasource and create it fresh when you're changing drivers, or for testing I'd just create two datasources, one for each driver, so you can easily flip back and forth while testing just by changing the datasource name. > <cfprocparam type="in" value="#url.id#" > cfsqltype="CF_SQL_INTEGER" null="No" dbvarname="@id"> Just out of curiosity have you tried it without dbvarname defined at all? And again, important to try both drivers to see if there's different behavior between them. -- Matthew Woodward [email protected] http://blog.mattwoodward.com identi.ca / Twitter: @mpwoodward Please do not send me proprietary file formats such as Word, PowerPoint, etc. as attachments. http://www.gnu.org/philosophy/no-word-attachments.html -- official tag/function reference: http://openbd.org/manual/ mailing list - http://groups.google.com/group/openbd?hl=en
