---------- Original Message ----------------------------------
From: "Bruce Sorge" <[EMAIL PROTECTED]>
>You have attempted to dereference a scalar variable of type class java.lang.String as
>a structure with members
>
>if (UserType.RecordCount NEQ "0") {
> Request.UserType = "#UserType#";
> }
>else {
> Request.UserType = "Clinical";
> }
My guess is that you want Request.UserType to be a string ("Clinical" or some other
string). However, it appears that UserType is a query [based on 'if
(UserType.Recordcount NEQ "0")'], so when you say 'Request.UserType = "#UserType#";'
you're setting Request.UserType to be the entire query, and not a string. Assuming
the returned recordset of UserType has a field called "usertype", try this code:
if (UserType.RecordCount) {
Request.UserType = UserType.usertype;
}
else {
Request.UserType = "Clinical";
}
If that's not what you're looking for, reply with more details and Ill see if I can
help you.
Scott
--------------------------------
Scott Brady
http://www.scottbrady.net/
>
>
>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
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
