Re: Where is the best place to put business rules?

[Adam Churvis]

Thanks for the kind words, Tony! :)

Kevin, it certainly is true that you can call stored procedures from within
triggers, but your stored procedures will not have direct access to the
Inserted and Deleted pseudotables (if you are using SQL Server) that are
created and accessible only within the trigger itself.

The logic for calling stored procedures from within Oracle's row-level
triggers is much more straightforward because the :New and :Old pseudorows
are single instances of directly accessible data, rather than the _sets_ of
new and old (inserted and deleted) data accessible within SQL Server's
statement-level triggers.

Accessing, manipulating, and joining to the new and old images of data are
the most powerful features of triggers, aside from the fact that they are
the only method for reliably binding business logic to data.  With SQL
Server's statement-level triggers, pseudotables also provide the only
scalable way to perform user-defined relational updates or relational
deletes between tables.

Calling stored procedures from triggers are fine when you are performing
either tasks that don't require parameters, or when you can reliably
restrict your pseudotable's data set to a single instance (row) that you can
directly access like you would an Oracle pseudorow, and then pass those
values as parameters to your called stored procedures.  Beware restricting
your triggers' pseudotables to single rows, though, as that also restricts
the triggering table to single-row transactions, and that is a slippery
slope that quickly leads to destroying your relational database's ability to
enforce its DRI (Declarative Referential Integrity) constraints.  It gets
tempting to guarantee a single row in either the Inserted or Deleted
pseudotables by rolling back everything if @@ROWCOUNT > 1 in the trigger,
but most of the time that blocks other processes from successfully
completing elsewhere in your database, so beware.

Happy triggering! :)

Respectfully,

Adam Phillip Churvis
Certified Advanced ColdFusion 5 Developer
Productivity Enhancement, Inc.
http://www.ColdFusionTraining.com
E-mail:  [EMAIL PROTECTED]
Phone:   770-446-8866

- Original Message -
From: "Kevin Gilchrist" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 6:24 PM
Subject: RE: Where is the best place to put business rules?


> This is what we do too with a slight difference in that our triggers
> call stored procedures.
> Sometimes triggers may need to perform similar business functions
> (look-ups etc.) so this way we can maintain a common set of functions.
>
> And because we call stored procedures we never have to think of the
> security concerns (and overhead) of checking URL vars for SQL
> statements.
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 4:19 PM
> To: CF-Talk
> Subject: RE: Where is the best place to put business rules?
>
>
> in the great words of Adam Churvis.
>
> What would happen if someone decided to update your database using Excel
> ODBC connection? The stored procedure wouldn't run. But if you had your
> business logic in the trigger, it would fired upon an insert, update, or
> delete.
>
>
> That man knows best. Since then I put all my business logic inside of
> triggers.
>
>
> Anthony Petruzzi
> Webmaster
> 954-321-4703
> http://www.sheriff.org
>
>
> -Original Message-
> From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 4:17 PM
> To: CF-Talk
> Subject: RE: Where is the best place to put business rules?
>
>
> I've often wondered about this is there really a need for a third tier,
> what
> would you put in the third tier that you *couldn't* put in a stored proc
> apart from file operations?
>
> Thanks
>
> Kola
>
> > >-Original Message-
> > >From: Dave Watts [mailto:[EMAIL PROTECTED]]
> > >Sent: 03 April 2002 15:02
> > >To: CF-Talk
> > >Subject: RE: Where is the best place to put business rules?
> > >
> > >
> > >> 1) Where is the best place to put the business rules? CF
> > >> Templates (using CFTransaction), or Stored Procedures (using
> > >> SQL Transactions). We realize that some business rules need
> > >> to reside on the templates, such as client side data validation.
> > >> But processing pages are a different story.
> > >
> > >In general, I think that stored procedures are better for any
> > >generic data
> > >manipulation tasks. Using stored procedures provides many
> > >advantages, such
> > >as more efficient processing and the ability to more easily replace
> or
> > >augment the presentation layer code.
> > >
> > >You did mention n-tier apps, and it's worth pointing out that in a
> > >three-tier app, the things you generally think of as "business
> > >rules" would
> > >be implemented in the middle tier, between the presentation
> > >layer code (CF,
> > >in this case) and the database. However, to the extent that your
> business
> > >rules are data manipulation 

Re: CF Scheduler - Weekly and Monthly events?

[Jim McAtee]

I just found this posted in the CF forums at macromedia.com.  Is it true?

---
"Interval" refers to the period of time that the scheduler will execute
relative to the "startdate" and "starttime" set in the cfschedule tag.

If interval is set to "Monthly" and "startdate" is set to "april 1st"
and "enddate" is set to be perpetual then 30 days later the scheduler
will execute on april 30th (not May 1st) and 30 days after that
(May 29th) and so on. "Monthly" does not take into account the 1st day
of each month.
---

If so, I'm obviously going about scheduling something for the first of every
month all wrong.  I would need to schedule the task to run daily and then
have the template check the date to see if it's the first.

Jim


- Original Message -
From: "Jim McAtee" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 5:21 PM
Subject: CF Scheduler - Weekly and Monthly events?


> It's not absolutely clear how the CF scheduler handles weekly or monthly
> scheduled events.  In the CF Administrator, it requires a time of day, but
> doesn't ask for a day of month, or a day of week.  I assume then that
> monthly scheduled task must go off on the day of month that coincides with
> the Start Date?  I.E., if you schedule something to start on 05/03/2002,
> then it would always execute on the third of the month?
>
> Similarly, with weekly scheduled events, does it figure out what day of
week
> the start date happens to fall on, then run the task on that same weekday
> each week?
>
> One thing that must be a bug in the CF Administrator (CF5) is that when
you
> edit a weekly or monthly event, it always resets the  box back to
> "Daily".
>
> Jim
>
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: How do you send a ColdFusion variable to a Flash Movie?

[Gary Groomer]

The solution was so simple, but it didn't occur to try it.

Thanks, Gary

- Original Message -
From: "Jim Curran" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 3:10 PM
Subject: RE: How do you send a ColdFusion variable to a Flash Movie?


