Print Page | Close Window

query sql

Printed From: CertCities.com Forums
Forum Name: Java Certs
Forum Discription: Discuss SCJP, SCJD, SCWCD and other Java certifications and related technologies here.
URL: http://certcities.com/forums/forum_posts.asp?tid=4281
Printed Date: 22 October 2007 at 7:53pm


Topic: query sql

Posted by: raz4
Subject: query sql
Date Posted: 13 December 2006 at 5:28am

query = "SELECT FILES.file FROM FILES,times where FILES.id = times.id AND FILES.country="+"'"+country+"'" +" AND FILES.name="+"'"+name+"'"+" AND FILES.food="+"'"+food+"'"+ " and "+"'"+ currentTime+"'" +" between times.startTime AND times.endTime";
//why I get an exception?




Print Page | Close Window