Re: dollar $ signs in database
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 28790
interpreted = N
texte = You solved the problem in a nice way, you can read about [GetChars] in your manual it gives give you the ability to return certain characters between two index values.Your search would like this:grPRICEdatarq=[getchars start=2][price][/getchars]&PRICEtype=numSince you took the $ signs out you can put back when you display price in your templates:$[format .2f][price][/format]Technical Support ********************************** Smith Micro, Internet Solutions Div | eCommerce (WebCatalog) 16855 West Bernardo Drive, #380 | ------------------------- San Diego, CA 92127 | Software & Site Development WebCatalog Support: (858) 675-0632 | http://www.smithmicro.com Fax: (858) 675-0372 ********************************* -----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of Terry Wilson Sent: Thursday, March 09, 2000 12:25 PM To: WebCatalog Talk Subject: dollar $ signs in database I'm working with a database that has $ signs before the prices. It's messing up searches since the $ is a lower ascii number than regular alphanumeric characters, making the price field data essentially numbers lower than zero, so le and ls find all records, and gr, ge, and eq find none. Deleting the $ from the DB solves the problem, but I was wondering if there was a way in webDNA to overcome the problem instead. grPRICEdatarq=[raw]$[/raw][price]&PRICEtype=num doesn't help.Terry Wilson terry@terryfic.com Terry Wilson terryw@terryfic.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 ------------------------------------------------------------- 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
Associated Messages, from the most recent to the oldest:
You solved the problem in a nice way, you can read about [getchars] in your manual it gives give you the ability to return certain characters between two index values.Your search would like this:grPRICEdatarq=[getchars start=2][price][/getchars]&PRICEtype=numSince you took the $ signs out you can put back when you display price in your templates:$[format .2f][price][/format]Technical Support ********************************** Smith Micro, Internet Solutions Div | eCommerce (WebCatalog) 16855 West Bernardo Drive, #380 | ------------------------- San Diego, CA 92127 | Software & Site Development WebCatalog Support: (858) 675-0632 | http://www.smithmicro.com Fax: (858) 675-0372 ********************************* -----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of Terry Wilson Sent: Thursday, March 09, 2000 12:25 PM To: WebCatalog Talk Subject: dollar $ signs in database I'm working with a database that has $ signs before the prices. It's messing up searches since the $ is a lower ascii number than regular alphanumeric characters, making the price field data essentially numbers lower than zero, so le and ls find all records, and gr, ge, and eq find none. Deleting the $ from the DB solves the problem, but I was wondering if there was a way in webDNA to overcome the problem instead. grPRICEdatarq=[raw]$[/raw][price]&PRICEtype=num doesn't help.Terry Wilson terry@terryfic.com Terry Wilson terryw@terryfic.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 ------------------------------------------------------------- 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
WebDNA Support
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:
Searching for ALL / empty form field (1997)
Configuration Q (1998)
recomend ftp (2001)
NetSplat and WebCat2 (1997)
encryption madness (2003)
math a various prices (1997)
Caching pages...again (2001)
Q: writefile and uploads. (1998)
possible bug in unix version? (2000)
[WriteFile] problems (1997)
SKU Question (1999)
Searching multiple Databases (1997)
Another question about credit cards (1997)
encrypt/decrypt failing (2000)
Running 2 two WebCatalog.acgi's (1996)
japanese characters (1997)
Payflow Pro help Mac OS 9 (2002)
emailer error 103 part ii (1997)
problems with 2 tags shakur (1997)
[WebDNA] Don't change [ipaddress] ... (2015)