Database results Error (with criteria)

[Jan van Emmerik]

Hello,

I use the frontpage database results wizard for quering a sql database.
It worked fine for some years now.
Suddenly I get this error.

************************
Database Results Error
Description: [Microsoft][ODBC SQL Server Driver][SQL Server]Prepared
statement '(@P1 numeric(18,0))SELECT ID,* FROM WWWPeople WHERE (ID = @P1);'
expects parameter @P1, which was not supplied.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers
***********************
Other asp pages worked fine but after a while they get the same error and I
didn't change a thing.

When I change the criteria from
select * from table where (ID = ::ID:
to
select * from table where (ID = 160)
It works!

Any help is welcome.

Regards,

Jan

 

[Mettá]

This sounds suspiciously like a problem with the MS SP3 "update" or an MS
security "fix" that has caused chaos for sites with db's. in them

There is a possible fix referred to in a thread dated 14 May 2004 04:11 by
Stephan
or
31 March 2004 17:31 by PAUL BUSNELL

God luck
M