Doesnt make much sense does it? What about using "query_result" I know each version of CF has had different reserved words, not sure if "query" is one of them. Thats about the end of my thoughts.
"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 2:42 PM Subject: Re: problems with storedproc > 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. > > > > > > > > > > > > ______________________________________________________________________ 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
