ASP Question - Images ...

[Suburbiana68]

I am designing a website that is based from an Access database; in the
database I have a table called "Categories" with fields called "Category"
and "CategoryPic".
On my index page I have coding to get the list of Categories, called
rsCategories. What I am attempting to do is create ASP code that would
retrieve an associated GIF file from my images folder when a particular
"Category" is chosen (ie. if you choose CategoryA from the recordset, then
CategoryA.gif would appear on the page, CategoryB would retrieve
CategoryB.gif, etc.).

Can anyone kindly assist me in completing this one piece of code that is
driving me nuts?

Thanks in advance,
Craig

[Jeff Clark]

show us what you have so far,
but generally it is this:

<img src = "<%= rsCategories("CategoryPic") %>.gif" border=0 >

Notice that I beat "Ray at Home" at helping you out here.


"Suburbiana68" <suburbiana68@hotmail.com> wrote in message
news:oiolb.143481$6C4.9369@pd7tw1no...

> I am designing a website that is based from an Access database; in the
> database I have a table called "Categories" with fields called "Category"
> and "CategoryPic".
> On my index page I have coding to get the list of Categories, called
> rsCategories. What I am attempting to do is create ASP code that would
> retrieve an associated GIF file from my images folder when a particular
> "Category" is chosen (ie. if you choose CategoryA from the recordset, then
> CategoryA.gif would appear on the page, CategoryB would retrieve
> CategoryB.gif, etc.).
>
> Can anyone kindly assist me in completing this one piece of code that is
> driving me nuts?
>
> Thanks in advance,
> Craig
>
>

[JohnBon]

Maybe you can do like this:

response.write "<img src='../imagefolder/"& rsCategories("Category") &".gif'>"



/Johnbon

"Suburbiana68" <suburbiana68@hotmail.com> wrote in message news:<oiolb.143481$6C4.9369@pd7tw1no>...

> I am designing a website that is based from an Access database; in the
> database I have a table called "Categories" with fields called "Category"
> and "CategoryPic".
> On my index page I have coding to get the list of Categories, called
> rsCategories. What I am attempting to do is create ASP code that would
> retrieve an associated GIF file from my images folder when a particular
> "Category" is chosen (ie. if you choose CategoryA from the recordset, then
> CategoryA.gif would appear on the page, CategoryB would retrieve
> CategoryB.gif, etc.).
>
> Can anyone kindly assist me in completing this one piece of code that is
> driving me nuts?
>
> Thanks in advance,
> Craig

[Suburbiana68]

Thanks Jeff and Jon, still don't seem to get any response, just errors ...
here is what I originally had:

<img src="/images/headergifs/<%=rsCategories.FieldValue("CategoryPic",
Container) %>" alt="Category Pic" width="79" height="79" border="0"
id="categoryPics" />

Which delivers the error:
Error Type:
Microsoft VBScript runtime (0x800A01A8)
Object required: ''

from that line of code.

I'm still bamboozled, kind of new at the programming side of this ... again
thanks in advance for any assistance.
Craig

"Jeff Clark" <JeffC@NO_SPAMreturnventures.com> wrote in message
news:Okr22gHmDHA.1488@TK2MSFTNGP12.phx.gbl...

> show us what you have so far,
> but generally it is this:
>
> <img src = "<%= rsCategories("CategoryPic") %>.gif" border=0 >
>
> Notice that I beat "Ray at Home" at helping you out here.
>
>
> "Suburbiana68" <suburbiana68@hotmail.com> wrote in message
> news:oiolb.143481$6C4.9369@pd7tw1no...

> > I am designing a website that is based from an Access database; in the
> > database I have a table called "Categories" with fields called

"Category"

> > and "CategoryPic".
> > On my index page I have coding to get the list of Categories, called
> > rsCategories. What I am attempting to do is create ASP code that would
> > retrieve an associated GIF file from my images folder when a particular
> > "Category" is chosen (ie. if you choose CategoryA from the recordset,

then

> > CategoryA.gif would appear on the page, CategoryB would retrieve
> > CategoryB.gif, etc.).
> >
> > Can anyone kindly assist me in completing this one piece of code that is
> > driving me nuts?
> >
> > Thanks in advance,
> > Craig
> >
> >

>
>

[Jeff Clark]

oh well did you do a set statement for the rsCategories?

set rsCategories = server.createobject("adodb.recordset")

also, maybe you have no records returned. did you test for that?



"Suburbiana68" <suburbiana68@hotmail.com> wrote in message
news:8evlb.147467$pl3.61154@pd7tw3no...

> Thanks Jeff and Jon, still don't seem to get any response, just errors ...
> here is what I originally had:
>
> <img src="/images/headergifs/<%=rsCategories.FieldValue("CategoryPic",
> Container) %>" alt="Category Pic" width="79" height="79" border="0"
> id="categoryPics" />
>
> Which delivers the error:
> Error Type:
> Microsoft VBScript runtime (0x800A01A8)
> Object required: ''
>
> from that line of code.
>
> I'm still bamboozled, kind of new at the programming side of this ...

again

> thanks in advance for any assistance.
> Craig
>
> "Jeff Clark" <JeffC@NO_SPAMreturnventures.com> wrote in message
> news:Okr22gHmDHA.1488@TK2MSFTNGP12.phx.gbl...

> > show us what you have so far,
> > but generally it is this:
> >
> > <img src = "<%= rsCategories("CategoryPic") %>.gif" border=0 >
> >
> > Notice that I beat "Ray at Home" at helping you out here.
> >
> >
> > "Suburbiana68" <suburbiana68@hotmail.com> wrote in message
> > news:oiolb.143481$6C4.9369@pd7tw1no...

> > > I am designing a website that is based from an Access database; in the
> > > database I have a table called "Categories" with fields called

> "Category"

> > > and "CategoryPic".
> > > On my index page I have coding to get the list of Categories, called
> > > rsCategories. What I am attempting to do is create ASP code that

would

> > > retrieve an associated GIF file from my images folder when a

particular

> > > "Category" is chosen (ie. if you choose CategoryA from the recordset,

> then

> > > CategoryA.gif would appear on the page, CategoryB would retrieve
> > > CategoryB.gif, etc.).
> > >
> > > Can anyone kindly assist me in completing this one piece of code that

is

> > > driving me nuts?
> > >
> > > Thanks in advance,
> > > Craig
> > >
> > >

> >
> >

>
>