Re: How can I ORDER BY RANDOM ?

2003-04-04 Thread Jochem van Dieten
Tom Forbes wrote:
 
 I need to modify the below query so that my results are still ordered by 
 ClassOfService (a number between 1 and 4) - BUT, the CompanyName needs 
 to be displayed in a RANDOM ORDER each time the query is run, rather than 
 its current alphabetical order. This will give all companies that 
 participate an even advantage of being selected rather than those that 
 begin with the first letters of the alphabet.

Usually I do:
SELECT  fields
FROMtables
WHERE   predicates
ORDER BY
Random()

It might be that your database does not support that because the 
Random() function needs to be seeded or else it will generate the same 
sequence every time. In that case, seed it with a different random 
number for each row. This different random number is best obtained by 
taking the primary key (different) and add a number (random).

SELECT  fields
FROMtables
WHERE   predicates
ORDER BY
Random(PrimaryKey + cfqueryparam cfsqltype=cf_sql_integer 
value=#RandRange(1,99)#)

This might be a little hard on your CPU when you have many records.

Jochem

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: CF Community recommendations?

2003-04-04 Thread Jochem van Dieten
Paul Campano wrote:

 I am looking to build a community website for my apartment building of almost 200 
 units.  I would like to have a members area with forums, the ability to add news 
 stories and other community functions.  Could someone recommend a free or low cost 
 solution?  I am doing this as a freebee, so I'm on my own as far as funding goes.

If you want to stay with CFML and still spend little money you might 
want to look into AssetNow Personal Edition http://www.assetnow.com/
I believe they are working on an edition for BlueDragon as well. Combine 
it with any of the numerous forum applications and you should be done 
pretty soon.

Jochem


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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: Hiding JavaScript codes

2003-04-04 Thread Jochem van Dieten
Costas Piliotis wrote:
 
 The only way for one to do this is if they know how to pass their own http
 headers.  And then they need to know that you're looking at that particular
 cgi variable, and they need to know what you're comparing to as well.  Too
 much trouble for a little piece of javascript IMHO...

No, you just need to use the header-replay feature from Mozilla.

Jochem


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: CF Community recommendations?

2003-04-04 Thread Matt Robertson
If his use doesn't qualify for their free personal edition, then that
will cost at least US$995.  My CMPro cms is US$350.  One of my customers
is a private dormitory at UC Berkeley, where the residents each get
their own web pages, can pay their rent online using a form generated by
the auto-form generator and a bunch of other stuff.  Add in an
inexpensive forum and you're up and running for a lot less.


 Matt Robertson   [EMAIL PROTECTED] 
 MSB Designs, Inc.  http://mysecretbase.com



I've stopped 47,943 spam messages. You can too!
Get your free, safe spam protection at
http://www.cloudmark.com/spamnetsig/

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 04, 2003 12:22 AM
To: CF-Talk
Subject: Re: CF Community recommendations?


Paul Campano wrote:

 I am looking to build a community website for my apartment building of
almost 200 units.  I would like to have a members area with forums, the
ability to add news stories and other community functions.  Could
someone recommend a free or low cost solution?  I am doing this as a
freebee, so I'm on my own as far as funding goes.

If you want to stay with CFML and still spend little money you might 
want to look into AssetNow Personal Edition http://www.assetnow.com/
I believe they are working on an edition for BlueDragon as well. Combine

it with any of the numerous forum applications and you should be done 
pretty soon.

Jochem



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: CF Community recommendations?

2003-04-04 Thread Jochem van Dieten
Matt Robertson wrote:

 If his use doesn't qualify for their free personal edition, then that
 will cost at least US$995.

The way I read the license and his requirements he qualifies.


 My CMPro cms is US$350.  One of my customers
 is a private dormitory at UC Berkeley

Berkeley? As in BSD? And they don't have a resident that writes this 
sort of thing in Haskell or some other obscure language? What is wrong 
with the world lately?

Jochem


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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: CF Community recommendations?

2003-04-04 Thread Chris Phillips
I've not used it / reviewed it / looked at it yet - it's on my to do
list (for situations like yours!) :-)

http://www.ultraapps.com/freecommunitywebportal.html



