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.

javascript - Find an unused number in a bunch of numbers -


i have huge table filled numbers (1001001..1009999) , there bunch of unused numbers in area. so, have these numbers returned doing:

select my_identifier my_table 

that return used numbers. how list of unused numbers table? work serverside (rhino/jaxer) javascript , database oracle 10g.

thanks,

the following query give need:

select seq_num   (select (lvl + &&v_from - 1) seq_num           (select *                   (    select level lvl                               dual                         connect level <= (&&v_to - &&v_from) + 1)))  seq_num not in (select my_identifier my_table); 

replace &&v_to , &&v_from boundary numbers.

reference: http://oraqa.com/2006/01/20/how-to-generate-sequence-numbers-between-two-numbers/


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 -