Re: cfqueryparam oddity

[Tony Weeg]

i have the same problem, its new, never happened before, and is now
happening, same kind of code, almost exact actually.

but same problem.

what gives?

ps.  its works in s... (bla**st**) just fine, just not in cfmx 6.1

tw


On Wed, 3 Nov 2004 17:21:40 -0700, Charlie Griefer
<[EMAIL PROTECTED]> wrote:
> what's the exact datatype of the field in the database?
> 
> On Wed, 03 Nov 2004 15:31:59 -0800, Brook Davies
> 
> 
> <[EMAIL PROTECTED]> wrote:
> > Actually, I added the val function AFTER getting the error - it makes no
> > difference...
> >
> >
> >
> > At 03:09 PM 11/3/2004, you wrote:
> > >do you need the val() function?  is the value coming in as a string or
> > >numeric?
> > >
> > >what happens if you simply #val(arguments.case_id)#?
> > >
> > >
> > >On Wed, 03 Nov 2004 14:50:24 -0800, Brook Davies
> > ><[EMAIL PROTECTED]> wrote:
> > > > This query was working fine, with the arguments.case_id variable being
> > > > 30026 (and the function it is in is set to receive the case_id as numeric.
> > > > Bottom line is it IS numeric.
> > > >
> > > > 
> > > > select payment_mode from expense
> > > > where case_id =  > > > value="#val(arguments.case_id)#">
> > > > 
> > > >
> > > > Now all of a sudden I get this error unless I remove the  and
> > > > do it without. So its not a big deal, I'm just curious as to what the hecks
> > > > happening:
> > > >
> > > > "Error Executing Database Query.
> > > > [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested
> > > > type. "
> > > >
> > > > Is this a bug?
> > > >
> > > > Brook D.
> > > > logiforms.com
> > > >
> > > >
> > >
> > >
> >
> >
> 
> 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

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

Re: File size

[Barney Boisvert]

Here's two methods, one with pure CFML, and one using Java.  




#fileinfo.size#

#createObject("java",
"java.io.File").init(filename).length()#

cheers,
barneyb

On Thu, 4 Nov 2004 14:23:46 +1030, Parker, Kevin <[EMAIL PROTECTED]> wrote:
> Is it possible to determine the size of a file in CFML?
> 
> TIA!!
> 
> ++
> Kevin Parker
> Web Services Manager
> WorkCover Corporation
> 


-- 
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/blog/

I currently have 0 GMail invites for the taking

~|
Get the mailserver that powers this list at 
http://www.houseoffusion.com/banners/view.cfm?bannerid=17

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

Re: File size

[Qasim Rasheed]

I am not sure about cffile or cfdirectory, however using some native
Java classes, I am confident that you can get this information.



On Thu, 4 Nov 2004 14:23:46 +1030, Parker, Kevin <[EMAIL PROTECTED]> wrote:
> Is it possible to determine the size of a file in CFML?
> 
> TIA!!
> 
> ++
> Kevin Parker
> Web Services Manager
> WorkCover Corporation
> 
> p: 08 8233 2548
> m: 0418 806 166
> e: [EMAIL PROTECTED]
> w: www.workcover.com
> 
> ++
> 
> 
> This e-mail is intended for the use of the addressee only. It may
> contain information that is protected by legislated confidentiality
> and/or is legally privileged. If you are not the intended recipient you
> are prohibited from disseminating, distributing or copying this e-mail.
> 
> Any opinion expressed in this e-mail may not necessarily be that of the
> WorkCover Corporation of South Australia. Although precautions have
> been taken, the sender cannot warrant that this e-mail or any files
> transmitted with it are free of viruses or any other defect.
> 
> If you have received this e-mail in error, please notify the sender
> immediately by return e-mail and destroy the original e-mail and any
> copies.
> 
> 
> 

~|
The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in 
the Washington DC Area. 
http://www.houseoffusion.com/banners/view.cfm?bannerid=44

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

File size

[Parker, Kevin]

Is it possible to determine the size of a file in CFML?

TIA!!


++
Kevin Parker
Web Services Manager
WorkCover Corporation

p: 08 8233 2548
m: 0418 806 166
e: [EMAIL PROTECTED]
w: www.workcover.com

++


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

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

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


~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

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

Re: How to use Request scope?!

[Ian Sheridan]

o.param is a string that I get out of a CFPROCEDURE it's there and
avaiable. I have focused it down to the setting the request variable.

when I dump and abort the o.param it's there.

Ian


On Wed, 3 Nov 2004 17:02:11 -0800, Sean Corfield <[EMAIL PROTECTED]> wrote:
> On Wed, 3 Nov 2004 18:29:00 -0500, Ian Sheridan <[EMAIL PROTECTED]> wrote:
> > oh yeah it works I am getting the expected value in o.param.
> 
> Where is o.param set? You didn't show that in your cut-down code...
> 
> > > > 
> > > > 
> > > >
> > > > 
> > > > #request.actionpasser#
> > > >
> > > > 
> > > > 
> > > > 
> -- 
> Sean A Corfield -- http://www.corfield.org/
> Team Fusebox -- http://www.fusebox.org/
> Got Gmail? -- I have 1 invite
> 
> "If you're not annoying somebody, you're not really alive."
> -- Margaret Atwood
> 
> 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34

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

RE: How to use Request scope?!

[Ewok]

Either way, it had to be set or the error he would get would be PARAM not
defined in O.

-Original Message-
From: Sean Corfield [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, November 03, 2004 8:02 PM
To: CF-Talk
Subject: Re: How to use Request scope?!

On Wed, 3 Nov 2004 18:29:00 -0500, Ian Sheridan <[EMAIL PROTECTED]>
wrote:
> oh yeah it works I am getting the expected value in o.param.

Where is o.param set? You didn't show that in your cut-down code...

> > > 
> > > 
> > >
> > > 
> > > #request.actionpasser#
> > >
> > > 
> > > 
> > > 
-- 
Sean A Corfield -- http://www.corfield.org/
Team Fusebox -- http://www.fusebox.org/
Got Gmail? -- I have 1 invite

"If you're not annoying somebody, you're not really alive."
-- Margaret Atwood



~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34

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

Re: How to use Request scope?!

[Sean Corfield]

On Wed, 3 Nov 2004 18:29:00 -0500, Ian Sheridan <[EMAIL PROTECTED]> wrote:
> oh yeah it works I am getting the expected value in o.param.

Where is o.param set? You didn't show that in your cut-down code...

> > > 
> > > 
> > >
> > > 
> > > #request.actionpasser#
> > >
> > > 
> > > 
> > > 
-- 
Sean A Corfield -- http://www.corfield.org/
Team Fusebox -- http://www.fusebox.org/
Got Gmail? -- I have 1 invite

"If you're not annoying somebody, you're not really alive."
-- Margaret Atwood

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

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

Re: jrun.security.NTAuth question

[Greg Stewart]

I have only ever used it as an authentication method, i.e. rather than
checking against say a database I used this to authenticate the user
against the domain, if true set the appropriate session variables and
that was that. So to log out simply cleared the session.

You don't necessarily have to store anything in the session scope but
you could use this access method on a page by page basis as well if
there were sections of your site you wanted to exclusively protect.

Hope this helps.
G.



On Wed, 3 Nov 2004 10:05:34 -0600, Peterson, Andrew S.
<[EMAIL PROTECTED]> wrote:
> Hello,
> 
> If you log someone in using jrun.security.NTAuth, how do you log them
> out?
> Sincerely,
> 
> Andrew
> 
> 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36

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

Suite sale

[Michael Dinowitz]

OK, tonight the community suite is open till late so come on over. Tomorrow we open at 
9 and will be auctioning off a huge amout of cool books at 10. After that we're 
raffling off the xbox w/ games. (about 11 or so). If your in the area, come on over. 
If your not, we are allowing raffle tickets to be purchased over the net. 
1 for $1.50
4 for $5.00
We'll cover the shipping in the continental US and partially for outside the US.

Again, the room info is 
Hampton Inn and Suites
right across from the conference center (center E)
room 213

Food and drink are free for all so come and enjoy.

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34

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

Re: cfqueryparam oddity

[Charlie Griefer]

what's the exact datatype of the field in the database?  


On Wed, 03 Nov 2004 15:31:59 -0800, Brook Davies
<[EMAIL PROTECTED]> wrote:
> Actually, I added the val function AFTER getting the error - it makes no
> difference...
> 
> 
> 
> At 03:09 PM 11/3/2004, you wrote:
> >do you need the val() function?  is the value coming in as a string or
> >numeric?
> >
> >what happens if you simply #val(arguments.case_id)#?
> >
> >
> >On Wed, 03 Nov 2004 14:50:24 -0800, Brook Davies
> ><[EMAIL PROTECTED]> wrote:
> > > This query was working fine, with the arguments.case_id variable being
> > > 30026 (and the function it is in is set to receive the case_id as numeric.
> > > Bottom line is it IS numeric.
> > >
> > > 
> > > select payment_mode from expense
> > > where case_id =  > > value="#val(arguments.case_id)#">
> > > 
> > >
> > > Now all of a sudden I get this error unless I remove the  and
> > > do it without. So its not a big deal, I'm just curious as to what the hecks
> > > happening:
> > >
> > > "Error Executing Database Query.
> > > [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested
> > > type. "
> > >
> > > Is this a bug?
> > >
> > > Brook D.
> > > logiforms.com
> > >
> > >
> >
> >
> 
> 

~|
The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in 
the Washington DC Area. 
http://www.houseoffusion.com/banners/view.cfm?bannerid=44

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

Re: Update on CFMX daily server crashing with no log entries

[Brook Davies]

oops, I meant Sun's  j2re1.4.2_06

At 03:38 PM 11/3/2004, you wrote:
>After trying everything under the sun to figure out why our CFMX 6.1
>updater 1 server was crashing every day we decided to try a new JRE.
>We were previously using  JavaSoft 1.3.1_09 and changed to
>Java's  j2re1.4.2_06 and the server has been stable for over a week with
>memory usage MUCH better.
>
>I think originally we went to the JavaSoft JRE after some issues with
>CFHHTP and HTTPS but I can not remember exactly..
>
>You have no idea how happy I am that our server is finally stable omg
>... I can sleep through the night without getting paged!!
>
>Brook
>
>
>
>
>

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37

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

Update on CFMX daily server crashing with no log entries

[Brook Davies]

After trying everything under the sun to figure out why our CFMX 6.1 
updater 1 server was crashing every day we decided to try a new JRE.
We were previously using  JavaSoft 1.3.1_09 and changed to 
Java's  j2re1.4.2_06 and the server has been stable for over a week with 
memory usage MUCH better.

I think originally we went to the JavaSoft JRE after some issues with 
CFHHTP and HTTPS but I can not remember exactly..

You have no idea how happy I am that our server is finally stable omg 
... I can sleep through the night without getting paged!!

Brook




~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

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

Re: cfqueryparam oddity

[Brook Davies]

Actually, I added the val function AFTER getting the error - it makes no 
difference...

At 03:09 PM 11/3/2004, you wrote:
>do you need the val() function?  is the value coming in as a string or 
>numeric?
>
>what happens if you simply #val(arguments.case_id)#?
>
>
>On Wed, 03 Nov 2004 14:50:24 -0800, Brook Davies
><[EMAIL PROTECTED]> wrote:
> > This query was working fine, with the arguments.case_id variable being
> > 30026 (and the function it is in is set to receive the case_id as numeric.
> > Bottom line is it IS numeric.
> >
> > 
> > select payment_mode from expense
> > where case_id =  > value="#val(arguments.case_id)#">
> > 
> >
> > Now all of a sudden I get this error unless I remove the  and
> > do it without. So its not a big deal, I'm just curious as to what the hecks
> > happening:
> >
> > "Error Executing Database Query.
> > [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested
> > type. "
> >
> > Is this a bug?
> >
> > Brook D.
> > logiforms.com
> >
> >
>
>

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

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

Re: How to use Request scope?!

[Ian Sheridan]

oh yeah it works I am getting the expected value in o.param.


On Wed, 3 Nov 2004 15:15:46 -0800, Sean Corfield <[EMAIL PROTECTED]> wrote:
> Have you checked that o.param contains a valid value?
> 
> 
> 
> On Wed, 3 Nov 2004 14:18:49 -0500, Ian Sheridan <[EMAIL PROTECTED]> wrote:
> > I was getting the "actionpasser" not defined in the Request scope.
> >
> > This is basicly what I am doing:
> >
> > 
> > 
> >
> > 
> > #request.actionpasser#
> >
> > 
> > 
> > 

-- 

--
Ian Sheridan
http://www.savagevines.com
--

~|
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.houseoffusion.com/banners/view.cfm?bannerid=11

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

Re: How to use Request scope?!

[Sean Corfield]

Have you checked that o.param contains a valid value?

On Wed, 3 Nov 2004 14:18:49 -0500, Ian Sheridan <[EMAIL PROTECTED]> wrote:
> I was getting the "actionpasser" not defined in the Request scope.
> 
> This is basicly what I am doing:
> 
> 
> 
> 
> 
> #request.actionpasser#
> 
> 
> 
> 

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

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

Re: cfqueryparam oddity

[Charlie Griefer]

do you need the val() function?  is the value coming in as a string or numeric?

what happens if you simply #val(arguments.case_id)#?


On Wed, 03 Nov 2004 14:50:24 -0800, Brook Davies
<[EMAIL PROTECTED]> wrote:
> This query was working fine, with the arguments.case_id variable being
> 30026 (and the function it is in is set to receive the case_id as numeric.
> Bottom line is it IS numeric.
> 
> 
> select payment_mode from expense
> where case_id =  value="#val(arguments.case_id)#">
> 
> 
> Now all of a sudden I get this error unless I remove the  and
> do it without. So its not a big deal, I'm just curious as to what the hecks
> happening:
> 
> "Error Executing Database Query.
> [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested
> type. "
> 
> Is this a bug?
> 
> Brook D.
> logiforms.com
> 
> 

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

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

RE: Another data type question

[Ewok]

And in Access...

You'll have to run a query that selects the column you want first...



SELECT MyColumn From table


then...





-Original Message-
From: Mark Wimer [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, November 03, 2004 4:42 PM
To: CF-Talk
Subject: Re: Another data type question

Donna,
Here's an old code snippet from CF4/SQL7 days - may still work - if you're
using MSSQL. Just an example of how to get at datatypes.

Mark





 
 
  
  
 

 
 
  #Column_Name#
#Type_Name#
#Length#
#Nullable#
#Column_def#
  
 



 

  Donna French

  <[EMAIL PROTECTED]To:   CF-Talk
<[EMAIL PROTECTED]>  
  om>  cc:

   Subject:  Another data type
question   
  11/03/2004 03:06

  PM

  Please respond to

  cf-talk

 

 





Okay, so I've got a SELECT menu that allows the user to choose which
DB field they'd like to see results on, then a text box to allow them
to enter the appropriate data for the SELECT choice. Now I'm wondering
if I should add some sort of CFIF to show the appropriate SELECT for
the 2nd portion instead of the text box b/c I'm having problems with
it recognizing the datatype on my query to show results.

Or is there a way to detect which datatype within my query - possibly
CFIF datatype1 > use this code, etc. Some of the SELECT drop downs
are text in my db, some are checkboxes and some True/False.

Any insight or feedback would be greatly appreciated.

TIA,
Donna

--

Donna French
[EMAIL PROTECTED]

Blog: http://dgfrench.blogspot.com
Site: http://www.dgfrenchdesigns.com









~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

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

cfqueryparam oddity

[Brook Davies]

This query was working fine, with the arguments.case_id variable being 
30026 (and the function it is in is set to receive the case_id as numeric. 
Bottom line is it IS numeric.


select payment_mode from expense
where case_id = 



Now all of a sudden I get this error unless I remove the  and 
do it without. So its not a big deal, I'm just curious as to what the hecks 
happening:

"Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver]Value can not be converted to requested 
type. "


Is this a bug?

Brook D.
logiforms.com




~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

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

RE: How to use Request scope?!

[Ewok]

That’s pretty strange. I've never seen or heard of it happening before.
Everything seems right to me. What happens when you unscope it? Make it just
actionpasser instead of request.actionpasser.

This would work just the same as it SHOULD when scoped as request. Are you
having nay problems with the request scope anywhere else?

-Original Message-
From: Ian Sheridan [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, November 03, 2004 2:19 PM
To: CF-Talk
Subject: Re: How to use Request scope?!

I was getting the "actionpasser" not defined in the Request scope.

This is basicly what I am doing:





#request.actionpasser#







On Wed, 3 Nov 2004 14:08:51 -0500, Ewok <[EMAIL PROTECTED]> wrote:
> Same here... I set all my request variables in one file then include it
via
> Application.cfm. the request vars are available anywhere and everywhere
> throughout the entire application this way.
> 
> If you have these two files...
> 
> 
> 
> 
> 
> 
> #request.testvar#
> 
> Index.cfm should just display "request variable"
> 
> This SHOULD definitely work. If it's not, then there is something wrong
> somewhere else. Were you getting test not defined in request scope errors?
> Or any kind of error for that matter...
> 
> 
> 
> -Original Message-
> From: Ben Doom [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 03, 2004 1:26 PM
> To: CF-Talk
> Subject: Re: How to use Request scope?!
> 
> Except that I do exactly what you said didn't work all the time.  I
> routinely create request or variable scoped vars in one include to be
> used in another.  The includes are serial, not nested.
> 
> So I don't know what your original problem was, but I'd be careful to
> check and make sure that the value being used in the second include is
> actually what's being set in the first, not in the index.
> 
> --Ben
> 
> Ian Sheridan wrote:
> > Well let me be a little bit more descriptive.
> >
> > I have an "index.cfm" page that includes two files. I was then setting
> > the REQUEST variable *in* the first include. In the second include I
> > would then look for it. This did not work.
> >
> > I now set the REQUEST variable in the "index.cfm" file first. Then set
> > it in the first include and read it in the second include. This works.
> >
> > So I gather from this experience that request is *inherited* from the
> > parent document.
> >
> > Application.cfm
> > - index.cfm
> > -- include.cfm
> >
> > It only gets inherited. there is no creating it in a child include/file.
> >
> > Ian
> 
> 



~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

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

Re: Odd SQL Behaviour, errors generated by values I am not trying to use!

[Anders Green]

At 01:54 PM 11/3/2004, you wrote:
>James Smith wrote:
> > INSERT INTO barcodes (Barcode, ItemID) VALUES (0008811953928,17870)
> >
> > Could anyone tell me why the number 0004294967295 is causing an error
> > when the SQL statement doesn't even show it being used?
> 
>  Because it is 2^32. Instead of throwing an error MySQL just rounds
>  your value to the maximum that fits in the field.
> >>>
> >>> But the field is INT(13), why would a 13 digit number not fit?
> >>
> >> Because display padding has got nothing to do with physical
> >> storage: http://dev.mysql.com/doc/mysql/en/Numeric_types.html
> >
> > Bigint fixed it, thanks.  Any idea why the DB allows an INT(13)?

I would never imagine that INT(13) is a 13 digit number.

I would assume that INT(13) is a 13 BIT number. So it
would have a limit of 8192.

Why allow a INT(13)? So you can allow an INT(1). If you
have True/false, why not use just one bit for it?

Anders
+===+
|Anders Green Email: [EMAIL PROTECTED]   |
|  Home: 919.303.0218   |
|Off Road Rally Racing Team: http://LinaRacing.com/ |
+===+


~|
Protect your mail server with built in anti-virus protection. It's not only good for 
you, it's good for everybody.
http://www.houseoffusion.com/banners/view.cfm?bannerid=39

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

Re: inetinfo.exe Memory Leak After 6.1 Updater

[Sung Woo]

One thing I forgot to mention -- it only happens if you use SSL.  We use 128-bit SSL 
encryption for all our stuff.  So that might be the distinction...

I didn't extract it from the updater -- the Macromedia rep sent it to me.  He says it 
isn't the final solution, so once I have the real thing, I'll update you guys on it.

~|
Protect your mail server with built in anti-virus protection. It's not only good for 
you, it's good for everybody.
http://www.houseoffusion.com/banners/view.cfm?bannerid=39

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

Re: Another data type question

[Mark Wimer]

Donna,
Here's an old code snippet from CF4/SQL7 days - may still work - if you're
using MSSQL. Just an example of how to get at datatypes.

Mark





 
 
  
  
 

 
 
  #Column_Name#
#Type_Name#
#Length#
#Nullable#
#Column_def#
  
 



   
   
  Donna French 
   
  <[EMAIL PROTECTED]To:   CF-Talk <[EMAIL PROTECTED]>  

  om>  cc: 
   
   Subject:  Another data type question
   
  11/03/2004 03:06 
   
  PM   
   
  Please respond to
   
  cf-talk  
   
   
   
   
   




Okay, so I've got a SELECT menu that allows the user to choose which
DB field they'd like to see results on, then a text box to allow them
to enter the appropriate data for the SELECT choice. Now I'm wondering
if I should add some sort of CFIF to show the appropriate SELECT for
the 2nd portion instead of the text box b/c I'm having problems with
it recognizing the datatype on my query to show results.

Or is there a way to detect which datatype within my query - possibly
CFIF datatype1 > use this code, etc. Some of the SELECT drop downs
are text in my db, some are checkboxes and some True/False.

Any insight or feedback would be greatly appreciated.

TIA,
Donna

--

Donna French
[EMAIL PROTECTED]

Blog: http://dgfrench.blogspot.com
Site: http://www.dgfrenchdesigns.com







~|
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.houseoffusion.com/banners/view.cfm?bannerid=11

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

Re: inetinfo.exe Memory Leak After 6.1 Updater

[Brook Davies]

I wonder why this would only be happening to some people (myself 
included).  How did you extract the jrun.dll from the Updater 4?

Brook

At 10:38 AM 11/3/2004, you wrote:
>FYI, after many tests, we have isolated the problem as a memory leak in 
>jrun.dll.  I've replaced the current jrun.dll with the one in JRun 4 
>Updater 4 (build 84683), and it has brought down the memory usage, which, 
>mind you, was going over 250MB easy a day, to a measly 19MB.
>
>It's a workaround, though; they'll be sending me a properly-patched 
>connector soon.  But for those suffering from this issue right now (and it 
>is a burden), you might want to give this a shot.
>
>

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

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

Another data type question

[Donna French]

Okay, so I've got a SELECT menu that allows the user to choose which
DB field they'd like to see results on, then a text box to allow them
to enter the appropriate data for the SELECT choice. Now I'm wondering
if I should add some sort of CFIF to show the appropriate SELECT for
the 2nd portion instead of the text box b/c I'm having problems with
it recognizing the datatype on my query to show results.

Or is there a way to detect which datatype within my query - possibly
CFIF datatype1 > use this code, etc. Some of the SELECT drop downs
are text in my db, some are checkboxes and some True/False.

Any insight or feedback would be greatly appreciated.

TIA,
Donna

-- 

Donna French
[EMAIL PROTECTED]

Blog: http://dgfrench.blogspot.com
Site: http://www.dgfrenchdesigns.com

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

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

Re: inetinfo.exe Memory Leak After 6.1 Updater

[Sung Woo]

FYI, after many tests, we have isolated the problem as a memory leak in jrun.dll.  
I've replaced the current jrun.dll with the one in JRun 4 Updater 4 (build 84683), and 
it has brought down the memory usage, which, mind you, was going over 250MB easy a 
day, to a measly 19MB.

It's a workaround, though; they'll be sending me a properly-patched connector soon.  
But for those suffering from this issue right now (and it is a burden), you might want 
to give this a shot.

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

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

Re: How to use Request scope?!

[Ian Sheridan]

I was getting the "actionpasser" not defined in the Request scope.

This is basicly what I am doing:





#request.actionpasser#







On Wed, 3 Nov 2004 14:08:51 -0500, Ewok <[EMAIL PROTECTED]> wrote:
> Same here... I set all my request variables in one file then include it via
> Application.cfm. the request vars are available anywhere and everywhere
> throughout the entire application this way.
> 
> If you have these two files...
> 
> 
> 
> 
> 
> 
> #request.testvar#
> 
> Index.cfm should just display "request variable"
> 
> This SHOULD definitely work. If it's not, then there is something wrong
> somewhere else. Were you getting test not defined in request scope errors?
> Or any kind of error for that matter...
> 
> 
> 
> -Original Message-
> From: Ben Doom [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 03, 2004 1:26 PM
> To: CF-Talk
> Subject: Re: How to use Request scope?!
> 
> Except that I do exactly what you said didn't work all the time.  I
> routinely create request or variable scoped vars in one include to be
> used in another.  The includes are serial, not nested.
> 
> So I don't know what your original problem was, but I'd be careful to
> check and make sure that the value being used in the second include is
> actually what's being set in the first, not in the index.
> 
> --Ben
> 
> Ian Sheridan wrote:
> > Well let me be a little bit more descriptive.
> >
> > I have an "index.cfm" page that includes two files. I was then setting
> > the REQUEST variable *in* the first include. In the second include I
> > would then look for it. This did not work.
> >
> > I now set the REQUEST variable in the "index.cfm" file first. Then set
> > it in the first include and read it in the second include. This works.
> >
> > So I gather from this experience that request is *inherited* from the
> > parent document.
> >
> > Application.cfm
> > - index.cfm
> > -- include.cfm
> >
> > It only gets inherited. there is no creating it in a child include/file.
> >
> > Ian
> 
> 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

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

Re: Can someone Explain this Error Message

[Graham Pearson]

The File when generated is approx 2 Meg in size. What have I done is 
learned the RTF File Format and is 60 Pages long.

At 07:23 AM 11/3/2004, you wrote:
>On Wednesday 03 Nov 2004 12:04 pm, Graham Pearson wrote:
> > Branch target offset too large for short
>
>Is the file very large ?
>Can you test it with a less evil path  ?
>
>--
>Tom Chiverton
>Advanced ColdFusion Programmer
>Tel: +44 (0)1749 834900
>email: [EMAIL PROTECTED]
>BlueFinger Limited
>Underwood Business Park
>Wookey Hole Road, WELLS. BA5 1AF
>Tel: +44 (0)1749 834900
>Fax: +44 (0)1749 834XXX
>web: www.bluefinger.com
>Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay,
>BRISTOL. BS1 6EG
>*** This E-mail contains confidential information for the addressee only. If
>you are not the intended recipient,
>please notify us immediately. You should not use, disclose, distribute or 
>copy
>this communication if received
>in error. No binding contract will result from this e-mail until such time as
>a written document is signed on
>behalf of the company. BlueFinger Limited cannot accept responsibility for 
>the
>completeness or accuracy of
>this message as it has been transmitted over public networks.***
>
>

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37

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

RE: getting CF version, other details

[Ray Champagne]

Cool - thanks.

Ray

At 02:10 PM 11/3/2004, you wrote:
>Try dumping the server variables
>
>
>
>Should get you everything you need to know about the server
>
>-Original Message-
>From: Ray Champagne [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, November 03, 2004 1:35 PM
>To: CF-Talk
>Subject: getting CF version, other details
>
>Isn't there a script that one can run to find this out when you don't have
>access to the administrator?
>
>I know that you can do this in other languages, but not sure for CF.
>
>I am working on a potential client, and would like to find this stuff out
>without having to ask.
>
>Ray
>
>=
>Ray Champagne - Senior Application Developer
>CrystalVision Web Site Design and Internet Services
>603.433.9559
>www.crystalvision.org
>=
>
>The information contained in this transmission (including any attached
>files) is CONFIDENTIAL and is intended only for the person(s) named
>above. If you received this transmission in error, please delete it
>from your system and notify us immediately. If you are not an intended
>recipient, please note that any use or dissemination of the information
>contained in this transmission (including any attached files) and the
>copying, printing, or retransmission of that information is strictly
>prohibited. You can notify us by return email or by phone at 603.433.9559.
>Thank you.
>
>
>
>
>
>

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

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

Re: How to use Request scope?!

[Ben Doom]

It shouldn't matter what version.  Request variables worked the way 
documented in 5, I know from experience.  They should work in 6.0 just fine.

But that raises the question of why you're running 6.0 instead of 6.1 
with updaters.  Is there are reason?  If not, you should definately 
update -- there are a number of security and performance fixes.

--Ben

Ian Sheridan wrote:
> Oh it is passing the right info but maybe it's because I am doing this
> on a 6.0 machine
> 
> Ian
> 
> On Wed, 03 Nov 2004 13:25:35 -0500, Ben Doom <[EMAIL PROTECTED]> wrote:
> 
>>Except that I do exactly what you said didn't work all the time.  I
>>routinely create request or variable scoped vars in one include to be
>>used in another.  The includes are serial, not nested.
>>
>>So I don't know what your original problem was, but I'd be careful to
>>check and make sure that the value being used in the second include is
>>actually what's being set in the first, not in the index.
>>
>>--Ben


~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34

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

RE: getting CF version, other details

[Ewok]

Try dumping the server variables



Should get you everything you need to know about the server

-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, November 03, 2004 1:35 PM
To: CF-Talk
Subject: getting CF version, other details

Isn't there a script that one can run to find this out when you don't have 
access to the administrator?

I know that you can do this in other languages, but not sure for CF.

I am working on a potential client, and would like to find this stuff out 
without having to ask.

Ray

=
Ray Champagne - Senior Application Developer
CrystalVision Web Site Design and Internet Services
603.433.9559
www.crystalvision.org
=

The information contained in this transmission (including any attached
files) is CONFIDENTIAL and is intended only for the person(s) named
above. If you received this transmission in error, please delete it
from your system and notify us immediately. If you are not an intended
recipient, please note that any use or dissemination of the information
contained in this transmission (including any attached files) and the
copying, printing, or retransmission of that information is strictly
prohibited. You can notify us by return email or by phone at 603.433.9559.
Thank you.





~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

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

RE: How to use Request scope?!

[Ewok]

Same here... I set all my request variables in one file then include it via
Application.cfm. the request vars are available anywhere and everywhere
throughout the entire application this way.

If you have these two files...






#request.testvar#


Index.cfm should just display "request variable"

This SHOULD definitely work. If it's not, then there is something wrong
somewhere else. Were you getting test not defined in request scope errors?
Or any kind of error for that matter...

-Original Message-
From: Ben Doom [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, November 03, 2004 1:26 PM
To: CF-Talk
Subject: Re: How to use Request scope?!

Except that I do exactly what you said didn't work all the time.  I 
routinely create request or variable scoped vars in one include to be 
used in another.  The includes are serial, not nested.

So I don't know what your original problem was, but I'd be careful to 
check and make sure that the value being used in the second include is 
actually what's being set in the first, not in the index.

--Ben

Ian Sheridan wrote:
> Well let me be a little bit more descriptive. 
> 
> I have an "index.cfm" page that includes two files. I was then setting
> the REQUEST variable *in* the first include. In the second include I
> would then look for it. This did not work.
> 
> I now set the REQUEST variable in the "index.cfm" file first. Then set
> it in the first include and read it in the second include. This works.
> 
> So I gather from this experience that request is *inherited* from the
> parent document.
> 
> Application.cfm
> - index.cfm
> -- include.cfm
> 
> It only gets inherited. there is no creating it in a child include/file.
> 
> Ian




~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37

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

Re: Problem with Access driver and Windows 2003 Server

[Jake .]

Does not verify in CF Admin under the Access or Access w/Unicode drivers. SQL Server 
DSNs seem to be working fine.

As far as the ports, yes, everything is open that should be open.

Thanks,
Jake

>On Wednesday 03 Nov 2004 16:02 pm, Jake wrote:
>> And when you hit the sites that they are running, I get the following
>> error:
>>   Error Executing Database Query.
>> coldfusion.sql.DatabaseConnectionException: Timed out trying to
>> establish connection
>
>Does it verify in the administrator ?
>Are the relavent ports open in the FireWall ?
>
>-- 
>Tom Chiverton 
>Advanced ColdFusion Programmer
>Tel: +44 (0)1749 834900
>email: [EMAIL PROTECTED]
>BlueFinger Limited
>Underwood Business Park
>Wookey Hole Road, WELLS. BA5 1AF
>Tel: +44 (0)1749 834900
>Fax: +44 (0)1749 834XXX
>web: www.bluefinger.com
>Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, 
>BRISTOL. BS1 6EG
>*** This E-mail contains confidential information for the addressee only. If 
>you are not the intended recipient,
>please notify us immediately. You should not use, disclose, distribute or copy 
>this communication if received
>in error. No binding contract will result from this e-mail until such time as 
>a written document is signed on
>behalf of the company. BlueFinger Limited cannot accept responsibility for the 
>completeness or accuracy of
>this message as it has been transmitted over public networks.***

~|
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.houseoffusion.com/banners/view.cfm?bannerid=11

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

Re: Odd SQL Behaviour, errors generated by values I am not trying to use!

[Jochem van Dieten]

James Smith wrote:
> INSERT INTO barcodes (Barcode, ItemID) VALUES (0008811953928,17870)
> 
> Could anyone tell me why the number 0004294967295 is causing an error
> when the SQL statement doesn't even show it being used?
 
 Because it is 2^32. Instead of throwing an error MySQL just rounds 
 your value to the maximum that fits in the field.
>>> 
>>> But the field is INT(13), why would a 13 digit number not fit?
>> 
>> Because display padding has got nothing to do with physical
>> storage: http://dev.mysql.com/doc/mysql/en/Numeric_types.html
> 
> Bigint fixed it, thanks.  Any idea why the DB allows an INT(13)?

I have no idea why MySQL does things the way it does. I can rant 
a long time about why what MySQL is doing is wrong :-)

You might want to read http://sql-info.de/mysql/gotchas.html

Jochem

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

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

Re: getting CF version, other details

[Charlie Griefer]

if the cfdump doesn't work, you're pre-CF 5 :)


On Wed, 03 Nov 2004 13:34:37 -0500, Ray Champagne <[EMAIL PROTECTED]> wrote:
> Isn't there a script that one can run to find this out when you don't have
> access to the administrator?
> 
> I know that you can do this in other languages, but not sure for CF.
> 
> I am working on a potential client, and would like to find this stuff out
> without having to ask.
> 
> Ray
> 
> =
> Ray Champagne - Senior Application Developer
> CrystalVision Web Site Design and Internet Services
> 603.433.9559
> www.crystalvision.org
> =
> 
> The information contained in this transmission (including any attached
> files) is CONFIDENTIAL and is intended only for the person(s) named
> above. If you received this transmission in error, please delete it
> from your system and notify us immediately. If you are not an intended
> recipient, please note that any use or dissemination of the information
> contained in this transmission (including any attached files) and the
> copying, printing, or retransmission of that information is strictly
> prohibited. You can notify us by return email or by phone at 603.433.9559.
> Thank you.
> 
> 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

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

RE: Online Presentations

[Dave Watts]

> Looking for LIVE demonstrations

Macromedia Breeze Live is very, very good for this. I think MM just
introduced a pay-per-use option for hosted Breeze.

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


~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

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

RE: cfexecute problems

[Dave Watts]

> I am having trouble running a Visual FoxPro Executable via CFEXECUTE to
> do some DBF maniupations on the Server -- the EXE is loaded as a service
> and then is not released upon execution timeout as specified in the
> CFEXECUTE statement (20 seconds) -- I included reference to an
> "outputfile" but no output is actually generated by the program so the
> file generated is empty.  
>
> JasonOU reported to Macromedia that he fixed the problem by running 
> "dcomcnfg". He then went to the "Default Security" tab, clicked on "Edit
> Default" under "Access Permissions", and added the account which the IIS
> service uses to execute anonymously (this is generally
> IUSR_machinename).
>
> Since I am running XP Home (without IIS), I am using CF's Internal
> equivalent of IIS and am wondering what fix works that may be similar to
> the one suggested by JasonOU to get the EXE released. 

You might be able to fix this using DCOMCNFG. Within that, you can allow
access to the security principle running CF (SYSTEM by default).

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


~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

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

Re: How to use Request scope?!

[Ian Sheridan]

Oh it is passing the right info but maybe it's because I am doing this
on a 6.0 machine

Ian

On Wed, 03 Nov 2004 13:25:35 -0500, Ben Doom <[EMAIL PROTECTED]> wrote:
> Except that I do exactly what you said didn't work all the time.  I
> routinely create request or variable scoped vars in one include to be
> used in another.  The includes are serial, not nested.
> 
> So I don't know what your original problem was, but I'd be careful to
> check and make sure that the value being used in the second include is
> actually what's being set in the first, not in the index.
> 
> --Ben
> 
> 
> 
> Ian Sheridan wrote:
> > Well let me be a little bit more descriptive.
> >
> > I have an "index.cfm" page that includes two files. I was then setting
> > the REQUEST variable *in* the first include. In the second include I
> > would then look for it. This did not work.
> >
> > I now set the REQUEST variable in the "index.cfm" file first. Then set
> > it in the first include and read it in the second include. This works.
> >
> > So I gather from this experience that request is *inherited* from the
> > parent document.
> >
> > Application.cfm
> > - index.cfm
> > -- include.cfm
> >
> > It only gets inherited. there is no creating it in a child include/file.
> >
> > Ian
> 
> 
> 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

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

getting CF version, other details

[Ray Champagne]

Isn't there a script that one can run to find this out when you don't have 
access to the administrator?

I know that you can do this in other languages, but not sure for CF.

I am working on a potential client, and would like to find this stuff out 
without having to ask.

Ray

=
Ray Champagne - Senior Application Developer
CrystalVision Web Site Design and Internet Services
603.433.9559
www.crystalvision.org
=

The information contained in this transmission (including any attached
files) is CONFIDENTIAL and is intended only for the person(s) named
above. If you received this transmission in error, please delete it
from your system and notify us immediately. If you are not an intended
recipient, please note that any use or dissemination of the information
contained in this transmission (including any attached files) and the
copying, printing, or retransmission of that information is strictly
prohibited. You can notify us by return email or by phone at 603.433.9559.
Thank you.



~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

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

Re: How to use Request scope?!

[Adam Haskell]

A request scope can be set anywere and is available anywhere during a
request. However its bad coding practice to use it in CFCs and what
not but as far as I can tell it can be done.

Adam 


On Wed, 03 Nov 2004 13:25:35 -0500, Ben Doom <[EMAIL PROTECTED]> wrote:
> Except that I do exactly what you said didn't work all the time.  I
> routinely create request or variable scoped vars in one include to be
> used in another.  The includes are serial, not nested.
> 
> So I don't know what your original problem was, but I'd be careful to
> check and make sure that the value being used in the second include is
> actually what's being set in the first, not in the index.
> 
> --Ben
> 
> 
> 
> Ian Sheridan wrote:
> > Well let me be a little bit more descriptive.
> >
> > I have an "index.cfm" page that includes two files. I was then setting
> > the REQUEST variable *in* the first include. In the second include I
> > would then look for it. This did not work.
> >
> > I now set the REQUEST variable in the "index.cfm" file first. Then set
> > it in the first include and read it in the second include. This works.
> >
> > So I gather from this experience that request is *inherited* from the
> > parent document.
> >
> > Application.cfm
> > - index.cfm
> > -- include.cfm
> >
> > It only gets inherited. there is no creating it in a child include/file.
> >
> > Ian
> 
> 
> 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

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

Re: How to use Request scope?!

[Ben Doom]

Except that I do exactly what you said didn't work all the time.  I 
routinely create request or variable scoped vars in one include to be 
used in another.  The includes are serial, not nested.

So I don't know what your original problem was, but I'd be careful to 
check and make sure that the value being used in the second include is 
actually what's being set in the first, not in the index.

--Ben

Ian Sheridan wrote:
> Well let me be a little bit more descriptive. 
> 
> I have an "index.cfm" page that includes two files. I was then setting
> the REQUEST variable *in* the first include. In the second include I
> would then look for it. This did not work.
> 
> I now set the REQUEST variable in the "index.cfm" file first. Then set
> it in the first include and read it in the second include. This works.
> 
> So I gather from this experience that request is *inherited* from the
> parent document.
> 
> Application.cfm
> - index.cfm
> -- include.cfm
> 
> It only gets inherited. there is no creating it in a child include/file.
> 
> Ian


~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

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

OT: XML Spy error when going to Schema view on XML file

[Damien McKenna]

I'm attempting to go into Schema view in XML Spy Home 2005 on the 
enclosed XML file when it gives the error "Unable to show schema.  
Schema has to begin with a schema-element!".  Anyone have any ideas what 
I'm missing in my files?  Thanks.
-- 
*Damien McKenna* - Web Developer - [EMAIL PROTECTED] 

The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
"Why are you wearing that stupid man suit?" - Frank

TLCircle.xml:


http://www.w3.org/2001/XMLSchema-instance"; 
xsi:noNamespaceSchemaLocation="TLCircle.xsd">

Joe Blogs
Texas




TLCircle.xsd:




http://www.w3.org/2001/XMLSchema"; 
elementFormDefault="qualified">































~|
Get the mailserver that powers this list at 
http://www.houseoffusion.com/banners/view.cfm?bannerid=17

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

RE: OT: How do I print out a directory listing in XP

[Tangorre, Michael]

> http://www.rohanclan.com/library/printdirlist.cfm

Very Cool!

~|
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.houseoffusion.com/banners/view.cfm?bannerid=11

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

Re: How to use Request scope?!

[Ian Sheridan]

Well let me be a little bit more descriptive. 

I have an "index.cfm" page that includes two files. I was then setting
the REQUEST variable *in* the first include. In the second include I
would then look for it. This did not work.

I now set the REQUEST variable in the "index.cfm" file first. Then set
it in the first include and read it in the second include. This works.

So I gather from this experience that request is *inherited* from the
parent document.

Application.cfm
- index.cfm
-- include.cfm

It only gets inherited. there is no creating it in a child include/file.

Ian


On Wed, 03 Nov 2004 13:05:25 -0500, Ben Doom <[EMAIL PROTECTED]> wrote:
> It sounds like it wasn't always being set in the first include.
> 
> Regardless of what file a request variable is set in, it is available to
> all subsequent code.  I may be off a bit with regard to CFCs, but that's
> how I understand it.
> 
> --Ben
> 
> 
> 
> Ian Sheridan wrote:
> > well that's the thing I am setting it in include not the index.cfm file.
> >
> > so I created it in the index.cfm file NOT the included file and it now works.
> >
> > Ian
> >
> >>Sure, as long as you set it before you call it of course
> >>
> >>-Original Message-
> >>
> >>can you set a request scope variable in an include?
> >>
> >>ex.
> >>-index.cfm
> >>--include1.cfm --> set request.test
> >>--include2.cfm --> read request.test
> >>
> >>can this be done?
> 
> 
> 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

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

RE: Bluedragon Server

[Vince Bonfanti]

From: Ryan Jones wrote:
> 
> With PHP I am basicly open and free to code and make the 
> language do just about anything I want it to.  With cfml, I 
> could find myself at a place where I need to call on java.  
> However, if I understand correctly, the free version of 
> Bluedragon does not support calls to java nor the parsing of jsp code.
> 
> I may be wrong...?
> 

The free version of BlueDragon does not support JSP, but does support calls
to Java via CFOBJECT/CreateObject(). So you can either call the built-in
Java APIs or Java classes that your write yourself. The free version of
BlueDragon also support Java and C++ CFX tags.

Vince Bonfanti
New Atlanta Communications, LLC
http://www.newatlanta.com



~|
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.houseoffusion.com/banners/view.cfm?bannerid=11

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

RE: OT: How do I print out a directory listing in XP

[Andy Ousterhout]

Thanks.  Exactly what I needed.

-Original Message-
From: Rob [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 03, 2004 11:39 AM
To: CF-Talk
Subject: Re: OT: How do I print out a directory listing in XP


http://www.rohanclan.com/library/printdirlist.cfm


On Wed, 3 Nov 2004 11:18:56 -0600, Andy Ousterhout <[EMAIL PROTECTED]>
wrote:
> I need to print out a directory listing for a disk I am sending to a
printer.
> Can someone tell me how to do this?
>
> Thanks,
> Andy
>
>



~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37

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

Re: How to use Request scope?!

[Ben Doom]

It sounds like it wasn't always being set in the first include.

Regardless of what file a request variable is set in, it is available to 
all subsequent code.  I may be off a bit with regard to CFCs, but that's 
how I understand it.

--Ben

Ian Sheridan wrote:
> well that's the thing I am setting it in include not the index.cfm file.
> 
> so I created it in the index.cfm file NOT the included file and it now works.
> 
> Ian
> 
>>Sure, as long as you set it before you call it of course
>>
>>-Original Message-
>>
>>can you set a request scope variable in an include?
>>
>>ex.
>>-index.cfm
>>--include1.cfm --> set request.test
>>--include2.cfm --> read request.test
>>
>>can this be done?


~|
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.houseoffusion.com/banners/view.cfm?bannerid=11

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

Re: How to use Request scope?!

[Ian Sheridan]

well that's the thing I am setting it in include not the index.cfm file.

so I created it in the index.cfm file NOT the included file and it now works.

Ian

On Wed, 3 Nov 2004 12:41:26 -0500, Ewok <[EMAIL PROTECTED]> wrote:
> Sure, as long as you set it before you call it of course
> 
> 
> 
> -Original Message-
> From: Ian Sheridan [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 03, 2004 12:38 PM
> To: CF-Talk
> Subject: How to use Request scope?!
> 
> can you set a request scope variable in an include?
> 
> ex.
> -index.cfm
> --include1.cfm --> set request.test
> --include2.cfm --> read request.test
> 
> can this be done?
> 
> --
> 
> --
> Ian Sheridan
> http://www.savagevines.com
> 
> 
> 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36

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

Re: Session vars stored in database?

[Barney Boisvert]

You can do sticky sessions in a cluster, but that means that a given
session always ends up on the same server, not than the session data
is shared across the cluster to whatever machine needs it.  That's
done with the load balancing hardware/software.  Still RAM-only
session vars, becuase they're never needed on multiple servers in the
cluster.

If you're using J2EE sessions, you can do session replication across
the cluster as well, but that's still RAM-only.  The servers just
broadcast the data direct to the other servers, not going through an
external store (a DB), as I understand it.  Never seen it in action,
so I don't know for sure.

cheers,
barneyb


On Wed, 3 Nov 2004 08:36:37 -0800, Matt Robertson
<[EMAIL PROTECTED]> wrote:
> What Barney said is dead-on.  I am a total zero on clusters, but isn't
> there a way -- outside of CF -- to handle sessions so they remain
> sticky despite the application?  i.e. an external application of some
> sort.  Would that be db-related?
> 
> Systems guys at that level usually aren't so ignorant so I'm wondering
> if he is taking something non-CF into account.
> 
> And even there was such a thing in play, I can't see how proper
> locking practices would be mitigated in any meaningful way.
> 
> --
> --Matt Robertson--
> President, Janitor
> MSB Designs, Inc.
> mysecretbase.com
> 
-- 
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/blog/

I currently have 0 GMail invites for the taking

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

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

Re: cfencode problems

[Stan Winchester]

>> c:\cfusionmx\bin\cfencode f:\websites\[path]\*.cfm f:\websites\[path]\*.cfm /r
>
>Path too long, or contains funny chars ?
>
The path uses no spaces or funny chars, just alpha characters. It worked before, but 
does not now, which is strange. I've even logged on as administrator and it still does 
not work (this is on a Windows 2003 server installation).

~|
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.houseoffusion.com/banners/view.cfm?bannerid=11

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

Re: Session vars stored in database?

[Phil Cruz]

He could be talking about a custom session management scheme.  I have used rsession 
(http://vfive.com/rsession/index.html)in previous (CF5) projects in order to avoid 
having to lock session vars and to support non-sticky sessions in clusters. 

-Phil

>What Barney said is dead-on.  I am a total zero on clusters, but isn't
>there a way -- outside of CF -- to handle sessions so they remain
>sticky despite the application?  i.e. an external application of some
>sort.  Would that be db-related?
>
>Systems guys at that level usually aren't so ignorant so I'm wondering
>if he is taking something non-CF into account.
>
>And even there was such a thing in play, I can't see how proper
>locking practices would be mitigated in any meaningful way.
>
>-- 
>--Matt Robertson--
>President, Janitor
>MSB Designs, Inc.
>mysecretbase.com

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37

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

RE: How do I print out a directory listing in XP

[Ewok]

dir /og > dirlist.txt

-Original Message-
From: Andy Ousterhout [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, November 03, 2004 12:19 PM
To: CF-Talk
Subject: OT: How do I print out a directory listing in XP

I need to print out a directory listing for a disk I am sending to a
printer.
Can someone tell me how to do this?

Thanks,
Andy






~|
Get the mailserver that powers this list at 
http://www.houseoffusion.com/banners/view.cfm?bannerid=17

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

RE: How do I print out a directory listing in XP

[Adkins, Randy]

You can redirect the listing to a text file

C:\DIR C:\MYDIRECTORY > listing.txt

then print the text file 

-Original Message-
From: Andy Ousterhout [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, November 03, 2004 12:19 PM
To: CF-Talk
Subject: OT: How do I print out a directory listing in XP

I need to print out a directory listing for a disk I am sending to a
printer.
Can someone tell me how to do this?

Thanks,
Andy






~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

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

RE: How to use Request scope?!

[Ewok]

Sure, as long as you set it before you call it of course

-Original Message-
From: Ian Sheridan [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, November 03, 2004 12:38 PM
To: CF-Talk
Subject: How to use Request scope?!

can you set a request scope variable in an include?

ex.
-index.cfm
--include1.cfm --> set request.test
--include2.cfm --> read request.test

can this be done?

-- 

--
Ian Sheridan
http://www.savagevines.com


~|
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.houseoffusion.com/banners/view.cfm?bannerid=11

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

Re: Query Help Needed (Solved)

[Donna French]

Got it working with this code:

SELECT COUNT(*) as ClientCount
FROM Clients 
WHERE 
Client_IntakeDate >= 
AND
Client_IntakeDate <= 
AND
#Trim(Form.Param1Select)# = 

AND
#Trim(Form.Param2Select)# = 


AND
#Trim(Form.Param3Select)# = 

;



On Wed, 3 Nov 2004 11:25:16 -0600, Donna French <[EMAIL PROTECTED]> wrote:
> Okay, I see what you mean but I'm not sure how to define since they
> are passed from selects instead of a db field?
> 
> Thank you for your help,
> ~ Donna
> 
> 
> 
> 
> On Wed, 03 Nov 2004 01:59:39 +0100, Jochem van Dieten
> <[EMAIL PROTECTED]> wrote:
> > Donna French wrote:
> > > Should this code work if I only pass the StartDate, EndDate and Param1Val?
> >
> > No.
> >
> >
> >
> >
> > > 
> > > 
> > >
> > > 
> > >  > > username=#MM_wdv_USERNAME# password=#MM_wdv_PASSWORD#>
> > > SELECT COUNT(Clients.Client_ID) as ClientCount
> > > FROM Clients
> > > WHERE
> > >   Client_IntakeDate >=  > > cfsqltype="cf_sql_date">
> > >   AND
> > >   Client_IntakeDate <=  > > cfsqltype="cf_sql_date">
> > >   AND
> > >   #Form.Param1# = 
> >
> > This will throw an error because form.param1 is undefined.
> >
> > >   AND
> > >   #Form.Param2# = 
> >
> > Here both form.param2 and form.param2val are undefined. Remember
> > that your cfparam is for param2val, not form.param2val. (CF might
> > skip past the param2val issue though since it is essentially a
> > constant and the compiler might recognize it as such.)
> >
> > >   AND
> > >   #Form.Param3# = ;
> >
> > Same issue.
> >
> > > 
> >
> > Jochem
> >
> > 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

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

Re: OT: How do I print out a directory listing in XP

[Rob]

http://www.rohanclan.com/library/printdirlist.cfm


On Wed, 3 Nov 2004 11:18:56 -0600, Andy Ousterhout <[EMAIL PROTECTED]> wrote:
> I need to print out a directory listing for a disk I am sending to a printer.
> Can someone tell me how to do this?
> 
> Thanks,
> Andy
> 
> 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

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

How to use Request scope?!

[Ian Sheridan]

can you set a request scope variable in an include?

ex.
-index.cfm
--include1.cfm --> set request.test
--include2.cfm --> read request.test

can this be done?

-- 

--
Ian Sheridan
http://www.savagevines.com
--

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37

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

OT: How do I print out a directory listing in XP

[Andy Ousterhout]

I need to print out a directory listing for a disk I am sending to a printer.
Can someone tell me how to do this?

Thanks,
Andy




~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

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

Re: Query Help Needed

[Donna French]

Okay, I see what you mean but I'm not sure how to define since they
are passed from selects instead of a db field?

Thank you for your help,
~ Donna


On Wed, 03 Nov 2004 01:59:39 +0100, Jochem van Dieten
<[EMAIL PROTECTED]> wrote:
> Donna French wrote:
> > Should this code work if I only pass the StartDate, EndDate and Param1Val?
> 
> No.
> 
> 
> 
> 
> > 
> > 
> >
> > 
> >  > username=#MM_wdv_USERNAME# password=#MM_wdv_PASSWORD#>
> > SELECT COUNT(Clients.Client_ID) as ClientCount
> > FROM Clients
> > WHERE
> >   Client_IntakeDate >=  > cfsqltype="cf_sql_date">
> >   AND
> >   Client_IntakeDate <=  > cfsqltype="cf_sql_date">
> >   AND
> >   #Form.Param1# = 
> 
> This will throw an error because form.param1 is undefined.
> 
> >   AND
> >   #Form.Param2# = 
> 
> Here both form.param2 and form.param2val are undefined. Remember
> that your cfparam is for param2val, not form.param2val. (CF might
> skip past the param2val issue though since it is essentially a
> constant and the compiler might recognize it as such.)
> 
> >   AND
> >   #Form.Param3# = ;
> 
> Same issue.
> 
> > 
> 
> Jochem
> 
> 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

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

Re: Problem with Access driver and Windows 2003 Server

[Thomas Chiverton]

On Wednesday 03 Nov 2004 16:02 pm, Jake wrote:
> And when you hit the sites that they are running, I get the following
> error:
>   Error Executing Database Query.
> coldfusion.sql.DatabaseConnectionException: Timed out trying to
> establish connection

Does it verify in the administrator ?
Are the relavent ports open in the FireWall ?

-- 
Tom Chiverton 
Advanced ColdFusion Programmer
Tel: +44 (0)1749 834900
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834XXX
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, 
BRISTOL. BS1 6EG
*** This E-mail contains confidential information for the addressee only. If 
you are not the intended recipient,
please notify us immediately. You should not use, disclose, distribute or copy 
this communication if received
in error. No binding contract will result from this e-mail until such time as 
a written document is signed on
behalf of the company. BlueFinger Limited cannot accept responsibility for the 
completeness or accuracy of
this message as it has been transmitted over public networks.***

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

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

Re: Session vars stored in database?

[Matt Robertson]

What Barney said is dead-on.  I am a total zero on clusters, but isn't
there a way -- outside of CF -- to handle sessions so they remain
sticky despite the application?  i.e. an external application of some
sort.  Would that be db-related?

Systems guys at that level usually aren't so ignorant so I'm wondering
if he is taking something non-CF into account.

And even there was such a thing in play, I can't see how proper
locking practices would be mitigated in any meaningful way.

-- 
--Matt Robertson--
President, Janitor
MSB Designs, Inc.
mysecretbase.com

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36

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

RE: Session Management

[Lawrence Ng]

hello there,

at our college, we made it a policy to have the sessions for our portal
appllcation expire after 3 minutes of inactivity. This is to address
security and privacy issues. Portal built using PHP and implemented
Novell's iChain for single signon ability across any applications that
involves authenticating the user.

 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

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

Re: When to use cachedwithin

[Bert Dawson]

Whether or not the RDBMS caches it CF will still have to go to the dB
server and get it. If you use cachedwithin (or cachedafter) then it
stays in CF's memory, and no trips to the dB are required, so i'd say
cache it.
And don't forget you could put it in a persistent scope (either
"application" or "server" in this case) by using , and only running the query when
you start up the application.
There are pluses and minuses for bother cachedwithin/after and
persistent scope caching - it depends on the individual case...

Bert


On Wed, 03 Nov 2004 10:01:21 -0400, Chris Peters <[EMAIL PROTECTED]> wrote:
> I have a web site that uses CFMX 6.1 and MS SQL for data handling.
> 
> This question is probably because I don't know as much about MS SQL as I should, so 
> bear with me.
> 
> Is it efficient to use cachedwithin on a query that only returns a row or two in the 
> recordset? Keep in mind that this query is accessed quite a bit. A colleague says 
> that the OS/RDBMS probably caches the small recordset anyway, so I should only use 
> cachedwithin on queries that use complex joins, return large datasets, use unions, 
> etc.
> 
> Thanks for your help!
> 
> Chris
> 
> 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36

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

jrun.security.NTAuth question

[Peterson, Andrew S.]

Hello,
 
If you log someone in using jrun.security.NTAuth, how do you log them
out?
Sincerely,
 
Andrew
 


~|
The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in 
the Washington DC Area. 
http://www.houseoffusion.com/banners/view.cfm?bannerid=44

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

Problem with Access driver and Windows 2003 Server

[Jake]

All,

The server I'm on just recently was upgraded to Windows2003. While 
everything else seems to be running fine, the one thing that didn't make 
the transition very well as that the Access and Access w/ Unicode 
drivers don't seem to be working. I can't get any datasource using those 
drivers to verify.

And when you hit the sites that they are running, I get the following error:


  Error Executing Database Query.


coldfusion.sql.DatabaseConnectionException: Timed out trying to 
establish connection

I know, Access is not great but it should at least be working. And there 
has been no code change, no DB change, nothing. We have the latest MX 
version on the server, the latest Access Jet drivers.

Anyone heard of this? If so, how do I fix?? Help!!

Thanks!
Jake

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

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

Re: Bluedragon Server

[Cutter (CF related)]

Ryan,

In my past life, working for an ISP that was a CF house, we had several 
high subscriber e-newsletter clients. One technique that we employed, 
which greatly reduced server load and errors, was to send out these 
newsletters in batches of 500. Fairly easy to script, did not drag out 
system resources, easy to troubleshoot in an error situation, and 
definitely doable on BD.

Cutter



Ryan Jones wrote:

>Actually, I have another concern: mass mailing.
>
>We run a newsletter with over 3,000 subscribers.  With PHP I sent out to this list on 
>a daily basis using phpmailer class sending via smtp.  Works great.
>
>I am afraid of using the cfmail tag for such mailings based on the fact that php's 
>mail() function should NEVER be used to send out bulk mail.  I may be way off base 
>here though... maybe the cfmail tag is capable of handling thousands of addresses.
>
>But even if it is, Bluedragon itself is a concern for me here.  I say this because on 
>the Macromedia site, their feature matrix for CF notes that while CF Enterprise has 
>"High-Performance Email Delivery", the Standard Server version does not.
>
>I am assuming that the Bluedragon Server is comparable to Coldfusion MX Standard, 
>meaning that I am also assuming it does NOT feature "High-Performance Email Delivery."
>
>Am I wrong here too?
>
>  
>
>>On Wednesday 03 Nov 2004 13:30 pm, Ryan Jones wrote:
>>
>>
>>>Will Bluedragon Server really offer me everything PHP does?
>>>  
>>>
>>Yes.
>>And more. 
>>Did you have something specific in mind ?
>>
>>
>>
>>>servers take up huge amounts of memory, and tend to crash often once the
>>>traffic starts increasing.  Are these stories true, or rumors?
>>>  
>>>
>>I expect a full J2EE app like CF will use more resources than PHP embeded in 
>>Apache's httpd. But if you are that close to your hardware limits, you have 
>>other problems :-)
>>
>>-- 
>>Tom Chiverton 
>>Advanced ColdFusion Programmer
>>Tel: +44 (0)1749 834900
>>email: [EMAIL PROTECTED]
>>BlueFinger Limited
>>Underwood Business Park
>>Wookey Hole Road, WELLS. BA5 1AF
>>Tel: +44 (0)1749 834900
>>Fax: +44 (0)1749 834XXX
>>web: www.bluefinger.com
>>Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, 
>>BRISTOL. BS1 6EG
>>*** This E-mail contains confidential information for the addressee only. If 
>>you are not the intended recipient,
>>please notify us immediately. You should not use, disclose, distribute or copy 
>>this communication if received
>>in error. No binding contract will result from this e-mail until such time as 
>>a written document is signed on
>>behalf of the company. BlueFinger Limited cannot accept responsibility for the 
>>completeness or accuracy of
>>this message as it has been transmitted over public networks.***
>>
>>
>
>

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

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

Re: inetinfo.exe Memory Leak After 6.1 Updater

[Dave Carabetta]

On Wed, 3 Nov 2004 03:58:17 -0700, Stephen Cassady <[EMAIL PROTECTED]> wrote:
> Please please let me know the solution!!!
> 
> This is bringing my server to it's knees constantly, the JRun locks a
> processor (Dual Xeons, so 1 of the 4 virtual chips and runs 25% of my system
> process) and the VMem goes out of control. Really need to know what to do!
> 

Perhaps either of these TechNotes might help you along? Sorry, I don't
work with Windows, so I have no personal experience:

http://www.macromedia.com/support/coldfusion/ts/documents/iis6_slow_perf.htm

http://www.macromedia.com/support/coldfusion/ts/documents/siteminder_filter_hang.htm

Regards,
Dave.

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36

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

Re: Bluedragon Server

[Rey Bango]

Ryan,

My suggestion is to use a blend of tools. CFML, IMO, will provide you with
faster application turnaround but that doesn't mean that you should abandon
tools that aren't built in it. Use what's best for the specific task at hand
and don't rewrite something for the sake of doing it. If you have PHP code
that already handles your mailings, just continue to use it.

Rey...


- Original Message - 
From: "Ryan Jones" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, November 03, 2004 8:49 AM
Subject: Re: Bluedragon Server


> Actually, I have another concern: mass mailing.
>
> We run a newsletter with over 3,000 subscribers.  With PHP I sent out to
this list on a daily basis using phpmailer class sending via smtp.  Works
great.
>
> I am afraid of using the cfmail tag for such mailings based on the fact
that php's mail() function should NEVER be used to send out bulk mail.  I
may be way off base here though... maybe the cfmail tag is capable of
handling thousands of addresses.
>
> But even if it is, Bluedragon itself is a concern for me here.  I say this
because on the Macromedia site, their feature matrix for CF notes that while
CF Enterprise has "High-Performance Email Delivery", the Standard Server
version does not.
>
> I am assuming that the Bluedragon Server is comparable to Coldfusion MX
Standard, meaning that I am also assuming it does NOT feature
"High-Performance Email Delivery."
>
> Am I wrong here too?
>
> >On Wednesday 03 Nov 2004 13:30 pm, Ryan Jones wrote:
> >> Will Bluedragon Server really offer me everything PHP does?
> >
> >Yes.
> >And more.
> >Did you have something specific in mind ?
> >
> >> servers take up huge amounts of memory, and tend to crash often once
the
> >> traffic starts increasing.  Are these stories true, or rumors?
> >
> >I expect a full J2EE app like CF will use more resources than PHP embeded
in
> >Apache's httpd. But if you are that close to your hardware limits, you
have
> >other problems :-)
> >
> >-- 
> >Tom Chiverton
> >Advanced ColdFusion Programmer
> >Tel: +44 (0)1749 834900
> >email: [EMAIL PROTECTED]
> >BlueFinger Limited
> >Underwood Business Park
> >Wookey Hole Road, WELLS. BA5 1AF
> >Tel: +44 (0)1749 834900
> >Fax: +44 (0)1749 834XXX
> >web: www.bluefinger.com
> >Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay,
> >BRISTOL. BS1 6EG
> >*** This E-mail contains confidential information for the addressee only.
If
> >you are not the intended recipient,
> >please notify us immediately. You should not use, disclose, distribute or
copy
> >this communication if received
> >in error. No binding contract will result from this e-mail until such
time as
> >a written document is signed on
> >behalf of the company. BlueFinger Limited cannot accept responsibility
for the
> >completeness or accuracy of
> >this message as it has been transmitted over public networks.***
>
> 

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

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

Re: Bluedragon Server

[Yves Arsenault]

Some of you might find this a little weird

But I once looped  a cfmail to test BlueDragon' 3.x version and my
mail server I can't remember how many emails I was (and had) set
to receive, but I had no problem what so ever

And the loop was several 10s of thousand... probably about 50 000 emails..

This was done on a Linux platform.

PS, this server was in production at the time of the test... 

Yves


On Wed, 3 Nov 2004 14:59:51 +, Thomas Chiverton
<[EMAIL PROTECTED]> wrote:
> On Wednesday 03 Nov 2004 13:49 pm, Ryan Jones wrote:
> > may be way off base here though... maybe the cfmail tag is capable of
> > handling thousands of addresses.
> 
> Certainly is, failing that there is the CFML that powers this very list :-)
> 
> > Standard, meaning that I am also assuming it does NOT feature
> > "High-Performance Email Delivery."
> 
> I wouldn't call 3000/day high.
> 
> > With cfml, I could find myself at a place where I need to call on java.
> 
> Only in the same way that if PHP doesn't do it, you need to call on C.
> 
> Drop the BD sales people a line, they are very responsive and helpful.
> 
> 
> 
> --
> Tom Chiverton
> Advanced ColdFusion Programmer
> Tel: +44 (0)1749 834900
> email: [EMAIL PROTECTED]
> BlueFinger Limited
> Underwood Business Park
> Wookey Hole Road, WELLS. BA5 1AF
> Tel: +44 (0)1749 834900
> Fax: +44 (0)1749 834XXX
> web: www.bluefinger.com
> Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay,
> BRISTOL. BS1 6EG
> *** This E-mail contains confidential information for the addressee only. If
> you are not the intended recipient,
> please notify us immediately. You should not use, disclose, distribute or copy
> this communication if received
> in error. No binding contract will result from this e-mail until such time as
> a written document is signed on
> behalf of the company. BlueFinger Limited cannot accept responsibility for the
> completeness or accuracy of
> this message as it has been transmitted over public networks.***
> 
> 

~|
Protect your mail server with built in anti-virus protection. It's not only good for 
you, it's good for everybody.
http://www.houseoffusion.com/banners/view.cfm?bannerid=39

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

RE: Odd SQL Behaviour, errors generated by values I am not trying to use!

[James Smith]

> >>> INSERT INTO barcodes (Barcode, ItemID) VALUES 
> (0008811953928,17870)
> >>> 
> >>> Could anyone tell me why the number 0004294967295 is causing an 
> >>> error
>  when the SQL statement doesn't even show it being used?
> >> 
> >> Because it is 2^32. Instead of throwing an error MySQL just rounds 
> >> your value to the maximum that fits in the field.
> > 
> > But the field is INT(13), why would a 13 digit number not fit?
> 
> Because display padding has got nothing to do with physical
> storage: http://dev.mysql.com/doc/mysql/en/Numeric_types.html

Bigint fixed it, thanks.  Any idea why the DB allows an INT(13)?

--
Jay


~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

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

Re: Bluedragon Server

[Thomas Chiverton]

On Wednesday 03 Nov 2004 13:49 pm, Ryan Jones wrote:
> may be way off base here though... maybe the cfmail tag is capable of
> handling thousands of addresses.

Certainly is, failing that there is the CFML that powers this very list :-)

> Standard, meaning that I am also assuming it does NOT feature
> "High-Performance Email Delivery."

I wouldn't call 3000/day high.

> With cfml, I could find myself at a place where I need to call on java.

Only in the same way that if PHP doesn't do it, you need to call on C.

Drop the BD sales people a line, they are very responsive and helpful.

-- 
Tom Chiverton 
Advanced ColdFusion Programmer
Tel: +44 (0)1749 834900
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834XXX
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, 
BRISTOL. BS1 6EG
*** This E-mail contains confidential information for the addressee only. If 
you are not the intended recipient,
please notify us immediately. You should not use, disclose, distribute or copy 
this communication if received
in error. No binding contract will result from this e-mail until such time as 
a written document is signed on
behalf of the company. BlueFinger Limited cannot accept responsibility for the 
completeness or accuracy of
this message as it has been transmitted over public networks.***

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

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

When to use cachedwithin

[Chris Peters]

I have a web site that uses CFMX 6.1 and MS SQL for data handling.

This question is probably because I don't know as much about MS SQL as I should, so 
bear with me.

Is it efficient to use cachedwithin on a query that only returns a row or two in the 
recordset? Keep in mind that this query is accessed quite a bit. A colleague says that 
the OS/RDBMS probably caches the small recordset anyway, so I should only use 
cachedwithin on queries that use complex joins, return large datasets, use unions, etc.

Thanks for your help!

Chris

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37

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

Re: Bluedragon Server

[Ryan Jones]

Actually, I have another concern: mass mailing.

We run a newsletter with over 3,000 subscribers.  With PHP I sent out to this list on 
a daily basis using phpmailer class sending via smtp.  Works great.

I am afraid of using the cfmail tag for such mailings based on the fact that php's 
mail() function should NEVER be used to send out bulk mail.  I may be way off base 
here though... maybe the cfmail tag is capable of handling thousands of addresses.

But even if it is, Bluedragon itself is a concern for me here.  I say this because on 
the Macromedia site, their feature matrix for CF notes that while CF Enterprise has 
"High-Performance Email Delivery", the Standard Server version does not.

I am assuming that the Bluedragon Server is comparable to Coldfusion MX Standard, 
meaning that I am also assuming it does NOT feature "High-Performance Email Delivery."

Am I wrong here too?

>On Wednesday 03 Nov 2004 13:30 pm, Ryan Jones wrote:
>> Will Bluedragon Server really offer me everything PHP does?
>
>Yes.
>And more. 
>Did you have something specific in mind ?
>
>> servers take up huge amounts of memory, and tend to crash often once the
>> traffic starts increasing.  Are these stories true, or rumors?
>
>I expect a full J2EE app like CF will use more resources than PHP embeded in 
>Apache's httpd. But if you are that close to your hardware limits, you have 
>other problems :-)
>
>-- 
>Tom Chiverton 
>Advanced ColdFusion Programmer
>Tel: +44 (0)1749 834900
>email: [EMAIL PROTECTED]
>BlueFinger Limited
>Underwood Business Park
>Wookey Hole Road, WELLS. BA5 1AF
>Tel: +44 (0)1749 834900
>Fax: +44 (0)1749 834XXX
>web: www.bluefinger.com
>Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, 
>BRISTOL. BS1 6EG
>*** This E-mail contains confidential information for the addressee only. If 
>you are not the intended recipient,
>please notify us immediately. You should not use, disclose, distribute or copy 
>this communication if received
>in error. No binding contract will result from this e-mail until such time as 
>a written document is signed on
>behalf of the company. BlueFinger Limited cannot accept responsibility for the 
>completeness or accuracy of
>this message as it has been transmitted over public networks.***

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36

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

Re: Bluedragon Server

[Ryan Jones]

Well Tom, at this point I guess my primary concern is this:

Say along the way I decide to do something with our site that is not directly handled 
by one of the currently available cfml tags...

With PHP I am basicly open and free to code and make the language do just about 
anything I want it to.  With cfml, I could find myself at a place where I need to call 
on java.  However, if I understand correctly, the free version of Bluedragon does not 
support calls to java nor the parsing of jsp code.

I may be wrong...?

>On Wednesday 03 Nov 2004 13:30 pm, Ryan Jones wrote:
>> Will Bluedragon Server really offer me everything PHP does?
>
>Yes.
>And more. 
>Did you have something specific in mind ?
>
>> servers take up huge amounts of memory, and tend to crash often once the
>> traffic starts increasing.  Are these stories true, or rumors?
>
>I expect a full J2EE app like CF will use more resources than PHP embeded in 
>Apache's httpd. But if you are that close to your hardware limits, you have 
>other problems :-)
>
>-- 
>Tom Chiverton 
>Advanced ColdFusion Programmer
>Tel: +44 (0)1749 834900
>email: [EMAIL PROTECTED]
>BlueFinger Limited
>Underwood Business Park
>Wookey Hole Road, WELLS. BA5 1AF
>Tel: +44 (0)1749 834900
>Fax: +44 (0)1749 834XXX
>web: www.bluefinger.com
>Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, 
>BRISTOL. BS1 6EG
>*** This E-mail contains confidential information for the addressee only. If 
>you are not the intended recipient,
>please notify us immediately. You should not use, disclose, distribute or copy 
>this communication if received
>in error. No binding contract will result from this e-mail until such time as 
>a written document is signed on
>behalf of the company. BlueFinger Limited cannot accept responsibility for the 
>completeness or accuracy of
>this message as it has been transmitted over public networks.***

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

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

Re: Bluedragon Server

[Ryan Jones]

Well Tom, at this point I guess my primary concern is this:

Say along the way I decide to do something with our site that is not directly handled 
by one of the currently available cfml tags...

With PHP I am basicly open and free to code and make the language do just about 
anything I want it to.  With cfml, I could find myself at a place where I need to call 
on java.  However, if I understand correctly, the free version of Bluedragon does not 
support calls to java nor the parsing of jsp code.

I may be wrong...?

>On Wednesday 03 Nov 2004 13:30 pm, Ryan Jones wrote:
>> Will Bluedragon Server really offer me everything PHP does?
>
>Yes.
>And more. 
>Did you have something specific in mind ?
>
>> servers take up huge amounts of memory, and tend to crash often once the
>> traffic starts increasing.  Are these stories true, or rumors?
>
>I expect a full J2EE app like CF will use more resources than PHP embeded in 
>Apache's httpd. But if you are that close to your hardware limits, you have 
>other problems :-)
>
>-- 
>Tom Chiverton 
>Advanced ColdFusion Programmer
>Tel: +44 (0)1749 834900
>email: [EMAIL PROTECTED]
>BlueFinger Limited
>Underwood Business Park
>Wookey Hole Road, WELLS. BA5 1AF
>Tel: +44 (0)1749 834900
>Fax: +44 (0)1749 834XXX
>web: www.bluefinger.com
>Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, 
>BRISTOL. BS1 6EG
>*** This E-mail contains confidential information for the addressee only. If 
>you are not the intended recipient,
>please notify us immediately. You should not use, disclose, distribute or copy 
>this communication if received
>in error. No binding contract will result from this e-mail until such time as 
>a written document is signed on
>behalf of the company. BlueFinger Limited cannot accept responsibility for the 
>completeness or accuracy of
>this message as it has been transmitted over public networks.***

~|
Protect your mail server with built in anti-virus protection. It's not only good for 
you, it's good for everybody.
http://www.houseoffusion.com/banners/view.cfm?bannerid=39

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

Re: Bluedragon Server

[Thomas Chiverton]

On Wednesday 03 Nov 2004 13:30 pm, Ryan Jones wrote:
> Will Bluedragon Server really offer me everything PHP does?

Yes.
And more. 
Did you have something specific in mind ?

> servers take up huge amounts of memory, and tend to crash often once the
> traffic starts increasing.  Are these stories true, or rumors?

I expect a full J2EE app like CF will use more resources than PHP embeded in 
Apache's httpd. But if you are that close to your hardware limits, you have 
other problems :-)

-- 
Tom Chiverton 
Advanced ColdFusion Programmer
Tel: +44 (0)1749 834900
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834XXX
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, 
BRISTOL. BS1 6EG
*** This E-mail contains confidential information for the addressee only. If 
you are not the intended recipient,
please notify us immediately. You should not use, disclose, distribute or copy 
this communication if received
in error. No binding contract will result from this e-mail until such time as 
a written document is signed on
behalf of the company. BlueFinger Limited cannot accept responsibility for the 
completeness or accuracy of
this message as it has been transmitted over public networks.***

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36

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

Re: Bluedragon Server

[Yves Arsenault]

Hello there,

You could check here for some comparison info...
http://www.newatlanta.com/products/bluedragon/product_info/cfml_tag_support.cfm
http://www.newatlanta.com/products/bluedragon/product_info/features.cfm#FCMatrix

I believe that the free version does have certain license restrictions... 

I'm sure there are some BD people on the list who may answer any questions.

Hope that helps a bit..

Yves


On Wed, 03 Nov 2004 15:30:11 +0200, Ryan Jones <[EMAIL PROTECTED]> wrote:
> Hello,
> 
> I posted the following to the Bluedragon mailing list over at New
> Atlanta, but would also love to have the insight of the members of this
> site.
> 
> *We are a small outfit that runs a PHP-based content site.  I would
> really like to move to cfml, as my job description includes webmaster,
> web developer, content co-editor and promotions guy... cfml's ease of
> use could really save me some time and allow me to do more advanced
> things than PHP would, as with PHP these things would presumably take
> more time to learn - time I don't have.
> 
> On Ben Forta's blog, Vince Bonfanti of New Atlanta made the following claim:
> 
> * */"//The free BlueDragon Server edition is being offered directly as
> an alternative to PHP to keep people using CFML instead."/
> 
> Will Bluedragon Server really offer me everything PHP does?
> 
> I have also read horror stories about how cfml is nice, but that the
> servers take up huge amounts of memory, and tend to crash often once the
> traffic starts increasing.  Are these stories true, or rumors?
> 
> *Thank you,
> Ryan Jones
> 
> 

~|
Protect your mail server with built in anti-virus protection. It's not only good for 
you, it's good for everybody.
http://www.houseoffusion.com/banners/view.cfm?bannerid=39

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

Re: Odd SQL Behaviour, errors generated by values I am not trying to use!

[Jochem van Dieten]

James Smith wrote:
>>> INSERT INTO barcodes (Barcode, ItemID) VALUES (0008811953928,17870)
>>> 
>>> Could anyone tell me why the number 0004294967295 is 
>>> causing an error 
 when the SQL statement doesn't even show it being used?
>> 
>> Because it is 2^32. Instead of throwing an error MySQL just 
>> rounds your value to the maximum that fits in the field.
> 
> But the field is INT(13), why would a 13 digit number not fit?

Because display padding has got nothing to do with physical 
storage: http://dev.mysql.com/doc/mysql/en/Numeric_types.html

Jochem

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

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

RE: Session Management

[Dawson, Michael]

That is correct with our current implementation.  In our computer labs, we strongly 
instruct that students log completely out of the computer, in effect closing the 
browser.
 
In administrative or faculty offices, users lock their computers when they walk away 
and, being a small university, we have the luxury of knowing when a "stranger" is 
around.
 
Without going into large security discussions, it's been this way for over two years 
and there has never been an issue with it.  In fact, I always leave my computer 
unlocked, but I have an office with a lockable door.
 
However, I have been considering adding a timeout so that users must log back in when 
their sessions expire.  It would sure make my coding much easier.
 
BTW, all the boozers our in our IT dept.  ;-)

  _  

From: Mike Kear [mailto:[EMAIL PROTECTED]
Sent: Tue 11/2/2004 9:30 PM
To: CF-Talk
Subject: Re: Session Management



Michael, does this mean if a logged-in user goes off to lunch without
logging out,  their machine is still logged in (in effect) all day (if
it's a long lunch with the sales department booze-heads) or even all
night too?

Isn't that a security risk?

Cheers
Mike Kear
Windsor, NSW, Australia
AFP Webworks
http://afpwebworks.com
.com,.net,.org domains from AUD$20/Year



On Tue, 2 Nov 2004 20:35:13 -0600, Dawson, Michael <[EMAIL PROTECTED]> wrote:
> I just store login information in a cookie.  Then, if the session has
> timed out, I reload the session using the login information that is
> stored in the cookie.  The user never knows they lost their session due
> to inactivity.
>
>
>



~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34

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

Bluedragon Server

[Ryan Jones]

Hello,

I posted the following to the Bluedragon mailing list over at New 
Atlanta, but would also love to have the insight of the members of this 
site.

*We are a small outfit that runs a PHP-based content site.  I would 
really like to move to cfml, as my job description includes webmaster, 
web developer, content co-editor and promotions guy... cfml's ease of 
use could really save me some time and allow me to do more advanced 
things than PHP would, as with PHP these things would presumably take 
more time to learn - time I don't have.

On Ben Forta's blog, Vince Bonfanti of New Atlanta made the following claim:

* */"//The free BlueDragon Server edition is being offered directly as 
an alternative to PHP to keep people using CFML instead."/

Will Bluedragon Server really offer me everything PHP does? 

I have also read horror stories about how cfml is nice, but that the 
servers take up huge amounts of memory, and tend to crash often once the 
traffic starts increasing.  Are these stories true, or rumors?

*Thank you,
Ryan Jones


~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37

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

Re: Can someone Explain this Error Message

[Thomas Chiverton]

On Wednesday 03 Nov 2004 12:23 pm, Thomas Chiverton wrote:
> less evil path  ?

or, indeed, string ?

-- 
Tom Chiverton 
Advanced ColdFusion Programmer
Tel: +44 (0)1749 834900
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834XXX
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, 
BRISTOL. BS1 6EG
*** This E-mail contains confidential information for the addressee only. If 
you are not the intended recipient,
please notify us immediately. You should not use, disclose, distribute or copy 
this communication if received
in error. No binding contract will result from this e-mail until such time as 
a written document is signed on
behalf of the company. BlueFinger Limited cannot accept responsibility for the 
completeness or accuracy of
this message as it has been transmitted over public networks.***

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

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

RE: Odd SQL Behaviour, errors generated by values I am not trying to use!

[James Smith]

> I'm not seeing why it happens, but you could simplify your code:
> 
> 
> INSERT INTO barcodes (Barcode, ItemID)
> SELECT   Barcode, ItemID
> FROM stockitemdetails
> 

Thanks, I was doing that originally but modified it so I could output some
values to screen for debug reasons.

--
Jay


~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34

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

RE: Odd SQL Behaviour, errors generated by values I am not trying to use!

[James Smith]

> > INSERT INTO barcodes (Barcode, ItemID) VALUES (0008811953928,17870)
> > 
> > Could anyone tell me why the number 0004294967295 is 
> causing an error 
> > when the SQL statement doesn't even show it being used?
> 
> Because it is 2^32. Instead of throwing an error MySQL just 
> rounds your value to the maximum that fits in the field.

But the field is INT(13), why would a 13 digit number not fit?

--
Jay


~|
Protect your mail server with built in anti-virus protection. It's not only good for 
you, it's good for everybody.
http://www.houseoffusion.com/banners/view.cfm?bannerid=39

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

RE: Odd SQL Behaviour, errors generated by values I am not trying to use!

[Pascal Peters]

I'm not seeing why it happens, but you could simplify your code:


INSERT INTO barcodes (Barcode, ItemID)
SELECT   Barcode, ItemID
FROM stockitemdetails


Pascal

> -Original Message-
> From: James Smith [mailto:[EMAIL PROTECTED]
> Sent: 03 November 2004 14:01
> To: CF-Talk
> Subject: Odd SQL Behaviour, errors generated by values I am not trying
to
> use!
> 
> I am looping over a result set to insert the results into a new table.
> 
> Select Query
> 
> 
> SELECT   Barcode, ItemID, Title
> FROM stockitemdetails
> ORDER BY Barcode
> 
> 
> Insert Query
> 
> 
>   #Select2.ItemID# - #Select2.Barcode# -
> #Select2.Title#
>   
>   INSERT INTO barcodes (Barcode, ItemID)
>   VALUES (#Select2.Barcode#,#Select2.ItemID#)
>   
> 
> 
> It should also be noted that the barcodes table includes an ID column
> which
> is an Auto Increment primary key, and the barcode column is INT(13)
> zerofill
> indexed as unique.
> 
> When this template is executed the first 4 values are inserted
correctly,
> however the 5th inserts the barcode wrong (as 0004294967295 where the
> output
> is 0008811171629) and the 6th then errors by trying to insert this
same
> wrong value again even though the output is unique (0008811953928).
The
> error generated is...
> 
> Invalid argument value: Duplicate entry '0004294967295' for key 2
> 
> However the error box lists the SQL statement in question as...
> 
> INSERT INTO barcodes (Barcode, ItemID) VALUES (0008811953928,17870)
> 
> Could anyone tell me why the number 0004294967295 is causing an error
when
> the SQL statement doesn't even show it being used?
> 
> NOTE: If I remove the requirement for the barcode column to be unique
then
> almost all of the barcodes are inserted as this same wrong number, and
by
> almost all I mean only 20 or so work correctly out of about 10,000
total
> rows.
> 
> --
> James Smith
> [EMAIL PROTECTED]
> 
> 
> 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

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

Re: Odd SQL Behaviour, errors generated by values I am not trying to use!

[Jochem van Dieten]

James Smith wrote:
> 
> However the error box lists the SQL statement in question as...
> 
> INSERT INTO barcodes (Barcode, ItemID) VALUES (0008811953928,17870)
> 
> Could anyone tell me why the number 0004294967295 is causing an error when
> the SQL statement doesn't even show it being used?

Because it is 2^32. Instead of throwing an error MySQL just 
rounds your value to the maximum that fits in the field.

Jochem

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

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

Re: Can someone Explain this Error Message

[Thomas Chiverton]

On Wednesday 03 Nov 2004 12:04 pm, Graham Pearson wrote:
> Branch target offset too large for short

Is the file very large ?
Can you test it with a less evil path  ?

-- 
Tom Chiverton 
Advanced ColdFusion Programmer
Tel: +44 (0)1749 834900
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834XXX
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, 
BRISTOL. BS1 6EG
*** This E-mail contains confidential information for the addressee only. If 
you are not the intended recipient,
please notify us immediately. You should not use, disclose, distribute or copy 
this communication if received
in error. No binding contract will result from this e-mail until such time as 
a written document is signed on
behalf of the company. BlueFinger Limited cannot accept responsibility for the 
completeness or accuracy of
this message as it has been transmitted over public networks.***

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37

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

Odd SQL Behaviour, errors generated by values I am not trying to use!

[James Smith]

I am looping over a result set to insert the results into a new table.

Select Query


SELECT   Barcode, ItemID, Title
FROM stockitemdetails
ORDER BY Barcode


Insert Query


  #Select2.ItemID# - #Select2.Barcode# -
#Select2.Title#
  
  INSERT INTO barcodes (Barcode, ItemID)
  VALUES (#Select2.Barcode#,#Select2.ItemID#)
  


It should also be noted that the barcodes table includes an ID column which
is an Auto Increment primary key, and the barcode column is INT(13) zerofill
indexed as unique.

When this template is executed the first 4 values are inserted correctly,
however the 5th inserts the barcode wrong (as 0004294967295 where the output
is 0008811171629) and the 6th then errors by trying to insert this same
wrong value again even though the output is unique (0008811953928).  The
error generated is...

Invalid argument value: Duplicate entry '0004294967295' for key 2

However the error box lists the SQL statement in question as...

INSERT INTO barcodes (Barcode, ItemID) VALUES (0008811953928,17870)

Could anyone tell me why the number 0004294967295 is causing an error when
the SQL statement doesn't even show it being used?

NOTE: If I remove the requirement for the barcode column to be unique then
almost all of the barcodes are inserted as this same wrong number, and by
almost all I mean only 20 or so work correctly out of about 10,000 total
rows.

--
James Smith
[EMAIL PROTECTED]


~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

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

RE: MS SQL problem

[Gavin Brook]

The following will do what you need, although it is a little long-winded.

-- Prepare blank list
declare @list varchar(4000)
set @list = ''

-- Get SOFTWARE list for COMPANY
select  @list = @list + ',' + SOFTWARE.SOFTWARE_NAME
fromSOFTWARE
inner join  COMPANY_SOFTWARES ON
COMPANY_SOFTWARES.SOFTWARE_ID = SOFTWARE.SOFTWARE_ID
where   COMPANY_SOFTWARES.COMPANY_ID = 10

-- Removes Extraneous , at beginning
select @list = substring( @list , 2, len( @list )  )

-- Final Returned Query
select  COMPANY.COMPANY_ID,
COMPANY.COMPANY_name,
@list as SOFTWARES
fromCOMPANY
where   COMPANY_ID = 10

The other option is do it through ColdFusion as suggested, which may be a
tidier way.

Gavin

-Original Message-
From: Nurettin Omer Hamzaoglu [mailto:[EMAIL PROTECTED] 
Sent: 03 November 2004 10:29
To: CF-Talk
Subject: MS SQL problem


Hi all,

I've 3 tables COMPANY, COMPANY_SOFTWARES, SOFWARES. COMPANY_SOFTWARES table
holds the data of the softwares used in the companies like;



~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34

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

Can someone Explain this Error Message

[Graham Pearson]

I am getting an error message which states:

Branch target offset too large for short

The first line of the stack trace reads

org.apache.bcel.generic.ClassGenException: Brnach target offset too large 
for short

The error message will appear when I include the following line and if I 
comment out this line I will not get the above error message.




I have also copied this line above from another section which is identical 
as I am creating an RTF File which contains a School Report Card which is 
apart of my Coldfusion Based Student Information System. Anyone have any ideas?



--
[]
   

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

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

RE: MS SQL problem

[Pascal Peters]

I don't think it is possible (but I don't use M$SQL that often, so I may
be mistaken). If it is for CF, use grouped output:


SELECT
C.COMPANY_ID,
C.COMPANY_NAME,
S.SOFTWARE_NAME 
FROM
COMPANY C
COMPANY_SOFTWARES COS, 
SOFTWARES S
WHERE 
S.SOFTWARE_ID = CS.SOFTWARE_ID 
AND COS.COMPANY_ID = C.COMPANY_ID
AND C.COMPANY_ID = 10
ORDER BY
C.COMPANY_NAME


ID: #qCompanySoftware.COMPANY_ID#
Name: #qCompanySoftware.COMPANY_NAME#
Softwares: 

#qCompanySoftware.SOFTWARE_NAME#,




If you are filtering on a unique ID, you can also do:

ID: #qCompanySoftware.COMPANY_ID#
Name: #qCompanySoftware.COMPANY_NAME#
Softwares: #ValueList(qCompanySoftware.SOFTWARE_NAME)#


Pascal

> -Original Message-
> From: Nurettin Omer Hamzaoglu [mailto:[EMAIL PROTECTED]
> Sent: 03 November 2004 11:29
> To: CF-Talk
> Subject: MS SQL problem
> 
> Hi all,
> 
> I've 3 tables COMPANY, COMPANY_SOFTWARES, SOFWARES. COMPANY_SOFTWARES
> table holds the data of the softwares used in the companies like;
> 
> I need a result like;
> COMPANY_ID   COMAPNY_NAME   SOFTWARES
> --      -
> 10   My Company X, Y, Z
> 
> 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36

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

Re: inetinfo.exe Memory Leak After 6.1 Updater

[Stephen Cassady]

Please please let me know the solution!!!

This is bringing my server to it's knees constantly, the JRun locks a
processor (Dual Xeons, so 1 of the 4 virtual chips and runs 25% of my system
process) and the VMem goes out of control. Really need to know what to do!

 

(can you hear the panic in my voice!)

cassady at lopedia dot com

 

 

> Still happening.  I called Macromedia (we just got their bronze 

> support), so I'll let you all know if they can resolve this.

> 

> > I just uninstalled the connectors and reinstalled them (and left 

> > jrunsvc.exe alone).  I'll let you know what happens tomorrow...

> > 

> > - Sung

> > 

> > >Is re-running the connectors necessary or can I just replace the

> > jrunsvc.

exe?

 





~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34

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

MS SQL problem

[Nurettin Omer Hamzaoglu]

Hi all,

I've 3 tables COMPANY, COMPANY_SOFTWARES, SOFWARES. COMPANY_SOFTWARES table holds the 
data of the softwares used in the companies like;

COMPANY TABLE
COMPANY_ID   COMPANY_NAME
--   
10   My Company

COMPANY SOFTWARES TABLE
COMPANY_ID   SOFTWARE_ID
--   --
10   1
10   2
10   3

SOFWARES TABLE
SOFTWARE_ID   SOFTWARE_NAME
---   -
1 X
2 Y
3 Z

I need a result like;
COMPANY_ID   COMAPNY_NAME   SOFTWARES
--      -
10   My Company X, Y, Z


I've used a query like;

SELECT
COMPANY_ID,
COMPANY_NAME,
(
SELECT 
SOFTWARE_NAME 
FROM 
COMPANY_SOFTWARES COS, 
SOFTWARES S
WHERE 
S.SOFTWARE_ID=CS.SOFTWARE_ID AND 
COS.COMPANY_ID = C.COMPANY_ID
) AS SOFWARE_NAMES
FROM
COMPANY C
WHERE
AND C.COMPANY_ID = 10

But I get an error message;
Subquery returned more than 1 value. This is not permitted when the subquery follows 
=, !=, <, <= , >, >= or when the subquery is used as an expression.

I've read that in MySQL there is CONCAT function for the result I want but I couldn't 
find any solution in MSSQL server, any solutions, suggestions?

Thanks in advance.



~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

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

Re: Verity not installed?

[Andrew Dixon]

This is driving me up the wall now... I have installed the hotfix for
6.1 and Verity/Linux:

http://www.macromedia.com/support/coldfusion/ts/documents/hotfix_verity_linux.htm

This made no difference.

I then installed the 6.1 updater and this has made no difference.

Any other ideas?

Andrew.


On Tue, 2 Nov 2004 10:34:47 -0700, Figy, Kam <[EMAIL PROTECTED]> wrote:
> http://www.houseoffusion.com/cf_lists/messages.cfm/threadid:855/forumid:
> 14
> 
> This was related to RedHat 7.2, but the same dependency issues might
> relate in Fedora.
> 
> HTH
> Kam
> 
> 
> 
> -Original Message-
> From: Andrew Dixon [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 02, 2004 3:19 AM
> To: CF-Talk
> Subject: Verity not installed?
> 
> Hi Everyone.
> 
> I have just installed a new system with CFMX6.1 on a Linux (done it lots
> of time before) and it all installed ok. I then started to do some
> configuration for my application in CF Admin and when I got to the bit
> to set up Verity collections I clicked the 'Verity Collections' click on
> the right and in the window on the left, instead of showing me the
> collections interface it says:
> 
> "You must configure your application server to enable Verity. For
> instructions, see "Installing and Using ColdFusion MX." "
> 
> I have never had this before and I have looked the the "Installing and
> Using ColdFusion MX" document on the MM website and I can't see any
> mention of this.
> 
> Anyone have any ideas what is going on and how I can fix the problem?
> 
> Best Regards
> 
> Andrew.
> 
> 
> 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36

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

Re: cfencode problems

[Thomas Chiverton]

On Tuesday 02 Nov 2004 20:38 pm, Stan Winchester wrote:
> c:\cfusionmx\bin\cfencode f:\websites\[path]\*.cfm f:\websites\[path]\*.cfm
> /r

Path too long, or contains funny chars ?

-- 
Tom Chiverton 
Advanced ColdFusion Programmer
Tel: +44 (0)1749 834900
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834XXX
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, 
BRISTOL. BS1 6EG
*** This E-mail contains confidential information for the addressee only. If 
you are not the intended recipient,
please notify us immediately. You should not use, disclose, distribute or copy 
this communication if received
in error. No binding contract will result from this e-mail until such time as 
a written document is signed on
behalf of the company. BlueFinger Limited cannot accept responsibility for the 
completeness or accuracy of
this message as it has been transmitted over public networks.***

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34

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

Re: Forcing text to wrap in table cell

[Stephen Moretti (cfmaster)]

Allan Cliff - CFUG Spain wrote:

>What if you live in
>Llanfairpwllgwyngyllgogerychwyrndrobwll-llantysiliogogogoch ?
>
>- Original Message - 
>From: "dave" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Wednesday, November 03, 2004 10:05 AM
>Subject: Re: Forcing text to wrap in table cell
>
>
>  
>
>>and the british have
>>supercalifragilisticexpealidous
>>
>>
>>-- Original Message --
>>From: Thomas Chiverton <[EMAIL PROTECTED]>
>>Reply-To: [EMAIL PROTECTED]
>>Date:  Wed, 3 Nov 2004 08:46:43 +
>>
>>
>>
>>>On Tuesday 02 Nov 2004 17:10 pm, [EMAIL PROTECTED] wrote:
>>>  
>>>
Well if the longest word in the English language is 28 chars...


>>>Not by a long shot.
>>>  
>>>
http://www.fact-index.com/l/lo/longest_word_in_english.html



~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

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

Re: Forcing text to wrap in table cell

[Allan Cliff - CFUG Spain]

What if you live in
Llanfairpwllgwyngyllgogerychwyrndrobwll-llantysiliogogogoch ?

- Original Message - 
From: "dave" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, November 03, 2004 10:05 AM
Subject: Re: Forcing text to wrap in table cell


> and the british have
> supercalifragilisticexpealidous
>
>
> -- Original Message --
> From: Thomas Chiverton <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date:  Wed, 3 Nov 2004 08:46:43 +
>
> >On Tuesday 02 Nov 2004 17:10 pm, [EMAIL PROTECTED] wrote:
> >> Well if the longest word in the English language is 28 chars...
> >
> >Not by a long shot.
> >
> >-- 
> >Tom Chiverton
> >Advanced ColdFusion Programmer
> >Tel: +44 (0)1749 834900
> >email: [EMAIL PROTECTED]
> >BlueFinger Limited
> >Underwood Business Park
> >Wookey Hole Road, WELLS. BA5 1AF
> >Tel: +44 (0)1749 834900
> >Fax: +44 (0)1749 834XXX
> >web: www.bluefinger.com
> >Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay,
> >BRISTOL. BS1 6EG
> >*** This E-mail contains confidential information for the addressee only.
If
> >you are not the intended recipient,
> >please notify us immediately. You should not use, disclose, distribute or
copy
> >this communication if received
> >in error. No binding contract will result from this e-mail until such
time as
> >a written document is signed on
> >behalf of the company. BlueFinger Limited cannot accept responsibility
for the
> >completeness or accuracy of
> >this message as it has been transmitted over public networks.***
> >
> >
>
> 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

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

Re: Forcing text to wrap in table cell

[dave]

and the british have 
supercalifragilisticexpealidous


-- Original Message --
From: Thomas Chiverton <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date:  Wed, 3 Nov 2004 08:46:43 +

>On Tuesday 02 Nov 2004 17:10 pm, [EMAIL PROTECTED] wrote:
>> Well if the longest word in the English language is 28 chars... 
>
>Not by a long shot.
>
>-- 
>Tom Chiverton 
>Advanced ColdFusion Programmer
>Tel: +44 (0)1749 834900
>email: [EMAIL PROTECTED]
>BlueFinger Limited
>Underwood Business Park
>Wookey Hole Road, WELLS. BA5 1AF
>Tel: +44 (0)1749 834900
>Fax: +44 (0)1749 834XXX
>web: www.bluefinger.com
>Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, 
>BRISTOL. BS1 6EG
>*** This E-mail contains confidential information for the addressee only. If 
>you are not the intended recipient,
>please notify us immediately. You should not use, disclose, distribute or copy 
>this communication if received
>in error. No binding contract will result from this e-mail until such time as 
>a written document is signed on
>behalf of the company. BlueFinger Limited cannot accept responsibility for the 
>completeness or accuracy of
>this message as it has been transmitted over public networks.***
>
>

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34

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

Re: Forcing text to wrap in table cell

[Thomas Chiverton]

On Tuesday 02 Nov 2004 17:10 pm, [EMAIL PROTECTED] wrote:
> Well if the longest word in the English language is 28 chars... 

Not by a long shot.

-- 
Tom Chiverton 
Advanced ColdFusion Programmer
Tel: +44 (0)1749 834900
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834XXX
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, 
BRISTOL. BS1 6EG
*** This E-mail contains confidential information for the addressee only. If 
you are not the intended recipient,
please notify us immediately. You should not use, disclose, distribute or copy 
this communication if received
in error. No binding contract will result from this e-mail until such time as 
a written document is signed on
behalf of the company. BlueFinger Limited cannot accept responsibility for the 
completeness or accuracy of
this message as it has been transmitted over public networks.***

~|
Get the mailserver that powers this list at 
http://www.houseoffusion.com/banners/view.cfm?bannerid=17

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

RE: Where're PLUM????

[James Holmes]

Damn; I thought I had the best excuse on record with, "the ferret was
pregnant." Oh well.

-Original Message-
From: Mark Drew [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 3 November 2004 3:19 
To: CF-Talk
Subject: Re: Where're PLUM

AS far as genuine excuses for lateness in a prokect... that is the most
valid one I have ever heard!


~|
Protect your mail server with built in anti-virus protection. It's not only good for 
you, it's good for everybody.
http://www.houseoffusion.com/banners/view.cfm?bannerid=39

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