Usually when I see "COMPUTED_COLUMN_1" it means that I have a calculated column in my query that doesn't tie directy to a field in a table (and for which I failed to use an alias).
Without seeing the source of the stored-proc, I couldn't say much more than that, but hopefully that might point you in the right direction. Steve Steve Bryant. Bryant Web Consulting LLC http://www.BryantWebConsulting.com/ http://steve.coldfusionjournal.com/ >Ok i have a SQL 2000 Stored Procedure which generates insert >statements for me. When i run the cfquery tag to execute this SP it >returns back X rows of data. > >When i cfdump the query VAR i see all the records but the column name >is called "COMPUTED_COLUMN_1" > >When i try to CFLOOP over this query and referance it as >#myquery.COMPUTED_COLUMN_1# i get an error telling me there is an >error in my insert script. > >I figured out the error was because CF was inserting extra single >quotes so i wrapped my var in PreserveSingleQuotes() and now i get the >error: >The system has attempted to use an undefined value, which usually >indicates a programming error, either in your code or some system >code. >Null Pointers are another name for undefined values. > >Here's my code: ><cfquery name="q_grabSourceContent" datasource="master#getSourceServer()#"> > USE #getSourceDB()# > EXEC sp_generate_inserts #getSourceTableName()#<cfif >IsDefined('arguments.ignoreFields') AND >Len(Trim(arguments.ignoreFields))> @cols_to_exclude = >#ignoreFields#</cfif> ></cfquery> > ><cfloop query="q_grabSourceContent"> > <cfquery name="q_grabSourceContent" >datasource="master#getDestinationServer()#"> > USE #getDestinationDB()# > #PreserveSingleQuotes(q_grabSourceContent.COMPUTED_COLUMN_1)# > <!--- >error here ---> > </cfquery> ></cfloop> > >thougts?? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219793 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

