SOTG_Halsey
Posts: 19
Joined: 2/22/2006
Status: offline
 |
RE: Database Help! - 2/23/2006 21:38:38
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns="http://www.w3.org/TR/REC-html40">
<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">
<meta name="description" content="Tortuga Trading">
<link rel="File-List" href="pistol_search_files/filelist.xml">
<title>Pistol Search</title>
<!--[if !mso]>
<style>
v\:* { behavior: url(#default#VML) }
o\:* { behavior: url(#default#VML) }
.shape { behavior: url(#default#VML) }
</style>
<![endif]-->
<script language="JavaScript">
<!--
function FP_swapImg() {//v1.0
var doc=document,args=arguments,elm,n; doc.$imgSwaps=new Array(); for(n=2; n<args.length;
n+=2) { elm=FP_getObjectByID(args[n]); if(elm) { doc.$imgSwaps[doc.$imgSwaps.length]=elm;
elm.$src=elm.src; elm.src=args[n+1]; } }
}
function FP_preloadImgs() {//v1.0
var d=document,a=arguments; if(!d.FP_imgs) d.FP_imgs=new Array();
for(var i=0; i<a.length; i++) { d.FP_imgs=new Image; d.FP_imgs.src=a; }
}
function FP_getObjectByID(id,o) {//v1.0
var c,el,els,f,m,n; if(!o)o=document; if(o.getElementById) el=o.getElementById(id);
else if(o.layers) c=o.layers; else if(o.all) el=o.all[id]; if(el) return el;
if(o.id==id || o.name==id) return o; if(o.childNodes) c=o.childNodes; if(c)
for(n=0; n<c.length; n++) { el=FP_getObjectByID(id,c[n]); if(el) return el; }
f=o.forms; if(f) for(n=0; n<f.length; n++) { els=f[n].elements;
for(m=0; m<els.length; m++){ el=FP_getObjectByID(id,els[n]); if(el) return el; } }
return null;
}
// -->
</script>
<!--[if gte mso 9]>
<xml><o:shapedefaults v:ext="edit" spidmax="1027"/>
</xml><![endif]-->
</head>
<body onload="FP_preloadImgs(/*url*/'button44.jpg', /*url*/'button43.jpg', /*url*/'button8.jpg', /*url*/'button7.jpg', /*url*/'button20.jpg', /*url*/'button19.jpg', /*url*/'button2D1.jpg', /*url*/'button2C1.jpg', /*url*/'button41.jpg', /*url*/'button40.jpg', /*url*/'button3B.jpg', /*url*/'button3A.jpg', /*url*/'button3E.jpg', /*url*/'button3D.jpg', /*url*/'button51.jpg', /*url*/'button50.jpg', /*url*/'button53.jpg', /*url*/'button52.jpg', /*url*/'button4D.jpg', /*url*/'button4C.jpg', /*url*/'button1C1.jpg', /*url*/'button1D1.jpg')">
<table border="0" cellpadding="0" cellspacing="0" width="1242" height="706" id="table1">
<!-- MSTableType="layout" -->
<tr>
<td valign="middle" bgcolor="#008080">
<!-- MSCellType="ContentHead" -->
<p align="center">
<img border="0" src="images.jpg" width="123" height="125"></td>
<td valign="middle" bgcolor="#008080">
<!-- MSCellType="ContentHead" -->
<p align="center"><!--[if gte vml 1]><v:shapetype id="_x0000_t161"
coordsize="21600,21600" o:spt="161" adj="4050" path="m,c7200@0,14400@0,21600,m,21600c7200@1,14400@1,21600,21600e">
<v:formulas>
<v:f eqn="prod #0 4 3"/>
<v:f eqn="sum 21600 0 @0"/>
<v:f eqn="val #0"/>
<v:f eqn="sum 21600 0 #0"/>
</v:formulas>
<v:path textpathok="t" o:connecttype="custom" o:connectlocs="10800,@2;0,10800;10800,@3;21600,10800"
o:connectangles="270,180,90,0"/>
<v:textpath on="t" fitshape="t" xscale="t"/>
<v:handles>
<v:h position="center,#0" yrange="0,8100"/>
</v:handles>
<o:lock v:ext="edit" text="t" shapetype="t"/>
</v:shapetype><v:shape id="_x0000_s1025" type="#_x0000_t161" alt="Totuga Trading Inc"
style='width:486pt;height:69.75pt' adj="5665" fillcolor="black" strokecolor="red"
strokeweight="1.5pt">
<v:shadow color="#868686"/>
<v:textpath style='font-family:"High Tower Text";font-size:40pt;font-weight:bold;
v-text-kern:t' trim="t" fitpath="t" xscale="f" string="Tortuga Trading Inc"/>
</v:shape><![endif]--><![if !vml]><img border=0 width=650 height=74
src="pistol_search23_files/image001.gif" alt="Totuga Trading Inc" v:shapes="_x0000_s1025"><![endif]></p>
<p align="center"><b><font face="Harrington" size="4" color="#FFFFFF">
<span style="text-decoration: none">
<a href="http://www.tortugatrading.com">
<font color="#FFFFFF"><span style="text-decoration: none">Home</span></font></a></span> ~
<span style="text-decoration: none">
<a href="about_sean.htm">
<font color="#FFFFFF"><span style="text-decoration: none">About Sean</span></font></a></span> ~
<span style="text-decoration: none">
<a href="contacts.htm">
<font color="#FFFFFF"><span style="text-decoration: none">Contact Us</span></font></a></span> ~
<span style="text-decoration: none">
<font color="#FFFFFF"><a href="search_site.asp">
<font color="#FFFFFF"><span style="text-decoration: none">Search Site</span></font></a></font></span> ~
<span style="text-decoration: none">
<a href="terms__agreements.htm">
<font color="#FFFFFF"><span style="text-decoration: none">Terms & Agreements</span></font></a></span></font></b></td>
<td valign="middle" bgcolor="#008080" height="125">
<!-- MSCellType="ContentHead" -->
<p align="center">
<img border="0" src="images.jpg" width="123" height="125"></td>
</tr>
<tr>
<td valign="top" bgcolor="#C0C0C0" colspan="3" height="20">
<p align="center"><a href="antiques.asp">
<img border="0" id="img14" src="button24.jpg" height="20" width="100" alt="Antiques" onmouseover="FP_swapImg(1,0,/*id*/'img14',/*url*/'button19.jpg')" onmouseout="FP_swapImg(0,0,/*id*/'img14',/*url*/'button24.jpg')" onmousedown="FP_swapImg(1,0,/*id*/'img14',/*url*/'button20.jpg')" onmouseup="FP_swapImg(0,0,/*id*/'img14',/*url*/'button19.jpg')" fp-style="fp-btn: Braided Row 1; fp-bgcolor: #C0C0C0; fp-orig: 0" fp-title="Antiques"></a><a href="bayonets.asp"><img border="0" id="img16" src="button2B1.jpg" height="20" width="100" alt="Bayonets" onmouseover="FP_swapImg(1,0,/*id*/'img16',/*url*/'button2C1.jpg')" onmouseout="FP_swapImg(0,0,/*id*/'img16',/*url*/'button2B1.jpg')" onmousedown="FP_swapImg(1,0,/*id*/'img16',/*url*/'button2D1.jpg')" onmouseup="FP_swapImg(0,0,/*id*/'img16',/*url*/'button2C1.jpg')" fp-style="fp-btn: Braided Row 1; fp-bgcolor: #C0C0C0; fp-orig: 0" fp-title="Bayonets"></a><a href="cannons_search.asp"><img border="0" id="img17" src="button55.jpg" height="20" width="100" alt="Cannons" onmouseover="FP_swapImg(1,0,/*id*/'img17',/*url*/'button40.jpg')" onmouseout="FP_swapImg(0,0,/*id*/'img17',/*url*/'button55.jpg')" onmousedown="FP_swapImg(1,0,/*id*/'img17',/*url*/'button41.jpg')" onmouseup="FP_swapImg(0,0,/*id*/'img17',/*url*/'button40.jpg')" fp-style="fp-btn: Braided Row 1; fp-bgcolor: #C0C0C0; fp-orig: 0" fp-title="Cannons"></a><a href="coin_search.asp"><img border="0" id="img18" src="button56.jpg" height="20" width="100" alt="Coins" onmouseover="FP_swapImg(1,0,/*id*/'img18',/*url*/'button3A.jpg')" onmouseout="FP_swapImg(0,0,/*id*/'img18',/*url*/'button56.jpg')" onmousedown="FP_swapImg(1,0,/*id*/'img18',/*url*/'button3B.jpg')" onmouseup="FP_swapImg(0,0,/*id*/'img18',/*url*/'button3A.jpg')" fp-style="fp-btn: Braided Row 1; fp-bgcolor: #C0C0C0; fp-orig: 0" fp-title="Coins"></a><a href="pistol_search.asp"><img border="0" id="img19" src="button3C.jpg" height="20" width="100" alt="Pistols" onmouseover="FP_swapImg(1,0,/*id*/'img19',/*url*/'button3D.jpg')" onmouseout="FP_swapImg(0,0,/*id*/'img19',/*url*/'button3C.jpg')" onmousedown="FP_swapImg(1,0,/*id*/'img19',/*url*/'button3E.jpg')" onmouseup="FP_swapImg(0,0,/*id*/'img19',/*url*/'button3D.jpg')" fp-style="fp-btn: Braided Row 1; fp-bgcolor: #C0C0C0; fp-orig: 0" fp-title="Pistols"></a><a href="powder_horn_search.asp"><img border="0" id="img20" src="button3F.jpg" height="20" width="100" alt="Powder Horns" onmouseover="FP_swapImg(1,0,/*id*/'img20',/*url*/'button50.jpg')" onmouseout="FP_swapImg(0,0,/*id*/'img20',/*url*/'button3F.jpg')" onmousedown="FP_swapImg(1,0,/*id*/'img20',/*url*/'button51.jpg')" onmouseup="FP_swapImg(0,0,/*id*/'img20',/*url*/'button50.jpg')" fp-style="fp-btn: Braided Row 1; fp-bgcolor: #C0C0C0; fp-orig: 0" fp-title="Powder Horns"></a><a href="rifle_search.asp"><img border="0" id="img21" src="button57.jpg" height="20" width="100" alt="Rifles" onmouseover="FP_swapImg(1,0,/*id*/'img21',/*url*/'button52.jpg')" onmouseout="FP_swapImg(0,0,/*id*/'img21',/*url*/'button57.jpg')" onmousedown="FP_swapImg(1,0,/*id*/'img21',/*url*/'button53.jpg')" onmouseup="FP_swapImg(0,0,/*id*/'img21',/*url*/'button52.jpg')" fp-style="fp-btn: Braided Row 1; fp-bgcolor: #C0C0C0; fp-orig: 0" fp-title="Rifles"></a><a href="shipwrecked_treasures.htm"><img border="0" id="img13" src="button6.jpg" height="20" width="140" alt="Shipwreck Treasures" onmouseover="FP_swapImg(1,0,/*id*/'img13',/*url*/'button7.jpg')" onmouseout="FP_swapImg(0,0,/*id*/'img13',/*url*/'button6.jpg')" onmousedown="FP_swapImg(1,0,/*id*/'img13',/*url*/'button8.jpg')" onmouseup="FP_swapImg(0,0,/*id*/'img13',/*url*/'button7.jpg')" fp-style="fp-btn: Braided Row 1; fp-bgcolor: #C0C0C0; fp-proportional: 0; fp-orig: 0" fp-title="Shipwreck Treasures"></a><a href="sword_search.asp"><img border="0" id="img24" src="button1B1.jpg" height="20" width="111" alt="Edged Weapons" onmouseover="FP_swapImg(1,0,/*id*/'img24',/*url*/'button1C1.jpg')" onmouseout="FP_swapImg(0,0,/*id*/'img24',/*url*/'button1B1.jpg')" onmousedown="FP_swapImg(1,0,/*id*/'img24',/*url*/'button1D1.jpg')" onmouseup="FP_swapImg(0,0,/*id*/'img24',/*url*/'button1C1.jpg')" fp-style="fp-btn: Braided Row 1; fp-bgcolor: #C0C0C0; fp-proportional: 0" fp-title="Edged Weapons"></a><a href="uniforms_search.asp"><img border="0" id="img23" src="button4B.jpg" height="20" width="100" alt="Uniforms" onmouseover="FP_swapImg(1,0,/*id*/'img23',/*url*/'button4C.jpg')" onmouseout="FP_swapImg(0,0,/*id*/'img23',/*url*/'button4B.jpg')" onmousedown="FP_swapImg(1,0,/*id*/'img23',/*url*/'button4D.jpg')" onmouseup="FP_swapImg(0,0,/*id*/'img23',/*url*/'button4C.jpg')" fp-style="fp-btn: Braided Row 1; fp-bgcolor: #C0C0C0; fp-orig: 0" fp-title="Uniforms"></a></td>
</tr>
<tr>
<td colspan="3" valign="top">
<form BOTID="0" METHOD="POST" action="pistol_search.asp">
<input type="hidden" name="fpdbr_0_PagingMove" value=" |< ">
</form>
<table width="100%" border="1">
<thead>
<tr>
<th ALIGN="LEFT"><b>Key</b></th>
<th ALIGN="LEFT"><b>Name</b></th>
<th ALIGN="LEFT"><b>Description</b></th>
<th ALIGN="LEFT"><b>Price</b></th>
<th ALIGN="LEFT" width="4%"><b>Details</b></th>
<th ALIGN="LEFT" width="2%"><b>Buy</b></th>
<th ALIGN="LEFT" width="10%"><b>Picture</b></th>
</tr>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart" s-columnnames="Key,Name,Description,Price,Details,Buy,Picture" s-columntypes="3,202,202,2,202,202,202" s-dataconnection="database2" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="Pistols" s-displaycolumns="Key,Name,Description,Price,Details,Buy,Picture" s-criteria s-order s-sql="SELECT * FROM Pistols" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="256" i-groupsize="5" botid="0" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the start of a Database Results region.</font></td></tr>" 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 Pistols"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=7 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="database2"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Key=3&Name=202&Description=202&Price=2&Details=202&Buy=202&Picture=202&"
fp_iDisplayCols=7
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="25530" --><tr>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="Key,Name,Description,Price,Details,Buy,Picture" s-column="Key" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Key<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Key")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="2510" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="Key,Name,Description,Price,Details,Buy,Picture" s-column="Name" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Name<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Name")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="3900" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="Key,Name,Description,Price,Details,Buy,Picture" s-column="Description" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Description<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Description")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="30092" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="Key,Name,Description,Price,Details,Buy,Picture" s-column="Price" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Price<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Price")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="9640" --></td>
<td width="4%">
<p align="center">
<img border="0" src="<%=FP_FieldLink(fp_rs,"Details")%>"></td>
<td width="2%">
<img border="0" src="<%=FP_FieldLink(fp_rs,"Buy")%>"></td>
<td width="10%">
<img border="0" src="<%=FP_FieldLink(fp_rs,"Picture")%>" align="right"></td>
</tr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="5" clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr><TR><TD VALIGN=MIDDLE COLSPAN=64><NOBR><INPUT TYPE=Button VALUE=" |< "><INPUT TYPE=Button VALUE=" < "><INPUT TYPE=Button VALUE=" > "><INPUT TYPE=Button VALUE=" >| "> [1/5]</NOBR><BR></td></tr>" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>
</table>
</td>
</tr>
<tr>
<td valign="top" bgcolor="#008080" colspan="3" height="98">
<!-- MSCellType="ContentFoot" -->
<p align="center"><b>Tortuga Trading, Inc. DBA The Treasure Connection
2240 Encinitas Blvd., Suite D-228 Encinitas, CA 92024</b></p>
<p align="center"><b>s-rich@sbcglobal.net 760-271-5457</b></p>
<p align="center"><b><font face="Rockwell">Website Built by: </font>
<font face="Rage Italic">Halsey, Charles R </font>
<font face="Poor Richard"><a href="feedback.htm">Leave Feedback</a></font></b></td>
</tr>
<tr>
<td width="295"></td>
<td width="650"></td>
<td height="2" width="297"></td>
</tr>
</table>
<p align="center">Copyright © 2001 Tortuga Trading, Inc., DBA The Treasure
Connection. All rights reserved.<br>
Revised: <!--webbot bot="TimeStamp" s-type="EDITED" s-format="%m/%d/%y" -->.</p>
</body>
</html>
< Message edited by Spooky -- 2/24/2006 22:33:29 >
|
Printable Version 
k¥ 
New Messages
No New Messages
Hot Topic w/ New Messages
Hot Topic w/o New Messages
Locked w/ New Messages
Locked w/o New Messages
Post New Thread