about insert/delete/update records in mysql server with asp code
how can I insert record in mysql database.. I insert into database but if I leave one text box empty, its give me error how can overcome on it...
my code is like
"INSERT INTO hamp6 VALUES ('" & request.QueryString("FRAME_WORK_ARRANGEMENT_REF_NU M")& "', '" & request.QueryString("TASK_ORDER_FORM_REFERENCE_NUM BER") &"', '" & request.QueryString ("TASK_TITLE") &"', '" & request.QueryString ("PROJECT_SPONSOR") &"', '" & request.QueryString("TEL") &"', '" & request.QueryString("PROPOSED_TASK")&"', '" & request.QueryString("DURATION")&"', '" & request.QueryString("BUSINESS_CASE") &"', '" & request.QueryString("TOTAL_ESTIMATE_COST")&"')"