update

Problem updating BLOB with Hibernate?

hi, i am having problem updating a blob with hibernate. (i am using Hibernate 3.3.1-GA) my model have these getters/setters for hibernate, i.e. internally i deal with byte[] so any getter/setter convert the byte[] to blog. I can create an initial object without problem, but if I try to change the content of the blob, the database colum...

Manually updating FF Add-ons

My application installs my Firefox add-on (by copying an my.xpi to [FF_inst_dir]\extensions). This application interact with my FF add-on. This application periodically has updates (.xpi with new version). When my application is updating it does next: Remove folder and content [FF_inst_dir]\extensions\MyExtension Copy new my.xpi to [FF...

in mysql table update 'a' record with 'b' and 'b' with 'a'

IN my table there are two field one is name and other is gender I want to fire query so that every male is update with female and vice a versa. I don't want to use procedure ,trigger or function.I have to do this only with simple query. ...

batch update SharePoint data

Hi, I need to import user profile information to a sharepoint list. Also, the user profile information will be periodically updated to the list , therefore i think i should use a timer job to update the information. Importing for the first time works without any issues. But can you suggest what can be the best way to update informatio...

Detecting modfications in the persistent state

Hi, I know that during a update hibernate cand detect if any change has been done. If it is no, no sql request will be done. IS there a way to get this boolean information computed by hibernate ? Thanks in advance Regards ...

check if update web page

i downloaded a web page ".html" on mu hard disk i would like to check if this page has been updated recently without downloading the page again.. P.S. when i use last-modified it doesn't work on some servers Can anyone help me?? thanks in advance ...

Grails domain class object updating question

Hi, should always the "version" field be checked when updating a domain class object ? If so, is using a while with sleep an acceptable option ? ...

SOAP web service evolution

Are there any guidelines/tutorials as to how to handle the evolution of a SOAP web service? I can see that changing existing methods or types would probably not work, but can I just add new methods, complex types, enumeration values without breaking existing clients? ...

cancel update in datacontext = LInq

Hi, I would like to know if its possible to discard changes of only one record of only one table in datacontext. I use databind to bind my controls on a form. I modify one record at a time. after the modification, the user have to hit save button to validate. But he can hit cancel. I would like that the cancel button discard all the ch...

Getting the CVE ID Property of an update from WSUS API via Powershell

I am writing a script in Powershell to get the update information from each computer and correlate the information with another System which identifies updates by CVE ID. I have discovered that there is a "CVEIDs" property for an update in WSUS, which is documented in MSDN, but I have no idea how to access the property. Retrieving the CV...

Updating specific area of table in postgresql

Ok I am trying to update a specific area of a table in postgresql I want it to find the user that goes along with the table and then update the information I have like in this case the email is the user name that it needs to look for. it needs to add in areas like $aboutSelf, $hobbies, $music, $tv, $sports so ya I have no idea how t...

vb.net | Update DB with OleDB

i wrote a module of a connection to DB with OleDB and the 'sub UpdateClients' doesn't work, the DB don't update. what's missing or wrong? this line -> "daClient.Update(dsClient, "CLUB_CLIENT")" -> dosen't work (sorry about my english, i'm not so good) the database doesn't update after this line (like i expected) what's missing in ...

Excel VBA to Update SQL Table

Hi All, I have a small excel program that is use to upload data to an SQL server. This has been working well for a while. My problem now is that I would like to offer to users a function to update an existing record in SQL. As each row on this table has a unique id columne. There is a column call UID which is the primary key. This ...

Return number of rows affected by SQL UPDATE statement in Java

I'm using a MySQL database and accessing it through Java. PreparedStatement prep1 = this.connection.prepareStatement("UPDATE user_table SET Level = 'Super' WHERE Username = ?"); prep1.setString(1, username); ...

Modifying existing object attributes in Core Data after the fact

In a previous question, I was looking for an alternative to modifying how "no date" was being stored in the date attribute of my NSManagedObject subclass. Previously, I had assigned nil to that attribute when a user didn't assign a date. In order to address sorting issues when using NSFetchedResultsController, I have decided to assign ...

MySQL: How to do a conditional update?

Hi, I'm trying to a create an update statement along the following lines: TABLE car: id | owner_id | type | status An owner can have multiple cars. UPDATE car c SET c.type = 1 WHERE c.owner_id IN ($ids) AND c.status = [1 IF THIS OWNER HAS A CAR WITH 1, ELSE A CAR WITH 0] // ... ??? $ids is reasonably small (under 5...

Web crawler update strategy

I want to crawl useful resource (like background picture .. ) from certain websites. It is not a hard job, especially with the help of some wonderful projects like scrapy. The problem here is I not only just want crawl this site ONE TIME. I also want to keep my crawl long running and crawl the updated resource. So I want to know is ther...

Update multiple rows with known keys without inserting new rows if nonexistent keys are found

Hello, Let's imagine that we have table items... table: items item_id INT PRIMARY AUTO_INCREMENT title VARCHAR(255) views INT Let's imagine that it is filled with something like (1, item-1, 10), (2, item-2, 10), (3, item-3, 15) I want to make multi update view for this items from data taken from this array [item_id] => [views] '1...

Populate an SSRS Report parameter(hidden) by a sproc or user defined function

My SSRS report fetches data from my DATAWAREHOUSE. The ASP.NET application I have is connected to an OLTP database. I invoke the SSRS Report from my ASP.NET application and provide a parameter as CustomerID(this is an application key in datawarehouse) to my report. Since my report is connected to my datawarehouse, I do not query my re...

How to update maven local repository with newer artifacts from a remote repository?

My maven module A has a dependency on another maven module B provided by other people. When I run "mvn install" under A for the first time, maven downloads B-1.0.jar from a remote repository to my local maven repository. My module A builds fine. In the mean time, other people are deploying newer B-1.0.jar to the remote repository. When ...