I may be in the running for today's dumbs**t question. I totally forgot to create the DSN when I moved the site. Sorry for the wasted bandwidth. ----- Original Message ----- From: "Matthew Walker" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, March 10, 2003 1:36 PM Subject: Re: MX Error
> 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
