Hi,

First time here, hope someone can understand me and help me.

I have a field wich type that is int(4), and I'm updating it from a form. it
is working ok, unless the formfield is empty. When it's empty I'm receiving
an SQL error number 51().

In the db the field is setup to receive empty values.
In the query the field is not surranded by ' ' ( since it's a number ).

does anyone can explain to me what is happening ? how can I leave that field
empty on the form.

Also the same thing is happening with a date field. ! anyclues ?

TIA
Marcelo Simon


---------------------------------------------------------------------
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

Reply via email to