get the my document path info

Discussion in 'ASP General' started by colleen1980@gmail.com, Mar 23, 2007.

  1. Guest

    Hi: Can any one please tell me how to i get the my document path infor
    of user computer thru ASP code. I try the VB6 code but it dont work
    their?
    Thanks.

    Dim DBConn,rs,social,vpath,vfile
    Dim WShell As Object
    Set WShell = CreateObject("wscript.shell")
    vPath = WShell.SpecialFolders("MyDocuments") & "\"
    Set DBConn = CreateObject("ADODB.Connection")
    DBConn.Open "ODBC; Driver=Adaptive Server Anywhere 6.0;
    DSN=Debtmaster; uid=dm; pwd=,,PeAches..;"
    sSQL = "select name1,ssn1 from dbtr where status_code=450 and
    status_date=today(*) "
    Set rs = DBConn.Execute(sSQL)
    Do While Not rs.EOF
    response.write(rs.Fields("ssn1"))
    response.write("<br>")
    rs.moveNext
    loop
     
    , Mar 23, 2007
    #1
    1. Advertising

  2. <> wrote in message
    news:...
    > Hi: Can any one please tell me how to i get the my document path infor
    > of user computer thru ASP code. I try the VB6 code but it dont work
    > their?
    > Thanks.


    In what way does it not work?
    Where is this code running on the server in ASP or in the Browser on the
    client?

    The server is the wrong place to attempt to file a users personal folder.

    On the client this sort of code will be considered unsafe and be blocked.

    >
    > Dim DBConn,rs,social,vpath,vfile
    > Dim WShell As Object
    > Set WShell = CreateObject("wscript.shell")
    > vPath = WShell.SpecialFolders("MyDocuments") & "\"
    > Set DBConn = CreateObject("ADODB.Connection")
    > DBConn.Open "ODBC; Driver=Adaptive Server Anywhere 6.0;
    > DSN=Debtmaster; uid=dm; pwd=,,PeAches..;"
    > sSQL = "select name1,ssn1 from dbtr where status_code=450 and
    > status_date=today(*) "
    > Set rs = DBConn.Execute(sSQL)
    > Do While Not rs.EOF
    > response.write(rs.Fields("ssn1"))
    > response.write("<br>")
    > rs.moveNext
    > loop
    >
     
    Anthony Jones, Mar 23, 2007
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Vasanth
    Replies:
    0
    Views:
    600
    Vasanth
    Jun 28, 2004
  2. Mupota Muchelemba
    Replies:
    1
    Views:
    951
    Tony Morris
    Feb 4, 2004
  3. ilya

    get CPU info, RAM info

    ilya, Apr 8, 2010, in forum: Java
    Replies:
    43
    Views:
    6,266
    Mike Schilling
    Apr 19, 2010
  4. MAX
    Replies:
    7
    Views:
    241
    A. Sinan Unur
    Dec 21, 2005
  5. qwweeeit

    Get info from another document

    qwweeeit, Jul 7, 2006, in forum: Javascript
    Replies:
    0
    Views:
    78
    qwweeeit
    Jul 7, 2006
Loading...

Share This Page