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... :-)RobOn 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:
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... :-)RobOn 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)