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: SM: MySQL and Numbers (BUG)

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 62840
interpreted = N
texte = They have a version later than 6.0a? On 8/24/05 11:21 AM, "Jesse Proudman" wrote: > SM has an updated version of 6 that fixes this. See if you can get a > copy. > > On Aug 24, 2005, at 8:40 AM, Clint Davis wrote: > >> The following query executed via command line or phpMyAdmin returns the >> correct price with 2 decimal places: >> >> SELECT thumb, title, itemid, price, round( price, 2 ) >> FROM items >> WHERE quantity >0 >> ORDER BY RAND( ) >> LIMIT 2 >> >> The same query executed via WebDNA DOES NOT WORK. The price is >> returned as a >> long string of numbers like: 1076756480 ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: SM: MySQL and Numbers (BUG) ( Clint Davis 2005)
  2. Re: SM: MySQL and Numbers (BUG) ( Jesse Proudman 2005)
  3. Re: SM: MySQL and Numbers (BUG) ( Clint Davis 2005)
  4. Re: SM: MySQL and Numbers (BUG) ( Jesse Proudman 2005)
  5. SM: MySQL and Numbers (BUG) ( Clint Davis 2005)
They have a version later than 6.0a? On 8/24/05 11:21 AM, "Jesse Proudman" wrote: > SM has an updated version of 6 that fixes this. See if you can get a > copy. > > On Aug 24, 2005, at 8:40 AM, Clint Davis wrote: > >> The following query executed via command line or phpMyAdmin returns the >> correct price with 2 decimal places: >> >> SELECT thumb, title, itemid, price, round( price, 2 ) >> FROM items >> WHERE quantity >0 >> ORDER BY RAND( ) >> LIMIT 2 >> >> The same query executed via WebDNA DOES NOT WORK. The price is >> returned as a >> long string of numbers like: 1076756480 ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/ Clint Davis

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:

Sorting (1998) RE: Answer: WebDelivery downloads alias, not original ? (1997) problems with WebCat-Plugin (1997) really wierd date stuff on NT (1997) [WebDNA] Webdna error on plain html site (2013) wierd crashes for multi-sendmails on NT (1997) Template Encryption (1998) Help! WebCat2 bug (Ben's input) (1997) [WebDNA] Error: Can't open order file. Ignoring [OrderFile] context Error: Error: expected [/APPLICATION], but found [/!] instead[/!] (2011) PSC recommends what date format yr 2000??? (1997) Return records from another (1997) WC1.6 to WC2 date formatting (1997) Search returns all, not 20 (1997) real beginner stumped (2000) search for all (1998) [WebDNA] Sort by Row (2017) Document Contains No Data! (1997) WebCatalog seems to choke on large (2meg) html files. (1998) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) WebCatalog for guestbook ? (1997)