---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
---
-Original Message-
From: Jason Powers [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, November 02, 2000 12:16 PM
maybe you can shed some light got it to work by doing this: (there could be
an easier way)
This query finds all the distinct ssn's.
CFQUERY DATASOURCE="#DSN#" name="search"
SELECT DISTINCT ssn
FROM STUDENTS
WHERE AIRPORT_CODE = 'AAE'
AND testname = 'Driver
on AirportNet. Subscribe to our
Announcement list today: http://www.airportnet.org/email.htm
---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
---
-Original
---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
---
-Original Message-
From: Claremont, Timothy S [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, October 05, 2000
---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
---
-Original Message-
From: JustinMacCarthy [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, September 26, 2000 11:03 AM
To: CF
to our
Announcement list today: http://www.airportnet.org/email.htm
---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
---
-Original Message-
From: Aaron
on AirportNet. Subscribe to our
Announcement list today: http://www.airportnet.org/email.htm
---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
---
-Original
is your PUBLIC folder an FTP root folder? because they dont act the same
they will list files instead
of showing them.
Stay current with what's happening on AirportNet. Subscribe to our
Announcement list today: http://www.airportnet.org/email.htm
---
Kelly
Not looking to reinvent the wheel. Anyone know of any GOOD shopping cart
apps
out there? Cost is not an issue. I already have a database of products so i
need
an app that is completely customizable to work with an EXISTING database of
products. Suggestions?
Kelly
the query comes back with at least
ONE record you know the user id is taken if it comes back with ZERO
you do the insert.
Kelly
Stay current with what's happening on AirportNet. Subscribe to our
Announcement list today: http://www.airportnet.org/email.htm
---
ot;#dsn#" tableName="PenPals"
/CFIF
Stay current with what's happening on AirportNet. Subscribe to our
Announcement list today: http://www.airportnet.org/email.htm
---
Kelly Matthews
Internet Development Coordinator
AAAE
703.57
---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
---
-Original Message-
From: Steve Bernard [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, August 29, 2000 5:42 PM
To: [EMAIL
://www.airportnet.org/email.htm
---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
---
-Original Message-
From: Peter Tilbrook [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday
/email.htm
---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
---
--
Archives: http
---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
---
-Original Message-
From: Philip Meadows [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, August 23, 2000
thats unix based right? on NT.
Kelly
Stay current with what's happening on AirportNet. Subscribe to our
Announcement list today: http://www.airportnet.org/email.htm
---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http
---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
---
-Original Message-
From: JustinMacCarthy [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, August 23, 2000 11:21 AM
To: [EMAIL PROTECTED]
Subject
with what's happening on AirportNet. Subscribe to our
Announcement list today: http://www.airportnet.org/email.htm
---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
We have all the airport codes listed on our site you can find them here:
http://www.airportnet.org/depts/membership/arptmem2.htm
I could export this info for you let me know.
---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL
We have all the airport codes listed on our site you can find them here:
http://www.airportnet.org/depts/membership/arptmem2.htm
I could export this info for you let me know.
---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL
and is being
kicked
back as if its relaying denyed. Has anyone expereinced this? is there a
fix?
Kelly
---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
Is there a way to set how often CF checks the spool folder to send mail?
It seems to take up to 10 minutes at times didn't know if there was a way
to shorten that.
Kelly
---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED
Care to share HOW I change the setting I am using 4.5 and saw no setting
for it. :)
Kelly
---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
---
-Original
Thanks howie :)
---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
---
-Original Message-
From: Howie Hamlin [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday
yes that was the problem changed a setting in their relay restrictions
though and
it seems to be working fine now
---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
Ok I have 2 queries I am running the first is:
CFQUERY datasource="#DSN#" name="qgetsi"
SELECT *
FROM SelfInspection
WHERE 0=0
CFIF (IsDefined("form.date1")) AND (IsDefined("form.Date2"))
AND SI_dt BETWEEN #CREATEODBCDate(form.date1)# AND
#CREATEODBCDate(form.date2)#
/CFIF
/CFQUERY
This runs
ike.
From this date to this date (i pass the date range thats what determines how
many SI_opsrpt_id's will be included):
There were 7 instances of this Item.
???
Kelly
---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http:
Ok here are my current queries, thanks to Ben I got that part working.
Query 1:
I pass a date range:
CFQUERY datasource="#DSN#" name="qgetsi"
SELECT *
FROM SelfInspection
WHERE SI_dt BETWEEN #CREATEODBCDate(form.date1)# AND
#CREATEODBCDate(form.date2)#
/CFQUERY
That works fine. then I have this
---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
---
-Original Message-
From: ColdFusion [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, August 08, 2000 1:19 PM
To: [EMAIL PROTECTED]
Subject
where statement.
Any clues why the first continues to find NO RECORD??
---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
---
-Original Message-
From: Mike
If anyone
can recommend
a reliable CF/SQL hosting solution for no more than 75/95 a month please let
me know.
Kelly
-------
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airp
so will i :)
[EMAIL PROTECTED]
---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
---
-Original Message-
From: ColdFusionKid [SMTP:[EMAIL PROTECTED
There must arleady be a patch on a CF site i have it doesnt work yet on
another one it does. My guess is there is a patch available.
Kelly
---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
Ok let me see if i can explain this right. I have a table called Items.
It has Item_ID, Item_Name. Basically a lookup table.
I have another table for basic info entered on a form say its called
SI_Report
Now when someone comes to the form its populated with a few fields
that will be entered into
Thanks I will try that. For some reason I thought they would over write
eachother...
i'll let ya know if it works. :)
---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
GOt to have CF server and a web server running on that machine...
---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
---
-Original Message-
From
Ok I have 2 tables One called SI_Categories it has
SI_Category_ID and SI_Category_Name
The other called SI_Items it has
SI_Item_ID
SI_Item_NAme
SI_Category_ID
So basically SI_Items has the category ID for each item to show what
category it belongs to. All Good...
I want the output however to
WOrked like a charm thanks! I am still kinda news at doing anything beyond
the simple query.
WHen i look at what you did it makes total sense, just couldn't seem to get
the ole brain
to figure it out! :)
Looks like what you need to do is :
SELECT SI_Categories.SI_Category_ID,
I wondered if you might be able to help me figure something else out. Along
the same premise as the first email (at the end of this message)
Once someone has filled out a form and checked certain items, the items that
were checked get thrown into a 3rd table by ITEM ID.
SO when editing that form
Oh i got it:
cfoutput
#SI_Item_Name#input name="SI_Item_ID#si_Item_ID#" value="1"
type="checkbox" cfif ListFind(ValueList(QgetCheckedItems.SI_Item_ID),
SI_ITEM_id)CHECKED/CFIFBR
/cfoutput
-------
Kelly
qgetrunwaydetail.runway_ID),
qgetrunways.runway_id)#qgetrunways.runway#/CFIF
/td/tr trtd colspan=3
hr NOSHADE color=black/td/tr/CFOUTPUT/cfloop
---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
-
Yes Its my favorite too!
-Original Message-
From: Gregory Gooden (Annex) [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, July 25, 2000 5:02 PM
To: '[EMAIL PROTECTED]'
Subject: RE: SQL Books
SQL IN 10 MINUTES, by BEN FORTA
A VERY good book. :)
Gregory
Ok here is what i want to do, question is, is it possible.
I want to beable to have CF Write a file with a few images
and some text and save it as a MS WORD document instead of
a text document. Is there a way to do this?
Kelly
OK i have a appl. on one page i am doing 3 calculations here is what they
look like:
CFSET hold="#Evaluate(TimeFormat(FIS_FirstI, 'H:mm')-Timeformat(FIS_Block,
'H:mm'))#"
CFSET api="#Evaluate(FIS_Pax_Num/FIS_API_Num)#"
CFSET process="#Evaluate(TimeFormat(FIS_LastI,
'H:mm')-Timeformat(FIS_FirstI,
Thanks so much I will try that! :)
Kelly
---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
---
-Original Message-
From: Deanna L. Schneider [SMTP
worked like a charm my brain just wasnt able to think this morning, havent
had enough caffine... :)
---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
Ok I run these 2 queries:
CFQUERY datasource="#dsn#" name="qgetrunways"
SELECT *
FROM Runways
/CFQUERY
CFQUERY datasource="#dsn#" name="qgetrunwaydetail"
SELECT *
FROM Runway_Detail
WHERE O_Report_Num = #qgetops.O_Report_Num#
/CFQUERY
The first just pulls all the runways.
The 2nd pulls any
y="qgetrunways"
cfif ListFind(ValueList(qgetrunwaydetail.runway_ID), runway_id)
input type="checkbox" name="runway_id#runway_id#" CFIF runway_id IS
qgetrunwaydetail.runways.runway_idCHECKED/CFIF
value="#runway_id#"#runway# nbsp;nbsp;nbsp;/CFIF
/CFOUTPUT
Ok I figured it out DUH:
input type="checkbox" name="runway_id#runway_id#" cfif
ListFind(ValueList(qgetrunwaydetail.runway_ID), runway_id)CHECKED/CFIF
value="#runway_id#"#runway#
Thanks Dave!
-------
Kelly Matthews
Interne
Ok I have a CF Insert statement (its a long one) and then below the
statement I will paste the error i am getting.
Its appearing that there is a size limit ont he CF Insert statement? Is this
true? All of my inserts except the first
few are just 1 character.
CFQUERY datasource="#DSN#"
Sure enough, DOH! :)
---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
---
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent
Kelly
---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
---
-Original Message-
From: Adrian Cooper [SMTP:[EMAIL PROTECTED]]
Sent: Monday, June 26, 2000 3
Actually I just found the Fuse Ads info you can go here:
http://www.e-zonemedia.com/fuseads
It was VERY easy to install I use SQL 7 as the back end. We run banners
on every page of a very high traffic site and it seems to work well.
Kelly
---
Kelly Matthews
Ok here's the deal. I run a TON of Cold Fusion apps on our site, and running
SQL Server 7.0.
I am still learning SQL Server but here is whats happening. Over time the
RAM usage
for SQL Server goes up and up, and continues to until I stop and restart the
service then
it drops back down.
Ok can this be done. Say I have small database of news stories and
on the front page of the website we want to include say the first
sentence or 2 of the story which then links to the full story. How
do I, for the front page, limit it to only pull and display the first
so many characters of
Home site is great i made it the standard at our location.
Kelly
---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
---
-Original Message-
From
WDDX is a great way to do this type of thing, CF and WDDX work well together
and there
is a ton of info out there about it.
Kelly
-Original Message-
From: stäs [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, May 25, 2000 12:16 PM
To: [EMAIL PROTECTED]
Subject: serving data
Let's
anyone find it weird that i have a webdiva domain and my name is kelly
too...
ok i know its time to go home now :-P
http://www.webdiva.org
-Original Message-
From: [ W E B D i V A ] [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, May 25, 2000 3:04 PM
To: [EMAIL PROTECTED]
Subject:
we are using it where we are. but arent really doing it to the extent that
you want.
Whos product are you using? We are using the VPN product
that comes with Firewall1.
-Original Message-
From: Jason Egan [SMTP:[EMAIL PROTECTED]]
Sent: Friday, May 19, 2000 9:36 AM
To: Cf-Talk
to get leading zeros the data type can NOT be integer I had the same problem
had
to change the data type in the database to text in order for the zeros to
remain.
-Original Message-
From: Gordon Burns [SMTP:[EMAIL PROTECTED]]
Sent: Friday, May 19, 2000 1:58 PM
To: [EMAIL
probably even easier to just put it in an HTML (not CF) comment tag !-- --
not !--- ---
those will show up when viewing source.
-Original Message-
From: Howell, Katie [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, May 18, 2000 8:59 AM
To: [EMAIL PROTECTED]
Subject: RE: How not to
Well i know when ever we bring down our exchange server or make changes to
it
it cuts the connection between CF and the mail server and I have to RESTART
CF Services in order
for it to connect again. Try stopping and starting your CF services and then
send a test mail and see if it goes thru. The
H
Dick
At 2:23 PM -0400 5/16/2000, Kelly Matthews wrote:
Ok i figured it out, use the evaluate tag...
Kelly
-Original Message-
From: Kelly Matthews [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, May 16, 2000 2:11 PM
To: '[EMAIL PROTECTED]'
Subject: Am I missing
e evaluate...
Look at the CF math functions (Functions, not Tags!)
cfset A = 3
cfset B = 7
cfset C = A / B
cfoutput
br A / B = #C#
/cfoutput
HTH
Dick
At 2:23 PM -0400 5/16/2000, Kelly Matthews wrote:
Ok i figured it out, use the evaluate tag.
yes cold fusion was made to integrate with crystal reports very easily.
-Original Message-
From: sam komolafe [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, May 16, 2000 11:04 AM
To: [EMAIL PROTECTED]
Subject: LOOKING FOR A REPORTING TOOL FOR COLDFUSION
Hi,
Thus anyone know a
Ok I must be missing something I have not had to do this before
so never really had to worry about it. I want to output a report
that does a couple things 1 is it takes 2 fields (field a and field b)
and divides them. I know how to do it in the SQL statement but I dont want
to I would rather do
Ok i figured it out, use the evaluate tag...
Kelly
-Original Message-
From: Kelly Matthews [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, May 16, 2000 2:11 PM
To: '[EMAIL PROTECTED]'
Subject: Am I missing something? Calculations...
Ok I must be missing something I have not had
yes they are mine is WEBDIVA :)
-Original Message-
From: Stephanie Cunningham [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, May 11, 2000 3:40 PM
To: [EMAIL PROTECTED]
Subject: RE: Slightly OT: Lighten things up a little
i think that's the point -- license plates are unique. :)
I have a 2 degree in music business, go figure. Havent had a single problem
getting a technical job since i have the years of experience (instead of the
degree)
to back it up. Gotta love that.
-Original Message-
From: Sharon DiOrio [SMTP:[EMAIL PROTECTED]]
Sent: Monday, May 15, 2000
i worked government contracts for 4 years my 2 year music degree
was enough never had a problem getting a job where a Bachelors was required,
however
I did have to back up my qualifications with proof and experience which was
easy enough.
I think with Gov. Contracts your PAY may suffer a little
Are you putting single quotes around the dates in the WHERE CLAUSE?
If so try removing them it shouldnt need quotes I have run into this before.
Kelly
-Original Message-
From: Marcus [SMTP:[EMAIL PROTECTED]]
Sent: Monday, May 15, 2000 5:04 PM
To: [EMAIL PROTECTED]
Subject:
Ok I have a question. I wanted to password protect a section of our website
using cookies with
Cold Fusion. It works fine except for this. If someone links to a PDF file
(instead of an .htm file) it
doesnt even seem to read or care about the application.cfm file therefore
never throws them
to
then working its way
up to the main directory.
- Original Message -
From: "Kelly Matthews" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, May 09, 2000 10:27 AM
Subject: cookies
Ok I have a question. I wanted to password protect a section of our
I know this discussion has occurred before but I missed most of it.
I have a friend considering using media3 as a dedicated server (host)
any bad things about them I should know about? Pros? Cons?
Any advice would be appreciated.
Kelly
Every one this is a VISUAL BASIC VIRUS dont run it delete it Immediately.
Frank WHY did you send this??
Kelly
-Original Message-
From: Frank Kowalewicz [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, May 04, 2000 9:24 AM
To: Cold Fusion
Subject: ILOVEYOU
This is a multi-part
yeah we were hit big time! :(
-Original Message-
From: Tim Bahlke [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, May 04, 2000 5:19 PM
To: CFTalk
Subject: WOW what a day
It seems like everyone has been hit by the LoveBug. It's like warfare
keeping it away.
I hope everyone
If you dont set a cache within the query it shouldnt be cached. But also go
to the admin part of Cold Fusion find the Datasource for that database and
UNCHECK
maintain database connection in the cfsettings but trusted cache has nothing
to do
with it. As long as you dont put a CACHEDWITHIN or
well in the database if there is no image that field SHOULD then be empty.
So why not something like CFIF IMG_FIELD IS NOT "" Display
ImageCFELSEDisplay other image/CFIF
or something. We have a member database with images for some people
and thats how I do it.
Kelly
-Original Message-
Quick question. IN the help files it CLAIMS that
when cycle bat shuts CF off, if someone attempts to
hit a CF file before it has started again, then it will
automatically start cold fusion. I have NOT found this
to be the case, I receive errors until CF is restarted
at the SCHEDULED time a minute
Is there a way to set up an automatic way to start and stop the Cold Fusion
Service? I want to stop and start it a specific time each day.
Kelly
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
... Forta's book seems to cover these
items in a measly 5 pages :)
Marco
- Original Message -
From: "Kelly Matthews" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 19, 2000 12:36 AM
Subject: RE: CF Classes
Its good but I had already read the CF Constructio
register now, you wont get in for 2 months so that
would give you plenty of time to get up to speed. If you are a person that
learns and picks stuff up relatively easy then you should be ok
in the advanced class, in my opinion. :)
-Original Message-
From: Kelly Matthews [SMTP:[EMAIL
Yep there is all kinds of documentation on allaires site about that.
If you go to their knowledge base and search on cookies you will
see some suggestions. What I do is set a session throw
them to the front page (after log in) and then set the cookie there.
-Original Message-
From:
Its good but I had already read the CF Construction Kit book so the class
covered about 80% of what I already knew, it was a good refresher. However,
the Advanced class, which I just took was extremely good. It used to be 2
days but they have stretched it out to 3, i learned quite a bit.
Kelly
: Kelly Matthews [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: "'[EMAIL PROTECTED] '" [EMAIL PROTECTED]
Subject: Am I Missing Something?
Date: Thu, 13 Apr 2000 21:26:31 -0400
Ok I am somewhat new to CF but something doesn't seem to be right.
I have a section of our site that
Here is one way if you log off have it go to a page that has this statement:
CFSET tmp = StructClear(SESSION)
CFLOCATION URL="wherever.cfm"
Works for me.
Kelly
-Original Message-
From: Brian Ingram [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, April 13, 2000 1:19 PM
To: CFTalk
I would suggest hosting at a FIRST Teir provider (someone with a direct
connection
to MAEEAST or MAEWEST anyone in the Tysons Herndon Area that connects
straight into MAEEAST is going to be pretty quick and reliable assuming they
have
redundancy built in. CAIS, PSINET, UUNET etc but you will pay
Ok I am somewhat new to CF but something doesn't seem to be right.
I have a section of our site that is secure, for members only. I
have written the app to write a cookie so they don't have to login in the
future. That part works fine.
Now I just wanted to see what happened if someone had
201 - 288 of 288 matches
Mail list logo