I dun really know whether it is on the server end or client side. My connection to db is all done in an include file which i call from all...

Yah I have found out about it already. Thnx dude. 🙂 But I have another question here : I am using Commandtext as the SQL statement. Is it possible to...

Hi guys,

i'm working in ASP in a Microsoft SQL Server environment. I dunno whether the Onchange event works in ASP but i do know that it works in VB.

Marvin

haha...guys...hehe..i solved dat issue also...thanks...managed to solve it by changing the Data Source to "localhost" but this problem is wierd rite??..anyone who knows why this happens?? Just wanna know for...

haha...thnx guys...I have sorta corrected the error. It lies in one of my other Include files deep within, which does the endless loop. So the EOF actually works..sorry guys... ...

The case is like this :

I have a random banner generator. It generates a random number and grabs from the database the image name via the ID. But first...

Thanks guys,

This is my first time programming in ASP and in a SQL server environment. There is a reason why I dun want to use the Top 20 thingie. Cos...

Hi,

I reversed the logic already and checked whether the rs.EOF returns true first. But it still returns a time-out error.

In another page, i used the same method to display a...

oh yah and i forgot to tell u...i also need to check basically whether it is an empty recordset...for cases when the user enters nonsensical data...which doesn't exist in the...

set rsConn = Server.CreateObject("ADODB.Connection")

rsConn.Open SQLdb

set newscmd = Server.CreateObject("ADODB.Command")

set newscmd.activeconnection = rsConn

newscmd.CommandText = "Select * FROM News WHERE Category = '" & Category & "' ORDER BY ID DESC"

newscmd.CommandType = 1

Set...

Hi, I am also getting one major error. I cannot seem to check for the EOF or rather that line doesn't work. So I tried to get the rs.Recordcount. It...