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
--------------------------------------------------------------------------
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