Problem in using Access queries in Frontpage

[Sevket]

hello,

I use access database for content management. I linked
this database with the site using frontpage.

Eveything works fine. I can use access tables in the web
pages dynamically.

The problem is , if I use an access query which uses 3
tables , I get No records returned messages in the web
site. This query works fine in Access.

What might the problem is ?

Thank you ?

Sevket

 

[Jim Buyens]

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

hello,
Howdy.

I use access database for content management. I linked
this database with the site using frontpage.

Eveything works fine. I can use access tables in the web
pages dynamically.

The problem is , if I use an access query which uses 3
tables , I get No records returned messages in the web
site. This query works fine in Access.

What might the problem is ?

You'll need to provide more information. For starters:

1. Rerun the Database Results Wizard.
2. On page 2 of the wizard, select Custom Query and
click Edit.
3. Select the entire SQL statement, copy it to the
clipboard, and post it to this thread.
4. Click Cancel and Cancel to exit the wizard without
making any changes.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

 

[Sevket]

Hello Jim,

Here is my querys SQL view. If I dont attach A_MakaleFoto query works fine. If I attach that table I get no records returned error. As I said before , query works fine in MS Access.

Thank you.

Sevket

SELECT A_Makale.Mak_ID, A_Makale.Mak_Baslik, A_Makale.Yazar_ID, A_Makale.Mak_Tarih, A_Makale.Mak_Metin, A_Makale.Mak_Ozet, A_Makale.Mak_Durum, A_Makale.Mak_Dosya_Adi, A_Makale.Yay_Bas_Tarih, A_Makale.Yay_Bit_Tarih, A_Yazar.Yaz_Ad, A_Yazar.Yaz_Soyad, A_Yazar.Yaz_Unvan, A_Yazar.Yaz_ID, A_MakaleFoto.Resim_ID, A_MakaleFoto.Resim_Dosya_Adi, A_MakaleFoto.Resim_Altyazi
FROM (A_Yazar RIGHT JOIN A_Makale ON A_Yazar.Yaz_ID = A_Makale.Yazar_ID) LEFT JOIN A_MakaleFoto ON A_Makale.Mak_ID = A_MakaleFoto.Mak_ID;


----- Jim Buyens wrote: -----

-----Original Message-----
hello,
Howdy.

I use access database for content management. I linked
this database with the site using frontpage.
tables , I get No records returned messages in the web
site. This query works fine in Access.

You'll need to provide more information. For starters:

1. Rerun the Database Results Wizard.
2. On page 2 of the wizard, select Custom Query and
click Edit.
3. Select the entire SQL statement, copy it to the
clipboard, and post it to this thread.
4. Click Cancel and Cancel to exit the wizard without
making any changes.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

 

[Jim Buyens]

I meant for you to send the SQL statement that *didn't* work.

The A_MakaleFoto doesn't happpen to contain photographs, does it? You
have to go through a completely different set of gyrations to get
photographs out of a database and display them in a Web page.

Also, if the query works in Access, have you considered saving it in
Access and pointing the DRW to the saved query?

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

 

[Sevket]

Hello

A_MakaleFoto does have the image file names only. I linked the photo to the web page using this query
I create html hyperlink codes in Access queries. And directly attach this using DRW , with choosing ( This field includes html codes ) option

Also I used the saved query ( I prefer that ) but it doesnt work to

Please help. Thank you

Sevke



----- Jim Buyens wrote: ----

I meant for you to send the SQL statement that *didn't* work

The A_MakaleFoto doesn't happpen to contain photographs, does it? Yo
have to go through a completely different set of gyrations to ge
photographs out of a database and display them in a Web page

Also, if the query works in Access, have you considered saving it i
Access and pointing the DRW to the saved query

Jim Buyen
Microsoft FrontPage MV
http://www.interlacken.co
Author of
*---------------------------------------------------
|\--------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Ou
||--------------------------------------------------
|| Web Database Development Step by Step .NET Editio
|| Microsoft FrontPage Version 2002 Inside Ou
|| Faster Smarter Beginning Programmin
|| (All from Microsoft Press
|/--------------------------------------------------
*---------------------------------------------------

 

[Jim Buyens]

Hello ,

A_MakaleFoto does have the image file names only. I linked the photo to the web page using this query.
I create html hyperlink codes in Access queries. And directly attach this using DRW , with choosing ( This field includes html codes ) option.

Also I used the saved query ( I prefer that ) but it doesnt work too

Somehow, I'm still not getting the key piece of information that will
explain this.

o Is the problem still that zero records are returned?

o Is this page on the Web somewhere where I can see it?

o Are you sure that the Access database your Web site is using
is identicla to the database where the query works?

o Please send the failing SQL statement.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------