Re: Uploading and displaying graphics from a database
As suggested, you could store them in the OS and store the path in the DB. To share images across several sites (and I'm guessing you mean servers too) you could put all the images on one particular box in your cluster and access them over the local network. I've done this on a couple of sites in the past and it works very well. On 6 Jan 2005, at 13:57, Richard East wrote: The reason why I want to do this is because I am writing an admin package to control content on several websites. I’d like to store the images in a central location. I think putting them in a database which all the sites can view seems sensible because the data is available immediately. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189507 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: Mac/Flash Video assistance requested
Tested on Safari, I can confirm that it doesn't work :( Here's a guess, try adding the ?url... bit onto the src attribute in the embed tag also. How are you loading the variables in from within flash? On 23 Dec 2004, at 0:06, Dennis Powers wrote: Hi, I first have to confess my ignorance when it comes to the issues of Mac web browsers and throw myself on the stake of the OS gods as supplication for my shame! Having said that, I am hoping that I could gain some assistance from a MAC user who might spare some time to determine where we have gone wrong with a particular Flash Video applet we created and why it won't run in a MAC browser. The flash video applet can be found at http://www.halomaps.org/index.cfm?pg=15sid=17 select any from the list. We pull the *.flv video file name from a database then append it to the URL line to tell the flash applet to run it. Mac users are reporting that they can't see it. I suspect it has to do with the Flash plug-in version mismatch but I no longer have a MAC to test it with. It appears to work fine in Windows browsers with the Flash 7.x plug-in but MAC users are complaining. Any insight you can give to this lowly Windows programmer would be greatly appreciated. Best Regards, Dennis Powers UXB Internet- A Website Design and Hosting Company 690 Wolcott Road - P.O. Box 6028 Wolcott, CT 06716tel: (203)879-2844 http://www.uxbinternet.com http://dennis.uxb.net ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188618 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: DateAdd problems.
cfset nextEdition = #DateAdd(m, 1, lcase(MonthAsString(month(UKtodayDate()# Hi Saturday, Noticed you've got an extra set of arguments after UKtodayDate which could be your problem, try: cfset nextEdition = DateAdd(m, 1, lcase(MonthAsString(month(UKtodayDate Also in the UK and always on the look out for a good host, have you found a US Host that's easy to deal with from here? Reply off list if you like. Thanks, Ant ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188622 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: Seeing double?
If you've closed the tag or used a / at the end, it will get called twice. You need to checkout the value of thisTag.executionMode, read more here: http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/reusec18.htm On 22 Dec 2004, at 13:39, Katz, Dov B (IT) wrote: I have a dev machine (www.4simchas.com) which has quad 2.4 ghz processors, running the latest 6.1 release I have an app (replica of my prod env) which is running there, and most of my layout elements consist of custom tags (CF_page argscontent/cf_page) What I'm finding is that the headers and footers respectively are appearing twice... this seems to happen only with content being brought into pages via CFMODULE. Any advice (check it out, it's very wierd). -Dov NOTICE: If received in error, please destroy and notify sender. Sender does not waive confidentiality or privilege, and use is prohibited. ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188526 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: CFPOP Parsing Question
Hi Jamie, This is just a quick guess, I've never really used CFPOP... but as CFPOP returns a query, I'm sure you could do a Query of Queries on the result. http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/ using_re.htm#wp1181595 For more info on QofQ Ant On 21 Dec 2004, at 14:53, Jamie Price wrote: I'm thinking of setting up a CF application to process AOL Postmaster notices for me. I can direct the notices to an email account and pop them with CF, however I want to do a little bit of filtering too - specifically I want to find the following line in the body of the email's Raw Content: Received: from SMTP32-FWD by SomeDomain.xyz the phrase 'SMTP32-FWD' is unique - if it appears at all it will only appear once. My filter needs to work something like this: if message body contains SMTP32-FWD then 'Send an email' to [EMAIL PROTECTED] (where SomeDomain.xyz is the domain found in the same line as SMTP32-FWD) Question: how do i search through the contents of a message once i pop it? ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188373 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: time to cluster, I thinkL
IMHO I think the first step, assuming you only have a budget for 1 extra machine, would be to move your MSSQL installation onto a separate box to free up some more resources for CF. This'll save you a bit too as you should have most of the software licenses you need too. After you've done that you could look at adding extra CF servers and hardware/software load balancing in. Perhaps it'd be best to have the busy site on it's own high spec. shiny new box and keep the quiet sites on the existing server. My 2p worth, Ant ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188239 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: record count
If I understand you correctly, you have already run the query in a cfquery/ tag and have a recordset, no? If so, you could do a simple Query of Queries on this to further interrogate your results. e.g. cfquery name=rsNew dbtype=query SELECT COUNT( something ) AS somethingCount FROM rsExisting WHERE NOT something IS NULL /cfquery Where 'rsExisting' is the name of your original recordset. HTH, Ant On 17 Dec 2004, at 17:28, Tim Laureska wrote: I'm looking for a way of obtaining a count of records from a query where only one particular field has data... I don't want to create a separate query for this just addressing this field (ie. do recordcount where field NEQ or some variation) but would like to utilize an existing query that includes that particular field already in the select statement (among many others) Is there an easy way to get a count of records obtained by a query where data is in a field I'm interested in Hope that makes sense Tim ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188022 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: Axis error on OS X
I'm fully up to date - Version: 6,1,0,63958 Have you guys got it working OK? On 15 Dec 2004, at 1:38, dave wrote: axis used an older driver till 6.1 so it wouldnt work right if u havent updated yet ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187716 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: Axis error on OS X
Thanks for the tip, however, it's still not right. This is on my local dev machine if that makes a difference. url: http://localhost:8080/cfusion/services/sample.cfc?wsdl CF Mapping /cfusion/services = /usr/local/jakarta-tomcat-4.1.31/webapps/cfusion/services Does that seem right to you? On 15 Dec 2004, at 10:54, James Holmes wrote: The 6.1 updater broke web services such that you need a mapping to point to the directory in which the CFC is located. It has to be that same as the path from the web root too. E.g. if your cfc is in somesite.com/cfusion/services/whatever.cfc them a mapping needs to be made to map the URL /cfusion/webservices/ to the physical path [whatever-your-web-root-is]/cfusion/webservices/. It sounds dumb, but it works. -Original Message- From: Anthony Cooper [mailto:[EMAIL PROTECTED] Sent: Wednesday, 15 December 2004 6:44 To: CF-Talk Subject: Re: Axis error on OS X I'm fully up to date - Version: 6,1,0,63958 Have you guys got it working OK? On 15 Dec 2004, at 1:38, dave wrote: axis used an older driver till 6.1 so it wouldnt work right if u havent updated yet ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187718 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: Bit of a predicament.. MySQL and sorting by dates..
Actually I meant SET theDate = cfqueryparam cfsqltype=cf_sql_varchar value=#newDate#/ Watch out for long lines wrapping. ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187564 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: Bit of a predicament.. MySQL and sorting by dates..
You'll could do something like: cfquery name=rsFix datasource=x SELECT uid, theDate FROMmyTable /cfquery cfloop query=rsFix cfset newDate = 20 listGetAt( rsFix.theData, 3, - ) - listGetAt( rsFix.theData, 1, - ) - listGetAt( rsFix.theData, 2, - )/ cfquery datasource=x UPDATE myTable SET theDate = cfqueryparam cfsqltype=cf_sql_varchar value=#theDate#/ WHERE uid = cfqueryparam cfsqltype=cf_sql_varchar value=#rsFix.uid#/ /cfquery /cfloop Of course I have just thought of that and not tested it at all... use/debug at your own will. Once you've done this, you should be able to convert the data type too. Good luck, Ant On 14 Dec 2004, at 16:27, Mike wrote: I'm willing to convert the column if I can find a way. I'm running a 3.x version my MySQL and at the time an upgrade is out of the question since I don't have access to the machine.. So maybe the question I should be asking is how can I convert: 10-22-04 to 2004-10-22 I've been scratching my head trying to do this in coldfusion but I'm just spinning my wheels.. Still a bit of a noob.. :) -Mike On Tue, 14 Dec 2004 07:37:29 -0800, Rob [EMAIL PROTECTED] wrote: One way to hack this is to use the old school date maneuver. Dates will order correctly using text methods if they are in the format -mm-dd. So if you can't find a way to convert that column (which I highly recommend) you can do something like this (pseudo code) ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187560 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
Axis error on OS X
Hi, I'm running CFMX 6.1 on Tomcat on OS X everything works fine apart from web services, if I try to call: http://localhost:8080/cfusion/services/sample.cfc I just get: AXIS error No service is available at this URL And if I try: http://localhost:8080/cfusion/services/sample.cfc?wsdl It reports: AXIS error Could not generate WSDL! There is no SOAP service at this location I've googled extensively on this and hunted around on MM but nothing useful has turned up. Any suggestions? TIA, Ant ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187541 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
Mac + JRun + CFMX = .cfm files downloading
Hi, Just moved my CFMX installation over to JRun from Tomcat. The app I've written worked fine before except when I try to browse it now, the index.cfm file just downloads to the desktop. The application is written in FB4, and it seems to do it the most when a page posts to itself or when I'm cflocating. Any ideas would be a great help. Really want to switch over to JRun. TIA, Ant [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Mac + JRun + CFMX = .cfm files downloading
Hi, I haven't tackled the Apache integration yet, I was just accessing the pages direct through the JRun server on port 8100. Ta, Ant On 6 May 2004, at 15:58, Dick Applebaum wrote: Do you have your Apache connection setup properly? BTW, run wsconfig as the root user HTH Dick On May 6, 2004, at 7:49 AM, Anthony Cooper wrote: Hi, Just moved my CFMX installation over to JRun from Tomcat. The app I've written worked fine before except when I try to browse it now, the index.cfm file just downloads to the desktop. The application is written in FB4, and it seems to do it the most when a page posts to itself or when I'm cflocating. Any ideas would be a great help. Really want to switch over to JRun. TIA, Ant [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Mac + JRun + CFMX = .cfm files downloading
Can't see any errors, starting up from a Terminal (su'd first) with /Applications/JRun/bin/jrun -start Then I go to my app at http://localhost:8100/cfusion/CFRoot/myapp/ It whirrs away for a while then just downloads a file called 'index.cfm' containing whitespace. Odd thing is that CFAdmin works OK. Couple of things: 1) what happens when you include index.cfm or other program name in the URL? 2) when you start CF from the console do you see any error messages? Dick On May 6, 2004, at 8:14 AM, Anthony Cooper wrote: Hi, I haven't tackled the Apache integration yet, I was just accessing the pages direct through the JRun server on port 8100. Ta, Ant On 6 May 2004, at 15:58, Dick Applebaum wrote: Do you have your Apache connection setup properly? BTW, run wsconfig as the root user HTH Dick On May 6, 2004, at 7:49 AM, Anthony Cooper wrote: Hi, Just moved my CFMX installation over to JRun from Tomcat. The app I've written worked fine before except when I try to browse it now, the index.cfm file just downloads to the desktop. The application is written in FB4, and it seems to do it the most when a page posts to itself or when I'm cflocating. Any ideas would be a great help. Really want to switch over to JRun. TIA, Ant [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]