Database Results

[HB2]

I am trying to put database results in my webpage using FP2000. The page is
:

http://www.mropartner.com/Test.asp

The code is:

<%
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=0
fp_iRegion=BOTID
%>
This is a query within my database. The query is not empty, but I am
getting "No Records Returned"

Help!
Thanks

 

[Bill Schroyer]

Missing a "
fp_sQry="SELECT * FROM "cONTACTORS"

Bill Schroyer
(e-mail address removed)
http://www.frontpagewiz.com

 

[Bob]

I had a similar problem. In my case I had set some criteria that had a space in it. Very difficult to spot straight away and now bald having torn all my hair out

Suggest
Go to page with Databse Results region. Right click on region. Select <Database Results Properties..> option.
Up will pop the Database Results Wizard
Check in step one that the connection is PRECOAT. (If not then you are not connecting to the database that you think you are
In Step 2 check that record source is correct, you will select from a list. If you have chosen <Custom> then check the sql for formatting...carefully
In step 3 check <more options..> to make sure you have not set criteria that logically precludes results being returned
<next > through steps 4 and 5

Publish and check results

Hope that helps
Bob

 

[HB2]

Now I am getting:


Microsoft VBScript compilation error '800a0401'

Expected end of statement

/Test.asp, line 45

fp_sQry="SELECT * FROM "cONTACTORS" ORDER BY Category ASC"

 

[Kathleen Anderson [MVP - FP]]

You usually don't need quotes around the name of the table. Are you sure
that the table is named cONTACTORS in your database?

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

 

[HB2]

Its is the name of a Query in my database

You usually don't need quotes around the name of the table. Are you sure
that the table is named cONTACTORS in your database?

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

 

[Kathleen Anderson [MVP - FP]]

Are you sure the query is named cONTACTORS (beginning with a lower case 'c'?

Try taking off the ORDER BY Category ASC - that should already be part of
your query.


--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

 

[HB2]

I changed the query to contactors and I am getting "No Results Returned"

Latest Code:

<%

fp_sQry="SELECT * FROM contactors"

fp_sDefault=""

fp_sNoRecords="<tr><td colspan=5 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=5

fp_fCustomQuery=False

BOTID=0

fp_iRegion=BOTID

%>