I am new to FrontPage 2002 and web design in general and I am trying to setup a webpage that will accept a username and password. This userid and password will be compared to the database and if it exist, it will display the contents of one the tables.

I am using the following SELECT stmt: select p.lname, m.fname from membersid m, personalinfo p where m.username=::id:: and m.password=::pwd:: and m.username = p.username

When I publish and test this, I receive the following error:

Database Results Error
Description: No value given for one or more required parameters.
Number: -2147217904 (0x80040E10)
Source: Microsoft JET Database Engine

I am not sure what I am doing wrong. Does anyone have any clue to correct this?