in reply to Re: andling form data
in thread Putting a long form into a database

Thanks Matija for your help. My table has column names same as field names in the form. So I think 1st part of the code will work for me. However I am not sure about one thing -

what happens if a field in the form is left blank? Will $val contain null for that field?

Replies are listed 'Best First'.
Re: Re: Re: andling form data
by matija (Priest) on Apr 14, 2004 at 16:26 UTC
    If the browser doesn't pass the empty field (which most browsers don't I think), then it won't be set at all (that is part of the purpose of enumerating the fieldnames in the INSERT statement) and it's value will be whatever default you set up for the table - most probably NULL or empty string.

    If the browser does pass fields without values entered, then they will be set to empty string in the database.

[reply]

In Section Seekers of Perl Wisdom