View Single Post
  #1 (permalink)  
Old April 1st, 2009, 08:44 AM
rtr1900 rtr1900 is offline
Authorized User
 
Join Date: Nov 2005
Posts: 72
Thanks: 3
Thanked 0 Times in 0 Posts
Default Adding dynamic data to a VBscript line

Hi,

As a newbie to VBscript I was wondering how to do the next:
I have some VBscript and want to make it dynamic. So I added some SQl script, but have no ide how to add it. this is my code:
Code:
Set conn = server.createobject("adodb.connection")
conn.open "DSN=XXXX"
set rs = server.createobject("adodb.recordset")
sql="Select * from table"
rs.open sql,conn
IF rs.eof THEN
ELSE
rr="offer.jpg"
%>

pic[0] = new banner("&rr&",102,offer2.asp')
Normally I use
Code:
("&rr&",
is ASp, but in VBSCRIPT how do I do this??

I am sure it is very simple to do.

thx
Reply With Quote