database contents can not display at same time

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

database contents can not display at same time

Author

Topic

fengvan
Starting Member

7 Posts

Posted - 2002-04-18 : 17:09:18

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 !!!

chadmat
The Chadinator

1974 Posts

Posted - 2002-04-18 : 17:43:41

Is order declared as an ADODB.Recordset somwhere?

-Chad