Re: Dhtml Menu System
DHTMLGoodies.com is the best I have seen! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232981 Archives: http://www.houseoffusion.com/cf_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
Railo MySQL data source / debugging template
Has anyone encounted the following two nasty issues using Railix (standalone Railo CF engine) on Linux (1.5 JVM) ? 1) The debugging can't be turned off (says variable memorylog doesnt exist in Form Scope when unticked). 2) MySQL datasource's give the following error when trying to save connection details: class [org.gjt.mm.mysql.Driver] is not a JDBC Driver class must implement interface [java.sql.Driver] I've pinged the Railo peeps too, but they've not gotten back yet. -- Tom Chiverton Advanced ColdFusion Programmer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232982 Archives: http://www.houseoffusion.com/cf_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: Annoyances with cfencode
Hmmm. So I gather that this behavior is what you see too? You work around it by not asking it to do more than one file at once? A bit odd that after all these years, basic functionality of this tool is so broken. Thanks, Dave Merrill Actually i've never used it, it was just an off the cuff remark... there might be a way to get it to work, maybe ask the rabid guy ;) As for these kinds of tools being broken: the silent command line installer on Unix insists on installing a developer version, even when you put the correct enterprise serial number in. It doesn't get fixed because it affects such a tiny number of people - which is probably the same thing happening here... /t ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232983 Archives: http://www.houseoffusion.com/cf_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
Source Control Choices
We're looking at changing our source control system but are having trouble finding something that seems suited to our needs. Basically, we have around six developers all working on our applications, checking into a dev server with VSS before running the code. From here the code goes to a test box then live. All our boxes are win2003 and IIS6. What we are looking for is something that makes the release process from server to server nice and easy, but also allows us to branch an app out of the way so that shared code can move past it in test and go live before the original code does (we have clients who insist on delaying go live dates :-() We can't really have local dev machines due to the sheer amount of code (~3mil lines) and applications (~ 50)we are controlling. Any ideas on how we might set something up that will let us do this? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232984 Archives: http://www.houseoffusion.com/cf_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: Source Control Choices
Hi Neil, This crops up regularly on this list so a search of the archives may be prove fruitful for you. We use CVS because our IDE of choice is CFEclipse and the CVS integration is part of the base eclipse product. We too have very large systems and several of them (although probably not as big as yours) and we do use local dev machines. So each PC has cf developer edition and IIS under WXP pro. CVS handles branching and it is made easy to manage by the tools in eclipse. SVN is the next generation of CVS and has fixed some CVS limitations so this is worth a look. Alot depends on the IDE you want to use and how important having it integrated to this IDE is. In terms of deployment CVS/SVN allow you to select a snapshot of code to release (in various ways) but how it moves from server to server is down to you. We have written a little CF app which provides a nice interface to some ANT scripts which are able to extract code from CVS and then copy it around. Hope all that helps! There are lots of choices, I chose CVS because it was tried and tested with lots of good tools. Good Luck! On 2/21/06, Neil Middleton [EMAIL PROTECTED] wrote: We're looking at changing our source control system but are having trouble finding something that seems suited to our needs. Basically, we have around six developers all working on our applications, checking into a dev server with VSS before running the code. From here the code goes to a test box then live. All our boxes are win2003 and IIS6. What we are looking for is something that makes the release process from server to server nice and easy, but also allows us to branch an app out of the way so that shared code can move past it in test and go live before the original code does (we have clients who insist on delaying go live dates :-() We can't really have local dev machines due to the sheer amount of code (~3mil lines) and applications (~ 50)we are controlling. Any ideas on how we might set something up that will let us do this? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232985 Archives: http://www.houseoffusion.com/cf_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
One type of NULL NULL error solved!
Hi all, I actually found a solution to ONE of the multiple NULL NULL errors that I have encountered over the past year. Here is the setup. qryGetDate.theDate is populated with a date from the database. The object is to produce table headers for all the months up to that date. (extra code not shown) cfloop from=1 to=#month(qryGetDate.theDate)# index=Variables.theLoop th#left(monthAsString(Variables.theLoop), 3)#/th /cfloop The NULL NULL error came up when qryGetDate.theDate ended up being NULL. This of course wasn't supposed to happen, but the code to prevent the variable from being NULL had a flaw. Weird thing is I would have expected CFLOOP to throw an error that the TO was not a number. Fixed the code and one type of NULL NULL error went away. Steve ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232986 Archives: http://www.houseoffusion.com/cf_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: Railo MySQL data source / debugging template
On Tuesday 21 February 2006 09:14, Thomas Chiverton wrote: I've pinged the Railo peeps too, but they've not gotten back yet. Known bugs, apperently. -- Tom Chiverton Advanced ColdFusion Programmer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232987 Archives: http://www.houseoffusion.com/cf_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: Ralio (was Re: Bluedragon 6.1)
On Thursday 02 February 2006 14:31, Ray Champagne wrote: This probably would have been better sent to them first, dontcha think? How do you know I didn't ? -- Tom Chiverton Advanced ColdFusion Programmer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232988 Archives: http://www.houseoffusion.com/cf_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: Ralio (was Re: Bluedragon 6.1)
Well, good point, I don't know. I guess what I gleaned from the original post was that this was the first place you posted. I'm pretty sure that others got the same vibe, but I can't speak for them. Usually, ppl put the disclaimer that they tried to contact the webmaster with the error, but since they didn't get back to them, blah blah blah. So, did you? :) BTW, this is quite the old post at this point, isn't it? I was surprised to see it revived! Thomas Chiverton wrote: On Thursday 02 February 2006 14:31, Ray Champagne wrote: This probably would have been better sent to them first, dontcha think? How do you know I didn't ? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232989 Archives: http://www.houseoffusion.com/cf_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
using cfinclude
I've got a little CMS type thing I'm working on, and I've been using cfinclude to import the page content (from a DB) into the page. Recently, my client asked me if I could frame in a URL from an IDX feed, and I was just going to put the http address into the cfinclude, but that throws an error. From what I am reading this, is because of multiple http headers being called into the page, but I'm not sure. The error is here: http://rivervalleyrealtyme.com/index.cfm?p=idx What are my alternatives? Or, is there a way to do this with cfinclude that I'm missing? Thanks, Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232990 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: using cfinclude
If I recall right, the CFINCLUDE takes a relative path such not a URL path. -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 21, 2006 9:38 AM To: CF-Talk Subject: using cfinclude I've got a little CMS type thing I'm working on, and I've been using cfinclude to import the page content (from a DB) into the page. Recently, my client asked me if I could frame in a URL from an IDX feed, and I was just going to put the http address into the cfinclude, but that throws an error. From what I am reading this, is because of multiple http headers being called into the page, but I'm not sure. The error is here: http://rivervalleyrealtyme.com/index.cfm?p=idx What are my alternatives? Or, is there a way to do this with cfinclude that I'm missing? Thanks, Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232991 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: using cfinclude
You can't cfinclude an http address. It needs a local template. You can do cfhttp and then display the output (and you can parse it first of course). Russ -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 21, 2006 9:38 AM To: CF-Talk Subject: using cfinclude I've got a little CMS type thing I'm working on, and I've been using cfinclude to import the page content (from a DB) into the page. Recently, my client asked me if I could frame in a URL from an IDX feed, and I was just going to put the http address into the cfinclude, but that throws an error. From what I am reading this, is because of multiple http headers being called into the page, but I'm not sure. The error is here: http://rivervalleyrealtyme.com/index.cfm?p=idx What are my alternatives? Or, is there a way to do this with cfinclude that I'm missing? Thanks, Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232992 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: using cfinclude
I don't think you can include a remote template, unless that's been changed in CF7. --Ben Ray Champagne wrote: I've got a little CMS type thing I'm working on, and I've been using cfinclude to import the page content (from a DB) into the page. Recently, my client asked me if I could frame in a URL from an IDX feed, and I was just going to put the http address into the cfinclude, but that throws an error. From what I am reading this, is because of multiple http headers being called into the page, but I'm not sure. The error is here: http://rivervalleyrealtyme.com/index.cfm?p=idx What are my alternatives? Or, is there a way to do this with cfinclude that I'm missing? Thanks, Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232993 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: using cfinclude
Hi Ray You should use cfhttp (http://livedocs.macromedia.com/coldfusion/7/htmldocs/0272.htm) for this. m. Ray Champagne wrote: I've got a little CMS type thing I'm working on, and I've been using cfinclude to import the page content (from a DB) into the page. Recently, my client asked me if I could frame in a URL from an IDX feed, and I was just going to put the http address into the cfinclude, but that throws an error. From what I am reading this, is because of multiple http headers being called into the page, but I'm not sure. The error is here: http://rivervalleyrealtyme.com/index.cfm?p=idx What are my alternatives? Or, is there a way to do this with cfinclude that I'm missing? Thanks, Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232994 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: using cfinclude
Yea, I tried that too, actually, but got a different error. I didn't give it tons of thought or time, so I'll try it out again tonight and see if I can't do that. Weird, though, I was under the impression that cfinclude could take an http address, since when in homesite+, when I type in cfinclude template=, the code hint prompts you to put in an http address Russ wrote: You can't cfinclude an http address. It needs a local template. You can do cfhttp and then display the output (and you can parse it first of course). Russ -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 21, 2006 9:38 AM To: CF-Talk Subject: using cfinclude I've got a little CMS type thing I'm working on, and I've been using cfinclude to import the page content (from a DB) into the page. Recently, my client asked me if I could frame in a URL from an IDX feed, and I was just going to put the http address into the cfinclude, but that throws an error. From what I am reading this, is because of multiple http headers being called into the page, but I'm not sure. The error is here: http://rivervalleyrealtyme.com/index.cfm?p=idx What are my alternatives? Or, is there a way to do this with cfinclude that I'm missing? Thanks, Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232995 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: using cfinclude
Cool surname you have there Ben :-) As the guys said, you cannot cfinclude remote files. You can CFHTTP it, or if as you say, your framing the content, in an iframe I presume, you can just use the direct url in the IFRAME src. Russ -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: 21 February 2006 14:48 To: CF-Talk Subject: Re: using cfinclude I don't think you can include a remote template, unless that's been changed in CF7. --Ben Ray Champagne wrote: I've got a little CMS type thing I'm working on, and I've been using cfinclude to import the page content (from a DB) into the page. Recently, my client asked me if I could frame in a URL from an IDX feed, and I was just going to put the http address into the cfinclude, but that throws an error. From what I am reading this, is because of multiple http headers being called into the page, but I'm not sure. The error is here: http://rivervalleyrealtyme.com/index.cfm?p=idx What are my alternatives? Or, is there a way to do this with cfinclude that I'm missing? Thanks, Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232996 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: using cfinclude
You wouldn't use cfinclude. That is only for local files that will be included and parsed as CF. You want to use cfhttp. -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 21, 2006 9:38 AM To: CF-Talk Subject: using cfinclude I've got a little CMS type thing I'm working on, and I've been using cfinclude to import the page content (from a DB) into the page. Recently, my client asked me if I could frame in a URL from an IDX feed, and I was just going to put the http address into the cfinclude, but that throws an error. From what I am reading this, is because of multiple http headers being called into the page, but I'm not sure. The error is here: http://rivervalleyrealtyme.com/index.cfm?p=idx What are my alternatives? Or, is there a way to do this with cfinclude that I'm missing? Thanks, Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232997 Archives: http://www.houseoffusion.com/cf_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: Source Control Choices
So each PC has cf developer edition and IIS under WXP pro. How do you go about keeping these all up to date? How do you manage more than one developer working on an app at any one time. CVS handles branching and it is made easy to manage by the tools in eclipse. How do you handle branching from a browsing point of view. Do you not have more than one branch active at any one time? Alot depends on the IDE you want to use and how important having it integrated to this IDE is. We're all using DWMX8 here. Neil On 2/21/06, Neil Middleton [EMAIL PROTECTED] wrote: ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232998 Archives: http://www.houseoffusion.com/cf_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: Ralio (was Re: Bluedragon 6.1)
On Tuesday 21 February 2006 14:27, Ray Champagne wrote: So, did you? :) Yeah, nice me :-) BTW, this is quite the old post at this point, isn't it? I was surprised to see it revived! I've been busy - just gotta go comment on that Microsoft buying Macromedia thread and I should be all caught up ;-) -- Tom Chiverton Advanced ColdFusion Programmer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232999 Archives: http://www.houseoffusion.com/cf_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: Generate JPEG from DB data
Maybe. I think for now I'll go with data to pdf, pdf to jpeg wherever we need it. Basically what we're doing is using these wireless digital sign boards to display constantly changing data. The boards will only take jpegs, tiffs, whatever. I was wondering if people use a watermark technique like that to make images like the soldier who's holding up a sign and you can specify your own text that shows up on the sign (and other photos like that where you can insert text to make your own photo). I can't remember any urls to a photo like that. Thanks, Brian -Original Message- From: Casey Dougall [mailto:[EMAIL PROTECTED] Sent: Monday, February 20, 2006 5:30 PM To: CF-Talk Subject: Re: Generate JPEG from DB data Couldn't you use http://www.opensourcecf.com/imagecfc/ and write the database stuff as a watermark on a blank image? Casey ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233000 Archives: http://www.houseoffusion.com/cf_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
Verity Error -1705
Hi all. I posted this to the CF forum on the Macromedia site but got no responses and spotted someone over there saying how this mailing list was a much better place to get answers anyway. So General Info: Windows Server 2003 / IIS CF 7,0,0,91690 Standard Default install location All collections in englishx Single server install (no clustering). The collections are created from queries and refreshed every fifteen minutes. There are no categories. The 2 collections in the example error below are average collections on the server and are 68/547 docs and 365/1,408 kb respectively. - I'm getting regular errors from verity which return the following: There was a problem executing the CFSearch tag with the following collections. Collection (status code): collection_name (-1705), collection_2_name (-1705) There are very few references to this error that I can find. When researching a while ago I came across a thread that I've found archived here: http://software.groupbrowser.com/printthread.php?t=179708. This thread mentions the collection language which I changed but still get the error. I have tried wrapping cflocks around the cfindex and cfsearch tags (i realise this is not current best practise) but still get the error. Sometimes the error is short lived - if I refresh the page the search is performed correctly. Other times it is permanent and requires manual restarting of the CF Search service - a point of note is that the K2Server service needs to have its process stopped in task manager as the restart command in services fails. I have no idea what else to try or what could be causing this. It's also hard to imagine I'm the only one experiencing the error (but maybe I am...). Can anyone help, offer advice or at least share similar experiences in an attempt to track down the cause? Many thanks Gareth ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233001 Archives: http://www.houseoffusion.com/cf_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
cfsavecontent and cfqueryparam
I am trying to optimize some queries, and as such, trying to put several 1 row insert queries into one. I am trying to use a function to generate the sql, and then just loop through each record and generate the sql I need. The issue I'm running into is that cfqueryparam is not supported outside of cfquery. Is there some way to escape it, or am I stuck with putting the sql inline with the loop? Here is an example of what I want: cfsavecontent variable=myqry set @userId=cfqueryparam cfsqltype=cf_sql_integer value=#userID# /cfsavecontent Russ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233004 Archives: http://www.houseoffusion.com/cf_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: Google indexing
How does google decide what to put up there? Click popularity? Of course they can't tell when you click on something, so maybe link popularity? That's the Holy Grail for all SEOsand it changes frequently ;-) No it's not as sinmple as click popularitythere is keyword density, inbound links, analysis of the content in general...and on and on and on ;-) You'll want to look at .HTACCESS files and how to use them to tell bots pages have been removed or to re-direct them to the new page. Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233005 Archives: http://www.houseoffusion.com/cf_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: cfsavecontent and cfqueryparam
Nope, if you HAVE to put your SQL outside a CFQUERY tag, you have to use inline values. Make sure you're very careful about sanitizing any such values before using them, or you could be leaving yourself open to SQL injection attacks. And don't forget preserveSingleQuotes() when you dump the generated SQL into the CFQUERY tag. cheers, barneyb On 2/21/06, Russ [EMAIL PROTECTED] wrote: I am trying to optimize some queries, and as such, trying to put several 1 row insert queries into one. I am trying to use a function to generate the sql, and then just loop through each record and generate the sql I need. The issue I'm running into is that cfqueryparam is not supported outside of cfquery. Is there some way to escape it, or am I stuck with putting the sql inline with the loop? Here is an example of what I want: cfsavecontent variable=myqry set @userId=cfqueryparam cfsqltype=cf_sql_integer value=#userID# /cfsavecontent Russ -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233006 Archives: http://www.houseoffusion.com/cf_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: cfsavecontent and cfqueryparam
There's no way to do something like lt;cfqueryparam and then do an evaluate or something? There must be some workaround... -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 21, 2006 11:50 AM To: CF-Talk Subject: Re: cfsavecontent and cfqueryparam Nope, if you HAVE to put your SQL outside a CFQUERY tag, you have to use inline values. Make sure you're very careful about sanitizing any such values before using them, or you could be leaving yourself open to SQL injection attacks. And don't forget preserveSingleQuotes() when you dump the generated SQL into the CFQUERY tag. cheers, barneyb On 2/21/06, Russ [EMAIL PROTECTED] wrote: I am trying to optimize some queries, and as such, trying to put several 1 row insert queries into one. I am trying to use a function to generate the sql, and then just loop through each record and generate the sql I need. The issue I'm running into is that cfqueryparam is not supported outside of cfquery. Is there some way to escape it, or am I stuck with putting the sql inline with the loop? Here is an example of what I want: cfsavecontent variable=myqry set @userId=cfqueryparam cfsqltype=cf_sql_integer value=#userID# /cfsavecontent Russ -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233007 Archives: http://www.houseoffusion.com/cf_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 SeeStack: Free Stack Trace Analysis Utility
Greetings, all. We've been using a simple home-grown utility for parsing JRun/ColdFusion stack traces for some time now, and since so many of our consulting customers have asked us for such a tool, it occurred to us that the broader community might find it useful as well. You can upload a stack trace file (text mime-type only), or paste one into the tool. SeeStack loops over the trace, presents the stacks/threads in a more readable fashion, and reports some basic summary information about thread states at the point the trace was taken. No charge to use it, although we may offer a Pro edition down the road. Any and all feedback welcomed (use the SeeFusion Support address). You can find the tool here: http://www.seefusion.com/seestack/seestack.cfm Best, Patrick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233008 Archives: http://www.houseoffusion.com/cf_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: Getting the Flex2 Phones sample to work. [SOLVED]
As well as all the other suggestions, I had to add all the MXML files to the flex project manually. Once that was done all was well. From thinman's post to Ben Forta's blog: http://www.forta.com/blog/index.cfm/2006/2/1/ColdFusion-Flex-2-Sample-Application Needed to add the all 3 mxml files into the Flex Applications panel of the Properties for the Phones app: Right-click the app Select Properties Select Flex Applications Click the 'Add..' button Select ProductDetails.mxml and Thumb.mxml -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233009 Archives: http://www.houseoffusion.com/cf_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: cfsavecontent and cfqueryparam
just thought of a nasty workaround (untested): write it to file then include it! -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: 21 February 2006 17:02 To: CF-Talk Subject: RE: cfsavecontent and cfqueryparam There's no way to do something like lt;cfqueryparam and then do an evaluate or something? There must be some workaround... -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 21, 2006 11:50 AM To: CF-Talk Subject: Re: cfsavecontent and cfqueryparam Nope, if you HAVE to put your SQL outside a CFQUERY tag, you have to use inline values. Make sure you're very careful about sanitizing any such values before using them, or you could be leaving yourself open to SQL injection attacks. And don't forget preserveSingleQuotes() when you dump the generated SQL into the CFQUERY tag. cheers, barneyb On 2/21/06, Russ [EMAIL PROTECTED] wrote: I am trying to optimize some queries, and as such, trying to put several 1 row insert queries into one. I am trying to use a function to generate the sql, and then just loop through each record and generate the sql I need. The issue I'm running into is that cfqueryparam is not supported outside of cfquery. Is there some way to escape it, or am I stuck with putting the sql inline with the loop? Here is an example of what I want: cfsavecontent variable=myqry set @userId=cfqueryparam cfsqltype=cf_sql_integer value=#userID# /cfsavecontent Russ -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233010 Archives: http://www.houseoffusion.com/cf_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: cfsavecontent and cfqueryparam
I thought about that, but didn't mention it. File I/O can be hideous for performance if you are doing this a lot in an environment which needs to be fast. I would consider it a last resort. This could open up even more doors for code insertion. ~Brad -Original Message- From: Jim [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 21, 2006 11:33 AM To: CF-Talk Subject: RE: cfsavecontent and cfqueryparam just thought of a nasty workaround (untested): write it to file then include it! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233011 Archives: http://www.houseoffusion.com/cf_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: cfsavecontent and cfqueryparam
You could generate a file with the query in it, and then cfinclude that file between the cfquery tags. But that seems like overkill. If your reason to use cfqueryparam is to validate the datatypes, you could achieve the same thing using CFPARAM before passing the values into your CFSAVECONTENT. -- Snake -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: 21 February 2006 17:02 To: CF-Talk Subject: RE: cfsavecontent and cfqueryparam There's no way to do something like lt;cfqueryparam and then do an evaluate or something? There must be some workaround... -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 21, 2006 11:50 AM To: CF-Talk Subject: Re: cfsavecontent and cfqueryparam Nope, if you HAVE to put your SQL outside a CFQUERY tag, you have to use inline values. Make sure you're very careful about sanitizing any such values before using them, or you could be leaving yourself open to SQL injection attacks. And don't forget preserveSingleQuotes() when you dump the generated SQL into the CFQUERY tag. cheers, barneyb On 2/21/06, Russ [EMAIL PROTECTED] wrote: I am trying to optimize some queries, and as such, trying to put several 1 row insert queries into one. I am trying to use a function to generate the sql, and then just loop through each record and generate the sql I need. The issue I'm running into is that cfqueryparam is not supported outside of cfquery. Is there some way to escape it, or am I stuck with putting the sql inline with the loop? Here is an example of what I want: cfsavecontent variable=myqry set @userId=cfqueryparam cfsqltype=cf_sql_integer value=#userID# /cfsavecontent Russ -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233012 Archives: http://www.houseoffusion.com/cf_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: Google indexing
Where the link shows up in Google's results is based on the PageRank. Higher pagerank = better listing. PageRank is calculated using various and ever changing means. One of the most significant is the links in to your site from other sites, since the actual goal of Google is to track how everything is related to each other. But Google has gotten good at filtering out link swapping and other means to artifically influence the score. Similarly, Google ignores the Keyword meta tags now because of people abusing them to get high scores. The things you can reliably do to ensure a good score are have the text that is being matched in the following locations: - h1 - First paragraph after h1 - title - url (typically in the filename) Additionally, when people link to your site, or for links within your own site, make the text of the link be the key search term, especially for in-context links (as opposed to nav bars). So if someone is searching for Bob Guiney photos: a href=photos.htmlBob Guiney's photo gallery/a is probably better than Bob Guiney's photo a href=gallery.htmlgallery/a But the rules keep shifting around. As for getting stuff that has been indexed by Google already off the Google listings: http://www.google.com/webmasters/remove.html#uncache --- Kevin Graeme Cooperative Extension Technology Services University of Wisconsin-Extension -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Monday, February 20, 2006 10:54 PM To: CF-Talk Subject: OT: Google indexing Okay... do a google search for bob guiney http://www.google.com/search?q=bob+guiney His site (which I built) is the first link.. which is good. And google also lists direct links to a couple of subpages.. BGB Imagery, Bob Guiney's Online Diary, Music, etc. How does google decide what to put up there? Click popularity? Of course they can't tell when you click on something, so maybe link popularity? Anyway, I didn't notice that google was doing this until just now when Bob asked me if we c ould axe the diary link from google. My initial idea is to just use a robots.txt file to prevent the diary from even being indexed.. clearly that would solve the problem, but is it the best solution? (vent: why doesn't Mozilla Thunderbird's built in spell checker know how to spell Mozilla and Thunderbird?) Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233013 Archives: http://www.houseoffusion.com/cf_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: cfsavecontent and cfqueryparam
My reason for using cfqueryparam is because it's (supposedly) faster then just putting the values in-line... -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 21, 2006 12:41 PM To: CF-Talk Subject: RE: cfsavecontent and cfqueryparam You could generate a file with the query in it, and then cfinclude that file between the cfquery tags. But that seems like overkill. If your reason to use cfqueryparam is to validate the datatypes, you could achieve the same thing using CFPARAM before passing the values into your CFSAVECONTENT. -- Snake -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: 21 February 2006 17:02 To: CF-Talk Subject: RE: cfsavecontent and cfqueryparam There's no way to do something like lt;cfqueryparam and then do an evaluate or something? There must be some workaround... -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 21, 2006 11:50 AM To: CF-Talk Subject: Re: cfsavecontent and cfqueryparam Nope, if you HAVE to put your SQL outside a CFQUERY tag, you have to use inline values. Make sure you're very careful about sanitizing any such values before using them, or you could be leaving yourself open to SQL injection attacks. And don't forget preserveSingleQuotes() when you dump the generated SQL into the CFQUERY tag. cheers, barneyb On 2/21/06, Russ [EMAIL PROTECTED] wrote: I am trying to optimize some queries, and as such, trying to put several 1 row insert queries into one. I am trying to use a function to generate the sql, and then just loop through each record and generate the sql I need. The issue I'm running into is that cfqueryparam is not supported outside of cfquery. Is there some way to escape it, or am I stuck with putting the sql inline with the loop? Here is an example of what I want: cfsavecontent variable=myqry set @userId=cfqueryparam cfsqltype=cf_sql_integer value=#userID# /cfsavecontent Russ -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233014 Archives: http://www.houseoffusion.com/cf_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: cfsavecontent and cfqueryparam
From: Russ [mailto:[EMAIL PROTECTED] I am trying to optimize some queries, and as such, trying to put several 1 row insert queries into one. I am trying to use a function to generate the sql, and then just loop through each record and generate the sql I need. The issue I'm running into is that cfqueryparam is not supported outside of cfquery. Is there some way to escape it, or am I stuck with putting the sql inline with the loop? How about passing a list into a stored procedure and looping over the list within the stored procedure to do all your inserts? http://www.i-notions.com/articles/dynamicin/ Tango. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233015 Archives: http://www.houseoffusion.com/cf_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: cfsavecontent and cfqueryparam
How would you select from an XML document in sql server? What I really need to do is insert lets say 100k simple records such as Firstname, lastname, emailaddress Into several tables. I have it working already with a loop and doing the 100k inserts, and it runs a little slow (Although not too bad). I tried converting it to a single query and it basically timed out on me. I guess sql server could not handle the huge query like that. Would be nice to make it into a stored procedure, but I don't really know how to pass that list into SQL. How would I do it with XML? Russ -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 21, 2006 1:39 PM To: CF-Talk Subject: RE: cfsavecontent and cfqueryparam Not a bad idea. If all the inserts are into the same table, I have had good luck generating a simple xml document, passing it into a text input in a MS SQL server 2000 proc, selecting from the xml into a temp table, and then doing one insert. ~Brad How about passing a list into a stored procedure and looping over the list within the stored procedure to do all your inserts? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233017 Archives: http://www.houseoffusion.com/cf_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: Google search appliance and Cold Fusion
We have a Google Mini here and generally like it. There's a really good reference here: http://code.google.com/gsa_apis/xml_reference.html [quote] A Google search request is a simple HTTP request to the Google search engine. The search request format and options available are detailed in the Request Format section. The search results are returned in the output format specified in the search request. Currently, Google supports output results in XML and HTML format. XML formatted results give you the power to customize the display of the results through the implementation of a custom XML parser. The HTML results can be customized through the application of an XSL stylesheet to the standard XML results. [/quote] One of the things I learned from that is that while the public Google search ignores the meta keywords by default, with a properly formatted search string you can tell it to not only use keywords but how to match specific meta tags. So if you have a good meta tag scheme, you can design interfaces that do custom searches on your site that target specific pages more accurately than just content text. http://code.google.com/gsa_apis/xml_reference.html#request_meta --- Kevin Graeme Cooperative Extension Technology Services University of Wisconsin-Extension -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 29, 2005 8:49 AM To: CF-Talk Subject: Google search appliance and Cold Fusion Does anyone have any experience/recomendations/lessons learned about integrating a Google search appliance into a Cold Fusion server environment serving dozens of sites and hundreds of thousands of pages? Thanks for any info, Jerry Johnson LawyersWeekly ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233018 Archives: http://www.houseoffusion.com/cf_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
A very specific message board/forum question...
Does anyone have any recommendations for Message Boards/Forums that are CF based that are as close to being like phpBB as possible? I'm in the process of possibly being tasked to take over and redesign a site, and one of the things they've asked for is message board/forum continuity, and they're currently using phpBB. Now, the reason I want to find a CF alternative and hopefully port over their users, is because one of the things they're doing is creating lots of login type stuff sitewide, and I'm naturally going to use CFLogin and the CFLogin framework to validate users sitewide and provide security via that way, tying in session management for a shopping cart, little games, user persistence, etc, and I'd LOVE for the message board to be tied to that user persistence. I'm looking at this board www.phpbb.com and would love to hear from anyone in the CF community who has experience with a CF equivalent. Jeff ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233019 Archives: http://www.houseoffusion.com/cf_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: A very specific message board/forum question...
Jeff, AFAIK, there are none. I've looked into this several times with no luck. There's no fair comparison to most CF boards and the open source PHP boards like vBulletin or phpBB. I wish an entrepreneurial CF company would create a CF board that matched feature to feature and then some! I'd buy it. ~Che -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 21, 2006 3:08 PM To: CF-Talk Subject: A very specific message board/forum question... Does anyone have any recommendations for Message Boards/Forums that are CF based that are as close to being like phpBB as possible? I'm in the process of possibly being tasked to take over and redesign a site, and one of the things they've asked for is message board/forum continuity, and they're currently using phpBB. Now, the reason I want to find a CF alternative and hopefully port over their users, is because one of the things they're doing is creating lots of login type stuff sitewide, and I'm naturally going to use CFLogin and the CFLogin framework to validate users sitewide and provide security via that way, tying in session management for a shopping cart, little games, user persistence, etc, and I'd LOVE for the message board to be tied to that user persistence. I'm looking at this board www.phpbb.com and would love to hear from anyone in the CF community who has experience with a CF equivalent. Jeff ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233020 Archives: http://www.houseoffusion.com/cf_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: A very specific message board/forum question...
http://www.rinium.com/ is very cool. I was going to do integration with it but haven't had the time yet. Worth looking at. -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 21, 2006 3:20 PM To: CF-Talk Subject: RE: A very specific message board/forum question... Jeff, AFAIK, there are none. I've looked into this several times with no luck. There's no fair comparison to most CF boards and the open source PHP boards like vBulletin or phpBB. I wish an entrepreneurial CF company would create a CF board that matched feature to feature and then some! I'd buy it. ~Che -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 21, 2006 3:08 PM To: CF-Talk Subject: A very specific message board/forum question... Does anyone have any recommendations for Message Boards/Forums that are CF based that are as close to being like phpBB as possible? I'm in the process of possibly being tasked to take over and redesign a site, and one of the things they've asked for is message board/forum continuity, and they're currently using phpBB. Now, the reason I want to find a CF alternative and hopefully port over their users, is because one of the things they're doing is creating lots of login type stuff sitewide, and I'm naturally going to use CFLogin and the CFLogin framework to validate users sitewide and provide security via that way, tying in session management for a shopping cart, little games, user persistence, etc, and I'd LOVE for the message board to be tied to that user persistence. I'm looking at this board www.phpbb.com and would love to hear from anyone in the CF community who has experience with a CF equivalent. Jeff ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233021 Archives: http://www.houseoffusion.com/cf_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: A very specific message board/forum question...
Jeff, AFAIK, there are none. I've looked into this several times with no luck. There's no fair comparison to most CF boards and the open source PHP boards like vBulletin or phpBB. I wish an entrepreneurial CF company would create a CF board that matched feature to feature and then some! I'd buy it. ~Che Well...crappity crap crap crap. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233023 Archives: http://www.houseoffusion.com/cf_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: A very specific message board/forum question...
I just started using PHPbb on one of my sites and I am quite impressed with it. I don't see anyreason why you wouldn't be able to use the database that PHPbb uses and either import the usernames and passwords into what you're doing in CF or just feed off of the usernames and passwords directly. You could even do something where when they log into ColdFusion and they try to go to the forums that you pass the username and password into a page you create in PHP so that they are automatically logged on. Why reinvent the wheel if you got a nice performance tire ready and willing to be used. Bob ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233022 Archives: http://www.houseoffusion.com/cf_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: XOR
I now I'm real late on this one, but I used to teach people how to do text searching with boolean logic in the pre-web days. When I showed them the XOR command (nearly every computer/query language has one), I told them they would NEVER use it. It's just not a real world operator. Jevo Michael Dinowitz wrote: That is an odd one, it doesn't seem like it would be used a whole lot. I'm doing a complete review of comparisons statements in CF and it's one of the joiners allowed. Even if they're never used, I have to cover them. :) As for the bitwise xor, I'll deal with that later. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233024 Archives: http://www.houseoffusion.com/cf_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
cfforms, cfslider, hack, and double control
I'm trying to use http://www.bloginblack.de/archives/000666.cfm anyone out there use this? I really want to make it use a default value somehow. It works great, kudos to Kai Konig, but I don't want the left and right thumb buttons to be at position 0 when it loads. I'd rather have them set to some intermediate values. Any ideas? -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233025 Archives: http://www.houseoffusion.com/cf_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: A very specific message board/forum question...
http://www.rinium.com/ is very cool. I was going to do integration with it but haven't had the time yet. Worth looking at. Okay...theoretically...can you somehow tie sitewide user persistence that's managed with CF into a phpBB? What road would one wander down if one were to consider persuing such a quest? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233026 Archives: http://www.houseoffusion.com/cf_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: A very specific message board/forum question...
It isn't a PHPBB equiv, but I do think it is a strong product: ray.camdenfamily.com/projects/galleon I tended to focus on relevant features and have skipped stuff like smilies. On 2/21/06, Jeff Small [EMAIL PROTECTED] wrote: Does anyone have any recommendations for Message Boards/Forums that are CF based that are as close to being like phpBB as possible? I'm in the process of possibly being tasked to take over and redesign a site, and one of the things they've asked for is message board/forum continuity, and they're currently using phpBB. Now, the reason I want to find a CF alternative and hopefully port over their users, is because one of the things they're doing is creating lots of login type stuff sitewide, and I'm naturally going to use CFLogin and the CFLogin framework to validate users sitewide and provide security via that way, tying in session management for a shopping cart, little games, user persistence, etc, and I'd LOVE for the message board to be tied to that user persistence. I'm looking at this board www.phpbb.com and would love to hear from anyone in the CF community who has experience with a CF equivalent. Jeff ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233028 Archives: http://www.houseoffusion.com/cf_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: A very specific message board/forum question...
Last I heard, someone on the list was working on a direct Open Source port of phpbb to CF. I believe it was being called cfmbb or cfbb or something like that. Not sure what the status is or if it's being continued, but it was an idea at one point. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 21, 2006 3:08 PM To: CF-Talk Subject: A very specific message board/forum question... Does anyone have any recommendations for Message Boards/Forums that are CF based that are as close to being like phpBB as possible? I'm in the process of possibly being tasked to take over and redesign a site, and one of the things they've asked for is message board/forum continuity, and they're currently using phpBB. Now, the reason I want to find a CF alternative and hopefully port over their users, is because one of the things they're doing is creating lots of login type stuff sitewide, and I'm naturally going to use CFLogin and the CFLogin framework to validate users sitewide and provide security via that way, tying in session management for a shopping cart, little games, user persistence, etc, and I'd LOVE for the message board to be tied to that user persistence. I'm looking at this board www.phpbb.com and would love to hear from anyone in the CF community who has experience with a CF equivalent. Jeff ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233027 Archives: http://www.houseoffusion.com/cf_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: A very specific message board/forum question...
From: Jeff Small [mailto:[EMAIL PROTECTED] I'm looking at this board www.phpbb.com and would love to hear from anyone in the CF community who has experience with a CF equivalent. There really aren't any equivalents to the big PHP based forum apps. FuseTalk is a CF based forum app as is Galleon (Ray Camden's project). In my opinion FuseTalk lacks the familiar feel that the PHP apps offer and hasn't really peaked my interest (for a variety of reasons, one of which is cost). Galleon, is a simple, no frills, no BS app which is pretty slick; but again, not close to PHPBB in terms of that familiar look, feel, and feature set. Your best bet is to interface with one of the PHP apps or join the CFBB team and help finish that project... oh wait, that is dead in the water. :-) I have interfaced with vBulletin (another PHP forum app) and found it pretty easy to do. So many people ask this question which usually results in a group of people saying they want to create a CF based app that can rival the PHP ones, it has yet to happen. Tango. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233029 Archives: http://www.houseoffusion.com/cf_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: A very specific message board/forum question...
I just started using PHPbb on one of my sites and I am quite impressed with it. I don't see anyreason why you wouldn't be able to use the database that PHPbb uses and either import the usernames and passwords into what you're doing in CF or just feed off of the usernames and passwords directly. You could even do something where when they log into ColdFusion and they try to go to the forums that you pass the username and password into a page you create in PHP so that they are automatically logged on. Why reinvent the wheel if you got a nice performance tire ready and willing to be used. Okay, okay...I'm listeningyou've got my attention. Are you currently doing any of this? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233030 Archives: http://www.houseoffusion.com/cf_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: A very specific message board/forum question...
Even easier than passing a username and password would be to generate a session key and set the cookie automatically. PHPBB just generates the key and stores in a cookie and stores it in the database. I've looked into making some CF code to do this, but we're currently having problems with PHPBB on the site we're using and so it hasn't been worth my time since we may not stick with it. The only thing to keep in mind here is that you need to find everywhere on PHPBB where they can control their usernames/passwords and remove those links or point them to your CF pages so that they can't change their PHPBB usernames/passwords to stuff different than your normal site because that will just get confusing. The other way to come at it would be to rewrite the php portions to login based on the scheme you're using on the CF side. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 21, 2006 2:25 PM To: CF-Talk Subject: Re: A very specific message board/forum question... I just started using PHPbb on one of my sites and I am quite impressed with it. I don't see anyreason why you wouldn't be able to use the database that PHPbb uses and either import the usernames and passwords into what you're doing in CF or just feed off of the usernames and passwords directly. You could even do something where when they log into ColdFusion and they try to go to the forums that you pass the username and password into a page you create in PHP so that they are automatically logged on. Why reinvent the wheel if you got a nice performance tire ready and willing to be used. Bob ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233031 Archives: http://www.houseoffusion.com/cf_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: A very specific message board/forum question...
Why does it *have* to be CF? Seems like if a particular tool's perfect for the job, it should be used. PHP isn't that big of a deal to learn if you're proficient in CF. Jeff Small wrote: Jeff, AFAIK, there are none. I've looked into this several times with no luck. There's no fair comparison to most CF boards and the open source PHP boards like vBulletin or phpBB. I wish an entrepreneurial CF company would create a CF board that matched feature to feature and then some! I'd buy it. ~Che Well...crappity crap crap crap. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233032 Archives: http://www.houseoffusion.com/cf_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: A very specific message board/forum question...
aha! disregard last message. :) Jeff Small wrote: http://www.rinium.com/ is very cool. I was going to do integration with it but haven't had the time yet. Worth looking at. Okay...theoretically...can you somehow tie sitewide user persistence that's managed with CF into a phpBB? What road would one wander down if one were to consider persuing such a quest? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233033 Archives: http://www.houseoffusion.com/cf_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: A very specific message board/forum question...
Here's an idea, if you really need both apps and both sessions... 0) Add a column to phpbb user table which stores the CF-app's user table's ID (say, RealUserID) 1) Make the phpbb login form page redirect you to a CF login page for your regular site 2) log in there, and redirect to phpbb/CrossSiteLogin.php 3) you should have cfid and cftoken on all requests now, so just make CrossSiteLogin.php do a CFHTTP-like request (in php) using cfid and cftoken, to your website, calling GetUserID.cfm (which just spits out #session.userid#) and then set it automatically in the php session The only thing we're missing is some sort of session stickiness. I guess you can embed an img src=image.cfm in your php templates to keep the cf session alive while on phpbb - -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 21, 2006 3:31 PM To: CF-Talk Subject: Re: A very specific message board/forum question... I just started using PHPbb on one of my sites and I am quite impressed with it. I don't see anyreason why you wouldn't be able to use the database that PHPbb uses and either import the usernames and passwords into what you're doing in CF or just feed off of the usernames and passwords directly. You could even do something where when they log into ColdFusion and they try to go to the forums that you pass the username and password into a page you create in PHP so that they are automatically logged on. Why reinvent the wheel if you got a nice performance tire ready and willing to be used. Okay, okay...I'm listeningyou've got my attention. Are you currently doing any of this? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233035 Archives: http://www.houseoffusion.com/cf_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: cfsavecontent and cfqueryparam
How would you select from an XML document in sql server? We use MS SQL Server 2000. Here is an example I just ripped out of my code and pasted in. (Sorry it is kind of long-- didn't have time to trim it down) Pass this xml string into the proc and the table variable is filled with a record corresponding to each element in the XML. Then a single insert is done. ROOTbank_account_transaction bank_account_transaction_id=00b42916-c5f5-4bc5-9ca2-59d6c7e56a19 bank_account_id=9ee2b725-8122-4cdf-8b1b-f512b6a5e1d2 bank_account_sub_id=4bf56758-459e-4c0e-a148-99f9915716ba full_order_number=0041351NLS05 order_id=4cd3d8c4-1f4f-4d78-aa60-dbc6bac4b2d5/bank_account_transacti on bank_account_transaction_id=8422f725-1eab-4139-8052-75b1191ff5e0 bank_account_id=9ee2b725-8122-4cdf-8b1b-f512b6a5e1d2 bank_account_sub_id=4bf56758-459e-4c0e-a148-99f9915716ba full_order_number=0041351NLS05 order_id=4cd3d8c4-1f4f-4d78-aa60-dbc6bac4b2d5/bank_account_transacti on bank_account_transaction_id=31770dc3-fc98-453a-b68c-16a9677c7108 bank_account_id=9ee2b725-8122-4cdf-8b1b-f512b6a5e1d2 bank_account_sub_id=4bf56758-459e-4c0e-a148-99f9915716ba full_order_number=0041545NLS05 order_id=af911a99-c460-49a3-ace8-fd429c68e552//ROOT CREATE PROCEDURE dbo.p_bank_account_transaction_mass_update @output_message AS varchar(255) OUTPUT, @executer_entity_id AS uniqueidentifier, @executer_entity_hierarchy_id AS uniqueidentifier, @executer_company_id AS uniqueidentifier, @xml_transaction_list AS text, @u_bank_account_transaction_status_type AS uniqueidentifier AS SET NOCOUNT ON DECLARE @rtn AS int DECLARE @xmlDoc integer DECLARE @tran_count AS int DECLARE @getDate AS datetime SET @getDate = getDate() SET @tran_count = @@trancount DECLARE @tmp_transaction_list TABLE ( bank_account_transaction_id uniqueidentifier PRIMARY KEY, new_bank_account_transaction_id uniqueidentifier DEFAULT newID(), bank_account_id uniqueidentifier, bank_account_sub_id uniqueidentifier, order_id uniqueidentifier, change_reason varchar(500), u_id_change_reason uniqueidentifier, u_bank_account_transaction_status_type uniqueidentifier) - -- IF TRANASCTIONS PASSED VIA XML - EXEC sp_xml_preparedocument @xmlDoc OUTPUT, @xml_transaction_list INSERT INTO @tmp_transaction_list (bank_account_transaction_id, bank_account_id, bank_account_sub_id, order_id, change_reason, u_id_change_reason) SELECT bank_account_transaction_id, bank_account_id, bank_account_sub_id, order_id, change_reason, u_id_change_reason FROM OPENXML(@xmlDoc, N'/ROOT/bank_account_transaction') WITH (bank_account_transaction_id uniqueidentifier '@bank_account_transaction_id', bank_account_id uniqueidentifier '@bank_account_id', bank_account_sub_id uniqueidentifier '@bank_account_sub_id', order_id uniqueidentifier '@order_id', change_reason varchar(500) '@change_reason', u_id_change_reason uniqueidentifier '@u_id_change_reason') EXEC sp_xml_removedocument @xmlDoc BEGIN TRANSACTION INSERT INTO bank_account_transaction_status ( bank_account_transaction_status_id, bank_account_transaction_id, u_bank_account_transaction_status_type, u_id_change_reason, change_reason, datetime_modified, entity_id_modified ) SELECT newid(), tmp.bank_account_transaction_id, @u_bank_account_transaction_status_type, tmp.u_id_change_reason, tmp.change_reason, @getDate, @executer_entity_id FROM @tmp_transaction_list tmp SET @rtn = @@ERROR IF @rtn 0 BEGIN IF @tran_count = 0 ROLLBACK TRANSACTION SET @output_message = 'ERROR ' +CAST(@rtn AS varchar(15))+ ' OCCURRED WHILE INSERTING BANK_ACCOUNT_TRANSACTION_STATUS RECORD ' RETURN @rtn END IF @tran_count = 0 COMMIT TRANSACTION SET @output_message = 'MODIFY SUCCESSFUL ' RETURN 0 GO ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233036 Archives: http://www.houseoffusion.com/cf_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: A very specific message board/forum question...
Not directly, but I got pretty well aquainted with it trying to install it, never installed PHP directly and ran into a few issues. I have done what I have talked about with other systems, ASP comes to mind. Run any questions you have, I'm sure we can figure out how to make it work without you having to find a new solution then run into a headache of moving data. Bob ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233037 Archives: http://www.houseoffusion.com/cf_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
ARgh! Display XML
I've got a form posting out to another server and returning an XML response. This: cfoutput#cfhttp.filecontent#/cfoutput Will output this: ?xml version=1.0 encoding=iso-8859-1? response successful1/successful modetest/mode result policyid12912006022116/policyid tripcost2000/tripcost premium21.8/premium commission4.36/commission /result /response I need to display the policyid from the above further down my CF page, so I parse the above and set a variable results: cfset results=XMLParse(cfhttp.filecontent) and then try to output that further down the page: #results.response.result.policyid# But what I get is [EMAIL PROTECTED] for the above output instead of the expected 12912006022116 Suggestions? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233040 Archives: http://www.houseoffusion.com/cf_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: Server Monitoring
We've been using it for a while, and I haven't noticed any load from it... I'm sure there is some overhead, but it's negligible. Russ -Original Message- From: Ken [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 21, 2006 5:04 PM To: CF-Talk Subject: Server Monitoring Hi. Has anybody used this coldfusion monitoring tool here: http://www.seefusion.com If so, can you tell if it creates a load on the server, if at all. I'll appreciate any feedback about it. Thanks, K ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233041 Archives: http://www.houseoffusion.com/cf_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: ARgh! Display XML
Do a cfdump on 'results' and see what you get? -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 21, 2006 2:03 PM To: CF-Talk Subject: ARgh! Display XML I've got a form posting out to another server and returning an XML response. This: cfoutput#cfhttp.filecontent#/cfoutput Will output this: ?xml version=1.0 encoding=iso-8859-1? response successful1/successful modetest/mode result policyid12912006022116/policyid tripcost2000/tripcost premium21.8/premium commission4.36/commission /result /response I need to display the policyid from the above further down my CF page, so I parse the above and set a variable results: cfset results=XMLParse(cfhttp.filecontent) .and then try to output that further down the page: #results.response.result.policyid# But what I get is [EMAIL PROTECTED] for the above output instead of the expected 12912006022116 Suggestions? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233042 Archives: http://www.houseoffusion.com/cf_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: ARgh! Display XML
#results.response.result.policyid# But what I get is [EMAIL PROTECTED] for the above output instead of the expected 12912006022116 *-*--*-*-*-*-*-*-*-*-* The problem is that results.response.result.policyid is a complex variable-- it is a struct. What you want is: #results.response.result.policyid.XmlText# XmlText is a key in the policyid struct. Of course this syntax assumes that you will never have more than one response, result, or policyid tag with a sibling of the same name. If your XML gets any more complicated, xpaths are great for pulling out the nodes you want. ~Brad ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233043 Archives: http://www.houseoffusion.com/cf_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: A very specific message board/forum question...
Raymond Camden wrote: It isn't a PHPBB equiv, but I do think it is a strong product: ray.camdenfamily.com/projects/galleon I tended to focus on relevant features and have skipped stuff like smilies. That's the kinda crap that makes phpBB popular. There are two things I'd add to galleon if I found the time.. #1 - implement BBML via the BBML UDF I wrote based on The Depressed Press's BBML custom tag. #2 - implement private messaging. And I may get around to it soon. =) I'm thinking of encrypting the code and calling it RapidGalleon ;) Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233044 Archives: http://www.houseoffusion.com/cf_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: A very specific message board/forum question...
Heh, I know - everyone bugs me to add BBML, which I think is disgusting. ;) But yes, if you write it, I'll do a quick QA and add it - reluctantly - to Galleon. On 2/21/06, Rick Root [EMAIL PROTECTED] wrote: Raymond Camden wrote: It isn't a PHPBB equiv, but I do think it is a strong product: ray.camdenfamily.com/projects/galleon I tended to focus on relevant features and have skipped stuff like smilies. That's the kinda crap that makes phpBB popular. There are two things I'd add to galleon if I found the time.. #1 - implement BBML via the BBML UDF I wrote based on The Depressed Press's BBML custom tag. #2 - implement private messaging. And I may get around to it soon. =) I'm thinking of encrypting the code and calling it RapidGalleon ;) Rick -- === Raymond Camden, Director of Development for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : ray.camdenfamily.com Yahoo IM : cfjedimaster My ally is the Force, and a powerful ally it is. - Yoda ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233045 Archives: http://www.houseoffusion.com/cf_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
Realbasic and CFC's
Hi There, I am not sure if this is the right place to put forward this quesiton, if iam in the wrong place please excuse me and can you let me know the right url please. I dont have any problems in creating an instance of the webservice using realbasic, but when ever i try to call the methods(cffuncton), the realbasic software gives an exception telling an XML Exception has occurred This is the first time i am using realbasic, does the soapmethod() understand the xml sent from coldfusion cfc? This is most urgent, can some one help me or send me some leads please Thanks vikram Sent via the WebMail system at seetrybuy.co.uk ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233046 Archives: http://www.houseoffusion.com/cf_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: A very specific message board/forum question...
Che Vilnonis wrote: I wish an entrepreneurial CF company would create a CF board that matched feature to feature and then some! I'd buy it. I started to with cfmbb (www.cfmbb.org)... but I went down a path I wasn't prepared to go down (making it multilingual) which caused the code to be REALLY hideous. It actually does support some of the phpbb features, but it's so very far from being good. I just fixed the BBML support in it. Honestly, if I decided i wanted to go back to working on a message board, I'd probably scrap cfmbb and use Ray's Galleon Forums as the base product. Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233047 Archives: http://www.houseoffusion.com/cf_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: A very specific message board/forum question...
I am looking to rewrite our Aftershock Forum using CFC's, see: http://www.aftershockweb.net/forums/ and would like to implement the most important phpBB features as shown on: http://www.phpbb.com/features.php. What are the most important features you are looking for? You can also post these feature requests on my features request forum at: http://www.aftershockweb.net/forums/threads.cfm/ForumId/19 (you can login as anonymous, or sign up for an account if you would like to subscribe to the thread). Also, I would invite others to be involved in the project. I would be willing to offer free licensing to those who make significant contributions, though we would need to move this off CF-Talk, and probably into a private forum (which we already support). Thank you, Aftershock Web Design, Inc. by: Stan Winchester President/Developer [EMAIL PROTECTED] http://www.aftershockweb.com/ Phone 503-244-3440 Jeff, AFAIK, there are none. I've looked into this several times with no luck. There's no fair comparison to most CF boards and the open source PHP boards like vBulletin or phpBB. I wish an entrepreneurial CF company would create a CF board that matched feature to feature and then some! I'd buy it. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233048 Archives: http://www.houseoffusion.com/cf_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: A very specific message board/forum question...
Get (and pay for) vBulletin - another php app, but heads and shoulders above phpBB. I'm sure there must be data migration scripts from php. Use the vBulletin database as your site's user base. You can authenticate user logins from CF against the vBulletin user database and you can take registrations and create new users within the vBulletin database from your CF apps. There's likely little that you'd want in a forum that isn't already in vBulletin. The only thing you'll probably want to do is skin it, which is fairly trivial. - Original Message - From: Jeff Small [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, February 21, 2006 1:53 PM Subject: Re: A very specific message board/forum question... Not directly, but I got pretty well aquainted with it trying to install it, never installed PHP directly and ran into a few issues. I have done what I have talked about with other systems, ASP comes to mind. Run any questions you have, I'm sure we can figure out how to make it work without you having to find a new solution then run into a headache of moving data. Yeah, after reading some of the responses here, and poking around, it actually doesn't seem like it's going to be that hard to do. I'm going to go off and ponder this and see what everyone else wants to do. It might be a decision that's out of my hands at this point. Thanks for all the quick replies and great info. Appreciate it all. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233049 Archives: http://www.houseoffusion.com/cf_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: A very specific message board/forum question...
Several of the links got trunctated so here they are again: http://www.aftershockweb.net/forums/ http://www.phpbb.com/features.php http://www.aftershockweb.net/forums/threads.cfm/ForumId/19 I am looking to rewrite our Aftershock Forum using CFC's, see: http://www.aftershockweb.net/forums/ and would like to implement the most important phpBB features as shown on: http://www.phpbb. com/features.php. What are the most important features you are looking for? You can also post these feature requests on my features request forum at: http://www.aftershockweb.net/forums/threads.cfm/ForumId/19 (you can login as anonymous, or sign up for an account if you would like to subscribe to the thread). Also, I would invite others to be involved in the project. I would be willing to offer free licensing to those who make significant contributions, though we would need to move this off CF-Talk, and probably into a private forum (which we already support). Thank you, Aftershock Web Design, Inc. by: Stan Winchester President/Developer [EMAIL PROTECTED] http://www.aftershockweb.com/ Phone 503-244-3440 Jeff, AFAIK, there are none. I've looked into this several times with no luck. There's no fair comparison to most CF boards and the open source PHP boards like vBulletin or phpBB. I wish an entrepreneurial CF company would create a CF board that matched feature to feature and then some! I'd buy it. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233050 Archives: http://www.houseoffusion.com/cf_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: Google indexing
Hi Rick, From Google: http://www.google.com/technology/ A couple of useful commands in a Google search: index:www.mysite.com Shows which pages Google has indexed, if any, and is a way to see indicate whether a site may have been banned. links:www.mysite.com Shows how many back links you have. Take a look at the page your link sits on. If it has a low page rank the link is actually hurting your rankings, not helping. (These commands also work on MSN and Yahoo.) A useful way to see if you have bad links is an undocumented search command on Yahoo: linkdomain:mydomain.com This will show you all Yahoo back links to any page in your site. A useful way of finding out if you have links on good pages. Also, download the Google tool bar http://www.google.co.uk/intl/en/options/ Google Tools: Toolbar This will show you the page rank on the page you are currently browsing. Don't even bother posting your link to a page if you see it has a PR below 3. Be very careful about following dodgey techniques that may get you a quick ranking until Google sees the cheat and may even bar the site completely. It can take months to get a site listed once it has been barred. Don't over do keyword useage hoping to score points. Get the keywords into key positions, but don't drown your page in them. High scoring positions for keywords are title h1-h6 b i ul ol. first and last words read be the SE on your page. To see how the SE sees your page a useful tool is http://www.goodkeywords.com/ which is also pretty good for keyword research. Keyword density is key. No more than 8 words in your page title, no more than 248 characters in your meta (or some search engines will reject your submission altogether). A pretty good piece of software to research and see how you are doing in rankings and back links is www.webceo.com (there is even a free version). SEO isn't everything. It is possible to spend huge amounts of time on SEO (and money) and get nowhere (in highly competitive markets) for a very long time and it may be as well to spend on Google Adwords to gain traffic either while you are waiting for SEO positioning, or even ditching SEO completely. First and foremost to get a good ranking is to have a site with good unique content that is easily navigable and easy to read. If you need any more pointers, or even my SEO consultancy, please drop me an email off list. Hope this helps, and good luck! Jenny -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: 21 February 2006 04:54 To: CF-Talk Subject: OT: Google indexing Okay... do a google search for bob guiney http://www.google.com/search?q=bob+guiney His site (which I built) is the first link.. which is good. And google also lists direct links to a couple of subpages.. BGB Imagery, Bob Guiney's Online Diary, Music, etc. How does google decide what to put up there? Click popularity? Of course they can't tell when you click on something, so maybe link popularity? Anyway, I didn't notice that google was doing this until just now when Bob asked me if we c ould axe the diary link from google. My initial idea is to just use a robots.txt file to prevent the diary from even being indexed.. clearly that would solve the problem, but is it the best solution? (vent: why doesn't Mozilla Thunderbird's built in spell checker know how to spell Mozilla and Thunderbird?) Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233051 Archives: http://www.houseoffusion.com/cf_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: A very specific message board/forum question...
Rick Root wrote: I started to with cfmbb (www.cfmbb.org)... but I went down a path I wasn't prepared to go down (making it multilingual) which caused the code to be REALLY hideous. why? what were you doing that made i18n so hideous? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233052 Archives: http://www.houseoffusion.com/cf_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: Source Control Choices
My company uses Perforce, which has a little learning curve but is a very cool product that supports everything you are looking for and more. Well worth a look, but unlike CVS/SVN, it is a commercial product. What we are looking for is something that makes the release process from server to server nice and easy, but also allows us to branch an app out of the way so that shared code can move past it in test and go live before the original code does (we have clients who insist on delaying go live dates :-() We can't really have local dev machines due to the sheer amount of code (~3mil lines) and applications (~ 50)we are controlling. Any ideas on how we might set something up that will let us do this? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233053 Archives: http://www.houseoffusion.com/cf_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: A very specific message board/forum question...
Paul Hastings wrote: Rick Root wrote: I started to with cfmbb (www.cfmbb.org)... but I went down a path I wasn't prepared to go down (making it multilingual) which caused the code to be REALLY hideous. why? what were you doing that made i18n so hideous? well it's just ugly, but the worst part is that since the language is extracted into message files, it's very hard to tell in the code where things are being output. Makes it very complex, because rather than: cfoutputYou have been successfully unsubscribed/cfoutput you get: cfoutput#Application.resourceBundle.getResource(message_topic_unsubscribe_success)#/cfoutput Plus, I went down the road of building it so that you could have multiple completely separate message boards in one database... and looking back, I see that's REALLY unnecessary. But what it did was require that all of my queries have an extra bit in the where clause, etc. Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233054 Archives: http://www.houseoffusion.com/cf_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: A very specific message board/forum question...
Raymond Camden wrote: Heh, I know - everyone bugs me to add BBML, which I think is disgusting. ;) But yes, if you write it, I'll do a quick QA and add it - reluctantly - to Galleon. I accept your challenge, Jedi. Actually, it's very simple to implement... I've already done and here's an example: http://www.opensourcecf.com/forums/messages.cfm?threadid=8ED431FF-AFAE-691A-CF53BC26B35FF3E0 Took about 10 minutes.. of course, there are a few additional things that would need to be done.. like making BBML an administrative option, and possibly a post-by-post option. so I'll work on that stuff tonight and finish it for tomorrow =) Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233055 Archives: http://www.houseoffusion.com/cf_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: A very specific message board/forum question...
I knew you'd pop in here sooner or later paul :) It's probably a matter of that being my first foray into the resource bundle, and not really knowing what I was doing. CFMBB was also my first attempt at a CFC-based application... I've learned a bit about things to do and things not to do, and you just taught me one thing about cleaning stuff up. Like var scoping the resource bundle inside the component so make the code easier to read.. that makes sense. even cfset var getResource = application.resourceBundle.getResource which would let me do #getResource(blah)# inside my component, right? That'd make things easier and prettier. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233058 Archives: http://www.houseoffusion.com/cf_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: A very specific message board/forum question...
Ray, Allow me to submit my solution to the Challenge. http://www.opensourcecf.com/forums/galleon_1_5_bbml_changes.zip Here's an example thread with all the BBML in use, along with a description of the changes made is here: http://www.opensourcecf.com/forums/messages.cfm?threadid=8ED431FF-AFAE-691A-CF53BC26B35FF3E0 Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233065 Archives: http://www.houseoffusion.com/cf_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
Need help - OBDC Timeout
Appreciate everyone help me to solve this problem. Recently our server (Window 2003, MX6.1) occur ODCB Timeouts and unresponsive requests. I have updated our server with lastest hotfix but still get this error. --- The description for Event ID ( 0 ) in Source ( ColdFusion MX ODBC Server ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: ColdFusion MX ODBC [EMAIL PROTECTED],ErrorCode=3059,ErrorMessage=The specified data source is not defined.,ClientHost=127.0.0.1,Session=21564. Rgrd Ang ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233066 Archives: http://www.houseoffusion.com/cf_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: A very specific message board/forum question...
As a general FYI to all (all who care about Galleon), I'm going to try to get this into Galleon sometime this week or next. It may be delayed a bit since I'll be off for Mardi Gras. On 2/21/06, Rick Root [EMAIL PROTECTED] wrote: Ray, Allow me to submit my solution to the Challenge. http://www.opensourcecf.com/forums/galleon_1_5_bbml_changes.zip Here's an example thread with all the BBML in use, along with a description of the changes made is here: http://www.opensourcecf.com/forums/messages.cfm?threadid=8ED431FF-AFAE-691A-CF53BC26B35FF3E0 Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233067 Archives: http://www.houseoffusion.com/cf_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
Is there a better way to do this?
I'm outputting a shipping option form from a cfc. The display table depends on a few things and it causes me to have to output the form in two different places. This works but I didnt know if someone has a better alt. cffunction cfargument. cfset var shipoptionform = cfsavecontent variable=shipoptionform extremely long form, with if/elses here. /cfsavecontent td #shipoptionform# /td and it goes somewhere else in here, depends on a cfif td #shipoptionform# /td Thanks, Will ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233068 Archives: http://www.houseoffusion.com/cf_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: Is there a better way to do this?
From: Will Tomlinson [mailto:[EMAIL PROTECTED] I'm outputting a shipping option form from a cfc. Will, is that a typo? You're outputting from a CFC! BLASPHEMY! :-) ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233069 Archives: http://www.houseoffusion.com/cf_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: embedding audio and playing with javascript
so, I'd like to add optional audio alerts to my chat app... and I did that using the embed tag and just had the javascript play the sound when appropriate. I used .au files for the audio. Some people surfed in and got the quicktime plugin alert because they were using mozilla and didn't have quicktime installed. I know *I* would find that to be obnoxious. I was thinking that using a flash movie to play the sounds might work better.. more likely to be installed. Javascript can cause actions to occur in flash movies, right? I've used actionscript to call javascript functions on a page before, but never used javascript to trigger an event in the flash movie. Ultimately, I'd just like a little 1x1 flash movie that could play 2-3 sounds.. which would be configurable via url parameter to the flash movie itself... and then allow javascript to play the different sounds by calling some kind of actionscript method... playSound(1) playsound(2) etc. Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233070 Archives: http://www.houseoffusion.com/cf_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 and SQL2005
According to Microsoft you would need a CAL for each web user (as they are technically running queries on your database). Personally I think this is ridiculous, but this is MS's official stance. So unless you have an intranet, I'm not sure if you can get away with CAL licensing. Russ -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 21, 2006 9:22 PM To: CF-Talk Subject: Re: coldfusion and SQL2005 Seems like for small intranets(that out grow the needs of the Express edition) that the CAL per actual user would come out a lot cheaper than buying the per processor licensing. On 2/16/06, Dave Watts [EMAIL PROTECTED] wrote: In any case, the Dell rep is wrong, wrong, wrong. This comes up frequently on the list; you either need one CAL per actual user, or a per-processor license which supports any number of users. For most web applications, a per-processor license is cheaper. All of this is posted quite clearly on microsoft.com. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233071 Archives: http://www.houseoffusion.com/cf_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 and SQL2005
Seems like for small intranets(that out grow the needs of the Express edition) that the CAL per actual user would come out a lot cheaper than buying the per processor licensing. That could very well be true. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233072 Archives: http://www.houseoffusion.com/cf_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