Re: MySQL Wildcard Trouble
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 67342
interpreted = N
texte = Try:LIKE %%YourColumn%%Matthew Bohne wrote:> 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/-------------------------------------------------------------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:
Try:LIKE %%YourColumn%%Matthew Bohne wrote:> 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/-------------------------------------------------------------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/
Adam O'Connor
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:
limit to listwords (2001)
problems with 2 tags (1997)
Emailer (1997)
emailer w/F2 (1997)
founditems / writefile (2005)
updating with ProductEditor (1998)
authenticate and password (1998)
[shell] (2002)
[WebDNA] Problem with [ListDatabases] - WebDNA CE 6.0a - Windows IIS 5.1 - Windows XP Pro Dev Box (2008)
Attn: Bug in GeneralStore example b15 (1997)
[taxRate] [TaxTotal] ? (1997)
nslookup (2000)
Stumpted Again (1997)
WC1.6 to WC2 date formatting (1997)
Duplicate Hell (1999)
Here we go again... was: DDEConnect not working (2006)
Emailer setup (1997)
More Applescript (1997)
Append File help needed (2000)
functions... (2005)