Assuming query is required, the following 116 results were found.
-
1.00 2000-02-19 002 1.00 2000-02-20 003 1.00 1999-02-25 003 1.00 1999-02-26 Some thing(s) to consider: User running the SQL query needs permission to read the master database. If run by a service account, ask a DBA to emulate the user for testing. the...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
being already logged in, this is the same user but re-prompted for credentials) Cannot run System Registry (not even DOS REG Query!!!) All oracle utilities and connections working on my computer (except for TNSPING). TNS_ADMIN is another environment...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
have a Joomla module which should take the keywords from a specified number of different but similar tables. I'm looking to query the Title and the Introductions of any valid articles from BOTH tables and return one table with everything I want....
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
date it is on 2012-07-10 and it doesn't have a clue. Anyway, enough faffing! Here's a script I used to generate the SELECT query. If you run it, it should return the additional 52 rows we want add. Note that the table "WeekStructure" could have been any...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
DELETE clause. Rather straightforward but I got this answer from StackOverflow. Based on the previous example, here's the query to only delete records in Session and SessionStudent represented by aliases s and sst respectively and to leave SessionStaff...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
REPLACE(`introtext`, @stringtoFind, @stringtoReplaceWith) WHERE `introtext` LIKE CONCAT('%',@stringtoFind,'%') Run the first query again and no rows should be returned. Quick Joomla One I use this reluctantly but often necessarily. SET @stringtoFind='...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
script pulling IDs and titles from the a sample table: $db =& JFactory::getDBO(); $sql_utf8 = "set names 'utf8'"; $db->setQuery( $sql_utf8 ); $temp_result = $db->query(); $sql = 'SELECT '.$modulescancontentsql.' FROM #__content WHERE state=1';...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
My other fix (for Croatian characters and Western languages): // insert after database connection and prior to database query (where $db_conn is your mysqli connection) mysqli_set_charset($db_conn,"utf8"); // decode and display in HTML-safe...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
Microsoft product Bang "Head" against wall. Bang "Head" against wall. Bang "Head" against wall. Alternatively Change the SQL query so that the date returns in yyyy-mm-dd format (eg. 2012-03-04) Reverse Dates Order If you have a date filter list and want...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
in front of and after the smallest data value (one that I know will never be two lines (or two words)) within the SQL query itself. We have a DEPT column that is an acronym of the departments so for example: SELECT Date, Reservation, Contact, JobTitle,...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
v_Response = getUrl( v_Url ); // usage: v_TimeZone = v_Response.getJSON("timezone"); Returns something like: { "query": "147.188.254.175", "status": "success", "continent": "Europe", "continentCode": "EU", "country": "United Kingdom", "countryCode":...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
I guess I'm a bit geekly like that) This doesn't show modified date and content size differences but I can run this SQL query to show me these.
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
-
it to auto-scroll down to the desired name. Our advanced users are exceptions to the rule. Problem Consider the following query: SELECT rb.[GivenDate] , rb.[DateStart] , rb.[DateFinish] , rb.[ContactUsername] , rb.[ContactName] , rb.[Room] ,...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Strip HTML in MySQLhttps://www.joellipman.com/articles/else/database/mysql/strip-html-in-mysql.html
could no longer be used. How? There were a few functions out there. One called "strip_tags" crashed in the running of the query. The function that did work errored persistently complaining about the delimiter, create the function by running the...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
So this is a quick note to myself as I was playing with the relevance heuristics of a query. This example adds a column of relevance and sorts the rows accordingly. How? This has to be a real quick one for a dropdown search field which has to find...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
The Solution This is what I use to convert a given SQL date to the standard European format: $this_date=mysql_result(mysql_query("SELECT my_date_field FROM my_table WHERE my_id='$this_id'"), 0, "my_date_field"); $this_date_array=explode("-",...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB