Re: enumerating variables

[Richard Meredith-Hardy]

Thanks everyone - getClientVariablesList() of course only returns
non-readonly client variables so my debug script does in fact have
another section similar to below where I loop thru a list like this:  

They don't seem to be in a structure like application,cgi vars Etc  and
have to be addressed directly.

Server variables I don't mind about as I never use them, but ordinary
variables.variables ?  

These are scoped only to the script being executed so there doesn't seem
to me to be any more security implications in being able to enumerate
them than session or client vars - I just don't seem to be able to
'grab' the names.  

It would be dead handy to be able to quickly cfinclude a debug script at
any point in a script to see the current state. (rather than
cfoutputting the problem var by hand which is what I usually have to
resort to)



> Date: Thu, 15 Mar 2001 16:06:41 -0500
> From: "Jon Hall" <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Re: enumerating variables
> Message-ID: <02a301c0ad93$d5761fa0$a41f88d8@ns2>
> 
> Server variables are not available for security reason. Client variables are
> retrieveable with getClientVariableList().
> 
> jon
> - Original Message -
> From: "Richard Meredith-Hardy" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, March 15, 2001 3:09 PM
> Subject: enumerating variables
> 
> 
> > With my debug script I can enumerate most system variables thus:
> >
> >
> > 
> > 
> > 
> > 
> > 
> > #struct# variables:
> > 
> > #var#:
> > 
> > A structure
> > 
> > An array
> > 
> > A query
> > 
> > #structfind(evaluate(struct),var)#
> > 
> > 
> > 
> > 
> > 
> > 
> > #struct# not defined 
> > 
> > 
> >
> >
> > But
> >
> > server.variables, client.variables and variables.variables don't seem to
> > be accessible at all in the method above or any other 'automated' way
> > (try adding them to structlist);  - is there a way of enumerating them
> > all at the end of a page?

--
Regards;

Richard Meredith-Hardy
-
[EMAIL PROTECTED]
Tel: + 44 (0)1462 834776 FAX: + 44 (0)1462 732668

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

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

RE: 'unknown exception condition' Causing CRASH

[Windle, Kevan]

I got this as a result of a bad sql query using up resources.

-Original Message-
From: David Berger [mailto:[EMAIL PROTECTED]]
Sent: 14 March 2001 20:37
To: CF-Talk
Subject: 'unknown exception condition' Causing CRASH


For the past 2 days, we've been experiencing Cold Fusion crashes.  This is 
the error in the Application Log:

'unknown exception condition' 
CodeRuntimeContextImp::executeSQLTagCFQuery::endTag

Does anybody know what could cause this?  ...and why is it crashing 
ColdFusion (have to reboot the server to get the service to start back up)?

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

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

RE: Philips Edit Form

[Philip Arnold - ASP]

> Yep, in the source code I'm getting this:
> deann [EMAIL PROTECTED]
>
> Where x = drive letter on our web server.
> Not so good.

Dag, I'll look into it...

Which web server?

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

"Websites for the real world"

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



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

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

RE: Form Fields cleared on Back

[Philip Arnold - ASP]

> I did a little testing, and the issue (at least for me) was the
> direction of
> the slash.
>
> So:
> variables.thisTemplateName=ListLast(CGI.CF_TEMPLATE_PATH,"/");
>
> Is fine, while:
> variables.thisTemplateName=ListLast(CGI.CF_TEMPLATE_PATH,"\");
>
> Pulls the local file structure (as there is not occurence of the list
> delimiter, it pulls the whole thing). (Same thing happens on our
> production server.)

D'OH! I knew I was missing something very simple...

New version with a few additions later today...

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

"Websites for the real world"

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



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

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

Re: 'unknown exception condition' Causing CRASH

[Sean Renet]

Are you running SQL on the same box?
- Original Message -
From: "Windle, Kevan" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 16, 2001 1:14 AM
Subject: RE: 'unknown exception condition' Causing CRASH


> I got this as a result of a bad sql query using up resources.
>
> -Original Message-
> From: David Berger [mailto:[EMAIL PROTECTED]]
> Sent: 14 March 2001 20:37
> To: CF-Talk
> Subject: 'unknown exception condition' Causing CRASH
>
>
> For the past 2 days, we've been experiencing Cold Fusion crashes.  This is
> the error in the Application Log:
>
> 'unknown exception condition'
> CodeRuntimeContextImp::executeSQLTagCFQuery::endTag
>
> Does anybody know what could cause this?  ...and why is it crashing
> ColdFusion (have to reboot the server to get the service to start back
up)?
>
> Thanks,
> David Berger
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

OT: Window open doesnt work in netscape - why?

[Michael Kear]

The following piece of code opens a nice sized window with scroll bars in
IE, but in Netscape 4.7 I get a large window, with no scrollbars.  I guess
I've got an error in my javascript ... can anyone see what's wrong?




Cheers,
Mike Kear
Windsor, NSW, Australia
AFP Webworks.



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

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

My Form Editor

[Philip Arnold - ASP]

OK, it's now got an instruction page and some more validating and options

http://www.aspmedia.co.uk/CF/_EditForm.zip

Any comments/feedback appreciated as it can only enhance it

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

"Websites for the real world"

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




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

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

Re: cfinclude security

[Bud]

On 3/15/01, Jon Hall penned:
>Does anyone know of a work around for cfinclude in a shared hosting
>environment? Maybe a few guidelines?
>Because, if there is a way to limit a top root directory for cfinclude, it
>is not obvious to me...

The easiest way is to not make the path contain a variable.



as opposed to:





If it must be done this way, you could do:



Or do a cfif pathtodocument contains "../" and cflocation them to 
some porn site somwhere. :)

Just make sure you make all your included documents at or below the 
template that's calling the include so you never need to enter ../ in 
your variable.
-- 

Bud Schneehagen - Tropical Web Creations

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

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

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

Re: cfinclude security

[Bud]

On 3/15/01, Jon Hall penned:
>Does anyone know of a work around for cfinclude in a shared hosting
>environment? Maybe a few guidelines?
>Because, if there is a way to limit a top root directory for cfinclude, it
>is not obvious to me...

I just realized you are probably talking about stopping cf developers 
from including a file from someone else's website. I think you'd need 
Enterprise and sandbox security in place for that.
-- 

Bud Schneehagen - Tropical Web Creations

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

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

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

RE: XML

[DeVoil, Nick]

> Let me point out a very good reason NOT to use CF for XML.
> When you get XML, you have to compare it to your DTD and
> then parse it to get the data out. 

Pedantic point: you only have to look at the DTD if you need
to validate the XML. No need to otherwise.

As regards parsers, I've used MSXML with CF quite a bit and
it works fine.

Nick


**
Information in this email is confidential and may be privileged. 
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**

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

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

RE: XML

[bflynn]

Cool - this is a good thing to know.  I'll keep it for future reference.

Brian

-Original Message-
From: Marc Garrett [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 15, 2001 6:03 PM
To: CF-Talk
Subject: Re: XML


<[EMAIL PROTECTED]> wrote

> So, short summary - there are no existing CF parsers for XML (that I know
> of...if I'm wrong, someone please correct me).  Handling XML is pretty
> process intensive, and lets be honest, thats not really CF's strong point.

Brian,

The custom tag CF_SOXML is very easy to use and relies on the MSXML parser,
which almost any up-to-date Windows server will have. You only have to pass
it a few parameters -- the xml file, the xsl file, and the desired action.

Regards,

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

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

RE: XML

[bflynn]

Thanks - I don't see why you'd want to use XML without validating it.  That
just seems like you're asking for problems.

Since Windows web servers are pretty much verboten here, the MSXML parser
doesn't sound like much use.  Also probably explains why I'm not familiar
with it.

Different thread coming as a followup

Brian


-Original Message-
From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 7:34 AM
To: CF-Talk
Subject: RE: XML


> Let me point out a very good reason NOT to use CF for XML.
> When you get XML, you have to compare it to your DTD and
> then parse it to get the data out. 

Pedantic point: you only have to look at the DTD if you need
to validate the XML. No need to otherwise.

As regards parsers, I've used MSXML with CF quite a bit and
it works fine.

Nick


**
Information in this email is confidential and may be privileged. 
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: XML

[James Maltby]

If you want to know more then http along to www.xmlarena.com/?pp as it hosts
loads of tools, info and downloadable books in pdf version.

James

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 16 March 2001 12:37
To: CF-Talk
Subject: RE: XML


Cool - this is a good thing to know.  I'll keep it for future reference.

Brian

-Original Message-
From: Marc Garrett [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 15, 2001 6:03 PM
To: CF-Talk
Subject: Re: XML


<[EMAIL PROTECTED]> wrote

> So, short summary - there are no existing CF parsers for XML (that I know
> of...if I'm wrong, someone please correct me).  Handling XML is pretty
> process intensive, and lets be honest, thats not really CF's strong point.

Brian,

The custom tag CF_SOXML is very easy to use and relies on the MSXML parser,
which almost any up-to-date Windows server will have. You only have to pass
it a few parameters -- the xml file, the xsl file, and the desired action.

Regards,

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

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

RE: exploiting shopping carts

[Aidan Whitehall]

> Any data from the browser is subject to tampering. You can't rely on
> HTTP_REFERER - that's sent by the browser, and thus subject 
> to the same sort
> of tampering as the form fields.


Then can you suggest the best way of tackling this situation...

 - website, basket and pre-checkout on one server
 - basket or orders table in database, each basket record tied to a
session.userid value
 - secure payment area / checkout on another server
 - no database access from secure server to database on main website server

How can you make the basket / orders data tied to a user, together with the
prices for the products, accessible to the checkout section without
including them as hidden form fields which, obviously can be tampered with?

I've seen one solution where a text file was written on the unsecure server
and the filename passed as a form field to the secure area. The checkout
just CFHTTPed the text file, parsed out the order / product data and
displayed the totals... not an ideal way of doing it but seemed reasonably
effective.



Thanks in advance

-- 
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services

http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651

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

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

looping qty form input box in shopping cart table using cfoutput

[megan sherman]

Hi,
I am trying to build a shopping cart table that displays a customer's
intended purchases from a temporary database holding that information.
Each item and its description and cost get put on their own line in the
table using cfoutput. I'm trying to provide a form input box for the
quantity on each line so the customer can change the quantity. This is
not working. The only way I've gotten it to work is to put an "update
quantity" submit button on each line. I want a single image submit
button at the bottom to update any modified quantities all at once. Can
anybody understand what I'm trying to do enough to help me?
Thanks in advance,
Megan



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

Re: looping qty form input box in shopping cart table using cfoutput

[Phoeun Pha]

why wasnt it working before?  what happened?
- Original Message - 
From: megan sherman <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Friday, March 16, 2001 8:27 AM
Subject: looping qty form input box in shopping cart table using cfoutput


> Hi,
> I am trying to build a shopping cart table that displays a customer's
> intended purchases from a temporary database holding that information.
> Each item and its description and cost get put on their own line in the
> table using cfoutput. I'm trying to provide a form input box for the
> quantity on each line so the customer can change the quantity. This is
> not working. The only way I've gotten it to work is to put an "update
> quantity" submit button on each line. I want a single image submit
> button at the bottom to update any modified quantities all at once. Can
> anybody understand what I'm trying to do enough to help me?
> Thanks in advance,
> Megan
> 
> 
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists


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

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

cflock and file access

[Jay Brushett]

>Hi,
>
>I'm trying to remove all of the images from a directory and then remove the
>directory.
>But I keep getting an error saying the directory is not empty since the os
>is still deleting the files.
>I know I can use cflock to accomplish this but I'm not sure how.
>
>Thanks,
>
>Jay

< > < > < > < > < Strategy ~ Creativity ~ Technology > < > < > < > < > < >

Jay Brushett
[EMAIL PROTECTED]

Developer

< ZeddComm Inc. >
2nd Floor, The Tower | 100 Signal Hill Road
St. John's, Newfoundland | Canada A1A 1B3
Main: 709.570.5669 | Fax: 709.739.9003
Web: www.zeddcomm.com
< > < > < > < St. John's ~ Toronto ~ Newport Beach ~ Ottawa > < > < > < >



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

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

RE: looping qty form input box in shopping cart table using cfoutput

[Dylan Bromby]

probably if she knew why it *wasn't* working she'd be able to make it work.

but here's what i've done in the past to do this:

let's say i have 10 rows on each page. i use CFLOOP FROM="1" TO="10"
INDEX="count". then let's say i have a TEXT field in each row. assuming
there's a unique ID in the database for each record, i would name each field
NAME="var_#num#" and VALUE="#ID#" so that i would have var_1...var_10. the
VALUE of each of these would be the respective unique ID.

then at the bottom put your image submit button. to handle the update, use
CFLOOP again FROM="1" TO="10" INDEX="num" and over EACH iteration, do
something like CFSET temp = "var_"&#num# and then CFSET temp =
#Evaluate(temp)# and that will give you the VALUE of each variable from the
form so you can UPDATE your DB in each iteration of this CFLOOP.

hope that makes sense. works really well for me.



-Original Message-
From: Phoeun Pha [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 15, 2001 6:26 AM
To: CF-Talk
Subject: Re: looping qty form input box in shopping cart table using
cfoutput


why wasnt it working before?  what happened?
- Original Message -
From: megan sherman <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Friday, March 16, 2001 8:27 AM
Subject: looping qty form input box in shopping cart table using cfoutput


> Hi,
> I am trying to build a shopping cart table that displays a customer's
> intended purchases from a temporary database holding that information.
> Each item and its description and cost get put on their own line in the
> table using cfoutput. I'm trying to provide a form input box for the
> quantity on each line so the customer can change the quantity. This is
> not working. The only way I've gotten it to work is to put an "update
> quantity" submit button on each line. I want a single image submit
> button at the bottom to update any modified quantities all at once. Can
> anybody understand what I'm trying to do enough to help me?
> Thanks in advance,
> Megan
>
>
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: looping qty form input box in shopping cart table using cfoutput

[Dylan Bromby]

in the first CFLOOP below my INDEX should be num or i should've used #count#
instead of #var# in each iteration.

blah. you can figure it out.

-Original Message-
From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 6:39 AM
To: CF-Talk
Subject: RE: looping qty form input box in shopping cart table using
cfoutput


probably if she knew why it *wasn't* working she'd be able to make it work.

but here's what i've done in the past to do this:

let's say i have 10 rows on each page. i use CFLOOP FROM="1" TO="10"
INDEX="count". then let's say i have a TEXT field in each row. assuming
there's a unique ID in the database for each record, i would name each field
NAME="var_#num#" and VALUE="#ID#" so that i would have var_1...var_10. the
VALUE of each of these would be the respective unique ID.

then at the bottom put your image submit button. to handle the update, use
CFLOOP again FROM="1" TO="10" INDEX="num" and over EACH iteration, do
something like CFSET temp = "var_"&#num# and then CFSET temp =
#Evaluate(temp)# and that will give you the VALUE of each variable from the
form so you can UPDATE your DB in each iteration of this CFLOOP.

hope that makes sense. works really well for me.



-Original Message-
From: Phoeun Pha [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 15, 2001 6:26 AM
To: CF-Talk
Subject: Re: looping qty form input box in shopping cart table using
cfoutput


why wasnt it working before?  what happened?
- Original Message -
From: megan sherman <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Friday, March 16, 2001 8:27 AM
Subject: looping qty form input box in shopping cart table using cfoutput


> Hi,
> I am trying to build a shopping cart table that displays a customer's
> intended purchases from a temporary database holding that information.
> Each item and its description and cost get put on their own line in the
> table using cfoutput. I'm trying to provide a form input box for the
> quantity on each line so the customer can change the quantity. This is
> not working. The only way I've gotten it to work is to put an "update
> quantity" submit button on each line. I want a single image submit
> button at the bottom to update any modified quantities all at once. Can
> anybody understand what I'm trying to do enough to help me?
> Thanks in advance,
> Megan
>
>
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Efficiency Question

[Christian N. Abad]

Hello, All!

I have a quick question :

I am currently working on a ColdFusion application for a client of mine, and
had a question about efficiency.

Scenario :

I have dozens of news articles, how-to guides, etc. that are all text-based
and currently stored in a db in memo fields.  These articles could be
accessed often, and the same user may view several of these in one sitting
(session).

Question :

What is the most efficient way to access this info?

1) Create a session-scoped array to store the titles and copy for the
articles. (Running the query only once.)

2) Simply cache the query.

3) Let the user hit the db every time the page loads and they request a
document.

My goal here is to maximize efficiency and minimize db access.  I imagine
that if I have dozens of simultaneous users, that creating session arrays
might be taxing to the server.  Conversely, if I hit the db server every
time the user requests an article, is this excessive?

Setup :

ColdFusion 4.5 Server
Access 2000 (development)
SQL Server (production)

Any ideas, thoughts or comments?

Thanks in Advance!

Christian N. Abad
ColdFusion Developer


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

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

OT: Sites that rate ISP's

[Daniel J O'Keefe]

Does anybody know of any sites that rate ColdFusion Hosting services? I am
aware of Ben Forta's.

Dan

--
Dan O'Keefe
TriPoint Technologies
[EMAIL PROTECTED]
954.675.3115


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

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

RE: Efficiency Question

[alistair . davidson]

Off the top of my head, I'd say you're probably best with option 2

-Original Message-
From: Christian N. Abad [mailto:[EMAIL PROTECTED]]
Sent: 16 March 2001 15:04
To: CF-Talk
Subject: Efficiency Question


Hello, All!

I have a quick question :

I am currently working on a ColdFusion application for a client of mine, and
had a question about efficiency.

Scenario :

I have dozens of news articles, how-to guides, etc. that are all text-based
and currently stored in a db in memo fields.  These articles could be
accessed often, and the same user may view several of these in one sitting
(session).

Question :

What is the most efficient way to access this info?

1) Create a session-scoped array to store the titles and copy for the
articles. (Running the query only once.)

2) Simply cache the query.

3) Let the user hit the db every time the page loads and they request a
document.

My goal here is to maximize efficiency and minimize db access.  I imagine
that if I have dozens of simultaneous users, that creating session arrays
might be taxing to the server.  Conversely, if I hit the db server every
time the user requests an article, is this excessive?

Setup :

ColdFusion 4.5 Server
Access 2000 (development)
SQL Server (production)

Any ideas, thoughts or comments?

Thanks in Advance!

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

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

RE: Efficiency Question

[Terry Bader]

question: does the text change often?
I wouldn't think so, but just in case...  
if no, then #3 is out...

I would say no to #1 because if you have multiple users accessing the same
document, then each will have their own session variable with same info.

So, unless the text changes often (less then 15 minutes), I would cache the
queries

This way even in a multi-user situation, the document is only  stored in one
place in memory...  


Terry Bader
IT/Web Specialist
EDO Corp - Combat Systems
(757) 424-1004 ext 361 - Work
[EMAIL PROTECTED]   


(757)581-5981 - Mobile
[EMAIL PROTECTED]
icq: 5202487   aim: lv2bounce
http://www.cs.odu.edu/~bader






> -Original Message-
> From: Christian N. Abad [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 16, 2001 10:04 AM
> To: CF-Talk
> Subject: Efficiency Question
> 
> 
> Hello, All!
> 
> I have a quick question :
> 
> I am currently working on a ColdFusion application for a 
> client of mine, and
> had a question about efficiency.
> 
> Scenario :
> 
> I have dozens of news articles, how-to guides, etc. that are 
> all text-based
> and currently stored in a db in memo fields.  These articles could be
> accessed often, and the same user may view several of these 
> in one sitting
> (session).
> 
> Question :
> 
> What is the most efficient way to access this info?
> 
> 1) Create a session-scoped array to store the titles and copy for the
> articles. (Running the query only once.)
> 
> 2) Simply cache the query.
> 
> 3) Let the user hit the db every time the page loads and they 
> request a
> document.
> 
> My goal here is to maximize efficiency and minimize db 
> access.  I imagine
> that if I have dozens of simultaneous users, that creating 
> session arrays
> might be taxing to the server.  Conversely, if I hit the db 
> server every
> time the user requests an article, is this excessive?
> 
> Setup :
> 
> ColdFusion 4.5 Server
> Access 2000 (development)
> SQL Server (production)
> 
> Any ideas, thoughts or comments?
> 
> Thanks in Advance!
> 
> Christian N. Abad
> ColdFusion Developer
> 
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: SQL 7 to SQL 2000 Cost

[Aidan Whitehall]

Ask Bud Shenanigans on this list (sorry, can't remember his real surname).
He's recently been through the mill with SQL Server licences... might have
picked up some info on upgrading too.


And this is some info the network admin here sent me the other day... might
be useful:


http://www.microsoft.com/sql/productinfo/pricing.htm

This gives him the answer (SQL 2000). I used to go through this quite often,
basically if he has CAL's (Client Access Licences) and Server and an
Internet Connector Licence, he should be bombproof

Note_ http://www.microsoft.com/sql/productinfo/70pricing.htm

Internet Connector
The Internet Connector is a license that allows an unlimited number of
devices used by Internet users access to SQL Server via your site. An
"Internet user" is any person currently connected to the Internet, other
than a person employed by you (as an employee, independent contractor, or in
any other capacity), or otherwise providing goods or services to you or on
your behalf. You must purchase an Internet Connector License for each
processor on each server that is running SQL Server or SQL Server Enterprise
Edition. 



-- 
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services

http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651

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

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

OT: Need some quick help

[Ben Forta]

Hi all,

I need some quick help from developers using anyone the following with CF (I
need one of each):

 - Netscape Enterprise Server on NT
 - Netscape Enterprise Server on Solaris
 - Apache on NT
 - Apache on Linux
 - Apache on Solaris
 - Anyone using CF via the CGI interface (on any platform)

I won't take much of your time, I'll need you to run a single CFM request
and forward some results to me.

Please reply to me directly (off list).

Thanks!

--- Ben

==
Ben Forta - Allaire Corporation
  E-Mail:   [EMAIL PROTECTED]
  Phone:(248)424-8420
  Fax:  (248)424-8421
  Allaire:  http://www.allaire.com/
  Personal: http://www.forta.com/

WAP is hot! Want to know more? You need "The WAP Book" - go to
http://www.thewapbook.com/ for more info!


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

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

You should hire this guy!!

[Nathan Stanford]

 <> 


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

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

RE: Need some quick help

[DeVoil, Nick]

apache on NT

-Original Message-
From: Ben Forta [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 3:22 PM
To: CF-Talk
Subject: OT: Need some quick help


Hi all,

I need some quick help from developers using anyone the following with CF (I
need one of each):

 - Netscape Enterprise Server on NT
 - Netscape Enterprise Server on Solaris
 - Apache on NT
 - Apache on Linux
 - Apache on Solaris
 - Anyone using CF via the CGI interface (on any platform)

I won't take much of your time, I'll need you to run a single CFM request
and forward some results to me.

Please reply to me directly (off list).

Thanks!

--- Ben

==
Ben Forta - Allaire Corporation
  E-Mail:   [EMAIL PROTECTED]
  Phone:(248)424-8420
  Fax:  (248)424-8421
  Allaire:  http://www.allaire.com/
  Personal: http://www.forta.com/

WAP is hot! Want to know more? You need "The WAP Book" - go to
http://www.thewapbook.com/ for more info!
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

OT: RE: Need some quick help: Sorry

[DeVoil, Nick]

 too quick on the button


**
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system. 
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone. 
Thank you for your co-operation.
**

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

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

Re: Efficiency Question

[Mark Woods]

>1) Create a session-scoped array to store the titles and copy for the
>articles. (Running the query only once.)

Nah, messy, and with multiple sessions running you might run into 
unexpected problems with available memory resources. If you've gonna go 
this far, save hard copies of the articles (or even the large data fields) 
every time they are inserted/updated into the content management system or 
something. This is an excellent solution for sites which need to use a 
database to store data, but where that data is rarely updated.


>2) Simply cache the query.

Probably the simplest method, though you can do far more with CF caching 
than just the query. Have a read of:
http://www.allaire.com/Handlers/index.cfm?ID=19470&Method=Full&Cache=Off


>3) Let the user hit the db every time the page loads and they request a
>document.

Well, if the data is liable to change regularly this is probably the best 
solution, tied in with some query caching to improve performance perhaps.


Mark


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

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

RE: looping qty form input box in shopping cart table using cfout put

[Phoeun Pha]

just wanted to clarify my question "Why wasn't it working".  what i meant
was, what errors did it show, or what did it do wrong.

-Original Message-
From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 8:39 AM
To: CF-Talk
Subject: RE: looping qty form input box in shopping cart table using
cfoutput


probably if she knew why it *wasn't* working she'd be able to make it work.

but here's what i've done in the past to do this:

let's say i have 10 rows on each page. i use CFLOOP FROM="1" TO="10"
INDEX="count". then let's say i have a TEXT field in each row. assuming
there's a unique ID in the database for each record, i would name each field
NAME="var_#num#" and VALUE="#ID#" so that i would have var_1...var_10. the
VALUE of each of these would be the respective unique ID.

then at the bottom put your image submit button. to handle the update, use
CFLOOP again FROM="1" TO="10" INDEX="num" and over EACH iteration, do
something like CFSET temp = "var_"&#num# and then CFSET temp =
#Evaluate(temp)# and that will give you the VALUE of each variable from the
form so you can UPDATE your DB in each iteration of this CFLOOP.

hope that makes sense. works really well for me.



-Original Message-
From: Phoeun Pha [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 15, 2001 6:26 AM
To: CF-Talk
Subject: Re: looping qty form input box in shopping cart table using
cfoutput


why wasnt it working before?  what happened?
- Original Message -
From: megan sherman <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Friday, March 16, 2001 8:27 AM
Subject: looping qty form input box in shopping cart table using cfoutput


> Hi,
> I am trying to build a shopping cart table that displays a customer's
> intended purchases from a temporary database holding that information.
> Each item and its description and cost get put on their own line in the
> table using cfoutput. I'm trying to provide a form input box for the
> quantity on each line so the customer can change the quantity. This is
> not working. The only way I've gotten it to work is to put an "update
> quantity" submit button on each line. I want a single image submit
> button at the bottom to update any modified quantities all at once. Can
> anybody understand what I'm trying to do enough to help me?
> Thanks in advance,
> Megan
>
>
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Sites that rate ISP's

[Brian Thornton]

internet.com
- Original Message -
From: "Daniel J O'Keefe" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 16, 2001 8:09 AM
Subject: OT: Sites that rate ISP's


> Does anybody know of any sites that rate ColdFusion Hosting services? I am
> aware of Ben Forta's.
>
> Dan
>
> --
> Dan O'Keefe
> TriPoint Technologies
> [EMAIL PROTECTED]
> 954.675.3115
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Need some quick help

[Terry Bader]

"Please reply to me directly (off list)."

just observing


Terry Bader
IT/Web Specialist
EDO Corp - Combat Systems
(757) 424-1004 ext 361 - Work
[EMAIL PROTECTED]   


(757)581-5981 - Mobile
[EMAIL PROTECTED]
icq: 5202487   aim: lv2bounce
http://www.cs.odu.edu/~bader






> -Original Message-
> From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 16, 2001 10:35 AM
> To: CF-Talk
> Subject: RE: Need some quick help
> 
> 
> apache on NT
> 
> -Original Message-
> From: Ben Forta [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 16, 2001 3:22 PM
> To: CF-Talk
> Subject: OT: Need some quick help
> 
> 
> Hi all,
> 
> I need some quick help from developers using anyone the 
> following with CF (I
> need one of each):
> 
>  - Netscape Enterprise Server on NT
>  - Netscape Enterprise Server on Solaris
>  - Apache on NT
>  - Apache on Linux
>  - Apache on Solaris
>  - Anyone using CF via the CGI interface (on any platform)
> 
> I won't take much of your time, I'll need you to run a single 
> CFM request
> and forward some results to me.
> 
> Please reply to me directly (off list).
> 
> Thanks!
> 
> --- Ben
> 
> ==
> Ben Forta - Allaire Corporation
>   E-Mail:   [EMAIL PROTECTED]
>   Phone:(248)424-8420
>   Fax:  (248)424-8421
>   Allaire:  http://www.allaire.com/
>   Personal: http://www.forta.com/
> 
> WAP is hot! Want to know more? You need "The WAP Book" - go to
> http://www.thewapbook.com/ for more info!
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: exploiting shopping carts

[Dave Watts]

> > Any data from the browser is subject to tampering. You can't 
> > rely on HTTP_REFERER - that's sent by the browser, and thus 
> > subject to the same sort of tampering as the form fields.
> 
> Then can you suggest the best way of tackling this situation...
> 
>  - website, basket and pre-checkout on one server
>  - basket or orders table in database, each basket record tied to a
> session.userid value
>  - secure payment area / checkout on another server
>  - no database access from secure server to database on main 
> website server
> 
> How can you make the basket / orders data tied to a user, 
> together with the prices for the products, accessible to the 
> checkout section without including them as hidden form fields 
> which, obviously can be tampered with?
> 
> I've seen one solution where a text file was written on the 
> unsecure server and the filename passed as a form field to the 
> secure area. The checkout just CFHTTPed the text file, parsed 
> out the order / product data and displayed the totals... not 
> an ideal way of doing it but seemed reasonably effective.

As in your example, you'd have to use CFHTTP or some other communication
mechanism between your CF server (as the client) and the payment server.
That's really the only way.

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

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

Re: You should hire this guy!!

[Clint Tredway]

There was not anything attached... :)

--
Clint Tredway
www.factorxsoftware.com
--

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

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

RE: You should hire this guy!!

[Philip Arnold - ASP]

>  <>

You do know that the CF-Talk list trims out all attachment and HTML format
emails, don't you?

Try a hyperlink

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

"Websites for the real world"

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



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

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

RE: Efficiency Question

[alistair . davidson]

I guess we're agreed on 2) then..

Your best bet is probably to cache the query, but every time the text is
changed, rerun the query with cachedwithin="#CreateTimeSpan(0,0,0,0)#". This
will force the query to refresh at that point, but be cached from the next
time it's accessed.

This is an effective, simple approach to the situation where the data is
accessed much more often than it's updated (as I assume is the case with
you)



-Original Message-
From: Mark Woods [mailto:[EMAIL PROTECTED]]
Sent: 16 March 2001 15:29
To: CF-Talk
Subject: Re: Efficiency Question



>1) Create a session-scoped array to store the titles and copy for the
>articles. (Running the query only once.)

Nah, messy, and with multiple sessions running you might run into 
unexpected problems with available memory resources. If you've gonna go 
this far, save hard copies of the articles (or even the large data fields) 
every time they are inserted/updated into the content management system or 
something. This is an excellent solution for sites which need to use a 
database to store data, but where that data is rarely updated.


>2) Simply cache the query.

Probably the simplest method, though you can do far more with CF caching 
than just the query. Have a read of:
http://www.allaire.com/Handlers/index.cfm?ID=19470&Method=Full&Cache=Off


>3) Let the user hit the db every time the page loads and they request a
>document.

Well, if the data is liable to change regularly this is probably the best 
solution, tied in with some query caching to improve performance perhaps.


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

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

Re: Control Panels for Remote Administration of Datasources for multiple clients

[Brian Thornton]

hostpilot by intermedia is by far the best. ive used verios, interland,
cfhostingss.. http://hosting.intermedia.net go through the demo.
- Original Message -
From: "Jason Larson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 15, 2001 3:02 PM
Subject: RE: Control Panels for Remote Administration of Datasources for
multiple clients


> Daryl,
>
> One of the best controlpanels that I have seen is at
> http://iroquois.cosmotek.net/mycontrol/login.asp. I have just begun to do
> some hosting myself, and eventually want to resell my services on the web
> (give about 12 months though). check it out, it is pretty cool.
>
> Jason
>
> -Original Message-
> From: Daryl Fullerton [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 15, 2001 2:18 PM
> To: CF-Talk
> Subject: Control Panels for Remote Administration of Datasources for
> multiple clients
>
>
> Hi all
>
> We are opening up our servers in Hosting division for clients to
> remotely administrate datasources.
>
> Up to now we relied on email messages or phone for client requests for
> datasource additions / alterations.
>
> Just wondering what everyones views are on control panels and which ones
> they have experience with from security points of view.
>
> Anyone recocommend or got preferences.
>
> Thanks
>
> D
>
>
> Daryl Fullerton,
> Managing Partner,
> BizNet Solutions,
> Allaire Premier Partner (Ireland)
> 133 - 137 Lisburn Road
> Belfast
> BT9 7AG
> N.Ireland
>
> Direct +44 (0) 28 9022 7888
> Tel  +44 (0) 028 9022 3224
> Fax +44 (0) 028 9022 3223
>
>
> [EMAIL PROTECTED]
> Http://www.BizNet-Solutions.com
>
> [EMAIL PROTECTED] (Chairman)
> Http://www.cfug.ie The Irish Cold Fusion User Group
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

MS Access97 on Solaris 8

[Troy Simpson]

I've noticed on the product support matrix that Sun Solaris supports
ODBC connections.  Does this include MS Access97 on Sun Solaris8?

I have been requested to determine if this configuration is possible for
our small departmental apps.  The requirements are: 1. run ColdFusion
Enterprise on a Sun Solaris8 system; 2. store and query MS Access97
database files on the Sun Solaris8 system.

Is this possible and supported.

Thanks,
Troy

--
Troy Simpson | North Carolina State University
NCSU Libraries | Campus Box 7111 | Raleigh | North Carolina
ph.919.515.3855 | fax.919.513.3330



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

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

SQL 2000 (enterprise manager)

[Jay Patton]

quick sql 2000 question.
I just upgraded to windows 2000 pro on my development machine, i was originally 
running win98 and had sql 7.0 Enterprise manager running on that. however after my 
upgrade to 2k i couldn't connect to my sql servers with that same software any longer. 
last night i downloaded the evaluation version of sql 2000 and with that i connected 
to the servers fine however now whenever i go to open the database folder to view my 
db the enterprise manager quits responding and i have to kill the program. has this 
happened to anyone else? or does anyone have any ideas why this might be happening?

Thanks,

Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com


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

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

OT: PWS not starting at boot up

[Aidan Whitehall]

A while ago I think I was messing about with PWS (can't remember the
details) and as a result, PWS doesn't start at boot up. Prior to that, it
was automatically loading and serving pages.

I've gone through the settings, incl the Advanced tab ("Ha! What a misnomer
*that* is!) but can't find anything that tells it to start on boot-up. Also,
just sticking the PWS icon in the Startup folder just launches the PWS
Manager window.

Anyone got any ideas? Apart from me not tinkering with software and screwing
it up?...



Thanks

-- 
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services

http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651

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

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

RE: Need some quick help

[Kevin Gilchrist]

Hi Ben,

We have CF 4.5.2 on Netscape Enterprise Server on Solaris 2.7 on a private
test box Sun E-250.  
What did you have in mind?

- Kevin

-Original Message-
From: Ben Forta [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 10:22 AM
To: CF-Talk
Subject: OT: Need some quick help


Hi all,

I need some quick help from developers using anyone the following with CF (I
need one of each):

 - Netscape Enterprise Server on NT
 - Netscape Enterprise Server on Solaris
 - Apache on NT
 - Apache on Linux
 - Apache on Solaris
 - Anyone using CF via the CGI interface (on any platform)

I won't take much of your time, I'll need you to run a single CFM request
and forward some results to me.

Please reply to me directly (off list).

Thanks!

--- Ben

==
Ben Forta - Allaire Corporation
  E-Mail:   [EMAIL PROTECTED]
  Phone:(248)424-8420
  Fax:  (248)424-8421
  Allaire:  http://www.allaire.com/
  Personal: http://www.forta.com/

WAP is hot! Want to know more? You need "The WAP Book" - go to
http://www.thewapbook.com/ for more info!
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Recall: Need some quick help

[Kevin Gilchrist]

Kevin Gilchrist would like to recall the message, "Need some quick help".

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

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

RE: Efficiency Question

[Christian N. Abad]

Thanks, everyone for the input!

#2 it is...

Cheers,

Christian

-Original Message-
From: Christian N. Abad [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 10:04 AM
To: CF-Talk
Subject: Efficiency Question


Hello, All!

I have a quick question :

I am currently working on a ColdFusion application for a client of mine, and
had a question about efficiency.

Scenario :

I have dozens of news articles, how-to guides, etc. that are all text-based
and currently stored in a db in memo fields.  These articles could be
accessed often, and the same user may view several of these in one sitting
(session).

Question :

What is the most efficient way to access this info?

1) Create a session-scoped array to store the titles and copy for the
articles. (Running the query only once.)

2) Simply cache the query.

3) Let the user hit the db every time the page loads and they request a
document.

My goal here is to maximize efficiency and minimize db access.  I imagine
that if I have dozens of simultaneous users, that creating session arrays
might be taxing to the server.  Conversely, if I hit the db server every
time the user requests an article, is this excessive?

Setup :

ColdFusion 4.5 Server
Access 2000 (development)
SQL Server (production)

Any ideas, thoughts or comments?

Thanks in Advance!

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

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

is eq or is not

[John McCosker]

Hi some days,, uhh

I seem to be struggling with this today and just can't sort it out, so
simple yet so difficult mmm.


SELECT  uid
FROMdbo.users
WHERE   uid = '#session.checkMilfordLogin#'


I'm just running this query so I can block out a login user from certain
functions of secured site.

so I 'm saying 


  



go ahed and to the business

Done this before but I have forgot

Thanx very much in advance

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

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

RE: PWS not starting at boot up

[Adkins, Randy]

Depends on the platform your running.

WIN NT/2000: 
Check the Services tab in the control Panel
Make sure it is set to Automatic

WIN 95/98:
You will need to place it in the STARTUP folder.

I am not sure if there is a command line parameter
or anything for WIN95/98 to make it automatically
be in the ready mode for serving webpages.



-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 11:01 AM
To: CF-Talk
Subject: OT: PWS not starting at boot up


A while ago I think I was messing about with PWS (can't remember the
details) and as a result, PWS doesn't start at boot up. Prior to that, it
was automatically loading and serving pages.

I've gone through the settings, incl the Advanced tab ("Ha! What a misnomer
*that* is!) but can't find anything that tells it to start on boot-up. Also,
just sticking the PWS icon in the Startup folder just launches the PWS
Manager window.

Anyone got any ideas? Apart from me not tinkering with software and screwing
it up?...



Thanks

-- 
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services

http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: exploiting shopping carts

[Steve Martin]

Worldpay have what is known as a 'data fetch' method whereby when you enter
the payment system you pass in a cart ID. The payment system then does the
equivalent of a CFHTTP to a URL on your site that you predefine in the
payment system administration pages passing the cart ID as a parameter. You
can then use this parameter to identify the appropriate cart, which you
would typically store in an application array of structs keyed on the cart
ID, and pass the info back to the payment system in whatever format it
requires. I dare say this is an approach adopted by other payment systems
too though I haven't really explored many others recently.

Steve

>
> > > Any data from the browser is subject to tampering. You can't
> > > rely on HTTP_REFERER - that's sent by the browser, and thus
> > > subject to the same sort of tampering as the form fields.
> >
> > Then can you suggest the best way of tackling this situation...
> >
> >  - website, basket and pre-checkout on one server
> >  - basket or orders table in database, each basket record tied to a
> > session.userid value
> >  - secure payment area / checkout on another server
> >  - no database access from secure server to database on main
> > website server
> >
> > How can you make the basket / orders data tied to a user,
> > together with the prices for the products, accessible to the
> > checkout section without including them as hidden form fields
> > which, obviously can be tampered with?
> >
> > I've seen one solution where a text file was written on the
> > unsecure server and the filename passed as a form field to the
> > secure area. The checkout just CFHTTPed the text file, parsed
> > out the order / product data and displayed the totals... not
> > an ideal way of doing it but seemed reasonably effective.
>
> As in your example, you'd have to use CFHTTP or some other communication
> mechanism between your CF server (as the client) and the payment server.
> That's really the only way.
>
> 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

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

Remote COM Objects

[Nick McClure]

Does anybody have any experience with using Remote COM Objects?

is there a big performance difference?

What happens when the remote COM object changes?

and help or documentation here would be great.


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

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

RE: PWS not starting at boot up

[Larry Juncker]

I looked in my registry and found the following:

HKEY_LOCAL_MACHINE
  Software
Microsoft
  Windows
CurrentVersion
  Run
PWSTray  "PWSTray.exe"

My PWS loads and runs automatically using these settings.  I do not know if
this is what causes it to auto run or not, but I am having to assume that
this is the reason.

Hope this helps

Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.


-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 10:01 AM
To: CF-Talk
Subject: OT: PWS not starting at boot up


A while ago I think I was messing about with PWS (can't remember the
details) and as a result, PWS doesn't start at boot up. Prior to that, it
was automatically loading and serving pages.

I've gone through the settings, incl the Advanced tab ("Ha! What a misnomer
*that* is!) but can't find anything that tells it to start on boot-up. Also,
just sticking the PWS icon in the Startup folder just launches the PWS
Manager window.

Anyone got any ideas? Apart from me not tinkering with software and screwing
it up?...



Thanks

--
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services

http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Remote COM Objects

[Andy Ewings]

Yup I have experiece but not using CF to call them but using VB instead.
You have to use DCOM (distributed COM).  If the COM object changes it will
get recompiled and re-registered so when your app creates an instance of the
object these changes will be reflected.  It's been a while since I looked at
DCOM but if I remeber correctly the COM object must be out of process i.e.
it is a .exe (runs in it's own process space) as opposed to a dll.

As far as performance goes it all depends on what the COM object does.  If
it throws back loads of data to your app then I guess there will be a
performance hit otherwise I can't see it being an issue.

-- 
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: Nick McClure [mailto:[EMAIL PROTECTED]]
Sent: 16 March 2001 16:30
To: CF-Talk
Subject: Remote COM Objects


Does anybody have any experience with using Remote COM Objects?

is there a big performance difference?

What happens when the remote COM object changes?

and help or documentation here would be great.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Extract Information from a word doc for DB Insertion via CF

[Larry Juncker]

Can someone tell me if there is a custom tag or a setting to use with
CFDIRECTORY or CFFILE that I can use to parse data from a word doc to insert
into a DSN.  All I get using a script is a 5 character encrypted code.

Thanks

Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.


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

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

RE: Remote COM Objects

[Dave Watts]

> Does anybody have any experience with using Remote COM Objects?

I've done a little DCOM stuff.

> is there a big performance difference?

It depends. Typically, when you use DCOM, you might have a centralized
DCOM/MTS server, and all your web servers talk to that server. Just like
with any other non-local service, there's a price to pay for network
traffic, but the reward may be worth it from a management perspective.

If, on the other hand, you want to have remote distributed services all over
the place, DCOM will be very slow for that. That's really the big impetus
for things like SOAP and Web Services - they work better over larger
networks.

> What happens when the remote COM object changes?

Typically, when using something like MTS, whether locally or remotely,
you'll end up cycling services when objects change.

> and help or documentation here would be great.

You might search on http://msdn.microsoft.com/.

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

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

RE: Remote COM Objects

[Stewart McGowan]

http://www.microsoft.com/com/tech/dcom.asp


for some background reading...


Regards


Stew

> --
> From: Nick McClure
> Reply To: [EMAIL PROTECTED]
> Sent: Friday, March 16, 2001 4:30 pm
> To:   CF-Talk
> Subject:  Remote COM Objects
> 
> Does anybody have any experience with using Remote COM Objects?
> 
> is there a big performance difference?
> 
> What happens when the remote COM object changes?
> 
> and help or documentation here would be great.
> 
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

escaping #'s

[Melissa Fraher]

I have a text area that submits to a message board and sends out an
email to subscribers.  When a user enters a # in the body of the message
it causes an error.

How do you escape # signs?

Here is the code that I tried:


Here is the error that I get:
Error Occurred While Processing Request

 Error Diagnostic Information

 Just in time compilation error

 Invalid parser construct found on line 99 at position 35. ColdFusion
was looking at the following text:

 "

 Invalid expression format. The usual cause is an error in the
expression structure.

Does anyone know how to get around this?

Thanks.

Melissa


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

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

RE: Extract Information from a word doc for DB Insertion via CF

[Dylan Bromby]

try using CFFILE to place the content of the Word doc into a CF variable and
parse from there. just point to the .doc using the FILE attribute of CFFILE.

-Original Message-
From: Larry Juncker [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 8:50 AM
To: CF-Talk
Subject: Extract Information from a word doc for DB Insertion via CF


Can someone tell me if there is a custom tag or a setting to use with
CFDIRECTORY or CFFILE that I can use to parse data from a word doc to insert
into a DSN.  All I get using a script is a 5 character encrypted code.

Thanks

Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: escaping #'s

[Top-Link Tech (John Ceci)]

Melissa,

try this:



HTH,
John

-Original Message-
From: Melissa Fraher [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 11:00 AM
To: CF-Talk
Subject: escaping #'s


I have a text area that submits to a message board and sends out an
email to subscribers.  When a user enters a # in the body of the message
it causes an error.

How do you escape # signs?

Here is the code that I tried:


Here is the error that I get:
Error Occurred While Processing Request

 Error Diagnostic Information

 Just in time compilation error

 Invalid parser construct found on line 99 at position 35. ColdFusion
was looking at the following text:

 "

 Invalid expression format. The usual cause is an error in the
expression structure.

Does anyone know how to get around this?

Thanks.

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

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

encryption of form & url variables

[nagesh]

Hi all,

Is there any way to encrypt the urls and hidden form variables so that no one could 
able to see even if they open either viewsource or pointing the cursor to the link.

I know by using encrypt(), decrypt() functions we can do that but the problem is when 
we want to send the hidden form variables to the next page, and some of the variables 
thru the link . how can we do that?

thanx in advance
nagesh



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

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

RE: Efficiency Question

[paul smith]

Nice reference.  Thanks!

However, the article comes close but does not come right out and say it.
I guess if I understood what "P-Code" meant I'd get it.

Not being a P-Code maven, does P-Code Caching mean the CF template
is processed to the point where it can still be used to house dynamic content?

I assume it means this.  Otherwise, what's the point?

best,  paul

At 03:47 PM 3/16/01 +, you wrote:
>Probably the simplest method, though you can do far more with CF caching
>than just the query. Have a read of:
>http://www.allaire.com/Handlers/index.cfm?ID=19470&Method=Full&Cache=Off


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

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

RE: escaping #'s

[Philip Arnold - ASP]

> I have a text area that submits to a message board and sends out an
> email to subscribers.  When a user enters a # in the body of the message
> it causes an error.
>
> How do you escape # signs?
>
> Here is the code that I tried:
> 
>
> Here is the error that I get:
> Error Occurred While Processing Request
>
>  Error Diagnostic Information
>
>  Just in time compilation error
>
>  Invalid parser construct found on line 99 at position 35. ColdFusion
> was looking at the following text:
>
>  "
>
>  Invalid expression format. The usual cause is an error in the
> expression structure.
>
> Does anyone know how to get around this?

You have to escape the #s within the replace



And will people PLEASE read Ben's "To # or not to #"

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

"Websites for the real world"

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



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

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

RE: Extract Information from a word doc for DB Insertion via CF

[Larry Juncker]

I tried that and keep getting a message CONNECTION FAILURE

I even typed the URL manually to test it.  The title of the files have
spaces in them, could that be what is causing the errors?

Thanks

Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.


-Original Message-
From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 10:54 AM
To: CF-Talk
Subject: RE: Extract Information from a word doc for DB Insertion via CF


try using CFFILE to place the content of the Word doc into a CF variable and
parse from there. just point to the .doc using the FILE attribute of CFFILE.

-Original Message-
From: Larry Juncker [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 8:50 AM
To: CF-Talk
Subject: Extract Information from a word doc for DB Insertion via CF


Can someone tell me if there is a custom tag or a setting to use with
CFDIRECTORY or CFFILE that I can use to parse data from a word doc to insert
into a DSN.  All I get using a script is a 5 character encrypted code.

Thanks

Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Remote COM Objects

[Stewart McGowan]

>If, on the other hand, you want to have remote distributed services all
over
>the place, DCOM will be very slow for that. That's really the big impetus
>for things like SOAP and Web Services - they work better over larger
>networks.


and XML-RPC, as of yet i don't think there's a client or a server for
CF...??

Stew



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

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

RE: Efficiency Question

[Philip Arnold - ASP]

> However, the article comes close but does not come right out and say it.
> I guess if I understood what "P-Code" meant I'd get it.
>
> Not being a P-Code maven, does P-Code Caching mean the CF template
> is processed to the point where it can still be used to house
> dynamic content?
>
> I assume it means this.  Otherwise, what's the point?

P-Code is what CF compiles the templates into - if you have the templates
cached then it reads them out of memory

If you turn on Trusted Cache, then it'll never look for newer versions of
the template, so it runs even faster

Put the Template Cache up (fairly) big, and let the server do what it has to

Rule of thumb on template cache size - double the size of all of your
templates... this give CF room for maneuvering and it should never have to
remove items from cache

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

"Websites for the real world"

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



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

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

Re: SQL 2000 (enterprise manager)

[Sean Daniels]

On 3/16/01 11:03 AM Jay Patton wrote:

> I just upgraded to windows 2000 pro on my development machine, i was
> originally running win98 and had sql 7.0 Enterprise manager running on that.
> however after my upgrade to 2k i couldn't connect to my sql servers with that
> same software any longer. last night i downloaded the evaluation version of
> sql 2000 and with that i connected to the servers fine however now whenever i
> go to open the database folder to view my db the enterprise manager quits
> responding and i have to kill the program. has this happened to anyone else?
> or does anyone have any ideas why this might be happening?

I haven't tried the SQL 2000 enterprise manager yet, but I use SQL 7
Enterprise Manager all the time on my Windows 2000 pro machine. You might
just try reinstalling those.

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

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

RE: escaping #'s

[Stewart McGowan]

at

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

just in case you don't know

Stew

>And will people PLEASE read Ben's "To # or not to #"
>Philip Arnold


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

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

RE: White space

[Lanny R. Udey]

Our tag must be a lot more efficient or our boxes faster because our times are a lot 
better. This may have been because we had Allaire help us optimize it.- here are some 
examples:

admissions home page: 219 ms
alumni home page: 78 ms 
athletics home page: 203 ms

Ours also work fine on Spectra sites with Javascript etc. - these are spectra pages 
that had LOTS of white space.

Lanny Udey
Associate Dean
Learning and Information Technology
Hofstra University

>>> [EMAIL PROTECTED] Thursday, March 15, 2001 >>>
I agree on the savings that it can achieve, but again at what cost.

If it ends up adding (and yes I have seen this) say 2000 ms in a very big
site that has hundreds of cfm files. Would this 2 seconds be better of
getting the information to the client, than trying to remove whitespace!

But as Philip said it is personal preference:-)


-Original Message-
From: Lanny R. Udey [mailto:[EMAIL PROTECTED]] 
Sent: 16 March 2001 14:06
To: CF-Talk
Subject: RE: White space


If you cache a lot of your pages like we do, then getting rid of the white
space is a big savings. This is particularly true if you have a lot of
people accessing your pages through modems via AOL etc. The saving on
download time on a 33 Kbs modem is substantial. We cut page sizes down from
40 K to 8K and that is after we used all the proper coding techniques.

Lanny Udey
Hofstra University






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

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

RE: You should hire this guy!!

[Eric Dawson]

http://www.shitdisturber.net/

I posted the ad. I'm not using the site yet.

Eric


From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
Subject: RE: You should hire this guy!!
Date: Fri, 16 Mar 2001 15:42:03 -

 >  <>

You do know that the CF-Talk list trims out all attachment and HTML format
emails, don't you?

Try a hyperlink

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

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: encryption of form & url variables

[Bryan Laplante]

do you mean you want to send search var's on the url string?

link
Never tried that before let me know if it works.

-- Original Message --
From: "nagesh" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Fri, 16 Mar 2001 11:58:23 -0500

Hi all,

Is there any way to encrypt the urls and hidden form variables so that no one could 
able to see even if they open either viewsource or pointing the cursor to the link.

I know by using encrypt(), decrypt() functions we can do that but the problem is when 
we want to send the hidden form variables to the next page, and some of the variables 
thru the link . how can we do that?

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

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

RE: My Form Editor

[Philip Arnold - ASP]

Just a little note that isn't in my docs and was pointed out to me

Don't put the Identity field into the FieldList - it's assumed to be there

I'll update the docs this weekend (incuding more examples)

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

"Websites for the real world"

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


> -Original Message-
> From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
> Sent: 16 March 2001 10:34
> To: CF-Talk
> Subject: My Form Editor
>
>
> OK, it's now got an instruction page and some more validating and options
>
> http://www.aspmedia.co.uk/CF/_EditForm.zip
>
> Any comments/feedback appreciated as it can only enhance it
>
> Philip Arnold
> Director
> Certified ColdFusion Developer
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
>
> "Websites for the real world"
>
> **
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> **
>
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: escaping #'s

[Aidan Whitehall]

> http://www.defusion.com/articles/index.cfm?ArticleID=26
> just in case you don't know

or point them to
http://www.thenetprofits.co.uk/coldfusion/faq/#answer89
and
http://www.thenetprofits.co.uk/coldfusion/faq/#answer111



-- 
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services

http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651

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

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

Re: SQL 2000 (enterprise manager)

[Jay Patton]

Acually i just got off the phone with an SQL Administrator at interland and
they say that SQL 2000 (Enterprise Manager) will connect to SQL 7.0 Server
but it wont open the database folder. so i reinstalled SQL 7.0 and for
whatever reason it connected fine this time, i didnt change or do anything
differantly on my end at all so the reason i didnt get connected the first
time i guess ill never find out.

Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
- Original Message -
From: "Sean Daniels" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 16, 2001 10:17 AM
Subject: Re: SQL 2000 (enterprise manager)


> On 3/16/01 11:03 AM Jay Patton wrote:
>
> > I just upgraded to windows 2000 pro on my development machine, i was
> > originally running win98 and had sql 7.0 Enterprise manager running on
that.
> > however after my upgrade to 2k i couldn't connect to my sql servers with
that
> > same software any longer. last night i downloaded the evaluation version
of
> > sql 2000 and with that i connected to the servers fine however now
whenever i
> > go to open the database folder to view my db the enterprise manager
quits
> > responding and i have to kill the program. has this happened to anyone
else?
> > or does anyone have any ideas why this might be happening?
>
> I haven't tried the SQL 2000 enterprise manager yet, but I use SQL 7
> Enterprise Manager all the time on my Windows 2000 pro machine. You might
> just try reinstalling those.
>
> - Sean
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

SAX in CF? Other ideas?

[Edward Smith]

Hey all,

I have a situation where I want to duplicate an application written in
Java using CF.

The application uses XML documents as templates, and executes
functionality based on tags in the XML.

For instance, the XML template might look like this:


 


The Java app uses a SAX parser to parse the template, which fires off an
event for each tag.

When the parser sees the "page" tag, it runs the PAGE java class, which
goes off into the database and gets page info, etc. and spits out more
XML to the output stream.

Same for the article tag, which calls the ARTICLE class., etc.

How would one go about doing this in CF?  I'm not sure there would be
any way to integrate a SAX parser into CF, so I'm not sure of how to do
this.

What I'd like to do is parse the template and execute CF custom tags for
each tag.

If I could rewrite the templates, I'd do something like:


 


and CFINCLUDE them into the page to get executed.

But, I can't rewrite the templates, and the templates come from the
database, not the filesystem.

Speed/efficiency is the primary motivation, so a RegExp replace, and
writing the file to the filesystem isn't really an option..

Any ideas?

Thanks in advance!
-- 
Edward Smith  Internet Broadcasting System
Director of Architecture  http://www.ibsys.com

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

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

RE: Extract Information from a word doc for DB Insertion via CF

[Dylan Bromby]

are you referencing it as a URL or a file path? try it as a file path.

-Original Message-
From: Larry Juncker [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 9:18 AM
To: CF-Talk
Subject: RE: Extract Information from a word doc for DB Insertion via CF


I tried that and keep getting a message CONNECTION FAILURE

I even typed the URL manually to test it.  The title of the files have
spaces in them, could that be what is causing the errors?

Thanks

Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.


-Original Message-
From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 10:54 AM
To: CF-Talk
Subject: RE: Extract Information from a word doc for DB Insertion via CF


try using CFFILE to place the content of the Word doc into a CF variable and
parse from there. just point to the .doc using the FILE attribute of CFFILE.

-Original Message-
From: Larry Juncker [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 8:50 AM
To: CF-Talk
Subject: Extract Information from a word doc for DB Insertion via CF


Can someone tell me if there is a custom tag or a setting to use with
CFDIRECTORY or CFFILE that I can use to parse data from a word doc to insert
into a DSN.  All I get using a script is a 5 character encrypted code.

Thanks

Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: escaping #'s

[John Wilker]

What also works, that I've done is to replace the #'s with the ASCII char.
That way you don't have to worry about whether it'll end up being properly
escaped or not. When it's displayed the browser will translate the Char into
a Pound

The ASCII char for # is #

My code was 

That way your db just has an ASCII value where ever a pound was. Seems to
work pretty well in my app.

Hope that helps too

J.

John Wilker
Web Applications Consultant
Allaire Certified ColdFusion Developer

Office: 909-943-8428
www.billtracker.org 


-Original Message-
From: Top-Link Tech (John Ceci) [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 9:58 AM
To: CF-Talk
Subject: RE: escaping #'s


Melissa,

try this:



HTH,
John

-Original Message-
From: Melissa Fraher [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 11:00 AM
To: CF-Talk
Subject: escaping #'s


I have a text area that submits to a message board and sends out an
email to subscribers.  When a user enters a # in the body of the message
it causes an error.

How do you escape # signs?

Here is the code that I tried:


Here is the error that I get:
Error Occurred While Processing Request

 Error Diagnostic Information

 Just in time compilation error

 Invalid parser construct found on line 99 at position 35. ColdFusion
was looking at the following text:

 "

 Invalid expression format. The usual cause is an error in the
expression structure.

Does anyone know how to get around this?

Thanks.

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

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

RE: encryption of form & url variables

[Ledwith, Brian]

Nagesh,

Just yesterday I used the following:

On source page:

str = '#trim(QueryName.Password)#';
key = 'YourKeyHere';
encStr = urlencodedformat(encrypt(str,key));



On LoginReminder.cfm

str = '#url.Password#';
key = 'YourKeyHere';
decStr = urlencodedformat(decrypt(str,key));



HTH,
~Brian




-Original Message-
From: nagesh [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 11:58 AM
To: CF-Talk
Subject: encryption of form & url variables


Hi all,

Is there any way to encrypt the urls and hidden form variables so that no
one could able to see even if they open either viewsource or pointing the
cursor to the link.

I know by using encrypt(), decrypt() functions we can do that but the
problem is when we want to send the hidden form variables to the next page,
and some of the variables thru the link . how can we do that?

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

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

RE: Efficiency Question

[Dave Watts]

> Rule of thumb on template cache size - double the size of all 
> of your templates... this give CF room for maneuvering and it 
> should never have to remove items from cache

You might need more than that - the Allaire recommendations have gone from
3x file size to 5x!

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

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

RE: SQL 2000 (enterprise manager)

[John Wilker]

I've got SQL 2k on Win2k and have no probs. Didn't have any with SQL 7 on
Win2k.

You will however have problems with SQL 7 EM trying to talk to SQL 2k
databases I believe. Though the reverse works just fine.

J.

John Wilker
Web Applications Consultant
Allaire Certified ColdFusion Developer

Office: 909-943-8428
www.billtracker.org 


-Original Message-
From: Sean Daniels [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 9:17 AM
To: CF-Talk
Subject: Re: SQL 2000 (enterprise manager)


On 3/16/01 11:03 AM Jay Patton wrote:

> I just upgraded to windows 2000 pro on my development machine, i was
> originally running win98 and had sql 7.0 Enterprise manager running on
that.
> however after my upgrade to 2k i couldn't connect to my sql servers with
that
> same software any longer. last night i downloaded the evaluation version
of
> sql 2000 and with that i connected to the servers fine however now
whenever i
> go to open the database folder to view my db the enterprise manager quits
> responding and i have to kill the program. has this happened to anyone
else?
> or does anyone have any ideas why this might be happening?

I haven't tried the SQL 2000 enterprise manager yet, but I use SQL 7
Enterprise Manager all the time on my Windows 2000 pro machine. You might
just try reinstalling those.

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

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

RE: exploiting shopping carts

[Aidan Whitehall]

> Worldpay have what is known as a 'data fetch' method whereby 
> when you enter
> the payment system you pass in a cart ID. The payment system 
> [ snip ]

Great - thanks for all the info.

CFHTTP it is, then.



-- 
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services

http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651

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

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

RE: Extract Information from a word doc for DB Insertion via CF

[Larry Juncker]

Dylan;

I am using the following:



with #FileRoot# = f:\websites\larry\aljcompserv\HumboldtMLS\$40k+\
and #Name# = Th - 426 Dear St. $45k.doc

Also I have tried replaceing the first period in the name with CHR(46) and
that did not help.  I then renamed the file with taking the pfirst period
out of it.

The template when run results in the following:

f:\websites\larry\aljcompserv\HumboldtMLS/$40k+/Th - 426 Dear St $45k.doc
ÐÏࡱ

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

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

CF rules!!!

[Phoeun Pha]

CF, in this case, means Caffeine!!!  I've been up all night writing code and
today almost drove off a freeway going 75mph  ack!  i'm crazy!  but now
I'm wide awake!!  hold up, my fingers are twitching!  ahh!!!

anyhow, that CF thingy in houston wednesday night with ben Forta was cool.
he had a pretty cool accent too.  I can't wait to start using CF 5, or
NEO!!!  what do u guys think the best thing in CF 5 is?  For me, it's the
user defined functions!

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

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

RE: Extract Information from a word doc for DB Insertion via CF

[Dylan Bromby]

what happens if you hardcode the full path including filename in the FILE
attribute?

-Original Message-
From: Larry Juncker [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 10:22 AM
To: CF-Talk
Subject: RE: Extract Information from a word doc for DB Insertion via CF


Dylan;

I am using the following:



with #FileRoot# = f:\websites\larry\aljcompserv\HumboldtMLS\$40k+\
and #Name# = Th - 426 Dear St. $45k.doc

Also I have tried replaceing the first period in the name with CHR(46) and
that did not help.  I then renamed the file with taking the pfirst period
out of it.

The template when run results in the following:

f:\websites\larry\aljcompserv\HumboldtMLS/$40k+/Th - 426 Dear St $45k.doc
ÐÏࡱ
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: CF rules!!!

[Philip Arnold - ASP]

> CF, in this case, means Caffeine!!!  I've been up all night
> writing code and
> today almost drove off a freeway going 75mph  ack!  i'm
> crazy!  but now
> I'm wide awake!!  hold up, my fingers are twitching!  ahh!!!
>
> anyhow, that CF thingy in houston wednesday night with ben Forta was cool.
> he had a pretty cool accent too.  I can't wait to start using CF 5, or
> NEO!!!  what do u guys think the best thing in CF 5 is?  For me, it's the
> user defined functions!

I must say that the best thing is keeping non-technical conversations in
CF-Community where they belong...

Biggest Bonuses to CF5;
UserDefined Functions (awaiting Beta2)
Query a Query - this is f***ing BRILLIANT
CFFlush
Speed increase!

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

"Websites for the real world"

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



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

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

RE: Extract Information from a word doc for DB Insertion via CF

[Garza, Jeff]

I think that the problem here is that you are dealing with binary data.  I
just tried what you had and got the same results.  

What I did to get around this is to convert the binary word doc to a string
using the ToBase64() command and then inserting that into the DB.  When you
need to retrive the info, get it as a string and then use the ToBinary()
function to convert it bact to a format that word can recognize.  

Then write the binary data to a file (like c:\temp\myworddoc.doc) and use
CFCONTENT to present the data to the user (IE users should automagically
open the file in the browser...) and delete the file when done.  Lots o
work, but it's functional...

HTH

Jeff Garza
Web Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200

[EMAIL PROTECTED]
http://www.spectrumastro.com



-Original Message-
From: Larry Juncker [mailto:[EMAIL PROTECTED]] 
Sent: Friday, March 16, 2001 11:22 AM
To: CF-Talk
Subject: RE: Extract Information from a word doc for DB Insertion via CF


Dylan;

I am using the following:



with #FileRoot# = f:\websites\larry\aljcompserv\HumboldtMLS\$40k+\
and #Name# = Th - 426 Dear St. $45k.doc

Also I have tried replaceing the first period in the name with CHR(46) and
that did not help.  I then renamed the file with taking the pfirst period
out of it.

The template when run results in the following:

f:\websites\larry\aljcompserv\HumboldtMLS/$40k+/Th - 426 Dear St $45k.doc
ÐÏࡱ
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: SQL 2000 (enterprise manager) New Question

[John Wilker]

That actually answers a problem I've been having but haven't had time to
look into completely.

Now my question is, I've got SQL 2k installed and am using that, can I
install 7 and have both EMs? I think I tried a while back and it killed my
EM and I had to reinstall 2k.

Anyone ever done that?

J.


John Wilker
Web Applications Consultant
Allaire Certified ColdFusion Developer

Office: 909-943-8428
www.billtracker.org 


-Original Message-
From: Jay Patton [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 9:32 AM
To: CF-Talk
Subject: Re: SQL 2000 (enterprise manager)


Acually i just got off the phone with an SQL Administrator at interland and
they say that SQL 2000 (Enterprise Manager) will connect to SQL 7.0 Server
but it wont open the database folder. so i reinstalled SQL 7.0 and for
whatever reason it connected fine this time, i didnt change or do anything
differantly on my end at all so the reason i didnt get connected the first
time i guess ill never find out.

Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
- Original Message -
From: "Sean Daniels" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 16, 2001 10:17 AM
Subject: Re: SQL 2000 (enterprise manager)


> On 3/16/01 11:03 AM Jay Patton wrote:
>
> > I just upgraded to windows 2000 pro on my development machine, i was
> > originally running win98 and had sql 7.0 Enterprise manager running on
that.
> > however after my upgrade to 2k i couldn't connect to my sql servers with
that
> > same software any longer. last night i downloaded the evaluation version
of
> > sql 2000 and with that i connected to the servers fine however now
whenever i
> > go to open the database folder to view my db the enterprise manager
quits
> > responding and i have to kill the program. has this happened to anyone
else?
> > or does anyone have any ideas why this might be happening?
>
> I haven't tried the SQL 2000 enterprise manager yet, but I use SQL 7
> Enterprise Manager all the time on my Windows 2000 pro machine. You might
> just try reinstalling those.
>
> - Sean
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: SAX in CF? Other ideas?

[David Gassner]

SAX requires a compiled language - there are implementations for Java, VB
and C++ - so you can't implement SAX parsers directly in CF, a non-compiled
scripting environment.

You could modify the Java classes so they can be called from a CF page; for
this, you have choices of calling them directly with CFOBJECT, modifying
them so they're useable as a Java-based CFX custom tag, or running them on
JRUN and calling them with CFSERVLET.

> -Original Message-
> From: Edward Smith [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 16, 2001 9:36 AM
> To: CF-Talk
> Subject: SAX in CF? Other ideas?
>
>
> Hey all,
>
> I have a situation where I want to duplicate an application written in
> Java using CF.
>
> The application uses XML documents as templates, and executes
> functionality based on tags in the XML.
>
> For instance, the XML template might look like this:
>
> 
>  
> 
>
> The Java app uses a SAX parser to parse the template, which fires off an
> event for each tag.
>
> When the parser sees the "page" tag, it runs the PAGE java class, which
> goes off into the database and gets page info, etc. and spits out more
> XML to the output stream.
>
> Same for the article tag, which calls the ARTICLE class., etc.
>
> How would one go about doing this in CF?  I'm not sure there would be
> any way to integrate a SAX parser into CF, so I'm not sure of how to do
> this.
>
> What I'd like to do is parse the template and execute CF custom tags for
> each tag.
>
> If I could rewrite the templates, I'd do something like:
>
> 
>  
> 
>
> and CFINCLUDE them into the page to get executed.
>
> But, I can't rewrite the templates, and the templates come from the
> database, not the filesystem.
>
> Speed/efficiency is the primary motivation, so a RegExp replace, and
> writing the file to the filesystem isn't really an option..
>
> Any ideas?
>
> Thanks in advance!
> --
> Edward Smith  Internet Broadcasting System
> Director of Architecture  http://www.ibsys.com
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: CF rules!!!

[Phoeun Pha]

come on man, we need some personality in our posts too.  at least i put
something legitimate in it :P



-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 12:40 PM
To: CF-Talk
Subject: RE: CF rules!!!


> CF, in this case, means Caffeine!!!  I've been up all night
> writing code and
> today almost drove off a freeway going 75mph  ack!  i'm
> crazy!  but now
> I'm wide awake!!  hold up, my fingers are twitching!  ahh!!!
>
> anyhow, that CF thingy in houston wednesday night with ben Forta was cool.
> he had a pretty cool accent too.  I can't wait to start using CF 5, or
> NEO!!!  what do u guys think the best thing in CF 5 is?  For me, it's the
> user defined functions!

I must say that the best thing is keeping non-technical conversations in
CF-Community where they belong...

Biggest Bonuses to CF5;
UserDefined Functions (awaiting Beta2)
Query a Query - this is f***ing BRILLIANT
CFFlush
Speed increase!

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

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: CF rules!!!

[John Ellard]

For me, it's the possibility of using this product to earn a living.  I 
agree - you are crazy.  Could we restrict this list to useful contributions 
rather than youthful exuberance please?

My nose is twitching

John



At 12:19 16/03/2001 -0600, you wrote:
>CF, in this case, means Caffeine!!!  I've been up all night writing code and
>today almost drove off a freeway going 75mph  ack!  i'm crazy!  but now
>I'm wide awake!!  hold up, my fingers are twitching!  ahh!!!
>
>anyhow, that CF thingy in houston wednesday night with ben Forta was cool.
>he had a pretty cool accent too.  I can't wait to start using CF 5, or
>NEO!!!  what do u guys think the best thing in CF 5 is?  For me, it's the
>user defined functions!
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: CF rules!!!

[Jon Gage]

No, you really didn't.  It's becoming a habit that you should stop.

> -Original Message-
> From: Phoeun Pha [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 16, 2001 1:42 PM
> To: CF-Talk
> Subject: RE: CF rules!!!
> 
> 
> come on man, we need some personality in our posts too.  at least i put
> something legitimate in it :P
> 
> 
> 
> -Original Message-
> From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 16, 2001 12:40 PM
> To: CF-Talk
> Subject: RE: CF rules!!!
> 
> 
> > CF, in this case, means Caffeine!!!  I've been up all night
> > writing code and
> > today almost drove off a freeway going 75mph  ack!  i'm
> > crazy!  but now
> > I'm wide awake!!  hold up, my fingers are twitching!  ahh!!!
> >
> > anyhow, that CF thingy in houston wednesday night with ben 
> Forta was cool.
> > he had a pretty cool accent too.  I can't wait to start using CF 5, or
> > NEO!!!  what do u guys think the best thing in CF 5 is?  For 
> me, it's the
> > user defined functions!
> 
> I must say that the best thing is keeping non-technical conversations in
> CF-Community where they belong...
> 
> Biggest Bonuses to CF5;
> UserDefined Functions (awaiting Beta2)
> Query a Query - this is f***ing BRILLIANT
> CFFlush
> Speed increase!
> 
> Philip Arnold
> Director
> Certified ColdFusion Developer
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
> 
> "Websites for the real world"
> 
> **
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> **
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: CF rules!!!

[Steve Bernard]

Your adulation of "Query a Query" requires comment. That functionality has
been asked for as far back as version 2.0, to my knowledge. Not that it
isn't a great idea, just nothing new.

Steve

-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 1:40 PM
To: CF-Talk
Subject: RE: CF rules!!!

... 
Biggest Bonuses to CF5;
UserDefined Functions (awaiting Beta2)
Query a Query - this is f***ing BRILLIANT
CFFlush
Speed increase!
 ..

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

"Websites for the real world"

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


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

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

Report

[monika kon]

I have an access table where my webmaster has made
tables as well as queries.
Please tell me can I use these queries of Access
Database in my ColdFusion program --in the tag
 the way the tables are used.
Thanks in advance.
Shally
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Efficiency Question

[mherbene]

FYI - On NT, one of the perfmon stats within the Cold Fusion object is
'Cache Pops/Sec'; if this is anything other than zero, your template cache
size is not big enough and CF is kicking templates out of cache to make room
for new ones.  The performance penalty this causes is significant...

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 12:46 PM
To: CF-Talk
Subject: RE: Efficiency Question


> Rule of thumb on template cache size - double the size of all 
> of your templates... this give CF room for maneuvering and it 
> should never have to remove items from cache

You might need more than that - the Allaire recommendations have gone from
3x file size to 5x!

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

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

RE: Report

[Dave Watts]

> I have an access table where my webmaster has made
> tables as well as queries. Please tell me can I use 
> these queries of Access Database in my ColdFusion 
> program --in the tag  the way the tables 
> are used.

You can call Access queries from CF. If they're not parameter queries, you
can reference them as if they were tables in your CFQUERY. If they are
parameter queries, you can use CFSTOREDPROC to call them.

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

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

RE: CF rules!!!

[Philip Arnold - ASP]

> Your adulation of "Query a Query" requires comment. That functionality has
> been asked for as far back as version 2.0, to my knowledge. Not that it
> isn't a great idea, just nothing new.

OK, my testing on the Beta has increased some of my template runs (the ones
that use 2 or 3 datasources, some on different database types) has cut the
running times down from a couple of minutes to about 20 seconds...

It's not a new idea, but I love that it's there now...

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

"Websites for the real world"

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



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

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

RE: Report

[Terry Bader]

yep...


Terry Bader
IT/Web Specialist
EDO Corp - Combat Systems
(757) 424-1004 ext 361 - Work
[EMAIL PROTECTED]   


(757)581-5981 - Mobile
[EMAIL PROTECTED]
icq: 5202487   aim: lv2bounce
http://www.cs.odu.edu/~bader






> -Original Message-
> From: monika kon [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 16, 2001 2:01 PM
> To: CF-Talk
> Subject: Report
> 
> 
> I have an access table where my webmaster has made
> tables as well as queries.
> Please tell me can I use these queries of Access
> Database in my ColdFusion program --in the tag
>  the way the tables are used.
> Thanks in advance.
> Shally
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Report

[Phoeun Pha]

U mean he's storing queries in an access table?  are they for stored
procedure stuff?

-Original Message-
From: monika kon [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 1:01 PM
To: CF-Talk
Subject: Report


I have an access table where my webmaster has made
tables as well as queries.
Please tell me can I use these queries of Access
Database in my ColdFusion program --in the tag
 the way the tables are used.
Thanks in advance.
Shally
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: CF rules!!!

[John Wilker]

I think that's probably what the adulation was for. It's finally being
included.

J.


John Wilker
Web Applications Consultant
Allaire Certified ColdFusion Developer

Office: 909-943-8428
www.billtracker.org 


-Original Message-
From: Steve Bernard [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 11:00 AM
To: CF-Talk
Subject: RE: CF rules!!!


Your adulation of "Query a Query" requires comment. That functionality has
been asked for as far back as version 2.0, to my knowledge. Not that it
isn't a great idea, just nothing new.

Steve

-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 1:40 PM
To: CF-Talk
Subject: RE: CF rules!!!

 
Biggest Bonuses to CF5;
UserDefined Functions (awaiting Beta2)
Query a Query - this is f***ing BRILLIANT
CFFlush
Speed increase!
 ..

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

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: SQL 7 to SQL 2000 Cost

[Bud]

On 3/16/01, Aidan Whitehall penned:
>Ask Bud Shenanigans on this list (sorry, can't remember his real surname).
>He's recently been through the mill with SQL Server licences... might have
>picked up some info on upgrading too.

LOL

That's closer than most of the telemarketer's get. :)

>What does it cost to upgrade?

Best price I found for the full version with 1 processor license is at:
http://www.mediaOK.com/. Don't know how their upgrade prices compare, 
but you're looking at around 2,800.00+ I believe.

>Do you need to upgrade the Internet connector licensee?

Yes.


-- 

Bud Schneehagen - Tropical Web Creations

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

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

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

Formatting CFQUERY Results in a Table

[James Birchler]

Hi Gang -

I'm building an employee directory, and am adding a page that displays all
employee photos so that if you don't know someone's name, you can find it by
recognizing their face. My query pulls an image url and fname/lastname from
a database.

I'm trying to format the output in table rows, with each row containing 4
table cells (each with one photo displayed).

How do I let CF know when to create another table row? So far I can make one
really long row, or one really long column!

Is the answer on the SQL side (using LIMIT or COUNT) or on the CF side, or
both? Any suggestions much appreciated.

Thanks,

James


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

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

RE: Report

[monika kon]

Hi,
Thanks for your reply.
I have already tried using the query of Access
database in the tag 
which is as follows


SELECT  Date, Total Orders, Average Per Order,
Total Items Sold, Total Dollar Amount Of Sales
FROM 'Sales Totals By Day'

But this gives me the following error:

+++
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access
violation)


[Microsoft][ODBC Microsoft Access 97 Driver] Syntax
error (missing operator) in query expression 'Average
Per Order'.


SQL = "SELECT Date, 'Total Orders', Average Per Order,
Total Items Sold, Total Dollar Amount Of Sales FROM
'Sales Totals By Day'"

Data Source = "SHOPPINGCART"


The error occurred while processing an element with a
general identifier of (CFQUERY), occupying document
position (6:2) to (8:23) in the template file
F:\Www\industrial\report\report1.cfm.


Date/Time: 03/16/01 14:25:58
Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows
NT)
Remote Address: 10.10.6.184
+++
I EVEN ADDED SINGLE CODE AROUND EACH FIELD BUT STILL
THAT GIVES ME ERROR .PLEASE HELP!!!

Thanks
Shally.

--- Dave Watts <[EMAIL PROTECTED]> wrote:
> > I have an access table where my webmaster has made
> > tables as well as queries. Please tell me can I
> use 
> > these queries of Access Database in my ColdFusion 
> > program --in the tag  the way the tables 
> > are used.
> 
> You can call Access queries from CF. If they're not
> parameter queries, you
> can reference them as if they were tables in your
> CFQUERY. If they are
> parameter queries, you can use CFSTOREDPROC to call
> them.
> 
> 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

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

RE: Efficiency Question

[paul smith]

And the default is apparently 10MB not the 1MB noted in Allaire  19740

best,  paul

At 12:45 PM 3/16/01 -0500, you wrote:
> > Rule of thumb on template cache size - double the size of all
> > of your templates... this give CF room for maneuvering and it
> > should never have to remove items from cache
>
>You might need more than that - the Allaire recommendations have gone from
>3x file size to 5x!


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

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

RE: Report

[monika kon]

Hi,
Thanks for your reply.
I have already tried using the query of Access
database in the tag 
which is as follows


SELECT  Date, Total Orders, Average Per Order,
Total Items Sold, Total Dollar Amount Of Sales
FROM 'Sales Totals By Day'

But this gives me the following error:

+++
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access
violation)


[Microsoft][ODBC Microsoft Access 97 Driver] Syntax
error (missing operator) in query expression 'Average
Per Order'.


SQL = "SELECT Date, 'Total Orders', Average Per Order,
Total Items Sold, Total Dollar Amount Of Sales FROM
'Sales Totals By Day'"

Data Source = "SHOPPINGCART"


The error occurred while processing an element with a
general identifier of (CFQUERY), occupying document
position (6:2) to (8:23) in the template file
F:\Www\industrial\report\report1.cfm.


Date/Time: 03/16/01 14:25:58
Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows
NT)
Remote Address: 10.10.6.184
+++
I EVEN ADDED SINGLE CODE AROUND EACH FIELD BUT STILL
THAT GIVES ME ERROR .PLEASE HELP!!!

Thanks
Shally.

--- Dave Watts <[EMAIL PROTECTED]> wrote:
> > I have an access table where my webmaster has made
> > tables as well as queries. Please tell me can I
> use 
> > these queries of Access Database in my ColdFusion 
> > program --in the tag  the way the tables 
> > are used.
> 
> You can call Access queries from CF. If they're not
> parameter queries, you
> can reference them as if they were tables in your
> CFQUERY. If they are
> parameter queries, you can use CFSTOREDPROC to call
> them.
> 
> 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

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

Re: You should hire this guy!!

[monika kon]

WHICH GUY R U TALKING ABOUT
--- Nathan Stanford <[EMAIL PROTECTED]> wrote:
> 
> 
> 
>  <> 
> 
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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