Gossamer Forum
Home : Products : DBMan SQL : Discussion :

add multiple - error messages

Quote Reply
add multiple - error messages
Hi,

I'd like to use the add multiple feature in dbman sql 2 to give users the option of adding several records using one form. So I have this:

db.cgi?do=add_multi_form&m=5&db=Company_Product

The problem I have is that if the user decides to add two records, and leaves the remaining records blank, I get a load of error messages like this:

# Column Product Code cannot be left blank.
# Column Category Code cannot be left blank

Is there any way I can tell dbman sql to ignore blank records when adding, so the user gets an add success message for the records he has added?

thanks
Tim Ault
Oxford UK
Subject Author Views Date
Thread add multiple - error messages timbo 3768 Nov 13, 2003, 10:31 AM
Thread Re: [timbo] add multiple - error messages
604 3656 Nov 14, 2003, 10:01 AM
Thread Re: [TheStone] add multiple - error messages
timbo 3648 Nov 14, 2003, 10:12 AM
Post Re: [timbo] add multiple - error messages
timbo 3643 Nov 14, 2003, 11:35 PM