Yes it is, anyhow I tried without it and it gave same error.
> It looks to me like you have ' ' in your value="'#Run_Query#'" is that > needed? > > > > > "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
