Assuming order is required, the following 136 results were found.
-
Looping -- From resultset of $i ,assigning it to variable $j using let clause, -- Getting top two employees by using where & order by clause. SELECT Event_XML.query('for $i in /STAFF/student let $j:= $i where ($j/@ID)
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
INNER JOIN Resources r ON r.ThisResourceID=s.CategoryID INNER JOIN Teams t ON t.TeamID=s.TeamID GROUP BY s.LogID ORDER BY s.TeamID, u.Username, s.DateTimeCreated, Resource Note there is no WHERE clause because we're going to use EXCEL filters as the...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
u.LastName) AS 'Fullname' FROM Users u WHERE u.StatusType NOT IN ('expired','guest','test account') AND u.TeamID='$t_value' ORDER BY CONCAT(u.FirstName, ' ', u.LastName) "; Activity Query $w_value = $number_of_weeks_from_now; // usually 0 for this week,...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
I want to export for offline backup. I have to raise and log a formal change request and follow a workflow process in order to make a change on a live system to a service user account... Especially one used by the scripts to access the database-driven...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
So I'm starting to get the impression that I no longer tender for brand new projects competing with time and cost in order to win the bids. Recently, more and more people have been asking if I can take over a project that has been abandoned by its...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
t.PageTitle, t.PageContent, t.Source, ".$scorepartstring." AS Score FROM (".$live_sub_query.") AS t WHERE ".$parts." ORDER BY Score DESC LIMIT 0, ".$maximum_number_of_results_from_db; $terms_rx = search_rx_escape_terms($terms); $results_rows = array();...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
others could have taken a several minutes if you knew where to look. My aim was to convert UTF-16 received XML to UTF-8 in order to convert XML to JSON and that has been achieved in part. It's 6am and I'm off to bed.
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
Elements Element Explanation all Specifies that the child elements can appear in any order. Each child element can occur 0 or 1 time annotation Specifies the top-level element for schema comments any Enables the author to extend the XML document with...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: en-GB
-
stutalk usr_code=«your_user_code» smg_code=CAPCHG xpt_code=7day tracemess=3 limit=600 tot Run the monitors in order of DOT, EOT and TOT Your target database table should now be populated... » Read the below "Testing" steps if you aren't getting a result...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
IDs - Added Joomla! Admin Option: Sort Words By (shuffle, alphabet, frequency) - Added Joomla! Admin Option: Sort Words Order (ascending, descending) - Prefixed language file references with JWC to avoid conflicts with 3rd-party apps. - Restructured...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
wrong tree. If I padded with one more zero so that "008" is before "010": Great! The columns are displayed in the correct order but who's ever seen a date written as the 008th of April? What if we didn't use parentheses? Then it wouldn't be evaluated as...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
into separate files per sheet. Why? The Excel file in question was about 36000 rows and had a file size of about 11Mb. In order for an import process to work, the import would only accept XLS files no greater than 1Mb. So our script has to split a...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
Software installs at flat price Website development per hourly rate Computer repair per hourly rate "I always had work order forms in duplicate. Right above the signature line was a BIG BOLD WARNING ABOUT LOSS OF DATA and “Check this box to have your...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *
-
in Zoho Books for received documents (Supplier/Vendor Invoices received to trigger the conversion of the relevant Purchase Order into a Bill and then attach the received invoice to the Bill). How? The key part that I was missing was step 2 in the below....
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
1, 2), '/', img_name) AS img_path_with_file from wikimedia_image -- where -- SUBSTRING(img_timestamp, 1, 8)>=20110922 ORDER BY img_timestamp DESC Note that I've commented out the lines which specify images modified since the 22nd of September 2011. I've...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
-
these to suit your needs. The new programs also read off a configuration file which you can modify in any text editor in order to tweak the program to suit your needs. Launcher v2.0 is crude replacement to the quick launch toolbar which arranges your...
- Type: Article
- Author: Joel Lipman
- Category: Products
- Language: *