The method below is used as part of a search facility for my web site. I'm getting this error message: org.apache.jasper.JasperException: Column not found, message from server: "Unknown column 'origin' in 'where clause'"
This is my code for the method:
Country and Type are defined as columns within the exsisting table within the DB. Any ideas? [ May 03, 2003: Message edited by: Rob Petterson ]
Actually you have 2 errors in your SQL statement. Since origin, and coinType are parameters, try this:
[ May 03, 2003: Message edited by: Irene Loos ]
Joined: Jan 23, 2002
Thanks Lasse and Irene for you're help. You were right Irene, there were a couple of mistakes in my syntax. You wouldn't believe how long I spent yesterday trying to figure it out! It works fine now. I've got one more of those methods to overload for a more complex search query, so at least now I've got a fair shot at getting it to work with your previous help. Thanks again. [ May 04, 2003: Message edited by: Rob Petterson ]