about insert/delete/update records in mysql server with asp code

[ebru]

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")&"')"

[jhardman]

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")&"')"

I always make it look more like:

objRS.addNew
for each fld in objRS.fields
   if request.QueryString(fld.name) <> "" then
      objRS(fld.name) = request.QueryString(fld.name)
   else
      'supply a default value usually with some complex function if needed
      objRS(fld.name) = supplyDefault(fld.name)
   end if
next
objRS.update
 

Of course you could always specify in your database that some fields are optional.

Jared

[ebru]

But this is insert data to Access database I want to insert data to MS Sql database..How can I do this?

I did like:
if request.queryString <> "" then
query = "select FRAME_WORK_ARRANGEMENT_REF_NUM,TASK_TITLE from hamp6 where"

if request.queryString("FRAME_WORK_ARRANGEMENT_REF_NU M") <> "" then
query = query + " FRAME_WORK_ARRANGEMENT_REF_NUM like '" & replace(request.queryString("FRAME_WORK_ARRANGEMEN T_REF_NUM"), "'", "''") & "' and"
end if

but it is not working :(




***************************

I always make it look more like:

objRS.addNew
for each fld in objRS.fields
   if request.QueryString(fld.name) <> "" then
      objRS(fld.name) = request.QueryString(fld.name)
   else
      'supply a default value usually with some complex function if needed
      objRS(fld.name) = supplyDefault(fld.name)
   end if
next
objRS.update
 

Of course you could always specify in your database that some fields are optional.

Jared

[jhardman]

But this is insert data to Access database I want to insert data to MS Sql database..How can I do this?

There is no difference between the way you access an MS Access db and a MS SQL Server db through an ASP. You will create an ADODB object, then use SQL statements to extract and manipulate the data.

I did like:
if request.queryString <> "" then
query = "select FRAME_WORK_ARRANGEMENT_REF_NUM,TASK_TITLE from hamp6 where"

if request.queryString("FRAME_WORK_ARRANGEMENT_REF_NU M") <> "" then
query = query + " FRAME_WORK_ARRANGEMENT_REF_NUM like '" & replace(request.queryString("FRAME_WORK_ARRANGEMEN T_REF_NUM"), "'", "''") & "' and"
end if

but it is not working :(

Try a quick experiment. Test the page in a way you think should work, but have a couple things written by the server. I would have the finished query statement and the original request queryString written right before executing the query:

response.write "<p>request('FRAME_WORK_ARRANGEMENT_REF_NUM'): " & request.queryString("FRAME_WORK_ARRANGEMENT_REF_NUM") & vbNewLine
response.write "<p>Query: " & query & vbNewLine
 

Do both of these have the right data that they should have? Let me know.

Jared