Access uses * for wildcard operator. CF uses % but converts it via the ODBC driver to Access native code. % works with SQL Server.
-----Original Message----- From: Matt Horn [mailto:[EMAIL PROTECTED] Sent: 07 July 2004 14:18 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] SQL Thanks odd that it doesnt work in the access query window :P stupid access ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 07, 2004 3:45 PM Subject: Re: [ cf-dev ] SQL > > use: > > like 'c%' > > > > > > "Matt Horn" > <[EMAIL PROTECTED] To: <[EMAIL PROTECTED]> > rn.org> cc: > Subject: [ cf-dev ] SQL > 07/07/2004 > 14:28 > Please > respond to > dev > > > > > > Hello again > > > any reason why Access returns one record for this query > > Select ProductionHouseName, ProductionHouseID from tblproductionHouse > where productionhousename like 'c*' > > but query.recordcount in CF returns 0 ? > > Matt > |\--------------------/| > Matt Horn > Web Applications Developer > Ph:+2782 424 3751 > W: http://www.matt-horn.org > E:[EMAIL PROTECTED] > |\--------------------/| > > > > > -- > These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
