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
______________________________________________________________________
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.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
