odd. with cf5 i have never had any problem with sp's and cfquery
tag. in fact, i have probably 30 of them that get hit over 2000 total.
and none run into any problems. even now with cfmx. i can still run
them against my MSSQL Advanced 2000 SQL Server, like this one below...
<cfquery name="SomeName" datasource="SomeDatasource">
exec sp_Navtrak_Vehicles 39
</cfquery>
however when i try the "System Stored Procedure" "sp_SpaceUsed"
it doesnt return anything.
thats the oddity. regular sp's that i have made are 100% ok
and work with cfmx, its just the sys. stored. proc's that are
buggin?
tw
-----Original Message-----
From: Simon Horwith [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 22, 2002 7:00 PM
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.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
______________________________________________________________________
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
