Using the login.cgi and WIN32::ODBC Module of ActivePerl, I have been able to synchronized the login option of my web page with UBB. How? Once the user is logged in once they select the FORUM option, I use the URL to pass action=login and a session id. In the login.cgi, I then use WIN32::ODBC to activate the SQL Server and retrieve the user name and password from the user table and session table. The login.cgi script validate the data and gives the user access.

However I have a problem. I wish to now synchronize the Registration and Profile option. For security reasons, I do not want to use the FORM or URL to send the user information across. However the sub routine in ubbmisc.cgi is expecting the variables (user name, etc) to be loaded into the associate array(%in) via the query string.

Use WIN32::ODBC, I am able to retrieve the required data and define them as scalar variables, eg $user_name. But how do I loaded them into %in. Should I use
eg. $in{'user_name'} = "$user_name', etc.

I tried to resolve this problem by creating a new script and use scalar variables instead of associate array, but is as if Perl cannot find the script.

Could anyone tell me how to resolve this problem, using either method?