RE: Order by: Access 2000 Question

Ann, Try SELECT state, COUNT (state) AS StateCount FROM Wobinfo GROUP BY state Order by COUNT(state) -Original Message- From: Ann Harrell [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 10:57 PM To: CF-Talk Subject: Order by: Access 2000 Question I have a graph that

RE: Slightly OT: Javascript Error - Confirmation Box

Issac, Not sure if this got wrapped in the email or if it is on two lines in your code, but I tried placing the confirm text all on one line and it worked fine. if (confirm('Are you sure you want to DELETE the Page you selected? This will also delete any SUB articles of this item!!')) {

RE: SQL Brain F@rt

Try SELECT State, Count(State) AS StateTotal FROM databasename GROUP BY State; -Original Message- From: Ann Harrell [mailto:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 10:24 PM To: CF-Talk Subject: SQL Brain F@rt I have a STATE column in a database. There are duplicate states. I

RE: A newbiw question to the masters

Greg, Try adding the query name to your cfoutput tag cfoutput query="blahblahblah1" cfif (#id1# is #ID#) AND (#password1# is #PASSWORD#) your id and password are correct CFELSE your id and password are not correct /cfif /cfoutput or add it

RE: make it simple to show the table.

Hosaka, You could try doing a group in your cfoutput to create the participant list. CFOUTPUT QUERY="test" GROUP="CourseID" #CourseID# !--- empty variable and create comma separated string --- CFSET FormatName="" CFOUTPUT CFSET FormatName=FormatName Name ","

RE: week ending

Joshua, How about: !--- Current Day --- CFSET TestDate="03/07/01" !--- Calculate number of days until end of week based on which day of the week it is --- CFSET NumOfDays=7-DayOfWeek(TestDate) !--- Add number of days until end of week and the current date --- CFSET EndOfWeek=NumOfDays