|
| |
|
|
SpecialBlend
Posts: 15
Joined: 4/14/2002
From:
Status: offline
 |
Wrong results displayed - 4/21/2002 18:07:24
Don't remember if I posted this already or not, but I've setup my database, and I've linked it to my pages. Only problem is it doesn't seem to be going to the database that I linked.
For instance one of my tables in my database has 11 entries in it, but the page that the database is linked to shows 22 entries, all of them different. Here's the code
<%'Setup the record set
Set DataConn = Server.CreateObject("ADODB.Connection")
DataConn.ConnectionTimeout = Application("DataConn_ConnectionTimeout")
DataConn.CommandTimeout = Application("DataConn_CommandTimeout")
DataConn.Open Application("DataConn_ConnectionString"), Application("DataConn_RuntimeUserName"), Application("DataConn_RuntimePassword")
Set cmdTemp = Server.CreateObject("ADODB.Command")
Set rs = Server.CreateObject("ADODB.Recordset")
cmdTemp.CommandText = "Select * from DamageCar"
cmdTemp.CommandType = 1
Set cmdTemp.ActiveConnection = DataConn
rs.Open cmdTemp, , 1, 3
%>
|
|
|
|
Spooky
Posts: 26597
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Wrong results displayed - 4/21/2002 21:15:39
Are there actually 2 databases or tables that information can be gained from?
§þððk¥
Database / DRW Q & A
VP-ASP Shopping cart
Spooky Login
| |
|
|
|
SpecialBlend
Posts: 15
Joined: 4/14/2002
From:
Status: offline
|
RE: Wrong results displayed - 4/21/2002 22:17:38
No, each table/database has it's own unique name in which the asp takes the results from
What I just tried is in one of the tables I added another result in to see if it was actually the database and not Frontpage. Needless to say the result I just added in didn't appear. So it seems that Frontpage is taking it from a different place rather than the database I linked it to
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
