Select CVAL('Database') From Table Where Limit=1
I then assigned and placed a local variable <@Assign local$DBname Value='<@COL Num=1>'>
My Database is :@@local$DBname,
Thanks again!
Brian Mowers
At 01:06 AM 2/5/2003 -0500, you wrote:
At 05:17 PM 2/4/2003 -0500, Brian Mowers wrote:
>Is there a way to find the Database that is servicing a
>given select command? I have one application servicing
>two databases based on the url used to start the web
>application. I would like to know which database the
>application is currently servicing. Is there something
>I can load into a variable in results HTML?
Brian,
You can certainly use the power of CVAL Functions,
including (CVAL('Database')).
(CVAL('Database')) will return a text string containing the
currently connected database.
Of course, you can use DBMS action to achieve that
result.
Hope that helps!
Very Best Regards,
Razzak.
[EMAIL PROTECTED]
