|
 |
asp_databases thread: displaying only that data which is present in table
Message #1 by arshad siddiqui <ash_arshad@y...> on Mon, 19 Aug 2002 22:26:43 -0700 (PDT)
|
|
Hi,
I wanna dispaly only that data which is present in the
table along with the column name.I dont want to
display the data and the column for which there is no
entry in the table.
Please give me some idea and sample,I am confused.
Thanx
Best regards
--Arshad--
__________________________________________________
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com
Message #2 by bopardikar@q... on Fri, 23 Aug 2002 00:26:30
|
|
> Hi,
I wanna dispaly only that data which is present in the
table along with the column name.I dont want to
display the data and the column for which there is no
entry in the table.
Please give me some idea and sample,I am confused.
Thanx
Best regards
--Arshad--
Arshad,
You can check if the data is NULL or is a ""
(blank) put that in your SQL statement ( where .. IS NOT NULL and ..
<> '') if you dont want the whole row or
put it in you code to check for these
Hope this helps,
-Arundhati
__________________________________________________
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com
Message #3 by Vijay G <happygv@y...> on Thu, 22 Aug 2002 18:50:27 -0700 (PDT)
|
|
Arshad,
Please be more clear. What Arundhati had written would solve your purpose. If it doesnot, please mail it in details so as to help
you do exactly what u need to.
Cheers!!!
Gee.Vee
bopardikar@q... wrote:> Hi,
I wanna dispaly only that data which is present in the
table along with the column name.I dont want to
display the data and the column for which there is no
entry in the table.
Please give me some idea and sample,I am confused.
Thanx
Best regards
--Arshad--
Arshad,
You can check if the data is NULL or is a ""
(blank) put that in your SQL statement ( where .. IS NOT NULL and ..
<> '') if you dont want the whole row or
put it in you code to check for these
Hope this helps,
-Arundhati
---------------------------------
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
Message #4 by "Chetan Kelkar" <chetan@c...> on Fri, 23 Aug 2002 09:03:05 +0530
|
|
What would the actual syntax for the sql statement be ?
dim sql
sql = ("select * from tbl_name where ? is not null ")
???
chetan
----- Original Message -----
From: <bopardikar@q...>
To: "ASP Databases" <asp_databases@p...>
Sent: Friday, August 23, 2002 12:26 AM
Subject: [asp_databases] Re: displaying only that data which is present in
table
> > Hi,
> I wanna dispaly only that data which is present in the
> table along with the column name.I dont want to
> display the data and the column for which there is no
> entry in the table.
> Please give me some idea and sample,I am confused.
> Thanx
> Best regards
> --Arshad--
>
> Arshad,
>
> You can check if the data is NULL or is a ""
> (blank) put that in your SQL statement ( where .. IS NOT NULL and ..
> <> '') if you dont want the whole row or
>
> put it in you code to check for these
>
> Hope this helps,
>
> -Arundhati
> __________________________________________________
> Do You Yahoo!?
> HotJobs - Search Thousands of New Jobs
> http://www.hotjobs.com
>
|
|
|
View Cart
