Database Results

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
 
K

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top