Maintaining a Lyris listserv via CF
Has anyone attempted decontructing the Lyris listserv database to manage subscribers using a CF web form? Thanks... ~| 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:359522 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: looping over PDF subforms
Fair enough. I got my client to exempt "on the fly" pdfs from 508 requirements. Although CF11/Splendor has some nice enhancements. PDFs and CF do seem to be a niche, at least in Adobe's eyes. I think they are badly underestimating it, but if only I ran the world...everything would be nice then. cf-talk@houseoffusion.com on Wednesday, July 16, 2014 at 12:09 PM -0700 wrote: >I can generate HTML tables and such all day long and use CFDOCUMENT to turn >it into a PDF, but it's not 508 Compliant because CFDOCUMENT doesn't >support tagging, > >My thought is to create predefined PDFs that are compliant and populate >them like you would a PDF Formthen merge the whole mess together, but I >can't fathom a way to repeatedly loop over a PDF form and repopulate it... ~| 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:358884 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: looping over PDF subforms
I am...I just have a cfdocumentsection within a cfloop that is looping through however many rows my query returned. Sometimes the page breaks can get goofy if there is a lot of data, in which case I test for greater than however many rows I can fit and insert a page break. cf-talk@houseoffusion.com on Wednesday, July 16, 2014 at 11:50 AM -0700 wrote: > >I know there are methods to populate pre defined PDF forms, which would >work except that alot of my data is multiple row format and I don't know >how many rows may be returned and I can't limit it ~| 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:358881 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
SpreadsheetMergeCells and SpreadsheetFormatRow
I am creating a spreadsheet, and the first row is a merged cell with the title. I'd like an underline on this merged cell. However, only the first cell of the original unmerged first row is underlined. I worked around this by using topborder on row 2...but it seems like I should be able to underline a merged cell. Can anyone point out if I have something wrong? Thanks! ~| 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:357746 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: list from array occurences
Everyone had interesting solutions, but I wonder why you just wouldn't use ArrayTolist() cf-talk@houseoffusion.com on Wednesday, July 29, 2009 at 9:27 AM -0700 wrote: > >hi > >we need to create a list of the string VarChar i.e. >"VarChar,VarChar,VarChar" > >the amount of list elements is totally dependant on the length of another >array which could change. > >e.g. if theArray length is 3 then the list would be >"VarChar,VarChar,VarChar" else if theArray length is 5 then the list >would be "VarChar,VarChar,VarChar,VarChar,VarChar" etc... > >is there a function to do this in a line of code > >thanks > ~| 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:325082 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfdocument question
Your code below will save the pdf in the same folder as your cf template.are you sure that is where your email is looking for the file? I usually have to give cfmail the full path from the root directory (c:\#myFullPath#\etc\etc\). Your configuration might be simpler, of course. cf-talk@houseoffusion.com on Monday, July 27, 2009 at 7:14 AM -0700 wrote: > >Any reason why the cfdocument line below does not save the file anywhere? >I try to attach it to an email and it cannot find this file. > > > >Thanks. > >RO >HWW > > > ~| 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:325009 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
(ot) php commenting
Not CF related, but does anyone know what this is. When editing a php file in Dreamweaver, when you click on the comments button, you also get a choice that results in this: I can't find that documented anywhere and I guess I am just curious. It does result in an error on my server so I've learned to ignore it, but I am still wondering why it is there and what the heck it is. ~| 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:323942 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: css and cfdocument...grrr
Solid background behind table headers?.must be the pm slump because I can't think what you mean, but maybe the stuff below will help. I am using border-collapse and setting borders on all my table cells, like this: I am setting font and background color in the class as you can see from my obtuse css naming scheme. I also was able to get a watermark on my pdf in this way: body{ background-image:url(/images/draftlandscape.jpg); } Anyway, best of luck. If you get to be an expert at all these tricks you too can present at CFUnited. ;) cf-talk@houseoffusion.com on Thursday, June 18, 2009 at 2:22 PM -0700 wrote: >I'm getting closer to what I want with a table layout. One thing I can't >seem to get so far is a solid background behind table headers. >border-collapse works in a browser but isn't supported by the cfdocument. >Setting border-spacing, padding and margin all to 0 doesn't seem to do it >either. ~| 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:323679 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: css and cfdocument...grrr
I should have mentioned that I had to put everything in tables for layout. I also removed every non-basic CSS thing I had. I ended up with a print version and a simle print style sheet and the web version with its own nicer style sheet. My client had what is basically an accounting spreadsheet they wanted recreated in a web form, then pdf'd for an official copy. It took me almost 3 weeks to match the original's exact positioning, font, layout, etc. Good times. cf-talk@houseoffusion.com on Thursday, June 18, 2009 at 12:07 PM -0700 wrote: >Font sizes I specified in pt instead of em and I tried to do everything in >percentages with no px definitions under the theory that pdf is a vector >format. No love. > >Thanks for all the ideas being tossed out though. ~| 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:323659 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: css and cfdocument...grrr
I use an alternate style sheet that sets fonts to a point size instead of em and has a fixed width. Even then, I sometimes run into an odd scaling down effect if there is too much data. Also, if you have images that you are resizing for the web, make an alternate actual size image for the pdf. cf-talk@houseoffusion.com on Thursday, June 18, 2009 at 11:50 AM -0700 wrote: > >The CSS file is definitely being included, so that's good. And I haven't >tried to do anything with images yet, thankfully. Perhaps I need to move >to >a fixed-width layout using inches as units instead of percentages. Or >maybe >tables. Blech. > >Thanks for that link though, I haven't looked at that one in quite awhile. > >Judah ~| 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:323656 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Certified Adobe PDFs and cfdocument
>From what I've been able to find on the Adobe website so far, it seems there are different kinds of pdfs. PDFs created with Acrobat Pro can be digitally certified and locked to prevent the recipient from editing. CFDocument allows you to add a password, and prevent edits as well, but it is not the same as a digital certification. Does anyone else have any experience with this? What the project folks would like is to use ColdFusion to generate certified pdfs, but I don't think this is possible, as from the docs I've read so far, the pdf types are different. Any thoughts on this would be appreciated! (yup we are running CF8). ~| 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:314955 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: use of IN operator in CFIF tag
cf-talk@houseoffusion.com on Monday, June 30, 2008 at 1:47 PM -0700 wrote: >CFIF isDefined("FullName") and ( >FullName IN "Jr." How about using FindOneOf? ~| 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:308344 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Database of US Zip Codes
You could just download it from the US Census at http://www.census.gov/geo/www/tiger/zip1999.html You'll need to change their state numbers to the right abbr, but otherwise it's useable. "Michael Barnum" <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>... > All I need though is zip, and town and state, nothing else, isnt there > something cheaper? > > THanks > > Michael > > "Dylan Bromby" <[EMAIL PROTECTED]> wrote in message > news:<001a01c0a7fc$dfb126a0$6401a8c0@bromby>... > > their data is good. i've used it for years. used to be $35. > > > > -Original Message- > > From: Duane Boudreau [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, March 08, 2001 10:21 AM > > To: CF-Talk > > Subject: RE: Database of US ZIP CODES > > > > > > You can get it for $150 USD at http://www.tpsnet.com/html/zipcode.html > > > > I just finished a stored procedure that does a distance calculation and > > locates all zips with in a given radius if that is what you are trying to > > accomplish. > > > > Duane > > > > > > -Original Message- > > From: Michael [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, March 08, 2001 1:05 PM > > To: CF-Talk > > Subject: OT: Database of US ZIP CODES > > > > > > Anyone know of where I can get this, and reasonably accurate and up to > > date... > > > > I may be asking too much , but hey cant hurt right. > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL Statement books
Instant SQL Programming, by Joe Celko (A very good basic reference with plenty of more advanced stuff like "having", "outer joins", etc.) Guru's Guide to Transact-SQL, by Ken Henderson (Specific to SQL-Server/Sybase, advanced reference more for DBA types) SQL Server Essential Reference, by Sharon Dooley (a most excellent resource if you use SQL Server) [EMAIL PROTECTED] writes: >Does anyone know of any GOOD SQL reference books that explain in detail >when to use certain clause's? such as WHERE Whatever IN, the different >types of JOINS ect... basically a good reference book with a lot of >detail. (i have the "The Complete Reference SQL" by James R. Groff & Paul >N. Weinberg.) > >Thanks, > >Jay Patton >Web Design / Application Design >Web Pro USA >406.549.3337 ext. 203 >1.888.5WEBPRO >www.webpro-usa.com > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Dynamic column order
Sorry for the basic question, but here goes: I'm trying to allow the columns in a query output table to be dynamic in order, depending on the sort selection the user previously made in the form (in the form field form.sort). Form.sort has four fields in order, and they are comma-delimited. In other words, form.sort will contain something like "First, Last, City, State". The sql statement uses form.sort in order by. Then, I thought it would be nice if the columns showed up in the order the user selected. So on the search results page, I wrote form.sort to a series of variables that I can hopefully use in the CFOUTPUT, like this: Then I wrote out the table, like this: #variables.col1value# #variables.col2value# #variables.col3value# #variables.col4value# All I get in the output table though, is "variables.col1value".etc. I can't figure out what I did wrongany help would be appreciated! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Dynamic column order
Sorry for the basic question, but here goes: I'm trying to allow the columns in a query output table to be dynamic in order, depending on the sort selection the user previously made in the form (in the form field form.sort). Form.sort has four fields in order, and they are comma-delimited. In other words, form.sort will contain something like "First, Last, City, State". The sql statement uses form.sort in order by. Then, I thought it would be nice if the columns showed up in the order the user selected. So on the search results page, I wrote form.sort to a series of variables that I can hopefully use in the CFOUTPUT, like this: Then I wrote out the table, like this: #variables.col1value# #variables.col2value# #variables.col3value# #variables.col4value# All I get in the output table though, is "variables.col1value".etc. I can't figure out what I did wrongany help would be appreciated! ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists