Just figured it out ... I changed the query columname to thisSecurity (as opposed to security) and it seemed to fix the problem .. This worked in v5.0 but not CFMX ...
Thanks for those who may be replying! Paul Giesenhagen QuillDesign ----- Original Message ----- From: "Paul Giesenhagen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, September 24, 2002 3:12 PM Subject: CFMX > Question about CFMX. I am running a query to find various security settings for a particular user and whatever settings the query finds, I am setting those values into a struct names "security" could this be a big problem? Is that a reserved word in CFMX? > > (Running Linux/CMFX/MySQL) > > Here is the error I am recieving: > > You have attempted to dereference a scalar variable of type class coldfusion.sql.QueryColumn as a structure with members. > > Here is the code that I am using: > > <cfset security = StructNew()> > <cfloop query="getSecurity"> > <cfset "security.#getSecurity.security#" = 1> > </cfloop> > > <cflock timeout="20" throwontimeout="No" type="EXCLUSIVE" scope="SESSION"> > <cfset session.security = security> > </cflock> > > > Thank You > Paul Giesenhagen > QuillDesign > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