-Original Message-
From: Paul Campano [mailto:[EMAIL PROTECTED] 
Sent: Thursday 03 April 2003 23:42
To: CF-Talk
Subject: CF Community recommendations?


I am looking to build a community website for my apartment building of
almost 200 units.  I would like to have a members area with forums, the
ability to add news stories and other community functions.  Could
someone recommend a free or low cost solution?  I am doing this as a
freebee, so I'm on my own as far as funding goes.  Thanks.

Paul Campano


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: CF Community recommendations?

2003-04-04 Thread Matt Robertson
Jochem wrote:
Berkeley? As in BSD? And they don't have a resident that writes this 
sort of thing in Haskell or some other obscure language? What is wrong 
with the world lately?

In Berserkeley ???  Expect the unexpected in the People's Republic.  :D

--Matt--


Berkeley? As in BSD? And they don't have a resident that writes this 
sort of thing in Haskell or some other obscure language? What is wrong 
with the world lately?
Jochem



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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: CF 5 For Sale?

2003-04-04 Thread Philip Arnold
 Anyone have Cold Fusion 5 Pro for sale?  Where can I
 obtain...everything I see is for MX...

eBay?


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: -OT- Adding a button to IE

2003-04-04 Thread Philip Arnold
 Is it possible to add a button to IE that will open a new
 window and load a webpage?  Would one have to write it in
 VBscript?

Do you mean on your machine, or on a visitors?

If you're talking about a visitors, then I think that might be classed
under hacking...

On your own, you can add buttons to the Links bar by adding it to the
Links folder in your Favorites


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Multiple forms, looping and inserting

2003-04-04 Thread Philip Arnold
Similar to Matt's solution, but name your Form fields with a numeric
extension

input type=text name=Name_#i#
value=#HTMLeditFormat(Form[Name_#i#])#

Then when you're inserting, just use the form[Name_#i#]

Remember to pass the number of entries along with the form, otherwise
you won't know how many to loop over

I'd use the underscore to separate the field name from the number

HTH

 -Original Message-
 From: Candace Cottrell [mailto:[EMAIL PROTECTED]
 Sent: Friday, April 04, 2003 12:56 AM
 To: CF-Talk
 Subject: Multiple forms, looping and inserting


 Ok, so I have an idea, but I'm not sure how to carry it through.

 I have a basic insert record page. However, I want the person
 to be able to add 5, 10, or 15 records at a time, depending
 on the value they select from a drop-down. Meaning, depending
 on how many they want to add, there will be that many forms,
 and one submit button to add all the records.

 I'm thinking I need a loop somewhere, but not sure where.

 Any help is greatly appreciated!

 Here's what I have so far:

 addSite.cfm:


 form name=MultiForm
 action=addSite.cfm?MultiForm=TRUENumForms=#NumForms#
   select name=NumForms
option value=55/option
 option value=10 selected10/option
   option value=1515/option
   /select
   input name= type=submit value=Show
 /form

  cfif MultiForm IS True
 form action=addSite2.cfm method=post name=addSite
cfloop from=0 to=URL.NumForms index=i
   table width=100% border=0 cellspacing=2 cellpadding=5
 tr
   td width=24% class=copyTealdiv
 align=rightAuthor Name: /div/td
   td width=76%input name=Website_author
 type=text id=Website_author/td
 /tr
 tr
   td class=copyTealdiv align=rightWebsite link:/div/td
   tdp
   input name=Website_Link type=text
 id=Website_Link size=45
 /p
 pspan class=tealHeaderPlease include the
 http:// and remember to
   verify the link's accuracy./span/p/td
 /tr
   /table
   p class=tealHeader
 input type=submit value=Continue
   /p/cfloop
   /form

   cfelse
   form action=addSite2.cfm method=post name=addSite
table width=100% border=0 cellspacing=2 cellpadding=5
 tr
   td width=24% class=copyTealdiv
 align=rightAuthor Name: /div/td
   td width=76%input name=Website_author
 type=text id=Website_author/td
 /tr
 tr
   td class=copyTealdiv align=rightWebsite link:/div/td
   tdp
   input name=Website_Link type=text
 id=Website_Link size=45
 /p
 pspan class=tealHeaderPlease include the
http:// and remember to
  verify the link's accuracy./span/p/td
/tr
  /table
  p class=tealHeader
input type=submit value=Continue
  /p
  /form

  /cfif


The problem is that the page is trying to run the loop regardless of if
the upper form has been submitted or not. And then it says that my to
value is invalid because it isn't a simple data type.

Thanks for taking the time to read my rambling :)

Candace K. Cottrell, Web Developer
The Children's Medical Center
One Children's Plaza
Dayton, OH 45404
937-641-4293
http://www.childrensdayton.org


[EMAIL PROTECTED]

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Count(*) Query

2003-04-04 Thread Hawkes, Keith A CIV
I have a table that has one field that holds numbers 1 thru 9.  Can I run a
single query that will give me the count(*) of 1's, count(*) of 2's, etc. or
do I have to run a separate query for each?

Thanks to all,

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Count(*) Query

2003-04-04 Thread Philip Arnold
 I have a table that has one field that holds numbers 1 thru
 9.  Can I run a single query that will give me the count(*)
 of 1's, count(*) of 2's, etc. or do I have to run a separate
 query for each?

Do you want them in one row, or one row per number?

The SQL is a lot bigger for one row, but here they are

This will give you only 1-9 and one row per number;
SELECT number, Count(number) as Counted
FROM table
GROUP BY number
HAVING number BETWEEN 1 AND 9
ORDER BY number

This will give you one row with all 9 values;
SELECT TOP 1 (SELECT count(number) FROM table WHERE number=1) as Count1,
(SELECT count(number) FROM table WHERE number=2) as Count2,
(SELECT count(number) FROM table WHERE number=3) as Count3,
(SELECT count(number) FROM table WHERE number=4) as Count4,
(SELECT count(number) FROM table WHERE number=5) as Count5,
(SELECT count(number) FROM table WHERE number=6) as Count6,
(SELECT count(number) FROM table WHERE number=7) as Count7,
(SELECT count(number) FROM table WHERE number=8) as Count8,
(SELECT count(number) FROM table WHERE number=9) as Count9
FROM table

HTH



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Multiple forms, looping and inserting

2003-04-04 Thread Candace Cottrell
Thanks to Matt and Philip for helping out with this. I have the form
page displaying correctly now.
 
HOWEVER, (and there always is one with me) I thought of one of those
user-error things.
 
What if the user tells the page she wants to add 10 records, but only
fills in eight of them?
If I use the initial loop value (which I am calling NumForms) there
will be empty records added.
 
Any ideas?
 
 
Candace K. Cottrell, Web Developer 
The Children's Medical Center 
One Children's Plaza 
Dayton, OH 45404 
937-641-4293 
http://www.childrensdayton.org
 
 
[EMAIL PROTECTED]

 [EMAIL PROTECTED] 4/4/2003 5:09:07 AM 
Similar to Matt's solution, but name your Form fields with a numeric
extension

input type=text name=Name_#i#
value=#HTMLeditFormat(Form[Name_#i#])#

Then when you're inserting, just use the form[Name_#i#]

Remember to pass the number of entries along with the form, otherwise
you won't know how many to loop over

I'd use the underscore to separate the field name from the number

HTH

 -Original Message-
 From: Candace Cottrell [mailto:[EMAIL PROTECTED] 
 Sent: Friday, April 04, 2003 12:56 AM
 To: CF-Talk
 Subject: Multiple forms, looping and inserting


 Ok, so I have an idea, but I'm not sure how to carry it through.

 I have a basic insert record page. However, I want the person
 to be able to add 5, 10, or 15 records at a time, depending
 on the value they select from a drop-down. Meaning, depending
 on how many they want to add, there will be that many forms,
 and one submit button to add all the records.

 I'm thinking I need a loop somewhere, but not sure where.

 Any help is greatly appreciated!

 Here's what I have so far:

 addSite.cfm:


 form name=MultiForm
 action=addSite.cfm?MultiForm=TRUENumForms=#NumForms#
   select name=NumForms
option value=55/option
 option value=10 selected10/option
 option value=1515/option
   /select
   input name= type=submit value=Show
 /form

  cfif MultiForm IS True
 form action=addSite2.cfm method=post name=addSite
cfloop from=0 to=URL.NumForms index=i
   table width=100% border=0 cellspacing=2 cellpadding=5
 tr
   td width=24% class=copyTealdiv
 align=rightAuthor Name: /div/td
   td width=76%input name=Website_author
 type=text id=Website_author/td
 /tr
 tr
   td class=copyTealdiv align=rightWebsite
link:/div/td
   tdp
   input name=Website_Link type=text
 id=Website_Link size=45
 /p
 pspan class=tealHeaderPlease include the
 http:// and remember to
   verify the link's accuracy./span/p/td
 /tr
   /table
   p class=tealHeader
 input type=submit value=Continue
   /p/cfloop
   /form

   cfelse
   form action=addSite2.cfm method=post name=addSite
table width=100% border=0 cellspacing=2 cellpadding=5
 tr
   td width=24% class=copyTealdiv
 align=rightAuthor Name: /div/td
   td width=76%input name=Website_author
 type=text id=Website_author/td
 /tr
 tr
   td class=copyTealdiv align=rightWebsite
link:/div/td
   tdp
   input name=Website_Link type=text
 id=Website_Link size=45
 /p
 pspan class=tealHeaderPlease include the
http:// and remember to
  verify the link's accuracy./span/p/td
/tr
  /table
  p class=tealHeader
input type=submit value=Continue
  /p
  /form

  /cfif


The problem is that the page is trying to run the loop regardless of
if
the upper form has been submitted or not. And then it says that my
to
value is invalid because it isn't a simple data type.

Thanks for taking the time to read my rambling :)

Candace K. Cottrell, Web Developer
The Children's Medical Center
One Children's Plaza
Dayton, OH 45404
937-641-4293
http://www.childrensdayton.org 


[EMAIL PROTECTED] 


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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Multiple forms, looping and inserting

2003-04-04 Thread Angel Stewart
Hmm...could just check if they are empty??
And only add to the database if they are not empty?

So loop over the fields during the insert query, and only run the insert
query if the field is NEQ .

So even if they select 15 records and only actually fill out 5 you won't
try to insert anything.


CFLOOP FROM=1 TO=#form.Numforms# index=j
CFIF form.Name_#j# NEQ 
CFQUERY name=insertrecords datasource=#DSN#
..
..
..
/CFQUERY
/CFIF
/CFLOOP

??

Okies..maybe not..
*sneaks away quietly*

-Gel

-Original Message-
From: Candace Cottrell [mailto:[EMAIL PROTECTED] 

Thanks to Matt and Philip for helping out with this. I have the form
page displaying correctly now.
 
HOWEVER, (and there always is one with me) I thought of one of those
user-error things.
 
What if the user tells the page she wants to add 10 records, but only
fills in eight of them? If I use the initial loop value (which I am
calling NumForms) there will be empty records added.
 
Any ideas?

 
Candace K. Cottrell, Web Developer 
The Children's Medical Center 
One Children's Plaza 
Dayton, OH 45404 
937-641-4293 
http://www.childrensdayton.org
 
 
[EMAIL PROTECTED]

 [EMAIL PROTECTED] 4/4/2003 5:09:07 AM 
Similar to Matt's solution, but name your Form fields with a numeric
extension

input type=text name=Name_#i#
value=#HTMLeditFormat(Form[Name_#i#])#

Then when you're inserting, just use the form[Name_#i#]

Remember to pass the number of entries along with the form, otherwise
you won't know how many to loop over

I'd use the underscore to separate the field name from the number

HTH

 -Original Message-
 From: Candace Cottrell [mailto:[EMAIL PROTECTED]
 Sent: Friday, April 04, 2003 12:56 AM
 To: CF-Talk
 Subject: Multiple forms, looping and inserting


 Ok, so I have an idea, but I'm not sure how to carry it through.

 I have a basic insert record page. However, I want the person to be 
 able to add 5, 10, or 15 records at a time, depending on the value 
 they select from a drop-down. Meaning, depending on how many they want

 to add, there will be that many forms, and one submit button to add 
 all the records.

 I'm thinking I need a loop somewhere, but not sure where.

 Any help is greatly appreciated!

 Here's what I have so far:

 addSite.cfm:


 form name=MultiForm 
 action=addSite.cfm?MultiForm=TRUENumForms=#NumForms#
   select name=NumForms
option value=55/option
 option value=10 selected10/option
 option value=1515/option
   /select
   input name= type=submit value=Show
 /form

  cfif MultiForm IS True
 form action=addSite2.cfm method=post name=addSite
cfloop from=0 to=URL.NumForms index=i
   table width=100% border=0 cellspacing=2 cellpadding=5
 tr
   td width=24% class=copyTealdiv align=rightAuthor Name:

 /div/td
   td width=76%input name=Website_author type=text 
 id=Website_author/td
 /tr
 tr
   td class=copyTealdiv align=rightWebsite
link:/div/td
   tdp
   input name=Website_Link type=text id=Website_Link 
 size=45
 /p
 pspan class=tealHeaderPlease include the http:// and 
 remember to
   verify the link's accuracy./span/p/td
 /tr
   /table
   p class=tealHeader
 input type=submit value=Continue
   /p/cfloop
   /form

   cfelse
   form action=addSite2.cfm method=post name=addSite
table width=100% border=0 cellspacing=2 cellpadding=5
 tr
   td width=24% class=copyTealdiv align=rightAuthor Name:

 /div/td
   td width=76%input name=Website_author type=text 
 id=Website_author/td
 /tr
 tr
   td class=copyTealdiv align=rightWebsite
link:/div/td
   tdp
   input name=Website_Link type=text id=Website_Link 
 size=45
 /p
 pspan class=tealHeaderPlease include the
http:// and remember to
  verify the link's accuracy./span/p/td
/tr
  /table
  p class=tealHeader
input type=submit value=Continue
  /p
  /form

  /cfif


The problem is that the page is trying to run the loop regardless of if
the upper form has been submitted or not. And then it says that my to
value is invalid because it isn't a simple data type.

Thanks for taking the time to read my rambling :)

Candace K. Cottrell, Web Developer
The Children's Medical Center
One Children's Plaza
Dayton, OH 45404
937-641-4293
http://www.childrensdayton.org 


[EMAIL PROTECTED] 



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Multiple forms, looping and inserting

2003-04-04 Thread Candace Cottrell
Sounds like a plan, thanks Gel. I'll try it out when I get home :)
okies??  ;)
 
Candace K. Cottrell, Web Developer 
The Children's Medical Center 
One Children's Plaza 
Dayton, OH 45404 
937-641-4293 
http://www.childrensdayton.org
 
 
[EMAIL PROTECTED]

 [EMAIL PROTECTED] 4/4/2003 8:25:30 AM 
Hmm...could just check if they are empty??
And only add to the database if they are not empty?

So loop over the fields during the insert query, and only run the
insert
query if the field is NEQ .

So even if they select 15 records and only actually fill out 5 you
won't
try to insert anything.


CFLOOP FROM=1 TO=#form.Numforms# index=j
CFIF form.Name_#j# NEQ 
CFQUERY name=insertrecords datasource=#DSN#
..
..
..
/CFQUERY
/CFIF
/CFLOOP

??

Okies..maybe not..
*sneaks away quietly*

-Gel

-Original Message-
From: Candace Cottrell [mailto:[EMAIL PROTECTED] 

Thanks to Matt and Philip for helping out with this. I have the form
page displaying correctly now.

HOWEVER, (and there always is one with me) I thought of one of those
user-error things.

What if the user tells the page she wants to add 10 records, but only
fills in eight of them? If I use the initial loop value (which I am
calling NumForms) there will be empty records added.

Any ideas?


Candace K. Cottrell, Web Developer 
The Children's Medical Center 
One Children's Plaza 
Dayton, OH 45404 
937-641-4293 
http://www.childrensdayton.org 


[EMAIL PROTECTED] 

 [EMAIL PROTECTED] 4/4/2003 5:09:07 AM 
Similar to Matt's solution, but name your Form fields with a numeric
extension

input type=text name=Name_#i#
value=#HTMLeditFormat(Form[Name_#i#])#

Then when you're inserting, just use the form[Name_#i#]

Remember to pass the number of entries along with the form, otherwise
you won't know how many to loop over

I'd use the underscore to separate the field name from the number

HTH

 -Original Message-
 From: Candace Cottrell [mailto:[EMAIL PROTECTED] 
 Sent: Friday, April 04, 2003 12:56 AM
 To: CF-Talk
 Subject: Multiple forms, looping and inserting


 Ok, so I have an idea, but I'm not sure how to carry it through.

 I have a basic insert record page. However, I want the person to be 
 able to add 5, 10, or 15 records at a time, depending on the value 
 they select from a drop-down. Meaning, depending on how many they
want

 to add, there will be that many forms, and one submit button to add 
 all the records.

 I'm thinking I need a loop somewhere, but not sure where.

 Any help is greatly appreciated!

 Here's what I have so far:

 addSite.cfm:


 form name=MultiForm 
 action=addSite.cfm?MultiForm=TRUENumForms=#NumForms#
   select name=NumForms
option value=55/option
 option value=10 selected10/option
 option value=1515/option
   /select
   input name= type=submit value=Show
 /form

  cfif MultiForm IS True
 form action=addSite2.cfm method=post name=addSite
cfloop from=0 to=URL.NumForms index=i
   table width=100% border=0 cellspacing=2 cellpadding=5
 tr
   td width=24% class=copyTealdiv align=rightAuthor
Name:

 /div/td
   td width=76%input name=Website_author type=text 
 id=Website_author/td
 /tr
 tr
   td class=copyTealdiv align=rightWebsite
link:/div/td
   tdp
   input name=Website_Link type=text id=Website_Link 
 size=45
 /p
 pspan class=tealHeaderPlease include the http:// and 
 remember to
   verify the link's accuracy./span/p/td
 /tr
   /table
   p class=tealHeader
 input type=submit value=Continue
   /p/cfloop
   /form

   cfelse
   form action=addSite2.cfm method=post name=addSite
table width=100% border=0 cellspacing=2 cellpadding=5
 tr
   td width=24% class=copyTealdiv align=rightAuthor
Name:

 /div/td
   td width=76%input name=Website_author type=text 
 id=Website_author/td
 /tr
 tr
   td class=copyTealdiv align=rightWebsite
link:/div/td
   tdp
   input name=Website_Link type=text id=Website_Link 
 size=45
 /p
 pspan class=tealHeaderPlease include the
http:// and remember to
  verify the link's accuracy./span/p/td
/tr
  /table
  p class=tealHeader
input type=submit value=Continue
  /p
  /form

  /cfif


The problem is that the page is trying to run the loop regardless of
if
the upper form has been submitted or not. And then it says that my
to
value is invalid because it isn't a simple data type.

Thanks for taking the time to read my rambling :)

Candace K. Cottrell, Web Developer
The Children's Medical Center
One Children's Plaza
Dayton, OH 45404
937-641-4293
http://www.childrensdayton.org 


[EMAIL PROTECTED] 




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads 

Re: CF Server Mappings

2003-04-04 Thread Matt Kornguth
Thanks Barney, Al,  Chris

On 4/3/2003 5:11 PM, Barney Boisvert [EMAIL PROTECTED] wrote:
This is somewhat off topic, but if you don't want to put settings 
like this
in every directory's Application.cfm, just set up your Application.cfm 
files
to cascade.  Then you can abstract things up to a single place:

/Application.cfm

cfset request.dsn = asdf /
cfif cgi.remote_addr EQ 1.1.1.1
   cfset path = dev/ /
cfelse
   cfset path = prod/ /
/cfif
!--- global application variables ---

/users/Application.cfm
--
cfinclude template=../Application.cfm /
!--- user directory specific app variables ---

/products/Application.cfm
-
cfinclude template=../Application.cfm /
cfset request.catalog_dsn = whatever /

/products/order/Application.cfm
-
cfinclude template=../Application.cfm /
cfset request.payment_gateway = 1.1.1.2 /



---
Barney Boisvert, Senior Development Engineer
AudienceCentral (formerly PIER System, Inc.)
[EMAIL PROTECTED]
voice : 360.756.8080 x12
fax   : 360.647.5351

www.audiencecentral.com

 -Original Message-
 From: Al Musella, DPM [mailto:[EMAIL PROTECTED]
 Sent: Thursday, April 03, 2003 2:03 PM
 To: CF-Talk
 Subject: Re: CF Server Mappings


What I do is set a variable in the application.cfm called
 path, and then
 whereever you need a mapping, just use:
   #path#
 for example, instead of dev/images
 you set #path#  = 'dev/'
 then call:
 #path#images

 I actually use a little conditional logic in the application.cfm 
to
 automate it.. I set the path depending on the ip address of the
 host.  This
 way I can move it from my development machine to the server, which 
has a
 different directory structure, but the conditional logic is just
 in 1 place
 (per directory), not all over the place.

 Al

 At 09:25 AM 4/3/2003, Matt Kornguth wrote:
 Think the answer to this is No, but worth a try:
 
 We recently moved our development and staging sites onto the
 same physical
 server running CF 5.0. We are running into the situation where 
our CF
 server mappings are pointing to specific directories on EITHER 
dev or
 staging. So, when working on dev, we may have to change a file
 in a mapped
 directory on staging ... or vice versa.
 
 Anyone know of a way (without conditional coding) to have the
 same server
 mapping point to the correct mapped directory (i.e. dev when on 
dev,
 staging when on staging)? I know multiple instances of CF are
 not possible
 with 5.0, so any thoughts?
 
 Hope I conveyed the problem OK. Thanks for your help,
 Matt Kornguth
 BLR.com

 

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: compare

2003-04-04 Thread Robert Orlini
Thanks, but I think I should explain this a little better...

Col002 is a text (varchar in SQL) field imported from a log file which displays a date 
such as 04/04/03. 
I need to compare this field, 04/04/03, using the dateformat command which gives me 
the current numeric(?) date. Using the examples below I get a blank screen with no 
errors but no date comparison.

Robert O.

-Original Message-
From: Ben Doom [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 03, 2003 4:21 PM
To: CF-Talk
Subject: RE: compare 


I think you just need more quotes:

cfquery name=getsomedata datasource=application_log
select * from application2
where col002 = '#dateformat(now(), MM/DD/YY)#'
/cfquery


--  Ben Doom
Programmer  General Lackey
Moonbow Software, Inc

: -Original Message-
: From: Robert Orlini [mailto:[EMAIL PROTECTED]
: Sent: Thursday, April 03, 2003 4:08 PM
: To: CF-Talk
: Subject: compare
:
:
: I'm using an SQL table and comparing a date column which was
: imported from a log file. The date is setup as a varchar not a
: number. I would it so that the varchar date in the column can be
: compared with the current date (which of course is a number)
: using dateformat.
:
: The code I have is:
:
: cfquery name=getsomedata datasource=application_log
: select * from application2
: where col002 = #dateformat(now(),'MM/DD/YY')#
: /cfquery
:
: This of course does not work. What can I code in the where
: col002 section that compares the varchar date (which is written
: 04/03/03) with the current date using the CF dateformat command?
:
: Thanks!
:
: Robert O.
: HWW
:
: 

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Multiple forms, looping and inserting

2003-04-04 Thread Angel Stewart
Yesh! 
Okies! 

:)

-Gel


-Original Message-
From: Candace Cottrell [mailto:[EMAIL PROTECTED] 

Sounds like a plan, thanks Gel. I'll try it out when I get home :)
okies??  ;)
 

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: Count(*) Query

2003-04-04 Thread Dina Hess
You could do something like this:

SELECT TOP 1 (select count(qty) from items where qty = 1) AS num_1s, (select
count(qty) from items where qty = 2) AS num_2s
FROM items
GROUP BY qty

I'm sure there's a more efficient way to do this, but this should work.


- Original Message -
From: Hawkes, Keith A CIV [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, April 04, 2003 6:17 AM
Subject: Count(*) Query


 I have a table that has one field that holds numbers 1 thru 9.  Can I run
a
 single query that will give me the count(*) of 1's, count(*) of 2's, etc.
or
 do I have to run a separate query for each?

 Thanks to all,

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Count(*) Query

2003-04-04 Thread Matthew Small
SELECT Count(NumbersField) AS CountOfField
FROM table1
GROUP BY NumbersField

That does it, I tried it.

Matt Small

-Original Message-
From: Hawkes, Keith A CIV [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 04, 2003 7:18 AM
To: CF-Talk
Subject: Count(*) Query


I have a table that has one field that holds numbers 1 thru 9.  Can I
run a single query that will give me the count(*) of 1's, count(*) of
2's, etc. or do I have to run a separate query for each?

Thanks to all,

Keith

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



cfparam

2003-04-04 Thread Adrian Lynch
Anyone else thing cfparam would be more useful when if using it like this...

cfparam name=URL.id default=0 type=numeric

...was the same as using...

cfif NOT IsDefined(URL.id) OR NOT IsNumeric(URL.id)
cfset URL.id = 0
/cfif

...so the param kicks in if URL.id isn't defined OR if it isn't a number?

I'd never really used the type attribute in cfparam before and I was hoping
this was the way it worked.

Oh well :O(

Adrian Lynch
Web Developer
Thoughtbubble Ltd
--
United Kingdom
http://www.thoughtbubble.net
Ph: +44 (0) 20 7387 8890
--
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) 20 7387 8890

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: cfparam

2003-04-04 Thread Raymond Camden
 
   cfparam name=URL.id default=0 type=numeric
 
 ...was the same as using...
 
   cfif NOT IsDefined(URL.id) OR NOT IsNumeric(URL.id)
   cfset URL.id = 0
   /cfif
 
 ...so the param kicks in if URL.id isn't defined OR if it 
 isn't a number?
 

Correct. If url.id = ray, then you would get an error.


===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
(www.mindseye.com)
Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia)

Email: [EMAIL PROTECTED]
Blog : www.camdenfamily.com/morpheus/blog
Yahoo IM : morpheus

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

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: cfparam

2003-04-04 Thread Mike Townend
Afaik, with the cfparam name=URL.id default=0 type=numeric if URL.ID
is passed in as 8nb3b23k then it will throw an error, where as the if not
defined or not numeric code will still run...



HTH



-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 4, 2003 15:29
To: CF-Talk
Subject: cfparam


Anyone else thing cfparam would be more useful when if using it like this...

cfparam name=URL.id default=0 type=numeric

...was the same as using...

cfif NOT IsDefined(URL.id) OR NOT IsNumeric(URL.id)
cfset URL.id = 0
/cfif

...so the param kicks in if URL.id isn't defined OR if it isn't a number?

I'd never really used the type attribute in cfparam before and I was hoping
this was the way it worked.

Oh well :O(

Adrian Lynch
Web Developer
Thoughtbubble Ltd
--
United Kingdom
http://www.thoughtbubble.net
Ph: +44 (0) 20 7387 8890
--
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) 20 7387 8890


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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: cfparam

2003-04-04 Thread Andy Ewings
Prob is that CF doesn't set the datatype of a variable on creation (as in
other languages).  It determines it when it is referenced or tested.  Guess
it's good in some ways and bad in others.

-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: 04 April 2003 15:29
To: CF-Talk
Subject: cfparam


Anyone else thing cfparam would be more useful when if using it like this...

cfparam name=URL.id default=0 type=numeric

...was the same as using...

cfif NOT IsDefined(URL.id) OR NOT IsNumeric(URL.id)
cfset URL.id = 0
/cfif

...so the param kicks in if URL.id isn't defined OR if it isn't a number?

I'd never really used the type attribute in cfparam before and I was hoping
this was the way it worked.

Oh well :O(

Adrian Lynch
Web Developer
Thoughtbubble Ltd
--
United Kingdom
http://www.thoughtbubble.net
Ph: +44 (0) 20 7387 8890
--
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) 20 7387 8890


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re:Count(*) Query

2003-04-04 Thread jlangevin
Use the aggregate functions GROUP BY and WITH ROLLUP.  I just tested this and it
should work just fine for what you're trying to do.  Good luck.

SELECT  numberColumn,
COUNT(numberColumn) AS total
FROMnumberTable
GROUP BYnumberColumn
WITH ROLLUP
ORDER BYnumberColumn


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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re:Count(*) Query

2003-04-04 Thread jlangevin
Actually, didn't need the WITH ROLLUP.  It works just fine like this as well. WITH 
ROLLUP gives you a grand total as well which you probably don't need.

SELECT  number,
COUNT(number) AS total
FROMnumberTable
GROUP BYnumber
ORDER BYnumber


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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: cfparam

2003-04-04 Thread Adrian Lynch
I understand what it's doing, but I'd rather it worked like the example I
gave than throw an error.

Ade

-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]
Sent: 04 April 2003 15:32
To: CF-Talk
Subject: RE: cfparam


 
   cfparam name=URL.id default=0 type=numeric
 
 ...was the same as using...
 
   cfif NOT IsDefined(URL.id) OR NOT IsNumeric(URL.id)
   cfset URL.id = 0
   /cfif
 
 ...so the param kicks in if URL.id isn't defined OR if it 
 isn't a number?
 

Correct. If url.id = ray, then you would get an error.


===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
(www.mindseye.com)
Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia)

Email: [EMAIL PROTECTED]
Blog : www.camdenfamily.com/morpheus/blog
Yahoo IM : morpheus

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


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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Count(*) Query

2003-04-04 Thread Philip Arnold
 SELECT Count(NumbersField) AS CountOfField
 FROM table1
 GROUP BY NumbersField

 That does it, I tried it.

But you only get the Count, so you don't know what it's a count of...



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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: compare

2003-04-04 Thread Ben Doom
Have you tried doing something like LTrim(RTrim(Col002)) in case you're
accidentally importing spaces?

I'm just trying to think of anything, because it looks to me like the query
ought to run properly.  Have you tried running the query from the equivalent
of Query Analizer, so you can play with it easily?


--  Ben Doom
Programmer  General Lackey
Moonbow Software, Inc

: -Original Message-
: From: Robert Orlini [mailto:[EMAIL PROTECTED]
: Sent: Friday, April 04, 2003 8:45 AM
: To: CF-Talk
: Subject: RE: compare
:
:
: Thanks, but I think I should explain this a little better...
:
: Col002 is a text (varchar in SQL) field imported from a log file
: which displays a date such as 04/04/03.
: I need to compare this field, 04/04/03, using the dateformat
: command which gives me the current numeric(?) date. Using the
: examples below I get a blank screen with no errors but no date comparison.
:
: Robert O.
:
: -Original Message-
: From: Ben Doom [mailto:[EMAIL PROTECTED]
: Sent: Thursday, April 03, 2003 4:21 PM
: To: CF-Talk
: Subject: RE: compare
:
:
: I think you just need more quotes:
:
: cfquery name=getsomedata datasource=application_log
: select * from application2
: where col002 = '#dateformat(now(), MM/DD/YY)#'
: /cfquery
:
:
: --  Ben Doom
: Programmer  General Lackey
: Moonbow Software, Inc
:
: : -Original Message-
: : From: Robert Orlini [mailto:[EMAIL PROTECTED]
: : Sent: Thursday, April 03, 2003 4:08 PM
: : To: CF-Talk
: : Subject: compare
: :
: :
: : I'm using an SQL table and comparing a date column which was
: : imported from a log file. The date is setup as a varchar not a
: : number. I would it so that the varchar date in the column can be
: : compared with the current date (which of course is a number)
: : using dateformat.
: :
: : The code I have is:
: :
: : cfquery name=getsomedata datasource=application_log
: : select * from application2
: : where col002 = #dateformat(now(),'MM/DD/YY')#
: : /cfquery
: :
: : This of course does not work. What can I code in the where
: : col002 section that compares the varchar date (which is written
: : 04/03/03) with the current date using the CF dateformat command?
: :
: : Thanks!
: :
: : Robert O.
: : HWW
: :
: :
:
: 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Hiding JavaScript codes

2003-04-04 Thread Mosh Teitelbaum
Costas Piliotis wrote:
 cfparam name=cgi.http_referer default=
 cfif cgi.http_referer eq cfabort/cfif at the top.

 Then, in your script, just enter:
 script language=javascript src=temp.cfm/script

Costas Piliotis also wrote:
 The only way for one to do this is if they know how to pass their own http
 headers.  And then they need to know that you're looking at that
particular
 cgi variable, and they need to know what you're comparing to as well.  Too
 much trouble for a little piece of javascript IMHO...

Sorry if I'm coming late to the party, but you don't need to spoof headers
at all.  What follows is the high-tech security breaker:

A HREF=temp.cfmclick here to d/l the JS file/A

--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 942-5378
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: cfparam

2003-04-04 Thread Douglas.Knudsen
ugh...CFCATCH 

Doug

-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: Friday, April 04, 2003 9:54 AM
To: CF-Talk
Subject: RE: cfparam


I understand what it's doing, but I'd rather it worked like 
the example I
gave than throw an error.

Ade

-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]
Sent: 04 April 2003 15:32
To: CF-Talk
Subject: RE: cfparam


 
  cfparam name=URL.id default=0 type=numeric
 
 ...was the same as using...
 
  cfif NOT IsDefined(URL.id) OR NOT IsNumeric(URL.id)
  cfset URL.id = 0
  /cfif
 
 ...so the param kicks in if URL.id isn't defined OR if it 
 isn't a number?
 

Correct. If url.id = ray, then you would get an error.

===
=
===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
(www.mindseye.com)
Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia)

Email: [EMAIL PROTECTED]
Blog : www.camdenfamily.com/morpheus/blog
Yahoo IM : morpheus

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



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: CF Server Mappings

2003-04-04 Thread Thomas Chiverton
On Thursday 03 Apr 2003 16:00 pm, Chris Norloff wrote:
 Looking forward to our transition to CFMX for J2EE and multiple instances
 of CF!

Depends - we haven't be able to achive this with j2EE on WebLogic.

-- 
Tom C
Land of the free, home of the brave... you have to be brave to live there and 
enjoy the freedoms
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Count(*) Query

2003-04-04 Thread Matthew Small
You're right, I didn't see your query when I wrote this one.

-Original Message-
From: Philip Arnold [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 04, 2003 9:52 AM
To: CF-Talk
Subject: RE: Count(*) Query


 SELECT Count(NumbersField) AS CountOfField
 FROM table1
 GROUP BY NumbersField

 That does it, I tried it.

But you only get the Count, so you don't know what it's a count of...




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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re:OT: Outer Join

2003-04-04 Thread jlangevin
I think changing INNER JOIN csite c to
FULL OUTER JOIN csite c will work.

And I think you might have to add OR c.id IS NULL



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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



cfmx and clientmanagement-problem

2003-04-04 Thread Uwe Degenhardt
Hi list,
this is the email of a friend:

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



FED-Ex API calls

2003-04-04 Thread Ciliotta, Mario
Hi,

Has anyone been able to code a Cold Fusion page that can talk successfully with the 
Fed-Ex Ship API.  I have take a look on their site and as usually all the examples are 
in ASP/ASP.NET or Java.  I am trying to do this with CF of course.

If anyone has any info on this with using CF or even ASP or Java, can you let me know 
how you accomplished this.  I cannot get it to work at all.  


Thanks

Mario

This message is for the named person's use only. It may contain sensitive and private 
proprietary or legally privileged information. No confidentiality or privilege is 
waived or lost by any mistransmission. If you are not the intended recipient, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender. You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE FIRST BOSTON 
or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE FIRST BOSTON reserve 
the right to monitor all e-mail communications through its networks. Any views 
expressed in this message are those of the individual sender, except where the message 
states otherwise and the sender is authorized to state them to be the views of any 
such entity.
Unless otherwise stated, any pricing information given in this message is indicative  
only, is subject to change and does not constitute an offer to deal at any price 
quoted. Any reference to the terms of executed transactions should be treated as  
preliminary only and subject to our formal written confirmation.


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: FED-Ex API calls

2003-04-04 Thread Edwards Robert (air0rae)
Now why on earth would you want to interface with FedEx?  :)

After all UPS is now Synchronizing Commerce.

Rob 

UPS Developer

-Original Message-
From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 04, 2003 10:18 AM
To: CF-Talk
Subject: FED-Ex API calls


Hi,

Has anyone been able to code a Cold Fusion page that can talk successfully
with the Fed-Ex Ship API.  I have take a look on their site and as usually
all the examples are in ASP/ASP.NET or Java.  I am trying to do this with CF
of course.

If anyone has any info on this with using CF or even ASP or Java, can you
let me know how you accomplished this.  I cannot get it to work at all.  


Thanks

Mario

This message is for the named person's use only. It may contain sensitive
and private proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mistransmission. If
you are not the intended recipient, please immediately delete it and all
copies of it from your system, destroy any hard copies of it and notify the
sender. You must not, directly or indirectly, use, disclose, distribute,
print, or copy any part of this message if you are not the intended
recipient. CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE
FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT
SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications
through its networks. Any views expressed in this message are those of the
individual sender, except where the message states otherwise and the sender
is authorized to state them to be the views of any such entity. Unless
otherwise stated, any pricing information given in this message is
indicative  only, is subject to change and does not constitute an offer to
deal at any price quoted. Any reference to the terms of executed
transactions should be treated as  preliminary only and subject to our
formal written confirmation.



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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



cfcookie expires syntax

2003-04-04 Thread Sean McCarthy
I would like to expire a cookie after 10 min.  Something is not correct with
my syntax any ideas?

cfset foo = DateAdd(n, 10, Now())

cfcookie name = MYCOOKIE
value = #Now()#
expires = #foo#   



thanks!

sean

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: FED-Ex API calls

2003-04-04 Thread Marlon Moyer
Plus, UPS has a spiffy new Logo!

Edwards Robert (air0rae) wrote:

Now why on earth would you want to interface with FedEx?  :)

After all UPS is now Synchronizing Commerce.

Rob 

UPS Developer

-Original Message-
From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 04, 2003 10:18 AM
To: CF-Talk
Subject: FED-Ex API calls


Hi,

Has anyone been able to code a Cold Fusion page that can talk successfully
with the Fed-Ex Ship API.  I have take a look on their site and as usually
all the examples are in ASP/ASP.NET or Java.  I am trying to do this with CF
of course.

If anyone has any info on this with using CF or even ASP or Java, can you
let me know how you accomplished this.  I cannot get it to work at all.  


Thanks

Mario

This message is for the named person's use only. It may contain sensitive
and private proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mistransmission. If
you are not the intended recipient, please immediately delete it and all
copies of it from your system, destroy any hard copies of it and notify the
sender. You must not, directly or indirectly, use, disclose, distribute,
print, or copy any part of this message if you are not the intended
recipient. CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE
FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT
SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications
through its networks. Any views expressed in this message are those of the
individual sender, except where the message states otherwise and the sender
is authorized to state them to be the views of any such entity. Unless
otherwise stated, any pricing information given in this message is
indicative  only, is subject to change and does not constitute an offer to
deal at any price quoted. Any reference to the terms of executed
transactions should be treated as  preliminary only and subject to our
formal written confirmation.




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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: FED-Ex API calls

2003-04-04 Thread Ciliotta, Mario
Believe I wanted to go the UPS route, but I had no choice.  I assume the Fed-Ex was 
the low bidder on the contract and won - that's about all I know about it.

I am just a developer doing what I am told to do.

Yes the logo is nicer and I do want to drive the big brown truck :-)

But serious if anyone has any info it would really help.

Thanks

Mario

-Original Message-
From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED]
Sent: Friday, April 04, 2003 10:23 AM
To: CF-Talk
Subject: RE: FED-Ex API calls


Now why on earth would you want to interface with FedEx?  :)

After all UPS is now Synchronizing Commerce.

Rob 

UPS Developer

-Original Message-
From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 04, 2003 10:18 AM
To: CF-Talk
Subject: FED-Ex API calls


Hi,

Has anyone been able to code a Cold Fusion page that can talk successfully
with the Fed-Ex Ship API.  I have take a look on their site and as usually
all the examples are in ASP/ASP.NET or Java.  I am trying to do this with CF
of course.

If anyone has any info on this with using CF or even ASP or Java, can you
let me know how you accomplished this.  I cannot get it to work at all.  


Thanks

Mario

This message is for the named person's use only. It may contain sensitive
and private proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mistransmission. If
you are not the intended recipient, please immediately delete it and all
copies of it from your system, destroy any hard copies of it and notify the
sender. You must not, directly or indirectly, use, disclose, distribute,
print, or copy any part of this message if you are not the intended
recipient. CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE
FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT
SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications
through its networks. Any views expressed in this message are those of the
individual sender, except where the message states otherwise and the sender
is authorized to state them to be the views of any such entity. Unless
otherwise stated, any pricing information given in this message is
indicative  only, is subject to change and does not constitute an offer to
deal at any price quoted. Any reference to the terms of executed
transactions should be treated as  preliminary only and subject to our
formal written confirmation.




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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: FED-Ex API calls

