What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

Re: dollar $ signs in database

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 28787
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.No, that's not possible. Comparisons on database fields consider ALL the data in that field.================================ Kenneth Grome, WebDNA Consultant 808-737-6499 http://webdna.net ================================------------------------------------------------------------- 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)
>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.No, that's not possible. Comparisons on database fields consider ALL the data in that field.================================ Kenneth Grome, WebDNA Consultant 808-737-6499 http://webdna.net ================================------------------------------------------------------------- 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 Kenneth Grome

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:

E-Mail Preferences in Admin Folder (1997) TRAINING videos - Prove IT. (1998) [OT] DOD again (2003) service stop and restart (1997) [SHOWIF] (1997) Wanted: More Math Functions (or, Can You Solve This?) (1997) Hiding HTML in an [include] file... (2004) Multiple Passwords (1997) Paths, relative paths, webstar server setup and security (Mac) (1997) Help need to figure this out today!!! Advanced Question. (2004) new orderfile params... (2003) F*** you (1998) GrandTotal not right (1997) Creating comums (1998) Credit Card Processing (2000) [taxRate] [TaxTotal] ? (1997) setitems, one more thing (1997) Signal Raised Error (1997) WebCat2 several catalogs? (1997) For those of you not on the WebCatalog Beta... (1997)