RE: CF Studio like free editor?

[Robertson-Ravo, Neil (REC)]

I would have to say that CF Studio is more 'beefed up' than Homesite+, as
HS+ has some stuff removed post Adobe case.



-Original Message-
From: Tilbrook, Peter [mailto:[EMAIL PROTECTED]]
Sent: 17 November 2002 22:33
To: CF-Talk
Subject: RE: CF Studio like free editor?


Don't forget that if you upgrade to Studio MX (like more than 250,000 others
have already done according to MM - pretty good) HomeSite+ is included free.
It' basically a beefed up Studio/HomeSite 5 with MX support thrown in.

I still think I prefer Studio though after having used it daily for years
but HomeSite+ is still quite good.

-Original Message-
From: Li Chunshen (Don) [mailto:[EMAIL PROTECTED]]
Sent: Sunday, 17 November 2002 10:50 AM
To: CF-Talk
Subject: CF Studio like free editor?


Probably, I'm going to buy a copy of HomeSite soon
(for lack of alternatives), (HomeSite eval has
expired), but before that, I'd like to try some CF
Studio like free editor naturally without CF end TAG
insertion?  Does any one know anything like that
exist?  Thanks.

DL


**
The information contained in this e-mail, and any attachments to it, is
intended for the use of addressee and is confidential.  If you are not 
the intended recipient, you must not use, disclose, read, forward, copy or
retain any of the information.  If you have received this e-mail in 
error, please delete it and notify the sender by return e-mail or telephone.

The Commonwealth does not warrant that any attachments are free from 
viruses or any other defects.  You assume all liability for any loss,
damage, or 
other consequences which may arise from opening or using the attachments.

**

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

RE: CF Studio like free editor?

[Robertson-Ravo, Neil (REC)]

I have found this to be very unstable with JRE 1.4.1.  It crashes both
Windows XP and 2000 when you exit the application.



-Original Message-
From: Josh Trefethen [mailto:[EMAIL PROTECTED]]
Sent: 17 November 2002 01:33
To: CF-Talk
Subject: RE: CF Studio like free editor?


You should try Jedit -- look at www.jedit.org and
www.joshuasmiller.com/jedit

--
Josh Trefethen

