dollar $ signs in database
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 28786
interpreted = N
texte = 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
Associated Messages, from the most recent to the oldest:
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
Terry Wilson
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:
[ModDate] & [ModTime] ? (1997)
LookUp Tag (1997)
Email Destination Folder Question (2004)
This list needs a digest: rant, rave... (1997)
[OT] Theiving B*****ds (2004)
[WebDNA] Salesforce integration (2009)
WebCatalog2 Feature Feedback (1996)
No Access warning when caching HTML files (1997)
Configuring E-mail (1997)
Cannot get subtotal to work (1997)
Submit buttons not working.... (1999)
Web Catalog 2 demo (1997)
Using Plug-In while running 1.6.1 (1997)
Problems appending to database (1997)
Bug Report, maybe (1997)
Moment of Thanks (1997)
Information on Vieworders.tpl (1998)
Re:quit command on NT (1997)
[taxrate] question (1997)
WebCat2b12 forgets serial # (1997)