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.
