Comparing Dates Functions

2001-10-25 Thread Paige Chandler

Hello All,

I'm having difficulty comparing a date range to DateLastModified, 
returned from CFDirectory. I've explored most of the date functions but 
can't find the function and syntax to do the job. Any help would be 
appreciated. TIA. Have a nice day.

Regards,

Paige

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



AS400 Stored Procedure without using CFSTOREDPROC?

2001-10-25 Thread Nathan Stanford

CFSTOREDPROC PROCEDURE=ASTDTCCK.TESTPRC14 DATASOURCE=ork DEBUG=Yes 
  CFPROCPARAM TYPE=IN cfsqltype=CF_SQL_CHAR VALUE=12345678
variable=dealer_number 
  CFPROCPARAM TYPE=INOUT cfsqltype=CF_SQL_CHAR VALUE=ABCDEFG
variable=price 
/CFSTOREDPROC  

The above stored proc works against the AS400.  How can I do the same thing
but without using the cfstoredproc tag?

cfquery name=test datasource=ork

What would I put here?

/cfquery


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: Access Default values

2001-10-25 Thread Aidan Whitehall

 You can set the default value of a field in an Access table's design 
 view.

He wanted to set default values as part of a CREATE TABLE statement.



-- 
Aidan Whitehall [EMAIL PROTECTED]
Macromedia ColdFusion Developer
Fairbanks Environmental +44 (0)1695 51775


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

2001-10-25 Thread Alistair Davidson

Michael

Try

REReplace( string, .*(URL=)([^[:space:]]+).*, \2 )

A loose translation -

1) look for any character (.) any number of times(*), followed by
2) the string URL=, followed by
3) anything other than a space ([^[:space:]]), at least once (+)
4) Replace that whole lot with whatever bit of the string matched part 3.

Hope that helps

Alistair Davidson
Senior Developer
Rocom New Media
www.rocomx.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: Comparing Dates Functions

2001-10-25 Thread Joseph DeVore

This code should help you out.

You can compare the dates down to the second.
The function datecompare has an optional parameter (It's the precision of
the comparison)

The parameter can have any of the following values:
  sPrecise to the second
  nPrecise to the minute
  hPrecise to the hour
  dPrecise to the day
  mPrecise to the month
  Precise to the year


cfdirectory action=list filter=*.* directory=c:\ name=directory

cfoutput query=directory
cfscript
// set your date either dynamically or statically below
mydate = now();

// compare mydate to directory.datelastmodified
comparison = datecompare(dateformat(mydate,'m/dd/'),
dateformat(datelastmodified,'m/dd/'));
/cfscript

!--- output results of comparison ---
cfif comparison eq -1
date1 is less than date2
cfelseif comparison eq 0
date1 is equal to date2
cfelseif comparison eq 1
date1 is greater than date2
/cfif
br
/cfoutput



Joseph DeVore
VeloxWeb Technologies




-Original Message-
From: Paige Chandler [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 24, 2001 5:36 PM
To: CF-Talk
Subject: Comparing Dates Functions


Hello All,

I'm having difficulty comparing a date range to DateLastModified,
returned from CFDirectory. I've explored most of the date functions but
can't find the function and syntax to do the job. Any help would be
appreciated. TIA. Have a nice day.

Regards,

Paige


~~
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: Checking file size before upload.

2001-10-25 Thread Tilbrook, Peter

I don't thinks so. At least not with CF as standard.

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

http://www.anzfa.gov.au

-Original Message-
From: Lon Lentz [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 24 October 2001 6:07
To: CF-Talk
Subject: Checking file size before upload.


  Is there a way to check the size of a file before the server 
CFFile-Uploads it?



Lon Lentz
Applications Developer and CyberEntomolgist
http://Proof-it-Online.Com - Free 15 Day Trial

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



Server Installation Question

2001-10-25 Thread Kevin Mansel

When setting up cf 4.5, do you have to stop the IIS service?Or does it
stop the IIS service?   And do you have to reboot after the installation is
complete?   Just wondering if anyone knows this stuff off the top of their
head.

Thanks,

Kev

~
Kevin Mansel
Senior Web Developer
Fox Communications
[EMAIL PROTECTED]
DL : 425-649-1321
C : 425-346-7221

~~
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: Running app from server...HELP!

2001-10-25 Thread James Sleeman

At 01:51 AM 10/24/2001, you wrote:
Hi,

I've posted this before but I'm at a dead end. I have no idea how to go
about this.

I'm listing files in a directory on my server. All files are wrapped with
a href.../a. What I want to happen is when a user clicks on a file I
want that file opened in an editor on the client PC (not the server). In my
case, UltraEdit.

What a file is opened with is a matter of configuration for the browser, 
not something that the server can dictate to the browser.  All you can do 
is supply the file using CFCONTENT with an appropriate mime-type for the 
file.  If the user has got their default editor for that type set the way 
you want it then you are sweet.



--
James Sleeman
Innovative Media Ltd
Phone: (03) 377 6262
http://www.websolutions.co.nz/

CAUTION: The information contained in this email message is confidential 
and may be legally privileged. If the reader of this message is not the 
intended recipient you are notified that any use, dissemination, 
distribution or reproduction of this message is prohibited. If you have 
received this message in error please notify the sender immediately and 
destroy the original message and any attachments.

Views expressed in this communication may not be those of Innovative Media 
Ltd.

~~
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 to auto generate images?

2001-10-25 Thread James Sleeman

Hunt around for the CFX_IMAGE tag, it might not be on the developers 
exchange so a google search is in order... 
http://www.google.com/search?q=cfx_image

At 06:45 AM 10/24/2001, you wrote:
Does anyone know how to dynamically generate formatted images.

i.e.

1. A client fills out a web site banner name in a form and presses submit
2. That automatically generates the banner image, with formatting rules like
drop shadow, etc.

I know Macromedia Generator does this, but its a very heavy price to pay in
terms of server load and up front costs.

Are there any other good alternatives?





--
James Sleeman
Innovative Media Ltd
Phone: (03) 377 6262
http://www.websolutions.co.nz/

CAUTION: The information contained in this email message is confidential 
and may be legally privileged. If the reader of this message is not the 
intended recipient you are notified that any use, dissemination, 
distribution or reproduction of this message is prohibited. If you have 
received this message in error please notify the sender immediately and 
destroy the original message and any attachments.

Views expressed in this communication may not be those of Innovative Media 
Ltd.

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



When is a cookie set in the browser

2001-10-25 Thread Aidan Whitehall

When setting a cookie in a page that throws a ColdFusion error, the cookie
doesn't get set in the browser.

Why is that? Does the instruction to the cookie not get sent until the page
is successfully parsed?



Thanks

-- 
Aidan Whitehall [EMAIL PROTECTED]
Macromedia ColdFusion Developer
Fairbanks Environmental +44 (0)1695 51775


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

2001-10-25 Thread Owens, Howard

Try:

SELECT*
FROM  messages
WHERE message_date = #CreateODBCDate(attributes.datebox)#



H.



Howard Owens
Internet Operations Coordinator
www.insidevc.com
[EMAIL PROTECTED]
AIM: GoCatGo1956


 -Original Message-
 From: Greg Luce [SMTP:[EMAIL PROTECTED]]
 Sent: Thursday, October 18, 2001 5:45 PM
 To:   CF-Talk
 Subject:  Access Question
 
 I haven't used access much, so I'm sure this is going to sound dumb, but
 can you think of a reason that I get 0 records for this query when I can
 see there's a record in the db with a date of 10/18/2001?
 SELECT*
 FROM  messages
 WHERE message_date = #attributes.datebox#
 The debugging shows:
 SQL = SELECT * FROM messages WHERE message_date = 10/18/2001
 
 If I use single quotes around #attributes.datebox# it gives me an error
 saying datatype mismatch.
 
 
~~
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



Tracking time in CF

2001-10-25 Thread Mike Tangorre

Hi everyone.

I am trying to find a way on how to do the following securely.
I have a website that has 4 chat rooms.
Chat Room A = $0.50/minute
Chat Room B = $0.60/minute
Chat Room C = $0.70/minute
Suppose when people sign up they prefill their account with X amount of
dollars.
Is there a way in CF to monitor time on a certain page and compare it to the
total
amount of time available for the room based on the number of dollars
available in the account... then
if they run out of money direct them to the order time page...?

Any help would be appreciated.  I thought maybe Javascript might be of use
but wuld it not be easy to hack???  For instance:

Get the dollar total form the DB, divide it by the price of the room you
enter...store that value in a variable, then set a counter to count down
from the total available time...when the counter hits 0 refresh them to a
page... if they logout, take the value of counter and refigure money
available and store it back into the db  AM i all confused or what?  :-)

Thanks for any help,

Mike
~~
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: Access Question

2001-10-25 Thread David Green

This is what works for me.   I don't know if it's the best way but it seems
to work fine with access and ODBC drivers.

Good Luck
David

DT = #CREATEODBCDATE(FORM.P_DATE)#

- Original Message -
From: Greg Luce [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, October 18, 2001 5:43 PM
Subject: Access Question


 I haven't used access much, so I'm sure this is going to sound dumb, but
 can you think of a reason that I get 0 records for this query when I can
 see there's a record in the db with a date of 10/18/2001?
 SELECT*
 FROM  messages
 WHERE message_date = #attributes.datebox#
 The debugging shows:
 SQL = SELECT * FROM messages WHERE message_date = 10/18/2001

 If I use single quotes around #attributes.datebox# it gives me an error
 saying datatype mismatch.

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



Default Value for CFTree

2001-10-25 Thread Ulf Unger

Hi,

I have a table with categories stored with their id and parent_id. I would
like to use CFTree to show the category tree in an Input / Update form. In
the input form there is no problem - but how can I provide a default value
to cfree in an update form to show the selected category. I couldn't find
any attribute in the cftree tag. But it must be possible to provide a
default value, because in the data source selection in CF Administrator
there can be a datasource preselected (if you would like to update your
information to a existing data source).

Is there an undocumented attribute available to do this?

Thanks for hints.

Ulf
~~
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: Running app from server...HELP!

2001-10-25 Thread phumes1

I have the following lines of code to open a file from the server on the 
client PC using ultraedit.

cfheader name=Content-Disposition value=filename=#FileName#
cfcontent type=text/plain file=#DirPath#\#FileName# deletefile=No

It works great (Thanks Dave) except for a few things. For example, when I 
open the file cover.dat in ultraedit it names it as cover[1].dat and 
the path in the ultraedit window is C:\Windows\Temporary Internet 
Files\Content.IE5\ECX72406\cover[1].dat

Is there anyway to change this display in the top window banner?
~~
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



Macromedia/Allaire Knowledge Base

2001-10-25 Thread Tracy Bost

 I'm am very frustrated with the Knowledge Base at Macromedia/Allaire.
 If it wasn't for posting a problem here or doing a search through the CF
Talk archives, I would have
ditched ColdFusion a long time ago. Its just when this list is down, that
something like that is appreciated.
One would think Macromedia/Allaire would take the Knowledge Base section
of their web site a lot more serious.
 As much as I dislike microsoft's products, they do have a great knowledge
base, and makes the problems easy to find in the searches.






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

2001-10-25 Thread Greg Luce

Like I said earlier:

If I use single quotes around #attributes.datebox# it gives me an error
saying datatype mismatch.

I just disregarded using access and made a SQL Server db for it. It
works in SQL Server.
 
Greg Luce
954-763-4504

It's doing the math.  It thinks 10/18/2001 is 10 divided by 18 divided
by
2001.  Use single quotes.


 

Bryan Love Macromedia Certified Professional
Internet Application Developer / Database Analyst
Telecommunication Systems Inc.
[EMAIL PROTECTED]
 

What father would hesitate to say 'if there must be trouble let it be
in my
day, that my child may have peace'?
- Thomas Paine, An American Crisis



-Original Message-
From: Greg Luce [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 18, 2001 5:43 PM
To: CF-Talk
Subject: Access Question


I haven't used access much, so I'm sure this is going to sound dumb, but
can you think of a reason that I get 0 records for this query when I can
see there's a record in the db with a date of 10/18/2001?
SELECT*
FROM  messages
WHERE message_date = #attributes.datebox#
The debugging shows:
SQL = SELECT * FROM messages WHERE message_date = 10/18/2001

If I use single quotes around #attributes.datebox# it gives me an error
saying datatype mismatch.



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



Declare a variable as a string in SQL

2001-10-25 Thread Dusty Tinashe Shoko

How do I declare a variable as a string in SQL?
I want to create tables dynamically in Coldfusion  and Access and some 
of the input will be huge amounts of text

 And when we think we getting a lil stronger
 Thats when we weakest of all!!
 We think we're holding onto something special
 That very thing makes us fall
 - Honeyz - Just Let It Go.MP3


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.286 / Virus Database: 152 - Release Date: 10/9/01

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



Multiple request scopes?

2001-10-25 Thread Mike Kear

The request scope, as I understand it, contains variables that are available
for all templates executing from one page, including any included templates.

But what happens if two users are simultaneously executing the same page?
Are there two copies of the request scope?  Or do they share the same set of
variables?  (In which case you can't use user variables in the  request
scope)

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



WDDX question

2001-10-25 Thread Neil Clark

WDDX will support any type of variable/char thrown at it, it is simply XML.

Regads

Neil 
Team Macromedia

~~
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: Multiple request scopes?

2001-10-25 Thread Craig Dudley

The request scope exists on a per http request basis, ie the variables in
the request scope only exist while the webs server/application server are
completing that single request.They die immediatley CF has finished
processing the request.

If your'e server is set up to process 5 maximum simultanious connections,
then in theory there could be 5 sets of request variables in server memory
but they are tied to a particular request and cannot exist in another page
request unless you copy them into another scope.

I think the answer to your question is nothing will happen if two users are
simultaneously executing the same page, the pages should execute normally.
Request scope variables do not need locking as a session variable would.

Hope that helps a bit.

Cheers, Craig.

-Original Message-
From: Mike Kear [mailto:[EMAIL PROTECTED]]
Sent: 25 October 2001 10:04
To: CF-Talk
Subject: Multiple request scopes?


The request scope, as I understand it, contains variables that are available
for all templates executing from one page, including any included templates.

But what happens if two users are simultaneously executing the same page?
Are there two copies of the request scope?  Or do they share the same set of
variables?  (In which case you can't use user variables in the  request
scope)

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



cfmail and more than 1 cc problem

2001-10-25 Thread Seamus Campbell

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 Will Swain

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

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



Updating an XML file so Flash can use it

2001-10-25 Thread Jeff Green

Hi all,

I have a client that needs CF to update an XML file that flash reads to
display info.

I was wondering if anyone has any tips, tags, or advice to help get me
started on my project of updating his existing XML file.

Also, I know that CF supports WDDX, which is a dialect of XML, I was
wondering if Flash can read this dialect of XML.  If so I assume that this
would make the project very easy.

The XML file is below.  I suppose I could use CFFile to make the changes I
need, but I figure there is a more XML supported way ;)
Basically, I have to ad article elements to the file.

Thanks in advance,
Jeff

?xml version=1.0 ?
moreovernews
article
 headline_textThis is a headline/headline_text
 urlhttp://www.theurl.com/url
/article
article
 headline_textAnother headline/headline_text
 urlhttp://www.anotherurl.com/flash4page.html/url
/article
moreovernews

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



Displaying Word Docs with CF -- Urgent!!!

2001-10-25 Thread Ianv2

Hi Fellow Developers.

I wish to display MS Word docs in an html page/browser via Coldfusion. These word docs 
are currently stored in BLOBS in an Oracle 8 database,

Is this achieveable and what is the process to achieve this? 
~~
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: cfmail and more than 1 cc problem

2001-10-25 Thread Seamus Campbell

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



Oracle and CF

2001-10-25 Thread Simon Whittaker

hello there,

I am having some trouble connecting ColdFusion to an Oracle Datasource on a
different machine. It seems that we may be missing a driver somewhere along
the line but am not exactly sure what to do next - does anyone have any
advice?

Also, what are the major differences between Oracle and MSSQL server 7. Will
I need to make any coding changes or should everything be okay.

And one final thing, how difficult is it to link into Oracle from SQL?

Some Basic Questions I know but Oracle is not my strong point.

I hope you can help

Best Regards

Simon

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



HTTP Posts with a java cfx

2001-10-25 Thread Craig Dudley

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.

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

my bad, you are absolutely right.

just tried it with the commas too and it works fine for me.



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


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: Updating an XML file so Flash can use it

2001-10-25 Thread Joseph DeVore

Jeff,

You could use SOXML, it provides ColdFusion programmers with an easy to use
interface for integration of XML with CF.

This custom tag is open-source (of course), free, and action based.

These actions include:
• XML2CF (Converts a XML document into a complex CF structure)

• XML2DOM (Loads the XML document into a valid XML DOM object accessed via
CF)

• XML2HTML (Displays the XML document as IE does but INLINE! very cool for
debugging)

• CF2XML (Transforms any CF variable into a valid XML document)

• CF2XMLDOM (Transforms any CF variable into a valid XML DOM object
accessible with CFML)

• Transform (Transforms any XML document based on a specified XSL document)

http://www.siteobjects.com/index.cfm?fuseAction=showproducts#soxml


Joseph DeVore
VeloxWeb Technologies




-Original Message-
From: Jeff Green [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 23, 2001 3:48 PM
To: CF-Talk
Subject: Updating an XML file so Flash can use it


Hi all,

I have a client that needs CF to update an XML file that flash reads to
display info.

I was wondering if anyone has any tips, tags, or advice to help get me
started on my project of updating his existing XML file.

Also, I know that CF supports WDDX, which is a dialect of XML, I was
wondering if Flash can read this dialect of XML.  If so I assume that this
would make the project very easy.

The XML file is below.  I suppose I could use CFFile to make the changes I
need, but I figure there is a more XML supported way ;)
Basically, I have to ad article elements to the file.

Thanks in advance,
Jeff

?xml version=1.0 ?
moreovernews
article
 headline_textThis is a headline/headline_text
 urlhttp://www.theurl.com/url
/article
article
 headline_textAnother headline/headline_text
 urlhttp://www.anotherurl.com/flash4page.html/url
/article
moreovernews


~~
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: Displaying Word Docs with CF -- Urgent!!!

2001-10-25 Thread Joseph DeVore

You need to use cfcontent with the type=application/msword or
application/rtf


Joseph DeVore
VeloxWeb Technologies



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 2:34 AM
To: CF-Talk
Subject: Displaying Word Docs with CF -- Urgent!!!


Hi Fellow Developers.

I wish to display MS Word docs in an html page/browser via Coldfusion. These
word docs are currently stored in BLOBS in an Oracle 8 database,

Is this achieveable and what is the process to achieve this?

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

2001-10-25 Thread Joseph DeVore

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



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

2001-10-25 Thread Tony Gruen

Try ...

WHERE message_date = '#attributes.datebox#'

-Original Message-
From: Greg Luce [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 18, 2001 5:45 PM
To: CF-Talk
Subject: Access Question


I haven't used access much, so I'm sure this is going to sound dumb, but
can you think of a reason that I get 0 records for this query when I can
see there's a record in the db with a date of 10/18/2001?
SELECT*
FROM  messages
WHERE message_date = #attributes.datebox#
The debugging shows:
SQL = SELECT * FROM messages WHERE message_date = 10/18/2001

If I use single quotes around #attributes.datebox# it gives me an error
saying datatype mismatch.


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

2001-10-25 Thread nagraj

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.

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

2001-10-25 Thread Craig Dudley

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.

 

~~
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: Updating an XML file so Flash can use it

2001-10-25 Thread Rich Wild

Jeff,

like Joseph said, there are the SOXML options to go down to alter your XML
file - but you should be aware that Flash currently processes pure text
variable files much quicker than XML files. This was an issue that
Figleaf/Allaire/Macromedia came across during the development of the Flash
Component Kit for Coldfusion (Harpoon) , and is why this component kit
doesn't use xml to pass variables to its flash movies.

To this end - we create text files in CF with cffile or cfcontent which are
read in by our flash movies rather than use XML. We've found that with the
applications we did, the text files would be at least a whole second
quicker, but you make experience different results depending on your flash
app.

Rich Wild


 -Original Message-
 From: Jeff Green [mailto:[EMAIL PROTECTED]]
 Sent: 23 October 2001 23:48
 To: CF-Talk
 Subject: Updating an XML file so Flash can use it
 
 
 Hi all,
 
 I have a client that needs CF to update an XML file that 
 flash reads to
 display info.
 
 I was wondering if anyone has any tips, tags, or advice to help get me
 started on my project of updating his existing XML file.
 
 Also, I know that CF supports WDDX, which is a dialect of XML, I was
 wondering if Flash can read this dialect of XML.  If so I 
 assume that this
 would make the project very easy.
 
 The XML file is below.  I suppose I could use CFFile to make 
 the changes I
 need, but I figure there is a more XML supported way ;)
 Basically, I have to ad article elements to the file.
 
 Thanks in advance,
 Jeff
 
 ?xml version=1.0 ?
 moreovernews
 article
  headline_textThis is a headline/headline_text
  urlhttp://www.theurl.com/url
 /article
 article
  headline_textAnother headline/headline_text
  urlhttp://www.anotherurl.com/flash4page.html/url
 /article
 moreovernews
 
 
~~
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



Oracle and CF

2001-10-25 Thread John Forrester

First to respond to the question about Oracle and CF. We have found that CF
on Windows platform with ODBC drivers linking with Oracle DB on Windows or
Linux boxes had few problems once we chose the native drivers from Oracle.
The principal problem with connecting to an Oracle db was the connection to
the correct library and getting the net8 files correct - particularly with
Linux files.

Where we have fallen afoul is the management of characters with accents
using CF Entreprise 4.5.1 SP2.  For some reason asking users to input city
names, for instance, on Windows boxes creates few problems. As soon as we
use the same scripts (see the following) on Linux boxes the search comes
back empty when any name with an accent mark has been inserted. The debug
report from CF shows the select formatted correctly. In effect, the select
seems to be formulated correctly but arrives on Oracle translated badly ...
that the characters with accents are incorrectly reported.

 Using SQL+ of Oracle I checked the DB - everything is correct on the DB
(accents, etc.).  Oracle's logs show the select attempted in remote as
incorrect basically because the accented characters are incorrect.

The Linux systems all respond to the command locale CR indicating italian
as the principal language.

Select seq, nome_progetto, localita_area
FROM
innovazioni
WHERE
nome_progetto IS NOT NULL AND
tipo_ente = '01'

AND LOWER(Localita_area) LIKE '%citt` di castello%'

We would be certainly interested if anyone has any idea why a Linux system
does not manage accented characters like the Windows.

John Forrester
Senior Networking e Systems Engineer
Ancitel Spa
Tel: +39-06-76291206
Cell: +39-0348-7972041
Fax: +39-06-76291328

email: [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



Problem with database insert

2001-10-25 Thread Lee Bailey - Element2 Limited

Hi all,

I have a form which includes a file field, however this is an optional field
for the user.  The 'insert.cfm' page checks to see if the user has selected
a file and if so gets the name of it and all the other form data and inserts
it into a database.  The problem I'm having is what code I need to use as an
'else' (if the user hasn't selected a file to upload) - everything I've
tried so far is giving me an access violation.  Code for the 'insert.cfm'
page is belowany help would really be appreciated!

Thanks,

Lee


!--- Upload File Attachment, check if user has selected a file first ---
cfif Len(Trim(form.file_rfq)) GT 0
CFFILE action=UPLOAD FILEFIELD=file_rfq
DESTINATION=d:\webserver\mysite\www\uploads\ NAMECONFLICT=makeunique
/cfif
!--- End Insert ---
!--- SQL Insert Statement - After Upload  If user selected a file to
upload ---
cfif Len(Trim(form.file_rfq)) is not 0
CFQUERY DATASOURCE=datasourcename
INSERT INTO rfqs(rfq_fullname,
 rfq_companyname,
 rfq_email,
 rfq_tel,
 project_name,
 project_scope,
 budget,
 timescale,
 file_rfq)
VALUES('#Trim(FORM.rfq_fullname)#',
  '#Trim(FORM.rfq_companyname)#',
  '#Trim(FORM.rfq_email)#',
  '#Trim(FORM.rfq_tel)#',
  '#Trim(FORM.project_name)#',
  '#Trim(FORM.project_scope)#',
  '#Trim(FORM.budget)#',
  '#Trim(FORM.timescale)#',
  '#Trim(CFFILE.SERVERFILE)#')

/CFQUERY
/cfif

~~
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: Problem with database insert

2001-10-25 Thread Craig Dudley

Try this lee.

!--- Upload File Attachment, check if user has selected a file first ---
cfif Len(Trim(form.file_rfq)) GT 0
CFFILE action=UPLOAD FILEFIELD=file_rfq
DESTINATION=d:\webserver\mysite\www\uploads\ NAMECONFLICT=makeunique
cfset uploadedfilename = CFFILE.SERVERFILE
cfelse
cfset uploadedfilename = 
/cfif
!--- End Insert ---

!--- SQL Insert Statement - After Upload  If user selected a file to
upload ---
CFQUERY DATASOURCE=datasourcename
INSERT INTO rfqs(rfq_fullname,
 rfq_companyname,
 rfq_email,
 rfq_tel,
 project_name,
 project_scope,
 budget,
 timescale,
 file_rfq)
VALUES('#Trim(FORM.rfq_fullname)#',
  '#Trim(FORM.rfq_companyname)#',
  '#Trim(FORM.rfq_email)#',
  '#Trim(FORM.rfq_tel)#',
  '#Trim(FORM.project_name)#',
  '#Trim(FORM.project_scope)#',
  '#Trim(FORM.budget)#',
  '#Trim(FORM.timescale)#',
  '#Trim(uploadedfilename)#')
/CFQUERY




-Original Message-
From: Lee Bailey - Element2 Limited [mailto:[EMAIL PROTECTED]]
Sent: 25 October 2001 11:39
To: CF-Talk
Subject: Problem with database insert


Hi all,

I have a form which includes a file field, however this is an optional field
for the user.  The 'insert.cfm' page checks to see if the user has selected
a file and if so gets the name of it and all the other form data and inserts
it into a database.  The problem I'm having is what code I need to use as an
'else' (if the user hasn't selected a file to upload) - everything I've
tried so far is giving me an access violation.  Code for the 'insert.cfm'
page is belowany help would really be appreciated!

Thanks,

Lee


!--- Upload File Attachment, check if user has selected a file first ---
cfif Len(Trim(form.file_rfq)) GT 0
CFFILE action=UPLOAD FILEFIELD=file_rfq
DESTINATION=d:\webserver\mysite\www\uploads\ NAMECONFLICT=makeunique
/cfif
!--- End Insert ---
!--- SQL Insert Statement - After Upload  If user selected a file to
upload ---
cfif Len(Trim(form.file_rfq)) is not 0
CFQUERY DATASOURCE=datasourcename
INSERT INTO rfqs(rfq_fullname,
 rfq_companyname,
 rfq_email,
 rfq_tel,
 project_name,
 project_scope,
 budget,
 timescale,
 file_rfq)
VALUES('#Trim(FORM.rfq_fullname)#',
  '#Trim(FORM.rfq_companyname)#',
  '#Trim(FORM.rfq_email)#',
  '#Trim(FORM.rfq_tel)#',
  '#Trim(FORM.project_name)#',
  '#Trim(FORM.project_scope)#',
  '#Trim(FORM.budget)#',
  '#Trim(FORM.timescale)#',
  '#Trim(CFFILE.SERVERFILE)#')

/CFQUERY
/cfif


~~
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: Problem with database insert

2001-10-25 Thread Lee Bailey - Element2 Limited

Perfect! Thanks Craig, much appreciated :-)


~~
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: Submitting forms without showing the action pages

2001-10-25 Thread Angel Stewart

Hmm..
Ok.

So say you are at Page 1, and you then want to go to Page 2, but Page
1's data must be processed by Page1_Action.cfm 

You can use CFINCLUDE template=Page1_Action.cfm at the very top of
Page 2, to run the action page, but still display Page 2.

Do the same thing with page 3..etc. etc. providing those Action pages
don't have to display anything to the user, just do some database
processing, validation etc. 

-Gel


-Original Message-
From: Tom Jacobs [mailto:[EMAIL PROTECTED]] 

This is probably simple, but I'm new to CF and HTML so it's not obvious.

I am creating a questionnaire composed of a series of forms with several

questions on each. After a user answers each of the questions and clicks

the Submit button, I want to go directly to the next page of questions 
without showing the action page.

I also want to verify that the user has answered all the questions on 
each page and re-present a page if necessary. It seems that I need an 
action page with a CFIF tag that would redirect to the previous page or 
submit the data and redirect to the next page.

I know this is done all the time, but I'm not clear what the most 
efficient method is.

Tom
-
|   Tom Jacobs  |
|   InterVision |
|   www.intervisionmedia.com|
|   541-343-7993|
-


~~
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: 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: AS400 Stored Procedure without using CFSTOREDPROC? - Anyone?

2001-10-25 Thread Nathan Stanford

Can you not do it any other way?

-Original Message-
From: Nathan Stanford [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 24, 2001 7:59 AM
To: CF-Talk
Subject: AS400 Stored Procedure without using CFSTOREDPROC?


CFSTOREDPROC PROCEDURE=ASTDTCCK.TESTPRC14 DATASOURCE=ork DEBUG=Yes 
  CFPROCPARAM TYPE=IN cfsqltype=CF_SQL_CHAR VALUE=12345678
variable=dealer_number 
  CFPROCPARAM TYPE=INOUT cfsqltype=CF_SQL_CHAR VALUE=ABCDEFG
variable=price 
/CFSTOREDPROC  

The above stored proc works against the AS400.  How can I do the same thing
but without using the cfstoredproc tag?

cfquery name=test datasource=ork

What would I put here?

/cfquery


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

2001-10-25 Thread Seamus Campbell

Many thanks - this worked fine.
I think there is something wrong with my ISP's mail server as I have just 
sent myself an email with 2 cc's and only get 2 of the 3 emails back
I'll ring my ISP tomorrow
Thanks to everyone who replied
Seamus



At 08:12 pm 25/10/01 , you wrote:
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
 
 


~~
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: 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: SQL question grouping, ordering, sorting

2001-10-25 Thread Alistair Davidson

Willy 

Try something like -

SELECT TOP 10
(table).searchstring,
'NoSearches' = COUNT( tableAlias.ID )

FROM (table) INNER JOIN (table) tableAlias
ON (table).searchstring = tableAlias.searchstring

GROUP BY (table.searchstring)

ORDER BY COUNT( tableAlias.ID ) DESC

( replace (table) with your table name )

That should do it - for each row in (table) it will return all rows with the
same searchstring, and the COUNT function used with the GROUP BY clause will
'roll-up' the results

HTH

Alistair Davidson
Senior Developer
Rocom New Media
www.rocomx.net
There Is No Spoon


-Original Message-
From: Willy Ray [mailto:[EMAIL PROTECTED]]
Sent: 22 October 2001 16:07
To: CF-Talk
Subject: SQL question grouping, ordering, sorting


Ok, I have a database of search strings with which users of the site have 
hit my search engine.  I want to build a viewer so I can go in and see 
what people are doing without actually cracking into the database.  My 
database isn't doing anything fancy.  It's one table, consisting, 
essentially, of id, searchstring, casesensitive...

What I want is to be able to query the database, and display the 10 or 15 
most searched strings.  I'm just not sure how to go about it.

I can

GROUP BY searchstring

that get's me close, and culls out duplicate strings, but I don't know how 
I'd get from there to 

top 5 strings:

1. Happy and Go and Lucky (16 searches)
2. Moo Cow (10 searches)
3. etc.
4. etc.

Any thoughts?

Willy Ray

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



RE: client wants online credit card processing

2001-10-25 Thread Bud

On 10/18/01, Matt Robertson penned:
Thats a valid point.  real time cc processing isn't cheap, and 
generally is the wrong answer for a small business with an unproven 
web business model.  Most of my clients don't use it, instead doing 
exactly what Paris mentions.  Once they can't keep up with all of 
the orders, then its time to spring the bucks for cc processing.

Well, that sort of depends. If the client already has a brick and 
mortar business and accepts credit cards and is able to use their 
existing merchant account with their new e-store, then yes, I tell 
them to wait until they're sure that their online business is going 
to fly. On the other hand, if they are establishing a new merchant 
account, then they are going to have to pay upwards of 400 bucks for 
the terminal software, then again pay another 400+ dollars setup fee 
to go real time. Figuring the monthly fee for most real time 
transaction services is only about 15 bucks per month, if they're 
likely to go real time in less than 2 years, then they're better off 
bypassing the terminal software costs. Then there are also no changes 
to make to their shopping cart when that happens.
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.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: Percent calculation

2001-10-25 Thread Bud

On 10/19/01, Tilbrook, Peter penned:
Hi there!

I need to find the percentage of a value in ColdFusion but have been
getting inconsistent results.

eg:

Initial Weight: 250 grams
Weight Change: 10.7%
Final Weight (would be 250 grams plus 10.7%): ??

and also for subtracting (weight reduction), eg:

Initial Weight: 250 grams
Weight Change: -15.4%
Final Weight (would be 250 grams minus 15.4%): ??

This should work for addition or subtraction. This is figuring you're 
passing the percent as a whole number (10 for 10%, not .1).

cfset num = 250
cfset percent = -15.4

CFOUTPUT
#evaluate(num + (num * (percent / 100)))#
/CFOUTPUT
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.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



How to Handle Multiple CF Versions?

2001-10-25 Thread Voris, Jim

Say I have an application that will be deployed in mulitple environments,
some which are CF 4.5, and some which are CF 4.0.  

In in the CF 4.5 environments, I want to use the cfmailparam tag.  Is
there anyway to prevent CF 4.0 from trying to parse this?  Cftry doesn't
work.  Testing for version in cfif doesn't work.  

Any help would be appreciated.

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



CF Reporting question

2001-10-25 Thread Mark Robinson (National Express)

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: 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: Comparing Dates Functions

2001-10-25 Thread Paige Chandler

Hi Joseph,

Thanks. I'll be working on it again today. Have a nice day.

Regards,

Paige
- Original Message -
From: Joseph DeVore [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, October 25, 2001 2:56 AM
Subject: RE: Comparing Dates Functions


 This code should help you out.

 You can compare the dates down to the second.
 The function datecompare has an optional parameter (It's the precision of
 the comparison)

 The parameter can have any of the following values:
   sPrecise to the second
   nPrecise to the minute
   hPrecise to the hour
   dPrecise to the day
   mPrecise to the month
   Precise to the year


 cfdirectory action=list filter=*.* directory=c:\ name=directory

 cfoutput query=directory
 cfscript
 // set your date either dynamically or statically below
 mydate = now();

 // compare mydate to directory.datelastmodified
 comparison = datecompare(dateformat(mydate,'m/dd/'),
 dateformat(datelastmodified,'m/dd/'));
 /cfscript

 !--- output results of comparison ---
 cfif comparison eq -1
 date1 is less than date2
 cfelseif comparison eq 0
 date1 is equal to date2
 cfelseif comparison eq 1
 date1 is greater than date2
 /cfif
 br
 /cfoutput



 Joseph DeVore
 VeloxWeb Technologies




 -Original Message-
 From: Paige Chandler [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, October 24, 2001 5:36 PM
 To: CF-Talk
 Subject: Comparing Dates Functions


 Hello All,

 I'm having difficulty comparing a date range to DateLastModified,
 returned from CFDirectory. I've explored most of the date functions but
 can't find the function and syntax to do the job. Any help would be
 appreciated. TIA. Have a nice day.

 Regards,

 Paige


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



Why can't I buy JUST CFStudio 5?

2001-10-25 Thread Joshua Miller

Why is it that Macromedia insists on bundling CFStudio5 and UltraDev 4
together? Why can't I buy just CFStudio5? I can get JRun Studio, I can buy
UltraDev without CFStudio, I can buy HomeSite but I can't buy just
CFStudio5. I already own UltraDev4 and I really don't want to pay extra to
have a second copy just to get CFStudio5 ... what's the logic behind this?

Also, quit making it sound like it's one product. It's not. It's 2 separate
applications, proabably on 2 different CDs that you have to install one at a
time. What's the deal with trying to make it sound like it's one product
that has all these new features? It's the same UltraDev4 that's been around
for over a year - only Studio is new. Selling bundles is nice, but why force
customers into buying a more expensive bundle when they already paid $300
for one half of it? UltraDev is nice, but I really don't need 2 copies at
$250-$300 each for one developer.

When you make them one product, then it will make sense, but now you're just
confusing people into thinking that they're getting some hybrid of the two
in one application - and they're not getting that at all.

Why the hassle Macromedia? Just sell CFStudio as a standalone product!

Joshua Miller
Web Development::Programming
Eagle Technologies Group, Inc.
www.eagletgi.com
[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



Popup calendar

2001-10-25 Thread Jones, Becky

Has anyone seen a good script that pops up a calendar and fills in not only
a date in the text field but also a time?


*
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: Popup calendar

2001-10-25 Thread Neil Clark

Use the ColdFusion/Flash UI. Adding the date is easy.

Neil
Team Macromedia

~~
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: Why can't I buy JUST CFStudio 5?

2001-10-25 Thread Todd Ashworth

http://dynamic.macromedia.com/bin/MM/store/US/product.jsp?category=/Software
/Development/StandAlones/ColdFusionStudiotype=FULL

Todd

- Original Message -
From: Joshua Miller [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, October 25, 2001 8:55 AM
Subject: Why can't I buy JUST CFStudio 5?


 Why is it that Macromedia insists on bundling CFStudio5 and UltraDev 4
 together? Why can't I buy just CFStudio5? I can get JRun Studio, I can buy
 UltraDev without CFStudio, I can buy HomeSite but I can't buy just
 CFStudio5. I already own UltraDev4 and I really don't want to pay extra to
 have a second copy just to get CFStudio5 ... what's the logic behind this?

 Also, quit making it sound like it's one product. It's not. It's 2
separate
 applications, proabably on 2 different CDs that you have to install one at
a
 time. What's the deal with trying to make it sound like it's one product
 that has all these new features? It's the same UltraDev4 that's been
around
 for over a year - only Studio is new. Selling bundles is nice, but why
force
 customers into buying a more expensive bundle when they already paid $300
 for one half of it? UltraDev is nice, but I really don't need 2 copies at
 $250-$300 each for one developer.

 When you make them one product, then it will make sense, but now you're
just
 confusing people into thinking that they're getting some hybrid of the two
 in one application - and they're not getting that at all.

 Why the hassle Macromedia? Just sell CFStudio as a standalone product!

 Joshua Miller
 Web Development::Programming
 Eagle Technologies Group, Inc.
 www.eagletgi.com
 [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: Popup calendar

2001-10-25 Thread corrigan

Neil,

I'm interested in something like this too, but I'm not familiar with 
ColdFusion/Flash UI.  Could you give a few more details?  I'd love to 
find out more about it.

Thanks,

Michael Corrigan
Programmer
Endora Digital Solutions 
www.endoradigital.com
630/942-5211 x-134
  - Original Message - 
  From: Neil Clark 
  To: CF-Talk 
  Sent: Thursday, October 25, 2001 8:04 AM
  Subject: RE: Popup calendar


  Use the ColdFusion/Flash UI. Adding the date is easy.

  Neil
  Team Macromedia

  
~~
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: Popup calendar

2001-10-25 Thread Neil Clark

Hi Michael

http://devex.allaire.com/developer/gallery/info.cfm?id=20C2283F-3392-11D5-83
F400508B94F380method=full

Take a squiz at this... download and your away.. if you need a hand just
shout.

HTH

Neil
Team Macromedia

~~
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: Cold Fusion and Dynamic PDF Files

2001-10-25 Thread Chuck Rodgers

Hi,

I've used activepdf toolkit.  If you can afford this it will make your life 
much easier in dealing with pdfs.

Chuck Rodgers

At 10:03 PM 10/24/01 -0700, you wrote:
http://partners.adobe.com/asn/developer/acrosdk/forms.html

www.pdflib.com

www.fastio.com

www.activePDF.com


Ive got some rudimentary examples with the Adobe FDF Toolkit for ActiveX,
and CF.  Not sure that s the way you want to go.

Stephen M. Aylor
Aylor Insurance Agency, Inc.
Specialized Insurance Programs for the IT Industry
[EMAIL PROTECTED]
949.581.2333 vox
949.581.2814 fax
949.678.6091 cell





- Original Message -
From: Leon Oosterwijk [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, October 23, 2001 11:36 AM
Subject: Cold Fusion and Dynamic PDF Files


  All,
 
  I'm going to be working on a dynamic PDF File generator. Has anyone on the
  list had any experience with generating dynamic PDF files based on some
user
  variables? Based on some user input I need to fill in the blanks in a PDF
  document and present this to the user.
 
  Sincerely,
 
  Leon Oosterwijk


~~
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: Popup calendar

2001-10-25 Thread corrigan

PERFECT  Thanks Neil!!!

Michael Corrigan
Programmer
Endora Digital Solutions 
www.endoradigital.com
630/942-5211 x-134
  - Original Message - 
  From: Neil Clark 
  To: CF-Talk 
  Sent: Thursday, October 25, 2001 8:13 AM
  Subject: RE: Popup calendar


  Hi Michael

  
http://devex.allaire.com/developer/gallery/info.cfm?id=20C2283F-3392-11
D5-83
  F400508B94F380method=full

  Take a squiz at this... download and your away.. if you need a hand 
just
  shout.

  HTH

  Neil
  Team Macromedia

  
~~
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: Popup calendar

2001-10-25 Thread James Taavon

also, you can go here.

http://www.webtricks.com/Main.cfm



-Original Message-
From: Neil Clark [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 9:14 AM
To: CF-Talk
Subject: RE: Popup calendar


Hi Michael

http://devex.allaire.com/developer/gallery/info.cfm?id=20C2283F-3392-11D5-83
F400508B94F380method=full

Take a squiz at this... download and your away.. if you need a hand just
shout.

HTH

Neil
Team Macromedia


~~
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: Access Default values

2001-10-25 Thread Dina Hess

brainfart...that reply was definitely before coffee :( my apologies to 
the original poster.
  - Original Message - 
  From: Aidan Whitehall 
  To: CF-Talk 
  Sent: Wednesday, October 24, 2001 4:05 AM
  Subject: RE: Access Default values


   You can set the default value of a field in an Access table's design 

   view.

  He wanted to set default values as part of a CREATE TABLE statement.



  -- 
  Aidan Whitehall [EMAIL PROTECTED]
  Macromedia ColdFusion Developer
  Fairbanks Environmental +44 (0)1695 51775


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

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

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: Popup calendar

2001-10-25 Thread Angel Stewart

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

The most likely cause of this problem is that the service is not
currently running. You can use the 'Services' Control Panel to verify
that the service is running and to restart it if necessary. 

Windows NT error number 2 occurred.
 
When I went to that page.I didn't do anything :)
Just clicked on the URL below. The top and bottom banner graphics came
up fine though.

-Gel


-Original Message-
From: James Taavon [mailto:[EMAIL PROTECTED]] 

also, you can go here.

http://www.webtricks.com/Main.cfm

~~
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: Why can't I buy JUST CFStudio 5?

2001-10-25 Thread Jeffry Houser

  I assumed ( although do not know for a fact ) that the CF Studio 5 
Ultradev 4 was just a first out the door thing.  The product won't be 
available in a 'boxed' form until sometime in November.  I suspect that we 
will be getting a single CF Studio package sometime soon.

  People with CF Studio 5 subscriptions will be receiving their CF Studio 5 
upgrades, but not a free copy of Ultradev.

At 08:55 AM 10/25/2001 -0400, you wrote:
Why is it that Macromedia insists on bundling CFStudio5 and UltraDev 4
together? Why can't I buy just CFStudio5? I can get JRun Studio, I can buy
UltraDev without CFStudio, I can buy HomeSite but I can't buy just
CFStudio5. I already own UltraDev4 and I really don't want to pay extra to
have a second copy just to get CFStudio5 ... what's the logic behind this?

  The guess is that their long term plan is to merge the two into 
one.  Yes, all word from Macromedia has said that this is not the case, 
but... time will tell.  I spoke to a publisher about doing a CF Studio 
book.  They didn't seem to think that CF Studio had much of a future 
because Why waste resources on two different editors.


Also, quit making it sound like it's one product. It's not. It's 2 separate
applications, proabably on 2 different CDs that you have to install one at a
time.

  That is actually documented in the FAQ section of the product.  I'm 
pretty sure I saw it, at least.


When you make them one product, then it will make sense, but now you're just
confusing people into thinking that they're getting some hybrid of the two
in one application - and they're not getting that at all.

Why the hassle Macromedia? Just sell CFStudio as a standalone product!

  My guess ( I sort of stated before ) is that they are trying to blur the 
line between the two products, so when CF Studio goes away... it will cause 
less of a stir.




--
Jeffry Houser | mailto:[EMAIL PROTECTED]
AIM: Reboog711  | ICQ: 5246969 | Fax / Phone: 860-223-7946
--
DotComIt: Database Driven Web Data
My Book: Instant ColdFusion 5  | http://www.instantcoldfusion.com
My New Book: ColdFusion: A Beginner's Guide due out next February
--
Far Cry Fly, Alternative Folk Rock
http://www.farcryfly.com | http://www.mp3.com/FarCryFly
--
I can't believe I just gave up a gig... And rehearsal
~~
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: Why can't I buy JUST CFStudio 5?

2001-10-25 Thread Jeffry Houser

  Forget everything I said in my last email.  : ha, ha:  They don't make it 
obvious, though.

At 09:02 AM 10/25/2001 -0400, you wrote:
http://dynamic.macromedia.com/bin/MM/store/US/product.jsp?category=/Software
/Development/StandAlones/ColdFusionStudiotype=FULL

Todd

- Original Message -
From: Joshua Miller [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, October 25, 2001 8:55 AM
Subject: Why can't I buy JUST CFStudio 5?


  Why is it that Macromedia insists on bundling CFStudio5 and UltraDev 4
  together? Why can't I buy just CFStudio5? I can get JRun Studio, I can buy
  UltraDev without CFStudio, I can buy HomeSite but I can't buy just
  CFStudio5. I already own UltraDev4 and I really don't want to pay extra to
  have a second copy just to get CFStudio5 ... what's the logic behind this?
 
  Also, quit making it sound like it's one product. It's not. It's 2
separate
  applications, proabably on 2 different CDs that you have to install one at
a
  time. What's the deal with trying to make it sound like it's one product
  that has all these new features? It's the same UltraDev4 that's been
around
  for over a year - only Studio is new. Selling bundles is nice, but why
force
  customers into buying a more expensive bundle when they already paid $300
  for one half of it? UltraDev is nice, but I really don't need 2 copies at
  $250-$300 each for one developer.
 
  When you make them one product, then it will make sense, but now you're
just
  confusing people into thinking that they're getting some hybrid of the two
  in one application - and they're not getting that at all.
 
  Why the hassle Macromedia? Just sell CFStudio as a standalone product!
 
  Joshua Miller
  Web Development::Programming
  Eagle Technologies Group, Inc.
  www.eagletgi.com
  [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: Popup calendar

2001-10-25 Thread Angel Stewart

When you turn off the POPUP Attribute on the UI Calendar, it seems the
user needs to DOUBLE CLICK on a particular date in order for that date
to be registered as being selected. 

Is there any way to change this behaviour? As it is counter intuitive to
a user to have to doubleclick a date, especially since there is no
visual cue as to whether a date is finally selected or not using this
method.

-Gel
~~
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: Server Installation Question

2001-10-25 Thread Mark Stewart

IIS needs to be running so CF can see it when you do the install. I
can't remember if it prompts you to reboot, but nonetheless, it's always
a good idea to do a reboot after you install something new.

Mark

-Original Message-
From: Kevin Mansel [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 24, 2001 1:15 PM
To: CF-Talk
Subject: Server Installation Question


When setting up cf 4.5, do you have to stop the IIS service?Or does
it
stop the IIS service?   And do you have to reboot after the installation
is
complete?   Just wondering if anyone knows this stuff off the top of
their
head.

Thanks,

Kev

~
Kevin Mansel
Senior Web Developer
Fox Communications
[EMAIL PROTECTED]
DL : 425-649-1321
C : 425-346-7221


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



pop up windows

2001-10-25 Thread Jones, Becky

i have a template that i want to be able to have a link that you would click

on that would launch a popup window.  the contents of that popup window when

changed will effect the template underneath.  my problem is that the window 
doesnt automatically close after i click on submit (an alert box asks me if 
i really want to close the window)  i click on yes, but it doesnt refresh 
the template.  how can i get the template to automatically refresh with the 
new changes and the popup window to just close after the submit button is 
clicked?  i used window.close() but that still gives me that alert box. 
thanks, 
bec. 


* 
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. 




*
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: Tracking time in CF

2001-10-25 Thread Mark Stewart

What about a scenario where they just close their browser? At that
point, you at least have to have some javascript involved. Have you
thought about using an applet instead?

Mark

-Original Message-
From: Mike Tangorre [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 23, 2001 3:40 PM
To: CF-Talk
Subject: Tracking time in CF


Hi everyone.

I am trying to find a way on how to do the following securely.
I have a website that has 4 chat rooms.
Chat Room A = $0.50/minute
Chat Room B = $0.60/minute
Chat Room C = $0.70/minute
Suppose when people sign up they prefill their account with X amount of
dollars.
Is there a way in CF to monitor time on a certain page and compare it to
the
total
amount of time available for the room based on the number of dollars
available in the account... then
if they run out of money direct them to the order time page...?

Any help would be appreciated.  I thought maybe Javascript might be of
use
but wuld it not be easy to hack???  For instance:

Get the dollar total form the DB, divide it by the price of the room you
enter...store that value in a variable, then set a counter to count down
from the total available time...when the counter hits 0 refresh them to
a
page... if they logout, take the value of counter and refigure money
available and store it back into the db  AM i all confused or what?
:-)

Thanks for any help,

Mike

~~
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: pop up windows

2001-10-25 Thread Janine Jakim

You can find this topic at the forums at http://www.tek-tips.com/
From what I understand the message will always appear on a windows machine-
however, on the mac it closes automatically.


-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 10:14 AM
To: CF-Talk
Subject: pop up windows


i have a template that i want to be able to have a link that you would click

on that would launch a popup window.  the contents of that popup window when

changed will effect the template underneath.  my problem is that the window 
doesnt automatically close after i click on submit (an alert box asks me if 
i really want to close the window)  i click on yes, but it doesnt refresh 
the template.  how can i get the template to automatically refresh with the 
new changes and the popup window to just close after the submit button is 
clicked?  i used window.close() but that still gives me that alert box. 
thanks, 
bec. 


* 
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. 




*
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: Why can't I buy JUST CFStudio 5?

2001-10-25 Thread Mark Stewart

Not obvious at all. They're going to become another Microsoft, just wait
and see.

Mark



-Original Message-
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 12:58 PM
To: CF-Talk
Subject: Re: Why can't I buy JUST CFStudio 5?


  Forget everything I said in my last email.  : ha, ha:  They don't make
it 
obvious, though.

At 09:02 AM 10/25/2001 -0400, you wrote:
http://dynamic.macromedia.com/bin/MM/store/US/product.jsp?category=/So
f
tware
/Development/StandAlones/ColdFusionStudiotype=FULL

Todd

- Original Message -
From: Joshua Miller [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, October 25, 2001 8:55 AM
Subject: Why can't I buy JUST CFStudio 5?


  Why is it that Macromedia insists on bundling CFStudio5 and UltraDev
4
  together? Why can't I buy just CFStudio5? I can get JRun Studio, I
can buy
  UltraDev without CFStudio, I can buy HomeSite but I can't buy just
  CFStudio5. I already own UltraDev4 and I really don't want to pay
extra to
  have a second copy just to get CFStudio5 ... what's the logic behind
this?
 
  Also, quit making it sound like it's one product. It's not. It's 2
separate
  applications, proabably on 2 different CDs that you have to install
one at
a
  time. What's the deal with trying to make it sound like it's one
product
  that has all these new features? It's the same UltraDev4 that's been
around
  for over a year - only Studio is new. Selling bundles is nice, but
why
force
  customers into buying a more expensive bundle when they already paid
$300
  for one half of it? UltraDev is nice, but I really don't need 2
copies at
  $250-$300 each for one developer.
 
  When you make them one product, then it will make sense, but now
you're
just
  confusing people into thinking that they're getting some hybrid of
the two
  in one application - and they're not getting that at all.
 
  Why the hassle Macromedia? Just sell CFStudio as a standalone
product!
 
  Joshua Miller
  Web Development::Programming
  Eagle Technologies Group, Inc.
  www.eagletgi.com
  [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: Macromedia/Allaire Knowledge Base

2001-10-25 Thread Raymond Camden

What is wrong w/ the KB? I mean what issues are you running into?

===
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: Tracy Bost [mailto:[EMAIL PROTECTED]] 
 Sent: Wednesday, October 24, 2001 11:21 AM
 To: CF-Talk
 Subject: Macromedia/Allaire Knowledge Base
 
 
  I'm am very frustrated with the Knowledge Base at 
 Macromedia/Allaire.
  If it wasn't for posting a problem here or doing a search 
 through the CF
 Talk archives, I would have
 ditched ColdFusion a long time ago. Its just when this list 
 is down, that
 something like that is appreciated.
 One would think Macromedia/Allaire would take the Knowledge 
 Base section
 of their web site a lot more serious.
  As much as I dislike microsoft's products, they do have a 
 great knowledge
 base, and makes the problems easy to find in the searches.
 
 
~~
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: pop up windows

2001-10-25 Thread Richard B

I use the following script regularly, the only ime I get a message, is 
if the page being loaded is the result of a submit, in which case the 
browser asks if it is OK to resubmit the data.

 script language=JavaScript
window.opener.location.reload();
window.close();
/script


 Regards


 You can find this topic at the forums at http://www.tek-tips.com/
 From what I understand the message will always appear on a windows machine-
 however, on the mac it closes automatically.
 
 
 -Original Message-
 From: Jones, Becky [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, October 25, 2001 10:14 AM
 To: CF-Talk
 Subject: pop up windows
 
 
 i have a template that i want to be able to have a link that you would click
 
 on that would launch a popup window.  the contents of that popup window when
 
 changed will effect the template underneath.  my problem is that the window 
 doesnt automatically close after i click on submit (an alert box asks me if 
 i really want to close the window)  i click on yes, but it doesnt refresh 
 the template.  how can i get the template to automatically refresh with the 
 new changes and the popup window to just close after the submit button is 
 clicked?  i used window.close() but that still gives me that alert box. 
 thanks, 
 bec. 
 
 
 * 
 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. 
 
 
 
 
 *
 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. 
 
 
 
~~
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: Macromedia/Allaire Knowledge Base

2001-10-25 Thread Robert Everland

I have never liked the KB myself either. You find more on the support forums
then you do on there. I would like it if they were able to update the KB as
an issue is resolved with CF. Microsoft, although they are the devil, has an
awesome KB that you can find answers to every question you can think of.

Robert Everland III
Dixon Ticonderoga
Web Developer Extraordinaire

-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 10:36 AM
To: CF-Talk
Subject: RE: Macromedia/Allaire Knowledge Base


What is wrong w/ the KB? I mean what issues are you running into?

===
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: Tracy Bost [mailto:[EMAIL PROTECTED]] 
 Sent: Wednesday, October 24, 2001 11:21 AM
 To: CF-Talk
 Subject: Macromedia/Allaire Knowledge Base
 
 
  I'm am very frustrated with the Knowledge Base at 
 Macromedia/Allaire.
  If it wasn't for posting a problem here or doing a search 
 through the CF
 Talk archives, I would have
 ditched ColdFusion a long time ago. Its just when this list 
 is down, that
 something like that is appreciated.
 One would think Macromedia/Allaire would take the Knowledge 
 Base section
 of their web site a lot more serious.
  As much as I dislike microsoft's products, they do have a 
 great knowledge
 base, and makes the problems easy to find in the searches.
 
 

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



CFREPORT

2001-10-25 Thread Mark Robinson (National Express)

I am getting the error below when I try and use the CFREPORT tag. I have
installed our copy of Crystal Reports 7 and I get the error below.
Has anybody used CFREPORT tag successfully and have they got any tips that
would help me.
Error Diagnostic Information
Error occurred while processing CFREPORT 
The Crystal Reports Engine (CRPE32.DLL) could not be located on this server.
ColdFusion's reporting functionality requires the Crystal Engine. Please
verify that you have installed this component before using the CFREPORT tag.

Crystal Library = () 
DLL Version = , Engine Version = 
The error occurred while processing an element with a general identifier of
(CFREPORT), occupying document position (10:1) to (10:59).
Date/Time: 10/25/01 16:05:56
Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0; DigExt)

thanks in advance,
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]
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



cf_filter_duplicate_emails_from_query

2001-10-25 Thread coldfusion . developer

Hello,

I am querying 3 tables that all contain email addresses.
What I want to do is send an email using all the email
addresses.  I just want to make sure there aren't 
duplicate e-mail when i sent the email.

I need some advice on how to remove duplicates.


---
i've got the cfquery ...

CFQUERY NAME=all_emails datasource=#datasource#
SELECT  db1_email, 
db2_email, 
db3_email
FROMdb1, 
db2, 
db3,
/cfquery  

--
I need some advice on how to remove dupplicates


--
I've got the beginning of the cfloop/cfmail ...

CFLOOP QUERY=all_emails 

cfmail to=? from=[EMAIL PROTECTED] 
subject=subject 

body 

/cfmail


~~
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: Checking file size before upload.

2001-10-25 Thread Lewis Sellers

On Thu, 25 Oct 2001 16:51:35 +1000, Tilbrook, Peter
[EMAIL PROTECTED] wrote:

I don't thinks so. At least not with CF as standard.

I vaguely recall writing a custom http server and cfx to handle
getting raw post data... I believe I intended to allow you to set a
byte-limit and have the server simple break connection if a post
exceeded it.

To be honest though I'm not sure if I ever finished the code or not.
Been a long time.

It was part of the IHTK package, secPOST/secPOSTService (?).

--min


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

2001-10-25 Thread Leon Greeff

Why don't you use distinct


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 25 October 2001 05:12
To: CF-Talk
Subject: cf_filter_duplicate_emails_from_query


Hello,

I am querying 3 tables that all contain email addresses.
What I want to do is send an email using all the email
addresses.  I just want to make sure there aren't 
duplicate e-mail when i sent the email.

I need some advice on how to remove duplicates.


---
i've got the cfquery ...

CFQUERY NAME=all_emails datasource=#datasource#
SELECT  db1_email, 
db2_email, 
db3_email
FROMdb1, 
db2, 
db3,
/cfquery  

--
I need some advice on how to remove dupplicates


--
I've got the beginning of the cfloop/cfmail ...

CFLOOP QUERY=all_emails 

cfmail to=? from=[EMAIL PROTECTED] 
subject=subject 

body 

/cfmail



~~
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: Macromedia/Allaire Knowledge Base

2001-10-25 Thread Owen Leonard

I find the KB impossible to use as well.  It seems that every time I'm
looking for something, I put in a phrase or keywords to search for, and the
results are zero.  And usually the page doesn't even say, 'No results were
found,' it's just empty.  Usually I have to trim my search down to 1 keyword
before any results turn up, and then there's too much stuff to sift through.
 Part of me feels that I must be doing it wrong, but this isn't rocket
science and I can get results out of other search engines.  Very
frustrating.

-- Owen


Athens County Library Services
http://www.athenscounty.lib.oh.us

- Original Message -
From: Raymond Camden [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, October 25, 2001 10:36 AM
Subject: RE: Macromedia/Allaire Knowledge Base


 What is wrong w/ the KB? I mean what issues are you running into?

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

  -Original Message-
  From: Tracy Bost [mailto:[EMAIL PROTECTED]]
  Sent: Wednesday, October 24, 2001 11:21 AM
  To: CF-Talk
  Subject: Macromedia/Allaire Knowledge Base
 
 
   I'm am very frustrated with the Knowledge Base at
  Macromedia/Allaire.
~~
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



OT Frontier Rochester

2001-10-25 Thread Rich Tretola

Anyone on this list work for Frontier Rochester, NY? Formally frontier
Plano, TX
Rich
~~
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



How do I check to see if cookies exist

2001-10-25 Thread Robert Everland

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

2001-10-25 Thread Steven Monaghan

Would this work?

CFQUERY NAME=all_emails datasource=#datasource#
SELECT  db1_email as email_field, 
FROMdb1
union
SELECT  db2_email as email_field, 
FROMdb2 
union
SELECT  db3_email as email_field, 
FROMdb3
/cfquery  

CFLOOP QUERY=all_emails 
cfmail to=email_field from=[EMAIL PROTECTED] 
subject=subject 
   
body 

/cfmail

-
Steven Monaghan
Oracle DBA / Cold Fusion Developer
MSC Industrial Direct Co., Inc.
Melville, NY
[EMAIL PROTECTED]
http://www.mscdirect.com
-
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 11:12 AM
To: CF-Talk
Subject: cf_filter_duplicate_emails_from_query


Hello,

I am querying 3 tables that all contain email addresses.
What I want to do is send an email using all the email
addresses.  I just want to make sure there aren't 
duplicate e-mail when i sent the email.

I need some advice on how to remove duplicates.


---
i've got the cfquery ...

CFQUERY NAME=all_emails datasource=#datasource#
SELECT  db1_email, 
db2_email, 
db3_email
FROMdb1, 
db2, 
db3,
/cfquery  

--
I need some advice on how to remove dupplicates


--
I've got the beginning of the cfloop/cfmail ...

CFLOOP QUERY=all_emails 

cfmail to=? from=[EMAIL PROTECTED] 
subject=subject 

body 

/cfmail



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



RE: How do 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: How do I check to see if cookies exist

2001-10-25 Thread Will Swain

try setting one then check for its existence. This should tell you if the
browser is allowing cookies.

HTH
Will

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

2001-10-25 Thread Lon Lentz

  Have you tried unions?

  Another option is to convert the email query to a list and run it 
through a custom tag like cfx_listsort which can sort the list and 
dedupe it.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 11:12 AM
To: CF-Talk
Subject: cf_filter_duplicate_emails_from_query


Hello,

I am querying 3 tables that all contain email addresses.
What I want to do is send an email using all the email
addresses.  I just want to make sure there aren't 
duplicate e-mail when i sent the email.

I need some advice on how to remove duplicates.
~~
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 Lanny R. Udey

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



validate email addresses in text area

2001-10-25 Thread Jeff Beer

Does anyone have a routine to parse and validate e-mail addresses in a text
area?

I'm having some trouble figuring out all the necessary steps.

It would be cool if it could handle various delimiters (spaces, commas, etc)
and validate each address, resulting in a simple comma delimited list of
valid (format) addresses.

Thank in advance!

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



RE: How do I check to see if cookies exist

2001-10-25 Thread Andy Ewings

yeh but remember that you can't write to a cookie and then read it within
the same page call.

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



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


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: How do I check to see if cookies exist

2001-10-25 Thread Robert Everland

I am trying that, it's not showing me that it wasn't set. Maybe because I
set it then check to see if it exists right after.

Robert Everland III
Dixon Ticonderoga
Web Developer Extraordinaire

-Original Message-
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 11:31 AM
To: CF-Talk
Subject: RE: How do I check to see if cookies exist


try setting one then check for its existence. This should tell you if the
browser is allowing cookies.

HTH
Will

-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


~~
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: Macromedia/Allaire Knowledge Base

2001-10-25 Thread Gary P. McNeel, Jr.

The Devil? That's how they suck you in. You are lost. ;)

I agree. I have never counted on finding answers there, although I must
admit I got close enough once to actually solve it after a bit of monkeying
around.

-Gary

 -Original Message-
 From: Robert Everland [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, October 25, 2001 9:41 AM
 To: CF-Talk
 Subject: RE: Macromedia/Allaire Knowledge Base


 I have never liked the KB myself either. You find more on the
 support forums
 then you do on there. I would like it if they were able to update
 the KB as
 an issue is resolved with CF. Microsoft, although they are the
 devil, has an
 awesome KB that you can find answers to every question you can think of.

 Robert Everland III
 Dixon Ticonderoga
 Web Developer Extraordinaire

 -Original Message-
 From: Raymond Camden [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, October 25, 2001 10:36 AM
 To: CF-Talk
 Subject: RE: Macromedia/Allaire Knowledge Base


 What is wrong w/ the KB? I mean what issues are you running into?

 ===
 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: Tracy Bost [mailto:[EMAIL PROTECTED]]
  Sent: Wednesday, October 24, 2001 11:21 AM
  To: CF-Talk
  Subject: Macromedia/Allaire Knowledge Base
 
 
   I'm am very frustrated with the Knowledge Base at
  Macromedia/Allaire.
   If it wasn't for posting a problem here or doing a search
  through the CF
  Talk archives, I would have
  ditched ColdFusion a long time ago. Its just when this list
  is down, that
  something like that is appreciated.
  One would think Macromedia/Allaire would take the Knowledge
  Base section
  of their web site a lot more serious.
   As much as I dislike microsoft's products, they do have a
  great knowledge
  base, and makes the problems easy to find in the searches.
 
 

 
~~
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 Lomvardias, Christopher

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: Macromedia/Allaire Knowledge Base

2001-10-25 Thread Aidan Whitehall

 It seems that every time I'm
 looking for something, I put in a phrase or keywords to 
 search for, and the
 results are zero.

Me too.



-- 
Aidan Whitehall [EMAIL PROTECTED]
Macromedia ColdFusion Developer
Fairbanks Environmental +44 (0)1695 51775


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



RE: How do I check to see if cookies exist

2001-10-25 Thread Garza, Jeff

Set it with CF, check it with JavaScript.  This has always worked for me for
setting and reading a cookie on the same page.  Othwise you'll have to use a
gateway page that attempts the cookie set and then read if from a second
page.

Jeff Garza
Lead Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200
[EMAIL PROTECTED]
http://www.spectrumastro.com



-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, October 25, 2001 8:33 AM
To: CF-Talk
Subject: RE: How do I check to see if cookies exist


I am trying that, it's not showing me that it wasn't set. Maybe because I
set it then check to see if it exists right after.

Robert Everland III
Dixon Ticonderoga
Web Developer Extraordinaire

-Original Message-
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 11:31 AM
To: CF-Talk
Subject: RE: How do I check to see if cookies exist


try setting one then check for its existence. This should tell you if the
browser is allowing cookies.

HTH
Will

-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 Dave Watts

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



CF4.5 and JRE: CFGRID won't run

2001-10-25 Thread andrew kopelman

I am trying to run an app with a CFGRID applet; CF4.5 is running, and I have 
JRE 1.2 ('classic') running.  I believe the JVMP and Class Path are set 
correctly in the CFAdministrator, but .cfms with the CFGRID won't even load! 
  Help!

Thanks in advance,
Andrew


~~
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: Popup calendar

2001-10-25 Thread wdlist

I have one at http://planeta.terra.com.br/informatica/vega/_opcal/cal_en2.html

It has nothing to do with CF and it only puts the date into the field but that
can be accomplished with a small script modification.
Feel free to modify and use it if you like.
__

Jones, Becky wrote:

 Has anyone seen a good script that pops up a calendar
 and fills in not only a date in the text field but
 also a time?

UAI - ESTADO DE MINAS
O Grande portal dos Mineiros na Internet
~~
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

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



  1   2   3   >