Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Location
    Vietnam
    Posts
    188

    Unanswered: how to get current user name to a variable

    Anybody can please tell me how to get the current user name (the user name that is logging in to mysql server) into a variable using vb?

    many thanks
    qha_vn

  2. #2
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320

    Re: how to get current user name to a variable

    Originally posted by qha_vn
    Anybody can please tell me how to get the current user name (the user name that is logging in to mysql server) into a variable using vb?

    many thanks
    You can use

    Code:
    select user();
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  3. #3
    Join Date
    Jan 2003
    Location
    Vietnam
    Posts
    188
    thanks for the advise, but can you pls be more in details? i 'd like to set the user name to a variable, how can i do this with SELECT user() statement in Visual Basic

    thanks again
    Last edited by qha_vn; 06-29-03 at 23:04.
    qha_vn

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •