我把sql語句放在asp執行後,再commit,卻沒插入
cmdsql="insert into wip.xwp_seq_daily_quantity_dafa(datetime,dept,organization_id,process,qty)"
cmdsql=cmdsql &" values(to_date('"&s_date&"','YYYYMMDD'),'MW','84','"&s_dept&"','" &rowdata1(20,b)&"')"
cn.execute(cmdsql)
cn.execute("commit")我就把這條sql語句在asp中response出來,
insert into wip.xwp_seq_daily_quantity_dafa(datetime,dept,organization_id,process,qty) values(to_date('20101204','YYYYMMDD'),'MW','84','','-1198')在pl/sql developer 中insert後,再commit,能插入為什麼會這樣
cmdsql="insert into wip.xwp_seq_daily_quantity_dafa(datetime,dept,organization_id,process,qty)"
cmdsql=cmdsql &" values(to_date('"&s_date&"','YYYYMMDD'),'MW','84','"&s_dept&"','" &rowdata1(20,b)&"')"
cn.execute(cmdsql)
cn.execute("commit")我就把這條sql語句在asp中response出來,
insert into wip.xwp_seq_daily_quantity_dafa(datetime,dept,organization_id,process,qty) values(to_date('20101204','YYYYMMDD'),'MW','84','','-1198')在pl/sql developer 中insert後,再commit,能插入為什麼會這樣
这里面的cn应该是你连接oracle的那一段字符