Assuming values is required, the following 105 results were found.
-
List Box to your form Right-click it and select "Drop-down List Box Properties" Under "List box entries" select Look up values from an external data source Next to "Data source" click on Add Select "Create a new connection to" and then Receive Data...
- Type: Article
- Author: Joel Lipman
- Category: Infopath
- Language: *
-
PivotTable Report...resources in row (along the side)......staff in columns (along the top)......persondays in values (the number my bosses want - 7h 24m or 26640s is 1 person day)... With date range as parameters...ouch......and it was so easy up...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
This is a stored procedure I've nabbed from some consultants from my day job. It shuffles the records and matching data values: Before: ID Name DateOfBirth --------- ------------ ----------- 1 John Smith 1988-06-24 2 Fred Bloggs 1972-11-17 3 Another...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
and double-quotes ("). But who can honestly build a system that thinks of everything from day one? How? Check all required values to escape have been escaped. In all my cases this has been the percent sign (%) but I'm listing what needs to be escaped in...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
1, Line 1 Conversion failed when converting the varchar value 'B110' to data type int. I'm not using any of the non-numeric values to map to... Well the system thinks I might so it fails. I realised then the equals sign ("=") could be changed to a...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
,'1' + substring(CAST(DaysOffSick AS VARCHAR(10)), 2, 1000) AS Items FROM Employees_Attendance_Table JOIN master..spt_values n ON n.type = 'P' AND n.number...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
A quick article on how to create a middleware script which accepts the values from a submitted HTML form and sends it to a server on another domain for processing. This applies to Linux Apache MySQL and PHP (LAMP) setups. Why? A customer wanted to...
- Type: Article
- Author: Joel Lipman
- Category: API Miscellaneous
- Language: *
-
Backup the database in LIVE environment Clear the database in DEV Copy database from LIVE to DEV Change database values: Navigate to wp_options table and change the two values where `option_name`='siteurl' change `option_value` // from www.myexample.com...
- Type: Article
- Author: Joel Lipman
- Category: Wordpress
- Language: en-GB
-
set initial hidden date field input.Selected_Date = zoho.currentdate; input.Starting_Date = zoho.currentdate; // // set the values for the calendar select field clear Calendar_Day_Select; input.Calendar_Day_Select:ui.add("<"); for each index...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
files associated to CRM Contact records. There's first the preparation of an "Attachments.csv" file that needs the correct values in each column and the "Attachments.zip" containing the files to attach that needs some formatting as well: Note that any...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
load of the page when creating an invoice) then I'll just put the client script I used to map over all the applicable field values from the quote to the invoice within ZohoCRM. Set up the Client Script Login to ZohoCRM > Setup (cog icon next to profile...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
This is a quick article on how to convert some cells in Microsoft Excel to number values... Why? OMG. Seriously Microsoft! I have spent an hour trying to convert a column of currency values to a number using Microsoft Excel 2010. Since when did MS Excel...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
you how to do this by title in ascending order without installing any 3rd-party extension as well as by any of the database values used by each link. Joomla 1.5.x I found the page to edit after going through the Joomla forums for a bit. Their solution...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
the most recent mySQL version -- installed. These are NOT the same as apostrophes used in SQL to define -- non-numerical values. -- ----------------------------------------------------------------------------- -- -- 1. replace all database names in the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
anyway otherwise it will look a bit like a staircase of bricks). 4. Design the Matrix: In other words, put where all the values are going to go. [Time] into "Columns", [Room] into "Rows", and [Status] into "Details". 5. Save and close the report wizard...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
compiles without warnings in SQL Developer (or SQL*Plus, etc.) Hardcode your parameters in the SSRS report with actual values that would have been submitted. Create the most basic report you can with the data you're working with just so you can get used...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
int; -- Format given value (prevents CHAR datatype issue) SET @OrigVal = LTRIM(RTRIM(@OrigVal)); -- Set variable default values SET @NewVal = ''; SET @OrigLen = DATALENGTH(@OrigVal); SET @CurrLen = @OrigLen; SET @LoopCt = 1; SET @DateVal = ''; --...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
IS NULL THEN v_returnedval := NULL; ELSIF p_original_datatype='INT' THEN -- Check Parameters and assign proper default values IF p_original_range_1 IS NULL THEN v_rand_param1 := POWER(10, (LENGTH(p_original_value)-1)); -- should yield eg. 100000 ELSE...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
-- Format given value (prevents CHAR datatype issue) SET @OrigVal = LTRIM(RTRIM(@OrigVal)); -- Set variable default values SET @NewVal = ''; SET @OrigLen = LEN(CAST(@OrigVal AS VARCHAR(max))); SET @CurrLen = @OrigLen; SET @LoopCt = 1; SET @DateVal = '';...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
the end of the month didn't wait for me to finish the project, I quickly created this program to extract all the data values from an AwStats report. Advanced Web Statistics or AwStats, is a reporting system for server logs. This gives data as to your...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF