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:

    
  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)
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)