on a particular
date."
Are there programs already written? He is willing ot pay a bit for something
nice.
Ann Harrell
Mind like a steel trap,
Rusty and illegal in 37 states.
__
This list and all House of Fusion resources
Thanks, Nathan. I didn't work for me, but that probably has more to do wi
th
the lateness of the hour than anything. I'll start fresh in the morning.
Ann Harrell
-Original Message-
From: Nathan Chen [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 17, 2002 11:01 PM
To: CF-Ta
I'm trying to figure a percentage in a query. I don't know if it's possible.
I would like to D_Loss / D_Goal and then output the percentage. I'm using an
Access database if that helps.
SELECT D_ID, D_Name, D_Loss, D_Goal
FROMdiet
ORDER BY diet.D_Name
I'm in the thinking stage of a small project for a group of friends. I want
to keep it fairly simple. It would be in Access
Person1
WeightLost (bar graph)
WeightGoal
Person2
WeightLost
WeightGoal
and I would like to display this in cfgraph. Is this possible?
Ann Harrell, USA
Sorry. My sattelite connection was being naughty.
Ann
> -Original Message-
> From: Ann Harrell [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 20, 2001 8:35 PM
> To: CF-Talk
> Subject: RE: How can I get a query's name?
>
>
> zxvczx
>
> &g
zxvczx
> -Original Message-
> From: Gregory Harris [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 20, 2001 5:24 PM
> To: CF-Talk
> Subject: RE: How can I get a query's name?
>
>
> Well, granted that a query name is the defining key for everything else
> about a query for example:
>
I live in a place that's about as mid-west as you can get. After this
warning I decided to go get a Pepsi refill at the local minimart. Lo and
behold.. lines for gas, 20 gallon limit.
Yes, I got gas. Thinking about going to the ATM since I used all my cash.
Ann
> -Original Message-
> F
I saw a guy doing something similar counting .gifs viewed but don't remember
the link. Perhaps he will pipe up later in the day.
Ann
> -Original Message-
> From: Will Swain [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 05, 2001 5:50 AM
> To: CF-Talk
> Subject: putting values fr
ate) AS StateCount
> FROM Wobinfo
> GROUP BY state
> HAVING COUNT(state) > 1
> ORDER BY COUNT(state)
>
>
>
> -Original Message-
> From: Ann Harrell [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 14, 2001 11:31 AM
> To: CF-Talk
> Subject: Access and CFG
I have this query that goes through the database and counts up the number of
people from each state and then I put it in a cfgraph. How do I get it to
only display states that are greater than 1?
SELECT state, COUNT (state) AS StateCount
FROM Wobinfo
GROUP BY state
ORDER BY COUNT(state)
Ann
And thank God that one didn't bounce
Ann
> -Original Message-
> From: Ann Harrell [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 09, 2001 10:25 AM
> To: CF-Talk
> Subject: RE: Zachary Bedell
>
>
>
> LOL! It doesn't pay to be a smart @ss d
LOL! It doesn't pay to be a smart @ss does it
Ann
> -Original Message-
> From: Will Swain [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 09, 2001 9:22 AM
> To: CF-Talk
> Subject: RE: Zachary Bedell
>
>
>
> Hey Bruce
>
> I got your message 3 times.
>
> are you spamming me? :
Stop the insanity!!
> -Original Message-
> From: 'Zachary S. Bedell' [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 08, 2001 1:54 PM
> To: CF-Talk
> Subject: RE: buying/leasing SQL
>
>
>
>
> > 1. is it possible to still buy SQL server 7 somehow?
> > does the new (per-cpu) pricin
When a female (professional or not) reaches a certain age,
chick sounds pretty darn good
Ann Harrell
> -Original Message-
> From: Christian Abad [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 07, 2001 1:28 PM
> To: CF-Talk
> Subject: RE: Cold Fusion Devel
hought:
1) Find ways to do everything in CodeCharge
2) Generate basic templates and tweak outside to your hearts content.
http://www.codecharge.com/?221
Ann Harrell
PS For one site I even pasted a CFgraph tag into codecharge and it works
fine after taking out a generated CFLoop.
>
Try news.codecharge.com / codecharge.discussion
As the user base increases the complex issues are being addressed. Also
visit www.gotocode.com and check out the discussion group there.
Ann Harrell
> -Original Message-
> From: Stephen Hait [mailto:[EMAIL PROTECTED]]
> Sen
How about - ASP, ColdFusion, JSP, PHP, Perl and ASP.NET/C# (Beta)
http://www.codecharge.com/?221
If you would like to see some templates generated by CodeCharge I would be
glad to share them with you.
Ann Harrell
> -Original Message-
> From: Parker, Kevin [mailto:[EMAIL PRO
Why just use PHP?
How about - ASP, ColdFusion, JSP, PHP, Perl and ASP.NET/C# (Beta)
http://www.codecharge.com/?221
Ann Harrell
> -Original Message-
> From: Angél Stewart [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, July 24, 2001 12:55 PM
> To: CF-Talk
> Subject
But the layoff rumor is true? Glad I got it in the first round while there
was still severance money
Ann
> -Original Message-
> From: Raymond Camden [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 09, 2001 3:05 PM
> To: CF-Talk
> Subject: RE: F***edcompany.com report
>
>
>
> > doh ..
ght. Send to
> [EMAIL PROTECTED]
>
> Jim
> - Original Message -
> From: "Ann Harrell" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Saturday, June 09, 2001 2:09 PM
> Subject: RE: CFgraph on O'Reilly Website 3
>
>
2001 12:12 PM
> To: CF-Talk
> Subject: Re: CFgraph on O'Reilly Website 3
>
>
> Thanks Ann
> I did try them and they are at:
> http://www.ngtcollege.org/graphtest3.cfm and
> don't work either.
>
> Jim
> - Original Message -
> From: "Ann Harrel
Jim did you try either of the corrected examples that I sent yesterday? Did
they work for you?
Ann
> -Original Message-
> From: Jim Watkins [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, June 09, 2001 8:25 AM
> To: CF-Talk
> Subject: CFgraph on O'Reilly Website 3
>
>
> Does anyone run CF 5
Yes, mine work.I just installed 5.0 this morning.
Ann
> -Original Message-
> From: Jim Watkins [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 08, 2001 11:49 AM
> To: CF-Talk
> Subject: Re: CF 5 Cfgraph problem More Info
>
>
> Tim,
>
> If you go to
> http://127.0.0.1/cfdocs/exampleapps/c
_Reference/Tags40.html) should be as follwos:
Ann Harrell
Harrell Computer Enterprises
Phone: 219.342.0618
eFax: 603.843.9212
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/
e, LastName, Birthday, Met, Email, Address1, City, State,
> Zip, Phone
> FROM wobinfo
> ORDER BY DATEPART("m", birthday), DATEPART("d", birthday);
>
> HTH
>
> Dan
>
> (note the datepart function is slightly different syntax in
> access and SQL
ast NameBirthday!
#FirstName##LastName##DateFormat(Birthday, "
dd, ")#
Ann Harrell
Harrell Computer Enterprises
Phone: 219.342.0618
eFax: 603.843.9212
~~
Structure your ColdFusion code
ge it to
>
> ORDER BY 2
>
> or
>
> ORDER BY Count(State)
>
> you should be OK.
>
>
>
>
>
>
> "Ann Harrell" <[EMAIL PROTECTED]> on 06-06-2001 02:26:33 PM
>
> Please respond to [EMAIL PROTECTED]
>
> To: CF-Talk <[
> 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 us
WOB\STATEDATA.CFM.
http://ann.bourbon.hoosierlink.net/Wob/StateData.cfm
SELECT state, COUNT (state) AS StateCount
FROM Wobinfo
GROUP BY state
Ann Harrell
Harrell Computer Enterprises
Phone: 219.342.0618
eFax: 603.843.9212
~~
Structure your ColdFusion c
>http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_
Version=ShockwaveFlash">
Ann Harrell
> -Original Message-
> From: Jim Watkins [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, June 03, 2001 9:54 PM
> To: CF-Talk
> Subject: Re: Resubmit: cfgraph problem
>
>
I went back to the beta forum to see if the information about the problem
was still there, but all the beta information is gone. Here is a working
example of a line graph with a fill though. If you want, I have other
examples I can send you.
Ann Harrell
> -Origi
Yes
> -Original Message-
> From: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 31, 2001 6:37 PM
> To: CF-Talk
> Subject: CF5 released - Macromedia?
>
>
> Has anyone actually received an email from MM to advise that CF5 has been
> released (after signing up on the CF ho
Woo-hoo!!
But,
It moved my code around to all one line instead of each item on a seperate
line.
Where is the option for gif in the drop down list?
Ann Harrell
> -Original Message-
> From: Garza, Jeff [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 29, 2001 12:14 PM
>
Hi Tony,
I'm using Access 2000 and I'll give this a try after I've had my morning
coffee (Pepsi)
Happy Holiday!
Ann Harrell
> -Original Message-
> From: Tony Gruen [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, May 26, 2001 12:27 AM
> To: CF-Talk
> Subject
I have a STATE column in a database. There are duplicate states. I want to
count the states 7 MA, 3 FL, 3 IN, ect) and eventually output them to a
CFGRAPH pie chart.
SELECT State
>From databasename
is as far as I've gotten.
Nightie.
Ann Harrell
Mind like a steel trap..
Rusty and illeg
> > No real need. CF code issues can be discussed right here on
> > > CF-Talk. Server
> > > issues like installing or the admin can go to CF-Server. The Partners,
> > > Community and other lists will take up the slack on other 5.0 issues.
> > >
> > >
&
**
> No real need. CF code issues can be discussed right here on
> CF-Talk. Server
> issues like installing or the admin can go to CF-Server. The Partners,
> Community and other lists will take up the slack on other 5.0 issues.
>
>
> > Will there be a CF 5.0 spe
Will there be a CF 5.0 specific list?
Ann Harrell
Mind like a steel trap..
Rusty and illegal in 37 states.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http
Thanks guys! One (or a combination) of your ideas worked. It's late.. maybe
I dreamed it up myself. NOT
Ann
> -Original Message-
> From: Ann Harrell [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 23, 2001 1:12 PM
> To: CF-Talk
> Subject: Count check boxes?
>
tName#
Ann Harrell
Mind like a steel trap..
Rusty and illegal in 37 states.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf
. Right now I search on "5" and I get May.. but I also get June 25 and
December 25
Here is the CFIF I use to search on "5". How do I change this to search for
"May"?
AND bGames.bDay
LIKE '%#Form.bDay#%'
Ann Harrell
Mind like a steel trap..
Rusty and illegal in 37 states.
Ann Harrell
Mind like a steel trap..
Rusty and illegal in 37 states.
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthor
This ended up working for me:
SELECT bEvent, bTime, bDay
FROM bGames
WHERE bDay > (Now())-1
Order BY bGames.bDay
Ann Harrell
Mind like a steel trap..
Rusty and illegal in 37 states.
> -Original Message-
> From: Semrau, Steven L Mr SRA
> [mailto:[EMAIL PROTEC
I have this query that shows all events in a database. What do I need to add
to not show older expired events? I just want to show events from 'today'
on.
SELECT bEvent, bTime, bDay
FROM bGames
Order BY bGames.bDay
Ann Harrell
Mind like a steel trap..
Rusty and illegal in
Morning Folks!
1) I would like to output Word docs using the OLE Object field in Office
2000. Is this possible?
2) Alternately if I can't do that, I have used a memo field. I lose all the
line and paragraph breaks for some reason. I can put them in by using
in the actual memo field. Is there an
back up now
-Original Message-
From: Ann Harrell [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 11, 2000 8:43 AM
To: '[EMAIL PROTECTED]'
Subject: RE: [ot]Ouch at allaire.com
Provider problems
-Original Message-
From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
Se
Provider problems
-Original Message-
From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 11, 2000 6:45 AM
To: [cftalk]
Subject: [ot]Ouch at allaire.com
All of www.allaire.com down
C:\>ping www.allaire.com
Pinging allaire.com [205.181.25.11] with 32 bytes of dat
http://www.allaire.com/Handlers/index.cfm?ID=16907&Method=Full
-Original Message-
From: stephen holland chang [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 03, 2000 12:17 PM
To: [EMAIL PROTECTED]
Subject: CFCONTENT problems with NT 4.0 SP6
Hey peeps
just wondering if anyone has a s
I just joined the list today. I would be interested in viewing the entire
thread if anyone has it.
Thanks!
Ann Harrell
Tech Support Engineer
-Original Message-
From: Zachary Bedell [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 28, 2000 10:18 AM
To: '[
49 matches
Mail list logo