Featured post

c# - Usage of Server Side Controls in MVC Frame work -

i using asp.net 4.0 , mvc 2.0 web application. project requiremrnt have use server side control in application not possibl in noraml case. ideally want use adrotator control , datalist control. i saw few samples , references in codepleax mvc controllib howwver found less useful. can tell how utilize theese controls in asp.net application along mvc. note: please provide functionalities related adrotator , datalist controls not equivalent functionalities thanks in advace. mvc pages not use normal .net solution makes use of normal .net components impossible. a normal .net page use event driven solution call different methods service side mvc use actions , view completly different way handle things. also, mvc not use viewstate normal .net controlls require. found article discussing mixing of normal .net , mvc.

mysql - Returning sequential numbers -


assume col contains system name "apple". col b has bunch of id's associated system in col a. these id's mean wrt system. col c has timestamp @ these id's generated system.

this query wrote obtain above data:

select name, id, time xtable (name='apple') , id in ('1', '2', '3', '4') group name, id, time 

the problem query returns rows long contains 1 of above numbers (not in sequence)

output of above query:

apple   3    12/1/2010 11:04  apple   4    12/1/2010 11:58 apple   1    12/1/2010 11:00 apple   1    12/1/2010 11:01 apple   1    12/1/2010 09:05 apple   2    12/1/2010 09:10 apple   3    12/1/2010 09:40  apple   4    12/1/2010 10:00 apple   2    12/4/2010 03:25 pm  apple   1    12/4/2010 12:47 pm . . . . . . 

i want tweak such returns values in 3 columns when ids in column b occur in sequence (1,2,3,4). want information because sequential ids represent set of events i'm using extract information.

it doesn't matter if event id 2 occurs before id 1. want 4 id's (1, 2, 3, , 4) occur in consecutive rows. ids mean if them appear together. mean, if there repeating ids like: 3, 3, 4, 2, 1; want first 3 excluded output.


Comments

Popular posts from this blog

c# - Usage of Server Side Controls in MVC Frame work -

cocoa - Nesting arrays into NSDictionary object (Objective-C) -

ios - Very simple iPhone App crashes on UILabel settext -