Database Results

  • Thread starter Thread starter HB2
  • Start date Start date
H

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
 
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"""
 
Back
Top