Hi,
I have a DL module setup for login on my web site. I was hoping to use the Execute SQL Query to perform a lookup immediately after login to then add a variable to the querystring to be available to the page called after login. My stored procedure is being called as expected, but I think this feature is supposed to be used for data creation/update rather than data retrieval. Any thoughts on how I might do something like this?
Again, I need to retrieve a value from a SQL table based upon the UserID of the user who just logged into the system. I thought that I might have a DF on the receiving page that ran a SQL Query upon load to populate a hidden field, but then I would still not be able to access that hidden field from other modules on the page (without writing additional code, which I'm trying to avoid).
Thanks!
Brian