Set cn=Server.CreateObject("ADODB.Connection")
cn.Open Session("database_connection")
Set Rs=Server.CreateObject("ADODB.RECORDSET")
sql ="select employeeid,to_char(dd4,'yyyy-mm-dd') from K_Employee2 "
Rs.CursorLocation = 3
RS.Open SQL,cn,1,3
while not rs.eof
response.write rs("employeeid")
'response.write rs("dd4")
rs.movenext
wend
cn.close
set cn=nothing
我选择数据的时候必须加上TO_CHAR()函数,如果比÷不加就出错,但这样选择出来之后用RESPONSE.WRITE RS("DD4") 也出错
请penitent(只取一瓢)解决一下好吗
cn.Open Session("database_connection")
Set Rs=Server.CreateObject("ADODB.RECORDSET")
sql ="select employeeid,to_char(dd4,'yyyy-mm-dd') from K_Employee2 "
Rs.CursorLocation = 3
RS.Open SQL,cn,1,3
while not rs.eof
response.write rs("employeeid")
'response.write rs("dd4")
rs.movenext
wend
cn.close
set cn=nothing
我选择数据的时候必须加上TO_CHAR()函数,如果比÷不加就出错,但这样选择出来之后用RESPONSE.WRITE RS("DD4") 也出错
请penitent(只取一瓢)解决一下好吗
解决方案 »
- 这个存储过程要怎么改呢
- 请教关于date排序的问题
- oracle批量绑定问题求教
- oracle语句
- 判断影响数量,就像sql中的@@rowcount一样的有木有?谢谢
- 帮我看看这个from varchar2_table(i) 这样可以吗?该怎么改啊
- oracle数据库system用户的问题
- 帮我看看我应该使用哪种事务类型,谢谢先?
- 请教一个问题,有关算法的。急!!!
- java连接oracle数据库报错ntly know of service requested in connect descriptor
- 使用VB6程序调用ORACLE数据表时循环时出现错,我很急,高手出力!!!!
- 怎样给表加锁
..............
while not rs.eof
response.write rs("employeeid")
response.write rs("d4")
rs.movenext
wendrs.close() --------记得要关记录集
set rs.activeconnection=nothing
cn.close()
set cn.activeconnection=nothing
v_rtno=request("rtno")
set rs = Server.CreateObject("ADODB.Recordset")
rs.ActiveConnection = MM_conn_STRING
rs.Source = "SELECT a.*,to_char(bgtime,'yyyy') bgYear,to_char(bgtime,'mm') bgMonth,to_char(bgtime,'dd') bgDay,"&_
"to_char(bgtime,'hh24') bghour,to_char(bgtime,'mi') bgminute,to_char(bgtime,'ss') bgsecond,"&_
"to_char(edtime,'yyyy') edyear,to_char(edtime,'mm') edMonth,to_char(edtime,'dd') edDay,"&_
"to_char(edtime,'hh24') edhour,to_char(edtime,'mi') edminute,to_char(edtime,'ss') edsecond FROM timecard.rest a where rtno='"&v_rtno&"'"
rs.CursorType = 0
rs.CursorLocation = 2
rs.LockType = 3
rs.Open()
v_employeeno=rs("employeeno")
v_holid=rs("holid")
v_holcause=rs("holcause")
bgYear=rs("bgYear")
bgMonth=rs("bgMonth")
bgDay=rs("bgDay")
bghour=rs("bghour")
bgminute=rs("bgminute")
bgsecond=rs("bgsecond")
edyear=rs("edyear")
edMonth=rs("edMonth")
edDay=rs("edDay")
edhour=rs("edhour")
edminute=rs("edminute")
edsecond=rs("edsecond")
%>