Got it. Look at the bottom.
At 08:51 AM 7/27/00 -0700, you 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
It thinks that pressurename is included in the value of enditempn. Make
your query string enditempn=#enditempn#&pressurename=#pressurename#
------------------------------------------------------------------------------
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.
