CF executing stored procedures?
I have come across an interesting occurrence where CF mysteriously started to fail on a Stored procedure. The storedProc was working fine for a while and now it doesn't. The storedProc is executed in a cfquery (there seems to be an issue with the cfstoredproc tag and paraming timestamps), anyways it executes in SQL QUERY ANALYZER just fine. The SQL statement is good and generates no errors. Sometimes CF will leave an open pipe to the db server and lock up the database for 45 minutes. Anyone have any suggestions? Environment: NT 4.0 sp5 CF 4.5.2 MDAC 2.5.13 DataSource is setup as OLEDB NT4.0 sp5 SQL7.0 Located on same network. Sincerely, Matthew M. Eschenbaum Allaire Certified Professional DevTech Inc. [EMAIL PROTECTED] 206.956.0888 www.dev-tech.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
IsDate() with NULL's inside a loop!!
Got another good one. I'm doing an IsDate() function for a cfif statement, inside a cfloop-query. The problem is that the cfif's will not function properly if there are NULL's in the data. Any suggestins would be nice... Here is the code: cfloop query=qTMPPull cfif IsDate(qTMPPull.OpenDate) cfset OpenDate = createODBCDate(qTMPPull.OpenDate) cfelse cfset OpenDate = a /cfif cfif IsDate(qTMPPull.CloseDate) cfset CloseDate = createODBCDate(qTMPPull.CloseDate) cfelse cfset CloseDate = not here /cfif cfif IsDate(qTMPPull.LastBilled) cfset LastBilled = createODBCDate(qTMPPull.LastBilled) cfelse cfset LastBilled = b /cfif cfoutput#IsDate(qTMPPull.OpenDate)#-#OpenDate#-a#qTMPPull.OpenDate#-br #IsDate(qTMPPull.LastBilled)#-#LastBilled#-bbr #IsDate(qTMPPull.CloseDate)#-#CloseDate#-here/cfoutputcfabort ... /cfloop THIS is what it returns: NO--a- NO--b NO--here Any ideas Sincerely, Matthew M. Eschenbaum Allaire Certified Professional DevTech Inc. [EMAIL PROTECTED] 206.956.0888 www.dev-tech.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CF Server Locking?
I have a client who has problems with sessions getting corrupt. I've determined that their site does not utilize locking in the code throughout the application. During my research I noticed that they didn't set up the ColdFusion Administrator Variable Locking. Now, can I just configure the settings in the ColdFusion Administrator for variable locking and not have to go back and code locks. I know this is a stretch, but I haven't been able to find any definitive documentation on the ColdFusion Administrator configuration for Variable Locking. Any suggestions or leads would be appreciated. matt ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: using NT accounts for username/password login authentication
Set up the LDAP in the CFA as a new user Directory. You will need to point it to the LDAP server (via IP or Domain Name). You will need an account with sufficient privileges, search root, Lookup start, and the lookup end. You can then set a context to use the cfauthenticate tag. This can be time consuming but once done works rather well. Depending on your access to the LDAP server schema, you can also utilize the CFLDAP tag to authenticate as well as query for information on the server. Sincerely, Matthew M. Eschenbaum Allaire Certified Professional DevTech Inc. [EMAIL PROTECTED] 206.956.0888 www.dev-tech.com -Original Message- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 1:21 PM To: CF-Talk Subject: RE: using NT accounts for username/password login authentication um...you did post to the list. :) ldap is a different animal. i've never really used it for authentication, besides Win2K's ACLs being LDAP-compliant. you're probably going to want to look into Advanced Security. it can use an LDAP database for suthentication. of course, it's a BEAST to setup. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Jerre Hale [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 3:52 PM To: CF-Talk Subject: Re: using NT accounts for username/password login authentication Chris, Sorry to respond to you this way. I subscribed to this list only today. I am looking for help on authenticating users against an ldap directory but have not quite gotten there yet and I cannot see how to post to the list. Any pointers on how to post to the list would be appreciated. Then I will be more descriptive in my question. Thanks, Jerre Christopher Olive, CIO wrote: if you're running IIS, just switch off anonymous access. users will be prompted for their NT password, and the ACL on that directory/file will take over. if they're not authorized, they get a 403.1 error. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Philip Humeniuk [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 12:09 PM To: CF-Talk Subject: Re: using NT accounts for username/password login authentication How would you go about accessing the NT accounts and use those username/password for login authentication rather than accessing an MS Access database? Has anyone done this before? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: using variable list from a multiple select/form (warning: lon g)
Your trying to do to many loops. Try this and let me know if works for you.
CFLOOP INDEX=get_count
LIST=#form.notify#
CFQUERY NAME=notify_email DATASOURCE=iMIS Enterprise
SELECT Users.UserName
FROM Users Users
WHERE (Users.UserId='#form.NOTIFY#')
/cfquery
cfset Dear = Users.Username
!--- CFMAIL FROM=[EMAIL PROTECTED]
TO=#form.notify#@dineout.org
SUBJECT=Help Desk Request for Follow-up
SERVER=mail.dineout.org
Dear #Dear# !--- this doesn't work right, just yet -- but it will ---
/cfloop
Sincerely,
Matthew M. Eschenbaum
Allaire Certified Professional
DevTech Inc.
[EMAIL PROTECTED]
206.956.0888
www.dev-tech.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 25, 2001 3:45 PM
To: CF-Talk
Subject: using variable list from a multiple select/form (warning: long)
Hello all,
I am having trouble using a particular variable. This is a long email
because I am trying to provide enough information to give a clear picture of
my problem (which is probably quite simple and I probably should be able to
solve it on my own ...)
I have a form variable (called NOTIFY) which comes from a drop-down option
(dynamically populated) which allows for multiple choices. The variable
arrives on the action page (where the data is inserted in a table, that
works
no problem) as a comma delimited list. Once it arrives at the action page,
it
serves two functions. It's email address creation function works
beautifully. But then I need to use it to query our membership database to
pull out the actual name of the person so that the email message is more
user
friendly ... (the CN in an email address just won't do for Dear , you
know how that goes).
What I think I need to do it
1. Count the number of items in the list
2. Run it through a list loop to parse each item out as a separate variable
3. Run the query to the membership database to get the UserNames, using the
newly created variables.
4. Run it through a query to put it back in a new variable for output in the
single email that is generated.
But I don't know how to count the items or run the list loop. Can you help
me?
Here's the code for the select from the form, populated by an earlier query:
SELECT NAME=NOTIFY
SIZE=8
MULTIPLE
CFOUTPUT QUERY=notify
OPTION VALUE=#NOTIFY##NOTIFY#
/cfoutput
OPTION VALUE= No Report
/SELECT
And this is what I have in the action form, so far:
!--- First, test to see if the call taker has chosen to notify anyone. If
no notification targets have been selected, the CFMAIL tag will be skipped.
---
CFIF IsDefined('form.NOTIFY')
!--- Query to convert NOTIFY from the iMIS UserID to the UserName for a
more
user-friendly message in the email ---
CFLOOP INDEX=get_count
LIST=#form.notify#
DELIMITERS=,
/CFLOOP
CFOUTPUT
#get_count.RecordCount#
/CFOUTPUT
CFSET to=#get_count.RecordCount#)
CFLOOP INDEX=notify_emal
FROM=1
TO=#to#
CFQUERY NAME=notify_email DATASOURCE=iMIS Enterprise
SELECT Users.UserName
FROM Users Users
WHERE (Users.UserId='#form.NOTIFY#')
/cfquery
/CFLOOP
CFSET Dear=
CFLOOP QUERY=who_to_notify
CFSET Dear=ListAppend(Dear, '#who_to_notify.UserName#')
/CFLOOP
!--- Loops over CFMAIL tag so that multiple email recipients can be
inserted
---
CFLOOP INDEX=Notify_whom
LIST=Notify
DELIMITERS=, (closes at the end of the mail, I have not included
all of that...)
!--- Mails follow-up request/notification to all selected staff members,
based on iMIS UserID selected in the users/NOTIFY field of the form ---
!--- CFMAIL FROM=[EMAIL PROTECTED]
TO=#form.notify#@dineout.org
SUBJECT=Help Desk Request for Follow-up
SERVER=mail.dineout.org
Dear #Dear# !--- this doesn't work right, just yet -- but it will ---
@@@
Help!!
Special thanks in advance to anyone who has a better idea of how to do this
than I have had so far.
:-)
Oriole
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Date Difference
DateDiff(datepart, date1, date2) you can specify 'D', 'H', 'M', 'N', 'Q', 'S', 'W', 'WW', 'Y', '' as the datepart. Date1 from your table and date2 could be Now() or CreateODBCDateTime(date). This will return positive and negatives, depending on the scenario. Sincerely, Matthew M. Eschenbaum Allaire Certified Professional DevTech Inc. [EMAIL PROTECTED] 206.956.0888 www.dev-tech.com -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 5:52 AM To: CF-Talk Subject: Date Difference cf talk. I want to find out the difference in days between select getdate() - expdate which is a date stored in a table. Of course getdate pulls the date of the sql server. I need to do this in a select statement. Can anyone help me. I could also do this somewhere else but I need to be able to include it in my cfoutput query. If anyone knows the correct structure to make this happen in dts please let me know because I can run it in dts and have it update my table. Joshua Tipton ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Adding 90 minutes to Now()
'N', is the datepart for minutes.
Sincerely,
Matthew M. Eschenbaum
Allaire Certified Professional
DevTech Inc.
[EMAIL PROTECTED]
206.956.0888
www.dev-tech.com
-Original Message-
From: Ben Dyer [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 24, 2001 8:33 AM
To: CF-Talk
Subject: Adding 90 minutes to Now()
I'm not sure how to do this:
How do I find the value of ninety minutes from now?
#DateAdd('h',1.5,Now())#
Returns one hour from now (I'm guessing CF just rounds the non-integer down
to the next integer.
#DateAdd('m',90,Now())#
Returns ninety months from now (October 2008).
#DateAdd('mm',90,Now())#
Returns an error.
Any thoughts?
--Ben
-=-=-=-=-=-=-=-=-=-=-=-=-
Ben Dyer
Senior Internet Developer
Imaginuity Interactive
http://www.imaginuity.com
-=-=-=-=-=-=-=-=-=-=-=-=-
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Date Difference
Sorry, seems to be an hour delay. Sincerely, Matthew M. Eschenbaum Allaire Certified Professional DevTech Inc. [EMAIL PROTECTED] 206.956.0888 www.dev-tech.com -Original Message- From: Matt Eschenbaum [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 9:12 AM To: CF-Talk Subject: RE: Date Difference DateDiff(datepart, date1, date2) you can specify 'D', 'H', 'M', 'N', 'Q', 'S', 'W', 'WW', 'Y', '' as the datepart. Date1 from your table and date2 could be Now() or CreateODBCDateTime(date). This will return positive and negatives, depending on the scenario. Sincerely, Matthew M. Eschenbaum Allaire Certified Professional DevTech Inc. [EMAIL PROTECTED] 206.956.0888 www.dev-tech.com -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 5:52 AM To: CF-Talk Subject: Date Difference cf talk. I want to find out the difference in days between select getdate() - expdate which is a date stored in a table. Of course getdate pulls the date of the sql server. I need to do this in a select statement. Can anyone help me. I could also do this somewhere else but I need to be able to include it in my cfoutput query. If anyone knows the correct structure to make this happen in dts please let me know because I can run it in dts and have it update my table. Joshua Tipton ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL INSERTS - return ID
Anyone know a trick to return the ID of a record just Inserted into a table? Sincerely, Matthew M. Eschenbaum Allaire Certified Professional DevTech Inc. [EMAIL PROTECTED] 206.956.0888 www.dev-tech.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Advanced CF5 Bootcamp format
Get the entire URL! Sincerely, Matthew M. Eschenbaum Allaire Certified Professional DevTech Inc. [EMAIL PROTECTED] 206.956.0888 www.dev-tech.com -Original Message- From: David Sammons [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 19, 2001 9:15 AM To: CF-Talk Subject: RE: Advanced CF5 Bootcamp format I would definately be interested in the type of training that you're planning. Unfortuneately I received the following error when going to your site. Error Diagnostic Information An error occurred while evaluating the expression: Len(Trim(Attributes.EventID)) Error near line 35, column 6. Error resolving parameter ATTRIBUTES.EVENTID ColdFusion was unable to determine the value of the parameter. This problem is very likely due to the fact that either: You have misspelled the parameter name, or You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE tag. The error occurred while processing an element with a general identifier of (CFIF), occupying document position (35:1) to (35:36). Date/Time: 04/19/01 12:22:17 Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0) Remote Address: 209.160.216.31 Query String: fa=home.getinfoInfoType=itinera ds -Original Message- From: Adam Phillip Churvis [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 19, 2001 9:17 AM To: CF-Talk Subject: Advanced CF5 Bootcamp format I'm trying to make a decision about the Advanced Bootcamp for ColdFusion 5, Database, and Javascript, and I could really use some advice. I'm wondering if the format is right for people. Currently, I have it scheduled like this: -- 68 hours over six days, 12 hours per day M-F, 8 hours on Saturday -- All three meals catered -- $4,500 normally, $3,950 early registration But it's been suggested that a better format would be this: -- 60 hours over five days, 12 hours per day M-F -- Breakfast and lunch catered, dinner is on your own -- $3,500 normally, $2,950 early registration I really want to provide a truly advanced training course, and need to have plenty of time to thoroughly cover everything. The 12-hour-per-day format worked really well on the recent Database Development course we did in March, but I don't know if people are really wanting to go an extra two days like that. I would really appreciate any input you can give me. If you would, please look at the detailed itinerary at: http://www.coldfusiontraining.com/index.cfm?fa=home.getinfoInfoType=itinera ryTitleCode=advbootEventID=4 and let me know what you think people might like better. I get the feeling that I'm being a _wee_ bit too enthusiastic about the amount of training people want. :) Thanks in advance. Respectfully, Adam Phillip Churvis Productivity Enhancement, Inc. http://www.ColdFusionTraining.com http://www.ColdFusionSeminars.com http://www.CommerceBlocks.com E-mail: [EMAIL PROTECTED] Phone: 770-446-8866 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: URGENT - CFFTP
I've ran into this before in a past app. We found that we were timing out. There was never an error message thrown. I don't have my code in front of me, but I may be able to get a sample up tomorrow. Sincerely, Matthew M. Eschenbaum, ACP Systems Developer [EMAIL PROTECTED] ph: (206)956.0888 ext.24 fax:(206)956.4460 ___ DevTech, Inc.: Web Application Training Development www.dev-tech.com 600 Stewart Street 15th Floor Seattle, WA 98101 -Original Message- From: Andrew Tyrone [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 1:24 PM To: CF-Talk Subject: RE: URGENT - CFFTP -Original Message- From: Kevin Schmidt [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 4:27 PM To: CF-Talk Subject: Re: URGENT - CFFTP Robert I know your problem well. Make sure you specify the full path to the folder that you are uploading to IE C:\inetpub\wwwroot\yourfoldertouploadto\ Just using /yourfoldertouploadto doesn't work They don't specify that very well in the documentation Kevin How did he get a 0 byte file up there then, if the path was never specified right? - Original Message - From: "Robert Forsyth" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 1:26 PM Subject: URGENT - CFFTP After exhaustive searching through the forums, I finally got cfftp to upload a file to the server...but it is 0 bytes. Before I get the "standard" questions back: ** I can transfer files over using other FTP clients. Not a permissions issue ** Latest SP2 is installed, including the ftp.dll hotfix ** Used to work in 4.0. I'm running CF 4.51 on an NT 4.0 box. Any thoughts?? Robert Forsyth Robert, The only thing I can suggest is to try the code on another machine. I've had problems with CFFTP before on a client's servers. It stopped working altogether after Sprint did something to the Win2k Server machines, and we've never gotten it to work. The cfftp COM object is not registered and subsequent installs didn't fix the problem. Because I cannot get admin rights to these machines I cannot diagnose the problem properly, so we've implemented a workaround. The problem was actually that not even the directory was returned back. Everything was tried, and the code worked properly on other servers, but not on these 2. The last people I want poking around are Sprint employees (no offense to anyone). - Andy ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: validation
Steven has a simple and effective approach to your problem. You may also want, depending on your spec, want to allow the user to change current user information. This can be done in the same manner by giving them the option to update. Just another way to decide what the user is trying to accomplish. Sincerely, Matthew M. Eschenbaum, ACP Systems Developer [EMAIL PROTECTED] ph: (206)956.0888 ext.24 fax:(206)956.4460 ___ DevTech, Inc.: Web Application Training Development www.dev-tech.com 600 Stewart Street 15th Floor Seattle, WA 98101 -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Monday, April 16, 2001 1:27 PM To: CF-Talk Subject: validation i want to have a form where i can insert a new user into my database. and i have that form but i want to be able to validate it before it submits this new user into my database. i want to check to make sure the person doesnt already exist. (it wont be me entering the data, so i dont want to have user input errors if they dont search thru the drop down list before adding a new person...resulting in duplicate people). someone told me to look thru the custom tags and i did...but i really dont see what i am looking for. can anyone give me any ideas or some direction? thanks for all your help, bec. * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: (Easy SQL)
Here is a similar bit of code that I used to get records between certain dates. !--- Set Start and End Dates for the appointments --- cfset ODBCStartDate = "#DateFormat(Request.Week.Monday, '-MM-DD')#" " 07:00:00" cfset ODBCStartDate = CreateODBCDateTime(ODBCStartDate) cfset ODBCEndDate = "#DateFormat(Request.Week.Friday, '-MM-DD')#" " 18:00:00" cfset ODBCEndDate = CreateODBCDateTime(ODBCEndDate) cfloop query="qDisplayResources" CFQUERY NAME="qGetBookingAppoinments" DATASOURCE="#Request.DSN#" SELECT dbo.AppointmentType.ShortDescription, dbo.AppointmentType.AppointmentTypeID, dbo.AppointmentType.Background, dbo.AppointmentType.Foreground, dbo.Appointments.Client,dbo.Appointments.Date, dbo.Appointments.EmployeeID, dbo.Appointments.AppointmentID FROMdbo.Appointments, dbo.AppointmentType WHERE dbo.Appointments.EmployeeID = #EmployeeID# AND dbo.Appointments.AppointmentTypeID = dbo.AppointmentType.AppointmentTypeID AND (dbo.Appointments.Date = #ODBCStartDate#) AND (dbo.Appointments.Date = #ODBCEndDate#) ORDER BYDATE /CFQUERY You will notice that I added my own start time and end time. I have noticed some issues with the datepart function and thus did a work around with the above code. Sincerely, Matthew M. Eschenbaum, ACP Systems Developer [EMAIL PROTECTED] ph: (206)956.0888 ext.24 fax:(206)956.4460 ___ DevTech, Inc.: Web Application Training Development www.dev-tech.com 600 Stewart Street 15th Floor Seattle, WA 98101 -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Monday, April 16, 2001 2:00 PM To: CF-Talk Subject: RE: (Easy SQL) hmmm. I am getting a "'dateformat' not a recognized function" error. So I need the SQL statement similar to select datepart(,signup_datetime) as year, datepart(mm,signup_datetime) as month, datepart(d,signup_datetime) as day, count(userID) as NewMembers from membertable group by datepart(,signup_datetime), datepart(mm,signup_datetime), datepart(d,signup_datetime) I just can't believe this is the way you have to do it. Also: how would I reconnect date(year,month,day) as datetime field in the returned query results. Eric Note I am trying to limit the amount of record that are returned by using SQL aggregate functions. It seems like there should be a way to easily group by justthedatepartofadatetimefield but I can't find any syntax to do it. Eric From: "John Wilker" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: (Easy SQL) Date: Mon, 16 Apr 2001 13:25:32 -0700 dateformat(signup_datetime, "mm/dd/") Or use any mask you choose for the mm/dd/ part. Just run your query and grab the fields, then do the mask in CF when displaying the data. J. John Wilker Web Applications Consultant Allaire Certified ColdFusion Developer www.red-omega.com http://www.red-omega.com Pepsi's "Come Alive With the Pepsi Generation" translated into "Pepsi Brings Your Ancestors Back From the Grave" in Chinese. -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Monday, April 16, 2001 12:09 PM To: CF-Talk Subject: (Easy SQL) I have a member table which contains userid, signup_datetime I want to create a daily summary of registrations. select signup_datetime as justDatenotTime,count(userID) as NewMembers from membertable group by justDatenotTime == * == I know this has to be simple, but I can't find the syntax. How do I drop the time from a datetime field (SQL Server 7/2000/MSDE) so I can group by just the day? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
