Maintaining a Lyris listserv via CF

2014-10-27 Thread Randi Knutson
Has anyone attempted decontructing the Lyris listserv database to manage subscribers using a CF web form? Thanks... ~| Order the Adobe Coldfusion Anthology now!

Re: looping over PDF subforms

2014-07-16 Thread Randi Knutson
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.

Re: looping over PDF subforms

2014-07-16 Thread Randi Knutson
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.

SpreadsheetMergeCells and SpreadsheetFormatRow

2014-02-24 Thread Randi Knutson
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

Re: list from array occurences

2009-07-29 Thread Randi Knutson
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

Re: cfdocument question

2009-07-27 Thread Randi Knutson
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.

(ot) php commenting

2009-06-25 Thread Randi Knutson
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: ?php /*??php */? I can't find that documented anywhere and I guess I am just curious. It does result in an error on my

Re: css and cfdocument...grrr

2009-06-18 Thread Randi Knutson
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.

Re: css and cfdocument...grrr

2009-06-18 Thread Randi Knutson
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

Re: css and cfdocument...grrr

2009-06-18 Thread Randi Knutson
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: table style=border-collapse:collapse; border=0 cellpadding=2 cellspacing=0

Certified Adobe PDFs and cfdocument

2008-11-07 Thread Randi Knutson
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

Re: use of IN operator in CFIF tag

2008-06-30 Thread Randi Knutson
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? cfif isDefined(FullName) AND findOneOf(jr, mr, mrs,FullName) ~| AdobeĀ®

RE: Database of US Zip Codes

2001-03-08 Thread Randi Knutson
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

Re: SQL Statement books

2001-03-01 Thread Randi Knutson
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

Dynamic column order

2001-02-14 Thread Randi Knutson
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

Dynamic column order

2001-02-14 Thread Randi Knutson
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