Re: dollar $ signs in database
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 28823
interpreted = N
texte = You are right, the search will not work. I was thinking about stripping thedollar signoff, but the dollar sign is not in the [price] you were using for the searchkey.The best solution is what you came up with.-----Original Message-----From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]OnBehalf Of Terry WilsonSent: Thursday, March 09, 2000 4:04 PMTo: WebCatalog TalkSubject: Re: dollar $ signs in databaseI thought the getchars was for manipulating data retrieved already,not for digging into a database. I tried it anyway, but it didn'twork. I just asked the client to please remove the $ signs, so it's amoot 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 twoindex>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 Wilsonterryw@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 are right, the search will not work. I was thinking about stripping thedollar signoff, but the dollar sign is not in the [price] you were using for the searchkey.The best solution is what you came up with.-----Original Message-----From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]OnBehalf Of Terry WilsonSent: Thursday, March 09, 2000 4:04 PMTo: WebCatalog TalkSubject: Re: dollar $ signs in databaseI thought the getchars was for manipulating data retrieved already,not for digging into a database. I tried it anyway, but it didn'twork. I just asked the client to please remove the $ signs, so it's amoot 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 twoindex>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 Wilsonterryw@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:
No Access warning when caching HTML files (1997)
Confirming a bug/oddity (2003)
Extended [ConvertChars] (1997)
Need help with emailer- 2 issues (1997)
Running _every_ page through WebCat ? (1997)
incrementing a counter remotely? (1999)
OrderFile (2000)
Accepting credit cards (1997)
find with exceptions (1997)
Formatting a .txt file (1998)
Here we go again...WebDNA - SQL- Clustering (2006)
Time Remaining? (1998)
ListFiles Bug (1998)
test (2002)
Need help with emailer- 2 issues (1997)
WebCatalog for WebStar V (2001)
New WebMerchant/Mac beta available (1997)
Re:2nd WebCatalog2 Feature Request (1996)
faxing orders (2000)
[writefile] (1997)