It looks correct. What sort of form element was URL.PRESSURENAME? If it is
a Checkbox or a Radio button, no parameter is passed if the user selects
nothing.
BTW, if I remember correctly, ParameterExists() is deprecated and you should
use IsDefined() instead.
Dana Larose
Software Engineer
Canadian Web Design & Consulting Inc.
A: 701-281 McDermot Avenue (McDermot & King)
P: 204-946-5155
C: 204-228-0477
F: 204-946-5156
E: [EMAIL PROTECTED]
W: http://www.cdnwebdesign.com
-----Original Message-----
From: Ray, James A [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 27, 2000 10:52 AM
To: [EMAIL PROTECTED]
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.
