ry strings. I bet
it'll be dead obvious to you if you give that a shot.
Rich
> -Original Message-
> From: anders thoresson [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 02, 2003 9:30 AM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: [P
UPDATE un_issue SET i_editor = null WHERE i_date = '$issue'"
Thanks. But how come this works and sets i_editor to NULL
"UPDATE un_issue SET i_editor = $editor WHERE i_date = \"$issue\""
but the following two gives me a sql-error "You have an error in your SQL
syntax near 'WHERE i_date = ' at lin
how about \0. yours is a foward slash not an escape. though that may
just be your post you can also use an unquoted NULL.
hth
jeff
