Re: search with funny characters
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 49044
interpreted = N
texte = on 3/30/2003 5:05 pm, Andrew Simpson at andrew.simpson@blackpepper.co.nz so noted...> This is what resides in the database: > Plasma Screens F # 28.5 853 x 480 NEC # # # # NEC 0%22%20-%2043%22 > > Is this just against the rules or something?Oof. This is going to cause headaches.Since the value you're searching for in the database has been stored in a URL'd form, you're going to have to double-encode the value in the search string.Either:eqPROD_NAV_SIZEdatarq=[url]0%22%20-%2043%22[/url]or:eqPROD_NAV_SIZEdatarq=[url][url]0 - 43[/url][/url]Better to store the value in the database as 0 - 43 so you don't have remember which fields require which encoding method to be found. Rob Marquardt Designer/Resident Wirehead Toast Design800 Washington Avenue North Minneapolis MN 55401 612.330.9863 v 612.321.9424 f www.toastdesign.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:
on 3/30/2003 5:05 pm, Andrew Simpson at andrew.simpson@blackpepper.co.nz so noted...> This is what resides in the database: > Plasma Screens F # 28.5 853 x 480 NEC # # # # NEC 0%22%20-%2043%22 > > Is this just against the rules or something?Oof. This is going to cause headaches.Since the value you're searching for in the database has been stored in a URL'd form, you're going to have to double-encode the value in the search string.Either:eqPROD_NAV_SIZEdatarq=[url]0%22%20-%2043%22[/url]or:eqPROD_NAV_SIZEdatarq=[url][url]0 - 43[/url][/url]Better to store the value in the database as 0 - 43 so you don't have remember which fields require which encoding method to be found. Rob Marquardt Designer/Resident Wirehead Toast Design800 Washington Avenue North Minneapolis MN 55401 612.330.9863 v 612.321.9424 f www.toastdesign.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/
Rob Marquardt
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:
Web Catalog vs. ICAT (1997)
select multiple 2 more cents (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
WebCat2b13MacPlugIn - [include] (1997)
Emailer (1997)
[WebDNA] Count Lines (2011)
WebCatalog can't find database (1997)
Running _every_ page through WebCat ? (1997)
WebCat2: Items xx to xx shown, etc. (1997)
Group search doesn't work. (1997)
resorting found set (2005)
BBEdit and WebCatalog 2.0? (1997)
Email notification to one of multiple vendors ? (1997)
WebDNA and SQL (2003)
WebCat b13 CGI -shownext- (1997)
[OT] Who's got a cool link (2002)
WebCat2 as a chat server? (1997)
problem: search crashes webstar (1997)
WebCat2b15MacPlugin - [protect] (1997)
French Webcat User (2002)