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.

sql - How to change results in Access query? -


i have table, we'll call users.

id username type 

the type field 2 character type, each user either has us, mo, ad. not sure why original developer did this, cannot change method, unfortunately.

1 mike 2 tim ad 3 mark mo 

instead of returning us, ad... etc types in access, i'd query replace user, replace mo moderator, , replace ad admin.

is possible?

kind of select * users , if statements within access (if us, user). not sure how proceed?

you can create table user, mo moderator etc mappings , use in join.
lot easier maintain, extend (i.e. different languages) hard-coding drawback need maintain mapping table.


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 -