SELECT * FROM Your_Table WHERE YourColumn1 = 'foo'
AND USERNAMEFIELD = '#this is what I'm missing#'
best, paul
At 09:41 AM 11/14/00 -0600, you wrote:
>I've been watching this list for a while and reading what I can find. Yet
>I'm still stuck. Please tell me if I've missed something. I have an
>application where I want the user to see only those sql records (using MS
>SQL 7.0) where a certain field is equivalent to their NT user id. It seems
>from what I've seen that it either can't be done or I may need some other
>component to make that happen. Is there a way to evaluate what the NT user
>id is? I don't need to validate their password. Once they've logged in I
>can assume they are that user. So all I really need is to be able to write
>a query that would select only the records where the field USERNAMEFIELD EQ
>#this is what I'm missing#. Can someone point me to a resource for figuring
>this out? TIA.
>
>Athelene Gieseman
>[EMAIL PROTECTED]
>------------------------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/[email protected]/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
>a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
