Help with OUTPUT of some Querys

[Kelly Matthews]

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 look like so.

Category1:
Item1
Item2
Item 3

Category2:
Item4
Item5
Item6

Category3:
Item7
Item8
Item9

I seem to be having trouble. Obviously something has to loop and maybe even
group (ooo a rhyme)
because once I pull all items I have the Category ID for each but need to go
back to the category table
to find out what that category actually is. Also need the categories
displayed BY NAME (from category table)
with the items for each category (item table) listed under the appropriate
Category. i am srue I am
missing something little. Any suggestions???

Should I do 2 separate queries or a join? I have tried quite a few things
and can't get it to work.
Kelly
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Help with OUTPUT of some Querys

[Kelly Matthews]

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, SI_Categories.SI_Category_Name,
> SI_Items.SI_Item_ID,
>  SI_Items.SI_Item_Name
> FROM SI_Categories, SI_Items
> WHERE SI_Categories.SI_CategoryID = SI_Items.SI_Category_ID
> ORDER BY SI_Category_Name
> 
> Then you need to do a nested CFOUTPUT using the GROUP attribute
> 
> 
>   #SI_Catgeory_Name#
>   
>   #SI_Item_Name#
>   
> 
> 
> This way you have one hit on the database, the database deals with the
> ordering of the data and you get your sets of categories with their items.
> 
> HTH
> 
> Regards
> 
> Stephen
> 
> 
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Help with OUTPUT of some MORE Querys

[Kelly Matthews]

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 I am trying to get it where all checked items will
appear CHECKED On the form. So far I am doing this.

(this queries to pull up a SPECIFIC report)

SELECT *
FROM SelfInspection
WHERE SI_OPSRPT_ID = #url.SI_OPSRPT_ID#


Then down in the output I have what Stephen showed me earlier to get the
categories and items to lay out properly:

 SELECT 
SI_Categories.SI_Category_ID, 
SI_Categories.SI_Category,
SI_Items.SI_Item_ID,
SI_Items.SI_Item_Name
FROM 
SI_Categories, 
SI_Items
WHERE 
SI_Categories.SI_Category_ID = SI_Items.SI_Category_ID
ORDER BY SI_Categories.SI_Category_ID


The original output for a NEW form would be:


#SI_Category#


#SI_Item_Name#



However on the edit form I want that same output as above but another query
becomes involved to see which
items were checked upon the entry form so they will be checked when someone
pulls up the EDIT form.
So a query such as the following needs to be added:

SELECT SI_Item_ID
FROM SI_Items2
WHERE SI_OpsRpt_ID = #url.si_opsrpt_ID#

This query is correct when I ran it it pulled the 2 records it should have.
However in the output now I need the check box to be checked if it shows up
in that query, I tried the following but it didnt work:



#SI_Category#


#SI_Item_Name#CHECKED>



It throws no errors just doesn't check ANY boxes and all the queries are
definetly running correctly so its something in the
way I am doing the output. 
Any suggestions??
Kelly



