SimonJM
Contributing User
Devshed Regular (2000 - 2499 posts)
- Join Date
- March 10th, 2006
- Last Activity
- Today 04:56 AM
Recent Visitors
This page has had 620 visits
-
Older Activity
-
A little surprised you did not mention the implicit join syntax! :)June 17th, 2014, 11:44 AM8 replies | 292 view(s) -
What would happen if a parent was also a teacher? I suspect you'd want a way of identifying and/or separating the 'people' into distinct types,...June 15th, 2014, 02:42 PM3 replies | 295 view(s)
-
There is a limit on the length of the total text within the GROUP_CONCAT but I suspect it'll not be a problem for you - but it can be over-ridden by...June 13th, 2014, 04:34 AM3 replies | 574 view(s)
-
You could compare the month and year of the column to the month and year of current date less 1 month?June 12th, 2014, 04:12 PM4 replies | 338 view(s)
-
You are looking for the GROUP_CONCAT function.June 12th, 2014, 04:09 PM3 replies | 574 view(s)
-
Well done in the pursuing of the gremlin!June 12th, 2014, 11:42 AM9 replies | 460 view(s)
-
My first step in looking at this would be to take the query in question (your ss3.jpg screenshot) and modify it to change the SUM (fi.amount) to a...June 12th, 2014, 06:23 AM9 replies | 460 view(s)
Latest Reputation Given
Thread / Date
User / Points
Comment
User / Points
Comment
-
Thread / Date
double SUM
June 12th, 201406:24 AMUser / Points
You gave 0 toComment
Sniped!
-
Thread / Date
What to do with methods if the methods do not make sense to all sub-classes?
May 14th, 201403:47 PMUser / Points
You gave 0 toComment
Isn't it platypi?
-
Thread / Date
How to combine sha-1 and md5
March 7th, 201404:14 AMUser / Points
You gave -10 toComment
Off topic and cross-posted -
Thread / Date
The Milestone Posting Thread
February 18th, 201402:33 PMUser / Points
You gave 12 toComment
No Comment Made -
Thread / Date
Issue with POST. Is it an array or not?
February 14th, 201408:44 AMUser / Points
You gave 0 toComment
Not just me 'scared' by all this? ^_^ -
Thread / Date
Authenticate and delete member photo.
January 7th, 201403:05 AMUser / Points
You gave 200 toComment
How very true. I have had to arrange recovery of *multiple* files for a user. FOllowed 30 minutes later by the same request as he'd done it again, by mistake. Again! -
Thread / Date
Persistent data. Completely persistent data.
December 31st, 201308:06 AMUser / Points
You gave 387 toComment
Nicely put -
Thread / Date
I am lost with how to use function value in another function
December 22nd, 201306:26 PMUser / Points
You gave 23 toComment
Nice to see someone listening to sage advice
-
Thread / Date
I am lost with how to use function value in another function
December 22nd, 201306:25 PMUser / Points
You gave 23 toComment
Rep by proxy -
Thread / Date
The Milestone Posting Thread
December 18th, 201304:27 AMUser / Points
You gave 286 toComment
No Comment Made
Latest Reputation Received 167716 point(s) total
Thread / Date
User / Points
Comment
User / Points
Comment
-
Thread / Date
Multi-select query
June 12th, 201404:32 PMUser / Points
You recieved 0 fromComment
Worked a treat, thank you. -
Thread / Date
Incorrect key file for table 'vendors'; try to repair it
April 18th, 201407:25 AMUser / Points
You recieved 0 fromComment
Very helpful -
Thread / Date
Incorrect key file for table 'vendors'; try to repair it
April 16th, 201406:10 PMUser / Points
You recieved 0 fromComment
No Comment Made -
Thread / Date
-bash: ./g3-from-scratch.csh: Permission denied
March 20th, 201402:29 PMUser / Points
You recieved 0 fromComment
No Comment Made -
Thread / Date
Loops In Python
March 5th, 201406:25 PMUser / Points
You recieved 1 fromComment
The colon is all. -
Thread / Date
Issue with POST. Is it an array or not?
February 13th, 201409:54 AMUser / Points
You recieved 6324 fromComment
Interesting -
Thread / Date
Help Speeding up query
February 11th, 201411:18 AMUser / Points
You recieved 0 fromComment
Simon took the time to help me understand what I was missing and narrow down my issue. -
Thread / Date
String manipulation
February 2nd, 201405:45 PMUser / Points
You recieved 0 fromComment
No Comment Made -
Thread / Date
How to check if I have read/write errors?
January 30th, 201408:07 AMUser / Points
You recieved 5 fromComment
No Comment Made -
Thread / Date
Shell Script(simple problem)!!! [moved from PHP]
January 7th, 201403:41 AMUser / Points
You recieved 0 fromComment
Thanks.
