Assuming insert is required, the following 55 results were found.
-
give radically high relevance to articles where the search term is found in the title. \plugins\search\content\content.php: Insert this between the if ($sContent && $limit > 0){ and before the from part of the query $query->from('#__content AS a'); //...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
To: MS SQL Server 2008 R2 MS Windows 7 Enterprise (Client) MS Excel 2010 What? A really quick note on how to insert a carriage return or new line into the column name/alias (the header). It might seem trivial but these little aesthetic changes done at...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
\_ A “_” character. Additional An alternative in SQL to escape apostrophes is to change these to paired apostrophes, so: INSERT INTO myTable VALUES ('1', 'It\'s amazing!'); -- equally valid INSERT INTO myTable VALUES ('1', 'It''s amazing!'); Bear this...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
"_")); // returns a string return $v_Output; } and the MySQL is a trigger which executes before the record is inserted and increments the value of url_alias: DROP TRIGGER IF EXISTS incrementUrlAlias; DELIMITER | CREATE TRIGGER incrementUrlAlias BEFORE...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
file to an empty folder of its own With Excel open (ensure editing is enabled) hold down ALT and press F11 (Alt+F11) Go to Insert > Module and paste the below code Sub SplitData() Dim WorkRng As Range Dim xRow As Range Dim SplitRow As Integer Dim xWs As...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
text you have copied off the web and into an MS Excel document. How? Open up a new workbook. Get into VBA (Press Alt+F11) Insert a new module (Insert > Module) Copy and Paste the Excel user defined function below Sub ExtractHL() Dim HL As Hyperlink For...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
// returns error Error on Execution Execution Failed Due to invalid expressions insert statement is terminated Line:(102) Value of the field Etag length should be lesser than or equal to MaxLength 255. Line:(132) It's not in the documentation but...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
to convert the node into a map: info m_Response.get("item").toMap().get("item_id"); // yields: 123456789012345678 Problem: Inserting a date time string into a date time field in Deluge So annoying but sometimes you want to insert a date/time value into...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
module which: creates a sales order checks the returning sales order line items cycles through the invoice line items to insert the "sales_order_item_id" field v_InvoiceID = invoice.get("invoice_id"); v_BooksOrgID = organization.get("organization_id");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
]; // add record as zoho.loginuser so that only record owners can access this record in report or form r_HoldInCreator = insert into Download_File [ Added_User=zoho.loginuser Owner_Email=v_ResultEmail File_Name=v_ThisFileName File_Ref=v_ThisFileCrmID...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
and blueprints related to the API will get executed. Enter the trigger value as [] to not execute the workflows. Source(s): Insert Records API
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
myForm[ID == input.ID]; r_Details.Account = input.Account.toLong(); } else { //... code to create new record r_NewRecord = insert into [ = = = ]; } Done: Additional Remember that an integration field on the interface is returned as a string and needs...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
fields hold the time zone they are set in (ZohoCreator > Settings > Date and Time Settings); so as soon as you try to insert a date time and perhaps accompany that value with a timezone, several calculations happen in real-time making it really...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
File Transfer Protocol on a Port number of your choosing: Set for new imports to append, replace, or check if exists then insert/replace: Schedule to repeat: Every X Hours, Every Day, Weekly, Monthly: Schedule with Timezone specified (click on the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
add to the "" tag under "OrderedItems" class the code: style="page-break-inside:avoid; page-break-after:auto" Click on "Insert" and test!
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
v_DateAdded = r_NewDocumentRecord.Added_Time.toString("E, d MMM yyyy HH:mm"); } else { r_Document = insert into Document [ Added_User=zoho.loginuser Document_Name=r_Attachment.get("File_Name") Document_File=r_Download Downloaded="Downloaded"...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
c_CheckDoc.File_field=f_DownloadFile; v_UploadFileID = c_CheckDoc.ID; } else { v_UploadFileID = insert into Document [ Added_User=zoho.loginuser Ticket_field=c_TicketRecord.ID Image=c_ImageRow.Image File_field=f_DownloadFile Subform_Row_ID=c_ImageRow.ID...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
based on the invoice type if (v_InvoiceType == "Final Balance") { v_DepositAmount = -Math.abs(v_DepositAmount); } // insert a product line item called "Deposit" var o_NewLineItem = {}; // the record ID of the product "Deposit" is inserted into...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
{ info m_ThisInvoice.get("InvoiceNumber") + ": FAILED: " + m_ResponseData; info m_UpsertCrmInvoice; } } if(v_Action == "insert") { v_Count_Created = v_Count_Created + 1; } else if(v_Action == "update") { v_Count_Updated = v_Count_Updated + 1; } } } } }...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
{ v_UpsertedCrmID = m_ResponseData.get("details").get("id"); } } } if(v_Action == "insert") { v_Count_Created = v_Count_Created + 1; // // override the auto-naming to take the Quote Subject from Xero if(v_UpsertedCrmID != "") { m_OverrideCrmQuote =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *