Assuming where is required, the following 228 results were found.
-
the change: // We need to get a list of all weblinks in the given category $query = 'SELECT *' . ' FROM #__weblinks' . ' WHERE catid = '. (int) $this->_id. ' AND published = 1' . ' AND archived = 0'; $query.=($filter_order!="ordering")?' ORDER BY '....
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
Warning: implode() [function.implode]: Invalid arguments passed in /home/.../public_html/includes/router.php on line 325 Where "..." is the path on your server. If you're writing a component, then ask yourself if you really need the router.php file....
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
K2 Items disappearhttps://www.joellipman.com/articles/cms/joomla/k2-items-disappear.html
on line 145 So I checked these pages and the error is at a foreach() line where it's pulling data from the database. I asked to see the jos_k2_items table and it returned the following error: #145 - Table './jos_k2_items' is marked as crashed and should...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
(Stage 1) is the only part you need to modify as this will improve your Joomla search results by giving priority to articles where the search term is in the article title. In the stages thereafter, I'm going to simply enhance the relevance factor:...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
// JSON format for the parameters $query->set($db->quoteName('params') . ' = ' . $db->quote($defaults)); $query->where($db->quoteName('name') . ' = ' . $db->quote('com_XXX')); $db->setQuery($query); $db->query(); } } } Additional: ACL during install My...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
Method #2 If method #1 didn't work for you then if the following code works, it's because Google have changed where they're storing the API (again). This overrides the Core Joomla code for ReCaptcha: 1. Open the file:...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
but these were already created along the way and then deleted. The system is still storing the offending menu items somewhere. How? The fix that I use involves a change to #__menu table in the database for that website. The example used here will be to...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
in DEV Copy database from LIVE to DEV Change database values: Navigate to wp_options table and change the two values where `option_name`='siteurl' change `option_value` // from www.myexample.com to dev1.myexample.com where `option_name`='home' change...
- Type: Article
- Author: Joel Lipman
- Category: Wordpress
- Language: en-GB
-
- Day 3. Can you rewrite this using headings and punctuation so that it makes sense to other trainees reading it? Rephrase where necessary and include details from the official documentation for [Topic] where applicable. // wait for completion and...
- Type: Article
- Author: Joel Lipman
- Category: Apple
- Language: *
-
Drive folder in your browser and note the last string in the URL. So in https://drive.google.com/drive/folders/, the value where "" sits will be your folder ID. $GAPIS = 'https://www.googleapis.com/'; function uploadFile($access_token, $file,...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
key should not be stored in a public folder that is accessible via the web but at least stored (eg. outside your web root) where this script can access it. The same goes for the access token, store it off the web but where this script can access it...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
"Double", "Solid") BorderWidth: 1pt, , , , =IIF(RowNumber(Nothing)=Count(Fields!Field1.Value, "DataSet1"), "3pt", "1pt") -- where "Field1" is a column in my dataset and "DataSet1" is my dataset -- and Count(Fields!Field1.Value, "DataSet1") returns the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
http:///ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render &rs:Format=XML Where XML can be any of the following: HTML3.2, HTML4.0, MHTML, IMAGE, EXCEL, WORD, CSV, PDF, XML, defaults to HTML4.0 So to export to...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
null entry and the end-user will be none the wiser. OLD: Dataset to populate the dropdown SELECT Name, ItemID FROM Catalog WHERE Type = 2 ORDER BY Name ASC NEW: Dataset to populate the dropdown SELECT d1.Name, d1.ItemID FROM ( SELECT Name, ItemID FROM...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
AS [Date] UNION ALL --Add a record for every day in the range SELECT DATEADD(DAY, 1, [Date]) FROM Dates WHERE Date...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
tell us much but it is just for demo purposes. Consider the following query: SELECT DISTINCT StudentDetail FROM StudentTable WHERE SOUNDEX(StudentDetail)=SOUNDEX('Data Not Yet Available') -- yields StudentDetail ----------------- Data Not Yet Available...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
IN varchar2) RETURN number IS student_no number; cursor c1 is select student_reference from student_accounts_table where student_ad_account = trim(lower(ad_username)); BEGIN open c1; fetch c1 into student_no; if c1%notfound then student_no := 0; end if;...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
a funny way of working with dates which made this need to be changed. The following function now requires a second parameter where you specify the data type: CREATE OR REPLACE FUNCTION UFN_DATASCRAMBLE ( p_original_value IN VARCHAR2, p_original_datatype...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9) b ORDER BY n ) n WHERE n.n 5 AND TRIM(`value`) NOT IN ('Article','This',' ','content','component','applies','because','doesn''t') GROUP BY `value`...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
the DIV layer width to be 100 percent of the page. Position the module with absolute on your webpage with background (where left is 0 [zero] because your width is 100%). Position the background image bearing in mind that your layer is 100% of the...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: en-GB