this is where i got the SP.. http://vyaskn.tripod.com/code.htm#inserts
erj On 9/30/05, Steve Bryant <[EMAIL PROTECTED]> wrote: > 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?? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219800 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
