p2p.wrox.com: Archives - asp

asp_databases thread: Re: BANNER

Message #1 by arshad siddiqui <ash_arshad@y...> on Wed, 16 Jan 2002 03:34:28 -0800 (PST)

Hi there,

Can any one give me some idea how to put a banner on

my web site.

Any help will be appreciated.

Thanx

Regards

--Arshad--





__________________________________________________

Do You Yahoo!?

Send FREE video emails in Yahoo! Mail!

http://promo.yahoo.com/videomail/

Message #2 by "Kim Iwan Hansen" <kimiwan@k...> on Wed, 16 Jan 2002 12:38:45 +0100

<a href="bannerlink.htm"><img src="bannerimage.gif" height="100" width="400"

border="0"></a>



(that's incl. the link)



anything else? :-)



-Kim







> -----Original Message-----

> From: arshad siddiqui [mailto:ash_arshad@y...]

> Sent: 16. januar 2002 12:34

> To: ASP Databases

> Subject: [asp_databases] Re: BANNER

>

>

> Hi there,

> Can any one give me some idea how to put a banner on

> my web site.

> Any help will be appreciated.

> Thanx

> Regards

> --Arshad--

>

>

> __________________________________________________

> Do You Yahoo!?

> Send FREE video emails in Yahoo! Mail!

> http://promo.yahoo.com/videomail/

>




> $subst('Email.Unsub').

>

Message #3 by arshad siddiqui <ash_arshad@y...> on Wed, 16 Jan 2002 04:37:02 -0800 (PST)

Hi

Actually I wanted to ask whetehr we can do it the

database way so that we can store the image location

in the database and then we can display it as a

banner.

Any way thanx for your help.

Regards

--Arshad--



--- Kim Iwan Hansen <kimiwan@k...> wrote:

> <a href="bannerlink.htm"><img src="bannerimage.gif"

> height="100" width="400"

> border="0"></a>

> 

> (that's incl. the link)

> 

> anything else? :-)

> 

> -Kim

> 

> 

> 

> > -----Original Message-----

> > From: arshad siddiqui

> [mailto:ash_arshad@y...]

> > Sent: 16. januar 2002 12:34

> > To: ASP Databases

> > Subject: [asp_databases] Re: BANNER

> >

> >

> > Hi there,

> > Can any one give me some idea how to put a banner

> on

> > my web site.

> > Any help will be appreciated.

> > Thanx

> > Regards

> > --Arshad--

> >

> >

> > __________________________________________________

> > Do You Yahoo!?

> > Send FREE video emails in Yahoo! Mail!

> > http://promo.yahoo.com/videomail/

> >





> > $subst('Email.Unsub').

> >

> 

> 





$subst('Email.Unsub').





__________________________________________________

Do You Yahoo!?

Send FREE video emails in Yahoo! Mail!

http://promo.yahoo.com/videomail/

Message #4 by "Drew, Ron" <RDrew@B...> on Wed, 16 Jan 2002 08:07:18 -0500

Use Javascript...go to http://javascript.internet.com/ and look for the

banner or scroll type you want



-----Original Message-----

From: arshad siddiqui [mailto:ash_arshad@y...]

Sent: Wednesday, January 16, 2002 6:34 AM

To: ASP Databases

Subject: [asp_databases] Re: BANNER





Hi there,

Can any one give me some idea how to put a banner on

my web site.

Any help will be appreciated.

Thanx

Regards

--Arshad--





__________________________________________________

Do You Yahoo!?

Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/






$subst('Email.Unsub').

Message #5 by "Johnson, Israel" <IJohnson@R...> on Wed, 16 Jan 2002 08:32:28 -0500

why not use the AdRotator Component



-----Original Message-----

From: arshad siddiqui [mailto:ash_arshad@y...]

Sent: Wednesday, January 16, 2002 7:37 AM

To: ASP Databases

Subject: [asp_databases] Re: BANNER





Hi

Actually I wanted to ask whetehr we can do it the

database way so that we can store the image location

in the database and then we can display it as a

banner.

Any way thanx for your help.

Regards

--Arshad--



--- Kim Iwan Hansen <kimiwan@k...> wrote:

> <a href="bannerlink.htm"><img src="bannerimage.gif"

> height="100" width="400"

> border="0"></a>

> 

> (that's incl. the link)

> 

> anything else? :-)

> 

> -Kim

> 

> 

> 

> > -----Original Message-----

> > From: arshad siddiqui

> [mailto:ash_arshad@y...]

> > Sent: 16. januar 2002 12:34

> > To: ASP Databases

> > Subject: [asp_databases] Re: BANNER

> >

> >

> > Hi there,

> > Can any one give me some idea how to put a banner

> on

> > my web site.

> > Any help will be appreciated.

> > Thanx

> > Regards

> > --Arshad--

> >

> >

> > __________________________________________________

> > Do You Yahoo!?

> > Send FREE video emails in Yahoo! Mail!

> > http://promo.yahoo.com/videomail/

> >





> > $subst('Email.Unsub').

> >

> 

> 





$subst('Email.Unsub').





__________________________________________________

Do You Yahoo!?

Send FREE video emails in Yahoo! Mail!

http://promo.yahoo.com/videomail/






$subst('Email.Unsub').

Message #6 by "Peter Foti (PeterF)" <PeterF@S...> on Wed, 16 Jan 2002 11:40:27 -0500

Create a table for your banner ads:



bannerAdTable

-------

bannerAdID (autonumber)

bannerAdURL (text - big enough to hold large URL)

bannerAdImgSrc (text)

bannerAdImgHeight (number)

bannerAdImgWidth (number)



So your data might look like this:

1	"http://www.link1.com"	"/images/link1.gif"	100	400

2	"http://www.link2.com"	"/images/link2.gif"	50	200



etc.





If you wanted to hard code a banner for the first ad, you could do this

on your page



<%

' Assumes you already have a connection open and are passing the

connection object

' in as DConn

Function GetBannerAd( DConn )

	Dim SQLStr

	Dim oRS

	

	SQLStr = "SELECT

bannerAdURL,bannerAdImgSrc,bannerAdImgHeight,bannerAdImgWidth FROM

bannerAdTable"

	

	' Create recordset object

	Set oRS = Server.CreateObject("ADODB.Recordset")

	Set oRS = DConn.Execute( SQLStr, ,adCmdText )

	

	' Copy recordset into an array

	If Not oRS.EOF Then

		Response.Write("<a href=""")

		Response.Write( oRS("bannerAdURL") )

		Response.Write("""><img src=""")

		Response.Write( oRS("bannerAdImgSrc") )

		Response.Write(""" height=""")

		Response.Write( oRS("bannerAdImgHeight") )

		Response.Write(""" width=""")

		Response.Write( oRS("bannerAdImgWidth") )

		Response.Write(""" border=""0""></a>")

	Else

		' No ads in table

	End If

	

	' Close and terminate recordset object

	oRS.close

	set oRS = Nothing

End Function





' On the page where you want the add, include this ASP

Call GetBannerAd( MyConn )

%>



Note that this will write the first add only.  You could modify the

function to accept a parameter like the adID, or you could write

something to make it randomly pick which ad to print.  There are several

options, but I hope this helps you get started.



Regards,

Peter







> -----Original Message-----

> From: arshad siddiqui [mailto:ash_arshad@y...]

> Sent: Wednesday, January 16, 2002 7:37 AM

> To: ASP Databases

> Subject: [asp_databases] Re: BANNER

> 

> 

> Hi

> Actually I wanted to ask whetehr we can do it the

> database way so that we can store the image location

> in the database and then we can display it as a

> banner.

> Any way thanx for your help.

> Regards

> --Arshad--

> 

> --- Kim Iwan Hansen <kimiwan@k...> wrote:

> > <a href="bannerlink.htm"><img src="bannerimage.gif"

> > height="100" width="400"

> > border="0"></a>

> > 

> > (that's incl. the link)

> > 

> > anything else? :-)

> > 

> > -Kim

> > 

> > 

> > 

> > > -----Original Message-----

> > > From: arshad siddiqui

> > [mailto:ash_arshad@y...]

> > > Sent: 16. januar 2002 12:34

> > > To: ASP Databases

> > > Subject: [asp_databases] Re: BANNER

> > >

> > >

> > > Hi there,

> > > Can any one give me some idea how to put a banner

> > on

> > > my web site.

> > > Any help will be appreciated.

> > > Thanx

> > > Regards

> > > --Arshad--

> > >

> > >

> > > __________________________________________________

> > > Do You Yahoo!?

> > > Send FREE video emails in Yahoo! Mail!

> > > http://promo.yahoo.com/videomail/

> > >





> > > $subst('Email.Unsub').

> > >

> > 

> > 





> $subst('Email.Unsub').

> 

> 

> __________________________________________________

> Do You Yahoo!?

> Send FREE video emails in Yahoo! Mail!

> http://promo.yahoo.com/videomail/

> 




> $subst('Email.Unsub').

>

Return to Index

P2P Archives