Posts

sql server - Maximum row size of 8060 Error -

i stuck , can not figure out. have ideas? appreciate help. i have table in sql server 2008 following defintion: i can insert/delete/update without error. however, when run select statement filter out 1 single item, got following error: msg 511, level 16, state 1, line 1 cannot create row of size 8104 greater allowable maximum row size of 8060. if remove condition a15.member_parent_level_id4 in (91329) ran fine. if add 5 or 10 criterias ran fine, including 1 throwing error if add itself. [mstr_prod_hier_id] [int] not null, [mstr_prod_hier_desc] [varchar](50) null, [member_group_level_id1] [int] null, [member_group_level_desc1] [varchar](60) null, [memberkey_sort1] [int] null, [member_group_level_id2] [int] null, [member_group_level_desc2] [varchar](60) null, [memberkey_sort2] [int] null, [member_group_level_id3] [int] null, [member_group_level_desc3] [varchar](60) null, [memberkey_sort3] [int] null, [member_level_id4] [int] null, [member_level_desc4] [varchar](60) n...

Unix syntax for the grep command for only an ending character -

for file james , when run command: cat james | grep ["."] i lines contain dot. how lines end dot? to find lines end . character: grep '\.$' james your cat command unnecessary ; grep able read file itself, , doesn't need cat job it. a . character special in regular expressions, matching 1 character; need escape \ match literal . character. and need enclose whole regular expression in single quotes because \ , $ characters special shell. in regular expression, $ matches end of line. (you're dealing characters treated specially shell, , others treated specially grep ; single quotes shell out of way can control grep sees.) as square brackets used in question, that's way escape . , it's unusual. in regular expression, [abc] matches single character that's of a , b , or c . [.] matches single literal . character, since . loses special meaning inside square brackets. double quotes used: ["."] unneces...

facebook - How to tell when FB.init() completed? How to tell if the user is not connected when to app starts? -

i'm developing using facebook plugin phonegap/cordova. read maybe every single post or example plugin in stackoverflow , wherever, still have unresolved issure. when app starts, need if user logged in --> continue logged in main page. if user not logged in --> present screen "push connect button login" now, when app starts- call "fb.init" method. problem is, don't have callback use know when completes, , check login status. if subscribe auth.statuschange event before fb.init, event raised when user logged in. not enough, because need know when not logged in. if call "fb.getloginstatus" after fb.init, doesn't work since thing async , tries login status before "fb.init()" completed. in other words, can't tell when user not logged in when app starts. thank you, liran. ok, solved issue right timeout + little things. don't timeout, solution found "unknown" session status moment. here code:...

Cascading/Inherited/Shared Rails configuration environments -

my staging , production environment rails configuration 99% same few things set differently (e.g. log level), , i'd eliminate duplication between 2 environment files. for example, have this: # config/environments/staging.rb myapp::application.configure config.cache_classes = true config.static_cache_control = "public, max-age=31536000" config.log_level = :debug # ... end # config/environments/production.rb myapp::application.configure config.cache_classes = true config.static_cache_control = "public, max-age=31536000" config.log_level = :info # ... end any recommendations on best way create shared configuration doesn't affect development environment? in projects, have 3 production-like environments have file called shared_production.rb under config/environments put common configuration myapp::application.configure config.cache_classes = true config.consider_all_requests_local = false #more shared configs end and...

schema - Propel ORM - how do I specify tables to reverse engineer? -

i have database few dozen tables. app deals 1 of tables. i'd propel generate schema table. there way can specify table(s) in build.properties? a solution write own schema parser ignores tables. these tables exclude read config file or so. take @ mysqlschemaparser.php idea of how such parser works. extend such existing parser , override parse() method. when tables added, check them exclusion/inclusion , add them if meet subset criteria. how create custom propel tasks described in propel cookbook . instead of invoking propel-gen reverse invoke customized reverse engineering task. if done neatly, i'd find worth being added contribution propel project , you'd deserve fame that! :-)

vba - Excel Do While Find -

below code uses .find function in excel find location dodcell appears in sheet2 , add reecell column 18 in sheet2 sheet1. suppose loop based on how many times finds strsearch in rrange. but, running once , stops, think there mistake in "do while loop" can't seen fix it. any thoughts? so after fixing errors pointed out in code have revised sub. think have addressed loop issue, know program running once , freezing excel , need restart excel. think have created infinite loop don't know how fix ideas? sub addnumber() 'used add ree value dod projects dim ssht worksheet, dsht worksheet dim lastrow integer dim firstaddress string dim strsearch string dim reecell range, dodcell range, arange range, rrange range, aarange range dim hold1cell range, holdcell range, lastcell range set ssht = worksheets("sheet1") set dsht = worksheets("sheet2") set rrange = ssht.columns(18) set arange = ssht.colum...

c# - GroupBox growing in a inherited form -

i´ve created base form. in base form, has groupbox component. when use form inherit, groupbox inherited growing more form. need ajust time when close , open design of forms inheriteds form base. thanks! using dock property of group box in pagecontrol i´ve resolved problem. reply.