which db, what is the datatype of lines?
On Fri, 5 Nov 2004 14:34:46 -0600, Eric Creese <[EMAIL PROTECTED]> wrote:
> Can some one please tell me why this does not work? If you pass the url.inch
> variable it works fine. If you pass the url.line variable it fails with the
> following error. code is below the error I need an answer quick please
>
> Syntax error or access violation: You have an error in your SQL syntax near 'lines =
> 1 ORDER BY Charht ' at line 8 The error occurred in
> /home/auto1/autocomm-inc.com/html/dev/matrix.cfm: line 3
> 1 : <cfinclude template="header2.cfm">
> 2 :
> 3 : <cfquery name="getmatrix" datasource="yeuwes">
> 4 : SELECT *
> 5 : FROM p#url.prodid#_matrix
>
> SELECT * FROM p1_matrix WHERE display='yes' AND lines = 1 ORDER BY Charht ;
>
> <cfquery name="getmatrix" datasource="autocomm">
> SELECT *
> FROM p#url.prodid#_matrix
> WHERE display='yes'
> <cfif url.prodid EQ 1>
> <cfif isdefined('url.inch')>
> <cfif url.inch EQ 1>
> AND charht < 2
> <cfelseif url.inch EQ 2>
> AND charht < 3
> AND charht >=2
> <cfelseif url.inch EQ 3>
> AND charht < 4
> AND charht >=3
> <cfelseif url.inch EQ 4>
> AND charht < 7
> AND charht >=4
> <cfelseif url.inch EQ 7>
> AND charht >=7
> </cfif>
> </cfif>
> <cfif isdefined('url.line')>
> <cfif url.line EQ 1>
> AND lines = 1
> <cfelseif url.line EQ 2>
> AND lines =2
> <cfelseif url.line EQ 3>
> AND lines =3
> <cfelseif url.line EQ 4>
> AND lines >=4
> </cfif>
> </cfif>
> ORDER BY Charht
> <cfelseif url.prodid EQ 6>
> <cfif isdefined('url.inch')>
> <cfif url.inch EQ 5>
> AND charht < 6
> <cfelseif url.inch EQ 8>
> AND charht < 9
> AND charht >=6
> <cfelseif url.inch EQ 18>
> AND charht < 19
> AND charht >=9
> <cfelseif url.inch EQ 29>
> AND charht < 30
> AND charht >=19
> <cfelseif url.inch EQ 30>
> AND charht >=30
> </cfif>
> </cfif>
> <cfif isdefined('url.line')>
> <cfif url.line EQ 1>
> AND lines = 1
> <cfelseif url.line EQ 2>
> AND lines =2
> <cfelseif url.line EQ 3>
> AND lines =3
> <cfelseif url.line EQ 4>
> AND lines >=4
> </cfif>
> </cfif>
> ORDER BY charht
> <cfelseif url.prodid EQ 19>
> <cfif isdefined('url.type')>
> <cfif url.type EQ 'baseball'>
> AND event ='baseball'
> <cfelseif url.type EQ 'basketball'>
> AND (event = 'basketball'
> OR event='Bsktbll/Wrstlng/Vollyball'
> OR event='Possession Indicator'
> OR event='Foul Panels'
> OR event='Shot Clock')
> <cfelseif url.type EQ 'football'>
> AND event ='football'
> <cfelseif url.type EQ 'hockey'>
> AND event ='hockey'
> <cfelseif url.type EQ 'BWV'>
> AND event ='Bsktbll/Wrstlng/Vollyball'
> <cfelseif url.type EQ 'race'>
> AND event ='race track'
> <cfelseif url.type EQ 'multi'>
> AND event ='multi-sport'
> <cfelseif url.type EQ 'soccer'>
> AND event ='soccer'
> </cfif>
> </cfif>
> ORDER BY event
> </cfif>
> ;
> </cfquery>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183541
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
