|
Note
the double quotes...
<CFIF isDefined("URL.RecordID")>
WHERE Talent.ID = #val(URL.RecordID)#
</CFIF>
Hi
adam
thanks for the direction
i updated but now getting a new
error.
the current link to this page is just <a
href="">
and runs this code
<CFQUERY name="GetRecord" datasource="interacttalent"
maxRows=1>
SELECT Talent.talentID AS ViewField1, Talent.Name
AS ViewField2, Talent.Gender AS ViewField3, Talent.DOB AS ViewField4,
Talent.Hair AS ViewField5, Talent.Eye AS ViewField6, Talent.Height AS
ViewField7, Talent.Clothessize AS ViewField8, Talent.shoesize AS
ViewField9, Talent.hobbies AS ViewField10, Talent.BIO AS ViewField11,
Talent.Compcard AS ViewField12, Talent.ID AS ID_Field
FROM
Talent
<CFIF
isDefined(URL.RecordID)>
WHERE Talent.ID =
#URL.RecordID#
</CFIF>
</CFQUERY>
Element RECORDID is
undefined in URL. |
|
| |
The error occurred in
D:\WebSpace\interact\admin\DrillDown_RecordView.cfm: line
23
|
21 : SELECT Talent.talentID AS ViewField1, Talent.Name AS ViewField2, Talent.Gender AS ViewField3, Talent.DOB AS ViewField4, Talent.Hair AS ViewField5, Talent.Eye AS ViewField6, Talent.Height AS ViewField7, Talent.Clothessize AS ViewField8, Talent.shoesize AS ViewField9, Talent.hobbies AS ViewField10, Talent.BIO AS ViewField11, Talent.Compcard AS ViewField12, Talent.ID AS ID_Field
22 : FROM Talent
23 : <CFIF isDefined(URL.RecordID)>
24 : WHERE Talent.ID = #URL.RecordID#
25 : </CFIF>
|
----- Original Message -----
Sent: Friday, December 05, 2003 12:26 PM
Subject: [cfaussie] RE: mirgation code issues
Hmmm.. Here is my post again.. Now with a new
Email
subject..
Hi Greg,
>> <CFIF
ParameterExists(URL.RecordID)>
>> WHERE Talent.ID =
#URL.RecordID#
>> </CFIF>
I'm not on MX as yet *sigh*
but I have a feeling
The parameterExists function may no longer
Be
supported in MX..
Replace it with
<CFIF
isDefined("URL.RecordID")>
WHERE Talent.ID =
#URL.RecordID#
</CFIF>
Also it may pay to use cfqueryparam on
your
Query variables for some extra
security..
Cheers,
Adam
---
You are currently subscribed
to cfaussie as: [EMAIL PROTECTED]
To
unsubscribe send a blank email to
[EMAIL PROTECTED]
MXDU2004
+ Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February,
2004
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a
blank email to [EMAIL PROTECTED]
MXDU2004
+ Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To
unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney,
Australia
http://www.mxdu.com/ + 24-25 February, 2004
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
|
