Bug: MySQL WebDNA 6 int bigint fail case

This WebDNA talk-list message is from

2004

It keeps the original formatting. numero = 59440
interpreted = N
texte = Hi, Narrowed down a bug with numbers, WebDNA 6 and MySQL.I found it by wanting to store a CART num in a bigint field.Note: WebDNA Linux and WebDNA OSX return different Values.Using Webmin to test MySQL, shows the MySQL is correct.= = = = = = = = = =-- Using this as input:---- MySQL dump 9.11---- Host: localhost Database: test-- -------------------------------------------------------- Server version4.0.21-standard---- Table structure for table `test`--DROP TABLE IF EXISTS `test`;CREATE TABLE `test` ( `testint` int(11) unsigned NOT NULL default '0', `testbigint` bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (`testint`)) TYPE=MyISAM;---- Dumping data for table `test`--INSERT INTO `test` VALUES (4294967295,1095711250141);= = = = = = = = = =On both Linux and OSX: Output from SQL commandselect * from test ;testint 4294967295testbigint 1095711250141Works as it should.= = = = = = = = = =from WebCat 6 Linux RHES 3.0 using select * from test ;Host: localhostServer Version: 4.0.21-standardClient Version: 3.23.58 1 records foundtestint 2147483647testbigint 494589661= = = = = = = = = =from WebCat 6 OSX using select * from test ;Host: localhostServer Version: 4.0.21-standardClient Version: 3.23.58 1 records foundtestint 2147483647testbigint 2147483647-------------------------------------------------------------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:

Re: Bug: MySQL WebDNA 6 int bigint fail case ( "Steve Contreras" 2004) Re: Bug: MySQL WebDNA 6 int bigint fail case ( Jim Lanford 2004) Re: Bug: MySQL WebDNA 6 int bigint fail case ( John Peacock 2004) Re: Bug: MySQL WebDNA 6 int bigint fail case ( Jim Lanford 2004) Re: Bug: MySQL WebDNA 6 int bigint fail case ( John Peacock 2004) Bug: MySQL WebDNA 6 int bigint fail case ( Jim Lanford 2004)

Hi, Narrowed down a bug with numbers, WebDNA 6 and MySQL.I found it by wanting to store a CART num in a bigint field.Note: WebDNA Linux and WebDNA OSX return different Values.Using Webmin to test MySQL, shows the MySQL is correct.= = = = = = = = = =-- Using this as input:---- MySQL dump 9.11---- Host: localhost Database: test-- -------------------------------------------------------- Server version4.0.21-standard---- Table structure for table `test`--DROP TABLE IF EXISTS `test`;CREATE TABLE `test` ( `testint` int(11) unsigned NOT NULL default '0', `testbigint` bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (`testint`)) TYPE=MyISAM;---- Dumping data for table `test`--INSERT INTO `test` VALUES (4294967295,1095711250141);= = = = = = = = = =On both Linux and OSX: Output from SQL commandselect * from test ;testint 4294967295testbigint 1095711250141Works as it should.= = = = = = = = = =from WebCat 6 Linux RHES 3.0 using select * from test ;Host: localhostServer Version: 4.0.21-standardClient Version: 3.23.58 1 records foundtestint 2147483647testbigint 494589661= = = = = = = = = =from WebCat 6 OSX using select * from test ;Host: localhostServer Version: 4.0.21-standardClient Version: 3.23.58 1 records foundtestint 2147483647testbigint 2147483647-------------------------------------------------------------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/ Jim Lanford

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:

Multiple Hideif peramiters (2001) [WebDNA] client request (2010) Locked files not [REPLACE APPEND=T]ed (2000) Looping control (1997) NT Setup (1998) maximu values for sendmail! (1997) Emailer choke (1997) Updating checkboxes made easy !!! (1998) RequiredFields template (1997) [OT] Any perl gurus out there? (2006) Unable to view next 101-200 (1997) FYI: virus alert (1996) [/application] error? (1997) Fun with dates (1997) looping table rows (1999) WebCat2 beta 11 - new prefs ... (1997) America Online Issues (1998) [WebDNA] Update on WebDNA? (2011) using showpage and showcart commands (1996) Formatting of email on NT (1998)