When you turn on debeugging, what do you show for URL parameters being
passed?
----- Original Message -----
From: "Ray, James A" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 27, 2000 10:51 AM
Subject: Wierd Query Error
> 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_talk 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.
