/build/static/layout/Breadcrumb_cap_w.png

query problem

I have an MS Access database linked to the K1000.  I'm having difficulty with a query.  I have the query linked to assets, and I can successfully filter it if I use the ID (For instance if I put a "5" under the criteria in asset types, it'll list only the assets that are computer.

I can then go into one of my other fields and add as the query "like ph%", and when I run the query, it'll show a list of all computers (asset type 5) where field_65 starts with PH - and the results are exactly what I want.

Where I run into a problem is if I try to use that query within another query.  I'm fine if I take the "like ph%" out of query #1 (and leave the "5" for asset type, but if I leave it in I get an error message that says "ODBC Call failed. [MYSQL].[ODBC 5.1 driver].[mysqld.5.6.10-log]Unknown Column 'MS1.ID' in 'field list' (#1054)."

Any thoughts?  Thanks.

2 Comments   [ + ] Show comments
  • Are you using MS Access for a specific reason? If you are just using it to query the database then I would recommend using a tool like MySQL Workbench. - chucksteel 10 years ago
  • I didn't know you could link K1000 to an MS Access DB. Thank you so much for this post, good to know and I hope your issue is resolved! - RisingStar 10 years ago

Answers (0)

Be the first to answer this question

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