|
|
 |
|
초보자 / 2001-10-10 / 오후 7:24:39 / 211.107.241.193
조회수 : 124
|
| [질문] 조건식 데이터 형식이 일치하지 않는다고 하는데.. |
내용이 길어서 지송해요... 부탁드립니다.
-- 에러 내용 --
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC Microsoft Access 97 드라이버] 조건 식의 데이터 형식이 일치하지 않습니다.
/service/write_ok.asp, line 220
-- 에러 소스 --
office=upload.item("office")
tel=upload.item("tel")
charge=upload.item("charge")
mail=upload.item("mail")
con=upload.item("con")
basic=upload.item("basic")
use=upload.item("use")
site=upload.item("site")
basic1=upload.item("basic1")
con_area=upload.item("con_area")
c_num1=upload.item("c_num1")
c_num2=upload.item("c_num2")
med_area=upload.item("med_area")
med_plus=upload.item("med_plus")
med_new=upload.item("med_new")
m_num1=upload.item("m_num1")
m_num2=upload.item("m_num2")
p_num1=upload.item("p_num1")
p_num2=upload.item("p_num2")
n_num1=upload.item("n_num1")
n_num2=upload.item("n_num2")
pro=upload.item("pro")
text1=upload.item("text1")
basic2=upload.item("basic2")
basic2_1=upload.item("basic2_1")
basic2_2=upload.item("basic2_2")
basic3=upload.item("basic3")
basic3_1=upload.item("basic3_1")
basic3_2=upload.item("basic3_2")
basic4=upload.item("basic4")
basic4_1=upload.item("basic4_1")
baice4_2=upload.item("basic4_2")
'day=upload.item("day")
basic5=upload.item("basic5")
long1=upload.item("long1")
basic6=upload.item("basic6")
long1_6=upload.item("long1_6")
long1_7=upload.item("long1_7")
pwd=upload.item("pwd")
sql="select MAX(num) from service"
set rs=server.createobject("adodb.recordset")
rs.open sql,db
sql="insert into service(office,tel,charge,mail,con,basic,use,site,basic1,con_area,c_num1,c_num2,med_area,"
sql=sql & "med_plus, med_new, m_num1,m_num2,p_num1,p_num2,n_num1,n_num2,pro,text1,basic2,basic2_1,"
sql=sql & "basic2_2,basic3,basic3_1,basic3_2,basic4,basic4_1,basic4_2,basic5,long1,basic6,long1_6,"
sql=sql & "long1_7,pwd,s_filename,s_filesize) values"
sql=sql & "('" & office & "'"
sql=sql & ",'" & tel & "'"
sql=sql & ",'" & charge & "'"
sql=sql & ",'" & mail & "'"
sql=sql & ",'" & con & "'"
sql=sql & ",'" & basic & "'"
sql=sql & ",'" & use & "'"
sql=sql & ",'" & site & "'"
sql=sql & ",'" & basic1 & "'"
sql=sql & ",'" & con_area & "'"
sql=sql & ",'" & c_num1 & "'"
sql=sql & ",'" & c_num2 & "'"
sql=sql & ",'" & med_area & "'"
sql=sql & ",'" & med_plus & "'"
sql=sql & ",'" & med_new & "'"
sql=sql & ",'" & m_num1 & "'"
sql=sql & ",'" & m_num2 & "'"
sql=sql & ",'" & p_num1 & "'"
sql=sql & ",'" & p_num2 & "'"
sql=sql & ",'" & n_num1 & "'"
sql=sql & ",'" & n_num2 & "'"
sql=sql & ",'" & pro & "'"
sql=sql & ",'" & text1 & "'"
sql=sql & ",'" & basic2 & "'"
sql=sql & ",'" & basic2_1 & "'"
sql=sql & ",'" & basic2_2 & "'"
sql=sql & ",'" & basic3 & "'"
sql=sql & ",'" & basic3_1 & "'"
sql=sql & ",'" & basic3_2 & "'"
sql=sql & ",'" & basic4 & "'"
sql=sql & ",'" & basic4_1 & "'"
sql=sql & ",'" & basic4_2 & "'"
'sql=sql & ",'" & day & "'"
sql=sql & ",'" & basic5 & "'"
sql=sql & ",'" & long1 & "'"
sql=sql & ",'" & basic6 & "'"
sql=sql & ",'" & long1_6 & "'"
sql=sql & ",'" & long1_7 & "'"
sql=sql & ",'" & pwd & "'"
sql=sql & ",'" & s_filename & "'"
sql=sql & ",'" & s_filesize & "')"
db.execute sql <-- 220
디비 연결에 문제일까요?? 부탁드립니다. |
|
|
|