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:

    
  1. Re: MySQL Wildcard Trouble ( Adam O'Connor 2006)
  2. Re: MySQL Wildcard Trouble ( Adam O'Connor 2006)
  3. Re: MySQL Wildcard Trouble ( Sam McConnell 2006)
  4. Re: MySQL Wildcard Trouble ( Adam O'Connor 2006)
  5. Re: MySQL Wildcard Trouble ( Matthew Bohne 2006)
  6. MySQL Wildcard Trouble ( Sam McConnell 2006)
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)