I tried also running inside a <cfquery>
<cfquery ... ...>
mystoredprodure 'param1',param2,param3
</cfquery>
still, same error. the weirdset thing is that exactly the same code
("mystoredprodure 'param1',param2,param3") work perfectly
in query analazyer (sql enterprise manager)
help?
----- Original Message -----
From: "Jason Davis" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, March 03, 2002 12:17 AM
Subject: Re: problems with storedproc
> 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.
> > >
> > >
> > >
> >
>
______________________________________________________________________
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
