Search Results

Search found 41071 results on 1643 pages for 'post update'.

Page 160/1643 | < Previous Page | 156 157 158 159 160 161 162 163 164 165 166 167  | Next Page >

• Update with inner join ?

  - by phenevo

  I have two databases: DB1 and DB2 How to do something like: update myServer.DB1.dbo.hotels.Name = myServer.DB2.dbo.hotels.Name join myServer.DB2.dbo.hotels on myServer.DB2.dbo.hotels.Code= myServer.DB1.dbo.hotels.Code where myServer.DB2.dbo.hotels.CountryCoe != myServer.DB1.dbo.hotels.CountryCode

  Read the article

• update query with join on two tables

  - by dba_query

  I have customer and address tables. query: select * from addresses a, customers b where a.id = b.id returns 474 records For these records, I'd like to add the id of customer table into cid of address table. Example: If for the first record the id of customer is 9 and id of address is also 9 then i'd like to insert 9 into cid column of address table. I tried: update addresses a, customers b set a.cid = b.id where a.id = b.id but this does not seem to work.

  Read the article

• C# how to update file(leave old data)

  - by lolalola

  Hi, Now I'm writing to a file: TextWriter tw = new StreamWriter(@"D:/duom.txt"); tw.WriteLine("Text1"); When i writen second time all data delete and write new. How update data? Leave old data and add new

  Read the article

• How to update two tables in a single query in MS SQL

  - by Aditya Acharya

  Can it be possible to update two tables writing single query. So that i do not to execute two queries and to track whether both are successful.

  Read the article

• update to ubuntu 10.04 failed

  - by Denis

  Hi, I did an update of my Ubuntu to version 10.04 lts. Everything was ok until final reboot. When I boot I now have the following message: Ubuntu 10.04 LTS laptop tty1 laptop login: [ 29.828287] hci_cmd_task: hc10 commnd tx timeout What can I do? Thanks

  Read the article

• Cannot add or update a child row: a foreign key constraint fails

  - by sarah

  Hi All, i am having a user table which has desname as FK referring to des table ,i am trying to add desname in user but i am gettng Cannot add or update a child row: a foreign key constraint fails error. desname is prepopulated and i am selected the same for he user.Where i am doing wrong I ma using mysql and hibernate hbm

  Read the article

• vim does not update screen right away

  - by suresh

  I am using the cw (change word) command and the screen does not update until i press the ESC key. I have already set "slow" in my .vimrc.

  Read the article

• WHERE id IN doesn't work in UPDATE

  - by Donator

  UPDATE static SET money = money + '100' WHERE member_id IN (SELECT member_id FROM race WHERE race_id = '$race_id')" I want to retrieve member_ids and give for all of them +100 money. What's wrong?

  Read the article

• WHERE id IN doesn't work in UPDATE

  - by Donator

  UPDATE statistics' SET money = money + '$money' WHERE member_id IN ((SELECT member_id FROM races WHERE l_id = '$mem_id'), $other_id) What's wrong with that? I want to retrieve all member_ids from races and also include to member_id $other_id. Without $other_id it works. By the way, it gives me "Subquery returns more than 1 row" error.

  Read the article

• need help with a simple SQL update statement.

  - by Tony

  There's a field with type of varchar. It actually stores a float point string. Like 2.0 , 12.0 , 34.5 , 67.50 ... What I need is a update statement that remove the ending zeros of fields like 2.0 , 12.0 , change them to their integer representation , that is 2 , 12 ...,and leave 3.45 , 67.50 unchanged . How should I do this ? I am using oracle 10.

  Read the article

• easy update web application multiple server

  - by v14nt0

  how to easily update php web application to multiple server ? i read about capistrano, can it be use for PHP ? Please Help Regards, REV

  Read the article

• how to update two input box in jquery

  - by Mac Taylor

  hey guys i create two input text fields , one for title and another for permanent link i need to update the second filed automatically when user is typing the tilte how can i do such a thing in jquery /php somehow im looking for a way to simulate wordpress creation of permanent link in post section

  Read the article

• Restrict update Column

  - by Kushan Hasithe Fernando

  Is it possible to restrict updating a column in SQL without using a trigger ? If so how ? (need the query) PS: I mean, I have a table CREATE TABLE MYBUDGET.tbl_Income ( [IncomeID] INT NOT NULL IDENTITY(1,1), [IncomeCatID] INT NOT NULL, [IncomeAmnt] MONEY NOT NULL, [IncomeCurrencyID] INT NOT NULL, [ExchangeRateID] INT NOT NULL, [IncomeAmnt_LKR] MONEY NOT NULL, [AddedOn] DATETIME NOT NULL, [Remark] VARCHAR(250), ) I need to allow users to update only [ExchangeRateID] and [IncomeAmnt_LKR] fields. All other fields can not be updated. only insert.

  Read the article

• update a user status by ajex

  - by Arpan

  how we can update a user status by ajex. user id store in session.. plz send me the code...for php mysql

  Read the article

• Bulk Compare, Report, Update

  - by Tim Donaldon

  I need to import either csv or excel file into a dbase. The column headers will match but I will want to compare the file against the dbase using an ItemID field, list the rows to be affected and the differences, then allow an update to all the rows with the matching ID.

  Read the article

