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:

What about this [delete] situation? (1998) accountnum using [listwords] (2001) This list needs a digest: rant, rave... (1997) [writefile] (1997) (2000) Search in 2 or more catalogs (1997) notification solutions (1997) RE: E-mailer error codes (1997) WebCatalog 2.0 & WebDNA docs in HTML ... (1997) date (1999) [WebDNA] FileUpload (2014) [protect] on NT? (1997) searching with if/then (2004) RE: Netscape v. IE (1997) Test (2006) WebCatalog dying in WebTen Revisited (1998) indexing dates (1998) 2cd pair of eyes (2003) MasterCounter and capitalization (1997) too many nested tags ... (1997)