Try using the just the Stored Procedure Name without the table name. i.e. sp_SpaceUsed
This will return the results required for each data source against which it is called. Conrad -----Original Message----- From: Simon Horwith [mailto:[EMAIL PROTECTED]] Sent: 23 June 2002 01:00 AM To: CF-Talk Subject: RE: sp_SpaceUsed system stored procedure... So far... I'm finding that I can call SP's using the ODBC {call sp (params)} syntax.... but when I have to pass string data as arguments to the SP, CFQUERYPARAM is required to make it work. I haven't been able to find any consistency as to when I must use cfqueryparam and when it's not required. In the event that I need to use cfqueryparam and don't, the SP is stilll called and no error is returned, but neither is any recordset. This is with SQL Server 2000 SP2. Our CEO, Steve Drucker, has reportedly tested calling SP's in this manner against SQL Server 7 without error. He also didn't mention having to use cfqueryparam at all.... but I really don't know exactly what the sp's he ran looked like. ~Simon Simon Horwith Macromedia Certified Instructor Certified Advanced ColdFusion 5 Developer Fig Leaf Software 1400 16th St NW, # 500 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 22, 2002 18:02 To: CF-Talk Subject: RE: sp_SpaceUsed system stored procedure... > using cfmx and this query > > <cfquery name="GetDbaseData" datasource="Reports"> > sp_SpaceUsed Reports > </cfquery> > > to get the database usage stats for the reports database, > returns nothing. is there somethin in cfmx that inhibits > system stored procedures from running correctly? when i try > to get any of the results, nothing shows up? same query > ran in query analyzer, gives me exactly what i am looking for. I don't think that you can call stored procedures with CFQUERY and have those procedures return recordsets in CF MX. That functionality relied on specific ODBC client functionality in previous versions of CF, I think. You should be able to call it with CFSTOREDPROC. This is kind of a bummer, though, because you can't cache recordsets retrieved via CFSTOREDPROC using the CACHEDWITHIN/CACHEDAFTER stuff ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
