MySQL Wildcard Trouble
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 67340
interpreted = N
texte = 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-- Sam McConnellSoftware DeveloperThe GoTriCities Network - http://www.gotricities.net/ Phone: 423-392-1757 -------------------------------------------------------------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:
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-- Sam McConnellSoftware DeveloperThe GoTriCities Network - http://www.gotricities.net/ Phone: 423-392-1757 -------------------------------------------------------------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/
Sam McConnell
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:
RE: Web*SSL and WebCatalog (1997)
programmer help needed (1998)
Anyone get WebDNA working on a windows XP Home box? (2006)
New WebCatalog Version !!! (1997)
Include a big block of text (1997)
Ampersand (1997)
Hosts who have upgraded to v5.0? (2003)
Understanding texta (1997)
Document Contains No Data! (1997)
[WebDNA] WebDNA is not parsing CSS file (2010)
Username for Admin Group (1997)
Exclamation point (1997)
Carts & Refering URLs (1997)
WebCat2b15MacPlugIn - [authenticate] not [protect] (1997)
WebCat2b13MacPlugIn - More limits on [include] (1997)
same product in cart (1997)
Windows-based Code Editor (2002)
WebDNA 4.5 & iTools 7 (2003)
Protect vs Authenicate (1997)
[Sum] function? (1997)