Access database query sorting

	Home Register Search Help Login

Sponsors

Hosting from $3.99 per month!

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions. dd

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Access database query sorting

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> Access database query sorting

Page: [1]


mjmtravel Posts: 272 Joined: 7/30/2006 Status: offline	Access database query sorting - 8/13/2006 0:52:23 I'm running front page 2003 and a access database. I would like to know how to filter a query with 2 separate search boxes. Example: I would like so sort a table, in a database, one box searching for a cruise (carnival) and another search box with the location (caribbean). I need to narrow down the results from the query. Both caribbean and carnival are in the same table. Is this possible. I have tried the directions from FP 2000, but they don't seem to work. Thank you very much


Spooky Posts: 26617 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: Access database query sorting - 8/13/2006 3:42:12 What is the SQL you have tried so far? (if you can post some of the database code we can see what youve tried) _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem ��k� Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to mjmtravel)


mjmtravel Posts: 272 Joined: 7/30/2006 Status: offline	RE: Access database query sorting - 8/29/2006 20:14:00 What I have tried so far is the article I found in your forums on filtering a database query by using a drop down box. Its for FP 2000, though. http://support.microsoft.com/default.aspx?scid=kb:EN-US:235554 I follow the instructions to the letter but nothing shows up in the drop down list box. I haven't been able to find a similar article for FP 2003, which is what I'm using. I can use a regular search form by typing in the text box and it finds all my information perfectly. My only problem is narrowing down my search. I don't know script at all so I'm banking on the software doing its thing. Any help? Thanks (in reply to Spooky)


mjmtravel Posts: 272 Joined: 7/30/2006 Status: offline	RE: Access database query sorting - 8/29/2006 20:17:30 Sorry, bad link. http://support.microsoft.com/default.aspx?scid=kb;EN-US;235554 (in reply to mjmtravel)


swoosh Posts: 1438 Joined: 5/18/2002 From: Beaver Falls, PA Status: offline	RE: Access database query sorting - 8/29/2006 20:28:32 I believe spooky is asking for Your code to the page in question.....not what you have tried with the software. Can you post the code from the page here? _____________________________ Swoooosh Just Do It! (in reply to mjmtravel)

mjmtravel

Posts: 272
Joined: 7/30/2006
Status: offline

RE: Access database query sorting - 8/29/2006 20:33:53

