Find Library Item Links In Content

Posted on By David Kittell 
SELECT c.[content_id]
	,c.[content_title]
	,c.[folder_id]
	,cft.[folder_name]
	,cft.FolderPath
	,cft.FolderIdPath
FROM [content] c
INNER JOIN [content_folder_tbl] cft ON c.folder_id = cft.folder_id
WHERE content_html LIKE '%uploadedFiles%'
Originally Posted on May 31, 2014
Last Updated on October 26, 2015
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Code Ektron MSSQL MSSQL - Ektron MSSQL - Ektron 8.7 SQL

Related Posts

Java – FRC – Limelight Vision – Basic Information Read

Posted on

The code below will help you to be able read basic information from your Limelight Vision camera. If you haven’t already read the documentation it’s a good idea to start there -> http://docs.limelightvision.io/en/latest/ Start with a new “Timed Robot” template project and add a few imports import edu.wpi.first.networktables.NetworkTable; import edu.wpi.first.networktables.NetworkTableEntry;…

Read More

Calculate Age

Posted on

public static Int32 GetAge(this DateTime dateOfBirth) { var today = DateTime.Today; var a = (today.Year * 100 + today.Month) * 100 + today.Day; var b = (dateOfBirth.Year * 100 + dateOfBirth.Month) * 100 + dateOfBirth.Day; return (a – b) / 10000; } var now = float.Parse(DateTime.Now.ToString("yyyy.MMdd")); var dob = float.Parse(dateOfBirth.ToString("yyyy.MMdd"));…

Read More

Get Source Code Line Count

Posted on

(dir -include *.cs,*.asmx, *.asp, *.aspx, *.asax, *.vb -recurse | select-string .).Count Originally Posted on March 12, 2015Last Updated on October 26, 2015 All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested…

Read More