本文发表在 rolia.net 枫下论坛I have a problem with MS SQL 7.0

Table: orderinfor including
ordernumber (varchar)
username (varchar)
address (varchar)
ordertime (datatime)
cancelstatus (bit)

the database no index.

--------------------------------------------------------
ordernumber = request.form("ordernumber ")

set conn = server.createobject ("adodb.connection")
conn.open connstr

Set order=conn.execute("Select * from OrderInfor where OrderNumber='"& ordernumber &"'")

response.write "order time:" & order("ordertime") & "<br>"
response.write "cancel status:" & order("cancelstatus") & "<br>"

close.order
set conn=nothing
------------------------------------------------

in this case, the result only show the order time,

order time: 04/17/2002
cancel status:

--------------------------------------------------

if i change order
--------------------------------------------------------
ordernumber = request.form("ordernumber ")

set conn = server.createobject ("adodb.connection")
conn.open connstr

Set order=conn.execute("Select * from OrderInfor where OrderNumber='"& ordernumber &"'")


response.write "cancel status:" & order("cancelstatus") & "<br>"
response.write "order time:" & order("ordertime") & "<br>"

close.order
set conn=nothing
------------------------------------------------

the result only show the cancel status,

cancel status: true
order time:


-------------------------------------------------
the ordertime and cancelstatus can not be display
at same time.

why could this happen?

help !!!!!

thank you !!!更多精彩文章及讨论，请光临枫下论坛 rolia.net