In my experience order matters even with CFSTOREDPROC, I have not tested
the limits of Stored procedures but I have an ASP page that passes 109
values and inserts data to 6 tables that works fine. Even there I user the
order that is in the SP it makes finding things easier.
At 11:56 AM 12/18/00 -0800, you wrote:
>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
