RE: Issue and Risk Management System

2005-07-25 Thread Mark Smyth
Hi

Its Prince2 specific, but it will cover what you need

http://www.fortes.nl/projectmanagement/prince2-tools.php

Regards
Mark 

-Original Message-
From: Andy [mailto:[EMAIL PROTECTED] 
Sent: 25 July 2005 15:16
To: CF-Talk
Subject: Issue and Risk Management System

Does anyone know where I can find an Issue and Risk Tracking/Management
System?  





~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212733
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Import/Export for PostgreSQL

2005-06-01 Thread Mark Smyth
I've used some of these before, very good and easy to setup/use
http://www.sqlmanager.net/products/postgresql

Not free, but you do get a free trial

Hth
mark 

-Original Message-
From: George Abraham [mailto:[EMAIL PROTECTED] 
Sent: 01 June 2005 14:51
To: CF-Talk
Subject: OT: Import/Export for PostgreSQL

All,
Anyone have a suggestion for a (preferably free) Import/Export tool for
PostgreSQL? I have to import/export from MS SQL Server and using MS' DTS
does not seem to be working due to this bug:
http://gborg.postgresql.org/project/psqlodbc/bugs/bugupdate.php?944

Thanks,
George



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208193
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Import/Export for PostgreSQL

2005-06-01 Thread Mark Smyth
Yeah just relaised,

But if dts is the problem, dts to csv or access (for example), then the
import tools will work fine 

-Original Message-
From: George Abraham [mailto:[EMAIL PROTECTED] 
Sent: 01 June 2005 15:23
To: CF-Talk
Subject: Re: Import/Export for PostgreSQL

Mark,
Thanks for the suggestion, but none of them seem to have anything for SQL
Server.

George

On 6/1/05, Mark Smyth [EMAIL PROTECTED] wrote:
 I've used some of these before, very good and easy to setup/use 
 http://www.sqlmanager.net/products/postgresql
 
 Not free, but you do get a free trial
 
 Hth
 mark
 
 -Original Message-
 From: George Abraham [mailto:[EMAIL PROTECTED]
 Sent: 01 June 2005 14:51
 To: CF-Talk
 Subject: OT: Import/Export for PostgreSQL
 
 All,
 Anyone have a suggestion for a (preferably free) Import/Export tool 
 for PostgreSQL? I have to import/export from MS SQL Server and using 
 MS' DTS does not seem to be working due to this bug:
 http://gborg.postgresql.org/project/psqlodbc/bugs/bugupdate.php?944
 
 Thanks,
 George
 
 
 
 



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208206
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: (SOT) Joins aren't always better than subqueries (longish post)

2005-05-31 Thread Mark Smyth
Just a comment, there's often a similar time deficit with using SQL joins on
Ingres.

-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED] 
Sent: 31 May 2005 10:59
To: CF-Talk
Subject: (SOT) Joins aren't always better than subqueries (longish post)

It is common for best practices docs to advise that we should use a join in
preference to a subquery wherever possible, since the subquery prevents the
DB from creating the execution plan it could with a join.
This is probably quite true most of the time. However I just discovered a
situation (in Oracle at least) where joins hobbled my query so badly that a
query that should have taken milliseconds took minutes; using an aggregate
function in a query that needed to return joined info.

I'll simplify my situation: say I have the following table for scores in a
unit of study:

tblscore - scoreid, score, personid, unitid

and it is joined to a tblperson table and a tblunit table in the obvious
way. Now I want to sum the scores across all people in the given unit, so I
do this:

SELECT SUM(score) AS totalscore
FROM tblscore
GROUP BY unitid

No problems so far. Great, but I now need to return the unit name in the
above query, so using a join I do this:

SELECT SUM(tblscore.score) AS totalscore, tblunit.unitname FROM tblscore,
tblunit WHERE tblscore.unitid = tblunit.unitid GROUP BY tblunit.unitname

(yeah yeah, I know, use ANSI join syntax - I'm an Oracle user, so sue me).

This is necessary because you must either group or aggregate on anything
returned by the query. The end result performs like a dog in a situation
where there are in fact three more joins to other tables. I presume this is
because to figure out the grouping for the sum the join result has to be
returned and it messes up the aggregate's performance.

Oracle's subqueries to the rescue:

SELECT SUM(score) AS totalscore, (SELECT unitname FROM tblunit WHERE
tblunit.unitid = s.unitid) AS unitname FROM tblscore s GROUP BY unitid

This performs many times better than the group on the join, when there are
actually four joins to perform.

Anyone more intimate with the inner dark secrets of SQL is welcome to
comment.






~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208011
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: DatePart problem

2005-05-31 Thread Mark Smyth
Hi 

Try this, create a new date using dateformat, based on your existing date.
cfset tmpdate = dayformat(varName, dd/mm/)

Then run datepart on tmpDate

I haven't tested it, but it should provide a workaround

-Original Message-
From: Mark Henderson [mailto:[EMAIL PROTECTED] 
Sent: 31 May 2005 11:07
To: CF-Talk
Subject: DatePart problem

I want to extract the month from a date that is in the format dd/m/, so
I've tried using DatePart (access is the database format). The problem I
have is that, by default, DatePart always seems to presume the entry is in
the m/dd/ format and thus, it's setting the month from the day (where
possible).

An example: from 12/02/2005 (12th February 2005) DatePart will select the 12
as the month. From 25/02/2005, it obviously works correctly, due to a lack
of alternatives.

Actually, my situation is slightly more complicated in that this is actually
used to submit events to a calendar table in the database. 
Start_date is currently in the above mentioned dd/m/ format and that is
the way I wish to keep things (to save confusion for those submitting). So
my question  - can this be achieved, and if so, how...any ideas?

A worst case scenario means I will just have to alter the form thats
entered, but this (DatePart) is something I might like to use in the future,
so I figured I would ask. All help appreciated.

TIA
Mark



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208012
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: I truly hate Ben Forta

2005-05-11 Thread Mark Smyth
I'm with Neil on this.

I have bought the CFWACK since 4.5, but I will not be buying version 7 

If I need to find out something its, 
1. CF Docs
2. Google
3. CF lists


-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED] 
Sent: 11 May 2005 14:24
To: CF-Talk
Subject: Re: I truly hate Ben Forta

Fair enough.  I still like having a nice bound reference nearby, but to each
their own.  BTW, I know I can print and bind the docs, but another benefit
to having Ben's book (with other authors now, let's not forget Ray Camden,
et al) are the little pearls of wisdom that are in there. 
The docs are just so cold, IMO.

Robertson-Ravo, Neil (RX) wrote:
 Yeah, I do, I think the docs have come on leaps n bounds since CF 4.5 
 though the internet and the explosion of Blogs allows you to learn at 
 a quicker and cheaper rate than with CWACK.
 
 
 
 
 
 -Original Message-
 From: Ray Champagne [mailto:[EMAIL PROTECTED]
 Sent: 11 May 2005 14:16
 To: CF-Talk
 Subject: Re: I truly hate Ben Forta
 
 What?  r u serious?
 
 Robertson-Ravo, Neil (RX) wrote:
 
Q. Why on earth do you need these books now?  The CF Docs are more 
than enoughif not better.



-Original Message-
From: Rey Bango [mailto:[EMAIL PROTECTED]
Sent: 11 May 2005 14:00
To: CF-Talk
Subject: I truly hate Ben Forta

Thats right! I said it!! I hate the man! I hate him because everytime 
a
 
 new
 
version of CF comes out, I find myself TOTALLY plunking down $55 for 
his
 
 new
 
revised version of CFWACK!! He is sucking my bank account dry! Dryer 
than the Sahara I tell you.

I hate you, Ben.

Rey...

PS: Of course, this message is all in jest and I don't actually hate 
Ben; well, maybe a little. Great books Ben. Keep up the great work bud.





 
 
 
 
 



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206348
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Excel sheet datasource in CFMX7

2005-05-06 Thread Mark Smyth
Couldn't you in theory use a excel JDBC driver instead of the ODBC/ODBC
socket route?  

Have a look at https://xlsql.dev.java.net/

I have never tried it personally but it would be well  worth investigating

hth
Mark

PS If all else fails you can also fallback on asp/vb etc, which although
painful do work well with Excel via ODBC

 

-Original Message-
From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED] 
Sent: 06 May 2005 08:47
To: CF-Talk
Subject: Re: Excel sheet datasource in CFMX7

It won't work by going in to CFAdmin, hitting Datasources, setting the New
Datasource Type popup to ODBC and configuring it with the DSN of your
OS-based ODBC DSN?

I guess I hadn't considered that the ODBC connector from within CFAdmin was
dependent on the ODBC agent... if you've tried it and it doesn't work, I
can't think of a workaround right off the top of my head...

I'll give it some more thought, though...

J

On 5/6/05, Duncan [EMAIL PROTECTED] wrote:
 
 Ok I get where you are coming from and I would think that if the CF 
 ODBC agent was installed and running it would probably work.
 
 Unfortunately this server doesnt have the CF odbc agent. Any other 
 ways around this without installing the odbc agent?
 
 
 On 5/6/05, Jared Rypka-Hauer - CMG, LLC [EMAIL PROTECTED] wrote:
  After setting up the OS-based ODBC datasource, you WILL need to go 
  into
 CF
  Admin and create a CFMX DSN that points to your ODBC DSN by name, 
  and
 supply
  the appropriate (if necessary) credentials.
 
  That is, you create an ODBC DSN via the Windows Control Panel and 
  after
 that
  a CF Administrator DSN that points to the original ODBC DSN. It's
 confusing
  until you do it once. Don't hesitate to ask further questions. :)
 
  Laterz,
  J
 



--
---
-
Buy SQLSurveyor!
http://www.web-relevant.com/sqlsurveyor
Never make your developers open Enterprise Manager again.




~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205827
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: macromedia and Adobe?!

2005-04-18 Thread Mark Smyth
That's got to be on their hitlist, must break the MM developers hearts 

-Original Message-
From: Adam Haskell [mailto:[EMAIL PROTECTED] 
Sent: 18 April 2005 11:59
To: CF-Talk
Subject: Re: macromedia and Adobe?!

Great say goodbye to flash paper...

Adam H

On 4/18/05, Stephen Moretti (cfmaster) [EMAIL PROTECTED] wrote:
 Thomas Chiverton wrote:
 
 Incidentally, it looks more like a takeover of MM by Adobe, looking 
 at the board make-up etc.
 
 PDF FAQ  http://snipurl.com/abodemacromediaFAQ
 
 
 



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203182
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: macromedia and Adobe?!

2005-04-18 Thread Mark Smyth
I, like many others miss allaire

Soon it'll be redirecting to Adobe

-Original Message-
From: Dawson, Michael [mailto:[EMAIL PROTECTED] 
Sent: 18 April 2005 17:14
To: CF-Talk
Subject: RE: macromedia and Adobe?!

Well, Adobe is easier to type than Macromedia. 

-Original Message-
From: Jack Dalaa [mailto:[EMAIL PROTECTED]
Sent: Monday, April 18, 2005 4:26 AM
To: CF-Talk
Subject: Re: macromedia and Adobe?!

Wow, this is just totally surreal. Had a complete out-of-body experience
there for a few minutes. The perspectives and consequences are just
mind-boggling.. And not necessarily all bad. 

Adobe ColdFusion
Adobe JRun
Adobe Flex
Adobe Dreamweaver

.. Heh. The thought makes my head spin. I wonder what it will mean for
CF.

Wild stuff.


Jack





~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203303
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: macromedia and Adobe?!

2005-04-18 Thread Mark Smyth
for what reason connie? 

-Original Message-
From: Connie DeCinko [mailto:[EMAIL PROTECTED] 
Sent: 18 April 2005 17:48
To: CF-Talk
Subject: RE: macromedia and Adobe?!

I think he was just looking for an excuse, any excuse to ditch CF.  Now he
thinks he has it.


-Original Message-
From: dave [mailto:[EMAIL PROTECTED] 

Over half a day of speculation?
 How did he become boss? A prize from a cracker jacks box?


From: Kerry [EMAIL PROTECTED]

Well, my boss is nervous about CF now, looks like we're moving to a pure
Java environment...






~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203331
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Locking shared scope variables

2005-03-30 Thread Mark Smyth
I'm trying to standardise a locking strategy when setting/reading shared
scope variables
 
I've did some research and came up with what I thought was a plan,
exclusive-scoped locks for writing variables and readonly-scoped locks for
reading variables.
 
However I crossrefered this against the Macromedia CFMX coding standards and
it has the following:
 
If the shared resource is in server or application scope, you should use
named locks to control access - and choose a name that uniquely identifies
the resource being locked, e.g., use server_varname when locking an update
to server.varname

If the shared resource is in session scope, you should generally use a
scoped lock on session itself.

AND

most read operations do not need to be locked;

 

This is the first time I have come across this, so two questions come from
this:

1. Why named locks for application  server variables and scope for session?

2. Why can read locks  be ignored?

 

I'd be greatful for opinions

Thanks

Mark



~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200673
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Locking shared scope variables

2005-03-30 Thread Mark Smyth
Hi Dave 

Thanks for that.  

Makes sense about the named locks, but why are scoped locks recommeded for
session variables?

And  most read operations do not need to be locked;  now makes sense.
It was the exceptions to the rule I couldn't get my head around.

Regards
Mark 

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: 30 March 2005 14:11
To: CF-Talk
Subject: RE: Locking shared scope variables

 I'm trying to standardise a locking strategy when setting/reading 
 shared scope variables
  
 I've did some research and came up with what I thought was a plan, 
 exclusive-scoped locks for writing variables and readonly-scoped locks 
 for reading variables.
  
 However I crossrefered this against the Macromedia CFMX coding 
 standards and it has the following:
  
 If the shared resource is in server or application scope, you should 
 use named locks to control access - and choose a name that uniquely 
 identifies the resource being locked, e.g., use server_varname when 
 locking an update to server.varname
 
 If the shared resource is in session scope, you should generally use a 
 scoped lock on session itself.
 
 AND
 
 most read operations do not need to be locked;
 
 This is the first time I have come across this, so two questions come 
 from this:
 
 1. Why named locks for application  server variables and scope for 
 session?
 
 2. Why can read locks be ignored?

It's worth pointing out that the MM coding standards probably assume the use
of CFMX, and that locking requirements and best practices have changed
between CF 5 and CFMX.

Named locks allow more granularity than scope locks. You're less likely to
have unnecessary lock contention, and you're still able to synchronize
access to the variable in question.

If you write a variable once, and simply read it afterwards, which is a
common thing to do with Application variables, there's very little
likelihood that there will be any cases where a write is occurring at the
same time as another operation - which of course is what you want to prevent
with locking. Multiple concurrent reads are harmless as long as there's no
write going on simultaneously.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized instruction
at our training centers in Washington DC, Atlanta, Chicago, Baltimore,
Northern Virginia, or on-site at your location. 
Visit http://training.figleaf.com/ for more information!




~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200680
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Locking shared scope variables

2005-03-30 Thread Mark Smyth
I probably should've added that I based my initial findings on a CFMX tech
note
http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18235

Which appears to come to the conclusion that although named locks give
greater granularity, It is often simpler to continue using the scope
attribute 

I'm just really curious as to why a different approach is suggested in the
Coding doc dependant on variable scope.

Regards
Mark

-Original Message-
From: Mark Smyth [mailto:[EMAIL PROTECTED] 
Sent: 30 March 2005 14:14
To: CF-Talk
Subject: RE: Locking shared scope variables

Hi Dave 

Thanks for that.  

Makes sense about the named locks, but why are scoped locks recommeded for
session variables?

And  most read operations do not need to be locked;  now makes sense.
It was the exceptions to the rule I couldn't get my head around.

Regards
Mark 

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: 30 March 2005 14:11
To: CF-Talk
Subject: RE: Locking shared scope variables

 I'm trying to standardise a locking strategy when setting/reading 
 shared scope variables
  
 I've did some research and came up with what I thought was a plan, 
 exclusive-scoped locks for writing variables and readonly-scoped locks 
 for reading variables.
  
 However I crossrefered this against the Macromedia CFMX coding 
 standards and it has the following:
  
 If the shared resource is in server or application scope, you should 
 use named locks to control access - and choose a name that uniquely 
 identifies the resource being locked, e.g., use server_varname when 
 locking an update to server.varname
 
 If the shared resource is in session scope, you should generally use a 
 scoped lock on session itself.
 
 AND
 
 most read operations do not need to be locked;
 
 This is the first time I have come across this, so two questions come 
 from this:
 
 1. Why named locks for application  server variables and scope for 
 session?
 
 2. Why can read locks be ignored?

It's worth pointing out that the MM coding standards probably assume the use
of CFMX, and that locking requirements and best practices have changed
between CF 5 and CFMX.

Named locks allow more granularity than scope locks. You're less likely to
have unnecessary lock contention, and you're still able to synchronize
access to the variable in question.

If you write a variable once, and simply read it afterwards, which is a
common thing to do with Application variables, there's very little
likelihood that there will be any cases where a write is occurring at the
same time as another operation - which of course is what you want to prevent
with locking. Multiple concurrent reads are harmless as long as there's no
write going on simultaneously.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized instruction
at our training centers in Washington DC, Atlanta, Chicago, Baltimore,
Northern Virginia, or on-site at your location. 
Visit http://training.figleaf.com/ for more information!






~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200682
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Locking shared scope variables

2005-03-30 Thread Mark Smyth
Have a look a the tech note below.

Basically it doesn't crash the server like in the good old days, but there
are still issues with potential race conditons

http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18235

Regards
Mark

-Original Message-
From: Connie DeCinko [mailto:[EMAIL PROTECTED] 
Sent: 30 March 2005 14:22
To: CF-Talk
Subject: RE: Locking shared scope variables

I thought with CFMX7 we did not need to worry about locks.


-Original Message-
From: Mark Smyth [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 30, 2005 6:53 AM
To: CF-Talk
Subject: Locking shared scope variables

I'm trying to standardise a locking strategy when setting/reading shared
scope variables
 
I've did some research and came up with what I thought was a plan,
exclusive-scoped locks for writing variables and readonly-scoped locks for
reading variables.
 
However I crossrefered this against the Macromedia CFMX coding standards and
it has the following:
 
If the shared resource is in server or application scope, you should use
named locks to control access - and choose a name that uniquely identifies
the resource being locked, e.g., use server_varname when locking an update
to server.varname

If the shared resource is in session scope, you should generally use a
scoped lock on session itself.

AND

most read operations do not need to be locked;

 

This is the first time I have come across this, so two questions come from
this:

1. Why named locks for application  server variables and scope for session?

2. Why can read locks  be ignored?

 

I'd be greatful for opinions

Thanks

Mark







~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200690
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Graphic Manipulation in Coldfusion question.

2005-03-30 Thread Mark Smyth
Hi Jeff
I may well be missing something, but wouldn't you be better off doing this
using flash or even an animated gif? 
Mark
-Original Message-
From: Jeff Waris [mailto:[EMAIL PROTECTED] 
Sent: 30 March 2005 15:25
To: CF-Talk
Subject: Graphic Manipulation in Coldfusion question.

Here is what I need to do, hopefully someone out there has done something
close. I need to remove (or not display) the bottom 30 or so pixels of a
JPEG file and then display it to the user. Can this be done on the fly?
Using what? I am running CFMX6.1, so a solution would need to be compatible.


Thanks!
Jeff




~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200706
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Setting validation order when validating via CFINPUT

2005-03-02 Thread Mark Smyth
Hi 

Since cfform is simply creating javascript validation on the fly, you could
do the following:

View the source in the page, you'll see that cfform creates a javascript
method which is then called via a form onsubmit tag.

Basically you could take that javascript and HTML source (you only need the
form and the javascript), put it in a cfm or html page and it'll still work
fine.

Once it'll directly in the page, you can change the validation order within
the method as you like.

A bit around the houses but it'll work.  Otherwise of course you could
always write the validation yourself :)

hth
Mark





-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: 02 March 2005 07:41
To: CF-Talk
Subject: Setting validation order when validating via CFINPUT

Hi, does anyone know how to set the validation order, when doing validation
with CFINPUT inside CFFORM?

I have 5 fields.

The first at top of form is FIRSTNAME.

Then LAST NAME.

The last is ZIPCODE.

But Cold Fusion tries to validate zipcode first arbitrarily, then another
field, but in no particular order.

This is a pain in the ass and looks unprofessional. Obviously you want to
ask for the first field before the person can move onto the next one.

Does anyone know how to pull this off, so it asks for FIRSTNAME info first,
then LAST NAME then ZIPCODE?




~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197082
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Cold Fusion Gettin Hot?

2005-03-02 Thread Mark Smyth
Even sean connery if cf'ing

http://www.seanconnery.com/index.cfm 

-Original Message-
From: Chuck Mason [mailto:[EMAIL PROTECTED] 
Sent: 02 March 2005 16:34
To: CF-Talk
Subject: Re: Cold Fusion Gettin Hot?

HA!!  After submitting this email -- checked my webmail account at
Roadrunner and Bam ... they're using CF too (nice use of Flash and CF):
http://www.rr.com/flash/index.cfm


Chuck Mason wrote:

I've been noticing a LOT of high-vis sites using Cold Fusion lately ... 
so couldn't help but putting my comments here ... is CF on the take 
w/regard to increased company awareness?  The last company I worked for 
shunned Cold Fusion (said any monkey could learn it, and they are 
engineers with loyalty to the Microsoft Empire by golley, so DotNet is 
their game plan) -- but now I notice the CTO's bio has Cold Fusion 
listed as the first language that they use (even though they don't have 
anyone on staff that knows CF), followed by DotNet, etc..  Funny ...

Some high-vis Sites I've recently taken notice of that use CF are:

   1. Logitech.com
   2. FedEX.com
   3. Solarwinds.net (good site for you net-admin guys/gals)
   4. Techsoup.org

Others I can't think of now too.  I have this habit of looking at the 
status bar and/or address bar to see what extensions are being used and 
-- have seen .cfm a LOT lately. 

Keep carrying the torch Macromedia, New Atlanta, Fusebox, Plum, OnTap, 
and others ...

All the best!
Chuck





~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197117
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Excel Lock Issue

2005-02-17 Thread Mark Smyth
Hi Chaps could use some advice here.  Coldfusion 6.1.

The scenario is a user uploads an excel spreadsheet which then needs to be
imported into SQL Server.

I've set up an ODBC connection to the uploaded spreadsheet (it'll be the
same name, same location every time) and then a odbc socket in the
administrator as per:
http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18656

Now this all works fine, but its maintaining the lock on the spreadsheet
after the page has finished processing,  which will make it impossible to
upload a new one.  The only way I have found a way round it so far is to
restart the ODBC server service (or cfmx service), which is not really
workable.

I've tried everything I though might work, for example:
run a query against a non existant query/datasource to try and relase the
lock (like the old access lock workaround)
ran a query against another spreadsheet via a different odbc socket to try
to release the query.
Tried the purgeQueryCache() and [disable] methods of the datasource
factory.

But no luck, its still maintaining the lock

any ideas?

thanks
mark

 

 

Mark Smyth

Certified Advanced ColdFusion MX Developer





~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195168
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Excel Lock Issue

2005-02-17 Thread Mark Smyth
Hi Pete

This did come up, but its all about ease of use for the people who are going
to be using the spreasheet (non techies).

If worse comes to worse I'll fall back on that option

Many Thanks
Mark

-Original Message-
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] 
Sent: 17 February 2005 15:41
To: CF-Talk
Subject: Re: Excel Lock Issue

Probably less elegant than you are looking for, and certainly not an answer
to your problem, but having the users upload a .csv file and then using
cffile to read the contents to a variable and then loop through that to
insert into SQL Server might also work.

Pete


On Thu, 17 Feb 2005 15:24:19 -, Mark Smyth [EMAIL PROTECTED]
wrote:
 Hi Chaps could use some advice here.  Coldfusion 6.1.
 
 The scenario is a user uploads an excel spreadsheet which then needs 
 to be imported into SQL Server.
 
 I've set up an ODBC connection to the uploaded spreadsheet (it'll be 
 the same name, same location every time) and then a odbc socket in the 
 administrator as per:
 http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18656
 
 Now this all works fine, but its maintaining the lock on the 
 spreadsheet after the page has finished processing,  which will make 
 it impossible to upload a new one.  The only way I have found a way 
 round it so far is to restart the ODBC server service (or cfmx 
 service), which is not really workable.
 
 I've tried everything I though might work, for example:
 run a query against a non existant query/datasource to try and relase 
 the lock (like the old access lock workaround) ran a query against 
 another spreadsheet via a different odbc socket to try to release the 
 query.
 Tried the purgeQueryCache() and [disable] methods of the datasource 
 factory.
 
 But no luck, its still maintaining the lock
 
 any ideas?
 
 thanks
 mark
 
 Mark Smyth
 
 Certified Advanced ColdFusion MX Developer
 
 



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195180
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Excel Lock Issue

2005-02-17 Thread Mark Smyth
Hi 

Found out what it was it was the Maintain connections across client
requests.  being checked in the advanced datasource settings.

Cheers again for the advo!

mark

-Original Message-
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] 
Sent: 17 February 2005 16:47
To: CF-Talk
Subject: Re: Excel Lock Issue

You might want to look at a COM solution (try cfcomet for examples, though
it doesn't look like it's been updated for a while) for converting .XLS
files to .CSV files on the server, without user interaction.

Pete


On Thu, 17 Feb 2005 15:46:58 -, Mark Smyth [EMAIL PROTECTED]
wrote:
 Hi Pete
 
 This did come up, but its all about ease of use for the people who are 
 going to be using the spreasheet (non techies).
 
 If worse comes to worse I'll fall back on that option
 
 Many Thanks
 Mark
 
 -Original Message-
 From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]
 Sent: 17 February 2005 15:41
 To: CF-Talk
 Subject: Re: Excel Lock Issue
 
 Probably less elegant than you are looking for, and certainly not an 
 answer to your problem, but having the users upload a .csv file and 
 then using cffile to read the contents to a variable and then loop 
 through that to insert into SQL Server might also work.
 
 Pete
 
 On Thu, 17 Feb 2005 15:24:19 -, Mark Smyth 
 [EMAIL PROTECTED]
 wrote:
  Hi Chaps could use some advice here.  Coldfusion 6.1.
 
  The scenario is a user uploads an excel spreadsheet which then needs 
  to be imported into SQL Server.
 
  I've set up an ODBC connection to the uploaded spreadsheet (it'll be 
  the same name, same location every time) and then a odbc socket in 
  the administrator as per:
  http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_1865
  6
 
  Now this all works fine, but its maintaining the lock on the 
  spreadsheet after the page has finished processing,  which will make 
  it impossible to upload a new one.  The only way I have found a way 
  round it so far is to restart the ODBC server service (or cfmx 
  service), which is not really workable.
 
  I've tried everything I though might work, for example:
  run a query against a non existant query/datasource to try and 
  relase the lock (like the old access lock workaround) ran a query 
  against another spreadsheet via a different odbc socket to try to 
  release the query.
  Tried the purgeQueryCache() and [disable] methods of the 
  datasource factory.
 
  But no luck, its still maintaining the lock
 
  any ideas?
 
  thanks
  mark
 
  Mark Smyth
 
  Certified Advanced ColdFusion MX Developer
 
 
 
 



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195208
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: CF Hosting

2005-02-16 Thread Mark Smyth
I'd recommend

http://www.cfmxhosting.co.uk/

Reasonably priced with excellent support etc and a top notch control panel!

-Original Message-
From: dave [mailto:[EMAIL PROTECTED] 
Sent: 16 February 2005 10:12
To: CF-Talk
Subject: re: CF Hosting

not too mention the user control panels are top notch plus now smartermail 
smarterstats, its a good package :)


From: Andy Jarrett [EMAIL PROTECTED]
Sent: Wednesday, February 16, 2005 5:00 AM
To: CF-Talk cf-talk@houseoffusion.com
Subject: CF Hosting 

Hi there,

I've just came across Viux (www.vuix.com) for CF hosting and was wondering
if anyone is using them or has used them?

Im already with CrystalTech, but was thinking of getting another domain w/
hosting for a friend and for CF they seemed too cheap. Their Starter Plan
(http://hosting.viux.com/webhosting/plan-starter.asp)
starts at $55.84 yearly with

Microsoft Windows Server 2003
Web Hosting Control Panel
Internet Information Services (IIS 6 | .htm) ColdFusion MX v6.1 (CFML |
..cfm) ...NET Framework v1.1 (ASP.Net | .aspx) Active Server Pages (ASP |
..asp) VBScript / JScript PHP v4.3.10 (.php) ActivePerl v5.8.3 Build 809
(Perl / CGI | .pl  .cgi) Private CGI-Bin Directory Server Side Includes
24 / 7 / 365 Unlimited FTP Updates
Password Protected Directories (IISPassword / .htaccess) Custom 404 / Error
Pages Domain Pointers: (4) Sub (Conical) Domains: (4)

Plus loads of other stuff? 

Cheers

Andy
www.andyjarrett.co.uk





~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194915
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Suggestions for writing a calendar app

2005-02-08 Thread Mark Smyth
This could be handy (depending on the type of calender you want) if you want
to record events etc

http://www.infusiontechnology.com/web/products/handler.cfm?event=ProductView
Changedproduct=calendarInfusion

Theres a free open source version and its cfc based
hth
mark
-Original Message-
From: Damien McKenna [mailto:[EMAIL PROTECTED] 
Sent: 08 February 2005 16:59
To: CF-Talk
Subject: Suggestions for writing a calendar app

I need to write calendaring functionality into an existing system and was
wondering if anyone had suggestions for CFCs or UDFs that might help?
Thanks.
 
--
Damien McKenna - Web Developer - [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
The Limu Company - http://www.thelimucompany.com/
http://www.thelimucompany.com/  - 407-804-1014 #include stdjoke.h
 




~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193663
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: ASP help

2005-01-05 Thread Mark Smyth
Here goes, but you're just bound to get a few comments

If you need more help, I would consider joining an ASP list

% if var1 =  then
response.write(variable does not exist)
else
response.write(variable exists)
end if%

Test it by setting the variable before the if statement (as so)
dim var1
var1 = test

Hth

Mark


-Original Message-
From: Asim Manzur [mailto:[EMAIL PROTECTED] 
Sent: 05 January 2005 14:17
To: CF-Talk
Subject: ASP help

could someone please tell me the following code in ASP???

Thanks once again.


CFIF IsDefined(pid)

do this

cfelseif IsDefined(jid)

do this

cfif



~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189375
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: upgrade site from FB2 to FB2

2005-01-04 Thread Mark Smyth
Hi 

For mach-ii sample code, go to http://www.mach-ii.com/code.cfm

There are some sample apps to choose from, which are open source.

Just out of interest anyone know if there are any performance benefit (or
otherwise) in using mach ii over fusebox 4?

Regards
Mark



-Original Message-
From: Troy Murray [mailto:[EMAIL PROTECTED] 
Sent: 04 January 2005 14:16
To: CF-Talk
Subject: Re: upgrade site from FB2 to FB2

I know that at
http://www.fusebox.org/downloads/index.cfm?method=Fusebox4.download
there is a FB Demo app that has FB3 and FB4 code to compare.  I wasn't using
FB in version 2, I started in version 3, but perhaps the comparison of the
FB3 and FB4 would give you a rough idea.

-t



On Tue, 4 Jan 2005 08:29:08 -0500, Katz, Dov B (IT)
[EMAIL PROTECTED] wrote:
 Does anyone have any advice on updating a FB2 site to the later 
 versions of fusebox?
 
 In particular, I'm interested in the additional request overhead (or 
 improvement in response time) related to such a change...
 
 Does someone have an sample code in both fb2 and mach-ii/fb4 etc which 
 I could compare the code
 
 I'm trying to determine whether a change is justified in my app.
 
 Thanks
 -dov
 
 
 NOTICE: If received in error, please destroy and notify sender.  Sender
does not waive confidentiality or privilege, and use is prohibited.
 
 



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189231
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Can't Signin

2004-12-14 Thread Mark Smyth
I Signed in today OK, but it did pop up a few alert boxes

Mark

-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED] 
Sent: 14 December 2004 17:13
To: CF-Talk
Subject: RE: Can't Signin

I'll check it out. I made some changes last night and it looked good, but...
 
 I get the form showing up but I don't seem to be able to log in
 
 -Original Message-
 From: Michael Dinowitz [mailto:[EMAIL PROTECTED]
 Sent: Monday, December 13, 2004 12:18 PM
 To: CF-Talk
 Subject: RE: Can't Signin
 
 
 Try it now. The issue was one of naming. I used a variable called method
 to
 indicate what page to load into a multi-page interface. Method in CFMX (or
 at least in 7) is reserved to indicate the page method. This caused the
 variable to be loaded with get in each page run. I've fixed it for the
 sign
 in and will do so for any other location I find. This will be replaced
 with
 more up to date and tighter code as soon as I get another free second.
 Sorry for the inconvenience.
 
 
  I don't know something is wrong with the website. I can't signin.
  There is no text boxes there to put the username/password there.
 
  Whenever  I go there it just have a link says Back to previous section
 
  Is anthing wrong with houseoffusion website?
  --
  Regards,
 
 
 
 
 
 



~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187577
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


FW: Job in UK

2004-09-13 Thread Mark Smyth
 Sent on behalf of the employer - Do not reply to me pls
 
 
 Required, full-time junior ColdFusion developer local to
 Hillsea/Portsmouth in the UK.
 This is a fairly junior position, so you don't need to be a coldfusion
 guru.
 Main requires are are ColdFusion5 with Transact SQL(ability to write
 complex inner/outer joins for SQL server), DHTML/_javascript_, with the
 ability to work on existing projects and understand/adapt other developers
 code.
 The job will be primarily remote working from home for one of our clients
 in portsmouth with some onsite work when required. Occasional requirements
 to visit head office in Berkshire.
 for more details Contact : Russ Michaels (russ.michaels @ satachi.com)
 Tel: 0870 747 3709
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




RE: Referencing a variable in a database

2002-11-07 Thread Mark Smyth
use evaluate?

-Original Message-
From: Russ [mailto:russ;unrealisticexpectations.com]
Sent: 07 November 2002 07:55
To: CF-Talk
Subject: Referencing a variable in a database


All,

I've got an oddity that I'm not certain how to overcome.

I have an extranet system that I use a database to store content for
pages--most specifically to store locations of a client's files.

However, when I add code of
cfoutput#qClients.clientDirectory#/cfoutput/image1.jpg to the
database, it doesn't display correctly--it instead shows the code.

Because of that, I can't imagine that HTMLCodeFormat would work--tested
it, it doesn't, unless I'm not using it correctly.

As with all things, I'm sure there's a way to do this, but I'm not close
to it at all.

Does anyone have any thoughts?

Thanks,

Russ


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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



RE: Thank you, Macromedia!

2002-10-31 Thread Mark Smyth
Ill leave it.  Judith and Micheal do a great job

-Original Message-
From: Bryan Stevenson [mailto:bryan;electricedgesystems.com]
Sent: 31 October 2002 17:02
To: CF-Talk
Subject: Re: Thank you, Macromedia!


There's banning going on about OT posts.  One specific topic that is even
getting it's own list is Macromedia related talk.  Now theMistress of the
House posts to Thank Macromedia!!!

I'm not usually too challenging on this list, but is the pot calling the
kettle black or what!!!

Practice what you preach or there is NO CHANCE anyone will take you
seriously.

I NEVER whine about OT posts either (because I'm a big boy and I can just
hit delete), but it's been like watching a bunch of freakin children
latelyeverybody involved including the moderators...GET A GRIP!!

my 2 cents...take it of leave it...I'm done

Bryan Stevenson B.Comm.
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 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: Judith Dinowitz [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, October 30, 2002 10:20 PM
Subject: OT: Thank you, Macromedia!


 I was very impressed with Macromedia's responsiveness and attentiveness to
the community at Devcon. When we had a small problem with the Flash
Communications Server, Vernon Viehe, the ColdFusion Community Manager at
Macromedia, stepped in and got us some Macromedia tech support to help solve
the problem. Without their help, and without Vernon (and Jochem, of course),
we would not been able to broadcast our Suite program out to other community
members.

 I also heard that Macromedia had several people sitting in on Ben Forta's
Devcon gripe session, listening attentively and taking notes on what people
were saying. I hope that the community recognizes that Macromedia has
listened to their concern about not being attentive, and are changing.

 Judith Dinowitz
 Mistress of the House
 House of Fusion

 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



RE: Installing Tomcat 4

2002-10-03 Thread Mark Smyth

run the exe and once done check the tomcat service is running (if you're opn
windows)

then you should be able to browse http://localhost:8080 which will provide
the local tomcat docs

hth

mark

-Original Message-
From: Stephen Moretti [mailto:[EMAIL PROTECTED]]
Sent: 03 October 2002 13:59
To: CF-Talk
Subject: Re: Installing Tomcat 4


http://jakarta.apache.org/tomcat/

There's a pointer for you ;o)

- Original Message -
From: Robertson-Ravo, Neil (REC) [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 1:44 PM
Subject: Installing Tomcat 4


 I know this is not CF related, but we are using Tomcat for one of our
 application features; thing is, do any of you guys know the process of
 installing it?  I have Tomcat 4.x binary files which have been delivered
to
 me as a .zip archive.  I extracted these and I have the Tomcat.exe etc and
 whole host of .bat files..

 Anyone got any pointers.

 Neil
 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com



RE: Installing Tomcat 4

2002-10-03 Thread Mark Smyth

is that the technical term? ;)

-Original Message-
From: Robertson-Ravo, Neil (REC)
[mailto:[EMAIL PROTECTED]]
Sent: 03 October 2002 14:13
To: CF-Talk
Subject: RE: Installing Tomcat 4


ah it doesnt matter, turns out its a piece of piss :-)

-Original Message-
From: Robertson-Ravo, Neil (REC)
[mailto:[EMAIL PROTECTED]]
Sent: 03 October 2002 14:10
To: CF-Talk
Subject: RE: Installing Tomcat 4


there isnt an .exe installer, only binaries

-Original Message-
From: Mark Smyth [mailto:[EMAIL PROTECTED]]
Sent: 03 October 2002 14:01
To: CF-Talk
Subject: RE: Installing Tomcat 4


run the exe and once done check the tomcat service is running (if you're opn
windows)

then you should be able to browse http://localhost:8080 which will provide
the local tomcat docs

hth

mark

-Original Message-
From: Stephen Moretti [mailto:[EMAIL PROTECTED]]
Sent: 03 October 2002 13:59
To: CF-Talk
Subject: Re: Installing Tomcat 4


http://jakarta.apache.org/tomcat/

There's a pointer for you ;o)

- Original Message -
From: Robertson-Ravo, Neil (REC) [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 1:44 PM
Subject: Installing Tomcat 4


 I know this is not CF related, but we are using Tomcat for one of our
 application features; thing is, do any of you guys know the process of
 installing it?  I have Tomcat 4.x binary files which have been delivered
to
 me as a .zip archive.  I extracted these and I have the Tomcat.exe etc and
 whole host of .bat files..

 Anyone got any pointers.

 Neil
 




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



RE: Eron Cohen, please email me!

2002-10-01 Thread Mark Smyth

yes, do it again and we'll report you to the list admin :)

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 01 October 2002 15:21
To: CF-Talk
Subject: OT: Eron Cohen, please email me!


My apologies for the cross-post and my use of the list for this purpose.

Judith Dinowitz
Editor
Fusion Authority
http://www.fusionauthority.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: Two tables same column name?

2002-09-24 Thread Mark Smyth

hi john 
try aliasing the value you want to pull out, there is a way which will
negate the need to name all the columns you want to select, but I can't
remember it off the top of my head.  The code below should work, let me kow
if you have any problems

Mark

cfquery name=getRep
   datasource=#session.datasource#
   dbserver=#session.dbserver#
  SELECT b.total, d.total AS second_total
  FROM trip_flow_breakdown b, trip_flow_data d
  WHERE b.wid = #attributes.wid# AND b.fid = #attributes.fid# AND b.id = 
#attributes.id#
  AND d.wid = #attributes.wid# AND d.fid = #attributes.fid#
/cfquery

cfoutput#getRep.second_total#/cfoutput

-Original Message-
From: John Gedeon [mailto:[EMAIL PROTECTED]]
Sent: 24 September 2002 01:21
To: CF-Talk
Subject: Two tables same column name?


I have a query where i join two tables. and both tables have a field which 
are titled the same but each table has a different value. is there a way 
for pulling the two different values out in cold fusion or do i have to use 
multiple selects??

cfquery name=getRep
   datasource=#session.datasource#
   dbserver=#session.dbserver#
  SELECT *
  FROM trip_flow_breakdown b, trip_flow_data d
  WHERE b.wid = #attributes.wid# AND b.fid = #attributes.fid# AND b.id = 
#attributes.id#
  AND d.wid = #attributes.wid# AND d.fid = #attributes.fid#
/cfquery

   the field i want to get is total but if i use
  cfoutput query=getRep#total#/cfoutput i only get the value of the 
first table in the from clause. any one have a solution?

 Proverbs 3:5 Trust in the Lord with all your heart and lean not on 
your own understanding;


__
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



REGEX

2002-08-15 Thread Mark Smyth

 Anyone got a regex hanging around which would search a comma delimited
 file e.g.
 
 1,f,g,h,4,56,lk,lk,re,tr,yt,,2,3,4,er,re,tr,
 
 locate text within the speech marks and replace the commas with another
 character (e.g ¬), thereby producing
 
 1,f,g,h,4,56,lk¬k¬re¬tr¬yt,2,3,4,er¬re¬tr¬
 
 many thanks
 Mark
 
 Mark Smyth
 Systems Union eBusiness Solutions
 01865 880800
 www.systemsunion.net
 
 
__
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: REGEX

2002-08-15 Thread Mark Smyth

good thinking that man

thanks

-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]]
Sent: 15 August 2002 14:18
To: CF-Talk
Subject: RE: REGEX


I don't think you need a regex, although it might be faster.

Using double quotes as the delimiter, all the even numbered elements will be
the ones you want to convert. Grab these then replace all the commas.

Ade

-Original Message-
From: Mark Smyth [mailto:[EMAIL PROTECTED]]
Sent: 15 August 2002 14:02
To: CF-Talk
Subject: REGEX


 Anyone got a regex hanging around which would search a comma delimited
 file e.g.
 
 1,f,g,h,4,56,lk,lk,re,tr,yt,,2,3,4,er,re,tr,
 
 locate text within the speech marks and replace the commas with another
 character (e.g ¬), thereby producing
 
 1,f,g,h,4,56,lk¬k¬re¬tr¬yt,2,3,4,er¬re¬tr¬
 
 many thanks
 Mark
 
 Mark Smyth
 Systems Union eBusiness Solutions
 01865 880800
 www.systemsunion.net
 
 


__
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: Problem building a comma separated list.

2002-08-14 Thread Mark Smyth

go for listappend()

-Original Message-
From: Adams, Stephen [mailto:[EMAIL PROTECTED]]
Sent: 14 August 2002 10:31
To: CF-Talk
Subject: Problem building a comma separated list.


**
WESTMINSTER CITY COUNCIL
Please refer to the disclaimer beneath this message
**

Hi,

I am trying to build a comma separated list of ID number, something I have
done many times before, but for some reason this code does not seem to be
working. Here is my code:


cfparam name=EmailIDList default=

cflock timeout=30 throwontimeout=No type=EXCLUSIVE scope=SESSION
  cfloop query=getEmails
cfset EmailIDList = EmailIDList  #ID#  ,
  /cfloop
  cfset session.EmailIDList = #EmailIDList#  
/cflock

I know it is a bit of a no-brainer, but can anyone tell me where I am going
wrong?

Stephen


**
Westminster City Council switchboard: 
+44 20 7641 6000
**
This E-Mail may contain information which is 
privileged, confidential and protected from 
disclosure.  If you are not the intended recipient 
of this E-mail or any part of it, please telephone 
Westminster City Council immediately on receipt.
You should not disclose the contents to any other 
person or take copies.
**


__
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: Calling CFM file from an HTML page

2002-08-14 Thread Mark Smyth

you could change the IIS mappings to do this

-Original Message-
From: Thane Sherrington [mailto:[EMAIL PROTECTED]]
Sent: 14 August 2002 17:10
To: CF-Talk
Subject: Calling CFM file from an HTML page


Is it possible to include a .cfm file in a .htm page?  I have an .htm page 
on a non-CF server and I want to call a cfm page from a CF server.  Short 
of a frame on the .htm page, is there a way to do this?  Javascript perhaps?

T


__
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



Affino 2.0

2002-07-31 Thread Mark Smyth

 Anyone come across the Affino content managment system from emojo
 (www.emojo.com)?
 
 I'd be very interested to hear opinions
 
 Thanks
 Mark
 
 Mark Smyth
 Systems Union eBusiness Solutions
 01865 880800
 www.systemsunion.net
 
 
__
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: ColdFusion based message Forum ?

2002-07-31 Thread Mark Smyth

simplemessagboards is very very developer friendly

-Original Message-
From: Eric Hoffman [mailto:[EMAIL PROTECTED]]
Sent: 31 July 2002 17:30
To: CF-Talk
Subject: RE: ColdFusion based message Forum ?


Simple Message Board  (SMB) we've used and hacked up with great
success  www.simplemessageboard.com and we have it running
thankfully on our SQL server.

For a good pay one, check out www.quilldesign.com ...decent features and
a good price! Super easy to implement...wow.

Regards,

Eric J Hoffman
Head Tech Geek
DataStream Connexion
www.datastreamconnexion.com
Delivering Creative Data Solutions 

-Original Message-
From: Vishal Narayan [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, July 31, 2002 3:17 AM
To: CF-Talk
Subject: ColdFusion based message Forum ?


Can anybody recommend a good freeware message forum written purely in 
ColdFusion ? It should be possible to integrate it with a SQL 2000 DB.

Has anyone evaluated or is using FuseTalk (http://www.e-zonemedia.com/)
? 
Any comments ?

Vishal



__
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's Most Wanted ::

2002-04-22 Thread Mark Smyth

Raymond
There will _always_ be
a need for logical type locks.

why will there always be a need for using cflock with session variables.
Should they manage muliple access automatically?

And if there is a need for cflock, why doesn't client vars use them?

Mark
-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: 22 April 2002 15:18
To: CF-Talk
Subject: RE: CF's Most Wanted ::


 Abilty to resize images on the fly, store in cache, read 
 dimensions, etc.
 (should be a cinch with Macromedia's expertise in graphic 
 products [yea, right])

There are plenty of CFX tags out there that do this. I'm not saying we
shouldn't do it - just that solutions exist already. :)

 locking:
 Needs to protect the server. Period.

Sure - the answer is to use locking - but I'm assuming your saying that
we _shouldnt_ need locking for server stability. There will _always_ be
a need for logical type locks.


 cfdirectory:
 Please just give us one more attribute (filesonly=True, 
 or type=file) or update filter to accept type=file or 
 type=dir.  Those directory dots irk me 99% of the time I 
 use the tag.

Hey, just use startrow=3 when looping. ;)

 c# support:
 I'm not even sure this is a possilbilty and it's probably 
 a little early to call for it, but something to think about.

Um - you mean writing C#? Why? That's like asking for Perl support. Why
not just use perl.exe?


 NOTE: I'm also aware that some some of these things may 
 already be alleviated or improved upon in NEO.  For all the 
 Beta testers and PDA hounds out there, please do not jump in 
 on this discussion and say That's already developed and 
 then the subsequent You're not allowed to say that and then 
 I have to say Please keep this discussion in a pre-NEO 
 context etc, etc.  So, I'll go ahead and say that now, 
 please keep this discussion to pre-NEO improvements.  
 Although NEO is on it's way, please just submit features you 
 have thought and dreamt about prior to NEO, and future releases.

Neo, what's Neo? :)

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

Email: [EMAIL PROTECTED]
Yahoo IM : morpheus

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


__
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



Structure Sorting

2002-04-04 Thread Mark Smyth

Hi

I'm looping over a list e.g. (D, C, B, A) and inserting into a structure
as follows:

cfset list=D,B,C,A
cfset struct= structnew()
cfloop index=i list=#list# delimiters=,
cfscript
StructInsert(struct, i,);
/cfscript
/cfloop

but when I ouput the structure, it is sorted alphabetically by key.  

cfloop collection=#struct# item=i
cfoutput#i# #struct[i]#br/cfoutput
/cfloop

So the above code would output:
A
B
C
D

Instead of what i want which is (The same order the elements were in the
original list)
D
B
C
A

Anyone know any way to keep the output order the same as the input order or
are they always automatically sorted?
Thanks
Mark
Mark Smyth 
Developer 
SystemsUnion.Net
00 44 1865 880800 
[EMAIL PROTECTED] 
www.systemsunion.net

__
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: Structure Sorting

2002-04-04 Thread Mark Smyth

i know in theory they are not ordered, so how come its ordering
automatically in alphabetical asending order when the key is a string?

mark

-Original Message-
From: Pascal Peters [mailto:[EMAIL PROTECTED]]
Sent: 04 April 2002 10:33
To: CF-Talk
Subject: RE: Structure Sorting


Structures are NOT ordered and there is no way of keeping them oredered. If
you want an order, use an array.

Pascal

-Original Message-
From: Mark Smyth [mailto:[EMAIL PROTECTED]]
Sent: donderdag 4 april 2002 11:18
To: CF-Talk
Subject: Structure Sorting


Hi

I'm looping over a list e.g. (D, C, B, A) and inserting into a structure
as follows:

cfset list=D,B,C,A
cfset struct= structnew()
cfloop index=i list=#list# delimiters=,
cfscript
StructInsert(struct, i,);
/cfscript
/cfloop

but when I ouput the structure, it is sorted alphabetically by key.  

cfloop collection=#struct# item=i
cfoutput#i# #struct[i]#br/cfoutput
/cfloop

So the above code would output:
A
B
C
D

Instead of what i want which is (The same order the elements were in the
original list)
D
B
C
A

Anyone know any way to keep the output order the same as the input order or
are they always automatically sorted?
Thanks
Mark
Mark Smyth 
Developer 
SystemsUnion.Net
00 44 1865 880800 
[EMAIL PROTECTED] 
www.systemsunion.net



__
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: Structure Sorting

2002-04-04 Thread Mark Smyth

heres what i'm trying to do

The app i'm building has to integrate with staffware (a workflow program),
it does this through a coded text file
e.g.
CHPART_DISC,50%
COLLAB, Y
CP_IADMN, N

Theres around 220 elements in total, all elements must be present in the
textfile even if the values are blank. As the user progresses through the
app, his selections are recorded in a structure (with the structure keys
representing the staffware code, as above).  Depending on the
process/selections of the user the content of the structure at the end will
change.  
e.g. he might only have
CHPART_DISC,50%
COLLAB, Y

I have a textfile listing all the required files which i have stored in a
structure with all the values blank, basically cause i wanted to use the
structure functions. At the end to make sure the structure has the required
content, I loop over the example structure adding the blank values where
necessary.
e.g. from the above example he would end up with
CHPART_DISC,50%
COLLAB,Y
CP_IADMN*,

*repeated per required field

The possible problem i'm looking at is that the example provided is not
aplhabetically sorted but the textfile i produced by looping over my
finished structure as writing to a textfile always is (unless i write it
individually per key, all 200+ !!).


I'm testing the textfile input later today, so i was just hoping there might
be a way to stop the structure alphabetically sorting, just in case
staffware needs the textfile to be in the same order

hope that explains it a bit better

Mark

-Original Message-
From: Stephen Moretti [mailto:[EMAIL PROTECTED]]
Sent: 04 April 2002 11:07
To: CF-Talk
Subject: Re: Structure Sorting


 Of course, coldfusion has to loop over the keys a certain way. It does it
alphabetically,
 but that is just the way it is done. If they do it some other way in MX,
you can't complain
 because structures are NOT oredered.


Pascal.  why does Coldfusion have to loop over the keys in a certain way?
The easiest way would be to display them in the order that they are entered
into the structure, not going out of its way to order them alphabetically,
which, incidentally, is exactly what its doing.

I just had a play with Mark's code and for whatever reason, whether you
return the key list, cfdump the struct variable or loop through the
collection, the list of keys always returns in alphabetic order.

Mark,
It shouldn't really matter what order the keys are returned in, because
that's only a reference to the contents the key is storing.  If the keys
(D, C, B, A) are actually the content then I suspect you may be getting
the wrong end of the stick with structures and, as Pascal says, you probably
should be using arrays.

Hope that helps

Regards

Stephen



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



RE: web server for XP home?

2002-03-27 Thread Mark Smyth

to be honest craig its probably because most people are familiar with IIS,
but apache sounds good to me

-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]]
Sent: 27 March 2002 09:11
To: CF-Talk
Subject: RE: web server for XP home?


What ???

XPHOME is NOT, I repeat, NOT based on Windows98

It is based on the same NT core as XP Pro and Windows 2k before that.

Btw, Apache runs like a DREAM on xp, it's free, easy to set up (if you can
read instructions correctly), it has a smaller memory footprint than IIS and
theoretically is more secure as well, so WHY on earth would you want IIS? 

-Original Message-
From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, March 26, 2002 11:18 PM
To: CF-Talk
Subject: RE: web server for XP home?

Yes.

XP Home = Windows 9x.
XP Pro = NTx/2K Workstation.
NET = NTx/2000 Server

That's it.

-- 
SCOTT VAN VLIET 
SENIOR ANALYST 
SBC SERVICES, INC 
Tel: 858.886.3878 
Fax: 858.653.6763 
Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 




-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 2:48 PM
To: CF-Talk
Subject: RE: web server for XP home?


you cannot join a domain with XP Home? Are you sure about this? 

On Tue, 26 Mar 2002, Tyler M. Fitch wrote:

 Robert,
 
 I'm chiming in here after the storm has settled, but I'd like to add a
 feature between XP Home and XP Pro that you get for your $100.
 
 The ability to join a domain.
 
 If you're at home and you're just you then save the $100 and get XP
 Home, run Apache for the webserver.  It will work.  If you're in a
 corporate environment or you have a nice home network with an actual
 domain not just a workgroup then you'll want XP Pro.
 
 Cheers,
 
 t
 
 **
 Tyler M. Fitch
 Certified Advanced ColdFusion 5 Developer
 http://isitedesign.com
 ** 
 
 -Original Message-
 From: Robert Everland [mailto:[EMAIL PROTECTED]] 
 Sent: Tuesday, March 26, 2002 8:40 AM
 To: CF-Talk
 Subject: RE: web server for XP home?
 
 
   Well then why not just not install it. I see what you're saying
 about security, but if they are a home user and they don't need it, they
 probably wouldn't even know how to install it. It sucks that when I want
 a new computer now, I will have get professional and pay $100 just to
 get IIS.
 
 Robert Everland III
 Dixon Ticonderoga
 Web Developer Extraordinaire
 
 -Original Message-
 From: Dave Watts [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, March 26, 2002 11:42 AM
 To: CF-Talk
 Subject: RE: web server for XP home?
 
 
  I do find it unforgiveable that Microsoft didn't include IIS
  in XP Home, it is very shortsighted on their part.
 
 I feel exactly the opposite. I think it would be unforgivable if
 Microsoft put a web server in a home OS. If you want to run a web
 server, you can always get one, but the vast majority of home users -
 and end-users in general - neither need to run a web server nor want to.
 Nor would they understand the potential security implications of doing
 so.
 
 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 voice: (202) 797-5496
 fax: (202) 797-5444
 
 
 
 



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



RE: web server for XP home?

2002-03-26 Thread Mark Smyth

now, i'm having the same problem.  Apache seems the best ption at the moment

but, a few days ago i foung something like this on the microsoft site (you
need professional to run a web server on XP, but please note to do not need
a dedicated web server to develop OR HOST a website )

I just tried to find it again but couldn't, anyone know what they are on
about?

-Original Message-
From: Ed Gordon [mailto:[EMAIL PROTECTED]]
Sent: 26 March 2002 05:29
To: CF-Talk
Subject: web server for XP home?


I just bought a laptop and we are discussing development (like at the
park/beach/pool ;-)  )  but I read somewhere that Personal Web Server won't
run under XP.

I don't really want to upgrade it to XP Pro to use IIS, and I tried two
free web servers - when I click on the CF Administrator, analog X web
server software somehow goes into a file download dialogue of 127.0.0.1;
Savant 3.0 just serves up a screen full of trash...

Do you know of a fix to either of these problems, or a decent web server to
try? Preferably one with a trial period, I would like to buy before I try...


TIA

Ed Gordon
CF Developer

FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.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: kill session aka Logout page

2002-03-25 Thread Mark Smyth

there you go, just stick this in your application.cfm

cfif IsDefined( Cookie.CFID ) AND IsDefined( Cookie.CFTOKEN )
  cfset localCFID = Cookie.CFID
  cfset localCFTOKEN = Cookie.CFTOKEN
  cfcookie name=CFID value=#localCFID#
  cfcookie name=CFTOKEN value=#localCFTOKEN#
/cfif

-Original Message-
From: YC Nyon [mailto:[EMAIL PROTECTED]]
Sent: 25 March 2002 14:10
To: CF-Talk
Subject: kill session aka Logout page


hi,

anyone mind to share the code to do a logout page where the session is
terminated.

thanks
Nyon


__
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: Testing Software

2002-03-25 Thread Mark Smyth

i'm no expert, but heres a couple of links
http://www.leb.net/vmac/

http://www.pona.net/basilisk/


-Original Message-
From: Smith, Daron [PA] [mailto:[EMAIL PROTECTED]]
Sent: 25 March 2002 14:21
To: CF-Talk
Subject: Testing Software


Does anyone know of any software like vmware that will allow for Mac
emulation.  From what I understand vmware does not, but does anyone know of
another that does?

Thanks,

Daron J. Smith
Web Developer
PSEA

[EMAIL PROTECTED]
717-255-7141 
1-800-944-PSEA (7732) x 7141
Please note new email address (old one with 'mail' will soon expire)

 
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
__
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: session without cookies - why/how does this work?

2002-02-25 Thread Mark Smyth

Hi

Probably you've set setclientcookies to yes previously, and they are 
still
being used.  setclientcookies does not tell CF not to use cookies if 
they
exist, simply not to set them.

Put this code into your application cfm to kill the cookies when you 
close
the browser and then try the same thing again

cfif IsDefined( Cookie.CFID ) AND IsDefined( Cookie.CFTOKEN )
  cfset localCFID = Cookie.CFID
  cfset localCFTOKEN = Cookie.CFTOKEN
  cfcookie name=CFID value=#localCFID#
  cfcookie name=CFTOKEN value=#localCFTOKEN#
/cfif

hth 

mark

Mark Smyth 
Developer 
SUeBS 
00 44 1865 880800 
[EMAIL PROTECTED] 
www.systemsunion.net


-Original Message-
From: Bimal Shah [mailto:[EMAIL PROTECTED]]
Sent: 25 February 2002 12:18
To: CF-Talk
Subject: session without cookies - why/how does this work?


Hello

I have an Application.cfm page with the following:

cfapplication name=sessiontest sessionmanagement=Yes
setclientcookies=No

And two cf pages:

page1.cfm

cfset session.name = tom.smith

page2.cfm

cfoutput#session.name#/cfoutput

In the browser, I type in http://mywebserver/page1.cfm and
then type in http://mywebserver/page2.cfm and it displays
tom.smith.

Why/how does this work when I have set setclientcookies to
No and I am not passing CFID,CFTOKEN (since I am typing in
the URLS directly - no url or form variables being sent)?

Bimal Shah
Senior Web developer | Venus Internet Ltd | www.venus.co.uk
e: [EMAIL PROTECTED] | t: 0207 240 5858 | f: 0207 240 5859

__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.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 Vars expiring? When?

2002-02-11 Thread Mark Smyth

hi

this  code will expire the client variables when the browser closes

hth
mark

cfif IsDefined( Cookie.CFID ) AND IsDefined( Cookie.CFTOKEN )
  cfset localCFID = Cookie.CFID
  cfset localCFTOKEN = Cookie.CFTOKEN
  cfcookie name=CFID value=#localCFID#
  cfcookie name=CFTOKEN value=#localCFTOKEN#
/cfif

-Original Message-
From: Andrew Scott [mailto:[EMAIL PROTECTED]]
Sent: 11 February 2002 07:00
To: CF-Talk
Subject: RE: Client Vars expiring? When? 


Mike,

Are you sure that you are expiring the CFID  CFToken each and every
time in the application.cfm template. I posted code in the CF Aussie
mailing list that will do what you want it to do.


-Original Message-
From: Mike Kear [mailto:[EMAIL PROTECTED]] 
Sent: Monday, 11 February 2002 4:40 PM
To: CF-Talk
Subject: Client Vars expiring? When? 

I thought that client variables were extinguished every time the 
browser
was
closed.   Perhaps I was wrong with this.

I am developing an access control app using client vars and when I 
close
the
browser and open it again, I am still logged in and can just go direct
to my
protected page.   When I open a totally different browser (e.g.
netscape4.7
instead of IE5,) I am sent to the login page as I expected, so part of
the
system is working ok.

Do client vars expire when the browser is closed? Or do I have to 
expire
them myself somehow?  In which case,  how do I detect that the browser
has
closed and the client vars have to be killed?

Cheers,
Mike Kear
Windsor, NSW, Australia
AFP WebWorks



__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.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: looking for duplicate emails

2001-12-27 Thread Mark Smyth

well one way of doing this this would be to select existing email 
addresses
from the database using a where clause that searches only for the email
address that you are looking for.

Then you can apply code that will deal with whether the the email 
address
exists or not by checking the recordcount for the query.

e.g. cfif queryname.recordcount is o
the email address does not exist in the database
cfelse
the email address exists in the database
/cfif

I'm not sure whether that is what you need.  If you need to compare the 
text
within the email use the compare/comparenocase functions

hth
mark



-Original Message-
From: Ben Densmore [mailto:[EMAIL PROTECTED]]
Sent: 27 December 2001 15:46
To: CF-Talk
Subject: looking for duplicate emails


Hi everyone,
 can someone possibly tell me the best way to compare email addresses 
that are allready in a database? Some of the info that my company gets 
from customers may come from the same person but looking for 2 
different 
part numbers so I need to look for the email address and then compare 
the part numbers and if they are the same the only show one of the 
records, if the part numbers are different then show both. 

Thank You,
 Ben Densmore


__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.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: append Txt file to Access

2001-12-14 Thread Mark Smyth

hi

if you go to
file - get external data - choose csv from the dropdown list

and you should be away

-Original Message-
From: ronmyers [mailto:[EMAIL PROTECTED]]
Sent: 14 December 2001 14:40
To: CF-Talk
Subject: append Txt file to Access


Can some on tell me or point me in the right direction on how to append a
comma delimited .txt file to an access database. The fist line of the file
has the same header names as the database.
 
Thanks Ron
Just a beginner in Cold Fusion, But think its an awesome program

 


~~
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: append Txt file to Access

2001-12-14 Thread Mark Smyth

i see... well it is friday

well basically if you need to upload (if its not on the server) and read the
file using cffile get the data

then create a list and loop through the txt file data populating the list
(using list functions, read up in the cfstudio docs)

then loop through the list (using cfloop) and have a cfquery inside
inserting the data into access

give it a bash and let me know if you need any help

HTH
Mark





-Original Message-
From: ronmyers [mailto:[EMAIL PROTECTED]]
Sent: 14 December 2001 15:14
To: CF-Talk
Subject: RE: append Txt file to Access


I understand that. I was hoping I could do it through CF as the file changes
and I wanted to use CFSchedule so it would update automatically

-Original Message-
From: Mark Smyth [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 14, 2001 7:53 AM
To: CF-Talk
Subject: RE: append Txt file to Access


hi

if you go to
file - get external data - choose csv from the dropdown list

and you should be away

-Original Message-
From: ronmyers [mailto:[EMAIL PROTECTED]]
Sent: 14 December 2001 14:40
To: CF-Talk
Subject: append Txt file to Access


Can some on tell me or point me in the right direction on how to append a
comma delimited .txt file to an access database. The fist line of the file
has the same header names as the database.
 
Thanks Ron
Just a beginner in Cold Fusion, But think its an awesome program

 




~~
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: append Txt file to Access

2001-12-14 Thread Mark Smyth

also

regarding the scheduled task, if the txt file is always going to be  on the
server it should be no problem once the code is written.

You'll just have to think how you're going to manage the txt file

-Original Message-
From: Mark Smyth 
Sent: 14 December 2001 15:20
To: CF-Talk
Subject: RE: append Txt file to Access


i see... well it is friday

well basically if you need to upload (if its not on the server) and read the
file using cffile get the data

then create a list and loop through the txt file data populating the list
(using list functions, read up in the cfstudio docs)

then loop through the list (using cfloop) and have a cfquery inside
inserting the data into access

give it a bash and let me know if you need any help

HTH
Mark





-Original Message-
From: ronmyers [mailto:[EMAIL PROTECTED]]
Sent: 14 December 2001 15:14
To: CF-Talk
Subject: RE: append Txt file to Access


I understand that. I was hoping I could do it through CF as the file changes
and I wanted to use CFSchedule so it would update automatically

-Original Message-
From: Mark Smyth [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 14, 2001 7:53 AM
To: CF-Talk
Subject: RE: append Txt file to Access


hi

if you go to
file - get external data - choose csv from the dropdown list

and you should be away

-Original Message-
From: ronmyers [mailto:[EMAIL PROTECTED]]
Sent: 14 December 2001 14:40
To: CF-Talk
Subject: append Txt file to Access


Can some on tell me or point me in the right direction on how to append a
comma delimited .txt file to an access database. The fist line of the file
has the same header names as the database.
 
Thanks Ron
Just a beginner in Cold Fusion, But think its an awesome program

 





~~
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: Java - Socket()

2001-12-12 Thread Mark Smyth

I though COM/DCOM were similar to sockets..

-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 10:11
To: CF-Talk
Subject: RE: Java - Socket()


I don't think there is one, the closest would be cfhttp though I think, what
are you trying to do?

-Original Message-
From: Rudy Rustam [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 10:18
To: CF-Talk
Subject: Java - Socket()


Hi guys,

What's the coldfusion equivalent for java Socket()?

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: Java - Socket()

2001-12-12 Thread Mark Smyth

cfhttp is fairly limited

I've had this problem working with SOAP.  

If you need to send a body, this is achieved by using a COM object and then
sending the http message through the COM.

try tcpclient2 http://www.intrafoundation.com/tcpclient.html

You connect to a COM object using the cfobject tag, but this tag comes with
loads of examples if i remember

Mark




-Original Message-
From: Rudy Rustam [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 10:46
To: CF-Talk
Subject: RE: Java - Socket()


Initially in java, to send a stream of http data (header and body) like
this:
Post /customer/customer.sms HTTP/1.1
Host: www.yahoo.com
Authorization: 1232132
Content-Length: 93

Subject=Example
[Book1]
Chapter1=Bla bla bla

[Book2]
Chapter1=Bla bla

Any idea how cfhttp could do the same function?

Regards,
Rudy


-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 12, 2001 6:51 PM
To: CF-Talk
Subject: RE: Java - Socket()

I don't think there is one, the closest would be cfhttp though I think,
what
are you trying to do?

-Original Message-
From: Rudy Rustam [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 10:18
To: CF-Talk
Subject: Java - Socket()


Hi guys,

What's the coldfusion equivalent for java Socket()?

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: Java - Socket()

2001-12-12 Thread Mark Smyth

hi craig

just out of interest, have you (or anyone else on the list) connected to a
SOAP server of tomcat?

Mark

-Original Message-
From: Mark Smyth 
Sent: 12 December 2001 11:04
To: CF-Talk
Subject: RE: Java - Socket()


cfhttp is fairly limited

I've had this problem working with SOAP.  

If you need to send a body, this is achieved by using a COM object and then
sending the http message through the COM.

try tcpclient2 http://www.intrafoundation.com/tcpclient.html

You connect to a COM object using the cfobject tag, but this tag comes with
loads of examples if i remember

Mark




-Original Message-
From: Rudy Rustam [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 10:46
To: CF-Talk
Subject: RE: Java - Socket()


Initially in java, to send a stream of http data (header and body) like
this:
Post /customer/customer.sms HTTP/1.1
Host: www.yahoo.com
Authorization: 1232132
Content-Length: 93

Subject=Example
[Book1]
Chapter1=Bla bla bla

[Book2]
Chapter1=Bla bla

Any idea how cfhttp could do the same function?

Regards,
Rudy


-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 12, 2001 6:51 PM
To: CF-Talk
Subject: RE: Java - Socket()

I don't think there is one, the closest would be cfhttp though I think,
what
are you trying to do?

-Original Message-
From: Rudy Rustam [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 10:18
To: CF-Talk
Subject: Java - Socket()


Hi guys,

What's the coldfusion equivalent for java Socket()?

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: Java - Socket()

2001-12-12 Thread Mark Smyth

tried cfx_soap, even to the extent of altering the source code, with no luck

there seems to be some problem with coldfusion, com and soap servers on
tomcat.

ASP works fine, and i'm really pi with having to work with asp

Mark


-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 11:24
To: CF-Talk
Subject: RE: Java - Socket()


Not yet Mark, will be implementing a SOAP system soon after Christmas.

I've heard a few people talk about a custom tag called cfx_soap before
though, maybe that can help you.


-Original Message-
From: Mark Smyth [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 11:06
To: CF-Talk
Subject: RE: Java - Socket()


hi craig

just out of interest, have you (or anyone else on the list) connected to a
SOAP server of tomcat?

Mark

-Original Message-
From: Mark Smyth 
Sent: 12 December 2001 11:04
To: CF-Talk
Subject: RE: Java - Socket()


cfhttp is fairly limited

I've had this problem working with SOAP.  

If you need to send a body, this is achieved by using a COM object and then
sending the http message through the COM.

try tcpclient2 http://www.intrafoundation.com/tcpclient.html

You connect to a COM object using the cfobject tag, but this tag comes with
loads of examples if i remember

Mark




-Original Message-
From: Rudy Rustam [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 10:46
To: CF-Talk
Subject: RE: Java - Socket()


Initially in java, to send a stream of http data (header and body) like
this:
Post /customer/customer.sms HTTP/1.1
Host: www.yahoo.com
Authorization: 1232132
Content-Length: 93

Subject=Example
[Book1]
Chapter1=Bla bla bla

[Book2]
Chapter1=Bla bla

Any idea how cfhttp could do the same function?

Regards,
Rudy


-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 12, 2001 6:51 PM
To: CF-Talk
Subject: RE: Java - Socket()

I don't think there is one, the closest would be cfhttp though I think,
what
are you trying to do?

-Original Message-
From: Rudy Rustam [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 10:18
To: CF-Talk
Subject: Java - Socket()


Hi guys,

What's the coldfusion equivalent for java Socket()?

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: Releasing Access locks with Coldfusion?

2001-12-12 Thread Mark Smyth

just stopping the coldfusion service should do it


-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2001 15:31
To: CF-Talk
Subject: Releasing Access locks with Coldfusion?


Anyone know how to release all locks on an access database via coldfusion?

I am having some trouble with getting one of our datasources to release its
current locking thus preventing me from uploading a new copy of the DB.


Thanks for your help

Kris Pilles
Website Manager
Western Suffolk BOCES
507 Deer Park Rd., Building C
Phone: 631-549-4900 x 267
E-mail: [EMAIL PROTECTED]

~~
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: Java Byte Code

2001-12-11 Thread Mark Smyth

java is slower than some other languages (e.g C++), but thats a pice you pay
for portability

Mark

-Original Message-
From: Mark Stewart [mailto:[EMAIL PROTECTED]]
Sent: 11 December 2001 14:40
To: CF-Talk
Subject: OT: Java Byte Code


I'm currently learning Java and I'm very excited to see Macromedia
moving in the Java direction. However, one of my co-workers stated that
Java byte code was very slow. Since I'm just learning Java, I didn't
have a good retort for him at the moment. So, I'm turning to you for
some answers here. Is this true? In my limited work with Java, I haven't
seen it to be slow. But then again, I don't expect a little Hello
World app to be slow.

Any suggestions or places that I can find some answers?

Thanks,

Mark Stewart
Programmer/Analyst
CC3
Phone: 215.672.6900 x1332
http://www.cc3.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: Hi

2001-12-05 Thread Mark Smyth

But, P-Mail doesn't have that nice paper clippy thingy.

I rest my case.

-Original Message-
From: Zac Belado [mailto:[EMAIL PROTECTED]]
Sent: 05 December 2001 16:15
To: CF-Talk
Subject: RE: Hi


 If P-mail were as popular as Outlook, it would be targetted and exploited.
 You don't hear about Pegasus Mail viruses because it doesn't have the
 userbase that Outlook does.

Complete and utter rubbish.

Outlook, Windows Scripting and the entire Office macro system is riddled
with security holes and this has been the case for years. Microsoft built
the system, Microsoft made it insecure and Microsoft continues to ship apps
and system level options that are enabled by default making them prime
targets for exploitation by hackers.

It is MS that builds the insecure systems. Virus writers take advantage of
the vulnerabilities and problems in the system...they don't make them.

~~
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: cfmail and more than 1 cc problem

2001-10-25 Thread Mark Smyth

hi

no the commas are the correct delimiter

i just tested the code here and it works fine

that would make me think its a problem with your mail server

what errors are you getting?
mark

-Original Message-
From: Seamus Campbell [mailto:[EMAIL PROTECTED]]
Sent: 25 October 2001 10:41
To: CF-Talk
Subject: RE: cfmail and more than 1 cc problem


I tried that but still didn't work

Ta
Seamus

At 07:29 pm 25/10/01 , you wrote:
should the cc addresses be separated by a ; not a comma?

they certainly need to be when I add more than one to outlook when wending
a
mail.

HTH

Will

-Original Message-
From: Seamus Campbell [mailto:[EMAIL PROTECTED]]
Sent: 25 October 2001 10:20
To: CF-Talk
Subject: cfmail and more than 1 cc problem


Hi

I am using cfmail to send some emails to more than one person

A cannot, however, get it to work after I have more than one cc

Here is my code:
cfmail to=[EMAIL PROTECTED]
from=[EMAIL PROTECTED]
subject=TEST
cc=[EMAIL PROTECTED],[EMAIL PROTECTED]
TESTING
/cfmail


It works perfectly until I add the second cc.

Is there any known problems with more than 1 cc address?

Any clues?

Many thanks

Seamus



~~
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: cfmail and more than 1 cc problem

2001-10-25 Thread Mark Smyth

I'd be interested to see if that works.

Because if it was a CF limitation the code wouldnt've worked here

would it?

Mark

-Original Message-
From: Joseph DeVore [mailto:[EMAIL PROTECTED]]
Sent: 25 October 2001 11:13
To: CF-Talk
Subject: RE: cfmail and more than 1 cc problem


If you still can't get it to send multiple emails, a
workaround would be to loop over a list of email addresses.

cfset emailList =[EMAIL PROTECTED],[EMAIL PROTECTED]

cfloop list=#emailList# index=i
cfmail to=#i#
.
/cfmail
/cfloop


Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: Seamus Campbell [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 2:41 AM
To: CF-Talk
Subject: RE: cfmail and more than 1 cc problem


I tried that but still didn't work

Ta
Seamus

At 07:29 pm 25/10/01 , you wrote:
should the cc addresses be separated by a ; not a comma?

they certainly need to be when I add more than one to outlook when wending
a
mail.

HTH

Will

-Original Message-
From: Seamus Campbell [mailto:[EMAIL PROTECTED]]
Sent: 25 October 2001 10:20
To: CF-Talk
Subject: cfmail and more than 1 cc problem


Hi

I am using cfmail to send some emails to more than one person

A cannot, however, get it to work after I have more than one cc

Here is my code:
cfmail to=[EMAIL PROTECTED]
from=[EMAIL PROTECTED]
subject=TEST
cc=[EMAIL PROTECTED],[EMAIL PROTECTED]
TESTING
/cfmail


It works perfectly until I add the second cc.

Is there any known problems with more than 1 cc address?

Any clues?

Many thanks

Seamus




~~
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: HTTP Posts with a java cfx

2001-10-25 Thread Mark Smyth

hi

not sure if this will help but cfx_soap on cfdev has source code included

regards
mark

-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]]
Sent: 25 October 2001 11:15
To: CF-Talk
Subject: RE: HTTP Posts with a java cfx


It already does ?

-Original Message-
From: nagraj [mailto:[EMAIL PROTECTED]]
Sent: 25 October 2001 11:30
To: CF-Talk
Subject: Re: HTTP Posts with a java cfx


Hai Craig,

This is specially when you donot give exception throws exception  clause
processrequest() method.


Is the syntax as below. Please check it
public void processRequest(Request req,Response res) throws Exception
{
}

Regards
Nagaraj

- Original Message -
From: Craig Dudley [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, October 25, 2001 3:15 PM
Subject: HTTP Posts with a java cfx


 Good morning all,

 I'm trying to write a java custom tag to do a simple http post and read
the
 response into a variable, I'm getting the same error no matter what method
I
 try.

 Basically it's for posting small xml packets to an SMS service provider.

 I've tried this with 20+ differnet url's, all of which exist.

 Error;
 ---
 java.io.FileNotFoundException: http://localhost/public/sms/smsin.cfm. Java
 exception occurred in call to method.
 ---

 What I don't undestand is why it would say file not found when I'm opening
a
 connection to a url, not a file?

 Are there any java experts out there that can give me some advice?

 Code follows;

 sendMessages.class
 ---

 import com.allaire.cfx.* ;

 import java.net.*;
 import java.io.*;


 public class sendMessages implements CustomTag
 {
public void processRequest( Request request, Response response )
 throws Exception
{

  // validate that required attributes were passed
  if ( !request.attributeExists( XMLDATA ) )
   {
throw new Exception( Missing attribute ( XMLDATA is a  +
required
 attribute for this tag) ) ;
  }

 String strName = request.getAttribute( XMLDATA );

 URL url = new URL(http://localhost/public/sms/smsin.cfm;);
 URLConnection connection = url.openConnection();
 connection.setDoOutput(true);
 connection.setDoInput (true);
 connection.setUseCaches (false);
 connection.setRequestProperty(Content-Type,
 application/x-www-form-urlencoded);

 PrintWriter out = new PrintWriter(connection.getOutputStream());

 out.println(XMLDATA= + strName);
 out.close();

 BufferedReader in = new BufferedReader(new
 InputStreamReader(connection.getInputStream()));

 String inputLine;
 String ReturnXML = ;

 while ((inputLine = in.readLine()) != null)
 {
 ReturnXML = ReturnXML + inputLine;
 }

 in.close();

 response.setVariable( ReturnXML , ReturnXML );
 response.write(ReturnXML);

 }

 }

 ---

 Sorry for the slight OT post, but at least it's a java CFX.

 


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

2001-10-25 Thread Mark Smyth

hi mark

i don't know about crystal reports but i use actuate reports quite alot

these work with the database via odbc so, it's fairly easy to implement and
once done the report is written the format can be switched between DHML, PDF
and its native report format for delivery across different media

look at www.actuate.com for further info and if i can be of more help, just
let me know

regards
mark

Mark Smyth 
Internet Systems Developer 
SUeBS 
00 44 1865 880800 
[EMAIL PROTECTED] 
www.systemsunion.net


-Original Message-
From: Mark Robinson (National Express)
[mailto:[EMAIL PROTECTED]]
Sent: 24 October 2001 10:11
To: CF-Talk
Subject: CF Reporting question


We have had a request to have data extracted by reports from a CF intranet
with an Ingres database.

Only being an amateur CF developer I wonder if anybody has any suggestion on
how to do this.

The ways we have thought of so far is perhaps using crystal reports (can
this be plugged into CF easily ?? Can you pass over values from CF to
crystal ??) or perhaps building a rtf/word document and then opening that up
within the browser.

any advice would be great,

mark

Mark Robinson
Analyst Programmer



This document is intended for, and should only be read by, those persons
to whom it is addressed. Its contents are confidential and if you have
received this message in error, please notify us immediately by telephone 
on 0121609 6301 and delete all records of the message from your computer.
Any form of reproduction, dissemination, copying, disclosure,
modification, distribution and / or publication of this message without our
prior written consent is strictly prohibited.
Neither the author of this message nor their employers
accept legal responsibility for the contents of the message. Any views or
opinions presented are solely those of the author.

If you have any queries please contact [EMAIL PROTECTED]

~~
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: CFHTTP Replacement

2001-10-25 Thread Mark Smyth

hi lewis

would you recommend this object for connecting to soap server

if so, what advice would you give?

if not, what would you recommend using with CF?
tia
mark

-Original Message-
From: Lewis Sellers [mailto:[EMAIL PROTECTED]]
Sent: 25 October 2001 14:34
To: CF-Talk
Subject: Re: CFHTTP Replacement


On Wed, 24 Oct 2001 23:05:03 -0500, David Brooks
[EMAIL PROTECTED] wrote:

Heya all,

Anyone know of a good solution, cfx tag or otherwise, for a replacement
for the CFHTTP tag?  I consistently have had problems with CFAS 4.x
and 5.0 servers.

http://www.intrafoundation.com/tcpclient.html. It's a COM I wrote a
while back that's been used with CF and ASP among others. There are
several examples showing how to grab pages (or headers or whatever you
want) using the HTTP protocol.

That one doesn't support SSL however is it's only drawback.

--min

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



RE: How do I check to see if cookies exist

2001-10-25 Thread Mark Smyth

why don't you just try setting a cookie on the 1st page

that would tell you if they cookies enabled
mark

-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: 25 October 2001 16:19
To: CF-Talk
Subject: How do I check to see if cookies exist


I am making an applications that will rely on cookies, basically
session management, I don't want to pass cfid or cftoken because it is a
shopping catalouge and will defeat the purpose if people can't link to my
products on other websites. How can I check this?

Robert Everland III
Dixon Ticonderoga

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



RE: CFHTTP Replacement

2001-10-25 Thread Mark Smyth

hi

i've been trying to get the xmlhttprequest com object working, but i keep
getting the following error



LoadRegTypeLi(4110913304, 29909128, 47497,  u...)failed.
Library not registered.
TYPE_E_LIBNOTREGISTERED($8002801D)



can anyone help with this?
I've already tried proxycfg.exe but to no avail

thanks guys
mark

-Original Message-
From: Lomvardias, Christopher [mailto:[EMAIL PROTECTED]]
Sent: 25 October 2001 16:39
To: CF-Talk
Subject: RE: CFHTTP Replacement


Another option If you are running CF on Windows is the ServerXMLHTTP object
included in MS XML Parser 3 or later. The ServerXMLHTTP object provides for
support for basic authentication, SSL and certificates. I will have a slide
presentation on using ServerXMLHTTP available on http://www.ancfug.com
sometime in the next few days.

Chris

-Original Message-
From: Lanny R. Udey [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 11:33 AM
To: CF-Talk
Subject: RE: CFHTTP Replacement


According to Dave Watts at the Devoloper's Conference, you cannot use
CFHTTP. He used a TCP COM object although I don't remember which one. You
may want to contact him.

Lanny Udey
Hofstra University

 [EMAIL PROTECTED] Thursday, October 25, 2001 
hi lewis

would you recommend this object for connecting to soap server

if so, what advice would you give?

if not, what would you recommend using with CF?
tia
mark

-Original Message-
From: Lewis Sellers [mailto:[EMAIL PROTECTED]] 
Sent: 25 October 2001 14:34
To: CF-Talk
Subject: Re: CFHTTP Replacement


On Wed, 24 Oct 2001 23:05:03 -0500, David Brooks
[EMAIL PROTECTED] wrote:

Heya all,

Anyone know of a good solution, cfx tag or otherwise, for a replacement
for the CFHTTP tag?  I consistently have had problems with CFAS 4.x
and 5.0 servers.

http://www.intrafoundation.com/tcpclient.html. It's a COM I wrote a
while back that's been used with CF and ASP among others. There are
several examples showing how to grab pages (or headers or whatever you
want) using the HTTP protocol.

That one doesn't support SSL however is it's only drawback.

--min




~~
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: CFHTTP Replacement

2001-10-25 Thread Mark Smyth

dave
just a quick question

i've been concentrating on connecting to the server firstly, and then worry
about the syntax of the messaage after.

With that in mind should the following work without sending a message??

cfobject
action=create
name=obj
class=Intrafoundation.TCPClient

cfset c = obj.Open(soapserver address,80)
cfif c is 1connected
cfelseNot Connected
/cfif 

thanks
mark


-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: 25 October 2001 16:50
To: CF-Talk
Subject: RE: CFHTTP Replacement


 According to Dave Watts at the Devoloper's Conference, you 
 cannot use CFHTTP. He used a TCP COM object although I don't 
 remember which one. You may want to contact him.

I used Lewis Sellers' TCPClient COM object. It was very simple to use,
making it good for demonstration purposes, and free:

http://www.intrafoundation.com/tcpclient.html

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

~~
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: CFHTTP Replacement

2001-10-25 Thread Mark Smyth

hi

made those changes but its still no go.

The only reason i know the servers working is that when i use cfx_soap its
returning an error message due to an incorrectly formatted message.  I
really want to steer away from editing the java source if possible which
would allow me to send the message format i need.

Would the fact that its on tomcat make any difference to the tag working?

any more ideas?

Mark
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 25 October 2001 17:33
To: CF-Talk
Subject: RE: CFHTTP Replacement


At 05:05 PM 10/25/2001 +0100, you wrote:

With that in mind should the following work without sending a message??

 cfobject
 action=create
 name=obj
 class=Intrafoundation.TCPClient

 cfset c = obj.Open(soapserver address,80)
 cfif c is 1connected
 cfelseNot Connected
 /cfif

thanks
mark

Assuming the address exists, yes that will open a TCP connection to the 
server. Don't forget to close it afterward though: cfset obj.Close() 
(HTTP will remotely close a connection after it sends any data -- annoying 
for sat connections but that's the way it is -- but the Close also does 
some garbage handling on the local client end that you really shouldn't 
rely on the object going out of scope to handle because the tag was 
originally designed to be persistent across pages.).

Additionally I believe the default time-out is something like 200ms. If 
you've developing you'll probably want to toss in a higher timeout than 
normal, say cfset obj.timeout=3.000 (3 seconds) at first unless you want 
to bother with putting in all the error handling cfml right off the bat.

--min

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



RE: Last Record's Autonumber value.

2001-09-27 Thread Mark Smyth

you can use max to do it

If its before you're inserting the record for the current user, just get the
last id number and add 1 to it

cfquery name=getID datasource=#travelDS#
select MAX(id) as id_no
from forms
/cfquery

cfset trnumber=#getID.id_no# + 1

is that what you wanted?

-Original Message-
From: Angel Stewart [mailto:[EMAIL PROTECTED]]
Sent: 27 September 2001 12:51
To: CF-Talk
Subject: Last Record's Autonumber value.


Hey all,

How can I tell what the Autonumber value of a record I just inserted is
using Access?

So I enter a User, and then I want to display that user's ID back to them. 
UserID is an Autonumber field, so I don't know it until after I insert. 
I can't search for First name or last name, because those could be
duplicated.

Do I do a Top 1 in a SQl query and wrap the entire thing in a CFTransaction?

-Gel


~~
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: Certified Master ColdFusion 5 Developer

2001-09-24 Thread Mark Smyth

has anyone taken both tests, how do they compare for difficulty?
Mark

-Original Message-
From: Mike Tangorre [mailto:[EMAIL PROTECTED]]
Sent: 24 September 2001 15:11
To: CF-Talk
Subject: Re: Certified Master ColdFusion 5 Developer


Brainbench and Allaires test are like apples and oranges..   :-)


- Original Message - 
From: Tristram Charnley [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, September 24, 2001 10:04 AM
Subject: RE: Certified Master ColdFusion 5 Developer


 Brainbench do a Master Cert - I can't remember my score but it was
 enough.
 
 Tristram Charnley
 
 

~~
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: Find in-coming form fields

2001-09-24 Thread Mark Smyth

try this
cfoutput
#Form.FieldNames#
/cfoutput

hth
mark
-Original Message-
From: Steven Monaghan [mailto:[EMAIL PROTECTED]]
Sent: 24 September 2001 15:34
To: CF-Talk
Subject: Find in-coming form fields


I have a situation where I need to accept a form, but I don't know the names
of the form fields that are set.

I can't access the posting form, since it's hidden in someone else's app, so
I can't find the names that way.  I want to build a simple page where I can
accept the post, then dump out all of the values in memory into an e-mail.
I looked at the CFDUMP tag, but that requires the variable name.

I'm new to Cold Fusion, so please indulge me if this is a simple task.

Thanks for any help,
Steve
-
Steven Monaghan
Oracle DBA / Cold Fusion Developer
MSC Industrial Direct Co., Inc.
Melville, NY
[EMAIL PROTECTED]
http://www.mscdirect.com
-


This e-mail is intended for the use of the addressee(s) only and may contain
privileged, confidential, or proprietary information that is exempt from
disclosure under law.  If you are not the intended recipient, please do not
read, copy, use or disclose the contents of this communication to others.
Please notify the sender that you have received this e-mail in error by
replying to the e-mail.  Please then delete the e-mail and destroy any

~~
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: Intranet search engines?

2001-09-21 Thread Mark Smyth

why not verity?

-Original Message-
From: John Paitel [mailto:[EMAIL PROTECTED]]
Sent: 21 September 2001 17:56
To: CF-Talk
Subject: Intranet search engines?


We are running our intranet on CF 3.1, with O'Reilly Website v2.3, Access 
as a backend database. (We are a small 10+ person company). We would like 
to add a search capability to the intranet...anyone recommend a good 
(Hopefully free/linkware) search enging tag or solution?

John

~~
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: Intranet search engines?

2001-09-21 Thread Mark Smyth

hi john

have a read of this
http://www.allaire.com/Handlers/index.cfm?ID=18429Method=FullCache=Off

coldfusion comes with its own search facility built in verity, it sounds
like website has one also, so you're spoilt for choice.  I'd stick with
verity if I was you, since you'll get help on this list if you need it.

Also look up the documentation on cfstudio about the cfsearch, cfindex and
cfcollection tags

Good Luck 
Mark

-Original Message-
From: John Paitel [mailto:[EMAIL PROTECTED]]
Sent: 21 September 2001 18:04
To: CF-Talk
Subject: RE: Intranet search engines?


Uhm...link? (Sorry, new to the whole search engine thing).

At 05:56 PM 9/21/01 +0100, you wrote:
why not verity?

-Original Message-
From: John Paitel [mailto:[EMAIL PROTECTED]]
Sent: 21 September 2001 17:56
To: CF-Talk
Subject: Intranet search engines?


We are running our intranet on CF 3.1, with O'Reilly Website v2.3, Access
as a backend database. (We are a small 10+ person company). We would like
to add a search capability to the intranet...anyone recommend a good
(Hopefully free/linkware) search enging tag or solution?

John



~~
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: formatting question

2001-09-20 Thread Mark Smyth

unless its changed for 5 cfgrid displays exactly how the data is held in the
database.

Theres no way to format the data using cfgrid, you'll have to format the dat
at DataBase level

HTH
Mark

-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: 20 September 2001 13:47
To: CF-Talk
Subject: formatting question


does anyone know how to put a date/time format on this field?
cfgridcolumn name=OpenDate header=Opened
right now it displays like...2001-08-22 19:37:51
i want it to be 08/22/2001 7:37pm



*
This e-mail, including any attachments, is intended for the 
receipt and use by the intended addressee(s), and may contain 
confidential and privileged information.  If you are not an intended 
recipient of this e-mail, you are hereby notified that any unauthorized 
use or distribution of this e-mail is strictly prohibited. 


~~
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: CFWDDX problem

2001-09-20 Thread Mark Smyth

wouldn't the evaluate function help here?

-Original Message-
From: Mike Kear [mailto:[EMAIL PROTECTED]]
Sent: 20 September 2001 13:49
To: CF-Talk
Subject: CFWDDX problem


CFWDDX problem.. What do I do about this?   I want to turn a struct into a
WDDX packet, but the name of the struct is dymanic, based on the user id.


The struct is called:   application.um.#UmID#_Data

and the CFWDDX tag is as follows:


cfwddx action=CFML2WDDX output=UserDataPacket
input=application.um.#UmID#_Data


But that puts the following into the packet:

wddxPacket
version='1.0'header/headerdatastringapplication.um.Um_F6B94560ADC11
1D583DC0003470B0337_Data/string/data/wddxPacket

As you can see it hasn't turned the contents of the struct into the WDDX
packet, but just the dynamic name instead.  I tried putting a hash before
and after the name, e.g.


cfwddx action=CFML2WDDX output=UserDataPacket
input=#application.um.#UmID#_Data#


but that throws an error.


What am I doing wrong here?



Cheers,
Mike Kear
Windsor, NSW, Australia
AFP WebWorks




~~
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: Converting Word and Excel to HTML

2001-09-20 Thread Mark Smyth

My advise would be to save the word docs as HTML, then make sure the clean
the HTML with dreamweaver (theres an option in dreamweaver to do this),
otherwise the HTML produced (but word at least) is a bit of a nightmare.

Then the HTML you're left with should be more or less workable with, and i
think the same might be possible with excel docs also, but i've never done
that

hth
mark
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 20 September 2001 13:54
To: CF-Talk
Subject: Converting Word and Excel to HTML


This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--_=_NextPart_001_01C141D3.50AA0870
Content-Type: text/plain;
charset=iso-8859-1

Good morning, all

Here is my problem.  We have a number of Word and Excel documents that are
currently available on our company Intranet.  We have just rolled out the
Intranet, so it is only available at HQ.  We are slowly beginning to give
our branches access, but our branch employees generally have thin clients
with IE installed, but no Word or Excel.  Therefore, we need to create a
custom tag that takes Word/Excel files and coverts them to HTML.

My first thought is to use the Object models in Word and Excel to do a
simple Save As HTML.  

Has anyone done anything like this?  Is this a practical solution?  I would
think that I would use VBScript to do this.  Does anyone have any comments,
war stories, references or resources on this?

I am posting this through email, since our Internet access has been shut
down due to the virus, so if this has been covered ad nauseum, I apologize.

Thanks!

Kathryn Butterly
Web Developer
Washington Mutual Finance
813 632-4490
[EMAIL PROTECTED]

--_=_NextPart_001_01C141D3.50AA0870
Content-Type: text/html;
charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN
HTML
HEAD
META HTTP-EQUIV=3DContent-Type CONTENT=3Dtext/html; =
charset=3Diso-8859-1
META NAME=3DGenerator CONTENT=3DMS Exchange Server version =
5.5.2654.45
TITLEConverting Word and Excel to HTML/TITLE
/HEAD
BODY

PFONT SIZE=3D2Good morning, all/FONT
/P

PFONT SIZE=3D2Here is my problem.nbsp; We have a number of Word =
and Excel documents that are currently available on our company =
Intranet.nbsp; We have just rolled out the Intranet, so it is only =
available at HQ.nbsp; We are slowly beginning to give our branches =
access, but our branch employees generally have thin clients with IE =
installed, but no Word or Excel.nbsp; Therefore, we need to create a =
custom tag that takes Word/Excel files and coverts them to =
HTML./FONT/P

PFONT SIZE=3D2My first thought is to use the Object models in Word =
and Excel to do a simple Save As HTML.nbsp; /FONT
/P

PFONT SIZE=3D2Has anyone done anything like this?nbsp; Is this a =
practical solution?nbsp; I would think that I would use VBScript to do =
this.nbsp; Does anyone have any comments, war stories, references or =
resources on this?/FONT/P

PFONT SIZE=3D2I am posting this through email, since our Internet =
access has been shut down due to the virus, so if this has been covered =
ad nauseum, I apologize./FONT/P

PFONT SIZE=3D2Thanks!/FONT
/P

PFONT SIZE=3D2Kathryn Butterly/FONT
BRFONT SIZE=3D2Web Developer/FONT
BRFONT SIZE=3D2Washington Mutual Finance/FONT
BRFONT SIZE=3D2813 632-4490/FONT
BRFONT SIZE=3D2[EMAIL PROTECTED]/FONT
/P

/BODY
/HTML
--_=_NextPart_001_01C141D3.50AA0870--
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.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



Cowards

2001-09-14 Thread Mark Smyth

It just makes me angry.

We've been going forwards and backwards over this now for days, maybe they
have a valid grievance, maybe they don't.

Maybe by training bin laden to be a terrorist, it is some kind of warped
retribution, who knows.

But when push comes to shove we're missing the point.  Him, or whoever did
this is a coward, not even human.  If he wanted to make a real show why
didn't they make an attempt a proper military target, they could've achieved
the same objective.  Killing themselves while taking people with them,
making a dramatic gesture...

To express their arguments and anger been taking childrens and families
lives and then feel its some kind of triumph.  They are beyond contempt,
that kind of thinking is beyond comtempt.  I can't express how much it
sickens me to think people like that exist amoung us.  I'm a father and to
think that my son could've been killed on that plane..

I just have a feeling though that we have to try to maintain our integrity
at the moment, blind hatred leads to the kind of mental sickness that
spurned these actions. 

So where does that leave us? forgiveness is unquestionable, to mull in our
hatred allows them to defeat us on a personal level

Mark Smyth 
Macromedia Certified ColdFusion Developer 
Systems Union eBusiness Solutions 
01865 880800 
[EMAIL PROTECTED] 
www.systemsunion.net


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

2001-09-14 Thread Mark Smyth

so angry posted it to the wrong list

-Original Message-
From: Mark Smyth 
Sent: 14 September 2001 16:14
To: CF-Talk
Subject: Cowards


It just makes me angry.

We've been going forwards and backwards over this now for days, maybe they
have a valid grievance, maybe they don't.

Maybe by training bin laden to be a terrorist, it is some kind of warped
retribution, who knows.

But when push comes to shove we're missing the point.  Him, or whoever did
this is a coward, not even human.  If he wanted to make a real show why
didn't they make an attempt a proper military target, they could've achieved
the same objective.  Killing themselves while taking people with them,
making a dramatic gesture...

To express their arguments and anger been taking childrens and families
lives and then feel its some kind of triumph.  They are beyond contempt,
that kind of thinking is beyond comtempt.  I can't express how much it
sickens me to think people like that exist amoung us.  I'm a father and to
think that my son could've been killed on that plane..

I just have a feeling though that we have to try to maintain our integrity
at the moment, blind hatred leads to the kind of mental sickness that
spurned these actions. 

So where does that leave us? forgiveness is unquestionable, to mull in our
hatred allows them to defeat us on a personal level

Mark Smyth 
Macromedia Certified ColdFusion Developer 
Systems Union eBusiness Solutions 
01865 880800 
[EMAIL PROTECTED] 
www.systemsunion.net



~~
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: Plain text view in outlook?

2001-08-31 Thread Mark Smyth

tools, options, mail format, and choose plain text from the message form
drop down list

HTH
Mark

-Original Message-
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: 31 August 2001 11:46
To: CF-Talk
Subject: Plain text view in outlook?


How can I use my outlook to simulate Plain text e-mail reader?

I just come up with a code that will send both html and plain text In
the same message = I see the html just fine (without text notes) But I
want to be able to see it in Plain text also.

Thanks,
 
Michael
~~
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: CF5 Pro SN

2001-08-30 Thread Mark Smyth

Subtle point (Ok, maybe I'm expectorating upwind), but I think it might 
help. ;-))

if someone can write a function which could expectorate upwind, now THAT
would be something
mark



-Original Message-
From: John Paitel [mailto:[EMAIL PROTECTED]]
Sent: 30 August 2001 17:00
To: CF-Talk
Subject: RE: CF5 Pro SN



I love this bunch... someone want to write a function to randomly
create serials :) laugh people...

LOL...

  Lets not get anal here.  Maybe giving your serial to someone is not
  illegal
  per say - as it is just string of numbers and letters - but why would

I would think that giving out the serial number is NOT an illegal act. But, 
the SN will do you absolutely no good without the piece of software to go 
with it, and the copying of THAT is what is illegal.

Subtle point (Ok, maybe I'm expectorating upwind), but I think it might 
help. ;-))

John (And yes, I am in a cantankerous mood this AM...lol)
~~
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: date format in CFgrid

2001-08-22 Thread Mark Smyth

hmmm

i'm fairly sure that you can't, cfgrid presents data more or less how it is
stored in the database.

You'll have to format it when you are inserting the data so it is
pre-formatted for output
Mark

Mark Smyth 
Macromedia Certified ColdFusion Developer 
Systems Union eBusiness Solutions 
01865 880800 
[EMAIL PROTECTED] 
www.systemsunion.net




-Original Message-
From: Terry Troxel [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2001 15:19
To: CF-Talk
Subject: date format in CFgrid


How do you format for a date field in CFgrid?

Terry Troxel
~~
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: Stock Quotes

2001-08-22 Thread Mark Smyth

cf_stockgrabber is available on the exchange
hth
mark

-Original Message-
From: Ronald Winn [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2001 16:09
To: CF-Talk
Subject: Stock Quotes


Any ideas on a good service that allows web servers to obtain stock
quotes (preferably free).  I'm building a flash and generator interface
to display a stock ticker.  
 
Thanks
Ron
~~
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



Open Source Content Mananagent System

2001-08-21 Thread Mark Smyth

Hi 

Does anyone know of any decent open source content management systems,
preferably in modular format.

I know some have been mentioned in recent threads..

Thanks in Advance

Mark Smyth 
Macromedia Certified ColdFusion Developer 
Systems Union eBusiness Solutions 
01865 880800 
[EMAIL PROTECTED] 
www.systemsunion.net




~~
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: Db query question

2001-08-20 Thread Mark Smyth

Hi Peter

Something like this should do the trick

cfquery name=select datasource=testdb dbtype=ODBC
select f.LONG_NAME, n.VALUE, n.NUTRIENT
from NIP_FOOD f, NIP_Nutrient n
where f.id = '01A10014'
/cfquery

Then just output the query as normal (without the aliases)
HTH
Mark

Mark Smyth 
Macromedia Certified ColdFusion Developer 
Systems Union eBusiness Solutions 
01865 880800 
[EMAIL PROTECTED] 
www.systemsunion.net




-Original Message-
From: Tilbrook, Peter [mailto:[EMAIL PROTECTED]]
Sent: 20 August 2001 05:35
To: CF-Talk
Subject: Db query question


I've been given a massive (130Mb) Access database with two tables.

NIP_FOOD and NIP_Nutrient.

NIP_FOOD contains a unique ID field which is Alphanumeric (eg:
01A10014) and NOT indexed, eg:

ID  LONG_NAME   
01A10014Beer, Ale
01A10015Beer, Bitter Or Draught
01A10016Beer, Regular Alcohol, Home Brewed
01A10017Beer, Lager

NIP_Nutrient contains a field called FOOD_ID which is seven seperate
rows of the same value as ID (but not linked). eg:

FOOD_ID VALUE NUTRIENT
01A10014191.574   ENERGY-SOA
01A100140.4   PROT
01A100140 FAT
01A100140 TOTSATFD
01A100142.492 CHO-SOA
01A100140 TOTSUG
01A1001410NA-SOA

What would be the way to retrieve all of the fields from both tables
using the ID value (eg: 01A10014) but have it output a single row, eg:

ID   LONG_NAME ENERGY-SOAPROT FATTOTSATFD
CHO-SOATOTSUG   NA-SOA
01A10014 Beer, Ale 191   0.4  0  0
2.492  010
01A10015 Beer, Bitter  191.622   0.3  0  0
2.726  0.2  7

etc

Thanks!

Peter Tilbrook
ColdFusion Applications Developer
Australia New Zealand Food Authority
Boeing House
55 Blackall Street
BARTON ACT 2600
Ph: +61-2-6271 2256
Fax: +61-2-6271 2278

http://www.anzfa.gov.au


**

This transmission is intended only for the use of the addressee(s)
and may contain confidential or legally privileged information. If you are
not the intended recipient, you are notified that any use or dissemination
of this communication is strictly prohibited. If you have received this
transmission in error, please notify the ANZFA IT helpdesk prior to deleting
all copies of this transmission together with any attachments.

ANZFA helpdesk:

E-mail:  [EMAIL PROTECTED]
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.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: Limiting text entered into TextArea

2001-08-20 Thread Mark Smyth

hi 
theres some code below that I found somewhere that does this, it should do
what you need

the textbox below the textarea gives a countdown of characters left and
starts counting down as they type.

HTH
Mark
Mark Smyth 
Macromedia Certified ColdFusion Developer 
Systems Union eBusiness Solutions 
01865 880800 
[EMAIL PROTECTED] 
www.systemsunion.net





SCRIPT LANGUAGE=JavaScript

!-- Begin
function textCounter(field, countfield, maxlimit) {
if (field.value.length  maxlimit) // if too long...this trims it!
field.value = field.value.substring(0, maxlimit);
// otherwise, update 'characters left' counter
else 
countfield.value = maxlimit - field.value.length;
}
// End --
/script

textarea cols=57 rows=10 name=agenda
onKeyDown=textCounter(this.form.agenda,this.form.remLen3,250);
onKeyUp=textCounter(this.form.agenda,this.form.remLen3,250);/textarea

font size=-2There are: 
input readonly type=text name=remLen3 size=3 maxlength=3 value=250
characters still available in the notes field

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: 20 August 2001 10:53
To: CF-Talk
Subject: Re: Limiting text entered into TextArea


[EMAIL PROTECTED] wrote:

 i guess it is compare with fieldname.length.

Almost, it is compared with formname.value.length like in the example 
below. Doesn't work flawlessly (one can paste stuff into the field 
without pressing a key), but it is a start.

textarea name=text onkeypress=return checkLength(this,500)

script language=JavaScript
function checkLength(formfield,limit) {
if (formfield.value.length  limit) {
alert(Only  + limit +  characters allowed.);
return false;
}
}
/SCRIPT




--
 
  The information transmitted is intended only for the person or entity to
 which it is addressed and may contain confidential and/or privileged
 material.  Any review, retransmission,  dissemination or other use of, or
 taking of any action in reliance upon, this information by persons or
 entities other than the intended recipient is prohibited.   If you
received
 this in error,  please contact the sender and delete the material from any
 computer.
 -- Phoenix Global Solutions (India) Pvt Ltd., www.pgsolutions.com

I am retransmitting and also kindly inviting you to take legal action 
against that.


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: Dynamic page creation help

2001-08-16 Thread Mark Smyth

Hi 

I did this before also, probably the easiest way is to use ewebeditpro and
add some administration functions yourself.

for info about ewebeditpro go to www.ektron.com

HTH

Mark Smyth 
Macromedia Certified ColdFusion Developer 
Systems Union eBusiness Solutions 
01865 880800 
[EMAIL PROTECTED] 
www.systemsunion.net






-Original Message-
From: Nick Betts [mailto:[EMAIL PROTECTED]]
Sent: 16 August 2001 11:15
To: CF-Talk
Subject: Dynamic page creation help


The brief is to create webpages via an updater.  The user can select how
many pages they wish the site to have (1,2 or 3).  Then based on a
defulat template they can then upload different images, amend text,
change colours etc.  This will then create their very own webiste.  Has
anyone done anything similar for inspairation?

regards,
Nick

-Original Message-
From: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
Sent: 16 August 2001 11:06
To: CF-Talk
Subject: RE: Cookie Question


Fuon,

Never rely on using cookies. ColdFusion's built-in handling of
session/client variables negates the use of cookies for most situations.
You
need to setup your application to use either client or session variables
and
store them in, preferably, a datasource as opposed to the registry (the
default).

Unless you are using pirated software the manuals explain this.

To depend on storing variables in the registry is not a good idea -
especially in a clustered environment.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Fuon See Tu
Sent: Thursday, 16 August 2001 4:42 AM
To: CF-Talk
Subject: Cookie Question


Do I use javascript to manipulate cookies, or can coldfusion do all of
the
cookie handling and manipulation?
~~
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: relational select box

2001-08-09 Thread Mark Smyth

could you be a bit more specific, 
what exactly are you trying to achieve?

Mark Smyth 
Macromedia Certified ColdFusion Developer 
Systems Union eBusiness Solutions 
01865 880800 




 



-Original Message-
From: Emmet McGovern [mailto:[EMAIL PROTECTED]]
Sent: 09 August 2001 15:40
To: CF-Talk
Subject: relational select box


Can anyone give me a tip on how to have the contents of one select box
update the contents of another from a relational DB?


Emmet McGovern

p.s.  Good lord its HOT!
~~
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: Subtract Null = Error

2001-08-07 Thread Mark Smyth

HI

Something like this should do it
Depending whether the variable is null or has a value cf will evaulate which
one to use automatically

cfif Recordset2.Total is NULL
Statements to deal with when the value is null
cfelse
cfoutputcfset newTotal =(Recordset2.TOTAL - Recordset1.TOTAL)#newTotal#
/cfoutput
/cfif


regards
Mark Smyth 
Macromedia Certified ColdFusion Developer 
Systems Union eBusiness Solutions 
00 44 1865 880800 

-Original Message-
From: Gryphawk [mailto:[EMAIL PROTECTED]]
Sent: 07 August 2001 09:41
To: CF-Talk
Subject: Subtract Null = Error


Hi there

I was hoping you could help me with a problem - I have a calculated value
from the following code:

cfoutputcfset newTotal =(Recordset2.TOTAL - Recordset1.TOTAL)#newTotal#
/cfoutput

Which works just fine when the Recordset2.TOTAL and Recordset1.TOTAL are
populated by the SQL (as set by search parameters on a previous page).  

However, on occasion Recordset2.Total is equal to nothing (null?) while
Recordset1.TOTAL has a value due to the search string, and when this
happens, CF throws an error which reads:

An error occurred while evaluating the expression: 

  newTotal =(Recordset2.TOTAL - Recordset1.TOTAL)

 Error near line 316, column 17.

 Cannot convert to number.

Is there anyway to get around this such as an If Recordset.TOTAL = nothing,
Then [don't subtract]? 

My apologies that I am only just starting to learn how to write coded stuff.

Many thanks,

Gryphawk
~~
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: Subtract Null = Error

2001-08-07 Thread Mark Smyth

Or actually, if the variable isn't even created you'll have to:

cfif isDefined(Recordset2.Total)
cfoutputcfset newTotal =(Recordset2.TOTAL - Recordset1.TOTAL)#newTotal#
/cfoutput
cfelse
Statements to deal with when the value is null
/cfif

-Original Message-
From: Mark Smyth 
Sent: 07 August 2001 09:52
To: CF-Talk
Subject: RE: Subtract Null = Error


HI

Something like this should do it
Depending whether the variable is null or has a value cf will evaulate which
one to use automatically

cfif Recordset2.Total is NULL
Statements to deal with when the value is null
cfelse
cfoutputcfset newTotal =(Recordset2.TOTAL - Recordset1.TOTAL)#newTotal#
/cfoutput
/cfif


regards
Mark Smyth 
Macromedia Certified ColdFusion Developer 
Systems Union eBusiness Solutions 
00 44 1865 880800 

-Original Message-
From: Gryphawk [mailto:[EMAIL PROTECTED]]
Sent: 07 August 2001 09:41
To: CF-Talk
Subject: Subtract Null = Error


Hi there

I was hoping you could help me with a problem - I have a calculated value
from the following code:

cfoutputcfset newTotal =(Recordset2.TOTAL - Recordset1.TOTAL)#newTotal#
/cfoutput

Which works just fine when the Recordset2.TOTAL and Recordset1.TOTAL are
populated by the SQL (as set by search parameters on a previous page).  

However, on occasion Recordset2.Total is equal to nothing (null?) while
Recordset1.TOTAL has a value due to the search string, and when this
happens, CF throws an error which reads:

An error occurred while evaluating the expression: 

  newTotal =(Recordset2.TOTAL - Recordset1.TOTAL)

 Error near line 316, column 17.

 Cannot convert to number.

Is there anyway to get around this such as an If Recordset.TOTAL = nothing,
Then [don't subtract]? 

My apologies that I am only just starting to learn how to write coded stuff.

Many thanks,

Gryphawk
~~
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: web base reporting tools

2001-08-07 Thread Mark Smyth

I've been using actuate

well worth a look, but pricy

www.actuate.com

hth
mark

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 07 August 2001 17:34
To: CF-Talk
Subject: web base reporting tools


Hi,

Does anyone knows any good web base reporting tools beside Crytal report?

Thank you for any information

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



Discussion List

2001-08-03 Thread Mark Smyth

I need to find a quick to implement discussion group section, where people
can post comments to specific subjects.

I know there are some good free one out there, any suggestion

Thanks in advance

Mark Smyth 
Macromedia Certified ColdFusion Developer 
Systems Union eBusiness Solutions 
www.systemsunion.net
01865 880800 




 


~~
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: Question: Creating a primary key field

2001-08-01 Thread Mark Smyth

Hi

I needed the ID number of a form (its autonumber when inserted), so do this
I used the SQL max function to optain, the last entry, therefore the last
autonumber and then added 1 to it.

Heres the code

cfquery name=getform datasource=#travelDS#
select MAX(id) as test
from forms
/cfquery

cfset trnumber=#getform.test# + 1

HTH
mark
-Original Message-
From: Shannon Rhodes [mailto:[EMAIL PROTECTED]]
Sent: 01 August 2001 14:41
To: CF-Talk
Subject: Question: Creating a primary key field


Is it possible to query which was the last ID number created (autonumber
field in Access) for the purpose of adding 1 to explicitly state the new ID
number for a newly created record?

The reason why I ask is that I'm having trouble inserting my new info into
two separate tables because I need the newly created ID number for table A
to be inserted into table B.  If I can't guess what the number will be,
I'm stuck trying to take the user through a second page where I insert into
table A then turn around and query the new record to insert the new field
into table B.  That leaves me with the problem of what to do if the user
abandons the application on the second page, leaving no new record created
in table B.

This may sound like screwy application design (and maybe it is, I'm still
pretty new at this), but the problem is that table A contains contact
information, while table B contains all other information (class
registration, payment methods, etc), and they have a one-to-one relationship
because I may need to change which person the info is associated with (it's
possible that a person will register and pay for a class, but a co-worker
will attend in their place).  I can't make the classID a primary key in
table B either (the person could decide to switch classes) so I just have an
autonumber as a primary key.  Argh!  All suggestions welcomed.

TIA,
Shannon
[EMAIL PROTECTED]



FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

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

2001-07-31 Thread Mark Smyth

Just a heads up

Someone here just recieved an attachment with their email
ssa.zip.pif 

We've had a look and it looks nasty, dont't open

Mark Smyth 
Macromedia Certified ColdFusion Developer 
Systems Union eBusiness Solutions 
01865 880800 



~~
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: Attachment Warning

2001-07-31 Thread Mark Smyth

spot on

thanks bill
mark

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 31 July 2001 13:59
To: CF-Talk
Subject: Re: OT: Attachment Warning


Hey Mark,

This appears to be the SirCam virus. Check out earlier posts today on this 
board. More info can be found at:

http:[EMAIL PROTECTED]

Also, note that the name of the attached file, the subject of the Email and 
the sending address are all dynamic. So beware of other attached files.

Cheers,
Bill 

In a message dated 7/31/01 7:51:32 AM Eastern Daylight Time, 
[EMAIL PROTECTED] writes:


 Just a heads up
 
 Someone here just recieved an attachment with their email
 ssa.zip.pif 
 
 We've had a look and it looks nasty, dont't open
 
 Mark Smyth 
 Macromedia Certified ColdFusion Developer 
 Systems Union eBusiness Solutions 
 01865 880800 

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

2001-07-31 Thread Mark Smyth

make the type=html

mark
-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: 31 July 2001 16:47
To: CF-Talk
Subject: cfmail


is there a way to put td tags in the cfmail tag to make the formatting
prettier?



*
This e-mail, including any attachments, is intended for the 
receipt and use by the intended addressee(s), and may contain 
confidential and privileged information.  If you are not an intended 
recipient of this e-mail, you are hereby notified that any unauthorized 
use or distribution of this e-mail is strictly prohibited.
~~
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: Geek Cruises

2001-07-27 Thread Mark Smyth

If anyone manages to get their boss to let them put a cruise on their
expenses, i'd love to hear about it!


-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: 26 July 2001 23:00
To: CF-Talk
Subject: RE: Geek Cruises


 I don't know about you...but if I go on a cruise...I 
 certainly DON'T want to talk about work!!!

Sure you do - then it's a business expense!

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Friday Afternoon Macromedia Styleee

2001-07-27 Thread Mark Smyth

That is a great site
try this for interactivity with a capitol I
http://www.dubit.co.uk


-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: 27 July 2001 15:25
To: CF-Talk
Subject: RE: Friday Afternoon Macromedia Styleee


 I thought that since we are all now Macromedia customers we could
 do a spot
 the best Dynamic flash site. (does not have to be CF driven, not sure what
 this one is to be honest)

 Thought I'd start the ball rolling with http://www.2advanced.com

 This site grabbed me by the short and curlys, well impressed, its well out
 there.

Or how about taking this type of non-question-asking to CF-Community, where
it belongs?

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

Websites for the real world

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

2001-07-26 Thread Mark Smyth

could be worse, imagine if you went on the asp by mistake :)

-Original Message-
From: Brandon Wood [mailto:[EMAIL PROTECTED]]
Sent: 26 July 2001 16:06
To: CF-Talk
Subject: Re: Geek Cruises


You have got to be kiddingThere is no way I would spend eight friggin
days with a bunch of you guys.  I love you and all but jeez...



- Original Message -
From: C. Hatton Humphrey [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, July 26, 2001 10:05 AM
Subject: WOT: Geek Cruises


 Okay, I know this is off-topic, but I just found this link and thought it
 was interesting/funny enough to share.

 Geek Cruises:
 http://www.userfriendly.org/bazaar/GEN-geekcruises.html

 Enjoy!
 Hatton



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

2001-07-17 Thread Mark Smyth

I havn't taken the exam, but i'm 100% that the new features will be covered.

especially user defined functions

HTH
Mark
-Original Message-
From: Ruslan Sivak [mailto:[EMAIL PROTECTED]]
Sent: 17 July 2001 14:39
To: CF-Talk
Subject: CF 5 Certification


Well, as of last Saturday, CF 4.5 certification is no longer being
offered and as of last Sunday, the CF 5.0 Certification is offered.  I'm
about to take it this coming Sunday, but I'm a little nervous, as Ben's
book (Certified ColdFusion Developer Study Guide) doesn't talk about CF
5 features at all, even though the book was just published a few months
ago.  

Has anyone taken the CF 5 exam yet, or does anyone know if it will cover
any CF 5 specific features? 


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

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



RE: access not accepting insert statement

2001-07-05 Thread Mark Smyth

are you locking the insert statement?

Mark Smyth 
Macromedia Certified ColdFusion Developer 
Systems Union eBusiness Solutions 
01865 880800 
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 

-Original Message-
From: Gilbert Midonnet [mailto:[EMAIL PROTECTED]]
Sent: 05 July 2001 15:20
To: CF-Talk
Subject: access not accepting insert statement



I'm using coldfusion and access (ODBC) and having a problem.When
multiple insert statements arrive at the same time only the first insert
statement is accepted.  We don't have that many users on the system
(Intranet) so it doesn't make sense to migrate from access.

Is there a way of queuing the insert statements, or any other way of solving
this problem?



Gilbert Midonnet
BrokerTec USA, LLC
(201) 209-7843





 
This message is for the named person's use only. It may contain
confidential, proprietary or legally 
privileged information. No confidentiality or privilege is waived or lost by
any mistransmission. If 
you receive this message in error, please immediately delete it and all
copies of it from your 
system, destroy any hard copies of it and notify the sender. You must not,
directly or indirectly, 
use, disclose, distribute, print, or copy any part of this message if you
are not the intended 
recipient.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



  1   2   >