update

Update span tag value with JQuery

I'm trying to update a span tag that is in a fieldset tag that is in a legend tag. The idea is to update the cost of a Software Item as components are selected. The code below works fine if I only have one software item (e.g. - Visual Studio 2008 Pro $2800), but if I add a second item in another fieldset, then when I try to update the ...

LINQ: How to perform an update like UPDATE <T> SET Update(<T>, <T>) SELECT FROM clause in LINQ?

Hi, I want to update and insert some records based on a csv I read. The insert is not a problem, but how to update a bunch of data in a single statement? I have not clear how to join them. Update Item Set Name = t.Name From Item i, TextFile t Where i.ItemNo = t.ItemNo For the Name = t.Name I created an private Item UpdateItem(I...

Linq Update Problem

Hello, I'm having some problems updating the database using Linq... Public Shared Function Save(ByRef appointment As MyLinq.Appointment, ByRef db As MyEntities) As Boolean If appointment.id = 0 Then db.AddToAppointments(appointment) Else db.AttachTo("Appointments", appointment) 'db....

How to update a database schema without losing your data with Hibernate?

Hi everybody! Imagine you are developing a Java EE app using Hibernate and JBoss. You have a running server that has some important data on it. You release the next version of the app once in a while (1-2 weeks) and they have a bunch of changes in the persistence layer: New entities Removed entities Attribute type changes Attribute na...

How to update an asp.net website (just changed files)

Hi all : I am developing an asp.net website that will need regular updates for source codes and HTML sides. After i have completed the necessary updates, i use the 'publish website tool' and publish the site to my local directory. Then i upload all files to Remote File. Is there any way to fix my site with just changed files. For examp...

Trigger based history

What I am trying to do is find out which fields were updated and record the change to a different table. DECLARE @BillNo int, @column_name varchar(500) SELECT @BillNo = BillNo FROM INSERTED DECLARE HistoryMonitorLoop CURSOR FOR SELECT column_name FROM information_schema.columns WHERE ...

List View UpdateCommand passing nulls

I am trying to get a listview to automatically bind and update data elements. After looking at numerous examples and tutorials, I still can't seem to find what is wrong with my code. The display is working just fine. It is just the update command that fails. Here is my SqlDataSource node: <asp:SqlDataSource ID="MSSQLDataSource" runat="s...

Updating display order of multiple MySQL rows in one or very few queries

I have a table with say 20 rows each with a number for display order (1-20). SELECT * FROM `mytable` ORDER BY `display_order` DESC; From an admin area you can drag the rows around or type a new number manually for each row. Surely it's not good to loop over an UPDATE query for every row, what's an alternative in one or very few queri...

Using subquerys in Update statement

I have the following SQL statement in a trigger that fires on deletion: UPDATE bk2_InfoPages SET SortOrder = SortOrder - (SELECT COUNT(*) FROM Deleted d WHERE d.SortOrder <= SortOrder) My problem is that the very last SortOrder refers to the Deleted table and not to the bk2_InfoPages table. I am not allowed to add an alias to the bk2_...

Update OpenGL libraries on windows

Hi, I'm using a 3rd party DLL which uses OpenGL. Right now that 3rd party does not work correctly as the display does not refresh correctly. I came to suspect that the OpenGL library isn't correctly installed or may be outdated. Is there a way to update the OpenGL library on windows? Is there like an official site which will hold the c...

SharePoint Infrastructure Update Authentication Issues

I've got a SharePoint MOSS 2007 development setup on to which I installed the WSS infrastructure update. Now, whenever I try to access any site collection in my SharePoint farm using IE7 I get a username and password prompt. I enter valid credentials for my Site Collection admin account and I see the box again. This happens three time...

Periodically, partially update aspx page using jquery

Hi, I want to use only jquery to update a method which is reading account information periodically from database every 60 minutes. I do not want to refresh or load the whole aspx page while I’m refreshing only that portion of the page. Is there any way for accomplish this task? Thank you in advance ...

Updating from svn repository returns "Could not read chunk size" error

When updating from subversion repository using tortoise svn client I get error looking like that: Could not read chunk size: An existing connection was forcibly closed by the remote host. It doesn't prevent me from updating, just interrupts update process, so that I have to repeat update several times, before it is complete. What can...

How do I make an UPDATE while joining tables on SQLite ?

I tried : UPDATE closure JOIN item ON ( item_id = id ) SET checked = 0 WHERE ancestor_id = 1 Then : UPDATE closure, item SET checked = 0 WHERE ancestor_id = 1 AND item_id = id Both works with MySql but gives me a syntax error in SQLite. How can I make this UPDATE / JOIN works with SQLite version 3.5.9 ? ...

Can I have an inner SELECT inside of an SQL UPDATE?

I have a database like where: Table foo has columns id and name Table bar has columns id and foo_id I have an incoming HTTP query with a foo.name, I'd like to insert a row into bar with bar.foo_id set appropriately. So, for example: > SELECT * FROM foo; id name ------ ------- 1 "Andrey" (1 row) > SELECT * FROM bar; (0 rows)...

How can I make my C# application check for updates?

I am building a C# windows application. I want it so whenever I click the update button in my form the application will Start looking for whether there is a new version avaliable on my Server. If there is then proceed to update the Software. How is this usually handled? ...

How does a dataset update query work?

I have a dataset that points to a View in my SQL database, and a gridview that uses this dataset to populate itself. I of course want the rows editable, so I added Edit and Delete functionality to the gridview - standard method (not custom buttons) working with the Update Query now... For some reason it didn't auto-generate the update s...

SQL: Use the same string for both INSERT and UPDATE?

The INSERT syntax I've been using is this INSERT INTO TableName VALUES (...) The UPDATE syntax I've been using is UPDATE TableName SET ColumnName=Value WHERE ... So in all my code, I have to generate 2 strings, which would result in something like this insertStr = "(27, 'John Brown', 102)"; updateStr = "ID=27, Name='John Brown', I...

Is it good practice to "force" users to update their browser?

I helped develop a website for a local non-profit. I have asked for feedback from people who have been using the site. I have encountered a problem with IE6, fixing that problem introduces other problems in IE6 to the point of introducing another CSS file just for IE6 fixes. I stumbled across a way that would essentially "force" users...

Unable to update my Bash in Mac by MacPorts

I updated unsuccessfully my Bash to 3.2.48 by MacPorts. It seems that I do not have it active, since I get echo $BASH_VERSION 3.2.17(1)-release How can you make the newest Bash active such that I get it for my login shell? ...