Kip Dole
|
| Posted: 03/04/2003, 12:25 PM |
|
*// This works
'sSql = "SELECT password, login FROM dbo_person_security WHERE person_id = 1"
*// I can't get this to work? Any ideas would be appreciated.
*// This works in Access?
sSql = "SELECT ps.password, ps.login FROM dbo_person_security ps WHERE person_id in (select person_id from dbo_email_address where email = 'kipdolehotmail.com')"
Thanks in advance.
|
|
|
 |
Kip Dole
|
| Posted: 03/04/2003, 12:44 PM |
|
I made a typo. It works sorry.
Correlated Sub query is not working ASP Access
Date Entered 3/4/2003 12:25:19 PM
Message *// This works
'sSql = "SELECT password, login FROM dbo_person_security WHERE person_id = 1"
*// I can't get this to work? Any ideas would be appreciated.
*// This works in Access?
sSql = "SELECT ps.password, ps.login FROM dbo_person_security ps WHERE person_id in (select person_id from dbo_email_address where email = 'kipdole@hotmail.com')"
Thanks in advance.
|
|
|
|
|
