Hello guys,I want know how to add an input(field) on sql query.---QUERY---- IF THIS input IS NULL THEN SELECT ...Thank you

I am trying to query blog posts on my website using a data source web part.Using a SQL where clause in my data source I am doing the following to grab by category from the query string:('{%ToInt(Qu...

I have a form with 2 dropdown fields. The value of the first needs to be taken into account when populating the data source of the second. I have the dependant field checkboxes correctly set.I've t...

I'm trying to list several child pages based on most recent date, however for some sections I want the top 3 documents and some areas the rest of the articles from the same folder.My current SQL st...

We have a stored value on a web part which is a PIPE separated list of NodeGUIDs, which also indicate the custom sort order of the selected items.How would we use the stored value to retrieve the l...

I'm about to try an upgrade from Kentico 9 to 10. I had to change a column from varchar to nvarchar.To do this I had to update an index so it didn't use the column and then remove a view, then adde...

I have a news page where I need to display DISTINCT News date month and year in the drop down. So I created a Query Repeater with Effect web part and I have this query insideSELECT DISTICT DAT...

I have a large amount of data from a previous site that I'd like to bulk import into my Kentico 11 build. I'd hoped to be able to do this with a SQL script (simple insert statements) but wasn't sur...

I am new to kentico cms.I am working on existing kentico project.In that one unigrid used for displaying record from database and for binding unigrid they were using "query" property of unigrid.But...

I have a Repeater set up on the page which is used to repeat Blog Posts. If the user clicks on the author a transformation is used to set ?author=[id] as a query parameter and lists all the blogs f...