Search Results

Search found 25535 results on 1022 pages for 'automatic update'.

Page 92/1022 | < Previous Page | 88 89 90 91 92 93 94 95 96 97 98 99  | Next Page >

• how to create before update trigger in sql server 2005

  - by nectar

  Is there anyway where I can create a trigger which will execute before the update/delete takes place( and then the actual update/delete takes place)? and how can I drop a trigger from a table?

  Read the article

• hibernate bulkupdate: update query syntax

  - by QuanNH

  when i update a table using hibernate getHibernateTemplate().bulkUpdate("UPDATE Channel SET number = 40 AND active = 0"); i get error: ERROR [PARSER]: unexpected token: AND evething run well if i remove AND active = 0 i dont know how to correct this query. help me pls, thanks :)

  Read the article

• Doctrine migrations in symfony don't update model and forms

  - by miguelSantirso

  I've been testing the Doctrine migrations in symfony and I finally got them to work, but I noticed that these migrations only update the database. The forms and the model are not updated as I expected... Is this normal? If it's normal, is there a way to update the model with the changes made to the db?

  Read the article

• how to escape a string before insert or update in Ruby

  - by ywenbo

  Hi guy, In ruby ActiveRecord doesn't provide dynamic binding for update and insert sqls, of course i can use raw sql, but that need maintain connection, so i want to know if there is simpler way to escape update or insert sql before executing like code below: ActiveRecord::Base.connection.insert(sql) i think i can write code by gsub, but i know if there has been a ready method to do it. thank you very much, and Merry Christmas for you all.

  Read the article

• Php/Mysql - need help to insert and update multiple rows with a single query

  - by Guanche

  Hello, is there any way how in this situation insert and update DB with single queries? $message = 'Hello to all group members'; $userdata = mysql_query("SELECT memberid, membernick FROM members WHERE groupid='$cid'") or die('Error'); while(list($memberid, $membernick) = mysql_fetch_row($userdata)) { $result1 = mysql_query("INSERT INTO messages VALUES (NULL,'$membernick', '$memberid', '$message')") or die('Error'); $result2 = mysql_query("UPDATE users SET new_messages=new_messages+1, total_messages=total_messages+1 WHERE id='$memberid'") or die('Error'); }

  Read the article

• Update a column based on a field from another table

  - by Sergio

  Hi: I'd like to update values in one table based on corresponding values from other tables. Say you want to update prices of pieces provided by one specific manufacturer whose name is in the table Manufacturers with the Pieces table containing only the id of the manufacturer. I've seen several solutions for MySQL here and for MS SQL Server here but none of them seems to work in SQLite. Any suggestion?

  Read the article

• Update multiple table column values using single query

  - by Dave Jarvis

  How would you update data in multiple tables using a single query? In MySQL it would be: UPDATE party p LEFT JOIN party_name n ON p.party_id = n.party_id LEFT JOIN party_details d ON p.party_id = d.party_id LEFT JOIN incident_participant ip ON ip.party_id = p.party_id LEFT JOIN incident i ON ip.incident_id = i.incident_id SET p.employee_id = NULL, c.em_address = '[email protected]', c.ad_postal = 'x', n.first_name = 'x', n.last_name = 'x' WHERE i.confidential_dt IS NOT NULL What is the equivalent SQL statement using Oracle 11g? (Is ANSI SQL possible?) Thank you!

  Read the article

• svn update for another, non-current directory

  - by abatishchev

  How to execute svn up for another directory without changing the current? For example, current directory is mono. I want to update ../mcs. I can execute cd ../mcs && svn up && cd ../mono. Maybe I want to update a dozen of directories. How to do that without cd?

  Read the article

• Update just one field from backup

  - by justSteve

  I'm looking to restore one field from a backup and can't find the syntax for an update statement that can look at 2 different catalogs. Seems like it should be something fairly close to: update users set idUserCompany = (select idUserCompany from .myBackup.dbo.users uT) where uT.idUser = idUser

  Read the article

• how to Update the XMl value and write back using LINQ

  - by NewDev

  Hi all, i am having query for update the node value using Linq, For example i am have to update <Student> <studentdetail> <studentname>test</studentname> <libraryid>hem001</libraryid> </studentdetail> </Student> in above xml i want to change the value of Student name "test" ti something else like "Undertest" regards NewDev

  Read the article

• AS3 Core Lib and Adobe Air update frameowork conflicts

  - by Sny

  Hello i am working on an Adobe air html/ajax application in which in need as3Core lib and Air update framework. Update framework work only if I remove as3Corelib from my code. But they both are essential for my project. Btw i am using only JpegEncoder from as3Core lib. Thanks For reading :)

  Read the article

• how not to update timestamp field

  - by GOsha

  project is written on php. There is timestamp field in mysql it updates automatically. In one case I don`t need update this field. Can I gibe instruction not to update this field in this queries without getting timestamp value.

  Read the article

• MySQL update with two subqueries

  - by Julian Cvetkov

  I'm trying to update one column of MySQL table with subquery that returns a date, and another subquery for the WHERE clause. Here is it: UPDATE wtk_recur_subs_temp SET wtk_recur_date = (SELECT final_bb.date FROM final_bb, wtk_recur_subs WHERE final_bb.msisdn = wtk_recur_subs.wtk_recur_msisdn) WHERE wtk_recur_subs_temp.wtk_recur_msisdn IN (select final_bb.msisdn from final_bb) The response from the MySQL engine is "Subquery returns more than 1 row".

  Read the article

• Update facebook status with C#

  - by Tim

  Hi all, My desktop application should update my facebook status. Is there an API that allows to update the status with a login and pwd ? Thanks in advance for your answer

  Read the article

• mysql update unique index

  - by atno

  Is there a way to say UPDATE items SET qty=10 WHERE **unique key** instead of saying UPDATE items SET qty=10 WHERE userID=1 AND listID=10 and itemID=100 on the following table? CREATE TABLE IF NOT EXISTS `items` ( `userID` int(20) NOT NULL, `listID` int(20) NOT NULL, `itemID` int(20) NOT NULL, `qty` int(10) NOT NULL, UNIQUE KEY `unique` (`userID`,`listID`,`itemID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

  Read the article

• Update Params in Python During Infinite Loop

  - by python Dude

  Hello, I was hoping to get some help on a question. I have an infinite loop that I need run and I need to update a set of variables (x in this case) at random times from the command-line. Is there any way to do this? For example: x = 0 while True: x = x + 1 if x < 30: do something and I need to update x's value from the command-line periodically

  Read the article

• update multiple rows in oracle

  - by devang

  hi can you tell me how to update multiple rows in oracle as when i fired the update statment it gave me the following error ORA-01427: single-row subquery returns more than one row Thanks in advance

  Read the article

• NHibernate Empty Set Clauses in SQL Update Statements

  - by Brian Wilkinson

  I'm getting SQL update statements from NHibernate having a empty set clause ie UPDATE SET WHERE x == ? This propblem is occuring when a child entity is being updated for some reason the sql statement is being run against the Parent Entity, for some reason NHibenate is saying the parent has changed but when the set clause is being built no changes are found, can anyone help. The application I am constructing isn 3 tier. The domain entities are light weight data contract only entities.

  Read the article

• how to delete old image when update ImageField?

  - by eos87

  hi using Django to create a stock photo site, i have a ImageField in my model, the problem is that when the user update the image field, the original image file isn't deleted from the hard disk. how can I make to delete those images after an update? Thanks!

  Read the article

• Ajax: Partial refresh of a parent page (update a div) from "lightbox" window

  - by superUntitled

  Is there a way to update information in a div of a parent page from a pop-up/"lightbox" window. I would like to create a pop up window that contains a form that updates a database (currently i am using php/mysql with prototype). In other words... I would like a user to be able to use a form in a popup window to update the database, and the changes that are made to be shown on the parent page without that parent page being refreshed. Thanks.

  Read the article

• I want to do a sql update loop statement, by using the do--while in php

  - by Jean

  Hello, I want to loop the update statement, but it only loops once. Here is the code I am using: do { mysql_select_db($database_ll, $ll); $query_query= "update table set ex='$71[1]' where field='val'"; $query = mysql_query($query_query, $ll) or die(mysql_error()); $row_domain_all = mysql_fetch_assoc($query); } while ($row_query = mysql_fetch_assoc($query)); Thanks Jean

  Read the article

• Using ASP.Net GridView Update Command for specific fields

  - by kenom

  How do I use the Update command in GrideView? I would like to use update command for specific fields in the dataset, but not all fields from database ( or maybe in GridView? )

  Read the article

• Gridview disappears inside an update panel

  - by Sachin

  I have a gridview inside an update panel and a treeview on the left side. When i click on a node, data is populated in grid view. The gridview disappears when page index change event is fired. Im binding the data on page index change. This does not happen when i remove the update panel :( Please help me! Thanks

  Read the article

• Update rich:dataTable binding on Ajax selectionchange

  - by MilkJug

  I want to find the current selection of the data table whenever a selection changes. I can update other items using: <a4j:ajax render=":tmp,:tmp2" event="selectionchange"> But I cannot find the current selection - I think the major issue is that the UIExtendedDataTable backing does not get updated on the Ajax request. Is there a way to update the current selection on a selectionchange (Using RichFaces 4)?

  Read the article

• Svn update done by mistake - how to recover the version before update?

  - by Myx

  I was editing a file on my local machine and I was ready to commit to the repository except that instead of running the svn commit, I ran svn update. Is there any way I can retrieve the changes that I had? I was working on a tex file in vim and I had closed the file before running svn update.

  Read the article

< Previous Page | 88 89 90 91 92 93 94 95 96 97 98 99  | Next Page >