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:

    
  1. Re: dollar $ signs in database (WebDNA Support 2000)
  2. Re: dollar $ signs in database (Kenneth Grome 2000)
  3. Re: dollar $ signs in database (Terry Wilson 2000)
  4. Re: dollar $ signs in database (WebDNA Support 2000)
  5. Re: dollar $ signs in database (Kenneth Grome 2000)
  6. dollar $ signs in database (Terry Wilson 2000)
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:

memory in high traffic servers (2004) [SHOWIF]s and empty arguments (1997) [WebDNA] products.db (2013) WebCat2: Items xx to xx shown, etc. (1997) Database Fields (1997) WebDelivery (1998) [middle] (2000) Formulas.db + Users.db (1997) Add message to Order (1997) Bulletin Board needed (2007) Verifying both name and password (was: New Problem) (1997) Triggers (2003) For those of you not on the WebCatalog Beta... (1997) can WC render sites out? (1997) Another [redirect] question (2003) RE: IIS 4 (1998) WC Database Format (1997) WebCat2 beta FTP site (1997) EIMS Problems (1997) Wanted: More Math Functions (or, Can You Solve This?) (1997)