2003-04-04 Thread Edwards Robert (air0rae)
What version of CF are you trying to do this with?

From what I know of the FedEx API, you can connect to it with Java, hence
you should be able to write a servlet/web service for Jrun/CFMX.

Another option is that you can use COM objects to connect with FedEx.  I
would think you create a CFOBJECT to instantiate the object and connect to
it using cfscript.

Just my thoughts.  I'd help more, but downloading FedEx's api on a UPS
machine would probably be a fireable offence. :)

Rob

-Original Message-
From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 04, 2003 10:36 AM
To: CF-Talk
Subject: RE: FED-Ex API calls


Believe I wanted to go the UPS route, but I had no choice.  I assume the
Fed-Ex was the low bidder on the contract and won - that's about all I know
about it.

I am just a developer doing what I am told to do.

Yes the logo is nicer and I do want to drive the big brown truck :-)

But serious if anyone has any info it would really help.

Thanks

Mario

-Original Message-
From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED]
Sent: Friday, April 04, 2003 10:23 AM
To: CF-Talk
Subject: RE: FED-Ex API calls


Now why on earth would you want to interface with FedEx?  :)

After all UPS is now Synchronizing Commerce.

Rob 

UPS Developer

-Original Message-
From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 04, 2003 10:18 AM
To: CF-Talk
Subject: FED-Ex API calls


Hi,

Has anyone been able to code a Cold Fusion page that can talk successfully
with the Fed-Ex Ship API.  I have take a look on their site and as usually
all the examples are in ASP/ASP.NET or Java.  I am trying to do this with CF
of course.

If anyone has any info on this with using CF or even ASP or Java, can you
let me know how you accomplished this.  I cannot get it to work at all.  


Thanks

Mario

This message is for the named person's use only. It may contain sensitive
and private proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mistransmission. If
you are not the intended recipient, please immediately delete it and all
copies of it from your system, destroy any hard copies of it and notify the
sender. You must not, directly or indirectly, use, disclose, distribute,
print, or copy any part of this message if you are not the intended
recipient. CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE
FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT
SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications
through its networks. Any views expressed in this message are those of the
individual sender, except where the message states otherwise and the sender
is authorized to state them to be the views of any such entity. Unless
otherwise stated, any pricing information given in this message is
indicative  only, is subject to change and does not constitute an offer to
deal at any price quoted. Any reference to the terms of executed
transactions should be treated as  preliminary only and subject to our
formal written confirmation.





~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



multiple instances of CFMX [was: CF Server Mappings]

2003-04-04 Thread Chris Norloff
Strange.  Any idea why?  CFMX for J2EE is just an app in a container, so I'm surprised 
it isn't pretty straight forward to have two CFMX's on one machine.

Of course, I might be even MORE surprised if I can't do it when we get it ourselves.

thanks,
Chris Norloff


-- Original Message --
From: Thomas Chiverton [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
date: Fri, 4 Apr 2003 16:00:20 +0100

On Thursday 03 Apr 2003 16:00 pm, Chris Norloff wrote:
 Looking forward to our transition to CFMX for J2EE and multiple instances
 of CF!

Depends - we haven't be able to achive this with j2EE on WebLogic.

-- 
Tom C
Land of the free, home of the brave... you have to be brave to live there and 
enjoy the freedoms

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



question

2003-04-04 Thread Shahzad.Butt
CFQuery name=Test datasource=DSN
Select *
From tb_test
/cfquery

(this query gives 34 results)

CFSet Test.RecordCount = 1

CFOUTPUT#Test.RecordCount#/CFOUTPUT

What should it display 34 or 1?

It display 1. Any reason why?

Shahzad Butt (Development Engineer)

JJ FastFood Distribution Ltd.
Office:  +44 (0) 1992 701 722
Mobile: +44 (0) 7803 584 873
Fax: +44 (0) 1992 701 604

7 Solar Way, Innova Park, Enfield, London, EN3 7XY


![EMAIL PROTECTED]@APOLLO!

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: question

2003-04-04 Thread Bryan F. Hogan
Because you reset it with your cfset


Bryan F. Hogan
Director of Internet Development
Team Macromedia Volunteer
Macromedia Certified ColdFusion MX Developer
Digital Bay Media, Inc.
1-877-72DIGITAL


-Original Message-
From: Shahzad.Butt [mailto:[EMAIL PROTECTED]
Sent: Friday, April 04, 2003 11:11 AM
To: CF-Talk
Subject: question


CFQuery name=Test datasource=DSN
Select *
From tb_test
/cfquery

(this query gives 34 results)

CFSet Test.RecordCount = 1

CFOUTPUT#Test.RecordCount#/CFOUTPUT

What should it display 34 or 1?

It display 1. Any reason why?

Shahzad Butt (Development Engineer)

JJ FastFood Distribution Ltd.
Office:  +44 (0) 1992 701 722
Mobile: +44 (0) 7803 584 873
Fax: +44 (0) 1992 701 604

7 Solar Way, Innova Park, Enfield, London, EN3 7XY


![EMAIL PROTECTED]@APOLLO!


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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: cfcookie expires syntax

2003-04-04 Thread Sean McCarthy
I have also tried:

cfcookie name = MYCOOKIE
value = foo
expires=#DateFormat(CreateDate(2001,12,31), 'ddd,
dd-mmm-')# #TimeFormat(CreateTime(00,00,00), 'HH:mm:ss')# GMT

with no luck

-Original Message-
From: Sean McCarthy 
Sent: Friday, April 04, 2003 10:26 AM
To: CF-Talk
Subject: cfcookie expires syntax


I would like to expire a cookie after 10 min.  Something is not correct with
my syntax any ideas?

cfset foo = DateAdd(n, 10, Now())

cfcookie name = MYCOOKIE
value = #Now()#
expires = #foo#   



thanks!

sean


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: cfcookie expires syntax

2003-04-04 Thread Bryan Stevenson
Use CreateTimeSpan(0,0,10,0)

Bryan Stevenson B.Comm.
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder  Director
www.cfug-vancouverisland.com
- Original Message -
From: Sean McCarthy [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, April 04, 2003 8:20 AM
Subject: RE: cfcookie expires syntax


 I have also tried:

 cfcookie name = MYCOOKIE
   value = foo
   expires=#DateFormat(CreateDate(2001,12,31), 'ddd,
 dd-mmm-')# #TimeFormat(CreateTime(00,00,00), 'HH:mm:ss')# GMT

 with no luck

 -Original Message-
 From: Sean McCarthy
 Sent: Friday, April 04, 2003 10:26 AM
 To: CF-Talk
 Subject: cfcookie expires syntax


 I would like to expire a cookie after 10 min.  Something is not correct
with
 my syntax any ideas?

 cfset foo = DateAdd(n, 10, Now())

 cfcookie name = MYCOOKIE
   value = #Now()#
   expires = #foo#



 thanks!

 sean


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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: cfcookie expires syntax

2003-04-04 Thread Bryan Stevenson
Actually the docs seem to say that you can't use minutes to timeout
acookie...only a future date or a number of days:

From the docs:
Expires:
Optional. Schedules the expiration of a cookie variable. Can be specified as
a date (as in, 10/09/97), number of days (as in, 10, 100), NOW, or NEVER.
Using NOW effectively deletes the cookie from the client's browser.

Bryan Stevenson B.Comm.
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder  Director
www.cfug-vancouverisland.com
- Original Message -
From: Sean McCarthy [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, April 04, 2003 8:20 AM
Subject: RE: cfcookie expires syntax


 I have also tried:

 cfcookie name = MYCOOKIE
   value = foo
   expires=#DateFormat(CreateDate(2001,12,31), 'ddd,
 dd-mmm-')# #TimeFormat(CreateTime(00,00,00), 'HH:mm:ss')# GMT

 with no luck

 -Original Message-
 From: Sean McCarthy
 Sent: Friday, April 04, 2003 10:26 AM
 To: CF-Talk
 Subject: cfcookie expires syntax


 I would like to expire a cookie after 10 min.  Something is not correct
with
 my syntax any ideas?

 cfset foo = DateAdd(n, 10, Now())

 cfcookie name = MYCOOKIE
   value = #Now()#
   expires = #foo#



 thanks!

 sean


 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: FED-Ex API calls

2003-04-04 Thread Bud
On 4/4/03, Ciliotta, Mario penned:
Hi,

Has anyone been able to code a Cold Fusion page that can talk 
successfully with the Fed-Ex Ship API.  I have take a look on their 
site and as usually all the examples are in ASP/ASP.NET or Java.  I 
am trying to do this with CF of course.

If anyone has any info on this with using CF or even ASP or Java, 
can you let me know how you accomplished this.  I cannot get it to 
work at all.


I'm waiting for the XML to come out this summer. This is all the info I have:

Click the link below to obtain a copy of the Seven-Step Implementation:

http://www.fedex.com/globaldeveloper/shipapi/implementation.pdf


In order to review the Implementation guide, you will need to have
Microsoft PowerPoint installed on your system.  If you do not have access
to the PowerPoint application, please go to the following website location
and download the powerpoint viewer.

http://office.microsoft.com/downloaddetails/ppview97.htm


If you have any additional questions or encounter any technical
difficulties/issues, please visit the Global Developer Program website and
review our technical and F.A.Q. (Frequently Asked Questions) sections.  You
may also wish to contact the API Support Team via email,
[EMAIL PROTECTED] or phone, 1-800-810-9073.

Thank you for choosing FedEx as a shipping solution,
API Technical Support Group
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
http://www.cf-ezcart.com/
954.721.3452
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Strange Error in CF MX Administrator

2003-04-04 Thread Ruggiero, Kevin D
We had another server hang this morning (we're at about 1 every 2 days now),
so I went through our logs and I found this error in the application log a
few minutes before the crash:

Could not find the included template cfadmin_5_unix.cfm.Note: If you wish to
use an absolute template path (e.g. TEMPLATE=/mypath/index.cfm) with
CFINCLUDE then you must create a mapping for the path using the ColdFusion
Administrator. Using relative paths (e.g. TEMPLATE=index.cfm or
TEMPLATE=../index.cfm) does not require the creation of any special
mappings. It is therefore recommended that you use relative paths with
CFINCLUDE whenever possible. The specific sequence of files included or
processed is: D:\Inetpub\wwwroot\CFIDE\componentutils\cfcexplorer.cfc 


This is an error in the CF Administrator itself, so I'm not sure what would
cause this.  Anybody seen it before or have a guess what would cause it?

Thanks,
Kevin
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: FED-Ex API calls

2003-04-04 Thread Ciliotta, Mario
Rob,

I have access to either MX or 4.5.  I do not have that much Java experience so I was 
kind of thinking of going that route but I am not sure where to even start.

Mario

-Original Message-
From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED]
Sent: Friday, April 04, 2003 10:57 AM
To: CF-Talk
Subject: RE: FED-Ex API calls


What version of CF are you trying to do this with?

From what I know of the FedEx API, you can connect to it with Java, hence
you should be able to write a servlet/web service for Jrun/CFMX.

Another option is that you can use COM objects to connect with FedEx.  I
would think you create a CFOBJECT to instantiate the object and connect to
it using cfscript.

Just my thoughts.  I'd help more, but downloading FedEx's api on a UPS
machine would probably be a fireable offence. :)

Rob

-Original Message-
From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 04, 2003 10:36 AM
To: CF-Talk
Subject: RE: FED-Ex API calls


Believe I wanted to go the UPS route, but I had no choice.  I assume the
Fed-Ex was the low bidder on the contract and won - that's about all I know
about it.

I am just a developer doing what I am told to do.

Yes the logo is nicer and I do want to drive the big brown truck :-)

But serious if anyone has any info it would really help.

Thanks

Mario

-Original Message-
From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED]
Sent: Friday, April 04, 2003 10:23 AM
To: CF-Talk
Subject: RE: FED-Ex API calls


Now why on earth would you want to interface with FedEx?  :)

After all UPS is now Synchronizing Commerce.

Rob 

UPS Developer

-Original Message-
From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 04, 2003 10:18 AM
To: CF-Talk
Subject: FED-Ex API calls


Hi,

Has anyone been able to code a Cold Fusion page that can talk successfully
with the Fed-Ex Ship API.  I have take a look on their site and as usually
all the examples are in ASP/ASP.NET or Java.  I am trying to do this with CF
of course.

If anyone has any info on this with using CF or even ASP or Java, can you
let me know how you accomplished this.  I cannot get it to work at all.  


Thanks

Mario

This message is for the named person's use only. It may contain sensitive
and private proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mistransmission. If
you are not the intended recipient, please immediately delete it and all
copies of it from your system, destroy any hard copies of it and notify the
sender. You must not, directly or indirectly, use, disclose, distribute,
print, or copy any part of this message if you are not the intended
recipient. CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE
FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT
SUISSE FIRST BOSTON reserve the right to monitor all e-mail communications
through its networks. Any views expressed in this message are those of the
individual sender, except where the message states otherwise and the sender
is authorized to state them to be the views of any such entity. Unless
otherwise stated, any pricing information given in this message is
indicative  only, is subject to change and does not constitute an offer to
deal at any price quoted. Any reference to the terms of executed
transactions should be treated as  preliminary only and subject to our
formal written confirmation.






~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Strange Error in CF MX Administrator

2003-04-04 Thread Ruggiero, Kevin D
Also, this is the entry in the exception.log:

Error,jrpp-74,04/04/03,10:32:41,,Could not find the included
template cfadmin_5_unix.cfm.Note: If you wish to use an absolute template
path (e.g. TEMPLATE=/mypath/index.cfm) with CFINCLUDE then you must
create a mapping for the path using the ColdFusion Administrator. Using
relative paths (e.g. TEMPLATE=index.cfm or TEMPLATE=../index.cfm)
does not require the creation of any special mappings. It is therefore
recommended that you use relative paths with CFINCLUDE whenever possible.
The specific sequence of files included or processed is:
D:\Inetpub\wwwroot\CFIDE\componentutils\cfcexplorer.cfc 
coldfusion.tagext.lang.IncludeTag$NoSuchIncludeTemplateException: Could not
find the included template cfadmin_5_unix.cfm.
at coldfusion.tagext.lang.IncludeTag.setTemplate(Unknown Source)
at
cflogin2ecfm1942167648.runPage(D:\Inetpub\wwwroot\CFIDE\componentutils\login
.cfm:92)
at coldfusion.runtime.CfJspPage.invoke(Unknown Source)
at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source)
at coldfusion.runtime.CfJspPage._emptyTag(Unknown Source)
at
cfApplication2ecfm1272781787.runPage(D:\Inetpub\wwwroot\CFIDE\componentutils
\Application.cfm:54)
at coldfusion.runtime.CfJspPage.invoke(Unknown Source)
at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source)
at coldfusion.filter.CfincludeFilter.invoke(Unknown Source)
at coldfusion.filter.CfincludeFilter.include(Unknown Source)
at coldfusion.filter.ApplicationFilter.invoke(Unknown Source)
at coldfusion.filter.ExceptionFilter.invoke(Unknown Source)
at coldfusion.filter.BrowserFilter.invoke(Unknown Source)
at coldfusion.filter.PathFilter.invoke(Unknown Source)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown
Source)
at coldfusion.filter.GlobalsFilter.invoke(Unknown Source)
at coldfusion.filter.DatasourceFilter.invoke(Unknown Source)
at coldfusion.xml.rpc.CFCServlet.invoke(Unknown Source)
at coldfusion.xml.rpc.CFCServlet.doGet(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at
org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:
335)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at
jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:226)
at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198)
at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:
348)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451
)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:29
4)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)



 -Original Message-
 From: Ruggiero, Kevin D 
 Sent: Friday, April 04, 2003 11:34 AM
 To: CF-Talk
 Subject: Strange Error in CF MX Administrator
 
 
 We had another server hang this morning (we're at about 1 
 every 2 days now),
 so I went through our logs and I found this error in the 
 application log a
 few minutes before the crash:
 
 Could not find the included template cfadmin_5_unix.cfm.Note: 
 If you wish to
 use an absolute template path (e.g. 
 TEMPLATE=/mypath/index.cfm) with
 CFINCLUDE then you must create a mapping for the path using 
 the ColdFusion
 Administrator. Using relative paths (e.g. TEMPLATE=index.cfm or
 TEMPLATE=../index.cfm) does not require the creation of 
 any special
 mappings. It is therefore recommended that you use relative paths with
 CFINCLUDE whenever possible. The specific sequence of files 
 included or
 processed is: D:\Inetpub\wwwroot\CFIDE\componentutils\cfcexplorer.cfc 
 
 
 This is an error in the CF Administrator itself, so I'm not 
 sure what would
 cause this.  Anybody seen it before or have a guess what 
 would cause it?
 
 Thanks,
 Kevin
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: multiple instances of CFMX [was: CF Server Mappings]

2003-04-04 Thread Barney Boisvert
You can put multiple CFMX's on one machine.  You can also put multiple
CFMX's on one J2EE server instance, as long as you use different context
paths.  However, unless you need the security that provides, I'd recommend
just using one, and have a two-part context path (to the CFMX server, and
then to the app's directory).  That way you don't need to have two copies of
the CF Server loaded in memory all the time.  In other words, rather than
this:

www.mydomain.com/cfapp1/
www.mydomain.com/cfapp2/

do this:

www.mydomain.com/cfmx/app1/
www.mydomain.com/cfmx/app2/



---
Barney Boisvert, Senior Development Engineer
AudienceCentral (formerly PIER System, Inc.)
[EMAIL PROTECTED]
voice : 360.756.8080 x12
fax   : 360.647.5351

www.audiencecentral.com

 -Original Message-
 From: Chris Norloff [mailto:[EMAIL PROTECTED]
 Sent: Friday, April 04, 2003 8:04 AM
 To: CF-Talk
 Subject: multiple instances of CFMX [was: CF Server Mappings]


 Strange.  Any idea why?  CFMX for J2EE is just an app in a
 container, so I'm surprised it isn't pretty straight forward to
 have two CFMX's on one machine.

 Of course, I might be even MORE surprised if I can't do it when
 we get it ourselves.

 thanks,
 Chris Norloff


 -- Original Message --
 From: Thomas Chiverton [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 date: Fri, 4 Apr 2003 16:00:20 +0100

 On Thursday 03 Apr 2003 16:00 pm, Chris Norloff wrote:
  Looking forward to our transition to CFMX for J2EE and
 multiple instances
  of CF!
 
 Depends - we haven't be able to achive this with j2EE on WebLogic.
 
 --
 Tom C
 Land of the free, home of the brave... you have to be brave to
 live there and
 enjoy the freedoms
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: question

2003-04-04 Thread Adrian Lynch
It displays 34(or rather the equivalent on my result set) on my test.

Ade

-Original Message-
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]
Sent: 04 April 2003 17:13
To: CF-Talk
Subject: RE: question


Because you reset it with your cfset


Bryan F. Hogan
Director of Internet Development
Team Macromedia Volunteer
Macromedia Certified ColdFusion MX Developer
Digital Bay Media, Inc.
1-877-72DIGITAL


-Original Message-
From: Shahzad.Butt [mailto:[EMAIL PROTECTED]
Sent: Friday, April 04, 2003 11:11 AM
To: CF-Talk
Subject: question


CFQuery name=Test datasource=DSN
Select *
From tb_test
/cfquery

(this query gives 34 results)

CFSet Test.RecordCount = 1

CFOUTPUT#Test.RecordCount#/CFOUTPUT

What should it display 34 or 1?

It display 1. Any reason why?

Shahzad Butt (Development Engineer)

JJ FastFood Distribution Ltd.
Office:  +44 (0) 1992 701 722
Mobile: +44 (0) 7803 584 873
Fax: +44 (0) 1992 701 604

7 Solar Way, Innova Park, Enfield, London, EN3 7XY


![EMAIL PROTECTED]@APOLLO!



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: question

2003-04-04 Thread Bruce Sorge
Because that is the first element in the list. cfoutput is like a loop. It
starts at the first record, and loops through to the last. If you tell it to
output a recordcount of 1, that it will only give you the first record. Make
sense?
- Original Message -
From: Shahzad.Butt [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, April 04, 2003 10:11 AM
Subject: question


 CFQuery name=Test datasource=DSN
 Select *
 From tb_test
 /cfquery

 (this query gives 34 results)

 CFSet Test.RecordCount = 1

 CFOUTPUT#Test.RecordCount#/CFOUTPUT

 What should it display 34 or 1?

 It display 1. Any reason why?

 Shahzad Butt (Development Engineer)

 JJ FastFood Distribution Ltd.
 Office:  +44 (0) 1992 701 722
 Mobile: +44 (0) 7803 584 873
 Fax: +44 (0) 1992 701 604

 7 Solar Way, Innova Park, Enfield, London, EN3 7XY


 ![EMAIL PROTECTED]@APOLLO!

 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: question

2003-04-04 Thread Shahzad.Butt
OK, it display 34 but how can I set it to 1. I was a bit screwed up and
said it displays 1. Actually it is displaying 34 but I want it to
display 1



-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED] 
Sent: 04 April 2003 18:01
To: CF-Talk
Subject: RE: question


It displays 34(or rather the equivalent on my result set) on my test.

Ade

-Original Message-
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]
Sent: 04 April 2003 17:13
To: CF-Talk
Subject: RE: question


Because you reset it with your cfset


Bryan F. Hogan
Director of Internet Development
Team Macromedia Volunteer
Macromedia Certified ColdFusion MX Developer
Digital Bay Media, Inc.
1-877-72DIGITAL


-Original Message-
From: Shahzad.Butt [mailto:[EMAIL PROTECTED]
Sent: Friday, April 04, 2003 11:11 AM
To: CF-Talk
Subject: question


CFQuery name=Test datasource=DSN
Select *
From tb_test
/cfquery

(this query gives 34 results)

CFSet Test.RecordCount = 1

CFOUTPUT#Test.RecordCount#/CFOUTPUT

What should it display 34 or 1?

It display 1. Any reason why?

Shahzad Butt (Development Engineer)

JJ FastFood Distribution Ltd.
Office:  +44 (0) 1992 701 722
Mobile: +44 (0) 7803 584 873
Fax: +44 (0) 1992 701 604

7 Solar Way, Innova Park, Enfield, London, EN3 7XY


![EMAIL PROTECTED]@APOLLO!




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: MX Sites Crossed

2003-04-04 Thread Jamie Jackson
On Wed, 2 Apr 2003 22:18:56 -0800, in cf-talk you wrote:

On Wednesday, Apr 2, 2003, at 19:01 US/Pacific, Matthew Walker wrote:
 http://www.macromedia.com/support/coldfusion/ts/documents/tn18258.htm

And this is mentioned in the Release Notes I believe...

Thanks for the RTFM, guys, that did the trick.

Jamie   

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: question

2003-04-04 Thread Barney Boisvert
If you want to maintain the recordset, you can't.  If you don't care about
the recordset, then do this:

cfset test = structNew() /
cfset test.recordcount = 1 /

the 'recordcount' attribute of a recordset is immutable.

---
Barney Boisvert, Senior Development Engineer
AudienceCentral (formerly PIER System, Inc.)
[EMAIL PROTECTED]
voice : 360.756.8080 x12
fax   : 360.647.5351

www.audiencecentral.com

 -Original Message-
 From: Shahzad.Butt [mailto:[EMAIL PROTECTED]
 Sent: Friday, April 04, 2003 9:03 AM
 To: CF-Talk
 Subject: RE: question


 OK, it display 34 but how can I set it to 1. I was a bit screwed up and
 said it displays 1. Actually it is displaying 34 but I want it to
 display 1



 -Original Message-
 From: Adrian Lynch [mailto:[EMAIL PROTECTED]
 Sent: 04 April 2003 18:01
 To: CF-Talk
 Subject: RE: question


 It displays 34(or rather the equivalent on my result set) on my test.

 Ade

 -Original Message-
 From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]
 Sent: 04 April 2003 17:13
 To: CF-Talk
 Subject: RE: question


 Because you reset it with your cfset

 
 Bryan F. Hogan
 Director of Internet Development
 Team Macromedia Volunteer
 Macromedia Certified ColdFusion MX Developer
 Digital Bay Media, Inc.
 1-877-72DIGITAL
 

 -Original Message-
 From: Shahzad.Butt [mailto:[EMAIL PROTECTED]
 Sent: Friday, April 04, 2003 11:11 AM
 To: CF-Talk
 Subject: question


 CFQuery name=Test datasource=DSN
 Select *
 From tb_test
 /cfquery

 (this query gives 34 results)

 CFSet Test.RecordCount = 1

 CFOUTPUT#Test.RecordCount#/CFOUTPUT

 What should it display 34 or 1?

 It display 1. Any reason why?

 Shahzad Butt (Development Engineer)

 JJ FastFood Distribution Ltd.
 Office:  +44 (0) 1992 701 722
 Mobile: +44 (0) 7803 584 873
 Fax: +44 (0) 1992 701 604

 7 Solar Way, Innova Park, Enfield, London, EN3 7XY


 ![EMAIL PROTECTED]@APOLLO!




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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: Hiding Javascript codes

2003-04-04 Thread Christian Cantrell
Ben,

Your best bet is to obfuscate your code.  As several people have  
demonstrated here, it is not possible to keep anyone who is even  
remotely determined from getting your code, but you can prevent them  
from understanding and reusing it.  This is by far the best technique I  
have seen used.

There are several companies out there that have entire business models  
partially riding on Javascript code (ad serving companies, site  
trackers, etc) and they typically do an extremely thorough job of  
obfuscating their code.  If all of your variables are named with a  
combination of random characters and hundreds of lines of script  
calling dozens of interwoven functions are all moved onto a single line  
with no whitespace at all, you code is pretty safe.

Christian

On Saturday, March 29, 2003, at 08:41 PM, DESIGN SHOP wrote:

 Hi all!,
 This may be a very dumb question.
 Is there any way at all to hide/encrypt Client side Javascript codes.
 We have a situation where we have to use certain client  side  
 Javascript
 codes which we wish to hide in the source code for security reasons.
 Any ideas??

 Thanks in advance


 Ben Thomas
 Uncertified  Dangerous
 Digital Internet Ltd.

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: question

2003-04-04 Thread Shahzad.Butt
Lovely stuff that's all I wanted. 

Thanks

-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED] 
Sent: 04 April 2003 18:11
To: CF-Talk
Subject: RE: question


If you want to maintain the recordset, you can't.  If you don't care
about the recordset, then do this:

cfset test = structNew() /
cfset test.recordcount = 1 /

the 'recordcount' attribute of a recordset is immutable.

---
Barney Boisvert, Senior Development Engineer
AudienceCentral (formerly PIER System, Inc.)
[EMAIL PROTECTED] voice : 360.756.8080 x12
fax   : 360.647.5351

www.audiencecentral.com

 -Original Message-
 From: Shahzad.Butt [mailto:[EMAIL PROTECTED]
 Sent: Friday, April 04, 2003 9:03 AM
 To: CF-Talk
 Subject: RE: question


 OK, it display 34 but how can I set it to 1. I was a bit screwed up 
 and said it displays 1. Actually it is displaying 34 but I want it to 
 display 1



 -Original Message-
 From: Adrian Lynch [mailto:[EMAIL PROTECTED]
 Sent: 04 April 2003 18:01
 To: CF-Talk
 Subject: RE: question


 It displays 34(or rather the equivalent on my result set) on my test.

 Ade

 -Original Message-
 From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]
 Sent: 04 April 2003 17:13
 To: CF-Talk
 Subject: RE: question


 Because you reset it with your cfset

 
 Bryan F. Hogan
 Director of Internet Development
 Team Macromedia Volunteer
 Macromedia Certified ColdFusion MX Developer
 Digital Bay Media, Inc.
 1-877-72DIGITAL
 

 -Original Message-
 From: Shahzad.Butt [mailto:[EMAIL PROTECTED]
 Sent: Friday, April 04, 2003 11:11 AM
 To: CF-Talk
 Subject: question


 CFQuery name=Test datasource=DSN
 Select *
 From tb_test
 /cfquery

 (this query gives 34 results)

 CFSet Test.RecordCount = 1

 CFOUTPUT#Test.RecordCount#/CFOUTPUT

 What should it display 34 or 1?

 It display 1. Any reason why?

 Shahzad Butt (Development Engineer)

 JJ FastFood Distribution Ltd.
 Office:  +44 (0) 1992 701 722
 Mobile: +44 (0) 7803 584 873
 Fax: +44 (0) 1992 701 604

 7 Solar Way, Innova Park, Enfield, London, EN3 7XY


 ![EMAIL PROTECTED]@APOLLO!




 

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: CFMX fails to respond under high load with IIS5

2003-04-04 Thread Ruggiero, Kevin D
 
 Also, we have our CFMX servers simultaneous threads set to 
 100, and this 
 seems to have also helped with the crashing which is much 
 less frequent now.

Is this setting enabled with the:
Limit simultaneous requests to: (textbox)
option in ColdFusion administrator?

We're having a problem right now with crashes and I'd like to try this.
Also, why did you settle on 100?  I'm just wondering if there's any formula
behind it, etc.

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Count(*) Query

2003-04-04 Thread Hawkes, Keith A CIV
YOU GUYS ROCK!!!

Keith
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: question

2003-04-04 Thread Bryan F. Hogan
Boy, was my answer dumb.


Bryan F. Hogan
Director of Internet Development
Team Macromedia Volunteer
Macromedia Certified ColdFusion MX Developer
Digital Bay Media, Inc.
1-877-72DIGITAL


-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: Friday, April 04, 2003 12:01 PM
To: CF-Talk
Subject: RE: question


It displays 34(or rather the equivalent on my result set) on my test.

Ade

-Original Message-
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]
Sent: 04 April 2003 17:13
To: CF-Talk
Subject: RE: question


Because you reset it with your cfset


Bryan F. Hogan
Director of Internet Development
Team Macromedia Volunteer
Macromedia Certified ColdFusion MX Developer
Digital Bay Media, Inc.
1-877-72DIGITAL


-Original Message-
From: Shahzad.Butt [mailto:[EMAIL PROTECTED]
Sent: Friday, April 04, 2003 11:11 AM
To: CF-Talk
Subject: question


CFQuery name=Test datasource=DSN
Select *
From tb_test
/cfquery

(this query gives 34 results)

CFSet Test.RecordCount = 1

CFOUTPUT#Test.RecordCount#/CFOUTPUT

What should it display 34 or 1?

It display 1. Any reason why?

Shahzad Butt (Development Engineer)

JJ FastFood Distribution Ltd.
Office:  +44 (0) 1992 701 722
Mobile: +44 (0) 7803 584 873
Fax: +44 (0) 1992 701 604

7 Solar Way, Innova Park, Enfield, London, EN3 7XY


![EMAIL PROTECTED]@APOLLO!




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: Count(*) Query

2003-04-04 Thread Tony Schreiber
SELECT number, count(*) FROM table
GROUP BY number

 I have a table that has one field that holds numbers 1 thru 9.  Can I run a
 single query that will give me the count(*) of 1's, count(*) of 2's, etc. or
 do I have to run a separate query for each?

 Thanks to all,

 Keith
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: cfparam

2003-04-04 Thread Christian Cantrell
On Friday, April 4, 2003, at 09:54 AM, Adrian Lynch wrote:

 I understand what it's doing, but I'd rather it worked like the 
 example I
 gave than throw an error.

So write a custom tag that works the way you want it to, publish it 
here, and get famous.

Whenever I come across a tag that doesn't work exactly like I want it 
to, I wrap it up in a custom tag that I like better.  I've even 
experimented with doing this with HTML that I don't like so that 
something like this...

table width=100% cellpadding=0 cellspacing=0 broder=0

... becomes this ...

my:table

All attributes have defaults that I can override if I want.  I haven't 
used anything like this in a production environment yet, though, 
because I would want to see if adds too much overhead (I use a lot of 
table tags), but it's an interesting idea.

Christian
http://www.macromedia.com/go/cantrell

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: cfparam

2003-04-04 Thread Jim Davis
 -Original Message-
 From: Adrian Lynch [mailto:[EMAIL PROTECTED] 
 Sent: Friday, April 04, 2003 9:54 AM
 To: CF-Talk
 Subject: RE: cfparam
 
 
 I understand what it's doing, but I'd rather it worked like 
 the example I gave than throw an error.

Of course if it did this thread would have been created by somebody else
wishing it worked the other way.  ;^)

You can't please everybody so CF's core philosophy has always been to
make things work the way most people would use it most of the time.
It's part of it's abstraction-of-complexity mission.

When you wan't to do something different or more complex CF provides
many avenues of extension for you.

I suppose that a new attribute - something like
ApplyDefaultForTypeMismatch but named better would solve it... But
that would require a change to the language.

A simpler option considering is to create a CustomTag or UDF that does
just what you described and use that instead.  By using the Is()
functions inside a case statement with try catch this should be very
easy.

Then you'd call CF_ParamPlus (or maybe even
CF_ParamTheWayIDamnWellWantIt or, my favorite CF_ParamALamaDingDing)
instead of CFPARAM.

Jim Davis


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: multiple instances of CFMX [was: CF Server Mappings]

2003-04-04 Thread Chris Norloff
Thanks, that makes sense.  Though in our case we WANT to have two copies of the 
cfserver - so we can have two completely independent environments on one physical 
machine.

Chris Norloff

-- Original Message --
From: Barney Boisvert [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
date: Fri, 4 Apr 2003 08:55:04 -0800

You can put multiple CFMX's on one machine.  You can also put multiple
CFMX's on one J2EE server instance, as long as you use different context
paths.  However, unless you need the security that provides, I'd recommend
just using one, and have a two-part context path (to the CFMX server, and
then to the app's directory).  That way you don't need to have two copies of
the CF Server loaded in memory all the time.  In other words, rather than
this:

www.mydomain.com/cfapp1/
www.mydomain.com/cfapp2/

do this:

www.mydomain.com/cfmx/app1/
www.mydomain.com/cfmx/app2/



---
Barney Boisvert, Senior Development Engineer
AudienceCentral (formerly PIER System, Inc.)
[EMAIL PROTECTED]
voice : 360.756.8080 x12
fax   : 360.647.5351

www.audiencecentral.com

 -Original Message-
 From: Chris Norloff [mailto:[EMAIL PROTECTED]
 Sent: Friday, April 04, 2003 8:04 AM
 To: CF-Talk
 Subject: multiple instances of CFMX [was: CF Server Mappings]


 Strange.  Any idea why?  CFMX for J2EE is just an app in a
 container, so I'm surprised it isn't pretty straight forward to
 have two CFMX's on one machine.

 Of course, I might be even MORE surprised if I can't do it when
 we get it ourselves.

 thanks,
 Chris Norloff


 -- Original Message --
 From: Thomas Chiverton [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 date: Fri, 4 Apr 2003 16:00:20 +0100

 On Thursday 03 Apr 2003 16:00 pm, Chris Norloff wrote:
  Looking forward to our transition to CFMX for J2EE and
 multiple instances
  of CF!
 
 Depends - we haven't be able to achive this with j2EE on WebLogic.
 
 --
 Tom C
 Land of the free, home of the brave... you have to be brave to
 live there and
 enjoy the freedoms
 
 

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: question

2003-04-04 Thread Mark A. Kruger - CFG
Why would you want to do this?  Why not set a separate variable that does
not appear to be part of your query?  Throughout your code, recordcount
should probably usually (always) refer to the total number of rows returned
by a query. Making it mean something else may not be wise.

-mark

-Original Message-
From: Shahzad.Butt [mailto:[EMAIL PROTECTED]
Sent: Friday, April 04, 2003 11:03 AM
To: CF-Talk
Subject: RE: question


OK, it display 34 but how can I set it to 1. I was a bit screwed up and
said it displays 1. Actually it is displaying 34 but I want it to
display 1



-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: 04 April 2003 18:01
To: CF-Talk
Subject: RE: question


It displays 34(or rather the equivalent on my result set) on my test.

Ade

-Original Message-
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]
Sent: 04 April 2003 17:13
To: CF-Talk
Subject: RE: question


Because you reset it with your cfset


Bryan F. Hogan
Director of Internet Development
Team Macromedia Volunteer
Macromedia Certified ColdFusion MX Developer
Digital Bay Media, Inc.
1-877-72DIGITAL


-Original Message-
From: Shahzad.Butt [mailto:[EMAIL PROTECTED]
Sent: Friday, April 04, 2003 11:11 AM
To: CF-Talk
Subject: question


CFQuery name=Test datasource=DSN
Select *
From tb_test
/cfquery

(this query gives 34 results)

CFSet Test.RecordCount = 1

CFOUTPUT#Test.RecordCount#/CFOUTPUT

What should it display 34 or 1?

It display 1. Any reason why?

Shahzad Butt (Development Engineer)

JJ FastFood Distribution Ltd.
Office:  +44 (0) 1992 701 722
Mobile: +44 (0) 7803 584 873
Fax: +44 (0) 1992 701 604

7 Solar Way, Innova Park, Enfield, London, EN3 7XY


![EMAIL PROTECTED]@APOLLO!





~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



CFLOCK around CFDIRECTORY?

2003-04-04 Thread Richmond, Pamela
Is it necessary (or good practice) to put CFLOCK around CFDIRECTORY?
 
If I understand correctly, CFLOCKs should be used around CFFILEs.  If
someone knows of a good article on non-db locking in CF, I'd appreciate it.
Most of the resources I'm finding provide details on using CFLOCK for CFXs
or CFQUERYs.
 
TIA
Pam

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Structure Referencing Problem

2003-04-04 Thread Jeff Chastain
I have a structure where the key and value items are URLEncoded strings
- i.e.
 
Key = Google%2Ecom
Value = http%3A%2F%2Fwww%2Egoogle%2Ecom
 
I am not being able to reference this value however.  If I try to access
structure(Google.com) or structure(Google%2Ecom) - both return the
following error:
 
Element ITEM is undefined in DGADGETSETTINGS
 
Any suggestions as to how to get this info out?
 
Thanks
-- Jeff

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: Structure Referencing Problem

2003-04-04 Thread Nick Han
i haven't tried it, but i am curious what would happen if you do something like this

#UrlDecode(structure[#urlDecode(key)#])#?

Nick Han

 [EMAIL PROTECTED] 04/04/03 09:56AM 
I have a structure where the key and value items are URLEncoded strings
- i.e.
 
Key = Google%2Ecom
Value = http%3A%2F%2Fwww%2Egoogle%2Ecom
 
I am not being able to reference this value however.  If I try to access
structure(Google.com) or structure(Google%2Ecom) - both return the
following error:
 
Element ITEM is undefined in DGADGETSETTINGS
 
Any suggestions as to how to get this info out?
 
Thanks
-- Jeff


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Structure Referencing Problem

2003-04-04 Thread Jeff Chastain
I have attempted to reference the value using both an encoded and
decoded key value - both have returned the same error message.  I
believe what you suggested was to attempt it with a decoded key -
correct?

-- Jeff


-Original Message-
From: Nick Han [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 04, 2003 12:15 PM
To: CF-Talk
Subject: Re: Structure Referencing Problem


i haven't tried it, but i am curious what would happen if you do
something like this

#UrlDecode(structure[#urlDecode(key)#])#?

Nick Han

 [EMAIL PROTECTED] 04/04/03 09:56AM 
I have a structure where the key and value items are URLEncoded strings
- i.e.
 
Key = Google%2Ecom
Value = http%3A%2F%2Fwww%2Egoogle%2Ecom
 
I am not being able to reference this value however.  If I try to access
structure(Google.com) or structure(Google%2Ecom) - both return the
following error:
 
Element ITEM is undefined in DGADGETSETTINGS
 
Any suggestions as to how to get this info out?
 
Thanks
-- Jeff



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: Structure Referencing Problem

2003-04-04 Thread Jeff Garza
I think you might be referencing your structure incorrectly.  Try using
brackets [] instead of parenthesis ()...

I got the following to work properly using CF5.0 on Win2000...

CFSET mylinks = structNew()
CFSET foo = StructInsert(mylinks, Google%2Ecom,
http%3A%2F%2Fwww%2Egoogle%2Ecom)
CFOUTPUT
CFLOOP collection=#mylinks# item=link
#URLDecode(link)# = #URLDecode(StructFind(mylinks, link))#
/CFLOOP
/CFOUTPUT
BRBR
Manual calling of mylinks[Google%2Ecom] =
CFOUTPUT#mylinks[Google%2Ecom]#/CFOUTPUT

HTH,

Jeff Garza

- Original Message -
From: Jeff Chastain [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, April 04, 2003 10:56 AM
Subject: Structure Referencing Problem


I have a structure where the key and value items are URLEncoded strings
- i.e.

Key = Google%2Ecom
Value = http%3A%2F%2Fwww%2Egoogle%2Ecom

I am not being able to reference this value however.  If I try to access
structure(Google.com) or structure(Google%2Ecom) - both return the
following error:

Element ITEM is undefined in DGADGETSETTINGS

Any suggestions as to how to get this info out?

Thanks
-- Jeff


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: Structure Referencing Problem

2003-04-04 Thread John Quarto-vonTivadar
use brackets instead of parentheses?

- Original Message -
From: Jeff Chastain [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, April 04, 2003 12:56 PM
Subject: Structure Referencing Problem


 I have a structure where the key and value items are URLEncoded strings
 - i.e.

 Key = Google%2Ecom
 Value = http%3A%2F%2Fwww%2Egoogle%2Ecom

 I am not being able to reference this value however.  If I try to access
 structure(Google.com) or structure(Google%2Ecom) - both return the
 following error:

 Element ITEM is undefined in DGADGETSETTINGS

 Any suggestions as to how to get this info out?

 Thanks
 -- Jeff

 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Structure Referencing Problem

2003-04-04 Thread Jeff Chastain
That was it -- Thanks

-Original Message-
From: Jeff Garza [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 04, 2003 12:19 PM
To: CF-Talk
Subject: Re: Structure Referencing Problem


I think you might be referencing your structure incorrectly.  Try using
brackets [] instead of parenthesis ()...

I got the following to work properly using CF5.0 on Win2000...

CFSET mylinks = structNew()
CFSET foo = StructInsert(mylinks, Google%2Ecom,
http%3A%2F%2Fwww%2Egoogle%2Ecom)
CFOUTPUT
CFLOOP collection=#mylinks# item=link
#URLDecode(link)# = #URLDecode(StructFind(mylinks, link))# /CFLOOP
/CFOUTPUT BRBR Manual calling of mylinks[Google%2Ecom] =
CFOUTPUT#mylinks[Google%2Ecom]#/CFOUTPUT

HTH,

Jeff Garza

- Original Message -
From: Jeff Chastain [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, April 04, 2003 10:56 AM
Subject: Structure Referencing Problem


I have a structure where the key and value items are URLEncoded strings
- i.e.

Key = Google%2Ecom
Value = http%3A%2F%2Fwww%2Egoogle%2Ecom

I am not being able to reference this value however.  If I try to access
structure(Google.com) or structure(Google%2Ecom) - both return the
following error:

Element ITEM is undefined in DGADGETSETTINGS

Any suggestions as to how to get this info out?

Thanks
-- Jeff



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



CFPOP From and db

2003-04-04 Thread Kris Pilles
I am trying to use CFPOP to look for a certain email address in the
FROM.

I have the address I am looking for stored in my DB.

I know that the email I am looking for is there (I can see it) but when
I try to compare the CFPOP.From to the address in my DB I never get a
match???

Anyone have any ideas??? 


!--- Declare Variables---
cfquery name=GetVars datasource=DSN
select * from settings
/cfquery
!--- Get New Mail ---
cfquery name=getpops datasource=DSN
select *
from pop3
/cfquery
CFLOOP QUERY=getpops
STARTROW=1
ENDROW=#getpops.recordcount#
CFPOP 
   server=#getpops.pop3_server#
username=#getpops.pop_username#
password=#getpops.pop_password#
action=GetAll
NAME=MailList

strongLooking for:/strong cfoutput#GetVars.CLFrom#/cfoutput
BRBR
cfoutput query=maillist
cfset trimaddress = trim(#mailList.from#)

cfif '#trimaddress#' NEQ '#GetVars.CLFrom#'

/cfif
/cfoutput
/CFLoop



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


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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Formatting output question

2003-04-04 Thread ecreese
I have a message form where users submit a form via a textarea box. In this textarea 
box they may make a carriage return. When I output the message everything is on one 
line and the carriage returns are not there. I looked in the datbase and the lines are 
setup with carriage returns.

Example
a
b
c

When I out put I get 
a b c

How do I format this to keep the carriage returns?


Get your own free email account from
http://www.popmail.com

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Formatting output question

2003-04-04 Thread Ben Doom
Use replace() to add br tags to the carriage returns.


--  Ben Doom
Programmer  General Lackey
Moonbow Software, Inc

: -Original Message-
: From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
: Sent: Friday, April 04, 2003 1:40 PM
: To: CF-Talk
: Subject: Formatting output question
:
:
: I have a message form where users submit a form via a textarea
: box. In this textarea box they may make a carriage return. When I
: output the message everything is on one line and the carriage
: returns are not there. I looked in the datbase and the lines are
: setup with carriage returns.
:
: Example
: a
: b
: c
:
: When I out put I get
: a b c
:
: How do I format this to keep the carriage returns?
:
: 
: Get your own free email account from
: http://www.popmail.com
:
: 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Run CF Studio 4 and 4.5 on same machine?

2003-04-04 Thread Jim McAtee
I've been running CF Studio 4 for just about forever.  I recall trying 4.5 quite
a while ago and not particularly liking it, but I'd like to try it out again.

Can I run both on the same machine, so that I could uninstall one or the other
if I choose?  It would be easier than installing, uninstalling, reinstalling, if
I want to go back to 4.

Thanks,
Jim

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Time Format Question

2003-04-04 Thread Randell B Adkins
ok I have a field which allows a user to enter a 
time format MASK to be used when displaying 
time on a website.

Example: user enters:  H:MM:SS TT

This is a proepr formatting mask for TIMEFORMAT.

However if a user enters: NOTIMEFORMAT or something
stupid and off the wall, the timeformat function should
blow up.

I entered: MONKEY as a mask and the TIMEFORMAT
function output: 
#TimeFormat(Now(),MONKEY)# = 2O'N'K'E'Y


I also tried to use IsDate in conjunction with CREATEDATE
so I could have a valid date but an invalid time and it
returns as a true statement that it is a DATE.

There is not IStime function.. anyone have an idea?

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Hiding JavaScript codes

2003-04-04 Thread Costas Piliotis
Okay okay...  I know Dave...  You're right of course...  The browser has to
read the file, ergo it can be downloaded and viewed.  However that being
said, it still somewhat helps, even a little...

Any web developer with a modicum of common sense
I have a modicum of common sense, I was just trying to help the guy out so
he can keep dumb people out at least...  To simply say you can't doesn't
do anyone any good.  I may have understated how simple it was...

I for one wouldn't go to that much effort to borrow a snippet.  There's so
much out there that if someone really doesn't want me to take it, I'll just
move on.  Chances are he isn't the first one to come up with that script
idea, and won't be the last.



-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Thursday, April 03, 2003 7:40 PM
To: CF-Talk
Subject: RE: Hiding JavaScript codes


 Actually, you kind of can I think...
 
 You can use a cfm file as a .js file to emulate a javascript
 file. Change the extension to .cfm... Careful, cf studio 
 won't correctly parse it, but nonetheless it'll work...  
 Just tested it.
 
 cfparam name=cgi.http_referer default=
 cfif cgi.http_referer eq cfabort/cfif at the top.
 
 Then, in your script, just enter:
 script language=javascript src=temp.cfm/script
 
 In THEORY, the .js will come up blank unless it's called
 from another file on your site.
 
 Tweak it as you wish. It should keep prying eyes from
 reading your .js file.

 This isn't 100% bulletproof, but should work for the most
 part. You can of course get more anal on the file and 
 verify the referer more carefully.

If prying eyes are being used in concert with a brain (or just common,
off-the-shelf software), this won't stop them from seeing your Javascript.

 I know, you cannot for sure, 100% hide it... Cgi variables
 can be spoofed. Still better than leaving it wide open if 
 you want to lock it down...
 
 It's like your house. Just because someone can break a
 window doesn't mean you should leave the door unlocked.  
 Nothing is really 100% secure. But it protects you from 
 everyone but the elite hacker.

This is a poor analogy. Perhaps a better one would be locking your door, but
leaving the key under the mat. But that doesn't really do justice to the
situation either. The simple fact is, securing your house is quite a bit
different from securing application code, and you simply can't secure code
that is being downloaded to the client.

Any web developer with a modicum of common sense knows that for your browser
to run Javascript, it has to be downloaded to the browser. If your browser
can get to it, so can the web developer. Knowing this, it's pretty trivial
to figure out how to do this - just send the same message to the server that
your browser sends. (Or, for that matter, just fetch it from the browser
cache.) You certainly don't have to be an elite hacker to do this.

 The only way for one to do this is if they know how to pass
 their own http headers. And then they need to know that you're 
 looking at that particular cgi variable, and they need to know 
 what you're comparing to as well. Too much trouble for a little 
 piece of javascript IMHO...

It's no trouble at all. Again, the developer doesn't have to know what
variable you're checking against - it really doesn't matter at all. All the
developer has to do is send the same HTTP request that your browser sent.
Since HTTP requests are just text, this is a very easy thing to do. Any
packet sniffer or recording proxy will tell you exactly what that text is.
I've recently started using EffeTech HTTP Sniffer for this sort of thing -
it just does HTTP, but it will let you refetch any file automatically, among
other things. But you don't have to spend $40 to do this - you can use free
tools like Ethereal.

Finally, keep in mind that your approach means more (unnecessary) work for
your CF server, and defeats the primary purpose of using external source
files in the first place - caching!

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


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: Formatting output question

2003-04-04 Thread cf-talk
To expand on what Ben said below... try this:

Replace(string,Chr(13),br,ALL)

-Novak

- Original Message -
From: Ben Doom [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, April 04, 2003 10:42 AM
Subject: RE: Formatting output question


 Use replace() to add br tags to the carriage returns.


 --  Ben Doom
 Programmer  General Lackey
 Moonbow Software, Inc

 : -Original Message-
 : From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
 : Sent: Friday, April 04, 2003 1:40 PM
 : To: CF-Talk
 : Subject: Formatting output question
 :
 :
 : I have a message form where users submit a form via a textarea
 : box. In this textarea box they may make a carriage return. When I
 : output the message everything is on one line and the carriage
 : returns are not there. I looked in the datbase and the lines are
 : setup with carriage returns.
 :
 : Example
 : a
 : b
 : c
 :
 : When I out put I get
 : a b c
 :
 : How do I format this to keep the carriage returns?
 :
 : 
 : Get your own free email account from
 : http://www.popmail.com
 :
 :
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Time Format Question

2003-04-04 Thread Mosh Teitelbaum
Either create a regex that checks what the user entered for correctness or,
instead of letting the user enter the mask free form, let them choose from a
predetermined number of masks via a SELECT list.

--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 942-5378
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/


 -Original Message-
 From: Randell B Adkins [mailto:[EMAIL PROTECTED]
 Sent: Friday, April 04, 2003 2:03 PM
 To: CF-Talk
 Subject: Time Format Question


 ok I have a field which allows a user to enter a
 time format MASK to be used when displaying
 time on a website.

 Example: user enters:  H:MM:SS TT

 This is a proepr formatting mask for TIMEFORMAT.

 However if a user enters: NOTIMEFORMAT or something
 stupid and off the wall, the timeformat function should
 blow up.

 I entered: MONKEY as a mask and the TIMEFORMAT
 function output:
 #TimeFormat(Now(),MONKEY)# = 2O'N'K'E'Y


 I also tried to use IsDate in conjunction with CREATEDATE
 so I could have a valid date but an invalid time and it
 returns as a true statement that it is a DATE.

 There is not IStime function.. anyone have an idea?

 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Formatting output question

2003-04-04 Thread Barney Boisvert
Or the paragraphFormat() function.



---
Barney Boisvert, Senior Development Engineer
AudienceCentral (formerly PIER System, Inc.)
[EMAIL PROTECTED]
voice : 360.756.8080 x12
fax   : 360.647.5351

www.audiencecentral.com

 -Original Message-
 From: Ben Doom [mailto:[EMAIL PROTECTED]
 Sent: Friday, April 04, 2003 10:43 AM
 To: CF-Talk
 Subject: RE: Formatting output question


 Use replace() to add br tags to the carriage returns.


 --  Ben Doom
 Programmer  General Lackey
 Moonbow Software, Inc

 : -Original Message-
 : From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
 : Sent: Friday, April 04, 2003 1:40 PM
 : To: CF-Talk
 : Subject: Formatting output question
 :
 :
 : I have a message form where users submit a form via a textarea
 : box. In this textarea box they may make a carriage return. When I
 : output the message everything is on one line and the carriage
 : returns are not there. I looked in the datbase and the lines are
 : setup with carriage returns.
 :
 : Example
 : a
 : b
 : c
 :
 : When I out put I get
 : a b c
 :
 : How do I format this to keep the carriage returns?
 :
 : 
 : Get your own free email account from
 : http://www.popmail.com
 :
 :
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



allaire MIB event log error

2003-04-04 Thread Douglas.Knudsen
Ok, I'm getting this error thing in my event log
Failure to connect to url: http://magnys2/cfide/mib/getmetricdataXML.cfm. 

Where does CF get the computer name used in the url above?  That's incorrect causing 
the error.

Using CF 5.0 on Win2K
I know what the file/reuest is for and all, I just can't figure out where CF is 
building the URL for the request.

Cheers!

--
Douglas Knudsen
Alltel Corporate
CIS Group
678-351-6063
Spoon feeding in the long run teaches us nothing but the shape of the spoon. - E.M. 
Forster 
NOTE!!  Magnys production changes occur on Friday evenings

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Time Format Question

2003-04-04 Thread Ryan Emerle
Why don't you just check to make sure the mask contains only the chars: 
h,H,m,M,s,S,t,T,: (or whatever the time chars are).

-R

-Original Message-
From: Randell B Adkins [mailto:[EMAIL PROTECTED]
Sent: Friday, April 04, 2003 2:03 PM
To: CF-Talk
Subject: Time Format Question


ok I have a field which allows a user to enter a 
time format MASK to be used when displaying 
time on a website.

Example: user enters:  H:MM:SS TT

This is a proepr formatting mask for TIMEFORMAT.

However if a user enters: NOTIMEFORMAT or something
stupid and off the wall, the timeformat function should
blow up.

I entered: MONKEY as a mask and the TIMEFORMAT
function output: 
#TimeFormat(Now(),MONKEY)# = 2O'N'K'E'Y


I also tried to use IsDate in conjunction with CREATEDATE
so I could have a valid date but an invalid time and it
returns as a true statement that it is a DATE.

There is not IStime function.. anyone have an idea?


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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Time Format Question

2003-04-04 Thread Barney Boisvert
TimeFormat (and DateFormat) ignore characters they don't understand and send
them directly to the output, with an apostrophe in there as well.  The
solution would be to strip out all illegal characters with an RE.


---
Barney Boisvert, Senior Development Engineer
AudienceCentral (formerly PIER System, Inc.)
[EMAIL PROTECTED]
voice : 360.756.8080 x12
fax   : 360.647.5351

www.audiencecentral.com

 -Original Message-
 From: Randell B Adkins [mailto:[EMAIL PROTECTED]
 Sent: Friday, April 04, 2003 11:03 AM
 To: CF-Talk
 Subject: Time Format Question


 ok I have a field which allows a user to enter a
 time format MASK to be used when displaying
 time on a website.

 Example: user enters:  H:MM:SS TT

 This is a proepr formatting mask for TIMEFORMAT.

 However if a user enters: NOTIMEFORMAT or something
 stupid and off the wall, the timeformat function should
 blow up.

 I entered: MONKEY as a mask and the TIMEFORMAT
 function output:
 #TimeFormat(Now(),MONKEY)# = 2O'N'K'E'Y


 I also tried to use IsDate in conjunction with CREATEDATE
 so I could have a valid date but an invalid time and it
 returns as a true statement that it is a DATE.

 There is not IStime function.. anyone have an idea?

 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Demo Version of CFMX with 5.0

2003-04-04 Thread Jim Curran
Hi all,

I just installed MX on the same machine as 5.  Everything is working AOK,
but just wanted to make sure i did the install right.

I installed MX as a standalone server.

In IIS, for sites that i want to use MX, i set the Application Mappings for
*.cfm etc to:

C:\CFusionMX\runtime\lib\wsconfig\1\jrun.dll

For CF5, I keep the Application Mappings for *.cfm as:

C:\CFusion\bin\iscf.dll

This seemed too easy...  so i wanted to check with you folk to see if there
is anything else I should have done.

Thanks in advance!!!

- jim


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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: allaire MIB event log error

2003-04-04 Thread Debbie Dickerson
It should be coming from \CFusion\cfam\Database\mib.properties

Deb

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 04, 2003 2:15 PM
To: CF-Talk
Subject: allaire MIB event log error


Ok, I'm getting this error thing in my event log
Failure to connect to url: http://magnys2/cfide/mib/getmetricdataXML.cfm. 

Where does CF get the computer name used in the url above?  That's incorrect causing 
the error.

Using CF 5.0 on Win2K
I know what the file/reuest is for and all, I just can't figure out where CF is 
building the URL for the request.

Cheers!

--
Douglas Knudsen
Alltel Corporate
CIS Group
678-351-6063
Spoon feeding in the long run teaches us nothing but the shape of the spoon. - E.M. 
Forster 
NOTE!!  Magnys production changes occur on Friday evenings


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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Time Format Question

2003-04-04 Thread Randell B Adkins
Cause the field does not need to have all those characters.
Trying to rule out someone putting in something that is not
part of the proper Time Mask paramters


 [EMAIL PROTECTED] 04/04/03 02:15PM 
Why don't you just check to make sure the mask contains only the chars:
h,H,m,M,s,S,t,T,: (or whatever the time chars are).

-R

-Original Message-
From: Randell B Adkins [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 04, 2003 2:03 PM
To: CF-Talk
Subject: Time Format Question


ok I have a field which allows a user to enter a 
time format MASK to be used when displaying 
time on a website.

Example: user enters:  H:MM:SS TT

This is a proepr formatting mask for TIMEFORMAT.

However if a user enters: NOTIMEFORMAT or something
stupid and off the wall, the timeformat function should
blow up.

I entered: MONKEY as a mask and the TIMEFORMAT
function output: 
#TimeFormat(Now(),MONKEY)# = 2O'N'K'E'Y


I also tried to use IsDate in conjunction with CREATEDATE
so I could have a valid date but an invalid time and it
returns as a true statement that it is a DATE.

There is not IStime function.. anyone have an idea?



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: allaire MIB event log error

2003-04-04 Thread Douglas.Knudsen
ah ha!! that did it.  Thans Deb.

-Original Message-
From: Debbie Dickerson [mailto:[EMAIL PROTECTED]
Sent: Friday, April 04, 2003 2:20 PM
To: CF-Talk
Subject: RE: allaire MIB event log error


It should be coming from \CFusion\cfam\Database\mib.properties

Deb

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 04, 2003 2:15 PM
To: CF-Talk
Subject: allaire MIB event log error


Ok, I'm getting this error thing in my event log
Failure to connect to url: 
http://magnys2/cfide/mib/getmetricdataXML.cfm. 

Where does CF get the computer name used in the url above?  
That's incorrect causing the error.

Using CF 5.0 on Win2K
I know what the file/reuest is for and all, I just can't 
figure out where CF is building the URL for the request.

Cheers!

--
Douglas Knudsen
Alltel Corporate
CIS Group
678-351-6063
Spoon feeding in the long run teaches us nothing but the 
shape of the spoon. - E.M. Forster 
NOTE!!  Magnys production changes occur on Friday evenings



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Time Format Question

2003-04-04 Thread Ryan Emerle
Right, so make sure that the chars entered are part of the list of acceptable chars?  
They don't all need to be there, just can't have chars that aren't supposed to be 
there..

-Original Message-
From: Randell B Adkins [mailto:[EMAIL PROTECTED]
Sent: Friday, April 04, 2003 2:21 PM
To: CF-Talk
Subject: RE: Time Format Question


Cause the field does not need to have all those characters.
Trying to rule out someone putting in something that is not
part of the proper Time Mask paramters


 [EMAIL PROTECTED] 04/04/03 02:15PM 
Why don't you just check to make sure the mask contains only the chars:
h,H,m,M,s,S,t,T,: (or whatever the time chars are).

-R

-Original Message-
From: Randell B Adkins [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 04, 2003 2:03 PM
To: CF-Talk
Subject: Time Format Question


ok I have a field which allows a user to enter a 
time format MASK to be used when displaying 
time on a website.

Example: user enters:  H:MM:SS TT

This is a proepr formatting mask for TIMEFORMAT.

However if a user enters: NOTIMEFORMAT or something
stupid and off the wall, the timeformat function should
blow up.

I entered: MONKEY as a mask and the TIMEFORMAT
function output: 
#TimeFormat(Now(),MONKEY)# = 2O'N'K'E'Y


I also tried to use IsDate in conjunction with CREATEDATE
so I could have a valid date but an invalid time and it
returns as a true statement that it is a DATE.

There is not IStime function.. anyone have an idea?




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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Formatting output question

2003-04-04 Thread Eric Creese
Thanks, I got it to work with your help using 

cfset field=replace(#rf10#,#chr(10)#,BR,ALL)
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: Run CF Studio 4 and 4.5 on same machine?

2003-04-04 Thread Chris Norloff
No, I don't think you can run both copies of CFserver on one physical machine. 

CFMX for J2EE is the first version of CF that can have more than one copy of the 
CFserver running on one physical machine.

Chris Norloff

-- Original Message --
From: Jim McAtee [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
date: Fri, 4 Apr 2003 11:42:22 -0700

I've been running CF Studio 4 for just about forever.  I recall trying 4.5 quite
a while ago and not particularly liking it, but I'd like to try it out again.

Can I run both on the same machine, so that I could uninstall one or the other
if I choose?  It would be easier than installing, uninstalling, reinstalling, if
I want to go back to 4.

Thanks,
Jim


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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



IIF() and IsDefined()

2003-04-04 Thread Alexander Sherwood
Help:

#IIF(StructKeyExists(struct, 'keyname'),DE(struct.keyname),DE('no 
key'))#.fails if the key is not present.

BUT,

cfif StructKeyExists(struct, 'keyname')
#struct.keyname#
cfelse
no key
/cfif

doesn't.

Am I missing something about IIF() and DE()? It looks as if both DE() 
expressions must be evaluateable, and the IIF() just decides which one to 
evaluate? Correct?

Thanks,

--
Alex Sherwood
PHS Collection Agency
THE COLLECTORS
T:   301.215.4200
F:   301.664.6834
W: www.phs-net.com

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Run CF Studio 4 and 4.5 on same machine?

2003-04-04 Thread Jeff Battershall
Jim,

I seem to recall being able to do that successfully, but it's been a while.
Have you tried Homesite+ ?  I'm liking it pretty well - in fact it's all I
use.

Jeff

-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 04, 2003 1:42 PM
To: CF-Talk
Subject: Run CF Studio 4 and 4.5 on same machine?


I've been running CF Studio 4 for just about forever.  I recall trying 4.5
quite a while ago and not particularly liking it, but I'd like to try it out
again.

Can I run both on the same machine, so that I could uninstall one or the
other if I choose?  It would be easier than installing, uninstalling,
reinstalling, if I want to go back to 4.

Thanks,
Jim


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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: IIF() and IsDefined()

2003-04-04 Thread Tangorre, Michael
try quotes around the argument passed to DE.
DE(struct.keyname) should be DE('struct.keyname')

mike

-Original Message-
From: Alexander Sherwood [mailto:[EMAIL PROTECTED]
Sent: Friday, April 04, 2003 2:36 PM
To: CF-Talk
Subject: IIF() and IsDefined()


Help:

#IIF(StructKeyExists(struct, 'keyname'),DE(struct.keyname),DE('no 
key'))#.fails if the key is not present.

BUT,

cfif StructKeyExists(struct, 'keyname')
#struct.keyname#
cfelse
no key
/cfif

doesn't.

Am I missing something about IIF() and DE()? It looks as if both DE() 
expressions must be evaluateable, and the IIF() just decides which one to 
evaluate? Correct?

Thanks,

--
Alex Sherwood
PHS Collection Agency
THE COLLECTORS
T:   301.215.4200
F:   301.664.6834
W: www.phs-net.com


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: IIF() and IsDefined()

2003-04-04 Thread Barney Boisvert
you don't need the de() call around the variable name, just put it in
quotes:

iif(structKeyExists(struct, keyname), struct.keyname, de(no key))

Your code was trying to output a variable with a name equal to the value
stored in #struct.keyname#, which isn't what you wanted.

Usually, using CFIF is more readable (especially with complex expressions)
and it's always faster, as it doesn't require any delayed evaluation (which
is slow).  Sometimes it's the only way to get a job done, but you generally
shouldn't use it unless you have to.

barneyb

---
Barney Boisvert, Senior Development Engineer
AudienceCentral (formerly PIER System, Inc.)
[EMAIL PROTECTED]
voice : 360.756.8080 x12
fax   : 360.647.5351

www.audiencecentral.com

 -Original Message-
 From: Alexander Sherwood [mailto:[EMAIL PROTECTED]
 Sent: Friday, April 04, 2003 11:36 AM
 To: CF-Talk
 Subject: IIF() and IsDefined()


 Help:

 #IIF(StructKeyExists(struct, 'keyname'),DE(struct.keyname),DE('no
 key'))#.fails if the key is not present.

 BUT,

 cfif StructKeyExists(struct, 'keyname')
 #struct.keyname#
 cfelse
 no key
 /cfif

 doesn't.

 Am I missing something about IIF() and DE()? It looks as if both DE()
 expressions must be evaluateable, and the IIF() just decides
 which one to
 evaluate? Correct?

 Thanks,

 --
 Alex Sherwood
 PHS Collection Agency
 THE COLLECTORS
 T:   301.215.4200
 F:   301.664.6834
 W: www.phs-net.com

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



cffile, uploading on a mac, which doesn't need file suffixes...

2003-04-04 Thread Jeff
Okay, so using cffile, I've got the uploading part down, but one thing I
shoulda seen coming. When people in the office on a mac browse their hard
drive to choose the file they want to upload, what do I do, if it's got no
suffix on it? On macs, you can (and these people frequently do) create pdfs
and jpegs with no suffix. I'm only accepting jpegs and pdfs, so that part's
figured out, and works...um, when there's a suffix on the file apparently.
Not to mention, any link to the file won't work with the browser, it doesn't
know what kind of file it is, naturally.

What I'd like, was that, when the user uploads a file, if it doesn't have a
suffix, maybe throw an error. (which would be a different error than if it
wasn't the right type of file) Or is there a way to even determine the file
type when there's no suffix? In other words, what kind of file *is*
MyDocument? If I could tell if it was a jpeg, then I might consider just
putting the suffix on if it doesn't exist.

So I guess I'm really just sort of looking for a direction to go in, to do
such a thing, or to handle such an event. How do others who have to do
cffile in a mac browser environment handle this sort of thing? What's the
logic?

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Data source error

2003-04-04 Thread Stephenie Hamilton
Hmmm, are  you using the system user as the user CF service operates
under? Or have you created a new user?

Ensure that the user has permissions on the database folder, it is also
a good idea to ensure the db is not in a folder that is accessible to
the web (ie: your inetpub/wwwroot or whatever dir structure you use).

Yes it should be a system dsn.


~~
Stephenie Hamilton
Macromedia Certified ColdFusion Professional
CFXHosting





-Original Message-
From: Eric Vacin [mailto:[EMAIL PROTECTED] 
Sent: Thursday, April 03, 2003 4:28 PM
To: CF-Talk
Subject: Re: Data source error


Stephanie,

I got it from the CF Admin...when I tried to do an ODBC socket to the
data source I created in the ODBC panel.  Below is the exact output:


*   Connection verification failed for data source: ss
[]java.sql.SQLException: SQLException occurred in JDBCPool while
attempting to connect, please check your username, password, URL, and
other connectivity info java.sql.SQLException: [MERANT][SequeLink JDBC
Driver][SequeLink Server]Could not create a trace file..


I've added a system DSN...this is right, right?

I'm starting to think its some kind of permissions thing as I have the
server locked down, very locked down.

Singed,

Eternally Confused.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.459 / Virus Database: 258 - Release Date: 2/25/2003
 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Time Format Question

2003-04-04 Thread Barney Boisvert
REreplace(string, [^tTmMhHsH: ], , all)

that'll strip out the extra chars

---
Barney Boisvert, Senior Development Engineer
AudienceCentral (formerly PIER System, Inc.)
[EMAIL PROTECTED]
voice : 360.756.8080 x12
fax   : 360.647.5351

www.audiencecentral.com

 -Original Message-
 From: Ryan Emerle [mailto:[EMAIL PROTECTED]
 Sent: Friday, April 04, 2003 11:28 AM
 To: CF-Talk
 Subject: RE: Time Format Question


 Right, so make sure that the chars entered are part of the list
 of acceptable chars?  They don't all need to be there, just can't
 have chars that aren't supposed to be there..

 -Original Message-
 From: Randell B Adkins [mailto:[EMAIL PROTECTED]
 Sent: Friday, April 04, 2003 2:21 PM
 To: CF-Talk
 Subject: RE: Time Format Question


 Cause the field does not need to have all those characters.
 Trying to rule out someone putting in something that is not
 part of the proper Time Mask paramters


  [EMAIL PROTECTED] 04/04/03 02:15PM 
 Why don't you just check to make sure the mask contains only the chars:
 h,H,m,M,s,S,t,T,: (or whatever the time chars are).

 -R

 -Original Message-
 From: Randell B Adkins [mailto:[EMAIL PROTECTED]
 Sent: Friday, April 04, 2003 2:03 PM
 To: CF-Talk
 Subject: Time Format Question


 ok I have a field which allows a user to enter a
 time format MASK to be used when displaying
 time on a website.

 Example: user enters:  H:MM:SS TT

 This is a proepr formatting mask for TIMEFORMAT.

 However if a user enters: NOTIMEFORMAT or something
 stupid and off the wall, the timeformat function should
 blow up.

 I entered: MONKEY as a mask and the TIMEFORMAT
 function output:
 #TimeFormat(Now(),MONKEY)# = 2O'N'K'E'Y


 I also tried to use IsDate in conjunction with CREATEDATE
 so I could have a valid date but an invalid time and it
 returns as a true statement that it is a DATE.

 There is not IStime function.. anyone have an idea?




 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



  1   2   >