How to display a picture by using an Access database in FrontPage

I have FP 2003 and Access Database 2003 and unable to get photo to
show in my web. I have gone to Ms Support and followed their
instructions to no avail (http://support.microsoft.com/kb/825515).
I've read the posts in this form and have put my photo in a file in my
web outside the database (fpdb). I just don't know how to put the
image script into my DRW to get it to work. I've been working on this
for 3 weeks - my other data results appear ok. Any help is greately
appreciated.

my error message: ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested
name or ordinal.

/_fpclass/fpdblib.inc, line 48

Ronx
Tue Feb 12 04:07:06 CST 2008

Sounds like you are trying to display the contents of a field that does
not exist. Check the names of the fields in the database against the
names of the fields being used in the script on your page.

--
Ron Symonds - Microsoft MVP (FrontPage)
Reply only to group - emails will be deleted unread.

http://www.rxs-enterprises.org/fp




"anncobb@q.com" <anncobb@q.com> wrote in message
news:2848b183-2acd-45ab-a4c6-865da6c2fc6c@s13g2000prd.googlegroups.com:

> I have FP 2003 and Access Database 2003 and unable to get photo to
> show in my web. I have gone to Ms Support and followed their
> instructions to no avail (http://support.microsoft.com/kb/825515).
> I've read the posts in this form and have put my photo in a file in my
> web outside the database (fpdb). I just don't know how to put the
> image script into my DRW to get it to work. I've been working on this
> for 3 weeks - my other data results appear ok. Any help is greately
> appreciated.
>
> my error message: ADODB.Recordset error '800a0cc1'
>
> Item cannot be found in the collection corresponding to the requested
> name or ordinal.
>
> /_fpclass/fpdblib.inc, line 48

anncobb
Tue Feb 12 09:12:03 CST 2008

On Feb 12, 3:07=A0am, "Ronx" <ronx...@hotmail.com> wrote:
> Sounds like you are trying to display the contents of a field that does
> not exist. =A0Check the names of the fields in the database against the
> names of the fields being used in the script on your page.
>
> --
> Ron Symonds - Microsoft MVP (FrontPage)
> Reply only to group - emails will be deleted unread.
>
> http://www.rxs-enterprises.org/fp
>
> "annc...@q.com" <annc...@q.com> wrote in message
>
> news:2848b183-2acd-45ab-a4c6-865da6c2fc6c@s13g2000prd.googlegroups.com:
>
>
>
> > I have FP 2003 and Access Database 2003 and unable to get photo to
> > show in my web. =A0I have gone to Ms Support and followed their
> > instructions to no avail (http://support.microsoft.com/kb/825515).
> > I've read the posts in this form and have put my photo in a file in my
> > web outside the database (fpdb). =A0I just don't know how to put the
> > image script into my DRW to get it to work. =A0I've been working on this=

> > for 3 weeks - my other data results appear ok. =A0Any help is greately
> > appreciated.
>
> > my error message: =A0ADODB.Recordset error '800a0cc1'
>
> > Item cannot be found in the collection corresponding to the requested
> > name or ordinal.
>
> > /_fpclass/fpdblib.inc, line 48- Hide quoted text -
>
> - Show quoted text -

I know I'm doing something wrong - I'm trying to do this as posted in
this forum: Don't put the pictures in the database. Upload the
pictures as files, and put
the *file names* in the database.

To make the Database Results Wizard display the pictures, set up a
custom
query that begins like this:


SELECT '<img src=3D"'images/&[picfilename]&'">' as pictag, ...


and report the pictag field. Then, when the DRW conmpletes, right-
click
<<pictag>>, choose Database Column Value Properties, and select Column
Value
Contains HTML.


I have my database set up with the names of the pic only
ImagesDeceased/mycat.jpg

ImagesDeceased is folder in the web outside of the database and I
named the filed in my table picfilename

how do i set up the custom query and what path would I use? would it
be like below?
SELECT '<img src=3D"ImagesDeceased/&[mycat]&""> as pictag


And how do i report the pictag field?

My operating system is Vista, I'm using FrontPage and Access 2003.

My other results appear just fine - it is the picture I just am lost
with.

Thanks in Advance for any help.

Thomas
Tue Feb 12 09:57:48 CST 2008

Try placing the following on your page where you want the image to be displayed:


<img src="ImagesDeceased/<%=fp_rs("picfilenamefieldname")%>...


--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================


<anncobb@q.com> wrote in message
news:f63d2c6e-599d-4e24-813b-8dd91f4eb5a1@s8g2000prg.googlegroups.com...
On Feb 12, 3:07 am, "Ronx" <ronx...@hotmail.com> wrote:
> Sounds like you are trying to display the contents of a field that does
> not exist. Check the names of the fields in the database against the
> names of the fields being used in the script on your page.
>
> --
> Ron Symonds - Microsoft MVP (FrontPage)
> Reply only to group - emails will be deleted unread.
>
> http://www.rxs-enterprises.org/fp
>
> "annc...@q.com" <annc...@q.com> wrote in message
>
> news:2848b183-2acd-45ab-a4c6-865da6c2fc6c@s13g2000prd.googlegroups.com:
>
>
>
> > I have FP 2003 and Access Database 2003 and unable to get photo to
> > show in my web. I have gone to Ms Support and followed their
> > instructions to no avail (http://support.microsoft.com/kb/825515).
> > I've read the posts in this form and have put my photo in a file in my
> > web outside the database (fpdb). I just don't know how to put the
> > image script into my DRW to get it to work. I've been working on this
> > for 3 weeks - my other data results appear ok. Any help is greately
> > appreciated.
>
> > my error message: ADODB.Recordset error '800a0cc1'
>
> > Item cannot be found in the collection corresponding to the requested
> > name or ordinal.
>
> > /_fpclass/fpdblib.inc, line 48- Hide quoted text -
>
> - Show quoted text -

I know I'm doing something wrong - I'm trying to do this as posted in
this forum: Don't put the pictures in the database. Upload the
pictures as files, and put
the *file names* in the database.

To make the Database Results Wizard display the pictures, set up a
custom
query that begins like this:


SELECT '<img src="'images/&[picfilename]&'">' as pictag, ...


and report the pictag field. Then, when the DRW conmpletes, right-
click
<<pictag>>, choose Database Column Value Properties, and select Column
Value
Contains HTML.


I have my database set up with the names of the pic only
ImagesDeceased/mycat.jpg

ImagesDeceased is folder in the web outside of the database and I
named the filed in my table picfilename

how do i set up the custom query and what path would I use? would it
be like below?
SELECT '<img src="ImagesDeceased/&[mycat]&""> as pictag


And how do i report the pictag field?

My operating system is Vista, I'm using FrontPage and Access 2003.

My other results appear just fine - it is the picture I just am lost
with.

Thanks in Advance for any help.

anncobb
Tue Feb 12 12:40:02 CST 2008

On Feb 12, 8:57=A0am, "Thomas A. Rowe" <tar...@mvps.org> wrote:
> Try placing the following on your page where you want the image to be disp=
layed:
>
> <img src=3D"ImagesDeceased/<%=3Dfp_rs("picfilenamefieldname")%>...
>
> --
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> Thomas A. Rowe
> Microsoft MVP - FrontPage
>
> http://www.Ecom-Data.com
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>
> <annc...@q.com> wrote in message
>
> news:f63d2c6e-599d-4e24-813b-8dd91f4eb5a1@s8g2000prg.googlegroups.com...
> On Feb 12, 3:07 am, "Ronx" <ronx...@hotmail.com> wrote:
>
>
>
>
>
> > Sounds like you are trying to display the contents of a field that does
> > not exist. Check the names of the fields in the database against the
> > names of the fields being used in the script on your page.
>
> > --
> > Ron Symonds - Microsoft MVP (FrontPage)
> > Reply only to group - emails will be deleted unread.
>
> >http://www.rxs-enterprises.org/fp
>
> > "annc...@q.com" <annc...@q.com> wrote in message
>
> >news:2848b183-2acd-45ab-a4c6-865da6c2fc6c@s13g2000prd.googlegroups.com:
>
> > > I have FP 2003 and Access Database 2003 and unable to get photo to
> > > show in my web. I have gone to Ms Support and followed their
> > > instructions to no avail (http://support.microsoft.com/kb/825515).
> > > I've read the posts in this form and have put my photo in a file in my=

> > > web outside the database (fpdb). I just don't know how to put the
> > > image script into my DRW to get it to work. I've been working on this
> > > for 3 weeks - my other data results appear ok. Any help is greately
> > > appreciated.
>
> > > my error message: ADODB.Recordset error '800a0cc1'
>
> > > Item cannot be found in the collection corresponding to the requested
> > > name or ordinal.
>
> > > /_fpclass/fpdblib.inc, line 48- Hide quoted text -
>
> > - Show quoted text -
>
> I know I'm doing something wrong - I'm trying to do this as posted in
> this forum: =A0Don't put the pictures in the database. Upload the
> pictures as files, and put
> the *file names* in the database.
>
> To make the Database Results Wizard display the pictures, set up a
> custom
> query that begins like this:
>
> SELECT '<img src=3D"'images/&[picfilename]&'">' as pictag, ...
>
> and report the pictag field. Then, when the DRW conmpletes, right-
> click
> <<pictag>>, choose Database Column Value Properties, and select Column
> Value
> Contains HTML.
>
> I have my database set up with the names of the pic only
> ImagesDeceased/mycat.jpg
>
> ImagesDeceased is folder in the web outside of the database and I
> named the filed in my table picfilename
>
> how do i set up the custom query and what path would I use? would it
> be like below?
> SELECT '<img src=3D"ImagesDeceased/&[mycat]&""> as pictag
>
> And how do i report the pictag field?
>
> My operating system is Vista, I'm using FrontPage and Access 2003.
>
> My other results appear just fine - it is the picture I just am lost
> with.
>
> Thanks in Advance for any help.- Hide quoted text -
>
> - Show quoted text -

Hi,

I tried placing the code as you suggested on my page <img
src=3D"ImagesDeceased/<%=3Dfp_rs("picfilenamefieldname")%>...
, but it only generated the same code when publilshed, then I tried
putting code in the code (html) of the page, and received the
following results and all my other results were gone:

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'fp_rs'

/Braten.asp, line 52

Thanks you for your help,
Ann

Trevor
Tue Feb 12 16:07:10 CST 2008


<anncobb@q.com> wrote in message
news:483a6e50-9767-4382-9960-a7ae850bebbe@s37g2000prg.googlegroups.com...
Hi,

I tried placing the code as you suggested on my page <img
src="ImagesDeceased/<%=fp_rs("picfilenamefieldname")%>...
, but it only generated the same code when publilshed, then I tried
putting code in the code (html) of the page, and received the
following results and all my other results were gone:

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'fp_rs'

/Braten.asp, line 52

Just a question

Did you change "picfilenamefieldname" to the *actual* fieldname on Access ?
--
Trevor Lawrence
Canberra
Microsoft MVP - FrontPage
MVP Web Site http://trevorl.mvps.org

anncobb
Tue Feb 12 18:51:56 CST 2008

On Feb 12, 3:07=A0pm, "Trevor Lawrence" <Trevor L.@Canberra> wrote:
> <annc...@q.com> wrote in message
>
> news:483a6e50-9767-4382-9960-a7ae850bebbe@s37g2000prg.googlegroups.com...
> Hi,
>
> I tried placing the code as you suggested on my page <img
> src=3D"ImagesDeceased/<%=3Dfp_rs("picfilenamefieldname")%>...
> , but it only generated the same code when publilshed, then I tried
> putting code in the code (html) of the page, and received the
> following results and all my other results were gone:
>
> Microsoft VBScript runtime error '800a000d'
>
> Type mismatch: 'fp_rs'
>
> /Braten.asp, line 52
>
> Just a question
>
> Did you change "picfilenamefieldname" to the *actual* fieldname on Access =
?
> --
> Trevor Lawrence
> Canberra
> Microsoft MVP - FrontPage
> MVP Web Sitehttp://trevorl.mvps.org

Thank you, yes I did change the actual field name in the script to the
field name I have in my table/query - the field for my pictures is
named picfilename and i tried putting the script in the code section
of my web and also just on my page. I get the following error message
when it is in the code(html) section of my web and all the other
results are missing:

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'fp_rs'

/Braten.asp, line 54

Thanks, Ann

Thomas
Wed Feb 13 06:56:48 CST 2008

What is the name of your recordset ?

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================


<anncobb@q.com> wrote in message
news:a81139db-9a1b-43ba-bc73-10f746811f5f@l32g2000hse.googlegroups.com...
On Feb 12, 3:07 pm, "Trevor Lawrence" <Trevor L.@Canberra> wrote:
> <annc...@q.com> wrote in message
>
> news:483a6e50-9767-4382-9960-a7ae850bebbe@s37g2000prg.googlegroups.com...
> Hi,
>
> I tried placing the code as you suggested on my page <img
> src="ImagesDeceased/<%=fp_rs("picfilenamefieldname")%>...
> , but it only generated the same code when publilshed, then I tried
> putting code in the code (html) of the page, and received the
> following results and all my other results were gone:
>
> Microsoft VBScript runtime error '800a000d'
>
> Type mismatch: 'fp_rs'
>
> /Braten.asp, line 52
>
> Just a question
>
> Did you change "picfilenamefieldname" to the *actual* fieldname on Access ?
> --
> Trevor Lawrence
> Canberra
> Microsoft MVP - FrontPage
> MVP Web Sitehttp://trevorl.mvps.org

Thank you, yes I did change the actual field name in the script to the
field name I have in my table/query - the field for my pictures is
named picfilename and i tried putting the script in the code section
of my web and also just on my page. I get the following error message
when it is in the code(html) section of my web and all the other
results are missing:

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'fp_rs'

/Braten.asp, line 54

Thanks, Ann

anncobb
Wed Feb 13 13:31:48 CST 2008

On Feb 13, 5:56=A0am, "Thomas A. Rowe" <tar...@mvps.org> wrote:
> What is the name of your recordset ?
>
> --
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> Thomas A. Rowe
> Microsoft MVP - FrontPage
>
> http://www.Ecom-Data.com
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>
> <annc...@q.com> wrote in message
>
> news:a81139db-9a1b-43ba-bc73-10f746811f5f@l32g2000hse.googlegroups.com...
> On Feb 12, 3:07 pm, "Trevor Lawrence" <Trevor L.@Canberra> wrote:
>
>
>
>
>
> > <annc...@q.com> wrote in message
>
> >news:483a6e50-9767-4382-9960-a7ae850bebbe@s37g2000prg.googlegroups.com...=

> > Hi,
>
> > I tried placing the code as you suggested on my page <img
> > src=3D"ImagesDeceased/<%=3Dfp_rs("picfilenamefieldname")%>...
> > , but it only generated the same code when publilshed, then I tried
> > putting code in the code (html) of the page, and received the
> > following results and all my other results were gone:
>
> > Microsoft VBScript runtime error '800a000d'
>
> > Type mismatch: 'fp_rs'
>
> > /Braten.asp, line 52
>
> > Just a question
>
> > Did you change "picfilenamefieldname" to the *actual* fieldname on Acces=
s ?
> > --
> > Trevor Lawrence
> > Canberra
> > Microsoft MVP - FrontPage
> > MVP Web Sitehttp://trevorl.mvps.org
>
> Thank you, yes I did change the actual field name in the script to the
> field name I have in my table/query =A0- the field for my pictures is
> named picfilename and i tried putting the script in the code section
> of my web and also just on my page. =A0I get the following error message
> when it is in the code(html) section of my web and all the other
> results are missing:
>
> Microsoft VBScript runtime error '800a000d'
>
> Type mismatch: 'fp_rs'
>
> /Braten.asp, line 54
>
> Thanks, =A0Ann- Hide quoted text -
>
> - Show quoted text -

My table name is Deceased, my query is DeceasedQuery, my database is
hampton, my images are kept in the web in folder called
ImagesDeceased, the field in query that holds the image is named
picfilename. the image in the field picfilename is ImagesDeceased/
Blossom.jpg.

thanks for your help and advice,

Ann

anncobb
Wed Feb 13 14:27:49 CST 2008

On Feb 13, 12:31=A0pm, annc...@q.com wrote:
> On Feb 13, 5:56=A0am, "Thomas A. Rowe" <tar...@mvps.org> wrote:
>
>
>
>
>
> > What is the name of your recordset ?
>
> > --
> > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> > Thomas A. Rowe
> > Microsoft MVP - FrontPage
>
> >http://www.Ecom-Data.com
> > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>
> > <annc...@q.com> wrote in message
>
> >news:a81139db-9a1b-43ba-bc73-10f746811f5f@l32g2000hse.googlegroups.com...=

> > On Feb 12, 3:07 pm, "Trevor Lawrence" <Trevor L.@Canberra> wrote:
>
> > > <annc...@q.com> wrote in message
>
> > >news:483a6e50-9767-4382-9960-a7ae850bebbe@s37g2000prg.googlegroups.com.=
..
> > > Hi,
>
> > > I tried placing the code as you suggested on my page <img
> > > src=3D"ImagesDeceased/<%=3Dfp_rs("picfilenamefieldname")%>...
> > > , but it only generated the same code when publilshed, then I tried
> > > putting code in the code (html) of the page, and received the
> > > following results and all my other results were gone:
>
> > > Microsoft VBScript runtime error '800a000d'
>
> > > Type mismatch: 'fp_rs'
>
> > > /Braten.asp, line 52
>
> > > Just a question
>
> > > Did you change "picfilenamefieldname" to the *actual* fieldname on Acc=
ess ?
> > > --
> > > Trevor Lawrence
> > > Canberra
> > > Microsoft MVP - FrontPage
> > > MVP Web Sitehttp://trevorl.mvps.org
>
> > Thank you, yes I did change the actual field name in the script to the
> > field name I have in my table/query =A0- the field for my pictures is
> > named picfilename and i tried putting the script in the code section
> > of my web and also just on my page. =A0I get the following error message=

> > when it is in the code(html) section of my web and all the other
> > results are missing:
>
> > Microsoft VBScript runtime error '800a000d'
>
> > Type mismatch: 'fp_rs'
>
> > /Braten.asp, line 54
>
> > Thanks, =A0Ann- Hide quoted text -
>
> > - Show quoted text -
>
> My table name is Deceased, my query is DeceasedQuery, my database is
> hampton, my images are kept in the web in folder called
> ImagesDeceased, the field in query that holds the image is named
> picfilename. =A0the image in the field picfilename is ImagesDeceased/
> Blossom.jpg.
>
> thanks for your help and advice,
>
> Ann- Hide quoted text -
>
> - Show quoted text -

Also, I use frontpage 2003, but I have office 2007 installed in
micosoft office and although the database is supposed to be in 2002-03
format - the database opens in access07, but it does state at the top
that the database is 02-03 access.

Thomas
Wed Feb 13 15:05:41 CST 2008

Can you paste in a reply the lines that are similar to:

Set RecordSet = Server.CreateObject("ADODB.Recordset")
SQL = "SELECT * FROM tablename"
RecordSet.Open SQL, DSN_Name
--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================


<anncobb@q.com> wrote in message
news:70762f49-201b-4e2b-ab48-2eba15bfbd20@d4g2000prg.googlegroups.com...
On Feb 13, 12:31 pm, annc...@q.com wrote:
> On Feb 13, 5:56 am, "Thomas A. Rowe" <tar...@mvps.org> wrote:
>
>
>
>
>
> > What is the name of your recordset ?
>
> > --
> > ==============================================
> > Thomas A. Rowe
> > Microsoft MVP - FrontPage
>
> >http://www.Ecom-Data.com
> > ==============================================
>
> > <annc...@q.com> wrote in message
>
> >news:a81139db-9a1b-43ba-bc73-10f746811f5f@l32g2000hse.googlegroups.com...
> > On Feb 12, 3:07 pm, "Trevor Lawrence" <Trevor L.@Canberra> wrote:
>
> > > <annc...@q.com> wrote in message
>
> > >news:483a6e50-9767-4382-9960-a7ae850bebbe@s37g2000prg.googlegroups.com...
> > > Hi,
>
> > > I tried placing the code as you suggested on my page <img
> > > src="ImagesDeceased/<%=fp_rs("picfilenamefieldname")%>...
> > > , but it only generated the same code when publilshed, then I tried
> > > putting code in the code (html) of the page, and received the
> > > following results and all my other results were gone:
>
> > > Microsoft VBScript runtime error '800a000d'
>
> > > Type mismatch: 'fp_rs'
>
> > > /Braten.asp, line 52
>
> > > Just a question
>
> > > Did you change "picfilenamefieldname" to the *actual* fieldname on Access ?
> > > --
> > > Trevor Lawrence
> > > Canberra
> > > Microsoft MVP - FrontPage
> > > MVP Web Sitehttp://trevorl.mvps.org
>
> > Thank you, yes I did change the actual field name in the script to the
> > field name I have in my table/query - the field for my pictures is
> > named picfilename and i tried putting the script in the code section
> > of my web and also just on my page. I get the following error message
> > when it is in the code(html) section of my web and all the other
> > results are missing:
>
> > Microsoft VBScript runtime error '800a000d'
>
> > Type mismatch: 'fp_rs'
>
> > /Braten.asp, line 54
>
> > Thanks, Ann- Hide quoted text -
>
> > - Show quoted text -
>
> My table name is Deceased, my query is DeceasedQuery, my database is
> hampton, my images are kept in the web in folder called
> ImagesDeceased, the field in query that holds the image is named
> picfilename. the image in the field picfilename is ImagesDeceased/
> Blossom.jpg.
>
> thanks for your help and advice,
>
> Ann- Hide quoted text -
>
> - Show quoted text -

Also, I use frontpage 2003, but I have office 2007 installed in
micosoft office and although the database is supposed to be in 2002-03
format - the database opens in access07, but it does state at the top
that the database is 02-03 access.

anncobb
Thu Feb 14 16:07:17 CST 2008

On Feb 13, 2:05=A0pm, "Thomas A. Rowe" <tar...@mvps.org> wrote:
> Can you paste in a reply the lines that are similar to:
>
> Set RecordSet =3D Server.CreateObject("ADODB.Recordset")
> SQL =3D "SELECT * FROM tablename"
> RecordSet.Open SQL, DSN_Name
> --
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> Thomas A. Rowe
> Microsoft MVP - FrontPage
>
> http://www.Ecom-Data.com
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>
> <annc...@q.com> wrote in message
>
> news:70762f49-201b-4e2b-ab48-2eba15bfbd20@d4g2000prg.googlegroups.com...
> On Feb 13, 12:31 pm, annc...@q.com wrote:
>
>
>
>
>
> > On Feb 13, 5:56 am, "Thomas A. Rowe" <tar...@mvps.org> wrote:
>
> > > What is the name of your recordset ?
>
> > > --
> > > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> > > Thomas A. Rowe
> > > Microsoft MVP - FrontPage
>
> > >http://www.Ecom-Data.com
> > > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>
> > > <annc...@q.com> wrote in message
>
> > >news:a81139db-9a1b-43ba-bc73-10f746811f5f@l32g2000hse.googlegroups.com.=
..
> > > On Feb 12, 3:07 pm, "Trevor Lawrence" <Trevor L.@Canberra> wrote:
>
> > > > <annc...@q.com> wrote in message
>
> > > >news:483a6e50-9767-4382-9960-a7ae850bebbe@s37g2000prg.googlegroups.co=
m...
> > > > Hi,
>
> > > > I tried placing the code as you suggested on my page <img
> > > > src=3D"ImagesDeceased/<%=3Dfp_rs("picfilenamefieldname")%>...
> > > > , but it only generated the same code when publilshed, then I tried
> > > > putting code in the code (html) of the page, and received the
> > > > following results and all my other results were gone:
>
> > > > Microsoft VBScript runtime error '800a000d'
>
> > > > Type mismatch: 'fp_rs'
>
> > > > /Braten.asp, line 52
>
> > > > Just a question
>
> > > > Did you change "picfilenamefieldname" to the *actual* fieldname on A=
ccess ?
> > > > --
> > > > Trevor Lawrence
> > > > Canberra
> > > > Microsoft MVP - FrontPage
> > > > MVP Web Sitehttp://trevorl.mvps.org
>
> > > Thank you, yes I did change the actual field name in the script to the=

> > > field name I have in my table/query - the field for my pictures is
> > > named picfilename and i tried putting the script in the code section
> > > of my web and also just on my page. I get the following error message
> > > when it is in the code(html) section of my web and all the other
> > > results are missing:
>
> > > Microsoft VBScript runtime error '800a000d'
>
> > > Type mismatch: 'fp_rs'
>
> > > /Braten.asp, line 54
>
> > > Thanks, Ann- Hide quoted text -
>
> > > - Show quoted text -
>
> > My table name is Deceased, my query is DeceasedQuery, my database is
> > hampton, my images are kept in the web in folder called
> > ImagesDeceased, the field in query that holds the image is named
> > picfilename. the image in the field picfilename is ImagesDeceased/
> > Blossom.jpg.
>
> > thanks for your help and advice,
>
> > Ann- Hide quoted text -
>
> > - Show quoted text -
>
> Also, I use frontpage 2003, but I have office 2007 installed in
> micosoft office and although the database is supposed to be in 2002-03
> format - the database opens in access07, but it does state at the top
> that the database is 02-03 access.- Hide quoted text -
>
> - Show quoted text -

I Just don't know how to get the record set information - I just not
familar with getting under the hood (I'm not a programer - just a
user) - but heck this is supposed to work and that is why I use FP and
Access. I've tried to figure out how to access the recordset by help,
google and forums, not not enough info given there to guide me through
this. Sorry for being inept. But I do need the help - I'm to
complete this website for funeral home - have missed deadline due to
this picture problem. Thanks again. Ann

Thomas
Thu Feb 14 17:13:35 CST 2008

Go to my website below and contact me.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================


<anncobb@q.com> wrote in message
news:b64c1545-bf1f-4b16-bf13-21fbdf500f5f@c23g2000hsa.googlegroups.com...
On Feb 13, 2:05 pm, "Thomas A. Rowe" <tar...@mvps.org> wrote:
> Can you paste in a reply the lines that are similar to:
>
> Set RecordSet = Server.CreateObject("ADODB.Recordset")
> SQL = "SELECT * FROM tablename"
> RecordSet.Open SQL, DSN_Name
> --
> ==============================================
> Thomas A. Rowe
> Microsoft MVP - FrontPage
>
> http://www.Ecom-Data.com
> ==============================================
>
> <annc...@q.com> wrote in message
>
> news:70762f49-201b-4e2b-ab48-2eba15bfbd20@d4g2000prg.googlegroups.com...
> On Feb 13, 12:31 pm, annc...@q.com wrote:
>
>
>
>
>
> > On Feb 13, 5:56 am, "Thomas A. Rowe" <tar...@mvps.org> wrote:
>
> > > What is the name of your recordset ?
>
> > > --
> > > ==============================================
> > > Thomas A. Rowe
> > > Microsoft MVP - FrontPage
>
> > >http://www.Ecom-Data.com
> > > ==============================================
>
> > > <annc...@q.com> wrote in message
>
> > >news:a81139db-9a1b-43ba-bc73-10f746811f5f@l32g2000hse.googlegroups.com...
> > > On Feb 12, 3:07 pm, "Trevor Lawrence" <Trevor L.@Canberra> wrote:
>
> > > > <annc...@q.com> wrote in message
>
> > > >news:483a6e50-9767-4382-9960-a7ae850bebbe@s37g2000prg.googlegroups.com...
> > > > Hi,
>
> > > > I tried placing the code as you suggested on my page <img
> > > > src="ImagesDeceased/<%=fp_rs("picfilenamefieldname")%>...
> > > > , but it only generated the same code when publilshed, then I tried
> > > > putting code in the code (html) of the page, and received the
> > > > following results and all my other results were gone:
>
> > > > Microsoft VBScript runtime error '800a000d'
>
> > > > Type mismatch: 'fp_rs'
>
> > > > /Braten.asp, line 52
>
> > > > Just a question
>
> > > > Did you change "picfilenamefieldname" to the *actual* fieldname on Access ?
> > > > --
> > > > Trevor Lawrence
> > > > Canberra
> > > > Microsoft MVP - FrontPage
> > > > MVP Web Sitehttp://trevorl.mvps.org
>
> > > Thank you, yes I did change the actual field name in the script to the
> > > field name I have in my table/query - the field for my pictures is
> > > named picfilename and i tried putting the script in the code section
> > > of my web and also just on my page. I get the following error message
> > > when it is in the code(html) section of my web and all the other
> > > results are missing:
>
> > > Microsoft VBScript runtime error '800a000d'
>
> > > Type mismatch: 'fp_rs'
>
> > > /Braten.asp, line 54
>
> > > Thanks, Ann- Hide quoted text -
>
> > > - Show quoted text -
>
> > My table name is Deceased, my query is DeceasedQuery, my database is
> > hampton, my images are kept in the web in folder called
> > ImagesDeceased, the field in query that holds the image is named
> > picfilename. the image in the field picfilename is ImagesDeceased/
> > Blossom.jpg.
>
> > thanks for your help and advice,
>
> > Ann- Hide quoted text -
>
> > - Show quoted text -
>
> Also, I use frontpage 2003, but I have office 2007 installed in
> micosoft office and although the database is supposed to be in 2002-03
> format - the database opens in access07, but it does state at the top
> that the database is 02-03 access.- Hide quoted text -
>
> - Show quoted text -

I Just don't know how to get the record set information - I just not
familar with getting under the hood (I'm not a programer - just a
user) - but heck this is supposed to work and that is why I use FP and
Access. I've tried to figure out how to access the recordset by help,
google and forums, not not enough info given there to guide me through
this. Sorry for being inept. But I do need the help - I'm to
complete this website for funeral home - have missed deadline due to
this picture problem. Thanks again. Ann