SEO

#1 (**permalink**) 03-20-2008, 12:47 PM

Hello,

is it possible to access a session variable from inside an UDF?
Or as a more general case: is it possible to issue a query on the server
with the context of the current user? (I cannot use the mysql c-lib
because i need to know a user/password to let the udf connect to the own
server)

Thanks for your answers,

Dennis

#2 (**permalink**) 03-20-2008, 12:47 PM

Dennis Birkholz wrote:
> Hello,
>
> is it possible to access a session variable from inside an UDF?
> Or as a more general case: is it possible to issue a query on the server
> with the context of the current user? (I cannot use the mysql c-lib
> because i need to know a user/password to let the udf connect to the own
> server)
>
> Thanks for your answers,
>
> Dennis
>

You can pass the session variable as a parameter to the UDF. But the
UDF runs under a MySQL process, not your web server's process, and
cannot access anything from the server not passed to it.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Access a session-variable (@xyz) from an UDF