RE: storing query results while paging through

[Dave Watts]

> > For some reason, the CACHEDWITHIN/CACHEDAFTER attributes 
> > cannot be used with queries that contain CFQUERYPARAMs. ...
>
> It can be done according to Mark Kruger. He blogged the 
> technique here: ...

While that's pretty nifty, it's not using CFQUERYPARAM, and it doesn't
provide the two primary benefits that CFQUERYPARAM does. Read through the
comments on Mark's blog for details.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230291
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: from 6 to 7

[Eric Roberts]

Access is never a good web DB solution. It was never designed to handle that
kind of traffic.  It was designed to handle a salesman's client list or a
home user's address book.  It is one of the most abused pieces of software
in the history of software...

Eric

-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED] 
Sent: Monday, 23 January 2006 16:17
To: CF-Talk
Subject: Re: from 6 to 7

Aha!

After they finally escalated the issue to the higher-ups, I found the issue.

There are two DB apps running in background.  They have the server set up so
that only one connection can be open at a time when connecting to Access
DB's.  So, the scripts are timing out when concurrent requests are being
made to two different Access DB's.  They claim that they worked with
Macromedia and this was the solution to a "stability issue with Win2003".

Whatever - I guess it's time to upgrade to a SQL Server DB.

Thanks for the help and suggestions, guys.

