Displaying two database results

Guest · Aug 8, 2007

maybe I am trying to hardto please the boss but what I am trying to do is

displaying the details of a datbase record and using the contents of a field
in that database as the search word to display all pictures in another db
that relate to the dispayed record.

I have the details listed and the second db on the same page (but am copying
and pasting the link) from the details area to the search field the pressing
search button.

Surely there is some coade that I can use to use field in the details area
to automatically search thelist below for associate records.

I will keep trying to sort this out and hopefully find a solution somewhere

Thanks in advance
Ruffred

Thomas A. Rowe · Aug 8, 2007

Post your query string.

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

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

Ronx · Aug 8, 2007

Take a look at
http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp
http://www.spiderwebwoman.com/tutorials/picklist.htm
and
http://support.microsoft.com/kb/318813

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

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

FrontPage Support: http://www.frontpagemvps.com/

Guest · Aug 8, 2007

The field in the details database that is displayed at the top of the page
has a field name - image_group. It is the contents of this field that
iscopy and pasted into the search field with a query as below

SELECT * FROM Gallery WHERE (Location_Trip LIKE '::Caption::')

Thomas A. Rowe · Aug 8, 2007

Ok, then in your next query use

"SELECT * FROM OtherDatabase WHERE (image_group = '" & fp_rs1("image_group") & "')"

"fp_rs1" is the name of the first recordset used by your first query, This recordset must have a
unique name.
--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

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

Guest · Aug 8, 2007

