Find the Key!

Page 1 of 3 123 LastLast
Results 1 to 10 of 24

Thread: Find the Key!

  1. #1
    Nathan Masek Guest

    Default Find the Key!

    Can I find out what the key field of an Access DB is by using ASP?

  2. #2
    Join Date
    Dec 1969

    Default SQL, Not ASP


  3. #3
    Join Date
    Dec 1969

    Default RE: Find the Key!

    &#060;%<BR>Dim cn<BR>Dim strSQL<BR>Dim rs<BR>Set cn = Server.CreateObject("ADODB.Connection")<BR>cn.Open YourConnectString<BR>strSQL = "select KeyField from AccessDBtable"<BR>set rs = conn.execute(strSQL)<BR>response.write rs("KeyField")<BR>rs.close<BR>cn.close<BR>set rs = nothing<BR>set cn = nothing<BR>%&#062;

  4. #4
    Nathan Masek Guest

    Default hehe ....

    Yeah ... SQL

  5. #5
    Join Date
    Dec 1969

    Default If you used your brains

    He was trying to figure WHICH the key feild was in ASP :P<BR><BR>Hand in your cloak captain and wear your underwear INSIDE your pants from now on<BR><BR>Brain Power.

  6. #6
    Join Date
    Dec 1969

    Default Check out the ADO docs.<BR>This will tell ya how to find it.

  7. #7
    Join Date
    Dec 1969
    Los Angeles, CA

    Default HEY "DealBackouter"

    what happened to your site??<BR><BR>

  8. #8
    Join Date
    Dec 1969

    Default Openschema

    You can use the openschema method<BR><BR>set rs = connection.openschema(28)<BR><BR>You better check the docs at MSDN as I&#039;m not sure aboute the right value for gettinng the primary keys.

  9. #9
    Cap'n O Guest

    Default Bite me

    Whooooosh!<BR><BR>(The sound of my humor going over your head)

  10. #10
    Kristin Hedge Guest

    Default Are you for real?

    SQL *IS* one of the components of ASP.

Posting Permissions

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