Re: MySQL Wildcard Trouble
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 67341
interpreted = N
texte = Build the search string first...[text show=f]strQuery=[url]"SELECT * FROM Classifieds WHERE AdText LIKE '%[/url][_textstring][url]%'"[/url][/text]then search using [unurl][strQuery][/unurl]... Or try it without the url/unurl combo.Sam McConnell wrote:> Hello,>> I'm having a bit of trouble with WebDNA and MySQL. I need to query a > table in the database where the text field matches a search. The > problem I'm having is that WebDNA doesn't work with the wildcard syntax.>> Basically, I'm trying to do "SELECT * FROM Classifieds WHERE AdText > LIKE '%[_textstring]%'", but "%" seems to cause an error with WebDNA. > If I take out the "%", the query works.>> Thanks>-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list
.To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Build the search string first...[text show=f]strQuery=[url]"SELECT * FROM Classifieds WHERE AdText LIKE '%[/url][_textstring][url]%'"[/url][/text]then search using [unurl][strQuery][/unurl]... Or try it without the url/unurl combo.Sam McConnell wrote:> Hello,>> I'm having a bit of trouble with WebDNA and MySQL. I need to query a > table in the database where the text field matches a search. The > problem I'm having is that WebDNA doesn't work with the wildcard syntax.>> Basically, I'm trying to do "SELECT * FROM Classifieds WHERE AdText > LIKE '%[_textstring]%'", but "%" seems to cause an error with WebDNA. > If I take out the "%", the query works.>> Thanks>-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Matthew Bohne
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:
Date problems (1997)
PR: WebCatalog Affiliates Program Announced -- Share the revenue for promoting WebCatalog (2000)
Search on encrypted field (2000)
WebDNA Book? (2003)
suffix mapping for NT? (1997)
ANother SHOWIF problem (1997)
Protecting Images (2003)
lookups (2000)
RE: URL too Long? (1997)
re: [addlineitem] working almost (1997)
Multiple prices (1997)
bug in [SendMail] (1997)
Trouble with formula.db (1997)
question: back button prevention (1997)
[switch] platform specific bug??? (2003)
Almost a there but..bye bye NetCloak (1997)
format problem on NT? (1997)
numfound=0 for a search after going into the SSL (2003)
Firesite cache vs webcat cache (1997)
Simultaneous Users (1999)