Search Results

Search found 23664 results on 947 pages for 'quirky update'.

Page 98/947 | < Previous Page | 94 95 96 97 98 99 100 101 102 103 104 105 | Next Page >

why do I have to commit explicitly when doing an UPDATE

- by Tshepang

Here's my code: import cx_Oracle conn = cx_Oracle.connect(usr, pwd, url) cursor = conn.cursor() cursor.execute("UPDATE SO SET STATUS='PE' WHERE ID='100'") conn.commit() If I remove the conn.commit(), the table isn't updated. But for select statements, I don't need that conn.commit(). I'm curious why?

Read the article
hibernate's transaction read and subsequent update

- by feiroox

Hi I have situation in which I read a record from a database. And if everything is ok I'll modify few properties and commit transaction. But in situations two threads do the same, they will update the same record. How to make it in hibernate?

Read the article
Force Binding Update Silverlight

- by Matt

How can I force my objects DataContext bindings to update? I'm using an event on a grid, and binding updates are not being processed before my event fires. Any cheap tricks to get around this? In the end I can always do things the old manual way of getting the values from my textboxes and updating my object, but it'd be nice to have binding do it for me.

Read the article
Set creation and update time with Hibernate in Xml mappings

- by Marco

Hi, I'm using Hibernate with Xml mappings. I have an entity that has two fields creationDate and updateDate of type timestamp, that have to be filled with the current UTC time when the entity is persisted and updated. I know about the existence of the @PrePersist and @PreUpdate annotations, but i don't know how to use their equivalent in my Xml mappings. Again, i was wondering if Hibernate somehow supports natively the update and creation time set. Thanks

Read the article
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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(' ').load( '/process/url?html=' + q ); Update just tried it passing server data to test results div, this does work, textarea does not $( '#results' ).html( ' ' ).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

< Previous Page | 94 95 96 97 98 99 100 101 102 103 104 105 | Next Page >