Hi.
On Mon 2002-06-03 at 14:17:42 -0400, [EMAIL PROTECTED] wrote:
> Try changing your WHERE clause from:
> WHERE
> call_notes.ticketid = '1' &&
> call_notes.userid = users.userid &&
> call_notes.contactid = facility_contact.contactid &&
> call_notes_text.noteid = call_notes.noteid
>
> To
> WHERE
> call_notes.ticketid = '1' &&
> call_notes.userid = users.userid &&
> call_notes.contactid = facility_contact.contactid &&
> call_notes.noteid = call_notes_text.noteid
>
> Note only the last line is changed and is reversed.
AFAIK, this should change nothing, as MySQL will change the "order of
the assignment" as appropriate. If you have an example which proves
otherwise I am very interested to see it.
Bye,
Benjamin.
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