> I like this way the best:
>
>
> mymovie.swf?var1=value1&var2=value2
>
> -Original Message-
> From: Gary Groomer [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 5:58 PM
> To: CF-Talk
> Subject: How do you send a ColdFusion variable to a Flash Movie?
>
>
> I got roped into creating a small Flash movie for a client.  Creating the
> Flash movie was simple, but I can't figure out how to send a ColdFusion
> variable to the Flash movie.  It should be simple, but I can't seem to
find
> how to do it in the Flash documentation without saving the variable to a
> file.  If I save it to a file, it works great.
>
> Basically, ColdFusion will create a variable by querying a database and
then
> it will do some string manipulation.  This variable, intern, needs to be
> passed directly on to a Flash movie.  If anyone can direct me in the right
> direction, it would be greatly appreciated.
>
> Gary Groomer
>
>
> 
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF_AutoLogout (was RE: Auto logout when leaving the applicati on)

[JAIME HOI]

Hi 
i can't use this tag because user could be keying in data so if i
activate this autologout they will not be able to save their data .
  Does anyone know what event will be triggered when user type in another
url ? If we can capture this event then we can handle the auto logout for
the user. 

-Original Message-
From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 4:30 AM
To: CF-Talk
Subject: CF_AutoLogout (was RE: Auto logout when leaving the application)


I have seen several people post questions regarding this matter before, so I
built this little tool:

CF_AutoLogout v1.0
http://www.brdwrks.com/downloads/AutoLogout.zip

This tool will automatically send a user to a logout page if that user is
inactive for a specified amount of time.

USAGE:



This tag basically just writes the window watcher JavaScript that will do a
redirect after a certain amount of time.  You will need a script which
actually expires the user's session / logs the user out, and you will
specify this script as the LogoutLocation.

The tag is self documented, but if you have any questions, please let me
know.

Enjoy!


--
Scott Van Vliet
Senior Analyst
SBC Services, Inc.
ITO Enterprise Tools
Office: 858.886.3878
Pager: 858.536.0070
Email: [EMAIL PROTECTED]


-Original Message-
From: VAN VLIET, SCOTT E (SBCSI)
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 11:05 AM
To: CF-Talk
Subject: RE: Auto logout when leaving the application


I am building a JS tool that will automate this process.  I will post it..

--
Scott Van Vliet
Senior Analyst
SBC Services, Inc.
ITO Enterprise Tools
Office: 858.886.3878
Pager: 858.536.0070
Email: [EMAIL PROTECTED]
 


-Original Message-
From: Shawn Regan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 9:20 AM
To: CF-Talk
Subject: RE: Auto logout when leaving the application


I believe I got this a while back from hal helms website.


  
  
  
  


this kills the client/session variables when the browser closes because it
has taken the cookies set by the cfapplication and resets them to expire
when the browser closes.


Shawn Regan
Applications Developer
Pacific Technology Solutions 

-Original Message-
From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 8:49 AM
To: CF-Talk
Subject: RE: Auto logout when leaving the application


I am working on a custom tag that will solve this, and will post it when I
finish.

--
Scott Van Vliet
Senior Analyst
SBC Services, Inc.
ITO Enterprise Tools
Office: 858.886.3878
Pager: 858.536.0070
Email: [EMAIL PROTECTED]


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 8:41 AM
To: CF-Talk
Subject: Re: Auto logout when leaving the application


Good question.  I am also interested in this response, but with an added
element.  What if a user closes the browser, how do you kill client/session
variables, presumably someone could close the browser thinking they are
"logged out", the next person wanders up and sees the first persons
information.

CC


 

Brian Fox

   
@sdccd.cc.ca.cc:

us>  Subject: Auto logout when
leaving the application 
 

04/03/02

10:30 AM

Please

respond to

cf-talk

 

 





What's the best way of handling security for a website that may be used in
a
kiosk mode?  I'm working on a student grade system that does a one time
validation and sets a session variable.  Timeout is 15 minutes.

John may log into the system using a lab computer to retrieve his student
grades, become confused, wander to yahoo, read his mail, then leave the
computer as is.  Sue may come in to use the same machine, go to the grade
application to get her grades, and still be logged in as John.  Is there a
good way to avoid this?

I'm thinking about mangling the referer variable and zapping the session
variables if the referer is not from the application.

 i.e. http://www.gradesrus.com/"; ...
session.auth=0>

That would solve the 'lost' client wandering out of the site.  Leaving the
site is equivalent to logging out then (more or less).

What about a javascript warning when a person is going to leave the
application?  I'm not a javascript guru, but it seems like an onunload in
the body should be able to give a popup alert and hopefully the ability to
cancel the outside navigation.  Anyone ever try it?

Is there a better approach to this?

Thanks!
Brian







__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-ta

RE: UDF or Custom Tag

[Will Swain]

I've used one called cf_createLinks, which may be the one Ray is referring
to. Works well.

will

-Original Message-
From: chris.alvarado [mailto:[EMAIL PROTECTED]]
Sent: 03 April 2002 17:45
To: CF-Talk
Subject: UDF or Custom Tag


does anyone have a UDF or Custom tag that will turn,

http://www.yahoo.com into http://www.yahoo.com";>http://www.yahoo.com


i would just build it myself but im swamped.

thanks a million.

-chris.alvarado
[application.developer]
4 Guys Interactive, Inc.



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

RE: reverse engineering database structure

[Kevin Gilchrist]

The new version of Visio that comes with Visual Studio .Net Enterprise
Edition (what a mouthful) will do this and allow you to apply schema
changes back to the database if you so wish.

It's pretty nice although it had some difficulty when we pointed it at
our Oracle database and it refused to apply some changes citing some
arcane relationship rules (wouldn't allow multiple foreign keys between
two tables).

-Original Message-
From: Garza, Jeff [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 6:49 PM
To: CF-Talk
Subject: RE: reverse engineering database structure


I think I remember being able to do this with Visio 2000 Enterprise
version.
You can basically point it at a datasource and it will determine the
database structure and diagram it out...

I'm not sure if the newer versions also have this capability.

HTH,

Jeff Garza


-Original Message-
From: Douglas Jordon [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 4:32 PM
To: CF-Talk
Subject: reverse engineering database structure


We're building a site for a company that uses a very complex inventory 
and accounting system that's based on SQL Server. We'd like to use only 
a few fields from the database maybe a dozen or so to display some items

on the web. There are a lot of tables, a 100 or so. There aren't very 
many relationships; a table might have four foreign keys but only one 
realtionship. Lots of SPs and Views. There is no diagram.

How should I go about understanding this structure? Remember, I only 
need a few fields.

Reading the MCSE book, it looked as if maybe a trace would be the way to
go.

As always, all suggestions are appreciated.

TIA,

Doug Jordon



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

RE: Exporting data to Excel spreadsheet

[Mike Kear]

Thanks Seamus,  That's the exact thing I need!  I just got it and tried it
out and it took me all of 5 minutes to get it to work.   I can see it's
going to be exactly what I need.  Programmable enough to be able to
dynamically assign the correct tables to the various login ids and they'll
be able to click a button in the admin module and get the correct table sent
as a spreadsheet in seconds.


Thanks for the other suggestions too.  I can see they're helpful, but in
this case it's the Query2Excel tag that takes the statuette home tonight.



Cheers,
Mike Kear
Windsor, NSW, Australia
AFP WebWorks


-Original Message-
From: Seamus Campbell [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 5:39 PM
To: CF-Talk
Subject: Re: Exporting data to Excel spreadsheet

Try CF_Query2Excel tag - works very well

if you can't find it on Macromedia send me another email - I've got a copy
here somewhere

Seamus


At 05:23 pm 3/04/02 , you wrote:
>At one of my clients, the content providers each look after an allocated
>part of the data used for displaying information on the web site. They
>want to be able to export their data to a spreadsheet so they can review
>it and update it off line.  These are not IT people but experts in their
>various consumer fields.  They want me to put a button in their admin
>areas for each category of comsumer data so it will export the data for
>them automatically.  I was going to do it this way and I wondered if there
>was a better way:
>
>
>(1)  Have a spreadsheet already attached to CF as a datasource.
>(2)  Use a CFQuery to delete all the records in that datasource.
>(3)  CFQUERY the SQL7 table the content provider wants to export
>(4)  loop through the query, inserting the data into the (now blank)
>spreadsheet.
>(5)  Use CFMail to email the spreadsheet to the user (getting their email
>address from their logon details).
>
>I seem to remember a function or a tag that output the results of a query
>into spreadsheet format but I can't find any reference to it any more.
>Can anyone enlighten me?
>
>
>Is this the easiest way?   Will CFMail be able to send the spread sheet or
>will I need to unlock it from the server first? in which case, how can i
>do that automatically?
>

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

CF Scheduler - Weekly and Monthly events?

[Jim McAtee]

It's not absolutely clear how the CF scheduler handles weekly or monthly
scheduled events.  In the CF Administrator, it requires a time of day, but
doesn't ask for a day of month, or a day of week.  I assume then that
monthly scheduled task must go off on the day of month that coincides with
the Start Date?  I.E., if you schedule something to start on 05/03/2002,
then it would always execute on the third of the month?

Similarly, with weekly scheduled events, does it figure out what day of week
the start date happens to fall on, then run the task on that same weekday
each week?

One thing that must be a bug in the CF Administrator (CF5) is that when you
edit a weekly or monthly event, it always resets the  box back to
"Daily".

Jim

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

Re: Only permit execution from CF scheduler

[Jim McAtee]

Yeah, testing it myself is always the last option. :)  Doing so, I found
what I what I was looking for:

HTTP_USER_AGENT=CFSCHEDULE

Thanks,
Jim


- Original Message -
From: "Jim Curran" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 4:52 PM
Subject: RE: Only permit execution from CF scheduler


> Test it, have teh scheduler run and in the template ,  yourself
the
> cgi.REMOTE_ADDR var and then use that.  OTTOMH, It should be one of the
> bound IP's, but which one it chooses seems to be random.
>
> - j
>
> -Original Message-
> From: Jim McAtee [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 6:46 PM
> To: CF-Talk
> Subject: Re: Only permit execution from CF scheduler
>
>
> Any idea if will it be returned as 127.0.0.1, or one of the bound IP
> addresses?
>
> Jim
>
>
> - Original Message -
> From: "Jim Curran" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, April 03, 2002 4:19 PM
> Subject: RE: Only permit execution from CF scheduler
>
>
> > You can check that the cgi.REMOTE_ADDR is the IP of the computer the CF
> > scheduler is running on.
> >
> > - j
> >
> > -Original Message-
> > From: Jim McAtee [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, April 03, 2002 6:13 PM
> > To: CF-Talk
> > Subject: Only permit execution from CF scheduler
> >
> >
> > I'd like to only permit the running of a certain template through the CF
> > scheduler.  I know this is easily done by simply placing the source
> > directory outside of the web space, but for a couple of reasons this
> > particular template needs to be in a web-accessible directory.  I'm
> guessing
> > that there may be one or more CGI variable that would tell me if the
> > scheduler is executing the template.  Any ideas?
> >
> > Jim

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

Re: DSNless query

[James Sleeman]

I always use

 
 
 



- Original Message -
From: "Bruce, Rodney (SIGNAL)" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, April 04, 2002 10:26 AM
Subject: DSNless query


> Hello all
>
> Hoping someone can tell me what I am missing here.
> We are running:  CF5 NT  ACCESS2K
>
> 
>
> 
> SELECT DrawingDetails.*
> FROM DrawingDetails
> WHERE DrawingDetails.ESID=5;
> 
>
>
>
> I get the error:
> Error Diagnostic Information
> ODBC Error Code = IM002 (Data source not found and no default driver
> specified)
>
>
> [Microsoft][ODBC Driver Manager] Data source '' not found and no default
> driver specified
>
> Hint: In order to use ODBC data sources with Cold Fusion you must create
the
> data source using the Data Sources page of the Cold Fusion Administrator.
In
> addition, if you are running under Windows NT you must make sure that the
> Data Source is created as a System DSN in order for it to be available to
> ColdFusion.
>
>
>
> The error occurred while processing an element with a general identifier
of
> (CFQUERY), occupying document position (4:1) to (4:68).
>
>
> Date/Time: 04/03/02 15:31:44
> Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
> Remote Address: 137.80.60.254
>
>
> Thanks for any help
> 
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Web based Chat

[Scott Van Vliet]

Unity Socket Server - http://moock.org/unity/
Flash-based chat engine (with both server and client connectivity).

HTH


-Original Message-
From: chris.alvarado [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 3:12 PM
To: CF-Talk
Subject: Web based Chat

A client wants some type of web-based chat integrated into their site.
It
would be nice if I could incorporate the Chat into the existing security
system.

Obviously any type of streaming chat would probably be Java-based but
that
is fine.

I remember "back in the day" I would use Peri-Chat, so something similar
would be nice.

Thanks for any recommendations.

-chris.alvarado
[application.developer]
4 Guys Interactive, Inc.


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

RE: Only permit execution from CF scheduler

[Jim Curran]

Test it, have teh scheduler run and in the template ,  yourself the
cgi.REMOTE_ADDR var and then use that.  OTTOMH, It should be one of the
bound IP's, but which one it chooses seems to be random.

- j

-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 6:46 PM
To: CF-Talk
Subject: Re: Only permit execution from CF scheduler


Any idea if will it be returned as 127.0.0.1, or one of the bound IP
addresses?

Jim


- Original Message -
From: "Jim Curran" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 4:19 PM
Subject: RE: Only permit execution from CF scheduler


> You can check that the cgi.REMOTE_ADDR is the IP of the computer the CF
> scheduler is running on.
>
> - j
>
> -Original Message-
> From: Jim McAtee [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 6:13 PM
> To: CF-Talk
> Subject: Only permit execution from CF scheduler
>
>
> I'd like to only permit the running of a certain template through the CF
> scheduler.  I know this is easily done by simply placing the source
> directory outside of the web space, but for a couple of reasons this
> particular template needs to be in a web-accessible directory.  I'm
guessing
> that there may be one or more CGI variable that would tell me if the
> scheduler is executing the template.  Any ideas?
>
> Jim
>
>
>

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

RE: reverse engineering database structure

[Garza, Jeff]

I think I remember being able to do this with Visio 2000 Enterprise version.
You can basically point it at a datasource and it will determine the
database structure and diagram it out...

I'm not sure if the newer versions also have this capability.

HTH,

Jeff Garza


-Original Message-
From: Douglas Jordon [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 4:32 PM
To: CF-Talk
Subject: reverse engineering database structure


We're building a site for a company that uses a very complex inventory 
and accounting system that's based on SQL Server. We'd like to use only 
a few fields from the database maybe a dozen or so to display some items 
on the web. There are a lot of tables, a 100 or so. There aren't very 
many relationships; a table might have four foreign keys but only one 
realtionship. Lots of SPs and Views. There is no diagram.

How should I go about understanding this structure? Remember, I only 
need a few fields.

Reading the MCSE book, it looked as if maybe a trace would be the way to go.

As always, all suggestions are appreciated.

TIA,

Doug Jordon


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

Re: Fw: Problem with EMBED and OBJECT tags.

[William H. Bowen]

tried that, no dice.

Thanks for the suggestion. :o)

will


William H. Bowen
Webmaster
ALSTOM's Energy Management and Markets Business

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

- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 2:31 PM
Subject: Re: Fw: Problem with EMBED and OBJECT tags.


> Try putting the  directly around the #url.mov#.
>
> Eg. #url.mov#
>
> -Hugh
>
>
>   I'm having trouble getting a EMBED/OBJECT tag to recognize a varible as
a
>   filename.
>
>   Original code:
>
>HEIGHT="196" CODEBASE="http://www.apple.com/qtactivex/qtplugin.cab";>
> 
VALUE="http:[EMAIL PROTECTED]";>
> 
> 
> 
>SRC="http:[EMAIL PROTECTED]";
>   WIDTH=240 HEIGHT=196 AUTOPLAY=true CONTROLLER=true LOOP=false
>   PLUGINSPAGE="http://www.apple.com/quicktime/";>
>
> 
>
>   works like a champ
>
>   
>HEIGHT="196" CODEBASE="http://www.apple.com/qtactivex/qtplugin.cab";>
>VALUE="http://intranet.esca.com/documents/mpeg/brownbag/#url.mov#.mov";>
> 
> 
> 
>SRC="http://intranet.esca.com/documents/mpeg/brownbag/#url.mov#.mov";
>   WIDTH=240 HEIGHT=196 AUTOPLAY=true CONTROLLER=true LOOP=false
>   PLUGINSPAGE="http://www.apple.com/quicktime/";>
>
> 
>  
>
>   the variable is passed as follows:
>
>
>
index.cfm?action=qt&gc_ID=8B9D5438-1C10-11D6-94DB0002A50741F5&mov=esca_@stak
>  e_1
>
>  (the spaces at the end of the string are Underscores...)
>
>   Fails with the following message:
>
>   Plugin Error
>  The data that the plugin requested, did not download successfully
>
>   Anyone with thoughts?
>
>  CF Server 5
>  WinNT 4sp6a
>
>   viewed on
>  WinNT Workstation 4sp6a
>  IE6 and QT
>
>   Thanks all :o)
>
>   will
>  
>
>  William H. Bowen
>  Webmaster
>  ALSTOM's Energy Management and Markets Business
>
>   [EMAIL PROTECTED]
>  http://www.esca.com/
>
>
>
> 
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: OT: Multiple hotmail messages bounce

[Gordon Burns]

At 00:03 04/04/2002 Don Vawter said
>I send out about 700 email messages a day to people who have signed up to
>receive a daily cryptogram. If I send them all at once nearly all of the
>message to hotmail accounts
>bounce. If I space them throughout the day they get delivered. Apparently
>hotmail interprets multiple
>emails in a short period of time as spam and rejects them.
>
>Does anyone have a solution for this? I have tried using a different return
>email address on each message but that makes no difference. I have
>communicated the problem to Hotmail's customer service but that is worse
>than talking to a wall.


I think you need to deliver the mails to Hotmail in bunches of 8 or 
less at a time.

If you are using CF mail I do not think you can vary this.

We solved this fairly easily using iMS as you can set the "Max 
Recipients" in the tag used to send the mail.

Wall's at least are clearly in existence I am not sure the same can 
be said about Hotmail's service.

Gordon




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

Re: Only permit execution from CF scheduler

[Jim McAtee]

Any idea if will it be returned as 127.0.0.1, or one of the bound IP
addresses?

Jim


- Original Message -
From: "Jim Curran" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 4:19 PM
Subject: RE: Only permit execution from CF scheduler


> You can check that the cgi.REMOTE_ADDR is the IP of the computer the CF
> scheduler is running on.
>
> - j
>
> -Original Message-
> From: Jim McAtee [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 6:13 PM
> To: CF-Talk
> Subject: Only permit execution from CF scheduler
>
>
> I'd like to only permit the running of a certain template through the CF
> scheduler.  I know this is easily done by simply placing the source
> directory outside of the web space, but for a couple of reasons this
> particular template needs to be in a web-accessible directory.  I'm
guessing
> that there may be one or more CGI variable that would tell me if the
> scheduler is executing the template.  Any ideas?
>
> Jim
>
>
> 
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: mystery page named FFFFFF

[Lon Lentz]

  Just a thought: Are there places where a color is set to "#FF" and within 
 tags and contains only one pound sign "#"? Perhaps CF is doing something 
funky like running the FF into your form tag's action value. And if you are using 
a pound encased CF variable as your action value, things could get kinda funky.


> -Original Message-
> From: Chris Norloff [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 4:09 PM
> To: CF-Talk
> Subject: mystery page named FF
> 
> 
> This might or might not be a CF problem: we routinely get 404 
> errors when the application looks for a page named "FF". 
> Somehow a link is getting corrupted and we've been unable to 
> track it down.
> 
> It happens all over our application, with no real pattern.  It 
> appears more often after calling a style sheet, but it appears 
> even when we're not calling the style sheet.
> 
> Anybody seen anything like this?

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

RE: Stored procedure - use dbo.?

[Jared Clinton]

Reading this article might help in your situation :
http://www.sqlservercentral.com/columnists/bkelley/procedurecache.asp#Owners
hip

Unfortunately you need to register at this site to read the article :(

Jared Clinton
NEC Australia

-Original Message-
From: Matt Kornguth [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 4 April 2002 1:23 AM
To: CF-Talk
Subject: Stored procedure - use dbo.?


Thought I read/heard somewhere that prefacing the stored procedure name in
the cfstoredproc tag with "dbo." would reduce the amount of SQL Server
recompiling taking place, e.g.:






Does anyone have any experience with this from a best practices standpoint?
Advantages/disadvantages?

Thanks in advance,
Matt Kornguth
Web Applications Developer
BLR



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

reverse engineering database structure

[Douglas Jordon]

We're building a site for a company that uses a very complex inventory 
and accounting system that's based on SQL Server. We'd like to use only 
a few fields from the database maybe a dozen or so to display some items 
on the web. There are a lot of tables, a 100 or so. There aren't very 
many relationships; a table might have four foreign keys but only one 
realtionship. Lots of SPs and Views. There is no diagram.

How should I go about understanding this structure? Remember, I only 
need a few fields.

Reading the MCSE book, it looked as if maybe a trace would be the way to go.

As always, all suggestions are appreciated.

TIA,

Doug Jordon

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

RE: CF doing strange things with dates

[Jared Clinton]

Cold Fusion in general likes dates to be in US format.

It is a sensitive area in which your application may seem to work on most
days of the year :)

I try to pass dates around in the format 'dd/MMM/' as in 03/Apr/2002
this way databases don't get confused and all processes cannot
'misunderstand' a date.

Jared Clinton
NEC Australia



-Original Message-
From: Simon Whittaker [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 3 April 2002 11:10 PM
To: CF-Talk
Subject: Re: CF doing strange things with dates


why not use cf_cal, not sure about cross browser compatability but it is
worth checking it out. you can then make the text box read only to ensure
that the user cannot edit the date that is inserted. Is available in the
developers gallery at macromedia.com

HTH

Simon
- Original Message -
From: "Tristram Charnley" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 2:14 PM
Subject: Re: CF doing strange things with dates


> Stephen
>
> I'd already figured out the list items thing but thanks anyway. I had
> considered using select boxes  but there are quite a few date fields on
the
> form and it would be a bit clunky.
>
> It occurred to me that the TwoSelectsRelated tag could also be a good way
to
> ensure correct dates
> were being passed.
>
> Tristram
>
>
> - Original Message -
> From: "Stephen Moretti" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, April 03, 2002 1:50 PM
> Subject: Re: CF doing strange things with dates
>
>
> > Tristram,
> >
> > You're right about all the hashes/pound signs, but the 3 refers to the
> item
> > in the list rather than the list delimiter i.e.. the year.
> >
> >  >
>
createdate(listgetat(userdate,3,"-"),listgetat(userdate,2,"-"),listgetat(use
> > rdate,1,"-"))>
> >
> > Should do the trick.  Also you might want to look at the Locale
functions
> to
> > ensure that CF handles your dates correctly.
> >
> > Generally I tend to make sure that users are entering valid dates, by
> giving
> > them 3 drop downs, one for day, month and year and checking that they
> > haven't entered anything daft like the 31 Feb and make sure that the
year
> is
> > restricted to sensible values (i.e.. Credit Card expiry date has to be
in
> > the future)
> >
> > Hope that helps
> >
> > Regards
> >
> > Stephen
> >
> > - Original Message -
> > From: "Tristram Charnley" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Wednesday, April 03, 2002 1:06 PM
> > Subject: Re: CF doing strange things with dates
> >
> >
> > > Umm. There are only 2 delimiters in the list and I don't think you
need
> > all
> > > the # signs
> > >
> > > Tris
> > >
> > > - Original Message -
> > > From: "Jille Floridor" <[EMAIL PROTECTED]>
> > > To: "CF-Talk" <[EMAIL PROTECTED]>
> > > Sent: Wednesday, April 03, 2002 12:42 PM
> > > Subject: RE: CF doing strange things with dates
> > >
> > >
> > > > It's probably not the most correct solution, but I use something
like
> > this
> > > > to vaildate European dates:
> > > > 
> > > >
> > > >
> > >
> >
>
#createdate(#listgetat("#userdate#",3,"-")#,#listgetat("#userdate#",2,"-")#,
> > > > #listgetat("#userdate#",1,"-")#)#
> > > >
> > > >  > > >
> > > > 
> > > >
> > > > There are probably more efficient ways to do this, but this works
fine
> > for
> > > > me. Hope it helps.
> > > >
> > > > Jille
> > > >
> > > >
> > > > -Original Message-
> > > > From: Tristram Charnley
[mailto:[EMAIL PROTECTED]]
> > > > Sent: woensdag 3 april 2002 13:37
> > > > To: CF-Talk
> > > > Subject: CF doing strange things with dates
> > > >
> > > >
> > > > I want users to enter dates in forms using  European format dates
> > > > (dd/mm/yy).
> > > >
> > > > But CF is converting dates on or before the 12th of the month to the
> US
> > > > format - {d '2002-12-04'} while dates after the 12th are being
> formatted
> > > as
> > > > European - {d '2002-04-13'}
> > > >
> > > > This happens with both CreateODBCDate and CFQUERYPARAM.
> > > >
> > > > Unless I'm missing something this makes Eurodate validation pretty
> > > > pointless...
> > > >
> > > > Any suggestions?
> > > >
> > > >
> > > >
> > > > Tristram Charnley
> > > > ---
> > > > [EMAIL PROTECTED]
> > > > Allaire Certified ColdFusion Developer
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> >
> 

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

RE: Where is the best place to put business rules?

[Kevin Gilchrist]

This is what we do too with a slight difference in that our triggers
call stored procedures.
Sometimes triggers may need to perform similar business functions
(look-ups etc.) so this way we can maintain a common set of functions.

And because we call stored procedures we never have to think of the
security concerns (and overhead) of checking URL vars for SQL
statements.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 4:19 PM
To: CF-Talk
Subject: RE: Where is the best place to put business rules?


in the great words of Adam Churvis.

What would happen if someone decided to update your database using Excel
ODBC connection? The stored procedure wouldn't run. But if you had your
business logic in the trigger, it would fired upon an insert, update, or
delete.


That man knows best. Since then I put all my business logic inside of
triggers.


Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org


-Original Message-
From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 4:17 PM
To: CF-Talk
Subject: RE: Where is the best place to put business rules?


I've often wondered about this is there really a need for a third tier,
what
would you put in the third tier that you *couldn't* put in a stored proc
apart from file operations?

Thanks

Kola

> >-Original Message-
> >From: Dave Watts [mailto:[EMAIL PROTECTED]]
> >Sent: 03 April 2002 15:02
> >To: CF-Talk
> >Subject: RE: Where is the best place to put business rules?
> >
> >
> >> 1) Where is the best place to put the business rules? CF
> >> Templates (using CFTransaction), or Stored Procedures (using
> >> SQL Transactions). We realize that some business rules need
> >> to reside on the templates, such as client side data validation.
> >> But processing pages are a different story.
> >
> >In general, I think that stored procedures are better for any
> >generic data
> >manipulation tasks. Using stored procedures provides many
> >advantages, such
> >as more efficient processing and the ability to more easily replace
or
> >augment the presentation layer code.
> >
> >You did mention n-tier apps, and it's worth pointing out that in a
> >three-tier app, the things you generally think of as "business
> >rules" would
> >be implemented in the middle tier, between the presentation
> >layer code (CF,
> >in this case) and the database. However, to the extent that your
business
> >rules are data manipulation issues, you're better off putting them in
the
> >database tier of your two-tier application.
> >
> >> 2) What is more likely to need clustering - the Web/CF Server,
> >> or the SQL Server.
> >
> >The web servers are more likely to benefit from clustering, in
general.
> >
> >Dave Watts, CTO, Fig Leaf Software
> >http://www.figleaf.com/
> >voice: (202) 797-5496
> >fax: (202) 797-5444
> >
> >


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

RE: Exporting data to Excel spreadsheet

[Jared Clinton]

Mike,

I highly recommend cfx_ss http://www.sanders-indev.com/cfxssdoc.htm 

It is very fast although doesn't convert to excel format only csv.

Jared Clinton
NEC Australia



-Original Message-
From: Seamus Campbell [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 3 April 2002 5:39 PM
To: CF-Talk
Subject: Re: Exporting data to Excel spreadsheet


Try CF_Query2Excel tag - works very well

if you can't find it on Macromedia send me another email - I've got a copy 
here somewhere

Seamus


At 05:23 pm 3/04/02 , you wrote:
>At one of my clients, the content providers each look after an allocated
>part of the data used for displaying information on the web site. They
>want to be able to export their data to a spreadsheet so they can review
>it and update it off line.  These are not IT people but experts in their
>various consumer fields.  They want me to put a button in their admin
>areas for each category of comsumer data so it will export the data for
>them automatically.  I was going to do it this way and I wondered if there
>was a better way:
>
>
>(1)  Have a spreadsheet already attached to CF as a datasource.
>(2)  Use a CFQuery to delete all the records in that datasource.
>(3)  CFQUERY the SQL7 table the content provider wants to export
>(4)  loop through the query, inserting the data into the (now blank)
>spreadsheet.
>(5)  Use CFMail to email the spreadsheet to the user (getting their email
>address from their logon details).
>
>I seem to remember a function or a tag that output the results of a query
>into spreadsheet format but I can't find any reference to it any more.
>Can anyone enlighten me?
>
>
>Is this the easiest way?   Will CFMail be able to send the spread sheet or
>will I need to unlock it from the server first? in which case, how can i
>do that automatically?
>
>
>Cheers,
>Mike Kear
>AFP Webworks,
>Windsor, NSW, Australia
>
>

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

RE: Only permit execution from CF scheduler

[Jim Curran]

You can check that the cgi.REMOTE_ADDR is the IP of the computer the CF
scheduler is running on.

- j

-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 6:13 PM
To: CF-Talk
Subject: Only permit execution from CF scheduler


I'd like to only permit the running of a certain template through the CF
scheduler.  I know this is easily done by simply placing the source
directory outside of the web space, but for a couple of reasons this
particular template needs to be in a web-accessible directory.  I'm guessing
that there may be one or more CGI variable that would tell me if the
scheduler is executing the template.  Any ideas?

Jim


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

RE: Web based Chat

[Robert Bailey]

Check the allaire msg boards, I remember downloading a program such as
the old perl type chat that was written in CF and it was not encrypted
as well, so the easily modified for your needs. Hope this helps

Rob

-Original Message-
From: chris.alvarado [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 3:12 PM
To: CF-Talk
Subject: Web based Chat

A client wants some type of web-based chat integrated into their site.
It
would be nice if I could incorporate the Chat into the existing security
system.

Obviously any type of streaming chat would probably be Java-based but
that
is fine.

I remember "back in the day" I would use Peri-Chat, so something similar
would be nice.

Thanks for any recommendations.

-chris.alvarado
[application.developer]
4 Guys Interactive, Inc.


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

Re: How do you change this number 70.0500 to 70.05?

[one]

Just tried this code, but alas, no dice:(

Thanks for the suggestion tho.


- Original Message -
From: "VAN VLIET, SCOTT E (SBCSI)" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 2:07 PM
Subject: RE: How do you change this number 70.0500 to 70.05?


> SELECT ('$' + CONVERT(VARCHAR,DollarField)) As DollarField
> FROM TABLENAME
>
> (Where DollarField is the Column you are getting the dollar value from)
>
> The convert function trimmed off to only 2 decimals in the conversion.  I
> was starting to get all crazy with SUBSTING, but I think will work just
> fine. HTH!
>
> --
> Scott Van Vliet
> Senior Analyst
> SBC Services, Inc.
> ITO Enterprise Tools
> Office: 858.886.3878
> Pager: 858.536.0070
> Email: [EMAIL PROTECTED]
>
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 1:22 PM
> To: CF-Talk
> Subject: Re: How do you change this number 70.0500 to 70.05?
>
>
> Thanks for your help. Only thing is a list of about 1000 clients is merged
> into the Activ Mail tag, and so each record has to be formatted within the
> query itself because Active Mail only takes lists from the query, not from
> CFPARAM or CFSET. The emails go out only to clients who's accounts are
past
> due, but again the email tag uses variables only coming directly from
within
> a query. Also, the database is managed by another company and they may be
> averse to changing the field type to decimal with a scale of 2, although
I'm
> going to try that as the first option.
>
> Is there anyway to perhaps format fields with a function directly in the
> queries?
>
> Regards,
> Pardeep.
>
> - Original Message -
> From: "Christopher Olive" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, April 03, 2002 12:59 PM
> Subject: RE: How do you change this number 70.0500 to 70.05?
>
>
> > try making the field "decimal" with a scale of 2.
> >
> > christopher olive
> > cto, vp of web development, vp it security
> > atnet solutions, inc.
> > 410.931.4092
> > http://www.atnetsolutions.com
> >
> >
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, April 03, 2002 4:08 PM
> > To: CF-Talk
> > Subject: Re: How do you change this number 70.0500 to 70.05?
> >
> >
> > Anyone have any idea how to change a number thats being outputted from a
> > table as 70.0500 to 70.05 with only 2 decimal points.
> >
> > Is this doable thru a change in SQL 2000 or a change in the query
itself?
> >
> > I'm doing an email merge, and the tag used won't allow formatting of
> > anything within the body of the email, so the data has to be correctly
> > formatted before being inserted into the email. The above number is a
> dollar
> > amount owed by customers past due, so it need to be displayed in the
email
> > as $70.05 and right now shows as $70.0500
> >
> > Appreciate any insights. Thanks.
> >
> >
> >
>
> 
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: How do you send a ColdFusion variable to a Flash Movie?

[Jim Curran]

I like this way the best:


mymovie.swf?var1=value1&var2=value2

-Original Message-
From: Gary Groomer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 5:58 PM
To: CF-Talk
Subject: How do you send a ColdFusion variable to a Flash Movie?


I got roped into creating a small Flash movie for a client.  Creating the
Flash movie was simple, but I can't figure out how to send a ColdFusion
variable to the Flash movie.  It should be simple, but I can't seem to find
how to do it in the Flash documentation without saving the variable to a
file.  If I save it to a file, it works great.

Basically, ColdFusion will create a variable by querying a database and then
it will do some string manipulation.  This variable, intern, needs to be
passed directly on to a Flash movie.  If anyone can direct me in the right
direction, it would be greatly appreciated.

Gary Groomer


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

Only permit execution from CF scheduler

[Jim McAtee]

I'd like to only permit the running of a certain template through the CF
scheduler.  I know this is easily done by simply placing the source
directory outside of the web space, but for a couple of reasons this
particular template needs to be in a web-accessible directory.  I'm guessing
that there may be one or more CGI variable that would tell me if the
scheduler is executing the template.  Any ideas?

Jim

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

Re: How do you change this number 70.0500 to 70.05?

[one]

How do you round it off?



> Multiply the number b7 100, round it off, and then divide by 100.
>
> Benjamin S. Rogers
> http://www.c4.net/
> v.508.240.0051
> f.508.240.0057
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 4:22 PM
> To: CF-Talk
> Subject: Re: How do you change this number 70.0500 to 70.05?
>
>
> Thanks for your help. Only thing is a list of about 1000 clients is
> merged into the Activ Mail tag, and so each record has to be formatted
> within the query itself because Active Mail only takes lists from the
> query, not from CFPARAM or CFSET. The emails go out only to clients
> who's accounts are past due, but again the email tag uses variables only
> coming directly from within a query. Also, the database is managed by
> another company and they may be averse to changing the field type to
> decimal with a scale of 2, although I'm going to try that as the first
> option.
>
> Is there anyway to perhaps format fields with a function directly in the
> queries?
>
> Regards,
> Pardeep.
>
> - Original Message -
> From: "Christopher Olive" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, April 03, 2002 12:59 PM
> Subject: RE: How do you change this number 70.0500 to 70.05?
>
>
> > try making the field "decimal" with a scale of 2.
> >
> > christopher olive
> > cto, vp of web development, vp it security
> > atnet solutions, inc.
> > 410.931.4092
> > http://www.atnetsolutions.com
> >
> >
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, April 03, 2002 4:08 PM
> > To: CF-Talk
> > Subject: Re: How do you change this number 70.0500 to 70.05?
> >
> >
> > Anyone have any idea how to change a number thats being outputted from
>
> > a table as 70.0500 to 70.05 with only 2 decimal points.
> >
> > Is this doable thru a change in SQL 2000 or a change in the query
> > itself?
> >
> > I'm doing an email merge, and the tag used won't allow formatting of
> > anything within the body of the email, so the data has to be correctly
>
> > formatted before being inserted into the email. The above number is a
> dollar
> > amount owed by customers past due, so it need to be displayed in the
> > email as $70.05 and right now shows as $70.0500
> >
> > Appreciate any insights. Thanks.
> >
> >
> >
>
> 
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Web based Chat

[chris.alvarado]

A client wants some type of web-based chat integrated into their site. It
would be nice if I could incorporate the Chat into the existing security
system.

Obviously any type of streaming chat would probably be Java-based but that
is fine.

I remember "back in the day" I would use Peri-Chat, so something similar
would be nice.

Thanks for any recommendations.

-chris.alvarado
[application.developer]
4 Guys Interactive, Inc.

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

RE: How do you send a ColdFusion variable to a Flash Movie?

[Neil Clark - =TMM=]

Use URL, loadVariables or loadVar depending on your Flash version.

N

There are loads of docs on the MM site to :

http://www.macromedia.com/desdev



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

OT: Multiple hotmail messages bounce

[Don Vawter]

I send out about 700 email messages a day to people who have signed up to
receive a daily cryptogram. If I send them all at once nearly all of the
message to hotmail accounts
bounce. If I space them throughout the day they get delivered. Apparently
hotmail interprets multiple
emails in a short period of time as spam and rejects them.

Does anyone have a solution for this? I have tried using a different return
email address on each message but that makes no difference. I have
communicated the problem to Hotmail's customer service but that is worse
than talking to a wall.

TIA


°¿°
 ~
Don Vawter
www.vawter.com
www.dailycryptogram.com
www.cyberroomies.com


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

Re: Using Structures with Arrays, Please Help

[Robert Gatton]

in your  over the q_act_detail query,
instead of
--













..other struct fields...

-
try this...
-







..other struct fields...



--
hth.


- Original Message -
From: "Burcham, Steve" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 5:25 PM
Subject: Using Structures with Arrays, Please Help


> Can anyone see anything wrong with this code? I am trying to loop through
> data to find the Sales Persons login id and for each sales person return
the
> activities, dates, contacts, etc. for them to see. The error is listed
> below.
>
> There are two pages to this.
>
> The first page goes out and retrieves the all login ids and then sends
that
> info to the second page as an attribute.
>
> Here is the code on the first page:
> --
--
> -
> 
>
> SELECT  email_, logname, sls_psn_code
> FROM dbo.gmslspsn
> WHERE   job_code = 'SALES'
>
> 
>
>   sls_psn_code='#q_email.sls_psn_code#'>
> --
--
> ---
> Here is the code for the second page:
>
> 
>
> SELECT act_key, CONVERT(char(10), date_, 101) AS ACT_DATE,
> time_,
> act_code,
> result_code,
> act_txt,
> duration_,
> result_code,
> gmin_mngr.recordid,
> contact_fname,
> contact_lname,
> company_name_1,
> comp_phone,
> gmopph.description,
> address1,
> city,
> state,
> zip
> FROM gmin_mngr LEFT JOIN gminfo ON gmin_mngr.recordid = gminfo.recordid
LEFT
> JOIN gmcmpany ON gmin_mngr.comp_code=gmcmpany.comp_code LEFT JOIN gmopph
ON
> gmin_mngr.opp_code = gmopph.opp_code
> LEFT JOIN gmcm_addr ON gmcmpany.comp_code = gmcm_addr.comp_code
> WHERE sls_psn_code = '#attributes.sls_psn_code#'
> AND date_ BETWEEN '#DateFormat(Now(), "MM/DD/")#' AND
> '#DateFormat(DateAdd("d",7,Now()), "MM/DD/")#' AND result_code = ''
> ORDER BY date_, time_
>
> 
>
>
>
>
> 
>
> 
>
> 
>
> 
>
> 
>
>
>
> 
>
> 
>  "#attributes.sls_psn_code#">
> 
> 
> 
> 
> 
> 
> 
> 
> 
>
> 
> 
> 
>
> 
>
> #aSales[i].Sales_Psn#
> #aSales[i].Date#
> #aSales[i].Act_Code# #aSales[i].Contact_Name#
> #aSales[i].Comp_Name#
> 
7>#LEFT(TRIM(aSales[i].comp_phone),3)#–#RIGHT(aSales[i].comp_phone,4)#
>
(#LEFT(TRIM(aSales[i].comp_phone),3)#)#LEFT(RIGHT(TRIM(aSales[i].com
> p_phone),7),3)#-#RIGHT(TRIM(aSales[i].comp_phone),4)#
> #Trim(aSales[i].address1)# #Trim(aSales[i].city)#,
> #Trim(aSales[i].state)# #Trim(aSales[i].zip)#
>
> 
>
> 
>
> 
> --
--
> ---
> This is the error I get:
>
>
> Error Diagnostic Information
>
>
>
> An error occurred while evaluating the expression:
>
>
>
> #aSales[i].Sales_Psn#
>
>
>
> Error near line 75, column 19.
>   _
>
>
> The member "SALES_PSN" in dimension 1 of object "aSales" cannot be found.
> That struct object is empty.
>
>
>
> The error occurred while processing an element with a general identifier
of
> (#aSales[i].Sales_Psn#), occupying document position (75:9) to (75:29) in
> the template file E:\INETPUB\EIC\MAINTENANCE\ACT_SCHEDULE.cfm.
>
>
> Date/Time: 04/03/02 16:24:14
> Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)
> Remote Address: 10.16.128.83
>
>
> 
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

How do you send a ColdFusion variable to a Flash Movie?

[Gary Groomer]

I got roped into creating a small Flash movie for a client.  Creating the
Flash movie was simple, but I can't figure out how to send a ColdFusion
variable to the Flash movie.  It should be simple, but I can't seem to find
how to do it in the Flash documentation without saving the variable to a
file.  If I save it to a file, it works great.

Basically, ColdFusion will create a variable by querying a database and then
it will do some string manipulation.  This variable, intern, needs to be
passed directly on to a Flash movie.  If anyone can direct me in the right
direction, it would be greatly appreciated.

Gary Groomer

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

RE: Using Structures with Arrays, Please Help

[Cantrell, Adam]

Download the custom tag cf_dump from devex.macromedia.com. Right before your
cfmail tag, do:




It will tell you exactly what's in your structure.

Adam.


> -Original Message-
> From: Burcham, Steve [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 4:26 PM
> To: CF-Talk
> Subject: Using Structures with Arrays, Please Help
> 
> 
> Can anyone see anything wrong with this code? I am trying to 
> loop through
> data to find the Sales Persons login id and for each sales 
> person return the
> activities, dates, contacts, etc. for them to see. The error is listed
> below.
>  
> There are two pages to this.
>  
> The first page goes out and retrieves the all login ids and 
> then sends that
> info to the second page as an attribute. 
>  
> Here is the code on the first page:
> --
> --
> -
> 
>  
> SELECT  email_, logname, sls_psn_code
> FROM dbo.gmslspsn 
> WHERE   job_code = 'SALES'
>  
> 
>  
>   sls_psn_code='#q_email.sls_psn_code#'>
> --
> --
> ---
> Here is the code for the second page:
>  
> 
>  
> SELECT act_key, CONVERT(char(10), date_, 101) AS ACT_DATE, 
> time_, 
> act_code, 
> result_code, 
> act_txt, 
> duration_, 
> result_code, 
> gmin_mngr.recordid, 
> contact_fname, 
> contact_lname, 
> company_name_1,
> comp_phone, 
> gmopph.description,
> address1,
> city,
> state,
> zip 
> FROM gmin_mngr LEFT JOIN gminfo ON gmin_mngr.recordid = 
> gminfo.recordid LEFT
> JOIN gmcmpany ON gmin_mngr.comp_code=gmcmpany.comp_code LEFT 
> JOIN gmopph ON
> gmin_mngr.opp_code = gmopph.opp_code 
> LEFT JOIN gmcm_addr ON gmcmpany.comp_code = gmcm_addr.comp_code
> WHERE sls_psn_code = '#attributes.sls_psn_code#' 
> AND date_ BETWEEN '#DateFormat(Now(), "MM/DD/")#' AND
> '#DateFormat(DateAdd("d",7,Now()), "MM/DD/")#' AND 
> result_code = '' 
> ORDER BY date_, time_
>  
> 
>  
>  
>  
> 
> 
>  
> 
>  
> 
>  
> 
>  
>  StructNew())>
>  
>  
>  
> 
>  
> 
>  "#attributes.sls_psn_code#">
> 
> 
> 
>  "#company_name_1#">
> 
> 
> 
> 
> 
>  
> 
> 
> 
>  
> 
>  
> #aSales[i].Sales_Psn#
> #aSales[i].Date#
> #aSales[i].Act_Code# #aSales[i].Contact_Name#
> #aSales[i].Comp_Name#
>  7>#LEFT(TRIM(aSales[i].comp_phone),3)#–#RIGHT(aSales[i].
> comp_phone,4)#
> (#LEFT(TRIM(aSales[i].comp_phone),3)#)#LEFT(RIGHT(TRIM
> (aSales[i].com
> p_phone),7),3)#-#RIGHT(TRIM(aSales[i].comp_phone),4)#
> #Trim(aSales[i].address1)# #Trim(aSales[i].city)#,
> #Trim(aSales[i].state)# #Trim(aSales[i].zip)#
>  
> 
>  
> 
>  
> 
> --
> --
> ---
> This is the error I get:
>  
> 
> Error Diagnostic Information
> 
> 
> 
> An error occurred while evaluating the expression: 
> 
> 
> 
> #aSales[i].Sales_Psn#
> 
> 
> 
> Error near line 75, column 19. 
>   _  
> 
> 
> The member "SALES_PSN" in dimension 1 of object "aSales" 
> cannot be found.
> That struct object is empty. 
> 
> 
> 
> The error occurred while processing an element with a general 
> identifier of
> (#aSales[i].Sales_Psn#), occupying document position (75:9) 
> to (75:29) in
> the template file E:\INETPUB\EIC\MAINTENANCE\ACT_SCHEDULE.cfm.
> 
> 
> Date/Time: 04/03/02 16:24:14
> Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)
> Remote Address: 10.16.128.83
> 
> 
> 
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Fw: Problem with EMBED and OBJECT tags.

[Cfapple]

Try putting the  directly around the #url.mov#.

Eg. #url.mov#

-Hugh

 
  I'm having trouble getting a EMBED/OBJECT tag to recognize a varible as a
  filename.
 
  Original code:
 
http://www.apple.com/qtactivex/qtplugin.cab";>
http:[EMAIL PROTECTED]";>



http:[EMAIL PROTECTED]";
  WIDTH=240 HEIGHT=196 AUTOPLAY=true CONTROLLER=true LOOP=false
  PLUGINSPAGE="http://www.apple.com/quicktime/";>


 
  works like a champ
 
  
http://www.apple.com/qtactivex/qtplugin.cab";>
http://intranet.esca.com/documents/mpeg/brownbag/#url.mov#.mov";>



http://intranet.esca.com/documents/mpeg/brownbag/#url.mov#.mov";
  WIDTH=240 HEIGHT=196 AUTOPLAY=true CONTROLLER=true LOOP=false
  PLUGINSPAGE="http://www.apple.com/quicktime/";>


 
 
  the variable is passed as follows:
 
 
 index.cfm?action=qt&gc_ID=8B9D5438-1C10-11D6-94DB0002A50741F5&mov=esca_@stak
 e_1
 
 (the spaces at the end of the string are Underscores...)
 
  Fails with the following message:
 
  Plugin Error
 The data that the plugin requested, did not download successfully
 
  Anyone with thoughts?
 
 CF Server 5
 WinNT 4sp6a
 
  viewed on
 WinNT Workstation 4sp6a
 IE6 and QT
 
  Thanks all :o)
 
  will
 
 
 William H. Bowen
 Webmaster
 ALSTOM's Energy Management and Markets Business
 
  [EMAIL PROTECTED]
 http://www.esca.com/
 
 
 
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Using Structures with Arrays, Please Help

[Burcham, Steve]

Can anyone see anything wrong with this code? I am trying to loop through
data to find the Sales Persons login id and for each sales person return the
activities, dates, contacts, etc. for them to see. The error is listed
below.
 
There are two pages to this.
 
The first page goes out and retrieves the all login ids and then sends that
info to the second page as an attribute. 
 
Here is the code on the first page:

-

 
SELECT  email_, logname, sls_psn_code
FROM dbo.gmslspsn 
WHERE   job_code = 'SALES'
 

 


---
Here is the code for the second page:
 

 
SELECT act_key, CONVERT(char(10), date_, 101) AS ACT_DATE, 
time_, 
act_code, 
result_code, 
act_txt, 
duration_, 
result_code, 
gmin_mngr.recordid, 
contact_fname, 
contact_lname, 
company_name_1,
comp_phone, 
gmopph.description,
address1,
city,
state,
zip 
FROM gmin_mngr LEFT JOIN gminfo ON gmin_mngr.recordid = gminfo.recordid LEFT
JOIN gmcmpany ON gmin_mngr.comp_code=gmcmpany.comp_code LEFT JOIN gmopph ON
gmin_mngr.opp_code = gmopph.opp_code 
LEFT JOIN gmcm_addr ON gmcmpany.comp_code = gmcm_addr.comp_code
WHERE sls_psn_code = '#attributes.sls_psn_code#' 
AND date_ BETWEEN '#DateFormat(Now(), "MM/DD/")#' AND
'#DateFormat(DateAdd("d",7,Now()), "MM/DD/")#' AND result_code = '' 
ORDER BY date_, time_
 

 
 
 


 

 

 

 

 
 
 

 











 



 

 
#aSales[i].Sales_Psn#
#aSales[i].Date#
#aSales[i].Act_Code# #aSales[i].Contact_Name#
#aSales[i].Comp_Name#
#LEFT(TRIM(aSales[i].comp_phone),3)#–#RIGHT(aSales[i].comp_phone,4)#
(#LEFT(TRIM(aSales[i].comp_phone),3)#)#LEFT(RIGHT(TRIM(aSales[i].com
p_phone),7),3)#-#RIGHT(TRIM(aSales[i].comp_phone),4)#
#Trim(aSales[i].address1)# #Trim(aSales[i].city)#,
#Trim(aSales[i].state)# #Trim(aSales[i].zip)#
 

 

 


---
This is the error I get:
 

Error Diagnostic Information



An error occurred while evaluating the expression: 



#aSales[i].Sales_Psn#



Error near line 75, column 19. 
  _  


The member "SALES_PSN" in dimension 1 of object "aSales" cannot be found.
That struct object is empty. 



The error occurred while processing an element with a general identifier of
(#aSales[i].Sales_Psn#), occupying document position (75:9) to (75:29) in
the template file E:\INETPUB\EIC\MAINTENANCE\ACT_SCHEDULE.cfm.


Date/Time: 04/03/02 16:24:14
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)
Remote Address: 10.16.128.83


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

DSNless query

[Bruce, Rodney (SIGNAL)]

Hello all

Hoping someone can tell me what I am missing here.
We are running:  CF5 NT  ACCESS2K




SELECT DrawingDetails.*
FROM DrawingDetails
WHERE DrawingDetails.ESID=5;




I get the error:
Error Diagnostic Information
ODBC Error Code = IM002 (Data source not found and no default driver
specified)


[Microsoft][ODBC Driver Manager] Data source '' not found and no default
driver specified

Hint: In order to use ODBC data sources with Cold Fusion you must create the
data source using the Data Sources page of the Cold Fusion Administrator. In
addition, if you are running under Windows NT you must make sure that the
Data Source is created as a System DSN in order for it to be available to
ColdFusion.



The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (4:1) to (4:68).


Date/Time: 04/03/02 15:31:44
Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
Remote Address: 137.80.60.254


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

Fw: Problem with EMBED and OBJECT tags.

[William H. Bowen]

Sorry for the cross post, need an answer quickly please:

 I'm having trouble getting a EMBED/OBJECT tag to recognize a varible as a
 filename.

 Original code:

   http://www.apple.com/qtactivex/qtplugin.cab";>
   http:[EMAIL PROTECTED]";>
   
   
   
   http:[EMAIL PROTECTED]";
 WIDTH=240 HEIGHT=196 AUTOPLAY=true CONTROLLER=true LOOP=false
 PLUGINSPAGE="http://www.apple.com/quicktime/";>
   
   

 works like a champ

 
   http://www.apple.com/qtactivex/qtplugin.cab";>
   http://intranet.esca.com/documents/mpeg/brownbag/#url.mov#.mov";>
   
   
   
   http://intranet.esca.com/documents/mpeg/brownbag/#url.mov#.mov";
 WIDTH=240 HEIGHT=196 AUTOPLAY=true CONTROLLER=true LOOP=false
 PLUGINSPAGE="http://www.apple.com/quicktime/";>
   
   


 the variable is passed as follows:


index.cfm?action=qt&gc_ID=8B9D5438-1C10-11D6-94DB0002A50741F5&mov=esca_@stak
e_1

(the spaces at the end of the string are Underscores...)

 Fails with the following message:

 Plugin Error
The data that the plugin requested, did not download successfully

 Anyone with thoughts?

CF Server 5
WinNT 4sp6a

 viewed on
WinNT Workstation 4sp6a
IE6 and QT

 Thanks all :o)

 will


William H. Bowen
Webmaster
ALSTOM's Energy Management and Markets Business

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


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

RE: How do you change this number 70.0500 to 70.05?

[VAN VLIET, SCOTT E (SBCSI)]

SELECT ('$' + CONVERT(VARCHAR,DollarField)) As DollarField
FROM TABLENAME

(Where DollarField is the Column you are getting the dollar value from)

The convert function trimmed off to only 2 decimals in the conversion.  I
was starting to get all crazy with SUBSTING, but I think will work just
fine. HTH!

--
Scott Van Vliet
Senior Analyst
SBC Services, Inc.
ITO Enterprise Tools
Office: 858.886.3878
Pager: 858.536.0070
Email: [EMAIL PROTECTED]
 


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 1:22 PM
To: CF-Talk
Subject: Re: How do you change this number 70.0500 to 70.05?


Thanks for your help. Only thing is a list of about 1000 clients is merged
into the Activ Mail tag, and so each record has to be formatted within the
query itself because Active Mail only takes lists from the query, not from
CFPARAM or CFSET. The emails go out only to clients who's accounts are past
due, but again the email tag uses variables only coming directly from within
a query. Also, the database is managed by another company and they may be
averse to changing the field type to decimal with a scale of 2, although I'm
going to try that as the first option.

Is there anyway to perhaps format fields with a function directly in the
queries?

Regards,
Pardeep.

- Original Message -
From: "Christopher Olive" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 12:59 PM
Subject: RE: How do you change this number 70.0500 to 70.05?


> try making the field "decimal" with a scale of 2.
>
> christopher olive
> cto, vp of web development, vp it security
> atnet solutions, inc.
> 410.931.4092
> http://www.atnetsolutions.com
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 4:08 PM
> To: CF-Talk
> Subject: Re: How do you change this number 70.0500 to 70.05?
>
>
> Anyone have any idea how to change a number thats being outputted from a
> table as 70.0500 to 70.05 with only 2 decimal points.
>
> Is this doable thru a change in SQL 2000 or a change in the query itself?
>
> I'm doing an email merge, and the tag used won't allow formatting of
> anything within the body of the email, so the data has to be correctly
> formatted before being inserted into the email. The above number is a
dollar
> amount owed by customers past due, so it need to be displayed in the email
> as $70.05 and right now shows as $70.0500
>
> Appreciate any insights. Thanks.
>
>
> 

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

RE: How do you change this number 70.0500 to 70.05?

[Benjamin S. Rogers]

Multiply the number b7 100, round it off, and then divide by 100.

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

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 4:22 PM
To: CF-Talk
Subject: Re: How do you change this number 70.0500 to 70.05?


Thanks for your help. Only thing is a list of about 1000 clients is
merged into the Activ Mail tag, and so each record has to be formatted
within the query itself because Active Mail only takes lists from the
query, not from CFPARAM or CFSET. The emails go out only to clients
who's accounts are past due, but again the email tag uses variables only
coming directly from within a query. Also, the database is managed by
another company and they may be averse to changing the field type to
decimal with a scale of 2, although I'm going to try that as the first
option.

Is there anyway to perhaps format fields with a function directly in the
queries?

Regards,
Pardeep.

- Original Message -
From: "Christopher Olive" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 12:59 PM
Subject: RE: How do you change this number 70.0500 to 70.05?


> try making the field "decimal" with a scale of 2.
>
> christopher olive
> cto, vp of web development, vp it security
> atnet solutions, inc.
> 410.931.4092
> http://www.atnetsolutions.com
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 4:08 PM
> To: CF-Talk
> Subject: Re: How do you change this number 70.0500 to 70.05?
>
>
> Anyone have any idea how to change a number thats being outputted from

> a table as 70.0500 to 70.05 with only 2 decimal points.
>
> Is this doable thru a change in SQL 2000 or a change in the query 
> itself?
>
> I'm doing an email merge, and the tag used won't allow formatting of 
> anything within the body of the email, so the data has to be correctly

> formatted before being inserted into the email. The above number is a
dollar
> amount owed by customers past due, so it need to be displayed in the 
> email as $70.05 and right now shows as $70.0500
>
> Appreciate any insights. Thanks.
>
>
> 

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

Re: OT: SQL ?

[Jochem van Dieten]

Douglas Brown wrote:
> I was wondering if this is true or not, can someone answer this? Say I have a
> table with 60,000 records in it, and I have a query where I want the data with
> an ID of 4000. I heard sql searches like so
> 
> 1 - 6
> 2 - 5
> 3 - 59998
> 
> but if you have an index, it does it like
> 1
> 2
> 3
> 4
> until it gets to the correct ID

With no index you are probably a bit right. It will do a full tablescan, 
but it will read them in the order they are on the disk (which might be 
completely random).

If there is an index, the database will probably use the index to 
determine the right record.  After the index has hit the database will 
know the location of the actual record on the disk and read just that 
record from the disk.

All of this is quite database dependent, so you should check your 
database docs for more details.

Jochem

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

RE: Where is the best place to put business rules?

[Tony_Petruzzi]

in the great words of Adam Churvis.

What would happen if someone decided to update your database using Excel
ODBC connection? The stored procedure wouldn't run. But if you had your
business logic in the trigger, it would fired upon an insert, update, or
delete.


That man knows best. Since then I put all my business logic inside of
triggers.


Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org


-Original Message-
From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 4:17 PM
To: CF-Talk
Subject: RE: Where is the best place to put business rules?


I've often wondered about this is there really a need for a third tier, what
would you put in the third tier that you *couldn't* put in a stored proc
apart from file operations?

Thanks

Kola

> >-Original Message-
> >From: Dave Watts [mailto:[EMAIL PROTECTED]]
> >Sent: 03 April 2002 15:02
> >To: CF-Talk
> >Subject: RE: Where is the best place to put business rules?
> >
> >
> >> 1) Where is the best place to put the business rules? CF
> >> Templates (using CFTransaction), or Stored Procedures (using
> >> SQL Transactions). We realize that some business rules need
> >> to reside on the templates, such as client side data validation.
> >> But processing pages are a different story.
> >
> >In general, I think that stored procedures are better for any
> >generic data
> >manipulation tasks. Using stored procedures provides many
> >advantages, such
> >as more efficient processing and the ability to more easily replace or
> >augment the presentation layer code.
> >
> >You did mention n-tier apps, and it's worth pointing out that in a
> >three-tier app, the things you generally think of as "business
> >rules" would
> >be implemented in the middle tier, between the presentation
> >layer code (CF,
> >in this case) and the database. However, to the extent that your business
> >rules are data manipulation issues, you're better off putting them in the
> >database tier of your two-tier application.
> >
> >> 2) What is more likely to need clustering - the Web/CF Server,
> >> or the SQL Server.
> >
> >The web servers are more likely to benefit from clustering, in general.
> >
> >Dave Watts, CTO, Fig Leaf Software
> >http://www.figleaf.com/
> >voice: (202) 797-5496
> >fax: (202) 797-5444
> >
> >

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

RE: How do you change this number 70.0500 to 70.05?

[Tony_Petruzzi]

works in SQL Server

declare @num float
set @num = 4.8672
print @num   -- 4.8672
set @num = round(@num, 2)
print @num   -- 4.87

Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 4:22 PM
To: CF-Talk
Subject: Re: How do you change this number 70.0500 to 70.05?


Thanks for your help. Only thing is a list of about 1000 clients is merged
into the Activ Mail tag, and so each record has to be formatted within the
query itself because Active Mail only takes lists from the query, not from
CFPARAM or CFSET. The emails go out only to clients who's accounts are past
due, but again the email tag uses variables only coming directly from within
a query. Also, the database is managed by another company and they may be
averse to changing the field type to decimal with a scale of 2, although I'm
going to try that as the first option.

Is there anyway to perhaps format fields with a function directly in the
queries?

Regards,
Pardeep.

- Original Message -
From: "Christopher Olive" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 12:59 PM
Subject: RE: How do you change this number 70.0500 to 70.05?


> try making the field "decimal" with a scale of 2.
>
> christopher olive
> cto, vp of web development, vp it security
> atnet solutions, inc.
> 410.931.4092
> http://www.atnetsolutions.com
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 4:08 PM
> To: CF-Talk
> Subject: Re: How do you change this number 70.0500 to 70.05?
>
>
> Anyone have any idea how to change a number thats being outputted from a
> table as 70.0500 to 70.05 with only 2 decimal points.
>
> Is this doable thru a change in SQL 2000 or a change in the query itself?
>
> I'm doing an email merge, and the tag used won't allow formatting of
> anything within the body of the email, so the data has to be correctly
> formatted before being inserted into the email. The above number is a
dollar
> amount owed by customers past due, so it need to be displayed in the email
> as $70.05 and right now shows as $70.0500
>
> Appreciate any insights. Thanks.
>
>
> 

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

RE: Where is the best place to put business rules?

[Kola Oyedeji]

I've often wondered about this is there really a need for a third tier, what
would you put in the third tier that you *couldn't* put in a stored proc
apart from file operations?

Thanks

Kola

> >-Original Message-
> >From: Dave Watts [mailto:[EMAIL PROTECTED]]
> >Sent: 03 April 2002 15:02
> >To: CF-Talk
> >Subject: RE: Where is the best place to put business rules?
> >
> >
> >> 1) Where is the best place to put the business rules? CF
> >> Templates (using CFTransaction), or Stored Procedures (using
> >> SQL Transactions). We realize that some business rules need
> >> to reside on the templates, such as client side data validation.
> >> But processing pages are a different story.
> >
> >In general, I think that stored procedures are better for any
> >generic data
> >manipulation tasks. Using stored procedures provides many
> >advantages, such
> >as more efficient processing and the ability to more easily replace or
> >augment the presentation layer code.
> >
> >You did mention n-tier apps, and it's worth pointing out that in a
> >three-tier app, the things you generally think of as "business
> >rules" would
> >be implemented in the middle tier, between the presentation
> >layer code (CF,
> >in this case) and the database. However, to the extent that your business
> >rules are data manipulation issues, you're better off putting them in the
> >database tier of your two-tier application.
> >
> >> 2) What is more likely to need clustering - the Web/CF Server,
> >> or the SQL Server.
> >
> >The web servers are more likely to benefit from clustering, in general.
> >
> >Dave Watts, CTO, Fig Leaf Software
> >http://www.figleaf.com/
> >voice: (202) 797-5496
> >fax: (202) 797-5444
> >
> >
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: How do you change this number 70.0500 to 70.05?

[one]

I forgot to mention, the Activ Mail tag won't take regular Cold Fusion
variables with the # signs, it works with only what they refer to as Tokens,
and the Tokens which are really data from a query can't be formatted with
regular Cold Fusion functions such as dollarformat, etc.

Hence the need to somehow format within a query or revert to changing the
database field type structure.

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

RE: OT: SQL Server Connection

[Thanh Nguyen]

Nope, don't have public IP.


-Original Message-
From: Christopher Olive [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 12:15 PM
To: CF-Talk
Subject: RE: OT: SQL Server Connection


does the database server have a publicly acessible IP address?  if so, just
crate the ODBC source on the ISP for the site, and point it to that IP.

christopher olive
cto, vp of web development, vp it security
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com


-Original Message-
From: Thanh Nguyen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 3:11 PM
To: CF-Talk
Subject: FW: OT: SQL Server Connection


 
Hi all,
 
I have a website that's accessing a sql database on the same network.
Starting next week, I'd have to move my website to an ISP. 
My Question is how should I set up the connection to my SQL server database
which will stay in-house?  I can't'move the database because we also have
other in-house applications connecting to the same database. 
 
What's the best way to do this?
Should I create a duplicate database on the ISP server just for the website.
and sync it with our main database here? any potential problems with doing
this?
 
Any advice would be appreciated.
 
Thanks.



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

RE: mystery page named FFFFFF

[Tony_Petruzzi]

what you could try to do is find out what the referer page is from the log
files. that is most likely the culprit.

Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org


-Original Message-
From: Chris Norloff [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 4:09 PM
To: CF-Talk
Subject: mystery page named FF


This might or might not be a CF problem: we routinely get 404 errors when
the application looks for a page named "FF". Somehow a link is getting
corrupted and we've been unable to track it down.

It happens all over our application, with no real pattern.  It appears more
often after calling a style sheet, but it appears even when we're not
calling the style sheet.

Anybody seen anything like this?

thanks,
Chris Norloff



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

Re: How do you change this number 70.0500 to 70.05?

[one]

Thanks for your help. Only thing is a list of about 1000 clients is merged
into the Activ Mail tag, and so each record has to be formatted within the
query itself because Active Mail only takes lists from the query, not from
CFPARAM or CFSET. The emails go out only to clients who's accounts are past
due, but again the email tag uses variables only coming directly from within
a query. Also, the database is managed by another company and they may be
averse to changing the field type to decimal with a scale of 2, although I'm
going to try that as the first option.

Is there anyway to perhaps format fields with a function directly in the
queries?

Regards,
Pardeep.

- Original Message -
From: "Christopher Olive" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 12:59 PM
Subject: RE: How do you change this number 70.0500 to 70.05?


> try making the field "decimal" with a scale of 2.
>
> christopher olive
> cto, vp of web development, vp it security
> atnet solutions, inc.
> 410.931.4092
> http://www.atnetsolutions.com
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 4:08 PM
> To: CF-Talk
> Subject: Re: How do you change this number 70.0500 to 70.05?
>
>
> Anyone have any idea how to change a number thats being outputted from a
> table as 70.0500 to 70.05 with only 2 decimal points.
>
> Is this doable thru a change in SQL 2000 or a change in the query itself?
>
> I'm doing an email merge, and the tag used won't allow formatting of
> anything within the body of the email, so the data has to be correctly
> formatted before being inserted into the email. The above number is a
dollar
> amount owed by customers past due, so it need to be displayed in the email
> as $70.05 and right now shows as $70.0500
>
> Appreciate any insights. Thanks.
>
>
> 
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Auto logout when leaving the application

[John Quarto-vonTivadar]

CC,

you could have your client (and cookie) vars act like session variables and
also "die" when the browser is closed and then put the variable you use to
define if the person is logged in (or 'is initialized' or whatever you like
to call it) in that scope:  check out this snippet and you'll see it does
what you want: (I happen to use client vars all the time now since the
snippet below allows them to act a lot more like session vars)




 
 
 
 



- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 11:41 AM
Subject: Re: Auto logout when leaving the application


> Good question.  I am also interested in this response, but with an added
> element.  What if a user closes the browser, how do you kill
client/session
> variables, presumably someone could close the browser thinking they are
> "logged out", the next person wanders up and sees the first persons
> information.
>
> CC
>
>
>
> Brian Fox
> 
> @sdccd.cc.ca.cc:
> us>  Subject: Auto logout when
leaving the application
>
> 04/03/02
> 10:30 AM
> Please
> respond to
> cf-talk
>
>
>
>
>
>
> What's the best way of handling security for a website that may be used in
> a
> kiosk mode?  I'm working on a student grade system that does a one time
> validation and sets a session variable.  Timeout is 15 minutes.
>
> John may log into the system using a lab computer to retrieve his student
> grades, become confused, wander to yahoo, read his mail, then leave the
> computer as is.  Sue may come in to use the same machine, go to the grade
> application to get her grades, and still be logged in as John.  Is there a
> good way to avoid this?
>
> I'm thinking about mangling the referer variable and zapping the session
> variables if the referer is not from the application.
>
>  i.e. http://www.gradesrus.com/";
..
> session.auth=0>
>
> That would solve the 'lost' client wandering out of the site.  Leaving the
> site is equivalent to logging out then (more or less).
>
> What about a javascript warning when a person is going to leave the
> application?  I'm not a javascript guru, but it seems like an onunload in
> the body should be able to give a popup alert and hopefully the ability to
> cancel the outside navigation.  Anyone ever try it?
>
> Is there a better approach to this?
>
> Thanks!
> Brian
>
>
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

mystery page named FFFFFF

[Chris Norloff]

This might or might not be a CF problem: we routinely get 404 errors when the 
application looks for a page named "FF". Somehow a link is getting corrupted and 
we've been unable to track it down.

It happens all over our application, with no real pattern.  It appears more often 
after calling a style sheet, but it appears even when we're not calling the style 
sheet.

Anybody seen anything like this?

thanks,
Chris Norloff


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

Re: How do you change this number 70.0500 to 70.05?

[Michael Corrigan]

DollarFormat(number)

Michael Corrigan
Programmer
Endora Digital Solutions
1900 Highland Avenue, Suite 200
Lombard, IL 60148
630-627-5055 ext.-136
630/627-5255 Fax
  - Original Message - 
  From: [EMAIL PROTECTED] 
  To: CF-Talk 
  Sent: Wednesday, April 03, 2002 3:07 PM
  Subject: Re: How do you change this number 70.0500 to 70.05?


  Anyone have any idea how to change a number thats being outputted from a
  table as 70.0500 to 70.05 with only 2 decimal points.

  Is this doable thru a change in SQL 2000 or a change in the query itself?

  I'm doing an email merge, and the tag used won't allow formatting of
  anything within the body of the email, so the data has to be correctly
  formatted before being inserted into the email. The above number is a dollar
  amount owed by customers past due, so it need to be displayed in the email
  as $70.05 and right now shows as $70.0500

  Appreciate any insights. Thanks.

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

RE: How do you change this number 70.0500 to 70.05?

[VAN VLIET, SCOTT E (SBCSI)]

#DecimalFormat(num)#

--
Scott Van Vliet
Senior Analyst
SBC Services, Inc.
ITO Enterprise Tools
Office: 858.886.3878
Pager: 858.536.0070
Email: [EMAIL PROTECTED]  
 


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 1:08 PM
To: CF-Talk
Subject: Re: How do you change this number 70.0500 to 70.05?


Anyone have any idea how to change a number thats being outputted from a
table as 70.0500 to 70.05 with only 2 decimal points.

Is this doable thru a change in SQL 2000 or a change in the query itself?

I'm doing an email merge, and the tag used won't allow formatting of
anything within the body of the email, so the data has to be correctly
formatted before being inserted into the email. The above number is a dollar
amount owed by customers past due, so it need to be displayed in the email
as $70.05 and right now shows as $70.0500

Appreciate any insights. Thanks.


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

RE: How do you change this number 70.0500 to 70.05?

[Christopher Olive]

try making the field "decimal" with a scale of 2.

christopher olive
cto, vp of web development, vp it security
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 4:08 PM
To: CF-Talk
Subject: Re: How do you change this number 70.0500 to 70.05?


Anyone have any idea how to change a number thats being outputted from a
table as 70.0500 to 70.05 with only 2 decimal points.

Is this doable thru a change in SQL 2000 or a change in the query itself?

I'm doing an email merge, and the tag used won't allow formatting of
anything within the body of the email, so the data has to be correctly
formatted before being inserted into the email. The above number is a dollar
amount owed by customers past due, so it need to be displayed in the email
as $70.05 and right now shows as $70.0500

Appreciate any insights. Thanks.


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

Re: How do you change this number 70.0500 to 70.05?

[one]

Anyone have any idea how to change a number thats being outputted from a
table as 70.0500 to 70.05 with only 2 decimal points.

Is this doable thru a change in SQL 2000 or a change in the query itself?

I'm doing an email merge, and the tag used won't allow formatting of
anything within the body of the email, so the data has to be correctly
formatted before being inserted into the email. The above number is a dollar
amount owed by customers past due, so it need to be displayed in the email
as $70.05 and right now shows as $70.0500

Appreciate any insights. Thanks.

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

RE: UDF or Custom Tag

[Jerry Johnson]

Typing this in email - so it may not work :)

\1\2 ","ALL")>

(NOTE: it doesn't handle if there is no space after a  tag.)

Jerry Johnson


>>> [EMAIL PROTECTED] 04/03/02 03:17PM >>>
actually i meant a function to search through text to find the patter
"http://"; OR "www." and returns that entire string (to the next space) back
with  tags around it

-chris.alvarado
[application.developer]
4 Guys Interactive, Inc.

-Original Message-
From: Park, Simon [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 11:20 AM
To: CF-Talk
Subject: RE: UDF or Custom Tag



function CreateHTMLLink(textin) {
textout = "" & textin & "";
return textout;
}



#CreateHTMLLink("http://www.yahoo.com";)#


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Simon Park  Computer Systems Management, Inc.
Director, E-Business205 South Whiting Street #201
Ph: 703-823-4300 x119   Alexandria, VA  22304
fax: 703-823-4301   http://www.csmi.com 

> -Original Message-
> From: chris.alvarado [mailto:[EMAIL PROTECTED]] 
> Sent: Wednesday, April 03, 2002 11:45 AM
> To: CF-Talk
> Subject: UDF or Custom Tag
>
>
> does anyone have a UDF or Custom tag that will turn,
>
> http://www.yahoo.com into  href="http://www.yahoo.com";>http://www.yahoo.com
>
>
> i would just build it myself but im swamped.
>
> thanks a million.
>
> -chris.alvarado
> [application.developer]
> 4 Guys Interactive, Inc.
>
>
>


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

RE: How could I improve this code?

[Tony_Petruzzi]

if you have questions about the code, please email me directly since this
post is huge.
[EMAIL PROTECTED]

Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 3:33 PM
To: CF-Talk
Subject: RE: How could I improve this code?


===
Index2.cfm
===



"

I removed all of your comments

one of the main things i change is that the delimeter in the file is now "|"
instead of a tab. I think that that tabs
and spaces for delimeters are clunky to work with. Also I seperated the
question and answers with a "^".

 ///--->



Untitled






   




LineNumber = 1;
QuizArray = ArrayNew(2);
NumberOfQuestions = ListLen("#AllLines#", "#chr(10)##chr(13)#");
for(SingleLine=1;SingleLine LTE
NumberOfQuestions;SingleLine=SingleLine+1){
ThisLine = ListGetAt(AllLines, SingleLine,
"#chr(10)##chr(13)#");
AnswerList = ListFirst(ThisLine, "^");
Question = ListLast(ThisLine, "^");
QuizArray[LineNumber][1] = AnswerList;
QuizArray[LineNumber][2] = Question;
LineNumber = LineNumber + 1;
}








#QuizArray[QuestionIndex][2]#


#ListGetAt(QuizArray[QuestionIndex][1], ItemIndex,
"|")#



 





NumberRight = 0;
for(QuestionIndex=1;QuestionIndex LTE
NumberOfQuestions;QuestionIndex=QuestionIndex+1){
YourAnswer = Evaluate("Form.Ans"&QuestionIndex);
CorrectAnswer =
#ListLast(QuizArray[QuestionIndex][1], "|")#;
writeoutput("Question #QuestionIndex#:
#QuizArray[QuestionIndex][2]#");
writeoutput("Correct Answer: #CorrectAnswer#");
if(YourAnswer EQ CorrectAnswer){
writeoutput("That is correct!");
NumberRight = NumberRight + 1;
}
else{writeoutput("That is incorrect.");}
}
Score = (NumberRight/NumberOfQuestions)*100;
writeoutput("You scored #Score#%. Thanks for taking the
quiz!");











Quiz.txt

me|greg|charles|me^who's you daddy
tony|charles|greg|tony^who is the man
kara|peach|jewlery|nutmeg|peach^cutest dog



Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org


-Original Message-
From: trey [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 2:50 PM
To: CF-Talk
Subject: How could I improve this code?


Apologies for posting a big chunk of code. This is a simple multiple-choice 
quiz that gets generated from a tab-delimited text file as noted below. It 
works, but as a novice CF programmer, I was wondering how it might be
improved.

Thanks,
Trey






 Untitled









 
 

 
 
 
 

 
 

 
 

 
 

 
 
 
 

 
 

 
 
 
 

 
 
 

 
 


 
 

 
 

 
 
#QuizArray[QuestionIndex][NumberOfItems]#

 
 
 #QuizArray[QuestionIndex][ItemIndex]#
 

 
 
  
 



 
 
 
 

 
 
 
 

 
 

 
 

 
 

 
 
 
 

 
 

 
 
 
 

 
 
 

 
 
 

 
 

 
 
 
 
 
 
 

 
 
 #CurrentQuestion#
 You chose #CurrentAnswer#.
 
 That is correct!
 
 
 That is incorrect. The correct answer is 
#CorrectAnswer#
 
 

 

 
 You scored #Score#%. Thanks for taking the 
quiz!









__
Get the mailserver that 

RE: CF VS ASP <- let the trolling being

[Neil Clark - =TMM=]

There is also X-Platorm issues with ASP.   Also, with MM and Allaire
merging and with Flash MX etc.. jeez we have an exciting time ahead.

N

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

RE: How could I improve this code?

[Tony_Petruzzi]

===
Index2.cfm
===



"

I removed all of your comments

one of the main things i change is that the delimeter in the file is now "|"
instead of a tab. I think that that tabs
and spaces for delimeters are clunky to work with. Also I seperated the
question and answers with a "^".

 ///--->



Untitled






   




LineNumber = 1;
QuizArray = ArrayNew(2);
NumberOfQuestions = ListLen("#AllLines#", "#chr(10)##chr(13)#");
for(SingleLine=1;SingleLine LTE
NumberOfQuestions;SingleLine=SingleLine+1){
ThisLine = ListGetAt(AllLines, SingleLine,
"#chr(10)##chr(13)#");
AnswerList = ListFirst(ThisLine, "^");
Question = ListLast(ThisLine, "^");
QuizArray[LineNumber][1] = AnswerList;
QuizArray[LineNumber][2] = Question;
LineNumber = LineNumber + 1;
}








#QuizArray[QuestionIndex][2]#


#ListGetAt(QuizArray[QuestionIndex][1], ItemIndex,
"|")#



 





NumberRight = 0;
for(QuestionIndex=1;QuestionIndex LTE
NumberOfQuestions;QuestionIndex=QuestionIndex+1){
YourAnswer = Evaluate("Form.Ans"&QuestionIndex);
CorrectAnswer =
#ListLast(QuizArray[QuestionIndex][1], "|")#;
writeoutput("Question #QuestionIndex#:
#QuizArray[QuestionIndex][2]#");
writeoutput("Correct Answer: #CorrectAnswer#");
if(YourAnswer EQ CorrectAnswer){
writeoutput("That is correct!");
NumberRight = NumberRight + 1;
}
else{writeoutput("That is incorrect.");}
}
Score = (NumberRight/NumberOfQuestions)*100;
writeoutput("You scored #Score#%. Thanks for taking the
quiz!");











Quiz.txt

me|greg|charles|me^who's you daddy
tony|charles|greg|tony^who is the man
kara|peach|jewlery|nutmeg|peach^cutest dog



Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org


-Original Message-
From: trey [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 2:50 PM
To: CF-Talk
Subject: How could I improve this code?


Apologies for posting a big chunk of code. This is a simple multiple-choice 
quiz that gets generated from a tab-delimited text file as noted below. It 
works, but as a novice CF programmer, I was wondering how it might be
improved.

Thanks,
Trey






 Untitled









 
 

 
 
 
 

 
 

 
 

 
 

 
 
 
 

 
 

 
 
 
 

 
 
 

 
 


 
 

 
 

 
 
#QuizArray[QuestionIndex][NumberOfItems]#

 
 
 #QuizArray[QuestionIndex][ItemIndex]#
 

 
 
  
 



 
 
 
 

 
 
 
 

 
 

 
 

 
 

 
 
 
 

 
 

 
 
 
 

 
 
 

 
 
 

 
 

 
 
 
 
 
 
 

 
 
 #CurrentQuestion#
 You chose #CurrentAnswer#.
 
 That is correct!
 
 
 That is incorrect. The correct answer is 
#CorrectAnswer#
 
 

 

 
 You scored #Score#%. Thanks for taking the 
quiz!








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

RE: Client Variable Database Storage

[Chris Montgomery]

I've always used session variables, too, until now. I'm playing with Toby's
OpenForums for Fusebox. It's set up to use client vars. Rather than mucking
around and changing everything to the session scope, I thought I would first
give it a whirl as is. My host tells me that setting my original data source
up to handle client vars won't be a problem.

Cheers and thanks.

Chris

> -Original Message-
> From: Christopher Olive [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 2:15 PM
> To: CF-Talk
> Subject: RE: Client Variable Database Storage
>
>
> i think he's referring to the CFID and CFTOKEN storage that CF
> does.  that requires the registry (really bad!), an ODBC source
> (best!), or cookies (fair to middling).
>
> christopher olive
>
> -Original Message-
> From: Robert Everland [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 2:52 PM
> To: CF-Talk
> Subject: RE: Client Variable Database Storage
>
>
> If you don't expect a lot of traffic, just use session variables.
> I only use
> client variables on sites that will either have a lot of traffic, or ones
> that I would like to move one day to a clustered enviroment. Use session
> variables (with locking), it will make your life easier.
>
> Robert Everland III

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

RE: File sizes

[VAN VLIET, SCOTT E (SBCSI)]

http://livedocs.macromedia.com/cf50docs/CFML_Reference/Tags14.jsp

--
Scott Van Vliet
Senior Analyst
SBC Services, Inc.
ITO Enterprise Tools
Office: 858.886.3878
Pager: 858.536.0070
Email: [EMAIL PROTECTED] 


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 12:26 PM
To: CF-Talk
Subject: File sizes


Is there a way to get the size of a file with Fusion?

Thanks.
Nick



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

CF_AutoLogout (was RE: Auto logout when leaving the application)

[VAN VLIET, SCOTT E (SBCSI)]

I have seen several people post questions regarding this matter before, so I
built this little tool:

CF_AutoLogout v1.0
http://www.brdwrks.com/downloads/AutoLogout.zip

This tool will automatically send a user to a logout page if that user is
inactive for a specified amount of time.

USAGE:



This tag basically just writes the window watcher JavaScript that will do a
redirect after a certain amount of time.  You will need a script which
actually expires the user's session / logs the user out, and you will
specify this script as the LogoutLocation.

The tag is self documented, but if you have any questions, please let me
know.

Enjoy!


--
Scott Van Vliet
Senior Analyst
SBC Services, Inc.
ITO Enterprise Tools
Office: 858.886.3878
Pager: 858.536.0070
Email: [EMAIL PROTECTED]


-Original Message-
From: VAN VLIET, SCOTT E (SBCSI)
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 11:05 AM
To: CF-Talk
Subject: RE: Auto logout when leaving the application


I am building a JS tool that will automate this process.  I will post it..

--
Scott Van Vliet
Senior Analyst
SBC Services, Inc.
ITO Enterprise Tools
Office: 858.886.3878
Pager: 858.536.0070
Email: [EMAIL PROTECTED]
 


-Original Message-
From: Shawn Regan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 9:20 AM
To: CF-Talk
Subject: RE: Auto logout when leaving the application


I believe I got this a while back from hal helms website.


  
  
  
  


this kills the client/session variables when the browser closes because it
has taken the cookies set by the cfapplication and resets them to expire
when the browser closes.


Shawn Regan
Applications Developer
Pacific Technology Solutions 

-Original Message-
From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 8:49 AM
To: CF-Talk
Subject: RE: Auto logout when leaving the application


I am working on a custom tag that will solve this, and will post it when I
finish.

--
Scott Van Vliet
Senior Analyst
SBC Services, Inc.
ITO Enterprise Tools
Office: 858.886.3878
Pager: 858.536.0070
Email: [EMAIL PROTECTED]


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 8:41 AM
To: CF-Talk
Subject: Re: Auto logout when leaving the application


Good question.  I am also interested in this response, but with an added
element.  What if a user closes the browser, how do you kill client/session
variables, presumably someone could close the browser thinking they are
"logged out", the next person wanders up and sees the first persons
information.

CC


 

Brian Fox

   
@sdccd.cc.ca.cc:

us>  Subject: Auto logout when
leaving the application 
 

04/03/02

10:30 AM

Please

respond to

cf-talk

 

 





What's the best way of handling security for a website that may be used in
a
kiosk mode?  I'm working on a student grade system that does a one time
validation and sets a session variable.  Timeout is 15 minutes.

John may log into the system using a lab computer to retrieve his student
grades, become confused, wander to yahoo, read his mail, then leave the
computer as is.  Sue may come in to use the same machine, go to the grade
application to get her grades, and still be logged in as John.  Is there a
good way to avoid this?

I'm thinking about mangling the referer variable and zapping the session
variables if the referer is not from the application.

 i.e. http://www.gradesrus.com/"; ...
session.auth=0>

That would solve the 'lost' client wandering out of the site.  Leaving the
site is equivalent to logging out then (more or less).

What about a javascript warning when a person is going to leave the
application?  I'm not a javascript guru, but it seems like an onunload in
the body should be able to give a popup alert and hopefully the ability to
cancel the outside navigation.  Anyone ever try it?

Is there a better approach to this?

Thanks!
Brian






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

File sizes

[nick]

Is there a way to get the size of a file with Fusion?

Thanks.
Nick


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

RE: UDF or Custom Tag

[chris.alvarado]

actually i meant a function to search through text to find the patter
"http://"; OR "www." and returns that entire string (to the next space) back
with  tags around it

-chris.alvarado
[application.developer]
4 Guys Interactive, Inc.

-Original Message-
From: Park, Simon [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 11:20 AM
To: CF-Talk
Subject: RE: UDF or Custom Tag



function CreateHTMLLink(textin) {
textout = "" & textin & "";
return textout;
}



#CreateHTMLLink("http://www.yahoo.com";)#


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Simon Park  Computer Systems Management, Inc.
Director, E-Business205 South Whiting Street #201
Ph: 703-823-4300 x119   Alexandria, VA  22304
fax: 703-823-4301   http://www.csmi.com

> -Original Message-
> From: chris.alvarado [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 11:45 AM
> To: CF-Talk
> Subject: UDF or Custom Tag
>
>
> does anyone have a UDF or Custom tag that will turn,
>
> http://www.yahoo.com into  href="http://www.yahoo.com";>http://www.yahoo.com
>
>
> i would just build it myself but im swamped.
>
> thanks a million.
>
> -chris.alvarado
> [application.developer]
> 4 Guys Interactive, Inc.
>
>
>

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

RE: CF VS ASP <- let the trolling being

[Thane Sherrington]

At 12:06 PM 4/3/02 -0800, David Schmidt wrote:
>If he's willing to fork the bucks for the training.  Grab hold, hang on, and
>take what you can learn.

A cold hearted approach (but I think wise) would be to get the training 
paid for, and then move to a company that is more reasonable.

T

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

RE: OT: SQL Server Connection

[Christopher Olive]

does the database server have a publicly acessible IP address?  if so, just crate the 
ODBC source on the ISP for the site, and point it to that IP.

christopher olive
cto, vp of web development, vp it security
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com


-Original Message-
From: Thanh Nguyen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 3:11 PM
To: CF-Talk
Subject: FW: OT: SQL Server Connection


 
Hi all,
 
I have a website that's accessing a sql database on the same network.
Starting next week, I'd have to move my website to an ISP. 
My Question is how should I set up the connection to my SQL server database
which will stay in-house?  I can't'move the database because we also have
other in-house applications connecting to the same database. 
 
What's the best way to do this?
Should I create a duplicate database on the ISP server just for the website.
and sync it with our main database here? any potential problems with doing
this?
 
Any advice would be appreciated.
 
Thanks.


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

RE: Client Variable Database Storage

[Christopher Olive]

i think he's referring to the CFID and CFTOKEN storage that CF does.  that requires 
the registry (really bad!), an ODBC source (best!), or cookies (fair to middling).

christopher olive
cto, vp of web development, vp it security
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com


-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 2:52 PM
To: CF-Talk
Subject: RE: Client Variable Database Storage


If you don't expect a lot of traffic, just use session variables. I only use
client variables on sites that will either have a lot of traffic, or ones
that I would like to move one day to a clustered enviroment. Use session
variables (with locking), it will make your life easier.

Robert Everland III
Dixon Ticonderoga
Web Developer Extraordinaire

-Original Message-
From: Chris Montgomery [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 2:50 PM
To: CF-Talk
Subject: RE: Client Variable Database Storage


Matt and Tony,

Thanks for the quick response. Your messages confirmed some of my
assumptions. Here's what my hosting company support had to say about it:

> Hi Chris, we create a DSN for each individual client who wants CV
> storage.  You could use either an AccessDB or an MSSQL db for this.  It
> is probably best to have an empty one, as the CF Administrator will
> create the tables necessary.  As you already have a DSN associated with
> this account an additional one would incur a $5/month charge.  You could
> avoid this charge by using your current database for CV storage, as the
> table names that are created are fairly unique.  However, do this at
> your own risk.  Please let us know if you have any further questions.

I think I will be able to work with just having them configure my already
existing datasource to store client vars. It's for a fairly small site and I
don't really expect lots of traffic.

Thanks again.

Chris Montgomery[EMAIL PROTECTED]

Airtight Web Services
Web Development, Web Project Management, Software Sales
Macromedia Sales & Consulting Partner
210-490-3249/888-745-7603

> -Original Message-
> From: Matt Robertson [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 1:28 PM
> To: CF-Talk
> Subject: RE: Client Variable Database Storage
>
>
> Chris,
>
> You can put your client vars in any dsn you like, so long as you specify
> that dsn as a client var repository in the CF Administrator.  If you've
> already created your tables, just leave the ''create tables'' choice
> unchecked when you do the above.
>
> This lets you specify multiple client var datasources, one for each
> client assuming each client has its own dsn.  You may or may not want to
> do that.  I used to but mostly don't anymore, preferring instead to
> keeping those w/generic needs in a server-wide db.  I have some clients
> whose expirations differ from the norm, so I break them out into their
> own db's.
>
> I'm not sure this is something you can really manage with a shared host.
> You'll have to ask them directly if they can set you up.
>
> --Matt Robertson--
> MSB Designs, Inc.
> http://mysecretbase.com
>



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

RE: CF VS ASP <- let the trolling being

[Rick Walters]

Agreed, it's a bitter pill to take.  But, it's arguably still a
recession. 

Good Fortune,
Richard Walters,
Webmaster, Davita Laboratory Services
[EMAIL PROTECTED]
(800) 604-5227 x 3525

>>> [EMAIL PROTECTED] 04/03/02 03:03PM >>>
Yes, I agree with you, but killing all of our CF is what is making me
a
little sour on the subject, would have no problem learning more of it,
but to ask me to abandon CF totally gets to me since I am very fond of
using CF

Rob

-Original Message-
From: Rick Walters [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 11:46 AM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being

Honestly,

If he's willing to pay you to cross train in ASP, why complain?  I'm
assuming that you have already written a score of reports and tools
that
will all need to be translated into ASP and who would know the reports
better than their author.  ASP isn't "that" different from Cold Fusion.

Cold Fusion takes care of quite a few loose ends and takes far less
time
to produce quick apps.  So, if your new boss is dead-set on using ASP
pick up a few "kill weight" manuals on ASP coding and rewrite one of
your tools.  

Remeber, coders survive on being able to code.  Managers survive on
making good business decisions.  You may well see a new manager in the
not so distant future.

Good Fortune,
Richard Walters,
Webmaster, Davita Laboratory Services
[EMAIL PROTECTED] 
(800) 604-5227 x 3525

>>> [EMAIL PROTECTED] 04/03/02 02:36PM >>>
But I have made up my mind that if they kill Cold Fusion here I am not
staying here any longer. It is mostly because we have a new manager
that
seems to be such a die hard ASP fan who swears it is better then CF
even
though he does not even know anything about CF. A little annoying, but
I
think since he is not the one that is doing any of the coding, he
should
really go with what us developers are wanting to work with. Maybe I am
living in a dream like state when I think that managers will always
pick
the best product.



-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 11:28 AM
To: CF-Talk
Subject: Re: CF VS ASP <- let the trolling being

and on that note you should tell your boss there is a new version of
CF
comingall that can be
said here is WOW...wait for it...can you say coool
;-)

Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED] 
-
Macromedia Associate Partner
www.macromedia.com 
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com 

- Original Message -
From: "Robert Bailey" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 11:12 AM
Subject: RE: CF VS ASP <- let the trolling being


> Yeah, I thought this would get quite a bit of response, but I would
> really like the information to share with my current employer who
wants
> to move from CF to ASP and get rid of CF, which I do not want to do
at
> all, and I only know a little ASP, and from what I do know, I do not
> like it.
>
> Rob
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
> Sent: Wednesday, April 03, 2002 10:59 AM
> To: CF-Talk
> Subject: RE: CF VS ASP <- let the trolling being
>
> gentlemen (and ladies) start your engines
>
> Anthony Petruzzi
> Webmaster
> 954-321-4703
> http://www.sheriff.org 
>
>
> -Original Message-
> From: Robert Bailey [mailto:[EMAIL PROTECTED]] 
> Sent: Wednesday, April 03, 2002 2:03 PM
> To: CF-Talk
> Subject: CF VS ASP
>
>
> OK, I have been looking for some things on the net that shows the
pros
> and cons of CF as opposed to ASP. Knowing very little ASP myself, I
do
> not know the many differences. Anyone know where I can find this?
Pretty
> much looking for development time differences, execution speed,
security
> and scalability at a bare minimum. Anyone know where I can find
this?
>
> Rob
>
>
>
>
>
> 




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

FW: OT: SQL Server Connection

[Thanh Nguyen]

 
Hi all,
 
I have a website that's accessing a sql database on the same network.
Starting next week, I'd have to move my website to an ISP. 
My Question is how should I set up the connection to my SQL server database
which will stay in-house?  I can't'move the database because we also have
other in-house applications connecting to the same database. 
 
What's the best way to do this?
Should I create a duplicate database on the ISP server just for the website.
and sync it with our main database here? any potential problems with doing
this?
 
Any advice would be appreciated.
 
Thanks.

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

RE: Question on parametising the variables that are generated on the fly?

[Jamie Jackson]

or maybe you want



but i'm also not sure what you're doing.

those are some ideas, anyway.

Jamie

-Original Message-
From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 2:50 PM
To: CF-Talk
Subject: Question on parametising the variables that are generated on
the fly?


Hi,
  I am building the variables like this way.



the variable generated would look like this:
  CALENDARENDDATE_12

   Actually a variable of this is coming from the previous screen. I
wanted to see whether that variable is null or not.

  When I am using:


It is giving an error: saying that error in that variable.

I could figure out how to use  that variable to give a default
value.

I hope I am clear in asking question.

thanks in advance.

Sudheer Chakka.


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

RE: CF VS ASP <- let the trolling being

[Robert Bailey]

No problem learning something new, I learned the little bit of ASP and
PHP here, but I do not want to abandon CF completely, which is what he
is asking

Rob

-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 11:54 AM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being

Will they keep you on? You should be happy; you get paid to learn
something new.

On Wed, 3 Apr 2002, Robert Bailey wrote:

> Yeah, I thought this would get quite a bit of response, but I would
> really like the information to share with my current employer who
wants
> to move from CF to ASP and get rid of CF, which I do not want to do at
> all, and I only know a little ASP, and from what I do know, I do not
> like it. 
> 
> Rob
> 
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
> Sent: Wednesday, April 03, 2002 10:59 AM
> To: CF-Talk
> Subject: RE: CF VS ASP <- let the trolling being
> 
> gentlemen (and ladies) start your engines
> 
> Anthony Petruzzi
> Webmaster
> 954-321-4703
> http://www.sheriff.org
> 
> 
> -Original Message-
> From: Robert Bailey [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 2:03 PM
> To: CF-Talk
> Subject: CF VS ASP
> 
> 
> OK, I have been looking for some things on the net that shows the pros
> and cons of CF as opposed to ASP. Knowing very little ASP myself, I do
> not know the many differences. Anyone know where I can find this?
Pretty
> much looking for development time differences, execution speed,
security
> and scalability at a bare minimum. Anyone know where I can find this?
> 
> Rob
> 
> 
> 
> 
> 
> 

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

RE: Question on parametising the variables that are generated on the fly?

[Jamie Jackson]

you might want



or 



depending whether you want to know if it's defined, or if it's the empty
string.

jamie

-Original Message-
From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 2:50 PM
To: CF-Talk
Subject: Question on parametising the variables that are generated on
the fly?


Hi,
  I am building the variables like this way.



the variable generated would look like this:
  CALENDARENDDATE_12

   Actually a variable of this is coming from the previous screen. I
wanted to see whether that variable is null or not.

  When I am using:


It is giving an error: saying that error in that variable.

I could figure out how to use  that variable to give a default
value.

I hope I am clear in asking question.

thanks in advance.

Sudheer Chakka.


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

RE: CF VS ASP <- let the trolling being

[David Schmidt]

If he's willing to fork the bucks for the training.  Grab hold, hang on, and
take what you can learn.


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

RE: CF VS ASP <- let the trolling being

[David Schmidt]

>
> Remeber, coders survive on being able to code.  Managers survive on
> making good business decisions.  You may well see a new manager in the
> not so distant future.

Yep, and then he'll be able to learn yet another language, thus broadening
his skill set, and increasing his market worth. :)

"I need input..." - Johnny 5


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

RE: CF VS ASP <- let the trolling being

[Robert Bailey]

Yes, I agree with you, but killing all of our CF is what is making me a
little sour on the subject, would have no problem learning more of it,
but to ask me to abandon CF totally gets to me since I am very fond of
using CF

Rob

-Original Message-
From: Rick Walters [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 11:46 AM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being

Honestly,

If he's willing to pay you to cross train in ASP, why complain?  I'm
assuming that you have already written a score of reports and tools that
will all need to be translated into ASP and who would know the reports
better than their author.  ASP isn't "that" different from Cold Fusion. 
Cold Fusion takes care of quite a few loose ends and takes far less time
to produce quick apps.  So, if your new boss is dead-set on using ASP
pick up a few "kill weight" manuals on ASP coding and rewrite one of
your tools.  

Remeber, coders survive on being able to code.  Managers survive on
making good business decisions.  You may well see a new manager in the
not so distant future.

Good Fortune,
Richard Walters,
Webmaster, Davita Laboratory Services
[EMAIL PROTECTED]
(800) 604-5227 x 3525

>>> [EMAIL PROTECTED] 04/03/02 02:36PM >>>
But I have made up my mind that if they kill Cold Fusion here I am not
staying here any longer. It is mostly because we have a new manager
that
seems to be such a die hard ASP fan who swears it is better then CF
even
though he does not even know anything about CF. A little annoying, but
I
think since he is not the one that is doing any of the coding, he
should
really go with what us developers are wanting to work with. Maybe I am
living in a dream like state when I think that managers will always
pick
the best product.



-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 11:28 AM
To: CF-Talk
Subject: Re: CF VS ASP <- let the trolling being

and on that note you should tell your boss there is a new version of
CF
comingall that can be
said here is WOW...wait for it...can you say coool
;-)

Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED] 
-
Macromedia Associate Partner
www.macromedia.com 
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com 

- Original Message -
From: "Robert Bailey" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 11:12 AM
Subject: RE: CF VS ASP <- let the trolling being


> Yeah, I thought this would get quite a bit of response, but I would
> really like the information to share with my current employer who
wants
> to move from CF to ASP and get rid of CF, which I do not want to do
at
> all, and I only know a little ASP, and from what I do know, I do not
> like it.
>
> Rob
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
> Sent: Wednesday, April 03, 2002 10:59 AM
> To: CF-Talk
> Subject: RE: CF VS ASP <- let the trolling being
>
> gentlemen (and ladies) start your engines
>
> Anthony Petruzzi
> Webmaster
> 954-321-4703
> http://www.sheriff.org 
>
>
> -Original Message-
> From: Robert Bailey [mailto:[EMAIL PROTECTED]] 
> Sent: Wednesday, April 03, 2002 2:03 PM
> To: CF-Talk
> Subject: CF VS ASP
>
>
> OK, I have been looking for some things on the net that shows the
pros
> and cons of CF as opposed to ASP. Knowing very little ASP myself, I
do
> not know the many differences. Anyone know where I can find this?
Pretty
> much looking for development time differences, execution speed,
security
> and scalability at a bare minimum. Anyone know where I can find
this?
>
> Rob
>
>
>
>
>
> 



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

RE: CF VS ASP <- let the trolling being

[Robert Bailey]

Yes, he knows we develop at a very fast pace, mostly thanks to the
FuseBox specs. He wants me to learn ASP and create the intranet using
ASP as opposed to CF, hm, that sounds like fun, all I can really do
in ASP right now is retrieve and update data in a DB and send email, so
I imagine I may have a lot to learn, at least he bought me some books,
lol


-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 11:47 AM
To: CF-Talk
Subject: Re: CF VS ASP <- let the trolling being

Have you pointed out the rapid development nature of CF?  Talk their
talk...faster development
translates to lower development/maintenance costs.  Talk like that
usually grabs the suits attention
;-)

Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com

- Original Message -
From: "Robert Bailey" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 11:36 AM
Subject: RE: CF VS ASP <- let the trolling being


> But I have made up my mind that if they kill Cold Fusion here I am not
> staying here any longer. It is mostly because we have a new manager
that
> seems to be such a die hard ASP fan who swears it is better then CF
even
> though he does not even know anything about CF. A little annoying, but
I
> think since he is not the one that is doing any of the coding, he
should
> really go with what us developers are wanting to work with. Maybe I am
> living in a dream like state when I think that managers will always
pick
> the best product.
>
>
>
> -Original Message-
> From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 11:28 AM
> To: CF-Talk
> Subject: Re: CF VS ASP <- let the trolling being
>
> and on that note you should tell your boss there is a new version of
CF
> comingall that can be
> said here is WOW...wait for it...can you say coool
> ;-)
>
> Bryan Stevenson
> VP & Director of E-Commerce Development
> Electric Edge Systems Group Inc.
> p. 250.920.8830
> e. [EMAIL PROTECTED]
> -
> Macromedia Associate Partner
> www.macromedia.com
> -
> Vancouver Island ColdFusion Users Group
> Founder & Director
> www.cfug-vancouverisland.com
>
> - Original Message -
> From: "Robert Bailey" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, April 03, 2002 11:12 AM
> Subject: RE: CF VS ASP <- let the trolling being
>
>
> > Yeah, I thought this would get quite a bit of response, but I would
> > really like the information to share with my current employer who
> wants
> > to move from CF to ASP and get rid of CF, which I do not want to do
at
> > all, and I only know a little ASP, and from what I do know, I do not
> > like it.
> >
> > Rob
> >
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, April 03, 2002 10:59 AM
> > To: CF-Talk
> > Subject: RE: CF VS ASP <- let the trolling being
> >
> > gentlemen (and ladies) start your engines
> >
> > Anthony Petruzzi
> > Webmaster
> > 954-321-4703
> > http://www.sheriff.org
> >
> >
> > -Original Message-
> > From: Robert Bailey [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, April 03, 2002 2:03 PM
> > To: CF-Talk
> > Subject: CF VS ASP
> >
> >
> > OK, I have been looking for some things on the net that shows the
pros
> > and cons of CF as opposed to ASP. Knowing very little ASP myself, I
do
> > not know the many differences. Anyone know where I can find this?
> Pretty
> > much looking for development time differences, execution speed,
> security
> > and scalability at a bare minimum. Anyone know where I can find
this?
> >
> > Rob
> >
> >
> >
> >
> >
> >
>
> 

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

RE: CF VS ASP <- let the trolling being

[Robert Bailey]

No arguments really, just close minded

-Original Message-
From: Neil Giarratana [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 11:44 AM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being

I'm sure a lot of people on this list are former ASP'ers.  As one of
them, I
can tell you that life does not have to be that hard.  Does he have
specific
"ASP is better" arguments?  At our MMUG meeting yesterday, there was an
ASP'er who was seeing how to connect to a database in CF for the first
time.
I talked to him afterward and he said that we kept asking himself
"where's
the rest of the code?" until he figured out that there wasn't any...

Regards,
Neil

-Original Message-
From: Robert Bailey [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 2:37 PM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being


But I have made up my mind that if they kill Cold Fusion here I am not
staying here any longer. It is mostly because we have a new manager that
seems to be such a die hard ASP fan who swears it is better then CF even
though he does not even know anything about CF. A little annoying, but I
think since he is not the one that is doing any of the coding, he should
really go with what us developers are wanting to work with. Maybe I am
living in a dream like state when I think that managers will always pick
the best product.



-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 11:28 AM
To: CF-Talk
Subject: Re: CF VS ASP <- let the trolling being

and on that note you should tell your boss there is a new version of CF
comingall that can be
said here is WOW...wait for it...can you say coool
;-)

Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com

- Original Message -
From: "Robert Bailey" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 11:12 AM
Subject: RE: CF VS ASP <- let the trolling being


> Yeah, I thought this would get quite a bit of response, but I would
> really like the information to share with my current employer who
wants
> to move from CF to ASP and get rid of CF, which I do not want to do at
> all, and I only know a little ASP, and from what I do know, I do not
> like it.
>
> Rob
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 10:59 AM
> To: CF-Talk
> Subject: RE: CF VS ASP <- let the trolling being
>
> gentlemen (and ladies) start your engines
>
> Anthony Petruzzi
> Webmaster
> 954-321-4703
> http://www.sheriff.org
>
>
> -Original Message-
> From: Robert Bailey [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 2:03 PM
> To: CF-Talk
> Subject: CF VS ASP
>
>
> OK, I have been looking for some things on the net that shows the pros
> and cons of CF as opposed to ASP. Knowing very little ASP myself, I do
> not know the many differences. Anyone know where I can find this?
Pretty
> much looking for development time differences, execution speed,
security
> and scalability at a bare minimum. Anyone know where I can find this?
>
> Rob
>
>
>
>
>
> 



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

RE: CF VS ASP <- let the trolling being

[Alex]

Will they keep you on? You should be happy; you get paid to learn
something new.

On Wed, 3 Apr 2002, Robert Bailey wrote:

> Yeah, I thought this would get quite a bit of response, but I would
> really like the information to share with my current employer who wants
> to move from CF to ASP and get rid of CF, which I do not want to do at
> all, and I only know a little ASP, and from what I do know, I do not
> like it. 
> 
> Rob
> 
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
> Sent: Wednesday, April 03, 2002 10:59 AM
> To: CF-Talk
> Subject: RE: CF VS ASP <- let the trolling being
> 
> gentlemen (and ladies) start your engines
> 
> Anthony Petruzzi
> Webmaster
> 954-321-4703
> http://www.sheriff.org
> 
> 
> -Original Message-
> From: Robert Bailey [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 2:03 PM
> To: CF-Talk
> Subject: CF VS ASP
> 
> 
> OK, I have been looking for some things on the net that shows the pros
> and cons of CF as opposed to ASP. Knowing very little ASP myself, I do
> not know the many differences. Anyone know where I can find this? Pretty
> much looking for development time differences, execution speed, security
> and scalability at a bare minimum. Anyone know where I can find this?
> 
> Rob
> 
> 
> 
> 
> 
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CF VS ASP

[Alex]

cf-talk archives


On Wed, 3 Apr 2002, Robert Bailey wrote:

> OK, I have been looking for some things on the net that shows the pros
> and cons of CF as opposed to ASP. Knowing very little ASP myself, I do
> not know the many differences. Anyone know where I can find this? Pretty
> much looking for development time differences, execution speed, security
> and scalability at a bare minimum. Anyone know where I can find this?
> 
> Rob
> 
> 
> 
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF VS ASP <- let the trolling being

[Robert Bailey]

Mandate, that and a disillusioned view of ASP

Rob


-Original Message-
From: Greg Jordan [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 11:43 AM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being

here is an article from pcmagazine comparing a slew of web applications
servers/languages...

http://www.pcmag.com/article/0,2997,s=1611&a=3125,00.asp

The real question for me would be WHY ON EARTH would your current
employer
switch to ASP if you don't have any experience with it and they are
currently using CF.  Have they not seen the NEO faq?  Or is this one of
those "mandate" thingys?

-Original Message-
From: Robert Bailey [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 1:13 PM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being


Yeah, I thought this would get quite a bit of response, but I would
really like the information to share with my current employer who wants
to move from CF to ASP and get rid of CF, which I do not want to do at
all, and I only know a little ASP, and from what I do know, I do not
like it.

Rob

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 10:59 AM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being

gentlemen (and ladies) start your engines

Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org


-Original Message-
From: Robert Bailey [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 2:03 PM
To: CF-Talk
Subject: CF VS ASP


OK, I have been looking for some things on the net that shows the pros
and cons of CF as opposed to ASP. Knowing very little ASP myself, I do
not know the many differences. Anyone know where I can find this? Pretty
much looking for development time differences, execution speed, security
and scalability at a bare minimum. Anyone know where I can find this?

Rob







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

Re: arraySum() for structures?

[Jon Hall]

Ditto, what Phillip said...but here is a hack.



myStruct = structnew();
myStruct.val1 = 1;
myStruct.val2 = 3;
myStruct.val3 = 2;

list = structKeyList(myStruct);
total = 0;
for(i = 1; i LTE listLen(list); i = i + 1) {
 total = total + myStruct[listGetAt(list,i)];
}

#total#

- Original Message -
From: "Cantrell, Adam" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 11:14 AM
Subject: arraySum() for structures?


> Does anyone know how I can get the sum of values from a structure?
>
> Example:
>
> 
>
> myStruct = structnew();
> myStruct.val1 = "1";
> myStruct.val2 = "3";
> myStruct.val3 = "2";
>
> 
>
> I want to quickly return the sum, 6, without having to loop over the keys
> and all that. Is it possible?
>
> Adam.
>
> 
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Client Variable Database Storage

[Robert Everland]

If you don't expect a lot of traffic, just use session variables. I only use
client variables on sites that will either have a lot of traffic, or ones
that I would like to move one day to a clustered enviroment. Use session
variables (with locking), it will make your life easier.

Robert Everland III
Dixon Ticonderoga
Web Developer Extraordinaire

-Original Message-
From: Chris Montgomery [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 2:50 PM
To: CF-Talk
Subject: RE: Client Variable Database Storage


Matt and Tony,

Thanks for the quick response. Your messages confirmed some of my
assumptions. Here's what my hosting company support had to say about it:

> Hi Chris, we create a DSN for each individual client who wants CV
> storage.  You could use either an AccessDB or an MSSQL db for this.  It
> is probably best to have an empty one, as the CF Administrator will
> create the tables necessary.  As you already have a DSN associated with
> this account an additional one would incur a $5/month charge.  You could
> avoid this charge by using your current database for CV storage, as the
> table names that are created are fairly unique.  However, do this at
> your own risk.  Please let us know if you have any further questions.

I think I will be able to work with just having them configure my already
existing datasource to store client vars. It's for a fairly small site and I
don't really expect lots of traffic.

Thanks again.

Chris Montgomery[EMAIL PROTECTED]

Airtight Web Services
Web Development, Web Project Management, Software Sales
Macromedia Sales & Consulting Partner
210-490-3249/888-745-7603

> -Original Message-
> From: Matt Robertson [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 1:28 PM
> To: CF-Talk
> Subject: RE: Client Variable Database Storage
>
>
> Chris,
>
> You can put your client vars in any dsn you like, so long as you specify
> that dsn as a client var repository in the CF Administrator.  If you've
> already created your tables, just leave the ''create tables'' choice
> unchecked when you do the above.
>
> This lets you specify multiple client var datasources, one for each
> client assuming each client has its own dsn.  You may or may not want to
> do that.  I used to but mostly don't anymore, preferring instead to
> keeping those w/generic needs in a server-wide db.  I have some clients
> whose expirations differ from the norm, so I break them out into their
> own db's.
>
> I'm not sure this is something you can really manage with a shared host.
> You'll have to ask them directly if they can set you up.
>
> --Matt Robertson--
> MSB Designs, Inc.
> http://mysecretbase.com
>


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

Question on parametising the variables that are generated on the fly?

[Chakka, Sudheer]

Hi,
  I am building the variables like this way.



the variable generated would look like this:
  CALENDARENDDATE_12

   Actually a variable of this is coming from the previous screen. I
wanted to see whether that variable is null or not.

  When I am using:


It is giving an error: saying that error in that variable.

I could figure out how to use  that variable to give a default
value.

I hope I am clear in asking question.

thanks in advance.

Sudheer Chakka.

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

Re: CF VS ASP <- let the trolling being

[Bryan Stevenson]

LOL...I love doing that to ASPersSOOoOOoo much fun...deer in headlights 
all the way ;-)

Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com

- Original Message - 
From: "Neil Giarratana" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 11:44 AM
Subject: RE: CF VS ASP <- let the trolling being


> I'm sure a lot of people on this list are former ASP'ers.  As one of them, I
> can tell you that life does not have to be that hard.  Does he have specific
> "ASP is better" arguments?  At our MMUG meeting yesterday, there was an
> ASP'er who was seeing how to connect to a database in CF for the first time.
> I talked to him afterward and he said that we kept asking himself "where's
> the rest of the code?" until he figured out that there wasn't any...
> 
> Regards,
> Neil
> 
> -Original Message-
> From: Robert Bailey [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 2:37 PM
> To: CF-Talk
> Subject: RE: CF VS ASP <- let the trolling being
> 
> 
> But I have made up my mind that if they kill Cold Fusion here I am not
> staying here any longer. It is mostly because we have a new manager that
> seems to be such a die hard ASP fan who swears it is better then CF even
> though he does not even know anything about CF. A little annoying, but I
> think since he is not the one that is doing any of the coding, he should
> really go with what us developers are wanting to work with. Maybe I am
> living in a dream like state when I think that managers will always pick
> the best product.
> 
> 
> 
> -Original Message-
> From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] 
> Sent: Wednesday, April 03, 2002 11:28 AM
> To: CF-Talk
> Subject: Re: CF VS ASP <- let the trolling being
> 
> and on that note you should tell your boss there is a new version of CF
> comingall that can be
> said here is WOW...wait for it...can you say coool
> ;-)
> 
> Bryan Stevenson
> VP & Director of E-Commerce Development
> Electric Edge Systems Group Inc.
> p. 250.920.8830
> e. [EMAIL PROTECTED]
> -
> Macromedia Associate Partner
> www.macromedia.com
> -
> Vancouver Island ColdFusion Users Group
> Founder & Director
> www.cfug-vancouverisland.com
> 
> - Original Message -
> From: "Robert Bailey" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, April 03, 2002 11:12 AM
> Subject: RE: CF VS ASP <- let the trolling being
> 
> 
> > Yeah, I thought this would get quite a bit of response, but I would
> > really like the information to share with my current employer who
> wants
> > to move from CF to ASP and get rid of CF, which I do not want to do at
> > all, and I only know a little ASP, and from what I do know, I do not
> > like it.
> >
> > Rob
> >
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, April 03, 2002 10:59 AM
> > To: CF-Talk
> > Subject: RE: CF VS ASP <- let the trolling being
> >
> > gentlemen (and ladies) start your engines
> >
> > Anthony Petruzzi
> > Webmaster
> > 954-321-4703
> > http://www.sheriff.org
> >
> >
> > -Original Message-
> > From: Robert Bailey [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, April 03, 2002 2:03 PM
> > To: CF-Talk
> > Subject: CF VS ASP
> >
> >
> > OK, I have been looking for some things on the net that shows the pros
> > and cons of CF as opposed to ASP. Knowing very little ASP myself, I do
> > not know the many differences. Anyone know where I can find this?
> Pretty
> > much looking for development time differences, execution speed,
> security
> > and scalability at a bare minimum. Anyone know where I can find this?
> >
> > Rob
> >
> >
> >
> >
> >
> > 
> 
> 
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF VS ASP <- let the trolling being

[Jerry Johnson]

Oh, well sure.  

Change the argument to doing something useful, like a "develop a program", and maybe 
I'd choose CF.

I suppose you want some "user interface" or "data connectivity" as well?

What ever happended to stdout as an interface?

Harumph!
Jerry Johnson

>>> [EMAIL PROTECTED] 04/03/02 02:45PM >>>
The new PERL sounds promising, and I would agree that it would be great
to use modperl within CF, I started as a PERL developer.

But if I had a choice to develop a program in CF or PERL, I would pick
CF

But that is my opinion, which only matters when I am home alone

Rob

-Original Message-
From: Jerry Johnson [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 11:46 AM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being

Gasp, sputter, cough.

Blasphemy! Heretic! Unbeliever!

Nothing is better than perl.

My fondest dream would be to be able to write perl (and real regex)
within CF templates. And a good implementation of modperl within the CF
Server.


 -- don't I wish!


"Dreams I'll Never See" - (can you name that band?)
Jerry Johnson

>>> [EMAIL PROTECTED] 04/03/02 02:29PM >>>
Yeah, for sure, maybe some people need to get together and create that,
we use PHP here as well, my opinion of PHP is worse then ASP, not very
fond of it at all, but that is my opinion. Anything is better then PERL
anyways, heh

I think CF5 blows ASP out of the water, like comparing an old Married
with Children type of Dodge to a Corvette

Rob

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 11:14 AM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being

The only problem you have is that you are going to find alot of
information
comparing CF4.0 and ASP/IIS3.0. i would love to see a comparison
between
CF5.0, ASP/IIS5.0, and PHP4.

Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org 


-Original Message-
From: Robert Bailey [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 2:13 PM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being


Yeah, I thought this would get quite a bit of response, but I would
really like the information to share with my current employer who wants
to move from CF to ASP and get rid of CF, which I do not want to do at
all, and I only know a little ASP, and from what I do know, I do not
like it. 

Rob

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 10:59 AM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being

gentlemen (and ladies) start your engines

Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org 


-Original Message-
From: Robert Bailey [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 2:03 PM
To: CF-Talk
Subject: CF VS ASP


OK, I have been looking for some things on the net that shows the pros
and cons of CF as opposed to ASP. Knowing very little ASP myself, I do
not know the many differences. Anyone know where I can find this? Pretty
much looking for development time differences, execution speed, security
and scalability at a bare minimum. Anyone know where I can find this?

Rob










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

RE: CF VS ASP <- let the trolling being

[Paul Wille]

Alright, I will join the discussion here as well, except I will come at
it from the standpoint of CFMX/Neo and ASP.NET.  However, many of the
same arguments are still valid from CF5 and ASP 3.0, such as multiple
platform support for ColdFusion.

I love the ColdFusion Component concept in CFMX, and the ability to call
them as web services.  ASP.NET has made HUGE strides over traditional
ASP, especially in the management of DLL's (this is actually a benefit
of the .NET Framework, not ASP.NET).  Also, ADO.NET is greatly improved
over traditional ADO.  Lastly, with .NET, you have a suite of languages
that can all talk to each other, pass data back and forth very easily,
etc. 

However, ColdFusion still has more built-in functionality that I like.
Its still easier, still faster to develop on, and CFMX is even faster
than CF5.  

So which to go with?  To me, it is still dependent on the application(s)
you are developing, your web/app servers that you intend to run them on,
and cost (including software purchase AND development time).  If you are
already a CF shop with little or no ASP background, stay with CF.  I
guarantee you that CFMX is worth the wait!

Cheers,

--Paul


Paul W. Wille   [EMAIL PROTECTED]
---
Certified Advanced ColdFusion 5 Developer
---
ISITE Design, Inc. -- Solutions Architect
www.isitedesign.com
615 SW Broadway, Suite 200
Portland, OR 97205
503.221.9860 x110
503.221.9865
 

-Original Message-
From: Robert Bailey [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 11:29 AM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being

Yeah, for sure, maybe some people need to get together and create that,
we use PHP here as well, my opinion of PHP is worse then ASP, not very
fond of it at all, but that is my opinion. Anything is better then PERL
anyways, heh

I think CF5 blows ASP out of the water, like comparing an old Married
with Children type of Dodge to a Corvette

Rob

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 11:14 AM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being

The only problem you have is that you are going to find alot of
information
comparing CF4.0 and ASP/IIS3.0. i would love to see a comparison
between
CF5.0, ASP/IIS5.0, and PHP4.

Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org


-Original Message-
From: Robert Bailey [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 2:13 PM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being


Yeah, I thought this would get quite a bit of response, but I would
really like the information to share with my current employer who wants
to move from CF to ASP and get rid of CF, which I do not want to do at
all, and I only know a little ASP, and from what I do know, I do not
like it. 

Rob

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 10:59 AM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being

gentlemen (and ladies) start your engines

Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org


-Original Message-
From: Robert Bailey [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 2:03 PM
To: CF-Talk
Subject: CF VS ASP


OK, I have been looking for some things on the net that shows the pros
and cons of CF as opposed to ASP. Knowing very little ASP myself, I do
not know the many differences. Anyone know where I can find this? Pretty
much looking for development time differences, execution speed, security
and scalability at a bare minimum. Anyone know where I can find this?

Rob








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

RE: Client Variable Database Storage

[Chris Montgomery]

Matt and Tony,

Thanks for the quick response. Your messages confirmed some of my
assumptions. Here's what my hosting company support had to say about it:

> Hi Chris, we create a DSN for each individual client who wants CV
> storage.  You could use either an AccessDB or an MSSQL db for this.  It
> is probably best to have an empty one, as the CF Administrator will
> create the tables necessary.  As you already have a DSN associated with
> this account an additional one would incur a $5/month charge.  You could
> avoid this charge by using your current database for CV storage, as the
> table names that are created are fairly unique.  However, do this at
> your own risk.  Please let us know if you have any further questions.

I think I will be able to work with just having them configure my already
existing datasource to store client vars. It's for a fairly small site and I
don't really expect lots of traffic.

Thanks again.

Chris Montgomery[EMAIL PROTECTED]

Airtight Web Services
Web Development, Web Project Management, Software Sales
Macromedia Sales & Consulting Partner
210-490-3249/888-745-7603

> -Original Message-
> From: Matt Robertson [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 1:28 PM
> To: CF-Talk
> Subject: RE: Client Variable Database Storage
>
>
> Chris,
>
> You can put your client vars in any dsn you like, so long as you specify
> that dsn as a client var repository in the CF Administrator.  If you've
> already created your tables, just leave the ''create tables'' choice
> unchecked when you do the above.
>
> This lets you specify multiple client var datasources, one for each
> client assuming each client has its own dsn.  You may or may not want to
> do that.  I used to but mostly don't anymore, preferring instead to
> keeping those w/generic needs in a server-wide db.  I have some clients
> whose expirations differ from the norm, so I break them out into their
> own db's.
>
> I'm not sure this is something you can really manage with a shared host.
> You'll have to ask them directly if they can set you up.
>
> --Matt Robertson--
> MSB Designs, Inc.
> http://mysecretbase.com
>

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

RE: CF VS ASP <- let the trolling being

[Rick Walters]

Honestly,

If he's willing to pay you to cross train in ASP, why complain?  I'm
assuming that you have already written a score of reports and tools that
will all need to be translated into ASP and who would know the reports
better than their author.  ASP isn't "that" different from Cold Fusion. 
Cold Fusion takes care of quite a few loose ends and takes far less time
to produce quick apps.  So, if your new boss is dead-set on using ASP
pick up a few "kill weight" manuals on ASP coding and rewrite one of
your tools.  

Remeber, coders survive on being able to code.  Managers survive on
making good business decisions.  You may well see a new manager in the
not so distant future.

Good Fortune,
Richard Walters,
Webmaster, Davita Laboratory Services
[EMAIL PROTECTED]
(800) 604-5227 x 3525

>>> [EMAIL PROTECTED] 04/03/02 02:36PM >>>
But I have made up my mind that if they kill Cold Fusion here I am not
staying here any longer. It is mostly because we have a new manager
that
seems to be such a die hard ASP fan who swears it is better then CF
even
though he does not even know anything about CF. A little annoying, but
I
think since he is not the one that is doing any of the coding, he
should
really go with what us developers are wanting to work with. Maybe I am
living in a dream like state when I think that managers will always
pick
the best product.



-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 11:28 AM
To: CF-Talk
Subject: Re: CF VS ASP <- let the trolling being

and on that note you should tell your boss there is a new version of
CF
comingall that can be
said here is WOW...wait for it...can you say coool
;-)

Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED] 
-
Macromedia Associate Partner
www.macromedia.com 
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com 

- Original Message -
From: "Robert Bailey" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 11:12 AM
Subject: RE: CF VS ASP <- let the trolling being


> Yeah, I thought this would get quite a bit of response, but I would
> really like the information to share with my current employer who
wants
> to move from CF to ASP and get rid of CF, which I do not want to do
at
> all, and I only know a little ASP, and from what I do know, I do not
> like it.
>
> Rob
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
> Sent: Wednesday, April 03, 2002 10:59 AM
> To: CF-Talk
> Subject: RE: CF VS ASP <- let the trolling being
>
> gentlemen (and ladies) start your engines
>
> Anthony Petruzzi
> Webmaster
> 954-321-4703
> http://www.sheriff.org 
>
>
> -Original Message-
> From: Robert Bailey [mailto:[EMAIL PROTECTED]] 
> Sent: Wednesday, April 03, 2002 2:03 PM
> To: CF-Talk
> Subject: CF VS ASP
>
>
> OK, I have been looking for some things on the net that shows the
pros
> and cons of CF as opposed to ASP. Knowing very little ASP myself, I
do
> not know the many differences. Anyone know where I can find this?
Pretty
> much looking for development time differences, execution speed,
security
> and scalability at a bare minimum. Anyone know where I can find
this?
>
> Rob
>
>
>
>
>
> 


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

RE: CF VS ASP <- let the trolling being

[Robert Bailey]

Here is a good URL that I came across:

http://hotwired.lycos.com/webmonkey/99/46/index1a.html?tw=programming



-Original Message-
From: Jerry Johnson [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 11:46 AM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being

Gasp, sputter, cough.

Blasphemy! Heretic! Unbeliever!

Nothing is better than perl.

My fondest dream would be to be able to write perl (and real regex)
within CF templates. And a good implementation of modperl within the CF
Server.


 -- don't I wish!


"Dreams I'll Never See" - (can you name that band?)
Jerry Johnson

>>> [EMAIL PROTECTED] 04/03/02 02:29PM >>>
Yeah, for sure, maybe some people need to get together and create that,
we use PHP here as well, my opinion of PHP is worse then ASP, not very
fond of it at all, but that is my opinion. Anything is better then PERL
anyways, heh

I think CF5 blows ASP out of the water, like comparing an old Married
with Children type of Dodge to a Corvette

Rob

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 11:14 AM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being

The only problem you have is that you are going to find alot of
information
comparing CF4.0 and ASP/IIS3.0. i would love to see a comparison
between
CF5.0, ASP/IIS5.0, and PHP4.

Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org 


-Original Message-
From: Robert Bailey [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 2:13 PM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being


Yeah, I thought this would get quite a bit of response, but I would
really like the information to share with my current employer who wants
to move from CF to ASP and get rid of CF, which I do not want to do at
all, and I only know a little ASP, and from what I do know, I do not
like it. 

Rob

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 10:59 AM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being

gentlemen (and ladies) start your engines

Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org 


-Original Message-
From: Robert Bailey [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 2:03 PM
To: CF-Talk
Subject: CF VS ASP


OK, I have been looking for some things on the net that shows the pros
and cons of CF as opposed to ASP. Knowing very little ASP myself, I do
not know the many differences. Anyone know where I can find this? Pretty
much looking for development time differences, execution speed, security
and scalability at a bare minimum. Anyone know where I can find this?

Rob









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

Re: CF VS ASP <- let the trolling being

[Bryan Stevenson]

Have you pointed out the rapid development nature of CF?  Talk their talk...faster 
development
translates to lower development/maintenance costs.  Talk like that usually grabs the 
suits attention
;-)

Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com

- Original Message -
From: "Robert Bailey" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 11:36 AM
Subject: RE: CF VS ASP <- let the trolling being


> But I have made up my mind that if they kill Cold Fusion here I am not
> staying here any longer. It is mostly because we have a new manager that
> seems to be such a die hard ASP fan who swears it is better then CF even
> though he does not even know anything about CF. A little annoying, but I
> think since he is not the one that is doing any of the coding, he should
> really go with what us developers are wanting to work with. Maybe I am
> living in a dream like state when I think that managers will always pick
> the best product.
>
>
>
> -Original Message-
> From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 11:28 AM
> To: CF-Talk
> Subject: Re: CF VS ASP <- let the trolling being
>
> and on that note you should tell your boss there is a new version of CF
> comingall that can be
> said here is WOW...wait for it...can you say coool
> ;-)
>
> Bryan Stevenson
> VP & Director of E-Commerce Development
> Electric Edge Systems Group Inc.
> p. 250.920.8830
> e. [EMAIL PROTECTED]
> -
> Macromedia Associate Partner
> www.macromedia.com
> -
> Vancouver Island ColdFusion Users Group
> Founder & Director
> www.cfug-vancouverisland.com
>
> - Original Message -
> From: "Robert Bailey" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, April 03, 2002 11:12 AM
> Subject: RE: CF VS ASP <- let the trolling being
>
>
> > Yeah, I thought this would get quite a bit of response, but I would
> > really like the information to share with my current employer who
> wants
> > to move from CF to ASP and get rid of CF, which I do not want to do at
> > all, and I only know a little ASP, and from what I do know, I do not
> > like it.
> >
> > Rob
> >
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, April 03, 2002 10:59 AM
> > To: CF-Talk
> > Subject: RE: CF VS ASP <- let the trolling being
> >
> > gentlemen (and ladies) start your engines
> >
> > Anthony Petruzzi
> > Webmaster
> > 954-321-4703
> > http://www.sheriff.org
> >
> >
> > -Original Message-
> > From: Robert Bailey [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, April 03, 2002 2:03 PM
> > To: CF-Talk
> > Subject: CF VS ASP
> >
> >
> > OK, I have been looking for some things on the net that shows the pros
> > and cons of CF as opposed to ASP. Knowing very little ASP myself, I do
> > not know the many differences. Anyone know where I can find this?
> Pretty
> > much looking for development time differences, execution speed,
> security
> > and scalability at a bare minimum. Anyone know where I can find this?
> >
> > Rob
> >
> >
> >
> >
> >
> >
>
> 
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: <<>> URL Var Passing Issue...Under the gun...again...!

[Houk, Gary]

Hi Jon,

I'm not sure that I completely understand your problem, but I'll take a
stab at it anyway ;-)

You should use the isdefined() function to make sure that the
values/variables exist. If they don't, then use 
to send them to the page where they should initially be defined. 

To continuously pass the form params through your series of pages, you
could do it through url vars
or through hidden form fields. Using hidden form fields will prevent the
user from tampering with
the data, which is what I prefer. Another method would be to use session
or client vars.

Also, make sure you always scope your variables: #url.myvariable#,
#variables.myvariable# and so on...

HTH!!!

- Gary

-Original Message-
From: CF_JONNY [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 10:58 AM
To: CF-Talk
Subject: <<>> URL Var Passing Issue...Under the gun...again...!


Newbie Question..

I need to pass 2 URL Vars to pre fill an insert form.

>From the Detail Page;

PreID and PreEM are form a display table that is generated from the same
URL.PreID passed from a master page.

add Extra info

The next Insert Form;

Do I need to do an IsDefined() to get the passed VARs to pre fill 2 of
the 3
fields?
I need 2 to be filled and one to be blank for input.  The need to be
filled
so the person can keep track of what he is doing.




  



Any suggestions???

Thanks

JON



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

RE: CF VS ASP <- let the trolling being

[Robert Bailey]

The new PERL sounds promising, and I would agree that it would be great
to use modperl within CF, I started as a PERL developer.

But if I had a choice to develop a program in CF or PERL, I would pick
CF

But that is my opinion, which only matters when I am home alone

Rob

-Original Message-
From: Jerry Johnson [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 11:46 AM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being

Gasp, sputter, cough.

Blasphemy! Heretic! Unbeliever!

Nothing is better than perl.

My fondest dream would be to be able to write perl (and real regex)
within CF templates. And a good implementation of modperl within the CF
Server.


 -- don't I wish!


"Dreams I'll Never See" - (can you name that band?)
Jerry Johnson

>>> [EMAIL PROTECTED] 04/03/02 02:29PM >>>
Yeah, for sure, maybe some people need to get together and create that,
we use PHP here as well, my opinion of PHP is worse then ASP, not very
fond of it at all, but that is my opinion. Anything is better then PERL
anyways, heh

I think CF5 blows ASP out of the water, like comparing an old Married
with Children type of Dodge to a Corvette

Rob

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 11:14 AM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being

The only problem you have is that you are going to find alot of
information
comparing CF4.0 and ASP/IIS3.0. i would love to see a comparison
between
CF5.0, ASP/IIS5.0, and PHP4.

Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org 


-Original Message-
From: Robert Bailey [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 2:13 PM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being


Yeah, I thought this would get quite a bit of response, but I would
really like the information to share with my current employer who wants
to move from CF to ASP and get rid of CF, which I do not want to do at
all, and I only know a little ASP, and from what I do know, I do not
like it. 

Rob

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 10:59 AM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being

gentlemen (and ladies) start your engines

Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org 


-Original Message-
From: Robert Bailey [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 2:03 PM
To: CF-Talk
Subject: CF VS ASP


OK, I have been looking for some things on the net that shows the pros
and cons of CF as opposed to ASP. Knowing very little ASP myself, I do
not know the many differences. Anyone know where I can find this? Pretty
much looking for development time differences, execution speed, security
and scalability at a bare minimum. Anyone know where I can find this?

Rob









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

RE: CF VS ASP <- let the trolling being

[Neil Giarratana]

I'm sure a lot of people on this list are former ASP'ers.  As one of them, I
can tell you that life does not have to be that hard.  Does he have specific
"ASP is better" arguments?  At our MMUG meeting yesterday, there was an
ASP'er who was seeing how to connect to a database in CF for the first time.
I talked to him afterward and he said that we kept asking himself "where's
the rest of the code?" until he figured out that there wasn't any...

Regards,
Neil

-Original Message-
From: Robert Bailey [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 2:37 PM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being


But I have made up my mind that if they kill Cold Fusion here I am not
staying here any longer. It is mostly because we have a new manager that
seems to be such a die hard ASP fan who swears it is better then CF even
though he does not even know anything about CF. A little annoying, but I
think since he is not the one that is doing any of the coding, he should
really go with what us developers are wanting to work with. Maybe I am
living in a dream like state when I think that managers will always pick
the best product.



-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 11:28 AM
To: CF-Talk
Subject: Re: CF VS ASP <- let the trolling being

and on that note you should tell your boss there is a new version of CF
comingall that can be
said here is WOW...wait for it...can you say coool
;-)

Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com

- Original Message -
From: "Robert Bailey" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 11:12 AM
Subject: RE: CF VS ASP <- let the trolling being


> Yeah, I thought this would get quite a bit of response, but I would
> really like the information to share with my current employer who
wants
> to move from CF to ASP and get rid of CF, which I do not want to do at
> all, and I only know a little ASP, and from what I do know, I do not
> like it.
>
> Rob
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 10:59 AM
> To: CF-Talk
> Subject: RE: CF VS ASP <- let the trolling being
>
> gentlemen (and ladies) start your engines
>
> Anthony Petruzzi
> Webmaster
> 954-321-4703
> http://www.sheriff.org
>
>
> -Original Message-
> From: Robert Bailey [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 2:03 PM
> To: CF-Talk
> Subject: CF VS ASP
>
>
> OK, I have been looking for some things on the net that shows the pros
> and cons of CF as opposed to ASP. Knowing very little ASP myself, I do
> not know the many differences. Anyone know where I can find this?
Pretty
> much looking for development time differences, execution speed,
security
> and scalability at a bare minimum. Anyone know where I can find this?
>
> Rob
>
>
>
>
>
> 


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

RE: CF VS ASP <- let the trolling being

[Greg Jordan]

here is an article from pcmagazine comparing a slew of web applications
servers/languages...

http://www.pcmag.com/article/0,2997,s=1611&a=3125,00.asp

The real question for me would be WHY ON EARTH would your current employer
switch to ASP if you don't have any experience with it and they are
currently using CF.  Have they not seen the NEO faq?  Or is this one of
those "mandate" thingys?

-Original Message-
From: Robert Bailey [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 1:13 PM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being


Yeah, I thought this would get quite a bit of response, but I would
really like the information to share with my current employer who wants
to move from CF to ASP and get rid of CF, which I do not want to do at
all, and I only know a little ASP, and from what I do know, I do not
like it.

Rob

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 10:59 AM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being

gentlemen (and ladies) start your engines

Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org


-Original Message-
From: Robert Bailey [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 2:03 PM
To: CF-Talk
Subject: CF VS ASP


OK, I have been looking for some things on the net that shows the pros
and cons of CF as opposed to ASP. Knowing very little ASP myself, I do
not know the many differences. Anyone know where I can find this? Pretty
much looking for development time differences, execution speed, security
and scalability at a bare minimum. Anyone know where I can find this?

Rob






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

Re: multiple file uploads

[Paul Giesenhagen]

Not using appletFile, but have used  it does a very nice job
of handling multiple files .. you can find it in the tag gallery at
Macromedia.

Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector v2.0 - Commerce Builder



> any comments or suggestions for multiple file upload widgets? anybody
using
> xxxactiveFile its late, i actually meant appletFile.
>
> thanks
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.342 / Virus Database: 189 - Release Date: 3/14/2002
>
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF VS ASP <- let the trolling being

[Jerry Johnson]

Gasp, sputter, cough.

Blasphemy! Heretic! Unbeliever!

Nothing is better than perl.

My fondest dream would be to be able to write perl (and real regex) within CF 
templates. And a good implementation of modperl within the CF Server.


 -- don't I wish!


"Dreams I'll Never See" - (can you name that band?)
Jerry Johnson

>>> [EMAIL PROTECTED] 04/03/02 02:29PM >>>
Yeah, for sure, maybe some people need to get together and create that,
we use PHP here as well, my opinion of PHP is worse then ASP, not very
fond of it at all, but that is my opinion. Anything is better then PERL
anyways, heh

I think CF5 blows ASP out of the water, like comparing an old Married
with Children type of Dodge to a Corvette

Rob

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 11:14 AM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being

The only problem you have is that you are going to find alot of
information
comparing CF4.0 and ASP/IIS3.0. i would love to see a comparison
between
CF5.0, ASP/IIS5.0, and PHP4.

Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org 


-Original Message-
From: Robert Bailey [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 2:13 PM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being


Yeah, I thought this would get quite a bit of response, but I would
really like the information to share with my current employer who wants
to move from CF to ASP and get rid of CF, which I do not want to do at
all, and I only know a little ASP, and from what I do know, I do not
like it. 

Rob

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 10:59 AM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being

gentlemen (and ladies) start your engines

Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org 


-Original Message-
From: Robert Bailey [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 2:03 PM
To: CF-Talk
Subject: CF VS ASP


OK, I have been looking for some things on the net that shows the pros
and cons of CF as opposed to ASP. Knowing very little ASP myself, I do
not know the many differences. Anyone know where I can find this? Pretty
much looking for development time differences, execution speed, security
and scalability at a bare minimum. Anyone know where I can find this?

Rob








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

multiple file uploads

[Paul Hastings]

any comments or suggestions for multiple file upload widgets? anybody using 
xxxactiveFile its late, i actually meant appletFile.

thanks


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.342 / Virus Database: 189 - Release Date: 3/14/2002

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

RE: CF VS ASP <- let the trolling being

[Robert Bailey]

But I have made up my mind that if they kill Cold Fusion here I am not
staying here any longer. It is mostly because we have a new manager that
seems to be such a die hard ASP fan who swears it is better then CF even
though he does not even know anything about CF. A little annoying, but I
think since he is not the one that is doing any of the coding, he should
really go with what us developers are wanting to work with. Maybe I am
living in a dream like state when I think that managers will always pick
the best product.



-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 03, 2002 11:28 AM
To: CF-Talk
Subject: Re: CF VS ASP <- let the trolling being

and on that note you should tell your boss there is a new version of CF
comingall that can be
said here is WOW...wait for it...can you say coool
;-)

Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com

- Original Message -
From: "Robert Bailey" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 11:12 AM
Subject: RE: CF VS ASP <- let the trolling being


> Yeah, I thought this would get quite a bit of response, but I would
> really like the information to share with my current employer who
wants
> to move from CF to ASP and get rid of CF, which I do not want to do at
> all, and I only know a little ASP, and from what I do know, I do not
> like it.
>
> Rob
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 10:59 AM
> To: CF-Talk
> Subject: RE: CF VS ASP <- let the trolling being
>
> gentlemen (and ladies) start your engines
>
> Anthony Petruzzi
> Webmaster
> 954-321-4703
> http://www.sheriff.org
>
>
> -Original Message-
> From: Robert Bailey [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 2:03 PM
> To: CF-Talk
> Subject: CF VS ASP
>
>
> OK, I have been looking for some things on the net that shows the pros
> and cons of CF as opposed to ASP. Knowing very little ASP myself, I do
> not know the many differences. Anyone know where I can find this?
Pretty
> much looking for development time differences, execution speed,
security
> and scalability at a bare minimum. Anyone know where I can find this?
>
> Rob
>
>
>
>
>
> 

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

multiple file uploads

[Paul Hastings]

any comments or suggestions for multiple file upload widgets? anybody using 
activeFile?


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.342 / Virus Database: 189 - Release Date: 3/14/2002

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

RE: CF VS ASP <- let the trolling being

[Mark Broner]

Forgot the link:
http://techupdate.zdnet.com/techupdate/stories/main/0,14179,2646052,00.html

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 12:14 PM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being


The only problem you have is that you are going to find alot of information
comparing CF4.0 and ASP/IIS3.0. i would love to see a comparison  between
CF5.0, ASP/IIS5.0, and PHP4.

Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org


-Original Message-
From: Robert Bailey [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 2:13 PM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being


Yeah, I thought this would get quite a bit of response, but I would
really like the information to share with my current employer who wants
to move from CF to ASP and get rid of CF, which I do not want to do at
all, and I only know a little ASP, and from what I do know, I do not
like it.

Rob

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 10:59 AM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being

gentlemen (and ladies) start your engines

Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org


-Original Message-
From: Robert Bailey [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 2:03 PM
To: CF-Talk
Subject: CF VS ASP


OK, I have been looking for some things on the net that shows the pros
and cons of CF as opposed to ASP. Knowing very little ASP myself, I do
not know the many differences. Anyone know where I can find this? Pretty
much looking for development time differences, execution speed, security
and scalability at a bare minimum. Anyone know where I can find this?

Rob







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

RE: CF VS ASP <- let the trolling being

[Mark Broner]

Well there is this article by eweek that is probably the most recent
comparison you are going to get.  CF 4.5.1, ASP 5.0 PHP 4, Tomcat 3.2,
And they give CF the nod.  While still saying different tools for different
jobs, might make sense.  So we can only conjecture that they would have
given CF 5.0 higher marks, since it has better performace.



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 12:14 PM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being


The only problem you have is that you are going to find alot of information
comparing CF4.0 and ASP/IIS3.0. i would love to see a comparison  between
CF5.0, ASP/IIS5.0, and PHP4.

Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org


-Original Message-
From: Robert Bailey [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 2:13 PM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being


Yeah, I thought this would get quite a bit of response, but I would
really like the information to share with my current employer who wants
to move from CF to ASP and get rid of CF, which I do not want to do at
all, and I only know a little ASP, and from what I do know, I do not
like it.

Rob

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 10:59 AM
To: CF-Talk
Subject: RE: CF VS ASP <- let the trolling being

gentlemen (and ladies) start your engines

Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org


-Original Message-
From: Robert Bailey [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 2:03 PM
To: CF-Talk
Subject: CF VS ASP


OK, I have been looking for some things on the net that shows the pros
and cons of CF as opposed to ASP. Knowing very little ASP myself, I do
not know the many differences. Anyone know where I can find this? Pretty
much looking for development time differences, execution speed, security
and scalability at a bare minimum. Anyone know where I can find this?

Rob







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