ColdFusion Studio Tag Update

2002-05-22 Thread Stephen Galligan

Anybody know where I can download the ColdFusion Studio Tag Update from?  

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

__
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: ColdFusion Studio Tag Update

2002-05-22 Thread Stephen Galligan

Even the one that updates CFstudio 4.# to CF5 studio?

-Original Message-
From: Neil Clark - =TMM= [mailto:[EMAIL PROTECTED]]
Sent: 22 May 2002 11:30
To: CF-Talk
Subject: RE: ColdFusion Studio Tag Update


Its not released yet...









Neil Clark
Team Macromedia
http://www.macromedia.com/go/team

Announcing Macromedia MX!! 
http://www.macromedia.com/software/trial/.

-Original Message-
From: Stephen Galligan [mailto:[EMAIL PROTECTED]] 
Sent: 22 May 2002 11:35
To: CF-Talk
Subject: ColdFusion Studio Tag Update

Anybody know where I can download the ColdFusion Studio Tag Update from?


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



__
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 Studio Tag Update

2002-05-22 Thread Stephen Galligan

Many thanks Mike.

-Original Message-
From: Mike Townend [mailto:[EMAIL PROTECTED]]
Sent: 22 May 2002 12:28
To: CF-Talk
Subject: Re: ColdFusion Studio Tag Update


theres a link in the CF5 Administrator that allows you to download the
4 - 5 tag update... not sure where it is off hand on the macromedia site.

HTH



Stephen Galligan wrote:

 Even the one that updates CFstudio 4.# to CF5 studio?
 
 -Original Message-
 From: Neil Clark - =TMM= [mailto:[EMAIL PROTECTED]]
 Sent: 22 May 2002 11:30
 To: CF-Talk
 Subject: RE: ColdFusion Studio Tag Update
 
 
 Its not released yet...
 
 
 
 
 
 
 
 
 
 Neil Clark
 Team Macromedia
 http://www.macromedia.com/go/team
 
 Announcing Macromedia MX!! 
 http://www.macromedia.com/software/trial/.
 
 -Original Message-
 From: Stephen Galligan [mailto:[EMAIL PROTECTED]] 
 Sent: 22 May 2002 11:35
 To: CF-Talk
 Subject: ColdFusion Studio Tag Update
 
 Anybody know where I can download the ColdFusion Studio Tag Update from?
 
 
 Regards,
 Stephen
 -- 
 Stephen Galligan
 Systems Administrator
 Thoughtbubble Ltd 
 Media Development House
 -- 
 United Kingdom 
 http://www.thoughtbubble.net 
 http://www.thoughtbubble.co.uk/ 
 Tel: +44 (0) 20 7387 8890 
 -- 
 New Zealand 
 http://www.thoughtbubble.co.nz/ 
 Tel: +64 (0) 9 488 9131 
 -- 
 The information in this email and in any attachments is confidential and
 intended solely for the attention and use of the named addressee(s). Any
 views or opinions presented are solely those of the author and do not
 necessarily represent those of Thoughtbubble. This information may be
 subject to legal, professional or other privilege and further
 distribution
 of it is strictly prohibited without our authority. If you are not the
 intended recipient, you are not authorised to disclose, copy,
 distribute, or
 retain this message. Please notify us on +44 (0)207 387 8890.
 
 
 
 

__
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: Query help

2002-05-21 Thread Stephen Galligan

Kris,
In your Stored Proc you can use one of SQL's own variables @@identity to get
the row id for the record you have just inserted.  Simply assign @@identity
to a local var et voilà!

HTH
Stephen

DECLARE @id as int

INSERT INTO tableFoo (Col1,Col2,Col3)
VALUES (a,b,c)

SELECT @@identity = @id
SELECT @id


-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: 21 May 2002 14:06
To: CF-Talk
Subject: Query help


How can Insert a record into a table (that I know how to do) but after
the insert, I want to be able to know what the primary key for the
record I just inserted...  

__
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: Query help

2002-05-21 Thread Stephen Galligan

Just keeping you on your toes Boss!

-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: 21 May 2002 15:18
To: CF-Talk
Subject: RE: Query help


almost!

instead of SELECT @@identity = @id you need SELECT @id = @@identity 

-Original Message-
From: Stephen Galligan [mailto:[EMAIL PROTECTED]]
Sent: 21 May 2002 15:14
To: CF-Talk
Subject: RE: Query help


Kris,
In your Stored Proc you can use one of SQL's own variables @@identity to get
the row id for the record you have just inserted.  Simply assign @@identity
to a local var et voilà!

HTH
Stephen

DECLARE @id as int

INSERT INTO tableFoo (Col1,Col2,Col3)
VALUES (a,b,c)

SELECT @@identity = @id
SELECT @id


-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: 21 May 2002 14:06
To: CF-Talk
Subject: Query help


How can Insert a record into a table (that I know how to do) but after
the insert, I want to be able to know what the primary key for the
record I just inserted...  



__
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: Strange SQL error

2002-05-17 Thread Stephen Galligan

What Andy meant was that he moved the @JuryTitle param to the bottom of the
list like so:
-- Any parameters here
@CountryID  int 
,   @JuryName   varchar(100)
,   @JuryCompanyvarchar(50) 
,   @JuryCity   varchar(50) 
,   @JuryTypeID int 
,   @JuryTitle  varchar(50) 

@JuryTitle was originally declared after the second param @JuryName.

For some reason the SP then released perfectly.  Bizarrely I then moved the
@JuryTitle param back to where it was and then the SP relases again.  For
the last 2 hours the SP would not release and we are at a loss as to why it
didn't work.

Any Ideas SQL gurus what may have happened?

-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]]
Sent: 17 May 2002 17:10
To: CF-Talk
Subject: RE: Strange SQL error


uh?

 -Original Message-
 From: Andy Ewings [mailto:[EMAIL PROTECTED]]
 Sent: 17 May 2002 17:18
 To: CF-Talk
 Subject: RE: Strange SQL error
 
 
 Right fixed it - all we did was to move the declaration of 
 the JuryTitle
 param to the bottom of the list and itr works! SQL schmeequel
 
 -Original Message-
 From: Rich Wild [mailto:[EMAIL PROTECTED]]
 Sent: 17 May 2002 16:50
 To: CF-Talk
 Subject: RE: Strange SQL error
 
 
 I assume in this bit:
 
   VALUES  (
   @CountryID
   ,   @JuryName
   ,   @test
   ,   @JuryCompany
   ,   @JuryCity
   ,   @JuryTypeID
   
 
 you're actually using 
 
   VALUES  (
   @CountryID
   ,   @JuryName
   ,   @JuryTitle
   ,   @JuryCompany
   ,   @JuryCity
   ,   @JuryTypeID
   
 
 ?
 
  -Original Message-
  From: Andy Ewings [mailto:[EMAIL PROTECTED]]
  Sent: 17 May 2002 16:56
  To: CF-Talk
  Subject: Strange SQL error
  
  
  In all my time developing SQL I have never come across sommat 
  like this -
  please someone tell me I'm being stoopid as it's a Fri
  afternoon.
  I have the following SP which refuses to release - it says it 
  cannot find
  parameter @JuryTitle.  If I comment out @JuryTitle and the 
  corresponding
  field insert it works.  If I change the name of the variable it
  doesn'tsomeone slap me with a kipper so I can see 
  where I've
  gone wrong...
  
  CREATE PROCEDURE JuryInsert
  
  -- Any parameters here
  @CountryID  int 
  ,   @JuryName   varchar(100)
  ,   @JuryTitle  varchar(50) 
  ,   @JuryCompanyvarchar(50) 
  ,   @JuryCity   varchar(50) 
  ,   @JuryTypeID int 
  
  AS
  
  BEGIN
  
  INSERT INTO tblJury (
  CountryID
  ,   JuryName
  ,   JuryTitle
  ,   JuryCompany
  ,   JuryCity
  ,   JuryTypeID
  )
  VALUES  (
  @CountryID
  ,   @JuryName
  ,   @test
  ,   @JuryCompany
  ,   @JuryCity
  ,   @JuryTypeID
  )
  
  IF @@error  0
  BEGIN
  GOTO ERROR_EXIT
  END
  
  RETURN @@error
  
  ERROR_EXIT:
  RETURN @@error
  
  
  END
  GO
  -- 
  Andy Ewings
  Director 
  Thoughtbubble Ltd
  http://www.thoughtbubble.net 
  -- 
  United Kingdom 
  http://www.thoughtbubble.net 
  Tel: +44 (0) 20 7387 8890 
  -- 
  New Zealand 
  http://www.thoughtbubble.co.nz/ 
  Tel: +64 (0) 9 419 4235 
  -- 
  The information in this email and in any attachments is 
  confidential and
  intended solely for the attention and use of the named 
  addressee(s). Any
  views or opinions presented are solely those of the author 
 and do not
  necessarily represent those of Thoughtbubble. This 
 information may be
  subject to legal, professional or other privilege and further 
  distribution
  of it is strictly prohibited without our authority. If you 
 are not the
  intended recipient, you are not authorised to disclose, copy, 
  distribute, or
  retain this message. Please notify us on +44 (0)207 387 8890. 
  
  
  
 
 

__
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 Developer Edition

2002-05-13 Thread Stephen Galligan

Anthony,

It has vanished.  I can't seem to find it anywhere on the site.

Stephen

-Original Message-
From: Weaver, Anthony [mailto:[EMAIL PROTECTED]]
Sent: 13 May 2002 13:39
To: CF-Talk
Subject: CF5 Developer Edition


Does anybody remember the URL to the CF5 developers edition?  Macromedia
seems to have purged every metion of 5.0 from their site.


Tony Weaver
Limited Technology Services
Technology Planning 
Programmer/Analyst
Phone: 614.415.7647
E-mail: [EMAIL PROTECTED]

THE LIMITED, INC.


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



RE: sql Stored Proc

2002-05-02 Thread Stephen Galligan

I agree Kevan.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 02 May 2002 09:46
To: CF-Talk
Subject: RE: sql Stored Proc


I don't think you can use a variable to build dynamic sql like that. I think
you have to build the sql statement in a string and then use
execute(@yoursqlstring) to run it.

-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: 01 May 2002 17:44
To: CF-Talk
Subject: RE: sql Stored Proc


Can anyone else give me any insight on this?

-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 12:08 PM
To: CF-Talk
Subject: RE: sql Stored Proc


I recieve an error incorrect synatx near the keyword and.


declare @col as varchar(500)

if(@rpttype) = 'Missing'
  begin
set @col = ([desc] Like '%Missing%' OR [DESC] IS NULL)
   end
set nocount on

if (@corp is not null and @reg_no is null and @dis_no is null and @date1 is
not null and @date2 is null)
   BEGIN
SELECT m_id, y_id, reg_no,
SUM(CASE WHEN SLIC NOT LIKE '88%' THEN cost ELSE 0 END) AS INTCOST,
SUM(CASE WHEN SLIC LIKE '88%' THEN cost ELSE 0 END) AS exTCOST,
CONVERT(datetime, (cast(m_id as varchar)) + '/01/' + (cast(y_id as
varchar))) as dateinput
into #blahtable
FROM vw_CTMCORPAPPFULLVIEWprod
where @col and year = @date1
GROUP BY  reg_NO, y_id, M_id
ORDER BY cast(y_id as int), cast(m_id as int)

-Original Message-
From: Costas Piliotis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 12:00 PM
To: CF-Talk
Subject: RE: sql Stored Proc


You missed the word AS in the declare statement:

DECLARE @col AS nvarchar(30)



-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 9:00 AM
To: CF-Talk
Subject: RE: sql Stored Proc


If the colors didnt come across the declare and set all work fine the part
that is giving me a problem is the @col when I try to use it in the query.
Does anyone know how to make this work correctly?

Joshua TIpton

-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 01, 2002 11:35 AM
To: CF-Talk
Subject: sql Stored Proc


The red protion works and I can output the variable my problem is the blue
highlighted part.  Is it possible to create that part of the query from what
is in a variable?



CREATE PROCEDURE sp_ctmdatacorp

@corp char(4) = null,
@reg_no char(4) =null,
@dis_no char(4) =null,
@date1 varchar(4),
@date2 varchar(4) = null,
@rpttype char(10)


  AS
/*SELECT  @corp, @reg_no, @dis_no, @date1,@date2, @rpttype*/ declare @col
varchar(30)

if(@rpttype) = 'Missing'
  begin
set @col = [desc] Like '%Missing%' OR [DESC] IS NULL
   end

set nocount on

if (@corp is not null and @reg_no is null and @dis_no is null and @date1 is
not null and @date2 is null)
   BEGIN
 SELECT m_id, y_id, reg_no,
 SUM(CASE WHEN SLIC NOT LIKE '88%' THEN cost ELSE 0 END) AS INTCOST,
SUM(CASE WHEN SLIC LIKE '88%' THEN cost ELSE 0 END) AS exTCOST,
CONVERT(datetime, (cast(m_id as varchar)) + '/01/' + (cast(y_id as
varchar))) as dateinput
  into #blahtable
 FROM vw_CTMCORPAPPFULLVIEWprod
 WHERE (@col) and year = @date1
 GROUP BY  reg_NO, y_id, M_id
 ORDER BY cast(y_id as int), cast(m_id as int)

insert into #blahtable

SELECT DISTINCT
dbo.tbl_CTMCORPMONTHYEARRDD.m_id,
dbo.tbl_CTMCORPMONTHYEARRDD.y_id,
dbo.tbl_CTMCORPMONTHYEARRDD.reg_no,
0 as intcost, 0 as extcost,
   CONVERT(datetime, (cast(tbl_CTMCORPMONTHYEARRDD.m_id as varchar)) +
'/01/' + (cast(tbl_CTMCORPMONTHYEARRDD.y_id as varchar))) as dateinput FROM
dbo.tbl_CTMCORPMONTHYEARRDD LEFT OUTER JOIN #blahtable ON
dbo.tbl_CTMCORPMONTHYEARRDD.y_id = #blahtable.y_id AND
 dbo.tbl_CTMCORPMONTHYEARRDD.m_id = #blahtable.m_id AND
dbo.tbl_CTMCORPMONTHYEARRDD.reg_no = #blahtable.reg_no WHERE
(#blahtable.m_id IS NULL) AND (#blahtable.y_id IS NULL) AND
(#blahtable.reg_no IS NULL)  and dbo.tbl_CTMCORPMONTHYEARRDD.y_id =
right(@date1,1)

select * from #blahtable
drop table #blahtable

END







__
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: javaScript (simple)

2002-04-26 Thread Stephen Galligan

Try this

INPUT TYPE=button VALUE=Delete Record onClick=return confirm('Are you
sure you want to delete this record?')

Regards
Stephen
-Original Message-
From: Deborah Curley [mailto:[EMAIL PROTECTED]]
Sent: 26 April 2002 12:16
To: CF-Talk
Subject: javaScript (simple)


Hi all,
Anyone have the code readily available for an OnClick action to make sure a 
customer wants to delete the record (i.e., click the delete button, get 
prompted for whether you really want to delete and don't do the action 
unless you.

TIA,
Deb

_
Chat with friends online, try MSN Messenger: http://messenger.msn.com



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



RE: double post: access2000 on unix. Is it even possible??

2002-04-26 Thread Stephen Galligan

www.unixodbc.org

http://www.atinet.com/Products/OpenRDA/ODBC_UNIX/ODBC_UNIX_access.asp

-Original Message-
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: 26 April 2002 17:47
To: CF-Talk
Subject: double post: access2000 on unix. Is it even possible??


Hello,

This might be a stoopid question (in fact i'm pretty sure it is) but I have
always worked with NT servers up to now.

I want to port a site over to a unix server. The backend DB is Access2000.
Are there ODBC drivers for Access on Unix? Can I do this, or do I need to
upgrade to SQL server?

Cheers

Will


__
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: EMERGENCY!!! NEED SOLARIS HELP

2002-04-16 Thread Stephen Galligan

su as root and then use these to start and stop the ColdFusion processes: 

installdir/coldfusion/bin/start
installdir/coldfusion/bin/stop

Stephen

-Original Message-
From: James Taavon [mailto:[EMAIL PROTECTED]]
Sent: 16 April 2002 15:42
To: CF-Talk
Subject: EMERGENCY!!! NEED SOLARIS HELP


I need the stop/startup command for CF on Solaris platform.

THANKS IN ADVANCE!!!

__
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: Related Question to Previous Solaris question

2002-04-16 Thread Stephen Galligan

Typically UNIX systems can only have a certain number of file descriptors
open.  This is set to 64 by default I believe.  This can be increased to
something like 1024 which should stop the error.

No process may have more than OPEN_MAX file descriptors open at a time.

http://www.macromedia.com/v1/handlers/index.cfm?ID=8627Method=Full

Look at this page for the section about Solaris and it will anser your
question. You need to modify the /etc/system file to increase the file
descriptor size to 1024.

-Original Message-
From: James Taavon [mailto:[EMAIL PROTECTED]]
Sent: 16 April 2002 16:03
To: CF-Talk
Subject: Related Question to Previous Solaris question


Does anybody know what unix error 24 means?

Error Occurred While Processing Request
Error Diagnostic Information
An error occurred while attempting to establish a connection to the service.


Unix error number 24 occurred: Too many open files




-Original Message-
From: James Taavon [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 16, 2002 10:53 AM
To: CF-Talk
Subject: RE: EMERGENCY!!! NEED SOLARIS HELP (THANKS)


thanks

-Original Message-
From: Stephen Galligan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 16, 2002 10:47 AM
To: CF-Talk
Subject: RE: EMERGENCY!!! NEED SOLARIS HELP


su as root and then use these to start and stop the ColdFusion processes:

installdir/coldfusion/bin/start
installdir/coldfusion/bin/stop

Stephen

-Original Message-
From: James Taavon [mailto:[EMAIL PROTECTED]]
Sent: 16 April 2002 15:42
To: CF-Talk
Subject: EMERGENCY!!! NEED SOLARIS HELP


I need the stop/startup command for CF on Solaris platform.

THANKS IN ADVANCE!!!




__
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: Run SHELL

2002-03-27 Thread Stephen Galligan

Romulogomes,

Yup you can use it to run a shell script or any other program you wish.

Here you can run a shell script called myscript
CFSET arguments=#PARAM1#
CFEXECUTE
NAME=/usr/local/bin/myscript
ARGUMENTS=#arguments#
OUTPUTFILE=/var/www/html/mysite/mysite.foo
TIMEOUT=999
/CFEXECUTE

Here you can use it to call GREP
CFSET arguments=#STRING# #DIRECTORY#
CFEXECUTE
NAME=/bin/grep
ARGUMENTS=#arguments#
OUTPUTFILE=/tmp/grepoutput
TIMEOUT=10
/CFEXECUTE

If the request doesn't have the correct privileges to run that program it
simply returns an error page.

[EMAIL PROTECTED] is a good source of info.  There is a guy there
Jesse Nolle who knows his onions.

Stephen
-Original Message-
From: James Maltby [mailto:[EMAIL PROTECTED]]
Sent: 27 March 2002 13:07
To: CF-Talk
Subject: RE: Run SHELL


As far as I am aware cfexecute only runs on NT and UNIX platforms - whether
that means Linux I dunno - worth a try I guess - you can use the optional
ARGUMENTS syntax to pass command-line arguments to a program, elements of
the ARGUMENTS array is copied into a corresponding array of exec() arguments
on UNIX.

Dunno if this helps...

J

-Original Message-
From: romulogomes [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, March 27, 2002 10:03
To: CF-Talk
Subject: Run SHELL


Can I use cfexecute to run a linux shell file?



__
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: OT - large text file handling?

2002-02-19 Thread Stephen Galligan

Use Vi on a Unix box :)

-Original Message-
From: Ian Lurie [mailto:[EMAIL PROTECTED]]
Sent: 19 February 2002 16:42
To: CF-Talk
Subject: OT - large text file handling?


Hi all,

I've got a 400 meg text file. I need to remove the first 2/3 of the 
file.

I can't open it in any text editor without melting my computer. Does 
anyone
have a good tool/solution for this?

Thanks,

Ian Lurie

Portent Interactive
Using Process, Design and Content to create great web sites since 1995
Consulting, design, development, measurement
http://www.portentinteractive.com

__
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: Determine current version

2001-09-26 Thread Stephen Galligan

Hi there,

In Coldfusion output these:
Returns product name:   #Server.Coldfusion.ProductName#
Returns version number and if any service packs applied:
#Server.Coldfusion.ProductVersion#
Returns which type of product, either professional or enterprise:
#Server.Coldfusion.ProductLevel#


OS name:#Server.OS.Name#
OS service packs applied:   #Server.OS.AdditionalInformation#
OS version eg. 4.0 if running NT4:  #Server.OS.Version#

You can also find out your OS info in the registry:
At key HKEY_LOCAL_MACHINE\Software\Microsoft\WindowsNT\ CurrentVersion. 
Current Version key for the OS version 
CSDVersion key for the service pack version

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

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 26 September 2001 14:27
To: CF-Talk
Subject: Determine current version


I've got an interesting situation that includes checking what service pack
is installed on the Cold Fusion server.  Is there a way to check this?  I
have the version and everything like that, but we don't know if the Sp has
been applied (it's running 4.5.1 pro right now)

TIA!

C. Hatton Humphrey

~~
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: Determine current version

2001-09-26 Thread Stephen Galligan

Spot on!

Regards,
Stephen

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 26 September 2001 15:07
To: CF-Talk
Subject: RE: Determine current version


Thanks for the replies, that got the information I was looking for...

I'm assuming then that 4, 5, 1, 0 means 4.5.1 with no service packs applied?

C. Hatton Humphrey

 -Original Message-
 From: Stephen Galligan [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, September 26, 2001 9:47 AM
 To: CF-Talk
 Subject: RE: Determine current version


 Hi there,

 In Coldfusion output these:
 Returns product name: #Server.Coldfusion.ProductName#
 Returns version number and if any service packs applied:
 #Server.Coldfusion.ProductVersion#
 Returns which type of product, either professional or enterprise:
 #Server.Coldfusion.ProductLevel#


 OS name:  #Server.OS.Name#
 OS service packs applied: #Server.OS.AdditionalInformation#
 OS version eg. 4.0 if running NT4:#Server.OS.Version#

 You can also find out your OS info in the registry:
 At key HKEY_LOCAL_MACHINE\Software\Microsoft\WindowsNT\ CurrentVersion.
 Current Version key for the OS version
 CSDVersion key for the service pack version

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


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 Sent: 26 September 2001 14:27
 To: CF-Talk
 Subject: Determine current version


 I've got an interesting situation that includes checking what service pack
 is installed on the Cold Fusion server.  Is there a way to check this?  I
 have the version and everything like that, but we don't know if the Sp has
 been applied (it's running 4.5.1 pro right now)

 TIA!

 C. Hatton Humphrey

 

~~
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: Open Source Content Mananagent System

2001-08-22 Thread Stephen Galligan

Hi,

Yes zope is an Open Source web application server - cast your eyes over
www.zope.org . It is currently at version 2.4.0 for download.

Regards
Stephen

-Original Message-
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2001 14:55
To: CF-Talk
Subject: RE: Open Source Content Mananagent System

Isn't ZOPE more of an application server (like CF, Jrun, or ASP) than a
CMS?

---
Billy Cravens
Web Development, EDS
[EMAIL PROTECTED]


-Original Message-
From: Jared Clinton [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, August 21, 2001 6:54 PM
To: CF-Talk
Subject: RE: Open Source Content Mananagent System



Zope :  www.zope.org

Jared Clinton
NEC Australia

Subject: RE: Open Source Content Mananagent System
~~
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: ms sql to ms access

2001-08-22 Thread Stephen Galligan

DTS- Data Transformation Services.

These facilitate the importation and exportation of heterogeneous data
between many data formats - be they databases, spreadsheets and even text
files.

-Original Message-
From: Lorenzo Imperatrice [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2001 15:52
To: CF-Talk
Subject: RE: ms sql to ms access


what is DTS

tnx

L

-Original Message-
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: mercoledì 22 agosto 2001 15.49
To: CF-Talk
Subject: RE: ms sql to ms access


Can't you use DTS?

---
Billy Cravens
Web Development, EDS
[EMAIL PROTECTED]


-Original Message-
From: Lorenzo Imperatrice [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 22, 2001 3:44 AM
To: CF-Talk
Subject: OT: ms sql to ms access


Hi
Sorry for OT and for my english.
i have a sql script and i wont this to became an access db how can i
do to create a access db with a script for ms sql

tnx

L


Lorenzo Imperatrice
Project Manager
[EMAIL PROTECTED]
--
PROMOSnet s.r.l.
Firenze - Via A. di Duccio, 20/22
Tel. +39 055 7135176 - +39 055 7134740
Fax +39 055 7131634 - Cell. +39 347 6009781 [EMAIL PROTECTED]
www.promosnet.it
--
contatto immediato
~~
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: Open Source Content Mananagent System

2001-08-22 Thread Stephen Galligan

As regards Zope - look at this url:  www.zope.org 

ta,
Stephen


-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: 22 August 2001 16:08
To: CF-Talk
Subject: RE: Open Source Content Mananagent System


If Zope isn't an app server, what does it run on? Ie, Spectra runs on CF,
what about Zope?

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

Email: [EMAIL PROTECTED]
Yahoo IM : morpheus

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

 -Original Message-
 From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, August 22, 2001 10:30 AM
 To: CF-Talk
 Subject: RE: Open Source Content Mananagent System


  Isn't ZOPE more of an application server (like CF, Jrun, or
  ASP) than a
  CMS?

 No. It features role based security, online editing, lots of stuff.

 I looked at a year ago before we choose coldfusion, and it was a bit
 immature.

~~
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: Remove spaces

2001-08-15 Thread Stephen Galligan

Not all UK postcodes are 6 chars long. Some english postcodes are seven
charcters long e.g. SW10 0SZ is a location in Chelsea, London and WC2E 7PE
is Tavistock street in central London.

cheers
s

-Original Message-
From: Leon Oosterwijk [mailto:[EMAIL PROTECTED]]
Sent: 15 August 2001 13:59
To: CF-Talk
Subject: RE: Remove spaces


I know that both English and Dutch Zip codes are alpha-numeric and 6
characters long (minus spaces). 

-Original Message-
From: Rich Tretola [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 14, 2001 4:22 PM
To: CF-Talk
Subject: RE: Remove spaces


Can't do that because the US zips are 5 digits and international are 6.
Rich

-Original Message-
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 14, 2001 5:11 PM
To: CF-Talk
Subject: RE: Remove spaces


You could do a Replace(zipcode, ,,all) but I would suggest doing
client-side as well as server-side validation, and make it more robust
than just checking for spaces.  Check for length, all numbers, etc.

---
Billy Cravens
HR Systems, EDS
[EMAIL PROTECTED]


-Original Message-
From: Rich Tretola [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 14, 2001 3:59 PM
To: CF-Talk
Subject: Remove spaces


What function do I use to remove spaces in the middle of a string? I
have a zipcode field where international users are leaving spaces in the
zipcode which is causing errors in the shipping calculator. Thanks, Rich
~~
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: cross-posting: data type mismatch

2001-07-19 Thread Stephen Galligan

Hi,

It must be to do with the data type you have assigned for the number. If you
get 'Numeric value out of range' as an error it is probably because it is
out of range for a short integer(-32768 to 32767) or an
integer(-2,147,483,648 to 2,147,483,647 ) .  Try using a long or a double if
you want very long numbers.

I hope that helps
Stephen



-Original Message-
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: 19 July 2001 11:25
To: CF-Talk
Subject: cross-posting: data type mismatch


Hi guys,

Brain drain going on here. I am getting this error message with a simple
query:

Error Diagnostic Information
ODBC Error Code = 22005 (Error in assignment)

[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in
criteria
expression.

SQL = INSERT INTO tbl_test (testname, testnumber) VALUES ('will',
1333444545456)

Data Source = dsntest

This is the code:

cfquery datasource=liquidid-payments name=addtest
INSERT INTO tbl_test
(testname, testnumber)
VALUES ('#Form.testname#', #Form.testnumber#)
/cfquery

And the Access2000 db is set up as follows:

testname is a VARCHAR 510
testnumber is a INTEGER 4


I must have done hundreds of these kind of queries. They ALWAYS work, at
least I'm sure they do. I've tried putting '' around the value for
testnumber but then get an

ODBC Error Code = 22003 (Numeric value out of range)

[Microsoft][ODBC Microsoft Access Driver]Numeric value out of range (null)

Any ideas people??

Will Swain
Hot Horse Ltd
http://www.hothorse.com
e: [EMAIL PROTECTED]
t: 01273 675375
~~
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: Which OS to use? Win98 or WinME?

2001-07-13 Thread Stephen Galligan

Hi,

NT4.0 cannot be installed on a FAT32 partition as NT cannot natively
undertstand FAT32 partitions.  NT can only run on a FAT16 or an NTFS
partition.  WIN2k can however run on FAT32 and NTFS.  If you are running NT4
or Win2k then NTFS would make sense as it has far superior inherent security
features.

I personally would use win2k as my development platform - windoze 9*/ME just
don't cut the mustard!  BSODs are very rare sights when one uses Win2k.
ME/9* are not designed to be robust development OSs - they are for playing
games!

Stephen

-Original Message-
From: Ledwith, Brian [mailto:[EMAIL PROTECTED]]
Sent: 13 July 2001 15:10
To: CF-Talk
Subject: RE: Which OS to use? Win98 or WinME?


Dell sent me a laptop with NT4 preinstalled, on a FAT32 formatted drive,
making it blatantly obvious that manufacturers don't necessarily even boot a
computer before they ship it, so I'm not sure if I'd point the finger at
Compaq for the botched ME install on your Presario.

I recently bought a new home computer, and copies of 98se and 2000 with the
intention tossing the ME cd and create a dual boot system.  After 2 attempts
of installing and configuring 98, I ended up reinstalling ME.  Apache and CF
server work like a charm.  Granted, I haven't benchmarked the setup, it's
temporary, till a side project I'm working on is done.  Then I'll spend a
Saturday doing it right, 98 and/or 2000.

my .02

~bgl


-Original Message-
From: Russel Madere [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 13, 2001 9:10 AM
To: CF-Talk
Subject: RE: Which OS to use? Win98 or WinME?


We got a Compac Presario system for our QA Engineer on which to test our
product.  Right out of the box, the OS had to be reinstalled.  It has also
consistantly been a problem OS.  Even out Windows 95 test boxes have been
less troublesome.  I also installed it on my wife's computer after
purchasing an upgrade.  After 2 days she demanded I reload Windows 98.

I guess you have a good system for ME.  1Apparently it does not like the
systems I have deal with.

Russel

 -Original Message-
 From: G [mailto:[EMAIL PROTECTED]]
 Sent: Friday, July 13, 2001 7:29 AM
 To: CF-Talk
 Subject: Re: Which OS to use? Win98 or WinME?


 I've found this very interesting.  Many reviews i've heard about
 window's ME
 have been negative like this one.  However, it has been a God-send on my
 home PC.  Faster boots, fewer, as in almost none, reboots.  With
 windows 98,
 I was rebooting every couple of days.  It was also one of the cleanest and
 easiest upgrades I've been subjected too while in microsoft land.  After
 about 6 months of use, I'm YET to find a single bug.  I wonder
 what some of
 the subtle differences and nuances are in these systems that can
 cause such
 drastically different results with this OS??? Perhaps it's as
 simple as some
 people test the limits of an OS more so than othersI admit my home PC
 use is not nearly as intensive as work.

 Brian
 - Original Message -
 From: Russel Madere [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Thursday, July 12, 2001 3:38 PM
 Subject: RE: Which OS to use? Win98 or WinME?


  DON'T INSTALL Windows ME!!
 
  Sorry to scream, but we have it on a test box here and it is
 really buggy.
  Tell your friend to stick with Windows 98, especially if he
 wants to keep
  his techie friends.  I have almost lost my religion troubleshooting
 Windows
  ME.
 
  Russel
 
   -Original Message-
   From: Pooh Bear [mailto:[EMAIL PROTECTED]]
   Sent: Thursday, July 12, 2001 3:27 PM
   To: CF-Talk
   Subject: OT: Which OS to use? Win98 or WinME?
  
  
   hey guys, i have a friend who is doing small development stuff on
   his win 98
   box.  He wants to upgrade to the latest consumer version of
   windows (WinME),
   but wants to know if WinMe was more buggy than win98!  thanx!
  
 

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

2001-07-09 Thread Stephen Galligan

Kevin,

Addresses in the class A range 127.0.0.0 of network addresses have special
status, and are reserved for use as a loopback address (typically
127.0.0.1).  So if you are developing solely on your box then the only IP
address you will need is for the loopback interface, which is always
127.0.0.1.

However if your CFserver is located on a different box you should specify
the IP address of the server's NIC when you connect to it.  The version of
CFserver you are using does only accept one IP address connection.  I was
originally developing on the same box and when I tried connecting to that
box from a networked PC it gave the same error.  When this happened to me I
stopped coldfusion restarted it and then connected to CF using something
like http://194.168.0.1/CFIDE/administrator/ where the IP address is your
server's NIC address.
It then worked.  Hope that is of some help.

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

- -Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Parker,
Kevin
Sent: Friday, 6 July 2001 4:01 PM
To: CF-Talk
Subject: Server


Can someone please point me in the right direction here not being a
network
administrator.

I've got CF Server (single user dev version) installed on a dev box
and have
tried to connect to it from my desktop PC. It says that 127.0.0.1 is
logged
on and will only accept a single IP address. Fair enough - I expected
this.
I can't fire it up from my box because CF services start
automatically. Fair
enough - I've turned all the services to manual start but still no
luck
starting it form here. IIS is running on the box - I can fire it up
from my
desktop PC. What am I doing wrong or not doing?

TIA




Kevin Parker
Web Services Manager
WorkCover Corporation

[EMAIL PROTECTED]

www.workcover.com

p: +61 8 82332548
f: +61 8 82332000
m: 0418 806 166








This e-mail is intended for the use of the addressee only. It may 
contain information that is protected by legislated confidentiality
and/or is legally privileged. If you are not the intended recipient
you
are prohibited from disseminating, distributing or copying this
e-mail.

Any opinion expressed in this e-mail may not necessarily be that of
the
WorkCover Corporation of South Australia. Although precautions have
been taken, the sender cannot warrant that this e-mail or any files
transmitted with it are free of viruses or any other defect.

If you have received this e-mail in error, please notify the sender
immediately by return e-mail and destroy the original e-mail and any
copies.


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



JavaScript not working in cfm

2001-06-22 Thread Stephen Galligan

Any of you guys seen this before - I have a perfect working html page which
has some Javascript in it for rollovers.  As soon as I change the page to
..cfm the javascript doesn't work!!I get object not found.



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



~~
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: JavaScript not working in cfm

2001-06-22 Thread Stephen Galligan

We worked out the problem.  We had coldfusion comments surrounding the
JavaScript so it wasn't read!  It works now

Regards

-Original Message-
From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
Sent: 22 June 2001 14:25
To: CF-Talk
Subject: RE: JavaScript not working in cfm


post the code.

-Original Message-
From: Stephen Galligan [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 22, 2001 3:34 AM
To: CF-Talk
Subject: JavaScript not working in cfm


Any of you guys seen this before - I have a perfect working html page which
has some Javascript in it for rollovers.  As soon as I change the page to
cfm the javascript doesn't work!!I get object not found.



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

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



RE: [RE: CF on Linux]

2001-05-23 Thread Stephen Galligan

Or alternatively one could use MYSQLCLIENT.  We have running at work
MySQLGUI version 1.7

Stephen :)
-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: 16 May 2001 17:41
To: CF-Talk
Subject: Re: [RE: CF on Linux]


MySQL GUI:
link msaccess to the mysql database via ODBC and you have a GUI.


[EMAIL PROTECTED] wrote:
Actually for MySQL connectivity, check out:

http://dajoba.com/projects/mysqltool/

The tool is PERL driven, and web-based, but by far it is the best tool for
mysql connectivity I have ever used. I got it up and running internally in a
matter of minutes, and I commonly edit the source code to add features I
need.

Meanwhile, remember, when connecting to mysql from ColdFusion, you'll need
to remember to add users with the full hostname, so, if I was connecting
from Coldfusion on server 'bob' I'd add:

user: cfserver
host: bob.domain.com


(As a note, this is not an official macromedia endorsment, just me bein
helpful)

Jesse Noller
Linux Systems Lead
Macromedia, Inc.
[EMAIL PROTECTED]

Look, said Arthur, would it save you a lot of time if I just gave up and
went mad now?
-Douglas Adams Hitchhiker's Guide to the Galaxy


-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 16, 2001 8:58 AM
To: CF-Talk
Subject: RE: CF on Linux


 It isn't GUI driven like SQL server and Access. 

http://www.mysql.com/downloads/gui-clients.html
There is even an offical GUI.

 I know there are third party clients but we haven't 
 had the chance
 to test any.  

Dont whine then :-)
m2d is very good, and the offical GUI is also very useful.
~~
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: the big export...ColdFusion.NET?

2001-05-21 Thread Stephen Galligan

C# is basically a new language developed by Microsoft that has the
simplicity of Visual Basic but with all the power of C++.  It is an OO
language that offers garbage collection as Java does so no more I am
assuming no more pointers.  It also has simplified type declarations - a
bool can be true or false but can't be converted into other types.

ttfn
Stephen

-Original Message-
From: Paul Mone [mailto:[EMAIL PROTECTED]]
Sent: 19 May 2001 00:01
To: CF-Talk
Subject: RE: the big export...ColdFusion.NET?


What is C#?

-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 18, 2001 7:36 AM
To: CF-Talk
Subject: Re: the big export...ColdFusion.NET?


Michael, before you go and learn VB, realize that vb is morphing into
vb.net. Although the syntax is similar, the changes/improvements are quite
drastic. You may want to skip picking up a book on the old VB and
concentrate on learning the new stuff. Microsofts site is a great place to
start though.

bigfatsegue
The whole dotNet thing is very interesting... Microsofts try at interpreted
code, like java.
Which leads me to think back to Macromedia's repeatedly saying dotNet in the
press release that they were commited to dotNet.
It isn't too far of a stretch to say that Neo may be ported to dotNet, and
specifically C#, which is basically java anyway. The more I think about it,
the more I think it's a no brainer for Macromedia to do a C# port. It will
probably run much faster on Windows. The only risk would be confusing the
users as to which is better.

That's my random Friday thought. Anyone have any comments?
/bigfatsegue

jon
- Original Message -
From: Michael Lugassy [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, May 18, 2001 10:57 AM
Subject: Re: the big export


 thanks for the tip, paul!
 I keep seeing this learn VB tips and I was wondering -
 are there any good and quick resources on learning VB on the net?
something
 you know about??

 Michael.

 - Original Message -
 From: Paul Mone [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Friday, May 18, 2001 12:49 AM
 Subject: RE: the big export


 
  This is definately something I would consider off-line processing. In
  most cases, CF is not suitable for these types of tasks, espcially if
it's
 a
  task that you'll have to repeat on scheduled basis.  If this is a
one-time
  event (are you sure? :) ) then you can way the time for development vs.
 time
  of processing.
 
  one time operation?
 
  Developing it in CF is probably the quickest solution.  Won't be the
  quickest app in the world.
 
  recurring task?
 
  Do it in C, or even better, VB.  It would be quicker to develop this in
VB
  than C, and the performance increase that C would give you is probably
  negligible.  Writing an offline recurring task like this in CF would be
a
  mis-use of your CFServer's resources.
 
 
  ---
  Paul Mone
  Ninthlink Consulting Group
  [EMAIL PROTECTED]
  619.222.7082
 
 
  -Original Message-
  From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
  Sent: Thursday, May 17, 2001 9:49 AM
  To: CF-Talk
  Subject: the big export
 
 
  I need the fastest way to export 100s of 1000s of text
  files into a database. I need each file in a a new row like this:
  file1name, file1content
  file2name, file2content
 
  CF is too slow for this, what can I use?
 
  Thanks,
 
  -=Michael.
 

~~
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: Page Refreshing

2001-05-21 Thread Stephen Galligan

Hello,

You may wish to try using this snippet of code

hth
Stephen

!--- NO cache ---
CFSET gmt = gettimezoneinfo()
CFSET gmt = gmt.utcHourOffset
CFIF gmt EQ 0
   CFSET gmt = 
CFELSEIF gmt GT 0
   CFSET gmt = +  gmt 
/CFIF
CFHEADER NAME=Pragma VALUE=no-cache
CFHEADER NAME=Cache-Control VALUE=no-cache, must-revalidate
CFHEADER NAME=Last-Modified VALUE=#DateFormat(now(), 'ddd, dd mmm
')# #TimeFormat(now(), 'HH:mm:ss')# GMT#gmt#
CFHEADER NAME=Expires VALUE=Mon, 26 Jul 1997 05:00:00 GMT

-Original Message-
From: Kate Hillier [mailto:[EMAIL PROTECTED]]
Sent: 21 May 2001 16:59
To: CF-Talk
Subject: Page Refreshing


I need to force a refresh on a page when I return to it after doing a
postcode lookup routine.  I was wondering if there was a CF solution to this
as I have tried JavaScript and using meta tags and they don't seem to work.

Forgive me if this is an easy one for the list.

TIA

Kate
~~
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: defining french table in oracle

2001-05-18 Thread Stephen Galligan

Hi,

While language support depends on the database install, most installations
include support for Western European languages.   If you use the proper NLS
specifier and pass that to oracle then you can support languages with no
problem.

SELECT TO_CHAR(sale_date, 'Day DD Month  HH24:MI:SS') as nice_sale_date
FROM sales
WHERE sales_id=3939

This would return


-Original Message-
From: FARRAH NG [mailto:[EMAIL PROTECTED]]
Sent: 17 May 2001 20:03
To: CF-Talk
Subject: defining french table in oracle


Hi everybody,
Does anyone has the experience of creating a oracle database to store
french characters ?  Please give me advise of how to do this, if 
anyone has this experience before. 

thanks




--
Global Internet phone calls, voicemail, fax, e-mail and instant messaging.
Sign-up today at http://www.hotvoice.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



RE: defining french table in oracle

2001-05-18 Thread Stephen Galligan

Oops forgot to say the rest!

SELECT TO_CHAR(sale_date, 'Day DD Month  HH24:MI:SS') as nice_sale_date
FROM sales
WHERE sales_id=3939

This would return
Nice_sale_date
--
Wednesday 25 October   2000 00:16:13

if you do the same query and add the NLS specifier
SELECT TO_CHAR(sale_date,'Day DD Month 
HH24:MI:SS','NLS_DATE_LANGUAGE=FRENCH') as nice_sale_date
FROM sales
WHERE sales_id=3939

you get it in français

Nice_sale_date
--
Mercredi 25 Octobre   2000 00:16:13

Hth
s



-Original Message-
From: FARRAH NG [mailto:[EMAIL PROTECTED]]
Sent: 17 May 2001 20:03
To: CF-Talk
Subject: defining french table in oracle


Hi everybody,
Does anyone has the experience of creating a oracle database to store
french characters ?  Please give me advise of how to do this, if 
anyone has this experience before. 

thanks




--
Global Internet phone calls, voicemail, fax, e-mail and instant messaging.
Sign-up today at http://www.hotvoice.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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



RE: Welcome to Julia Computer Consulting!

2001-03-29 Thread Stephen Galligan



Ta Love for the spam,

-Original Message-
From: Julia Green [mailto:[EMAIL PROTECTED]]
Sent: 29 March 2001 12:12
To: CF-Talk
Subject: Welcome to Julia Computer Consulting!



This is to announce the new Julia Computer Consulting's Store...at
http://juliagreen.safeshopper.com

We're not quite ready yet, but a few more days, check back in for business.

If you are a new client or thinking of being one, click on our New Clients
section, and read away.  First and Second Consultations are free.  And we
offer the same reprogramming and programming web services we have for five
years.

An old client?? -- going to send that monthly check?  Don't write it out
yet!  There's a colorful section for you with explanations of the goals of
each of your organizations.  In a few days, our store will have checkwriting
privileges that just require you to void a check in your checkbook.  No
credit cards yet, we'll just start with the small stuff.

And finally, my famous self-programming ASP form that some of you have found
to be so helpful, don't waste check paper giving a $10 or $15 donation, or
reprogramming money for the form.  It'll all be there.

Of course, as in all new entries, there are snafus -- there's no shipping or
taxes involved in Julia Computer Consulting, so if it shows up as $0 on your
invoice, don't worry, it's only $0...

And the good news, 5% of all services, if you use the coupon I
generated...and if you have a friend or co-worker that could use my
services, please send them my way.

You are all on my List Management Program within safeshopper!  So feel
honored, even if you don't have much to give, give a $1 or so just to try it
out...

Welcome to Julia Computer Consulting!


Julia Green
Julia Computer Consulting
www.juliagreen.com
Email:  [EMAIL PROTECTED]
Phone:  617-926-3413
PO Box 279
Watertown MA  02471-0279
Fax:  413-771-0306
~~
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: CFFILE ACTION=copy and NAMECONFLICT

2001-03-23 Thread Stephen Galligan

Can't you use the 'MAKEUNIQUE' attribute with the CFFILE tag?

Steve

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



-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: 23 March 2001 12:57
To: CF-Talk
Subject: CFFILE ACTION="copy" and NAMECONFLICT


I'm using CFFILE to copy a file from one directory to another on the server.
What happens if the file already exists? It's telling me that I can't use
the NAMECONFLICT attribute when the ACTION is "copy":


Attribute set validation error in tag CFFILE

The tag has an invalid attribute combination: the value of the tag switch
attribute 'ACTION' which is now 'COPY' requires a different combination of
attributes. For the same switch attribute value the following unknown
attributes have been provided: (NAMECONFLICT).


Does it just automatically overwrite the file in the destination folder?
Have I got to use CFTRY and CATCH instead?

Seems nuts not to have this built into the CFFILE tag directly...


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

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

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