Russ wrote:
> Well we all know how bad access can get under load... is it possible 
> that they mapped it using the wrong db type?  I believe CF7 introduced 
> MS Access vs MS Access Unicode.  Also are persistent connections to the db
enabled?
> How big is the access file?  
> 
> If it's a big file, and persistent connections are not enabled, I can 
> see it timing out form time to time.
> 
> Russ
> 
> 
>>-Original Message-
>>From: Ray Champagne [mailto:[EMAIL PROTECTED]
>>Sent: Monday, January 23, 2006 4:55 PM
>>To: CF-Talk
>>Subject: Re: from 6 to 7
>>
>>Sorry, was out shoveling snow.  :(
>>
>>Nope, this is an Access DB.  I know that's not the best situation, but 
>>like I said, it was my first project, and it worked fine on the other 
>>server.
>>
>>And, just so it's known, I'm on a shared host, so there is no access 
>>to anything outside my web root, including the administrator.
>>
>>Ray
>>
>>Jim Wright wrote:
>>
>>>That was where I was going...I just wanted to eliminate a local db 
>>>like Access.  I don't think this is a shot in the dark...a lot of 
>>>hosts out there these days are just renting equipment in others co-lo 
>>>facilities...and often in more than one co-lo facility.  You want to 
>>>make sure they are not pulling your data from one datacenter to 
>>>anothernot just different segments of "their" network.
>>>
>>>On 1/23/06, Burns, John D <[EMAIL PROTECTED]> wrote:
>>>
>>>
As well as the question other have asked about "which database" are 
you using, I also wonder if this server sits in a different segment 
of the network than the previous one. If the server and the database 
are further removed, they could have network issues that are causing 
longer delays in the calls to the database. You may want to ask if 
there is a database server in the same segment as your server that 
you could use instead of your old one. That's a shot in the dark, 
but you may want to research it.


John Burns
Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | 
Web Developer


-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED]
Sent: Monday, January 23, 2006 3:26 PM
To: CF-Talk
Subject: from 6 to 7

Hey all:

I'm having an issue with my hosting company that I wanted to run by 
everyone.

I've had a site up and running fine at this particular host for 
quite a while now.  While it is not the most elegantly coded site 
(one of my first large projects), it works fine.  To take advantage 
of newer hosting options (more disk space), we migrated this site 
from a CF6Win2000 server to a CF7 Win2003 server.  Now it seems like 
even the most menial database queries are sometimes timing out.  
Mind you, this is not occurring all the time with the same query, it 
seems to be happening with different queries at different times.

I'm now in a debate with said host - they are telling me that it's 
because of my coding in general, they say I need to "upgrade" my 
coding to adapt to CF7.  I say this is pure BS, a copout answer.  
From what I know, the release of CF7 was more a "features" release, 
so this shouldn't matter, right?

Ray





>>>
>>>
>>>
>>
> 
> 



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230290
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: storing query results while paging through

[Will Tomlinson]

>For some reason, the CACHEDWITHIN/CACHEDAFTER attributes cannot be used with
>queries that contain CFQUERYPARAMs. This is kind of a bummer.

It can be done according to Mark Kruger. He blogged the technique here:

http://mkruger.cfwebtools.com/index.cfm?mode=entry&entry=F1B29E12-9424-1650-BA023EEB6224B18C

Will

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230289
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: Browser Testing/Redirect...

[Dave Watts]

> What would be a good method to test a user's browser and see 
> if they have JavaScript and ActiveX controls enabled and 
> Flash installed? If any are disabled or not installed, I 
> would like to re-direct the user to a site requirements page.

FlashObject - http://blog.deconcept.com/flashobject/

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230288
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 much of myspace.com is now blue dragon?

[Tony]

just wondering how that transition is going.

tw

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230287
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: Browser Testing/Redirect...

[Bobby Hartsfield]

Mock uses JS (or maybe I should say USED... looks like it has been
discontinued) to detect flash thus, it should kill 2 birds with 1 stone.
Although it's discontinued, it's just a .js file so run a search on google,
view source, and grab the mock.js file.

..:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com

 

-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 23, 2006 6:20 PM
To: CF-Talk
Subject: RE: Browser Testing/Redirect...

http://www.macromedia.com/software/flashplayer/download/detection_kit/

Not sure if this is the best to use. Anyone got anything better?

Ade

-Original Message-
From: Ryan Escamilla [mailto:[EMAIL PROTECTED]
Sent: 23 January 2006 23:15
To: CF-Talk
Subject: Browser Testing/Redirect...


What would be a good method to test a user's browser and see if they have
JavaScript and ActiveX controls enabled and Flash installed? If any are
disabled or not installed, I would like to re-direct the user to a site
requirements page. Thanks

 

Rye



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230286
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: convert windows media file to flash video on the fly

[Jason Rogoz]

what we have now is a solution where the client uploads windows media files 
that are played through their site via windows media player.  We are having 
compatibilty issues with some mac and firefox users so the switch to flash 
video looks like a good alternative.  Moving to flash video would most likely 
force us to convert all existing files and introduce a step for the client 
where they would have to convert the windows media file to an flv before they 
upload it.  The solutions mentioned below may be enough to not make things too 
confusing for the client to convert to flv before uploading. Unless there is a 
way to have the flash player play windows media files.

-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED]
Sent: January 23, 2006 3:19 PM
To: CF-Talk
Subject: RE: convert windows media file to flash video on the fly


>From what I gather, FFmpeg is a command line utility though I've never used
it, I have used Riva... which uses FFmpeg to do its conversions. As for CF,
no. you'd probably have to write your own if that's the way you wanted to go
with it. But encoding video files can be pretty strenuous on a machine and
take quite a while.

You'd probably be better off keeping a directory of the video files and use
schedules to fire off a nightly task to convert video files from a specific
directory or something.

...:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com


-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 23, 2006 4:47 PM
To: CF-Talk
Subject: RE: convert windows media file to flash video on the fly

Bobby-

Is this accessible via command line or something? I can't find any info
on that or any way that it could be called from CF.


John Burns
Certified Advanced ColdFusion MX Developer
Wyle Laboratories, Inc. | Web Developer
 

-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 23, 2006 4:38 PM
To: CF-Talk
Subject: RE: convert windows media file to flash video on the fly

http://www.flashstreamworks.com/archive.php?post_id=1095873165

"Riva just updated their free FLV Video encoder to version 1.2. The
encoder is based on the FFMPEG video conversion command line tool (GNU
LGPL)."

FFMPG
http://ffmpeg.sourceforge.net/index.php


.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com



-Original Message-
From: Jason Rogoz [mailto:[EMAIL PROTECTED]
Sent: Monday, January 23, 2006 4:31 PM
To: CF-Talk
Subject: convert windows media file to flash video on the fly

Are they any plugings available that would allow one to upload a windows
media file and convert it to a flash video file?


Jason Rogoz
Programmer / Analyst

Zoom Communications Inc.
Calgary, Alberta, Canada

Office: (403) 229-2511
Fax: (403) 229-4211
Toll Free: 1-866-698-8932

www.zoomcom.ca  
 










~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230285
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: Browser Testing/Redirect...

[Adrian Lynch]

http://www.macromedia.com/software/flashplayer/download/detection_kit/

Not sure if this is the best to use. Anyone got anything better?

Ade

-Original Message-
From: Ryan Escamilla [mailto:[EMAIL PROTECTED]
Sent: 23 January 2006 23:15
To: CF-Talk
Subject: Browser Testing/Redirect...


What would be a good method to test a user's browser and see if they have
JavaScript and ActiveX controls enabled and Flash installed? If any are
disabled or not installed, I would like to re-direct the user to a site
requirements page. Thanks

 

Rye

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230284
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

Browser Testing/Redirect...

[Ryan Escamilla]

What would be a good method to test a user's browser and see if they have
JavaScript and ActiveX controls enabled and Flash installed? If any are
disabled or not installed, I would like to re-direct the user to a site
requirements page. Thanks

 

Rye



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230283
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: convert windows media file to flash video on the fly

[John C. Bland II]

Well you could write a custom app that accepts params via CF (command line
if need be) then fires ffmpeg accordingly. You could also write a directory
watcher (seen one somewhere online) to watch a directory for uploads and
fire off the custom app once something is fully ftp'd.

Just thoughts...

On 1/23/06, Bobby Hartsfield <[EMAIL PROTECTED]> wrote:
>
> From what I gather, FFmpeg is a command line utility though I've never
> used
> it, I have used Riva... which uses FFmpeg to do its conversions. As for
> CF,
> no. you'd probably have to write your own if that's the way you wanted to
> go
> with it. But encoding video files can be pretty strenuous on a machine and
> take quite a while.
>
> You'd probably be better off keeping a directory of the video files and
> use
> schedules to fire off a nightly task to convert video files from a
> specific
> directory or something.
>
> ..:.:.:.:.:.:.:.:.:.:.:.:.
> Bobby Hartsfield
> http://acoderslife.com
>
>
> -Original Message-
> From: Burns, John D [mailto:[EMAIL PROTECTED]
> Sent: Monday, January 23, 2006 4:47 PM
> To: CF-Talk
> Subject: RE: convert windows media file to flash video on the fly
>
> Bobby-
>
> Is this accessible via command line or something? I can't find any info
> on that or any way that it could be called from CF.
>
>
> John Burns
> Certified Advanced ColdFusion MX Developer
> Wyle Laboratories, Inc. | Web Developer
>
>
> -Original Message-
> From: Bobby Hartsfield [mailto:[EMAIL PROTECTED]
> Sent: Monday, January 23, 2006 4:38 PM
> To: CF-Talk
> Subject: RE: convert windows media file to flash video on the fly
>
> http://www.flashstreamworks.com/archive.php?post_id=1095873165
>
> "Riva just updated their free FLV Video encoder to version 1.2. The
> encoder is based on the FFMPEG video conversion command line tool (GNU
> LGPL)."
>
> FFMPG
> http://ffmpeg.sourceforge.net/index.php
>
>
> :.:.:.:.:.:.:.:.:.:.:.:.
> Bobby Hartsfield
> http://acoderslife.com
>
>
>
> -Original Message-
> From: Jason Rogoz [mailto:[EMAIL PROTECTED]
> Sent: Monday, January 23, 2006 4:31 PM
> To: CF-Talk
> Subject: convert windows media file to flash video on the fly
>
> Are they any plugings available that would allow one to upload a windows
> media file and convert it to a flash video file?
>
>
> Jason Rogoz
> Programmer / Analyst
>
> Zoom Communications Inc.
> Calgary, Alberta, Canada
>
> Office: (403) 229-2511
> Fax: (403) 229-4211
> Toll Free: 1-866-698-8932
>
> www.zoomcom.ca 
>
>
>
>
>
>
>
>
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230282
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: convert windows media file to flash video on the fly

[Bobby Hartsfield]

>From what I gather, FFmpeg is a command line utility though I've never used
it, I have used Riva... which uses FFmpeg to do its conversions. As for CF,
no. you'd probably have to write your own if that's the way you wanted to go
with it. But encoding video files can be pretty strenuous on a machine and
take quite a while.

You'd probably be better off keeping a directory of the video files and use
schedules to fire off a nightly task to convert video files from a specific
directory or something.

..:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com


-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 23, 2006 4:47 PM
To: CF-Talk
Subject: RE: convert windows media file to flash video on the fly

Bobby-

Is this accessible via command line or something? I can't find any info
on that or any way that it could be called from CF.


John Burns
Certified Advanced ColdFusion MX Developer
Wyle Laboratories, Inc. | Web Developer
 

-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 23, 2006 4:38 PM
To: CF-Talk
Subject: RE: convert windows media file to flash video on the fly

http://www.flashstreamworks.com/archive.php?post_id=1095873165

"Riva just updated their free FLV Video encoder to version 1.2. The
encoder is based on the FFMPEG video conversion command line tool (GNU
LGPL)."

FFMPG
http://ffmpeg.sourceforge.net/index.php


:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com



-Original Message-
From: Jason Rogoz [mailto:[EMAIL PROTECTED]
Sent: Monday, January 23, 2006 4:31 PM
To: CF-Talk
Subject: convert windows media file to flash video on the fly

Are they any plugings available that would allow one to upload a windows
media file and convert it to a flash video file?


Jason Rogoz
Programmer / Analyst

Zoom Communications Inc.
Calgary, Alberta, Canada

Office: (403) 229-2511
Fax: (403) 229-4211
Toll Free: 1-866-698-8932

www.zoomcom.ca  
 








~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230281
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: from 6 to 7

[Ray Champagne]

Aha!

After they finally escalated the issue to the higher-ups, I found the issue.

There are two DB apps running in background.  They have the server set 
up so that only one connection can be open at a time when connecting to 
Access DB's.  So, the scripts are timing out when concurrent requests 
are being made to two different Access DB's.  They claim that they 
worked with Macromedia and this was the solution to a "stability issue 
with Win2003".

Whatever - I guess it's time to upgrade to a SQL Server DB.

Thanks for the help and suggestions, guys.

Russ wrote:
> Well we all know how bad access can get under load... is it possible that
> they mapped it using the wrong db type?  I believe CF7 introduced MS Access
> vs MS Access Unicode.  Also are persistent connections to the db enabled?
> How big is the access file?  
> 
> If it's a big file, and persistent connections are not enabled, I can see it
> timing out form time to time.  
> 
> Russ
> 
> 
>>-Original Message-
>>From: Ray Champagne [mailto:[EMAIL PROTECTED]
>>Sent: Monday, January 23, 2006 4:55 PM
>>To: CF-Talk
>>Subject: Re: from 6 to 7
>>
>>Sorry, was out shoveling snow.  :(
>>
>>Nope, this is an Access DB.  I know that's not the best situation, but
>>like I said, it was my first project, and it worked fine on the other
>>server.
>>
>>And, just so it's known, I'm on a shared host, so there is no access to
>>anything outside my web root, including the administrator.
>>
>>Ray
>>
>>Jim Wright wrote:
>>
>>>That was where I was going...I just wanted to eliminate a local db
>>>like Access.  I don't think this is a shot in the dark...a lot of
>>>hosts out there these days are just renting equipment in others co-lo
>>>facilities...and often in more than one co-lo facility.  You want to
>>>make sure they are not pulling your data from one datacenter to
>>>anothernot just different segments of "their" network.
>>>
>>>On 1/23/06, Burns, John D <[EMAIL PROTECTED]> wrote:
>>>
>>>
As well as the question other have asked about "which database" are you
using, I also wonder if this server sits in a different segment of the
network than the previous one. If the server and the database are
further removed, they could have network issues that are causing longer
delays in the calls to the database. You may want to ask if there is a
database server in the same segment as your server that you could use
instead of your old one. That's a shot in the dark, but you may want to
research it.


John Burns
Certified Advanced ColdFusion MX Developer
Wyle Laboratories, Inc. | Web Developer


-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED]
Sent: Monday, January 23, 2006 3:26 PM
To: CF-Talk
Subject: from 6 to 7

Hey all:

I'm having an issue with my hosting company that I wanted to run by
everyone.

I've had a site up and running fine at this particular host for quite a
while now.  While it is not the most elegantly coded site (one of my
first large projects), it works fine.  To take advantage of newer
hosting options (more disk space), we migrated this site from a
CF6Win2000 server to a CF7 Win2003 server.  Now it seems like even the
most menial database queries are sometimes timing out.  Mind you, this
is not occurring all the time with the same query, it seems to be
happening with different queries at different times.

I'm now in a debate with said host - they are telling me that it's
because of my coding in general, they say I need to "upgrade" my coding
to adapt to CF7.  I say this is pure BS, a copout answer.  From what I
know, the release of CF7 was more a "features" release, so this
shouldn't matter, right?

Ray





>>>
>>>
>>>
>>
> 
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230280
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: convert windows media file to flash video on the fly

[John Dowdell]

Jason Rogoz wrote:
> Are they any plugings available that would allow one to upload a windows 
> media file and convert it to a flash video file?

The Macromedia Flash authoring tool can do this conversion, with most 
(if not all) of the codecs currently available in the Windows Media Player.

But from the rest of the conversation I'm wondering if you're looking 
for a serverside translation, unattended by human eyes? If so, that can 
get a little tricky, because the most desirable compression rates and 
frame rates are best performed from raw source file rather than 
arbitrary files which have already been compressed -- it's possible to 
get good results, but not guaranteed, depending on what type of content 
and initial .WMV compression settings were chosen.

 is the core problem here something like "How can I let any visitor 
upload any .WMV file from their local machine to my server, so that I 
can automatically re-deliver it to the widest range of audience menmbers 
in Flash Video format?" Or is the situation from the audience's 
viewpoint just a little bit different from that...?

jd





-- 
John Dowdell . Adobe Developer Support . San Francisco CA USA
Weblog: http://weblogs.macromedia.com/jd
Aggregator: http://weblogs.macromedia.com/mxna
Technotes: http://www.macromedia.com/support/
Spam killed my private email -- public record is best, thanks.

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230279
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: from 6 to 7

[Adkins, Randy]

When converting from 6 to 7, I as well experienced
Problems with using MS Access even with basic queries.

It came down to the drivers that was used. 
 

-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 23, 2006 4:55 PM
To: CF-Talk
Subject: Re: from 6 to 7

Sorry, was out shoveling snow.  :(

Nope, this is an Access DB.  I know that's not the best situation, but
like I said, it was my first project, and it worked fine on the other
server.

And, just so it's known, I'm on a shared host, so there is no access to
anything outside my web root, including the administrator.

Ray

Jim Wright wrote:
> That was where I was going...I just wanted to eliminate a local db 
> like Access.  I don't think this is a shot in the dark...a lot of 
> hosts out there these days are just renting equipment in others co-lo 
> facilities...and often in more than one co-lo facility.  You want to 
> make sure they are not pulling your data from one datacenter to 
> anothernot just different segments of "their" network.
> 
> On 1/23/06, Burns, John D <[EMAIL PROTECTED]> wrote:
> 
>>As well as the question other have asked about "which database" are 
>>you using, I also wonder if this server sits in a different segment of

>>the network than the previous one. If the server and the database are 
>>further removed, they could have network issues that are causing 
>>longer delays in the calls to the database. You may want to ask if 
>>there is a database server in the same segment as your server that you

>>could use instead of your old one. That's a shot in the dark, but you 
>>may want to research it.
>>
>>
>>John Burns
>>Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | 
>>Web Developer
>>
>>
>>-Original Message-
>>From: Ray Champagne [mailto:[EMAIL PROTECTED]
>>Sent: Monday, January 23, 2006 3:26 PM
>>To: CF-Talk
>>Subject: from 6 to 7
>>
>>Hey all:
>>
>>I'm having an issue with my hosting company that I wanted to run by 
>>everyone.
>>
>>I've had a site up and running fine at this particular host for quite 
>>a while now.  While it is not the most elegantly coded site (one of my

>>first large projects), it works fine.  To take advantage of newer 
>>hosting options (more disk space), we migrated this site from a 
>>CF6Win2000 server to a CF7 Win2003 server.  Now it seems like even the

>>most menial database queries are sometimes timing out.  Mind you, this

>>is not occurring all the time with the same query, it seems to be 
>>happening with different queries at different times.
>>
>>I'm now in a debate with said host - they are telling me that it's 
>>because of my coding in general, they say I need to "upgrade" my 
>>coding to adapt to CF7.  I say this is pure BS, a copout answer.  From

>>what I know, the release of CF7 was more a "features" release, so this

>>shouldn't matter, right?
>>
>>Ray
>>
>>
>>
>>
>>
> 
> 
> 



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230278
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: VdkAdminPurge

[Les Irvin]

While trying to index a verity collection.
Thanks,
Les 

-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 23, 2006 2:35 PM
To: CF-Talk
Subject: RE: VdkAdminPurge

In what context?



-Original Message-
From: Les Irvin [mailto:[EMAIL PROTECTED]
Sent: Monday, January 23, 2006 3:15 PM
To: CF-Talk
Subject: VdkAdminPurge


Anyone know what this error means?

Error occurred in tag CFINDEX
Error # -23 [ffe9] VdkAdminPurge

Thanks,
Les



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230277
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: from 6 to 7

[Russ]

Well we all know how bad access can get under load... is it possible that
they mapped it using the wrong db type?  I believe CF7 introduced MS Access
vs MS Access Unicode.  Also are persistent connections to the db enabled?
How big is the access file?  

If it's a big file, and persistent connections are not enabled, I can see it
timing out form time to time.  

Russ

> -Original Message-
> From: Ray Champagne [mailto:[EMAIL PROTECTED]
> Sent: Monday, January 23, 2006 4:55 PM
> To: CF-Talk
> Subject: Re: from 6 to 7
> 
> Sorry, was out shoveling snow.  :(
> 
> Nope, this is an Access DB.  I know that's not the best situation, but
> like I said, it was my first project, and it worked fine on the other
> server.
> 
> And, just so it's known, I'm on a shared host, so there is no access to
> anything outside my web root, including the administrator.
> 
> Ray
> 
> Jim Wright wrote:
> > That was where I was going...I just wanted to eliminate a local db
> > like Access.  I don't think this is a shot in the dark...a lot of
> > hosts out there these days are just renting equipment in others co-lo
> > facilities...and often in more than one co-lo facility.  You want to
> > make sure they are not pulling your data from one datacenter to
> > anothernot just different segments of "their" network.
> >
> > On 1/23/06, Burns, John D <[EMAIL PROTECTED]> wrote:
> >
> >>As well as the question other have asked about "which database" are you
> >>using, I also wonder if this server sits in a different segment of the
> >>network than the previous one. If the server and the database are
> >>further removed, they could have network issues that are causing longer
> >>delays in the calls to the database. You may want to ask if there is a
> >>database server in the same segment as your server that you could use
> >>instead of your old one. That's a shot in the dark, but you may want to
> >>research it.
> >>
> >>
> >>John Burns
> >>Certified Advanced ColdFusion MX Developer
> >>Wyle Laboratories, Inc. | Web Developer
> >>
> >>
> >>-Original Message-
> >>From: Ray Champagne [mailto:[EMAIL PROTECTED]
> >>Sent: Monday, January 23, 2006 3:26 PM
> >>To: CF-Talk
> >>Subject: from 6 to 7
> >>
> >>Hey all:
> >>
> >>I'm having an issue with my hosting company that I wanted to run by
> >>everyone.
> >>
> >>I've had a site up and running fine at this particular host for quite a
> >>while now.  While it is not the most elegantly coded site (one of my
> >>first large projects), it works fine.  To take advantage of newer
> >>hosting options (more disk space), we migrated this site from a
> >>CF6Win2000 server to a CF7 Win2003 server.  Now it seems like even the
> >>most menial database queries are sometimes timing out.  Mind you, this
> >>is not occurring all the time with the same query, it seems to be
> >>happening with different queries at different times.
> >>
> >>I'm now in a debate with said host - they are telling me that it's
> >>because of my coding in general, they say I need to "upgrade" my coding
> >>to adapt to CF7.  I say this is pure BS, a copout answer.  From what I
> >>know, the release of CF7 was more a "features" release, so this
> >>shouldn't matter, right?
> >>
> >>Ray
> >>
> >>
> >>
> >>
> >>
> >
> >
> >
> 
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230276
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: XML, SOAP and WDDX and CF5

[Ali Awan]

Thanks for the tips Dave,
I'll check those out before continuing on.

>You should first confirm exactly what XML you're receiving.
>
>Dave Watts, CTO, Fig Leaf Software
>http://www.figleaf.com/
>
>Fig Leaf Software provides the highest caliber vendor-authorized
>instruction at our training centers in Washington DC, Atlanta,
>Chicago, Baltimore, Northern Virginia, or on-site at your location.
>Visit http://training.figleaf.com/ for more information!

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230275
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: from 6 to 7

[Ray Champagne]

Sorry, was out shoveling snow.  :(

Nope, this is an Access DB.  I know that's not the best situation, but 
like I said, it was my first project, and it worked fine on the other 
server.

And, just so it's known, I'm on a shared host, so there is no access to 
anything outside my web root, including the administrator.

Ray

Jim Wright wrote:
> That was where I was going...I just wanted to eliminate a local db
> like Access.  I don't think this is a shot in the dark...a lot of
> hosts out there these days are just renting equipment in others co-lo
> facilities...and often in more than one co-lo facility.  You want to
> make sure they are not pulling your data from one datacenter to
> anothernot just different segments of "their" network.
> 
> On 1/23/06, Burns, John D <[EMAIL PROTECTED]> wrote:
> 
>>As well as the question other have asked about "which database" are you
>>using, I also wonder if this server sits in a different segment of the
>>network than the previous one. If the server and the database are
>>further removed, they could have network issues that are causing longer
>>delays in the calls to the database. You may want to ask if there is a
>>database server in the same segment as your server that you could use
>>instead of your old one. That's a shot in the dark, but you may want to
>>research it.
>>
>>
>>John Burns
>>Certified Advanced ColdFusion MX Developer
>>Wyle Laboratories, Inc. | Web Developer
>>
>>
>>-Original Message-
>>From: Ray Champagne [mailto:[EMAIL PROTECTED]
>>Sent: Monday, January 23, 2006 3:26 PM
>>To: CF-Talk
>>Subject: from 6 to 7
>>
>>Hey all:
>>
>>I'm having an issue with my hosting company that I wanted to run by
>>everyone.
>>
>>I've had a site up and running fine at this particular host for quite a
>>while now.  While it is not the most elegantly coded site (one of my
>>first large projects), it works fine.  To take advantage of newer
>>hosting options (more disk space), we migrated this site from a
>>CF6Win2000 server to a CF7 Win2003 server.  Now it seems like even the
>>most menial database queries are sometimes timing out.  Mind you, this
>>is not occurring all the time with the same query, it seems to be
>>happening with different queries at different times.
>>
>>I'm now in a debate with said host - they are telling me that it's
>>because of my coding in general, they say I need to "upgrade" my coding
>>to adapt to CF7.  I say this is pure BS, a copout answer.  From what I
>>know, the release of CF7 was more a "features" release, so this
>>shouldn't matter, right?
>>
>>Ray
>>
>>
>>
>>
>>
> 
> 
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230274
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: convert windows media file to flash video on the fly

[Bryan Stevenson]

> FFMPG
> http://ffmpeg.sourceforge.net/index.php

This is used by many viedo re-encoding packages out thereI use for AVI to 
MPG conversion...works great!!

I would not want this to be an "on-the-fly" process while the user waits.

AVI to MPG conversion takes as long to convert as it does to play the 
videoupt to twice as long or a bit more...

.so a user is not going and sit and wait all that time whilea video is 
converted.

Of course this conversion may take place at a different time...in which case 
ignore me ;-)

Cheers

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com 


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230273
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: convert windows media file to flash video on the fly

[Burns, John D]

Bobby-

Is this accessible via command line or something? I can't find any info
on that or any way that it could be called from CF.


John Burns
Certified Advanced ColdFusion MX Developer
Wyle Laboratories, Inc. | Web Developer
 

-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 23, 2006 4:38 PM
To: CF-Talk
Subject: RE: convert windows media file to flash video on the fly

http://www.flashstreamworks.com/archive.php?post_id=1095873165

"Riva just updated their free FLV Video encoder to version 1.2. The
encoder is based on the FFMPEG video conversion command line tool (GNU
LGPL)."

FFMPG
http://ffmpeg.sourceforge.net/index.php


...:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com



-Original Message-
From: Jason Rogoz [mailto:[EMAIL PROTECTED]
Sent: Monday, January 23, 2006 4:31 PM
To: CF-Talk
Subject: convert windows media file to flash video on the fly

Are they any plugings available that would allow one to upload a windows
media file and convert it to a flash video file?


Jason Rogoz
Programmer / Analyst

Zoom Communications Inc.
Calgary, Alberta, Canada

Office: (403) 229-2511
Fax: (403) 229-4211
Toll Free: 1-866-698-8932

www.zoomcom.ca  
 






~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230272
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: convert windows media file to flash video on the fly

[John C. Bland II]

I actually just did a preso on FFmpeg. It is strictly command line stuff but
it will (hopefully) help the learning curve for FFmpeg so you can easily
integrate it into your app.

We just used it for a Flash+Zinc app.

http://mmusergroup.breezecentral.com/p90631599/

On 1/23/06, Burns, John D <[EMAIL PROTECTED]> wrote:
>
> I've been searching for this as well. As far as I've found so far, there
> are no CFX or CFC wrapper tags available. I have, however, found a few
> command-line tools that can convert videos from one format to another
> (including FLV). If you search google for "command line video conversion
> flv" you should get a list of tools. You could then call them via
> CFEXECUTE. I'm not sure how flexible they are as far as resizing,
> resampling of audio/video rates, but if you're just looking at straight
> conversion, I don't see why, in theory, it wouldn't work.  If you find
> anything else please let me know as this is coming up on my horizon
> shortly.
>
>
> John Burns
> Certified Advanced ColdFusion MX Developer
> Wyle Laboratories, Inc. | Web Developer
>
>
> -Original Message-
> From: Jason Rogoz [mailto:[EMAIL PROTECTED]
> Sent: Monday, January 23, 2006 4:31 PM
> To: CF-Talk
> Subject: convert windows media file to flash video on the fly
>
> Are they any plugings available that would allow one to upload a windows
> media file and convert it to a flash video file?
>
>
> Jason Rogoz
> Programmer / Analyst
>
> Zoom Communications Inc.
> Calgary, Alberta, Canada
>
> Office: (403) 229-2511
> Fax: (403) 229-4211
> Toll Free: 1-866-698-8932
>
> www.zoomcom.ca 
>
>
>
>
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230271
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: convert windows media file to flash video on the fly

[Burns, John D]

I've been searching for this as well. As far as I've found so far, there
are no CFX or CFC wrapper tags available. I have, however, found a few
command-line tools that can convert videos from one format to another
(including FLV). If you search google for "command line video conversion
flv" you should get a list of tools. You could then call them via
CFEXECUTE. I'm not sure how flexible they are as far as resizing,
resampling of audio/video rates, but if you're just looking at straight
conversion, I don't see why, in theory, it wouldn't work.  If you find
anything else please let me know as this is coming up on my horizon
shortly. 


John Burns
Certified Advanced ColdFusion MX Developer
Wyle Laboratories, Inc. | Web Developer
 

-Original Message-
From: Jason Rogoz [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 23, 2006 4:31 PM
To: CF-Talk
Subject: convert windows media file to flash video on the fly

Are they any plugings available that would allow one to upload a windows
media file and convert it to a flash video file?


Jason Rogoz
Programmer / Analyst

Zoom Communications Inc.
Calgary, Alberta, Canada

Office: (403) 229-2511
Fax: (403) 229-4211
Toll Free: 1-866-698-8932

www.zoomcom.ca  
 




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230270
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: convert windows media file to flash video on the fly

[Bobby Hartsfield]

http://www.flashstreamworks.com/archive.php?post_id=1095873165

"Riva just updated their free FLV Video encoder to version 1.2. The encoder
is based on the FFMPEG video conversion command line tool (GNU LGPL)."

FFMPG
http://ffmpeg.sourceforge.net/index.php


..:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com



-Original Message-
From: Jason Rogoz [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 23, 2006 4:31 PM
To: CF-Talk
Subject: convert windows media file to flash video on the fly

Are they any plugings available that would allow one to upload a windows
media file and convert it to a flash video file?


Jason Rogoz
Programmer / Analyst

Zoom Communications Inc.
Calgary, Alberta, Canada

Office: (403) 229-2511
Fax: (403) 229-4211
Toll Free: 1-866-698-8932

www.zoomcom.ca  
 




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230269
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: VdkAdminPurge

[Andy Matthews]

In what context?



-Original Message-
From: Les Irvin [mailto:[EMAIL PROTECTED]
Sent: Monday, January 23, 2006 3:15 PM
To: CF-Talk
Subject: VdkAdminPurge


Anyone know what this error means?

Error occurred in tag CFINDEX
Error # -23 [ffe9] VdkAdminPurge

Thanks,
Les

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230268
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

Returning a binary char type from a mySQL query using ColdFusion

[Andy Matthews]

This is a really odd occurrence and I wonder if anyone has run into
themselves, or more importantly knows how to get around it.

I'm using ColdFusion 6.1 with mySQL 4.0. Here's my data structure:
eq_year - smallint(4)
mfr_name - varchar(60)
eq_model - varchar(12)

and the query:
SELECT CONCAT(' ', e.eq_year,' ', m.mfr_name,' ',e.eq_model) AS equipment
FROM equipment e
INNER JOIN manufacturer m
ON m.mfr_id = e.fk_mfr_id

The query itself runs just fine, but instead of returning a string for
"equipment", it returns a binary number. So I recall this sort of thing
happening before where the CAST function fixed it. So I try this query:
SELECT CONCAT(' ', CAST(e.eq_year AS CHAR),' ', m.mfr_name,' ',e.eq_model)
AS equipment
FROM equipment e
INNER JOIN manufacturer m
ON m.mfr_id = e.fk_mfr_id

And I get an error. Does anyone have any ideas about why this might be
happening? Just to point out that it also throws an error when running the
query straight in phpmyadmin. The easy solution would be to just convert the
eq_year field to a char field, but that seems stupid.





~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230267
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

convert windows media file to flash video on the fly

[Jason Rogoz]

Are they any plugings available that would allow one to upload a windows media 
file and convert it to a flash video file?


Jason Rogoz
Programmer / Analyst

Zoom Communications Inc.
Calgary, Alberta, Canada

Office: (403) 229-2511
Fax: (403) 229-4211
Toll Free: 1-866-698-8932

www.zoomcom.ca  
 


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230266
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: from 6 to 7

[Burns, John D]

As a side question, does the site appear to perform slower on the new
server? If not, it seems rather odd that the server times out
periodically trying to connect to the database but that it doesn't act
slower on regular page calls. As a quick fix, you could possibly
increase the timeout time for the connection to the database. That
doesn't solve the root problem, but may get it to at least stop timing
out. 


John Burns
Certified Advanced ColdFusion MX Developer
Wyle Laboratories, Inc. | Web Developer
 

-Original Message-
From: Jim Wright [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 23, 2006 4:05 PM
To: CF-Talk
Subject: Re: from 6 to 7

That was where I was going...I just wanted to eliminate a local db like
Access.  I don't think this is a shot in the dark...a lot of hosts out
there these days are just renting equipment in others co-lo
facilities...and often in more than one co-lo facility.  You want to
make sure they are not pulling your data from one datacenter to
anothernot just different segments of "their" network.

On 1/23/06, Burns, John D <[EMAIL PROTECTED]> wrote:
> As well as the question other have asked about "which database" are 
> you using, I also wonder if this server sits in a different segment of

> the network than the previous one. If the server and the database are 
> further removed, they could have network issues that are causing 
> longer delays in the calls to the database. You may want to ask if 
> there is a database server in the same segment as your server that you

> could use instead of your old one. That's a shot in the dark, but you 
> may want to research it.
>
>
> John Burns
> Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | 
> Web Developer
>
>
> -Original Message-
> From: Ray Champagne [mailto:[EMAIL PROTECTED]
> Sent: Monday, January 23, 2006 3:26 PM
> To: CF-Talk
> Subject: from 6 to 7
>
> Hey all:
>
> I'm having an issue with my hosting company that I wanted to run by 
> everyone.
>
> I've had a site up and running fine at this particular host for quite 
> a while now.  While it is not the most elegantly coded site (one of my

> first large projects), it works fine.  To take advantage of newer 
> hosting options (more disk space), we migrated this site from a 
> CF6Win2000 server to a CF7 Win2003 server.  Now it seems like even the

> most menial database queries are sometimes timing out.  Mind you, this

> is not occurring all the time with the same query, it seems to be 
> happening with different queries at different times.
>
> I'm now in a debate with said host - they are telling me that it's 
> because of my coding in general, they say I need to "upgrade" my 
> coding to adapt to CF7.  I say this is pure BS, a copout answer.  From

> what I know, the release of CF7 was more a "features" release, so this

> shouldn't matter, right?
>
> Ray
>
>
>
>
> 



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230265
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

VdkAdminPurge

[Les Irvin]

Anyone know what this error means?

Error occurred in tag CFINDEX
Error # -23 [ffe9] VdkAdminPurge

Thanks,
Les


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230264
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: from 6 to 7

[Jim Wright]

That was where I was going...I just wanted to eliminate a local db
like Access.  I don't think this is a shot in the dark...a lot of
hosts out there these days are just renting equipment in others co-lo
facilities...and often in more than one co-lo facility.  You want to
make sure they are not pulling your data from one datacenter to
anothernot just different segments of "their" network.

On 1/23/06, Burns, John D <[EMAIL PROTECTED]> wrote:
> As well as the question other have asked about "which database" are you
> using, I also wonder if this server sits in a different segment of the
> network than the previous one. If the server and the database are
> further removed, they could have network issues that are causing longer
> delays in the calls to the database. You may want to ask if there is a
> database server in the same segment as your server that you could use
> instead of your old one. That's a shot in the dark, but you may want to
> research it.
>
>
> John Burns
> Certified Advanced ColdFusion MX Developer
> Wyle Laboratories, Inc. | Web Developer
>
>
> -Original Message-
> From: Ray Champagne [mailto:[EMAIL PROTECTED]
> Sent: Monday, January 23, 2006 3:26 PM
> To: CF-Talk
> Subject: from 6 to 7
>
> Hey all:
>
> I'm having an issue with my hosting company that I wanted to run by
> everyone.
>
> I've had a site up and running fine at this particular host for quite a
> while now.  While it is not the most elegantly coded site (one of my
> first large projects), it works fine.  To take advantage of newer
> hosting options (more disk space), we migrated this site from a
> CF6Win2000 server to a CF7 Win2003 server.  Now it seems like even the
> most menial database queries are sometimes timing out.  Mind you, this
> is not occurring all the time with the same query, it seems to be
> happening with different queries at different times.
>
> I'm now in a debate with said host - they are telling me that it's
> because of my coding in general, they say I need to "upgrade" my coding
> to adapt to CF7.  I say this is pure BS, a copout answer.  From what I
> know, the release of CF7 was more a "features" release, so this
> shouldn't matter, right?
>
> Ray
>
>
>
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230263
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: from 6 to 7

[Burns, John D]

As well as the question other have asked about "which database" are you
using, I also wonder if this server sits in a different segment of the
network than the previous one. If the server and the database are
further removed, they could have network issues that are causing longer
delays in the calls to the database. You may want to ask if there is a
database server in the same segment as your server that you could use
instead of your old one. That's a shot in the dark, but you may want to
research it. 


John Burns
Certified Advanced ColdFusion MX Developer
Wyle Laboratories, Inc. | Web Developer
 

-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 23, 2006 3:26 PM
To: CF-Talk
Subject: from 6 to 7

Hey all:

I'm having an issue with my hosting company that I wanted to run by
everyone.

I've had a site up and running fine at this particular host for quite a
while now.  While it is not the most elegantly coded site (one of my
first large projects), it works fine.  To take advantage of newer
hosting options (more disk space), we migrated this site from a
CF6Win2000 server to a CF7 Win2003 server.  Now it seems like even the
most menial database queries are sometimes timing out.  Mind you, this
is not occurring all the time with the same query, it seems to be
happening with different queries at different times.

I'm now in a debate with said host - they are telling me that it's
because of my coding in general, they say I need to "upgrade" my coding
to adapt to CF7.  I say this is pure BS, a copout answer.  From what I
know, the release of CF7 was more a "features" release, so this
shouldn't matter, right?

Ray




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230262
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: from 6 to 7

[Jim Wright]

What database?
-jim

On 1/23/06, Ray Champagne <[EMAIL PROTECTED]> wrote:
> Hey all:
>
> I'm having an issue with my hosting company that I wanted to run by
> everyone.
>
> I've had a site up and running fine at this particular host for quite a
> while now.  While it is not the most elegantly coded site (one of my
> first large projects), it works fine.  To take advantage of newer
> hosting options (more disk space), we migrated this site from a
> CF6Win2000 server to a CF7 Win2003 server.  Now it seems like even the
> most menial database queries are sometimes timing out.  Mind you, this
> is not occurring all the time with the same query, it seems to be
> happening with different queries at different times.
>
> I'm now in a debate with said host - they are telling me that it's
> because of my coding in general, they say I need to "upgrade" my coding
> to adapt to CF7.  I say this is pure BS, a copout answer.  From what I
> know, the release of CF7 was more a
> "features" release, so this shouldn't matter, right?
>
> Ray
>
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230261
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: from 6 to 7

[Russ]

What database are you using?  Perhaps it's an issue with the database
drivers that came with CF7.  Also have you installed updater1?

> -Original Message-
> From: Ray Champagne [mailto:[EMAIL PROTECTED]
> Sent: Monday, January 23, 2006 3:26 PM
> To: CF-Talk
> Subject: from 6 to 7
> 
> Hey all:
> 
> I'm having an issue with my hosting company that I wanted to run by
> everyone.
> 
> I've had a site up and running fine at this particular host for quite a
> while now.  While it is not the most elegantly coded site (one of my
> first large projects), it works fine.  To take advantage of newer
> hosting options (more disk space), we migrated this site from a
> CF6Win2000 server to a CF7 Win2003 server.  Now it seems like even the
> most menial database queries are sometimes timing out.  Mind you, this
> is not occurring all the time with the same query, it seems to be
> happening with different queries at different times.
> 
> I'm now in a debate with said host - they are telling me that it's
> because of my coding in general, they say I need to "upgrade" my coding
> to adapt to CF7.  I say this is pure BS, a copout answer.  From what I
> know, the release of CF7 was more a
> "features" release, so this shouldn't matter, right?
> 
> Ray
> 
> 
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230260
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

updating cf

[Russ]

We're running CF 6.1 with all the relevant hotfixes.  A bug has seemed to
come up that is fixed in JRUN updater 4, but not in any CF hotfixes.  

 

Since CF runs on top of JRUN, do we need to install all the jrun updates
separately as well?  I though ColdFusion came with the relevant jrun updates
(when the updates are released)

 

Russ



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230259
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: Print to a printer

[Nathan C. Smith]

Some printers now have the ability to print from a mailbox using pop3.  You
might be able to set ColdFusion up to send a printer formatted message to
the pop3 mailbox that the printer could print from.

I think HPs and Xeroxes do this, maybe Lexmark, and probably others.

-Nate

-Original Message-
From: Robert Everland III [mailto:[EMAIL PROTECTED] 
Sent: Friday, January 20, 2006 8:06 AM
To: CF-Talk
Subject: Print to a printer


I have a perl script that prints directly to a printer when a user submits a
form. Is there a way that ColdFusion can do this through Java? Has anyone
done this before. The printer will be attached to my network locally.



Bob



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230258
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: Why does this happen with SQL Server 2000 and CFML?

[Kevin Penny]

Not sure why you'd want to convert a date to float - but try datetime or
smalldatetime instead of converting to float and you should have no issues -


Check BOL for conversion types to/from and the matrix grid - 


Kevin Penny, MMCP
[EMAIL PROTECTED]
Lead Developer, HotGigs.com
 "Not now I'm multitasking"
 
-Original Message-
From: Richard Dillman [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 19, 2006 4:07 PM
To: CF-Talk
Subject: Why does this happen with SQL Server 2000 and CFML?

 
  Select convert(float,getdate()) as datetimefromdb
 

 
  display that with: #val(datetimefromdb - 0)#
  Returns 38734.6939544 (or whatever date/time it is)

  display that with: #dateformat(val(datetimefromdb-0), "dd-mmm-yy")#
  Returns 17-Jan-06 (what? thats 2 days ago)
 

Now use select getdate() as datetimefromdb in your Query

 
  select getdate() as datetimefromdb
 

 
  display that with: #val(datetimefromdb - 0)#
  Returns 38736.6939468 (hrm differen date)

  display that with: #dateformat(val(datetimefromdb-0), "dd-mmm-yy")#
  Returns 19-Jan-06 (success todays date)
 

But why would i get 2 different dates?


--
Richard Dillman

"The most important step is always the first one."




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230257
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: CF 7 and CFDUMP

[Bryan Stevenson]

I should add that there is NOTHING in the code that would force a page refresh!!

I've just confrimed this by removing the CFDUMPs and replaced with good old 
CFOUTPUT and all works as intended!!

Anybody?

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com 


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230256
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

from 6 to 7

[Ray Champagne]

Hey all:

I'm having an issue with my hosting company that I wanted to run by 
everyone.

I've had a site up and running fine at this particular host for quite a 
while now.  While it is not the most elegantly coded site (one of my 
first large projects), it works fine.  To take advantage of newer 
hosting options (more disk space), we migrated this site from a 
CF6Win2000 server to a CF7 Win2003 server.  Now it seems like even the 
most menial database queries are sometimes timing out.  Mind you, this 
is not occurring all the time with the same query, it seems to be 
happening with different queries at different times.

I'm now in a debate with said host - they are telling me that it's 
because of my coding in general, they say I need to "upgrade" my coding 
to adapt to CF7.  I say this is pure BS, a copout answer.  From what I 
know, the release of CF7 was more a
"features" release, so this shouldn't matter, right?

Ray


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230255
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: CFScript Quick Reference Guide?

[Brandon Harper]

On 1/23/06, Charlie Griefer <[EMAIL PROTECTED]> wrote:
>
> any specific questions that we can take a shot at tho?
>

I know CFScript just fine so I don't have any questions about it, I
was just looking for an old "Quick Start" guide that I used to have--
but thanks. :)

I finally found it.. I've posted it here in case someone else would like it:

http://www.content-type.com/-1407484951/cfscript.pdf.htm

Unfortunately my VOIP router at home locks-up every so often and today
is one of those days, so I'm unable to upload it to my server at home
at the moment.. sorry.

Thanks,

- Brandon

--
http://devnulled.com

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230254
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: XML, SOAP and WDDX and CF5

[Dave Watts]

> The client I am working with will be sending me an XML packet 
> via an HTTP POST.
> 
> So I assume it's a SOAP packet.

I wouldn't make that assumption. It could be any sort of XML at all, unless
you've specifically agreed to use SOAP.

> Is it possible to use WDDX to grab that packet and manipulate 
> it as needed?

Only if the XML is, in fact, WDDX. If it's SOAP, it's not WDDX.

> Is it possible to parse that packet as straight text?  If so, how?

You could, but, ugh. You should be able to read it using the
GetHTTPRequestData function, which was introduced in CF 5. But again, ugh.
I'd use an external XML parser from CF - if you're using Windows, look into
the MSXML COM object.

> Or do I need to install a customtag that deals with SOAP, exclusively?

You should first confirm exactly what XML you're receiving.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230253
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: XML, SOAP and WDDX and CF5

[Ali Awan]

Thanks for the input Alan.

However this is an app for the client, and CF5 is what we are stuck with.

Eventually, we will upgrade to MX7, we all agree, but until then we have to
use what we got to pay the bills and keep everyone's mouths fed.

:-)

 

>If you have any say in the matter I would try to use CFMX or CFMX7.

> 

>--

>Alan Rother

>Macromedia Certified Advanced ColdFusion MX 7 Developer



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230252
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: XML, SOAP and WDDX and CF5

[Alan Rother]

Well, first WDDX is not in itself a tool, it's standardized XML format. So
for you to use WDDX to grab the file, it would need to be a valid WDDX type
xml file.

When the customer posts the XML file to you Cold Fusion page you will need
to parse out the XML file and as I recall, doing that in CF5 is a big pain.

If you have any say in the matter I would try to use CFMX or CFMX7.

--
Alan Rother
Macromedia Certified Advanced ColdFusion MX 7 Developer


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230251
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

XML, SOAP and WDDX and CF5

[Ali Awan]

I am in the processing of writing a CF application in CF5.  

The client I am working with will be sending me an XML packet via an HTTP
POST.

So I assume it's a SOAP packet.

 

Is it possible to use WDDX to grab that packet and manipulate it as needed?

Is it possible to parse that packet as straight text?  If so, how?

Or do I need to install a customtag that deals with SOAP, exclusively?

 

Thanks in advance,

Ali

 



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230250
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

CF 7 and CFDUMP

[Bryan Stevenson]

Hey All,

Is there an issue with CFDUMP on MX 7?

We're running some data intensive scripts with cfdumps along the way to ensure 
all is going smoothly.  It seems that using cfdump instead of cfoutput to dump 
vars, the page will display partially (almost like CFFLUSH allows for) and then 
the page refreshes...each time showing the same set of output it did before.

Any insight?

TIA

Cheers

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230249
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: Audio conversion CFX tag, cfc, etc?

[Bobby Hartsfield]

I don’t think it has any kind of command line interface but I use Riva for
converting videos to FLV's.

..:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
 
 

-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 23, 2006 12:43 PM
To: CF-Talk
Subject: RE: Audio conversion CFX tag, cfc, etc?

Yeah, the ID3 stuff can be read by java too, that's why I was wondering
if someone made a cfc wrapper that used a java library to do the
conversion.  The command line program I found is at
http://www.audconv.com/  All I did was search for "command line audio
converter" on google and that returned quite a few results. I'm not sure
what kind of speed these work at and how well they work, but I'm going
to do some testing to see. The software only costs like $20 so if it
works it would be pretty neat. I'm not sure if it would be something
you'd want a web request waiting on, but it could always be put in a
queue and triggered as a scheduled task (either by CF or by a windows
scheduled task).

Just fyi, I was searching for something similar to convert video files
to flv and found a couple of programs that claim to do it. I'm not sure
how flexible or reliable they are since video settings get a little more
complicated than audio, but I'm definitely going to try it out. 


John Burns
Certified Advanced ColdFusion MX Developer
Wyle Laboratories, Inc. | Web Developer
 

-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 23, 2006 11:09 AM
To: CF-Talk
Subject: RE: Audio conversion CFX tag, cfc, etc?

I'd be very surprised if you found a tag/cfc to do that. You'll most
likely have to roll your own using whatever command line tool you've
found. But by all means... if I'm wrong... do share :-)

What command line utility did you find? Windows? Linux?

The only thing I've seen that was remotely related was just a tag to
read the ID3 tags of mp3s (maybe some other formats too), file size,
track lengths, titles, artists, etc... it was called CFX_AudioInfo. It's
not what you are looking for but may come in handy with what you are
doing.


:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com


-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: Monday, January 23, 2006 9:44 AM
To: CF-Talk
Subject: Audio conversion CFX tag, cfc, etc?

I've been looking for a CFX or CFC tag that can take in an audio file in
various formats (the more the better) and convert to MP3. I've found
some command-line tools that can do conversions and I've considered
using CFEXECUTE to call that but I'm curious if anyone has some java
code in a CFC wrapper or if there's a good CFX tag out there to do this
type of thing more elegantly than CFEXECUTE to a command-line program.
All we really need to be able to control is the input file, the output
path and the bitrate of the MP3. If the tag returns a final file size or
something like that, that would be an added bonus. Please let me know if
you have experience with this or know of a product. Thanks!
 
John Burns
Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web
Developer
 
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.14.21/236 - Release Date:
1/20/2006
 

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.14.21/236 - Release Date:
1/20/2006
 







~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230248
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: CFScript Quick Reference Guide?

[Michael Traher]

how about
http://livedocs.macromedia.com/coldfusion/7/htmldocs/0970.htm#1106683


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230247
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: CFScript Quick Reference Guide?

[Dave Watts]

> A Java programmer I work with is working on integrating 
> something in Java to CF and keeps asking me control structure 
> questions about CFScript.  I've googled for the last 15 
> minutes without any luck finding it unfortunately.  Any help 
> would be appreciated.

They're the same as in JavaScript 1.0, I think. Of course, you can't use JS
expressions, only CFML expressions.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230246
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: CFScript Quick Reference Guide?

[Jim Davis]

> -Original Message-
> From: Charlie Griefer [mailto:[EMAIL PROTECTED]
> Sent: Monday, January 23, 2006 1:29 PM
> To: CF-Talk
> Subject: Re: CFScript Quick Reference Guide?
> 
> i remember the doc you're referring to...i used to have it printed
> out, but don't remember where I got it from now (it's been a while) :\

Didn't Mike D author such a beastie?

Here's the HTML version: http://www.houseoffusion.com/docs/cfscript/

But I coulda sweared he had a PDF as well.

Jim Davis



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230245
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: CFScript Quick Reference Guide?

[Charlie Griefer]

i remember the doc you're referring to...i used to have it printed
out, but don't remember where I got it from now (it's been a while) :\

any specific questions that we can take a shot at tho?

On 1/23/06, Brandon Harper <[EMAIL PROTECTED]> wrote:
> Some time ago I had a PDF which was a quick reference to CFScript.  It
> was basically a quick and dirty two page overview which showed the
> various control structures available in CFScript.   I've not needed it
> in quite a long time and don't seem to have it around any longer.
> That said, I was curious to see if anyone knows what document I'm
> talking about and happens to have a copy or knows where I can get it
> again?
>
> A Java programmer I work with is working on integrating something in
> Java to CF and keeps asking me control structure questions about
> CFScript.  I've googled for the last 15 minutes without any luck
> finding it unfortunately.  Any help would be appreciated.
>
> Thanks,
>
> - Brandon
>
> --
> http://devnulled.com
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230244
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: storing query results while paging through

[Dave Watts]

> When you say it differentiats by the actual SQL, does that 
> include cfqueryparams? Or is the sql considered the same just 
> with different params? I had some problems at one point and 
> thought that might be the issue. I was just curious if you knew.

For some reason, the CACHEDWITHIN/CACHEDAFTER attributes cannot be used with
queries that contain CFQUERYPARAMs. This is kind of a bummer.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230243
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: storing query results while paging through

[George Abraham]

Well,
I completely forgot that we were using stored procedures for our db calls.
So the cachedwithin property goes out the window. Now I am just storing the
storedproc results in the session scope and using them from there.

Thanks,
George

On 1/23/06, Justin D. Scott <[EMAIL PROTECTED]> wrote:
>
> The cache is based on the query name, as well as the actual query going to
> the SQL server.  If the search string is different, then the query would
> be
> different, so it would get cached independently of the others.
>
> Note that if you are using cfqueryparam in the query, it cannot be cached
> with cachedwithin.
>
> -Justin
>
>
>
> > -Original Message-
> > From: George Abraham [mailto:[EMAIL PROTECTED]
> > Sent: Monday, January 23, 2006 12:13 PM
> > To: CF-Talk
> > Subject: Re: storing query results while paging through
> >
> > Justin,
> > Suppose the query is named 'getResults' and I have enabled
> > the cachedwithin
> > attribute. Say user1 comes along and searches for 'Portugal'.
> > The query
> > 'getResults' is cached. Then user2 comes along and searches
> > for 'Spain'.
> > This happens while user1 is paging through the resultset for
> > 'Portugal'.
> > Then user3 comes along (while the sessions for user1 and
> > user2 are still on)
> > and searches for 'Argentina'. What happens to the cache for
> > 'getResults'
> > while all this is happening? How does CFMX 7 (which I am on)
> > handle all
> > these interactions for cached queries?
> >
> > Thanks,
> > George
> >
> > On 1/23/06, Justin D. Scott <[EMAIL PROTECTED]> wrote:
> > >
> > > Assuming your query pulls all of the results and you use
> > the startrow and
> > > maxrows attributes when outputting, you could just use the
> > cachedwithin
> > > attribute of cfquery itself to store the results in memory
> > without all the
> > > fuss of session variables.  This will also have the benefit
> > of using the
> > > same cache if multiple sessions search for the same thing
> > while it's in
> > > the
> > > cache.
> > >
> > > -Justin
> > >
> > >
> > >
> > > > -Original Message-
> > > > From: George Abraham [mailto:[EMAIL PROTECTED]
> > > > Sent: Monday, January 23, 2006 10:34 AM
> > > > To: CF-Talk
> > > > Subject: storing query results while paging through
> > > >
> > > > All,
> > > > I don't use session variables at all, but this might a good
> > > > time to use
> > > > them.
> > > >
> > > > I have a search page that takes in a search term, runs a
> > > > query and then
> > > > displays the results. The user is allowed to click into a
> > > > result and then
> > > > page through the search resultset while in a result (via
> > Previous/Next
> > > > controls). Since I don't store the query results anywhere, I
> > > > basically run
> > > > that query every single time that the user presses Previous
> > > > or Next (just so
> > > > that I can find out where the user is while s/he is paging
> > > > through and what
> > > > the previous and next results are.) For an intensive search
> > > > (which this is
> > > > turning out to be), this means every time that the user does
> > > > anything with
> > > > the resultset, I am running a 4 or 5 second operation. Highly
> > > > inefficient, I
> > > > suspect.
> > > >
> > > > How do I cache the query results? Is a session variable the
> > > > best option? I
> > > > guess cookies would not be bad, but they are limited in the
> > > > amount they can
> > > > hold. How do people tackle this problem anyway?
> > > >
> > > > Thanks,
> > > > George
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230242
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: Audio conversion CFX tag, cfc, etc?

[Burns, John D]

Yeah, the ID3 stuff can be read by java too, that's why I was wondering
if someone made a cfc wrapper that used a java library to do the
conversion.  The command line program I found is at
http://www.audconv.com/  All I did was search for "command line audio
converter" on google and that returned quite a few results. I'm not sure
what kind of speed these work at and how well they work, but I'm going
to do some testing to see. The software only costs like $20 so if it
works it would be pretty neat. I'm not sure if it would be something
you'd want a web request waiting on, but it could always be put in a
queue and triggered as a scheduled task (either by CF or by a windows
scheduled task).

Just fyi, I was searching for something similar to convert video files
to flv and found a couple of programs that claim to do it. I'm not sure
how flexible or reliable they are since video settings get a little more
complicated than audio, but I'm definitely going to try it out. 


John Burns
Certified Advanced ColdFusion MX Developer
Wyle Laboratories, Inc. | Web Developer
 

-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 23, 2006 11:09 AM
To: CF-Talk
Subject: RE: Audio conversion CFX tag, cfc, etc?

I'd be very surprised if you found a tag/cfc to do that. You'll most
likely have to roll your own using whatever command line tool you've
found. But by all means... if I'm wrong... do share :-)

What command line utility did you find? Windows? Linux?

The only thing I've seen that was remotely related was just a tag to
read the ID3 tags of mp3s (maybe some other formats too), file size,
track lengths, titles, artists, etc... it was called CFX_AudioInfo. It's
not what you are looking for but may come in handy with what you are
doing.


...:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com


-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: Monday, January 23, 2006 9:44 AM
To: CF-Talk
Subject: Audio conversion CFX tag, cfc, etc?

I've been looking for a CFX or CFC tag that can take in an audio file in
various formats (the more the better) and convert to MP3. I've found
some command-line tools that can do conversions and I've considered
using CFEXECUTE to call that but I'm curious if anyone has some java
code in a CFC wrapper or if there's a good CFX tag out there to do this
type of thing more elegantly than CFEXECUTE to a command-line program.
All we really need to be able to control is the input file, the output
path and the bitrate of the MP3. If the tag returns a final file size or
something like that, that would be an added bonus. Please let me know if
you have experience with this or know of a product. Thanks!
 
John Burns
Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web
Developer
 
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.14.21/236 - Release Date:
1/20/2006
 

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.14.21/236 - Release Date:
1/20/2006
 





~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230241
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 License Change

[David McCan]

Thanks Casey.  I will check it out.  I also found this last night:

http://www.ignitefusion.com/default.htm

I submitted a post to the New Atlanta list as Charlie requested.  

David


>Sorry to add to an already blunted topic but for those who wish to get
>rid of licencing agreements... please check out my previous question
>on this crap.
>
>http://houseoffusion.com/cf_lists/messages.cfm/forumid:4/threadid:43959
>
>
>Someone must be using Coral Web Builder.
>
>
>Other than that, get over it and Buy Coldfusion or BlueDragon
>
>Casey
>
>On 1/22/06, Yves Arsenault <[EMAIL PROTECTED]> wrote:
>>

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230240
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: storing query results while paging through

[Burns, John D]

Dave-

When you say it differentiats by the actual SQL, does that include
cfqueryparams? Or is the sql considered the same just with different
params? I had some problems at one point and thought that might be the
issue. I was just curious if you knew. 


John Burns
Certified Advanced ColdFusion MX Developer
Wyle Laboratories, Inc. | Web Developer
 

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 23, 2006 12:44 PM
To: CF-Talk
Subject: RE: storing query results while paging through

> Ah, so there is a diffrentiation by connection as well (hence by 
> session)? I knew that there was a diffrentiation by actual SQL 
> statement. That is good to know.

Well, I oversimplified a bit when I said "connection". CF uses the
connection information - username, password, datasource - to
differentiate queries.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta, Chicago,
Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230239
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

CFScript Quick Reference Guide?

[Brandon Harper]

Some time ago I had a PDF which was a quick reference to CFScript.  It
was basically a quick and dirty two page overview which showed the
various control structures available in CFScript.   I've not needed it
in quite a long time and don't seem to have it around any longer. 
That said, I was curious to see if anyone knows what document I'm
talking about and happens to have a copy or knows where I can get it
again?

A Java programmer I work with is working on integrating something in
Java to CF and keeps asking me control structure questions about
CFScript.  I've googled for the last 15 minutes without any luck
finding it unfortunately.  Any help would be appreciated.

Thanks,

- Brandon

--
http://devnulled.com

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230238
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: storing query results while paging through

[Dave Watts]

> Ah, so there is a diffrentiation by connection as well (hence 
> by session)? I knew that there was a diffrentiation by actual 
> SQL statement. That is good to know.

Well, I oversimplified a bit when I said "connection". CF uses the
connection information - username, password, datasource - to differentiate
queries.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230237
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: storing query results while paging through

[Dawson, Michael]

By "connection" he means database connection from the CF server to the
DB server.

This is not related to a session.  Since it is not related to a session,
many users can "share" the *exact* same query.

M!ke 

-Original Message-
From: George Abraham [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 23, 2006 11:34 AM
To: CF-Talk
Subject: Re: storing query results while paging through

On 1/23/06, Dave Watts <[EMAIL PROTECTED]> wrote:
>
> When you use CACHEDWITHIN/CACHEDAFTER, CF identifies cached queries 
> not just by name, but by connection and by the actual SQL statement. 
> So, each user would generate their own cached query, and CF would only

> reuse one of them if another request used one of the 
> previously-entered search criteria.


Ah, so there is a diffrentiation by connection as well (hence by
session)? I knew that there was a diffrentiation by actual SQL
statement. That is good to know.

Thanks all!
George

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230236
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: storing query results while paging through

[Justin D. Scott]

The cache is based on the query name, as well as the actual query going to
the SQL server.  If the search string is different, then the query would be
different, so it would get cached independently of the others.

Note that if you are using cfqueryparam in the query, it cannot be cached
with cachedwithin.

-Justin

 

> -Original Message-
> From: George Abraham [mailto:[EMAIL PROTECTED] 
> Sent: Monday, January 23, 2006 12:13 PM
> To: CF-Talk
> Subject: Re: storing query results while paging through
> 
> Justin,
> Suppose the query is named 'getResults' and I have enabled 
> the cachedwithin
> attribute. Say user1 comes along and searches for 'Portugal'. 
> The query
> 'getResults' is cached. Then user2 comes along and searches 
> for 'Spain'.
> This happens while user1 is paging through the resultset for 
> 'Portugal'.
> Then user3 comes along (while the sessions for user1 and 
> user2 are still on)
> and searches for 'Argentina'. What happens to the cache for 
> 'getResults'
> while all this is happening? How does CFMX 7 (which I am on) 
> handle all
> these interactions for cached queries?
> 
> Thanks,
> George
> 
> On 1/23/06, Justin D. Scott <[EMAIL PROTECTED]> wrote:
> >
> > Assuming your query pulls all of the results and you use 
> the startrow and
> > maxrows attributes when outputting, you could just use the 
> cachedwithin
> > attribute of cfquery itself to store the results in memory 
> without all the
> > fuss of session variables.  This will also have the benefit 
> of using the
> > same cache if multiple sessions search for the same thing 
> while it's in
> > the
> > cache.
> >
> > -Justin
> >
> >
> >
> > > -Original Message-
> > > From: George Abraham [mailto:[EMAIL PROTECTED]
> > > Sent: Monday, January 23, 2006 10:34 AM
> > > To: CF-Talk
> > > Subject: storing query results while paging through
> > >
> > > All,
> > > I don't use session variables at all, but this might a good
> > > time to use
> > > them.
> > >
> > > I have a search page that takes in a search term, runs a
> > > query and then
> > > displays the results. The user is allowed to click into a
> > > result and then
> > > page through the search resultset while in a result (via 
> Previous/Next
> > > controls). Since I don't store the query results anywhere, I
> > > basically run
> > > that query every single time that the user presses Previous
> > > or Next (just so
> > > that I can find out where the user is while s/he is paging
> > > through and what
> > > the previous and next results are.) For an intensive search
> > > (which this is
> > > turning out to be), this means every time that the user does
> > > anything with
> > > the resultset, I am running a 4 or 5 second operation. Highly
> > > inefficient, I
> > > suspect.
> > >
> > > How do I cache the query results? Is a session variable the
> > > best option? I
> > > guess cookies would not be bad, but they are limited in the
> > > amount they can
> > > hold. How do people tackle this problem anyway?
> > >
> > > Thanks,
> > > George
> > >
> > >
> > >
> >
> > 
> 
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230235
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: storing query results while paging through

[George Abraham]

On 1/23/06, Dave Watts <[EMAIL PROTECTED]> wrote:
>
> When you use CACHEDWITHIN/CACHEDAFTER, CF identifies cached queries not
> just
> by name, but by connection and by the actual SQL statement. So, each user
> would generate their own cached query, and CF would only reuse one of them
> if another request used one of the previously-entered search criteria.


Ah, so there is a diffrentiation by connection as well (hence by session)? I
knew that there was a diffrentiation by actual SQL statement. That is good
to know.

Thanks all!
George


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230234
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: storing query results while paging through

[Dave Watts]

> Suppose the query is named 'getResults' and I have enabled 
> the cachedwithin attribute. Say user1 comes along and 
> searches for 'Portugal'. The query 'getResults' is cached. 
> Then user2 comes along and searches for 'Spain'.
> This happens while user1 is paging through the resultset for 
> 'Portugal'.
> Then user3 comes along (while the sessions for user1 and 
> user2 are still on) and searches for 'Argentina'. What 
> happens to the cache for 'getResults'
> while all this is happening? How does CFMX 7 (which I am on) 
> handle all these interactions for cached queries?

When you use CACHEDWITHIN/CACHEDAFTER, CF identifies cached queries not just
by name, but by connection and by the actual SQL statement. So, each user
would generate their own cached query, and CF would only reuse one of them
if another request used one of the previously-entered search criteria.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230233
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: SeeFusion versus FusionReactor [was: Monitoring JRun Memory U sage]

[Snake]

Well that probably wouldn't help if the JVM fell over.
What I have always done up till now, is have a cf app that monitor other cf
apps and servers. Of course running on another server.

Russ 

-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED] 
Sent: 23 January 2006 15:20
To: CF-Talk
Subject: RE: SeeFusion versus FusionReactor [was: Monitoring JRun Memory U
sage]

Russ,  I know what you mean re: UI, it does look better.

Write your own in what way - using java?







-Original Message-
From: Snake [mailto:[EMAIL PROTECTED]
Sent: 23 January 2006 15:15
To: CF-Talk
Subject: RE: SeeFusion versus FusionReactor [was: Monitoring JRun Memory
Usage]

I'm a stickler for nice UI.
So I didn't really like seeFusion.
Fusion Reactor is on use on one of our servers and has stopped a few crashes
and tells me what site was timing out when it happened. Which actually
doesn't seem to be at all related, but there you go.
Fusion Reactor just looks more professional to me.
But all things considered, I probably will still write my own.

Russ 

-Original Message-
From: Nick de Voil [mailto:[EMAIL PROTECTED]
Sent: 23 January 2006 12:24
To: CF-Talk
Subject: SeeFusion versus FusionReactor [was: Monitoring JRun Memory Usage]

> How does it compare to SeeFusion?

> > U might want to have a look at fusion reactor.

I haven't used either of them yet - if anyone has used both, it would be
great to hear what you think.

Nick









~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230232
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: storing query results while paging through

[George Abraham]

Justin,
Suppose the query is named 'getResults' and I have enabled the cachedwithin
attribute. Say user1 comes along and searches for 'Portugal'. The query
'getResults' is cached. Then user2 comes along and searches for 'Spain'.
This happens while user1 is paging through the resultset for 'Portugal'.
Then user3 comes along (while the sessions for user1 and user2 are still on)
and searches for 'Argentina'. What happens to the cache for 'getResults'
while all this is happening? How does CFMX 7 (which I am on) handle all
these interactions for cached queries?

Thanks,
George

On 1/23/06, Justin D. Scott <[EMAIL PROTECTED]> wrote:
>
> Assuming your query pulls all of the results and you use the startrow and
> maxrows attributes when outputting, you could just use the cachedwithin
> attribute of cfquery itself to store the results in memory without all the
> fuss of session variables.  This will also have the benefit of using the
> same cache if multiple sessions search for the same thing while it's in
> the
> cache.
>
> -Justin
>
>
>
> > -Original Message-
> > From: George Abraham [mailto:[EMAIL PROTECTED]
> > Sent: Monday, January 23, 2006 10:34 AM
> > To: CF-Talk
> > Subject: storing query results while paging through
> >
> > All,
> > I don't use session variables at all, but this might a good
> > time to use
> > them.
> >
> > I have a search page that takes in a search term, runs a
> > query and then
> > displays the results. The user is allowed to click into a
> > result and then
> > page through the search resultset while in a result (via Previous/Next
> > controls). Since I don't store the query results anywhere, I
> > basically run
> > that query every single time that the user presses Previous
> > or Next (just so
> > that I can find out where the user is while s/he is paging
> > through and what
> > the previous and next results are.) For an intensive search
> > (which this is
> > turning out to be), this means every time that the user does
> > anything with
> > the resultset, I am running a 4 or 5 second operation. Highly
> > inefficient, I
> > suspect.
> >
> > How do I cache the query results? Is a session variable the
> > best option? I
> > guess cookies would not be bad, but they are limited in the
> > amount they can
> > hold. How do people tackle this problem anyway?
> >
> > Thanks,
> > George
> >
> >
> >
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230231
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: storing query results while paging through

[Robertson-Ravo, Neil (RX)]

Well,  lots of options.  At present I am using mainly BXML/Backbase.



-Original Message-
From: Wayne Putterill [mailto:[EMAIL PROTECTED] 
Sent: 23 January 2006 16:24
To: CF-Talk
Subject: Re: storing query results while paging through

As a side note to this, what are the options for paging with regards
to Ajax or Flash these days? I'm just wondering if there is something
out there that I should be considering for future use.

On 1/23/06, George Abraham  wrote:
> All,
> I don't use session variables at all, but this might a good time to use
> them.
>
> I have a search page that takes in a search term, runs a query and then
> displays the results. The user is allowed to click into a result and then
> page through the search resultset while in a result (via Previous/Next
> controls). Since I don't store the query results anywhere, I basically run
> that query every single time that the user presses Previous or Next (just
so
> that I can find out where the user is while s/he is paging through and
what
> the previous and next results are.) For an intensive search (which this is
> turning out to be), this means every time that the user does anything with
> the resultset, I am running a 4 or 5 second operation. Highly inefficient,
I
> suspect.
>
> How do I cache the query results? Is a session variable the best option? I
> guess cookies would not be bad, but they are limited in the amount they
can
> hold. How do people tackle this problem anyway?
>
> Thanks,
> George
>
>
> 



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230230
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: storing query results while paging through

[Wayne Putterill]

As a side note to this, what are the options for paging with regards
to Ajax or Flash these days? I'm just wondering if there is something
out there that I should be considering for future use.

On 1/23/06, George Abraham <[EMAIL PROTECTED]> wrote:
> All,
> I don't use session variables at all, but this might a good time to use
> them.
>
> I have a search page that takes in a search term, runs a query and then
> displays the results. The user is allowed to click into a result and then
> page through the search resultset while in a result (via Previous/Next
> controls). Since I don't store the query results anywhere, I basically run
> that query every single time that the user presses Previous or Next (just so
> that I can find out where the user is while s/he is paging through and what
> the previous and next results are.) For an intensive search (which this is
> turning out to be), this means every time that the user does anything with
> the resultset, I am running a 4 or 5 second operation. Highly inefficient, I
> suspect.
>
> How do I cache the query results? Is a session variable the best option? I
> guess cookies would not be bad, but they are limited in the amount they can
> hold. How do people tackle this problem anyway?
>
> Thanks,
> George
>
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230229
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: Audio conversion CFX tag, cfc, etc?

[Bobby Hartsfield]

I'd be very surprised if you found a tag/cfc to do that. You'll most likely
have to roll your own using whatever command line tool you've found. But by
all means... if I'm wrong... do share :-)

What command line utility did you find? Windows? Linux?

The only thing I've seen that was remotely related was just a tag to read
the ID3 tags of mp3s (maybe some other formats too), file size, track
lengths, titles, artists, etc... it was called CFX_AudioInfo. It's not what
you are looking for but may come in handy with what you are doing.


..:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com


-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 23, 2006 9:44 AM
To: CF-Talk
Subject: Audio conversion CFX tag, cfc, etc?

I've been looking for a CFX or CFC tag that can take in an audio file in
various formats (the more the better) and convert to MP3. I've found
some command-line tools that can do conversions and I've considered
using CFEXECUTE to call that but I'm curious if anyone has some java
code in a CFC wrapper or if there's a good CFX tag out there to do this
type of thing more elegantly than CFEXECUTE to a command-line program.
All we really need to be able to control is the input file, the output
path and the bitrate of the MP3. If the tag returns a final file size or
something like that, that would be an added bonus. Please let me know if
you have experience with this or know of a product. Thanks!
 
John Burns
Certified Advanced ColdFusion MX Developer
Wyle Laboratories, Inc. | Web Developer
 
-- 
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.14.21/236 - Release Date: 1/20/2006
 

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.14.21/236 - Release Date: 1/20/2006
 



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230228
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

urlencode

[Jennifer Gavin-Wear]

urlencode:

had this working great, then a message appeared with a % in the subject to
be passed as a url var and urlencode promptly falls over.

work around:

this

#threads.subject2#

gets inperpretted by this







all i need now is a ~ and i'm stuck again, lol

1. it looks like a bug in urlencode
2. my workaround does work, but it's a bit frail using a tilda like that.
3. it looks like a lot of ugly code and I'm wondering if there's a better
way

any ideas anyone please?

Thanks!  Jenny







~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230227
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: storing query results while paging through

[Justin D. Scott]

Assuming your query pulls all of the results and you use the startrow and
maxrows attributes when outputting, you could just use the cachedwithin
attribute of cfquery itself to store the results in memory without all the
fuss of session variables.  This will also have the benefit of using the
same cache if multiple sessions search for the same thing while it's in the
cache.

-Justin



> -Original Message-
> From: George Abraham [mailto:[EMAIL PROTECTED] 
> Sent: Monday, January 23, 2006 10:34 AM
> To: CF-Talk
> Subject: storing query results while paging through
> 
> All,
> I don't use session variables at all, but this might a good 
> time to use
> them.
> 
> I have a search page that takes in a search term, runs a 
> query and then
> displays the results. The user is allowed to click into a 
> result and then
> page through the search resultset while in a result (via Previous/Next
> controls). Since I don't store the query results anywhere, I 
> basically run
> that query every single time that the user presses Previous 
> or Next (just so
> that I can find out where the user is while s/he is paging 
> through and what
> the previous and next results are.) For an intensive search 
> (which this is
> turning out to be), this means every time that the user does 
> anything with
> the resultset, I am running a 4 or 5 second operation. Highly 
> inefficient, I
> suspect.
> 
> How do I cache the query results? Is a session variable the 
> best option? I
> guess cookies would not be bad, but they are limited in the 
> amount they can
> hold. How do people tackle this problem anyway?
> 
> Thanks,
> George
> 
> 
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230226
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: SeeFusion versus FusionReactor [was: Monitoring JRun Memory U sage]

[Robertson-Ravo, Neil (RX)]

Russ,  I know what you mean re: UI, it does look better.

Write your own in what way - using java?







-Original Message-
From: Snake [mailto:[EMAIL PROTECTED] 
Sent: 23 January 2006 15:15
To: CF-Talk
Subject: RE: SeeFusion versus FusionReactor [was: Monitoring JRun Memory
Usage]

I'm a stickler for nice UI.
So I didn't really like seeFusion.
Fusion Reactor is on use on one of our servers and has stopped a few crashes
and tells me what site was timing out when it happened. Which actually
doesn't seem to be at all related, but there you go.
Fusion Reactor just looks more professional to me.
But all things considered, I probably will still write my own.

Russ 

-Original Message-
From: Nick de Voil [mailto:[EMAIL PROTECTED] 
Sent: 23 January 2006 12:24
To: CF-Talk
Subject: SeeFusion versus FusionReactor [was: Monitoring JRun Memory Usage]

> How does it compare to SeeFusion?

> > U might want to have a look at fusion reactor.

I haven't used either of them yet - if anyone has used both, it would be
great to hear what you think.

Nick







~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230225
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

storing query results while paging through

[George Abraham]

All,
I don't use session variables at all, but this might a good time to use
them.

I have a search page that takes in a search term, runs a query and then
displays the results. The user is allowed to click into a result and then
page through the search resultset while in a result (via Previous/Next
controls). Since I don't store the query results anywhere, I basically run
that query every single time that the user presses Previous or Next (just so
that I can find out where the user is while s/he is paging through and what
the previous and next results are.) For an intensive search (which this is
turning out to be), this means every time that the user does anything with
the resultset, I am running a 4 or 5 second operation. Highly inefficient, I
suspect.

How do I cache the query results? Is a session variable the best option? I
guess cookies would not be bad, but they are limited in the amount they can
hold. How do people tackle this problem anyway?

Thanks,
George


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230224
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: SeeFusion versus FusionReactor [was: Monitoring JRun Memory Usage]

[Snake]

I'm a stickler for nice UI.
So I didn't really like seeFusion.
Fusion Reactor is on use on one of our servers and has stopped a few crashes
and tells me what site was timing out when it happened. Which actually
doesn't seem to be at all related, but there you go.
Fusion Reactor just looks more professional to me.
But all things considered, I probably will still write my own.

Russ 

-Original Message-
From: Nick de Voil [mailto:[EMAIL PROTECTED] 
Sent: 23 January 2006 12:24
To: CF-Talk
Subject: SeeFusion versus FusionReactor [was: Monitoring JRun Memory Usage]

> How does it compare to SeeFusion?

> > U might want to have a look at fusion reactor.

I haven't used either of them yet - if anyone has used both, it would be
great to hear what you think.

Nick





~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230223
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: Using a .jar file

[Steve Brownlee]

No, it's not possible with CFMX.  They meant you'd have to write a new Java
class to extend theirs.

> -Original Message-
> From: blists [mailto:[EMAIL PROTECTED] 
> Sent: Friday, January 20, 2006 8:58 PM
> To: CF-Talk
> Subject: Re: Using a .jar file
> 
> Ahhh yes, your right. I figured this out with some help from 
> their tech 
> support but you are right on the money. Now, I have another 
> problem. I got 
> this working, but now I need to listen for events to know if 
> the ftp was 
> successfull etc, ect. The only way to do this, according to their 
> documentation I need to create a new object/class to do this 
> and while I 
> could figure out how to do this in Java or AS, I'm not sure how its 
> possible within CFMX. Is it even possible to do something 
> like this with 
> cfscript?
> 
> For an object to listen for events published by the Sftp class the 
> following steps are required:
> 
> 1. Set object to implement SftpListener or extend SftpAdapter class.
> 2. Overload event handling methods.
> 3. Subscribe object to receive events published by Sftp instance.
> 
> The example below demonstrates using the SftpAdapter class.
> 
> import com.jscape.inet.sftp.*;
> import com.jscape.inet.sftp.events.*;
> import com.jscape.inet.ssh.util.SshParameters;
> 
> public class MySftpAdapter extends SftpAdapter {
> 
>public void connected(SftpConnectedEvent evt) {
>  System.out.println("Connected to host: " + evt.getHostname());
>}
> 
>public void disconnected(SftpDisconnectedEvent evt) {
>  System.out.println("Disconnected from host: " + 
> evt.getHostname());
>}
> 
>public static void main(String[] args) {
>  try {
>String hostname = "ftp.host.com";
>String username = "jsmith";
>String password = "secret";
> 
>// create connection parameters
>SshParameters sshParams = new 
> SshParameters(hostname,username,password);
>Sftp sftp = new Sftp(sshParams);
> 
>// subscribe listener to published SFTP events
>sftp.addSftpListener(new MySftpAdapter());
> 
>// connect then disconnect
>sftp.connect();
>sftp.disconnect();
> 
>  } catch(SftpException e) {
>e.printStackTrace();
>  }
>}
> }
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230222
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: Monitoring JRun Memory Usage

[Douglas Knudsen]

On 1/22/06, Steven Brownlee <[EMAIL PROTECTED]> wrote:
> First reaction: OutOfMemory errors are *usually* the result of a low PermGen
> setting on your JVM.
>
> Now, on to your question.  If you're running unmodified CFMX, then you're
> using the 1.4.2 JDK, so your options are limited.  If you've upgraded to the
> 1.5 JDK then you have many options for probing deeper into the JVM guts to
> find the problem.  With the 1.4, then all you have is the code the Gabriel
> posted earlier.

actually, IIRC, visualGC can see non Java 5 JVMs.
http://java.sun.com/performance/jvmstat/visualgc.html
I have set this up before.  you need the Java 5 JVM installed, but you
don't have to switch the JVM CF uses.

DK
>
> -Original Message-
> From: Rick Root [mailto:[EMAIL PROTECTED]
> Sent: Friday, January 20, 2006 10:00 AM
> To: CF-Talk
> Subject: Monitoring JRun Memory Usage
>
> I'm running CFMX7.0.1 Enterprise on Windows Server 2003.
>
> I'd like to monitor - and log - JRun memory usage.  coldfusion died on us
> this morning for some reason - I can't find any indication of what caused
> the error other than the time it occurred (9:16am) when an OutOfMemory error
> occurred.
>
> I thought it would be useful to monitor memory usage every minute or so and
> record it to a log... timestamp,memory
>
> Anyone got any ideas of the simplest way to do this?  I do have Perl
> installed on the server so that might be an option.
>
> Rick
>
>
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230221
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

Audio conversion CFX tag, cfc, etc?

[Burns, John D]

I've been looking for a CFX or CFC tag that can take in an audio file in
various formats (the more the better) and convert to MP3. I've found
some command-line tools that can do conversions and I've considered
using CFEXECUTE to call that but I'm curious if anyone has some java
code in a CFC wrapper or if there's a good CFX tag out there to do this
type of thing more elegantly than CFEXECUTE to a command-line program.
All we really need to be able to control is the input file, the output
path and the bitrate of the MP3. If the tag returns a final file size or
something like that, that would be an added bonus. Please let me know if
you have experience with this or know of a product. Thanks!
 
John Burns
Certified Advanced ColdFusion MX Developer
Wyle Laboratories, Inc. | Web Developer
 
 


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230220
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: Firefox Sessions

[Russ]

There is an optional path attribute when a cookie is set.  If you put on
something like httplook and see the cookies being sent back and forth, I'm
willing to bet that the ones in the admin directory is setting the cookie
with /root/admin as the path.  
 
If you set the cookie in /root and then read it in /admin, I bet that would
work.  And the reason I'm talking about cookies is because that's how cf
tracks sessions, through the cftoken and cfid cookies (or jsessionid).  

Russ

> -Original Message-
> From: Jake . [mailto:[EMAIL PROTECTED]
> Sent: Sunday, January 22, 2006 6:14 PM
> To: CF-Talk
> Subject: Firefox Sessions
> 
> OK, this is boggling -
> 
> I have two directories I'm working with:
> 
> /root/
> /root/admin
> 
> Each of those two directories has an Application.cfm file, each with a
> CFAPPLICATION tag, both of which are named the same.
> 
> I login to the /root/admin/ and create a CF session variable.
> 
> When I go to the /root/somepage.cfm, I should see the same session
> variables as when I visit /root/admin/somepage.cfm, right?
> 
> This doesn't actually happen... at least not in Firefox. In Internet
> Explorer I see all session variables in the root for the /admin and vice
> versa.
> 
> This is beyond perplexing - usually it's IE causing issues, not FF!
> 
> Thanks in advance,
> Jake
> 
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230219
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, Delete, Insert recordcount?

[Paul Hastings]

Jim Wright wrote:
> I have read that not having "set nocount on" can mess up CF's ability

in the past (ie pre MX) you needed it to pump multiple t-sql statements into 1 
cfquery. the intermediate resultset counts returned to cf would otherwise 
confuse it. i forget who exactly figured that out but i think it was a team 
allaire member, maybe around the time of cf3. it's been a good practice since 
then (even longer in the sql server world, you'll see it recommended for use in 
sp that deal w/monster thumping tables all the time).

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230218
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, Delete, Insert recordcount?

[Adrian Lynch]

Cheers. I can't say I've ever used it in cfquery, but it's in my SP
templates.

I could have sworn there was another reason for using it but I can't think
what it is right now.

Ade

-Original Message-
From: Jim Wright [mailto:[EMAIL PROTECTED]
Sent: 23 January 2006 12:21
To: CF-Talk
Subject: Re: Update, Delete, Insert recordcount?


Mainly, it is a performance thing...when you have multiple statements
returning their counts, it takes longer to get to that one statement
that actually has the results you want.It may be milliseconds, but
in some systems, that can add up...so it's just good practice.  Also,
I have read that not having "set nocount on" can mess up CF's ability
to parse out an error message from the messages that are returned, as
it gets confused by the multiple count messages that may precede the
errorbut I haven't confirmed that one myself.

But there is probably no problem using it on a single statement.

On 1/22/06, Adrian Lynch <[EMAIL PROTECTED]> wrote:
> Why multiple statements, why not single statements?
>
> Ade
>
> -Original Message-
> From: Jim Wright [mailto:[EMAIL PROTECTED]
> Sent: 22 January 2006 01:08
> To: CF-Talk
> Subject: Re: Update, Delete, Insert recordcount?
>
>
> Also always a good idea to use SET NOCOUNT around multiple SQL
> statements to suppress informational messages...
> 
> SET NOCOUNT ON
>
> UPDATE yourTable
> SET YourColumn = 'Something'
>
> SELECT @@ROWCOUNT  AS RowsUpdated
>
> SET NOCOUNT OFF
> 
>
>
> On 1/21/06, Adrian Lynch <[EMAIL PROTECTED]> wrote:
> > My name's not Bobby, but here goes:
> >
> > 
> > UPDATE yourTable
> > SET YourColumn = 'Something'
> >
> > SELECT @@ROWCOUNT 'RowsUpdated'
> > 
> >
> > 
> > #yourQuery.RowsUpdated#
> > 
> >
> > Untested, and for SQL Server, but might be ok for Access.
> >
> > Adrian


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230217
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

SeeFusion versus FusionReactor [was: Monitoring JRun Memory Usage]

[Nick de Voil]

> How does it compare to SeeFusion?

> > U might want to have a look at fusion reactor.

I haven't used either of them yet - if anyone has used both, it would be
great to hear what you think.

Nick



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230216
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: Update, Delete, Insert recordcount?

[Jim Wright]

Mainly, it is a performance thing...when you have multiple statements
returning their counts, it takes longer to get to that one statement
that actually has the results you want.It may be milliseconds, but
in some systems, that can add up...so it's just good practice.  Also,
I have read that not having "set nocount on" can mess up CF's ability
to parse out an error message from the messages that are returned, as
it gets confused by the multiple count messages that may precede the
errorbut I haven't confirmed that one myself.

But there is probably no problem using it on a single statement.

On 1/22/06, Adrian Lynch <[EMAIL PROTECTED]> wrote:
> Why multiple statements, why not single statements?
>
> Ade
>
> -Original Message-
> From: Jim Wright [mailto:[EMAIL PROTECTED]
> Sent: 22 January 2006 01:08
> To: CF-Talk
> Subject: Re: Update, Delete, Insert recordcount?
>
>
> Also always a good idea to use SET NOCOUNT around multiple SQL
> statements to suppress informational messages...
> 
> SET NOCOUNT ON
>
> UPDATE yourTable
> SET YourColumn = 'Something'
>
> SELECT @@ROWCOUNT  AS RowsUpdated
>
> SET NOCOUNT OFF
> 
>
>
> On 1/21/06, Adrian Lynch <[EMAIL PROTECTED]> wrote:
> > My name's not Bobby, but here goes:
> >
> > 
> > UPDATE yourTable
> > SET YourColumn = 'Something'
> >
> > SELECT @@ROWCOUNT 'RowsUpdated'
> > 
> >
> > 
> > #yourQuery.RowsUpdated#
> > 
> >
> > Untested, and for SQL Server, but might be ok for Access.
> >
> > Adrian
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230215
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: Monitoring JRun Memory Usage

[Robertson-Ravo, Neil (RX)]

How does it compare to SeeFusion?



-Original Message-
From: Nick de Voil [mailto:[EMAIL PROTECTED] 
Sent: 21 January 2006 10:33
To: CF-Talk
Subject: Re: Monitoring JRun Memory Usage

Russ

> U might want to have a look at fusion reactor.


Have you used this & does it do what it says? It looks fantastic.

Nick





~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230214
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

Deflated Web Services can't be consumed on CFMX7?

[Andrew Stevens]

Hi I hit a problem today trying to consume a web service in CFMX7.

 

Sorry, I don't have the exact wording, it's something like java.util.zip.Zip
Exception. invalid compression algorithm.

Some investigation revealed the WSDL is compressed with Deflate, not GZIP
which seems more common.

 

Does anyone know of a way to make CF(Axis) work with 'Deflate'?

Or maybe there's a header I could set to stop it being compressed? 

 

Any help would be great.

 

Cheers,

AS



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230213
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