Assuming query is required, the following 111 results were found.
-
I've decided to put something in here as it took me an age to find out how I could do it. This is when using a MySQL query within a PHP script. The process is used often to do a statistics table or top ten chart of your data (eg. movies, music, etc)....
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
back the articles that aren't listed in the audit table (articles yet to be approved). So this will be based on the SQL query to get just your articles from your MediaWiki CMS: -- to get articles from MediaWiki CMS: Let's call it STATEMENT1 SELECT...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
variable references (eg. T-SQL is @localvariable, Oracle is :localvariable). I need to change it to a conditional query with the OR statement below: Lets take the following query as an example: SELECT table1.studentID , table2.studentUsername FROM...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
methods with regular expressions but the only method reliable enough I have found to work each time is using the CRM Object Query Language or Zoho's COQL. Similar to SQL but subject to similar issues of escaping special characters... 1. Setup a CRM...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
so first we will set up the ZIA action "Ask ChatGPT" using the GUI, then we will capture the question using Deluge code and query the OpenAI ChatGPT API to return a response. Getting to the development-side Login to ZohoCRM as a super-admin Go to Setup...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Then in the top right of the dashboard, I'm going to click on the "Widget" button: On the data column, I'll select any query and any field. It doesn't matter which one here, as long as I can get to the 3rd tab of the widget (it becomes enabled once...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
scenario is that I wanted a PHP/MySQL extension created which needs to launch a query to find all columns across the tables of the local database which had valid content to extract keywords from. The following is a MYSQL query that displays the...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
-- each article, banner, category, contact, newsfeed, weblink. This is -- why each snippet consists of more than one MySQL query. -- I have separated the queries so that they can be run individually -- rather than running this entire script in one go...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
{ $omitted_words_array[]=$term; $out[]=$term; } } $terms=array(); $terms=$out; # start creating the sql query $terms_db = search_db_escape_terms($terms); $terms_db_sql = search_final_clean($terms); $parts = array(); foreach($terms_db as $term_db){...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
called "HouseKeepExec". The Problem We get the above error if we tried to execute the stored procedure within the dataset query. Initially our dataset query was: EXEC MY_STORED_PROCEDURE(:Parameter1, :Parameter2, :Parameter3); The Solution To setup the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
? "":$db_prefix; $db_connect = mysqli_connect($db_host,$db_user,$db_pass); $content_count = 0; // CONNECTED! so run a SQL query as per usual if (!mysqli_connect_errno()) { $query='SELECT COUNT(*) as ArticleCount FROM `'.$db_prefix.'content` WHERE...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
3 2012-07-30... 467 2012/2013 51 2013-07-01 468 2012/2013 52 2013-07-08 I'll use this table to create the calendar. Query #1: Works from command-line but may generate "Empty Query 1065" SELECT calendar.WeekNumber AS AcademicWeek,...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
16th May 2013 2.1.1- Included ReadMe file (lost in v1.6.8) - Enhancement: Parameter: Display Debug Mode (was "display SQL query") - Enhancement: Debug Mode: Advanced Troubleshoot - Enhancement: Integration: Exclude Joomla Articles. - Date Uploaded: Sun,...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
A quick article on how to use the where clause in a joomla database query. Why? In response to a member, I use the old form where I can include the whole SQL statement: $db->query('SELECT * FROM #__myTable WHERE condition1=true or condition2=true')...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
in the Solution Explorer > select "Add New Report" Select the "Shared Data Source" you just created > Next Click on the "Query Builder" button Right-click on any empty space in the first frame > Select "Add Table..." Add and specify the query as you...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Studio (BIDS) or Report Builder 2.0 and when previewing the report, the parameters are not accounted for (ie. the SQL query creating the dataset does not use the parameters in its query). Problems: Given a date, the date format was reverting to US...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
I'm looking for a SQL query that could do this all in one go and return all the results in one table. With PHP & MySQL it's pretty simple: use individual SQL queries to get the count of yesterday, yesterweek, yestermonth, yesteryear and do the layout in...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
The ReportServer Databasehttps://joellipman.com/articles/database/the-reportserver-database.html
and lose the decimal ".00". I need the size of the report but the value has to be returned as part of the aggregate query. I want the SQL to return just numbers and let the MDX query add the thousand separator. My answer for everything: CAST((TimeEnd -...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
List MediaWiki Articleshttps://joellipman.com/articles/cms/mediawiki/list-mediawiki-articles.html
for my day job). Thought I already had this somewhere on my site, so it took a while again but I've posted my finished query here: The base query to list mediawiki articles Page ID, Title, Content, Category SELECT p.page_id AS PageID,...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
-
execute... I decided to do a database level calculation using two datasets: -- Oracle 10g: DataSet1 -- your normal dataset query with an added field (ReportStartTime) SELECT field1, field2, TO_CHAR(systimestamp, 'HH24:MI:SS.FF6') AS ReportStartTime FROM...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF