Re: CF User group around Tallahassee Florida

2014-06-20 Thread Steve 'Cutter' Blades
://www.packtpub.com/learning-ext-js-3-2-for-building-dynamic-desktop-style-user-interfaces/book The best way to predict the future is to help create it On 6/19/2014 1:53 PM, Rick Dennis wrote: I am curious if there is a ColdFusion user group meeting or located near Tallahassee, Florida? If not where

Re: CF User group around Tallahassee Florida

2014-06-20 Thread Roger Austin
On 6/19/2014 2:53 PM, Rick Dennis wrote: I am curious if there is a ColdFusion user group meeting or located near Tallahassee, Florida? If not where are other CF groups located near by? I hope you find a CFUG near your area as user groups can be great for sharing knowledge. Please also

Re: CF User group around Tallahassee Florida

2014-06-20 Thread Gerald Guido
/gerald.guido.9 On Thu, Jun 19, 2014 at 2:53 PM, Rick Dennis rick.den...@fldoe.org wrote: I am curious if there is a ColdFusion user group meeting or located near Tallahassee, Florida? If not where are other CF groups located near

CF User group around Tallahassee Florida

2014-06-19 Thread Rick Dennis
I am curious if there is a ColdFusion user group meeting or located near Tallahassee, Florida? If not where are other CF groups located near by? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe

Group by??

2012-10-03 Thread Phillip Vector
to do is produce a table for MenuNameClient_Name Client_Code Test Test Company 4938,9328,10349 Test Test 2 Company 9283 So far, I have this.. cfoutput query=currentQuery group=Client_Code tr

Re: Group by??

2012-10-03 Thread Dave Watts
trying to do is produce a table for MenuNameClient_Name Client_Code Test Test Company 4938,9328,10349 Test Test 2 Company 9283 So far, I have this.. cfoutput query=currentQuery group=Client_Code tr

Re: Group by??

2012-10-03 Thread Phillip Vector
on that row. So I have a query that returns the following.. Whenever you use the GROUP attribute of CFOUTPUT, you use a nested CFOUTPUT to display the members of each group. So, you'd need something like this: cfoutput query=... group=Client_Name tr td#MenuName#/td td

Re: Group by??

2012-10-03 Thread Leigh
group=Client_Code It should work as long as its contained without a nested cfoutput as Dave mentioned. Also, notice he is grouping by Client_Name instead of the code.  Be sure the query results are sorted by that column too. -Leigh

Re: Group by??

2012-10-03 Thread Phillip Vector
*facepalms* That did it. I wasn't sorting the query by Client_Name. I was doing it by Client_Code. Thanks guys. I appricate the help. :) group=Client_Code It should work as long as its contained without a nested cfoutput as Dave mentioned. Also, notice he is grouping by Client_Name

cfchart bar chart for group by query result set

2012-02-18 Thread sarah mfr
I have a result set that has the following columns studentid,sectionid,tracedate,duration,pagehits I want to draw a horizontal bar chart per student per section displaying tracedate as xaxis and duration and pagehits as the yaxis one below the other Thanks

Re: cfchart bar chart for group by query result set

2012-02-18 Thread Leigh
What issue are you having with your code? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Re: Query of Queries and GROUP - use CFLOOP?

2011-08-02 Thread Chris Sizemore
I am using a cfloop condition approach to perform a standard branched tree operation. I have four tables and my query is pretty straight forward. The output is not working though. It is returning the correct amount of results and is organizing them properly but the values displayed are

Re: Query of Queries and GROUP - use CFLOOP?

2011-08-02 Thread Chris Sizemore
I am using a cfloop condition approach to perform a standard branched tree operation. I have four tables and my query is pretty straight forward. The output is not working though. It is returning the correct amount of results and is organizing them properly but the values displayed are

Re: Query of Queries and GROUP - use CFLOOP?

2011-08-02 Thread Azadi Saryev
use a cfoutput with group attribute instead? cfoutput query=GetStates group=StateID #GetStates.StateName# #GetStates.StateID# - cfoutput group=RegionID #GetStates.StateRegion# #GetStates.RegionID#BR / cfoutput group=CountryID cfoutput A HREF=property1.cfm?PropertyLocationID

RE: Looking for CF/Adobe Network group in Chicago

2011-02-09 Thread Eric Roberts
Joshua...check out Linkdin-Chicago (obviously on Linkdin). They have regular networking events downtown. There is also a tech group...I'll have to look it up when I get a chance that does the same. Currently, there isn't anything specifically CF going on at this time as far as I know. Eric

Re: Looking for CF/Adobe Network group in Chicago

2011-02-09 Thread J.J. Merrick
...@threeravensconsulting.com wrote: Joshua...check out Linkdin-Chicago (obviously on Linkdin). They have regular networking events downtown. There is also a tech group...I'll have to look it up when I get a chance that does the same. Currently, there isn't anything specifically CF going

Looking for CF/Adobe Network group in Chicago

2011-02-08 Thread Joshua O'Connor-Rose
Does anybody know of any groups in Chicago (downtown) that are active and has a focus on Coldfusion/Adobe products I'm looking to possibly shift back into Java/CF/Mobile world from .NET world. thanks in advance -Joshua O'Connor-Rose -All is Good

Re: Looking for CF/Adobe Network group in Chicago

2011-02-08 Thread John M Bliss
http://chicago.groups.adobe.com On Tue, Feb 8, 2011 at 3:05 PM, Joshua O'Connor-Rose joshua.oconnorr...@gmail.com wrote: Does anybody know of any groups in Chicago (downtown) that are active and has a focus on Coldfusion/Adobe products I'm looking to possibly shift back into

RE: Looking for CF/Adobe Network group in Chicago

2011-02-08 Thread Eric Roberts
Joshua, The CHIFUG group has been relative dormant and there has only been a couple of meetings over the past couple of years. I would love to see something start up again. They guy that used to run it had twins a few years ago and obviously, that and the coffee shop he runs with his wife

RE: Looking for CF/Adobe Network group in Chicago

2011-02-08 Thread Terry Troxel
thought out that I could attend online that would allow me to expand, meet, and partake in anything CF related, that just might put some forward momentum in this wild and crazy language we all love so much. Some of you folks in this group certainly have the knowledge, resources, desire to pull

Re: Looking for CF/Adobe Network group in Chicago

2011-02-08 Thread Casey Dougall
On Tue, Feb 8, 2011 at 5:55 PM, Terry Troxel terry.tro...@gmail.com wrote: Hey, is this the INTERNET world? Are we having a hard time finding the funds to have a big Coldfusion Extravaganza to host, participate in, attend, etc.? You mean like? http://www.meetup.com/coldfusionmeetup/

Re: Looking for CF/Adobe Network group in Chicago

2011-02-08 Thread Kelly
You beat me to it! LOL :) On 2/8/2011 6:10 PM, Casey Dougall wrote: You mean like? http://www.meetup.com/coldfusionmeetup/ ~| Order the Adobe Coldfusion Anthology now!

RE: Looking for CF/Adobe Network group in Chicago

2011-02-08 Thread Terry Troxel
: Looking for CF/Adobe Network group in Chicago On Tue, Feb 8, 2011 at 5:55 PM, Terry Troxel terry.tro...@gmail.com wrote: Hey, is this the INTERNET world? Are we having a hard time finding the funds to have a big Coldfusion Extravaganza to host, participate in, attend, etc.? You mean like

Re: Looking for CF/Adobe Network group in Chicago

2011-02-08 Thread Joshua O'Connor-Rose
While CFMeetup is great and there are awesome presentations going on it's not exactly a networking opportunity for folks in the area. I participate in the web events and they are great, but networking ops aren't quite the same. Thanks for the info. -Joshua O'Connor-Rose -All is Good

Re: Looking for CF/Adobe Network group in Chicago

2011-02-08 Thread Casey Dougall
On Tue, Feb 8, 2011 at 10:09 PM, Joshua O'Connor-Rose joshua.oconnorr...@gmail.com wrote: While CFMeetup is great and there are awesome presentations going on it's not exactly a networking opportunity for folks in the area. I participate in the web events and they are great, but networking

Is the Atlanta ColdFusion users group still active?

2011-01-31 Thread mftroyu
Hi all, I was just wondering if the Atlanta CF Users Group was still active. I still see the site up but no monthly meeting scheduled. Thanks in advance for any help! MIke ~| Order the Adobe Coldfusion Anthology now! http

Group BY

