I
iam247
Hi
I am fairly inexperienced with ASP, SQL and VB Script.
In one of my web pages I am trying to search a table in access which
has a number of integers (GroupID's) (1 to 5 at present) and find those
which do not match another set of GroupID's already contained in a
record set named rsGroupsJ (1 to 4 at present).
I want to find the GroupID's which do not match ie GroupID
I have created the following sql which returns the error:
"Unterminated string constant"
strSQL3 = "SELECT tblGroups.* FROM tblGroups WHERE tblGroups.GroupID <>
(rsGroupsJ("GroupID"))"
The following sql does not create an error message but the WHERE bit
seems to be ignored - it returns all records 1 to 5, it should only
return 5
I am realy poor at creating sql statements, I am never sure where or
why to put " or &
I have looked at a number of tutorials but cannot find examples close
to my requirements.
Any help with this would be appreciated
ColinK
I am fairly inexperienced with ASP, SQL and VB Script.
In one of my web pages I am trying to search a table in access which
has a number of integers (GroupID's) (1 to 5 at present) and find those
which do not match another set of GroupID's already contained in a
record set named rsGroupsJ (1 to 4 at present).
I want to find the GroupID's which do not match ie GroupID
I have created the following sql which returns the error:
"Unterminated string constant"
strSQL3 = "SELECT tblGroups.* FROM tblGroups WHERE tblGroups.GroupID <>
(rsGroupsJ("GroupID"))"
The following sql does not create an error message but the WHERE bit
seems to be ignored - it returns all records 1 to 5, it should only
return 5
I am realy poor at creating sql statements, I am never sure where or
why to put " or &
I have looked at a number of tutorials but cannot find examples close
to my requirements.
Any help with this would be appreciated
ColinK