Hi,
I have a small piece of code in the "processlink" embed to load the glo:dbowner variable.
This is to enable different users to connect to seperate DB's
The site is still quite simple with only a few pages, but on a specific page it seems as if the values in the session queue is blank, this then loads the master connection string again, and then everything falls over.
If I keep navigating the site it sorts itself out and finds the session queue values again on subsequent pages.
As if the session queue record retrieval failed in certain instances.
This has been working fine, but somewhere something has gone wrong.
I have added some debug code of my own to try and understand what is going wrong and was wondering if there is any error code check I can add to
confirm p_web.GSV() success or not?
p_web._trace('session_ID =' & p_web.sessionid)
! >>>>>> the login_status is set on the login screen, 1=valid, 0 or space = not logged in
! >>>>>> if logged in then I set the connection string to the string for that specific user
! >>>>>> else, I set the string to the master DB that is the default DB this also contains the master file with companies and users
if p_web.GSV('login_status') = '1'
glo:dbowner = p_web.GSV('dbowner')
else
glo:dbowner = 'Driver=PostgreSQL ODBC Driver(UNICODE); server=localhost; UID=demo; PWD=demo; database=wfmaster; PORT=5432;'
end
p_web._trace('yyy_session-DBOwner =' & p_web.GSV('dbowner') )
p_web._trace(p_web.GSV('login_status') & ':DBOwner =' & glo:dbowner )
thanks in advance for any ideas
Johan