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 IT EXISTS, ELSE 0]
$ids is reasonably small (under 50 values).
It seems simple but I can't seem to get my head around it because I can't use a SELECT subquery with an UPDATE to the same table.
Anyone?
Thanks
.cproj is not the only name of the project file. My solution says there are 5 projects but only three .cproj files are seen. What is the file extinsion of other project files/? THe icon that represents the other two look different as well:
I want to archive something like this: http://www.jayhollywood.com.au/ but instead of small previous and next images, I would like them to remain the same size but with low opacity.
(Will this work in IE too?)
Hey!
Has anybody used a good obfuscator for PHP?, I've tried some but they dont work for very big projects. They can't handle variables that are included in one file and used in another, for instance.
Or do you have any other tricks for stopping the spread of your great code? :)
Hi,
What's the best way to implement showing a number in a small circle on a UITableView row, much like is seen on the 'Inbox' row in the image below?
Thanks,
I have been learning the mapreduce algorithm and how it can potentially scale to millions of machines, but I don't understand how the sorting of the intermediate keys after the map phase can scale, as there will be:
1,000,000 x 1,000,000
: potential machines communicating small key / value pairs of the intermediate results with each other? Isn't this a bottleneck?
Hi, i was curious if there is some sort of way to change the look and feel of wxpython to something that is more standardized. I am writing a small application for windows and mac os x. And i noticed that Mac formats the layout and look of my application pretty terribly. I looked around online and could not find anything. Any ideas?
I know this is probably a very obvious answer and that I'm exposing myself to less-than-helpful snarky comments, but I don't know the answer so here goes.
If Python compiles to bytecode at runtime, is it just that initial compiling step that takes longer? If that's the case wouldn't that just be a small upfront cost in the code (ie if the code is running over a long period of time, do the differences between C and python diminish?)
I get this error message when I do update:
Server sent unexpected return value (502 Bad Gateway) in response to OPTIONS
It was working 2 hours ago, now it suddenly started not to, I tried updating other projects and I get the same thing.
Hi,
when i go with the mouse pointer on the function it doesn't show the location, class...
i have this problem in one of my projects. All is executed ok so the functions are there :).
Build id: 20090920-1017
Any idea?
Javi
By best I mean most efficient.
So don't go on about subjectiveness.
I have a list of websites and I want to store the list on the iphone locally, there must be an URL, title and a small image (like 32x32 max image size). I don't think I should be using CoreData for this. Should I be using a plist?
Hi,
I made a small product using Google APIs.
Now i need to sell it to my client.
I made installer and simply added all APIs.
But now it is showing error of type COM.
How can i resolve this issue?
Basically I want the books to be text book based, ie, author discusses the background,philosophy,syntax,semtantix for every language AND after every section there are questions what you learned so far and mini projects. Is there any books like this, I'm absolutely new to php/mysql/javascript and web development in general. Thanks in advance.
I'm looking for a remote desktop client that works as a webapp, similar to Citrix or WebEx. Are there any open-source projects that do this? Need to mainly to be able to access Windows machines using a regular browser.
Thanks!
I add an image to the button in the following way:
ImageIcon icon = new ImageIcon("images/col.jpg");
tmp = new JButton(icon);
My image is a red sphere but in my button I see only read color. I assume that I see just a small part of the sphere. How can I see the whole image in the button?
I would like to write a small module that can check if anything is connected to my computer's HDMI input, and if so write a frame of video to bitmap once in a while.
Can anyone point me to resources regarding grabbing audio/video from HDMI on windows?
Hi!
I want to create a small code in C++ with the same functionality as "tail-f": watch for new lines in a text file and show them in the standard output.
The idea is to have a thread that monitors the file
Is there an easy way to do it without opening and closing the file each time?
Just wondered if anything like that exists? Certainly in Eclipse it does.
A small window like the solution window listing all the methods in the active class would be great
Any ideas?
Thank you
We have a small office server running Linux Centos for internal use. I can connect to it externally though using Putty with SSH.
Since the server does not have any kind of SSL certificate, is using putty ssh still secure?
Thanks
Hi, When i give the scrollbar height as 320sp in andoir ,it is okay for my application in android but in droid the same code for that scroll bar but it is too small in that how can i adjust ? Give me some suggestions.Thanks in advance?
So I made a standard swing application in Netbeans 6.8 and I can't find where the resource file is for File/Exit in the projects view. All the other resource files can be found in the <project>/resources.
Am I missing something?
I read that an SEO best practice is to use lowercase urls. Should I name my asp.net webforms project files lowercase as well? Visual Studio doesn't name default documents in new projects all lowercase. I'm not sure it matters since browsing to http://www.mysite.com/mypage.aspx will still work even if your page is named MyPage.aspx.
Can somebody enlighten me on this?
I read that an SEO best practice is to use lowercase urls. Should I name my asp.net webforms project files lowercase as well? Visual Studio doesn't name default documents in new projects all lowercase. I'm not sure it matters since browsing to http://www.mysite.com/mypage.aspx will still work even if your page is named MyPage.aspx.
Can somebody enlighten me on this?
Hi
I am trying to compare the performance of Single and Multithreaded Java programs. Are there any single thread benchmarks which are available which I could then use and convert to their multithreaded version and compare the performance. Could anybody guide me as to what kind of programs(not very small) are suitable for this empirical comparison.
Thanks in advance