That's not a query error, you don't have #URL.PRESSURENAME#
defined... just as the error message says.
put
<CFOUTPUT>
<BR>URL.PRESSURENAME...|#URL.PRESSURENAME#|
</CFOUTPUT>
before your query & you'll see!
HTH
Dick
At 8:51 AM -0700 7/27/00, Ray, James A wrote:
>CAn anyone tell me if there is something wrong with this statement? I can
>not find anything wrong with it, unless CF does not support multi parms
>(which I doubt).
>
>Thanks for the help.
>
><cfquery name="getRecord" datasource="DSTS" maxrows=1>
> SELECT ENDITEMPN, PRESSUREHIREQTS, PRESSURELOREQTS, PRESSURENAME
> FROM DSTS.PRESSURE_REQTS
> <CFIF ParameterExists(URL.ENDITEMPN)>
> WHERE (ENDITEMPN = '#URL.ENDITEMPN#' ) AND (PRESSURENAME =
>'#URL.PRESSURENAME#' )
> </CFIF>
> ORDER BY ENDITEMPN,PRESSURENAME
></cfquery>
>
>
>ERROR
>
>Error Diagnostic Information
>Error resolving parameter URL.PRESSURENAME
>The specified URL parameter cannot be found. This problem is very likely due
>to the fact that you have misspelled the parameter name.
>The error occurred while evaluating the expression:
>#URL.PRESSURENAME#
>The error occurred while processing an element with a general identifier of
>(#URL.PRESSURENAME#), occupying document position (13:98) to (13:115).
>Date/Time: 07/27/00 08:34:22
>Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
>Remote Address: 129.200.234.120
>Template: e:\Inetpub\wwwroot\vsts\Pressure.cfm
>Query String: ENDITEMPN=1B89037%20AND%20PRESSURENAME=Another%20Name
>
>
>
>
>Jim Ray
>
>
>
>
>------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_tal
>k or send a message to [EMAIL PROTECTED] with
>'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
