<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not Edit. FP_CharSet = "windows-1252" FP_CodePage = 1252 %>



SOLD PIANOS.   Organized by Price/Brand/Age.
(Please Scroll Down to see search results)  

Back to Index

Brand " size="20">
(Enter a brand if you want to refine the search)


<% if 0 then %> <% end if %> <% fp_sQry="SELECT * FROM Testofquery WHERE (Brand LIKE '%::Brand::%' AND SoldCalc = 'SOLD') ORDER BY SalesPrice DESC,Brand ASC" fp_sDefault="Brand=" fp_sNoRecords="" fp_sDataConn="pfdbtest9" fp_iMaxRecords=0 fp_iCommandType=1 fp_iPageSize=10 fp_fTableFormat=True fp_fMenuFormat=False fp_sMenuChoice="" fp_sMenuValue="" fp_iDisplayCols=8 fp_fCustomQuery=False BOTID=3 fp_iRegion=BOTID %>
ID Brand Sales Price Age Feet Inches Finish Sold
No records returned.
"> <%=FP_FieldVal(fp_rs,"ID")%> <%=FP_FieldVal(fp_rs,"Brand")%> <%=FP_FieldVal(fp_rs,"SalesPrice")%> <%=FP_FieldVal(fp_rs,"Age")%> <%=FP_FieldVal(fp_rs,"Feet")%> <%=FP_FieldVal(fp_rs,"Inches")%> <%=FP_FieldVal(fp_rs,"Finish")%> <%=FP_FieldVal(fp_rs,"SoldCalc")%>

The directional arrows above take you take you forward and backwards through the list, 10 pianos at a time.  The number next to the arrows (i.e. [1/5] ) tells you the following:  the first number is the page you are on, the second number tells you how many pages are in this particular listing. If you wish more details on a piano, click on the ID number.  It will be highlighted if there is more info available.

<% if 0 then %> <% end if %> <% fp_sQry="SELECT * FROM DateLastUpdate" fp_sDefault="" fp_sNoRecords="No records returned." fp_sDataConn="pfdbtest9" fp_iMaxRecords=256 fp_iCommandType=1 fp_iPageSize=0 fp_fTableFormat=False fp_fMenuFormat=False fp_sMenuChoice="" fp_sMenuValue="" fp_iDisplayCols=5 fp_fCustomQuery=False BOTID=1 fp_iRegion=BOTID %>

Date of last update: <%=FP_FieldVal(fp_rs,"DateLastUpdate")%>
Time of last update: <%=FP_FieldVal(fp_rs,"TimeLastUpdate")%> Pacific Standard Time
Number of pianos sold: <%=FP_FieldVal(fp_rs,"PianosSold")%> since list began on 11-30-99.  
Number of pianos added: <%=FP_FieldVal(fp_rs,"PianosAdded")%> since last update
Total pianos: <%=FP_FieldVal(fp_rs,"Totalpianos")%> pianos listed in the entire Piano Finders database



Privacy Seal

Building Trust in Transactions (tm)


Copyright 1999, 2001 Karen E. Lile.  All Rights Reserved.  Use of this Web site constitutes 
acceptance of the
 Piano Finders Member Agreement and Privacy Policy