Re: Java.sql.SQlException
- From: David Harper <devnull@xxxxxxxxxxxxxxxxxxx>
- Date: Wed, 31 Oct 2007 11:27:28 GMT
Clive_ wrote:
I am trying to get an SQL statement to check that the users ID and the
ID row in a table match. There maybe up to a hundred users using the
database.
I have two tables in SQl Server express - Users and Property1 both
with a
SurveyID column ie Users.SurveyID and Prop1.SurveyID
The SQL statement is:
String querySQL=("Select * from Prop1_WallFinish where SurveyID =
\"Users.SurveyID\"" );
I am getting a java.sql.SQlException: Invalid column name.
Could anyone point out what is wrong with the statement???
It looks to me like you have two problems.
First, your select statement is trying to select from a table named "Prop1_WallFinish" rather than from either of the tables you mention, Users and Property1. Perhaps you actually mean
select * from Property1 ....
Second, your "where" clause looks fishy. Assuming that you really mean to select rows from the table named Property1, then your query appears to be
select * from Property1 where SurveyID = "Users.SurveyID"
which is testing an ID column, which is presumably a number, against a literal string "Users.SurveyID".
Are you trying to match rows in the Property1 table which have the same SurveyID column as rows in the Users table? That's called a join. It's a very common type of query, but the syntax is different than what you're trying to use.
May I suggest that you read the documentation for your database system and pay close attention to the chapter which explains joins. It will tell you how to query across two tables. Use your database system's command-line query tool to talk directly to your database server and try out various different queries before you take the leap to programming them in Java. One hurdle at a time ... :-)
David Harper
Cambridge, England
.
- Follow-Ups:
- Re: Java.sql.SQlException
- From: Thomas Kellerer
- Re: Java.sql.SQlException
- From: Clive_
- Re: Java.sql.SQlException
- References:
- Java.sql.SQlException
- From: Clive_
- Java.sql.SQlException
- Prev by Date: Java.sql.SQlException
- Next by Date: Re: Java.sql.SQlException
- Previous by thread: Java.sql.SQlException
- Next by thread: Re: Java.sql.SQlException
- Index(es):
Relevant Pages
|
