Is 'case number' from another query? if so, you could reference it via #queryname['case number'][curRow]#
Jerry Johnson Lawyersweekly.com >>> [EMAIL PROTECTED] 12/13/01 02:39PM >>> Ok here is the deal. I have an excel file. I can query through it no problem. I have to take results and update a SQL database. Again no problem. Except some of the field names in the excel file have spaces. We receive this file from another party so we can't remove the spaces from the file. Can we 1. rename the field names in excel and remove the spaces that way? or 2. Somehow convert it during the query so it will work. Example: <CFQUERY> UPDATE TABLE SET CASENUM = '#CASE NUMBER#' WHERE WHATEVER = WHATEVER </CFQUERY> It errors out at NUMBER because of the space. Any suggestions? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
