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