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
