Assuming field is required, the following 152 results were found.
-
sat there with phpMyAdmin or a MySQL Administration Tool (like Navicat or SQLYog), and still there at night editing each field so that it displays correctly... well that's usually me. Found it a bit boring but here's a short bit of code to speed it up...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
checks any password you might want to try using and suggests variations on this. Simply type a word or phrase in the input field and let it do the rest. Background Joe's Password Analyzer is a Joomla 2.5.x component which simply displays a...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
// 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 a date/time field and you get the error: v_MyDateTimeString =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
to "Header" Grant Type: set this to "Authorization Code" Client ID: Copy & paste from the previous step this value into this field. Client Secret: Copy & paste from the previous step this value into this field. Authorize URL: Enter the Zoho...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
Click on "Data Sources" in the left sidebar then click on "Add Data Sources" in the top right: Type FTP in the filter field in the top right and there should be a single FTP option displayed to you: Step 1 of 2: Give the datasource the table name it...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
the Stripe terminal will ask for the amount on the invoice. Well almost. We've gone the extra step in that we added a custom field that can override the full balance, to allow partial payments such as a deposit or instalment. How? I won't go in to how...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
image URL to/from ZohoWriter. Loop through active users in ZohoCRM. Merge the HTML email signature with the fields evaluated. Function: fn_Workdrive_HostImage I add this function to the CRM and use it as a standalone function to upload generic images...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
get the tags of the contact record using an invokeurl because shortcode only gives me name and ID; but I want the color code field as well which I only seem to get with an InvokeURL. I'm then going to create a list map of tags and add these to the deal...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
and respond to eBay with an HTTP 200 OK status, including the hashed result in JSON format within the challengeResponse field. The response's Content-Type header must be set to application/json. The following instructions are on the eBay page but this...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
copy from Xero to Zoho the Client doesn't use the Items module in Xero and instead puts the product name in the description field How? Because my head is a little fried, I'm putting the two functions I used here and I'll document further if I remember....
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
modules and find the "ID" number for your "pubmenu" item and then input that number in the "Quick Module ID Include" field. 6. Copy metamod_pubmenu, edit and rename it to metamod_regmenu. Then, on right side in "Module Parameters" "Show Quick Modules...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
and some don't description - not recommended! date - the one I use for most recent created - this is also a date formatted field modified - and this is a date formatted field hits - number of times that weblink has been visited state - this is the J16...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
Go to Security > Show More > Advanced Settings > Manage API Client Access Enter the Client ID in the field Client Name (eg. 1000389324798977991) Enter the scope URL in the field One or More API Scopes (eg. https://www.googleapis.com/auth/drive) Click...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
Debug Method Fallback to debug methods; create a textbox that will be visible on the executed report (obviously replace the field name with the name of your field containing the location of the image - ours is "PhotoURL"): =" The file " &...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
to do a database level calculation using two datasets: -- Oracle 10g: DataSet1 -- your normal dataset query with an added field (ReportStartTime) SELECT field1, field2, TO_CHAR(systimestamp, 'HH24:MI:SS.FF6') AS ReportStartTime FROM... Then add another...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
2))=1 SET @ColumnTypeIsDate = 1; -- Determine if this is a date/time value IF @ColumnTypeIsDate=1 BEGIN -- DETERMINE IF THIS FIELD CONTAINS A DATE VALUE SET @DateMatch = CASE WHEN CAST(CAST(@OrigVal AS date) AS VARCHAR(10))'1900-01-01' THEN 1 ELSE 0...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
2))=1 SET @ColumnTypeIsDate = 1; -- Determine if this is a date/time value IF @ColumnTypeIsDate=1 BEGIN -- DETERMINE IF THIS FIELD CONTAINS A DATE VALUE SET @DateMatch = CASE WHEN CAST(CAST(@OrigVal AS date) AS VARCHAR(10))'1900-01-01' THEN 1 ELSE 0...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
task. Why? I'm trying to create an ETag for a synchronization process between Zoho Creator and Zoho CRM. Combining all the fields to compare into a single field can't be done via the documented methods (base64, urlencode or AES) as this exceeds 255...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
which displays a date. Being rather pernickety, I would like a question mark to display if there is no date to populate the field. Why? At the moment, the expression in there is something like this: =Format(Fields!MyCompletionTime.Value, "dd/MM/yyyy...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
what I use to convert a given SQL date to the standard European format: $this_date=mysql_result(mysql_query("SELECT my_date_field FROM my_table WHERE my_id='$this_id'"), 0, "my_date_field"); $this_date_array=explode("-", trim(substr($this_date, 0,...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB