I can get ISNULL to work but...

[cheese]

Good afternoon all,

🙂 The code below works fine, but if I wanted the opposite ie

$row = odbc_exec($link,"SELECT Consignments.ReceiverCode, Consignments.Prefix, Consignments.WRef, Consignments.DateReceived, Publishers.PublisherName, Consignments.Invoice, Consignments.Cartons, Consignments.Weight, Consignments.ShipRef FROM Consignments INNER JOIN Publishers ON Publishers.PublisherCode = Consignments.PublisherCode WHERE (((Consignments.ReceiverCode)='$HTTP_COOKIE_VARS[user]') AND (ISNULL/COLOR))");


😕 When Consignments.ShipRef IS NOT NULL how can I get it work. I tried all sorts of combinations but must have miised the obvious!!

[stolzyboy]

have you tried

!ISNULL()

[cheese]

🙁 Nope,

Unfortunately !ISNULL(Consignments.ShipRef) returns the following error;

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Undefined function '!ISNULL' in expression., SQL state 37000 in SQLExecDirect in C:\Apache Group\Apache2\htdocs\pastshipment2.php on line 62

If you get rid of the ! it does not error anymore.......

H😕E😕L😕P

Neil.

[stolzyboy]

oops, didn't quite notice you weren't using mysql, sorry

[cheese]

No problem mate,

Still sitting here scratching my head.

Neil.

[cheese]

Got it sorted......

what I did was;

$nowt == NULL;

$row = odbc_exec($link,"SELECT Consignments.ReceiverCode, Consignments.Prefix, Consignments.WRef, Consignments.DateReceived, Publishers.PublisherName, Consignments.Invoice, Consignments.Cartons, Consignments.Weight, Consignments.ShipRef FROM Consignments INNER JOIN Publishers ON Publishers.PublisherCode = Consignments.PublisherCode WHERE (((Consignments.ReceiverCode)='$HTTP_COOKIE_VARS[user]') AND (B>'$nowt')[/B])");

Thanks to all for their help....

Neil