Start Free Trial
Output report with coldfusion
I have a table with some columns: "UnQID" "UserID" "CompDate" "ModDate"
I would like to output a query that will show a list of UserIDs and a count of how many CompDates or Moddates they appear in for a given timespan. Could someone assist?
I would provide the date range into a query in a cfc with arguments. I'd like it to display a YTD or a given range. Any ideas?
It would look something like this:
8/22/2022 - Mon
How do you mean - "how many comp dates or mod dates they appear in"?
What is an example value for your compdate and moddate columns?
Can you post a couple example rows with values for each column?
Basically you can think of them as orders. How many orders does each person complete a day. ModDate is the date an order is created. CompDate is a date the order is completed.
I'd like to a table to show how many were created by each person based on those dates.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
So I can use declare in a cfquery?
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
I'm in the habit of doing it this way so that I can create a stored procedure and send in var values to it that originally may be CF vars.
If you are doing a CF Query right on the same page as your code you could just simplify and do something like :
# and #CreateODBCDateTime(Edate)
and in this case Sdate would be a CF variable you've sent in i.e. Apr 1, 2012
I just prefer my method even if the query is on the same page - seems cleaner - but it is your choice - you are the developer!
Plans and Pricing
Certified Expert Program
© 1996-2023 Experts Exchange, LLC. All rights reserved. Covered by US Patent