Re: sql select where clauses
From: Frank Hickman [MVP] (fhickman_NOSP_at_M_noblesoft.com)
Date: 12/30/04
- Next message: M. R.: "Executing Access Reports through VB 6 Code"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 30 Dec 2004 16:19:24 -0500
If there was no row that matched, the select would return an empty result
set not necessarily an error.
--
============
Frank Hickman
Microsoft MVP
NobleSoft, Inc.
============
Replace the _nosp@m_ with @ to reply.
"Sirine83" <Sirine83@discussions.microsoft.com> wrote in message
news:C294602A-4AA0-4D72-805E-F6EEF617430A@microsoft.com...
> Hi,
>
> I have a sql statement
>
> strSQL = "SELECT userName.Name, userName.ID,userName.Password FROM
> userName
> WHERE userName.ID= '" & Request.QueryString("sn") & "' ;"
>
> If the where clause is not found or true, what would that statement
> return?
>
> Basically I want to test if the where condition is found then continue
> with
> the session otherwise end the session.
>
> Thanks,
> Sirine
- Next message: M. R.: "Executing Access Reports through VB 6 Code"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
