RE: CFSCRIPT-Reference

[Raymond B.]

http://www.allaire.com/cfdocs/Developing_Web_Applications_with_ColdFusion/20
_Extending_ColdFusion_Pages_with_CFML_Scripting/dwa20.htm

Just read the online docs Allaire has up (or in CFStudio) "Developing Web
Applications with ColdFusion" > "Extending ColdFusion Pages with CFML
Scripting". Pretty much just follow very basic JS syntax using CF operators.
It's rather limited, so don't expect ternary (? :) operators or even
anything as simple as += or ++ style shortcuts.

If in doubt semi-colon all expressions and enclose control statements in
curly brackets: They are rarely invalid in this class of syntax, just
unnecessary at times. Err on the side of extra keystrokes and you should be
fine.

-Original Message-
From: Brad Comer [mailto:[EMAIL PROTECTED]]
Sent: May 4, 2001 21:53
To: CF-Talk
Subject: CFSCRIPT-Reference


Can any one recommend a good reference for CFSCRIPT code. I realize it is
similar to CF code, but it is different in syntax.

Thanks In Advance!
Brad Comer
[EMAIL PROTECTED]
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

CFSCRIPT-Reference

[Brad Comer]

Can any one recommend a good reference for CFSCRIPT code. I realize it is
similar to CF code, but it is different in syntax.

Thanks In Advance!
Brad Comer
[EMAIL PROTECTED]


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

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

RE: connections

[Andrew Tyrone]

Becky,

You can use a UNC path, it just doesn't SEEM like you can ;)

Create a system DSN, go to select, and where the *.mdb is highlighted, type:

\\servername\directory\yourdb.mdb

I did this before I responded the first time, and it works like a charm.  I had never 
had the need to do it, so I wanted to make sure I was giving you good advice.

-Andy

> -Original Message-
> From: Jones, Becky [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 04, 2001 7:28 PM
> To: CF-Talk
> Subject: RE: connections
> 
> 
> that's my problem.
> i want to use a vnc path, but i cant if it is an access database. 
>  unless i
> am missing something...when it comes up to choose the path, it always
> selects a drive to map the connection to.  and that's what i dont want to
> do.  i know u can do what i want to do if the database is SQL.  
> like i said,
> not sure for access.  
> thanks,
>  bec.
> 
> -Original Message-
> From: Andrew Tyrone [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 04, 2001 7:02 PM
> To: CF-Talk
> Subject: RE: connections
> 
> 
> 
> 
> > -Original Message-
> > From: Jones, Becky [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, May 04, 2001 6:28 PM
> > To: CF-Talk
> > Subject: connections
> > 
> > 
> > hey
> > does anyone know how to set up the database connection on the 
> webserver if
> > your database is not located on your webserver??  i can do this if the
> > database is a SQL server...but i dont see how if the database is Access.
> > right now..i have to always have a specific drive letter mapped 
> > to my filer
> > in order for the applications that use the access database on 
> > that server to
> > run properly.  
> > any ideas are appreciated.
> > thanks,
> > bec.
> > 
> 
> Bec,
> 
> You can use UNC paths (\\myotherserver\directory\access.mdb) or 
> you can map
> a network drive and use that when selecting your .mdb file on the other
> server.  You set this up on the computer running ColdFusion, under the
> machine's Datasources. Also to make this work you must have the ColdFusion
> Application Server service log on as a user with the appropriate
> permissions.  While ColdFusion normally runs under the 
> LocalSystem account,
> the drawback to this is that it cannot access network drives--it has no
> network access rights.  So you can log on the service as a specific user
> with admin rights, say, and the service will be able to access the network
> drives (as long as they are set with the proper permissions, as well).
> 
> -Andy
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: What's the best way to deal with inexplicable error messages?

[Hubert Earl]

Hi,

Thanks for the feedback.  Having just solved a problem largely due to my
taking some time away from it, I'm seeing the value of the recommendation
you made in the first paragraph of your email below.  I discovered that the
problem wasn't at all the kind I'd been thinking it was, and taking 'time
out' allowed me to get a better perspective on it.

Hubert
---
Hubert Earl

ICQ#: 16199853
AIM: hubertfme

My Jamaican Art, Craft & More Online Store:
http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html


- Original Message -
From: "Bill Davidson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 04, 2001 6:48 PM
Subject: Re: What's the best way to deal with inexplicable error messages?


> From someone who has written code the majority of my life (usually for
> pleasure more than anything), the best thing to do is take some time away
> from the problem.  Not a lot, just enough so you're not seeing red.  If
you
> are frustrated, you're not going to be productive.  Go back later, and
> document your code as best as you can.  Document every friggin' line if
you
> have to.  See if your algorithms & methodologies make sense.
>
> Then start debugging.  I have never REALLY been able to get debugging
going
> in CF Studio.   That's one thing I'd love to rectify...
>
> Comment out sections of your code until you get a page that works. You may
> have to substitute the commented out code with strict setting of values to
> replace logic that otherwise exists.  Start isolating the problems, and
you
> can always add your own debugging code, like variable testing, and
> CFOUTPUTing your values as you go.
>
> This is also where a methodology like OOD (in other languages) or Fusebox
> (in Fusebox) helps a lot - you can isolate problems pretty quickly.  My
> fusebox code is so segmented that I can quickly see where the error is
> occurring.  It helps to have debug output on.
>
> Also, error messages/crashes in debug mode in compiled languages/etc
should
> be the easiest kind to fix as it tells you exactly where in the code
things
> are blowing up.  Logic bugs are the hardest to deal with.  They're a tiny
> bit of the reason I can't quit smoking. ;)
>
> -Bill
> brainbox
>
> - Original Message -
> From: "Hubert Earl" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, May 04, 2001 4:56 PM
> Subject: What's the best way to deal with inexplicable error messages?
>
>
> > Hi,
> >
> > What's the best way to deal with inexplicable error messages?  Is it:
> > a.  to slog away at the problem until the solution is found?
> > b.  to do something else, then come back after a while?
> > c.  to redo the code from scratch?
> >
> > I'd appreciate words of wisdom from cooler, more experienced heads,
since
> there *must* be a way to avoid the enormous frustration I often feel while
> coding! :-)
> >
> > Hubert
> > ---
> > Hubert Earl
> >
> > ICQ#: 16199853
> > AIM: hubertfme
> >
> > My Jamaican Art, Craft & More Online Store:
> http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html
> >
> >
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

ZDNet d e v e l o p e r ColdFusion Server 5

[David Hannum]

Look - a fairly decent review of CF 5

 http://www.zdnet.com/devhead/stories/articles/0,4413,2714811,00.html

Dave


~~
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: [RE: [Object Oriented CFML]]

[Alex]

No demand means no go.

"Chris Montgomery" <[EMAIL PROTECTED]> wrote:
What about Ruby? Anyone used that yet?

Chris Montgomery [EMAIL PROTECTED]  

Web Development & Consulting http://www.astutia.com
Allaire Sales & Consulting Partner  
210-490-3249/888-745-7603Fax 210-490-4692
Instant Messaging:
AIM: astutiaweb; ICQ: 7381282; MSN: [EMAIL PROTECTED]

> -Original Message-
> From: Alex [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 04, 2001 2:43 PM
> 
> I like easy things easy. Right tool for the right job. You want 
> OO I suggest
> java or python.
~~
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: [cold_fusion] Unusual Results, help

[Jeffry Houser]

At 03:55 PM 05/04/2001 -0400, you wrote:
> >:huh?:   Why would you expect an outer loop control variable to
> > increment in the inner loop?  It doesn't seem to make any sense to me.
>
>well, since LOOPING refers to the ability to go through each recordset and
>use its data in the code with in the beginning and ending of the loop
>controls, you would assume that the current pointer of the outside loop
>would be available to the inner loop...

   Available for read yes, but not for modifications.  I understand what 
you are saying now.  I haven't ever come across that.  I'll have to go 
looking through my code.  I'm sure I've done loops within loops.


Jeffry Houser | mailto:[EMAIL PROTECTED]
AIM: Reboog711  | ICQ: 5246969 | Phone: 860-229-2781
--
Instant ColdFusion 5.0  | ISBN: 0-07-213238-8
Due out June 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


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

FreeZip added to SimpleMessageBoard

[Tony Schreiber]

Thanks to John McGary for creating a freely-available zipcode database,
I've added a "Find Near" feature to the
freely-available SimpleMessageBoard.

The lack of users with zipcodes on the SMB Demo Forum makes it a bit hard
to test though. ;p

So, if y'all don't mind, can some of you register (with your zipcode) and
try it out a little bit?

You can click on a "Find Near" link in any user's profile with a zipcode
or use this currently undocumented url:

http://www.simplemessageboard.com/demo/users.cfm?ZipCode=X

Where X is any valid US ZipCode.

Thanks!

Tony Schreiber, Senior Partner  Man and Machine, Limited
mailto:[EMAIL PROTECTED]   http://www.technocraft.com

http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion
http://www.is300.net ___The Enthusiast's Home of the Lexus IS300
http://www.digitacamera.com __DigitA Camera Scripts and Tips
http://www.linklabexchange.com _Miata Link ECU Data Exchange



~~
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: ADA Section 508 Accessibility and CF tags

[Bonnie Betts]

To add to this, I've received a number of personal emails from persons
wanting me to post any findings I get.  I would appreciate replys to the
list on this subject so folks can see how many are interested in this
subject.  I saved all those emails tho and I will definitely email you any
answers I get (from the list or elsewhere).

Thanks,

Bonnie E. Betts
[EMAIL PROTECTED]
www.interacttechs.com


- Original Message -
From: "Bonnie Betts" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, May 02, 2001 11:47 PM
Subject: ADA Section 508 Accessibility and CF tags


> Can anyone point me to articles or information on whether certain tags are
Section 508 compliant?  Say for example, CFGRID. is that accessible to
disabled persons (a screen reader like JAWS or something)?
>
> MUCH tia!
>
> Bonnie E. Betts
> [EMAIL PROTECTED]
> www.interacttechs.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: ADA Section 508 Accessibility and CF tags

[Bonnie Betts]

Thanks Jeanne;

I've been working with Section 508 a little, but I'm looking for specifics
on CF tags like CFGrid mostly.  It's an applet and I don't know if the
screen readers can read that applet.  So I guess my question is, are CF
tags Section 508 compliant?  Which ones are not?  I searched the Allaire
site and found nothing on tags and compliance.  I'm now working on an
application that uses CFGrid extensively (for a government client).  I want
to know if we need to offer an alternative (or change the CFGrid to
something else) or if they are ok to leave in the application.  Since
government applications are supposed to be compliant by June 21st, I need to
find out if we need to extend the pilot date so we can make this change, or
if it is compliant we can stay on schedule.  Any advice on cftag compliance
is welcome!  (I've already almost memorized the w3c accessibility so I only
need cftag assistance).

Thanks again Jeanne.  That article is pretty much a repeat of the w3c
recommendations tho.

Bonnie E. Betts
[EMAIL PROTECTED]
www.interacttechs.com



> Hi Bonnie,
>
> Our Maryland CFUG hosted a talk given by Jon Brundage, on 508 requirements
> at our last meeting.  You can view his presentation under April 10, 2000:
> http://www.cfug-md.org/meetings.cfm
>
> I don't recall whether he touched on specific CFM tags, but it might be of
> some help.
>
> Best,
> - - - Jeanne
>
> - Original Message -
> From: Bonnie Betts <[EMAIL PROTECTED]>
> To: CF-Talk <[EMAIL PROTECTED]>
> Sent: Wednesday, May 02, 2001 11:47 PM
> Subject: ADA Section 508 Accessibility and CF tags
>
>
> > Can anyone point me to articles or information on whether certain tags
are
> Section 508 compliant?  Say for example, CFGRID. is that accessible to
> disabled persons (a screen reader like JAWS or something)?
> >
> > MUCH tia!
> >
> > Bonnie E. Betts
> > [EMAIL PROTECTED]
> > www.interacttechs.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: ADA Section 508 Accessibility and CF tags

[Bonnie Betts]

I don't know what a VBA site is but 'skip repetitve navigation links' was
handled by USPS by putting a transparent link at the top of the navbar named
"Skip Navigation Bar" with a target to the cell with the content of that
page.  That way when clicked, the screen reader would skip the navigation
and go to the content area.


> Whats a 'VBA' site ?
> And also - "A method shall be provided that permits users to skip
repetitive
> navigation links". What is that driving at, exactly ?
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Problem with login page

[Peter Tilbrook]

You should be able to use  rather than INPUT as
a hidden field.


~~
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: Inexpensive Hosting

[Patrick and Diane Thomlinson]

We have been using I-Wiz (www.iwiz.com) for a while and have had great luck
with uptime and also incredible support.

One domain is 15/month and 2 is 20/month.

Patrick Thomlinson
Allaire Certified ColdFusion Developer
TravelNow.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: CF/Java/ASP Comparision

[Patrick and Diane Thomlinson]

http://www.zdnetindia.com/techzone/coding/stories/7802.html

Patrick Thomlinson
Allaire Certified ColdFusion Developer
TravelNow.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: Has anyone seen this before?

[Sean Renet]

Pablo its more than just that, even if you update to that patch you will
still get that error if you are sending out a bunch of email at once.  I
don't think Allaire has thier arms completely around CFMAIL and CFFTP yet.
As I have posted before, here is what we do to pre-empt having the problem
occur.

Actually its not my solution, it was Tony Aly's solution and it works great.


 
THIS QUERY RETURNS THE PEOPLE YOU ARE SENDING TO
 





 #get_email_message.message_mem#
 .
 
 

 

   


Over the last 2 years we have tried everything imaginable in CF to
accomplish the same task and this is the only solution that has worked for
us.

You can get CFX_WAIT int the tag gallery in Allaire's Developer Exchange.
http://devex.allaire.com/developer/gallery/SearchResults.cfm?keywords=CFX_WA
IT&search=search

Hope that helps,

Sean Renet


- Original Message -
From: "Pablo Varando" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 04, 2001 4:01 PM
Subject: Re: Has anyone seen this before?


> Cool, thanks! That did it! :)
>
> Pablo
> http://www.cfm-resources.com
>
> - Original Message -
> From: "Bud" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, May 04, 2001 10:10 AM
> Subject: Re: Has anyone seen this before?
>
>
> > On 5/4/01, Pablo Varando penned:
> > >unknown exception condition
> > >
> > >TagCFMail::sendMessage
> > >
> > >The error occurred while processing an element with a general
> > >identifier of (CFMAIL), occupying document position (37:1) to
> > >(40:43).
> > >
> > >What exactly is this? anyone know how to get rid of it?
> >
> > Try this:
> >
> > http://www.allaire.com/Handlers/index.cfm?ID=15821&Method=Full
> > --
> >
> > 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: [Object Oriented CFML]

[Chris Montgomery]

What about Ruby? Anyone used that yet?

Chris Montgomery [EMAIL PROTECTED]  

Web Development & Consulting http://www.astutia.com
Allaire Sales & Consulting Partner  
210-490-3249/888-745-7603Fax 210-490-4692
Instant Messaging:
AIM: astutiaweb; ICQ: 7381282; MSN: [EMAIL PROTECTED]

> -Original Message-
> From: Alex [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 04, 2001 2:43 PM
> 
> I like easy things easy. Right tool for the right job. You want 
> OO I suggest
> java or python.


~~
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: BANNER AD PROGRAM

[William Wheatley]

AMEN i hear you it is a piece of shit program =) that i trully have learned
to dispise (sp)

Would you think i could get around the bottleneck on the local side, becuase
the ad server is a screamer, as well as both boxes are on our local network,
so i dont think transfer problems could be a problem, and if needed we could
do 1 ad box per domain.

We currently use CFHTTP's to grab the central ad ads and we've had no
problem with it at all EXCEPt for it pulling up default ads all the time =),
no way to SET ads to a specific number of HIts per month, unless you want to
set the ads to run 1 month only and then redo that EVERY month. I really
think it was a piece of garage, we're talking with double click now about
possibly getting there software licensed to use for us internally outside of
there network (because they are not much better IMHO). But i really want
something in CF that i can get my hands on and do what i want it and need it
to do =)

