Re: dollar $ signs in database
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 28820
interpreted = N
texte = I thought the getchars was for manipulating data retrieved already, not for digging into a database. I tried it anyway, but it didn't work. I just asked the client to please remove the $ signs, so it's a moot point now. Thanks for your help, in any case. You too, Ken.>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=num > >Since 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 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 thought the getchars was for manipulating data retrieved already, not for digging into a database. I tried it anyway, but it didn't work. I just asked the client to please remove the $ signs, so it's a moot point now. Thanks for your help, in any case. You too, Ken.>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=num > >Since 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 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:
How to redirect based on price subtotal? (1998)
preserving the zero's (1999)
UnitShipCost, Formulas.db and passwords (2003)
[Announce] Newest Commerce Site based on WebCatalog (1997)
Emailer (1997)
Comments in db? (1997)
international time (1997)
Grep not working, shows [grep] in browser (2000)
Rhapsody? (1997)
restarting webcatalog (2002)
RE: WebCatalog2 for NT Beta Request (1997)
Can WC remember people? (1998)
[WebDNA] [OT] the "Work in progress" thread. (2009)
Protecting Images (2003)
WebCat2 - Getting to the browser's username/password data (1997)
Webcatalog 4.0 - When will we be able to beta test it? (2000)
questions on variations of Ken's [text multi=T]var1=&var2=[/text] (1999)
Help! WebCat2 bug (1997)
Robert Minor duplicate mail (1997)
WebCommerce: Folder organization ? (1997)