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

Reply via email to