I am running the following query from my java program : select * from OtherValues where StructureID = 0 and (DPID is null or DPID=""); I am getting error : java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. Although the query running fine in Access directly. pls suggest.. Thanks in advance.
double quotes was the problem , I changed the query and now its working. select * from OtherValues where StructureID = 0 and (DPID is null or DPID='');