RE: [ACFUG Discuss] POI

2006-08-17 Thread Charlie Arehart
No, those were rubber bullets. Supposed to be non-lethal. Really. :-) /charlie http://www.carehart.org/blog/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Reil Sent: Thursday, August 17, 2006 11:30 PM To: discussion@acfug.org Subject: RE: [ACFU

RE: [ACFUG Discuss] POI

2006-08-17 Thread Robert Reil
Ohhh got me with real bullets.. Ok Ill learn to google. Robert P. Reil Managing Director, Motorcyclecarbs.com, Inc. 4292 Country Garden Walk NW Kennesaw, Ga. 30152 Office 770-974-8851 Fax 770-974-8852 www.motorcyclecarbs.com -Original Message- From: Charlie Arehart [mailto:[EMAIL PRO

Re: [ACFUG Discuss] group count ability

2006-08-17 Thread Douglas Knudsen
what DB?  If on Oracle you can add a column to your query called say countofcolumntogroupby populated by using a aggregate function as a analytic functionCOUNT(*) OVER (PARTITION BY columntogroupby ) AS countofcolumnttogeroupby no grouping needed here on the SQL side.  Does SQLServer have a simila

RE: [ACFUG Discuss] group count ability

2006-08-17 Thread Charlie Arehart
That is a good question and would be a useful feature request, I think. I don't believe there to be any such solution for now.   (For those who don't know, the CFOUTPUT GROUP is intended to be used with a query that's been ORDERed BY the named ColumnToGroupBy. It then creates in the outer l

[ACFUG Discuss] group count ability

2006-08-17 Thread Seth Tepfer
When doing a group on a query, is there a simple way to identify the number of rows in each group/section? That is, rather than prerunning over the query and setting up an array or structure. Perhaps something built in, even? If not, is this something worth asking for? My Section Title 

RE: [ACFUG Discuss] POI

2006-08-17 Thread Charlie Arehart
Hmm. How should I answer "what's POI"? I could answer in my best Leslie Nielsen voice, from Airplane: "it's a traditional Hawaiian food made from ground up taro leaves, but that's not important right now..." Or I could do my helpful Charlie voice and point to you to http://jakarta.apache.org/poi/

RE: [ACFUG Discuss] POI

2006-08-17 Thread Gerrey . Mary-Catherine
Point Of Insanity It's been a LONG day.. mcg Robert Reil <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/17/2006 06:06 PM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject RE: [ACFUG Discuss] POI Whats a POI? Robert P. Reil Managing Dir

RE: [ACFUG Discuss] POI

2006-08-17 Thread Robert Reil
Whats a POI? Robert P. Reil Managing Director, Motorcyclecarbs.com, Inc. 4292 Country Garden Walk NW Kennesaw, Ga. 30152 Office 770-974-8851 Fax 770-974-8852 www.motorcyclecarbs.com -Original Message- From: Charlie Arehart [mailto:[EMAIL PROTECTED] Sent: Thursday, August 17, 2006 2:46 P

Re: [ACFUG Discuss] POI

2006-08-17 Thread john . lyons
yeap we are on the same page. what api did you use? open-source, pay or free? Quoting Teddy Payne <[EMAIL PROTECTED]>: I am not sure from here. In the past I used an API to batch change my PDFs from Word docs. I did not try to create the API itself due to lack of documentation from the sourc

Re: [ACFUG Discuss] POI

2006-08-17 Thread Teddy Payne
I am not sure from here.  In the past I used an API to batch change my PDFs from Word docs.  I did not try to create the API itself due to lack of documentation from the source files.  I cannot remember the API I used.  A quick Google turned up lots of results. I was hoping you discovered what I di

Re: [ACFUG Discuss] POI

2006-08-17 Thread john . lyons
not sure i would be able to do that. tostring the object of course gives up the java structure: [EMAIL PROTECTED] theres a step here where i can recourse into the document but i have no idea how. Quoting Teddy Payne <[EMAIL PROTECTED]>: What output formats does hdf support because you could

RE: [ACFUG Discuss] POI

2006-08-17 Thread Charlie Arehart
For those wondering about the context of this discussion, it was moved over from the community list. Here was the first message in the thread, to which these are replies: >From [EMAIL PROTECTED] > Ive added the poi scratchpad jar so i have access to word ole2 stuff. I initially was getting the er

Re: [ACFUG Discuss] POI

2006-08-17 Thread Teddy Payne
What output formats does hdf support because you could wrap it in a cfdocument if you are using mx 7 and have plain text, xml,png,jpg,gif?The xml in the case of cfdocument is analagous to pages rendered as HTML pages. TeddyOn 8/17/06, [EMAIL PROTECTED] <[EMAIL PROTECTED] > wrote:Quoting Teddy Payne

Re: [ACFUG Discuss] POI

2006-08-17 Thread john . lyons
Quoting Teddy Payne <[EMAIL PROTECTED]>: Oh i found lots of examples of excel. Thats the reason why the base poi libraries are in cfmx7. I had to add scratchpad to get the hdf functions which are for word files. I am 50% of the way there. I am trying to read a word document into the hdfDoc obje

Re: [ACFUG Discuss] POI

2006-08-17 Thread Teddy Payne
So, you are trying to use the POI library to read an excel document and output it as a pdf?TeddyOn 8/17/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: yes:poi-scratchpad-2.5.1-final-20040804.jarexposes the hdf classes.On 8/17/06, Teddy Payne <[EMAIL PROTECTED]> wrote:I do not think too many peop

[ACFUG Discuss] POI

2006-08-17 Thread john . lyons
yes:poi-scratchpad-2.5.1-final-20040804.jar exposes the hdf classes. On 8/17/06, Teddy Payne <[EMAIL PROTECTED]> wrote: I do not think too many people are going to know how to use the POI library. Which library JAR did you use? The one from Apache? Teddy --