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
