I am working on a solution in 6.0.6. Doing most of my development testing using smart client but some in web client especially when I have to check dialog box stuff as I’m working on a Mac. I’m therefore pretty sure this is something that just came about…
When I login using web client my login/password lets me in to the solution but none of the usual Servoy security functions work. So security.getUserName() for example returns null. Naturally this screws everything up. However in smart client this doesn’t happen at all. Everything is fine. I thought I was almost done and ready to launch this live by the end of the week plus I have a demo tomorrow morning at 11 AM Pacific time. I’m totally bewildered. I tried uploading the solution to the server proper but I get exactly the same behavior: fine in smart, not in web client. If it helps I’ve pasted the output from the servoy-admin pages below although it just seems to be confirming running the same query in both and works in smart but not in web…
Any help would be greatly appreciated!
Here is the web client output (read from bottom up):
Loading messages from server: null table: null
Leave registerClient registered:false in 16 ms
Client (re)registered with id C89577FB-0AE6-435E-872F-EF818DE20443, previous: null
Loading messages from server: null table: null
questiondata[2] = 2 ,type: java.lang.Integer
questiondata[1] = ‘mypassword==’ ,type: java.lang.String
questiondata[0] = ‘mylogin’ ,type: java.lang.String
used sql select user_uid from servoy_users where user_name=? and user_password=? limit ? questiondata.length 3
QuerySet { prepares = , select = select user_uid from servoy_users where user_name=? and user_password=? limit ? [[mylogin,mypassword==,2]] <0^2>, cleanups = }
CUSTOM ELEMENT select user_uid from servoy_users where user_name=? and user_password=? ([mylogin,mypassword==]) FILTER null
Here is the same stuff when logging in via smart client:
used sql select distinct(sg.group_name) from servoy_groups sg,servoy_user_groups sug, servoy_users su where sg.group_id = sug.group_id and sug.user_id=su.user_id and su.user_uid=? order by sg.group_name limit ? questiondata.length 2
QuerySet { prepares = , select = select distinct(sg.group_name) from servoy_groups sg,servoy_user_groups sug, servoy_users su where sg.group_id = sug.group_id and sug.user_id=su.user_id and su.user_uid=? order by sg.group_name limit ? [[1,501]] <0^501>, cleanups = }
CUSTOM ELEMENT select distinct(sg.group_name) from servoy_groups sg,servoy_user_groups sug, servoy_users su where sg.group_id = sug.group_id and sug.user_id=su.user_id and su.user_uid=? order by sg.group_name ([1]) FILTER null
Analysing filters null
sql select CUSTOM ELEMENT select distinct(sg.group_name) from servoy_groups sg,servoy_user_groups sug, servoy_users su where sg.group_id = sug.group_id and sug.user_id=su.user_id and su.user_uid=? order by sg.group_name ([1])
questiondata[2] = 2 ,type: java.lang.Integer
questiondata[1] = ‘mypassword==’ ,type: java.lang.String
questiondata[0] = ‘mylogin’ ,type: java.lang.String
used sql select user_uid from servoy_users where user_name=? and user_password=? limit ? questiondata.length 3
QuerySet { prepares = , select = select user_uid from servoy_users where user_name=? and user_password=? limit ? [[mylogin,mypassword==,2]] <0^2>, cleanups = }
CUSTOM ELEMENT select user_uid from servoy_users where user_name=? and user_password=? ([mylogin,mypassword==]) FILTER null
Analysing filters null
sql select CUSTOM ELEMENT select user_uid from servoy_users where user_name=? and user_password=? ([mylogin,mypassword==])