here is the code
as i told you the error is only error '80020009'
no lines specified

Sub Top5manual
dim conn, sql, rs, products, i

if getconfig("xTopTopSalesdynamic")<>"" then
sql="select top "&clng(getconfig("xTopTopSalesdynamic"))&" * from products where bestof='oui' and ( hide=0 or hide is null ) "
else
sql="select * from products where bestof='oui' and ( hide=0 or hide is null ) "
end if

shopopendatabase conn

set rs=conn.execute(sql)
'
response.write "<table border=0 cellpadding=2 cellspacing=2>"
response.write "<tr valign=top>"
'
do while not rs.eof
for i=1 to clng(getconfig("xTopTopSalesdynamic"))

if getconfig("xTopTopSalesdynamic")<>"" then
sql="select top "&clng(getconfig("xTopTopSalesdynamic"))&" * from products where bestof='oui' and ( hide=0 or hide is null ) "
else
sql="select * from products where bestof='oui' and ( hide=0 or hide is null ) "
end if

'or in order to make sure try like this
'sql="select top 10 * from products where bestof='oui' and ( hide=0 or hide is null ) "

Your "for i = 1 to..." line is looping through records that aren't there. You've selected the correct amount of records from your database - you don't need to loop through the numbers. Just loop through ALL the results like this:

I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :)
To start, I want to make sure everyone understands the importance of utilizing p…

This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…

This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash"
After Shake : http://www.videocopilot.net/presets/after_shake/
All lightning effects with instructions : http://www.mediaf…

Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…