On Apr 9, 8:27 pm, Matthew Woodward <[email protected]> wrote: > 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?
I was using the standard MS driver. I switched the jTDS and I got a different error. This time I got "Parameter @hideflaggedposts not found in the parameter list." So it sounds to me like it's getting a bit further through the function before causing problems. > 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. Yup, I renamed the old one and then restarted the system. Since I'm in a VM, it's pretty easy. > > <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? Not yet. > And again, important to try both drivers to see if there's different > behavior between them. Sure seems like it. David -- official tag/function reference: http://openbd.org/manual/ mailing list - http://groups.google.com/group/openbd?hl=en
