Assuming after is required, the following 130 results were found.
-
and redefined. To pass a value to this script you have to use the $_GET, $_POST or $_SESSION methods. Or redeclare it after the above. MYSQLI_USE_RESULT allows these results to be used once, remove it if you need counts or to use the data later on....
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
order for this to work. Unfortunately, clients who sign up to template providers who disallow access to their support forums after the subscription period expires are on the rise. I'm going to annoy them all by posting solutions here: for Joomla 1.6.x -...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
$num_rows = $db->getNumRows(); print_r($num_rows); $result = $db->loadRowList(); -- eg. 3 -- NOTE: Load row list after get num rows or PHP warning: -- Warning: mysql_num_rows(): 80 is not a valid MySQL result resource -- in...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
to 1. If it's name is "root..." and title is "Root Asset" then leave this as having a parent_id of 0. The fix is immediate after the change is committed to the database. NTS: Possible Related Error: "You cannot access the private section of this site"
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
in a new tab. F6 or Ctrl+L or Alt+D Highlights the URL. Ctrl+K or Ctrl+E Places a '?' in the address bar. Type a search term after the question mark to perform a search using your default search engine. Click the address bar, then press Ctrland the left...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
little script I found on Stack Overflow. Wasn't really my solution as after 2 hours, realised that the customer had been looking at the wrong server. But this script showed me where the cron job we intended was located. #!/bin/bash # System-wide crontab...
- Type: Article
- Author: Joel Lipman
- Category: Linux
- Language: *
-
the new phone prompts you to set it up but you could do the below again at anytime (as I discovered). The steps below apply after having gone through the process of setting up the phone and finishing on the "Get Started" (including Touch ID). Ensure...
- Type: Article
- Author: Joel Lipman
- Category: iOS
- Language: *
-
took me two days to solve despite following an innumerable number of sites advising but none of them having my issue of rows after blank ones being out of alignment. TWO DAYS!!! I hope this helps you! If you know of other ways to resolve this, I would...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
provided in the main report (note: main report runs with incident number as NULL, the user can then add an incident number afterwards or when the initial report was run). The confirmation page just checks with the end-user that this is what they really...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
use the same Oracle PL/SQL query they used to determine whether to display an image or not. Bit of a cop-out I know but after two weeks of trying to find a solution, I would definitely recommend seeing if you can't check at the database level first. I...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
JOIN student_details b ON a.student_id = b.person_id WHERE a.student_id = p_STUDENT_REF; -- ending that second begin I had after my variable declaration END; EXCEPTION WHEN OTHERS THEN RAISE_APPLICATION_ERROR (-20001, p_STUDENT_ADNAME || ':$:' ||...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
a specific drive. Note that this section applies to the currently logged-in user. To restrict other users, see the example after this one: Open the Start Menu, then type regedit in the search box and press Enter. In regedit, expand to the following key...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
and because we want our search in the example above to be case-sensitive, I need to add "COLLATE Latin1_General_CS_AS" after the column this affects. More collations can be found by going to MSDN's SQL Server Collation Name page. Limitations Trailing...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
load). How? The below stored procedure can be reduced to just a script as long as you declare and set the parameters after the BEGIN and extract the script from BEGIN to END (excluding the words BEGIN and END - avoids the need to create a stored...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
Properties. Find your parameters in the Query. Check that there are no apostrophes enclosing the parameters. Before: After:
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
------------- 1 John Smith 1990-03-21 2 Fred Bloggs 1988-11-02 3 Another User 1985-07-11 4 Yet Another User 1977-06-25 After: StudentID StudentName DateOfBirth ----------- -------------------- ------------- 1 mStnoh iJh 1926-01-02 2 lgreg BFdos...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
achieve other than it identified the remaining values as having the same SOUNDEX value. Adding the COLLATE option straight after the column that needs to be case-sensitive returned the correct results: SELECT DISTINCT StudentDetail COLLATE...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
------------- 1 John Smith 1990-03-21 2 Fred Bloggs 1988-11-02 3 Another User 1985-07-11 4 Yet Another User 1977-06-25 After: StudentID StudentName DateOfBirth ----------- -------------------- ------------- 1 PDUHjRWJcb 1926-01-02 2 WRmNqQKxvuV...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
basic Oracle stored procedure as my MySQL and T-SQL stored procedures work slightly differently and are easier to pull off. After much umming and aah-ing, I have written this article as a note for me to demo a working stored procedure and how to use...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
student_accounts.studentID = trim(:p_myparameter) ), '???') FROM DUAL; The other issue The "other" issue was the problem after all. The first query was erroring despite the stored procedure compiling successfully. An empty dataset is still an error it...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB