Assuming parent is required, the following 29 results were found.
-
0)); SET @new_jos_assets_id_last_lft=( SELECT MAX(`lft`) FROM `my_new_database`.my_prefix_assets); SET @new_jos_banners_parent_id=( SELECT MIN(`id`) FROM `my_new_database`.my_prefix_assets WHERE `name`='com_banners'); SET @new_jos_banners_parent_id = (...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
could try adding a subform to Creator but have it as a blank form rather than a bidirectional form as in this example, the parent record doesn't yet exist... The cheat here is that we actually want the user to be able to click and download/open the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
from Joomla 1.5.x to 2.5.x. I asked to examine the database and a quick scan in the assets table revealed 3 assets had the parent_id = 0. Only one asset can have that and that is "root". Login to your Joomla database using your MySQL database manager...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
different to Attachment ID which has to be unique as you may have many files called "image001.jpg" but for other records. Parent Id: The CRM Record ID you are going to attach the file to (eg. "zcrm_123450000000000123456"). the Attachments.zip This needs...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
`v34_db`.`v34_assets` WHERE `name` LIKE 'com_content.article.%'); SET @nextAssetContentID = @maxAssetContentID; SET @assetParentID = (SELECT `id` FROM `v34_db`.`v34_assets` WHERE `name` LIKE 'com_content.category.%' AND `title` = 'Uncategorised' LIMIT...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
duplicate if exists so need to check if it exists first) // https://workdrive.zoho.com/home/{dunno_id}/teams/{dunno_id}/ws/{parent_id}/folders/files m_SubfolderNames = Map(); r_Subfolders = invokeurl [ url...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Workdrive
- Language: *
-
--- Specify number of days a file is "UPDATED" - Added Admin Section: Manage Categories --- Category Title --- Category Parent --- Create Date / Modified Date / Expired Date --- Order by / Order az --- Display all reviews/comments (or just for this...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
page, you can add the following code: openUrl("#Script:dialog.close","same window"); Known Issues Popup opens in the parent window: This only happens on certain machines and I couldn't narrow down the cause. I have tested on both Mac and PC but I had a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
INSERT INTO mydb_upgrade_j25.myprefix_jcomments ( id, parent, thread_id, path, level, object_id, object_group, object_params, lang, userid, name, username, email, homepage, title, comment, ip, date, isgood, ispoor, published, subscribe, source,...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
file defined('_JEXEC') or die; // com_XXX is your component name class com_XXXInstallerScript { function postflight($type, $parent) { // $type (install, update or discover_install) if ($type == 'install') { $db = JFactory::getDBO(); $query =...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
Configuration Wizard > Backup Now Adding articles in Administrator interface: Save failed with the following error: Invalid parent ID. Asset ID is incorrect... Categories > Clear Filter Options > Show All > Tick to select all > Rebuild [does not work]...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
'' to_ping, '' pinged, modified 'post_modified', modified 'post_modified_gmt', '' post_content_filtered, '0' post_parent, CONCAT('http://demo.joellipman.com/wordpress/', '?p=', id) AS guid, '0' menu_order, 'post' AS 'post_type', '' post_mime_type, 0...
- Type: Article
- Author: Joel Lipman
- Category: Wordpress
- Language: en-GB
-
the report wizard and returned to the designer. Right-click on the "[Order]" cell and select "Add Group" then click on "Parent Group..." as shown. Week grouping expression: you're being asked to Group by, so we click on the "fx" button to enter the...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
-- to return unknown nodes from XML column - Event_XML SELECT Event_XML.query('//* ') FROM [dbo].[XML_EVENTS] Parent/Child Node Names -- to get name of parent node -- returns STAFF SELECT ( SELECT c.value('local-name(.)', 'nvarchar(50)') FROM...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
here we are using SRS as the dictionary and CAP as the entity. (If your change spans different entities, just use the parent/root entity, usually STU) XML is case sensitive so bear this in mind, tick the "Valid for Export" and decide whether blanks are...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
Type:=8) SplitRow = Application.InputBox("Specify Num Rows per Sheet", xTitleId, 5, Type:=1) Set xWs = WorkRng.Parent Set xRow = WorkRng.Rows(1) Application.ScreenUpdating = False For i = 1 To WorkRng.Rows.Count Step SplitRow resizeCount = SplitRow If...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
- Type: Article
- Category: Static Items
- Language: *
-
Const WM_MBUTTONDOWN = $0207 Const WM_MBUTTONUP = $0208 Const WM_MBUTTONDBLCLK = $0209 Const WM_MOUSEWHEEL = $020A Const WM_PARENTNOTIFY = $0210 Const WM_ENTERMENULOOP = $0211 Const WM_EXITMENULOOP = $0212 Const WM_NEXTMENU = $0213 Const WM_SIZING =...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
"Verify Now" link. The sidebar for "Domain Verification" will poup on the right. Note the small code and prefix it to your parent domain (eg. abcd12.joellipman.com) and note the CNAME which will either be creator.cs.zohohost.eu or...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Similar to how to create a call or task, but with some variation: // // initialize m_ScheduleMeeting = Map(); // // specify parent module m_ScheduleMeeting.put("$se_module","Leads"); // // all day meeting m_ScheduleMeeting.put("All_day",false); // //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *