Results 1 to 2 of 2

Thread: ASP and SQL

  1. Jul 13th, 2003, 06:03 PM #1
    RhYnOsT
    RhYnOsT is offline

    Thread Starter
    New Member
    Join Date
    Jul 2003
    Posts
    13

    Question ASP and SQL

    Hey im trying to design a log in type page with an access database and im trying to put a variable into the SQL statement and its not letting me do it

    dim mySQL
    mySQL = "SELECT * FROM USERS WHERE USERNAME='" & Request.Form("username") & "'"
    set recordCollection=connectionToDatabase.Execute(mySQL)
    connectiontodatabase.


    any help???
    rhynost
    Reply With Quote Reply With Quote
  2. Jul 15th, 2003, 07:33 PM #2
    PT Exorcist
    PT Exorcist is offline
    yay gay PT Exorcist's Avatar
    Join Date
    Apr 2002
    Location
    . . . my reason of shame
    Posts
    2,729
    it doesnt work that way! you have to first of all create a sqlconnection type and then if you want to use mssql create a sqlcommand and bind it to the sqlconnection thru the CreateCommand().
    \m/\m/
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width