Thanks!
And i feel your pain


Bill Wheatley
Director of Development
Allaire Certified ColdFusion Developer
AEPS INC
Allaire ColdFusion Consulting Partner
www.aeps.com
www.aeps2000.com
954-472-6684 X303
ICQ: 417645



- Original Message -
From: "Jim McAtee" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 04, 2001 8:02 PM
Subject: Re: BANNER AD PROGRAM


> William,
>
> I've also thought about using CFHTTP to pull ads from a dedicated ad
server,
> but I'd think there would be serious performance problems.  First, you're
> forced to lock CFHTTP until you've output the variable cfhttp.filecontent.
> Secondly, each page that CF returns doesn't get passed on to the web
server
> until it's been completely rendered by CF.  So if you have a lot of CF
pages
> waiting on that single threaded CFHTTP that's pulling banners, it could
> become an enormous bottleneck.  More so if you've got banner ads on every
> page of a busy site or family of sites.
>
> BTW, we're also using CentralAd.  What a piece of unsupported garbage.  If
> you're doing remote ad calls (ala doubleclick) the clickthroughs often end
> up going to the wrong place, or else the server is incapable of figuring
it
> out at all and redirects to the 'default' ad's URL.  It's a really problem
> when users are going through proxies and the like.  I suspect as many as
> 10-20% of clickthroughs are being misdirected.  When it gets busy, we also
> have a problem with their CGI's hanging on the ad server and having to be
> manually killed off to free up memory and CPU cycles.
>
> Jim
>
>
> - Original Message -
> From: "William Wheatley" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, May 04, 2001 5:27 PM
> Subject: Re: BANNER AD PROGRAM
>
>
> > Yes i know they called me today its called DART its 7K to setup and 1000
a
> > month =) we have a program now but i want CF, and i would not have to
> worry
> > about mulptiple boxes because i have a dedicated AD box that i iwll use
a
> > CFHTTP to grab the ads from and the program on the ad box will decide,
> just
> > curious but i will look through allt he selections.
> >
> > The Doubleclick program looked nice it still did not do what i really
> wanted
> > it to do so =) i guess its time for me to hit the coding!!
> >
> >
> > Bill Wheatley
> > Director of Development
> > Allaire Certified ColdFusion Developer
> > AEPS INC
> > Allaire ColdFusion Consulting Partner
> > www.aeps.com
> > www.aeps2000.com
> > 954-472-6684 X303
> > ICQ: 417645
> >
> >
> >
> > - Original Message -
> > From: "Jon Hall" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Friday, May 04, 2001 6:39 PM
> > Subject: Re: BANNER AD PROGRAM
> >
> >
> > > None if you dont need to worry about weighted ads or targeted ads. As
> long
> > > as the program does not need to make decisions based upon how many
views
> > an
> > > ad has had, or which ad it should show now it does not matter.
> > > As soon as you need to know which ad to show next, rather than random
> ads,
> > > you have to be updating a counter and selecting it again on the next
ad
> > > view, if you have two different servers, where you cant cflock the
> entire
> > > program you then have a situation where concurrent users on different
> > > servers are being shown the same ad then updating the counter +1 each
> > time,
> > > and you just lost a rotation...or you get each rotation but you lose
an
> > > adview, depending on how you do your math.
> > > Since single threading a banner program by making the entire set of
> > queries
> > > a transaction is not an option even under moderate load, it can get a
> > little
> > > complex. I just personally dont think CF is the best solution for a
high
> > > transaction banner system...
> > > Even SQL Server has problems with concurrency that make it not ideal
> > either.
> > > >From what I have seen, at least one of the big banner companies uses
> > Oracle
> > > not SQL Server... I've been thinking about rewriting the banner
pr

Re: Problem with login page

[Hubert Earl]

Hi,

Thanks for the feedback.  Please see my next email for an update on my
efforts.

Hubert
---
Hubert Earl

ICQ#: 16199853
AIM: hubertfme

My Jamaican Art, Craft & More Online Store:
http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html


- Original Message -
From: "Semrau, Steven L Mr SRA" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 04, 2001 9:20 AM
Subject: RE: Problem with login page


> First, I would double check to make sure the name of that form field is
> UserPassword, if it can't find the form field.  You can also check your
> debug output in the Parameters section "Form Fields" which will display
all
> the form fields passed to that page as well as their values.
>
> Steven Semrau
> SRA International, Inc.
> Senior Member, Professional Staff
> [EMAIL PROTECTED]
> [EMAIL PROTECTED]
> Com:  (703) 805-1095
> DSN:  (703) 655-1095
>
>
> -Original Message-
> From: Hubert Earl [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 03, 2001 7:15 PM
> To: CF-Talk
> Subject: Problem with login page
>
>
> hi. when i submit my login page i get this error message:
>
> "
> Error Diagnostic Information
>
> An error occurred while evaluating the expression:
>
>
> #Form.UserPassword#
>
>
>
> Error near line 8, column 15.
> --
--
> 
>
> Error resolving parameter FORM.USERPASSWORD
>
>
> The specified form field cannot be found. This problem is very likely due
to
> the fact that you have misspelled the form field name.
>
>
>
> The error occurred while processing an element with a general identifier
of
> (#Form.UserPassword#), occupying document position (8:14) to (8:32)."
>
> This is the code I'm submitting, but darned if I could find anything wrong
> with it:
>
>  
> SELECT * FROM User
> WHERE UserName = '#Form.UserName#' AND
>  Password = '#Form.UserPassword#'
>   
>
> I've checked datasource name etc.  Could anyone suggest what I may be
> overlooking?  Thanks.
>
> ---
> Hubert Earl
>
> ICQ#: 16199853
> AIM: hubertfme
>
> My Jamaican Art, Craft & More Online Store:
> http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Problem with login page

[Hubert Earl]

Hi Jon et al,

Thanks for the response.

1.  I decided to redo the login form and the application tag, and now I'm
getting this error message after entering my username and userpassword:

"Form Entries Incomplete or Invalid
One or more problems exist with the data you have entered.
This field must be filled before submission of form.

Use the Back button on your web browser to return to the previous page and
correct the listed problems."

But both username and userpassword fields *have* been filled in.  Why is one
or both not being recognized?

2.  If I type in my user name, and leave the password field blank, nothing
happens when I press the login button when, according to the cfinput
required code, I should get an error message warning me that I need to fill
in the password.

3.  If I type in my password alone, I get the expected message generated by
a hidden input type value argument.

When remaking the login form, I dragged and dropped the names of the fields
from the database into studio's edit page using the database tab, to ensure
that I got all the names right.  Below is A. the code for the login form,
and B. the code for the application.cfm tag.  I'd appreciate any advice as
I'm totally stumped at this point.

A. clicologin.cfm






  
  
SELECT * FROM User
WHERE UserName = '#Form.UserName#'
 AND UserPassword = '#Form.UserPassword#'
  




  
  Sorry, invalid username or password. Please click
  here to try again.





  
  

  
  

  
  











 PROPOSAL FOR INSURANCE OF MONEY LOGIN PAGE




PROPOSAL FOR INSURANCE OF MONEY LOGIN PAGE
  Please log in below.

  

   
  
 
 User Name:
 
 
   
 
   
   
 
 
   Password:
 
 
   

   


  

 

  











B. clicoapplication.cfm





 





Hubert
---
Hubert Earl

ICQ#: 16199853
AIM: hubertfme

My Jamaican Art, Craft & More Online Store:
http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html


- Original Message -
From: "Jon Hall" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 04, 2001 2:59 AM
Subject: Re: Problem with login page


> So what is the name of the password field on your login page? Is it
> UserPassword?
>
> jon
> - Original Message -
> From: "Hubert Earl" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, May 03, 2001 7:15 PM
> Subject: Problem with login page
>
>
> > hi. when i submit my login page i get this error message:
> >
> > "
> > Error Diagnostic Information
> >
> > An error occurred while evaluating the expression:
> >
> >
> > #Form.UserPassword#
> >
> >
> >
> > Error near line 8, column 15.
>
> --
> --
> >
> > Error resolving parameter FORM.USERPASSWORD
> >
> >
> > The specified form field cannot be found. This problem is very likely
due
> to the fact that you have misspelled the form field name.
> >
> >
> >
> > The error occurred while processing an element with a general identifier
> of (#Form.UserPassword#), occupying document position (8:14) to (8:32)."
> >
> > This is the code I'm submitting, but darned if I could find anything
wrong
> with it:
> >
> >  
> > SELECT * FROM User
> > WHERE UserName = '#Form.UserName#' AND
> >  Password = '#Form.UserPassword#'
> >   
> >
> > I've checked datasource name etc.  Could anyone suggest what I may be
> overlooking?  Thanks.
> >
> > ---
> > Hubert Earl
> >
> > ICQ#: 16199853
> > AIM: hubertfme
> >
> > My Jamaican Art, Craft & More Online Store:
> http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html
> >
> >
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: client variables

[Peter Tilbrook]

Client variables are identified by the users browser. Open a web site in IE
and it will give you a different CFID and CFTOKEN than the same site opened
in Navigator. It is important that you track the "client" throughout your
site when using client variables - usually by appending #URLToken# on the
end of all URL's. eg:

http://www.mysite.com/edit.cfm?#URLToken#">Edit
Record

Just an idea anyway. Anyone else have a solution?

-Original Message-
From: Brook Davies [mailto:[EMAIL PROTECTED]]
Sent: Saturday, 5 May 2001 04:50
To: CF-Talk
Subject: client variables


I have a really strange report from a client about some irregularities in
an app we built for them. Essentially, there is a long client variable that
contains a delimited string of items. This long delimited list is used
throughout the app. This string is later stored in the DB.

Each record in the DB has its own identifiably string of delimited items.
When a user accesses a particular item, the DB record is read and that
delimited list is set as the client Var. The previous client vars are all
deleted.

Now, when my user views the entire string it looks normal. But if she
attempts to edit an item in the list, all of its properties change to an
item in another list from a separate record in the DB. Its seems as through
the previous client Var is still hanging around and sometimes being
selected from the clientVar repository instead of what should be the
currently active client Var.

Has any one seen anything like this happen before? Am I crazy?

Brook Davies
MaracasMedia.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: Credit Card DB Encryption Methodology

[Tony Schreiber]

Ok, I've been thinking about this. And in the case of returns or credits,
I think we could this:

On the website as the customer requests a return, they must enter their
password. I store this encrypted with the RMA number (or some other
associated id) as the key. Once the return is processed, the server uses
the RMA number to decrypt the password to decrypt the CC info and process
the credit...

Now I've comprised the security of those users with pending returns, but
that would be a small percentage of users at any given time. And if I'm
going to use an easily available key to encrypt the password temporarily,
it's almost not even worth the bother...

Still thinking.

OR, I would have to request the customer to login to the website and check
if their return has been received, then enter their password when prompted
in order to receive the credit.

Another issue is that I'm locked to doing ONLY real-time processing. If
the cc processing gateway is down, I can't take orders...

> So what are you doing in those cases, do you have to contact the customer?
> Curious...
> 
> > > I thought the reason most people kept card numbers around was
> > > for handling credits, delayed charges, and other problems (or
> > > possibly because of record-keeping requirements of their bank),
> > > or because they're doing the credit card charges manually (or
> > > at least with some human intervention) rather than in real
> > > time.  It doesn't seem like your solution would work in that
> > > situation.
> >
> > Correct, that wouldn't work here, because we don't have an unecrypted
> > version of the user's password available.
> >
> > > Keith C. Ivey <[EMAIL PROTECTED]>
> > > Webmaster, EEI Communications
> >
> >
> >
> > Tony Schreiber, Senior Partner  Man and Machine, Limited
> > mailto:[EMAIL PROTECTED]   http://www.technocraft.com
> >
> > http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion
> > http://www.is300.net ___The Enthusiast's Home of the Lexus IS300
> > http://www.digitacamera.com __DigitA Camera Scripts and Tips
> > http://www.linklabexchange.com _Miata Link ECU Data Exchange
> >
> >
> >
>
~~
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: connections

[Costas Piliotis]

Assuming you're on NT:

I don't think you can use the UNC with a file DSN...  Try mapping a drive to
the folder where the file resides and pointing the ODBC connection to that
file.  Than just use blah blah
blah

If not NT, dunno...

-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]] 
Sent: Friday, May 04, 2001 4:28 PM
To: CF-Talk
Subject: RE: connections


that's my problem.
i want to use a vnc path, but i cant if it is an access database.  unless i
am missing something...when it comes up to choose the path, it always
selects a drive to map the connection to.  and that's what i dont want to
do.  i know u can do what i want to do if the database is SQL.  like i said,
not sure for access.  
thanks,
 bec.

-Original Message-
From: Andrew Tyrone [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 04, 2001 7:02 PM
To: CF-Talk
Subject: RE: connections




> -Original Message-
> From: Jones, Becky [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 04, 2001 6:28 PM
> To: CF-Talk
> Subject: connections
> 
> 
> hey
> does anyone know how to set up the database connection on the 
> webserver if your database is not located on your webserver??  i can 
> do this if the database is a SQL server...but i dont see how if the 
> database is Access. right now..i have to always have a specific drive 
> letter mapped to my filer in order for the applications that use the 
> access database on that server to
> run properly.  
> any ideas are appreciated.
> thanks,
> bec.
> 

Bec,

You can use UNC paths (\\myotherserver\directory\access.mdb) or you can map
a network drive and use that when selecting your .mdb file on the other
server.  You set this up on the computer running ColdFusion, under the
machine's Datasources. Also to make this work you must have the ColdFusion
Application Server service log on as a user with the appropriate
permissions.  While ColdFusion normally runs under the LocalSystem account,
the drawback to this is that it cannot access network drives--it has no
network access rights.  So you can log on the service as a specific user
with admin rights, say, and the service will be able to access the network
drives (as long as they are set with the proper permissions, as well).

-Andy
~~
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: BANNER AD PROGRAM

[Jim McAtee]

William,

I've also thought about using CFHTTP to pull ads from a dedicated ad server,
but I'd think there would be serious performance problems.  First, you're
forced to lock CFHTTP until you've output the variable cfhttp.filecontent.
Secondly, each page that CF returns doesn't get passed on to the web server
until it's been completely rendered by CF.  So if you have a lot of CF pages
waiting on that single threaded CFHTTP that's pulling banners, it could
become an enormous bottleneck.  More so if you've got banner ads on every
page of a busy site or family of sites.

BTW, we're also using CentralAd.  What a piece of unsupported garbage.  If
you're doing remote ad calls (ala doubleclick) the clickthroughs often end
up going to the wrong place, or else the server is incapable of figuring it
out at all and redirects to the 'default' ad's URL.  It's a really problem
when users are going through proxies and the like.  I suspect as many as
10-20% of clickthroughs are being misdirected.  When it gets busy, we also
have a problem with their CGI's hanging on the ad server and having to be
manually killed off to free up memory and CPU cycles.

Jim


- Original Message -
From: "William Wheatley" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 04, 2001 5:27 PM
Subject: Re: BANNER AD PROGRAM


> Yes i know they called me today its called DART its 7K to setup and 1000 a
> month =) we have a program now but i want CF, and i would not have to
worry
> about mulptiple boxes because i have a dedicated AD box that i iwll use a
> CFHTTP to grab the ads from and the program on the ad box will decide,
just
> curious but i will look through allt he selections.
>
> The Doubleclick program looked nice it still did not do what i really
wanted
> it to do so =) i guess its time for me to hit the coding!!
>
>
> Bill Wheatley
> Director of Development
> Allaire Certified ColdFusion Developer
> AEPS INC
> Allaire ColdFusion Consulting Partner
> www.aeps.com
> www.aeps2000.com
> 954-472-6684 X303
> ICQ: 417645
>
>
>
> - Original Message -
> From: "Jon Hall" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, May 04, 2001 6:39 PM
> Subject: Re: BANNER AD PROGRAM
>
>
> > None if you dont need to worry about weighted ads or targeted ads. As
long
> > as the program does not need to make decisions based upon how many views
> an
> > ad has had, or which ad it should show now it does not matter.
> > As soon as you need to know which ad to show next, rather than random
ads,
> > you have to be updating a counter and selecting it again on the next ad
> > view, if you have two different servers, where you cant cflock the
entire
> > program you then have a situation where concurrent users on different
> > servers are being shown the same ad then updating the counter +1 each
> time,
> > and you just lost a rotation...or you get each rotation but you lose an
> > adview, depending on how you do your math.
> > Since single threading a banner program by making the entire set of
> queries
> > a transaction is not an option even under moderate load, it can get a
> little
> > complex. I just personally dont think CF is the best solution for a high
> > transaction banner system...
> > Even SQL Server has problems with concurrency that make it not ideal
> either.
> > >From what I have seen, at least one of the big banner companies uses
> Oracle
> > not SQL Server... I've been thinking about rewriting the banner program
in
> > Java because of the whole concurrency issue. When it comes down to it,
CF
> > and SQL SP's are essentially stateless, so the program has to make all
> it's
> > decisions and updates all at once. That's a whole lot of database
traffic.
> >
> > But then again, my statements only really apply for complex, high
> > transaction banner systems, not the majority of sites out there...
> > There is a guy from DoubleClick that occasionally posts here that has a
> real
> > nice banner program though, wonder how much. ;-)
> >
> > jon
> > - Original Message -
> > From: "Jim McAtee" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Friday, May 04, 2001 5:56 PM
> > Subject: Re: BANNER AD PROGRAM
> >
> >
> > > I can understand the potential performance problems, but what kind of
> > > concurrency issues do you have if you're storing all ad & campaign
data
> in
> > a
> > > central database?
> > >
> > > Jim
> > >
> > > - Original Message -
> > > From: "Jon Hall" <[EMAIL PROTECTED]>
> > > To: "CF-Talk" <[EMAIL PROTECTED]>
> > > Sent: Friday, May 04, 2001 3:45 PM
> > > Subject: Re: BANNER AD PROGRAM
> > >
> > >
> > > > One problem you are going to run into with ANY CF banner program is
> > > > performance first off, secondly is concurrency issues once you move
to
> > > more
> > > > than one server. If all you need is a counter, positions, and a
random
> > ad
> > > > then you are safe with just about anything, however once you move to
> > > > weighted ads concurre

RE: CF Error on Uploading Large files

[Garza, Jeff]

Yeah, plenty of RAM.  I was monitoring that while trying the upload process.
Actually, inetinfo.exe was taking the hit, not CF.  It never seemed to
transfer control back to the CF Engine to do the CFFILE part.  H?  I'm
used to CF's memory footprint going up in size to accommodate the uploaded
file, but it never spiked.

Jeff Garza
Web Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200

[EMAIL PROTECTED]
http://www.spectrumastro.com



-Original Message-
From: Brook Davies [mailto:[EMAIL PROTECTED]] 
Sent: Friday, May 04, 2001 4:30 PM
To: CF-Talk
Subject: Re: CF Error on Uploading Large files


Do you have lots of available ram? Twice as much as the size of the file 
your uploading?

Brook

At 04:12 PM 04/05/01 -0700, you wrote:
>Has anyone seen an error like this one???
>
>"Error","TID=279","05/04/01","15:56:50","Error reading remainder of content
>stream (total bytes = 16821955, available = 49152) Windows NT error
>number 10054 occurred."
>"Error","TID=279","05/04/01","15:56:50","Exception occurred during
>processing of ISAPI request (code = -1073741819)"
>I get this when uploading large files to the server and writing them using
>CFFILE.  I've restarted IIS, and CF...  No avail.
>This code has worked flawlessley for the past 5 months  Now this.  The
>browser never displays an error and CF doesn't spit out it's usual error
>either?  Just kinda hangs.
>
>Jeff Garza
>Web Developer/Webmaster
>Spectrum Astro, Inc.
>480.892.8200
>
>[EMAIL PROTECTED]
>http://www.spectrumastro.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

ultradev STUDIO =)

[William Wheatley]

For the love of god dont make Ultradev to be STUDIO all in one, i like CF STUDIO 
because it lets you have the flat text based editing and you can right click on any 
tag and edit it..then ultradev is great for GRAPHIC development, though ultradev does 
butcher some CF code if you drag and drop sometimes. I think that is due to the fact 
that Ultradev is tryign to be an END all it does ASP, JSP, PHP & CF =) since you guys 
own the company now maybe making UD focus more on CF first makign it perfect and then 
get it to run all the other program next. But if you can get Ultradev to integrate 
EVERYTHIGN about CF STUDIO (except the memory hogging, and the continous crashing) I 
think it would be a great product, but you might want to do what allaire did, they had 
HOMESITE, then to make CF STUDIO they just took HOMESITE and added some CF stuff to it 
and walla!..

Maybe take UD and add a CF MODE to it that opens a window like CF STUDIO to do text 
based working?? I don tknow just dont forget about the CF RDS integration i hate 
FTPing =)

Thx thats my 2 cents i know you guys will get it right


Bill Wheatley
Director of Development
Allaire Certified ColdFusion Developer
AEPS INC
Allaire ColdFusion Consulting Partner
www.aeps.com
www.aeps2000.com
954-472-6684 X303
ICQ: 417645





~~
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 Error on Uploading Large files

[Brook Davies]

Do you have lots of available ram? Twice as much as the size of the file 
your uploading?

Brook

At 04:12 PM 04/05/01 -0700, you wrote:
>Has anyone seen an error like this one???
>
>"Error","TID=279","05/04/01","15:56:50","Error reading remainder of content
>stream (total bytes = 16821955, available = 49152) Windows NT error
>number 10054 occurred."
>"Error","TID=279","05/04/01","15:56:50","Exception occurred during
>processing of ISAPI request (code = -1073741819)"
>I get this when uploading large files to the server and writing them using
>CFFILE.  I've restarted IIS, and CF...  No avail.
>This code has worked flawlessley for the past 5 months  Now this.  The
>browser never displays an error and CF doesn't spit out it's usual error
>either?  Just kinda hangs.
>
>Jeff Garza
>Web Developer/Webmaster
>Spectrum Astro, Inc.
>480.892.8200
>
>[EMAIL PROTECTED]
>http://www.spectrumastro.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: connections

[Jones, Becky]

that's my problem.
i want to use a vnc path, but i cant if it is an access database.  unless i
am missing something...when it comes up to choose the path, it always
selects a drive to map the connection to.  and that's what i dont want to
do.  i know u can do what i want to do if the database is SQL.  like i said,
not sure for access.  
thanks,
 bec.

-Original Message-
From: Andrew Tyrone [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 04, 2001 7:02 PM
To: CF-Talk
Subject: RE: connections




> -Original Message-
> From: Jones, Becky [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 04, 2001 6:28 PM
> To: CF-Talk
> Subject: connections
> 
> 
> hey
> does anyone know how to set up the database connection on the webserver if
> your database is not located on your webserver??  i can do this if the
> database is a SQL server...but i dont see how if the database is Access.
> right now..i have to always have a specific drive letter mapped 
> to my filer
> in order for the applications that use the access database on 
> that server to
> run properly.  
> any ideas are appreciated.
> thanks,
> bec.
> 

Bec,

You can use UNC paths (\\myotherserver\directory\access.mdb) or you can map
a network drive and use that when selecting your .mdb file on the other
server.  You set this up on the computer running ColdFusion, under the
machine's Datasources. Also to make this work you must have the ColdFusion
Application Server service log on as a user with the appropriate
permissions.  While ColdFusion normally runs under the LocalSystem account,
the drawback to this is that it cannot access network drives--it has no
network access rights.  So you can log on the service as a specific user
with admin rights, say, and the service will be able to access the network
drives (as long as they are set with the proper permissions, as well).

-Andy
~~
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: BANNER AD PROGRAM

[William Wheatley]

Yes i know they called me today its called DART its 7K to setup and 1000 a
month =) we have a program now but i want CF, and i would not have to worry
about mulptiple boxes because i have a dedicated AD box that i iwll use a
CFHTTP to grab the ads from and the program on the ad box will decide, just
curious but i will look through allt he selections.

The Doubleclick program looked nice it still did not do what i really wanted
it to do so =) i guess its time for me to hit the coding!!


Bill Wheatley
Director of Development
Allaire Certified ColdFusion Developer
AEPS INC
Allaire ColdFusion Consulting Partner
www.aeps.com
www.aeps2000.com
954-472-6684 X303
ICQ: 417645



- Original Message -
From: "Jon Hall" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 04, 2001 6:39 PM
Subject: Re: BANNER AD PROGRAM


> None if you dont need to worry about weighted ads or targeted ads. As long
> as the program does not need to make decisions based upon how many views
an
> ad has had, or which ad it should show now it does not matter.
> As soon as you need to know which ad to show next, rather than random ads,
> you have to be updating a counter and selecting it again on the next ad
> view, if you have two different servers, where you cant cflock the entire
> program you then have a situation where concurrent users on different
> servers are being shown the same ad then updating the counter +1 each
time,
> and you just lost a rotation...or you get each rotation but you lose an
> adview, depending on how you do your math.
> Since single threading a banner program by making the entire set of
queries
> a transaction is not an option even under moderate load, it can get a
little
> complex. I just personally dont think CF is the best solution for a high
> transaction banner system...
> Even SQL Server has problems with concurrency that make it not ideal
either.
> >From what I have seen, at least one of the big banner companies uses
Oracle
> not SQL Server... I've been thinking about rewriting the banner program in
> Java because of the whole concurrency issue. When it comes down to it, CF
> and SQL SP's are essentially stateless, so the program has to make all
it's
> decisions and updates all at once. That's a whole lot of database traffic.
>
> But then again, my statements only really apply for complex, high
> transaction banner systems, not the majority of sites out there...
> There is a guy from DoubleClick that occasionally posts here that has a
real
> nice banner program though, wonder how much. ;-)
>
> jon
> - Original Message -
> From: "Jim McAtee" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, May 04, 2001 5:56 PM
> Subject: Re: BANNER AD PROGRAM
>
>
> > I can understand the potential performance problems, but what kind of
> > concurrency issues do you have if you're storing all ad & campaign data
in
> a
> > central database?
> >
> > Jim
> >
> > - Original Message -
> > From: "Jon Hall" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Friday, May 04, 2001 3:45 PM
> > Subject: Re: BANNER AD PROGRAM
> >
> >
> > > One problem you are going to run into with ANY CF banner program is
> > > performance first off, secondly is concurrency issues once you move to
> > more
> > > than one server. If all you need is a counter, positions, and a random
> ad
> > > then you are safe with just about anything, however once you move to
> > > weighted ads concurrency becomes a huge problem.
> > > I has to rewrite an entire CF banner program as a stored procedure for
> > those
> > > exact reasons. It's smooth as butter now, serving up ~300,000+
weighted
> > > banners a day on a load balanced web site. Unfortunately it's not for
> > sale,
> > > but keep these issues in mind as you look for a banner program.
> > >
> > > 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: BANNER AD PROGRAM

[William Wheatley]

let me know what you started with =) cause i will have to do the same thing
i guess!


Bill Wheatley
Director of Development
Allaire Certified ColdFusion Developer
AEPS INC
Allaire ColdFusion Consulting Partner
www.aeps.com
www.aeps2000.com
954-472-6684 X303
ICQ: 417645



- Original Message -
From: "Jon Hall" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 04, 2001 5:45 PM
Subject: Re: BANNER AD PROGRAM


> One problem you are going to run into with ANY CF banner program is
> performance first off, secondly is concurrency issues once you move to
more
> than one server. If all you need is a counter, positions, and a random ad
> then you are safe with just about anything, however once you move to
> weighted ads concurrency becomes a huge problem.
> I has to rewrite an entire CF banner program as a stored procedure for
those
> exact reasons. It's smooth as butter now, serving up ~300,000+ weighted
> banners a day on a load balanced web site. Unfortunately it's not for
sale,
> but keep these issues in mind as you look for a banner program.
>
> jon
> - Original Message -
> From: "William J Wheatley" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, May 04, 2001 5:01 PM
> Subject: BANNER AD PROGRAM
>
>
> > ok i want a banner ad program that runs in CF
> >
> > what we have now is this
> >
> > www.centralad.com
> >
> > SELL ME =0) i would prefer the source and i would prefer it to be robust
> =)
> >
> >
> > Bill Wheatley
> > Director of Development
> > AEPS INC
> > Allaire ColdFusion Consulting Partner
> > Allaire Certified ColdFusion Developer
> > http://www.aeps.com
> > ICQ: 417645
> > 954-472-6684 X303
> >
> > 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 unauthorized 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

CF Error on Uploading Large files

[Garza, Jeff]

Has anyone seen an error like this one???

"Error","TID=279","05/04/01","15:56:50","Error reading remainder of content
stream (total bytes = 16821955, available = 49152) Windows NT error
number 10054 occurred." 
"Error","TID=279","05/04/01","15:56:50","Exception occurred during
processing of ISAPI request (code = -1073741819)" 
I get this when uploading large files to the server and writing them using
CFFILE.  I've restarted IIS, and CF...  No avail.
This code has worked flawlessley for the past 5 months  Now this.  The
browser never displays an error and CF doesn't spit out it's usual error
either?  Just kinda hangs.

Jeff Garza
Web Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200

[EMAIL PROTECTED]
http://www.spectrumastro.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: connections

[Andrew Tyrone]

> -Original Message-
> From: Jones, Becky [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 04, 2001 6:28 PM
> To: CF-Talk
> Subject: connections
> 
> 
> hey
> does anyone know how to set up the database connection on the webserver if
> your database is not located on your webserver??  i can do this if the
> database is a SQL server...but i dont see how if the database is Access.
> right now..i have to always have a specific drive letter mapped 
> to my filer
> in order for the applications that use the access database on 
> that server to
> run properly.  
> any ideas are appreciated.
> thanks,
> bec.
> 

Bec,

You can use UNC paths (\\myotherserver\directory\access.mdb) or you can map a network 
drive and use that when selecting your .mdb file on the other server.  You set this up 
on the computer running ColdFusion, under the machine's Datasources. Also to make this 
work you must have the ColdFusion Application Server service log on as a user with the 
appropriate permissions.  While ColdFusion normally runs under the LocalSystem 
account, the drawback to this is that it cannot access network drives--it has no 
network access rights.  So you can log on the service as a specific user with admin 
rights, say, and the service will be able to access the network drives (as long as 
they are set with the proper permissions, as well).

-Andy


~~
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: Has anyone seen this before?

[Pablo Varando]

Cool, thanks! That did it! :)

Pablo
http://www.cfm-resources.com

- Original Message -
From: "Bud" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 04, 2001 10:10 AM
Subject: Re: Has anyone seen this before?


> On 5/4/01, Pablo Varando penned:
> >unknown exception condition
> >
> >TagCFMail::sendMessage
> >
> >The error occurred while processing an element with a general
> >identifier of (CFMAIL), occupying document position (37:1) to
> >(40:43).
> >
> >What exactly is this? anyone know how to get rid of it?
>
> Try this:
>
> http://www.allaire.com/Handlers/index.cfm?ID=15821&Method=Full
> --
>
> 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: Credit Card DB Encryption Methodology

[Bill Davidson]

So what are you doing in those cases, do you have to contact the customer?
Curious...

By the way, I think you've done a great job of dealing with CC encryption.
Good approach.  Even though the major on-line vendor site that we've written
doesn't do credit card processing, we still prompt for the password before
the order is placed.  Yeah, its a small pain for the customer, but it is a
whole lot more secure Especially in this application where it is mostly
college students, who may easily log in, walk away from a public terminal,
and forget to logout.

-Bill
www.brainbox.tv


> > I thought the reason most people kept card numbers around was
> > for handling credits, delayed charges, and other problems (or
> > possibly because of record-keeping requirements of their bank),
> > or because they're doing the credit card charges manually (or
> > at least with some human intervention) rather than in real
> > time.  It doesn't seem like your solution would work in that
> > situation.
>
> Correct, that wouldn't work here, because we don't have an unecrypted
> version of the user's password available.
>
> > Keith C. Ivey <[EMAIL PROTECTED]>
> > Webmaster, EEI Communications
>
>
>
> Tony Schreiber, Senior Partner  Man and Machine, Limited
> mailto:[EMAIL PROTECTED]   http://www.technocraft.com
>
> http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion
> http://www.is300.net ___The Enthusiast's Home of the Lexus IS300
> http://www.digitacamera.com __DigitA Camera Scripts and Tips
> http://www.linklabexchange.com _Miata Link ECU Data Exchange
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: What's the best way to deal with inexplicable error messages?

[Bill Davidson]

>From someone who has written code the majority of my life (usually for
pleasure more than anything), the best thing to do is take some time away
from the problem.  Not a lot, just enough so you're not seeing red.  If you
are frustrated, you're not going to be productive.  Go back later, and
document your code as best as you can.  Document every friggin' line if you
have to.  See if your algorithms & methodologies make sense.

Then start debugging.  I have never REALLY been able to get debugging going
in CF Studio.   That's one thing I'd love to rectify...

Comment out sections of your code until you get a page that works. You may
have to substitute the commented out code with strict setting of values to
replace logic that otherwise exists.  Start isolating the problems, and you
can always add your own debugging code, like variable testing, and
CFOUTPUTing your values as you go.

This is also where a methodology like OOD (in other languages) or Fusebox
(in Fusebox) helps a lot - you can isolate problems pretty quickly.  My
fusebox code is so segmented that I can quickly see where the error is
occurring.  It helps to have debug output on.

Also, error messages/crashes in debug mode in compiled languages/etc should
be the easiest kind to fix as it tells you exactly where in the code things
are blowing up.  Logic bugs are the hardest to deal with.  They're a tiny
bit of the reason I can't quit smoking. ;)

-Bill
brainbox

- Original Message -
From: "Hubert Earl" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 04, 2001 4:56 PM
Subject: What's the best way to deal with inexplicable error messages?


> Hi,
>
> What's the best way to deal with inexplicable error messages?  Is it:
> a.  to slog away at the problem until the solution is found?
> b.  to do something else, then come back after a while?
> c.  to redo the code from scratch?
>
> I'd appreciate words of wisdom from cooler, more experienced heads, since
there *must* be a way to avoid the enormous frustration I often feel while
coding! :-)
>
> Hubert
> ---
> Hubert Earl
>
> ICQ#: 16199853
> AIM: hubertfme
>
> My Jamaican Art, Craft & More Online Store:
http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html
>
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: What's the best way to deal with inexplicable error messages?

[Jon Hall]

I choose A, which usually ends up leading to C which then ends up with me
doing B. ;-)

jon
- Original Message -
From: "Hubert Earl" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 04, 2001 4:56 PM
Subject: What's the best way to deal with inexplicable error messages?


> Hi,
>
> What's the best way to deal with inexplicable error messages?  Is it:
> a.  to slog away at the problem until the solution is found?
> b.  to do something else, then come back after a while?
> c.  to redo the code from scratch?
>
> I'd appreciate words of wisdom from cooler, more experienced heads, since
there *must* be a way to avoid the enormous frustration I often feel while
coding! :-)
>
> Hubert
> ---
> Hubert Earl
>
> ICQ#: 16199853
> AIM: hubertfme
>
> My Jamaican Art, Craft & More Online Store:
http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html
>
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: BANNER AD PROGRAM

[Jon Hall]

None if you dont need to worry about weighted ads or targeted ads. As long
as the program does not need to make decisions based upon how many views an
ad has had, or which ad it should show now it does not matter.
As soon as you need to know which ad to show next, rather than random ads,
you have to be updating a counter and selecting it again on the next ad
view, if you have two different servers, where you cant cflock the entire
program you then have a situation where concurrent users on different
servers are being shown the same ad then updating the counter +1 each time,
and you just lost a rotation...or you get each rotation but you lose an
adview, depending on how you do your math.
Since single threading a banner program by making the entire set of queries
a transaction is not an option even under moderate load, it can get a little
complex. I just personally dont think CF is the best solution for a high
transaction banner system...
Even SQL Server has problems with concurrency that make it not ideal either.
>From what I have seen, at least one of the big banner companies uses Oracle
not SQL Server... I've been thinking about rewriting the banner program in
Java because of the whole concurrency issue. When it comes down to it, CF
and SQL SP's are essentially stateless, so the program has to make all it's
decisions and updates all at once. That's a whole lot of database traffic.

But then again, my statements only really apply for complex, high
transaction banner systems, not the majority of sites out there...
There is a guy from DoubleClick that occasionally posts here that has a real
nice banner program though, wonder how much. ;-)

jon
- Original Message -
From: "Jim McAtee" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 04, 2001 5:56 PM
Subject: Re: BANNER AD PROGRAM


> I can understand the potential performance problems, but what kind of
> concurrency issues do you have if you're storing all ad & campaign data in
a
> central database?
>
> Jim
>
> - Original Message -
> From: "Jon Hall" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, May 04, 2001 3:45 PM
> Subject: Re: BANNER AD PROGRAM
>
>
> > One problem you are going to run into with ANY CF banner program is
> > performance first off, secondly is concurrency issues once you move to
> more
> > than one server. If all you need is a counter, positions, and a random
ad
> > then you are safe with just about anything, however once you move to
> > weighted ads concurrency becomes a huge problem.
> > I has to rewrite an entire CF banner program as a stored procedure for
> those
> > exact reasons. It's smooth as butter now, serving up ~300,000+ weighted
> > banners a day on a load balanced web site. Unfortunately it's not for
> sale,
> > but keep these issues in mind as you look for a banner program.
> >
> > 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

connections

[Jones, Becky]

hey
does anyone know how to set up the database connection on the webserver if
your database is not located on your webserver??  i can do this if the
database is a SQL server...but i dont see how if the database is Access.
right now..i have to always have a specific drive letter mapped to my filer
in order for the applications that use the access database on that server to
run properly.  
any ideas are appreciated.
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: CF Studio and UltraDev Merging!

[John Dowdell]

At 9:15 PM 5/3/1, Michael Kear wrote:
> Anyway, unless we have some input to Macromedia, we'll end up
> with a Studio that looks like Ultradev.

As noted previously, this is understood, but if you'd still like to drive
it home, then [EMAIL PROTECTED] would directly reach
the in-boxes of the integration team, thanks. (There are also
product-specific addresses too, but this top-level address reaches general
execs as well.)

For the thread itself, yup, it's a bundle... if you see a way that the web
page is unclear then a note to the product wishlist would route it
directly, thanks.

(btw, we don't have a cafeteria, although the lavatories *do* have adequate
head height ;-)

jd





John Dowdell, Macromedia Tech Support, San Francisco CA US
Search technotes: http://www.macromedia.com/support/search/
Offlist email risks capture by the spam filters. I may not see your
email if it's not on the list. Private one-on-one email options are
available via Priority Access: http://www.macromedia.com/support/



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

IIS Script Mapping Limit?

[Kevin Miller]

Is there a real or practical limit (from a performance standpoint) to the number of 
IIS script engine mappings in IIS 4.0?  

Thanks,

Kevin


~~
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: handling 404 errors with CF?

[Bill Davidson]

Yeah, actually I wrote a whole functionality-set of CF catching 404's.  I
wanted a way to handle "virtual directories" - like www.brainbox.tv/clients
for instance - there's no folder there, but instead I wanted it to relocate
to a point in our main fusebox app.  One of our developers suggested an
ingeniously simple way of doing it, so here's what I did..

In IIS, I pointed 404's to a CF template that checks to see if the
administrator has set up a virtual directory for whatever URL the user is
trying to access.. I wrote an interface to do a few different kinds of
virtual paths, one for URL's, one for Fuseactions, one to force a 404.  Also
if the 404 was thrown, it handles it a little more elegantly than normal 404
errors.  I'm constantly evolving this - it has a lot of power.  It's a lot
easier to give a client a URL like brainbox.tv/whatever than some long
fuseaction... and I no longer have to make folders and index.cfm's to show
some sample images for clients.  That combined with our content management
makes me almost never have to Remote Admin in to put some stuff up for
clients, which is one less monkey on my back and good service for them.

That's a lot more than you were asking, but

Here's how to set it up in IIS:
http://www.brainbox.tv/404.gif

HTH,
-Bill
brainbox

- Original Message -
From: "jim sullivan" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 04, 2001 12:37 PM
Subject: handling 404 errors with CF?


> Can CF handle 404 errors?
> that is, can CF catch a 404 (page not found) error and send back a custom
> error page?
> I tried using cferror for this and it doesn't seem to work..
>
>
>
~~
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

What's the best way to deal with inexplicable error messages?

[Hubert Earl]

Hi,

What's the best way to deal with inexplicable error messages?  Is it: 
a.  to slog away at the problem until the solution is found?
b.  to do something else, then come back after a while?
c.  to redo the code from scratch?

I'd appreciate words of wisdom from cooler, more experienced heads, since there *must* 
be a way to avoid the enormous frustration I often feel while coding! :-)

Hubert
---
Hubert Earl

ICQ#: 16199853
AIM: hubertfme

My Jamaican Art, Craft & More Online Store: 
http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html




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

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

Re: BANNER AD PROGRAM

[Jim McAtee]

I can understand the potential performance problems, but what kind of
concurrency issues do you have if you're storing all ad & campaign data in a
central database?

Jim

- Original Message -
From: "Jon Hall" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 04, 2001 3:45 PM
Subject: Re: BANNER AD PROGRAM


> One problem you are going to run into with ANY CF banner program is
> performance first off, secondly is concurrency issues once you move to
more
> than one server. If all you need is a counter, positions, and a random ad
> then you are safe with just about anything, however once you move to
> weighted ads concurrency becomes a huge problem.
> I has to rewrite an entire CF banner program as a stored procedure for
those
> exact reasons. It's smooth as butter now, serving up ~300,000+ weighted
> banners a day on a load balanced web site. Unfortunately it's not for
sale,
> but keep these issues in mind as you look for a banner program.
>
> 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: New ColdFusion "logo"

[Andrew Tyrone]

The hand with the lightning bolt...

Gone...

What to do now?  It'll cost me THOUSANDS upon THOUSANDS to get skin grafts to remove 
all the old ColdFusion logo tattoos on my body.

How could Macromedia do this?  Time to reevaluate the product, I suppose...

> -Original Message-
> From: Darren Adams [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 04, 2001 7:36 AM
> To: CF-Talk
> Subject: RE: New ColdFusion "logo"
> 
> 
> How can they get rid of the hand holding the lightning bolt.
> 
> That kind of says it all really.
> 
> Coldfusion gives you the ability to strike out your web projects at a fast
> rate but, at the same time it has alot of power.
> 
> Well, thats my interpretation.
> 
> -Original Message-
> From: Parker, Kevin [mailto:[EMAIL PROTECTED]]
> Sent: 04 May 2001 03:32
> To: CF-Talk
> Subject: RE: New ColdFusion "logo"
> 
> 
> I just got one of our Designers here to look at it. Here's what he said:
> 
> Unresolved.
> Seems like a first idea.
> Has no interaction with the text.
> For such a dynamic product, colour and layouts don't match.
> Lighting is just a cliché (on its own).
> Its a flash in the pan.
> I showed him the 4.5 box and he said  "Its (V5 logo) not progressive."
> 
> 
> 
> 
> 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: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 3 May 2001 8:49:AM
> To: CF-Talk
> Subject: New ColdFusion "logo"
> 
> 
> What do you think of the new "Macromedia ColdFusion 5" logo? >>
> http://www.allaire.com/products/coldfusion/
>
~~
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: BANNER AD PROGRAM

[Jon Hall]

One problem you are going to run into with ANY CF banner program is
performance first off, secondly is concurrency issues once you move to more
than one server. If all you need is a counter, positions, and a random ad
then you are safe with just about anything, however once you move to
weighted ads concurrency becomes a huge problem.
I has to rewrite an entire CF banner program as a stored procedure for those
exact reasons. It's smooth as butter now, serving up ~300,000+ weighted
banners a day on a load balanced web site. Unfortunately it's not for sale,
but keep these issues in mind as you look for a banner program.

jon
- Original Message -
From: "William J Wheatley" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 04, 2001 5:01 PM
Subject: BANNER AD PROGRAM


> ok i want a banner ad program that runs in CF
>
> what we have now is this
>
> www.centralad.com
>
> SELL ME =0) i would prefer the source and i would prefer it to be robust
=)
>
>
> Bill Wheatley
> Director of Development
> AEPS INC
> Allaire ColdFusion Consulting Partner
> Allaire Certified ColdFusion Developer
> http://www.aeps.com
> ICQ: 417645
> 954-472-6684 X303
>
> 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 unauthorized 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: Dynamic Variable Names

[Jose Alberto Guerra Ugalde]

I havent tried this but according to Michael Dinowitz it should be like
this:

Dynamic Variables

The Variable portion of a CFSET can be set dynamically by placing the text
portion within double quotes (") and surrounding the dynamic portion with
pound signs (#).
The Variable part of a CFSET does not need pound signs unless you're setting
a dynamic variable name, in which case it should be inside double quotes (")
as well.

Wrong: 
Right: 

When setting a dynamic Variable in a CFSET, remember to place the entire
Variable within double quotes (").

Wrong: 
Wrong: 
Right: 
Right: 

Regards.

- Original Message -
From: "Diana Nichols" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 04, 2001 12:07 PM
Subject: RE: Dynamic Variable Names


> Or, another solution is to reference #evaluate(qn)#, which will give you
the
> query result.
> D
> *
> Diana Nichols
> Webmistress
> http://www.lavenderthreads.com
> 770.434.7374
>
> "One man's magic is another man's engineering." ---Lazarus Long
>
> -Original Message-
> From: Joshua Meekhof [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 04, 2001 1:38 PM
> To: CF-Talk
> Subject: Re: Dynamic Variable Names
>
>
> assuming that once you have retrieved the record the value of qn is no
> significant, try alias the value in the query:
>  
> SELECT #qn# as foo
> FROM database
>  
>
>
>
> Jenny Anderson wrote:
> >
> > I want to dynamically create a variable name based upon a url variable.
> > First I set up a couple of strings:
> > 
> > 
> >
> > Where q is a number from 1-37 passed via url variable.  Let's say that
> > url.q is 7.  Then qn is 'q7'.
> > So I query the database like this:
> >
> > 
> >SELECT #qn#
> >FROM database
> > 
> >
> > And it correctly pulls all the results from the 'q7' column.  So far so
> good.
> > But now I want to be able to manipulate the query results and refer to
the
> > q7's from the database query.  If I refer to #qn# I only get q7 as the
> > result.  So how do I have it refer to the variable q7 and not the string
> q7?
> >
> > Thanks!
> >
> > Jenny
> >
> >
>
~~
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: Credit Card DB Encryption Methodology

[Tony Schreiber]

> > 1) The User's password is stored as a one-way HASH.
> > 2) The Credit Card info (list of cc number,exp date and
> > verification number) is stored as an ENCRYPTED string with the
> > User's raw password as the key.
> 
> That's fine as long as the only reason you're storing the 
> credit card number is to prevent having to ask the customer for 
> it again the next order.  But if that was the only reason for 
> keeping the number, it seems hardly worth storing it in the 
> first place -- just forget it as soon as you've charged the 
> card.

That's correct. Part of the goal for this project is to have customers
ordering via WAP and we need to make that as easy as possible.
 
> I thought the reason most people kept card numbers around was 
> for handling credits, delayed charges, and other problems (or 
> possibly because of record-keeping requirements of their bank), 
> or because they're doing the credit card charges manually (or 
> at least with some human intervention) rather than in real 
> time.  It doesn't seem like your solution would work in that 
> situation.

Correct, that wouldn't work here, because we don't have an unecrypted
version of the user's password available.

> Keith C. Ivey <[EMAIL PROTECTED]>
> Webmaster, EEI Communications



Tony Schreiber, Senior Partner  Man and Machine, Limited
mailto:[EMAIL PROTECTED]   http://www.technocraft.com

http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion
http://www.is300.net ___The Enthusiast's Home of the Lexus IS300
http://www.digitacamera.com __DigitA Camera Scripts and Tips
http://www.linklabexchange.com _Miata Link ECU Data Exchange


~~
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: Online Docs

[Hoffman, Joe (CIT)]

http://www.houseoffusion.com/cfdocs1/dochome.htm

"In ColdFusion 4.0.1, the Advanced ColdFusion Development manual has been
merged into the Developing Web Applications with ColdFusion manual. In
addition, a new online manual has been added to the ColdFusion 4.0.1
documentation, Using ColdFusion Studio. This latter manual is available
online only as HTML and in Acrobat format."

Joe Hoffman mailto:[EMAIL PROTECTED]
National Institutes of Health 
Center for Information Technology 
Division of Computer System Services

-Original Message-
From: Steve Pierce [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 04, 2001 4:51 PM
To: CF-Talk
Subject: Online Docs


Does anyone have a link to online docs for CF 4.x? Use to be that Allaire
had the docs online.

Thanks in advance,

 - Steve

Steve Pierce, HDL
"Co-Location starting $99 per month, no setup fee"
(734) 482-9682 | mailto:[EMAIL PROTECTED] | http://HDL.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: BANNER AD PROGRAM

[Angél Stewart]

Check www.fuseads.com 

You don't need anything else.

-Gel


~~
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: Credit Card DB Encryption Methodology

[Keith C. Ivey]

On 3 May 2001, at 15:52, Tony Schreiber wrote:

> 1) The User's password is stored as a one-way HASH.
> 2) The Credit Card info (list of cc number,exp date and
> verification number) is stored as an ENCRYPTED string with the
> User's raw password as the key.

That's fine as long as the only reason you're storing the 
credit card number is to prevent having to ask the customer for 
it again the next order.  But if that was the only reason for 
keeping the number, it seems hardly worth storing it in the 
first place -- just forget it as soon as you've charged the 
card.

I thought the reason most people kept card numbers around was 
for handling credits, delayed charges, and other problems (or 
possibly because of record-keeping requirements of their bank), 
or because they're doing the credit card charges manually (or 
at least with some human intervention) rather than in real 
time.  It doesn't seem like your solution would work in that 
situation.

Keith C. Ivey <[EMAIL PROTECTED]>
Webmaster, EEI Communications
66 Canal Center Plaza, Suite 200
Alexandria, VA  22314
Telephone:  703-683-0683
Fax:  703-683-4915
Web Site:  http://www.eeicommunications.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: BANNER AD PROGRAM

[Dick Applebaum]

Have a look at DreamBanner in the tag Gallery

HTH Dick

At 5:01 PM -0400 5/4/01, William J Wheatley wrote:
>ok i want a banner ad program that runs in CF
>
>what we have now is this
>
>www.centralad.com
>
>SELL ME =0) i would prefer the source and i would prefer it to be robust =)
>

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

Client Variable Issues!

[Brook Davies]

1. Does SQL7 go into single user mode while executing transaction log backups?
And is it necessary to back up the client Var Repository? We do not user
the global hit count client vars and I can not think of any other situation
where we would need to retrieve clients var data.

It also appears that the Hitcount and Last Visit variables are being 
written to the client variable database even though we have the disable 
check box checked in the administrator.




2. I have a really strange report from a client about some irregularities in
an app we built for them. Essentially, there is a long client variable that
contains a delimited string of items. This long delimited list is used
throughout the app. This string is later stored in the DB.
Each record in the DB has its own identifiably string of delimited items.
When a user accesses a particular item, the DB record is read and that
delimited list is set as the client Var. The previous client vars are all
deleted.
Now, when my user views the entire string it looks normal. But if she
attempts to edit an item in the list, all of its properties change to an
item in another list from a separate record in the DB. Its seems as through
the previous client Var is still hanging around and sometimes being
selected from the clientVar repository instead of what should be the
currently active client Var.
Has any one seen anything like this happen before?



3. When I view the ClientVariable Database, there are numerous entries 
where the data is only a single variable. Each user session should always 
have between 10-20 client variables initialized when they log in yet there 
are numerous entries which contain just this orphaned variable. Why would 
this Variable be written to the client Var repository as a single record 
where as other records contain the entire string of client variables as 
expected.

Thank you for your help.

Brook Davies
MaracasMedia Inc.











  MARACASMEDIA INC.

  Brook Davies
  President


 

Address Info
 

421 - 425 Carrall Street
Vancouver, BC
V6B 6E3 CA 








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

BANNER AD PROGRAM

[William J Wheatley]

ok i want a banner ad program that runs in CF

what we have now is this

www.centralad.com

SELL ME =0) i would prefer the source and i would prefer it to be robust =)


Bill Wheatley
Director of Development
AEPS INC
Allaire ColdFusion Consulting Partner
Allaire Certified ColdFusion Developer
http://www.aeps.com
ICQ: 417645
954-472-6684 X303

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

Online Docs

[Steve Pierce]

Does anyone have a link to online docs for CF 4.x? Use to be that Allaire
had the docs online.

Thanks in advance,

 - Steve

Steve Pierce, HDL
"Co-Location starting $99 per month, no setup fee"
(734) 482-9682 | mailto:[EMAIL PROTECTED] | http://HDL.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: cfloop help! -- solved!!

[Diana Nichols]

It's no elegant, and I'm sure there's a better way, but I finally go what I
wanted by setting another variable:


#userID# (#thisuser#,#getm.userID#)


Thanks everyone for your help!
D
*
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374

"One man's magic is another man's engineering." ---Lazarus Long

-Original Message-
From: Diana Nichols [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 04, 2001 4:08 PM
To: CF-Talk
Subject: RE: cfloop help!


That did the trick...the output straitened up...but now I'm back to where I
started, which was adding a  qualifier


#getusers.userID# (#userID#,#getm.userID#)


and its still outputting all:

1 (1,1)(4,4)(19,19)(22,22)(23,23)

4 (1,1)(4,4)(19,19)(22,22)(23,23)

19 (1,1)(4,4)(19,19)(22,22)(23,23)

22 (1,1)(4,4)(19,19)(22,22)(23,23)

23 (1,1)(4,4)(19,19)(22,22)(23,23)

I also tried selecting getusers.userID as "thisuser", but when it gets to
the  it throws an Error Resolving Parameter on THISUSER.

yikes.

D

-Original Message-
From: Todd Ashworth [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 04, 2001 3:56 PM
To: CF-Talk
Subject: Re: cfloop help!


get rid of "getusers" in getusers.userID


#getusers.userID# (#userID#,#getm.userID#)



Todd

- Original Message -
From: "Diana Nichols" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 04, 2001 3:34 PM
Subject: cfloop help!


| I must be blind today - I've used cfloops like this many timesbut the
| output is wrong#@!$@#!^%$
|
| I've reduced the code to see what was happening, and the value of the
userID
| the getusers query is not updating with each iteration of the outputin
| other words, this code:
|
| 
| select userID
| from users
| where companyID = 1
| 
| 
| select userID
| from billing
| where companyID = 1
| 
| 
|
| 
| #getusers.userID# (#getusers.userID#,#getm.userID#)
| 
| 
|
| produces this output:
|
| 1 (1,1) (1,4) (1,19) (1,22) (1,23)
|
| 4 (1,1) (1,4) (1,19) (1,22) (1,23)
|
| 19 (1,1) (1,4) (1,19) (1,22) (1,23)
|
| 22 (1,1) (1,4) (1,19) (1,22) (1,23)
|
| 23 (1,1) (1,4) (1,19) (1,22) (1,23)
|
| I don't have a clue what I've done wronghelp, please!
|
| TIA!
| D
|
| *
| Diana Nichols
| Webmistress
| http://www.lavenderthreads.com
| 770.434.7374
|
| "One man's magic is another man's engineering." ---Lazarus Long
|
|
|
~~
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: Credit Card DB Encryption Methodology

[Tony Schreiber]

I'm writing a CF_ManageCC tag as part of my development, so whenever I
need to do anything with a card, I just call the tag. I'll post it to the
gallery when I'm done.

> Yes, I agree your method is much more secure, just harder to snippetize ;-)
> 
> jon
> - Original Message -
> From: "Tony Schreiber" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, May 04, 2001 4:25 PM
> Subject: Re: Credit Card DB Encryption Methodology
> 
> 
> > That's what I'm doing, but the problem with that is that you have to store
> > the key, unencrypted, somewhere on the server. And one key decrypts your
> > whole slew of credit cards.
> >
> > This way, there's one key for each credit card and it's not store
> > unencrypted on the server...
> >
> > > I just use encrypt/base64 to encrypt cards as sop. Here is my snippet,
> the
> > > key I choose randomly for each site.
> > >
> > >  > > ToBase64(encrypt("#string2beEncrypted#","#key#"))>
> > >  > > decrypt(tostring(tobinary("#secret_word_encrypted#")),"#key#")>
> > >
> > > jon
> > > - Original Message -
> > > From: "Tony Schreiber" <[EMAIL PROTECTED]>
> > > To: "CF-Talk" <[EMAIL PROTECTED]>
> > > Sent: Friday, May 04, 2001 11:43 AM
> > > Subject: Re: Credit Card DB Encryption Methodology
> > >
> > >
> > > > Yes, but that's a physical architecture issue. I'm just trying to
> address
> > > > the software side. I'm surprised there haven't been more comments on
> this,
> > > > seems to have been a pretty hot topic.
> > > >
> > > > Also, I've realized no site I've been to seems to store cc info this
> way
> > > > (because I'm not prompted for my password) so I wonder what other
> schemes
> > > > they are using
> > > >
> > > > > Sounds very secure, of course you might add that the database in
> > > question
> > > > > should never be on a web server. The  database should only be
> accessible
> > > > > from behind a firewall which permits only the web server's ip to
> access
> > > the
> > > > > database server.
> > > > >
> > > > > jon
> > > > > - Original Message -
> > > > > From: "Tony Schreiber" <[EMAIL PROTECTED]>
> > > > > To: "CF-Talk" <[EMAIL PROTECTED]>
> > > > > Sent: Thursday, May 03, 2001 3:52 PM
> > > > > Subject: Credit Card DB Encryption Methodology
> > > > >
> > > > >
> > > > > > Ok, I've been reading the last few threads on this and pondering
> the
> > > best
> > > > > > way to approach this scenario (storing CC in DB) and I've come up
> with
> > > the
> > > > > > following idea:
> > > > > >
> > > > > > 1) The User's password is stored as a one-way HASH.
> > > > > > 2) The Credit Card info (list of cc number,exp date and
> verification
> > > > > > number) is stored as an ENCRYPTED string with the User's raw
> password
> > > as
> > > > > > the key.
> > > > > >
> > > > > > Interface-wise, this requires that:
> > > > > >
> > > > > > a) the user type in their password when Adding or Updating a
> credit
> > > card
> > > > > > record in the db (so it can be encrypted)
> > > > > > b) the user type in their password when finalizing an order (so
> the cc
> > > > > > info can be decrypted to be processed)
> > > > > > c) When a user changes their password, all cc records in the
> database
> > > must
> > > > > > be updated using the old and new passwords
> > > > > >
> > > > > > But this way, neither the users password, the encryption key nor
> the
> > > cc
> > > > > > info is stored unencrypted anywhere on the server.
> > > > > >
> > > > > > Comments?
> > > > > >
> > > > > >
> > > > > > Tony Schreiber, Senior Partner  Man and Machine,
> > > Limited
> > > > > > mailto:[EMAIL PROTECTED]
> > > http://www.technocraft.com
> > > > > >
> > > > > > http://www.simplemessageboard.com ___Free Forum Software for Cold
> > > Fusion
> > > > > > http://www.is300.net ___The Enthusiast's Home of the Lexus
> > > IS300
> > > > > > http://www.digitacamera.com __DigitA Camera Scripts
> and
> > > Tips
> > > > > > http://www.linklabexchange.com _Miata Link ECU Data
> > > Exchange
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
~~
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: Credit Card DB Encryption Methodology

[Jon Hall]

Yes, I agree your method is much more secure, just harder to snippetize ;-)

jon
- Original Message -
From: "Tony Schreiber" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 04, 2001 4:25 PM
Subject: Re: Credit Card DB Encryption Methodology


> That's what I'm doing, but the problem with that is that you have to store
> the key, unencrypted, somewhere on the server. And one key decrypts your
> whole slew of credit cards.
>
> This way, there's one key for each credit card and it's not store
> unencrypted on the server...
>
> > I just use encrypt/base64 to encrypt cards as sop. Here is my snippet,
the
> > key I choose randomly for each site.
> >
> >  > ToBase64(encrypt("#string2beEncrypted#","#key#"))>
> >  > decrypt(tostring(tobinary("#secret_word_encrypted#")),"#key#")>
> >
> > jon
> > - Original Message -
> > From: "Tony Schreiber" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Friday, May 04, 2001 11:43 AM
> > Subject: Re: Credit Card DB Encryption Methodology
> >
> >
> > > Yes, but that's a physical architecture issue. I'm just trying to
address
> > > the software side. I'm surprised there haven't been more comments on
this,
> > > seems to have been a pretty hot topic.
> > >
> > > Also, I've realized no site I've been to seems to store cc info this
way
> > > (because I'm not prompted for my password) so I wonder what other
schemes
> > > they are using
> > >
> > > > Sounds very secure, of course you might add that the database in
> > question
> > > > should never be on a web server. The  database should only be
accessible
> > > > from behind a firewall which permits only the web server's ip to
access
> > the
> > > > database server.
> > > >
> > > > jon
> > > > - Original Message -
> > > > From: "Tony Schreiber" <[EMAIL PROTECTED]>
> > > > To: "CF-Talk" <[EMAIL PROTECTED]>
> > > > Sent: Thursday, May 03, 2001 3:52 PM
> > > > Subject: Credit Card DB Encryption Methodology
> > > >
> > > >
> > > > > Ok, I've been reading the last few threads on this and pondering
the
> > best
> > > > > way to approach this scenario (storing CC in DB) and I've come up
with
> > the
> > > > > following idea:
> > > > >
> > > > > 1) The User's password is stored as a one-way HASH.
> > > > > 2) The Credit Card info (list of cc number,exp date and
verification
> > > > > number) is stored as an ENCRYPTED string with the User's raw
password
> > as
> > > > > the key.
> > > > >
> > > > > Interface-wise, this requires that:
> > > > >
> > > > > a) the user type in their password when Adding or Updating a
credit
> > card
> > > > > record in the db (so it can be encrypted)
> > > > > b) the user type in their password when finalizing an order (so
the cc
> > > > > info can be decrypted to be processed)
> > > > > c) When a user changes their password, all cc records in the
database
> > must
> > > > > be updated using the old and new passwords
> > > > >
> > > > > But this way, neither the users password, the encryption key nor
the
> > cc
> > > > > info is stored unencrypted anywhere on the server.
> > > > >
> > > > > Comments?
> > > > >
> > > > >
> > > > > Tony Schreiber, Senior Partner  Man and Machine,
> > Limited
> > > > > mailto:[EMAIL PROTECTED]
> > http://www.technocraft.com
> > > > >
> > > > > http://www.simplemessageboard.com ___Free Forum Software for Cold
> > Fusion
> > > > > http://www.is300.net ___The Enthusiast's Home of the Lexus
> > IS300
> > > > > http://www.digitacamera.com __DigitA Camera Scripts
and
> > Tips
> > > > > http://www.linklabexchange.com _Miata Link ECU Data
> > Exchange
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > >
> >
>
~~
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: Credit Card DB Encryption Methodology

[Tony Schreiber]

That's what I'm doing, but the problem with that is that you have to store
the key, unencrypted, somewhere on the server. And one key decrypts your
whole slew of credit cards.

This way, there's one key for each credit card and it's not store
unencrypted on the server...

> I just use encrypt/base64 to encrypt cards as sop. Here is my snippet, the
> key I choose randomly for each site.
> 
>  ToBase64(encrypt("#string2beEncrypted#","#key#"))>
>  decrypt(tostring(tobinary("#secret_word_encrypted#")),"#key#")>
> 
> jon
> - Original Message -
> From: "Tony Schreiber" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, May 04, 2001 11:43 AM
> Subject: Re: Credit Card DB Encryption Methodology
> 
> 
> > Yes, but that's a physical architecture issue. I'm just trying to address
> > the software side. I'm surprised there haven't been more comments on this,
> > seems to have been a pretty hot topic.
> >
> > Also, I've realized no site I've been to seems to store cc info this way
> > (because I'm not prompted for my password) so I wonder what other schemes
> > they are using
> >
> > > Sounds very secure, of course you might add that the database in
> question
> > > should never be on a web server. The  database should only be accessible
> > > from behind a firewall which permits only the web server's ip to access
> the
> > > database server.
> > >
> > > jon
> > > - Original Message -
> > > From: "Tony Schreiber" <[EMAIL PROTECTED]>
> > > To: "CF-Talk" <[EMAIL PROTECTED]>
> > > Sent: Thursday, May 03, 2001 3:52 PM
> > > Subject: Credit Card DB Encryption Methodology
> > >
> > >
> > > > Ok, I've been reading the last few threads on this and pondering the
> best
> > > > way to approach this scenario (storing CC in DB) and I've come up with
> the
> > > > following idea:
> > > >
> > > > 1) The User's password is stored as a one-way HASH.
> > > > 2) The Credit Card info (list of cc number,exp date and verification
> > > > number) is stored as an ENCRYPTED string with the User's raw password
> as
> > > > the key.
> > > >
> > > > Interface-wise, this requires that:
> > > >
> > > > a) the user type in their password when Adding or Updating a credit
> card
> > > > record in the db (so it can be encrypted)
> > > > b) the user type in their password when finalizing an order (so the cc
> > > > info can be decrypted to be processed)
> > > > c) When a user changes their password, all cc records in the database
> must
> > > > be updated using the old and new passwords
> > > >
> > > > But this way, neither the users password, the encryption key nor the
> cc
> > > > info is stored unencrypted anywhere on the server.
> > > >
> > > > Comments?
> > > >
> > > >
> > > > Tony Schreiber, Senior Partner  Man and Machine,
> Limited
> > > > mailto:[EMAIL PROTECTED]
> http://www.technocraft.com
> > > >
> > > > http://www.simplemessageboard.com ___Free Forum Software for Cold
> Fusion
> > > > http://www.is300.net ___The Enthusiast's Home of the Lexus
> IS300
> > > > http://www.digitacamera.com __DigitA Camera Scripts and
> Tips
> > > > http://www.linklabexchange.com _Miata Link ECU Data
> Exchange
> > > >
> > > >
> > > >
> > > >
> > >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Access ldb files w/a twist

[Zachary S. Bedell]

> I did not noticed any performance problem in testing I did a 
> while back,
> besides, using Access is a performance hit in and of itself. 
> Access cant
> have too many simultaneous users without serious performance 
> problems of
> it's own.

Point taken...  I've gotten spoiled with my SQL Server.  I'd forgotten
just how limitted Access can be

Thanks for the reality check! ;-)

Best regards,
Zac Bedell


~~
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: cfloop help!

[Diana Nichols]

originally, I was trying to print out info only if the two userID's
matchsee the response I posted a few minutes ago.

(and thanks for your response!)
D

-Original Message-
From: Clint Tredway [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 04, 2001 3:58 PM
To: CF-Talk
Subject: Re: cfloop help!


The results that you are getting is correct to the code you showed us. Can
you tell us what you are 'trying' to get and maybe we can help.

Thanks,

Clint

-- Original Message --
From: "Diana Nichols" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Fri, 04 May 2001 15:34:14 -0400

I must be blind today - I've used cfloops like this many timesbut the
output is wrong#@!$@#!^%$

I've reduced the code to see what was happening, and the value of the userID
the getusers query is not updating with each iteration of the outputin
other words, this code:


select userID
from users
where companyID = 1


select userID
from billing
where companyID = 1




#getusers.userID# (#getusers.userID#,#getm.userID#)



produces this output:

1 (1,1) (1,4) (1,19) (1,22) (1,23)

4 (1,1) (1,4) (1,19) (1,22) (1,23)

19 (1,1) (1,4) (1,19) (1,22) (1,23)

22 (1,1) (1,4) (1,19) (1,22) (1,23)

23 (1,1) (1,4) (1,19) (1,22) (1,23)

I don't have a clue what I've done wronghelp, please!

TIA!
D

*
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374

"One man's magic is another man's engineering." ---Lazarus Long
~~
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: cfloop help!

[Diana Nichols]

That did the trick...the output straitened up...but now I'm back to where I
started, which was adding a  qualifier


#getusers.userID# (#userID#,#getm.userID#)


and its still outputting all:

1 (1,1)(4,4)(19,19)(22,22)(23,23)

4 (1,1)(4,4)(19,19)(22,22)(23,23)

19 (1,1)(4,4)(19,19)(22,22)(23,23)

22 (1,1)(4,4)(19,19)(22,22)(23,23)

23 (1,1)(4,4)(19,19)(22,22)(23,23)

I also tried selecting getusers.userID as "thisuser", but when it gets to
the  it throws an Error Resolving Parameter on THISUSER.

yikes.

D

-Original Message-
From: Todd Ashworth [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 04, 2001 3:56 PM
To: CF-Talk
Subject: Re: cfloop help!


get rid of "getusers" in getusers.userID


#getusers.userID# (#userID#,#getm.userID#)



Todd

- Original Message -
From: "Diana Nichols" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 04, 2001 3:34 PM
Subject: cfloop help!


| I must be blind today - I've used cfloops like this many timesbut the
| output is wrong#@!$@#!^%$
|
| I've reduced the code to see what was happening, and the value of the
userID
| the getusers query is not updating with each iteration of the outputin
| other words, this code:
|
| 
| select userID
| from users
| where companyID = 1
| 
| 
| select userID
| from billing
| where companyID = 1
| 
| 
|
| 
| #getusers.userID# (#getusers.userID#,#getm.userID#)
| 
| 
|
| produces this output:
|
| 1 (1,1) (1,4) (1,19) (1,22) (1,23)
|
| 4 (1,1) (1,4) (1,19) (1,22) (1,23)
|
| 19 (1,1) (1,4) (1,19) (1,22) (1,23)
|
| 22 (1,1) (1,4) (1,19) (1,22) (1,23)
|
| 23 (1,1) (1,4) (1,19) (1,22) (1,23)
|
| I don't have a clue what I've done wronghelp, please!
|
| TIA!
| D
|
| *
| Diana Nichols
| Webmistress
| http://www.lavenderthreads.com
| 770.434.7374
|
| "One man's magic is another man's engineering." ---Lazarus Long
|
|
|
~~
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: cfloop help!

[Clint Tredway]

The results that you are getting is correct to the code you showed us. Can you tell us 
what you are 'trying' to get and maybe we can help.

Thanks,

Clint

-- Original Message --
From: "Diana Nichols" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Fri, 04 May 2001 15:34:14 -0400

I must be blind today - I've used cfloops like this many timesbut the
output is wrong#@!$@#!^%$

I've reduced the code to see what was happening, and the value of the userID
the getusers query is not updating with each iteration of the outputin
other words, this code:


select userID
from users
where companyID = 1


select userID
from billing
where companyID = 1




#getusers.userID# (#getusers.userID#,#getm.userID#)



produces this output:

1 (1,1) (1,4) (1,19) (1,22) (1,23)

4 (1,1) (1,4) (1,19) (1,22) (1,23)

19 (1,1) (1,4) (1,19) (1,22) (1,23)

22 (1,1) (1,4) (1,19) (1,22) (1,23)

23 (1,1) (1,4) (1,19) (1,22) (1,23)

I don't have a clue what I've done wronghelp, please!

TIA!
D

*
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374

"One man's magic is another man's engineering." ---Lazarus Long
~~
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: [cold_fusion] Unusual Results, help

[Terry Bader]

>:huh?:   Why would you expect an outer loop control variable to 
> increment in the inner loop?  It doesn't seem to make any sense to me.

well, since LOOPING refers to the ability to go through each recordset and
use its data in the code with in the beginning and ending of the loop
controls, you would assume that the current pointer of the outside loop
would be available to the inner loop...

thus on a sequential numbering ID, on the 2nd iteration when qry_test.ID = 2
that the inner LOOP would see that the pointer was pointed to the 2nd row
and thusly qry_test.ID should return 2 and not 1.


maybe my logic of looping is terrible and my years of programming logic
education was wasted

>   But you can easily change that to:  queryname[10].myfield 
> to return the 
> 10th row, if you wish.

maybe, but the  with the QUERY option should be removed and just
use the TO FROM INDEX options with qry.recordset...  why have the QUERY if
it is buggy and Yes, I plan to use the TO FROM INDEX with
queryname[index].myfield from now on...



Thanks...


Terry Bader
IT/Web Specialist
Macromedia Certified Coldfusion Developer
EDO Corp - Combat Systems
(757) 424-1004 ext 361 - Work
[EMAIL PROTECTED]   


(757)581-5981 - Mobile
[EMAIL PROTECTED]
icq: 5202487   aim: lv2bounce
http://www.cs.odu.edu/~bader





> -Original Message-
> From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 04, 2001 10:44 AM
> To: CF-Talk
> Subject: RE: [cold_fusion] Unusual Results, help
> 
> 
> At 11:31 AM 05/04/2001 +0100, you wrote:
> > > This has always been the behavior of CF.  I can agree 
> that it at first
> > > glances appears to be counter intuitive, but at the same
> > > time, any reference
> > > to queryname.fieldname outside the context of a  
> or 
> > > results in a reference to the value of the field in the first
> > > row of the
> > > query.  The functionality is such that there is no 
> "inheritance" of
> > > references.
> >
> >Well, I think you're at risk of sounding like an apologist 
> for Allaire.
> >
> >There are a couple of things that I feel need "fixing" in 
> ColdFusion, and
> >this is one of them (the other one that springs to mind is 
> the inability to
> >optionally specify that empty list elements aren't ignored - 
> really useful
> >if you are populating database tables from delimited lists).
> >
> >
> >
> >*Crappy CFSET GetParents.ParentID code required here*
> >
> >
> >
> >   #GetParents.ParentID# doesn't increment properly with each
> >   iteration of the outer loop WHY NOT ALLAIRE?!?!
> >
> >
> >
> 
>:huh?:   Why would you expect an outer loop control variable to 
> increment in the inner loop?  It doesn't seem to make any sense to me.
> 
>I haven't been following this thread, but I will point out 
> that a query 
> object is an array of structures.
> 
>   queryname.myfield will return the first row, true.
> 
>   But you can easily change that to:  queryname[10].myfield 
> to return the 
> 10th row, if you wish.
> 
> 
> 
> Jeffry Houser | mailto:[EMAIL PROTECTED]
> AIM: Reboog711  | ICQ: 5246969 | Phone: 860-229-2781
> --
> Instant ColdFusion 5.0  | ISBN: 0-07-213238-8
> Due out June 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
> 
> 
>
~~
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: cfloop help!

[Semrau, Steven L Mr SRA]

Change



To





Steven Semrau
SRA International, Inc.
Senior Member, Professional Staff
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Com:  (703) 805-1095
DSN:  (703) 655-1095


-Original Message-
From: Diana Nichols [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 04, 2001 3:34 PM
To: CF-Talk
Subject: cfloop help!


I must be blind today - I've used cfloops like this many timesbut the
output is wrong#@!$@#!^%$

I've reduced the code to see what was happening, and the value of the userID
the getusers query is not updating with each iteration of the outputin
other words, this code:


select userID
from users
where companyID = 1


select userID
from billing
where companyID = 1




#getusers.userID# (#getusers.userID#,#getm.userID#)



produces this output:

1 (1,1) (1,4) (1,19) (1,22) (1,23)

4 (1,1) (1,4) (1,19) (1,22) (1,23)

19 (1,1) (1,4) (1,19) (1,22) (1,23)

22 (1,1) (1,4) (1,19) (1,22) (1,23)

23 (1,1) (1,4) (1,19) (1,22) (1,23)

I don't have a clue what I've done wronghelp, please!

TIA!
D

*
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374

"One man's magic is another man's engineering." ---Lazarus Long
~~
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: cfloop help!

[Todd Ashworth]

get rid of "getusers" in getusers.userID


#getusers.userID# (#userID#,#getm.userID#)



Todd

- Original Message -
From: "Diana Nichols" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 04, 2001 3:34 PM
Subject: cfloop help!


| I must be blind today - I've used cfloops like this many timesbut the
| output is wrong#@!$@#!^%$
|
| I've reduced the code to see what was happening, and the value of the
userID
| the getusers query is not updating with each iteration of the outputin
| other words, this code:
|
| 
| select userID
| from users
| where companyID = 1
| 
| 
| select userID
| from billing
| where companyID = 1
| 
| 
|
| 
| #getusers.userID# (#getusers.userID#,#getm.userID#)
| 
| 
|
| produces this output:
|
| 1 (1,1) (1,4) (1,19) (1,22) (1,23)
|
| 4 (1,1) (1,4) (1,19) (1,22) (1,23)
|
| 19 (1,1) (1,4) (1,19) (1,22) (1,23)
|
| 22 (1,1) (1,4) (1,19) (1,22) (1,23)
|
| 23 (1,1) (1,4) (1,19) (1,22) (1,23)
|
| I don't have a clue what I've done wronghelp, please!
|
| TIA!
| D
|
| *
| Diana Nichols
| Webmistress
| http://www.lavenderthreads.com
| 770.434.7374
|
| "One man's magic is another man's engineering." ---Lazarus Long
|
|
|
~~
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

cfloop help!

[Diana Nichols]

I must be blind today - I've used cfloops like this many timesbut the
output is wrong#@!$@#!^%$

I've reduced the code to see what was happening, and the value of the userID
the getusers query is not updating with each iteration of the outputin
other words, this code:


select userID
from users
where companyID = 1


select userID
from billing
where companyID = 1




#getusers.userID# (#getusers.userID#,#getm.userID#)



produces this output:

1 (1,1) (1,4) (1,19) (1,22) (1,23)

4 (1,1) (1,4) (1,19) (1,22) (1,23)

19 (1,1) (1,4) (1,19) (1,22) (1,23)

22 (1,1) (1,4) (1,19) (1,22) (1,23)

23 (1,1) (1,4) (1,19) (1,22) (1,23)

I don't have a clue what I've done wronghelp, please!

TIA!
D

*
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374

"One man's magic is another man's engineering." ---Lazarus Long


~~
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: [Object Oriented CFML]

[Alex]

I like easy things easy. Right tool for the right job. You want OO I suggest
java or python.

"Craig Bowes" <[EMAIL PROTECTED]> wrote:
Ok, here is a little poll for you guys.

How many of you are using SmartObjects and how many of you are using
CFObjects?  I know there’s a ton of Fusebox people but I’m looking for the
people using object oriented CFML.

Tell me what you are using, if you like it, and for how long.

Thanks!

-Craig

http://www.smart-objects.com/

http://www.cfobjects.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: Object Oriented CFML

[Bryan LaPlante]

That's awesome man, I want to take some time and read about it. Do you have
a design interface beyond the availability of the vtm editors? don't forget
I have a free tool for creating vtm's on line at
http://www.netwebapps.com/mytags/main.cfm

Bryan LaPlante

- Original Message -
From: "Craig Bowes" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 04, 2001 2:30 PM
Subject: Object Oriented CFML


> Ok, here is a little poll for you guys.
>
> How many of you are using SmartObjects and how many of you are using
> CFObjects?  I know there's a ton of Fusebox people but I'm looking for the
> people using object oriented CFML.
>
> Tell me what you are using, if you like it, and for how long.
>
> Thanks!
>
> -Craig
>
> http://www.smart-objects.com/
>
> http://www.cfobjects.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: Combining two fields In Access SQL.

[jethro1973]

Assuming you want a , between them:

Select LastName & ", " & FirstName as FullName FROM 

Chris Nebinger
- Original Message -
From: "Angél Stewart" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 03, 2001 1:49 PM
Subject: Combining two fields In Access SQL.


> HI!
>
> I want to select Lastname Firstname AS Name in an Access SQL query.
>
> Select fname||lname AS name From Users,Vehicles
> Where name = #searchname#
>
> Doesn't work..
> I get an error saying Invalid use of Pipe.
> :-\
> *sigh*
>
> Any ideas on how to do this in Access?
>
> -Gel
>
>
>
~~
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: Delimited text file to database

[Matthew Fusfield]

Christine,
There are a number of ways to do this. With ColdFusion, you might read in
the file in with CFFILE and then use the List functions in CFML to parse out
each row and field.

If it is a one-time import, you might want to look into using Microsoft
Access or Excel to reformat your data and then import into your main
database.

Matt



-Original Message-
From: Christine Kelley [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 04, 2001 3:09 PM
To: CF-Talk
Subject: Delimited text file to database



Hi all!
 Never done this one before...
 A client would like to send me delimited text files of 
info for insertion into a database table.  Sort of like the 
Monster.com, http://doc.monster.com/ftpjobs.html.  I'm not 
sure where to start.  Is it  or  to turn the 
file into a query?
 My brain feels a little scrambled :)
   Christine
~~
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: Delimited text file to database

[Russ Conway]

Does the insert need to be done in Cold Fusion? What about BCP (for SQL
Server) or SQL Loader (for Oracle)? We usually load the data into "stage"
tables using the load utility from the database and then run stored
procedures to clean the data and insert it into the production database. You
could alternately use CF code to clean and insert the data to the production
database.

You can run the command line scripts from CF if you want...



The .bat file looks like this...
e:
cd e:\inetpub\wwwroot\administration\productbulkload\files
sqlplus username/password @truncatestage.sql
sqlldr userid=username/password control=uploadathlete.ctl skip=1
log=uploadathlete.log
sqlldr userid=username/password control=uploadbullet.ctl skip=1
log=uploadbullet.log
sqlldr userid=username/password control=uploadcategory.ctl skip=1
log=uploadcategory.log
sqlldr userid=username/password control=uploadpicture.ctl skip=1
log=uploadpicture.log
sqlldr userid=username/password control=uploadproduct.ctl skip=1
log=uploadproduct.log
sqlldr userid=username/password control=uploadteam.ctl skip=1
log=uploadteam.log
exit

Russell Conway
HallofSports.com, Inc.
351 West 22nd Street
New York, NY 10011
P (646) 638-2500
F (561) 423-2674
http://www.hallofsports.com
.. . . where the legends live on

> -Original Message-
> From: Christine Kelley [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 04, 2001 3:09 PM
> To: CF-Talk
> Subject: Delimited text file to database
>
>
>
> Hi all!
>  Never done this one before...
>  A client would like to send me delimited text files of
> info for insertion into a database table.  Sort of like the
> Monster.com, http://doc.monster.com/ftpjobs.html.  I'm not
> sure where to start.  Is it  or  to turn the
> file into a query?
>  My brain feels a little scrambled :)
>Christine
>
>
>
~~
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

Object Oriented CFML

[Craig Bowes]

Ok, here is a little poll for you guys.

How many of you are using SmartObjects and how many of you are using
CFObjects?  I know there’s a ton of Fusebox people but I’m looking for the
people using object oriented CFML.

Tell me what you are using, if you like it, and for how long.

Thanks!

-Craig

http://www.smart-objects.com/

http://www.cfobjects.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: Dynamic Variable Names

[Diana Nichols]

Or, another solution is to reference #evaluate(qn)#, which will give you the
query result.
D
*
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374

"One man's magic is another man's engineering." ---Lazarus Long

-Original Message-
From: Joshua Meekhof [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 04, 2001 1:38 PM
To: CF-Talk
Subject: Re: Dynamic Variable Names


assuming that once you have retrieved the record the value of qn is no
significant, try alias the value in the query:
 
SELECT #qn# as foo
FROM database
 



Jenny Anderson wrote:
>
> I want to dynamically create a variable name based upon a url variable.
> First I set up a couple of strings:
> 
> 
>
> Where q is a number from 1-37 passed via url variable.  Let's say that
> url.q is 7.  Then qn is 'q7'.
> So I query the database like this:
>
> 
>SELECT #qn#
>FROM database
> 
>
> And it correctly pulls all the results from the 'q7' column.  So far so
good.
> But now I want to be able to manipulate the query results and refer to the
> q7's from the database query.  If I refer to #qn# I only get q7 as the
> result.  So how do I have it refer to the variable q7 and not the string
q7?
>
> Thanks!
>
> Jenny
>
>
~~
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-Certification

[Todd Ashworth]

Yeah .. don't fail ;)

Actually, on tip is, don't rush!  There is plenty of time to finish the
test.  When I took mine, I felt really pressured and rushed through it.  I
didn't need to .. I finished with 25 minutes to spare.  Also, make sure you
read the instructions for each question.  Sometimes there are multiple
correct answers, so make sure you are aware of how many things you are
supposed to select.

Todd Ashworth --
Certified ColdFusion Developer
Network Administrator

Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111]

- Original Message -
From: "Brad Comer" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 04, 2001 11:08 AM
Subject: CF-Certification


| I am going to take the CF Cert. Exam in about an hourany pointers???
|
| Thanks In Advance!
| Brad
| [EMAIL PROTECTED]
|
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Delimited text file to database

[Christine Kelley]

Hi all!
 Never done this one before...
 A client would like to send me delimited text files of 
info for insertion into a database table.  Sort of like the 
Monster.com, http://doc.monster.com/ftpjobs.html.  I'm not 
sure where to start.  Is it  or  to turn the 
file into a query?
 My brain feels a little scrambled :)
   Christine


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

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

Re: Access ldb files w/a twist

[Jon Hall]

I did not noticed any performance problem in testing I did a while back,
besides, using Access is a performance hit in and of itself. Access cant
have too many simultaneous users without serious performance problems of
it's own.

jon
- Original Message -
From: "Zachary S. Bedell" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 04, 2001 11:18 AM
Subject: RE: Access ldb files w/a twist


> > The cfusion_disable_dbconnections() works fine, however, just
> > call your
> > host, and tell them to uncheck the box that says 'Maintain database
> > connections'. Then curse at them because they are not
> > following SOP for
> > Access databases ;-) ldb's will not be a problem if this box
> > is unchecked.
>
> Not to be ignorant, but...  Isn't that a performance hit?  I thought
> keeping the DB open eliminated the extra processing of opening & closing
> it every time it's needed?  Am I completely off?
>
> Thanks,
> Zac
>
>
>
~~
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: Credit Card DB Encryption Methodology

[Jon Hall]

I just use encrypt/base64 to encrypt cards as sop. Here is my snippet, the
key I choose randomly for each site.




jon
- Original Message -
From: "Tony Schreiber" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 04, 2001 11:43 AM
Subject: Re: Credit Card DB Encryption Methodology


> Yes, but that's a physical architecture issue. I'm just trying to address
> the software side. I'm surprised there haven't been more comments on this,
> seems to have been a pretty hot topic.
>
> Also, I've realized no site I've been to seems to store cc info this way
> (because I'm not prompted for my password) so I wonder what other schemes
> they are using
>
> > Sounds very secure, of course you might add that the database in
question
> > should never be on a web server. The  database should only be accessible
> > from behind a firewall which permits only the web server's ip to access
the
> > database server.
> >
> > jon
> > - Original Message -
> > From: "Tony Schreiber" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Thursday, May 03, 2001 3:52 PM
> > Subject: Credit Card DB Encryption Methodology
> >
> >
> > > Ok, I've been reading the last few threads on this and pondering the
best
> > > way to approach this scenario (storing CC in DB) and I've come up with
the
> > > following idea:
> > >
> > > 1) The User's password is stored as a one-way HASH.
> > > 2) The Credit Card info (list of cc number,exp date and verification
> > > number) is stored as an ENCRYPTED string with the User's raw password
as
> > > the key.
> > >
> > > Interface-wise, this requires that:
> > >
> > > a) the user type in their password when Adding or Updating a credit
card
> > > record in the db (so it can be encrypted)
> > > b) the user type in their password when finalizing an order (so the cc
> > > info can be decrypted to be processed)
> > > c) When a user changes their password, all cc records in the database
must
> > > be updated using the old and new passwords
> > >
> > > But this way, neither the users password, the encryption key nor the
cc
> > > info is stored unencrypted anywhere on the server.
> > >
> > > Comments?
> > >
> > >
> > > Tony Schreiber, Senior Partner  Man and Machine,
Limited
> > > mailto:[EMAIL PROTECTED]
http://www.technocraft.com
> > >
> > > http://www.simplemessageboard.com ___Free Forum Software for Cold
Fusion
> > > http://www.is300.net ___The Enthusiast's Home of the Lexus
IS300
> > > http://www.digitacamera.com __DigitA Camera Scripts and
Tips
> > > http://www.linklabexchange.com _Miata Link ECU Data
Exchange
> > >
> > >
> > >
> > >
> >
>
~~
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

UltraDev Conversion

[Brian Thornton]

Anyone got UltraDev info for a CF guy? I need to convert a site


.Brian


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

[Brad Comer]

I am going to take the CF Cert. Exam in about an hourany pointers???

Thanks In Advance!
Brad
[EMAIL PROTECTED]

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

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

client variables

[Brook Davies]

I have a really strange report from a client about some irregularities in 
an app we built for them. Essentially, there is a long client variable that 
contains a delimited string of items. This long delimited list is used 
throughout the app. This string is later stored in the DB.

Each record in the DB has its own identifiably string of delimited items. 
When a user accesses a particular item, the DB record is read and that 
delimited list is set as the client Var. The previous client vars are all 
deleted.

Now, when my user views the entire string it looks normal. But if she 
attempts to edit an item in the list, all of its properties change to an 
item in another list from a separate record in the DB. Its seems as through 
the previous client Var is still hanging around and sometimes being 
selected from the clientVar repository instead of what should be the 
currently active client Var.

Has any one seen anything like this happen before? Am I crazy?

Brook Davies
MaracasMedia.com









  MARACASMEDIA INC.

  Brook Davies
  President


 

Address Info
 

421 - 425 Carrall Street
Vancouver, BC
V6B 6E3 CA 








~~
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: handling 404 errors with CF?

[Mary_Baotic]

In the administrator there is a setting for a Missing Template Handler.  We
use this to catch CF 404 errors. It works quite well.

Mary


   
   
"jim   
   
sullivan"To: CF-Talk <[EMAIL PROTECTED]>   
   
Subject: handling 404 errors with CF? 
   
   
   
05/04/2001 
   
12:37 PM   
   
Please 
   
respond to 
   
cf-talk
   
   
   
   
   




Can CF handle 404 errors?
that is, can CF catch a 404 (page not found) error and send back a custom
error page?
I tried using cferror for this and it doesn't seem to work..
~~
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: handling 404 errors with CF?

[Tony Schreiber]

And your custom page will only work for .cfm pages not found. If cold
fusion doesn't process .html files, those that are not found will result
in your web servers 404 error page.

> Can CF handle 404 errors?
> that is, can CF catch a 404 (page not found) error and send back a custom
> error page?
> I tried using cferror for this and it doesn't seem to work..
> 
> 
>
~~
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 Server Locking?

[Chris Norloff]

-- Original Message --
From: Matt Eschenbaum <[EMAIL PROTECTED]>
>.  During my research I noticed that they didn't set up the
>ColdFusion Administrator Variable Locking.  Now, can I just configure the
>settings in the ColdFusion Administrator for variable locking and not have
>to go back and code locks.  I know this is a stretch, but I haven't been
>able to find any definitive documentation on the ColdFusion Administrator
>configuration for Variable Locking.  

Nope, gotta write those locks.  

You can use Automatic Read Locking, which will lock the reads and error on unlocked 
writes, but it'll run slower since it has to do its own locking.

Full Checking will error on any unlocked reads or writes.

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:Authentication Users Against LDAP

[Jerre Hale]

When I access the SuperGadgets index.cfm template via the browser I am
presented with the product listings screen with the Distributor Login
link.  At login.cfm if I enter a valid username and password for our
test LDAP directory or none at all, I am sent back the index.cfm without
any error message.  It appears that I am not being processed by
authenticate_user.cfm.  I am sure that I am missing something.  Again I
am following the examples in the manual.

On CF server 4.0, when setting up LDAP authentication is the a way to
verify that I have successfully made contact with the LDAP server?  When
I created the Policy, was able to view the LDAP directory but was only
able to select o=gmu.edu.  Any other attempted selection, such as
ou=people, o=gmu.edu, generated an error message: Error Diagnostic
Information, Security Policy Administration, Add User 'ou=People' to
Policy 'LetThemIn' failed.  I can only assume that since I can see the
LDAP directory listing that I am in fact connected.

I have been able to use CFLDAP to add and delete users and query.  So I
know that I connectivity with this approach.

Any assistance is appreciated.

Thanks,

Jerre


~~
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: Dynamic Variable Names

[Joshua Meekhof]

assuming that once you have retrieved the record the value of qn is no
significant, try alias the value in the query:
 
SELECT #qn# as foo
FROM database
 



Jenny Anderson wrote:
> 
> I want to dynamically create a variable name based upon a url variable.
> First I set up a couple of strings:
> 
> 
> 
> Where q is a number from 1-37 passed via url variable.  Let's say that
> url.q is 7.  Then qn is 'q7'.
> So I query the database like this:
> 
> 
>SELECT #qn#
>FROM database
> 
> 
> And it correctly pulls all the results from the 'q7' column.  So far so good.
> But now I want to be able to manipulate the query results and refer to the
> q7's from the database query.  If I refer to #qn# I only get q7 as the
> result.  So how do I have it refer to the variable q7 and not the string q7?
> 
> Thanks!
> 
> Jenny
> 
>
~~
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

