using sql statment in ASP

Results 1 to 2 of 2

Thread: using sql statment in ASP

  1. #1
    Join Date
    Dec 1969

    Default using sql statment in ASP

    firstly i don&#039;t know how to send msg on the Beginner-level ASP Questions that why i will send my question here.<BR><BR>i have three tables users,u_link and link so i did the sql statment for the ASP like this:<BR><BR>set rs_link = x.execute("select users.userid,u_link.linkid,username,direct, scription from users,link,u_link WHERE users.userid = u_link.userid AND link.linkid = u_link.linkid")<BR><BR>and iam trying to check if its the right way to write a sql statment on the ASP pages coz its not working with me. <BR>thanks for your time <BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: using sql statment in ASP

    Dim con, rst, strSQL<BR>Set con = Server.CreateObject("ADODB.Connection")<BR>con.Ope n "DSN"<BR>strSQL = "SELECT * FROM table where ID=5"<BR>Set rst = Server.CreateObject("ADODB.Recordset")<BR>rst.Open strSQL, con, 3, 3<BR>

Posting Permissions

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