RE: After installation of studio 4.5, Remote Files tab cannot be foun d

[David Shadovitz]

No, but don't worry. Go to the Files tab.  The pull-down list contains an entry 
"Allaire FTP & RDS".
-David

On Tuesday, March 06, 2001 JAIME HOI [SMTP:[EMAIL PROTECTED]] wrote:
>In CF4.5, is the Remote Files Tab still in use? I cannot find this tab
> in CF 4.5 studio.   Are there any way to get around this?

~~
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: After installation of studio 4.5, Remote Files tab cannot be foun d

[JAIME HOI]

sorrie...found the tab alreadi ..sorrie for the trouble. 

-Original Message-
From: JAIME HOI [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 07, 2001 2:27 PM
To: CF-Talk
Subject: After installation of studio 4.5, Remote Files tab cannot be foun d


hi
   In CF4.5, is the Remote Files Tab still in use?? I cannot find this tab
in CF 4.5 studio.   Are there any way to get around this ?
~~
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

After installation of studio 4.5, Remote Files tab cannot be foun d

[JAIME HOI]

hi
   In CF4.5, is the Remote Files Tab still in use?? I cannot find this tab
in CF 4.5 studio.   Are there any way to get around this ?



~~
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: CFMail - Sending a link in an email

[Teng-Yan Loke]

Well, for me I found that the problem seems to be with the MIME type that is
set by ColdFusion. If memory serves me right, it was "text/html". Somehow,
MS Outlook is not able to treat the e-mail as HTML code, so it displays all
the code. As for most other mail clients that can view HTML mail, they have
no problems displaying mail sent by CF.

Has anyone else seen this?


Loke, Teng-Yan | [EMAIL PROTECTED] | +65-8313547
E-Developer | novaSPRINT.com (S) Pte Ltd


~~
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: Installation of CF-Studio 4.5 Upgrade

[JAIME HOI]

thanks a lot!!





-Original Message-
From: John Wilker [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 07, 2001 1:23 PM
To: CF-Talk
Subject: RE: Installation of CF-Studio 4.5 Upgrade


I don't think so. the 4.5 upgrade will need to see 4.0 installed. However
you can uninstall the 4.0 after you install 4.5. That's what I always do.

J.


John Wilker
Web Applications Consultant
Allaire Certified ColdFusion Developer

Office: 909-943-8428
www.billtracker.org 


-Original Message-
From: JAIME HOI [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 06, 2001 9:13 PM
To: CF-Talk
Subject: Installation of CF-Studio 4.5 Upgrade



Can i uninstall the CF-Studio 4.0 before i install this CF-Studio 4.5
UpGrade CD?? Because after i install CF-Studio 4.0 followed by 4.5 Upgrade,
i see 2 folders of ColdFusion Studio. One leading to 4.0 and the other to
4.5. Why is there a need to have 2 different folders to 4.0 and 4.5??
~~
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: Installation of CF-Studio 4.5 Upgrade

[John Wilker]

I don't think so. the 4.5 upgrade will need to see 4.0 installed. However
you can uninstall the 4.0 after you install 4.5. That's what I always do.

J.


John Wilker
Web Applications Consultant
Allaire Certified ColdFusion Developer

Office: 909-943-8428
www.billtracker.org 


-Original Message-
From: JAIME HOI [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 06, 2001 9:13 PM
To: CF-Talk
Subject: Installation of CF-Studio 4.5 Upgrade



Can i uninstall the CF-Studio 4.0 before i install this CF-Studio 4.5
UpGrade CD?? Because after i install CF-Studio 4.0 followed by 4.5 Upgrade,
i see 2 folders of ColdFusion Studio. One leading to 4.0 and the other to
4.5. Why is there a need to have 2 different folders to 4.0 and 4.5??
~~
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 Newgroups

[Howie Hamlin]

www.fuseware.com is the web site and news.fuseware.com is the news server.

HTH,

Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
www.CoolFusion.com
631-737-4668 x101
inFusion Mail Server (iMS) - the World's most configurable mail server
Get your free copy of iMS POST-SE Server from CoolFusion!

- Original Message -
From: "Jharlist" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 07, 2001 12:03 AM
Subject: CF Newgroups


> To anyone who knows...
>
> Can anyone tell me what the address of the newsgroup version of CF-Talk
is?
>
> I used to be subscribed to this newgroup, but I cannot find the address
anywhere!!!
>
> Thanks
>
> Benjamin
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

CF Newgroups

[Jharlist]

To anyone who knows...
 
Can anyone tell me what the address of the newsgroup version of CF-Talk is?

I used to be subscribed to this newgroup, but I cannot find the address anywhere!!!

Thanks

Benjamin


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

Installation of CF-Studio 4.5 Upgrade

[JAIME HOI]

Can i uninstall the CF-Studio 4.0 before i install this CF-Studio 4.5
UpGrade CD?? Because after i install CF-Studio 4.0 followed by 4.5 Upgrade,
i see 2 folders of ColdFusion Studio. One leading to 4.0 and the other to
4.5. Why is there a need to have 2 different folders to 4.0 and 4.5?? 





~~
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: reading local INI file

[Scott, Andrew]

WDDX is probably the best way, although you could use XML. The only problem
with XML is that from both the Windows Application and the Web Server would
need to use a XML passer, whereas WDDX can be used under Delphi by inlcuding
the relevant dll into the Application and from the server well that is the
easy part. 



-Original Message-
From: Jason Egan [mailto:[EMAIL PROTECTED]]
Sent: 07 March 2001 15:03
To: CF-Talk
Subject: RE: reading local INI file


I didn't write the delphi forms, but the programmer that did is quite
sharp... but I know he'll ask how he passes a var from delphi to cf... ??

Jason

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 05, 2001 12:13 PM
To: CF-Talk
Subject: RE: reading local INI file


> I have set up several kiosks, each of them are connected
> to the net... I need to uniquely identify each computer,
> but without human intervention. The browser is a Delphi
> form, and part of the INI file that is on each kiosk
> contains a unique ID for that kiosk. Any ideas for reading
> that INI file on the local computer without human
> intervention? Each kiosk doesn't have pws or cf express or
> anything running on them, just a straight NT box with IE
> and these Delphi forms.
>
> ??? - I know how to read through and INI file that is on the
> server, but not on the local box.

Usually, the answer would be to write an ActiveX executable to do this for
you, and have that executable downloaded from your server via an OBJECT
reference in your HTML page.

However, it would probably be even easier to simply add some code to your
Delphi forms, and have them send the ID back on each page request.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: (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: reading local INI file

[Jason Egan]

I didn't write the delphi forms, but the programmer that did is quite
sharp... but I know he'll ask how he passes a var from delphi to cf... ??

Jason

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 05, 2001 12:13 PM
To: CF-Talk
Subject: RE: reading local INI file


> I have set up several kiosks, each of them are connected
> to the net... I need to uniquely identify each computer,
> but without human intervention. The browser is a Delphi
> form, and part of the INI file that is on each kiosk
> contains a unique ID for that kiosk. Any ideas for reading
> that INI file on the local computer without human
> intervention? Each kiosk doesn't have pws or cf express or
> anything running on them, just a straight NT box with IE
> and these Delphi forms.
>
> ??? - I know how to read through and INI file that is on the
> server, but not on the local box.

Usually, the answer would be to write an ActiveX executable to do this for
you, and have that executable downloaded from your server via an OBJECT
reference in your HTML page.

However, it would probably be even easier to simply add some code to your
Delphi forms, and have them send the ID back on each page request.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: (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

curly queries

[Toby Tremayne]

I've got a tricky problem that I just can't figure out.

I'm outputting a list of poems fomr a database (just the titles.) Each poem
has several "options" such as hidden, hilite etc.  As I output the titles in
a list, I need to be able to run conditional checks against each option (IE
if hilite is "on" then display markers next to the title.)  The tables are
set up like so:

-
poem
-
poem_id numeric
poem_title  varchar
-


-
poem_option
-
poem_id numeric
option_id   numeric
setting varchar
-


-
poem_option_def
-
option_id   numeric
option_name varchar
-

you can see my problem (hopefully).  To start with I'm getting each
poem_title repeated once for every option that exists.  In the query I need
to select all this information for only the poems whose "hidden" option has
a setting of "off", then I need to output the title only once obviously, at
that time check each of it's options.

This doesn't quite work because while what I NEED is this:

one record:
-
poem_id  |   poem_title   |   hidden   |   hilite  |   spellcheck   |
-
   01"my poem"  "off""on" "on"


instead, I have this:

one record:
-
poem_id  |   poem_title   |   option_name   |   setting |
-
01   "my poem"  "hidden" "off"
01   "my poem"  "spellcheck" "on"
01   "my poem"  "hilite" "on"


as you can see this makes it difficult to do a   

can anyone help me with this please?  i know it's going to be a combination
of writing the correct query and grouping the output - it's just eluding me
utterly.  I can't / don't want to hardcode each option into the queries etc,
because obivously the number and names of options will evnetually grow...
help - anyone?




























Toby Tremayne
Code Poet and Zen Master of the Heavy Sleep
Show Ads Interactive
359 Plummer St
Port Melbourne
VIC 3207
P +61 3 9245 1247
F +61 3 9646 9814
ICQ UIN  13107913


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

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

RE: Custom tags

[Scott, Andrew]

Ben not to forget the fact that if your able to, one can change the registry
setting for this to include other directories


-Original Message-
From: Ben Forta [mailto:[EMAIL PROTECTED]]
Sent: 07 March 2001 14:09
To: CF-Talk
Subject: RE: Custom tags


To call with  syntax they need to be under C:\CFUSION\CustomTags (or
current directory). If you use  they can be anywhere.

--- Ben


-Original Message-
From: Parker, Kevin [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 06, 2001 9:57 PM
To: CF-Talk
Subject: Custom tags


Do custom tags have to be stored under the custom tags directory or can they
be run from anywhere?




Kevin Parker
Web Services Manager
WorkCover Corporation

[EMAIL PROTECTED]

www.workcover.com

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






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

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

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

RE: Custom tags

[Jason Aden]

The ColdFusion server will first search for the custom tag in the current
directory, so if you call  and you have a file called edit.cfm in
that folder, the local file will be run. If CF does not find the file in the
local folder, it will search the folders specified in the registry setting
under HKEY_LOCAL_MACHINE > SOFTWARE > Allaire > ColdFusion > CurrentVersion
> CustomTags > CFMLTagSearchPath. There is a comma-delimited list here of
the folders where CF will search for custom tags.

Once CF finds the file, it will cache the location until the next time the
server is restarted.

hth,

Jason


Jason Aden
Allaire Certified Developer
[EMAIL PROTECTED]
www.wwstudios.com

> -Original Message-
> From: Parker, Kevin [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 06, 2001 9:57 PM
> To: CF-Talk
> Subject: Custom tags
>
>
> Do custom tags have to be stored under the custom tags directory
> or can they
> be run from anywhere?
>
>
> 
>
> Kevin Parker
> Web Services Manager
> WorkCover Corporation
>
> [EMAIL PROTECTED]
>
> www.workcover.com
>
> p: +61 8 82332548
> f: +61 8 82332000
> m: 0418 800 287
>
>
>
>
>
> **
> **
> This e-mail is intended for the use of the addressee only. It may contain
> information that is protected by legislated confidentiality and/or is
> legally privileged. If you are not the intended recipient you are
> prohibited
> from disseminating, distributing or copying this e-mail. Any opinion
> expressed in this e-mail may not necessarily be that of the WorkCover
> Corporation of South Australia. Although precautions have been taken, the
> sender cannot warrant that this e-mail or any files transmitted
> with it are
> free of viruses or any other defect.
> If you have received this e-mail in error, please notify the sender
> immediately by return e-mail and destroy the original e-mail and
> any copies.
> **
> **
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Custom tags

[Ben Forta]

To call with  syntax they need to be under C:\CFUSION\CustomTags (or
current directory). If you use  they can be anywhere.

--- Ben


-Original Message-
From: Parker, Kevin [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 06, 2001 9:57 PM
To: CF-Talk
Subject: Custom tags


Do custom tags have to be stored under the custom tags directory or can they
be run from anywhere?




Kevin Parker
Web Services Manager
WorkCover Corporation

[EMAIL PROTECTED]

www.workcover.com

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






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

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

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

RE: Custom tags

[BORKMAN Lee]

Hi Kevin,

for CustomTags called like , the apps server first looks in
the local directory, then in the CustomTag directory or directories defined
in the Registry.

If you want greater flexibility in calling Custom Tags (eg if you are being
hosted on a server where you don't have access to the CustomTags directory),
you can use CFMODULE to call the tag, and can include the path to wherever
you like.

Best of luck,
Lee (Bjork) Borkman
http://bjork.net ColdFusion Tags by Bjork


-Original Message-
From: Parker, Kevin [mailto:[EMAIL PROTECTED]]


Do custom tags have to be stored under the custom tags directory or can they
be run from anywhere?



IMPORTANT NOTICE:
This e-mail and any attachment to it is intended only to be read or used by
the named addressee.  It is confidential and may contain legally privileged
information.  No confidentiality or privilege is waived or lost by any
mistaken transmission to you.  If you receive this e-mail in error, please
immediately delete it from your system and notify the sender.  You must not
disclose, copy or use any part of this e-mail if you are not the intended
recipient.  The RTA is not responsible for any unauthorised alterations to
this e-mail or attachment to 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

Custom tags

[Parker, Kevin]

Do custom tags have to be stored under the custom tags directory or can they
be run from anywhere?




Kevin Parker
Web Services Manager
WorkCover Corporation

[EMAIL PROTECTED]

www.workcover.com

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






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


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

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

RE: How to make recursion in CF

[BORKMAN Lee]

Hi George, 
You make recursive functions in CF just as you would in any language.  Well,
of course, CF doesn't yet have user-definable functions, but you can
certainly make recursive Custom Tags.  It may not always be the most
efficient method, but it can be very effective when speed is not a vital
issue.  It always seems alittle like magic to me.

There's really no special trick.  A CustomTag can be called with parameters
(ie ATTRIBUTES).  Inside the tag, the code calls this same tag, hopefully
with a different set of attributes.  There are two things you need to do to
make recursion work:

1) The attributes with which you call the tag need to be changing; and
2) There needs to be some condition where the code DOES NOT make the
recursive call.

Without these two conditions, the recursion goes on infinitely, and never
"pops" up again.  

But I guess you knew all that already.  Sorry for the lecture.
Best of luck,
Lee (Bjork) Borkman
http://bjork.net ColdFusion Tags by Bjork


-Original Message-
From: George Dong [mailto:[EMAIL PROTECTED]]

hi there,
if anyone can tell me how make recursion function in CF template?



IMPORTANT NOTICE:
This e-mail and any attachment to it is intended only to be read or used by
the named addressee.  It is confidential and may contain legally privileged
information.  No confidentiality or privilege is waived or lost by any
mistaken transmission to you.  If you receive this e-mail in error, please
immediately delete it from your system and notify the sender.  You must not
disclose, copy or use any part of this e-mail if you are not the intended
recipient.  The RTA is not responsible for any unauthorised alterations to
this e-mail or attachment to 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: How to make recursion in CF

[Chris Montgomery]

Here's one idea:
http://www.defusion.com/articles/index.cfm?ArticleID=63

Chris Montgomery [EMAIL PROTECTED]  

Web Development & Consulting http://www.astutia.com
Allaire Consulting Partner  
210-490-3249/888-745-7603Fax 210-490-4692
AIM: astutiaweb; ICQ: 7381282; Firetalk: Ag78
 
> -Original Message-
> From: George Dong [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 06, 2001 5:52 PM
> To: CF-Talk
> Subject: How to make recursion in CF
> 
> 
> hi there,
> if anyone can tell me how make recursion function in CF template?
> 
> thanks

~~
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: I'm stumped

[sebastian palmigiani]

on 3/6/01 6:45 PM, Bryan Love at [EMAIL PROTECTED] wrote:

> here's your problem...
> 
> 
>  cfsqltype="CF_SQL_VARCHAR"
> dbvarname="@PollID"
> value="TRIM(FORM.PollID)">
> 
> you didn't pound the trim function :)


Geez...You're right! I have been at it for hours with this trying to figure
it out. Couldn't see the trees because the forest was in the way.

Thanks. 


~~
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 make recursion in CF

[Bryan Love]

recursion is fun!

create and run the following two files for a cool example of recursion :)


text.cfm
---

---


fileList.cfm
---












---

pretty basic.  You'll end up with a list of all files in the original root
folder and all subfolders in (stored in request.files)

You can do other cool things with this kind of recursion (like use it to
build a CFtree).

Bryan Love ACP
[EMAIL PROTECTED]



-Original Message-
From: George Dong [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 06, 2001 5:52 PM
To: CF-Talk
Subject: How to make recursion in CF


hi there,
if anyone can tell me how make recursion function in CF template?

thanks
~~
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: Nested Loop limit?

[Bryan Love]

There is no limit, but as you get deeper you have to pay close attention so
that you don't reassign a variable that is being used by a parent loop.  

In your case you need to ensure the following:
- that the index of the first loop isn't being manipulated inside any of the
nested loops
- that the condition of the second loop doesn't reference a variable being
changed inside the third loop.
- that the condition of the third loop evaluates to TRUE the first time it
is hit

There is almost never a need to nest loops three deep.  The third loop
indicates that your counting something; you can best accomplish this using
SQL (if counting query results) or by utilizing one of CF's many length
functions (arrayLen(), listLen, len(), etc...).  Maintaining counters inside
loops is slow in CF and very inefficient.  You may want to re-examine the
way your code works...


Bryan Love ACP
[EMAIL PROTECTED]



-Original Message-
From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 06, 2001 2:52 PM
To: CF-Talk
Subject: Nested Loop limit?


Hi All,

I've just added some code to my current project that has three-deep nested
loops but the third loop doesn't seem to be processed by CF.  
Is there a limit as to how many loops you can nest within each other?

I've been tracing through the code with the debugger and I'm pretty sure it
just skips over the third loop, (causing a nice little infinite loop in the
process too).

Code is of the form





Do stuff


increment a counter (this doesn't get touched)




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: I'm stumped

[Bryan Love]

here's your problem...

 


you didn't pound the trim function :)


Bryan Love ACP
[EMAIL PROTECTED]



-Original Message-
From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 4:38 PM
To: CF-Talk
Subject: I'm stumped


I get the following error with a stored procedure. I am using CF 4.0. What
is stumping me is that when I run the query in the analyzer it works. For
example, this work:


INSERT INTO PollMembers
(PollID, MemberID, MyVote, LastUpdate)
VALUES('MC-03-5-2001-14-33-22', 'PWOO2', 'A', GetDate())


ODBC Error Code = 23000 (Integrity constraint violation)

[Microsoft][ODBC SQL Server Driver][SQL Server]INSERT statement conflicted
with COLUMN FOREIGN KEY constraint 'FK_PollMembers_Polls'. The conflict
occurred in database 'arica', table 'Polls', column 'PollID'.

SQL = "spInsertMyVote"

Data Source = "arica"

The error occurred while processing an element with a general identifier of
(CFSTOREDPROC), occupying document position (92:1) to (93:33).
--

The Tables are:

Polls   PollMembersMembers
PollID VARCHAR(25) PK   PollID VARCHAR(25) FK  MemberID CHAR(10) PK
PollNameMemberID CHAR(10) FK   FirstName
etc.etcetc

I have triple checked the relationships and they are fine.

Here is the stored procedure in CF:







 



 




---

Here it is in SQL Server:

CREATE PROCEDURE spInsertMyVote (@PollID VARCHAR(25), @MemberID CHAR(10),
@MyVote CHAR(3))

AS


INSERT INTO PollMembers
(PollID, MemberID, MyVote, LastUpdate)
VALUES(@PollID, @MemberID, @MyVote, GetDate())

---

It's got to be something with CF. Why would it work in the SQL Query
Analyzer?

Thanks,
Sebastian
~~
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: I'm stumped

[John Wilker]

Sounds like Pollid is linked to another table. If there are any
relationships or existing data you'll have to work within those constraints.

Maybe inserting data into the other table first then into the other one?

J.


John Wilker
Web Applications Consultant
Allaire Certified ColdFusion Developer

Office: 909-943-8428
www.billtracker.org 


-Original Message-
From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 4:38 PM
To: CF-Talk
Subject: I'm stumped


I get the following error with a stored procedure. I am using CF 4.0. What
is stumping me is that when I run the query in the analyzer it works. For
example, this work:


INSERT INTO PollMembers
(PollID, MemberID, MyVote, LastUpdate)
VALUES('MC-03-5-2001-14-33-22', 'PWOO2', 'A', GetDate())


ODBC Error Code = 23000 (Integrity constraint violation)

[Microsoft][ODBC SQL Server Driver][SQL Server]INSERT statement conflicted
with COLUMN FOREIGN KEY constraint 'FK_PollMembers_Polls'. The conflict
occurred in database 'arica', table 'Polls', column 'PollID'.

SQL = "spInsertMyVote"

Data Source = "arica"

The error occurred while processing an element with a general identifier of
(CFSTOREDPROC), occupying document position (92:1) to (93:33).
--

The Tables are:

Polls   PollMembersMembers
PollID VARCHAR(25) PK   PollID VARCHAR(25) FK  MemberID CHAR(10) PK
PollNameMemberID CHAR(10) FK   FirstName
etc.etcetc

I have triple checked the relationships and they are fine.

Here is the stored procedure in CF:
















---

Here it is in SQL Server:

CREATE PROCEDURE spInsertMyVote (@PollID VARCHAR(25), @MemberID CHAR(10),
@MyVote CHAR(3))

AS


INSERT INTO PollMembers
(PollID, MemberID, MyVote, LastUpdate)
VALUES(@PollID, @MemberID, @MyVote, GetDate())

---

It's got to be something with CF. Why would it work in the SQL Query
Analyzer?

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

I'm stumped

[sebastian palmigiani]

I get the following error with a stored procedure. I am using CF 4.0. What
is stumping me is that when I run the query in the analyzer it works. For
example, this work:


INSERT INTO PollMembers
(PollID, MemberID, MyVote, LastUpdate)
VALUES('MC-03-5-2001-14-33-22', 'PWOO2', 'A', GetDate())


ODBC Error Code = 23000 (Integrity constraint violation)

[Microsoft][ODBC SQL Server Driver][SQL Server]INSERT statement conflicted
with COLUMN FOREIGN KEY constraint 'FK_PollMembers_Polls'. The conflict
occurred in database 'arica', table 'Polls', column 'PollID'.

SQL = "spInsertMyVote"

Data Source = "arica"

The error occurred while processing an element with a general identifier of
(CFSTOREDPROC), occupying document position (92:1) to (93:33).
--

The Tables are:

Polls   PollMembersMembers
PollID VARCHAR(25) PK   PollID VARCHAR(25) FK  MemberID CHAR(10) PK
PollNameMemberID CHAR(10) FK   FirstName
etc.etcetc

I have triple checked the relationships and they are fine.

Here is the stored procedure in CF:







 



 




---

Here it is in SQL Server:

CREATE PROCEDURE spInsertMyVote (@PollID VARCHAR(25), @MemberID CHAR(10),
@MyVote CHAR(3))

AS


INSERT INTO PollMembers
(PollID, MemberID, MyVote, LastUpdate)
VALUES(@PollID, @MemberID, @MyVote, GetDate())

---

It's got to be something with CF. Why would it work in the SQL Query
Analyzer?

Thanks,
Sebastian



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

[Brian Thornton]

MIME attachments are basically different formats of file to be attached in a
message. For instance at Double Click we use MIME attachment to a HTML
message in the case the reader doesn't support HTML then the MIME decencies
kick in and display the txt. You can find all about MIME and it's history at
http://bondiboard.macpublishing.net/1998/06/secrets/4337.html

--Yes it's a Mac Site--

As to the other issue I would determine if they are using new mail clients
that can read HTML and the send it that way.

-Brian
- Original Message -
From: "Jones, Becky" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, March 06, 2001 3:23 PM
Subject: cfmail


> is there a way to attach a cf template to an email with the cfmail tag?
> and what exactly is a MIME attachment?
> i have a form that a user fills out...and i want the info in that form to
go
> to an email address but i want the layout of the form to go also.
> thanks,
> bec.
>
>
> *
> This e-mail, including any attachments, is intended for the
> receipt and use by the intended addressee(s), and may contain
> confidential and privileged information.  If you are not an intended
> recipient of this e-mail, you are hereby notified that any unauthorized
> use or distribution of this e-mail is strictly prohibited.
>
>
>
>
~~
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: Enterprise Manager

[Kinley Pon]

Thanks Eric - Kinley

-Original Message-
From: Eric Barr [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 05, 2001 1:13 PM
To: CF-Talk
Subject: RE: OT: Enterprise Manager


I guess I was a little late to the game with an answer ...just needed to
use the menu's in the MMC.


-eric



Common sense is genius dressed in its working clothes.
 -- Ralph Waldo Emerson

Eric Barr
Zeff Design
(p)  212.714.6390
(f)   212.580.7181


-Original Message-
From: Kinley Pon [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 05, 2001 12:20 AM
To: CF-Talk
Subject: RE: OT: Enterprise Manager


a big thanks to you Jeffry...after uninstalling and going through the
registry removing any references to SQL Server, I am now able to make
use of
the registering SQL Server wizard.

again, a big thanks.  Have a great day! - Kinley

-Original Message-
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 04, 2001 4:21 PM
To: CF-Talk
Subject: Re: OT: Enterprise Manager


At 11:47 AM 03/04/2001 -0800, you wrote:
>I have been frustated out of my brains...I foolishly selected to have
the
>wizard for registering a new SQL Server turned off.
>
>So from that point on, each time I right-click a server and then click
"New
>SQL Server Registration", I get the "Registered SQL Server Properties"
>dialog box instead.
>
>Within the dialog, the dropdown list does not have anything available
to
>select from except "(local)", so I enter the IP address of the server I
wish
>to register.  This is not working for me.  I get a timeout when
attempting
>to connect.

   Extend the timeout...   I think the default is like 10 seconds or
something.  I've never been able to successfully register a server
without
upping it. I typically use 30 seconds.  The option to extend the timeout
is
very hidden (and I don't know where off the top of my head).



>I have used the wizard and that works beautifully.  But how do I re-set
my
>Enterprise Manager so that I can have access to the wizard again?  I
have
>tried uninstalling and installing Enterprise Manager several times but
it
is
>storing the original setup somewhere on my workstation.

   If you don't mind un-installing and re-installing.  Un-install.  Do a
search in the registery for everything SQL Server related, and delete
it.



Jeff Houser | mailto:[EMAIL PROTECTED]
AIM: Reboog711  | ICQ: 5246969 | Phone: 860-229-2781
--
Instant ColdFusion 5.0  | 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 Duo called Far Cry Fly
http://www.farcryfly.com | http://www.mp3.com/FarCryFly
--
I've got the brains, you've got the looks, let's make lots of money
~~
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: Nested Loop limit?

[Kevin Gilchrist]

Figured it out, I wrote the conditional loop on the notion that it would
only check the condition after and not before an iteration , I guess like a
DO  UNTIL kinda' loop.

-Original Message-
From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 06, 2001 5:52 PM
To: CF-Talk
Subject: Nested Loop limit?


Hi All,

I've just added some code to my current project that has three-deep nested
loops but the third loop doesn't seem to be processed by CF.  
Is there a limit as to how many loops you can nest within each other?

I've been tracing through the code with the debugger and I'm pretty sure it
just skips over the third loop, (causing a nice little infinite loop in the
process too).

Code is of the form





Do stuff


increment a counter (this doesn't get touched)




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

[Jones, Becky]

but wouldnt the user that recieves the form need to have cf?
i want them to be able to open it like a word or text document.
but how would i get the cf variables to right to that doc?

-Original Message-
From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 06, 2001 5:42 PM
To: CF-Talk
Subject: Re: cfmail



- Original Message -
From: "Jones, Becky" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, March 06, 2001 5:23 PM
Subject: cfmail


> is there a way to attach a cf template to an email with the cfmail tag?

Sure:

blah


-OR-



blah


The first method can be used in any version of cf and allows for a single
attachment.  The second method is for cf 4.5 and allows for multiple
attachments.

> and what exactly is a MIME attachment?

MIME means "Multipurpose Internet Mail Extensions " and is an encoding
method for mail attachments or special character sets.  Traditionally,
emails can only contain 7-bit characters (although some mail servers support
8-bit).  Using MIME allows for 8-bit binary attachments to be converted into
a 7-bit representation that can be decoded by the recipient.

HTH,

Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
www.CoolFusion.com
631-737-4668 x101
inFusion Mail Server (iMS) - the World's most configurable mail server
Get your free copy of iMS POST-SE Server from CoolFusion!

> i have a form that a user fills out...and i want the info in that form to
go
> to an email address but i want the layout of the form to go also.
> thanks,
> bec.
>
>
> *
> This e-mail, including any attachments, is intended for the
> receipt and use by the intended addressee(s), and may contain
> confidential and privileged information.  If you are not an intended
> recipient of this e-mail, you are hereby notified that any unauthorized
> use or distribution of this e-mail is strictly prohibited.
>
>
>
>
>
~~
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 make recursion in CF

[Joseph Thompson]

Try this:
http://cfhub.com/advanced/customtags/recursion.cfm
or:
http://www.cfhub.com/tutorials/ftp2tree/recursion.cfm

> hi there,
> if anyone can tell me how make recursion function in CF template?
> 
> thanks
> 



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

Nested Loop limit?

[Kevin Gilchrist]

Hi All,

I've just added some code to my current project that has three-deep nested
loops but the third loop doesn't seem to be processed by CF.  
Is there a limit as to how many loops you can nest within each other?

I've been tracing through the code with the debugger and I'm pretty sure it
just skips over the third loop, (causing a nice little infinite loop in the
process too).

Code is of the form





Do stuff


increment a counter (this doesn't get touched)




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

How to make recursion in CF

[George Dong]

hi there,
if anyone can tell me how make recursion function in CF template?

thanks


~~
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 Security Question...

[Scott, Andrew]

I suggest reading Ben Forta's books, these questions are covered in the
Advanced Coldfusion Application Development book



-Original Message-
From: Vance Duke [mailto:[EMAIL PROTECTED]]
Sent: 06 March 2001 08:55
To: CF-Talk
Subject: Another Security Question...


I figured out the other Advanced Security issue and I wanted to say thank
you.

Now I have another question.  I have a Security context with all Domain
Users allowed the access the application.  No problem there.  NOW, I want to
limit a part of the application to just a certain subset of domain users
setup in a User Group.  Those users would have access to the main part of
the application, but also need access to the HR functions.  Do I need to set
up another security context and Authorize them against that context also (in
other words, 2 CFAuthenticate statements)?  Or how would I do that?  How do
I know that they are part of that User Group when they log in?

Thanks for the help,
Vance Duke
~~
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: Getting hold of old archives

[Howie Hamlin]

The archives contain individual messages but not the digests.  AFAIK there
is no archive of the digests.

Regards,

Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
www.CoolFusion.com
631-737-4668 x101
inFusion Mail Server (iMS) - the World's most configurable mail server
Get your free copy of iMS POST-SE Server from CoolFusion!

- Original Message -
From: "Brian Sheehan" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, March 06, 2001 5:29 PM
Subject: Getting hold of old archives


Posting a message on this a couple of days ago but wasn't in a
position to follow-up the then reply about the webisite.

I'm looking to find a location where I can download the old archives
(pre-167) I know there is a website that has an online version of
these with all threads but I was wondering whether it's possible to
get copies of the original digests to store locally,

Apologies if I didn't make myself clear the first time I posted - my
mistake.

Cheers

Brian

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


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

[Howie Hamlin]

- Original Message -
From: "Jones, Becky" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, March 06, 2001 5:23 PM
Subject: cfmail


> is there a way to attach a cf template to an email with the cfmail tag?

Sure:

blah


-OR-



blah


The first method can be used in any version of cf and allows for a single
attachment.  The second method is for cf 4.5 and allows for multiple
attachments.

> and what exactly is a MIME attachment?

MIME means "Multipurpose Internet Mail Extensions " and is an encoding
method for mail attachments or special character sets.  Traditionally,
emails can only contain 7-bit characters (although some mail servers support
8-bit).  Using MIME allows for 8-bit binary attachments to be converted into
a 7-bit representation that can be decoded by the recipient.

HTH,

Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
www.CoolFusion.com
631-737-4668 x101
inFusion Mail Server (iMS) - the World's most configurable mail server
Get your free copy of iMS POST-SE Server from CoolFusion!

> i have a form that a user fills out...and i want the info in that form to
go
> to an email address but i want the layout of the form to go also.
> thanks,
> bec.
>
>
> *
> This e-mail, including any attachments, is intended for the
> receipt and use by the intended addressee(s), and may contain
> confidential and privileged information.  If you are not an intended
> recipient of this e-mail, you are hereby notified that any unauthorized
> use or distribution of this e-mail is strictly prohibited.
>
>
>
>
>
~~
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: URLtoken - OK w/proxies & dynamic IP addressing?

[Jeffry Houser]

  Just to clarify (or else correct me if I'm wrong)

   CF only generates the CFID and CFTOKEN if a CFAPPLICATION is executed, 
correct?  No CFAPPLICATION, no CFID or CFTOKEN.  Of course it's rare to not 
be using a CFAPPLICATION...

At 03:40 PM 03/06/2001 -0500, you wrote:
> > Looks like we're going to have to use client.URLtoken since
> > the customer doesn't want cookies required.
> >
> > I've heard that the CFTOKEN is generated based on your IP
> > address (which is how the server knows it's you when you come
> > back) ...
> >
> > but will CFTOKEN get confused if users come through proxies
> > or have dynamic IP addressing?
>
>I don't think that CFTOKEN is generated based on your IP address. To the
>best of my knowledge, it's generated using internal state information (time,
>etc) within CF without regard to any info from the browser. CF will generate
>a CFID and CFTOKEN for each user that doesn't send those variables back,
>regardless of IP address.
>
>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

Getting hold of old archives

[Brian Sheehan]

Posting a message on this a couple of days ago but wasn't in a
position to follow-up the then reply about the webisite.

I'm looking to find a location where I can download the old archives
(pre-167) I know there is a website that has an online version of
these with all threads but I was wondering whether it's possible to
get copies of the original digests to store locally,

Apologies if I didn't make myself clear the first time I posted - my
mistake.

Cheers

Brian

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

cfmail

[Jones, Becky]

is there a way to attach a cf template to an email with the cfmail tag?  
and what exactly is a MIME attachment?
i have a form that a user fills out...and i want the info in that form to go
to an email address but i want the layout of the form to go also.
thanks,
bec.


*
This e-mail, including any attachments, is intended for the 
receipt and use by the intended addressee(s), and may contain 
confidential and privileged information.  If you are not an intended 
recipient of this e-mail, you are hereby notified that any unauthorized 
use or distribution of this e-mail is strictly prohibited. 



~~
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: cfmail not working sometimes

[Ryan]

At 09:52 PM 3/6/2001 +, you wrote:
>Does anyone have some basic solutions to the occasional (2-3%) emails not
>being sent? Not getting the occasional order alert (or help request, or
>confirmation, or...) is causing problems.
>
>I refuse to believe our ISP response to this problem when they tell me:
>
>"That is actually a bug in CF that was never resolved. The mail actually is
>gone forever. No way to check for unsent mail either. ASPmail seems to be
>the most reliable; so you may want to consider using that. More info on
>ASPmail is at (Link deleted)"
>
>I know some of you have some tips for this problem.

I'd ask if they are running Qmail for a mail server. If they are, then 
there is a known problem when using CF and sending mail through a Qmail 
server. For some reason sometimes CF sends emails with bare line feeds in 
it, (maybe this problem stems from the developers editor, I don't know) and 
Qmail adheres strictly to the RFC, and does not accept it.

I've also had mail not go through for no reason at all, there was just some 
generic error message in CF's mail log.

In any case, I've never seen the mail get lost completely, its always in 
Cold Fusion's undeliverable folder.

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: Authorize.Net or Cybercash or someone else?

[Joby Bednar]

I hope to God that you don't actually put that code on your web page.
Someone could just copy the source code and adjust the amount and submit
it... that's like putting the price as a variable in the url.

I'm going to assume you use this internally and not in the "outside" world.

Joby Bednar
Director of Internet Design
iNEOgroup.com
http://www.ineogroup.com 
Fusing your Dreams and the Web, Together as One
[EMAIL PROTECTED] 
Cell:  949-283-5138
Personal Fax:  208-485-1170

-Original Message-
From: Judith Campbell [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 06, 2001 1:55 PM
To: CF-Talk
Subject: Re: Authorize.Net or Cybercash or someone else?


This is form submit we use to send the data to payflow.  There are several
configuration steps you have take, but their instructions are very
clear.  The data is echoed back in the same form variables so once you
receive them back  you can do with them as you wish.

https://payflowlink.signio.com/paylinks.dll">




































At 10:51 AM 3/6/01 -0800, you wrote:
>Do you happen to have any sample source code for using this?
>
>Dustin M. Snell
>Unisyn Software, LLC
>Developers of AutoMate - The Leading Automation Software for Windows
>http://www.unisyn.com
>- Original Message -
>From: "Jeff Beer" <[EMAIL PROTECTED]>
>
> > VeriSign bought Signio a while back - very fast, easy to use, stable,
and
> > has a great price structure.
> >
> > Check out the PayFlowPro product.  It's hard to say five times quickly,
>but
> > it works like a charm.
~~
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: cfmail not working sometimes

[Chad Gray]

If you trusting the user to put in a valid email address this may be the 
problem.

http://www.coolfusion.com/WhyiMS.cfm

"If, for some reason, the designated mail server is not available or 
refuses to relay the mail (mail sending via CFMAIL is actually a mail relay 
through a mail server) then the mail is moved into the UNDELIVR directory. 
You would need to manually move the mail back into the ColdFusion spool to 
retry mail delivery."



At 09:52 PM 3/6/01 +, you wrote:
>Does anyone have some basic solutions to the occasional (2-3%) emails not
>being sent? Not getting the occasional order alert (or help request, or
>confirmation, or...) is causing problems.
>
>I refuse to believe our ISP response to this problem when they tell me:
>
>"That is actually a bug in CF that was never resolved. The mail actually is
>gone forever. No way to check for unsent mail either. ASPmail seems to be
>the most reliable; so you may want to consider using that. More info on
>ASPmail is at (Link deleted)"
>
>I know some of you have some tips for this problem.
>
>HELP
>
~~
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: Authorize.Net or Cybercash or someone else?

[net_man]

We use CardServices and Linkpoint gateway with great success!!!

Robert Filipovich
ATSWebNet

- Original Message -
From: "Judith Campbell" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, March 06, 2001 4:54 PM
Subject: Re: Authorize.Net or Cybercash or someone else?


> This is form submit we use to send the data to payflow.  There are several
> configuration steps you have take, but their instructions are very
> clear.  The data is echoed back in the same form variables so once you
> receive them back  you can do with them as you wish.
>
> https://payflowlink.signio.com/paylinks.dll">
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>
>
>
>
> At 10:51 AM 3/6/01 -0800, you wrote:
> >Do you happen to have any sample source code for using this?
> >
> >Dustin M. Snell
> >Unisyn Software, LLC
> >Developers of AutoMate - The Leading Automation Software for Windows
> >http://www.unisyn.com
> >- Original Message -
> >From: "Jeff Beer" <[EMAIL PROTECTED]>
> >
> > > VeriSign bought Signio a while back - very fast, easy to use, stable,
and
> > > has a great price structure.
> > >
> > > Check out the PayFlowPro product.  It's hard to say five times
quickly,
> >but
> > > it works like a charm.
>
>
>
~~
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: cfmail not working sometimes

[Howie Hamlin]

One of  the problems with CFMAIL is that it only tries to deliver mail once.
If, for any reason, the mail is not sent there is no mechanism to retry.
Instead, the mail is moved to the UNDELIVR folder.  There are custom tags
for moving the mail back into the spool for retry.

I would consider this to be a limitation and not a bug.

Also, I don't think ASPMail would make things any better since it operates
in pretty much the same way AFAIK.

One other thing - the mail delivery failure can be caused by the ISP's mail
server rejecting the mail as well or being off-line (CFMAIL won't retry if
the mail server is not available)

I would try to get the ISP to install the CF tag for mail respooling.

HTH,

Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
www.CoolFusion.com
631-737-4668 x101
inFusion Mail Server (iMS) - the World's most configurable mail server
Get your free copy of iMS POST-SE Server from CoolFusion!

- Original Message -
From: "Josh R" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, March 06, 2001 9:52 PM
Subject: cfmail not working sometimes


> Does anyone have some basic solutions to the occasional (2-3%) emails not
> being sent? Not getting the occasional order alert (or help request, or
> confirmation, or...) is causing problems.
>
> I refuse to believe our ISP response to this problem when they tell me:
>
> "That is actually a bug in CF that was never resolved. The mail actually
is
> gone forever. No way to check for unsent mail either. ASPmail seems to be
> the most reliable; so you may want to consider using that. More info on
> ASPmail is at (Link deleted)"
>
> I know some of you have some tips for this problem.
>
> HELP
>
~~
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

cfmail not working sometimes

[Josh R]

Does anyone have some basic solutions to the occasional (2-3%) emails not 
being sent? Not getting the occasional order alert (or help request, or 
confirmation, or...) is causing problems.

I refuse to believe our ISP response to this problem when they tell me:

"That is actually a bug in CF that was never resolved. The mail actually is 
gone forever. No way to check for unsent mail either. ASPmail seems to be 
the most reliable; so you may want to consider using that. More info on 
ASPmail is at (Link deleted)"

I know some of you have some tips for this problem.

HELP
_
Get your FREE download of MSN Explorer at http://explorer.msn.com


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

Re: Authorize.Net or Cybercash or someone else?

[Judith Campbell]

This is form submit we use to send the data to payflow.  There are several 
configuration steps you have take, but their instructions are very 
clear.  The data is echoed back in the same form variables so once you 
receive them back  you can do with them as you wish.

https://payflowlink.signio.com/paylinks.dll">




































At 10:51 AM 3/6/01 -0800, you wrote:
>Do you happen to have any sample source code for using this?
>
>Dustin M. Snell
>Unisyn Software, LLC
>Developers of AutoMate - The Leading Automation Software for Windows
>http://www.unisyn.com
>- Original Message -
>From: "Jeff Beer" <[EMAIL PROTECTED]>
>
> > VeriSign bought Signio a while back - very fast, easy to use, stable, and
> > has a great price structure.
> >
> > Check out the PayFlowPro product.  It's hard to say five times quickly,
>but
> > it works like a charm.


~~
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: Determine if a variable has a value

[Michael S. Kimmett]

Bud,

Thank you !

Michael
- Original Message -
From: "Bud" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, March 06, 2001 10:41 AM
Subject: Re: Determine if a variable has a value


> On 3/5/01, Michael S. Kimmett penned:
> >Hello,
> >
> >I am new to ColdFusion, so this will be an easy answer to most of
> >you.  I am having difficulty trying to determine if a variable in
> >one of my pages has a value.  What I mean by a value is did I assign
> >it a value or is it still empty.  I have tried using IsDefined,
> >Evaluate, and other CF Functions, but they all are failing the test.
> >Any ideas on how to quickly and easly determine if variable has a
> >value.
> >
> >Thanks in advance.
>
> If you know the variable is set:
>
> 
>
> if you're not sure if you even set an empty default variable:
>
> 
> --
>
> Bud Schneehagen - Tropical Web Creations
>
> _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> ColdFusion Solutions / eCommerce Development
> [EMAIL PROTECTED]
> http://www.twcreations.com/
> 954.721.3452
>
>
~~
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: Redeliver and Undelivered Message

[Dave Watts]

> I just discovered a couple of mail messages in CF's UNDELIVR 
> directory. The error is in the CC address and easily fixed. How 
> can I "redeliver" these messages? Is just a matter of dropping 
> the .TMP files back in the SPOOL directory (after fixing the 
> mail address)?

That's worked fine for me in the past.

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: One page calls another

[Parker, Kevin]

Thank you Robert. This is an area I haven't previously used so if you'll
bare with me I think I'm beginning to understand it a bit better after
reading the relevant sections in Ben Forta's book.

The plan is to create a simple quiz comprising 7 pages, 5 for the quiz, one
to enter your details if you get to the end and one for the certificate.
Lets call them A, B, C, D, E, F and G. The test is not marked - you just
have to get to the last page E and answer the question right to qualify.

I think what I need to do is establish an application.cfm file to initialise
the variable rather than in the first page (correct me if I'm wrong please):




   





Then as you suggested check for the variable in page 2




 

What I also need to check is that someone else hasn't hopped in on the
details page and entered there own details to create further certificates
without doing the test by pressing the back button from the certificate
page. I think I can also use this to check for using the back button so that
someone doesn't manipulate previous answers to get the right outcome without
reviewing the material. I think if I retain the variable acvtivePage but
change its value page to page I can do this. Again correct me if I'm wrong
but the code in page 2 might look like this:







 

Then in page 3 check that session.activePage has a value of 2, then in page
4 check that session.activePage has a value of 3 etc This way if someone
hits the back button on say page 4 session.activePage would have a value of
3 whereas it should be 2 so the user should be sent back to index.cfm (but
I'm not quite sure how to code this come to think of it - I think I've got
it right).


+
Kevin Parker
Web Services Manager
WorkCover Corporation

[EMAIL PROTECTED]

www.workcover.com

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

+


-Original Message-
From: Robert Long [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 6 March 2001 10:04:AM
To: CF-Talk
Subject: RE: One page calls another


you could set some kind of variable (ie session, cookie, url, etc) that
would only be 
set on page 1 and if it doesn't exist then  them to page 1. Code
example below.

--Page 1---



-- Page 2 ---




Hth,
Robert



-Original Message-
From: Parker, Kevin [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 05, 2001 4:53 PM
To: CF-Talk
Subject: One page calls another



A little while ago I wrote to the list seeking some advice on how I could
ensure that a given page could not be loaded (lets call it B) unless the
user had come, by some means, from another specified page (lets call it A),
i.e. if the user went to direct to page B they would automatically be
directed back to page A.

Thank you to all of those that replied.

Because I'm not using forms in this app, using hidden fields, doesn't seem
workable. Someone suggested that I use HTTP Referrer but its unclear to me
how to use this, despite some research. Can anyone give me some
samples/examples on how to code this please.

TIA!


+
Kevin Parker
Web Services Manager
WorkCover Corporation

[EMAIL PROTECTED]

www.workcover.com

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

+




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

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

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

Re: Authorize.Net or Cybercash or someone else?

[Bud]

On 3/6/01, Dustin M. Snell [Unisyn Software, LLC] penned:
>Do you happen to have any sample source code for using this?

Sure. Here's a little synopsis of how it works. It's pretty archaic 
and took some testing. PayFlow link will call a page after you submit 
all the info through CFHTTP.  I set the parameter Return URL in the 
Payflow Link Form Configuration page to point to a page called 
payflow.cfm through a secure url.

https://your.secure.domain/payflow.cfm

Put this text into that file:






Then the myresult is output into the template that I call the 
cf_payflowlink tag with and I pick it up with cfhttp.filecontent.

I pass the parameters below using cfhttp. I can't remember exactly 
which ones are required. I seem to remember having problems when I 
deleted any. I do know that PAGENUM must remain "2". I set them all 
as defaults with cfparam but I won't include all that for space's 
sake. Here is the tag where I pass the parameters to the calling 
template. "METHOD" is either CC or eCheck. TYPE is AUTH_ONLY or 
AUTH_CAPTURE.



Here is the contents of the tag itself:




























































999 is my own which I set it I don't find the 

RE: URLtoken - OK w/proxies & dynamic IP addressing?

[Dave Watts]

> Looks like we're going to have to use client.URLtoken since 
> the customer doesn't want cookies required.
> 
> I've heard that the CFTOKEN is generated based on your IP 
> address (which is how the server knows it's you when you come 
> back) ...
> 
> but will CFTOKEN get confused if users come through proxies 
> or have dynamic IP addressing?

I don't think that CFTOKEN is generated based on your IP address. To the
best of my knowledge, it's generated using internal state information (time,
etc) within CF without regard to any info from the browser. CF will generate
a CFID and CFTOKEN for each user that doesn't send those variables back,
regardless of IP address.

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

URLtoken - OK w/proxies & dynamic IP addressing?

[Chris Norloff]

Looks like we're going to have to use client.URLtoken since the customer doesn't want 
cookies required.

I've heard that the CFTOKEN is generated based on your IP address (which is how the 
server knows it's you when you come back) ...

but will CFTOKEN get confused if users come through proxies or have dynamic IP 
addressing?

thanks,
Chris Norloff

~~
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: Secure to unsecure

[Howie Hamlin]

It's in the browser settings.  You can disable it for your browser but,
obviously, not for other users.

To change this in IE:

Open Tools/Internet Options
Click on the Advanced tab
Scroll down to the Security section - "Warn if changing between secure and
not secure mode"

In Netscape:

Open Communicator/Toos/Security Info
Click on Navigator
Uncheck the "Show warning before leaving an encrypted site" checkbox


HTH,

Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
www.CoolFusion.com
631-737-4668 x101
inFusion Mail Server (iMS) - the World's most configurable mail server
Get your free copy of iMS POST-SE Server from CoolFusion!

- Original Message -
From: "Cami Lawson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, March 06, 2001 2:18 PM
Subject: Secure to unsecure


> I have a page that is secure and within the page is a help link that pops
up a secondary window with the appropriate help information.  All is well
except that when the secondary window opens I also get a message about
leaving a secure site.  How can I stop this message, it happens in IE and
Netscape?
>
> TIA,
> Cami
>
>
>
>
~~
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

SQL Server Dev edition - oops

[Jon Hall]

I was wrong about the developers edition of SQL Server! Someone please smack
me with a large trout. I could swear it was downloadable somethime in the
past. Probably I'm nuts though.

I did locate it here for $500
http://shop.microsoft.com/Products/Products_Feed/Online/SQLServer2000[10145]
/ProductOverview.asp

jon




~~
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: Secure to unsecure

[Larry Juncker]

Save your help files in your secure folder or at least have a virtual file
under your secure side that points to the help files.

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


-Original Message-
From: Cami Lawson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 06, 2001 1:19 PM
To: CF-Talk
Subject: Secure to unsecure


I have a page that is secure and within the page is a help link that pops up
a secondary window with the appropriate help information.  All is well
except that when the secondary window opens I also get a message about
leaving a secure site.  How can I stop this message, it happens in IE and
Netscape?

TIA,
Cami
~~
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: Secure to unsecure

[Todd Stanley]

We run into that all the time if the cfm has an http reference instead of
https

-Original Message-
From: Cami Lawson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 06, 2001 2:19 PM
To: CF-Talk
Subject: Secure to unsecure


I have a page that is secure and within the page is a help link that pops up
a secondary window with the appropriate help information.  All is well
except that when the secondary window opens I also get a message about
leaving a secure site.  How can I stop this message, it happens in IE and
Netscape?

TIA,
Cami
~~
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: line breaks in excel

[Deanna L. Schneider]

Hm...I was using cfcontent (code snippet from a previous post by Ben Forta)
to create a csv file. We don't have the necessary stuff to use com for this.
I would just use the cf_excel custom tag (which we have installed) but I
need more control than that affords. I've got it working now, at least on my
machine. I'll have to do some testing on other platforms.

Thanks for the info, though. I might try playing with cffile for this, but
that requires asking permission from the server guys.

-d




Deanna Schneider
Interactive Media Developer
UWEX Cooperative Extension Electronic Publishing Group
103 Extension Bldg
432 N. Lake Street
Madison, WI 53706
(608) 265-7923




~~
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: Check out your ISP (was ISP's with CF)

[David Hannum]

It was not static.  These are dynamic sites done in Perl.  Yes, the
directory names and paths changed . . . .
The path
WAS: /usr/local/www/com/domain/blah
IS NOW:  /home/domain/blah

Major bummer . . .

Dave

- Original Message -
From: Raymond Camden <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Tuesday, March 06, 2001 10:04 AM
Subject: RE: Check out your ISP (was ISP's with CF)


> Hmm, why did you have to recode your site if it was static? (Well, you
said
> it was non-CF, so I guess it could be ASP.) I mean, if you reference
> imagines as img src="/images/foo.gif", don't tell me they actually made
you
> use a new directory name. If your site is dynamic, no matter what the
> technology is, if you do any kind of file reading and need absolute paths,
> be sure to keep the base directory as a global var. Then the ISP can move
> you around and it's no big deal.
>
> ===
> Raymond Camden, Principal Spectra Compliance Engineer for Allaire
>
> Email   : [EMAIL PROTECTED]
> ICQ UIN : 3679482
>
> "My ally is the Force, and a powerful ally it is." - Yoda
>
> > -Original Message-
> > From: David Hannum [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, March 06, 2001 9:43 AM
> > To: CF-Talk
> > Subject: OT: Check out your ISP (was ISP's with CF)
> >
> >
> > Lesson learned:  Check out how your ISP does business BEFORE you put
> > valuable sites on them.  Case in point.  I have an ISP that I put NON-CF
> > sites on.  This past weekend, they have hardware problems.  First, their
> > primary RAID failed, then in the process of restoring, the backup failed
> > too.  This in and of itself could be forgiven, BUT (and it's a BIG BUT),
> > they had no tape or CD backups, so every single website and everything
in
> > their MySQL database was lost.  Then, to add insult to injury, when they
> > rebuilt their system, they completely changed their directory
> > structure, so
> > not only must you re-upload your sites, but you must also recode your
site
> > to match their new directory structure.
> >
>
>
>
~~
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

Secure to unsecure

[Cami Lawson]

I have a page that is secure and within the page is a help link that pops up a 
secondary window with the appropriate help information.  All is well except that when 
the secondary window opens I also get a message about leaving a secure site.  How can 
I stop this message, it happens in IE and Netscape?

TIA,
Cami


~~
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: line breaks in excel

[Deanna L. Schneider]

Since I posted I figured out that if I put all my code on line 1, I don't
have the white space problem. But, sheesh. Talk about ugly code!

I'll try cfsilent, too.
d



Deanna Schneider
Interactive Media Developer
UWEX Cooperative Extension Electronic Publishing Group
103 Extension Bldg
432 N. Lake Street
Madison, WI 53706
(608) 265-7923




~~
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: line breaks in excel

[Philip Arnold - ASP]

> I have a page that is creating an excel spreadsheet using
> multiple queries.
> What happens is that a bunch of blank rows are generated in
> between the rows
> with data. This doesn't happen in the plain text file.
>
> I'd include the code, but it's long cause it's a many-tabled database that
> I'm attempting to flatten for the client. Ugh. I've used multiple
> loops, and
> it would appear that for each loop that is used, a blank line is
> added. I've
> tried wrapping all the output in  But,
> that doesn't help.

Are you creating the spreadsheet via CFContent, a CSV or COM?

If it's a CFContent then you really have to be careful with the output -
ensure you're laying it out in a Table

If you're using a CSV, then build it as a string and write it with a CFFile

If you're using COM, then I can't see how any blanks get in...

Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**



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

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

Re: Remote Modifying MS SQL

[Jon Hall]

You need to register the SQL Server that you are connecting to in Enterprise
Manager.
Just click Action/New SQL Server Registration
Type the IP address of the isp's SQL Server into Available Server's and
click Add
Use the SQL Server login and type in the Username and Password the isp gives
you.

Most isp's will not let you create a database though. You need to call them
and have them create it and give you a username and password. Then you can
log in and create your tables or whatever you want.

SQL Server Developers Edition is free for developers. So no you dont have to
buy it ;-)

jon
- Original Message -
From: "Chad Gray" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, March 06, 2001 10:23 AM
Subject: Remote Modifying MS SQL


> I searched the FAQ, and Archives, and did not see anything obvious.
>
> How do i connect to a remote SQL server so i can create a new DB?  I
played
> with the demo version of MS SQL, and it came with a client to connect to a
> remote SQL server.  Do i have to buy this client?
>
> I will be using a comma delimited file supplied by the client, and i need
> to get this file into the MS SQL server at our web host.
>
> Thanks,
> Chad
>
>
~~
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: line breaks in excel

[Patricia Lee]

Try  too.  It's a bit tricky because  will severly
repress your output in that you might have to specify  in cases
where it was before not necessary.

When creating a cf page that talks to flash white space is also anathema,
and I've learned that the combination cfsilent and cfsetting works to strip
out even the most persistent white space maybe it will help.

|-Original Message-
|From: Deanna L. Schneider [mailto:[EMAIL PROTECTED]]
|Sent: Tuesday, March 06, 2001 1:51 PM
|To: CF-Talk
|Subject: line breaks in excel
|
|
|Hi folks,
|I have a page that is creating an excel spreadsheet using 
|multiple queries.
|What happens is that a bunch of blank rows are generated in 
|between the rows
|with data. This doesn't happen in the plain text file.
|
|I'd include the code, but it's long cause it's a many-tabled 
|database that
|I'm attempting to flatten for the client. Ugh. I've used 
|multiple loops, and
|it would appear that for each loop that is used, a blank line 
|is added. I've
|tried wrapping all the output in  But,
|that doesn't help.
|
|Thoughts?
|
|-Deanna
|
|
|
|
|Deanna Schneider
|Interactive Media Developer
|UWEX Cooperative Extension Electronic Publishing Group
|103 Extension Bldg
|432 N. Lake Street
|Madison, WI 53706
|(608) 265-7923
|
|
|
|
|
~~
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: Authorize.Net or Cybercash or someone else?

[Dustin M. Snell [Unisyn Software, LLC]]

Do you happen to have any sample source code for using this?

Dustin M. Snell
Unisyn Software, LLC
Developers of AutoMate - The Leading Automation Software for Windows
http://www.unisyn.com
- Original Message -
From: "Jeff Beer" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, March 06, 2001 5:07 AM
Subject: RE: Authorize.Net or Cybercash or someone else?


> VeriSign bought Signio a while back - very fast, easy to use, stable, and
> has a great price structure.
>
> Check out the PayFlowPro product.  It's hard to say five times quickly,
but
> it works like a charm.
>
> -Original Message-
> From: Dustin M. Snell [Unisyn Software, LLC]
> [mailto:[EMAIL PROTECTED]]
> Sent: Monday, March 05, 2001 10:14 PM
> To: CF-Talk
> Subject: OT: Authorize.Net or Cybercash or someone else?
>
>
> Hello All,
>
> I have never been terribly enthusastic about Cybercash's quality of
service.
> I am hearing a lot about Authorize.net now.  Our site is all CF 4.5/W2K so
> good integration in that area is a must. Price, reliabilty, speed are also
> important of course. Does anyone have any opinions on this and or
> comparisons?
>
> If the answer is Authorize.net - could someone point me in the direction
to
> find CF integration instructions for online transaction processing?
>
> Thanks!
>
> Dustin M. Snell
> Unisyn Software, LLC
> Developers of AutoMate - The Leading Automation Software for Windows
> http://www.unisyn.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

line breaks in excel

[Deanna L. Schneider]

Hi folks,
I have a page that is creating an excel spreadsheet using multiple queries.
What happens is that a bunch of blank rows are generated in between the rows
with data. This doesn't happen in the plain text file.

I'd include the code, but it's long cause it's a many-tabled database that
I'm attempting to flatten for the client. Ugh. I've used multiple loops, and
it would appear that for each loop that is used, a blank line is added. I've
tried wrapping all the output in  But,
that doesn't help.

Thoughts?

-Deanna




Deanna Schneider
Interactive Media Developer
UWEX Cooperative Extension Electronic Publishing Group
103 Extension Bldg
432 N. Lake Street
Madison, WI 53706
(608) 265-7923




~~
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: End result: M$ licensing has me at wits end

[Kevin Miller]

Be safe.   Get this is writing.

Kevin

>>> [EMAIL PROTECTED] 03/06/01 10:33AM >>>
Well, after over a week back and forth with Microsoft's sales and 
licensing reps, they've come to the conclusion that since I'm not 
hosting any standalone apps that will be running on SQL Server, i.e., 
instead the data will be accessed through a web browser, I don't need 
to be licensed commercially or as an ASP. I can't say that I have a 
clue what they're talking about, as apparently they're not sure 
either, but at least if I end up in court I can say under oath that I 
talked to their licensing reps for over a week and they said "Go for 
it. Hosting SQL databases for internet access is NOT considered 
commercial hosting so all you need is CALs and the processor license 
covers those.".
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED] 
http://www.twcreations.com/ 
954.721.3452
~~
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: CFERROR Question

[Admin]

Put a  directive at the top of your page near the .
That will tell the browser relative to what folder it has to look for the
images.
Or just define the images with absolute rather than relative paths.

- Original Message -
From: "Corrine Clark" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, March 06, 2001 5:39 PM
Subject: CFERROR Question


> Good Morning,
> I have been trying to utilize my global error template processing, It does
> bring up the error page, but not the images if the error is not in the
same
> directory as the error page.  Both the application and error page are in
the
> root of my directory.  Could someone help me?
> Here is my code:
> Application.cfm:
> 
> 
>
> cferror_exception.cfm:
> 
> 
> FSC Intranet Exception Error Handling
> 
> 
>
> 
> 
> 
>  height="63" alt="" border="0">
> An Error Has Occurred
> 
> 
> #error.DateTime#
> #error.Template#
> #error.Browser#
> #error.HTTPReferer#
> #error.diagnostics#
> 
> Please contact yadayadayada
>
> 
> 
>
>
>
> Thank you
> Corrine Clark, FSC IT Dept.
> Wichita KS
>
>
> --
> NOTICE OF CONFIDENTIALITY
> ~~
> This message and all attachments are confidential.  It is intended only
for
> the use of the person to whom it is addressed.  If the message is not
> addressed to you, then you should immediately notify the sender and delete
> this message.  Any use or retransmission of this message by a person other
> than the intended recipient is strictly prohibited and may violate state
or
> federal law.
>
> Franchise Services Company, LLC, its subsidiaries, affiliates, and
> employees, do not accept liability for any errors, omissions, corruption
or
> virus in the contents of this message or any attachments that arise as a
> result of e-mail transmission.
> ~~
>
>
>
>
~~
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

End result: M$ licensing has me at wits end

[Bud]

Well, after over a week back and forth with Microsoft's sales and 
licensing reps, they've come to the conclusion that since I'm not 
hosting any standalone apps that will be running on SQL Server, i.e., 
instead the data will be accessed through a web browser, I don't need 
to be licensed commercially or as an ASP. I can't say that I have a 
clue what they're talking about, as apparently they're not sure 
either, but at least if I end up in court I can say under oath that I 
talked to their licensing reps for over a week and they said "Go for 
it. Hosting SQL databases for internet access is NOT considered 
commercial hosting so all you need is CALs and the processor license 
covers those.".
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452

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

Dynamically assigning SetClientCookies?

[Joseph Thompson]

Can anyone think of a good reason NOT to try something like this?

I have a prototype running but am wondering if it is breaking any "rules".
It is part of a "user managment" system so we can send cookies only to those
that "accept" 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

RE: Zombo.Com

[Moneymaker, Jon S (WPNSTA Yorktown)]

I love a sublime sense of humor...
I laughed, I cried, I hurled


too funny

-Original Message-
From: Brian Thornton [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 05, 2001 2:59 PM
To: CF-Talk
Subject: Zombo.Com


Found a very useful cold fusion site at www.zombo.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

OT: windows client for postgreSQL

[Jon Tillman]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Does anyone know of a decent windows client for PostgreSQL that isn't 
pgaccess? I thought I had seen one at one time, but I can't find it again 
now. The one I am thinking of also ran on Linux (?)

- -- 
Jon Tillman
http://www.eruditum.org

"VMS is a text-only adventure game. If you win you can use unix."

-BEGIN PGP SIGNATURE-
Version: PGP 6.5.1i

iQA/AwUBOqUU49ga7tZtnIOtEQK38wCeMZhx9w1rDI2Zyjz3fJOL8KFwHmkAoP1G
nWAb9/kSrRCgAJOzGNdGtpMJ
=Xh03
-END PGP SIGNATURE-

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

CFERROR Question

[Corrine Clark]

Good Morning, 
I have been trying to utilize my global error template processing, It does
bring up the error page, but not the images if the error is not in the same
directory as the error page.  Both the application and error page are in the
root of my directory.  Could someone help me?
Here is my code:
Application.cfm:



cferror_exception.cfm:


FSC Intranet Exception Error Handling







An Error Has Occurred


#error.DateTime#
#error.Template#
#error.Browser#
#error.HTTPReferer#
#error.diagnostics#

Please contact yadayadayada






Thank you
Corrine Clark, FSC IT Dept.
Wichita KS


-- 
NOTICE OF CONFIDENTIALITY 
~~
This message and all attachments are confidential.  It is intended only for
the use of the person to whom it is addressed.  If the message is not
addressed to you, then you should immediately notify the sender and delete
this message.  Any use or retransmission of this message by a person other
than the intended recipient is strictly prohibited and may violate state or
federal law. 

Franchise Services Company, LLC, its subsidiaries, affiliates, and
employees, do not accept liability for any errors, omissions, corruption or
virus in the contents of this message or any attachments that arise as a
result of e-mail transmission. 
~~ 



~~
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: Determine if a variable has a value

[Bud]

On 3/5/01, Michael S. Kimmett penned:
>Hello,
>
>I am new to ColdFusion, so this will be an easy answer to most of 
>you.  I am having difficulty trying to determine if a variable in 
>one of my pages has a value.  What I mean by a value is did I assign 
>it a value or is it still empty.  I have tried using IsDefined, 
>Evaluate, and other CF Functions, but they all are failing the test. 
>Any ideas on how to quickly and easly determine if variable has a 
>value.
>
>Thanks in advance.

If you know the variable is set:



if you're not sure if you even set an empty default variable:


-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452

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

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

RE: SQL Server...

[jeff tapper]

sorry about that everyone, I was responding to the wrong email.


At 12:59 AM 3/2/01 -0500, you wrote:
>i've never had the defaults/identity stuff transfer successfully, either.
>even between SQL installs, selecting "Transfer Objects".  i've resorted to
>scripting the tables, sticking the defaults in myself (scripting will
>capture the identities) and running the scripts on the target system.
>
>chris olive, cio
>cresco technologies
>[EMAIL PROTECTED]
>http://www.crescotech.com
>
>
>
>-Original Message-
>From: Dave Watts [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, March 01, 2001 9:02 PM
>To: CF-Talk
>Subject: RE: SQL Server...
>
>
> > I used the SQL Server export function (Data Transformation
> > Service) to move data (and table structure) from one SQL Server
> > database to a blank SQL Server database. Everything looked fine
> > initially, however I have realized that it did not copy over
> > default value. Nor did it copy over seed information.
> >
> > Is this common? Is there a better way to do this (Other than
> > detaching / attaching the database)? Although I haven't verified
> > it yet, I do suspect that I exported the data from a SQL Server
> > 2000 DB into a SQL Server 7 DB. Would I experience the same
> > results if this occurred between to SQL Server 2000 DBs?
>
>Typically, when transferring between two SQL 7 servers, you have an option
>to transfer "objects and data". This gets not only the tables and their
>data, but everything else as well.
>
>In addition, you can do a backup to file from one, then restore from file on
>the other. I've had better luck with that, with pre-SP versions of SQL 7.
>This is better than detaching and attaching, since you don't have to stop
>operation of the database on the source server, and you don't have problems
>with "phantom logins" that might exist in one server but not the other.
>(Although there is a way to address that, if necessary.)
>
>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: REMOVE

[Alex Schrimsher]

'nuf said



- Original Message -
From: "Braver, Ben:" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, March 06, 2001 11:20 AM
Subject: RE: REMOVE


> 
> Don't you mean "Marines"??
> "Marine's" is possessive, not plural
> isn't that why the Navy calls them "jarheads" (couldn't resist)
> BTW, I wasn't in *any* branch of the military, so go ahead and make stupid
> civilian jokes!
> 
>
> -Original Message-
> From: Michael [mailto:[EMAIL PROTECTED]]
> Sent: Monday, March 05, 2001 4:26 PM
> To: CF-Talk
> Subject: Re: REMOVE
>
>
> ARMYAint Ready for the Marine's Yet
>
> couldnt resist
>
>
> "Braver, Ben:" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > We need to have a "HUA" test -- to see whether the person uses the Army
> > version ("Heard, Understood, Acknowledged") or the other version ("Head
Up
> > A**")...
> >
> > -Original Message-
> > From: Bill Davidson [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, March 05, 2001 12:08 PM
> > To: CF-Talk
> > Subject: Re: REMOVE
> >
> >
> > I think we need to have a 'net-test' like we do with driving - if you
> can't
> > do a 3-point turn, you have no business to be on the road.  -- If you
> can't
> > unsubscribe from a listserv, you have no business to be on the internet.
> >
> > -Bill
> > /intraget
> >
>
~~
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: REMOVE

[Braver, Ben:]

Don't you mean "Marines"??
"Marine's" is possessive, not plural
isn't that why the Navy calls them "jarheads" (couldn't resist)
BTW, I wasn't in *any* branch of the military, so go ahead and make stupid
civilian jokes!


-Original Message-
From: Michael [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 05, 2001 4:26 PM
To: CF-Talk
Subject: Re: REMOVE


ARMYAint Ready for the Marine's Yet

couldnt resist


"Braver, Ben:" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> We need to have a "HUA" test -- to see whether the person uses the Army
> version ("Heard, Understood, Acknowledged") or the other version ("Head Up
> A**")...
>
> -Original Message-
> From: Bill Davidson [mailto:[EMAIL PROTECTED]]
> Sent: Monday, March 05, 2001 12:08 PM
> To: CF-Talk
> Subject: Re: REMOVE
>
>
> I think we need to have a 'net-test' like we do with driving - if you
can't
> do a 3-point turn, you have no business to be on the road.  -- If you
can't
> unsubscribe from a listserv, you have no business to be on the internet.
>
> -Bill
> /intraget
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: SQL Server...

[jeff tapper]

hit f5 to refresh.  go after the high priorities first.

At 12:59 AM 3/2/01 -0500, you wrote:
>i've never had the defaults/identity stuff transfer successfully, either.
>even between SQL installs, selecting "Transfer Objects".  i've resorted to
>scripting the tables, sticking the defaults in myself (scripting will
>capture the identities) and running the scripts on the target system.
>
>chris olive, cio
>cresco technologies
>[EMAIL PROTECTED]
>http://www.crescotech.com
>
>
>
>-Original Message-
>From: Dave Watts [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, March 01, 2001 9:02 PM
>To: CF-Talk
>Subject: RE: SQL Server...
>
>
> > I used the SQL Server export function (Data Transformation
> > Service) to move data (and table structure) from one SQL Server
> > database to a blank SQL Server database. Everything looked fine
> > initially, however I have realized that it did not copy over
> > default value. Nor did it copy over seed information.
> >
> > Is this common? Is there a better way to do this (Other than
> > detaching / attaching the database)? Although I haven't verified
> > it yet, I do suspect that I exported the data from a SQL Server
> > 2000 DB into a SQL Server 7 DB. Would I experience the same
> > results if this occurred between to SQL Server 2000 DBs?
>
>Typically, when transferring between two SQL 7 servers, you have an option
>to transfer "objects and data". This gets not only the tables and their
>data, but everything else as well.
>
>In addition, you can do a backup to file from one, then restore from file on
>the other. I've had better luck with that, with pre-SP versions of SQL 7.
>This is better than detaching and attaching, since you don't have to stop
>operation of the database on the source server, and you don't have problems
>with "phantom logins" that might exist in one server but not the other.
>(Although there is a way to address that, if necessary.)
>
>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: Advanced ColdFusion, UK, March 12th

[Aidan Whitehall]

> Company I suspect he means is Tech Connect 
> (www.tech-connect.com)

K - thanks for that.



-- 
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services

http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651

~~
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: Need some help with CFCONTENT

[Patricia Lee]

A while back I was trying to map extensions to mime types.  I looked in my
registry and copied a bunch of mime types that were listed for the
extensions.  This kis what I have for exe.

application/x-msdownload

maybe try that instead of application/octet-stream?

|-Original Message-
|From: Tracy Bost [mailto:[EMAIL PROTECTED]]
|Sent: Tuesday, March 06, 2001 10:48 AM
|To: CF-Talk
|Subject: Need some help with CFCONTENT
|
|
|I'm trying to allow users to download  particular files which 
|are executables.
|I'm also specifying the filepath for the executable.
|
|If I use some bogus mime type in the cfcontent, I get the 
|download dialog box with the coldfusion file name inside of
|it such as coldfusionfile.cfm... When I save, it saves the 
|executable that I have specified inside the cfcontent tag.
|I just have to rename the file from coldfusionfile.cfm to 
|myexcutable.exe, and it works...
|
| I would like to eliminate the step of having the users change 
|the .cfm to .exe in the "save as" box, or renaming the file 
|once downloaded...
|Have tried using application/octet-stream for the file type, 
|but this just shows binary data in the browser window and 
|doesn't download anything.
|
|
| Thanks for any help.
|   Tracy
|
|
|
~~
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: page error

[Jay Patton]

Jon,
Thanks i figured that something like that was the problem but it wasnt a top
priority page so i thought i would just send it out to see what i got back.
Thanks a lot,

Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
- Original Message -
From: "Jon Hall" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, March 05, 2001 6:16 PM
Subject: Re: page error


> Jay, you have way too many SQL queries on one page. In general looping
over
> a query should be avoided at all costs, not to mention two queries.
>
> I think a little research into SQL dot notation will help you a lot here.
I
> wish I had time to do a longer example for you, but I gotta get some work
> done ;-)
>
> Example:
> 
> SELECT EventManager.id, EventManager.RodeoDate, EventManager.EyebrowSize,
> RodeoManager.Score, RodeoManager.Winner
> FROM EventManager, RodeoManager
> WHERE EventID = '#eventID#'
> 
>
> This code wont work in your app, but I hope you see the power of having a
> peice of information that matches in the two tables. Instead of looping
over
> a query, all you would have to do is output one query! I believe the
EventID
> might be your key. It's hard to tell from the code.
>
> HTH
>
> jon
>
>
> - Original Message -
> From: "Jay Patton" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, March 05, 2001 7:09 PM
> Subject: page error
>
>
> > Can someone maybe tell me why i get this error on the web but not on my
> local machine? its only when this page is run. (both local and web are SQL
> 7) here is my code:(followed by the error)
> >
> > 
> >
> > 
> >  >  datasource="#datasource#"
> >  dbtype="ODBC"
> >  username="#username#"
> >  password="#password#">
> > SELECT *
> > FROM ContestantManager
> > WHERE ContestantID = #url.ContestantID#
> > 
> >
> > 
> >  >  datasource="#datasource#"
> >  dbtype="ODBC"
> >  username="#username#"
> >  password="#password#">
> > SELECT *
> > FROM EventManager
> > 
> >
> > 
> >  >  datasource="#datasource#"
> >  dbtype="ODBC">
> > SELECT RodeoID, EventID, SUM (AdjPoints) as AdjPoints, SUM (Points) as
> Points, SUM (MoneyEarned) as TotalMoneyAll, NotAllAround
> > FROM ResultsManager
> > WHERE ContestantID = #url.ContestantID#
> > GROUP BY RodeoID, EventID, NotAllAround
> > ORDER BY '#GetEvents.EventName#'
> > 
> > 
> > 
> > 
> > NSPRA - Contestant Results for #GetName.LastName#,
> #GetName.FirstName# (#GetName.Age#)
> > 
> >
> > 
> > 
> >   
> >  size="2">Individual Results For:
> >  size="2">#GetName.LastName#, #GetName.FirstName# (#GetName.Age#)
> #GetName.BirthDate# #GetName.CardNumber#
> >   
> > 
> > 
> > 
> >   
> >  size="1">Rodeo
> >  size="1">Event
> >  size="1">Points
> >  size="1">Adj. Points
> >  size="1">Money Won
> >  size="1">Total Points
> >  size="1">Include in AllAround (Y/N)
> >   
> >   
> >   
> >  size="1"> username="#username#" password="#password#" dbtype="ODBC">SELECT * FROM
> RodeoManager WHERE RodeoID =
'#GetResults.RodeoID#'#RodeoName.Rode
> oName#
> >  size="1">SELECT
*
> FROM EventManager WHERE EventID =
> '#GetResults.EventID#'#EventName.EventName#
> >  size="1">#GetResults.Points#
> >  size="1">#GetResults.AdjPoints#
> >  size="1"> username="#username#" password="#password#">SELECT MoneyEarned FROM
> ResultsManager WHERE EventID =
>
'#GetResults.EventID#'#NumberFormat(EventMoney.MoneyEarned,"$.
> __")#
> >  size="1">
> >  size="1">Y GetResults.NotAllAround EQ "1">N
> >   
> >   
> >   
> >  size="1">Rodeo
> >  size="1">Event
> >  size="1">Points
> >  size="1">Adj. Points
> >  size="1">Money Won
> >  size="1">Total Points
> >  size="1">Include in AllAround (Y/N)
> >   
> > 
> > 
> > 
> >   
> >  size="1">Total Money Won (All Events):
> >  size="1"> username="#username#" password="#password#" dbtype="ODBC">SELECT SUM
> (MoneyEarned) as TotalMoneyAll FROM ResultsManager WHERE ContestantID =
>
'#url.ContestantID#'#NumberFormat(TotalMoney.TotalMoneyAll,"$.
> __")#
> >   
> > 
> > 
> > 
> > 
> >
> > 
> >
> > 
> > ODBC Error Code = ()
> >
> >
> > Timed-out trying to get a connection to RODEO. The connection limit has
> been reached.
> >
> >
> >
> > The error occurred while processing an element with a general identifier
> of (CFQUERY), occupying document position (23:1) to (25:23).
> >
> > 
> >
> > Thanks,
> >
> > Jay Patton
> > Web Design / Application Design
> > Web Pro USA
> > 406.549.3337 ext. 203
> > 1.888.5WEBPRO
> > www.webpro-usa.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: Loops and Update queries

[Shannon Carr]

Thanks Patti,

It works!

It worked on the first try. Thanks so much for your help. I will be sure to
save as a snippet.

Shannon


- Original Message -
From: "Patricia Lee" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, March 06, 2001 10:17 AM
Subject: RE: Loops and Update queries


> I have an idea.
>
> List Functions.
>
> I'm assuming a bit, so let me know if I'm wrong (and I'm sure that others
> have a less cumbersome way to deal with your problem too, so don't think
> what I'm saying is at all the only way).
>
> I'm assuming that Quantity looks something like this: 1,2,3,4,5
> And Item number looks somethiing like this: F004,F005,F006,F007
>
> And F004 has a quantity of 1; F005 has a quantity of 2 etc.
>
> Take a look at this code... I've mocked up the same functionality set
a
> counter, incremented the counter while looping over one of my lists and
then
> used that counter to retreive a list element at the poisitoin represented
by
> the counter.
>
> 
> 
>
> 
> 
> 
> Counter = #counter# Qty = #qty#
> list2 = #ListGetAt(list2, counter)#
> 
> 
> 
>
>
> Output looks like:
>
> Counter = 1 Qty = 1 list2 = mom
> Counter = 2 Qty = 2 list2 = pop
> Counter = 3 Qty = 3 list2 = dad
> Counter = 4 Qty = 4 list2 = sis
>
> So all you'd have to do is loop over your quantity, find the
representative
> list element and then input both into the db via your query, which is of
> course nested in the loop.
>
> -Patti
> |-Original Message-
> |From: Shannon Carr [mailto:[EMAIL PROTECTED]]
> |Sent: Tuesday, March 06, 2001 9:02 AM
> |To: CF-Talk
> |Subject: Re: Loops and Update queries
> |
> |
> |Hi Patricia,
> |
> |No errors, just not sure how to write the syntax to make it work. The
> |problem I'm having is inputing a quanity in a form that was
> |generated by a
> |loop, then on the next page updating a table where the
> |Quantity is paired
> |with Item_Number.So far I can produce what I need in two
> |separate places.
> |Don't know how to combine the two.
> |
> |Note - F004 should have Quantity of 1
> |F065 Quantityof  2
> |A400 Quantity of 3
> |
> |ACTION PAGE TOP:
> |
> |#The_Item_Number#
> |
> |
> |
> |  UPDDATE   BOM
> |  SET  QUANTITY = '#TheQuantity#'
> |   WHERE  DRAWING_NUMBER = '#DRAWING_NUMBER#' AND ITEM_NUMBER = ???
> |
> |
> |ACTION PAGE DISPLAY:
> |F004
> |F065
> |A400
> |UPDDATE BOM SET QUANTITY = '1' WHERE DRAWING_NUMBER = 3000-04
> |
> |UPDDATE BOM SET QUANTITY = '2' WHERE DRAWING_NUMBER = 3000-04
> |
> |UPDDATE BOM SET QUANTITY = '3' WHERE DRAWING_NUMBER = 3000-04
> |
> |
> |
> |- Original Message -
> |From: "Patricia Lee" <[EMAIL PROTECTED]>
> |To: "CF-Talk" <[EMAIL PROTECTED]>
> |Sent: Monday, March 05, 2001 5:48 PM
> |Subject: RE: Loops and Update queries
> |
> |
> |> ARe you experiencing an error during some part of the
> |process?  Is it a
> |sql
> |> problem or a cf / display problem?  More detailed information please?
> |> Inluding any error messages if applicable...
> |>
> |> |-Original Message-
> |> |From: Shannon Carr [mailto:[EMAIL PROTECTED]]
> |> |Sent: Monday, March 05, 2001 4:17 PM
> |> |To: CF-Talk
> |> |Subject: Loops and Update queries
> |> |
> |> |
> |> |I am trying to update a table using values that were input on
> |> |a form using
> |> | .
> |> |
> |> |On the input form I am using a loop query to output the Item_Number,
> |> |Item_Description and Quantity fields. The user can update
> |the quantity.
> |> |
> |> |On the second page I would like to display inside a table, the
> |> |variables for
> |> |confirmation, then update the table once confirmed. I am
> |> |having a problem
> |> |parsing the Item_Number and Quantity fields together on the
> |display and
> |> |table update. The table being updated does not have a unique ID.
> |> |
> |> |
> |> |INPUT PAGE:
> |> |
> |> |
> |> | 
> |> |   #item_number#
> |> |   #Item_description#
> |> |  
> |> |   |> |maxlength="6"
> |> |   onFocus="window.status='Quantity'; return true">
> |> |   #CurrentRow#
> |> |  
> |> |
> |> | 
> |> | 
> |> |  |> |value="#ITEM_DESCRIPTION#">
> |> | 
> |> |
> |> |
> |> |Any help would be appreciated.
> |> |
> |> |Thanks,
> |> |Shannon
> |> |
> |> |
> |> |
> |>
> |>
> |
>
>
~~
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

Need some help with CFCONTENT

[Tracy Bost]

I'm trying to allow users to download  particular files which are executables.
I'm also specifying the filepath for the executable.

If I use some bogus mime type in the cfcontent, I get the download dialog box with the 
coldfusion file name inside of
it such as coldfusionfile.cfm... When I save, it saves the executable that I have 
specified inside the cfcontent tag.
I just have to rename the file from coldfusionfile.cfm to myexcutable.exe, and it 
works...

 I would like to eliminate the step of having the users change the .cfm to .exe in the 
"save as" box, or renaming the file once downloaded...
Have tried using application/octet-stream for the file type, but this just shows 
binary data in the browser window and doesn't download anything.


 Thanks for any help.
   Tracy


~~
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: Remote Modifying MS SQL

[Philip Arnold - ASP]

> I searched the FAQ, and Archives, and did not see anything obvious.
>
> How do i connect to a remote SQL server so i can create a new DB?
>  I played with the demo version of MS SQL, and it came with a client to
> connect to a remote SQL server.  Do i have to buy this client?
>
> I will be using a comma delimited file supplied by the client, and i need
> to get this file into the MS SQL server at our web host.

create database myDatabase

It's that simple!
You'll need to make a new ODBC/OLEDB to it unless you want it hidden and
refer to it as myDatabase.dbo.myTable all of the time

Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**



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

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

A request

[Philip Arnold - ASP]

I know I put my phone number in my Sig - the amount I post, I'm hardly
likely to take it off every post 

Can people not phone me to ask for help - I've had a few now, and although
I'm normally willing to help (it's why I'm on CF-Talk), I'm usually too busy
to spend 5-10 mins on the phone to people

I normally answer emails during "thinking time", so if you really want a bit
of personal help - email me and ask directly - I'll see what I can do
(including calling people back)...

Thanks

Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**




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

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

Remote Modifying MS SQL

[Chad Gray]

I searched the FAQ, and Archives, and did not see anything obvious.

How do i connect to a remote SQL server so i can create a new DB?  I played 
with the demo version of MS SQL, and it came with a client to connect to a 
remote SQL server.  Do i have to buy this client?

I will be using a comma delimited file supplied by the client, and i need 
to get this file into the MS SQL server at our web host.

Thanks,
Chad

~~
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: Loops and Update queries

[Patricia Lee]

I have an idea.

List Functions.

I'm assuming a bit, so let me know if I'm wrong (and I'm sure that others
have a less cumbersome way to deal with your problem too, so don't think
what I'm saying is at all the only way).

I'm assuming that Quantity looks something like this: 1,2,3,4,5
And Item number looks somethiing like this: F004,F005,F006,F007

And F004 has a quantity of 1; F005 has a quantity of 2 etc.

Take a look at this code... I've mocked up the same functionality set a
counter, incremented the counter while looping over one of my lists and then
used that counter to retreive a list element at the poisitoin represented by
the counter.







Counter = #counter# Qty = #qty#
list2 = #ListGetAt(list2, counter)#
 




Output looks like:

Counter = 1 Qty = 1 list2 = mom
Counter = 2 Qty = 2 list2 = pop
Counter = 3 Qty = 3 list2 = dad
Counter = 4 Qty = 4 list2 = sis

So all you'd have to do is loop over your quantity, find the representative
list element and then input both into the db via your query, which is of
course nested in the loop.

-Patti
|-Original Message-
|From: Shannon Carr [mailto:[EMAIL PROTECTED]]
|Sent: Tuesday, March 06, 2001 9:02 AM
|To: CF-Talk
|Subject: Re: Loops and Update queries
|
|
|Hi Patricia,
|
|No errors, just not sure how to write the syntax to make it work. The
|problem I'm having is inputing a quanity in a form that was 
|generated by a
|loop, then on the next page updating a table where the 
|Quantity is paired
|with Item_Number.So far I can produce what I need in two 
|separate places.
|Don't know how to combine the two.
|
|Note - F004 should have Quantity of 1
|F065 Quantityof  2
|A400 Quantity of 3
|
|ACTION PAGE TOP:
|
|#The_Item_Number#
|
|
|
|  UPDDATE   BOM
|  SET  QUANTITY = '#TheQuantity#'
|   WHERE  DRAWING_NUMBER = '#DRAWING_NUMBER#' AND ITEM_NUMBER = ???
|
|
|ACTION PAGE DISPLAY:
|F004
|F065
|A400
|UPDDATE BOM SET QUANTITY = '1' WHERE DRAWING_NUMBER = 3000-04
|
|UPDDATE BOM SET QUANTITY = '2' WHERE DRAWING_NUMBER = 3000-04
|
|UPDDATE BOM SET QUANTITY = '3' WHERE DRAWING_NUMBER = 3000-04
|
|
|
|- Original Message -
|From: "Patricia Lee" <[EMAIL PROTECTED]>
|To: "CF-Talk" <[EMAIL PROTECTED]>
|Sent: Monday, March 05, 2001 5:48 PM
|Subject: RE: Loops and Update queries
|
|
|> ARe you experiencing an error during some part of the 
|process?  Is it a
|sql
|> problem or a cf / display problem?  More detailed information please?
|> Inluding any error messages if applicable...
|>
|> |-Original Message-
|> |From: Shannon Carr [mailto:[EMAIL PROTECTED]]
|> |Sent: Monday, March 05, 2001 4:17 PM
|> |To: CF-Talk
|> |Subject: Loops and Update queries
|> |
|> |
|> |I am trying to update a table using values that were input on
|> |a form using
|> | .
|> |
|> |On the input form I am using a loop query to output the Item_Number,
|> |Item_Description and Quantity fields. The user can update 
|the quantity.
|> |
|> |On the second page I would like to display inside a table, the
|> |variables for
|> |confirmation, then update the table once confirmed. I am
|> |having a problem
|> |parsing the Item_Number and Quantity fields together on the 
|display and
|> |table update. The table being updated does not have a unique ID.
|> |
|> |
|> |INPUT PAGE:
|> |
|> |
|> | 
|> |   #item_number#
|> |   #Item_description#
|> |  
|> |   |maxlength="6"
|> |   onFocus="window.status='Quantity'; return true">
|> |   #CurrentRow#
|> |  
|> |
|> | 
|> | 
|> |  |value="#ITEM_DESCRIPTION#">
|> | 
|> |
|> |
|> |Any help would be appreciated.
|> |
|> |Thanks,
|> |Shannon
|> |
|> |
|> |
|>
|>
|
~~
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: Check out your ISP (was ISP's with CF)

[Raymond Camden]

Hmm, why did you have to recode your site if it was static? (Well, you said
it was non-CF, so I guess it could be ASP.) I mean, if you reference
imagines as img src="/images/foo.gif", don't tell me they actually made you
use a new directory name. If your site is dynamic, no matter what the
technology is, if you do any kind of file reading and need absolute paths,
be sure to keep the base directory as a global var. Then the ISP can move
you around and it's no big deal.

===
Raymond Camden, Principal Spectra Compliance Engineer for Allaire

Email   : [EMAIL PROTECTED]
ICQ UIN : 3679482

"My ally is the Force, and a powerful ally it is." - Yoda

> -Original Message-
> From: David Hannum [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 06, 2001 9:43 AM
> To: CF-Talk
> Subject: OT: Check out your ISP (was ISP's with CF)
>
>
> Lesson learned:  Check out how your ISP does business BEFORE you put
> valuable sites on them.  Case in point.  I have an ISP that I put NON-CF
> sites on.  This past weekend, they have hardware problems.  First, their
> primary RAID failed, then in the process of restoring, the backup failed
> too.  This in and of itself could be forgiven, BUT (and it's a BIG BUT),
> they had no tape or CD backups, so every single website and everything in
> their MySQL database was lost.  Then, to add insult to injury, when they
> rebuilt their system, they completely changed their directory
> structure, so
> not only must you re-upload your sites, but you must also recode your site
> to match their new directory structure.
>


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

OT: Check out your ISP (was ISP's with CF)

[David Hannum]

Lesson learned:  Check out how your ISP does business BEFORE you put
valuable sites on them.  Case in point.  I have an ISP that I put NON-CF
sites on.  This past weekend, they have hardware problems.  First, their
primary RAID failed, then in the process of restoring, the backup failed
too.  This in and of itself could be forgiven, BUT (and it's a BIG BUT),
they had no tape or CD backups, so every single website and everything in
their MySQL database was lost.  Then, to add insult to injury, when they
rebuilt their system, they completely changed their directory structure, so
not only must you re-upload your sites, but you must also recode your site
to match their new directory structure.

Lesson here - back up your site once a week yourself and ASK QUESTIONS.
Don't assume that "backup" means "tape or CD backup".

Dave



- Original Message -
From: Chris Montgomery <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Monday, March 05, 2001 9:10 PM
Subject: RE: ISP's with CF


> ABI Hosting: http://www.abihosting.com. No extra charge for SQL Server
> databases.
>
> Chris Montgomery [EMAIL PROTECTED]
>
> Web Development & Consulting http://www.astutia.com
> Allaire Consulting Partner
> 210-490-3249/888-745-7603Fax 210-490-4692
> AIM: astutiaweb; ICQ: 7381282; Firetalk: Ag78
>
> > -Original Message-
> > From: S R [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, March 05, 2001 4:06 PM
> >
> > I've been asked to build a website for a client. The website
> > is going to have forms, need some kind of database connectivity,
> > basically its a dynamic website. Does anyone know of an ISP out
> > there that offers Cold Fusion and preferably SQL Server
> > capabality? I don't think any of the major ones, like prodigy,
> > earthlink or AOL do.
>
> > Thanks for your help,
> >
> > Sal
>
>
>
~~
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: Advanced ColdFusion, UK, March 12th

[Jason Lees (National Express)]

I did the course last year, its a good course.  

Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: Chris Phillips [mailto:[EMAIL PROTECTED]]
Sent: 06 March 2001 14:51
To: CF-Talk
Subject: RE: Advanced ColdFusion, UK, March 12th


Company I suspect he means is Tech Connect (www.tech-connect.com) coz I'm
expecting to be in Kingston on 12th March too for an Advanced CF course!!! 

Chris Phillips
communisis one, Leeds

^-Original Message-
^From: Nick Betts [mailto:[EMAIL PROTECTED]]
^Sent: 06 March 2001 14:10
^To: CF-Talk
^Subject: RE: Advanced ColdFusion, UK, March 12th
^
^
^Aidan,
^I would be interested in this course.  Have you more details?
^
^Nick Betts
^PoulterNet
^
^-Original Message-
^From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
^Sent: 06 March 2001 14:00
^To: CF-Talk
^Subject: RE: Advanced ColdFusion, UK, March 12th
^
^
^> In Kingston - anyone else from here attending ?
^
^What company organises the courses?
^
^
^
^-- 
^Aidan Whitehall <[EMAIL PROTECTED]>
^Netshopper UK Ltd
^Advanced Web Solutions & Services
^
^http://www.netshopperuk.com/
^Telephone +44 (01744) 648650
^Fax +44 (01744) 648651
^
~~
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

OT:Looking for an Oracle person for a little job.

[Jeff Fongemie]

Hello Cf-Talk,

  I  have  a  project that was developed using an access database, and
  the  client has Oracle. The Oracle database is very small, 5 tables,
  and  while each is populated with a couple records, one is populated
  with name and address info of about 500 dealers.

  The  project  is  simple,  using  CF  to let the client add news and
  headlines to a news page, and a dealer search.

  So,  I'm looking for someone who has experience converting Access to
  Oracle.

  I  can  provide  a  copy  Access Database by email, and would like a
  quote on the job if possible.

  Can provide more details...


Best regards,
 Jeff Fongemie  mailto:[EMAIL PROTECTED]
 
Internet Guns For Hire
(603) 356-0768



~~
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: Advanced ColdFusion, UK, March 12th

[Nick Betts]

Thanks for that Chris.

Nick Betts. PoulterNet, Leeds, UK

-Original Message-
From: Chris Phillips [mailto:[EMAIL PROTECTED]]
Sent: 06 March 2001 14:51
To: CF-Talk
Subject: RE: Advanced ColdFusion, UK, March 12th


Company I suspect he means is Tech Connect (www.tech-connect.com) coz I'm
expecting to be in Kingston on 12th March too for an Advanced CF course!!! 

Chris Phillips
communisis one, Leeds

^-Original Message-
^From: Nick Betts [mailto:[EMAIL PROTECTED]]
^Sent: 06 March 2001 14:10
^To: CF-Talk
^Subject: RE: Advanced ColdFusion, UK, March 12th
^
^
^Aidan,
^I would be interested in this course.  Have you more details?
^
^Nick Betts
^PoulterNet
^
^-Original Message-
^From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
^Sent: 06 March 2001 14:00
^To: CF-Talk
^Subject: RE: Advanced ColdFusion, UK, March 12th
^
^
^> In Kingston - anyone else from here attending ?
^
^What company organises the courses?
^
^
^
^-- 
^Aidan Whitehall <[EMAIL PROTECTED]>
^Netshopper UK Ltd
^Advanced Web Solutions & Services
^
^http://www.netshopperuk.com/
^Telephone +44 (01744) 648650
^Fax +44 (01744) 648651
^
~~
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: Advanced ColdFusion, UK, March 12th

[Chris Phillips]

Company I suspect he means is Tech Connect (www.tech-connect.com) coz I'm
expecting to be in Kingston on 12th March too for an Advanced CF course!!! 

Chris Phillips
communisis one, Leeds

^-Original Message-
^From: Nick Betts [mailto:[EMAIL PROTECTED]]
^Sent: 06 March 2001 14:10
^To: CF-Talk
^Subject: RE: Advanced ColdFusion, UK, March 12th
^
^
^Aidan,
^I would be interested in this course.  Have you more details?
^
^Nick Betts
^PoulterNet
^
^-Original Message-
^From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
^Sent: 06 March 2001 14:00
^To: CF-Talk
^Subject: RE: Advanced ColdFusion, UK, March 12th
^
^
^> In Kingston - anyone else from here attending ?
^
^What company organises the courses?
^
^
^
^-- 
^Aidan Whitehall <[EMAIL PROTECTED]>
^Netshopper UK Ltd
^Advanced Web Solutions & Services
^
^http://www.netshopperuk.com/
^Telephone +44 (01744) 648650
^Fax +44 (01744) 648651
^
~~
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: CFLOCK, when to use...

[Andy]

Thanks.

- Original Message -
From: "Jon Hall" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, March 05, 2001 2:42 PM
Subject: Re: CFLOCK, when to use...


> When you open a new window with CTRL-N it is the same session since the
cfid
> and cftoken cookies (or url parameters) are still bound to you. So all the
> session variables would still be vaild in both browser windows.
>
> jon
>
> - Original Message -
> From: "Andy" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, March 05, 2001 12:05 PM
> Subject: Re: CFLOCK, when to use...
>
>
> > Along these same lines,  when I open a new window, is that a new
session?
> > If so, how are session variables such as User ID carried over?  CFToken,
> > CFID?
> >
> > Andy
> >
> > - Original Message -
> > From: "Dave Watts" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Friday, March 02, 2001 4:41 PM
> > Subject: RE: CFLOCK, when to use...
> >
> >
> > > > A previous message mentioned locking session variables when
> > > > you read or write them. Why? I thought session variables were
> > > > unique to the client.
> > >
> > > They are. That doesn't mean that they can't be accessed concurrently
by
> > that
> > > (multithreaded, frames-capable, back-button-enabled) client.
> > >
> > > 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: Advanced ColdFusion, UK, March 12th

[Nick Betts]

Aidan,
I would be interested in this course.  Have you more details?

Nick Betts
PoulterNet

-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: 06 March 2001 14:00
To: CF-Talk
Subject: RE: Advanced ColdFusion, UK, March 12th


> In Kingston - anyone else from here attending ?

What company organises the courses?



-- 
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services

http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651
~~
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 Function PART 2

[Aidan Whitehall]

> geesh, i wonder who else on this list doesn't have a sense of humor.

Plenty of people on this list have a sense of humour.

They *also* happen to have jobs, deadlines, other mailing lists, spouses,
responsibilities, lives away from the computer... need I go on?

No-one minds the odd wise-crack, but you seem to be making a habit recently
of posting unnecessary messages to the list (if you find a girl's name cute,
send your e-mail to her off the list next time).

There's enough traffic already.

And, as a side-note, where I come from, "hey, is there a coldfusion function
to make a killer beef fajita?" doesn't exactly constitute a joke.



-- 
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services

http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651

~~
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: Loops and Update queries

[Shannon Carr]

Hi Patricia,

No errors, just not sure how to write the syntax to make it work. The
problem I'm having is inputing a quanity in a form that was generated by a
loop, then on the next page updating a table where the Quantity is paired
with Item_Number.So far I can produce what I need in two separate places.
Don't know how to combine the two.

Note - F004 should have Quantity of 1
F065 Quantityof  2
A400 Quantity of 3

ACTION PAGE TOP:

#The_Item_Number#



  UPDDATE   BOM
  SET  QUANTITY = '#TheQuantity#'
   WHERE  DRAWING_NUMBER = '#DRAWING_NUMBER#' AND ITEM_NUMBER = ???


ACTION PAGE DISPLAY:
F004
F065
A400
UPDDATE BOM SET QUANTITY = '1' WHERE DRAWING_NUMBER = 3000-04

UPDDATE BOM SET QUANTITY = '2' WHERE DRAWING_NUMBER = 3000-04

UPDDATE BOM SET QUANTITY = '3' WHERE DRAWING_NUMBER = 3000-04



- Original Message -
From: "Patricia Lee" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, March 05, 2001 5:48 PM
Subject: RE: Loops and Update queries


> ARe you experiencing an error during some part of the process?  Is it a
sql
> problem or a cf / display problem?  More detailed information please?
> Inluding any error messages if applicable...
>
> |-Original Message-
> |From: Shannon Carr [mailto:[EMAIL PROTECTED]]
> |Sent: Monday, March 05, 2001 4:17 PM
> |To: CF-Talk
> |Subject: Loops and Update queries
> |
> |
> |I am trying to update a table using values that were input on
> |a form using
> | .
> |
> |On the input form I am using a loop query to output the Item_Number,
> |Item_Description and Quantity fields. The user can update the quantity.
> |
> |On the second page I would like to display inside a table, the
> |variables for
> |confirmation, then update the table once confirmed. I am
> |having a problem
> |parsing the Item_Number and Quantity fields together on the display and
> |table update. The table being updated does not have a unique ID.
> |
> |
> |INPUT PAGE:
> |
> |
> | 
> |   #item_number#
> |   #Item_description#
> |  
> |   |maxlength="6"
> |   onFocus="window.status='Quantity'; return true">
> |   #CurrentRow#
> |  
> |
> | 
> | 
> |  |value="#ITEM_DESCRIPTION#">
> | 
> |
> |
> |Any help would be appreciated.
> |
> |Thanks,
> |Shannon
> |
> |
> |
>
>
~~
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: Advanced ColdFusion, UK, March 12th

[Aidan Whitehall]

> In Kingston - anyone else from here attending ?

What company organises the courses?



-- 
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services

http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651

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

Another Security Question...

[Vance Duke]

I figured out the other Advanced Security issue and I wanted to say thank
you.

Now I have another question.  I have a Security context with all Domain
Users allowed the access the application.  No problem there.  NOW, I want to
limit a part of the application to just a certain subset of domain users
setup in a User Group.  Those users would have access to the main part of
the application, but also need access to the HR functions.  Do I need to set
up another security context and Authorize them against that context also (in
other words, 2 CFAuthenticate statements)?  Or how would I do that?  How do
I know that they are part of that User Group when they log in?

Thanks for the help,
Vance Duke


~~
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: Multiple Query Problem

[Todd Stanley]

Nick's right, you should do it in a join.  In case you are wondering why the
other way didn't work, it's because you aren't looping over the values of
the first query when you get to the second query.  You'd need to do
something like this:



SELECT * FROM prod
WHERE cat_id = '1' AND active = '1'
ORDER BY prod_priority





Select *
>From variants
WHERE prod_id = #get_prod.prod_id#






But don't do that.  Do the JOIN.




-Original Message-
From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 06, 2001 6:32 AM
To: CF-Talk
Subject: RE: Multiple Query Problem


Why not do a join ?


SELECT * FROM prod p, variants v
WHERE p.cat_id = '1' AND p.active = '1' AND p.prod_id = v.prod_id
ORDER BY p.prod_priority


Nick

-Original Message-
From: Chris Poole [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 06, 2001 10:57 AM
To: CF-Talk
Subject: Multiple Query Problem


To anyone who can help,

I am trying to output a list of records on a page, also nested in this list
are individually populated
drop down boxes which has values determined by the parent record. But before
I get to this stage I can't get the query
syntax right.

I can't quite get the query syntax right, below is what I have tried but I
only seem to get 1 variant and no more.
All the records are there but can't seem to output them. I have also tried
 tag but still can't get any more than
one row out of get_variants.


SELECT * FROM prod
WHERE cat_id = '1' AND active = '1'
ORDER BY prod_priority



Select *
>From variants
WHERE prod_id = #get_prod.prod_id#


Am probably being stuuupid due to sleep depravation.

If anyone can help I would appreciate it.

Cheers

Chris.


---
Chris Poole
Development Engineer

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


**
Information in this email is confidential and may be privileged. 
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**
~~
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

Advanced ColdFusion, UK, March 12th

[Thomas Chiverton]

In Kingston - anyone else from here attending ?

Regards,

Thomas Chiverton,
Intranet Architect and Desktop Analyst
Office: 01565 757 909
As a GUI, reality in useless...


~~
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: Authorize.Net or Cybercash or someone else?

[Bud]

On 3/5/01, Dustin M. Snell [Unisyn Software, LLC] penned:
>If the answer is Authorize.net - could someone point me in the direction to
>find CF integration instructions for online transaction processing?

Authorize.net works great with a simple cfhttp call. I use Ralph 
Fiol's cf_authorizenet tag which I've hacked to fix some of the 
parameters he had wrong on the result string.
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452

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