> Run the following in MySQL and please show us the result: > CREATE TABLE testTable (testField DECIMAL(4,2)); > INSERT INTO testTable (testField) VALUES (1.1); > INSERT INTO testTable (testField) VALUES (22.22); > INSERT INTO testTable (testField) VALUES (333.333); > INSERT INTO testTable (testField) VALUES (4444.4444); > INSERT INTO testTable (testField) VALUES (55555.55555); > SELECT * FROM testTable;
mysql> select * from testtable; +-----------+ | testField | +-----------+ | 1.10 | | 22.22 | | 333.33 | | 999.99 | | 999.99 | +-----------+ 5 rows in set (0.00 sec) ------- Wow, MySQL is *really* good at rounding! Thanks - you learn something new every day. - Jim -----Original Message----- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 5:32 PM To: CF-Talk Subject: Re: Access to MySQL Migration Jim Campbell wrote: > Transactions and foreign keys are available in MySQL by using the InnoDB > engine. But the OP said MyISAM. > Subqueries might be "doable" via a workaround, be it through > more complex joins, CF QoQ's or a mixture of the two (Don't know about > the performance hit, though). Some subqueries can be rewritten, others not. > Is the "decimal" data type that different from MySQL's "double"? Run the following in MySQL and please show us the result: CREATE TABLE testTable (testField DECIMAL(4,2)); INSERT INTO testTable (testField) VALUES (1.1); INSERT INTO testTable (testField) VALUES (22.22); INSERT INTO testTable (testField) VALUES (333.333); INSERT INTO testTable (testField) VALUES (4444.4444); INSERT INTO testTable (testField) VALUES (55555.55555); SELECT * FROM testTable; > I also thought NOT NULL was supported. I guess > I'll have to go home and try it now... :) The default value will be inserted instead of the record being rejected. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
