Query: sql = "SELECT * FROM images WHERE ID IN (SELECT jpgId FROM sales WHERE printed = 0)"
I'm getting the following error.
*PROBABLY* this means that jpgId in the sales table is not the same data type as id in the images table.
If you had shown the SCHEMA of the two tables, instead of a (mostly useless) data dump I could tell you for sure.
In any case, that's an inefficient way to do that.
But that will still give you a type mismatch if ID and jpgId are not the same datatype.
I would *guess* that ID is declared as auto_increment primary key which means that jpgId should be declared as int.
It's also possible that printed is not an int field, which it needs to be if you are going to compare it to the number 0.
|All times are GMT +1. The time now is 11:32 PM.|
Powered by vBulletin®
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.