As you can tell these are my messed up functions that convert dates into seconds and vice-versa. They're a little disorganised but they're the ones I copy and paste to my scripts then modify.
In it' ...
... ROLLUP is interesting, think I'm looking in the wrong place.
Using Aggregate Functions?
What follows is the T-SQL Query I finally went with. Lots of numbers but I think this pretty much answered ...
... to be handled by existing Joomla! CMS features. I also needed a component which isolated the download functions external to Joomla! for performance purposes.
What makes this one different to others, ...
... - The following Methods will be used throughout this tutorial. (comparable to built-in functions for AHK)
alert(), getElementById(), getElementsByName(), getElementsByTagName(), focus(), click()
...
... environment, have you?
Commented out lines that you suspect might be the problem?
Able to run the SQL queries directly against the database?
Matched the datatypes received/returned by functions, ...
... to normal people's week numbers is because these are academic week numbers. So I can't use the built-in functions.
The current structure looks similar to this:
ID SetID WeekNumber ...
... MySQL where you can do iteration within the query (SELECT @ncount:=@ncount+1), we're stuck with T-SQL. Ask Google how to iterate in T-SQL and you're confined to functions, temporary tables or little subroutines ...
... 2 functions to split up search terms and accepting double-quotes as phrase makers.
function search_transform_term($term){
$term = preg_replace("/(\s)/e", "''", $term);
$term = preg_replace("/,/", ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.