>>Any suggestions? 1. never use space or special characters in any table or especially column names. Column names are used as variable names in CF and most languages using queries, so better use table and column names compatible with the syntax of the language handling the query. 2. use [...] around table and column names; 3. use aliases to rename the columns so that they can be handled properly by the language, ie: SELECT [poorly named column] AS correctlyNamedColumn FROM [poorly named table]... 4. consider redesigning your db anyway and go back to 1! ;-)
-- _______________________________________ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237845 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
