Hi Andreas,

the problem is that not every row of the $ergRouten statement has a row in
the $ergDispatch statement.

I also tired a UNION query, but this took longer for execution than it does
now and brings me more timeout problems then I have now.

Michael


"Andreas Karajannis" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Michael J. Eisner wrote:
>
>
> >>>i have a loop going through a result set of an odbc-query. each row of
> >>>this loop has to be checked if there is an entry in another table. so
as the
> >>>last odbc-query is the same for each row except they key-field, i tried
to
> >>>use the odbc_prepare function and a parameter array. but it doesn't
work.
>
> If Access supports subqueries, you should consider this approach, e.g.
>
>
> $sql="SELECT fldCaptain, fldCaptID, fldCaptStat, fldCaptTR, fldCaptDuty,
>   fldFO, fldFOID, fldFOStat, fldFOTR, fldFODuty, fld_F_Reserved,
>   fld_F_Flown
>   FROM tblBookings WHERE fldFlight in (select ... from ... where ...)
>   AND fldBookDate=#".$EngDatum."#";
>
> with the subquery being essentially your $ergRouten statement.
>
>
> HTH,
>   Andreas
>
> --
> Andreas Karajannis
> mediaworx berlin  AG
>
> Fon (0 30) 2 75 80 - 266
> Fax (0 30) 2 75 80 - 200
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to