When inserting multiple rows of literal data, instead of: INSERT INTO Table (X) VALUES (1); INSERT INTO Table (X) VALUES (2); Etc, Etc....
You can just do: INSERT INTO Table (X) VALUES (1), (2), Etc, Etc..... I learn new things every day, but rarely shortcuts that are this basic! Anyway, you all probably already knew about this, but I thought it was cool, and it instantly makes my life easier! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:332282 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
