Re: Help with test

[Eric Dawson]

what do you need to do? I'm not sure I understand what you need to do.

If I understand random numbers correctly, each pull has an equal chance of a 
generating any number in the set, so there is no reason why the same random 
number can't appear consecutively in sequence.

Eric Dawson

From: "Douglas L. Brown" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
Subject: Re: Help with test
Date: Mon, 12 Nov 2001 21:03:18 -0800

Well I guess what I am getting at is do I want to use it as a custID
value...If I can get it through a million iterations then I probably can.

Doug

- Original Message -
From: "Joseph Thompson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 12, 2001 8:44 PM
Subject: Re: Help with test

 > assuming you "seed" it, won't that number also be random?
 >
 > 
 > 
 > 
 >
 > 

 > > I want to test how many iterations I can put
 > > randRange(11,111,111, 99,999,999) through before it comes up with a 
duplicate
 > > number, can someone help me with script to do so?

 > >  > NAME="Douglas L. Brown"
 > > EMAIL="[EMAIL PROTECTED]"
 > > PHONE="714.538.6611"
 > > WEB="http://www.carnivorepc.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: left outer join - and null results (Lazy but Stumped)

[Eric Dawson]

>>... or b.id IS NULL
Well that solves why I can't see the null problem. thanks for the syntax. (I 
have a spot where I need that somewhere else.)

With a slight alteration your sugg. is the winner ...

