February 20th, 2002, 04:36 PM
concatenating strings and columns in mysql query statement in a jsp page
I would like to know how to concatenate two strings and columns in the where portion in an mysql statement.
Here is a fragment of my code
/*Search student refers to the name of the textfield either student number, first name, last name, or both first name and last name*/
//the var student is the student number
//the var first is the first name
//the var last is the last name
String student = request.getParameter("searchStudent");
String first = request.getParameter("searchStudent");
String last = request.getParameter("searchStudent");
connection = DriverManager.getConnection(connectionURL, "", "");
//This statment search for all records from students table relating
//firstname, lastname, first name and last name,student number
//of particular student
//Whats wrong with this statement
rs=statement.executeQuery("SELECT * FROM students WHERE firstname+lastlastname='" +first+last+"' OR firstname='" + first + "' OR lastname='" + last + "' OR studentid='" + student + "'");
I'm getting this error
javax.servlet.ServletException: Column not found: Unknown column 'first' in 'where clause'
I want the text field to accept a full name for example "Tom Jones"
It will then search the firstname and lastname from the student table and display those records for that persons name.
February 21st, 2002, 07:26 AM
there is a mysql function called concat
is equivalent to
Probably no help, but the error message doesn't make too much sense, cos you are never refering to a column as "first" this is purely in the java, so the db will not see this as it is at a different layer of abstraction