Query on SQL Server 2000 Linked Table Doesnt Provide Correct Results
- From: Benjamin <benjamin.dizenhouse@xxxxxxxxx>
- Date: Thu, 28 Jun 2007 07:46:33 -0700
Hello,
I have some backend tables in a SQL Server 2000 Database linked into
my MSACCESS database. When I run the following query in Access I get
0 (zero) results. If I run the same query in query analyzer, I get
the correct results. Can someone please help? I think the problem
has to do with the fact that I am comparing long strings. Originally,
all the tables were in MSACCESS and I found that for some comparisons,
if I only used [Detail] = '..' the match wouldnt work but If I used
[Detail] LIKE '...' (even without wildcards) it would work for some
but not all, thats why I have used both versions). Now, because of
the size of the tables, I though having them in a SQL server database
would help.
Thanks for any help!
Query:
"SELECT *
FROM Scan_UniqueFindings
WHERE [Server] = 'servername' AND
[Type] = 'once-only' AND
[Policy] = 'policy1' AND
[Check] = 'admin' AND
([Detail] = 'User daemon value login is true
User daemon value rlogin is true
User bin value login is true
User bin value rlogin is true
User adm value login is true
User adm value rlogin is true
User nobody value login is true
User nobody value rlogin is true
User lpd value login is true
User lpd value rlogin is true
User nuucp value login is true
User nuucp value rlogin is true
User sys value login is true
User sys value rlogin is true' OR
[Detail] LIKE 'User daemon value login is true
User daemon value rlogin is true
User bin value login is true
User bin value rlogin is true
User adm value login is true
User adm value rlogin is true
User nobody value login is true
User nobody value rlogin is true
User lpd value login is true
User lpd value rlogin is true
User nuucp value login is true
User nuucp value rlogin is true
User sys value login is true
User sys value rlogin is true');
.
- Follow-Ups:
- Re: Query on SQL Server 2000 Linked Table Doesnt Provide Correct Results
- From: Allen Browne
- Re: Query on SQL Server 2000 Linked Table Doesnt Provide Correct Results
- Prev by Date: Re: Need 5 Business Days...
- Next by Date: Re: This should be simple but I don't know how!
- Previous by thread: Re: This should be simple but I don't know how!
- Next by thread: Re: Query on SQL Server 2000 Linked Table Doesnt Provide Correct Results
- Index(es):
Relevant Pages
|
