|
 |
asp_databases thread: Detecting what part of SQL Statement was executed
Message #1 by imran.saleem@b... on Tue, 19 Nov 2002 11:36:43
|
|
Hi,
hope you guys can help me with this. Is there some way of detecting
which part of an SQL statement has been executed. For example if i have a
SQL statement:
select surname, post_title from (people inner join.......) where
quicksearch value = surname OR quicksearch value = post_title.
Is it possible to detct which part of the OR part was successful?
Thanks for your help.
Message #2 by "Drew, Ron" <RDrew@B...> on Tue, 19 Nov 2002 07:33:38 -0500
|
|
To my knowledge no unless you break it into 2 sql statements which I
would not do. You should also think about using IN instead of OR when
testing for results for the same field.
-----Original Message-----
From: imran.saleem@b... [mailto:imran.saleem@b...]
Sent: Tuesday, November 19, 2002 6:37 AM
To: ASP Databases
Subject: [asp_databases] Detecting what part of SQL Statement was
executed
Hi,
hope you guys can help me with this. Is there some way of detecting
which part of an SQL statement has been executed. For example if i have
a
SQL statement:
select surname, post_title from (people inner join.......) where
quicksearch value =3D surname OR quicksearch value =3D post_title.
Is it possible to detct which part of the OR part was successful?
Thanks for your help.
Message #3 by imran.saleem@b... on Tue, 19 Nov 2002 12:56:09 -0000
|
|
thanks drew
-----Original Message-----
From: Drew, Ron [mailto:RDrew@B...]
Sent: Tuesday, November 19, 2002 12:34 PM
To: ASP Databases
Subject: [asp_databases] RE: Detecting what part of SQL Statement was
executed
To my knowledge no unless you break it into 2 sql statements which I
would not do. You should also think about using IN instead of OR when
testing for results for the same field.
-----Original Message-----
From: imran.saleem@b... [mailto:imran.saleem@b...]
Sent: Tuesday, November 19, 2002 6:37 AM
To: ASP Databases
Subject: [asp_databases] Detecting what part of SQL Statement was
executed
Hi,
hope you guys can help me with this. Is there some way of detecting
which part of an SQL statement has been executed. For example if i have
a
SQL statement:
select surname, post_title from (people inner join.......) where
quicksearch value = surname OR quicksearch value = post_title.
Is it possible to detct which part of the OR part was successful?
Thanks for your help.
|
|
|
View Cart
