|
Hi to all,
I have one query. In my sql auery in am selecting data from two
tables for that purpose i have used join query.I have used follwoing
query.
select distinct blog_new.blgid,blog_new.blogtitle,blog_new.createddate from blog_new,blog_post where blog_new.blgid=blog_post.blgid and blog_new.status=1 order by blog_post.editeddate desc
My question is that if there is 3 same blogtitle but they have different id
then what is the output of that query. Is the query return me three row or
only one row.
Thanks.
Rahul.
People Laugh on me Because i am Different
but i Laugh on them Because they all are same.
|
|
|
|
|
hi Rahul,
you are using distinct blgid and join on blgid so even though thr are 3 same blogtitle but if they have diffrent id it will return 3 records
pallavi
|
|
|
|
|
Hi Pallavi,
If they have same blogtitle and same id then it will return only one
row. Is it correct?
Thanks.
Rahul.
People Laugh on me Because them
i am Different but i Laugh on Because they all are same.
|
|
|
|
|
Hi Rahul,
if you have same ids how will u get 3 records ..its one record na ..
see in join, u join in which field is matter a lot .. so if u are joining on blogid it must be unique...and so it will have uique ids no matter title same or diffrent.
if u have any query plz ask
pallavi
|
|
|
|
|
Thanks Pallavi,
Regards
Rahul.
People Laugh on me Because i am
Different but i Laugh on them
Because they all are same.
|
|
|
|
|
Hi Pallavi,
When i run this query in query analyzer it shows me three row with
same id.My query is as follow.
select distinct blog_new.blgid,blog_new.blogtitle,blog_new.createddate,blog_post.editeddate from blog_new,blog_post where blog_new.blgid=blog_post.blgid and blog_new.status=1 order by blog_post.editeddate desc
can u tell me why?
People Laugh on me Because i am
Different but i Laugh on them
Because they all are same.
|
|
|
|
|
Hi Rahul,
can u show me out put here .. as i dont know if u r using distinct blgid it is showing 3 records to u ?
Do u have one record in first table and 3 records in second table with same ids ?
pallavi
|
|
|
|
|
3 Exma tips for student 2007-11-18 17:47:17.000<br />
3 Exma tips for student 2007-11-05 15:56:20.950<br />
11 New blog under Exam Study tips 2007-11-05 15:54:17.780<br />
12 This is first blog by user Swati. 2007-11-05 12:39:43.123<br />
13 Blog Created on 11/03/2007 2007-11-03 17:15:38.297<br />
14 This is second blog created by Swati on 11/03/2007. 2007-11-03 17:12:24.437<br />
13 Blog Created on 11/03/2007 2007-11-03 16:32:01.293<br />
12 This is first blog by user Swati. 2007-11-03 11:37:26.170<br />
11 New blog under Exam Study tips 2007-11-02 16:47:43.263<br />
3 Exma tips for student 2007-10-31 14:47:19.107<br />
6 First Blog by NItin 2007-10-30 18:26:12.183<br />
4 New action Movies coming soon 2007-10-29 17:43:20.310<br />
5 Part time jobs 2007-10-29 17:22:20.857<br />
6 First Blog by NItin 2007-10-23 16:01:47.763<br />
5 Part time jobs 2007-10-23 15:21:10.717<br />
1 What are database. 2007-10-20 19:41:14.780<br />
3 Exma tips for student 2007-10-18 17:47:17.000<br />
4 New action Movies coming soon 2007-10-18 17:47:17.000<br />
<br />
People Laugh on me Because i am
Different but i Laugh on them
Because they all are same.
|
|
|
|
|
hi,
can u try query like this .. and tell me what is out put now...
select blog_new.blgid,blog_new.blogtitle,blog_new.createddate
from blog_new inner join blog_post on blog_new.blgid = blog_post.blgid and blog_new.status= 1
order by blog_post.editeddate desc
pallavi
|
|
|
|
|
Hi Pallavi,(sorry for late rply)
I fired query given by u but the result is same.It shows three column
with same id.
Thanks.
People Laugh on me Because i am
Different but i Laugh on them
Because they all are same.
|
|
|
|
|
Hi rahul,
can u explain me u r table relationship? means is your first table have blogid as primary key and second table with blogid as forgien key?
can u give me few table content of both tables (2, 3 records for both tables)?
pallavi
|
|
|
|
|
Hi
My first table name is Blog_New which having
1)blgid- Primery key
2)blgname-
3) blogtitle
4)createddate
5)editeddate
and my second table is
Blog_Post
1)postid- primery key
2)blgid- forein key
3)posttitle
4)posttext
5)createeddate
6)status
7)createddate
8)editeddate
First three columg of my second table is as follow.
first column postid(P.K),second blgid(F.K) and third Posttitle
1 3 Exam tips for 12 std student.(updated)
3 3 This is second post
4 1 This is post for database blog (updated)
5 4 Which are the New action Movie cming this month.
6 3 This is thire post in this blog.
7 5 Part time jobs in Abroad
8 6 How to do timepass.
9 5 Uploading image into Post.
10 4 This is the new image Picture of James 007
11 6 Which is teh best selller book of the year 2007.
12 10 This is my first Post under Sanjay's Blog.
13 3 How to Create a blog.
14 10 This is new post posted on 11/02/2007
15 11 New post under the blog created on 11/02/2007.
16 11 Test for Blog.
17 12 Hi to all i am new here.
18 12 Which are the best natural places in India.
19 13 This is the post in Blog Exam Study tips created on 11/03/2007
20 13 This is second post in Blog Exam Study Tips created on 11/02/2007.
21 14 This is second post in Blog Exam Study Tips created on 11/02/2007.
22 4 This post publish property is set to false.
and first three column of my second table is as follow.
First column blgid(P.K),userid,third blogtitle
1 4 What are database.
2 4 College Financing. and its Adv
3 4 Exma tips for student
4 4 New action Movies coming soon
5 4 Part time jobs
6 7 First Blog by NItin
7 7 Todays best muxic seller Album
8 4 Which is the best field now a dayz?
9 4 Which is the best field now a dayz?
10 4 Sanjay's Blog
11 4 New blog under Exam Study tips
12 10 This is first blog by user Swati.
13 4 Blog Created on 11/03/2007
14 10 This is second blog created by Swati on 11/03/2007.
This is my table structure and its content. Both table contain created
and edited date column.
Thanks.
-- modified at 10:26 Monday 5th November, 2007
-- modified at 10:31 Monday 5th November, 2007
People Laugh on me Because i am
Different but i Laugh on them
Because they all are same.
|
|
|
|
|
Dear all,
i have grid view in which the first column consist of image button which when clicked redirects to new page. In the last column i have a textbox(non data base field) . now what i want is just to display textbox value in new page. how can i do this
|
|
|
|
|
HI
Use OnRowCommand event of gridview and under that event use findcontrol
event to find out your text box. Once you find textbox use text
property to get value in textbox and redirect to second page. Put this
value in session or pass using qhery string.
Hope this help.
Regards.
Rahul.
People Laugh on me Because
i am Different but i Laugh on them Because they all are same.
|
|
|
|
|
|
|
Welcome.
People Laugh on me Because i am
Different but i Laugh on them
Because they all are same.
|
|
|
|
|
is any body who can help me in delphi.. doubts?
thanks
mahen
|
|
|
|
|
mahenputta wrote: doubts
I have lots of doubts that anybody can help you with Delphi here. You did notice that this site is Your Visual Studio and .NET Resource didn't you?
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
i know.. but many guys.. who are expertise in visual studio.. are also experienced in delphi..
|
|
|
|
|
mahenputta wrote: i know.. but many guys.. who are expertise in visual studio.. are also experienced in delphi..
But surely a Delphi forum would be a better choice. I'm sure that CodeGear/Borland have links to suitable forums.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
|
Hello,
This is ravikumar.I have a form Default.aspx.
In code behind(Default.aspx.cs) i have a method. Method is
public void Hello()
{
Response.Write("Hellooooooooooo");
}
I have a user control named User1.I have placed User1 on Default.aspx.In User1.ascx i have placed a button named "print".I wrote nothing in User1.ascx.cs;I wanna call Hello() method when i click on Print Button.
plz help me............
ravikumaryazali
|
|
|
|
|
yazali wrote: Need Help
A meaningful subject will look good
yazali wrote: ;I wanna call Hello() method when i click on Print Button.
I don't think this is a good way to do so ? Why you need to do this ? Have you tried creating an object for that page and calling the Hello() method ?
|
|
|
|
|
yes i tried to create that class object.but it is not allowed.I know this is not good way.In interview this question asked me.try to answer this.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
