heinepeople

This code always helps me! SELECT CAST( CommonName AS nvarchar) + N' | ' FROM tblPlantCommonName WHERE CPCNum = [@field:CPCNumer] for xml path(N'')

Hello, I often use the following SQL code to create a calculated field which concatenates elements of a list with a character separating them (here is it a vertical bar "|"). For instance, here I am creating a list of all the common names for a given plantID (CPCNumber) in the table tblPlantCommonNames. Is there a way to create this code but remove the character from the end of the list? SELECT CAST( CommonName AS nvarchar) + N' | ' FROM tblPlantCommonName WHERE CPCNum = [@field:CPCNumer] for xml path(N'')

Support gave me the following response, which definitely works when I preview datapage. Unfortunately, it does not work deployed on my Word Press site due to my theme. One step closer!

Hello, I am creating a calendar data page in the "monthly" view. There are often weeks where there are no events, but aesthetically, I think it looks odd if these weeks are collapsed to be much smaller than the weeks that contain events. I changed padding = 20px in the ResultSetCalendarField element to make the empty rows slightly larger (see below). But this element also affects rows with events, so the discrepancy is still large (see screen shot). Is there any element to change that would make the default size of these empty cells larger? .cbResultSetCalendarField { /*Results Pag