Re: mysql insert

Hi Byan: > This works fine. However, there are fields in the > table that cant be null, but after doing the insertion > and viewing the table, those fields are null. How did you define the fields? Did it include something like not null default '', If so, then you shouldn't have a problem. When you say "those fields are null" do you mean a query returns "NULL" or does it return a blank "" If it's the latter, the fields are not null, they're blank. --Dan -- T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y More than just answers. Solutions. (SM) http://www.analysisandsolutions.com/ 4015 7 Av #4, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409