NEMONOMAN DO YOU READ THE QUESTIONS OR EVEN THE ENTIRE POST???
I AM NOT... I REPEAT NOT USING MYSQL!!!
IN CASE YOU MISSED IT
I AM NOT USING MYSQL!!!!
NO MYSQL HERE...
I am using Micro$oft Access... Strange I know but If you read both posts you would see that in fact the Query works...
All I wanted to know is if people had had the same experience I had with ODBC...
I have descided to go another route Please see the code below.
$ss = $_GET[ss];
$pid = $_GET[pid];
$tok = strtok($ss," \n\t");
$n=0;
while ($tok) {
if(!$osql){
$osql=" IIf(InStr([ProjectTasksName] & ' ' & iif(isnull([ProjectTasksDescripton]),'No Description Entered',[ProjectTasksDescripton]),'$tok')>0,1,0) ";
}else{
$osql.=" + IIf(InStr([ProjectTasksName] & ' ' & iif(isnull([ProjectTasksDescripton]),'No Description Entered',[ProjectTasksDescripton]),'$tok')>0,1,0) ";
}
$tok = strtok(" \n\t");
$n+=1;
}
$sql="SELECT TblProjectTasks.ProjectTasksId, TblProjectTasks.ProjectTasksRefNum, TblProjectTasks.ProjectTasksName, iif(isnull(TblProjectTasks.ProjectTasksDescripton),'No Description Entered',TblProjectTasks.ProjectTasksDescripton), TblStatus.StatusCharacter, TblFont.FontName, TblColor.ColorHTML, Format([ProjectTasksStartDate],'mm/dd/yyyy') AS StartDate, Format([ProjectTasksEndDate],'mm/dd/yyyy') AS EndDate
FROM TblColor INNER JOIN (TblFont INNER JOIN (TblStatus INNER JOIN TblProjectTasks ON TblStatus.StatusId = TblProjectTasks.StatusID) ON TblFont.FontId = TblStatus.FontId) ON TblColor.ColorId = TblStatus.ColorId
WHERE ((($osql)=$n) AND ((TblProjectTasks.ProjectId)=$pid))
ORDER BY TblProjectTasks.ProjectTasksRefNum;";
$cur=odbc_exec($cnx,$sql);
$n=0;
print "<center><form><input type=text value='$ss' name=ss></input><input type=hidden value=$pid name=pid></input> <input type=submit value=Search></input></form></center>";
Print "<table bgcolor='#000000' width=100%>";
print "<tr><th align=center bgcolor='#d0d0d0' ><h2> Search Results </h2></th></tr>";
while(odbc_fetch_row($cur)){
$tid=odbc_result($cur,1);
$trn=odbc_result($cur,2);
$tnm=odbc_result($cur,3);
$tdc=odbc_result($cur,4);
$tcr=odbc_result($cur,5);
$tfn=odbc_result($cur,6);
$thc=odbc_result($cur,7);
$tsd=odbc_result($cur,8);
$ted=odbc_result($cur,9);
print "<tr><td bgcolor='#ffffff'>";
print "Not this far yet..";
print "</td></tr>\n";
$n+=1;
}
if($n==0){
print "<tr><td bgcolor='#ffffff' align=center> No Matches Found </td></tr>";
}
Print "</table>";
I wish People would just read....
