Isn't usertype the name of your query record set? Here you are setting request.usertype equal to your entire record set (or you would be if you went without the quotes and hashes.
Request.UserType = "#UserType#"; Perhaps you want... Request.UserType = UserType.usertype[1]; Matthew Walker Electric Sheep Web http://www.electricsheep.co.nz/ ----- Original Message ----- From: "Bruce Sorge" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 11, 2003 8:25 AM Subject: MX Error > I am receiving this error on a CFMX site. > > You have attempted to dereference a scalar variable of type class java.lang.String as a structure with members > > The section of code that it does not like is this piece that is wrapped inside a cfscript tag: > > if (UserType.RecordCount NEQ "0") { > Request.UserType = "#UserType#"; > } > else { > Request.UserType = "Clinical"; > } > > > > I am not sure what the deal is. > > > > TIA, > > > > Bruce > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
