Re: Form Submision only once ??

[Jason Miller]

on top of that you may also want to do something like this.. It let's the user know 
that something is happening.

js-



html -

Name:  




also - Mat - will a cflocation after the form has been handled prevent quick double 
hits of the submit button? I
was not sure it would.

jay miller



Matthew Walker wrote:

> After the form has been handled, cflocation the visitor to a thank you
> page.
>
> > -Original Message-
> > From: Brian Simpson [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, 5 June 2002 4:40 p.m.
> > To: CF-Talk
> > Subject: Form Submision only once ??
> >
> >
> > I'm back needing help again.
> >
> > How do you keep a form from being submitted only once?
> >
> > I have a entry form that same some information to a database. If the
> > subscriber hits the browser refreash the form get put into
> > the database
> > twice. How do I prevent the data from going into the database
> > twice (or as
> > many times as they hit the refresh key?
> >
> > Thanks once again for your help.
> >
> >   Brian
> >
> >
> >
> 
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Form Submision only once ??

[Matthew Walker]

After the form has been handled, cflocation the visitor to a thank you
page.

> -Original Message-
> From: Brian Simpson [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, 5 June 2002 4:40 p.m.
> To: CF-Talk
> Subject: Form Submision only once ??
> 
> 
> I'm back needing help again.
> 
> How do you keep a form from being submitted only once?
> 
> I have a entry form that same some information to a database. If the 
> subscriber hits the browser refreash the form get put into 
> the database 
> twice. How do I prevent the data from going into the database 
> twice (or as 
> many times as they hit the refresh key?
> 
> Thanks once again for your help.
> 
>   Brian
> 
> 
> 
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Shopping cart descision

[Ian Lurie]

I've been completely happy with Netready (Aloha Designs). We've got sites
processing upwards of $150k per month using that cart - it customizes easily
and scales great. You could add a nested tree model to handle parts, etc.
and be ready to go in no time.

I wouldn't look any further.

Ian

-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 9:42 PM
To: CF-Talk
Subject: Shopping cart descision


I have looked into sitedirector and aloha designs shopping cart, and was
wondering if there is other carts available to compare against. I know
about ablecommerce, but I think it is a little pricey. Could everyone
give me some input into what they think is best and why? The site it
will be used on will be selling auto body parts for all makes and models
of cars and must be able to handle different parts for different makes
etc.. etc... etc...


Thnks in advance for words of advise

Douglas Brown
Email: [EMAIL PROTECTED]


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Form Submision only once ??

[Brian Simpson]

I'm back needing help again.

How do you keep a form from being submitted only once?

I have a entry form that same some information to a database. If the 
subscriber hits the browser refreash the form get put into the database 
twice. How do I prevent the data from going into the database twice (or as 
many times as they hit the refresh key?

Thanks once again for your help.

Brian


__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Session timeout and inactivity time

[Bud]

On 6/4/02, Stephen Hait penned:
>If cfapplication specifies a sessiontimeout of 10 minutes, will any 
>session variables be destroyed after 10 minutes or only after 10
>minutes of inactivity?

Inactivity.
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Shopping cart descision

[Douglas Brown]

I have looked into sitedirector and aloha designs shopping cart, and was
wondering if there is other carts available to compare against. I know
about ablecommerce, but I think it is a little pricey. Could everyone
give me some input into what they think is best and why? The site it
will be used on will be selling auto body parts for all makes and models
of cars and must be able to handle different parts for different makes
etc.. etc... etc...


Thnks in advance for words of advise

Douglas Brown
Email: [EMAIL PROTECTED]

__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: White papers and articles

[Stacy Young]

Some handy PDFs here..

http://www.macromedia.com/desdev/mx/coldfusion/


-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, June 04, 2002 9:51 AM
To: CF-Talk
Subject: White papers and articles

Can anyone out there send me a few links to white papers or articles
regarding CFMX. I've read several, but I do not have the links at the
moment.  I'm mostly interested in articles that mention (dare I say tout)
the J2EE compliance and standards based integration of the new server
product.  Thanks if you can.

Mark



__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: view Word document without showing URL

[Dave Watts]

> how can i pust a microsoft word document content into 
> a client browser by not letting the user know the actual 
> location and file name of the word document, is that 
> possible?

Not really, in any absolute sense. You can hide it by presenting the
document in a frame, or you can use CFCONTENT to serve the file, which
doesn't hide the URL but allows you to perform CF-based authentication. You
can move files around on the filesystem, so that URLs don't last very long -
on Unix, you can use symlinks for this, which is kind of handy.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444


__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

view Word document without showing URL

[Mak Wing Lok]

how can i pust a microsoft word document content into a client browser by
not letting the user know the actual location and file name of the word
document, is that possible?


--- 
"Pharmaniaga Berhad, your integrated healthcare provider"
www.pharmaniaga.com.my 
"www.ehealth4all.com, your most convenient way to healthcare, everyday..." 
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential or privileged material.
If you received this in error, please contact the sender and delete the
material from any computer. Any review, retransmission, dissemination or
other use of, or taking of any action in reliance upon, this information by
persons or entities other than the intended recipient is prohibited. 
---
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: OT DevCon

[Howie Hamlin]

Disney World, same as last year:

http://www.macromedia.com/v1/conference/

HTH,

--
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. - www.CoolFusion.com  - 631-737-4668 x101
inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server
>>> Find out how iMS Stacks up to the competition: 
>http://www.coolfusion.com/imssecomparison.cfm

- Original Message -
From: "Constanty DeCinko III" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, June 04, 2002 10:13 PM
Subject: RE: OT DevCon


> Where is it being held this year?  Where can I read more about it?
>
>
> -Original Message-
> From: Drew Harris [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 04, 2002 7:59 AM
> To: CF-Talk
> Subject: Re: OT DevCon
>
>
> If someone has already answered this, apologies, I did not see it here.
>
> I have been (to DevCon) the past two years.
> I would recommend staying in the host hotel.
> It makes it very easy to go up to your room anytime, and allows you to see
> cool people in the lobby like Jeremy and Ben.
>
> As far as I know, the Fusebox conference will be in the same hotel this year
> and yes right now the plan is to have it the two days before DevCon.
>
> You might go over to [EMAIL PROTECTED] for more details about the
> Fusebox conference.
>
> -Drew Harris
>
> On 6/2/02 11:36 AM, "Allen Hall" <[EMAIL PROTECTED]> wrote:
>
> > I was just interested to see what those of you who have been to DevCon in
> > the past have to say about the general do's and don'ts.
> >
> > Does Macromedia offer special room rates or packages?  Should you stay at
> > the host hotel? ($$$)  What about the Fusebox conference, and is it going
> to
> > be held the two days before?
> >
> > Allen Hall
> >
> >
> >
>
> 
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: OT DevCon

[Constanty DeCinko III]

Where is it being held this year?  Where can I read more about it?


-Original Message-
From: Drew Harris [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 7:59 AM
To: CF-Talk
Subject: Re: OT DevCon


If someone has already answered this, apologies, I did not see it here.

I have been (to DevCon) the past two years.
I would recommend staying in the host hotel.
It makes it very easy to go up to your room anytime, and allows you to see
cool people in the lobby like Jeremy and Ben.

As far as I know, the Fusebox conference will be in the same hotel this year
and yes right now the plan is to have it the two days before DevCon.

You might go over to [EMAIL PROTECTED] for more details about the
Fusebox conference.

-Drew Harris

On 6/2/02 11:36 AM, "Allen Hall" <[EMAIL PROTECTED]> wrote:

> I was just interested to see what those of you who have been to DevCon in
> the past have to say about the general do's and don'ts.
>
> Does Macromedia offer special room rates or packages?  Should you stay at
> the host hotel? ($$$)  What about the Fusebox conference, and is it going
to
> be held the two days before?
>
> Allen Hall
>
>
>

__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: White papers and articles

[Phil Costa]

http://www.macromedia.com/software/coldfusion/whitepapers/

-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, June 04, 2002 9:51 AM
To: CF-Talk
Subject: White papers and articles


Can anyone out there send me a few links to white papers or articles regarding CFMX. 
I've read several, but I do not have the links at the moment.  I'm mostly interested 
in articles that mention (dare I say tout) the J2EE compliance and standards based 
integration of the new server product.  Thanks if you can.

Mark



__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Random Values generated in SQL

[Justin Greene]

This is not really something that Transact SQL excels in, but I think the
way to handle it is to create a string 'ABCDEFGH' then in a while loop
select a number between 1 & len(string) and and insert the number into a
temp table.  After N loops, I would exit the while loop, and select
substring(string,column,1) from the temp table. 

Justin


> -Original Message-
> From: Casey C Cook [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 04, 2002 7:04 PM
> To: CF-Talk
> Subject: RE: Random Values generated in SQL
> 
\
> 
> 1 column of output - 346 rows long - All values in the list will be
> randomly selected from 8 possible list items (A,B,C,D,E,F,G,H)
> 
> Output of 5 Rows
> 
> D
> A
> B
> B
> C
> 
> Thanks,
> Casey Cook
> 
> 
>   
>  
> bjohnson  
>  
> @hostworks.coTo: CF-Talk 
> <[EMAIL PROTECTED]>   
> m (Ben   cc:  
>  
> Johnson) Subject: RE: 
> Random Values generated in SQL   
>   
>  
> 06/04/02  
>  
> 05:01 PM  
>  
> Please
>  
> respond to
>  
> cf-talk   
>  
>   
>  
>   
>  
> 
> 
> 
> 
> > Does anyone know in SQL how to generate 346 random selections from
> > predefined list of 8 distinct values (A,B,C,D,E,F,G,H). I 
> will be using
> > query analyzer to complete this task, no coldfusion is involved.
> 
> 
> Casey,
>  Can you be more specific?  Do you need 346 random rows?  
> Are you only
> choosing one column per row or do you need several columns?  
> Also, is this
> random or do you just need permutations/combinations of those 
> 8 values?
> 
> Basically, can you give me a mini-example of the output that 
> you want to
> see?
> 
> Thanks.
> 
> 
> 
> Ben Johnson
> Hostworks, Inc.
> 
> 
> 
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Weird, inconsistent browser behavior

[Chris Kief]

So if they're not allowing cookies - problem solved.

If cookies are working fine, then you should be checking to see if the
session vars are being set before  exectutes. In some
situations, these vars won't be set properly (or at all!!). MM has a
tech note about this here with some workarounds:

http://www.macromedia.com/v1/Handlers/index.cfm?ID=22712&Method=Full

chris



-Original Message-
From: Ian Lurie [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, June 04, 2002 3:45 PM
To: CF-Talk
Subject: RE: Weird, inconsistent browser behavior

You're right, sorry - too little caffeine today.

-Original Message-
From: Jamie Jackson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 2:59 PM
To: CF-Talk
Subject: Re: Weird, inconsistent browser behavior


You *are* using cookies, unless you are passing cfid/cftoken in the
url.

Jamie

On Tue, 4 Jun 2002 14:41:33 -0700, in cf-talk you wrote:

>I thought of that but the site uses session vars, no cookies necessary.
>
>-Original Message-
>From: Brian Fox [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, June 04, 2002 2:39 PM
>To: CF-Talk
>Subject: RE: Weird, inconsistent browser behavior
>
>
>Cookies disabled?
>
>> -Original Message-
>> From: Ian Lurie [mailto:[EMAIL PROTECTED]]
>> Sent: Tuesday, June 04, 2002 2:32 PM
>> To: CF-Talk
>> Subject: Weird, inconsistent browser behavior
>>
>>
>> Hi all,
>>
>> I've got an application on a server. If I, or anyone else I
>> know, browse the
>> site, it works fine.
>>
>> ONE person is having the following problem: When they go to
>> the login screen
>> and enter a username/password, they keep coming back to the
>> login page. And
>> yes, they're entering the right password. It seems as if
>> their browser is
>> ignoring the URL parameter that tells CF to go on to the next
>> page. They're
>> using IE 5.5 SP1 on a Windows 2000 PC.
>>
>> Has anyone else experienced this?
>>
>> Ian
>>
>> Portent Interactive
>> Helping clients build customer relationships on the web since 1995
>> Consulting, design, development, measurement
>> http://www.portentinteractive.com
>> Talk with us: http://projects.portentinteractive.com
>>
>>
>
>


__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Weird, inconsistent browser behavior

[Ian Lurie]

OK, the client has cookies turned on. I'm setting session vars and am now
using location.href to redirect them immediately after that. I'm not
attaching URLTOKEN, but if cookies are on it's my understanding that that's
not necessary.

-Original Message-
From: UXB Internet [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 3:54 PM
To: CF-Talk
Subject: RE: Weird, inconsistent browser behavior


Session vars and client vars rely on either cookies or URL variables to keep
track of state.  Remember: The web is stateless.


Best regards,

Dennis Powers
UXB Internet - A Web Design and Hosting Company
tel: (203)879-2844  fax: (203)879-6254
http://www.uxbinternet.com/
http://dennis.uxb.net/


-Original Message-
From: Ian Lurie [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 5:42 PM
To: CF-Talk
Subject: RE: Weird, inconsistent browser behavior

I thought of that but the site uses session vars, no cookies necessary.

-Original Message-
From: Brian Fox [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 2:39 PM
To: CF-Talk
Subject: RE: Weird, inconsistent browser behavior


Cookies disabled?

> -Original Message-
> From: Ian Lurie [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 04, 2002 2:32 PM
> To: CF-Talk
> Subject: Weird, inconsistent browser behavior
>
>
> Hi all,
>
> I've got an application on a server. If I, or anyone else I
> know, browse the
> site, it works fine.
>
> ONE person is having the following problem: When they go to
> the login screen
> and enter a username/password, they keep coming back to the
> login page. And
> yes, they're entering the right password. It seems as if
> their browser is
> ignoring the URL parameter that tells CF to go on to the next
> page. They're
> using IE 5.5 SP1 on a Windows 2000 PC.
>
> Has anyone else experienced this?
>
> Ian
>
> Portent Interactive
> Helping clients build customer relationships on the web since 1995
> Consulting, design, development, measurement
> http://www.portentinteractive.com
> Talk with us: http://projects.portentinteractive.com
>
>



__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Random Values generated in SQL

[Casey C Cook]

1 column of output - 346 rows long - All values in the list will be
randomly selected from 8 possible list items (A,B,C,D,E,F,G,H)

Output of 5 Rows

D
A
B
B
C

Thanks,
Casey Cook


   

bjohnson   

@hostworks.coTo: CF-Talk <[EMAIL PROTECTED]>   

m (Ben   cc:   

Johnson) Subject: RE: Random Values generated in 
SQL   
   

06/04/02   

05:01 PM   

Please 

respond to 

cf-talk

   

   





> Does anyone know in SQL how to generate 346 random selections from
> predefined list of 8 distinct values (A,B,C,D,E,F,G,H). I will be using
> query analyzer to complete this task, no coldfusion is involved.


Casey,
 Can you be more specific?  Do you need 346 random rows?  Are you only
choosing one column per row or do you need several columns?  Also, is this
random or do you just need permutations/combinations of those 8 values?

Basically, can you give me a mini-example of the output that you want to
see?

Thanks.



Ben Johnson
Hostworks, Inc.


__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CFMX on OSX

[Dick Applebaum]

No, 256 Meg RAM

But this is a teeny. teeny machine... 6 Gig HD (I  also have a 60 Gig 
USB external HD)

I read somewhere, in some apple documentation, that 350 MHz, 256 Meg RAM 
was the minimum requirement. for running OS X.

But I initially installed OS X on my 333 MHz  96MEG RAM... it worked 
acceptably (better than OS 9).

When I started fiddling with CFMX I upgraded to 256 Meg (the max on this 
old iMac).

If we do get CFMX running (mostly)... then you would have a pretty good 
little CF IDE on a machine you could buy for $300 or so... and takes up 
15 cu inches of space.

Dick


On Tuesday, June 4, 2002, at 03:36  PM, Ben Johnson wrote:

>> Flash from the past  I worked on Maimframes with as little as 2K
>> (tubes,before RAM)... my first micro had 4-16K the same as an IBM/360
>> Mod 30... long, long ago... in another galexy
>
> Wait... are you serious that it only has 256K of RAM?  Or was that a 
> typo?
>
>
>
>
> Ben Johnson
> Hostworks, Inc.
> 
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Client Variable Storage: Trouble Purging

[Matt Robertson]

So is this, kind of.  I grabbed it out of the Allaire KB quite awhile ago.  Turned it 
into a custom tag.  No idea if MX has an internal fix rather than this:










SELECT CGLOBAL.cfid FROM CGLOBAL WHERE CGLOBAL.lvisit < #variables.ExpireDate#




  
DELETE FROM CDATA WHERE CDATA.cfid='#Expired.cfid#'
  




  DELETE FROM CGLOBAL WHERE CGLOBAL.lvisit < #variables.ExpireDate#





---
Matt Robertson[EMAIL PROTECTED]
MSB Designs, Inc., www.mysecretbase.com
---


-- Original Message --
from: "James Smith" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Tue, 4 Jun 2002 23:45:29 +0100

I would be interested in this, I use MySQL and the workround I have is VERY
messy.

--
Jay

- Original Message -
From: "Matt Robertson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, June 04, 2002 11:38 PM
Subject: Re: Client Variable Storage: Trouble Purging


> Whats your db platform?  If its mySQL, CF can't purge it (although a
workaround was published some time ago that you can cfschedule).  Let me
know if you need it and I'll post it.
>
> ---
> Matt Robertson[EMAIL PROTECTED]
> MSB Designs, Inc., www.mysecretbase.com
> ---
>
>
> -- Original Message --
> from: Jamie Jackson <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> date: Tue, 04 Jun 2002 18:17:52 -0400
>
> Two questions:
>
> *My registry seems to be corrupted, though it's hard to say. It has
> swollen with client variables, and CF *seems* not to be able to purge
> the old ones after the designated period. Is there a way to manually
> purge them? I can't view the CF key in regedit, as regedit eats up
> RAM/virtual memory when I try to access the CF part of the registry.
>
> *Same sort of issue with DB client stores: CF isn't properly purging
> unused client variables. It looks as though all rows created so far
> (since ~1 week ago) are still there, though CF's supposed to clean
> unused client variables after a day. Isn't CF supposed to handle these
> deletes, or do I need to implement a DB job to handle it?
>
> Thanks,
> Jamie
>
> 

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Old-School Flash

[Todd]

A... FutureSplash... man... that's old.

At 04:49 PM 6/4/2002 -0600, you wrote:
>Anybody know of anywhere that has examples of really old school flash, as in
>Flash version 1?  Or even a document that lists all the new features to each
>new version?  I'm curious to know how it's all evolved.
>
>
>
>Ben Johnson
>Hostworks, Inc.
>
>
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Weird, inconsistent browser behavior

[UXB Internet]

Session vars and client vars rely on either cookies or URL variables to keep
track of state.  Remember: The web is stateless.


Best regards,

Dennis Powers
UXB Internet - A Web Design and Hosting Company
tel: (203)879-2844  fax: (203)879-6254
http://www.uxbinternet.com/
http://dennis.uxb.net/


-Original Message-
From: Ian Lurie [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 5:42 PM
To: CF-Talk
Subject: RE: Weird, inconsistent browser behavior

I thought of that but the site uses session vars, no cookies necessary.

-Original Message-
From: Brian Fox [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 2:39 PM
To: CF-Talk
Subject: RE: Weird, inconsistent browser behavior


Cookies disabled?

> -Original Message-
> From: Ian Lurie [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 04, 2002 2:32 PM
> To: CF-Talk
> Subject: Weird, inconsistent browser behavior
>
>
> Hi all,
>
> I've got an application on a server. If I, or anyone else I
> know, browse the
> site, it works fine.
>
> ONE person is having the following problem: When they go to
> the login screen
> and enter a username/password, they keep coming back to the
> login page. And
> yes, they're entering the right password. It seems as if
> their browser is
> ignoring the URL parameter that tells CF to go on to the next
> page. They're
> using IE 5.5 SP1 on a Windows 2000 PC.
>
> Has anyone else experienced this?
>
> Ian
>
> Portent Interactive
> Helping clients build customer relationships on the web since 1995
> Consulting, design, development, measurement
> http://www.portentinteractive.com
> Talk with us: http://projects.portentinteractive.com
>
>


__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Old-School Flash

[Vernon Viehe]

Try these:

http://radio.weblogs.com/0106797/2002/05/07.html#a60

www.archive.org

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 04, 2002 3:50 PM
> To: CF-Talk
> Subject: Old-School Flash
> 
> 
> Anybody know of anywhere that has examples of really old 
> school flash, as in
> Flash version 1?  Or even a document that lists all the new 
> features to each
> new version?  I'm curious to know how it's all evolved.
> 
> 
> 
> Ben Johnson
> Hostworks, Inc.
> 
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Session timeout and inactivity time

[Dave Watts]

> If cfapplication specifies a sessiontimeout of 10 minutes, 
> will any session variables be destroyed after 10 minutes 
> or only after 10 minutes of inactivity?

After ten minutes of inactivity.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Session timeout and inactivity time

[Matt Robertson]

10 minutes of inactivity.

---
Matt Robertson[EMAIL PROTECTED]
MSB Designs, Inc., www.mysecretbase.com
---


-- Original Message --
from: "Stephen Hait" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Tue, 4 Jun 2002 18:41:54 -0500

If cfapplication specifies a sessiontimeout of 10 minutes, will any  
session variables be destroyed after 10 minutes or only after 10 
minutes of inactivity?

TIA,
Stephen

__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Old-School Flash

[Ben Johnson]

Anybody know of anywhere that has examples of really old school flash, as in
Flash version 1?  Or even a document that lists all the new features to each
new version?  I'm curious to know how it's all evolved.



Ben Johnson
Hostworks, Inc.

__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Weird, inconsistent browser behavior

[Ian Lurie]

You're right, sorry - too little caffeine today.

-Original Message-
From: Jamie Jackson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 2:59 PM
To: CF-Talk
Subject: Re: Weird, inconsistent browser behavior


You *are* using cookies, unless you are passing cfid/cftoken in the
url.

Jamie

On Tue, 4 Jun 2002 14:41:33 -0700, in cf-talk you wrote:

>I thought of that but the site uses session vars, no cookies necessary.
>
>-Original Message-
>From: Brian Fox [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, June 04, 2002 2:39 PM
>To: CF-Talk
>Subject: RE: Weird, inconsistent browser behavior
>
>
>Cookies disabled?
>
>> -Original Message-
>> From: Ian Lurie [mailto:[EMAIL PROTECTED]]
>> Sent: Tuesday, June 04, 2002 2:32 PM
>> To: CF-Talk
>> Subject: Weird, inconsistent browser behavior
>>
>>
>> Hi all,
>>
>> I've got an application on a server. If I, or anyone else I
>> know, browse the
>> site, it works fine.
>>
>> ONE person is having the following problem: When they go to
>> the login screen
>> and enter a username/password, they keep coming back to the
>> login page. And
>> yes, they're entering the right password. It seems as if
>> their browser is
>> ignoring the URL parameter that tells CF to go on to the next
>> page. They're
>> using IE 5.5 SP1 on a Windows 2000 PC.
>>
>> Has anyone else experienced this?
>>
>> Ian
>>
>> Portent Interactive
>> Helping clients build customer relationships on the web since 1995
>> Consulting, design, development, measurement
>> http://www.portentinteractive.com
>> Talk with us: http://projects.portentinteractive.com
>>
>>
>
>

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Client Variable Storage: Trouble Purging

[James Smith]

I would be interested in this, I use MySQL and the workround I have is VERY
messy.

--
Jay

- Original Message -
From: "Matt Robertson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, June 04, 2002 11:38 PM
Subject: Re: Client Variable Storage: Trouble Purging


> Whats your db platform?  If its mySQL, CF can't purge it (although a
workaround was published some time ago that you can cfschedule).  Let me
know if you need it and I'll post it.
>
> ---
> Matt Robertson[EMAIL PROTECTED]
> MSB Designs, Inc., www.mysecretbase.com
> ---
>
>
> -- Original Message --
> from: Jamie Jackson <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> date: Tue, 04 Jun 2002 18:17:52 -0400
>
> Two questions:
>
> *My registry seems to be corrupted, though it's hard to say. It has
> swollen with client variables, and CF *seems* not to be able to purge
> the old ones after the designated period. Is there a way to manually
> purge them? I can't view the CF key in regedit, as regedit eats up
> RAM/virtual memory when I try to access the CF part of the registry.
>
> *Same sort of issue with DB client stores: CF isn't properly purging
> unused client variables. It looks as though all rows created so far
> (since ~1 week ago) are still there, though CF's supposed to clean
> unused client variables after a day. Isn't CF supposed to handle these
> deletes, or do I need to implement a DB job to handle it?
>
> Thanks,
> Jamie
>
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Client Variable Storage: Trouble Purging

[Dave Watts]

> *My registry seems to be corrupted, though it's hard to say. It has
> swollen with client variables, and CF *seems* not to be able to purge
> the old ones after the designated period. Is there a way to manually
> purge them? I can't view the CF key in regedit, as regedit eats up
> RAM/virtual memory when I try to access the CF part of the registry.

If you just want to delete everything in the Clients key, you could do
something like this:



If CF isn't able to do this (and it might be a bad idea to try this, come to
think of it), you might instead delete the key programmatically, you could
do it any number of ways. For example, if you're using Windows 2000, you can
use the command-line REG.EXE tool, which comes with the Windows 2000 Support
Tools (found on the Win2K install CD):

REG DELETE
HKEY_LOCAL_MACHINE\Software\Allaire\ColdFusion\CurrentVersion\Clients

Note that in either case, you'll delete whatever loose values are in there
to track server-wide settings for Client variables, such as the use of
UUIDTokens. That's no big problem, though, I suppose. You could read out
just those values before deleting the key, again using REG:

REG QUERY
HKEY_LOCAL_MACHINE\Software\Allaire\ColdFusion\CurrentVersion\Clients /v
TimeOut
REG QUERY
HKEY_LOCAL_MACHINE\Software\Allaire\ColdFusion\CurrentVersion\Clients /v
LastID
REG QUERY
HKEY_LOCAL_MACHINE\Software\Allaire\ColdFusion\CurrentVersion\Clients /v
UUIDToken

> *Same sort of issue with DB client stores: CF isn't properly purging
> unused client variables. It looks as though all rows created so far
> (since ~1 week ago) are still there, though CF's supposed to clean
> unused client variables after a day. Isn't CF supposed to handle these
> deletes, or do I need to implement a DB job to handle it?

There's a bug with this, but there's also a bug fix:
http://www.macromedia.com/v1/Handlers/index.cfm?ID=22730&Method=Full

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Session timeout and inactivity time

[Stephen Hait]

If cfapplication specifies a sessiontimeout of 10 minutes, will any  
session variables be destroyed after 10 minutes or only after 10 
minutes of inactivity?

TIA,
Stephen
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Weird, inconsistent browser behavior

[Ian Lurie]

Yess

Should I use location.href instead?

-Original Message-
From: Chris Kief [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 2:54 PM
To: CF-Talk
Subject: RE: Weird, inconsistent browser behavior


After setting the session variables, are you then immediately
redirecting the user to the next page via ?



-Original Message-
From: Ian Lurie [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 2:42 PM
To: CF-Talk
Subject: RE: Weird, inconsistent browser behavior

I thought of that but the site uses session vars, no cookies necessary.

-Original Message-
From: Brian Fox [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 2:39 PM
To: CF-Talk
Subject: RE: Weird, inconsistent browser behavior


Cookies disabled?

> -Original Message-
> From: Ian Lurie [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 04, 2002 2:32 PM
> To: CF-Talk
> Subject: Weird, inconsistent browser behavior
>
>
> Hi all,
>
> I've got an application on a server. If I, or anyone else I
> know, browse the
> site, it works fine.
>
> ONE person is having the following problem: When they go to
> the login screen
> and enter a username/password, they keep coming back to the
> login page. And
> yes, they're entering the right password. It seems as if
> their browser is
> ignoring the URL parameter that tells CF to go on to the next
> page. They're
> using IE 5.5 SP1 on a Windows 2000 PC.
>
> Has anyone else experienced this?
>
> Ian
>
> Portent Interactive
> Helping clients build customer relationships on the web since 1995
> Consulting, design, development, measurement
> http://www.portentinteractive.com
> Talk with us: http://projects.portentinteractive.com
>
>



__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Client Variable Storage: Trouble Purging

[Ken Wilson]

Do these help at all?



>> CF *seems* not to be able to purge

http://www.macromedia.com/v1/Handlers/index.cfm?ID=22419&Method=Full



>> *Same sort of issue with DB client stores:


http://www.macromedia.com/v1/Handlers/index.cfm?ID=22730&Method=Full

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Learn about CF MX at MDCFUG 6/11

[Michael Smith]

You are invited to the Maryland ColdFusion User Group Meeting,
Tuesday 6/11/02 at 6:30pm

   Backstreets Cafe
   12352 Wilkins Ave.
   Rockville, MD 20852
   Cafe phone 301-984-0394

For a map or directions go here:
http://www.cfug-md.org/directions/directions.cfm

Topics
**
Getting to Know ColdFusion MX
by Rob Brooks-Bilson

Rob introduces many of the new features available in ColdFusion MX
through practical and meaningful examples.  Wherever possible,
real-world examples are provided that showcase new features and
functionality.  Highlights include adaptive tags, CFCs, UDF
enhancements, XML, and more.

Rob Brooks-Bilson is the Web technology manager at Amkor Technology,
where he has worked since 1996. Rob's involvement with ColdFusion goes
all the way back to version 1.5 and includes several large-scale
projects, the creation of numerous open source custom tags, and more
recently, CFLib.org and CFCzone.org where he coordinates several
libraries of freely available functions and CFCs.

He is the author of the O'Reilly book Programming ColdFusion and has
written several articles on ColdFusion for Macromedia, Intranet Design
Magazine, CFAdvisor, O'Reilly, and CNET's Builder.com. Rob is a
frequent speaker at ColdFusion user groups and conferences and is also
a Macromedia Certified Advanced ColdFusion Developer.



Getting High on Search Engines with Webposition Gold

by Arden Weiss

Arden will discuss how to increase your site's popularity with search
engines using the Webposition Gold tool.

Find out more at the meeting!

See the pix from the last meeting at
   http://www.cfug-md.org/pix/index.cfm
Meeting notes as always at
   http://www.cfug-md.org/meetings.cfm

A map and directions are at
   http://www.cfug-md.org/directions/directions.cfm
Parking is available both on street and in the next door FDA lot
after
6pm.


- CF Help --
Need expert ColdFusion, SQL and Access Programming? CF or Fusebox
training? Project stuck and need help? See http://www.teratech.com/
or
call TeraTech 800-447-9120 or email mailto:[EMAIL PROTECTED]. We
will get you moving fast!

--
Michael Smith, TeraTech Inc
VB, CF , SQL, Math programming
12221 Parklawn Dr Ste 200, Rockville MD 20852-1711 USA
Voice: +1-301-881-1440 x110, 800-447-9120  Fax:301-881-3586
Web: http://www.teratech.com/sig/
Email:  mailto:[EMAIL PROTECTED] ICQ: 66057682


__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: DWMX on OSX won't run!

[Vernon Viehe]

THere are literally thousands of folks with DWMX running on their OSX.

You might want to post your issue in the DW forums 
(http://www.macromedia.com/dreamweaver) They'd love to help! Tell'em I sentcha!

Vernon Viehe
ColdFusion Community Manager
Developer Relations
Macromedia, Inc.
Online diary: http://vvmx.blogspot.com/ 

> -Original Message-
> From: Dick Applebaum [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 04, 2002 3:29 PM
> To: CF-Talk
> Subject: DWMX on OSX won't run!
> 
> 
> Isn't that just the way things go?
> 
> CFMX OSX not supported, but runs (kinda')
> 
> DWMX OSX legitimate MM product, won't run.
> 
> Seriously, I have tried the beta and trial versions of DWMX and they 
> won't run
> 
> anybody else have this problem.
> 
> TIA
> 
> Dick
> 
> 
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CFMX on OSX

[Cary Gordon]

But there was no Flash in that past...

At 03:22 PM 6/4/2002 -0700, you wrote:
>Flash from the past  I worked on Maimframes with as little as 2K
>(tubes,before RAM)... my first micro had 4-16K the same as an IBM/360
>Mod 30... long, long ago... in another galexy

__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Client Variable Storage: Trouble Purging

[Matt Robertson]

Whats your db platform?  If its mySQL, CF can't purge it (although a workaround was 
published some time ago that you can cfschedule).  Let me know if you need it and I'll 
post it.

---
Matt Robertson[EMAIL PROTECTED]
MSB Designs, Inc., www.mysecretbase.com
---


-- Original Message --
from: Jamie Jackson <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Tue, 04 Jun 2002 18:17:52 -0400

Two questions:

*My registry seems to be corrupted, though it's hard to say. It has
swollen with client variables, and CF *seems* not to be able to purge
the old ones after the designated period. Is there a way to manually
purge them? I can't view the CF key in regedit, as regedit eats up
RAM/virtual memory when I try to access the CF part of the registry.

*Same sort of issue with DB client stores: CF isn't properly purging
unused client variables. It looks as though all rows created so far
(since ~1 week ago) are still there, though CF's supposed to clean
unused client variables after a day. Isn't CF supposed to handle these
deletes, or do I need to implement a DB job to handle it?

Thanks,
Jamie

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

DWMX on OSX won't run!

[Dick Applebaum]

Isn't that just the way things go?

CFMX OSX not supported, but runs (kinda')

DWMX OSX legitimate MM product, won't run.

Seriously, I have tried the beta and trial versions of DWMX and they 
won't run

anybody else have this problem.

TIA

Dick

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFMX on OSX

[Ben Johnson]

> Flash from the past  I worked on Maimframes with as little as 2K 
> (tubes,before RAM)... my first micro had 4-16K the same as an IBM/360 
> Mod 30... long, long ago... in another galexy

Wait... are you serious that it only has 256K of RAM?  Or was that a typo?




Ben Johnson
Hostworks, Inc.
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Understanding Macromedia MX Strategy

[Alexander Nasson]

> All,
> 
> Here is an easy way to understand the Macromedia MX strategy! 
> 
> Requires Flash Player.  
> 
> http://www.macromedia.com/software/mx/presentation/
> 
> Regards,
> 
> Alex Nasson
> 
> Alex Nasson
> Sr. Alliance Manager
> Eastern USA
> Macromedia
> [EMAIL PROTECTED]
> 
> 
> 
> 
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CFMX on OSX

[Dick Applebaum]

Flash from the past  I worked on Maimframes with as little as 2K 
(tubes,before RAM)... my first micro had 4-16K the same as an IBM/360 
Mod 30... long, long ago... in another galexy




On Tuesday, June 4, 2002, at 03:25  PM, Ben Johnson wrote:

>> The CPU is a G3 333 MHz with 256K RAM
>
> 256K RAM!?  Wow!  How do you run anything on there?  
>
>
>
> Ben Johnson
> Hostworks, Inc.
> 
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: lock an operation exclusive to the app?

[Matt Robertson]

Sure.  I'm working with a designer, doing the back end to his front-end.  One of my 
concerns is this 100k splash page (100k is the reduced version... Don't get me started 
on that subject).

index.cfm is a page that serves to either 
1. visit the splash page if the user's browser has Flash 5 (intro.cfm)
2. ask the user to upgrade to Flash 5 if they have a previous version 
(upgradeflash.cfm)
3. Ask the user to install Flash 5 if they don't have Flash (installflash.cfm)

Further, once a user is determined to have the proper Flash (case 1):
1. if they click the html 'Skip Intro' link they go to skipped.cfm, where they're 
CFLOCATION'd to main.cfm.
2. if they watch the movie, it dumps out to main.cfm, which is the actual home page 
for the site, and the 'home' link on the site menu.

None of the pages prior to main.cfm are on the menu.  you have to physically type in 
index.cfm, or the plain root url to do the above dance all over again. A session 
cookie traps whether or not they've been to the movies in the current session, and 
bypasses the tracking system referenced above to give a purer, per-real-person set of 
numbers.

bah, humbug.

---
Matt Robertson[EMAIL PROTECTED]
MSB Designs, Inc., www.mysecretbase.com
---


-- Original Message --
from: "Dina Hess" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Tue, 4 Jun 2002 13:10:32 -0500

> Every first-time visitor will hit this once.

maybe i don't understand what you're trying to do here, but i
don't see how access to this code will be limited to first-time
visitors only. can you clarify?

~ dina


__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFMX on OSX

[Ben Johnson]

> The CPU is a G3 333 MHz with 256K RAM

256K RAM!?  Wow!  How do you run anything on there?  



Ben Johnson
Hostworks, Inc.
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Client Variable Storage: Trouble Purging

[Jamie Jackson]

Two questions:

*My registry seems to be corrupted, though it's hard to say. It has
swollen with client variables, and CF *seems* not to be able to purge
the old ones after the designated period. Is there a way to manually
purge them? I can't view the CF key in regedit, as regedit eats up
RAM/virtual memory when I try to access the CF part of the registry.

*Same sort of issue with DB client stores: CF isn't properly purging
unused client variables. It looks as though all rows created so far
(since ~1 week ago) are still there, though CF's supposed to clean
unused client variables after a day. Isn't CF supposed to handle these
deletes, or do I need to implement a DB job to handle it?

Thanks,
Jamie
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFMX on OSX

[Dave Watts]

> If you want to play a little, here's CFMX Trial on OS X
> 
> http://66.126.111.58:8500/cfdocs/exampleapps/index.cfm?CFID=14
> 00&CFTOKEN=80561292
> 
> My ISP doesn't provide permanent IP addresses, so this will 
> go away when I disconnect.
> 
> This is a medium speed DSL Line.
> 
> The CPU is a G3 333 MHz with 256K RAM
> 
> I changed Application.cfm to allow examples to run from remote 
> IP addresses, so most things should work (execpt those requiring 
> separate processes).

In your page /myFile.cfm, you should add this:


Version: #Server.ColdFusion.ProductVersion#
#Server.ColdFusion.ProductLevel#
OS: #Server.OS.Name# #Server.OS.Version# #Server.OS.BuildNumber#
#Server.OS.AdditionalInformation#


Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CFMX on OSX

[Dick Applebaum]

Hey

If you want to play a little, here's CFMX Trial on OS X


http://66.126.111.58:8500/cfdocs/exampleapps/index.cfm?CFID=1400&CFTOKEN=80561292

My ISP doesn't provide permanent IP addresses, so this will go away when 
I disconnect.

This is a medium speed DSL Line.

The CPU is a G3 333 MHz with 256K RAM

I changed Application.cfm to allow examples to run from remote IP 
addresses, so most things should work (execpt those requiring separate 
processes).

Have fun

Dick

__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Weird, inconsistent browser behavior

[Jamie Jackson]

You *are* using cookies, unless you are passing cfid/cftoken in the
url.

Jamie

On Tue, 4 Jun 2002 14:41:33 -0700, in cf-talk you wrote:

>I thought of that but the site uses session vars, no cookies necessary.
>
>-Original Message-
>From: Brian Fox [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, June 04, 2002 2:39 PM
>To: CF-Talk
>Subject: RE: Weird, inconsistent browser behavior
>
>
>Cookies disabled?
>
>> -Original Message-
>> From: Ian Lurie [mailto:[EMAIL PROTECTED]]
>> Sent: Tuesday, June 04, 2002 2:32 PM
>> To: CF-Talk
>> Subject: Weird, inconsistent browser behavior
>>
>>
>> Hi all,
>>
>> I've got an application on a server. If I, or anyone else I
>> know, browse the
>> site, it works fine.
>>
>> ONE person is having the following problem: When they go to
>> the login screen
>> and enter a username/password, they keep coming back to the
>> login page. And
>> yes, they're entering the right password. It seems as if
>> their browser is
>> ignoring the URL parameter that tells CF to go on to the next
>> page. They're
>> using IE 5.5 SP1 on a Windows 2000 PC.
>>
>> Has anyone else experienced this?
>>
>> Ian
>>
>> Portent Interactive
>> Helping clients build customer relationships on the web since 1995
>> Consulting, design, development, measurement
>> http://www.portentinteractive.com
>> Talk with us: http://projects.portentinteractive.com
>>
>>
>
>
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Verity Search crashing CF Server 4

[Jason Miller]

Hello Group,
I have a verity index setup - PRetty much straight from the book - in fact - the 
sample code from a Ben Forta book was used as the indexing link.

It indexes about 8000 Word documents. Problem is after it indexes them - and I get the 
- indexing finished message. It crashes the server. No coldfusion
pages or verity searches will work until the server is rebooted.

Any ideas? This is not my server - it is on a hosted server - but I need to help 
pinpoint or find a solution. Everyday when my client indexes the .docs -
it crashes everyone's pages.

Also - when I clicked on the indexing link when we were testing - the server resources 
jumped to like 60% and more. Basically it is an open question
because I do not know where to start. Is it a CF Server/verity limit? is it the word 
.doc?
any helps or points int he right direction would be helpful.
jay miller
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Weird, inconsistent browser behavior

[Chris Kief]

After setting the session variables, are you then immediately
redirecting the user to the next page via ?



-Original Message-
From: Ian Lurie [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, June 04, 2002 2:42 PM
To: CF-Talk
Subject: RE: Weird, inconsistent browser behavior

I thought of that but the site uses session vars, no cookies necessary.

-Original Message-
From: Brian Fox [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 2:39 PM
To: CF-Talk
Subject: RE: Weird, inconsistent browser behavior


Cookies disabled?

> -Original Message-
> From: Ian Lurie [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 04, 2002 2:32 PM
> To: CF-Talk
> Subject: Weird, inconsistent browser behavior
>
>
> Hi all,
>
> I've got an application on a server. If I, or anyone else I
> know, browse the
> site, it works fine.
>
> ONE person is having the following problem: When they go to
> the login screen
> and enter a username/password, they keep coming back to the
> login page. And
> yes, they're entering the right password. It seems as if
> their browser is
> ignoring the URL parameter that tells CF to go on to the next
> page. They're
> using IE 5.5 SP1 on a Windows 2000 PC.
>
> Has anyone else experienced this?
>
> Ian
>
> Portent Interactive
> Helping clients build customer relationships on the web since 1995
> Consulting, design, development, measurement
> http://www.portentinteractive.com
> Talk with us: http://projects.portentinteractive.com
>
>


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Random Values generated in SQL

[Ben Johnson]

> Does anyone know in SQL how to generate 346 random selections from
> predefined list of 8 distinct values (A,B,C,D,E,F,G,H). I will be using
> query analyzer to complete this task, no coldfusion is involved.


Casey,
Can you be more specific?  Do you need 346 random rows?  Are you only
choosing one column per row or do you need several columns?  Also, is this
random or do you just need permutations/combinations of those 8 values?

Basically, can you give me a mini-example of the output that you want to
see?

Thanks.



Ben Johnson
Hostworks, Inc.

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Verity K2 & Localhost

[Jamie Jackson]

Is it possible to spider multiple sites with virtual directories off
of localhost (http://localhost/site1, http://localhost/site2, etc.),
or does the site have to live at http://localhost itself?

If not, doesn't that mean that you can't spider multiple sites, unless
you keep changing the destination of localhost in IIS for each
indexing job?

I have multiple sites on a single server, and I'd like to spider/index
a few of them.

Thanks,
Jamie
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: LDAP/Active Directory

[Timothy Heald]

That would be great.  The error messages are horrible.  You get LDAP Error
and that's about it.  At least with the SQL messages you get a clue :)

Tim Heald
ACP/CCFD :)
Application Development
www.schoollink.net

> -Original Message-
> From: LANCASTER, STEVEN M. (JSC-OL) (BAR)
> [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 04, 2002 5:37 PM
> To: CF-Talk
> Subject: RE: LDAP/Active Directory
>
>
> I have a guy here at work working on an LDAP server (brand New) I will get
> some info from him and pass it along to you.
>
> Steven Lancaster
> Barrios Technology
> NASA/JSC
> 281-244-2444 (voice)
> [EMAIL PROTECTED]
>
>
>
> -Original Message-
> From: Timothy Heald [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 04, 2002 4:15 PM
> To: CF-Talk
> Subject: LDAP/Active Directory
>
>
> Does anyone have links to good resources for using Active
> Directory through
> LDAP?  I am doing some work on this now, I have the tutorial out on the MM
> site, but I am also looking for anything I should look out for? Pitfalls
> people?
>
> TIA :)
>
> Tim Heald
> ACP/CCFD :)
> Application Development
> www.schoollink.net
>
>
> 
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Weird, inconsistent browser behavior

[Ian Lurie]

I thought of that but the site uses session vars, no cookies necessary.

-Original Message-
From: Brian Fox [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 2:39 PM
To: CF-Talk
Subject: RE: Weird, inconsistent browser behavior


Cookies disabled?

> -Original Message-
> From: Ian Lurie [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 04, 2002 2:32 PM
> To: CF-Talk
> Subject: Weird, inconsistent browser behavior
>
>
> Hi all,
>
> I've got an application on a server. If I, or anyone else I
> know, browse the
> site, it works fine.
>
> ONE person is having the following problem: When they go to
> the login screen
> and enter a username/password, they keep coming back to the
> login page. And
> yes, they're entering the right password. It seems as if
> their browser is
> ignoring the URL parameter that tells CF to go on to the next
> page. They're
> using IE 5.5 SP1 on a Windows 2000 PC.
>
> Has anyone else experienced this?
>
> Ian
>
> Portent Interactive
> Helping clients build customer relationships on the web since 1995
> Consulting, design, development, measurement
> http://www.portentinteractive.com
> Talk with us: http://projects.portentinteractive.com
>
>

__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Weird, inconsistent browser behavior

[Brian Fox]

Cookies disabled?

> -Original Message-
> From: Ian Lurie [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 04, 2002 2:32 PM
> To: CF-Talk
> Subject: Weird, inconsistent browser behavior
> 
> 
> Hi all,
> 
> I've got an application on a server. If I, or anyone else I 
> know, browse the
> site, it works fine.
> 
> ONE person is having the following problem: When they go to 
> the login screen
> and enter a username/password, they keep coming back to the 
> login page. And
> yes, they're entering the right password. It seems as if 
> their browser is
> ignoring the URL parameter that tells CF to go on to the next 
> page. They're
> using IE 5.5 SP1 on a Windows 2000 PC.
> 
> Has anyone else experienced this?
> 
> Ian
> 
> Portent Interactive
> Helping clients build customer relationships on the web since 1995
> Consulting, design, development, measurement
> http://www.portentinteractive.com
> Talk with us: http://projects.portentinteractive.com
> 
> 
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: LDAP/Active Directory

[LANCASTER, STEVEN M. (JSC-OL) (BAR)]

I have a guy here at work working on an LDAP server (brand New) I will get
some info from him and pass it along to you.

Steven Lancaster
Barrios Technology
NASA/JSC
281-244-2444 (voice)
[EMAIL PROTECTED] 

 

-Original Message-
From: Timothy Heald [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 4:15 PM
To: CF-Talk
Subject: LDAP/Active Directory


Does anyone have links to good resources for using Active Directory through
LDAP?  I am doing some work on this now, I have the tutorial out on the MM
site, but I am also looking for anything I should look out for? Pitfalls
people?

TIA :)

Tim Heald
ACP/CCFD :)
Application Development
www.schoollink.net


__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Weird, inconsistent browser behavior

[Ian Lurie]

Hi all,

I've got an application on a server. If I, or anyone else I know, browse the
site, it works fine.

ONE person is having the following problem: When they go to the login screen
and enter a username/password, they keep coming back to the login page. And
yes, they're entering the right password. It seems as if their browser is
ignoring the URL parameter that tells CF to go on to the next page. They're
using IE 5.5 SP1 on a Windows 2000 PC.

Has anyone else experienced this?

Ian

Portent Interactive
Helping clients build customer relationships on the web since 1995
Consulting, design, development, measurement
http://www.portentinteractive.com
Talk with us: http://projects.portentinteractive.com

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: OT: Design Rates

[Jerry Johnson]

Don't try to figure out how much an hour you can charge, figure how much an hour you 
need to earn.

If you KNOW what you need to carry you each month, you will be a little more hungry to 
sell.

It also makes it a lot easier to stick tough and not bargain down to get a particluar 
job when you realize hours worked vs rent paid.

And if you need to make rent, you might decide to hold a fire sale to get some money 
in the door.

Hourly rate is fluid for me.

As for pricing the job, I always try to get 50% up front, and 50% on completion of a 
job. This works most of the time (80%)
The second half payment is almost always delayed, even when they promise it won't be. 
30 day policies appear out of nowhere, scope creep, changed expectations, etc.

I always get enough in that first 50% to cover my costs and salary. Then if the second 
half is delayed or never paid, I am still afloat (pissed, but afloat)

I keep the jobs very short. Phases is the way to go. Even the initial design phase is 
a separate job. (Actually, the "blueprint" for a site is now the biggest segment of my 
consulting work)

HTH
Jerry Johnson




>>> [EMAIL PROTECTED] 06/04/02 04:27PM >>>
Well if you get alot of offers then your rate might be too low. If you get
nothing then your rate might be too high. Of course, this is not set in
stone. I recommend you learn as many languages, methodologies, databases,
and platforms as you can and do the shotgun approach. 

On Tue, 4 Jun 2002, Wallick, Mike wrote:

> Hey all. I'm about to dive into the world of freelancing and I was wondering
> - Where might I get a good idea of what to charge for my services? I was
> thinking that there would be separate costs for design (just how the page
> looks, not what it does) and actual programming tasks (site management, news
> board, forums, etc). I don't even know where to begin. Any advice would be
> great.
> Thanks.
>  
> Mike Wallick
> * Web Application Developer
> *  
> [EMAIL PROTECTED] 
> * 651.628.5377
> *   http://www.securecomputing.com/ 
>  
> 

__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

LDAP/Active Directory

[Timothy Heald]

Does anyone have links to good resources for using Active Directory through
LDAP?  I am doing some work on this now, I have the tutorial out on the MM
site, but I am also looking for anything I should look out for? Pitfalls
people?

TIA :)

Tim Heald
ACP/CCFD :)
Application Development
www.schoollink.net

__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFX_Zip & CFMX

[Sarsoun, Jeff]

If you don't get it working, I wrote a tag that can do similar things as
CFX_Zip, and it's free.
http://devex.macromedia.com/developer/gallery/searchresults.cfm?keywords=jco
mpress&search=search  Or if cfexecute is available on your server you could
use the command line version of winzip, it gives you greater flexibility.

Jeff

-Original Message-
From: Critz [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 7:20 AM
To: CF-Talk
Subject: CFX_Zip & CFMX


I'm trying to run cfx_zip on cfmx and apache.and keep getting this
error:

Exceptions

07:14:56.056 - coldfusion.tagext.DerivedNativeCFXException - in
C:\Inetpub\wwwroot\content\ziptest\ziptest.cfm : line 7

Error occurred in tag CFX_ZIP

does anyone know if this tag is working on cfmx? or is it just me?
(cuz that is very possible, course the code was a werkin before i
upgraded. Bah!)




-- 
Best regards,

Critter, MMCP
Certified ColdFusion Developer
 
Crit[s2k] - 


__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: OT: Design Rates

[Alex]

Well if you get alot of offers then your rate might be too low. If you get
nothing then your rate might be too high. Of course, this is not set in
stone. I recommend you learn as many languages, methodologies, databases,
and platforms as you can and do the shotgun approach. 

On Tue, 4 Jun 2002, Wallick, Mike wrote:

> Hey all. I'm about to dive into the world of freelancing and I was wondering
> - Where might I get a good idea of what to charge for my services? I was
> thinking that there would be separate costs for design (just how the page
> looks, not what it does) and actual programming tasks (site management, news
> board, forums, etc). I don't even know where to begin. Any advice would be
> great.
> Thanks.
>  
> Mike Wallick
> * Web Application Developer
> *  
> [EMAIL PROTECTED]
> * 651.628.5377
> *   http://www.securecomputing.com/
>  
> 
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Verity Search under FuseBox Methodology

[Dave Watts]

> How does one use the verity serach function under a fuse 
> box written site? Is there a better way to search for 
> information under FuseBox Technology?

It should work the same way with a Fusebox site as with a non-Fusebox site -
you index your documents and/or queries, and you provide a search form and
results page.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CFMX on OSX

[Dick Applebaum]

On Tuesday, June 4, 2002, at 01:01  PM, Drew Harris wrote:

> Well, that's cool.
> I like to see what you get when you get something.
> Also, If there is a way to get database interaction working that would 
> rock
> too.
> Does CFFILE work on OSX as is now?
>
> -Drew Harris
>
>

According to what I've been told, he only major CF facility that 
*definitely* won't work is Verity... is is an os-dependent C++ program.

Dick

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CFMX on OSX

[Dick Applebaum]

On Tuesday, June 4, 2002, at 01:01  PM, Drew Harris wrote:

> Well, that's cool.
> I like to see what you get when you get something.

I will post it as soon as I get it working

> Also, If there is a way to get database interaction working that would 
> rock
> too.

DB should work  because CF uses JDBC drivers.

The standalone install includes the PointBase RDBMS (written entirely in 
Java).  This should work in CFMX, because PointBase runs fine on OS X.


> Does CFFILE work on OSX as is now?

Yes, as far as I've tested:

   

   
   
   getTemplatepPath().|#getTemplatePath()#|
   len(fileIn)|#len(fileIn)#|
   
   

gives:

   getTemplatepPath().|/home/coldfusionmx/wwwroot/myFile.cfm|
   len(fileIn)|251|


Dick

>
> -Drew Harris
>

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Querying a table for its columns

[Chris Lofback]

I've done this in Oracle 8i and I would assume it can be done in SQLServer
and mySQL.  Here's what I did with Oracle:




select *
from #TableName#
where 1 = 0


Columns for #TableName#


select data_type, data_length, nullable from
user_tab_columns
where table_name = '#UCase(TableName)#'
and column_name = '#UCase(ColName)#'





#ColName# : #TempDetail#


There may be more efficient ways to do this rather than loop through the
columns and querying on each loop, but this was my quick hack!

Chris Lofback
Sr. Web Developer

TRX Integration
28051 US 19 N., Ste. C
Clearwater, FL  33761
www.trxi.com



-Original Message-
From: Jason Miller [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 3:54 PM
To: CF-Talk
Subject: Re: Querying a table for its columns


This came at a perfect time. - I am building a flash application with
coldfusion that queries a database, creates forms on the fly in flash so I
can have
1 mini app that can be used as a database updater (to merely update data in
existing columns) to any database - specifically for now access.

Anyone now of a good tutorial or someone who has done this in just cf and
html so I can check it out?

I am looking for similair variables that may be availabel along with
ColumnList - like - can I see what type of information it is? Or if it is a
drop
down list in Access? If i can sniff that out - so I can create a drop down
so it matches etc etc.

Hope this is clear - any good resources would be a great help.
thanks,
jason miller

Chris Lofback wrote:

> Here's one way:
>
> 
> select *
> from table
> where 1 = 0
> 
>
> (Use WHERE 1 = 0 so you get no records, but the ColumnList variable will
> still be populated.)
>
> 
> #Column#
> 
>
> Chris Lofback
> Sr. Web Developer
>
> TRX Integration
> 28051 US 19 N., Ste. C
> Clearwater, FL  33761
> www.trxi.com
>
> -Original Message-
> From: Eric Dawson [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 04, 2002 3:15 PM
> To: CF-Talk
> Subject: Querying a table for its columns
>
> Querying a table for its columns
>
> I can't remember the syntax for querying a table for its columns. I think
it
>
> is a mySQL table on CF 4.0x box.
>
> Eric
>
> 

__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

duplicate

[Robert Orlini]

Hello,

What does this error mean?

ODBC Error Code = S1000 (General error) [Microsoft][ODBC Microsoft Access Driver] 
Duplicate output destination 'Partnumbertwo'.
SQL = "UPDATE purchases 

Here is some of the code:

SQL = "UPDATE purchases 
SET Vendor = 'CDW Warehouse',
Invoicenumber = '989MMPQh',
Contact = 'John Q. Public',
Address = 'Main street',
address2 = '',
City = 'Jackson',
State = 'KY',
Zip = '20020',
Country = '',
Phone = '88',
Qtytwo = 0.0,
Descriptiontwo = '',
Partnumbertwo = '',
Costeachtwo = 0.0,
Totaltwo = 0.0,
Comments = ''
Where ID = 1710"Data Source = "PURCHASES"The error occurred while processing 
an element with a general identifier of (CFQUERY), occupying document position (4:1) 
to (4:46) in the template file d:\InetPub\wwwroot\Adeleforms\getpurchaseorder2a.cfm

Thanks ahead for the help/advice.

Robert O.
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Double Quotes and pre-filling a form input field

[Charlie]

thank you.this works...


- Original Message -
From: "Justin Scott" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, June 04, 2002 4:01 PM
Subject: Re: Double Quotes and pre-filling a form input field


> value="#htmleditformat(myQuery.fieldname)#"
>
> -Justin Scott, Lead Developer
>  Sceiron Internet Services, Inc.
>  http://www.sceiron.com
>
>
> - Original Message -
> From: "Charlie" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, June 04, 2002 3:51 PM
> Subject: Double Quotes and pre-filling a form input field
>
>
> > 
> >
> >
> > the particular data in this field may have double quotes within the
> textwhen this occurs, the form continues to work but the value
displayed
> in the form field gets truncated at the first quote within the datafield
> >
> > any advice on preserving the text of  #myQuery.fieldname# in instances
> where it might contain double quotes
> >
> >
> 
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE:

[Rob Baxter]

No, you are right. Mapped drives are specific to the currently logged in
user. That's why UNC paths are much better in this case as they don't
require the user to be actively logged in to work.



-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 3:44 PM
To: CF-Talk
Subject: RE: mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 2:12 PM
To: CF-Talk
Subject: RE:  > What user is CF running under?
>
> The user logged in that created the mapped drive letter
> has Administrator privileges.

That doesn't mean that the user account of the CF server will be able to see
the drive mapping. By default, CF runs as SYSTEM, rather than as a specific
user. You might find this helpful:

http://www.defusion.com/articles/index.cfm?ArticleID=89

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444


__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Querying a table for its columns

[Jerry Johnson]

On mySQL, you want the marvelous SHOW command.

SHOW [FULL] COLUMNS FROM tbl_name [FROM db_name] [LIKE wild]

Docs: http://www.mysql.com/doc/S/H/SHOW.html


>>> [EMAIL PROTECTED] 06/04/02 03:14PM >>>
Querying a table for its columns

I can't remember the syntax for querying a table for its columns. I think it 
is a mySQL table on CF 4.0x box.

Eric



__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Double Quotes and pre-filling a form input field

[Helen Simpson]

Have you tried putting single quotes around the variable name? 

Helen


At 03:51 PM 6/4/02, you wrote:
> 
>
>
>the particular data in this field may have double quotes within the textwhen this 
>occurs, the form continues to work but the value displayed in the form field gets 
>truncated at the first quote within the datafield
>
>any advice on preserving the text of  #myQuery.fieldname# in instances where it might 
>contain double quotes
> 
>
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Querying a table for its columns

[Jason Miller]

This came at a perfect time. - I am building a flash application with coldfusion that 
queries a database, creates forms on the fly in flash so I can have
1 mini app that can be used as a database updater (to merely update data in existing 
columns) to any database - specifically for now access.

Anyone now of a good tutorial or someone who has done this in just cf and html so I 
can check it out?

I am looking for similair variables that may be availabel along with ColumnList - like 
- can I see what type of information it is? Or if it is a drop
down list in Access? If i can sniff that out - so I can create a drop down so it 
matches etc etc.

Hope this is clear - any good resources would be a great help.
thanks,
jason miller

Chris Lofback wrote:

> Here's one way:
>
> 
> select *
> from table
> where 1 = 0
> 
>
> (Use WHERE 1 = 0 so you get no records, but the ColumnList variable will
> still be populated.)
>
> 
> #Column#
> 
>
> Chris Lofback
> Sr. Web Developer
>
> TRX Integration
> 28051 US 19 N., Ste. C
> Clearwater, FL  33761
> www.trxi.com
>
> -Original Message-
> From: Eric Dawson [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 04, 2002 3:15 PM
> To: CF-Talk
> Subject: Querying a table for its columns
>
> Querying a table for its columns
>
> I can't remember the syntax for querying a table for its columns. I think it
>
> is a mySQL table on CF 4.0x box.
>
> Eric
>
> 
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFMX on OSX

[Jesse Noller]

Hmm. I need to write a hacker-guide to porting CFMX, but the only thing that would not 
work would be OS level parts/C(++) components. The drivers are JDBC, and contained in 
jars, so they would logically work, etc.

As for CFFILE, I doubt that that would work, i can remember if CFFILE just does a Java 
Exec call though. it could very well work.

-jesse

> -Original Message-
> From: Drew Harris [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 04, 2002 4:01 PM
> To: CF-Talk
> Subject: Re: CFMX on OSX
> 
> 
> Well, that's cool.
> I like to see what you get when you get something.
> Also, If there is a way to get database interaction working 
> that would rock
> too.
> Does CFFILE work on OSX as is now?
> 
> -Drew Harris
> 
> On 6/4/02 2:16 PM, "Dick Applebaum" <[EMAIL PROTECTED]> wrote:
> 
> > Yeah, that was weeks ago... I have been off tending to 
> personal issues.
> > 
> > In the meantime, the trial version was announced.
> > 
> > Where I was when I got sidetracked was:
> > 
> > CFMX RC1 was installed and partially running on OS X
> > 
> > JRun And the ColdFusion server were running
> > 
> > basic .cfm pages were interpreted and served correctly
> > 
> > Anything that required an additional process (db, graphics, web
> > services, etc) was *Not* running under OS X... the program 
> that launches
> > these processes is /bin/cfusion.  It is an intel native C++ 
> program and
> > will *not* run on OS X.
> > 
> > I  have been able to get  the same results with the Trial version.
> > 
> > I did  not want to generally post a partial quick-and-dirty 
> solution...
> > and create busy-work for a lot of people.
> > 
> > I did send responses with the info to those who emailled me 
> privately.
> > 
> > I am told that the cfusion C++ file can be bypassed with 
> shell scripts.
> > 
> > I am waiting for more info & will post a complete working solution
> > (except verity) when I have one.
> > 
> > It should be noted, that this is not supported by MM.
> > 
> > But, the stuff that works, works pretty well.
> > 
> > I am really looking forward to having a local IDE which 
> includes CFMX
> > server (and JRun)  running on a Mac (Native).
> > 
> > Dick
> > 
> > 
> > 
> > On Friday, May 31, 2002, at 12:53  PM, Drew Harris wrote:
> > 
> >> I'd love to see a step by step white paper for getting 
> CFMX running on
> >> the
> >> Mac OSX...
> >> 
> >> Anyone...?
> >> 
> >> -Drew Harris
> >> 
> >> On 5/29/02 12:33 PM, "Neil Clark - =TMM="
> >> <[EMAIL PROTECTED]>
> >> wrote:
> >> 
> >>> Oops, got carried away with the send button but...Yep, it was Dick
> >>> Applebaum.
> >>> 
> >>> I am intrigued also, he said he would post something in a 
> few days,
> >>> that
> >>> was weeks ago!
> >>> 
> >>> 
> >>> 
> >>> 
> >>> 
> >>> Neil Clark
> >>> Team Macromedia
> >>> http://www.macromedia.com/go/team
> >>> 
> >>> Announcing Macromedia MX!!
> >>> http://www.macromedia.com/software/trial/
> >>> 
> >>> 
> >>> 
> >>> 
> >>> -Original Message-
> >>> From: Venable, John [mailto:[EMAIL PROTECTED]]
> >>> Sent: 29 May 2002 18:26
> >>> To: CF-Talk
> >>> Subject: CFMX on OSX
> >>> 
> >>> Sorry to be a pest but wasn't someone going to post a 
> how-to on how
> >>> they
> >>> got
> >>> CFMX running on OSX?
> >>> 
> >>> Thanks in advance,
> >>> 
> >>> John Venable
> >>> 
> >>> 
> > 
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Double Quotes and pre-filling a form input field

[Justin Scott]

value="#htmleditformat(myQuery.fieldname)#"

-Justin Scott, Lead Developer
 Sceiron Internet Services, Inc.
 http://www.sceiron.com


- Original Message -
From: "Charlie" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, June 04, 2002 3:51 PM
Subject: Double Quotes and pre-filling a form input field


> 
>
>
> the particular data in this field may have double quotes within the
textwhen this occurs, the form continues to work but the value displayed
in the form field gets truncated at the first quote within the datafield
>
> any advice on preserving the text of  #myQuery.fieldname# in instances
where it might contain double quotes
>
> 
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CFMX on OSX

[Drew Harris]

Well, that's cool.
I like to see what you get when you get something.
Also, If there is a way to get database interaction working that would rock
too.
Does CFFILE work on OSX as is now?

-Drew Harris

On 6/4/02 2:16 PM, "Dick Applebaum" <[EMAIL PROTECTED]> wrote:

> Yeah, that was weeks ago... I have been off tending to personal issues.
> 
> In the meantime, the trial version was announced.
> 
> Where I was when I got sidetracked was:
> 
> CFMX RC1 was installed and partially running on OS X
> 
> JRun And the ColdFusion server were running
> 
> basic .cfm pages were interpreted and served correctly
> 
> Anything that required an additional process (db, graphics, web
> services, etc) was *Not* running under OS X... the program that launches
> these processes is /bin/cfusion.  It is an intel native C++ program and
> will *not* run on OS X.
> 
> I  have been able to get  the same results with the Trial version.
> 
> I did  not want to generally post a partial quick-and-dirty solution...
> and create busy-work for a lot of people.
> 
> I did send responses with the info to those who emailled me privately.
> 
> I am told that the cfusion C++ file can be bypassed with shell scripts.
> 
> I am waiting for more info & will post a complete working solution
> (except verity) when I have one.
> 
> It should be noted, that this is not supported by MM.
> 
> But, the stuff that works, works pretty well.
> 
> I am really looking forward to having a local IDE which includes CFMX
> server (and JRun)  running on a Mac (Native).
> 
> Dick
> 
> 
> 
> On Friday, May 31, 2002, at 12:53  PM, Drew Harris wrote:
> 
>> I'd love to see a step by step white paper for getting CFMX running on
>> the
>> Mac OSX...
>> 
>> Anyone...?
>> 
>> -Drew Harris
>> 
>> On 5/29/02 12:33 PM, "Neil Clark - =TMM="
>> <[EMAIL PROTECTED]>
>> wrote:
>> 
>>> Oops, got carried away with the send button but...Yep, it was Dick
>>> Applebaum.
>>> 
>>> I am intrigued also, he said he would post something in a few days,
>>> that
>>> was weeks ago!
>>> 
>>> 
>>> 
>>> 
>>> 
>>> Neil Clark
>>> Team Macromedia
>>> http://www.macromedia.com/go/team
>>> 
>>> Announcing Macromedia MX!!
>>> http://www.macromedia.com/software/trial/
>>> 
>>> 
>>> 
>>> 
>>> -Original Message-
>>> From: Venable, John [mailto:[EMAIL PROTECTED]]
>>> Sent: 29 May 2002 18:26
>>> To: CF-Talk
>>> Subject: CFMX on OSX
>>> 
>>> Sorry to be a pest but wasn't someone going to post a how-to on how
>>> they
>>> got
>>> CFMX running on OSX?
>>> 
>>> Thanks in advance,
>>> 
>>> John Venable
>>> 
>>> 
> 
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Double Quotes and pre-filling a form input field

[Bryan Stevenson]

you could replace the double quotes in the data to be used in the value of the form 
element with
their ASCII equivalent

Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com

- Original Message -
From: "Charlie" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, June 04, 2002 12:51 PM
Subject: Double Quotes and pre-filling a form input field


> 
>
>
> the particular data in this field may have double quotes within the textwhen 
>this occurs, the
form continues to work but the value displayed in the form field gets truncated at the 
first quote
within the datafield
>
> any advice on preserving the text of  #myQuery.fieldname# in instances where it 
>might contain
double quotes
>
> 
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Querying a table for its columns

[Tony_Petruzzi]

oh yeah. god forbid the table has 10,000 and more records in it. The query
would take a while. Goto groups.google.com and do a search there. I have
seen this posted for Access, mssql, and mysql before.

Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org


-Original Message-
From: Shawn Grover [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 3:41 PM
To: CF-Talk
Subject: RE: Querying a table for its columns


one method, which would avoid system tables, or other vendor specific
methods, would be to simply do a "Select * From Table" using CFQUERY, then
using the ColumnList field in the result list - it's a comma delimited list
of all the columns.

On SQL Server you can query the system tables (I think it's sysobjects you
want here).  I'm not sure about the system tables or methods available to
Oracle or MySQL.

Hope that helps.

Shawn Grover

-Original Message-
From: Eric Dawson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 1:15 PM
To: CF-Talk
Subject: Querying a table for its columns


Querying a table for its columns

I can't remember the syntax for querying a table for its columns. I think it

is a mySQL table on CF 4.0x box.

Eric




__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Double Quotes and pre-filling a form input field

[Charlie]

 


the particular data in this field may have double quotes within the textwhen this 
occurs, the form continues to work but the value displayed in the form field gets 
truncated at the first quote within the datafield

any advice on preserving the text of  #myQuery.fieldname# in instances where it might 
contain double quotes
 
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Querying a table for its columns

[Jim Curran]

>From CF,



select * from my table



#myQuery.columnlist#

- j


-Original Message-
From: Eric Dawson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 3:15 PM
To: CF-Talk
Subject: Querying a table for its columns


Querying a table for its columns

I can't remember the syntax for querying a table for its columns. I think it
is a mySQL table on CF 4.0x box.

Eric



__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

OT: Random Values generated in SQL

[Casey C Cook]

Hello -

Does anyone know in SQL how to generate 346 random selections from
predefined list of 8 distinct values (A,B,C,D,E,F,G,H). I will be using
query analyzer to complete this task, no coldfusion is involved.

Thanks for your help.
Casey Cook

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Querying a table for its columns

[Chris Lofback]

Here's one way:


select *
from table
where 1 = 0


(Use WHERE 1 = 0 so you get no records, but the ColumnList variable will
still be populated.)


#Column#


Chris Lofback
Sr. Web Developer

TRX Integration
28051 US 19 N., Ste. C
Clearwater, FL  33761
www.trxi.com



-Original Message-
From: Eric Dawson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 3:15 PM
To: CF-Talk
Subject: Querying a table for its columns


Querying a table for its columns

I can't remember the syntax for querying a table for its columns. I think it

is a mySQL table on CF 4.0x box.

Eric



__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Querying a table for its columns

[Mark A. Kruger - CFG]

Eric,

If its mySql you can try "describe tablename" and it will return a query one
of which is the column name.  If it's SQL server, you can use sp_columns
tablename.

-Original Message-
From: Eric Dawson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 2:15 PM
To: CF-Talk
Subject: Querying a table for its columns


Querying a table for its columns

I can't remember the syntax for querying a table for its columns. I think it
is a mySQL table on CF 4.0x box.

Eric



__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Querying a table for its columns

[Shawn Grover]

one method, which would avoid system tables, or other vendor specific
methods, would be to simply do a "Select * From Table" using CFQUERY, then
using the ColumnList field in the result list - it's a comma delimited list
of all the columns.

On SQL Server you can query the system tables (I think it's sysobjects you
want here).  I'm not sure about the system tables or methods available to
Oracle or MySQL.

Hope that helps.

Shawn Grover

-Original Message-
From: Eric Dawson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 1:15 PM
To: CF-Talk
Subject: Querying a table for its columns


Querying a table for its columns

I can't remember the syntax for querying a table for its columns. I think it

is a mySQL table on CF 4.0x box.

Eric



__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE:

[Mark A. Kruger - CFG]

Yes.. we have found that the cf server must have permissions and running as
that user AND That the user himself usually must be logged into the desktop
to use a "mapped" drive.  However, UNC mappings should work regardless of
whether the user is logged into the desktop. Perhaps someone else has a
different experience with how to get to mapped drives.

Mark

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 2:12 PM
To: CF-Talk
Subject: RE:  > What user is CF running under?
>
> The user logged in that created the mapped drive letter
> has Administrator privileges.

That doesn't mean that the user account of the CF server will be able to see
the drive mapping. By default, CF runs as SYSTEM, rather than as a specific
user. You might find this helpful:

http://www.defusion.com/articles/index.cfm?ArticleID=89

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: cfml.exe

[Dave Watts]

> Running cfml.exe from a .bat file is a great way to use 
> the windows scheduler and has other uses as well but...
> 
> Is there a way to "fake" a Form or URL post to the files?
> 
>  arguments="d:\pathtofile\file.cfm?NoVar=Passed"\>
> 
> Here, NoVar is not passed in the URL scope. Obviously 
> because we bypassed the webserver. I just think there must 
> be some subtle workaround that I am missing.

You can send URL parameters by simply setting a QUERY_STRING environment
variable before running CFML.EXE. I've done this using a batch file like
this:

SET CF_TEMPLATE_PATH=c:\inetpub\wwwroot\myfile.cfm
SET QUERY_STRING=NoVar=Passed
C:\CFUSION\BIN\CFML.EXE

I don't know how you'd pass form data that way, though.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: cfml.exe

[Joseph Thompson]

Thanks!  That makes perfect sense. 


> 
> Is there a way to "fake" a Form or URL post to the files?
> 

> Sure.  Have your scheduled event call a file that contains a CFHTTP post
> to the operative template.



__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CFMX on OSX

[Dick Applebaum]

Yeah, that was weeks ago... I have been off tending to personal issues.

In the meantime, the trial version was announced.

Where I was when I got sidetracked was:

CFMX RC1 was installed and partially running on OS X

JRun And the ColdFusion server were running

basic .cfm pages were interpreted and served correctly

Anything that required an additional process (db, graphics, web 
services, etc) was *Not* running under OS X... the program that launches 
these processes is /bin/cfusion.  It is an intel native C++ program and 
will *not* run on OS X.

I  have been able to get  the same results with the Trial version.

I did  not want to generally post a partial quick-and-dirty solution... 
and create busy-work for a lot of people.

I did send responses with the info to those who emailled me privately.

I am told that the cfusion C++ file can be bypassed with shell scripts.

I am waiting for more info & will post a complete working solution 
(except verity) when I have one.

It should be noted, that this is not supported by MM.

But, the stuff that works, works pretty well.

I am really looking forward to having a local IDE which includes CFMX 
server (and JRun)  running on a Mac (Native).

Dick



On Friday, May 31, 2002, at 12:53  PM, Drew Harris wrote:

> I'd love to see a step by step white paper for getting CFMX running on 
> the
> Mac OSX...
>
> Anyone...?
>
> -Drew Harris
>
> On 5/29/02 12:33 PM, "Neil Clark - =TMM=" 
> <[EMAIL PROTECTED]>
> wrote:
>
>> Oops, got carried away with the send button but...Yep, it was Dick
>> Applebaum.
>>
>> I am intrigued also, he said he would post something in a few days, 
>> that
>> was weeks ago!
>>
>>
>>
>>
>>
>> Neil Clark
>> Team Macromedia
>> http://www.macromedia.com/go/team
>>
>> Announcing Macromedia MX!!
>> http://www.macromedia.com/software/trial/
>>
>>
>>
>>
>> -Original Message-
>> From: Venable, John [mailto:[EMAIL PROTECTED]]
>> Sent: 29 May 2002 18:26
>> To: CF-Talk
>> Subject: CFMX on OSX
>>
>> Sorry to be a pest but wasn't someone going to post a how-to on how 
>> they
>> got
>> CFMX running on OSX?
>>
>> Thanks in advance,
>>
>> John Venable
>>
>> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: cfml.exe

[Jeff Beer]

Sure.  Have your scheduled event call a file that contains a CFHTTP post
to the operative template.

-Original Message-
From: Joseph Thompson [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, June 04, 2002 1:37 PM
To: CF-Talk
Subject: cfml.exe


Running cfml.exe from a .bat file is a great way to use the windows
scheduler and has other uses as well but...

Is there a way to "fake" a Form or URL post to the files?



Here, NoVar is not passed in the URL scope.  Obviously because we
bypassed the webserver.  I just think there must be some subtle
workaround that I am missing.

Thanks for any tips!




__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Verity Search under FuseBox Methodolgy

[Dave Clay]

How does one use the verity serach function under a fuse box written site?  Is there a 
better way to search for information under FuseBox Technology?

Any help would be great
Thanks Dave Clay
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Querying a table for its columns

[Eric Dawson]

Querying a table for its columns

I can't remember the syntax for querying a table for its columns. I think it 
is a mySQL table on CF 4.0x box.

Eric


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

OT: Design Rates

[Wallick, Mike]

Hey all. I'm about to dive into the world of freelancing and I was wondering
- Where might I get a good idea of what to charge for my services? I was
thinking that there would be separate costs for design (just how the page
looks, not what it does) and actual programming tasks (site management, news
board, forums, etc). I don't even know where to begin. Any advice would be
great.
Thanks.
 
Mike Wallick
* Web Application Developer
*  
[EMAIL PROTECTED]
* 651.628.5377
*   http://www.securecomputing.com/
 
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE:

[Dave Watts]

> > What user is CF running under?
> 
> The user logged in that created the mapped drive letter 
> has Administrator privileges.

That doesn't mean that the user account of the CF server will be able to see
the drive mapping. By default, CF runs as SYSTEM, rather than as a specific
user. You might find this helpful:

http://www.defusion.com/articles/index.cfm?ArticleID=89

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: unscoped variables

[Max Paperno]

At 6/4/2002 10:12 AM -0500, Paul Giesenhagen wrote:
>If they are created in the Application.cfm page, they are application
>variables (application.whatever)

That's incorrect.  Unscoped variables are created in the variables. scope no matter 
where they are defined.

-Max

__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re:

[phumes1]

Only if I run it manually from a command prompt.

Not with On Tue, 04 Jun 2002 13:34:57 -0400, in cf-talk you wrote:
>
> >d:
> >cd /dir1/dir2
> >c:/programdir/subdir/runme.exe d:/temp1/temp2/filename 
> >
> >
> >This works as long as I change the directory path.
> >
> >How can I do the above (change directory) and use  >interface?
>
>Unless my ginko isn't working today, you'll probably get several
>replies asking if you've tried simply putting those three lines in a
>bat file and cfexecute-ing the bat.
>
>That work?
>
>--min
>
>
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re:

[phumes1]

At 02:35 PM 6/4/2002 -0400, you wrote:
>What user is CF running under?


The user logged in that created the mapped drive letter has Administrator 
privileges.

>Does that user have the drive mapped?

Yes.

>Do you have rights as that user to that drive?

Administrator

>If any of this is too difficult, try using UNC file names rather than 
>relying on mapped drives.
>(This is my standard answer for any drive mapping questions :)

Tried this also without any success.


>Jerry Johnson
>
> >>> [EMAIL PROTECTED] 06/04/02 02:19PM >>>
>On our server I have a mapped drive letter "Q" pointing to a directory on
>another server.
>
>I'm trying to read in a file off the server but I keep getting an error.
>Can't I specify a mapped drive letter in CFFILE?
>
>
>
>
>#FileContents#
>
>
>This is the error:
>
>Error processing CFFILE
>Error attempting to read 'Q:/dir1/filename.txt.' Access is denied. (error 5)
>The error occurred while processing an element with a general identifier of
>(CFFILE), occupying document position (112:1) to (112:65).
>Date/Time: 06/04/02 14:19:41
>Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; msnca3; Q312461)
>
>
>
>+---+ 
>
>
>Philip Humeniuk
>[EMAIL PROTECTED]
>[EMAIL PROTECTED]
>++
>
>
>
>
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Oracle Exporting Table structures

[Deanna Schneider]

You can do it with sql navigator by right clicking on the object and
selecting "extract ddl." You can also do it manually (sort of) by querying a
bunch of tables from the data dictionary.

-d



Deanna Schneider
Interactive Media Developer
[EMAIL PROTECTED]


__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re:

[Lewis Sellers]

On Tue, 04 Jun 2002 13:34:57 -0400, in cf-talk you wrote:

>d:
>cd /dir1/dir2
>c:/programdir/subdir/runme.exe d:/temp1/temp2/filename 
>
>
>This works as long as I change the directory path.
>
>How can I do the above (change directory) and use interface?

Unless my ginko isn't working today, you'll probably get several
replies asking if you've tried simply putting those three lines in a
bat file and cfexecute-ing the bat.

That work?

--min

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CFMAIL through MS Exchange

[Howie Hamlin]

CFMAIL does not support authenticated SMTP so you can't do that.  The best thing would 
be to have your administrator allow mail
relay via IP address and allow the IP address of your CF machine.

HTH,

--
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. - www.CoolFusion.com  - 631-737-4668 x101
inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server
>>> Find out how iMS Stacks up to the competition: 
>http://www.coolfusion.com/imssecomparison.cfm

- Original Message -
From: "stas" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, June 04, 2002 2:22 PM
Subject: CFMAIL through MS Exchange


> Hello,
>
> Is there a way to send e-mail (using CFMAIL) when relaying has been turned
> off on the Exchange side? I can send with any e-mail program by supplying a
> username/password. Thanks!
>
>
>
>
> 
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re:

[Jerry Johnson]

What user is CF running under?
Does that user have the drive mapped?
Do you have rights as that user to that drive?

If any of this is too difficult, try using UNC file names rather than relying on 
mapped drives.
(This is my standard answer for any drive mapping questions :)

Jerry Johnson

>>> [EMAIL PROTECTED] 06/04/02 02:19PM >>>
On our server I have a mapped drive letter "Q" pointing to a directory on 
another server.

I'm trying to read in a file off the server but I keep getting an error. 
Can't I specify a mapped drive letter in CFFILE?




#FileContents#


This is the error:

Error processing CFFILE
Error attempting to read 'Q:/dir1/filename.txt.' Access is denied. (error 5)
The error occurred while processing an element with a general identifier of 
(CFFILE), occupying document position (112:1) to (112:65).
Date/Time: 06/04/02 14:19:41
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; msnca3; Q312461)



+---+ 

Philip Humeniuk
[EMAIL PROTECTED] 
[EMAIL PROTECTED] 
++



__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE:

[Mark A. Kruger - CFG]

Only if you are using an account for cf server and you are logged into that
server as that user. It's tricky.  Unc paths are easier to work with.  Just
make sure you have permissions and use:

\\servername\sharename\filename


Mark

-Original Message-
From: phumes1 [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 1:19 PM
To: CF-Talk
Subject: 


#FileContents#


This is the error:

Error processing CFFILE
Error attempting to read 'Q:/dir1/filename.txt.' Access is denied. (error 5)
The error occurred while processing an element with a general identifier of
(CFFILE), occupying document position (112:1) to (112:65).
Date/Time: 06/04/02 14:19:41
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; msnca3; Q312461)



+---
+

Philip Humeniuk
[EMAIL PROTECTED]
[EMAIL PROTECTED]
+---
-+



__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CFMAIL through MS Exchange

[stas]

Hello,

Is there a way to send e-mail (using CFMAIL) when relaying has been turned
off on the Exchange side? I can send with any e-mail program by supplying a
username/password. Thanks!




__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

cf-talk@houseoffusion.com

[phumes1]

On our server I have a mapped drive letter "Q" pointing to a directory on 
another server.

I'm trying to read in a file off the server but I keep getting an error. 
Can't I specify a mapped drive letter in CFFILE?




#FileContents#


This is the error:

Error processing CFFILE
Error attempting to read 'Q:/dir1/filename.txt.' Access is denied. (error 5)
The error occurred while processing an element with a general identifier of 
(CFFILE), occupying document position (112:1) to (112:65).
Date/Time: 06/04/02 14:19:41
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; msnca3; Q312461)



+---+ 

Philip Humeniuk
[EMAIL PROTECTED]
[EMAIL PROTECTED]
++


__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: lock an operation exclusive to the app?

[Dina Hess]

> Every first-time visitor will hit this once.

maybe i don't understand what you're trying to do here, but i
don't see how access to this code will be limited to first-time
visitors only. can you clarify?

~ dina

__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Coldfusion & My Acocunting System

[Alex]

Sure it's possible. I prefer simple systems myself. Think about how
maintainable and flexible this is. Just by reading your email it sounds
like a pile of sh*t. Of course, given a good rate you could get someone to
do it for you.

On Tue, 4 Jun 2002, Kris Pilles wrote:

> We've got CF 5 on win 2k server
> Oracle on Unix box
> And our accountign system (UNIX) bascially compiles of .qpt files and
> quiz files
> 
> I have to determine if there is anyway for us to take our existing .QPT
> files via custom tags or stored procedures/UDF's or whatever and
> continue to use them for all of our business logic for our new
> coldfusion based accounting system.  Our goal is to move all of our data
> away from CI-Sam flat files and into an Oracle backend while using
> coldfusion to web enable the application and our QTP files for the
> logic.  Has anyone had any experience with anything like this??  Any
> thoughts on how possible this is?? Ideas...suggesstions... I'm
> listening...
> 
> Thanks
> 
> KP 
> 
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Re[2]: Is this possible to do?

[Tony_Petruzzi]

well sortof. when you pass in the value to the storedprocedure, MSSQL looks
at the string as a whole. to demostrate

mylist = "me, myself, and I"

to MSSQL, the string looks like:

'me, myself, and I'

even if you enclose each element in " ' ".

mylist = "'me', 'myself', 'and I'"

MSSQL looks at it like

'''me'', ''myself'', ''and I'''

notice that it will escape the " ' ". Much like you doing

john''s book

this is actually a known limitation. there is alot more information on this
in the groups.google.com archives. probably better explaination to. :)



Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org


-Original Message-
From: chad [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 1:30 PM
To: CF-Talk
Subject: RE: Re[2]: Is this possible to do?


Isnt this because you need single quotes around your list items?


At 01:15 PM 6/4/2002 -0400, you wrote:
>just to throw a tidbit out there. Remember that if you use MSSQL server you
>cannot use IN inside a stored procedure that you are passign the list in.
>
>such that
>
>Store Procedure
>===
>
>CREATE PROCEDURE ProcessList
>
> @myList varchar(255)
>
>As
>
>SELECT *
>FROM MyTable
>WHERE myColumn IN (@myList)
>
>
>
>   datasource="#request.dsn#"
>   username="#request.username#"
>   password="#request.password#">
> dbvarname="@mylist" value="#variables.mylist#" maxlength="255" null="No">
> 
>
>
>
>This would fail. There are somework arounds. Use can use dynamic sql:
>
>EXEC 'SELECT * FROM MyTable WHERE myColumn IN (' + @myList + ')'
>
>this stinks because you have to give the user access to the table and not
>just stored procedure access, so this is a little bit of a security risk in
>your application.
>
>OR
>
>if you are using SQL Server 2000 you can write list functions.
>
>http://www.xcreation.com/downloads/ListGetAt.sql
>
>
>Anthony Petruzzi
>Webmaster
>954-321-4703
>[EMAIL PROTECTED]
>http://www.sheriff.org
>
>
>-Original Message-
>From: Tony Carcieri [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, June 04, 2002 12:52 PM
>To: CF-Talk
>Subject: RE: Re[2]: Is this possible to do?
>
>
>Critz and Gyrus,
>
>I think I need more caffeine. I STUPIDLY forgot to do: WHERE ID IN
>(#form.ID#). Yup, those damn parens do it all the time. ARGH!
>*gets up, smashes head on monitor, and stomps off to get more coffee*
>
>Thanks,
>T
>
>-Original Message-
>From: Critz [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, June 04, 2002 11:58 AM
>To: CF-Talk
>Subject: Re[2]: Is this possible to do?
>
>
>oi Tony!!
>
>si  Tony  is  correct.  all  you would need would be the one fieldname,
>since if
>there  are  more  than  one, their values are passed thru in a list. And
>even if
>there is only one. the [IN(#form.id#)] will still work
>
>
>--
>Critz
>Certified Adv. ColdFusion Developer
>
>Crit[s2k] - 
>
>Tuesday, June 4, 2002, 11:28:40 AM, you wrote:
>
>TC> But this would also include the form field SUBMIT which, obviously,
>isn't
>TC> part of the DB. Right?
>
>TC> -Original Message-
>TC> From: Gyrus [mailto:[EMAIL PROTECTED]]
>TC> Sent: Tuesday, June 04, 2002 11:18 AM
>TC> To: CF-Talk
>TC> Subject: Re: Is this possible to do?
>
>
>TC> - Original Message -
>TC> From: "Tony Carcieri" <[EMAIL PROTECTED]>
>TC> --snip--
>TC> 
>TC>UPDATE mytable
>TC>SET IsDeleted = 1
>TC>
>TC>WHERE ID = '#form.ID#'
>TC>
>TC> 
>TC> ---
>
>TC> You're submitting a form with one or more checkboxes checked to delete,
>TC> yeah?
>
>TC> Try using the 'form.fieldnames' value and the SQL 'IN' operator.
>TC> Form.fieldnames should contain a list of all form fields defined in the
>TC> submission. Checkboxes that aren't checked aren't even defined, so...
>
>TC> 
>TC>  UPDATE mytable
>TC>  SET IsDeleted = 1
>TC>  WHERE ID IN (#form.fieldnames#)
>TC> 
>
>TC> HTH,
>
>TC> - Gyrus
>
>TC> 
>TC> - [EMAIL PROTECTED]
>TC> work: http://www.tengai.co.uk
>TC> play: http://www.norlonto.net
>TC> - PGP key available
>TC> 
>
>
>TC>
>
>
>

__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists