Can you send me the asp page as an attachment? Nick
:> -----Original Message----- :> From: Ivan Paul [mailto:[EMAIL PROTECTED]] :> Sent: 16 July 2002 04:53 :> To: MySQL :> Subject: problem when try to insert into mysql db using ASP :> :> :> 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 :> --------------------------------------------------------------------- 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
