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