Sending Variable On Next Page

qadeer_ahmad

DEAR FRIENDS
IF I SEND ONE VARIABLE IT WORK ON THIS COMMAND LINE

$handle = @fopen("http://paradox.freshislandfish.com/itemdescserver.php?cust=".$custno, "rb");

BUT WHEN I TRY TO SEND THREE VARIABLE IT NOT WORK AND DID NOT GIVE ANY ERROR MESSAGE THROUGH THIS COMMAND PLEASE CHECK AND CORRECT IT

$handle = @fopen("http://paradox.freshislandfish.com/soecprojciel.php?cust=".$cust.",date1=".$date1.",date2=".$date2.", \"rb\"");

has27

Try separating the variables in the URL with & not ,

$handle = @fopen("http://paradox.freshislandfish.com/soecprojciel.php?cust=".$cust."&date1=".$date1."&date2=".$date2, "rb");

There might also have been something wrong with the
.", \"rb\"");
at the end - it looks like you're passing "rb" at the end of the URL (which would come out as
...&date2=foo "rb"
which isn't right)

you need to use fopen("url","rb") not fopen("url\"rb\"")
see [man]fopen[/man].

qadeer_ahmad

now giving 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\unitscustomerspecie.php on line 16
37000

and line 16 is

$result=odbc_exec($conn,$sql) or die(odbc_error());

TheDefender

$result=odbc_exec($conn,$sql) or die(odbc_error());

This line has nothing to do with the $handle issue, so first we need to find out if the first issue is fixed now...

The line should look something like this:

$handle = @fopen("http://paradox.freshislandfish.com/soecprojciel.php?cust=".$cust."&date1=".$date1."&date2=".$date2."", "rb");

qadeer, you're going to need to post more code... Specifically, a few lines before and after line 16... Sometimes a line number referenced in an error is actually before or after the actual problem code.

qadeer_ahmad

problem show is

<?
$cust=$REQUEST["cust"];
//$date1=$REQUEST["date1"];
//$date2=$_REQUEST["date2"];
$date1="08/23/2004";
$date2="08/28/2004";
//$date1="2004/08/23";
//$date2=getdate();

$conn=odbc_connect('123','nabc','ar23');

$sql = "SELECT sum(p.revised) as units,p.customer as customer,x.speciecode as speciecode
FROM slproj p
LEFT OUTER JOIN crxref x ON ( x.item = p.item AND x.customer = p.customer )
WHERE p.customer='.$cust.' AND p.pdate
BETWEEN '.$date1.' AND '.$date2.'
GROUP BY p.customer,x.speciecode";

//$sql= "SELECT * FROM slproj WHERE p.customer='.$cust.'";
//echo $sql."<br>";
$result=odbc_exec($conn,$sql) or die(odbc_error());
while($row=odbc_fetch_array($result))
{
echo $row["units"]."^{^{".$row["customer"]."^{^{".$row["speciecode"]."@@";}}}}
}
?>

tsinka

Hi,

try the following modification:

... AND FormatDateTime('mm/dd/yyyy', p.pdate) BETWEEN ...

Thomas

qadeer_ahmad

now error is

odbc_exec(): SQL error: {MERANT}[ODBC Paradox driver]Unmatched quote character:'GROUP BY p.customer,x.speciecode, SQL state S1000 in SQLExecDirect in C:......... on line 21
and line21 is
$result=odbc_exec($conn3,$sql) or die(odbc_error());

tsinka

Seems like a space is missing between ' and GROUP BY.

Change the $sql = ... line to:

$sql = "SELECT sum(p.revised) as units,p.customer as "
      ."customer,x.speciecode as speciecode "
      ."FROM slproj p LEFT OUTER JOIN crxref x "
      ."ON ( x.item = p.item AND x.customer = p.customer ) "
      ."WHERE p.customer='$cust' AND "
      ."FormatDateTime('mm/dd/yyyy', p.pdate) "
      ."BETWEEN '$date1' AND '$date2' "
      ."GROUP BY p.customer,x.speciecode";

Thomas

qadeer_ahmad

i put this line
$sql = "SELECT sum(p.revised) as units,p.customer as "
."customer,x.speciecode as speciecode "
."FROM slproj p LEFT OUTER JOIN crxref x "
."ON ( x.item = p.item AND x.customer = p.customer ) "
."WHERE p.customer='.$cust.' AND "
."FormatDateTime('mm/dd/yyyy',p.date) "
."BETWEEN '.$date1.' AND '.$date2.' "
."GROUP BY p.customer,x.speciecode";

now error is

Warning odbc_exec(): SQL error:[MERANT][ODBC Paradox driver]Unknown Function FORMATDATETIME, SQL state 37000 in SQLExecDirect in c:................. on line26

tsinka

which database version do you use ?