Database Results Wizard Error

[Mike]

I recently upgraded to FP2003 from FP2000. I use the
Database Results to query from an Access file. I use a
form to get data to query on and use a custom query. The
statement " ... where '::selectdata::' = 'All Records' "
used to work, now it returns a Database Results Wizard
Error. Anyway to know what the error is or why this
wouldn't work anymore?
Thanks, Mike

 

[David Berry]

What is the exact error and what does your SQL Statement look like?

 

[Guest]

The exact error I receive is:

Database Results Wizard Error
The operation failed. If this continues, please contact
your server administrator.

The SQL Query is:

SELECT [tblwpproducts].[ISBN], [tblwpproducts].
[Category], [tblwpproducts].[Title], [tblwpproducts].
[SubTitle], [tblwpproducts].[Author], [tblwpproducts].
[Pages], [tblwpproducts].[Retail_price], [tblwpproducts].
[Promo_price], [tblwpproducts].[Download_price],
[tblwpproducts].[Promo], [tblwpproducts].[PDF_download],
[tblwpproducts].[CD_sample], [tblwpproducts].
[CD_sample_link], [tblwpproducts].[CD_sample_desc],
[tblwpproducts].[Weight], [tblwpproducts].
[Shipping_units] FROM tblwpproducts WHERE [tblwpproducts].
[Category] Like '%:rodCategory::%'
or ':rodCategory::' = 'All Product' order by
[tblwpproducts].[Category], [tblwpproducts].[Title]

If I take out " or ':rodCategory::' = 'All Product' "
it works fine. If I leave it in then I receive the error
message. This did work in FP2000.

Thanks, Mike

 

[David Berry]

Does the Select statement work if you try it in Access? It almost sounds
like there's a permissions issue on the server where you don't have select
privileges on the database. You may want to check with your ISP and ask
about the permissions on the database if this used to work before.

--
David Berry - MCP
Microsoft MVP - FrontPage
FrontPage Support: http://www.net-sites.com/sitebuilder/
-----------------------------------

-----------------------------------

The exact error I receive is:

Database Results Wizard Error
The operation failed. If this continues, please contact
your server administrator.

The SQL Query is:

SELECT [tblwpproducts].[ISBN], [tblwpproducts].
[Category], [tblwpproducts].[Title], [tblwpproducts].
[SubTitle], [tblwpproducts].[Author], [tblwpproducts].
[Pages], [tblwpproducts].[Retail_price], [tblwpproducts].
[Promo_price], [tblwpproducts].[Download_price],
[tblwpproducts].[Promo], [tblwpproducts].[PDF_download],
[tblwpproducts].[CD_sample], [tblwpproducts].
[CD_sample_link], [tblwpproducts].[CD_sample_desc],
[tblwpproducts].[Weight], [tblwpproducts].
[Shipping_units] FROM tblwpproducts WHERE [tblwpproducts].
[Category] Like '%:rodCategory::%'
or ':rodCategory::' = 'All Product' order by
[tblwpproducts].[Category], [tblwpproducts].[Title]

If I take out " or ':rodCategory::' = 'All Product' "
it works fine. If I leave it in then I receive the error
message. This did work in FP2000.

Thanks, Mike

-----Original Message-----
What is the exact error and what does your SQL Statement look like?

--
David Berry - MCP
Microsoft MVP - FrontPage
FrontPage Support: http://www.net-sites.com/sitebuilder/
-----------------------------------
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
-----------------------------------



.

 

[YeahRight]

In the file /_fpclass/fpdbrgn1.inc , change :

fp_DEBUG = False

to :
fp_DEBUG = True

Now run the DRW - what is the error now?

The exact error I receive is:

Database Results Wizard Error
The operation failed. If this continues, please contact
your server administrator.

The SQL Query is:

SELECT [tblwpproducts].[ISBN], [tblwpproducts].
[Category], [tblwpproducts].[Title], [tblwpproducts].
[SubTitle], [tblwpproducts].[Author], [tblwpproducts].
[Pages], [tblwpproducts].[Retail_price], [tblwpproducts].
[Promo_price], [tblwpproducts].[Download_price],
[tblwpproducts].[Promo], [tblwpproducts].[PDF_download],
[tblwpproducts].[CD_sample], [tblwpproducts].
[CD_sample_link], [tblwpproducts].[CD_sample_desc],
[tblwpproducts].[Weight], [tblwpproducts].
[Shipping_units] FROM tblwpproducts WHERE [tblwpproducts].
[Category] Like '%:rodCategory::%'
or ':rodCategory::' = 'All Product' order by
[tblwpproducts].[Category], [tblwpproducts].[Title]

If I take out " or ':rodCategory::' = 'All Product' "
it works fine. If I leave it in then I receive the error
message. This did work in FP2000.

Thanks, Mike

-----Original Message-----
What is the exact error and what does your SQL Statement look like?

--
David Berry - MCP
Microsoft MVP - FrontPage
FrontPage Support: http://www.net-sites.com/sitebuilder/
-----------------------------------
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
-----------------------------------



.

 

[Jim Buyens]

The expression

':rodCategory::' = 'All Product'

is a little weird because it compares the value from a
form field to a literal, and doesn't involve a database
field at all.

If the ProdCategory form field is a Drop-Down box, I
suggest configuring the All Products choice to submit an
empty value. That way, your WHERE clause can consist
entirely of

[tblwpproducts].[Category] Like '%:rodCategory::%'

and if :rodCategory:: is an empty string, you'll match
all records.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

-----Original Message-----
The exact error I receive is:

Database Results Wizard Error
The operation failed. If this continues, please contact
your server administrator.

The SQL Query is:

SELECT [tblwpproducts].[ISBN], [tblwpproducts].
[Category], [tblwpproducts].[Title], [tblwpproducts].
[SubTitle], [tblwpproducts].[Author], [tblwpproducts].
[Pages], [tblwpproducts].[Retail_price], [tblwpproducts].
[Promo_price], [tblwpproducts].[Download_price],
[tblwpproducts].[Promo], [tblwpproducts].[PDF_download],
[tblwpproducts].[CD_sample], [tblwpproducts].
[CD_sample_link], [tblwpproducts].[CD_sample_desc],
[tblwpproducts].[Weight], [tblwpproducts].
[Shipping_units] FROM tblwpproducts WHERE [tblwpproducts].
[Category] Like '%:rodCategory::%'
or ':rodCategory::' = 'All Product' order by
[tblwpproducts].[Category], [tblwpproducts].[Title]

If I take out " or ':rodCategory::' = 'All Product' "
it works fine. If I leave it in then I receive the error
message. This did work in FP2000.

Thanks, Mike

-----Original Message-----
What is the exact error and what does your SQL

Statement
look like?

--
David Berry - MCP
Microsoft MVP - FrontPage
FrontPage Support: http://www.net-sites.com/sitebuilder/
-----------------------------------
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
-----------------------------------



.

.