Database Results

[HB2]

No Records Returned


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

I used insert database results on my page:
http://www.mropartner.com/Test.asp

When I insert results from a qeury I get "NO RECORDS RETURNED"

When I insert from a table I t works. Here is the code for the query:

<%
fp_sQry="SELECT * FROM contactors"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=7 align=left width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="precoat"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=7
fp_fCustomQuery=False
BOTID=2
fp_iRegion=BOTID
%>

Any ideas. I have checked the query in my access file. It returns
several records.

Thanks

 

[Kathleen Anderson [MVP - FP]]

If you are using an Access query as your record source, the FP database
wizard should generate SQL that looks something like this: fp_sQry="SELECT
* FROM ""tblnames Query"""