Thanks for your help so far. I have been able to come out with my problems so far but one is still eluding me. I explain my problem as such:-
Microsoft OLE DB Provider for SQL Server error '80040e14'
Line 1: Incorrect syntax near ','.
/jewel/stock_items_data.asp, line 34
where, line 34 contains the execute statement, viz con.execute mysql. The data types of the fields in the database are of types char, int, money, float etc. The same code works fine when all the elements of the form has the value. Kindly bail me out. Thanks a lot.