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
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!
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
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
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.
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.
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
I need to update some rows of the tables and then display these rows. Is there a way to do this with one single query and avoid this 2 query ? :
UPDATE table SET foo=1 WHERE boo=2
SELECT * from table WHERE ( foo=1 ) AND ( boo=2 )
Hai
Thanks for everything. I have successfully implemented clean url in local. Very nice site.
Now my objective is to create a clean URL web site in php Microsoft-IIS/5.0, I know this in apache. But I don't know how this on Microsoft-IIS/5.0. Does any one give me a solution?
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? )
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
I don't really know how to compose this question. My complay has been using Microsoft ProClarity for few years and we have a quite a few users using it publising books and doing ad-hoc analysis. With the new Microsoft BI solutions, it seems like they are completely going away from ProClarity and replacing the OLAP analysis with Excel. I understand the with SharePoint and integration with PerformancePoint and reporting services the dashboards and reports would be done in SharePoint but what about the analysis? Any ideas?
Dear,
I am looking for well known Microsoft Project alike applications which somehow i get to know through this http://stackoverflow.com/questions/729926/alternatives-to-microsoft-project but I also need to know their API/Library through which I can pro grammatically read their files using .NET
Hope m not asking for much :)
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.
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)?
I was trying to run the following query
UPDATE blog_post SET `thumbnail_present`=0, `thumbnail_size`=0, `thumbnail_data`=''
WHERE `blog_post` NOT IN (
SELECT `blog_post`
FROM blog_post
ORDER BY `blog_post` DESC
LIMIT 10)
But Mysql doesn't allow 'LIMIT' in an 'IN' subquery.
I think I can make a select to count the table rows and then make an ordered update limited by 'COUNT - 10', but I was wondering if there is a better way.
Thanks in advance.
import inspect
class Test:
def test(self, p, d={}):
d.update(p)
return d
print inspect.getargspec(getattr(Test, 'test'))[3]
print Test().test({'1':True})
print inspect.getargspec(getattr(Test, 'test'))[3]
I would expect the argspec for Test.test not to change but because of dict.update it does. Why?
I have a Parent Table A and child tables B,C with many to one relations.
Lets say I have data like, for primary key 1 in parent table A I have 3 rows in child table B and 4 rows in child table C.
Now if I want to delete the rows of the child table during an update of the parent table(that means Now, I want to update the table only with one row in each child tables and delete the other rows in them) then how to handle this scenario in hibernate?
im using this sql query to create an index:
$query = "CREATE INDEX id_index2
ON countries(geoname_id, name)";
but how do i update the index when new entries are added?
should i run a php script with the update query in CRON and run it every night?
is this best practice for automated index updating?
I have used Microsoft.SqlServer.Smo.dll and Microsoft.SqlServer.ConnectionInfo.dll in a number of VS2008 projects but they don't appear in the VS2010 Add Reference dialog. Why did they disappear and how can I add them to my VS2010 project?
I have 2 tables:
Table A: code | name
Table B: barcode | name
Table B has full barcode and name, Table A has only code.
I need to run update query that fill name in Table A.
I tried something like:
update A set name = (select top 1 Name from B where B.Code = mid(A.Barcode,1,8))
but it doesn't work.
I am new to Ruby, so bear with me. I've been trying to update my Ruby to 1.8.7 and just ran into many issues on my Mac OS X (10.5.7).
So really, how do you update to Ruby 1.8.7?
Thanks.
Does grails have an automatic constraint update. If we change the field in domain class to be nullable by adding constraint, it is not getting reflected in database without schema export. Is it possible to do get grails do this update automatically.
i have registered a domain and now i want to host it on my own home server ...
i want to setup a system with php curl so that i login to my domain website and update my name servers i.e
http://mycompany.com/webhosting/domain/manage.php?action=showNS&domain_id=10003489
i want to login to that site and auto update my dynamic ip address...
i am connecting to mysql from excel using odbc. the following illustrates how i am updating the rs
With rs
.AddNew ' create a new record
' add values to each field in the record
.Fields("datapath") = dpath
.Fields("analysistime") = atime
.Fields("reporttime") = rtime
.Fields("lastcalib") = lcalib
.Fields("analystname") = aname
.Fields("reportname") = rname
.Fields("batchstate") = "bstate"
.Fields("instrument") = "NA"
.Update ' stores the new record
End With
the question is why is there a need to run cn.execute after this? havent i already updated the rs with rs.update?