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. > > > ______________________________________________________________________ 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=coldfusiona 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
