also, I have tried to make a Datasource for the "Master" database, where the actual sp_SpaceUsed stored procedure resides, to no avail, still doesn't work. no records.
very strange. tony -----Original Message----- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 23, 2002 12:46 PM To: CF-Talk Subject: RE: sp_SpaceUsed system stored procedure... 100% in cf5! very odd that it doesnt work now.... tony -----Original Message----- From: Chris Kief [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 22, 2002 5:25 PM To: CF-Talk Subject: RE: sp_SpaceUsed system stored procedure... Has this worked before under CF5? I have always used the <cfstoredproc> and <cfprocparam> tags when calling stored procedures. Chris -----Original Message----- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 22, 2002 1:43 PM To: CF-Talk Subject: sp_SpaceUsed system stored procedure... hi there. 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. very odd.... tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
