[Solved] How Can I Output a Remark Column with rowspan Without Duplicates for same group in Coldfusion (Re formated)

Please try the following: <!— pseudo query —> <cfscript> report = queryNew(“productTypeName,paintType,paintColor,paintCode,quantity,litreName”); queryAddRow(report, [[“Honey”,”Texture”,”Brilliant White”,1700,3,”20 litres”]]); queryAddRow(report, [[“Honey”,”Texture”,”Off White”,1701,8,”20 litres”]]); queryAddRow(report, [[“Magic”,”Texture”,”Off White”,1701,21,”20 litres”]]); queryAddRow(report, [[“Magic”,”Texture”,”Brilliant White”,1700,8,”20 litres”]]); queryAddRow(report, [[“Princess”,”Gloss”,”Brilliant White”,9102,9,”4 litres”]]); queryAddRow(report, [[“Princess”,”Texture”,”Rose Pink”,1712,3,”20 litres”]]); queryAddRow(report, [[“Princess”,”Texture”,”Ivory”,1704,1,”20 litres”]]); queryAddRow(report, [[“Princess”,”Texture”,”Off White”,1701,3,”20 litres”]]); queryAddRow(report, [[“Princess”,”Texture”,”Off White”,1701,3,”20 litres”]]); </cfscript> <!— add groupRowspan and groupTotalQuantity columns —> … Read more

[Solved] Removing Code by using rereplace

Scott is right, and Leigh was right before, when you asked a similar question, jSoup is your best option. As to a regex solution. This is possible with regex but there are problems that regex cannot always solve. For instance, if the first or second table contains a nested table, this regex would trip. (Note … Read more

[Solved] Return checked checkboxes when user retrieves the form (Coldfusion) [closed]

I like to use cfparam in these case like above. <cfparam name=”form.delegations” value=”#yourQuery.columnname#” /> And in HTML: <input type=”checkbox” name=”delegations” id=”SR1″ value=”0″ <cfif listFind(form.delegations,0)>checked</cfif> /> Please note, in your database the value will be a list of values from checkboxes delegations. 1 solved Return checked checkboxes when user retrieves the form (Coldfusion) [closed]

[Solved] Remove the string from URL

Here is one way to do it. <cfset normalURL = “http://test.com/myhome/live”> <cfoutput><p>#normalURL#</p></cfoutput> Output from above code: http://test.com/myhome/live <cfset stringAfterLastSlash = ListLast(normalURL,”https://stackoverflow.com/”)> <cfoutput><p>#stringAfterLastSlash#</p></cfoutput> Output from above code: live <cfset stringRemovedFromURL = Replace(normalURL,”/#stringAfterLastSlash#”,””)> <cfoutput><p>#stringRemovedFromURL#</p></cfoutput> Output from above code: http://test.com/myhome You can play with this code and see the results here. solved Remove the string from URL