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?
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.
Hello all,
I've been using Twitter4J for a quite a while now, but I can't seem to find this particular feature.
I want to be able to search on a name, and when the certain user is on twitter, I want to retrieve basic information such as tweets, followers (like you can access via http) - but how to do is in Twitter4J? Neither the code examples or the source could help me.
Thanks,
William van Doorn
I need to get a simple description of the OS, such as "Windows XP (SP2)" or "Windows 2000 Professional" to include in some debugging code. Ideally, I'd like to simply retrieve it by calling a "GetOSDisplayName" function.
Is there such a function available for C++ win32 programming?
I am currently following along with http://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4/accessing-your-model's-data-from-a-controller to get a grasp of MVC 4.
I am trying to add the MoviesController, but whenever I do I receive an error that says...
"Unable to retrieve metadata for 'MvcMovie.Models.Movie'
unrecognized configuration section entityFramework
(C:\Users\User\AppData\Local\Temp\tmp4FFB.tmp line 76)"
The last thing I did before this was change the Web.config file from the end of the previous page in the tutorial.
hi
i hve an sqlite db which contain transactions each transaction has an price
and has an transDate
i want to retrieve the sum of the transaction group by month
so the retrieved records should be like the following
Price month
230 2
500 3
400 4
pleas any help
I'm just starting with hudson and I'd like to build my projects like my handmade solution did before:
Retrieve the current svn revision number rev.
Build all projects (each with individual result) with the revision number rev.
Start again with step 1 regardless if there were any changes in the meantime (to detect nondeterministic errors that don't occur on every test run).
How can I configure this with hudson?
Hi, I'm just wondering if it's possible to retrieve the the most entered entries from the mysql database
It's like this :
ID - Value
Id is auto increment, and value is the text that is being entered, i'd like to have it display the top 10 most entered terms, how could i do that?
It's possible to use Microsoft's OracleClient assembly to connect to an Oracle database, and using Oracle's connection string format, set it up to use load balancing, provided your Oracle environment supports it.
The question I have is how do you know after the fact, which db host the command actually executed against? Is there a way to retrieve the machine name from the load balanced set of machines?
I'm using a custom ashx HttpHandler to retrieve gif images from a database and show it on a website - when the image exists, it works great.
However, there are cases when the image will not exist, and I'd like to have the html table holding the image to become invisible so the "image not found" icon is not shown.
But since the HttpHandler is not synchronous, all my attempts checking for image size at Page_Load were frustrated. Any ideas on how this can be accomplished?
Hi all, my question is simple but i cant fin de answer. Is there a way to set in Lucene to retrieve an amount of results higher than 100 in a query?
Im using lucene 2.4.0 now.
Thanks all.
Hello,
I had recently (and unfortunately) uninstalled the google chrome browser from my computer -while completely forgetting about the dozens of bookmarks I had stored on it.
Is there a method/directory to retrieve these chrome bookmarks after having already uninstalled???
Please do help! would be a lifesaver!
I am indexing a row of data from database in Lucene.Net. A row is equivalent of Document.
I want to update my database with the DocId, so that I can use the DocId in the results to be able to retrieve rows quickly.
I currently first retrive the PK from the result docs which I think should be slower than retriving directly from the database using DocId.
How can I find the DocId when adding a document to Lucene?
How do you retrieve the URL for a discussion board item? That is, the URL displayed when you mouse over the subject line (once the list has been added to the page as a web part).
hello
is it possible to get all attributes for a particular node in pyqt ?
for example .. consider for following node:
< asset Name="3dAsset" ID="5"/
i want to retrieve the ("Name" and "ID") strings
is it possible?
thanks in advance
I just read this statement in a java book saying Objects in java reside on a heap.
Is a heap used because it is the best way to store data and retrieve data fast ?
I only have an idea about data structures being a beginner. I mean why not stack or something else ?
Is there any sort of non-SQL API for talking to SQL Server? I'm curious if there is a more direct way to retrieve table or view data.
(I don't have a problem with SQL, just curious if any of the layer between the SQL parser and the underlying data store is exposed.)
Hi,
The current situation encourages the design of the system to split object fields to seperate objects in order to reduce the chance of the JDOCanRetryException to be thrown.
If we could have the fields that were changed by the other client who changed the object in the exception content itself we could deside whether to re-retrieve the object or ignore...
I'm having a problem trying to wrap my head around how to query the database to retrieve the foreign keys in my Nav table and then using those to find the id's in the NavItem table. Can someone point me in the right direction or give me some pointers? i'm not even sure if this should be done in the model or the controller!
Thanks in advance
I have a table which stores data with null valued columns for some entries .I want to retrieve only Not null data to the detail view. I tried the following
foreach(string strTableField in (objDataSet.Tables[0].Columns[i]))
{
if(objDataSet.Tables[0].Columns[i].Equals(null))
{
objDataSet.Tables[0].Columns.Remove(strTableField);
objDataSet.Tables[0].AcceptChanges();
}
i++;
}
but it is giving error .. Pls help me reg this ...
I have the following tables:
TableA (id, tableB_id, tableC_id)
TableB (id, expirationDate)
TableC (id, expirationDate)
I want to retrieve all the results from TableA ordered by tableB.expirationDate and tableC.expirationDate.
thanks
Hi,
Could anyone point me in the right direction to parse an ID from a Vimeo URL in Javascript?
The URL will be entered by a user so I will need to check that they have entered it in the correct format.
I need the ID so that I can use their simple API to retrieve video data.
Any help appreciated.
Hi.
I'm working on Android 2.0 and am trying to receive a list of all contacts.
Since android.provider.Contacts.People is deprecated, I have to use android.provider.ContactsContract, But I can't find a proper example of how to use it (ex: retrieve a list of all contacts on the phonebook).
Anyone knows how to implement it?
Thanks!
I have a class Foo which has_many Bars. Foo has an attribute, some_id. I want to Retrieve all Bar instances where the Foo has some_id = N. In SQL this translates into something like:
select * from bar inner join foo on foo.id = bar.foo_id WHERE foo.some_id = N