Grant

South Africa

Aug
3
accepted How do I Inner join my calendar_table to get full range of calendar dates + my query result from other_table
Aug
3
comment How do I Inner join my calendar_table to get full range of calendar dates + my query result from other_table
Last question: Why did you add act after LEFT JOIN activity? and cal after SELECT cal.dt, aveHR, duration, date FROM calendar? Works fine without these, aliases?
Aug
3
comment How do I Inner join my calendar_table to get full range of calendar dates + my query result from other_table
Works perfectly! Thanks so much!
Aug
3
comment How do I Inner join my calendar_table to get full range of calendar dates + my query result from other_table
OK awesome! Seems to work except my activity.date format is: 2014-08-02 11:08:24 and my calendar dt format is: 2014-08-02 - I tried: substr(activity.date,0,10) but it's giving me NULL values for date
Aug
3
revised How do I Inner join my calendar_table to get full range of calendar dates + my query result from other_table
added 9 characters in body
Aug
3
comment How do I Inner join my calendar_table to get full range of calendar dates + my query result from other_table
OK so: WHERE date BETWEEN first and last date - first and last date columns do not exist they would have to be selected dynamically from the same query
Aug
3
asked How do I Inner join my calendar_table to get full range of calendar dates + my query result from other_table
Jul
28
awarded Popular Question
Jul
2
awarded Curious
Apr
23
asked WordPress plugin adds the number 1 to content if activated
Apr
6
accepted Split radio button values using jquery / Javascript
Apr
6
comment Split radio button values using jquery / Javascript
Sorted, I had some incorrect variable names, all working perfectly now.
Apr
6
comment Split radio button values using jquery / Javascript
How can I "Print" out the values for each array?
Apr
6
comment Split radio button values using jquery / Javascript
Thanks, yes I worked that one out. It seems to be working now, but giving me total values that are not correct.
Apr
6
comment Split radio button values using jquery / Javascript
This gives me Error: $arm is not defined. I am guessing the error has something to do with this line: var a = parseInt($arm.val(arr[0]), 10);
Apr
6
comment Split radio button values using jquery / Javascript
I am guessing the error has something to do with this line: var a = parseInt($arm.val(arr[0]), 10);
Apr
6
comment Split radio button values using jquery / Javascript
This gives me Error: $arm is not defined
Apr
6
comment Split radio button values using jquery / Javascript
Yes, so how do I do that?
Apr
6
asked Split radio button values using jquery / Javascript
Mar
31
revised Disable hidden duplicate field when selecting dropdown option
added 565 characters in body
1 2 3 4 5