<% if 0 then %> <% end if %> <% fp_sQry="SELECT * FROM Results WHERE (member2008 LIKE 'a%' AND member2007 LIKE 'a%') ORDER BY company ASC" fp_sDefault="" fp_sNoRecords="" fp_sDataConn="Database2" fp_iMaxRecords=0 fp_iCommandType=1 fp_iPageSize=0 fp_fTableFormat=True fp_fMenuFormat=False fp_sMenuChoice="company" fp_sMenuValue="company" fp_sColTypes="&ID=3&company=202&web=202&phone=202&first=202&last=202&email=202&specialty=202&Remote_computer_name=202&User_name=202&Browser_type=202&Timestamp=135&membership=202&street=202&city=202&st=202&zip=202&contact1title=202&first0=202&last0=202&contact1title0=202&email0=202&services=203&counties=202&fax=202&title=202&Officeer=202&county=202&member2007=202&member2008=202&member2009=202&member2010=202&member2011=202&homeshow2007=202&homeshow2008=202&homeshow2009=202&homeshow2010=202&homeshow2011=202&mainbusines=202&comment=203&req1=202&req2=202&req3=202&boothassigned=202&contract=202&application=202&paid=202&paidamount=202&email1=202&web0=202&specialty0=202&Remote_computer_name1=202&User_name1=202&Browser_type1=202&Timestamp1=135&" fp_iDisplayCols=13 fp_fCustomQuery=False BOTID=0 fp_iRegion=BOTID %>

No records returned.
<%=FP_FieldVal(fp_rs,"company")%>	<%=FP_FieldVal(fp_rs,"specialty")%>       Anniversary:<%=FP_FieldVal(fp_rs,"Officeer")%>
	<%=FP_FieldVal(fp_rs,"street")%>_<%=FP_FieldVal(fp_rs,"city")%>_<%=FP_FieldVal(fp_rs,"st")%>_<%=FP_FieldVal(fp_rs,"zip")%>
	Home Show Booth:    <%=FP_FieldVal(fp_rs,"boothassigned")%>   "> <%="" & FP_FieldVal(fp_rs,"web") & ""%>
	<%=FP_FieldVal(fp_rs,"first")%>_<%=FP_FieldVal(fp_rs,"last")%>_<%=FP_FieldVal(fp_rs,"title")%>
	Phone: <%=FP_FieldVal(fp_rs,"phone")%>______ Email: "> <%=FP_FieldVal(fp_rs,"email")%>