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

[anncobb]

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]

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.

 

[anncobb]

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









- 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.

 

[Thomas A. Rowe]

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
==============================================

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









- 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]

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
==============================================

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.

- 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.- Hide quoted text -

- Show quoted text -

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

Thanks you for your help,
Ann

 

[Trevor Lawrence]

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 ?

 

[anncobb]

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

 

[Thomas A. Rowe]

What is the name of your recordset ?

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

http://www.Ecom-Data.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]

What is the name of your recordset ?

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

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









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

 

[anncobb]

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.

 

[Thomas A. Rowe]

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
==============================================

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]

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
==============================================








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 A. Rowe]

Go to my website below and contact me.

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

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

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
==============================================








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