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 ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
