> Getting an error, any ideas > Here is the top 2 items
> client_first_name > co_client_first_name > Error Diagnostic Information > ODBC Error Code = 37000 (Syntax error or access > violation) > [Microsoft][ODBC SQL Server Driver][SQL Server]Line > 4: Incorrect syntax > near 'co_client_first_name'. Do this: <cfoutput> CREATE TABLE mynewtable ( <cfloop index="x" from="1" to="#listlen(myvariable,CHR(13))#"> #listgetat(myvariable,x,CHR(13))# varchar(8000) <cfif x gt 1>,</cfif></cfloop> ) </cfoutput> And copy and paste the results into a reply on this thread -- maybe I screwed up the syntax somehow... Isaac www.turnkey.to 954-776-0046 ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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
