Assuming where is required, the following 226 results were found.
-
doing any other job and it beats daytime television any day. I use this quite a lot so I thought I'd put an article here somewhere. Based on the following concept: RowID column_to_return_as_string --------- -------------------------- 1 Me 2 Myself 3 I...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
two use specified values (setup in the subscription section). The report being subscribed to is hidden in tile view. Cases where this would NOT work Reports where the connection string to the data source is held in the parameters (though, with more...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
SELECT ps.person_id, ps.person_name, ( select pa.person_reference as personid, pa.person_text as txt from Person_Academia pa where pa.type = 'USER' AND pa.code = 'SPECIAL1' pa.person_reference = ps.person_reference order by pa.last_modified_date desc )...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: *
-
is a redirect to the actual thumbnail stored by Google Drive: https://drive.google.com/thumbnail?authuser=0&sz=w320&id= // where is the file id The shareable link to the file will be something like: https://drive.google.com/file/d//view?usp=sharing //...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
function invokeURL rather than the usual shortcode of zoho.crm.updateRecord() or zoho.crm.createRecord(). How? This is somewhere in the official documentation but here's the bits that I need: Updating a record with PUT (note that id needs passed for...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
which took me a few years to notice in Joomla. If you've ever installed a template for Joomla and spent hours working out where or how you are going to put what where, try adding ?tp=1 after your index.php url (ie. http://www.yourdomain.com/?tp=1) If...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
cache" so click on the "Run Now" button which I found myself doing at lots of stages in this installation process. So note where it is and come back to it when things aren't responding properly....so in summary: General → Server configuration → Load...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
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: *
-
K2 Items disappearhttp://mail.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: *
-
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
-
"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: *
-
Taking a break from website migrations. Thought I'd share some thoughts I was reminiscing of: "We cast a shadow on something wherever we stand, and it is no good moving from place to place to save things; because the shadow always follows. Choose a...
- Type: Article
- Author: Joel Lipman
- Category: Hobbies
- 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
-
users. This sounds really simple, we could try: $search_term_esc = AddSlashes($search_term); $sql = "SELECT * FROM Content WHERE content_body LIKE '%$search_term_esc%'"; Great! Few problems though, multiple terms are not supported; quotation marks and...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
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
-
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
-
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
-
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
-
(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
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF