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:
OT - iHTML contact (2007)
Virtual hosting and webcatNT (1997)
WebCatalog featured at Internet World LA... (2000)
RE: Fishing: anyone on this group willing to do support? (1998)
Tab Charactor (1997)
MacAuthorize order data fields WAS:How To question... (1997)
trouble updating records in database (1998)
Separate SSL Server (1997)
WCf2 and nested tags (1997)
Multiple security dbs (1997)
Download (1999)
clean(); (2004)
WCf2 and nested tags (1997)
Items XX to XX shown (1997)
View order not right (1997)
Path of Events (1999)
WebCat2 Append problem (B14Macacgi) (1997)
Bug alert! (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
WebCatalog2 Feature Feedback (1996)