</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM ""Cruise Lines"""
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="CruiseLineName"
fp_sMenuValue="CruiseLineID"
fp_sColTypes="&CruiseLineID=3&CruiseLineName=202&ContactName=202&ContactTitle=202&Address=202&City=202&PostalCode=202&StateOrProvince=202&Country/Region=202&PhoneNumber=202&FaxNumber=202&PaymentTerms=202&EmailAddress=202&Notes=203&"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="58083" --><select NAME="CruiseLineID" SIZE="1">
																	<!--webbot bot="AspInclude" clientside u-incfile="_fpclass/fpdbrgn1.inc" startspan --><!--#include file="_fpclass/fpdbrgn1.inc"--><!--webbot bot="AspInclude" endspan i-checksum="62210" -->
																	<option VALUE="<%=FP_FieldHTML(fp_rs,"CruiseLineID")%>"><%=FP_FieldHTML(fp_rs,"CruiseLineName")%>
																	</option>
																	<!--webbot bot="AspInclude" clientside u-incfile="_fpclass/fpdbrgn2.inc" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"--><!--webbot bot="AspInclude" endspan i-checksum="62218" -->
																	</select><!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="TRUE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside preview=" <span style="color: rgb(0,0,0); background-color: rgb(255,255,0)">Results</span> " startspan --><!--webbot bot="DatabaseRegionEnd" endspan --></nobr></p>
																	<p>
																	<input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
																</form>
																<p>
											 </p>
																	<p>
																	 </p>
																<p> </p>
																<p> </td>
															</tr>
															</table>
													</td>
												</tr>
											</table>
										</td>
									</tr>
									<tr>
										<td valign="top" width="766" height="40">
										<input type="hidden" name="fpdbr_2_PagingMove" value="  |<  ">
										<input type="hidden" name="fpdbr_0_PagingMove" value="  |<  ">
											<input type="hidden" name="fpdbr_0_PagingMove" value="  |<  ">
											<!--webbot bot="DatabaseRegionStart" s-columnnames="ItinID,Itinerary,DestinationID,Destination,CruiseLineID,CruiseLineName,ShipID,Months,Year,PortsofCall,StartingFrom,ShipPicture,ItineraryPicture" s-columntypes="3,202,3,202,3,202,3,202,3,203,6,205,205" s-dataconnection="Database1" b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice="ItinID" s-menuvalue="ItinID" b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="5" b-makeform="FALSE" s-recordsource="Itineraries" s-displaycolumns="ItinID,Itinerary,DestinationID,Destination,CruiseLineID,CruiseLineName,ShipID,Months,Year,PortsofCall,StartingFrom,ShipPicture,ItineraryPicture" s-criteria="{CruiseLineID} EQ {CruiseLineID} +" s-order s-sql="SELECT * FROM Itineraries WHERE (CruiseLineID =  ::CruiseLineID::)" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="CruiseLineID=0" s-norecordsfound="No records returned." i-maxrecords="256" i-groupsize="5" botid="1" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><font color="#000000">This is the start of a Database Results region. The page must be fetched from a web server with a web browser to display correctly; the current web is stored on your local disk or network.</font></td></tr></table>" b-UseDotNET="FALSE" CurrentExt sa-InputTypes="3" b-DataGridFormat="FALSE" b-DGridAlternate="TRUE" sa-CritTypes="3" b-WasTableFormat="FALSE" startspan --><!--#include file="_fpclass/fpdblib.inc"-->
<% 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 Itineraries WHERE (CruiseLineID =  ::CruiseLineID::)"
fp_sDefault="CruiseLineID=0"
fp_sNoRecords="No records returned."
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice="ItinID"
fp_sMenuValue="ItinID"
fp_sColTypes="&ItinID=3&Itinerary=202&DestinationID=3&Destination=202&CruiseLineID=3&CruiseLineName=202&ShipID=3&Months=202&Year=3&PortsofCall=203&StartingFrom=6&ShipPicture=205&ItineraryPicture=205&"
fp_iDisplayCols=13
fp_fCustomQuery=False
BOTID=1
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="2600" --><table BORDER="1">
											<tr>
												<td><b>ItinID:</b></td>
												<td>
												<!--webbot bot="DatabaseResultColumn" s-columnnames="ItinID,Itinerary,DestinationID,Destination,CruiseLineID,CruiseLineName,ShipID,Months,Year,PortsofCall,StartingFrom,ShipPicture,ItineraryPicture" s-column="ItinID" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>ItinID<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"ItinID")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="15982" --></td>
											</tr>
											<tr>
												<td><b>Itinerary:</b></td>
												<td>
												<!--webbot bot="DatabaseResultColumn" s-columnnames="ItinID,Itinerary,DestinationID,Destination,CruiseLineID,CruiseLineName,ShipID,Months,Year,PortsofCall,StartingFrom,ShipPicture,ItineraryPicture" s-column="Itinerary" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Itinerary<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Itinerary")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="21961" --></td>
											</tr>
											<tr>
												<td><b>DestinationID:</b></td>
												<td>
												<!--webbot bot="DatabaseResultColumn" s-columnnames="ItinID,Itinerary,DestinationID,Destination,CruiseLineID,CruiseLineName,ShipID,Months,Year,PortsofCall,StartingFrom,ShipPicture,ItineraryPicture" s-column="DestinationID" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>DestinationID<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"DestinationID")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="34868" --></td>
											</tr>
											<tr>
												<td><b>Destination:</b></td>
												<td>
												<!--webbot bot="DatabaseResultColumn" s-columnnames="ItinID,Itinerary,DestinationID,Destination,CruiseLineID,CruiseLineName,ShipID,Months,Year,PortsofCall,StartingFrom,ShipPicture,ItineraryPicture" s-column="Destination" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Destination<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Destination")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="29890" --></td>
											</tr>
											<tr>
												<td><b>CruiseLineID:</b></td>
												<td>
												<!--webbot bot="DatabaseResultColumn" s-columnnames="ItinID,Itinerary,DestinationID,Destination,CruiseLineID,CruiseLineName,ShipID,Months,Year,PortsofCall,StartingFrom,ShipPicture,ItineraryPicture" s-column="CruiseLineID" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>CruiseLineID<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"CruiseLineID")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="31409" --></td>
											</tr>
											<tr>
												<td><b>CruiseLineName:</b></td>
												<td>
												<!--webbot bot="DatabaseResultColumn" s-columnnames="ItinID,Itinerary,DestinationID,Destination,CruiseLineID,CruiseLineName,ShipID,Months,Year,PortsofCall,StartingFrom,ShipPicture,ItineraryPicture" s-column="CruiseLineName" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>CruiseLineName<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"CruiseLineName")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="41836" --></td>
											</tr>
											<tr>
												<td><b>ShipID:</b></td>
												<td>
												<!--webbot bot="DatabaseResultColumn" s-columnnames="ItinID,Itinerary,DestinationID,Destination,CruiseLineID,CruiseLineName,ShipID,Months,Year,PortsofCall,StartingFrom,ShipPicture,ItineraryPicture" s-column="ShipID" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>ShipID<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"ShipID")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="15090" --></td>
											</tr>
											<tr>
												<td><b>Months:</b></td>
												<td>
												<!--webbot bot="DatabaseResultColumn" s-columnnames="ItinID,Itinerary,DestinationID,Destination,CruiseLineID,CruiseLineName,ShipID,Months,Year,PortsofCall,StartingFrom,ShipPicture,ItineraryPicture" s-column="Months" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Months<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Months")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="16115" --></td>
											</tr>
											<tr>
												<td><b>Year:</b></td>
												<td>
												<!--webbot bot="DatabaseResultColumn" s-columnnames="ItinID,Itinerary,DestinationID,Destination,CruiseLineID,CruiseLineName,ShipID,Months,Year,PortsofCall,StartingFrom,ShipPicture,ItineraryPicture" s-column="Year" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Year<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Year")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="5130" --></td>
											</tr>
											<tr>
												<td><b>PortsofCall:</b></td>
												<td>
												<!--webbot bot="DatabaseResultColumn" s-columnnames="ItinID,Itinerary,DestinationID,Destination,CruiseLineID,CruiseLineName,ShipID,Months,Year,PortsofCall,StartingFrom,ShipPicture,ItineraryPicture" s-column="PortsofCall" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>PortsofCall<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"PortsofCall")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="29599" --></td>
											</tr>
											<tr>
												<td><b>StartingFrom:</b></td>
												<td>
												<!--webbot bot="DatabaseResultColumn" s-columnnames="ItinID,Itinerary,DestinationID,Destination,CruiseLineID,CruiseLineName,ShipID,Months,Year,PortsofCall,StartingFrom,ShipPicture,ItineraryPicture" s-column="StartingFrom" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>StartingFrom<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"StartingFrom")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="32427" --></td>
											</tr>
											<tr>
												<td><b>ShipPicture:</b></td>
												<td>
												<!--webbot bot="DatabaseResultColumn" s-columnnames="ItinID,Itinerary,DestinationID,Destination,CruiseLineID,CruiseLineName,ShipID,Months,Year,PortsofCall,StartingFrom,ShipPicture,ItineraryPicture" s-column="ShipPicture" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>ShipPicture<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"ShipPicture")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="32251" --></td>
											</tr>
											<tr>
												<td><b>ItineraryPicture:</b></td>
												<td>
												<!--webbot bot="DatabaseResultColumn" s-columnnames="ItinID,Itinerary,DestinationID,Destination,CruiseLineID,CruiseLineName,ShipID,Months,Year,PortsofCall,StartingFrom,ShipPicture,ItineraryPicture" s-column="ItineraryPicture" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>ItineraryPicture<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"ItineraryPicture")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="41830" --></td>
											</tr>
										</table>
										<hr>
										<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="5" clientside tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><font color="#000000">This is the end of a Database Results region.</font></td></tr><TR><TD VALIGN=MIDDLE><NOBR><INPUT TYPE=Button VALUE="  |<  "><INPUT TYPE=Button VALUE="   <  "><INPUT TYPE=Button VALUE="  >   "><INPUT TYPE=Button VALUE="  >|  ">  [1/5]</NOBR><BR></td></tr></table>" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --><br>
											 <!--webbot bot="SaveAsASP" clientside suggestedext="asp" preview=" " startspan --><!--webbot bot="SaveAsASP" endspan --><input type="hidden" name="fpdbr_1_PagingMove" value="  |<  "><!--webbot bot="SaveAsASP" clientside suggestedext="asp" preview=" " startspan --><!--webbot bot="SaveAsASP" endspan --><input type="hidden" name="fpdbr_2_PagingMove" value="  |<  "></td>
									</tr>

< Message edited by BeTheBall -- 8/29/2006 22:39:40 >

(in reply to swoosh)


BeTheBall Posts: 6385 Joined: 6/21/2002 From: West Point Utah USA Status: offline	RE: Access database query sorting - 8/29/2006 22:03:08 Try renaming the database table without a space. Then redo the database results wizard. For example, rename Cruise Lines to CruiseLines. Spaces in table/field names can cause a myriad of problems. _____________________________ Duane Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs. (in reply to mjmtravel)


mjmtravel Posts: 272 Joined: 7/30/2006 Status: offline	RE: Access database query sorting - 8/29/2006 22:22:02 You were right, that little space prevented it from not finding the table. Now all I need to do is figure out why I'm not getting any results from the search, which is part 2 of the previous article link. (in reply to BeTheBall)


BeTheBall Posts: 6385 Joined: 6/21/2002 From: West Point Utah USA Status: offline	RE: Access database query sorting - 8/29/2006 22:39:05 Are you getting "No Records Returned" or an error message? _____________________________ Duane Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs. (in reply to mjmtravel)


mjmtravel Posts: 272 Joined: 7/30/2006 Status: offline	RE: Access database query sorting - 8/30/2006 17:17:22 I'm getting no records returned, but I can get the search to work doing a simple type in search box. It just don't seem to work with the drop down box type. (in reply to BeTheBall)


BeTheBall Posts: 6385 Joined: 6/21/2002 From: West Point Utah USA Status: offline	RE: Access database query sorting - 8/30/2006 18:46:32 Even though it hasn't changed much, please post the full code for the page once more. Maybe something will jump out. _____________________________ Duane Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs. (in reply to mjmtravel)

mjmtravel

Posts: 272
Joined: 7/30/2006
Status: offline

RE: Access database query sorting - 8/30/2006 19:04:53

Here it is, I have tried different ways to make it work again, with no luck. Thanks.

<!--webbot bot="DatabaseRegionStart" s-columnnames="CruiseLineID,CruiseLineName,ContactName,ContactTitle,Address,City,PostalCode,StateOrProvince,Country/Region,PhoneNumber,FaxNumber,PaymentTerms,EmailAddress,Notes" s-columntypes="3,202,202,202,202,202,202,202,202,202,202,202,202,203" s-dataconnection="Database1" b-tableformat="FALSE" b-menuformat="TRUE" s-menuchoice="CruiseLineName" s-menuvalue="CruiseLineID" b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="CruiseLines" s-displaycolumns="CruiseLineID,CruiseLineName" s-criteria s-order s-sql="SELECT * FROM CruiseLines" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="256" i-groupsize="0" botid="0" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" preview=" <span style="color: rgb(0,0,0); background-color: rgb(255,255,0)">Database</span> " startspan --><!--#include file="_fpclass/fpdblib.inc"-->
<% 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 CruiseLines"
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="CruiseLineName"
fp_sMenuValue="CruiseLineID"
fp_sColTypes="&CruiseLineID=3&CruiseLineName=202&ContactName=202&ContactTitle=202&Address=202&City=202&PostalCode=202&StateOrProvince=202&Country/Region=202&PhoneNumber=202&FaxNumber=202&PaymentTerms=202&EmailAddress=202&Notes=203&"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="32635" -->Choose your 
																	favorite 
																	Cruise Line
																	<select NAME="CruiseLineID" SIZE="1">
																	<!--webbot bot="AspInclude" clientside u-incfile="_fpclass/fpdbrgn1.inc" startspan --><!--#include file="_fpclass/fpdbrgn1.inc"--><!--webbot bot="AspInclude" endspan i-checksum="62210" -->
																	<option VALUE="<%=FP_FieldHTML(fp_rs,"CruiseLineID")%>"><%=FP_FieldHTML(fp_rs,"CruiseLineName")%>
																	</option>
																	<!--webbot bot="AspInclude" clientside u-incfile="_fpclass/fpdbrgn2.inc" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"--><!--webbot bot="AspInclude" endspan i-checksum="62218" -->
																	</select><!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="TRUE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside preview=" <span style="color: rgb(0,0,0); background-color: rgb(255,255,0)">Results</span> " startspan --><!--webbot bot="DatabaseRegionEnd" endspan --><br>
																	<!--webbot bot="DatabaseRegionStart" s-columnnames="Destination ID,Destination,CategoryID,SupplierID" s-columntypes="3,202,3,3" s-dataconnection="Database1" b-tableformat="FALSE" b-menuformat="TRUE" s-menuchoice="Destination" s-menuvalue="Destination ID" b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="Destinations" s-displaycolumns="Destination ID,Destination" s-criteria s-order s-sql="SELECT * FROM Destinations" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="256" i-groupsize="0" botid="1" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" preview=" <span style="color: rgb(0,0,0); background-color: rgb(255,255,0)">Database</span> " startspan --><!--#include file="_fpclass/fpdblib.inc"-->
<% 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 Destinations"
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="Destination"
fp_sMenuValue="Destination ID"
fp_sColTypes="&Destination ID=3&Destination=202&CategoryID=3&SupplierID=3&"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=1
fp_iRegion=BOTID
%>
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="36132" -->Choose your 
																	favorite 
																	Destination
																	<select NAME="Destination ID" SIZE="1">
																	<!--webbot bot="AspInclude" clientside u-incfile="_fpclass/fpdbrgn1.inc" startspan --><!--#include file="_fpclass/fpdbrgn1.inc"--><!--webbot bot="AspInclude" endspan i-checksum="62210" -->
																	<option VALUE="<%=FP_FieldHTML(fp_rs,"Destination ID")%>"><%=FP_FieldHTML(fp_rs,"Destination")%>
																	</option>
																	<!--webbot bot="AspInclude" clientside u-incfile="_fpclass/fpdbrgn2.inc" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"--><!--webbot bot="AspInclude" endspan i-checksum="62218" -->
																	</select><!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="TRUE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside preview=" <span style="color: rgb(0,0,0); background-color: rgb(255,255,0)">Results</span> " startspan --><!--webbot bot="DatabaseRegionEnd" endspan --></nobr></p>
																	<p>
																	<input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
																</form>
																<p>
											 </p>
																	<p>
																	 </p>
																<p> </p>
																<p> </td>
															</tr>
															</table>
													</td>
												</tr>
											</table>
										</td>
									</tr>
									<tr>
										<td valign="top" width="766" height="40">
										<input type="hidden" name="fpdbr_2_PagingMove" value="  |<  ">
										<input type="hidden" name="fpdbr_0_PagingMove" value="  |<  ">
											<input type="hidden" name="fpdbr_0_PagingMove" value="  |<  ">
											<!--webbot bot="DatabaseRegionStart" s-columnnames="ItinID,Itinerary,DestinationID,Destination,CruiseLineID,CruiseLineName,ShipID,Months,Year,PortsofCall,StartingFrom,ShipPicture,ItineraryPicture" s-columntypes="3,202,3,202,3,202,3,202,3,203,6,205,205" s-dataconnection="Database1" b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice="ItinID" s-menuvalue="ItinID" b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="5" b-makeform="FALSE" s-recordsource="Itineraries" s-displaycolumns="ItinID,Itinerary,DestinationID,Destination,CruiseLineID,CruiseLineName,ShipID,Months,Year,PortsofCall,StartingFrom,ShipPicture,ItineraryPicture" s-criteria="{CruiseLineID} EQ {CruiseLineID} + {DestinationID} EQ {DestinationID} |" s-order s-sql="SELECT * FROM Itineraries WHERE (CruiseLineID =  ::CruiseLineID:: AND DestinationID =  ::DestinationID::)" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="CruiseLineID=0&DestinationID=0" s-norecordsfound="No records returned." i-maxrecords="256" i-groupsize="5" botid="2" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><font color="#000000">This is the start of a Database Results region. The page must be fetched from a web server with a web browser to display correctly; the current web is stored on your local disk or network.</font></td></tr></table>" b-UseDotNET="FALSE" CurrentExt sa-InputTypes="3,3" b-DataGridFormat="FALSE" b-DGridAlternate="TRUE" sa-CritTypes="3,3" b-WasTableFormat="FALSE" startspan --><!--#include file="_fpclass/fpdblib.inc"-->
<% 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 Itineraries WHERE (CruiseLineID =  ::CruiseLineID:: AND DestinationID =  ::DestinationID::)"
fp_sDefault="CruiseLineID=0&DestinationID=0"
fp_sNoRecords="No records returned."
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice="ItinID"
fp_sMenuValue="ItinID"
fp_sColTypes="&ItinID=3&Itinerary=202&DestinationID=3&Destination=202&CruiseLineID=3&CruiseLineName=202&ShipID=3&Months=202&Year=3&PortsofCall=203&StartingFrom=6&ShipPicture=205&ItineraryPicture=205&"
fp_iDisplayCols=13
fp_fCustomQuery=False
BOTID=2
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="14767" --><table BORDER="1">
											<tr>
												<td><b>ItinID:</b></td>
												<td>
												<!--webbot bot="DatabaseResultColumn" s-columnnames="ItinID,Itinerary,DestinationID,Destination,CruiseLineID,CruiseLineName,ShipID,Months,Year,PortsofCall,StartingFrom,ShipPicture,ItineraryPicture" s-column="ItinID" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>ItinID<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"ItinID")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="15982" --></td>
											</tr>
											<tr>
												<td><b>Itinerary:</b></td>
												<td>
												<!--webbot bot="DatabaseResultColumn" s-columnnames="ItinID,Itinerary,DestinationID,Destination,CruiseLineID,CruiseLineName,ShipID,Months,Year,PortsofCall,StartingFrom,ShipPicture,ItineraryPicture" s-column="Itinerary" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Itinerary<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Itinerary")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="21961" --></td>
											</tr>
											<tr>
												<td><b>DestinationID:</b></td>
												<td>
												<!--webbot bot="DatabaseResultColumn" s-columnnames="ItinID,Itinerary,DestinationID,Destination,CruiseLineID,CruiseLineName,ShipID,Months,Year,PortsofCall,StartingFrom,ShipPicture,ItineraryPicture" s-column="DestinationID" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>DestinationID<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"DestinationID")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="34868" --></td>
											</tr>
											<tr>
												<td><b>Destination:</b></td>
												<td>
												<!--webbot bot="DatabaseResultColumn" s-columnnames="ItinID,Itinerary,DestinationID,Destination,CruiseLineID,CruiseLineName,ShipID,Months,Year,PortsofCall,StartingFrom,ShipPicture,ItineraryPicture" s-column="Destination" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Destination<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Destination")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="29890" --></td>
											</tr>
											<tr>
												<td><b>CruiseLineID:</b></td>
												<td>
												<!--webbot bot="DatabaseResultColumn" s-columnnames="ItinID,Itinerary,DestinationID,Destination,CruiseLineID,CruiseLineName,ShipID,Months,Year,PortsofCall,StartingFrom,ShipPicture,ItineraryPicture" s-column="CruiseLineID" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>CruiseLineID<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"CruiseLineID")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="31409" --></td>
											</tr>
											<tr>
												<td><b>CruiseLineName:</b></td>
												<td>
												<!--webbot bot="DatabaseResultColumn" s-columnnames="ItinID,Itinerary,DestinationID,Destination,CruiseLineID,CruiseLineName,ShipID,Months,Year,PortsofCall,StartingFrom,ShipPicture,ItineraryPicture" s-column="CruiseLineName" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>CruiseLineName<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"CruiseLineName")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="41836" --></td>
											</tr>
											<tr>
												<td><b>ShipID:</b></td>
												<td>
												<!--webbot bot="DatabaseResultColumn" s-columnnames="ItinID,Itinerary,DestinationID,Destination,CruiseLineID,CruiseLineName,ShipID,Months,Year,PortsofCall,StartingFrom,ShipPicture,ItineraryPicture" s-column="ShipID" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>ShipID<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"ShipID")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="15090" --></td>
											</tr>
											<tr>
												<td><b>Months:</b></td>
												<td>
												<!--webbot bot="DatabaseResultColumn" s-columnnames="ItinID,Itinerary,DestinationID,Destination,CruiseLineID,CruiseLineName,ShipID,Months,Year,PortsofCall,StartingFrom,ShipPicture,ItineraryPicture" s-column="Months" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Months<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Months")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="16115" --></td>
											</tr>
											<tr>
												<td><b>Year:</b></td>
												<td>
												<!--webbot bot="DatabaseResultColumn" s-columnnames="ItinID,Itinerary,DestinationID,Destination,CruiseLineID,CruiseLineName,ShipID,Months,Year,PortsofCall,StartingFrom,ShipPicture,ItineraryPicture" s-column="Year" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Year<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Year")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="5130" --></td>
											</tr>
											<tr>
												<td><b>PortsofCall:</b></td>
												<td>
												<!--webbot bot="DatabaseResultColumn" s-columnnames="ItinID,Itinerary,DestinationID,Destination,CruiseLineID,CruiseLineName,ShipID,Months,Year,PortsofCall,StartingFrom,ShipPicture,ItineraryPicture" s-column="PortsofCall" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>PortsofCall<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"PortsofCall")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="29599" --></td>
											</tr>
											<tr>
												<td><b>StartingFrom:</b></td>
												<td>
												<!--webbot bot="DatabaseResultColumn" s-columnnames="ItinID,Itinerary,DestinationID,Destination,CruiseLineID,CruiseLineName,ShipID,Months,Year,PortsofCall,StartingFrom,ShipPicture,ItineraryPicture" s-column="StartingFrom" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>StartingFrom<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"StartingFrom")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="32427" --></td>
											</tr>
											<tr>
												<td><b>ShipPicture:</b></td>
												<td>
												<!--webbot bot="DatabaseResultColumn" s-columnnames="ItinID,Itinerary,DestinationID,Destination,CruiseLineID,CruiseLineName,ShipID,Months,Year,PortsofCall,StartingFrom,ShipPicture,ItineraryPicture" s-column="ShipPicture" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>ShipPicture<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"ShipPicture")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="32251" --></td>
											</tr>
											<tr>
												<td><b>ItineraryPicture:</b></td>
												<td>
												<!--webbot bot="DatabaseResultColumn" s-columnnames="ItinID,Itinerary,DestinationID,Destination,CruiseLineID,CruiseLineName,ShipID,Months,Year,PortsofCall,StartingFrom,ShipPicture,ItineraryPicture" s-column="ItineraryPicture" b-tableformat="FALSE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>ItineraryPicture<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"ItineraryPicture")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="41830" --></td>
											</tr>
										</table>
										<hr>
										<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="5" clientside tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><font color="#000000">This is the end of a Database Results region.</font></td></tr><TR><TD VALIGN=MIDDLE><NOBR><INPUT TYPE=Button VALUE="  |<  "><INPUT TYPE=Button VALUE="   <  "><INPUT TYPE=Button VALUE="  >   "><INPUT TYPE=Button VALUE="  >|  ">  [1/5]</NOBR><BR></td></tr></table>" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --><br>
											 <!--webbot bot="SaveAsASP" clientside suggestedext="asp" preview=" " startspan --><!--webbot bot="SaveAsASP" endspan --><input type="hidden" name="fpdbr_1_PagingMove" value="  |<  "><!--webbot bot="SaveAsASP" clientside suggestedext="asp" preview=" " startspan --><!--webbot bot="SaveAsASP" endspan --><input type="hidden" name="fpdbr_2_PagingMove" value="  |<  "></td>
									</tr>
									<tr>

< Message edited by BeTheBall -- 8/30/2006 22:14:29 >

(in reply to BeTheBall)


BeTheBall Posts: 6385 Joined: 6/21/2002 From: West Point Utah USA Status: offline	RE: Access database query sorting - 8/30/2006 22:17:43 The name of the dropdown for the Destination ID has a space in it that should not be there. Change: <select NAME="Destination ID" SIZE="1"> to: <select NAME="DestinationID" SIZE="1"> _____________________________ Duane Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs. (in reply to mjmtravel)


mjmtravel Posts: 272 Joined: 7/30/2006 Status: offline	RE: Access database query sorting - 8/31/2006 18:10:55 Pardon the french but, damn your good. I thought after the first space problem I went through and changed everyone that I could find. I changed the last one you mentioned and presto, it works beautifully now. I don't know how I can thank you enough. I'm a firm believer in this website for sure. Thanks again. Jeff (in reply to BeTheBall)


BeTheBall Posts: 6385 Joined: 6/21/2002 From: West Point Utah USA Status: offline	RE: Access database query sorting - 8/31/2006 18:15:45 Glad you got it working as it should. Good luck with site. _____________________________ Duane Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs. (in reply to mjmtravel)