|
| |
|
|
SpecialBlend
Posts: 15
Joined: 4/14/2002
From:
Status: offline
 |
Wrong results displayed - 4/14/2002 23:34:32
I have created a databse in Access. I have set up my web to use that database. But I have 2 problems. They go hand in hand.
First when I preview the databases by either publishing it to my server and viewing it that way or previewing it in my browser, it shows different results. For instance one of my databases will show 22 results or entries while the database I made in Access only has 10.
Second, which has to be related to my first problem, is it won't show updated entries that I have added to my Access database.
What I am doing is updating a previously made website. I am creating databases so it would be easier to manage all of the entries I have.
Just to let you know the databases I am attempting to set up are for cars. I want to convert the list of cars I have shown to databases so all I have to do it change the Access database.
|
|
|
|
SpecialBlend
Posts: 15
Joined: 4/14/2002
From:
Status: offline
|
RE: Wrong results displayed - 4/14/2002 23:36:11
It might also help if you knew that I was running Win XP Pro with IE 6, seeing as those might affect my problems
| |
|
|
|
SpecialBlend
Posts: 15
Joined: 4/14/2002
From:
Status: offline
|
RE: Wrong results displayed - 4/16/2002 1:55:14
not sure. As I mentioned before they pages were already done I just needed to re-direct the results to a database and make sure all the links and such worked fine.
| |
|
|
|
Spooky
Posts: 26597
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Wrong results displayed - 4/16/2002 2:40:28
Youll need to know the SQl, as its the only way you can compare whether the same query is running, or where the error lays.
Somewhere in the asp code will be the SQL string :)
§þðð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/18/2002 21:17:15
I searched and this is all I could find:
<%'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
%>
| |
|
 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 
