|
helloooo i am using this query
SELECT Format([StartDateTime], "dd mm yyyy") as StartDate, Format([StartDateTime], "dddd") as Day
FROM Messages;
output of this query:-
StartDate Day
StartDate Day
13 11 2007 Tuesday
13 11 2007 Tuesday
14 11 2007 Wednesday
14 11 2007 Wednesday
14 11 2007 Wednesday
14 11 2007 Wednesday
14 11 2007 Wednesday
now i want to count starttime and out put like this Format(all things in MSaCCess)
StartDate – Day - ChatCount
14 Nov 2007- Wednesday – 5
13 Nov 2007- Tuesday – 2
Piyush Vardhan Singh
|
|
|
|
|
u have all the query. just check in Archiviewer u will get the same query.
Devjit Das.
|
|
|
|
|
but that in sql server and its in ms access syntax is very diff between them
Piyush Vardhan Singh
|
|
|
|
|
just try to use group by or some related to access to get calculate.
Devjit Das.
|
|
|
|
|
try to use this one can solve ur problem.
SELECT Format([StartDateTime], "dd mm yyyy") as StartDate, Format([StartDateTime], "dddd") as Day,
Count(*) as ChatCount
FROM Messages where 1=1 group by Format([StartDateTime], "dd mm yyyy")
Devjit Das.
|
|
|
|
|
Eval is just syntactic sugar, it's just a shortcut that does the same thing. I got the impression you were trying to do a <%# block in your code behind, you can't - that block is to tell the aspx that it's code, you're already in the code behind and don't need it.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
I guess you are doing this in code behind. It's not possible to do this on code behind. You can use the GridViewRowEventArgs object e, and access the cell value instead.
|
|
|
|
|
how to use Distinct in ms access
i want to count distinct starttime from table
Piyush Vardhan Singh
|
|
|
|
|
Microsoft Access Team Blog: Writing a Count(Distinct) Query in Access[^]
SELECT Count(*) AS N<br />
FROM<br />
(SELECT DISTINCT starttime FROM yourtable) AS T;
i haven't tested it yet but i hope it gonna work..
btw, This form is for ASP.NET question only.. Please don't post the question related to database here. Thank you.
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
"Please vote to let me (and others) know if this answer helped you or not. A 5 vote tells people that your question has been answered successfully and that I've pitched it at just the right level. Thanks."
|
|
|
|
|
it show all starttime count. its not show according different starttime count
Piyush Vardhan Singh
|
|
|
|
|
|
iam having one text box when i enter some value in the textbox and press enter key then iam calling java script through asp.net to excute.but in one situation this java script funtction not to execute ...means it should stop and another script has to execute how it is possible
|
|
|
|
|
jagadeeshkumar2106 wrote: but in one situation
Can you code a return off condition in that function?
|
|
|
|
|
Hello Friends,
I've created a simple menu in which images get changed onmouseover..... it's working great in Internet Explorer but looking ugly in Mozilla..........
Here i'm giving the URL ......
http://www.saamstesting.com/Rough_New.aspx
|
|
|
|
|
Start firebug to find out the errors. It shows 17errors to me.
|
|
|
|
|
means.................. make it clear plz
|
|
|
|
|
FireBug[^] is an add-on for mozilla firefox. It will show the errors in the page, it's very easy to debug javascript and CSS.
|
|
|
|
|
|
I tried to access your page. I got the error in IE6... As N a v a n e e t h suggested, you should try to use "Firebug", Firefox extension to find out the error..
You can get the Firbug from this link.. If you need the tutorials for using Firebug, I have the series of Firebug tutorials for beginners. you may check-out..
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
"Please vote to let me (and others) know if this answer helped you or not. A 5 vote tells people that your question has been answered successfully and that I've pitched it at just the right level. Thanks."
|
|
|
|
|
Michael Sync wrote: I have the series of Firebug tutorials for beginners. you may check-out..
Great one
|
|
|
|
|
Thanks, man.. 
u know, i think my writing is suck.. Only this post was featured as a popular post in del.icoi.us... I think people don't like other posts of this series even I used the same effort for all of my posts.. I should read some writing books or attend some classes..
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
"Please vote to let me (and others) know if this answer helped you or not. A 5 vote tells people that your question has been answered successfully and that I've pitched it at just the right level. Thanks."
|
|
|
|
|
Michael Sync wrote: u know, i think my writing is suck.
Maybe your first language won't be english. I too have the same problem. But I found some good posts in Scott Mitchels blog which explains how a technical article can be written. Marc clifton also has a good article here in CP
|
|
|
|
|
Different browsers have different HTML/CSS/script engines. It can be a challenge to write code that looks good in them all.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Christian Graus wrote: It can be a challenge to write code that looks good in them all.
I don't feel much difficulty till now by using W3C standards and not any proprietary methods. Alternatively I used to change the CSS/JS, by checking the browser version.
|
|
|
|
|
hi
how to implement paging & sorting in gridview...both r working but if my page size is 20 and records r 60 then the sorting done on 60 records insted of 20 record of current page...
i have tried like this
public DataSet GetDatasetForPage(DataSet dsGlobal, int pageindex, int pagesize)
{
string Query = "Select * From tb where Deleted!=1";
SqlConnection myConnection = dbAccess.SQLConn;
dsGlobal.Tables[0].
SqlDataAdapter dapter = new SqlDataAdapter(Query,myConnection);
dapter.Fill(dsGlobal, pageindex, pagesize, "tb");
return (dsGlobal);
}
but i don't want to execute select statement each and every time...
Jintal Patel
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
