Search Results

Search found 27207 results on 1089 pages for 'preferred solution'.

Page 451/1089 | < Previous Page | 447 448 449 450 451 452 453 454 455 456 457 458  | Next Page >

  • MySQL Split Time Ranges into Smaller Chunks

    - by Neren
    Hello all, I've recently been tasked with finishing a PHP/MySQL web app when the developer quit last week. I'm no MySQL expert, so I apologize if this is an intensely simple question. I've searched SO for the better part of two days trying to find a relatively easy solution to my problem, which is as follows. Problem in a Nutshell: I have a MySQL table full of start and end datetime (GMT -5) & UNIX Timestamp values covering durations of irregular length and need to break/split/divide them into more-regular time chunks (5 minutes). I'm not after a count of row entries per time chunk/bucket/period, if that makes any sense. Data Example: started, ended, started_UNIX, ended_UNIX 2010-10-25 15:12:33, 2010-10-25 15:47:09, 1288033953, 1288036029 What I'm hoping to get: 2010-10-25 15:12:33, 2010-10-25 15:15:00, 1288033953, 1288037700 2010-10-25 15:15:00, 2010-10-25 15:20:00, 1288037700, 1288038000 2010-10-25 15:20:00, 2010-10-25 15:25:00, 1288038000, 1288038300 2010-10-25 15:25:00, 2010-10-25 15:30:00, 1288038300, 1288038600 2010-10-25 15:30:00, 2010-10-25 15:35:00, 1288038600, 1288038900 2010-10-25 15:35:00, 2010-10-25 15:40:00, 1288038900, 1288039200 2010-10-25 15:40:00, 2010-10-25 15:45:00, 1288039200, 1288039500 2010-10-25 15:45:00, 2010-10-25 15:47:09, 1288039500, 1288039629 If you're interested, here's the quick & dirty on the app and why I need the data: App overview: The application receives very simple POST requests generated by a basic sensor device when its input pins go to ground, which submits an INSERT query to the database where MySQL records a timestamp (as started). When the input pins return from a grounded state, the device submits a different POST request, which causes the PHP app to submit an UPDATE query, where a modification time timestamp is inserted (as ended). My employer recently changed the periodic reporting unit of measure from Seconds "On" Per Day to Seconds "On" Per 5 Minute Interval. I had formulated what I thought would be a workable solution, but when I looked at it on paper, it looked like Rube Goldberg's nightmare constructed in MySQL, so that was out. Any suggestions as to how to break these spans into 5 minute blocks? Keeping it all in MySQL would be my preference, though I'll take any suggestions. Thank you for any suggestions you may have. Again, I apologize if this is a no-brainer. If I ask any additional questions of the SO collective consciousness in the future, I'll try to word them a bit better. Any help will be happily welcomed. Thanks, Neren

    Read the article

  • Ping remote server and wait to get data

    - by infinity
    Hi I'm building my first application for android and I've reached a point where I can't find a solution even have no idea what to search for in Google. So the problem: I am pinging a remote server with GET request through the application passing some parameters like file_id. Then the server gives back confirmation if the file exists or error otherwise, both in plain text. The error string is $$$ERROR$$$. Actually the confirmation is JSON string that holds the path to the file. If the file doesn't exists on the server it generated the error message and start downloading the file and processing it which normally takes 10-30 seconds. What would be the best way to check if the file is ready for download? I have DownloadFile class that extends AsyncTask but before I reach the point to download the file I need the URL which is dependant on the previous request which is in the main class in the UI thread. Here is some code: public class MainActivity extends Activity { private String getInfo() { // Create a new HttpClient and Post Header HttpClient httpClient = new DefaultHttpClient(); HttpGet httpPost = new HttpGet(infoUrl); StringBuilder sb = null; String data; JSONObject jObject = null; try { HttpResponse response = httpClient.execute(httpPost); // This might be equal "$$$ERROR$$$" if no file exists sb = inputStreamToString(response.getEntity().getContent()); } catch(ClientProtocolException e) { // TODO Auto-generated catch block Log.v("Error: pushItem ClientProtocolException: ", e.toString()); } catch (IOException e) { // TODO Auto-generated catch block Log.v("Error: pushItem IOException: ", e.toString()); } // Clean the data to be complaint JSON format data = sb.toString().replace("info = ", ""); try { jObject = new JSONObject(data); data = jObject.getString("h"); fileTitle = jObject.getString("title"); } catch (JSONException e) { // TODO Auto-generated catch block e.printStackTrace(); } downloadUrl = String.format(downloadUrl, fileId, data); return downloadUrl; } } So my idea was to get the content and if equal to $$$ERROR$$$ go into loop until JSON data is passed but I guess there is better solution. Note: I don't have control over the server output so have to deal with what I have.

    Read the article

  • Cross-platform editing for LaTeX documents?

    - by pufferfish
    What solutions are there for working on a LaTeX document on both Windows and Linux? It's a large document, and I will be working daily on both platforms so compatibility is essential if it's two different pieces of software. Bonus points for a solution that includes easy previewing.

    Read the article

  • Display Malformed HTML "Safely?"

    - by yar
    Let's say I have some HTML like this: <ol><li>a knock at the door, I'll be back in a second which I display as inline HTML within a div that I produce. Is there any way to stop the inner, malformed HTML from screwing up the alignment of the entire document that comes after the HTML? I realize that intelligently parsing it is one option (since I do have it on the server side), but I'm looking for a lighter solution.

    Read the article

  • How to generate changelog: git log since last Hudson build?

    - by takeshin
    I'm using Phing to do post build tasks in Hudson. I want to generate changelog containing all commits since last successful Hudson build. But looks like neither Hudson nor Git plugin for Hudson does not provide %last_build_time% variable. This would be satisfying solution, (but how to get the time?): git log --pretty="%s" --since="%last_build_time%" The only way I see for now is extracting it from the job xml file, but I do not know if it is possible with Phing. How do you generate your change logs?

    Read the article

  • Checking for nulls in ASP.NET MVC Controllers

    - by Brian McCord
    Another opinion question: What is the proper (in your opinion) to check for nulls in an MVC controller. For instance, if you have an edit controller that fetches a record from the db based on an id, what do you do if that record is not found? I found this article, but I'm not sure I like that method. Do you just check for it with an if statement and redirect to a 404 page? What solution do you use?

    Read the article

  • Why does FastCGI not work well with Ruby on Rails?

    - by Jian Lin
    It is said that FastCGI doesn't work well with Ruby on Rails deployment. Why is that? In previous experience, something either works quite well or it might be fundamentally wrong. So if FastCGI is a viable solution, why is it not reliable with RoR? Does FastCGI work well with most any language / frameworks?

    Read the article

  • How to build many projects with the same svn revision number with hudson?

    - by tangens
    I'm just starting with hudson and I'd like to build my projects like my handmade solution did before: Retrieve the current svn revision number rev. Build all projects (each with individual result) with the revision number rev. Start again with step 1 regardless if there were any changes in the meantime (to detect nondeterministic errors that don't occur on every test run). How can I configure this with hudson?

    Read the article

  • Windows Journal Eraser functionality

    - by Nitz
    Hey guys I want to add Eraser functionality in my software. I look down in the SDK of Windows Tablet PC SDK but i can't find any solution for that. there is one eraser sample in that SDK but that is not similar to feature which is in Windows Journal. DOES ANYONE KNOW HOW TO ADD THAT ERASER FEATURE IN MY C# APPLICATION [I WANT SAME AS IN WINDOWS JOURNAL]? btw i am taking reference from Microsoft Windows XP Tablet PC Edition Software Development Kit 1.7.

    Read the article

  • How to set the position .

    - by shamim
    http://www.kampyle.com/ in this url when you scroll one picture always moves. i want to know this process name.how can they do it. after click this picture it's vanish and never appear even refresh the page.How they get information i click this picture .it will be helpful for me if some one give me the solution .

    Read the article

  • .NET 4.0 on Windows Azure?

    - by Iain Galloway
    My google-fu is failing me on this one. As a possible solution to http://stackoverflow.com/questions/1679404/unit-testing-net-3-5-projects-using-mstest-in-vs2010 (but I've put this in a seperate question because it's kind of unrelated): Is there any information available regarding if/when .NET 4.0 support will be added to Windows Azure? Cheers!

    Read the article

  • Problem While Deploying Application in GlassFish

    - by Sarang
    I have to deploy an application named "mrs-ws-server.war" in glassfish. I did it using both : 1) Package File to be uploaded to the server 2) Local package File or Directory at the address : http://localhost:42328/common/index.jsf It generates the following error : Exception while loading the app : java.lang.Exception: java.lang.IllegalStateException: ContainerBase.addChild: start: org.apache.catalina.LifecycleException: org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Cannot open connection What should be the solution for the same ?

    Read the article

  • iPhone database load

    - by Mizan
    I have a sqlite databse that holds a table. The table contains about 7500 data. I've fetch the 7500 data in a UITableView. A UISearchBar is used to search the UITableView.There is no problem in simulator but when I run in a iPhone device, then it will take time to load and when I type to SearchBar then it hangs the device keyboard. Is there any optimal solution to load 7500 data in a UITableView?

    Read the article

  • How to pass a resource file string to a function in an external .js file

    - by hima
    Hi , There is a Messages.resx file under App_GlobalResources in my solution. Everytime i create a string and give a value to the string internal static string Alert_EnterUserName { get { return ResourceManager.GetString("Alert_EnterUserName", resourceCulture); } } is created automatically. Can anybody guide me how to use this string in a function which is present in a seperate .js file? Thanks in advance

    Read the article

  • How to Highlight image based on selection in JSF

    - by Paul
    The images are displayed horizontally using . At first no images are selected if selected it has to be highlighted. If user changes the selection the old has to go normal and new has to be highlighted. while in edit mode we need to highlight the already selected image and they may change in this mode so highlight should change. Bean is in session scope. pls provide some solution.

    Read the article

  • Can I set svn properties through ankhsvn?

    - by grungean
    I am using ankhsvn with VS2008. I am using a free repo hosting on the web. I am not using a svn client for this repo, but managing everything with ankhsvn (including adding solution file and project files to the new repo). I want to add the svn:needs-lock preperty to these files. I wonder if I can do this task using ankhsvn, or if I need to get another svn client for this purpose.

    Read the article

  • Jquery Dom and functions in html body

    - by slick
    I have before my closing body tag here i have the usual $(function() { function test(){ alert("test"); } }); in my html i have input tags I get an error of that test is undefined. I am trying to make IE7 call function onchange I had a whole solution working but since IE7 does not like .change() i am going to put onchange attributes within the inputs but now i have this issue. Any idea how I can solve this?

    Read the article

  • Substring text with html tags in javascript

    - by honzahommer
    Do you have solution to substring text with html tags in Javascipt? For example: var str = 'Lorem ipsum <a href="#">dolor <strong>sit</strong> amet</a>, consectetur adipiscing elit.' html_substr(str, 20) // return Lorem ipsum <a href="#">dolor <strong>si</strong></a> html_substr(str, 30) // return Lorem ipsum <a href="#">dolor <strong>sit</strong> amet</a>, co

    Read the article

  • WPF / Silverlight - Mapping API

    - by Travis
    I am about to start on a project where I need to display maps with cross streets and possibly directions. I know there are a lot of API for the web, but I was wondering what the best solution is for a desktop application. I know of Bing Maps and I believe there are some Google Maps solutions out there as well. Any help or information on good mapping API's would be greatly appreciated. Thanks.

    Read the article

< Previous Page | 447 448 449 450 451 452 453 454 455 456 457 458  | Next Page >