Interesing. I really can't wait for the stable release of MySQL 5.x. Although I have the latest beta on my localhost, our production server runs on the Generally Available (GA) 4.x version. Thank you for pointing me in the right direction. While exploring the INFORMATION_SCHEMA db, I'll also explore if I can also apply it to the MYSQL db.
Again, thank you Jochem! [ simon.cpu ] >Jochem van Dieten wrote: >On second thought you can do it as a 2-step process (MySQL > >5.02). First you get the name of the column from the information >schema, then you can manipulate it in a second query: > >SELECT COLUMN_NAME >FROM INFORMATION_SCHEMA.COLUMNS >WHERE table_name = <cfqueryparam value="#tbl_name#"> > AND table_schema = <cfqueryparam value="#db_name#"> > AND ordinal_position = <cfqueryparam value="#N#"> > >Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207729 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
