Search Results

Search found 36705 results on 1469 pages for 'update apt xapian index'.

Page 182/1469 | < Previous Page | 178 179 180 181 182 183 184 185 186 187 188 189  | Next Page >

• MySQL: Update table column from subquery result

  - by Jhourlad Estrella

  On the Members table are columns "MemberID" and "PointsEarned". I want to update the PointsEarned column from the result of this query: SELECT m.MemberID, m.UserName, ( (SELECT COUNT(*) FROM EventsLog as e WHERE e.MemberID=m.MemberID AND e.EventsTypeID=2)*10 ) + ( (SELECT COUNT(*) FROM EventsLog as e WHERE e.MemberID=m.MemberID AND e.EventsTypeID=3)*3 ) + ( (SELECT COUNT(*) FROM ChatMessages as c WHERE c.MemberID=m.MemberID)*.1 ) as PointsEarned FROM Members as m Can anybody tell me how I should do it with a single query? Thanks!

  Read the article

• Javascript update before page loads in ASP.NET

  - by user204588

  Hello, I'm trying to update values from a xml file into textboxes. I have this javascript being called in the Page_Load event this.Page.ClientScript.RegisterStartupScript(this.GetType(), "Script", sb.ToString(), true); I click the continue button which does a post back but the values are not updated until I refresh the page again which makes me think the js isn't being run until after the page is returned. I'm wondering how to have the values updated when the page is refreshed after the button postback. thanks

  Read the article

• HTML: Update Google Search Title and Summary

  - by Patrick

  hi, I want to change the title and summary of my website on google search results. Is enough to change the meta-data and title on my html files, and wait few weeks to let google update the results ? (how long does it take on average ?) thanks

  Read the article

• Update ListView in the main thread from another thread

  - by Wilson

  I have a separate thread running to get data from the internet. After that, I would like to update the ListView in the main thread by calling adapter.notifyDataSetChanged(). But it does not work. Any workaround for that? Thanks.

  Read the article

• Symfony2: update query with query builder

  - by Ichigo Kurosaki

  This is my query $id contains primary key and $status contains new status public function updateStatus($id,$status) { $qb=$this-createQueryBuilder('b') -update() -set('b.status',$status) -where('b.id='.$id); echo $qb; return $qb-getQuery() -getResult(); } Problem I am facing is [Semantical Error] line 0, col 56 near 'Complete WHERE': Error: 'Complete' is not defined.

  Read the article

• Update a Google Doc (or file stored with Docs) with PHP

  - by tb

  It seems Zend Gdata doesn't provide a way to interface with the PUT API for Google Docs. I'd like to clear a document with a known id and update its contents. Should I authenticate with Zend's Gdata and use an HTTP PUT request? How?

  Read the article

• How to update sharepoint list data with TeamCenter Data

  - by hellboy406

  Hi, I have a sharepoint List.We will get the data from TEAMCENTER from there we will enter manually into the List. Inorder to automatically update the sharepoint List with Teamcenter data is there any way????

  Read the article

• Update existing pdf with C#

  - by Prashant

  I have an existing pdf file which needs to be updated with information which varies with each client. There are around 50 clients. I have to update the pdf with these. How can I acheive the same in C#. The pdf has to be shown in the browser (only IE) Is there a third party dll which could be used, which would parse the pdf. Then write to the pdf.

  Read the article

• why is ADODB inserting NULL values on update?

  - by every_answer_gets_a_point

  i have: With rs .AddNew ' create a new record ' add values to each field in the record .Fields("datapath") = dpath .Fields("analysistime") = "atime" .Fields("reporttime") = "rtime" .Fields("lastcalib") = "lcalib" .Fields("analystname") = "aname" .Fields("reportname") = "rname" .Fields("batchstate") = "bstate" .Fields("instrument") = "NA" .Update ' stores the new record End With when i check the database, it looks like it ONLY inserted the last field! has anyone encountered this problem?

  Read the article

• Error during data UPDATE in php

  - by Piyush

  $sql = "UPDATE tblprofile SET name = '$membername' , f_h_name = '$fathername', maritalS = '$mstatus' , dob = '$dob' , occupation = '$occupation' , nominee = '$nominee' , address1 = '$address1' , address2 = '$address2', city = '$city', district = '$district', state = '$state', pin = '$areapin', mobile = '$mobileno', email = '$email', PANno = '$panno', bankname = '$bankname', branch = '$branch', accountno = '$accountno' WHERE userId = '$_SESSION['UserId']' "; //line 212 if(mysql_query($sql)) { echo "Updation Done."; } Error comes in browser : Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in C:\xampp\htdocs\303\saveEditProfile.php on line 212

  Read the article

• update Eclips Plugin with JDE4.7

  - by Master

  Hello every one I am using eclipse with JDE4.5 plugin, i want to update eclips plugin with jde 4.7. what should i do Thanks

  Read the article

