Click here to Skip to main content
15,881,172 members
Home / Discussions / Database
   

Database

 
GeneralCreating a DBASE file Pin
DonBush6-Nov-03 4:04
DonBush6-Nov-03 4:04 
GeneralRe: Creating a DBASE file Pin
Jörgen Sigvardsson6-Nov-03 14:00
Jörgen Sigvardsson6-Nov-03 14:00 
GeneralRe: Creating a DBASE file Pin
DonBush7-Nov-03 2:33
DonBush7-Nov-03 2:33 
GeneralRe: Creating a DBASE file Pin
Jörgen Sigvardsson7-Nov-03 3:14
Jörgen Sigvardsson7-Nov-03 3:14 
GeneralRe: Creating a DBASE file Pin
DonBush7-Nov-03 4:10
DonBush7-Nov-03 4:10 
GeneralRe: Creating a DBASE file Pin
Arjan Einbu10-Nov-03 11:07
Arjan Einbu10-Nov-03 11:07 
GeneralRe: Creating a DBASE file Pin
DonBush11-Nov-03 2:47
DonBush11-Nov-03 2:47 
QuestionMust be a permissions thing, but what? Pin
Colin Angus Mackay6-Nov-03 4:04
Colin Angus Mackay6-Nov-03 4:04 
I have a table and everything works out okay if I log in as sa, naturally.

If I run:
SELECT TOP 1000 * FROM [site] WHERE [date]>='2000-10-01' And [date]<='2000-10-07 23:59:00'

select count(*) from site

select * from site

I get back everything I expect.

However if I log is as another user, the first SQL results in zero rows (as sa it was ~700), the second statement reports there are ~5000 in the table, and the third returns all ~5000 rows. Weird!

I have a feeling I am missing something totally obvious, but I can't figure it out, especially as the statment without the WHERE clause works fine.

Any Ideas?



--Colin Mackay--

"In the confrontation between the stream and the rock, the stream always wins - not through strength but perseverance." (H. Jackson Brown)


Answer(Actually it wasn't) Pin
Colin Angus Mackay6-Nov-03 5:33
Colin Angus Mackay6-Nov-03 5:33 
GeneralRe: (Actually it wasn't) Pin
Michael Dunn6-Nov-03 13:01
sitebuilderMichael Dunn6-Nov-03 13:01 
GeneralRe: (Actually it wasn't) Pin
Jörgen Sigvardsson6-Nov-03 13:58
Jörgen Sigvardsson6-Nov-03 13:58 
GeneralRe: (Actually it wasn't) Pin
Colin Angus Mackay7-Nov-03 1:37
Colin Angus Mackay7-Nov-03 1:37 
GeneralRe: (Actually it wasn't) Pin
Jörgen Sigvardsson7-Nov-03 3:11
Jörgen Sigvardsson7-Nov-03 3:11 
AnswerRe: Must be a permissions thing, but what? Pin
Giles7-Nov-03 3:49
Giles7-Nov-03 3:49 
GeneralRe: Must be a permissions thing, but what? Pin
Colin Angus Mackay7-Nov-03 5:10
Colin Angus Mackay7-Nov-03 5:10 
Generaldate Pin
Anonymous6-Nov-03 2:26
Anonymous6-Nov-03 2:26 
GeneralRe: date Pin
Colin Angus Mackay6-Nov-03 3:59
Colin Angus Mackay6-Nov-03 3:59 
GeneralRe: date Pin
Anonymous6-Nov-03 4:36
Anonymous6-Nov-03 4:36 
GeneralRe: date Pin
Colin Angus Mackay6-Nov-03 4:49
Colin Angus Mackay6-Nov-03 4:49 
GeneralSQL Statement question. Pin
theJazzyBrain6-Nov-03 1:25
theJazzyBrain6-Nov-03 1:25 
GeneralRe: SQL Statement question. Pin
Roger Wright6-Nov-03 3:24
professionalRoger Wright6-Nov-03 3:24 
GeneralRe: SQL Statement question. Pin
theJazzyBrain6-Nov-03 5:53
theJazzyBrain6-Nov-03 5:53 
GeneralRe: SQL Statement question. Pin
Jeff Varszegi6-Nov-03 6:57
professionalJeff Varszegi6-Nov-03 6:57 
GeneralRe: SQL Statement question. Pin
theJazzyBrain6-Nov-03 7:36
theJazzyBrain6-Nov-03 7:36 
GeneralRe: SQL Statement question. Pin
Jeff Varszegi6-Nov-03 7:39
professionalJeff Varszegi6-Nov-03 7:39 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.