[OT] disabling embedded slides in Windows Media

2001-03-22 Thread Jamie Keane

Hi folks, and apologies for veering out of CF-Land (but I'm at the 11th hour
and about ready to pull my hair out!).

What we have is a series of ASF files acting as a mini-presentation.  The
client encoded them originally for a framed presentation screen... but where
the movies are shown now is not a frameset.  Therefore, the slides
associated with the movie are popping up in a new window... most
disconcerting!  I'm told we have somehow fixed this in IE, but Netscape
still proves to be a problem.  What I'm getting at is:  Is there a way
within our object/embed declarations to force Media Player to discard
slide-display events?

If you have any suggestions, please let me know, preferably off-list
(because I'd feel bad for that much clutter on the list ;) ).

Thanks!
Jamie

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.849.7771 x 228  Voice
704.849.9291  Fax



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



Re: URGENT: Case Question

2001-01-26 Thread Jamie Keane

Use Compare().  It's case-sensitive.

HTH

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.849.7771 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Javed Mushtaq [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Friday, January 26, 2001 6:39 PM
Subject: URGENT: Case Question


Hi all,

Please could you tell me how i could verify if a password being posted from
another page
has the exact same case as the password in the database.

Eg password: Orange
But if enter orangE it evaluates to being true.

Please could you tell me how to determine if the password matches the entry
in every way.

Yours hopefully



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



[WAY OT] Media Player/Netscape wackiness

2001-01-18 Thread Jamie Keane

Hi all, and apologies for being so off-topic... but I've got a pretty tight
deadline and don't know where else to turn.

We have a client that wishes, for some reason, to have an .ASF file embedded
on their front page.  The current code allows a control-less display in IE,
but no matter how much I tweak the EMBED, the Netscape version still shows
the start/stop control.  Does anyone have experience with Windows Media
Player/Netscape interaction (and wouldn't mind helping me)?

Thanks in advance,
Jamie

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.849.7771 x 228  Voice
704.849.9291  Fax



~~
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: DELPHI - where does it fit in the scheme of things?

2001-01-09 Thread Jamie Keane

I remember that Nick Bradbury's original releases of Homesite (before HS was
bought by Allaire, which begat CFStudio...) was a Delphi app.  It would
stand to reason, then, that the current releases at least have some Delphi
floating around in them.  And wasn't there a known bug with how Delphi
handled Z-Order that caused CFStudio/HS that caused it not to "pop forward"
on window focus?  I recall having a problem with this at the previous job,
and I think it was attributed to a Delphi glitch.  I can't remember exactly.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.849.7771 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Marius Milosav [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Tuesday, January 09, 2001 9:00 AM
Subject: Re: DELPHI - where does it fit in the scheme of things?


Delphi is a client/server RAD development tool, developed by Borland
(Inprise or whatever they are called this days). Main competitors are
(were)
Visual Basic and PowerBuilder.

If I'm not mistaken ColdFusion Studio was built using Delphi. form more
information go to Borland home page.

Marius Milosav
www.scorpiosoft.com
It's not about technology, it's about people.
Virtual Help Desk Demo (VHD)
www.scorpiosoft.com/vhd/login.cfm

- Original Message -
From: "Joe Sheble aka Wizaerd" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, January 09, 2001 8:50 AM
Subject: RE: DELPHI - where does it fit in the scheme of things?


 For those that are using Delphi, what role does it play in the
 internet?  Is it being used strictly for COM access with CF, or are there
 hidden web abilities some of us may be unaware of?

 At 07:45 AM 1/9/01 -0600, you wrote:
 We use Delphi and CF here. The main reason for that is most of our
products
 have some standard application interfaces as well as web interfaces.
 
 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, January 09, 2001 1:48 AM
 To: CF-Talk
 Subject: RE: DELPHI - where does it fit in the scheme of things?
 
 
 
   What is Delphi?  Is it a peer to ASP and ColdFusion or is it more a
peer
   to VisualBasic and used for making COM Objects?
  
   Is it any good?
  
   Would you other webmasters live with ASP, ColdFusion AND Delphi in
your
   sites?
 
 Never used it, but I keep bumping into Delphi shops that also use CF.
 There's at least a couple of those folks on the mailing list somewhere.
 
 Delphi is basically the child of Pascal, like C++ was to C. Think of it
as
 Pascal++. Somewhere between Java and C++ in power/complexity. You can
make
 COM's with it. You can also make CFX's with it. Yes, it's roughly in the
 same league as VisualBasic, Java and C++.
 
 --min
 


~~
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: Stripping CRs and LFs

2001-01-09 Thread Jamie Keane

Couldn't you replace all instances of Chr(13) (I think that's right...) with
a null?

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.849.7771 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Bryan Batchelder [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Tuesday, January 09, 2001 9:13 AM
Subject: Stripping CRs and LFs


What is the best way to strip CRs and LFs from a string?

StripCR() gets the CRsbut I still have linefeeds (or CR/LF combos...)
left in the string.

I am doing this as part of cleaning up data from an SQL server to put into
a
..CSV file...and well, CSV doesn't handle random CR/LF very well :-)

Thanks in advance...

--b

--
Bryan BatchelderHome:727.547.1322
Web Application Developer   Work:813.935.7100 x427
Cell:727.460.6665
--
 Company:http://www.connectwise.com
Personal:http://pontiphex.stetsonsucks.com
 PGP Key:http://pontiphex.stetsonsucks.com/pgp.txt
--
At the macro level, it may appear that I am doing
nothing.  But at the cellular level I am really
quite busy.



~~
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 force CFOUTPUT to display results horizontally

2001-01-05 Thread Jamie Keane

After the output of a record, do this:
(assuming that breakpoint = 5)
#IIf(queryname.currentrow mod breakpoint,DE(""),DE("br"))#

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.849.7771 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Britta Wingenroth [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Friday, January 05, 2001 4:36 PM
Subject: Re: How to force CFOUTPUT to display results horizontally


Hi, I just used this and suddenly realized that, yes! all the images are
displaying horizontally from the query output, but unfortunately, they are
not breaking at the end of the table, but extending the table way off to
the
right.  Setting the table cells to the appropriate width has no effect.
Any
way of forcing it to break after, say five records have been output, and
then staring the new row?

record record record record record
record record record record record

instead of

record record record record record record record record record record

Thanks a lot,
Britta

- Original Message -
From: "Britta Wingenroth" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Thursday, January 04, 2001 8:24 PM
Subject: How to force CFOUTPUT to display results horizontally


 I would like to display the results of the Cfoutput tag running
 horizontally, ie.

 tdimage image image image/td
 instead of

 td
 image
 image
 image
 image
 /td

 Is there any way that I can do this?  Any help would be greatly
appreciated.

 Britta





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



preparing for CF certification...

2001-01-02 Thread Jamie Keane

Hi folks.  I'm thinking about going for my Allaire CF Certification in the
moderately near future.  What are some of the things I can do to help
prepare?

Just looking for suggestions. :)

Thanks and hope you all had a happy and safe New Year's!
Jamie

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.849.7771 x 228  Voice
704.849.9291  Fax


~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free 
Setup from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support 
 Visit SoloServer, https://secure.irides.com/clientsetup.cfm.

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



Re: preparing for CF certification...

2001-01-02 Thread Jamie Keane

I've done that and scored a Master's Certification from it.  Thanks though.
:)

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.849.7771 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Nick Betts [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Tuesday, January 02, 2001 10:14 AM
Subject: RE: preparing for CF certification...


Try looking at www.brainbench.com. They have a free certification exam on
there which is good prep.

Nick Betts

-Original Message-
From: Jamie Keane [mailto:[EMAIL PROTECTED]]
Sent: 02 January 2001 15:18
To: CF-Talk
Subject: preparing for CF certification...


Hi folks.  I'm thinking about going for my Allaire CF Certification in the
moderately near future.  What are some of the things I can do to help
prepare?

Just looking for suggestions. :)

Thanks and hope you all had a happy and safe New Year's!
Jamie

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.849.7771 x 228  Voice
704.849.9291  Fax

~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free 
Setup from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support 
 Visit SoloServer, https://secure.irides.com/clientsetup.cfm.

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



Re: Sessions/cookies

2001-01-02 Thread Jamie Keane

CF usually doesn't care about case (except for string comparison functions
that aren't of the "NoCase" variety), but if you wanted to fake
case-insensitivity just in case, use lcase() on the strings.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.849.7771 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Jeffry Houser [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Tuesday, January 02, 2001 12:29 PM
Subject: Re: Sessions/cookies



  I don't know if you missed my additional comments in the code or not, but
just
to re-specify,

You use CFPARAM to set the default to 'na' and when you check the
value (in the else statement) you are checking for 'NA' .  Technically, the
two values are different.  Does anyone know if the CF default is to check
cases or not?  It's the only other idea I can think of...


Michael Ross wrote:

 Yes thats exactly what it should do.  But in the first instance I define
the session.user_name as a unique number.  so the next time round it will
update the table.  I know why the query isn't working, it shouldn't be
getting the na in the first place.

--
Jeff Houser | mailto:[EMAIL PROTECTED]
AIM: Reboog711  | ICQ: 5246969 | Phone: 860-229-2781
--
Instant Cold Fusion 4.5  | ISBN: 0-07-213238-8
Due out 3rd Quarter 2001
--
DotComIt, LLC
database driven web data using ColdFusion, Lotus Notes/Domino
--
Half of the Alternative Folk Acoustic Duo called Far Cry Fly
http://www.farcryfly.com | http://www.mp3.com/FarCryFly
--
Promise me no dead end streets, and I'll guarantee we'll have a road




~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free 
Setup from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support 
 Visit SoloServer, https://secure.irides.com/clientsetup.cfm.

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



Access. um, access on a Linux box

2001-01-02 Thread Jamie Keane

Hi everyone,

I have been asked to determine if there is a way for a client to run a
CF/Linux/Apache box and maintain all DBs on a separate NT machine.  Is there
a good ODBC bridge that will fix this (preferably free/OSS)?

I'm looking at a few potential possibilities, but I wanted to see if any of
you have already solved my problem. :)

Thanks,
Jamie

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.849.7771 x 228  Voice
704.849.9291  Fax


~~
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: Access. um, access on a Linux box Redux

2001-01-02 Thread Jamie Keane

Oops.  I forgot to add:

The two datasources we'd be connecting to are an Access DB and an Oracle DB.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.849.7771 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Jamie Keane [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Tuesday, January 02, 2001 4:56 PM
Subject: Access. um, access on a Linux box


Hi everyone,

I have been asked to determine if there is a way for a client to run a
CF/Linux/Apache box and maintain all DBs on a separate NT machine.  Is
there
a good ODBC bridge that will fix this (preferably free/OSS)?

I'm looking at a few potential possibilities, but I wanted to see if any of
you have already solved my problem. :)

Thanks,
Jamie

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.849.7771 x 228  Voice
704.849.9291  Fax



~~
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: Access. um, access on a Linux box

2001-01-02 Thread Jamie Keane

The thing is these are existing datasources, and the admin who's going to be
in charge of maintaining the servers has minimal NT experience.  He wants to
migrate over to Linux where the client was once using NT/Apache.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.849.7771 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Ryan [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Tuesday, January 02, 2001 5:05 PM
Subject: Re: Access. um, access on a Linux box


At 17:05 1/2/01 -0500, you wrote:
Hi everyone,

I have been asked to determine if there is a way for a client to run a
CF/Linux/Apache box and maintain all DBs on a separate NT machine.  Is
there
a good ODBC bridge that will fix this (preferably free/OSS)?

I'm looking at a few potential possibilities, but I wanted to see if any
of
you have already solved my problem. :)

You can run MySQL on a Winbox, but their license was worded such that
it was not free if you were running on Windows. I don't know if its
still that way.

You can connect to MSSQL on a winbox from Linux/CF.

I have no idea why anyone would *want* their data running on
a winbox if they were running everything else on a linux box.
MySQL is quick and easy to setup on linux, they could just put
their data there.

RPS



~~
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: OT- HTH

2000-12-29 Thread Jamie Keane

Hope This Helps. :-)

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.849.7771 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Guy J. McDowell [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Friday, December 29, 2000 8:35 AM
Subject: OT- HTH


Okay, I've seen a million people use HTH in their signatures or
sign-offs.
I can't figure it out. I guess I'll just have to return my Mensa
membership card...
Please tell me what it means, I get a headache when I don't know
everything!
;0)

Yours In Conservation,

Guy J. McDowell,
Webmaster
The Ontario Federation of Anglers  Hunters
E-mail: [EMAIL PROTECTED]
Phone: (705) 748-6324 ext. 262
www.OFAH.org



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



~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free 
Setup from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support 
 Visit SoloServer, https://secure.irides.com/clientsetup.cfm.

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



Re: Forfields WDDX

2000-12-29 Thread Jamie Keane

What you could do is convert the formfields to a struct (or a query set, if
that suits you) by assigning key values or column values whilst looping over
the form.fieldnames list.  Then WDDX-ify the resulting dataset and you're
good to go. :)

