To resolve the error - The value 'null' is not valid for operator '>='In your controller (or extension), you do not set a value for avalistasSize until getAvalist() is called.I don't have any documentation to point to for the order in which merge expressions are processed in Visualforce, but I'd expect that it's the…
Salesforce
Answered May 16, 2023
·
2.0K Views
Read answer →
Unfortunately apex doesn't handle list-level type conversion so if "obj" is a List and even if each Object is actually a String you still cannot convert that salesforce list class directly to a List via type casting. You have two options. First is to do a loop: List obj = ...; List objAsStrings = new List(); for…
Salesforce
Answered May 12, 2023
·
1.9K Views
Read answer →
If you go to the Details page, the Delete button will be greyed out if it is in use somewhere. Hovering over the button will tell you where it is used. Or, use the "Del" link from the list view of certificates. If it is used, you'll get a list of places it is used. Regarding deleting - If it's in use, no. You'll have…
Salesforce
Answered May 11, 2023
·
1.0K Views
Read answer →
To resolve the error - This schedulable class has jobs pending or in progress at line 11 column 8 - As per Salesforce help article https://help.salesforce.com/s/articleView?id=000323577&type=1 this can also happen "When editing a class being called by a class that is called in the execute() method, in other words, a…
Salesforce
Answered May 4, 2023
·
2.6K Views
Read answer →
We've had this issue before in our project, here is what we did. ConnectApi Commerce class methods respects the structure of your storefront (I.E Entitlements, Pricebooks, Products) So as a workaround: we had to use ConnectApi.ManagedContentVersionCollection to retrieve medias attached to our community we need to…
Salesforce
Answered May 1, 2023
·
2.9K Views
Read answer →
The 5 million record limit is a salesforce Data Loader limit, not a Salesforce limit, and I'm pretty sure that's more of a "suggested maximum per file" than a hard limit. The maximum records you can theoretically load in 24 hours is 200 times your API Limit (found in Setup > Company Information). This value is scaled…
Salesforce
Answered Apr 28, 2023
·
1.8K Views
Read answer →
Not detracting from anything above, and not being part of the SF community, here follows a PHP class for converting between type 18 and type 15 ids. Note that many people suggest merely cutting the last three characters off the type 18 id, in order to get the type 15. Since type 18 is 'case-safe' and type 15 is…
Salesforce
Answered Apr 27, 2023
·
930 Views
Read answer →
The Test Setup salesforce method runs once and only once for the given test class (at least when running all tests; I'm not sure what happens if you run tests selectively, by method name). When a test class is to be executed, if there's a setup method this is called once, always before any of the test methods are…
Salesforce
Answered Apr 20, 2023
·
1.0K Views
Read answer →
In MySQL 8, it is the option disable_log_bin which has to be provided without any parameter in the my.cnf file in the [mysqld] section: [mysqld] disable_log_bin some-other-option = any-valueFrom the manual entry Binary Logging Options and Variables: To disable mysql binary log, you can specify the --skip-log-bin or…
SQL Server
Answered Mar 15, 2023
·
2.8K Views
Read answer →
The answer to your question - what is varchar in mysql is - In the standard row formats for InnoDB and MyISAM (dynamic/compact) a VARCHAR(50) and a VARCHAR(255) will store the string text in the same way- 1 byte for the length and the actual string with between 1 and 4 bytes per character (depending on the encoding…
SQL Server
Answered Mar 14, 2023
·
1.2K Views
Read answer →
Strictly speaking you're guaranteed for the query to fail with 65536 values. With that said, I think it's fairly safe to consider 32768 as an upper bound in practice, but it's not the least upper bound. The least upper bound depends on what else is going on in the query and other local factors. You can see this with a…
SQL Server
Answered Mar 14, 2023
·
1.9K Views
Read answer →
Your er diagram for hotel management system looks mostly complete, though the BookingID field in Guest seems a little pessimistic. What will you do if a guest wants to stay at the hotel again in the future? As you already have a relation between Guest and Booking via GuestID, you can probably remove BookingID from…
SQL Server
Answered Mar 14, 2023
·
3.6K Views
Read answer →