[cfaussie] RE: mirgation code issues

[Steve Onnis]

should be   <CFIF isDefined("URL.RecordID")>  WHERE Talent.ID = #URL.RecordID#  </CFIF>   If you have isDefined(URL.RecordID) the function will try to evaluate the variable and use that value to check if its defined.  You need to be passing in a string like isDefined("URL.RecordID")   Steve -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED] Sent: Friday, December 05, 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 To: CFAussie Mailing List 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