Re: Email server/CF integration?

[Howie Hamlin]

There is no mail server more integrated with ColdFusion than iMS.
www.coolfusion.com/ims.cfm

Regards,

Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
www.CoolFusion.com
631-737-4668 x101
inFusion Mail Server (iMS) - the World's most configurable mail server
Get your free copy of iMS POST-SE Server from CoolFusion!

- Original Message -
From: "Billy Cravens" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 22, 2001 5:03 PM
Subject: Email server/CF integration?


> Doing some research.  What mail servers are fully exposed to
> ColdFusion?  In other words, I want to be able to programatically
> administer the mail server through a web based (programmed in
> ColdFusion, not proprietary) interface.. mail servers that have exposed
> COM interfaces look like the prime candidates at this point.
>
> --
> Billy Cravens
> HR Web Development, Sabre
> [EMAIL PROTECTED]
>
>
~~
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: Strengths of each

[Nick McClure]

In general it would depend on your implementation.

If you query the DB for each set and get it would greatly increase over 
head. But if you run a query in application.cfm to get all of the values 
and set them in a structure and reset values on the page, then in the 
OnRequestEnd.cfm file you could take that structure and update the records 
in the DB, this would only cause two DB hits per GET.

Unfortunately ASP does not have a feature similar to the 
Application.cfm/OnRequestEnd.cfm deal, so I must include files in each page 
to ensure that the code is executed.

At 04:37 PM 2/23/2001 +1100, you wrote:
>I had also started to adoipt something like this, but sometimes time is not
>very kind to some...
>
>Anyway my main concern would be the overheads off pulling this information
>out all the time, yet when I did stop to think about it I would assume the
>overheads would be similar to using client variables and having this stored
>into a datasource...
>
>Would I be right on this?
>
>
>-Original Message-
>From: Nick McClure [mailto:[EMAIL PROTECTED]]
>Sent: 23 February 2001 16:12
>To: CF-Talk
>Subject: RE: Strengths of each
>
>
>One of the things that I have been working on recently is My own
>Session/Application management System.
>
>All variables are stored in the database, VBScript functions and CF Custom
>Tags are used to pull these variables. This system was designed to easily
>be ported to any Language. If for some reason we wanted to add a JSP or C++
>portion to a given application, it could continue to use the same session
>info.
>
>Right now I am in the early development stages, so a lot of stuff has to be
>done twice, but I plan to move most of it into stored procs.
>
>
> >To answer your first question, yes, CF and ASP can coexist on the server,
> >there are no problems having a mix of ColdFusion and ASP pages within a
> >site, however, I'm pretty certain you can forget sharing Session and
> >Application variables between these environments.  But you could pass
> >variables through on URL's.
> >
> >We tend to write CF only sites now, while we used to be mainly ASP
> >developers, however we've never needed to mix the two.
> >
> >Hope this helps a little bit.  Feel free to contact me off list if you have
> >any further questions.
> >
> >Nick
> >
> > > From: "Terry Troxel" <[EMAIL PROTECTED]>
> > > Reply-To: [EMAIL PROTECTED]
> > > Date: Thu, 22 Feb 2001 11:09:31 -0800
> > > To: CF-Talk <[EMAIL PROTECTED]>
> > > Subject: Strengths of each
> > >
> > > I am posing a question that has been rattling around in my mind for
> >awhile.
> > > My host runs on O'Reilly WebSite Pro, so I have zero exposure to IIS and
> > > maybe that is why I m in the dark.
> > > I would like to know if CF and ASP can co-exist and possibly trade data
> >like
> > > CF does with javascript, WAP, etc.
> > >
> > > The second part of my question is if this is possible has anyone
>compiled
> >a
> > > list of what types of procedures, functionality is best handled by
>which.
> > >
> > > If these questions are true then I have to get onto an IIS host, and
>start
> > > learning ASP to broaden my skills. I assume this is the path alot of you
> > > have taken by the frequency of ASP and CF in your signatures.
> > >
> > > Terry Troxel
> > >
> > >
> > >
> >
>
~~
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: Referential Integrity

[David Shadovitz]

Another reason to handle it in the database:
If you do it in your app, you've got to do it in every app that accesses
the database.  If you do it in the database, it's a one-shot deal.
Always try to operate as close to the data as possible.
-David

On Thu, 22 Feb 2001 16:50:59 -0500 "Hal Helms"
<[EMAIL PROTECTED]> writes:
> Cyrill, I think everyone will advise  you to always prefer the 
> database functions--especially when dealing with referential integrity.

> Databases have had almost 40 years with some of the best minds applied
> to them.  They're stable, elegant and fast.
> 
> Hal Helms 
> 
> -Original Message-
> From: Cyrill Vatomsky [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 22, 2001 2:49 PM
> To: CF-Talk
> Subject: Referential Integrity
> 
> HI,
> 
> My question is whether it is better to write CF routines to 
> maintain referential integrity of the database or to set up 
> "Preserve Referential Integrity" rules in MS Access and
> try to catch errors?
~~
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[2]: Strengths of each

[brendan avery]

Hello Nick,

Thursday, February 22, 2001, 9:11:55 PM, you wrote:

> One of the things that I have been working on recently is My own 
> Session/Application management System.

> All variables are stored in the database, VBScript functions and CF Custom 
> Tags are used to pull these variables. This system was designed to easily 
> be ported to any Language. If for some reason we wanted to add a JSP or C++ 
> portion to a given application, it could continue to use the same session info.

> Right now I am in the early development stages, so a lot of stuff has to be 
> done twice, but I plan to move most of it into stored procs.


>>To answer your first question, yes, CF and ASP can coexist on the server,
>>there are no problems having a mix of ColdFusion and ASP pages within a
>>site, however, I'm pretty certain you can forget sharing Session and
>>Application variables between these environments.  But you could pass
>>variables through on URL's.
>>
>>We tend to write CF only sites now, while we used to be mainly ASP
>>developers, however we've never needed to mix the two.
>>
>>Hope this helps a little bit.  Feel free to contact me off list if you have
>>any further questions.
>>
>>Nick
>>
>> > From: "Terry Troxel" <[EMAIL PROTECTED]>
>> > Reply-To: [EMAIL PROTECTED]
>> > Date: Thu, 22 Feb 2001 11:09:31 -0800
>> > To: CF-Talk <[EMAIL PROTECTED]>
>> > Subject: Strengths of each
>> >
>> > I am posing a question that has been rattling around in my mind for
>>awhile.
>> > My host runs on O'Reilly WebSite Pro, so I have zero exposure to IIS and
>> > maybe that is why I m in the dark.
>> > I would like to know if CF and ASP can co-exist and possibly trade data
>>like
>> > CF does with javascript, WAP, etc.
>> >
>> > The second part of my question is if this is possible has anyone compiled
>>a
>> > list of what types of procedures, functionality is best handled by which.
>> >
>> > If these questions are true then I have to get onto an IIS host, and start
>> > learning ASP to broaden my skills. I assume this is the path alot of you
>> > have taken by the frequency of ASP and CF in your signatures.
>> >
>> > Terry Troxel
>> >
>> >
>> >
>>
>
~~
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: Strengths of each

[Scott, Andrew]

I had also started to adoipt something like this, but sometimes time is not
very kind to some...

Anyway my main concern would be the overheads off pulling this information
out all the time, yet when I did stop to think about it I would assume the
overheads would be similar to using client variables and having this stored
into a datasource...

Would I be right on this?


-Original Message-
From: Nick McClure [mailto:[EMAIL PROTECTED]]
Sent: 23 February 2001 16:12
To: CF-Talk
Subject: RE: Strengths of each


One of the things that I have been working on recently is My own 
Session/Application management System.

All variables are stored in the database, VBScript functions and CF Custom 
Tags are used to pull these variables. This system was designed to easily 
be ported to any Language. If for some reason we wanted to add a JSP or C++ 
portion to a given application, it could continue to use the same session
info.

Right now I am in the early development stages, so a lot of stuff has to be 
done twice, but I plan to move most of it into stored procs.


>To answer your first question, yes, CF and ASP can coexist on the server,
>there are no problems having a mix of ColdFusion and ASP pages within a
>site, however, I'm pretty certain you can forget sharing Session and
>Application variables between these environments.  But you could pass
>variables through on URL's.
>
>We tend to write CF only sites now, while we used to be mainly ASP
>developers, however we've never needed to mix the two.
>
>Hope this helps a little bit.  Feel free to contact me off list if you have
>any further questions.
>
>Nick
>
> > From: "Terry Troxel" <[EMAIL PROTECTED]>
> > Reply-To: [EMAIL PROTECTED]
> > Date: Thu, 22 Feb 2001 11:09:31 -0800
> > To: CF-Talk <[EMAIL PROTECTED]>
> > Subject: Strengths of each
> >
> > I am posing a question that has been rattling around in my mind for
>awhile.
> > My host runs on O'Reilly WebSite Pro, so I have zero exposure to IIS and
> > maybe that is why I m in the dark.
> > I would like to know if CF and ASP can co-exist and possibly trade data
>like
> > CF does with javascript, WAP, etc.
> >
> > The second part of my question is if this is possible has anyone
compiled
>a
> > list of what types of procedures, functionality is best handled by
which.
> >
> > If these questions are true then I have to get onto an IIS host, and
start
> > learning ASP to broaden my skills. I assume this is the path alot of you
> > have taken by the frequency of ASP and CF in your signatures.
> >
> > Terry Troxel
> >
> >
> >
>
~~
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: Strengths of each

[Scott, Andrew]

Your right it uses CFHTTP...

The idea is that there is certain information that is added to the generated
content, that can be passed back to the Web Server. Thus allowing for
interaction, what I was looking for was a way to return the variables using
ASP back to CF somehow.

The problem is that as I only know the basics of ASP, so I have no idea if
ASP as the same advantages as CF in being able to get the collection of
variables... If we could then this would be a good way to get the two to
communicate in the one page

btw there are small overheads, and that's because a file has to be created
to be passed to the web server Hope this helps more, if not just ask.


-Original Message-
From: Robert Everland III [mailto:[EMAIL PROTECTED]]
Sent: 23 February 2001 14:43
To: CF-Talk
Subject: RE: Strengths of each


I would have to see what your custom tag is but I would think either you are
using cfhttp to do everythign or you are using wscript. Either way there is
gonna be a way to do it, so if you would be so kind as to send me your code
so that I may evaluate a way to do this.


bob everland

-Original Message-
From: Scott, Andrew [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 22, 2001 6:13 PM
To: CF-Talk
Subject: RE: Strengths of each


Actually you can mix the two, and I have developed a custom tag that can do
something like the following


 <%
  a=1
  b=2
  c=3
 %>


Which would then execute the ASP from within the cfml template, the only
problem is that I haven't found a way to share the result with CF. But I
could do something like the following without any problems.






 <%
  a=1
  b=2
  c=3
  #strTest#
 %>



But I haven't had the time to learn enough about ASP, to take the variables
from ASP tp Coldfusion So if anyone has any ideas to develop this
further I would like to hear from you.



-Original Message-
From: Nick Texidor [mailto:[EMAIL PROTECTED]]
Sent: 23 February 2001 08:02
To: CF-Talk
Subject: Re: Strengths of each


Hi Terry,

To answer your first question, yes, CF and ASP can coexist on the server,
there are no problems having a mix of ColdFusion and ASP pages within a
site, however, I'm pretty certain you can forget sharing Session and
Application variables between these environments.  But you could pass
variables through on URL's.

We tend to write CF only sites now, while we used to be mainly ASP
developers, however we've never needed to mix the two.

Hope this helps a little bit.  Feel free to contact me off list if you have
any further questions.

Nick

> From: "Terry Troxel" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date: Thu, 22 Feb 2001 11:09:31 -0800
> To: CF-Talk <[EMAIL PROTECTED]>
> Subject: Strengths of each
>
> I am posing a question that has been rattling around in my mind for
awhile.
> My host runs on O'Reilly WebSite Pro, so I have zero exposure to IIS and
> maybe that is why I m in the dark.
> I would like to know if CF and ASP can co-exist and possibly trade data
like
> CF does with javascript, WAP, etc.
>
> The second part of my question is if this is possible has anyone compiled
a
> list of what types of procedures, functionality is best handled by which.
>
> If these questions are true then I have to get onto an IIS host, and start
> learning ASP to broaden my skills. I assume this is the path alot of you
> have taken by the frequency of ASP and CF in your signatures.
>
> Terry Troxel
>
>
>
~~
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: Cheaper Alternative to SQL Server 2000 - Interbase?

[Jon Hall]

It's been an Interbase night for me. I am not a dba, but here is a quote
from a slashdot post that may answer your question.

"Regarding mySQL, yes, it is very fast for simple queries. For high-volume
use it is less than ideal, though, as it implements concurrency control by
locking entire tables. Postgres, Interbase and Oracle all implement
concurrency control such that readers NEVER wait for writers, and writers
only lock affected rows during a transaction (unless the user does a "select
for update" or otherwise imposes a more stringent lock ). "

I presume that the above quote means yes, it does support row level locking.
I could be wrong though.

My first experience with Interbase has been mostly positive. The only really
annoying thing is that no odbc driver is included. This is supposed to be
resolved in Q3 otf this year with a full open source odbc driver. I was able
to find a free odbc driver though and am testing it now. There is also a cfx
tag that replaces  that can access Interbase db's natively.
Hopefully though Allaire will include the ability to add Interbase odbc
drivers through the cfadmin in the future. I have to do it manually via
windows now.
Although there is a gui client utility included it does not include any
ability to create table's or fields. I have to use a third party utility to
do this for now.

These problems aside, so far it seems to be a very nice database and
amazingly it is free. I would kinda describe it as a SQL Server lite. It
does support transactions, stored procedures, and triggers...

jon
- Original Message -
From: "Arden Weiss" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 22, 2001 9:55 PM
Subject: RE: Cheaper Alternative to SQL Server 2000 - Interbase?


> Does Interbase support row-level locking???
>
>  ^
> / \__
>(@\___
>   /  O
>  /(_/
> /_/
> Whoof...
> 410-757-3487
>
> -Original Message-
> From: Jon Hall [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, February 22, 2001 8:03 PM
> To: CF-Talk
> Subject: Re: Cheaper Alternative to SQL Server 2000 - Interbase?
>
> I am going to download Interbase tonight and play around with it. Are
there
> any gotchas other than needing to buy an odbc driver?
>
> jon
> - Original Message -
> From: "Howie Hamlin" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, February 22, 2001 11:43 AM
> Subject: Re: Cheaper Alternative to SQL Server 2000
>
>
> > Interbase is free.  www.borland.com/interbase.
> >
> > You'll have to get an ODBC driver - there are several to be found for
> around
> > $100.
> >
> > HTH,
> >
> > Howie Hamlin - inFusion Project Manager
> > On-Line Data Solutions, Inc.
> > www.CoolFusion.com
> > 631-737-4668 x101
> > inFusion Mail Server (iMS) - the World's most configurable mail server
> > Get your free copy of iMS POST-SE Server from CoolFusion!
> >
> > - Original Message -
> > From: "Jason Larson" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Thursday, February 22, 2001 10:49 AM
> > Subject: OT: Cheaper Alternative to SQL Server 2000
> >
> >
> > >
> > > Sorry about the OT post.
> > >
> > > I was wondering if someone could give me some feedback on a cheaper
> > > alternative to SQL Server. I am on a limited budget to create my own
> > > webserver and I have only experience in developing with CF and SQL
> Server.
> > I
> > > really can't afford the $5,000 that Microsoft wants for SQL Server
2000.
> > > Anybody have any suggestions?
> > >
> > >
> > > Thanks for your time
> > >
> > > Jason Larson
> > > [EMAIL PROTECTED]
> > > 406-728-4422
> > >
> > >
> > >
> >
>
~~
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: Strengths of each

[Nick McClure]

One of the things that I have been working on recently is My own 
Session/Application management System.

All variables are stored in the database, VBScript functions and CF Custom 
Tags are used to pull these variables. This system was designed to easily 
be ported to any Language. If for some reason we wanted to add a JSP or C++ 
portion to a given application, it could continue to use the same session info.

Right now I am in the early development stages, so a lot of stuff has to be 
done twice, but I plan to move most of it into stored procs.


>To answer your first question, yes, CF and ASP can coexist on the server,
>there are no problems having a mix of ColdFusion and ASP pages within a
>site, however, I'm pretty certain you can forget sharing Session and
>Application variables between these environments.  But you could pass
>variables through on URL's.
>
>We tend to write CF only sites now, while we used to be mainly ASP
>developers, however we've never needed to mix the two.
>
>Hope this helps a little bit.  Feel free to contact me off list if you have
>any further questions.
>
>Nick
>
> > From: "Terry Troxel" <[EMAIL PROTECTED]>
> > Reply-To: [EMAIL PROTECTED]
> > Date: Thu, 22 Feb 2001 11:09:31 -0800
> > To: CF-Talk <[EMAIL PROTECTED]>
> > Subject: Strengths of each
> >
> > I am posing a question that has been rattling around in my mind for
>awhile.
> > My host runs on O'Reilly WebSite Pro, so I have zero exposure to IIS and
> > maybe that is why I m in the dark.
> > I would like to know if CF and ASP can co-exist and possibly trade data
>like
> > CF does with javascript, WAP, etc.
> >
> > The second part of my question is if this is possible has anyone compiled
>a
> > list of what types of procedures, functionality is best handled by which.
> >
> > If these questions are true then I have to get onto an IIS host, and start
> > learning ASP to broaden my skills. I assume this is the path alot of you
> > have taken by the frequency of ASP and CF in your signatures.
> >
> > Terry Troxel
> >
> >
> >
>
~~
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: Cheaper Alternative to SQL Server 2000 - Interbase?

[Howie Hamlin]

Not that I know of.  You may want to check out the following sites for more
info:

http://www.borland.com/interbase

http://community.borland.com/interbase/

http://www.interbase2000.org

Regards,

Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
www.CoolFusion.com
631-737-4668 x101
inFusion Mail Server (iMS) - the World's most configurable mail server
Get your free copy of iMS POST-SE Server from CoolFusion!

- Original Message -
From: "Jon Hall" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 22, 2001 8:03 PM
Subject: Re: Cheaper Alternative to SQL Server 2000 - Interbase?


> I am going to download Interbase tonight and play around with it. Are
there
> any gotchas other than needing to buy an odbc driver?
>
> jon
> - Original Message -
> From: "Howie Hamlin" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, February 22, 2001 11:43 AM
> Subject: Re: Cheaper Alternative to SQL Server 2000
>
>
> > Interbase is free.  www.borland.com/interbase.
> >
> > You'll have to get an ODBC driver - there are several to be found for
> around
> > $100.
> >
> > HTH,
> >
> > Howie Hamlin - inFusion Project Manager
> > On-Line Data Solutions, Inc.
> > www.CoolFusion.com
> > 631-737-4668 x101
> > inFusion Mail Server (iMS) - the World's most configurable mail server
> > Get your free copy of iMS POST-SE Server from CoolFusion!
> >
> > - Original Message -
> > From: "Jason Larson" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Thursday, February 22, 2001 10:49 AM
> > Subject: OT: Cheaper Alternative to SQL Server 2000
> >
> >
> > >
> > > Sorry about the OT post.
> > >
> > > I was wondering if someone could give me some feedback on a cheaper
> > > alternative to SQL Server. I am on a limited budget to create my own
> > > webserver and I have only experience in developing with CF and SQL
> Server.
> > I
> > > really can't afford the $5,000 that Microsoft wants for SQL Server
2000.
> > > Anybody have any suggestions?
> > >
> > >
> > > Thanks for your time
> > >
> > > Jason Larson
> > > [EMAIL PROTECTED]
> > > 406-728-4422
> > >
> > >
> > >
> >
>
~~
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: Cheaper Alternative to SQL Server 2000 - Interbase?

[Howie Hamlin]

Interbase supports versioning.

http://community.borland.com/article/0,1410,23216,00.html

HTH,

Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
www.CoolFusion.com
631-737-4668 x101
inFusion Mail Server (iMS) - the World's most configurable mail server
Get your free copy of iMS POST-SE Server from CoolFusion!

- Original Message - 
From: "Arden Weiss" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 22, 2001 9:55 PM
Subject: RE: Cheaper Alternative to SQL Server 2000 - Interbase?


> Does Interbase support row-level locking???
> 
>  ^
> / \__
>(@\___
>   /  O
>  /(_/
> /_/
> Whoof...
> 410-757-3487
> 


~~
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: HELP! - dynamic variables...

[Ted Parton]

Joby, in your action file you want to do something along the lines of this.



 
 

   
 

Or you could do that while looping through your query... just depend on your 
preference.  I'm not sure it will
work, but you could probably throw in a  to ensure that there it is
defined.

I hope this helps you out.

Ted Parton


Joby Bednar wrote:

> I need some help please!
>
> I have a form that asks for # of guests.  It then goes to a page that
> generates a form for each guest and names the fields "name_first_1",
> "name_first_2", etc...  I need to figure out some way to do a  for
> each possible name in case it was left blank, and then add each guest's info
> into a database.  The problem I have is how do I loop to add the fields into
> the database with the proper info?  I'm trying to put them into an array and
> then use the array for the query.
>
> This is something like what I'm trying to do, but I can't figure out how to
> get it to work:
>  
>name="form.guest_name_first_#gnum#" default=""> 
>  temp_salutation[gnum] = ???>
>  datasource="xxx">  INSERT INTO Guests (guest_salutation,guest_name_first)
> VALUES
> ('#temp_salutation[gnum]#','#temp_name_first[gnum]#')
> Joby Bednar
> Director of Internet Design
> iNEOgroup.com
> http://www.ineogroup.com
> Fusing your Dreams and the Web, Together as One
> [EMAIL PROTECTED]
> Cell:  949-283-5138
> Personal Fax:  208-485-1170
>
>
~~
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: "isdefined" obsolete?

[Scott Weikert]

IsDefined works... are you putting quotes around the variable? i.e. ...?

- Original Message -
From: "DSJ / PC1, Inc." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 22, 2001 2:17 PM
Subject: "isdefined" obsolete?


> Hello All,
>
> Just got a new web hosting account and it appears to have some old CF code
> in it, which is not working.  Do I recall correctly that "isdefined" is no
> longer valid for use in CF?  I'm running CF 4.51 on my server.
>
> Thanks in advance for any help!
>
> DSJ
>
>
>
~~
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: [End session on browser close]

[Scott, Andrew]

What it does is resets the cookie with the same value it once held, but if
you read the documentation on cfcookie you will find out that it defaults to
expire now if the expire attribute is not passed.

Hope this helps:-)




-Original Message-
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: 23 February 2001 10:21
To: CF-Talk
Subject: Re: [End session on browser close]


I'm a bit confused by what this piece of code is supposed to do.  Looks
to me like you reassign cookie values to themselves.  Not sure how that
solves the problem.

-- 
Billy Cravens
HR Web Development, Sabre
[EMAIL PROTECTED]

Alex wrote:
> 
> 
> 
>   
>   
>   
>   
> 
> 
> "David Berger" <[EMAIL PROTECTED]> wrote:
> How can you kill the session when the browser is closed, or the user
leaves
> your site?
> 
> (In ASP, the session ends when you close the browser)
> 
> I've looked at the Allaire developers exchange and a number of people had
> the same question, but nobody had responded with an answer.
> 
> Thanks,
> David J. Berger
> Senior Web Developer
> Cynergy Consulting
>
~~
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: [End session on browser close]

[Sean Faulkner]

Resetting the values kills the cookie.. the code below basically
re-initializes them by giving them null values, this "logging out"...
- Original Message -
From: "Billy Cravens" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 22, 2001 6:21 PM
Subject: Re: [End session on browser close]


> I'm a bit confused by what this piece of code is supposed to do.  Looks
> to me like you reassign cookie values to themselves.  Not sure how that
> solves the problem.
>
> --
> Billy Cravens
> HR Web Development, Sabre
> [EMAIL PROTECTED]
>
> Alex wrote:
> >
> > 
> > 
> >   
> >   
> >   
> >   
> > 
> >
> > "David Berger" <[EMAIL PROTECTED]> wrote:
> > How can you kill the session when the browser is closed, or the user
leaves
> > your site?
> >
> > (In ASP, the session ends when you close the browser)
> >
> > I've looked at the Allaire developers exchange and a number of people
had
> > the same question, but nobody had responded with an answer.
> >
> > Thanks,
> > David J. Berger
> > Senior Web Developer
> > Cynergy Consulting
> >
>
~~
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: Installing CF Server

[David Hannum]

What version of CF are you installing?  I don't believe anything below 4.5
is promised to run on Win2K.

Dave


- Original Message -
From: Haryono ... <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Thursday, February 22, 2001 8:40 PM
Subject: Installing CF Server


> Hi everyone,
> I get a problem when I was installing ColdFusion
> Server
> Professional in Windows 2000.
> Can someone help me to tell me about what step should
> I take when I install ColdFusion Server in Windows
> 2000?
>
> Thank you for your answer.
>
~~
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: Strengths of each

[Robert Everland III]

I would have to see what your custom tag is but I would think either you are
using cfhttp to do everythign or you are using wscript. Either way there is
gonna be a way to do it, so if you would be so kind as to send me your code
so that I may evaluate a way to do this.


bob everland

-Original Message-
From: Scott, Andrew [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 22, 2001 6:13 PM
To: CF-Talk
Subject: RE: Strengths of each


Actually you can mix the two, and I have developed a custom tag that can do
something like the following


 <%
  a=1
  b=2
  c=3
 %>


Which would then execute the ASP from within the cfml template, the only
problem is that I haven't found a way to share the result with CF. But I
could do something like the following without any problems.






 <%
  a=1
  b=2
  c=3
  #strTest#
 %>



But I haven't had the time to learn enough about ASP, to take the variables
from ASP tp Coldfusion So if anyone has any ideas to develop this
further I would like to hear from you.



-Original Message-
From: Nick Texidor [mailto:[EMAIL PROTECTED]]
Sent: 23 February 2001 08:02
To: CF-Talk
Subject: Re: Strengths of each


Hi Terry,

To answer your first question, yes, CF and ASP can coexist on the server,
there are no problems having a mix of ColdFusion and ASP pages within a
site, however, I'm pretty certain you can forget sharing Session and
Application variables between these environments.  But you could pass
variables through on URL's.

We tend to write CF only sites now, while we used to be mainly ASP
developers, however we've never needed to mix the two.

Hope this helps a little bit.  Feel free to contact me off list if you have
any further questions.

Nick

> From: "Terry Troxel" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date: Thu, 22 Feb 2001 11:09:31 -0800
> To: CF-Talk <[EMAIL PROTECTED]>
> Subject: Strengths of each
>
> I am posing a question that has been rattling around in my mind for
awhile.
> My host runs on O'Reilly WebSite Pro, so I have zero exposure to IIS and
> maybe that is why I m in the dark.
> I would like to know if CF and ASP can co-exist and possibly trade data
like
> CF does with javascript, WAP, etc.
>
> The second part of my question is if this is possible has anyone compiled
a
> list of what types of procedures, functionality is best handled by which.
>
> If these questions are true then I have to get onto an IIS host, and start
> learning ASP to broaden my skills. I assume this is the path alot of you
> have taken by the frequency of ASP and CF in your signatures.
>
> Terry Troxel
>
>
>
~~
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: Installing CF Server

[Dylan Bromby]

can you provide more detail?

-Original Message-
From: Haryono ... [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 22, 2001 5:40 PM
To: CF-Talk
Subject: Installing CF Server


Hi everyone,
I get a problem when I was installing ColdFusion
Server
Professional in Windows 2000.
Can someone help me to tell me about what step should
I take when I install ColdFusion Server in Windows
2000?

Thank you for your answer.
~~
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: Strengths of each

[Arden Weiss]

Are you willing to post some code to show how you "pass information from CF to ASP 
which
builds a PDF for me?"



 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Cami Lawson [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, February 22, 2001 3:57 PM
To: CF-Talk
Subject:Re: Strengths of each

I am currently running CF 4.5.2 and pass information from CF to ASP which
builds a PDF for me.

HTH
- Original Message -
From: "Terry Troxel" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 22, 2001 1:09 PM
Subject: Strengths of each


> I am posing a question that has been rattling around in my mind for
awhile.
> My host runs on O'Reilly WebSite Pro, so I have zero exposure to IIS and
> maybe that is why I m in the dark.
> I would like to know if CF and ASP can co-exist and possibly trade data
like
> CF does with javascript, WAP, etc.
>
> The second part of my question is if this is possible has anyone compiled
a
> list of what types of procedures, functionality is best handled by which.
>
> If these questions are true then I have to get onto an IIS host, and start
> learning ASP to broaden my skills. I assume this is the path alot of you
> have taken by the frequency of ASP and CF in your signatures.
>
> Terry Troxel
>
>
>
~~
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: Cheaper Alternative to SQL Server 2000 - Interbase?

[Arden Weiss]

Does Interbase support row-level locking???

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Jon Hall [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, February 22, 2001 8:03 PM
To: CF-Talk
Subject:Re: Cheaper Alternative to SQL Server 2000 - Interbase?

I am going to download Interbase tonight and play around with it. Are there
any gotchas other than needing to buy an odbc driver?

jon
- Original Message -
From: "Howie Hamlin" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 22, 2001 11:43 AM
Subject: Re: Cheaper Alternative to SQL Server 2000


> Interbase is free.  www.borland.com/interbase.
>
> You'll have to get an ODBC driver - there are several to be found for
around
> $100.
>
> HTH,
>
> Howie Hamlin - inFusion Project Manager
> On-Line Data Solutions, Inc.
> www.CoolFusion.com
> 631-737-4668 x101
> inFusion Mail Server (iMS) - the World's most configurable mail server
> Get your free copy of iMS POST-SE Server from CoolFusion!
>
> - Original Message -
> From: "Jason Larson" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, February 22, 2001 10:49 AM
> Subject: OT: Cheaper Alternative to SQL Server 2000
>
>
> >
> > Sorry about the OT post.
> >
> > I was wondering if someone could give me some feedback on a cheaper
> > alternative to SQL Server. I am on a limited budget to create my own
> > webserver and I have only experience in developing with CF and SQL
Server.
> I
> > really can't afford the $5,000 that Microsoft wants for SQL Server 2000.
> > Anybody have any suggestions?
> >
> >
> > Thanks for your time
> >
> > Jason Larson
> > [EMAIL PROTECTED]
> > 406-728-4422
> >
> >
> >
>
~~
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: OT: Cheaper Alternative to SQL Server 2000

[paul smith]

Has anyone confirmed that MSDE is limited compared to SQL Server?

best,  paul

At 04:06 PM 2/22/01 -0700, you wrote:
>MSDE works great. Easy install from the Office Server Extensions disk. I use
>the Enterprise Manager on my MS SQL box to work on the tables. Seems to have
>the same performance as MS SQL.


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

[Darryl Lyons]

Why don't you make it a stored procedure?

-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 23, 2001 7:57 AM
To: CF-Talk
Subject: sql query


can anyone help me translate this FROM in my SQL query so CF will like it?
it works fine in SQL but bombs in CF with syntax errors.

FROM INT_AUX_LISTING

LEFT JOIN int_aux_listing as CompanyListing 
ON  (int_aux_listing.company_list_id =
CompanyListing.Listing_ID)
AND (int_aux_listing.Company_list_src_id =
CompanyListing.Listing_src_id))


left JOIN INT_AUX_LST_ADDR 
ON (INT_AUX_LISTING.LISTING_SRC_ID =
INT_AUX_LST_ADDR.LISTING_SRC_ID) 
AND (INT_AUX_LISTING.LISTING_ID =
INT_AUX_LST_ADDR.LISTING_ID)) 

left JOIN INT_AUX_ADDRESS 
ON (INT_AUX_LST_ADDR.ADDRESS_SRC_ID =
INT_AUX_ADDRESS.ADDRESS_SRC_ID) 
AND (INT_AUX_LST_ADDR.ADDRESS_ID =
INT_AUX_ADDRESS.ADDRESS_ID)

left JOIN INT_AUX_LST_PHONE 
ON (int_aux_listing.LISTING_ID =
INT_AUX_LST_PHONE.LISTING_ID) 
AND (int_aux_listing.LISTING_SRC_ID =
INT_AUX_LST_PHONE.LISTING_SRC_ID))

left JOIN INT_AUX_PHONE 
ON (INT_AUX_PHONE.PHONE_ID = INT_AUX_LST_PHONE.PHONE_ID) 
AND (INT_AUX_PHONE.PHONE_SRC_ID =
INT_AUX_LST_PHONE.PHONE_SRC_ID)) 

left join int_phone_typ
on (int_aux_phone.phone_typ_id = int_phone_typ.phone_typ_id)

left join int_relation_typ as Phone_Relation_TYP
on (int_aux_lst_phone.rltn_typ_id =
phone_relation_typ.rltn_typ_id)
i was working with the query builder and it seemed like it was using {
instead of (.  
thanks for your 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: "isdefined" obsolete?

[C. Hatton Humphrey]

I use IsDefined on 4.5.1 all the time.

What code is giving you a problem?

Hatton

-Original Message-
From: DSJ / PC1, Inc. [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 22, 2001 4:18 PM
To: CF-Talk
Subject: "isdefined" obsolete?


Hello All,

Just got a new web hosting account and it appears to have some old CF code
in it, which is not working.  Do I recall correctly that "isdefined" is no
longer valid for use in CF?  I'm running CF 4.51 on my server.

Thanks in advance for any help!

DSJ
~~
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: [End session on browser close]

[Billy Cravens]

I'm a bit confused by what this piece of code is supposed to do.  Looks
to me like you reassign cookie values to themselves.  Not sure how that
solves the problem.

-- 
Billy Cravens
HR Web Development, Sabre
[EMAIL PROTECTED]

Alex wrote:
> 
> 
> 
>   
>   
>   
>   
> 
> 
> "David Berger" <[EMAIL PROTECTED]> wrote:
> How can you kill the session when the browser is closed, or the user leaves
> your site?
> 
> (In ASP, the session ends when you close the browser)
> 
> I've looked at the Allaire developers exchange and a number of people had
> the same question, but nobody had responded with an answer.
> 
> Thanks,
> David J. Berger
> Senior Web Developer
> Cynergy Consulting
>
~~
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: Validating Checkboxes

[Scott, Andrew]

You might need to post the snippet of code for the submit and action
pages... Radio and Checkboxes if nothing is selected do not get passed back
to the server.

cfparam name="Checkbox_Name" default=""> will only set it up as null if its
not already set up. But as for validation, what do you mean by this. Do you
mean validate that it exists, validate the data or something completely
different:-)



-Original Message-
From: Roque,Carlos [mailto:[EMAIL PROTECTED]]
Sent: 23 February 2001 09:45
To: CF-Talk
Subject: RE: Validating Checkboxes


I am trying to pass a value if when a box is selected. Right now I use a
CFPARAM default ="". On submit it looks like it does something even though
it really does not.

Carlos Roque
I.S., WebMaster
x2154

 -Original Message-
From:   Phoeun Pha [mailto:[EMAIL PROTECTED]] 
Sent:   Wednesday, February 21, 2001 11:07 AM
To: CF-Talk
Subject:RE: Validating Checkboxes

what kind of validation?  please explain

-Original Message-
From: Roque,Carlos [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 21, 2001 10:18 AM
To: CF-Talk
Subject: Validating Checkboxes


Anyone have a good method in CF for validating checkboxes (grouped).


Carlos Roque
I.S., WebMaster
x2154
~~
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: OT: Cheaper Alternative to SQL Server 2000

[Shawnea Carter]

There is a win32 port of it - mind you I am in NO WAY endorsing mySQL - I
personally hate the product - just pointing out that you can run it on an
NT/2k box.

Shawnea Carter
- Original Message -
From: "Adrian Cooper" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 22, 2001 3:58 PM
Subject: Re: OT: Cheaper Alternative to SQL Server 2000


>
> - Original Message -
> From: "JustinMacCarthy" <[EMAIL PROTECTED]>
> Sent: Thursday, February 22, 2001 7:03 PM
>
>
> > You could look at MySql ->Free
>
> Except for the fact if you are running NT/2000, you will need a seperate
machine
> to run Linux/mySQL and which then costs the same as SQL Server for an
> appropriate spec machine.
>
> I agree that_if_you have a decent Linux box already - mySQL is a good
solution
> for sure, but beyond that I am intrigued by the possibilities for MSDE -
anyone
> tried that?
>
> Adrian Cooper.
>
>
>
>
~~
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: Strengths of each

[Terry Troxel]

Cami,

That is EXACTLY the type of data transfer functionality I am talking about.
Could I email you off list to ask you some more about this?

Terry

- Original Message -
From: Cami Lawson <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Thursday, February 22, 2001 12:56 PM
Subject: Re: Strengths of each


> I am currently running CF 4.5.2 and pass information from CF to ASP which
> builds a PDF for me.
>
> HTH
> - Original Message -
> From: "Terry Troxel" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, February 22, 2001 1:09 PM
> Subject: Strengths of each
>
>
> > I am posing a question that has been rattling around in my mind for
> awhile.
> > My host runs on O'Reilly WebSite Pro, so I have zero exposure to IIS and
> > maybe that is why I m in the dark.
> > I would like to know if CF and ASP can co-exist and possibly trade data
> like
> > CF does with javascript, WAP, etc.
> >
> > The second part of my question is if this is possible has anyone
compiled
> a
> > list of what types of procedures, functionality is best handled by
which.
> >
> > If these questions are true then I have to get onto an IIS host, and
start
> > learning ASP to broaden my skills. I assume this is the path alot of you
> > have taken by the frequency of ASP and CF in your signatures.
> >
> > Terry Troxel
> >
> >
> >
>
~~
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

HELP! - dynamic variables...

[Joby Bednar]

I need some help please!

I have a form that asks for # of guests.  It then goes to a page that
generates a form for each guest and names the fields "name_first_1",
"name_first_2", etc...  I need to figure out some way to do a  for
each possible name in case it was left blank, and then add each guest's info
into a database.  The problem I have is how do I loop to add the fields into
the database with the proper info?  I'm trying to put them into an array and
then use the array for the query.

This is something like what I'm trying to do, but I can't figure out how to
get it to work:
 
   

  INSERT INTO Guests (guest_salutation,guest_name_first)
VALUES
('#temp_salutation[gnum]#','#temp_name_first[gnum]#')
Joby Bednar
Director of Internet Design
iNEOgroup.com
http://www.ineogroup.com
Fusing your Dreams and the Web, Together as One
[EMAIL PROTECTED]
Cell:  949-283-5138
Personal Fax:  208-485-1170



~~
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: ["isdefined" obsolete?]

[Alex]

i think isdefined() is valid and parameterexists() is only for backward
compatbility

"DSJ / PC1, Inc." <[EMAIL PROTECTED]> wrote:
Hello All,

Just got a new web hosting account and it appears to have some old CF code
in it, which is not working.  Do I recall correctly that "isdefined" is no
longer valid for use in CF?  I'm running CF 4.51 on my server.

Thanks in advance for any help!

DSJ
~~
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: OT: Cheaper Alternative to SQL Server 2000

[John Lucas]

You can run MySQL on a win box. Windows versions of MySQL require a license.
However, it is considerably less that SQL Server.

http://www.abriasoft.com/products11.php has a Win32 compiled version. The
standard version runs $109.00

One thing to consider with MySQL is that while it is supported on Linux and
NT/2000, the databases are not compatible.  MySQL saves the databases as
files on the server. The files structure differences between Linux and
NT/2000 makes it "virtually" impossible to simply move the database from one
to the other.  However, you could always create a new database on the one
being move to and do a query update.

You'll have to install the MySQL drivers on the NT/2000 box to use ODBC.  CF
does not natively handle MySQL DSN setup through CF Administrator on the
NT/2000 platform, but you could create the datasources through the ODBC
manager on the server.  I believe there my be a tag in the Allaire tag
gallery that will do this for you as well.

Additionally, you can use Access to create your structures on MySQL through
an ODBC connection.   www.accessmysql.com ($30.00)

John Lucas
[EMAIL PROTECTED]

-Original Message-
From: Adrian Cooper [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 22, 2001 2:58 PM
To: CF-Talk
Subject: Re: OT: Cheaper Alternative to SQL Server 2000



- Original Message -
From: "JustinMacCarthy" <[EMAIL PROTECTED]>
Sent: Thursday, February 22, 2001 7:03 PM


> You could look at MySql ->Free

Except for the fact if you are running NT/2000, you will need a seperate
machine
to run Linux/mySQL and which then costs the same as SQL Server for an
appropriate spec machine.

I agree that_if_you have a decent Linux box already - mySQL is a good
solution
for sure, but beyond that I am intrigued by the possibilities for MSDE -
anyone
tried that?

Adrian Cooper.
~~
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: [Log File Analyzers]

[Alex]

analog
webalizer

"Duane Boudreau" <[EMAIL PROTECTED]> wrote:
Any suggestions on good Log File Analyzers along the lines of WebTrends?
WebTrends new pricing model makes them a little to expensive on hosted
servers.

TIA,
Duane Boudreau,
Chief Technology Officer
CFExperts, LLC
Nashua, NH
603.620.8797
~~
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: [Re: [End session on browser close]]

[Alex]

application.cfm

Nick Texidor <[EMAIL PROTECTED]> wrote:
Thanks for the code Alex

Where does this code go?



> From: Alex <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date: Thu, 22 Feb 2001 12:31:38 CST
> To: CF-Talk <[EMAIL PROTECTED]>
> Subject: Re: [End session on browser close]
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> "David Berger" <[EMAIL PROTECTED]> wrote:
> How can you kill the session when the browser is closed, or the user leaves
> your site?
> 
> (In ASP, the session ends when you close the browser)
> 
> I've looked at the Allaire developers exchange and a number of people had
> the same question, but nobody had responded with an answer.
> 
> Thanks,
> David J. Berger
> Senior Web Developer
> Cynergy Consulting
>
~~
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: Log File Analyzers

[Kym Kovan]

Hi Duane,

>Any suggestions on good Log File Analyzers along the lines of WebTrends?
>WebTrends new pricing model makes them a little to expensive on hosted
>servers.

Which way are you looking at this, from which end? Our hosting firm partner 
(www.mbcomms.net.au) has Media House's Statistics Server 
looking at all of its machines, the price model is quite good on a 
per-domain basis.

If you are looking at tracking just one site on an external machine, or 
whatever, then it starts getting expensive any which way you look.



--

Yours,

Kym


~~
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: "isdefined" obsolete?

[Richard Ramos]

If it was, then half of my sites would not be working.  I am using CF Pro
4.5.2 and it still works.

Richard Ramos
Network Administrator
Softitler Net, Inc.
www.softitler.com
[EMAIL PROTECTED]

- Original Message -
From: "DSJ / PC1, Inc." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 22, 2001 1:17 PM
Subject: "isdefined" obsolete?


> Hello All,
>
> Just got a new web hosting account and it appears to have some old CF code
> in it, which is not working.  Do I recall correctly that "isdefined" is no
> longer valid for use in CF?  I'm running CF 4.51 on my server.
>
> Thanks in advance for any help!
>
> DSJ
>
>
>
~~
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

CFMAIL and SMTP timestamp

[Drechsler, Jennifer]

I built a subscrption application which sends out email once a day.  The
problem is I am getting a wierd timestamp on the mail.  The mail server is
GMT - 8:00 as is the webserver.  The headers of the email look like this.

Received: from mason.puc.sf.ca.us (puc-intra1.puc.sf.ca.us [10.40.92.43]) by
mason.puc.sf.ca.us with SMTP (Microsoft Exchange Internet Mail Service
Version 5.5.2650.21)
id FCHRP8QH; Thu, 22 Feb 2001 14:34:17 -0800
Content-type: text/html
Date: Thu, 22 Feb 2001 14:30:32 +0700
From: [EMAIL PROTECTED]
Subject: Keeping you Current
To: [EMAIL PROTECTED]

>From this, it says the timestamp on the webserver is  GMT + 7:00.  Does
anyone know what's going on here.  Is there somewhere else on the webserver
I should be looking for a time.  It's IIS on Win2K, CF 4.5.1.

Thanks for the help,

Jennifer Drechsler
SFPUC, ITS
415.554.3270

~~
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: "isdefined" obsolete?

[Patricia Lee]

Nope.  Isdefined() is still quite valid.  It is the ancient
parameterexists() that has been deprecated.

|-Original Message-
|From: DSJ / PC1, Inc. [mailto:[EMAIL PROTECTED]]
|Sent: Thursday, February 22, 2001 4:18 PM
|To: CF-Talk
|Subject: "isdefined" obsolete?
|
|
|Hello All,
|
|Just got a new web hosting account and it appears to have some 
|old CF code
|in it, which is not working.  Do I recall correctly that 
|"isdefined" is no
|longer valid for use in CF?  I'm running CF 4.51 on my server.
|
|Thanks in advance for any help!
|
|DSJ
|
|
|
~~
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: Strengths of each

[Scott, Andrew]

Actually you can mix the two, and I have developed a custom tag that can do
something like the following


 <%
  a=1
  b=2
  c=3
 %>


Which would then execute the ASP from within the cfml template, the only
problem is that I haven't found a way to share the result with CF. But I
could do something like the following without any problems.






 <%
  a=1
  b=2
  c=3
  #strTest#
 %>



But I haven't had the time to learn enough about ASP, to take the variables
from ASP tp Coldfusion So if anyone has any ideas to develop this
further I would like to hear from you.



-Original Message-
From: Nick Texidor [mailto:[EMAIL PROTECTED]]
Sent: 23 February 2001 08:02
To: CF-Talk
Subject: Re: Strengths of each


Hi Terry,

To answer your first question, yes, CF and ASP can coexist on the server,
there are no problems having a mix of ColdFusion and ASP pages within a
site, however, I'm pretty certain you can forget sharing Session and
Application variables between these environments.  But you could pass
variables through on URL's.

We tend to write CF only sites now, while we used to be mainly ASP
developers, however we've never needed to mix the two.

Hope this helps a little bit.  Feel free to contact me off list if you have
any further questions.

Nick

> From: "Terry Troxel" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date: Thu, 22 Feb 2001 11:09:31 -0800
> To: CF-Talk <[EMAIL PROTECTED]>
> Subject: Strengths of each
> 
> I am posing a question that has been rattling around in my mind for
awhile.
> My host runs on O'Reilly WebSite Pro, so I have zero exposure to IIS and
> maybe that is why I m in the dark.
> I would like to know if CF and ASP can co-exist and possibly trade data
like
> CF does with javascript, WAP, etc.
> 
> The second part of my question is if this is possible has anyone compiled
a
> list of what types of procedures, functionality is best handled by which.
> 
> If these questions are true then I have to get onto an IIS host, and start
> learning ASP to broaden my skills. I assume this is the path alot of you
> have taken by the frequency of ASP and CF in your signatures.
> 
> Terry Troxel
> 
> 
>
~~
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: "isdefined" obsolete?

[Scott, Andrew]

No IsDefined replaced ParameterExists...



-Original Message-
From: DSJ / PC1, Inc. [mailto:[EMAIL PROTECTED]]
Sent: 23 February 2001 08:18
To: CF-Talk
Subject: "isdefined" obsolete?


Hello All,

Just got a new web hosting account and it appears to have some old CF code
in it, which is not working.  Do I recall correctly that "isdefined" is no
longer valid for use in CF?  I'm running CF 4.51 on my server.

Thanks in advance for any help!

DSJ
~~
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: "isdefined" obsolete?

[Jon Hall]

isDefined() is the preferred way to test for the existence of a variable.
You are thinking about parameterExists(). It still works, but is deprecated.

jon
- Original Message -
From: "DSJ / PC1, Inc." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 22, 2001 4:17 PM
Subject: "isdefined" obsolete?


> Hello All,
>
> Just got a new web hosting account and it appears to have some old CF code
> in it, which is not working.  Do I recall correctly that "isdefined" is no
> longer valid for use in CF?  I'm running CF 4.51 on my server.
>
> Thanks in advance for any help!
>
> DSJ
>
>
>
~~
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: "isdefined" obsolete?

[Cameron Childress]

> Do I recall correctly that "isdefined" is no
> longer valid for use in CF?

Yes, as are CFOUTPUT, CFQUERY and CFINCLUDE...  they just took them right
out...  yup, just took them right out...

-Cameron


Cameron Childress
elliptIQ Inc.
p.770.460.7277.232
f.770.460.0963

> -Original Message-
> From: DSJ / PC1, Inc. [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 22, 2001 4:18 PM
> To: CF-Talk
> Subject: "isdefined" obsolete?
>
>
> Hello All,
>
> Just got a new web hosting account and it appears to have some old CF code
> in it, which is not working.  Do I recall correctly that "isdefined" is no
> longer valid for use in CF?  I'm running CF 4.51 on my server.
>
> Thanks in advance for any help!
>
> DSJ
>
>
>
~~
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

Installing CF Server

[Haryono ...]

Hi everyone,
I get a problem when I was installing ColdFusion
Server
Professional in Windows 2000.
Can someone help me to tell me about what step should
I take when I install ColdFusion Server in Windows
2000?

Thank you for your answer.
~~
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: OT: Cheaper Alternative to SQL Server 2000

[Zac]

> > You could look at MySql ->Free

> Except for the fact if you are running NT/2000, you will need a seperate
machine
> to run Linux/mySQL and which then costs the same as SQL Server for an
> appropriate spec machine.

mySQL has a Windows binary.

And in any case you should really run your SQL server on a server separate
from your web server.


~~
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: Log File Analyzers

[ron]

> Any suggestions on good Log File Analyzers along the lines of WebTrends?
> WebTrends new pricing model makes them a little to expensive on hosted
> servers.

LiveStats (http://www.mediahouse.com/statisticsserver/); around $500 for up
to 500 domains, then $380 for additional 500-packs, I believe. And much
cooler than WebTrends, since you see, well, live stats, like who's currently
on your server. It's also much easier on server resources; we had to use a
separate box for WebTrends, and process at night. LiveStats now runs on the
same box, and does incremental processing every 5 minutes or so that's
unnoticeable on the CPU and RAM. Has it's own webserver, on a separate port,
for the reports. (And no, I don't work for MediaHouse. :))

-ron



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

verity/cf4.5sp2/.doc

[Dylan Bromby]

anyone have any trouble building verity collections of .DOC files in
CF4.5sp2?



~~
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: "isdefined" obsolete?

[Dylan Bromby]

i think it's ParameterExists() that is being ditched in favor of
IsDefined().


-Original Message-
From: DSJ / PC1, Inc. [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 22, 2001 1:18 PM
To: CF-Talk
Subject: "isdefined" obsolete?


Hello All,

Just got a new web hosting account and it appears to have some old CF code
in it, which is not working.  Do I recall correctly that "isdefined" is no
longer valid for use in CF?  I'm running CF 4.51 on my server.

Thanks in advance for any help!

DSJ
~~
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: "isdefined" obsolete?

[Sean Faulkner]

That's funny, I thought I heard that IsDefined was being kept and
ParameterExists was being fazed out.. maybe I got it backwards..
- Original Message -
From: "DSJ / PC1, Inc." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 22, 2001 4:17 PM
Subject: "isdefined" obsolete?


> Hello All,
>
> Just got a new web hosting account and it appears to have some old CF code
> in it, which is not working.  Do I recall correctly that "isdefined" is no
> longer valid for use in CF?  I'm running CF 4.51 on my server.
>
> Thanks in advance for any help!
>
> DSJ
>
>
>
~~
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: Cheaper Alternative to SQL Server 2000 - Interbase?

[Jon Hall]

I am going to download Interbase tonight and play around with it. Are there
any gotchas other than needing to buy an odbc driver?

jon
- Original Message -
From: "Howie Hamlin" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 22, 2001 11:43 AM
Subject: Re: Cheaper Alternative to SQL Server 2000


> Interbase is free.  www.borland.com/interbase.
>
> You'll have to get an ODBC driver - there are several to be found for
around
> $100.
>
> HTH,
>
> Howie Hamlin - inFusion Project Manager
> On-Line Data Solutions, Inc.
> www.CoolFusion.com
> 631-737-4668 x101
> inFusion Mail Server (iMS) - the World's most configurable mail server
> Get your free copy of iMS POST-SE Server from CoolFusion!
>
> - Original Message -
> From: "Jason Larson" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, February 22, 2001 10:49 AM
> Subject: OT: Cheaper Alternative to SQL Server 2000
>
>
> >
> > Sorry about the OT post.
> >
> > I was wondering if someone could give me some feedback on a cheaper
> > alternative to SQL Server. I am on a limited budget to create my own
> > webserver and I have only experience in developing with CF and SQL
Server.
> I
> > really can't afford the $5,000 that Microsoft wants for SQL Server 2000.
> > Anybody have any suggestions?
> >
> >
> > Thanks for your time
> >
> > Jason Larson
> > [EMAIL PROTECTED]
> > 406-728-4422
> >
> >
> >
>
~~
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: Threaded Discussion App with Tree view...??

[BORKMAN Lee]

Thanks Jeff, thanks everyone.  This is the one I was thinking of.

I'll look closer at SimpleMessageBoard as well.

Thanks for all your help, people,
LeeBB.


-Original Message-
From: Jeff Sarsoun [mailto:[EMAIL PROTECTED]]

Try this one.
http://www.coldfusiontags.com/message_board/index.cfm



IMPORTANT NOTICE:
This e-mail and any attachment to it is intended only to be read or used by
the named addressee.  It is confidential and may contain legally privileged
information.  No confidentiality or privilege is waived or lost by any
mistaken transmission to you.  If you receive this e-mail in error, please
immediately delete it from your system and notify the sender.  You must not
disclose, copy or use any part of this e-mail if you are not the intended
recipient.  The RTA is not responsible for any unauthorised alterations to
this e-mail or attachment to it.  

~~
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: local user time

[Gieseman, Athelene]

And we appreciate that in many cases.  However, the purpose of a listserv is
to share questions and answers.  Often someone will ask a question that I
haven't even thought about.  But the answer is still interesting to me as
I'm always trying to learn all I can.  In fact, this particular question is
of interest to me too.  Remember when your teachers use to tell you that if
you had a question, chances are that someone else had the same question too?
I guess I'd rather someone err on the side of sending too much to the list
rather than sending too little.  I can always use my delete key.  :-)  If
you decide not to post to the list, would you pls send me the information
too?  TIA.

Athelene Gieseman
[EMAIL PROTECTED]

-Original Message-
From: Clint Tredway [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 22, 2001 1:18 PM
To: CF-Talk
Subject: Re: local user time


The reason I take it off the list, is so that the list doesn't get cluttered
with meaningless emails...

--
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: Strengths of each

[Steve Bernard]

If you pass the information along via cookies, forms (POST), URL (GET), DSN,
file, WDDX, or system registry (on NT/W2k), then you can interchangeably use
data in CF and ASP. If you have a transaction server you may be able to use
COM/DCOM too. I'm sure I missed something but, this should work for
starters.

Steve

-Original Message-
From: Cami Lawson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 22, 2001 3:57 PM
To: CF-Talk
Subject: Re: Strengths of each


I am currently running CF 4.5.2 and pass information from CF to ASP which
builds a PDF for me.

HTH
- Original Message -
From: "Terry Troxel" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 22, 2001 1:09 PM
Subject: Strengths of each


> I am posing a question that has been rattling around in my mind for
awhile.
> My host runs on O'Reilly WebSite Pro, so I have zero exposure to IIS and
> maybe that is why I m in the dark.
> I would like to know if CF and ASP can co-exist and possibly trade data
like
> CF does with javascript, WAP, etc.
>
> The second part of my question is if this is possible has anyone compiled
a
> list of what types of procedures, functionality is best handled by which.
>
> If these questions are true then I have to get onto an IIS host, and start
> learning ASP to broaden my skills. I assume this is the path alot of you
> have taken by the frequency of ASP and CF in your signatures.
>
> Terry Troxel
>
>
>
~~
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: OT: Cheaper Alternative to SQL Server 2000

[Kent Runyan]

MSDE works great. Easy install from the Office Server Extensions disk. I use
the Enterprise Manager on my MS SQL box to work on the tables. Seems to have
the same performance as MS SQL.

Kent Runyan
CFDynamics.com

-Original Message-
From: Adrian Cooper [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 22, 2001 1:58 PM
To: CF-Talk
Subject: Re: OT: Cheaper Alternative to SQL Server 2000



- Original Message -
From: "JustinMacCarthy" <[EMAIL PROTECTED]>
Sent: Thursday, February 22, 2001 7:03 PM


> You could look at MySql ->Free

Except for the fact if you are running NT/2000, you will need a seperate
machine
to run Linux/mySQL and which then costs the same as SQL Server for an
appropriate spec machine.

I agree that_if_you have a decent Linux box already - mySQL is a good
solution
for sure, but beyond that I am intrigued by the possibilities for MSDE -
anyone
tried that?

Adrian Cooper.
~~
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: [RE: [OT: Cheaper Alternative to SQL Server 2000]]

[Alex]

your database doesnt have to be on the same box as CF.
i have a solaris CF box hitting a NT/SQLServer DB and it works fine.
but anyway if youhave to have both on 1 machine MySQL works on both.

"Rob Eastland" <[EMAIL PROTECTED]> wrote:
I actually have more of a related question than advice on this. I have been
developing CF on NT using SQLserver and Access, but now I have to build an
application that will be hosted on a solaris box. The box doesn't have
anything yet, so ideally I'm trying to find a database that I can develop on
my NT development server and publish to the unix box. Any suggestions on a
good cross-platform database solution?

:--))
Rob


-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 22, 2001 1:30 PM
To: CF-Talk
Subject: Re: [OT: Cheaper Alternative to SQL Server 2000]


postgresSQL

"Jason Larson" <[EMAIL PROTECTED]> wrote:

Sorry about the OT post.

I was wondering if someone could give me some feedback on a cheaper
alternative to SQL Server. I am on a limited budget to create my own
webserver and I have only experience in developing with CF and SQL Server. I
really can't afford the $5,000 that Microsoft wants for SQL Server 2000.
Anybody have any suggestions?


Thanks for your time

Jason Larson
[EMAIL PROTECTED]
406-728-4422
~~
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: Validating Checkboxes

[Roque,Carlos]

I am trying to pass a value if when a box is selected. Right now I use a
CFPARAM default ="". On submit it looks like it does something even though
it really does not.

Carlos Roque
I.S., WebMaster
x2154

 -Original Message-
From:   Phoeun Pha [mailto:[EMAIL PROTECTED]] 
Sent:   Wednesday, February 21, 2001 11:07 AM
To: CF-Talk
Subject:RE: Validating Checkboxes

what kind of validation?  please explain

-Original Message-
From: Roque,Carlos [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 21, 2001 10:18 AM
To: CF-Talk
Subject: Validating Checkboxes


Anyone have a good method in CF for validating checkboxes (grouped).


Carlos Roque
I.S., WebMaster
x2154
~~
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: local user time

[Scott, Andrew]

You could use Javascript to do this:-)

Not sure on the syntax as I don't use it much... Maybe someone can shed more
light on it, but JS has suite of Date functions available and then its a
matter of then fiiting it into how you need it to work onLoad or
whatever to activate the function and then have this display it to the HTML
via innerHTML depending on what you need to do with it.



-Original Message-
From: Ethan Rosch [mailto:[EMAIL PROTECTED]]
Sent: 23 February 2001 02:23
To: CF-Talk
Subject: local user time


What's the best way to get the time off of the users local machine?
The Now() fuctions pulls server time.

Thank you

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

Follow up on the WDDX Recordset Sort problem

[Planet CF]

Hi,
This is a follow up to my earlier mail on the problem
that I have been having after using the WDDX extension
from WDDX.org

For all those interested in seeing the problem that
comes with CF see the attached code.

Extract the four files into a directory

1. Run the GetEmpDtls.cfm file.It shows the empid's
2. Click 'OK'.
3. The javascript alert shows the WDDX recordset.
Observe the new column 'preserveFieldCase' (top few
lines)
4. The records are infact sorted
5. Now clikc OK again.
6. Again you see the javascript msg with one more
'preservefieldcase'
7. And then the CF error

Hope someone has a solution

Kedar Desai
Differential Technologies
~~
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: How to choose Name or Scope when locking

[sebastian palmigiani]

on 2/22/01 2:13 PM, Dave Watts at [EMAIL PROTECTED] wrote:

> Databases do this stuff for you; that's what transactional database
> processing is all about. I'd strongly recommend using transactions within
> the database to do this instead of CFLOCK. Of course, I suspect that you
> already know this, but for the benefit of any other readers, I thought that
> I should respond.

how about ?


~~
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: Referential Integrity

[Maia, Eric]

It's probably best to do both: Check in CF for things that are most likely
to break, but always build your referential integrity into the DB in case
something gets past your code (and then catch & handle, of course!) When
you're dealing with forms, you can also add client-side validation.

Not that I've always operated this way ;(

Eric

-Original Message-
From: Cyrill Vatomsky [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 22, 2001 11:49 AM
To: CF-Talk
Subject: Referential Integrity


HI,

My question is whether it is better to write CF routines to maintain
referential integrity of the database (say, hiding a delete button or
checkbox if child records exist in another table) or to set up "Preserve
Referential Integrity" rules in MS access and try to catch errors?

Which leads me to a theoretical question: should I rely more on built-in
database functions or on CF?

Thanks,

Cyrill
~~
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: Referential Integrity

[Gary Dusbabek]

This is only my opinion... it all depends on your take.

Sometimes it is much easier to put a constraint on your database rather than
have to check for the constraint violation a million of times in your CF
code.  However, this forces you to use try/catch blocks, which you really
should be using in the first place.

>From my experience, I've found that trying to catch constraint violations
that have not been set at the database level to be messy and sometimes
inefficient (involving other queries, etc.).

- Original Message -
From: "Cyrill Vatomsky" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 22, 2001 12:48 PM
Subject: Referential Integrity


> HI,
>
> My question is whether it is better to write CF routines to maintain
> referential integrity of the database (say, hiding a delete button or
> checkbox if child records exist in another table) or to set up "Preserve
> Referential Integrity" rules in MS access and try to catch errors?
>
> Which leads me to a theoretical question: should I rely more on built-in
> database functions or on CF?
>
> Thanks,
>
> Cyrill
>
>
>
~~
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: Cheaper Alternative to SQL Server 2000

[Gary Dusbabek]

I don't know if you meant to include this as part of your first issue
(transaction support), but the last time I checked (several months ago)
MySQL doesn't yet support row-level locking (table level only).  This can be
a performance hit on heavily accessed databases.

Still, you couldn't beat the price unless they paid you to use it.



- Original Message -
From: "Zachary Bedell" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 22, 2001 12:37 PM
Subject: RE: Cheaper Alternative to SQL Server 2000


> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> > Well, there's always MySQL, but I bet there's a chorus of
> > folks here who'll
> > say it ain't ready for primetime, which is why I'm posting...
> >  could anyone
> > expound on this? Especially using mySQL with CF.
>
> Ok...  I'll bite...
>
> Probably the biggest things about MySQL that aren't ready for prime
> time are these:
>
> 1) Its support for transactions is limited (at best!).  I know
> they're working on that and it's getting better, but that's a fairly
> big limitation for some situations.
>
> 2) As far as I know, it still doesn't support any kind of stored
> procedure.
>
> 3) They take shortcuts on things like log-before-write that can cause
> data loss or corruption if your server loses power or if MySQL goes
> down hard.  Microsoft SQL Server is pretty close to bullet-proof in
> that regard.  If SQL Server tells ODBC that data was written, then
> indeed it will be written -- either permanently to the DB or at least
> to the log where it will be recovered if anything unpleasant happens
> to the server.  MySQL doesn't do that, so there's a chance of
> problems.  I've never run into any, but it's mathematically
> possible
>
> 4) MySQL's support for JOINs is fairly dumb in my experience.  I find
> I have to use completely different syntax to do the same things in
> SQL Server / MS Access then I do for MySQL.
>
>
> That's not to say MySQL doesn't have it's plusses.  It *is* free.
> I've got the MP3 player in the trunk of my car running MySQL and it
> works just *fine*.  I just wouldn't want to sick a thousand paying
> customers on that server and hope it keeps working through it...
>
> That's just my jaded opinion of course, so please take it with the
> proper grain of salt...
>
> Best regards,
> Zac Bedell
>
> -BEGIN PGP SIGNATURE-
> Version: PGPfreeware 6.5.8 for non-commercial use 
> Comment: Please use PGP!
>
> iQA/AwUBOpVqcKvhLS1aWPxeEQIqvwCg9CPpRT2K4DZyloBKYUDP7JvuTCoAoOxC
> CippPV+adIoyx7ZEQPHH7zqQ
> =YGHK
> -END PGP SIGNATURE-
>
>
>
~~
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: Referential Integrity

[Dave Watts]

> My question is whether it is better to write CF routines to 
> maintain referential integrity of the database (say, hiding 
> a delete button or checkbox if child records exist in another 
> table) or to set up "Preserve Referential Integrity" rules in 
> MS access and try to catch errors?
> 
> Which leads me to a theoretical question: should I rely more 
> on built-in database functions or on CF?

I love theoretical questions.

In my opinion, you should always, ALWAYS, use declarative referential
integrity rules in your database. You shouldn't rely on your application to
maintain database integrity. DRI should be incorporated into the database
design process - when you're deciding what your entities and relationships
will be, you should also decide how RI will work.

That said, it's also my opinion that you should code your application as if
you didn't use DRI. Your application shouldn't do things that would cause
integrity problems in the absence of DRI within the database. There's
nothing wrong with a little redundancy here.

You can make this relatively easy by using stored procedures within the
database to handle things like the deletion of child records before their
parents.

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

Email server/CF integration?

[Billy Cravens]

Doing some research.  What mail servers are fully exposed to
ColdFusion?  In other words, I want to be able to programatically
administer the mail server through a web based (programmed in
ColdFusion, not proprietary) interface.. mail servers that have exposed
COM interfaces look like the prime candidates at this point.

-- 
Billy Cravens
HR Web Development, Sabre
[EMAIL PROTECTED]

~~
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: Referential Integrity

[Nick Texidor]

In a performance tips seminar that Ben Forta gave, he said that referential
integrity was best left in the database rather than coding it yourself.
Then use CF to catch the errors.

Having said that, for deletes, I still check to see if children exist!!!



> From: "Cyrill Vatomsky" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date: Thu, 22 Feb 2001 11:48:57 -0800
> To: CF-Talk <[EMAIL PROTECTED]>
> Subject: Referential Integrity
> 
> HI,
> 
> My question is whether it is better to write CF routines to maintain
> referential integrity of the database (say, hiding a delete button or
> checkbox if child records exist in another table) or to set up "Preserve
> Referential Integrity" rules in MS access and try to catch errors?
> 
> Which leads me to a theoretical question: should I rely more on built-in
> database functions or on CF?
> 
> Thanks,
> 
> Cyrill
> 
> 
>
~~
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 query

[Jones, Becky]

can anyone help me translate this FROM in my SQL query so CF will like it?
it works fine in SQL but bombs in CF with syntax errors.

FROM INT_AUX_LISTING

LEFT JOIN int_aux_listing as CompanyListing 
ON  (int_aux_listing.company_list_id =
CompanyListing.Listing_ID)
AND (int_aux_listing.Company_list_src_id =
CompanyListing.Listing_src_id))


left JOIN INT_AUX_LST_ADDR 
ON (INT_AUX_LISTING.LISTING_SRC_ID =
INT_AUX_LST_ADDR.LISTING_SRC_ID) 
AND (INT_AUX_LISTING.LISTING_ID =
INT_AUX_LST_ADDR.LISTING_ID)) 

left JOIN INT_AUX_ADDRESS 
ON (INT_AUX_LST_ADDR.ADDRESS_SRC_ID =
INT_AUX_ADDRESS.ADDRESS_SRC_ID) 
AND (INT_AUX_LST_ADDR.ADDRESS_ID =
INT_AUX_ADDRESS.ADDRESS_ID)

left JOIN INT_AUX_LST_PHONE 
ON (int_aux_listing.LISTING_ID =
INT_AUX_LST_PHONE.LISTING_ID) 
AND (int_aux_listing.LISTING_SRC_ID =
INT_AUX_LST_PHONE.LISTING_SRC_ID))

left JOIN INT_AUX_PHONE 
ON (INT_AUX_PHONE.PHONE_ID = INT_AUX_LST_PHONE.PHONE_ID) 
AND (INT_AUX_PHONE.PHONE_SRC_ID =
INT_AUX_LST_PHONE.PHONE_SRC_ID)) 

left join int_phone_typ
on (int_aux_phone.phone_typ_id = int_phone_typ.phone_typ_id)

left join int_relation_typ as Phone_Relation_TYP
on (int_aux_lst_phone.rltn_typ_id =
phone_relation_typ.rltn_typ_id)
i was working with the query builder and it seemed like it was using {
instead of (.  
thanks for your 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: Referential Integrity

[Hal Helms]

Cyrill, I think everyone will advise  you to always prefer the database
functions--especially when dealing with referential integrity. Databases
have had almost 40 years with some of the best minds applied to them.
They're stable, elegant and fast.

Hal Helms
== See ColdFusionTraining.com for info on "Best Practices with ColdFusion &
Fusebox" training ==


-Original Message-
From: Cyrill Vatomsky [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 22, 2001 2:49 PM
To: CF-Talk
Subject: Referential Integrity


HI,

My question is whether it is better to write CF routines to maintain
referential integrity of the database (say, hiding a delete button or
checkbox if child records exist in another table) or to set up "Preserve
Referential Integrity" rules in MS access and try to catch errors?

Which leads me to a theoretical question: should I rely more on built-in
database functions or on CF?

Thanks,

Cyrill
~~
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: OT: Cheaper Alternative to SQL Server 2000

[Tony Schreiber]

Run CF on Linux with either PostGreSQL or MySQL...

There are couple of join types not supported on postgres, but I can't
remember specifically.

> I was wondering if someone could give me some feedback on a cheaper
> alternative to SQL Server. I am on a limited budget to create my own
> webserver and I have only experience in developing with CF and SQL Server. I
> really can't afford the $5,000 that Microsoft wants for SQL Server 2000.
> Anybody have any suggestions?
> 
> 
> Thanks for your time
> 
> Jason Larson
> [EMAIL PROTECTED]
> 406-728-4422
> 
> 
>
~~
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: CFMail?

[Tom Muck]

Put a transparent gif in the email, and then track it with your web server log
file.

tom
www.basic-ultradev.com

- Original Message -
From: "Christian L. Watt" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 22, 2001 2:09 PM
Subject: CFMail?


> Hello all!
> Can anyone tell me how to track if an email is opened using CFMail
> to send it?  Any help would be great!!!
>
> CW



~~
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: Regular Expression Help?

[David Cummins]

Firstly I'd like to mention that doing this is playing with fire. ;)

Secondly, I'd suggest three replaces:
1. Replace application.cfm with an easily recognisable other string without
application in the name.
2. Replace "([^a-zA-Z0-9])application.([a-zA-z])" with "\1request.\2".
3. Replace the funny string with application.cfm again.

David Cummins

Jamie Jackson wrote:
> 
> Hi, I'm trying to globally replace (with CF Studio) application
> variables with request variables in several sites. I can't figure out
> exactly how, as I don't know how to negate strings (as opposed to just
> character classes).
> 
> I want to change application.variableX to request.variableX, but I
> don't want to change "application. ", "application.", or
> references to "application.cfm"
> 
> Could you please help?
> 
> Here is just one of may seriously flawed attempts at a match:
> (application\.)([^ ]|[^cC][^fF][^mM]|[^<])
> 
> Thanks,
> Jamie
> 
> 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: [End session on browser close]

[Nick Texidor]

Thanks for the code Alex

Where does this code go?



> From: Alex <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date: Thu, 22 Feb 2001 12:31:38 CST
> To: CF-Talk <[EMAIL PROTECTED]>
> Subject: Re: [End session on browser close]
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> "David Berger" <[EMAIL PROTECTED]> wrote:
> How can you kill the session when the browser is closed, or the user leaves
> your site?
> 
> (In ASP, the session ends when you close the browser)
> 
> I've looked at the Allaire developers exchange and a number of people had
> the same question, but nobody had responded with an answer.
> 
> Thanks,
> David J. Berger
> Senior Web Developer
> Cynergy Consulting
>
~~
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

"isdefined" obsolete?

[DSJ / PC1, Inc.]

Hello All,

Just got a new web hosting account and it appears to have some old CF code
in it, which is not working.  Do I recall correctly that "isdefined" is no
longer valid for use in CF?  I'm running CF 4.51 on my server.

Thanks in advance for any help!

DSJ


~~
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: Cheaper Alternative to SQL Server 2000

[Chris Montgomery]

Are you going to be just running a local development server, or will this be
on a production box?

If this is just for developing on a local box, as someone else already
pointed out, you could use MSDE. If you don't already have Access 2000, you
can download MSDE (I think) from Microsoft's site. MSDE also comes bundled
with Visio 2000 (it installs MSDE without asking if it isn't already on your
system). Another option is to join the MS Developer Network and get a
universal subscription for about $600 (plus tax/shipping). With that, you
get all the commerce server, visual studio, office and a whole bunch of
other software, including SQL Server. I wanted SQL Server to run on my
development box and thought this was a great deal - Office Developer, Win200
and MS SQL (plus all the other stuff) for less than $700.

BTW, if anyone needs/wants Visio 2000 Pro (plus a free copy of Visio 2000
Enterprise), I have a still-shrink-wrapped copy I don't need anymore (since
it's part of the MSDN subscription) that I'll let go for what I paid - about
$350.

Chris Montgomery [EMAIL PROTECTED]

Web Development & Consulting http://www.astutia.com
Allaire Consulting Partner
210-490-3249/888-745-7603Fax 210-490-4692
AIM: astutiaweb; ICQ: 7381282; Firetalk: Ag78

> -Original Message-
> From: Jason Larson [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 22, 2001 9:50 AM
> To: CF-Talk
> Subject: OT: Cheaper Alternative to SQL Server 2000
>
> Sorry about the OT post.
>
> I was wondering if someone could give me some feedback on a cheaper
> alternative to SQL Server. I am on a limited budget to create my own
> webserver and I have only experience in developing with CF and
> SQL Server. I
> really can't afford the $5,000 that Microsoft wants for SQL Server 2000.
> Anybody have any suggestions?
>
>
> Thanks for your time
>
> Jason Larson


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

which cfwr8040 to use?

[mherbene]

This article
(http://www.allaire.com/Handlers/index.cfm?ID=15885&Method=Full) describes
an updated CFWR8040.dll file that corrects a memory leak when using an
Oracle native data source as a client variable repository.  It's not clear
to me if this update should be applied to CF 4.51 SP2 or only to CF 4.51;
does anyone know?  Both DLLs (the one that you have if you've updated to
4.51 SP2 and the one ref'd by the KB article) have internal version numbers
of "4.5.0"...

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

Log File Analyzers

[Duane Boudreau]

Any suggestions on good Log File Analyzers along the lines of WebTrends?
WebTrends new pricing model makes them a little to expensive on hosted
servers.

TIA,
Duane Boudreau,
Chief Technology Officer
CFExperts, LLC
Nashua, NH
603.620.8797


~~
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: Strengths of each

[Nick Texidor]

Hi Terry,

To answer your first question, yes, CF and ASP can coexist on the server,
there are no problems having a mix of ColdFusion and ASP pages within a
site, however, I'm pretty certain you can forget sharing Session and
Application variables between these environments.  But you could pass
variables through on URL's.

We tend to write CF only sites now, while we used to be mainly ASP
developers, however we've never needed to mix the two.

Hope this helps a little bit.  Feel free to contact me off list if you have
any further questions.

Nick

> From: "Terry Troxel" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date: Thu, 22 Feb 2001 11:09:31 -0800
> To: CF-Talk <[EMAIL PROTECTED]>
> Subject: Strengths of each
> 
> I am posing a question that has been rattling around in my mind for awhile.
> My host runs on O'Reilly WebSite Pro, so I have zero exposure to IIS and
> maybe that is why I m in the dark.
> I would like to know if CF and ASP can co-exist and possibly trade data like
> CF does with javascript, WAP, etc.
> 
> The second part of my question is if this is possible has anyone compiled a
> list of what types of procedures, functionality is best handled by which.
> 
> If these questions are true then I have to get onto an IIS host, and start
> learning ASP to broaden my skills. I assume this is the path alot of you
> have taken by the frequency of ASP and CF in your signatures.
> 
> Terry Troxel
> 
> 
>
~~
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: OT: Cheaper Alternative to SQL Server 2000

[Adrian Cooper]

- Original Message -
From: "JustinMacCarthy" <[EMAIL PROTECTED]>
Sent: Thursday, February 22, 2001 7:03 PM


> You could look at MySql ->Free

Except for the fact if you are running NT/2000, you will need a seperate machine
to run Linux/mySQL and which then costs the same as SQL Server for an
appropriate spec machine.

I agree that_if_you have a decent Linux box already - mySQL is a good solution
for sure, but beyond that I am intrigued by the possibilities for MSDE - anyone
tried that?

Adrian Cooper.



~~
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: Strengths of each

[Cami Lawson]

I am currently running CF 4.5.2 and pass information from CF to ASP which
builds a PDF for me.

HTH
- Original Message -
From: "Terry Troxel" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 22, 2001 1:09 PM
Subject: Strengths of each


> I am posing a question that has been rattling around in my mind for
awhile.
> My host runs on O'Reilly WebSite Pro, so I have zero exposure to IIS and
> maybe that is why I m in the dark.
> I would like to know if CF and ASP can co-exist and possibly trade data
like
> CF does with javascript, WAP, etc.
>
> The second part of my question is if this is possible has anyone compiled
a
> list of what types of procedures, functionality is best handled by which.
>
> If these questions are true then I have to get onto an IIS host, and start
> learning ASP to broaden my skills. I assume this is the path alot of you
> have taken by the frequency of ASP and CF in your signatures.
>
> Terry Troxel
>
>
>
~~
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: cfassociate

[Dave Watts]

> i am having a real problem trying to figure out how to get my 
> "cfassociate" tag working.
> 
> i have three files set up : index.cfm, mytag.cfm, and 
> mysubtag.cfm. on the index.cfm page i am calling  name="test">
> 
> 
> 
> 
> and the ``mytag.cfm`` page is set up as follows :
> 
> #isdefined("mystruct")#
> 
> 
> and the ``mysubtag.cfm`` page is simply :
> 
> 
> 
> what am i doing wrong? it seems like my page never seems to 
> get the "mystruct" structure. how is this cfassociate tag 
> called? and where am i going wrong.?

Your CFASSOCIATE tag is fine, but the DATACOLLECTION attribute creates an
array in the associated tag. Each element of the array will be a structure
which corresponds to a single instance of the subtag, and contains the
name-value pairs of the subtag's attributes. The way you'll refer to the
array in the base tag is by using the "ThisTag" scope prefix. I haven't
tried testing for its existence with IsDefined, but your code would look
something like this:





Name: #ThisTag.MyData[i].Name# Value:
#ThisTag.MyData[i].Value#








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

[Howarth, Craig (IBK-NY)]

In your parent tag, you reference the subtag structure with the thisTag scope.  So, 
you need to reference mystruct as thisTag.mystruct.

Craig

> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, February 22, 2001 2:14 PM
> To:   CF-Talk
> Subject:  cfassociate
> 
> i am having a real problem trying to figure out how to get my "cfassociate" tag 
>working.
> 
> i have three files set up : index.cfm, mytag.cfm, and mysubtag.cfm. on the index.cfm 
>page i am calling 
> 
> 
> 
> 
> 
> and the ``mytag.cfm`` page is set up as follows :
> 
> #isdefined("mystruct")#
> 
> 
> 
> and the ``mysubtag.cfm`` page is simply :
> 
> 
> 
> what am i doing wrong? it seems like my page never seems to get the "mystruct" 
>structure.
> how is this cfassociate tag called? and where am i going wrong.?
> 
> any help that can be given will be greatly appreciated.
> 
> thanks alot
> peter
> 
> 
>
~~
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: How to choose Name or Scope when locking

[Zachary Bedell]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

> Zac,
> 
> Thanks.  This was very helpful.
> 
> One clarification question.  Does a Named lock prevent a 
> same-named  thread
> within the session or application(on a single server?)?

Well...  I'm not quite sure what you're asking.

The three scoped locks and any named lock are completely separate
beasts.  If you have two threads that hit the same named lock, one of
them will block until the other is done.  If you have session,
application, or server locks going on at the same time, that won't
effect the named lock in any way, nor will the named lock affect the
scoped locks.

Basically:
* Two named locks with the same name will affect each other.
* Two session locks in the same session will affect each other.
* Two application locks in the same application will affect each
other.
* Two server locks will affect each other.
* Any other possible combination, and the two locks won't even know
the other one exists.

Make sense?

Best regards,
Zac Bedell


-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.8 for non-commercial use 
Comment: Please use PGP!

iQA/AwUBOpV7G6vhLS1aWPxeEQIkRQCfa4VAxeyKKCnxNyQJkoi8NS+YCt4AoKMm
riKVynfg396liGRNk69NZ3YS
=bHQK
-END PGP SIGNATURE-


~~
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: [OT: Cheaper Alternative to SQL Server 2000]

[Rob Eastland]

I actually have more of a related question than advice on this. I have been
developing CF on NT using SQLserver and Access, but now I have to build an
application that will be hosted on a solaris box. The box doesn't have
anything yet, so ideally I'm trying to find a database that I can develop on
my NT development server and publish to the unix box. Any suggestions on a
good cross-platform database solution?

:--))
Rob


-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 22, 2001 1:30 PM
To: CF-Talk
Subject: Re: [OT: Cheaper Alternative to SQL Server 2000]


postgresSQL

"Jason Larson" <[EMAIL PROTECTED]> wrote:

Sorry about the OT post.

I was wondering if someone could give me some feedback on a cheaper
alternative to SQL Server. I am on a limited budget to create my own
webserver and I have only experience in developing with CF and SQL Server. I
really can't afford the $5,000 that Microsoft wants for SQL Server 2000.
Anybody have any suggestions?


Thanks for your time

Jason Larson
[EMAIL PROTECTED]
406-728-4422
~~
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: Interesting Java/CF Article

[Dave Watts]

> The link to tagfusion has come up on this list a bunch of 
> times. But, no one has actually discussed it. I wonder what 
> the legalities of it are. I'd be talking to lawyers if I was 
> Allaire/Macromedia. There has got to be something wrong 
> against taking someone's product and copying it, which is 
> what they did.

I don't necessarily think that TagFusion hurts Allaire in any meaningful
way, or that there are any serious intellectual property implications.

Assuming that TagFusion was built by someone who knew how to write CFML
code, and who had never seen the source code for the CF Server, TagFusion
would essentially be a "clean-room" implementation of CF functionality.
Further, assuming that there is no right of ownership to CFML syntax itself
- I'm not sure of this, and of course I'm not a lawyer - then it would be
perfectly legal to write your own CFML interpreter.

In any case, this isn't the first time this has happened. Live Software, the
makers of JRun, created something called CF_ANYWHERE, which was essentially
a servlet-based CFML engine. Shortly after that, Live Software was acquired
by Allaire.

What I find interesting about TagFusion is that it seems to be based on
different design choices than the real CF server. The marketing docs talk
about "speed", then discuss how TagFusion doesn't retain things in memory -
two different issues entirely. 

There isn't much other than marketspeak on TagFusion now, anyway. The same
marketing docs talk about how "initial tests" indicate that TagFusion is
more efficient than CF, but no third-party testing has occurred, to the best
of my knowledge. There's just a demo, rather than a real product, so I don't
know whether TagFusion will actually be released significantly earlier than
CF 6. All of the "reviews" listed on the TagFusion site are nearly identical
with the marketing materials on the site itself.

Finally, TagFusion isn't necessarily a bad thing for Allaire. One of the
perceived problems with CF development is that it relies on a proprietary
language; TagFusion may increase the desire to learn CFML, which may
eventually lead to more product sales for Allaire! After all, I suspect that
TagFusion won't equal CF 6.

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: Interesting Java/CF Article

[Edward Smith]

I don't think so.  The specifications for CFML are all in publically
available documents.

So, with x input, you expect y result.  You code whatever you want to
take x and make y.

This is way open.  Anybody can write an interpreter or compiler for any
language - as long as you use accepted reverse-engineering techniques. 
And since the source code for the CFServer has never been released, the
authors of TagFusion could never have seen it.  No problem.

Its just like Chilisoft ASP, or anybody's C++ compiler.

Allaire's only defense is to write a better product, and that they have
99% of the market for CFML interpreters.  Therefore, they can lead the
market, release new specifications, and incorporate them into their
product before TagFusion can - and do this fast enough to stay ahead.


Jeffry Houser wrote:
> 
>   The link to tagfusion has come up on this list a bunch of times.  But, no
> one has actually discussed it.  I wonder what the legalities of it
> are.  I'd be talking to lawyers if I was Allaire/Macromedia.  There has got
> to be something wrong against taking someone's product and copying it,
> which is what they did.
> 
> At 09:43 AM 02/22/2001 -0600, you wrote:
> >The article is in the February 2001 issue of Java Developers Journal page
> >70 "Things Can Only Get Better". Alan Williamson describes how his Java
> >shop migrated to a Java/ColdFusion solutions company. They created
> >something called "tagFusion" that actually resulted in them having to
> >downsize their Java team.
> >--
> >
>
~~
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

WDDXRecordSet Sorting

[Planet CF]

Hi,
I am using the 'WddxRecordset Extensions' available
with the SDK from www.wddx.org. In the extensions
there is a method for sorting the WDDXRecordSet. It
sorts the recordset by the column you specify, or
using a custom sort function that you supply in a
custom JavaScript object.

Now here is something that the 'sort' method does. It
adds a new column to the sorted data, called
'preserveFieldCase'. If you sort in a loop, another
column with the same name is added. So now there are
multiple columns with the same name, namely
'preserveFieldCase'. 

Below is the serialized version of the WDDXRecordSet
after one sort. 

VR0009VR0008IINo new civil actions to be
processed exist for the specified case
type.The selected case does not have
an image.1999-7-26T0:0:0-5:02000-1-4T0:0:0-5:0

Here is the serialized version after the second sort.
See the duplicate column name, namely
'preserveFieldCase'

VR0009VR0008IINo new civil actions to be
processed exist for the specified case
type.The selected case does not have
an image.1999-7-26T0:0:0-5:02000-1-4T0:0:0-5:0

This is not mentioned in the documentation. Also
another point to note is that this column is not added
if the WDDXRecordSet has only one row. The above
example has two rows.

Because of these columns that get added to the sorted
recordset, the CFCFML2WDDX tag throws an error...
*
Error Diagnostic Information
unknown exception condition
TagCFWddx::doCFML2WddxStringTagCFWddx::execute
*

This error is thrown because the WDDX2CFML conversion
was not correct.


Is anyone out there who has done this before or can
give me a solution to this problem?

Thanks in advance

Kedar Desai
Differential Technologies
~~
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: bold verity search terms

[James McCullough]

I've only done this with description and title tags on html pages. This
could get hairy with CF templates because of the need to parse all CF tags.

This is a simplistic version of what needs to be done.











You need a Regex expression to find a start tag for "" to account for
its properties and things like "onload=whatever()" before finding the ">".It
also needs to parse out CF tags and conditional expressions. Then set this
string equal to "findstarttag". This snippet then creates the bodycontent
variable by starting at the end of the starttag (starttag+Len(findopentag))
and adding the number of characters(numchars) between that and the start of
the "endtag". Using a regex subExprs[] array that comes with Refind() is a
more elegant way to figure out the start and stop position but this example
illustrates the method.

To make sure that the text that you want to highlight or make bold is not
inside a CF or HTML tag like  or 

Re: blacked-out icons in studio

[David Adams]

This problem has been experienced on IBM Think Pads.

- Original Message -
From: Craig Dudley <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Thursday, February 22, 2001 1:24 PM
Subject: RE: blacked-out icons in studio


> Sometimes that's a video driver problem, do you have blacked out icons in
> any other applications?
>
> Either way, try downloading the latest drivers for the video card.
>
> -Original Message-
> From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
> Sent: 22 February 2001 16:15
> To: CF-Talk
> Subject: blacked-out icons in studio
>
>
> i just installed cfstu 4.5 on my laptop (win2k) and a large number of the
> icons are blacked-out. anyone seen this before?
>
> --dylan
>
~~
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: Mail stuck in spool folder...

[Howie Hamlin]

Does the mail server connection verify in the administrator?  Is the
ColdFusion Executive running (I believe this is the service that does the
actual mail sending)?

Regards,

Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
www.CoolFusion.com
631-737-4668 x101
inFusion Mail Server (iMS) - the World's most configurable mail server
Get your free copy of iMS POST-SE Server from CoolFusion!

- Original Message -
From: "Alexandre Dornback" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 22, 2001 1:33 PM
Subject: Mail stuck in spool folder...


> Using CFMAIL.  Mail server set in CF Admin
> Can telnet to server and perform smtp commands to send mail
>
> Mail just sits in SPOOL folder and doesn't get processed.
> No mail.log or mailsent.log.
>
> Alex
>
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.231 / Virus Database: 112 - Release Date: 2/12/01
>
>
>
~~
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: Mail stuck in spool folder...

[Stephenie]

is there a 0 byte file in the spool? this can be an issue when using sp2 on
cf 4.5.1

--
Stephenie Hamilton
Senior ColdFusion Administrator
Express Technologies, Inc.
want CF_Freedom?
try CFXHosting.com
Winner of the 2000 ColdFusion Developer's Journal Best ColdFusion Web Host!!



-Original Message-
From: Alexandre Dornback [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 22, 2001 1:34 PM
To: CF-Talk
Subject: Mail stuck in spool folder...


Using CFMAIL.  Mail server set in CF Admin
Can telnet to server and perform smtp commands to send mail

Mail just sits in SPOOL folder and doesn't get processed.
No mail.log or mailsent.log.

Alex



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.231 / Virus Database: 112 - Release Date: 2/12/01
~~
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

Missing Template Handler problem

[Jeremy Ridout]

I'm running into a problem where it appears that Client variables or Cookies
fail to get set properly when using the Missing Template handler. Has anyone
else run into this, and if so, is there a workaround?

I'm really baffled by this. From documentation and forums postings that I
have seen, Allaire contends that the Missing Template handler functions
exactly like a normal Cold Fusion template. However the test below seems to
prove otherwise.  I've pretty much accepted that none of this is going to
work. I just want to know why. Is this a feature? is it a bug? Am I
overlooking something simple?

I do know that the Missing Template Handler does not call Application.cfm
and that it must be included.

For example, 

Setup: First, set the file "mth.cfm" as the Missing Template Handler in the
CF Administrator. Also, tell CF to store client vars in a database (I don't
know if this makes a difference, but it duplicates my testbed). Create an
Application.cfm with a cfapplication tag and turn on client management and
setclientcookies = yes.

1) Now, put the following code inside "mth.cfm":


#Client.MyVar#
Now for the REAL test.

2) Put the following code inside "therealtest.cfm":
#Client.MyVar#

When you call the "mth.cfm" file directly, everything works as expected. You
see the new client var both on the mth.cfm page and when you click the link
to see the real test.

(Be sure to delete the client variable between tests!!)

However, when you enter a bogus URL to trigger the missing template handler,
you still see the new client var. But when you click the link to
"therealtest.cfm", you get an error that Client.MyVar does not exist.

It also appears that the Missing Template Handler misbehaves when setting
cookies.

Any ideas?

Thanks for your help,
Jeremy

Jeremy Ridout
Internet Services Director
www.ACEP.org

American College of Emergency Physicians
PO Box 619911
Dallas, TX 75261-9911
972-550-0911


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

[Phoeun Pha]

then how do i go about screwing up my server with bad code???!!


>:]

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 22, 2001 12:40 PM
To: CF-Talk
Subject: RE: CFINCLUDE Question


Actually, the endless loops I've run into with includes haven't crashed the
server, just timed out.

Hatton

> -Original Message-
> From: Phoeun Pha [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 22, 2001 12:15 PM
> To: CF-Talk
> Subject: CFINCLUDE Question
>
>
> hey guys, let's say i have three templates, with some content on
> them.  they
> are Template A, B, and C.  What were to happen if on each template, I do a
> CFINCLUDE for other templates?  For example, Template A would have a
> CFINCLUDE = "b.cfm" and a CFINCLUDE = "c.cfm".  and those templates have
> have the same CFincludes for the other templates.  WOuld it be an endless
> loop and cause coldfusion to crash?  If I were to do this on my
> host, would
> that host crash? (i think it's serving like 150 peeps)
>
> MUWHAHAHA!
>
>
~~
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: How to choose Name or Scope when locking

[Dave Watts]

> > First of all...  Why in lord's name would you want to single 
> > thread your DB access?
> 
> Fairly common example:
> 
> You insert something in the database, and immediately need to 
> access the ID of that new thing. You want to single thread the 
> insert and select, so the table doesn't change.

Databases do this stuff for you; that's what transactional database
processing is all about. I'd strongly recommend using transactions within
the database to do this instead of CFLOCK. Of course, I suspect that you
already know this, but for the benefit of any other readers, I thought that
I should respond.

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: blacked-out icons in studio

[Dylan Bromby]

Sometimes that's a video driver problem, do you have blacked out icons in
any other applications?

> No.

Either way, try downloading the latest drivers for the video card.

> Already did that before I installed studio.

-Original Message-
From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
Sent: 22 February 2001 16:15
To: CF-Talk
Subject: blacked-out icons in studio


i just installed cfstu 4.5 on my laptop (win2k) and a large number of the
icons are blacked-out. anyone seen this before?

--dylan
~~
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: blacked-out icons in studio

[Clint Tredway]

I've had this problem when my pc runs low on memory or studio errors or hangs. 

--
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: local user time

[Clint Tredway]

Here is the script I use. I don't remeber where I found it, but it works great!


// This script is designed to replace the "0" that you get using
// the getHours().  Nothing to it.
// richard lands http://www.taja.com/ 
// If you use let drop me a line at [EMAIL PROTECTED]
// peace
function getTime() {
var mins = ((min < 10) ? ":0" : ":") + min
var secs = ((sec < 10) ? ":0" : ":") + sec
if ( hour < 12) {
var am = (hour == 0) ? "12" : hour 
document.write(am + mins + secs +" a.m.")
}
if (hour > 12) {
var pm = hour - 12
document.write(pm + mins + secs +" p.m.")
}
if (hour == 12) {
var noon = hour  
document.write(noon + mins + secs +" p.m.")
}
}





--
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: browser refresh/reload

[Christopher Olive, CIO]

that's not strictly correct.  the webserver and browser are the ones that
handle these variables (CGI and HTTP scoped ones.)  not all browsers support
them.

additionally, the HTTP_REFERER variable you talk about first is only
populated when following a link.  refreshing a page does not change the
referer.

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



-Original Message-
From: Phoeun Pha [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 22, 2001 12:36 PM
To: CF-Talk
Subject: RE: browser refresh/reload


yes there is.  there coldfusion automatically creates a variable that
contains the url or address that u came from to get to the current page.  it
also gives u a variable which contains the url of the page u are on (I  am
95% sure hehe).  so u can do a CFIF to see if the page the person came from
matches the page he is at.  if it is true, then it must be a refresh

-Original Message-
From: Jay E Wigginton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 22, 2001 10:52 AM
To: CF-Talk
Subject: browser refresh/reload


Is there a way to determine in CF whether the page has been refreshed or
reloaded?  Or maybe a method in JavaScript?

thanks
Jay
~~
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: CFMAIL ERROR I WILL EXPLAIN

[lsellers]

000
> before it started crapping out. It looks as though whenever CF would parse
> the mail to the email server it somehow made a blank cfmail page that is
> exactly the same size as the email it should have made. Now this blank one
> had only a a line of big rectangular boxes and once CF went to move it, it

Sounds a lot like the coder forgot to make sure the buffers they're using
are cleared in all conditions (including ones where 'new' memory allocation
fails). The jiberish sounds like a non-null terminated block of memory was
copied after a new failure or a tcp buffer failure.

Probably fixable by one line of code if you had the c++ source.

--min


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

Referential Integrity

[Cyrill Vatomsky]

HI,

My question is whether it is better to write CF routines to maintain
referential integrity of the database (say, hiding a delete button or
checkbox if child records exist in another table) or to set up "Preserve
Referential Integrity" rules in MS access and try to catch errors?

Which leads me to a theoretical question: should I rely more on built-in
database functions or on CF?

Thanks,

Cyrill


~~
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: How to choose Name or Scope when locking

[Zachary Bedell]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

> > > I haven't seen anything yet that talks explicitly about when to
> > > use the Name attribute and when to use the Scope
> > > attribute.  There have been a number of threads around
> > > whether to single thread updates to a single table.
> > >
> > > For example, lets say that I read from a table in two
> > > programs and write/delete from a third.  For this example,
> > > lets say I want to single thread all writes.   To do this,
> > > would you use  scope="application" type="readonly" to lock
> > > the two read queries and scope="application" type="exclusive"
> > > around the write or would replace the scope attribute in both
> > > with something like name="databasename.tablename"?
> >
> >First of all...  Why in lord's name would you want to single
> >thread your DB access?
>Fairly common example:
> 
> You insert something in the database, and immediately 
> need to access 
> the ID of that new thing.  You want to single thread the 
> insert and select, 
> so the table doesn't change.
>  Example:
>Table1   (a fairly static table)
>Table2   (A table that changes a lot)
>Table1Table2  (an intersection table, because their is 
> a many to 
> many relationship between table 1 and table 2)
> 
>  Insert into table2
>  select the thing you just inserted into table2 (to get the ID)
>  Inset into intersection table.
> 
> 
>  You'll want to the first to SQL statements to be 
> single-threaded.  There are SQL commands to do this, the 
> commands commit and rollback come to mind.  I typically 
> just use CFTRANSACTION in those 
> cases, so I don't have the exact SQL syntax memorized.

Are you using MS SQL Server or Access here?  SQL Server and any other
halfway decent RDBMS should support something like the following
syntax:


SET NOCOUNT ON

INSERT INTO Table2 (Whatever) VAUES ('Thingy')

SELECT @@IDENTITY AS ThatSnazzyNewIDNumber

SET NOCOUNT OFF





INSERT INTO Table1Table2 (Table1ID, Table2ID) VALUES
(#WhateverHadTheTable1ID#, #Table2ID#)



Now you've got the ID without any chance of other updates messing you
up AND you don't need to limit the DB to only one update at a time. 
Pretty neat, ne?

> I think the remainder of this e-mail says it all about 
> naming vs scope in a lock, though.  ;)

I learned locking at the School Of Hard Knocks, and I've become
somewhat of a locking evangelist...  I'll get off my soapbox now...
*grin*

Best regards,
Zac Bedell

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.8 for non-commercial use 
Comment: Please use PGP!

iQA/AwUBOpVsuqvhLS1aWPxeEQLzswCgqz8aORvfImWJFl/9IEXQ/Ov8Q7IAoI5i
aziyM1EUWzwHn5anI/qT8XU0
=JOFP
-END PGP SIGNATURE-


~~
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: browser refresh/reload

[Jeffry Houser]

   I think you are referring to CGI Variables, which a server-based not 
ColdFusion based.  ColdFusion does have access to them, as indicated 
below.  Depending upon your application this may or may not work.  I do not 
know if the CGI variables refresh upon a page reload, but I suspect that a 
simple reload will not change the CGI variable to say where you were last.

At 11:35 AM 02/22/2001 -0600, you wrote:
>yes there is.  there coldfusion automatically creates a variable that
>contains the url or address that u came from to get to the current page.  it
>also gives u a variable which contains the url of the page u are on (I  am
>95% sure hehe).  so u can do a CFIF to see if the page the person came from
>matches the page he is at.  if it is true, then it must be a refresh
>
>-Original Message-
>From: Jay E Wigginton [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, February 22, 2001 10:52 AM
>To: CF-Talk
>Subject: browser refresh/reload
>
>
>Is there a way to determine in CF whether the page has been refreshed or
>reloaded?  Or maybe a method in JavaScript?
>
>thanks
>Jay
>
~~
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: Custom Tag??

[Erika L Walker]

Yes. Go to www.allaire.com/developer and search through the tags using
paging, next records, recordsets to name a few keywords

These are the ones I found with a cursory search... CF_NextRecords,
CF_Paging, CF_MoreResults

Erika



AIM: WebErika5
Yahoo: WebErika
MSN: WebErika

Erika L. Walker
Vice President
RUWebby, LLC
201-370-4272 (c)
973-244-9120 (o)
153 Rutgers Lane
Parsippany, NJ 07054

Website Design/Programming
Database Integration
Allaire Partner - ColdFusion



-Original Message-
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 22, 2001 12:28 PM
To: CF-Talk
Subject: Custom Tag??


Does anyone know of a custom tag that will allow output to be spread over
multiple pages?  In other words results 1-10 on page 1 and then 11-20 on
page 2 etc.

Thansk,
rich
~~
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

DB2 and Client Variables

[Nikki Woelk]

This is a multi-part message in MIME format.

--=_NextPart_000_008A_01C09CC4.2B564110
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

I'm trying to set up a client variable repository using DB2 7.1 on Red =
Hat Linux 7, Apache 1.3.14. After I create and verify the datasource =
successfully, when I attempt to set up the database for client variable =
storage and create the necessary tables, I receive this error message:=20

"Unable to create client tables If they already exist, you should =
uncheck Create Client Tables. DB2 Error Code =3D -604=20

[IBM][CLI Driver][DB2/LINUX] SQL0604N The length, precision, or scale =
attribute for column, distinct type, structured type, attribute of =
structured type, function, or type mapping "DATA" is not valid. =
SQLSTATE=3D42611"=20

Since the automatic creation doesn't work, I set up the 2 tables =
manually, with the following fields: CDATA - cfid char 20, app char 64, =
data long varchar; CGLOBAL - cfid char 20, data long varchar, lvisit =
timestamp (also tried date).=20

I attempt to use my application, and when it's time to submit a form, I =
receive this error message:=20

"DB2 Error Code =3D -104=20

[IBM][CLI Driver][DB2/LINUX] SQL0104N An unexpected token "2001" was =
found following "15:23:26''}#','{ts '". Expected tokens may include: "". =
SQLSTATE=3D42601"=20

At the bottom of the error page is this: "Found The document has moved =
here." - with the word 'here' correctly hyperlinked to the page that the =
form was supposed to return.=20

It looks like data is being written to the CDATA table, but not the =
CGLOBAL table.=20

The application will eventually sit on clustered servers, so that's why =
we're going the database repository route.=20

As a workaround, we've installed MySql and are successfully using that =
as the client variable repository, but ideally we'd like to use DB2 for =
both the data and client variables.=20

Does anyone have any experience or advice with this? Thanks.=20

--
Nikki Woelk
Faludi Computing, Inc.  (415) 512-8212
[EMAIL PROTECTED] http://www.faludicomputing.com

--=_NextPart_000_008A_01C09CC4.2B564110
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable










I'm trying to set up a client variable repository using DB2 7.1 on =
Red Hat=20
Linux 7, Apache 1.3.14. After I create and verify the datasource =
successfully,=20
when I attempt to set up the database for client variable storage and =
create the=20
necessary tables, I receive this error message:=20
"Unable to create client tables If they already exist, you should =
uncheck=20
Create Client Tables. DB2 Error Code =3D -604=20
[IBM][CLI Driver][DB2/LINUX] SQL0604N The length, precision, or scale =

attribute for column, distinct type, structured type, attribute of =
structured=20
type, function, or type mapping "DATA" is not valid. SQLSTATE=3D42611"=20
Since the automatic creation doesn't work, I set up the 2 tables =
manually,=20
with the following fields: CDATA - cfid char 20, app char 64, data long =
varchar;=20
CGLOBAL - cfid char 20, data long varchar, lvisit timestamp (also tried =
date).=20
I attempt to use my application, and when it's time to submit a form, =
I=20
receive this error message:=20
"DB2 Error Code =3D -104=20
[IBM][CLI Driver][DB2/LINUX] SQL0104N An unexpected token "2001" was =
found=20
following "15:23:26''}#','{ts '". Expected tokens may include: "".=20
SQLSTATE=3D42601"=20
At the bottom of the error page is this: "Found The document has =
moved here."=20
- with the word 'here' correctly hyperlinked to the page that the form =
was=20
supposed to return.=20
It looks like data is being written to the CDATA table, but not the =
CGLOBAL=20
table.=20
The application will eventually sit on clustered servers, so that's =
why we're=20
going the database repository route.=20
As a workaround, we've installed MySql and are successfully using =
that as the=20
client variable repository, but ideally we'd like to use DB2 for both =
the data=20
and client variables.=20
Does anyone have any experience or advice with this? Thanks. =

--Nikki WoelkFaludi Computing,=20
Inc.  (415) =
512-8212mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]   &n=
bsp;=20
http://www.faludicomputing.com">http://www.faludicomputing.com

--=_NextPart_000_008A_01C09CC4.2B564110--


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

RE: Cheaper Alternative to SQL Server 2000

[Zachary Bedell]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

> Well, there's always MySQL, but I bet there's a chorus of 
> folks here who'll
> say it ain't ready for primetime, which is why I'm posting... 
>  could anyone
> expound on this? Especially using mySQL with CF.

Ok...  I'll bite...

Probably the biggest things about MySQL that aren't ready for prime
time are these:

1) Its support for transactions is limited (at best!).  I know
they're working on that and it's getting better, but that's a fairly
big limitation for some situations.

2) As far as I know, it still doesn't support any kind of stored
procedure.

3) They take shortcuts on things like log-before-write that can cause
data loss or corruption if your server loses power or if MySQL goes
down hard.  Microsoft SQL Server is pretty close to bullet-proof in
that regard.  If SQL Server tells ODBC that data was written, then
indeed it will be written -- either permanently to the DB or at least
to the log where it will be recovered if anything unpleasant happens
to the server.  MySQL doesn't do that, so there's a chance of
problems.  I've never run into any, but it's mathematically
possible

4) MySQL's support for JOINs is fairly dumb in my experience.  I find
I have to use completely different syntax to do the same things in
SQL Server / MS Access then I do for MySQL.


That's not to say MySQL doesn't have it's plusses.  It *is* free. 
I've got the MP3 player in the trunk of my car running MySQL and it
works just *fine*.  I just wouldn't want to sick a thousand paying
customers on that server and hope it keeps working through it...

That's just my jaded opinion of course, so please take it with the
proper grain of salt...

Best regards,
Zac Bedell

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.8 for non-commercial use 
Comment: Please use PGP!

iQA/AwUBOpVqcKvhLS1aWPxeEQIqvwCg9CPpRT2K4DZyloBKYUDP7JvuTCoAoOxC
CippPV+adIoyx7ZEQPHH7zqQ
=YGHK
-END PGP SIGNATURE-


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

Search form with selection boxes

[kawahl]

I am trying to set up a page where the user can search 
the database with use of the selection boxes.  I do not 
want a default value or set have the default set at 
null.  Any suggestions?

Thanks
Kim Foley
Webmaster
William and Mary Quarterly

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