Posts

Crystal Reports 2 column crosstab -

using crosstab expert in crpts, populating columns selection 2 column names , using preview, report has cannot tell what. report has helpdesk total date , out of total there group count dept. report looks great 1 column selected. however, once select column fr db , select columns crosstab expert, columns in report preview displayed hard tell what since no , yes columns. have keep groups together, column totals on top, , row totals on left "checked" out. want have: grand toatl column(for helpdesk) total dist. classrooms afected totals can help? new cr , have not been able make "hit" researching. based on above, want report like: (col 1) (col 2) (col 3 date group district classes affected crosstab expert has: 2 rows, 2 summaries(sum on date , grandtotal on top), 1 col(which works great col 2 used column not when include col 3). district count of district's in group classes affected count of groups count. i...

How to setup MySQL table to follow a variable over time? -

say have several registered users in website. users saved on single table 'users' assigns unique id each 1 of them. i want allow users track expenses, miles driven, temperature, etc. i can't sure each user enter value all trackable variables when login -- example of happen be: 'example data' user date amount miles temp etc 1 3/1/2010 $10.00 5 54 2 3/1/2010 $20.00 15 1 3/12/2010 5 55 1 3/15/2010 $10.00 25 51 3 3/20/2010 45 3 4/12/2010 $20.00 10 54 what best way set tables situation? should create table exclusive each user when register? (could end thousands of user-exclusive tables) 'user-1 table' date amount miles temp etc 3/1/2010 $10.00 5 54 3/12/2010 5 55 3/15/2010 $10.00 25 51 'user-3 table' date ...

Zend Validator location -

do need save custom zend validator location "zend/validate"? i'd rather create folder custom validation scripts, cannot find in zend documentation other changing namespace. here error message. "plugin name 'usernamevalidate' not found in registry; used paths: zend_validate_: zend/validate/" i'd tell search additional paths. i able solve problem using addelementprefixpath('application_validate', '../application/validate', 'validate');

android - Question about an activity killed by system -

suppose root activity starts activity b, , activity b starts activity c. current task stack contains a, b, c. suppose system memory got low, , os killed activity b. after that, user pressed key exit activity c. question is, after activity c exits, activity b recreated , shows up, or activity shows up? thanks. unless activity b called finish(), should show again.

php - shell_exec ( 'svn up /var/www/mydirectory' ) not working -

i cannot shell_exec ( 'svn /var/www/mydirectory' ) work. reason nothing happens. tempted think permission issue, not sure. can execute no problem: shell_exec ( 'svn help' ) this because of file-permission issue. in php configurations, /var/www/* not writable php user. svn /var/www/... tries write directory, while svn help not. /var/www/ not writable php user security precaution. making writable makes site more vulnerable because if bug found in php scripts, attacker more capable of taking complete control on server. (because able write own php code on server) if /var/www/mydirectory not contain php code needs execute, should safe chmod -x+w mydirectory/ . if mydirectory contains php code need execute, , you've assessed there not more secure way of doing it, use chmod +w mydirectory/ . note, recommend making cron job or using other way of running svn up operation different user, , leaving read-only php process.

Will adding a column to table break asp.net app? -

i've inherited asp.net web app, , coming speed on being dba well. before break anything, if add new column table, there chance break existing page crud operations? new column not, of course, part of existing operations , grid controls, , if allow contain null (so inserts don't require value input), ok? i realize deleting column break things. adding nullable column seem harmless enough. (i think). but want check! thanks well, depends on how app written. if, example, code uses column numbers instead of names it's things break, if add columns in between ones exist. hopefully app has enough unit tests try out confidence. if not, maybe adding unit tests should first priority.

Forward Geocoding example Code for android? -

has developed code converting address lat/long value. getting confused geocoder. of great if can sample code, using below code. gives error no address found . not crashes public void oncreate(bundle savedinstancestate) { super.oncreate(savedinstancestate); setcontentview(r.layout.main); mymap = (mapview) findviewbyid(r.id.simplegm_map); // map xml btnsearch = (button) findviewbyid(r.id.simplegm_btn_search); // button xml adress = (edittext) findviewbyid(r.id.simplegm_adress); // address xml gc = new geocoder(this); // create new geocoder instance btnsearch.setonclicklistener(new onclicklistener() { public void onclick(view v) { pd = progressdialog.show(simplegooglemaps.this, "working..", "searching address", true, false); //show progress dialog //thread thread = new thread(simplegooglemaps.this); //then create new thread // thread.start(); //and...