Is the stored procedure actually called "sp_get_ResponseCodes_Details Connection Failure" ? If not, then that is even more weird.
Darryl On 3/12/06, Carl Vanderpal <[EMAIL PROTECTED]> wrote: > can anyone explain what is going on here, as things were working a few weeks > back but not now.. > > It is running on CF 4.5 and like the guys the other day saying they are > updating a CFModuled spaghetti nightmare (I know how you feel). > I have checked the stored proceedure and all looks in working order. > > > :) > > === > Error Occurred While Processing Request > Error Diagnostic Information > > ODBC Error Code = 37000 (Syntax error or access violation) > > [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax > near 'Failure'. > > SQL = "sp_get_ResponseCodes_Details Connection Failure" > > Data Source = "--Removed--" > > The error occurred while processing an element with a general identifier of > (CFQUERY), occupying document position (173:2) to (173:121). > > Date/Time: 03/12/06 14:45:16 > Browser: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.1) > Gecko/20060111 Firefox/1.5.0.1 > Remote Address: 60.240.64.217 > HTTP Referer: > https://mysite/ssl/checkout/checkout5.cfm?CFID=9323407&CFTOKEN=13768207 > > === > > > > ==================================== > Postal: Po Box 3462 Dural, NSW 2158 > Email: mailto:[EMAIL PROTECTED] > FireFly Internet Phone: 80011777 > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~----------~----~----~----~------~----~------~--~---