:[ Exciteworks, Inc ]::[ http://exciteworks.com ]:. 
::[ cf hosting on linux ]::[ consulting ]::[ expertise ]::.
 

-Original Message-
From: Li Chunshen (Don) [mailto:[EMAIL PROTECTED]] 
Sent: Saturday, November 16, 2002 3:50 PM
To: CF-Talk
Subject: CF Studio like free editor?


Probably, I'm going to buy a copy of HomeSite soon
(for lack of alternatives), (HomeSite eval has
expired), but before that, I'd like to try some CF
Studio like free editor naturally without CF end TAG
insertion?  Does any one know anything like that
exist?  Thanks.

DL



__
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
http://webhosting.yahoo.com


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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.

RE: CF Studio like free editor?

[Raymond Camden]

Remember, though, that the stuff removed only applies to custimization
of the UI. Many people never customized their Studio at all. 

===
Raymond Camden, ColdFusion Jedi Master for Hire

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

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

> -Original Message-
> From: Robertson-Ravo, Neil (REC) 
> [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, November 18, 2002 4:36 AM
> To: CF-Talk
> Subject: RE: CF Studio like free editor?
> 
> 
> I would have to say that CF Studio is more 'beefed up' than 
> Homesite+, as
> HS+ has some stuff removed post Adobe case.
> 
> 
> 


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

RE: CF Studio like free editor?

[Robertson-Ravo, Neil (REC)]

:-) I would certainly like to see a feature matrix of whats changed...


-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: 18 November 2002 10:31
To: CF-Talk
Subject: RE: CF Studio like free editor?


Remember, though, that the stuff removed only applies to custimization
of the UI. Many people never customized their Studio at all. 

===
Raymond Camden, ColdFusion Jedi Master for Hire

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

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

> -Original Message-
> From: Robertson-Ravo, Neil (REC) 
> [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, November 18, 2002 4:36 AM
> To: CF-Talk
> Subject: RE: CF Studio like free editor?
> 
> 
> I would have to say that CF Studio is more 'beefed up' than 
> Homesite+, as
> HS+ has some stuff removed post Adobe case.
> 
> 
> 



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

User Preferences template--Continued post

[FlashGuy]

Hi,

I'm hoping I can explain this better so here it goes. My database has the following 
fields and what they contain:

strUser_ID (auto-generated)
strUsername = 'Bill'
strSelect = 'D:\test\dir1,D:\test\dir2,D:\test\dir3,D:\test\dir4,D:\test\dir5'
strSelectFlag = ''
strOmit = 'D:\test\dir2,D:\test\dir4


My http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

CF SQL problem

[Kennerly, Rick H CIV]

I've never seen this message before.  Any ideas would be appreciated. 

Here's the code from the Action page:


 


And here's the info I get back from CF Debug

Error Executing Database Query. Invalid data
1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1 for CFSQLTYPE
CF_SQL_NUMERIC. 



Rick 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

RE: CF SQL problem

[Raymond Camden]

cfupdate is passing the entire value form.empid_muster, not one value at
a time. Simply dump the cfupdate and switch to a real SQL insert.

===
Raymond Camden, ColdFusion Jedi Master for Hire

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

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

> -Original Message-
> From: Kennerly, Rick H CIV [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, November 18, 2002 9:22 AM
> To: CF-Talk
> Subject: CF SQL problem
> 
> 
> I've never seen this message before.  Any ideas would be appreciated. 
> 
> Here's the code from the Action page:
> 
> 
>  formfields="empID_muster, emp_status"> 
> 
> 
> And here's the info I get back from CF Debug
> 
> Error Executing Database Query. Invalid data
> 1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1 for CFSQLTYPE
> CF_SQL_NUMERIC. 
> 
> 
> 
> Rick 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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.

RE: FlashCom host

[Kris Pilles]

I am in the process of addinga MX server to our hosting offerings... I
will explore what is involved in purchasing and offering Flashcom.  For
anyone who is interested please email me off list.

Thanks

KP

-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] 
Sent: Sunday, November 17, 2002 6:34 PM
To: CF-Talk
Subject: Re: FlashCom host


I'm trying to convince a friend of mine who has some huge pipes to do
flashcom hosting. He may do it. He's going to be doing some other stuff
for the community that I can't mention yet.


> Thanks Sam,
>
> I'll give them a shot. They seem to be the only game in town :)
>
> Michael
> - Original Message -
> From: "Samuel Neff" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Sunday, November 17, 2002 4:55 PM
> Subject: RE: FlashCom host
>
>
> > I haven't used Media Temple, but I can say that I met one of their 
> > people at DevCon and he appeared very knowledgeable about Flash 
> > Comm.
> >
> > -Original Message-
> > From: Massimo, Tiziana e Federica [mailto:[EMAIL PROTECTED]]
> > Sent: Sunday, November 17, 2002 3:45 PM
> > To: CF-Talk
> > Subject: Re: FlashCom host
> >
> >
> > > Does anyone know of a good (any) Flash Communication server hosts?
> > >
> > > Any experience or advice on a host would be helpful.
> > >
> > I have no direct experience with them:
> >
> > http://www.mediatemple.com/
> >
> > Massimo
> >
> >
> >
> 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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.

OT: Name Server

[Kris Pilles]

Also... while I am at it... we are in the process of taking control of
our own DNS... does nayone know of any tutorial or site that can help
with the with setup of the name servers..

Thanks

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=subscribe&forumid=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

What service is responsible for CF Scheduler?

[Bosky, Dave]

What service is responsible for CF Scheduler?
CF Application Server, CF Executive

Thanks,
Dave


HTC Disclaimer:  The information contained in this message may be privileged and 
confidential and protected from disclosure. If the reader of this message is not the 
intended recipient, or an employee or agent responsible for delivering this message to 
the intended recipient, you are hereby notified that any dissemination, distribution 
or copying of this communication is strictly prohibited.  If you have received this 
communication in error, please notify us immediately by replying to the message and 
deleting it from your computer.  Thank you.
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

Re: Name Server

[samcfug]

contact me off list,
Tell me what operating system will be hosting your DNS and I
will send you a sample ZONE file that you can clone for each
web site.

=
Douglas White
group Manager
mailto:[EMAIL PROTECTED]
http://www.samcfug.org
=
- Original Message -
From: "Kris Pilles" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 18, 2002 7:58 AM
Subject: OT: Name Server


| Also... while I am at it... we are in the process of
taking control of
| our own DNS... does nayone know of any tutorial or site
that can help
| with the with setup of the name servers..
|
| Thanks
|
| 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=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Re: What service is responsible for CF Scheduler?

[Howie Hamlin]

CF Executive.

HTH,

--
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. - www.CoolFusion.com  - 631-737-4668 x101
inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server
>>> Find out how iMS Stacks up to the competition: 
>http://www.coolfusion.com/imssecomparison.cfm

- Original Message -
From: "Bosky, Dave" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 18, 2002 9:08 AM
Subject: What service is responsible for CF Scheduler?


> What service is responsible for CF Scheduler?
> CF Application Server, CF Executive
>
> Thanks,
> Dave
>
>
> HTC Disclaimer:  The information contained in this message may be privileged and 
>confidential and protected from
disclosure. If the reader of this message is not the intended recipient, or an 
employee or agent responsible for
delivering this message to the intended recipient, you are hereby notified that any 
dissemination, distribution or
copying of this communication is strictly prohibited.  If you have received this 
communication in error, please notify
us immediately by replying to the message and deleting it from your computer.  Thank 
you.
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

Re: User Preferences template--Continued post

[Randell B Adkins]

In your initial Output for the OMIT Directories try:


 
   
   
   
   
   
 


Do the same for the ADD section but reverse the query elements.



>>> [EMAIL PROTECTED] 11/18/02 08:09AM >>>
Hi,

I'm hoping I can explain this better so here it goes. My database has
the following fields and what they contain:

strUser_ID (auto-generated)
strUsername = 'Bill'
strSelect =
'D:\test\dir1,D:\test\dir2,D:\test\dir3,D:\test\dir4,D:\test\dir5'
strSelectFlag = ''
strOmit = 'D:\test\dir2,D:\test\dir4


My http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

RE: CF Studio like free editor?

[Joshua Miller]

I'm running it on Windows XP and Windows 2K with JSDK 1.4.1 and have no
issues with crashing on exit. There are some problems on MacOSX with JDK
1.4.x but that's because Apple hasn't finished up their Java 1.4.x
implementation - still a preview release. Haven't put 1.4.x on Linux
yet, but it's running fine for me under Windows.

Joshua Miller
[EMAIL PROTECTED]


-Original Message-
From: Robertson-Ravo, Neil (REC)
[mailto:[EMAIL PROTECTED]] 
Sent: Monday, November 18, 2002 5:01 AM
To: CF-Talk
Subject: RE: CF Studio like free editor?


I have found this to be very unstable with JRE 1.4.1.  It crashes both
Windows XP and 2000 when you exit the application.



-Original Message-
From: Josh Trefethen [mailto:[EMAIL PROTECTED]]
Sent: 17 November 2002 01:33
To: CF-Talk
Subject: RE: CF Studio like free editor?


You should try Jedit -- look at www.jedit.org and
www.joshuasmiller.com/jedit

--
Josh Trefethen

:[ Exciteworks, Inc ]::[ http://exciteworks.com ]:. 
::[ cf hosting on linux ]::[ consulting ]::[ expertise ]::.
 

-Original Message-
From: Li Chunshen (Don) [mailto:[EMAIL PROTECTED]] 
Sent: Saturday, November 16, 2002 3:50 PM
To: CF-Talk
Subject: CF Studio like free editor?


Probably, I'm going to buy a copy of HomeSite soon
(for lack of alternatives), (HomeSite eval has
expired), but before that, I'd like to try some CF
Studio like free editor naturally without CF end TAG
insertion?  Does any one know anything like that
exist?  Thanks.

DL



__
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
http://webhosting.yahoo.com



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

RE: CF Studio like free editor?

[Robertson-Ravo, Neil (REC)]

Wierd... it must be a config on the machines then, as it seems to crash -
BSOD everytime on Windows 2000 & Windows XP

-Original Message-
From: Joshua Miller [mailto:[EMAIL PROTECTED]]
Sent: 18 November 2002 14:28
To: CF-Talk
Subject: RE: CF Studio like free editor?


I'm running it on Windows XP and Windows 2K with JSDK 1.4.1 and have no
issues with crashing on exit. There are some problems on MacOSX with JDK
1.4.x but that's because Apple hasn't finished up their Java 1.4.x
implementation - still a preview release. Haven't put 1.4.x on Linux
yet, but it's running fine for me under Windows.

Joshua Miller
[EMAIL PROTECTED]


-Original Message-
From: Robertson-Ravo, Neil (REC)
[mailto:[EMAIL PROTECTED]] 
Sent: Monday, November 18, 2002 5:01 AM
To: CF-Talk
Subject: RE: CF Studio like free editor?


I have found this to be very unstable with JRE 1.4.1.  It crashes both
Windows XP and 2000 when you exit the application.



-Original Message-
From: Josh Trefethen [mailto:[EMAIL PROTECTED]]
Sent: 17 November 2002 01:33
To: CF-Talk
Subject: RE: CF Studio like free editor?


You should try Jedit -- look at www.jedit.org and
www.joshuasmiller.com/jedit

--
Josh Trefethen

:[ Exciteworks, Inc ]::[ http://exciteworks.com ]:. 
::[ cf hosting on linux ]::[ consulting ]::[ expertise ]::.
 

-Original Message-
From: Li Chunshen (Don) [mailto:[EMAIL PROTECTED]] 
Sent: Saturday, November 16, 2002 3:50 PM
To: CF-Talk
Subject: CF Studio like free editor?


Probably, I'm going to buy a copy of HomeSite soon
(for lack of alternatives), (HomeSite eval has
expired), but before that, I'd like to try some CF
Studio like free editor naturally without CF end TAG
insertion?  Does any one know anything like that
exist?  Thanks.

DL



__
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
http://webhosting.yahoo.com




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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.

RE: CF Studio like free editor?

[Joshua Miller]

Wow, Blue Screen on 2K and NT? That sounds like a problem bigger than
Jedit/Java.

Joshua Miller
[EMAIL PROTECTED]


-Original Message-
From: Robertson-Ravo, Neil (REC)
[mailto:[EMAIL PROTECTED]] 
Sent: Monday, November 18, 2002 9:28 AM
To: CF-Talk
Subject: RE: CF Studio like free editor?


Wierd... it must be a config on the machines then, as it seems to crash
- BSOD everytime on Windows 2000 & Windows XP

-Original Message-
From: Joshua Miller [mailto:[EMAIL PROTECTED]]
Sent: 18 November 2002 14:28
To: CF-Talk
Subject: RE: CF Studio like free editor?


I'm running it on Windows XP and Windows 2K with JSDK 1.4.1 and have no
issues with crashing on exit. There are some problems on MacOSX with JDK
1.4.x but that's because Apple hasn't finished up their Java 1.4.x
implementation - still a preview release. Haven't put 1.4.x on Linux
yet, but it's running fine for me under Windows.

Joshua Miller
[EMAIL PROTECTED]


-Original Message-
From: Robertson-Ravo, Neil (REC)
[mailto:[EMAIL PROTECTED]] 
Sent: Monday, November 18, 2002 5:01 AM
To: CF-Talk
Subject: RE: CF Studio like free editor?


I have found this to be very unstable with JRE 1.4.1.  It crashes both
Windows XP and 2000 when you exit the application.



-Original Message-
From: Josh Trefethen [mailto:[EMAIL PROTECTED]]
Sent: 17 November 2002 01:33
To: CF-Talk
Subject: RE: CF Studio like free editor?


You should try Jedit -- look at www.jedit.org and
www.joshuasmiller.com/jedit

--
Josh Trefethen

:[ Exciteworks, Inc ]::[ http://exciteworks.com ]:. 
::[ cf hosting on linux ]::[ consulting ]::[ expertise ]::.
 

-Original Message-
From: Li Chunshen (Don) [mailto:[EMAIL PROTECTED]] 
Sent: Saturday, November 16, 2002 3:50 PM
To: CF-Talk
Subject: CF Studio like free editor?


Probably, I'm going to buy a copy of HomeSite soon
(for lack of alternatives), (HomeSite eval has
expired), but before that, I'd like to try some CF
Studio like free editor naturally without CF end TAG
insertion?  Does any one know anything like that
exist?  Thanks.

DL



__
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
http://webhosting.yahoo.com





~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

Crybabies

[booya booya]

OMFG - just read the biggest crybaby article I've *ever* read.  Someone break out the 
hankies (or, better yet - dish out some spankings)

http://builder.com.com/article.jhtml?id=u00320021108gcn01.htm&fromtm=e601-1
-- 
__
Sign-up for your own FREE Personalized E-mail at Mail.com
http://www.mail.com/?sr=signup

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

Re: Crybabies

[Jochem van Dieten]

booya booya wrote:

> OMFG - just read the biggest crybaby article I've *ever* read. 
> Someone break out the hankies (or, better yet - dish out some spankings)

Wasn't there some list where this was ON-topic?

Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

Re: User Preferences template--Continued post

[FlashGuy]

OKbut I require the check box selections to be deleted or appended to the database 
depening on the OMIT or ADD function. Sure I can omit it from the list but it still 
exists 
in the database field "strSelect".



On Mon, 18 Nov 2002 09:22:25 -0500, Randell B Adkins wrote:

> In your initial Output for the OMIT Directories try:
> 
> 
>  
>
>
>
>
>
>  
> 
> 
> Do the same for the ADD section but reverse the query elements.
> 
> 
> 
> >>> [EMAIL PROTECTED] 11/18/02 08:09AM >>>
> Hi,
> 
> I'm hoping I can explain this better so here it goes. My database has
> the following fields and what they contain:
> 
> strUser_ID (auto-generated)
> strUsername = 'Bill'
> strSelect =
> 'D:\test\dir1,D:\test\dir2,D:\test\dir3,D:\test\dir4,D:\test\dir5'
> strSelectFlag = ''
> strOmit = 'D:\test\dir2,D:\test\dir4
> 
> 
> My  
> To OMIT directory(s) click on a checkbox below:
> 
> [  ] dir1  [  ] dir2  [  ] dir3  [  ] dir4 
>[  ] dir5
> 
> 
> To ADD directory(s) click on a checkbox below:
> 
> [  ] dir2  [  ] dir3  [  ] dir4
> 
> 
> The problem I'm having is getting the selection from the OMIT checkbox
> deleted from the database. Can I easily do a match of the string and
> delete them?
> 
> The output should *really* be this and visa-versa if checkboxes are
> checked in the ADD directory section.
> 
> To OMIT directory(s) click on a checkbox below:
> 
> [  ] dir1[  ] dir5
> 
> 
> To ADD directory(s) click on a checkbox below:
> 
> [  ] dir2  [  ] dir3  [  ] dir4
> 
> 
> 
> 
> 
> 
> 
> ---
> Colonel Nathan R. Jessop
> Commanding Officer
> Marine Ground Forces
> Guatanamo Bay, Cuba
> ---
> 
> 
> 
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

RE: CF Studio like free editor?

[Robertson-Ravo, Neil (REC)]

Nope, both these machines are pukka.   The only application they BSOD with
is JEdit. Everytime.





-Original Message-
From: Joshua Miller [mailto:[EMAIL PROTECTED]]
Sent: 18 November 2002 14:36
To: CF-Talk
Subject: RE: CF Studio like free editor?


Wow, Blue Screen on 2K and NT? That sounds like a problem bigger than
Jedit/Java.

Joshua Miller
[EMAIL PROTECTED]


-Original Message-
From: Robertson-Ravo, Neil (REC)
[mailto:[EMAIL PROTECTED]] 
Sent: Monday, November 18, 2002 9:28 AM
To: CF-Talk
Subject: RE: CF Studio like free editor?


Wierd... it must be a config on the machines then, as it seems to crash
- BSOD everytime on Windows 2000 & Windows XP

-Original Message-
From: Joshua Miller [mailto:[EMAIL PROTECTED]]
Sent: 18 November 2002 14:28
To: CF-Talk
Subject: RE: CF Studio like free editor?


I'm running it on Windows XP and Windows 2K with JSDK 1.4.1 and have no
issues with crashing on exit. There are some problems on MacOSX with JDK
1.4.x but that's because Apple hasn't finished up their Java 1.4.x
implementation - still a preview release. Haven't put 1.4.x on Linux
yet, but it's running fine for me under Windows.

Joshua Miller
[EMAIL PROTECTED]


-Original Message-
From: Robertson-Ravo, Neil (REC)
[mailto:[EMAIL PROTECTED]] 
Sent: Monday, November 18, 2002 5:01 AM
To: CF-Talk
Subject: RE: CF Studio like free editor?


I have found this to be very unstable with JRE 1.4.1.  It crashes both
Windows XP and 2000 when you exit the application.



-Original Message-
From: Josh Trefethen [mailto:[EMAIL PROTECTED]]
Sent: 17 November 2002 01:33
To: CF-Talk
Subject: RE: CF Studio like free editor?


You should try Jedit -- look at www.jedit.org and
www.joshuasmiller.com/jedit

--
Josh Trefethen

:[ Exciteworks, Inc ]::[ http://exciteworks.com ]:. 
::[ cf hosting on linux ]::[ consulting ]::[ expertise ]::.
 

-Original Message-
From: Li Chunshen (Don) [mailto:[EMAIL PROTECTED]] 
Sent: Saturday, November 16, 2002 3:50 PM
To: CF-Talk
Subject: CF Studio like free editor?


Probably, I'm going to buy a copy of HomeSite soon
(for lack of alternatives), (HomeSite eval has
expired), but before that, I'd like to try some CF
Studio like free editor naturally without CF end TAG
insertion?  Does any one know anything like that
exist?  Thanks.

DL



__
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
http://webhosting.yahoo.com






~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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.

Re: User Preferences template--Continued post

[Randell B Adkins]

When a NEW USER is created, where do you get the Directory listing?
Is it a Database table?
Just a Directory Listing on the Server?
Or Hard Coded?

>>> [EMAIL PROTECTED] 11/18/02 09:44AM >>>
OKbut I require the check box selections to be deleted or appended
to the database depening on the OMIT or ADD function. Sure I can omit it
from the list but it still exists 
in the database field "strSelect".



On Mon, 18 Nov 2002 09:22:25 -0500, Randell B Adkins wrote:

> In your initial Output for the OMIT Directories try:
> 
> 
>  
>
>
>
>
>
>  
> 
> 
> Do the same for the ADD section but reverse the query elements.
> 
> 
> 
> >>> [EMAIL PROTECTED] 11/18/02 08:09AM >>>
> Hi,
> 
> I'm hoping I can explain this better so here it goes. My database
has
> the following fields and what they contain:
> 
> strUser_ID (auto-generated)
> strUsername = 'Bill'
> strSelect =
> 'D:\test\dir1,D:\test\dir2,D:\test\dir3,D:\test\dir4,D:\test\dir5'
> strSelectFlag = ''
> strOmit = 'D:\test\dir2,D:\test\dir4
> 
> 
> My  
> To OMIT directory(s) click on a checkbox below:
> 
> [  ] dir1  [  ] dir2  [  ] dir3  [  ] dir4   
 
>[  ] dir5
> 
> 
> To ADD directory(s) click on a checkbox below:
> 
> [  ] dir2  [  ] dir3  [  ] dir4
> 
> 
> The problem I'm having is getting the selection from the OMIT
checkbox
> deleted from the database. Can I easily do a match of the string and
> delete them?
> 
> The output should *really* be this and visa-versa if checkboxes are
> checked in the ADD directory section.
> 
> To OMIT directory(s) click on a checkbox below:
> 
> [  ] dir1[  ] dir5
> 
> 
> To ADD directory(s) click on a checkbox below:
> 
> [  ] dir2  [  ] dir3  [  ] dir4
> 
> 
> 
> 
> 
> 
> 
> ---
> Colonel Nathan R. Jessop
> Commanding Officer
> Marine Ground Forces
> Guatanamo Bay, Cuba
> ---
> 
> 
> 
> 
> 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

Re: User Preferences template--Continued post

[FlashGuy]

On Mon, 18 Nov 2002 09:48:10 -0500, Randell B Adkins wrote:

> When a NEW USER is created, where do you get the Directory listing?

>From an external ASCII text file which gets read in at initial login. A flag is then 
>set in my database in the field "strSelectFlag" to be "Yes".
Next time the user logs in I check that field. If its equal to "Yes" use whats in the 
"strSelect" field rather than read in the external file.


> Is it a Database table?

Yes.

> Just a Directory Listing on the Server?

It is a directory listing but based on the external file. 

> Or Hard Coded?

Nope.
 
> >>> [EMAIL PROTECTED] 11/18/02 09:44AM >>>
> OKbut I require the check box selections to be deleted or appended
> to the database depening on the OMIT or ADD function. Sure I can omit it
> from the list but it still exists 
> in the database field "strSelect".
> 
> 
> 
> On Mon, 18 Nov 2002 09:22:25 -0500, Randell B Adkins wrote:
> 
> > In your initial Output for the OMIT Directories try:
> > 
> > 
> >  
> >
> >
> >
> >
> >
> >  
> > 
> > 
> > Do the same for the ADD section but reverse the query elements.
> > 
> > 
> > 
> > >>> [EMAIL PROTECTED] 11/18/02 08:09AM >>>
> > Hi,
> > 
> > I'm hoping I can explain this better so here it goes. My database
> has
> > the following fields and what they contain:
> > 
> > strUser_ID (auto-generated)
> > strUsername = 'Bill'
> > strSelect =
> > 'D:\test\dir1,D:\test\dir2,D:\test\dir3,D:\test\dir4,D:\test\dir5'
> > strSelectFlag = ''
> > strOmit = 'D:\test\dir2,D:\test\dir4
> > 
> > 
> > My  > 
> > To OMIT directory(s) click on a checkbox below:
> > 
> > [  ] dir1  [  ] dir2  [  ] dir3  [  ] dir4   
>  
> >[  ] dir5
> > 
> > 
> > To ADD directory(s) click on a checkbox below:
> > 
> > [  ] dir2  [  ] dir3  [  ] dir4
> > 
> > 
> > The problem I'm having is getting the selection from the OMIT
> checkbox
> > deleted from the database. Can I easily do a match of the string and
> > delete them?
> > 
> > The output should *really* be this and visa-versa if checkboxes are
> > checked in the ADD directory section.
> > 
> > To OMIT directory(s) click on a checkbox below:
> > 
> > [  ] dir1[  ] dir5
> > 
> > 
> > To ADD directory(s) click on a checkbox below:
> > 
> > [  ] dir2  [  ] dir3  [  ] dir4
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > ---
> > Colonel Nathan R. Jessop
> > Commanding Officer
> > Marine Ground Forces
> > Guatanamo Bay, Cuba
> > ---
> > 
> > 
> > 
> > 
> > 
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Checking a float

[Cutter (CF_Talk)]

A have a float field in a db to store the number of bathrooms for a 
property ( 1.5 bathrooms, 3 bathrooms). My question is, how do I check 
to see if there is a non zero value after the decimal? I want it to show:

1.5 bathrooms
3 bathrooms

and not:

1.5 bathrooms
3.0 bathrooms

Any help is greatly appreciated.

Cutter
Falcon Knives

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

FYI: Review on MM Contribute

[David Adams]

Webmonkey has done a review on MM's Contribute product.
 
http://hotwired.lycos.com/webmonkey/02/45/index4a.html
 
Dave Adams
CFUG Ottawa


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

RE: Checking a float

[Turetsky, Seth]

you could use this i believe:

#gettoken(bathrooms,1,".")#

#bathrooms#


-Original Message-
From: Cutter (CF_Talk) [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 18, 2002 10:28 AM
To: CF-Talk
Subject: Checking a float


A have a float field in a db to store the number of bathrooms for a 
property ( 1.5 bathrooms, 3 bathrooms). My question is, how do I check 
to see if there is a non zero value after the decimal? I want it to show:

1.5 bathrooms
3 bathrooms

and not:

1.5 bathrooms
3.0 bathrooms

Any help is greatly appreciated.

Cutter
Falcon Knives


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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.

GetQueuedCompletionStatus error

[John Lucas]

Good Morning,

Our site was generating server too busy to fulfill request errors this
morning.

Upon checking our server.log file which was 154 MB from this mornings
entries, I found the following pairs of errors occurring every second
from 06:52:42 to 09:56:45 EST.

"Unexpected error returned from GetQueuedCompletionStatus"
"Windows NT error number 6 occurred"

Occasionally, there was a "Unexpected error returned from
AssociateDeviceWithCompletionPort" error thrown in.

All of these errors occur on the same thread number.  However, the only
preceding error on this thread occurred at 04:44:15 when Linkwalker
visited the site and generated a variable was missing error in the
application.log file.

Our server config is

Windows 2000 Server Service Pack 3
Coldfusion Professional 5
1 GHZ Processor 1 GB RAM

Limit simultaneous requests to 5
Restart at 3 unresponsive requests
Timeout requests after 75 seconds
Restart when requests terminate abnormally checked

Any ideas on where to start on these errors or what they mean?

Thanks,
John




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

RE: CF SQL problem

[Jim Davis]

> I've never seen this message before.  Any ideas would be appreciated. 
> 
> Here's the code from the Action page:
> 
>  
>  tablename="muster" formfields="empID_muster, emp_status"> 
> 
> 
> And here's the info I get back from CF Debug
> 
> Error Executing Database Query. Invalid data 
> 1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1 for 
> CFSQLTYPE CF_SQL_NUMERIC. 

Well - it looks like you're trying to pass a list into a numeric column.

My guess is that you've got several form fields named the same - so that
the browser is sending one name as a list of all the values rather than
one value for each.

Jim Davis


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

RE: Checking a float

[Jason Lees (National Express)]

As CF is a loosly typed language you could simply do


--whole bathrooms

--partial bathrooms


Question is though how do you have .5 of a bathroom, isnt this like half a
hole?

Jason Lees
Systems Developer
National Express Coaches Ltd.



-Original Message-
From: Cutter (CF_Talk) [mailto:[EMAIL PROTECTED]]
Sent: 18 November 2002 15:28
To: CF-Talk
Subject: Checking a float


A have a float field in a db to store the number of bathrooms for a 
property ( 1.5 bathrooms, 3 bathrooms). My question is, how do I check 
to see if there is a non zero value after the decimal? I want it to show:

1.5 bathrooms
3 bathrooms

and not:

1.5 bathrooms
3.0 bathrooms

Any help is greatly appreciated.

Cutter
Falcon Knives


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

RE: cfexecute under Unix RESOLVED

[Chris Norloff]

Thanks to all who've responded to my request for help with running cfexecute under 
Unix (CF 4.5 SP2, Solaris 8).

Looks like it's a CF bug, as it works okay in CF 5 but not 4.5.

One more reason to get us upgraded!

thanks,
Chris Norloff

"What's wrong with computing in the 20th Century?"

-- Original Message --
from: "Rob Rohan" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Thu, 14 Nov 2002 13:06:25 -0800

>I don't have access to a unix box at work so this is just a guess, but you
>could make a script file:
>
>+===+
>#!/bin/sh
>
>cfstat > output.txt 2>&1
>
>+===+
>
>save it in the /opt/coldfusion/bin directory
>
>$chmod u+x [filename]
>
>
>then in cf load in the output file after executing.
>
>   name="/opt/coldfusion/bin/[filename]"
>   timeout="5"
>/>
>
>
>
>Shot in the dark.
>
>
>
>-Original Message-
>From: Chris Norloff [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, November 14, 2002 12:53 PM
>To: CF-Talk
>Subject: Re: cfexecute under Unix?
>
>
>This is what cfstat outputs. The call with cfexecute is not even writing the
>cfstat.txt file, so something basic must be wrong.  I even tried just to get
>the machine to ping an IP address ... no joy.
>
>I think this might be related to shells, of which I know very little.
>
>thanks,
>Chris Norloff
>
>Pg/Sec  DB/Sec  CP/Sec  Reqs Reqs  Reqs  AvgQ   AvgReq AvgDB  Bytes  Bytes
>Now Hi  Now Hi  Now Hi  Q'ed Run'g TO'ed Time   Time   Time   In/Sec Out/Sec
>0   0   0   0   0   0   00 300  8164070  0
>
>-- Original Message --
>from: "William Wheatley" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>date: Thu, 14 Nov 2002 15:24:03 -0500
>
>>what output are you trying to get? you dont get any output from it on the
>>screen but are you saying you're not getting the output into the cfstat.txt
>>file?
>>
>>What are you expecting to see? What do you see when you go in from the
>>command prompt
>>
>>- Original Message -
>>From: "Chris Norloff" <[EMAIL PROTECTED]>
>>To: "CF-Talk" <[EMAIL PROTECTED]>
>>Sent: Thursday, November 14, 2002 3:20 PM
>>Subject: cfexecute under Unix?
>>
>>
>>> I can't get cfexecute to run under Unix.  I can get it to "not error" but
>>I can't get any output.  The commands work okay when I su to userid nobody,
>>and permissions are okay on the directories.
>>>
>>> Any ideas?
>>>
>>> thanks,
>>> Chris Norloff
>>>
>>> >>   name="/opt/coldfusion/bin/cfstat"
>>>   outputfile="/opt/coldfusion/log/cfstat.txt"
>>>   timeout="5"
>>> >
>>> 
>>>
>>
>
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

RE: CF SQL problem

[Janine Jakim]

Test the page-
comment out the loop/query and put a 
#ListLen(Form.EmpID_Muster)#--#empID_muster#,
#emp_status#
This will show you how it's trying to update the database- and Jim is
probably right that it's trying to do something like 
EmpID/Emp_Status
123/1,1,1,1,1,1,1,1,1
Instead of what you want, which is
123/1
124/1
193/1
203/1
blah/blah/blah/blah
Maybe you should use a different field to use with listlen?? I guess I just
neveruse an autonumber type id with my loops.

-Original Message-
From: Jim Davis [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 18, 2002 11:12 AM
To: CF-Talk
Subject: RE: CF SQL problem


> I've never seen this message before.  Any ideas would be appreciated. 
> 
> Here's the code from the Action page:
> 
>  
>  tablename="muster" formfields="empID_muster, emp_status"> 
> 
> 
> And here's the info I get back from CF Debug
> 
> Error Executing Database Query. Invalid data 
> 1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1 for 
> CFSQLTYPE CF_SQL_NUMERIC. 

Well - it looks like you're trying to pass a list into a numeric column.

My guess is that you've got several form fields named the same - so that
the browser is sending one name as a list of all the values rather than
one value for each.

Jim Davis



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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.

How to get exact template requested

[Jochem van Dieten]

IIS 5, CF MX.

I need to find out the exact template as requested by the browser. That 
means without any default documents that the webserver might or might 
not add. I.e., if the requested URL by the browser is:
GET /admin/ HTTP/1.1
I need to get /admin/, even when the webserver adds a default document 
and passes the request on as /admin/index.cfm. I have tried CGI 
variables but they all have the default document. GetHTTPRequestData() 
apparently does not give access to all the request headers, because the 
part regarding the URI is omitted even though I see it in the network 
sniffer.

Any suggestions?

Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

RE: CF Studio like free editor?

[Josh Trefethen]

Bummer,  works great for me...

--
Josh Trefethen

:[ Exciteworks, Inc ]::[ http://exciteworks.com ]:. 
::[ cf hosting on linux ]::[ consulting ]::[ expertise ]::.
 

-Original Message-
From: Robertson-Ravo, Neil (REC)
[mailto:[EMAIL PROTECTED]] 
Sent: Monday, November 18, 2002 2:01 AM
To: CF-Talk
Subject: RE: CF Studio like free editor?


I have found this to be very unstable with JRE 1.4.1.  It crashes both
Windows XP and 2000 when you exit the application.



-Original Message-
From: Josh Trefethen [mailto:[EMAIL PROTECTED]]
Sent: 17 November 2002 01:33
To: CF-Talk
Subject: RE: CF Studio like free editor?


You should try Jedit -- look at www.jedit.org and
www.joshuasmiller.com/jedit

--
Josh Trefethen

:[ Exciteworks, Inc ]::[ http://exciteworks.com ]:. 
::[ cf hosting on linux ]::[ consulting ]::[ expertise ]::.
 

-Original Message-
From: Li Chunshen (Don) [mailto:[EMAIL PROTECTED]] 
Sent: Saturday, November 16, 2002 3:50 PM
To: CF-Talk
Subject: CF Studio like free editor?


Probably, I'm going to buy a copy of HomeSite soon
(for lack of alternatives), (HomeSite eval has
expired), but before that, I'd like to try some CF
Studio like free editor naturally without CF end TAG
insertion?  Does any one know anything like that
exist?  Thanks.

DL



__
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
http://webhosting.yahoo.com



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

Re: How to get exact template requested

[S . Isaac Dealey]

> IIS 5, CF MX.

> I need to find out the exact template as requested by the browser. That
> means without any default documents that the webserver might or might
> not add. I.e., if the requested URL by the browser is:
> GET /admin/ HTTP/1.1
> I need to get /admin/, even when the webserver adds a default document
> and passes the request on as /admin/index.cfm. I have tried CGI
> variables but they all have the default document. GetHTTPRequestData()
> apparently does not give access to all the request headers, because the
> part regarding the URI is omitted even though I see it in the network
> sniffer.

> Any suggestions?

> Jochem

Sounds like a pickle... The only thing that springs to my mind is javascript
location.href -- which iirc will give you the untampered path without the
default document... Unfortunately you have to go to the client to get it,
which I suspect is going to make the point moot for whatever it is you're
working on.

S. Isaac Dealey
Certified Advanced ColdFusion 5 Developer

www.turnkey.to
954-776-0046
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

RE: CF Studio like free editor?

[Robertson-Ravo, Neil (REC)]

I will stick with Studio :-)

-Original Message-
From: Josh Trefethen [mailto:[EMAIL PROTECTED]]
Sent: 18 November 2002 16:38
To: CF-Talk
Subject: RE: CF Studio like free editor?


Bummer,  works great for me...

--
Josh Trefethen

:[ Exciteworks, Inc ]::[ http://exciteworks.com ]:. 
::[ cf hosting on linux ]::[ consulting ]::[ expertise ]::.
 

-Original Message-
From: Robertson-Ravo, Neil (REC)
[mailto:[EMAIL PROTECTED]] 
Sent: Monday, November 18, 2002 2:01 AM
To: CF-Talk
Subject: RE: CF Studio like free editor?


I have found this to be very unstable with JRE 1.4.1.  It crashes both
Windows XP and 2000 when you exit the application.



-Original Message-
From: Josh Trefethen [mailto:[EMAIL PROTECTED]]
Sent: 17 November 2002 01:33
To: CF-Talk
Subject: RE: CF Studio like free editor?


You should try Jedit -- look at www.jedit.org and
www.joshuasmiller.com/jedit

--
Josh Trefethen

:[ Exciteworks, Inc ]::[ http://exciteworks.com ]:. 
::[ cf hosting on linux ]::[ consulting ]::[ expertise ]::.
 

-Original Message-
From: Li Chunshen (Don) [mailto:[EMAIL PROTECTED]] 
Sent: Saturday, November 16, 2002 3:50 PM
To: CF-Talk
Subject: CF Studio like free editor?


Probably, I'm going to buy a copy of HomeSite soon
(for lack of alternatives), (HomeSite eval has
expired), but before that, I'd like to try some CF
Studio like free editor naturally without CF end TAG
insertion?  Does any one know anything like that
exist?  Thanks.

DL



__
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
http://webhosting.yahoo.com




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

CF Studio like free editor?

[Judith Dinowitz]

Hi. This thread is really dealing with editing software, and as such probably belongs 
more on the DWMX list or the CF-OT list. :) But since you guys are being so good to 
each other here, and it's still only about 14 posts long, this is just a friendly 
suggestion from the Mistress of the House.

Judith Dinowitz
Mistress of the House
House of Fusion
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

Crybabies

[Judith Dinowitz]

I do appreciate the link, Booya, but as Jochem said, this really does belong on the 
CF-OT list. :)

Thanks,

Judith Dinowitz
Mistress of the House
House of Fusion
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

Anyone seen this strange 'Authorization error' message before?

[David Laing]

Hi All.

We have just moved a site of ours to a new hosting provider, and several 
pages have begun to through strange errors:

ie: one page throws:
---
Error Diagnostic Information

CFAssociate

Authorization error - user not authorized.

--
and another throws
---


Error Diagnostic Information

CFSchedule

Authorization error - user not authorized.

-

These pages worked fine up until before the site was moved to the new 
server, and don't do any thing more complicated than handle a form post 
or schedule a new task (the site doesn't use Advanced Security or 
anything like that)

Has anyone seen these errors before, or know what causes them?  (And of 
course how to make them go away :)

Thanks

David Laing
applicatrionjunction.com




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

RE: CF Studio like free editor?

[S . Isaac Dealey]

Yea, I'm running the last final release on Win2K Pro & Server with JRE 1.4.1
and haven't had this problem... The interface is a bit fidgety, but I have
yet to see a really clean Java UI for anything really so that's just sort of
par for the course...

S. Isaac Dealey
Certified Advanced ColdFusion 5 Developer

www.turnkey.to
954-776-0046

> Bummer,  works great for me...

> --
> Josh Trefethen

> :[ Exciteworks, Inc ]::[ http://exciteworks.com ]:.
> ::[ cf hosting on linux ]::[ consulting ]::[ expertise ]::.


> -Original Message-
> From: Robertson-Ravo, Neil (REC)
> [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 18, 2002 2:01 AM
> To: CF-Talk
> Subject: RE: CF Studio like free editor?


> I have found this to be very unstable with JRE 1.4.1.  It crashes both
> Windows XP and 2000 when you exit the application.



> -Original Message-
> From: Josh Trefethen [mailto:[EMAIL PROTECTED]]
> Sent: 17 November 2002 01:33
> To: CF-Talk
> Subject: RE: CF Studio like free editor?


> You should try Jedit -- look at www.jedit.org and
> www.joshuasmiller.com/jedit

> --
> Josh Trefethen

> :[ Exciteworks, Inc ]::[ http://exciteworks.com ]:.
> ::[ cf hosting on linux ]::[ consulting ]::[ expertise ]::.


> -Original Message-
> From: Li Chunshen (Don) [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, November 16, 2002 3:50 PM
> To: CF-Talk
> Subject: CF Studio like free editor?


> Probably, I'm going to buy a copy of HomeSite soon
> (for lack of alternatives), (HomeSite eval has
> expired), but before that, I'd like to try some CF
> Studio like free editor naturally without CF end TAG
> insertion?  Does any one know anything like that
> exist?  Thanks.

> DL



> __
> Do you Yahoo!?
> Yahoo! Web Hosting - Let the expert host your site
> http://webhosting.yahoo.com



> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

Re: Anyone seen this strange 'Authorization error' message before?

[S . Isaac Dealey]

Sounds to me like issues with sandboxing in MX. I'm not up enough on MX to
offer any specific advice unfortunately, but that's what I'd look at first.

> Hi All.

> We have just moved a site of ours to a new hosting provider, and several
> pages have begun to through strange errors:

> ie: one page throws:
> ---
> Error Diagnostic Information

> CFAssociate

> Authorization error - user not authorized.

> --
> and another throws
> ---


> Error Diagnostic Information

> CFSchedule

> Authorization error - user not authorized.

> -

> These pages worked fine up until before the site was moved to the new
> server, and don't do any thing more complicated than handle a form post
> or schedule a new task (the site doesn't use Advanced Security or
> anything like that)

> Has anyone seen these errors before, or know what causes them?  (And of
> course how to make them go away :)

> Thanks

> David Laing
> applicatrionjunction.com


S. Isaac Dealey
Certified Advanced ColdFusion 5 Developer

www.turnkey.to
954-776-0046
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Re: How to get exact template requested

[Jochem van Dieten]

S. Isaac Dealey wrote:

> Sounds like a pickle... The only thing that springs to my mind is 
> javascript location.href -- which iirc will give you the untampered 
> path without the default document... Unfortunately you have to go to 
> the client to get it, which I suspect is going to make the point moot 
> for whatever it is you're working on.

That won't do for this application :-(

The authenticating server must assure that the resource designated by
the "uri" directive is the same as the resource specified in the
Request-Line; if they are not, the server SHOULD return a 400 Bad
Request error.
 RFC 2617, HTTP Authentication

Getting at what is designated in the "uri" directive is easy, but I need 
server-side access to what is in the Request-Line.

Jochem

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

Re: CFMX & Classes

[Joe Eugene]

> I searched the MM website but didn't find
> anything specific.
Sean..Thanks for trying to find some doc.

It would be nice, if MM can put some documentation out there relating to..

1. Enabling "HOTLOAD" for Java Objects/classes/Java Beans when developing in
JSP or using CFObject.
2. What JVM does CFMX use when run under IBM WebSphere?
3. Any possibilities of using other(IBM/ORACLE/BEA) JVM's?

Thanks
Joe 


On Sun, 17 Nov 2002 13:23:53 -0800 Sean A Corfield <[EMAIL PROTECTED]> wrote:

> On Monday, Nov 11, 2002, at 19:17 US/Pacific,
> Joe Eugene wrote:
> > Can you point us to some MM docs on
> configuration or optimization
> > techniques?
> 

> 
> > Is there a way to force HOTSPOT VM, once the
> pages are compiled?
> 
> I don't know.
> 
> > Any MM docs on this?
> 
> I didn't find anything by searching the MM
> website.
> 
> Sean A Corfield -- Director, Architecture
> Web Technology Group -- Macromedia, Inc.
> tel: (415) 252-2287 -- cell: (415) 717-8473
> aim: seancorfield -- http://www.macromedia.com
> An Architect's View --
> http://www.corfield.org/blog/
> 
> Introducing Macromedia Contribute. Web
> publishing for everyone.
> Learn more at
> http://www.macromedia.com/contribute
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

Date time Question (CF and SQL)

[Ciliotta, Mario]

Hi All,

I have a questions, I am using Sql Server 7.0 and I have field called 
Event_Start_DateTime and I would like my query to be able to return to me two fields
the date and the time

ie 

The field contains:  12/12/2002 7:30:00AM

and I would like my query to return:

Dec 12  (Start Date)
7:30 PM (Start Time)

I know how to do it in CF, but I have many records returned and I would prefer to have 
my database do some of the work, instead of my cuff server doing all the work.

I believe that there are CAST and CONVERT functions but I cannot get it to work.

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=subscribe&forumid=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

RE: CF Studio like free editor and CFGRAPH with CF50

[Li Chunshen \(Don\)]

Thanks, Robertson-Ravo and Josh.  I'll skip the editor
thing for now.

An immediate, pressing problem:
Cfgraph does not display graph
(it seems jrun configuration and IIS configuration
mismatch something).  Here is the configuration scoop.
* CF50
* Windows XP Pro
* IIS 5.1
 JRunScripts --> using CF5.0 jrun (I had CFMX)
* JRun server = ColdFusion Management Repository
Server (jrun-cfam-config file indicated so)
* CFgraph fileFormat = jpg

Error:
graph/image not found(or not generated)
image property revealed
(http://127.0.0.1:8723/CFGraphingPage.cfm?Action=GetGraph&GraphFile=/cfgraphs/bar.swt&Key=-...
well, 1) couldn't find "CFGraphingPage.cfm" anywhere?
is it generated on demand? 2) current directory URL
prefix is http://127.0.0.1:8723/thisDir, 
so, even if CFGraphingPage.cfm is generated on demand,
should it be located at /[current
directory]/CFGraphingPage.cfm?

As for cfgraphs/bar.swt, it's under [CF_ROOT_DIR]

I've looked at CF admin, can't tell, what would be a
worthy try?

Thanks.

DL

--- Josh Trefethen <[EMAIL PROTECTED]>
wrote:
> Bummer,  works great for me...
> 
> --
> Josh Trefethen
> 
> :[ Exciteworks, Inc ]::[ http://exciteworks.com
> ]:. 
> ::[ cf hosting on linux ]::[ consulting ]::[
> expertise ]::.
>  
> 
> -Original Message-
> From: Robertson-Ravo, Neil (REC)
> [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, November 18, 2002 2:01 AM
> To: CF-Talk
> Subject: RE: CF Studio like free editor?
> 
> 
> I have found this to be very unstable with JRE
> 1.4.1.  It crashes both
> Windows XP and 2000 when you exit the application.
> 
> 
> 
> -Original Message-
> From: Josh Trefethen
> [mailto:[EMAIL PROTECTED]]
> Sent: 17 November 2002 01:33
> To: CF-Talk
> Subject: RE: CF Studio like free editor?
> 
> 
> You should try Jedit -- look at www.jedit.org and
> www.joshuasmiller.com/jedit
> 
> --
> Josh Trefethen
> 
> :[ Exciteworks, Inc ]::[ http://exciteworks.com
> ]:. 
> ::[ cf hosting on linux ]::[ consulting ]::[
> expertise ]::.
>  
> 
> -Original Message-
> From: Li Chunshen (Don) [mailto:[EMAIL PROTECTED]] 
> Sent: Saturday, November 16, 2002 3:50 PM
> To: CF-Talk
> Subject: CF Studio like free editor?
> 
> 
> Probably, I'm going to buy a copy of HomeSite soon
> (for lack of alternatives), (HomeSite eval has
> expired), but before that, I'd like to try some CF
> Studio like free editor naturally without CF end TAG
> insertion?  Does any one know anything like that
> exist?  Thanks.
> 
> DL
> 
> 
> 
> __
> Do you Yahoo!?
> Yahoo! Web Hosting - Let the expert host your site
> http://webhosting.yahoo.com
> 
> 
> 
>

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

Multiple Form Submitters?

[Luce, Greg]

I have a multipart form that has to become multi-multi-part. ;-( Right now
when I go from Step 1 to Step 2 with a submit button I do db stuff and then
go to step 2. I'm implimenting "paging" links, and I need them to submit the
form also, do db stuff and post back to the original fuseaction. (FB 3) And
also need a button to submit the form and go to Step 3.
What I'm trying to do is have a variable "done", and the paging links would
have "done=N" and the submit button "done=Y". I'm not a javascripter, but
here's what I've got:





Here's my Paging link:


And Here's my Submit button:



My form's not even submitting. Help?
***Sterling Financial Investment Group, Inc. (SFIG) is a member of
NASD/MSRB/NFA/SIPC.  Email transmissions may be monitored.  SFIG cannot
accept orders to buy or sell via email.  Please visit www.mysterling.com for
more information.***
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

RE: Multiple Form Submitters?

[Ben Doom]

Is it safe to assume that your form name is 'profile2' and you have a input
type=hidden named 'done'?

Also, what browsers are you testing this in, and is it failing in all of
them, or just one (I've noticed differences in how Mozilla and IE6 treat
names vs. ids).



  --Ben Doom
Programmer & General Lackey
Moonbow Software

: -Original Message-
: From: Luce, Greg [mailto:[EMAIL PROTECTED]]
: Sent: Monday, November 18, 2002 12:11 PM
: To: CF-Talk
: Subject: Multiple Form Submitters?
:
:
: I have a multipart form that has to become multi-multi-part. ;-( Right now
: when I go from Step 1 to Step 2 with a submit button I do db
: stuff and then
: go to step 2. I'm implimenting "paging" links, and I need them to
: submit the
: form also, do db stuff and post back to the original fuseaction.
: (FB 3) And
: also need a button to submit the form and go to Step 3.
: What I'm trying to do is have a variable "done", and the paging
: links would
: have "done=N" and the submit button "done=Y". I'm not a javascripter, but
: here's what I've got:
:
: 
: 
: 
:
: Here's my Paging link:
: 
:
: And Here's my Submit button:
: 
: 
:
: My form's not even submitting. Help?
: ***Sterling Financial Investment Group, Inc. (SFIG) is a member of
: NASD/MSRB/NFA/SIPC.  Email transmissions may be monitored.  SFIG cannot
: accept orders to buy or sell via email.  Please visit
www.mysterling.com for
more information.***

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

RE: Multiple Form Submitters?

[Luce, Greg]

Yeah, I have a hidden form field called "done". And I'm only worried about
IE. I'm using 6.0


-Original Message-
From: Ben Doom [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 18, 2002 12:29 PM
To: CF-Talk
Subject: RE: Multiple Form Submitters?


Is it safe to assume that your form name is 'profile2' and you have a input
type=hidden named 'done'?

Also, what browsers are you testing this in, and is it failing in all of
them, or just one (I've noticed differences in how Mozilla and IE6 treat
names vs. ids).



  --Ben Doom
Programmer & General Lackey
Moonbow Software

: -Original Message-
: From: Luce, Greg [mailto:[EMAIL PROTECTED]]
: Sent: Monday, November 18, 2002 12:11 PM
: To: CF-Talk
: Subject: Multiple Form Submitters?
:
:
: I have a multipart form that has to become multi-multi-part. ;-( Right now
: when I go from Step 1 to Step 2 with a submit button I do db
: stuff and then
: go to step 2. I'm implimenting "paging" links, and I need them to
: submit the
: form also, do db stuff and post back to the original fuseaction.
: (FB 3) And
: also need a button to submit the form and go to Step 3.
: What I'm trying to do is have a variable "done", and the paging
: links would
: have "done=N" and the submit button "done=Y". I'm not a javascripter, but
: here's what I've got:
:
: 
: 
: 
:
: Here's my Paging link:
: 
:
: And Here's my Submit button:
: 
: 
:
: My form's not even submitting. Help?
: ***Sterling Financial Investment Group, Inc. (SFIG) is a member of
: NASD/MSRB/NFA/SIPC.  Email transmissions may be monitored.  SFIG cannot
: accept orders to buy or sell via email.  Please visit
www.mysterling.com for
more information.***


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

MAKEUNIQUE Names In CFFILE Using MX

[Double Down, Inc.]

In the make file names unique in MX is there a way to change the naming convention so 
it does not just add a number to the end of the file name. (i.e. pic1.jpg, pic11.jpg, 
etc.)

Thanks.
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

Re: Date time Question (CF and SQL)

[jebmail]

Mario..
Here is one way of doing this You substitute GetDate() with your dates.

select Cast(left(DateName(mm,GetDate()),3) as varchar(3))+' '+ 
   Cast(DatePart(dd,GetDate()) as varchar(2))+' '+ 
   Cast(DatePart(,GetDate()) as varchar(4)) as currDate,
   Cast(DatePart(hh,GetDate()) as varchar(2))+':'+ 
   Cast(DatePart(mi,GetDate()) as varchar(2))+':'+ 
   Cast(DatePart(ss,GetDate()) as varchar(2)) as currTime

Joe


On Mon, 18 Nov 2002 12:05:12 -0500 "Ciliotta, Mario" <[EMAIL PROTECTED]>
wrote:

> Hi All,
> 
> I have a questions, I am using Sql Server 7.0
> and I have field called Event_Start_DateTime
> and I would like my query to be able to return
> to me two fields
> the date and the time
> 
> ie 
> 
> The field contains:  12/12/2002 7:30:00AM
> 
> and I would like my query to return:
> 
> Dec 12  (Start Date)
> 7:30 PM (Start Time)
> 
> I know how to do it in CF, but I have many
> records returned and I would prefer to have my
> database do some of the work, instead of my
> cuff server doing all the work.
> 
> I believe that there are CAST and CONVERT
> functions but I cannot get it to work.
> 
> 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=subscribe&forumid=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

Re: Date time Question (CF and SQL)

[Joe Eugene]

Mario..
Here is one way of doing this You substitute GetDate() with your dates.

select Cast(left(DateName(mm,GetDate()),3) as varchar(3))+' '+ 
   Cast(DatePart(dd,GetDate()) as varchar(2))+' '+ 
   Cast(DatePart(,GetDate()) as varchar(4)) as currDate,
   Cast(DatePart(hh,GetDate()) as varchar(2))+':'+ 
   Cast(DatePart(mi,GetDate()) as varchar(2))+':'+ 
   Cast(DatePart(ss,GetDate()) as varchar(2)) as currTime

Joe


On Mon, 18 Nov 2002 12:05:12 -0500 "Ciliotta, Mario" <[EMAIL PROTECTED]>
wrote:

> Hi All,
> 
> I have a questions, I am using Sql Server 7.0
> and I have field called Event_Start_DateTime
> and I would like my query to be able to return
> to me two fields
> the date and the time
> 
> ie 
> 
> The field contains:  12/12/2002 7:30:00AM
> 
> and I would like my query to return:
> 
> Dec 12  (Start Date)
> 7:30 PM (Start Time)
> 
> I know how to do it in CF, but I have many
> records returned and I would prefer to have my
> database do some of the work, instead of my
> cuff server doing all the work.
> 
> I believe that there are CAST and CONVERT
> functions but I cannot get it to work.
> 
> 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=subscribe&forumid=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

Forms *sometimes* not holding info in MX

[E. Keith Dodd]

(my first posting ever on CFTalk)

Using a traditional html form for several uses, such as guest book. After
submitting to a processing page, do some error handling, noting any missing
or conflicting data, user to go back and fix/complete form. The usual
process.

Locally, on singleIP development server (MX), all is fine; go back and form
fields hold any existing data the way they should.

On remote, shared MX server, however, have mixed results. In a couple places
this works just as expected. In most, however, when go back to form (back
button), all earlier data is gone. (Note: If try to go forward then to the
error handling message, get notice that page has expired--that doesn't
happen in situations where form behaves properly.)
Behavior seems to be browser independent (IE 6 and Netscape 6).

Tried putting the identical templates on two different mx sites in a couple
of places (sites are one same server)

(Does not work means, form data missing when go back using back button and
shows page has expired if try then to go forward)

1. On one site, form does NOT work as expected regardless of directory
2. On another site, if at root level (www.abc.com/testform.cfm), it does NOT
work;
3. however at same site, if in a sub directory
(www.aabc.com/mydirectory/testform.com), it does work as expected.
4. As a control, used same templates at root level and subdirectly on a CF5
machine, and all works fine.

As stated, all works fine locally, but problems on the remote, shared
server. CF guy at hosting service can't see what could be causing this
behavior.

I don't have the foggiest idea of where to even begin looking to solve this.
And it seems more likely that it has something to do with remote server or
mapping than my code.

Appreciate any suggestions.

Searched the archives, but couldn't find anything about this.
(Search wasn't in vain, however. From a Ray Camden response, found why
serializing a form, via WDDX, was giving me only a random 10 fields rather
than all. Ray's response was a known MX bug, and to work around duplicate
the form first. THANKS Ray!)

Keith Dodd


-
[This E-mail scanned for viruses by declude AntiVirus Software]

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

Re: CFMX & Classes

[ksuh]

2) I would think this would be whatever JVM that's pointed to in the CFMX admin.
3) Sure, why not?  Download the JVM, install it, point CFMX to it, stop and restart 
the service.

- Original Message -
From: Joe Eugene <[EMAIL PROTECTED]>
Date: Monday, November 18, 2002 10:03 am
Subject: Re: CFMX & Classes

> > I searched the MM website but didn't find
> > anything specific.
> Sean..Thanks for trying to find some doc.
> 
> It would be nice, if MM can put some documentation out there 
> relating to..
> 
> 1. Enabling "HOTLOAD" for Java Objects/classes/Java Beans when 
> developing in
> JSP or using CFObject.
> 2. What JVM does CFMX use when run under IBM WebSphere?
> 3. Any possibilities of using other(IBM/ORACLE/BEA) JVM's?
> 
> Thanks
> Joe 
> 
> 
> On Sun, 17 Nov 2002 13:23:53 -0800 Sean A Corfield 
> <[EMAIL PROTECTED]> wrote:
> 
> > On Monday, Nov 11, 2002, at 19:17 US/Pacific,
> > Joe Eugene wrote:
> > > Can you point us to some MM docs on
> > configuration or optimization
> > > techniques?
> > 
> 
> > 
> > > Is there a way to force HOTSPOT VM, once the
> > pages are compiled?
> > 
> > I don't know.
> > 
> > > Any MM docs on this?
> > 
> > I didn't find anything by searching the MM
> > website.
> > 
> > Sean A Corfield -- Director, Architecture
> > Web Technology Group -- Macromedia, Inc.
> > tel: (415) 252-2287 -- cell: (415) 717-8473
> > aim: seancorfield -- http://www.macromedia.com
> > An Architect's View --
> > http://www.corfield.org/blog/
> > 
> > Introducing Macromedia Contribute. Web
> > publishing for everyone.
> > Learn more at
> > http://www.macromedia.com/contribute
> > 
> > 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Re: Multiple Form Submitters?

[charlie griefer]

Greg: 

The problem might be having a function (done()) with the same name as a form 
field (your hidden field). 

not 100% sure that's it...but it's worth eliminating as a possibility :) 

charlie 


Luce, Greg writes: 

> Yeah, I have a hidden form field called "done". And I'm only worried about
> IE. I'm using 6.0 
> 
> 
> -Original Message-
> From: Ben Doom [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 18, 2002 12:29 PM
> To: CF-Talk
> Subject: RE: Multiple Form Submitters? 
> 
> 
> Is it safe to assume that your form name is 'profile2' and you have a input
> type=hidden named 'done'? 
> 
> Also, what browsers are you testing this in, and is it failing in all of
> them, or just one (I've noticed differences in how Mozilla and IE6 treat
> names vs. ids). 
> 
>  
> 
>   --Ben Doom
> Programmer & General Lackey
> Moonbow Software 
> 
> : -Original Message-
> : From: Luce, Greg [mailto:[EMAIL PROTECTED]]
> : Sent: Monday, November 18, 2002 12:11 PM
> : To: CF-Talk
> : Subject: Multiple Form Submitters?
> :
> :
> : I have a multipart form that has to become multi-multi-part. ;-( Right now
> : when I go from Step 1 to Step 2 with a submit button I do db
> : stuff and then
> : go to step 2. I'm implimenting "paging" links, and I need them to
> : submit the
> : form also, do db stuff and post back to the original fuseaction.
> : (FB 3) And
> : also need a button to submit the form and go to Step 3.
> : What I'm trying to do is have a variable "done", and the paging
> : links would
> : have "done=N" and the submit button "done=Y". I'm not a javascripter, but
> : here's what I've got:
> :
> : 
> : 
> : 
> :
> : Here's my Paging link:
> : 
> :
> : And Here's my Submit button:
> : 
> :  : border="0">
> :
> : My form's not even submitting. Help?
> : ***Sterling Financial Investment Group, Inc. (SFIG) is a member of
> : NASD/MSRB/NFA/SIPC.  Email transmissions may be monitored.  SFIG cannot
> : accept orders to buy or sell via email.  Please visit
> www.mysterling.com for
> more information.*** 
> 
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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.

RE: Multiple Form Submitters?

[Ben Doom]

Hmm.  Is it throwing an error, or just not working?

You might need to refer to the form by
document.forms[0].
rather than
document.formname.

I seem to recall having some trouble out of IE with DOM names.  :-(



  --Ben Doom
Programmer & General Lackey
Moonbow Software

: -Original Message-
: From: Luce, Greg [mailto:[EMAIL PROTECTED]]
: Sent: Monday, November 18, 2002 12:34 PM
: To: CF-Talk
: Subject: RE: Multiple Form Submitters?
:
:
: Yeah, I have a hidden form field called "done". And I'm only worried about
: IE. I'm using 6.0
:
:
: -Original Message-
: From: Ben Doom [mailto:[EMAIL PROTECTED]]
: Sent: Monday, November 18, 2002 12:29 PM
: To: CF-Talk
: Subject: RE: Multiple Form Submitters?
:
:
: Is it safe to assume that your form name is 'profile2' and you
: have a input
: type=hidden named 'done'?
:
: Also, what browsers are you testing this in, and is it failing in all of
: them, or just one (I've noticed differences in how Mozilla and IE6 treat
: names vs. ids).
:
:
:
:   --Ben Doom
: Programmer & General Lackey
: Moonbow Software
:
: : -Original Message-
: : From: Luce, Greg [mailto:[EMAIL PROTECTED]]
: : Sent: Monday, November 18, 2002 12:11 PM
: : To: CF-Talk
: : Subject: Multiple Form Submitters?
: :
: :
: : I have a multipart form that has to become multi-multi-part.
: ;-( Right now
: : when I go from Step 1 to Step 2 with a submit button I do db
: : stuff and then
: : go to step 2. I'm implimenting "paging" links, and I need them to
: : submit the
: : form also, do db stuff and post back to the original fuseaction.
: : (FB 3) And
: : also need a button to submit the form and go to Step 3.
: : What I'm trying to do is have a variable "done", and the paging
: : links would
: : have "done=N" and the submit button "done=Y". I'm not a
: javascripter, but
: : here's what I've got:
: :
: : 
: : 
: : 
: :
: : Here's my Paging link:
: : 
: :
: : And Here's my Submit button:
: : 
: : 
: :
: : My form's not even submitting. Help?
: : ***Sterling Financial Investment Group, Inc. (SFIG) is a member of
: : NASD/MSRB/NFA/SIPC.  Email transmissions may be monitored.  SFIG cannot
: : accept orders to buy or sell via email.  Please visit
: www.mysterling.com for
: more information.***
:
:
: 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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.

Re: cfmx and cgi

[Sean A Corfield]

On Sunday, Nov 17, 2002, at 22:03 US/Pacific, Jason Burnett wrote:
> There is no error logged anywhere. Basically if I try to execute a cgi
> while cf is running the webserver returns the code of the cgi, as if it
> were just a text file. Once I stop cold fusion cgi's work fine.

Very odd. Sounds like a configuration problem with Apache because we 
have CGIs working just fine here alongside CFMX. Send me your 
httpd.conf offlist and I'll see if I can figure out what the problem is.

Sean A Corfield -- Director, Architecture
Web Technology Group -- Macromedia, Inc.
tel: (415) 252-2287 -- cell: (415) 717-8473
aim: seancorfield -- http://www.macromedia.com
An Architect's View -- http://www.corfield.org/blog/

Introducing Macromedia Contribute. Web publishing for everyone.
Learn more at http://www.macromedia.com/contribute

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

Re: Forms *sometimes* not holding info in MX

[ksuh]

Don't rely on the browser to hold form values.  Rather, redisplay the form with the 
value attribute populated.

- Original Message -
From: "E. Keith Dodd" <[EMAIL PROTECTED]>
Date: Monday, November 18, 2002 10:44 am
Subject: Forms *sometimes* not holding info in MX

> (my first posting ever on CFTalk)
> 
> Using a traditional html form for several uses, such as guest 
> book. After
> submitting to a processing page, do some error handling, noting 
> any missing
> or conflicting data, user to go back and fix/complete form. The usual
> process.
> 
> Locally, on singleIP development server (MX), all is fine; go back 
> and form
> fields hold any existing data the way they should.
> 
> On remote, shared MX server, however, have mixed results. In a 
> couple places
> this works just as expected. In most, however, when go back to 
> form (back
> button), all earlier data is gone. (Note: If try to go forward 
> then to the
> error handling message, get notice that page has expired--that doesn't
> happen in situations where form behaves properly.)
> Behavior seems to be browser independent (IE 6 and Netscape 6).
> 
> Tried putting the identical templates on two different mx sites in 
> a couple
> of places (sites are one same server)
> 
> (Does not work means, form data missing when go back using back 
> button and
> shows page has expired if try then to go forward)
> 
> 1. On one site, form does NOT work as expected regardless of directory
> 2. On another site, if at root level (www.abc.com/testform.cfm), 
> it does NOT
> work;
> 3. however at same site, if in a sub directory
> (www.aabc.com/mydirectory/testform.com), it does work as expected.
> 4. As a control, used same templates at root level and subdirectly 
> on a CF5
> machine, and all works fine.
> 
> As stated, all works fine locally, but problems on the remote, shared
> server. CF guy at hosting service can't see what could be causing this
> behavior.
> 
> I don't have the foggiest idea of where to even begin looking to 
> solve this.
> And it seems more likely that it has something to do with remote 
> server or
> mapping than my code.
> 
> Appreciate any suggestions.
> 
> Searched the archives, but couldn't find anything about this.
> (Search wasn't in vain, however. From a Ray Camden response, found why
> serializing a form, via WDDX, was giving me only a random 10 
> fields rather
> than all. Ray's response was a known MX bug, and to work around 
> duplicatethe form first. THANKS Ray!)
> 
> Keith Dodd
> 
> 
> -
> [This E-mail scanned for viruses by declude AntiVirus Software]
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Re: CFMX & Classes

[Sean A Corfield]

I've forwarded your email to the product and the support folks to get  
feedback.

On Monday, Nov 18, 2002, at 09:03 US/Pacific, Joe Eugene wrote:

>> I searched the MM website but didn't find
>> anything specific.
> Sean..Thanks for trying to find some doc.
>
> It would be nice, if MM can put some documentation out there relating  
> to..
>
> 1. Enabling "HOTLOAD" for Java Objects/classes/Java Beans when  
> developing in
> JSP or using CFObject.
> 2. What JVM does CFMX use when run under IBM WebSphere?
> 3. Any possibilities of using other(IBM/ORACLE/BEA) JVM's?
>
> Thanks
> Joe
>
>
> On Sun, 17 Nov 2002 13:23:53 -0800 Sean A Corfield <[EMAIL PROTECTED]>  
> wrote:
>
>> On Monday, Nov 11, 2002, at 19:17 US/Pacific,
>> Joe Eugene wrote:
>>> Can you point us to some MM docs on
>> configuration or optimization
>>> techniques?
>>
>
>>
>>> Is there a way to force HOTSPOT VM, once the
>> pages are compiled?
>>
>> I don't know.
>>
>>> Any MM docs on this?
>>
>> I didn't find anything by searching the MM
>> website.
>>
>> Sean A Corfield -- Director, Architecture
>> Web Technology Group -- Macromedia, Inc.
>> tel: (415) 252-2287 -- cell: (415) 717-8473
>> aim: seancorfield -- http://www.macromedia.com
>> An Architect's View --
>> http://www.corfield.org/blog/
>>
>> Introducing Macromedia Contribute. Web
>> publishing for everyone.
>> Learn more at
>> http://www.macromedia.com/contribute
>>
>>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

RE: Date time Question (CF and SQL)

[Ciliotta, Mario]

Thanks for the help.

Mario

-Original Message-
From: Joe Eugene [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 18, 2002 12:42 PM
To: CF-Talk
Subject: Re: Date time Question (CF and SQL)


Mario..
Here is one way of doing this You substitute GetDate() with your dates.

select Cast(left(DateName(mm,GetDate()),3) as varchar(3))+' '+ 
   Cast(DatePart(dd,GetDate()) as varchar(2))+' '+ 
   Cast(DatePart(,GetDate()) as varchar(4)) as currDate,
   Cast(DatePart(hh,GetDate()) as varchar(2))+':'+ 
   Cast(DatePart(mi,GetDate()) as varchar(2))+':'+ 
   Cast(DatePart(ss,GetDate()) as varchar(2)) as currTime

Joe


On Mon, 18 Nov 2002 12:05:12 -0500 "Ciliotta, Mario" <[EMAIL PROTECTED]>
wrote:

> Hi All,
> 
> I have a questions, I am using Sql Server 7.0
> and I have field called Event_Start_DateTime
> and I would like my query to be able to return
> to me two fields
> the date and the time
> 
> ie 
> 
> The field contains:  12/12/2002 7:30:00AM
> 
> and I would like my query to return:
> 
> Dec 12  (Start Date)
> 7:30 PM (Start Time)
> 
> I know how to do it in CF, but I have many
> records returned and I would prefer to have my
> database do some of the work, instead of my
> cuff server doing all the work.
> 
> I believe that there are CAST and CONVERT
> functions but I cannot get it to work.
> 
> 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=subscribe&forumid=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

Forms *sometimes* not holding info in MX

[Keith Dodd]

You mean pack up or hidden fields all the fields and have user click a back link 
rather than the back button, then repopulate the form? Not sure I understand.

Seems strange that until trying the form on MX, never in dozens of such forms have had 
this problem. And the existance of problem seems to vary with the site/directory. And 
all works fine on CF5 site.
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

OT: updateing a decimal field in an Access DB...

[Yager, Brian T Contractor/Sverdrup]

I am having problems updatin a field in my database.  The field is a number,
with field size = Decimal, Format = General Number, and long enough to store my
number.  Here is my code that isn't working.

update tax_tbl set tax_amount = .08 where tax_key = 1;

It is putting a -1 as the value.  If I change the tax_amount = 0, then it puts 0
in as the value.  Can anyone help?

Thanks,

Brian Yager
President - North AL Cold Fusion Users Group
http://www.nacfug.com
Sr. Systems Analyst
Sverdrup/CIC
[EMAIL PROTECTED]
(256) 842-8342

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

sql oddity (repost)

[Tony Weeg]

hi there.
could anyone please tell me how in the heck i can
do a dbquery to get all instances of a match of these

’ 

in that exact string from within a text (Datatype) field full of other
data?

they are supposed to be 's and for some odd reason, in my cut and
paste from word to a text file, then into a textarea formfield, ended up
in the db like  "driver’s"  where that should be "driver's" like
"driver's license"

anyway, its making life hell right now, and i gotta get em out!

thanks.

this isnt working...


select count(Id) as thisCount from seatBeltLaws where line like
'%â€tm%'


#get1.thisCount#

wow its getting late.

...tony

tony weeg
[EMAIL PROTECTED]
www.revolutionwebdesign.com
rEvOlUtIoN wEb DeSiGn
410.334.6331

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

DreamweaverMX Bug?

[grant]

Has anyone else seen this type of behavior with DreamweaverMX?

I'm a longtime ColdFusion Studio user and trying to switch to DreamweaverMX. I 
am editing one of my templates, via RDS, in DreamweaverMX.  When I save the 
template, it is changing the last three lines of my code as follows.  I added 
the comments while trying to figure out what DreamweaverMX was doing to my 
code and have left them intact below as it may help others to see what 
DreamweaverMX is doing:

WAS:

   

  
 


DREAMWEAVER CHANGED TO:




  

--
Grant Szabo, Sr. Software Architect
MCSE, MCSD, MCSA, MCDBA, MCP
Macromedia Certified Cold Fusion 5 & MX Developer
office: 513.321.1636 | fax: 617.588.0219
www.quagmire.com | www.sterlingcreek.net

-
This mail sent through IMP: http://horde.org/imp/
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Re: CFMX & Classes

[Joe Eugene]

There are some issues doing this.. Suns J2SE JVM's work fine..
Try specifying a hotspot option to the JVM..CFMX doesnt like it..Option is
-hotspot

Joe

On Mon, 18 Nov 2002 10:48:38 -0700 [EMAIL PROTECTED] wrote:

> 2) I would think this would be whatever JVM
> that's pointed to in the CFMX admin.
> 3) Sure, why not?  Download the JVM, install
> it, point CFMX to it, stop and restart the
> service.
> 
> - Original Message -
> From: Joe Eugene 
> Date: Monday, November 18, 2002 10:03 am
> Subject: Re: CFMX & Classes
> 
> > > I searched the MM website but didn't find
> > > anything specific.
> > Sean..Thanks for trying to find some doc.
> > 
> > It would be nice, if MM can put some
> documentation out there 
> > relating to..
> > 
> > 1. Enabling "HOTLOAD" for Java
> Objects/classes/Java Beans when 
> > developing in
> > JSP or using CFObject.
> > 2. What JVM does CFMX use when run under IBM
> WebSphere?
> > 3. Any possibilities of using
> other(IBM/ORACLE/BEA) JVM's?
> > 
> > Thanks
> > Joe 
> > 
> > 
> > On Sun, 17 Nov 2002 13:23:53 -0800 Sean A
> Corfield 
> >  wrote:
> > 
> > > On Monday, Nov 11, 2002, at 19:17
> US/Pacific,
> > > Joe Eugene wrote:
> > > > Can you point us to some MM docs on
> > > configuration or optimization
> > > > techniques?
> > > 
> > 
> > > 
> > > > Is there a way to force HOTSPOT VM, once
> the
> > > pages are compiled?
> > > 
> > > I don't know.
> > > 
> > > > Any MM docs on this?
> > > 
> > > I didn't find anything by searching the MM
> > > website.
> > > 
> > > Sean A Corfield -- Director, Architecture
> > > Web Technology Group -- Macromedia, Inc.
> > > tel: (415) 252-2287 -- cell: (415) 717-8473
> > > aim: seancorfield --
> http://www.macromedia.com
> > > An Architect's View --
> > > http://www.corfield.org/blog/
> > > 
> > > Introducing Macromedia Contribute. Web
> > > publishing for everyone.
> > > Learn more at
> > > http://www.macromedia.com/contribute
> > > 
> > > 
> > 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

Re: How to get exact template requested

[S . Isaac Dealey]

Yea, that's what I thought... I wouldn't know where to begin,
unfortunately...

> S. Isaac Dealey wrote:

>> Sounds like a pickle... The only thing that springs to my
>> mind is
>> javascript location.href -- which iirc will give you the
>> untampered
>> path without the default document... Unfortunately you
>> have to go to
>> the client to get it, which I suspect is going to make
>> the point moot
>> for whatever it is you're working on.

> That won't do for this application :-(
> 
> The authenticating server must assure that the
> resource designated by
> the "uri" directive is the same as the resource
> specified in the
> Request-Line; if they are not, the server SHOULD
> return a 400 Bad
> Request error.
>  RFC 2617, HTTP Authentication

> Getting at what is designated in the "uri" directive is
> easy, but I need
> server-side access to what is in the Request-Line.

> Jochem

> ~~
> ~~~|
> Archives:
> http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
> Subscription: http://www.houseoffusion.com/cf_lists/index.
> cfm?method=subscribe&forumid=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


Isaac
Certified Advanced ColdFusion 5 Developer

www.turnkey.to
954-776-0046

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

RE: DreamweaverMX Bug?

[Samuel Neff]

Are all of your tags properly nested?  I have run into other issues with
Dreamweaver when there were problems with the code.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Monday, November 18, 2002 1:40 PM
To: CF-Talk
Subject: DreamweaverMX Bug?


Has anyone else seen this type of behavior with DreamweaverMX?

I'm a longtime ColdFusion Studio user and trying to switch to
DreamweaverMX. I 
am editing one of my templates, via RDS, in DreamweaverMX.  When I save
the 
template, it is changing the last three lines of my code as follows.  I
added 
the comments while trying to figure out what DreamweaverMX was doing to
my 
code and have left them intact below as it may help others to see what 
DreamweaverMX is doing:

WAS:

   

  
 


DREAMWEAVER CHANGED TO:




  


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

RE: updating a decimal field in an Access DB...SOLVED

[Yager, Brian T Contractor/Sverdrup]

I'm an idiot...there were more arguments in this SQL and THAT was making it do
that.  Sorry Everyone.

Brian

-Original Message-
From: Yager, Brian T Contractor/Sverdrup
[mailto:[EMAIL PROTECTED]]
Sent: Monday, November 18, 2002 12:34 PM
To: CF-Talk
Subject: OT: updateing a decimal field in an Access DB...


I am having problems updatin a field in my database.  The field is a number,
with field size = Decimal, Format = General Number, and long enough to store my
number.  Here is my code that isn't working.

update tax_tbl set tax_amount = .08 where tax_key = 1;

It is putting a -1 as the value.  If I change the tax_amount = 0, then it puts 0
in as the value.  Can anyone help?

Thanks,

Brian Yager
President - North AL Cold Fusion Users Group
http://www.nacfug.com
Sr. Systems Analyst
Sverdrup/CIC
[EMAIL PROTECTED]
(256) 842-8342


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

RE: CF Studio like free editor?

[Rob Rohan]

Works really well for me on W2k and on Red Hat 7.3 - jdk1.4 on both.

-Original Message-
From: Joshua Miller [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 18, 2002 6:28 AM
To: CF-Talk
Subject: RE: CF Studio like free editor?


I'm running it on Windows XP and Windows 2K with JSDK 1.4.1 and have no
issues with crashing on exit. There are some problems on MacOSX with JDK
1.4.x but that's because Apple hasn't finished up their Java 1.4.x
implementation - still a preview release. Haven't put 1.4.x on Linux
yet, but it's running fine for me under Windows.

Joshua Miller
[EMAIL PROTECTED]


-Original Message-
From: Robertson-Ravo, Neil (REC)
[mailto:[EMAIL PROTECTED]]
Sent: Monday, November 18, 2002 5:01 AM
To: CF-Talk
Subject: RE: CF Studio like free editor?


I have found this to be very unstable with JRE 1.4.1.  It crashes both
Windows XP and 2000 when you exit the application.



-Original Message-
From: Josh Trefethen [mailto:[EMAIL PROTECTED]]
Sent: 17 November 2002 01:33
To: CF-Talk
Subject: RE: CF Studio like free editor?


You should try Jedit -- look at www.jedit.org and
www.joshuasmiller.com/jedit

--
Josh Trefethen

:[ Exciteworks, Inc ]::[ http://exciteworks.com ]:.
::[ cf hosting on linux ]::[ consulting ]::[ expertise ]::.


-Original Message-
From: Li Chunshen (Don) [mailto:[EMAIL PROTECTED]]
Sent: Saturday, November 16, 2002 3:50 PM
To: CF-Talk
Subject: CF Studio like free editor?


Probably, I'm going to buy a copy of HomeSite soon
(for lack of alternatives), (HomeSite eval has
expired), but before that, I'd like to try some CF
Studio like free editor naturally without CF end TAG
insertion?  Does any one know anything like that
exist?  Thanks.

DL



__
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
http://webhosting.yahoo.com




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

RE: How to get exact template requested

[Samuel Neff]

Since the web server maps a request-line to a template file name, it may
be that the only way to get this info is at the web server
level--perhaps with an ISAPI filter for IIS or mod for apache.  If this
is feasible, you may be able to add a new custom CGI variable with this
info which is then easily accessible from CF/Java.

> Getting at what is designated in the "uri" directive is
> easy, but I need
> server-side access to what is in the Request-Line.

> Jochem


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

Re: DreamweaverMX Bug?

[Ian Lurie]

I contacted Macromedia about MX munging my  statements - we
e-mailed back and forth a few times, and then they sort of trailed off.

My guess is they're (please god) working on a fix for MX's penchant for
edits...

On 11/18/02 10:40 AM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:

> Has anyone else seen this type of behavior with DreamweaverMX?
> 
> I'm a longtime ColdFusion Studio user and trying to switch to DreamweaverMX. I
> am editing one of my templates, via RDS, in DreamweaverMX.  When I save the
> template, it is changing the last three lines of my code as follows.  I added
> the comments while trying to figure out what DreamweaverMX was doing to my
> code and have left them intact below as it may help others to see what
> DreamweaverMX is doing:
> 
> WAS:
> 
>  
> 
>  
>  
> 
> 
> DREAMWEAVER CHANGED TO:
> 
> 
>   
> 
>  
> 
> --
> Grant Szabo, Sr. Software Architect
> MCSE, MCSD, MCSA, MCDBA, MCP
> Macromedia Certified Cold Fusion 5 & MX Developer
> office: 513.321.1636 | fax: 617.588.0219
> www.quagmire.com | www.sterlingcreek.net
> 
> -
> This mail sent through IMP: http://horde.org/imp/
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

RE: SOT Tool to disassemble Java class files

[Rob Rohan]

Jedit has a built in decompiler (probably uses javap or mocha) you just
click decomplie and - BAM you have it in the editor

www.jedit.org

-Original Message-
From: Dick Applebaum [mailto:[EMAIL PROTECTED]]
Sent: Saturday, November 16, 2002 3:40 AM
To: CF-Talk
Subject: SOT Tool to disassemble Java class files


What do people use to disassemble Java Class files?

This is legitimate!

I am trying to figure out what functions exist in a Java applet, so I
can interface them with JavaScript.

I am on Mac OS X, so 'Nix or Java based tools would be preferred.

TIA

Dick


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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.

Re: sql oddity (repost)

[Tyler Silcox]

There's a great little UDF on cflib.org called DeMoronize that should help
you out with this:
http://www.cflib.org/udf.cfm?ID=725

I don't know how to grab the infected fields through SQL, but I'd just write
a couple queries to accomplish the same thing: grab all records, loop
through them, run the UDF on the particular columns and then update the
fields.

I also added this to the top to pick up some of the funky A's:

// remove funky A's
Text = Replace(Text, "Ã", "", "All");
Text = Replace(Text, "Â", "", "All");

And the last ReReplace has an extra double quote in it, so ReReplace(Text,
""(^;)", ""\1", "All"); should be ReReplace(Text, "(^;)", ""\1",
"All");.

Tyler
email | [EMAIL PROTECTED]

- Original Message -
From: "Tony Weeg" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 18, 2002 1:39 PM
Subject: sql oddity (repost)


hi there.
could anyone please tell me how in the heck i can
do a dbquery to get all instances of a match of these

â?T

in that exact string from within a text (Datatype) field full of other
data?

they are supposed to be 's and for some odd reason, in my cut and
paste from word to a text file, then into a textarea formfield, ended up
in the db like  "driverâ?Ts"  where that should be "driver's" like
"driver's license"

anyway, its making life hell right now, and i gotta get em out!

thanks.

this isnt working...


select count(Id) as thisCount from seatBeltLaws where line like
'%â?tm%'


#get1.thisCount#

wow its getting late.

..tony

tony weeg
[EMAIL PROTECTED]
www.revolutionwebdesign.com
rEvOlUtIoN wEb DeSiGn
410.334.6331


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

RE: DreamweaverMX Bug?

[Christine Lawson]

I'm seeing what I can find on this. Ian, if you want to let me know who you 
spoke/e-mailed with I might be able to find your status.

Thanks!
Christine

-Original Message-
From: Ian Lurie [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 18, 2002 1:54 PM
To: CF-Talk
Subject: Re: DreamweaverMX Bug?


I contacted Macromedia about MX munging my  statements - we
e-mailed back and forth a few times, and then they sort of trailed off.

My guess is they're (please god) working on a fix for MX's penchant for
edits...

On 11/18/02 10:40 AM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:

> Has anyone else seen this type of behavior with DreamweaverMX?
> 
> I'm a longtime ColdFusion Studio user and trying to switch to DreamweaverMX. I
> am editing one of my templates, via RDS, in DreamweaverMX.  When I save the
> template, it is changing the last three lines of my code as follows.  I added
> the comments while trying to figure out what DreamweaverMX was doing to my
> code and have left them intact below as it may help others to see what
> DreamweaverMX is doing:
> 
> WAS:
> 
>  
> 
>  
>  
> 
> 
> DREAMWEAVER CHANGED TO:
> 
> 
>   
> 
>  
> 
> --
> Grant Szabo, Sr. Software Architect
> MCSE, MCSD, MCSA, MCDBA, MCP
> Macromedia Certified Cold Fusion 5 & MX Developer
> office: 513.321.1636 | fax: 617.588.0219
> www.quagmire.com | www.sterlingcreek.net
> 
> -
> This mail sent through IMP: http://horde.org/imp/
> 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

SOT: PDF files with MX on the fly

[Rob Rohan]

I just finished a custom tag this weekend called cfx_treebeard. It can do
xslt transformations AND can translated FO documents into PDF. In other
words if you have the urge to do

XML + FO -> PDF

on the fly you can with this tag. It is of course free and open source. It
usage looks like:





you can get the tag at http://treebeard.sourceforge.net/cfx_treebeard.php

Have fun
Rob


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

RE: DreamweaverMX Bug?

[grant]

Thanks Sam - I indeed did verify that all the tags were nested properly.  The 
way I found the bug was actually saving the working template (which I 
initially wrote in CF Studio v5) in DreamweaverMX, refreshing in my browser 
and noting the ensuing page error.  Opening the page in CFStudio, I quickly 
saw what Dreamweaver did to mess up my code.  It took me saving it in CFStudio 
again to fix it (although I am sure notepad would have worked equally well).  
If I opened it in DreamweaverMX, made NO changes, then saved, it messed up the 
code again.

I tell you what, this is a really disconcerting problem and one that 
Macromedia had best look into FAST if they expect any ColdFusion developers to 
take a serious look at DreamweaverMX.  I mean what the heck is going on that 
the software is MOVING my lines of code around in my template on save??

I have reported this as a bug to Macromedia.

-Grant


Quoting Samuel Neff <[EMAIL PROTECTED]>:

> Are all of your tags properly nested?  I have run into other issues with
> Dreamweaver when there were problems with the code.
> 
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, November 18, 2002 1:40 PM
> To: CF-Talk
> Subject: DreamweaverMX Bug?
> 
> 
> Has anyone else seen this type of behavior with DreamweaverMX?
> 
> I'm a longtime ColdFusion Studio user and trying to switch to
> DreamweaverMX. I 
> am editing one of my templates, via RDS, in DreamweaverMX.  When I save
> the 
> template, it is changing the last three lines of my code as follows.  I
> added 
> the comments while trying to figure out what DreamweaverMX was doing to
> my 
> code and have left them intact below as it may help others to see what 
> DreamweaverMX is doing:
> 
> WAS:
> 
>
> 
>   
>  
> 
> 
> DREAMWEAVER CHANGED TO:
> 
> 
> 
> 
>   
> 
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Re: CFMX & Classes

[ksuh]

If you want to use the hotspot server jvm, point cfmx to the server jvm.dll, which is 
in the jre\bin\server directory of your installation (at least for 1.4.0_01 sdk).  I 
think you have to install the SDK, not the RE, to get the server hotspot.

- Original Message -
From: Joe Eugene <[EMAIL PROTECTED]>
Date: Monday, November 18, 2002 11:43 am
Subject: Re: CFMX & Classes

> There are some issues doing this.. Suns J2SE JVM's work fine..
> Try specifying a hotspot option to the JVM..CFMX doesnt like 
> it..Option is
> -hotspot
> 
> Joe
> 
> On Mon, 18 Nov 2002 10:48:38 -0700 [EMAIL PROTECTED] wrote:
> 
> > 2) I would think this would be whatever JVM
> > that's pointed to in the CFMX admin.
> > 3) Sure, why not?  Download the JVM, install
> > it, point CFMX to it, stop and restart the
> > service.
> > 
> > - Original Message -
> > From: Joe Eugene 
> > Date: Monday, November 18, 2002 10:03 am
> > Subject: Re: CFMX & Classes
> > 
> > > > I searched the MM website but didn't find
> > > > anything specific.
> > > Sean..Thanks for trying to find some doc.
> > > 
> > > It would be nice, if MM can put some
> > documentation out there 
> > > relating to..
> > > 
> > > 1. Enabling "HOTLOAD" for Java
> > Objects/classes/Java Beans when 
> > > developing in
> > > JSP or using CFObject.
> > > 2. What JVM does CFMX use when run under IBM
> > WebSphere?
> > > 3. Any possibilities of using
> > other(IBM/ORACLE/BEA) JVM's?
> > > 
> > > Thanks
> > > Joe 
> > > 
> > > 
> > > On Sun, 17 Nov 2002 13:23:53 -0800 Sean A
> > Corfield 
> > >  wrote:
> > > 
> > > > On Monday, Nov 11, 2002, at 19:17
> > US/Pacific,
> > > > Joe Eugene wrote:
> > > > > Can you point us to some MM docs on
> > > > configuration or optimization
> > > > > techniques?
> > > > 
> > > 
> > > > 
> > > > > Is there a way to force HOTSPOT VM, once
> > the
> > > > pages are compiled?
> > > > 
> > > > I don't know.
> > > > 
> > > > > Any MM docs on this?
> > > > 
> > > > I didn't find anything by searching the MM
> > > > website.
> > > > 
> > > > Sean A Corfield -- Director, Architecture
> > > > Web Technology Group -- Macromedia, Inc.
> > > > tel: (415) 252-2287 -- cell: (415) 717-8473
> > > > aim: seancorfield --
> > http://www.macromedia.com
> > > > An Architect's View --
> > > > http://www.corfield.org/blog/
> > > > 
> > > > Introducing Macromedia Contribute. Web
> > > > publishing for everyone.
> > > > Learn more at
> > > > http://www.macromedia.com/contribute
> > > > 
> > > > 
> > > 
> > 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

RE: PDF files with MX on the fly

[Rob Rohan]

Oh yeah, and unlike the build in cf xslt stuff and CF_XSLT you *can* pass
params to the style sheets.

-Original Message-
From: Rob Rohan [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 18, 2002 11:04 AM
To: CF-Talk
Subject: SOT: PDF files with MX on the fly



I just finished a custom tag this weekend called cfx_treebeard. It can do
xslt transformations AND can translated FO documents into PDF. In other
words if you have the urge to do

XML + FO -> PDF

on the fly you can with this tag. It is of course free and open source. It
usage looks like:





you can get the tag at http://treebeard.sourceforge.net/cfx_treebeard.php

Have fun
Rob



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

RE: DreamweaverMX Bug?

[Yager, Brian T Contractor/Sverdrup]

It does sound Microsoftish!

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 18, 2002 1:04 PM
To: CF-Talk
Subject: RE: DreamweaverMX Bug?


Thanks Sam - I indeed did verify that all the tags were nested properly.  The 
way I found the bug was actually saving the working template (which I 
initially wrote in CF Studio v5) in DreamweaverMX, refreshing in my browser 
and noting the ensuing page error.  Opening the page in CFStudio, I quickly 
saw what Dreamweaver did to mess up my code.  It took me saving it in CFStudio 
again to fix it (although I am sure notepad would have worked equally well).  
If I opened it in DreamweaverMX, made NO changes, then saved, it messed up the 
code again.

I tell you what, this is a really disconcerting problem and one that 
Macromedia had best look into FAST if they expect any ColdFusion developers to 
take a serious look at DreamweaverMX.  I mean what the heck is going on that 
the software is MOVING my lines of code around in my template on save??

I have reported this as a bug to Macromedia.

-Grant


Quoting Samuel Neff <[EMAIL PROTECTED]>:

> Are all of your tags properly nested?  I have run into other issues with
> Dreamweaver when there were problems with the code.
> 
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, November 18, 2002 1:40 PM
> To: CF-Talk
> Subject: DreamweaverMX Bug?
> 
> 
> Has anyone else seen this type of behavior with DreamweaverMX?
> 
> I'm a longtime ColdFusion Studio user and trying to switch to
> DreamweaverMX. I 
> am editing one of my templates, via RDS, in DreamweaverMX.  When I save
> the 
> template, it is changing the last three lines of my code as follows.  I
> added 
> the comments while trying to figure out what DreamweaverMX was doing to
> my 
> code and have left them intact below as it may help others to see what 
> DreamweaverMX is doing:
> 
> WAS:
> 
>
> 
>   
>  
> 
> 
> DREAMWEAVER CHANGED TO:
> 
> 
> 
> 
>   
> 
> 
> 

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

RE: PDF files with MX on the fly

[Nick McClure]

Hehe, .php for a CFX tag.

Kinda funny.

> -Original Message-
> From: Rob Rohan [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 18, 2002 2:04 PM
> To: CF-Talk
> Subject: SOT: PDF files with MX on the fly
> 
> 
> I just finished a custom tag this weekend called cfx_treebeard. It can
do
> xslt transformations AND can translated FO documents into PDF. In
other
> words if you have the urge to do
> 
> XML + FO -> PDF
> 
> on the fly you can with this tag. It is of course free and open
source. It
> usage looks like:
> 
>type="2"
>   xml="#xmlstring#"
>   xsl="C:\wwwroot\whatever\topdf.fo"
>   outfile="C:\wwwroot\3rdQ\fin.pdf"
> >
> 
> 
> 
> you can get the tag at
http://treebeard.sourceforge.net/cfx_treebeard.php
> 
> Have fun
> Rob
> 
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

Linux updater crash & burn

[Jim Campbell]

Hi all -

Trying to run the CFMX updater on a Linux installation - this is a new
install of MX, and running the updater, it dies with this error message:

--

# ./cfmx_updater_linux.bin
Preparing to install...
Extracting the JRE from the installer archive...
Unpacking the JRE...
Extracting the installation resources from the installer archive...
Configuring the installer for this system's environment...

Launching installer...

Error: can't find libjava.so.

--

Now libjava.so is most certainly there, it's exactly where the MX install
put it: /opt/coldfusionmx/jre/lib/i386/libjava.so

A reinstallation didn't help, so I'm stumped.  Should I install the most
up-to-date JRE from Sun?  Has anyone else had anything remotely like this
show up?  Does the installer have a conf file anywhere?  Why does
"monosyllabic" have 5 syllables?

Thanks,

- Jim


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

SSL Certificate usage in Cold Fusion

[Bartee Lamar]

I have purchased a secure certificate from GeoTrust.  I have it
installed in IIS under the www.mycustomer.com web site.  I can view the
certificate in IIS.
 
My question what mean of relocation / redirection do I use in Cold
fusion to get page to show using this certificate.
 
I am showing a age to enter credit card numbers.  I am using
 
 CFLOCATION url=

https://www.mycustomer.com/index.cfm?fuseaction=cart.dspcrditcard
token="yes">
 
NOTE: there is an S in the https ..
 
Is this the correct way to do this??
 
I am getting a page unable to display.  If I change the same URL to http
it will work.
 
Any suggestion and/or idea would greatly be appreciated.   I really need
to get this to work.
 
Bartee Lamar
www.enterpriseenergy.com  
MSN   [EMAIL PROTECTED] 
 
 


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

RE: DreamweaverMX Bug?

[Samuel Neff]

My experience was similar.  The most reproducible error I ran into was
when we have JavaScript files saved with a cfm extension.  Perfectly
valid thing to do but Dreamweaver didn't like it and really messed up
our code very time we saved a file.  The problem occurred only when
there was absolutely no CFM code in the template.  If we added some CFM
code to it, then Dreamweaver stopped messing it up.

There are a few known bugs that cause issues like this (although I'm not
aware of the specific scenario you explained).  Yes, they are very
disconcerting.  In my opinion, the mere fact that Dreamweaver mangles
code internally (by design, not by error) and then expects to re-output
the correct code in all cases when you save is far fetched.  

I saw Christine responded here already so MM is aware of your concern,
but I would still suggest making an official bug report through the wish
form.  http://www.macromedia.com/support/email/wishform/?6213=6

Sam

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Monday, November 18, 2002 2:04 PM
To: CF-Talk
Subject: RE: DreamweaverMX Bug?


Thanks Sam - I indeed did verify that all the tags were nested properly.
The 
way I found the bug was actually saving the working template (which I 
initially wrote in CF Studio v5) in DreamweaverMX, refreshing in my
browser 
and noting the ensuing page error.  Opening the page in CFStudio, I
quickly 
saw what Dreamweaver did to mess up my code.  It took me saving it in
CFStudio 
again to fix it (although I am sure notepad would have worked equally
well).  
If I opened it in DreamweaverMX, made NO changes, then saved, it messed
up the 
code again.

I tell you what, this is a really disconcerting problem and one that 
Macromedia had best look into FAST if they expect any ColdFusion
developers to 
take a serious look at DreamweaverMX.  I mean what the heck is going on
that 
the software is MOVING my lines of code around in my template on save??

I have reported this as a bug to Macromedia.

-Grant



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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.

Re: SSL Certificate usage in Cold Fusion

[jon hall]

Did you set port 443 as the SSL port in IIS? That's always the step I
forget...
cflocation will work fine...
-- 
 jon
 mailto:[EMAIL PROTECTED]

Monday, November 18, 2002, 2:19:40 PM, you wrote:
BL> I have purchased a secure certificate from GeoTrust.  I have it
BL> installed in IIS under the www.mycustomer.com web site.  I can view the
BL> certificate in IIS.
 
BL> My question what mean of relocation / redirection do I use in Cold
BL> fusion to get page to show using this certificate.
 
BL> I am showing a age to enter credit card numbers.  I am using
 
BL>  CFLOCATION url=
BL> 
BL> https://www.mycustomer.com/index.cfm?fuseaction=cart.dspcrditcard
token="yes">>
 
BL> NOTE: there is an S in the https ..
 
BL> Is this the correct way to do this??
 
BL> I am getting a page unable to display.  If I change the same URL to http
BL> it will work.
 
BL> Any suggestion and/or idea would greatly be appreciated.   I really need
BL> to get this to work.
 
BL> Bartee Lamar
BL> www.enterpriseenergy.com  
BL> MSN   [EMAIL PROTECTED] 
 
 


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

Re: CFMX & Classes

[ksuh]

Well, I tried my own advice out, and CFMX complains that the directory must have a bin 
dir in it, which means you can't choose the server jvm explicitly.  Perhaps MM should 
fix this.

- Original Message -
From: [EMAIL PROTECTED]
Date: Monday, November 18, 2002 12:05 pm
Subject: Re: CFMX & Classes

> If you want to use the hotspot server jvm, point cfmx to the 
> server jvm.dll, which is in the jre\bin\server directory of your 
> installation (at least for 1.4.0_01 sdk).  I think you have to 
> install the SDK, not the RE, to get the server hotspot.
> 
> - Original Message -
> From: Joe Eugene <[EMAIL PROTECTED]>
> Date: Monday, November 18, 2002 11:43 am
> Subject: Re: CFMX & Classes
> 
> > There are some issues doing this.. Suns J2SE JVM's work fine..
> > Try specifying a hotspot option to the JVM..CFMX doesnt like 
> > it..Option is
> > -hotspot
> > 
> > Joe
> > 
> > On Mon, 18 Nov 2002 10:48:38 -0700 [EMAIL PROTECTED] wrote:
> > 
> > > 2) I would think this would be whatever JVM
> > > that's pointed to in the CFMX admin.
> > > 3) Sure, why not?  Download the JVM, install
> > > it, point CFMX to it, stop and restart the
> > > service.
> > > 
> > > - Original Message -
> > > From: Joe Eugene 
> > > Date: Monday, November 18, 2002 10:03 am
> > > Subject: Re: CFMX & Classes
> > > 
> > > > > I searched the MM website but didn't find
> > > > > anything specific.
> > > > Sean..Thanks for trying to find some doc.
> > > > 
> > > > It would be nice, if MM can put some
> > > documentation out there 
> > > > relating to..
> > > > 
> > > > 1. Enabling "HOTLOAD" for Java
> > > Objects/classes/Java Beans when 
> > > > developing in
> > > > JSP or using CFObject.
> > > > 2. What JVM does CFMX use when run under IBM
> > > WebSphere?
> > > > 3. Any possibilities of using
> > > other(IBM/ORACLE/BEA) JVM's?
> > > > 
> > > > Thanks
> > > > Joe 
> > > > 
> > > > 
> > > > On Sun, 17 Nov 2002 13:23:53 -0800 Sean A
> > > Corfield 
> > > >  wrote:
> > > > 
> > > > > On Monday, Nov 11, 2002, at 19:17
> > > US/Pacific,
> > > > > Joe Eugene wrote:
> > > > > > Can you point us to some MM docs on
> > > > > configuration or optimization
> > > > > > techniques?
> > > > > 
> > > > 
> > > > > 
> > > > > > Is there a way to force HOTSPOT VM, once
> > > the
> > > > > pages are compiled?
> > > > > 
> > > > > I don't know.
> > > > > 
> > > > > > Any MM docs on this?
> > > > > 
> > > > > I didn't find anything by searching the MM
> > > > > website.
> > > > > 
> > > > > Sean A Corfield -- Director, Architecture
> > > > > Web Technology Group -- Macromedia, Inc.
> > > > > tel: (415) 252-2287 -- cell: (415) 717-8473
> > > > > aim: seancorfield --
> > > http://www.macromedia.com
> > > > > An Architect's View --
> > > > > http://www.corfield.org/blog/
> > > > > 
> > > > > Introducing Macromedia Contribute. Web
> > > > > publishing for everyone.
> > > > > Learn more at
> > > > > http://www.macromedia.com/contribute
> > > > > 
> > > > > 
> > > > 
> > > 
> > 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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.

RE: SSL Certificate usage in Cold Fusion

[Dan Phillips]

When you view the page, look at the cert name, it is showing up as
localhost.localdomain. It should read www.mycustomer.com
I have personally worked with Geotrust's tech support team and they are
excellent. Give them a call or email and they should be able to tell you
exactly how to fix it. Matt Conway is who I have worked with and he is very
efficient.

Thank you,

Dan Phillips
Express Technologies, Inc.
dba HalfPriceHosting, CFXHosting and Invotion.
www.HalfPriceHosting.com
www.CFXHosting.com
www.Invotion.com


-Original Message-
From: Bartee Lamar [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 18, 2002 2:20 PM
To: CF-Talk
Subject: SSL Certificate usage in Cold Fusion


I have purchased a secure certificate from GeoTrust.  I have it
installed in IIS under the www.mycustomer.com web site.  I can view the
certificate in IIS.

My question what mean of relocation / redirection do I use in Cold
fusion to get page to show using this certificate.

I am showing a age to enter credit card numbers.  I am using

 CFLOCATION url=

https://www.mycustomer.com/index.cfm?fuseaction=cart.dspcrditcard
token="yes">

NOTE: there is an S in the https ..

Is this the correct way to do this??

I am getting a page unable to display.  If I change the same URL to http
it will work.

Any suggestion and/or idea would greatly be appreciated.   I really need
to get this to work.

Bartee Lamar
www.enterpriseenergy.com 
MSN   [EMAIL PROTECTED]





~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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.

RE: SSL Certificate usage in Cold Fusion

[Dave Watts]

> I am showing a age to enter credit card numbers. I am using
>  
>  CFLOCATION url=
> 
> https://www.mycustomer.com/index.cfm?fuseaction=cart.dspcrditcard
> token="yes">
>  
> NOTE: there is an S in the https ..
>  
> Is this the correct way to do this??
>  
> I am getting a page unable to display. If I change the same 
> URL to http it will work.

This sounds like an IIS configuration problem, rather than anything to do
with CF. What happens if you request an HTML page in the same directory via
HTTPS? (for example, https://www.mycustomer.com/mytestfile.html)

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=subscribe&forumid=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

Custom tag crashes CF Server? Possible? Remedy?

[Michael Kear]

I am using Nate Weiss's CSVtoQuery custom tag to convert 17 .csv files to
queries to be inserted in a database every morning at 7am.   Our information
partner FTPs the files into our server every morning, and I then read them
into CF using the tag, then insert them into the MSSql7 database.

I set it up after testing on my staging server for a week or so, and loaded
the tag into the production server two weeks ago.  After I used the CF
administrator to register the tag, it worked as advertised and I was quite
happy with it.  Until last Friday.

At 3am Friday, our Sysadmin rebooted the server (for a reason totally
unrelated to CF) and immediately the CF server refused to work, and kept
showing a NT password challenge dialog box every time anyone tried to use a
cfm page.   When we renamed the csvtoquery.dll to something else, thereby
breaking the custom tag, the CF Server booted up ok again and is now working
fine (with the exception of this application of course)

Do you know of any problem with this query that might cause this behaviour?
And following from that, what we can do to fix it?

Our environment is:

NT4 SP6
CF5.0
SQLServer7

The problem is not apparently the actual execution of the tag, because the
NTserver rebooted at 3am, and the tag is only used in a scheduled task set
to run every morning at 7am.The CF Server stopped working immediately
the NTserver booted up.


Any ideas?

Cheers,
Mike Kear
Windsor, NSW, Australia
AFP WebWorks



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

RE: Date time Question (CF and SQL)

[Ciliotta, Mario]

Joe,

I tried the query and it worked but I have two quick questions:

1) is there anyway to get the time to show as 15:00 instead of 15:0
2) is there a way to get the AM/PM to Show

Sorry for the questions, but I have tried and failed to get it.

Here is my code:

SELECT Cast(LEFT(DateName(mm, Event_Start_Date), 3) 
AS varchar(3)) + ' ' + Cast(DatePart(dd, Event_Start_Date) 
AS varchar(2)) AS currDate, Cast(DatePart(hh, 
Event_Start_Date) AS varchar(2)) + ':' + Cast(DatePart(mi, 
Event_Start_Date) AS varchar(2)) AS currTime
FROM dbo.tbl_Diversity_Events


Thanks again,

Mario

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 18, 2002 12:41 PM
To: CF-Talk
Subject: Re: Date time Question (CF and SQL)


Mario..
Here is one way of doing this You substitute GetDate() with your dates.

select Cast(left(DateName(mm,GetDate()),3) as varchar(3))+' '+ 
   Cast(DatePart(dd,GetDate()) as varchar(2))+' '+ 
   Cast(DatePart(,GetDate()) as varchar(4)) as currDate,
   Cast(DatePart(hh,GetDate()) as varchar(2))+':'+ 
   Cast(DatePart(mi,GetDate()) as varchar(2))+':'+ 
   Cast(DatePart(ss,GetDate()) as varchar(2)) as currTime

Joe


On Mon, 18 Nov 2002 12:05:12 -0500 "Ciliotta, Mario" <[EMAIL PROTECTED]>
wrote:

> Hi All,
> 
> I have a questions, I am using Sql Server 7.0
> and I have field called Event_Start_DateTime
> and I would like my query to be able to return
> to me two fields
> the date and the time
> 
> ie 
> 
> The field contains:  12/12/2002 7:30:00AM
> 
> and I would like my query to return:
> 
> Dec 12  (Start Date)
> 7:30 PM (Start Time)
> 
> I know how to do it in CF, but I have many
> records returned and I would prefer to have my
> database do some of the work, instead of my
> cuff server doing all the work.
> 
> I believe that there are CAST and CONVERT
> functions but I cannot get it to work.
> 
> 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=subscribe&forumid=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

Quick "change address bar value" script anyone?

[Lee Fuller]

Just need a java script that will change the value of the "Address" bar.
Not the status bar.

Anyone have anything like that?

TTAIA

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

RE: Quick "change address bar value" script anyone?

[Tony Weeg]

hmmm besides an href'ed link in a html page?

..tony

Tony Weeg
Senior Web Developer
Information System Design
Navtrak, Inc.
Fleet Management Solutions
www.navtrak.net
410.548.2337 


-Original Message-
From: Lee Fuller [mailto:[EMAIL PROTECTED]] 
Sent: Monday, November 18, 2002 2:45 PM
To: CF-Talk
Subject: Quick "change address bar value" script anyone?


Just need a java script that will change the value of the "Address" bar.
Not the status bar.

Anyone have anything like that?

TTAIA


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

Re: Quick "change address bar value" script anyone?

[charlie griefer]

Lee Fuller writes: 

> Just need a java script that will change the value of the "Address" bar.
> Not the status bar. 
> 
> Anyone have anything like that?

Lee: 

The address bar is 'readonly'...the only way to replace a value in there 
would be to actually load a new page. 

This is actually a good thing...otherwise people could put up objectionable 
content and have the address bar show http://www.microsoft.com (ok, ok, bad 
example...but you get the idea) :) 

charlie 


> 
> TTAIA 
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

RE: [OT] Zip Code Lookup

[jon roig]

If you're using the JCSM database, here's a simple query to pull out all the
zips within #radius# number of miles.




SELECT  lat, lon, Zip, LastLineCity, State
FROM jcszip
WHERE Zip = '#zip#'





SELECT jcszip.Zip,
jcszip.LastLineCity,
jcszip.State,
jcszip.Lat,
jcszip.Lon
FROM jcszip
WHERE (((jcszip.lat)>= (#geoCode.Lat# - (#Radius# * 0.0005))
 And (jcszip.lat)<= (#geoCode.Lat# + (#Radius# * 0.0005))
) AND ((jcszip.lon)>= (#geoCode.Lon# - (#Radius# * 0.0005))
 And (jcszip.lon)<= (#geoCode.Lon# + (#Radius# * 0.0005))
))
ORDER BY jcszip.Zip


We purchased this fairly recently and we love it.

-- jon

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 15, 2002 5:04 PM
To: CF-Talk
Subject: Re: [OT] Zip Code Lookup


charlie griefer wrote:

> I'm building an application where i need to do the 'search within x
> miles of zip code 12345'
>
> Can anybody make a recommendation?  The client would like something
> that offers updates fairly regularly.  Maybe even some sort of XML
> feed direct from the (a) source?
>
> Any leads would be greatly appreciated.
>
> Oh, and would be nice if it integrated easily with CF (to kinda bring
> this question a little bit on topic) :)

Strategy and options depends quite a bit on the usage pattern and the
financial room. I will just presume it is for nearest outlet matching
for now.

If it is for the occasional lookup, I am sure there are webservices
where you can pay per hit. Easy and all the database maintenance is done
for you by the remote partner. But it might be a bit clumsy if you get
back a long list of ZIP codes that you then have to match against your
own database of outlets. And if you get a lot of hits, paying per hit
might not be the best model.

Another option would be to buy a ZIP database with subscriptions for
updates and a bunch of tags for running queries on them. But again, it
might be a bit clumsy if you want to match those results with another
database of outlets.

The last option is to buy the ZIP database and built your own search
system for it. It really isn't that hard to make the database do
distance calculations based on lat/lon pairs, and unless you have a very
special set of datapoints using a smart algorithm and some indexing will
make it very fast, especially since you can do the outlet matching in
the database as well.

I would probably go for option 3, unless there is a business reason for
doing number 1. Let me know if you want some code for option 3.

Jochem


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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.

RE: Quick "change address bar value" script anyone?

[Tony Weeg]

I really don't think there is a way to do that...someone a few months
back was asking on here, and to no avail did anyone come up an answer.

..tony

Tony Weeg
Senior Web Developer
Information System Design
Navtrak, Inc.
Fleet Management Solutions
www.navtrak.net
410.548.2337 


-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]] 
Sent: Monday, November 18, 2002 2:52 PM
To: CF-Talk
Subject: RE: Quick "change address bar value" script anyone?


hmmm besides an href'ed link in a html page?

.tony

Tony Weeg
Senior Web Developer
Information System Design
Navtrak, Inc.
Fleet Management Solutions
www.navtrak.net
410.548.2337 


-Original Message-
From: Lee Fuller [mailto:[EMAIL PROTECTED]] 
Sent: Monday, November 18, 2002 2:45 PM
To: CF-Talk
Subject: Quick "change address bar value" script anyone?


Just need a java script that will change the value of the "Address" bar.
Not the status bar.

Anyone have anything like that?

TTAIA



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

Re: Quick "change address bar value" script anyone?

[Jim Campbell]

You can't change the address bar with Javascript.  The closest thing I can
come up with (if you're worried about URL variables being exposed) is not to
use them, or run your web app in a Javascript-created window without an
address bar.

- Jim

- Original Message -
From: "Lee Fuller" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 18, 2002 1:44 PM
Subject: Quick "change address bar value" script anyone?


> Just need a java script that will change the value of the "Address" bar.
> Not the status bar.
>
> Anyone have anything like that?
>
> TTAIA
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Totally Freaked Out Browser Issues

[Joshua Miller]

Ok, this is driving me nuts.
 
Macintosh IE 5.2: Won't display CFGRAPH data for about 5 minutes, then
it finally displays ... but literally 5+ minutes later.
Macintosh Netscape 7.2: Displays "Document Contains No Data" popup.
 
Windows IE 6: Displays CFGRAPH data.
Windows Netscape 7.2: Displays "Document Contains No Data" popup.
 
When I view the exact same application on my local server, with all
variations above, the application works. When I go to the actual domain
and access the application, I get the above results.
 
Does anyone have any idea why Netscape would be returning "Document
Contains No Data" when the same application works fine under IE ??? I've
cleared the cache and that's not it ... it's just breaking with no
results and no explanation.
 
What I'm doing is testing to see if a SESSION variable is defined, if
it's not, then I'm using JavaScript to redirect the browser to another
page to login. Once logged in, I'm using JavaScript to forward the user
to the application. Once the user hits the application there's a CFGRAPH
displayed on a "dashboard". It only works for Windows IE 6 which is odd
because I built the whole #@*  &$ thing on a Macintosh
using IE and Mozilla to test. Now when I move it "live" it breaks on Mac
and Netscape.
 
Is there a better way to direct users around than with JavaScript
redirects? I tried METAs and they don't work ... same results.
 
Anyone have any clues?
 
Joshua Miller
[EMAIL PROTECTED]
 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

RE: DreamweaverMX Bug?

[Matt Brown]

At 02:19 PM 11/18/2002 -0500, you wrote:
>My experience was similar.  The most reproducible error I ran into was
>when we have JavaScript files saved with a cfm extension.  Perfectly
>valid thing to do but Dreamweaver didn't like it and really messed up
>our code very time we saved a file.  The problem occurred only when
>there was absolutely no CFM code in the template.  If we added some CFM
>code to it, then Dreamweaver stopped messing it up.

Sounds like a bug. DMX is looking for CF code and not finding it. I bet we 
didn't test for that. I am passing it to the QA team.

>There are a few known bugs that cause issues like this (although I'm not
>aware of the specific scenario you explained).  Yes, they are very
>disconcerting.  In my opinion, the mere fact that Dreamweaver mangles
>code internally (by design, not by error) and then expects to re-output
>the correct code in all cases when you save is far fetched.

DMX does not mangle code anytime by design, it is an error in every case. 
CL is working on it and passing some things to me. I try to look at this 
list when I can, but the signal to noise ration on DMX issues is high (lots 
of other stuff to talk about)

_

Matt Brown   Community Manager
Macromedia  (415) 706-6543   [EMAIL PROTECTED]
For daily Dreamweaver news and info: http://shorterlink.com/?KB8LAL



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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.

Re: Custom tag crashes CF Server? Possible? Remedy?

[samcfug]

sounds like directory permissions

=
Douglas White
group Manager
mailto:[EMAIL PROTECTED]
http://www.samcfug.org
=
- Original Message -
From: "Michael Kear" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 18, 2002 1:39 PM
Subject: Custom tag crashes CF Server? Possible? Remedy?


| I am using Nate Weiss's CSVtoQuery custom tag to convert
17 .csv files to
| queries to be inserted in a database every morning at 7am.
Our information
| partner FTPs the files into our server every morning, and
I then read them
| into CF using the tag, then insert them into the MSSql7
database.
|
| I set it up after testing on my staging server for a week
or so, and loaded
| the tag into the production server two weeks ago.  After I
used the CF
| administrator to register the tag, it worked as advertised
and I was quite
| happy with it.  Until last Friday.
|
| At 3am Friday, our Sysadmin rebooted the server (for a
reason totally
| unrelated to CF) and immediately the CF server refused to
work, and kept
| showing a NT password challenge dialog box every time
anyone tried to use a
| cfm page.   When we renamed the csvtoquery.dll to
something else, thereby
| breaking the custom tag, the CF Server booted up ok again
and is now working
| fine (with the exception of this application of course)
|
| Do you know of any problem with this query that might
cause this behaviour?
| And following from that, what we can do to fix it?
|
| Our environment is:
|
| NT4 SP6
| CF5.0
| SQLServer7
|
| The problem is not apparently the actual execution of the
tag, because the
| NTserver rebooted at 3am, and the tag is only used in a
scheduled task set
| to run every morning at 7am.The CF Server stopped
working immediately
| the NTserver booted up.
|
|
| Any ideas?
|
| Cheers,
| Mike Kear
| Windsor, NSW, Australia
| AFP WebWorks
|
|
|
|

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

RE: Quick "change address bar value" script anyone?

[Adrocknaphobia Jones]

Don't forget about frames.

Adam Wayne Lehman
Web Systems Developer
Johns Hopkins Bloomberg School of Public Health
Distance Education Division


-Original Message-
From: Jim Campbell [mailto:[EMAIL PROTECTED]] 
Sent: Monday, November 18, 2002 2:58 PM
To: CF-Talk
Subject: Re: Quick "change address bar value" script anyone?

You can't change the address bar with Javascript.  The closest thing I
can
come up with (if you're worried about URL variables being exposed) is
not to
use them, or run your web app in a Javascript-created window without an
address bar.

- Jim

- Original Message -
From: "Lee Fuller" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 18, 2002 1:44 PM
Subject: Quick "change address bar value" script anyone?


> Just need a java script that will change the value of the "Address"
bar.
> Not the status bar.
>
> Anyone have anything like that?
>
> TTAIA
>
> 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

Re: Quick "change address bar value" script anyone?

[Jim Campbell]

Ah, true true, s as well, if you're writing for an intranet or a
similar environment where you can guarantee later versions of IE/NS/Mozilla.

- Jim

- Original Message -
From: "Adrocknaphobia Jones" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 18, 2002 2:06 PM
Subject: RE: Quick "change address bar value" script anyone?


> Don't forget about frames.
>
> Adam Wayne Lehman
> Web Systems Developer
> Johns Hopkins Bloomberg School of Public Health
> Distance Education Division
>
>
> -Original Message-
> From: Jim Campbell [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 18, 2002 2:58 PM
> To: CF-Talk
> Subject: Re: Quick "change address bar value" script anyone?
>
> You can't change the address bar with Javascript.  The closest thing I
> can
> come up with (if you're worried about URL variables being exposed) is
> not to
> use them, or run your web app in a Javascript-created window without an
> address bar.
>
> - Jim
>
> - Original Message -
> From: "Lee Fuller" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, November 18, 2002 1:44 PM
> Subject: Quick "change address bar value" script anyone?
>
>
> > Just need a java script that will change the value of the "Address"
> bar.
> > Not the status bar.
> >
> > Anyone have anything like that?
> >
> > TTAIA
> >
> >
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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.

RE: Custom tag crashes CF Server? Possible? Remedy?

[Michael Kear]

Yes Douglas, sounded like it to me too.  We spent ages checking and
rechecking all the permissions of anywhere the CFServer went, and nothing
had changed.   When we renamed the csvtoquery.dll file to something else,
the CF Server worked ok again. (except for the app that uses the custom tag
of course).

That was without changing any permissions though. Does that tell us
there is a permissions problem or not?


Cheers,
Mike Kear
Windsor, NSW, Australia
AFP WebWorks


-Original Message-
From: samcfug [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 19 November 2002 7:07 AM
To: CF-Talk
Subject: Re: Custom tag crashes CF Server? Possible? Remedy?

sounds like directory permissions

=
Douglas White
group Manager
mailto:[EMAIL PROTECTED]
http://www.samcfug.org
=
- Original Message -
From: "Michael Kear" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 18, 2002 1:39 PM
Subject: Custom tag crashes CF Server? Possible? Remedy?


| I am using Nate Weiss's CSVtoQuery custom tag to convert
17 .csv files to
| queries to be inserted in a database every morning at 7am.
Our information
| partner FTPs the files into our server every morning, and
I then read them
| into CF using the tag, then insert them into the MSSql7
database.
|
| I set it up after testing on my staging server for a week
or so, and loaded
| the tag into the production server two weeks ago.  After I
used the CF
| administrator to register the tag, it worked as advertised
and I was quite
| happy with it.  Until last Friday.
|
| At 3am Friday, our Sysadmin rebooted the server (for a
reason totally
| unrelated to CF) and immediately the CF server refused to
work, and kept
| showing a NT password challenge dialog box every time
anyone tried to use a
| cfm page.   When we renamed the csvtoquery.dll to
something else, thereby
| breaking the custom tag, the CF Server booted up ok again
and is now working
| fine (with the exception of this application of course)
|
| Do you know of any problem with this query that might
cause this behaviour?
| And following from that, what we can do to fix it?
|
| Our environment is:
|
| NT4 SP6
| CF5.0
| SQLServer7
|
| The problem is not apparently the actual execution of the
tag, because the
| NTserver rebooted at 3am, and the tag is only used in a
scheduled task set
| to run every morning at 7am.The CF Server stopped
working immediately
| the NTserver booted up.
|
|
| Any ideas?
|
| Cheers,
| Mike Kear
| Windsor, NSW, Australia
| AFP WebWorks
|
|
|
|


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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

RE: Date time Question (CF and SQL)

[Joe Eugene]

Mario,
Here is a better solution but not very flexible though.. i think this is what
you are looking for...

select 'CurrentDate'=Left(GetDate(),11),'CurrentTime'=right(GetDate(),8)

DatePart doesnt allow to get "AM/PM" or i dont know of way to extract it..

Joe



On Mon, 18 Nov 2002 19:41:42 - "Ciliotta, Mario" <[EMAIL PROTECTED]>
wrote:

> Joe,
> 
> I tried the query and it worked but I have two
> quick questions:
> 
> 1) is there anyway to get the time to show as
> 15:00 instead of 15:0
> 2) is there a way to get the AM/PM to Show
> 
> Sorry for the questions, but I have tried and
> failed to get it.
> 
> Here is my code:
> 
> SELECT Cast(LEFT(DateName(mm,
> Event_Start_Date), 3) 
> AS varchar(3)) + ' ' + Cast(DatePart(dd,
> Event_Start_Date) 
> AS varchar(2)) AS currDate,
> Cast(DatePart(hh, 
> Event_Start_Date) AS varchar(2)) + ':' +
> Cast(DatePart(mi, 
> Event_Start_Date) AS varchar(2)) AS
> currTime
> FROM dbo.tbl_Diversity_Events
> 
> 
> Thanks again,
> 
> Mario
> 
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 18, 2002 12:41 PM
> To: CF-Talk
> Subject: Re: Date time Question (CF and SQL)
> 
> 
> Mario..
> Here is one way of doing this You
> substitute GetDate() with your dates.
> 
> select Cast(left(DateName(mm,GetDate()),3) as
> varchar(3))+' '+ 
>Cast(DatePart(dd,GetDate()) as
> varchar(2))+' '+ 
>Cast(DatePart(,GetDate()) as
> varchar(4)) as currDate,
>Cast(DatePart(hh,GetDate()) as
> varchar(2))+':'+ 
>Cast(DatePart(mi,GetDate()) as
> varchar(2))+':'+ 
>Cast(DatePart(ss,GetDate()) as
> varchar(2)) as currTime
> 
> Joe
> 
> 
> On Mon, 18 Nov 2002 12:05:12 -0500 "Ciliotta,
> Mario" 
> wrote:
> 
> > Hi All,
> > 
> > I have a questions, I am using Sql Server 7.0
> > and I have field called Event_Start_DateTime
> > and I would like my query to be able to
> return
> > to me two fields
> > the date and the time
> > 
> > ie 
> > 
> > The field contains:  12/12/2002 7:30:00AM
> > 
> > and I would like my query to return:
> > 
> > Dec 12  (Start Date)
> > 7:30 PM (Start Time)
> > 
> > I know how to do it in CF, but I have many
> > records returned and I would prefer to have
> my
> > database do some of the work, instead of my
> > cuff server doing all the work.
> > 
> > I believe that there are CAST and CONVERT
> > functions but I cannot get it to work.
> > 
> > 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=subscribe&forumid=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

RE: Quick "change address bar value" script anyone?

[Lee Fuller]

Yeah, I thought that may be the answer.  Hence nothing about it readily
available anywhere that I could find.

And it's really not for that.. It's for hiding bad pages when a 404
happens.  But that's ok.  It wasn't critical.  Just thought someone
might have the answer.

Thanks!

Lee


| -Original Message-
| From: Jim Campbell [mailto:[EMAIL PROTECTED]] 
| Sent: Monday, November 18, 2002 11:58 AM
| To: CF-Talk
| Subject: Re: Quick "change address bar value" script anyone?
| 
| 
| You can't change the address bar with Javascript.  The 
| closest thing I can come up with (if you're worried about URL 
| variables being exposed) is not to use them, or run your web 
| app in a Javascript-created window without an address bar.
| 
| - Jim
| 
| - Original Message -
| From: "Lee Fuller" <[EMAIL PROTECTED]>
| To: "CF-Talk" <[EMAIL PROTECTED]>
| Sent: Monday, November 18, 2002 1:44 PM
| Subject: Quick "change address bar value" script anyone?
| 
| 
| > Just need a java script that will change the value of the "Address" 
| > bar. Not the status bar.
| >
| > Anyone have anything like that?
| >
| > TTAIA
| >
| > 
| 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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.