Problem in using Access queries in Frontpage

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
Wed Dec 31 12:05:07 CST 2003

>-----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
Thu Jan 01 10:31:15 CST 2004

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.
>>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)
|/---------------------------------------------------
*----------------------------------------------------

buyensj
Fri Jan 02 09:44:11 CST 2004

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 <sevket.celikkanat@zorlu.com> wrote in message news:<FBE46731-9257-4D19-8FA4-F2CAF968B8F1@microsoft.com>...
> 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.
> >>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
Sat Jan 03 15:46:21 CST 2004

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
|/--------------------------------------------------
*---------------------------------------------------




Sevket <sevket.celikkanat@zorlu.com> wrote in message news:<FBE46731-9257-4D19-8FA4-F2CAF968B8F1@microsoft.com>..
> 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
>> Sevke
>> 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_Altyaz
> 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.
>>>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 an
> click Edit
> 3. Select the entire SQL statement, copy it to th
> clipboard, and post it to this thread
> 4. Click Cancel and Cancel to exit the wizard withou
> making any changes
>> 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
> |/--------------------------------------------------
> *---------------------------------------------------

buyensj
Sat Jan 03 20:05:24 CST 2004

Sevket <sevket.celikkanat@zorlu.com> wrote in message news:<F0E50239-5522-4AF0-953E-88483BE2BC48@microsoft.com>...
> 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)
|/---------------------------------------------------
*----------------------------------------------------