Is it possible to use a CASE statement for a JOIN ?
Something like this:
Code:
SELECT tasks.taskid,jobs.jobid FROM tasks CASE WHEN tasks.taskid>100 THEN INNER JOIN jobs USING (taskid) ELSE INNER JOIN jobs ON tasks.lastjobid = jobs.jobid END
nsteiner
Last Activity: Jan 26 '11, 03:43 PM
Joined: Dec 29 '08
Location:
-
MySQL case statement
Hi guys
Is it possible to use a CASE statement for a JOIN ?
Something like this:
Thanks in advance -
LIMIT on a condition
Hi all
I am trying to get info from a table in this form :
table_1
jobid(PK) projectid desc
------------------------------------------
1 1 whatever
2 1 .
3 1 .
4 2 .
5 2 .
. . .
... -
Thanks a lot, cloud255.
This is exactly what I need.
Just one more question.
I want the shortcut arguments to be written within the installer, so that I wouldn't have to modify the actual shortcuts manually.
Is that possible?
I can see an 'argument' property for the shortcut in the installer.
Is this it ?
Thanks... -
Hi tlhintoq and cloud255
Thanks for your replys, I will try to answer:
tlhintoq, yes, exactly. I am trying to differentiate between which shortcut was launched. This is for a simple reason:
If the app is launched on startup, I would like it to be minimizes to the system tray, if not, I would like it to be in a 'Normal' state.
cloud255, none.
What I have already are 2 shortcuts created by the MSI installer....Leave a comment:
-
Passing command line arguments to windows app
Hi all
I am trying to differ between launching an application from 'startup' or from the desktop shortcuts.
I thought of adding a command line argument to the shortcuts through the msi installer but i'm not sure how to do it.
The next step would be reading the argument and acting accordingly.
Can someone please help ?
Thanks in advance. -
Iframe and gz file
Hi all
Do you know of a way to show the contents of a gzip text file in an iframe window ?
Thanks in advance -
User direcotries on windows
Hi all
I am running Apache2 on windows XP.
I was wondering, is it at all possible to create ~userdir directories on windows ?
Thanks -
Jconsole with CruiseControl
Hi all
I have a probem.
I am trying to monitor the memory usage of CruiseControl (A java/Ant based continous integration app).
I tried using Jconsole from the JDK, but I get this error:
"Management agent is not enabled on this process".
Can anybody help me on this ?
Thanks -
How to invoke a delegate from a sub class
Hi all
I have a limited understanding of delegates, so bear with me.
In my main Form, I have a listview control.
I also have a class inside the main namespace in which I perform actions on the listview (such as removing a row).
Problem is, the actions the class performs are time consuming, so in order for the Form to avoid freezing, I am executing the class's methods in a separate thread using a 'backGroundWork er'.
Here... -
DoubleClick a listview Item
Hi all
I have a listview with checkboxes and I would like to catch the doubleclick event on an Item.
Everything is o.k, BUT, the double clicking on the item, also checks/unchecks the checkbox of the item, which I don't want.
Can I work around this ?
Thanks In advance. -
Free Text option in Select box
Hi all
Is it possible to have the the first option of a select box editable ?
By doing this, I am giving the user a choice between given options and free text.
This is useful if I want to have a 'history' of previous searches for example.
TIA -
I found it !
What I did is create a global variable named STOP and set it to false.
In the OnClick function of the STOP_BUTTON I set the value to true.
Now, on every iteration of my FOR loop, it first checks the value of the variable.
Code:if (stop==true) break;Leave a comment:
-
I'm not.
My code is something like this:
...Code:Cmd="%comspec% /c cleartool lsview " > C:\\output.txt 2>&1"; Exec=WshShell.Run(Cmd,0, true); ts = fso.OpenTextFile("C:\\output.txt", 1); msg = ts.ReadAll(); array = msg.split("\n"); for (var i=0; i<array.length; i=i+1) { document.write(array[i]); HERE GOES ANOTHER FOR LOOP THAT EXTRACTLeave a comment:
-
It takes between 10 to 20 seconds.
I forgot to mention that the data is coming from Clearcase (a version control system).
It would be very helpfull if I could stop the search if I found what I want in 3 seconds instead of waiting the whole 20.Leave a comment:
-
Breaking a loop after an event
Hi all
What I am trying to achieve is this:
I have a FOR loop that is searching in a large data array.
The results are being published to the screen as they are found.
I would like to have a STOP button to terminate the search, so that the user would have the option to call off the search.
Is this possible ?
Thanks In Advance ... -
Change 'cell color' on dynamically added table cells
Hi all
On my web page I have a 3 column table.
The first cell changes background color when mouseover event occurs.
Something like this :
This works fine.Code:<TR><TD onMouseOver="this.bgColor='#00CC00'" onMouseOut="this.bgColor='#F0FFF0'" >name</TD> <TD>number</TD> <TD>address</TD><TR>
Problem starts when I add more rows dynamically... -
Check if Cygwin or Windows CMD
Hi all
I am trying to verify from my Perl script, whether the environment I am running in is Cygwin or Windows CMD.
Thanks In Advance -
Thanks Atli.
One more thing:
Is it possible to keep different databases on separate locations ?
Is my.cnf per database ? or per server ?
TIALeave a comment:
-
Create a Database on a network drive
Hi all
I am trying to create a database that will not reside in "C:\program file\mysql\db\d ata" but somewhere else on the disk or even on a network drive.
Is it possible ?
if so, how?
P.S - I am using Mysql 5.0
Thanks -
Thanks. I will try ...
BTW - do you know of a better way to execute commands on a client other than the WshShell method ?
Of course, any method would have to be able to save the output somewhere.Leave a comment:
No activity results to display
Leave a comment: