Re: SELECT MAX(ID), Access & SQL Server - confused!

[Matt Robertson]

>i chose not to use mysql more for their attitudes about the ...
>missing "luxury" items (triggers, sp, transaction granularity, etc.,
>i guess they're singing another song now.

I hear that.  Nothing for triggers yet, unfortunately.  It won't be an
enterprise-level product for a long time, I think.  I'm there purely for
budgetary reasons, although I see some good deals on ebay, and my ISP is
offering SQL 2000 for $1455.  Thats not too bad.

Cheers,

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

Ben on Caching Queries

[Andrew Scott]

Ben,

Just wanted to say that I read this article on your site, and wish to
add one thing that I do that can help manage the cached queries.

I started to create some complex custom tags, and when I started to add
the caching of queries I discovered I also needed a way to make the data
appear to change. The solution was to allow the system that
changed/inserted the query, to change a variable that the cfquery used
to cache the query. For those queries that don't change much this does
make a huge difference in speed, as indicated by Ben's article.



~~
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: SELECT MAX(ID), Access & SQL Server - confused!

[Paul Hastings]

> I wouldn't know either way, as I don't use SQL server.  As I said, I've
heard the argument.  Nothing more.

scandalous behavior in repeating it ;-)

> You know dbs inside and out, Paul.  What is your opinion of the best way
to accomplish the task, if you're stuck with something like Access or mySQL?
What do you think of the CF_max_ID tag the original poster was mentioning?

i wouldn't say that i know dbs "inside & out", i know something about
sql server because thats what i chose to use (best bang for the buck
with the fewest management headaches in my market). i chose not to
use access for reasons you've heard me spout on enough about in the
cf forums. i chose not to use mysql more for their attitudes about the
missing "luxury" items (triggers, sp, transaction granularity, etc., we
didn't build them into mysql, therefore you don't need them, blah blah
blah) than for the fact these things were missing--though not having these
tools is still fatal to me. i guess they're singing another song now.

if you can live w/2 queries:
insert into autonumber table.
re-query for that row, returning autonumber.
if nothing in that row but the autonumber makes it
unique, than *add* (not replace) in a column to hold
a UUID (which you'd build in cf prior to inserting) and
query for that. keep the int autonumber for JOINs.

if you can live with more than 2 queries (though the 1st 2 should
be short & sharp):
use a key table to manage these IDs.
i suppose if you were clever enough you could load this into
an application/server scope structure & periodically refresh
the physical tableprovided no non-cf processes hit that
table.


~~
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: Rounding a value UP

[Benjamin Falloon]

   thanks Jared and Joseph !
Exactly what I was after...

Benajamin


- Original Message -
From: "Jared Clinton" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, November 27, 2001 4:11 PM
Subject: RE: Rounding a value UP


> From the documentation:
>
> --
> 
> 
> Ceiling Example
> 
>
> 
> Ceiling Example
>
> 
> The ceiling of 3.4 is #ceiling(3.4)#
> The ceiling of 3 is #ceiling(3)#
> The ceiling of 3.8 is #ceiling(3.8)#
> The ceiling of -4.2 is #ceiling(-4.2)#
> 
>
> 
> 
> 
>
>
> Does this help?
>
> Jared Clinton.
>
> -Original Message-
> From: Benjamin Falloon [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, 27 November 2001 1:56 PM
> To: CF-Talk
> Subject: Rounding a value UP
>
>
> Hi all,
>
> Who knows the function for rounding UP to the nearest number?
> Eg. If I have the number 2.33 etc, what's the CF syntax for rounding
> this number UP to 3 (instead of  down to 2)?
>
> Thanks in advance,
>
> Benjamin Falloon
>
> 
~~
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: SELECT MAX(ID), Access & SQL Server - confused!

[Matt Robertson]

>> trigger or the @@identity value (which I have heard argued 
>> here is also vulnerable to the same problem as is the MAX 
>> method, for much the same reasons).  

> utter nonsense.

I wouldn't know either way, as I don't use SQL server.  As I said, I've heard the 
argument.  Nothing more.

You know dbs inside and out, Paul.  What is your opinion of the best way to accomplish 
the task, if you're stuck with something like Access or mySQL?  What do you think of 
the CF_max_ID tag the original poster was mentioning?

---
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: SELECT MAX(ID), Access & SQL Server - confused!

[Douglas L. Brown]

bottom line is that it is a pain in the keester to make a DB portable with
identity fields as a PK

If you visit http://www.fusebox.org/index.cfm?fuseaction=learn.gallery there
is a nice little custom tag for using max(ID) instead of identity also.


Doug
- Original Message -
From: "Gyrus" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 26, 2001 6:10 PM
Subject: Re: SELECT MAX(ID), Access & SQL Server - confused!


> Thanks for all the feedback everyone - but I've still
> some lingering questions...
>
> > In SQL Server, it's called an IDENTITY column. It's basically the same
> > thing. Most database systems have some way to create a surrogate key - a
> key
> > which is created by the database, rather than drawn from the actual
data.
>
> A developer who handled converting my Access DB to
> SQL Server for a client told me I had to rewrite all my
> INSERT queries to use SELECT MAX(ID), because there
> was no equivalent to AUTONUMBER in SQL Server. Eh?
>
> My problem is, I want to create an Access-based app
> template where the SQL code is as portable as possible
> between DB systems - specifically, Access and SQL
> Server.
>
> Why not carry on using AUTONUMBER, and convert
> that field to IDENTITY if upsizing? Why bother having a
> slightly risky 2-step transaction (or slightly performance-
> hurting transaction if isolation="serializable") for Access,
> only to have to switch all this to a stored procedure or
> trigger when upsizing to SQL Server?
>
> Why do Fusebox advise using the MAX_ID tag for and the
> 2-step INSERT for "portability" reasons - is this only when
> converting to non-MS stuff like Oracle or Sybase? Steve's
> documentation for the tag says:
>
> "Because autonumber datatypes are not easily transferable
> from database to database."
>
> Does this count for Access > SQL Server (i.e. AUTONUMBER
> > IDENTITY)? I've not upsized Access > SQL Server before.
> Maybe I should give it a go before I finalise this template
> code, but I thought I'd check with some people who have
> probably struggled with this a while ago ;)
>
> - 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: Raduis Authentication

[Lewis Sellers]

On Mon, 26 Nov 2001 17:08:47 -0500 (EST), <[EMAIL PROTECTED]> wrote:

>I am trying to use CF to authenticate users with their Username and
>password from the radius server on the Unix side of the network on an
>Win2K/IIS/CF 5 server. I tried the cfx_radauth tag without success. The
>sys admin watched the request and said that the username was not being
>sent. In this initial testing phase I hardcoded in a valid username and
>password as a "proof of concept" so there isn't any chance that a variable
>is not evaluating properly. The tag does make a request to the radius
>server but just doesn't seem to be passing the right data along. Is there
>something I could be doing wrong? Is there a better tag out there (I tried
>the java one, even though it says it has only been tested on linux, with
>no success)? Any help would be much appreciated.

To clear this up, you're wanting something that works on Windows or
Linux? Linux right?

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

CFFILE Upload less than 4100 bytes

[Dian Oktosoma]

I have a problem with CFFILE when I am trying to upload a image file
with size less than 4100 bytes. It always become a zero-sized file. If I
try to output #File.FileSize# it will display '0' too.

~~
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: SELECT MAX(ID), Access & SQL Server - confused!

[Paul Hastings]

> trigger or the @@identity value (which I have heard argued 
> here is also vulnerable to the same problem as is the MAX 
> method, for much the same reasons).  

utter nonsense.

~~
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: Rounding a value UP

[Jared Clinton]

>From the documentation:

--


Ceiling Example



Ceiling Example


The ceiling of 3.4 is #ceiling(3.4)#
The ceiling of 3 is #ceiling(3)#
The ceiling of 3.8 is #ceiling(3.8)#
The ceiling of -4.2 is #ceiling(-4.2)#



   



Does this help?

Jared Clinton.

-Original Message-
From: Benjamin Falloon [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 27 November 2001 1:56 PM
To: CF-Talk
Subject: Rounding a value UP


Hi all,

Who knows the function for rounding UP to the nearest number?
Eg. If I have the number 2.33 etc, what's the CF syntax for rounding
this number UP to 3 (instead of  down to 2)?

Thanks in advance,

Benjamin Falloon

~~
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: Rounding a value UP

[Joseph DeVore]

The CF function you are looking for is
ceiling()

Joseph DeVore
VeloxWeb Technologies


-Original Message-
From: Benjamin Falloon [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 26, 2001 7:56 PM
To: CF-Talk
Subject: Rounding a value UP


Hi all,

Who knows the function for rounding UP to the nearest number?
Eg. If I have the number 2.33 etc, what's the CF syntax for rounding
this number UP to 3 (instead of  down to 2)?

Thanks in advance,

Benjamin Falloon

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

Rounding a value UP

[Benjamin Falloon]

Hi all,

Who knows the function for rounding UP to the nearest number?
Eg. If I have the number 2.33 etc, what's the CF syntax for rounding
this number UP to 3 (instead of  down to 2)?

Thanks in advance,

Benjamin Falloon
~~
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: SELECT MAX(ID), Access & SQL Server - confused!

[Matt Robertson]

> A developer who handled converting my Access DB to 
> SQL Server for a client told me I had to rewrite all my 
> INSERT queries to use SELECT MAX(ID), because there 
> was no equivalent to AUTONUMBER in SQL Server. Eh? 

H.  That sounds like a warning sign.  Identity is 
the SQL Server equivalent to autonumber in SQL Server.

> Why not carry on using AUTONUMBER, and convert 
> that field to IDENTITY if upsizing? 

Ordinarily I'd say that was what you should do (see below)
The trouble comes in when you have to pull the number out again,
with the proviso that you can't use a stored proc, a 
trigger or the @@identity value (which I have heard argued 
here is also vulnerable to the same problem as is the MAX 
method, for much the same reasons).  

>> Why do Fusebox advise using the MAX_ID tag for and the 
>> 2-step INSERT for "portability" reasons - is this only when 
>> converting to non-MS stuff like Oracle or Sybase? Steve's 
>> documentation for the tag says: 
>
> "Because autonumber datatypes are not easily transferable 
> from database to database." 

I downloaded that tag, and in the readme.txt there's an 
example routine in there that will retry submissions until it 
submits a record with a unique key value, thereby resolving 
the multiple user issue.  A very interesting idea.  
Like the author says, it does appear to be pretty slick, 
and if its as foolproof as presented would be a neat way to 
make a completely portable primary key value using a simple, 
universal integer datatype.

If you can't use stored procs, then maybe this tag, coupled to
that retry routine, *is* the best way to go.

---
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: SELECT MAX(ID), Access & SQL Server - confused!

[Gyrus]

Thanks for all the feedback everyone - but I've still
some lingering questions...

> In SQL Server, it's called an IDENTITY column. It's basically the same
> thing. Most database systems have some way to create a surrogate key - a
key
> which is created by the database, rather than drawn from the actual data.

A developer who handled converting my Access DB to
SQL Server for a client told me I had to rewrite all my
INSERT queries to use SELECT MAX(ID), because there
was no equivalent to AUTONUMBER in SQL Server. Eh?

My problem is, I want to create an Access-based app
template where the SQL code is as portable as possible
between DB systems - specifically, Access and SQL
Server.

Why not carry on using AUTONUMBER, and convert
that field to IDENTITY if upsizing? Why bother having a
slightly risky 2-step transaction (or slightly performance-
hurting transaction if isolation="serializable") for Access,
only to have to switch all this to a stored procedure or
trigger when upsizing to SQL Server?

Why do Fusebox advise using the MAX_ID tag for and the
2-step INSERT for "portability" reasons - is this only when
converting to non-MS stuff like Oracle or Sybase? Steve's
documentation for the tag says:

"Because autonumber datatypes are not easily transferable
from database to database."

Does this count for Access > SQL Server (i.e. AUTONUMBER
> IDENTITY)? I've not upsized Access > SQL Server before.
Maybe I should give it a go before I finalise this template
code, but I thought I'd check with some people who have
probably struggled with this a while ago ;)

- 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: Copying Structures Exam Question - is this right?

[James Sleeman]

At 11:45 AM 11/27/2001, you wrote:
> > my answer was 160, but according to the book, the answer is 120. I thought
> > (and it says in Forta's book) that a copy of a structure is just a pointer
> > to the original so that if you change the copy, you change the
> > original. Am
> > i missing something here? Can someone explain? Thanks for any help.
>
>You're right that copies of a struct created using the assignment operator
>are simply pointers but the structCopy() function makes a deep duplicate of
>the struct that is in its own memory space and is not just a pointer to the
>original struct.
>
>So in the example from the exam the two structs are different entities

Not quite correct, if you make a structure such as






(i.e a structure with nested structures) and do



then x will be copied by value to z, but x.y will be copied by reference to 
z.y, such that




produces the expected result...

x.name eq "Blah"
z.name eq "Foo"

but also the unexpected result...

x.y.name eq "Foo"
z.y.name eq "Foo"





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

~~
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: CF and credit card transactions

[Matt Robertson]

Thx for the tip.  I'm interested in using them on a software product I'm going to be 
selling, plus maybe I can use them to automate my recurring hosting bills.  I bill 
annually, but I want to move that to a recurring monthly to even out my cash flow and 
ease the bite on customers' wallets.

Back to your question:  My personal favorite is Verisign's Payflow Pro service, 
although you have to have a CFX installed on your server to get it running.  Someone 
just posted a new custom tag in the dev exchg thats supposed to make things easy to 
interface, but its not that tough to do, either way.  Authorize.net is maybe even 
easier to integrate.  I used cf_Authorizenet3, I think.  They can be a real pain to 
sign up with, though.  Wanted 2 years' personal and corporate tax returns from me when 
they heard I was an internet business.  I've heard similar stories from clients and 
other developers.  They're pretty conservative, which isn't a bad thing.

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


-- Original Message --
from: "Tangorre, Michael T." <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Mon, 26 Nov 2001 20:37:11 -0500

Yes,
I have used them with the guy I work with.. Probably on about 15 or so
sites... It not only works good, but it is nice for small volume commerce
sites.
I am trying to investigate others to see the pros and cons. Most of the
clients (upcoming) want seemless integration and do not wish their users to
leave the site then return and what not as seen with 2CheckOut. 

Mike


-Original Message-
From: Matt Robertson [mailto:[EMAIL PROTECTED]] 
Sent: Monday, November 26, 2001 8:35 PM
To: CF-Talk
Subject: Re: CF and credit card transactions


That 2CheckOut service actually looks pretty good for a very lite ecommerce
in-house project I have coming up.  Have you used these guys before?
Good/bad experience?

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


-- Original Message --
from: "Tangorre, Michael T." <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Mon, 26 Nov 2001 20:14:50 -0500

Hi Everyone,

I am looking for some insight for processing credit cards with Cold Fusion.
I am aware of a few custom tags, but what kind of variety is offered in
terms of companies and sites to do the processing. I am not really a fan of
going from my site, to another site then back to my site as you do with
2CheckOut..

Open for discussion and ideas.

Thanks,

Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4



~~
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: CFMODULE and odd display behavior

[Don Vawter]

replacenocase(red_face, "schmuck","just human after all","all")
- Original Message -
From: "Bryan Stevenson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 26, 2001 6:43 PM
Subject: Re: CFMODULE and odd display behavior


> Thanks again to Dave Watts at Fig Leaf...that did the tricknow the
find
> and replace begins ;-)
>
>  ;-)
>
> Bryan Stevenson
> VP & Director of E-Commerce Development
> Electric Edge Systems Group Inc.
> p. 250.920.8830
> e. [EMAIL PROTECTED]
> -
> Allaire Alliance Partner
> www.allaire.com
>
> - Original Message -
> From: "Dave Watts" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, November 26, 2001 4:32 PM
> Subject: RE: CFMODULE and odd display behavior
>
>
> > > Basically I've narrowed it down to an issue with CFMODULE
> > > because when I call the tags the good old fashioned way (from
> > > custom tags dir in cf server) then all is well.
> >
> > Are you doing something like this:
> >
> > 
> >
> > or this:
> >
> > 
> >
> > If so, that calls the custom tag twice. Within the custom tag itself,
you
> > can detect whether it's being called by the opening or the closing tag
by
> > looking to see whether the variable ThisTag.ExecutionMode is "start" or
> > "end".
> >
> > 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: CF and credit card transactions

[Tangorre, Michael T.]

Yes,
I have used them with the guy I work with.. Probably on about 15 or so
sites... It not only works good, but it is nice for small volume commerce
sites.
I am trying to investigate others to see the pros and cons. Most of the
clients (upcoming) want seemless integration and do not wish their users to
leave the site then return and what not as seen with 2CheckOut. 

Mike


-Original Message-
From: Matt Robertson [mailto:[EMAIL PROTECTED]] 
Sent: Monday, November 26, 2001 8:35 PM
To: CF-Talk
Subject: Re: CF and credit card transactions


That 2CheckOut service actually looks pretty good for a very lite ecommerce
in-house project I have coming up.  Have you used these guys before?
Good/bad experience?

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


-- Original Message --
from: "Tangorre, Michael T." <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Mon, 26 Nov 2001 20:14:50 -0500

Hi Everyone,

I am looking for some insight for processing credit cards with Cold Fusion.
I am aware of a few custom tags, but what kind of variety is offered in
terms of companies and sites to do the processing. I am not really a fan of
going from my site, to another site then back to my site as you do with
2CheckOut..

Open for discussion and ideas.

Thanks,

Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4


~~
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: CFMODULE and odd display behavior

[Bryan Stevenson]

Thanks again to Dave Watts at Fig Leaf...that did the tricknow the find
and replace begins ;-)

 ;-)

Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Allaire Alliance Partner
www.allaire.com

- Original Message -
From: "Dave Watts" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 26, 2001 4:32 PM
Subject: RE: CFMODULE and odd display behavior


> > Basically I've narrowed it down to an issue with CFMODULE
> > because when I call the tags the good old fashioned way (from
> > custom tags dir in cf server) then all is well.
>
> Are you doing something like this:
>
> 
>
> or this:
>
> 
>
> If so, that calls the custom tag twice. Within the custom tag itself, you
> can detect whether it's being called by the opening or the closing tag by
> looking to see whether the variable ThisTag.ExecutionMode is "start" or
> "end".
>
> 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: CF and credit card transactions

[Matt Robertson]

That 2CheckOut service actually looks pretty good for a very lite ecommerce in-house 
project I have coming up.  Have you used these guys before?  Good/bad experience?

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


-- Original Message --
from: "Tangorre, Michael T." <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Mon, 26 Nov 2001 20:14:50 -0500

Hi Everyone,

I am looking for some insight for processing credit cards with Cold Fusion.
I am aware of a few custom tags, but what kind of variety is offered in
terms of companies and sites to do the processing. I am not really a fan of
going from my site, to another site then back to my site as you do with
2CheckOut..

Open for discussion and ideas.

Thanks,

Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4

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

CF and credit card transactions

[Tangorre, Michael T.]

Hi Everyone,

I am looking for some insight for processing credit cards with Cold Fusion.
I am aware of a few custom tags, but what kind of variety is offered in
terms of companies and sites to do the processing. I am not really a fan of
going from my site, to another site then back to my site as you do with
2CheckOut..

Open for discussion and ideas.

Thanks,

Michael T. Tangorre


Resident Assistant - Brick
Web Applications Developer
A.U. Webteam Slave  :-)
AIM: CrazyFlash4
~~
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: SELECT MAX(ID), Access & SQL Server - confused!

[Adrian Cesana]

Hey that is some good info, Ive always locked the queries when doing that
(luckily not high traffic site), this leads me to another query Ive been
putting on the back burner.

Here is the working query, shortened for the example:

SELECT a.SalesMan,a.CustomerName,b.Entry_Comments,b.Entry_Date
FROM MyMaster a LEFT OUTER JOIN MyDetail b ON a.id = b.id WHERE blah ORDER
BY blah

This works fine and I get all my detail reocrds for each master.  Now I need
to be able to select only a single most recent b.Entry_Date.  MAX(b.Entry_D)
requires I group the entire query.  Whats a good way to accomlish this?

Thanks,Adrian
~~
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: SELECT MAX(ID), Access & SQL Server - confused!

[Rey Muradaz]

Having had to wrestle with this problem recently, I discovered that it's
actually possible (in CF 4.5x+) to perform more than one SQL procedure
inside a single CFQUERY.  Here's how I got the ID (using SQL Server 7/2000):



 SET NOCOUNT ON

 INSERT INTO test
 (
 testtext
 )
 VALUES
 (
 'testval'
 )

 SELECT  Rec_id = @@identity



You can then reference #testquery.Rec_id# in your code.  Note that 'SET
NOCOUNT ON' is *required*--if you don't put it in, the SELECT statement
won't fire.

There's an even more elegant variation of this (in a cf tag) described on
TeraTech's site: http://www.teratech.com/coldcuts/cutdetail.cfm?cutid=225.

Hope this helps!

All the best,
REM O-


-Original Message-
From: Matt Robertson [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 26, 2001 4:27 PM
To: CF-Talk
Subject: RE: SELECT MAX(ID), Access & SQL Server - confused!


Yeah, both the original poster and I are in the same boat.  No stored procs
or triggers.  Supposedly v4.1 of mySQL will finally get them.  Interesting
post (as usual) from Dave Watts.  I had no idea Access had what sounds like
a quasi-stored proc capability.

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


-- Original Message --
from: Costas Piliotis <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Mon, 26 Nov 2001 16:09:42 -0800

I guess if I read the WHOLE thread :-)

-Original Message-
From: Costas Piliotis
Sent: Monday, November 26, 2001 4:04 PM
To: CF-Talk
Subject: RE: SELECT MAX(ID), Access & SQL Server - confused!


If you want to know the ID of the last insterted record, there is a variable
called @@Identity.  Be careful that there aren't any triggers firing on that
table onto another with an identity field.

No need to get more complicated than that.  Using a stored procedure to do
your inserts and an out parameter will get that value:

CREATE PROCEDURE sp_InsertOne
@MyInValue int,
@MyOutValue int = null output
AS
INSERT INTO MyTable (myInvalue) VALUES(@MyInValue)
SET @MyOutValue = @@Identity
GO



-Original Message-
From: Matt Robertson [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 26, 2001 3:48 PM
To: CF-Talk
Subject: Re: SELECT MAX(ID), Access & SQL Server - confused!


No, Access doesn't support stored procs or triggers.

In SQL Server the analog for 'autonumber' is 'identity', which imho makes a
perfectly good primary key.

There's no real certainty that MAX is going to return *your* last inserted
ID.  It might be from another user's insert statement.  I think you can
choke the process down with a name-based cflock, but now you have a cflock
and a cftransaction block to go along with a query needed to determine the
last-inserted value.

If you don't have triggers/stored procs available to you, here's another way
to do the job:  First, when the db table is created include a text field
called UUID or something similar.  Then, in your insert operation do a

CFSET variables.myvalue=CreateUUID()

and insert variables.myvalue into the UUID field of the db.

Then, when you need the record next, select with a WHERE filter that looks
for the UUID value set in variables.myvalue.  *Then* you can grab the much
tidier ID field value for future use, if needed.

This gets the job done without a CFTRANSACTION, CFLOCK or an extra query to
determine the ID value.  Its cost is a db field and an (optional, really)
table index.

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


-- Original Message --
from: "Gyrus" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Mon, 26 Nov 2001 23:22:38 -

I'm majorly confused about Primary Keys and Access' 'Autonumber' data type.

I've always used 'Autonumber' as seemingly the best
and easiest way for unique ID's to be created for PK
fields in Access tables.

I was aware of some issue with the common SELECT
MAX(ID) SQL operation you end up doing to get the ID
of something you just inserted. I found this at

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

The guy seems to be responding to someone posting the
Fusebox technique of using SELECT MAX(ID) and
 as a universal method of creating
ID's for PKs, so that apps are portable between RDMS's.

He seems to think the problem he mentions only happens
on SQL Server 6.5/7, though. There was a response to
this at

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

Here it was advised to use stored procedures, "isolation
level" on , or an insert trigger.

Then I grab the Max_ID.cfm custom tag by Steve Nelson
from fusebox.org, which has a nice suggestion in the documentation, to use
an endless loop and  around the , to keep trying to
get the new ID *and* insert t

RE: AOLServer (was: CF/IIS/Windows security class)

[Dave Watts]

> What the heck is AOLServer?

"AOLserver is America Online's Open-Source web server. AOLserver is the
backbone of the largest and busiest production environments in the world.
AOLserver is a multithreaded, Tcl-enabled web server used for large scale,
dynamic web sites."

http://www.aolserver.com/

It's very good, from what I've heard. I've never used it, myself.

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: CFMODULE and odd display behavior

[Bryan Stevenson]

Ahhh Dave I think you may have something thereDOH!  I was using the
second method without testing for start and end.  I'll change it up and see
how she flys ;-)

Thanks

Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Allaire Alliance Partner
www.allaire.com

- Original Message -
From: "Dave Watts" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 26, 2001 4:32 PM
Subject: RE: CFMODULE and odd display behavior


> > Basically I've narrowed it down to an issue with CFMODULE
> > because when I call the tags the good old fashioned way (from
> > custom tags dir in cf server) then all is well.
>
> Are you doing something like this:
>
> 
>
> or this:
>
> 
>
> If so, that calls the custom tag twice. Within the custom tag itself, you
> can detect whether it's being called by the opening or the closing tag by
> looking to see whether the variable ThisTag.ExecutionMode is "start" or
> "end".
>
> 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: AOLServer (was: CF/IIS/Windows security class)

[Jay Sudowski - Handy Networks LLC]

What the heck is AOLServer?

-Jay
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]] 
Sent: Monday, November 26, 2001 6:53 PM
To: CF-Talk
Subject: RE: AOLServer (was: CF/IIS/Windows security class)


> PSS:  Although certain parts of allaire.com run faster now
> that Macromedia has taken over, the support section still is 
> slow and the KB returns articles that have little relevance to 
> what I type it. That said, I'm tired of waiting around for the 
> web site to actually tell me something useful. Anyone know if 
> CF will run on AOLServer?

It should run in CGI mode, with the crappy performance which that
entails. I don't think AOLServer supports any of the "standard" APIs
used by other web servers.

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

RE: CFMODULE and odd display behavior

[Dave Watts]

> Basically I've narrowed it down to an issue with CFMODULE 
> because when I call the tags the good old fashioned way (from 
> custom tags dir in cf server) then all is well.

Are you doing something like this:



or this:



If so, that calls the custom tag twice. Within the custom tag itself, you
can detect whether it's being called by the opening or the closing tag by
looking to see whether the variable ThisTag.ExecutionMode is "start" or
"end".

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: SELECT MAX(ID), Access & SQL Server - confused!

[Matt Robertson]

Yeah, both the original poster and I are in the same boat.  No stored procs or 
triggers.  Supposedly v4.1 of mySQL will finally get them.  Interesting post (as 
usual) from Dave Watts.  I had no idea Access had what sounds like a quasi-stored proc 
capability.

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


-- Original Message --
from: Costas Piliotis <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Mon, 26 Nov 2001 16:09:42 -0800

I guess if I read the WHOLE thread :-)

-Original Message-
From: Costas Piliotis 
Sent: Monday, November 26, 2001 4:04 PM
To: CF-Talk
Subject: RE: SELECT MAX(ID), Access & SQL Server - confused!


If you want to know the ID of the last insterted record, there is a variable
called @@Identity.  Be careful that there aren't any triggers firing on that
table onto another with an identity field.

No need to get more complicated than that.  Using a stored procedure to do
your inserts and an out parameter will get that value:

CREATE PROCEDURE sp_InsertOne
@MyInValue int,
@MyOutValue int = null output
AS
INSERT INTO MyTable (myInvalue) VALUES(@MyInValue)
SET @MyOutValue = @@Identity
GO



-Original Message-
From: Matt Robertson [mailto:[EMAIL PROTECTED]] 
Sent: Monday, November 26, 2001 3:48 PM
To: CF-Talk
Subject: Re: SELECT MAX(ID), Access & SQL Server - confused!


No, Access doesn't support stored procs or triggers.

In SQL Server the analog for 'autonumber' is 'identity', which imho makes a
perfectly good primary key.

There's no real certainty that MAX is going to return *your* last inserted
ID.  It might be from another user's insert statement.  I think you can
choke the process down with a name-based cflock, but now you have a cflock
and a cftransaction block to go along with a query needed to determine the
last-inserted value.

If you don't have triggers/stored procs available to you, here's another way
to do the job:  First, when the db table is created include a text field
called UUID or something similar.  Then, in your insert operation do a 

CFSET variables.myvalue=CreateUUID() 

and insert variables.myvalue into the UUID field of the db.  

Then, when you need the record next, select with a WHERE filter that looks
for the UUID value set in variables.myvalue.  *Then* you can grab the much
tidier ID field value for future use, if needed.

This gets the job done without a CFTRANSACTION, CFLOCK or an extra query to
determine the ID value.  Its cost is a db field and an (optional, really)
table index. 

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


-- Original Message --
from: "Gyrus" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Mon, 26 Nov 2001 23:22:38 -

I'm majorly confused about Primary Keys and Access' 'Autonumber' data type.

I've always used 'Autonumber' as seemingly the best
and easiest way for unique ID's to be created for PK
fields in Access tables.

I was aware of some issue with the common SELECT
MAX(ID) SQL operation you end up doing to get the ID
of something you just inserted. I found this at

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

The guy seems to be responding to someone posting the
Fusebox technique of using SELECT MAX(ID) and
 as a universal method of creating
ID's for PKs, so that apps are portable between RDMS's.

He seems to think the problem he mentions only happens
on SQL Server 6.5/7, though. There was a response to
this at

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

Here it was advised to use stored procedures, "isolation
level" on , or an insert trigger.

Then I grab the Max_ID.cfm custom tag by Steve Nelson
from fusebox.org, which has a nice suggestion in the documentation, to use
an endless loop and  around the , to keep trying to
get the new ID *and* insert the new record until it gets it right.

Questions:

- Am I right in thinking SQL Server doesn't have the
  'Autonumber' data type? Why not? Is there a grave
  disadvantage to it unless you're doing kid's stuff in
  Access?

- Is it cool to use the SELECT MAX(ID) with SQL Server
  2000 (i.e. do the 6.5/7 problems above not happen now)?

- If I put  around
  the SELECT MAX(ID) and INSERT queries (in whatever
  order), are there any hidden dangers? Does this prevent
  anything else from changing the table concerned until
  the new ID is calculated and the nice new record is
  INSERTed?

- You can't use stored procedures or triggers on Access,
  right?

I'm basically trying to get this process *right*, and trying
to construct app templates that will be easily portable
between different DB systems - so even though I'm still
mostly working with Access, I might drop the whole
'Autonumber' thing.

Any advice/tips greatly appreciated on 

Re: CFMODULE and odd display behavior

[Bryan Stevenson]

I could post the code, but I'd have to post about 10 tags worth plus where
I'm using it.

Basically I've narrowed it down to an issue with CFMODULE because when I
call the tags the good old fashioned way (from custom tags dir in cf server)
then all is well.

Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Allaire Alliance Partner
www.allaire.com

- Original Message -
From: "Tangorre, Michael T." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 26, 2001 3:57 PM
Subject: RE: CFMODULE and odd display behavior


> Could you post the code?
>
>
>
> -Original Message-
> From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 26, 2001 7:02 PM
> To: CF-Talk
> Subject: CFMODULE and odd display behavior
>
>
> Hey Folks,
>
> OK I found this bug/glitch quite a while agoposted it to some
> lists...never really got a decent resolution.
>
> So here we go again beacuse it's driving me up the wall ;-)
>
> I got tired of relying on hosting tech support to put custom tags in
> place, so I use CFMODULE instead.
>
> The Problem:
>
> I have many tags that do many things, but we'll go with a simple
> example.  A tag to take a phone number and format it based on
> length...not rocket science.  Now when I call the tag (using cfmodule)
> to format a phone number (input string...process...display) I will get
> the phone number displaying twice (once in the table where it should be
> and again at the bottom of the page).  Now if I loop over a bunch of
> records and use the tag for each record all is well.  So my solution up
> till now when displaying a single record is to wrap the cfmodule call in
> a cfloop from 1 to 1 which makes the extra output vanish.
>
> Well I'm starting to find other odd display things that cfmodule seems
> to be doing...so it's time to nail this puppy once and for all.
>
> Any thoughts? experiences? comments?
>
> TIA
>
> Bryan Stevenson
> VP & Director of E-Commerce Development
> Electric Edge Systems Group Inc.
> p. 250.920.8830
> e. [EMAIL PROTECTED]
> -
> Allaire Alliance Partner
> www.allaire.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: CFMODULE and odd display behavior

[Bryan Stevenson]

in this particular tag it's the :caller" scope.  That said it does the same
thing with ALL cfmodule calls that display something (i.e. a link).

Yes I've checked for duplicate tags...the answer is no.

Single use of tag outside of a cfloop = dual display
Multiple use of tag inside a cfloop = fine and dandy
Single use inside a  cfloop = fine and dandy except I have to use the loop =
ggghhh

Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Allaire Alliance Partner
www.allaire.com

- Original Message -
From: "Won Lee" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 26, 2001 4:02 PM
Subject: RE: CFMODULE and odd display behavior


> waht scopoe do you set the formated string in?
> do you have output twice?
> Seeing the code would really help.
>
> -Original Message-
> From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 26, 2001 7:02 PM
> To: CF-Talk
> Subject: CFMODULE and odd display behavior
>
>
> Hey Folks,
>
> OK I found this bug/glitch quite a while agoposted it to some
> lists...never really got a decent resolution.
>
> So here we go again beacuse it's driving me up the wall ;-)
>
> I got tired of relying on hosting tech support to put custom tags in
> place, so I use CFMODULE instead.
>
> The Problem:
>
> I have many tags that do many things, but we'll go with a simple
> example.  A tag to take a phone number and format it based on
> length...not rocket science.  Now when I call the tag (using cfmodule)
> to format a phone number (input string...process...display) I will get
> the phone number displaying twice (once in the table where it should be
> and again at the bottom of the page).  Now if I loop over a bunch of
> records and use the tag for each record all is well.  So my solution up
> till now when displaying a single record is to wrap the cfmodule call in
> a cfloop from 1 to 1 which makes the extra output vanish.
>
> Well I'm starting to find other odd display things that cfmodule seems
> to be doing...so it's time to nail this puppy once and for all.
>
> Any thoughts? experiences? comments?
>
> TIA
>
> Bryan Stevenson
> VP & Director of E-Commerce Development
> Electric Edge Systems Group Inc.
> p. 250.920.8830
> e. [EMAIL PROTECTED]
> -
> Allaire Alliance Partner
> www.allaire.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: SELECT MAX(ID), Access & SQL Server - confused!

[Costas Piliotis]

I guess if I read the WHOLE thread :-)

-Original Message-
From: Costas Piliotis 
Sent: Monday, November 26, 2001 4:04 PM
To: CF-Talk
Subject: RE: SELECT MAX(ID), Access & SQL Server - confused!


If you want to know the ID of the last insterted record, there is a variable
called @@Identity.  Be careful that there aren't any triggers firing on that
table onto another with an identity field.

No need to get more complicated than that.  Using a stored procedure to do
your inserts and an out parameter will get that value:

CREATE PROCEDURE sp_InsertOne
@MyInValue int,
@MyOutValue int = null output
AS
INSERT INTO MyTable (myInvalue) VALUES(@MyInValue)
SET @MyOutValue = @@Identity
GO



-Original Message-
From: Matt Robertson [mailto:[EMAIL PROTECTED]] 
Sent: Monday, November 26, 2001 3:48 PM
To: CF-Talk
Subject: Re: SELECT MAX(ID), Access & SQL Server - confused!


No, Access doesn't support stored procs or triggers.

In SQL Server the analog for 'autonumber' is 'identity', which imho makes a
perfectly good primary key.

There's no real certainty that MAX is going to return *your* last inserted
ID.  It might be from another user's insert statement.  I think you can
choke the process down with a name-based cflock, but now you have a cflock
and a cftransaction block to go along with a query needed to determine the
last-inserted value.

If you don't have triggers/stored procs available to you, here's another way
to do the job:  First, when the db table is created include a text field
called UUID or something similar.  Then, in your insert operation do a 

CFSET variables.myvalue=CreateUUID() 

and insert variables.myvalue into the UUID field of the db.  

Then, when you need the record next, select with a WHERE filter that looks
for the UUID value set in variables.myvalue.  *Then* you can grab the much
tidier ID field value for future use, if needed.

This gets the job done without a CFTRANSACTION, CFLOCK or an extra query to
determine the ID value.  Its cost is a db field and an (optional, really)
table index. 

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


-- Original Message --
from: "Gyrus" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Mon, 26 Nov 2001 23:22:38 -

I'm majorly confused about Primary Keys and Access' 'Autonumber' data type.

I've always used 'Autonumber' as seemingly the best
and easiest way for unique ID's to be created for PK
fields in Access tables.

I was aware of some issue with the common SELECT
MAX(ID) SQL operation you end up doing to get the ID
of something you just inserted. I found this at

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

The guy seems to be responding to someone posting the
Fusebox technique of using SELECT MAX(ID) and
 as a universal method of creating
ID's for PKs, so that apps are portable between RDMS's.

He seems to think the problem he mentions only happens
on SQL Server 6.5/7, though. There was a response to
this at

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

Here it was advised to use stored procedures, "isolation
level" on , or an insert trigger.

Then I grab the Max_ID.cfm custom tag by Steve Nelson
from fusebox.org, which has a nice suggestion in the documentation, to use
an endless loop and  around the , to keep trying to
get the new ID *and* insert the new record until it gets it right.

Questions:

- Am I right in thinking SQL Server doesn't have the
  'Autonumber' data type? Why not? Is there a grave
  disadvantage to it unless you're doing kid's stuff in
  Access?

- Is it cool to use the SELECT MAX(ID) with SQL Server
  2000 (i.e. do the 6.5/7 problems above not happen now)?

- If I put  around
  the SELECT MAX(ID) and INSERT queries (in whatever
  order), are there any hidden dangers? Does this prevent
  anything else from changing the table concerned until
  the new ID is calculated and the nice new record is
  INSERTed?

- You can't use stored procedures or triggers on Access,
  right?

I'm basically trying to get this process *right*, and trying
to construct app templates that will be easily portable
between different DB systems - so even though I'm still
mostly working with Access, I might drop the whole
'Autonumber' thing.

Any advice/tips greatly appreciated on this!

- Gyrus





~~
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: SELECT MAX(ID), Access & SQL Server - confused!

[Costas Piliotis]

If you want to know the ID of the last insterted record, there is a variable
called @@Identity.  Be careful that there aren't any triggers firing on that
table onto another with an identity field.

No need to get more complicated than that.  Using a stored procedure to do
your inserts and an out parameter will get that value:

CREATE PROCEDURE sp_InsertOne
@MyInValue int,
@MyOutValue int = null output
AS
INSERT INTO MyTable (myInvalue) VALUES(@MyInValue)
SET @MyOutValue = @@Identity
GO



-Original Message-
From: Matt Robertson [mailto:[EMAIL PROTECTED]] 
Sent: Monday, November 26, 2001 3:48 PM
To: CF-Talk
Subject: Re: SELECT MAX(ID), Access & SQL Server - confused!


No, Access doesn't support stored procs or triggers.

In SQL Server the analog for 'autonumber' is 'identity', which imho makes a
perfectly good primary key.

There's no real certainty that MAX is going to return *your* last inserted
ID.  It might be from another user's insert statement.  I think you can
choke the process down with a name-based cflock, but now you have a cflock
and a cftransaction block to go along with a query needed to determine the
last-inserted value.

If you don't have triggers/stored procs available to you, here's another way
to do the job:  First, when the db table is created include a text field
called UUID or something similar.  Then, in your insert operation do a 

CFSET variables.myvalue=CreateUUID() 

and insert variables.myvalue into the UUID field of the db.  

Then, when you need the record next, select with a WHERE filter that looks
for the UUID value set in variables.myvalue.  *Then* you can grab the much
tidier ID field value for future use, if needed.

This gets the job done without a CFTRANSACTION, CFLOCK or an extra query to
determine the ID value.  Its cost is a db field and an (optional, really)
table index. 

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


-- Original Message --
from: "Gyrus" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Mon, 26 Nov 2001 23:22:38 -

I'm majorly confused about Primary Keys and Access' 'Autonumber' data type.

I've always used 'Autonumber' as seemingly the best
and easiest way for unique ID's to be created for PK
fields in Access tables.

I was aware of some issue with the common SELECT
MAX(ID) SQL operation you end up doing to get the ID
of something you just inserted. I found this at

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

The guy seems to be responding to someone posting the
Fusebox technique of using SELECT MAX(ID) and
 as a universal method of creating
ID's for PKs, so that apps are portable between RDMS's.

He seems to think the problem he mentions only happens
on SQL Server 6.5/7, though. There was a response to
this at

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

Here it was advised to use stored procedures, "isolation
level" on , or an insert trigger.

Then I grab the Max_ID.cfm custom tag by Steve Nelson
from fusebox.org, which has a nice suggestion in the documentation, to use
an endless loop and  around the , to keep trying to
get the new ID *and* insert the new record until it gets it right.

Questions:

- Am I right in thinking SQL Server doesn't have the
  'Autonumber' data type? Why not? Is there a grave
  disadvantage to it unless you're doing kid's stuff in
  Access?

- Is it cool to use the SELECT MAX(ID) with SQL Server
  2000 (i.e. do the 6.5/7 problems above not happen now)?

- If I put  around
  the SELECT MAX(ID) and INSERT queries (in whatever
  order), are there any hidden dangers? Does this prevent
  anything else from changing the table concerned until
  the new ID is calculated and the nice new record is
  INSERTed?

- You can't use stored procedures or triggers on Access,
  right?

I'm basically trying to get this process *right*, and trying
to construct app templates that will be easily portable
between different DB systems - so even though I'm still
mostly working with Access, I might drop the whole
'Autonumber' thing.

Any advice/tips greatly appreciated on this!

- Gyrus




~~
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: CFMODULE and odd display behavior

[Tangorre, Michael T.]

Could you post the code?



-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] 
Sent: Monday, November 26, 2001 7:02 PM
To: CF-Talk
Subject: CFMODULE and odd display behavior


Hey Folks,

OK I found this bug/glitch quite a while agoposted it to some 
lists...never really got a decent resolution.

So here we go again beacuse it's driving me up the wall ;-)

I got tired of relying on hosting tech support to put custom tags in 
place, so I use CFMODULE instead.

The Problem:

I have many tags that do many things, but we'll go with a simple 
example.  A tag to take a phone number and format it based on 
length...not rocket science.  Now when I call the tag (using cfmodule) 
to format a phone number (input string...process...display) I will get 
the phone number displaying twice (once in the table where it should be 
and again at the bottom of the page).  Now if I loop over a bunch of 
records and use the tag for each record all is well.  So my solution up 
till now when displaying a single record is to wrap the cfmodule call in 
a cfloop from 1 to 1 which makes the extra output vanish.

Well I'm starting to find other odd display things that cfmodule seems 
to be doing...so it's time to nail this puppy once and for all.

Any thoughts? experiences? comments?

TIA

Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Allaire Alliance Partner
www.allaire.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: CFMODULE and odd display behavior

[Won Lee]

waht scopoe do you set the formated string in?
do you have output twice?
Seeing the code would really help.

-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 26, 2001 7:02 PM
To: CF-Talk
Subject: CFMODULE and odd display behavior


Hey Folks,

OK I found this bug/glitch quite a while agoposted it to some
lists...never really got a decent resolution.

So here we go again beacuse it's driving me up the wall ;-)

I got tired of relying on hosting tech support to put custom tags in
place, so I use CFMODULE instead.

The Problem:

I have many tags that do many things, but we'll go with a simple
example.  A tag to take a phone number and format it based on
length...not rocket science.  Now when I call the tag (using cfmodule)
to format a phone number (input string...process...display) I will get
the phone number displaying twice (once in the table where it should be
and again at the bottom of the page).  Now if I loop over a bunch of
records and use the tag for each record all is well.  So my solution up
till now when displaying a single record is to wrap the cfmodule call in
a cfloop from 1 to 1 which makes the extra output vanish.

Well I'm starting to find other odd display things that cfmodule seems
to be doing...so it's time to nail this puppy once and for all.

Any thoughts? experiences? comments?

TIA

Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Allaire Alliance Partner
www.allaire.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: SELECT MAX(ID), Access & SQL Server - confused!

[Dave Watts]

> Am I right in thinking SQL Server doesn't have the
> 'Autonumber' data type? Why not? Is there a grave
> disadvantage to it unless you're doing kid's stuff in
> Access? 

In SQL Server, it's called an IDENTITY column. It's basically the same
thing. Most database systems have some way to create a surrogate key - a key
which is created by the database, rather than drawn from the actual data.

> Is it cool to use the SELECT MAX(ID) with SQL Server
> 2000 (i.e. do the 6.5/7 problems above not happen now)?

You're better off taking advantage of the features of your database. Instead
of doing two queries, you can have one interaction with the database in
which you insert the new record and retrieve the new key. You can do this
with a stored procedure or trigger.

I didn't read the link you posted, but if I recall correctly, the problem to
which you're referring is the possibility that you might get the wrong key
due to row-level locking within transactions. If that's the case, that
"problem" - it's not really a problem with the database, but rather one with
the expectations within the application code - still exists, and you
wouldn't want to use the SELECT MAX(ID) approach.

> If I put  around
> the SELECT MAX(ID) and INSERT queries (in whatever
> order), are there any hidden dangers? Does this prevent
> anything else from changing the table concerned until
> the new ID is calculated and the nice new record is
> INSERTed?

You may unnecessarily hurt performance if you make your transactions
serializable. There's no need for it in this case - just use a stored proc
or a trigger. However, I'm pretty sure that, yes, it would prevent someone
else from inserting a record until you've retrieved the key.

> You can't use stored procedures or triggers on Access,
> right?

Access doesn't support ANSI SQL stored procedures, but you can create
parameter queries in Access, and you can use CFSTOREDPROC to call them from
within your CF application.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: (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

CFMODULE and odd display behavior

[Bryan Stevenson]

Hey Folks,

OK I found this bug/glitch quite a while agoposted it to some 
lists...never really got a decent resolution.

So here we go again beacuse it's driving me up the wall ;-)

I got tired of relying on hosting tech support to put custom tags in 
place, so I use CFMODULE instead.

The Problem:

I have many tags that do many things, but we'll go with a simple 
example.  A tag to take a phone number and format it based on 
length...not rocket science.  Now when I call the tag (using cfmodule) 
to format a phone number (input string...process...display) I will get 
the phone number displaying twice (once in the table where it should be 
and again at the bottom of the page).  Now if I loop over a bunch of 
records and use the tag for each record all is well.  So my solution up 
till now when displaying a single record is to wrap the cfmodule call in 
a cfloop from 1 to 1 which makes the extra output vanish.

Well I'm starting to find other odd display things that cfmodule seems 
to be doing...so it's time to nail this puppy once and for all.

Any thoughts? experiences? comments?

TIA

Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Allaire Alliance Partner
www.allaire.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: AOLServer (was: CF/IIS/Windows security class)

[Dave Watts]

> PSS:  Although certain parts of allaire.com run faster now 
> that Macromedia has taken over, the support section still is 
> slow and the KB returns articles that have little relevance to 
> what I type it. That said, I'm tired of waiting around for the 
> web site to actually tell me something useful. Anyone know if 
> CF will run on AOLServer?

It should run in CGI mode, with the crappy performance which that entails. I
don't think AOLServer supports any of the "standard" APIs used by other web
servers.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: (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: SELECT MAX(ID), Access & SQL Server - confused!

[Matt Robertson]

No, Access doesn't support stored procs or triggers.

In SQL Server the analog for 'autonumber' is 'identity', which imho makes a perfectly 
good primary key.

There's no real certainty that MAX is going to return *your* last inserted ID.  It 
might be from another user's insert statement.  I think you can choke the process down 
with a name-based cflock, but now you have a cflock and a cftransaction block to go 
along with a query needed to determine the last-inserted value.

If you don't have triggers/stored procs available to you, here's another way to do the 
job:  First, when the db table is created include a text field called UUID or 
something similar.  Then, in your insert operation do a 

CFSET variables.myvalue=CreateUUID() 

and insert variables.myvalue into the UUID field of the db.  

Then, when you need the record next, select with a WHERE filter that looks for the 
UUID value set in variables.myvalue.  *Then* you can grab the much tidier ID field 
value for future use, if needed.

This gets the job done without a CFTRANSACTION, CFLOCK or an extra query to determine 
the ID value.  Its cost is a db field and an (optional, really) table index. 

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


-- Original Message --
from: "Gyrus" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Mon, 26 Nov 2001 23:22:38 -

I'm majorly confused about Primary Keys and Access'
'Autonumber' data type.

I've always used 'Autonumber' as seemingly the best
and easiest way for unique ID's to be created for PK
fields in Access tables.

I was aware of some issue with the common SELECT
MAX(ID) SQL operation you end up doing to get the ID
of something you just inserted. I found this at

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

The guy seems to be responding to someone posting the
Fusebox technique of using SELECT MAX(ID) and
 as a universal method of creating
ID's for PKs, so that apps are portable between RDMS's.

He seems to think the problem he mentions only happens
on SQL Server 6.5/7, though. There was a response to
this at

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

Here it was advised to use stored procedures, "isolation
level" on , or an insert trigger.

Then I grab the Max_ID.cfm custom tag by Steve Nelson
from fusebox.org, which has a nice suggestion in the
documentation, to use an endless loop and 
around the , to keep trying to get the
new ID *and* insert the new record until it gets it right.

Questions:

- Am I right in thinking SQL Server doesn't have the
  'Autonumber' data type? Why not? Is there a grave
  disadvantage to it unless you're doing kid's stuff in
  Access?

- Is it cool to use the SELECT MAX(ID) with SQL Server
  2000 (i.e. do the 6.5/7 problems above not happen now)?

- If I put  around
  the SELECT MAX(ID) and INSERT queries (in whatever
  order), are there any hidden dangers? Does this prevent
  anything else from changing the table concerned until
  the new ID is calculated and the nice new record is
  INSERTed?

- You can't use stored procedures or triggers on Access,
  right?

I'm basically trying to get this process *right*, and trying
to construct app templates that will be easily portable
between different DB systems - so even though I'm still
mostly working with Access, I might drop the whole
'Autonumber' thing.

Any advice/tips greatly appreciated on this!

- Gyrus



~~
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: Announcement: CF/IIS/Windows security class

[Won Lee]

You probably don't have clients that will threaten to sue you because you
failed to fully secure your web server.  Setup your own honeypot project;
put a single machine with a standard install of IIS out on the web and log
everything.  Heck for $6 an hour I can't imagine your university expects
more out from you.

PS: Man I remember being a kid.  Eating at the Kiddie table during famliy
get-togethers.  That sucked.  Hopefully your family isn't as a living
Shakespear play like mine is.

PSS:  You get paid $6/hour?  Your school is ultra cheap.  I got paid like
$15/ hour networking other students computers the the net.  Although I have
to say that you earn your money working with Novell and trying to connect
win 3.11 machines.  Heh.

PSS:  Although certain parts of allaire.com run faster now that Macromedia
has taken over, the support section still is slow and the KB returns
articles that have little relevance to what I type it.  That said, I'm tired
of waiting around for the web site to actually tell me something useful.
Anyone know if CF will run on AOLServer?

Won Lee

=
Not being a materialist in the U.S. is kind of like not appreciating opera
if you live in Milan or art if you live in Paris. We support materialism
better than any other culture. Because retailing and distribution are so
efficient here, stuff is cheaper than anywhere else in the world. And then
we have huge houses in which to archive our stuff.


-Original Message-
From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 26, 2001 5:44 PM
To: CF-Talk
Subject: RE: Announcement: CF/IIS/Windows security class


Where can kids deeply involved in technology go for some classes like
these.. Im sure you know, college kids are broke  :-)
My $6/hr wages for CF development for the University and fulltime credit
load doesn't allow for day trips to the south.  LOL

Mike


-Original Message-
From: Lee Fuller [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 26, 2001 5:42 PM
To: CF-Talk
Subject: RE: Announcement: CF/IIS/Windows security class


True.. Make it LA, which makes it good for everyone from San Diego to San
Francisco, pretty much.

Lee


> -Original Message-
> From: Matt Robertson [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 26, 2001 2:41 PM
> To: CF-Talk
> Subject: RE: Announcement: CF/IIS/Windows security class
>
>
> > As Lee indicated, there may be demand for this course in many >
> > places, and I wouldn't mind a bit of travel, myself.
>
> Me neither.  Come to CA!  I'd definitely want to take this
> course provided the travelling could be held down to a day's
> drive or somesuch.
>
> Cheers,
>
> ---
> 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

SELECT MAX(ID), Access & SQL Server - confused!

[Gyrus]

I'm majorly confused about Primary Keys and Access'
'Autonumber' data type.

I've always used 'Autonumber' as seemingly the best
and easiest way for unique ID's to be created for PK
fields in Access tables.

I was aware of some issue with the common SELECT
MAX(ID) SQL operation you end up doing to get the ID
of something you just inserted. I found this at

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

The guy seems to be responding to someone posting the
Fusebox technique of using SELECT MAX(ID) and
 as a universal method of creating
ID's for PKs, so that apps are portable between RDMS's.

He seems to think the problem he mentions only happens
on SQL Server 6.5/7, though. There was a response to
this at

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

Here it was advised to use stored procedures, "isolation
level" on , or an insert trigger.

Then I grab the Max_ID.cfm custom tag by Steve Nelson
from fusebox.org, which has a nice suggestion in the
documentation, to use an endless loop and 
around the , to keep trying to get the
new ID *and* insert the new record until it gets it right.

Questions:

- Am I right in thinking SQL Server doesn't have the
  'Autonumber' data type? Why not? Is there a grave
  disadvantage to it unless you're doing kid's stuff in
  Access?

- Is it cool to use the SELECT MAX(ID) with SQL Server
  2000 (i.e. do the 6.5/7 problems above not happen now)?

- If I put  around
  the SELECT MAX(ID) and INSERT queries (in whatever
  order), are there any hidden dangers? Does this prevent
  anything else from changing the table concerned until
  the new ID is calculated and the nice new record is
  INSERTed?

- You can't use stored procedures or triggers on Access,
  right?

I'm basically trying to get this process *right*, and trying
to construct app templates that will be easily portable
between different DB systems - so even though I'm still
mostly working with Access, I might drop the whole
'Autonumber' thing.

Any advice/tips greatly appreciated on this!

- 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: Verity Explicit Search using evidence operators

[Joseph Thompson]

Have you tried
 'Image'

that should give you only "exact" matches.

I am not sure that Verity is not simply ignoring the hyphen though...


> I have verity collection populated from a db query. In the CFSearch I have
> set the type to EXPLICIT and I need to set the criteria so that it only
> returns a specific word selected from a form; such as  = #form.topics#>
>
> Here's why: Say I search on the word "Image". In the collection, there are
> topics called "image" and "self-image". The results brings back records
> based on both "image" and "self-image".
>
> I need to be able to suppress the word stemming. I thought of using the
>  evidence operator, but I can't get it to work.
>
> What would be the proper syntax for using , or is there something
else
> I should be using?
>
> Thanks,
> Mark
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Announcement: CF/IIS/Windows security class

[Tangorre, Michael T.]

Where can kids deeply involved in technology go for some classes like
these.. Im sure you know, college kids are broke  :-)
My $6/hr wages for CF development for the University and fulltime credit
load doesn't allow for day trips to the south.  LOL

Mike


-Original Message-
From: Lee Fuller [mailto:[EMAIL PROTECTED]] 
Sent: Monday, November 26, 2001 5:42 PM
To: CF-Talk
Subject: RE: Announcement: CF/IIS/Windows security class


True.. Make it LA, which makes it good for everyone from San Diego to San
Francisco, pretty much.

Lee


> -Original Message-
> From: Matt Robertson [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 26, 2001 2:41 PM
> To: CF-Talk
> Subject: RE: Announcement: CF/IIS/Windows security class
> 
> 
> > As Lee indicated, there may be demand for this course in many >
> > places, and I wouldn't mind a bit of travel, myself.
> 
> Me neither.  Come to CA!  I'd definitely want to take this
> course provided the travelling could be held down to a day's 
> drive or somesuch.
> 
> Cheers,
> 
> ---
> 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: Announcement: CF/IIS/Windows security class

[Dave Watts]

> Ok.. So I go back to my first question...
> 
> When are you coming out here to So.Cal to make that happen?  ;)

I have no idea. That's not up to me, really. However, I know that we're
planning to offer this course at some point on the West Coast. I'll pass
along all notes of interest to our training department, which might make
that happen sooner.

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

RE: Copying Structures Exam Question - is this right?

[David Schmidt]

Try it.  The answer is 120.

-Original Message-
From: Baskin, Dave [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 26, 2001 2:28 PM
To: CF-Talk
Subject: Copying Structures Exam Question - is this right?


Hello, the following question was asked:

What would the following CFML code display to the user?
cfset Temp=StructNew()
cfset Temp["First"]=40
cfset Second=StructCopy(Temp)
cfset Second["First"]=80
cfoutput #Evaluate(Second["First"] + Temp["First"])# /cfoutput

my answer was 160, but according to the book, the answer is 120. I thought
(and it says in Forta's book) that a copy of a structure is just a pointer
to the original so that if you change the copy, you change the original. Am
i missing something here? Can someone explain? Thanks for any help.

d


~~
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: Copying Structures Exam Question - is this right?

[Dave Watts]

> What would the following CFML code display to the user?
>
> cfset Temp=StructNew()
> cfset Temp["First"]=40
> cfset Second=StructCopy(Temp)
> cfset Second["First"]=80
> cfoutput #Evaluate(Second["First"] + Temp["First"])# /cfoutput
>
> my answer was 160, but according to the book, the answer is 120. I
> thought (and it says in Forta's book) that a copy of a structure is 
> just a pointer to the original so that if you change the copy, you 
> change the original.

When you use the StructCopy or Duplicate functions to copy a structure, it
copies the structure by value - creating a separate object. If you don't use
one of those functions when you copy, you copy by reference, creating a
pointer. The code below would copy by reference:



Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: (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: Announcement: CF/IIS/Windows security class

[Lee Fuller]

Ok.. So I go back to my first question...

When are you coming out here to So.Cal to make that happen?  ;)

Lee


> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, November 26, 2001 2:36 PM
> To: CF-Talk
> Subject: RE: Announcement: CF/IIS/Windows security class
> 
> 
> > Even better (IMHO), why not make it an online class or tutorial?
> 
> While that would be nice, there are a few reasons that come to mind.
> 
> 1. Experience
> 
> I've developed "regular" courses before, and I feel confident 
> in my ability to do so. I haven't developed online courses. 
> There are enough differences in how material is presented to 
> make it a non-trivial task - something else I'd have to 
> learn. There's a lot of work in course development beyond 
> simply presenting the material itself, and I want to do it right.
> 
> 2. Course flexibility and value
> 
> One of the advantages of this course is that it can easily 
> accommodate questions and answers that go beyond the stuff on 
> the slides. In my opinion, as someone who spends a decent 
> amount of time training others, that's the primary value of 
> "regular" courses. The value of a good course isn't in the 
> courseware itself - often, you'd be better off with a book on 
> the subject. Instead, the value comes from the Socratic 
> dialog, if you will, that can occur in a classroom.
> 
> On the topic covered by this course, for example, there are 
> quite a few books worth reading. I submit, however, that the 
> course may still be a worthwhile undertaking for you if you'd 
> read those books, because you could ask questions (and 
> followup questions) in a more efficient and directed manner 
> than you could hope to otherwise.
> 
> 3. Time to market.
> 
> This goes back to (1) above, but even if I did have 
> experience developing effective online courseware, it would 
> take significantly longer.
> 
> 4. An excuse for me to get out of the office.
> 
> As Lee indicated, there may be demand for this course in many 
> places, and I wouldn't mind a bit of travel, myself.
> 
> 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

RE: Announcement: CF/IIS/Windows security class

[Lee Fuller]

True.. Make it LA, which makes it good for everyone from San Diego to
San Francisco, pretty much.

Lee


> -Original Message-
> From: Matt Robertson [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, November 26, 2001 2:41 PM
> To: CF-Talk
> Subject: RE: Announcement: CF/IIS/Windows security class
> 
> 
> > As Lee indicated, there may be demand for this course in many > 
> > places, and I wouldn't mind a bit of travel, myself.
> 
> Me neither.  Come to CA!  I'd definitely want to take this 
> course provided the travelling could be held down to a day's 
> drive or somesuch.
> 
> Cheers,
> 
> ---
> 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: Copying Structures Exam Question - is this right?

[Zac Belado]

> my answer was 160, but according to the book, the answer is 120. I thought
> (and it says in Forta's book) that a copy of a structure is just a pointer
> to the original so that if you change the copy, you change the
> original. Am
> i missing something here? Can someone explain? Thanks for any help.

You're right that copies of a struct created using the assignment operator
are simply pointers but the structCopy() function makes a deep duplicate of
the struct that is in its own memory space and is not just a pointer to the
original struct.

So in the example from the exam the two structs are different entities
~~
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: Announcement: CF/IIS/Windows security class

[Matt Robertson]

> As Lee indicated, there may be demand for this course in many > places, and I 
>wouldn't mind a bit of travel, myself.

Me neither.  Come to CA!  I'd definitely want to take this course provided the 
travelling could be held down to a day's drive or somesuch.

Cheers,

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

Copying Structures Exam Question - is this right?

[Baskin, Dave]

Hello, the following question was asked:

What would the following CFML code display to the user?
cfset Temp=StructNew()
cfset Temp["First"]=40
cfset Second=StructCopy(Temp)
cfset Second["First"]=80
cfoutput #Evaluate(Second["First"] + Temp["First"])# /cfoutput

my answer was 160, but according to the book, the answer is 120. I thought
(and it says in Forta's book) that a copy of a structure is just a pointer
to the original so that if you change the copy, you change the original. Am
i missing something here? Can someone explain? Thanks for any help.

d

~~
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: Announcement: CF/IIS/Windows security class

[Dave Watts]

> Even better (IMHO), why not make it an online class or tutorial?

While that would be nice, there are a few reasons that come to mind.

1. Experience

I've developed "regular" courses before, and I feel confident in my ability
to do so. I haven't developed online courses. There are enough differences
in how material is presented to make it a non-trivial task - something else
I'd have to learn. There's a lot of work in course development beyond simply
presenting the material itself, and I want to do it right.

2. Course flexibility and value

One of the advantages of this course is that it can easily accommodate
questions and answers that go beyond the stuff on the slides. In my opinion,
as someone who spends a decent amount of time training others, that's the
primary value of "regular" courses. The value of a good course isn't in the
courseware itself - often, you'd be better off with a book on the subject.
Instead, the value comes from the Socratic dialog, if you will, that can
occur in a classroom.

On the topic covered by this course, for example, there are quite a few
books worth reading. I submit, however, that the course may still be a
worthwhile undertaking for you if you'd read those books, because you could
ask questions (and followup questions) in a more efficient and directed
manner than you could hope to otherwise.

3. Time to market.

This goes back to (1) above, but even if I did have experience developing
effective online courseware, it would take significantly longer.

4. An excuse for me to get out of the office.

As Lee indicated, there may be demand for this course in many places, and I
wouldn't mind a bit of travel, myself.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: (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: Announcement: CF/IIS/Windows security class

[Lee Fuller]

Yes.. Agreed!

Lee


> -Original Message-
> From: Cary Gordon [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, November 26, 2001 2:14 PM
> To: CF-Talk
> Subject: RE: Announcement: CF/IIS/Windows security class
> 
> 
> Even better (IMHO), why not make it an online class or tutorial?
> 
> Cary
> 
> At 11:44 AM 11/26/2001 -0800, you wrote:
> >And just when are you planning on coming out here to CA to teach it 
> >Dave??  Hmm?? ;)
> >
> > Lee
> >
> >
> > > -Original Message-
> > > From: Dave Watts [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, November 26, 2001 10:58 AM
> > > To: CF-Talk
> > > Subject: OT: Announcement: CF/IIS/Windows security class
> > >
> > >
> > > Hi, everyone!
> > >
> > > I apologize in advance for posting this, but I think that some of 
> > > you might find it useful. I've just written a one-day 
> CF/IIS/Windows 
> > > security class aimed at developers and "casual administrators" as 
> > > well as regular sysadmins. This class originated in the work that
> > > I've done
> > > to secure servers for Fig Leaf's clients, in (hopefully
> > > well-received)
> > > presentations done at users' groups, and quite a bit of additional
> > > research, testing and organization.
> > >
> > > I've included the description of the class from our web site. If 
> > > anyone has any questions, feel free to email me off-list. 
> There's an
> > > upcoming
> > > Atlanta data: Friday, 7 December, and there are plenty of 
> seats still
> > > available. Thanks!
> > >
> > > Dave Watts, CTO, Fig Leaf Software
> > > http://www.figleaf.com/
> > > phone: (202) 797-5496
> > > fax: (202) 797-5444
> > >
> > > Securing ColdFusion Servers on Windows
> > >
> > > This one-day "Working in the Trenches" seminar covers building 
> > > secure ColdFusion application servers on the Windows 
> platform, and 
> > > keeping them secure. You'll learn how to secure the 
> Windows OS, IIS 
> > > and CF Server, find and eliminate security holes in your 
> application 
> > > code, and maintain security on your servers. See how 
> attacks work, 
> > > and how you can
> > > defend against them in depth.
> > >
> > > There are other security courses out there, but none that cover 
> > > general Windows Internet server security as well as 
> > > ColdFusion-specific
> > > security: from securing the ColdFusion server itself to securing 
> > > ColdFusion applications and their dependencies.
> > >
> > > Not only will you learn the steps to security, you'll 
> also learn how 
> > > to perform those steps efficiently and quickly, and leave with
> > > ready-to-use
> > > tools and methodologies you can apply immediately. Lower 
> your TCO and
> > > your stress with "Securing ColdFusion Servers on 
> Windows"! This is a
> > > lecture course - not hands on.
> > >
> > > Cost:   $495 per student
> > > Instructor: Dave Watts, CTO, Fig Leaf Software
> > > Available Dates:
> > > Washington, DC - December 5, 2001, January 9, 2002
> > > Atlanta, GA - December 7, 2001, January 22, 2002
> > > Chicago, IL - December 13, 2001
> > >
> > > Register today at http://www.figleaf.com/trainingcalendar/
> 
> 
> Cary Gordon
> The Cherry Hill Company 
> 
~~
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: Announcement: CF/IIS/Windows security class

[Cary Gordon]

Even better (IMHO), why not make it an online class or tutorial?

Cary

At 11:44 AM 11/26/2001 -0800, you wrote:
>And just when are you planning on coming out here to CA to teach it
>Dave??  Hmm?? ;)
>
> Lee
>
>
> > -Original Message-
> > From: Dave Watts [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, November 26, 2001 10:58 AM
> > To: CF-Talk
> > Subject: OT: Announcement: CF/IIS/Windows security class
> >
> >
> > Hi, everyone!
> >
> > I apologize in advance for posting this, but I think that some of you
> > might find it useful. I've just written a one-day CF/IIS/Windows
> > security class aimed at developers and "casual
> > administrators" as well
> > as regular sysadmins. This class originated in the work that
> > I've done
> > to secure servers for Fig Leaf's clients, in (hopefully
> > well-received)
> > presentations done at users' groups, and quite a bit of additional
> > research, testing and organization.
> >
> > I've included the description of the class from our web site.
> > If anyone
> > has any questions, feel free to email me off-list. There's an
> > upcoming
> > Atlanta data: Friday, 7 December, and there are plenty of seats still
> > available. Thanks!
> >
> > Dave Watts, CTO, Fig Leaf Software
> > http://www.figleaf.com/
> > phone: (202) 797-5496
> > fax: (202) 797-5444
> >
> > Securing ColdFusion Servers on Windows
> >
> > This one-day "Working in the Trenches" seminar covers building secure
> > ColdFusion application servers on the Windows platform, and keeping
> > them secure. You'll learn how to secure the Windows OS, IIS
> > and CF Server, find and eliminate security holes in your
> > application code, and
> > maintain security on your servers. See how attacks work, and
> > how you can
> > defend against them in depth.
> >
> > There are other security courses out there, but none that
> > cover general
> > Windows Internet server security as well as ColdFusion-specific
> > security: from securing the ColdFusion server itself to securing
> > ColdFusion applications and their dependencies.
> >
> > Not only will you learn the steps to security, you'll also
> > learn how to
> > perform those steps efficiently and quickly, and leave with
> > ready-to-use
> > tools and methodologies you can apply immediately. Lower your TCO and
> > your stress with "Securing ColdFusion Servers on Windows"! This is a
> > lecture course - not hands on.
> >
> > Cost:   $495 per student
> > Instructor: Dave Watts, CTO, Fig Leaf Software
> > Available Dates:
> > Washington, DC - December 5, 2001, January 9, 2002
> > Atlanta, GA - December 7, 2001, January 22, 2002
> > Chicago, IL - December 13, 2001
> >
> > Register today at http://www.figleaf.com/trainingcalendar/


Cary Gordon
The Cherry Hill Company
~~
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: problem inserting encrypted wddx packet into database

[BILLY CRAVENS]

The way I dealt with this was to use the undocument cfusion_encrypt
function - works just like encrypt(), but it only encrypts to alphanumeric
characters, ensuring that it's sql safe.

- Original Message -
From: "Kola Oyedeji" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 26, 2001 9:50 AM
Subject: problem inserting encrypted wddx packet into database


> Hi - sorry for the cross post
>
> I hope someone can shed some light on the best way to do this. I have a
> structure which is turned into a wddx packet and then encrypted. However
> when I try save it to the database I get an error:
>
> SQL = "UPDATE sales SET serializedStruct = 'M&L0?@(.FF/?2CD&718NI3'.
> E.>>P>X0SL'4PJ<;_@^7D8S!!L@/49.#6D'S M"-=6[ZQ8Q91K:898NQG'Q*I)[_"SMEO8V
> &:J$V]6_*RN(NM<+>6J-3^ 1JH
> MQTZWNUO-FB80Y91+E/79?&$G]$D=K1+Q$5JLV57]D@/WGAY^C!Z/M:O[_;C%
> MRHR:SJ:AE<>JT8/: L(&4_)QMS$L%UZB0F0_<8&"[6:1JF3BI'- YR!_;[S
> M*6F:O1/=.#>^P-W,);RK)$Z[]=3!Q4Z2K1>CF,"/HD&:#_&,F526"*@"XO"-
> @CKWU9LB,4Z&K\$ ' WHERE transactionNumber = '195572' AND CustomerID =
> 232387"
>
> I'm assuming its because of some of the characters the encrypt tag spits
> out(such as commas and quotes) as when I save it using URlencodedFOrmat
its
> fine. But when I do that and its time to de-serailize it I get the
following
> error:
>
> XML parsing error: not well-formed (error code 4, line 1, column 22,
buffer
> offset 22)
>
> Thanks in advance for any light you can shed on this>
> 
~~
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: Deleting CFusion Log records

[Webmaster]

Funny you should mention that. My mail log file on my workstation at work
(test system) was 1.07 GB :( )  Now I gots room :)

"Jeffrey R. Pratte" <[EMAIL PROTECTED]> wrote in message
000301c175d9$a72cd210$79c3b7d1@crawdadsvr">news:000301c175d9$a72cd210$79c3b7d1@crawdadsvr...
> Gang,
>
> My Cold Fusion log files are getting quite large and I would like to
> delete them. Can I just go in via PC Anywhere/Windows Exploder and
> delete the contents of those folders, or is there a more elegant
> procedure I don't know about.
>
> Thanks, J
> [EMAIL PROTECTED]
>
> 
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Raduis Authentication

[krisch]

I am trying to use CF to authenticate users with their Username and
password from the radius server on the Unix side of the network on an
Win2K/IIS/CF 5 server. I tried the cfx_radauth tag without success. The
sys admin watched the request and said that the username was not being
sent. In this initial testing phase I hardcoded in a valid username and
password as a "proof of concept" so there isn't any chance that a variable
is not evaluating properly. The tag does make a request to the radius
server but just doesn't seem to be passing the right data along. Is there
something I could be doing wrong? Is there a better tag out there (I tried
the java one, even though it says it has only been tested on linux, with
no success)? Any help would be much appreciated.

Thanks in advance,

Kristine C. Hege  [EMAIL PROTECTED]
Database & Applications SpecialistPhone: (802) 463-2111
SoVerNet Inc. Ext: 105
5 Rockingham St.
Bellows Falls, VT 05101

--
_   ..   . - .
PROGRAM  (PRO'-gram') [n] A magic spell cast over a |C>_.|.:' .:.  .
computer allowing it to turn one's input into error   __||__ `:.  O_/
messages.[vi] To engage in a pastime similar to  |  __--|   \/M
banging one's head against a wall,  but, with fewer  `-/..\-'   _/ \_
opportunities for reward. `'

~~
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: MS word HTML page with a picture

[Robert Everland]

What I did was this, I did a replace on the html when I created it, then
moved the pictures to a directory that the web refrences. That fixed my
problem, if you don't do that what will happen is word automatically creates
images that are number, say 10 images then they will be 1 - 10.png (word
2000) so if you have 2 documents with 10 images, the second one will
overwrite the first one. So you have to make directories to seperate the
different documents to boot. It works though.

Robert Everland III
Dixon Ticonderoga
Web Developer Extraordinaire

-Original Message-
From: David Green [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 26, 2001 4:40 PM
To: CF-Talk
Subject: MS word HTML page with a picture


Hello list,  Thanks all for the good material on this list!

I am not sure how to ask this question.

Is there a way to control the relative calling directory information 
when using cfinclude?  "I know questions does not make sense"

My problem is am including pages that are created in word and saved to 
HTML then uploaded by a user to a user defined directory structure on 
the server.  I then use cfdirectory and cfinclude to make pages with 
links and display the pages with footers and back grounds ect.   This 
all works great for pages without a pictures user is able to build and 
control there site with just word and some file management.   Till they 
add a picture to the document created in word

A page created/saved by MS word as HTML that  includes a picture looks 
for a sub directory of (WebPageName_files) in the directory that the MS 
word page is in.My problem is that because am using cfinclude I am 
not in the directory that the MS word page is in so my relative 
directory path is not what was created by the word when the document was 
saved.   

The path to the image in the document created word will be something 
like "./tour/testpage_files/picture.jpg"  but because of the cfinclude 
am not in the directory with a subdirectory of tour.  Am in the 
directory with my cfm pages (/webname/cf_pages ) and the page is looking 
here for the subdirectory of tour and the path to the image.   

Editing the path in the word after saving it html document is not an 
option.My user would not a clue on how to edit the code.

So my question has anybody done something like this using word and 
cfinclude and how did you handle the file paths created by word?

I am guessing some how I need to create a web page dynamically in the 
directory that the word doc is in and call it directly with maybe
a cflocation or java script?

Thanks the any help,  Sorry if this makes no sense.
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

MS word HTML page with a picture

[David Green]

Hello list,  Thanks all for the good material on this list!

I am not sure how to ask this question.

Is there a way to control the relative calling directory information 
when using cfinclude?  "I know questions does not make sense"

My problem is am including pages that are created in word and saved to 
HTML then uploaded by a user to a user defined directory structure on 
the server.  I then use cfdirectory and cfinclude to make pages with 
links and display the pages with footers and back grounds ect.   This 
all works great for pages without a pictures user is able to build and 
control there site with just word and some file management.   Till they 
add a picture to the document created in word

A page created/saved by MS word as HTML that  includes a picture looks 
for a sub directory of (WebPageName_files) in the directory that the MS 
word page is in.My problem is that because am using cfinclude I am 
not in the directory that the MS word page is in so my relative 
directory path is not what was created by the word when the document was 
saved.   

The path to the image in the document created word will be something 
like "./tour/testpage_files/picture.jpg"  but because of the cfinclude 
am not in the directory with a subdirectory of tour.  Am in the 
directory with my cfm pages (/webname/cf_pages ) and the page is looking 
here for the subdirectory of tour and the path to the image.   

Editing the path in the word after saving it html document is not an 
option.My user would not a clue on how to edit the code.

So my question has anybody done something like this using word and 
cfinclude and how did you handle the file paths created by word?

I am guessing some how I need to create a web page dynamically in the 
directory that the word doc is in and call it directly with maybe
a cflocation or java script?

Thanks the any help,  Sorry if this makes no sense.
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

Re: hosting recommendations

[corrigan]

I like CFM resources (www.cfm-resources.com).  Of course, they're all 
I've ever used but I've never had a problem with them.

Michael Corrigan
Programmer
Endora Digital Solutions 
www.endoradigital.com
630/942-5211 x-134
  - Original Message - 
  From: lsellers 
  To: CF-Talk 
  Sent: Monday, November 26, 2001 3:05 PM
  Subject: hosting recommendations


  'ello.

  Was looking around for a new host for intrafoundation.com. (My current 

  host's new management software is really ticking me off.)

  <2gb traffic a month avg. 8 email accounts. cf & asp required. 1 or 
more 
  odbc. relatively low stress website. cc gateway soft and cfx/com 
allowance 
  usage required (though I'm not using any cfx's or com's on it at the 
  moment). Some place reliable (2+ years up) but laid back.

  Cheap's good too. ;-)

  Thanks,
  --min
  
~~
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: hosting recommendations

[Yager, Brian T Contractor/NCCIM]

I have had really great service from www.advances.com 

Check them out!

Brian Yager
President - North AL Cold Fusion Users Group
Sr. Systems Analyst
NCCIM/CIC
[EMAIL PROTECTED]
(256) 842-8342


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 26, 2001 3:05 PM
To: CF-Talk
Subject: hosting recommendations


'ello.

Was looking around for a new host for intrafoundation.com. (My current 
host's new management software is really ticking me off.)

<2gb traffic a month avg. 8 email accounts. cf & asp required. 1 or more 
odbc. relatively low stress website. cc gateway soft and cfx/com allowance 
usage required (though I'm not using any cfx's or com's on it at the 
moment). Some place reliable (2+ years up) but laid back.

Cheap's good too. ;-)

Thanks,
--min

~~
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: hosting recommendations

[Bryan Stevenson]

Well they have been up over a yeartheir support is stellar...their
prices are dirt cheap especially if you're in the US because they are here
in Canada.

www.wedohosting.com talk to Lyle MacGregor or Dave Davies (tell 'em Electric
Edge sent ya...then ya get really good service)

HTH

Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Allaire Alliance Partner
www.allaire.com

- Original Message -
From: "lsellers" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 26, 2001 1:05 PM
Subject: hosting recommendations


> 'ello.
>
> Was looking around for a new host for intrafoundation.com. (My current
> host's new management software is really ticking me off.)
>
> <2gb traffic a month avg. 8 email accounts. cf & asp required. 1 or more
> odbc. relatively low stress website. cc gateway soft and cfx/com allowance
> usage required (though I'm not using any cfx's or com's on it at the
> moment). Some place reliable (2+ years up) but laid back.
>
> Cheap's good too. ;-)
>
> Thanks,
> --min
> 
~~
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: hosting recommendations

[Bruce Sorge]

I have been using ExpertHost.com for a while, and I have all of my clients on there as 
well. They have CF5, Windows, Linux, Oracle, SQL. And their prices are pretty good as 
well. They have customer service that is fast, knowledgable and friendly. I think that 
the slowest response time that I had was about an hour for an issue.

-- Original Message --
From: [EMAIL PROTECTED] (lsellers)
Reply-To: [EMAIL PROTECTED]
Date:  Mon, 26 Nov 2001 16:05:18 -0500

>'ello.
>
>Was looking around for a new host for intrafoundation.com. (My current 
>host's new management software is really ticking me off.)
>
><2gb traffic a month avg. 8 email accounts. cf & asp required. 1 or more 
>odbc. relatively low stress website. cc gateway soft and cfx/com allowance 
>usage required (though I'm not using any cfx's or com's on it at the 
>moment). Some place reliable (2+ years up) but laid back.
>
>Cheap's good too. ;-)
>
>Thanks,
>--min
>
~~
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

hosting recommendations

[lsellers]

'ello.

Was looking around for a new host for intrafoundation.com. (My current 
host's new management software is really ticking me off.)

<2gb traffic a month avg. 8 email accounts. cf & asp required. 1 or more 
odbc. relatively low stress website. cc gateway soft and cfx/com allowance 
usage required (though I'm not using any cfx's or com's on it at the 
moment). Some place reliable (2+ years up) but laid back.

Cheap's good too. ;-)

Thanks,
--min
~~
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: Easy SQL query, brain died

[Alex]

use an outer join 

On Mon, 26 Nov 2001, Robert Everland wrote:

>   Here is what I am trying to do. I have a table that lists types of
> stuff. In another table I refer to this stuff. So say one record will refer
> to stuff 1. another to stuff 2, but maybe no stuff 3
> how would I make a query to show 
> 
> stuff 1 = 1
> stuff 2 = 1
> stuff 3 = 0
> 
> My brain isn't working anymore
> 
> Robert Everland III
> Dixon Ticonderoga
> 
~~
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: cached query

[Nick Le Mouton]

can you post the code that you're using?

Thanks

-Original Message-
From: Fregas [mailto:[EMAIL PROTECTED]]
Sent: Monday, 26 November 2001 5:24 p.m.
To: CF-Talk
Subject: cached query


CFQuery 

Retrieval of cached query failed

I was under the impression that if a cached query wasn't already loaded, 
it would go ahead ond run it from the DB.  Is this wrong?  I am using 
CF4.5



~~
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: Complete lack of locking...

[Chris Norloff]

-- Original Message --
from: Shawn Grover <[EMAIL PROTECTED]>

>For those of you adverse to locking, why not simply set the server to lock
>all reads?

The Auto-read locking has some major problems with locking ALL reads.  Things like 
StructFind and IsDefined are reads but are not caught by read locking, which catches 
little more than cfset statements. The CF techs told me this, but said it's not 
published yet ...

Having survived (barely) multiple locking massacre's, I say lock ever use of every 
shared-scope variable no matter what.

Chris Norloff
~~
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: Complete lack of locking...

[Chris Norloff]

-- Original Message --
from: "Keith Meade" <[EMAIL PROTECTED]>
>BTW, a corollary of this is that, if your site does not use frames, ***you
>don't have to worry about locking session variables ever***.  Regardless of
>the setting of "Single Threaded Sessions" .

I'd be concerned about a user opening a second browser instance (which uses the same 
session id) or pressing a refresh button before a page fully loads.  Both will cause 
CF to start another thread.

~~
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: problem inserting encrypted wddx packet into database

[David Cummins]

The problem is that you're trying to decrypt an url encoded string - which will
give a different result than decrypting the original string. CF5 has an
URLDecode function. Otherwise its not hard to write one yourself.

David

Kola Oyedeji wrote:
> 
> Hi - sorry for the cross post
> 
> I hope someone can shed some light on the best way to do this. I have a
> structure which is turned into a wddx packet and then encrypted. However
> when I try save it to the database I get an error:
> 
> SQL = "UPDATE sales SET serializedStruct = 'M&L0?@(.FF/?2CD&718NI3'.
> E.>>P>X0SL'4PJ<;_@^7D8S!!L@/49.#6D'S M"-=6[ZQ8Q91K:898NQG'Q*I)[_"SMEO8V
> &:J$V]6_*RN(NM<+>6J-3^ 1JH
> MQTZWNUO-FB80Y91+E/79?&$G]$D=K1+Q$5JLV57]D@/WGAY^C!Z/M:O[_;C%
> MRHR:SJ:AE<>JT8/: L(&4_)QMS$L%UZB0F0_<8&"[6:1JF3BI'- YR!_;[S
> M*6F:O1/=.#>^P-W,);RK)$Z[]=3!Q4Z2K1>CF,"/HD&:#_&,F526"*@"XO"-
> @CKWU9LB,4Z&K\$ ' WHERE transactionNumber = '195572' AND CustomerID =
> 232387"
> 
> I'm assuming its because of some of the characters the encrypt tag spits
> out(such as commas and quotes) as when I save it using URlencodedFOrmat its
> fine. But when I do that and its time to de-serailize it I get the following
> error:
> 
> XML parsing error: not well-formed (error code 4, line 1, column 22, buffer
> offset 22)
> 
> Thanks in advance for any light you can shed on this>
~~
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: Global User-Defined Functions

[Ben Forta]

Some of the more advanced (and obscure) uses are not documented in detail.

For those of you playing with UDF's, if you are interested, the UDF
presentation I wrote for my CFUG tour is online at:
http://www.forta.com/cf/resources/

--- Ben


-Original Message-
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 26, 2001 3:04 PM
To: CF-Talk
Subject: Re: Global User-Defined Functions


  If memory serves me it is documented that you can use function names as
variables.
  This specific application of that is probably up the user to figure out.

At 12:52 PM 11/26/2001 -0700, you wrote:
>that is great! Is that documented anywhere? If not it should be.
>
>- Original Message -
>From: "Raymond Camden" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Monday, November 26, 2001 12:52 PM
>Subject: RE: Global User-Defined Functions
>
>
> > Yes, you can do this:
> >
> > 
> >
> > function foo() {
> > return true;
> > }
> >
> > request.foo = foo;
> >
> > 
> >
> > Then inside the custom tag you can say:
> >
> > 
> >
> > ===
> > 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: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, November 26, 2001 2:30 PM
> > > To: CF-Talk
> > > Subject: Global User-Defined Functions
> > >
> > >
> > > Is there a way to access a user-defined function throughout a
> > > request (e.g.
> > > from within custom tags or templates invoked with the CFMODULE tag)?
> > >
> > > Benjamin S. Rogers
> > > http://www.c4.net/
> > > v.508.240.0051
> > > f.508.240.0057
> > >
> >
>

~~
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: Problem with percentages

[Jay Callaghan]

Well  I have done it differently,but here is an idea

May have to create a field for 1,2,3,4 and 5 (such as Opt1Count, Opt2Count,
etc).

Increment the field by one when the user submits the survey.

Percentage:

What I would do is:



etc...

then when displaying percentage:


1: #NumberFormat(Num1Percent)#%  2:#NumberFormat(num2Percent)#% etc


I bet that is not the best way to do it,but hopefully it can help somewhat.



Jim Watkins <[EMAIL PROTECTED]> wrote in message
news:004101c17504$c47c6450$0100a8c0@jimdell...
> I have responses from a survey stored in an Access Database.  The
> responses
> are represented as 1,2,3,4, or 5 and are stored under columns labeled Q1
> through Q30 which represent the questions on the survey. I have no
> problem
> grouping and doing a SUM or an AVG.  What I am struggling with is
> getting
> percentages.
>
> Specifcally, I want to know what percentage of all the responses are
> ones,
> or twos, or threes, or fours, or fives. The test output is at:
> http://www.ngtcollege.org/survey/courseeval/courseevaldbg.cfm  I need to
> display something like:
> 1 = 25%, 2 = 15%, 3 = 40%, 4 = 20%, 5 = 0%
>
> A sample of my code is:
>
> 
> SELECT coursename,term,term1,
> SUM(Q1) AS Q1y,
> AVG(Q1) AS Q1x,
> SUM(Q2) AS Q2y,
> AVG(Q2) AS Q2x,
> [repeated through Q30]
>
> count (*) as num
> FROM courseeval
> GROUP BY coursename,term,term1
> 
>
> Sure would appreciate any help you can give me on this.
>
> Jim Watkins
>
>
> 
~~
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: Easy SQL query, brain died

[Robert Everland]

More along the lines of

SELECT count(ts.*) as number, tr.*
FROMtbl_stuff ts,  tbl_stuffReference tr
WHERE ts.id_stuff = tr.id_stuff
group by tr.*

Robert Everland III
Dixon Ticonderoga
Web Developer Extraordinaire

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 26, 2001 2:57 PM
To: CF-Talk
Subject: Re: Easy SQL query, brain died


Is this it?

SELECT ts.*, tr.*
FROMtbl_stuff ts,  tbl_stuffReference tr
WHERE ts.id_stuff = tr.id_stuff

Hope it helps

Michael Corrigan
Programmer
Endora Digital Solutions 
www.endoradigital.com
630/942-5211 x-134
  - Original Message - 
  From: Robert Everland 
  To: CF-Talk 
  Sent: Monday, November 26, 2001 1:39 PM
  Subject: Easy SQL query, brain died


  Here is what I am trying to do. I have a table that lists types of
  stuff. In another table I refer to this stuff. So say one record will 
refer
  to stuff 1. another to stuff 2, but maybe no stuff 3
  how would I make a query to show 

  stuff 1 = 1
  stuff 2 = 1
  stuff 3 = 0

  My brain isn't working anymore

  Robert Everland III
  Dixon Ticonderoga
  

~~
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: Global User-Defined Functions

[Jeffry Houser]

  If memory serves me it is documented that you can use function names as 
variables.
  This specific application of that is probably up the user to figure out.

At 12:52 PM 11/26/2001 -0700, you wrote:
>that is great! Is that documented anywhere? If not it should be.
>
>- Original Message -
>From: "Raymond Camden" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Monday, November 26, 2001 12:52 PM
>Subject: RE: Global User-Defined Functions
>
>
> > Yes, you can do this:
> >
> > 
> >
> > function foo() {
> > return true;
> > }
> >
> > request.foo = foo;
> >
> > 
> >
> > Then inside the custom tag you can say:
> >
> > 
> >
> > ===
> > 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: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, November 26, 2001 2:30 PM
> > > To: CF-Talk
> > > Subject: Global User-Defined Functions
> > >
> > >
> > > Is there a way to access a user-defined function throughout a
> > > request (e.g.
> > > from within custom tags or templates invoked with the CFMODULE tag)?
> > >
> > > Benjamin S. Rogers
> > > http://www.c4.net/
> > > v.508.240.0051
> > > f.508.240.0057
> > >
> >
>
~~
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: Easy SQL query, brain died

[Alex Santantonio]

SELECT p.StuffName, (SELECT Count(c.Table2ID) FROM T_StuffChild c WHERE
c.StuffID = p.StuffID) AS StuffCount FROM T_StuffParent p

Then 


#QueryName.StuffName# = #QueryName.StuffCount#


Or something along those lines.

Alex Santantonio, 
Lead Developer
Macromedia Coldfusion 5 Certified Professional
Macromedia Certified Web Site Developer
[EMAIL PROTECTED] 
www.doceus.com

-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 26, 2001 2:39 PM
To: CF-Talk
Subject: Easy SQL query, brain died

Here is what I am trying to do. I have a table that lists types of
stuff. In another table I refer to this stuff. So say one record will refer
to stuff 1. another to stuff 2, but maybe no stuff 3
how would I make a query to show

stuff 1 = 1
stuff 2 = 1
stuff 3 = 0

My brain isn't working anymore

Robert Everland III
Dixon Ticonderoga

~~
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: Global User-Defined Functions

[Benjamin S. Rogers]

That's exactly what I was looking for. I seemed to recall something about
that awhile back but, for the life of me, couldn't track down where I'd seen
that before. Thanks.

Benjamin S. Rogers
http://www.c4.net/
v.508.240.0051
f.508.240.0057

-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 26, 2001 2:53 PM
To: CF-Talk
Subject: RE: Global User-Defined Functions


Yes, you can do this:



function foo() {
return true;
}

request.foo = foo;



Then inside the custom tag you can say:



===
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: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 26, 2001 2:30 PM
> To: CF-Talk
> Subject: Global User-Defined Functions
>
>
> Is there a way to access a user-defined function throughout a
> request (e.g.
> from within custom tags or templates invoked with the CFMODULE tag)?
>
> Benjamin S. Rogers
> http://www.c4.net/
> v.508.240.0051
> f.508.240.0057
>

~~
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: Easy SQL query, brain died

[corrigan]

Is this it?

SELECT ts.*, tr.*
FROMtbl_stuff ts,  tbl_stuffReference tr
WHERE ts.id_stuff = tr.id_stuff

Hope it helps

Michael Corrigan
Programmer
Endora Digital Solutions 
www.endoradigital.com
630/942-5211 x-134
  - Original Message - 
  From: Robert Everland 
  To: CF-Talk 
  Sent: Monday, November 26, 2001 1:39 PM
  Subject: Easy SQL query, brain died


  Here is what I am trying to do. I have a table that lists types of
  stuff. In another table I refer to this stuff. So say one record will 
refer
  to stuff 1. another to stuff 2, but maybe no stuff 3
  how would I make a query to show 

  stuff 1 = 1
  stuff 2 = 1
  stuff 3 = 0

  My brain isn't working anymore

  Robert Everland III
  Dixon Ticonderoga
  
~~
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: Global User-Defined Functions

[Don Vawter]

that is great! Is that documented anywhere? If not it should be.

- Original Message - 
From: "Raymond Camden" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 26, 2001 12:52 PM
Subject: RE: Global User-Defined Functions


> Yes, you can do this:
> 
> 
> 
> function foo() {
> return true;
> }
> 
> request.foo = foo;
> 
> 
> 
> Then inside the custom tag you can say:
> 
> 
> 
> ===
> 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: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] 
> > Sent: Monday, November 26, 2001 2:30 PM
> > To: CF-Talk
> > Subject: Global User-Defined Functions
> > 
> > 
> > Is there a way to access a user-defined function throughout a 
> > request (e.g.
> > from within custom tags or templates invoked with the CFMODULE tag)?
> > 
> > Benjamin S. Rogers
> > http://www.c4.net/
> > v.508.240.0051
> > f.508.240.0057
> > 
> 
~~
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: Global User-Defined Functions

[Raymond Camden]

Yes, you can do this:



function foo() {
return true;
}

request.foo = foo;



Then inside the custom tag you can say:



===
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: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, November 26, 2001 2:30 PM
> To: CF-Talk
> Subject: Global User-Defined Functions
> 
> 
> Is there a way to access a user-defined function throughout a 
> request (e.g.
> from within custom tags or templates invoked with the CFMODULE tag)?
> 
> Benjamin S. Rogers
> http://www.c4.net/
> v.508.240.0051
> f.508.240.0057
> 
~~
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

Easy SQL query, brain died

[Robert Everland]

Here is what I am trying to do. I have a table that lists types of
stuff. In another table I refer to this stuff. So say one record will refer
to stuff 1. another to stuff 2, but maybe no stuff 3
how would I make a query to show 

stuff 1 = 1
stuff 2 = 1
stuff 3 = 0

My brain isn't working anymore

Robert Everland III
Dixon Ticonderoga
~~
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: Announcement: CF/IIS/Windows security class

[Lee Fuller]

And just when are you planning on coming out here to CA to teach it
Dave??  Hmm?? ;)

Lee


> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, November 26, 2001 10:58 AM
> To: CF-Talk
> Subject: OT: Announcement: CF/IIS/Windows security class
> 
> 
> Hi, everyone! 
> 
> I apologize in advance for posting this, but I think that some of you 
> might find it useful. I've just written a one-day CF/IIS/Windows 
> security class aimed at developers and "casual 
> administrators" as well 
> as regular sysadmins. This class originated in the work that 
> I've done 
> to secure servers for Fig Leaf's clients, in (hopefully 
> well-received) 
> presentations done at users' groups, and quite a bit of additional 
> research, testing and organization. 
> 
> I've included the description of the class from our web site. 
> If anyone 
> has any questions, feel free to email me off-list. There's an 
> upcoming 
> Atlanta data: Friday, 7 December, and there are plenty of seats still 
> available. Thanks! 
> 
> Dave Watts, CTO, Fig Leaf Software 
> http://www.figleaf.com/ 
> phone: (202) 797-5496 
> fax: (202) 797-5444 
> 
> Securing ColdFusion Servers on Windows 
> 
> This one-day "Working in the Trenches" seminar covers building secure 
> ColdFusion application servers on the Windows platform, and keeping 
> them secure. You'll learn how to secure the Windows OS, IIS 
> and CF Server, find and eliminate security holes in your 
> application code, and 
> maintain security on your servers. See how attacks work, and 
> how you can 
> defend against them in depth. 
>   
> There are other security courses out there, but none that 
> cover general 
> Windows Internet server security as well as ColdFusion-specific 
> security: from securing the ColdFusion server itself to securing 
> ColdFusion applications and their dependencies. 
> 
> Not only will you learn the steps to security, you'll also 
> learn how to 
> perform those steps efficiently and quickly, and leave with 
> ready-to-use 
> tools and methodologies you can apply immediately. Lower your TCO and 
> your stress with "Securing ColdFusion Servers on Windows"! This is a 
> lecture course - not hands on. 
> 
> Cost:   $495 per student 
> Instructor: Dave Watts, CTO, Fig Leaf Software 
> Available Dates: 
> Washington, DC - December 5, 2001, January 9, 2002 
> Atlanta, GA - December 7, 2001, January 22, 2002 
> Chicago, IL - December 13, 2001 
> 
> Register today at http://www.figleaf.com/trainingcalendar/ 
> 
~~
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

Verity Explicit Search using evidence operators

[Mark Leder]

I have verity collection populated from a db query. In the CFSearch I have
set the type to EXPLICIT and I need to set the criteria so that it only
returns a specific word selected from a form; such as 

Here's why: Say I search on the word "Image". In the collection, there are
topics called "image" and "self-image". The results brings back records
based on both "image" and "self-image".

I need to be able to suppress the word stemming. I thought of using the
 evidence operator, but I can't get it to work.

What would be the proper syntax for using , or is there something else
I should be using?

Thanks,
Mark
~~
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: New Toolkit for Integrating Flash and CF

[Robert Everland]

I have numerous times. Many people have over the flash kit. No one ever
responds. Even on the forums no one answers about the flash kit. So now they
come out with a new one and expect us all to just oooh and a and talk up
CF to our friends when one of the applications they made public doesn't
work.

Robert Everland III
Dixon Ticonderoga
Web Developer Extraordinaire

-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 26, 2001 2:28 PM
To: CF-Talk
Subject: Re: New Toolkit for Integrating Flash and CF


Hey Robert,

Why not ask Macromedia ;-)

Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Allaire Alliance Partner
www.allaire.com

- Original Message -
From: "Robert Everland" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 26, 2001 10:57 AM
Subject: RE: New Toolkit for Integrating Flash and CF


> Well what happened to fixing the existing Flash Kit. It's a great idea
that
> doesn't work, how do I know this flash kit won't go by the wayside like
the
> other one has.
>
> Robert Everland III
> Dixon Ticonderoga
> Web Developer Extraordinaire
>
> -Original Message-
> From: Phil Costa [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 26, 2001 1:59 PM
> To: CF-Talk
> Subject: RE: New Toolkit for Integrating Flash and CF
>
>
> This one is different. The Component Kit provided prebuilt widgets like a
> calendar. The Connector Kit provides a framework of reusable services for
> building your own applications. It uses a different architecture. For more
> info, see the FAQ:
> http://www.macromedia.com/software/coldfusion/downloads/component_kit/faq/
>
> Phil
>
> > -Original Message-
> > From: Robert Everland [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, November 26, 2001 1:48 PM
> > To: CF-Talk
> > Subject: RE: New Toolkit for Integrating Flash and CF
> >
> >
> > Does this one fix all the screwed up things that are wrong
> > with the flash
> > kit that is on the taggallery now?
> >
> > Robert Everland III
> > Dixon Ticonderoga
> > Web Developer Extraordinaire
> >
> > -Original Message-
> > From: Phil Costa [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, November 26, 2001 1:48 PM
> > To: CF-Talk
> > Subject: New Toolkit for Integrating Flash and CF
> >
> >
> >
> >  ctor_kit/>
> http://www.macromedia.com/software/coldfusion/downloads/connector_kit/
>
>   />
>
> Macromedia has just released the Macromedia Flash Connector Kit for
> ColdFusion. Consisting of prebuilt ActionScript objects and ColdFusion
> custom tags, the Connector Kit provides a framework of reusable services
for
> establishing communication, encoding and decoding data, managing context
and
> tracing errors.
>
>
>
> Download the Connector Kit and sample applications today and see what you
> can do with ColdFusion and Flash.
>
>
>
>  
> http://www.macromedia.com/software/coldfusion/downloads/connector_kit/
>
>
>
> Phil
>
>
>
>
>
> 

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

Global User-Defined Functions

[Benjamin S. Rogers]

Is there a way to access a user-defined function throughout a request (e.g.
from within custom tags or templates invoked with the CFMODULE tag)?

Benjamin S. Rogers
http://www.c4.net/
v.508.240.0051
f.508.240.0057
~~
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: New Toolkit for Integrating Flash and CF

[Bryan Stevenson]

Hey Robert,

Why not ask Macromedia ;-)

Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Allaire Alliance Partner
www.allaire.com

- Original Message -
From: "Robert Everland" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 26, 2001 10:57 AM
Subject: RE: New Toolkit for Integrating Flash and CF


> Well what happened to fixing the existing Flash Kit. It's a great idea
that
> doesn't work, how do I know this flash kit won't go by the wayside like
the
> other one has.
>
> Robert Everland III
> Dixon Ticonderoga
> Web Developer Extraordinaire
>
> -Original Message-
> From: Phil Costa [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 26, 2001 1:59 PM
> To: CF-Talk
> Subject: RE: New Toolkit for Integrating Flash and CF
>
>
> This one is different. The Component Kit provided prebuilt widgets like a
> calendar. The Connector Kit provides a framework of reusable services for
> building your own applications. It uses a different architecture. For more
> info, see the FAQ:
> http://www.macromedia.com/software/coldfusion/downloads/component_kit/faq/
>
> Phil
>
> > -Original Message-
> > From: Robert Everland [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, November 26, 2001 1:48 PM
> > To: CF-Talk
> > Subject: RE: New Toolkit for Integrating Flash and CF
> >
> >
> > Does this one fix all the screwed up things that are wrong
> > with the flash
> > kit that is on the taggallery now?
> >
> > Robert Everland III
> > Dixon Ticonderoga
> > Web Developer Extraordinaire
> >
> > -Original Message-
> > From: Phil Costa [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, November 26, 2001 1:48 PM
> > To: CF-Talk
> > Subject: New Toolkit for Integrating Flash and CF
> >
> >
> >
> >  ctor_kit/>
> http://www.macromedia.com/software/coldfusion/downloads/connector_kit/
>
>   />
>
> Macromedia has just released the Macromedia Flash Connector Kit for
> ColdFusion. Consisting of prebuilt ActionScript objects and ColdFusion
> custom tags, the Connector Kit provides a framework of reusable services
for
> establishing communication, encoding and decoding data, managing context
and
> tracing errors.
>
>
>
> Download the Connector Kit and sample applications today and see what you
> can do with ColdFusion and Flash.
>
>
>
>  
> http://www.macromedia.com/software/coldfusion/downloads/connector_kit/
>
>
>
> Phil
>
>
>
>
>
> 
~~
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: New Toolkit for Integrating Flash and CF

[Howie Hamlin]

Try this link instead:

http://www.macromedia.com/software/coldfusion/downloads/connector_kit/faq/

--
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: "Phil Costa" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 26, 2001 1:59 PM
Subject: RE: New Toolkit for Integrating Flash and CF


> This one is different. The Component Kit provided prebuilt widgets like a
> calendar. The Connector Kit provides a framework of reusable services for
> building your own applications. It uses a different architecture. For more
> info, see the FAQ:
> http://www.macromedia.com/software/coldfusion/downloads/component_kit/faq/
> 
> Phil
> 

~~
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: New Toolkit for Integrating Flash and CF

[Robert Everland]

Well what happened to fixing the existing Flash Kit. It's a great idea that
doesn't work, how do I know this flash kit won't go by the wayside like the
other one has.

Robert Everland III
Dixon Ticonderoga
Web Developer Extraordinaire

-Original Message-
From: Phil Costa [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 26, 2001 1:59 PM
To: CF-Talk
Subject: RE: New Toolkit for Integrating Flash and CF


This one is different. The Component Kit provided prebuilt widgets like a
calendar. The Connector Kit provides a framework of reusable services for
building your own applications. It uses a different architecture. For more
info, see the FAQ:
http://www.macromedia.com/software/coldfusion/downloads/component_kit/faq/

Phil

> -Original Message-
> From: Robert Everland [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 26, 2001 1:48 PM
> To: CF-Talk
> Subject: RE: New Toolkit for Integrating Flash and CF
> 
> 
> Does this one fix all the screwed up things that are wrong 
> with the flash
> kit that is on the taggallery now?
> 
> Robert Everland III
> Dixon Ticonderoga
> Web Developer Extraordinaire
> 
> -Original Message-
> From: Phil Costa [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 26, 2001 1:48 PM
> To: CF-Talk
> Subject: New Toolkit for Integrating Flash and CF
> 
> 
>  
> 
http://www.macromedia.com/software/coldfusion/downloads/connector_kit/

 

Macromedia has just released the Macromedia Flash Connector Kit for
ColdFusion. Consisting of prebuilt ActionScript objects and ColdFusion
custom tags, the Connector Kit provides a framework of reusable services for
establishing communication, encoding and decoding data, managing context and
tracing errors.

 

Download the Connector Kit and sample applications today and see what you
can do with ColdFusion and Flash. 

 

 
http://www.macromedia.com/software/coldfusion/downloads/connector_kit/

 

Phil 





~~
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: New Toolkit for Integrating Flash and CF

[Phil Costa]

This one is different. The Component Kit provided prebuilt widgets like a
calendar. The Connector Kit provides a framework of reusable services for
building your own applications. It uses a different architecture. For more
info, see the FAQ:
http://www.macromedia.com/software/coldfusion/downloads/component_kit/faq/

Phil

> -Original Message-
> From: Robert Everland [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 26, 2001 1:48 PM
> To: CF-Talk
> Subject: RE: New Toolkit for Integrating Flash and CF
> 
> 
> Does this one fix all the screwed up things that are wrong 
> with the flash
> kit that is on the taggallery now?
> 
> Robert Everland III
> Dixon Ticonderoga
> Web Developer Extraordinaire
> 
> -Original Message-
> From: Phil Costa [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 26, 2001 1:48 PM
> To: CF-Talk
> Subject: New Toolkit for Integrating Flash and CF
> 
> 
>  
> 
http://www.macromedia.com/software/coldfusion/downloads/connector_kit/

 

Macromedia has just released the Macromedia Flash Connector Kit for
ColdFusion. Consisting of prebuilt ActionScript objects and ColdFusion
custom tags, the Connector Kit provides a framework of reusable services for
establishing communication, encoding and decoding data, managing context and
tracing errors.

 

Download the Connector Kit and sample applications today and see what you
can do with ColdFusion and Flash. 

 

 
http://www.macromedia.com/software/coldfusion/downloads/connector_kit/

 

Phil 




~~
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: New Toolkit for Integrating Flash and CF

[Robert Everland]

Does this one fix all the screwed up things that are wrong with the flash
kit that is on the taggallery now?

Robert Everland III
Dixon Ticonderoga
Web Developer Extraordinaire

-Original Message-
From: Phil Costa [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 26, 2001 1:48 PM
To: CF-Talk
Subject: New Toolkit for Integrating Flash and CF


 
http://www.macromedia.com/software/coldfusion/downloads/connector_kit/

 

Macromedia has just released the Macromedia Flash Connector Kit for
ColdFusion. Consisting of prebuilt ActionScript objects and ColdFusion
custom tags, the Connector Kit provides a framework of reusable services for
establishing communication, encoding and decoding data, managing context and
tracing errors.

 

Download the Connector Kit and sample applications today and see what you
can do with ColdFusion and Flash. 

 

 
http://www.macromedia.com/software/coldfusion/downloads/connector_kit/

 

Phil 



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

OT: Announcement: CF/IIS/Windows security class

[Dave Watts]

Hi, everyone! 

I apologize in advance for posting this, but I think that some of you 
might find it useful. I've just written a one-day CF/IIS/Windows 
security class aimed at developers and "casual administrators" as well 
as regular sysadmins. This class originated in the work that I've done 
to secure servers for Fig Leaf's clients, in (hopefully well-received) 
presentations done at users' groups, and quite a bit of additional 
research, testing and organization. 

I've included the description of the class from our web site. If anyone 
has any questions, feel free to email me off-list. There's an upcoming 
Atlanta data: Friday, 7 December, and there are plenty of seats still 
available. Thanks! 

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

Securing ColdFusion Servers on Windows 

This one-day "Working in the Trenches" seminar covers building secure 
ColdFusion application servers on the Windows platform, and keeping 
them secure. You'll learn how to secure the Windows OS, IIS and CF Server,
find and eliminate security holes in your application code, and 
maintain security on your servers. See how attacks work, and how you can 
defend against them in depth. 
  
There are other security courses out there, but none that cover general 
Windows Internet server security as well as ColdFusion-specific 
security: from securing the ColdFusion server itself to securing 
ColdFusion applications and their dependencies. 

Not only will you learn the steps to security, you'll also learn how to 
perform those steps efficiently and quickly, and leave with ready-to-use 
tools and methodologies you can apply immediately. Lower your TCO and 
your stress with "Securing ColdFusion Servers on Windows"! This is a 
lecture course - not hands on. 

Cost:   $495 per student 
Instructor: Dave Watts, CTO, Fig Leaf Software 
Available Dates: 
Washington, DC - December 5, 2001, January 9, 2002 
Atlanta, GA - December 7, 2001, January 22, 2002 
Chicago, IL - December 13, 2001 

Register today at http://www.figleaf.com/trainingcalendar/ 
~~
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

New Toolkit for Integrating Flash and CF

[Phil Costa]

 
http://www.macromedia.com/software/coldfusion/downloads/connector_kit/

 

Macromedia has just released the Macromedia Flash Connector Kit for
ColdFusion. Consisting of prebuilt ActionScript objects and ColdFusion
custom tags, the Connector Kit provides a framework of reusable services for
establishing communication, encoding and decoding data, managing context and
tracing errors.

 

Download the Connector Kit and sample applications today and see what you
can do with ColdFusion and Flash. 

 

 
http://www.macromedia.com/software/coldfusion/downloads/connector_kit/

 

Phil 


~~
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: Is name locking sufficient for session vats?

[Yager, Brian T Contractor/NCCIM]

The server gives me an error.  I don't believe I have any of the service packs..

-Original Message-
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 26, 2001 12:38 PM
To: CF-Talk
Subject: RE: Is name locking sufficient for session vars?


  CF Studio gives you an error or your CF Server?
  The scope attribute was introduced in CF 4.5 ( I believe ).  It should 
work fine.  It sounds like your CF Studio 4.5 may have an earlier version 
of the VTMs.

At 12:30 PM 11/26/2001 -0600, you wrote:
>I am using CF 4.5 and Studio won't let me use scope.  When I try using the
>wizard, it doesn't put it in..When I add it manually, I get an error.
>
>-Original Message-
>From: Jim McAtee [mailto:[EMAIL PROTECTED]]
>Sent: Monday, November 26, 2001 10:47 AM
>To: CF-Talk
>Subject: Re: Is name locking sufficient for session vars?
>
>
>- Original Message -
>From: "cf refactoring" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Monday, November 26, 2001 9:09 AM
>Subject: Is name locking sufficient for session vars?
>
>
> > There's something that's been buggin me:
> >
> > Is NAME LOCKING sufficient for session variables?
> >
> > A best practice in CF is to always lock session
> > variable access, but it's not really clear whether
> >   1) NAME locking is sufficient or
> >   2) should we always lock with SCOPE=SESSION?
> >
> > To me, the answer seems to depend on how shared memory
> > is managed in CF. If session scope memory is managed
> > as an entire block, then we have to use SCOPE=SESSION,
> > because different user sessions can corrupt each
> > other. On the other hand, if session scope memory is
> > managed variable by variable, then we only need to
> > worry that a single variable is not simultaneously
> > accessed by two different threads, in which case a
> > NAME lock would be sufficient.
>
>
>I always assumed that setting a lock of scope=session implied that only one
>particular user session was being locked.  Is that not the case?  Does CF
>lock every current session established on the server?
>
>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

RE: Is name locking sufficient for session vars?

[Jeffry Houser]

  CF Studio gives you an error or your CF Server?
  The scope attribute was introduced in CF 4.5 ( I believe ).  It should 
work fine.  It sounds like your CF Studio 4.5 may have an earlier version 
of the VTMs.

At 12:30 PM 11/26/2001 -0600, you wrote:
>I am using CF 4.5 and Studio won't let me use scope.  When I try using the
>wizard, it doesn't put it in..When I add it manually, I get an error.
>
>-Original Message-
>From: Jim McAtee [mailto:[EMAIL PROTECTED]]
>Sent: Monday, November 26, 2001 10:47 AM
>To: CF-Talk
>Subject: Re: Is name locking sufficient for session vars?
>
>
>- Original Message -
>From: "cf refactoring" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Monday, November 26, 2001 9:09 AM
>Subject: Is name locking sufficient for session vars?
>
>
> > There's something that's been buggin me:
> >
> > Is NAME LOCKING sufficient for session variables?
> >
> > A best practice in CF is to always lock session
> > variable access, but it's not really clear whether
> >   1) NAME locking is sufficient or
> >   2) should we always lock with SCOPE=SESSION?
> >
> > To me, the answer seems to depend on how shared memory
> > is managed in CF. If session scope memory is managed
> > as an entire block, then we have to use SCOPE=SESSION,
> > because different user sessions can corrupt each
> > other. On the other hand, if session scope memory is
> > managed variable by variable, then we only need to
> > worry that a single variable is not simultaneously
> > accessed by two different threads, in which case a
> > NAME lock would be sufficient.
>
>
>I always assumed that setting a lock of scope=session implied that only one
>particular user session was being locked.  Is that not the case?  Does CF
>lock every current session established on the server?
>
>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

RE: Complete lack of locking...

[Chris Norloff]

Doesn't single-threading work only on the session?  This is, single-threading the 
SESSION, not the entire CFserver?

The text from the CFadmin single-thread setting on our CF4.5.1 is:
"
Single Threaded Sessions 
When checked, all requests are single threaded by session ID. This guarantees that any 
potential variable contention caused by simultaneous requests in the same session will 
not occur. 
"


thanks,
Chris Norloff
-- Original Message --
from: "Philip Arnold - ASP" <[EMAIL PROTECTED]>

>> Why not just enable the "Single Threaded Sessions" option? Doesn't that
>> eliminate the need to lock session-scoped variable access?
>
>DRASTIC!
>That'd mean that only one person who access the site at a time - severely
>limiting the access to the site
~~
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: Is name locking sufficient for session vars?

[Yager, Brian T Contractor/NCCIM]

I am using CF 4.5 and Studio won't let me use scope.  When I try using the
wizard, it doesn't put it in..When I add it manually, I get an error.  

-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 26, 2001 10:47 AM
To: CF-Talk
Subject: Re: Is name locking sufficient for session vars?


- Original Message -
From: "cf refactoring" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 26, 2001 9:09 AM
Subject: Is name locking sufficient for session vars?


> There's something that's been buggin me:
>
> Is NAME LOCKING sufficient for session variables?
>
> A best practice in CF is to always lock session
> variable access, but it's not really clear whether
>   1) NAME locking is sufficient or
>   2) should we always lock with SCOPE=SESSION?
>
> To me, the answer seems to depend on how shared memory
> is managed in CF. If session scope memory is managed
> as an entire block, then we have to use SCOPE=SESSION,
> because different user sessions can corrupt each
> other. On the other hand, if session scope memory is
> managed variable by variable, then we only need to
> worry that a single variable is not simultaneously
> accessed by two different threads, in which case a
> NAME lock would be sufficient.


I always assumed that setting a lock of scope=session implied that only one
particular user session was being locked.  Is that not the case?  Does CF
lock every current session established on the server?

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

RE: CF-Flash

[Phil Costa]

You might also try some of the approaches discussed here:
http://www.macromedia.com/software/coldfusion/resources/flash_coldfusion/.
Click on the tutorials and sample components. There are lots of less
complicated ways to integrate the two than the component kit.

Phil

> -Original Message-
> From: nagraj [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, November 22, 2001 9:13 AM
> To: CF-Talk
> Subject: Re: CF-Flash
> 
> 
> Hai Dave,
> 
> Thanks,then I will give one more try to configure the Flash 
> Development Kit
> with Coldfusion
> 
> With Regards
> Nagaraj.A
> 
> - Original Message -
> From: "David Hannum (Ohio University)" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, November 22, 2001 6:21 PM
> Subject: Re: CF-Flash
> 
> 
> > Hello Nagaraj.A
> >
> > Flash is not a server.  Flash (Flash Player) is 1) a 
> plug-in for browsers
> > and 2) a development tool for creating the .swf files that the Flash
> Player
> > plays. (SWF is open, so you can use other tools to create 
> them)  You don't
> > need anything for your server.  You need to code your pages 
> so that the
> swf
> > file is downloaded to the browser (much the same as an image or Java
> Applet
> > are) and the browser's Flash Plug in then handles the rest.
> >
> > Dave
> >
> >
> >
> > - Original Message -
> > From: "nagraj" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Thursday, November 22, 2001 6:18 AM
> > Subject: CF-Flash
> >
> >
> > > Hai ,
> > >
> > > I had downloaded the flash component kit from 
> macromedia.Can  anybody
> tell
> > > wether we need to have
> > > flash loaded at server to make flash component run.I am 
> even having
> > trouble
> > > in making it activated.
> > >
> > > Can any body help me.
> > >
> > > Any help is really appreciable.
> > >
> > > Regards
> > > Nagaraj.A
> > >
> > 
> 
~~
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: CF_Forum Source

[Robert Long]

Just wanted to point out that the CF Forum product (www.cfcode.com) 
is in no way related to the allaire forum product.

-Original Message-
From: Tony Schreiber [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 22, 2001 4:11 PM
To: CF-Talk
Subject: RE: CF_Forum Source


Yes, the forumspot.org software was previously sold by Allaire, before
being open-sourced. There were many complaints from users who had bought
that software and failed to get decent support from Allaire (presumably
because noone there had written it perhaps) and I think that was of the
not-so-official reasons for o/s'ing it. But what I remember is that
original software was developed by someone other than Allaire.

> >From the forumspot web site:
>
> "In the true spirit of Open Source initiatives, Allaire Corp. has modified
> the Allaire Forums license agreement to allow the Forums Open Source
> software to be freely redistributable, allow modification and allow
> distribution of those modifications. It is our hope that by making
> enhancements to Allaire Forums in the form of an "open source" initiative,
> the Forums product will continue to evolve and become a compliment to the
> huge number of ColdFusion add-on products."
>
> >>> [EMAIL PROTECTED] 11/21/01 01:34PM >>>
> I recall that Allaire did market and sell a Forum product, sold for around
> $275.00 from memory.
>
> Mike Brunt
> Sempra Energy
> 213.244.5226
>
> "Prediction is hard, especially when it's about the future."
>
>
> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 21, 2001 1:31 PM
> To: CF-Talk
> Subject: RE: CF_Forum Source
>
>
> > > http://www.forumspot.org/
> > >
> > > Open source free forum originally developed by Allaire.
> >
> > I don't think it was originally developed by Allaire, actually...
>
> I may very well be wrong, but I think it was. It's been around for quite a
> while, though, so I'm not sure.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
>
>
> 

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

OT: domain name registration

[Won Lee]

Is there a site that has price and service comparison of domain name
registras?

Won
~~
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: Is name locking sufficient for session vars?

[Jim McAtee]

- Original Message -
From: "cf refactoring" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 26, 2001 9:09 AM
Subject: Is name locking sufficient for session vars?


> There's something that's been buggin me:
>
> Is NAME LOCKING sufficient for session variables?
>
> A best practice in CF is to always lock session
> variable access, but it's not really clear whether
>   1) NAME locking is sufficient or
>   2) should we always lock with SCOPE=SESSION?
>
> To me, the answer seems to depend on how shared memory
> is managed in CF. If session scope memory is managed
> as an entire block, then we have to use SCOPE=SESSION,
> because different user sessions can corrupt each
> other. On the other hand, if session scope memory is
> managed variable by variable, then we only need to
> worry that a single variable is not simultaneously
> accessed by two different threads, in which case a
> NAME lock would be sufficient.


I always assumed that setting a lock of scope=session implied that only one
particular user session was being locked.  Is that not the case?  Does CF
lock every current session established on the server?

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

RE: Composite primary key and INNER JOIN syntax

[Andy Ewings]

SELECT acs.ownerid, sts.siteid, sts.sitename
FROM Accounts acc
INNER JOIN AccountSites acs ON (acc.AccountID = acs.AccountID)
INNER JOIN Sites sts ON (acs.OwnerID = sts.OwnerID)
WHERE acs.Accountid = 

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



-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: 26 November 2001 16:06
To: CF-Talk
Subject: Composite primary key and INNER JOIN syntax


Does anyone know the SQL to retrieve the OwnerID, SiteID and SiteName given
a single AccountID value using the INNER JOIN syntax? (don't want to use =
in the WHERE clause) Thanks if you can help!


Accounts

AccountID PK
FullName

AccountSites

AccountID  }
OwnerID } Composite PK
SiteID }

Sites

OwnerID   }
SiteID   } Composite PK
SiteName


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



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

Is name locking sufficient for session vars?

[cf refactoring]

There's something that's been buggin me:

Is NAME LOCKING sufficient for session variables?

A best practice in CF is to always lock session
variable access, but it's not really clear whether
  1) NAME locking is sufficient or 
  2) should we always lock with SCOPE=SESSION?

To me, the answer seems to depend on how shared memory
is managed in CF. If session scope memory is managed
as an entire block, then we have to use SCOPE=SESSION,
because different user sessions can corrupt each
other. On the other hand, if session scope memory is
managed variable by variable, then we only need to
worry that a single variable is not simultaneously
accessed by two different threads, in which case a
NAME lock would be sufficient.

Are there any MACROMEDIA folks out there who know
enough about CFAS internals to answer this?

=
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer


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

Composite primary key and INNER JOIN syntax

[Aidan Whitehall]

Does anyone know the SQL to retrieve the OwnerID, SiteID and SiteName given
a single AccountID value using the INNER JOIN syntax? (don't want to use =
in the WHERE clause) Thanks if you can help!


Accounts

AccountID PK
FullName

AccountSites

AccountID  }
OwnerID } Composite PK
SiteID }

Sites

OwnerID   }
SiteID   } Composite PK
SiteName


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