Jason Davis wrote:
> I tried also running inside a <cfquery>
>
> <cfquery ... ...>
> mystoredprodure 'param1',param2,param3
> </cfquery>
>
> still, same error. the weirdset thing is that exactly the same code
> ("mystoredprodure 'param1',param2,param3") work perfectly
> in query analazyer (sql enterprise manager)
Are you running query analyser through ODBC?
BTW, you should change the name of the variable you are passing. SQL is
a reserved word. Maybe MS SQL Server doesn't think so (just like Access
doesn't think Date is a reserved word), but it is. And if the ODBC
driver is a bit more strict, you have a problem (just like using date
with OLE DB and Access works, but not with ODBC).
Jochem
______________________________________________________________________
Why Share?
Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
