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:

free "Image Viewer" widget (2004) What file? (1997) New command suggestion (was Modifying databases manually) (1997) Does ".tpl" index with SE's? (2003) available times? (2003) Protecting webdelivery (1997) Content-type:... (2000) WebCatalog for Postcards ? (1997) [IPAddress] and AutoProxy (1998) Serious bug writing to a database ... (2002) [shownext] and descending order (1997) [WebDNA] Replace / Append only unique data (2013) WebCat2_Mac RETURNs in .db (1997) WSDL Web services design wizard (2005) [WebDNA] Chrome 56 character encoding (2017) Summary search -- speed (1997) Sample Tearoom Search Error (1998) tcpconnect/tcpsend frustrations (2002) [SearchString] problem with [search] context (1997) Multiple Pulldowns (1997)