Valid SELECT statement for use in JSP?
[270 byte] By [hyrum14] at [2007-9-26 1:19:31] 
Just starting to work with mySQL and JSP, is this a valid statement:String Query = "SELECT r.resumeID,r.userID,u.location FROM resumes r,resumeHolders u WHEREr.userID=u.userID AND u.location=" +City;City being a variable set earlier...
Unless City is a number you will probably want to surrond your variable city with 'sSELECT r.resumeID,r.userID,u.location FROM resumes r,resumeHolders u WHEREr.userID=u.userID AND u.location=\'" +City"\'";
walaloo at 2007-6-29 0:52:07 >
Enterprise & Remote Computing New Topic
Enterprise & Remote Computing Hot Topic
Enterprise & Remote Computing
All Classified
- Archived Forums
- Enterprise & Remote Computing
- Java Essentials
- Desktop
- Core
- Solaris Operating System
- Security
- Database Connectivity
- Java Mobility Forums
- Web & Directory Servers
- Development Tools
- Application & Integration Servers
- Java HotSpot Virtual Machine
- Other Topics
- E-Mail, Calendar, & Collaboration
- Developer Tools
- General
- Administration Tools
- Sun Hardware
- Storage Forums
- Java Enterprise System
- StarOffice
- Open Source Technologies
- BigAdmin
- Real-Time
- Java Coding