FP and SQL search

[Lost with FP 2002 and SQL]

I think i am going nuts but her goes:

FP 2002 asp page generated with databse results wizard
against a SQL table. If I just list contents of table,
even with where clauses, it all works well.

The minute I add a search form for a field (like client #
equal to), I get an error:

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

Nothing in event logs

Table is created in SQL 2000 running SP3. the asp page is
on a web 2003 machine with IIS 6.

Even a clue on where to look would be appreciated

Thanks

 

[Thomas A. Rowe]

Please post your select query string.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Cowboy \(Gregory A. Beamer\)]

Kathleen may be the best person, as she is our DRW MVP guru, but it would be
helpful to add a followup with a few more steps and how you are filtering
(completely with DRW, writing any SQL, etc.). More input will certainly help
here.

Generic answer (problems I have seen in the past):
If you are writing ANY of the SQL is the fact that many come from the Access
(aka, bastardized SQL) world and try to move Access SQL to T-SQL. This,
unfortunately, fails more often than it works, at least in my experience.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

**********************************************************************
Think Outside the Box!
**********************************************************************

 

[Art]

The SQL query is so simple its sickening:

SELECT * FROM database1 WHERE (a31 = '::a31::')

A31 is a column name

 

[Thomas A. Rowe]

Try

If text field

"SELECT * FROM database1 WHERE a31 = '" & request.form("a31") & "" "

If a number field

"SELECT * FROM database1 WHERE a31 = " & request.form("a31")


--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Art]

I should add the the same page without a variable works
fine when listing the entire database

 

[Kathleen Anderson [MVP - FP]]

I don't think Art has said what kind of field a31 is (text or number).

I haven't used the DRW with SQL Server, but I will give it a shot.

 

[Art]

That query gives a schema error

-----Original Message-----
Try

If text field

"SELECT * FROM database1 WHERE a31 = '" & request.form ("a31") & "" "

If a number field

"SELECT * FROM database1 WHERE a31 = " & request.form ("a31")


--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp




.

 

[Thomas A. Rowe]

See if the following helps:

http://www.15seconds.com/issue/010228.htm

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================