Stored Procedures in a CFC
Hi there, I have a SP wrapped in a CFC. The SP returns two record sets, which i use cfprocresult to reference. How do i then return the 2 queries via the CFC? Cheers Andy J www.andyjarrett.co.uk ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197229 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Stored Procedures in a CFC
Good question, I believe you will have to enter the two resultset objects into a single CF complex object (such as a Structure) and return that as a single value. -Original Message- From: Andy Jarrett [mailto:[EMAIL PROTECTED] Sent: 03 March 2005 09:01 To: CF-Talk Subject: Stored Procedures in a CFC Hi there, I have a SP wrapped in a CFC. The SP returns two record sets, which i use cfprocresult to reference. How do i then return the 2 queries via the CFC? Cheers Andy J www.andyjarrett.co.uk ~| 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:197230 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Skins in XML forms
There is a lot of information in the new help files in CFMX7, but i havent been able to find out how to tinker with the skins of XML forms. Specifically, what files I need to tinker with. i've found a file called blue.xml for example, but that seeems to refer to the specs of the 'blue' skin for charts. (also the fact that it's in the folder c:\cfusionmx7\charting\styles) I know I'm bound to regret this, but can anyone tell me which file represents the xml form 'skin' and in the xml file, and where the css file goes in a css defined skin? -- Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~| 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:197231 Archives: http://www.houseoffusion.com/cf_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: Skins in XML forms
I think it's /cfide/scripts Andy On Thu, 3 Mar 2005 21:58:24 +1100, Mike Kear [EMAIL PROTECTED] wrote: There is a lot of information in the new help files in CFMX7, but i havent been able to find out how to tinker with the skins of XML forms. Specifically, what files I need to tinker with. i've found a file called blue.xml for example, but that seeems to refer to the specs of the 'blue' skin for charts. (also the fact that it's in the folder c:\cfusionmx7\charting\styles) I know I'm bound to regret this, but can anyone tell me which file represents the xml form 'skin' and in the xml file, and where the css file goes in a css defined skin? -- Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~| 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:197232 Archives: http://www.houseoffusion.com/cf_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
I got it! Output grouped query horizontal loop thingamajig.
Here's my final code that worked in case it may help someone else in the future. Is nothing fancy, but here it is anyway! Thanks Charlie and Ade, Will cfset ctr=0 table width=90% align=left cellpadding=6 tr cfoutput query=getprodsbycategory group=prodmodelcode cfset ctr=ctr + 1 td height=90 bgcolor=##00 div align=centera href=itemdetail.cfm?MODEL=#getprodsbycategory.prodmodelcode#img src=productimages/#getprodsbycategory.imagename# alt=Click for details width=160 height=160 border=0 //a br / a href=itemdetail.cfm?MODEL=#getprodsbycategory.prodmodelcode##getprodsbycategory.prodmodeltitle#/a br / span style=font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; color:##F7F7F7$strong#getprodsbycategory.prodsellprice#/strong/span /div /td cfif ctr MOD 3 EQ 0 /trtr /cfif /cfoutput /table ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197233 Archives: http://www.houseoffusion.com/cf_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: I got it! Output grouped query horizontal loop thingamajig.
You could use [queryname].currentrow MOD 3 EQ 0 instead of the ctr variable. Slightly more elegant (IMO) and slightly easier. Pete On Thu, 03 Mar 2005 06:28:35 -0400, Will The Game [EMAIL PROTECTED] wrote: Here's my final code that worked in case it may help someone else in the future. Is nothing fancy, but here it is anyway! Thanks Charlie and Ade, Will cfset ctr=0 table width=90% align=left cellpadding=6 tr cfoutput query=getprodsbycategory group=prodmodelcode cfset ctr=ctr + 1 td height=90 bgcolor=##00 div align=centera href=itemdetail.cfm?MODEL=#getprodsbycategory.prodmodelcode#img src=productimages/#getprodsbycategory.imagename# alt=Click for details width=160 height=160 border=0 //a br / a href=itemdetail.cfm?MODEL=#getprodsbycategory.prodmodelcode##getprodsbycategory.prodmodeltitle#/a br / span style=font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; color:##F7F7F7$strong#getprodsbycategory.prodsellprice#/strong/span /div /td cfif ctr MOD 3 EQ 0 /trtr /cfif /cfoutput /table ~| 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:197234 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: I got it! Output grouped query horizontal loop thingamajig.
except that he's grouping his output. that was the original issue. currentrow is no longer sequential :) On Thu, 3 Mar 2005 07:22:59 -0500, Pete Ruckelshaus [EMAIL PROTECTED] wrote: You could use [queryname].currentrow MOD 3 EQ 0 instead of the ctr variable. Slightly more elegant (IMO) and slightly easier. Pete On Thu, 03 Mar 2005 06:28:35 -0400, Will The Game [EMAIL PROTECTED] wrote: Here's my final code that worked in case it may help someone else in the future. Is nothing fancy, but here it is anyway! Thanks Charlie and Ade, Will cfset ctr=0 table width=90% align=left cellpadding=6 tr cfoutput query=getprodsbycategory group=prodmodelcode cfset ctr=ctr + 1 td height=90 bgcolor=##00 div align=centera href=itemdetail.cfm?MODEL=#getprodsbycategory.prodmodelcode#img src=productimages/#getprodsbycategory.imagename# alt=Click for details width=160 height=160 border=0 //a br / a href=itemdetail.cfm?MODEL=#getprodsbycategory.prodmodelcode##getprodsbycategory.prodmodeltitle#/a br / span style=font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; color:##F7F7F7$strong#getprodsbycategory.prodsellprice#/strong/span /div /td cfif ctr MOD 3 EQ 0 /trtr /cfif /cfoutput /table ~| 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:197235 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MSSQL TEXT datatype problem with CF
Did you ever try storing the files in an Image data-type? I'm not sure, but I would guess that would not require the files to be converted to text before storing them. M!ke -Original Message- From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED] Sent: Thursday, March 03, 2005 12:12 AM To: CF-Talk Subject: Re: MSSQL TEXT datatype problem with CF Yeps, you have to enable CLOB retrieval and set a max buffer size to get this to work. Actually, I'm guessing you've might have CLOB turned on already and just not have the buffer set high enough. It's rougly max record size in kBytes. Otherwise it will cut your result off. I had to do it when I was storing PDFs converted from Binary to base64 as long-text strings in a DB table. It worked pretty cool, but only if I had the buffer jacked up to about 1.5MB. Turns out that 30MB of PDF files take up roughly 195MB of space in the DB when encoded and stuffed into a long text field in SQL Server. Then I'd grab the one I wanted and use cfcontent/cfheader to return it as an attachment or inline. Cool test of the technology, but a big consumer of DB space (unless you've got pretty specific needs... a waste.) Laterz, J ~| 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:197236 Archives: http://www.houseoffusion.com/cf_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: Stored Procedures in a CFC
Good question, I believe you will have to enter the two resultset objects into a single CF complex object (such as a Structure) and return that as a single value. That would be my choice. I think a structure makes more sense for that as this code: cfset data = myCFC.getQueries() cfloop query=data.getUsers.../cfloop cfloop query=data.getRoles.../cfloop Is much more legible (and self-documenting) than this code: cfset data = myCFC.getQueries() cfloop query=data[1].../cfloop cfloop query=data[2].../cfloop s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://macromedia.breezecentral.com/p49777853/ http://www.sys-con.com/story/?storyid=44477DE=1 http://www.sys-con.com/story/?storyid=45569DE=1 http://www.fusiontap.com ~| 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:197237 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Stored Procedures in a CFC
I use structures to pass back multiple things from functions, but I'm not so sure you're right about not using an array. An array maps to the cfprocresult's resultset attribute(as it could equally to it's name attrib) but with the array you don't need to know the name used only the number of the resultset. I hope that makes sense, I've just had a not so powerful power nap and I tell ya, it hasn't done anything for my thinking just this minute. Ade -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: 03 March 2005 13:50 To: CF-Talk Subject: RE: Stored Procedures in a CFC Good question, I believe you will have to enter the two resultset objects into a single CF complex object (such as a Structure) and return that as a single value. That would be my choice. I think a structure makes more sense for that as this code: cfset data = myCFC.getQueries() cfloop query=data.getUsers.../cfloop cfloop query=data.getRoles.../cfloop Is much more legible (and self-documenting) than this code: cfset data = myCFC.getQueries() cfloop query=data[1].../cfloop cfloop query=data[2].../cfloop s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://macromedia.breezecentral.com/p49777853/ http://www.sys-con.com/story/?storyid=44477DE=1 http://www.sys-con.com/story/?storyid=45569DE=1 http://www.fusiontap.com ~| 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:197238 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ot: interesting thingy on allaire
On Thursday 03 Mar 2005 00:04 am, dave wrote: crurious how if jeremy will add any cfm perks to this? Yes, but: An error occurred while loading http://www.brightcove.com/: Unknown host www.brightcove.com -- Tom Chiverton Advanced ColdFusion Programmer ~| 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:197239 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfscript functions in CFCs
cfcomponent cfscript function myFunc... return resultVar /cfscript That method nets function myFunc not found. It's been a while since I've played with CFC's, but from what I remember, that should work. Are you calling object.myfunc()? That method gets me a variable myArg is undefined message, curiously enough referencing the cfreturn line of code. It seems the argument passes muster when it enters the function but can't be called in the return call? IIRC, cfscripts always error at the last line of the function, or the first line of the script if it's not a function. But I could be completely off my rocker, because that just doesn't sound right. --Ben ~| 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:197240 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: Dynamic form fields calendars
On Friday 25 Feb 2005 16:02 pm, Damien McKenna wrote: Any ideas what I should look for, or failing that, anyone have a suggestion on something else for me to try? There was speed-up code added to reuse Calender.js instances - one of the setup variables turns this off, try that... -- Tom Chiverton Advanced ColdFusion Programmer ~| 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:197241 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfscript functions in CFCs
Thanks for playing around with this, Jared. In your experiments did you try calling test.getCGI() from within a second cfc as well? (temp.cfm creates test1.cfc; test1.cfc calls test.getCGI() as part of its processing.) If that works for you my difficulty may be a difference between BD and CFMX; my life would be simpler if I could talk my way into a second MX license... -Original Message- From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 02, 2005 10:20 PM To: CF-Talk Subject: Re: cfscript functions in CFCs This also works: test.cfc - cfcomponent cfscript function getCGI(cV) { try { return cgi[cV]; } catch (any cfScriptError) { return cgi; } } /cfscript /cfcomponent temp.cfm cfdump var=#createObject('component','test').getCGI('server_name')# / cfdump var=#createObject('component','test').getCGI('')# / The first one outputs w2ksrv1 which is the server name of my dev box. The second one does a cfdump of the CGI struct. I was messing around with using various if statements to detect cV, and the try/catch worked immediately. structKeyExists always recognized that cV existed, even when it wasn't passed in. len(cV) threw an error because it tried to access a variable that hadn't been set. I haven't worked with function definitions in cfscript enough to be sure exactly the best way to declare a default value for one... but that snippet ran just fine. Laterz, J ~| 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:197242 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfscript functions in CFCs
Well this syntax is invalid -- if your psuedocode is accurate... You can't declare a function within a function. Or that was what I thought You're right - my function-within-a-function code block caused an error on CFMX server. It does seem like a pretty silly idea after having it pointed out... Curiously, no error was thrown (related to the nested function) on the BlueDragon box we use for a few internal apps. And it turns out my real problem was a stinking typo - one that I missed time and time again even while specifically looking for typos. I'll just slink off into my corner... (Thanks for your time, though.) ~| 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:197243 Archives: http://www.houseoffusion.com/cf_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: MSSQL TEXT datatype problem with CF
No, I didn't... but that's a great idea. I was using the long-value columns in SQL Server because the site I was doing needed secured storage for the PDFs (they're fairly private contract documents - high but not mission-critical security needs) but thru the host at the time I didn't have access to any folders outside the webroot. So rather than mess with the ISP, I just stored them in the DB... and it worked great. Access was actually faster than it is on the new ISP's server using cffile action=read even though I was moving 1.5MB of text out of the DB and converting it from base64 data back to binary and then to string data. However, the new ISP only alotted 50MB of data storage in SQL Server and did provide a context on the web server that basically puts the webroot of the site inside my FTP root, so I had to pull the PDFs out of the database and put them in a directory. It's a little easier to work with, but it's not quite as fast. I'm not sure why, but I never looked at a proper BLOB field, just a CLOB field, for storing the PDFs. Maybe I just latched onto the first idea I had. Other than the size of the files in the database, though, it worked amazingly well. Laterz, J On Thu, 3 Mar 2005 07:12:04 -0600, Dawson, Michael [EMAIL PROTECTED] wrote: Did you ever try storing the files in an Image data-type? I'm not sure, but I would guess that would not require the files to be converted to text before storing them. M!ke Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=15114.13525.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54 -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.neo.servequake.com ~| 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:197244 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Stored Procedures in a CFC
I would do it differently (then returning a struct/array with both recordset). Please give comments/suggestions/whatevers as I'm just thinking out loud. In essence, your SP returns two recordsets which don't hold the same data, they could be related but they are not the same. Why not create two methods for your CFC each returning one of these recordsets. They would both use another private method which would run the SP and then store its results in private variables. It would also ensure that the SP isn't run again and again if it's been run recently. Two me that's better encapsulation. The Application doesn't have to know how the CFC gets the recordsets all it knows is that by calling either of the methods it will get back the data it needs. -- Marc ~| 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:197245 Archives: http://www.houseoffusion.com/cf_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: MSSQL TEXT datatype problem with CF
You are going to use more physical disk space storing the PDF's in the DB than if you store them as physically files on the drive. -Original Message- From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED] Sent: 03 March 2005 15:24 To: CF-Talk Subject: Re: MSSQL TEXT datatype problem with CF No, I didn't... but that's a great idea. I was using the long-value columns in SQL Server because the site I was doing needed secured storage for the PDFs (they're fairly private contract documents - high but not mission-critical security needs) but thru the host at the time I didn't have access to any folders outside the webroot. So rather than mess with the ISP, I just stored them in the DB... and it worked great. Access was actually faster than it is on the new ISP's server using cffile action=read even though I was moving 1.5MB of text out of the DB and converting it from base64 data back to binary and then to string data. However, the new ISP only alotted 50MB of data storage in SQL Server and did provide a context on the web server that basically puts the webroot of the site inside my FTP root, so I had to pull the PDFs out of the database and put them in a directory. It's a little easier to work with, but it's not quite as fast. I'm not sure why, but I never looked at a proper BLOB field, just a CLOB field, for storing the PDFs. Maybe I just latched onto the first idea I had. Other than the size of the files in the database, though, it worked amazingly well. Laterz, J On Thu, 3 Mar 2005 07:12:04 -0600, Dawson, Michael [EMAIL PROTECTED] wrote: Did you ever try storing the files in an Image data-type? I'm not sure, but I would guess that would not require the files to be converted to text before storing them. M!ke Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=15114.13525.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54 -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.neo.servequake.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197246 Archives: http://www.houseoffusion.com/cf_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: Securing MS-SQL port 1433
On Wed, 2 Mar 2005 09:32:10 -, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: My point is that if you are running 818 you are NOT fully patched. Not disputing that at all. And even having MS-SQL fully patched on a Windows box that is missing OS patches doesn't necessarily make you safe either, considering the other known vulnerabilities in a base Windows install. But as you probably know from reading the security bulletins, the overwhelming majority of the vulnerabilities MS issues patches for can be mitigated by controlling and limiting either remote access (e.g. blocking external access to services) or securing physical access -- not fixed for sure, but mitigated. And that certainly gives you time to assess the effect of the patch/update on your systems in a calm and controlled way. My original point wasn't that you have to be fully patched to be safe -- it was that leaving the door wide open to a known and widely publicized problem was foolish and stupid, which would make such a person an idiot. -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| 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:197247 Archives: http://www.houseoffusion.com/cf_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: Securing MS-SQL port 1433
-- My original point wasn't that you have to be fully patched to be safe I agree with that for sure. -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] Sent: 03 March 2005 15:28 To: CF-Talk Subject: Re: Securing MS-SQL port 1433 On Wed, 2 Mar 2005 09:32:10 -, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: My point is that if you are running 818 you are NOT fully patched. Not disputing that at all. And even having MS-SQL fully patched on a Windows box that is missing OS patches doesn't necessarily make you safe either, considering the other known vulnerabilities in a base Windows install. But as you probably know from reading the security bulletins, the overwhelming majority of the vulnerabilities MS issues patches for can be mitigated by controlling and limiting either remote access (e.g. blocking external access to services) or securing physical access -- not fixed for sure, but mitigated. And that certainly gives you time to assess the effect of the patch/update on your systems in a calm and controlled way. My original point wasn't that you have to be fully patched to be safe -- it was that leaving the door wide open to a known and widely publicized problem was foolish and stupid, which would make such a person an idiot. -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| 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:197248 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Stored Procedures in a CFC
Well, If the method called can call one proc and is returning two record sets which are required - sure they are not calling the same data sets but they may be required - and one hit to the DB is better than separate calls - if there is certainly good reason and better performance over your idea I would be happy to try it out! Also the SP would probably not get called again and again internally for as long as the Query/Query plan is cached on SQL Server. -Original Message- From: Marc Campeau [mailto:[EMAIL PROTECTED] Sent: 03 March 2005 15:24 To: CF-Talk Subject: Re: Stored Procedures in a CFC I would do it differently (then returning a struct/array with both recordset). Please give comments/suggestions/whatevers as I'm just thinking out loud. In essence, your SP returns two recordsets which don't hold the same data, they could be related but they are not the same. Why not create two methods for your CFC each returning one of these recordsets. They would both use another private method which would run the SP and then store its results in private variables. It would also ensure that the SP isn't run again and again if it's been run recently. Two me that's better encapsulation. The Application doesn't have to know how the CFC gets the recordsets all it knows is that by calling either of the methods it will get back the data it needs. -- Marc ~| 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:197249 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Web Based Spreadsheet To MSSQL Mapping
On Friday 25 Feb 2005 15:21 pm, Bryan F. Hogan wrote: send it to me. Against all of my recommendations to have us write an import function they don't want to spend the money. So, fine. Let them do it that way. When it breaks, explain why. -- Tom Chiverton Advanced ColdFusion Programmer ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197250 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: Migration from Sybase ASE 12.5.1 to SQl Server
Isn't it annoying how you can search for an answer for days, then post a request to the list, then find the answer no more than an hour after requesting assitance? Invariably, I find this to be true. Maybe we should call it the Natural Law of Abundant Answers. It means that there are always answers available to any given question, and those question/answer pairs are stateful, can exist in any venue, and have a 1-n relationship (Q1-An). However, those answers only become available once the context of the question question matches the context of the answer (Qc=Ac), because to pair up they must exist within the same context... So if you don't know the answer, busting your tail to find it is a waste of time because until the context of the question matches the context of the answer they will not connect. So once you've publicized the question, the answers are immediately availble, even if they aren't delivered via the same conduit by which the question was asked, simply because by asking, the Qc has been matched to Ac, and therefore your new asking methods are able to locate A. Then again, I'm a geek, and I tend to think like a geek. ;) Laterz, J On Mon, 28 Feb 2005 09:46:15 -0500, George Abraham [EMAIL PROTECTED] wrote: Whoops, Let me answer my own question with this URL: http://www.ispirer.com/doc/sqlways38/Output/SQLWays-1-317.html George On Mon, 28 Feb 2005 09:22:48 -0500, George Abraham [EMAIL PROTECTED] wrote: All, We are trying to migrate a database from Sybase ASE 12.5.1 to SQL Server 2000. We are having problems with the ODBC driver that Sybase has provided to complete the migration using the SQL Server DTS utility. There appears to be no place to specify the port number for the Sybase installation. Obviously I am doing something wrong, but has anybody else run into this? TIA, George http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=15114.13525.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54 -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.neo.servequake.com ~| 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:197251 Archives: http://www.houseoffusion.com/cf_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: RDS and file browsing
On Friday 25 Feb 2005 17:47 pm, Douglas Knudsen wrote: dir only, user Henry Rollins has access to everything, etc... Use WebDAV :-) -- Tom Chiverton Advanced ColdFusion Programmer ~| 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:197252 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Securing MS-SQL port 1433
On Tue, 1 Mar 2005 22:06:48 -0500, Dave Watts [EMAIL PROTECTED] wrote: If someone's installing Visio Enterprise to work on flowcharts at home, they probably got it from work. Licensing issues aside (since we'll assume they're good there) then their home box gets hosed. PITA, but not much impact on the business. My point has nothing to do with impact on the business. You stated that anyone running an unprotected SQL Server was an idiot. I took issue with that, and provided a counterexample. It's as simple as that. And I'm still not convinced by your counterexample. While MSDE is certainly fundamentally SQL Server (and now officially named that in the 2005 product editions) the original point was that leaving your SQL Server wide open for TCP/IP access was an idiotic thing to do. And on a ColdFusion list, clearly from context we're talking about the SQL Server(s) interacting with the ColdFusion server(s). (I will make that clear next time ;) I think the main value of the MSDE counterexample is as a reminder that you need to secure your SQL Server against both external threats (e.g. locking down TCP/IP access) and *internal* threats that avoid or circumvent the externally-facing security measures. If Joe Homeuser picks up Slammer on his Visio-installed MSDE, that sucks for him -- but if Jane Sysadmin hasn't protected the internal systems from such a scenario then she's probably on the way to clean our her desk. How is this any different than the corporate education about opening attachments (bad) and phishing (bad)? Most people, I'd put forth, *do* know that the internet isn't all that safe and they should be running a firewall. WinXP SP2 finally has it builtin, for gosh sakes. While most people may know that they should be running a firewall, I doubt very much that most of these people even know what a firewall is. And when their system pops up a little message saying do you want to allow traffic from [socket 1] to [socket 2], they'll click the OK button in many cases even if they don't know the import of their actions. And again, your analogy with corporate education about attachments just highlights the idiocy of our industry - we find it more efficient to train untold thousands of people not to double-click something, rather than design a safe system in the first place! If we built cars, we'd tell people don't drive downhill because the brakes don't work, rather than just fixing the damn brakes. How idiotic is that? I think we both agree that it's idiotic as an industry that we have to deal with anti-virus software, spam filters, spyware, worms, phishing, and the like. It's hard to claim otherwise! But we've got the systems we've got -- if your car *doesn't* have brakes and you say to yourself Well, it should have breaks so I'm going to go down this hill anyway. It will be the engineers' fault! you are pretty foolish. If you however attach a parachute to the back of the car to slow you (or do a Fred Flinstone with your feet to stop) you've at least hedged your bets. Actually, I think the answer to your question is yes, you did have something happen to you that was completely avoidable and probably deserve it. You chose to keep your door open when they're a high likelihood of attack (we're comparing to the security of the internet, remember). You have a peculiar way of defining deserved. To think that's the result has been earned by your actions? That you merited the attack? (a few definitions just to make sure I'm using the word in a normal fashion...). I think the cracker, script kiddie, or disgruntled employee who now has access to your data would certainly think you deserved it. -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| 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:197253 Archives: http://www.houseoffusion.com/cf_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: Web Based Spreadsheet To MSSQL Mapping
No not fine. I don't care if they want it or not, I want it to make my job easier. These are people that if they see something that will understand how it will make their jobs easier. That's why I posted looking for something that someone may have already done. I can't believe that this has not been done before and that no one on this list hasn't seen one before. Thanks for your reply -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Thursday, March 03, 2005 10:36 AM To: CF-Talk Subject: Re: Web Based Spreadsheet To MSSQL Mapping On Friday 25 Feb 2005 15:21 pm, Bryan F. Hogan wrote: send it to me. Against all of my recommendations to have us write an import function they don't want to spend the money. So, fine. Let them do it that way. When it breaks, explain why. -- Tom Chiverton Advanced ColdFusion Programmer ~| 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:197254 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: So what chair are you sitting in with your dual monitors?
The thread about dual (or 3+) monitors has been a lot of fun to read, but I'm wondering what kind of chair people are sitting in as they survey their 3200-wide pixel domain -- Areon? Mirra? Folding chair? -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| 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:197255 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Stored Procedures in a CFC
I'm not sure about others, but I was talking about the call to the function that contains the two resultset SP. No matter how many layers you put between the SP call at some point you need to call a function that will run that SP. The cfstoredproc tag will return both queries regardless, you could construct the function to return one of the callers choosing, but from a simplistic approach returning both in either an array or a structure seems more useful. The point I was making was that you either reference them as: function()[1] and function()[2] or: function().resultsetOne and function().resultsetTwo one, the structure, exposes more about the function than the other, the array. I understand what you're suggesting in your post, something like: component getData SP resultset1 resultset2 /SP return resultset /getData getFirst return getData().resultset1 (or return getData()[1]) /getFirst getSecond return getData().resultset2 (or return getData()[2]) /getSecond /component But within getFirst() and getSecond() you still need to decide how you call getData and access the two resultsets, struct or array fashion. Not that it's hugely important! :O) Ade -Original Message- From: Marc Campeau [mailto:[EMAIL PROTECTED] Sent: 03 March 2005 15:24 To: CF-Talk Subject: Re: Stored Procedures in a CFC I would do it differently (then returning a struct/array with both recordset). Please give comments/suggestions/whatevers as I'm just thinking out loud. In essence, your SP returns two recordsets which don't hold the same data, they could be related but they are not the same. Why not create two methods for your CFC each returning one of these recordsets. They would both use another private method which would run the SP and then store its results in private variables. It would also ensure that the SP isn't run again and again if it's been run recently. Two me that's better encapsulation. The Application doesn't have to know how the CFC gets the recordsets all it knows is that by calling either of the methods it will get back the data it needs. -- Marc ~| 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:197256 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfscript functions in CFCs
Hey Paul... Here's the latest test. :) Note that in test.cfc, I've got both CFINVOKE and createObject() styles of accessing the second CFC... they both work just fine. I used one, then remarked it out and used the other too and figured I'd leave them both in as examples. temp.cfm - cfdump var=#createObject('component','test').getCGIVar('server_name')# / cfdump var=#createObject('component','test').getCGIVar('')# / test.cfc - cfcomponent cffunction name=getCGIVar cfargument name=cgVar type=string default= !--- cfset var cVLocal = cfinvoke component=test2 method=getCGI cV=#arguments['cgVar']# returnvariable=cVlocal cfreturn cVlocal / --- cfreturn createObject(component,test2).getCGI(arguments[cgVar])/ /cffunction /cfcomponent test2.cfc - cfcomponent cfscript function getCGI(cV) { var cVlocal = ''; if (len(cV)) { cVlocal = cgi[cV]; } else { cVlocal = cgi; } return cVlocal; } /cfscript /cfcomponent I think it's worth noting that since test.cfc is calling test2.getCGI(arguments[cgVar]) and cgVar is being created in the cfarguments of test.getCGIVar() with a default value of , I was able to dispense with the try/catch and use an if... sort of speaks to Facade patterns, doesn't it? My need to always supply an empty argument is hidden by my public API. Kinda neat. This was a fun, if simple, excercise... thanks Paul! Laterz, J On Thu, 3 Mar 2005 08:19:29 -0700, Paul [EMAIL PROTECTED] wrote: Thanks for playing around with this, Jared. In your experiments did you try calling test.getCGI() from within a second cfc as well? (temp.cfm creates test1.cfc; test1.cfc calls test.getCGI() as part of its processing.) If that works for you my difficulty may be a difference between BD and CFMX; my life would be simpler if I could talk my way into a second MX license... -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.neo.servequake.com ~| 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:197257 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: So what chair are you sitting in with your dual monitors?
At work, crappy 30 dollar office depot special. The up/down air cylinder is broken and the screw to hold the back upright doesn't hold. At home I've got an Aeron chair (used, part of a complete Herman Miller cube system I resold), but I don't use it for coding anymore. My computer desk is a low Japanese-style table (42 square, 15 high, oak and copper) that I sit indian style or kneel at. I also use an overstuffed leather chair and a laptop for general surfing. Jerry Johnson Web Developer Dolan Media Company [EMAIL PROTECTED] 03/03/05 10:48AM The thread about dual (or 3+) monitors has been a lot of fun to read, but I'm wondering what kind of chair people are sitting in as they survey their 3200-wide pixel domain -- Areon? Mirra? Folding chair? ~| 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:197258 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: So what chair are you sitting in with your dual monitors?
Currently I have a low ikea coffee (side) table and a big ole beanbag (looks like leather but it aint) NOT the most comfortable coding position known to man. Oh.. thats at home, at work they treat me a bit better... MD On Thu, 03 Mar 2005 10:53:11 -0500, Jerry Johnson [EMAIL PROTECTED] wrote: At work, crappy 30 dollar office depot special. The up/down air cylinder is broken and the screw to hold the back upright doesn't hold. At home I've got an Aeron chair (used, part of a complete Herman Miller cube system I resold), but I don't use it for coding anymore. My computer desk is a low Japanese-style table (42 square, 15 high, oak and copper) that I sit indian style or kneel at. I also use an overstuffed leather chair and a laptop for general surfing. Jerry Johnson Web Developer Dolan Media Company [EMAIL PROTECTED] 03/03/05 10:48AM The thread about dual (or 3+) monitors has been a lot of fun to read, but I'm wondering what kind of chair people are sitting in as they survey their 3200-wide pixel domain -- Areon? Mirra? Folding chair? ~| 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:197259 Archives: http://www.houseoffusion.com/cf_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: MSSQL TEXT datatype problem with CF
Indeed... I could tell. I ran an export of the DB into a local replica sans the PDF column... the data file went from 198MB to 4MB. Twas a telling test. But still... there are situations where eating up disk space with a DB data file isn't a waste so much as a cost. The point was mostly just that a) it could be done and works nicely and b) the perceived performance of reading 1.5MB of text out of a database and converting it back to the right format was FASTER (by quite a bit, actually) than using CFFILE and a folder outside the web root. I say perceived performance because I didn't actually do any performance testing... I refer to user experience. The DB-driven solution returned activity to the user's screen faster by a second or two than the CFFILE version doing basically the same thing. That, considering that cffile is reading from the local hard disk and the DB solution was over-the-wire to a busy SQL Server, is actually quite the fascinating factlet. Laterz, J On Thu, 3 Mar 2005 15:22:46 -, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: You are going to use more physical disk space storing the PDF's in the DB than if you store them as physically files on the drive. -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.neo.servequake.com ~| 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:197260 Archives: http://www.houseoffusion.com/cf_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: Web Based Spreadsheet To MSSQL Mapping
Against all of my recommendations to have us write an import function they don't want to spend the money. Well, if they don't want to spend the money, why care for them anyway? ;-) Do I understand well that if spreadsheets come from their client, they can have about anything in it, in any format? Or do they always have the same type of data in the same columns? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:197261 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: access w username and password..
That doesn't really matter. So long as you're using the right username/password combination, it'll work fine even if you have access credentials in both places. Sometimes it's a matter of going into CFADMIN, getting it all set up so it works, then stripping the creds out of CFADMIN and using them in your datasource. I usually use the DSN to hold the credentials, though, just because I'm too lazy to add them to every... single... query... But, there's no rule... do it how is most comfortable and makes the most sense. Laterz, J On Mon, 28 Feb 2005 19:03:44 -0400, Larry White [EMAIL PROTECTED] wrote: If you're setting the username and password in CF Admin, then why are you doing it in cfquery? The datasource should use the one set up in CF Admin. -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.neo.servequake.com ~| 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:197262 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: So what chair are you sitting in with your dual monitors?
From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] The thread about dual (or 3+) monitors has been a lot of fun to read, but I'm wondering what kind of chair people are sitting in as they survey their 3200-wide pixel domain -- Areon? Mirra? Folding chair? Fun, yes. On-topic, No. Herman Miller Aeron here... best purchase ever :-) ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197263 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Securing MS-SQL port 1433
Lee: Hi my name is Lee and I'm and idiot. Half the list: Hi Lee! Lee: I installed my first Windows box in 1998. Half the list: (Sympathetic Hush) Lee: Yeah and ever since then my life has been out of control. I really need Windows but the problems it's caused... Half the list: Nodding approval... ~| 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:197264 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: So what chair are you sitting in with your dual monitors?
Dual montiors, one, a 19 dell flatscreen, one a 19 viewsonic crt. I've found I can't tell color differences in most text colors on the lcd (except at extreme angles or with bright colors), which is why i put all my CFEclipse utility panels on there and the coding window on the crt. My chair is a crappy hunch-inducing half-high-back generic office chair with scratchy plastic armrests. It slowly sinks downwards and I have to bring it back up once or twice a week. They'll splurge for more ram, more monitors, more software, but no Aeron yet :( -nathan strutz http://www.dopefly.com/ ~| 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:197265 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Web Based Spreadsheet To MSSQL Mapping
Ok, let me reiterate. I care for them because I know if they can see an example, they will foot the integration bill. These are clients that I have that we have been working with for the last 5 years. I care for them because they sustain our business and even if they were one of our smaller customers I feel that caring about your customers is often times more beneficial that monetary returns. They can come in any format. That's why I'm looking for something where they can upload/open the spreadsheet and map the spreadsheet columns to the MSSQL columns that I supply. Something that I can write rules against. If you haven't seen one that's ok. But I don't want to speak about the reason I want to do this. It is an ethical thing that I like to do for my customers. Thanks for your reply. -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Thursday, March 03, 2005 11:11 AM To: CF-Talk Subject: Re: Web Based Spreadsheet To MSSQL Mapping Against all of my recommendations to have us write an import function they don't want to spend the money. Well, if they don't want to spend the money, why care for them anyway? ;-) Do I understand well that if spreadsheets come from their client, they can have about anything in it, in any format? Or do they always have the same type of data in the same columns? ~| 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:197266 Archives: http://www.houseoffusion.com/cf_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: Web Based Spreadsheet To MSSQL Mapping
Can you force a spreadsheet format on them? If so, you can generate a spreadsheet with locked cells where they can only enter information in cells you have specified. That would make it much easier for you handle the data. Of course, if the sheets contain varying amounts of data, it might not work as well. M!ke -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Thursday, March 03, 2005 10:24 AM To: CF-Talk Subject: RE: Web Based Spreadsheet To MSSQL Mapping Ok, let me reiterate. I care for them because I know if they can see an example, they will foot the integration bill. These are clients that I have that we have been working with for the last 5 years. I care for them because they sustain our business and even if they were one of our smaller customers I feel that caring about your customers is often times more beneficial that monetary returns. They can come in any format. That's why I'm looking for something where they can upload/open the spreadsheet and map the spreadsheet columns to the MSSQL columns that I supply. Something that I can write rules against. If you haven't seen one that's ok. But I don't want to speak about the reason I want to do this. It is an ethical thing that I like to do for my customers. Thanks for your reply. ~| 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:197267 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cfform not working correctly
everything has been working on the developers workstation (windows xp/standalone/cfmx7) but when deployed to server (solaris/j2ee(jrun)/cmx7) the forms will not display correctly on the clients. The bizarre thing is that it displays differently depending on the client you are using. There is only one client OSX safari that actually displays the flash form correctly. All other clients show varying different levels of functionality.with some not even showing the form at all. what could be going wrong? to me it seems that if one client can recieve the correct form they all should. toru ~| 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:197268 Archives: http://www.houseoffusion.com/cf_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: Web Based Spreadsheet To MSSQL Mapping
If you haven't seen one that's ok. But I don't want to speak about the reason I want to do this. I was just joking ;-) The reason I asked is because I have a site in which spreadsheets are imported, but the columns always match, so it won't help. I don't know about any matching tool however. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:197269 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: So what chair are you sitting in with your dual monitors?
Speaking of tables - I used to have a nice desk. When I moved, the desk broke, so I borrowed a simple table that you would typically use at Thanksgiving for the kids. I love it. I feel like I have acres of real estate. I never used the drawers of my old desk anyway so it's perfect. On Thu, 03 Mar 2005 10:53:11 -0500, Jerry Johnson [EMAIL PROTECTED] wrote: At work, crappy 30 dollar office depot special. The up/down air cylinder is broken and the screw to hold the back upright doesn't hold. At home I've got an Aeron chair (used, part of a complete Herman Miller cube system I resold), but I don't use it for coding anymore. My computer desk is a low Japanese-style table (42 square, 15 high, oak and copper) that I sit indian style or kneel at. I also use an overstuffed leather chair and a laptop for general surfing. Jerry Johnson Web Developer Dolan Media Company [EMAIL PROTECTED] 03/03/05 10:48AM The thread about dual (or 3+) monitors has been a lot of fun to read, but I'm wondering what kind of chair people are sitting in as they survey their 3200-wide pixel domain -- Areon? Mirra? Folding chair? ~| 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:197270 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Web Based Spreadsheet To MSSQL Mapping
A matching tool as described would be an easy sell to a lot of people. Though probably would be a nightmare to try and make which might be why I have never stumbled upon a canned solution for it. :) On Thu, 03 Mar 2005 11:38:18 -0500, Claude Schneegans [EMAIL PROTECTED] wrote: If you haven't seen one that's ok. But I don't want to speak about the reason I want to do this. I was just joking ;-) The reason I asked is because I have a site in which spreadsheets are imported, but the columns always match, so it won't help. I don't know about any matching tool however. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:197271 Archives: http://www.houseoffusion.com/cf_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
(OO) UI in CFCs
I'm starting this topic to get peoples feelings on the subject. Do you use CFCs for UI? Do you have a good reason to do so? Do you see a reason to use it (or not) vs. CFINCLUDEs or CFMODULEs? According to commonly discussed practices in the community (and in part of the Macromedia docs), UI elements should not go inside of CFCs. According to the Macromedia CFC examples, UI can go inside CFCs. According to the makeup of the CFCOMPONENT and CFFUNCTION tags, the ability exists explicitly (the output attribute). According to many of the OO books I've been reading, there's no reason for UI not to be within an object. ~| 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:197272 Archives: http://www.houseoffusion.com/cf_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: MSSQL TEXT datatype problem with CF
The problem is simply the size and cost of the indexes etc they all add up to unnecessary usage. -Original Message- From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED] Sent: 03 March 2005 16:06 To: CF-Talk Subject: Re: MSSQL TEXT datatype problem with CF Indeed... I could tell. I ran an export of the DB into a local replica sans the PDF column... the data file went from 198MB to 4MB. Twas a telling test. But still... there are situations where eating up disk space with a DB data file isn't a waste so much as a cost. The point was mostly just that a) it could be done and works nicely and b) the perceived performance of reading 1.5MB of text out of a database and converting it back to the right format was FASTER (by quite a bit, actually) than using CFFILE and a folder outside the web root. I say perceived performance because I didn't actually do any performance testing... I refer to user experience. The DB-driven solution returned activity to the user's screen faster by a second or two than the CFFILE version doing basically the same thing. That, considering that cffile is reading from the local hard disk and the DB solution was over-the-wire to a busy SQL Server, is actually quite the fascinating factlet. Laterz, J On Thu, 3 Mar 2005 15:22:46 -, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: You are going to use more physical disk space storing the PDF's in the DB than if you store them as physically files on the drive. -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.neo.servequake.com ~| 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:197273 Archives: http://www.houseoffusion.com/cf_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: Securing MS-SQL port 1433
Eh? -Original Message- From: Lee [mailto:[EMAIL PROTECTED] Sent: 03 March 2005 16:15 To: CF-Talk Subject: Re: Securing MS-SQL port 1433 Lee: Hi my name is Lee and I'm and idiot. Half the list: Hi Lee! Lee: I installed my first Windows box in 1998. Half the list: (Sympathetic Hush) Lee: Yeah and ever since then my life has been out of control. I really need Windows but the problems it's caused... Half the list: Nodding approval... ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197274 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Web Based Spreadsheet To MSSQL Mapping
Ah, and that's why I don't want to write it myself. I was thinking something along the lines of a mail merge. -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Thursday, March 03, 2005 11:42 AM To: CF-Talk Subject: Re: Web Based Spreadsheet To MSSQL Mapping A matching tool as described would be an easy sell to a lot of people. Though probably would be a nightmare to try and make which might be why I have never stumbled upon a canned solution for it. :) ~| 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:197275 Archives: http://www.houseoffusion.com/cf_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: (OO) UI in CFCs
It's a big no noone of the points of using CFCs is to seperate business logic from the presentation layer I know it's possiblebut it's also possible to put page header display code in Application.cfmbut we don't do it ;-) Ultimately it's up to the developer ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com.cfm/54 ~| 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:197276 Archives: http://www.houseoffusion.com/cf_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: Web Based Spreadsheet To MSSQL Mapping
A matching tool as described would be an easy sell to a lot of people. Ah ah! A great idea for a new tag? ;-) Though probably would be a nightmare to try Not really, using CFX_ODBCInfo would make it pretty easy. I'm about to release a super new application: The ODBCMyAdmin, version 1.0 and I may consider adding this feature in future version. Version 1.0 already imports tables, ie. copies tables, but here we more talking of import'n translate. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:197277 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: (OO) UI in CFCs
I don't think he means use UI and business together, but rather CFCs for the presentation. Mike? Ade -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: 03 March 2005 16:52 To: CF-Talk Subject: Re: (OO) UI in CFCs It's a big no noone of the points of using CFCs is to seperate business logic from the presentation layer I know it's possiblebut it's also possible to put page header display code in Application.cfmbut we don't do it ;-) Ultimately it's up to the developer ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com.cfm/54 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197278 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfscript functions in CFCs
This was a fun, if simple, excercise... thanks Paul! For as often as I'm confused, it's nice that at least my questions at least occasionally lead to something positive for someone out there! Thanks for looking into it, as well. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197279 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Stored Procedures in a CFC
The cfstoredproc tag will return both queries regardless, you could construct the function to return one of the callers choosing, but from a simplistic approach returning both in either an array or a structure seems more useful. The point I was making was that you either reference them as: function()[1] and function()[2] or: function().resultsetOne and function().resultsetTwo one, the structure, exposes more about the function than the other, the array. I understand but I feel like they both expose too much to the application. ;) I usually prefer structs becauses they're more literate but by hiding the resultsets in the CFC it doesn't matter whether you use an array, struct or whatever. I would do this: component private datasets = structNew(); private isLoaded = false; private function loadData() if not isLoaded sp result1 result2 /sp datasets.result1 = result1; datasets.result2 = result2; isLoaded = true; /if return; /function private function getResult1() loadData(); return datasets.result1; /function private function getResult2() loadData(); return datasets.result2; /function /component -- Marc ~| 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:197280 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: (OO) UI in CFCs
This is one of those topics where I see people making CFC's into something they aren't. Yeah, CFC's can be used to separate BL from UI blah blah blah. But that doesn't preclude the use for other things. I see so many emails floating around about OO design and how this rule keeps you from doing this or that or that you must follow this way of doing things. The plain fact is that CF is still procedural by nature with some OO abilities. I say use CFC's for whatever you want to use them for. You might just stumble on a really neat implementation. I'm currently in the middle of OOP Demystified. Excellent book so far. The author gives real world examples of creating objects. Then he also gives situations where it might not be the best course of action to use OO, but to do it procedurally. That was surprising from an OO book. He said that OO programmers will model objects after reality and sometimes, to keep to the hard and fast rules of OO design, they would 'bend' reality to fit the OO model. If you get a chance, check out the book. It starts out like all the other OO books I've read, but then after the definition chapters, he'll actually start using real world designs to illustrate his points. Marlon On Thu, 3 Mar 2005 11:43:09 -0500, Michael Dinowitz [EMAIL PROTECTED] wrote: I'm starting this topic to get peoples feelings on the subject. Do you use CFCs for UI? Do you have a good reason to do so? Do you see a reason to use it (or not) vs. CFINCLUDEs or CFMODULEs? According to commonly discussed practices in the community (and in part of the Macromedia docs), UI elements should not go inside of CFCs. According to the Macromedia CFC examples, UI can go inside CFCs. According to the makeup of the CFCOMPONENT and CFFUNCTION tags, the ability exists explicitly (the output attribute). According to many of the OO books I've been reading, there's no reason for UI not to be within an object. ~| 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:197281 Archives: http://www.houseoffusion.com/cf_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: (OO) UI in CFCs
Personally, I don't see a reason not to have a separate CFC just for UI elements that go on a page. Basically, you have a page which calls a BL (business logic) CFC for logic and a UI (user interface) CFC for specific UI elements that go on the page with the business logic. Take an average blog for example. Most have a calendar on the side. Why is this not inside a blogui.cfc file with other specific UI elements that are re-used. Yes, a custom tag can be built for each of the UI elements but on an average blog, there are 4 or 5 different small side elements. A single location for all of them would make sense rather than 4 or 5 different modules. At the moment I'm not using CFCs for UI but for UI elements less than 10 lines long, it's looking good. I don't think he means use UI and business together, but rather CFCs for the presentation. Mike? Ade -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: 03 March 2005 16:52 To: CF-Talk Subject: Re: (OO) UI in CFCs It's a big no noone of the points of using CFCs is to seperate business logic from the presentation layer I know it's possiblebut it's also possible to put page header display code in Application.cfmbut we don't do it ;-) Ultimately it's up to the developer ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com.cfm/54 ~| 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:197282 Archives: http://www.houseoffusion.com/cf_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: Web Based Spreadsheet To MSSQL Mapping
To me the mapping itself would not be the nightmare. It would be the reading in the Excel file and grabbing the data correctly. Dealing with any pretty formating it might have, dealing with multiple worksheets and so on. I actually have the need for something kind of like this and will be tackling it some hopefully this month. My need we at least have a great deal of control over how the spreadsheet will always be laid out so not going to be mapping issues. On Thu, 03 Mar 2005 11:54:02 -0500, Claude Schneegans [EMAIL PROTECTED] wrote: A matching tool as described would be an easy sell to a lot of people. Ah ah! A great idea for a new tag? ;-) Though probably would be a nightmare to try Not really, using CFX_ODBCInfo would make it pretty easy. I'm about to release a super new application: The ODBCMyAdmin, version 1.0 and I may consider adding this feature in future version. Version 1.0 already imports tables, ie. copies tables, but here we more talking of import'n translate. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197283 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Stored Procedures in a CFC
Right, but in your getResult1() and getResult2() you access the key named in loadData(). That's what I'm saying(asking whether it's) bad. Would array syntax not hide better what loadData() does? -Original Message- From: Marc Campeau [mailto:[EMAIL PROTECTED] Sent: 03 March 2005 17:04 To: CF-Talk Subject: Re: Stored Procedures in a CFC The cfstoredproc tag will return both queries regardless, you could construct the function to return one of the callers choosing, but from a simplistic approach returning both in either an array or a structure seems more useful. The point I was making was that you either reference them as: function()[1] and function()[2] or: function().resultsetOne and function().resultsetTwo one, the structure, exposes more about the function than the other, the array. I understand but I feel like they both expose too much to the application. ;) I usually prefer structs becauses they're more literate but by hiding the resultsets in the CFC it doesn't matter whether you use an array, struct or whatever. I would do this: component private datasets = structNew(); private isLoaded = false; private function loadData() if not isLoaded sp result1 result2 /sp datasets.result1 = result1; datasets.result2 = result2; isLoaded = true; /if return; /function private function getResult1() loadData(); return datasets.result1; /function private function getResult2() loadData(); return datasets.result2; /function /component -- Marc -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 266.6.0 - Release Date: 02/03/2005 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197284 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: short term contractor required
Hi all, Sorry if this is an inappropriate post, however I'm looking for someone to write up a Coldfusion XML-RPC implementation for me as its just beyond my skill levels. Basics of the project is to use XML-RPC to check our db for new events, then push them to the client. The environment is CFMX 6.1 on Debian and apache 2.0.49 MySQL 4.1 db If you're interested please email me offlist on [EMAIL PROTECTED] and we can discuss terms. Thanks, Dave ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197285 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: (OO) UI in CFCs
Thus far I have only seen one example where someone was using a CFC for the UI. I never got to see the actual code but his explanation made it sound like a good chunk of the business logic was in other CFCs and then he had a set of CFCs for the UI portion. Without really seeing the code, I always had a hard time seeing how this approach was any better or worse than just have a custom tag for that portion of his UI. That example though was not just one CFC to display the information, it used 3 or 4 I think to build it all up.What he was displaying was exactly what we do here but with custom tags and we probably use the same amount of tags as he was using CFCs. On Thu, 3 Mar 2005 12:09:57 -0500, Michael Dinowitz [EMAIL PROTECTED] wrote: Personally, I don't see a reason not to have a separate CFC just for UI elements that go on a page. Basically, you have a page which calls a BL (business logic) CFC for logic and a UI (user interface) CFC for specific UI elements that go on the page with the business logic. Take an average blog for example. Most have a calendar on the side. Why is this not inside a blogui.cfc file with other specific UI elements that are re-used. Yes, a custom tag can be built for each of the UI elements but on an average blog, there are 4 or 5 different small side elements. A single location for all of them would make sense rather than 4 or 5 different modules. At the moment I'm not using CFCs for UI but for UI elements less than 10 lines long, it's looking good. ~| 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:197286 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: (OO) UI in CFCs
[EMAIL PROTECTED] wrote: Personally, I don't see a reason not to have a separate CFC just for UI elements that go on a page. we have talked about his many times in our shop. the main advantage that we have come up with is giving UI an interface of sorts. It would allow you to define what is required for the UI element. This helps a lot when you are editing a display and need to know what variables are available to you. toru ~| 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:197287 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: (OO) UI in CFCs
Someone I work with uses CFCs for UI. For instance, something he did is make a CFC that runs a query and returns a recordset. He then passes the recordset to a UI CFC and it formats the results in a datagrid fashion. I believe the default action is to take the column names and make them table headers with a specific look and sorting functionality and then display the data in cells below the header. There's also functionality to map a display name to a column and also to limit which columns are displayed. This is used on a reporting site that uses these datagrid displays all over. So now, he can control the UI on the majority of the site within 1 simple CFC. I haven't used it yet or looked into it at great length, but in theory it sounds like a pretty good idea. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Thursday, March 03, 2005 12:21 PM To: CF-Talk Subject: Re: (OO) UI in CFCs Thus far I have only seen one example where someone was using a CFC for the UI. I never got to see the actual code but his explanation made it sound like a good chunk of the business logic was in other CFCs and then he had a set of CFCs for the UI portion. Without really seeing the code, I always had a hard time seeing how this approach was any better or worse than just have a custom tag for that portion of his UI. That example though was not just one CFC to display the information, it used 3 or 4 I think to build it all up.What he was displaying was exactly what we do here but with custom tags and we probably use the same amount of tags as he was using CFCs. On Thu, 3 Mar 2005 12:09:57 -0500, Michael Dinowitz [EMAIL PROTECTED] wrote: Personally, I don't see a reason not to have a separate CFC just for UI elements that go on a page. Basically, you have a page which calls a BL (business logic) CFC for logic and a UI (user interface) CFC for specific UI elements that go on the page with the business logic. Take an average blog for example. Most have a calendar on the side. Why is this not inside a blogui.cfc file with other specific UI elements that are re-used. Yes, a custom tag can be built for each of the UI elements but on an average blog, there are 4 or 5 different small side elements. A single location for all of them would make sense rather than 4 or 5 different modules. At the moment I'm not using CFCs for UI but for UI elements less than 10 lines long, it's looking good. ~| 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:197288 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
coldfusion photo gallery suggestions?
I need a coldfusion photo gallery that can have multiple users and allow the verification of the photos put on the site. Here is an example of one. http://www.stingrayboats.com/MyStingray/ppost/showmembers.php/cat/500/password/ its driven by http://www.photopost.com/ but its not really what we are looking for. We need user sections that allow them to post a few images that we can make sure are kid friendly. Plus let them post stories of sorts. It will be for an owners section of our site. -- Phillip B. ~| 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:197289 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: (OO) UI in CFCs
A datagrid as you refered to it is exactly the example I am thinking of. We just use custom tags here to do what you are describing. Now our system was developed long before CFCs were even available. I could see how maybe it would be easier using some Set/Get functions over potentially a lot of attributes. Although we actually do not run into a problem with a lot of attributes as is. I have been wanting to redo a form builder tag we have here for awhile and have often debated if I would benifit any over doing it in a CFC instead. On Thu, 3 Mar 2005 12:28:04 -0500, Burns, John D [EMAIL PROTECTED] wrote: Someone I work with uses CFCs for UI. For instance, something he did is make a CFC that runs a query and returns a recordset. He then passes the recordset to a UI CFC and it formats the results in a datagrid fashion. I believe the default action is to take the column names and make them table headers with a specific look and sorting functionality and then display the data in cells below the header. There's also functionality to map a display name to a column and also to limit which columns are displayed. This is used on a reporting site that uses these datagrid displays all over. So now, he can control the UI on the majority of the site within 1 simple CFC. I haven't used it yet or looked into it at great length, but in theory it sounds like a pretty good idea. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer ~| 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:197290 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: coldfusion photo gallery suggestions?
Are you looking for a solution that only allows moderated/approved images and captions to appear? Who can moderate/approve? Jerry Johnson Web Developer Dolan Media Company [EMAIL PROTECTED] 03/03/05 12:35PM I need a coldfusion photo gallery that can have multiple users and allow the verification of the photos put on the site. Here is an example of one. http://www.stingrayboats.com/MyStingray/ppost/showmembers.php/cat/500/password/ its driven by http://www.photopost.com/ but its not really what we are looking for. We need user sections that allow them to post a few images that we can make sure are kid friendly. Plus let them post stories of sorts. It will be for an owners section of our site. -- Phillip B. ~| 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:197291 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: (OO) UI in CFCs
Someone I work with uses CFCs for UI. For instance, something he did is make a CFC that runs a query and returns a recordset. He then passes the recordset to a UI CFC and it formats the results in a datagrid fashion. We do something similar. We have a set of report-building CFCs where you can populate paragraphs of text and arrays of data, then choose to (re-)display the report as HTML, RTF, PDF or CSV, with the arrays shown as tables or charts. Some kind of object-oriented approach is ideal for this. I can't see any sense in the assertion that you shouldn't use CFCs for UI. Why on earth not? In fact, in my experience the object-oriented approach is more useful for UI than it is for business data processing - although of course this is far more true when you're programming an interactive stateful environment (ActionScript, JavaScript etc). Nick ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197292 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Which is better?
Quick question... I'm wanting to do a keyword search would be it best to A. have one huge text field (varchar2 or clob) and search using like '%keyword%' or B. set up the database where these search-a-ble words are each a row themselves.. with an ID. So you'd have 50+ fields with each searchable word or phrase has it's own row? This is more of a preformance question.. -- Auxilium meum a Domino ~| 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:197293 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: (OO) UI in CFCs
Yeah, my main intrigue with it is that you could have different mini-functions within the CFC that could do formatting and arranging and stuff and could be used for a lot of data display. That way, even more than with a custom tag, you could reuse the CFC for all kinds of displays and such. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Thursday, March 03, 2005 12:38 PM To: CF-Talk Subject: Re: (OO) UI in CFCs A datagrid as you refered to it is exactly the example I am thinking of. We just use custom tags here to do what you are describing. Now our system was developed long before CFCs were even available. I could see how maybe it would be easier using some Set/Get functions over potentially a lot of attributes. Although we actually do not run into a problem with a lot of attributes as is. I have been wanting to redo a form builder tag we have here for awhile and have often debated if I would benifit any over doing it in a CFC instead. On Thu, 3 Mar 2005 12:28:04 -0500, Burns, John D [EMAIL PROTECTED] wrote: Someone I work with uses CFCs for UI. For instance, something he did is make a CFC that runs a query and returns a recordset. He then passes the recordset to a UI CFC and it formats the results in a datagrid fashion. I believe the default action is to take the column names and make them table headers with a specific look and sorting functionality and then display the data in cells below the header. There's also functionality to map a display name to a column and also to limit which columns are displayed. This is used on a reporting site that uses these datagrid displays all over. So now, he can control the UI on the majority of the site within 1 simple CFC. I haven't used it yet or looked into it at great length, but in theory it sounds like a pretty good idea. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer ~| 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:197294 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: coldfusion photo gallery suggestions?
On Thu, 3 Mar 2005 12:35:55 -0500, Phill B [EMAIL PROTECTED] wrote: I need a coldfusion photo gallery that can have multiple users and allow the verification of the photos put on the site. We need user sections that allow them to post a few images that we can make sure are kid friendly. Plus let them post stories of sorts. It will be for an owners section of our site. I searched and searched, and never found one, so we wrote our own. See http://www.sandmwedding.co.uk/index.cfm/section.gallery -- mac jordan home: www.kestrel.org work: www.webhorus.net them: www.jordan-cats.org ~| 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:197295 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: (OO) UI in CFCs
For ColdFusion, I prefer presentation elements (we are talking about HTML/XHTML/XML for the most part, right?) to be in tags. The main reasons are simple. I'd rather see: ui:navdiv a href=homehome/a /ui:navdiv Than cfsavecontent variable=myvar a href=homehome/a /cfsavecontent cfset WriteOutput(obj.showNavDiv(myvar)) Or variations along those lines. The tag based solution feels like a natural fit alongside the tag based output for the most part, and it seem like a cleaner method to wrap with tags than if you are using CFCs, and finally, it appears that you will have no choice on using tags for UI, then it makes sense to me to always use tags for UI, for consistency sake. - Calvin -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Thursday, March 03, 2005 12:10 PM To: CF-Talk Subject: RE: (OO) UI in CFCs Personally, I don't see a reason not to have a separate CFC just for UI elements that go on a page. Basically, you have a page which calls a BL (business logic) CFC for logic and a UI (user interface) CFC for specific UI elements that go on the page with the business logic. Take an average blog for example. Most have a calendar on the side. Why is this not inside a blogui.cfc file with other specific UI elements that are re-used. Yes, a custom tag can be built for each of the UI elements but on an average blog, there are 4 or 5 different small side elements. A single location for all of them would make sense rather than 4 or 5 different modules. At the moment I'm not using CFCs for UI but for UI elements less than 10 lines long, it's looking good. I don't think he means use UI and business together, but rather CFCs for the presentation. Mike? Ade -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: 03 March 2005 16:52 To: CF-Talk Subject: Re: (OO) UI in CFCs It's a big no noone of the points of using CFCs is to seperate business logic from the presentation layer I know it's possiblebut it's also possible to put page header display code in Application.cfmbut we don't do it ;-) Ultimately it's up to the developer ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com.cfm/54 ~| 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:197296 Archives: http://www.houseoffusion.com/cf_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: (OO) UI in CFCs
Our tags handle a lot of this. They are however fed a single file that is nothing more than a big switch case. You set the cases values to various things based upon what and how you want the datagrid to be displayed. The more I think about it from a coding(code within custom tag or CFC, not code that implements it) standpoint the CFC probably would be a lot easier to follow. On Thu, 3 Mar 2005 12:51:14 -0500, Burns, John D [EMAIL PROTECTED] wrote: Yeah, my main intrigue with it is that you could have different mini-functions within the CFC that could do formatting and arranging and stuff and could be used for a lot of data display. That way, even more than with a custom tag, you could reuse the CFC for all kinds of displays and such. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer ~| 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:197297 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Which is better?
The latter will almost certainly be faster, probably by a large margin. However, the former will be far simpler to set up and maintain. How about option C, create a full text index on your CLOB from option A, and use that? I know SQL Server and MySQL both support such indexes, I'd imagine others do as well. Or you could go with Verity. cheers, barneyb On Thu, 3 Mar 2005 11:54:38 -0600, Greg Morphis [EMAIL PROTECTED] wrote: Quick question... I'm wanting to do a keyword search would be it best to A. have one huge text field (varchar2 or clob) and search using like '%keyword%' or B. set up the database where these search-a-ble words are each a row themselves.. with an ID. So you'd have 50+ fields with each searchable word or phrase has it's own row? This is more of a preformance question.. -- Auxilium meum a Domino -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| 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:197298 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Which is better?
one word...Verity :) DK On Thu, 3 Mar 2005 11:54:38 -0600, Greg Morphis [EMAIL PROTECTED] wrote: Quick question... I'm wanting to do a keyword search would be it best to A. have one huge text field (varchar2 or clob) and search using like '%keyword%' or B. set up the database where these search-a-ble words are each a row themselves.. with an ID. So you'd have 50+ fields with each searchable word or phrase has it's own row? This is more of a preformance question.. -- Auxilium meum a Domino ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197299 Archives: http://www.houseoffusion.com/cf_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
delivering a file...
I want my template to deliver ( start a download ) form the current template, without opening a new window or calling a seperate template. Basically... I need to run some processing in cf and then call the downloadhow can this be done? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197300 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: (OO) UI in CFCs
Yes, I use CFCs for presentation of content, but only in situations where it makes sense. For simple web pages, absolutely not, there's no point. My main use of CFC is, for example, in a custom content management system where almost every view is the same and only a query resultset changes what content appears in the view. Just simple components such as PageHeader, QueryTable, QueryList, PersistentSructForm, InterfaceBreadcrumb, etc... They have minimal, but consistent HTML and/or CSS formatting applied to them every time. When creating hundreds of pages, it adds up. Would custom tags perform the same function? Of course. However, when creating something of significant size, with many hands touching it, I like to keep the elements used in development to a minimum. Again, as a few people have mentioned, whatever flavor you like best is what you should be eating. Like I've said to many people: it's a ColdFusion Component, not a ColdFusion Business Logic Container, or ColdFusion Transaction Processor. You can make a component out of anything you like. And if you don't agree with me, I'll take my Property p = new Property(Ball.Color(Red)) and Structure.Home.Go() - Steve -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Thursday, March 03, 2005 11:43 AM To: CF-Talk Subject: (OO) UI in CFCs I'm starting this topic to get peoples feelings on the subject. Do you use CFCs for UI? Do you have a good reason to do so? Do you see a reason to use it (or not) vs. CFINCLUDEs or CFMODULEs? According to commonly discussed practices in the community (and in part of the Macromedia docs), UI elements should not go inside of CFCs. According to the Macromedia CFC examples, UI can go inside CFCs. According to the makeup of the CFCOMPONENT and CFFUNCTION tags, the ability exists explicitly (the output attribute). According to many of the OO books I've been reading, there's no reason for UI not to be within an object. ~| 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:197301 Archives: http://www.houseoffusion.com/cf_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
Insert Unicode Smart Quotes into MS SQL Server 2000
I thought char and varchar columns would only allow the 255 ASCII values and would not allow Unicode. SQL Server 2000 seems to let me insert Unicode into these columns without any problems. For example, when I insert the two sets of MS Word smart quotes, separated by a space, into a varchar(5) column, the smart quotes get inserted just fine. I am performing the inserts and retrievals using CFMX 6.1. Smart quotes: '' Unicode values: (8220)(8221)(32)(8216)(8217) Where am I wrong in my understanding of char and varchar columns? Thank you. ~| 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:197302 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfscript functions in CFCs
If I have option values I do this function bob(required) { var optional = ''; if (arraylen(arguments) EQ 2) optional = arguments[2]; ... } I think you will find this common practice if you look trhough a good chunk of the UDFs on cflib.org. Adam H On Wed, 2 Mar 2005 23:20:25 -0600, Jared Rypka-Hauer - CMG, LLC [EMAIL PROTECTED] wrote: This also works: test.cfc - cfcomponent cfscript function getCGI(cV) { try { return cgi[cV]; } catch (any cfScriptError) { return cgi; } } /cfscript /cfcomponent temp.cfm cfdump var=#createObject('component','test').getCGI('server_name')# / cfdump var=#createObject('component','test').getCGI('')# / The first one outputs w2ksrv1 which is the server name of my dev box. The second one does a cfdump of the CGI struct. I was messing around with using various if statements to detect cV, and the try/catch worked immediately. structKeyExists always recognized that cV existed, even when it wasn't passed in. len(cV) threw an error because it tried to access a variable that hadn't been set. I haven't worked with function definitions in cfscript enough to be sure exactly the best way to declare a default value for one... but that snippet ran just fine. Laterz, J On Wed, 2 Mar 2005 14:56:18 -0700, Paul [EMAIL PROTECTED] wrote: This must be easier than I'm making it this afternoon. All the UDFs from cflib.org are written in cfscript. Is there a way to store them in a CFC, say Util.cfc, and then call them from another CFC? When I attempt to do so CF can't find the function. I experimented and wrapped the cfscript inside a cffunction definition and now CF apparently can't see the arguments I'm passing in. So, how does one call cfscript-based functions from within a CFC? -paul http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Donations Support: http://www.houseoffusion.com/tiny.cfm/54 -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.neo.servequake.com ~| 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:197303 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Which is better?
Cool, this was more or less just a preformance (which would you do in this situation) question. Thanks for the responses :) On Thu, 3 Mar 2005 13:09:26 -0500, Douglas Knudsen [EMAIL PROTECTED] wrote: one word...Verity :) DK On Thu, 3 Mar 2005 11:54:38 -0600, Greg Morphis [EMAIL PROTECTED] wrote: Quick question... I'm wanting to do a keyword search would be it best to A. have one huge text field (varchar2 or clob) and search using like '%keyword%' or B. set up the database where these search-a-ble words are each a row themselves.. with an ID. So you'd have 50+ fields with each searchable word or phrase has it's own row? This is more of a preformance question.. -- Auxilium meum a Domino ~| 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:197304 Archives: http://www.houseoffusion.com/cf_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: (OO) UI in CFCs
We use CFC's to _return_ UI elements. In other words, we don't use output=true but we do use CFC's to return data that generates output. For example, we have a contentserver CFC. This CFC returns images and files that are outside of the webroot. We also have a template CFC for one specific template that gets used over and over from both the secure and non-secure sides of our server. - Original Message - From: Michael Dinowitz [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, March 03, 2005 11:09 AM Subject: RE: (OO) UI in CFCs Personally, I don't see a reason not to have a separate CFC just for UI elements that go on a page. Basically, you have a page which calls a BL (business logic) CFC for logic and a UI (user interface) CFC for specific UI elements that go on the page with the business logic. Take an average blog for example. Most have a calendar on the side. Why is this not inside a blogui.cfc file with other specific UI elements that are re-used. Yes, a custom tag can be built for each of the UI elements but on an average blog, there are 4 or 5 different small side elements. A single location for all of them would make sense rather than 4 or 5 different modules. ~| 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:197305 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: (OO) UI in CFCs
Nick, I am not sure that previous discussions where about CFC's designed specifically for UI, but for CFC's that are instances of objects. -Original Message- From: Nick de Voil I can't see any sense in the assertion that you shouldn't use CFCs for UI. Why on earth not? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197306 Archives: http://www.houseoffusion.com/cf_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
Announcing SeeFusion 2.0 - Enterprise amp; Standard
Greetings, all. We're extremely excited to announce the release of SeeFusion 2.0. This latest version of SeeFusion includes the long-awaited Enterprise Edition, along with a host of new features. Here's a summary of 2.0: strongStandard:/strong ul liEven faster than before/li liSeeFusion.trace() function for more granular request tracking/li liOptional kill command available to stop long running/hung requests/li liPassword protection/li liCurrent/max heap size monitoring/li /ul strongEnterprise:/strong ul liAll standard version features/li liDashboard display for monitoring multiple servers, with color-coded health statuses/li liOptional logging of slow pages to a database via JDBC (logging is configurable)/li /ul We've also added a substantial amount of new content to the SeeFusion Website, including an improved administrator's guide, more FAQs, and screenshots. We welcome you to visit http://www.seefusion.com to learn more. ~| 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:197307 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: So what chair are you sitting in with your dual monitors?
Dual Dell 1800FP's in front of me, and an Aeron beneath me. On Thu, 3 Mar 2005 10:39:39 -0600, Raymond Camden [EMAIL PROTECTED] wrote: Speaking of tables - I used to have a nice desk. When I moved, the desk broke, so I borrowed a simple table that you would typically use at Thanksgiving for the kids. I love it. I feel like I have acres of real estate. I never used the drawers of my old desk anyway so it's perfect. On Thu, 03 Mar 2005 10:53:11 -0500, Jerry Johnson [EMAIL PROTECTED] wrote: At work, crappy 30 dollar office depot special. The up/down air cylinder is broken and the screw to hold the back upright doesn't hold. At home I've got an Aeron chair (used, part of a complete Herman Miller cube system I resold), but I don't use it for coding anymore. My computer desk is a low Japanese-style table (42 square, 15 high, oak and copper) that I sit indian style or kneel at. I also use an overstuffed leather chair and a laptop for general surfing. Jerry Johnson Web Developer Dolan Media Company [EMAIL PROTECTED] 03/03/05 10:48AM The thread about dual (or 3+) monitors has been a lot of fun to read, but I'm wondering what kind of chair people are sitting in as they survey their 3200-wide pixel domain -- Areon? Mirra? Folding chair? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197308 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: So what chair are you sitting in with your dual monitors?
I have a Steelcase Leap chair. I have not found the perfect chair, but this one is pretty good. -Mike Chabot On Thu, 3 Mar 2005 10:48:30 -0500, John Paul Ashenfelter [EMAIL PROTECTED] wrote: The thread about dual (or 3+) monitors has been a lot of fun to read, but I'm wondering what kind of chair people are sitting in as they survey their 3200-wide pixel domain -- Areon? Mirra? Folding chair? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197312 Archives: http://www.houseoffusion.com/cf_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: Questions on a dynamic tab delimited export and regular expressions
Is or was it the quotes cffile action=append file=#tempfile# output=cfloop list= -- ??? -Dan -Original Message- From: Doug Hyde [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 02, 2005 8:28 PM To: CF-Talk Subject: Questions on a dynamic tab delimited export and regular expressions Help please... I am trying to create a little custom tag that allows someone to query a database, and then (if they decide) have the results of the query sent to them as a tab delimited file by email. The user can select any number of fields. The data is in sql server, and some of it is in ntext columns, and in some cases has tabs in it (commas won't work...more commas than tabs). So, I have two challenges. First, because the user can select any of the fields they want, I don't always know what the column names are ahead of time. To resolve this for column headings in the export file, I created a tab-delimited list based on query.columnlist. However, it gets tricky for the actual data...I loop through the query, and append each value. What I need to do is run a regular expression inside this loop...but I am not sure how to (1) dynamically generate the variable from the query based on and (2) run a regular expression on any ntext fields to remove returns.here is my code - throws an error at output in cffile (doesn't like the loop). The loop works fine out of the cffile tag. Any thoughts? cfoutput query=getData cffile action=append file=#tempfile# output=cfloop list=#getData.columnList# index=i cfif findnocase('mem',i) cfset temp = rereplace(setvariable(i,#evaluate('getData.'i)#),replacethis,replacewith)c hr(9) cfelse cfset temp = setvariable(i,#evaluate('getData.'i)#)chr(9) /cfif cfoutput#temp#/cfoutput /cfloop addnewline=Yes /cfoutput Thanks. D ~| 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:197313 Archives: http://www.houseoffusion.com/cf_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: Questions on a dynamic tab delimited export and regular expressions
Please by all means use cfsavecontent for your output variable. cfsavecontent variable=myVar Do stuff /cfsavecontent cffile output=#variables.myVar# ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197314 Archives: http://www.houseoffusion.com/cf_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: Announcing SeeFusion 2.0 - Enterprise amp; Standard
very exciting! We have been looking at this tool, trying to convinve the boss now liOptional kill command available to stop long running/hung requests/li Does this kill the actual thread? Doug On Thu, 03 Mar 2005 13:49:28 -0400, Patrick Quinn [EMAIL PROTECTED] wrote: Greetings, all. We're extremely excited to announce the release of SeeFusion 2.0. This latest version of SeeFusion includes the long-awaited Enterprise Edition, along with a host of new features. Here's a summary of 2.0: strongStandard:/strong ul liEven faster than before/li liSeeFusion.trace() function for more granular request tracking/li liOptional kill command available to stop long running/hung requests/li liPassword protection/li liCurrent/max heap size monitoring/li /ul strongEnterprise:/strong ul liAll standard version features/li liDashboard display for monitoring multiple servers, with color-coded health statuses/li liOptional logging of slow pages to a database via JDBC (logging is configurable)/li /ul We've also added a substantial amount of new content to the SeeFusion Website, including an improved administrator's guide, more FAQs, and screenshots. We welcome you to visit http://www.seefusion.com to learn more. ~| 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:197315 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: short term contractor required
What is XML-RPC? Is it like XMLHttpRequest? -Original Message- From: Dave Wilson [mailto:[EMAIL PROTECTED] Sent: Thursday, March 03, 2005 12:25 PM To: CF-Talk Subject: OT: short term contractor required Hi all, Sorry if this is an inappropriate post, however I'm looking for someone to write up a Coldfusion XML-RPC implementation for me as its just beyond my skill levels. Basics of the project is to use XML-RPC to check our db for new events, then push them to the client. The environment is CFMX 6.1 on Debian and apache 2.0.49 MySQL 4.1 db If you're interested please email me offlist on [EMAIL PROTECTED] and we can discuss terms. Thanks, Dave ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197316 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: short term contractor required
Dan see http://www.xmlrpc.com/spec Dave see http://www.markme.com/cantrell/archives/002339.cfm -Original Message- From: Dan Plesse [mailto:[EMAIL PROTECTED] Sent: Thursday, March 03, 2005 2:26 PM To: CF-Talk Subject: RE: short term contractor required What is XML-RPC? Is it like XMLHttpRequest? ~| 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:197317 Archives: http://www.houseoffusion.com/cf_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: coldfusion photo gallery suggestions?
Yup. Every thing would have to go thru a person here in the office. If the photo or story is ok, it would get approved and listed to the public. At this point I would be ok with a php app if one in CF doesn't exist. On Thu, 03 Mar 2005 12:32:52 -0500, Jerry Johnson [EMAIL PROTECTED] wrote: Are you looking for a solution that only allows moderated/approved images and captions to appear? Who can moderate/approve? Jerry Johnson Web Developer Dolan Media Company ~| 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:197318 Archives: http://www.houseoffusion.com/cf_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: (OO) UI in CFCs
And if you don't agree with me, I'll take my Property p = new Property(Ball.Color(Red)) and Structure.Home.Go() That's one of the funniest things I've read all week!!! (It's been a hard one :) -- dc ~| 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:197319 Archives: http://www.houseoffusion.com/cf_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: coldfusion photo gallery suggestions?
Just seeing what the needs are to dig around for a solution. You have 3 user types. General public. Free unfettered access to view gallery. view galleries. Submitter . unrestricted ability to submit images and text. How many images per piece of text? Can the submitter create a new gallery, or just upload into existing gallery? Is there a size/volume restriction? Does the submitter need to be registered/logged in? Moderator. restricted access to manage approval of uploaded images. manage galleries manage approvals Jerry Johnson Web Developer Dolan Media Company [EMAIL PROTECTED] 03/03/05 02:40PM Yup. Every thing would have to go thru a person here in the office. If the photo or story is ok, it would get approved and listed to the public. At this point I would be ok with a php app if one in CF doesn't exist. ~| 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:197320 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: Live Chat
Can anyone recommend some live chat software (preferably something that integrates with CF). We need something that works sort of like the ESPN chat, which allows visitors to ask questions and after the moderator approves it, the question would show up, and then the host can answer the question. Any suggestions will be appreciated, Russ ~| 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:197309 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: short term contractor required
Hi all, Sorry if this is an inappropriate post, however I'm looking for someone to write up a Coldfusion XML-RPC implementation for me as its just beyond my skill levels. Basics of the project is to use XML-RPC to check our db for new events, then push them to the client. The environment is CFMX 6.1 on Debian and apache 2.0.49 MySQL 4.1 db If you're interested please email me offlist on [EMAIL PROTECTED] and we can discuss terms. Roger Benningfield wrote a ColdFusion-based XML-RPC CFC a long time ago: http://support.journurl.com/users/admin/index.cfm?mode=articleentry=669 I'm not sure it he's updated it since this entry, but it should get you a ways down the path. Regards, Dave. ~| 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:197321 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Troublesome or Dangerous Form Submission Characters for SQL
Are there any characters that a user could enter into a textarea form field that I should strip out before inserting the value into an MS SQL Server varchar field? Could these characters cause problems? semi-colon,,*,+,-,--,?,%,_. To prevent SQL injection, I could strip out truncate, drop, insert, update, delete, and '--.' However, queryparam and the use of stored procedures should prevent SQL injection. Thank you, Mike Chabot ~| 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:197310 Archives: http://www.houseoffusion.com/cf_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: Troublesome or Dangerous Form Submission Characters for SQL
Nothing if you're using queryparam/SPs, however on pulling the data back out double quotes may cause you trouble in text inputs(or single quotes if that's how you delimit your attributes in HTML). Use HTMLEditFormat() to solve the problem with double quotes. Ade -Original Message- From: Mike Chabot [mailto:[EMAIL PROTECTED] Sent: 03 March 2005 19:03 To: CF-Talk Subject: Troublesome or Dangerous Form Submission Characters for SQL Are there any characters that a user could enter into a textarea form field that I should strip out before inserting the value into an MS SQL Server varchar field? Could these characters cause problems? semi-colon,,*,+,-,--,?,%,_. To prevent SQL injection, I could strip out truncate, drop, insert, update, delete, and '--.' However, queryparam and the use of stored procedures should prevent SQL injection. Thank you, Mike Chabot -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 266.6.0 - Release Date: 02/03/2005 ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197311 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Troublesome or Dangerous Form Submission Characters for SQL
Thanks for the tip about the double quotes. I am concerned that some people who enter in the text field will see the five character HTML-safe equivalent when they go to edit the value because of the HtmlEditFormat function. IE 6 does not seem to have this problem. Are there any browsers that display the contents of the value attribute literally, instead of properly interpreting the HTML-safe code? Similarily, when I submit a field who's value attribute equals an expanded HTML-safe code, CF receives the interpreted, single-character, value (actually %26 for amp; if you look at the headers). Are there any browsers that do not do this? As a general rule, should I wrap HtmlEditFormat around all form field values. For example: input type=text value=#HtmlEditFormat(form.fieldname)#. Thank you, Mike Chabot On Thu, 3 Mar 2005 19:09:02 -, Adrian Lynch [EMAIL PROTECTED] wrote: Nothing if you're using queryparam/SPs, however on pulling the data back out double quotes may cause you trouble in text inputs(or single quotes if that's how you delimit your attributes in HTML). Use HTMLEditFormat() to solve the problem with double quotes. Ade ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197322 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Stored Procedures in a CFC
On Thu, 3 Mar 2005 13:54:45 -, Adrian Lynch [EMAIL PROTECTED] wrote: I use structures to pass back multiple things from functions, but I'm not so sure you're right about not using an array. An array maps to the cfprocresult's resultset attribute(as it could equally to it's name attrib) but with the array you don't need to know the name used only the number of the resultset. But returning an array causes the array to be *copied* (not a huge deal with only two entries but still...). An array doesn't give you nice names - it effectively requires calling code to know which order the two entries are in. It's much better from a maintenance point of view to use a struct with well-named keys. That way if you change the implementation of the CFC method, you can still return the two queries even if you move away from a SP with two result sets... (so the struct is better encapsulation because it hides the SP implementation). -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Breeze Me! -- http://www.corfield.org/breezeme Got Gmail? -- I have 49, yes 49, invites to give away! If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| 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:197323 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Stored Procedures in a CFC
I think for readability returning the values in a structure is going to do a.k.a S.Isaac cfset data = myCFC.getQueries() cfloop query=data.getUsers.../cfloop cfloop query=data.getRoles.../cfloop But the idea of going through a function to get the different recordsets, and referencing via the array would mean that there is no need to know the name of the queries? defently beneficial. Cheers everyone for you help Andy On Thu, 3 Mar 2005 17:17:48 -, Adrian Lynch [EMAIL PROTECTED] wrote: Right, but in your getResult1() and getResult2() you access the key named in loadData(). That's what I'm saying(asking whether it's) bad. Would array syntax not hide better what loadData() does? -Original Message- From: Marc Campeau [mailto:[EMAIL PROTECTED] Sent: 03 March 2005 17:04 To: CF-Talk Subject: Re: Stored Procedures in a CFC The cfstoredproc tag will return both queries regardless, you could construct the function to return one of the callers choosing, but from a simplistic approach returning both in either an array or a structure seems more useful. The point I was making was that you either reference them as: function()[1] and function()[2] or: function().resultsetOne and function().resultsetTwo one, the structure, exposes more about the function than the other, the array. I understand but I feel like they both expose too much to the application. ;) I usually prefer structs becauses they're more literate but by hiding the resultsets in the CFC it doesn't matter whether you use an array, struct or whatever. I would do this: component private datasets = structNew(); private isLoaded = false; private function loadData() if not isLoaded sp result1 result2 /sp datasets.result1 = result1; datasets.result2 = result2; isLoaded = true; /if return; /function private function getResult1() loadData(); return datasets.result1; /function private function getResult2() loadData(); return datasets.result2; /function /component -- Marc -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 266.6.0 - Release Date: 02/03/2005 ~| 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:197324 Archives: http://www.houseoffusion.com/cf_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
was: coldfusion photo gallery suggestions? - Is this List Working?
I made two posts to coldfusion photo gallery suggestions? several hours ago and neither of them got listed, so here is my post again. Phill, We are about to start a public beta of a ColdFusion/JavaScript photo gallery with the features you are requesting. Please contact me off-list if you are interested at: [EMAIL PROTECTED] or 503-244-3440 Thank you, Aftershock Web Design, Inc. by: Stan Winchester President/Developer [EMAIL PROTECTED] http://www.aftershockweb.com/ Phone 503-244-3440 Fax 503-244-3454 ~| 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:197325 Archives: http://www.houseoffusion.com/cf_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
Safe HTML display of user-entered text
Below is a function for displaying text, entered by users in form fields, in HTML format to someone else. Can this code be improved? This code assumes the user is not allowed to enter HTML markup in the text fields. function friendlyHtml(argStr) { argStr=htmlEditFormat(argStr); //Replace line breaks with BRs argStr = reReplace(argStr,'(#chr(13)##chr(10)#|#chr(10)#|#chr(13)#)','br','All'); //Replace tabs with spaces argStr= replace(argStr,chr(9),'nbsp;nbsp;nbsp;nbsp;nbsp;','All'); //Replace all remaining spaces (chr10-chr12) with a regular space argStr= REReplace(argStr,'[[:space:]]+',' ','All'); return argStr; } Thank you, Mike Chabot ~| 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:197326 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Binding Flash Form
Thanks for the info. I see that you use the name of the input or textarea to reference it. How would you reference a cfformgroup object? - Original Message - From: Sean Corfield [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, March 02, 2005 5:14 PM Subject: Re: Binding Flash Form On Wed, 2 Mar 2005 16:08:46 -0500, David Brown [EMAIL PROTECTED] wrote: I would like to evaluate the value on a flash form CF MX 7 cfform format=flash in a cfif statment to decide if I should make a cftextarea visiable or not. cfif works on the server. You need something that works in Flash. This will do what you want: cfform format=flash cfformgroup type=vertical cfformitem type=text Downtime Required/cfformitem cfinput type=text required=yes name=DowntimeHours label=Hours size=3 onchange=if (DowntimeHours.text 2) Note1.visible = true; else Note1.visible = false; cfinput type=text required=yes name=DowntimeMin label=Minutes size=3 /cfformgroup cfformitem type=hrule / cftextarea name=Note1 value=Downtime requiring more than 2 hours needs a detailed explanation! height=50 width=700 disabled=No required=No enabled=Yes visible=false/cftextarea /cfform -- Sean A Corfield -- http://www.corfield.org/ Team Fusebox -- http://www.fusebox.org/ Breeze Me! -- http://www.corfield.org/breezeme Got Gmail? -- I have 49, yes 49, invites to give away! If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| 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:197327 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Safe HTML display of user-entered text
This code assumes the user is not allowed to enter HTML markup in the text fields. By this you mean that the submitted data is checked for HTML content via another means? Because the way you said it (the form field itself prevents HTML from being entered) isn't secure. cheers, barneyb On Thu, 3 Mar 2005 15:34:48 -0500, Mike Chabot [EMAIL PROTECTED] wrote: Below is a function for displaying text, entered by users in form fields, in HTML format to someone else. Can this code be improved? This code assumes the user is not allowed to enter HTML markup in the text fields. function friendlyHtml(argStr) { argStr=htmlEditFormat(argStr); //Replace line breaks with BRs argStr = reReplace(argStr,'(#chr(13)##chr(10)#|#chr(10)#|#chr(13)#)','br','All'); //Replace tabs with spaces argStr= replace(argStr,chr(9),'nbsp;nbsp;nbsp;nbsp;nbsp;','All'); //Replace all remaining spaces (chr10-chr12) with a regular space argStr= REReplace(argStr,'[[:space:]]+',' ','All'); return argStr; } Thank you, Mike Chabot -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| 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:197328 Archives: http://www.houseoffusion.com/cf_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