have you got a cfoutput around that ? On Wed, Jun 1, 2011 at 11:02 PM, Terry Troxel <[email protected]>wrote:
> > I have been doing this forever with no problems until today. > Can anyone spot my error(s)?: > > <cfquery name="searcher" datasource="rnc"> > select * from leads where 0 = 0 > <cfif lname NEQ ""> > and lastname LIKE '#lname#%' > </cfif> > </cfquery> > > which give me this error: > Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC > Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. > Expected 1. > The error occurred in *C:\Inetpub\wwwroot\RNC\lmain.cfm: line 13* > > 11 : select * from leads where 0 = 0 > 12 : <cfif lname NEQ "">*13 : and lastname LIKE > '#lname#%'* > 14 : </cfif> > 15 : </cfquery> > > ------------------------------ > SQLSTATE 07002 SQL select * from leads where 0 = 0 and lastname LIKE > 'tro%' VENDORERRORCODE -3010 DATASOURCE rnc > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345037 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