• Update Mysql database with dataset changings? (C#)

  - by Ases

  I'm changing my dataset in my program. And when my job was finished, I'm connecting to mysql database. I don't want to do this job again, how can I send changings to database like this mydatadapter.Update(dataset, " table"); I found this code, but I can't run it :S

  Read the article

• jQuery update Google Map

  - by Beardy

  I am trying to update a google map v3 with jQuery and at the moment it loads the map but when .preview is clicked the map scaled to the width and height and then goes grey. $('.preview').click(function(){ var width = $('#width').val(); var height = $('#height').val(); $('#map').css({ 'width':width, 'height':height }); var mapElement = document.getElementById('map'); var updateOptions = { zoom: 6 } var map = new google.maps.Map(mapElement, updateOptions); });

  Read the article

• NHibernate does not update entity when repository is passed by constructor

  - by Alex

  Hi everybody, I am developing with NHibernate for the first time in conjunction with ASP.NET MVC and StructureMap. The CodeCampServer serves as a great example for me. I really like the different concepts which were implemented there and I can learn a lot from it. In my controllers I use Constructur Dependency Injection to get an instance of the specific repository needed. My problem is: If I change an attribute of the customer the customer's data is not updated in the database, although Commit() is called on the transaction object (by a HttpModule). public class AccountsController : Controller { private readonly ICustomerRepository repository; public AccountsController(ICustomerRepository repository) { this.repository = repository; } public ActionResult Save(Customer customer) { Customer customerToUpdate = repository .GetById(customer.Id); customerToUpdate.GivenName = "test"; //<-- customer does not get updated in database return View(); } } On the other hand this is working: public class AccountsController : Controller { [LoadCurrentCustomer] public ActionResult Save(Customer customer) { customer.GivenName = "test"; //<-- Customer gets updated return View(); } } public class LoadCurrentCustomer : ActionFilterAttribute { public override void OnActionExecuting(ActionExecutingContext filterContext) { const string parameterName = "Customer"; if (filterContext.ActionParameters.ContainsKey(parameterName)) { if (filterContext.HttpContext.User.Identity.IsAuthenticated) { Customer CurrentCustomer = DependencyResolverFactory .GetDefault() .Resolve<IUserSession>() .GetCurrentUser(); filterContext.ActionParameters[parameterName] = CurrentCustomer; } } base.OnActionExecuting(filterContext); } } public class UserSession : IUserSession { private readonly ICustomerRepository repository; public UserSession(ICustomerRepository customerRepository) { repository = customerRepository; } public Customer GetCurrentUser() { var identity = HttpContext.Current.User.Identity; if (!identity.IsAuthenticated) { return null; } Customer customer = repository.GetByEmailAddress(identity.Name); return customer; } } I also tried to call update on the repository like the following code shows. But this leads to an NHibernateException which says "Illegal attempt to associate a collection with two open sessions". Actually there is only one. public ActionResult Save(Customer customer) { Customer customerToUpdate = repository .GetById(customer.Id); customer.GivenName = "test"; repository.Update(customerToUpdate); return View(); } Does somebody have an idea why the customer is not updated in the first example but is updated in the second example? Why does NHibernate say that there are two open sessions?

  Read the article

• Tools to update tables in SQL server 2000/2005

  - by Stan

  Is there any handy tool that can make updating tables easier? Usually I got an Excel file with the original value in one column and new value in another column. Then I write a formula in Excel to create the 'update' statement. Is there any way to simplify the updating task? I believe the approach in SQL server 2000 and 2005 would be different, so could we discuss them both? Thanks.

  Read the article

• Update textarea with jquery

  - by bocca

  Trying to get current data from textarea with jquery and replace it with what server returns. so far q value is picked up right, intead of updating it with server returned content, it just replaces it with ' ' q = $('textarea#id_message').val(); alert(q) $("textarea#id_message").val('&nbsp;').load( '/process/url?html=' + q ); Update just tried it passing server data to test results div, this does work, textarea does not $( '#results' ).html( '&nbsp;' ).load( '/process/url?html=' + q );

  Read the article

• update the row using ajax in cakephp

  - by Praveen kalal

  hi to all i am using cakephp in my project. in this at one section i need to update the particular row onclick of the image. using ajax. i used mootools as javascript library. so please help me how could i do this. thanks in advance

  Read the article

• Tomcat6 fails to update User parameter on a stopped service

  - by Woot4Moo

  At the moment I have installed tomcat via the service.bat command. After install I stop the service and execute the following command: //US//TOMCAT6 --User=MyUser this fails to update the service with the user MyUser, in addition this command also fails //US//TOMCAT6 --User=MyUser --Password=MyPassword I am running xp sp3 and it is Tomcat 6.20

  Read the article

• application resources after update

  - by klaus-vlad

  Hi, I have a curiosity about application updates . What happens after such a process with the resources supposing that the update needs different resources than the ones the old version used ? Are they overwritten ?( like overwrite string.xml) or the old resources are deleted and replaced with the new ones ?

  Read the article

• How to optimize an update SQL that runs on a Oracle table with 700M rows

  - by Bruno Rothgiesser

  UPDATE [TABLE] SET [FIELD]=0 WHERE [FIELD] IS NULL [TABLE] is an Oracle database table with more than 700 million rows. I cancelled the SQL execution after it had been running for 6 hours. Is there any SQL hint that could improve performance? Or any other solution to speed that up?

  Read the article

• How to capture 'Update' click event in ASP.NET GridView with jQuery

  - by Matt

  I need to capture the 'Update' click event with jQuery in an asp.net GridView and have no way of knowing where to start. I'm still rather new to jQuery. My GridView is attached to a SQLDataSource and, naturally, has all the bells and whistles that that combination affords. Any help would be greatly appreciated.

  Read the article

< Previous Page | 156 157 158 159 160 161 162 163 164 165 166 167  | Next Page >