• how to update newly exposed area of a scrolled widget

  - by yan bellavance

  I have setAttribute(Qt::WA_OpaquePaintEvent,true) on a widget. From a mouseMoveEvent, I scroll the widget. Now what I need to do is to update the newly exposed area, but it seems that doing this from the paintevent function create an artifact because there is a delay created when the user keeps scrolling. In other words, the widget seems to have scrolled again between the call to scrool and the call or end of paintevent. For example, while the paint event is trying to draw the desired area, the widget is still scrolling

  Read the article

• Update model instance with dynamic field names

  - by herpderp

  What I want to do is pretty simple: f=Foobar.objects.get(id=1) foo='somefield' bar='somevalue' f.foo=bar f.save() This doesn't work as it tries to update the f object's 'foo' field, which of course doesn't exist. How can I accomplish this?

  Read the article

• pre-update svn script to filter what get

  - by DrLuk

  Imagine a repository with many kind of files. Then, I want to get from this repository just some kind of files in a "filter process". I mean ALL FILES are versioned. But to my local work, I just wanna i.e get *.php files, ignoring download *.jpg instead. I think about client-site hook script (pre-update). Anyone know if is it possible? Thanks!

  Read the article

• ASP.Net : Need to run javascript on update panel load completed

  - by user279244

  Hi, I need to run a javascript function when the update panel is loaded completely(I want to scroll), and not on initial page load. Please suggest. Thanks

  Read the article

• Best way to update record X when Y is inserted

  - by Saif Bechan

  I have a huge table that is mainly used for backup and administrative purposes. The only records that matters is the last inserted record. On every hit to order by time inserted is just too slow. I want keep a separate table with the last inserted id. In PHP I now insert, get last inserted id, and update the other table. Is there a more efficient way to do this.

  Read the article

• How to test an iPhone application update?

  - by sfkaos

  I already have an iPhone application (version 1.0) available in the App Store and am ready to submit a newer version (version 1.1). How do I test the new upgrade to make sure that the current sqlite database and property list files on the earlier version do not get deleted/overwritten etc? The new version assumes the old data in both the sqlite database and property lists remain. Or better yet, is there a resource I can use to walk me through what to watch for when developing an application update?

  Read the article

• If I update a view, will my original tables get updated

  - by vaibhav

  suppose I have tables Employee, Locations. and I have a view viewEmpLocation which is made by joining Employee and Locations. Now If I update the view, will data in original table get updated.

  Read the article

• PHP+MySQL Update TimeStamp and get NOW() back

  - by Ben

  Is it possible to merge these two mysql queries into one? I want to get NOW() returned to a php variable. mysql_query('INSERT INTO translate (IDRef, RefType, Lang, Text, LastChangeTS) VALUES ('.$id.', \''.$reftype.'\', \''.$lang.'\', \''.$text.'\', NOW()) ON DUPLICATE KEY UPDATE text = \''.$text.'\', LastChangeTS = NOW()'); mysql_query('SELECT LastChangeTS FROM translate WHERE IDRef = '.$id.' AND RefType = \''.$reftype.'\' AND Lang = \''.$lang.'\'');

  Read the article

• android how to force the update of a widgetapp

  - by bob

  I'll need to force the update of a widgetapp every time the user turn the screen on. Any idea or snippet ? Thanks

  Read the article

• [CakePHP] update instead of delete

  - by user198003

  hi all, with cakephp, is it possible to have update sql action instead of delete (i would like to set some kind of flag, so it "looks" like it is deleted)? tnx in adv!!!

  Read the article

• while Reseting auto increment for a table, query taking long time to update in MYSQL

  - by urssujith

  "ALTER TABLE tablename AUTO_INCREMENT = 10000000 " taking long time to update. why? i need to get optimize this query. Please help

  Read the article

• Update WallPaper with text using c#

  - by srk

  I am doing an application that runs in background. Since there are no forms, I need to show some info on the desktop wallpaper. how can i achieve this ? The application need to update the info on wallpaper.

  Read the article

• Update Text Field after font change (Win32)

  - by user146780

  After I use setcontrolfont, the text of the text field does not update. The onnly way I fixed this is by removing then readding all text but this seems hackish. How can I do it properly? Thanks

  Read the article

• Docmd.TransferText to update data

  - by every_answer_gets_a_point

  i am using Docmd.TransferText to import data from a text file into my access table. i would like it to do the following: if the record already exists, then update it if the record does not exist then add it how do i accomplish this? currently i have this line: DoCmd.TransferText acImportDelim, yesyes, "table3", "C:\requisition_data_dump.txt", True

  Read the article

< Previous Page | 178 179 180 181 182 183 184 185 186 187 188 189  | Next Page >