[cfaussie] RE: mirgation code issues

Thu, 04 Dec 2003 19:56:42 -0800

<CFIF isDefined("URL.RecordID")>

 WHERE Talent.ID = #URL.RecordID#

 </CFIF>

 

Trent Shepherd

SeaSpray technology & design

cell: 0412 245 212

phone:4285 8793

email: [EMAIL PROTECTED]

web: www.seaspray.net

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Friday, 5 December 2003 1:32 PM
To: CFAussie Mailing List
Subject: [cfaussie] RE: mirgation code issues

 

 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 -----

From: Adam Chapman

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

Reply via email to