CFIMAGE (CF8) - moving /saving file from CFFileServlet
Hi all, I'm having problems getting an image which I've used CFIMAGE to crop on CF8. I can crop the image, return it to the browser, but trying to 'get' at it on the subsequent page request is driving me mad. I can output the image, i.e img src= http://localhost:81/CFFileServlet/_cf_image/_cfimg588898389753871789.jpg; / for the usual five minutes the temp file exists for, but if I try to do: cfimage action=write source=#expandpath('/CFFileServlet/_cf_image/_cfimg588898389753871789.jpg')# destination=#expandPath('/images/portraits/#profile.image#_crop.jpg')# overwrite = yes / i.e, I want to copy/move the file from the temp location to a more permanent location, I'd get File D:\www\blah\html\CFFileServlet\_cf_image\_cfimg5926235398043866604.jpg does not exist. When it really does - I can pull it up in a browser and look at it. This is presumably due to /CFFileServlet/ not being a physical directory? I've tried using cfimage to create another image object from the same location, and also tried to use cfhttp to get the image, but to no avail.. How does everyone else do it? Thanks T ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341923 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFIMAGE (CF8) - moving /saving file from CFFileServlet
I'm using Matt Gifford's trick of returning the cropped image via an ajax request: http://www.mattgifford.co.uk/image-cropping-with-coldfusion-jquery/ So, yes, I suppose I could save it at that point, but it would remove the functionality of being able to revert to the original which is rather handy. There must be a way of getting at the servlet images though? T On 7 February 2011 11:55, Dave Watts dwa...@figleaf.com wrote: I'm having problems getting an image which I've used CFIMAGE to crop on CF8. I can crop the image, return it to the browser, but trying to 'get' at it on the subsequent page request is driving me mad. I can output the image, i.e img src= http://localhost:81/CFFileServlet/_cf_image/_cfimg588898389753871789.jpg; / for the usual five minutes the temp file exists for, but if I try to do: cfimage action=write source=#expandpath('/CFFileServlet/_cf_image/_cfimg588898389753871789.jpg')# destination=#expandPath('/images/portraits/#profile.image#_crop.jpg')# overwrite = yes / i.e, I want to copy/move the file from the temp location to a more permanent location, I'd get File D:\www\blah\html\CFFileServlet\_cf_image\_cfimg5926235398043866604.jpg does not exist. When it really does - I can pull it up in a browser and look at it. This is presumably due to /CFFileServlet/ not being a physical directory? I've tried using cfimage to create another image object from the same location, and also tried to use cfhttp to get the image, but to no avail.. How does everyone else do it? Can't you just either (a) save it to a variable in memory on your first operation, or (b) save it to a specific destination on your first operation? You can then serve it in the browser as needed. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341925 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Function to Output a query as an ol or ul
Hi all, Having not found an existing function to do this (output a query object as a nested ol or ul), I thought I'd try my own hand at it - I'm *so* close. Yet, not quite there. Basically, my mind has given up trying to get the logic correct in when to close /li elements. It works most of the time, but if I say have a nested list, it gets a bit confused and doesn't close the /li - So XHTML throws a wobbly. Can anyone see where I'm going wrong? (or better still, happen to have a function which does something similar I might adapt?) Here's some dummy data and the function: http://neokoenig.pastebin.com/k7EQ8B98 Thanks in advance for any insight... T ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336573 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Function to Output a query as an ol or ul
Hi John, That's fine when you just want a straight: ul liSomething/li /ul But I'm trying to build something with nested ul/ol's from the same query object.. T On 26 August 2010 16:22, John M Bliss bliss.j...@gmail.com wrote: ul cfoutput query=MyQuery li#MyQuery.MyColumn#/li /cfoutput /ul On Thu, Aug 26, 2010 at 10:18 AM, Tom King mailingli...@oxalto.co.uk wrote: Hi all, Having not found an existing function to do this (output a query object as a nested ol or ul), I thought I'd try my own hand at it - I'm *so* close. Yet, not quite there. Basically, my mind has given up trying to get the logic correct in when to close /li elements. It works most of the time, but if I say have a nested list, it gets a bit confused and doesn't close the /li - So XHTML throws a wobbly. Can anyone see where I'm going wrong? (or better still, happen to have a function which does something similar I might adapt?) Here's some dummy data and the function: http://neokoenig.pastebin.com/k7EQ8B98 Thanks in advance for any insight... T ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336575 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Function to Output a query as an ol or ul
I've updated the dummy data in my example to include multiple depths (i.e nesting) http://neokoenig.pastebin.com/nGBphKVN T On 26 August 2010 16:27, Tom King mailingli...@oxalto.co.uk wrote: Hi John, That's fine when you just want a straight: ul liSomething/li /ul But I'm trying to build something with nested ul/ol's from the same query object.. T On 26 August 2010 16:22, John M Bliss bliss.j...@gmail.com wrote: ul cfoutput query=MyQuery li#MyQuery.MyColumn#/li /cfoutput /ul On Thu, Aug 26, 2010 at 10:18 AM, Tom King mailingli...@oxalto.co.uk wrote: Hi all, Having not found an existing function to do this (output a query object as a nested ol or ul), I thought I'd try my own hand at it - I'm *so* close. Yet, not quite there. Basically, my mind has given up trying to get the logic correct in when to close /li elements. It works most of the time, but if I say have a nested list, it gets a bit confused and doesn't close the /li - So XHTML throws a wobbly. Can anyone see where I'm going wrong? (or better still, happen to have a function which does something similar I might adapt?) Here's some dummy data and the function: http://neokoenig.pastebin.com/k7EQ8B98 Thanks in advance for any insight... T ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336577 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Function to Output a query as an ol or ul
It sort of makes sense that this is a recursion issue, as I keep hitting the 'You need to know the future' (i.e the next row before it's happened) feeling.. Re: Michael, yes, assume the query is sorted (i.e the depth is how deep the containing UL is). It does my head in. Recursion that is. On 26 August 2010 16:35, Ian Skinner h...@ilsweb.com wrote: I *THINK* what you are trying to do is a classic problem for a recursive function. Create a function that handles one level of your list with the proper ul and li tags. Then for each record inside the logic for the li... test to see if there is another level, if so call the same function. Rough and incomplete pseudo code. cffunction name=myMenu... ul cfloop li #anMenuItem# cfif anotherLevelmyMenu()/cfif li /cfloop /ul cfreturn theMenu /cffunction ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336581 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Passing a Date Time Value to a function
It's been one of those days already - can anyone tell me why the time gets stripped out? I'm aware that I'm using 'date' as an argument type, but datetime throws an error and there's nothing in CF8 docs on it... How do I preserve the time data? cffunction name=dateFormatter2 returntype=string cfargument name=startDate type=date cfargument name=endDate type=date cfscript var result =; startDate=dateFormat(arguments.startdate, 'dd '); startTime=timeFormat(arguments.startdate, HH:MM); endDate=dateFormat(arguments.enddate, 'dd '); endTime=timeFormat(arguments.enddate, HH:MM); /cfscript cfsavecontent variable=result cfoutputStart: #startDate#, #startTime# br /End: #endDate#, #endTime#/cfoutput /cfsavecontent cfreturn result /cffunction cfoutput #dateFormatter2(now(),now())# /cfoutput Cheers! T ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336349 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Passing a Date Time Value to a function
Brilliant- that's got it, thanks. Can't really believe I've never hit that error in the past 6 years... :) Cheers! T On 18 August 2010 13:48, Jason Fisher ja...@wanax.com wrote: It's because you re-used the variable names startDate and endDate, so you re-wrote the value of each variable to strip out the time and then asked for the time. Always be sure to 'var' all variables in a function, and you'll avoid the snafu. If you do the following, you'll even get a runtime error letting you know the problem (cannot var a variable with the same name as an argument): cffunction name=dateFormatter2 returntype=string access=private output=No cfargument name=startDate type=date required=Yes / cfargument name=endDate type=date required=Yes / cfscript var result = ; var startDate = ; var startTime = ; var endDate = ; var endTime = ; startDate = dateFormat(arguments.startDate, dd ); startTime = timeFormat(arguments.startDate, HH:mm); endDate = dateFormat(arguments.endDate, dd ); endTime = timeFormat(arguments.endDate, HH:mm); /cfscript cfsavecontent variable=result cfoutput Start: #startDate#, #startTime# br /End: #endDate#, #endTime# /cfoutput /cfsavecontent cfreturn result / /cffunction cfoutput #dateFormatter2(now(), now())# /cfoutput Use different var names, and it works fine: cffunction name=dateFormatter2 returntype=string access=private output=No cfargument name=startDate type=date required=Yes / cfargument name=endDate type=date required=Yes / cfscript var result = ; var start = ; var startTime = ; var end = ; var endTime = ; start = dateFormat(arguments.startDate, dd ); startTime = timeFormat(arguments.startDate, HH:mm); end = dateFormat(arguments.endDate, dd ); endTime = timeFormat(arguments.endDate, HH:mm); /cfscript cfsavecontent variable=result cfoutput Start: #start#, #startTime# br /End: #end#, #endTime# /cfoutput /cfsavecontent cfreturn result / /cffunction cfoutput #dateFormatter2(now(), now())# /cfoutput From: Tom King mailingli...@oxalto.co.uk Sent: Wednesday, August 18, 2010 8:26 AM To: cf-talk cf-talk@houseoffusion.com Subject: Passing a Date Time Value to a function It's been one of those days already - can anyone tell me why the time gets stripped out? I'm aware that I'm using 'date' as an argument type, but datetime throws an error and there's nothing in CF8 docs on it... How do I preserve the time data? cffunction name=dateFormatter2 returntype=string cfargument name=startDate type=date cfargument name=endDate type=date cfscript var result =; startDate=dateFormat(arguments.startdate, 'dd '); startTime=timeFormat(arguments.startdate, HH:MM); endDate=dateFormat(arguments.enddate, 'dd '); endTime=timeFormat(arguments.enddate, HH:MM); /cfscript cfsavecontent variable=result cfoutputStart: #startDate#, #startTime# br /End: #endDate#, #endTime#/cfoutput /cfsavecontent cfreturn result /cffunction cfoutput #dateFormatter2(now(),now())# /cfoutput Cheers! T ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336351 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Finding the value of a key in a nested structure
Cheers Ray - simple is good!! :) On 14 June 2010 17:02, Raymond Camden rcam...@gmail.com wrote: Evaluate is slow - comparatively. It isn't horrible though. The main reason I will complain about evaluate is when it isn't strictly necessary. Technically it isn't in your case. You could break up the string into parts and check the existence of each - but I think your code is fine (and a hell of a lot simpler). On Mon, Jun 14, 2010 at 9:44 AM, Tom King mailingli...@oxalto.co.uk wrote: nevermind - found the solution! ended up with: cffunction name=checkPermission cfargument name=path cfif IsDefined('session.currentUser.permissions.' arguments.path) cfif evaluate('session.currentUser.permissions.' arguments.path) cfreturn true cfelse cfreturn false /cfif cfelse cfreturn false /cfif /cffu ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334568 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: concatenating email address
So in the CF Code, you don't escape the and 's. So: cfset the_from = the_from , fname lnameemail will get you the string to use in your CFMAIL tag, then when you're displaying it via cfoutput, use: #htmlCodeFormat(the_from)# or, to escape the characters, but don't surround with PREs #htmlEditFormat(the_from)# T On 15 June 2010 15:07, daniel kessler dani...@umd.edu wrote: Problem's not the concatenation, it's just the browser interprets anything between and as tags, so they're hidden by design. Once you have your list, try this: cfoutput#htmlCodeFormat(the_from)#/cfoutput I tried this and the email message failed anyway. It looked great when I did the output to a web page, but on checking the source, it instead had: PREDaniel Kesslerlt;dani...@umd.edu kessler%26lt%3bdani...@umd.edu gt;/PRE Clearly, I want the actual characters instead of the PRE and lt; ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334573 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Finding the value of a key in a nested structure
Ok, my brain is hurting - I know this should be possible, but I can't quite get the syntax. I need to pass a string (a path to a structure which contains a boolean in the session scope) into a function, which then checks the value: i.e cfif checkPermission(email.send.all) Show a form or page /cfif cffunction name=checkPermission cfargument name=path cfif session.currentUser.permissions['#arguments.path#'] cfreturn true cfelse cfreturn false /cfif /cffunction So in this instance, CF is looking for session.currentUser.permissions['email.send.all'] - i.e a structure key name of 'email.send.all' , rather than session.currentUser.permissions.email.send.all Is there an elegant solution to this problem? Ta T ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334528 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Finding the value of a key in a nested structure
Cheers Andy - That's fine if I want to check the struct exists, but I'm trying to directly test against the value of that path (which in this case is a boolean)...? T On 14 June 2010 15:25, Andy Matthews li...@commadelimited.com wrote: When working with structures nested that deeply you might consider IsDefined instead. cfif IsDefined('session.currentUser.permissions.' arguments.path) It's not a best practice necessarily, but it would prevent a whole bunch of StructKeyExists calls. andy -Original Message- From: Tom King [mailto:mailingli...@oxalto.co.uk] Sent: Monday, June 14, 2010 9:20 AM To: cf-talk Subject: Finding the value of a key in a nested structure Ok, my brain is hurting - I know this should be possible, but I can't quite get the syntax. I need to pass a string (a path to a structure which contains a boolean in the session scope) into a function, which then checks the value: i.e cfif checkPermission(email.send.all) Show a form or page /cfif cffunction name=checkPermission cfargument name=path cfif session.currentUser.permissions['#arguments.path#'] cfreturn true cfelse cfreturn false /cfif /cffunction So in this instance, CF is looking for session.currentUser.permissions['email.send.all'] - i.e a structure key name of 'email.send.all' , rather than session.currentUser.permissions.email.send.all Is there an elegant solution to this problem? Ta T ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334530 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Finding the value of a key in a nested structure
nevermind - found the solution! ended up with: cffunction name=checkPermission cfargument name=path cfif IsDefined('session.currentUser.permissions.' arguments.path) cfif evaluate('session.currentUser.permissions.' arguments.path) cfreturn true cfelse cfreturn false /cfif cfelse cfreturn false /cfif /cffunction (Never used evaluate() before, heard it was bad..?) T On 14 June 2010 15:29, Tom King mailingli...@oxalto.co.uk wrote: Cheers Andy - That's fine if I want to check the struct exists, but I'm trying to directly test against the value of that path (which in this case is a boolean)...? T On 14 June 2010 15:25, Andy Matthews li...@commadelimited.com wrote: When working with structures nested that deeply you might consider IsDefined instead. cfif IsDefined('session.currentUser.permissions.' arguments.path) It's not a best practice necessarily, but it would prevent a whole bunch of StructKeyExists calls. andy -Original Message- From: Tom King [mailto:mailingli...@oxalto.co.uk] Sent: Monday, June 14, 2010 9:20 AM To: cf-talk Subject: Finding the value of a key in a nested structure Ok, my brain is hurting - I know this should be possible, but I can't quite get the syntax. I need to pass a string (a path to a structure which contains a boolean in the session scope) into a function, which then checks the value: i.e cfif checkPermission(email.send.all) Show a form or page /cfif cffunction name=checkPermission cfargument name=path cfif session.currentUser.permissions['#arguments.path#'] cfreturn true cfelse cfreturn false /cfif /cffunction So in this instance, CF is looking for session.currentUser.permissions['email.send.all'] - i.e a structure key name of 'email.send.all' , rather than session.currentUser.permissions.email.send.all Is there an elegant solution to this problem? Ta T ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334531 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Looping over form structs into an array or query
Hi All, I've got a form where I've got a potentially unknown number of form fields as they're being added by Javascript; i.e form.linkText_1 form.linkUrl_1 form.linkText_2 form.linkUrl_2 form.linkText_3 form.linkUrl_3 form.linkText_4 form.linkUrl_4 How can I deal with this at the other end? I can output them (but in no useful order): cfloop list=#structKeyList(form)# index=key cfoutput cfif len(form[key]) GTE 1 AND key CONTAINS link pKey: #key#, Value: #form[key]#/p /cfif /cfoutput /cfloop How would I get these into an Array or a Query object where they are paired up by number? Thanks T ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314524 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Looping over form structs into an array or query
I get this cryptic error when running that: Element 1 is undefined in a CFML structure referenced as part of an expression. even though my stuff is getting passed: label for=linkname_1Link Name 1/label input name=linkname_1 id=linkname1 value=Event Registration size=35 maxlength=255 type=text class=textInput / label for=linkurl_1URL 1/label input name=linkurl_1 id=url1 value=/registration size=35 maxlength=255 type=text class=textInput / 2008/10/29 Jake Churchill [EMAIL PROTECTED] You are close. Try this: cfset counter = 1 cfset resultStruct = StructNew() cfloop list=#structKeyList(form)# index=key cfoutput cfif len(form[key]) GTE 1 AND key CONTAINS link cfset resultStruct[counter].linkUrl = form[linkUrl_counter] cfset resultStruct[counter].linkText = form[linkText_counter] cfset counter = counter + 1 /cfif /cfoutput /cfloop -Jake Churchill Tom King wrote: Hi All, I've got a form where I've got a potentially unknown number of form fields as they're being added by Javascript; i.e form.linkText_1 form.linkUrl_1 form.linkText_2 form.linkUrl_2 form.linkText_3 form.linkUrl_3 form.linkText_4 form.linkUrl_4 How can I deal with this at the other end? I can output them (but in no useful order): cfloop list=#structKeyList(form)# index=key cfoutput cfif len(form[key]) GTE 1 AND key CONTAINS link pKey: #key#, Value: #form[key]#/p /cfif /cfoutput /cfloop How would I get these into an Array or a Query object where they are paired up by number? Thanks T ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314530 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Best Open Source Message Board?
Have a look at Ray Camden's Galleon http://galleon.riaforge.org/ T 2008/10/29 Mallory Woods [EMAIL PROTECTED] Hello All, I have a quick project to do and there is no time for re-inventing the wheel. What is the best open source message board? It will be installed on a system that is using CF7. Thanks in Advance! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314536 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Looping over form structs into an array or query
Thanks for the help all; finally settled on: cfset testStruct = structnew() / cfset testStruct.LinkText_1 = Linktest1 / cfset testStruct.LinkText_2 = Linktest2 / cfset testStruct.LinkText_3 = Linktest3 / cfset testStruct.UrlText_1 = Urltest1 / cfset testStruct.UrlText_2 = Urltest2 / cfset testStruct.UrlText_3 = Urltest3 / cfset TempLinkQ=QueryNew(linkname,url, varchar,varchar) cfdump var=#testStruct# / cfset counter =1 cfloop list=#structKeyList(testStruct)# index=key cfif key CONTAINS linktext AND len(teststruct[key]) GTE 1 cfoutput cfset QueryAddRow(TempLinkQ, 1) cfset QuerysetCell(TempLinkQ, linkname, #testStruct[linkText_ counter]#) cfset QuerysetCell(TempLinkQ, url, #testStruct[UrlText_ counter]#) /cfoutput cfset counter=(counter+1) /cfif /cfloop cfdump var=#TempLinkQ# It's the #testStruct[UrlText_ counter]# syntax which was the key for me! Ta T 2008/10/29 Tom Chiverton [EMAIL PROTECTED] On Wednesday 29 Oct 2008, Jake Churchill wrote: cfloop list=#structKeyList(form)# index=key This will loop over each Url and Text, where as you really want one to be both url and text. Use one of the condition based loops instead. -- Tom Chiverton Helping to quickly repurpose user-centric synergies This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314549 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Paging in a customtag
Hi All, I've written a customtag to do paging; Basically, I can pass a recordcount in, and it'll output 1, 2, 3, 4, 5, 6, 7, - This works fine; However, I really need it to do this: 1, 2, 3, ... 8, 9 ,10 as the recordsets I'm now dealing with are getting quite big; Any one know how I can do this? Or has anyone come across a code example I can look at? My code is: !---Paging--- cfif thisTag.executionMode is start cfsilent cfscript page=attributes.page; recordsperpage=attributes.recordsperpage; totalpages=Ceiling(attributes.recordcount/recordsperpage); /cfscript cfif page GT totalpagescfset page=totalpagescfelseif page LT 1cfset page=1/cfif cfscript startrow=(page-1)*recordsperpage+1; endrow=startrow+recordsperpage-1; caller.startrow=startrow; caller.endrow=endrow; /cfscript /cfsilent cfif totalpages GT 1 cfoutputdiv class=paging/cfoutput cfif page GT 1 cfoutputa href=#REReplace(attributes.urlroot ? CGI.QUERY_STRING,'page=[0-9]+','','ALL')#amp;page=#page-1# title=Go to previous page class=previouspagelaquo;/a/cfoutput cfelse cfoutputspan class=previouspage inactivelaquo;/span/ cfoutput /cfif cfloop index=i from=1 to=#totalpages# cfif i EQ page cfoutput#i#/cfoutput cfelse cfoutputa href=#REReplace(attributes.urlroot ? CGI.QUERY_STRING,'page=[0-9]+','','ALL')#amp;page=#i# title=Go to page #i# class=number#i#/a/cfoutput /cfif /cfloop cfif page LT totalpages cfoutputa href=#REReplace(attributes.urlroot ? CGI.QUERY_STRING,'page=[0-9]+','','ALL')#amp;page=#page+1# title=Go to next page class=nextpageraquo;/a/cfoutput cfelse cfoutputspan class=nextpage inactiveraquo;/span/cfoutput /cfif cfoutput/div/cfoutput /cfif /cfif Thanks! T ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300384 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Cfoutput query backwards
Hi All, Is there a way of outputting a Query in cfoutput in reverse without creating another query, or adding rows to the query, and with no numerical index? I have a manual query object created, with galleryId, and galleryName, but GalleryID is not a sequential number sequence nor alphabetical, so ORDER BY galleryID doesn't have the correct effect; ie. values might be: ID Name 2007_fooFoobar 2007_abcFooFoo Obviously, when I CFDUMP the query, you get CF's ID in the column, and outputting QueryName.currentrow will give you a sequential numerical list, but I want CF to output that Query in reverse! Any ideas? Thanks T ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293365 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Cfoutput query backwards
Many thanks all, the negative step is something which simply had never even occured to me! T -Original message- From: Bobby Hartsfield [EMAIL PROTECTED] Date: Thu, 15 Nov 2007 20:37:34 + To: CF-Talk cf-talk@houseoffusion.com Subject: RE: Cfoutput query backwards Yes you can use a cfloop from and to with a negative step... cfloop from=#query.recordcount# to=1 step=-1 index=i #query['columnname'][i]# /cfloop ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293427 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Head banging MySQL DateTime
Hi all, this is driving me nuts: I'm trying to insert a date/time into a mysql database: the row is set up as datetime, NULL as default; I;m trying to insert from a form where I have drop downs which give me the various values; The values are definitely being passed from the form to the CFC; the time stamp I'm passing in is valid, and the DATE always changes, but the Time value is always inserted at 00:00:00 cfscript //Create Valid Date Time Objects ThisStartDate=CreateDateTime(year(form.EventStart), month(form.EventStart), day(form.EventStart), form.starthour, form.startmin, 00); ThisEndDate=CreateDateTime(year(form.EventEnd), month(form.EventEnd), day(form.EventEnd), form.Endhour, form.Endmin, 00); /cfscript This is the SQL: UPDATE tblEvents SET EVENTNAME = cfqueryparam value=#form.EventName# cfsqltype=cf_sql_varchar, EVENTSTART = cfqueryparam value=#ThisStartDate# cfsqltype=cf_sql_date, EVENTEND = cfqueryparam value=#ThisEndDate# cfsqltype=cf_sql_date, WHERE EventID = cfqueryparam value=#form.eventid# cfsqltype=cf_sql_integer; Help??? Thanks T ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283546 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Head banging MySQL DateTime
Thats got it - got confused about TimeStamp /DateTime /Date (just moved from Access :) Thanks! T On 12 Jul 2007, at 15:46, Charlie Griefer wrote: cf_sql_timestamp as the cfsqltype? On 7/12/07, Tom King [EMAIL PROTECTED] wrote: Hi all, this is driving me nuts: I'm trying to insert a date/time into a mysql database: the row is set up as datetime, NULL as default; I;m trying to insert from a form where I have drop downs which give me the various values; The values are definitely being passed from the form to the CFC; the time stamp I'm passing in is valid, and the DATE always changes, but the Time value is always inserted at 00:00:00 cfscript //Create Valid Date Time Objects ThisStartDate=CreateDateTime(year(form.EventStart), month(form.EventStart), day(form.EventStart), form.starthour, form.startmin, 00); ThisEndDate=CreateDateTime(year(form.EventEnd), month(form.EventEnd), day(form.EventEnd), form.Endhour, form.Endmin, 00); /cfscript This is the SQL: UPDATE tblEvents SET EVENTNAME = cfqueryparam value=#form.EventName# cfsqltype=cf_sql_varchar, EVENTSTART = cfqueryparam value=#ThisStartDate# cfsqltype=cf_sql_date, EVENTEND = cfqueryparam value=#ThisEndDate# cfsqltype=cf_sql_date, WHERE EventID = cfqueryparam value=#form.eventid# cfsqltype=cf_sql_integer; Help??? Thanks T ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283554 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Creating an in-out application w spry/CF
I have a project: I need to create an in and out board (i.e a webpage/application which sits on a tablet PC by an entrance to a building); The app needs to show a list of names, populated from a MySQL database, and on click, update the time signed in to the database, and change the color of the name to indicate whether they're in the building - that part is easy - however, the app needs to work multiple machines: Hence, you have data which needs to be pushed out to the other devices on the other entrances, so the record of when someone is in or out is identical. Previously, this has been done by making every click a form submission, and then each version of the page would use a Meta refresh every 30 seconds to update their displays; There's got to be a cooler way of doing this: Any ideas? Spry/Flex/Flash may be the way forward, and I'm intending to use it as a training exercise, so willing to learn, but would like a nudge in the right direction! Ta T ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283372 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: strange character entities in CF... on form submission...
Unicode!!! Make sure a) your html header has utf-8 in it - the form may also need to be told a specific char set; - Dump the form contents on submission: are the chars there? b) if in inserting into a database, that the database is set up with Unicode, look at the SQL - is it inserting the chars? c) check the output - is the DB outputting the chars? T On 10 Jul 2007, at 11:12, D F wrote: Anyone have any ideas... essentially we are getting ( just ahead of the pound character ) an A with a hat. Â ( capital a, circumflex accent,Acirc;,#194;) Any ideas how to prevent this one from happening? It seems to be doing this on form submissions. ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283373 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFQuery and MySQL
This may help with the set up (but I'm assuming as it verifies it probably ok): http://www.oxalto.co.uk/index.cfm/2007/7/2/Setting-up-a-MySQL- database-with-Unicode--properly-in-Coldfusion-7 T On 2 Jul 2007, at 13:18, Mark Leder wrote: I have a new MySQL connection set up in CF7 - verifies correctly (called mysqldb). Within this connection I have a db called ABC, and then tables within this db. I can't get the cfquery to work correctly: If I use: cfquery name=insertA datasource=mysqldb I get the error: No database selected If I use: cfquery name=insertA datasource=abc I get the error: Datasource ABC could not be found I suspect the first error is closer to the solution. How do I get a cfquery to point to the right db? THANKS! Mark ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282699 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT - Gap when making element invisible
You'd need to remove the br / Im not sure if you're allowed to do this, but could you apply a class to the br as well? Or even worse, nest the br in the span? T On 2 Jul 2007, at 14:39, Adrian Lynch wrote: I have three spans: span id=span_11/spanbr / span id=span_22/spanbr / span id=span_33/span Which gives me output: 1 2 3 If I make the middle one invisible with script: document.getElementById(span_2).style.visibility = hidden; It leaves a gap like so: 1 3 How would I make that gap close up leaving me with: 1 3 Adrian Lynch ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282709 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: specific hosting needs
TiTan Hosting (www.titaninternet.com) allow unlimited DSNs (Access) I believe. CFFILE is also fine w them. T On 13 Jun 2007, at 18:11, Nick Call wrote: I have an old CF application where different setups use the same source code. I need to host this application somewhere that allows me specific things that most hosting providers do not offer. a) I have one domain name, but about 40 different datasources. Which datasource they use depends on their login profile, etc. Combining this data into one database is not an option. b) The application has to be able to use CFFile to write text files and HTML files. These are reports that are necessary for retrieval later. The amount of space that is used is minimal, about 150 meg will do nicely. If anyone knows of a CF host that can accommodate me, I would appreciate the information. Sincerely, Nick ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281106 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help getting rid of Squares in DB
Could you elaborate? As I see it, there's no way I can refer to the blocks in a SQL statement? Ta T On 6 Jun 2007, at 00:03, Dave l wrote: you could run a query and copy in a smartquotes to sort by then update with normal quotes. Another BIG thank you to microcrap for those. Hi All, I've inherited a database which has loads of squares in the middle of text - i.e incorrectly encoded quotes, and other chars which bring out this type of wierdness when displayed. They are inconsistent as to what they are, but the majority are (or were) single quotes. Any tips on automating their removal (or replacement with single quotes) in a MySQL database? They are obviously 100's to 1000's of entries, so I'd REALLY rather avoid having to edit this manually (or indeed open every page they're on and resave)... Thanks ! T ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280214 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Help getting rid of Squares in DB
Hi All, I've inherited a database which has loads of squares in the middle of text - i.e incorrectly encoded quotes, and other chars which bring out this type of wierdness when displayed. They are inconsistent as to what they are, but the majority are (or were) single quotes. Any tips on automating their removal (or replacement with single quotes) in a MySQL database? They are obviously 100's to 1000's of entries, so I'd REALLY rather avoid having to edit this manually (or indeed open every page they're on and resave)... Thanks ! T ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280184 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOT: SQL methods
Hi All, Just set up a MySql DB, and I'm trying to work out the best way to update multiple tables via CF: I.e: TblEvent EventID [key] EventName tblEventType EventTypeID [key] EventTypeName tblEventJoin EventJoinID [key] EventID EventTypeID So above, I might have an EventID, which has multple EventTypeIDs associated with it in tblEventJoin At the moment, the only way I can see of updating the tblEventJoin (assuming I have an EventiD and several EventTypeIDs which are associated) is to Query tblEventJoin, work out whether the Row already exists, if not Insert the record, and if a row exists which shouldnt, delete it. What's the best way to actually do this? Multiple CFQueries, and do the logic CF side, or is there a better method? As you can see, still a newbie on this.. Ta T ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279932 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: SQL methods
that's a fab idea... :) Thanks! T On 3 Jun 2007, at 14:41, Dan O'Keefe wrote: Tom, One method I have used in the past is when you query the join table and display the results, store the EventJoinID 's in a list hidden form variable. Then on post, wrapped in transaction, a single delete statement using the EventJoinID 's list will delete all of the old records, and then loop over your new joins and insert. It eliminates the need of worrying if a join was changed or deleted. You can also use cftry cfcatch to handle the transaction failing. Dan On 6/3/07, Tom King [EMAIL PROTECTED] wrote: Hi All, Just set up a MySql DB, and I'm trying to work out the best way to update multiple tables via CF: I.e: TblEvent EventID [key] EventName tblEventType EventTypeID [key] EventTypeName tblEventJoin EventJoinID [key] EventID EventTypeID So above, I might have an EventID, which has multple EventTypeIDs associated with it in tblEventJoin At the moment, the only way I can see of updating the tblEventJoin (assuming I have an EventiD and several EventTypeIDs which are associated) is to Query tblEventJoin, work out whether the Row already exists, if not Insert the record, and if a row exists which shouldnt, delete it. What's the best way to actually do this? Multiple CFQueries, and do the logic CF side, or is there a better method? As you can see, still a newbie on this.. Ta T ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279935 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT: SQL methods
Thanks, Ill look into that aswell :) Ta T On 3 Jun 2007, at 14:53, Robert Rawlins - Think Blue wrote: Well, My suggestion would be to put the weight of the task on the DB Engine if possible rather than CF, it'll be much more efficient. I'm a SQL Server guy and don't know MySQL very well, but from memory they have a REPLACE function, which determines if the record needs to updated or inserted, it might be worth you taking a look at it, I think that may achieve what you want it to, the syntax goes like this. REPLACE (col1, col2, col3) VALUES (val2, val2, val3) I think, anyway, It's a bit of a shot in the dark, but just thought I'd share it. Rob -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: 03 June 2007 14:44 To: CF-Talk Subject: Re: SOT: SQL methods that's a fab idea... :) Thanks! T On 3 Jun 2007, at 14:41, Dan O'Keefe wrote: Tom, One method I have used in the past is when you query the join table and display the results, store the EventJoinID 's in a list hidden form variable. Then on post, wrapped in transaction, a single delete statement using the EventJoinID 's list will delete all of the old records, and then loop over your new joins and insert. It eliminates the need of worrying if a join was changed or deleted. You can also use cftry cfcatch to handle the transaction failing. Dan On 6/3/07, Tom King [EMAIL PROTECTED] wrote: Hi All, Just set up a MySql DB, and I'm trying to work out the best way to update multiple tables via CF: I.e: TblEvent EventID [key] EventName tblEventType EventTypeID [key] EventTypeName tblEventJoin EventJoinID [key] EventID EventTypeID So above, I might have an EventID, which has multple EventTypeIDs associated with it in tblEventJoin At the moment, the only way I can see of updating the tblEventJoin (assuming I have an EventiD and several EventTypeIDs which are associated) is to Query tblEventJoin, work out whether the Row already exists, if not Insert the record, and if a row exists which shouldnt, delete it. What's the best way to actually do this? Multiple CFQueries, and do the logic CF side, or is there a better method? As you can see, still a newbie on this.. Ta T ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279937 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8 sample databases and HostMySite free hosting
Download the 30 day trial of Navicat which should let you do all the front end work T On 1 Jun 2007, at 13:13, Wayne Putterill wrote: I would like to get the CF8 sample databases up on the free beta hosting for CF8 from hostmysite, but I don't use MS SQL and so can't get access to a copy of them. Any suggestions? Would the best way to be to get a script from someone to create and populate the tables? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279816 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8 sample databases and HostMySite free hosting
Ok, to run MySql locally, just download the community server version from their website. To use MySql on HostMySite, you'll need to connect to their MySql installation (I'm assuming you can get the details from them) and then you can use a GUI frontend, such as Navicat to create the tables remotely, or import them from a local installation. T On 1 Jun 2007, at 13:43, Wayne Putterill wrote: The problem is that I don't have the backend ;) I could download the CF8 beta which would have the sample databases, but I haven't got MS SQL to load them onto. On 01/06/07, Tom King [EMAIL PROTECTED] wrote: Download the 30 day trial of Navicat which should let you do all the front end work T On 1 Jun 2007, at 13:13, Wayne Putterill wrote: I would like to get the CF8 sample databases up on the free beta hosting for CF8 from hostmysite, but I don't use MS SQL and so can't get access to a copy of them. Any suggestions? Would the best way to be to get a script from someone to create and populate the tables? ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279820 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: US Web Hosting vs UK
Thanks - helpful response :) T On 31 May 2007, at 00:11, Mike Kear wrote: I've been hosting in the US for years, and most of my sites are Australian sites. At first i worried about what I assumed would be lag, bu tsince i had no viable alternative at the time, I went with it. I found that it made no practical difference where the box was hosted. I have a client with a fairly high-traffic Australian site on Hostmysite.com and while it's not perfect, none of the issues he lists includes too slow response time. These US hosting companies have very big pipes to connect to, and multiple redundancy. My own hosting business for example is based in a giant data centre in Texas with thousands upon thousands of server boxes. I havent had anyone ever say to me that they want to move their sites to an Australian-based host because teh response time is too slow. There might be other issues and you should do you arithmetic on the money, but lag because it's hosted in the USA rather than the UK is NOT going to be one of your problems. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 5/31/07, Tom King [EMAIL PROTECTED] wrote: Am I shooting myself in the foot by looking at US hosting (i,e hostmysite.com ) even though the majority of sites I run are in the UK (or have a large UK audience + are co.uks?)? The pricing just seems so much... cheaper. There's the obvious issue of Lag, but if somewhere offers 24h tech support, that should be the only issue? T ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279687 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
US Web Hosting vs UK
Am I shooting myself in the foot by looking at US hosting (i,e hostmysite.com ) even though the majority of sites I run are in the UK (or have a large UK audience + are co.uks?)? The pricing just seems so much... cheaper. There's the obvious issue of Lag, but if somewhere offers 24h tech support, that should be the only issue? T ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279582 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Date now() +1?
Hi All, a quickie for someone hopefully? I have the following SQL: SELECT * from request.events WHERE EventDate #Now()#; This returns all event before 'today'.. How would I do it to get all events including today? (a sort of Now + 1 day?) Ta ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278960 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Date now() +1?
Ah ok, forgot to mention the time stamp I'm checking against won't have times, i.e 00:00:00 etc. So I need to do two things: One, get past events, two get forthcoming events: Past events has to get everything yesterday (by date) backwards, and forthcoming has to include today forwards: So for each of them, I just can't the syntax right to literally add or remove a day? T On 23 May 2007, at 13:28, Kris Jones wrote: This is one way of doing it. But watch out. Got bit by some old code that used this approach on the switch to daylight savings time. It's better to add a day, then subtract a second. If you want to check until midnight today: SELECT * from request.events WHERE EventDate #createDateTime(Year(Now()),Month(Now()),Day(Now()),11,59,59)# Also, you might want to use cfqueryparam to pass in the value to SQL. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278967 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Date now() +1?
Thanks all, the #dateAdd('d', -1, Now())# does what I need in both instances! :) On 23 May 2007, at 13:45, Scott Stroz wrote: To get forthcoming: #dateAdd('d',-1, Now())# To get previous events from yesterday back #Now()# You might want to look at the specific date functions for the DB you are using. I prefer to let the DB do any work it can rather than CF. As long as the business rules for what needs to be returned will not change, I'd rather have the DB figure out the date I need. On 5/23/07, Tom King [EMAIL PROTECTED] wrote: Ah ok, forgot to mention the time stamp I'm checking against won't have times, i.e 00:00:00 etc. So I need to do two things: One, get past events, two get forthcoming events: Past events has to get everything yesterday (by date) backwards, and forthcoming has to include today forwards: So for each of them, I just can't the syntax right to literally add or remove a day? T On 23 May 2007, at 13:28, Kris Jones wrote: This is one way of doing it. But watch out. Got bit by some old code that used this approach on the switch to daylight savings time. It's better to add a day, then subtract a second. If you want to check until midnight today: SELECT * from request.events WHERE EventDate #createDateTime(Year(Now()),Month(Now()),Day(Now()),11,59,59)# Also, you might want to use cfqueryparam to pass in the value to SQL. ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278970 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Date now() +1?
It's on a Query of Queries, so no cfqueryparam - b... :( T On 23 May 2007, at 15:33, Ben Nadel wrote: You should also check out CFQueryParam for timestamp in combo with date math: Date cfquaryparam value=#Fix( Now() + 1)# cfsqltype=CF_SQL_TIMESTAMP / The Now() + 1 will get you into tomorrow. The Fix() on that date will strip out the time and create an integer date. The CFQueryParam will convert your integer back into a SQL date/time stamp (with zeroed out time). This way has been awesome for me in the past. Here are some potentially useful date posts: http://www.bennadel.com/blog/226-ColdFusion-Date-Math-Faster-Than- Date-M ethods-And-Other-Date-Math-Ramblings.htm http://www.bennadel.com/blog/193-Adding-Numbers-To-Date-Time- Values.htm http://www.bennadel.com/blog/150-Ask-Ben-Appending-Times-To-Date- Time-Ob jects.htm .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 23, 2007 8:54 AM To: CF-Talk Subject: Re: Date now() +1? Thanks all, the #dateAdd('d', -1, Now())# does what I need in both instances! :) ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278985 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Date now() +1?
Sorry, yes, getting confused with Cachedwithin(). It's hot here today :( T On 23 May 2007, at 15:52, Ben Nadel wrote: You can use CFQueryParam on a query of queries. .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 23, 2007 10:37 AM To: CF-Talk Subject: Re: Date now() +1? It's on a Query of Queries, so no cfqueryparam - b... :( T On 23 May 2007, at 15:33, Ben Nadel wrote: You should also check out CFQueryParam for timestamp in combo with date math: Date cfquaryparam value=#Fix( Now() + 1)# cfsqltype=CF_SQL_TIMESTAMP / The Now() + 1 will get you into tomorrow. The Fix() on that date will strip out the time and create an integer date. The CFQueryParam will convert your integer back into a SQL date/time stamp (with zeroed out time). This way has been awesome for me in the past. Here are some potentially useful date posts: http://www.bennadel.com/blog/226-ColdFusion-Date-Math-Faster-Than- Date-M ethods-And-Other-Date-Math-Ramblings.htm http://www.bennadel.com/blog/193-Adding-Numbers-To-Date-Time- Values.htm http://www.bennadel.com/blog/150-Ask-Ben-Appending-Times-To-Date- Time-Ob jects.htm .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278987 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Outputting structs
Hi All, i've created a struct which when outputted, outputs in the 'wrong order' If you run the code below when you're in a subdirectory, i.e: /home/mydir1/mydir2/somepage.cfm each dir and page name is added to the struct in order: When I dump the struct, it comes out in the correct order, but when I loop it as a collection, it comes out in a wierd order? I know that structs don't have exact row numbering, but can anyone tell me why the dump order is different to the actual outputted order? Thanks T cfsilent cfscript //Create a struct to play with Bread.struct=StructNew(); //Set our root location currentlocale=/; /cfscript !---CGI.SCRIPT_NAME is the var with the current location in--- cfloop list=#cgi.SCRIPT_NAME# delimiters=/ index=i cfscript //Insert the looped value into the struct, replacing underscores and .cfm //The keyname becomes the URL, and the keyvalue is the text to link StructInsert(Bread.struct, #currentLocale##i#, #replace(replace(i, '_', ' ', 'all'), '.cfm', '', 'all')#); //Update currentlocale, which acts as the string to update currentlocale=#currentLocale##i#/; /cfscript /cfloop /cfsilent !---For demo purposes, dump the struct - note the order--- cfdump var=#bread# !---Output the struct--- cfoutput div p cfloop collection=#bread.struct# item=i cfoutput a href=#i##bread.struct[i]#/a gt; /cfoutput /cfloop p /div /cfoutput ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277276 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Outputting structs
On 8 May 2007, at 15:31, Ben Nadel wrote: My CFDumps seem to change order when I dump them out. I am surprised that your CFDump outputs in a consistent order. Yep! everytime... Instead of doing a collection loop, try doing a list loop over the struct keys StructKeyList(), then using those keys to access the struct. This might be more consistent. Same behaviour this end. Thankfully, in this example, the values are guaranteed to get larger by nature, so I could so a structsort by len() I guess... T ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277280 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: 5 domains, one set of templates and one CF hosting account.
You could do this many ways: For multiple languages, I often use session vars (that way the URLS don't get bogged up, but you do use a few more resources having all those sessions flying around I guess) But multiple sites, i.e different domain names on one hosted account I run each site out of it's own folder, then use ISAPI to rewrite the URLS: so www.domain.com/site1/ - www.site1.com This way, you could have a siteroot application.cfc, and then application.cfc's which extend the site root cfc. I've got about 25 sites running out of one hosting account using that technique: only catch is you can't use absolute siteroot URLs. T On 12 Mar 2007, at 14:40, Che Vilnonis wrote: I'm looking for some real world advice on how to properly configure my ColdFusion application for one hosting account that will host five different web sites that share the same core templates. Only the images and the databased information will change from site to site. What is the best way to initially determine the domain? (Can CGI variables always be used?) Once determined, what is the best way to maintain its value (and any other necessary specific site values) from page to page? Would session variables be my best bet? I'm sure this has been done before. Especially with sites that are published in multiple languages. Any tips or advice would be appreciated. Thanks, Che ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272373 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: php equivalent of application.cfc
Thanks all - the htacess trickery is worth a punt I feel ! T On 3 Mar 2007, at 10:45, Peter Boughton wrote: Uh, $50 a month is £308 a year. The £200 a year Tom asked for is $32 a month. $50(USD) a month will get you pretty good CF hosting at a lot of places... Sunshinetechsolutions.com Hostnexus.com Those are 2 good hosts... Eric -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: Friday, March 02, 2007 8:40 AM To: CF-Talk Subject: Re: php equivalent of application.cfc Heh, Can you 60 gigs a month bandwidth, 25 gigs webspace, with CF for less than £200 PA? T On 2 Mar 2007, at 13:26, Peter Boughton wrote: ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271399 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
OT: php equivalent of application.cfc
Hi All, Sorry for the OT: I'm new to PHP, and am trying to find out if there is the equivalent of application.cfc onrequest() function: I.e, I want to be able to do this, without having to put the includes in every file: cffunction name=onrequest cfargument name=targetpage'' required=yes cfinclude template=header.html cfinclude template=#targetpage# cfinclude template=footer.html /cffunction Help? Many thanks T ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271256 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: php equivalent of application.cfc
heheh, Not my choice, working on a site where they can't afford to move the hosting... If it was my choice, I'd rewrite the damn thing from scratch in CF T On 2 Mar 2007, at 11:24, Peter Boughton wrote: There isn't one. You can mimic it with Apache stuff - but why bother when its far better to stick to the glorious CFML and not have to worry about stuff like this. Perhaps you could say why you want to use PHP, so we can convince you that your reasons are worthless and you should stay with us. ;) Hi All, Sorry for the OT: I'm new to PHP, and am trying to find out if there is the equivalent of application.cfc onrequest() function: I.e, I want to be able to do this, without having to put the includes in every file: cffunction name=onrequest cfargument name=targetpage'' required=yes cfinclude template=header.html cfinclude template=#targetpage# cfinclude template=footer.html /cffunction Help? Many thanks T ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271263 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: php equivalent of application.cfc
That sounds like the sort of thing I'm after... Will now have to see if I can get to the ini file on shared hosting :( T On 2 Mar 2007, at 13:01, Rob Wilkerson wrote: Hey Tom - It's been a couple of years (like 5), but as of PHP 4, there was a setting in php.ini that allowed you to define a file that would be called before every request the way Application.cfm is called. You have to define it explicitly, but it behaves exactly the same way, in my experience. That file can include custom functions. Unfortunately, I can't remember the setting offhand. On 3/2/07, Tom King [EMAIL PROTECTED] wrote: Hi All, Sorry for the OT: I'm new to PHP, and am trying to find out if there is the equivalent of application.cfc onrequest() function: I.e, I want to be able to do this, without having to put the includes in every file: cffunction name=onrequest cfargument name=targetpage'' required=yes cfinclude template=header.html cfinclude template=#targetpage# cfinclude template=footer.html /cffunction Help? Many thanks T ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271264 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: php equivalent of application.cfc
hehe, so glad I don't have to deal with this on a regular basis - thanks for the tips! T On 2 Mar 2007, at 14:05, Rob Wilkerson wrote: Ugh. :-) On 3/2/07, Tom Chiverton [EMAIL PROTECTED] wrote: On Friday 02 Mar 2007, Rob Wilkerson wrote: That could work (as would the related require_once() function), but it's maintenance-intensive since it has to be explicitly included on every page. OTTOMH: find . -name '*.php' -exec cp {} {}.1;cat header.php {}.1 {} \; :-) -- Tom Chiverton Helping to simultaneously innovate B2C environments On: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271285 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: php equivalent of application.cfc
Heh, Can you 60 gigs a month bandwidth, 25 gigs webspace, with CF for less than £200 PA? T On 2 Mar 2007, at 13:26, Peter Boughton wrote: Ah, interesting... Did you see my survey about potential low-cost CFML hosting? /cheeky-plug :) heheh, Not my choice, working on a site where they can't afford to move the hosting... If it was my choice, I'd rewrite the damn thing from scratch in CF T On 2 Mar 2007, at 11:24, Peter Boughton wrote: ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271292 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Coldfusion RSS Aggregator
Dear All, I've built a basic RSS aggregator, using Ray's RSS.cfc (basically, all I've done is write a function which loops URLs into RSS .cfc and saves the output as one big Query) But am now running into problems (mainly to do with Date types in RSS 1.0): Has anyone else done this? Or are there any other CF aggregators (as in a component, NOT a site) which anyone has seen? Surely other people have this problem? Displaying multiple RSS feeds as one mega feed? Ta T ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267250 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldfusion RSS Aggregator
Just display them, but for some reason I'm getting an invalid data type from a valid 1.0 XML doc.. I think it's just a matter of going through Ray's code and see if I can put some extra validation in.. T On 23 Jan 2007, at 12:00, Brian Swartzfager wrote: Hi, Tom, I recently built an RSS/ATOM aggregator as a portlet for a portal system we're releasing this month. I loop through each feed URL as well, but the output is stored in an array of structures (each feed has its own structure and the last component of each structure is an array of the news items in the feed). I display a list of the feeds to the user, and use JavaScript to show or hide the news items in the feed whenever the user clicks on the feed title. It handles RSS 1.0, RSS 2.0, and ATOM feeds. I don't really do anything with the dates that come with the feeds (other than display them) and I've never looked at Ray's code: what are you trying to do with the dates? --Brian ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267289 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldfusion RSS Aggregator
Ha, that looks great. But I'm broke :) T On 23 Jan 2007, at 15:06, Pete Freitag wrote: On 1/23/07, Tom King [EMAIL PROTECTED] wrote: Or are there any other CF aggregators (as in a component, NOT a site) which anyone has seen? Hi Tom, We have a commercial feed parser for sale here: http://foundeo.com/feed-parser/ it seams to do a pretty good job (I have used it on numberous sites), and has built in caching. You can download a free trial to test it out... -- Pete Freitag http://foundeo.com/ - ColdFusion Consulting Products http://petefreitag.com/ - My Blog http://spendfish.com/ - Fish for Deals ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267303 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Changing Dreamweaver Configuration File Location
Hi all, I'm in a multiuser, (read networked) environment, and my Dreamweaver config folder is currently located over a network share - this is obviously degrading the performance somewhat, and causing various issues whenever there's a server timeout Is there a way of changing where Dreamweaver looks for it's configuration folder? Preferably I want to change it to a local disk... thanks all T ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265605 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: TinyMCE editor question
Those are conditional statements left in by word: You'll need to tell TinyMCE to strip them: Look at the TinyMCE documentation - there's a config there which helps you get towards XHTML compliance - use that in combination with parsing the string to strip out all the crap. T On 9 Dec 2006, at 00:37, Victor Moore wrote: Hi all, I have installed TinyMCE editor on a site and while it was easy to install and work with, has some issue: For example if a user copy and paste content from MS-Word 2003 using Firefox, everything looks OK in Firefox but it displays: !--[if !supportLists]--â !--[endif]-- when viewing the page with IE. If the same exercise is done using IE all the line breaks are removed. Is anything that can be done or is just bad luck using content from MS-Word Thanks Victor PS If anybody has an example cfm page of using FCKeditor, really appreciate. I have to fix this ASAP ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263751 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Multiple Sites on IIS 5 on XP?
Hi all, Is there a way to define multiple websites on Windows XP IIS 5? Obviously, on the server edition, one can right click in IIS config and create a new website easily, but my dev box is running XP pro and doesn't seem to have the functionality. http://localhost/foo/ is fine, but I want the site with it's own site root - http://foo/ per example. I'm getting fed up with having to second guess all the site relative links :) Thanks T ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262844 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Multiple Sites on IIS 5 on XP?
awesome, that's done the job. Ta muchly T On 5 Dec 2006, at 11:32, Robertson-Ravo, Neil (RX) wrote: Yes, you cannot create multiple sites in XP. There are several tools to do this.. Search for tools such as IISAdmin. HTH -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: 05 December 2006 11:30 To: CF-Talk Subject: Multiple Sites on IIS 5 on XP? Hi all, Is there a way to define multiple websites on Windows XP IIS 5? Obviously, on the server edition, one can right click in IIS config and create a new website easily, but my dev box is running XP pro and doesn't seem to have the functionality. http://localhost/foo/ is fine, but I want the site with it's own site root - http://foo/ per example. I'm getting fed up with having to second guess all the site relative links :) Thanks T ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262846 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Country Name Case
There's a CFC called titlecase.cfc on cflib.org which is usually used for names (i.e recognises von, de as small etc..) You may be able to alter it to suit your needs T On 22 Nov 2006, at 14:06, Andy Matthews wrote: You could do a test and cap the first letter of any word 4 letters or longer. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: RichL [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 22, 2006 5:03 AM To: CF-Talk Subject: Country Name Case Hi Guys I have a country reference table where all of the country names are held in upper case. I want to be able to output in lower case but keep the caps where appropriate (e.g. UNITED KINGDOM to United Kingdom). However I think that this going to be close to impossible as there are values such as: VIRGIN ISLANDS (BRITISH) VIRGIN ISLANDS (U.S.) WALLIS AND FUTANA So using a function to capitalise the first letter of each word won't really work. How have people approached this situation and has anybody found any good solution? Also, is there a UDF around for capitalising the first letter of each word? Thanks in advance -- Rich ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261389 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Country Name Case
Correction, its not on there, author was http://artlung.com but I can't seem to find it on there. Well, I have a copy if you want a look see T On 22 Nov 2006, at 14:16, Tom King wrote: There's a CFC called titlecase.cfc on cflib.org which is usually used for names (i.e recognises von, de as small etc..) You may be able to alter it to suit your needs T On 22 Nov 2006, at 14:06, Andy Matthews wrote: You could do a test and cap the first letter of any word 4 letters or longer. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: RichL [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 22, 2006 5:03 AM To: CF-Talk Subject: Country Name Case Hi Guys I have a country reference table where all of the country names are held in upper case. I want to be able to output in lower case but keep the caps where appropriate (e.g. UNITED KINGDOM to United Kingdom). However I think that this going to be close to impossible as there are values such as: VIRGIN ISLANDS (BRITISH) VIRGIN ISLANDS (U.S.) WALLIS AND FUTANA So using a function to capitalise the first letter of each word won't really work. How have people approached this situation and has anybody found any good solution? Also, is there a UDF around for capitalising the first letter of each word? Thanks in advance -- Rich ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261391 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
IIS vs Apache on Win2003 w CF
Hi All, Currently, we've got a couple of servers happily running IIS, +Server 2003 +ColdFusion, with some of the sites using access databases, which contrary to some people's experience on here, have been behaving very well. We want to set up a new server, and after some discussion have thought about running CF on Win2003 +Apache (+php) and thus having better mySql support: apparently installing MySql on IIS is not very straightforward. As I see it, the benefits are mySql + the use of htaccess and other such tricks, and we'd probably get something like NaviCat etc.. Are there any blog posts/articles about the 'gotchas' I might run into re: CF on this configuration? Thanks! T ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261065 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: IIS vs Apache on Win2003 w CF
Thanks to all for the insight: Looks like I've got some reading to do :) Ta T ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261075 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Group-level security theory
Just to throw in my two pennies worth: I have a CMS where there are about 20 websites which use the same editor, file upload etc. I do this the following way - I have a table with the web site specifics in, like the various upload directories, image directories etc, and then a User table. Each user has a list of approved websites, where the Unique ID for the website matches a list of IDs in the User entry. So when they login, I authenticate, then assign the various website variables to a session struct/query which are then used to display the info they require. Using the session scope means you can only assign them the information etc they need. You can then build the various templates you need for web page editing around the variables set in the session scope. T ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260054 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Head Banging Access LIKE error in QoQ
OK, This have been driving me nuts... request.photolist exists, and has phototag etc fields. variables.thistag is also fine: BUT, this code: cfquery dbtype=query name=GetTaggedPhotos SELECT * from request.photolist WHERE phototag LIKE '%#trim(variables.thistag)#%'; /cfquery Throws this very unhelpful error: The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code. Null Pointers are another name for undefined values. java.lang.NullPointerException Using this works, but obvious doesn't return the same recordset, as it's looking for an exact match: cfquery dbtype=query name=GetTaggedPhotos SELECT * from request.photolist WHERE phototag = '#variables.thistag#'; /cfquery Help??? Ta ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259406 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Head Banging Access LIKE error in QoQ
That's closer I think: I DO have empty fields interspersed with populated fields in the column.. Just need to get the syntax right now.. T -Original message- From: Katz, Dov B \(IT\) [EMAIL PROTECTED] Date: Tue, 7 Nov 2006 12:44:19 + To: CF-Talk cf-talk@houseoffusion.com Subject: RE: Head Banging Access LIKE error in QoQ Just a guess: You might have an empty phototag value somewhere Try WHERE ( phototag) LIKE %#trim(variables.thistag)#%' Or, try +phototag (not sure of syntax) Does this fix the issue? Dov -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 07, 2006 7:30 AM To: CF-Talk Subject: Head Banging Access LIKE error in QoQ OK, This have been driving me nuts... request.photolist exists, and has phototag etc fields. variables.thistag is also fine: BUT, this code: cfquery dbtype=query name=GetTaggedPhotos SELECT * from request.photolist WHERE phototag LIKE '%#trim(variables.thistag)#%'; /cfquery Throws this very unhelpful error: The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code. Null Pointers are another name for undefined values. java.lang.NullPointerException Using this works, but obvious doesn't return the same recordset, as it's looking for an exact match: cfquery dbtype=query name=GetTaggedPhotos SELECT * from request.photolist WHERE phototag = '#variables.thistag#'; /cfquery Help??? Ta ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259412 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Head Banging Access LIKE error in QoQ
Agh! that's it in a nutshell.. :( Oh for a solution*sigh* T -Original message- From: Ben Nadel [EMAIL PROTECTED] Date: Tue, 7 Nov 2006 13:21:22 + To: CF-Talk cf-talk@houseoffusion.com Subject: RE: Head Banging Access LIKE error in QoQ Tom, I think that is definitely the case. Check out this blog post: http://www.bennadel.com/index.cfm?dax=blog:144.view I have found that ColdFusion query of queries throws errors on NULL fields when using LIKE, UPPER(), and LOWER(). .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 07, 2006 8:07 AM To: CF-Talk Subject: RE: Head Banging Access LIKE error in QoQ That's closer I think: I DO have empty fields interspersed with populated fields in the column.. Just need to get the syntax right now.. T -Original message- From: Katz, Dov B \(IT\) [EMAIL PROTECTED] Date: Tue, 7 Nov 2006 12:44:19 + To: CF-Talk cf-talk@houseoffusion.com Subject: RE: Head Banging Access LIKE error in QoQ Just a guess: You might have an empty phototag value somewhere Try WHERE ( phototag) LIKE %#trim(variables.thistag)#%' Or, try +phototag (not sure of syntax) Does this fix the issue? Dov -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 07, 2006 7:30 AM To: CF-Talk Subject: Head Banging Access LIKE error in QoQ OK, This have been driving me nuts... request.photolist exists, and has phototag etc fields. variables.thistag is also fine: BUT, this code: cfquery dbtype=query name=GetTaggedPhotos SELECT * from request.photolist WHERE phototag LIKE '%#trim(variables.thistag)#%'; /cfquery Throws this very unhelpful error: The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code. Null Pointers are another name for undefined values. java.lang.NullPointerException Using this works, but obvious doesn't return the same recordset, as it's looking for an exact match: cfquery dbtype=query name=GetTaggedPhotos SELECT * from request.photolist WHERE phototag = '#variables.thistag#'; /cfquery Help??? Ta ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259421 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Head Banging Access LIKE error in QoQ
Yay!!! For reference, my SQL now reads: cfquery dbtype=query name=GetTaggedPhotos SELECT * from request.photolist WHERE ( PhotoTag IS NOT NULL AND PhotoTag LIKE '%#trim(variables.thistag)#%' ); /cfquery Thanks y'all T -Original message- From: Ben Nadel [EMAIL PROTECTED] Date: Tue, 7 Nov 2006 13:30:39 + To: CF-Talk cf-talk@houseoffusion.com Subject: RE: Head Banging Access LIKE error in QoQ Tom, I am pretty sure that Query of queries using short circuit evaluation. This should allow you to test for NULL before actually performing the LIKE evaluation: WHERE AND ( A IS NOT NULL AND A LIKE '%foo%' ) If A IS NULL then the first part of the AND statement should fail and the rest should not be fired. The LIKE clause should only every be evaluated if the first part is also true (A IS NOT NULL). .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 07, 2006 8:25 AM To: CF-Talk Subject: RE: Head Banging Access LIKE error in QoQ Agh! that's it in a nutshell.. :( Oh for a solution*sigh* T -Original message- From: Ben Nadel [EMAIL PROTECTED] Date: Tue, 7 Nov 2006 13:21:22 + To: CF-Talk cf-talk@houseoffusion.com Subject: RE: Head Banging Access LIKE error in QoQ Tom, I think that is definitely the case. Check out this blog post: http://www.bennadel.com/index.cfm?dax=blog:144.view I have found that ColdFusion query of queries throws errors on NULL fields when using LIKE, UPPER(), and LOWER(). .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 07, 2006 8:07 AM To: CF-Talk Subject: RE: Head Banging Access LIKE error in QoQ That's closer I think: I DO have empty fields interspersed with populated fields in the column.. Just need to get the syntax right now.. T -Original message- From: Katz, Dov B \(IT\) [EMAIL PROTECTED] Date: Tue, 7 Nov 2006 12:44:19 + To: CF-Talk cf-talk@houseoffusion.com Subject: RE: Head Banging Access LIKE error in QoQ Just a guess: You might have an empty phototag value somewhere Try WHERE ( phototag) LIKE %#trim(variables.thistag)#%' Or, try +phototag (not sure of syntax) Does this fix the issue? Dov -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 07, 2006 7:30 AM To: CF-Talk Subject: Head Banging Access LIKE error in QoQ OK, This have been driving me nuts... request.photolist exists, and has phototag etc fields. variables.thistag is also fine: BUT, this code: cfquery dbtype=query name=GetTaggedPhotos SELECT * from request.photolist WHERE phototag LIKE '%#trim(variables.thistag)#%'; /cfquery Throws this very unhelpful error: The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code. Null Pointers are another name for undefined values. java.lang.NullPointerException Using this works, but obvious doesn't return the same recordset, as it's looking for an exact match: cfquery dbtype=query name=GetTaggedPhotos SELECT * from request.photolist WHERE phototag = '#variables.thistag#'; /cfquery Help??? Ta ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259425 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMail Problem - unable to send email form
cfmail to=form.email from=session.auth.email subject=Overs Form type=html server=smtp.mail.anet.com Should be cfmail to=#form.email# from=#session.auth.email# subject=Overs Form type=html server=smtp.mail.anet.com Should it not? On 2 Nov 2006, at 15:08, Madhuri Joshi wrote: cfmail to=form.email from=session.auth.email subject=Overs Form type=html server=smtp.mail.anet.com ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258859 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFFORM: Making an image with CFGRID a link with rel attribute
Hi all, New to CFFORM (flash) here - Im creating an admin system for a photogallery - Im outputting thumbnails, with their captions into rows, which are then editable. What I need to do now is make the thumbnails into a link, so people can view the full size image, but preferably, I want the link to have a 'rel=lightbox' attribute, so they'll open in lightbox.js. I've already created the necessary html link, which I've put into the query as a row, so each record has the necessary string, I'm just foxed how to implement it. the href attribute obviously only works for applets, so I'm a little stuck.. Ideas please? Code below.. !---Get Photos Recordset (returns GalleryID,PhotoFileName,PhotoFormat,PhotoCaption,PhotoID--- cfinvoke component=components.managephotos method=getcaptions returnvariable=Getphotos/cfinvoke cfscript //Set up the Query OutputPhotos = QueryNew(thumbnail,id,Caption,larger, varchar,integer,varchar,varchar); //Create Rows QueryAddRow(OutputPhotos, GetPhotos.Recordcount); /cfscript cfset counter=1 cfloop query=GetPhotos cfscript //Loop Adding contents to Q QuerySetCell(OutputPhotos, thumbnail, gallery_thumbnails/#GalleryID#/#PhotoFileName#.#PhotoFormat#, counter); QuerySetCell(OutputPhotos, id, #PhotoID#, counter); QuerySetCell(OutputPhotos, Caption, #PhotoCaption#, counter); QuerySetCell(OutputPhotos, larger, a href=../images/gallery_fullsize/#GalleryID#/ #PhotoFileName#.#PhotoFormat # rel=lightboxView/a, counter); /cfscript cfset counter=counter+1 /cfloop !---Output Form--- cfform name=myform height=500 width=750 format=Flash timeout=100 onload=formOnLoad() cfformitem type=script function formOnLoad(){ myGrid.getColumnAt(1).labelFunction = setLabel; } function setLabel(item:Object, columnName:String): String { if ( item[columnName] != undefined) { return ../images/ + item[columnName]; } else { return ; } }; /cfformitem cfgrid name=myGrid rowHeight=74 rowheaders=false query=OutputPhotos width=730 height=350 selectmode=edit !---img Thumbnail--- cfgridcolumn name=thumbnail type=image width=116 header=Photo select=no !---Editable Caption Field--- cfgridcolumn name=caption header=Caption !---Hidden ID field--- cfgridcolumn name=id header=id select=no width=50 display=no /cfgrid cfinput type=submit name=submit value=submit /cfform /cfif ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257972 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: PLEASE HELP! Why is this application.cfc erroring out?
Don't you need cfif EventName NEQ onApplicationEnd AND EventName NEQ onSessionEnd in the OnError Function? T On 18 Oct 2006, at 13:26, Ben Nadel wrote: Can someone please help me out here. My Application.cfc is throwing errors on OnApplicationEnd method. I am banging my head against the wall here. No idea what is going on and the debugging is not useful at all. The error get's written to the file error.htm. If anyone can lend a hand, that would be AWESOME. Code: http://bennadel.com/index.cfm?dax=blog:354.view Thanks so much! Ben .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257152 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: PLEASE HELP! Why is this application.cfc erroring out?
Here is my error handling function: I think I'm right in saying that without those additional lines, cfabort (if it's anywhere in your script) will set off an error, and this way, ending the session or application won't trigger said script either.. T ps - I'm a complete newbie, so I may be way off mark with this... cffunction name=onError returntype=void output=true cfargument name=exception required=yes/ cfargument name=eventName type=string required=yes/ cfif StructKeyExists(arguments.exception.RootCause,type) AND arguments.exception.RootCause.type EQ coldfusion.runtime.AbortException cfreturn/ /cfif cfif EventName NEQ onApplicationEnd AND EventName NEQ onSessionEnd cfmail to=[EMAIL PROTECTED] from=Oxalto Error Handling subject=Error: Brabant Ensemble type=html cfif IsDefined(variables.error)cfdump var=#variables.error# label=Error Variables//cfif cfdump var=#arguments.exception# label=Exception Variables/ cfdump var=#CGI# label=CGI Variables/ cfdump var=#application# label=Application /cfmail !--- message--- cfoutput !DOCTYPE html PUBLIC -//W3C// DTD XHTML 1.0 Strict//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd; html xmlns=http://www.w3.org/1999/xhtml; lang=en head meta http-equiv=Content-Type content=text/html; charset=ISO-8859-1 / style type=text/css media=all body {font:75%/140% Arial, Helvetica, sans-serif;text-align:center;} h1 {font- weight:normal;} a {color:##39c; text-decoration:none;} a:hover {text-decoration:underline;} ##container {margin:20% auto;width: 50%; text-align:left;} /style titleFooe/title /head body div id=container h1An Error has Occured/h1 p/p pIf this problem persists, please contact our a href=mailto:[EMAIL PROTECTED]Webmaster/a./p /div /body /html /cfoutput /cfif /cffunction On 18 Oct 2006, at 13:39, Ben Nadel wrote: Maybe I do? Please explain? .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 8:37 AM To: CF-Talk Subject: Re: PLEASE HELP! Why is this application.cfc erroring out? Don't you need cfif EventName NEQ onApplicationEnd AND EventName NEQ onSessionEnd in the OnError Function? T On 18 Oct 2006, at 13:26, Ben Nadel wrote: Can someone please help me out here. My Application.cfc is throwing errors on OnApplicationEnd method. I am banging my head against the wall here. No idea what is going on and the debugging is not useful at all. The error get's written to the file error.htm. If anyone can lend a hand, that would be AWESOME. Code: http://bennadel.com/index.cfm?dax=blog:354.view Thanks so much! Ben .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257155 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: PLEASE HELP! Why is this application.cfc erroring out?
I've just run your application.cfc on my dev machine and can't get an error just thought you'd like to know that it does work for some people! T On 18 Oct 2006, at 13:56, Ben Nadel wrote: Tom, I see what you are saying, but two issues: 1. My code does not have any CFAbort tags, just the Application.cfc and the index.cfm. 2. You are checking for the EventName in the OnError method, which means that the OnError event has already fired when you are performing the check. I am not concerned with stuff inside the OnError method. I am concerned as to why the OnError even is being fired in the first place. Thanks for the suggestions, Ben .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 8:52 AM To: CF-Talk Subject: Re: PLEASE HELP! Why is this application.cfc erroring out? Here is my error handling function: I think I'm right in saying that without those additional lines, cfabort (if it's anywhere in your script) will set off an error, and this way, ending the session or application won't trigger said script either.. T ps - I'm a complete newbie, so I may be way off mark with this... cffunction name=onError returntype=void output=true cfargument name=exception required=yes/ cfargument name=eventName type=string required=yes/ cfif StructKeyExists(arguments.exception.RootCause,type) AND arguments.exception.RootCause.type EQ coldfusion.runtime.AbortException cfreturn/ /cfif cfif EventName NEQ onApplicationEnd AND EventName NEQ onSessionEnd cfmail to=[EMAIL PROTECTED] from=Oxalto Error Handling subject=Error: Brabant Ensemble type=html cfif IsDefined(variables.error)cfdump var=#variables.error# label=Error Variables//cfif cfdump var=#arguments.exception# label=Exception Variables/ cfdump var=#CGI# label=CGI Variables/ cfdump var=#application# label=Application /cfmail !--- message--- cfoutput !DOCTYPE html PUBLIC -// W3C// DTD XHTML 1.0 Strict//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd; html xmlns=http://www.w3.org/1999/xhtml; lang=en head meta http-equiv=Content-Type content=text/html; charset=ISO-8859-1 / style type=text/css media=all body {font:75%/140% Arial, Helvetica, sans-serif;text-align:center;} h1 {font- weight:normal;} a {color:##39c; text-decoration:none;} a:hover {text-decoration:underline;} ##container {margin:20% auto;width: 50%; text-align:left;} /style titleFooe/title /head body div id=container h1An Error has Occured/h1 p/p pIf this problem persists, please contact our a href=mailto:[EMAIL PROTECTED]Webmaster/a./p /div /body /html /cfoutput /cfif /cffunction On 18 Oct 2006, at 13:39, Ben Nadel wrote: Maybe I do? Please explain? .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 8:37 AM To: CF-Talk Subject: Re: PLEASE HELP! Why is this application.cfc erroring out? Don't you need cfif EventName NEQ onApplicationEnd AND EventName NEQ onSessionEnd in the OnError Function? T On 18 Oct 2006, at 13:26, Ben Nadel wrote: Can someone please help me out here. My Application.cfc is throwing errors on OnApplicationEnd method. I am banging my head against the wall here. No idea what is going on and the debugging is not useful at all. The error get's written to the file error.htm. If anyone can lend
Re: PLEASE HELP! Why is this application.cfc erroring out?
Nothing is being written to error.htm, and the application struct is being dumped into the page successfully. T On 18 Oct 2006, at 14:11, Ben Nadel wrote: Tom, Just to be clear, you cannot see the error on the page... It only get's written to that HTML file. Are you not seeing the error on page or is it not writing any HTML file? .. Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 18, 2006 9:06 AM To: CF-Talk Subject: Re: PLEASE HELP! Why is this application.cfc erroring out? I've just run your application.cfc on my dev machine and can't get an error just thought you'd like to know that it does work for some people! T ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257162 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF blog application
Ray Camdens BlogCFC :) On 17 Oct 2006, at 12:40, Ali Majdzadeh wrote: Hi: I need a blog application in cfm with ms-access or ms-sql (for personal use). Do you know a good one? thanks Benign ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256996 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Cf vs ?
This might be one argument for starting a forum, rather than having an email list - I find it quite difficult to browse Houseoffusion Hence, flogged horses are dragged out more often than they might be (rather than just see so and so thread)... Ironically, the change to a forum rather than a mailing list is probably another flogged horse... T On 13 Oct 2006, at 15:39, Teddy Payne wrote: John, It is not a touchy subject. It is shall we say a, well beaten horse. It is not your fault. I was just trying to prevent yet another thread that forces so many to justify themselves uneccessarily. We enjoy the product to the point where we subject ourselves to debates so strong that bloggers and podcasters report the results like boxing title fights. Teddy On 10/13/06, John Cox [EMAIL PROTECTED] wrote: On 10/13/06, Cutter (CFRelated) [EMAIL PROTECTED] wrote: John, I would agree with you, if it weren't for guys like NewAtlanta putting out a free version of BlueDragon or the Railo project. Cost is not a valid argument any more (NewAtlanta has offered a free edition of BD since2003? Josh, Vince, pipe in anytime here). Not trying to start a pissing contest here, just saying that there are options if one is willing to research them. heh, you guys seem to think I am shying away from CF because of cost. I am obviously on this list, and am using CF daily. Just saying what my impression was prior to using it, and why I wouldn't have learned CF had I not taken my current position. It's no biggie to me at all, but to say that there isn't an impression of cost associate, again, I say impression is over looking one obvious difference. No one needs to convince me though either way though. To me it doesn't really matter one way or another as long as I can do a cost justification. A programming language is just a tool to use to meet an end. To me, I don't really care if I am writing in PHP / Ruby / ColdFusion, as long as I can do what I need to do. If I can make a case that CF allows me to do it faster with less man-power, then great, I can justify the cost. No biggie. Are CF developers less for me to hire than PHP / Ruby / PERL developers? Great, I can justify the cost. No biggie. I admit that I am new here, so my apologies for the comment if bringing up costs associated is a touchy subject, as it appears to be. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256673 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RSS + CF
Hi all, I'm looking for some code to create RSS feeds from a DB output (i.e news , you know the sort of thing) Ideally I'm looking for something which will let me specify a query and then output the contents into a flat XML file, preferably removing all the potentially invalid chars.. Any CFCs out there? Thanks, T ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256242 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: RSS + CF
Thanks to all for the tips! Ray - i've got your rss.cfc working a treat: However, much as I am a newbie, I have to point out that on line 177 of the cfc, for valid XML should read: dc:date#dateFormat(arguments.data.date,-mm-dd)#T#timeFormat (arguments.data.date,HH:mm:ss)##numberFormat(z.utcHourOffset,00)#: 00/dc:date (as the cfif statement there is seemingly redundant, as the - or + is in the HourOffset already) Probably a CF 7 thing? T On 11 Oct 2006, at 15:03, Raymond Camden wrote: A bit old - but it worked just fine last time I tested it: http://ray.camdenfamily.com/index.cfm/2005/5/10/RSScfc-Update On 10/11/06, Larry Lyons [EMAIL PROTECTED] wrote: Hi all, I'm looking for some code to create RSS feeds from a DB output (i.e news , you know the sort of thing) Ideally I'm looking for something which will let me specify a query and then output the contents into a flat XML file, preferably removing all the potentially invalid chars.. Any CFCs out there? Thanks, T Here are a few tutorials on the topic: http://www.petefreitag.com/item/465.cfm http://blog.daemon.com.au/archives/000104.html http://www.devx.com/xml/Article/10790/0/page/1 As for existing CFC's, its relatively simple so I've just rolled out my own. hth, larry -- Larry C. Lyons Web Analyst BEI Resources American Type Culture Collection http://www.beiresources.org email: llyons(at)atcc(dot)org tel: 703.365.2700.2678 -- ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256317 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: RSS + CF
It was showing both a + and a - rather than just one of them which made the Timestamp invalid. T On 11 Oct 2006, at 16:20, Raymond Camden wrote: I'm trying to remember my reason for it. I think the idea was that it was backwards. An offset of -5 meant I needed to show +(offset*-1). Ignoring that though - what change did you makde for valid xml? I don't see any change except the removal of the if. On 10/11/06, Tom King [EMAIL PROTECTED] wrote: Thanks to all for the tips! Ray - i've got your rss.cfc working a treat: However, much as I am a newbie, I have to point out that on line 177 of the cfc, for valid XML should read: dc:date#dateFormat(arguments.data.date,-mm-dd)#T#timeFormat (arguments.data.date,HH:mm:ss)##numberFormat (z.utcHourOffset,00)#: 00/dc:date (as the cfif statement there is seemingly redundant, as the - or + is in the HourOffset already) Probably a CF 7 thing? T On 11 Oct 2006, at 15:03, Raymond Camden wrote: A bit old - but it worked just fine last time I tested it: http://ray.camdenfamily.com/index.cfm/2005/5/10/RSScfc-Update On 10/11/06, Larry Lyons [EMAIL PROTECTED] wrote: Hi all, I'm looking for some code to create RSS feeds from a DB output (i.e news , you know the sort of thing) Ideally I'm looking for something which will let me specify a query and then output the contents into a flat XML file, preferably removing all the potentially invalid chars.. Any CFCs out there? Thanks, T Here are a few tutorials on the topic: http://www.petefreitag.com/item/465.cfm http://blog.daemon.com.au/archives/000104.html http://www.devx.com/xml/Article/10790/0/page/1 As for existing CFC's, its relatively simple so I've just rolled out my own. hth, larry -- Larry C. Lyons Web Analyst BEI Resources American Type Culture Collection http://www.beiresources.org email: llyons(at)atcc(dot)org tel: 703.365.2700.2678 -- ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256336 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Error handling and dumping vars into an email not using CFOBJECT
Dear All, I'm using the following script to dump the various scopes which exist into an email as a form of error handling. However, my shared host has locked down CFOBJECT, so this doesn't work unless I remove some of the structs being dumped. The Script in application.cfc: cffunction name=onError returntype=void output=true cfargument name=exception required=yes/ cfargument name=eventName type=string required=yes/ cfif StructKeyExists (arguments.exception.RootCause,type) AND arguments.exception.RootCause.type EQ coldfusion.runtime.AbortException cfreturn/ /cfif cfif EventName NEQ onApplicationEnd AND EventName NEQ onSessionEnd cfmail to=[EMAIL PROTECTED] from=Error Handling subject=Error: website type=html cfif IsDefined (variables.error) cfdump var=#variables.error# label=Error Variables/ /cfif cfdumpvar=#arguments.exception# label=Exception Variables/ cfdump var=#CGI# label=CGI Variables/ cfdump var=#application# label=Application /cfmail !--- message--- cfoutput h1An Error has Occured/h1 pIf this problem persists, please contact our a href=mailto:[EMAIL PROTECTED]Webmaster/a./p /cfoutput /cfif /cffunction the Error: java method security exception. A security exception occurred while invoking java method on a java.lang.Class object. MethodName is getMethods. Possible cause: createobject function and cfobject tag are disabled in the security sand box. Any ideas how I might get around this? Ta T ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255359 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Hosting companies
In which country? T On 8 Sep 2006, at 13:24, Doug Brown wrote: Was wondering who the best hosting companies were. Need to support mySql. Thanks ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252507 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Password access for PDF files
Add an Isapi rewrite to redirect all .pdfs to a page like library.cfm? file=filename.ext Then you can log the filename and any other info in a database, and then serve the file via CFHEADER.? T On 6 Sep 2006, at 16:26, Andy Matthews wrote: I'm working on a simple access for PDF files and HTML page on my client's website. There's nothing sensitive about them, they just want to start collecting user info. So my thought is to have an intermediate page which checks to see if the user is logged in; stores info about the view in the database; then redirects the user to the page/file. Problem is that I just tried it and it tried to view it in the browser, not just the PDF but the underlying source code. So I'm wondering what might be the best way to do this. My requirements are: 1) User must log in to view anything inside the library. At this point the various files and pages are in various directories, but if needed I could consolidate them all into a library directory. 2) Store information about the view in the database. 3) Redirect user to the appropriate file. Thoughts? !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252218 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Password access for PDF files
The ISAPI rewrite would catch ALL instances of .pdf or whatever you script it to: So , www.domain.com/test.pdf would be caught, rewritten to: www.domain.com/library/downloads.cfm?file=test.pdf The file string could then be parsed, checked in a databse, and then served if approved. You'd have to put an exception in the http.ini file to prevent the Filter from re-catching the .pdf in the ?file= string though! T On 6 Sep 2006, at 16:36, Andy Matthews wrote: Right. I'm planning on some system setups to make sure that people can't link directly to the file. How would this work though with alternate file types? For example, all but 3 or 4 of my newsletters are PDF. The other 3 or 4 are plain Coldfusion pages. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 06, 2006 10:32 AM To: CF-Talk Subject: Re: Password access for PDF files Add an Isapi rewrite to redirect all .pdfs to a page like library.cfm? file=filename.ext Then you can log the filename and any other info in a database, and then serve the file via CFHEADER.? T On 6 Sep 2006, at 16:26, Andy Matthews wrote: I'm working on a simple access for PDF files and HTML page on my client's website. There's nothing sensitive about them, they just want to start collecting user info. So my thought is to have an intermediate page which checks to see if the user is logged in; stores info about the view in the database; then redirects the user to the page/file. Problem is that I just tried it and it tried to view it in the browser, not just the PDF but the underlying source code. So I'm wondering what might be the best way to do this. My requirements are: 1) User must log in to view anything inside the library. At this point the various files and pages are in various directories, but if needed I could consolidate them all into a library directory. 2) Store information about the view in the database. 3) Redirect user to the appropriate file. Thoughts? !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252220 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Rich text Editors
Thanks all for the pointers: I've now successfully integrated TinyMCE into my Custom made CF CMS :) Its really is VERY good... Ta T On 1 Sep 2006, at 05:35, Paul Hastings wrote: James Holmes wrote: Is that something FCK does much better? TinyMCE is pretty good too. I prefer it to FCK. TinyMCE's i18n bits are for the birds. in my opinion, yes. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251730 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Rich text Editors
Hi All, Has anyone come across a Rich Text Editor which meets the following requirements: - Doesn't use inline styles, i.e p,em,i,h1,h2,h3,h4,h5,h6 only - Could load an external CSS stylesheet so what you see in the RTE window takes on the necessary styles of the website in which you're trying to edit - Filters out cut and pasted formatting (but more specifically, word) - Has html view - Has an image browser to browse a predetermined image directory on the server - Could be used on Shared Hosting, so not a fully fledged CMS I've found Widgeditor, which is almost there, but sadly not being developed anymore. Anything in Java/Flash which springs to mind? I've got quite far using Widgeditor + Cffile/Directory for writing and creating pages via a admin section, but it's not that user friendly.. Thanks all, T ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251636 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Flash Forms
Hi All, Please excuse my ignorance: I've got cfforms (flash forms) working on my local machine (WinXP, CF7 Dev edition), But on my IIS 6/Win2003/CF7 server hey simply don't appear: No preloader, error message, nothing. Presumably as I've them working locally it's not a code issue - However, in the source code, you see: script type=text/javascript charset='utf-8' src='/CFIDE/scripts/cfformhistory.js'/script noscript embed pluginspage='http://www.macromedia.com/go/getflashplayer' id='testform' src='/1385384305.mxml.cfswf' width='750' height='250' wMode='Window' flashVars='%5F%5Ftestform%5Fcacheid=2E59C667%2D015B%2D109D%2D52A0A7F842F20C2 9%5F%5Fwebcastgrid%5Fcacheid=2E59C657%2DE944%2D6AB1%2DA78DC673CCA2F519' /embed /noscript script type=text/javascript charset='utf-8' document.write(embed pluginspage='http://www.macromedia.com/go/getflashplayer' ); document.write( id='testform' ); document.write( src='/1385384305.mxml.cfswf' ); document.write( width='750' ); document.write( height='250' ); document.write( wMode='Window' ); document.write( flashVars='historyUrl=%2FCFIDE%2Fscripts%2Fcfformhistory%2Ecfm%3Flconid= + lc_id +%5F%5Ftestform%5Fcacheid=2E59C667%2D015B%2D109D%2D52A0A7F842F20C29%5F%5F webcastgrid%5Fcacheid=2E59C657%2DE944%2D6AB1%2DA78DC673CCA2F519' /embed); /script script type=text/javascript charset='utf-8' document.write(briframe src='/CFIDE/scripts/cfformhistory.cfm' name='_history' frameborder='0' scrolling='no' width='22' height='0'/iframe/br ); /script My question is this, do you need flash (as in flash player) itself installed on the server for this to work, or is the flash form function built into CF? I'm sure it must be something simple.. Many Thanks, T ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212179 Archives: http://www.houseoffusion.com/cf_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: Flash Forms
If anyone's interested, I figured out the problem, CF was looking for the flash compilers and libraries in the wrong place, as the CFIDE dir is on a different partition, and I had the flash forms debugging turned off.. *sigh* T -Original Message- From: Tom King [mailto:[EMAIL PROTECTED] Sent: 19 July 2005 10:18 To: CF-Talk Subject: Flash Forms Hi All, Please excuse my ignorance: I've got cfforms (flash forms) working on my local machine (WinXP, CF7 Dev edition), But on my IIS 6/Win2003/CF7 server hey simply don't appear: No preloader, error message, nothing. Presumably as I've them working locally it's not a code issue - However, in the source code, you see: script type=text/javascript charset='utf-8' src='/CFIDE/scripts/cfformhistory.js'/script noscript embed pluginspage='http://www.macromedia.com/go/getflashplayer' id='testform' src='/1385384305.mxml.cfswf' width='750' height='250' wMode='Window' flashVars='%5F%5Ftestform%5Fcacheid=2E59C667%2D015B%2D109D%2D52A0A7F842F20C2 9%5F%5Fwebcastgrid%5Fcacheid=2E59C657%2DE944%2D6AB1%2DA78DC673CCA2F519' /embed /noscript script type=text/javascript charset='utf-8' document.write(embed pluginspage='http://www.macromedia.com/go/getflashplayer' ); document.write( id='testform' ); document.write( src='/1385384305.mxml.cfswf' ); document.write( width='750' ); document.write( height='250' ); document.write( wMode='Window' ); document.write( flashVars='historyUrl=%2FCFIDE%2Fscripts%2Fcfformhistory%2Ecfm%3Flconid= + lc_id +%5F%5Ftestform%5Fcacheid=2E59C667%2D015B%2D109D%2D52A0A7F842F20C29%5F%5F webcastgrid%5Fcacheid=2E59C657%2DE944%2D6AB1%2DA78DC673CCA2F519' /embed); /script script type=text/javascript charset='utf-8' document.write(briframe src='/CFIDE/scripts/cfformhistory.cfm' name='_history' frameborder='0' scrolling='no' width='22' height='0'/iframe/br ); /script My question is this, do you need flash (as in flash player) itself installed on the server for this to work, or is the flash form function built into CF? I'm sure it must be something simple.. Many Thanks, T ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212184 Archives: http://www.houseoffusion.com/cf_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
Event gateways and real player
Dear All, This is my first post to this list! I'm looking to possibly set a way to divert CF page requests made from within real player (enterprise or likewise) to a site. At the moment, I can browse the pages from within real player, but want to customise the pages specifically: Is this the sort of thing I could do with an Event gateway? Or is there a simpler way of doing it? I'm assuming that the internal browser built into real player will be identifiable to CF, and thus you could divert requests, much like you would do if browsing from a mobile device? Any ideas on this would be appreciated. Best, Tom ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211955 Archives: http://www.houseoffusion.com/cf_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