Access Query Error. What's the prob?

Results 1 to 3 of 3

Thread: Access Query Error. What's the prob?

  1. #1
    Join Date
    Dec 1969
    Posts
    1,388

    Default Access Query Error. What's the prob?

    UNqryVar = Request.Form("UserName")<BR><BR>SQLprof = "SELECT * FROM UserInfo WHERE user_name =&#039& UNqryVar &&#039"<BR><BR>I&#039m using the UNqryVar to select a username so I can display that users info, but when the script executes I get this error.<BR><BR>ADODB.Field error &#039 800a0bcd&#039 <BR><BR>Either BOF or EOF is True, or the current record has been deleted; the operation requested by the application requires a current<BR>record. <BR><BR>I know the value is being transfered via the form, but I don&#039t think I&#039m calling it properly in the SQL statement that&#039s why it says BOF / EOF. There&#039s nothing there to query. If anyone know s the proper syntax please let me know.<BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969
    Posts
    29

    Default RE: Access Query Error. What's the prob?

    SQLprof = "SELECT * FROM UserInfo WHERE user_name =&#039"& UNqryVar &"&#039"<BR><BR>You just needed a couple more quotation marks...<BR><BR>The Dude

  3. #3
    Leigh Dragoon Guest

    Default RE: Access Query Error. What's the prob?

    Please let me know the answer to this. I&#039m having the exact same problem! My error message reads:<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80004005&#039 <BR><BR>[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified <BR><BR>/hfe/day8/addme.asp, line 4 <BR><BR><BR>my email is ldragoon@hotmail.com

Posting Permissions

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