Douglas, I also tried replacing the #run_query# with a varchar directly. also look at my other post, where I tried to put the entire sp (including parameters) run from a <cfquery>, didn't work. and it works great in query analayzer!
weird. ----- Original Message ----- From: "Douglas Brown" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, March 03, 2002 12:36 AM Subject: Re: problems with storedproc > Well since you are using an "IN" have you tested if #run_query# is > defined? That is the only thing I can think of that would give a "" > value in your code. > > > "Success is a journey, not a destination!!" > > > > Doug Brown > ----- Original Message ----- > From: "Jason Davis" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Saturday, March 02, 2002 12:53 PM > Subject: problems with storedproc > > > > I'm using something simple like this tored procedure: > > > > <cfstoredproc procedure="Catalog" datasource="Products"> > > <cfprocresult name="Query_Results"> > > <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" > dbvarname="@sql" > > value="'#Run_Query#'" null="No"> > > </CFSTOREDPROC> > > > > And getting a weird error: > > > > [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot use empty object > > > or column names. Use a single space if necessary. > > > > > > > ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