Not Quite sure what you mean maybe a bit brain dead at the momen as I have
been working on this all day. Here is the link to the page which show the
two dbs the top is the detail from the previous displayed list and below
picture gallery is the contents of the gallery. The image_group_title field
in the details (db name REPORTS - field name IMAGES) that should govern the
list below (db name GALLERY - field name IMAGES.

http://68.178.203.233/flyfish/cville/reports/editor/detail.asp?TripID=1

Regards
Tony

Thomas A. Rowe · Aug 8, 2007

Can you paste the complete code segments for both queries?

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

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

Guest · Aug 9, 2007

Thomas here you go. I have tried a few things but no luck hopefully this is
what you need and it isn't too big.

---------------------------------------------

<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a FrontPage Component. Do not
Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Reports -- Home</title>
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
</head>

<body bgcolor="#FFFFFF">



<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database
Results component on this page is unable to display database content. The
page must have a filename ending in '.asp', and the web must be hosted on a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM Reports WHERE TripID = ::TripID::"
fp_sDefault="TripID=0"
fp_sNoRecords="No records returned."
fp_sDataConn="cville"
fp_iMaxRecords=1
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&TripID=3&MemberID=3&Trip
Name=202&Location=202&Members_present=203&Guests=203&Trip
Date=135&Intro=203&Conditions=203&Best
Flies=203&Fishing=203&Images=202&Memorable Moments=203&Awards=203&"
fp_iDisplayCols=14
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>



<table BORDER=0 width="100%">

<tr>
<td colspan="3" align="center"><hr></td>
</tr>

<tr>
<td colspan="3" align="center">
<%=FP_FieldVal(fp_rs,"Trip Name")%></td>
</tr><tr>
<td colspan="3" align="center">
<%=FP_FieldVal(fp_rs,"Location")%></td>
</tr><tr>
<td colspan="3" align="center">
Trip Date 

<%=FP_FieldVal(fp_rs,"Trip Date")%></td>
</tr><tr>
<td width="99%" colspan="3"><hr></td>
</tr><tr>
<td width="47%" colspan="2">
 
Members</td>
<td width="52%">
Guests</td>
</tr><tr>
<td width="47%" colspan="2">
<%=FP_FieldVal(fp_rs,"Members_present")%></td>
<td width="52%">

<%=FP_FieldVal(fp_rs,"Guests")%></td>
</tr><tr>
<td colspan="3">
<hr></td>
</tr><tr>
<td colspan="3">
The Trip

<%=FP_FieldVal(fp_rs,"Intro")%></td>
</tr><tr>
<td width="99%" colspan="3"><hr></td>
</tr><tr>
<td width="21%">Conditions</td>
<td width="78%" colspan="2">

<%=FP_FieldVal(fp_rs,"Conditions")%></td>
</tr><tr>
<td width="99%" colspan="3"><hr></td>
</tr><tr>
<td width="21%">Best Flies</td>
<td width="78%" colspan="2">

<%=FP_FieldVal(fp_rs,"Best Flies")%></td>
</tr><tr>
<td width="99%" colspan="3"><hr></td>
</tr><tr>
<td width="21%">
The Fishing</td>
<td width="78%" colspan="2">

<%=FP_FieldVal(fp_rs,"Fishing")%></td>
</tr><tr>
<td width="99%" colspan="3"><hr></td>
</tr><tr>
<td width="21%">Memorable Moments</td>
<td width="78%" colspan="2">

<%=FP_FieldVal(fp_rs,"Memorable
Moments")%></td>
</tr><tr>
<td width="99%" colspan="3"><hr></td>
</tr>

<tr>
<td width="21%">Awards</td>
<td width="78%" colspan="2">

<%=FP_FieldVal(fp_rs,"Awards")%></td>
</tr>

<tr>
<td width="99%" colspan="3"><hr></td>
</tr>

<tr>
<td width="21%">Image
Group Title</td>
<td width="78%" colspan="2">


<%=FP_FieldVal(fp_rs,"Images")%></a></td>
</tr>

<tr>
<td width="99%" colspan="3">
</td>
</tr>

</table>



<table border="0" width="100%" id="table1">
<tr>
<td><hr></td>
</tr>
<tr>
<td>Trip
Images</td>
</tr>
</table>

<table width="100%" border="0" cellpadding="2" id="table2">
<thead>
<tr>
<th style="color: #FFFFFF" bgcolor="#000000">

Image</th>
<th style="color: #FFFFFF" bgcolor="#000000">

Location/Trip</th>
<th style="color: #FFFFFF" bgcolor="#000000">

Caption</th>
<th style="color: #FFFFFF" bgcolor="#000000">

Date</th>
</tr>
</thead>
<tbody>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database
Results component on this page is unable to display database content. The
page must have a filename ending in '.asp', and the web must be hosted on a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM Gallery WHERE (location_trip like (Reports(Images))"
fp_sDefault="Caption=&Caption=&Caption="
fp_sNoRecords="<tr><td colspan=4 align=""LEFT"" width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="cville"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="Caption"
fp_sMenuValue="Caption"
fp_sColTypes="&PhotoID=3&MemberID=3&Location_Trip=202&Photo=202&Caption=202&Description=203&Date=135&"
fp_iDisplayCols=4
fp_fCustomQuery=False
BOTID=1
fp_iRegion=BOTID
%>

<tr>
<td align="left" valign="top">

<img border="2"
src="http://68.178.203.233/ffo_cv/cv_images/th<%=FP_FieldLink(fp_rs,"Photo")%>" width="75"></td>
<td align="left" valign="top">
<a href="detail.asp?PhotoID=<%=FP_FieldURL(fp_rs,"PhotoID")%>"
target="_self">



<%=FP_FieldVal(fp_rs,"Caption")%></td>
<td align="left" valign="top">


<%=FP_FieldVal(fp_rs,"Location_Trip")%></td>
<td align="left" valign="top">

<%=FP_FieldVal(fp_rs,"Date")%></td>
</tr>

</tbody>
</table>

</body>

</html>

-----------------------------------------------

Thomas A. Rowe · Aug 9, 2007

I think you are going to have to learn to write your own ASP/VBScript unless someone that use the FP
database component can help you.

Here is how I would do it via hand written ASP/VBScript:

<%
TripID = Request.Form("TripID")

set ReportRS = server.CreateObject("ADODB.Recordset")
ReportSQL = "SELECT * FROM Reports WHERE TripID = '" & TripID & "'"
ReportRS.Open ReportSQL, Conn

ImageID = ReportRS("Images")

set GalleryRS = server.CreateObject("ADODB.Recordset")
GallerySQL = "SELECT * FROM Gallery WHERE location_trip = '" & ImageID & "'"
GalleryRS.Open GallerySQL, Conn
%>
--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

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

Ruffred said:
Thomas here you go. I have tried a few things but no luck hopefully this is
what you need and it isn't too big.

---------------------------------------------

<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a FrontPage Component. Do not
Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Reports -- Home</title>
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
</head>

<body bgcolor="#FFFFFF">



<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database
Results component on this page is unable to display database content. The
page must have a filename ending in '.asp', and the web must be hosted on a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM Reports WHERE TripID = ::TripID::"
fp_sDefault="TripID=0"
fp_sNoRecords="No records returned."
fp_sDataConn="cville"
fp_iMaxRecords=1
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&TripID=3&MemberID=3&Trip
Name=202&Location=202&Members_present=203&Guests=203&Trip
Date=135&Intro=203&Conditions=203&Best
Flies=203&Fishing=203&Images=202&Memorable Moments=203&Awards=203&"
fp_iDisplayCols=14
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>



<table BORDER=0 width="100%">

<tr>
<td colspan="3" align="center"><hr></td>
</tr>

<tr>
<td colspan="3" align="center">
<%=FP_FieldVal(fp_rs,"Trip Name")%></td>
</tr><tr>
<td colspan="3" align="center">
<%=FP_FieldVal(fp_rs,"Location")%></td>
</tr><tr>
<td colspan="3" align="center">
Trip Date 

<%=FP_FieldVal(fp_rs,"Trip Date")%></td>
</tr><tr>
<td width="99%" colspan="3"><hr></td>
</tr><tr>
<td width="47%" colspan="2">
 
Members</td>
<td width="52%">
Guests</td>
</tr><tr>
<td width="47%" colspan="2">
<%=FP_FieldVal(fp_rs,"Members_present")%></td>
<td width="52%">

<%=FP_FieldVal(fp_rs,"Guests")%></td>
</tr><tr>
<td colspan="3">
<hr></td>
</tr><tr>
<td colspan="3">
The Trip

<%=FP_FieldVal(fp_rs,"Intro")%></td>
</tr><tr>
<td width="99%" colspan="3"><hr></td>
</tr><tr>
<td width="21%">Conditions</td>
<td width="78%" colspan="2">

<%=FP_FieldVal(fp_rs,"Conditions")%></td>
</tr><tr>
<td width="99%" colspan="3"><hr></td>
</tr><tr>
<td width="21%">Best Flies</td>
<td width="78%" colspan="2">

<%=FP_FieldVal(fp_rs,"Best Flies")%></td>
</tr><tr>
<td width="99%" colspan="3"><hr></td>
</tr><tr>
<td width="21%">
The Fishing</td>
<td width="78%" colspan="2">

<%=FP_FieldVal(fp_rs,"Fishing")%></td>
</tr><tr>
<td width="99%" colspan="3"><hr></td>
</tr><tr>
<td width="21%">Memorable Moments</td>
<td width="78%" colspan="2">

<%=FP_FieldVal(fp_rs,"Memorable
Moments")%></td>
</tr><tr>
<td width="99%" colspan="3"><hr></td>
</tr>

<tr>
<td width="21%">Awards</td>
<td width="78%" colspan="2">

<%=FP_FieldVal(fp_rs,"Awards")%></td>
</tr>

<tr>
<td width="99%" colspan="3"><hr></td>
</tr>

<tr>
<td width="21%">Image
Group Title</td>
<td width="78%" colspan="2">


<%=FP_FieldVal(fp_rs,"Images")%></a></td>
</tr>

<tr>
<td width="99%" colspan="3">
</td>
</tr>

</table>



<table border="0" width="100%" id="table1">
<tr>
<td><hr></td>
</tr>
<tr>
<td>Trip
Images</td>
</tr>
</table>

<table width="100%" border="0" cellpadding="2" id="table2">
<thead>
<tr>
<th style="color: #FFFFFF" bgcolor="#000000">

Image</th>
<th style="color: #FFFFFF" bgcolor="#000000">

Location/Trip</th>
<th style="color: #FFFFFF" bgcolor="#000000">

Caption</th>
<th style="color: #FFFFFF" bgcolor="#000000">

Date</th>
</tr>
</thead>
<tbody>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database
Results component on this page is unable to display database content. The
page must have a filename ending in '.asp', and the web must be hosted on a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM Gallery WHERE (location_trip like (Reports(Images))"
fp_sDefault="Caption=&Caption=&Caption="
fp_sNoRecords="<tr><td colspan=4 align=""LEFT"" width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="cville"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="Caption"
fp_sMenuValue="Caption"
fp_sColTypes="&PhotoID=3&MemberID=3&Location_Trip=202&Photo=202&Caption=202&Description=203&Date=135&"
fp_iDisplayCols=4
fp_fCustomQuery=False
BOTID=1
fp_iRegion=BOTID
%>

<tr>
<td align="left" valign="top">

<img border="2"
src="http://68.178.203.233/ffo_cv/cv_images/th<%=FP_FieldLink(fp_rs,"Photo")%>"
width="75"></td>
<td align="left" valign="top">
<a href="detail.asp?PhotoID=<%=FP_FieldURL(fp_rs,"PhotoID")%>"
target="_self">



<%=FP_FieldVal(fp_rs,"Caption")%></td>
<td align="left" valign="top">


<%=FP_FieldVal(fp_rs,"Location_Trip")%></td>
<td align="left" valign="top">

<%=FP_FieldVal(fp_rs,"Date")%></td>
</tr>

</tbody>
</table>

</body>

</html>

-----------------------------------------------

Thomas A. Rowe said:

Ok, then in your next query use

"SELECT * FROM OtherDatabase WHERE (image_group = '" & fp_rs1("image_group") & "')"

"fp_rs1" is the name of the first recordset used by your first query, This recordset must have a
unique name.
--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

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

Click to expand...

Links in Database results	1	Mar 27, 2007
Searching database	2	Feb 9, 2007
ASP Pages	4	Nov 13, 2004
Can'y get a new database to work	5	Sep 4, 2006
database search	1	May 22, 2007
Monthly Inspection Database	0	Jan 31, 2014
Database Design	2	Feb 2, 2009
Dynamic ControlTip Text?	6	Feb 9, 2009

Displaying two database results

Guest

Thomas A. Rowe

Ronx

Guest

Thomas A. Rowe

Guest

Thomas A. Rowe

Guest

Thomas A. Rowe

Ask a Question

Similar Threads