Deflated Web Services can't be consumed on CFMX7?
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
RE: Monitoring JRun Memory Usage
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
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... cfquery name=yourQuery datesource=yourDS SET NOCOUNT ON UPDATE yourTable SET YourColumn = 'Something' SELECT @@ROWCOUNT AS RowsUpdated SET NOCOUNT OFF /cfquery On 1/21/06, Adrian Lynch [EMAIL PROTECTED] wrote: My name's not Bobby, but here goes: cfquery name=yourQuery datesource=yourDS UPDATE yourTable SET YourColumn = 'Something' SELECT @@ROWCOUNT 'RowsUpdated' /cfquery cfoutput #yourQuery.RowsUpdated# /cfoutput 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
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: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?
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... cfquery name=yourQuery datesource=yourDS SET NOCOUNT ON UPDATE yourTable SET YourColumn = 'Something' SELECT @@ROWCOUNT AS RowsUpdated SET NOCOUNT OFF /cfquery On 1/21/06, Adrian Lynch [EMAIL PROTECTED] wrote: My name's not Bobby, but here goes: cfquery name=yourQuery datesource=yourDS UPDATE yourTable SET YourColumn = 'Something' SELECT @@ROWCOUNT 'RowsUpdated' /cfquery cfoutput #yourQuery.RowsUpdated# /cfoutput 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
Re: Update, Delete, Insert recordcount?
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: Firefox Sessions
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
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 ~| 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: Monitoring JRun Memory Usage
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
RE: Using a .jar file
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: 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: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
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: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 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: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
RE: storing query results while paging through
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
urlencode
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 a href=display.cfm?maillist=#maillist#subject=#replace(threads.subject2, %, ~, all)# class=maillist#threads.subject2#/a gets inperpretted by this cfloop from=1 to=#len(cgi.QUERY_STRING)# index=i cfif #mid(cgi.QUERY_STRING, i, 8)# is subject= cfset thread = #replace(mid(cgi.QUERY_STRING, i+8, len(cgi.QUERY_STRING)),%20, , all)# /cfif /cfloop cfset thread = #replace(thread, ~, %, all)# 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: 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: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
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 [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: storing query results while paging through
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 georg [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: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
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: SeeFusion versus FusionReactor [was: Monitoring JRun Memory U sage]
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
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: 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: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
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
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
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
CFScript Quick Reference Guide?
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- 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
Re: BlueDragon License Change
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: 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: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: storing query results while paging through
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: storing query results while paging through
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: 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) :\ 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: CFScript Quick Reference Guide?
-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?
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?
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: Audio conversion CFX tag, cfc, etc?
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
CF 7 and CFDUMP
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
XML, SOAP and WDDX and CF5
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
Re: XML, SOAP and WDDX and CF5
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
Re: XML, SOAP and WDDX and CF5
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
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: CFScript Quick Reference Guide?
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
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: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: CF 7 and CFDUMP
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
RE: Why does this happen with SQL Server 2000 and CFML?
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? cfquery name=qryDate datasource=#request.dsn# Select convert(float,getdate()) as datetimefromdb /cfquery cfoutput query=qryDate 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) /cfoutput Now use select getdate() as datetimefromdb in your Query cfquery name=qryDate datasource=#request.dsn# select getdate() as datetimefromdb /cfquery cfoutput query=qryDate 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) /cfoutput 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: Print to a printer
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
updating cf
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: from 6 to 7
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
Re: from 6 to 7
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
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
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
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: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
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
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 http://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
Returning a binary char type from a mySQL query using ColdFusion
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.
!//--
andy matthews
web developer
ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--//-
~|
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
RE: VdkAdminPurge
In what context? !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -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
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 http://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: convert windows media file to flash video on the fly
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 http://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
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 http://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
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 http://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
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: 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: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: XML, SOAP and WDDX and CF5
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
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: VdkAdminPurge
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? !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -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
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: convert windows media file to flash video on the fly
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
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
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 http://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: convert windows media file to flash video on the fly
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 http://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
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: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: 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: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
RE: convert windows media file to flash video on the fly
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 http://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...
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
ot: how much of myspace.com is now blue dragon?
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...
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
Re: storing query results while paging through
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=entryentry=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: from 6 to 7
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
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
