Assuming added is required, the following 114 results were found.
-
for a SQL Server instance only and not filtered by other code. Why? I have a string such as the following (column positions added for demo purposes): String1.String2.String3.String4 1 5 10 15 20 25 30 -> length = 31 I'd like to end up with just the last...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
the default "Search" component in Joomla works. The default is to sort the results by popularity (hits) or by most recently added (depending on your version) which I have never seen in any other system. I've googled and binged but could not find...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
+ rm.[Zone] + ', ' + CONVERT(VARCHAR(4), rm.[Capacity]) + ', ' + rm.[Type] + ', ' + rm.[DeptId])) AS RoomDetails // success! added CONVERT(VARCHAR(4) to the room capacity which was of datatype int.
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
This is a quick article on how to use a counter added to the end of a field column of data. Eh. What? Assume the following two tables exist: TABLE: Employee -------------------------------------------------- ID FirstName Surname 1 Joel Lipman 2 Another...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
structure: Easy, my base rate is £20/hour. I use my own timesheet system, so if you have a 5 minute job, this will only be added to subsequent tasks until these add up to 1 hour. Housing the production and 2 development websites and email system as...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
c.value('local-name(.)', 'nvarchar(50)') FROM Event_XML.nodes('/*/*[contains(local-name(.),"SURNAME")][1]') AS r(c) -- added [1] to only get 1 result returned ) AS Node_Surname FROM [dbo].[XML_EVENTS] Search if Node or value contains string: -- exist()...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
-- if non-alpha, uppercase next alpha character. -- if alpha then lowercase subsequent alphas. -- NON-ALPHA EXCEPTIONS ADDED TO REGEXP (eg. apostrophe) WHILE (@i 0 BEGIN -- get the delimited word SET @CaseLen = CHARINDEX(',', @CaseExceptions, @i+1) - @i...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
each file as a separate connection manager but this is inefficient and not versatile enough to accommodate files that get added later. Why? I am creating an extract SSIS package intended to take a text file as its source and to populate a database table...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
adding allowed Android Keys to the Google APIs console (there's so many) when I should be using the App SHA1 (I have now added both to the console). [Optional] To use the keytool: If you know the command prompt, you know that you have to refer to each...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
exists in another XML with an identifier called @+id/hangar_aircraft_photo. The following is a full example of what can be added to a Main Activity Java file and will display an AlertDialog with the 3 options to "take a photo", "choose from existing",...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
(eg. "doc_indexer"), you would need to modify this to the component you want it to search. More than one area I have added the hidden fields in the HTML form (generated in PHP) in the following file: mod_joesearch.php. Simply add each component name...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
for Android OS on a mobile app, having access to the Google Map API v3 in JavaScript is a doddle... And incredible fun! I've added the options to style the map while trying to keep it simple enough for my clients. Why am I giving it away for free? Could...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
the categories with respect to the assets table. To do this via DB commands, refer to how the weblinks categories are added. Copy over Content: We want to maintain the same IDs for articles in case SEO settings will be enabled and the ID is in the URL....
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
(or claim set as Google seems to refer to it as) has most of the ever-changing data. Note how the impersonator is only added if it is not blank. It must not be included in the claim set if you have not yet had the service account authorized by a G-Suite...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
each row and increment based on how you copy the formula to other cells. You should end up with something like this (I have added some conditional formatting which colors the cells red or green for demonstration purposes): If you understand this...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
> 0, true, false); if(!b_Exists) { // insert into Product table r_ProductCreate = insert into Product [ Product_Name=v_Name Added_User=zoho.loginuser ]; v_ProductID = r_ProductCreate.ID; } else { // DON'T insert into Product table v_ProductID =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
:POST parameters:m_CreateRecord headers:m_Header ]; info r_Response; // yields: { "code": 0, "message": "The item has been added.", "item": { "item_id": "2124100000000081031",.... }} info r_Response.get("item"); // yields: "item_id":...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
upload field that has the field link name "MyImage". There is an additional single-line text field called "Name". I have added an entry with name "Logo" and I have uploaded an image accordingly. // change this to eu (Europe), com (US), com.cn (China),...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
you type in the terminal (will not display, just type away and press the Return key). The response will be something like “added 98 packages from 60 contributors in 3.043s”. Check the CLI installation by typing: zet –v This should return the version of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
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 Expiry_Date_Time=v_ExpiryTime...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF