Re: Determining gender....when good info is available

2009-03-25 Thread Barney Boisvert
100% kludge, but it works: http://barneyb.com/r/guess_sex.cfm Source is below the HR, and there's a Groovy in a comment. Slightly different semantics, but same general idea. Neither one handles all the edge cases properly. cheers, barneyb On Wed, Mar 25, 2009 at 10:11 PM, Doug Smidt wrote:

Re: CF8 Enterprise worth the cost? Any experience with it in a virtual environment?

2009-03-25 Thread Dan Baughman
Enterprise doesn't offer perf increase, cf8 runs noticeably on 64 bit than cf7. Enterprise only offers cluster management. On 3/25/09, Ben Mueller wrote: > > Apologies if this has been asked and answered countless times, but... > > We're about to upgrade our infrastructure from CF7 to 8, and a

Determining gender....when good info is available

2009-03-25 Thread Doug Smidt
This isn't so much a "gender-specific" question as it is a parsing question. I need to figure out the gender of the person from some bio information. Here's an example: "Tracy Smith is our finest pole-vaulter. He has set many team records, and his personal best is 19' 8". Tracy's other hob

Re: (OT) W32.Virut.W

2009-03-25 Thread Kym Kovan
Michael Dinowitz wrote: > The House of Fusion webserver has the W32.Virut.W virus. Does anyone know a > way to remove this virus remotely on a windows 2000 machine? I can't boot it > into safe mode so that's not an option. > Thanks > We have used TrendMicro's Housecall successfully on some viri

RE: (OT) W32.Virut.W

2009-03-25 Thread cfcom
Michael I think the online virus scanner by Eset can do that. -Original Message- From: Michael Dinowitz [mailto:mdino...@houseoffusion.com] Sent: 2009-03-25 22:55 To: cf-talk Subject: (OT) W32.Virut.W The House of Fusion webserver has the W32.Virut.W virus. Does anyone know a way to r

(OT) W32.Virut.W

2009-03-25 Thread Michael Dinowitz
The House of Fusion webserver has the W32.Virut.W virus. Does anyone know a way to remove this virus remotely on a windows 2000 machine? I can't boot it into safe mode so that's not an option. Thanks -- Michael Dinowitz (http://www.linkedin.com/in/mdinowitz) President: House of Fusion(http:/

Re: CF8 Enterprise worth the cost? Any experience with it in a virtual environment?

2009-03-25 Thread James Holmes
Enterprise will become more important for you if you move to VM servers. CF8 standard is licensed per VM server (or per 2 CPUs, whichever is greater). This adds up very quickly. By comparison, Enterprise is licensed only by the count of CPUs and the physical server count. For example let's say y

Re: How do you get motivated at work?

2009-03-25 Thread Gerald Guido
>> If you're bored with an aspect of coding, try to automate it or abstract it away so you don't have to write the same things over and over again. +1 for that. If you are writing the same things over and over it is definitely time to automate or abstract the process for creating these items. If

Fwd: public call for speakers...cf.O

2009-03-25 Thread Mark Mandel
Hi all, You might have already heard that cf.Objective() is coming to the Pacific region and that we're going to hold cf.Objective(ANZ) in Melbourne, AU later this year (12 & 13 November 2009). At this stage we're opening the public call for speakers. If you're interested in coming over to Melbo

Re: CF & Facebook

2009-03-25 Thread Monte Chan
Hi Michael, Sorry, I don't check house of fusion often. Based upon what you described, I would say that you can have your users create a profile on your web site. In this profile, you will have a field that would allow users to give you/your company permission to post video on their profiles

Re: CF & Facebook

2009-03-25 Thread Monte Chan
Hi Michael, Sorry, I don't check house of fusion often. Based upon what you described, I would say that you can have your users create a profile on your web site. In this profile, you will have a field that would allow users to give you/your company permission to post video on their profiles

RE: CF8 Enterprise worth the cost? Any experience with it in a virtual environment?

2009-03-25 Thread Mark Kruger
Ben, There are no JET drivers... You can still access excel in other ways :) -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Ben Mueller [mailto:bmuel...@gmail.com] Sent: Wednesday, March 25, 2

RE: TimeFormat

2009-03-25 Thread Steve LaBadie
Perfect Scott, Thanks Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 http://www.esu.edu slaba...@po-box.esu.edu -Original Message- From: Scott Stroz [mailto:boyz...@gmail.com] Sent: Wednesday, March 25, 2009 3:54 PM To: cf

Re: TimeFormat

2009-03-25 Thread Scott Stroz
Try - On Wed, Mar 25, 2009 at 3:34 PM, Steve LaBadie wrote: > > I have an XML file that is generating a time span of 7:00 AM - 7:00 PM. > Is there a way to print this to the screen? For my current code to work > I have to physically remove the trailing time stamp. > > > > > > > > #time# > >

Re: delete directory when user navigates away from site

2009-03-25 Thread Tony Bentley
Cool I will give it a try. Thanks for the pointer to docs. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: h

TimeFormat

2009-03-25 Thread Steve LaBadie
I have an XML file that is generating a time span of 7:00 AM - 7:00 PM. Is there a way to print this to the screen? For my current code to work I have to physically remove the trailing time stamp. #time# Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East St

RE: delete directory when user navigates away from site

2009-03-25 Thread Justin Scott
> Subject: delete directory when user navigates away from site > Any thoughts on how to do this? I am not that familiar with > advanced session capabilities. See the osSessionEnd() method of Application.cfc. Adobe docs here: http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=App

RE: Multiple Record Queries and CFCs

2009-03-25 Thread Josh Nathanson
Well you've run into the big problem with using ColdFusion and objects. The object instantiation speed in ColdFusion is unacceptably slow, when you get up into a large number of objects. The best solution to this problem that I've found is the IBO (iterating business object). Essentially, rathe

Re: Multiple Record Queries and CFCs

2009-03-25 Thread Donnie Carvajal
Brad, Thanks for the quick reply! This is kind of difficult to search for on Google and I have found nothing. Up until now, I have been creating an object outside of the loop and then setting the data to the object inside the loop. At the end of each iteration, I call a Reset() function. M

RE: delete directory when user navigates away from site

2009-03-25 Thread Paul Giesenhagen
Are you using Application.cfc? You can use on SessionEnd to do your dirty work. Paul Giesenhagen QuillDesign http://www.quilldesign.com -Original Message- From: Tony Bentley [mailto:t...@tonybentley.com] Sent: Wednesday, March 25, 2009 3:01 PM To: cf-talk Subject: delete directory whe

Re: Delivery Report

2009-03-25 Thread Dan Baughman
The number in the item checkbox would the primary key of the item in the items table, if you always have this of items then that is the simplest solution, your both over complicating, not the arbitrary order they appear on the page. You would join to the items table based on the order number, but

Re: Multiple Record Queries and CFCs

2009-03-25 Thread Dominic Watson
I like to use an 'iterating business object', or IBO. At its most basic, the component has the cfquery object as a property, as well as a pointer to the current row. It has methods for looping the query, ie. next(), previous(), first(), last(), etc. These I put in a base IBO component. It also has

RE: Multiple Record Queries and CFCs

2009-03-25 Thread brad
Welcome to the Object Instantiation Penalty. :) ColdFusion is much slower at object creation than Java or C++ when you are dealing with thousands of object. http://www.codersrevolution.com/index.cfm/2008/9/22/ColdFusions-Object-Instantiation-Penalty-How-Bad-Is-It This got better in CF8 and is su

RE: CF8 Enterprise worth the cost? Any experience with it in a virtual environment?

2009-03-25 Thread brad
For me, one of the big advantages to having enterprise is the lack of throttling on tags like cfdocument, cfthread, cfexchange, cfreport, and event gateways. If your app doesn't have any heavy use of the throttled features it might not be a big deal but if PDF generation for example is a huge fea

delete directory when user navigates away from site

2009-03-25 Thread Tony Bentley
Any thoughts on how to do this? I am not that familiar with advanced session capabilities. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;

Multiple Record Queries and CFCs

2009-03-25 Thread Donnie Carvajal
I have been trying to write my applications using the 3 tiered method of development, presentation layer, business logic layer and data access layer. I am having trouble coming up with an efficient method of displaying information returned in a query that has multiple records. Correct me if I

Re: html in database

2009-03-25 Thread Ian Skinner
Phillip Vector wrote: > Can't you Evaluate it instead? Works for me. Evaluate will handle embedded variables, but will not handle embedded CFML. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to da

Re: CF8 Enterprise worth the cost? Any experience with it in a virtual environment?

2009-03-25 Thread Ian Skinner
Ben Mueller wrote: > Apologies if this has been asked and answered countless times, but... > For *us* its worth the cost for the Oracle driver and the ability to create multiple ColdFusion instances, the 64 bit came in third. But if one is not using Oracle, then this order would not make sen

Re: html in database

2009-03-25 Thread Casey Dougall
On Wed, Mar 25, 2009 at 2:23 PM, Phillip Vector wrote: > > Can't you Evaluate it instead? Works for me. > Stored in (WelcomeLetter.HTML) ~ Dear #Customer.FirstName# Welcome to #APPLICATION.WebsiteName# ~ #evaluate(de(WelcomeLetter.HTML))# Not sure if it would work with a cfinclude, I'm think

Re: CF8 Enterprise worth the cost? Any experience with it in a virtual environment?

2009-03-25 Thread Alan Rother
>>>So it's really the case that there's no way to access an Excel doc via the 64-bit edition? To clarify, you can't acccess Excel using the Jet driver, as a datasource. If you need to read/write/create an excel doc, you still can you'll just need to use some other tool. Like POI ( http://www.benn

Re: html in database

2009-03-25 Thread Phillip Vector
Can't you Evaluate it instead? Works for me. On 3/25/09, Gert Franz wrote: > > Chad, > > yes that's normally the way to do it. > > You have to do something like this: > > output="#yourDatabaseCFMLContent#"> > > > In Railo you can create a RAM mapping that points to the server's ram. Let's > ca

Re: CF8 Enterprise worth the cost? Any experience with it in a virtual environment?

2009-03-25 Thread Ben Mueller
Thanks for the reply. So it's really the case that there's no way to access an Excel doc via the 64-bit edition? That could be a bit of a stumbling block. >The ability to run 64 bit is sometimes worth the cost... More to do with >hardware than CF :) For one thing you can run a huge heap on 64

RE: CF8 Enterprise worth the cost? Any experience with it in a virtual environment?

2009-03-25 Thread Mark Kruger
The ability to run 64 bit is sometimes worth the cost... More to do with hardware than CF :) For one thing you can run a huge heap on 64x - there is no more 1.5 gig limitation on the JVM heap size. That's very important for some applications that have reached their limit. You can also use cfthrea

Re: scopes

2009-03-25 Thread Brian Dumbledore
It never hurts to ask. Thank you all for your time. seems simple but I am not sure if it sets the default form structure to refer to url structure or it creates a variables.form wihch refers to url. ~| Adobe® ColdFusion® 8 so

CF8 Enterprise worth the cost? Any experience with it in a virtual environment?

2009-03-25 Thread Ben Mueller
Apologies if this has been asked and answered countless times, but... We're about to upgrade our infrastructure from CF7 to 8, and are trying to determine if the Enterprise edition is worth the cost. We've heard (mostly from our hosting company) that CF8 Enterprise running on a 64-bit server o

AW: html in database

2009-03-25 Thread Gert Franz
Chad, yes that's normally the way to do it. You have to do something like this: In Railo you can create a RAM mapping that points to the server's ram. Let's call it /ram Then you do the exact same like above: The problem is that with writing something to the disk you always hurt performa

RE: SQL server - Order totals by month, even without month data

2009-03-25 Thread brad
I too would recommend creating a temp table with a record for every date you want represented in your graph. Instead of unioning it though, I usually left outer join from it to my data with an isnull on any number columns so they show up 0 for months where there was no data. ~Brad Orig

Re: Delivery Report

2009-03-25 Thread Azadi Saryev
use with GROUP attribute. details are in the cfml reference - check it out as it is very particular syntax requiring nested tags: #columns_you_do_NOT_want_repeated# #columns_you_need_repeated_for_each_column-name# #maybe_other_columns_you_do_NOT_want_repeated_below_repeated_output# you can

Re: scopes

2009-03-25 Thread Seb Duggan
If I ever need to do this, I just use: You don't need to duplicate the Struct, as you're not going to have any problems with the original URL data changing throughout the lifetime of the page. Seb On 25 Mar 2009, at 16:17, Adrian Lynch wrote: > > I'm not sure if you're saying it works o

Re: Delivery Report

2009-03-25 Thread Jason Congerton
Hi Thank you for your replies, you are correct Azadi, I can not just have check boxes with the same name. I have resolved my issue in the following way, I removed the group attribute from my initial form output which returned one row for each order item I added an orderitem_id#currentrow# hi

Re: SQL server - Order totals by month, even without month data

2009-03-25 Thread Greg Morphis
Create a dummy table with the information for the current year and preform a UNION to your existing data On Wed, Mar 25, 2009 at 6:26 AM, Will Tomlinson wrote: > > I have your typical tblorders. I'm trying to query it to get order totals by > month, and I'm outputting them in > > All goes fine

RE: scopes

2009-03-25 Thread Adrian Lynch
I'm not sure if you're saying it works or doesn't work. If it doesn't, try FORM.putAll(URL) or StructAppend(FORM, URL) to get the URL vars into the FORM scope. Adrian > -Original Message- > From: Brian Dumbledore [mailto:psteja2...@yahoo.com] > Sent: 25 March 2009 16:31 > To: cf-talk > S

Re: CFHeader - appending date to xls file name

2009-03-25 Thread Dave Watts
> value="filename=ResolveIT_List#Now()#.xls"> > > >   >  #FirstName# >  #LastName# >  #Email# >  #Address1# >  #City# >  #State# >  #Zip# >   > > > value="filename=MyFiles#DateFormat(TheDate, > 'mm-dd-yy')#.xls"> First, you can't embed one CFML tag within another. If an attribute value of a

RE: html in database

2009-03-25 Thread Chad Gray
So save it as a file with cffile then cfinclude it? > -Original Message- > From: Tom Chiverton [mailto:tom.chiver...@halliwells.com] > Sent: Wednesday, March 25, 2009 11:33 AM > To: cf-talk > Subject: Re: html in database > > > On Wednesday 25 Mar 2009, Chad Gray wrote: > > How do I i

Re: CF Flash Form issue

2009-03-25 Thread Dave Watts
> Hey Dave after I posted that I mapped a virtual directory in IIS which worked > for a single > page website I had for testing. > > Once I placed the flash form in a framework (each page is included in the > index.cfm) I get > the blank look. > > No errors or js errors of any kind just blank.

Re: scopes

2009-03-25 Thread Azadi Saryev
oh yes, structAppend, of course! forgot about that one... Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Aaron Rouse wrote: > Just use the StructAppend() function, a lot less code. > > > May or may not want that over write flag set to false, just depends on the > situation/goals. > > >

Solved:---- CFHeader - appending date to xls file name

2009-03-25 Thread cfcom
Thanks all solved! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-

Re: scopes

2009-03-25 Thread Brian Dumbledore
Got you. So I guess in the above scenario, when I do a form dot, it resolves to variables dot form dot but if there is no dot (if I am accessing the whole structure), it doesn't try it in the variables scope. I did a #structkeylist(form)# and it came back as blank. Thanks for your time

Re: (ot) about Vista - sql server 2005 express etc.

2009-03-25 Thread Don L
Thank you all for your bits on Vista. FYI, to those who have to deal with sql server 2005 express, a few days ago, XP SP3 had a serious problem with installing this sql server package due to the MSXML6.0 SP2 bugs. Don >Windows_NT > >I'm running Vista Home Premium > >Jake Churchill >CF Webto

Re: scopes

2009-03-25 Thread Aaron Rouse
Just use the StructAppend() function, a lot less code. May or may not want that over write flag set to false, just depends on the situation/goals. On Wed, Mar 25, 2009 at 11:01 AM, Azadi Saryev wrote: > > all your "form dot names" are evaluated by cf as variables.form.somename > 'form' is a r

CFHeader - appending date to xls file name

2009-03-25 Thread cfcom
I want to add the DATE to my file name in cfheader but it did not work. Any suggestions SELECT * FROM blasts ORDER BY memberid #FirstName# #LastName# #Email# #Address1# #City# #State# #Zip# ~| Ado

Re: scopes

2009-03-25 Thread Azadi Saryev
all your "form dot names" are evaluated by cf as variables.form.somename 'form' is a reserved scope name in cf. it is noted in cf reference manual that one should NOT use built-in cf scope names as variable names. when you do, you can never be sure what you get in the end... like in your case, cf

Re: CFLOOP with Stored Procedure

2009-03-25 Thread Brian Kotek
No, it's not right. As the documentation on the tag states, if you don't specify a "result" attribute, the result is contained in "cfstoredproc". On Wed, Mar 25, 2009 at 10:42 AM, Priya Koya wrote: > > I have a query and looping the results of a query. I want to display the > names from the cfd

scopes

2009-03-25 Thread Brian Dumbledore
ok I was trying something and did this: And then I go about the rest as if the request came from a form post (I use form dot notation everywhere afterwards). When I did a it doesn't recognize the form scope, but this works But every where else in the code it works fine (recorgnizes all

Re: SQL server - Order totals by month, even without month data

2009-03-25 Thread Azadi Saryev
when i had to do a similar thing, this is how i did it: your query returns monthName and totalOrders columns. create a structure from your query with Month as key and Total as value: create a list of month names in the format returned by your query: create a new query you will use for you

Re: Delivery Report

2009-03-25 Thread Azadi Saryev
hmm... the way i read the op, i thought items belongs to different orders... if so, then naming all checkboxes "items" will make it impossible to distinguish which order a particular items belongs to: is this item 1 in order 1 or in order 1876768788? Azadi Saryev Sabai-dee.com http://www.sabai-de

Re: html in database

2009-03-25 Thread Tom Chiverton
On Wednesday 25 Mar 2009, Chad Gray wrote: > How do I insert a or any CF programming into the HTML when it > is pulled out of the database for display on the page? In Adobe ColdFusion, you have to write it to the desk then cfinclude it. Railo and OpenBD have a render() method, iirc. -- Tom Chi

Re: SQL server - Order totals by month, even without month data

2009-03-25 Thread Azadi Saryev
posted a reply hours ago, but it still hasn't showed up... reposting... when i had to do a similar thing, this is how i did it: your query returns monthName and totalOrders columns. create a structure from your query with Month as key and Total as value: create a list of month names in the

Re: Delivery Report

2009-03-25 Thread Dan Baughman
have all the check boxes be named the same thing. if all three boxes are check you will get a comma separated list in the form variable. e.g. with all 3 checked you'd get form.items = '1,2,3' then you just alter your query with an in statement ... where item_id in (, wrote: > > maybe i am

Error when Clustering CF Instances

2009-03-25 Thread Phillip Duba
I get the following error while trying to add an instance to a cluster: No MBean is registered on server under the ObjectName *:*. Also, trying to get to the administration server for this particular instance results int he following HTTP 500 error: There is no web application configured to se

RE: SQL server - Order totals by month, even without month data

2009-03-25 Thread William Seiter
There are 2 ways that come to mind right off the bat. 1. Create another table that has each month in it. Do an outer join that allows the other table to return 0 for the months where you have no records in your original table 2. Inspect the query in CF for missing months. If there are any miss

html in database

2009-03-25 Thread Chad Gray
I am doing a CMS type system and letting users edit pages with FCKeditor then storing the page HTML into a database field. I would like to make the menu system database drive and not statically created in FCKeditor. The menu system is inside of the area that FCKeditor is making. How do I inse

Re: How do you get motivated at work?

2009-03-25 Thread Yuliang Ruan
>> My way of keeping motivated is to make money while I >> code. Money is a big motivator. It keeps one happy and >> motivated to take the next step. > >For me, the money itself isn't the motivator, but what it allows me to do. >My coding pays for things like flight training and other fun stuff to

Re: Need help with a concept

2009-03-25 Thread Torrent Girl
Thanks Peter I'll try these out ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.co

CFLOOP with Stored Procedure

2009-03-25 Thread Priya Koya
I have a query and looping the results of a query. I want to display the names from the cfdocexamples when the user enters the first letters of their Names. I am using Ajax here...and the query is SELECT FirstName FROM Employees

Re: SQL server - Order totals by month, even without month data

2009-03-25 Thread Donnie Carvajal
The only way to get data into a query is to have data in a table. So there are a couple of options. 1. Create a months table that has 12 records 2. Create a temp table with 12 records You may also need to create a years table as well. Then your query would be something like SELECT year, mo

Re: Need help with a concept

2009-03-25 Thread Torrent Girl
Can I add a set time to this. Like first day of the week at 12:00 AM? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f

Re: Need help with a concept

2009-03-25 Thread Torrent Girl
> Or better still, just go straight from the date... > > to="#parseDateTime(Now())#" step="7"> > > > ... > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Fr

Re: Need help with a concept

2009-03-25 Thread Torrent Girl
wow that's perfect thanks! so will it increment to the next week everytime? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440

RE: SQL server - Order totals by month, even without month data

2009-03-25 Thread Robert Rawlins
Hello Will, I'd advise building yourself a calendar table, these are always a useful facility in any application where you're going to be doing report generation, I've attached the SQL script which creates and populates your calendar table, this basically creates a record for each date in a range

Re: Delivery Report

2009-03-25 Thread Azadi Saryev
maybe i am not fully understanding your requirements, but... if you give order item checkboxes names like cb_#this_order_id#_#this_item_id#, then when your form submits it will post only checked boxes, so you will have form fields like cb_1_1, cb_1_2, cb_3_4, ... - you can then loop over form.fiel

Re: httponly

2009-03-25 Thread Michael Traher
I realise now that the CFLOCATION is not server side although it does still seem to be the best solution. If your entire site can be SSL then you can set jsessionid cookies to be secure in the jrun-web.xml - this sets the secure attribute but not the httponly which would still be off until the se

RE: SQL server - Order totals by month, even without month data

2009-03-25 Thread Dawson, Michael
Create a calendar table. Load it with dates from 1900-2100. Each record relates to a single day. You can join to this table in many ways. Here is an example of one of my records... date 1900-01-01 00:00:00.000 dayOfWeek 2 dayOfWeekName Monday day 1 dayLeadingZero 01 month 1 monthLeading

RE: SQL server - Order totals by month, even without month data

2009-03-25 Thread Dawson, Michael
Also, since you are using SQL, you can use a CTE to dynamically generate a date range as a temp table, so to speak. I prefer a regular table as I mentioned in my last reply, however. Thanks, Mike -Original Message- From: Will Tomlinson [mailto:w...@wtomlinson.com] Sent: Wednesday, Marc

Delivery Report

2009-03-25 Thread Jason Congerton
Hi I am trying to create a delivery report for my website, the report is generated from the following tables ca_customers, ca_order_summary and ca_orderitems (please see query below) ca_customer >> holds the customer information (one record) ca_order_summary >> holds the order summary inform

SQL server - Order totals by month, even without month data

2009-03-25 Thread Will Tomlinson
I have your typical tblorders. I'm trying to query it to get order totals by month, and I'm outputting them in All goes fine, except in 2009. We have no order data for April-December of course, so the query returns just three rows (Jan, Feb, March). I need it to return all 12 months, with 0