帮助，我该怎么做？ [英] HELP, How do I do this??
问题描述
这应该是相当基本的，但我不能想到如何做到这一点，而且我已经没时间了！
时间不多了！
我正在开发一个图片库，我无法弄清楚如何选择
one每个画廊的图片。我的数据库配置如下...
tbl_pictures
这包含图片库中的所有图片。
tbl_pictures_galleries
这包含了
客户端可以创建的所有图片库名称。它的主键在tbl_pictures
表中充当外键。
我的问题：我不知道如何选择最新的图片来自每个
图库（由FK识别）通过循环。这应该是这么简单但是
我现在没有看到它。
非常感谢帮助!!
谢谢!!!
This should be fairly basic but I can''t think of how to do this and I''m
running out of time!
I am developing a picture gallery and I can''t figure out how to select
"one" picture from each gallery. My DB is configured like this...
tbl_pictures
this contains all pictures in the picture gallery.
tbl_pictures_galleries
this contains all the picture gallery names that can be created by the
client. It''s primary key acts as a foreign key in the tbl_pictures
table.
My problem: I don''t know how to select the latest picture from each
gallery (identified by FK) via a loop. This should be so simple but
I''m just not seeing it right now.
Help greatly appreciated!!
Thanks!!!
推荐答案
http://www.aspfaq.com/5009
雷在家
另一个约翰 <き***** @ yahoo.com>在消息中写道
news：11 ********************** @ g14g2000cwa.googlegr oups.com ...
http://www.aspfaq.com/5009
Ray at home
"the other john" <ki*****@yahoo.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
这应该是相当基本的，但我不能想到如何做到这一点，而且我已经没时间了！
我正在开发一个图片库，我不知道如何选择
一个每个画廊的图片。我的数据库配置如下...
tbl_pictures
这包含图片库中的所有图片。
tbl_pictures_galleries
这包含所有图片库可以由
客户创建的名称。它的主键在tbl_pictures
表中充当外键。
我的问题：我不知道如何选择每个
画廊的最新图片（由FK识别）通过循环。这应该是如此简单但是我现在还没有看到它。
非常感谢帮助!!
谢谢!!!
This should be fairly basic but I can''t think of how to do this and I''m
running out of time!
I am developing a picture gallery and I can''t figure out how to select
"one" picture from each gallery. My DB is configured like this...
tbl_pictures
this contains all pictures in the picture gallery.
tbl_pictures_galleries
this contains all the picture gallery names that can be created by the
client. It''s primary key acts as a foreign key in the tbl_pictures
table.
My problem: I don''t know how to select the latest picture from each
gallery (identified by FK) via a loop. This should be so simple but
I''m just not seeing it right now.
Help greatly appreciated!!
Thanks!!!
糟糕 - 我以为他正在使用Access并为Access提供了解决方案。
要另一个约翰：
如果您不使用Access，则最后函数可能不存在于您正在使用的sql品牌
中。第二个例子是大多数
数据库中的一个。
Bob Barrows
Ray Costanzo [MVP]写道：
Oops - I assumed he was using Access and provided a solution for Access.
To "the other john":
if you are not using Access, the "Last" function may not exist in the brand
of sql you are using. The second example is the one that will work in most
databases.
Bob Barrows
Ray Costanzo [MVP] wrote:
http://www.aspfaq.com/5009
Ray在家里
另一个约翰 <き***** @ yahoo.com>在消息中写道
新闻：11 ********************** @ g14g2000cwa.googlegr oups.com ...
http://www.aspfaq.com/5009
Ray at home
"the other john" <ki*****@yahoo.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
这应该是相当基本的，但我不能想到如何做到这一点和
我已经没时间了！
我正在开发一个画廊，我可以''弄清楚如何选择一个每个画廊的图片。我的数据库配置如
这... tbl_pictures
这包含图片库中的所有图片。
tbl_pictures_galleries
这包含所有可以的图片库名称由客户创建。它的主键在
tbl_pictures表中充当外键。
我的问题：我不知道如何选择每个
画廊的最新图片（由FK识别）通过循环。这应该是如此简单但是我现在还没有看到它。
非常感谢帮助!!
谢谢!!!
This should be fairly basic but I can''t think of how to do this and
I''m running out of time!
I am developing a picture gallery and I can''t figure out how to
select "one" picture from each gallery. My DB is configured like
this... tbl_pictures
this contains all pictures in the picture gallery.
tbl_pictures_galleries
this contains all the picture gallery names that can be created by
the client. It''s primary key acts as a foreign key in the
tbl_pictures table.
My problem: I don''t know how to select the latest picture from each
gallery (identified by FK) via a loop. This should be so simple but
I''m just not seeing it right now.
Help greatly appreciated!!
Thanks!!!
-
Microsoft MVP - ASP / ASP.NET
请回复新闻组。这个电子邮件帐户是我的垃圾邮件陷阱所以我
不经常检查它。如果您必须离线回复，请删除
无垃圾邮件
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don''t check it very often. If you must reply off-line, then remove the
"NO SPAM"
您在Access上正确假设。我会试试这个，今天回来
。
You assumed correctly on the Access. I''ll try this out and get back
today.
这篇关于帮助，我该怎么做？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
