how to converting string to date giving error

[qadeer_ahmad]

dear friends i try to getting some records from a database (Pardox) while giving a string value in date script is

$cust=$REQUEST["cust"];
$date1 = "2004/08/23";
$date2 = "2004/08/29";
//$date1=$REQUEST["date1"];
//$date2=$_REQUEST["date2"];
$conn=odbc_connect('abc','xyz','xyz');
$sql = "SELECT CRPROCEI.Specie,CRPROCEI.Projected,CRPROCEI.Ceiling
FROM CRPROCEI
WHERE Customer='".$cust."' AND SDate
BETWEEN '2004/08/23' AND '2004/08/29'";
echo $sql."<br>";
$result=odbc_exec($conn,$sql) or die(odbc_error());
while($row=odbc_fetch_array($result))
{
echo $row["Specie"]."^{".$row["Projected"]."".$row["Ceiling"]."@@";}
}

but i receive this error (since this code work nice in localhost but give error on net site which using paradox sever)

which give this error

Warning: odbc_exec(): SQL error: [MERANT][ODBC Paradox driver]Incompatible datatypes in expression : BETWEEN , SQL state 37000 in SQLExecDirect in C:\Inetbump\fif\crprocei.php on line 13
37000

and line 13 is
$result=odbc_exec($conn,$sql) or die(odbc_error());

also i print the query and it show in this page when i brows like this

SELECT CRPROCEI.Specie,CRPROCEI.Projected,CRPROCEI.Ceiling FROM CRPROCEI WHERE Customer='2100' AND SDate BETWEEN '2004/08/23' AND '2004/08/29'

so please guid me what i do

[qadeer_ahmad]

Friends i got solution here so the query is now as

$sql = "SELECT SUM(p.Revised) as units ,p.Customer,x.SpecieCode
FROM slproj p,crxref x
where x.Item = p.Item AND x.Customer = p.Customer
and p.Customer='".$cust."' AND p.PDate
BETWEEN { d '".$date1."'} AND { d '".$date2."'}
GROUP BY p.Customer,x.SpecieCode";

its work and got result but when i am getting result of Sum(p.Revised) as unite on the line

echo $row["units"]."^{".$row["Customer"]."".$row["SpecieCode"]."@@";}

it give the error

Notice: Undefined index: units in C:\Inetbump\fif\unitscustomerspecie.php on line 32
^{2100 273@@}
Notice: Undefined index: units in C:\Inetbump\fif\unitscustomerspecie.php on line 32
^{2100 35@@}
Notice: Undefined index: units in C:\Inetbump\fif\unitscustomerspecie.php on line 32
^{2100 38@@}
Notice: Undefined index: units in C:\Inetbump\fif\unitscustomerspecie.php on line 32
^{2100 50@@}

i also try to get unit like this

echo $row[0]."^{".$row["Customer"]."".$row["SpecieCode"]."@@";}

but here some change in error Undefined take as ofset .. all error smae

So any solution here Please guid me

[tsinka]

Hi,

add print_r($row); to your code to check how the row array looks like.

Post the results.

Thomas

[qadeer_ahmad]

i apply this code like this

echo print_r($row["units"])."^{".print_r($row["Customer"])."".print_r($row["SpecieCode"])."@@";}

but error show

Notice: Undefined index: units in C:\Inetbump\fif\unitscustomerspecie.php on line 33
2100 2731^11@@
Notice: Undefined index: units in C:\Inetbump\fif\unitscustomerspecie.php on line 33
2100 351^11@@
Notice: Undefined index: units in C:\Inetbump\fif\unitscustomerspecie.php on line 33
2100 381^11@@
Notice: Undefined index: units in C:\Inetbump\fif\unitscustomerspecie.php on line 33
2100 501^11@@

i also try like this but again error

echo print_r($row["units"])."^{".$row["Customer"]."".$row["SpecieCode"]."@@";}

[tsinka]

Sorry,

I wasn't clear enough, what I meant was something like:

print_r($row);
echo $row["units"]."^^".$row["Customer"]."^^".$row["SpecieCode"]."@@";

The first line should print the complete $row array in a readable way.

Thomas

[qadeer_ahmad]

i give it like this

print_r($row);
echo $row["units"]."^{".$row["Customer"]."".$row["SpecieCode"]."@@";}

butt now error is

Array ( [UNITS] => 45 [Customer] => 2100 [SpecieCode] => 273 )
Notice: Undefined index: units in C:\Inetbump\fif\unitscustomerspecie.php on line 33
^{2100 273@@Array} ( [UNITS] => 197 [Customer] => 2100 [SpecieCode] => 35 )
Notice: Undefined index: units in C:\Inetbump\fif\unitscustomerspecie.php on line 33
^{2100 35@@Array} ( [UNITS] => 65 [Customer] => 2100 [SpecieCode] => 38 )
Notice: Undefined index: units in C:\Inetbump\fif\unitscustomerspecie.php on line 33
^{2100 38@@Array} ( [UNITS] => 80 [Customer] => 2100 [SpecieCode] => 50 )
Notice: Undefined index: units in C:\Inetbump\fif\unitscustomerspecie.php on line 33
^{2100 50@@Array} ( [UNITS] => 69 [Customer] => 2100 [SpecieCode] => 321 )

[tsinka]

I expected that the error/warning still exists. PHP is case sensitive when it comes to array keys so try:

echo $row["UNITS"]."^{".$row["Customer"]."".$row["SpecieCode"]."@@";}

As you can see in
Array ( [UNITS] => 45 [Customer] => 2100 [SpecieCode] => 273 )

the key is UNITS. This is what print_r($rows); was for ... you can remove it now.

Thomas

[qadeer_ahmad]

THANKS FRIEND ITS WORKING NICE