| | |
| |
Active Server Pages help tutorial how to ASP Help ASP Tutorials ASP Programming ASP Code - ASP Free CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Select Statement From HELL! |
|
From: |
Ed Husar |
|
Date: |
7/16/1999 10:54:40 AM |
|
IP: |
208.18.119.72 |
I have a select statement that works using the NT SQL tester. But now I am trying to use it in a ASP page. Here is the select statement...
> 70
Can someone please help me format this to work in select a.u_name, a.u_f_name, a.u_l_name, b.u_id, c.up_id, c.up_name, d.u_id, d.p_score from users a, upint b, uprofs c, progress d where c.up_name in (Linda Lund) and c.up_id = b.up_id and b.u_id = a.u_id and a.u_id = d.u_id and d.p_score my ASP page. Here is what I did in the page..
sSQL = "select a.u_name, a.u_f_name, a.u_l_name, b.u_id, c.up_id, c.up_name, d.u_id, d.p_score from users a, upint b, uprofs c, progress d where c.up_name in (Linda Lund) and c.up_id = b.up_id and b.u_id = a.u_id and a.u_id = d.u_id and d.p_score > 70;"
Here is the error I get what I run the ASP page...
Microsoft OLE DB Provider for ODBC Drivers error 80040e14
[Microsoft][ODBC driver for Oracle][Oracle]ORA-00923: FROM keyword not found where expected
/pathware4/student/password/getMngr.asp, line 15
Line 15 is the select statement.
Thanks in advance,
Ed Husar |
|
|
|
|
|
|
