RE: SQL error (minus the mess)

[Christopher Olive, CIO]

ok, second round.

when setting up the datasource, did you restrict access to the SQL command
set?  in the CFAdministrator, under "ODBC Datasources", select the DSN in
question.  choose "Advanced>>", and make sure that "SELECT" is checked.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Kylie Lovelock [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 13, 2000 2:46 AM
To: CF-Talk
Subject: Re: SQL error (minus the mess)


Thanks for taking the time Christopher. I removed the username and password
from my CFQUERY - but still receiving the same error of SQL operation
unauthorized.

Cheers
Kylie
- Original Message -
From: "Christopher Olive, CIO" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 13, 2000 3:29 PM
Subject: RE: SQL error (minus the mess)


> at just a quick glance, is the username/password combination valid for
that
> database?  did you give access to the user "username"?  access by default
> does not have security.  try removing the username and password attributes
> from your CFQUERY.
>
> chris olive, cio
> cresco technologies
> [EMAIL PROTECTED]
> http://www.crescotech.com
>
>
>




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


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

Re: SQL error (minus the mess)

[Kylie Lovelock]

Thankyou Thankyou (as I smile until my cheeks hurt)
I forwarded your suggestion through to my ISP - he followed your
instructions and it works like a charm.

Did I say Thankyou? - Thankyou

Cheers
Kylie

- Original Message -
From: "Christopher Olive, CIO" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 13, 2000 4:42 PM
Subject: RE: SQL error (minus the mess)


> ok, second round.
>
> when setting up the datasource, did you restrict access to the SQL command
> set?  in the CFAdministrator, under "ODBC Datasources", select the DSN in
> question.  choose "Advanced>>", and make sure that "SELECT" is checked.
>
> chris olive, cio
> cresco technologies
> [EMAIL PROTECTED]
> http://www.crescotech.com
>
>
>
> -Original Message-
> From: Kylie Lovelock [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 13, 2000 2:46 AM
> To: CF-Talk
> Subject: Re: SQL error (minus the mess)
>
>
> Thanks for taking the time Christopher. I removed the username and
password
> from my CFQUERY - but still receiving the same error of SQL operation
> unauthorized.
>
> Cheers
> Kylie
> - Original Message -
> From: "Christopher Olive, CIO" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, November 13, 2000 3:29 PM
> Subject: RE: SQL error (minus the mess)
>
>
> > at just a quick glance, is the username/password combination valid for
> that
> > database?  did you give access to the user "username"?  access by
default
> > does not have security.  try removing the username and password
attributes
> > from your CFQUERY.
> >
> > chris olive, cio
> > cresco technologies
> > [EMAIL PROTECTED]
> > http://www.crescotech.com
> >
> >
> >
>
>
> --
--
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a
> message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>


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

Crystal Reports 8

[Lena Trajkovska]

 Hi!
 I just rejoin the mailing list, so I'm sorry if I repeat a question.
 So, short overview of my problem:
 We have a business application build using CF 4 Enterprise, Oracle 8 and
CR7. The CR7 showed that it's not up to the task, because it should generate
reports upon 5 - 7 entries, with subreports, conditional summaries,
and joining of 10 tables, some with conditional joins, some not, and when
generating of such a report the service blocked and stopped. We thought that
the solution is in the CR8, and we bought it. And then the real fun began.
When generating the reports with subreports - and opening it in the IE4 with
the ActiveX viewer - it give an error "Error detected in database dll".
Then, after consulting with the technical support in Seagate, I defined the
Oracle user - for the reports, as a Windows NT user with administrators
rights, and sometimes it works, sometimes it doesn't - the technical support
said it shouldn't be that way, but couldn't help me any further. The biggest
problem is that when the CR8 opens a simple report in the IE4 - with no
subs, it opens it OK, but afterwards, the cookies that I had defined with
expires="never", are not defined. I test it, and after each opening of the
report different parts of the definition of the cookie where deleted. Again,
the technical support of Seagate was amazed.
 I'm running out of time, the customer is getting very nervous, because he
bought the CR8.
Does any one had such a problem - or maybe a solution?

Thank you in advance,
Lena Trajkovska
Artisoft dooel


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

Multiple Select Difficulties

[t nelson]

Hello everyone,

I am facing a major problem right now. I have an application where the user 
can search for more than one piece of inventory at a time. They can do this 
by typing in multiple part numbers and seperating them with a comma. The 
problem I am facing is that when I pass these variables to the database I 
keep getting error messages. The error message I am getting is that the page 
is trying to process all of the variables at once instead of processing them 
one at a time. for example:

SELECT *
FROM table
WHERE partID = 1,2,3

instead of ("WHERE partID = 1")

I've tried nesting cfloop statement within my  tags but I still get 
the same results.

Any ideas out there?

As always thank you all in advance.
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

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


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

Re: Multiple Select Difficulties

[Dick Applebaum]

Try

WHERE partID IN (#SearchPartList#)

SearchPartList is the comma-delimited input list of parts





At 11:11 AM + 11/13/00, t nelson wrote:
>Hello everyone,
>
>I am facing a major problem right now. I have an application where the user
>can search for more than one piece of inventory at a time. They can do this
>by typing in multiple part numbers and seperating them with a comma. The
>problem I am facing is that when I pass these variables to the database I
>keep getting error messages. The error message I am getting is that the page
>is trying to process all of the variables at once instead of processing them
>one at a time. for example:
>
>SELECT *
>FROM table
>WHERE partID = 1,2,3
>
>instead of ("WHERE partID = 1")
>
>I've tried nesting cfloop statement within my  tags but I still get
>the same results.
>
>Any ideas out there?
>
>As always thank you all in advance.

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

RE: Report: Allaire Worldwide Developer Conference 2000

[JustinMacCarthy]

Hi Stephan ,
Excellent report, I missed the conf. because I was sick, thanks for getting
me up to speed,
Cheered me up no end :-) I'm off to buy some Allaire Stock

JustinMacCarthy
www.cfug.ie

> -Original Message-
> From: Stephan Tual (CFTutorials.com)
> [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 13, 2000 12:57 AM
> To: CF-Talk
> Subject: Report: Allaire Worldwide Developer Conference 2000
>
>
> I've uploaded a 7 page report that covers everything you ever wanted to
> know about the Allaire Worldwide Developer Conference 2000, from product
> announcements to fun facts.
>
> Learn what's behind codenames such as Pharaoh, Trinity, Neo, and Dharma.
> This is the most complete report available on the net, and it's
> accompanied
> by an exclusive product roadmap. A must read for both ColdFusion and JRun
> developers.
>
> You can find the report at http://www.cfvault.com/ , in the
> 'articles' section.
>
> As usual, feedback is welcomed!
>
> Best Regards,
>
>
> Stephan Tual
> Editor & Webmaster
>
> CFVault.com
> http://www.cfvault.com
> Daily News Updates, Jobs, Forums, Articles, Interviews, Events, and
> in-depth Tutorials from the Allaire World.
>
> Direct Line: CFTutorials.com Ltd. +(1) 415 637 5591
>
> Team Allaire Member
> Allaire Certified Trainer
> Allaire Certified CF Developer
>
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> or send a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
>
>


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

RE: Another: Send HTML email through CFMAIL

[Paul Johnston]

Of course, you could always write a frameset that calls in the relevant page
(just like a load of companies do - mp3.com is an example).

This would mean you could send both a frames and a non-frames version and a
link at the top for those with just text based email readers!

Just my two pennyworth (being English and all!)

Paul

> -Original Message-
> From: Aaron Johnson [mailto:[EMAIL PROTECTED]]
> Sent: 10 November 2000 21:36
> To: CF-Talk
> Subject: RE: Another: Send HTML email through CFMAIL
>
>
> Do a 
>
> and then in your  reference #cfhttp.filecontent#
>
> AJ
>
>
> -Original Message-
> From: andrew kopelman [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 10, 2000 4:18 PM
> To: CF-Talk
> Subject: Another: Send HTML email through CFMAIL
>
>
> If I want to embed one of my CF Page's output ENTIRELY in the CFMAIL, how
> would I reference it?  Would I run a call to the page within the
> CFMAIL tag?
>
> Thanks ahead of time,
> Andrew
>
>
> >From: "Daniel J O'Keefe" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: CF-Talk <[EMAIL PROTECTED]>
> >Subject: RE: Send HTML email through CFMAIL
> >Date: Thu, 9 Nov 2000 13:09:23 -0500
> >
> >TYPE="HTML" in the CFMAIL tag.
> >
> >Dan
> >
> >-Original Message-
> >From: Hong [mailto:[EMAIL PROTECTED]]
> >Sent: Thursday, November 09, 2000 12:27 PM
> >To: CF-Talk
> >Subject: Send HTML email through CFMAIL
> >
> >
> >Dear list,
> >
> >This is a simple question.
> >
> >I want to send a HTML page to a list of people in HTML format though
> >CFMAIL,
> >like the HTML newsletter we get from certain websites.
> >
> >How to do that?  Any required parameters, attributes, etc.
> >
> >Thanks!
> >
> >Hong
> >  _ Do
> You Yahoo!?
> >Get your free @yahoo.com address at
> >ttp://mail.yahoo.com
> >--
> >--
> >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> >Unsubscribe:
> http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
> >message with 'unsubscribe' in the body to
> >[EMAIL PROTECTED]
> >
> >-
> --
> -
> >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> >Unsubscribe:
> http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
> >message with 'unsubscribe' in the body to
> >[EMAIL PROTECTED]
>
> _
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
> Share information about yourself, create your own public profile at
> http://profiles.msn.com.
>
> --
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> or send a
> message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
>
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> or send a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
>



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

RE: intranet apps

[Paul Ihrig]

ok, open source.

ftp://63.69.175.75/zip/IntraNet/
user name: tl
pass word: timelord
both phone & education sections have a read me.
you should be able to figure out the knowledge base after those 2.

start with the phone, since the other two use that db in parts.

let me know if there are any ways to make these better!
thanks.
-paul

> -Original Message-
> From: Joseph Thompson [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, November 10, 2000 1:13 PM
> To:   CF-Talk
> Subject:  Re: intranet apps
> 
> I can toss in my crazy calendar part
> http://u8ntcn0.com/calendar
> 
> 
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
> a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]

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

RE: PCodeDocumentNodeImp::validateSelf

[Bud]

On 11/12/00, Ken Wilson penned:
>  > ...I'm using 4.01 since 4.51 is such crap.
>
>
>Really??
>
>I've had no problems with v4.51. What's your beef with it?

Problems I've experienced personally include:

cfmail not wrapping line breaks correctly. When I generate invoices 
from my shopping cart, manual line breaks work fine in 4.01. In 4.51, 
it wraps when it feels like it. I had to take all the line breaks out 
and enter #chr(10)# instead.

cfhttp returns an error if the page returned doesn't have the header 
it likes. This happens on some pretty major sites, UPS Online Tools 
being one of them.

Those are the 2 that I've experienced in the couple times I've had 
the "pleasure" of building sites to run on 4.51.

 From reading this list, I know there are several people that have 
rolled back to 4.01 due to instability of 4.51. A show of hands?

I know of one large ISP that rolled back because CF Server would lock 
up when client variables were cleared from the registry. I don't 
store client variables in the registry on my server, but still.

I've got about 30 sites running under CF 4.01 on my server, mostly 
using Access for the databases. I restart the server once a week, and 
except for the PCode error I got for the first time the other day, 
it's been solid as a rock.
-- 

Bud Schneehagen - Tropical Web Creations

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

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

Locking while deleting

[Todd Ashworth]

Is it necessary to lock session variables while doing a StructDelete() on
them?

Also .. say one is reading or writing a Session variable and an Application
variable in the same line of code.  What scope would one use on the lock if
one couldn't get an individual lock around each variable?


blah blah blah


??

Also .. is nesting locks a bad idea?  For example:


SELECT blah, blah2, blah3
FROM this_table
WHERE table_id = #Session.TableID#


Is this the only way to do it?



SELECT blah, blah2, blah3
FROM this_table
WHERE table_id = 
   #Session.TableID#
   



That seems awfully inefficient.

Todd Ashworth



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

RE: Locking while deleting

[Dave Watts]

> Is it necessary to lock session variables while doing a 
> StructDelete() on them?

Yes.

> Also .. say one is reading or writing a Session variable and 
> an Application variable in the same line of code. What scope 
> would one use on the lock if one couldn't get an individual 
> lock around each variable?
> 
>  Len(Trim('Application.Variable'))>
> blah blah blah
> 

If you've got things within two different scopes which need to be locked,
you'll need two separate locks. Neither scope is a subset of the other. If
you have to, you can copy variables from a memory scope to a local scope
before you use them.

> Also .. is nesting locks a bad idea?  For example:
> 
> 
> SELECT blah, blah2, blah3
> FROM this_table
> WHERE table_id = #Session.TableID#
> 
> 
> Is this the only way to do it?
> 
> 
> 
> SELECT blah, blah2, blah3
> FROM this_table
> WHERE table_id =  type="ReadOnly">
>#Session.TableID#
>
> 
> 
> 
> That seems awfully inefficient.

No, there are other ways to do this.

Again, you can copy variables to a local scope before using them. This will
keep you from having to use nested locks.

Also, you can rethink your use of memory variables, and limit it to what you
really need to keep in memory. For example, for things like the datasource
name, what you really want is a constant. CF doesn't have anything which is
directly analogous to constants; I like to use the Request scope for
constants, though, as it's not stored in memory and avoids the need for
locking.

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/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: RDS and NT holding a lock on a file

[Dave Watts]

> If anyone has *any* info on how to eliminate this error 
> message, please let me know.

Sorry it took so long to reply, but this should help. It originally was
posted by Gregory Narain. The only one I've played with is ObjectCacheTTL,
so you'll want to test these things a bit.

> I just had to deal with this problem.  Unfortunately, it will force some
> drastic changes in the server.  There are several registry keys that can
> be added that effectively eliminate the caching -- the cache scavenger
> as M$ calls it.
>
> All of the entries go into the
> HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\InetInfo\Parameters
> key
>
> ObjectCacheTTL (DWORD)
> --
> This thing supposedly tells IIS how long to hold on to the files.  They
> have a special value (as opposed to using just 0!) of 0x that
> supposedly disables the scavenger.
>
> Defaults to 10 minutes.
>
>
> ObjectFilesInCache (DWORD)
> --
> This reduces the total memory allowed to be in cache.  You can simply
> set this one to zero.
>
> Defaults to 1000 for every 32MB of memory.
>
>
> MemoryCacheSize (DWORD)
> ---
> This puppy caches system handles and other things for IIS (directory
> listings, etc.)  You can set this to 0 and eliminate the caching
> supposedly.
>
> Defaults to 3072000, 3MB.
>
>
> DisableMemoryCache (DWORD)
> --
> Well, this one I found from a reference to a knowledge book in the
> forums.  Apparently, setting MemoryCache to 0 wasn't intuitive enough so
> they made an an extra value.  Set this to 1 and it REALLY will work.  I
> tried this one yesterday and it's all good to go now. KB Article Q191742
> for reference.
>
> Defaults.. it wasn't ever meant to be used!

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/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: jr CF

[Lloyd, Kendre]

I was in accounting for several years.  I work for a non profit.  I took a
lateral in Electronic Pubs and found cold fusion.  I simply began doing it.
Once I did my first application with it, the company invested in me by
paying for the basic cold fusion class.  The more aps I did, the happier
they were and sent me to advanced cold fusion.  It took me a year to get the
promotion, title and salary to go with it all, but it was worth it.  Find a
small growing concern with system needs, take what you already know there,
show it, work hard and  the rewards will come.  It worked for me.  Yeah, I
could have taken my little bit of knowledge and fudged a higher paying job
elsewhere, I saw folks do that, but I wanted a solid foundation and having a
company willing to help me grow in it helps.  

I am finding that the combination of programming and accounting is really a
good thing to have.

Good luck, find a place to grow and work and study hard.  I found that
actually using and applying Cold Fusion was better than any of the courses I
took.  I get the updated manuals, I have Ben Fortas 4.0 and a good SQL
manual.  Also I use Goodmans Java script bible and pay close attention to
this list.   I have found many valuable lessons on this list.  It is amazing
the stuff you can get and learn free.  I have to admit that having Cold
Fusion here at work helps because I can see the results quickly, but you can
learn a great deal even at CF web sites.  Like someone else said, do a web
page showing your skills.  THen base your resume on that.  


> > Ellen Swartz wrote:
> >
> > Very interesting thread.
> >
> > I am not alone and it does not make me feel any better.
> > I have been struggling for the last 6 months between getting
> several part-time
> > jobs to make some $ and finding an entry level CF position or
> internship. I
> > got about 10 interviews with local companies that all ended the
> same way.
> > "Sorry, you don't have enough experience. Go home, work hard
> and contact us
> > again when you are ready."
> >
> > Let's face it. What company is going to hire an accountant with
> no experience
> > and barely any knowledge?
> > If CF was tought in college we would not be were we are now. We
> still would
> > not have the real life experience but we would have a lot more
> knowledge and
> > consequently a lot more chances to find an entry level CF job.
> >
> > I got to a point where I was wondering if I should pay a
> company to hire me
> > and give me some real life experience. I would work for freee
> if I was given
> > the opportunity (only on-site with a local company). It's
> either that (and I
> > agree I would be taken advantage of) or spent another year
> strugging learning
> > in 6 months at home what I would probably learn in a month
> working full time.
> >
> > Why don't we start something.
> > CF guru could teach one or twice a week and be paid for it.
> > Example: I live in Fort Lauderdale, FL. If an experience CF
> could give a class
> > to 10 CF beginners at least once a week and get paid by us (how
> much would
> > have to be determined) maybe we would learn faster and smarter.
> >
> >
>
> --
> Jeff Houser
> AIM: Reboog711  | ICQ: 5246969 | Phone: 860-229-2781
> --
> DotComIt, LLC
> Computer Consultant specializing in database driven web data
> Lotus Notes/Domino, Cold Fusion
> --
> Half of the Alternative Folk Acoustic Duo called Far Cry Fly
> http://www.farcryfly.com
> http://www.mp3.com/FarCryFly
> --
> Does Everyone Think I'm a Cynical?
> --
> 
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_jobs or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.



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




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

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

Re: Locking while deleting

[Todd Ashworth]

Ahh .. my thinking was to try to avoid having to set a variable on every
single page and just store something like the DSN that is used frequently in
a memory variable.  After reading your comments, and in hindsight, I suppose
it's a lot easier on system resources to simply set the variable instead of
having to lock it all over the place.  Also, moving the memory variable to a
local one before use defeats the purpose of having the memory variable to
begin with, so ...

Guess I'll do a little rewriting :)

Thanks.

Todd Ashworth

| > Is it necessary to lock session variables while doing a
| > StructDelete() on them?
|
| Yes.
|
| > Also .. say one is reading or writing a Session variable and
| > an Application variable in the same line of code. What scope
| > would one use on the lock if one couldn't get an individual
| > lock around each variable?
| >
| >  Len(Trim('Application.Variable'))>
| > blah blah blah
| > 
|
| If you've got things within two different scopes which need to be locked,
| you'll need two separate locks. Neither scope is a subset of the other. If
| you have to, you can copy variables from a memory scope to a local scope
| before you use them.
|
| > Also .. is nesting locks a bad idea?  For example:
| >
| > 
| > SELECT blah, blah2, blah3
| > FROM this_table
| > WHERE table_id = #Session.TableID#
| > 
| >
| > Is this the only way to do it?
| >
| > 
| > 
| > SELECT blah, blah2, blah3
| > FROM this_table
| > WHERE table_id =  type="ReadOnly">
| >#Session.TableID#
| >
| > 
| > 
| >
| > That seems awfully inefficient.
|
| No, there are other ways to do this.
|
| Again, you can copy variables to a local scope before using them. This
will
| keep you from having to use nested locks.
|
| Also, you can rethink your use of memory variables, and limit it to what
you
| really need to keep in memory. For example, for things like the datasource
| name, what you really want is a constant. CF doesn't have anything which
is
| directly analogous to constants; I like to use the Request scope for
| constants, though, as it's not stored in memory and avoids the need for
| locking.



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

RE: Hello. I'm looking for talented Photojournalists and Videographers. The event will be in

[mikec]

You swine !
*slaps the sender of this message*

*takes out his hankerchief to clean his soiled hand*








Change is the only constant

Download NeoPlanet at http://www.neoplanet.com


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

Create Table Question

[Will Ryan]

Greeting Guru's

  I'm trying to create a table in Access via CF. I need to create an
AutoNumber field for an ID.  I don't want to create it through access as I
would have to upload a 60 meg DB to our offsite server.  Any suggestions for
the SQL Statement?

create table T_AddBook (
AddID autonumber,
Name varchar (20),
Add1 varchar (40),
Add2 varchar (40)
)


Thanks,
 Will

Will Ryan
[EMAIL PROTECTED]
http://www.zerotoeighty.com
w: 410-327-9152
f: 410-327-4086


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

Doubled Headers

[Guy J. McDowell]

Hi CFFolks,

No this isn't about baseball.

Situation: when viewing source of my templates after being served from
our hosts the headers are doubled.
Example:



Untitled









O.F.A.H. - About Us










You can easily tell which is mine and which is not.

Question: Why is this happening and how can I correct it?

Thank you so much for your help in advance.

Yours In Conservation,

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

P.S. You may want to check out the fresh new look of www.OFAH.org
Launched 1st November 2000.
Don't forget our other great sites:
www.AuctionForWildlife.com - Your chance to make your bid for
conservation.
www.EcoEd.org - an online adventure for kids in grades 1 through 8.
www.HuntingDog.org - Celebrating our Hunting Dog Heritage.
www.AHTV.com - Your online companion to the Angler and Hunter
Television show.
www.OHEP.net -  Where to find out and learn about the Ontario Hunter
Education Program.




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

RE: please recommend cf host

[Michael She]

www.crystaltech.com.  Cheap prices, large feature set, and extremely good
tech support.






"Jason Egan" <[EMAIL PROTECTED]> on 11/10/2000 01:45:49 PM

Please respond to [EMAIL PROTECTED]

To:   CF-Talk <[EMAIL PROTECTED]>
cc:(bcc: Michael She/TOR/PBC)

Subject:  RE: please recommend cf host




konnections
801-621-8511

-Original Message-
From: Michael Slatoff [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 10, 2000 9:49 AM
To: CF-Talk
Subject: Re: please recommend cf host


Try using CFHosting
www.cfhosting.com


"Philip Denlinger" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I am a fledgling cf user and am looking for a cf host.
>
> This site is the archives of a science journal, with
> abstracts in HTML, and full text articles in PDF.
>
> Here are the characteristics of the site:
>
> NEEDS:
> -
>
> Traffic:  Average 250 megs transfer per month
>
> Disk space:  Currently 470 megs, grows by 125 megs per year
>
> Needs: Verity collection to index PDF
>
> Needs: CFCONTENT tag to push PDF to registered users who are granted
access
> by IP or by userid/password.
>
> Access database
>
> Site (currently unix) at: 
>
> If you are recommending a host, please include the address of your
> site located at that host. With your permission, I will run a
> Netmechanic Serverwatch for 8 hours to check out your host's
> performance.
>
> 
>
> Thanks.
>
>
>
--
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]


---
-

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

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







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

Re: Doubled Headers

[Howie Hamlin]

Do you have a blank html page in application.cfm?

Regards,

Howie

- Original Message -
From: "Guy J. McDowell" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 13, 2000 9:44 AM
Subject: Doubled Headers


> Hi CFFolks,
>
> No this isn't about baseball.
>
> Situation: when viewing source of my templates after being served from
> our hosts the headers are doubled.
> Example:
> 
> 
> 
> Untitled
> 
> 
>
> 
> 
> 
>
> 
> 
> O.F.A.H. - About Us
>
> 
> 
> 
> 
> 
> 
> 
> 
>
> You can easily tell which is mine and which is not.
>
> Question: Why is this happening and how can I correct it?
>
> Thank you so much for your help in advance.
>
> Yours In Conservation,
>
> Guy J. McDowell,
> Webmaster
> The Ontario Federation of Anglers & Hunters
> E-mail: [EMAIL PROTECTED]
> Phone: (705) 748-6324 ext. 262
>
> P.S. You may want to check out the fresh new look of www.OFAH.org
> Launched 1st November 2000.
> Don't forget our other great sites:
> www.AuctionForWildlife.com - Your chance to make your bid for
> conservation.
> www.EcoEd.org - an online adventure for kids in grades 1 through 8.
> www.HuntingDog.org - Celebrating our Hunting Dog Heritage.
> www.AHTV.com - Your online companion to the Angler and Hunter
> Television show.
> www.OHEP.net -  Where to find out and learn about the Ontario Hunter
> Education Program.
>
>
>
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]


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

RE: Doubled Headers

[Dave Watts]

> Situation: when viewing source of my templates after being 
> served from our hosts the headers are doubled.
> Example:
> 
> 
> 
>   Untitled
> 
> 
> 
> 
> 
> 
> 
> 
> 
> O.F.A.H. - About Us
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> You can easily tell which is mine and which is not.
> 
> Question: Why is this happening and how can I correct it?

It sounds like you might have the first block of HTML in an application.cfm
file somewhere.

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/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

RE: Doubled Headers

[Rich Wild]

Perhaps you have HTML in your application.cfm ???

This happens a lot round our way! I'm always slappin our junior coders for
it :)
 

---
Rich Wild
Senior Web Designer

---
e-mango.com ltd  Tel: 01202 587 400
Lansdowne Place  Fax: 01202 587 401
17 Holdenhurst Road
Bournemouth   Mailto:[EMAIL PROTECTED]
BH8 8EW, UK  http://www.e-mango.com
---
This message may contain information which is legally
privileged and/or confidential.  If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of e-mango.com ltd,
unless otherwise explicitly and independently indicated
by an authorised representative of e-mango.com ltd.
---




> -Original Message-
> From: Guy J. McDowell [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 13, 2000 2:45 PM
> To: CF-Talk
> Subject: Doubled Headers
> 
> 
> Hi CFFolks,
> 
> No this isn't about baseball.
> 
> Situation: when viewing source of my templates after being served from
> our hosts the headers are doubled.
> Example:
> 
> 
> 
>   Untitled
> 
> 
> 
> 
> 
> 
> 
> 
> 
> O.F.A.H. - About Us
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> You can easily tell which is mine and which is not.
> 
> Question: Why is this happening and how can I correct it?
> 
> Thank you so much for your help in advance.
> 
> Yours In Conservation,
> 
> Guy J. McDowell,
> Webmaster
> The Ontario Federation of Anglers & Hunters
> E-mail: [EMAIL PROTECTED]
> Phone: (705) 748-6324 ext. 262
> 
> P.S. You may want to check out the fresh new look of www.OFAH.org
> Launched 1st November 2000.
> Don't forget our other great sites:
> www.AuctionForWildlife.com - Your chance to make your bid for
> conservation.
> www.EcoEd.org - an online adventure for kids in grades 1 through 8.
> www.HuntingDog.org - Celebrating our Hunting Dog Heritage.
> www.AHTV.com - Your online companion to the Angler and Hunter
> Television show.
> www.OHEP.net -  Where to find out and learn about the Ontario Hunter
> Education Program.
> 
> 
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: 
http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with
'unsubscribe' in the body to [EMAIL PROTECTED]

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

Re: Doubled Headers

[Todd Ashworth]

Do you happen to leave this:




Untitled






in your Applcation.cfm?

I know it's a silly question, but ... :)

Todd Ashworth

| Hi CFFolks,
|
| No this isn't about baseball.
|
| Situation: when viewing source of my templates after being served from
| our hosts the headers are doubled.
| Example:
| 
| 
| 
| Untitled
| 
| 
|
| 
| 
| 
|
| 
| 
| O.F.A.H. - About Us
|
| 
| 
| 
| 
| 
| 
| 
| 
|
| You can easily tell which is mine and which is not.
|
| Question: Why is this happening and how can I correct it?
|
| Thank you so much for your help in advance.
|
| Yours In Conservation,
|
| Guy J. McDowell,
| Webmaster
| The Ontario Federation of Anglers & Hunters
| E-mail: [EMAIL PROTECTED]
| Phone: (705) 748-6324 ext. 262
|
| P.S. You may want to check out the fresh new look of www.OFAH.org
| Launched 1st November 2000.
| Don't forget our other great sites:
| www.AuctionForWildlife.com - Your chance to make your bid for
| conservation.
| www.EcoEd.org - an online adventure for kids in grades 1 through 8.
| www.HuntingDog.org - Celebrating our Hunting Dog Heritage.
| www.AHTV.com - Your online companion to the Angler and Hunter
| Television show.
| www.OHEP.net -  Where to find out and learn about the Ontario Hunter
| Education Program.
|
|
|
| --
--
| Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
| Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
|



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

RE: Create Table Question

[Mike Connolly]

I'd like to proven wrong on this, but I think you're at the mercy of Jet-SQL
which doesn't allow direct manipulation of numerous properties of an Access
table.

e.g. Default Value, AutoNumber types, etc...


> -Original Message-
> From: Will Ryan [SMTP:[EMAIL PROTECTED]]
> Sent: 13 November 2000 14:36
> To:   CF-Talk
> Subject:  Create Table Question
> 
> Greeting Guru's
> 
>   I'm trying to create a table in Access via CF. I need to create an
> AutoNumber field for an ID.  I don't want to create it through access as I
> would have to upload a 60 meg DB to our offsite server.  Any suggestions
> for
> the SQL Statement?
> 
> create table T_AddBook (
> AddID autonumber,
> Name varchar (20),
> Add1 varchar (40),
> Add2 varchar (40)
> )
> 
> 
> Thanks,
>  Will
> 
> Will Ryan
> [EMAIL PROTECTED]
> http://www.zerotoeighty.com
> w: 410-327-9152
> f: 410-327-4086
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
> a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]


---
Any opinions expressed in this message are those of the individual and not necessarily 
the company.  This message and any files transmitted with it are confidential and 
solely for the use of the intended recipient.  If you are not the intended recipient 
or the person responsible for delivering to the intended recipient, be advised that 
you have received this message in error and that any use is strictly prohibited.

Sapphire Technologies Ltd
http://www.sapphire.net

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

Re: Problem on RDS

[Michael She]

Not me... but right click on the RDS and choose properties





"PEREZ, RICHARD RINGO (SBCSI)" <[EMAIL PROTECTED]> on 11/10/2000
03:59:29 PM

Please respond to [EMAIL PROTECTED]

To:   CF-Talk <[EMAIL PROTECTED]>
cc:(bcc: Michael She/TOR/PBC)

Subject:  Problem on RDS




How can you delete the created Remote Hosts on the RDS? Previously my
connection to RDS is working when i changed my browser to MSIE 5 the i am
being asked to type in a "Enter Network Password". Anyone encountered this
problem?
---
-
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to
[EMAIL PROTECTED]







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

RE: Create Table Question

[Andy Ewings]

You've pretty much got ittry using text instead of varchar as the
datatype for the charachter fields.

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



-Original Message-
From: Will Ryan [mailto:[EMAIL PROTECTED]]
Sent: 13 November 2000 14:36
To: CF-Talk
Subject: Create Table Question


Greeting Guru's

  I'm trying to create a table in Access via CF. I need to create an
AutoNumber field for an ID.  I don't want to create it through access as I
would have to upload a 60 meg DB to our offsite server.  Any suggestions for
the SQL Statement?

create table T_AddBook (
AddID autonumber,
Name varchar (20),
Add1 varchar (40),
Add2 varchar (40)
)


Thanks,
 Will

Will Ryan
[EMAIL PROTECTED]
http://www.zerotoeighty.com
w: 410-327-9152
f: 410-327-4086



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

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

No Subject

[Andy Ewings]

Uhpleaws ignore my last mail..it was complete rubish!!

After seeing Mike's mail I have a feeling he is right.

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



-Original Message-
From: Andy Ewings 
Sent: 13 November 2000 15:07
To: '[EMAIL PROTECTED]'
Subject: RE: Create Table Question


You've pretty much got ittry using text instead of varchar as the
datatype for the charachter fields.

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



-Original Message-
From: Will Ryan [mailto:[EMAIL PROTECTED]]
Sent: 13 November 2000 14:36
To: CF-Talk
Subject: Create Table Question


Greeting Guru's

  I'm trying to create a table in Access via CF. I need to create an
AutoNumber field for an ID.  I don't want to create it through access as I
would have to upload a 60 meg DB to our offsite server.  Any suggestions for
the SQL Statement?

create table T_AddBook (
AddID autonumber,
Name varchar (20),
Add1 varchar (40),
Add2 varchar (40)
)


Thanks,
 Will

Will Ryan
[EMAIL PROTECTED]
http://www.zerotoeighty.com
w: 410-327-9152
f: 410-327-4086



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

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

.htr??

[Emmet McGovern]

Can someone provide me with a link to the info on allaire about the .htr
extension.  I cant seem to find it anywhere.

Thanks
Emmet McGovern


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

RE: Doubled Headers

[Scott Wolf]

My guess is that you have HTML headers in your application.cfm
file.  I've done that once or twice myself.  :P

Scott Wolf
Goodfriend Computer Training

-Original Message-
From: Guy J. McDowell [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 13, 2000 9:45 AM
To: CF-Talk
Subject: Doubled Headers


Hi CFFolks,

No this isn't about baseball.

Situation: when viewing source of my templates after being served from
our hosts the headers are doubled.
Example:



Untitled









O.F.A.H. - About Us










You can easily tell which is mine and which is not.

Question: Why is this happening and how can I correct it?

Thank you so much for your help in advance.

Yours In Conservation,

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

P.S. You may want to check out the fresh new look of www.OFAH.org
Launched 1st November 2000.
Don't forget our other great sites:
www.AuctionForWildlife.com - Your chance to make your bid for
conservation.
www.EcoEd.org - an online adventure for kids in grades 1 through 8.
www.HuntingDog.org - Celebrating our Hunting Dog Heritage.
www.AHTV.com - Your online companion to the Angler and Hunter
Television show.
www.OHEP.net -  Where to find out and learn about the Ontario Hunter
Education Program.





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

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

Command Line Programs

[Bill Poff]

Can anyone make a suggestion for the best way to run a command
line
application from within Cold Fusion?

 I need to execute something like:

command.exe
param param param

--Bill



---
  Web Hosting $14.95/mo  -  E-Commerce Hosting from
$24.95/mo
---
 ICN.NET  - INTERNET HOSTING - DEVELOPMENT - SUPPORT
SERVICES
Box 2570, Roanoke, VA 24010 - 540-343-8322 - Fax: 540-343-0691
---
Contact [EMAIL PROTECTED] for all support/site maintenance
issues


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

CFFile and large file sizes?

[Emmet McGovern]

I cant remember if ive seen this discussion before or not.  sorrry

Im trying to use cffile to upload some very large files  66-200megs each.
They just seem to take forever to upload across the network.  Ive had decent
success with smaller files of about 30 megs but they still take about 18-20
minutes each to upload.  This is going over the Lan so speed should be much
much faster.  Any clues?


Emmet McGovern

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

Re: Command Line Programs

[Todd Ashworth]

CFML Language Reference



Chapter 1 :  ColdFusion Tags

CFEXECUTE
Enables ColdFusion developers to execute any process on the server machine.

Syntax


NAME
Required. The full path name of the application that is to be executed.

Note: On Windows systems, you must specify the extension, for example, .exe,
as part of the application's name.

ARGUMENTS
Optional. Any command-line arguments that should be passed to the program.

If ARGUMENTS is specified as a string, it is processed as follows:

On Windows systems, the entire string is passed to the Windows process
control subsystem for parsing.
On UNIX, the string is tokenized into an array of arguments. The default
token separator is a space; arguments with embedded spaces may be delimited
by double quotes.
If ARGUMENTS is passed as an array, it is processed as follows:

On Windows systems, the array elements will be concatenated into a string of
tokens, separated by spaces. This string is then passed to the Windows
process control subsystem as above.
On UNIX, the elements of the ARGUMENTS array is copied into a corresponding
array of exec() arguments.
OUTPUTFILE
Optional. The file where the output of the program is to be directed. If
this is not specified, the output appears on the page from which it was
called.

TIMEOUT
Optional. Indicates how long in seconds the ColdFusion executing thread will
wait for the spawned process. Indicating a timeout of 0 is equivalent to the
non-blocking mode of executing. A very high timeout value is equivalent to a
blocking mode of execution. The default is 0; therefore, the ColdFusion
thread spawns a process and immediately returns without waiting for the
process to terminate.

If no output file is specified, and the timeout value is zero, then the
program's output will be directed to the bit bucket.

Usage
CFEXECUTE is available on Windows NT 4.0 and UNIX platforms. Do not put any
other ColdFusion tags or functions between the start and the end tags of
CFEXECUTE. Also, CFEXECUTE tags cannot be nested.

Exception
CFEXECUTE throws the following exceptions:

If the application name is not found, an Application File Not Found
exception will be thrown.
If the output file cannot be opened, an Output File Cannot be opened will be
thrown.
If the effective user of the ColdFusion executing thread does not have
permissions to execute the process, a security exception will be thrown.
The time out values must be between 0 and some high number (to be
determined).
Example



CFEXECUTE



CFEXECUTE

This example executes the Windows NT version of the netstat network
monitoring program, and places its output in a file.







Copyright © 1999, Allaire Corporation. All rights reserved.


Todd Ashworth

- Original Message -
From: "Bill Poff" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 13, 2000 10:17 AM
Subject: Command Line Programs


| Can anyone make a suggestion for the best way to run a command
| line
| application from within Cold Fusion?
| 
|  I need to execute something like:
| 
|
command.
exe
| param param param
| 
| --Bill
| 
|
| 
| ---
|   Web Hosting $14.95/mo  -  E-Commerce Hosting from
| $24.95/mo
| ---
|  ICN.NET  - INTERNET HOSTING - DEVELOPMENT - SUPPORT
| SERVICES
| Box 2570, Roanoke, VA 24010 - 540-343-8322 - Fax: 540-343-0691
| ---
| Contact [EMAIL PROTECTED] for all support/site maintenance
| issues
|
| --
--
| Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
| Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
|



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

RE: Command Line Programs

[CAlvarado]

in ColdFusion 4.5.x there is a Cold Fusion tag  (win)



chris.alvarado
cold.fusion - developer
[phone] 512.794.6563
[email] [EMAIL PROTECTED]
[web] http://www.tmanage.com


Privileged/Confidential Information may be contained in this message. It is
not for use or disclosure outside TManage without a written proprietary
agreement.  If you are not the addressee indicated in this message, or agent
responsible for delivery, you may not copy or deliver this message to
anyone.  Please notify the sender as soon as possible and immediately
destroy this message and its attachments entirely.



-Original Message-
From: Bill Poff [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 13, 2000 9:17 AM
To: CF-Talk
Subject: Command Line Programs


Can anyone make a suggestion for the best way to run a command
line
application from within Cold Fusion?

 I need to execute something like:

command.
exe
param param param

--Bill



---
  Web Hosting $14.95/mo  -  E-Commerce Hosting from
$24.95/mo
---
 ICN.NET  - INTERNET HOSTING - DEVELOPMENT - SUPPORT
SERVICES
Box 2570, Roanoke, VA 24010 - 540-343-8322 - Fax: 540-343-0691
---
Contact [EMAIL PROTECTED] for all support/site maintenance
issues



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

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

Re: .htr??

[Howie Hamlin]

Start with:

http://www.allaire.com/developer/securityzone/

And then you will see the link there.  The link is:

http://www.allaire.com/handlers/index.cfm?ID=15920&Method=Full

HTH,

Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
www.CoolFusion.com
631-737-4668 x101
inFusion Mail Server (iMS) - the World's most configurable mail server

- Original Message -
From: "Emmet McGovern" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 13, 2000 10:08 AM
Subject: .htr??


> Can someone provide me with a link to the info on allaire about the .htr
> extension.  I cant seem to find it anywhere.
>
> Thanks
> Emmet McGovern
> 
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]


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

Re: Create Table Question

[Gary Groomer]

Try the below:

create table T_AddBook (
> AddID COUNTER PRIMARY KEY,
> Name text(20),
> Add1 text(40),
> Add2 text(40)

Remove the PRIMARY KEY code if the filed is not to be a primary key.


Sincerely,

Gary Groomer

- Original Message -
From: "Will Ryan" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 13, 2000 6:36 AM
Subject: Create Table Question


> Greeting Guru's
>
>   I'm trying to create a table in Access via CF. I need to create an
> AutoNumber field for an ID.  I don't want to create it through access as I
> would have to upload a 60 meg DB to our offsite server.  Any suggestions
for
> the SQL Statement?
>
> create table T_AddBook (
> AddID autonumber,
> Name varchar (20),
> Add1 varchar (40),
> Add2 varchar (40)
> )
>
>
> Thanks,
>  Will
>
> Will Ryan
> [EMAIL PROTECTED]
> http://www.zerotoeighty.com
> w: 410-327-9152
> f: 410-327-4086
>
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>
>


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

Re: Command Line Programs

[Howie Hamlin]

You can try CFX_ConsoleCommand from
http://www.intrafoundation.com/freeware.html.

HTH,

Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
www.CoolFusion.com
631-737-4668 x101
inFusion Mail Server (iMS) - the World's most configurable mail server

- Original Message -
From: "Bill Poff" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 13, 2000 10:17 AM
Subject: Command Line Programs


> Can anyone make a suggestion for the best way to run a command
> line
> application from within Cold Fusion?
> 
>  I need to execute something like:
> 
>
command.
exe
> param param param
> 
> --Bill
> 
>
> 
> ---
>   Web Hosting $14.95/mo  -  E-Commerce Hosting from
> $24.95/mo
> ---
>  ICN.NET  - INTERNET HOSTING - DEVELOPMENT - SUPPORT
> SERVICES
> Box 2570, Roanoke, VA 24010 - 540-343-8322 - Fax: 540-343-0691
> ---
> Contact [EMAIL PROTECTED] for all support/site maintenance
> issues
>
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]


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

Re: Best Practices

[Greg Wolfinger]

> The reason?  PHP was written by coders who took pride in their work &
> made the best server they possibly knew how.  CF was written by
> coders who may well have possessed the same if not superior abilities
> but who were being driven by a marketing division that wanted the
> product out yesterday.  The result is a poorly written product that
> even after 5-odd upgrades, service packs, or whatever Allaire chooses
> to call them STILL has a huge number of functional flaws and serious
> speed & efficiency issues.

Actually, JJ wasn't expecting CF to become this giant application server and
be a product that thousands are using.  Just beacuse PHP is open source
doesn't mean it's better.  Allaire has some pretty smart guys working for
them and the developer base contributes vastly to CF as well. PHP is still
very underdeveloped and has a long way to go.

Best Regards,


Greg Wolfinger
- Original Message -
From: Zachary Bedell <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Friday, November 10, 2000 5:08 PM
Subject: RE: Best Practices


> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> 
>
> I might hazard a guess as to why the Java engine appears to be
> running faster than the C++ engine: the C++ engine has been a piece
> of junk since it was released.  I've no doubt that Allaire could get
> a Java based engine to run faster than the current CF engine.  If
> they took the time to write a well optimized C++ engine, I suspect it
> would be much, MUCH faster.
>
> Compare the speed of something like PHP to CF.  On a high level, PHP
> is doing exactly what CF does : open a file, parse the language to
> PCode, execute it, then return the results.  That's what the Java
> engine will do as well, parsing to Java bytecode in that case.  Yet
> even tho PHP & CF need to accomplish the same basic set of tasks, PHP
> can do the same thing MUCH faster than CF.
>
> The reason?  PHP was written by coders who took pride in their work &
> made the best server they possibly knew how.  CF was written by
> coders who may well have possessed the same if not superior abilities
> but who were being driven by a marketing division that wanted the
> product out yesterday.  The result is a poorly written product that
> even after 5-odd upgrades, service packs, or whatever Allaire chooses
> to call them STILL has a huge number of functional flaws and serious
> speed & efficiency issues.
>
> My apologies to whoever originally said this (and I believe someone
> on list either said it or uses it as his email sig, but...) "A
> product is only late once, but it can suck forever."  I wish that
> Allaire would take those words to heart, as I'm getting tired of
> working around their bugs AND my bugs to get a site working...
> 
>
> Okay...  My apologies for the on-list core dump.  Am I the only one
> who's long past fed up w/ Allaire's business practices?  Without a
> doubt they have a great product which makes my job (on the whole)
> easier.  It's just that they seem to consistently rush things out the
> door without sufficient testing.  At this point, I feel like a beta
> tester even when I'm opening a shrink wrapped final product.  As it
> is, I'm stuck using 4.0.1 because 4.5.x can't remain stable while
> running my code; and Allaire's tech support hasn't got a clue why...
> Very frustrating seeing as the same code runs on NT4 / CF4.0.1 with
> complete perfection and only requires a server reboot once every two
> months or so...
>
> Best regards,
> Zac Bedell
> 
> Zachary S. Bedell,
> Chief Technology Officer,
> Adirondack Technologies, Inc.
>
> Please include original message in any replies -- I get a
> lot of email every day, and I have a REALLY bad memory...
> So I don't always remember everything that was said.
> Thanks!
>
>
>
>
>
> > -Original Message-
> > From: David E. Crawford [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, November 10, 2000 4:42 PM
> > To: CF-Talk
> > Subject: Re: Best Practices
> >
> >
> > > That's all great, and I am looking forward to these improvements.
> > > However It's hard to believe that a Java engine will be
> > faster than a C++
> > engine.
> > >
> > > (The Java interpreter itself is written in C++. C++ is
> > compiled directly
> > to machine code. Think about it)
> > >
> >
> > Well, at least in theory, the demonstration during the
> > general assembly
> > seems to prove that the Java-based engine is faster.  Keep in
> > mind that this
> > is server side java which has had a great deal of
> > optimization attention
> > paid to it.
>
> -BEGIN PGP SIGNATURE-
> Version: PGPfreeware 6.5.8 for non-commercial use 
>
> iQA/AwUBOgxx+KvhLS1aWPxeEQKG5QCfYs5mIS6aEa5LDPmVs8E3TCXFYvEAnjt8
> huYj0zImvygkz08XYOEJyucQ
> =8SrH
> -END PGP SIGNATURE-
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsu

RE: Command Line Programs

[Simon Horwith]

On 4.5, use CFEXECUTE.  Otherwise, either use a storedproc or a CFX tag.  

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


-Original Message-
From: Bill Poff [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 13, 2000 10:17 AM
To: CF-Talk
Subject: Command Line Programs


Can anyone make a suggestion for the best way to run a command
line
application from within Cold Fusion?

 I need to execute something like:

command.
exe
param param param

--Bill



---
  Web Hosting $14.95/mo  -  E-Commerce Hosting from
$24.95/mo
---
 ICN.NET  - INTERNET HOSTING - DEVELOPMENT - SUPPORT
SERVICES
Box 2570, Roanoke, VA 24010 - 540-343-8322 - Fax: 540-343-0691
---
Contact [EMAIL PROTECTED] for all support/site maintenance
issues



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

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

RE: fusebox

[Stephen Moretti]

Jon,

>
> Everyone except those who dont have time to learn or care to
> learn Fusebox.
> When the day comes that someone dumps a site on me that was coded in
> Fusebox, and this is my main beef with the whole deal.
> It's going to take me LONGER to learn Fusebox and then go about adding the
> lastest widget!
>

I think that maybe you haven't seen any Fusebox code.

I write fusebox-esque code all the time.  Like everyone that use fusebox I
use different bits of the methodology, but all of us use the same basic
structure.

I recently had a guy who hasn't ever looked at fusebox pick up my code and
start making changes.  I asked if he had any questions, his was response was
'No, seems clear enough.'

Also, part of the fusebox concept is that you _can_ add new 'widgets'
without knowing what the other parts of the application are doing.  Part of
the reason that Steve Nelson et al. came up with Fusebox was to help them
with a large project that was being built by a number of remote developers.
Fusebox was developed to allow them to hand a section or circuit (e.g. the
search) from the whole application to a developer and he/she could build it
without needing to thing about the rest of the application.  All the parts
then came together under a common index.cfm to build the complete
application.

Regards

Stephen


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

Re: Create Table Question

[Joseph Thompson]

You can create autonumbers. use "Counter"
Adding default values seems a bit tricky, or not possible, I have tried and
tried on that point.

create table T_AddBook (
AddID counter,
Name text(20),
Add1 text(40),
Add2 text(40)
)




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

RE: Command Line Programs

[Mark Johnson]

CFEXECUTE

Mark

-Original Message-
From: Bill Poff [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 13, 2000 3:17 PM
To: CF-Talk
Subject: Command Line Programs


Can anyone make a suggestion for the best way to run a command
line
application from within Cold Fusion?

 I need to execute something like:

command.
exe
param param param

--Bill



---
  Web Hosting $14.95/mo  -  E-Commerce Hosting from
$24.95/mo
---
 ICN.NET  - INTERNET HOSTING - DEVELOPMENT - SUPPORT
SERVICES
Box 2570, Roanoke, VA 24010 - 540-343-8322 - Fax: 540-343-0691
---
Contact [EMAIL PROTECTED] for all support/site maintenance
issues



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


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

ODBC Error: Timeout Expired

[Geoffrey V. Brown]

Hi,
We are running SQL Server 7.0.  I'm getting "timeout expired" errors on one
script, which runs a lenthy query.  The CFQuery has a timeout attrib of
, and the script has a requesttimeout value of .  The error is still
occurring.

I'm thinking this must be a server config issue.  Any ideas on resolution?

Geoff B



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

cfhttp

[Peter Benoit]

How can I use cfhttp if the page doesn't exist?

I have a list of links, in case one doesn't exist anymore, I'd like to not
present it.  Is cfhttp the best way to do this?

Thanks,
Pete


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

question about stored procedures in Oracle

[Chen, Yung-Chih (CIT)]

Can I get the 5 queries result set back from executed one stored procedures
in Oracle?
That stored procedures contains 5 different queries.

thank you very much

YC

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

RE: [Cached Queries]

[Sandra Clark]

I do something like that but use an onChange event in my first select box to
run a combo CF/js script in a hidden frame to get only those items necessary
based on the first select statement.  Since I don't have to return the
entire state list for every country in the world each time, it executes
fairly quickly.

-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Sunday, November 12, 2000 8:32 AM
To: CF-Talk
Subject: Re: [Cached Queries]


On 11/12/00, W Luke penned:
>Excellent.  I basically have 2 queries that both return large amounts of
>records - the first being as you describe above - however the second is an
>interesting dilema.  I have a table called Locations, with "County" and
>"Town."  Using the cool TwoSelectsRelated tag, I'm populating both boxes
>(users choose a county - and then a town).  However with a current town
list
>of over 1600, and due to the fact that TwoSelectsRelated loads both columns
>of the table in their entirity, this takes *ages* to download.  Using
>TwoSelectsRelated is by far the nicest option available - but unfortunately
>I might have to change.
>
>Hopefully caching the query will speed things up a little anyhow.

I tried using it in my shopping cart also for countries and
states/territories. It was dreadfully slow, because of the huge
amount of javascript code that had to be loaded, and didn't work at
times probably due to the same thing. I ended up just going to an
extra screen to choose the state based on the country. An extra
click, but still much quicker.
--

Bud Schneehagen - Tropical Web Creations

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


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



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

RE: cfhttp

[Simon Horwith]

if they're local to the server, you should use CFFILE to test for their
existence, otherwise, yes... use CFHTTP to test for it's existence.

~Simon

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


-Original Message-
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 13, 2000 10:52 AM
To: CF-Talk
Subject: cfhttp


How can I use cfhttp if the page doesn't exist?

I have a list of links, in case one doesn't exist anymore, I'd like to not
present it.  Is cfhttp the best way to do this?

Thanks,
Pete



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

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

RE: please recommend cf host

[Arden Weiss]

www.Edgewebhosting.com has worked very very well for me -- standard price 
-- execlent/fast tech support -- they know CF -- talk with Bill Riley or 
Vlad...

Arden Weiss
410-757-3487

-Original Message-
From:   Michael She [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, November 13, 2000 9:43 AM
To: CF-Talk
Subject:RE: please recommend cf host




www.crystaltech.com.  Cheap prices, large feature set, and extremely good
tech support.






"Jason Egan" <[EMAIL PROTECTED]> on 11/10/2000 01:45:49 PM

Please respond to [EMAIL PROTECTED]

To:   CF-Talk <[EMAIL PROTECTED]>
cc:(bcc: Michael She/TOR/PBC)

Subject:  RE: please recommend cf host




konnections
801-621-8511

-Original Message-
From: Michael Slatoff [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 10, 2000 9:49 AM
To: CF-Talk
Subject: Re: please recommend cf host


Try using CFHosting
www.cfhosting.com


"Philip Denlinger" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I am a fledgling cf user and am looking for a cf host.
>
> This site is the archives of a science journal, with
> abstracts in HTML, and full text articles in PDF.
>
> Here are the characteristics of the site:
>
> NEEDS:
> -
>
> Traffic:  Average 250 megs transfer per month
>
> Disk space:  Currently 470 megs, grows by 125 megs per year
>
> Needs: Verity collection to index PDF
>
> Needs: CFCONTENT tag to push PDF to registered users who are granted
access
> by IP or by userid/password.
>
> Access database
>
> Site (currently unix) at: 
>
> If you are recommending a host, please include the address of your
> site located at that host. With your permission, I will run a
> Netmechanic Serverwatch for 8 hours to check out your host's
> performance.
>
> 
>
> Thanks.
>
>
>
--
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]


---
-

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

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






  

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

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

RE: SQL error (minus the mess)

[Christopher Olive, CIO]

no worries.  that's what we're all here for.

although i'd have to question what kind of ISP turns off SELECT priveledges
for an ODBC datasource. :)

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Kylie Lovelock [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 13, 2000 5:31 AM
To: CF-Talk
Subject: Re: SQL error (minus the mess)


Thankyou Thankyou (as I smile until my cheeks hurt)
I forwarded your suggestion through to my ISP - he followed your
instructions and it works like a charm.

Did I say Thankyou? - Thankyou

Cheers
Kylie

- Original Message -
From: "Christopher Olive, CIO" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 13, 2000 4:42 PM
Subject: RE: SQL error (minus the mess)


> ok, second round.
>
> when setting up the datasource, did you restrict access to the SQL command
> set?  in the CFAdministrator, under "ODBC Datasources", select the DSN in
> question.  choose "Advanced>>", and make sure that "SELECT" is checked.
>
> chris olive, cio
> cresco technologies
> [EMAIL PROTECTED]
> http://www.crescotech.com
>
>
>
> -Original Message-
> From: Kylie Lovelock [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 13, 2000 2:46 AM
> To: CF-Talk
> Subject: Re: SQL error (minus the mess)
>
>
> Thanks for taking the time Christopher. I removed the username and
password
> from my CFQUERY - but still receiving the same error of SQL operation
> unauthorized.
>
> Cheers
> Kylie
> - Original Message -
> From: "Christopher Olive, CIO" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, November 13, 2000 3:29 PM
> Subject: RE: SQL error (minus the mess)
>
>
> > at just a quick glance, is the username/password combination valid for
> that
> > database?  did you give access to the user "username"?  access by
default
> > does not have security.  try removing the username and password
attributes
> > from your CFQUERY.
> >
> > chris olive, cio
> > cresco technologies
> > [EMAIL PROTECTED]
> > http://www.crescotech.com
> >
> >
> >
>
>
> --
--
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a
> message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>



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


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

CFUPDATE and CFINSERT

[Greg Wolfinger]

This is a multi-part message in MIME format.

--=_NextPart_000_000D_01C04CFD.14A3F460
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hey Guys:

I've herd some people say NEVER to use CFUPDATE and CFINSERT.  Is this =
true and if so whyor when should I use the cf commands and when =
should I use SQL?

Thanx,


Greg Wolfinger

--=_NextPart_000_000D_01C04CFD.14A3F460
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








Hey Guys:
 
I've herd some people say NEVER to use =
CFUPDATE and=20
CFINSERT.  Is this true and if so whyor when should I use the =
cf=20
commands and when should I use SQL?
 
Thanx,
 
 
Greg =
Wolfinger

--=_NextPart_000_000D_01C04CFD.14A3F460--


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

RE: fusebox

[Gavin Myers]

I think it would be nice if there was a spot where we could put the most
common topics on this discussion board. 

For example: A fusebox pro / con. Two seasoned cf coders one that is for
fusebox, one that is against fusebox that are willing to write a page or
five describing the benifits/drawbacks of the methodolgy.

I strongly believe that methodogies are crucial when dealing with a large
group of coders. You can't have all 12 programmers doing their own format of
code, that would be messy and difficult to backtrack.

People who do their own programming without large groups of coders may not
see the importance of methodologies. Because, what does it matter if it
works? I can read it just fine. I belive that is a valid point. But for
large scale operations that involves several departments/groups/people one
single format is necessary for maximum effeciency

Wether or not fusebox is that methodogy i can honestly say i dont know, i've
paged through the free paper on it. I picked out somethings I thought were
cool and adapted them into my own format (like putting queries in their own
file and cfincluding them, that's a good idea). But I am in no means a
seasoned fusebox vetran.

Short: 
We've had this discussion a thousand times, and still havent found any good
ground. We need a reference of two programmers, one who is pro-fusebox and
willing to write out what he likes/dislikes, another programmer who is
anti-fusebox and willing to write out what he likes/dislikes.

I'd like to see the other methologies that are out there though,

Thanks,
Gavin

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

Re: cfhttp

[Craig Bowes]

Peter,

You do this by using cfhttp as follows:





 some link here


The only problem is, for every link that needs to be checked, cfhttp will
take a while to check the page and thus slow down YOUR page that has the
links.  CFHTTP is kind of slow.  A better way to do this would be to
database all your links, then create a scheduled task that checks all the
links at once, maybe once a day or month or so,  and and alters the database
as to whether or not each one has an error or connection failure.  Then you
run a query against this database checking the status of each link the last
time it was checked and displaying it or not based on what it finds in the
database.  If your links are already stored in a database, this will be easy
because you'll just have to add another bit field and call it "validlink" or
something.

-Craig Bowes
Coldfusion Programmer
[EMAIL PROTECTED]
972.243.1171

- Original Message -
From: "Peter Benoit" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 13, 2000 9:52 AM
Subject: cfhttp


> How can I use cfhttp if the page doesn't exist?
>
> I have a list of links, in case one doesn't exist anymore, I'd like to not
> present it.  Is cfhttp the best way to do this?
>
> Thanks,
> Pete
>
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>


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

RE: please recommend cf host

[CAlvarado]

another GREAT host is http://www.communitech.net

VERY reliable, helpful and full of features.

chris.alvarado
cold.fusion - developer
[phone] 512.794.6563
[email] [EMAIL PROTECTED]
[web] http://www.tmanage.com


Privileged/Confidential Information may be contained in this message. It is
not for use or disclosure outside TManage without a written proprietary
agreement.  If you are not the addressee indicated in this message, or agent
responsible for delivery, you may not copy or deliver this message to
anyone.  Please notify the sender as soon as possible and immediately
destroy this message and its attachments entirely.



-Original Message-
From: Arden Weiss [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 13, 2000 10:08 AM
To: CF-Talk
Cc: Bill Riley (E-mail)
Subject: RE: please recommend cf host


www.Edgewebhosting.com has worked very very well for me -- standard price 
-- execlent/fast tech support -- they know CF -- talk with Bill Riley or 
Vlad...

Arden Weiss
410-757-3487

-Original Message-
From:   Michael She [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, November 13, 2000 9:43 AM
To: CF-Talk
Subject:RE: please recommend cf host




www.crystaltech.com.  Cheap prices, large feature set, and extremely good
tech support.






"Jason Egan" <[EMAIL PROTECTED]> on 11/10/2000 01:45:49 PM

Please respond to [EMAIL PROTECTED]

To:   CF-Talk <[EMAIL PROTECTED]>
cc:(bcc: Michael She/TOR/PBC)

Subject:  RE: please recommend cf host




konnections
801-621-8511

-Original Message-
From: Michael Slatoff [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 10, 2000 9:49 AM
To: CF-Talk
Subject: Re: please recommend cf host


Try using CFHosting
www.cfhosting.com


"Philip Denlinger" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I am a fledgling cf user and am looking for a cf host.
>
> This site is the archives of a science journal, with
> abstracts in HTML, and full text articles in PDF.
>
> Here are the characteristics of the site:
>
> NEEDS:
> -
>
> Traffic:  Average 250 megs transfer per month
>
> Disk space:  Currently 470 megs, grows by 125 megs per year
>
> Needs: Verity collection to index PDF
>
> Needs: CFCONTENT tag to push PDF to registered users who are granted
access
> by IP or by userid/password.
>
> Access database
>
> Site (currently unix) at: 
>
> If you are recommending a host, please include the address of your
> site located at that host. With your permission, I will run a
> Netmechanic Serverwatch for 8 hours to check out your host's
> performance.
>
> 
>
> Thanks.
>
>
>
--
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]


---
-

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

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






  

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


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

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

COM Problem....

[Simon Horwith]

Hello All:
I'm debugging an obscure problem, and thought I'd throw you all something to
think about.
I'm running several COM OBJECT methods from various third party COM OBJECTS,
on the same page (via custom tags I've written).  I continuously receive
either "
Error Occurred While Processing Request
Error Diagnostic Information Server busy or unable to fulfill request. The
server is unable to fulfill your request due to extremely high traffic or an
unexpected internal error. Please attempt your request again (if you are
repeatedly unsuccessful you should notify the site administrator). (Location
Code: 25)   
", or the page just processes without timing out until the server crashes.
Once it has run once successfully (after several service restarts and
template calls), all subsequent requests seem to load fine.  I know my
syntax is fine, and I've tried every imagineable threading configuration
amongst the objects... still with no success.  I'm currently in the process
of determining which object is creating the problem, but thought I'd write
and see if anyone knows of anything I might not have tried yet. other
than writing my own COM Wrapper (that's not an adequate solution).  Bottom
line, I need to optimize the first initialization of the object...after
that, I'm OK.  Right now, my primary culprit suspect is the actual CF Server
(I'm running 4.5 SP2 BETA).I've got a feeling this CFServer version is
not stable in how it handles COM, but am hoping to try other work arounds
before "downgrading" my server version.

Anybody have any ideas?

~Simon

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

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

Re: intranet apps

[Joseph Thompson]

In time this project may be quite nice.

try this:
ftp:  u8ntcn0.com (port 1969)
username: open
password: source

should be a calendar.zip sitting there, with the readm.txt zipped inside of
that.

Happy hacking : )


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

RE: XML / XSL

[Shawn Regan]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--_=_NextPart_001_01C04D8F.0DA7FB20
Content-Type: text/plain;
charset="iso-8859-1"

There is a custom tag out there that did just that using cfobject and MSDOM.


Shawn Regan
[EMAIL PROTECTED]
Cold Fusion Developer
Pacific Technology Solutions


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 09, 2000 10:36 AM
To: CF-Talk
Subject: RE: XML / XSL


Good grief!  That's a lot of errors!

It would be nice if there was a custom tag that did the following:



Then you could output the variable "nameOfCFVariableToStoreResultIn" to the
user's browser.

The Lotus version seems to be close to this but requires output to a file
which means doing a file write and then a read as well as a delete for
housekeeping purposes.  That's very inefficient for page processing.

Any suggestions?

--Doug

-Original Message-
From: David Gassner [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 03, 2000 4:17 AM
To: [EMAIL PROTECTED]
Subject: RE: XML / XSL


To use Lotusxsl for transformations, the classpath in the CF Administrator
needs to include full paths to these files:
xalan.jar
Lotusxsl.jar

For instance:

c:\lotusxsl\lotusxsl.jar;c:\lotusxsl\xalan.jar

As Sean Renet pointed out awhile back, the KB article has some fatal errors.
Here are the fixes you need to apply to get it working:

1.  If you copy the example XSL file from the website, the 
tag's xmlns:xsl attribute value is broken into 2 lines, causing the xsl
processor to fail completely.  Instead of doing the transformation, it just
outputs the content of the original xsl file.  The namespace needs to be in
a continuous line, as follows:

http://www.w3.org/1999/XSL/Transform">

2.  The printWriter class isn't being closed, so the file containing the
wddx isn't being flushed to disk.  Add the following to the end of the code:



3.  The resulting processed file isn't being read into a CF variable, so
add:



4.  When you try to run  to transform the wddx to a structure,
you'll get:

Error Diagnostic Information
unknown exception condition
TagCFWddx::execute

There is an error in the XSL file.  The "item" element is being mapped to a
named structure.  Since it's a structure within an array, it can't take a
name, causing the WDDX parser to fail.  Here's the corrected XSL file:


http://www.w3.org/1999/XSL/Transform">






































































> -Original Message-
> From: dave fauth [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 02, 2000 5:32 PM
> To: [EMAIL PROTECTED]
> Subject: Re: XML / XSL
>
>
> Cary,
>
> It is an Allaire KB:
>
> http://www.allaire.com/handlers/index.cfm?ID=14244&Method=Full
>
> Also, you may want to check here:
>
> http://www.sys-con.com/xml/archives/0102/gassner/index.html
>
> dave
>
> At 08:28 AM 8/2/00 -0700, you wrote:
> >What KB article would that be?  I searched xml, xsl and lotus and found
> >nothing like what you mentioned.
> >
> >Cary
> >
> >At 09:13 AM 8/2/2000 -0400, you wrote:
> >>Doug,
> >>
> >>I'm just getting started in XML/XSL with CF.  I've looked at the KB
> >>article from Allaire on it and have downloaded the Lotus XML parser.
> >>
> >>One question I have is how the set the Class Path.  The Lotus parser
> >>documentation isn't really clear on it.  It seems like there is
> a place in
> >>the CF administrator but there must be another place to do it.
> Anybody's
> >>help would be appreciated.
> >>
> >>I'm looking to both read XML into WDDX and also convert WDDX
> into XML via
> XSL.
> >>
> >>What kind of things are you doing with XML?
> >>
> >>dave
> >
> >-
> --
> ---
> >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.
> >
> >
> ---
> dave fauth
> [EMAIL PROTECTED]
>
> "The opinions expressed here
> are my own and not those of
> DOMAIN technologies, inc."
> --
> 
> 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-

RE: please recommend cf host

[Andy Goodson]

http://www.needa.com   Strong CF resources, good pricing, excellent 
customer service.

At 11:08 AM 11/13/00 -0500, you wrote:
>www.Edgewebhosting.com has worked very very well for me -- standard price
>-- execlent/fast tech support -- they know CF -- talk with Bill Riley or
>Vlad...
>
>Arden Weiss
>410-757-3487
>
>-Original Message-
>From:   Michael She [SMTP:[EMAIL PROTECTED]]
>Sent:   Monday, November 13, 2000 9:43 AM
>To: CF-Talk
>Subject:RE: please recommend cf host
>
>
>
>
>www.crystaltech.com.  Cheap prices, large feature set, and extremely good
>tech support.
>
>
>
>
>
>
>"Jason Egan" <[EMAIL PROTECTED]> on 11/10/2000 01:45:49 PM
>
>Please respond to [EMAIL PROTECTED]
>
>To:   CF-Talk <[EMAIL PROTECTED]>
>cc:(bcc: Michael She/TOR/PBC)
>
>Subject:  RE: please recommend cf host
>
>
>
>
>konnections
>801-621-8511
>
>-Original Message-
>From: Michael Slatoff [mailto:[EMAIL PROTECTED]]
>Sent: Friday, November 10, 2000 9:49 AM
>To: CF-Talk
>Subject: Re: please recommend cf host
>
>
>Try using CFHosting
>www.cfhosting.com
>
>
>"Philip Denlinger" <[EMAIL PROTECTED]> wrote in message
>[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > I am a fledgling cf user and am looking for a cf host.
> >
> > This site is the archives of a science journal, with
> > abstracts in HTML, and full text articles in PDF.
> >
> > Here are the characteristics of the site:
> >
> > NEEDS:
> > -
> >
> > Traffic:  Average 250 megs transfer per month
> >
> > Disk space:  Currently 470 megs, grows by 125 megs per year
> >
> > Needs: Verity collection to index PDF
> >
> > Needs: CFCONTENT tag to push PDF to registered users who are granted
>access
> > by IP or by userid/password.
> >
> > Access database
> >
> > Site (currently unix) at: 
> >
> > If you are recommending a host, please include the address of your
> > site located at that host. With your permission, I will run a
> > Netmechanic Serverwatch for 8 hours to check out your host's
> > performance.
> >
> > 
> >
> > Thanks.
> >
> >
> >
>--
>--
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
>a message with 'unsubscribe' in the body to
>[EMAIL PROTECTED]
>
>
>---
>-
>
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
>message with 'unsubscribe' in the body to
>[EMAIL PROTECTED]
>
>---
>-
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
>message with 'unsubscribe' in the body to
>[EMAIL PROTECTED]
>
>
>
>
>
>
>
>
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
>message with 'unsubscribe' in the body to
>[EMAIL PROTECTED]
>
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send 
>a message with 'unsubscribe' in the body to [EMAIL PROTECTED]



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

Re: please recommend cf host

[Jake Hileman - Patmos]

www.superiorhosts.com

jake
- Original Message -
From: "Arden Weiss" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Cc: "Bill Riley (E-mail)" <[EMAIL PROTECTED]>
Sent: Monday, November 13, 2000 11:08 AM
Subject: RE: please recommend cf host


> www.Edgewebhosting.com has worked very very well for me -- standard price
> -- execlent/fast tech support -- they know CF -- talk with Bill Riley or
> Vlad...
>
> Arden Weiss
> 410-757-3487
>
> -Original Message-
> From: Michael She [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, November 13, 2000 9:43 AM
> To: CF-Talk
> Subject: RE: please recommend cf host
>
>
>
>
> www.crystaltech.com.  Cheap prices, large feature set, and extremely good
> tech support.
>
>
>
>
>
>
> "Jason Egan" <[EMAIL PROTECTED]> on 11/10/2000 01:45:49 PM
>
> Please respond to [EMAIL PROTECTED]
>
> To:   CF-Talk <[EMAIL PROTECTED]>
> cc:(bcc: Michael She/TOR/PBC)
>
> Subject:  RE: please recommend cf host
>
>
>
>
> konnections
> 801-621-8511
>
> -Original Message-
> From: Michael Slatoff [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 10, 2000 9:49 AM
> To: CF-Talk
> Subject: Re: please recommend cf host
>
>
> Try using CFHosting
> www.cfhosting.com
>
>
> "Philip Denlinger" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > I am a fledgling cf user and am looking for a cf host.
> >
> > This site is the archives of a science journal, with
> > abstracts in HTML, and full text articles in PDF.
> >
> > Here are the characteristics of the site:
> >
> > NEEDS:
> > -
> >
> > Traffic:  Average 250 megs transfer per month
> >
> > Disk space:  Currently 470 megs, grows by 125 megs per year
> >
> > Needs: Verity collection to index PDF
> >
> > Needs: CFCONTENT tag to push PDF to registered users who are granted
> access
> > by IP or by userid/password.
> >
> > Access database
> >
> > Site (currently unix) at: 
> >
> > If you are recommending a host, please include the address of your
> > site located at that host. With your permission, I will run a
> > Netmechanic Serverwatch for 8 hours to check out your host's
> > performance.
> >
> > 
> >
> > Thanks.
> >
> >
> >
> --
> --
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
send
> a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
>
>
> --
-
> -
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a
> message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
>
> --
-
> -
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a
> message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
>
>
>
>
>
>
> 
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a
> message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]


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

Re: cfhttp

[Dick Applebaum]

Pete

Use CFHTTP with a reasonably low timeout

If either the time expires or the returned content contains a 404 
message, the link is invalid.

HTH

Dick




At 10:52 AM -0500 11/13/00, Peter Benoit wrote:
>How can I use cfhttp if the page doesn't exist?
>
>I have a list of links, in case one doesn't exist anymore, I'd like to not
>present it.  Is cfhttp the best way to do this?
>
>Thanks,
>Pete

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

RE: please recommend cf host

[Eric J Hoffman]

www.corpsite.com

Used them with great success and quick tech support over the last two years.
They have provided very reliable CF hosting with decent prices on their
packages.

Good luck.

Eric J Hoffman, MAIP
Director of Internet Development
Small Dog Design

-Original Message-
From: Michael She [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 13, 2000 8:43 AM
To: CF-Talk
Subject: RE: please recommend cf host





www.crystaltech.com.  Cheap prices, large feature set, and extremely good
tech support.






"Jason Egan" <[EMAIL PROTECTED]> on 11/10/2000 01:45:49 PM

Please respond to [EMAIL PROTECTED]

To:   CF-Talk <[EMAIL PROTECTED]>
cc:(bcc: Michael She/TOR/PBC)

Subject:  RE: please recommend cf host




konnections
801-621-8511

-Original Message-
From: Michael Slatoff [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 10, 2000 9:49 AM
To: CF-Talk
Subject: Re: please recommend cf host


Try using CFHosting
www.cfhosting.com


"Philip Denlinger" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I am a fledgling cf user and am looking for a cf host.
>
> This site is the archives of a science journal, with
> abstracts in HTML, and full text articles in PDF.
>
> Here are the characteristics of the site:
>
> NEEDS:
> -
>
> Traffic:  Average 250 megs transfer per month
>
> Disk space:  Currently 470 megs, grows by 125 megs per year
>
> Needs: Verity collection to index PDF
>
> Needs: CFCONTENT tag to push PDF to registered users who are granted
access
> by IP or by userid/password.
>
> Access database
>
> Site (currently unix) at: 
>
> If you are recommending a host, please include the address of your
> site located at that host. With your permission, I will run a
> Netmechanic Serverwatch for 8 hours to check out your host's
> performance.
>
> 
>
> Thanks.
>
>
>
--
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]


---
-

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

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








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


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

RE: CFFile and large file sizes?

[Matt Wisdom]

CFFile writes uploaded files to memory. I guess you are hitting swap...

Matt

> -Original Message-
> From: Emmet McGovern [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 13, 2000 9:15 AM
> To: CF-Talk
> Subject: CFFile and large file sizes?
> 
> 
> I cant remember if ive seen this discussion before or not.  sorrry
> 
> Im trying to use cffile to upload some very large files  66-200megs each.
> They just seem to take forever to upload across the network.  Ive 
> had decent
> success with smaller files of about 30 megs but they still take 
> about 18-20
> minutes each to upload.  This is going over the Lan so speed 
> should be much
> much faster.  Any clues?
> 
> 
> Emmet McGovern
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
> or send a message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]
> 

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

RE: CFUPDATE and CFINSERT

[Simon Horwith]

if you need to churn something out really quick, you can use them.  I've had
some bad experiences with them, and personally prefer to have control over
all my SQL Syntax, anyway.  I'd avoid them, as a general rule of thumb.
Besides, you can just drag and drop your column names from the Studio
DataSource Resource pane to the template rather than typing them out, so
it's not like you're really going to suffer much as far as development time
goes.

~Simon

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


-Original Message-
From: Greg Wolfinger [mailto:[EMAIL PROTECTED]]
Sent: Sunday, November 12, 2000 11:06 PM
To: CF-Talk
Subject: CFUPDATE and CFINSERT


This is a multi-part message in MIME format.

--=_NextPart_000_000D_01C04CFD.14A3F460
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hey Guys:

I've herd some people say NEVER to use CFUPDATE and CFINSERT.  Is this =
true and if so whyor when should I use the cf commands and when =
should I use SQL?

Thanx,


Greg Wolfinger

--=_NextPart_000_000D_01C04CFD.14A3F460
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








Hey Guys:
 
I've herd some people say NEVER to use =
CFUPDATE and=20
CFINSERT.  Is this true and if so whyor when should I use the =
cf=20
commands and when should I use SQL?
 
Thanx,
 
 
Greg =
Wolfinger

--=_NextPart_000_000D_01C04CFD.14A3F460--



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

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

RE: CFUPDATE and CFINSERT

[CAlvarado]

I just prefer to write my own queries, thus I can control more things at run
time (functions etc), not to mention I don't always have my variables named
the same as the column names.

chris.alvarado
cold.fusion - developer
[phone] 512.794.6563
[email] [EMAIL PROTECTED]
[web] http://www.tmanage.com


Privileged/Confidential Information may be contained in this message. It is
not for use or disclosure outside TManage without a written proprietary
agreement.  If you are not the addressee indicated in this message, or agent
responsible for delivery, you may not copy or deliver this message to
anyone.  Please notify the sender as soon as possible and immediately
destroy this message and its attachments entirely.



-Original Message-
From: Greg Wolfinger [mailto:[EMAIL PROTECTED]]
Sent: Sunday, November 12, 2000 10:06 PM
To: CF-Talk
Subject: CFUPDATE and CFINSERT


This is a multi-part message in MIME format.

--=_NextPart_000_000D_01C04CFD.14A3F460
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hey Guys:

I've herd some people say NEVER to use CFUPDATE and CFINSERT.  Is this =
true and if so whyor when should I use the cf commands and when =
should I use SQL?

Thanx,


Greg Wolfinger

--=_NextPart_000_000D_01C04CFD.14A3F460
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








Hey Guys:
 
I've herd some people say NEVER to use =
CFUPDATE and=20
CFINSERT.  Is this true and if so whyor when should I use the =
cf=20
commands and when should I use SQL?
 
Thanx,
 
 
Greg =
Wolfinger

--=_NextPart_000_000D_01C04CFD.14A3F460--



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

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

Date Manipulation?

[Willy Ray]

Ok, I have a date.  I need to add a day, or a number of days.  How the devil does one 
do this?


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

Re: fusebox

[Todd Ashworth]

| I'd like to see the other methologies that are out there though,
| 
| Thanks,
| Gavin

www.switch-box.org

www.black-box.org

Todd Ashworth



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

RE: CFUPDATE and CFINSERT

[Andy Ewings]

As a die hard SQL programmer I never use CF to take care of the database
stuff.  I leave that to the database (makes sense to me)  In fact, when
using SQL, I hardly ever use CFQuery as I always use CFSTOREDPROC as you
will see improved performance.

However I wouldn't say never to use CFINSERT and CFUPDATE.  If you want to
run Basic sql queries that simply take a bunch of form values and insert
them into a table then CFINSERT would work ok.  It is particularly useful if
you have a lot of fields to insert into as you aren't required to list them.
However if you need to do more complex stuff in your SQL statement (like
insert the results of a select statement, or manipulate the form values
before inserting them) then you will have to use INSERT instead of CFINSERT.
The same argument applies to CFUPDATE vs UPDATE but i addition you are only
able to update one row in a table using CFUPDATE.

I can understand why some people say never to use CFINSERT or CFUPDATE as
you are asking CF to generate the SQL for you and this is taking the owness
off of the DB.  But in my view if you are only doing something very small
and simple then the CF commands are of use. 

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



-Original Message-
From: Greg Wolfinger [mailto:[EMAIL PROTECTED]]
Sent: 13 November 2000 04:06
To: CF-Talk
Subject: CFUPDATE and CFINSERT


This is a multi-part message in MIME format.

--=_NextPart_000_000D_01C04CFD.14A3F460
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hey Guys:

I've herd some people say NEVER to use CFUPDATE and CFINSERT.  Is this =
true and if so whyor when should I use the cf commands and when =
should I use SQL?

Thanx,


Greg Wolfinger

--=_NextPart_000_000D_01C04CFD.14A3F460
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








Hey Guys:
 
I've herd some people say NEVER to use =
CFUPDATE and=20
CFINSERT.  Is this true and if so whyor when should I use the =
cf=20
commands and when should I use SQL?
 
Thanx,
 
 
Greg =
Wolfinger

--=_NextPart_000_000D_01C04CFD.14A3F460--



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

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

RE: Date Manipulation?

[Andy Ewings]

Use the DateAdd function like so...

#DateAdd(d,2,mydate)#

This adds 2 days to the variable mydate.  

If you are using ColdFusion studio have a look at the help file for the full
syntax

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



-Original Message-
From: Willy Ray [mailto:[EMAIL PROTECTED]]
Sent: 13 November 2000 16:34
To: CF-Talk
Subject: Date Manipulation?



Ok, I have a date.  I need to add a day, or a number of days.  How the devil
does one do this?



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

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

RE: COM Problem....

[Neil Clark]

Are you explicitly calling the page or are you using a 'Live Data' feature?
If you are try changing the URL (if local) to 127.0.0.1 or (if remote/local)
to the machine name)...

Neil

http://www.mcbdigital.com
--->




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

Re: please recommend cf host

[AustralianAccommodation.com Pty. Ltd.]

try viewing www.cfhub.com for reviews and guidance to a quality cf host service
- Original Message - 
From: "Eric J Hoffman" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, November 14, 2000 2:41 AM
Subject: RE: please recommend cf host


www.corpsite.com

Used them with great success and quick tech support over the last two years.
They have provided very reliable CF hosting with decent prices on their
packages.

Good luck.

Eric J Hoffman, MAIP
Director of Internet Development
Small Dog Design

-Original Message-
From: Michael She [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 13, 2000 8:43 AM
To: CF-Talk
Subject: RE: please recommend cf host





www.crystaltech.com.  Cheap prices, large feature set, and extremely good
tech support.






"Jason Egan" <[EMAIL PROTECTED]> on 11/10/2000 01:45:49 PM

Please respond to [EMAIL PROTECTED]

To:   CF-Talk <[EMAIL PROTECTED]>
cc:(bcc: Michael She/TOR/PBC)

Subject:  RE: please recommend cf host




konnections
801-621-8511

-Original Message-
From: Michael Slatoff [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 10, 2000 9:49 AM
To: CF-Talk
Subject: Re: please recommend cf host


Try using CFHosting
www.cfhosting.com


"Philip Denlinger" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I am a fledgling cf user and am looking for a cf host.
>
> This site is the archives of a science journal, with
> abstracts in HTML, and full text articles in PDF.
>
> Here are the characteristics of the site:
>
> NEEDS:
> -
>
> Traffic:  Average 250 megs transfer per month
>
> Disk space:  Currently 470 megs, grows by 125 megs per year
>
> Needs: Verity collection to index PDF
>
> Needs: CFCONTENT tag to push PDF to registered users who are granted
access
> by IP or by userid/password.
>
> Access database
>
> Site (currently unix) at: 
>
> If you are recommending a host, please include the address of your
> site located at that host. With your permission, I will run a
> Netmechanic Serverwatch for 8 hours to check out your host's
> performance.
>
> 
>
> Thanks.
>
>
>
--
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]


---
-

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

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








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


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


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

Security and SQL

[Kevin Schmidt]

I pass a few values through URL variable that I use in where clauses in my
SQL.  I want to prevent someone from passing malicious SQL through that
value.  What are my options??

Kevin Schmidt
Internet Services Director
PWB Integrated Marketing and Communications
Office: 734.995.5000
Mobile: 734.649.4843




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

RE: cfhttp

[Robert Segal]

The cfhttp.filecontent variable will hold whatever is returned by the cfhttp
request.  If you are  on a browser requesting a page that doesn't exist,
you'll get back a 404 error or whatever which you can parse to look for the
page not found error.

-Original Message-
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 13, 2000 10:52 AM
To: CF-Talk
Subject: cfhttp


How can I use cfhttp if the page doesn't exist?

I have a list of links, in case one doesn't exist anymore, I'd like to not
present it.  Is cfhttp the best way to do this?

Thanks,
Pete



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

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

RE: COM Problem....

[Simon Horwith]

This is COM, not DCOM, and I'm calling the object within a custom tag... all
on the local machine.  I am using 127.0.0.1 to reference my server, and the
URL has nothing to do with this error, anyway.  Without a doubt, this is
some sort of bug in the thread model for the COM Objects, or (most likely) a
CF Enterprise Server 4.5.1 SP 2 Beta bug.  I've already reported the bug to
allaire beta, but am looking for debugging alternatives and/or solutions
that I ma not have expedited yet.  Thanks anyway, though.

~Simon

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


-Original Message-
From: Neil Clark [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 13, 2000 12:24 PM
To: CF-Talk
Subject: RE: COM Problem


Are you explicitly calling the page or are you using a 'Live Data' feature?
If you are try changing the URL (if local) to 127.0.0.1 or (if remote/local)
to the machine name)...

Neil

http://www.mcbdigital.com
--->





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

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

RE: cfhttp

[Ron Anderson]

Could you check to see if the mime type is .html or .cfm?
If not, then cancel the action.

-Original Message-
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 13, 2000 7:52 AM
To: CF-Talk
Subject: cfhttp


How can I use cfhttp if the page doesn't exist?

I have a list of links, in case one doesn't exist anymore, I'd like to not
present it.  Is cfhttp the best way to do this?

Thanks,
Pete



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

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

RE: cfhttp - java code to get status only

[JustinMacCarthy]

Just for fun...
Here is some java to just request the Http Status code (200 ok , 404
etc.)from a URL , it *should* be much faster than using cfhttp ... wrap it
up in a java cfx , and there you go.
Good exercise for you :-)

If you need help give me a shout and I'll get to it a some stage :-)

Justin

To run the class as is , if you have the JDK installed just run

javac Main.java

and then

java Main

>From the cmd line

http://www.allaire.com is hardcorded in ...


//-- java code -
import java.net.*;
import java.io.*;

class Main {
public static void main (String[] args)
{
int responseCode;
HttpURLConnection connection;


try
{
URL url = new URL("http://www.allaire.com");
connection = (HttpURLConnection)url.openConnection();
responseCode = connection.getResponseCode();
System.out.println("Status: " + responseCode );


}
 catch (MalformedURLException e)
 {
e.printStackTrace();

}
 catch (IOException e) {
   e.printStackTrace();
}

}
}

> -Original Message-
> From: Craig Bowes [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 13, 2000 4:23 PM
> To: CF-Talk
> Subject: Re: cfhttp
>
>
>
> Peter,
>
> You do this by using cfhttp as follows:
>
> 
> 
>
>  does not contain "connection">
>  some link here
> 
>
> The only problem is, for every link that needs to be checked, cfhttp will
> take a while to check the page and thus slow down YOUR page that has the
> links.  CFHTTP is kind of slow.  A better way to do this would be to
> database all your links, then create a scheduled task that checks all the
> links at once, maybe once a day or month or so,  and and alters
> the database
> as to whether or not each one has an error or connection failure.
>  Then you
> run a query against this database checking the status of each
> link the last
> time it was checked and displaying it or not based on what it finds in the
> database.  If your links are already stored in a database, this
> will be easy
> because you'll just have to add another bit field and call it
> "validlink" or
> something.
>
> -Craig Bowes
> Coldfusion Programmer
> [EMAIL PROTECTED]
> 972.243.1171
>
> - Original Message -
> From: "Peter Benoit" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, November 13, 2000 9:52 AM
> Subject: cfhttp
>
>
> > How can I use cfhttp if the page doesn't exist?
> >
> > I have a list of links, in case one doesn't exist anymore, I'd
> like to not
> > present it.  Is cfhttp the best way to do this?
> >
> > Thanks,
> > Pete
> >
> >
> --
> --
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe:
http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>



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



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

RE: CFFile and large file sizes?

[Emmet McGovern]

hmm..
i got 512 ram and 768 swap
it idles around 115 mb

when i upload a 200meg file it only gets up to 450

heres the action code.


3








INSERT INTO movie
(title,
CatID,

sindex,

descript,
movie,
size,
tme,
ext,
location)
VALUES ('#Form.title#',
#Val(Form.CatID)#, 

'#form.sindex#',
 
'#Form.descript#',
'#File.Serverfile#',
'#cffile.filesize#kb',
#CreateODBCDate(NOW())#,
'#cffile.clientfileext#',
'#FILE.ServerDirectory#\#FILE.ServerFile#')




###




Thanks in advance

Emmet








-Original Message-
From: Matt Wisdom [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 13, 2000 11:44 AM
To: CF-Talk
Subject: RE: CFFile and large file sizes?


CFFile writes uploaded files to memory. I guess you are hitting swap...

Matt

> -Original Message-
> From: Emmet McGovern [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 13, 2000 9:15 AM
> To: CF-Talk
> Subject: CFFile and large file sizes?
> 
> 
> I cant remember if ive seen this discussion before or not.  sorrry
> 
> Im trying to use cffile to upload some very large files  66-200megs each.
> They just seem to take forever to upload across the network.  Ive 
> had decent
> success with smaller files of about 30 megs but they still take 
> about 18-20
> minutes each to upload.  This is going over the Lan so speed 
> should be much
> much faster.  Any clues?
> 
> 
> Emmet McGovern
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
> or send a message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]
> 


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

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

RE: Date Manipulation?

[Doug Powell]

If your grabbing the date from a DB you can use


// Set Date to Whatever
DateWanted = queryname.date;
DateWanted = DateAdd("d", 5, DateWanted);


Or you can use



Or however you want



-Original Message-
From: Willy Ray [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 13, 2000 11:34 AM
To: CF-Talk
Subject: Date Manipulation?



Ok, I have a date.  I need to add a day, or a number of days.  How the devil
does one do this?



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



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

SQL Generator

[John Anderson]

Here is a SQL Generator that will generate all of your inserts, updates,
deletes, and selects directly from the database.
http://www.aloha-webdesign.com/sqlgen/

John


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

Re: Security and SQL

[Gregory Harris]

Few things:

1) Set up the CFQUERY Statement to use a username/pass that only does things
you like in the database (basically give it your choice of SELECT, INSERT,
UPDATE, DELETE rights), you are using a Enterprise level database aka SQL 7
or Oracle now aren't you?

2) At the CF Level, you can build your statements to check for malicous
statements as such.  If I recall correctly somebody built a custom tag to do
all that searching for you, check it out at the allaire development exchange
(http://ww.allaire.com).

Gregory Harris
Web Developer
Stirling Bridge Group LLC

- Original Message -
From: "Kevin Schmidt" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 13, 2000 10:41 AM
Subject: Security and SQL


> I pass a few values through URL variable that I use in where clauses in my
> SQL.  I want to prevent someone from passing malicious SQL through that
> value.  What are my options??
>
> Kevin Schmidt
> Internet Services Director
> PWB Integrated Marketing and Communications
> Office: 734.995.5000
> Mobile: 734.649.4843
>
>
>
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>
>


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

RE: Date Manipulation?

[Rich Wild]

> Ok, I have a date.  I need to add a day, or a number of days. 
>  How the devil does one do this?

dateadd('d', numberofdaysvar, datevar)

---
Rich Wild
Senior Web Designer

---
e-mango.com ltd  Tel: 01202 587 400
Lansdowne Place  Fax: 01202 587 401
17 Holdenhurst Road
Bournemouth   Mailto:[EMAIL PROTECTED]
BH8 8EW, UK  http://www.e-mango.com
---
This message may contain information which is legally
privileged and/or confidential.  If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of e-mango.com ltd,
unless otherwise explicitly and independently indicated
by an authorised representative of e-mango.com ltd.
---




> -Original Message-
> From: Willy Ray [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 13, 2000 4:34 PM
> To: CF-Talk
> Subject: Date Manipulation?
> 
> 
> 
> Ok, I have a date.  I need to add a day, or a number of days. 
>  How the devil does one do this?
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: 
> http://www.houseoffusion.com/index.cfm?sidebar=lists or send 
> a message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]
> 

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

Mail Servers

[David Clay]

This is a MIME message. If you are reading this text, you may want to 
consider changing to a mail reader or gateway that understands how to 
properly handle MIME multipart messages.

--=_376C105D.9AFB9CA0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Having problems with SMTP and hops.

What mail server(s) does anyone recommend to work well with CF 4.5.

Thanks for your time.

Dave Clay
Internet Facilitator
Trus Joist, A Weyerhaeuser Business
5995 Greenwood Plaza Blvd, Suite 100
Greenwood Village, CO 80111
303.770.8506


--=_376C105D.9AFB9CA0
Content-Type: text/plain
Content-Disposition: attachment; filename="David Clay.vcf"

BEGIN:VCARD
VERSION:2.1
X-GWTYPE:USER
FN:Clay, David
EMAIL;WORK;PREF;NGW:[EMAIL PROTECTED]
TEL;PREF;FAX:(303) 770-8506
X-GWUSERID:clayd
ADR;DOM;WORK;PARCEL;POSTAL:;Denver
LABEL;DOM;WORK;PARCEL;POSTAL;ENCODING=QUOTED-PRINTABLE:Clay, David=0A=
Denver
ORG:;Engineering Automation Group
N:Clay;David
TEL;WORK:(303) 967-1558
TITLE:Web Facilitator
END:VCARD


--=_376C105D.9AFB9CA0--

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

RE: Date Manipulation?

[JustinMacCarthy]

DateAdd('d',number,date)

Justin MacCarthy

> -Original Message-
> From: Willy Ray [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 13, 2000 4:34 PM
> To: CF-Talk
> Subject: Date Manipulation?
> 
> 
> 
> Ok, I have a date.  I need to add a day, or a number of days.  
> How the devil does one do this?
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar
> 
> 

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

RE: Form works in NS but not IE

[Braver, Ben:]

Ron,

Thanks so much for your help.
Third item was the charm -- the  seemed to do the trick by
providing a default value.

(BTW re: the "option" tag -- there wasn't just one, it's selecting many
entries from an Oracle table and populating a drop-down box...)

Once again, this great list and its mentors come through -- and thanks for
not saying "RTFM" for something as basic as cfparam...

Ben

> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, November 09, 2000 4:07 PM
> To:   CF-Talk
> Subject:  RE: Form works in NS but not IE
> 
> Ben,
> 
> Three things. First, the lone  tag is a bit unconventional,
> although
> I'm not sure if it will cause your error. If you want a blank option at
> the
> top of the list that says "Select One", use this:
> 
>   Select One...
> 
> Second, in your  line, you don't need the hash (#)
> marks there, although I don't believe that will throw an error in CF v4x.
> 
> Third, you should have a  at the top of
> your form action template (along with all other expected form variable
> names).
> 
> Ron Allen Hornbaker
> President/CTO
> Humankind Systems, Inc.
> http://humankindsystems.com
> mailto:[EMAIL PROTECTED]
> 
> 
> 
> > -Original Message-
> > From: Braver, Ben: [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, November 09, 2000 2:41 PM
> > To: CF-Talk
> > Subject: Form works in NS but not IE
> >
> >
> > Hi all,
> >
> > We have had an intranet running good ol' CF 3.1, standardized on
> > Netscape (I
> > know, I know...).  We're switching to Win2k desktop and IE5.  A phone
> book
> > search form which works great in NS does not work in IE5.
> >
> > The form has two drop-downs, a group of 4 radio buttons (with the same
> > variable name), a text box to type in selection criteria, and two
> buttons
> > (submit and reset).
> >
> > Both the dropdowns work.  The first one is:
> > Box Number: 
> > 
> > 
> > #boxdesc#
> > 
> > 
> >
> > The form default is the radio button for LastName checked.  User types a
> > last name fragment into the text box, hits enter or clicks the submit
> > button.  The following error is thrown:
> >
> > The error occurred on (or near) line 10 of the template file
> > 10: 
> > Error resolving parameter BOXID
> > Apparently, Netscape initializes the variable, and IE5 does not.
> > I tried  in the form template, and this didn't help.
> >
> > Any ideas would be appreciated.
> >
> > Ben Braver
> > Information Technology
> > Ultramar Inc.
> > Golden Eagle Refinery
> > 150 Solano Way
> > Martinez, CA  94553-1487
> > (925) 370-3673 voice
> > (925) 370-3393 fax
> > (510) 716-2557 pager
> > [EMAIL PROTECTED]
> >
> > --
> > --
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> > or send a message with 'unsubscribe' in the body to
> > [EMAIL PROTECTED]
> >
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
> a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]

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

Test Post

[John Stanley]

testing

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

RE: Mail Servers

[Simon Horwith]

This Depends on your OS, budget, traffic and accessibility needs, etc.
We're using Exchange Server and aren't having any problems.  I've also used
VINTRA's mail server without problems (and it's free).

~Simon

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


-Original Message-
From: David Clay [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 13, 2000 12:44 PM
To: CF-Talk
Subject: Mail Servers


This is a MIME message. If you are reading this text, you may want to 
consider changing to a mail reader or gateway that understands how to 
properly handle MIME multipart messages.

--=_376C105D.9AFB9CA0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Having problems with SMTP and hops.

What mail server(s) does anyone recommend to work well with CF 4.5.

Thanks for your time.

Dave Clay
Internet Facilitator
Trus Joist, A Weyerhaeuser Business
5995 Greenwood Plaza Blvd, Suite 100
Greenwood Village, CO 80111
303.770.8506


--=_376C105D.9AFB9CA0
Content-Type: text/plain
Content-Disposition: attachment; filename="David Clay.vcf"

BEGIN:VCARD
VERSION:2.1
X-GWTYPE:USER
FN:Clay, David
EMAIL;WORK;PREF;NGW:[EMAIL PROTECTED]
TEL;PREF;FAX:(303) 770-8506
X-GWUSERID:clayd
ADR;DOM;WORK;PARCEL;POSTAL:;Denver
LABEL;DOM;WORK;PARCEL;POSTAL;ENCODING=QUOTED-PRINTABLE:Clay, David=0A=
Denver
ORG:;Engineering Automation Group
N:Clay;David
TEL;WORK:(303) 967-1558
TITLE:Web Facilitator
END:VCARD


--=_376C105D.9AFB9CA0--


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

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

RE: powerpoint presentation on CF

[Terri Stocke]

Thanks, Chris! I'll check this out.

Terri


Original Message Follows
From: "Chris Montgomery" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
Subject: RE: powerpoint presentation on CF
Date: Sun, 12 Nov 2000 23:00:06 -0600

I thought that there were some at Allaire Alive at one time, but it
looks like all of the topics listed use Real Player media.  That
actually might be a better training platform for your intern than
PowerPoint.  Anyway, worth checking out: http://alive.allaire.com/.

Chris Montgomery [EMAIL PROTECTED]

Web Development & Consulting http://www.astutia.com
Allaire Consulting Partner & NetObjects Reseller
210-490-3249/888-745-7603Fax 210-490-4692


 >-Original Message-
 >From: Terri Stocke [mailto:[EMAIL PROTECTED]]
 >Sent: Thursday, November 09, 2000 12:46 PM
 >To: CF-Talk
 >Subject: powerpoint presentation on CF
 >
 >
 >Hey all!
 >
 >Does anyone know where one could find a good powerpoint
 >presentation on CF?
 >One of our interns here asked me if I knew of any. I figured
 >if there was
 >one available, someone from this group would know! :)
 >
 >Thanks!
 >Terri


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

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

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


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

Re: fusebox

[Fred T. Sanders]

Not to say anything bad about switch-box but it looks like someone wanted to
brand they're own "technique" that looks more like a fusebox styled with url
differences and nested cfswitch statements
- Original Message -
From: "Todd Ashworth" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 13, 2000 12:02 PM
Subject: Re: fusebox


> | I'd like to see the other methologies that are out there though,
> |
> | Thanks,
> | Gavin
>
> www.switch-box.org
>
> www.black-box.org
>
> Todd Ashworth
>
>
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>


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

Re: Security and SQL

[Todd Ashworth]

If your values are always numbers, always use the Val() funtion .. It
returns the number if it is a number and returns a 0 if anything else.
Otherwise, make sure you put single quotes aroung the variable.  There are
many other things you can do, but those 2 will take care of a lot of the
basic nastiness.

Todd Ashworth


| > I pass a few values through URL variable that I use in where clauses in
my
| > SQL.  I want to prevent someone from passing malicious SQL through that
| > value.  What are my options??
| >
| > Kevin Schmidt
| > Internet Services Director
| > PWB Integrated Marketing and Communications
| > Office: 734.995.5000
| > Mobile: 734.649.4843



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

Re: please recommend cf host

[Brian L. Wolfsohn]

At 09:42 AM 11/10/00 , you wrote:


www.media3.net  we colocate w/ them, but they have plans for small to large 
setups..

>I am a fledgling cf user and am looking for a cf host.
>
>This site is the archives of a science journal, with
>abstracts in HTML, and full text articles in PDF.
>
>Here are the characteristics of the site:
>
>NEEDS:
>-
>
>Traffic:  Average 250 megs transfer per month
>
>Disk space:  Currently 470 megs, grows by 125 megs per year
>
>Needs: Verity collection to index PDF
>
>Needs: CFCONTENT tag to push PDF to registered users who are granted access
>by IP or by userid/password.
>
>Access database
>
>Site (currently unix) at: 
>
>If you are recommending a host, please include the address of your
>site located at that host. With your permission, I will run a
>Netmechanic Serverwatch for 8 hours to check out your host's
>performance.
>
>
>
>Thanks.
>
>
>--- 
>-
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send 
>a message with 'unsubscribe' in the body to [EMAIL PROTECTED]


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

form generator?

[stas]

Hello,

I remember a few months ago there was a product announcment about a form
generator for CF. Does anybody recall that information? Thanks much.




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

RE: Mail Servers

[Scott Wolf]

I'm using IMail server with mine.  Haven't had any
problems so far.  :P

Scott Wolf
Goodfriend Computer Training

-Original Message-
From: David Clay [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 13, 2000 12:44 PM
To: CF-Talk
Subject: Mail Servers


This is a MIME message. If you are reading this text, you may want to 
consider changing to a mail reader or gateway that understands how to 
properly handle MIME multipart messages.

--=_376C105D.9AFB9CA0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Having problems with SMTP and hops.

What mail server(s) does anyone recommend to work well with CF 4.5.

Thanks for your time.

Dave Clay
Internet Facilitator
Trus Joist, A Weyerhaeuser Business
5995 Greenwood Plaza Blvd, Suite 100
Greenwood Village, CO 80111
303.770.8506


--=_376C105D.9AFB9CA0
Content-Type: text/plain
Content-Disposition: attachment; filename="David Clay.vcf"

BEGIN:VCARD
VERSION:2.1
X-GWTYPE:USER
FN:Clay, David
EMAIL;WORK;PREF;NGW:[EMAIL PROTECTED]
TEL;PREF;FAX:(303) 770-8506
X-GWUSERID:clayd
ADR;DOM;WORK;PARCEL;POSTAL:;Denver
LABEL;DOM;WORK;PARCEL;POSTAL;ENCODING=QUOTED-PRINTABLE:Clay, David=0A=
Denver
ORG:;Engineering Automation Group
N:Clay;David
TEL;WORK:(303) 967-1558
TITLE:Web Facilitator
END:VCARD


--=_376C105D.9AFB9CA0--


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

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

COM Problems Fixed.....

[Simon Horwith]

FYI:
I determined that CF Server SP2 BETA, MUST BE TO BLAME.  Uninstalling CF
Server, and then installing SP1 has fixed the errors.  Gee, I guess that's
why they call it a beta release.  I advise anyone running CFOBJECT on the
SP2 Beta release to "downgrade" until this bug is fixed.  I've reported my
findings to the Allaire Beta Bug Report system.

~Simon

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

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

RE: form generator?

[Arden Weiss]

Go to www.commerceblocks.com

Arden Weiss
410-757-3487

-Original Message-
From:   stas [SMTP:[EMAIL PROTECTED]]
Sent:   Monday, November 13, 2000 2:24 PM
To: CF-Talk
Subject:form generator?

Hello,

I remember a few months ago there was a product announcment about a form
generator for CF. Does anybody recall that information? Thanks much.



  

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


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

Edit a PDF

[Chad Gray]

Is there any way to open a PDF in a browser, and edit it? Like add notes etc.

The user would have the full blow Acrobat, but i dont see any edit tools on 
the browser plugin. Of course the other part of my question would be can 
the user save the file back to the web server?

Im leaning towards a Authorware solution... but wanted to see if CF had any 
capabilities first.

Thanks


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

RE: please recommend cf host

[Raymond K. Camden]

Ditto the Media3 recommendation. They host Death Clock (3.6 million hits
last month) as well as two other clients of mine. I had issues with them
a -long- time ago, but for a very long time now they have been running
smooth and w/o any problems, at least as far as I can tell.

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

Email   : [EMAIL PROTECTED]
ICQ UIN : 3679482

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


> -Original Message-
> From: Brian L. Wolfsohn [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 13, 2000 12:02 PM
> To: CF-Talk
> Subject: Re: please recommend cf host
>
>
> At 09:42 AM 11/10/00 , you wrote:
>
>
> www.media3.net  we colocate w/ them, but they have plans for
> small to large
> setups..
>
> >I am a fledgling cf user and am looking for a cf host.
> >
> >This site is the archives of a science journal, with
> >abstracts in HTML, and full text articles in PDF.
> >
> >Here are the characteristics of the site:
> >
> >NEEDS:
> >-
> >
> >Traffic:  Average 250 megs transfer per month
> >
> >Disk space:  Currently 470 megs, grows by 125 megs per year
> >
> >Needs: Verity collection to index PDF
> >
> >Needs: CFCONTENT tag to push PDF to registered users who are
> granted access
> >by IP or by userid/password.
> >
> >Access database
> >
> >Site (currently unix) at: 
> >
> >If you are recommending a host, please include the address of your
> >site located at that host. With your permission, I will run a
> >Netmechanic Serverwatch for 8 hours to check out your host's
> >performance.
> >
> >
> >
> >Thanks.
> >
> >
> >-
> --
> >-
> >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> >Unsubscribe:
http://www.houseoffusion.com/index.cfm?sidebar=lists or send
>a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]



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


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

Re: Mail Servers

[Joseph Thompson]

at $1500 Imail server is not cheap, but the web mail is "nifty" and because
it is ODBC compliant, building an online CF "signup" form is a snap.


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

Re: CF and a Framed Based Website

[Justin Scott]

Why bother using CF for something so simple?  Here's a JavaScript snippet
that does it...






___

Justin Scott :: [Staff Developer]
http://www.annex.com



- Original Message -
From: "AustralianAccommodation.com Pty. Ltd."
<[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, November 11, 2000 10:16 AM
Subject: CF and a Framed Based Website


My cf site it totally framed based which suites me fine.

I have just become aware that the major search engines have indexed all my
pages including the individual pages that are supposed to appear within the
framed environment.

I no I can stop this by placing the no index meta tag on the page however
the extra search engine exposure I am happy to have.

My question is that can cf detect that a page being displayed is not being
displayed as part of a frame set and then in the application file test for
this and then when the page is not being displayed in the frames set (eg due
to the search engine pointing directly to a specific page that makes up one
of the pages within the frame set) and therefore when this is true run the
appropriate tag to refresh the page back to the home page of the site where
the frame set exists.




Kind Regards

Claude Raiola (Director)
AustralianAccommodation.com Pty. Ltd.
Email: [EMAIL PROTECTED]
Developers Of:
  Website: www.AustralianAccommodation.com
  Website: www.AccommodationNewZealand.com




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



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

Re: SQL Server 2k - query from URL

[Justin Scott]

I've never heard of this before myself, but at first glance, it sounds
dangerous as well.  I suspect there's some way to secure it or something,
but the thouhgt of someone discovering that and executing a delete query or
something...  anyone know anything about the security of that thing?

___

Justin Scott :: [Staff Developer]
http://www.annex.com


- Original Message -
From: "David Shadovitz" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, November 11, 2000 11:48 PM
Subject: OT: SQL Server 2k - query from URL


> I just read an article in the December 2000 issue of WebTechniques, "Plug
> in to SQL Server 2k," that says you can make a database query from a URL.
>
> "One of the cool features of SQL Server 2000 is that you can query the
> database through a web connection.  That is, you can create an
> association within your web server that allows you to interact with SQL
> Servers.  Start by making a new virtual directory within your web server
> and associate that directory with the physical database.  You can do this
> by using the IIS Virtual Directory Manager for SQL, or programatically
> using the SQL Server Object Model.  Once you've created the associations,
> you can pass a SQL query directly in a URL and retrieve data through a
> web connection.  For example, I can use the following URL to retrieve all
> records from the invoice table:
>
>www.beyondhtml.com/db?sql=SELECT+*+FROM+invoice
>
> You can enter this URL in the location bar, but you're more likely to
> enter the query in a form and have the form's action page construct the
> URL and redirect to it.
>
> The article goes on to discuss how you can retrieve the results as XML
> data.  You can also execute stored procedures this way.
>
> I don't use SQL Server, but this sounds interesting.
>
> -David
> 
> YOU'RE PAYING TOO MUCH FOR THE INTERNET!
> Juno now offers FREE Internet Access!
> Try it today - there's no risk!  For your FREE software, visit:
> http://dl.www.juno.com/get/tagj.
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>


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

Re: RDS and NT holding a lock on a file

[Justin Scott]

If you're running MS IIS (like most CF people are) then try stopping that
service and restarting it.  I have run accross problems with file locking
where IIS will hold the file open for several minutes if the "Check if file
exists" attribute is set on the .cfm extention under the filter
configuration.  Unchecking this box may help with your locking problem, and
also may save a milisecond (or a little less) off your page load times
because ISS won't have to check for the file before it passes the request to
the CF processor.

___

Justin Scott :: [Staff Developer]
http://www.annex.com

- Original Message -
From: "Aidan Whitehall" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, November 12, 2000 7:03 AM
Subject: RE: RDS and NT holding a lock on a file


> If anyone has *any* info on how to eliminate this error message,
please
> let me know.
>
> I just can't t-t-t-take it any more *sob* *sob*
>
>
> > -Original Message-
> > From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
> > Sent: 08 November 2000 16:22
> > To: CF-Talk
> > Subject: RDS and NT holding a lock on a file
> >
> >
> > There was a thread a while ago about NT (I think) holding a
> -- It's actually an IIS thing, as someone mentioned --
> > lock on a file
> > for 60 seconds. I'm finding if request a .cfm file in a
> > browser and then try
> > and open the same file via RDS in Studio, Studio throws this error:
> >
> >Error attempting to read data from file
> > F:/pathtofile/file.cfm  Error
> > = There was a sharing violation.
> >
> > If you click OK, after about a minute you can open the file
> > and edit away.
> >
> > We're not having this problem with other servers and our
> > network admin has
> > just turned off "Keep Alives" on the server in question but no dice.
> >
> > Any suggestions? This is driving me mad (you want a file?
> > wait a minute,
> > then you can have it  ;-).
>
>
> --
> Aidan Whitehall <[EMAIL PROTECTED]>
> Netshopper UK Ltd
> Advanced Web Solutions & Services
>
> http://www.netshopperuk.com/
> Telephone +44 (01744) 648650
> Fax +44 (01744) 648651
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>


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

Re: jr CF

[Justin Scott]

That is probably the best advice I've seen on the list so far for the
newbies.  I wouldn't be where I am today without the site I was running.
Here's my story...

I was a senior in high school, very into computers and just getting into CGI
and perl for interactive web development for a few sites I was doing for
some friends and the local high school.  Since I was also into BBSing, I
attended SysCon (http://www.1syscon.org) to meet some like-minded people and
get a little vacation.  At this small conference in Vegas, I was introduced
to CF by the owner of a development company in California (which I now work
for).  Six months later I went back to Vegas for the conference again, but
this time I was the luckly winner of my very own copy of CF Server 4.0.  A
few weeks later I realized what I had and discovered its true power when I
converted all of my web sites from perl into CF.

I got the Forta books and played with CF for the next 5 months, then went
back to SysCon again (they do their conference every 6 months instead of
annually).  This time around, the CF developers that had also attended all
of the other Syscons mentioned that they were looking for some talent, so I
gave them some URLs to look at and went home thinking I would never hear
anything else about it.  A couple of weeks later they called and told me
that they were interesetd in possibly hiring me.  Less than a month later I
moved out of my parents house and took the job.

Now, a year later, I'm still with the same company.  Anyway, if you're a CF
"newbie" the best thing you can do to teach yourself CF and to show others
that you know your stuff is to do your own web site to demonstrate your
skills.

___

Justin Scott :: [Staff Developer]
http://www.annex.com

- Original Message -
From: "Warrick, Mark" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, November 12, 2000 12:23 PM
Subject: RE: jr CF


My advice:

Setup a web site which demostrates your skills.  If you can demonstrate that
you are knowledgeable about EVERY CF tag in the book, I'm sure you'll get a
job.

---mark


--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, November 12, 2000 11:28 AM
> To: CF-Jobs
> Subject: Re: jr CF
>
>
>
>  Things I would recommend:
>
>  Take the Allaire courses.  The beginner one and the advanced one on
> Cold Fusion.  Even if you pay for it out of your own pocket.  They
> aren't substitute for real-world experience, but will probably look
> better on a resume than "I self-taught myself at home for the past 6
> months."
>
>  Become active in the local CFUG, or try to start one if there isn't one.
> Go to meetings, and if you can, get involved in the web site (which will
> most likely use Cold Fusion).  Although, recruiting at meetings is
> generally frowned upon by the CFUG managers, I have been to meetings that
> do a 'business card swap' at the end of the meeting.  You may
> even be able
> to do this sort of work telecommuting for a CFUG if there isn't
> one local.
>
>  Look up local non-profit or volunteer run organizations.  Can you get
> involved with their web site, will ColdFusion help.
>
>  I just don't think it's right for a company to pay someone nothing,
> (that includes internships) for work.  I wouldn't expect an intern
> or a jr developer to receive the compensation someone w/ 4+ years
> experience would, either.
>
>
> > Ellen Swartz wrote:
> >
> > Very interesting thread.
> >
> > I am not alone and it does not make me feel any better.
> > I have been struggling for the last 6 months between getting
> several part-time
> > jobs to make some $ and finding an entry level CF position or
> internship. I
> > got about 10 interviews with local companies that all ended the
> same way.
> > "Sorry, you don't have enough experience. Go home, work hard
> and contact us
> > again when you are ready."
> >
> > Let's face it. What company is going to hire an accountant with
> no experience
> > and barely any knowledge?
> > If CF was tought in college we would not be were we are now. We
> still would
> > not have the real life experience but we would have a lot more
> knowledge and
> > consequently a lot more chances to find an entry level CF job.
> >
> > I got to a point where I was wondering if I should pay a
> company to hire me
> > and give me some real life experience. I would work for freee
> if I was given
> > the opportunity (only on-site with a local company). It's
> either that (and I
> > agree I would be taken advantage of) or spent another year
> strugging learning
> > in 6 months at home what I wou

Re: Date Manipulation?

[Justin Scott]

Use the DateAdd function...

DateAdd(datepart, number, date)

so it would be...










___

Justin Scott :: [DtDNS Administrator]
http://www.dtdns.com

- Original Message -
From: "Willy Ray" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 13, 2000 8:34 AM
Subject: Date Manipulation?



Ok, I have a date.  I need to add a day, or a number of days.  How the devil
does one do this?



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



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

Re: Mail Servers

[Justin Scott]

> Having problems with SMTP and hops.
> What mail server(s) does anyone recommend to work well with CF 4.5.
>
> Thanks for your time.

I prefer VOPMail from Vircom myself.  It handles just about whatever you can
throw at it very well, and has full database integration built in so you can
manage all your mailboxes via ODBC if you want.

___

Justin Scott :: [Staff Developer]
http://www.annex.com



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

Re: Security and SQL

[Justin Scott]

One basic thing you can do is place an #Int()# function in the query on any
values that the user has control of that are supposed to be numeric, or
check them in advance with #IsNumeric()# or soemthing.  This will keep them
from passing a subquery as part of the request.  So having it in a query
like..

SELECT This FROM That
WHERE ID = #Int(URL.ID)#

..always a good idea.

___

Justin Scott :: [DtDNS Administrator]
http://www.dtdns.com

- Original Message -
From: "Kevin Schmidt" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 13, 2000 10:41 AM
Subject: Security and SQL


> I pass a few values through URL variable that I use in where clauses in my
> SQL.  I want to prevent someone from passing malicious SQL through that
> value.  What are my options??
>
> Kevin Schmidt
> Internet Services Director
> PWB Integrated Marketing and Communications
> Office: 734.995.5000
> Mobile: 734.649.4843
>
>
>
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>


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