|
 |
asp_databases thread: RE : Incorrect syntax for Sams SQL Server
Message #1 by "Pierre" <pierre.mathieu@s...> on Thu, 16 Aug 2001 19:04:17 -0700
|
|
The query isn't good. Blank spaces are missing under * and from,...
You should use:
SQLProjectManage =3D "select * " _
&"FROM tblProject,tblBAFContact " _
&"WHERE projectManagerID =3D BAFContactID
" _
&"AND BAFContactID =3D " &
request.Cookies("LoginID")
-----Message d'origine-----
De=A0: Sam Clohesy [mailto:sam@e...]
Envoy=E9=A0: Thursday, August 16, 2001 7:16 AM
=C0=A0: ASP Databases
Objet=A0: [asp_databases] Incorrect syntax for Sams SQL Server
Hi Guys,I am using this query:
Dim rsProjectManager
Set rsProjectManager =3D server.createobject ("ADODB.recordset")
SQLProjectManage =3D "select *" _
&"FROM tblProject,tblBAFContact" _
&"WHERE projectManagerID =3D BAFContactID"
_
&"AND BAFContactID =3D " &
request.Cookies("LoginID")
rsProjectManager.Open
SQLProjectManage,cn,1
and I am getting this error:
Microsoft OLE DB Provider for SQL Server error '80040e14'
Line 1: Incorrect syntax near '=3D'.
?
I am very frustrated (It is not doing anything complex even...)
Any suggestions etc
Thanks
Sam
Message #2 by Sam Clohesy <sam@e...> on Thu, 16 Aug 2001 18:12:44 +0100
|
|
Thanks Pierre, worked it out at this end...
Thanks again
-----Original Message-----
From: Pierre [mailto:pierre.mathieu@s...]
Sent: 17 August 2001 03:04
To: ASP Databases
Subject: [asp_databases] RE : Incorrect syntax for Sams SQL Server
The query isn't good. Blank spaces are missing under * and from,...
You should use:
SQLProjectManage =3D "select * " _
&"FROM tblProject,tblBAFContact " _
&"WHERE projectManagerID =3D BAFContactID
" _
&"AND BAFContactID =3D " &
request.Cookies("LoginID")
-----Message d'origine-----
De=A0: Sam Clohesy [mailto:sam@e...]
Envoy=E9=A0: Thursday, August 16, 2001 7:16 AM
=C0=A0: ASP Databases
Objet=A0: [asp_databases] Incorrect syntax for Sams SQL Server
Hi Guys,I am using this query:
Dim rsProjectManager
Set rsProjectManager =3D server.createobject ("ADODB.recordset")
SQLProjectManage =3D "select *" _
&"FROM tblProject,tblBAFContact" _
&"WHERE projectManagerID =3D BAFContactID"
_
&"AND BAFContactID =3D " &
request.Cookies("LoginID")
rsProjectManager.Open
SQLProjectManage,cn,1
and I am getting this error:
Microsoft OLE DB Provider for SQL Server error '80040e14'
Line 1: Incorrect syntax near '=3D'.
?
I am very frustrated (It is not doing anything complex even...)
Any suggestions etc
Thanks
Sam
|
|
|
View Cart
