Re: Is time for a change?
I moved a client to Hostek from Newtek/Chrystaltech earlier this year and it has been a big improvement. On Fri, Nov 7, 2014 at 2:15 PM, Rick Eidson cfh...@kchost.net wrote: Anyone using Hostek? I have been with them for. well a long time. But in the last year it seems there have been more problems than ever. I really hate the idea of moving all my clients but I am wondering if in the long run will I be better off. Any thoughts? Rick ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359571 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFGrid filter stops working after move from CF10 to CF11
We have a CF app that uses a CF_GRID with some filters to allow limiting the data retrieved. After moving the app from a host running CF10 to another host running CF11, the filters stopped working even though the other grid functions did not - grid still display data correctly and clicking column headers correctly sorts the grid. This is the contents of the cfgrid tag: cfgrid format=html name=pilotGrid pagesize=10 autowidth=yes selectmode=row appendKey=yes href=index.cfm?fuseaction=dsp_adm-pilot-detail hrefKey=userid bind=cfc:pilot_search.getPilots({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection}, '#attributes.pil_email#', '#attributes.pil_lname#', '#attributes.pil_n_number#') The bind parameter specifies a function, getPilots, in pilot_search.cfc. It passes 3 attributes/parameters to the function which are the contents of the 3 text filters - pil_email, pil_lname, pil_n_number. The function contains a query to retrieve the requested data including WHERE clauses based on the filter text entered. This is the content of the function and query contained in pilot_search.cfc: cffunction name=getPilots access=remote returntype=struct cfargument name=page required=true / cfargument name=pageSize required=true / cfargument name=gridsortcolumn required=true / cfargument name=gridsortdirection required=true / cfargument name=pil_email type=string required=no default= / cfargument name=pil_lname type=string required=no default= / cfargument name=pil_n_number type=string required=no default= / cfif arguments.gridsortcolumn eq cfset arguments.gridsortcolumn = pil_email / cfset arguments.gridsortdirection = asc / /cfif cfquery name=pilots datasource=hope select userid, pil_n_number, pil_email, pil_lname, pil_fname, pil_password, last_login from pilots where 0=0 and pil_email like cfqueryparam cfsqltype=cf_sql_varchar value=%#arguments.pil_email#% and pil_lname like cfqueryparam cfsqltype=cf_sql_varchar value=%#arguments.pil_lname#% and pil_n_number like cfqueryparam cfsqltype=cf_sql_varchar value=%#arguments.pil_n_number#% order by #arguments.gridsortcolumn# #arguments.gridsortdirection# /cfquery cfreturn queryconvertforgrid(pilots, page, pagesize) / /cffunction Does anyone know why the WHERE clauses in the query appear to be ignored when running the app with CF11 but work correctly with CF10? Or does anyone have a suggestion of how to best debug this? I can't seem to figure out how to view the contents of the 3 arguments used in the WHERE clauses to see why they might be being ignored or why the result set is not limited by the filters on CF11. Any insight or suggestions appreciated. Regards, Stephen ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358960 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFGrid filter stops working after move from CF10 to CF11
On Tue, Jul 22, 2014 at 1:34 PM, Andrew Scott andr...@andyscott.id.au wrote: where 0 = 0 looks like its obsolete in that query, in other words it shouldn't be needed if you have no if statements there. As you said it works on ColdFusion 10, what would happen if you removed the 0 = 0 or replaced it with 1 = 1? There were originally if statements checking each filter value for existence before adding to the WHERE clause which explains why the 0 = 0 was there. I tried removing the 0 = 0 as well as replacing it with 1 = 1 and the behaviour remained the same. When you say is ignored, are you saying records are returning or no records are being returned? You also don't indicate whether you have an error, so we can assume that what is calling this is working to some degree with records in the grid? When I say is ignored, I mean that if a value is entered in one or more of the filter fields, the result set is the same as if there were no WHERE clause at all. There is no error that I'm seeing. So yes, records are successfully populating the grid, there's just no longer an ability to limit the number of rows returned based on the filter criteria. Also there is a huge push to remove any UI tags from Application code, it might pay to think about moving away from the likes of the current CF UI stuff. I can understand this but I'm primarily interested at the moment with getting the previously working functionality back before I start looking at implementing a replacement. Thanks for your suggestions. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358963 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFGrid filter stops working after move from CF10 to CF11
On Tue, Jul 22, 2014 at 1:38 PM, John M Bliss bliss.j...@gmail.com wrote: Here's the official replacement for cfgrid. Double-quotes because there're many way to replace cfgrid...this is just one suggestion. https://github.com/cfjedimaster/ColdFusion-UI-the-Right-Way/blob/master/chapters/cfgrid/index.md Thanks, John. That looks like an interesting approach. I will definitely check into that if I can't get this issue resolved fairly quickly. Regards, Stephen ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358964 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFGrid filter stops working after move from CF10 to CF11
On Tue, Jul 22, 2014 at 2:01 PM, Maureen mamamaur...@gmail.com wrote: On Tue, Jul 22, 2014 at 1:08 PM, Stephen Hait stephenh...@gmail.com wrote: Or does anyone have a suggestion of how to best debug this? I can't seem to figure out how to view the contents of the 3 arguments used in the WHERE clauses to see why they might be being ignored or why the result set is not limited by the filters on CF11. I would dump the argument scope to see if the arguments are actually being set. You might also use a variable and build your query are a Thanks, Maureen! You helped be figure out how to see what the values of the arguments were. I dumped the arguments scope to a file and found that the three arguments I am passing into the function for filters were showing as [empty string] when using CF11 but were displaying as expected in CF10. Apparently something is different in CF11 when it comes to passing additional arguments/parameters to a .CFC to serve as filters for the data grid. Any idea what has changed since CF10 or how to deal with this? Thanks, Stephen ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358966 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFGrid filter stops working after move from CF10 to CF11
On Tue, Jul 22, 2014 at 3:04 PM, Andrew Scott andr...@andyscott.id.au wrote: You could check your Chrome developer tools, to then see what ColdFusion via its Ajax / JS stuff is actually sending across as parameters as well. This would help to see what is actually being passed. Andrew, That's a good suggestion, too. With Chrome developer tools and inspecting pilot_search.cfc, when using CF10, under Headers, Query String Parameters, it reports argumentCollection which includes a list of all the arguments and values passed from the CFGRID tag. When using CF11, under Headers, Query String Parameters, there is no argumentCollection item displayed. Instead, the four main built-in CFGRID arguments are each displayed on separate lines along with their values - page, pagesize, gridsortcolumn, gridsortdirection. I'm not sure what this means but it does seem to indicate that in CF11, the 3 additional arguments are not making it to the .cfc to be used there using the method that accomplishes this in CF10. If I can't get this sorted out soon, I may see if simply moving our app to a CF10 instance would resolve this for now. I could then concentrate on a longer term fix before CF10 is no longer supported. Thanks, Stephen ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358969 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFGrid filter stops working after move from CF10 to CF11
On Tue, Jul 22, 2014 at 4:10 PM, Andrew Scott andr...@andyscott.id.au wrote: Stephen, Is this what you're experiencing? https://forums.adobe.com/thread/1490328 Andrew, I don't think this is the same problem but it might be related. I had not noticed any javascript errors. Just to test, removed 2 of the 3 arguments leaving just a single argument being passed to the .CFC and referenced there. I still did not see the argument getting passed and a dump of the arguments scope still showed [empty string] as the value of the single argument, even though I entered a value. Thanks, Stephen ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358971 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFGrid filter stops working after move from CF10 to CF11
On Tue, Jul 22, 2014 at 4:40 PM, Maureen mamamaur...@gmail.com wrote: I know some things have changed with scope over the last few versions but not sure what changed when. Local scope for functions was added at some point. Make sure you are scoping all variables and declaring any that need to be with var. Thanks, Maureen. I believe I am explicitly scoping all variables in this case. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358973 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFGrid filter stops working after move from CF10 to CF11
On Tue, Jul 22, 2014 at 4:51 PM, Maureen mamamaur...@gmail.com wrote: I didn't see scopes on the variables in your return statement. cfreturn queryconvertforgrid(pilots, page, pagesize) / Not sure if that matters, but I would scope them just in case. I'm not sure how to correctly scope pilots. It's the name of the query but if it try query.pilots or var.pilots the grid doesn't receive any data. I was able to change page and pagesize to arguments.page and arguments.pagesize without causing any noticeable problems but also without resolving the main issue. If you know how I should correctly scope the query name, pilots, let me know and I can see if that makes any difference. Regards, Stephen ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358976 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFGrid filter stops working after move from CF10 to CF11
On Tue, Jul 22, 2014 at 5:06 PM, Andrew Scott andr...@andyscott.id.au wrote: It will be in the variables scope for the query, but as this is an issue with the Ajax sending rather than receiving I doubt that is the issue. Thanks, Andrew - I confused var variables. And none of that scoping of the return values made any difference. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358978 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: need a host
Just switched a client from Newtek to Hostek and everyone's a lot happier. CF11, though, not sure about CF9. On Sun, Jul 20, 2014 at 5:09 PM, Matthew Smith chedders...@gmail.com wrote: not newtek, no hostmedia.co.uk(no mssql), no viviotek. Any suggestions? Need cf 9 and ms sql. Thanks. -- Regards, chedder is bedder ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358927 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF 11 and signing PDFs - Anyone using this?
If so, how is it working for you? We have been using Adobe's Echosign for this until now. We generate a PDF with Coldfusion and then send it to Echosign which responds with an e-signable PDF we present to the user on our site. With CF 11's announced support for signable PDF files, we're wondering if there might be a way to accomplish what we've been doing strictly with CF instead of relying of Echosign for this. I haven't been able to download CF 11 Developer Edition yet to check this out. If anyone knows where I can find this, please let me know. Regards, Stephen ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358750 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Need a way to collect neighborhood directory info online
We put out a printed directory of families in our neighborhood who choose to be included and distribute an updated version each year. Currently one person has compiled this data manually using a spreadsheet. Do you have any suggestions for a better way to accomplish this data gathering and management task? We'd like residents to be able to enter and modify their data themselves via a simple online form and provide a way for anyone to opt in or out of being included in the directory. When it comes time to print the directory we'd like to be able to dump the info that's been entered to use for that purpose. We have between 300 and 400 families currently who would need to be accommodated, usually with multiple e-mail addresses and phone numbers associated with an address. So far, Mailchimp looks like it might offer one possible solution. Does anyone have experience with a similar project? If so, how have you gone about it? I'd appreciate any constructive comments or experiences you might be willing to share. Regards, Stephen Hait ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357688 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Need a way to collect neighborhood directory info online
On Tue, Feb 18, 2014 at 10:18 AM, John Drake char...@ohmss.info wrote: Collecting info is easy - you could use Mailchimp, Formstack, Wufoo, etc. The problem comes when you want self-service editing. How do you prove that the person making the edits is really editing their own data only? That means passwords. John, that's a good point that I know we need to keep in mind. Jotform lets you send an auto-responder email to the user who has submitted a form. That email can include a link to just that record so that user can update his info later. That approach may have some drawbacks but it may provide a way to address this issue. Any thoughts? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357698 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: pdf COM object
On Mon, Aug 12, 2013 at 10:38 AM, daniel kessler dani...@umd.edu wrote: We are moving from cf7 to cf9 and because of that, we can no longer use COM objects. I've replaced most of the code with cf9 calls, but I cannot do so with CopyForm, which copies pages of the form. Can anyone recommend a path for correcting this? I don't know the cf pdf calls well. Is there a replacemnt for this within cf9? Here's a reference for merging PDF files with CF9: http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172e0811cbec22c24-798f.html ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356433 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Coldfusion and Adobe Echosign - any examples?
Do you know of any examples using Coldfusion to connect with Echosign's API? We are exploring moving from Docusign to Echosign for online document signing. We generate PDF documents on a website that site visitors then sign at Docusign. We transmit the PDF to be signed to Docusign and the users are notified how to sign it electronically there. If anyone is doing something similar with Echosign, I'm looking for CF examples that do this. Thanks in advance for any help or suggestions, Stephen Hait ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355508 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: I am stumped
On Wed, Apr 10, 2013 at 4:17 PM, John M Bliss bliss.j...@gmail.com wrote: Because my memory RE: logical operator precedence is often fallible and my WHERE clauses are often complicated, I almost always use parens, even when unnecessary. Also, they make SQL I wrote years ago and haven't looked at since easier to understand quickly. For MS SQL, AND takes precedence over OR. Using parentheses usually limits these gotchas. Here's the whole ball of wax re: precedence of operators: http://msdn.microsoft.com/en-us/library/ms190276.aspx ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355351 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: I am stumped
On Wed, Apr 10, 2013 at 5:52 PM, Bruce Sorge sor...@gmail.com wrote: This is MySQL. In that case, http://dev.mysql.com/doc/refman/5.0/en/operator-precedence.html AND still trumps OR ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355354 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Hosting - Clear Template Cache required
On Mon, Feb 25, 2013 at 1:47 PM, Dan LeGate d...@legeek.com wrote: Ever since I moved to their CF10 plan, any edits I make to my CFMs require me to login to their cumbersome interface and issue a Clear Template Cache command. They say this is required by ColdFusion, not them, and that the only way to not have this happen is to switch me back to a CF9 plan. Ugh. So my questions are: 1. Are they right? Do ALL CF hosting companies require a Clear Template Cache feature for CF10? Others will likely weigh in on this with better info, but ColdFusion does not require this behavior. It occurs when CF is set to use Trusted Cache. Raymond Camden has a clear explanation for why this is a good idea from a performance perspective. http://www.raymondcamden.com/index.cfm/2010/10/13/Why-arent-you-using-Trusted-Cache Regards, Stephen ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354684 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Hosting A to Z
On Thu, Feb 14, 2013 at 12:41 PM, Russ Michaels r...@michaels.me.uk wrote: try qforms http://pengoworks.com/index.cfm?action=get:qforms Have used qforms here, too, for quite some time and with success. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354524 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Anyone using CFPDF/CFPDFFORM to deliver personalized PDFs?
Thanks, Bobby. That's basically the way we're doing it. CF10 makes this quite simple, it turns out. Regards, Stephen On Tue, Jan 15, 2013 at 7:39 AM, Bobby bo...@acoderslife.com wrote: It has been a very long time but a number of years ago, I did a college application in PDF format. The PDF was already defined by the college and the format couldn't change. What I did was go into the PDF and make all of the answer sections form fields. Then, obviously, created a web form to gather all the answers. Once the form was submitted, all of those answers were used to generate a PDF answer file. The two files together populated the PDF with all the answers. It was tedious work since all the answer fields needed to match the PDF field names exactly (it was a huge application) but once that was done, it worked like a champ. It was all native CF code in (if I recall) CF6. On 12/12/12 10:59 AM, Stephen Hait sh...@mindspring.com wrote: We have an app that takes a user's info and uses it to populate an existing, blank Acrobat PDF form template that the user can then view, save or print. We had been using a commercial component, ActivePDFToolkit, for this on a CF7 platform. Our process previously had been to populate the PDF form template from a query, then to flatten and save the resulting PDF with a unique name. Now we want to use CF10 to accomplish the same goal. I'd be interested in discussing the approaches you may have taken for doing this type of thing with CF10. If anyone has experience with this and would be willing to discuss how you've approached it, please let me know, either through the list or by e-mail. Regards, Stephen Hait sh...@mindspring.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353873 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF10 styling cftooltip?
On Sat, Dec 22, 2012 at 12:36 PM, Billy Cravens bdcrav...@gmail.com wrote: You can't add a class to the cftooltip tag itself. Personally, I wouldn't use the CF UI tags. You'll get more control using any of the many tooltip jQuery plugins out there. That said Thanks Billy - very helpful info! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353610 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF10 styling cftooltip?
On Sat, Dec 22, 2012 at 12:56 PM, Scott Weikert li...@alphageek.cc wrote: On the subject of jQuery-based tooltip solutions, I recommend giving Tipped a looksee. http://projects.nickstakenburg.com/tipped Lots of options available for styling tooltips. --Scott Scott - Tipped looks very promising. Thanks for the suggestion! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353611 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF10 styling cftooltip?
I'm looking for an example of specifying style info for a cftooltip. I'd like to specify a class in a style sheet and reference that from the cftooltip tag. If that's not possible, how else can I go about this? Thanks, Stephen ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353603 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Anyone using CFPDF/CFPDFFORM to deliver personalized PDFs?
We have an app that takes a user's info and uses it to populate an existing, blank Acrobat PDF form template that the user can then view, save or print. We had been using a commercial component, ActivePDFToolkit, for this on a CF7 platform. Our process previously had been to populate the PDF form template from a query, then to flatten and save the resulting PDF with a unique name. Now we want to use CF10 to accomplish the same goal. I'd be interested in discussing the approaches you may have taken for doing this type of thing with CF10. If anyone has experience with this and would be willing to discuss how you've approached it, please let me know, either through the list or by e-mail. Regards, Stephen Hait sh...@mindspring.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353438 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Help needed with CF10 developer edition on XP w/IIS
Thanks, Russ Sergey, for your info and suggestions. I was hoping to set up CF10, IIS and SQL Server all on a single pc running XP. Looks like that wasn't such a good idea. For now I just switched to using the built-in webserver with CF10 which is just fine for my purpose. On Tue, Dec 11, 2012 at 7:44 AM, Russ Michaels r...@michaels.me.uk wrote: it seems like you are trying to treat a virtual directory as a separate website, which will not work. you can only have 1 website in IIS on windows XP. On Tue, Dec 11, 2012 at 12:21 PM, Sergey Croitor scroi...@gmail.com wrote: WinXP doesn't enable multiple sites on IIS. Use iis_multiplex as a workaround ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353416 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Help needed with CF10 developer edition on XP w/IIS
On Tue, Dec 11, 2012 at 7:47 AM, Andrew Scott andr...@andyscott.id.auwrote: Now XP is very old hat, and I would suggest upgrading your OS. If that is not an option then maybe look into something like VirtualBox which will allow you to run a VPS in your system. Now the beauty here is that you can install any *nix flavour that ColdFusion supports and it is at no cost to you. Thanks, Andy - Virtual Box sounds interesting. I was just looking into KVM and SPICE on linux recently so I'll check into virtualization further now. Stephen ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353417 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Help needed with CF10 developer edition on XP w/IIS
Thanks Dean, I didn't know about this and it looks promising. Stephen On Tue, Dec 11, 2012 at 10:37 AM, Dean Lawrence dean...@gmail.com wrote: However, you can create multiple sites via the command line. I used to run a utility called IIsAdmin.NET ( http://www.codeproject.com/Articles/10561/IIsAdmin-NET-Create-Multiple-Web-Sites-Under-Windo ) which does this for you and adds a taskbar icon that allows you to very easily create and switch between the different site. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353420 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Help needed with CF10 developer edition on XP w/IIS
On Tue, Dec 11, 2012 at 12:32 PM, Russ Michaels r...@michaels.me.uk wrote: Stop trying to struggle with iis 5 and install iis7 express as per last post, it will save all these headaches. You also need to get web platform installer to make life easier. Thanks Russ. I'll look into iis7 express. I wasn't aware of that before. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353422 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Help needed with CF10 developer edition on XP w/IIS
On Tue, Dec 11, 2012 at 4:19 PM, Russ Michaels r...@michaels.me.uk wrote: Windows 7 is not required to run iis 7 express, you can run it on xp. On Dec 11, 2012 7:59 PM, Steve Durette st...@durette.org wrote: Have you considered running apache? That's how I did it for years until I mover to windows 7. Thanks Russ and Steve, et. al. I appreciate all the good information I've gotten from the list. Apache on XP would be a good solution as would iis7 express. Is anyone running CF10 with iis7 express on XP or know how easy or difficult it would be to get that combination set up? Would the Web Server Configuration Tool that comes with CF10 work easily with that web server? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353425 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Help needed with CF10 developer edition on XP w/IIS
On Tue, Dec 11, 2012 at 5:25 PM, Russ Michaels r...@michaels.me.uk wrote: there should be no problem, cf10 supports both iis7 and apache. Apache on XP would be a good solution as would iis7 express. Is anyone running CF10 with iis7 express on XP or know how easy or difficult it would be to get that combination set up? Would the Web Server Configuration Tool that comes with CF10 work easily with that web server? Thanks Russ - sounds good. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353429 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Help needed with CF10 developer edition on XP w/IIS
I've installed CF 10 Developer edition on XP that is running IIS 5.1. I can get the CF Administrator to come up but cannot figure out how to set up a virtual directory for testing a CF website. I have tried creating a virtual directory, test, in IIS. I placed a simple .html file and a simple .cfm file in this directory. I modified my hosts file so that my current IP address 192.168.1.111 is set as test. I can browse to http://test/index.html and my test .html page displays. But if I try browsing to http://test/index.cfm I get a Coldfusion error: File not found: /index.cfm. The virtual directory is located under the IIS root: C:\inetpub\wwwroot\. Do I need to something more to tell CF where this directory is located?. Is there a guide somewhere that goes over the steps involved for getting .cfm pages to be served properly in this setup? Thanks in advance for any suggestions, Stephen ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353411 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF hosting plus Joomla capability needed - any suggestions?
I need to obtain hosting with ColdFusion with SQL Server or MySQL. Also need to be able to easily install and use Joomla for part of the website. I have previously used Crystaltech, now called Newtek, but am looking for suggestions on other hosting companies that would be good for this. This is for a fairly straightforward Joomla website and we would be using ColdFusion for a relatively low traffic data entry application. I am also wondering if a VPS would be better than basic shared hosting and, if so, why a VPS would be better. Thanks in advance. I know the topic of which hosting company is best has been done to death but I haven't had to look for one lately so thought I'd ask for suggestions here. Regards, Stephen ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352915 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) Were to store admin passwords?
This is a bit OT, but I'm starting to get paranoid. Where is the best place to store server administrator account password and passwords for the cfadministrator etc. You might try a program like KeePass. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349785 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: creating a signable PDF...CF9
On Fri, Sep 30, 2011 at 4:58 PM, Eric Roberts ow...@threeravensconsulting.com wrote: Does anyone know how to create a signable PDF? We have a need to be ale to create pdf's in CF on the fly, but then they need to be signable via a signing pad (like the one you use for credit card signatures). Does anyone know if this is possible and if so, how do you do it? Docusign allows for online PDF signing. So does Agreensign. I've implemented something like this using CF and Docusign. These may provide a solution for you. I think Docusign costs more. Good luck! Stephen ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347858 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Docusign with CF? Anyone successful with this?
Hi Christopher, and thanks for the link. I'll check it out and try to get somewhere with it over the weekend. Regards, Stephen On Fri, May 6, 2011 at 6:38 PM, Christopher Taylor christopher.tay...@docusign.com wrote: We're trying to integrate electronic signing of PDF files with Docusign and would appreciate any tips or suggestion anyone who has done this may have. We're running CFMX7. We create PDFs dynamically and would like to allow people to sign these online without needing to print them out and mail them to us. Hi Steve, I work for the DocuSign Professional Services team and have helped other DocuSign customers using ColdFusion. I wrote up a quick article on the DocuSign Community Forum to help as a guide to using ColdFusion with the API. http://community.docusign.com/t5/DocuSign-API-Integration-Other/Creating-an-Envelope-with-ColdFusion/m-p/3453 Hope this helps speed things up for you. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344311 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF5 download
On Tue, Jan 12, 2010 at 3:09 PM, Dave Watts dwa...@figleaf.com wrote: Tom, I've always loved your signature-- does it not count now that it is 2010? We've not won it this year yet :-) -- Helping to preemptively seize networks as part of the IT team of the year, '09 and '08 I would prefer that my network not be preemptively seized, TIA. Me, too. That would give me a seizure. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329605 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Is there a non-aggregate Max() function in MySQL?
On Sat, Dec 13, 2008 at 10:26 PM, Jim McAtee jmca...@mediaodyssey.comwrote: The max price may not be present and is set to zero when that's the case, so data might look like: 1 5 5 0 3 10 8 0 6 0 I want to order by the larger of the two column values ORDER BY Max(minprice, maxprice) DESC But SQL's MAX() can't be used like this since it's an aggregate function. Is there a MySQL function that would do this? I may be misunderstanding what you expect the result to be but ORDER BY minprice desc, maxprice desc would return rows in descending order of minprice and if there were multiples of minprice, they would be ordered in descending order of maxprice. With your example date, this should be: 8 0 6 0 5 0 3 10 1 5 Stephen ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316745 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: how to reduce PDF size?
needed. The problem I find is that there is no images what-so-ever and a 250 page document is about 200k. Is this as good as it gets? I'm curious That actually seems pretty good based on my experience. I've seen documents only one or two pages long with no graphics that are this size. I'm wondering how you get them so small. Stephen ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309684 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (ot) Stupid HTML Question
The nobr tag did what I wanted. The code below did not work as you would think it should (I had already tried those options myself). If you look at the page at http://www.zarts.com/test.cfm you will see the code you gave me below but you will also see that the cell still wraps. FYI - I see wrapping with IE but not FF. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309519 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Getting windows explorer to search ColdFusion files
On 8/2/07, Michael Dinowitz [EMAIL PROTECTED] wrote: Does anyone know how to force windows explorer to search through .cfm and .cfc files? Every time I try to use explorer to find text within a file of those extensions, it always returns no results. This works for me with XP: http://www.petri.co.il/windows_xp_search_bug.htm Describes a registry hack to allow searching for content within files with unknown extension (like .cfm) This is the simplest: Network administrators can configure this setting for the current user by modifying the registry. To do this, set the FilterFilesWithUnknownExtensions DWORD value to 1 in the following registry key: HKEY_LOCAL_MACHINE\SYSTEM\ControlSet\Control\ContentIndex Stephen ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285298 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Fusebox 5 install problem - help, please
On 5/18/07, Sandra Clark [EMAIL PROTECTED] wrote: Make sure your Fusebox_application_path in index.cfm points to the skeleton path. cfset FUSEBOX_APPLICATION_PATH = skeleton/ If I am reading your email message correctly. Thanks, Sandra I think the problem, which I didn't probably provide enough details for, was that this issue occurs when the virtual directory points to a location on a network share on another computer. I don't have any problems if everything is on the same machine and accessed via localhost. Thanks to Sean Corfield for this information. Stephen ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278702 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
OT: Fusebox 5 install problem - help, please
Sorry if this is off-topic. I wanted to install and try Fusebox 5. On my development system I've got a virtual directory configured named cf2 using IE6 running CFMX. I downloaded the FB 5.1 core files, extracted them from the archive and copied the fusebox5 directory to the root of the cf2 directory. Then I downloaded the FB5 skeleton app files, extracted them from the archive and copied the skeleton directory also to the root of the cf2 directory as per the readme.txt files (I think). I have both index.html and index.cfm files in the root of the cf2 directory and I can open both successfully in a browser at http://cf2/index.html and http://cf2/index.cfm. If I try to open http://cf2/skeleton/ I get an error: missing fusebox.xml The file fusebox.xml could not be found in the directory /ralj/cf2/skeleton/. Any idea what I'm doing wrong or how to get this working? Thanks in advance for any ideas. Stephen ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278652 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Use CF to fill a PDF form?
Thanks. Good info. We've been using ActivePDF to dynamically fill forms and I was hoping there was now a way to do this directly with CFMX. Any idea when this might be available? Stephen On 3/1/07, Ben Forta [EMAIL PROTECTED] wrote: You are correct, we've talked about it as a Scorpio feature. If you need some of this functionality now, check out http://www.forta.com/blog/index.cfm/2006/7/27/cf_pdfform --- Ben -Original Message- From: Stephen Hait [mailto:[EMAIL PROTECTED] Sent: Thursday, March 01, 2007 7:48 AM To: CF-Talk Subject: Use CF to fill a PDF form? I remember Ben Forta writing last summer about Adobe's plans to provide a cfpdfform tag (Scorpio?) that would allow dynamically filling PDF forms. Is this capablity available for CFMX yet? Stephen ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271283 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Use CF to fill a PDF form?
I remember Ben Forta writing last summer about Adobe's plans to provide a cfpdfform tag (Scorpio?) that would allow dynamically filling PDF forms. Is this capablity available for CFMX yet? Stephen ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271199 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Stumped on a cfgrid problem
http://208.112.27.110/services_TEST.cfm At the address above Nothing in I.E. Firefox paints up grid, but no data and no submit button, though it's in my code.! Works Locally in I.E. and Firefox EXCEPT - the Submit button isn't showing up. You might try escaping the forward slashes in your document.write statements: /embed to \/embed, /iframe to \/iframe, /br to br \/ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260207 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Studio to Dreamweaver question
I'm evaluating Dreamweaver8 after working with Studio5. Is there something comparable in Dreamweaver to Ctrl-M in Studio which finds the matching start or end tag for the one your cursor is on? Regards, Stephen ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248951 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: FDF and coldfusion
On 6/7/06, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: I wrote and app which does just this in CFMX 6.1. It takes in a PDF form ( Any code I can share let me know..be happy to. I would like to see your code for this. Thanks in advance. Stephen ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242778 Archives: http://www.houseoffusion.com/cf_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: Big SQL security hole at Crystaltech?
I think this occurs when databases have a user with the name of guest. Databases without a user named guest should not have their objects or even their database names exposed. If you have a user in your database named guest, delete that user and your database should not be visible to others thru EM. That's my understanding, anyway. Regards, Stephen On 5/8/06, Matt Robertson [EMAIL PROTECTED] wrote: After signing onto a new client's SQL Server account, first on one dedicated server and then another, I found I could not only see several other databases belonging to other customers... I could click on the Tables tab and see all of their tables. Taking it a step further, I could double-click on a table and pull up its table structure. All of this is in SQL Enterprise Manager. They have two separate accounts and I could see eight other databases that didn't belong to my client on one server and 9 on the other. I could not modify the tables or view the data (I didn't even try to Drop of course). Poking around a little more, I found I could view all of another db's stored procedures! This prompted me to load up a second customer of mine, who also has a SQL account at Crystaltech. Same freaking story! Before I completely blow a gasket I wanted to confirm this is as big of a screwup as I think it is. There is an easy fix for this right? I fired up another client and, while I can see other existing db's, if I try and click on anything I get a refusal (error 916. not an authorized user). Anyone else with a Crystaltech account... Can you chime in here? Do you see the same things I do? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239863 Archives: http://www.houseoffusion.com/cf_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: ActivePDF and CFMX 7
On 2/6/06, Loathe [EMAIL PROTECTED] wrote: Nothing huh? Tim Does anyone have any experience getting this combo to work? I really don't want to rewrite this bit of code using cfdocument, but I will if I need to. Right now this works in MX 6.1, but not in 7: CFOBJECT ACTION=Create TYPE=COM CLASS=APSERVER.Object NAME=APServer CFSET APServer.OutputDirectory = ExpandPath(./results) I doubt this will help but I have the following running on MX 7 without a problem. It also ran in CF 5. CFOBJECT ACTION=Create TYPE=COM CLASS=APToolkit.Object NAME=PDF Regards, Stephen ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231464 Archives: http://www.houseoffusion.com/cf_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: Authorize.net request
I'd be interested in this, too. Please post here or send the example code to my address if you can. Thanks, Stephen On 11/30/05, Ray Champagne [EMAIL PROTECTED] wrote: back authorized or declined. I can share the code with you once I get to work in about an hour. I'll email you off list when I get there, if you'd like. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225709 Archives: http://www.houseoffusion.com/cf_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: CF + ActivePDF hosting
I've been instructed to find a list of hosts that currently support both CF 6.1 and ActivePDF. Yes, I've googled, and will continue to do so. :-) Crystaltech just installed the ActivePDF Toolkit for us on one of their shared hosting servers running CFMX 6.1. For some reason they charge $10/month to register the DLL. Not sure about the other ActivePDF products. HTH, Stephen ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194874 Archives: http://www.houseoffusion.com/cf_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: Dynamic CF PDFs - help request
Jared asked: What's the driver behind needing PDF for this solution, if I may ask? Primarily the requirement for a user's signature on the form. The user enters data that's stored and used to populate the form, then they print the PDF that's populated with their data, sign the form and mail it in. For this case, the form needs to be updated each year so the user can make any minor changes in subsequent years and avoid having to enter all the form data once it's been entered initially. Is there an electronic signature of some kind that would be the same as an actual signature? If it would be acceptible to the insurance companies we deal with, that might be worth investigating. Stephen ~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190795 Archives: http://www.houseoffusion.com/cf_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: Dynamic CF PDFs - help request
Jared, Thanks to you and Doug James for checking into this issue. I just hit your test page, and the PDF form came up, the contents of the FDF came up... same as Doug. But when I clicked on the link to the FDF, I got the Reader splash screen, and then nothing. Blank screen. No content at all. No errors either... but I'm not sure that's a good thing. I used the FireFox Page Info dialogue to save the FDF to my desktop and when I opened it in Reader, nothing at all came up there either, just a blank, gray, empty Reader screen. It seems that Firefox has some known issues when trying to display a PDF via a FDF (content of type Application/vnd.fdf). I should have made it clearer that what we're trying to reproduce are errors when opening the form with _Internet Explorer_. That link again is: http://www.hopeaviation.com/pilotform/test/index.cfm If anyone else could test this with IE and report whether it succeeds or how it fails, I'd appreciate it. The system is oriented toward delivering content from a base64 encoded DB text table, but the example uses a PDF which is streamed back to the browser in a CFM page with cfcontent and cfheader making Acrobat think it's a PDF file... source code is downloadable from the link provided. This is basically what we're doing, too, except that we're trying to make the browser think that it's a FDF file (mime type would be Application/vnd.fdf). Here's another example for comparison at planetpdf.com (FWIW, this is the same situation but using ASP instead of CF. I have the same problems with Firefox and this example): http://www.planetpdf.com/planetpdf/inetpub/demo2.html Thanks again, Stephen ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190628 Archives: http://www.houseoffusion.com/cf_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: Dynamic CF PDFs - help request
Jared, Thanks again. I've tried every configuration I can think of I can't get either of the results you reported. Would you mind trying this link at planetpdf.com and letting me know what happens: http://www.planetpdf.com/planetpdf/inetpub/demo2.html This is the same basic idea of serving a FDF data file that points to a corresponding PDF but it's ASP instead of CF. Even though this FDF/PDF solution has worked for us for a couple of years, it's been a real bear trying to troubleshoot the odd, unreproducible problem. There are too many different factors between operating system and patch level, browser version and patch level and plugin configuration, Reader or Acrobat version(s), etc. Since there doesn't seem to be much problem with reading actual PDF files in most browsers, I think I will start looking at a solution that fills and saves a PDF file on the server and then serves that to the requestor. If you have any advice along those lines, please lay it on me. Thanks again for your time, Stephen Stephen... I just hit the URL again using IE 6. I got two messages from Acrobat, one that the page contained no comments with Yes and No buttons. The other one said This action is not permitted. Both of these ocurred while I had Reader open as a standalone app. When I hit the FDF page without Acrobat open, I, once again, got a blank page and no errors. Sorry dude... Laterz, J On Sun, 16 Jan 2005 13:42:30 -0500, Stephen Hait [EMAIL PROTECTED] wrote: Jared, Thanks to you and Doug James for checking into this issue.I just hit your test page, and the PDF form came up, the contents of the FDF came up... same as Doug. But when I clicked on the link to the FDF, I got the Reader splash screen, and then nothing. Blank screen. No content at all. No errors either... but I'm not sure that's a good thing. I used the FireFox Page Info dialogue to save the FDF to my desktop and when I opened it in Reader, nothing at all came up there either, just a blank, gray, empty Reader screen. It seems that Firefox has some known issues when trying to display a PDF via a FDF (content of type Application/vnd.fdf). I should have made it clearer that what we're trying to reproduce are errors when opening the form with _Internet Explorer_. That link again is: http://www.hopeaviation.com/pilotform/test/index.cfm If anyone else could test this with IE and report whether it succeeds or how it fails, I'd appreciate it.The system is oriented toward delivering content from a base64 encoded DB text table, but the example uses a PDF which is streamed back to the browser in a CFM page with cfcontent and cfheader making Acrobat think it's a PDF file... source code is downloadable from the link provided. This is basically what we're doing, too, except that we're trying to make the browser think that it's a FDF file (mime type would be Application/vnd.fdf). Here's another example for comparison at planetpdf.com (FWIW, this is the same situation but using ASP instead of CF. I have the same problems with Firefox and this example): http://www.planetpdf.com/planetpdf/inetpub/demo2.html Thanks again, Stephen -- Continuum Media Group LLC Burnsville, MN 55337 http://www.web-relevant.com http://cfobjective.blogspot.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190656 Archives: http://www.houseoffusion.com/cf_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
Dynamic CF PDFs problem - please help
For the past two years we have had an application that dynamically populates a PDF form that must be printed, signed and mailed. About 3 weeks ago we started getting one or two reports per day of problems users were having when trying to view the PDF. The most common problem reported was Error opening document. We have been unable to reproduce this error ourselves so troubleshooting has been fairly fruitless. If anyone knows of a reason this may have suddenly become a problem, we'd like to hear it. Here's a template with links to the dynamically populated form as well as the actual PDF form file and the contents of the FDF stream that feeds the PDF if you have a few moments to test it and have Acrobat Reader 5 or newer: http://www.hopeaviation.com/pilotform/test/index.cfm Any and all help would be greatly appreciated. Regards, Stephen ~| Purchase Homesite Plus with Dreamweaver from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=55 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190467 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: flowchart diagrams - best tools guides?
Here's a link to a shareware flowchart product that works pretty well on Windows: http://www.paraben.com/html/flow.html Stephen ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184338 Archives: http://www.houseoffusion.com/cf_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
Application.cfm update question
Running CF5 or CFMX6.1, if I make a change to Application.cfm and update that file on the server, the change doesn't seem to take effect until I cycle the CF service. Is this to be expected? Is there a way to force changes to Application.cfm to take effect without cycling the CF service? Stephen ~| Get the mailserver that powers this list at http://www.houseoffusion.com/banners/view.cfm?bannerid=17 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182966 Archives: http://www.houseoffusion.com/cf_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: hosting ?
I use them sometimes, but their SQL server access seems really slow sorry - CrystalTech.com junkie here giggle had to put my 2 cents in somehow... If you're using MS EM to access databases at CrystalTech, it _can_ take a really long time to initially connect. I've experienced this at several other hosting providers, too. You might want to try using Aqua Data Studio from http://www.aquafold.com/ which seems much faster for this. Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SQL Find
Does SQL Server have an function similar to CF's Find string function. I need to parse 150,000 names depending on where the comma is in the string and update each record. Not a great task for CF. I'm aware of the substring command but it needs to know what position the comma is in. With SQL Server you can use PATINDEX or CHARINDEX to locate the position in a string where one or more characters are. Documentation can be found in Books Online. Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFFUN 04 - He3
What's He3, please? Hey CFFUN attendees, how does He3 look? Very nice!I've already set it up as my pimary editor for CF files... looking forward to some of the updates that Matt L talked about at the conference! Hatton [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT: Dynamic menu for IE Mac
Hi! I'm having big problems finding a dynamic menu that works on major browsers on Win and Linux, and IE on Mac. The biggest challenge was IE on Mac. I couldAlso it I've had good luck with CoolMenus and IE5 Mac: http://www.dhtmlcentral.com/projects/coolmenus/ HTH, Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: IIS and Web? Hopefully CF
I've got a copy of IHTK from 1/5/2002. If you'd like I could provide it to you. Stephen Does anyone know a good utility to manage IIS, creating Virtual Sites and such from a web browser? (Would like a CF based one) I tried to download the IHTK however there was an error on their site so I am not sure what else would be available. I am running IIS 5 on a Windows platform. TIA! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: E-trade DHTML
I'm looking to replicate the flow of the E-Trade DHTML menu. https://us.etrade.com/e/t/home/accessus?traxui=F_GN Anyone know of a good place to find something similiar pre-rolled that I could work off of? You might try Coolmenus at http://www.dhtmlcentral.com/projects/coolmenus/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
jintegra.jar contains Trojans???
My virus checker, Kaspersky AVPRo, recently started flagging d:\CFusionMX\lib\jintegra.jar as containing TrojanDownloader.Java.OpenConneciton.j which apparently is a virus or a trojan. Since this .jar file was apparently installed as part of CFMX 6.1 it seems unlikely that there's actually a problem but I was wondering if anyone might be able to shed some light on this. Thanks, Stephen Stephen Hait [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Populating PDF Fields w/ ActivePDF
I'm trying to populate a pre-existing PDF form using the ActivePDF Toolkit. I'm having no luck, all i get is a zero-length PDF file. Anyone have any example code they could This link may help: http://www.worlddesign.com/index.cfm/rd/cf/PDFForms.htm Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX CFDUMP output formatting
Is there a way to control the font-size for CFDUMP output with CFMX on W2003? I'd like to have the text display larger so I can read it. I'd prefer to be able to do this from the CFAdministrator. There appears to be a class file, cfdump2ecfm659484891.class, which contains an embedded style sheet that specifies font-size: xx-small. This file appears to be encrypted. If CFDUMP output font-size cannot be controlled via the Administrator, could this file be modified to change this? Any ideas? Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SOT: PDF's forms being auto-filled by CFMX
Hey Stephen! Thanks so much for your reply. I am thinking it is an Adobe problem I am having. I can't get the PDF to open up in the browser. Instead, it opens Acrobat the program and gives me that file does not exist error. I edited the Acrobat and Reader preferences to Display document in browser but still no luck. I tried it on a machine that has Reader only, but it still is opening the Reader program and trying to load the PDF. If you have any ideas I'd appreciate it. There are all kinds of problems I've run into trying to implement this type of solution. What platform, browser version, acrobat and/or reader version (note that it's quite possible to have more than one version of reader installed and it may not be obvious at first which version is being used to open the file.) What happens when you try to open a PDF file from a link with your browser as opposed to an FDF? What happens when you try to open a PDF file with your browser from your local file system? Some general problems I've seen that may not be pertinent to your case: This seems to work less reliably on Macs for some reason. Versions of reader older than 5 seem to have some problems with PDFs with dynamic form fields. This may be somewhat OT so feel free to contact me off-list if you'd like; I'd be glad to try to help if I can. Regards, Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Incorrect syntax near...
Update wweb_status SET status = 'custom', custom_message = #form.custommessage# Where status = status If custom_status is not numeric, you may also need to put single quotes around '#form.custommessage#'. The where clause may also be a problem; what are you trying to compare with 'Where status = status'? Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SOT: PDF's forms being auto-filled by CFMX
Does anyone know of there are any things that have come up in MX that would disallow auto-filling PDF forms? Not exactly sure what problem you're having but I've handled this using CFMX 6.1 (and earlier) using CFCONTENT _and_ CFHEADER as follows: CFSETTING ENABLECFOUTPUTONLY=YES CFHEADER NAME=Content-Disposition VALUE=inline; filename=myfdfname.fdf CFCONTENT TYPE=application/vnd.fdf CFSETTING ENABLECFOUTPUTONLY=NOCFINCLUDE TEMPLATE=myfdfname.fdf Your FDF file needs to point to the actual PDF file which corresponds to its contents. HTH, Stephen I did the tutorial here: http://www.mail-archive.com/[EMAIL PROTECTED]/msg32040.html And everything was gravy until I got to the part where the PDF is supposed to load in Acrobat. I get an error that saysThere was an error opening the docuement. The file does not exist. Well, I uploaded the PDF and FDF files to my server, etc. The example tutorial uses the CFCONTENT tag, which I am not all that familiar with. Is is possible that there is something in CF causing the file not to be recognized? It's the only thing I can thinkof besides the fact that Acrobat Reader isn't opening within the confines fo the browser, but is opening itself up in a new window. I've tried on a few different machines with the same result. Any help is greatly appreciated, as always. Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] There is no right price for the wrong product, even if it is inexpensive and delivered on time. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFID/CFTOKEN newbie question
Bah - that's what I thought.So, how do you determine if the user has cookies or not before you go through the trouble of adding them to the url? cfcookie name=cookieTest value=test expires=never cfif COOKIE.cookieTest NEQ test cookies not enabled code here /cfif HTH, Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFID/CFTOKEN newbie question
Bah - that's what I thought.So, how do you determine if the user has cookies or not before you go through the trouble of adding them to the url? cfcookie name=cookieTest value=test expires=never cfif COOKIE.cookieTest NEQ test cookies not enabled code here /cfif You can't effectively test for the existence of a cookie on the same page in which you set the cookie. You can only test for its existence on subsequent pages. Dave Watts, CTO, Fig Leaf Software Ah! Right. Thanks for making that point. Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFID/CFTOKEN newbie question
Stephen, On 3/2/2004 at 17:15, you wrote: SH cfcookie name=cookieTest value=test expires=never SH cfif COOKIE.cookieTest NEQ test SHcookies not enabled code here SH /cfif The cookie isn't actually set until the page request setting the cookie completes; however, Cold Fusion makes the cookie value available during the page request. This means that the check for the cookie value has to occur on a subsequent page request to be of use. ~ Ubqtous ~ Thanks for clarifying that. Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ColdFusion IDEs
EditPad Pro All, I'm curious to know what IDEs other than Dreamweaver and HomeSite/ColdFusion Studio are people using, and what the stand out features of their favored IDE is. Note: I'm really not interested in HomeSite(+ or not) or Dreamweaver info. Thanks, Calvin Ward Jacksonville, FL ColdFusion User Group Manager http://www.jaxfusion.org/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ColdFusion Graphing Capabilities
Corda PopChart Stephen Does coldfusion allow you to do really indepth graphs that I would be able to do on MS Excel? If so, does any one know a good site that gives good examples of how to generate complicated graphs. If not, does anyone know of a good charting tool that integrates easily? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Free Mail Clients
BS Anyone know of any good free email clients? Pegasus Mail is free and works well if you run Windows. http://www.pmail.com/ Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Help (updated)
Had some incorrect info in there Carry on:-) Given the following journals with related documents. Journal A document1a - Jan 1, 2004 document2a - Jan 2, 2003 document3a - Dec 3, 2002 Journal B document1b - Jan 3, 2001 document2b - Jan 4, 2000 document3b - Dec 2, 1999 Journal C document1c - Dec 3, 2002 document2c - Jan 9, 2003 document3c - Jan 9, 2004 I would like to output to be like this Journal C - Jan 9, 2004 Journal A - Jan 1, 2004 Journal B - Jan 3, 2001 Anyone want to take a stab at it? Try this: SELECT j.title, MAX(d.createdate) AS maxdocdate FROM journal j JOIN document d ON j.journalid = d.journalid GROUP BY j.title ORDER BY maxdocdate DESC You can format your date output however you'd like. HTH, Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Mind Mapping Programs
I am looking into mind mapping software once again. A couple years ago I used Visual Mind and Ynguis a little bit, but want to find one and use it regularly as part of my planning processes. The ones I know of are listed below. Anybody have any experience using any of these or know of other ones I have not listed here? Visual Mind MindManager X5 FreeMind MindGenius MindMapper I've used MindManager from MindJet.com for quite awhile and like it pretty well. Has collaboration features, generates various HTML based representations that are fairly clean, supports hyperlinks, etc. Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Flash question - newbie
I'm interested in learning about developing applications on CFMX that utilize Flash but I confess I'm confused as to what I would need to do this. There seem to be various products; Flash MX 2004, Flash MX Pro 2004 and Studio MX 2004 with Flash Pro, etc. that might do this. What's the minimum software requirement for developing Flash apps? What would be the benefits of alternatives to the minimum? I own CF Studio 5 if that's a factor. Sorry this sounds so lame but I've never created anything with Flash and am clueless. Regards, Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Flash question - newbie
How does Flash Remoting fit into the equation? Or does it? Stephen The only 2 tools you need Flash MX 2004 Professional and Sapien's PrimalScript www.sapien.com. What's the minimum software requirement for developing Flash apps? What would be the benefits of alternatives to the minimum? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Flash question - newbie
Thanks to all for your input. Stephen At a minimum, Flash Pro with or without the studio (not sure if you need that extra stuff) and the free developer version of CFMX (which comes with Flash Remoting). You could get away with the standard version of Flash but the additional components and integrated AS editor in Pro make it worth it. chris From: Stephen Hait [mailto:[EMAIL PROTECTED] Sent: Monday, January 05, 2004 11:03 AM To: CF-Talk Subject: Flash question - newbie I'm interested in learning about developing applications on CFMX that utilize Flash but I confess I'm confused as to what I would need to do this. There seem to be various products; Flash MX 2004, Flash MX Pro 2004 and Studio MX 2004 with Flash Pro, etc. that might do this. What's the minimum software requirement for developing Flash apps? What would be the benefits of alternatives to the minimum? I own CF Studio 5 if that's a factor. Sorry this sounds so lame but I've never created anything with Flash and am clueless. Regards, Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT : Form Posts Mac
Recently, we have been having problems with some forms not posting correctly on a Macintosh (G4, IE 5.5), does anyone remember anything specific about Macs and form posting which needs to be addressed to get it to work correctly? One diiference in the way form data is posted from a Mac is how line endings might be sent. On a PC line endings are usually sent as two characters: CR + LF (carriage return + line feed/new line), on a *NIX box lines usually end with just a new line character and on Macs lines traditionally have ended with just a carriage return character. This may be different on newer Macs whose operating systems are UNIX based but I'm not sure about that. This could have an impact if the code in the form's target is attempting to parse line endings for some reason. However, since you don't describe exactly what problem you're encountering, this may or may not be relevant. Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT : Form Posts Mac
Line endings in what? the actual template / code? In this case, I'm referring to line endings contained in values related to submitted form elements. In a textarea form element, for instance, I could type the following: Now is the timereturn for all good ... When the form is submitted, the value for this form element would contain a line ending character(s) after the word 'time'. When you say forms are not posting correctly, what exactly is the problem you're seeing? Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF Studio RDS datasource madness
- Installed MS SQL Server on dev box. - Created a datasource in CF 5 admin. - Attempted to browse the datasource tables via the database tab in CF Studio. The tables I see via the database tab in CF Studio are NOT the tables defined in my datasource... they look like system tables or something, not really sure. Here's a snapshot of what I see. http://66.51.163.40/cfstudio/http://66.51.163.40/cfstudio/ Anyone know what's causing this and how to fix it? TIA. The tables you're seeing under the datasource you've created, CD_webstore, are actually tables in the master database. When you set up your datasource in CF Admin you need to specify the database in addition to the server. My guess is that the database has been left blank in which case the database defaults to whatever is set as the default database on SQL Server; probably this is the master database. Try entering CD_webstore as the database you want to connect to for this datasource name from withing CF Admin and you should be good to go. Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX on Win2K3 Web Edition?
Are there any known issues for installing CFMX on Windows 2003 Web Edition? Because we're having problems...first the CF service started fine, but would not execute CF pages, now the service won't even start.Any help would be greatly, superly, duperly, stupendously, immeasurably appreciated- This won't be much help, I'm afraid, but I've got CFMX 6.1 running on Windows 2003 Web Edition without any problems. When you look at CF MX Application Server in your services list, does it appear as Started? If not, can you start it? Is Startup Type set to Automatic? If not, can you set it to Automatic? If you have other CF services in the list, how do they appear to be set? This is a clean install of CFMX - no previous versions had been installed. Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Weird Images issues...
them on the server. When I look at them through either the web site or directly in the globalimages directory on a web browser I get nadda. No broken links just no image. FWIW, I also don't see images displayed at http://www.lcgis.com/STAGE/index.htm. I do see the directory listing in the GlobalImages directory but cannot actually view any of the images. And if I try to download an image from the listing by Save target as... I get a file downloaded with the image name but it ends up being zero bytes on my end. Have you checked to see if you can access an image stored in the /STAGE directory from the /STAGE directory? If so, the /STAGE and /STAGE/GlobalImages directories may be set up somehow differently. Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Problem
Update IssueRegister SET IssueStatus = '#form.IssueStatus#', Response = '#form.Response#', ResponseUserId = '#session.activeuser.USER_NAME#', DateofResponse = #CreateODBCdate(now())# Where IssueNumber = #form.issuenumber# The error that I get from CF is The search key was not found in any record. But if I look in the error window it show my statment as follows Update IssueRegister_qr SET IssueStatus = 'Closed', Response = 'completed', ResponseUserId = 'Mickael Elmalem1', DateofResponse = {d '2003-12-16'} Where IssueNumber = 1110 This look correct to me.So I tried running it in access's query window and I get the same error, yet when I try to search the column for issuenumber 1110 Access finds it through its own search utility. This is most probably a problem with Access and not your SQL statement or ColdFusion. Try a search in Google Groups for The search key was not found in any record. There appear to be any number of scenarios that can lead to this vague error message - replication, memo fields, Jet version, etc.You are definitely not the only one who has experienced this. Here's something else you might try if it's feasible: Try creating a new (blank) Access database. Immediately turn off Name AutoCorrect (Tools | Options | General). Then import everything from the old database (File | Get External | Import). Recreating everything like that may solve the issue. Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMAIL -- CDO/CDONTS problems
I have a CF shared hosting provider who is recommending switching to CDO/CDONTS from CFMAIL for sending e-mail. I've successfully created modifcations for a few sites there to accomplish this. Now I'm trying to implement this locally for development purposes and I'm realizing I'm totally lost so I'm asking if anyone has any suggestions or pointers to tutorials about this that might resolve the problems I'm having (basically mail doesn't get sent from my development machines, it just ends up and stays in the IIS mailroot\queue directory.) I've got 2 development platforms, both connecting to the Internet via ADSL connection and I'm able to send mail via this connection with a mail client through my ISP's mail servers no problem; in fact I'm doing that right now. I'm also able to set up CFMAIL in the CF Administrator to use CFMAIL no problem. My 2 platforms are as follows and I'd welcome solutions pertaining to either of them: W2K Pro running CF5 and IIS5 single mode (or whatever it's referred to). W2003 Server Webserver Edition running CFMX6.1 and IIS6. When trying to use CDONTS on either of these machines, mail ends up in the QUEUE directory but just stays there and is never sent out. With CF5 I can specify my mail server as mail.bellsouth.net (SMTP server I use with a regular mail client) and with CFMX I can specify this server and, additionally, specify the proper user/password credentials required by Bellsouth to send mail via its mail servers. I don't see how to accomplish this via CDO/CDONTS and the IIS SMTP service and I'm not even sure this is looking in the correct direction. This one's had me scratching my head for a few days now so any suggestions would be extemely welcome. Sorry if this is a newbie question but I've been trying to find a solution in many places and so far have struck out. Regards, Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: JOIN help
What I need is to select User 1 and ALL Queues so I get a result like this: UserID QueueID AccessID 12 0 11 NULL You could use an intermediate or temp table to return your desired result set like this: /* create temp table with one row for each queueid for each userid */ select u.id as userid, q.id as queueid into #t1 from users u, queues q GO /* this will provide the result you described */ select #t1.*, uq.accessid from #t1 left outer join userqueues uq on #t1.userid=uq.userid and #t1.queueid=uq.queueid order by #t1.userid, #t1.queueid GO drop table #t1 GO There are probably other, better ways to do this but I hope this may help you. Regards, Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Generators
Anyone know of software (desktop or CF based), that will generate SQL (select, insert, update, etc.), by simply pointing to an Access database? Generating cfqueryparam's would be a bonus. You might want to check out SqlGen at: http://www.aloha-webdesign.com/ It's helped me in prototyping. HTH, Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF5, ISA server, debugging question
I have a client who recently installed a MS ISA server for firewall purposes. This seems to change how IIS recognizes requests from IP addresses - now all requests are reported in the web server logs as 192.168.0.1. Likewise, cgi.remote_host now reports this IP regardless of where on the Internet a request comes from. Is there any way now to be able to specify debugging output be presented without having every visitor see this output? In CF Administrator it looks like the only way to direct debug output is by specifying IP addresses - in this case, only 192.168.0.1 will cause debug info to show in which case everyone sees it. Or, is there a more flexible mechanism for doing this that upgrading to CFMX would provide? Regards, Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF5, ISA server, debugging question
Dave Watts wrote: I can think of a couple of possible solutions. One would be to simply enable debugging for that address in the CF Administrator, then use code to control the display of debugging output. For example, you could have something like this in your Application.cfm file for a site on the server: cfsetting showdebugoutput=false cfif ShowMeDebugOutput cfsetting showdebugoutput=true /cfif You could control this by tying it to a login, or to a URL parameter, or something along those lines. Thanks, Dave, that's a great suggestion and one that I've now managed to implement with session variables which works quite well. It's actually more convenient from my perspective to have this setting be related to a session rather than a particular IP address anyway. Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFDUMP question, attributes scope - CF 5
I have CF 5 Enterprise running locally and a client with CF 5 Professional. I can run CFDUMP var=#attributes# locally no problem. Running this on the client's machine gives me an error resolving parameter ATTRIBUTES. Does anyone know what problem I'm running into here? Regards, Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: SQL Assistance Needed
Can someone assist me with the following: SELECT O.opportunityId, O.title, N.ndaId, N.ndaDate, U.firstName, U.lastName, U.emailAddress FROM tbl_opportunity O INNER JOIN tbl_nda N ON (O.opportunityId = N.opportunityId) INNER JOIN tbl_user U ON (N.issuedById = U.userId) Here is the gist... Three table: opportunity, nda, user. User is a lookup table for users and opportunity and nda are linked together via opportunityId. Table nda can have more than one opportunity referenced in it. What I would like to do is to just get a listing of the opportunities for which there is at least 1 record in the nda table. Does that make sense? Have you tried the example you provided. From your explanation, that looks like it would work. You should only get rows returned where an opportunityid exists in the nda table. If it doesn't, what is wrong with the result set you get? Regards, Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: textarea problem
IS there some secret to displaying a form variable in a HTML form - textarea box: I don't get any errors, but nothing shows when I pass the description variable to this text area: TEXTAREA NAME=description ROWS=5 COLS=59VALUE=#description# scroll=yes/textarea The value displayed in the textarea form element is specified diferently. Try changing it to this: TEXTAREA NAME=description ROWS=5 COLS=59 scroll=yes#description#/textarea You also need to use cfoutput/cfoutput tags of course. HTH, Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF5 and Windows 2003/IIS6
We're about to upgrade our server, currently running W2K/IIS5 to W2003/IIS6. We are currently running CF5. Are there any issues installing or running CF5 on W2003/IIS6? We're also running Corda's PopChart Server version 4 - does anyone have any experience with this running on W2003/IIS6? Anything we should watch out for? TIA, Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Computer Desk for Multiple Monitors...
I use two Cafeteria tables one 8' one 6'. The best desk I have ever had. I got a 21, 19, two 15 and a 17. 2 Macs and the 3 PC's underneath. Keyboards sit in front of monitors. Writing Space to the side and Collect all at the far end. Durable long lasting and easy to move. I will second this. I have a door laying on top of 2-drawer file cabinets for one side of an L and a shorter table to the left making up the other side of the L. Very inexpensive and flexible and lots of work space/monitor space. Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: converting double-spaced UNIX lines to CRLF
One other thing - I think Mac uses the opposite of Unix - CR only. At least that's what I recall from submitted HTML forms.Regards,Stephen Doesn't UNIX use just a single linefeed as a newline character?If you know there are only LFs and no CRs in the string, then: cfset cr = Chr(13) cfset lf = Chr(10) cfset mystring = Replace(mystring, #lf#, #cr##lf#, all)- Original Message - From: Gyrus [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, September 27, 2003 2:16 PM Subject: SOT: converting double-spaced UNIX lines to CRLFI've got some HTML documents that I'm converting for a new site, extracting content and re-formatting, etc. I'm use a CF script to do this. I'm not entirely certain, but I think the double-space UNIX-style lines (as per Homesite prompt when I open them) are screwing up the character position calculations I'm doing to extract content. What's the quickest way of converting all these to the usual Win(?) #Chr(13)##Chr(10)#? I'm currently trying: cfset oldContent = REReplace(oldContent, Chr(13)Chr(13)Chr(10), Chr(13)Chr(10), ALL) to no avail (I found a reference on the net to UNIX double-spaced lines being 0D0D0A). I'm searching and searching, but can anyone here help out with a quick 'n' easy method? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Graphing Solutions Beyond CFGraph
I am searching for a graphing engine that will allow me to display 2 Y axis, one on the right and one on the left. PopChart from Corda has worked very well for us for several years. Highly recommended. HTH, Stephen ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137574 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: DWMX 2004 - Whats new for us?
I strongly recommend that every Cf'er, studio, and dreamweaver user, who have not already planned to do so to contact the user group in your area who is participating in the Worldwide Macromedia user group meeting sponsored by Macromedia via Breeze on September 3, 2004. An additional perk is a copy of StudioMX 3004 will be raffled off at each meeting (a $499.00 value) Is this something that's available to someone who is not able to physically go to a presentation site? If so, what's the URL and time? Thanks, Stephen ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com