Accessing data from database query into asp code

Results 1 to 2 of 2

Thread: Accessing data from database query into asp code

  1. #1
    Rbz Guest

    Default Accessing data from database query into asp code

    I want to make a SELECT statement(query) in my asp code which is fetching its data from an existing "Query" in Access 95 Database; unlike fetching it from a "Table" in the Database. Can I do that?<BR><BR>When I try to run it, it gives;<BR> "Microsoft JET Database Engine error &#039 80040e10&#039.<BR>No value given for one or more required parameters." <BR><BR>NOTE: if I run this SELECT statement in the Access database, it outputs a result. Also my asp code runs, if the SELECT statement is fetching data from a table in the same database.<BR><BR>Can anybody please suggest?

  2. #2 Guest

    Default Show us your code!

    If you have an access select query in the db, then accessing it through asp is exactly the same if it is a table. <BR><BR>The error you are getting indicates that you have misspelled a field name in a where clause.<BR><BR>If I could see you code I would have a chance of being able to help you.<BR><BR>I DO NOT UNDERSTAND ALL YOU PEOPLE WHO EXPECT US TO HELP THEM WHEN WE DON&#039T KNOW WHAT THEY ARE DOING!

Posting Permissions

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