Re: [WebDNA] SQL Search

This WebDNA talk-list message is from

2010


It keeps the original formatting.
numero = 104687
interpreted = N
texte = Hi Paul, Thanks, I knew I was missing something. I also simplified the search. For a single field I use: select * from WHERE ='[searchterm]'; and for multiple fields use: select * from WHERE LIKE '[searchterm]' || LIKE '[searchterm]' || LIKE '[searchterm]' || LIKE '[searchterm]'; Everything working perfectly now... :-) Rob On 2010-02-04, at 3:36 AM, Paul Willis wrote: > > On 3 Feb 2010, at 23:14, Rob wrote: > >> SELECT dealer, prod_desc FROM prod WHERE MATCH(dealer, prod_desc) AGAINST ('searchterm'); > > Shouldn't that be... > > AGAINST ('[searchterm]'); > > ...on the end? > > Paul--------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > Bug Reporting: http://forum.webdna.us/eucabb.html?page=topics&category=288 Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] SQL Search (Rob 2010)
  2. Re: [WebDNA] SQL Search (Paul Willis 2010)
  3. [WebDNA] SQL Search (Rob 2010)
Hi Paul, Thanks, I knew I was missing something. I also simplified the search. For a single field I use: select * from WHERE ='[searchterm]'; and for multiple fields use: select * from WHERE LIKE '[searchterm]' || LIKE '[searchterm]' || LIKE '[searchterm]' || LIKE '[searchterm]'; Everything working perfectly now... :-) Rob On 2010-02-04, at 3:36 AM, Paul Willis wrote: > > On 3 Feb 2010, at 23:14, Rob wrote: > >> SELECT dealer, prod_desc FROM prod WHERE MATCH(dealer, prod_desc) AGAINST ('searchterm'); > > Shouldn't that be... > > AGAINST ('[searchterm]'); > > ...on the end? > > Paul--------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > Bug Reporting: http://forum.webdna.us/eucabb.html?page=topics&category=288 Rob

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

[getchars] questions (1997) Secure Server (1997) [WebDNA] math variables bug in OSX 7.0 / 7.1 (2012) Problems getting parameters passed into email. (1997) Use of & in text areas.... (1998) Signal Raised Error (Part III) (1997) How bad an idea is it to put cart=[cart] on all links? (2000) Searching an Email database (1997) determining plug-ins? (1998) Upgrade to 3.07 problems (2000) WebCat2b12--[searchstring] bug (1997) Live server problems (1999) Extended [ConvertChars] (1997) Suggestions for Topics to be covered in an Advanced (1998) More than one db with the same namn (was: WC2f3) (1997) Buggy Code (1998) WebCat2 Append problem (B14Macacgi) (1997) What am I missing (1997) Custom Shipping Charges (1997) RE: Credit card processing - UK (1997)