Re: Subtotals outputed to HTML

Well you had been on the right track there as well, the problem would have lied in the SQL then. There are maybe a few ways to do it, but you could certainly have a total or running total with SQL that resets when the indicated field changes. I think one of the things you might walk away with her

Re: Subtotals outputed to HTML

Thanks. That was just the final mental push I needed. I knew it had to do something with that, but I just couldn't get it out. I was really over thinking it by trying to do a rollup on the query. > Sure can, when using cfoutput and I am sure cfloop has it too, you > can > output with the gr

Re: Subtotals outputed to HTML

Sure can, when using cfoutput and I am sure cfloop has it too, you can output with the group attribute, this will allow you to also create the running subtotal and display it at the end of the group. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com

Subtotals outputed to HTML

Would anyone have any insight on how to output subtotals to HTML? Background: Given an SQL query, select eventcode, basecode, issued from mytable group by eventcode, basecode, issued I would like to output it to be: EventCode BaseCode Issued A/123 100 5 A/123 101

Re: Another weird SQL Injection attempt

Looks like the same attack tried my servers too - too bad for them it failed. Long Live CFQueryParam amongst other little tools. Oh, and running PostgreSQL database :-) Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.tr

Re: Another weird SQL Injection attempt

Just battled this today myselfŠ Here's some more information on it. https://isc.sans.edu/diary.html?storyid=12127 On 9/30/12 5:58 PM, "Les Mizzell" wrote: > >Never seen this before! Script in Application file, as usual, caught it >before it got further... > >Here's what was tried: > > >/inde

Another weird SQL Injection attempt

Never seen this before! Script in Application file, as usual, caught it before it got further... Here's what was tried: /index.cfm?action=dance.school%29%29%2F%2A%2A%2For%2F%2A%2A%2F1%3D%40%40version--40version--=&MSOTlPn_View=0&MSOTlPn_ShowSettings=False%27%2F%2A%2A%2For%2F%2A%2A%2F1%3D%40%40

I know this is less difficult than i'm making it

I am using an access database that has an auto number primary key and 10 columns i.e. ID,num1,num2,num3,num4,num5,num6,num7,num8,num9,num10 Each column has numbers ranging from 1 to 100 I want to find out how many times. each number occurs over all the columns i.e. 100 - 72 times 99 - 5 times