Assuming query is required, the following 116 results were found.
-
What? In view of the fact that this error pops up in so many systems I take over, I have often gone down the wrong path following the red herring as it were when in fact the answer to this is very common. Why? Bespoke systems are the usual suspects....
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
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 Deluge
- 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 CRM
- 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 Analytics
- Language: *
-
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
-
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
-
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: *
-
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: *
-
? "":$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
-
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
-
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
-
{ $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
-
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:...
- 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
-
a value in a column in a widget in Zoho Analytics. Why? Because I keep forgetting how to do it. How? I've done this for a query that amalgamated all the deals against a deal owner and needed to repeat this for all the invoices against a sales person. It...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
of us. We're going to use the interface to find the form where staff have been entering employees goals, then we're going to query it and push it to Zoho Analytics. Find the form link name: Putting this here as it should be what we first did! This is...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
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
-
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: *