RE: Hosting with Webexpose.net

[Gary McNeel, Jr.]

These guys got hammered in a series of exchanges in this forum sometime
back. You may want to look at the archives.

http://www.mail-archive.com/cf-talk@houseoffusion.com/

-Gary

> -Original Message-
> From: Jason Larson [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 12, 2001 9:32 AM
> To: CF-Talk
> Subject: Hosting with Webexpose.net
>
>
>
> I was wondering if anyone out there can give me some feedback on
> Webexpose.net cf web hosting. I like the fact that with webexpose, you can
> install your own custom CF Tags. I have not been able to find a telephone
> number for tech support though, this could be pretty scarry.
>
> Thanks for your feedback
>
> Jason Larson
> [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

CFX_Excel Tag Error

[Gary McNeel, Jr.]

I get this error. The query is quite large, the error is generated about 40
seconds into the query (1844ms for the query, about 929 records with a bunch
of fields. Anyone had a problem with this? Is there a timeout you can set?

Error Diagnostic Information
Error in CFX_Excel Tag


Unexpected OLE Automation Error while processing tag:

The error occurred while processing an element with a general identifier of
(CFX_EXCEL), occupying document position (41:1) to (42:220) in the template
file (path info)

Regards,

Gary McNeel, Jr.
DACNet Senior Project Manager
Research and Graduate Studies, Rice University
[OP] 713-348-6266
[M] 713-962-0885
[HO] 713-723-9240


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: high profile CF sites...

[Gary McNeel, Jr.]

My guess is they were trying to get the ALT text to step-down in a box
format.

ex.
MBE



Online, Connect




or Success, "The Complete Internet Access Service)

It just did not work. Or maybe they want  ?

-Gary

> -Original Message-
> From: JayB [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 09, 2001 3:51 PM
> To: CF-Talk
> Subject: Re: high profile CF sites...
>
>
> At 03:01 PM 1/9/2001 -0500, you wrote:
> >Hey, I just noticed that Mail Boxes, Etc. is a Cold Fusion site.
> >http://www.mbe.com
>
>
> Just had a look at the mbe siteanyone have a clue as to why
> they would
> set up their ALT tags like thisit looks weird in the browser
> and seems
> a little silly to me?
>
>
> height=89 src="images/Splash/mbe6a1.jpg" width=146 >
>
> or conversely...is this some kind of bug, error or other
> strangeness which
> could be introduced into a page?...I know without source it's
> kinda hard to
> know...but I don't want me alt tags to look like theirs...!
>
>
>
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: browser check

[Gary McNeel, Jr.]

Go to the CF Developers Exchange look at the custom tags that do this for
you. AEBrowser (I think) is the one I use often, works great and returns a
lot of useful information on the client that you can use to make good
decisions. There are other good ones there too. I use it for checking
browser types and versions and then display messages, use different menus or
load different stylesheets.

-Gary

> -Original Message-
> From: Jay Patton [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 09, 2001 11:43 AM
> To: CF-Talk
> Subject: browser check
>
>
> ?
> looking for help on this if anyone can...
> on our new layout for our site we have a menu script that works
> great with IE but not w/ ns. i was wondering if their was a way
> to do a check with cf that would check which browser was being
> used and if they were using NS then it would not load the menu
> script but if they were using IE then it would. ( does that make
> sense?) any ideas?
>
> thanks,
>
> Jay Patton
> Web Pro USA
> 406.549.3337 ext. 203
> 1.888.5WEBPRO
> www.webpro-usa.com
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: CFMAIL question

[Gary McNeel, Jr.]

Read-up more on CFFILE. It can handle that for you. First it checks for a
file with the same name in the appropriate directory. If it finds one it
automagically renames the uploaded file to something like AC109.exe
(whatever). It returns the new file name to you in a variable that you can
manipulate (like storing it in a database as a pointer, etc.).

-Gary

> -Original Message-
> From: Dave Hannum [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 05, 2001 10:14 AM
> To: CF-Talk
> Subject: Re: CFMAIL question
>
>
> How do you handle the possibility of duplicate file names?  If you have a
> handler, that would be good enough (or I can write a handler to uniquely
> rename each file)
>
> Thanks,
> Dave
>
>
> =
> "What we need is a list of specific unknown problems we will encounter"
>
> David Hannum
> Web Analyst/Programmer
> Ohio University
> [EMAIL PROTECTED]
> (740) 597-2524
>
>
>
> - Original Message -
> From: "James Taavon" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, January 05, 2001 10:59 AM
> Subject: Re: CFMAIL question
>
>
> Dave, I have an app that does something similar, but the file is
> uploaded to the server ina specifoed directory where it can be
> retrieved. Is that good enough?
>
>
> Dave Hannum wrote:
> >
> > Hello,
> >
> > I have an application where the client wants to be able to have
> customers
> > submit information and a document using CFMAIL via a web form.  Does
> someone
> > have an example they can share where they do this.  User fills
> out a form
> > and then attaches a file from their local hard drive and it is submitted
> to
> > owner via CFMAIL.
> >
> > Thanks,
> > Dave
> >
> > =
> > "What we need is a list of specific unknown problems we will encounter"
> >
> > David Hannum
> > Web Analyst/Programmer
> > Ohio University
> > [EMAIL PROTECTED]
> > (740) 597-2524
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: Any good Authorizenet solutions?

[Gary McNeel, Jr.]

There is also one on the net for ASP (a COM or DCOM object) that sounds very
nice. Been awhile since I saw it. I think it was AuthorizeX or something
like that. Sorry, I just can't remember the name. Was nice though. You pass
the object the info, it initiates a secure connection to AuthorizeNet, they
talk, you get a response code passed back and your done. I THINK it was
about $100.

The tags at Allaire were good too, only problem I found was that they were
out of date (at the time I looked, about a year ago). Maybe someone has
updated them to work with the changes at AuthorizeNet.

Regards,

Gary McNeel, Jr.
DACNet Senior Project Manager
Research and Graduate Studies, Rice University
[OP] 713-348-6266
[M] 713-962-0885
[HO] 713-723-9240 [HO] 713-723-9240

> -Original Message-
> From: Aaron Johnson [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 05, 2001 9:12 AM
> To: CF-Talk
> Subject: RE: Any good Authorizenet solutions?
>
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Pardeep,
>
> There are 2 custom tags in the tag gallery for doing exactly this:
>
> CF_AuthNet
> http://devex.allaire.com/developer/gallery/info.cfm?ID=CA34743C-2830-1
> 1D4-AA9700508B94F380&method=Full
>
> CF_Authorize
> http://devex.allaire.com/developer/gallery/info.cfm?ID=86F5E80C-9646-1
> 1D4-83E100508B94F85A&method=Full
>
>
> Aaron Johnson, MCSE, MCP+I
> Allaire Certified ColdFusion Developer
> MINDSEYE, Inc.
> 617.350.0339
> 617.350.8884
> 66172567
> [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: (OT): The +.htr bug strikes again becomes categorically executing want to be dev

[Gary McNeel, Jr.]

Hey Eric, I am sending you a package in the mail. It will be in a plain
brown wrapper with a return address like Ed McMahon and Company, that sounds
like you may have won a lot of money. Just pick it up and shake it violently
before ripping it open. Think of it as a holiday present. (Note: Please do
not open around children or family members. Also, you may want to call a
bunch of your developer friends and gather BEFORE opening it. BIG SURPRISE
inside.

(thinking to self)
Okay. One (or more) less developer(s) means $125 an hour x 1.45 to 2. If I
send out 500 of these at a cost of 

-Gary

> -Original Message-
> From: Eric Dawson [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 21, 2000 3:52 PM
> To: CF-Talk
> Subject: (OT): The +.htr bug strikes again becomes categorically
> executing want to be dev
>
>
> I wonder how the categorical execution of developers would influence the
> hourly rates we could work for. I mean think about it. If each developer
> executes one developer, the demand wouldn't change, so our rates would
> explode. maybe 10x what is currently available.
>
> E
>
>
> From: [EMAIL PROTECTED]
> Reply-To: [EMAIL PROTECTED]
> To: CF-Talk <[EMAIL PROTECTED]>
> Subject: RE: The +.htr bug strikes again
> Date: Thu, 21 Dec 2000 15:05:49 -0800
>
>
> 
> Yes what were you thinking putting us at the mercy of these ruthless and
> criminally minded developers.
> In fact i propose that all developers on this list be executed
> immediately
> to offset any danger to world democracy or the groovy capitalist
> system that
> lets us all make lots of money in the IT world.
> Granted many of us are not the kind of wicked, Dr. Evil type of
> developers,
> but hell why take the chance, its just not worth it.
> I further propose that the word coldfusion be banned as subversive and
> against god
> ---woe unto him that hath developed  in a wicked way
> 
>
> #code.monkey#
>
>  > ** Original Subject: RE: The +.htr bug strikes again
>  > ** Original Sender: Billy Cravens <[EMAIL PROTECTED]>
>  > ** Original Date: Thu, 21 Dec 2000 15:20:27 -0500
>
>  > ** Original Message follows...
>
>  >
>  > Don't you think it would have been better to wait until after Hasbro
>  > patched it to alert a list of hundreds of developers?  I often run
>  > across cf sites with the htr bug (it's hardly uncommon).  I usually
>  > email the webmaster personally, as opposed to the "Hey guys!  Look what
>  > I found!"
>  >
>  > Just out of curiosity (nothing against you Kevin): what are the legal
>  > implications for something like this?  Even if it's just a hole which a
>  > person could find on their own, can pointing it out be a cause for
>  > liability?
>  >
>  > --
>  > Billy Cravens
>  > [EMAIL PROTECTED]
>  >
>  >
>  >
>  > Kevin Schmidt wrote:
>  > >
>  > > Check out Hasbro Interactive.  They run entirely CF and
> haven't patched
> the
>  > > +.htr bug yet.  I alerted them to this fact.
>  > >
>  > > Kevin Schmidt, Web Technology Manager
>  > > Allaire Certified Cold Fusion Developer
>  > > pwb inc.
>  > > integrated marketing communications
>  > > 350 S. Main St., Suite 350
>  > > Ann Arbor, MI 48104
>  > > 734.995.5000 (tel)
>  > > 734.995.5002 (fax)
>  > > www.pwb.com
>  > >
>  > >
>  >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: (OT): The +.htr bug strikes again becomes categorically executing want to be dev

[Gary McNeel, Jr.]

LOL. But actually, you are right. But aren't big corporations running the
governement now anyway? They have been for 40 years. Alas, it will probably
get worse now that President (S)elect Bush is in office.

-Gary

> -Original Message-
> From: Jon Hall [mailto:[EMAIL PROTECTED]]
> Sent: Friday, December 22, 2000 9:20 AM
> To: CF-Talk
> Subject: Re: (OT): The +.htr bug strikes again becomes categorically
> executing want to be dev
>
>
> I am being anal, but you are misconstruing the Robin Hood legend.
> He did not
> steal from the "rich". He stole from the government that was
> overtaxing the
> citizens. It may seem only a semantic difference, but it is
> actually a huge
> difference. Your telling of the story would make Robin evil in my
> eyes...and
> we couldn't have that. ;-)
>
> wow this is way off topic...
>
> jon
> > Kinda like Robin Hood (stealing from the rich...) only without
> > giving it to the poor
> >
> > A to steal from the corporate and give to me...
> >
> > ahem...not steal...i mispoke myself..."borrow permanantly".
> >
> > Miles.
> >
> > >
> > >
> > >Yes what were you thinking putting us at the mercy of these
> ruthless and
> > >criminally minded developers.
> > >
> > >In fact i propose that all developers on this list be executed
> immediately
> > >to offset any danger to world democracy or the groovy capitalist system
> that
> > >lets us all make lots of money in the IT world.
> > >
> > >Granted many of us are not the kind of wicked, Dr. Evil type of
> developers,
> > >but hell why take the chance, its just not worth it.
> > >
> > >I further propose that the word coldfusion be banned as subversive and
> > >against god
> > >
> > >---woe unto him that hath developed  in a wicked
> way
> > >
> > >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: colors...

[Gary McNeel, Jr.]

Cool.

> -Original Message-
> From: Jon Hall [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 19, 2000 12:13 PM
> To: CF-Talk
> Subject: colors...
>
>
> Since there isn't a lot of activity on the list today, and I just
> finished a
> project (thanks to a lot of help from here), it must be the weather...
> I thought I would post some neato code I was playing with this
> weekend. It's
> a cool rollover effect, maybe for menus or whatnot, I really cant
> figure out
> a good use though ;-)
>
> 
>  "##33,##66,##99,##cc,Blue,##3300ff,##0066ff,##0099
> ff,##00ccf
> f,Aqua,##99,##cc,White,White">
>  "Black,##121212,##242424,##363636,##484848,##5a5a5a,##6c6c6c,##7e7
> e7e,##9090
> 90,##a2a2a2,##b4b4b4,##c6c6c6,##d8d8d8,##eaeaea">
>  "##020202,##030303,##040404,##050505,##060606,##070707,##090909,##
> 0a0a0a,##0
> b0b0b,##0c0c0c,##0d0d0d,##0e0e0e,##0f0f0f,##101010,##11,##1212
> 12,##13131
> 3,##141414,##151515,##161616,##171717,##181818,##191919,##1a1a1a,#
> #1b1b1b,##
> 1c1c1c">
>  "##eaeaea,##d8d8d8,##c6c6c6,##b4b4b4,##a3a3a3,##909090,##7e7e7e,##
> 6c6c6c,##5
> a5a5a,##484848,##363636,##242424,##121212,Black">
> 
> 
> 
>
> 
> 
> 
>  onMouseOver="this.style.background='#listgetat(colorlist2,looptracker)#'"
> onMouseOut="this.style.background='#color#'"
> onclick="this.style.background='red'">
> |
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>
> I've got a couple of extra colorlists, that can be changed in the code for
> different color schemes, and changing between looptracker and looptracker2
> changes the effect...
> oh yeah...dont forget to click on the rollovers
>
> 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: Danger of the +.htr bug

[Gary McNeel, Jr.]

Absolutely there is a danger. Just off the top of my head I can think of a
few. These may not be best practice but:

1. If you put the username and password in a CFQUERY they can see that (and
anything else).
2. If you just hard code a password or IP range to be blocked, or other
information that should not be seen.
3. If you have a client you do work for THEY have copyright to the code.
They paid for it, it is theirs.
4. Any CF comments become visible. You may be explaining a business process
and it gets read by someone who does not need to know about it.

Because you may have a bunch of people coding, you cannot anticipate what
may or may not be put in the code.

-Gary

> -Original Message-
> From: Eric Dawson [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 19, 2000 10:15 AM
> To: CF-Talk
> Subject: Re: Danger of the +.htr bug
>
>
> Is there any danger to the +.htr beyond being able to view the
> source code
> of the site?
>
> ie if you want my source code ... 1.) Why? I don't want it, but
> am forced to
> code it, and 2.) It might be easier to ask me for it, cause I'll
> zip up all
> the files and email it to you.
>
> Eric
>
>
> From: "Jamie Keane" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> To: CF-Talk <[EMAIL PROTECTED]>
> Subject: Re: Cool CF site - webos.org
> Date: Tue, 19 Dec 2000 08:57:29 -0500
>
> The fact that they don't have the +.htr bug patched.  Very
> interesting.
>
> Cheers,
> Jamie
>
> --
> Jamie Keane
> Programmer
> SolutionMasters, Inc.
> 9111 Monroe Rd., Suite 100
> Charlotte, NC  28270
> www.solutionmasters.com
> 704.563.5559 x 228  Voice
> 704.849.9291  Fax
> -Original Message-
> From: Gena <[EMAIL PROTECTED]>
> To: CF-Talk <[EMAIL PROTECTED]>
> Date: Monday, December 18, 2000 5:41 PM
> Subject: Re: Cool CF site - webos.org
>
>
>  >Pardon,
>  >
>  >do you mean this web site or my message???
>  >
>  >Regards
>  >
>  >
>  >- Original Message -
>  >From: "Jamie Keane" <[EMAIL PROTECTED]>
>  >To: "CF-Talk" <[EMAIL PROTECTED]>
>  >Sent: Tuesday, December 19, 2000 9:20 AM
>  >Subject: Re: Cool CF site - webos.org
>  >
>  >
>  >> *ROFL*
>  >>
>  >> That's the funniest thing I've seen this month!
>  >>
>  >> --
>  >> Jamie Keane
>  >> Programmer
>  >> SolutionMasters, Inc.
>  >> 9111 Monroe Rd., Suite 100
>  >> Charlotte, NC  28270
>  >> www.solutionmasters.com
>  >> 704.563.5559 x 228  Voice
>  >> 704.849.9291  Fax
>  >> -Original Message-
>  >> From: Gena <[EMAIL PROTECTED]>
>  >> To: CF-Talk <[EMAIL PROTECTED]>
>  >> Date: Monday, December 18, 2000 4:54 PM
>  >> Subject: Re: Cool CF site - webos.org
>  >>
>  >>
>  >> >And what is cool on this site? I found only one thing - it
> is possible
> to
>  >> >get all source code from this URL. It is not cool.
>  >> >
>  >> >- Original Message -
>  >> >From: "Eric Fickes" <[EMAIL PROTECTED]>
>  >> >To: "CF-Talk" <[EMAIL PROTECTED]>
>  >> >Sent: Tuesday, December 19, 2000 8:00 AM
>  >> >Subject: Cool CF site - webos.org
>  >> >
>  >> >
>  >> >> Hello all,
>  >> >>
>  >> >> I was wondering if any of you have seen/used www.webos.org yet?  I
>  >> noticed
>  >> >> that it's using CF, so I was hoping that some of you may have an
> answer
>  >> to
>  >> >> my question.  WebOs emulates a desktop, and pops up windows within
> one
>  >> >large
>  >> >> parent window.  I would love to do this on my inhouse site for
>  >navigation
>  >> >> and was wondering if any of you knew how to do this.
>  >> >>
>  >> >> E
>  >> >>
>  >> >>
>  >> >>
>  >> >
>  >>
>  >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: SQL DROP TABLE

[Gary McNeel, Jr.]

Thanks gang, I inadvertently stumbled on the one below while looking in the
SQL books online under INSERT (something completely different). Works like a
charm. Thanks Jeff.


This is the code I used.

IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME
= 'T1')
DROP TABLE T1


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Friday, December 15, 2000 8:38 PM
> To: CF-Talk
> Subject: Re: SQL DROP TABLE
>
>
> Gary,
>
> select name
> from sysobjects
> where name = 'tablename'
>
> That should tell you if the table exists.
>
> Jeff Craig
> ICQ 51303123
>
> - Original Message -
> From: "Gary McNeel, Jr." <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, December 15, 2000 6:36 PM
> Subject: SQL DROP TABLE
>
>
> > I am trying to use cfquery to drop a table. That works fine.\
> >
> > Problem:
> > If I run the DROP TABLE on a database where the table is already gone I
> get
> > a nasty SQL error. Is there a simple way to check for the
> existance of the
> > table, and if present, then drop it? My mind is mush right now and I
> cannot
> > figure this one out. Thank all.
> >
> > Regards,
> >
> > Gary McNeel, Jr.
> > DACNet Project Manager
> > Research and Graduate Studies
> > Rice University
> > [OP] 713-348-6266
> > [M] 713-962-0885
> > [HO] 713-723-9240
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

SQL DROP TABLE

[Gary McNeel, Jr.]

I am trying to use cfquery to drop a table. That works fine.\

Problem:
If I run the DROP TABLE on a database where the table is already gone I get
a nasty SQL error. Is there a simple way to check for the existance of the
table, and if present, then drop it? My mind is mush right now and I cannot
figure this one out. Thank all.

Regards,

Gary McNeel, Jr.
DACNet Project Manager
Research and Graduate Studies
Rice University
[OP] 713-348-6266
[M] 713-962-0885
[HO] 713-723-9240


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://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: Beware the imposter

[Gary McNeel, Jr.]

I confess, it was Uwe who did it. ;)

(Moving to Cafe 182).

-Gary

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 14, 2000 3:45 PM
> To: CF-Talk
> Subject: Re: Beware the imposter
> 
> 
> Todd, what if he works from an internet cafe to do this ?
> And he is changing the cafes constantly ?
> You simply can't find this guy !
> 
> Uwe
> 
> 
> Mail: [EMAIL PROTECTED]
> WWW: www.sdsolutions.de
> - Original Message -
> From: "Todd Ashworth" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, December 14, 2000 5:09 PM
> Subject: Re: Beware the imposter
> 
> 
> Doesn't Hotmail include the originating IP in their headers 
> anymore?  I know
> they used to.  If they still do, you can just figure out their 
> ISP and lodge
> a complaint.  I'm sure you would get prompt action ;)
> 
> Todd Ashworth
> 
> - Original Message -
> From: "Ben Forta" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, December 14, 2000 9:51 AM
> Subject: OT: Beware the imposter
> 
> 
> | Hi all, sorry for the OT message, but ...
> |
> | Some creep has set up an e-mail account "[EMAIL PROTECTED]" and is
> | sending out messages pretending to be me. Not that any of you would be
> | fooled by the messages (they essentially badmouth ColdFusion, 
> Allaire, and
> | me, and the language is both immature and tasteless) but just so you
> know -
> | it is not me. Promise. :-)
> |
> | What he is doing is illegal. If any of you have any idea who 
> this jerk is,
> | please let me know. Thanks.
> |
> | --- Ben
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: CGI.HTTP_REFERER and SSL

[Gary McNeel, Jr.]

Maybe you could try to capture the cgi.Server_Name or IP instead?

You may also want to look at the authorizenet merchant management section
though. Login and click on settings. Then select Manage URLs. You'll want to
configure this area.

-Gary

> -Original Message-
> From: Chris Montgomery [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 14, 2000 1:43 PM
> To: CF-Talk
> Subject: CGI.HTTP_REFERER and SSL
>
>
> Howdy,
>
> I have a simple payment form that submits to a secure page at
> AuthorizeNet.
> Once a customer makes a payment, they are returned to a receipt page on my
> remotely hosted site.  The AuthorizeNet gateway submits transaction
> information back to this receipt page using a form POST method.  The form
> post is originating on their secure site back to my non-secure
> receipt page.
>
> To prevent anyone from inadvertently accessing the receipt page
> (receipt.cfm) I wanted to check for the http referring page
> (AuthorizeNet's
> posting page) and redirect them to another page if the referrer
> was anything
> else.  This isn't working, the #cgi.http_referer# variable comes up blank.
>
> Is there a known problem using cgi.http_referer when transferring requests
> between secure and non-secure pages?
>
> TIA,
>
> Chris Montgomery [EMAIL PROTECTED]
>
> Web Development & Consulting http://www.astutia.com
> Allaire Consulting Partner
> 210-490-3249/888-745-7603Fax 210-490-4692
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

HELP: List questions...

[Gary McNeel, Jr.]

I am working with ascii delimited data, trying to read them into a SQL
Server table through a web browser interface. After it is all working I want
to convert it to a scheduled event.

The ascii is currently delimited by the pipe (|) with no enclosing quotes on
the fields. CRLF defines the start of a new record. It is output by a third
party program. I can change the delimiter and quotes inside the program
prior to output.
Ex.
197330|AY|20001211|25|88|20001211|Fall|2001|Li|Benhig19710706|Beijing,Ch
ina|Male|[EMAIL PROTECTED]|61|||214||DongYingFang
907-5-9|DongGaoDi|Beijing||61|100076|20101231||DongYingFang
907-5-9|DongGaoDi|Beijing||61|100076|DongYingFang
907-5-9,DongGaoDi|Beijing||61|100076|20011231|||235|numerical
analysis|Ph.D.|1||Full Time|||ErPao Institute of
Technology|09/88|07/92|BS|07/92|3.5|ErPao Institute of
Technology|09/93|03/96|MS|03/96|3.4|Automatic
Control Engineering|3.5|4.0|Aerocraft Control,Guide and Simulatio;MS||Other
(specify
below)|English|12/99|480|54|800|99|730|9108/00|643|||Liao|Professor.Grad
uate Adviser|ErPao Institute of Technology|Zhang|Professor,Graduate
Adviser|Capital Normal University|Ke|Professor,PhD|National Natural
SciChinese Academe of Launch Vehicle
Tech.|Beijing|04/96|08/00|Engineer|

I can read it into a textarea field with no problem using CFFILE. I can even
do a simple ListLen to get the number of records in the file. Works fine so
far.



The import list contains #ListLen(AIMxport, "#cr#")# records.



Next I submit this to the processing page.
Ex.









Main List Element #id# - Test ListGetAt function to get individual lines
in the big list.


List length #id#: #ListLen(fulllist, "|")#
#id# - #fulllist# 


Main List Element #id# - Test Getting Individual Field Elements in the
list








#fieldid# - #ListGetAt(fulllist, "#fieldID#",
"|")#










So far I can run the above and it all prints fine. Each full record appears
in the top and then a list of fields appears below it.

PROBLEM
Missing fields. I cannot figure out how to make the list function show
fields that contain no data. It just seems to drop them, they do not appear
in the output. I have tried ListQualify and that does not seem to help. Am I
missing something here? Do lists not include the blank fields. The first
record runs and shows 92 total fields (ListLen) the next record runs and
shows only 67 fields. The second record has less data filled in by the user.
I can see all of the fields in the input side. Frustrating the heck out me.
Any better way to do this?

Regards,

Gary McNeel, Jr.
DACNet Project Manager
Research and Graduate Studies
Rice University
[OP] 713-348-6266
[M] 713-962-0885
[HO] 713-723-9240


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

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

HELP: List questions...

[Gary McNeel, Jr.]

I am working with ascii delimited data, trying to read them into a SQL
Server table through a web browser interface. After it is all working I want
to convert it to a scheduled event.

The ascii is currently delimited by the pipe (|) with no enclosing quotes on
the fields. CRLF defines the start of a new record. It is output by a third
party program. I can change the delimiter and quotes inside the program
prior to output.
Ex.
197330|AY|20001211|25|88|20001211|Fall|2001|Li|Benhig19710706|Beijing,Ch
ina|Male|[EMAIL PROTECTED]|61|||214||DongYingFang
907-5-9|DongGaoDi|Beijing||61|100076|20101231||DongYingFang
907-5-9|DongGaoDi|Beijing||61|100076|DongYingFang
907-5-9,DongGaoDi|Beijing||61|100076|20011231|||235|numerical
analysis|Ph.D.|1||Full Time|||ErPao Institute of
Technology|09/88|07/92|BS|07/92|3.5|ErPao Institute of
Technology|09/93|03/96|MS|03/96|3.4|Automatic
Control Engineering|3.5|4.0|Aerocraft Control,Guide and Simulatio;MS||Other
(specify
below)|English|12/99|480|54|800|99|730|9108/00|643|||Liao|Professor.Grad
uate Adviser|ErPao Institute of Technology|Zhang|Professor,Graduate
Adviser|Capital Normal University|Ke|Professor,PhD|National Natural
SciChinese Academe of Launch Vehicle
Tech.|Beijing|04/96|08/00|Engineer|

I can read it into a textarea field with no problem using CFFILE. I can even
do a simple ListLen to get the number of records in the file. Works fine so
far.



The import list contains #ListLen(AIMxport, "#cr#")# records.



Next I submit this to the processing page.
Ex.









Main List Element #id# - Test ListGetAt function to get individual lines
in the big list.


List length #id#: #ListLen(fulllist, "|")#
#id# - #fulllist# 


Main List Element #id# - Test Getting Individual Field Elements in the
list








#fieldid# - #ListGetAt(fulllist, "#fieldID#",
"|")#










So far I can run the above and it all prints fine. Each full record appears
in the top and then a list of fields appears below it.

PROBLEM
Missing fields. I cannot figure out how to make the list function show
fields that contain no data. It just seems to drop them, they do not appear
in the output. I have tried ListQualify and that does not seem to help. Am I
missing something here? Do lists not include the blank fields. The first
record runs and shows 92 total fields (ListLen) the next record runs and
shows only 67 fields. The second record has less data filled in by the user.
I can see all of the fields in the input side. Frustrating the heck out me.
Any better way to do this?

Regards,

Gary McNeel, Jr.
DACNet Project Manager
Research and Graduate Studies
Rice University
[OP] 713-348-6266
[M] 713-962-0885
[HO] 713-723-9240


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

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

Printing to User printers...

[Gary McNeel, Jr.]

I have looked on the developer exchange at Allaire and had no luck.

I would like to find a tag (or other way) that would allow me to print to
the users printer. Here is the scenario I envision.

1. The user wants to print acceptance letters. This is tracked in our system
by an Admit function. In this case there are 20 letters.
2. They go to the correspondence page and select 'Print Acceptance Letters".
3. A moment later their printer fires up and begins printing 20 letters
generated from the database.

I know I can do this with Perl, we do it know. We have a form button on the
page that calls a CGI function that sends the form fields to another secure
server. It requires a password to print to the printer. There it is routed
via IP address to the printer queue. This is hard coded at the time. I would
have each department designate a printer IP and use that at runtime to make
it dynamic.

Is there any way to do this with CF? Some way that, if the user knew the
printer IP they wanted to print to, you could print to it?

TIA and have a great weekend all.

Gary McNeel, Jr.
Project Manager - DAC-Net, Research & Graduate Studies
Rice University - Houston
[Lovett Hall] 713-348-6266 (Primary)
[DAC] 713-348-5184
[M] 713-962-0885
[H] 713-723-9240
http://dacnet.rice.edu/DAC-Net/Staff/Gary/

"Great spirits have always encountered violent opposition from mediocre
minds."
   -Albert Einstein

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

RE: (OT) making fields readonly with JavaScript

[Gary McNeel, Jr.]

Just FYI. We did use Javascript to do this (similar to code below). It
worked fine in IE 4+, intermittent problems in Netscape 4+. Also, we found
that people would turn off Javascript (for whatever reason) and whamo, no go
on keeping them out. So if you are counting on this for some security reason
or other process, make sure to first check for Javascript support and then
not let them into the page if they do not have javascript enabled.

-Gary

> -Original Message-
> From: Jason Powers [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 31, 2000 9:52 AM
> To: '[EMAIL PROTECTED]'
> Subject: RE: (OT) making fields readonly with JavaScript
>
>
> Jamie,
>   Shouldn't it be possible for you to use the blur() method to force focus
> off of that text box?  Like this:
> 
> to take focus off of that field, or
> 
> to focus on another element, which would actually be rather confusing for
> the user.
> If that doesn't work, you might be able to do something like this:
> var myval;
> 
> to replace the value in the field with its previous value.
>
> -Original Message-
> From: Jamie Keane [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 31, 2000 9:51 AM
> To: CFTalk
> Subject: (OT) making fields readonly with JavaScript
>
>
> Hi all, and I apologise for being off-topic, but this is driving me nuts!
>
> Is there a way to "disable" text field via JavaScript?  I know of the
> READONLY attribute, and the client likes how that works, but in
> my research
> I was not able to come up with a way to access that attribute through JS.
> Any ideas?
>
> Thanks,
> Jamie
>
> --
> Jamie Keane
> Programmer
> SolutionMasters, Inc.
> 9111 Monroe Rd., Suite 100
> Charlotte, NC  28270
> www.solutionmasters.com
> 704.563.5559 x 228  Voice
> 704.849.9291  Fax
>
> --
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

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

RE: MS Access V.S. SQL

[Gary McNeel, Jr.]

Hello Chad.

Here at Rice we use Access for a lot of our simple sites. We have some DBs
hold over 60,000 (yes, thousand) records with no problems. Our user load is
low on these though, only 3-4 people working with them at any given moment.

We do have some that have about 10-20 thousand records that only viewable to
people on the web, just used for reporting. Sorry, no stats on usage, but no
complaints either.

Personally, I only use SQL. It is fast and flexible for developing,
especially if you are doing it remotely (Enterprise Manager works great for
me). Granted, I am not nearly as sophisticated as some of the people here,
but our stuff does the job, pretty much with little or no problems.

-Gary

> -Original Message-
> From: Chad [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 30, 2000 12:05 PM
> To: [EMAIL PROTECTED]
> Subject: MS Access V.S. SQL
>
>
> How many records can MS Access handle safely?  Im looking at a
> project that
> may be around 10,000 Records.
>
> Are there other specific database needs that demand making the leap to a
> SQL server?
>
>
>
> Thanks
> Chad
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

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

RE: cfcontent uncertainty

[Gary McNeel, Jr.]

Where can you find really good information about CFHEADER and the type of
values that can be used in the attribute fields (NAME and VALUE)? Like
value="inline;filename="mydocument.doc".

Thanks.

-Gary

> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 24, 2000 12:15 PM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: RE: cfcontent uncertainty
>
>
> > 
> > this is a test
> >
> > I don't know what the significance of using that cfcontent
> > is, but I threw it in there. I also tried the page without
> > the cfcontent, and it results in a blank page with no source.
>
> The CFCONTENT tag tells the browser what MIME type the document is. By
> default, output generated by CFML is the MIME type text/html.
>
> The filename attribute in CFHEADER should just be the name of the file,
> without path information. This file name is the name that the browser will
> use to reference the file.
>
> When I clicked on the link, it worked fine, except that it didn't
> prompt me
> to save the file as "ACF116.doc", but rather as "test2.cfm". It did prompt
> me to save the file, though, and the saved file contained the
> text "this is
> a test", as it should.
>
> However, in your example earlier, I thought you were trying to download an
> existing file to the browser, rather than generate a new file dynamically.
> Here's how you'd do that, if your file was "d:\attachments\acf116.doc":
>
> 
> 
>
> This would retrieve the file from the attachments directory, and
> prompt the
> user to save it as mydocument.doc.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
>
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

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

RE: Dates

[Gary McNeel, Jr.]

...or 

> -Original Message-
> From: Hinojosa, Robert [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 24, 2000 11:59 AM
> To: '[EMAIL PROTECTED]'
> Subject: RE: Dates
>
>
> yes
>
> Robert Hinojosa
> WebDeveloper
> 512.912.3775
> [EMAIL PROTECTED]
> www.cirrus.com
>
> -Original Message-
> From: Peter Benoit [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 24, 2000 10:22 AM
> To: '[EMAIL PROTECTED]'
> Subject: Dates
>
>
> If I use this?
>
> 
> 
>
> Will months with 2 digits appear with 2 digits?  IE 10/10/00?
>
> thanks,
> Pete
>
> --
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

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

RE: Mail Servers?

[Gary McNeel, Jr.]

Mercury Mail Transport. We run it here. No problems. Works fine on NT. Free
to cheap.

http://www.pegasus.usa.com

-Gary

> -Original Message-
> From: Neil Middleton [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 23, 2000 10:39 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Mail Servers?
>
>
> I think it could be,
>
> try www.sendmail.org
> --
> Neil Middleton
> Technical Director
> Stez Media
> 01737 212282
>
> - Original Message -
> From: JustinMacCarthy <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, August 23, 2000 4:20 PM
> Subject: Re: Mail Servers?
>
>
> > Free ? Surely not on NT ...
> >
> > ~Justin
> >
> > - Original Message -
> > From: "Neil Middleton" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Wednesday, August 23, 2000 4:02 PM
> > Subject: Re: Mail Servers?
> >
> >
> > > lets see, a good cheap mail server?
> > >
> > > Seems you'll be wanting sendmail, it's superb and above all FREE.
> > >
> > > --
> > > Neil Middleton
> > > Technical Director
> > > Stez Media
> > > 01737 212282
> > >
> > > - Original Message -
> > > From: Kelly Matthews <[EMAIL PROTECTED]>
> > > To: <[EMAIL PROTECTED]>
> > > Sent: Wednesday, August 23, 2000 2:58 PM
> > > Subject: Mail Servers?
> > >
> > >
> > > > Are there any GOOD yet not too expensive mail servers out there? We
> > > > currently
> > > > have exchange no matter what we do we cant get CF to work with
> exchange
> > as
> > > > long
> > > > as Relaying is shut down.  So we wanted to install another
> mail server
> > for
> > > > CF
> > > > that can bypass exchange. Meaning we dont want a mail server, like
> some,
> > > > that still
> > > > POINTS to another mail server. We want a mail server that
> can send out
> > > SMTP
> > > > mail on it's own, i dont care about receiving mail. Any
> recommendations?
> > > > Kelly
> > > >
> > > > Stay current with what's happening on AirportNet. Subscribe to our
> > > > Announcement list today: http://www.airportnet.org/email.htm
> > > >
> > > > ---
> > > > Kelly Matthews
> > > > Internet Development Coordinator
> > > > AAAE
> > > > 703.578.2509
> > > > [EMAIL PROTECTED]
> > > > http://www.airportnet.org
> > > > ---
> > > >
> > >
>
>
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

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

RE: CFLOCK and server variables

[Gary McNeel, Jr.]

Yes. That is how you tell the application you want them enabled. -Gary

> -Original Message-
> From: Jake Hileman [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 18, 2000 7:01 PM
> To: [EMAIL PROTECTED]
> Subject: Re: CFLOCK and server variables
>
>
> do you have to use application.cfm to use session variables?
>
> jake
> - Original Message -
> From: "Bud" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, August 18, 2000 9:00 AM
> Subject: RE: CFLOCK and server variables
>
>
> > On 7/13/00, Dave Watts penned:
> > >  > The also recommend  when locking
> > >>  session vars; do you agree, or if not, what do you recommend?
> > >
> > >No, again, this causes the same problem. You want a unique
> name to apply
> to
> > >an individual session, but you don't want to store it in a session
> variable.
> > >If you're using CF's cookies for state management, you could do this:
> > >
> > >
> >
> > OK. I'm still having a hard time getting a grasp on this (so, what
> > else is new?).
> >
> > I thought the whole idea of naming a lock was so nobody else would be
> > able to read or write to that memory space and it would lock other
> > users out based on the name of the lock.
> >
> > So, if I'm setting a session variable named "total":
> >
> > 
> >
> > If I lock that cfset and name the lock #Cookie.CFID##Cookie.CFTOKEN#,
> > won't that mean that anyone else would still be able to write to
> > session.total and session.subtotal seeing as how using that method
> > everyone would have the same lock named differently? I mean, why name
> > a lock if every user has the lock named differently? Won't ColdFusion
> > look and see if a lock by that name is being written and if it's not,
> > go ahead and write it?
> >
> > And a question about names across different application, or even the
> > same application, but named differently:
> >
> > When accessing or writing an application or session variable, does
> > the danger lie only within duplicate named variables within the same
> > application? Or across the whole server? Example:
> >
> > I have 3 instances of my shopping cart on a server which uses the
> > session variable "session.total", all 3 with the application name
> > unique (I always name the application the same name as the main
> > datasource of the app so there's no chance I can accidentally name 2
> > applications the same). Joe Blow has his totally different shopping
> > cart and it also uses a session variable of "session.total".
> >
> > If none of these were locked, and there is a single user using each
> > shopping cart, and each cart has a diffent application name, and they
> > are all writing a session.total at the exact same time, is there a
> > danger in that? Or would there only be a danger if 2 people were
> > writing to session.total in the SAME NAMED APPLICATION at the same
> > time?
> >
> > If it's based upon the session variable name across the server and
> > not within an application, then there's no way of knowing that you
> > could ever have a uniquely named lock. I am HOPING it's based on the
> > name in cfapplication.
> >
> > And one more question:
> >
> > If you are locking all session variables with the same name by using
> > a unique local variable, will that cause all writing to all sessions
> > to be postponed until the lock is released?
> >
> > For instance, I have these 2 cfsets:
> >
> > 
> > 
> > 
> >
> > 
> > 
> > 
> >
> > Would the second query be locked out while the first is being written
> > since the locks are named the same (even though they are accessing
> > different session variables)? If so, then it seems like it would be
> > detrimental to name any 2 locks the same that don't contain
> > references to the same session variable. I'm assuming this is the
> > case.
> >
> > I'm hoping this will clear things up for me once and for all. I read
> > BF's CFLOCK article in CFDJ and although it was a little useful,
> > there was really no clear cut explanation about what happens across
> > different applications on the server. Sadly, that is what the
> > majority of us are faced with. I have alot of copies of the same
> > application running on my server and if I need to lock session.total
> > with the same name on all instances of the application to stop all
> > users from writing to session.total no matter what application it is
> > in, then that's REALLY going to be a performance hit. If I can at
> > least name the lock different on each copy of the application, and
> > not worry about a user writing to session.total on application A
> > while other users are writing to session.total on applications B, C,
> > D, and E, that would be somewhat helpful.
> >
> > I hope somebody understood that. LOL
> > --
> >
> > Bud Schneehagen - Tropical Web Creations
> >
> > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> > ColdFusion Solutions / eCommerce Development
> > [EMAIL PROTECTED]
> > http://www.twcreations.com/
> > 954.721.3452
> >
> -

Working with a string...

[Gary McNeel, Jr.]

I have an email address sting that I need to manipulate.

I need to just get the first part before the @ symbol and discard the rest
(although knowing how to grab it might be useful too). Is the only way to do
a regular expression?

Ex. [EMAIL PROTECTED] would become gmcneel (maybe in a variable).

TIA

Gary McNeel, Jr.
Project Manager - DAC-Net, Research & Graduate Studies
Rice University - Houston
[Lovett Hall] 713-348-6266 (Primary)
[DAC] 713-348-5184
[M] 713-962-0885
[H] 713-723-9240
http://dacnet.rice.edu/DAC-Net/Staff/Gary/

"Great spirits have always encountered violent opposition from mediocre
minds."
   -Albert Einstein

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

RE: congratulations Daddy Camden

[Gary McNeel, Jr.]

Congrats

> -Original Message-
> From: Jennifer [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 31, 2000 12:55 PM
> To: [EMAIL PROTECTED]
> Subject: congratulations Daddy Camden
>
>
> I don't know if you guys have been informed yet, but congratulations to
> Raymond Camden on the adoption of his perfect baby boy. He's finally here!
>
> http://www.camdenfamily.com/jacob/arrival/
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
> _talk or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.
>

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

RE: CV/Resume Project Descriptions

[Gary McNeel, Jr.]

Hello Jamie.

While I am not involved in HR, I have hired (and yes, fired) many people
over the years.

On a resume, you really don't want to "describe" your work, just your
knowledge and accomplishments (which, when you are in school, may be just
beginning). Use the resume to entice the prospective employer to contact
you. You only have a few minutes to catch their attention. Pretty soon there
is no way in heck you could list all your work, except as an addendum
available on request. Make it functional, like:

It should be bulleted if you are young, paragraphs as you get more
accomplished.

Ex.
(beginning version)
* Designed, managed and completed several campus-wide, dynamic, web-based
applications (list available on request).
* Familiar with Transact-SQL and PL/SQL on Microsoft SQL Server and Oracle.
(this could go in a 'Skills' section at the end too)
* Worked with departments to implement campus-wide support systems on the
web. These are dynamic. Etc, etc.

(this is the more accomplished version)
Responsible for development and oversight of a 25 person engineering and
development time covering a range of disciplines including yada, yada.



As you get older (or rather grow in knowledge and accomplishments, you may
be a 75 year old undergrad for all I know ;)) your resume will change.

Keep it short, no more than one page.

Focus a little on your schooling for now. That has consumed most of your
time to date. Tell how you worked your way through school by doing this
development.

Ex:
* 40% of tuition earned doing dynamic web development.

Try not to use the word "I". Almost think in the 3rd person.

Instead of:

I have done this or that.

   Go with

Have done this or that.

Just some thoughts.


Gary McNeel, Jr.
Project Manager - DAC-Net, Research & Graduate Studies
Rice University - Houston
[Lovett Hall] 713-348-6266 (Primary)
[DAC] 713-348-5184
[M] 713-962-0885
[H] 713-723-9240
http://dacnet.rice.edu/DAC-Net/Staff/Gary/

"Great spirits have always encountered violent opposition from mediocre
minds."
   -Albert Einstein



> -Original Message-
> From: Jamie Symonds [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 31, 2000 12:42 PM
> To: [EMAIL PROTECTED]
> Subject: CV/Resume Project Descriptions
>
>
> Hello - I'm updating my resume since I've become familiar with
> ColdFusion.  I have worked independently on two projects for my
> university - one for storing, retrieving and updating survey data from
> faculty members, and a second project for the Students' Union, a message
> board of sorts where students can post textbooks for sale or trade and
> have them sorted by programme, course, etc.  Sorry for rambling here,
> but I'm curious as to how I describe these two projects on my Resume for
> prospective employers?  I'm sure some of you out there are involved in
> HR with your organization and can tell me what you specifically look
> for.  MANY THANKS!!  It's really appreciated.
>
> -Jamie
> Bachelor of Information Systems student, St. Francis Xavier University
>
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

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

RE: Date subtraction

[Gary McNeel, Jr.]

Sure ... if we had all of the thread.

There would be NO thread if we all waited to see who sent back a reply
first. Look at the times, about a 10-15 minute time span.

(no flame intended)

-Gary McNeel

> -Original Message-
> From: Reynolds, Adam [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 31, 2000 10:39 AM
> To: '[EMAIL PROTECTED]'
> Subject: RE: Date subtraction
>
>
> Could everybody please read to the end of a thread before replying? Rather
> than repeating the same answer over and over again.
>
> (No flame intended)
>
>
> Adam Reynolds
>
>
> **
>  This email and any attachments are confidential and solely
>  for the use of the intended recipient.  They may contain
>  material protected by legal professional or other privilege.
>  If you are not the intended recipient or the person responsible
>  for delivering to the intended recipient, you are not authorised
>  to and must not disclose, copy, distribute or retain this email
>  or its attachments.  Although this email and its attachments
>  are believed to be free of any virus or other defect, it is the
>  responsibility of the recipient to ensure that they are virus free
>  and no responsibility is accepted by the company for any
>  loss or damage arising from receipt or use thereof.
>
> **
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

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

RE: CFLOCKs.... is this really necessary?

[Gary McNeel, Jr.]

Sure, go to:

http://www.hcfug.com/


-Gary McNeel



> -Original Message-
> From: Ann Harrell [mailto:[EMAIL PROTECTED]]
> Sent: Friday, July 28, 2000 10:26 AM
> To: '[EMAIL PROTECTED]'
> Subject: RE: CFLOCKs is this really necessary?
>
>
> I just joined the list today. I would be interested in viewing the entire
> thread if anyone has it.
>
> Thanks!
>
>Ann Harrell
>   Tech Support Engineer
>
>
> -Original Message-
> From: Zachary Bedell [mailto:[EMAIL PROTECTED]]
> Sent: Friday, July 28, 2000 10:18 AM
> To: '[EMAIL PROTECTED]'
> Subject: RE: CFLOCKs is this really necessary?
>
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> > > *shudders*  Don't get me started on Allaire's documentation.
> > > We're considering starting our own internal errata list for our
> > > developers
> > >
> >
> > Maybe you could publish this for the rest of us, if you do it.
>
> If I ever do quantify it, I'll be sure to pass it on.  At the moment,
> it's just a bunch of bad experiences sitting in the collective brains
> of my programming team.  One of these days, I'll have to sit everyone
> down & see what we can think of off the top of our heads...
>
> Later,
> Zac Bedell
>
> -BEGIN PGP SIGNATURE-
> Version: PGPfreeware 6.5.3 for non-commercial use 
> Comment: Please use PGP!!!
>
> iQA/AwUBOYGkHwraVoMWBwRBEQI5+gCg54CBMkITaXMmyCKVb7TJaFVGG/8AoN+A
> txcf745yANZ6njJpvR5sf3WF
> =iO5e
> -END PGP SIGNATURE-
> --
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

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

RE: do stored procedures REALLY help performance?

[Gary McNeel, Jr.]

One of our programmers got good at, and we are now using, Transact/SQL
(T-SQL) to great advantage. Stored procedures probably do speed things up,
make it easier to correct or extend a commonly called procedure, etc. He
found, for us anyhow, that it is easier to pass variables and such around
using CF vs. passing them into the SQL server. It just saves development
time. We often store queries in includes and call them as needed, so changes
are not a big problem.

-Gary

> -Original Message-
> From: Robert Everland [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 27, 2000 9:39 AM
> To: '[EMAIL PROTECTED]'
> Subject: RE: do stored procedures REALLY help performance?
>
>
> What I have found that if you do a stored procedure in a loop it
> defeats the
> whole purpose of a stored procedure becuase you are doing the
> query over and
> over again. Though just in theory it would work faster because instead of
> cfquery building your query it would already be built for you. I figure it
> would work better with inner and outer joins, the more
> complicated the query
> the better the performance difference. I have never heard anyone say that
> stored procedures give CF worse performance. Do some testing
> yourself. Take
> some queries that take a long time and convert them over to stored
> procedures and see what happens, can't hurt.
>
>
> Robert Everland III
> Web Developer
> Dixon Ticonderoga
>
>
> -Original Message-
> From: Mike Amburn [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 27, 2000 10:20 AM
> To: Cf-Talk
> Subject: do stored procedures REALLY help performance?
>
>
> one of our senior developers is vehemently arguing against stored
> procedures, saying that in his testing he has found that stored procedures
> either perform equal or worse than CFQUERYs.
>
> can anyone provide actual data to support stored procedures over CFQUERYs?
>
> -mike
>
> --
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

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

RE: Calling SQL Server/NT gurus...

[Gary McNeel, Jr.]

Look in the SQL Books Online. Search on 'Server Memory Options'. This gives
a pretty good overview of what is happening. For most purposes you want to
let SQL server handle the memory configuration.

Did you change yours?
Are you setting it manually?
Are you doing full-text searching?

-Gary

> -Original Message-
> From: Robert M. Saxon, Jr. [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 26, 2000 5:11 PM
> To: Cf-Talk
> Subject: Calling SQL Server/NT gurus...
>
>
> I have a SQL Server 7 machine with 1 1/8 GB of memory.  After some
> performance problems, I confirmed that SQL Server had allocated all but
> about 50 MB of the memory for itself. The server is set to
> allocate anywhere
> from half a gig to all of the memory.  I have some questions:
>
> Is this the optimum configuration for this system?
> Is there a way to prevent this from reoccurring?
> Is there a way to cause SQL Server to release memory once it is allocated
> without restarting the system?
>
> If anyone can shed light on this, I would greatly appreciate it.
>
> Thanks,
>
> Rob
> ___
> Robert M. Saxon, Jr. (Rob), Senior Web Developer
> Mercer University
> Department of Web Management
> TSS // 1400 Coleman Avenue // Macon, GA 31207
> 912-301-5550 voice // 912-301-5314 fax
> [EMAIL PROTECTED]
> Philippians 4:13
>
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

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

RE: Authorize.net or.......

[Gary McNeel, Jr.]

I (and some of my colleagues) have had very good luck with AuthorizeNet.
Easy to setup and configure. I have not seen a good, updated CF custom tag
lately though.

-Gary McNeel

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 24, 2000 5:04 PM
> To: [EMAIL PROTECTED]
> Subject: Authorize.net or...
>
>
> Hi All,
>
> We're considering dropping our in-house ICVerify server (CyberCash has
> bought and dropped that product, and will no longer support it after
> March '01), and moving to Authorize.net or something similar. I was just
> quoted a $20/mo base, 2.3% discount rate and 30 cent per transaction
> fee, with about $300 in up-front fees, from Authorize.net, and all in
> all that doesn't sound too bad if it makes my life more headache-free. I
> will also gladly live without the 20-second modem delays on the answers.
>
> So, if anyone has any strong opinions on Authorize.net, or other
> suggestions of real-time transaction clearing, please email me off-list
> at mailto:[EMAIL PROTECTED].
>
> tia,
> Ron
>
>
>
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

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

CFIF question...

[Gary McNeel, Jr.]

can you use BETWEEN or maybe IN in a cfif?

ex: do something
ex: do something

Is there a better, faster way to do this?

Thanks.

Gary McNeel, Jr.
Project Manager - DAC-Net, Research & Graduate Studies
Rice University - Houston
[Lovett Hall] 713-348-6266 (Primary)
[DAC] 713-348-5184
[M] 713-962-0885
[H] 713-723-9240

"Great spirits have always encountered violent opposition from mediocre
minds."
   -Albert Einstein

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

Forms question

[Gary McNeel, Jr.]

Is there a way to nest forms?

Ex.




   

  
   




I know I can to this programmaticly with CF by looking at values, was hoping
for a faster way.

TIA

Gary McNeel, Jr.
Project Manager - DAC-Net, Research & Graduate Studies
Rice University - Houston
[Lovett Hall] 713-348-6266 (Primary)
[DAC] 713-348-5184
[M] 713-962-0885
[H] 713-723-9240

"Great spirits have always encountered violent opposition from mediocre
minds."
   -Albert Einstein

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

RE: CFLOCK and Client Variables

[Gary McNeel, Jr.]

You may also want to get the book "Mastering Cold Fusion 4" by Danesh and
Motlagh. I has a pretty good section on using this and several other tags
that are not as well covered in Mr. Forta's books (which I have all of too
;)).

Each of the authors cover things with different styles, and as a CF
non-programmer type (regular expressions - we don't need no stinking regular
expressions) they both have helped me tremendously.


Gary McNeel, Jr.
Project Manager - DAC-Net, Research & Graduate Studies
Rice University - Houston
[Lovett Hall] 713-348-6266 (Primary)
[DAC] 713-348-5184
[M] 713-962-0885
[H] 713-723-9240

"Great spirits have always encountered violent opposition from mediocre
minds."
   -Albert Einstein

> -Original Message-
> From: Cameron Childress [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 13, 2000 9:57 AM
> To: [EMAIL PROTECTED]
> Subject: RE: CFLOCK and Client Variables
>
>
> > Where is the best reading on CFLOCK and Session/Applicaiton/Server
> > variables?
>
> A lot of people don't look there, but the Allaire Knowledge Base has a
> wealth of information and data on configuration and usage.  The following
> article would probably help you out a great deal:
>
> http://www.allaire.com/Handlers/index.cfm?ID=14165&Method=Full
>
> -Cameron
>
> 
> Cameron Childress
> McRae Communications
> p. 770-460-7277 x.232
> f. 770-460-0963
>
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

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

RE: CF And Outlook Address Book

[Gary McNeel, Jr.]

Are you using Exchange Server and connecting with Outlook? You could Export
your data from Exchange or Outlook (install the Export tools) and import
into a database. That is how we did it, but data is static and needs to be
dumped often. Was a quick fix. There may be a COM or DCOM way to tackle it.
Anyone have any ideas?

-Gary McNeel

> -Original Message-
> From: Claremont, Timothy S [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 12, 2000 10:08 AM
> To: [EMAIL PROTECTED]
> Subject: CF And Outlook Address Book
>
>
> Does anyone on the list know of a tag that will allow me to use the
> Microsoft Outlook address book in my applications?
>
> I want end users to be able to search the address book for names and phone
> numbers, more than for the email addresses. Can I pull what amounts to a
> phone directory out of the Outlook address book?
>
> Tim
>
> 
> Tim Claremont
> Xerox Corporation
> 
>
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

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

RE: Cookies

[Gary McNeel, Jr.]

Or set a quick session variable, do the CFLOCATION and then convert the
variable to a COOKIE, then delete the session variable on the CFLOCATIONed
page. Works for me. Not sure in really high traffic site.


Gary McNeel, Jr.
Project Manager - DAC-Net, Research & Graduate Studies
Rice University - Houston
[Lovett Hall] 713-348-6266 (Primary)
[DAC] 713-348-5184
[M] 713-962-0885
[H] 713-723-9240

"Great spirits have always encountered violent opposition from mediocre
minds."
   -Albert Einstein

[snip]

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

RE: RE: What are you using instead of IDENTITY?

[Gary McNeel, Jr.]

Man, am I glad I am not a DBA and let myself get constrained by hypothetical
arguments. We have old databases here that did NOT use an IDENTITY field.
Man, what a mess that has been.

Example: For years the KEY to a manila file folder was the date and the
number of applications done that day. This was the offices' procedure, told
people what was in the file folder. So you had 99062301 for 1999 (year),
06(month), 23(day), 01(number sequence for that day). This was the primary
key and was stored in a numeric (Access) field. They then used this for
foreign keys. Guess what happened? Y2Kish issue. Numeric fields truncated
the leading zeros and was that a mess. 00010101 became 10101, etc.

This site is being completely redesigned (there were many more issues here,
it was quasi-relational, lot of duplicate data, etc.)

I have used IDENTITY fields for many years and have encountered NO problems.
The problems I have encountered are when a User uses the IDENTITY as part of
the data for the record, for instance John Doe is record 6. Now, when you
export and append this to another table, boom, the IDENTITY is hosed. There
are ways around this, but you get the idea.

I don't know, from my perspective you just can't beat IDENTITY fields (but
maybe I am looking down from the edge of a penny (dime?)). ;)

OK, back to the Moody Blues and some CF coding.

-Gary McNeel


> -Original Message-
> From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, July 11, 2000 12:55 PM
> To: [EMAIL PROTECTED]
> Subject: RE: RE: What are you using instead of IDENTITY?
>
>
> For awhile I tried to avoid using IDENTITY columns in the name of
> theoretical "best practices."  However, it seemed to cause quite a few
> problems in regards to data storage (whatever ended up as the primary key
> was invariably larger and more cumbersome than an integer field) and
> terribly difficult to update (e.g. foreign key constraints needed to be
> dropped before updating data in the primary key field and recreated
> afterwards).  In addition, the abstraction of the PRIMARY KEY
> from the data
> works towards normalizing (not "normalizing" in the sense of
> relational data
> but in the lay sense) database design, layout and implementation.  On the
> other hand, avoiding IDENTITY columns didn't fix any practical problems.
> For these reasons, I've reversed my position and include IDENTITY
> columns on
> most tables that require a primary key.
>
> Benjamin S. Rogers
> Web Developer, c4.net
> voice: (508) 240-0051
> fax: (508) 240-0057
>
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

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

RE: (Admin) Re: List wierdness ... again

[Gary McNeel, Jr.]

LOL. Someone needs to teach Michael how to use his email program. -;)

> -Original Message-
> From: Michael Dinowitz [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 10, 2000 3:10 AM
> To: [EMAIL PROTECTED]
> Subject: Re: (Admin) Re: List wierdness ... again
>
>
> Whoops. Thought that was going private.
>
> > Thanks for the feedback. :)
> >
> > > Hello Michael,
> > > I like to take the opportunity and
> > > thank you for your great work keeping this list up and running for
> > > the CF-Community.
> > > For my part I am really glad that this list exists and haven't
> > > really encountered a bit inconvenience. I hardly noticed that
> > > there are troubles now and then;-)) This comes with the enormous
> > > traffic this list has, and it is running, and running and running.
> > >
> > > Thanks to you!
> > >
> > > Birgit
> > >
> > >
> > >
> > >
> > > Sunday, July 09, 2000, 12:04:46 PM, you wrote:
> > >
> > > > We had a really bad series of bouncebacks that caused some routing
> > issues
> > > > with the list. Rather than let the problem persist,  I
> removed all the
> > email
> > > > from the spool and let it run 'fresh'. Last night I returned all the
> > removed
> > > > email so it wouldn't lose anything. The result was a few duplicate
> > messages
> > > > for some people and a delay for the messages in question. It's all
> fixed
> > and
> > > > working well now. Sorry for the inconvenience.
> > >
> > >
> > > >> I just love my e-mail program's feature:
> > > >> 'Kill duplicates'
> > > >>
> > > >> Wednesday, June 14, 2000, 2:43:20 PM, you wrote:
> > > >>
> > > >> > I am starting to randomly recieve multiple copies of postings ...
> > > > sometimes
> > > >> > days apart. I have looked at the headers in all cases and the
> > messages
> > > > are
> > > >> > exactly the same ... content, sender, date/time sent, everything.
> > What
> > > > the
> > > >> > heck is going on? Is Mike running a 'proper' listserver or some
> > > > homegrown CF
> > > >> > app?
> > > >>
> > > >> > Steve
> > > >>
> > > >>
> > >
> >
> >>
> -
> > -
> > > > 
> > > >> > Archives: http://www.eGroups.com/list/cf-talk
> > > >> > To Unsubscribe visit
> > > >
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> > or
> > > > send a message to [EMAIL PROTECTED] with
> 'unsubscribe'
> > in
> > > > the body.
> > > >>
> > > >>
> > >
> >
> >>
> -
> > -
> > > > 
> > > >> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > >> To Unsubscribe visit
> > > >
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> > or
> > > > send a message to [EMAIL PROTECTED] with
> 'unsubscribe'
> > in
> > > > the body.
> > > >>
> > >
> > >
> >
> >
> --
> > 
> > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > > To Unsubscribe visit
> >
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> >
> >
>
> --
> 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> >
>
> --

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


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

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

Getting the ID after insert...

[Gary McNeel, Jr.]

Hello all. Hope any of you celebrating 4th of July had a good one.

I have a question about the code below. This was done by a colleague of
mine, he is pretty handy with SQL coding. One of his observations was the
time involved in writing stored procedures and then calling them with
CFSTORPROC. I agree, that discouraged me somewhat in the past, but I knew of
no other way. He put this transact-sql query together and it seems solid,
works well.

My question(s): Have any of you tried this? Any problems? Can anyone see a
potential problem?

Thanks. -Gary McNeel


DECLARE @LookupID char(6)
DECLARE @MembersID char(6)

INSERT INTO tblMemberLkp
(DBAName, ReferredBy )
VALUES
('#Form.DBAName#', '#Form.ReferredBy#')

SELECT @LookupID = @@IDENTITY


INSERT INTO Members
(MemberLkpID)
VALUES
(@LookupID)

SELECT @MembersID = @@IDENTITY


INSERT INTO tblSiteInfo
(BusName, Website, RecStatusID, RecOriginID, MembersID,
PartnerNumber, SourceID, ApplicationDate)
VALUES
('#Form.BusName#', '#Lcase(Form.Website)#', 2, 1, @MembersID,
'#Form.PartnerNumber#', '#Form.SourceID#', getdate())



Gary McNeel, Jr.
Project Manager - DAC-Net, Research & Graduate Studies
Rice University - Houston
[Lovett Hall] 713-348-6266 (Primary)
[DAC] 713-348-5184
[M] 713-962-0885
[H] 713-723-9240

"Great spirits have always encountered violent opposition from mediocre
minds."
   -Albert Einstein

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

RE: return value of Identity Column

[Gary McNeel, Jr.]

There are a couple of ways, some more preferred than others.

Option 1 (Best for Beginners and Learning, can sometimes give erroneous
results)

Perform the insert into the database. My assumption is that you are using an
Identity field, like the Autonumber field in Access or Identity in MS SQL
Server. This gives every record a UNIQUE ID.

Now immediately run a query that gets the MAX (a SQL Aggregate Function) of
the Identity field.
You should enclose this in a simple CFTRANSACTION tag.

So,


INSERT INTO table (field)
VALUES (form.values)



SELECT MAX(ID) as MaxID
FROM table




#get_new_id.MaxID#


That will do it for the easier way and is good for learning.

Option 2 (More inline with larger applications and advance SQL Server - uses
stored procedure. You'll need to read the docs on this one for additional
details that I will not detail here. I have seen no books with good examples
(anyone?). (This example is using MS SQL Server)

Here is the Stored Procedure:***

CREATE PROC sp_insertApplicant

@FirstName varchar(50),
@MiddleName varchar(50),
@LastName varchar(50)

AS

INSERT INTO tblApplicants
(FirstName,
 MiddleName,
 LastName)
VALUES
(@FirstName,
 @MiddleName,
 @LastName)

SELECT ApplicantID = @@IDENTITY

Here is the code in the CFM:














Now you get a result set in the form of a variable called RS1. So, in this
instance we returned the new applicantID, or RS1.ApplicantID. You can use
RS1.RecordCount to see how many records were returned (one in this case) and
RS1.ColumnList for a list of Columns returned (again, one, ApplicantID).

We can use the result, the RS1.ApplicantID, to retrieve the record we just
created.


SELECT *
FROM tblApplicants
WHERE ApplicantID = #RS1.ApplicantID#


If I missed anything or am in error, it was the Martians who made me do it.
I waive all responsibility for my actions (seems to be going around these
days).

This is my favorite and seems pretty fast. Feel free to contact me off list.


Gary McNeel, Jr.
Project Manager - DAC-Net, Research & Graduate Studies
Rice University - Houston
[Lovett Hall] 713-348-6266 (Primary)
[DAC] 713-348-5184
[M] 713-962-0885
[H] 713-723-9240

"The politicians don't just want your money. They want your soul. They want
you to be worn down by taxes until you are dependent and helpless. When you
subsidize poverty and failure, you get more of both."
   -James Dale Davidson

> -Original Message-
> From: Shawn Mirza [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 30, 2000 11:59 AM
> To: [EMAIL PROTECTED]
> Subject: RE: return value of Identity Column
>
>
> I know its an @@id when looking it up in a stored proc
>
> -Original Message-
> From: Jason Zimmerman [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 30, 2000 12:35 PM
> To: Cf-Talk (E-mail)
> Subject: return value of Identity Column
>
>
> Is there a way to return the value of an Identity Column after an insert
> into a SQL db?
>
> Thanks,
> -Jason
> --
> --
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

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

RE: Great list WAS: Unsubscribe

[Gary McNeel, Jr.]

I could not agree with you more, John. I am on several lists and this is BY
FAR the best.

-Gary McNeel, Jr.

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 30, 2000 8:46 AM
> To: [EMAIL PROTECTED]
> Subject: Great list WAS: Unsubscribe
>
>
>
>
> Don Cuniff
>
>  [EMAIL PROTECTED]
> pring.com>cc:
>
>   Subject: RE:
> Unsubscribe
> 06/29/2000
>
> 03:25 PM
>
> Please respond
>
> to cf-talk
>
>
>
>
>
>
>
>
>
>
> Is this the 1st time this list has ever been unified on a topic.
> Don't you
> love it when someone brings out the best is us.
>
> don
>
> = Response
>
> This is not surprising at all to me, Don. I've been monitoring an ASP list
> for the past couple of weeks and the difference is remarkable. On
> the other
> list, they tend to be abrupt, if not rude, very often, more interested in
> displaying what they know than with helping the less experienced among
> them. This list, on the other hand, tends to be very considerate, patient
> and helpful. In addition, the newbie questions on this list tend to be
> better thought out in the first place. And even when they're not, I don't
> recall anyone going out of his or her way to make the newbie feel stupid.
>
> I consider this list to be a great resource.
>
> Regards,
> John Allred
>
>
>
>
>
>
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

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

RE: cf vs php

[Gary McNeel, Jr.]

Maybe it's because I am not a "programmer" per se, but I have found very
little todate to dissuade me from using ColdFusion in favor PHP (or any
other development language).

Granted, there are benefits to PHP, etc. I simply do not have the time to do
all this code writing and custom developing - we just make applications that
work, over 100 to date, all in CF with a small (I mean minute) smattering of
Perl and JavaScript. There is very little we have been unable to accomplish
with CF at a third of the time it takes Perl and other programmers to do the
same.

I often think it is that the "programmers" out there want to protect
themselves, who can blame them. But when I can take a biology or art student
for a summer and having them building simple web-based, database backend
systems in weeks, well, that sells CF to me. For the more advanced users,
the actual full-time staff, we use all of the CF features (scripting, etc.)
and have no problems. We have fairly robust applications running which
handle everything from online application to the university to managing
millions of dollars in sponsored research, proposal and award tracking,
costsharing, passthrus, you name it.

Anyway, my thoughts.


Gary McNeel, Jr.
Project Manager - DAC-Net, Research & Graduate Studies
Rice University - Houston
[Lovett Hall] 713-348-6266 (Primary)
[DAC] 713-348-5184
[M] 713-962-0885
[H] 713-723-9240

"Great spirits have always encountered violent opposition from mediocre
minds."
   -Albert Einstein


> -Original Message-
> From: Dain Anderson [mailto:[EMAIL PROTECTED]]
> Sent: Monday, June 28, 1999 2:40 PM
> To: [EMAIL PROTECTED]
> Subject: Re: cf vs php
>
>
> I found an interesting article on comparison of the two:
>
> http://marc.theaimsgroup.com/?l=php-general&m=95602167412542&w=1
>
> - Original Message -
> From: Adam Cantrell <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, June 28, 2000 2:04 PM
> Subject: cf vs php
>
>
> > I've seen a lot of "cf vs asp" stuff floating around, but I was
> wondering
> if
> > anybody had seen anything about cf vs php.  It seems like it
> would be good
> > scripting language to pick up only because everything you need to run a
> php
> > application is free excluding the minimal amount of hardware you would
> need.
> > It appears to resemble coldfusion more than asp does so I'm wondering if
> > anybody has had any experience with comparing the two.
> >
> >
> --
> 
> > Archives: http://www.eGroups.com/list/cf-talk
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

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

RE: row numbers

[Gary McNeel, Jr.]

Try currentrow. Also tied to recordcount.


#currentrow# #field1# #field2# etc.


> -Original Message-
> From: Douglas Jordon [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 28, 2000 11:19 AM
> To: Cold Fusion List
> Subject: row numbers
> 
> 
> Is there a way to find out which row number any given record is?
> 
> TIA,
> 
> Doug Jordon
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit 
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
> _talk or send a message to [EMAIL PROTECTED] with 
> 'unsubscribe' in the body.
> 
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Selecting one number from a list

[Gary McNeel, Jr.]

I completely agree with Dave. I am currently in the process of redesigning
several important databases that were incorrectly designed in the beginning.
Then tons (tonnes?) of CF code was written to handle the resulting problems
as the database grew. The original designers backed themselves into a
corner. Reporting is a major hassle. Duplicate data is everywhere. They
wrote all kinds of CF stuff to check for duplicates, etc. (which often don't
work correctly). Development time escalated.

At first I was going to look at just fixing the system. After looking at the
CF code and databases I decided to just through it out and start from
scratch. It is the story of "Well, it just started as a simple little ...".

Please, for the love of God Mr. Burns (from one of my favorite Simpson's
episodes), take time to read a good book on RELATIONAL database design.
Keyword RELATIONAL. You will do yourself AND anyone who follows behind you a
really, really huge favor.

-Gary McNeel

> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 27, 2000 11:30 AM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: RE: Selecting one number from a list
>
>
> > > Why are you storing a list of numbers in a varchar field?
> ...
> > I was storing them as a list so one item could be associated
> > with several categories, instead of having to add one for each
> > category. All I want is for an ID to be passed, and if that ID
> > exists within that column, then display it.
>
> This is not the right approach. You'll want to use an
> intersection table, as
> Mark suggested. The point of using an intersection table is to
> allow you to
> easily construct many-to-many relationships within your database. If you
> want to associate one item with many categories, and associate
> one category
> with many items, that's a many-to-many relationship and you'll
> want a table
> between item and category which contains all of the intersections between
> items and categories.
>
> I can't overemphasize the importance of correct database design to the
> success of application development. If you've come to CF from a
> non-programming background, as a lot of people have, you might not have
> learned enough about relational databases. CF makes it very easy to learn
> how to program, but it doesn't supply the knowledge you need to build
> well-designed database applications. The sooner you learn that stuff, the
> better your programming life will be. I can tell you this through my own
> personal experience. I started programming with CF, and didn't know very
> much about database design - and I had lots of problems until I
> buckled down
> and learned how to use a relational database.
>
> To take your situation as an example, there are several potential problems
> with storing lists of foreign keys within a field. If you were to delete a
> category, you'd have to retrieve the list of categories stored within each
> item, modify each list that contains the category to be deleted,
> then update
> those lists. That's a lot of unnecessary work, and doesn't allow the
> database to manage itself, as it can with declarative referential
> integrity
> rules. If you simply wanted to list all of the items within a given
> category, that would require a similar procedure. On the other
> hand, if you
> simply add an intersection table to your database, you can use that to
> perform these operations quickly and efficiently.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
>
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

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

CreateODBCTime question

[Gary McNeel, Jr.]

I have a tiny little schedule program that runs from MS SQL Server. This is
very simple.

In it the user enters an EventDetail, EventDate, EventStartTime and
EventEndTime. The date and time fields in SQL are DateTime datatype.

As I insert or update the records I use a CreateODBCDate for the EventDate
and CreateODBCTime for times. I use CFFORM to validate the date and time
formats.

INSERT QUERY

UPDATE tblGradOrientation
SET
EventDate = #CreateODBCDate(EventDate)#,
EventStartTime = #CreateODBCTime(EventStartTime)#,
EventEndTime = #CreateODBCTime(EventEndTime)#,
EventType = #EventType#,
EventDetail = '#EventDetail#'
WHERE GradOrientationID = #GradOrientationID#


The resulting data looks like this:
GID  EventDate   EventStartTime   EventEndTime EventDetail
EventType
12   08/23/006/20/00 9:00:00 AM   6/20/00 9:50:00 AM
Opening Remarks 1



***
In the output I sort it on first the EventDate, then the start times.

OUTPUT QUERY

SELECT tblGradOrientation.*, EventDate, EventStartTime,
EventType
FROM tblGradOrientation
ORDER BY EventDate, EventStartTime



***
Problem:
Example: When you insert (or update) a record to the system, it shows the
the EventDate in the database as 08/25/00. The times, however, show as
6/20/00 9:00:00 AM and 6/20/00 10:00:00 AM, showing the date the data was
entered. Output is fine at this point if all the data for that EventDate are
entered on the same day (06/20/00).

If someone updates the record on another day, say 06/21/00, the sorting gets
screwy. It now puts all times with the new, updated date in the EventStart
and StopTime fields at the end.

Question:
Is there a simple way to store JUST the time in a DateTime datatype field. I
would have thought that is what CreateODBCTime was for, but apparently not.
Or should I just use a char field for this.

Sorry if this is too much detail or messy. Please feel free to contact me
off-list.

Gary McNeel, Jr.
Project Manager - DAC-Net, Research & Graduate Studies
Rice University - Houston
[Lovett Hall] 713-348-6266 (Primary)
[DAC] 713-348-5184
[M] 713-962-0885
[H] 713-723-9240

"Great spirits have always encountered violent opposition from mediocre
minds."
   -Albert Einstein

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

RE: selecting random record from a database

[Gary McNeel, Jr.]

Thank you Phoebe, but most of the replies I have gotten do not take into
account the deletion of a record, and hence, the broken line of sequential
IDs.

For example (I probably should have included one in the original)

You have a database with 4 records, sequential IDs, 1 through 4:

ID  MemberName
1   Name1
2   Name2
3   Name3
4   Name4

Getting the random record here is easy. Run the query and get the record
count, then do a randrange(1, recordcount), then use that to retrieve a
record. So the recordcount is 4, randrange(1,4), random number generated is,
say 3, now run a query and get record with ID 3.

ex.

SELECT * FROM tblMembers




lets say r = 3 -


SELECT * FROM tblMembers WHERE ID = #r#



#finalrecord.MemberName#


Name3 is the winner!!!



Now let's say we delete record with ID 3. If we ran the above scenario, we
would get no reocrds with an ID of 3 (3 having been deleted but the random
function coming up with the 3 in the range of 1 through recordcount.

At this point you could say IF the RecordCount after the query to get the ID
is 0, then do this all again until you get a random number that is found in
the resulting query, in this case 1,2 or 4 would work.

You could add something to this effect in a loop.
 Then do this all again until we get a
hit.

This is all fine for small, not highly fragmented datasets. I wanted to come
up with a better way to do it, using less processor time, who knows, maybe
it is not significant.

Again, thanks a bunch, I was probably just not that clear in my first post.


Gary McNeel, Jr.
Project Manager - DAC-Net, Research & Graduate Studies
Rice University - Houston
[Lovett Hall] 713-348-6266 (Primary)
[DAC] 713-348-5184
[M] 713-962-0885
[H] 713-723-9240

"The genius of our ruling class is that it has kept a majority of the people
from ever questioning the inequity of a system where most people drudge
along, paying heavy taxes for which they get nothing in return."
   -Gore Vidal


> -Original Message-
> From: Wong, Phoebe [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 16, 2000 1:10 PM
> To: [EMAIL PROTECTED]
> Cc: Corson, Berton M.; Wong, Phoebe
> Subject: selecting random record from a database
>
>
> I saw your question on CF_Talk and one of our guys (Bert Corson) came up
> with this:
>
> Note: there were 186 records in this particular database
>
> 
> SELECT * FROM Survey WHERE ID > 186
> 
> 
>
>
>
>
> re: Is there an easy way to pick a random record from a database. I have a
> unique ID for each record, but it is not strictly sequential because of
> record deletions.
>
> Here is my thought:
>
> 1. Run a query and get the MAX and MIN IDs.
> 2. Do a loop using them as the beginning and ending range and generate a
> random
> number between them.
> 3. See if that number exists in the ID field of the db.
> 4. If yes, get the record, if not, try again.
> 5. Do this until you get a hit.
> 6. Alternatively I guess you could gen a random number and take the next
> higher
> number unless it is the highest number.
>
> That seems way to intensive and I know there must be a cleaner way. The
> programmers must know a good way to do this.
>

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

RE: How to stop an infinite CF loop?

[Gary McNeel, Jr.]

Look at using CFBREAK in a conditional loop. You can find it's use in a loop
on page 887 of the CF Web Application Const. Kit, Second Edition by Forta.

> -Original Message-
> From: Lon Lentz [mailto:[EMAIL PROTECTED]]
> Sent: Monday, June 12, 2000 8:34 AM
> To: cftalk
> Subject: How to stop an infinite CF loop?
>
>
>
>
>   I had posted this question, in a slightly more vague way, a couple weeks
> ago. Well, the theoretical happened and I was wondering if anyone
> might have
> a solution to head off such future occurrences.
>
>   It seems that a no-longer-here developer had written a template where in
> when conditions were met, a custom tag was called, and an email was
> generated. He had named his custom tag the same as the calling template.
> Well, the conditions were finally met, and in the end, some poor woman got
> 116,000 emails.
>
>   So, with an example this time, is there a straight forward way
> of shutting
> this loop down? Possibly a way of setting up a template to do it? Someway
> other than shutting the service down? We ended up having to kill
> the service
> to stop it. We initially tried making changes to the template hoping to
> force it to error out...but the system had cached all of the pertinent
> information and was on cruise control.
>
>
>
> Lon Lentz
> Applications Developer - GetLists.Com
> DataWarehousing and List Sales - Market your lists on the Net!
> [EMAIL PROTECTED]
> 941-541-9000 Ext. 210
>
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

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

RE: CF vs. Oracle Application Server

[Gary McNeel, Jr.]

I have similar question. Our school uses the Exeter Student Information
System (based on Oracle App. Forms)and is moving to web forms. Any feedback
on this anyone?

Gary McNeel

> -Original Message-
> From: Troy Simpson [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 02, 2000 4:20 PM
> To: [EMAIL PROTECTED]
> Subject: CF vs. Oracle Application Server
>
>
>
> We are trying to make a determination whether to use Oracle Application
> Server or ColdFusion Application Server.
> Does anyone know where I can find a comparison (pros/cons) between the
> two products?
> Any personal comments will also be appreciated.
>
> Sincerely,
> Troy
>
> --
> Troy Simpson | North Carolina State University
> NCSU Libraries | Campus Box 7111 | Raleigh | North Carolina
> ph.919.515.3855 | fax.919.513.3330
>
>
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
> _talk or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.
>
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


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

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

RE: Automatically transferring data from one table to another

[Gary McNeel, Jr.]

Use one table and just set a flag (yes/no or true/false or 0/1 depending on
your database) field. When people upload a joke the flag is set to No (or 0
or False) by default.

After you review the joke, you set the flag to Yes (or 1 or True).

Then in your CF code ONLY show jokes that have the flag set to Yes.


SELECT *
FROM Jokes
WHERE Flag = Yes (or whatever your flag equals)


That should work and no coping/duplicate tables and data. If you like you
can then purge all No records later.


Gary McNeel, Jr.
Project Manager - DAC-Net, Research & Graduate Studies
Rice University - Houston
[Lovett Hall] 713-348-6266 (Primary)
[DAC] 713-348-5184
[M] 713-962-0885
[H] 713-723-9240

"Open the pod bay doors please Hal."
 Dave Bowman - 2001 (talk about feeling alone)
"I know you and Frank were planning to disconnect me and I am afraid that is
something I cannot allow to happen."
 HAL - 2001 (response to Dave)

> -Original Message-
> From: Hubert Earl [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 30, 2000 1:18 PM
> To: [EMAIL PROTECTED]
> Subject: Automatically transferring data from one table to another
>
>
> Hi,
>
> Is there a way I may transfer data from one table to another
> automatically?
> I have a table containing jokes which can be accessed thru a browser.  I'm
> building another to which anyone can upload jokes.  After
> reviewing them, I
> want to be able to transfer any I wish to keep automatically to my first
> table, without having to copy and paste them (for example).  I'd
> appreciate
> any suggestions.
>
> Sincerely,
> ---
> Hubert Earl
> ICQ#:  16199853
>
> I develop & maintain web sites internationally.  I also build web
> applications using ColdFusion, JavaScript and CGI scripts written in Perl.
> I accept subcontracting work.
>
> **Personal web site:  http://www.geocities.com/hfme/
> (please remember to view this with a sense of humor!)
>
> **Business web page:  http://home.talkcity.com/MigrationPath/hearl/
>
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

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

RE: Will the last person leaving Cold Fusion please turn out the lights?

[Gary McNeel, Jr.]

Actually, to my knowledge, only a few US Army servers have moved. If you
have more information or statistics, I would be interested.

http://www.maccentral.com/news/0003/15.army.shtml

Granted, NT has vulnerabilities. Many of them. But I think the point is
being missed here. The new Mac OS X will have a UNIX command shell and
sendmail with it (albeit the command shell is not 'on' be default.

"The system’s kernel, which does the heavy lifting to support all those rich
applications, is based on Mach 3.0 from Carnegie-Mellon University and
FreeBSD 3.2 (derived from the University of California at Berkeley’s BSD
4.4-Lite), the most highly regarded core technologies from two of the most
widely acclaimed OS projects of the modern era. We also took the famous
Apache web server—which runs over half the websites on the Internet—and made
it friendly enough to use on your desktop for personal file sharing."

http://www.apple.com/macosx/inside.html

It is still vulnerable to stack overflows, etc. like any other UNIX system.
See:

http://www.anticode.com/

The Mac is still in very limited use as a server platform, having been years
behind NT and UNIX in getting to market. In fact, it is not even their own
technology, but existing technology repackaged as a new OS (see above).
There just have not been that many people trying to hack sites running this
server. You can, for all intents and purposes, "lock down" an NT box. As
with any complex operating system, as you add more functionality to the
systems they get increasing hard to secure. Many factors govern this, not
just the OS. It could be that the Army web master(s) were not competent in
'locking down' their server (nothing personal intended).

The Army is still reviewing their possible choices. Keep in mind the 'Army'
has many servers in many locations, so saying the "Army" is changing is very
misleading (again, unless there is a new, credible, press release out there
attesting to this).

It seems to me that many of the "Mac" people are very defensive. Maybe that
is because Apple is many years behind in their server development. I have no
bias either way, though I do understand and am more comfortable with PC's.
In fact, it is Mac's limited tool set and configurability (at least in the
past) that kept it from gaining wider acceptance. In past military, then
private and now academic environments I have had to work with and support
both PC, UNIX and Mac platforms. I have worked through many of the myths of
all of them. They all have there uses. Until there are many more sites
running the Mac OS X, I will reserve judgement as to it's invulnerability to
attack/exploit.

Working here I see many different Mac's and hear a bunch of the Mac
evangelizing. Kind of funny really. Believe me, they burp, hiccup and, well,
you know, just like other machines.

I will concede that, at present, it sounds like a really nice server.

Some questions reflecting my ignorance here.

How many actually running Mac OS X servers are out there running on the
internet open to the world (not boxes shipped/licensed)? I co-founded a
fairly large (200+ people) software company and am familiar with the "xxx
packages installed" marketing line.

What are they running in terms of having to open up the system? You can lock
down almost any server if you pull off enough services, etc. It is then a
matter of what functionality is lost.

Other thoughts?

Anyway,

Gary McNeel, Jr.
Project Manager - DAC-Net, Research & Graduate Studies
Rice University - Houston
[Lovett Hall] 713-348-6266 (Primary)
[DAC] 713-348-5184
[M] 713-962-0885
[H] 713-723-9240

"The politicians don't just want your money. They want your soul. They want
you to be worn down by taxes until you are dependent and helpless. When you
subsidize poverty and failure, you get more of both."
   -James Dale Davidson



> -Original Message-
> From: Larry C. Lyons [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 18, 2000 10:14 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Will the last person leaving Cold Fusion please turn out
> the lights?
>
>
> The Mac is dead as a server platform? While obviously not as popular as
> NT/2000, Mac servers suffer none of the gross security holes that NT/2000
> has. Remember that the US Army has decided to move towards the Mac web
> server system for those same reasons.
>
> --
> Larry C. Lyons
> EBStor.com
> 8870 Rixlew Lane, Suite 201
> Manassas, Virginia 20109-3795
> tel: (703) 393-7930 x253
> fax: (703) 393-2659
> http://www.ebstor.com
> http://www.pacel.com
> email: [EMAIL PROTECTED]
>
> Chaos, panic, and disorder - my work here is done.
> --
> "Reuben King" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]...
> > In <[EMAIL PROTECTED]>, Abe V. S.
> >
> > 

OT: Web Servers

[Gary McNeel, Jr.]

Is there a way to tell what another web site is running on? What type of
server it is?

Thanks.

Gary McNeel, Jr.
Project Manager - DAC-Net, Research & Graduate Studies
Rice University - Houston
[Lovett Hall] 713-348-6266 (Primary)
[DAC] 713-348-5184
[M] 713-962-0885
[H] 713-723-9240

"Great spirits have always encountered violent opposition from mediocre
minds."
   -Albert Einstein

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

OT - SQL Server

[Gary McNeel, Jr.]

I am trying to create a Role and put user in it. Then I go to set the
Permissions for the Role. Is there an easier way to do this than check all
of the check boxes multiple times? Sheesh. I have a bunch of tables and
views and I want to limit the Roles access to only very few of the views.
Can someone point me in the right direction?

Thanks.

Gary McNeel, Jr.
Project Manager - DAC-Net, Research & Graduate Studies
Rice University - Houston
[Lovett Hall] 713-348-6266 (Primary)
[DAC] 713-348-5184
[M] 713-962-0885
[H] 713-723-9240

"Great spirits have always encountered violent opposition from mediocre
minds."
   -Albert Einstein

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

RE: Opportunity

[Gary McNeel, Jr.]

Jeez, enough with the pre-IPO and planned IPO stuff. Everyone is pre-IPO and
planned IPO.

> -Original Message-
> From: THERESA [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 05, 2000 3:23 PM
> To: '[EMAIL PROTECTED]'
> Subject: OT: Opportunity
>
>
> In need of Cold Fusion Developers for a planned IPO in the fall.
>
> Platform is PC, language is Cold Fusion.
>
> Mandatory requirement is "Advanced Cold Fusion training".
>
> Experience Needed:
> At least two years and cold fusion training.
> Spectra experience is a definite plus.
> All levels of developers needed.
> Pay: DOE
>
> If you are interested in these positions, please email your resume to:
> [EMAIL PROTECTED]
>
> TIA,
>
> tcl
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

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

Application.cfm Question...

[Gary McNeel, Jr.]

Are application.(variablename) variables truly persistent. I am a bit
confused here. I know that only one application.cfm file is executed
automatically at any given time (others would have to be CFINCLUDEd).

I have a main application.cfm file in the root of the site. I set the
cfapplication (application and session management, name, etc.). I then set a
few application variables like application.dsn and application.sitename,
etc. That's about it.

(ex: main root application.cfm)




 




A directory level down I add another application.cfm that does a very quick
security check for user access to this area (yes/no field in db). In the
CFQUERY I use a datasourcename="#application.dsn#". I have, in the past,
just copied the application.cfm from the root into the other folder and
deleted anything not necessary, leaving the cfapplication and application
variables, then adding any other code.





SELECT PeopleID, PeopleFirstName, PeopleLastName, PeopleDACStaff
FROM tblPeople
WHERE PeopleID = #cookie.PeopleID#







Today I went ahead and deleted everything EXCEPT the little security query
(above) to see what would happen. Now the application can't seem to find my
application.dsn variable.

Does the running of another application.cfm file flush the variables created
previously?

Shouldn't the application variables be available for the life of the
application AS LONG as they are not flushed (STRUCTCLEARED or DELETED) or
changed?

Why would running another application.cfm, that does not delete or change
the earlier set application variables, make them unavailable to the
application?

Do you have to re-create the application.cfm file for each subfolder?

TIA

Gary McNeel, Jr.
Project Manager - DAC-Net, Research & Graduate Studies
Rice University - Houston
[Lovett Hall] 713-348-6266 (Primary)
[DAC] 713-348-5184
[M] 713-962-0885
[H] 713-723-9240

"Great spirits have always encountered violent opposition from mediocre
minds."
   -Albert Einstein

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

CF and SQL on same server...

[Gary McNeel, Jr.]

I know this is risky, but we have fairly low volume of hits, maybe several
hundred per day, to the server. We can afford a pretty nice server selected.

We are running it now on a server with no real problems (that we have seen).

Compaq Proliant ML350 733/133 Hot Plug HD Model (128) (will compare Dell and
HP too).

Greater Than 512MB (not final yet)
RAID 5 using 3 9.1GBHD's
Dual Wide-Ultra2 Controller
10/100 NIC
12/24GB Backup
NT SVR 4.0
etc.

I want to run CF and SQL on this box.

Questions:

1. Are there any huge draw backs to doing this.
2. Does it make more sense to get 2 lesser boxes?

Please don't respond if you just want to bash Compaq.

TIA

Gary McNeel, Jr.
Project Manager - DAC-Net, Research & Graduate Studies
Rice University - Houston
[Lovett Hall] 713-348-6266 (Primary)
[DAC] 713-348-5184
[M] 713-962-0885
[H] 713-723-9240

"Great spirits have always encountered violent opposition from mediocre
minds."
   -Albert Einstein

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

RE: CF and DB2

[Gary McNeel, Jr.]

http://www.as400.ibm.com/clientaccess/

Look here. Client Access is a way PC's can talk to IBM systems. Dig around a
bit here and I think you find what you need.


Gary McNeel, Jr.
Project Manager - DAC-Net, Research & Graduate Studies
Rice University - Houston
[Lovett Hall] 713-348-6266 (Primary)
[DAC] 713-348-5184
[M] 713-962-0885
[H] 713-723-9240

"Death and taxes are both certain...but death isn't annual."
   -Anon.

> -Original Message-
> From: Brian Cusack [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 12, 2000 8:38 AM
> To: [EMAIL PROTECTED]
> Subject: CF and DB2
>
>
> Hello all,
>
> Do any of you have experience with Cold Fusion and a DB2 back
> end?  Allaire
> maintains that there is some software called "Client Access Enabler" makes
> it possible for Cold Fusion to work with a DB2 database, but I am having
> some difficulty getting any information on this software.
>
> Thanks!
>
> Brian
>
>
>
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

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

RE: Semi OT: Passing JavaScript variables to other CF/JS templates

[Gary McNeel, Jr.]

Oops. I finally figured it out. Sorry for the bother folks. -Gary

> -Original Message-
> From: Gary McNeel, Jr. [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 07, 2000 4:45 PM
> To: Cf-Talk
> Subject: Semi OT: Passing JavaScript variables to other CF/JS templates
>
>
> I am trying to find a way to pass a JavaScript variable into a that would
> use it in another JavaScript code.
>
> I am using a JavaScript/CF page that, when the user clicks a button, a
> JavaScript popup window appears that has a CF calendar in it (thanks to
> Selena). Users then click on a date and that is pushed back into the main
> page, populating the date field.
>
> I have several fields on the page that use dates and I want this
> to work for
> the users. The tag Selena wrote is hard coded for a particular
> field. I want
> to pass the field name of the date field the user is currently selecting
> INTO the CF popup calendar template. That way, when the User clicks on a
> date, the code passes it back into the right date field. This
> would keep me
> from 10 different hard coded calendars templates.
>
> Any ideas or even good resources that might do this. Thanks.
>
> PS - Anyone interested in the code please contact me off list.
>
> Gary McNeel, Jr.
> Project Manager - DAC-Net, Research & Graduate Studies
> Rice University - Houston
> [Lovett Hall] 713-348-6266 (Primary)
> [DAC] 713-348-5184
> [M] 713-962-0885
> [H] 713-723-9240
>
> "Great spirits have always encountered violent opposition from mediocre
> minds."
>-Albert Einstein
>
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

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

AOL Server and CF

[Gary McNeel, Jr.]

Anyone have any experience with this server? Good or bad. Know issues.

Thanks.


Gary McNeel, Jr.
Project Manager - DAC-Net, Research & Graduate Studies
Rice University - Houston
[Lovett Hall] 713-348-6266 (Primary)
[DAC] 713-348-5184
[M] 713-962-0885
[H] 713-723-9240

"Great spirits have always encountered violent opposition from mediocre
minds."
   -Albert Einstein

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

Semi OT: Passing JavaScript variables to other CF/JS templates

[Gary McNeel, Jr.]

I am trying to find a way to pass a JavaScript variable into a that would
use it in another JavaScript code.

I am using a JavaScript/CF page that, when the user clicks a button, a
JavaScript popup window appears that has a CF calendar in it (thanks to
Selena). Users then click on a date and that is pushed back into the main
page, populating the date field.

I have several fields on the page that use dates and I want this to work for
the users. The tag Selena wrote is hard coded for a particular field. I want
to pass the field name of the date field the user is currently selecting
INTO the CF popup calendar template. That way, when the User clicks on a
date, the code passes it back into the right date field. This would keep me
from 10 different hard coded calendars templates.

Any ideas or even good resources that might do this. Thanks.

PS - Anyone interested in the code please contact me off list.

Gary McNeel, Jr.
Project Manager - DAC-Net, Research & Graduate Studies
Rice University - Houston
[Lovett Hall] 713-348-6266 (Primary)
[DAC] 713-348-5184
[M] 713-962-0885
[H] 713-723-9240

"Great spirits have always encountered violent opposition from mediocre
minds."
   -Albert Einstein

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

RE: Any known stability issues with CF Server 4.5 on NT?

[Gary McNeel, Jr.]

What web server are you running. We are running O'Reilly and there was a
problem with AOL IE browsers seeing the site. Since we have a lot of those,
we had to remove the server and go back to 4.1. This is documented both on
Allaires and O'Reilly's sites, but no information on a resolution.

Gary

> -Original Message-
> From: Mathew Raftree, Jr. [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 06, 2000 1:15 PM
> To: '[EMAIL PROTECTED]'
> Subject: Any known stability issues with CF Server 4.5 on NT?
>
>
> Hello All,
>
> I am trying to figure out which version of CFServer to run a website on. I
> have been using 4.0 for a long time without incident but I want to use the
> new stuff in 4.5 (ie. better support for Oracle). I have heard
> some murmers
> about 4.5 not being stable. Does anyone have any information,
> experiences or
> news about patches they would like to share?
>
> Thanks in advance,
>
> Mat
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
> _talk or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.
>

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

RE: Security holes revisited -- reward offered

[Gary McNeel, Jr.]

You might try to download and use Hackershield from BindView Development at
www.bindview.com. It does a pretty thorough job of finding many of the holes
in system. The trial download will work on one machine (just install it on
that one). It does require that you be logged in as Administrator and that
it can use the system account. I just used it and was pleasantly surprised.
It found MANY of the MOST common problems. Easy install, but does require
rebooting. Can even fix many problems, just make sure it isn't fixing
something that you really need.

(BTW, this is not a plug, even though I was employee number 30 something
when they were young and struggling. lol)


Gary McNeel, Jr.
Project Manager - DAC-Net, Research & Graduate Studies
Rice University - Houston
[Lovett Hall] 713-348-6266 (Primary)
[DAC] 713-348-5184
[M] 713-962-0885
[H] 713-723-9240

"The genius of our ruling class is that it has kept a majority of the people
from ever questioning the inequity of a system where most people drudge
along, paying heavy taxes for which they get nothing in return."
   -Gore Vidal

> -Original Message-
> From: Steve Pierce [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 04, 2000 11:31 AM
> To: [EMAIL PROTECTED]
> Subject: RE: Security holes revisited -- reward offered
>
>
> How about just turn off the system. Seriously, is this for an unlimited
> period and did your boss be stupid and pay in advance or will pay upon
> success.
>
> Make sure you are not vulnerable to social engineering where the guy calls
> and gets passwords from another employee.
>
>  - Steve
>
>
> -Original Message-
> From: Nick Call [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 04, 2000 11:44 AM
> To: [EMAIL PROTECTED]
> Subject: Security holes revisited -- reward offered
>
>
> Ok, fellow Listees, here's the deal...
>
>  My boss's daughter has a boyfriend.. (can you smell the trouble
> already???).  He is bent out of shape over the fact that I did
> not recommend
> that we hire him (I interviewed him and gave his skill sets an honest,
> thorough exam).  He is good at A/V stuff, but his web experience/database
> experience is null.  Anyway, back to the situation..  He has convinced
> the boss to pay him 2 grand to attempt to hack the system I built.  He
> claims to be a super hacker, blah, blah, blah.  I am not too
> confident that
> he can do it, but there is a small chance
>
> Multiple minds are better than one.  I have gone over and over
> all the stuff
> I know, but I am more than likely missing some stuff.  Anyone
> care to share
> their CF/NT/IIS security checklist or other advice?
>
> It's escalated into all-out war.  He is going to stop at nothing
> to make me
> look bad, and I will stop at nothing to prevent him from succeeding.
>
> Thanks in advance.  I will custom print 5 free T-shirts with your logo (in
> one color) on them if you give me advice that plugs up a hole
> that I didn't
> know about.
>
>
> Thanks in advance.
> Nick Call
> [EMAIL PROTECTED]
> http://www.graphixonline.com
>
>
> --
> --
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

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

Houston CFUG...

[Gary McNeel, Jr.]

Does anyone know if there is a Houston CFUG?


Gary McNeel, Jr.
Project Manager - DAC-Net, Research & Graduate Studies
Rice University - Houston
[Lovett Hall] 713-348-6266 (Primary)
[DAC] 713-348-5184
[M] 713-962-0885
[H] 713-723-9240

"Great spirits have always encountered violent opposition from mediocre
minds."
   -Albert Einstein

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

OT: Objective and/or subjective reviews of MySQL, MS SQL Server and other SQL products...

[Gary McNeel, Jr.]

This is a bit off topic.

I am looking for an objective review of the different SQL servers out there.
We are currently getting involved in a project where a department (name
withheld to protect the guilty) is having built an online application using
MySQL, Perl and Apache server. We are being asked to advise them as the work
is actually for one of our clients.

In our group we are exclusively (pretty much anyway) Cold Fusion and MS
Access or SQL Server.

I am concerned about MySQL because of discussions I have seen here and in
other groups. Is anyone using it in a production environment? What are it's
limitations? Why would I use or not use it? Anything else anyone wants to
add.

Gary McNeel, Jr.
Project Manager - DAC-Net, Research & Graduate Studies
Rice University - Houston
[Lovett Hall] 713-348-6266 (Primary)
[DAC] 713-348-5184
[M] 713-962-0885
[H] 713-723-9240

"Great spirits have always encountered violent opposition from mediocre
minds."
   -Albert Einstein

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