Front Page - Database results Error (with criteria)

Author

Database results Error (with criteria)

Jan van Emmerik

2004-05-29, 12:15 pm

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á

2004-05-29, 7:14 pm

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

"Jan van Emmerik" <vemmerik@nospamxs4all.nl> wrote in message
news:OLOk5NYREHA.1388@TK2MSFTNGP09.phx.gbl...
> 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
>
>