Ahh... I see. It looks like order matters. Using <cfstoredproc>, order was
not supposed to matter. But I found that the <cfprocparam> tags needed to be
in the same order as they were referenced in the SP; not in every case, but
enough times to matter. You should be able pass the params in any order
because they are named. To this day, I'm not sure if it was ODBC or SQL
Server 7.0 itself, or the data types of the params I was passing.
Is there a limit to the number of params you can pass? Using <cfstoredproc>
to execute an insert, I have passed 60 to 70 parameters. It sounds like a
lot and it was. It was a nightmare trying to debug something wrong with the
insert.
---
Jeffrey B. Marsh
professionals built the Titanic; amateurs built the Ark
-----Original Message-----
From: Michael 'Maxx' Porter [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 18, 2000 11:32 AM
To: Fusebox
Subject: RE: query caching (was dot notation)
not tricky I just thought I has some code for it but could not find it for
a til now..
<CFQUERY DATASOURCE=--->
{CALL spname(param1,param2)}
</CFQUERY>
At 11:04 AM 12/18/00 -0800, you wrote:
>The params are the tricky part, huh? I use SPs to insert records, so the
>prams are necessary. I would like to see how you do this. Thanks.
>
>---
>Jeffrey B. Marsh
>professionals built the Titanic; amateurs built the Ark
>
> -----Original Message-----
>From: Michael 'Maxx' Porter [mailto:[EMAIL PROTECTED]]
>Sent: Monday, December 18, 2000 10:49 AM
>To: Fusebox
>Subject: RE: query caching (was dot notation)
>
>I can not find the code for adding prams just yet but here is the code
>without prams.
>
><cfquery name="qu_name" datasource="#APPLICATION.SQL_server#" dbtype="ODBC"
>cachedwithin="#CreateTimeSpan(0, 1, 0, 0)#">
>{call sp_name}
></cfquery>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