I wrote an inhouse custom tag that does the dirty work of converting it to a
struct, and I could email it to you if you'd like.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.849.7771 x 228  Voice
704.849.9291  Fax
-Original Message-
From: paul smith [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Friday, December 29, 2000 5:15 PM
Subject: RE: Forfields  WDDX


Thanks!  I was thinking it would be easier in 4.5 than 4.0.1
I'll have to settle for the 4.0.1 version for now.

best,  paul

At 04:53 PM 12/29/00 -0500, you wrote:
In 4.5, you get a structure called "form" that you can do this with:

cfwddx action="CFML2WDDX" input="#form#" output="aWDDXpacket"

Then you can save that string, aWDDXpacket, as a client variable.

Hal Helms
== See www.ColdFusionTraining.com  for info on "Best Practices with
ColdFusion  Fusebox" training, Jan 22-25 ==


-Original Message-
From: paul smith [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 29, 2000 4:38 PM
To: CF-Talk
Subject: Forfields  WDDX


What's a slick way to put all FormFields (name  value) into WDDX for
placement into a client variable?

best,  paul


~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free 
Setup from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support 
 Visit SoloServer, https://secure.irides.com/clientsetup.cfm.

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



Re: how do i delete client vars?

2000-12-28 Thread Jamie Keane

Use DeleteClientVariable.  To get a list, use GetClientVariablesList().

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.849.7771 x 228  Voice
704.849.9291  Fax
-Original Message-
From: S R [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Thursday, December 28, 2000 12:50 PM
Subject: how do i delete client vars?


I know how to delete a session variable using:

cfset structdelete(session, "myVariable")

it works fine but I tried it with a client variable:

cfset structdelete(client, "myVariable")

and I got an error.

~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free 
Setup from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support 
 Visit SoloServer, https://secure.irides.com/clientsetup.cfm.

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



Re: Select Distinct problems

2000-12-27 Thread Jamie Keane

What you may wish to do is perform a UNION query and alias each subquery's
column to the same name.  That's worked for me in the past.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Todd Ashworth [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Wednesday, December 27, 2000 3:05 PM
Subject: Re: Select Distinct problems


Are these tables related in any way?

What the SQL server is doing is returning every distinct row it can make
up.

Say you have table 1 contains A and B and table 2 conatins 1, 2, and 3.
With your query you end up with this

A 1
A 2
A 3
B 1
B 2
B 3

As you can see .. all of these are indeed distinct rows, but probably not
what you wanted.

I'm gusing you want something like this:

A
B
1
2
3

right?

Todd Ashworth

- Original Message -
From: "W Luke" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, December 27, 2000 2:38 PM
Subject: Select Distinct problems


| Hi,
|
| I've used SELECT DISTINCT email FROM EMAILS successfully, but now I am
| trying to select 2 columns from 2 different tables, as follows, to obtain
x
| unique email address from the columns "email" and "email2", part of the
| tables "EMAILS" and "EMAILS2" respectively.
|
| cfquery name="getemails" datasource="emails"
| SELECT distinct email,email2 FROM EMAILS,EMAILS2
| /cfquery
|
| After a lot of crunching from my server, it just timed out, and I needed
to
| restart CF App server to operate the comp again as it had tied up all the
| resources.  I suppose I'm using the wrong SQL - could someone explain
what
I
| have to do?
|
| Cheers
|
| Will
|
|
|

~ Paid Sponsorship ~
Get Your Own Dedicated Win2K Server!  Instant Activation for $99/month w/Free Setup 
from SoloServer  PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support  Visit 
SoloServer, https://secure.irides.com/clientsetup.cfm.

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



importing session variables?

2000-12-20 Thread Jamie Keane

Hi all,

I'm working on a project that requires me to use two different
application.cfm templates in separate directories.  What we need to do is be
able to access some of the session variables from the root directory in its
child directory.  Is there any way we could import only the session
variables that matter to both applications?  We'd prefer not to include the
parent Application.cfm in the child, since that's just messy.

Thanks!
Jamie

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax


~~
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: Cool CF site - webos.org

2000-12-19 Thread Jamie Keane

The fact that they don't have the +.htr bug patched.  Very interesting.

Cheers,
Jamie

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Gena [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Monday, December 18, 2000 5:41 PM
Subject: Re: Cool CF site - webos.org


Pardon,

do you mean this web site or my message???

Regards


- Original Message -
From: "Jamie Keane" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, December 19, 2000 9:20 AM
Subject: Re: Cool CF site - webos.org


 *ROFL*

 That's the funniest thing I've seen this month!

 --
 Jamie Keane
 Programmer
 SolutionMasters, Inc.
 9111 Monroe Rd., Suite 100
 Charlotte, NC  28270
 www.solutionmasters.com
 704.563.5559 x 228  Voice
 704.849.9291  Fax
 -Original Message-
 From: Gena [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Date: Monday, December 18, 2000 4:54 PM
 Subject: Re: Cool CF site - webos.org


 And what is cool on this site? I found only one thing - it is possible
to
 get all source code from this URL. It is not cool.
 
 - Original Message -
 From: "Eric Fickes" [EMAIL PROTECTED]
 To: "CF-Talk" [EMAIL PROTECTED]
 Sent: Tuesday, December 19, 2000 8:00 AM
 Subject: Cool CF site - webos.org
 
 
  Hello all,
 
  I was wondering if any of you have seen/used www.webos.org yet?  I
 noticed
  that it's using CF, so I was hoping that some of you may have an
answer
 to
  my question.  WebOs emulates a desktop, and pops up windows within one
 large
  parent window.  I would love to do this on my inhouse site for
navigation
  and was wondering if any of you knew how to do this.
 
  E
 
 
 
 


~~
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: Name are Intranet !!

2000-12-18 Thread Jamie Keane

Sex and food?  Well then, I suggest... banana.

(I could get worse.  Really.)

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Todd Ashworth [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Friday, December 15, 2000 9:24 PM
Subject: Re: Name are Intranet !!


ahh ... sex and food at the same time .. who can beat that? ;)

Todd

- Original Message -
From: "Rif Kiamil" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, December 15, 2000 4:49 PM
Subject: RE: Name are Intranet !!


 Sell Food to End Users.


  -Original Message-
 From: Greg Wolfinger [mailto:[EMAIL PROTECTED]]
 Sent: 15 December 2000 18:44
 To: CF-Talk
 Subject: Re: Name are Intranet !!

 Rif:

 It should be name OUR intranet, not arewhat exactly does your company
 do?

 -Greg




~~
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: CFHeader

2000-12-18 Thread Jamie Keane

HTTP headers are different from META tags in that they are handled
completely on-server.  CFLOCATION is a front-end for a commonly-used HTTP
header, a location redirect.  I also use them for setting expiration dates
for served documents, to prevent caching.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Michael She [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Monday, December 18, 2000 10:42 AM
Subject: CFHeader





Does CF header generate meta tags, or are HTTP responses something
  different?



Thanks.



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: Cool CF site - webos.org

2000-12-18 Thread Jamie Keane

*ROFL*

That's the funniest thing I've seen this month!

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Gena [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Monday, December 18, 2000 4:54 PM
Subject: Re: Cool CF site - webos.org


And what is cool on this site? I found only one thing - it is possible to
get all source code from this URL. It is not cool.

- Original Message -
From: "Eric Fickes" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, December 19, 2000 8:00 AM
Subject: Cool CF site - webos.org


 Hello all,

 I was wondering if any of you have seen/used www.webos.org yet?  I
noticed
 that it's using CF, so I was hoping that some of you may have an answer
to
 my question.  WebOs emulates a desktop, and pops up windows within one
large
 parent window.  I would love to do this on my inhouse site for navigation
 and was wondering if any of you knew how to do this.

 E




~~
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 many milliseconds is too many?

2000-12-15 Thread Jamie Keane

Is there any way you could consolidate the queries, ie find some common
ground to perform a join on?

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Todd Ashworth [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Friday, December 15, 2000 11:06 AM
Subject: Re: how many milliseconds is too many?


| However, 3.6 seconds is a lengthy time for a page to be processing.

Yes, it is.  That's why I was concerned about how much of an impact it
would
have on the application and the server once users started using it for
real.
I would hate to lauch the site and then have it die pitifully under normal
use and have to go back a do a rewrite.

The page pulls data from 6 different tables and performs several loops in
the process.  Unfortunately, I can't figure out how to make it go any
faster.  I'm sure a stored procedure would help, but it was all I could do
to get it written in CF, heh.

Todd Ashworth

- Original Message -
From: "Greg Wolfinger" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, December 15, 2000 10:21 AM
Subject: Re: how many milliseconds is too many?


| Todd:
|
| It all really depends.  You can't accurately determine the number of
users
| until your server will crash.  It all depends on what the page is doing
and
| such.  However, 3.6 seconds is a lengthy time for a page to be
processing.
|
| -Greg
| - Original Message -
| From: "Todd Ashworth" [EMAIL PROTECTED]
| To: "CF-Talk" [EMAIL PROTECTED]
| Sent: Thursday, December 14, 2000 7:33 PM
| Subject: how many milliseconds is too many?
|
|
|  Say I have a page that takes about 3,600 ms to process.  Does anyone
know
|  how much traffic that page can handle before killing the server .. or
at
|  least until the app becomes unusable?
| 
|  Todd Ashworth
| 
| 
| 
| 
|

~~
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: Alternating TR colors

2000-12-15 Thread Jamie Keane

Initialise your counter to 0.

Output your TR, with the IIF statement determining the row colour (like your
standard currentrow snippet would do).

Set counter equal to counter = 1.

Voila!

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Ryan [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Friday, December 15, 2000 1:18 PM
Subject: Alternating TR colors


Lets say I wanted the background color of each row in a table to be
different colors. I found this code:

COLOR=###IIF(QueryName.currentrecord MOD 2, DE ('E9E7CF'), DE ('FFA768'))#

But I'm not looping through a query, I'm just manaully writing table rows,
BUT, some of the rows may not always be displayed, so I can't just hardcode
the color values, because then you'd have two rows right after each other
that are the same color.

In perl I would just write a function that increments a counter and returns
the new result. Like:

COLOR=###IIF(MyIncrementFunc(counter) MOD 2, DE ('E9E7CF'), DE ('FFA768'))#

How can I accomplish this in ColdFusion?

Thanks,

Ryan





~~
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: IsNumeric Function

2000-12-15 Thread Jamie Keane

You shouldn't need the quotation marks around the parameter passed to
IsNumeric().  Try that.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Greg Wolfinger [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Friday, December 15, 2000 12:28 PM
Subject: IsNumeric Function


Hey Guys/Gurls:

I am trying to do some server side validation for a phone number, but I am
running into an odd problem.  I split the phone number entry form into three
textboxes the first one for area code (ie must be 3 numbers) and then the
two parts of the phone number (ie must be 3 numbers and then must be 4
numbers).  I check to make sure the length of each textbox is correct and
then I try to check if they are numeric, however it will throw an error.

My code looks something like this:

cfif not IsNumeric("attributes.custPhone1") or not
IsNumeric("attributes.custPhone2") or not
IsNumeric("attributes.custPhone3")
cfset attributes.error = attributes.error  "Please enter a valid
phone number.br"
/cfif

The strange part is that when I take out the not IsNumeric() statements for
the first two form variables it works fine.  Ideas???

-Greg



~~
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: Detecting if JavaScript is enabled with Cold Fusion

2000-12-15 Thread Jamie Keane

There really isn't a way to determine it with CF, but there is a workaround
in HTML.  You can use a NoScript block to contain verbiage and/or code in
the event of the browser being able to see the JS block but not being able
to act on it.

There's a custom tag somewhere in the gallery that simplifies the process
somewhat.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Jerry Tolentino [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Friday, December 15, 2000 4:56 PM
Subject: Detecting if JavaScript is enabled with Cold Fusion


Anyone know how to detect if JavaScript is enabled on the client machine
using Cold Fusion???

Thanks in advance

Jerry




~~
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: Making changes to a live Database

2000-12-14 Thread Jamie Keane

To complement what Daniel wrote, if you're going to run more than one alter
statement, wrap them in a transaction.  That way, you can test all you want,
and should something screw up down the chain, the DB will revert to its
original state.  It makes life easy.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Daniel Lancelot [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Thursday, December 14, 2000 5:49 AM
Subject: RE: Making changes to a live Database


I suggest using an ALTER TABLE SQL statement - look up ALTER TABLE in
access
help (JET SQL) (I always create the statement  on my development box - test
it does what I want, then run it through a CF page on the live box...)

HTH

Dan

-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: 14 December 2000 10:31
To: CF-Talk
Subject: Making changes to a live Database


Hi,

I have a small change to make to a live database (create a new column in a
table) which is in Access.  I don't really want to download it and upload
it
again, as I will undoutedly lose data (or visitors will get an error).  So
I
was wondering what people's experiences are of this kind of situation and
how best to handle it.

Rgds

Will
www.localbounty.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: Another debate

2000-12-14 Thread Jamie Keane

It has COM support on NT only.  The downside is if you wanted to migrate
servers from NT to Unix, you're kinda hosed if you were using COM objects.

Jamie

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: lsellers [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Thursday, December 14, 2000 2:08 AM
Subject: RE: Another debate



 #2. Extensible into Java/COM/etc
 #2 and #4 are not available in PHP, nor is formal support available

Not that I really know what the hell I'm talking about as far as PHP goes,
but I thought php4 had COM support(?).

--min



~~
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: Decrypting

2000-12-14 Thread Jamie Keane

I know there is an encrypt/decrypt CFX on Allaire's DevEx site.  Worth a
check-out!

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Kevin Schmidt [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Thursday, December 14, 2000 12:14 PM
Subject: Decrypting


I know I saw the URL for a site that allows decryption of CF
filesanybody got it???

Kevin Schmidt, Web Technology Manager
Allaire Certified Cold Fusion Developer
pwb inc.
integrated marketing communications
350 S. Main St., Suite 350
Ann Arbor, MI 48104
734.995.5000 (tel)
734.995.5002 (fax)
www.pwb.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: cftry cfcatch/cfcatch/cftry

2000-12-13 Thread Jamie Keane

Alternately, you could have a main page that has a cftry/cfcatch block, and
include the meat of the page within (a la Fusebox).  Worth a shot, neh?

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Neil H. [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Wednesday, December 13, 2000 11:37 AM
Subject: cftry cfcatch/cfcatch/cftry


I just found, disappointingly enough that you can't have a cftry at the
top of a document via a CFinclude and the rest in another include at the
bottom?  Is there a work around.  I don't want to use a handler, and I want
the same error checking code on every page.

Please advise or throw ideas (even bones will do)

Thanks,

Neil

p.s. Running CF 4.51.

- Original Message -
From: "Hales, John M" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, December 13, 2000 11:17 AM
Subject: RE: CFreport and crystal reports


 I could never get it to work. We just use CF to pass the parameters to
 Crystal, and the CR Web Server to display the reports. That works well
for
 us.

 HTH
 Mike Hales

 -Original Message-
 From: Katie Bessiere [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, December 13, 2000 11:08 AM
 To: CF-Talk
 Subject: CFreport and crystal reports


 has anyone had any luck using CFREPORT with crystal reports 8?  i've
tried
 the workaround that Allaire recommends and I still can't get the tag to
 work.  It's very frustrating..

 If anyone has any ideas, please let me know..

 katie

 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: Another debate

2000-12-13 Thread Jamie Keane

Well, the two are really different critters.  It could be said that PHP is
more secure since it is open source, therefore flaws can, in theory, be
discovered (and hopefully patched) quicker.  As for other discussion along
the lines of "CF is a better platform because it's easier to write in", it
really depends on your style of programming.  If you're most comfortable
dealing with logical pseudo-extensions to an HTML-style programming system,
of course CF is for you.  It's tag-based to ease the transition between
static HTML and dynamically-generated templates.  PHP, OTOH, is very
reminiscent of Perl, so if your department is strong in Perl you'll love
PHP.

The down side of PHP is its fairly non-existant error handling capabilities
and lack of DB abstraction.  You will have to be familiar with different
function sets to use different DBs.  If you're a non-programmer, it is a bit
trickier to learn, since you'll have to work with creating file pointers and
whatnot on occasion.  And PHP doesn't include Verity or any other nifty
toys, so you're on your own.  On the plus side, PHP currently supports
user-defined functions, which makes for very structured, elegant code.

I haven't tried out PHP's session support, however, so I can't comment on
that.  Chances are, though, that CF has a better implementation, though,
simply because CF has had session support longer.

Also, what web server/OS are you running?  That's also a big part of the
picture, and arguably more important than the application server you're
using.

Jamie
(best tool for the job, et cetera, et cetera)

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Kelly Shepard [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Wednesday, December 13, 2000 1:04 PM
Subject: Another debate


The new boss has arrived in my department and of course he wants everyone
to
switch from the awesome and all mighty cold fusion to  PHP. We do need
some other strengths in our department for those clients who don't want us
to host their application or don't have cf on their server, but, he wants a
complete switch.  Here is a glimpse into his last email:

"It could be argued that both technologies have their strengths and
weaknesses. However, in the corporate IT department, CF is usually not an
option due to cost and security problems. I realize that changing
perceptions and old habits are sometimes difficult, but necessary.
Especially in our industry (high-tech).

The need to deliberate the issue further is a mute point."

Does anyone have any opinions on his security problems comment?  It seems
that alliare is pretty good about getting patches up - or we have just been
lucky and not had any problems.  And, would you agree that in the corporate
IT department cf is "usually" not an option?

Thanks in advance for any input.



~~
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: Just a stray thought

2000-12-13 Thread Jamie Keane

Yes, I'm interested too.  Send it on up!

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Andres [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Wednesday, December 13, 2000 12:13 PM
Subject: RE: Just a stray thought



Can you send the URL where you read this??


-Original Message-
From: Gregory Harris [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 13, 2000 11:36 AM
To: CF-Talk
Subject: Just a stray thought


Ok, this is meant as no shameless plug but I read on their website:

UPS expects to receive 5 million tracking requests on their website per day
especially on their peak days (it reads something like that)

Your mission: build a Cold Fusion application for UPS that could handle
such
a beating, how would you do this?  Bear in mind:

1) You will have to search through a database of approximately 245 million
records (packages delivered)

2) 5 million per day equals 60 per second, transactional integrity has to
be
TIGHT!

3) Money is no real object (UPS needs this to work some how, but be
realistic in terms of "what you get is what you pay for")

Who's up for this?

Gregory Harris
Web Developer
Stirling Bridge Group LLC

~~
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: Another debate

2000-12-13 Thread Jamie Keane

Above all-out evangelisation, the only thing that could stand up against the
IT boss in question is solid facts.  Present speed test results,
testimonials, and other basically-factual data.  Ask him why is it, exactly,
that he considers CF a security risk and PHP not one.  If the boss is at
least somewhat reasonable, he'll at least hear your concerns.  If he's
completely unresponsive, then it really doesn't reflect well on his ability
to manage, does it?

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Kevin Schmidt [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Wednesday, December 13, 2000 4:47 PM
Subject: Re: Another debate


Tell your boss to go out to the garage and use the head puller to pull his
head out of his ass.  CF is far above PHP in my mind and why would you want
to tell all of your developers hey forget what you know and learn this new
technology.  I could understand if you were all COBOL programmers and
wanted
to learn something new but CF is a great technology and as I said far
superior in my mind.


- Original Message -
From: "Kevin Schmidt" [EMAIL PROTECTED]
To: "Kevin Schmidt" [EMAIL PROTECTED]
Sent: Wednesday, December 13, 2000 12:39 PM
Subject: Fw: Another debate



 - Original Message -
 From: Kelly Shepard [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Wednesday, December 13, 2000 12:14 PM
 Subject: Another debate


  The new boss has arrived in my department and of course he wants
everyone
 to
  switch from the awesome and all mighty cold fusion to  PHP. We do
need
  some other strengths in our department for those clients who don't want
us
  to host their application or don't have cf on their server, but, he
wants
 a
  complete switch.  Here is a glimpse into his last email:
 
  "It could be argued that both technologies have their strengths and
  weaknesses. However, in the corporate IT department, CF is usually not
an
  option due to cost and security problems. I realize that changing
  perceptions and old habits are sometimes difficult, but necessary.
  Especially in our industry (high-tech).
 
  The need to deliberate the issue further is a mute point."
 
  Does anyone have any opinions on his security problems comment?  It
seems
  that alliare is pretty good about getting patches up - or we have just
 been
  lucky and not had any problems.  And, would you agree that in the
 corporate
  IT department cf is "usually" not an option?
 
  Thanks in advance for any input.
 
 
 

~~
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 are the recognized CF variable scopes?

2000-12-12 Thread Jamie Keane

In essence, refering to variables outside the scope of a tag is analogous to
using global variables in other languages, something that was frowned upon
in the books I read and the courses I took.  The proper way, then, would be
to explicitly pass all necessary parameters to a tag, and eliminate the
uncertainty.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: David Shadovitz [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Tuesday, December 12, 2000 10:29 AM
Subject: Re: What are the recognized CF variable scopes?


Jeff,

I'm with you.  When I raised this issue in December '99, Dave Watts
pointed out that just because you can do something doesn't mean that you
should.

-David

On Wed 06 Dec 2000 Jeffry Houser [EMAIL PROTECTED] wrote:
 Shouldn't custom tags be coded to be as self-contained as
 possible?  If you need to access values in the custom tag,
 wouldn't it make more sense to pass them as attributes to
 the custom tag, as opposed to globally defining them?

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



error upon verity access

2000-12-11 Thread Jamie Keane

Hi all,

I'm having a bit of a problem with a Verity collection (in tandem with
Allaire Forums).  For some reason I now receive the following error upon
accessing it with a CFSEARCH command:
Collection failed to open: collection_name

(collection_name is not a literal; it's the name of the collection in
question.)

I've tried to repair the collection through the administrator, which seems
to work fine, but doesn't fix the problem.  Any other ideas about what to
do?

Thanks!



--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax


~~
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: variables passed en masse - what is the tag?

2000-12-07 Thread Jamie Keane

It's CF_EMBEDFIELDS.  I based a form-to-struct tag on its logic.  Cool
stuff!

(I know in 4.5 form is a struct, but we're dealing with 4.0 here)

Do a search for "Forta" in the DevEx, and you'll find some nice derivatives
of his works.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Daniel Lancelot [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Thursday, December 07, 2000 9:13 AM
Subject: RE: variables passed en masse - what is the tag?


There is a tag, i've used it - its available on allaire tag gallery - I
believe its written by Ben Forta - cant remember whatits called... very
simple though - loops through #form.formfields# creates an input type =
hiidden... for each one...

: -Original Message-
: From: Walker, Matthew [mailto:[EMAIL PROTECTED]]
: Sent: 07 December 2000 03:49
: To: CF-Talk
: Subject: RE: variables passed en masse - what is the tag?
:
:
:  I remember several replies to a previous question where a
:  tag was referenced
:  that gathered all the variables on a form and passed them to
:  subsequent
:  pages
:  what was that tag - I hope I'm not dreaming but it would
:  help to replace
:  hidden fields.
:
: How about something like (needs CFServer 4.5)
:
: cfloop item="ThisField" collection=#Form#
: input type="hidden" name="#ThisField#"
: value="#Evaluate("Form.#ThisField#")#"
: /cfloop
:
:
:

~~
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: passing cfquery results to another page

2000-12-07 Thread Jamie Keane

Convert the query to a WDDX packet, and store the packet as a hidden form
field.  I've done it before, and it works pretty well.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: sam sidhom [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Thursday, December 07, 2000 9:59 AM
Subject: passing cfquery results to another page


Can anyone tell me if there is anyway CF will pass the results of a CFQuery
to another page without having to requery the database?

Thanks,

Jennifer Johnson


~~
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: Slightly OT....HTML question

2000-12-05 Thread Jamie Keane

Egads, that's a big number.  What we commonly use for a drill-down is the
TwoSelectsRelated tag (or if the data is sufficiently cumbersome,
ThreeSelectsRelated).

Jamie

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Todd Ashworth [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Tuesday, December 05, 2000 8:53 AM
Subject: Re: Slightly OTHTML question


| Does anyone know if there is a known issue here and if so is there a way
| around it?

Yes .. strike the client about the head firmly and repeatedly until they
understand the foolishness of their ways ;)

What in the world would you need 7,000 entries in a single select box?  Is
there a way you could split that up, or drill down to a more manageable
number?

Todd Ashworth

- Original Message -
From: "Andy Ewings" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, December 05, 2000 7:53 AM
Subject: Slightly OTHTML question


| I have a form with a select control that loads approx 7000 options into
it
| (I know this is stupid but it's what the client wants).  When I view the
| form on a PC it's fine.  However on a Mac I see nothing.  When I reduce
the
| number of entries to about 4,500 I can see them on the Mac.
|
| Does anyone know if there is a known issue here and if so is there a way
| around it?




~~
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: Big companies using CF

2000-12-05 Thread Jamie Keane

I believe www.roomstogo.com is CF-based (and FuseBox-based to boot!).

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Todd Ashworth [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Tuesday, December 05, 2000 8:36 AM
Subject: Re: Big companies using CF


Autobytel.com

You can also look here for a list:

http://www.allaire.com/casestudies/index.cfm

Todd Ashworth

- Original Message -
From: "Joe Sheble aka Wizaerd" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, December 04, 2000 9:18 PM
Subject: Big companies using CF


| I know this is probably one of those discussions that turn up all the
time
| on a mailing list such as this, and I apologize for bringing it up.  I
have
| a new IT Director starting at my company in the very near future who's a
big
| Microsoft fan, and thinks there's nothing better than ASP and/or C#
(which
I
| believe hasn't even been released yet, no?).
|
| When I told him that CF has been around for a long time, and some really
big
| companies use it, he doubted it.  I told him Amazon.com was using it (was
I
| right about this?).
|
| So anyway, I've agreed to compile a list of some of the bigger well known
| internet comapnies using it, and would like some assistance.  What big
time
| comapnies are using CF for their pages?




~~
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: Slightly OT....HTML question

2000-12-05 Thread Jamie Keane

Basically what they do is whip together two or three select boxes that are
tied with Javascript.  Select a category in Box 1, and the categories linked
to your selection show up in Box 2.  Change the selection in Box 1 again,
and Box 2's contents change to reflect a new category.  Spiffy!

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Andy Ewings [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Tuesday, December 05, 2000 9:54 AM
Subject: RE: Slightly OTHTML question


Thanks.  I'll have a lok at these tags.  Can you give me a brief desription
as to what they do?

--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
--
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
--
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 419 4235
--
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute,
or
retain this message. Please notify us on +44 (0)207 387 8890.



-Original Message-
From: Dick Applebaum [mailto:[EMAIL PROTECTED]]
Sent: 05 December 2000 14:11
To: CF-Talk
Subject: Re: Slightly OTHTML question


Andrew

You can try allocating more memory to the browser on the Mac.

A better approach might be to use something like twoSelectsRelated or
ThreeSelectsRelated custom tags availab at allaire.

At least you could break the unwieldy number of entries into smaller
groups.

HTH

Dick


At 12:53 PM + 12/5/00, Andy Ewings wrote:
I have a form with a select control that loads approx 7000 options into it
(I know this is stupid but it's what the client wants).  When I view the
form on a PC it's fine.  However on a Mac I see nothing.  When I reduce
the
number of entries to about 4,500 I can see them on the Mac.

Does anyone know if there is a known issue here and if so is there a way
around it?
--
Andrew Ewings

~~
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: deallocate

2000-12-04 Thread Jamie Keane

I know that there's a scope defined for ordinary variables on a page.  It's
the "variables" scope, right?  Anyway, whatever its name is, do you know if
it's a struct too?  Thanks.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Dave Watts [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Monday, December 04, 2000 10:04 AM
Subject: RE: deallocate


 is there any function or method that would allow me to
 deallocate a variable after its been created and used?

There's no explicit way to deallocate variables; typically, you simply wait
for their scope to close. However, if the variable is part of a structure,
you can delete it from the structure, which should suffice. Many variables,
such as Session variables, are stored within structures.

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

2000-12-04 Thread Jamie Keane

Are there any issues with using the request scope in lieu of the variable
scope?  Or is the fact that one's a struct the only difference?

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Simon Horwith [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Monday, December 04, 2000 2:03 PM
Subject: RE: deallocate


Apparently the variables scope is not a struct.  Mr. Dave Watts pointed
this
out to me, after my posting this e-mail.  Learn something new everyday, I
suppose.  The variables scope does hold the local variables on a page,
usually.  If you want to store your variables in a "local" scope structure,
write them to the request scope.

~Simon

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



-Original Message-
From: Simon Horwith [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 04, 2000 11:39 AM
To: CF-Talk
Subject: RE: deallocate


indeed it is... on both counts.

~Simon

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



-Original Message-----
From: Jamie Keane [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 04, 2000 11:15 AM
To: CF-Talk
Subject: Re: deallocate


I know that there's a scope defined for ordinary variables on a page.  It's
the "variables" scope, right?  Anyway, whatever its name is, do you know if
it's a struct too?  Thanks.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Dave Watts [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Monday, December 04, 2000 10:04 AM
Subject: RE: deallocate


 is there any function or method that would allow me to
 deallocate a variable after its been created and used?

There's no explicit way to deallocate variables; typically, you simply
wait
for their scope to close. However, if the variable is part of a structure,
you can delete it from the structure, which should suffice. Many
variables,
such as Session variables, are stored within structures.

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: ColdFusion for Dummies revision - CF5 features

2000-12-04 Thread Jamie Keane

O!  This makes me very happy, and will certainly make the other
developers happy as well.  We've been lamenting the lack of UDFs for a good
while.  Thanks for the pointer!

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Alex Aguilar [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Monday, December 04, 2000 1:38 PM
Subject: Re: ColdFusion for Dummies revision - CF5 features


Taken from CFVault's summary of Allaire DevCon:
[http://www.cfvault.com/index.cfm/mode/DisplayContent/ContentElementID/64/E
l
ementPage/2]

CF 5.0 will be built on the existing codebase, and released during the
first
half of 2001. It is NOT part of the Pharaoh initiative, the next generation
of Allaire application server platform.

Here are some of the CF 5.0 features:
  a.. User defined functions and functions libraries.
  b.. Ability to run queries against existing query result sets (CFSQL).
  c.. Partial page output.
  d.. Server side graphic engine.
- Original Message -
From: "Angél Stewart" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, December 04, 2000 7:56 AM
Subject: RE: ColdFusion for Dummies revision


 Ok..did I miss something?

 Where is the featureset for Coldfusion 5.0 listed?
 :-)

 -Gel

 -Original Message-
 From: Greg Wolfinger [mailto:[EMAIL PROTECTED]]

 John:

 Make sure you include user defined functions because that is the
singlemost
 important (in my opinion) new feature with 5.0.  Also, you might want to
go
 over briefly application frameworks like fusebox and any other known ways
 for newbies to structure CF.

 Best Regards,




~~
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: ColdFusion for Dummies revision - CF5 features

2000-12-04 Thread Jamie Keane

Yeah, you could just run another query, but if you already have a query and
you want to pull a subset of it, it does save resources to run a subquery
off of what you already store.  So in responce to your question: "Yeah".

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Todd Ashworth [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Monday, December 04, 2000 3:34 PM
Subject: Re: ColdFusion for Dummies revision - CF5 features


|   b.. Ability to run queries against existing query result sets (CFSQL).

I don't understand the need for that.  Couldn't you just run another query?
Or is it some sort of performance issue thing since the query is in memory?

Todd Ashworth

- Original Message -
From: "Alex Aguilar" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, December 04, 2000 3:10 PM
Subject: Re: ColdFusion for Dummies revision - CF5 features


| Taken from CFVault's summary of Allaire DevCon:
|
[http://www.cfvault.com/index.cfm/mode/DisplayContent/ContentElementID/64/E
l
| ementPage/2]
|
| CF 5.0 will be built on the existing codebase, and released during the
first
| half of 2001. It is NOT part of the Pharaoh initiative, the next
generation
| of Allaire application server platform.
|
| Here are some of the CF 5.0 features:
|   a.. User defined functions and functions libraries.
|   b.. Ability to run queries against existing query result sets (CFSQL).
|   c.. Partial page output.
|   d.. Server side graphic engine.




~~
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 7.0 Question

2000-11-30 Thread Jamie Keane

Try just DELETE FROM table WHERE conditions

You'd have to use UPDATE to delete/mangle individual cell data, so the * in
the previous statement is unnecessary. :)

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: ibtoad [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Thursday, November 30, 2000 2:24 PM
Subject: SQL 7.0 Question


Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
works great except one statement.

cfquery name="get_auctions" datasource="happytoad"
DELETE * from auction_records where auction_id='#id#' and userid='#userid#'
/cfquery

Here is the error:

ODBC Error Code = 37000 (Syntax error or access violation)

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax
near
'*'.

Is * not the correct syntax for All is SQL 7.0?

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

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

2000-11-29 Thread Jamie Keane

Have you taken a look at MultiCalendar?

http://www.lafilm.net/multicalendar/

We're using it on one of our big projects, and it's pretty cool.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Todd Ashworth [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Wednesday, November 29, 2000 5:35 PM
Subject: Re: CF_Calendar


I've noticed a lot of people looking for calandars and/or scheduling apps.
My company needed a hefty one for a current project.  We couldn't find
anything that suited our needs so we are having to build our own.  It's
pretty complex.  It takes 6 tables in the database just to schedule an
event.  It supports almost any type of scheduled event .. including
complicated ones that look like this:

Class 1
Number of seats 30
Price $35
Location: Building C
Age Range - N/A
Monday 5-6pm, Wed. 5-6pm, Friday 3-4:15pm
From October 1, 2000 to December 31, 2000
Except on Dec. 25 because of a holiday
Monday and Weds classes will be taught by Bob and Fridays classes will be
taught by Sue.

This is just an example though .. it can hold other events besides
"classes".  It can be used to schedule a single event for a single day, or
one that repeates infinately into the future and the past, or even a
reacurring event that never falls on the same day, at the same time.

Let me tell you what .. setting up the database structure for that was a
pain ;)

If anyone is interested in a calander/scheduling app with this much
flexability, I will see about making it available when it's done.  I would
like to just toss it out open source so everyone can make fun of my coding,
but I don't know if the boss will go for that ...

Todd Ashworth

- Original Message -
From: "Phoeun Pha" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, November 29, 2000 4:42 PM
Subject: RE: CF_Calendar


| DOn't get it. It's not really administratableblaablaggg.  what i
meant
| was, the only thing u set on it are the events and dates.  thats all.
There
| are some FREE nifty CF based event /planner calendar on the allaire site,
| which have a hugeload of cool stuff you can mess around with


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

~~
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: time in CF

2000-11-27 Thread Jamie Keane

Current date and time?  You can use the Now() function to get a date/time
object with that.  Afterwards, use the DateFormat() and TimeFormat()
functions to format the date the way you like.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Jeremy Bunton [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Monday, November 27, 2000 3:04 PM
Subject: time in CF


Hello,
I was wondering how to display the time and date in CF. In asp it is
%date%. I know there must be an equally easy way of doing it in CF.

Jeremy


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

~~
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: HTML CFMAIL

2000-11-27 Thread Jamie Keane

Other than setting the "type=html" param in CFMAIL, you should be set.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: paul smith [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Monday, November 27, 2000 5:09 PM
Subject: HTML CFMAIL


Do we need to do anything special to send HTML Mail with CFMAIL?

best,  paul

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

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



highlighting strings, with a twist.

2000-11-14 Thread Jamie Keane

Hi all,

I know this has been discussed previously, but I've got a question with a
little quirk in it.

I know there are ways to highlight a string, and basically you REReplace the
string with a copy of itself wrapped in a highlighting font tag (or span,
or what have you).  The problem is this:  What if the string contains HTML
and the highlighter mangles the HTML output?  Is there a smart way for the
regexp to do the highlighting but skip over the insides of an HTML tag?  In
other words, it would be okay to highlight the label portion of an A tag,
but not touch the HREF attribute.

Any assistance would be very appreciated!  And if you know a custom tag that
does this, please pass it on my way.  Thanks!

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax


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]



Smart renames on images?

2000-10-23 Thread Jamie Keane

Hi folks,

I've got a project that requires that all images that are uploaded are named
uniquely.  This would usually be a simple case of using the MAKEUNIQUE
attribute in CFFILE but the client is picky about the names of the incoming
files.  Therefore, the original name must be preserved.  If the desired
filename already exists on the server, I need to let the user know, and
rename the file accordingly.  What's the easiest and most efficent way to
handle this?

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax


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: Smart renames on images?

2000-10-23 Thread Jamie Keane

What type of error is returned from an unsuccessful upload?

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Cameron Childress [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Monday, October 23, 2000 11:35 AM
Subject: RE: Smart renames on images?


 I've got a project that requires that all images that are
 uploaded are named
 uniquely.  This would usually be a simple case of using the MAKEUNIQUE
 attribute in CFFILE but the client is picky about the names of
 the incoming
 files.  Therefore, the original name must be preserved.  If the desired
 filename already exists on the server, I need to let the user know, and
 rename the file accordingly.  What's the easiest and most efficent way to
 handle this?

Do they have to be names correctly on the server, or just when they are
downloaded back to the client again?  There are different filename two
parameters which would help you do that.  File.ServerFile is the unique
name
on the server, but File.ClientFile is the original name of the file before
it was made unique.  You can always store BOTH these names in the DB so
that
you can preserve the filename in listings and such in the application.  If
a
file is downloaded out of the app, you can also apply the original name
back
again to fake out the users into thinking it was always named that on the
server.

If they actually need it to be named correctly on the server itself (boy
that is picky), then you'll want to read up no the NAMECONFLICT="Error"
attribute of the CFFILE tag.  You should be able to use this along with
CFTRY/CFCASE to handle the error and give the user some options on renaming
it.

-Cameron


Cameron Childress
ElliptIQ Inc.
p.770.460.7277.232
f.770.460.0963


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: CGI Referrer variable

2000-10-09 Thread Jamie Keane

Yeah, I did that too.  The funny thing is that it didn't throw an error in
my case.  Is the CGI variable space particularly (and annoyingly) lenient
when it comes to nonexistant variables or is this anomalous behaviour?

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Larry Juncker [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Monday, October 09, 2000 4:02 PM
Subject: RE: CGI Referrer variable


#CGI.REFERER#

I found out the hard way just one r not 2



Larry Juncker
Senior Cold Fusion Programmer
Heartland Communications Group, Inc.


-Original Message-
From: Brian bouldernet [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 2:47 PM
To: CF-Talk
Subject: CGI Referrer variable


Does anyone know the variable name for refferer? I forgot ofhand...

Thnaks,
Brian

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



Re: Value to Variable?

2000-10-05 Thread Jamie Keane

To get the value of name  ".recordcount", use the Evaluate function.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Peter Benoit [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Thursday, October 05, 2000 12:19 PM
Subject: Value to Variable?



if I cfset tmp = #name#  ".recordCount"

I can't use it as it literally should, when I

cfoutput#tmp#/cfoutput it prints out but if I

cfif #tmp# is not "0"

it doesn't work...

is there a type conversion I have to do here?

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



Re: #Timeformat(Now())#

2000-10-03 Thread Jamie Keane

I would put the formatting mask behind the date.
#DateFormat(Now(),"mm/dd/")# would result in 10/03/2000.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Richard Colman [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Tuesday, October 03, 2000 5:39 PM
Subject: #Timeformat(Now())#


why doesn't this work:

INPUT type="text" name="timeopen"  value="#Timeformat(Now())#" size="8"

It does not display the time, but displays #Timeformat(Now())#
It's in the book! The date version works!

?

Richard Colman

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



Re: MORE: #Timeformat(Now())#

2000-10-03 Thread Jamie Keane

Well, that would do it too!  I'm in the habit of always adding the
formatting mask, and I've always done it this way, so I sorta jumped to
conclusions.  Doh.  Sorry.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Richard Colman [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Tuesday, October 03, 2000 5:49 PM
Subject: MORE: #Timeformat(Now())#


sorry. works. /cfoutput in the wrong place.

Boy, you can just look and look and look and not see the obvious.

-Original Message-
From: Richard Colman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 03, 2000 2:17 PM
To: Cf-Talk
Subject: #Timeformat(Now())#


why doesn't this work:

INPUT type="text" name="timeopen"  value="#Timeformat(Now())#" size="8"

It does not display the time, but displays #Timeformat(Now())#
It's in the book! The date version works!

?

Richard Colman

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



Re: _date fields

2000-10-02 Thread Jamie Keane

I've experienced that on a few occasions, and it is because CF reserves the
"_date" suffix for validating fields.  The way around this is to not name
your form fields with _date or _required or whatnot.  I wish there was a way
to turn this off!

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Karl Simanonok [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Monday, October 02, 2000 3:44 PM
Subject: _date fields


I've also experienced problems with form fields named 'something_date',
they don't get properly passed as form fields.  I think it has something
to do with CF's data input validation algorithm getting confused when it
doesn't find a 'something' field to do the validation on.  I've learned
(the hard way) to never name a form field with a _date suffix, except
for validating a date field.

Regards,

Karl Simanonok

Original message:
===
Date: Sun, 1 Oct 2000 11:13:17 -0400
From: Bud [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: Date fields in SQL
Message-ID: p0432040fb5fd043d4afa@[192.168.0.2]

On 10/1/00, W Luke penned:
Hi,

Well it's another Query problem for Will today - the error message is
telling me it can't find expiry_date field - in Access I've set the
date/time format to a custom dd-mmm-yy - is this the problem?  Here's
the
code:

For some reason, every now and again I have problems if I name
something underscore date. Try naming expirydate and see if that
helps.

And it wouldn't hurt to refer to today as #createodbcdate(today)#.
But that's probably not the problem.
--


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



Re: Javascript string search question...

2000-10-02 Thread Jamie Keane

You could use JS's regex functions...

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Kevin Langevin [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Monday, October 02, 2000 4:08 PM
Subject: Javascript string search question...


Anyone know how to do a text string search in Javascript?  I've used
substring before, but I'm looking for some way to do something akin to
find() in CF, where it finds the substring ANYWHERE in the string to be
searched.  Is it necessary to do a character by character search, or is
there a javascript command to find any instance of the search string in the
string to be searched?

CFUG-SFL Manager
-Kev
/CFUG-SFL Manager

 -Original Message-
 From: Stewart, Mark [mailto:[EMAIL PROTECTED]]
 Sent: Monday, October 02, 2000 12:44 PM
 To: CF-Talk
 Subject: RE: CFServer a memory leaker?


 Tim,

 I'm basically running the same thing: Win98, CFServer, CFStudio,
 PWS, Intel
 Celeron 300 (overclocked to 450) and 128 RAM. I've had a few problems,
but
 nothing major. This configuration works quite well for what I use it for.
 Now, I wouldn't use this for any type of production scenario, but it
works
 well for just playing around at home. I also run many other
 programs on this
 machine as well: MS Office, numerous games, mem turbo and Zone Alarm.

 I would definitely beef-up the RAM on your machine and it should act a
 little better.

 For what it's worth,

 ~Mark

 -Original Message-
 From: Claremont, Timothy S [mailto:[EMAIL PROTECTED]]
 Sent: Monday, October 02, 2000 11:54 AM
 To: CF-Talk
 Subject: CFServer a memory leaker?


 At home I have installed CFSERVER running on Personal Web Server,
 using RDS.

 Since I have installed both server and studio, my system is very unstable
 and totally locks up many times a day. This is on Windows 98 with only 64
 meg of RAM.

 Is this simply a memory issue, or is this configuration giving
 everyone else
 fits as well???



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



Re: HeadHunters?

2000-09-29 Thread Jamie Keane

I get those too.  They were especially heavy on my first week on the job
here, but I still occasionally get a call or email... I have no idea where
they get my name.

Jamie
(I know I've had a long week when I look at the subject line and think "Why
is CF-TALK talking about a Front 242 song?")

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Todd Ashworth [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Friday, September 29, 2000 9:06 AM
Subject: Re: HeadHunters?


We have been getting that *and* headhunters are also calling our company up
trying to get us to hire people completely unrelated to anything we do.  Go
figure ...

Todd Ashworth

- Original Message -
From: "Larry Juncker" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Friday, September 29, 2000 8:56 AM
Subject: RE: HeadHunters?


| Yes, I am getting them to and haven't even sent out any apps or feelers.
|
| Larry Juncker
| Senior Cold Fusion Programmer
| Heartland Internet
|
| -Original Message-
| From: Robert Everland [mailto:[EMAIL PROTECTED]]
| Sent: Thursday, September 28, 2000 1:55 PM
| To: CF-Talk
| Subject: HeadHunters?
|
|
| Is anyone else magically getting job offers from headhunters who
| know your name or is it just me?
|
| 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=listsbody=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=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Date Timestamp??

2000-09-26 Thread Jamie Keane

Have you tried using #Now()# in your insert statement?  That should work in
most cases.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: HappyToad.com [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Tuesday, September 26, 2000 11:15 AM
Subject: Date Timestamp??


How do I input the current date and time into a database? In other words I
want to time stamp an entry.

Rich

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



Re: [CF-Talk] RE: listing tables in Access?

2000-09-19 Thread Jamie Keane

That's what I needed.  Thanks very much!

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Billy Cravens [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Monday, September 18, 2000 8:35 PM
Subject: Re: [CF-Talk] RE: listing tables in Access?


You must open the database in Access, and make MSysObjects readable
(system table; lists objects that make up the db, including tables).
Can't remember the exact menu sequence, but we're all smart here :)
Then you can query that table.  Very similar to sysobjects table in SQL
Server.

Here some quick queries that do the tricks you need:
http://home.att.net/~dashish/queries/qry0002.htm (disclaimer: I spent 5
seconds searching, so it's probably not the best out there)

--
Billy Cravens
[EMAIL PROTECTED]



Eron Cohen wrote:

 Once upon a time there was a tag in the Allaire Tag Gallery that did this
 for MS Access.  Unfortunately, it quit working when we we upgraded to
Access
 2000 or something like that (I forget exactly what went wrong).  Just in
 case it will work for you, it was called CFX_TABLEFIELDS.

 HTH,

 Eron

 -Original Message-
 From: Jamie Keane [mailto:[EMAIL PROTECTED]]
 Sent: Monday, September 18, 2000 1:38 PM
 To: CFTalk
 Subject: OT: listing tables in Access?

 Hello everyone,

 I was wondering if Access has some mechanism in place to list all tables
in
 a database.  Thanks.

 --
 Jamie Keane
 Programmer
 SolutionMasters, Inc.
 9111 Monroe Rd., Suite 100
 Charlotte, NC  28270
 www.solutionmasters.com
 704.563.5559 x 228  Voice
 704.849.9291  Fax

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



OT: listing tables in Access?

2000-09-18 Thread Jamie Keane

Hello everyone,

I was wondering if Access has some mechanism in place to list all tables in
a database.  Thanks.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax

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



Re: [CF-Talk] Re: listing tables in Access?

2000-09-18 Thread Jamie Keane

I meant as a query.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Ricq Pattay [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Monday, September 18, 2000 3:28 PM
Subject: [CF-Talk] Re: listing tables in Access?


Assuming Access 97 (don't know about 2000):

With the main database window visible, select Tools/Analyze/Documenter.
There you can choose which db objects you wish to view/print.


Ricq Pattay [EMAIL PROTECTED]
Univ of Minnesota - Twin Cities
College of Veterinary Medicine



- Original Message -
From: Jamie Keane [EMAIL PROTECTED]
To: CFTalk [EMAIL PROTECTED]
Sent: Monday, September 18, 2000 12:37 PM
Subject: OT: listing tables in Access?


 Hello everyone,

 I was wondering if Access has some mechanism in place to list all tables
in
 a database.  Thanks.

 --
 Jamie Keane
 Programmer
 SolutionMasters, Inc.
 9111 Monroe Rd., Suite 100
 Charlotte, NC  28270
 www.solutionmasters.com
 704.563.5559 x 228  Voice
 704.849.9291  Fax

 -
-

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



Re: cf error question...

2000-09-06 Thread Jamie Keane

I assume you mean the error messages with the diagnostic information in a
box (syntax error, ODBC error, etc.)?  The way you can set a default
alternative for these admittedly ugly errors is to use the CFERROR tag in
your application.cfm.  If that's too limiting for what you wanted to do, you
could use CFTRY/CFCATCH to trap individual errors per page and manipulate
them.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Chris Terrebonne [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Tuesday, September 05, 2000 6:15 PM
Subject: cf error question...


This has probably been covered already but...
Is there any way to replace or customize CF's internal error messages
("canceled or ignored by server...", etc)?

Thanks,
Chris

_
Free email with personality! Over 200 domains!
http://www.MyOwnEmail.com

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



Re: count() or recordcount

2000-09-06 Thread Jamie Keane

Furthermore, count() is just that, a tally of the rows as a query column in
and of itself.  The RecordCount variable is an attribute of the query
object.  Returning a query object assumes that you wish to do something with
it, other than count how many rows are returned.  If you're just wishing to
count the items with x criteria, your intent is closer to count() anyway. :)

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Todd Ashworth [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Wednesday, September 06, 2000 12:31 PM
Subject: Re: count() or recordcount


In a direct comparison, I would think count() would be since it's run on
the
SQL server.

Todd Ashworth

- Original Message -
From: "Bud" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, September 06, 2000 12:11 PM
Subject: count() or recordcount


| Which is faster? I'm presuming count() or what else would it be good for?
| --
|
| Bud Schneehagen - Tropical Web Creations
|
| _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
| ColdFusion Solutions / eCommerce Development
| [EMAIL PROTECTED]
| http://www.twcreations.com/
| 954.721.3452
| -
-

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



Re: CF not letting go of database connection?

2000-09-01 Thread Jamie Keane

This works with Access (so I'm not sure if it'll work in your case), and
it's a quick-and-dirty approach, so YMMV.  Todd's idea is better in the long
run, but if you absolutely must kill the lock on the DB *right now*, try
this:

Just make a bogus SELECT query (usually I pull from a table named 50
characters of gibberish).  In Access it kills the lock on the DB, and it
might help out in Sybase.

HTH,
Jamie

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Todd Ashworth [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Friday, September 01, 2000 10:03 AM
Subject: Re: CF not letting go of database connection?


Do you mean that the database engine stays running even after the last
connection has been closed?

If so, go to your ODBC administrator in your control panel and open the
properties for the DSN in question.  Under the "Database" tab, you will
have
2 checkboxes at the bottom.  One is to automaticly start the database if it
isn't running and the other is to shut down the database after the last
disconnect.  You will want to check the second one.  Note that with this
option checked, anytime the database is not being queried, the database
engine will shut down.  This means that it will have to restart every time
a
new query comes along, which adds about 1 second of overhead (YMMV).

Todd Ashworth


- Original Message -
From: "Boris" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 31, 2000 1:20 PM
Subject: CF not letting go of database connection?


| I have a number CF based pages that once the query is completed with the
| data presented it will not let go of the database connection to my Sybase
| SQL Anywhere database.  Even after the page has been exited.
|
| Any suggestion would be appreciated.
|
| Boris


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



Re: StructClear

2000-09-01 Thread Jamie Keane

StructClear destroys struct keys.  As for deleting structures altogether,
I'm not sure.  Surely there's got to be a way to unset variables, right?

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Stas Newdel [EMAIL PROTECTED]
To: CFTalk [EMAIL PROTECTED]
Date: Friday, September 01, 2000 3:44 AM
Subject: StructClear


Does StructClear reset keys in a structure to be blank, or does it remove
the keys? Also, what's a function to get rid of a structure altogether?

Thank you


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



Re: New and Worried (terminating a session)

2000-09-01 Thread Jamie Keane

You can specify a session variable's timeout in the CFAPPLICATION tag (in
fact, you MUST set it).  Session variables can last as long as you want them
to, but bear in mind that they typically reside in memory, so be judicious
about their usage!  As for terminating the session, you can use the
StructClear() function.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: megan sherman [EMAIL PROTECTED]
To: cold fusion [EMAIL PROTECTED]
Date: Friday, September 01, 2000 3:38 AM
Subject: New and Worried (terminating a session)


Hi all,
This is proving to be an informative list! I have worked out a lot of
the cold fusion portion of my latest site. Session variables are still a
mystery. How do I turn off a session? In other words, if I leave the
website and come back in an hour, or next day, I want a fresh session.
Can this be done in applications.cfm with a timer/counter? I think I
read somewhere that a session can be terminated with javascript.
Earlier, someone posted the cold fusion script below. Will that
terminate my session after 30 minutes (or do I have to modify this code
somewhat?) Any help would be greatly appreciated. BTW, what is the
philosphy of a "session"? Do customers expect their session to be
persistant over days?
Thanks!
Megan


I use this which deletes all client variables if they haven't been
accessed in 30 minutes:

CFIF not isDefined('client.initialize_session')
cfset client.initialize_session = now()
cfelse
cfset app_timeout = now() - createtimespan(0,0,30,0)
 CFIF client.initialize_session GTE app_timeout
 cfset client.initialize_session = now()
 CFELSE
 cfset clientlist = GetClientVariablesList()
 cfloop index="i" list="#clientlist#"
cfset temp = DeleteClientVariable('#i#')
 /cfloop
 cfset client.initialize_session = now()
 /CFIF
/CFIF

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



Re: Has the Apocalypse cometh? (Was RE: CF vs. ASP)

2000-08-31 Thread Jamie Keane

I am, well at least professionally.  I fiddle with PHP as a hobby, and my
job hasn't required me to switch over yet, so I guess I still qualify.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Todd Ashworth [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Wednesday, August 30, 2000 8:32 PM
Subject: Re: Has the Apocalypse cometh? (Was RE: CF vs. ASP)


Me

- Original Message -
From: "Owens, Howard" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, August 30, 2000 8:22 PM
Subject: RE: Has the Apocalypse cometh? (Was RE: CF vs. ASP)




  -Original Message-
  From: Gregory Harris [SMTP:[EMAIL PROTECTED]]
  Sent: Wednesday, August 30, 2000 8:32 AM
  To: [EMAIL PROTECTED]
  Subject: Has the Apocalypse cometh? (Was RE: CF vs. ASP)
 
   How many dedicated CF programmers are there still out there?
 
 Me.



 =
 Howard Owens
 Web Producer
 InsideVC.com
 mailto:[EMAIL PROTECTED]
 =
 -
-

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



(OT) making fields readonly with JavaScript

2000-08-31 Thread Jamie Keane

Hi all, and I apologise for being off-topic, but this is driving me nuts!

Is there a way to "disable" text field via JavaScript?  I know of the
READONLY attribute, and the client likes how that works, but in my research
I was not able to come up with a way to access that attribute through JS.
Any ideas?

Thanks,
Jamie

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax

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



Re: Javascript Question

2000-08-31 Thread Jamie Keane

Here's what I'd do.

Make the image an HREF pointing to "#", and calls a function when clicked.
Like so:

function doMyStuff()
{
document.image.src = "newimage.jpg";
document.form.submit();
}

I think this will work.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Robert Everland [EMAIL PROTECTED]
To: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
Date: Thursday, August 31, 2000 11:20 AM
Subject: OT: Javascript Question


 I can't remember where or the name of the javascript forum off of
cf-talk but I figured I may as well as my question and then have someone
tell me where to do. I have a form button that is an image. I put some
javascript in there so that when I click on it, it changes the image. What
I
want to do now is make it so that image is not clickable that way no one
can
keep clicking on submit. Anyone know how to do this, it can't be a href tag
becuase I have to pass form variables.


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=listsbody=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=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: (OT) making fields readonly with JavaScript

2000-08-31 Thread Jamie Keane

Yep, that'll do it.  I forgot entirely about blur().  Thanks!

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Jason Powers [EMAIL PROTECTED]
To: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
Date: Thursday, August 31, 2000 12:05 PM
Subject: RE: (OT) making fields readonly with JavaScript


Jamie,
  Shouldn't it be possible for you to use the blur() method to force focus
off of that text box?  Like this:
input type="text" onFocus="this.blur();"
to take focus off of that field, or
input type="text" onFocus="document.forms[0].someotherelement.focus()"
to focus on another element, which would actually be rather confusing for
the user.
If that doesn't work, you might be able to do something like this:
scriptvar myval;/script
input type="text" onFocus="myval=this.value;" onBlur="this.value=myval;"
to replace the value in the field with its previous value.

-Original Message-
From: Jamie Keane [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 31, 2000 9:51 AM
To: CFTalk
Subject: (OT) making fields readonly with JavaScript


Hi all, and I apologise for being off-topic, but this is driving me nuts!

Is there a way to "disable" text field via JavaScript?  I know of the
READONLY attribute, and the client likes how that works, but in my research
I was not able to come up with a way to access that attribute through JS.
Any ideas?

Thanks,
Jamie

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax

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



Re: Re[2]: (OT) making fields readonly with JavaScript

2000-08-31 Thread Jamie Keane

Well, the bugbear of this was I needed to control, via radio buttons,
whether or not the text field(s) was/were readonly.  What I ended up doing
was storing the state in a hidden formfield.  If anyone cares to see the
code, I'll post it.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Carol Bluestein [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Thursday, August 31, 2000 4:14 PM
Subject: Re[2]: (OT) making fields readonly with JavaScript


Yes, it works and works well.

Carol L. Bluestein
Senior Programmer
NYS Office of Real Property
518-486-6335
[EMAIL PROTECTED]

I haven't tried this, and in fact I'm stealing this from the JS-Jive list:

onFocus="this.blur()"
in the input tag


Ricq Pattay [EMAIL PROTECTED]
Univ of Minnesota - Twin Cities
College of Veterinary Medicine


- Original Message -----
From: Jamie Keane [EMAIL PROTECTED]
To: CFTalk [EMAIL PROTECTED]
Sent: Thursday, August 31, 2000 8:50 AM
Subject: (OT) making fields readonly with JavaScript


 Hi all, and I apologise for being off-topic, but this is driving me nuts!

 Is there a way to "disable" text field via JavaScript?  I know of the
 READONLY attribute, and the client likes how that works, but in my
research
 I was not able to come up with a way to access that attribute through JS.
 Any ideas?

 Thanks,
 Jamie

 --
 Jamie Keane
 Programmer
 SolutionMasters, Inc.
 9111 Monroe Rd., Suite 100
 Charlotte, NC  28270
 www.solutionmasters.com
 704.563.5559 x 228  Voice
 704.849.9291  Fax

 -
-

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



Re: IsDefined help

2000-08-30 Thread Jamie Keane

What method is the form using?  To use the FORM scope a form must use the
POST method.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Joel Blanchette [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Tuesday, August 29, 2000 10:34 PM
Subject: IsDefined help


This is a multi-part message in MIME format.

--=_NextPart_000_0005_01C01200.C3750520
Content-Type: text/plain;
 charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hello everyoneI am having some stupid problems with a simple =
command.  I am to make a check on a form field and if it is not defined =
to write something.  i tried the following with no success...Hope =
someone can help.

CFIF NOT IsDefined("form.name")
You forgot your name
/CFIF

I also tried

CFIF IsDefined("form.name") EQ "FALSE"
You forgot your name
/CFIF

but still with no success...Hope someone can help me out!!!

Thanks...

Joel

--=_NextPart_000_0005_01C01200.C3750520
Content-Type: text/html;
 charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
HTMLHEAD
META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type
META content=3D"MSHTML 5.00.3018.900" name=3DGENERATOR
STYLE/STYLE
/HEAD
BODY bgColor=3D#ff
DIVFONT size=3D2Hello everyoneI am having some stupid problems =
with a=20
simple command.nbsp; I am to make a check on a form field and if it is =
not=20
defined to write something.nbsp; i tried the following with no =
success...Hope=20
someone can help./FONT/DIV
DIVnbsp;/DIV
DIVFONT size=3D2lt;CFIF NOT IsDefined("form.name")gt;/FONT/DIV
DIVFONT size=3D2nbsp;nbsp;nbsp; You forgot your name/FONT/DIV
DIVFONT size=3D2lt;/CFIFgt;/FONT/DIV
DIVnbsp;/DIV
DIVFONT size=3D2I also tried/FONT/DIV
DIVnbsp;/DIV
DIVFONT size=3D2
DIVFONT size=3D2lt;CFIFnbsp;IsDefined("form.name") EQ=20
"FALSE"gt;/FONT/DIV
DIVFONT size=3D2nbsp;nbsp;nbsp; You forgot your name/FONT/DIV
DIVFONT size=3D2lt;/CFIFgt;/FONT/DIV
DIVnbsp;/DIV
DIVbut still with no success...Hope someone can help me out!!!/DIV
DIVnbsp;/DIV
DIVThanks.../DIV
DIVnbsp;/DIV
DIVJoel/DIV/FONT/DIV/BODY/HTML

--=_NextPart_000_0005_01C01200.C3750520--

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



Re: Need help validating a URL...

2000-08-30 Thread Jamie Keane

How about...

cfif Left(var,7) is not "http://" 
(error message...)
/cfif

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Edward Chanter [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Wednesday, August 30, 2000 4:33 AM
Subject: Need help validating a URL...


Hey Gurus,

Does anyone know a quick way to take a url input into a form and check to
see if the user has put in the http:// ??? There must be a way to do it in
CF but I haven't found it yet... Been searching the archives for ages but
so
far with no luck... :-(

Any help would be most appreciated!

TiA

 -= Edward

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



Re: IsDefined help

2000-08-30 Thread Jamie Keane

I don't think so.  I know Form.FIELDNAMES is reserved, but that's about it,
I think.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Andy Ewings [EMAIL PROTECTED]
To: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
Date: Wednesday, August 30, 2000 8:56 AM
Subject: RE: IsDefined help


Just a thoughtis Form.name a reserved variable?  Try renaming the
control and see what happens.

-Original Message-
From: Jamie Keane [mailto:[EMAIL PROTECTED]]
Sent: 30 August 2000 13:56
To: [EMAIL PROTECTED]
Subject: Re: IsDefined help


What method is the form using?  To use the FORM scope a form must use the
POST method.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Joel Blanchette [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Tuesday, August 29, 2000 10:34 PM
Subject: IsDefined help


This is a multi-part message in MIME format.

--=_NextPart_000_0005_01C01200.C3750520
Content-Type: text/plain;
 charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hello everyoneI am having some stupid problems with a simple =
command.  I am to make a check on a form field and if it is not defined =
to write something.  i tried the following with no success...Hope =
someone can help.

CFIF NOT IsDefined("form.name")
You forgot your name
/CFIF

I also tried

CFIF IsDefined("form.name") EQ "FALSE"
You forgot your name
/CFIF

but still with no success...Hope someone can help me out!!!

Thanks...

Joel

--=_NextPart_000_0005_01C01200.C3750520
Content-Type: text/html;
 charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
HTMLHEAD
META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type
META content=3D"MSHTML 5.00.3018.900" name=3DGENERATOR
STYLE/STYLE
/HEAD
BODY bgColor=3D#ff
DIVFONT size=3D2Hello everyoneI am having some stupid problems =
with a=20
simple command.nbsp; I am to make a check on a form field and if it is =
not=20
defined to write something.nbsp; i tried the following with no =
success...Hope=20
someone can help./FONT/DIV
DIVnbsp;/DIV
DIVFONT size=3D2lt;CFIF NOT IsDefined("form.name")gt;/FONT/DIV
DIVFONT size=3D2nbsp;nbsp;nbsp; You forgot your name/FONT/DIV
DIVFONT size=3D2lt;/CFIFgt;/FONT/DIV
DIVnbsp;/DIV
DIVFONT size=3D2I also tried/FONT/DIV
DIVnbsp;/DIV
DIVFONT size=3D2
DIVFONT size=3D2lt;CFIFnbsp;IsDefined("form.name") EQ=20
"FALSE"gt;/FONT/DIV
DIVFONT size=3D2nbsp;nbsp;nbsp; You forgot your name/FONT/DIV
DIVFONT size=3D2lt;/CFIFgt;/FONT/DIV
DIVnbsp;/DIV
DIVbut still with no success...Hope someone can help me out!!!/DIV
DIVnbsp;/DIV
DIVThanks.../DIV
DIVnbsp;/DIV
DIVJoel/DIV/FONT/DIV/BODY/HTML

--=_NextPart_000_0005_01C01200.C3750520--

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



Re: formatting social security number

2000-08-30 Thread Jamie Keane

Here's what I did:

cfset output = Replace(form.ssn,"-","","ALL")
and to display it properly,
#Left(output,3)#-#Mid(output,4,2)#-#Right(output,4)#

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Kim Ahlbrandt [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Wednesday, August 30, 2000 2:35 PM
Subject: formatting social security number


I need to take the dashes out of a social security number before storing to
the database, and then put them back in when the page is brought up again
later.  Is there a way to do this in coldfusion??

Thanks,
Kim
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at
http://profiles.msn.com.

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



Re: What I want in CF (was: Learning ASP)

2000-08-29 Thread Jamie Keane

God that's kludgy, but if it works it works, eh?  Still, I wish Allaire
would put a more "standardised" and documented syntax, so I wouldn't have to
scratch my head as much. :)

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Peter Theobald [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED];
[EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Monday, August 28, 2000 5:53 PM
Subject: Re: What I want in CF (was: Learning ASP)


Cold Fusion is weak in these areas, but really you can do all these things
(or "emulate" them :-) ) using existing features.
(forgive my syntax - I'm writing this quickly)

Pick a standard variable name, like ReturnValue and only use it for
returning a value from a custom tag:
caller.ReturnValue = xxx

Or use the tag's name as a structure:
If NOT IsDefine("MyTagName") {
MyTagName = StructNew()
}
MyTagName.Return = "some data"


Static variables: How static do you want them? :-) Cold Fusion has extra
"scopes" that wouldn't make sense in a standard programming language like
C++ where the application all runs at once. In Cold Fusion you might want
static variables that retain their value (1) for the entire Application, (2)
for the page request (there are more you could define if you tried hard).
Pick a standard word, for example "static" and keep them under Application
and Request. Use a hash of the module name:

In Application.cfm:
If NOT IsDefined('Request.Static')
Request.Static = StructNew()

In module: MyTagName:
Request.Static["MyTagName"] = StructNew()
Request.MyTagName.ThisStaticVar = "some data";

This is now a static variable that will retain it's value for the duration
of this page request through all files and multiple calls to this tag. It is
only "private" within the tag because you make it so with the naming
convention. The same thing can be done under the Application scope (scopes
are structures).

Now the *REAL* problem with Cold Fusion is there is no ability to define a
macro, function, or subroutine to "hide" these details so these kinds of
things are very wordy which encourages mistakes when you have to specify
them a hundred times.

At 02:49 PM 8/28/00 -0400, Jamie Keane wrote:
My biggest complaint with the language is the lack of user-defined
functions.  I know that custom tags are sorta a work-around, but sometimes
a
function just needs to return a value, not just assign a value back to the
calling template.  Also, there's no way (that I know of at least) to pass
values by reference, or declare static variables within the scope of a
custom tag.  While PHP doesn't have the simplicity that CF has in terms of
database twiddling, and its error handling leaves a bit to be desired, it
does have support for user-defined functions that may contain variable
references and static variables, and that helps me out a lot.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Gregory Harris [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Monday, August 28, 2000 2:30 PM
Subject: Re: What I want in CF (was: Learning ASP)


Ok, my wish list now:

1) How about a way to determine whether a dimension exists in an array,
for
instance this works:

ArrayLen(ThisArray)

But if ThisArray were a 2 dimensional array and I needed to figure out the
length of something in dimension 2, using this

ArrayLen(ThisArray[DimensionOne]) breaks the page

Rather than having to go thru the excess overhead of trying to use a
counter, maybe extending Arraylen could help this? Or how about a
ArrayDimensionExists() function?

2) Extending CFHTTP (I think this is a BIG one)

3) Making Structures Multi-Dimensional, or is it possible to do structures
like:

Stuff.Things.MoreThings = ThisVariable

This has never worked with me, the best I could do would be Stuff.Things

I'm sure there are more headaches I've run into, but these are right off
the
top of my head.  What else can everyone think of?

Gregory Harris
Los Angeles Information Technology Agency (ITA)
[EMAIL PROTECTED]


 [EMAIL PROTECTED] 08/28 11:11 AM 
 Dave Watts [mailto:[EMAIL PROTECTED]]
I agree that the interfaces for SMTP, POP, HTTP, etc. need a lot of work.
As
for other stuff, I'm kind of curious. What basic functionality would you
like to see? I can't really think of all that much that I'd like to see
added.


Personally, I've got a laundry list.  :)  However, off the top of my head,
in no particular order (I mentioned most of these at The Con last year,
and
will do so again if I go this year):

1. Extend the CFX API to make it more useful.  There a

Re: Is there are way to get a hold of the referring server

2000-08-29 Thread Jamie Keane

It should also be noted that Allaire provides a PDF quick-reference that
summarises all functions, CF tags, and objects created by invocation of said
tags and functions.  It's a real life-saver.  You should be able to find it
on Allaire's site.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: JustinMacCarthy [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Tuesday, August 29, 2000 12:06 PM
Subject: Re: Is there are way to get a hold of the referring server


From cfdocs/Quick_Reference/contents.htm

 CGI.AUTH_TYPE
CGI.CONTENT_LENGTH
CGI.CONTENT_TYPE
CGI.PATH_INFO
CGI.PATH_TRANSLATED
CGI.QUERY_STRING
CGI.REMOTE_ADDR
CGI.REMOTE_HOST
CGI.REMOTE_USER
CGI.REQUEST_METHOD
CGI.SCRIPT_NAME



Server

CGI.GATEWAY_INTERFACE
CGI.SERVER_NAME
CGI.SERVER_PORT
CGI.SERVER_PROTOCOL
CGI.SERVER_SOFTWARE



Client

CGI.CERT_ISSUER
CGI.CERT_SUBJECT
CGI.CLIENT_CERT_ENCODED
CGI.HTTP_ACCEPT
CGI.HTTP_USER_AGENT




EG:

cfoutput
#cgi.http_referer#
/cfoutput

~Justin

- Original Message -
From: "Kevin Schmidt" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 29, 2000 6:02 PM
Subject: Is there are way to get a hold of the referring server


 This is a multi-part message in MIME format.

 --=_NextPart_000_0C9A_01C011B1.04723110
 Content-Type: text/plain;
 charset="iso-8859-1"
 Content-Transfer-Encoding: quoted-printable

 Is there are way to get a hold of the referring server in CF's CGI =
 variables. I can't even find the list of CGI variables in Allaires =
 Documentation.  Thanks.

 Kevin Schmidt
 Internet Services Manager
 Peterson, WIlliams  Bizer
 Office: 734.995.5000
 Mobile: 734.649.4843


 --=_NextPart_000_0C9A_01C011B1.04723110
 Content-Type: text/html;
 charset="iso-8859-1"
 Content-Transfer-Encoding: quoted-printable

 !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
 HTMLHEAD
 META content=3D"text/html; charset=3Diso-8859-1" =
 http-equiv=3DContent-Type
 META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR
 STYLE/STYLE
 /HEAD
 BODY bgColor=3D#ff
 DIV
 PIs there are way to get a hold of the referring server in CF's CGI =
 variables.=20
 I can't even find the list of CGI variables in Allaires =
 Documentation.nbsp;=20
 Thanks./P/DIV
 DIVFONT face=3DArial size=3D2Kevin SchmidtBRInternet Services=20
 ManagerBRPeterson, WIlliams amp; BizerBROffice: =
 734.995.5000BRMobile:=20
 734.649.4843BR/FONT/DIV/BODY/HTML

 --=_NextPart_000_0C9A_01C011B1.04723110--

 -
-

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



Re: CFLOCK datasource var?

2000-08-29 Thread Jamie Keane

Yeah, but the "Variables" scope isn't persistent.  Each time a page loads it
will unset itself.  It would be better IMHO to just do a plain vanilla
CFSET.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Todd Ashworth [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Tuesday, August 29, 2000 4:48 PM
Subject: Re: CFLOCK datasource var?


You shouldn't need to use a Session variable for your DSN .. especially if
you are going to be setting it over and over in your Application.cfm.  That
defeats the purpose of having a Session variable anyway.  You could get by
with another scope .. say Variables.ds, or something.  That way, you
wouldn't have to worry about locking at all.

cfif not IsDefined('Variables.ds')
cfset Variables.ds = "something_dev"
/cfif

Todd Ashworth

- Original Message -
From: "Ricq Pattay" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 29, 2000 4:42 PM
Subject: CFLOCK datasource var?


| In my application.cfm I set a session var for all my queries' datasource
| like this:
|
| cflock scope="session" timeout="30" type="exclusive"
|  cfset session.ds = "something_dev"
| /cflock
|
| So... Do I need to read-only lock every reference to session.ds in all my
| other templates where I have a query using that datasource session var?
| e.g.,
|
| cfquery name="get_year" datasource=#session.ds#
| select sysdate from dual
| /cfquery
|
| Since session.ds is always identical for every user of this site, what
does
| it matter if it's locked or not?
|
| 
| Ricq Pattay [EMAIL PROTECTED]
| Univ of Minnesota - Twin Cities
| College of Veterinary Medicine
|
|
|
|
| -
-

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



Re: What I want in CF (was: Learning ASP)

2000-08-28 Thread Jamie Keane

My biggest complaint with the language is the lack of user-defined
functions.  I know that custom tags are sorta a work-around, but sometimes a
function just needs to return a value, not just assign a value back to the
calling template.  Also, there's no way (that I know of at least) to pass
values by reference, or declare static variables within the scope of a
custom tag.  While PHP doesn't have the simplicity that CF has in terms of
database twiddling, and its error handling leaves a bit to be desired, it
does have support for user-defined functions that may contain variable
references and static variables, and that helps me out a lot.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Gregory Harris [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Monday, August 28, 2000 2:30 PM
Subject: Re: What I want in CF (was: Learning ASP)


Ok, my wish list now:

1) How about a way to determine whether a dimension exists in an array, for
instance this works:

ArrayLen(ThisArray)

But if ThisArray were a 2 dimensional array and I needed to figure out the
length of something in dimension 2, using this

ArrayLen(ThisArray[DimensionOne]) breaks the page

Rather than having to go thru the excess overhead of trying to use a
counter, maybe extending Arraylen could help this? Or how about a
ArrayDimensionExists() function?

2) Extending CFHTTP (I think this is a BIG one)

3) Making Structures Multi-Dimensional, or is it possible to do structures
like:

Stuff.Things.MoreThings = ThisVariable

This has never worked with me, the best I could do would be Stuff.Things

I'm sure there are more headaches I've run into, but these are right off the
top of my head.  What else can everyone think of?

Gregory Harris
Los Angeles Information Technology Agency (ITA)
[EMAIL PROTECTED]


 [EMAIL PROTECTED] 08/28 11:11 AM 
 Dave Watts [mailto:[EMAIL PROTECTED]]
I agree that the interfaces for SMTP, POP, HTTP, etc. need a lot of work. As
for other stuff, I'm kind of curious. What basic functionality would you
like to see? I can't really think of all that much that I'd like to see
added.


Personally, I've got a laundry list.  :)  However, off the top of my head,
in no particular order (I mentioned most of these at The Con last year, and
will do so again if I go this year):

1. Extend the CFX API to make it more useful.  There are some things (like
working with arrays, as Jeremy mentioned) that don't work or are hellishly
hard to workaround.  Some of us (very few, I know) *like* to work in C++ and
*like* to optimize our stuff by putting it in machine code.

2. Fix the encryption.  It's really *really* broken.

3. (or, in deference to or addition to #2) Support for "compiling"
templates.  We know that they already do this in memory (something akin to a
p-code or bytecode type thing), but what I'd like to see is the ability to
take that compiled chunk of memory and save it to a file.  Python has this,
as does Perl (in a limited sense).  This would do two things for me: (a) It
would mean that even though people could still "decompile" it, they'd still
have to figure out var names, etc.  (b) It would save the overhead of
parsing the file every time.

4. Better regular expression engine.  (Especially non-greedy matching.)

5. Better locking system.  (This is a whine.)  It's all fine and good to put
the burden of the locking on the programmer (who has to go absolutely crazy
on the CFLOCKs in a production system), but I'd really like to see something
a bit better.  I dunno how, but I know they have some pretty smart people
who can surprise us.

6. Binary data support for variables. (Unicode?)  Right now I can't
(reliably) mess around with binary files.  :(

7. Fix CFHTTP!  Please!  In the current implementation so much is broken
it's not even funny!
a. Not thread-safe (gah!)
b. Can't use CFHTTPPARAM (and therefore cookies) without the POST method.
(lame)
c. Can't select encoding type (multipart/form-data doesn't work
everywhere) - at least make it smart enough so that if no files are attached
it doesn't use multipart! (exceedingly lame)
d. The hack for port is *stupid*.  If I want to access an arbitrary URL that
could be on any port, I have to manually parse out the port number from the
URL and put it in the PORT attribute and at the same time take it out of the
URL string (it barfs otherwise!).  (mired in a sweaty mass of lameness)

8. Fix PreserveSingleQuotes() - Right now it doesn't act like a real
function.  I can't do other things in it.  That is,
PreserveSingleQuotes(ListChangeDelims(list,"','")) is broken.  (This is my
most common use for it.)

9. Fix the standard structures (Form, Client, etc) to actually work like
structures, so that I can enumerate them, delete from them, etc.  Having to
GetClientVariables() or get Form.FieldNames is just ann

Re: IF this OR this

2000-08-28 Thread Jamie Keane

Just like you said.  I usually wrap my conditional components in parentheses
just to be certain.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Peter Benoit [EMAIL PROTECTED]
To: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
Date: Monday, August 28, 2000 2:43 PM
Subject: IF this OR this


how can I

cfif this OR this

/cfif

?


Thanks
Pete

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



Re: password generation code snippet needed

2000-08-28 Thread Jamie Keane

Just for fun, I tried something.  It seems to work pretty well, and fast
too!

cfset length = 8
cfset pswd = ""
cfloop index="i" from="1" to="#length#" step="1"
cfset donumbers = RandRange(0,1)
cfif donumbers
cfset lowend = 49
cfset highend = 57
cfelse
cfset uppercase = RandRange(0,1)
cfif uppercase
cfset lowend = 65
cfset highend = 90
cfelse
cfset lowend = 97
cfset highend = 122
/cfif
/cfif
cfset pswd = pswd  Chr(RandRange(lowend,highend))
/cfloop

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Stas Newdel [EMAIL PROTECTED]
To: CFTalk [EMAIL PROTECTED]
Date: Monday, August 28, 2000 5:06 PM
Subject: password generation code snippet needed


Hello,

Does anyone have code lying around that will generate an alpha-numeric
mixed
case string? Thanks.

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



Re: Query syntax

2000-08-28 Thread Jamie Keane

The "dbo" scope is the "owner" of the table.  This means it was created by
user "dbo."

The "dis_products" scope is the name of the table the column belongs to.
That's to eliminate ambiguity in multitable queries.

"DESC" means descending. :)

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Chad [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Monday, August 28, 2000 5:22 PM
Subject: Query syntax


ORDER BY  dbo.dis_products.product_name DESC

This is a part of a query that im trying to de-cipher.  How can the
variable have two scopes?

And what is DESC?

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



Re: IsNotDefined()

2000-08-25 Thread Jamie Keane

Try NOT IsDefined().

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Peter Benoit [EMAIL PROTECTED]
To: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
Date: Friday, August 25, 2000 8:49 AM
Subject: IsNotDefined()


Is there a way to do this?

I've tried things like !IsDefined() with no success...

Thanks,
Pete

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



Re: Concatenate Strings

2000-08-25 Thread Jamie Keane

cfset ConcatenatedString = string1  string2

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Peter Benoit [EMAIL PROTECTED]
To: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
Date: Thursday, August 24, 2000 7:18 PM
Subject: Concatenate Strings


How can I concatenate 2 strings in CF?


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



Re: splitting strings

2000-08-24 Thread Jamie Keane

Do you wish to convert your list to an array?  If so, there's the function
ListToArray.  If you are wanting to put each element on a blank line, you
could loop through the array and output each element at a time, followed by
br.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Peter Benoit [EMAIL PROTECTED]
To: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
Date: Thursday, August 24, 2000 3:17 PM
Subject: splitting strings


if I have a string like word1,word2,word3

How could I split it in Cold Fusion into ?

word1
word2
word3

Thanks,
Pete

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



Re: Division in Cold Fusion?

2000-08-23 Thread Jamie Keane

cfset myval = thisval / thatval should work.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Peter Benoit [EMAIL PROTECTED]
To: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
Date: Wednesday, August 23, 2000 2:37 PM
Subject: Division in Cold Fusion?


I must be looking at all the wrong stuff... but I want to take 2 values and
divide them.

like:

cfset myval = #thisval# \ #thatval#

Is there a correct way to do this?

Thanks,
Pete

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



Re: Newbie Cold Fusion Studio Question

2000-08-23 Thread Jamie Keane

You will need Cold Fusion Server installed on the machine that's serving up
the documents for variables to be interpreted.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Kim Woodbridge [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Wednesday, August 23, 2000 2:43 PM
Subject: Newbie Cold Fusion Studio Question


Hello,

I am trying to set up Cold Fusion Studio in order to view and alter
.cfm files created by our main IS department.  I have set up the
Developmental Mappings properly and have created a very simple file from
an example in the Studio documentation.

HTML
HEAD
TITLECall Department/TITLE
/HEAD
BODY
STRONGCall Department/STRONG
!--- Set all variables ---
CFSET Department="Sales"
CFSET City="Boston"
CFSET Salary="11"
!--- Display results ---
CFOUTPUT
I'd like to talk to someone in #Department# in #city# who earns at
least #Salary#.
/CFOUTPUT
/BODY
/HTML

When I view this in my browser it shows #Department# etc. rather than
filling in the variables.  Does anyone know what I may have not
configured properly or what I am missing here.

I am not running Cold Fusion Server but am using the Microsoft Personal
Server for Windows 95.

Thanks in advance.



Kim A. Woodbridge
Web Developer
Children's Hospital of Philadelphia
215-590-1197
[EMAIL PROTECTED]
---
---
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: limiting Malicious uploaded file types

2000-08-23 Thread Jamie Keane

The way I'd do it is
cffile action="upload" (other_attributes)
cfset Disallow = "cfm,exe,asp,vbs,js"
cfif ListFindNoCase(Disallow,ListLast(FILE.ServerFile,".")) is not 0
cffile action="delete" file="#FILE.ServerFile#"

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Milks, Jim [EMAIL PROTECTED]
To: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
Date: Wednesday, August 23, 2000 3:46 PM
Subject: limiting Malicious uploaded file types


Hi all,
I am in the process of coding a site on which users can upload files for
collaboration. I need to limit the file types that can be uploaded for
obvious security reasons, and am curious if anyone has encountered this
type
of situation. I have found a way of determining this after the file is
uploaded (maybe there is a CFX??), at which point I delete it, but what I
am
really interested in is which type of files I should exclude.

So far, I have figured on these:
.cfm, .asp, .vbs, .exe, .js

Also, should I be concerned about EXE is I do not permit a file type that
could execute it? (such as cfm) If I do not have anything like JRun on the
server, need I be concerned with .jsp files?

Lastly, what is a .dbm file? I have seen this MIME type on CF powered sites
before.

Thanks,

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



Re: assigning value to dynamic variable

2000-08-23 Thread Jamie Keane

The proper syntax is:
CFSET Evaluate("CurBills_#myBillFolder#"
=ListAppend(Trim(Evaluate("CurBills_"myBillFolder)), myBillnum)

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Ric Smith [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Wednesday, August 23, 2000 4:24 PM
Subject: assigning value to dynamic variable


How can I accomplish this.

CFSET Evaluate("CurBills_"myBillFolder) =
ListAppend(Trim(Evaluate("CurBills_"myBillFolder)), myBillnum)

CF doesn't want to let me use a function .

-
Just in time compilation error


Illegal left hand side of assignment near line 127, column 11. Left hand
side cannot be a function call.
---

There must be a way to do this, my brain is a little mushy. Help!


Ric Smith

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



Re: assigning value to dynamic variable

2000-08-23 Thread Jamie Keane

oops remove the "evaluate(" from the beginning!

(I really should proofread...)

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-----
From: Jamie Keane [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Wednesday, August 23, 2000 4:31 PM
Subject: Re: assigning value to dynamic variable


The proper syntax is:
CFSET Evaluate("CurBills_#myBillFolder#"
=ListAppend(Trim(Evaluate("CurBills_"myBillFolder)), myBillnum)

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Ric Smith [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Wednesday, August 23, 2000 4:24 PM
Subject: assigning value to dynamic variable


How can I accomplish this.

CFSET Evaluate("CurBills_"myBillFolder) =
ListAppend(Trim(Evaluate("CurBills_"myBillFolder)), myBillnum)

CF doesn't want to let me use a function .

-
Just in time compilation error


Illegal left hand side of assignment near line 127, column 11. Left hand
side cannot be a function call.
---

There must be a way to do this, my brain is a little mushy. Help!


Ric Smith

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



Re: dynamic IIf

2000-08-21 Thread Jamie Keane

The syntax should be IIF(condition,result1,result2)
where result1 occurs if condition is true and result2 occurs if condition is
false.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Peter Benoit [EMAIL PROTECTED]
To: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
Date: Monday, August 21, 2000 11:41 AM
Subject: dynamic IIf



Having a hard time with this:

cfset value="#IIF url.stuff IS "whatever", "something", "something
else"#"

Tried mixing things up a bit (quotes, pound signs) with no success.  Any
suggestions?

TIA,
Pete

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



Re: dynamic IIf

2000-08-21 Thread Jamie Keane

Oh, my mistake... I forgot the DE()'s around the results.  These are needed.
My brain's fried today. :)

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Peter Benoit [EMAIL PROTECTED]
To: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
Date: Monday, August 21, 2000 12:03 PM
Subject: RE: dynamic IIf


Well that's what I have

IIF(url.stuff IS "whatever"

then "something"

else "something else")

which is what my line of code essentially says.  Though it doesn't work :/

*  -Original Message-
*  From: Jamie Keane [mailto:[EMAIL PROTECTED]]
*  Sent: Monday, August 21, 2000 11:53 AM
*  To: [EMAIL PROTECTED]
*  Subject: Re: dynamic IIf
*
*
*  The syntax should be IIF(condition,result1,result2)
*  where result1 occurs if condition is true and result2 occurs
*  if condition is
*  false.
*
*  --
*  Jamie Keane
*  Programmer
*  SolutionMasters, Inc.
*  9111 Monroe Rd., Suite 100
*  Charlotte, NC  28270
*  www.solutionmasters.com
*  704.563.5559 x 228  Voice
*  704.849.9291  Fax
*  -Original Message-
*  From: Peter Benoit [EMAIL PROTECTED]
*  To: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
*  Date: Monday, August 21, 2000 11:41 AM
*  Subject: dynamic IIf
*
*
*  
*  Having a hard time with this:
*  
*  cfset value="#IIF url.stuff IS "whatever", "something", "something
*  else"#"
*  
*  Tried mixing things up a bit (quotes, pound signs) with no
*  success.  Any
*  suggestions?
*  
*  TIA,
*  Pete
*  
*  
*  ---
*  ---
*  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
*  To Unsubscribe visit
*  http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lis
ts/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=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Printing anchor code

2000-08-21 Thread Jamie Keane

You'd need to escape the "trouble" characters, I'd think.  Have you tried
CF's HTMLCodeFormat() function?

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Kevin Queen [EMAIL PROTECTED]
To: Cold Fusion [EMAIL PROTECTED]
Date: Monday, August 21, 2000 4:56 PM
Subject: OT: Printing anchor code


All,
OK, my brain is about to explode for not being able to remember a simple
command from HTML 3.2, if I want to display the  text "a href="..."Blah,
blah, blah/a" in a browser, how do I do that.  BTW: pre/pre is not
it.

Please help before my brain goes on permanant vacation.

-Kevin

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



Re: How can you programmatically keep a web browser from caching a page?

2000-08-17 Thread Jamie Keane

You could use CFHEADER to expire the page:

CFHEADER Name="Expires" Value="#Now()#"

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Brandon Behrens [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Wednesday, August 16, 2000 6:23 PM
Subject: OT: How can you programmatically keep a web browser from caching a
page?


How can you programmatically keep a web browser from caching a page with
HTML?

Thanks in advance,

Brandon

Brandon Behrens
The Internet Design Firm
512.451.5225
[EMAIL PROTECTED]
http://www.theidf.com


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



Re: Open Source (and free?) web content editor?

2000-08-17 Thread Jamie Keane

It's not WSIWYG, and it's for PHP, but you might take a gander at

http://www.ekenberg.se/php/ide/

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Cameron Childress [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Thursday, August 17, 2000 11:36 AM
Subject: Open Source (and free?) web content editor?


I know this has been discussed before, but after looking through my email
archives I don't see a direct answer to my question, so here it is:

I'm scouring the web for word processor-ish content editor to embed into a
content management system.  I've found Activedit (www.cfdev.com) and
eWebEditPro (www.ektron.com) so far.  The two products look very similar
with a few differences.  You can get Activedit as open source, and I like
that.

What I'd really love to find though, is a nice *free* and full featured
editor.  I don't know that's going to happen, but I gotta try.  I'm
thinking
that one may exist in PHP-land or something.  In the event that there was a
PHP (or ASP) version out there, all I really need is the client editor
part.
It should be trivial to change the small amount of code which exchanges the
content with the DB.

Anyone seen anything like this anywhere out there?

-Cameron

Cameron Childress
McRae Communications
p. 770-460-7277 x.232
f. 770-460-0963

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



Re: credit card validation

2000-08-17 Thread Jamie Keane

If you wanted to use Javascript there is a Javascript validator at
http://www.dejeu.com/web/tools/tech/js/forms/form_chkcard-f.asp

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Kiley Simpson [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Thursday, August 17, 2000 1:10 PM
Subject: credit card validation


Does anyone have an up to date credit card number validation tag? I don't
need to verify funds or anything, I just have to see if the credit card
(visa, mc, amex) is a potentially valid number.

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



Re: javascript help

2000-08-17 Thread Jamie Keane

Your cfform needs a name.  If you're just using HTML forms, you'll still
need a name for your form to access the form's contents.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: sebastian palmigiani [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Thursday, August 17, 2000 1:50 PM
Subject: javascript help


I'm trying to develop a javascript validation for a textarea. I'm getting
an
error message which says "ProgramDescription.value" is not an object.

===

script language="javascript1.2"
function validate(testform) {
 if (testform.ProgramDescription.value == " ") {
 window.alert("Please add a program description.");
return false;
}
return true;

}
/script

cfform action="AddNewProgram.cfm" method="post" ONSUBMIT="return
validate(this)"

textarea name="ProgramDescription"  value="" cols="30" rows="10"
wrap="virtual"/textarea

input type="submit"  value="submit"
/cfform

Thanks,
Sebastian


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



Re: go back to previou s page

2000-08-17 Thread Jamie Keane

You can refer to the referring document with the CGI.HTTP_REFERER variable.
Just set your href to that and that should do the trick for you.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: thanh nguyen [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Thursday, August 17, 2000 2:06 PM
Subject: go back to previou s page


I have different pages go to the same page and i want to know know how if I
go to that page and click done it go back to previous page where I come
from
thanks

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

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



Re: SQL query problem...

2000-08-17 Thread Jamie Keane

It's an old-school bass synthesizer. (yeah, I'd love to get my hands on one
too...)

veering blindly off-topic,
Jamie

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Chapman, Katrina [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Thursday, August 17, 2000 3:01 PM
Subject: RE: SQL query problem...


What's a TB303?

--K

-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 17, 2000 10:57 AM
To: [EMAIL PROTECTED]
Subject: RE: SQL query problem...



OK, this is probably wrong, but its all I can glean from SQL BOL

ALTER TABLE table_name NOCHECK CONSTRAINT your_primary_key

...do your stuff...

ALTER TABLE table_name CHECK CONSTRAINT your_primary_key



If I'm right, you owe me a mint condition TB303!

*me sits down and crosses fingers in hope*

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


-Original Message-
From: Ryan Williams [mailto:[EMAIL PROTECTED]]
Sent: 17 August 2000 18:15
To: [EMAIL PROTECTED]
Subject: Re: SQL query problem...





 Oops.  I just stumbled onto the answer by accident.  I just removed the
"-2"
 and
 associated parentheses from the sub-query and I got my results.  My
 sub-query
 now looks like:
 select max(right(wire_id,len(wire_id))) from wire_list)
 and it works too !! :-)

 My sincerest apologies to everyone in the list.

 Ryan Williams
 [EMAIL PROTECTED]



 - Original Message -
 From: "Ryan Williams" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Thursday, August 17, 2000 12:45 PM
 Subject: SQL query problem...


  I have a SQL problem.  I know what information I want to retrieve
from
  the DB,
  however, I do not know what precisely is the proper SQL syntax/function
 is
  in order to
  achieve it.
 
 The query as it is currently  written in my CF template is:
  select wl.*,p.*,wlg.*,wb.*,wsnd.*,wrcvd.*,ws.*
  from wire_list wl
  left join P_officers p on wl.reg_by = p.off_id
  left join wire_status ws on wl.status_code = ws.status_code
  left join wire_log wlg on wl.wire_id = wlg.wire_id
  left join wire_senders wsnd on wl.sender_id = wsnd.sender_id
  left join wire_rcv_modes wrcvd on wl.rcv_mode = wrcvd.rcv_mode
  left join wire_banks wb on wl.bank_id = wb.bank_id
  where wl.wire_id = (
   select max(right(wire_id,(len(wire_id)-2)))
   from wire_list)
 
  The error this code generates when I attempt to run it in SQL query
  analyzer:
  Server: Msg 536, Level 16, State 1, Line 1
  Invalid length parameter passed to the substring function.
 
  The content of the wire_id column looks like this format:
  ab999 and is of varchar datatype.
 
  I did not code these tables and I am in the middle of re-coding the
  entire site to be FuseBox compliant.  I am trying to select the top
(max)
  wire_id from the wire_list table, and display all records related
  to the returned value of the max function, but the result that
 areretrieved
  to date,
  with the code "Select max(wire_id)" and no WHERE clause,
  is ab99 when I know there are wire_id's in the table that have values
  of ab999, etc.  It seems that SQL does not recognize that ab999 is the
  larger value when compared to ab99.
 
  The solution I am trying to apply with the code at the top of this
email
 is
  to "get"
  the "number" part of the wire_id column, minus the two letters, and
then
 use
  the max function on
  the remainder to get the ab999 wire_id i know is in the table.  I
looked
  through the
  SQL books online and it seems that SQL Sever does not have the ability
to
  convert
  the varchar datatype (of the wire_id) column to the int data type that
  the max function seems to need in order to work properly.
 
  Does anyone know of a work around for this problem?  Or am I going
totally
  in  the wrong
  direction with this logic?
 
  Any help/ideas/comments would be greatly apprecia

Re: Robot chasing question

2000-08-17 Thread Jamie Keane

I don't know about the first part but they shouldn't follow the includes,
since the robot should only see the resultant HTML code, like any browser.

--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC  28270
www.solutionmasters.com
704.563.5559 x 228  Voice
704.849.9291  Fax
-Original Message-
From: Larry Juncker [EMAIL PROTECTED]
To: Cf-Talk@Houseoffusion. Com [EMAIL PROTECTED]
Date: Thursday, August 17, 2000 3:49 PM
Subject: Robot chasing question


Will searchengine robots search cfm pages and will they follow cfincludes
through a page?

Thanks In Advance

Larry Juncker
Developer @ Heartland Internet

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



  1   2   >