:)
On 3/12/06,
Patrick Branley <[EMAIL PROTECTED]> wrote:
#returnedCode# is ur problem. whatever sets that variable is setting it to 'connection failure' sounds like a variable clash to me.
check the logic of ur page and see if returnedCode is being used in more than 1 spot.
ps using a cfquery name as 'response' is very dodgy. Response usually would refer to the http request response, not a query.
even qResponse would be better. but id suggest qResponseCodes. or even q<SystemthatgeneratesCodes>responseCodes.
readability or 'intrinsic documentation' is the most important type of code documentation in my opinion.
My 2c + rant
PatOn 3/12/06, Carl Vanderpal <[EMAIL PROTECTED]> wrote:I am looking at the other code before and after this code is called, to check to see if there is anything triggering it..
Stored Proceedure Table Name
sp_get_ResponseCodes_Details
Stored Proceedure:
CREATE PROCEDURE sp_get_ResponseCodes_Details
@Code int
AS
SELECT *
FROM ResponseCodes
WHERE Code = @Code
GOHere is what called it..
<cfquery name="Response" datasource="#Application.PDS#" username="#Application.DBUSER#" password="#Application.DBPASS#">
sp_get_ResponseCodes_Details #returnedCode#
</cfquery>
On 3/12/06, Patrick Branley <[EMAIL PROTECTED]> wrote:how is that sql being generated ? is it just a cfstoredproc call ? or is there content comming from somewhere else to generate the cfquery call ?
'Connection Failure' can come from CFHTTP or cfschedules when cf cant make a connection. or u have some weired variable clashing problem going on.
my 2c patOn 3/12/06, darryl lyons < [EMAIL PROTECTED]> wrote:
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:
--
====================================
Postal: Po Box 3462 Dural, NSW 2158
Email: mailto: [EMAIL PROTECTED]
FireFly Internet Phone: 80011777
--
====================================
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
-~----------~----~----~----~------~----~------~--~---
