hi all,
i have problem when try to insert into mysql db using ASP.
my statement seems too many character, so do you have another way to solve
my problem?
this is my SQL command in ASP:
<%
dim cd, nm, mt, addr, ct, ps_cd, st, tel, fax, eml, hm_pg, ct_prs, lc_no,
rg_no
dim objconn, objrs
dim inputtxt, sqltxt, srctxt
dim apkey, aplock
apkey = 1
aplock = 3
set objconn = server.createobject("adodb.connection")
set objrs = server.createobject("adodb.recordset")
objconn.connectionstring =
"server=192.168.0.1;driver=MySQL;db=mediause;uid=user;pwd=user"
objconn.open connectionstring
cd = request.form("cd")
nm = request.form("nm")
mt = request.form("mt")
addr = request.form("addr")
ct = request.form("ct")
ps_cd = request.form("ps_cd")
st = request.form("st")
tel = request.form("tel")
fax = request.form("fax")
eml = request.form("eml")
hm_pg = request.form("hm_pg")
ct_prs = request.form("ct_prs")
lc_no = request.form("lc_no")
rg_no = request.form("rg_no")
inputtxt = "insert into mmxcd(mmxcd_cd, mmxcd_nm, mmxcd_mt, mmxcd_addr,
mmxcd_ct, mmxcd_ps_cd, mmxcd_st, mmxcd_tel, mmxcd_fax, mmxcd_eml,
mmxcd_hm_pg, mmxcd_ct_prs, mmxcd_lc_no, mmxcd_rg_no, mmxcd_opr, mmxcd_sdt)
values(upper('" &cd &"'),upper('" &nm &"')," &mt &"," &addr &"," &ct &","
&ps_cd &"," &st &"," &tel &"," &fax &"," &eml &"," &hm_pg &"," &ct_prs &","
&lc_no &"," &rg_no &",'SFP',current_date)"
sqltxt = "select * from mmxcd"
srctxt = "mmxcd_cd = '" &cd &"'"
objrs.open sqltxt, objconn, apkey, aplock
objrs.find srctxt
if objrs.eof then
objrs.close
objrs.open inputtxt, objconn
response.redirect "/mediateonline/source/iclientdatabank.html"
else
objrs.close
response.redirect "/mediateonline/source/err_rec_exist.html"
end if
objconn.close
set objrs = nothing
set objconn = nothing
%>
and the error message is:
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
The request properties can not be supported by this ODBC Driver.
/mediateonline/scripts/asp/iclientdatabank_process.asp, line 33
TIA
Ivan Paul
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
