Assuming value is required, the following 197 results were found.
-
forget this one. If you are trying to join two tables and receiving the error "Conversion failed when converting the varchar value 'B110' to data type int" then read on. How? So where does the 'B110' string come from, well from one of our tables which...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
with the name of your database table AND `introtext` with the name of your column): SELECT SUM(`total_count`) as `total`, `value` FROM ( SELECT count(*) AS `total_count`, REPLACE(REPLACE(REPLACE(x.`value`,'?',''),'.',''),'!','') as `value` FROM ( SELECT...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
What? A very quick article to show pushing the date and time to ZohoCRM or ZohoCreator. Why? You may have received an error that goes something like: datatype: datetime How? Here are some formatting examples: Creator to CRM: v_CreatorTime =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
told to update field1. This causes a recursive or endless loop where each field triggers an workflow/automation, even if the value has not changed, to modify another field and vice-versa. This can get more complex when there are a lot of fields in the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
A quick article to display a value in a column in a widget in Zoho Analytics. Why? Because I keep forgetting how to do it. How? I've done this for a query that amalgamated all the deals against a deal owner and needed to repeat this for all the invoices...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
MySQL database manager (eg. phpMyAdmin, MySQL Workbench) Open the #__assets table where #_ is the Database Tables Prefix value found by logging into your Joomla admin panel Browse to Site > Global Configuration > Server > Database Settings : Database...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
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: *
-
Suppose you have a column in your table that you use as a counter (storing the value of the counter - eg. times an article has been displayed). Basically what I used to do is something similar to the following: SELECT counter_field_value FROM table1...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
This is a quick article to demonstrate how to compare two datetime values with the timezone specified. Why? A client's ZohoCRM had a different timezone setting than the user a script would be run as. The time difference was just one hour but this caused...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
is known to work on the CRM record: // assuming I have a creator form called "myForm" // that the ID of the record is the value of the variable "myRecordID" // that a subform exists in the form called "Attachments" // that a field exists in the subform...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
{ for each m_CustomField in l_CustomFields { if(m_CustomField.get("label") == "Amount To Be Taken") { if(m_CustomField.get("value") > 0) { v_AmountToPay = m_CustomField.get("value"); } } } } // // format to Stripe amount v_AmountToPay =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
is not provided out-of-the-box and getting our users to learn about hexadecimal color references and Red Green Blue (RGB) values is somewhat difficult. What would be nice-to-have is if they could be presented with a bunch of colors and they click on one...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
view page on each of the tabs. Then we'll make an OAuth function that can be executed by the client script which returns the value of the Pipeline given a deal record ID. Finally, we'll have client script execute this function, then show/hide tabs based...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
and line item. This took me a while to get the right syntax for writing to the invoice line items as well as setting the value of lookup fields so I thought it was worth an article and may help someone else (or even myself) in the future. At time of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
/* INSERT INTO mydb_upgrade_j25.myprefix_jcomments_settings ( component, lang, name, value ) SELECT component, lang, name, value FROM mydb_livecopy_j15.myprefix_jcomments_settings; */ --...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
arg0, int arg1) { // Some stuff to do when cancel got clicked } }) .show(); Additional: Pre-populating default value and returning input Lots of confusing answers out there on the web but here's an all-in-one where I Open an AlertDialog designed with a...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
"Student Username" first as "Student Reference" must be calculated and not blank/null): So I tried setting the "Available Values" as suggested by Stack Overflow to gets its value based on the first parameter but ended up with an error going on about...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
The Padding Found this in a forum so thought I'd better make a note: Right("00000" & Fields!ERROR_CODE.Value.ToString, 5) -- "Right()" to say extract text from the right -- ".ToString" because it's likely you're doing this to a number and numbers just...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
detailing what the report was displaying, so for example: -- If setting the limit to 100 records =IIf( Sum(Fields!myCount.Value, "DataSet2")>100, "» Displaying the first " & CountRows("DataSet1") & " of " & Sum(Fields!myCount.Value, "DataSet2") & "...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
In the right pane of Explorer, right click on a empty area, click on New > DWORD (32-bit) Value > type NoDrives > Enter. Right click on the DWORD you just created and click on Modify. Type in the drive option hex or decimal number from the list below...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *