Database Results Error

Art · Sep 9, 2004

I am attempting to query a SQL table using the DBW. I am
using FP2002

If I just list the entire database with no search
criteria, everything works fine.

The minute I add a search criteria (and a search form),
such as on zip, I get this error:

Database Results Error
Your page contains a query with user input parameters that
could not be resolved. This could happen if your
DatabaseRegionStart webbot has an empty or missing s-
columnnames or s-columntypes attributes. You may need to
read Microsoft Knowledge Base Article 817029.

I read the article although it apples to FP2003 and it
makes no sense in my case. The only thing I can figure is
the s-attributes are incorrect but I have no idea how to
change them.

All of the fields in the SQL table are set up as varchar.

Let me know if anyone can help with this dilemna. Thanks

Here is the relevant part (I think) if my asp page.


<tr>
<td>
<!--webbot bot="DatabaseResultColumn" s-
columnnames="ID,Company,Location,Address,City,State,Zip,Tel
ephone,Facsimile" s-column="Company" b-tableformat="TRUE"
b-hashtml="FALSE" b-makelink="FALSE" clientside b-
MenuFormat preview="&lt;&lt;Company&gt;&gt;"

startspan --> said:
</td>

<td>
<!--webbot bot="DatabaseResultColumn" s-
columnnames="ID,Company,Location,Address,City,State,Zip,Tel
ephone,Facsimile" s-column="Address" b-tableformat="TRUE"
b-hashtml="FALSE" b-makelink="FALSE" clientside b-
MenuFormat preview="&lt;&lt;Address&gt;&gt;"

startspan --> said:
</td>

<td>
<!--webbot bot="DatabaseResultColumn" s-
columnnames="ID,Company,Location,Address,City,State,Zip,Tel
ephone,Facsimile" s-column="City" b-tableformat="TRUE" b-
hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat
preview="&lt;&lt;City&gt;&gt;"

startspan --> said:
</td>

<td>
<!--webbot bot="DatabaseResultColumn" s-
columnnames="ID,Company,Location,Address,City,State,Zip,Tel
ephone,Facsimile" s-column="State" b-tableformat="TRUE" b-
hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat
preview="&lt;&lt;State&gt;&gt;"

startspan --> said:
</td>

<td>
<!--webbot bot="DatabaseResultColumn" s-
columnnames="ID,Company,Location,Address,City,State,Zip,Tel
ephone,Facsimile" s-column="Zip" b-tableformat="TRUE" b-
hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat
preview="&lt;&lt;Zip&gt;&gt;"

startspan --> said:
</td>

<td>
<!--webbot bot="DatabaseResultColumn" s-
columnnames="ID,Company,Location,Address,City,State,Zip,Tel
ephone,Facsimile" s-column="Telephone" b-
tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="&lt;&lt;Telephone&gt;&gt;"

startspan --> said:
</td>

<td>
<!--webbot bot="DatabaseResultColumn" s-
columnnames="ID,Company,Location,Address,City,State,Zip,Tel
ephone,Facsimile" s-column="Facsimile" b-
tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="&lt;&lt;Facsimile&gt;&gt;"

startspan --> said:
</td>

</tr>

Nicholas · Sep 9, 2004

What it boils down to is that FP uses only one SQL
statement to put results into the table created by DRW.
If you try to use different columns, it tries to write an
overcomplicated SQL statement that doesn't work.

The stuff that displays in the FP DRW and in the Normal
view are contained in the grayed out "DatabaseRegionStart"
area in the HTML view.

s-criteria="[Zip] EQ {Zip} +" s-order
s-sql="SELECT * FROM Results WHERE (Zip = '::Zip::')
ORDER BY Company"
b-procedure="FALSE" clientside SuggestedExt="asp"
s-DefaultFields="Zip="

The actual query that runs is in the ASP code below that.

fp_sQry="SELECT * FROM Results WHERE (Zip = '::ZIP::')
ORDER BY Company"
fp_sDefault="Zip="

Whatever is in s-sql and s-DefaultFields is copied into
corresponding ASP variables when you save the page. Try
setting it up exactly as above.

Or, try this:

s-criteria
s-order="[Zip] +"
b-procedure="FALSE" clientside SuggestedExt="asp"
s-DefaultFields

fp_sQry="SELECT * FROM Results WHERE (Zip = '::ZIP::')
ORDER BY Company"
fp_sDefault=""

On one page, I ended up leaving all of the above blank and
writing a custom ASP script to build the SQL statement and
put it into the fp_sQry variable. The trick with that,
though, is that FP gives you an error message and inserts
fp_sQry="" when you save it. You have to open it in
Notepad and delete the fp_sQry="" before publishing.

Another approach is don't use the DRW at all. Use
ASP/VBscript to query and write the results.

I am trying to understand this code...	3	Jul 26, 2008
DataBase results Error continued	1	Sep 10, 2004
any ideas why I can update one table in my database but not the other?	2	Sep 22, 2006
Please help, FP generated code produces a "Too few parameters. Expected1" error!	7	Jun 6, 2005
@ my wits end	1	Sep 12, 2006
Problem with form validation	1	Jul 19, 2004
Drop down box query no.2	1	Dec 11, 2004
Webbot FP_FieldLink FP_FeidlVal question	3	Mar 17, 2004

Database Results Error

Art

Nicholas

Ask a Question

Similar Threads