Sql Query Problem

[MrShahi]

thanx for reply .....
I m sorry I really forgot to write the actual code on that thread....
I m using this in my code but it is not working

QSqlQuery query;
	query.prepare("SELECT *FROM Schedules WHERE StartDateTime<=:date EndDateTime>=:endTime ORDER BY ScheduleNo ASC");
	query.bindValue(":date",currentSystemStartDate);
	query.bindValue(":endTime",currentSystemEndTime);
	query.exec();
 
 
 
	if(query.isActive())
 
	{
 
		while(query.next())
 
   		{
 
			startTime=query.value(2).toString();
               }
}

QSqlQuery query;
	query.prepare("SELECT *FROM Schedules WHERE StartDateTime<=:date EndDateTime>=:endTime ORDER BY ScheduleNo ASC");
	query.bindValue(":date",currentSystemStartDate);
	query.bindValue(":endTime",currentSystemEndTime);
	query.exec();



	if(query.isActive())

	{

		while(query.next())

   		{

			startTime=query.value(2).toString();
               }
}

To copy to clipboard, switch view to plain text mode 

Now can you tell me what mistake I m doing ?????????