It was the " it only wanted '. > -----Original Message----- > From: Barry Beattie [SMTP:[EMAIL PROTECTED] > Sent: Tuesday, 22 June 2004 16:12 > To: CFAussie Mailing List > Subject: [cfaussie] RE: Access 97 Question > > from MSAccess itself or via CFQUERY (to the Jet db engine)? > > hmmm: it should be > > MSAccess: where surname like "*smith*" > cfquery: where surname like "%smith%" > > if it's not working, something else is wrong (eg, surname is not a text > field, an space, etc). > > does: where surname like "smith" work (yeah, no results, but no errors > either)? > > just a thought > barry.b > > > -----Original Message----- > From: KNOTT, Brian [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 22 June 2004 4:06 PM > To: CFAussie Mailing List > Subject: [cfaussie] Access 97 Question > > Trying to get the like operator to work in Access 97. > > If I use the standard where surname like '%smith%' it fails > also where surname like '*smith *' fails. > > Any ideas > > Brian Knott > MIS Analyst > Group Accounting & MIS, Accounting and Tax > (07)383 55977 > Suncorp Pty Ltd > > > > -------------------------------------------------------------------------- > --------- > This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or one of > its related entities ("Suncorp"). > > Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on > 1800 689 762 or at suncorp.com.au. > > The content of this e-mail is the view of the sender or stated author and > does not necessarily reflect the view of Suncorp. The content, including > attachments, is a confidential communication between Suncorp and the > intended recipient. If you are not the intended recipient, any use, > interference with, disclosure or copying of this e-mail, including > attachments, is unauthorised and expressly prohibited. If you have > received this e-mail in error please contact the sender immediately and > delete the e-mail and any attachments from your system. > > If this e-mail constitutes a commercial message of a type that you no > longer wish to receive please reply to this e-mail by typing Unsubscribe > in the subject line. > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] Aussie Macromedia Developers: > http://lists.daemon.com.au/
--- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
