SQL Help

[TAT]

Hello,

I was hoping someone could help me with the following SQL script in putting
in a Data Access Page. It works in Access but not my web page.

Thanks for your help.

SELECT Sheet1.HRIS, Sheet1.PW, Sheet1.Points
FROM Sheet1
WHERE (((Sheet1.HRIS)=[Enter HRIS]) AND ((Sheet1.PW)=[Enter Password]));

 

[TAT]

Oh, and I realize the first line should look like:

SELECT * FROM "Points"

Thanks!

 

[Kevin Spencer]

Actually, assuming that the table name is "Sheet1," it should be the first
version.

The problem is that this is a parameterized query. Your web page doesn't
take Access parameters. It takes form input, query string data, etc.

--
HTH,

Kevin Spencer
Microsoft MVP
Professional Numbskull

Hard work is a medication for which
there is no placebo.

Oh, and I realize the first line should look like:

SELECT * FROM "Points"

Thanks!

Hello,

I was hoping someone could help me with the following SQL script in
putting
in a Data Access Page. It works in Access but not my web page.

Thanks for your help.

SELECT Sheet1.HRIS, Sheet1.PW, Sheet1.Points
FROM Sheet1
WHERE (((Sheet1.HRIS)=[Enter HRIS]) AND ((Sheet1.PW)=[Enter Password]));

 

[TAT]

Well that explains that. I went ahead and created a search form and it works
fine. Thanks

Actually, assuming that the table name is "Sheet1," it should be the first
version.

The problem is that this is a parameterized query. Your web page doesn't
take Access parameters. It takes form input, query string data, etc.

--
HTH,

Kevin Spencer
Microsoft MVP
Professional Numbskull

Hard work is a medication for which
there is no placebo.

Oh, and I realize the first line should look like:

SELECT * FROM "Points"

Thanks!

Hello,

I was hoping someone could help me with the following SQL script in
putting
in a Data Access Page. It works in Access but not my web page.

Thanks for your help.

SELECT Sheet1.HRIS, Sheet1.PW, Sheet1.Points
FROM Sheet1
WHERE (((Sheet1.HRIS)=[Enter HRIS]) AND ((Sheet1.PW)=[Enter Password]));

 

[Kevin Spencer]

:-D

--
Kevin Spencer
Microsoft MVP
Professional Numbskull

Hard work is a medication for which
there is no placebo.

Well that explains that. I went ahead and created a search form and it
works
fine. Thanks

Actually, assuming that the table name is "Sheet1," it should be the
first
version.

The problem is that this is a parameterized query. Your web page doesn't
take Access parameters. It takes form input, query string data, etc.

--
HTH,

Kevin Spencer
Microsoft MVP
Professional Numbskull

Hard work is a medication for which
there is no placebo.

Oh, and I realize the first line should look like:

SELECT * FROM "Points"

Thanks!

:

Hello,

I was hoping someone could help me with the following SQL script in
putting
in a Data Access Page. It works in Access but not my web page.

Thanks for your help.

SELECT Sheet1.HRIS, Sheet1.PW, Sheet1.Points
FROM Sheet1
WHERE (((Sheet1.HRIS)=[Enter HRIS]) AND ((Sheet1.PW)=[Enter
Password]));