Wrong results displayed (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

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



Spooky -> RE: Wrong results displayed (4/15/2002 0:10:51)

Whats the SQL query you are using?

§þððk¥
Database / DRW Q & A
VP-ASP Shopping cart
Spooky Login



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


%>






Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
3.320313E-02