Welcome to Dream.In.Code
Getting Help is Easy!

Join 136,094 Programmers for FREE! Get instant access to thousands of experts, tutorials, code snippets, and more! There are 1,605 people online right now. Registration is fast and FREE... Join Now!




CFEclipse: "Attribute not valid"

 
Reply to this topicStart new topic

CFEclipse: "Attribute not valid"

bruce779
16 Nov, 2007 - 08:06 AM
Post #1

New D.I.C Head
*

Joined: 29 May, 2007
Posts: 16



Thanked: 1 times
My Contributions
Hi folks.
I'm hoping someone can cast a quick eye over this fragment and tell me if they can see anything wrong with it.

It is part of a conditional check I have within and INSERT statement.
The argument 'saveDetails.cat_id' has been correctly passed in and the function getIdByCode has also been correctly passed in. The attributes for the function, match, table and column are also being used here correctly (i think)
According the data in the DB this section should return 'true' but I am getting an error on all three function attributes saying they are not valid.

Any help would be much appreciated.

CODE
<cfif arguments.saveDetails.cat_id eq #getIdByCode(match = 'C+1', table = 'cen_categories', column = 'code')#>


p.s. If you need to see more code leave a message and i wlkl post more on monday when i am back at work icon_up.gif
User is offlineProfile CardPM
+Quote Post

ajwsurfer
RE: CFEclipse: "Attribute Not Valid"
10 Dec, 2007 - 12:10 PM
Post #2

D.I.C Regular
Group Icon

Joined: 24 Oct, 2006
Posts: 292



Thanked: 2 times
Dream Kudos: 50
My Contributions
If
"getIdByCode(match = 'C+1', table = 'cen_categories', column = 'code')"
produces a valid scalar value, I don't see why it would need the pound signs around it in the cf conditional statement.

I would try to print both values out to the browser using:
CODE

  <cfset temp = getIdByCode(match = 'C+1', table = 'cen_categories', column = 'code')>
  <cfoutput>
    arguments.saveDetails.cat_id: #arguments.saveDetails.cat_id#<br />
    temp: #temp#<br />
  </cfoutput>


User is offlineProfile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic
Time is now: 12/1/08 08:27PM

Live Help!

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month