select a.id, a.data, b.id, b.a_id, b.g, b.data
from a left outer join b on (a.id = b.a_id and
(b.g = #attributes.g# or b.id IS NULL))

thanks.

Eric Dawson

From: Bryan Love <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
Subject: RE: left outer join - and null results (Lazy but Stumped)
Date: Mon, 12 Nov 2001 12:20:36 -0800

try this:

select a.id, a.data, b.id, b.a_id, b.g, b.data
from a left outer join b on a.id = b.a_id
where b.g = #attributes.g# or b.id IS NULL

Bryan Love Macromedia Certified Professional
Internet Application Developer / Database Analyst
Telecommunication Systems Inc.
[EMAIL PROTECTED]


"What father would hesitate to say 'if there must be trouble let it be in my
day, that my child may have peace'?"
- Thomas Paine, An American Crisis



-Original Message-
From: Eric Dawson [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 11:21 AM
To: CF-Talk
Subject: left outer join - and null results (Lazy but Stumped)


Here is the SQL. (I need for both access and MSDE datasources)

select a.id, a.data, b.id, b.a_id, b.g, b.data
from a left outer join b on a.id = b.a_id
where b.g = #attributes.g# or b.id = null?

That's basically what I want to do.

a is a roster table
b is a game data table where each roster item (might) have a record.

I don't know how to detect the null value(s) in a joined record without
data.

Or, is it better to do:
===
select a.id, a.data, b.id, b.a_id, b.g, b.data
from a left outer join
(select b.id, b.a_id, b.g, b.data from b where b.g = #attributes.g#)
on a.id = b.a_id

But I'm not sure if a) my syntax is right or b) yeah just can't do it on an
access database. Can you do with MSDE?

Eric Dawson





~~
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: Help with test

[Tony Schreiber]

For unique ids (usually shopping cart ids), I usually use something like

MMDDHHMMSS

Where  is a four digit random number (RandRange(1000,))...

> No, not as customer ID... I take it you don't like the CreateUUID()
> functions "large" strings?  They are unique at least.
>
>
> > Well I guess what I am getting at is do I want to use it as a custID
> > value...If I can get it through a million iterations then I probably can.
> >
> >
> > Doug
> >
> >
> > - Original Message -
> > From: "Joseph Thompson" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Monday, November 12, 2001 8:44 PM
> > Subject: Re: Help with test
> >
> >
> > > assuming you "seed" it, won't that number also be random?
> > >
> > > 
> > > 
> > > 
> > >
> > > 
> > >
> > >
> > >
> > > > I want to test how many iterations I can put
> > > > randRange(,) through before it comes up with a
> duplicate
> > > > number, can someone help me with script to do so?
> > > >
> > > >
> > > >
> > > >
> > > >  > > > NAME="Douglas L. Brown"
> > > > EMAIL="[EMAIL PROTECTED]"
> > > > PHONE="714.538.6611"
> > > > WEB="http://www.carnivorepc.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: Help with regular expression

[Seth Petry-Johnson]

> Personally I don't think this is possible with regexs, but I'd love
> to be corrected. It would need to be able to look for an even
> number of quotes followed by a greater than sign.

What I'm going to try now is to modify the regexp to distinguish between
string data (anything enclosed in quotes, including the '>' symbol) and
other things that might be in a CFSET: CF var names, mathematical operators,
etc.  I'm sure it can be done, its just a matter of tweaking the damn thing
to accept all of the various formats a CFSET statement can have.

I'll let you know if I get it working.

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

SUMMARY: Request Scope & Follow up Locking Questions

[Terry Hogan]

I want to thank everyone (particularily gyrus and Dave Watts) who responded
 to my questions regarding Request Scope.  

I had spent the better part of 2 days studying my 4 CF Reference Books plus
 checking many online sources and still didn't really understand the
 concept but you guys cleared it up real quick.

I'm sure others are interested in this so I thought I'd summarize what I
 learned. 

 Below I have cut&pasted some snippets from the thread and added a few of
 my own comments.

1.  What exactly is the Request Scope?

On 11/11/2001 at 3:59 AM gyrus wrote:

>The request scope lasts for the duration of each request. If
>you define request.var, every file (includes, custom tags,
>whatever) that's processed from then on in the course of
>that HTTP request has access to request.var.

It seems kind of stupid now, but I couldn't understand why they were called
  "Request" variables.  D!  It's because they persist and are available
 to all templates and custom tags in a single HTTP request!

On 11/11/2001 at 2:15 PM Peter Tilbrook wrote:

>I may be wrong but once set (eg: in the application.cfm file) if you do
 not 
>provide a scope (eg: Application., Session., Client., they become
 variables 
>in the REQUEST scope. You can then access them anywhere in a template 
>without using a scope, eg:

H, but how does that fit with custom tags?..

On 11/11/2001 at 5:07 PM Dave Watts wrote:

>It's identical to the local Variables scope in all ways except one: the
>Request scope is available both to a page and to any custom tags called by
>that page. It was added to make custom tag programming easier. If, for
>example, you wrote a recursive custom tag, it might have to write to the
>Caller scope to return its results, requiring a bit of tap-dancing around.
>Using the Request scope, you can have a variable that can be accessed
 easily
>from any custom tag, no matter how deep the recursion goes.

Ok, that makes sense. And Peter wasn't quite correct.  If a scope is not
 defined when a variable is set they are in the Variables Scope, not the
 Request Scope--the difference being that Request Variables are accessible
 (both Read & Write, I presume) in Custom Tags as well as the Calling
 template.


2. How are Request Variables similar or different from Session or
Application Variables?

On 11/11/2001 at 5:07 PM Dave Watts wrote:

>They're not persistent memory variables, as are Session, Application or
>Server variables.

Goes back to my new found understanding that Request variables only last
 for a particular HTTP Request. 

3. When should/shouldn't Request Variables be used?

On 11/11/2001 at 5:07 PM Dave Watts wrote:
>You can use them in place of the local Variables scope any time you like,
>really. The only time it wouldn't be appropriate to use them this way is
>when you want to create a variable that isn't accessible from both a
 calling
>page and its custom tags.
>
>They're very useful as constants, for example. You might have a bunch of
>variables which aren't going to change over the lifespan of the
 application,
>things like DSN names and file paths, for example. The Request scope is
 good
>for these since you may want to access those "global" variables from
 within
>custom tags. Of course, when you use the Request or Variables scopes for
>constants within Application.cfm, the variables will be created and
>destroyed again for each page request. There's a cost to that, but it's
>usually less than the cost of managing persistent memory variables within
>the Application scope.

Ok, but this had been one of my points of confusion.  The "Books" tend to
 use the Session Scope to keep things like DSN names, etc.  At first, I
 wondered if the Request Scope did not have persistance across sessions how
 would these variables be accessible on each request?  Of course the answer
 is that the Application.cfm is called on each request. 

gyrus also had some comments on Request Scope usage leading into my last
 question about locking

On 11/11/2001 at 3:59 AM gyrus wrote:

>Request variables are often talked of just in the context of custom
>tags, cos the fact that they can be accessed from anywhere
>during one request means they're useful for custom tags to
>talk to each other. But I use them quite a bit. I set all stuff
>like DSN names and passwords in application.cfm using the
>request scope. Also, any session variables that are needed
>frequently, I transfer them to the request scope in application.cfm.
>That way, I put one lock around this chunk of 'transfer' code,
>and don't need to lock every time a session variable is needed.
>
>A couple of notes here: if you do this, use something like
>
>
>
>to transfer the variable. If you don't use Duplicate() - correct
>me if I'm wrong someone! - then request.var just becomes a
>'pointer' to session.var, and session.var is still actually read when
>you refer later to request.var (rendering the whole business kind
>of redundant!). Duplicate() - which is only availa

Get Verity Collections from Win registry?

[Joseph Thompson]

Does anyone have code to create a Select box of existing collections?  Or
maybe just the "hidden" function?

I just released a new "Verity Manager" script to manage collections and
build "dynamic" search forms but would like to "enhance" it with something
like that.

If you want a copy (fusebox 3.01) I placed one here while it is in "beta"
http://cfhub.com/forum//index.cfm?FuseAction=Thread&TopicID=2011

(the Verity manager builds "searches" similiar to this one using the
Custom1/Custom2 fields as "refinements" like the"search" on the forum listed
above)
~~
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: Help with test

[Douglas L. Brown]

Well I have it through 10,000 iterations so far without a duplicate


I'll try for more


DB
- Original Message -
From: "Joseph Thompson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 12, 2001 9:00 PM
Subject: Re: Help with test


> No, not as customer ID... I take it you don't like the CreateUUID()
> functions "large" strings?  They are unique at least.
>
>
> > Well I guess what I am getting at is do I want to use it as a custID
> > value...If I can get it through a million iterations then I probably
can.
> >
> >
> > Doug
> >
> >
> > - Original Message -
> > From: "Joseph Thompson" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Monday, November 12, 2001 8:44 PM
> > Subject: Re: Help with test
> >
> >
> > > assuming you "seed" it, won't that number also be random?
> > >
> > > 
> > > 
> > > 
> > >
> > > 
> > >
> > >
> > >
> > > > I want to test how many iterations I can put
> > > > randRange(,) through before it comes up with a
> duplicate
> > > > number, can someone help me with script to do so?
> > > >
> > > >
> > > >
> > > >
> > > >  > > > NAME="Douglas L. Brown"
> > > > EMAIL="[EMAIL PROTECTED]"
> > > > PHONE="714.538.6611"
> > > > WEB="http://www.carnivorepc.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: Help with test

[Joseph Thompson]

No, not as customer ID... I take it you don't like the CreateUUID()
functions "large" strings?  They are unique at least.


> Well I guess what I am getting at is do I want to use it as a custID
> value...If I can get it through a million iterations then I probably can.
>
>
> Doug
>
>
> - Original Message -
> From: "Joseph Thompson" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, November 12, 2001 8:44 PM
> Subject: Re: Help with test
>
>
> > assuming you "seed" it, won't that number also be random?
> >
> > 
> > 
> > 
> >
> > 
> >
> >
> >
> > > I want to test how many iterations I can put
> > > randRange(,) through before it comes up with a
duplicate
> > > number, can someone help me with script to do so?
> > >
> > >
> > >
> > >
> > >  > > NAME="Douglas L. Brown"
> > > EMAIL="[EMAIL PROTECTED]"
> > > PHONE="714.538.6611"
> > > WEB="http://www.carnivorepc.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: Help with test

[Douglas L. Brown]

Well I guess what I am getting at is do I want to use it as a custID
value...If I can get it through a million iterations then I probably can.


Doug


- Original Message -
From: "Joseph Thompson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 12, 2001 8:44 PM
Subject: Re: Help with test


> assuming you "seed" it, won't that number also be random?
>
> 
> 
> 
>
> 
>
>
>
> > I want to test how many iterations I can put
> > randRange(,) through before it comes up with a duplicate
> > number, can someone help me with script to do so?
> >
> >
> >
> >
> >  > NAME="Douglas L. Brown"
> > EMAIL="[EMAIL PROTECTED]"
> > PHONE="714.538.6611"
> > WEB="http://www.carnivorepc.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: Help with test

[Joseph Thompson]

assuming you "seed" it, won't that number also be random?









> I want to test how many iterations I can put
> randRange(,) through before it comes up with a duplicate
> number, can someone help me with script to do so?
>
>
>
>
>  NAME="Douglas L. Brown"
> EMAIL="[EMAIL PROTECTED]"
> PHONE="714.538.6611"
> WEB="http://www.carnivorepc.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

Help with test

[Douglas L. Brown]

I want to test how many iterations I can put 
randRange(,) through before it comes up with a duplicate 
number, can someone help me with script to do so?




http://www.carnivorepc.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

update a user password on a LDAP server

[Mak Wing Lok]

hi CF ppl.

anyone can help me on this? i need to update/change a
user password thru CF application, how can i do that?
any hints? i tried to use cfa_user to change it but
the server keep track of two password, means that i 
be able to login with the old and new password. by the
way, i'm using advanced security and spectra.




~~
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: What am I doing wrong here?

[Douglas L. Brown]

Never mind, figured it out..



thanks


DB
- Original Message -
From: "Douglas L. Brown" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 12, 2001 8:05 PM
Subject: What am I doing wrong here?


> I am trying to populate the ID field of this table with the following.
> Please help
>
>
>   
>INSERT INTO cust_contacts
>VALUES  ( '#custNum#',
>   '#f_name#',
>   '#l_name#',
>   '#email#',
>   '#password#' )
>
>
>
> DECLARE @maxid int
> BEGIN
>  SELECT @maxid = MAX(ID)
>  FROM cust_contacts
>  WHERE custNum = '#custNum#'
> IF @maxid IS NULL
>  SELECT @maxid = 1
>  ELSE
>  SELECT @maxid = @maxid + 1
> END
>
>   
>
>
>
>  NAME="Douglas L. Brown"
> EMAIL="[EMAIL PROTECTED]"
> PHONE="714.538.6611"
> WEB="http://www.carnivorepc.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

What am I doing wrong here?

[Douglas L. Brown]

I am trying to populate the ID field of this table with the following. 
Please help


  
   INSERT INTO cust_contacts
   VALUES  ( '#custNum#',
  '#f_name#',
  '#l_name#',
  '#email#',
  '#password#' )



DECLARE @maxid int
BEGIN
 SELECT @maxid = MAX(ID)
 FROM cust_contacts 
 WHERE custNum = '#custNum#'
IF @maxid IS NULL
 SELECT @maxid = 1
 ELSE
 SELECT @maxid = @maxid + 1
END

  



http://www.carnivorepc.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

Passing large blocks of text to SQL 6.5 stored procedure

[Jim McAtee]

Is there any way to pass long text strings to a MS SQL 6.5 stored procedure
from ColdFusion?  Type varchar() is limited in SQL 6.5 to 255 characters.
Can you declare and pass a variable of SQL type "text" to a stored
procedure?  If not, is there any sort of workaround?  I'd like to be able to
pass text up to about 6k in length.

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

pass a structure to a stored proc ?

[Rob Sherman]

Is it possible to pass a simple name/value structure to a stored proc?
(stored proc is on a SQL 7 server).

Sincerely,

Rob Sherman
President

Velocity Interactive, Inc. - Technology Solutions for Business
http://www.velocityinteractive.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: Quick PayFlow Pro / Cybercash Question

[Matt Robertson]

I checked and yes, the dll that I got over a year ago is named PFProCF.dll, but is 
called as CFX_PaymentNet, although maybe you can label it as whatever you want.

I'm curious to know if they've updated the tag in the last 18 months.  Does that code 
fit into what your docs tell you?

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


-- Original Message --
from: Tony Schreiber <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Mon, 12 Nov 2001 20:59:02 -0500 (EST)

Yes. Thanks. I got it. Though the actual tag is PFPro_CF.dll or
something...

> I believe the tag is called CFX_PAYMENTNET. It's available in the
> manager's area of your PFP account site.
>
> Mike
>
> > -Original Message-
> > From: Tony Schreiber [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, November 12, 2001 6:15 PM
> > To: CF-Talk
> > Subject: Quick PayFlow Pro / Cybercash Question
> >
> >
> > I haven't had a chance to look at the documentation yet, but
> > when using PayFlow Pro are you actually using a Cybercash integration?
> >
> > What's the best tag currently available for this gateway?
> 

~~
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: Quick PayFlow Pro / Cybercash Question

[Matt Robertson]

No, we're talking about a bit of CF code to hook into the CFX; processing the 
responses and errmsgs.  Not CFX_PaymentNet itself.

The CF snippet is available at 

http://foohbar.org/verisign.txt

It still works, but for an installation a little over a year old.  CFX_PaymentNet may 
have been updated since then, particularly with regard to using signio.com servers.  
Be sure to read up on your *current* documentation.

In the code, the transaction is successful unless a response code of 0 or 13 is 
returned, at which point error information is dumped out on the screen.  For the site 
this code comes from, an AVS failure -- either to connect for the AVS portion of the 
transaction or an outright mismatch -- was logged for magagerial review, but this did 
NOT abort the transaction.  Check your docs for what the AVS failure codes are and add 
them to the last CFIF if you want to fail the buy upon AVS failure.

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


-- Original Message --
from: "Michael Wilson" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Mon, 12 Nov 2001 20:44:51 -0500

Tony,

I believe the tag is called CFX_PAYMENTNET. It's available in the
manager's area of your PFP account site.

Mike

> -Original Message-
> From: Tony Schreiber [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, November 12, 2001 6:15 PM
> To: CF-Talk
> Subject: Quick PayFlow Pro / Cybercash Question
> 
> 
> I haven't had a chance to look at the documentation yet, but 
> when using PayFlow Pro are you actually using a Cybercash integration?
> 
> What's the best tag currently available for this gateway?

~~
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: Quick PayFlow Pro / Cybercash Question

[Tony Schreiber]

Yes. Thanks. I got it. Though the actual tag is PFPro_CF.dll or
something...

> I believe the tag is called CFX_PAYMENTNET. It's available in the
> manager's area of your PFP account site.
>
> Mike
>
> > -Original Message-
> > From: Tony Schreiber [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, November 12, 2001 6:15 PM
> > To: CF-Talk
> > Subject: Quick PayFlow Pro / Cybercash Question
> >
> >
> > I haven't had a chance to look at the documentation yet, but
> > when using PayFlow Pro are you actually using a Cybercash integration?
> >
> > What's the best tag currently available for this gateway?
> 
~~
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: Quick PayFlow Pro / Cybercash Question

[Michael Wilson]

Tony,

I believe the tag is called CFX_PAYMENTNET. It's available in the
manager's area of your PFP account site.

Mike

> -Original Message-
> From: Tony Schreiber [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, November 12, 2001 6:15 PM
> To: CF-Talk
> Subject: Quick PayFlow Pro / Cybercash Question
> 
> 
> I haven't had a chance to look at the documentation yet, but 
> when using PayFlow Pro are you actually using a Cybercash integration?
> 
> What's the best tag currently available for this gateway?
~~
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: Inserting single quotes into SQL Server...

[Kym Kovan]

Hi Kevin,

>Anyone have any standard ways of inserting strings into SQL which may or may
>not contain single quotes?

CF will escape any single quotes only if the variable is a simple variable, 
ie a straight text string. If the code is more complex then you need to set 
it into a straight text var before you get to the query:

This could fail:
SQL..WHERE ID = #listGetAt(listvar, pos)#

This should not:

SQL..WHERE ID = #tempvar#


--

Yours,

Kym
~~
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: Inserting single quotes into SQL Server...

[Bryan Love]

That would fail.  PreserveSingleQuotes would cause the single to NOT be
escaped.  It sounds like he wants it escaped (since it's part of the name).
This may take a little examination on your part, Kevin.  Single quotes
should be escaped automatically.  Chances are you have a
PreserveSingleQuotes() function that needs to be removed.


 

Bryan Love Macromedia Certified Professional
Internet Application Developer / Database Analyst
Telecommunication Systems Inc.
[EMAIL PROTECTED]
 

"What father would hesitate to say 'if there must be trouble let it be in my
day, that my child may have peace'?"
- Thomas Paine, An American Crisis



-Original Message-
From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 1:56 PM
To: CF-Talk
Subject: Re: Inserting single quotes into SQL Server...


Use the PreserveSingleQuotes function.

HTH,

--
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. - www.CoolFusion.com  - 631-737-4668 x101
inFusion Mail Server (iMS) - The Intelligent Mail Server
<<< Vote for iMS as the CFDJ Reader's Choice Awards Most Innovative Product
>>>
http://www.sys-con.com/coldfusion/readerschoice2001/nominationformbpa.cfm
>>> Find out how iMS Stacks up to the competition:
http://www.coolfusion.com/imssecomparison.cfm

- Original Message - 
From: "Kevin Langevin" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 12, 2001 4:33 PM
Subject: Inserting single quotes into SQL Server...


> Hi all-
> 
> I've beaten this problem before, but even looking at code that seems to
work
> fine from previous projects, I can't see what I'm doing wrong.
> 
> I want to insert a string into a record in a SQL Server 2000 DB. The
string
> contains a customer's name.  If the customer's name contains an
apostrophe,
> the insert dies.  It works fine in another app, but I can't see what I'm
> doing differently.  I'm not escaping anything or doing anything special,
> from what I can see.
> 
> Anyone have any standard ways of inserting strings into SQL which may or
may
> not contain single quotes?
> 
> 
> Kevin Langevin
> Web Guy In Charge
> UsWebGuys
> 954-327-5780
> 
> 
> -Original Message-
> From: Langford, Bryan [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 12, 2001 4:29 PM
> To: CF-Talk
> Subject: CFCookie and the old switcharoo - help!
> 
> 
> Hey everyone,
> Anyone that read my recent posts "CFCOOKIE and the old switcheroo".
> I am still looking for any other suggestion before I revert to using
> sessions instead of cookies.  The basic problem is that I have a multiple
> user environment, a class room of students, each log in to take the test:
> Page1:
> 
> 
>
> 
>   
> 
>   Welcome Back #cookie.repname#:
>   
> 
>   
> 
> 
>   ID:
>   
>  (First 5 digits of
> SSN.)
>   
> 
>   
>   If you are not #cookie.repname# Click
> here
>   
> 
> 
> 
> 
> That is submitted through the form action to repverification which builds
> the cookies.
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>  '#mid(form.repname,value1,1)#' EQ CHR(39)>
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>  timeout="60"
> throwontimeout="Yes"
> type="EXCLUSIVE">
> 
>  
>  VALUE="#cookvalue#"
> EXPIRES="2" >
>  VALUE="#form.repid#"
> EXPIRES="2" >
> 
> 
> 
> 
> The information you have provided as your ID is not numeric or does not
> contain 5 digits, please click back and enter the first 5 digits of your
> social security number.
> 
> 
> Lastly the repmenu is pulled up.
> 
> select #variables.mastertableansw#.fldname,
> #variables.mastertableansw#.fldid, #variables.mastertableansw#.testnumber,
> max(#variables.mastertableansw#.questionnumber) as maxquest,
> max(#variables.mastertable#.questnum) as maxq
> from #variables.mastertableansw#, #variables.mastertable#
> where fldname = '#cookie.repname#'
> and fldid = '#cookie.repid#'
> and #variables.mastertableansw#.testnumber =
> #variables.mastertable#.testnumber
> group by #variables.mastertableansw#.fldname,
> #variables.mastertableansw#.fldid, #variables.mastertableansw#.testnumber
> 
> 
> 
> 
> 
> Our records indicate that you are a first time
user.
> Please select from the following tests.
> 
> Welcome Back #cookie.repname# your ID is #cookie.repid#
> #cookie.cftoken#
> 
> 
> 
> The problem is that reps 1 - 20 all log in.  Some reps get to the menu
page
> and get they're own information display...I.E. Rep 5 logs in and gets:
> "Welcome back rep5,"
> But many of the reps get someone elses info
> Rep 2 logs in and gets: "Welcome back rep 3"
> Rep 1 gets rep5
> rep 7 gets rep 3 as well.   etc.
> If anyone has ANY suggestions I would certianly appreciate it.  I have 12
> call centers full of trainees all waiting to take their tests.  I'm
starting
> to feel sorry that I ever switched to cookies from session vars.
> Bryan Langford
> 
> 
> Analyst
> National Customer Operations
> Enterprise Services & Strategic Planning
> Training Development 

Re: Quick PayFlow Pro / Cybercash Question

[Matt Robertson]

No, it has nothing to do with Cybercrash, and actually pre-dates Verisign's 
acquisition of them.  Based on my older docs, it actually originated back when the 
service was Signio, before Verisign bought *them*. 

You're going to use a CFX that you get from Verisign once you either a) sign up for a 
trial acct or b) sign up for a real one.  Its the only way to connect to the Pro 
system, so if you look around in the Dev Exchg and see nothing thats why.

I wrote something to interface with the CFX and loop around and handle most of their 
response error/success messages.  I'd put it into the Exchange, but we're only talking 
about 10 or 20 lines of code. Its really very easy to implement.  Let me know offline 
if you want the code and I'll email it over.

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


-- Original Message --
from: Tony Schreiber <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Mon, 12 Nov 2001 18:15:07 -0500 (EST)

I haven't had a chance to look at the documentation yet, but when using
PayFlow Pro are you actually using a Cybercash integration?

What's the best tag currently available for this gateway?


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

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


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

CFHTTP timeout in CF5

[David Cummins]

Hi all,

Has anyone used the timeout attribute on CFHTTP? It doesn't seem to work for me.
I've got a non-essential template to call via HTTP, and if it doesn't connect in
5 seconds I just want to give up - but CFHTTP doesn't actually stop executing
within the timeout value. It keeps going until shortly before the page timeout.
Thoughts?







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

Quick PayFlow Pro / Cybercash Question

[Tony Schreiber]

I haven't had a chance to look at the documentation yet, but when using
PayFlow Pro are you actually using a Cybercash integration?

What's the best tag currently available for this gateway?


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

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

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
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

CGGraph and Pinned CPU

[Don Vawter]

Has anybody else seen CFGraph pin the cpu
and skyrocket memory usage(nt.javaconsole)?

Win2k, CF 5 of course.

It has happened twice today and the common factor seems to be that I was
woking on a page with three calls to cfgraph.

TIA

Don

~~
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: Help with regular expression

[David Cummins]

Personally I don't think this is possible with regexs, but I'd love to be
corrected. It would need to be able to look for an even number of quotes
followed by a greater than sign.

This would also allow the valid statement  part 1"> to
be distinguished from the invalid statement .

David

Seth Petry-Johnson wrote:
> 
> I am trying to build a regular expression to test for valid CFSET statements
> in a block of text.  I have it working with one small issue:  if a ">"
> character appears on the right hand side of the equals sign, such as in
> 
> 
> 
> then the regexp fails to match the whole string.  I am only concerned with
> statements that set local variables which is why the regexp doesn't take
> variable scope into consideration. Here is what I have right now:
> 
> 
> 
> 
> Can anyone give me some pointers as to how I can modify this to support the
> ">" sign if it appears inside single or double quotes on the right hand side
> of the equals sign?
> 
> Thanks in advance,
> Seth Petry-Johnson
> Argo Enterprise and Associates
> 
~~
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

(ot) Access, SQL Server and Replication

[Owens, Howard]

I have a client with an ecommerce site (not quite finished yet).  

One of the issues is keeping the online inventory in sync with the in-store
inventory.

He only has a dial up connection and one phone line, so he doesn't want to
be online all of the time.

He does have Access on his computer.

I know the SQL Server client tools have some sort of replication ability.

What I'm wondering ... and I'm hoping one of the SQL Server guru's here can
tell me if it's possible ... Can I use the SQL Server client tools to, on a
daily basis, replicate his inventory in-store with the main SQL Server?  And
is there a way to daily have the two databases talk to each other and figure
out which inventories have changed (the in-store database will have
modifications each day as will the online database).

And to complicate matters further, the client has two store locations and
that inventory should be in synch, also.

Just in theory, is this a solvable issue using the tools available?





Howard Owens
Internet Operations Coordinator
www.insidevc.com
[EMAIL PROTECTED]
AIM: GoCatGo1956


~~
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: CFCookie and the old switcharoo - help!

[Langford, Bryan]

Well thanks for looking David,
I too was concerned that it might be a logic problem, The difficulty
is that it never happened with sessions and I essentially did a site 
wide
replace of "session." for "cookie." and I never had the problem before 
I
used cookies.  I have picked through the code three times myself and 
had
co-workers look it over as well.  I appreciate the suggestions and I 
will
try looking into these further, though I had the cache removed manually 
as
well as the cookies in the same few steps.  I also verified the 
browsers
were the same as mine and the only difference seems to be that they are 
on a
"thin client", but I can't rule out the possibility of code error 
either.
If you or anyone have any other thoughts, I am open to suggestions.  
Thanks
for everything.

Bryan Langford 


Analyst
National Customer Operations 
Enterprise Services & Strategic Planning
Training Development and Design Team. 
Desk: 714-695-4824
Cell: 714-270-8451


 


-Original Message-
From: David Cummins [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 2:36 PM
To: CF-Talk
Subject: Re: CFCookie and the old switcharoo - help!


There are only three ways I can imagine it happening:

1. The wrong cookie values are being sent. I'm not sure how this would
occur,
but you should be able to see the entire cookie data in 
CGI.HTTP_COOKIE.
2. There is a caching problem - the cookies are set correct, but the 
page
you
see is completely disconnected from what you should be seeing. Try 
adding a
random number on the url to test this.
3. There is a logic error in your page. I don't actually have time to 
look
at
your code sorry, but its always a possibility.

David

"Langford, Bryan" wrote:
> 
> Hi david,
> Yeah actually I expired all the old cookies before beginning
> > 
> > 
> > 
> > 
>  Just to make sure that the old cookies no longer existed.  On top of
> that I
> had the trainer of the course walk through a manual deletion of all
> cookies
> on each machine.  the problem still persisted.
> 
> Bryan Langford
> 
> Analyst
> National Customer Operations
> Enterprise Services & Strategic Planning
> Training Development and Design Team.
> Desk: 714-695-4824
> Cell: 714-270-8451
> 
> 
> 
> -Original Message-
> From: David Cummins [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 12, 2001 1:53 PM
> To: CF-Talk
> Subject: Re: CFCookie and the old switcharoo - help!
> 
> Sounds like there are old cookies on those machines from previous
> attempts.
> Maybe some machines now have cookie setting switched off, but of 
course
> the
> old
> cookies are still there. Try one of the machines with problems - turn
> cookie
> prompting on, etc. Maybe change the name of the cookie to rule out 
that
> possibility.
> 
> David
> 
> "Langford, Bryan" wrote:
> >
> > Hey everyone,
> > Anyone that read my recent posts "CFCOOKIE and the old
> switcheroo".
> > I am still looking for any other suggestion before I revert to 
using
> > sessions instead of cookies.  The basic problem is that I have a
> multiple
> > user environment, a class room of students, each log in to take the
> test:
> > Page1:
> > 
> > 
> >
> >
> >   
> > 
> >   Welcome Back #cookie.repname#:
> >   
> >  value='#cookie.repname#'>
> >   
> > 
> > 
> >   ID:
> >   
> >  message="Your ID
> must
> > be 5 digits in length" size=20 required="Yes"> (First 5 
digits
> of
> > SSN.)
> >   
> > 
> >   
> >   If you are not #cookie.repname#  href="./logon.cfm?track=yes">Click
> > here
> >   
> > 
> > 
> > 
> >
> > That is submitted through the form action to repverification which
> builds
> > the cookies.
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> >
> > 
> > 
> > 
> > 
> >  > '#mid(form.repname,value1,1)#' EQ CHR(39)>
> > 
> > 
> > 
> > 
> > 
> > 
> >
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> >  > timeout="60"
> > throwontimeout="Yes"
> > type="EXCLUSIVE">
> > 
> >  
> >  > VALUE="#cookvalue#"
> > EXPIRES="2" >
> >  > VALUE="#form.repid#"
> > EXPIRES="2" >
> > 
> > 
> > 
> > 
> > The information you have provided as your ID is not numeric or does
> not
> > contain 5 digits, please click back and enter the first 5 digits of
> your
> > social security number.
> > 
> >
> > Lastly the repmenu is pulled up.
> > 
> > select #variables.mastertableansw#.fldname,
> > #variables.mastertableansw#.fldid,
> #variables.mastertableansw#.testnumber,
> > max(#variables.mastertableansw#.questionnumber) as maxquest,
> > max(#variables.mastertable#.questnum) as maxq
> > from #variables.mastertableansw#, #variables.mastertable#
> > where fldname = '#cookie.repname#'
> > and fldid = '#cookie.repid#'> and#variables.mastertableansw#.testnumbe=
> > #variables.mastertable#.testnumber
> > group by #variables.mastertableansw#.fldname,
> > #variables.mastertableansw#.fldid,
> #variables.mastertableansw#.testnumber
> > 
> > 
> > 
> > 
> > 
> > Our records indicate that you are a first
> time

Re: Frames , cookies and IE6... Hate 'em all

[Matt Robertson]

Well, at least there's a (billable ;D) long-term solution.

Right now I'm trying out the following band-aid:

 FRAME.HTM: located at Site B
  top frame: secure .htm file shows logo from Site A
  bottom frame: secure .cfm file shows form from Site B

The only difference is the frame header page is on Site B instead of A.  This will (I 
hope) resolve the 3rd party issue, since the page that needs the cookies is on the 
same domain as the controlling header template.  The bad news, of course, is the url 
shows Site B instead of A, but I can live with that for now, on this project.

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


-- Original Message --
from: "Kirk Boecker" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Mon, 12 Nov 2001 14:12:06 -0800

Yup, we just ran into it on some applications we host- and it stinks - but
after a few hours i figured out how to make it work - you have to jump
through hoops and implement P3P on the server - which is actually easy -
just the instructions kind of stink.

here is where you can get started..
http://msdn.microsoft.com/library/default.asp?url=/workshop/security/privacy
/overview/createprivacypolicy.asp

also the w3c.org site has some info


Kirk

- Original Message -
From: "Matt Robertson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 12, 2001 2:12 PM
Subject: Frames , cookies and IE6... Hate 'em all


> I have this 2-frame structure:
>
> FRAME.HTM: located at Site A
>  top frame: secure .htm file shows logo from Site A
>  bottom frame: secure .cfm file shows form from Site B
>
> IE6 is blocking the urltoken cookies since they are considered 3rd-party
cookies.  Bah.
>
> Has anyone else run into this?  Is my only option passing the urltoken
around via urls?
>
> ---
> Matt Robertson[EMAIL PROTECTED]
> MSB Designs, Inc., www.mysecretbase.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

Help with regular expression

[Seth Petry-Johnson]

I am trying to build a regular expression to test for valid CFSET statements
in a block of text.  I have it working with one small issue:  if a ">"
character appears on the right hand side of the equals sign, such as in



then the regexp fails to match the whole string.  I am only concerned with
statements that set local variables which is why the regexp doesn't take
variable scope into consideration. Here is what I have right now:




Can anyone give me some pointers as to how I can modify this to support the
">" sign if it appears inside single or double quotes on the right hand side
of the equals sign?

Thanks in advance,
Seth Petry-Johnson
Argo Enterprise and Associates
~~
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: CFCookie and the old switcharoo - help!

[David Cummins]

There are only three ways I can imagine it happening:

1. The wrong cookie values are being sent. I'm not sure how this would occur,
but you should be able to see the entire cookie data in CGI.HTTP_COOKIE.
2. There is a caching problem - the cookies are set correct, but the page you
see is completely disconnected from what you should be seeing. Try adding a
random number on the url to test this.
3. There is a logic error in your page. I don't actually have time to look at
your code sorry, but its always a possibility.

David

"Langford, Bryan" wrote:
> 
> Hi david,
> Yeah actually I expired all the old cookies before beginning
> > 
> > 
> > 
> > 
>  Just to make sure that the old cookies no longer existed.  On top of
> that I
> had the trainer of the course walk through a manual deletion of all
> cookies
> on each machine.  the problem still persisted.
> 
> Bryan Langford
> 
> Analyst
> National Customer Operations
> Enterprise Services & Strategic Planning
> Training Development and Design Team.
> Desk: 714-695-4824
> Cell: 714-270-8451
> 
> 
> 
> -Original Message-
> From: David Cummins [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 12, 2001 1:53 PM
> To: CF-Talk
> Subject: Re: CFCookie and the old switcharoo - help!
> 
> Sounds like there are old cookies on those machines from previous
> attempts.
> Maybe some machines now have cookie setting switched off, but of course
> the
> old
> cookies are still there. Try one of the machines with problems - turn
> cookie
> prompting on, etc. Maybe change the name of the cookie to rule out that
> possibility.
> 
> David
> 
> "Langford, Bryan" wrote:
> >
> > Hey everyone,
> > Anyone that read my recent posts "CFCOOKIE and the old
> switcheroo".
> > I am still looking for any other suggestion before I revert to using
> > sessions instead of cookies.  The basic problem is that I have a
> multiple
> > user environment, a class room of students, each log in to take the
> test:
> > Page1:
> > 
> > 
> >
> >
> >   
> > 
> >   Welcome Back #cookie.repname#:
> >   
> >  value='#cookie.repname#'>
> >   
> > 
> > 
> >   ID:
> >   
> >  message="Your ID
> must
> > be 5 digits in length" size=20 required="Yes"> (First 5 digits
> of
> > SSN.)
> >   
> > 
> >   
> >   If you are not #cookie.repname#  href="./logon.cfm?track=yes">Click
> > here
> >   
> > 
> > 
> > 
> >
> > That is submitted through the form action to repverification which
> builds
> > the cookies.
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> >
> > 
> > 
> > 
> > 
> >  > '#mid(form.repname,value1,1)#' EQ CHR(39)>
> > 
> > 
> > 
> > 
> > 
> > 
> >
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> >  > timeout="60"
> > throwontimeout="Yes"
> > type="EXCLUSIVE">
> > 
> >  
> >  > VALUE="#cookvalue#"
> > EXPIRES="2" >
> >  > VALUE="#form.repid#"
> > EXPIRES="2" >
> > 
> > 
> > 
> > 
> > The information you have provided as your ID is not numeric or does
> not
> > contain 5 digits, please click back and enter the first 5 digits of
> your
> > social security number.
> > 
> >
> > Lastly the repmenu is pulled up.
> > 
> > select #variables.mastertableansw#.fldname,
> > #variables.mastertableansw#.fldid,
> #variables.mastertableansw#.testnumber,
> > max(#variables.mastertableansw#.questionnumber) as maxquest,
> > max(#variables.mastertable#.questnum) as maxq
> > from #variables.mastertableansw#, #variables.mastertable#
> > where fldname = '#cookie.repname#'
> > and fldid = '#cookie.repid#'> and #variables.mastertableansw#.testnumber=
> > #variables.mastertable#.testnumber
> > group by #variables.mastertableansw#.fldname,
> > #variables.mastertableansw#.fldid,
> #variables.mastertableansw#.testnumber
> > 
> > 
> > 
> > 
> > 
> > Our records indicate that you are a first
> time
> user.
> > Please select from the following tests.
> > 
> > Welcome Back #cookie.repname# your ID is #cookie.repid#
> > #cookie.cftoken#
> > 
> > 
> >
> > The problem is that reps 1 - 20 all log in.  Some reps get to the
> menu
> page
> > and get they're own information display...I.E. Rep 5 logs in and
> gets:
> > "Welcome back rep5,"
> > But many of the reps get someone elses info
> > Rep 2 logs in and gets: "Welcome back rep 3"
> > Rep 1 gets rep5
> > rep 7 gets rep 3 as well.   etc.
> > If anyone has ANY suggestions I would certianly appreciate it.  I
> have 12
> > call centers full of trainees all waiting to take their tests.  I'm
> starting
> > to feel sorry that I ever switched to cookies from session vars.
> > Bryan Langford
> >
> > Analyst
> > National Customer Operations
> > Enterprise Services & Strategic Planning
> > Training Development and Design Team.
> >
> > Bryan Langford
> >
> > Analyst
> > National Customer Operations
> > Enterprise Services & Strategic Planning
> > Training Development and Design Team.
> > >
> > >
> > >
> >
> >
> 
> 
~~
Get the mailserver that powers this list at http

RE: cross datasource updates --> Access to Oracle

[James Sleeman]

If it's just this one time I'd just do it the easy way that takes a long 
time to execute.  If it's gonna take a really long time (sounds like it 
might) you might be best to split the job into chunks.  We had to do a 
similar job here, importing some large DB from paradox tables of all things 
into an SQL Server DB (with some processing along the way), we just wrote 
it to process 50 records at a time, when those 50 are done it just 
cflocates to itself (recurses) to process the next 50 until all of them are 
complete.  That way we could leave it running in a browser window and 
occasionally check back to see how far through it was.

At 06:51 AM 11/10/2001, you wrote:
>I just need to do it this one time, to bulk load a new table.
>
>-Original Message-
>From: Won Lee [mailto:[EMAIL PROTECTED]]
>Sent: Friday, November 09, 2001 12:42 PM
>To: CF-Talk
>Subject: RE: cross datasource updates --> Access to Oracle
>
>
>How often would you have to update the Oracle Db?
>
>-Original Message-
>From: Scott Mulholland [mailto:[EMAIL PROTECTED]]
>Sent: Friday, November 09, 2001 12:05 PM
>To: CF-Talk
>Subject: cross datasource updates --> Access to Oracle
>
>
>Is there a quick way to take the results of a 2 table join in Access and do
>an update to a table in Oracle.
>
>The easy way I guess is to write a template to query the access datasource,
>loop over the results updating the oracle datasource, but I am dealing with
>140,000+ records and figure that would take quite awhile.
>
>Any thoughts?


--
James Sleeman
Innovative Media Ltd
Phone: (03) 377 6262
http://www.websolutions.co.nz/

CAUTION: The information contained in this email message is confidential 
and may be legally privileged. If the reader of this message is not the 
intended recipient you are notified that any use, dissemination, 
distribution or reproduction of this message is prohibited. If you have 
received this message in error please notify the sender immediately and 
destroy the original message and any attachments.

Views expressed in this communication may not be those of Innovative Media 
Ltd.

~~
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: Frames , cookies and IE6... Hate 'em all

[Kirk Boecker]

Yup, we just ran into it on some applications we host- and it stinks - but
after a few hours i figured out how to make it work - you have to jump
through hoops and implement P3P on the server - which is actually easy -
just the instructions kind of stink.

here is where you can get started..
http://msdn.microsoft.com/library/default.asp?url=/workshop/security/privacy
/overview/createprivacypolicy.asp

also the w3c.org site has some info


Kirk

- Original Message -
From: "Matt Robertson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 12, 2001 2:12 PM
Subject: Frames , cookies and IE6... Hate 'em all


> I have this 2-frame structure:
>
> FRAME.HTM: located at Site A
>  top frame: secure .htm file shows logo from Site A
>  bottom frame: secure .cfm file shows form from Site B
>
> IE6 is blocking the urltoken cookies since they are considered 3rd-party
cookies.  Bah.
>
> Has anyone else run into this?  Is my only option passing the urltoken
around via urls?
>
> ---
> Matt Robertson[EMAIL PROTECTED]
> MSB Designs, Inc., www.mysecretbase.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: Frames , cookies and IE6... Hate 'em all Rarrararrr!!

[Mookie Bear]

Pass em via javascript :)  Rarrararrr








>From: "Matt Robertson" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: Frames , cookies and IE6... Hate 'em all
>Date: Mon, 12 Nov 2001 14:12:27 -0800
>
>I have this 2-frame structure:
>
>FRAME.HTM: located at Site A
>  top frame: secure .htm file shows logo from Site A
>  bottom frame: secure .cfm file shows form from Site B
>
>IE6 is blocking the urltoken cookies since they are considered 3rd-party 
>cookies.  Bah.
>
>Has anyone else run into this?  Is my only option passing the urltoken 
>around via urls?
>
>---
>Matt Robertson[EMAIL PROTECTED]
>MSB Designs, Inc., www.mysecretbase.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: Trying to access information I just inserted in Access

[Bruce Sorge]

I usually do this (Presuming that you are using AutoNumbering).


 INSERT INTO.



 Select MAX(Some_ID) AS LastID
 From Sometable



 Select Something
 From Somewhere
 Where ID = #qSomeName.ID#


-- Original Message --
From: Steven  Lancaster <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date:  Mon, 12 Nov 2001 15:51:27 -0600

>I have a form which inserts data into an access database. Once that data is
>inserted I need to access the ID for that data so that I can send a URL in
>an email for them to click on so that the information can be updated by
>somebody else. I am running into the problem once I insert it tells me it
>does not understand #id#. I do a query right after the insertion so that it
>can pull that info, but how do I cross reference?
>
> Steven Lancaster
> WebMaster
> Core Laboratories
> 6316 Windfern
> Houston, TX 77040
> 713-328-2532 (Office)
> 713-328-2150 (Fax)
> 832-259-3010 (Cell)
> mailto:[EMAIL PROTECTED]
>
> http://www.corelab.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[2]: Opening file

[Joseph DeVore]

FYI: I used the file type of text/plain for example.
You will need to change this to whatever filetype you are trying to work
with.

In your case, maybe application/dat will be what you're looking for.

Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 1:45 PM
To: CF-Talk
Subject: Re: Opening file


Hi,

I have a test page on the server (Intranet) with the following link. I've
configured my file associations in UltraEdit (on the client)
to open .dat files. When I click on the link the file gets opening in
Ultraedit which is what I want.

For some reason if the following tags are in the datafile , ,
...etc the file get sent to the browser. Can someone explain why?
How do I get around this problem?

The "X" is a mapped driver letter on the client PC pointing to a specific
directory on the server.




Test



Test File





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

Frames , cookies and IE6... Hate 'em all

[Matt Robertson]

I have this 2-frame structure: 

FRAME.HTM: located at Site A
 top frame: secure .htm file shows logo from Site A
 bottom frame: secure .cfm file shows form from Site B

IE6 is blocking the urltoken cookies since they are considered 3rd-party cookies.  Bah.

Has anyone else run into this?  Is my only option passing the urltoken around via urls?

---
Matt Robertson[EMAIL PROTECTED]
MSB Designs, Inc., www.mysecretbase.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: Am I a crackhead: CFContent Weirdness

[Duane Boudreau]

Try this piece of code on your server to verify:

#Server.OS.Version# #Server.OS.BuildNumber#
#Server.ColdFusion.ProductVersion#

-Original Message-
From: Eric J Hoffman [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 5:04 PM
To: CF-Talk
Subject: RE: Am I a crackhead: CFContent Weirdness


The host is CF 5 on a Win2000 box if I recall correctly.

Eric J Hoffman
Home of Vikings fans Worldwide!
http://www.purplepride.org



-Original Message-
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 3:59 PM
To: CF-Talk
Subject: RE: Am I a crackhead: CFContent Weirdness


what is your OS and SP level?

Duane

-Original Message-
From: Eric J Hoffman [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 4:49 PM
To: CF-Talk
Subject: RE: Am I a crackhead: CFContent Weirdness


CFHEADER NAME="Content-Disposition" VALUE="inline;
filename=#form.tempfilename#"
cfcontent type="application/unknown"
file="D:\blah\clientapps\marcon\archives\#form.tempfilename#"

It still comes up with the name of the calling template file instead of the
file name!  Am I still off?

Eric J Hoffman
Home of Vikings fans Worldwide!
http://www.purplepride.org



-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Sunday, November 11, 2001 3:53 PM
To: CF-Talk
Subject: RE: Am I a crackhead: CFContent Weirdness


> Well, even when I cfcontent a normal file name like temp.txt,
> it is naming the file the calling template's file name rather
> than temp.txt in the save as dialog.  Very weird??

Not really - that's how CFCONTENT works. For examples of how to work around
this, look here:
http://www.figleaf.com/demo/mimetest/

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




~~
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: CFCookie and the old switcharoo - help!

[Langford, Bryan]

Hi david,
Yeah actually I expired all the old cookies before beginning
> 
> 
> 
> 
 Just to make sure that the old cookies no longer existed.  On top of 
that I
had the trainer of the course walk through a manual deletion of all 
cookies
on each machine.  the problem still persisted.

Bryan Langford 


Analyst
National Customer Operations 
Enterprise Services & Strategic Planning
Training Development and Design Team. 
Desk: 714-695-4824
Cell: 714-270-8451


 


-Original Message-
From: David Cummins [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 1:53 PM
To: CF-Talk
Subject: Re: CFCookie and the old switcharoo - help!


Sounds like there are old cookies on those machines from previous 
attempts.
Maybe some machines now have cookie setting switched off, but of course 
the
old
cookies are still there. Try one of the machines with problems - turn 
cookie
prompting on, etc. Maybe change the name of the cookie to rule out that
possibility.

David

"Langford, Bryan" wrote:
> 
> Hey everyone,
> Anyone that read my recent posts "CFCOOKIE and the old
switcheroo".
> I am still looking for any other suggestion before I revert to using
> sessions instead of cookies.  The basic problem is that I have a 
multiple
> user environment, a class room of students, each log in to take the 
test:
> Page1:
> 
> 
>
> 
>   
> 
>   Welcome Back #cookie.repname#:
>   
> 
>   
> 
> 
>   ID:
>   
>  (First 5 digits 
of
> SSN.)
>   
> 
>   
>   If you are not #cookie.repname# Click
> here
>   
> 
> 
> 
> 
> That is submitted through the form action to repverification which 
builds
> the cookies.
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>  '#mid(form.repname,value1,1)#' EQ CHR(39)>
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>  timeout="60"
> throwontimeout="Yes"
> type="EXCLUSIVE">
> 
>  
>  VALUE="#cookvalue#"
> EXPIRES="2" >
>  VALUE="#form.repid#"
> EXPIRES="2" >
> 
> 
> 
> 
> The information you have provided as your ID is not numeric or does 
not
> contain 5 digits, please click back and enter the first 5 digits of 
your
> social security number.
> 
> 
> Lastly the repmenu is pulled up.
> 
> select #variables.mastertableansw#.fldname,
> #variables.mastertableansw#.fldid, 
#variables.mastertableansw#.testnumber,
> max(#variables.mastertableansw#.questionnumber) as maxquest,
> max(#variables.mastertable#.questnum) as maxq
> from #variables.mastertableansw#, #variables.mastertable#
> where fldname = '#cookie.repname#'
> and fldid = '#cookie.repid#'> and #variables.mastertableansw#.testnumber=
> #variables.mastertable#.testnumber
> group by #variables.mastertableansw#.fldname,
> #variables.mastertableansw#.fldid, 
#variables.mastertableansw#.testnumber
> 
> 
> 
> 
> 
> Our records indicate that you are a first 
time
user.
> Please select from the following tests.
> 
> Welcome Back #cookie.repname# your ID is #cookie.repid#
> #cookie.cftoken#
> 
> 
> 
> The problem is that reps 1 - 20 all log in.  Some reps get to the 
menu
page
> and get they're own information display...I.E. Rep 5 logs in and 
gets:
> "Welcome back rep5,"
> But many of the reps get someone elses info
> Rep 2 logs in and gets: "Welcome back rep 3"
> Rep 1 gets rep5
> rep 7 gets rep 3 as well.   etc.
> If anyone has ANY suggestions I would certianly appreciate it.  I 
have 12
> call centers full of trainees all waiting to take their tests.  I'm
starting
> to feel sorry that I ever switched to cookies from session vars.
> Bryan Langford
> 
> Analyst
> National Customer Operations
> Enterprise Services & Strategic Planning
> Training Development and Design Team.
> 
> Bryan Langford
> 
> Analyst
> National Customer Operations
> Enterprise Services & Strategic Planning
> Training Development and Design Team.
> >
> >
> >
> 
> 

~~
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: Am I a crackhead: CFContent Weirdness

[Eric J Hoffman]

The host is CF 5 on a Win2000 box if I recall correctly.

Eric J Hoffman
Home of Vikings fans Worldwide!
http://www.purplepride.org



-Original Message-
From: Duane Boudreau [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 3:59 PM
To: CF-Talk
Subject: RE: Am I a crackhead: CFContent Weirdness


what is your OS and SP level?

Duane

-Original Message-
From: Eric J Hoffman [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 4:49 PM
To: CF-Talk
Subject: RE: Am I a crackhead: CFContent Weirdness


CFHEADER NAME="Content-Disposition" VALUE="inline;
filename=#form.tempfilename#"
cfcontent type="application/unknown"
file="D:\blah\clientapps\marcon\archives\#form.tempfilename#"

It still comes up with the name of the calling template file instead of the
file name!  Am I still off?

Eric J Hoffman
Home of Vikings fans Worldwide!
http://www.purplepride.org



-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Sunday, November 11, 2001 3:53 PM
To: CF-Talk
Subject: RE: Am I a crackhead: CFContent Weirdness


> Well, even when I cfcontent a normal file name like temp.txt,
> it is naming the file the calling template's file name rather
> than temp.txt in the save as dialog.  Very weird??

Not really - that's how CFCONTENT works. For examples of how to work around
this, look here:
http://www.figleaf.com/demo/mimetest/

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: Request Scope Questions

[Christopher Olive]

no, i said as you pointed out, it might be faster.  in principle, this
seems a logical statment.

christopher olive, cto, vp of web development
cresco technologies, inc
410.825.0383
http://www.crescotech.com


-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 10:40 AM
To: CF-Talk
Subject: RE: Request Scope Questions


I don't know if you mean me, but if so, I did not say structcopy is
faster. I said it _may_ be faster, but if so, most likely not in any
significant manner.

(If I'm wrong, sorry. As always, listen to what I _meant_ to say, not
what I said. ;)

Raymond Camden, Principal Spectra Compliance Engineer for Macromedia

Email: [EMAIL PROTECTED]
Yahoo IM : morpheus

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

> -Original Message-
> From: Christopher Olive [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, November 12, 2001 10:33 AM
> To: CF-Talk
> Subject: RE: Request Scope Questions
> 
> 
> as ray points out, in "principle", structcopy should be 
> faster.  by what
> margin, i don't know.  but the principle remains.
> 
> christopher olive, cto, vp of web development
> cresco technologies, inc
> 410.825.0383
> http://www.crescotech.com
> 
> 
> -Original Message-
> From: Daniel Lancelot [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 12, 2001 10:32 AM
> To: CF-Talk
> Subject: FW: Request Scope Questions
> 
> 
> If this is the case, is there any disadvantage of doing 
> duplicate rather
> than structcopy? - It would seem that duplicate would
> always work...
> 
> -Original Message-
> From: Christopher Olive [mailto:[EMAIL PROTECTED]]
> Sent: 12 November 2001 15:21
> To: CF-Talk
> Subject: RE: Request Scope Questions
> 
> 
> if i understand correctly, a week or so ago you (dave) mentioned that
> duplicate was only necessary for a session structure if it contained
> other complex variables.  you said that StructCopy was 
> sufficient if it
> was merely a structure with simple variables.  is this correct?
> 
> christopher olive, cto, vp of web development
> cresco technologies, inc
> 410.825.0383
> http://www.crescotech.com
> 
> 
> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, November 11, 2001 5:00 PM
> To: CF-Talk
> Subject: RE: Request Scope Questions
> 
> 
> > A couple of notes here: if you do this, use something like
> >
> > 
> >
> > to transfer the variable. If you don't use Duplicate() - correct
> > me if I'm wrong someone! - then request.var just becomes a 'pointer'
> > to session.var, and session.var is still actually read when you
> > refer later to request.var (rendering the whole business kind of
> > redundant!). Duplicate() - which is only available in CF4.5+ -
> > makes request.var a 'deep' copy of session.var, and then request.var
> > technically has nothing to do with session.var except having the
> > same value.
> 
> It's only necessary to use Duplicate in this case if Session.var is a
> structure or a query. If it's just a simple value, you don't need to
> worry -
> simple values are always passed by value, not by reference.
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
> 
> 
> 
> 
> 

~~
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: Am I a crackhead: CFContent Weirdness

[Duane Boudreau]

what is your OS and SP level?

Duane

-Original Message-
From: Eric J Hoffman [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 4:49 PM
To: CF-Talk
Subject: RE: Am I a crackhead: CFContent Weirdness


CFHEADER NAME="Content-Disposition" VALUE="inline;
filename=#form.tempfilename#"
cfcontent type="application/unknown"
file="D:\blah\clientapps\marcon\archives\#form.tempfilename#"

It still comes up with the name of the calling template file instead of the
file name!  Am I still off?

Eric J Hoffman
Home of Vikings fans Worldwide!
http://www.purplepride.org



-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Sunday, November 11, 2001 3:53 PM
To: CF-Talk
Subject: RE: Am I a crackhead: CFContent Weirdness


> Well, even when I cfcontent a normal file name like temp.txt,
> it is naming the file the calling template's file name rather
> than temp.txt in the save as dialog.  Very weird??

Not really - that's how CFCONTENT works. For examples of how to work around
this, look here:
http://www.figleaf.com/demo/mimetest/

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: Inserting single quotes into SQL Server...

[Howie Hamlin]

Use the PreserveSingleQuotes function.

HTH,

--
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. - www.CoolFusion.com  - 631-737-4668 x101
inFusion Mail Server (iMS) - The Intelligent Mail Server
<<< Vote for iMS as the CFDJ Reader's Choice Awards Most Innovative Product >>>
http://www.sys-con.com/coldfusion/readerschoice2001/nominationformbpa.cfm
>>> Find out how iMS Stacks up to the competition: 
>http://www.coolfusion.com/imssecomparison.cfm

- Original Message - 
From: "Kevin Langevin" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 12, 2001 4:33 PM
Subject: Inserting single quotes into SQL Server...


> Hi all-
> 
> I've beaten this problem before, but even looking at code that seems to work
> fine from previous projects, I can't see what I'm doing wrong.
> 
> I want to insert a string into a record in a SQL Server 2000 DB. The string
> contains a customer's name.  If the customer's name contains an apostrophe,
> the insert dies.  It works fine in another app, but I can't see what I'm
> doing differently.  I'm not escaping anything or doing anything special,
> from what I can see.
> 
> Anyone have any standard ways of inserting strings into SQL which may or may
> not contain single quotes?
> 
> 
> Kevin Langevin
> Web Guy In Charge
> UsWebGuys
> 954-327-5780
> 
> 
> -Original Message-
> From: Langford, Bryan [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 12, 2001 4:29 PM
> To: CF-Talk
> Subject: CFCookie and the old switcharoo - help!
> 
> 
> Hey everyone,
> Anyone that read my recent posts "CFCOOKIE and the old switcheroo".
> I am still looking for any other suggestion before I revert to using
> sessions instead of cookies.  The basic problem is that I have a multiple
> user environment, a class room of students, each log in to take the test:
> Page1:
> 
> 
>
> 
>   
> 
>   Welcome Back #cookie.repname#:
>   
> 
>   
> 
> 
>   ID:
>   
>  (First 5 digits of
> SSN.)
>   
> 
>   
>   If you are not #cookie.repname# Click
> here
>   
> 
> 
> 
> 
> That is submitted through the form action to repverification which builds
> the cookies.
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>  '#mid(form.repname,value1,1)#' EQ CHR(39)>
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>  timeout="60"
> throwontimeout="Yes"
> type="EXCLUSIVE">
> 
>  
>  VALUE="#cookvalue#"
> EXPIRES="2" >
>  VALUE="#form.repid#"
> EXPIRES="2" >
> 
> 
> 
> 
> The information you have provided as your ID is not numeric or does not
> contain 5 digits, please click back and enter the first 5 digits of your
> social security number.
> 
> 
> Lastly the repmenu is pulled up.
> 
> select #variables.mastertableansw#.fldname,
> #variables.mastertableansw#.fldid, #variables.mastertableansw#.testnumber,
> max(#variables.mastertableansw#.questionnumber) as maxquest,
> max(#variables.mastertable#.questnum) as maxq
> from #variables.mastertableansw#, #variables.mastertable#
> where fldname = '#cookie.repname#'
> and fldid = '#cookie.repid#'
> and #variables.mastertableansw#.testnumber =
> #variables.mastertable#.testnumber
> group by #variables.mastertableansw#.fldname,
> #variables.mastertableansw#.fldid, #variables.mastertableansw#.testnumber
> 
> 
> 
> 
> 
> Our records indicate that you are a first time user.
> Please select from the following tests.
> 
> Welcome Back #cookie.repname# your ID is #cookie.repid#
> #cookie.cftoken#
> 
> 
> 
> The problem is that reps 1 - 20 all log in.  Some reps get to the menu page
> and get they're own information display...I.E. Rep 5 logs in and gets:
> "Welcome back rep5,"
> But many of the reps get someone elses info
> Rep 2 logs in and gets: "Welcome back rep 3"
> Rep 1 gets rep5
> rep 7 gets rep 3 as well.   etc.
> If anyone has ANY suggestions I would certianly appreciate it.  I have 12
> call centers full of trainees all waiting to take their tests.  I'm starting
> to feel sorry that I ever switched to cookies from session vars.
> Bryan Langford
> 
> 
> Analyst
> National Customer Operations
> Enterprise Services & Strategic Planning
> Training Development and Design Team.
> 
> Bryan Langford
> 
> 
> Analyst
> National Customer Operations
> Enterprise Services & Strategic Planning
> Training Development and Design Team.
> >
> >
> >
> 
> 
> 
~~
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

Trying to access information I just inserted in Access

[Steven Lancaster]

I have a form which inserts data into an access database. Once that data is
inserted I need to access the ID for that data so that I can send a URL in
an email for them to click on so that the information can be updated by
somebody else. I am running into the problem once I insert it tells me it
does not understand #id#. I do a query right after the insertion so that it
can pull that info, but how do I cross reference?

 Steven Lancaster
 WebMaster
 Core Laboratories
 6316 Windfern
 Houston, TX 77040
 713-328-2532 (Office)
 713-328-2150 (Fax)
 832-259-3010 (Cell)
 mailto:[EMAIL PROTECTED]

 http://www.corelab.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: Inserting single quotes into SQL Server... Rarrararrr!!!

[Mookie Bear]

For some reason this always works with me!!  ok, i assume that customer's 
name is in form variable, so create a new variable and set it to that form 
variable, and use that new variable u created in the SQL code.  this works, 
promise!  if anyone knows why, i'd like to know!

hehehe Rarrararrr!!!








>From: "Kevin Langevin" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: Inserting single quotes into SQL Server...
>Date: Mon, 12 Nov 2001 16:33:21 -0500
>
>Hi all-
>
>I've beaten this problem before, but even looking at code that seems to 
>work
>fine from previous projects, I can't see what I'm doing wrong.
>
>I want to insert a string into a record in a SQL Server 2000 DB. The string
>contains a customer's name.  If the customer's name contains an apostrophe,
>the insert dies.  It works fine in another app, but I can't see what I'm
>doing differently.  I'm not escaping anything or doing anything special,
>from what I can see.
>
>Anyone have any standard ways of inserting strings into SQL which may or 
>may
>not contain single quotes?
>
>
>Kevin Langevin
>Web Guy In Charge
>UsWebGuys
>954-327-5780
>
>
>-Original Message-
>From: Langford, Bryan [mailto:[EMAIL PROTECTED]]
>Sent: Monday, November 12, 2001 4:29 PM
>To: CF-Talk
>Subject: CFCookie and the old switcharoo - help!
>
>
>Hey everyone,
>   Anyone that read my recent posts "CFCOOKIE and the old switcheroo".
>I am still looking for any other suggestion before I revert to using
>sessions instead of cookies.  The basic problem is that I have a multiple
>user environment, a class room of students, each log in to take the test:
>Page1:
>
>
>
>
>   
> 
>   Welcome Back #cookie.repname#:
>   
> 
>   
> 
> 
>   ID:
>   
>  (First 5 digits of
>SSN.)
>   
> 
>   
>   If you are not #cookie.repname# Click
>here
>   
> 
>
>
>
>That is submitted through the form action to repverification which builds
>the cookies.
>
>
>
>
>
>
>
>
>
>
>
>
>
>'#mid(form.repname,value1,1)#' EQ CHR(39)>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>timeout="60"
>throwontimeout="Yes"
>type="EXCLUSIVE">
>
>  
> VALUE="#cookvalue#"
> EXPIRES="2" >
> VALUE="#form.repid#"
> EXPIRES="2" >
>   
>
>
>
>The information you have provided as your ID is not numeric or does not
>contain 5 digits, please click back and enter the first 5 digits of your
>social security number.
>
>
>Lastly the repmenu is pulled up.
>
>select #variables.mastertableansw#.fldname,
>#variables.mastertableansw#.fldid, #variables.mastertableansw#.testnumber,
>max(#variables.mastertableansw#.questionnumber) as maxquest,
>max(#variables.mastertable#.questnum) as maxq
>from #variables.mastertableansw#, #variables.mastertable#
>where fldname = '#cookie.repname#'
>and fldid = '#cookie.repid#'
>and #variables.mastertableansw#.testnumber =
>#variables.mastertable#.testnumber
>group by #variables.mastertableansw#.fldname,
>#variables.mastertableansw#.fldid, #variables.mastertableansw#.testnumber
>
>
>
>
>
>Our records indicate that you are a first time user.
>Please select from the following tests.
>
>Welcome Back #cookie.repname# your ID is #cookie.repid#
>#cookie.cftoken#
>
>
>
>The problem is that reps 1 - 20 all log in.  Some reps get to the menu page
>and get they're own information display...I.E. Rep 5 logs in and gets:
>"Welcome back rep5,"
>But many of the reps get someone elses info
>Rep 2 logs in and gets: "Welcome back rep 3"
>Rep 1 gets rep5
>rep 7 gets rep 3 as well.   etc.
>If anyone has ANY suggestions I would certianly appreciate it.  I have 12
>call centers full of trainees all waiting to take their tests.  I'm 
>starting
>to feel sorry that I ever switched to cookies from session vars.
>Bryan Langford
>
>
>Analyst
>National Customer Operations
>Enterprise Services & Strategic Planning
>Training Development and Design Team.
>
>Bryan Langford
>
>
>Analyst
>National Customer Operations
>Enterprise Services & Strategic Planning
>Training Development and Design Team.
> >
> >
> >
>
>
>
~~
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: Opening file

[Joseph DeVore]

You could use CFCONTENT to serve them up as .dat files.





Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 1:45 PM
To: CF-Talk
Subject: Re: Opening file


Hi,

I have a test page on the server (Intranet) with the following link. I've
configured my file associations in UltraEdit (on the client)
to open .dat files. When I click on the link the file gets opening in
Ultraedit which is what I want.

For some reason if the following tags are in the datafile , ,
...etc the file get sent to the browser. Can someone explain why?
How do I get around this problem?

The "X" is a mapped driver letter on the client PC pointing to a specific
directory on the server.




Test



Test File





~~
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: Am I a crackhead: CFContent Weirdness

[Eric J Hoffman]

CFHEADER NAME="Content-Disposition" VALUE="inline;
filename=#form.tempfilename#"
cfcontent type="application/unknown"
file="D:\blah\clientapps\marcon\archives\#form.tempfilename#"

It still comes up with the name of the calling template file instead of the
file name!  Am I still off?

Eric J Hoffman
Home of Vikings fans Worldwide!
http://www.purplepride.org



-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Sunday, November 11, 2001 3:53 PM
To: CF-Talk
Subject: RE: Am I a crackhead: CFContent Weirdness


> Well, even when I cfcontent a normal file name like temp.txt,
> it is naming the file the calling template's file name rather
> than temp.txt in the save as dialog.  Very weird??

Not really - that's how CFCONTENT works. For examples of how to work around
this, look here:
http://www.figleaf.com/demo/mimetest/

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

~~
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: Opening file

[phumes1]

Hi,

I have a test page on the server (Intranet) with the following link. I've
configured my file associations in UltraEdit (on the client)
to open .dat files. When I click on the link the file gets opening in
Ultraedit which is what I want.

For some reason if the following tags are in the datafile , ,
...etc the file get sent to the browser. Can someone explain why?
How do I get around this problem?

The "X" is a mapped driver letter on the client PC pointing to a specific
directory on the server.




Test



Test File




~~
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: CFCookie and the old switcharoo - help!

[David Cummins]

Sounds like there are old cookies on those machines from previous attempts.
Maybe some machines now have cookie setting switched off, but of course the old
cookies are still there. Try one of the machines with problems - turn cookie
prompting on, etc. Maybe change the name of the cookie to rule out that
possibility.

David

"Langford, Bryan" wrote:
> 
> Hey everyone,
> Anyone that read my recent posts "CFCOOKIE and the old switcheroo".
> I am still looking for any other suggestion before I revert to using
> sessions instead of cookies.  The basic problem is that I have a multiple
> user environment, a class room of students, each log in to take the test:
> Page1:
> 
> 
>
> 
>   
> 
>   Welcome Back #cookie.repname#:
>   
> 
>   
> 
> 
>   ID:
>   
>  (First 5 digits of
> SSN.)
>   
> 
>   
>   If you are not #cookie.repname# Click
> here
>   
> 
> 
> 
> 
> That is submitted through the form action to repverification which builds
> the cookies.
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>  '#mid(form.repname,value1,1)#' EQ CHR(39)>
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>  timeout="60"
> throwontimeout="Yes"
> type="EXCLUSIVE">
> 
>  
>  VALUE="#cookvalue#"
> EXPIRES="2" >
>  VALUE="#form.repid#"
> EXPIRES="2" >
> 
> 
> 
> 
> The information you have provided as your ID is not numeric or does not
> contain 5 digits, please click back and enter the first 5 digits of your
> social security number.
> 
> 
> Lastly the repmenu is pulled up.
> 
> select #variables.mastertableansw#.fldname,
> #variables.mastertableansw#.fldid, #variables.mastertableansw#.testnumber,
> max(#variables.mastertableansw#.questionnumber) as maxquest,
> max(#variables.mastertable#.questnum) as maxq
> from #variables.mastertableansw#, #variables.mastertable#
> where fldname = '#cookie.repname#'
> and fldid = '#cookie.repid#'
> and #variables.mastertableansw#.testnumber =
> #variables.mastertable#.testnumber
> group by #variables.mastertableansw#.fldname,
> #variables.mastertableansw#.fldid, #variables.mastertableansw#.testnumber
> 
> 
> 
> 
> 
> Our records indicate that you are a first time user.
> Please select from the following tests.
> 
> Welcome Back #cookie.repname# your ID is #cookie.repid#
> #cookie.cftoken#
> 
> 
> 
> The problem is that reps 1 - 20 all log in.  Some reps get to the menu page
> and get they're own information display...I.E. Rep 5 logs in and gets:
> "Welcome back rep5,"
> But many of the reps get someone elses info
> Rep 2 logs in and gets: "Welcome back rep 3"
> Rep 1 gets rep5
> rep 7 gets rep 3 as well.   etc.
> If anyone has ANY suggestions I would certianly appreciate it.  I have 12
> call centers full of trainees all waiting to take their tests.  I'm starting
> to feel sorry that I ever switched to cookies from session vars.
> Bryan Langford
> 
> Analyst
> National Customer Operations
> Enterprise Services & Strategic Planning
> Training Development and Design Team.
> 
> Bryan Langford
> 
> Analyst
> National Customer Operations
> Enterprise Services & Strategic Planning
> Training Development and Design Team.
> >
> >
> >
> 
> 
~~
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

Inserting single quotes into SQL Server...

[Kevin Langevin]

Hi all-

I've beaten this problem before, but even looking at code that seems to work
fine from previous projects, I can't see what I'm doing wrong.

I want to insert a string into a record in a SQL Server 2000 DB. The string
contains a customer's name.  If the customer's name contains an apostrophe,
the insert dies.  It works fine in another app, but I can't see what I'm
doing differently.  I'm not escaping anything or doing anything special,
from what I can see.

Anyone have any standard ways of inserting strings into SQL which may or may
not contain single quotes?


Kevin Langevin
Web Guy In Charge
UsWebGuys
954-327-5780


-Original Message-
From: Langford, Bryan [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 4:29 PM
To: CF-Talk
Subject: CFCookie and the old switcharoo - help!


Hey everyone,
Anyone that read my recent posts "CFCOOKIE and the old switcheroo".
I am still looking for any other suggestion before I revert to using
sessions instead of cookies.  The basic problem is that I have a multiple
user environment, a class room of students, each log in to take the test:
Page1:


   

  

  Welcome Back #cookie.repname#:
  

  


  ID:
  
 (First 5 digits of
SSN.)
  

  
  If you are not #cookie.repname# Click
here
  




That is submitted through the form action to repverification which builds
the cookies.






























 






The information you have provided as your ID is not numeric or does not
contain 5 digits, please click back and enter the first 5 digits of your
social security number.


Lastly the repmenu is pulled up.

select #variables.mastertableansw#.fldname,
#variables.mastertableansw#.fldid, #variables.mastertableansw#.testnumber,
max(#variables.mastertableansw#.questionnumber) as maxquest,
max(#variables.mastertable#.questnum) as maxq
from #variables.mastertableansw#, #variables.mastertable#
where fldname = '#cookie.repname#'
and fldid = '#cookie.repid#'
and #variables.mastertableansw#.testnumber =
#variables.mastertable#.testnumber
group by #variables.mastertableansw#.fldname,
#variables.mastertableansw#.fldid, #variables.mastertableansw#.testnumber





Our records indicate that you are a first time user.
Please select from the following tests.

Welcome Back #cookie.repname# your ID is #cookie.repid#
#cookie.cftoken#



The problem is that reps 1 - 20 all log in.  Some reps get to the menu page
and get they're own information display...I.E. Rep 5 logs in and gets:
"Welcome back rep5,"
But many of the reps get someone elses info
Rep 2 logs in and gets: "Welcome back rep 3"
Rep 1 gets rep5
rep 7 gets rep 3 as well.   etc.
If anyone has ANY suggestions I would certianly appreciate it.  I have 12
call centers full of trainees all waiting to take their tests.  I'm starting
to feel sorry that I ever switched to cookies from session vars.
Bryan Langford


Analyst
National Customer Operations
Enterprise Services & Strategic Planning
Training Development and Design Team.

Bryan Langford


Analyst
National Customer Operations
Enterprise Services & Strategic Planning
Training Development and Design Team.
>
>
>


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

CFCookie and the old switcharoo - help!

[Langford, Bryan]

Hey everyone,
Anyone that read my recent posts "CFCOOKIE and the old switcheroo".
I am still looking for any other suggestion before I revert to using
sessions instead of cookies.  The basic problem is that I have a multiple
user environment, a class room of students, each log in to take the test:
Page1:


   
  
  

  Welcome Back #cookie.repname#:
   

  


  ID:
   
 (First 5 digits of
SSN.)
  

  
  If you are not #cookie.repname# Click
here
  




That is submitted through the form action to repverification which builds
the cookies.























  






 






The information you have provided as your ID is not numeric or does not
contain 5 digits, please click back and enter the first 5 digits of your
social security number.


Lastly the repmenu is pulled up.

select #variables.mastertableansw#.fldname,
#variables.mastertableansw#.fldid, #variables.mastertableansw#.testnumber,
max(#variables.mastertableansw#.questionnumber) as maxquest,
max(#variables.mastertable#.questnum) as maxq
from #variables.mastertableansw#, #variables.mastertable#
where fldname = '#cookie.repname#'
and fldid = '#cookie.repid#'
and #variables.mastertableansw#.testnumber =
#variables.mastertable#.testnumber
group by #variables.mastertableansw#.fldname,
#variables.mastertableansw#.fldid, #variables.mastertableansw#.testnumber



 

Our records indicate that you are a first time user.
Please select from the following tests.

Welcome Back #cookie.repname# your ID is #cookie.repid#
#cookie.cftoken#


 
The problem is that reps 1 - 20 all log in.  Some reps get to the menu page
and get they're own information display...I.E. Rep 5 logs in and gets:
"Welcome back rep5," 
But many of the reps get someone elses info
Rep 2 logs in and gets: "Welcome back rep 3"
Rep 1 gets rep5
rep 7 gets rep 3 as well.   etc.
If anyone has ANY suggestions I would certianly appreciate it.  I have 12
call centers full of trainees all waiting to take their tests.  I'm starting
to feel sorry that I ever switched to cookies from session vars.
Bryan Langford 


Analyst
National Customer Operations 
Enterprise Services & Strategic Planning
Training Development and Design Team. 

Bryan Langford 


Analyst
National Customer Operations 
Enterprise Services & Strategic Planning
Training Development and Design Team. 
>  
> 
> 

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

Allaire Alliance Partner Program -> Macromedia Alliance Program.. .

[Matthew Bertolami]

Hi, Kevin:

Your notes regarding the entitlements under the Allaire Alliance were
forwarded to me today.  Any partner with a current Allaire agreement  is
entitled to the benefits of the Allaire program until contract expiration.
The CF Studio updates will be distributed soon.  JRun 3.1 is a maintenance
release, and may be downloaded at
http://www.macromedia.com/software/jrun/download/.

Since the launch of the Macromedia Alliance, we are encouraging our existing
partners to join the new program.  Although there wouldn't be a refund for
the fee paid earlier this year, the term of your contract would be extended.
For example, if your current expiration date is March 2002, and you joined
the Macromedia Alliance today, the expiration of your new agreement would be
March 2003.  You can find the benefits and requirements of the new program
at www.macromedia.com/partners.

If you have any additional questions regarding your partnership, please send
them to [EMAIL PROTECTED]  A member of my team reviews this mailbox
daily.   

Best regards,

Meg-Ann Meaney
Director, Partner Programs
Macromedia
Phone: 617-219-7728
Fax: 617-219-2101


~~
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: Request Scope Questions

[Bryan Love]

Why not just copy the pointer from the session scope to the request scope?
Wouldn't the single-threaded nature of the request scope protect the actual
data from corruption?  I suppose the question I have is HOW does the CF
server force single threading in the request scope:

1.  By forcing every request into its own memory space or
2.  By internally recognizing and locking the data associated with the
request scope

Anyone?  Anyone?


 

Bryan Love Macromedia Certified Professional
Internet Application Developer / Database Analyst
Telecommunication Systems Inc.
[EMAIL PROTECTED]
 

"What father would hesitate to say 'if there must be trouble let it be in my
day, that my child may have peace'?"
- Thomas Paine, An American Crisis



-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 11:12 AM
To: CF-Talk
Subject: RE: Request Scope Questions


> if i understand correctly, a week or so ago you (dave) 
> mentioned that duplicate was only necessary for a session 
> structure if it contained other complex variables. you said 
> that StructCopy was sufficient if it was merely a structure 
> with simple variables. is this correct?

Yes, that's correct. Personally, I just use Duplicate whenever I want to
pass a structure by value, so I don't even think about it.

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: left outer join - and null results (Lazy but Stumped)

[Bryan Love]

try this:


select a.id, a.data, b.id, b.a_id, b.g, b.data
from a left outer join b on a.id = b.a_id
where b.g = #attributes.g# or b.id IS NULL


 

Bryan Love Macromedia Certified Professional
Internet Application Developer / Database Analyst
Telecommunication Systems Inc.
[EMAIL PROTECTED]
 

"What father would hesitate to say 'if there must be trouble let it be in my
day, that my child may have peace'?"
- Thomas Paine, An American Crisis



-Original Message-
From: Eric Dawson [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 11:21 AM
To: CF-Talk
Subject: left outer join - and null results (Lazy but Stumped)


Here is the SQL. (I need for both access and MSDE datasources)

select a.id, a.data, b.id, b.a_id, b.g, b.data
from a left outer join b on a.id = b.a_id
where b.g = #attributes.g# or b.id = null?

That's basically what I want to do.

a is a roster table
b is a game data table where each roster item (might) have a record.

I don't know how to detect the null value(s) in a joined record without 
data.

Or, is it better to do:
===
select a.id, a.data, b.id, b.a_id, b.g, b.data
from a left outer join
(select b.id, b.a_id, b.g, b.data from b where b.g = #attributes.g#)
on a.id = b.a_id

But I'm not sure if a) my syntax is right or b) yeah just can't do it on an 
access database. Can you do with MSDE?

Eric Dawson




~~
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: tickcount to actual time conversion

[Bryan Love]

if you want to measure processing time of a page you can get the tickcount
with GetTickCount() at the beginning and at the end then subtract.  Since it
is in milliseconds you just need to multiply by 1000 to get seconds.


 

Bryan Love Macromedia Certified Professional
Internet Application Developer / Database Analyst
Telecommunication Systems Inc.
[EMAIL PROTECTED]
 

"What father would hesitate to say 'if there must be trouble let it be in my
day, that my child may have peace'?"
- Thomas Paine, An American Crisis



-Original Message-
From: Justin Hansen [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 10:24 AM
To: CF-Talk
Subject: tickcount to actual time conversion


What formula would you use to convert tickcounts to actual time?


~~
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: Grids Rarrararrr!!

[Mookie Bear]

well if u have a SQL server backend, use the SQL Enterprise Management 
Console :D








>From: Janine Jakim <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: Grids
>Date: Mon, 12 Nov 2001 14:55:18 -0500
>
>What are people using instead of the cfgrid? I can't use cfgrid anymore
>
~~
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

Grids

[Janine Jakim]

What are people using instead of the cfgrid? I can't use cfgrid anymore
~~
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: Using CFModule

[Raymond Camden]

You don't need a lock around either. If code in the inside of the CT
does things that need locking, do it there.

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

Email: [EMAIL PROTECTED]
Yahoo IM : morpheus

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

> -Original Message-
> From: Bosky, Dave [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, November 12, 2001 2:42 PM
> To: CF-Talk
> Subject: Using CFModule
> 
> 
> What are the standard locking procedures regarding CFMODULE 
> and Custom Tags?
> 
> Is it necessary to put a lock around a cfmodule call or only 
> around a custom
> tag call?
>  
> Thanks
> Dave 
>  
>  
> 
> 
~~
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

Using CFModule

[Bosky, Dave]

What are the standard locking procedures regarding CFMODULE and Custom Tags?

Is it necessary to put a lock around a cfmodule call or only around a custom
tag call?
 
Thanks
Dave 
 
 

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

left outer join - and null results (Lazy but Stumped)

[Eric Dawson]

Here is the SQL. (I need for both access and MSDE datasources)

select a.id, a.data, b.id, b.a_id, b.g, b.data
from a left outer join b on a.id = b.a_id
where b.g = #attributes.g# or b.id = null?

That's basically what I want to do.

a is a roster table
b is a game data table where each roster item (might) have a record.

I don't know how to detect the null value(s) in a joined record without 
data.

Or, is it better to do:
===
select a.id, a.data, b.id, b.a_id, b.g, b.data
from a left outer join
(select b.id, b.a_id, b.g, b.data from b where b.g = #attributes.g#)
on a.id = b.a_id

But I'm not sure if a) my syntax is right or b) yeah just can't do it on an 
access database. Can you do with MSDE?

Eric Dawson



~~
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: Request Scope Questions

[Dave Watts]

> if i understand correctly, a week or so ago you (dave) 
> mentioned that duplicate was only necessary for a session 
> structure if it contained other complex variables. you said 
> that StructCopy was sufficient if it was merely a structure 
> with simple variables. is this correct?

Yes, that's correct. Personally, I just use Duplicate whenever I want to
pass a structure by value, so I don't even think about it.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~
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: ColdFusion extensions for Ultradev

[Massimo Foti]

"Peter Tilbrook" <[EMAIL PROTECTED]> wrote in message
> I must be missing something - the URL perhaps!

It's in the signature, I will take note for next time to make it more
visible :-)))


Massimo Foti
[EMAIL PROTECTED]

http://www.massimocorner.com
Dreamweaver, Ultradev and Fireworks goodies

http://www.projectseven.com/viewer/snippets.htm
Snippets Panel



~~
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: i don't understand cflock? can you explain it?

[Dave Watts]

> I think the only time that it doesn't really do a read is 
> when you do something like : IsDefined("session.myvariable"), 
> because this isn't reading the contents, only checking for the 
> existance of the variable. Having said that though, there is 
> still some debate about this. Comments anyone?

According to Sim Simeonov, who was at one point the lead developer on the CF
Server team, IsDefined is in fact a variable read, and must therefore be
locked.

It makes sense, when you consider that you're enumerating the Session
structure to find the variable, I suppose - you are in fact reading the
contents of the Session structure.

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

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
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

merant/foxpro

[Colby Reese]

Does anyone know of any special solaris environment variables or
configurations that need to be present to achieve connectivity to foxpro

databases?  I am unable to verify connections with the canned foxpro dbf

files included with cf5 like the snippets datasource.  We typically only

use the native oracle database connectivity, so I may have never
initialized certain odbc parameters.

Thanks

Colby Reese
University of Minnesota
612 626 2323
~~
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: tickcount to actual time conversion

[Howie Hamlin]

You can't convert tickcount to actual time.  Tickcount is the number of milliseconds 
since the sytem was rebooted (and resets after
43 days or so).

HTH,

--
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. - www.CoolFusion.com  - 631-737-4668 x101
inFusion Mail Server (iMS) - The Intelligent Mail Server
<<< Vote for iMS as the CFDJ Reader's Choice Awards Most Innovative Product >>>
http://www.sys-con.com/coldfusion/readerschoice2001/nominationformbpa.cfm
>>> Find out how iMS Stacks up to the competition: 
>http://www.coolfusion.com/imssecomparison.cfm

- Original Message -
From: "Justin Hansen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 12, 2001 1:23 PM
Subject: tickcount to actual time conversion


> What formula would you use to convert tickcounts to actual time?
>
> 
~~
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: Please Wait... ' or 'Loading...' message

[Don Vawter]

I create a div with position absolute and visibility visible and put a gif
in the div
Then I have the onload event  change the visibility. By making the position
absolute it doesnt affect placement of rest of the page. I also have the
submit buttons show the div to indidicate to users the program is acting.
You can see an example at www.secureyourposition.com  (choose Reports or Gap
Notification) site is still preliminary so all tabs are not operable.

If you don't have CF5 (hence cfflush) your best bet will be to show the give
from the onunload event of calling page.


splash{
position:absolute;
left:200px;
top:200px;
background-color:white;
visibilty:visible;
}



.
.
  

- Original Message -
From: "Kinley Pon" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 12, 2001 12:14 AM
Subject: RE: Please Wait... ' or 'Loading...' message


> Unfortunately, I can only use 4.5.
>
> Any ideas? - Kinley
>
>
> >From: "Kola Oyedeji" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: CF-Talk <[EMAIL PROTECTED]>
> >Subject: RE: Please Wait... ' or 'Loading...' message
> >Date: Sun, 11 Nov 2001 09:55:28 -
> >
> >If you do move to cf5
> >
> >there is an article by Ray Camden on how to do something along thses
lines:
> >
> >http://www.coldfusion.com/handlers/index.cfm?id=21216&method=full
> >
> >
> >HTH
> >
> >Kola
> >
> >-Original Message-
> >From: Stuart Duncan [mailto:[EMAIL PROTECTED]]
> >Sent: Sunday, November 11, 2001 6:39 AM
> >To: CF-Talk
> >Subject: Re: Please Wait... ' or 'Loading...' message
> >
> >
> >I don't how familiar you are with DHTML, but you could (hypothetically)
put
> >all your content into one DIV or SPAN tag... making it a layer, and make
it
> >invisible.
> >And then put a "Loading" messing into another DIV or SPAN tag, and make
it
> >visible.
> >
> >And then put an "OnLoad" handler in the Body tag, that would call
> >javascript to reverse the two. That would hide the "Loading" layer and
show
> >the content layer.
> >
> >That would be my suggestion. Course, that's only if you've got a handle
on
> >DHTML basics.
> >
> >Stuart Duncan.
> >
> >
> >At 06:32 PM 10/11/2001 -0800, you wrote:
> > >Hello everyone,
> > >
> > >Does anyone have an example of a 'Please Wait... ' or 'Loading...'
> >message
> > >that would prevent a user from clicking anywhere else?
> > >
> > >A message that would stay on the screen until the main page is
complete;
> > >until the rest of the content is ready.
> > >
> > >Any ideas? - Kinley
> > >
> > >
> > >
> > >
> >
> >
> 
~~
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

tickcount to actual time conversion

[Justin Hansen]

What formula would you use to convert tickcounts to actual time?

~~
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: Multiple case statements in SCRIPT

[Bryan Love]

Philip's got it.  Remember when using switch statements in CFSCRIPT that
once a condition is met CF will execute EVERYTHING until it encounters the
end of the switch OR a break.  


 

Bryan Love Macromedia Certified Professional
Internet Application Developer / Database Analyst
Telecommunication Systems Inc.
[EMAIL PROTECTED]
 

"What father would hesitate to say 'if there must be trouble let it be in my
day, that my child may have peace'?"
- Thomas Paine, An American Crisis



-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 5:52 AM
To: CF-Talk
Subject: RE: Multiple case statements in SCRIPT


> ColdFusion throws a wobbly on this (and the other variations I've tried
>
> switch (Attributes.PeriodID) {
>case (1,2,3) {
>   ...
>}
>case 4 {
>}
> }
>
> Is there any way to provide multiple values?

Of course

switch (Attributes.PeriodID)
{   case "1":
case "2":
case "3":
{   do stuff;
break;
}
case "4":
{   do other stuff;
}
}

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

"Websites for the real world"

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



~~
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: submitting a form with out a button? unload

[Bryan Love]

Actually, it sounds like this would be better fixed by changing your
architecture.  If you need to retain form information then stack the action
page on top of your form page.  That way you can fall through and re-display
the form if validation fails, or you can insert into the db and cflocate if
the fields are ok.  In fusebox it would look like this:










If you aren't fond of fusebox your form page might look like this:







mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 8:38 AM
To: CF-Talk
Subject: submitting a form with out a button? unload


i am sure this has been done a lot but cant find it.

how can i submit a form with out using a button.
using an unload event?


i was going to use cflocation on an action page, but cant pass my 
variable back to another page

thanks

-paul

~~
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: i don't understand cflock? can you explain it?

[Stephen Moretti]

David,


> Another question on understanding CFLOCK.   when you say reading the
> variable what is considered a read.   Any time you use the variable say in
a
> cfoutput.  Is this a read and should be locked?
>

You'd be correct in that assumption.

Also in CFSETs and CFPARAMS, using the variable as path for an CFINCLUDE
etc. etc.  Basically anything that will return the contents of the variable
to some part of CF is considered a read.

I think the only time that it doesn't really do a read is when you do
something like : IsDefined("session.myvariable"), because this isn't reading
the contents, only checking for the existance of the variable.  Having said
that though, there is still some debate about this.  Comments anyone?

Regards

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: i don't understand cflock? can you explain it?

[Sandy Clark]

Anytime you even look sideways at a shared scoped variable, that is
considered a read.




would be considered a read.



-Original Message-
From: David Green [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 9:22 AM
To: CF-Talk
Subject: Re: i don't understand cflock? can you explain it?


Another question on understanding CFLOCK.   when you say reading the
variable what is considered a read.   Any time you use the variable say in a
cfoutput.  Is this a read and should be locked?

Thanks
David

- Original Message -
From: "Beau Harbin" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 12, 2001 6:27 AM
Subject: RE: i don't understand cflock? can you explain it?


> Paul,
>
> The simple rule of thumb is that if you are using
> application, session or server variables then you need to
> lock them on reads and writes.  Meaning if you have a variable
> called Application.DSN, then you need to lock it when you
> write it and also lock it when you read it.
>
> If your application does not use application, session or server
> variables, then you don't have to worry about it.
>
> See Nate Weiss' talk at DevCon on locking for more information:
> http://www.nateweiss.com
>
> Good luck,
> Beau
>
>
> -Original Message-
> From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 12, 2001 9:25 AM
> To: CF-Talk
> Subject: i don't understand cflock? can you explain it?
>
>
> in  the WACK 4.0 & AID book's there is only a 1/2 page or so related to
> it.
> in mastering cf 4.0 there are a few pages about it, that i really don't
> understand.
>
> if i am not using application variables, just calling data sources for
> drop
> down list
> as well as calling data source for update pages, should i use cflock?
>
> you know just your standard generic forms, which is about 80% of my
> daily
> work here.
>
> how can i get a good grasp of  WHY to use them?
>
> Thanks in advance.
> any advice would be great!
>
>
>

~~
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: i don't understand cflock? can you explain it?

[tom muck]

Yes, that is a read.  If you even mention the variable name under your
breath you should put a read only lock on it.  If you are setting the
variable put an exclusive lock on it.

tom

"David Green" <[EMAIL PROTECTED]> wrote in message
006e01c16b9e$83277310$c8c1fcd0@davidxp">news:006e01c16b9e$83277310$c8c1fcd0@davidxp...
> Another question on understanding CFLOCK.   when you say reading the
> variable what is considered a read.   Any time you use the variable say in
a
> cfoutput.  Is this a read and should be locked?
>
> Thanks
> David


~~
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: i don't understand cflock? can you explain it?

[David Green]

Another question on understanding CFLOCK.   when you say reading the
variable what is considered a read.   Any time you use the variable say in a
cfoutput.  Is this a read and should be locked?

Thanks
David

- Original Message -
From: "Beau Harbin" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 12, 2001 6:27 AM
Subject: RE: i don't understand cflock? can you explain it?


> Paul,
>
> The simple rule of thumb is that if you are using
> application, session or server variables then you need to
> lock them on reads and writes.  Meaning if you have a variable
> called Application.DSN, then you need to lock it when you
> write it and also lock it when you read it.
>
> If your application does not use application, session or server
> variables, then you don't have to worry about it.
>
> See Nate Weiss' talk at DevCon on locking for more information:
> http://www.nateweiss.com
>
> Good luck,
> Beau
>
>
> -Original Message-
> From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 12, 2001 9:25 AM
> To: CF-Talk
> Subject: i don't understand cflock? can you explain it?
>
>
> in  the WACK 4.0 & AID book's there is only a 1/2 page or so related to
> it.
> in mastering cf 4.0 there are a few pages about it, that i really don't
> understand.
>
> if i am not using application variables, just calling data sources for
> drop
> down list
> as well as calling data source for update pages, should i use cflock?
>
> you know just your standard generic forms, which is about 80% of my
> daily
> work here.
>
> how can i get a good grasp of  WHY to use them?
>
> Thanks in advance.
> any advice would be great!
>
>
> 
~~
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: Coldfusion Server hanging up...

[Kinley Pon]

Unfortunately, the entire the server...


>From: Jochem van Dieten <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: Re: Coldfusion Server hanging up...
>Date: Mon, 12 Nov 2001 10:52:04 +0100
>
>Kinley Pon wrote:
>
> > I am receiving this error message plus I am force to restart the server.
>
>
>The entire server or just the CF Application Service.
>
>
> > --
> > Error Occurred While Processing Request
> > Error Diagnostic Information
> >
> > Request canceled or ignored by serverServer busy or unable to fulfill
> > request. The server is unable to fulfill your request due to extremely 
>high
> > traffic or an unexpected internal error. Please attempt your request 
>again
> > (if you are repeatedly unsuccessful you should notify the site
> > administrator). (Location Code: 26)
> >
> > Please inform the site administrator that this error has occurred (be 
>sure
> > to include the contents of this page in your message to the 
>administrator).
> >
> > --
> > I have added all the necessary  throughout the application.  I 
>am
> > using either session variables or local variables.
> >
> > My intent while testing the application is to break it.  I would click
> > wildly on links or buttons on the page and wait would not wait for the
> > process of each event to complete before clicking the next event.
>
>
>Can you provide some statistics like memory usage, CPU usage etc.?
>
>The error itself seems quite clear to me. You seem to have a performance
>problem. Enable logging of slow pages and see what turns up. Also, set
>the restart at x unresponsive requests a bit tighter.
>
>Jochem
>
~~
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: Allaire Alliance Partner Program -> Macromedia Alliance Progr am...

[Dharmesh Goel]

I think they offered a refund on the forums.

Dharmesh Goel
Programmer Analyst
IT Dept. - Discount Car & Truck Rentals
416-744-0123 x290

 -Original Message-
From:   Peter Tilbrook [mailto:[EMAIL PROTECTED]] 
Sent:   November 12, 2001 3:14 AM
To: CF-Talk
Subject:Re: Allaire Alliance Partner Program -> Macromedia Alliance
Program...

Especially if you also purchased a "subscription".

The best I've experience was purchasing Forums at about AUD $760.00 only 
for Allaire to then make it "open source".

Really impressed.

Honest. I was REALLY impressed!

At 16:02 11/11/01 -0500, you wrote:
>New management, new rules.  I was surprised to see they continued the
>program at all after the merger, but in it's current form it doesn't make
>much sense, at least for me personally since I have to buy the server
anyway
>for hosting my sites.  Speaking an author, it was a great program because I
>could work with the development software and the servers for my own
personal
>use for research and screenshots.
>
>tom
>
>
>"Kevin Langevin" <[EMAIL PROTECTED]> wrote in message
>news:[EMAIL PROTECTED]...
> > Hmmm...I received Homesite and Studio, even Skillbuilding, with my
>original
> > entitlement package.  I don't see why any of that would make a
difference.
> > We'll see...I'll post whatever I find out.
> >
> >
> > Kevin Langevin
> > Web Guy In Charge
> > UsWebGuys
> > 954-327-5780
>
>
>

~~
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: submitting a form with out a button? unload

[Paul Ihrig]

found it

-paul



-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 11:38 AM
To: CF-Talk
Subject: submitting a form with out a button? unload


i am sure this has been done a lot but cant find it.

how can i submit a form with out using a button.
using an unload event?


i was going to use cflocation on an action page, but cant pass my 
variable back to another page

thanks

-paul

~~
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: submitting a form with out a button? unload

[Critz]

oi Paul!!

Click  Here  to  Submit.


-- 
Critter, MMCP
Certified ColdFusion Developer

Crit[s2k] - 


-
Monday, November 12, 2001, 11:37:44 AM, you wrote:

PI> i am sure this has been done a lot but cant find it.

PI> how can i submit a form with out using a button.
PI> using an unload event?


PI> i was going to use cflocation on an action page, but cant pass my 
PI> variable back to another page

PI> thanks

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

submitting a form with out a button? unload

[Paul Ihrig]

i am sure this has been done a lot but cant find it.

how can i submit a form with out using a button.
using an unload event?


i was going to use cflocation on an action page, but cant pass my 
variable back to another page

thanks

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

Coldfusion and 4D

[Stephen Adams]

Hi,

Has anyone used CF connecting to a 4D database,  using the 4D ODBC driver.  If so has 
anyone found any problems to be aware of ?

Stephen
~~
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: Request Scope Questions

[Jeremy Allen]

I have never been happy with the documentation nor the
general handling of by reference/by value. 

I think it is honestly more confusing to have certain
data structures behave one way, yet others behave 
another. It may hide the complexity short-term but
in the long run it requires cruft like the "StructCopy/
Duplicate" stuff. 

Point and case, Looking at the function names what
is the difference in StructCopy and Duplicate. ???

You can't really tell. StructCopy creates a structure
but "Top-level simple values and arrays are assigned by value".

The documentation is ambiguous and probably confusing to most
people. Its just funny business. 

In PHP I can control by reference/value with a simple ampersand
and there is no language cruft really that has to work
around the behavior of by reference/by value. Granted no
language is perfect since some things are not very straight forward
with PHP at first. 

One way or another, I just wish it was more concise and easy
to handle in CF. All in all it is not TERRIBLE, but it certainly
stands a huge amount of room for improvement. Perhaps even
some diagrams and more careful wording in the documentation so
that there is less ambiguity. 

Jeremy Allen
elliptIQ Inc.

-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 10:40 AM
To: CF-Talk
Subject: RE: Request Scope Questions


I don't know if you mean me, but if so, I did not say structcopy is
faster. I said it _may_ be faster, but if so, most likely not in any
significant manner.

(If I'm wrong, sorry. As always, listen to what I _meant_ to say, not
what I said. ;)

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

Email: [EMAIL PROTECTED]
Yahoo IM : morpheus

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

> -Original Message-
> From: Christopher Olive [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, November 12, 2001 10:33 AM
> To: CF-Talk
> Subject: RE: Request Scope Questions
> 
> 
> as ray points out, in "principle", structcopy should be 
> faster.  by what
> margin, i don't know.  but the principle remains.
> 
> christopher olive, cto, vp of web development
> cresco technologies, inc
> 410.825.0383
> http://www.crescotech.com
> 
> 
> -Original Message-
> From: Daniel Lancelot [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 12, 2001 10:32 AM
> To: CF-Talk
> Subject: FW: Request Scope Questions
> 
> 
> If this is the case, is there any disadvantage of doing 
> duplicate rather
> than structcopy? - It would seem that duplicate would
> always work...
> 
> -Original Message-
> From: Christopher Olive [mailto:[EMAIL PROTECTED]]
> Sent: 12 November 2001 15:21
> To: CF-Talk
> Subject: RE: Request Scope Questions
> 
> 
> if i understand correctly, a week or so ago you (dave) mentioned that
> duplicate was only necessary for a session structure if it contained
> other complex variables.  you said that StructCopy was 
> sufficient if it
> was merely a structure with simple variables.  is this correct?
> 
> christopher olive, cto, vp of web development
> cresco technologies, inc
> 410.825.0383
> http://www.crescotech.com
> 
> 
> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, November 11, 2001 5:00 PM
> To: CF-Talk
> Subject: RE: Request Scope Questions
> 
> 
> > A couple of notes here: if you do this, use something like
> >
> > 
> >
> > to transfer the variable. If you don't use Duplicate() - correct
> > me if I'm wrong someone! - then request.var just becomes a 'pointer'
> > to session.var, and session.var is still actually read when you
> > refer later to request.var (rendering the whole business kind of
> > redundant!). Duplicate() - which is only available in CF4.5+ -
> > makes request.var a 'deep' copy of session.var, and then request.var
> > technically has nothing to do with session.var except having the
> > same value.
> 
> It's only necessary to use Duplicate in this case if Session.var is a
> structure or a query. If it's just a simple value, you don't need to
> worry -
> simple values are always passed by value, not by reference.
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
> 
> 
> 
> 
> 

~~
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: Request Scope Questions

[Raymond Camden]

I don't know if you mean me, but if so, I did not say structcopy is
faster. I said it _may_ be faster, but if so, most likely not in any
significant manner.

(If I'm wrong, sorry. As always, listen to what I _meant_ to say, not
what I said. ;)

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

Email: [EMAIL PROTECTED]
Yahoo IM : morpheus

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

> -Original Message-
> From: Christopher Olive [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, November 12, 2001 10:33 AM
> To: CF-Talk
> Subject: RE: Request Scope Questions
> 
> 
> as ray points out, in "principle", structcopy should be 
> faster.  by what
> margin, i don't know.  but the principle remains.
> 
> christopher olive, cto, vp of web development
> cresco technologies, inc
> 410.825.0383
> http://www.crescotech.com
> 
> 
> -Original Message-
> From: Daniel Lancelot [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 12, 2001 10:32 AM
> To: CF-Talk
> Subject: FW: Request Scope Questions
> 
> 
> If this is the case, is there any disadvantage of doing 
> duplicate rather
> than structcopy? - It would seem that duplicate would
> always work...
> 
> -Original Message-
> From: Christopher Olive [mailto:[EMAIL PROTECTED]]
> Sent: 12 November 2001 15:21
> To: CF-Talk
> Subject: RE: Request Scope Questions
> 
> 
> if i understand correctly, a week or so ago you (dave) mentioned that
> duplicate was only necessary for a session structure if it contained
> other complex variables.  you said that StructCopy was 
> sufficient if it
> was merely a structure with simple variables.  is this correct?
> 
> christopher olive, cto, vp of web development
> cresco technologies, inc
> 410.825.0383
> http://www.crescotech.com
> 
> 
> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, November 11, 2001 5:00 PM
> To: CF-Talk
> Subject: RE: Request Scope Questions
> 
> 
> > A couple of notes here: if you do this, use something like
> >
> > 
> >
> > to transfer the variable. If you don't use Duplicate() - correct
> > me if I'm wrong someone! - then request.var just becomes a 'pointer'
> > to session.var, and session.var is still actually read when you
> > refer later to request.var (rendering the whole business kind of
> > redundant!). Duplicate() - which is only available in CF4.5+ -
> > makes request.var a 'deep' copy of session.var, and then request.var
> > technically has nothing to do with session.var except having the
> > same value.
> 
> It's only necessary to use Duplicate in this case if Session.var is a
> structure or a query. If it's just a simple value, you don't need to
> worry -
> simple values are always passed by value, not by reference.
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
> 
> 
> 
> 
> 
~~
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: Request Scope Questions

[Christopher Olive]

as ray points out, in "principle", structcopy should be faster.  by what
margin, i don't know.  but the principle remains.

christopher olive, cto, vp of web development
cresco technologies, inc
410.825.0383
http://www.crescotech.com


-Original Message-
From: Daniel Lancelot [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 10:32 AM
To: CF-Talk
Subject: FW: Request Scope Questions


If this is the case, is there any disadvantage of doing duplicate rather
than structcopy? - It would seem that duplicate would
always work...

-Original Message-
From: Christopher Olive [mailto:[EMAIL PROTECTED]]
Sent: 12 November 2001 15:21
To: CF-Talk
Subject: RE: Request Scope Questions


if i understand correctly, a week or so ago you (dave) mentioned that
duplicate was only necessary for a session structure if it contained
other complex variables.  you said that StructCopy was sufficient if it
was merely a structure with simple variables.  is this correct?

christopher olive, cto, vp of web development
cresco technologies, inc
410.825.0383
http://www.crescotech.com


-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Sunday, November 11, 2001 5:00 PM
To: CF-Talk
Subject: RE: Request Scope Questions


> A couple of notes here: if you do this, use something like
>
> 
>
> to transfer the variable. If you don't use Duplicate() - correct
> me if I'm wrong someone! - then request.var just becomes a 'pointer'
> to session.var, and session.var is still actually read when you
> refer later to request.var (rendering the whole business kind of
> redundant!). Duplicate() - which is only available in CF4.5+ -
> makes request.var a 'deep' copy of session.var, and then request.var
> technically has nothing to do with session.var except having the
> same value.

It's only necessary to use Duplicate in this case if Session.var is a
structure or a query. If it's just a simple value, you don't need to
worry -
simple values are always passed by value, not by reference.

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: Request Scope Questions

[gyrus]

> Bare in mind that CF 4.5 had a um, 'issue' with Duplicate. You can
> download a hotfix for it though.

What was the issue?! I've got several sites live that are relying
on Duplicate for passing session vars to request scope, and
I'm not sure if the hosts have all the latest patches.

- Gyrus


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

FW: Request Scope Questions

[Daniel Lancelot]

If this is the case, is there any disadvantage of doing duplicate rather than 
structcopy? - It would seem that duplicate would
always work...

-Original Message-
From: Christopher Olive [mailto:[EMAIL PROTECTED]]
Sent: 12 November 2001 15:21
To: CF-Talk
Subject: RE: Request Scope Questions


if i understand correctly, a week or so ago you (dave) mentioned that
duplicate was only necessary for a session structure if it contained
other complex variables.  you said that StructCopy was sufficient if it
was merely a structure with simple variables.  is this correct?

christopher olive, cto, vp of web development
cresco technologies, inc
410.825.0383
http://www.crescotech.com


-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Sunday, November 11, 2001 5:00 PM
To: CF-Talk
Subject: RE: Request Scope Questions


> A couple of notes here: if you do this, use something like
>
> 
>
> to transfer the variable. If you don't use Duplicate() - correct
> me if I'm wrong someone! - then request.var just becomes a 'pointer'
> to session.var, and session.var is still actually read when you
> refer later to request.var (rendering the whole business kind of
> redundant!). Duplicate() - which is only available in CF4.5+ -
> makes request.var a 'deep' copy of session.var, and then request.var
> technically has nothing to do with session.var except having the
> same value.

It's only necessary to use Duplicate in this case if Session.var is a
structure or a query. If it's just a simple value, you don't need to
worry -
simple values are always passed by value, not by reference.

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



~~
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: Request Scope Questions

[Raymond Camden]

I don't know if Dave said that or not, but the statement is correct. In
general, I just always use Duplicate. Perhaps structcopy is 0.001%
faster, but to be honest, I'd rather just use Duplicate() which I know
will always work right.


Bare in mind that CF 4.5 had a um, 'issue' with Duplicate. You can
download a hotfix for it though.

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

Email: [EMAIL PROTECTED]
Yahoo IM : morpheus

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

> -Original Message-
> From: Christopher Olive [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, November 12, 2001 10:21 AM
> To: CF-Talk
> Subject: RE: Request Scope Questions
> 
> 
> if i understand correctly, a week or so ago you (dave) mentioned that
> duplicate was only necessary for a session structure if it contained
> other complex variables.  you said that StructCopy was 
> sufficient if it
> was merely a structure with simple variables.  is this correct?
> 
> christopher olive, cto, vp of web development
> cresco technologies, inc
> 410.825.0383
> http://www.crescotech.com
> 
> 
> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, November 11, 2001 5:00 PM
> To: CF-Talk
> Subject: RE: Request Scope Questions
> 
> 
> > A couple of notes here: if you do this, use something like
> > 
> > 
> > 
> > to transfer the variable. If you don't use Duplicate() - correct 
> > me if I'm wrong someone! - then request.var just becomes a 
> 'pointer' 
> > to session.var, and session.var is still actually read when you 
> > refer later to request.var (rendering the whole business kind of 
> > redundant!). Duplicate() - which is only available in CF4.5+ -
> > makes request.var a 'deep' copy of session.var, and then 
> request.var 
> > technically has nothing to do with session.var except having the 
> > same value.
> 
> It's only necessary to use Duplicate in this case if Session.var is a
> structure or a query. If it's just a simple value, you don't need to
> worry -
> simple values are always passed by value, not by reference.
> 
> 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: Request Scope Questions

[Christopher Olive]

if i understand correctly, a week or so ago you (dave) mentioned that
duplicate was only necessary for a session structure if it contained
other complex variables.  you said that StructCopy was sufficient if it
was merely a structure with simple variables.  is this correct?

christopher olive, cto, vp of web development
cresco technologies, inc
410.825.0383
http://www.crescotech.com


-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Sunday, November 11, 2001 5:00 PM
To: CF-Talk
Subject: RE: Request Scope Questions


> A couple of notes here: if you do this, use something like
> 
> 
> 
> to transfer the variable. If you don't use Duplicate() - correct 
> me if I'm wrong someone! - then request.var just becomes a 'pointer' 
> to session.var, and session.var is still actually read when you 
> refer later to request.var (rendering the whole business kind of 
> redundant!). Duplicate() - which is only available in CF4.5+ -
> makes request.var a 'deep' copy of session.var, and then request.var 
> technically has nothing to do with session.var except having the 
> same value.

It's only necessary to use Duplicate in this case if Session.var is a
structure or a query. If it's just a simple value, you don't need to
worry -
simple values are always passed by value, not by reference.

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

~~
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: i don't understand cflock? can you explain it?

[gyrus]

> if i am not using application variables, just calling data sources for
drop
> down list
> as well as calling data source for update pages, should i use cflock?

Check the thread titled 'Request Scope Options', only a little way
from the top of the http://www.houseoffusion.com CF-Talk archive
(thread ran over last few days). Mostly concerned with the request
scope, but there were some summaries of CFLOCK, and pointers to
good online articles.

hth,

- Gyrus


~~
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: i don't understand cflock? can you explain it?

[Beau Harbin]

Paul,

The simple rule of thumb is that if you are using
application, session or server variables then you need to 
lock them on reads and writes.  Meaning if you have a variable
called Application.DSN, then you need to lock it when you
write it and also lock it when you read it.

If your application does not use application, session or server
variables, then you don't have to worry about it.

See Nate Weiss' talk at DevCon on locking for more information:
http://www.nateweiss.com

Good luck,
Beau


-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 9:25 AM
To: CF-Talk
Subject: i don't understand cflock? can you explain it?


in  the WACK 4.0 & AID book's there is only a 1/2 page or so related to
it.
in mastering cf 4.0 there are a few pages about it, that i really don't
understand.

if i am not using application variables, just calling data sources for
drop
down list
as well as calling data source for update pages, should i use cflock?

you know just your standard generic forms, which is about 80% of my
daily
work here.

how can i get a good grasp of  WHY to use them?

Thanks in advance.
any advice would be great!


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

i don't understand cflock? can you explain it?

[Paul Ihrig]

in  the WACK 4.0 & AID book's there is only a 1/2 page or so related to it.
in mastering cf 4.0 there are a few pages about it, that i really don't
understand.

if i am not using application variables, just calling data sources for drop
down list
as well as calling data source for update pages, should i use cflock?

you know just your standard generic forms, which is about 80% of my daily
work here.

how can i get a good grasp of  WHY to use them?

Thanks in advance.
any advice would be great!

~~
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: Multiple case statements in SCRIPT

[Philip Arnold - ASP]

> ColdFusion throws a wobbly on this (and the other variations I've tried
>
> switch (Attributes.PeriodID) {
>case (1,2,3) {
>   ...
>}
>case 4 {
>}
> }
>
> Is there any way to provide multiple values?

Of course

switch (Attributes.PeriodID)
{   case "1":
case "2":
case "3":
{   do stuff;
break;
}
case "4":
{   do other stuff;
}
}

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

"Websites for the real world"

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


~~
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: %$#@^&%$& CFSETTING

[Carlisle, Eric]

   
WriteOutPut("Hello");


HA!  That did it!
Many thanks!  That was a great timesaver for me. :)

EC

-Original Message-
From: Steve Martin [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 7:50 AM
To: CF-Talk
Subject: RE: %$#@^&%$& CFSETTING


Do you have "Suppress whitespace by default" checked in the CF admin? If so
then you'll always end up with a leading space as it would appear to
compress runs of zero (yes, zero) or more whitespace characters to a space.
Had me pulling my hair out for a while once.

Steve

-Original Message-
From: Carlisle, Eric [mailto:[EMAIL PROTECTED]]
Sent: 12 November 2001 12:27
To: CF-Talk
Subject: RE: %$#@^&%$& CFSETTING


I put a  directly after it.
It still inserted the space.
I'll play around with it with different amount of code on that line.

Thanks :)

EC

-Original Message-
From: BILLY CRAVENS [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 09, 2001 5:02 PM
To: CF-Talk
Subject: Re: %$#@^&%$& CFSETTING


No, just remove the carriage return after cfsetting.



- Original Message -
From: "Carlisle, Eric" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, November 09, 2001 3:50 PM
Subject: %$#@^&%$& CFSETTING


> I'm using a CF script to talk to a Flash SWF.  The flash movie needs an
> output like a query string
>
> ?var1=abc&var2=123&var3=def
>
> The very first in this script is...
> 
> to supress any whitespace that is problematic in Flash.
>
> The problem is that the first carraige return after  causes a
> space to be placed into the output.  This can mess up communication with
the
> Flash movie.
> Do I have to write this entire %$#@^&%$& script on one line?
>
> Eric Carlisle
> Web Site Developer
> Progress Energy IT Systems Delivery
> E-mail: [EMAIL PROTECTED]
> Phone: (919) 546-4739
>



~~
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: Multiple case statements in SCRIPT

[Stephen Moretti]

Aidan,

> ColdFusion throws a wobbly on this (and the other variations I've tried
>
> switch (Attributes.PeriodID) {
>case (1,2,3) {
>   ...
>}

You need a break; in the end of each case.  That'll break out of the switch
when one of the cases are met and carry on with the next lot of code.

Regards

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: %$#@^&%$& CFSETTING

[Steve Martin]

Do you have "Suppress whitespace by default" checked in the CF admin? If so
then you'll always end up with a leading space as it would appear to
compress runs of zero (yes, zero) or more whitespace characters to a space.
Had me pulling my hair out for a while once.

Steve

-Original Message-
From: Carlisle, Eric [mailto:[EMAIL PROTECTED]]
Sent: 12 November 2001 12:27
To: CF-Talk
Subject: RE: %$#@^&%$& CFSETTING


I put a  directly after it.
It still inserted the space.
I'll play around with it with different amount of code on that line.

Thanks :)

EC

-Original Message-
From: BILLY CRAVENS [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 09, 2001 5:02 PM
To: CF-Talk
Subject: Re: %$#@^&%$& CFSETTING


No, just remove the carriage return after cfsetting.



- Original Message -
From: "Carlisle, Eric" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, November 09, 2001 3:50 PM
Subject: %$#@^&%$& CFSETTING


> I'm using a CF script to talk to a Flash SWF.  The flash movie needs an
> output like a query string
>
> ?var1=abc&var2=123&var3=def
>
> The very first in this script is...
> 
> to supress any whitespace that is problematic in Flash.
>
> The problem is that the first carraige return after  causes a
> space to be placed into the output.  This can mess up communication with
the
> Flash movie.
> Do I have to write this entire %$#@^&%$& script on one line?
>
> Eric Carlisle
> Web Site Developer
> Progress Energy IT Systems Delivery
> E-mail: [EMAIL PROTECTED]
> Phone: (919) 546-4739
>


~~
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: %$#@^&%$& CFSETTING

[Carlisle, Eric]

No, no application.cfm in use.  Good idea, though. :)
I'll try to mess around with it today and ask again if I'm certain I
couldn't get it to work otherwise (saves time all around).  Just wondered if
that was a problem that sounded familiar.

Thanks :)

EC

-Original Message-
From: Michiel Boland [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 7:47 AM
To: CF-Talk
Subject: RE: %$#@^&%$& CFSETTING


[blank line in output even after cfsetting]

You don't happen to have an Application.cfm that is included somewhere?
That may also add to initial whitespace.

~~
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: Multiple case statements in SCRIPT

[Clint Tredway]

you can nest case statments inside each other.

Clint

-- Original Message --
from: Aidan Whitehall <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Mon, 12 Nov 2001 12:51:31 -

ColdFusion throws a wobbly on this (and the other variations I've tried

switch (Attributes.PeriodID) {
   case (1,2,3) {
  ...
   }
   case 4 {
   }
}

Is there any way to provide multiple values?



Thanks.

-- 
Aidan Whitehall <[EMAIL PROTECTED]>
Macromedia ColdFusion Developer
Fairbanks Environmental +44 (0)1695 51775



~~
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: Database help needed please

[Bud]

On 11/11/01, Douglas L. Brown penned:
>I am kinda new to SQL and such and have the following question
>
>I have a table called (customer) which has a custNum column and is a PK
>it has a FK relationship to a table called cust_contacts and a column of
>custNum. when a user creates an account I generate a custNum and
>populate the cust_contacts table but I get a key constraint error
>because this table is a FK and not the PK..Should the table that holds
>the login information be the PK table?

The customer table must be populated first. Two ways to go about 
generating the custNum.

1. Identity field (SQL, Autnumber in Access) for custNum in customer. 
Insert new customer then grab the max(custNum) and insert it into the 
cust_contacts table along with any other info that goes in there.

2. Integer field for custNum in customer. You'll need to get the 
max(custNum) BEFORE inserting the record, add 1 and insert the new 
record with that value. Then insert the same new number into 
cust_contacts.

You should wrap either of these with a cftransaction to assure that 
the proper max(custNum) is written to the correct cust_contacts 
record in case two users are signing up simultaneously.
-- 

Bud Schneehagen - Tropical Web Creations

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

Multiple case statements in SCRIPT

[Aidan Whitehall]

ColdFusion throws a wobbly on this (and the other variations I've tried

switch (Attributes.PeriodID) {
   case (1,2,3) {
  ...
   }
   case 4 {
   }
}

Is there any way to provide multiple values?



Thanks.

-- 
Aidan Whitehall <[EMAIL PROTECTED]>
Macromedia ColdFusion Developer
Fairbanks Environmental +44 (0)1695 51775


~~
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: %$#@^&%$& CFSETTING

[Michiel Boland]

[blank line in output even after cfsetting]

You don't happen to have an Application.cfm that is included somewhere?
That may also add to initial whitespace.
~~
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: %$#@^&%$& CFSETTING

[Carlisle, Eric]

I put a  directly after it.
It still inserted the space.
I'll play around with it with different amount of code on that line.

Thanks :)

EC

-Original Message-
From: BILLY CRAVENS [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 09, 2001 5:02 PM
To: CF-Talk
Subject: Re: %$#@^&%$& CFSETTING


No, just remove the carriage return after cfsetting.



- Original Message -
From: "Carlisle, Eric" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, November 09, 2001 3:50 PM
Subject: %$#@^&%$& CFSETTING


> I'm using a CF script to talk to a Flash SWF.  The flash movie needs an
> output like a query string
>
> ?var1=abc&var2=123&var3=def
>
> The very first in this script is...
> 
> to supress any whitespace that is problematic in Flash.
>
> The problem is that the first carraige return after  causes a
> space to be placed into the output.  This can mess up communication with
the
> Flash movie.
> Do I have to write this entire %$#@^&%$& script on one line?
>
> Eric Carlisle
> Web Site Developer
> Progress Energy IT Systems Delivery
> E-mail: [EMAIL PROTECTED]
> Phone: (919) 546-4739
> 

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