> -Original Message-
> From: Stephen Moretti [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, August 01, 2000 11:24 AM
> To:   [EMAIL PROTECTED]
> Subject:  RE: Help with OUTPUT of some Querys
> 
> Hi Kelly,
> 
> >
> > 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 look like so.
> >
> [snip]
> > I seem to be having trouble. Obviously something has to loop and
> > maybe even
> > group (ooo a rhyme)
> > because once I pull all items I have the Category ID for each but
> > need to go
> > back to the category table
> > to find out what that category actually is. Also need the categories
> > displayed BY NAME (from category table)
> > with the items for each category (item table) listed under the
> appropriate
> > Category. i am srue I am
> > missing something little. Any suggestions???
> >
> > Should I do 2 separate queries or a join? I have tried quite a few
> things
> > and can't get it to work.
> 
> 
> Looks like what you need to do is :
> 
> SELECT SI_Categories.SI_Category_ID, SI_Categories.SI_Category_Name,
> SI_Items.SI_Item_ID,
>  SI_Items.SI_Item_Name
> FROM SI_Categories, SI_Items
> WHERE SI_Categories.SI_CategoryID = SI_Items.SI_Category_ID
> ORDER BY SI_Category_Name
> 
> Then you need to do a nested CFOUTPUT using the GROUP attribute
> 
> 
>   #SI_Catgeory_Name#
>   
>   #SI_Item_Name#
>   
> 
> 
> This way you have one hit on the database, the database deals with the
> ordering of the data and you get your sets of categories with their items.
> 
> HTH
> 
> Regards
> 
> Stephen
> 
> 
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Help with OUTPUT of some MORE Querys - figured it out...

[Kelly Matthews]

Oh i got it:

#SI_Item_Name#CHECKED>


---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
---

> -Original Message-
> From: Kelly Matthews 
> Sent: Tuesday, August 01, 2000 4:01 PM
> To:   'Stephen Moretti'; [EMAIL PROTECTED]
> Subject:  Help with OUTPUT of some MORE Querys
> 
> 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 I am trying to get it where all checked items
> will appear CHECKED On the form. So far I am doing this.
> 
> (this queries to pull up a SPECIFIC report)
> 
> SELECT *
> FROM SelfInspection
> WHERE SI_OPSRPT_ID = #url.SI_OPSRPT_ID#
> 
> 
> Then down in the output I have what Stephen showed me earlier to get the
> categories and items to lay out properly:
> 
>  SELECT 
>   SI_Categories.SI_Category_ID, 
>   SI_Categories.SI_Category,
>   SI_Items.SI_Item_ID,
>   SI_Items.SI_Item_Name
> FROM 
>   SI_Categories, 
>   SI_Items
> WHERE 
>   SI_Categories.SI_Category_ID = SI_Items.SI_Category_ID
> ORDER BY SI_Categories.SI_Category_ID
> 
> 
> The original output for a NEW form would be:
> 
> 
> #SI_Category#
> 
>   
>   #SI_Item_Name# type="checkbox">
>   
> 
> 
> However on the edit form I want that same output as above but another
> query becomes involved to see which
> items were checked upon the entry form so they will be checked when
> someone pulls up the EDIT form.
> So a query such as the following needs to be added:
> 
> SELECT SI_Item_ID
> FROM SI_Items2
> WHERE SI_OpsRpt_ID = #url.si_opsrpt_ID#
> 
> This query is correct when I ran it it pulled the 2 records it should
> have.
> However in the output now I need the check box to be checked if it shows
> up in that query, I tried the following but it didnt work:
> 
> 
> 
> #SI_Category#
> 
>   
>   #SI_Item_Name# type="checkbox"  "QgetCheckedItems.SI_Item_ID">CHECKED>
>   
> 
> 
> It throws no errors just doesn't check ANY boxes and all the queries are
> definetly running correctly so its something in the
> way I am doing the output. 
> Any suggestions??
> Kelly
> 
> 
> 
>   -Original Message-
>   From:   Stephen Moretti [SMTP:[EMAIL PROTECTED]]
>   Sent:   Tuesday, August 01, 2000 11:24 AM
>   To: [EMAIL PROTECTED]
>   Subject:RE: Help with OUTPUT of some Querys
> 
>   Hi Kelly,
> 
>   >
>   > 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 look like so.
>   >
>   [snip]
>   > I seem to be having trouble. Obviously something has to loop and
>   > maybe even
>   > group (ooo a rhyme)
>   > because once I pull all items I have the Category ID for each but
>   > need to go
>   > back to the category table
>   > to find out what that category actually is. Also need the
> categories
>   > displayed BY NAME (from category table)
>   > with the items for each category (item table) listed under the
> appropriate
>   > Category. i am srue I am
>   > missing something little. Any suggestions???
>   >
>   > Should I do 2 separate queries or a join? I have tried quite a few
> things
>   > and can't get it to work.
> 
> 
>   Looks like what you need to do is :
> 
>   SELECT SI_Categories.SI_Category_ID, SI_Categories.SI_Category_Name,
>   SI_Items.SI_Item_ID,
>SI_Items.SI_Item_Name
>   FROM SI_Categories, SI_Items
>   WHERE SI_Categories.SI_CategoryID = SI_Items.SI_Category_ID
>   ORDER BY SI_Category_Name
> 
>   Then you need to do a nested CFOUTPUT using the GROUP attribute
> 
>   
>   #SI_Catgeory_Name#
>   
>   #SI_Item_Name#
>   
>   
> 
>   This way you have one hit on the database, the database deals with
> the
>   ordering of the data and you get your sets of categories with their
> items.
> 
>   HTH
> 
>   Regards
> 
>   Stephen
> 
> 
> 
>   
> --

Tricky one for you...

[Kelly Matthews]

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 the SI_Report like name, time, date etc. Then all
the items (33 of them right now but that will changed per customer they
define
them, themselves) are laid out on the form as check boxes.  When they fill
out the form they CHECK which ever items apply. So they may check ONE
they may check 10. Here is where i get confused.  Each item is laid out
as such

Item Name
These are all built on the fly from the item table.  So first I can't NAME
THEM ALL
Item_ID because then the last one checked over rides all the others.
So I named them name="Item_ID#Item_ID#" so they would be unique like
ITEM_ID1 ITEM_ID2 ITEM_ID3. Maybe this isnt the way. So there is a third
table that takes the REPORT ID from SI_Report and the ITEM_ID from Items and
puts them in SI_Items So say the report number is 3 and items 7, 10 and 20
were
chosen there would be 3 entries in SI_Items
3 7
3 10
3 20
No problem. The problem is that in order to insert these variables into
SI_ITEMS I have
to do a check 33 times to see if the item_id exists. Example 
insert it into the table. And so on.  First there MUST be another way to do
this
without having to run it 33 times. Or at least to prevent me from typing it
33 times. Like
I tried running a record count on the items table to see how many items and
then tried
to run the query upping the number each time for the amount of items i
found. But still
that seems like a bad way to do it.  I am really new to anything beyond
basic querying so
there is probably an easy way maybe I am just missing.  Any suggestions?? If
i havent
been clear or you have questions let me know.
Kelly

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Tricky one for you...

[Kelly Matthews]

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
---

> -Original Message-
> From: Zachary Bedell [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, August 02, 2000 10:08 AM
> To:   '[EMAIL PROTECTED]'
> Subject:  RE: Tricky one for you...
> 
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
> 
> > Item Name
> > These are all built on the fly from the item table.  So first 
> > I can't NAME
> > THEM ALL
> > Item_ID because then the last one checked over rides all the
> > others.  
> 
> Nope.  You should be able to name them all Item_ID.  Make the VALUE
> of each check box the particular Item_ID.  Then on the template that
> receives the form post, Item_ID will be a nice comma delimited list
> of all the ItemID's that were checked.
> 
> The code in your receiving template would look something like:
> 
> 
>   
>   INSERT INTO SI_ITEMS
>   (Report_ID, Item_ID)
>   VALUES(#Report_ID#, #TheItem#)
>   
> 
> 
> Hope that helps.
> 
> Best regards,
> Zac Bedell
> 
> -BEGIN PGP SIGNATURE-
> Version: PGPfreeware 6.5.3 for non-commercial use <http://www.pgp.com>
> Comment: Please use PGP!!!
> 
> iQA/AwUBOYgrUQraVoMWBwRBEQJXigCg/rIPuGHHWZ7XEoM5pb/i16gZ/DIAn0Je
> 9bx94RpBJt5ooBUKrKjC6bQ0
> =jVtn
> -END PGP SIGNATURE-
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Tricky one for you...

[Kelly Matthews]

That worked like a charm, just have never run into this before so had no
idea it could be done. Thanks
a bunch Zac!
Kelly

> -Original Message-
> From: Zachary Bedell [SMTP:   
> Sent: Wednesday, August 02, 2000 10:08 AM
> To:   '[EMAIL PROTECTED]'
> Subject:  RE: Tricky one for you...
> 
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
> 
> > Item Name
> > These are all built on the fly from the item table.  So first 
> > I can't NAME
> > THEM ALL
> > Item_ID because then the last one checked over rides all the
> > others.  
> 
> Nope.  You should be able to name them all Item_ID.  Make the VALUE
> of each check box the particular Item_ID.  Then on the template that
> receives the form post, Item_ID will be a nice comma delimited list
> of all the ItemID's that were checked.
> 
> The code in your receiving template would look something like:
> 
> 
>   
>   INSERT INTO SI_ITEMS
>   (Report_ID, Item_ID)
>   VALUES(#Report_ID#, #TheItem#)
>   
> 
> 
> Hope that helps.
> 
> Best regards,
> Zac Bedell
> 
> -BEGIN PGP SIGNATURE-
> Version: PGPfreeware 6.5.3 for non-commercial use 
> Comment: Please use PGP!!!
> 
> iQA/AwUBOYgrUQraVoMWBwRBEQJXigCg/rIPuGHHWZ7XEoM5pb/i16gZ/DIAn0Je
> 9bx94RpBJt5ooBUKrKjC6bQ0
> =jVtn
> -END PGP SIGNATURE-
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: HTTP Error 500

[Kelly Matthews]

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: Chapman, Katrina [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, August 02, 2000 12:42 PM
> To:   '[EMAIL PROTECTED]'
> Subject:  HTTP Error 500
> 
> I'm getting error's trying to get CF pages to run on my local machine.  I
> get this error, 
> The page cannot be displayed
> There is a problem with the page you are trying to reach and it cannot be
> displayed.
> Every page I attempt to access has this problem.  Even the docs and cfide.
> Anyone have any ideas?
> TIA,
> --K
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Integrating with Flash

[Kelly Matthews]

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]]
> Sent: Thursday, August 03, 2000 11:38 AM
> To:   [EMAIL PROTECTED]
> Subject:  Re: Integrating with Flash
> 
> And I'd like a copy too, if it's not too much trouble.  =)
> 
> Cody
> [EMAIL PROTECTED]
> 
> - Original Message -
> From: "Kevin Queen" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, August 03, 2000 8:04 AM
> Subject: RE: Integrating with Flash
> 
> 
> > Same here, if you don't mind.
> >
> > TIA,
> > -Kevin
> >
> > -Original Message-
> > From: Norman Elton [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, August 03, 2000 9:00 AM
> > To: [EMAIL PROTECTED]
> > Subject: RE: Integrating with Flash
> >
> >
> > I'll take a copy of your files too :). Thanks!
> >
> > Norman
> >
> > On Thu, 3 Aug 2000, Reynolds, Adam wrote:
> >
> > > Could you copy me in on this. I would be very interested.
> > >
> > > > --
> > > > From: Sean Renet[SMTP:[EMAIL PROTECTED]]
> > > > Sent: 03 August 2000 12:24
> > > > To: [EMAIL PROTECTED]
> > > > Subject: Re: Integrating with Flash
> > > >
> > > > I have a day left of crazy left, then I will email you an fla file
> and
> > cf
> > > > template off list.
> > > > - Original Message -
> > > > From: "Rich Wild" <[EMAIL PROTECTED]>
> > > > To: <[EMAIL PROTECTED]>
> > > > Sent: Thursday, August 03, 2000 1:53 AM
> > > > Subject: RE: Integrating with Flash
> > > >
> > > >
> > > > > Yeah - I wasn't talking semantics though, I am genuinely
> interested
> in
> > > > how
> > > > > you pull those variables out - where does the LoadVariables pull
> the
> > CF
> > > > > variables from?
> > > > >
> > > > > I've used URL variables before fine - but limited as I said, due
> to
> > the
> > > > max
> > > > > length of a URL string
> > > > >
> > > > > I've used textfiles also - getting CF to create a textfile with
> the
> > > > > variables written into it:
> > > > >
> > > > > eg: variables.txt
> > > > > **
> > > > >
> > > > > var1 = Hello
> > > > > var2 = Cheese
> > > > > var3 = red hot poker
> > > > >
> > > > > **
> > > > >
> > > > > And Then Flash LoadVariables from variables.txt
> > > > >
> > > > > Now I *know* that this is brutish and poor. Must be. Makes me
> wince
> > just
> > > > > looking at it.
> > > > >
> > > > > How specifically are you handling it? I long for a better way...
> > > > >
> > > > > --
> > > > > Rich Wild
> > > > > Senior Web Designer
> > > > >
> > > > > ---
> > > > > e-mango.com ltd  Tel: 01202 587 400
> > > > > Lansdowne Place  Fax: 01202 587 401
> > > > > 17 Holdenhurst Road
> > > > > Bournemouth   Mailto:[EMAIL PROTECTED]
> > > > > BH8 8EW, UK  http://www.e-mango.com
> > > > > ---
> > > > > This message may contain information which is legally
> > > > > privileged and/or confidential.  If you are not the
> > > > > intended recipient, you are hereby notified that any
> > > > > unauthorised disclosure, copying, distribution or use
> > > > > of this information is strictly prohibited. Such
> > > > > notification notwithstanding, any comments, opinions,
> > > > > information or conclusions expressed in this message
> > > > > are those of the originator, not of e-mango.com ltd,
> > > > > unless otherwise explicitly and independently indicated
> > > > > by an authorised representative of e-mango.com ltd.
> > > &

RE: Allaire security problem - anyone know solution?

[Kelly Matthews]

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
---

> -Original Message-
> From: Dave Wilson [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, August 03, 2000 12:27 PM
> To:   [EMAIL PROTECTED]
> Subject:  Allaire security problem - anyone know solution?
> 
> Hi all,
> 
> One of my hosting clients has just made me aware of this major security
> problem and I'm wondering if anyone knows how to eliminate it?
> 
> Try calling the application.cfm template on any CF site with +.htr
> appended
> to the end of the url. You'll first see a blank page. Now hit
> refresh/reload
> and you'll see the full code of said application.cfm
> 
> e.g. http://www.support.alllaire.com/application.cfm+.htr
> 
> Can someone please tell me there is a patch for this. It seems to happen
> on
> all CFserver versions 4.x + running IS4.0 with Service pack 5
> 
> Dave
> 
> Dave Wilson
> Internet Technology Manager,
> BizNet Solutions
> 
> 
> Co-Founder CFUG Ireland
> http://www.cfug.ie
> 
> 224, Lisburn Road
> Belfast BT9 6GE
> 
> Tel: 02890 225 776
> Fax: 02890 223 223
> web: http://www.biznet-solutions.com
> 
> email: [EMAIL PROTECTED]
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Hosting Solutions???

[Kelly Matthews]

Ok I am looking for a GOOD hosting solution that will allow me to use CF 4.5
and SQL Server 7.0.
I dont want a dedicated server, just shared server if possible, I am with
Intermedia right now and for
the last week their service has SUCKED because they 1. put too many people
on each server
2. dont monitor sites for BAD CODE that could bring the server to a
screeching halt so in the last week
my site has been up and down DAILY. Which is UNACCEPTABLE, they just say
"well there is nothing
we can do about it" Bull CRAP! 

Anyway Media3 I was going to go with until they too FOREVER to set up my
account, maybe they were
just having a bad day? So if you use them has your experience been good? The
things I am looking for
are reliablity and support that is EASY to contact. For instance intermedia
you can ONLY CONTACT
by email which is RIDICULOUS when hosting BUSINESS applications.  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.airportnet.org
---

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Help with CFQUERY/Update

[Kelly Matthews]

Ok i am very confused. I am trying to update one field with the following
statement:

Update Rates_And_Charges
SET passengers_enplaned_domestic = #form.passengers_enplaned_domestic#
Where Member_number = '#form.Member_Number#'
 
It returns back the following:
update1 (Records=0, Time=62ms) 
SQL = Update Rates_And_Charges 
SET passengers_enplaned_domestic = 456466 
Where Member_number = '00' 

Saying it found ZERO records to update. However if i run a similar query:

SELECT passengers_enplaned_domestic
FROM Rates_And_Charges
WHERE Member_number = '#form.Member_number#'
  
edit (Records=1, Time=0ms) 
SQL = SELECT passengers_enplaned_domestic 
FROM Rates_And_Charges 
WHERE Member_number = '00' 
Its finds one records with the SAME EXACT 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 Sullivan [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, August 07, 2000 11:39 AM
> To:   '[EMAIL PROTECTED]'
> Subject:  RE: CFFILE problem on linux
> 
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
> 
> Who is your httpd running as and does it have access to the file
> system?
> Mike
> 
> - -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Sunday, August 06, 2000 10:36 PM
> To:   [EMAIL PROTECTED]
> Subject:  CFFILE problem on linux
> 
> 
> 
> Hi there,
> 
> I'm trying to get CFFILE working on a linux box. ColdFusion is
> running as a user
> called coldfusion which has group write privileges to my HTML
> directory. If I
> log in as the coldfusion user I can create directories and files in
> the HTML
> directory OK.
> 
> However, when I try to do a  into that same
> directory I
> get a permissions error.
> 
> I am not running advanced security.
> 
> What is going on?
> 
> - 
> Rob Keniger
> 
> 
> - --
> - 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_tal
> k or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.
> 
> -BEGIN PGP SIGNATURE-
> Version: PGPfreeware 6.5.3 for non-commercial use <http://www.pgp.com>
> 
> iQA/AwUBOY7YVXYFmKomMlANEQJ1xgCaA52FfQ0evBi9hlQbM6oTtod3RCcAnRso
> kMZdsWNAOplgtcqcy7F98wXY
> =ihDF
> -END PGP SIGNATURE-
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Hosting Solutions???

[Kelly Matthews]

I really am not too hot on them they offer ABSOLUTELY no info on their
website, which
is a good reflection  

---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
---

> -Original Message-
> From: Mark Shay [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, August 04, 2000 4:30 PM
> To:   [EMAIL PROTECTED]
> Subject:  Re: Hosting Solutions???
> 
> AlexandriaInternet is a good web host.  Very amenable, good rates, and has
> the apps you are looking for.
> 
> http://alexandriainternet.com
> 
> Mark
> 
> 
> - Original Message -
> From: Kelly Matthews <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, August 04, 2000 2:34 PM
> Subject: Hosting Solutions???
> 
> 
> > Ok I am looking for a GOOD hosting solution that will allow me to use CF
> 4.5
> > and SQL Server 7.0.
> > I dont want a dedicated server, just shared server if possible, I am
> with
> > Intermedia right now and for
> > the last week their service has SUCKED because they 1. put too many
> people
> > on each server
> > 2. dont monitor sites for BAD CODE that could bring the server to a
> > screeching halt so in the last week
> > my site has been up and down DAILY. Which is UNACCEPTABLE, they just say
> > "well there is nothing
> > we can do about it" Bull CRAP!
> >
> > Anyway Media3 I was going to go with until they too FOREVER to set up my
> > account, maybe they were
> > just having a bad day? So if you use them has your experience been good?
> The
> > things I am looking for
> > are reliablity and support that is EASY to contact. For instance
> intermedia
> > you can ONLY CONTACT
> > by email which is RIDICULOUS when hosting BUSINESS applications.  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.airportnet.org
> > ---
> >
> >
> --
> 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: I need a host. Intermedia testimonials

[Kelly Matthews]

I disagree i just left intermedia 1. because they took over an hour 5 times
in a row
to get back to me when my site was down. 2. their server monitoring seems
very poor.
The server MY SITE was on went down multiple times a day. i would NOT
recommend them
Kelly

---
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:  RE: I need a host. Intermedia testimonials
> 
> I use Intermedia and they are incredible.  They answer support emails
> within
> minutes.  They're hostpilot control panel is great.  They're real nice
> guys,
> always looking to help out.  I'd give them a try.
> 
> 
> 
> -Original Message-
> From: paul smith [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 08, 2000 12:56 AM
> To: [EMAIL PROTECTED]
> Subject: Re: I need a host. Intermedia testimonials
> 
> 
> Check out http://www.shanje.com/
> 
> best,  paul
> 
> At 09:04 PM 8/7/00 -0500, you wrote:
> >I need a host. and I gather from cftalk that Intermedia is the winner. I
> am
> >interested in hearing testimonials or other alternatives.
> >
> >1 client, 10 domains and growing.
> >
> >Thanks
> >Eric Dawson
> 
> --
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

QUERY QUESTION

[Kelly Matthews]

Ok I have 2 queries I am running the first is:


SELECT *
FROM SelfInspection
WHERE 0=0

AND SI_dt BETWEEN #CREATEODBCDate(form.date1)# AND
#CREATEODBCDate(form.date2)#


This runs fine...

Next one is:



SELECT *
FROM SI_ITEMS2
WHERE SI_ITEM_ID = #TheITem#
AND SI_Opsrpt_ID = #qgetsi.SI_Opsrpt_ID#



This seems to run fine but comes back with ONE record when it should come
back with THREE:

Results:
qgetitems (Records=1, Time=0ms) 
SQL = SELECT * FROM SI_ITEMS2 
WHERE SI_ITEM_ID = 19 AND 
SI_Opsrpt_ID = 5 
SELECT * FROM SI_ITEMS2 
WHERE SI_ITEM_ID = 13 
AND SI_Opsrpt_ID = 5 
SELECT * FROM 
SI_ITEMS2 
WHERE SI_ITEM_ID = 15 
AND SI_Opsrpt_ID = 5 

It only appears to bring back ONE record however it should bring back 3
because
ID 5 is in there with item id 19,15 and 13 but it seems to only pick up and
display the first one
Do I need to change my query
Kelly
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: QUERY QUESTION

[Kelly Matthews]

Ok here is my perdicament. Yours worked fine

SELECT *
FROM SI_ITEMS2
WHERE SI_ITEM_ID IN (#SI_Item_ID#)
AND SI_Opsrpt_ID = #qgetsi.SI_Opsrpt_ID#

however what I am really trying to do is get a count.
So say there are 3 SI_OPSRPT_ID's
and i pass 5 item_ids i want to do a count of how many times
each ITEM shows up within those 3 reports.
I'm still somewhat new at getting things to query and display properly.
would want the output to be something like.

>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://www.airportnet.org
---

> -Original Message-
> From: Ben Forta [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, August 10, 2000 1:45 PM
> To:   [EMAIL PROTECTED]
> Subject:  RE: QUERY QUESTION
> 
> Robert, actually, that would not work. As the same query name is used each
> time each subsequent query would overwrite the prior one. If you ever need
> to execute queries in a loop like that you must be sure to
> programmatically
> adjust the query name as well (perhaps by using a counter).
> 
> --- Ben
> 
> 
> -Original Message-
> From: Hinojosa, Robert [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 10, 2000 1:36 PM
> To: '[EMAIL PROTECTED]'
> Subject: RE: QUERY QUESTION
> 
> 
> Put the loop  outside the query tag.
> 
> 
>   
>   SELECT *
>   FROM SI_ITEMS2
>   WHERE SI_ITEM_ID = #TheITem#
>   AND SI_Opsrpt_ID = #qgetsi.SI_Opsrpt_ID#
>   
> 
> 
> 
> Robert Hinojosa
> WebDeveloper
> 512.912.3775
> [EMAIL PROTECTED]
> www.cirrus.com
> 
> -Original Message-
> From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 10, 2000 12:14 PM
> To: '[EMAIL PROTECTED]'
> Subject: QUERY QUESTION
> 
> 
> Ok I have 2 queries I am running the first is:
> 
> 
> SELECT *
> FROM SelfInspection
> WHERE 0=0
> 
> AND SI_dt BETWEEN #CREATEODBCDate(form.date1)# AND
> #CREATEODBCDate(form.date2)#
> 
> 
> This runs fine...
> 
> Next one is:
> 
> 
>   
>   SELECT *
>   FROM SI_ITEMS2
>   WHERE SI_ITEM_ID = #TheITem#
>   AND SI_Opsrpt_ID = #qgetsi.SI_Opsrpt_ID#
>   
> 
> 
> This seems to run fine but comes back with ONE record when it should come
> back with THREE:
> 
> Results:
> qgetitems (Records=1, Time=0ms)
> SQL = SELECT * FROM SI_ITEMS2
> WHERE SI_ITEM_ID = 19 AND
> SI_Opsrpt_ID = 5
> SELECT * FROM SI_ITEMS2
> WHERE SI_ITEM_ID = 13
> AND SI_Opsrpt_ID = 5
> SELECT * FROM
> SI_ITEMS2
> WHERE SI_ITEM_ID = 15
> AND SI_Opsrpt_ID = 5
> 
> It only appears to bring back ONE record however it should bring back 3
> because
> ID 5 is in there with item id 19,15 and 13 but it seems to only pick up
> and
> display the first one
> Do I need to change my query
> Kelly
> --
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Problem with counting???

[Kelly Matthews]

Ok here are my current queries, thanks to Ben I got that part working.
Query 1:
I pass a date range:

SELECT *
FROM SelfInspection
WHERE SI_dt BETWEEN #CREATEODBCDate(form.date1)# AND
#CREATEODBCDate(form.date2)#


That works fine. then I have this next query, with a sub query, that checks
the SI_Items2 table
to see what items where checked for each qgetsi.SI_OPSRPT.ID.


SELECT SI_ITEM_NAME
FROM SI_ITEMS
WHERE si_item_id IN (
SELECT si_item_id
FROM SI_ITEMS2
WHERE SI_ITEM_ID IN (#SI_Item_ID#)
AND SI_Opsrpt_ID = #qgetsi.SI_Opsrpt_ID#)
Group by si_item_name   


Ok for the query above its deal with 2 tables one is SI_ITEMS which
simply have an SI_ITEM_ID and a name SI_ITEM_NAME
the 2nd table SI_ITEMS2 has the item id SI_ITEM_ID and the report
number SI_OPSRPT_ID  this table gets updated when someone fills out
a report if they select 3 items when filling out the report the ONE report
number is plopped in to SI_ITEMS2 with each item id. SO if there were
3 items selected when entering report 5 it would enter:
SI_OPSRPT_ID  SI_ITEM_ID
5   12
5   15
5   16

And then you can refer back to table SI_ITEMS and/or SelfInspection
to get the particulars about the ITEM ID or the REPORT ID. So now
I want to run a report between specific dates that will show how many times
an item
was reported on within that period.

Ok lets say the item I wanted to run a report on was Rubber. (although
someone may want to 
run a report on multiple items too_
The 2nd query I posted above will run for EACH qgetsi.si_opsrpt_id since
I have it within the  tags.
So the results look something like:
qgetitems (Records=1, Time=0ms) 
SQL = SELECT SI_ITEM_NAME 
FROM SI_ITEMS 
WHERE si_item_id IN ( 
SELECT si_item_id 
FROM SI_ITEMS2 
WHERE SI_ITEM_ID IN (5) 
AND SI_Opsrpt_ID = 5) 
and then if it finds it again:
qgetitems (Records=1, Time=0ms) 
SQL = SELECT SI_ITEM_NAME 
FROM SI_ITEMS 
WHERE si_item_id IN ( 
SELECT si_item_id 
FROM SI_ITEMS2 
WHERE SI_ITEM_ID IN (5) 
AND SI_Opsrpt_ID = 14)

So say it found rubber twice. Now in my output. How do I get that count. I
messed around with COUNT
but being that it runs each query separately for eacy report id i didnt see
a way to count it properly.
I just want the output to be something like
>From this date to that date: there were 2 Rubber problems.
what am i missing?
Kelly 



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Exchange & CF Problems.

[Kelly Matthews]

Recently we turned RELAYING off on our exchange server because people kept
using it to SPAM. Now this i find very strange.  Now that relaying is turned
off
any CFMails that mail to the OUTSIDE world get kicked back as if Exchange
thinks
the mail that CFMail passed to it is coming from the outside 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
---

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Mail Spooling Question

[Kelly Matthews]

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]
http://www.airportnet.org
---

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Mail Spooling Question

[Kelly Matthews]

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 Message-
> From: Howie Hamlin [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, August 16, 2000 12:27 PM
> To:   [EMAIL PROTECTED]
> Subject:  Re: Mail Spooling Question
> 
> You can set this time as low as 15 seconds with cf4.5.  Older versions of
> cf
> do not allow you to set this.
> 
> Regards,
> 
> Howie
> 
> - Original Message -
> From: "Kelly Matthews" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, August 16, 2000 10:57 AM
> Subject: Mail Spooling Question
> 
> 
> > 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]
> > http://www.airportnet.org
> > ---
> >
> >
> --
> 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Mail Spooling Question

[Kelly Matthews]

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, August 16, 2000 12:41 PM
> To:   [EMAIL PROTECTED]
> Subject:  Re: Mail Spooling Question
> 
> This setting is only for cf4.5.1 (maybe 4.5 also but I'm not sure).  It's
> under miscellaneous/mail/Spool Interval.
> 
> Howie
> 
> - Original Message -
> From: "Kelly Matthews" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Wednesday, August 16, 2000 12:25 PM
> Subject: RE: Mail Spooling Question
> 
> 
> > 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 Message-
> > > From: Howie Hamlin [SMTP:[EMAIL PROTECTED]]
> > > Sent: Wednesday, August 16, 2000 12:27 PM
> > > To: [EMAIL PROTECTED]
> > > Subject: Re: Mail Spooling Question
> > >
> > > You can set this time as low as 15 seconds with cf4.5.  Older versions
> of
> > > cf
> > > do not allow you to set this.
> > >
> > > Regards,
> > >
> > > Howie
> > >
> > > - Original Message -
> > > From: "Kelly Matthews" <[EMAIL PROTECTED]>
> > > To: <[EMAIL PROTECTED]>
> > > Sent: Wednesday, August 16, 2000 10:57 AM
> > > Subject: Mail Spooling Question
> > >
> > >
> > > > 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]
> > > > http://www.airportnet.org
> > > > ---
> > > >
> > > >
> >
> >
> --
> > > 
> > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > > To Unsubscribe visit
> > >
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> or
> > > send a message to [EMAIL PROTECTED] with 'unsubscribe'
> in
> > > the body.
> > >
> >
> >
> --
> > > 
> > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > To Unsubscribe visit
> > >
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> or
> > > send a message to [EMAIL PROTECTED] with 'unsubscribe'
> in
> > > the body.
> >
> --
> 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Exchange & CF Problems.

[Kelly Matthews]

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
---

> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, August 16, 2000 1:11 PM
> To:   [EMAIL PROTECTED]
> Subject:  RE: Exchange & CF Problems.
> 
> Be aware that Exchange SMTP relay control is a little confusing; the admin
> can either limit access by IP address/range OR by "smtp authentication",
> but
> not both, so if the mail people want to use authentication you're out of
> luck, as CF's mailer cannot do smtp authentication.  I have had to set up
> a
> seperate SMTP server as our mail admins wanted to use smtp authentication.
> 
> It does sound like you've run into the relay restriction; when the mail
> admins forbid relaying it means that the SMTP server will only accept mail
> that is destined for itself.  So I'll bet you can use CFMAIL to send mail
> to
> people within your organization, but not to anyone in the outside world.
> 
> -Original Message-
> From: Philip Meadows [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 16, 2000 11:36 AM
> To: '[EMAIL PROTECTED]'
> Cc: '[EMAIL PROTECTED]'
> Subject: RE: Exchange & CF Problems.
> 
> 
> I only have experience w/this in IIS using SMTP, but I think its the same
> problem. Since your CF Server has a different IP then your Exchange
> server,
> any mail being sent via CF Server the Exchange server thinks you're
> relaying. So, if Exchange has similar settings to IIS, you need to allow
> relaying just for the IP your CF Server is using. This will block the
> spam,
> but allow your CF Server to relay (hopefully). Like I said this is all
> based
> on my experience w/SMTP in IIS, but it sounds like a similar problem.
> 
> Phil Meadows
> 
> -Original Message-
> From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 16, 2000 9:31 AM
> To: '[EMAIL PROTECTED]'
> Subject: Exchange & CF Problems.
> 
> 
> Recently we turned RELAYING off on our exchange server because people kept
> using it to SPAM. Now this i find very strange.  Now that relaying is
> turned
> off
> any CFMails that mail to the OUTSIDE world get kicked back as if Exchange
> thinks
> the mail that CFMail passed to it is coming from the outside 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
> ---
> 
> 
> *
> 
> 
> *
> Any views or opinions are solely those of the author
> and do not necessarily represent those of
> United Advertising Media.
> *
> The information transmitted is intended only for the
> person or entity to which it is addressed and may
> contain confidential and/or privileged material. If
> you are not the intended recipient of this message,
> please do not read, copy, use or disclose this
> communication and notify the sender immediately. It
> should be noted that any review, retransmission,
> dissemination or other use of, or taking action in
> reliance upon, this information by persons or
> entities other than the intended recipient is
> prohibited.
> *
> **
> --
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Airport Code Database/We have one....

[Kelly Matthews]

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 PROTECTED]
http://www.airportnet.org
---

> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, August 17, 2000 12:12 PM
> To:   Cf-Talk
> Subject:  Airport Code Database
> 
> I have an application that requires that I offer a listing of airports and
> their associated codes. Does anyone have a tag or know of a source for the
> data so I can build my own tag?
> 
> Thanks,
> Scott
> 
> 
> Scott Brader
> USAV Group
> 5485 South Westridge Drive
> PO Box 510620
> New Berlin, WI 53151-0620
> Phone: 262.814.2000
> Fax: 262.814.2006
> 
> Amateurs Practice Until They Get It Right,
> Experts Practice Until They Can't Get It Wrong
> 
> Any opinions expressed herein are mine and are not representative of USAV
> Communications Group.
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Airport Code Database - We have one...

[Kelly Matthews]

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 PROTECTED]
http://www.airportnet.org
---

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Mail Servers?

[Kelly Matthews]

Are there any GOOD yet not too expensive mail servers out there? We
currently
have exchange no matter what we do we cant get CF to work with exchange as
long
as Relaying is shut down.  So we wanted to install another mail server for
CF
that can bypass exchange. Meaning we dont want a mail server, like some,
that still
POINTS to another mail server. We want a mail server that can send out SMTP
mail on it's own, i dont care about receiving mail. Any recommendations?
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://www.airportnet.org
---

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Mail Servers?

[Kelly Matthews]

I tried that and it didnt seem dependable i would only receive about 70% of
the messages that
were sent even though none of them threw errors. Very strange...
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://www.airportnet.org
---

> -Original Message-
> From: Philip Meadows [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, August 23, 2000 10:41 AM
> To:   '[EMAIL PROTECTED]'
> Cc:   '[EMAIL PROTECTED]'
> Subject:  RE: Mail Servers?
> 
> How about just starting the service for the mail server included w/IIS? If
> its just for CF it will work fine and you can block relaying w/your own
> exceptions. Plus its free and you already have it if you're running NT
> Server.
> 
> Philip
> 
> -Original Message-
> From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 23, 2000 8:59 AM
> To: '[EMAIL PROTECTED]'
> Subject: Mail Servers?
> 
> 
> Are there any GOOD yet not too expensive mail servers out there? We
> currently
> have exchange no matter what we do we cant get CF to work with exchange as
> long
> as Relaying is shut down.  So we wanted to install another mail server for
> CF
> that can bypass exchange. Meaning we dont want a mail server, like some,
> that still
> POINTS to another mail server. We want a mail server that can send out
> SMTP
> mail on it's own, i dont care about receiving mail. Any recommendations?
> 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://www.airportnet.org
> ---
> 
> --
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Mail Servers?

[Kelly Matthews]

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://www.airportnet.org
---

> -Original Message-
> From: Neil Middleton [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, August 23, 2000 11:02 AM
> To:   [EMAIL PROTECTED]
> Subject:  Re: Mail Servers?
> 
> lets see, a good cheap mail server?
> 
> Seems you'll be wanting sendmail, it's superb and above all FREE.
> 
> --
> Neil Middleton
> Technical Director
> Stez Media
> 01737 212282
> 
> Neil Middleton studied ancient Greek and Roman warfare with the aim of
> world
> domination.
> He's now a ColdFusion programmer.
> - Original Message -
> From: Kelly Matthews <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, August 23, 2000 2:58 PM
> Subject: Mail Servers?
> 
> 
> > Are there any GOOD yet not too expensive mail servers out there? We
> > currently
> > have exchange no matter what we do we cant get CF to work with exchange
> as
> > long
> > as Relaying is shut down.  So we wanted to install another mail server
> for
> > CF
> > that can bypass exchange. Meaning we dont want a mail server, like some,
> > that still
> > POINTS to another mail server. We want a mail server that can send out
> SMTP
> > mail on it's own, i dont care about receiving mail. Any recommendations?
> > 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://www.airportnet.org
> > ---
> >
> >
> --
> 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> >
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Mail Servers?

[Kelly Matthews]

i never said free just not expensive :) and there are a couple free ones i
ran across actually
but they arent that good. 

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://www.airportnet.org
---

> -Original Message-
> From: JustinMacCarthy [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, August 23, 2000 11:21 AM
> To:   [EMAIL PROTECTED]
> Subject:  Re: Mail Servers?
> 
> Free ? Surely not on NT ...
> 
> ~Justin
> 
> - Original Message -
> From: "Neil Middleton" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, August 23, 2000 4:02 PM
> Subject: Re: Mail Servers?
> 
> 
> > lets see, a good cheap mail server?
> >
> > Seems you'll be wanting sendmail, it's superb and above all FREE.
> >
> > --
> > Neil Middleton
> > Technical Director
> > Stez Media
> > 01737 212282
> >
> > Neil Middleton studied ancient Greek and Roman warfare with the aim of
> world
> > domination.
> > He's now a ColdFusion programmer.
> > - Original Message -
> > From: Kelly Matthews <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Wednesday, August 23, 2000 2:58 PM
> > Subject: Mail Servers?
> >
> >
> > > Are there any GOOD yet not too expensive mail servers out there? We
> > > currently
> > > have exchange no matter what we do we cant get CF to work with
> exchange
> as
> > > long
> > > as Relaying is shut down.  So we wanted to install another mail server
> for
> > > CF
> > > that can bypass exchange. Meaning we dont want a mail server, like
> some,
> > > that still
> > > POINTS to another mail server. We want a mail server that can send out
> > SMTP
> > > mail on it's own, i dont care about receiving mail. Any
> recommendations?
> > > 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://www.airportnet.org
> > > ---
> > >
> >
> >
> --
> > 
> > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> or
> > send a message to [EMAIL PROTECTED] with 'unsubscribe'
> in
> > the body.
> > >
> >
> >
> --
> 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> >
> >
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Select Query

[Kelly Matthews]

I dont see why not but you might want it to say
LIKE '%#url.page#%' that way as long as Peter
is within the keyword list it will find it otherwise
it won't. the % represents a wild card so anything
can come before or after Peter in the key word list
and it will still find Peter.

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://www.airportnet.org
---

> -Original Message-
> From: Peter Benoit [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, August 23, 2000 4:31 PM
> To:   '[EMAIL PROTECTED]'
> Subject:  Select Query
> 
> I have set a url string to a page, and I want to perform a query from a DB
> using that as a keyword.
> 
> Can I set a field in a DB with a bunch of keywords to compare against a
> string?
> 
> Lets say I pass the word "Peter" is #url.page#
> 
> And the field in the DB named Keyword has - John Mary Peter Bill - in it.
> Is it possible to build a query that will find Peter in that list of
> words,
> and presents the results?
> 
> My code so far:
> 
>   
>   SELECT  *
>   FROM Customerdoclist 
>   WHERE   (Customerdoclist.keywords LIKE '#url.page#')
> 
> 
> 
> Peter
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Shopping Cart Software?

[Kelly Matthews]

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
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: UserAction.cfm

[Kelly Matthews]

What i normally do is FIRST I RUN a QUERY against the database
seeing if the USERNAME that was passed is equal to any username in the 
database. Then i do a 
and show a message that the username is taken and then a 
that does the insert. That way if 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

---
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
---

> -Original Message-
> From: Jeremy Toevs [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, August 29, 2000 11:49 AM
> To:   <
> Subject:  UserAction.cfm
> 
> When you have a "No Duplicates" field in the database and a duplicate is
> entered, CF returns somewhat of a weird error message. How do you get it
> to return an error message saying "This UserName is already in use, choose
> another." UserName being the "No Duplicates" field. Here is my action cfm:
> 
> *
> 
> 
> INSERT INTO Users (UserName, RealName, Email)
> VALUES ('#UserName#','#RealName#','#Email#')
> 
> 
> *
> 
> Thanks in advance,
> 
> Jeremy
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: UserAction.cfm

[Kelly Matthews]

Example:

SELECT * 
FROM PenPals
WHERE PP_Username = '#Form.PP_Username#'


I'm sorry someone has already chosen that username, please go back
and choose another.




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://www.airportnet.org
---

> -Original Message-
> From: Jeremy Toevs [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, August 29, 2000 12:02 PM
> To:   [EMAIL PROTECTED]
> Subject:  RE: UserAction.cfm
> 
> How would that query look?
> 
> >>> Kelly Matthews <[EMAIL PROTECTED]> 08/29/00 08:43AM >>>
> What i normally do is FIRST I RUN a QUERY against the database
> seeing if the USERNAME that was passed is equal to any username in the 
> database. Then i do a 
> and show a message that the username is taken and then a 
> that does the insert. That way if 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 
> 
> ---
> Kelly Matthews
> Internet Development Coordinator
> AAAE
> 703.578.2509
> [EMAIL PROTECTED] 
> http://www.airportnet.org 
> ---
> 
> > -Original Message-
> > From:   Jeremy Toevs [SMTP:[EMAIL PROTECTED]] 
> > Sent:   Tuesday, August 29, 2000 11:49 AM
> > To: <
> > Subject:UserAction.cfm
> > 
> > When you have a "No Duplicates" field in the database and a duplicate is
> > entered, CF returns somewhat of a weird error message. How do you get it
> > to return an error message saying "This UserName is already in use,
> choose
> > another." UserName being the "No Duplicates" field. Here is my action
> cfm:
> > 
> > *
> > 
> > 
> > INSERT INTO Users (UserName, RealName, Email)
> > VALUES ('#UserName#','#RealName#','#Email#')
> > 
> > 
> > *
> > 
> > Thanks in advance,
> > 
> > Jeremy
> > 
> >
> --
> > 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 
> > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> or
> > send a message to [EMAIL PROTECTED] with 'unsubscribe'
> in
> > the body.
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ 
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: CF Conferance 2000 :: Do you want my registration?

[Kelly Matthews]

I agree i cant see them turning someone away because they forgot their ID.
All the person would have to say is they forgot to bring it.
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://www.airportnet.org
---

> -Original Message-
> From: Steve Bernard [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, August 29, 2000 5:42 PM
> To:   [EMAIL PROTECTED]
> Subject:  RE: CF Conferance 2000 :: Do you want my registration?
> 
> What keeps you from simply sending someone your pass and having them walk
> through the door as Paul?
> 
> Steve
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: ColdFusion Verity versus Verity Verity

[Kelly Matthews]

Yes its definetly LITE.  It was TOO LITE for use so we bought
the REAL DEAL.  The full version we own works FINE with CF.
Have had no problems. Email me if you have a question.
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://www.airportnet.org
---

> -Original Message-
> From: Peter Tilbrook [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, August 29, 2000 5:42 PM
> To:   '[EMAIL PROTECTED]'
> Subject:  RE: ColdFusion Verity versus Verity Verity
> 
> The Verity engine in CF is more like a "lite" version of Verity's full
> search engine product. It's still powerful however. I'm not sure if you
> can
> interact with the full version from within CF however.
> 
> Peter Tilbrook
> Internet Applications Developer
> Aspect Computing Pty. Ltd.
> 19-25 Moore Street
> Turner, ACT, 2612
> AUSTRALIA
> 
> http://www.aspect.com.au
> 
> Phone: (02) 6247 7677
> Fax: (02) 6249 1620
> Mobile: 0428 765 020
> 
> ACT ColdFusion Users Group - http://203.37.24.198
> 
> 
> -Original Message-
> From: Smith, Melanie [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, 30 August 2000 3:35
> To: '[EMAIL PROTECTED]'
> Subject: ColdFusion Verity versus Verity Verity
> 
> 
> I hope someone can help me get started here.  I've been asked to create a
> couple of simple verity collections and provide some kind of screen for
> users to query from to search those collections.  We've already purchased
> Verity.  Should I use Verity only (there is no database associated with
> these (mostly Word) files) or should I use ColdFusion to create, maintain
> and search the collections?  Seems like the whole thing would be easier to
> do with CF but I'm not sure what advantages using the full-blown Verity
> package could offer.  Since Verity only/no-CF is an option can someone
> point
> out the plusses and minuses of doing it either way?
> --
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Web server mapping not working...

[Kelly Matthews]

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 Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
---

> -Original Message-
> From: Peter Theobald [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, August 30, 2000 4:01 PM
> To:   [EMAIL PROTECTED]
> Subject:  Web server mapping not working...
> 
> I am having trouble with what should be a simple Apache web server
> mapping:
> 
> I had:
> 
> Alias / /home/httpd/html/mydomain.com/
> and it correctly ran the index.cfm in that directory when I went to the
> domain name in my browser.
> 
> I changed it to:
> 
> Alias / /home/httpd/html/mydomain.com/public/
> and now when I go to the domain name my browser shows me a listing of the
> files in the "public" directory INCLUDING the index.cfm file. I tried
> putting an index.htm just to make sure it wasn't Cold Fusion causing the
> problem and I still get a directory listing including the index.cfm and
> index.htm files in the list.
> 
> That is the only thing I changed. I can change it back and forth and see
> it work/not work.
> 
> -Going crazy
> 
> 
> --
> -
> Peter Theobald, Chief Technology Officer
> LiquidStreaming http://www.liquidstreaming.com
> [EMAIL PROTECTED]
> Phone 1.212.545.1232 Fax 1.212.679.8032
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Strange Warning in Application.Log

[Kelly Matthews]

its basically saying its going to use the
template file (intershipper.cfm) you have in 
C:\CFUSION\CustomTags\Ship
INSTEAD of the one you have in
C:\inetpub\wwwroot\shopping_cart\constructors\
You obviously have intershipper.cfm located in BOTH places.


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://www.airportnet.org
---

> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, September 06, 2000 12:11 PM
> To:   Cf-Talk
> Subject:  Strange Warning in Application.Log
> 
> Hi Folks,
> 
> I am getting a strange error in my Application.Log file that I am
> wondering
> if anyone could decode.  The error itself is cryptic to me, but weirder
> still is that the problem is with a shopping cart that I am fairly certain
> isn't being used by anyone at all...so why is this tag being looked at:
> 
> "Warning","TID=238","09/06/00","10:58:08","In a CF_TagName construct
> custom
> tag file 'C:\CFUSION\CustomTags\Ship\intershipper.cfm' will occlude custom
> tag file
> 'C:\inetpub\wwwroot\shopping_cart\constructors\intershipper.cfm'."
> 
> Thanks,
> 
> Eron
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

SQL Server Total Server Memory

[Kelly Matthews]

Ok question. I have SQL server running on the same server as IIS
and CF.  Basically we have a power house server and dont get a TON
of hits so saw no reason to have SQL on a separate server. I use it
only for some SMALL databases for the website.  Now with SQL 
server on the performance monitor you can monitor what's called 
Total Server Memory.  We have a gig of memory on the server however
here is whats happening. When I restart the MSSQLServer Service
it brings that Total Server memory down to about 9megs of that 1 gig.
However as the days pass that memory creeps up. For instance I checked
this morning and after 5 days it was using HALF of the 1 gig memory. 
Obviously if i never restarted MSSQLServer at some point this would
end up using ALL of the servers memory.  My guess is I am doing something
wrong
somewhere to cause a memory leak.  Any suggestions either in how i write
my queries or how I set up SQL Server to prevent this?? Suggestions would
be appreciated.
Thanks
Kelly
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: SQL Server Total Server Memory

[Kelly Matthews]

ok thanks any idea why it appears to CREEP UP slowly though
instead of just using the max from the get go, also if a set a MAX
and it ends up using that max will the performance be degraded
if its at MAX all the time? Just curious. :)

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://www.airportnet.org
---

> -Original Message-
> From: Aaron Johnson [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, September 25, 2000 12:00 PM
> To:   CF-Talk
> Subject:  RE: SQL Server Total Server Memory
> 
> Hey Kelly,
> 
> SQL Server, I think by default is configured to use all the memory on the
> machine.   You can change this by going to Enterprise Manager, right click
> on Properties (of your SQL Server, not the database) and then click on
> Memory.  From there you can configure SQL to have a MAX, MIN, or Fixed
> memory size.
> 
> Aaron
> 
> -Original Message-
> From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 25, 2000 8:38 AM
> To: CF-Talk
> Subject: SQL Server Total Server Memory
> 
> 
> Ok question. I have SQL server running on the same server as IIS
> and CF.  Basically we have a power house server and dont get a TON
> of hits so saw no reason to have SQL on a separate server. I use it
> only for some SMALL databases for the website.  Now with SQL
> server on the performance monitor you can monitor what's called
> Total Server Memory.  We have a gig of memory on the server however
> here is whats happening. When I restart the MSSQLServer Service
> it brings that Total Server memory down to about 9megs of that 1 gig.
> However as the days pass that memory creeps up. For instance I checked
> this morning and after 5 days it was using HALF of the 1 gig memory.
> Obviously if i never restarted MSSQLServer at some point this would
> end up using ALL of the servers memory.  My guess is I am doing something
> wrong
> somewhere to cause a memory leak.  Any suggestions either in how i write
> my queries or how I set up SQL Server to prevent this?? Suggestions would
> be appreciated.
> Thanks
> Kelly
> --
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> 
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Default Error Files

[Kelly Matthews]

I have always used my own custom Error files... I define them in 
CF Administrator under Settings at the bottom where it asks for
Missing Template Handler
and 
Site-Wide Error Handler.
These have always worked suddenly today it has reverrted back to the
plain IIS error screens. I changed NOTHING.  Any idea what i need
to look at to fix this? The error file pointers are still there. I am 
at a loss.
Any suggestions would be appreciated.
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://www.airportnet.org
---

> -Original Message-
> From: JustinMacCarthy [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, September 26, 2000 11:03 AM
> To:   CF-Talk
> Subject:  Re: Post form data in (to) CF
> 
> Have you tried removing the scope?
> Are you posting to cf using perl or the other way around?
> 
> ~Justin MacCarthy
> 
> - Original Message -
> From: "Benji Spencer" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, September 26, 2000 3:26 PM
> Subject: Post form data in (to) CF
> 
> 
> > I am working on a project where I need to construct the actual HTTP
> > request. I have run into a roadblock with CFM form pages though. Does
> > anyone know how CF handles form data in a post? CF seems to be
> > expecting/seeing things different then a CGI script.
> > here are a couple of examples as to what I am doing as well as there
> > unexplainable results.
> >
> > 1.1) my test PERL script (just displays the post data)
> >
> > [/opt/cgi-bin]% cat 2.pl
> > #!/usr/local/bin/perl
> > use CGI;
> > $query=new CGI;
> >
> > print $query->header;
> > print $query->param('date_id');
> >
> > 1.2) The request to that script
> > [~]$ telnet xyz 80
> > Trying xxx.xxx.xxx.xxx...
> > Connected to xyz.xyz.com.
> > Escape character is '^]'.
> > POST http://xyz.xyz.com/cgi-bin/2.pl HTTP/1.0
> > Content-Length: 18
> >
> > date_id=2000-09-21
> > HTTP/1.1 200 OK
> > Date: Tue, 26 Sep 2000 14:08:58 GMT
> > Server: xx
> > Last-Modified: Tue, 26 Sep 2000 13:45:57 GMT
> > Cache-Control: no-cache
> > Connection: close
> > Content-Type: text/html
> >
> > 2000-09-21Connection closed by foreign host.
> >
> >
> > 2.1) the CFM page
> >  #form.date_id#
> >
> >
> > 2.2) The request to the CF page
> > [~]$ telnet xyz 80
> > Trying xxx.xxx.xxx.xxx...
> > Connected to xyz.xyz.com.
> > Escape character is '^]'.
> > POST http://xyz.xyz.com/1.cfm HTTP/1.0
> > Content-Length: 18
> >
> > date_id=2000-09-21
> > HTTP/1.1 200 OK
> > Date: Tue, 26 Sep 2000 14:21:53 GMT
> > Server: 
> > Page-Completion-Status: Normal
> > Page-Completion-Status: Abnormal
> > Connection: close
> > Content-Type: text/html
> >
> >
> >
> >
> >
> >
> >
> >
> >
> <
> /A
> >
> BBREV> QU
> > OTE>
> >
>  T>
> >
> <
> /K
> > BD> >
> > P
> >
> ERSON>
>  > STRONG> >
> TD> D>
> > Error Occurred While Processing
> > RequestError Occurred While Processi
> > ng Request Error Diagnostic
> > InformationAn error occurred while evaluating the expression:
> > #form.date_id#Error near line 1, column
> > 13.Error resolving parameter FORM.DATE_IDThe
> specified
> > form field cannot be found. This problem is very likely due to the fact
> > that you have misspelled the form field name. The error
> occurred
> > while processing an element with a general identifier of
> (#form.date_id#),
> > occupying document position (1:12) to (1:25).Date/Time: Tue
> Sep
> > 26 09:22:01 2000Browser: Remote Address:
> > 172.24.2.15Please inform the  > href="mailto:[EMAIL PROTECTED]">site administrator that this error has
> > occurred (be sure to include the contents of this page in your message
> to
> > the administrator).Connection closed by foreign
> host.
> > [~]$
> >
> >
> > any insight that you could offer would be appreciated...thanks...
> >
> > benji
> >
> > ---
> > Benji Spencer
> > Web Programmer
> > Moody Bible Institute
> > 312-329-2288
> >
> >
> ---

RE: Studio vs. HomeSite

[Kelly Matthews]

Homesite doesn't incorporate all the Cold Fusion add ons so if you are doing
Cold Fusion go with Studio its basically a beefed up CF version of homesite.
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://www.airportnet.org
---

> -Original Message-
> From: Claremont, Timothy S [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, October 05, 2000 2:51 PM
> To:   CF-Talk
> Subject:  Studio vs. HomeSite
> 
> Does anyone have any preferences for one over the other?
> 
> What does one do that the other does not?
> 
> What is the diff??
> 
> 
> Tim Claremont
> Xerox Corporation
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: serving data

[Kelly Matthews]

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 say our company has a ton of proprietary data and we want to serve
> it 
> to others via the web - basically provide a way for other companies to 
> query that database from their web site using an interface they build 
> themselves. What's the most practical (quick, in-expensive) way of doing 
> this? Are there any CF tools for this? Thanks!
> 
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Major Spaces....OT

[Kelly Matthews]

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:  Major Spaces
> 
> I use Cold Fusion Studio 4.01 and it seems that everytime I save and
> re-open
> a document a bunch of spaces have been added.  Anyone else having this
> problem???  Any ideas what it happening?
> 
> Thanks in advance!
> 
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Slightly OT

[Kelly Matthews]

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: Jeffrey Cohen [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, June 01, 2000 12:08 PM
> To:   House OfFusion
> Subject:  Slightly OT
> 
> Does anyone have experience with homesite?
> 
> I need to recommend a SIMPLE wysiwyg editor to a customer of mine. Is
> Homesite Wysywyg or an HTML editor?, and if it's html, can anyone
> recommend a simple wys...editor BESIDES front page?
> 
> Thanks,
> 
> Jeffrey Cohen
> ImageWorks
> 
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Question...

[Kelly Matthews]

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 the story instead of the whole thing?? Can this 
be done?
Kelly
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

SQL Server/CF Question

[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.  Obviously there is some type of memory leak and I dont
know where
to begin to trouble shoot. Meaning are there some settings on the
Datasources I should
change to prevent this or is it something in SQL Server I need to look at.
If anyone has
experience with this please respond.
Kelly
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: CF based Ad Server & Management

[Kelly Matthews]

I use fuse ads (cold fusion program) which i have had no problems with...
It cost about $300 but the code is unencrypted... you can find info for
it in the CF Exchange part of allaires site (seems to be down at the moment
or I would have gotten it for you) just search for fuseads or fuse_ads
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:56 PM
> To:   [EMAIL PROTECTED]
> Subject:  CF based Ad Server & Management
> 
> What are the best CF driven Ad Server & Management solutions available?
> 
> I am looking for something which which not only has strong scheduling,
> campaign
> and management functions, but most importantly will allow advertisers to
> login
> to their own areas to check progress of ad campaigns such as banner
> impressions
> and click thru's etc..
> 
> Thanks.
> 
> Adrian Cooper.
> 
> 
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: CF based Ad Server & Management

[Kelly Matthews]

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
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:56 PM
> To:   [EMAIL PROTECTED]
> Subject:  CF based Ad Server & Management
> 
> What are the best CF driven Ad Server & Management solutions available?
> 
> I am looking for something which which not only has strong scheduling,
> campaign
> and management functions, but most importantly will allow advertisers to
> login
> to their own areas to check progress of ad campaigns such as banner
> impressions
> and click thru's etc..
> 
> Thanks.
> 
> Adrian Cooper.
> 
> 
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

HELP CF Insert Problem

[Kelly Matthews]

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.


Insert Into selfinspection
(si_report,
si_dt,
SI_Ops_Coord,
SI_tm,
si_Pavement_Lip_gt_3in,
SI_Hole_gt_5in_diam_3in_deep,
SI_Cracks_Spalling_Bumps,
SI_FOD,
SI_Rubber,
SI_Ponding_Edge_Dams,
SI_Obstruction_Lights,
SI_Cranes_Trees,
SI_Equip_Crew,
SI_Comm_Alarm,
SI_Ruts_Humps_Erosion,
SI_Drainage_Construction,
SI_Objects_Vegetation,
SI_Visible_Standard,
SI_Hold_Lines_Signs,
SI_Frangible_Bases,
SI_Fencing_Gates,
SI_Fencing_Gates_Signs,
SI_Fuel_Labeling,
SI_Fire_Extinguishers,
SI_Grounding_Clips,
SI_Obscured,
SI_Damaged,
SI_Inoperative,
SI_Faulty_Aim,
SI_Rotating_Beacon,
SI_Wind_Indicators,
SI_Barricades_Lights,
SI_Equipment_Parking,
SI_Dead_Birds,
SI_Flocks_of_Bird,
SI_Animals,
SI_Resolved,
SI_dt_Resolved,
SI_Descrip")
Values  
('#form.si_report#',
'#form.si_dt#',
'#form.si_Ops_Coord#',
'#form.si_tm#',
'#form.si_Pavement_Lip_gt_3in#',
'#form.si_Hole_gt_5in_diam_3in_deep#',
'#form.si_Cracks_Spalling_Bumps#',
'#form.si_FOD#',
'#form.si_Rubber#',
'#form.si_Ponding_Edge_Dams#',
'#form.si_Obstruction_Lights#',
'#form.si_Cranes_Trees#',
'#form.si_Equip_Crew#',
'#form.si_Comm_Alarm#',
'#form.si_Ruts_Humps_Erosion#',
'#form.si_Drainage_Construction#',
'#form.si_Objects_Vegetation#',
'#form.si_Visible_Standard#',
'#form.si_Hold_Lines_Signs#',
'#form.si_Frangible_Bases#',
'#form.si_Fencing_Gates#',
'#form.si_Fencing_Gates_Signs#',
'#form.si_Fuel_Labeling#',
'#form.si_Fire_Extinguishers#',
'#form.si_Grounding_Clips#',
'#form.si_Obscured#',
'#form.si_Damaged#',
'#form.si_Inoperative#',
'#form.si_Faulty_Aim#',
'#form.si_Rotating_Beacon#',
'#form.si_Wind_Indicators#',
'#form.si_Barricades_Lights#',
'#form.si_Equipment_Parking#',
'#form.si_Dead_Birds#',
'#form.si_Flocks_of_Birds#',
'#form.si_Animals#',
'#form.si_Resolved#',
'#form.si_dt_Resolved#',
'#form.si_Descrip#')


ERROR:
















Problem: ODBC Error Code = 37000 (Syntax error or access violation) 
[Microsoft][ODBC SQL Server Driver][SQL Server]The identifier that starts
with ') Values ('AM', '{ts '2000-07-14 11:27:12'}', 'KM', '7:00', '', '',
'', '', '', '', '', '', '' is too long. Maximum length is 128. 
SQL = "Insert Into selfinspection (si_report, si_dt, SI_Ops_Coord, SI_tm,
si_Pavement_Lip_gt_3in, SI_Hole_gt_5in_diam_3in_deep,
SI_Cracks_Spalling_Bumps, SI_FOD, SI_Rubber, SI_Ponding_Edge_Dams,
SI_Obstruction_Lights, SI_Cranes_Trees, SI_Equip_Crew, SI_Comm_Alarm,
SI_Ruts_Humps_Erosion, SI_Drainage_Construction, SI_Objects_Vegetation,
SI_Visible_Standard, SI_Hold_Lines_Signs, SI_Frangible_Bases,
SI_Fencing_Gates, SI_Fencing_Gates_Signs, SI_Fuel_Labeling,
SI_Fire_Extinguishers, SI_Grounding_Clips, SI_Obscured, SI_Damaged,
SI_Inoperative, SI_Faulty_Aim, SI_Rotating_Beacon, SI_Wind_Indicators,
SI_Barricades_Lights, SI_Equipment_Parking, SI_Dead_Birds,
SI_Flocks_of_Bird, SI_Animals, SI_Resolved, SI_dt_Resolved, SI_Descrip")
Values ('AM', '{ts '2000-07-14 11:27:12'}', 'KM', '7:00', '', '', '', '',
'', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '',
'', '', '', '', '', '', '', '', '', '', '', 'This is an AM Test
description.')" 
Data Source = "NOTAM"

Any suggestions
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

HELP CF Insert Problem

[Kelly Matthews]

> 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.
> 
> 
>   Insert Into selfinspection
>   (si_report,
>   si_dt,
>   SI_Ops_Coord,
>   SI_tm,
>   si_Pavement_Lip_gt_3in,
>   SI_Hole_gt_5in_diam_3in_deep,
>   SI_Cracks_Spalling_Bumps,
>   SI_FOD,
>   SI_Rubber,
>   SI_Ponding_Edge_Dams,
>   SI_Obstruction_Lights,
>   SI_Cranes_Trees,
>   SI_Equip_Crew,
>   SI_Comm_Alarm,
>   SI_Ruts_Humps_Erosion,
>   SI_Drainage_Construction,
>   SI_Objects_Vegetation,
>   SI_Visible_Standard,
>   SI_Hold_Lines_Signs,
>   SI_Frangible_Bases,
>   SI_Fencing_Gates,
>   SI_Fencing_Gates_Signs,
>   SI_Fuel_Labeling,
>   SI_Fire_Extinguishers,
>   SI_Grounding_Clips,
>   SI_Obscured,
>   SI_Damaged,
>   SI_Inoperative,
>   SI_Faulty_Aim,
>   SI_Rotating_Beacon,
>   SI_Wind_Indicators,
>   SI_Barricades_Lights,
>   SI_Equipment_Parking,
>   SI_Dead_Birds,
>   SI_Flocks_of_Bird,
>   SI_Animals,
>   SI_Resolved,
>   SI_dt_Resolved,
>   SI_Descrip")
>   Values  
>   ('#form.si_report#',
>   '#form.si_dt#',
>   '#form.si_Ops_Coord#',
>   '#form.si_tm#',
>   '#form.si_Pavement_Lip_gt_3in#',
>   '#form.si_Hole_gt_5in_diam_3in_deep#',
>   '#form.si_Cracks_Spalling_Bumps#',
>   '#form.si_FOD#',
>   '#form.si_Rubber#',
>   '#form.si_Ponding_Edge_Dams#',
>   '#form.si_Obstruction_Lights#',
>   '#form.si_Cranes_Trees#',
>   '#form.si_Equip_Crew#',
>   '#form.si_Comm_Alarm#',
>   '#form.si_Ruts_Humps_Erosion#',
>   '#form.si_Drainage_Construction#',
>   '#form.si_Objects_Vegetation#',
>   '#form.si_Visible_Standard#',
>   '#form.si_Hold_Lines_Signs#',
>   '#form.si_Frangible_Bases#',
>   '#form.si_Fencing_Gates#',
>   '#form.si_Fencing_Gates_Signs#',
>   '#form.si_Fuel_Labeling#',
>   '#form.si_Fire_Extinguishers#',
>   '#form.si_Grounding_Clips#',
>   '#form.si_Obscured#',
>   '#form.si_Damaged#',
>   '#form.si_Inoperative#',
>   '#form.si_Faulty_Aim#',
>   '#form.si_Rotating_Beacon#',
>   '#form.si_Wind_Indicators#',
>   '#form.si_Barricades_Lights#',
>   '#form.si_Equipment_Parking#',
>   '#form.si_Dead_Birds#',
>   '#form.si_Flocks_of_Birds#',
>   '#form.si_Animals#',
>   '#form.si_Resolved#',
>   '#form.si_dt_Resolved#',
>   '#form.si_Descrip#')
> 
> 
> ERROR:
>   
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> Problem: ODBC Error Code = 37000 (Syntax error or access violation) 
> [Microsoft][ODBC SQL Server Driver][SQL Server]The identifier that starts
> with ') Values ('AM', '{ts '2000-07-14 11:27:12'}', 'KM', '7:00', '', '',
> '', '', '', '', '', '', '' is too long. Maximum length is 128. 
> SQL = "Insert Into selfinspection (si_report, si_dt, SI_Ops_Coord, SI_tm,
> si_Pavement_Lip_gt_3in, SI_Hole_gt_5in_diam_3in_deep,
> SI_Cracks_Spalling_Bumps, SI_FOD, SI_Rubber, SI_Ponding_Edge_Dams,
> SI_Obstruction_Lights, SI_Cranes_Trees, SI_Equip_Crew, SI_Comm_Alarm,
> SI_Ruts_Humps_Erosion, SI_Drainage_Construction, SI_Objects_Vegetation,
> SI_Visible_Standard, SI_Hold_Lines_Signs, SI_Frangible_Bases,
> SI_Fencing_Gates, SI_Fencing_Gates_Signs, SI_Fuel_Labeling,
> SI_Fire_Extinguishers, SI_Grounding_Clips, SI_Obscured, SI_Damaged,
> SI_Inoperative, SI_Faulty_Aim, SI_Rotating_Beacon, SI_Wind_Indicators,
> SI_Barricades_Lights, SI_Equipment_Parking, SI_Dead_Birds,
> SI_Flocks_of_Bird, SI_Animals, SI_Resolved, SI_dt_Resolved, SI_Descrip")
> Values ('AM', '{ts '2000-07-14 11:27:12'}', 'KM', '7:00', '', '', '', '',
> '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '',
> '', '', '', '', '', '', '', '', '', '', '', '', 'This is an AM Test
> description.')" 
> Data Source = "NOTAM"
> 
> Any suggestions
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: HELP CF Insert Problem

[Kelly Matthews]

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: Friday, July 14, 2000 12:44 PM
> To:   [EMAIL PROTECTED]
> Cc:   [EMAIL PROTECTED]
> Subject:  RE: HELP CF Insert Problem
> 
> > 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 on the CF Insert statement? Is this
> > true? All of my inserts except the first few are just 1 character.
> 
> No, your problem is that you've got a double-quote at the end of your
> fields
> list, I think:
> 
> > 
> > Insert Into selfinspection
> > (si_report,
> > si_dt,
> ...
> > SI_dt_Resolved,
> > SI_Descrip")
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Help with some calculations...

[Kelly Matthews]

OK i have a appl. on one page i am doing 3 calculations here is what they
look like:



 

The first is suppose to subtract 2 different TIMES and get the difference. 
The 2 times involved as an example are 17:11 - 17:09 which should give
a result of 2 minutes. It does but it looks like this: 0.002 how can i get
it to
output as :02

The 2nd one is just 2 number one being divided by the other. So for
instance. 423/562
which gives 0.752266etc... i want it however to display as 75.22%

The 3rd is another Time one want that to display like the first. Any
suggestions on how
to manipulate the display I tried messing around with Number Format with no
luck. I tried
doing some DateAdd functions for the times, no luck.
Kelly
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Help with some calculations...

[Kelly Matthews]

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:[EMAIL PROTECTED]]
> Sent: Thursday, July 20, 2000 10:45 AM
> To:   [EMAIL PROTECTED]
> Subject:  Re: Help with some calculations...
> 
> Hi Kelly,
> For this one:
> 
> 
> Just do it like this:
> 
> 
> #numberformat(apipercent, "99.99")#%
> 
> For this one:
> 
> 
> Try this:
> 
> :#minutes#
> 
> Hope that helps.
> -d
> 
> 
> 
> Deanna Schneider
> Interactive Media Developer
> UWEX Cooperative Extension Electronic Publishing Group
> 103 Extension Bldg
> 432 N. Lake Street
> Madison, WI 53706
> (608) 265-7923
> 
> 
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Help with some calculations...

[Kelly Matthews]

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
---

> -Original Message-
> From: Kelly Matthews [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, July 20, 2000 10:32 AM
> To:   '[EMAIL PROTECTED]'
> Subject:  RE: Help with some calculations...
> 
> 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:[EMAIL PROTECTED]]
> > Sent:   Thursday, July 20, 2000 10:45 AM
> > To: [EMAIL PROTECTED]
> > Subject:Re: Help with some calculations...
> > 
> > Hi Kelly,
> > For this one:
> > 
> > 
> > Just do it like this:
> > 
> > 
> > #numberformat(apipercent, "99.99")#%
> > 
> > For this one:
> > 
> > 
> > Try this:
> > 
> > :#minutes#
> > 
> > Hope that helps.
> > -d
> > 
> > 
> > 
> > Deanna Schneider
> > Interactive Media Developer
> > UWEX Cooperative Extension Electronic Publishing Group
> > 103 Extension Bldg
> > 432 N. Lake Street
> > Madison, WI 53706
> > (608) 265-7923
> > 
> > 
> > 
> >
> --
> > 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> or
> > send a message to [EMAIL PROTECTED] with 'unsubscribe'
> in
> > the body.
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Help w/ query display...

[Kelly Matthews]

Ok I run these 2 queries:

SELECT *
FROM Runways


SELECT *
FROM Runway_Detail
WHERE O_Report_Num = #qgetops.O_Report_Num#

The first just pulls all the runways.
The 2nd pulls any runways that were affected. the Runway_ID is the field
that is associated in both tables.

In the output I have all the runways display with check boxes (this works
fine) by doing this:

#runway#

This works fine.  It displays the 4 runways. HOwever with the 2nd query it
finds that 2 of the runways
were reported to have problems therefore I want those 2 check boxes to be
CHECKED.
However doing this:
CHECKED>#runway#

Does not work.  even though there are 2 runway Id's that are pulled from the
runwaydetail query it only brings back one
in this output. Either way it doesnt check any boxes at all. Yet throws no
errors either. The queries work fine so its something
in the way I am outputting. Any Suggestions???
Kelly

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Help w/ query display...

[Kelly Matthews]

> uh where do i put this:
> 
> I did it like this (guessing) but then only the TWO runways that should be
> checked show up I still
> need the other 2 NON CHECKED runways to show up unchecked?? Any
> suggestions?
> 
> 
> SELECT *
> FROM Runways
> 
> 
> SELECT runway_ID
> FROM Runway_Detail
> WHERE O_Report_Num = #qgetops.O_Report_Num#
>  
> What runway was affected if any?
> 
> 
> 
> 
>  qgetrunwaydetail.runways.runway_id>CHECKED
> value="#runway_id#">#runway#    
> 
> 
> ---
> Kelly Matthews
> Internet Development Coordinator
> AAAE
> 703.578.2509
> [EMAIL PROTECTED]
> http://www.airportnet.org
> ---
> 
> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, July 20, 2000 1:57 PM
> To:   [EMAIL PROTECTED]
> Cc:   [EMAIL PROTECTED]
> Subject:  RE: Help w/ query display...
> 
> > Ok I run these 2 queries:
> > 
> > SELECT *
> > FROM Runways
> > 
> > 
> > SELECT *
> > FROM Runway_Detail
> > WHERE O_Report_Num = #qgetops.O_Report_Num#
> > 
> > The first just pulls all the runways.
> > The 2nd pulls any runways that were affected. the Runway_ID
> > is the field that is associated in both tables.
> >
> > In the output I have all the runways display with check boxes
> > (this works fine) by doing this:
> > 
> >  > value="#runway_id#">#runway#
> > 
> > This works fine.  It displays the 4 runways. HOwever with the
> > 2nd query it finds that 2 of the runways were reported to have
> > problems therefore I want those 2 check boxes to be CHECKED.
> > However doing this:
> >  > value="#runway_id#" 
> > CHECKED>#runway#
> >
> > Does not work.  even though there are 2 runway Id's that are
> > pulled from the runwaydetail query it only brings back one
> > in this output. Either way it doesnt check any boxes at all.
> > Yet throws no errors either. The queries work fine so its
> > something in the way I am outputting. Any Suggestions???
> 
> There are a couple of problems with what you're doing. The first problem
> is
> that you're referencing a string:
> 
> 
> 
> instead of a variable:
> 
> 
> 
> The second problem is that you really want to have any runway checked if
> it's in the list of runways that have problems, so you'll have to look at
> all of them at once, rather than just looking at the first one:
> 
> 
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Help w/ query display...

[Kelly Matthews]

Ok I figured it out DUH:
CHECKED
value="#runway_id#">#runway#
Thanks Dave!

-------
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
---

> -Original Message-----
> From: Kelly Matthews [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, July 20, 2000 2:01 PM
> To:   '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
> Subject:  RE: Help w/ query display...
> 
> ok thats the thing i didnt know how to do it was only looking at the FIRST
> and iw asnt sure
> how to get it to look at all of them. The missing quotes was just from
> typing and trying too many
> damn things.. hehe I will try that thanks!
> Kelly
> 
> ---
> Kelly Matthews
> Internet Development Coordinator
> AAAE
> 703.578.2509
> [EMAIL PROTECTED]
> http://www.airportnet.org
> ---
> 
> > -Original Message-
> > From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> > Sent:   Thursday, July 20, 2000 1:57 PM
> > To: [EMAIL PROTECTED]
> > Cc: [EMAIL PROTECTED]
> > Subject:RE: Help w/ query display...
> > 
> > > Ok I run these 2 queries:
> > > 
> > > SELECT *
> > > FROM Runways
> > > 
> > > 
> > > SELECT *
> > > FROM Runway_Detail
> > > WHERE O_Report_Num = #qgetops.O_Report_Num#
> > > 
> > > The first just pulls all the runways.
> > > The 2nd pulls any runways that were affected. the Runway_ID
> > > is the field that is associated in both tables.
> > >
> > > In the output I have all the runways display with check boxes
> > > (this works fine) by doing this:
> > > 
> > >  > > value="#runway_id#">#runway#
> > > 
> > > This works fine.  It displays the 4 runways. HOwever with the
> > > 2nd query it finds that 2 of the runways were reported to have
> > > problems therefore I want those 2 check boxes to be CHECKED.
> > > However doing this:
> > >  > > value="#runway_id#" 
> > > CHECKED>#runway#
> > >
> > > Does not work.  even though there are 2 runway Id's that are
> > > pulled from the runwaydetail query it only brings back one
> > > in this output. Either way it doesnt check any boxes at all.
> > > Yet throws no errors either. The queries work fine so its
> > > something in the way I am outputting. Any Suggestions???
> > 
> > There are a couple of problems with what you're doing. The first problem
> > is
> > that you're referencing a string:
> > 
> > 
> > 
> > instead of a variable:
> > 
> > 
> > 
> > The second problem is that you really want to have any runway checked if
> > it's in the list of runways that have problems, so you'll have to look
> at
> > all of them at once, rather than just looking at the first one:
> > 
> > 
> > 
> > Dave Watts, CTO, Fig Leaf Software
> > http://www.figleaf.com/
> > voice: (202) 797-5496
> > fax: (202) 797-5444
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

CF & MS Word

[Kelly Matthews]

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
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

CFOUTPUT/QUERY question/Problem

[Kelly Matthews]

Ok someone helped me with something similar before.  Basically I initially
run a query based on a set
of dates and pull ALL records within that date range (simple enough):

SELECT O_Report_Num, O_Period_dt_Beg, O_WildLife, O_Bird_Strikes, O_K9, 
O_Small_Mammals, O_Flocks_of_Birds, O_WildLife_Incidents
FROM Operations
WHERE O_Period_dt_Beg BETWEEN #CREATEODBCDate(form.wild_dt1)# AND
#CREATEODBCDate(form.wild_dt2)#
AND O_Wildlife > 0
ORDER BY O_Period_dt_Beg


Then I have another query I run just to get airport runway names.


SELECT *
FROM Runways



Then in the output I have a few variables that print out from the first
query. Where the airport runways come into play
is if there were any problems reported about a runway for a particular
airport. So for instance Query qgetwild may bring
back FIVE records. In this output I want each record and its variables to
print out one at a time. Thats very easy But then when I do the 3rd query: 


SELECT runway_ID
FROM Runway_Detail
WHERE O_Report_Num = #qgetwild.O_Report_Num#
 

which takes A SPECIFIC qgetwild record and sees what runways were reported
on it only will pick up the
FIRST qgetwild record.  And I have trouble outputting it too since I am
already in an output if I close it and open
a new one then it shows all the runways for all the reports as one instead
of listing each runway with its associated
report.  Point is I cant get it to print out like this:

Report Number: 1
Wild Life: Birds
Date: 01/02/00
Runways Affected: Runway 2 & Runway 4

Report Number: 2
Wild Life: Birds
Date: 01/03/00
Runways Affected: Runway 3 & Runway 4

Instead the only 2 ways I could get to work were either all reports
reporting the same runway.
Report Number: 1
Wild Life: Birds
Date: 01/02/00
Runways Affected: Runway 2

Report Number: 2
Wild Life: Birds
Date: 01/03/00
Runways Affected: Runway 2

Or all the runways showing up at the end:

Report Number: 1
Wild Life: Birds
Date: 01/02/00

Report Number: 2
Wild Life: Birds
Date: 01/03/00

Runways Affected: Runway 2 & Runway 4 & Runway 3



Any suggestions on how to get it to output the FIRST way would be
appreciated. I am still new to this so just don't know all the capabilities.
Thanks
Kelly

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: CFOUTPUT/QUERY question/Problem

[Kelly Matthews]

Here is what i did
Still only pulls ONE of the 2 runways that it should for the first report.
however i may have done it wrong.




Date of Incident: #DateFormat(O_Period_dt_Beg, ' d, ')#
Number of
Wildlife Incidents: #O_WildLife#
Report
Number:
#O_Report_Num#Wildlife Info: #O_WildLife_Incidents#


Bird Strikes: #O_Bird_Strikes#     K9: #O_K9#
    Flocks of Birds:
 #O_Flocks_of_Birds#     Small Mammals:
#O_Small_Mammals#


Runways Affected:

SELECT runway_ID
FROM Runway_Detail
WHERE O_Report_Num = #qgetwild.O_Report_Num#
 
What runway was affected if any?




#qgetrunways.runway# 

 
 


-------
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
---

> -Original Message-
> From: Joseph Thompson [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, July 25, 2000 10:11 AM
> To:   [EMAIL PROTECTED]
> Subject:  Re: CFOUTPUT/QUERY question/Problem
> 
> 
> On Tue, 25 Jul 2000 09:49:25 -0400, [EMAIL PROTECTED] wrote:
> 
> >  Ok someone helped me with something similar before.  Basically I
> initially
> >  run a query based on a set
> >  of dates and pull ALL records within that date range (simple enough):
> 
> Good morning.  I suspect that the trick here is to use an output loop
>  
> 
> ..
> 
> 
> 
> I have seen more elegant solutions, but this is my favorite : )
> 
> 
> 
> 
> 
> ___
> Say Bye to Slow Internet!
> http://www.home.com/xinbox/signup.html
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: SQL Books

[Kelly Matthews]

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
> 
> 
> --- 
> annex.com, Inc. - http://www.annex.com/ 
> --- 
> - If you EcoBuild it, they will come. - 
> - http://www.ecobuilder.com/ - 
> --- 
> 
> 
> > -Original Message-
> > From: Robert Everland [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, July 25, 2000 2:02 PM
> > To: '[EMAIL PROTECTED]'
> > Subject: SQL Books
> > 
> > 
> > Ok I am putting in some requests for books and when I 
> > do a search on
> > SQL books, just a billion come up. I would like to get the 
> > ones that deal
> > more with programming, since getting the software to work is 
> > usually the
> > easy part. Anyone recommend any?
> > 
> > Robert Everland III
> > Web Developer
> > Dixon Ticonderoga
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: conference info

[Kelly Matthews]

You are correct
http://www.allaire.com/handlers/index.cfm?ID=9495&Method=Full&Title=Conferen
ce%20Location%20and%20Hotel%20Reservations&Cache=False
but its still the Woodley stop some people refer to that Marriott as the
woodley but its the same
place.
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://www.airportnet.org
---

> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, October 31, 2000 12:27 PM
> To:   CF-Talk
> Subject:  RE: conference info
> 
> 
> I thought the conference was at Marriot Wardman Park Hotel.  I am wrong?
> 
> Mary
> 
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
> a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Help with Query

[Kelly Matthews]

Ok I will lay this out best i can... I have a database I am dealing just
with one small table.
In that table we have:
Auto_ID  FirstName LastName SocialSecNum TestName TestDate
If someone takes a test, we will use Driver Training as an example. They
take
the test and pass and their info is automatically entered in the database.
In 2 years
they will have to take the test again.  I want to build a report so they can
see 
who is up for RENEWAL.

Now hypothetically after 5 years or so a specific test taker may show up
more than
once. For instance if I took the test 4 years ago, then 2 years ago I would
have
2 records like:

AutoID: 3
First Name: Kelly
Last Name: Matthews
SSN: 
Test Name: Driver Training
Test Date: 11/07/96

AutoID: 302
First Name: Kelly
Last Name: Matthews
SSN: 
Test Name: Driver Training
Test Date: 11/07/98

Pretty much the same record but different test dates... To create a "Who
needs to retake their test" report.
I need to determine the LAST time each person took the test (meaning the
most recent test date) and then
if its MORE than 2 years ago have them show up on the renewal page.  I found
the query difficult
because obviously there will be multiple records for the same people.  So if
i query the table and it finds
2 records for kelly matthews, along with multiple records for other people,
I somehow need it to 
choose the most RECENT record and then do a check to see if its older than 2
years.  So in essence
on the report I would want Kelly Matthews to show up ONCE like:
Kelly Matthews  - Last Test date: 01/01/98 - Up for renewal in 6 days.

Any suggestions would be appreciated.
Kelly

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Help with Query

[Kelly Matthews]

well it still doesnt pull just the ONE distinct record my 2 records still
come up...???
i only want the most recent of all the folks records to appear...

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://www.airportnet.org
---

> -Original Message-
> From: Jason Powers [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, November 02, 2000 12:16 PM
> To:   CF-Talk
> Subject:  RE: Help with Query
> 
> Can't you say something like 
> SELECT name, max(date) 
> FROM table
> WHERE date<@mydate-2years
> GROUP BY name
> 
> Jason Powers
> Fig Leaf Software
> 
> -Original Message-
> From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, November 02, 2000 11:51 AM
> To: CF-Talk
> Subject: Help with Query
> 
> 
> Ok I will lay this out best i can... I have a database I am dealing just
> with one small table.
> In that table we have:
> Auto_ID  FirstName LastName SocialSecNum TestName TestDate
> If someone takes a test, we will use Driver Training as an example. They
> take
> the test and pass and their info is automatically entered in the database.
> In 2 years
> they will have to take the test again.  I want to build a report so they
> can
> see 
> who is up for RENEWAL.
> 
> Now hypothetically after 5 years or so a specific test taker may show up
> more than
> once. For instance if I took the test 4 years ago, then 2 years ago I
> would
> have
> 2 records like:
> 
> AutoID: 3
> First Name: Kelly
> Last Name: Matthews
> SSN: 
> Test Name: Driver Training
> Test Date: 11/07/96
> 
> AutoID: 302
> First Name: Kelly
> Last Name: Matthews
> SSN: 
> Test Name: Driver Training
> Test Date: 11/07/98
> 
> Pretty much the same record but different test dates... To create a "Who
> needs to retake their test" report.
> I need to determine the LAST time each person took the test (meaning the
> most recent test date) and then
> if its MORE than 2 years ago have them show up on the renewal page.  I
> found
> the query difficult
> because obviously there will be multiple records for the same people.  So
> if
> i query the table and it finds
> 2 records for kelly matthews, along with multiple records for other
> people,
> I somehow need it to 
> choose the most RECENT record and then do a check to see if its older than
> 2
> years.  So in essence
> on the report I would want Kelly Matthews to show up ONCE like:
> Kelly Matthews  - Last Test date: 01/01/98 - Up for renewal in 6 days.
> 
> Any suggestions would be appreciated.
> Kelly
> --
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
> a
> message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
> a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Still need Help with Query

[Kelly Matthews]

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.

SELECT DISTINCT ssn
FROM STUDENTS
WHERE AIRPORT_CODE = 'AAE'
AND testname = 'Driver Training'
 

Then i loop through (actually 2 loops the first takes the ssn and then finds
the max record id for that ssn)
the second goes back and gets all the INFO for the record id
Now the output is correct. It is pulling ONE record per person, the MOST
recent test.
However the ORDERING of the records is all screwy. I want the list to order
by test dates
but it doesnt. And of course putting ORDER BY testdate in one of the looped
queries doesnt
work since its dealing with one query at a time. I am sure i am 1. either
doing more than i need to do
or 2 missing something simple.??



SELECT MAX(airport_auto_ID) AS RECORD
FROM students
WHERE ssn = '#trim(search.ssn)#'



SELECT lname, fname, ssn, testdate
FROM students
WHERE airport_auto_ID = #search1.record#
 


#trim(fname)# #trim(lname)# #trim(ssn)# #dateformat(testdate,
'mm/dd/yy')#





Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Verity Search Engine

[Kelly Matthews]

Yep sure is... 
I use cmd files to run mine but in the file i put the following to exclude:
Here is a sample of excluding files AND directories:
-exclude  "*.gif" "*.jpg"  "*.cfm" "*\\cgi-bin" "*\\webboard" "*\\gif"
"*\\search97*" "*\\admin"

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://www.airportnet.org
---

> -Original Message-
> From: Michael She [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, November 13, 2000 5:43 PM
> To:   CF-Talk
> Subject:  Verity Search Engine
> 
> Is there a way to exclude certain paths from the verity search engine?
> Thanks!
> -- 
> Michael She
> I m a g i n e   C o m m u n i c a t i o n s
> Company E-mail: [EMAIL PROTECTED]
> Personal E-mail: [EMAIL PROTECTED]
> ICQ UIN: #243466
> Personal Homepage: http://www.michaelshe.com (Under Construction)
> Imagine Communications: http://www.imagineer.net
> PGP Fingerprint: 9A24 1DA9 39B8 0A0C C5ED 6E5D 45E9 075A 51CD 66A1
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
> a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Studio - left panel missing

[Kelly Matthews]

yes happened to me a few times Go to View and make sure 
Resource Tab is checked.
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://www.airportnet.org
---

> -Original Message-
> From: W Luke [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, November 15, 2000 1:29 PM
> To:   CF-Talk
> Subject:  Studio - left panel missing
> 
> Hi,
> 
> For some bizarre reason the left panel, with directory structure and Docs,
> in CF Studio has vanished.  The same happened in Homesite a month ago, and
> I'm still none the wiser as to how to get it back.
> 
> I've looked everywhere (obviously not hard enough) - anyone advise?
> 
> Thanks
> 
> Will
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
> a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Certification Exam

[Kelly Matthews]

OH goodie got a 4.3 there is hope for me yet...

> -Original Message-
> From: Shane Witbeck [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, November 16, 2000 11:56 AM
> To:   CF-Talk
> Subject:  RE: Certification Exam
> 
> There is a free 40 question CF 4.5 Certification exam available at
> brainbench.com. I have been told that if you score at least a 4 (on a 5
> point system), you have a good chance of passing the Allaire test. Good
> luck!
> 
> Shane Witbeck
> www.digitalsanctum.com
> 
> -- Original Message --
> From: "Mark W. Breneman" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date: Thu, 16 Nov 2000 09:39:14 -0600
> 
> >Don't take it too lightly.  I took it three times and failed.  I always
> >thought of my self as a good (better than average) cf programmer.  Only
> >missed it by one question the last time.
> >
> >I will not complain until after I pass it.  But, I knew that the result
> was
> >not going to be pretty when I guessed on five or six CFSCRIPT questions.
> I
> >have never used cfscript before.
> >
> >Note: The 61 test questions are pulled from about 100 to 150 questions
> >(guessing).
> >
> >Study:
> >CFscript
> >Array (pay attention to the names of the array tags)
> >Anything related to Structures. (and looping over them)
> >Application tag
> >SQL insert and wildcard selects
> >
> >http://www.cfcertification.com
> >
> >Hope this helps
> >Mark W. Breneman
> >-Cold Fusion Developer
> >-Network Administrator
> >  Vivid Media
> >  [EMAIL PROTECTED]
> >  www.vividmedia.com
> >  608.270.9770
> >
> >-Original Message-
> >From: Leong Yew [mailto:[EMAIL PROTECTED]]
> >Sent: Wednesday, November 15, 2000 6:14 PM
> >To: CF-Talk
> >Subject: Re: Certification Exam
> >
> >
> >Hi,
> >
> >I'm pretty new to this thread. Not knowing what's transpired, I'm just
> >wondering if anyone who's taken the certification exam could comment on
> the
> >following:
> >
> >1. What sort of familiarity are you expected to have with each CF tag and
> >function? Are you supposed to know every attribute that you can use with
> >each tag?
> >
> >2. Can anyone recommed any exam preparation material or books? I found it
> >really disappointing that compared to the more established exams (eg
> >Microsoft's or Novell's) there aren't a lot of published materials or
> sample
> >exams (not questions) you can refer to.
> >
> >3. When you're taking the exam, can you return to previous questions or
> must
> >you answer each question there and then? (I guess I'd have to admit that
> I'm
> >not sure if its computerized or paper-based).
> >
> >Leong
> >
> >- Original Message -
> >From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
> >To: "CF-Talk" <[EMAIL PROTECTED]>
> >Sent: Thursday, November 16, 2000 6:49 AM
> >Subject: RE: Certification Exam
> >
> >
> >> > The test is easy enough, especially considering you only need 60%.
> Many
> >> of
> >> > the questions are ambiguous so if you are not sure you can get a
> decent
> >> > amount wrong.
> >>
> >> Hopefully they'll change the questions soon.
> >>
> >> One thing to note is that they have a large bank of questions, so you
> >> shouldn't get the same exam if you sit it twice (some people were at
> the
> >> Conference)
> >>
> >> > If you've been coding for about a year or two and are
> >> > familiar with the majority of CF tags you'll be fine.
> >>
> >> As an ammendment to Andrew's comment - be familiar with the majority of
> >the
> >> CF4.5 tags, knowing CF4 will get you by, but they do ask some CF4.5
> >specific
> >> questions
> >>
> >> > Look over the tags
> >> > and functions, as well as error processing and how cf handles copying
> >from
> >> > one variable to another (remember cf is pass-by-reference).
> >>
> >> Also brush up on how CFScript works - it's fairly important... oh, and
> >> knowing HTML, JavaScript and how a website basically works is a damn
> good
> >> idea 
> >>
> >> > Brush up on your queries
> >>
> >> A decent, but not amazing, knowledge of SQL is (pseudo) required, so
> >knowing
> >> only "SELECT * FROM TABLE" won't cut it...
> >>
> >> > and last but not least... get a good night's sleep.
> >>
> >> Erm, I took it on 3 hours sleep over 40 hours... running on coffee, but
> >> having sleep is a DAMN good idea 
> >>
> >> Overall, know as much about CF as you can - pretty bleeding obvious,
> but
> >> there were some people at the Conf who took it after using CF for only
> a
> >> couple of months (from those I chatted to and what I heard), which is a
> >very
> >> bad idea - you can't just know the manuals parrot fashion - you MUST
> know
> >> the material!
> >>
> >> BTW, 60% isn't a difficult target to hit, it was annoying when a
> question
> >> has multiple answers but the system only allows one!
> >>
> >> Philip Arnold
> >> Director
> >> Certified ColdFusion Developer
> >> ASP Multimedia Limited
> >> T: +44 (0)20 8680 1133
> >>
> >> "Websites for the real world"
> >>
> >> 

RE: Firewall Question

[Kelly Matthews]

we use checkpoint very happy with it they have a great VPN add on as
well


> -Original Message-
> From: Philip Arnold - ASP [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, November 30, 2000 8:16 AM
> To:   CF-Talk
> Subject:  RE: Firewall Question
> 
> > companies like checkpoint (they might have been acquired - not sure)
> > make/made great products for securing internet/network traffic.
> 
> Just a FYI, Check Point are still running happily;
> Check Point Software Technologies
> Suite 5B
> Enterprise House, Vision Park
> Histon,
> Cambridge
> Cambridgeshire
> CB4 5BW
> United Kingdom
> 
> T: 01223236861
> T: 01223236847
> W: www.checkpoint.com
> 
> I'm not pushing their products, they just happen to exhibit at an
> exhibition
> we run the website for...
> 
> Philip Arnold
> Director
> Certified ColdFusion Developer
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
> 
> "Websites for the real world"
> 
> **
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> **
> 
>
~~
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

Help with Median...

[Kelly Matthews]

quick question I have no problem getting the averages using this query:


SELECT AVG(passengers_enplaned_domestic) as
avg_passengers_enplaned_domestic,AVG(passengers_enplaned_international) as
avg_passengers_enplaned_international,AVG(passengers_enplaned_transfer) as
avg_passengers_enplaned_transfer,
FROM rates_and_charges2, rates_and_charges1, airport_info
where rates_and_charges2.member_number = airport_info.member_number
and rates_and_charges1.member_number = airport_info.member_number


I would like to do something similar to get the MEDIAN... now SQL claims to
have a MEDIAN function yet when i use
it i get an error saying that function doesnt exist. Has anyone ever done a
median query?? any help would be appreciated.
Kelly

~~
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: Help with Median...

[Kelly Matthews]

Actually i found a CF_Median tag on allaire it works fine problem solved...
they have a CF_Standarddeviation tag too i am in heaven :)

> -Original Message-
> From: pan [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, December 06, 2000 1:09 PM
> To:   CF-Talk
> Subject:  Re: Help with Median...
> 
> 
> > 
> > I would like to do something similar to get the MEDIAN... now SQL claims
> to
> > have a MEDIAN function yet when i use
> > it i get an error saying that function doesnt exist. Has anyone ever
> done a
> > median query?? any help would be appreciated.
> > Kelly
> 
> "SQL" doesn't exist in re functional operations except as implemented
> by the rdbms you have deployed. You need to specify which rdbms
> you are trying to run code against. Some systems may have nothing
> but, less than, or more than what is specified in the ANSI SQL-92
> specs or other standard.
> 
> Pan
> 
> 
> 
>
~~
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

Survey Software

[Kelly Matthews]

Can i get some suggestoins on survey software. I was considering this one:
http://www.activefeedback.com/af/products/se2enterprise/
has anyone used it? If so do you like it?

If not any other pre written survey software out there? I would like
something for DUMB
users where they can fill out a few forms, set up many different types of
surveys, have it all
write to a SQL database, and then run reports on resutls, I spend far too
much time setting
up surveys for these folks and dont have time of course to write a program
to automate it all.. :)
Any suggestions would be appreciated.
Kelly

~~
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: SQL SERVER and IIS on the same machine?

[Kelly Matthews]

It really depends I did it for a long time. Never had major problems.
HOwever when I finally moved SQL to it's own server I did have performance
improvements, used less memories and had fewer errors. Not that there
was a major problem while SQL was on the same server it just performs
better when it's not. The big thing is to just monitor it. And set
your SQL memory not to go over a certain limit, because it really has
an appetite for memory otherwise.

-Original Message-
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 22, 2001 5:40 AM
To: CF-Talk
Subject: SQL SERVER and IIS on the same machine?


Our hosting company told me they don't support SQL SERVER
and IIS on the same NT machine.
"Even Microsoft doesn't recommened it", they claim.

What do you think? Money is always an issue...

Thanks,

-Michael.
~~
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: Problem with Studio 4.5.2 help

[Kelly Matthews]

I was having the same problem, that did the trick. Thanks!
Kelly

-Original Message-
From: Christopher Cortes [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 11:48 PM
To: CF-Talk
Subject: RE: Problem with Studio 4.5.2 help


Hubert,

Studio has its own Verity collection that stores the ColdFusion indices.
Renaming the directory where it is stored will trick Studio into recreating
the collections.

First close studio and then go to your ColdFusion Studio installation
directory, maybe:

"c:/program files/allaire/ColdFusion Studio 4x/Verity/Collections/Searchable
Help"

Rename the "Searchable help" directory to anything else, now launch studio
and try to use your help search again. It should prompt you to regenerate
the collection. Hope that does the trick for you, good luck.

- Chris


Christopher Cortes   |Coming Q3 2001:
Consultant   |
Stonebridge Technologies, Inc.   | ’Optimizing ColdFusion’
 Putting Technology To Work  |   By
Visit us at www.sbti.com |   Christopher Cortes
Ofc: 713.985.6244 cel: 281.235.6100  | www.osborne.com
<---!>


-Original Message-
From: Hubert Earl [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 7:06 PM
To: CF-Talk
Subject: Problem with Studio 4.5.2 help


Hi,

While Studio 4.5.2 was indexing its help files for the first time, as a
result of a search I was trying to do, my computer froze.  Now, whatever I
try to search for, I get the reply "No matches found" (even for words like
"form" and "template", which I tried to be absolutely sure about the
situation).  What can I do to rectify the situation?

Sincerely,
---
Hubert Earl

ICQ#: 16199853
AIM: hubertfme

My Jamaican Art, Craft & More Online Store:
http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html
~~
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: Quick DB Design

[Kelly Matthews]

This is the way I would go too:
-Kelly

This is a classic many-to-many relationship, best represented by 3 tables:

Table Users (userid, username, other user info)
Table Groups (groupid, groupname, other group info)
Table UsersGroups (userid, groupid)

-David

On Sunday, May 06, 2001 9:38 AM, Michael Lugassy [SMTP:[EMAIL PROTECTED]]
wrote:
> I'm trying to normalize a table to best hold the following data:
> username, group1, group2, group3, group4... groupN...
>
> there are 1000s of unique usernames, and 1s of unique groups
> every user can subscribe to 1-1 diffrent groups (so I don't know how
much
> group colums to put).
>
> I need somehow to maintain a list of subscribed groups for each user.
>
> is there a better way then 2 fields like the following:
>
> username (nvarchar(30)
> groups (longtext) = > group1,group3,group15,group7,group9 ?
~~
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: Field required doesn't work

[Kelly Matthews]

it works for me i wasn't able to submit an empty form maybe it's your
browser
giving you problems

-Original Message-
From: Parker, Kevin [mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 06, 2001 8:20 PM
To: CF-Talk
Subject: Field required doesn't work


This is a real head scratcher so that means I've probably overlooked
something simple. Thought if I left it for the weekend and had a look this
morning I'd spot it but no luck.

I have developed a form at
http://www.e-safety.sa.gov.au/sw_abstracts/sw_paper_form.cfm and have a
number of CFINPUTs with required = yes but when I hit the submit button I
can submit a completely empty form






Kevin Parker
Web Services Manager
WorkCover Corporation

[EMAIL PROTECTED]

www.workcover.com

p: +61 8 82332548
f: +61 8 82332000
m: 0418 800 287






This e-mail is intended for the use of the addressee only. It may contain
information that is protected by legislated confidentiality and/or is
legally privileged. If you are not the intended recipient you are prohibited
from disseminating, distributing or copying this e-mail. Any opinion
expressed in this e-mail may not necessarily be that of the WorkCover
Corporation of South Australia. Although precautions have been taken, the
sender cannot warrant that this e-mail or any files transmitted with it are
free of viruses or any other defect.
If you have received this e-mail in error, please notify the sender
immediately by return e-mail and destroy the original e-mail and any copies.

~~
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: Hosting /Dedicated or else

[Kelly Matthews]

www.knrtech.com

-Original Message-
From: Simon Horwith [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 10, 2001 3:25 PM
To: CF-Talk
Subject: RE: Hosting /Dedicated or else


cfdynamics.com ROCKS!!

~Simon

Simon Horwith
Macromedia Certified Instructor
Certified ColdFusion Developer
Fig Leaf Software
1400 16th St NW, # 500
Washington DC 20036
202.797.6570 (direct line)
www.figleaf.com



-Original Message-
From: Chris Badouin [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 10, 2001 2:22 PM
To: CF-Talk
Subject: Hosting /Dedicated or else



Looking for recommendations on CF Hosting places. No cheap places, places
that kick butt!

Christopher Badouin - founder
www.giveitaudio.com



-Original Message-
From: Angel Stewart [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 10, 2001 8:51 AM
To: CF-Talk
Subject: RE: URL Parameter in window.open


oh! oh!
I know the answer to this one!
:)
I did this already..hang on lemme get the code here..

ok! Go to www.opentelecom.com and click Send E page.

and do a View Source on that page
^_^

Its all there.

But just in case the site is down or somethign here is the relevant code:

function OpenPage()
{
window.open('sendpage.cfm?name='+ document.selectcustomer.name.value +
'&message=' + document.selectcustomer.message.value + '&email='
+document.selectcustomer.email.value,'paging','scrollbars=auto,menu=no,heigh
t=80,width=600')
}
//-->



And here is the form:


  
  
  
  
  



Took me a morning to hunt down and debug the syntax on this one :)
But it looks rather nice.

-Gel


-Original Message-
From: Richard Colman [mailto:[EMAIL PROTECTED]]

does anyone know something like this will work:

window.open('file.cfm?name=value', ... )

(does not seem to be working.)
~~
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 'Between' sql for Times/Dates

[Kelly Matthews]

-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 16, 2001 1:34 PM
To: CF-Talk
Subject: Using 'Between' sql for Times/Dates


Hi,

I have a list of dates and times, in a field called logDate, which are
constantly updated.  I need to pull the last 2 hours worth of rows that have
been added.  I think there's a specific part of time-handling that I'm
missing, because the code below doesn't pull any records at all:





SELECT logDate FROM stats
WHERE logDate BETWEEN #twohours# AND #nowtime#


The Database is Access, and the field is set to General Date.

Any help would be appreciated

--
Will
Free Classifieds -=- www.localbounty.com
e: [EMAIL PROTECTED]  icq: 31099745
~~
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: Article Discussion ready solution

[Kelly Matthews]

Just to give you an example. I built a real estate site for someone. After
the main site was built he mentioned that for every neighborhood that an
agent
signs up for he wanted a discussion forum *sigh* so we already owned CF
Forum 2000
open source. I simply modified the source to create a new forum for each
agent that signed up... This could be done in a similar fashion, everytime
an
article is posted it could automatically use that Article ID to create a
forum with
the same ID, this is assuming you have some forum software already in place.
Kelly

-Original Message-
From: Fouad Al-Farhan [mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 13, 2001 6:24 AM
To: CF-Talk
Subject: Article Discussion ready solution


We have a magazine website that is fully interactive. Now, they want us to
add article discussion feature. I don't want to reinvent the wheel again. Is
there a discussion system that could be plugged in our system with minimum
configuration? I'm not looking for indpendent system like FuseTalk
Discussion Forums. Simpler one would work fine.

Thank you
Fouad
~~
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: CFHTTP??

[Kelly Matthews]

It can be tricky but Find, Mid, ReFind etc... are functions you should use
to find the start and end point.

-Original Message-
From: Alii Design [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 30, 2001 10:23 AM
To: CF-Talk
Subject: CFHTTP??


How do I display a specific area of a CFHTTP request if I know where I want
the beginning and end to be?

Rich
~~
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: CFHTTP??

[Kelly Matthews]

Here is a good example this get's a dilbert comic out of a CFHTTP string:
http://www.unitedmedia.com/comics/dilbert/"; METHOD="GET"
RESOLVEURL="Yes">
http://www.unitedmedia.com/comics/dilbert/archive/images/dilbert",CFHT
TP.FileContent)>

",Variables.MyURL)>



-Original Message-
From: Alii Design [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 30, 2001 10:23 AM
To: CF-Talk
Subject: CFHTTP??


How do I display a specific area of a CFHTTP request if I know where I want
the beginning and end to be?

Rich
~~
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: Brain isn't working yet...

[Kelly Matthews]

Allow action


-Original Message-
From: Marcus [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 01, 2001 10:56 AM
To: CF-Talk
Subject: Brain isn't working yet...


I'm trying to provide functionality to a select group of people on a
specific subnet. What I'd like to do is something along the lines of..


Allow action


The thing being they use dhcp to allocate IP's and the address could
actually be any of the block. Is there a wild card I can use? or some other
way to not specify the last number?

Marcus
~~
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: Updating multiple rows!

[Kelly Matthews]

Why not do:


Update BiosPart
SET VGA_Rom = 'PCI'
WHERE
Part_ID > 751


Update BiosPart
SET VGA_Rom = 'PCI'
WHERE
Part_ID BETWEEN 751 AND whatever

That's assuming you are updating them all within a range.

-Original Message-
From: Jann VanOver [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 01, 2001 12:37 PM
To: CF-Talk
Subject: RE: Updating multiple rows!


Logic error -- do you have any records where the part_id is 751 AND 752?

Change "Part_ID = 751
AND
PART_ID = 752"
to "Part_ID IN (751,752...)"

-Original Message-
From: Ben Densmore [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 01, 2001 8:25 AM
To: CF-Talk
Subject: Updating multiple rows!


I am trying to update multiple rows at once and I don't seem to get any
errors but when I try to get the info I just updated nothing is there. Can
someone tell me if this Query should work?


Update BiosPart
SET VGA_Rom = 'PCI'
WHERE
Part_ID = 751
AND
PART_ID = 752   etc...

Thanks,
Ben




~~
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: Can we limit the text in textarea

[Kelly Matthews]

Well there isn't a maxlength BUT after they hit submit, on the action page, 
before it processes anything else, you can have CF COUNT the characters in
that
string and if they exceed a certain number you can give them a message
telling
them so.  There are also javascripts that will count characters on the form
so
when a person types in their text they click the (count characters) button
to see
if it's too long. I think there are even some written that will not let them
hit submit until they fix the field.
Kelly

-Original Message-
From: bajaria aslam [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 04, 2001 1:26 PM
To: CF-Talk
Subject: Can we limit the text in textarea


Is there a way to limit the number of characters
someone can type in in a textarea input box?

Thanks
AB
~~
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: Custom error pages

[Kelly Matthews]

There are a number of ways. The FIRST thing you want to do if you have
access is go CF administrator and then go to Settings.
Then scroll down and fill in the Exact Path to your Missing Template Handler
(for 404)
and your site-wide error handler (for errors).

Then you create the 2 pages you just pointed to and you have custom pages.
Now, there are a few things to keep in mind. 1. For 404 errors it will only
catch
..CFM 404 errors not .HTM so if you use IIS you need to edit their 404 page
to 
point to your new page.

Now what I do since I have my own server and MANY sites on it, is I create
the custom 404 and then on that 404 page I look at the SERVER_NAME which
normally contains the DOMAIN NAME, depending on the domain name found, 
I use  to then send them to a specific 404 page for that site.

Just some ideas.
Kelly

-Original Message-
From: Steve Vosloo [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 05, 2001 10:51 AM
To: CF-Talk
Subject: Custom error pages


I need to create 2 custom error pages for an application. One is for 404
errors (page not found), and the other is for any other server errors. Armed
with CFERROR and CFTRY/CFCATCH, does anyone have suggestions on how to
achieve this?

Thanks
Steve

Development Manager
Vardus Internet Solutions (SA)

Tel: (+27) 21 670 9880
Fax: (+27) 21 674 4549

Email: [EMAIL PROTECTED]
Website: www.vardus.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: CF5 Docs

[Kelly Matthews]

As far as I know you will still get the BOXED version as always. Even when I
bought 
4.5 I could download it but the box came later.

-Original Message-
From: cassady [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 06, 2001 1:05 PM
To: CF-Talk
Subject: CF5 Docs



I see that I can purchase and download the CF5 server from Macromedia, but I
was wondering IF or WHEN they'll offer a non-download that will include the
manuals (nice dead-tree print format). I use my current manuals all the time
and am hoping for updateded versions that include the new functions et. all.
I'm not really interested in using online help or printing off a bunch of
sheets esp. for new employees or helping introduce the product to clients.

Any idea when (if)?

Stephen R. Cassady
[EMAIL PROTECTED]
http://www.tallylist.com < You know you wanna

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

~~
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: Image resizing question

[Kelly Matthews]

One suggestion is you are probably trying ot resize GIFS
What I do is I do a search to see if the image is a GIF first
if it is I have it resave as a JPG then i resize it and save
it back to a gif then it wont distort.

-Original Message-
From: Eron Cohen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 06, 2001 12:52 PM
To: CF-Talk
Subject: Image resizing question


Hi Folks,

I am looking for ideas on how to handle a problem: The
site I am working on allows customers to upload their
company logos for display on a public page.  I'd like
the logos to be 100x100 pixels but I have a feeling I
can't really "require" that because alot of the
clients won't have a clue what I am talking about and
I don't want to chase anyone away.

I tried using CFX_Image to resize the images after
they come in, but they wind up a bit screwed up. 
First problem is that CFX_image only lets you resize X
or Y and then scales the other in proportion.  That
means to get to 100x100 I would potentially have to
scale one way and then scale the other which would
result in a smaller image the other direction.  Second
problem is alot of the images look bad after the
resizing.

I guess I could also just set the image height and
width when I display them, but I also don't like that
solution.  I am mainly concerned that someone will
upload a really tall or really wide image that will
take over my whole page.

Does anyone have any comments or ideas about what to
do here?
~~
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: Image resizing question

[Kelly Matthews]

Also don't force 100x100 just force the WIDTH to be 100 then you
wont have distortion from that either. a 300x200 image would ALWAYS
distort when forced into a square if it was a rectangle to begin with :)
Kelly

-Original Message-
From: Eron Cohen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 06, 2001 12:52 PM
To: CF-Talk
Subject: Image resizing question


Hi Folks,

I am looking for ideas on how to handle a problem: The
site I am working on allows customers to upload their
company logos for display on a public page.  I'd like
the logos to be 100x100 pixels but I have a feeling I
can't really "require" that because alot of the
clients won't have a clue what I am talking about and
I don't want to chase anyone away.

I tried using CFX_Image to resize the images after
they come in, but they wind up a bit screwed up. 
First problem is that CFX_image only lets you resize X
or Y and then scales the other in proportion.  That
means to get to 100x100 I would potentially have to
scale one way and then scale the other which would
result in a smaller image the other direction.  Second
problem is alot of the images look bad after the
resizing.

I guess I could also just set the image height and
width when I display them, but I also don't like that
solution.  I am mainly concerned that someone will
upload a really tall or really wide image that will
take over my whole page.

Does anyone have any comments or ideas about what to
do here?
~~
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: CFForm only passing one of my variables

[Kelly Matthews]

why do you have a TITLE tag in 2 of your 3 radio buttons

-Original Message-
From: Larry Junker [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 08, 2001 1:45 PM
To: CF-Talk
Subject: CFForm only passing one of my variables


Guru's;

I have a CF Form on my login page that uses the following code.
When I submit my form, I get my DIVISION variable to pass through OK,
however it seems as though my DIV_GROUP variable does not pass through.  I
am including a snippet of code to see if this stirs any interest in helping
me out.

Contractors Hot Line

   Which groups to include in this
email?
CHL  
CEG  
ALL  
WEB  



Thanks In Advance
Larry Juncker
Senior ColdFusion Developer
Heartland Communications Group, Inc.
[EMAIL PROTECTED]
~~
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 Administrator not restarting itself????

[Kelly Matthews]

>From what i have read and have been told if you set the setting
for RESTART at (HOWEVER MANY) unresponsive requests,
then Cold Fusion Administrator is SUPPOSED To restart itself,
after that many requests. We have NEVER had CF restart itself.
We always have to do it manually. Any reason why this wouldn't work?
It's an NT Server, running IIS. Any help or suggestion would be appreciated.
Kelly

~~
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 Administrator not restarting itself???? Sending again, can ANY ONE HELP?

[Kelly Matthews]

> From what i have read and have been told if you set the setting
> for RESTART at (HOWEVER MANY) unresponsive requests,
> then Cold Fusion Administrator is SUPPOSED To restart itself,
> after that many requests. We have NEVER had CF restart itself.
> We always have to do it manually. Any reason why this wouldn't work?
> It's an NT Server, running IIS. Any help or suggestion would be
> appreciated.
> Kelly
> 

~~
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: CF Administrator not restarting itself???? Sending again, can ANY ONE HELP?

[Kelly Matthews]

Yes to both.


> -Original Message-
> From: Dave Watts [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, February 02, 2001 12:27 PM
> To:   '[EMAIL PROTECTED]'
> Cc:   '[EMAIL PROTECTED]'
> Subject:  RE: CF Administrator not restarting itself Sending
> again, can ANY ONE HELP?
> 
> > From what i have read and have been told if you set the setting
> > for RESTART at (HOWEVER MANY) unresponsive requests,
> > then Cold Fusion Administrator is SUPPOSED To restart itself,
> > after that many requests. We have NEVER had CF restart itself.
> > We always have to do it manually. Any reason why this wouldn't work?
> > It's an NT Server, running IIS. Any help or suggestion would be
> > appreciated.
> 
> Do you have the CF Executive service running? Do you also have the
> "Timeout
> requests after n seconds" option turned on (found on the "Settings" page
> in
> CF Administrator)? I think you need to have both on.
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444

~~
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: What does OT mean?

[Kelly Matthews]

OFF TOPIC! :)

> -Original Message-
> From: Paul Ihrig [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, March 01, 2001 3:40 PM
> To:   CF-Talk
> Subject:  RE: What does OT mean?
> 
> Off Track Betting.
> 
> -paul
> 
> Web Developer, NBBJ
> Work: [EMAIL PROTECTED]
>   614 241-3534
> fax:  614 485-5534
> 
> Home: [EMAIL PROTECTED]
>   614 449-1681
> 
> > icq:47658358
> > 
> > -Original Message-
> > From:   Phoeun Pha [SMTP:[EMAIL PROTECTED]]
> > Sent:   Saturday, November 11, 2000 5:17 AM
> > To: CF-Talk
> > Subject:What does OT mean?
> > 
> > Other things??
> > 
> > 
> >
>
~~
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: Hostcentric concerns?

[Kelly Matthews]

YES YES YES!

> -Original Message-
> From: Jeff Epstein [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, March 14, 2001 2:04 PM
> To:   CF-Talk
> Subject:  Hostcentric concerns?
> 
> We originally set up on Virtualscape, but ever since Hostcentric took over
> Virtualscape, I've noticed a decline in performance and service.  More db
> errors, fewer answers, longer hold times on the phone, less knowledgable
> techs on the phone. Has anyone else had the same experience?  Is this
> normal?
> 
> Jeff Epstein 
> Web Producer 
> Search for Common Ground 
> 1601 Connecticut Avenue, NW 
> Suite 200 
> Washington, DC  20009  USA 
> +1 (202) 265-4300 
> +1 (202) 777-2238 (direct) 
> +1 (202) 232-6718 (fax) 
> [EMAIL PROTECTED] 
> www.sfcg.org  
> 
> 
>  
> 
> 
>
~~
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: Displaying yes/no field dynamically in checkboxes

[Kelly Matthews]

CHECKED>Yes
CHECKED>No

> -Original Message-
> From: P@tty Ayers [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, April 03, 2001 10:45 AM
> To:   CF-Talk
> Subject:  Displaying yes/no field dynamically in checkboxes
> 
> Friends,
> 
> I would much appreciate any help with a problem I'm stuck on.
> 
> I'm writing a page that will allow my client to edit a record. I've got it
> so that the page queries the table and inserts the values from the record
> specified by the numeric variable passed to it. The numeric fields, text
> fields and memo fields appear, but I can't figure out how to make the
> checkboxes display a check when the yes/no field is "yes".
> 
> Here's my code (below), such as it currently is. UltraDev wrote some of it
> and I wrote the rest. The first few yes/no fields are "cabinHottub",
> "cabinJettedtub", "cabinFireplace" and "cabinPets".
> 
> I would be grateful for any help; thanks very much in advance.
> 
> P@tty Ayers
> 
> 
> 
> 
> 
>  username=#MM_connAsheville_USERNAME# password=#MM_connAsheville_PASSWORD#>
> SELECT * FROM cabinQuery WHERE cabinID = #rsEdit__varcabintoedit#
> 
> 
> 
> 
> 
> 
>  Edit a Record Page
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>align="center" bordercolor="##CC">
> 
>   Cabin Name:
>   
>  value="#cabinName#">
>   
>   Location (City):
>   
>  value="#cabinCity#">
>   
> 
> 
>   Distance from Asheville:
>   
>  value="#cabinDistance#">
>   
>   Number of Bedrooms:
>   
>  value="#cabinBedrooms#">
>   
> 
> 
>   Number of Bathrooms:
>   
>  value="#cabinBathrooms#">
>   
>   Sleeps:
>   
>  value="#cabinSleeps#">
>   
> 
> 
>   Hot tub:
>   
> 
>   
>   Jetted tub:
>   
>  value="#cabinJettedtub#">
>   
> 
> 
>   Fireplace:
>   
>  value="#cabinFireplace#">
>   
>   Pet-friendly:
>   
> 
>   
> 
> 
>   Nightly Rate:
>$
>  value="#cabinNightly#">
>   
>   Weekly Rate:
>$
>  value="#cabinWeekly#">
>   
> 
> 
>   Bedroom 1:
>   
>  value="#cabinBedroom1#">
>   
>   Bedroom 2:
>   
>  value="#cabinBedroom2#">
>   
> 
> 
>   Bedroom 3:
>   
>  value="#cabinBedroom3#">
>   
>   Bedroom 4:
>   
>  value="#cabinBedroom4#">
>   
> 
> 
>   Bedroom 5:
>   
>  value="#cabinBedroom5#">
>   
>   Sleep Sofa:
>   
>  value="#cabinSleepsofa#">
>   
> 
> 
>   Loft:
>   
>  value="#cabinLoft#">
>   
>   Dishwasher:
>value="#cabinDishwasher#">
> 
> 
>   Microwave:
>value="#cabinMicrowave#"
>   Air Conditioning:
>   
> 
> 
>   Stereo/CD Player:
>value="#cabinStereoCD#"
>   TV:
>   
>  value="#cabinTV#">
>   
> 
> 
>   VCR:
>   
>   Washer/Dryer:
>   
>  value="#cabinWashdry#">
>   
> 
> 
>   Deck/Porch:
>value="#cabinDeckporch#"
>   Grill:
>   
>  value="#cabinGrill#">
>   
> 
> 
>   View:
>   
>  value="#cabinView#">
>   
>   Fireplace Style:
>   
>  value="#cabinFirestyle#">
>   
> 
> 
>   
> Description:
>rows="5">#cabinsDescription#
> 
>   
> 
> 
>   
> 
>   
> 
>   
> 
>   
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>
~~
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: 404 Page

[Kelly Matthews]

The referer is the page they came FROM. Meaning if they click a link and
that is not found you will get the page they clicked the actualy link, not
the missing page.
I have a similar script set up. When the referer is blank I know they were
going DIRECTLY
to that page by typing in the URL, when the referer is populated then I know
they bad LINK is on that page. Create a test page that links to a non
existent page,
click the link and see if the referer then fills in. Instead of just going
to a bad URL.
Kelly

> -Original Message-
> From: SHEETS, DAYV (PB) [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, April 03, 2001 12:08 PM
> To:   CF-Talk
> Subject:  404 Page
> 
> Hello, 
> 
> I am attempting to put into effect error handling on my 404 pages so that
> it
> emails me (via cfmail). I am using the following code to generate this:
> 
> 
> 
> 
>  
>  
>  
>   
> 
>  
>  
>  
>  
>   
> 
> 
>  from="#[EMAIL PROTECTED]#"
> cc="#[EMAIL PROTECTED]#"
> to="#[EMAIL PROTECTED]#"
> subject="404 Error Encountered"
> >
> 404 Error Encountered:
> 
> IP:   #address# 
> Host: #host# 
> Referer:
> #referer# 
> Agent:#agent# 
> page: #page# 
> host: #host#
> 
>   
> 
> 
> Sorry, the URL #referer# either does not exist, or
> has
> been removed from our site. 
> An email has been send to the Webmaster to inspect this error further.
> 
> 
> 
> 
> 
> The problem is that I am not receiving everything BUT the referring page.
> Is
> there something else I am overlooking/need to be doing?
> 
> Thanks in advance for your assistance,
> 
> Dayv
> 
>
~~
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: Stupid Question? - Commenting Code That Does Not Show in Brow ser

[Kelly Matthews]

are you using or use 3 dashes the other is to
comment
out HTML code that you WANT people to see in the source. 3 dashes HIDES it.

> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, April 03, 2001 2:35 PM
> To:   CF-Talk
> Subject:  Stupid Question? - Commenting Code That Does Not Show in
> Browser
> 
> I want to place comments in the code for the other developers.  However I
> do
> not want the comments to show up in the browser with "view source." Am I
> totally overlooking something?
> 
> Thanks,
> Jeff
>
~~
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: How to Allow a "Doesn't Matter" Variable in a Search?

[Kelly Matthews]

Well if it doesn't matter just don't pass the parameter have it set with a
value of "" and
then when you run the query where hottub =
Yesetc
that way if they pass the parameter blank it won't include it in the search,
hence pulling
up records that do and/or don't include hottubs. Is that what you mean? If
not let me know.
Kelly

> -Original Message-
> From: P@tty Ayers [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, April 04, 2001 1:31 PM
> To:   CF-Talk
> Subject:  How to Allow a "Doesn't Matter" Variable in a Search?
> 
> Friends:  Can anyone help with this problem I'm stuck on? Not sure if this
> is a simple one or not, but in any case I'll sure be delighted to get it
> working.
> 
> This set of pages allows the user to search a set of records using 9
> search
> objects. Four of those are for searching yes/no (1/0) fields in the
> Access2000 database.
> 
> For the four search fields which search yes/no columns, I  want them to
> choose either "This doesn't matter - don't include this in the search" OR
> "Include only records with "yes" (1) in this column. They need to be able
> to
> specify that they want to see only rental properties that have a hot tub,
> or
> else that this doesn't matter to them.
> 
> Obviously this differs from offering the choice between "Include only
> records with 'yes' in this column" and "Include only records with 'no' in
> this column", which is *not* what I need to do here.
> 
> This could be done with checkboxes or a menu - but I can't figure out how
> to
> allow that "This doesn't matter" search parameter.
> 
> Thanks very much in advance for your help!
> 
> 
> P@tty Ayers
> Macromedia Evangelist
> 
> Dreamweaver Resources, FAQs, and Tutorials:
> http://www.thepattysite.com/dreamweaver/
> 
> P@tty's ColdFusion Site
> http://carolina.cf-developer.net
> 
> Carolina Web Solutions
> http://www.carolinawebsolutions.com
> 
> "Design in art, is a recognition of the relation between various things,
> various elements in the creative flux. You can't invent a design. You
> recognise it, in the fourth dimension. That is, with your blood and your
> bones, as well as with your eyes."  - D. H. Lawrence
> 
> "Well-behaved women seldom make history."  - Anonymous
> 
> 
> 
> 
>
~~
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: Includes on HtML?

[Kelly Matthews]

You can always have .htm files process as CF files. I do it. So my whole
site is .htm people don't even know it's in cold fusion. Just a minor tweak
in IIS. Then if there are static html pages that you don't want CF to
process (because
they have no CF functionality or templates) you just use .html for those and
don't change the functionality of .html in IIS just .htm. Anyway, works
great for
me. No performance change at all. :)
Kelly

> -Original Message-
> From: SHEETS, DAYV (PB) [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, April 04, 2001 6:35 PM
> To:   CF-Talk
> Subject:  RE: Includes on HtML?
> 
> I'd rather Cold Fusion parse through the HTM/HTML files. How is this done
> via CF Server?
> 
> Dayv 
> 
> 
> 
> -Original Message-
> From: Andrew Tyrone [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 04, 2001 2:03 PM
> To: CF-Talk
> Subject: RE: Includes on HtML?
> 
> 
> In my opinion...
> 
> Unless you have a huge amount of html files and are running other web
> sites
> on the same server, this won't be a big performance concern.
> 
> Also, remember, that if you have more than 1 virtual site on the server,
> you
> can configure the applicable site to process htm and html files through
> the
> ColdFusion server, so only that site will be processing the files through
> CF.
> 
> To use server side includes will not offer that much of a performance gain
> since the ssinc.dll must then process the html files as well (by default
> it
> is mapped to .shtm, .shtml and .stm files).  So you'd be stuck in having
> the
> ssinc.dll process the files vs. having ColdFusion's iscf.dll do the work.
> 
> Changing file extensions is not really dangerous.  Many sites use their
> own
> custom extensions.  If portability is not a concern then go ahead and do
> it.
> Of course you can always rename the files and change the mappings back to
> the way they were in IIS.
> 
> - Andy
> 
> > -Original Message-
> > From: Erika L Walker [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, April 04, 2001 3:37 PM
> > To: CF-Talk
> > Subject: RE: Includes on HtML?
> > 
> > 
> > WellI know it's not recommended changing how the server 
> > interprets .htm
> > or .html files,however, if the site doesn't really take a 
> > huge amount of
> > hitsand it's hosted on a server by itself.and the company flatly
> > refuses to change the page names for fear of breaking bookmarks or some
> > other silly reasonthen allow CF to parse through html files 
> > isn't a huge
> > load..
> > 
> > But, if the hardware can't take the work and/or traffic beefs up, 
> > could slow
> > everything down?
> > 
> > Erika
> > 
> > -Original Message-
> > From: Douglas Knudsen [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, April 04, 2001 2:28 PM
> > To: CF-Talk
> > Subject: RE: Includes on HtML?
> > 
> > 
> > 
> > 
> > But the question was "can I  a file from a page with the
> > extension .htm or .html?"  The answer is no.  There is file inclusion
> > using server side includes, which is actually how it is done in ASP.
> > 
> > The thing to keep in mind is that 'includes' are synonymous with
> > 'inline functions' as in C programming.  The code just gets pasted to
> > the current 'page'.  So, if you could include a .cfm file within a
> > ...html file, the CFML would not get processed unless you told your Web
> > Server to run all .html files through your ColdFusion App Server,
> > something that is usually not recomended.  Check out Allaire's site.
> > There are some diagrams there on the interactions betwix web server,
> > cold fusion app server, and browser.  Ask yourself 'What actually
> > happens when I enter a URL and hit enter from my favourite browser?'.
> > 
> > I think your stuck changing your files to .cfm files.  opinions?
> > 
> > DK
> > 
> > 
> > 
> > From: [EMAIL PROTECTED] AT INTERNET on 04/04/2001 01:20 PM
> > 
> > To:   [EMAIL PROTECTED] AT INTERNET@CCMAIL
> > cc:(bcc: Douglas Knudsen/ATL/ALLTELCORP)
> > 
> > Subject:  RE: Includes on HtML?
> > 
> > 
> > You can CFINCLUDE a file with any extension.
> > 
> > -Original Message-
> > From: SHEETS, DAYV (PB) [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, April 04, 2001 12:21 PM
> > To: CF-Talk
> > Subject: Includes on HtML?
> > 
> > 
> > Hi All,
> > 
> > Another question.
> > 
> > Can you  from *.htm *.html based files? I want to be able
> > to
> > include a hit counter on some of our pages but not by not having them
> > changed to .cfm.
> > 
> > Thanks,
> > Dayv
> > 
> >
>
~~
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: CFSETTING "HTML Strings" *URGENT*

[Kelly Matthews]

Or just get rid of the quotes. Believe it or not whatever will work.

> -Original Message-
> From: bfalloon [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, April 05, 2001 10:05 AM
> To:   CF-Talk
> Subject:  CFSETTING "HTML Strings" *URGENT*
> 
> Hello,
> 
> Can someone help me with this problem?
> 
> I want to create a string that contains HTML. Specifically a 'path' string
> to be
> outputted at the top of a page with variable content. The problem that I
> have
> is that I need to do something like this...
> 
> Category  href="subcategory.cfm">Sub">
> 
> The problem is that because of the quotation marks within the string
> itself,
> it is terminating
> the CFSET command before it gets to the end of the string.
> 
> I'm not sure if I should use the converted HTML ie. < becomes < and so
> on
> because I need to output 'functional' HTML on the page below this CFSET,
> not
> 'display' HTML.
> 
> Can someone explain how this should be phrased.
> I may also need to append more string information onto the end of this
> string
> depending of other query results.
> 
> Thanks in advance!
> 
> Benjamin Falloon
> Objektmedia
> www.objekt.com.au
> 
> 
> 
>
~~
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: insert to two tables

[Kelly Matthews]

I do the same!

> -Original Message-
> From: Jason Green [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, April 05, 2001 5:40 PM
> To:   CF-Talk
> Subject:  Re: insert to two tables
> 
> i have had this issue before and the only way i could come up with it is 
> insert into the peopletable and then query it with the same info you just 
> inserted, thus giving you the id of that personthen insert into the 
> appointment table
> 
> it's a pain, but i haven't found an easier solution
> 
> jason
> 
> 
> >From: Aimee Abbott <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: CF-Talk <[EMAIL PROTECTED]>
> >Subject: insert to two tables
> >Date: Thu, 05 Apr 2001 14:08:41 -0600
> >
> >Hello everyone.
> >
> >I have mostly worked on very simple, single table, cold fusion projects
> but
> >now I need to do something where I need to add information into two
> >tables.  I have something like this:
> >
> >PeopleTable
> >personID Autonumber
> >name Text
> >address  Text
> >
> >AppointmentTable
> >aptIDAutonumber
> >PersonID Number
> >AptName  Text
> >AptDate  Date/Time
> >
> >The information for both tables come from one entry form on a web page.
> I
> >have a second page to do the insert.  When I insert the person into the
> >person table, how do I find out what the personID was so I can enter it
> >into the AppointmentTable/PersonID?  Or can I do some sort of more
> complex
> >insert statement that inserts into both tables at once?  What if I add a
> >third table?  Does it get more complex?  Should I setup the join as a
> >relationship in microsoft access?
> >
> >
> >
>
~~
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