handling 404 errors with CF?

[jim sullivan]

Can CF handle 404 errors?
that is, can CF catch a 404 (page not found) error and send back a custom
error page?
I tried using cferror for this and it doesn't seem to work..


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

Output

[Chris Badouin]

All-

Outputting a selection of categories & subcategories and within all
categories selections is the subcategory field "other". So, if the output is
ordered alphabetically the "other" will show in the middle(of course). 

What would be the proper way to place "other" at the bottom of the output?

CB


~~
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: Spell Checking??

[Cameron Childress]

As a side note here, our company has adopted a policy of locking CFX tags
using named locks which are named after the CFX tag itself IE:
NAME="CFX_Spell".  Assuming everyone using that machine obeys this rule,
this ensures that the lock is present across all applications on the
machine, and really helps out when you have multiple apps on a server.

-Cameron


Cameron Childress
elliptIQ Inc.
p.770.460.7277.232
f.770.460.0963

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 04, 2001 1:09 PM
> To: CF-Talk
> Subject: RE: Spell Checking??
>
>
> 1) In our case, we figured out that cfx_spell was not thread safe by
> deploying it and watching CF crash under load :-(.  I think you
> need to have
> some decent C/C++ knowledge and access to the source to be able to be sure
> in advance.
>
> 2) You need to lock them if you need to lock them; that is, depends on the
> tag and the situation.
>
> -Original Message-
> From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 04, 2001 10:41 AM
> To: CF-Talk
> Subject: RE: Spell Checking??
>
>
> 2 Questions
>   1. How do you know if a cfx tag is thread safe
>   2. Do you need to lock cfx tags?
>
> Cheers
>
> KOla
>
> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]]
> Sent: 04 May 2001 14:06
> To: CF-Talk
> Subject: RE: Spell Checking??
>
>
> > I have a customer who is insisting upon having a built-in
> > spell checker in an application I'm currently writing. The
> > only application I can find seems to be Ben's CFX_Spell.
> > While I admire Ben, it is a 1.0 application that was developed
> > 4 years ago. Did he write the perfect application which needs
> > no updates?
> >
> > Has anyone had any experience with CFX_Spell or have you
> > incorporated any other spell checking system into a CF
> > application?
>
> We've used CFX_Spell, and it's not thread-safe, so you'll need to lock it
> with a named exclusive CFLOCK. Other than that, it's fine, as long as you
> don't need to have everybody running it at once.
>
> 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: CF Studio and UltraDev Merging!

[Nathan Stanford]

I hope that is correct and my reason for worry is no more.  I also know that
MM reads this list and wanted them to know how important it is to us as
developers.


Nathan Stanford
Senior Programmer/Analyst
[EMAIL PROTECTED]


> -Original Message-
> From: Stephen Collins [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, May 03, 2001 9:05 PM
> To:   CF-Talk
> Subject:  RE: CF Studio and UltraDev Merging!
> 
> Interestingly, I can give a definitive answer on the subject...
> 
> Adam Berrey, Macromedia VP of Application Server Business (ex-Allaire, and
> apparently Allaire employee #10 in 1996) has been visiting Australia this
> week and I took the opportunity to discuss with him a number of issues
> relating to the future of CF and Spectra (which I can discuss offline if
> anyone's interested).
> 
> One announcement he did make was that very soon, UltraDev and CF Studio
> would be packaged in the one box (NOT the one app) and sold as a bundle at
> around the price of UD alone (kind of like the UD/Fireworks bundle).  This
> announcement would appear to refer to just such a bundling.  The products
> would remain available standalone for those not interested in the bundle.
> Adam was VERY vehement about the fact that Macromedia UNDERSTANDS THE
> SEPARATION between designer (not me, nor most of us on the list I imagine)
> and coder (me, and you) and would continue to allow that separation to
> exist, even if UD and Studio eventually became the one product - which has
> not yet been decided.
> 
> Rest easy.
> 
> As for my $0.02, I use UD4 several times a week for layout work, as it
> quite
> happily sucks up my CF code and doesn't break it.  It's a great tool.
> That
> said, Studio remains my tool of choice for cutting CF code.
> 
> Steve Collins
>
~~
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: CFContent and large file transfers

[tom muck]

> Can anyone suggest an alternate method? Is there any way I can control
where
> the CFContent places the temporary file then zip the file prior to
download?
>
> Thank you in advance,
>
> Will Fadel
> ([EMAIL PROTECTED])


You could probably write the file using CFFILE and avoid CFCONTENT
altogether, and then use Ben Forta's CFX_ZIP tag to automatically zip up the
file and then a CFLOCATION to download the resulting zip file.

tom






~~
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: Credit Card DB Encryption Methodology

[Tony Schreiber]

Yes, but that's a physical architecture issue. I'm just trying to address
the software side. I'm surprised there haven't been more comments on this,
seems to have been a pretty hot topic.

Also, I've realized no site I've been to seems to store cc info this way
(because I'm not prompted for my password) so I wonder what other schemes
they are using

> Sounds very secure, of course you might add that the database in question
> should never be on a web server. The  database should only be accessible
> from behind a firewall which permits only the web server's ip to access the
> database server.
> 
> jon
> - Original Message -
> From: "Tony Schreiber" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, May 03, 2001 3:52 PM
> Subject: Credit Card DB Encryption Methodology
> 
> 
> > Ok, I've been reading the last few threads on this and pondering the best
> > way to approach this scenario (storing CC in DB) and I've come up with the
> > following idea:
> >
> > 1) The User's password is stored as a one-way HASH.
> > 2) The Credit Card info (list of cc number,exp date and verification
> > number) is stored as an ENCRYPTED string with the User's raw password as
> > the key.
> >
> > Interface-wise, this requires that:
> >
> > a) the user type in their password when Adding or Updating a credit card
> > record in the db (so it can be encrypted)
> > b) the user type in their password when finalizing an order (so the cc
> > info can be decrypted to be processed)
> > c) When a user changes their password, all cc records in the database must
> > be updated using the old and new passwords
> >
> > But this way, neither the users password, the encryption key nor the cc
> > info is stored unencrypted anywhere on the server.
> >
> > Comments?
> >
> >
> > Tony Schreiber, Senior Partner  Man and Machine, Limited
> > mailto:[EMAIL PROTECTED]   http://www.technocraft.com
> >
> > http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion
> > http://www.is300.net ___The Enthusiast's Home of the Lexus IS300
> > http://www.digitacamera.com __DigitA Camera Scripts and Tips
> > http://www.linklabexchange.com _Miata Link ECU Data Exchange
> >
> >
> >
> >
>
~~
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 Using 90-100% of processor time (911!)

[Darren Adams]

Where can I get CF 4.0 service packs ?

Untill we get the licenses for 4.5 I would like to upgrade our studios a
little bit ?

Daz

-Original Message-
From: Mark Woods [mailto:[EMAIL PROTECTED]]
Sent: 03 May 2001 15:43
To: CF-Talk
Subject: RE: CF Using 90-100% of processor time (911!)


and in case you haven't already done so, make sure you have the latest 
service pack for your version of CF installed.

At 02:42 PM 5/3/2001, you wrote:
> > Would any of the log files give you a hint as to which pages
> > were accessed when the server started using up resources?
>
>Not necessarily, although there is a "log slow pages" option which can be
>enabled in CF Administrator. Often, the "slow pages" will be the ones
>causing trouble!
>
>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: Spell Checking??

[Dylan Bromby]

>> 1. How do you know if a cfx tag is thread safe?

More like how do you know when it's not?

When it starts crashing your sever. :) Seriously though, some are more
thread-safe than others, but there's no way of knowing that unless the
author of the tag tells you, or you may or may not see memory issues with
ColdFusion. You'd need to look at the logs to determine what code was
causing the problems and see if there were any CFX tags there. But you
should lock them anyway.

>> 2. Do you need to lock cfx tags?

It's good practice to lock CFX tags in general.


-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: 04 May 2001 14:06
To: CF-Talk
Subject: RE: Spell Checking??


> I have a customer who is insisting upon having a built-in
> spell checker in an application I'm currently writing. The
> only application I can find seems to be Ben's CFX_Spell.
> While I admire Ben, it is a 1.0 application that was developed
> 4 years ago. Did he write the perfect application which needs
> no updates?
>
> Has anyone had any experience with CFX_Spell or have you
> incorporated any other spell checking system into a CF
> application?

We've used CFX_Spell, and it's not thread-safe, so you'll need to lock it
with a named exclusive CFLOCK. Other than that, it's fine, as long as you
don't need to have everybody running it at once.

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

CF Server Locking?

[Matt Eschenbaum]

I have a client who has problems with sessions getting corrupt.  I've
determined that their site does not utilize locking in the code throughout
the application.  During my research I noticed that they didn't set up the
ColdFusion Administrator Variable Locking.  Now, can I just configure the
settings in the ColdFusion Administrator for variable locking and not have
to go back and code locks.  I know this is a stretch, but I haven't been
able to find any definitive documentation on the ColdFusion Administrator
configuration for Variable Locking.  Any suggestions or leads would be
appreciated.

matt


~~
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: Spell Checking??

[mherbene]

1) In our case, we figured out that cfx_spell was not thread safe by
deploying it and watching CF crash under load :-(.  I think you need to have
some decent C/C++ knowledge and access to the source to be able to be sure
in advance.

2) You need to lock them if you need to lock them; that is, depends on the
tag and the situation.

-Original Message-
From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 04, 2001 10:41 AM
To: CF-Talk
Subject: RE: Spell Checking??


2 Questions
1. How do you know if a cfx tag is thread safe
2. Do you need to lock cfx tags?

Cheers

KOla

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: 04 May 2001 14:06
To: CF-Talk
Subject: RE: Spell Checking??


> I have a customer who is insisting upon having a built-in
> spell checker in an application I'm currently writing. The
> only application I can find seems to be Ben's CFX_Spell.
> While I admire Ben, it is a 1.0 application that was developed
> 4 years ago. Did he write the perfect application which needs
> no updates?
>
> Has anyone had any experience with CFX_Spell or have you
> incorporated any other spell checking system into a CF
> application?

We've used CFX_Spell, and it's not thread-safe, so you'll need to lock it
with a named exclusive CFLOCK. Other than that, it's fine, as long as you
don't need to have everybody running it at once.

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: Access ldb files w/a twist

[Zachary S. Bedell]

> The cfusion_disable_dbconnections() works fine, however, just 
> call your
> host, and tell them to uncheck the box that says 'Maintain database
> connections'. Then curse at them because they are not 
> following SOP for
> Access databases ;-) ldb's will not be a problem if this box 
> is unchecked.

Not to be ignorant, but...  Isn't that a performance hit?  I thought
keeping the DB open eliminated the extra processing of opening & closing
it every time it's needed?  Am I completely off?

Thanks,
Zac


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

Oracle stored procedure question.

[Kevin Gilchrist]

Hi All,

I need another set of eyes on a problem. I have a piece of code that calls
an Oracle stored procedure that just refuses to work with either the Oracle
or Microsoft ODBC drivers on my personal development Win2K box (CF Pro 4.5.1
SP2).  However, it does work with the Oracle native drivers though on our
Solaris production machine.

The code in question is:












The MS driver throws back an error message about there being a bad parameter
datatype, while the Oracle driver just says that there's a syntax violation.
I've double-checked the data-types and I'm pretty sure that they're right
and that all the variable values are OK as it works with the native driver.
I shouldn't have to wrap anything is single quotes right because
CFSTOREDPROC will do this as appropriate, right?

If I do a desc of the SP in SQL PLus, I get:

PROCEDURE CREATE_NODE
 Argument Name  TypeIn/Out Default?
 -- --- -- 
 NODE   VARCHAR2IN
 SYSTEM_TYPEVARCHAR2IN
 AGENT_PORT NUMBER  IN
 IP_ADDRESS VARCHAR2IN
 MONITORED  VARCHAR2IN
 REF_CODE   VARCHAR2IN
 REF_ID NUMBER  IN
 RETURN_STATUS  VARCHAR2OUT   

Any ideas as to how I can get the code above to work with CF Pro?
I've upgraded both sets of ODBC drivers on my Win2K box to the latest and
greatest etc.

We're eventually going to get another CF Enterprise license for a Solaris
test box although that doesn't help me right now.  I hate testing on a
production box (although the app I'm writing is only in the dev stage so
it's not as if I'm messing with a live app)

Any suggestions would be really appreciated!

Kevin

Kevin Gilchrist
Senior Consultant
RedSiren Technologies Inc.
(412) 281 4427 ext 466

~~
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: Brown Bear's iCal

[C. Hatton Humphrey]

Justin,

Thanks for the reply.  What I'm actually trying to do is grab the output and
fit it into a look and feel.

Hatton

> -Original Message-
> From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 03, 2001 6:31 AM
> To: CF-Talk
> Subject: RE: Brown Bear's iCal
>
>
> are you trying to parse iCal data??
>
> use lex/yacc + a cCFX
> or jacc + & java cfx
>
>
> look here http://www.imc.org/
>
> Justin
>
> >>-Original Message-
> >>From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]]
> >>Sent: Thursday, May 03, 2001 3:01 AM
> >>To: CF-Talk
> >>Subject: Brown Bear's iCal
> >>
> >>
> >>Does anyone have or know of a custom tag that interacts with
> Brown Bear's
> >>iCal calendar server.  If not, does anyone know where I can get a good
> >>reference for parsing through a CFHTTP pull?
> >>
> >>TIA!
> >>Hatton Humphrey
> >>
> >>
> >>
>
~~
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 form, two submit buttons...

[Erik Carroll]

In addition to the ways already presented you can try something like this

Put however many buttons you want on the form. Give them the same name but
different values.
Imagine a form with two input boxes for two numbers and  four buttons as
follows.

   
   
   
   

When the form is submitted, you can interrogate form.submit as follows to
determine which button was pressed.

   
   
   
   
   
   
   
   
   
   
   

To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, April 29, 2001 1:07 PM
Subject: One form, two submit buttons...


> Hi,
>
> I have a form that is posted to a processing page.  I want to add another
> button that submits the form information to another page, if the user
> wishes, which will preview what it will look like.
>
> How can I do this?
>
> Cheers.
>
> --
> Will
> Free Classifieds -=- www.localbounty.com
> e: [EMAIL PROTECTED]  icq: 31099745
>
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: OT - synch files automatically

[Mark Woods]

store all the images on one server and map drives to it from the other servers

or use file replication service




At 05:28 PM 5/2/2001, you wrote:
>I am having problems replicating images across to load balanced servers. We
>have users that are upload images to one server and need to have an
>automated way to check the other server for this file and if it doesn't
>exist we need to transfer a copy over. Has anyone came across any solutions
>for this. Thanks for any help!
>
>Rick
>
>
>
~~
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: Spell Checking??

[Kola Oyedeji]

2 Questions
1. How do you know if a cfx tag is thread safe
2. Do you need to lock cfx tags?

Cheers

KOla

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: 04 May 2001 14:06
To: CF-Talk
Subject: RE: Spell Checking??


> I have a customer who is insisting upon having a built-in
> spell checker in an application I'm currently writing. The
> only application I can find seems to be Ben's CFX_Spell.
> While I admire Ben, it is a 1.0 application that was developed
> 4 years ago. Did he write the perfect application which needs
> no updates?
>
> Has anyone had any experience with CFX_Spell or have you
> incorporated any other spell checking system into a CF
> application?

We've used CFX_Spell, and it's not thread-safe, so you'll need to lock it
with a named exclusive CFLOCK. Other than that, it's fine, as long as you
don't need to have everybody running it at once.

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