Posts

dns - How can I Force flex apps to load on a local domain? -

i have situation need swf load domain. flex set loads swf file//... i prefer domain local.somedomain.com does know how this? create simple html page has object tag , load there. load same domain html page loaded from. when hit debug button in flex builder, running html page (its in html-template folder called index.template.html). if right click project in navigator , click properties, click run/debug settings, can edit "launch configuration" , tell page load (here, can modify debug or run path url instead of folder path).

php - how do I get month from date in mysql -

i want able fetch results mysql statement this: select * table amount > 1000 but want fetch result constrained month , year (based on input user)... trying this: select * table amount > 1000 , datestart = month('$m') ... $m being month gave error. in table, have 2 dates: startdate , enddate focusing on startdate . input values month , year. how phrase sql statement gets results based on month of year? you close - got comparison backwards (assuming startdate datetime or timestamp data type): select * table amount > 1000 , month(datestart) = {$m} caveats: mind using mysql_escape_string or risk sql injection attacks . function calls on columns means index, if 1 exists, can not used alternatives: because using functions on columns can't use indexes, better approach use between , str_to_date functions: where startdate between str_to_date([start_date], [format]) , str_to_da...

mysql - How to handle large database? -

i working in 1 real-estate website , have large database around 250 fields in table , 15 lakhs (1.5 million) records in table. want give searching functionality in website so, how should design db such can search property fast these 15 lakhs records. want make site http://www.redfin.com/ . is effective 15 lakhs records should in 1 table searching ? i don't understand how should design db? using php + mysql , want ask storage engine(myisam,innodb etc.) preferred type of large database handling ? please me out. are saying database consists of 1 table? that's 250 fields in single table suggests me. if so, i'd recommend consulting design expert have schema normalized bit. as far performance goes, mysql innodb should sufficient long design proper keys , indexes. trick know queries you'll need , creating indexes make them efficient possible. your table might have 250 columns, i'm betting typical queries go after combinations of columns of time. ...

sql - How to recover the old data from table -

i have made update statement in table in sql 2008 updated table wrong data. i didn't have backup db. it's important dates got updated. is there anyway can recover old data table. thanks sna basically no unless want use commercial log reader , try go through fine tooth comb. no backup of database can 'update resume, leave town' scenario - harsh should not happen.

jquery - What triggers the IE Enhanced Security warning -

is there published set of ie enhanced security blocking rules? background: when try out jquery scripts, trigger ie enhanced security warning - matter of trial , error removing bits of code until find offending part,and see if jquery can work without it. commenting out code doesn't work, have delete page. a utility can pinpoint blocked part of html/script useful. edit: trying implement dynamic tooltips using this: http://www.queness.com/post/92/create-a-simple-cssjavascript-tooltip-with-jquery now there no shortage of other ways of doing tooltips, finding out triggers ie enhanced security warnings i'm after. are testing script webserver or local file? there known issue ie enhanced security warnings on local files. in case thats you're issue, there fix consists of placing following between opening tag. <!-- saved url=(0014)about:internet -->

javascript - js override console.log if not defined -

which solution recommend, second simpler ( less code ), there drawbacks on using ? first: (set global debug flag) // first line of code var debug = true; try { console.log } catch(e) { if(e) { debug=false; } }; // later in code if(debug) { console.log(something); } second: override console.log try { console.log } catch(e) { if (e) { console.log = function() {} } }; // , need in code console.log(something); neither, variation of second. lose try...catch , check existence of console object properly: if (typeof console == "undefined") { window.console = { log: function () {} }; } console.log("whatever");

c# - List of generic interfaces -

if have generic interface couple of implementing classes such as: public interface idataelement<t> { int dataelement { get; set; } t value { get; set; } } public class integerdataelement : idataelement<int> { public int dataelement { get; set; } public int value { get; set; } } public class stringdataelement : idataelement<string> { public int dataelement { get; set; } public string value { get; set; } } is possible pass collection of implementing classes of differing types, without having resort passing object. it not appear possible define return values as public idataelement<t>[] getdata() or public idataelement<object>[] getdata() any suggestions? you can declare: public idataelement<t>[] getdata<t>() and public idataelement<object>[] getdata() although latter isn't you're after (your interface won't variant in c# 4 uses t in both input , output position; if v...