Complex Select Problem?
Dustin Wish with NCA Communications <[email protected]> Mon, 26 Aug 2002 22:58:31 -0500
| Newsgroups | gmane.comp.windows.devel.oledb.devel |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format.
------=_NextPart_000_0021_01C24D54.1945ED80
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I am having a problem with
"SELECT DaStatus AS a.StatusCode, DaType =3D c.Description, DaYear =3D =
a.[Year], DaMake =3D b.Description,DaModel =3D a.Model, DaPrice =3D =
a.Retails FROM Inventory AS a, Makes AS b, Types AS c WHERE =
a.Make=3Db.Make And a.Type=3Dc.Type"
=20
I had a heck of a time figuring out that you can't do paging with a =
datareader you must use a dataset, but now this?
Tried using AS instead of =3D ut no luck? I keep getting:
=20
Server Error in '/' Application.=20
-------------------------------------------------------------------------=
-------
The SELECT statement includes a reserved word or an argument name that =
is misspelled or missing, or the punctuation is incorrect.=20
Description: An unhandled exception occurred during the execution of the =
current web request. Please review the stack trace for more information =
about the error and where it originated in the code.=20
Exception Details: System.Data.OleDb.OleDbException: The SELECT =
statement includes a reserved word or an argument name that is =
misspelled or missing, or the punctuation is incorrect.
Any Help?
Dustin Wish
Data and Networking Technician
NCA Communications, Inc.
"Facts do not cease to exist because they are ignored." - Aldous Huxley
"Don't let your minds be cluttered up with the prevailing doctrine." - =
Alexander Fleming (1881-1955)=20
***=20
You can read messages from the OLEDB_DEV archive, unsubscribe from OLEDB_DEV,
or subscribe to other DevelopMentor lists at http://discuss.develop.com.
------=_NextPart_000_0021_01C24D54.1945ED80
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2716.2200" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>I am having a problem with</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>"SELECT DaStatus AS a.StatusCode, =
DaType =3D=20
c.Description, DaYear =3D a.[Year], DaMake =3D b.Description,DaModel =3D =
a.Model,=20
DaPrice =3D a.Retails FROM Inventory AS a, Makes AS b, Types AS c WHERE=20
a.Make=3Db.Make And a.Type=3Dc.Type"</FONT></DIV>
<DIV><FONT face=3DArial size=3D2> </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I had a heck of a time figuring out =
that you can't=20
do paging with a datareader you must use a dataset, but now =
this?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Tried using AS instead of =3D ut no =
luck? I keep=20
getting:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><SPAN> </DIV>
<H1>Server Error in '/' Application.=20
<HR width=3D"100%" color=3Dsilver SIZE=3D1>
</H1>
<H2><I>The SELECT statement includes a reserved word or an argument name =
that is=20
misspelled or missing, or the punctuation is incorrect.</I> </H2>
<DIV></SPAN><FONT=20
face=3D"Arial, Helvetica, Geneva, SunSans-Regular, sans-serif =
"><B>Description:=20
</B>An unhandled exception occurred during the execution of the current =
web=20
request. Please review the stack trace for more information about the =
error and=20
where it originated in the code. <BR><BR><B>Exception Details:=20
</B>System.Data.OleDb.OleDbException: The SELECT statement includes a =
reserved=20
word or an argument name that is misspelled or missing, or the =
punctuation is=20
incorrect.<BR></FONT></DIV>
<DIV><FONT=20
face=3D"Arial, Helvetica, Geneva, SunSans-Regular, sans-serif =
"></FONT> </DIV>
<DIV><FONT face=3D"Arial, Helvetica, Geneva, SunSans-Regular, sans-serif =
"><FONT=20
size=3D2>Any Help?</FONT></DIV></FONT>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Dustin Wish<BR>Data and Networking=20
Technician<BR>NCA Communications, Inc.</FONT></DIV>
<DIV> </DIV><FONT face=3DArial size=3D2>
<DIV><BR>"Facts do not cease to exist because they are ignored." - =
Aldous=20
Huxley<BR>"Don't let your minds be cluttered up with the prevailing =
doctrine." -=20
Alexander Fleming (1881-1955) </DIV>
<DIV> </DIV>
<DIV>*** </DIV>
<DIV> </DIV>
<DIV></FONT> </DIV></BODY></HTML>
You can read messages from the OLEDB_DEV archive, unsubscribe from OLEDB_DEV,
or subscribe to other DevelopMentor lists at http://discuss.develop.com.
------=_NextPart_000_0021_01C24D54.1945ED80--