2010-11-03 Thread Monique Boea
How can I get this query to group by month? select count(intMemberID)as NewMembers, DATENAME(mm, dteAdded) + '-' + DATENAME(, dteAdded) AS Month FROM TABLE GROUP BY Month(dteAdded) When I ask on google everyone says to add: *GROUP BY Year(SomeDate), Month(SomeDate) * but that doesn't work

re: Group BY

2010-11-03 Thread Jason Fisher
If this is SQL Server, than the GROUP BY has to match the un-aggregated SELECT columns, so it would need to be something like: SELECT COUNT(intMemberID) AS NewMembers, DATENAME(mm, dteAdded) + '-' + DATENAME(, dteAdded) AS Month FROM TABLE GROUP BY DATENAME(mm, dteAdded

RE: Group BY

2010-11-03 Thread DURETTE, STEVEN J (ATTASIAIT)
Your group by has to match your select in most cases... Also, you are using reserved words in your query so that can mess stuff up. Try this instead... Select count(intMemberID) as [NewMembers], dateName(mm, [dteAdded]) + '-' + dateName(, [dteAdded]) as MTH From table Group by dateName(mm

Re: Group BY

2010-11-03 Thread Monique Boea
That was it. I found the solution SELECT DATENAME(mm, article.Created) AS Month, DATENAME(, article.Created) AS Year, COUNT(*) AS Total FROM Articles AS article GROUP BY DATENAME(mm, article.Created), DATENAME(, article.Created) ORDER BY Month, Year DESC

Re: New Coldfusion User Group in the DC Area

2010-09-02 Thread george.e...@ssa.gov george.e...@ssa.gov
The Capital Area ColdFusion User Group is now beginning to meet. Our first meeting will be Tuesday, September 14th at 6pm. ... Sandy Clark Is this replacing the MDCFUG? ~| Order the Adobe Coldfusion Anthology now! http

Re: New Coldfusion User Group in the DC Area

2010-09-02 Thread Sandra Clark
You would have to talk to Teratech about that part. I will say that this is an Approved Adobe Coldfusion User Group. On Thu, Sep 2, 2010 at 11:09 AM, george.e...@ssa.gov george.e...@ssa.gov george.e...@ssa.gov wrote: The Capital Area ColdFusion User Group is now beginning to meet. Our

New Coldfusion User Group in the DC Area

2010-09-01 Thread Sandra Clark
The Capital Area ColdFusion User Group is now beginning to meet. Our first meeting will be Tuesday, September 14th at 6pm. It will be a social gathering, held at Timpanos Italian Grill, 12021 Rockville Pike Rockville MD 20852. View Map of Locationhttp://www.mapquest.com/maps/map.adp?address

CFlickr help upload to a group

2010-06-22 Thread Rick Mason
I am building a web form that uploads pictures to our account on Flickr. Using the CFlickr library examples I was able to get the form posting to Flickr. But I need it to post to a specific group within our account. In Flickr parlance groups are sort of like folders and depending on the posters

Re: cfselect binding group= not working

2010-05-28 Thread Azadi Saryev
On 27/05/2010 02:24, Janet Whittredge wrote: What is missing?? Missing is a clear explanation in CFML Reference that GROUP attribute does not work with bind'ed cfselect. It works only with query-based cfselect. Azadi

cfselect binding group= not working

2010-05-26 Thread Janet Whittredge
ColdFusion8, Windows Server2003, JQuery I have a cfform with a cfselect on it, bound to the selection on another cfselect. This cfselect loads from the query returned from cfc, and, the display and value attributes work, but the group does not. I expect group='column' to populate the select

GROUP BY problem...

2009-10-02 Thread Les Mizzell
ON areas.empID = employees_office.empID ORDER BY employees.name, employees_office.theORDER OK, here's the problem I need to be able to GROUP BY employees.empID so each employee is returned only ONCE (a unique empID), but, I can't include any of the columns in the other tables in the GROUP BY, because

RE: GROUP BY problem...

2009-10-02 Thread DURETTE, STEVEN J (ATTASIAIT)
02, 2009 12:10 PM To: cf-talk Subject: GROUP BY problem... SELECT employees.empID employees.name, employees_office.theORDER office.office_name areas.area_NAME FROM employees INNER JOIN employees_office ON employees.empID = employees_office.empID INNER JOIN office

Re: GROUP BY problem...

2009-10-02 Thread Agha Mehdi
Why not just cfoutput query= group=name b#name#/bbr cfoutput #area_name#, #office_name#br /cfoutput /cfoutput On Fri, Oct 2, 2009 at 9:09 AM, Les Mizzell lesm...@bellsouth.net wrote: SELECT employees.empID employees.name

Re: GROUP BY problem...

2009-10-02 Thread Les Mizzell
Agha Mehdi wrote: Why not just cfoutput query= group=name b#name#/bbr cfoutput #area_name#, #office_name#br /cfoutput /cfoutput I could - but it's way more complicated than that... This single query (example was simplified) is responsible

RE: GROUP BY problem...

2009-10-02 Thread DURETTE, STEVEN J (ATTASIAIT)
information. You could make multiple columns address1, address2, etc but that is considered really bad database design and isn't normalized. Steve -Original Message- From: Les Mizzell [mailto:lesm...@bellsouth.net] Sent: Friday, October 02, 2009 12:58 PM To: cf-talk Subject: Re: GROUP

RE: GROUP BY problem...

2009-10-02 Thread Dave Phillips
Diego (W), New Orleans (S) Is that the kind of result set you are looking for? Dave -Original Message- From: Les Mizzell [mailto:lesm...@bellsouth.net] Sent: Friday, October 02, 2009 11:10 AM To: cf-talk Subject: GROUP BY problem... SELECT employees.empID employees.name

Need help with cfquery for a sort and a group

2009-09-12 Thread Traci Porter
Hello. I'm hoping someone here can help me. I have a search form that is submitted (with a number of criteria but for this purpose) with a proposal number (Pipe_id) and what type of file the user is looking for (proposal (chkProposal), solicitation (chkSolicitation), debrief (chkDebrief)).

RE: Need help with cfquery for a sort and a group

2009-09-12 Thread Chuck
query=MyQry group=Pipe_id #MyQry.Pipe_id#br / !--- This will display once. --- cfoutput #MyQry.File_title#br / !--- This will display all the documents associated to the Pipe_id --- /cfoutput /cfoutput HTH Chuck

Re: Getting a count from a group in cfquery

2009-05-06 Thread Jason Fisher
, emailID, emailDate, groupID FROM log_email GROUP BY emailID, groupID, emailDate ) AS sub ON e.emailID = sub.emailID WHERE sub.emailID = cfqueryparam cfsqltype=CF_SQL_VARCHAR value

Re: Getting a count from a group in cfquery

2009-05-06 Thread Scott Stroz
,        sub.groupID FROM log_email e RIGHT OUTER JOIN        (                SELECT COUNT(emailAddress) AS thisCount,                        emailID,                        emailDate,                        groupID                FROM log_email                GROUP BY emailID, groupID, emailDate

Getting a count from a group in cfquery

2009-05-05 Thread Les Mizzell
What I'm trying to get: cfoutput query=thisLOG group=groupID / #thisCOUNT# emails sent on #thisLOG.emailDATE# cfoutput #thisLOG.emailADDRESS#br /cfoutput /cfoutput thisCOUNT above would be the number of emails in a particular group Here's what I want to do in my query

Re: Getting a count from a group in cfquery

2009-05-05 Thread Greg Morphis
)# cfsqltype=CF_SQL_INTEGER / ORDER BY emailDATE desc then you dont need the GROUP BY caluse On Tue, May 5, 2009 at 10:56 AM, Les Mizzell lesm...@bellsouth.net wrote: What I'm trying to get: cfoutput query=thisLOG group=groupID /   #thisCOUNT# emails sent on #thisLOG.emailDATE#    cfoutput

RE: Getting a count from a group in cfquery

2009-05-05 Thread Adrian Lynch
You need to include the other columns in your SELECT in your GROUP BY clause. Adrian -Original Message- From: Les Mizzell [mailto:lesm...@bellsouth.net] Sent: 05 May 2009 16:56 To: cf-talk Subject: Getting a count from a group in cfquery What I'm trying to get: cfoutput

Re: Getting a count from a group in cfquery

2009-05-05 Thread Les Mizzell
Adrian Lynch wrote: You need to include the other columns in your SELECT in your GROUP BY clause. When I do that, the group count is always 1 I'm using a second query right now, but there's got to be a more compact way... -Original Message- From: Les Mizzell [mailto:lesm

Re: Getting a count from a group in cfquery

2009-05-05 Thread Azadi Saryev
you can also do it cf-only way: cfquery ... SELECT emailID, emailADDRESS, emailDATE, groupID FROM log_email WHERE emailID = cfqueryparam value=#trim(url.emailID)# cfsqltype=CF_SQL_INTEGER / ORDER BY emailDATE DESC /cfquery cfoutput query=thisLOG group=emailDATE

Help requested - Syntax for GROUP BY with HAVING ...

2009-03-24 Thread BobSharp
(a.Amount) AS AverageAward, SUM(a.Amount) AS DeptTotal FROM incentiveawards a INNER JOIN employeedirectory e ON (e.ID = a.RecipientIDfk) INNER JOIN departments d ON (d.DepartmentID = e.DepartmentIDfk) WHERE SUM(a.Amount) 5000 GROUP BY d.DeptName

Re: Help requested - Syntax for GROUP BY with HAVING ...

2009-03-24 Thread Peter Boughton
Do this: SELECT d.DeptName AS dName, AVG(a.Amount) AS AverageAward, SUM(a.Amount) AS DeptTotal You can't select individual amounts if you're performing aggregates on that same column. Also, your SUM(a.Amount) 5000 belongs probably needs to go in the HAVING clause.

RE: Help requested - Syntax for GROUP BY with HAVING ...

2009-03-24 Thread brad
Try putting a.Amount in your group by clause. Everything in your select list should be in the group by OR should have an aggregate function applied to it. Also, I noticed you are referencing an alias AverageAward in your order by. I'm pretty certain SQL Server doesn't let you do that, but you

Re: Help requested - Syntax for GROUP BY with HAVING ...

2009-03-24 Thread BobSharp
OK, think I've got it now ... GROUP BY contains the main criteria for the query (not to be confused with ORDER BY) HAVING should contain any (both) conditions needed for the search. http://ttcfm.open.ac.uk/~bs3578/test1/Week9_Act6.cfm thanks BTWare there any tutorials online

Re: Help requested - Syntax for GROUP BY with HAVING ... ommitted code

2009-03-24 Thread BobSharp
Sorry, forgot to include the revised script ... = === OK, think I've got it now ... GROUP BY contains the main criteria for the query (not to be confused with ORDER BY) HAVING should contain any (both) conditions needed for the search. http

Re: Help requested - Syntax for GROUP BY with HAVING ... ommitted code

2009-03-24 Thread Brad Wood
I don't see how that SQL would work. You are using deptName in your select list and order by, but you aren't grouping by it. Unless MySQL allows you to do stuff that SQL Server doesn't, that should throw an error. Also, I had originally suggested placing the amount in the group by, but I

Query Group Clause and determining the end of a group

2009-03-12 Thread Mark Henderson
attributes.newRow = true / cfoutput query=qGetSponsors group=Category_ID h3#Category#/h3 cfif Display_Type EQ Images div class=sponsorimgcontainer div class=sponsorimgbox cfoutput cfset attributes.currentCat = qGetSponsors[Category][qGetSponsors.currentRow]/ cfset

RE: Query Group Clause and determining the end of a group

2009-03-12 Thread Mark Henderson
Ooops, sorry about that first post. I hadn't set Outlook 2007 (yes, please keep the comments to yourself!) to automatically send text messages to the list. Settings for cf-talk updated now. Regards Mark ~| Adobe® ColdFusion® 8

setting a var from Inside cfoutput group

2009-02-27 Thread Paul Ihrig
cfoutput group=n1#n1Id#,/cfoutput i need to set a variable as a list from the results above. i tried putting a cfset inside the cfoutput, but it didn't work. some thing like cfset myList = 7,4,9 ~| Adobe® ColdFusion® 8

RE: setting a var from Inside cfoutput group

2009-02-27 Thread Adrian Lynch
cfset myList = ListAppend(myList, ni.id) Adrian -Original Message- From: Paul Ihrig [mailto:pih...@gmail.com] Sent: 27 February 2009 16:58 To: cf-talk Subject: setting a var from Inside cfoutput group cfoutput group=n1#n1Id#,/cfoutput i need to set a variable as a list from

Re: setting a var from Inside cfoutput group

2009-02-27 Thread Paul Ihrig
cfoutput group=n1 cfset myList = #n1Id#, cfset myListx = ListAppend(myList, n1Id) /cfoutput returns: myList: 6, myListX: 6,,6 cfoutput group=n1#n1Id#,/cfoutput returns: 1,7,2,6, which is what i want, but as a carible i can call outside of the output

Re: setting a var from Inside cfoutput group

2009-02-27 Thread morgan l
You're restarting the variable by setting it inside the output group. Try: cfset myList = cfoutput group=n1 cfset myListx = ListAppend(myList, n1Id) /cfoutput On Fri, Feb 27, 2009 at 11:10 AM, Paul Ihrig pih...@gmail.com wrote: cfoutput group=n1 cfset myList = #n1Id#, cfset myListx

Re: setting a var from Inside cfoutput group

2009-02-27 Thread Paul Ihrig
Thanks Guys! worked like a charm! On Fri, Feb 27, 2009 at 12:18 PM, morgan l greyk...@gmail.com wrote: You're restarting the variable by setting it inside the output group. Try: cfset myList = cfoutput group=n1 cfset myListx = ListAppend(myList, n1Id) /cfoutput On Fri, Feb 27, 2009

Re: setting a var from Inside cfoutput group

2009-02-27 Thread Jason Fisher
Or, if you don't need to loop the output for any other reason, just do this once, without using CFOUTPUT at all: cfset myList = valueList(n1.n1Id) / ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic

Re: sum of cfquery with group by

2008-12-15 Thread Claude Schneegans
you can also do: #arraysum(queryname.columnname)# Any CF function will be executed before the query by CF. What is needed here is an SQL function executed inside the query. ~| Adobe® ColdFusion® 8 software 8 is the most

Re: sum of cfquery with group by

2008-12-15 Thread Claude Schneegans
Sorry : my mistake, I was mistaking this thread for Is there a non-aggregate Max() function in MySQL? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial

Re: sum of cfquery with group by

2008-12-14 Thread Azadi Saryev
you can also do: #arraysum(queryname.columnname)# Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Tech Gate wrote: cfquery select a.Dept, c.Assonum . group by a.Dept, c.Assonum /cfquery I need to get the SUM of c.Assonum, but I can't do sum(c.Assonum

sum of cfquery with group by

2008-12-12 Thread Tech Gate
cfquery select a.Dept, c.Assonum . group by a.Dept, c.Assonum /cfquery I need to get the SUM of c.Assonum, but I can't do sum(c.Assonum ) in the sql (cfquery). What is the way to get the SUM of c.Assonum with cf function? Please advise. Thank you

Re: sum of cfquery with group by

2008-12-12 Thread Jason Fisher
There's not a function, but you can add them up as you loop over the query: cfset sumAssonum = 0 cfoutput query=... cfset sumAssonum = sumAssonum + Assonum /cfoutput cfoutputSUM of Assonum is #sumAssonum#/cfoutput cfquery select a.Dept, c.Assonum . group by a.Dept, c.Assonum

Re: sum of cfquery with group by

2008-12-12 Thread Tech Gate
is #sumAssonum#/cfoutput cfquery select a.Dept, c.Assonum . group by a.Dept, c.Assonum /cfquery I need to get the SUM of c.Assonum, but I can't do sum(c.Assonum ) in the sql (cfquery). What is the way to get the SUM of c.Assonum with cf function? Please advise. Thank you

What's wrong with my cfoutput group?

2008-12-01 Thread Will Tomlinson
I don't recall ever having a problem with the cfoutput group attribute. But I can't figure out why it isn't woring right here. My table looks like this: ID Date ZIP code - 1 12/01/200827403 2 12/01/200890210 3 12/01/2008

Re: What's wrong with my cfoutput group?

2008-12-01 Thread Will Tomlinson
Crap, it goes back to my stupid date/time datatype for the field. All the times are different, and CF IS group the data, but they're all different so it output each row. I used Michael's example from my other thread to do this. Seems to work: SELECT estshiplogid,CAST(FLOOR(CAST(estshiplogdate

subtotal SUM in group query

2008-11-17 Thread Mark Townsend
, Cost from travel WHERE reconciled = 'No' GROUP BY Acct, Name, Cost /cfquery to try and get the groups summed up together, but my sum total is only the first record so it looks like the following. The output is: cfoutput query=GetCostSum group=Acct strong#Acct#-6405/strongbr

Re: subtotal SUM in group query

2008-11-17 Thread C S
Do I need to do some kind of a loop to get the subtotals for each account? Thanks. There are a few ways to do it. One option is to use a variable to accumulate the subtotals within your inner cfoutput. cfoutput query=GetCostSum group=Acct strong#Acct#-6405/strongbr

Re: subtotal SUM in group query

2008-11-17 Thread Azadi Saryev
you didn't say which db you are using, but with MySQL you have a GROUP BY ... WITH ROLLUP option (if i remember correctly). Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Mark Townsend wrote: Hello. Say I have a table with the following data: Acct#, Name, Cost 001, Bennett, 50.00

Re: LinkedIn CF group

2008-06-13 Thread Richard Dillman
Just another way for headhunters to find more information about you. Actually works well in that regard. On Thu, Jun 12, 2008 at 4:41 PM, AJ Mercer [EMAIL PROTECTED] wrote: Theis is a Railo group too ***http://www.linkedin.com/e/gis/71368/0CF7D323BBC1 * On Thu, Mar 6, 2008 at 11:54 PM

Re: LinkedIn CF group

2008-06-12 Thread Tom Chiverton
On Wednesday 11 Jun 2008, Dawson, Michael wrote: Linked In = Facebook - Drunk Girl Pics Yeah, I use LinkedIn to maintain my 'professional' links, and Something Else for the 'man, I'm so wasted after last night' stuff :-) -- Tom Chiverton

Re: LinkedIn CF group

2008-06-12 Thread AJ Mercer
Theis is a Railo group too ***http://www.linkedin.com/e/gis/71368/0CF7D323BBC1 * On Thu, Mar 6, 2008 at 11:54 PM, Ben Forta [EMAIL PROTECTED] wrote: And here's a Flex group, just coz ;-) http://www.linkedin.com/e/gis/65596/7DF3445D30E0 --- Ben -Original Message- From: James

Re: LinkedIn CF group

2008-06-11 Thread James Wolfe
1,000 users and counting though I still have no idea what to do with the group. Any ideas? I'm not sure what purpose it serves, but I created a LinkedIn CF group if anyone cares http://www.linkedin.com/groupInvitation?groupID=63526sharedKey=59CB6255962F

Re: LinkedIn CF group

2008-06-11 Thread Phillip Vector
I always wondered what the purpose of Linked In actually was.. *shrugs* No idea. On Wed, Jun 11, 2008 at 12:34 PM, James Wolfe [EMAIL PROTECTED] wrote: 1,000 users and counting though I still have no idea what to do with the group. Any ideas

RE: LinkedIn CF group

2008-06-11 Thread Dawson, Michael
Linked In = Facebook - Drunk Girl Pics m!ke -Original Message- From: Phillip Vector [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 11, 2008 2:44 PM To: CF-Talk Subject: Re: LinkedIn CF group I always wondered what the purpose of Linked In actually was.. *shrugs* No idea

Re: LinkedIn CF group

2008-06-11 Thread Gerald Guido
Vector [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 11, 2008 2:44 PM To: CF-Talk Subject: Re: LinkedIn CF group I always wondered what the purpose of Linked In actually was.. *shrugs* No idea. ~| Adobe® ColdFusion® 8

query on query group by

2008-05-30 Thread Richard White
hi i am trying to run this query of query: cfquery name=newQuery dbtype=query select * from query1 group by column1, column2; /cfquery but it gives me the following error: The column query.column3 is invalid in the SELECT list clause because it is not contained in either an aggregate

Re: query on query group by

2008-05-30 Thread Dominic Watson
select * from query1 group by column1, column2; /cfquery but it gives me the following error: The column query.column3 is invalid in the SELECT list clause because it is not contained in either an aggregate function or the GROUP BY clause. it doesnt say this if i query in mysql

User/Role/Group Permissions

2008-05-08 Thread Jason Durham
Anybody have any recommendations on web sites or literature for setting up role-based OO permission architecture? I'd like to have a method on each user object that checks through a list of asset permissions. Setting up the necessary DB tables and assigning asset permissions is the type of stuff

RE: LinkedIn CF group

2008-03-06 Thread Ben Forta
And here's a Flex group, just coz ;-) http://www.linkedin.com/e/gis/65596/7DF3445D30E0 --- Ben -Original Message- From: James Wolfe [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2008 6:01 PM To: CF-Talk Subject: LinkedIn CF group I'm not sure what purpose it serves, but I

Re: LinkedIn CF group

2008-03-06 Thread Rick Root
Cool. I just joined linkedin yesterday. www.linkedin.com/in/rickroot And now I joined those groups. On 3/6/08, Ben Forta [EMAIL PROTECTED] wrote: And here's a Flex group, just coz ;-) http://www.linkedin.com/e/gis/65596/7DF3445D30E0 --- Ben -Original Message- From: James

LinkedIn CF group

2008-03-04 Thread James Wolfe
I'm not sure what purpose it serves, but I created a LinkedIn CF group if anyone cares http://www.linkedin.com/groupInvitation?groupID=63526sharedKey=59CB6255962F ~| Adobe® ColdFusion® 8 software 8 is the most important

Re: LinkedIn CF group

2008-03-04 Thread RobG
I'm game. Just joined. Rob On Tue, Mar 4, 2008 at 3:01 PM, James Wolfe [EMAIL PROTECTED] wrote: I'm not sure what purpose it serves, but I created a LinkedIn CF group if anyone cares http://www.linkedin.com/groupInvitation?groupID=63526sharedKey=59CB6255962F

Re: LinkedIn CF group

2008-03-04 Thread James Holmes
+1 On Wed, Mar 5, 2008 at 9:08 AM, RobG wrote: I'm game. Just joined. On Tue, Mar 4, 2008 at 3:01 PM, James Wolfe [EMAIL PROTECTED] wrote: I'm not sure what purpose it serves, but I created a LinkedIn CF group if anyone cares http://www.linkedin.com/groupInvitation?groupID

Re: LinkedIn CF group

2008-03-04 Thread Mike Little
me too! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive:

LDAP Query for group members

2008-02-22 Thread Burns, John D
I'm trying to find out if there's a simpler way to do this than what I'm doing. Currently, I'm querying a group from LDAP and retrieving the attribute called Member which gives me this ugly result set of one record with all of these domain users' distinguished names instead of just the AD username

RE: LDAP Query for group members

2008-02-22 Thread Dawson, Michael
LDAP query for each member. That could, and will, be very slow, if you have a large group. You will also have a limitation of 1000 members. Active Directory returns only 1000 values in a multi-value attribute. There is a workaround for this, but it really sucks. I don't even want to talk about

RE: LDAP Query for group members

2008-02-22 Thread Dawson, Michael
Also, you need to specify the DELIMITER attribute in the CFLDAP tag. Set it to a tab character chr(9). You won't be passing any tabs in your filter, however, this prevents any errors because of the commas in the group's distinguished name. Ignore this part of my message. This is only needed if

RE: LDAP Query for group members

2008-02-22 Thread Burns, John D
Michael- AWESOME! Thank you so much for the help. Is it as simple to add users to the group using the same method? Did you come up with this on your own or find this info somewhere? Any other tips of things I can look out for as I'm working with CFLDAP? John -Original Message- From

RE: LDAP Query for group members

2008-02-22 Thread Burns, John D
AWESOME! Thank you so much for the help. Is it as simple to add users to the group using the same method? Did you come up with this on your own or find this info somewhere? Any other tips of things I can look out for as I'm working with CFLDAP? John -Original Message- From: Dawson

RE: LDAP Query for group members

2008-02-22 Thread Dawson, Michael
Glad to help. Regarding group membership, check back through the archives on this list. Specifically, look on Thurs, Jan 17, 2008 at 9:12 AM. I posted a reply with the subject of RE: CFLdap. This reply contains the code that uses CFLDAP to add and remove domain group members. If you can't

Re: How to sort columns and Group them at the same time

2008-02-21 Thread Ali
You are right. I deleted USERID and the whole problem is solved. Thanks Ali ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial

Re: How to sort columns and Group them at the same time

2008-02-20 Thread Ali
That's true. UserID is unique and makes everything else in ORDER BY useless but what should I do? Cause group in cfoutput needs UerID. Please help me. Thanks benign On 2/20/08, Dave Francis [EMAIL PROTECTED] wrote: ORDER BY Tbl_Dogs.DogID, Tbl_Users.UserID, Tbl_DogPurchWait.DogPurchWaitDate

  1   2   3   4   5   6   7   >