if request("add")<>"" then
Rs.ActiveConnection = bag
Sorgu="SELECT * FROM contact_trans WHERE id="& id &""
rs.open "contact_trans",bag,3,2
rs.addnew
bu şekilde mysql e veri giremiyorum burada sql sorgusumu yanlış bağlantı kodu mu yanlış? yada başka bir yerdemi hata?
tıkandım yine
şimdiden teşekkür ederim.
if request("add")<>"" then
Rs.ActiveConnection = bag
Sorgu="SELECT * FROM contact_trans WHERE id="& id &""
rs.open "contact_trans",bag,3,2
rs.addnew
rs.fields ("workspace")=request("workspace")
rs.fields ("contact_id")=request("contact_id")
rs.fields ("description")=request("description")
rs.fields ("amount")=request("amount")
rs.fields ("debt")=request("debt")
rs.fields ("credit")=request("credit")
rs.fields ("_right")=request("_right")
rs.fields ("trans_type")=request("trans_type")
rs.fields ("trans_date")=request("trans_date")
rs.fields ("trans_dir")=request("trans_dir")
rs.fields ("trans_year")=request("trans_year")
rs.fields ("trans_month")=request("trans_month")
rs.fields ("exc_code")=request("exc_code")
rs.fields ("exc_rate")=request("exc_rate")
rs.fields ("exc_equivalent")=request("exc_equivalent")
rs.fields ("insert_by")=request("insert_by")
rs.fields ("insert_at")=request("insert_at")
rs.fields ("update_by")=request("update_by")
rs.fields ("update_at")=request("update_at")
rs.fields ("version")=request("version")
rs.fields ("receipt_no")=request("receipt_no")
rs.fields ("maturity")=request("maturity")
rs.fields ("trans_no")=request("trans_no")
rs.fields ("trans_source_id")=request("trans_source_id")
rs.fields ("trans_point_id")=request("trans_point_id")
rs.fields ("private_code_id")=request("private_code_id")
rs.fields ("ref_module")=request("ref_module")
rs.fields ("ref_id")=request("ref_id")
rs.update
rs.close
set rs=nothing
Response.Redirect("muhasebe_cari_acilis_ekle.asp")
end if
End If 