Re: DW versions that supported CF

2014-04-30 Thread Bruce Sorge

The version just prior to Creative Cloud. 

Bruce

Sent from my iPhone 5S

 On Apr 30, 2014, at 12:48 PM, Ben b...@webworldinc.com wrote:
 
 
 Hi 
 
 What was the most recent version of DW that still supported CF?  I've been 
 using an older version and want to upgrade but am not going to learn a 
 different platform just to upgrade. 
 
 Thanks!
 
 Ben
 
 

~|
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:358481
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: DW versions that supported CF

2014-04-30 Thread Bruce Sorge

I believe so. 

Sent from my iPhone 5S

 On Apr 30, 2014, at 1:05 PM, Ben b...@webworldinc.com wrote:
 
 
 Looking at the version list would that be CS 5.5?
 
 Ben
 
 On Apr 30, 2014, at 9:53 AM, Bruce Sorge sor...@gmail.com wrote:
 
 
 The version just prior to Creative Cloud. 
 
 Bruce
 
 Sent from my iPhone 5S
 
 On Apr 30, 2014, at 12:48 PM, Ben b...@webworldinc.com wrote:
 
 
 Hi 
 
 What was the most recent version of DW that still supported CF?  I've been 
 using an older version and want to upgrade but am not going to learn a 
 different platform just to upgrade. 
 
 Thanks!
 
 Ben
 
 

~|
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:358484
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: DW versions that supported CF

2014-04-30 Thread Bruce Sorge

On my machine using CC, I just told it to open .cfm files with dreamweaver by 
default, then it works. I even have tag insight. What it won't do is create a 
.cfm file. I have to do a file - save-as .cfm. I think that I need to 
embrace the new builder going forward. 

Bruce

Sent from my iPhone 5S

 On Apr 30, 2014, at 1:59 PM, Russ Michaels r...@michaels.me.uk wrote:
 
 
 the creative cloud version does support CF, but it is not enabled by
 default and is depreciated, but I have seen posts explaining how to get it
 working, so do a bit of googling and you should find it.
 
 
 
 On Wed, Apr 30, 2014 at 6:08 PM, Gerald Guido gerald.gu...@gmail.comwrote:
 
 
 I think DW 6 was the last one to support CF
 
 --
 Gerald Guido
 
 Twitter https://twitter.com/CozmoTrouble
 Blarg http://www.myinternetisbroken.com
 Facebook https://www.facebook.com/gerald.guido.9
 
 
 On Wed, Apr 30, 2014 at 1:05 PM, Ben b...@webworldinc.com wrote:
 
 
 Looking at the version list would that be CS 5.5?
 
 Ben
 
 On Apr 30, 2014, at 9:53 AM, Bruce Sorge sor...@gmail.com wrote:
 
 
 The version just prior to Creative Cloud.
 
 Bruce
 
 Sent from my iPhone 5S
 
 On Apr 30, 2014, at 12:48 PM, Ben b...@webworldinc.com wrote:
 
 
 Hi
 
 What was the most recent version of DW that still supported CF?  I've
 been using an older version and want to upgrade but am not going to
 learn a
 different platform just to upgrade.
 
 Thanks!
 
 Ben
 
 
 
 
 
 
 
 
 
 

~|
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:358487
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: DW versions that supported CF

2014-04-30 Thread Bruce Sorge

Carl,
I know. I was one of the original testers of CF11 and Builder 3, but I had
to stop testing. I am still on Active Duty and I am also a full time
college student, and since I didn't have any actual CF projects (only PHP
at the time), I didn't have the time to dedicate to any real testing. Once
I finish these four classes and graduate school, I plan to install CF11 (on
my VMWare partition since there are features that don't work on a Mac) and
buy Builder 3 and start back into working with the two.

Bruce


On Wed, Apr 30, 2014 at 2:23 PM, Carl Von Stetten
vonner.li...@vonner.netwrote:


 Bruce,

 If you can make it through the first two weeks using CFBuilder, you
 probably won't look back at Dreamweaver (at least for ColdFusion
 coding).  I was a long-time Dreamweaver user before switching to
 CFBuilder 2.  After a couple of weeks, I never opened Dreamweaver
 again.  And that was despite some of the little quirks of
 CFBuilder/Aptana.  The CFBuilder 3 beta seemed to be pretty solid (Adobe
 ripped out Aptana and rewrote the HTML/JS/CSS/CFML parser, code insight,
 code completion stuff), and is much faster and free of the quirks that
 annoyed me.  Plus you can add in any Eclipse plugins that are useful to
 you (I like the MXUnit and EGit plugins for Unit Testing and Git
 interactions, respectively).

 -Carl V.




~|
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:358489
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CF11... Live?

2014-04-29 Thread Bruce Sorge

You have to dig into their products catalog to find it right now:
http://www.adobe.com/products/catalog.html?promoid=JOOTH


On Tue, Apr 29, 2014 at 10:19 AM, DURETTE, STEVEN J sd1...@att.com wrote:


 Ok, I could sort of understand that, however ColdFusion is an existing
 product why would you remove it from the See All Products link? You can bet
 they wouldn't do that for a new version of Creative Cloud!





~|
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:358460
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CF to groovy, awe man wth...

2014-03-17 Thread Bruce Sorge

I recall a long time ago, a company that I worked for switched from CF to
.NET. So I was paid to learn C# and rewrite all my CF apps to C# as well.
Yep, getting paid to learn new stuff is where it's at.

Bruce


On Mon, Mar 17, 2014 at 9:41 AM, Adam Cameron dacc...@gmail.com wrote:


 Absolutely. I'd KILL for an opportunity like that (that said, we're being
 cross-trained to C#, which I am also looking fwd to).





~|
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:357948
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Adobe take over a MONTH to advise me my credit card details are stolen

2013-11-26 Thread Bruce Sorge

I received a letter stating my information might have been compromised and 
offered me one year of credit monitoring for free. 

Sent from my iPhone 4S. 

 On Nov 26, 2013, at 7:20 AM, John M Bliss bliss.j...@gmail.com wrote:
 
 
 My bank (Bank Of America) preemptively sent me a new card with a letter
 stating that my old card's numbers may have been stolen from a vendor I've
 used in the past.
 
 No letter from Adobe yet.
 
 
 On Tue, Nov 26, 2013 at 7:07 AM, Mike K afpwebwo...@gmail.com wrote:
 
 
 We all heard about the Adobe security disaster here,  but finally now,
 OVER A MONTH later,   Adobe have finally got around to informing me that
 my credit card info and other details were stolen, possibly creating an
 identity theft issue for me.
 
 And they thought so much about it, and were SO concerned for my security,
 they didnt even bother to sign the letter.
 
 I have my email address on file because I'm a Creative Cloud subscriber,
 but did they send me a warning that way?   NO!  Merely sent a letter by
 snail mail on 13 October and couldn't even put a name to the person sending
 it.
 
 I dont have many complimentary words for these *^$#@@s.
 
 --
 Cheers
 Mike Kear
 Windsor, NSW, Australia
 Adobe Certified Advanced ColdFusion Developer
 AFP Webworks
 http://afpwebworks.com
 ColdFusion Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month
 
 
 
 
 

~|
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:357138
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Adobe take over a MONTH to advise me my credit card details are stolen

2013-11-26 Thread Bruce Sorge

Same here John. Emails stating that my password might have been compromised as 
well. 

Bruce

On Nov 26, 2013, at 7:44 AM, John M Bliss bliss.j...@gmail.com wrote:

 
 I received emails stating that my password may have been stolen. Nothing
 about card number.
 
 Why would Adobe have been storing my entire card number anyway? I'm pretty
 sure that's just bad infosec.
 
 



~|
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:357141
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CF 10 on Mavericks AND Adobe download links not working

2013-10-28 Thread Bruce Sorge

I did the mavericks fix for cf this morning and a reinstall and I am working 
fine using apache and cf10. I already had the dmg for cf so I never messed 
towing it. 

Sent from my iPhone 4S. 

 On Oct 28, 2013, at 10:15 AM, Raymond Camden raymondcam...@gmail.com wrote:
 
 
 I just tried and it worked for me - the download I mean. What problem did
 you have with the link?
 
 As for Mavericks - I updated yesterday and CF is running fine for me. Note
 though that I do not use the OSX Apache but rather MAMP.
 
 
 On Mon, Oct 28, 2013 at 9:10 AM, Scott Brady dsbr...@gmail.com wrote:
 
 
 I upgraded my Mac to Mavericks over the weekend and I had CF 10 working
 yesterday, by using the modified mod_jk.so that someone posted on the net
 (since there isn't a fix from Adobe yet).
 
 This morning, it stopped working after trying a CF restart, so I went
 through the process again and still couldn't get it working.  So, I figured
 i'd try re-installing CF10.  Unfortunately, it looks like both the download
 links on Adobe's site for ColdFusion 10 aren't working (nor is the Report
 a bug link on their site), but other download links are working. (One
 other developer can get to the download page, but another one can't -- we
 thought maybe it was a VPN issue, but if I disconnect from the VPN, I still
 can't get to the download link).
 
 Since I can't report the problem and Ray is on this list, I'm hoping he can
 at least notify the web site team.
 
 Here's the download link I'm trying:
 http://www.adobe.com/cfusion/tdrc/index.cfm?product=coldfusion
 
 
 --
 -
 Scott Brady
 http://www.scottbrady.net/
 
 

~|
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:356984
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Sort of OT

2013-10-24 Thread Bruce Sorge

Soldier and part time cf dev. 

Sent from my iPhone 4S. 

 On Oct 24, 2013, at 12:23 PM, Robert Harrison rob...@austin-williams.com 
 wrote:
 
 
 Just curious on the makeup of the list participants...are we mainly 
 employees of companies using CF or are there any hosting companies/ISPs in 
 the group?
 
 IT director of a company that host and develops sites for a multitude of 
 large clients.   Most sites are currently CF.
 
 Unfortunately, sales lately seem to be easier if we develop using Word Press. 
  Adobe has done little to rebrand or reinvigorate CF, so there is a 
 perception that it's 'old and dying' technology, so our CF team and Adobe are 
 losing sales and opportunities. 
 
 Robert Harrison 
 Director of Interactive Services
 
 Austin  Williams
 Advertising I Branding I Digital I Direct  
 125 Kennedy Drive,  Suite 100   I  Hauppauge, NY 11788
 T 631.231.6600 X 119   F 631.434.7022   
 http://www.austin-williams.com
 
 Blog:  http://www.austin-williams.com/blog
 Twitter:  http://www.twitter.com/austi
 
 

~|
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:356972
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Metters Inc. Looking for Two CF Developers

2013-10-10 Thread Bruce Sorge

When I first saw this, I thought it was a reposting from  a while ago. The 
first line, Do you write ColdFusion code in your sleep was used before by a 
company - I don't recall who though.

On Oct 10, 2013, at 2:08 PM, Scott Stewart webmas...@sstwebworks.com wrote:

 
 and I just realized that I sent this to the wrong list... Mike D if you
 want to delete this that's fine
 
 


~|
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:356902
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Adobe hacked

2013-10-03 Thread Bruce Sorge

It's on CF community as well

On Oct 3, 2013, at 6:02 PM, Billy Cravens bdcrav...@gmail.com wrote:

 
 Kinda surprised no one else here has said anything,  but with the Adobe 
 breach, change your Adobe.com password immediately.
 
 http://blogs.adobe.com/conversations/2013/10/important-customer-security-announcement.html
 http://blogs.adobe.com/asset/2013/10/illegal-access-to-adobe-source-code.html
 
 
 Billy Cravens
 bdcrav...@gmail.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:356874
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Getting output into a div using cfdocument

2013-08-31 Thread Bruce Sorge

I am on my dev machine but the hosting company is on 8 or 9. 

Sent from my iPhone 4S. 

On Aug 30, 2013, at 11:21 PM, Byron Mann byronos...@gmail.com wrote:

 
 http://help.adobe.com/en_US/ColdFusion/10.0/Developing/WSe61e35da8d318518-106e125d1353e804331-7ffd.html
 
 Are you using CF 10? You can use Bbq without needing the jar in the server
 lib directory.
 
 Byron Mann
 Lead Engineer  Architect
 HostMySite.com
 On Aug 29, 2013 4:36 PM, Bruce Sorge sor...@gmail.com wrote:
 
 
 I'm starting to figure that out. I even included the JS library in the
 cfdocument tag and still nada. This sucks. If I were on my own server I'd
 have no issues downloading BBQ or something like that, but since I am on a
 hosted server I am pretty much limited in what I can do.
 
 Bruce
 
 On Aug 29, 2013, at 4:20 PM, Dave Watts dwa...@figleaf.com wrote:
 
 
 I don't think you'll be able to use client-side barcode generation
 with CFDOCUMENT. The jQuery barcode plugin uses JavaScript, not just
 CSS.
 
 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 http://training.figleaf.com/
 
 Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
 GSA Schedule, and provides the highest caliber vendor-authorized
 instruction at our training centers, online, or onsite.
 
 
 
 
 
 

~|
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:356682
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Getting output into a div using cfdocument

2013-08-29 Thread Bruce Sorge

Hey all,
I decided to try and use the query barcode plugin for an app that I have out 
there. The app queries a database and then creates and emails PDF's to 
customers who bought a voucher. The voucher includes a barcode. Previously I 
was using a barcode generator from barcode.tec-it.com, but the barcode prints 
their company name on it. No big deal except that I have to call their 
generator with each one, and if the company goes under or for waterer reason I 
cannot access their site, then barcodes do not generate.

So I can get my barcodes to generate on a regular .cfm page using the following 
code:

script src=../js/jquery-1.7.2.min.js type=text/javascript/script
script src=../js/jquery-barcode.js/script

cfset Yesterday = #DateAdd(d, -1, Now())#
 

!---Get customer information---
cfquery datasource=#Request.LiveDSN# name=qGetUseremail
SELECT user_id, Name, Address_1, City, State, Zip, Email, BarCode, 
ACC_Code, BirthDate, Deal_Name, DateRegistered, Time_Registered, 
Confirmation_Number
FROM Users
WHERE DateRegistered = '#DateFormat(Yesterday,mm/dd/)#' AND  BarCode 
IS NOT NULL
/cfquery

cfoutput query=qGetUserEmail
script
$(document).ready(function() {
$(##bcTarget).barcode(#BarCode#, code39,{barWidth:2, barHeight:30});
});
/script

div id=bcTarget
/div

Now when I move this div tag inside my cfdocument tag, I get no barcode. I am 
not sure if it's a css issue (the plug in defaults to css, and I cannot get the 
bmp to output). Any thoughts? 

Bruce

~|
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:356659
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Getting output into a div using cfdocument

2013-08-29 Thread Bruce Sorge

I'm starting to figure that out. I even included the JS library in the 
cfdocument tag and still nada. This sucks. If I were on my own server I'd have 
no issues downloading BBQ or something like that, but since I am on a hosted 
server I am pretty much limited in what I can do.

Bruce

On Aug 29, 2013, at 4:20 PM, Dave Watts dwa...@figleaf.com wrote:

 
 I don't think you'll be able to use client-side barcode generation
 with CFDOCUMENT. The jQuery barcode plugin uses JavaScript, not just
 CSS.
 
 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 http://training.figleaf.com/
 
 Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
 GSA Schedule, and provides the highest caliber vendor-authorized
 instruction at our training centers, online, or onsite.
 


~|
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:356662
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Getting output into a div using cfdocument

2013-08-29 Thread Bruce Sorge

Tried that. It spits out a huge chunk of div tags that actually generates the 
barcode styles. When I put that into the cfdocument (as I would if I stuck it 
all in a db then called it later via a query) and nothing. I think that it has 
to do with css and generating a pdf, not sure. Oh well, it was worth a shot.

Bruce
On Aug 29, 2013, at 4:44 PM, Rob Parkhill robert.parkh...@gmail.com wrote:

 
 Could you call a CFC that created the Barcode, and then saved the HTML (or
 whatever the result is) to a DB, and then have CF call it out inside the
 CFdocument just to display? It's an extra step, but it _should_ allow you
 to get around the CFDocument issue.
 
 
 On Thu, Aug 29, 2013 at 4:35 PM, Bruce Sorge sor...@gmail.com wrote:
 


~|
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:35
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Haven't received any mail lately...

2013-06-25 Thread Bruce Sorge

Got it. 

Sent from my iPhone 4S. 

On Jun 25, 2013, at 10:32 AM, Rick Faircloth r...@whitestonemedia.com wrote:

 
 Testing...
 
 -- 
 --
 Ninety percent of the politicians give the other ten percent a bad
 reputation.  Henry Kissinger
 
 
 

~|
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:356041
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Adobe no longer supports ColdFusion??? Really?

2013-06-18 Thread Bruce Sorge

I'll admit that I usually do my design work in DW, or Photoshop (slice and
dice when done), and then once I have my design the way I want it, I'll
switch to code view and hand code my CF into the page(s). I find that to be
much easier than hand coding the entire thing. Except CSS. I usually hand
code CSS.

I recently got back into using CF Builder though as I like it once I got
used to it. I will still use DW or PS for layout and design, but then
switch to builder for the real work.

Bruce

On Tue, Jun 18, 2013 at 2:29 PM, Steve 'Cutter' Blades 
cold.fus...@cutterscrossing.com wrote:


 I had not seen this, but I'm not surprised either. One, Dreamweaver is
 really a designer's editor (IMO). I'm actually surprised that they
 continue to support any server side language, of any kind. Two, Adobe
 already has a first class ColdFusion file editor in ColdFusion Builder,
 built on Eclipse (an editor for those who write apps, and know what F5
 can do in the browser) ;)

 Steve 'Cutter' Blades
 Adobe Community Professional
 Adobe Certified Expert
 Advanced Macromedia ColdFusion MX 7 Developer
 
 http://cutterscrossing.com


 Co-Author Learning Ext JS 3.2 Packt Publishing 2010

 https://www.packtpub.com/learning-ext-js-3-2-for-building-dynamic-desktop-style-user-interfaces/book

 The best way to predict the future is to help create 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:355990
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Code Design help

2013-05-09 Thread Bruce Sorge

I see it just fine.
On May 9, 2013, at 10:51 AM, Marty Franklin ma...@assetresearch.com wrote:

 
 Hello,
 
 It appears my posts do not appear on this list? I am curious why?
 
 Martin Franklin
 ma...@assetresearch.com
 
 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:355666
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Easy CFC question (I hope)

2013-05-09 Thread Bruce Sorge

Hey,
I am doing a project for my CF class in college. I admit that I have not played 
with CFC's in a while, but I cannot figure out why this is not working:

cffunction name=adduser hint=Adds a new user to the database 
returntype=query
cfargument name=fname required=true type=string
cfargument name=lname required=true type=string
cfargument name=username required=true type=string
cfargument name=userpwd required=true type=string
cfargument name=email required=true type=string

cfset var adduser =  /
!--- Hash the password and create a random number for the URL 
on the email that will be sent ---
cfset securepwd = #hash(arguments.userpwd)# /
cfset salt = #Rand(SHA1PRNG)# /
cfset secureHash = hash(salt) /


cfquery name=qUserID result=userid 
datasource=bhsrecruitadmindsn
INSERT INTO users
(username, userpwd, fname, lname, email, secureHash)
VALUES ('#arguments.username#', '#securepwd#', 
'#arguments.fname#', '#arguments.lname#', '#arguments.email#', '#secureHash#')
/cfquery

!--- Set the auto generated key ---
cfset newID = #userid.generated_key# /
!--- Now we get the informatoion from the db ---
cfquery name=qUserEmail
SELECT fname, lname, email, secureHash
FROM users
WHERE userid = #newID#
/cfquery

cfreturn adduser
/cffunction

The information enters into the db as expected, but when I invoke the component 
on the other end:

cfinvoke method=adduser component=cfc/dbfunctions 
returnvariable=userinfo
cfinvokeargument name=username value=#form.username#
cfinvokeargument name=userpwd value=#form.userpwd#
cfinvokeargument name=fname value=#form.fname#
cfinvokeargument name=lname value=#form.lname#
cfinvokeargument name=email value=#form.email#
/cfinvoke

I get the error message The value returned from the adduser function is not of 
type query. If the component name is specified as a return type, it is possible 
that either a definition file for the component cannot be found or is not 
accessible. The error occurred on line 16.

Also, I know that there are a few things that could be fixed/tidied up 
regarding hashing and such, but this class is not on encryption or anything 
like that, it's so that the instructor see's that I have a basic understanding 
of CF. The book for the class is CFWAC for version 9, so it's beginner level 
stuff.

Bruce

~|
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:355669
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Easy CFC question (I hope)

2013-05-09 Thread Bruce Sorge

Damn it. Stupid rookie mistake. 

Sent from my iPhone 4S. 

On May 9, 2013, at 11:55 AM, morgan lindley greyk...@gmail.com wrote:

 
 Change your return to:
 cfretun qUserEmail
 
 As you have it, it's attempting to return a reference to the adduser method.
 
 
 

~|
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:355673
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Easy CFC question (I hope)

2013-05-09 Thread Bruce Sorge

I just did what dave and morgan suggested and it worked like a charm. 
Embarrassed that I made this beginner mistake. I have about six or so more 
functions above this one that all work fine, just didn't pay attention to 
details on this one. 

Bruce
On May 9, 2013, at 12:02 PM, DURETTE, STEVEN J sd1...@att.com wrote:

 
 Actually up higher he does a cfset var adduser =  / so he is actually 
 returning a variable. He can solve it either using your way or by doing a 
 cfset adduser = qUserEmail / before the cfreturn.
 
 I just mention this because if he inspected the results he wouldn't get back 
 that he was returning an instance of the component, just a simple variable.
 
 I know a lot of people who declare some sort of return variable and set it at 
 the end just before returning. 
 
 Steve
 


~|
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:355676
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Easy CFC question (I hope)

2013-05-09 Thread Bruce Sorge

Already done. And I'm stepping away from the computer or a bit. Heh. 

Sent from my iPhone 4S. 

On May 9, 2013, at 12:10 PM, DURETTE, STEVEN J sd1...@att.com wrote:

 
 You might want to remove the cfset var adduser =  / since it isn't used 
 then. Clean code is easier to troubleshoot.
 
 That's just my .01 (I'm too cheap to give 2 cents!) LOL.
 
 -Original Message-
 From: Bruce Sorge [mailto:sor...@gmail.com] 
 Sent: Thursday, May 09, 2013 12:06 PM
 To: cf-talk
 Subject: Re: Easy CFC question (I hope)
 
 
 I just did what dave and morgan suggested and it worked like a charm. 
 Embarrassed that I made this beginner mistake. I have about six or so more 
 functions above this one that all work fine, just didn't pay attention to 
 details on this one. 
 
 Bruce
 
 

~|
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:355680
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Job Openings With Our Direct Client for COLD FUSION DEVELOPER@CHICAGO IL 60606 // SAN ANTONIO TX 78209 // ATLANTA GA 30308

2013-04-23 Thread Bruce Sorge

Thanks but I am back in the army now. 

Sent from my iPhone 4S. 

On Apr 23, 2013, at 9:01 AM, Sharan sha...@suntechnologies.com wrote:

 
 Greetings from Sun Technologies!
 
 
 
 My name is Sharan Gowda and I'm a Recruiter at Sun Technologies Inc. 
 
 
 
 Our records show that you have past or current experience with skills
 fitting a current opening with our Direct End Client. Please be aware that
 our database has searched out your resume based on key word skills, so
 please accept my apologies if this requirement does not match your current
 or preferred job profile or location preference. 
 
 
 
 I would love to show my appreciation with referral fee(s) for anyone I hire
 through your referral/introduction/recommendation, including confidential
 referrals.  If you know anyone who is interested / qualified, please feel
 free to pass on my contact info as you see fit.
 
 
 
 Job Details
 
 
 
 Job Title: COLD FUSION DEVELOPER
 
 Job Location: CHICAGO IL  60606 // SAN ANTONIO  TX 78209  // ATLANTA GA
 30308
 
 Duration: EXPECTED TO BE 8 MONTHS CONTRACT WITH POSSIBLE EXTENSION
 
 Positions: 3
 
 
 
 PLEASE LIST IN THE SUPPLIMENTAL AREA WHERE CANDIDATE IS ELIGIABLE TO WORK
 
 
 
 This position will work on ColdFusion report development and migration for
 the new One Click initiative. The candidate must possess cross-browser
 web-development skills including IE (all versions), Firefox, Safari, and
 Chrome. Other critical skill sets include ColdFusion 9 or later and a
 working knowledge of SQL Server Query Design  Optimization  SQL Server
 Integration Services (SSIS), familiarity with Eclipse/CFEclipse or
 Dreamweaver, jQuery, HTML-4/5 and Cascading Style sheets.
 
 
 
 
 Skills Inventory 
 
 
 
 
 
 
 Skill 
 
 Experience 
 
 Need 
 
 
 1)
 
 Cold Fusion 10
 
 Expert 
 
 Required 
 
 
 2)
 
 SQL Server Query Design
 
 Expert 
 
 Required 
 
 
 3)
 
 CSS-2
 
 Expert 
 
 Required 
 
 
 4)
 
 HTML 4 (minimum)
 
 Expert 
 
 Required 
 
 
 5)
 
 JQuery
 
 Intermediate 
 
 Desired 
 
 
 6)
 
 Eclipse-Dreamweaver
 
 Intermediate 
 
 Desired 
 
 
 7)
 
 Webservices using XML
 
 Intermediate 
 
 Required 
 
 
 8)
 
 Prior ATT Experience
 
 Intermediate 
 
 Desired
 
 
 
 Please fill the below information and send it along with your resume in word
 format:
 
 *Visa status (Citizen / Green Card / TN / EAD/H1B): 
 *Expected Hourly Rate: 
 *Employment Type: 
 *Availability:
 *Best number and time to reach you:
 
 Thanks  Regards,
 Sharan Gowda,
 Sun Technologies, Inc.
 3700 Mansell Road Suite 125 
 
 Alpharetta GA 30022
 
 Phone number - 678-713-5809 
 
 Fax 678-459-1068
 
 Email:   mailto:sha...@suntechnologies.com sha...@suntechnologies.com  
 
 http://www.suntechnologies.com/ http://www.suntechnologies.com
 
 
 
 Disclaimer: We respect your on-line privacy. This is not an unsolicited
 mail. Under Bill 1618 Title III passed by the 105th US Congress this mail
 cannot be considered Spam as long as we include contact information and a
 method to be removed from our mailing list. If you are not interested in
 receiving our e-mails then please reply with a REMOVE in the subject line
 or  mailto:feedb...@suntechnologies.com click here to Remove your name
 from the mailing list. I am sorry for any inconvenience 
 
 
 
 

~|
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:355538
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Job Openings With Our Direct Client for COLD FUSION DEVELOPER@CHICAGO IL 60606 // SAN ANTONIO TX 78209 // ATLANTA GA 30308

2013-04-23 Thread Bruce Sorge

And I feel dumb for not realizing ha was posted to the list and not sent to me 
directly, hahahaha. 

Sent from my iPhone 4S. 

On Apr 23, 2013, at 9:15 AM, Raymond Camden raymondcam...@gmail.com wrote:

 
 You may have more luck if you use the actual name of the technology.
 ColdFusion, not Cold Fusion.
 
 
 On Tue, Apr 23, 2013 at 8:01 AM, Sharan sha...@suntechnologies.com wrote:
 
 
 Greetings from Sun Technologies!
 
 
 
 My name is Sharan Gowda and I'm a Recruiter at Sun Technologies Inc.
 
 
 
 Our records show that you have past or current experience with skills
 fitting a current opening with our Direct End Client. Please be aware that
 our database has searched out your resume based on key word skills, so
 please accept my apologies if this requirement does not match your current
 or preferred job profile or location preference.
 
 
 
 I would love to show my appreciation with referral fee(s) for anyone I hire
 through your referral/introduction/recommendation, including confidential
 referrals.  If you know anyone who is interested / qualified, please feel
 free to pass on my contact info as you see fit.
 
 
 
 Job Details
 
 
 
 Job Title: COLD FUSION DEVELOPER
 
 Job Location: CHICAGO IL  60606 // SAN ANTONIO  TX 78209  // ATLANTA GA
 30308
 
 Duration: EXPECTED TO BE 8 MONTHS CONTRACT WITH POSSIBLE EXTENSION
 
 Positions: 3
 
 
 
 PLEASE LIST IN THE SUPPLIMENTAL AREA WHERE CANDIDATE IS ELIGIABLE TO WORK
 
 
 
 This position will work on ColdFusion report development and migration for
 the new One Click initiative. The candidate must possess cross-browser
 web-development skills including IE (all versions), Firefox, Safari, and
 Chrome. Other critical skill sets include ColdFusion 9 or later and a
 working knowledge of SQL Server Query Design  Optimization  SQL Server
 Integration Services (SSIS), familiarity with Eclipse/CFEclipse or
 Dreamweaver, jQuery, HTML-4/5 and Cascading Style sheets.
 
 
 
 
 Skills Inventory
 
 
 
 
 
 
 Skill
 
 Experience
 
 Need
 
 
 1)
 
 Cold Fusion 10
 
 Expert
 
 Required
 
 
 2)
 
 SQL Server Query Design
 
 Expert
 
 Required
 
 
 3)
 
 CSS-2
 
 Expert
 
 Required
 
 
 4)
 
 HTML 4 (minimum)
 
 Expert
 
 Required
 
 
 5)
 
 JQuery
 
 Intermediate
 
 Desired
 
 
 6)
 
 Eclipse-Dreamweaver
 
 Intermediate
 
 Desired
 
 
 7)
 
 Webservices using XML
 
 Intermediate
 
 Required
 
 
 8)
 
 Prior ATT Experience
 
 Intermediate
 
 Desired
 
 
 
 Please fill the below information and send it along with your resume in
 word
 format:
 
 *   Visa status (Citizen / Green Card / TN / EAD/H1B):
 *   Expected Hourly Rate:
 *   Employment Type:
 *   Availability:
 *   Best number and time to reach you:
 
 Thanks  Regards,
 Sharan Gowda,
 Sun Technologies, Inc.
 3700 Mansell Road Suite 125
 
 Alpharetta GA 30022
 
 Phone number - 678-713-5809
 
 Fax 678-459-1068
 
 Email:   mailto:sha...@suntechnologies.com sha...@suntechnologies.com
 
 http://www.suntechnologies.com/ http://www.suntechnologies.com
 
 
 
 Disclaimer: We respect your on-line privacy. This is not an unsolicited
 mail. Under Bill 1618 Title III passed by the 105th US Congress this mail
 cannot be considered Spam as long as we include contact information and a
 method to be removed from our mailing list. If you are not interested in
 receiving our e-mails then please reply with a REMOVE in the subject line
 or  mailto:feedb...@suntechnologies.com click here to Remove your name
 from the mailing list. I am sorry for any inconvenience
 
 
 
 
 
 

~|
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:355539
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


I am stumped

2013-04-10 Thread Bruce Sorge

I have a site where a user is only supposed to register for one deal. I have 
this query:

cfquery datasource=#Request.LiveDSN# name=qCheckUserTable
SELECT Name, Birthdate, Email
FROM Users
WHERE Name = cfqueryparam cfsqltype=cf_sql_varchar 
value=#Form.SHIPTONAME# /
AND Birthdate = cfqueryparam cfsqltype=cf_sql_varchar 
value=#Birthdate# / 
OR Email = cfqueryparam cfsqltype=cf_sql_varchar 
value=#Form.Email# /
/cfquery

I then do this:

cfif qCheckUserTable.RecordCount GT 0

cfinclude template=header.cfm
BRBRBR
cfoutput#Form.SHIPTONAME#/cfoutput,
It appears that you have already registered for this deal. You can click 
the back button and enter another's information or quit the application. You 
can only register an individual for one deal only. 
cfinclude template=footer.cfm
cfabort
cfelse

blah blah blah

Well today someone managed to register more than once. In the db, the only 
difference is the birthdate, which should not matter since I am checking for 
their name, birthdate or email. The name and email in both records are 
identical. I ran this query against the db several times using different 
birth-dates and every time I get the records, which means the name/email search 
is working.  I suspect that this person tried for a while to get around this 
since her registrations were about an hour apart. Is there something that I am 
overlooking in the query? How would she have gotten by this? I am guessing I 
missed something very simple.

Thanks,

Bruce

~|
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:355344
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: I am stumped

2013-04-10 Thread Bruce Sorge

I put parens around the name and birthdate and it works fine now. 

Thanks,

Bruce
On Apr 10, 2013, at 4:01 PM, John M Bliss bliss.j...@gmail.com wrote:

 
 Agreed: next step: add parens to make it explicit. If *that* does not work,
 let us know.
 
 


~|
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:355348
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: I am stumped

2013-04-10 Thread Bruce Sorge

Well I could have Sworn it worked when I tested it. However I must've missed 
something.

Sent from my iPhone 4S. 

On 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.
 
 
 On Wed, Apr 10, 2013 at 3:13 PM, Bruce Sorge sor...@gmail.com wrote:
 
 
 I put parens around the name and birthdate and it works fine now.
 
 Thanks,
 
 Bruce
 On Apr 10, 2013, at 4:01 PM, John M Bliss bliss.j...@gmail.com wrote:
 
 
 Agreed: next step: add parens to make it explicit. If *that* does not
 work,
 let us know.
 
 

~|
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:355350
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: I am stumped

2013-04-10 Thread Bruce Sorge

This is MySQL. 

Sent from my iPhone 4S. 

On Apr 10, 2013, at 5:41 PM, Stephen Hait sh...@mindspring.com wrote:

 
 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:355352
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: I am stumped

2013-04-10 Thread Bruce Sorge

Yeah. I actually found this not too long ago. I have it bookmarked for future 
reference. 

Sent from my iPhone 4S. 

On Apr 10, 2013, at 6:01 PM, Stephen Hait sh...@mindspring.com wrote:

 
 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:355355
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Curmudgeon painted in a corner

2013-03-18 Thread Bruce Sorge

I don't understand the statement of a Mac owning me. I was a windows user since 
it first came out and a DOS user before then. In switched to a Mac about a year 
ago and I love it. I have CF10 running with apache, MySQL and php all working 
great. Using Adobe creative cloud for dev and I have no complaints. Once you 
get used to working in the terminal macs are easy to use and my machine in no 
way owns me. Just saying. And for the occasional instance where I HAVE to use 
windows, I have windows 8 running with bootcamp. No complaints and Windows 8 
screams on the Mac. Having 8 gigs of RAM helps too. 

Bruce

Sent from my iPhone 4S. 

On Mar 18, 2013, at 8:41 AM, Cameron Childress camer...@gmail.com wrote:

 
 On Sun, Mar 17, 2013 at 11:41 PM, Dave Long d...@northgoods.com wrote:
 
 Cameron, thanks anyway. I want to own the machine, not have the machine
 own me.
 
 
 Yeah, I'm not one to sell you on Mac, just interesting that no-one brought
 it up.
 
 -Cameron
 
 ...
 
 
 

~|
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:355065
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Curmudgeon painted in a corner

2013-03-18 Thread Bruce Sorge

Yeah, to be honest I would not have one had it not been for a client who 
offered to buy me ANY computer I wanted in exchange for doing a small site for 
his non-profit. So I went with a MacBook Pro 17 dual quad core processors and 
8gb of ram. 

Sent from my iPhone 4S. 

On Mar 18, 2013, at 7:22 PM, Maureen mamamaur...@gmail.com wrote:

 
 Likely referring to the cost of purchase.  Macs are pricy little buggers.
 
 On Mon, Mar 18, 2013 at 6:04 AM, Bruce Sorge sor...@gmail.com wrote:
 
 I don't understand the statement of a Mac owning me.
 
 

~|
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:355093
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


CFFILE Issue

2013-03-07 Thread Bruce Sorge

I am having something strange going on today with my dev machine. I have an app 
that writes a PDF:

cffile action=write file=pdf/Voucher#user_id#.pdf output=#Voucher# 
nameconflict=make unique

It has been working great, but today when I ran it I was given an java.io error 
that a folder did not exist. Funny thing was that it was looking at the 
following path:

ColdFusion10\cfusion\runtime\work\catalina\localhost\tmp\pdf. 
But as you can see in my cffile I am pointing to a local folder called PDF that 
is in the same directory as the .CFM file calling it. Any ideas?

Also, this is a duplicate of another app that I have that does the exact same 
thing, and it works fine. That app is in another directory, and the only 
difference is that this new one allows the site admin to generate a PDF for one 
customer where the other app I have sends PDF's to all users who bought 
something the day prior.

Thanks,

Bruce

~|
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:354881
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CFFILE Issue

2013-03-07 Thread Bruce Sorge

Yeah, I went the expand path route and pointed it to a pdf directory that was 
already accepting new vouchers and it works. I
On Mar 7, 2013, at 4:05 PM, Bobby bo...@acoderslife.com wrote:

 
 I'd probably start by trying one of these instead just to see if it made a
 difference:
 
 ./pdf/voucher#user_id#.pdf
 
 Or
 
 #expandPath('./pdf/')#  'voucher#user_id#.pdf'
 
 
 
 On 3/7/13 3:41 PM, Bruce Sorge sor...@gmail.com wrote:
 
 
 I am having something strange going on today with my dev machine. I have
 an app that writes a PDF:
 
 cffile action=write file=pdf/Voucher#user_id#.pdf output=#Voucher#
 nameconflict=make unique
 
 It has been working great, but today when I ran it I was given an java.io
 error that a folder did not exist. Funny thing was that it was looking at
 the following path:
 
 ColdFusion10\cfusion\runtime\work\catalina\localhost\tmp\pdf.
 But as you can see in my cffile I am pointing to a local folder called
 PDF that is in the same directory as the .CFM file calling it. Any ideas?
 
 Also, this is a duplicate of another app that I have that does the exact
 same thing, and it works fine. That app is in another directory, and the
 only difference is that this new one allows the site admin to generate a
 PDF for one customer where the other app I have sends PDF's to all users
 who bought something the day prior.
 
 Thanks,
 
 Bruce
 
 
 
 

~|
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:354884
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CFFILE Issue

2013-03-07 Thread Bruce Sorge

Hi Dave,
On my dev machine it did not exist, but it worked, and it worked on the live 
server. The only real change I made was I created a new directory in the admin 
folder called pdf so that the new one's get generated there. I updated the 
permissions on my dev machine to read/write for the cf user but no joy even 
when creating the pdf directory in the tmp directory. When I went the 
#expandpath()# route though, and pointed the PDF's to the directory where the 
other one's are written, it worked fine. It's just outside of the admin folder 
but I really don't care since the other one is also outside of the admin 
directory. I was just trying to keep add admin stuff inside the admin folder.

 
 CF often writes files to a local temp directory before putting them in
 their final destination. That's probably what's happening here. Does
 the temp directory exist? Does CF have permission to write to it?
 
 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 http://training.figleaf.com/
 
 Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
 GSA Schedule, and provides the highest caliber vendor-authorized
 instruction at our training centers, online, or onsite.


~|
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:354887
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: SOT: Graphic Artist Software for HTML CSS

2013-02-22 Thread Bruce Sorge

Fireworks does a good job as well. 

Sent from my iPhone 4S. 

On Feb 22, 2013, at 12:04 PM, Gerald Guido gerald.gu...@gmail.com wrote:

 
 In the past I have used Photoshop's Slice tool. It does a fairly decent job
 but I have always had to go in and massage it by hand. It does not by any
 means leave you with finished product out of the box but it takes care of a
 lions share of the grunt work.
 
 HTH
 G!
 
 On Fri, Feb 22, 2013 at 11:38 AM, Chad Gray cg...@careyweb.com wrote:
 
 
 I have not kept track of all the graphic artist software adobe has come
 out with to go from mockups to HTML/CSS.
 
 
 
 If I were to tell a graphic designer to design me some mockups for a web
 site, what is the best adobe software that will export out to _CLEAN_
 (looks like hand written J) HTML/CSS that I can inject my CF code easily
 into?
 
 
 
 Muse?
 
 
 
 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:354633
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CF10 Std Educational Pricing

2013-02-22 Thread Bruce Sorge

Does this help?

http://www.adobe.com/products/coldfusion-family.edu.html

On Feb 22, 2013, at 12:41 PM, Mosh Teitelbaum mosh.teitelb...@evoch.com wrote:

 
 All:
 
 In the past there has been reduced pricing for educational licenses of 
 ColdFusion Standard.  From what I can tell from the Adobe website, there does 
 not appear to be such a reduced price for CF10.  Is that the case?  If not, 
 can anyone recommend a vendor for educationally-priced CF10 Standard?
 
 Thanks.
 
 --
 Mosh Teitelbaum
 evoch, LLC
 http://www.evoch.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:354636
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CF10 Std Educational Pricing

2013-02-22 Thread Bruce Sorge

Disregard that last one. I saw the tiny print that it does not have an edu 
pricing scheme anymore. 

Bruce

On Feb 22, 2013, at 12:41 PM, Mosh Teitelbaum mosh.teitelb...@evoch.com wrote:

 
 All:
 
 In the past there has been reduced pricing for educational licenses of 
 ColdFusion Standard.  From what I can tell from the Adobe website, there does 
 not appear to be such a reduced price for CF10.  Is that the case?  If not, 
 can anyone recommend a vendor for educationally-priced CF10 Standard?
 
 Thanks.
 
 --
 Mosh Teitelbaum
 evoch, LLC
 http://www.evoch.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:354637
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: SOT: Graphic Artist Software for HTML CSS

2013-02-22 Thread Bruce Sorge

I have been messing around with Fireworks CS6 and it does a really good job of 
slicing pages. I never really messed with Photoshop though so I cannot compare 
them. 
On Feb 22, 2013, at 3:50 PM, Bobby bo...@acoderslife.com wrote:

 
 In the beginning, I actually sliced designs. When I did, I used Image
 Ready. It was much better suited for the slicing part than Photoshop.
 
 


~|
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:354642
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


A little help with jquery/cfm

2013-02-12 Thread Bruce Sorge

Hey all,
I have an app that is running great. User enters a code into a form field, and 
it checks the db to see if it's valid. If not they can't move on. Problem is 
that now the customer wants to be able to enter either the 2-5 character code 
OR the long name. For instance, you could enter AS or Adaptive Sports. I am not 
sure how to add this functionality into this code below as I did not write the 
query, I found it on-line and modified it for my site.

JQuery:

script src=js/jquery.js type=text/javascript/script
script type=text/javascript
pic1 = new Image(16, 16); 
pic1.src = images/loader.gif;

$(document).ready(function(){

$(#orgname).change(function() { 

var usr = $(#orgname).val();

if(usr.length = 2)
{
$(#status).html('img align=absmiddle src=images/loader.gif / Checking 
Code...');

$.ajax({ 
type: POST, 
url: checkcode.cfm, 
data: orgname=+ usr, 
success: function(msg){ 

$(#status).ajaxComplete(function(event, request, settings){ 

if(msg == 'OK')
{ 
$(#orgname).removeClass('object_error'); // if necessary
$(#orgname).addClass(object_ok);

$(this).html(' img align=absmiddle src=images/accepted.png / ');
} 
else 
{ 
$(#orgname).removeClass('object_ok'); // if necessary
$(#orgname).addClass(object_error);
$(this).html(msg);


}});}});}
else
{
$(#status).html('The Code should have at least 2 characters.');
$(#orgname).removeClass('object_ok'); // if necessary
$(#orgname).addClass(object_error);
}});});

//--

/script

Here is the check code.cfm page:

cfsetting showdebugoutput=false
 !--- Set the orgname to blank first ---
cfparam name=orgname default=

!--- Query the organizations table for all of the org names ---
cfquery name=checkName datasource=#request.dataSource#
   SELECT orgname, orglongname
   FROM organizations
/cfquery

 !--- put the names into a list ---
cfset orgnamelist = valueList(checkname.orgname, ,)

!--- Check the list against the name entered. If there is a match, then code 
is valid, otherwise conde is invalid ---
cfif listFindNoCase(orgnamelist, orgname)
cfset available = 'span style=color: Green;Code is valid./span'
cfelse
cfset available = 'span style=color: red;The Code b #orgname#/b is an 
invalid code. br /Please re-enter your code./span'
/cfif
cfoutput#available#/cfoutput 

Hopefully someone can help. The client put out a huge email blast today and 
then as an afterthought wanted the added functionality since someone already 
tried to enter the long name rather than the code as instructed.

Thanks,

Bruce

~|
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:354488
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: A little help with jquery/cfm

2013-02-12 Thread Bruce Sorge

The think is that the check is not done when they post, it's done when they 
enter the code, then shift the focus form the form field. 

Bruce
On Feb 12, 2013, at 8:42 PM, Brian Cain bcc9...@gmail.com wrote:

 
 You should move your check into the WHERE clause of the query (WHERE  orgname 
 = '#orgname#' or orglongname ='#orgname#') and change the listfindnocase 
 condition to checkname.recordcount GT 0.  There is no need to return the 
 entire record set and then convert it to a list.  Get rid is the orgnamelist 
 variable all together.  That is a waste of resources.
 
 To be on the safe side you should also use cfqueryparam to wrap the variables 
 in your SQL statement to prevent SQL injection attacks.
 
 Brian Cain
 
 
 


~|
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:354490
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: A little help with jquery/cfm

2013-02-12 Thread Bruce Sorge

Yeah, I had a brain fart. This fixed it:

 cfsetting showdebugoutput=false
 !--- Set the orgname to blank first ---
cfparam name=form.orgname default=

!--- Query the organizations table for all of the org names ---
cfquery name=checkName datasource=#request.dataSource#
   SELECT orgname, orglongname
   FROM organizations
   WHERE orgname = cfqueryparam value=#form.orgname# 
cfsqltype=cf_sql_varchar OR orglongname = cfqueryparam 
value=#form.orgname# cfsqltype=cf_sql_varchar

/cfquery

!--- Check the list against the name entered. If there is a match, then code 
is valid, otherwise code is invalid ---

cfif LEN(checkName.orgname) OR LEN(checkName.orglongname)

cfset available = 'span style=color: Green;Code is valid./span'
cfelse
cfset available = 'span style=color: red;The Code b #orgname#/b is an 
invalid code. Please re-enter your code./span'
/cfif
cfoutput#available#/cfoutput 

~|
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:354492
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Nesting Issue?

2013-02-08 Thread Bruce Sorge

Hey all,
I have an app that at midnight each day, queries a database and fires of an 
email with a .PDF attachment for a ski voucher. The problem is that each person 
is getting not only their voucher but the others who registered as well. Here 
is what I am doing:

cfquery datasource=DealsDSN name=qGetUseremail
SELECT Name, Address_1, Address_2, City, State, Zip, Email, BarCode, 
ACC_Code, BirthDate, Deal_Name, DateRegistered, Time_Registered, 
Confirmation_Number
FROM MAH.Users
WHERE DateRegistered = '#DateFormat(Yesterday,mm/dd/)#' AND BarCode 
IS NOT NULL
/cfquery

cfoutput query = qGetUserEmail

 cfdocument
name=Voucher
format=PDF
pagetype=custom
pageheight=5
pagewidth=6.5
margintop=0
marginbottom=0
marginright=0
marginleft=0
unit=in
fontembed=true
backgroundvisible=true
localurl=true
cfoutput

Voucher formatting goes here
/cfoutput

/cfdocument
cfmail from=x to=#Email#  subject=Voucher Barcode type=html

Email message here

cfmailparam
file=Voucher.pdf
type=application/pdf
content=#Voucher#
/ 
 /cfmail 
/cfoutput

When I dump the information I get one row of the users information with X 
number of barcodes. What do I need to do to ensure that the intended recipient 
only receives their barcode? I am sure it's simple but again, I have been out 
of the CF game a while and the obvious is escaping me.

Brue

~|
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:354403
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Nesting Issue?

2013-02-08 Thread Bruce Sorge

So I am guessing that I do this:

cfset VoucherName = Voucher#user_id#, then cfdocument name=#VoucherName# Â…Â…
./cfdocument

So then I figured I could use #VoucherName# in the content part of the 
cfmailparam tag. To be sure I did a cfdump of #VoucherName#, and as I expected 
I get Voucher12, voucher13Â…Â… and not the pdf binary like I would expect. I am 
at work right now and don't have the bandwidth to load the site onto the test 
server and test it out and I don't have an SMTP server on my laptop so I will 
have to wait until I get home (I supervise a range on base and am tagging onto 
a very weak signal). 
But, looking at what I am proposing do uyou all think that this will work? I am 
thinking no because I don't get the pdf binary on my screen with the dump.
Again, apologies for my lack of grasping the obvious. I've been working more on 
PHP and less in CF so am still pretty rusty.

Thanks
Bruce
On Feb 8, 2013, at 10:52 AM, Dave Watts dwa...@figleaf.com wrote:

 
 I have an app that at midnight each day, queries a database and fires of an 
 email with a .PDF attachment for a ski voucher. The
 problem is that each person is getting not only their voucher but the others 
 who registered as well. Here is what I am doing:
 
 cfquery datasource=DealsDSN name=qGetUseremail
SELECT Name, Address_1, Address_2, City, State, Zip, Email, BarCode, 
 ACC_Code, BirthDate, Deal_Name, DateRegistered, Time_Registered, 
 Confirmation_Number
FROM MAH.Users
WHERE DateRegistered = '#DateFormat(Yesterday,mm/dd/)#' AND BarCode 
 IS NOT NULL
 /cfquery
 
 cfoutput query = qGetUserEmail
 
 cfdocument
 name=Voucher
 
 I suggest you create a unique name for each voucher.
 
 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 http://training.figleaf.com/
 
 Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
 GSA Schedule, and provides the highest caliber vendor-authorized
 instruction at our training centers, online, or onsite.
 
 

~|
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:354412
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Nesting Issue?

2013-02-08 Thread Bruce Sorge

It's a feature that was introduced in version 9 I believe. It lets you send the 
contents of a CF variable as an attachment. 

Bruce

On Feb 8, 2013, at 2:23 PM, Brian McCairn brian.mcca...@medicapp.eu wrote:

 
 Are the cfmailparam parameters right? I haven't seen a content parameter 
 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:354416
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Nesting Issue?

2013-02-08 Thread Bruce Sorge

So this did not work and I am kind of desperate here. Any ideas?

Bruce

On Feb 8, 2013, at 12:39 PM, Bruce Sorge sor...@gmail.com wrote:

 So I am guessing that I do this:
 
 cfset VoucherName = Voucher#user_id#, then cfdocument name=#VoucherName# 
 Â…Â…./cfdocument
 
 So then I figured I could use #VoucherName# in the content part of the 
 cfmailparam tag. To be sure I did a cfdump of #VoucherName#, and as I 
 expected I get Voucher12, voucher13Â…Â… and not the pdf binary like I would 
 expect. I am at work right now and don't have the bandwidth to load the site 
 onto the test server and test it out and I don't have an SMTP server on my 
 laptop so I will have to wait until I get home (I supervise a range on base 
 and am tagging onto a very weak signal). 
 But, looking at what I am proposing do uyou all think that this will work? I 
 am thinking no because I don't get the pdf binary on my screen with the dump.
 Again, apologies for my lack of grasping the obvious. I've been working more 
 on PHP and less in CF so am still pretty rusty.
 
 Thanks
 Bruce
 On Feb 8, 2013, at 10:52 AM, Dave Watts dwa...@figleaf.com wrote:
 
 
 
 I suggest you create a unique name for each voucher.
 


~|
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:354423
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Nesting Issue?

2013-02-08 Thread Bruce Sorge

I got rid of the extra cfoutput. Everything is wrapped into just the output 
query

Bruce
On Feb 8, 2013, at 4:46 PM, morgan lindley greyk...@gmail.com wrote:

 
 I suspect this is causing the problem. As someone else mentioned, nesting
 cfoutputs without a group attribute in the outermost cfoutput used to throw
 an error. In CF10, the inner cfoutput block loops over the remaining values
 of the query in each iteration through the outer cfoutput.
 
 On Fri, Feb 8, 2013 at 9:31 AM, Bruce Sorge sor...@gmail.com wrote:
 
 cfoutput
 
Voucher formatting goes here
 /cfoutput
 
 
 
 

~|
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:354425
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Nesting Issue?

2013-02-08 Thread Bruce Sorge

So I managed to resolve this issue. Here is what I did:

Create the document:
cfoutput query = qGetUserEmail

 cfdocument
name=Voucher
format=PDF
pagetype=custom
pageheight=9
pagewidth=8
margintop=0
marginbottom=0
marginright=0
marginleft=0
unit=in
fontembed=true
backgroundvisible=true
localurl=true
/cfdocument

Set the folder location for the PDF to be created
cfset PDFFolder = #ExpandPath(../pdf)#

Write the pdf to the server, creating a unique name from the user_id field in 
the DB
cffile action=write file=#PDFFolder#/Voucher#user_id#.pdf 
output=#Voucher# nameconflict=makeunique
 
Attach the PDF to the email using the unique file

  cfmail from=x to=#Email# subject=Voucher Barcode type=html 
mimeattach=#PDFFolder#/Voucher#user_id#.pdf

Dear #Name#,br
Attached please find your voucher for #Deal_Name#brbr


 /cfmail  

Crisis averted and we are going live now.

Bruce


 


~|
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:354429
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Nesting Issue?

2013-02-08 Thread Bruce Sorge

I resolved this, but everyone was getting their own email but they would get 
the other people's vouchers in addition to their own. 

Sent from my iPhone 4S. 

On Feb 8, 2013, at 6:38 PM, Eric Roberts ow...@threeravensconsulting.com 
wrote:

 
 Is it a case of just one person getting the mail or random people not
 getting it?
 
 -Original Message-
 From: Bruce Sorge [mailto:sor...@gmail.com] 
 Sent: Friday, February 08, 2013 3:48 PM
 To: cf-talk
 Subject: Re: Nesting Issue?
 
 
 I got rid of the extra cfoutput. Everything is wrapped into just the output
 query
 
 Bruce
 On Feb 8, 2013, at 4:46 PM, morgan lindley greyk...@gmail.com wrote:
 
 
 I suspect this is causing the problem. As someone else mentioned, 
 nesting cfoutputs without a group attribute in the outermost cfoutput 
 used to throw an error. In CF10, the inner cfoutput block loops over 
 the remaining values of the query in each iteration through the outer
 cfoutput.
 
 On Fri, Feb 8, 2013 at 9:31 AM, Bruce Sorge sor...@gmail.com wrote:
 
 cfoutput
 
   Voucher formatting goes here
 /cfoutput
 
 
 
 
 
 
 
 

~|
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:354437
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Posting question

2013-01-30 Thread Bruce Sorge

Probably want to post it to cf-jobs


On Jan 30, 2013, at 3:31 PM, Ken Hammond khamm...@saleminc.com wrote:

 
 If I have a project I need someone with experience to work on, can I post it 
 here?
 
 Ken Hammond
 
 IT Director
 The Salem Group
 Phone: 630-873-3018
 Fax: 630-932-7010
 Email: khamm...@saleminc.com
 
 www.saleminc.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:354168
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Tracking Link Click

2013-01-08 Thread Bruce Sorge

Hello all,
I have a site where once a user registers they are taken to a page with three 
links to a movie to download (normal, hearing impaired and vision impaired). 
hat I want to do is track which movie is downloaded. The problem is that the 
movies are stored off site on another server (yousendit.com). So I guess this 
is an outbound link? How would i go about doing this? Do I do a separate CFM 
page that tracks the URL then does a quick redirect to the actual download?

Thanks,

Bruce

~|
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:353799
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Tracking Link Click

2013-01-08 Thread Bruce Sorge

Yeah, I got it figured out. Just sent it to another page that captured the URL 
variables, pulled out what I needed to insert into the db then did a redirect 
to the download. 

Bruce


On Jan 8, 2013, at 9:43 AM, Brian Thornton br...@cfdeveloper.com wrote:

 
 Yes or embed it on a page you own and hidden ajax download call
 On Jan 8, 2013 7:46 AM, Bruce Sorge sor...@gmail.com wrote:
 
 
 Hello all,
 I have a site where once a user registers they are taken to a page with
 three links to a movie to download (normal, hearing impaired and vision
 impaired). hat I want to do is track which movie is downloaded. The problem
 is that the movies are stored off site on another server (yousendit.com).
 So I guess this is an outbound link? How would i go about doing this? Do I
 do a separate CFM page that tracks the URL then does a quick redirect to
 the actual download?
 
 Thanks,
 
 Bruce
 
 
 
 

~|
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:353812
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Spammers are stupid

2012-12-30 Thread Bruce Sorge

So since occasional messages from this list and random legitimate emails from 
other sources somehow end up in my spam folder, I actually have to look at the 
folder contents. As I was moving legitimate messages out, I came across an ad 
about BBW dating. Funny thing was, the girl in the picture was anything but 
BBW. Very much in shape actually. I wonder if the idiot who actually took the 
time to create the graphic actually knows what a BBW is.
Spammers make me laugh, and after being up for over 24 hours because I had duty 
yesterday, I needed a good laugh.

Happy New Year

Bruce

~|
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:353721
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: AJAX Issue

2012-12-23 Thread Bruce Sorge

Thanks for the Video Ray. It was very helpful for debugging another part of 
this site. Finally finished it though bug free and functions the way I want.

Bruce
On Dec 20, 2012, at 9:55 PM, Raymond Camden raymondcam...@gmail.com wrote:

 
 Here is a video demonstrating chrome dev tools:
 
 http://www.raymondcamden.com/index.cfm/2011/6/15/Example-of-using-Chrome-Dev-tools-to-solve-Ajax-issues
 
 


~|
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:353652
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Script Issue

2012-12-20 Thread Bruce Sorge

I needed a way to check a database when someone enters a code into a form 
field, and I ran across an old posting from Ray Camden using SPRY assets to 
accomplish this. (I know that I should probably use AJAX or jQuery, but I have 
not learned these languages yet so I am stuck going off of what I can find on 
line).
Anyway, when I enter a code into the field, I get an error Exception caught 
while loading checkcode.cfm?orgname=AA; Cannot set property 'innerHTML' of null.

Here is the code below:

script
Spry.Data.Region.debug = true;

function checkorgname() {

var uvalue = document.getElementById(orgname).value;
if(uvalue.length  2) { status(''); return; }


Spry.Utils.loadURL(GET,checkcode.cfm?orgname=+encodeURIComponent(uvalue), 
false, orgcheck);
}

function orgcheck(request) {

var result = request.xhRequest.responseText;

if(result == 0) status('You have entered an invalid code. 
Please try again!');
 else status('');

}

function status(str) {

var resultblock = document.getElementById(resultblock);
resultblock.innerHTML = str;

}
/script

form field in question:

 input type=text name=orgname id=orgname size=10 required 
class=upper onKeyUp=checkorgname();  /

The checkcode.cfm page works fine though. When I call it on it's own I get 
either a 0 or 1 depending if the orgname in the URL variable is in the database.


Thanks,

Bruce

~|
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:353556
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Script Issue

2012-12-20 Thread Bruce Sorge

Yeah, I forgot that. Thanks. Now the issue is that when I enter a code in the 
database, I don't get any message at all. This is driving me nuts. And again, I 
know that the calling CFM file works and I also know that the script is calling 
the checkorgname.cfm file because if I change the name of it it throws a 404 
error. 

Bruce
On Dec 20, 2012, at 10:14 AM, Raymond Camden raymondcam...@gmail.com wrote:

 
 The error is on this line,
 
   var resultblock = document.getElementById(resultblock);
 
 So ensure you have a div or span with that ID.
 
 


~|
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:353559
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Script Issue

2012-12-20 Thread Bruce Sorge

I didn't see anything that stands out. What's interesting is that if I change 
this line from this:

if(result == 0) status('You have entered an invalid code. Please try again!');
 else status('');

to this:

if(result == 0) status('You have entered an invalid code. Please try again!');
 else status('Code is valid');

no matter what code I put in, valid or invalid, I get the response Code is 
valid. I'll have to dig into this deeper to see what's going on.

Bruce


~|
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:353563
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Script Issue

2012-12-20 Thread Bruce Sorge

No matter what I put in, I get a 1 as the result var.
On Dec 20, 2012, at 12:00 PM, Raymond Camden raymondcam...@gmail.com wrote:

 
 So what is result? If you use the XHR portion of your JS console you can
 see it, or just plain alert() 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:353566
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Script Issue

2012-12-20 Thread Bruce Sorge

What is really pissing me off about this issue is that even if I copy your 
example verbatim and it does not work. I even went to the source of your 
example and copied and pasted and it did not work on my test machine. I might 
just roll it out to the production site since it's not done yet and see. What's 
weird is I can go directly to the page that is being called in the background, 
and dump the names, add the username=victor or whatever and it returns the 
value 0 which I is what it is supposed to do. Even when I just my db query and 
enter an invalid code it works fine. Just when I call it from the form it 
returns 1 every time. Frustrating. But I won't let it kick my ass.

Bruce


On Dec 20, 2012, at 12:58 PM, Raymond Camden raymondcam...@gmail.com wrote:

 
 Then you need to debug in your CFM.
 
 


~|
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:353589
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


AJAX Issue

2012-12-20 Thread Bruce Sorge

OK, so I gave up on the Spry version of the database validation and moved onto 
AJAX (a language I really don't know a lot about but I am slowly figuring it 
out). Anyway, I have the code working the way I want with the exception that 
when the validation is done, whether the code is valid or not, the page is 
reloading and showing an overlay or something of the page. If you go to 
http://www.makeaherodonations.com/themovement/ you'll see what I am talking 
about. It's weird and I have been trying to figure this out. Here is the script:

script src=js/jquery.js type=text/javascript/script
script type=text/javascript
pic1 = new Image(16, 16); 
pic1.src = images/loader.gif;

$(document).ready(function(){

$(#orgname).change(function() { 

var usr = $(#orgname).val();

if(usr.length = 2)
{
$(#status).html('img align=absmiddle src=images/loader.gif / Checking 
Code...');

$.ajax({ 
type: POST, 
url: checkcode.cfm, 
data: orgname=+ usr, 
success: function(msg){ 

$(#status).ajaxComplete(function(event, request, settings){ 

if(msg == 'OK')
{ 
$(#orgname).removeClass('object_error'); // if necessary
$(#orgname).addClass(object_ok);
$(this).html(' img align=absmiddle src=images/accepted.png / ');
} 
else 
{ 
$(#orgname).removeClass('object_ok'); // if necessary
$(#orgname).addClass(object_error);
$(this).html(msg);
}});}});}
else
{
$(#status).html('The Code should have at least 2 characters.');
$(#orgname).removeClass('object_ok'); // if necessary
$(#orgname).addClass(object_error);
}});});

//--

/script

I think that I'll have to head to the bookstore tomorrow and get me an AJAX 
book. It seems pretty cool and something that I can use in the future.

Bruce

~|
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:353590
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: AJAX Issue

2012-12-20 Thread Bruce Sorge

Thanks Ray, I'll look into this for sure. And yeah, I am wrapping all the pages 
in a header, footer and nab in the application.cfc. I'll switch it to an 
include in the page instead. I've been out of web development for about 4 years 
and have obviously fallen behind the knowledge curve. Thanks for the input I'll 
work on this stuff tomorrow. 

Sent from my iPhone 4S. 

On Dec 20, 2012, at 9:55 PM, Raymond Camden raymondcam...@gmail.com wrote:

 
 Here is a video demonstrating chrome dev tools:
 
 http://www.raymondcamden.com/index.cfm/2011/6/15/Example-of-using-Chrome-Dev-tools-to-solve-Ajax-issues
 
 
 On Thu, Dec 20, 2012 at 8:54 PM, Raymond Camden 
 raymondcam...@gmail.comwrote:
 
 As to your error, it is very obvious if you use the Chrome Dev Tools. I
 cannot stress this enough. You *need* to learn how to use your browser dev
 tools as it makes this stuff a heck of a lot easier.
 
 I opened it up in Chrome, went to the Network panel, filtered on XHR. I
 then entered 88 in the first form field.
 
 I then saw a big ole graphic load. Why? It's obvious if you look at the
 result in the Network panel. Your server returned this:
 
 !doctype html
 html
 head
 meta charset=UTF-8
 meta name=Keywords content=The Movement, Make A Hero, makeahero.org,
 veterans, disabled american veterans, veterans of forign wars, Iraq
 veteran, Afghanistan veteran, disabled veteran, disabilities, the movement
 DVD/
 meta name=Description content=For The Movement DVD Free Download/
 link type=text/css 
 href=Styles/Movement.csshttp://www.makeaherodonations.com/themovement/Styles/Movement.css
  rel=stylesheet
 link rel=shortcut icon type=image/x-icon 
 href=favicon.icohttp://www.makeaherodonations.com/themovement/favicon.ico
 
 
 
 
 titleThe Movement DVD Download - Information/title
 /head
 
 header
 div id=head
 /div
 DIV id=navbar
 /DIV
 /header
 
 
 
 nav
 img 
 src=images/MAH-ski.jpeghttp://www.makeaherodonations.com/themovement/images/MAH-ski.jpeg
  alt=The Movement Movie Poster Image /
 /nav span style=color: red;The Code b 88/b is an invalid code.
 Please ree-enter your code./span footer
 pa href=http://www.makeahero.org; target=newimg src=
 images/logo.pnghttp://www.makeaherodonations.com/themovement/images/logo.png
  alt=Make A Hero Logo //aBR /
 emHelping individuals with disabilities enjoy the freedom of sports
 and recreation/em/p
 p class=align
 Thank you for your interest in Make A Hero's first film, The Movement! If
 you would like to use this film as a fund-raiser please email a href=
 mailto:i...@makeahero.orghttp://www.makeaherodonations.com/themovement/mailto:i...@makeahero.org
 i...@makeahero.org/a. For more information about our organization or
 ways that you can support our cause, please visit a href=
 http://www.makeahero.org; target=newhttp://makeahero.org/a or email 
 a 
 href=mailto:i...@makeahero.orghttp://www.makeaherodonations.com/themovement/mailto:i...@makeahero.org
 i...@makeahero.org/a.
 /footer
 
 /body
 /html
 
 Most likely you ONLY wanted the The code... part. Most likely your CF
 code is wrapping everything with a header and footer. You need to stop
 doing that. :)
 
 
 
 On Thu, Dec 20, 2012 at 8:51 PM, Raymond Camden 
 raymondcam...@gmail.comwrote:
 
 I'll take a look, but I need to nitpick something. AJAX isn't a language.
 It is simply the name of a technique used in JavaScript to communicate with
 a server. Spry uses AJAX too. (But don't use Spry anymore. It's old like
 Donkey Kong.)
 
 
 On Thu, Dec 20, 2012 at 7:49 PM, Bruce Sorge sor...@gmail.com wrote:
 
 
 OK, so I gave up on the Spry version of the database validation and
 moved onto AJAX (a language I really don't know a lot about but I am slowly
 figuring it out). Anyway, I have the code working the way I want with the
 exception that when the validation is done, whether the code is valid or
 not, the page is reloading and showing an overlay or something of the page.
 If you go to http://www.makeaherodonations.com/themovement/ you'll see
 what I am talking about. It's weird and I have been trying to figure this
 out. Here is the script:
 
 script src=js/jquery.js type=text/javascript/script
 script type=text/javascript
 pic1 = new Image(16, 16);
 pic1.src = images/loader.gif;
 
 $(document).ready(function(){
 
 $(#orgname).change(function() {
 
 var usr = $(#orgname).val();
 
 if(usr.length = 2)
 {
 $(#status).html('img align=absmiddle src=images/loader.gif /
 Checking Code...');
 
 $.ajax({
 type: POST,
 url: checkcode.cfm,
 data: orgname=+ usr,
 success: function(msg){
 
 $(#status).ajaxComplete(function(event, request, settings){
 
 if(msg == 'OK')
 {
 $(#orgname).removeClass('object_error'); // if necessary
 $(#orgname).addClass(object_ok);
 $(this).html(' img align=absmiddle src=images/accepted.png / ');
 }
 else
 {
 $(#orgname).removeClass('object_ok'); // if necessary
 $(#orgname).addClass(object_error);
 $(this).html(msg);
 }});}});}
 else
 {
 $(#status).html('The Code should have at least 2 characters.');
 $(#orgname

Re: Need help finding new CF Hosting

2012-12-18 Thread Bruce Sorge

I are daily razor. They are good and allow you to set up dsn's via their 
administrator file. And they allow cffile. Their support is fast as well. 

Sent from my iPhone 4S. 

On Dec 18, 2012, at 10:32 AM, Dave Long d...@northgoods.com wrote:

 
 I'm trying to find a CF Hosting provider with 24/7 support and allows code
 such as CFILE plus access to the CF Administrator so I can add ODBC sources
 timely.
 
 Any suggestions?
 
 Dave Long
 NorthGoods Merchant Services
 
 
 

~|
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:353524
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Can this be improved

2012-12-01 Thread Bruce Sorge

Since I have been out of CF dev for several years, I thought I would work on 
some simple stuff. Looking at this code below, can this be improved?
I am using CF 10 with MySQL backend. I did not use stored procs because I have 
having issues with making them on MySQL since I am new to the db, so I know 
that is one improvement that I could make.


Thanks,

Bruce

Code snippet below:

!--- Insert users information into the database ---
cfquery datasource=#request.datasource#
INSERT INTO themovement.users
(firstname, lastname, email, zipcode, groupemail, orgid)
VALUES
(cfqueryparam value=#form.firstname# cfsqltype=cf_sql_varchar,
cfqueryparam value=#form.lastname# cfsqltype=cf_sql_varchar,
cfqueryparam value=#form.email# cfsqltype=cf_sql_varchar,
cfqueryparam value=#form.zipcode# cfsqltype=cf_sql_varchar,
cfqueryparam value=#form.friendemail# cfsqltype=cf_sql_varchar,
cfqueryparam value=#form.selectOrg# cfsqltype=cf_sql_integer)

 /cfquery
 
!--- Select the org ID and DL count from the database using the form variable 
for a match ---
 cfquery datasource=#request.datasource# name=qgetOrgID
SELECT orgid, dlcount
FROM themovement.dlcount
WHERE orgid = cfqueryparam value=#form.selectOrg# 
cfsqltype=cf_sql_integer
/cfquery

!--- If there is already an org ID in the database, then update the dlcount by 
one ---
cfif qgetorgID.recordcount GT 0
cfquery datasource=#request.datasource#
UPDATE themovement.dlcount
set dlcount = cfqueryparam value=#qgetOrgID.dlcount# 
cfsqltype=cf_sql_integer + 1
Where orgid = cfqueryparam value=#form.selectORg# 
cfsqltype=cf_sql_integer
/cfquery

!--- Otherwise we can assume that the org ID is not in the database and add it 
here, and set the DL count to 1 ---  
  cfelse
cfquery datasource=#request.datasource#
INSERT INTO themovement.dlcount
(orgid, dlcount)
VALUES
(cfqueryparam value=#form.selectOrg# cfsqltype=cf_sql_integer,
cfqueryparam value=1 cfsqltype=cf_sql_integer)
/cfquery
/cfif

~|
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:353322
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


How would I change this to a div

2012-09-21 Thread Bruce Sorge

I have several lines of code like this inside a cfoutput:

span 
style=border-right:#val(mid(code39[asc(mid(Attributes.InputValue,i,1))],1,1)*(Attributes.BarWidth)+(Attributes.BarWidth/2))#px
 solid; border-color: black; height: 
#Attributes.BarHeight#px;margin-bottom:#Attributes.MarginBottom#px;margin-top:#Attributes.MarginTop#px;/span

This generates a barcode and works fine in HTML, but when I try to insert the 
barcode in a PDF it does not show up. I searched online and it appears that 
cfdocument has an issue with span tags and I should use div instead. However, 
when I change the span tags to div the barcode is vertical instead of 
horizontal. I thought about creating several class properties inside a style 
tag but I admit that my HTML is weak since I have been out of programming for 
several years. Any ideas how I can accomplish this?


Thanks,

Bruce

~|
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:352697
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Issue with CF Barcode39

2012-09-21 Thread Bruce Sorge

I downloaded the font but my macbook is not picking it up. It recognizes other 
fonts that I have installed but not this one. Weird.

Bruce
On Sep 20, 2012, at 4:03 PM, Mike Kear afpwebwo...@gmail.com wrote:

 
 You might need to download a 3of9 truetype font and print the number you
 want in that font. it's just like printing 44557841 in TimesRoman,
 except you're printing it in Barcode3of9.  That's the way we've been
 printing barcodes for decades.
 
 Cheers
 Mike Kear
 Windsor, NSW, Australia
 Adobe Certified Advanced ColdFusion Developer
 AFP Webworks
 http://afpwebworks.com
 ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month


~|
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:352698
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: How would I change this to a div

2012-09-21 Thread Bruce Sorge

Unfortunately a P tag does not work either. Same result as a div. I can't 
figure this out. Maybe I need to make a way to save the barcode as an image 
then reference it the same as I do the company logo and the signature at the 
bottom.

Bruce
On Sep 21, 2012, at 11:19 AM, Russ Michaels r...@michaels.me.uk wrote:

 
 span is just a block element, you could use any other block element in it's
 place, just try with a P tag.
 the point in a span is that it doesn't have any pre-defined styles.
 
 On Fri, Sep 21, 2012 at 5:35 PM, Bruce Sorge sor...@gmail.com wrote:
 
 
 I have several lines of code like this inside a cfoutput:
 
 span
 style=border-right:#val(mid(code39[asc(mid(Attributes.InputValue,i,1))],1,1)*(Attributes.BarWidth)+(Attributes.BarWidth/2))#px
 solid; border-color: black; height:
 #Attributes.BarHeight#px;margin-bottom:#Attributes.MarginBottom#px;margin-top:#Attributes.MarginTop#px;/span
 
 This generates a barcode and works fine in HTML, but when I try to insert
 the barcode in a PDF it does not show up. I searched online and it appears
 that cfdocument has an issue with span tags and I should use div instead.
 However, when I change the span tags to div the barcode is vertical instead
 of horizontal. I thought about creating several class properties inside a
 style tag but I admit that my HTML is weak since I have been out of
 programming for several years. Any ideas how I can accomplish this?
 
 
 Thanks,
 
 Bruce
 
 
 


~|
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:352705
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: How would I change this to a div

2012-09-21 Thread Bruce Sorge

That did not work either. I did find a piece of code that actually generates a 
barcode as an image. So what I was thinking was creating an image with CF and 
then referencing that. Is there a way to create a new image in CF? I was 
looking at CFIMAGE but I do not see where I can pass the barcode text/numbers 
and make it into an actual image. The code I downloaded is encrypted so I can't 
make any changes to it.

Bruce

On Sep 21, 2012, at 1:27 PM, Russ Michaels r...@michaels.me.uk wrote:

 
 have to tried giving it a width to keep it horizontal
 


~|
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:352708
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: How would I change this to a div

2012-09-21 Thread Bruce Sorge

Well after realizing that I cannot access their java library with 
createObject(java), I decided that I am going to go ahead and change hosts. 
They suck balls. Never use DailyRazor.com unless you want to very basic stuff.

Bruce


On Sep 21, 2012, at 3:00 PM, Eric Roberts ow...@threeravensconsulting.com 
wrote:

 
 I was just thinking...if you use the Barcode 3of9 font someone had mentioned
 earlier, my cfc would probably work great with very little tweaking.
 
 
 Three Ravens Consulting
 Eric Roberts
 Owner/Developer
 ow...@threeravensconsulting.com
 tel: 630-486-5255
 fax: 630-310-8531
 http://www.threeravensconsulting.com
 
 
 -Original Message-
 From: Bruce Sorge [mailto:sor...@gmail.com] 
 Sent: Friday, September 21, 2012 3:49 PM
 To: cf-talk
 Subject: Re: How would I change this to a div
 
 
 That did not work either. I did find a piece of code that actually generates
 a barcode as an image. So what I was thinking was creating an image with CF
 and then referencing that. Is there a way to create a new image in CF? I was
 looking at CFIMAGE but I do not see where I can pass the barcode
 text/numbers and make it into an actual image. The code I downloaded is
 encrypted so I can't make any changes to it.
 
 Bruce
 
 On Sep 21, 2012, at 1:27 PM, Russ Michaels r...@michaels.me.uk wrote:
 
 
 have to tried giving it a width to keep it horizontal
 
 
 
 
 
 

~|
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:352713
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: How would I change this to a div

2012-09-21 Thread Bruce Sorge

I opened a support ticket regarding this and they are looking for a work 
around. I guess this is not the first complaint they have has. I just have to 
wait till I get home to send them my code.  

Sent from my iPhone 4S. 

On Sep 21, 2012, at 5:04 PM, Russ Michaels r...@michaels.me.uk wrote:

 
 be fair, you cannot say a host sucks just because they are secure.
 Allowing createObject(java) completely bypasses coldfusion sandboxes.
 If you are happy with any other customer on the server being able to
 read/write/delete your files, then you can find cf hosts out there that
 have no restrictions and allow everything.
 
 On Fri, Sep 21, 2012 at 10:33 PM, Bruce Sorge sor...@gmail.com wrote:
 
 
 Well after realizing that I cannot access their java library with
 createObject(java), I decided that I am going to go ahead and change hosts.
 They suck balls. Never use DailyRazor.com unless you want to very basic
 stuff.
 
 Bruce
 
 
 On Sep 21, 2012, at 3:00 PM, Eric Roberts ow...@threeravensconsulting.com
 wrote:
 
 
 I was just thinking...if you use the Barcode 3of9 font someone had
 mentioned
 earlier, my cfc would probably work great with very little tweaking.
 
 
 Three Ravens Consulting
 Eric Roberts
 Owner/Developer
 ow...@threeravensconsulting.com
 tel: 630-486-5255
 fax: 630-310-8531
 http://www.threeravensconsulting.com
 
 
 -Original Message-
 From: Bruce Sorge [mailto:sor...@gmail.com]
 Sent: Friday, September 21, 2012 3:49 PM
 To: cf-talk
 Subject: Re: How would I change this to a div
 
 
 That did not work either. I did find a piece of code that actually
 generates
 a barcode as an image. So what I was thinking was creating an image with
 CF
 and then referencing that. Is there a way to create a new image in CF? I
 was
 looking at CFIMAGE but I do not see where I can pass the barcode
 text/numbers and make it into an actual image. The code I downloaded is
 encrypted so I can't make any changes to it.
 
 Bruce
 
 On Sep 21, 2012, at 1:27 PM, Russ Michaels r...@michaels.me.uk wrote:
 
 
 have to tried giving it a width to keep it horizontal
 
 

~|
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:352716
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Issue with CF Barcode39

2012-09-20 Thread Bruce Sorge

Has anyone here used CFBARCODE? I am having a small issue with it.

Basically, I am creating a PDF using CFDOCUMENT and inside the PDF I am using 
CF_Barcdode39 to insert a barcode into the document that will be emailed to a 
customer. When I put the code into CFMAIL all works fine, images including 
barcode are there. But because someone can get that emal and put it into a word 
doc and change the barcode, they want to use a PDF instead. With the PDF, the 
logo and signature images are fine. But the barcode will not insert into the 
PDF and I really cannot figure out why. I have tried cfinclude as well as just 
putting cf_barcode in the code as I did below. Since the barcode is basically 
an image that is being created based on the actual barcode in the database, I 
put it in an IMG tag but still get the nice little red x on the document. Below 
is the code I am using. 
 

cfoutput query=qGetUserEmail

cfdocument format=PDF filename=Voucher.pdf overwrite=Yes localUrl=Yes

table width=900 border=0 cellspacing=1 cellpadding=1
  tr
td width=420 align=left valign=bottomimg src=Images/logo.png 
//td
td width=473 align=left valign=middle class=TEXTLEFT4840 PERL 
EAST CIRCLE, 210 W. span class=ORANGE| /spanBOULDER span 
class=ORANGE|/span CO span class=ORANGE|/span 80301/td
  /tr
  tr
td colspan=2 valign=tophr size=10 noshade=noshade /
  hr size=50 noshade=noshade color=##DE6E1B /
pnbsp;/p/td
  /tr
  tr
td colspan=2


Dear #F_Name# #L_Name#,
BR /
BR /
Thank you for your support of Make A Hero and #Deal_Name#! A 
portion of this lift ticket will go toward supporting local adaptive groups 
that help individuals with physical disabilities regain their freedom through 
skiing. Please spread the word about the great cause you have supported today 
by telling friends and family about this deal and other donation opportunities.
BR /
BR /
BR /
center This voucher is for #F_Name# #L_Name#, Birth date: 
#Birthdate#,BR /
Address: #Address_1#, cfif #Address_2# NEQ '' #Address_2#,/cfif 
#City#, #State#, #Zip#BR /
Your order was submitted on #DateRegistered# at #Time_Registered# 
for a #Deal_Name#!
BR /
BR /
BR /
bYour #Deal_Name# Resort Voucher ## is:/b
BR /br /
cfoutput
img src=CF_barcode39 
InputValue=#qGetUseremail.Barcode# BarWidth=2 BarHeight=50 TextTop= 
TextBottom=#qGetuserEmail.Barcode#
/cfoutput
BR /
NO CASH VALUE / NOT FOR RESALE / NON-TRANSFERABLE
BR /
BR /
BR /
/center
This is a restricted #Deal_Name# resort lift ticket voucher redeemable 
Monday through Friday between the hours of 9:00 am and 4:00 pm, excluding 
blackout dates. Only one voucher per person. This voucher is only for a single 
day lift ticket to #Deal_Name# Resort, redeemable at the box office with a 
physical copy of this voucher and a valid ID that has the matching name, 
address and birth date. Children using this voucher must be accompanied by a 
parent with a valid ID. Excluded blackout dates include: 11/19 - 11/23/2012; 
12/24 - 12/28/2012; 1/21/2013 and 2/18/2013.
BR /
To further support Make A Hero's cause of learn more information about 
our movement, please visit our website at www.makeahero.org, like us on a 
href=https://www.facebook.com/makeahero;Facebook/a or follow us on a 
href=https://twitter.com/MakeAHeroOrg;Twitter/a. If you  have any 
questions, please email a 
href=mailto:h...@makeahero.org;h...@makeahero.org/a with your Make A Hero 
reference number:#Confirmation_Number#

/td
  /tr
  tr
tdWith Sincere Thanks,BR /BR /

img src=Images/KurtSig.png width=186 height=94 
/BR /BR /

Make A Hero Founder
/td

  /tr
 
/table
/cfdocument
/cfoutput


Thanks,

Bruce

~|
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:352679
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Issue with CF Barcode39

2012-09-20 Thread Bruce Sorge

Nope, same exact issue


On Sep 20, 2012, at 12:25 PM, Chad Gray cg...@careyweb.com wrote:

 
 This is a guess, because I have no experience with the custom tag to make the 
 barcode image, but you may want to save the content out at a variable first.  
 Then put it in the cfdocument tag.  This has always worked best for me.
 
 
 cfsavecontent variable=voucher
 
table width=900 border=0 cellspacing=1 cellpadding=1
  tr
td width=420 align=left valign=bottomimg 
 src=Images/logo.png //td
td width=473 align=left valign=middle class=TEXTLEFT4840 
 PERL EAST CIRCLE, 210 W. span class=ORANGE| /spanBOULDER span 
 class=ORANGE|/span CO span class=ORANGE|/span 80301/td
   etc
 
 /cfsavecontent
 
 
 cfdocument format=PDF filename=Voucher.pdf overwrite=Yes 
 localUrl=Yes
 #variables. Voucher#
 /cfdocument
 
 
 -Original Message-
 From: Bruce Sorge [mailto:sor...@gmail.com] 
 Sent: Thursday, September 20, 2012 1:03 PM
 To: cf-talk
 Subject: Issue with CF Barcode39
 
 
 Has anyone here used CFBARCODE? I am having a small issue with it.
 
 Basically, I am creating a PDF using CFDOCUMENT and inside the PDF I am using 
 CF_Barcdode39 to insert a barcode into the document that will be emailed to a 
 customer. When I put the code into CFMAIL all works fine, images including 
 barcode are there. But because someone can get that emal and put it into a 
 word doc and change the barcode, they want to use a PDF instead. With the 
 PDF, the logo and signature images are fine. But the barcode will not insert 
 into the PDF and I really cannot figure out why. I have tried cfinclude as 
 well as just putting cf_barcode in the code as I did below. Since the barcode 
 is basically an image that is being created based on the actual barcode in 
 the database, I put it in an IMG tag but still get the nice little red x on 
 the document. Below is the code I am using. 
 
 
 
 
 

~|
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:352688
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Issue with CF Barcode39

2012-09-20 Thread Bruce Sorge

I did a CFDUMP on the varabies.voucher and copied and pasted it into an HTML 
document and the barcode shows up. What's interesting is that it won't work in 
a PDF, and I think that I know why. The dump code consists of all of the span 
tags that make up the barcode, so it's not actually an image, it's HTML 
formatting, but when creating the PDF it's not working right. Attached is a 
small sample:

span style=border-right:1px solid; border-color: black; height: 
50px;margin-bottom:0px;margin-top:0px; and so on and so on until the barcode 
is created. 

So it seems that making a PDF, it does not know what to do with the SPAN tag. 
This requires some more digging


Bruce


On Sep 20, 2012, at 12:25 PM, Chad Gray cg...@careyweb.com wrote:

 
 This is a guess, because I have no experience with the custom tag to make the 
 barcode image, but you may want to save the content out at a variable first.  
 Then put it in the cfdocument tag.  This has always worked best for me.
 
 
 cfsavecontent variable=voucher
 
table width=900 border=0 cellspacing=1 cellpadding=1
  tr
td width=420 align=left valign=bottomimg 
 src=Images/logo.png //td
td width=473 align=left valign=middle class=TEXTLEFT4840 
 PERL EAST CIRCLE, 210 W. span class=ORANGE| /spanBOULDER span 
 class=ORANGE|/span CO span class=ORANGE|/span 80301/td
   etc
 
 /cfsavecontent
 
 
 cfdocument format=PDF filename=Voucher.pdf overwrite=Yes 
 localUrl=Yes
 #variables. Voucher#
 /cfdocument
 
 
 -Original Message-
 From: Bruce Sorge [mailto:sor...@gmail.com] 
 Sent: Thursday, September 20, 2012 1:03 PM
 To: cf-talk
 Subject: Issue with CF Barcode39
 
 
 Has anyone here used CFBARCODE? I am having a small issue with it.
 
 Basically, I am creating a PDF using CFDOCUMENT and inside the PDF I am using 
 CF_Barcdode39 to insert a barcode into the document that will be emailed to a 
 customer. When I put the code into CFMAIL all works fine, images including 
 barcode are there. But because someone can get that emal and put it into a 
 word doc and change the barcode, they want to use a PDF instead. With the 
 PDF, the logo and signature images are fine. But the barcode will not insert 
 into the PDF and I really cannot figure out why. I have tried cfinclude as 
 well as just putting cf_barcode in the code as I did below. Since the barcode 
 is basically an image that is being created based on the actual barcode in 
 the database, I put it in an IMG tag but still get the nice little red x on 
 the document. Below is the code I am using. 
 
 
 
 
 

~|
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:352690
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Embedding image to a document that is attached to an email

2012-09-14 Thread Bruce Sorge

So after searching the docs, I found out that you have to do two things to 
embed an image to a PDF with CFDUCUMENT.

1. Set the localUrl variable to Yes
2. Use the path to the image relative to the file accessing it. Since my image 
is in the Images folder, my code was ing src=Images/logo.png / And it IS 
case sensitive. 

Bruce 

~|
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:352620
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Embedding image to a document that is attached to an email

2012-09-13 Thread Bruce Sorge

Here is what is weird;

If you go to http://www.makeaherodonations.com/test.cfm you see the logo.
If you go to http://www.makeaherodonations.com/Images/Logo.png you get a 404 
error.

The IMG SRC is Images/Logo.png. I am at a loss. It seems that if a file is 
there when you browse to it you should see it. Weird.

Bruce

On Sep 13, 2012, at 10:30 AM, .jonah jonah@creori.com wrote:

 
 Ok, so what is the url to the image that actually works in your browser 
 and what is the webroot for your server and the document root for that 
 particular 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:352580
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Embedding image to a document that is attached to an email

2012-09-13 Thread Bruce Sorge

How do I do that?

On Sep 13, 2012, at 10:57 AM, Russ Michaels r...@michaels.me.uk wrote:

 
 I notice on the 404 page it says
 HandlerColdFusion-wildcard
 
 which means that the coldfusion handler is processing the request for the
 image, which seems like the likley cause.
 try disabling the cf handler briefly just to see if this fixes the problem
 to the png image displaying a 404.
 
 


~|
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:352584
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Embedding image to a document that is attached to an email

2012-09-13 Thread Bruce Sorge

Im on a MAC


On Sep 13, 2012, at 12:04 PM, Russ Michaels r...@michaels.me.uk wrote:

 
 open the iis MMC, select your site, choose handlers, remove the wildcard
 handler for CF
 
 or run the wsconfig tool and use that to disable cf on the whole server
 
 
 On Thu, Sep 13, 2012 at 6:04 PM, Bruce Sorge sor...@gmail.com wrote:
 
 
 How do I do that?
 
 On Sep 13, 2012, at 10:57 AM, Russ Michaels r...@michaels.me.uk wrote:
 
 
 I notice on the 404 page it says
 HandlerColdFusion-wildcard
 
 which means that the coldfusion handler is processing the request for the
 image, which seems like the likley cause.
 try disabling the cf handler briefly just to see if this fixes the
 problem
 to the png image displaying a 404.
 
 
 
 
 
 
 

~|
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:352588
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Embedding image to a document that is attached to an email

2012-09-13 Thread Bruce Sorge

Yeah, that is the live server and I have no control over that. My testing 
server does the same thing and it's a MAC


Bruce



On Sep 13, 2012, at 12:24 PM, Russ Michaels r...@michaels.me.uk wrote:

 
 I can;t help you with MAC, but the url you sent earlier showed an IIS error
 page.
 


~|
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:352591
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Embedding image to a document that is attached to an email

2012-09-13 Thread Bruce Sorge

Well I am narrowing it down to the live server. I drug and dropped the image 
onto the code and put in the alternate text as well as a hyperlink attribute 
and ran it and I got the image on my machine. Loaded it up to the live server 
and I get the outline and alternate text on the PDF but not the image. And yes, 
initially I was using an uppercase L on Logo.png. It is case sensitive.

Bruce


On Sep 13, 2012, at 12:30 PM, morgan lindley greyk...@gmail.com wrote:

 
 As someone else pointed out, if you got to:
 http://www.makeaherodonations.com/Images/logo.pnghttp://www.makeaherodonations.com/Images/Logo.png
 the
 image loads fine. It appears the server is case-sensitive.
 


~|
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:352592
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Embedding image to a document that is attached to an email

2012-09-13 Thread Bruce Sorge

cfdocument format=PDF filename=Voucher.pdf overwrite=Yes



On Sep 13, 2012, at 12:49 PM, .jonah jonah@creori.com wrote:

 
 What tag do you have in the HTML to generate your PDF now?
 


~|
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:352594
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Embedding image to a document that is attached to an email

2012-09-13 Thread Bruce Sorge

img src=Images/logo.png width=413 height=87 alt=Make a Hero.org  /


On Sep 13, 2012, at 1:44 PM, .jonah jonah@creori.com wrote:

 
 Aahh, OK. And then the HTML code in that that's used to generate the 
 content of the PDF? (Well, just the img tag in question.)
 
 
 On 9/13/12 11:52 AM, Bruce Sorge wrote:
 cfdocument format=PDF filename=Voucher.pdf overwrite=Yes
 
 
 
 On Sep 13, 2012, at 12:49 PM, .jonah jonah@creori.com wrote:
 
 What tag do you have in the HTML to generate your PDF now?
 
 
 
 
 

~|
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:352600
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Embedding image to a document that is attached to an email

2012-09-13 Thread Bruce Sorge

No joy. This is so frustrating.


On Sep 13, 2012, at 3:30 PM, .jonah jonah@creori.com wrote:

 
 See if
 
 img src=/Images/logo.png width=413 height=87 alt=Make a Hero.org /
 
 works...
 
 
 
 On 9/13/12 1:42 PM, Bruce Sorge wrote:
 img src=Images/logo.png width=413 height=87 alt=Make a Hero.org  /
 
 
 

~|
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:352602
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Embedding image to a document that is attached to an email

2012-09-13 Thread Bruce Sorge

it has to be something with the server because in design view in DW I see the 
logo fine, and when I create the PDF on my laptop which is my dev machine the 
PDF has the logo fine. Just not on the live site.

Bruce

On Sep 13, 2012, at 3:30 PM, .jonah jonah@creori.com wrote:

 
 See if
 
 img src=/Images/logo.png width=413 height=87 alt=Make a Hero.org /
 
 works...
 
 
 
 On 9/13/12 1:42 PM, Bruce Sorge wrote:
 img src=Images/logo.png width=413 height=87 alt=Make a Hero.org  /
 
 
 

~|
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:352603
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Embedding image to a document that is attached to an email

2012-09-12 Thread Bruce Sorge

So I have a page that every day queries a db for new voucher registrations. I 
am using CFDOCUMENT to create a PDF for the voucher, then CFMAIL to attach the 
voucher to an email. Problem is that I cannot get the companies logo image to 
appear on the PDF. I am using the folllowing code:

cfoutput query=qGetUserEmail
cfdocument format=PDF filename=Voucher.pdf overwrite=Yes

table width=900 border=0 cellspacing=1 cellpadding=1
  tr
td width=416 align=left valign=bottomimg 
src=http://www.makeaherodonations.com/Images/Logo.png/td
...

/cfdocument

cfmail blah blah blah

blah blah blah

/cfmail
/cfoutput

I also tried expandpath but that did  not work either. Any suggestions?

Bruce



~|
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:352563
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Embedding image to a document that is attached to an email

2012-09-12 Thread Bruce Sorge

That does not work either

Bruce


On Sep 12, 2012, at 3:16 PM, Russ Michaels r...@michaels.me.uk wrote:

 
 you should reference the image locally, e.g.
 
 image src=images/bird.jpg
 
 


~|
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:352567
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Embedding image to a document that is attached to an email

2012-09-12 Thread Bruce Sorge

Yes I did.
On Sep 12, 2012, at 5:29 PM, Azadi Saryev azadi.sar...@gmail.com wrote:

 
 you use proper img tag and not Russ's mysterious image one, right?
 


~|
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:352569
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Embedding image to a document that is attached to an email

2012-09-12 Thread Bruce Sorge

I have done the following:

http://www.makeaherodonations.com/Images/Logo.png
C:\pathtoimage (I put the actual path but I won't put it on a public forum.
Images/Logo.png

No joy. I'll have to dig deeper into Google I guess.


On Sep 12, 2012, at 5:41 PM, .jonah jonah@creori.com wrote:

 
 And actually make the path absolute to the app root:
 
 img src=/images/site/logo_print.png alt=#siteName# name=logo/
 
 



~|
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:352571
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Alternative to CFOBJECT

2012-08-31 Thread Bruce Sorge

Her husband is a Major in the Army. She works for DHS.


On Aug 31, 2012, at 7:32 AM, Scott Stewart webmas...@sstwebworks.com wrote:

 
 She's only about 30 (ish) miles from where I'm living and she must be
 loaded... Great Falls is not a cheap area :)
 
 On Thu, Aug 30, 2012 at 7:56 PM, Bruce Sorge sor...@gmail.com wrote:
 
 
 I just looked it up and she is in great falls.
 
 Sent from my iPhone 4S.
 
 On Aug 30, 2012, at 2:50 PM, Scott Stewart webmas...@sstwebworks.com
 wrote:
 
 
 Where at in Alexandria?
 
 
 
 
 

~|
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:352388
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Alternative to CFOBJECT

2012-08-30 Thread Bruce Sorge

So I discovered today that the hosting company that I am using has disabled 
CFOBJECT, which sucks because the PayPal API that I am using uses the CFOBJECT 
tag. Is there an alternative to this?

Thanks,

Bruce

~|
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:352352
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Alternative to CFOBJECT

2012-08-30 Thread Bruce Sorge

This is everything that they disabled:

On the shared ColdFusion servers you will have access to all tags and functions 
except for the following:

CF Tags:
CFCOLLECTION
CFCONTENT
CFDUMP
CFEXECUTE
CFLOG
CFOBJECT
CFOBJECTCACHE
CFREGISTRY


CF Functions:
SetProfileString
CreateObject(COM)
CreateObject(CORBA)
CreateObject(JAVA)
On Aug 30, 2012, at 1:09 PM, Scott Stroz boyz...@gmail.com wrote:

 
 Have they disabled createObject() (they probably have, though)
 
 On Thu, Aug 30, 2012 at 3:04 PM, Bruce Sorge sor...@gmail.com wrote:
 
 So I discovered today that the hosting company that I am using has disabled 
 CFOBJECT, which sucks because the PayPal API that I am using uses the 
 CFOBJECT tag. Is there an alternative to this?
 
 Thanks,
 
 Bruce
 
 
 
 

~|
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:352355
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Alternative to CFOBJECT

2012-08-30 Thread Bruce Sorge

The legacy code on x.com

Sent from my iPhone 4S. 

On Aug 30, 2012, at 1:35 PM, Michael van Leest mvanle...@gmail.com wrote:

 
 A bit of topic, but which Paypal api are you using??
 
 2012/8/30 Matt Quackenbush quackfu...@gmail.com
 
 
 Time for a new host. :-)
 
 In the meantime, though, createObject( Component ) is not disabled,
 according to that list. So you should be able to refactor and use that
 instead of cfobject.
 
 HTH
 
 
 On Thu, Aug 30, 2012 at 2:21 PM, Bruce Sorge sor...@gmail.com wrote:
 
 
 This is everything that they disabled:
 
 On the shared ColdFusion servers you will have access to all tags and
 functions except for the following:
 
 CF Tags:
 CFCOLLECTION
 CFCONTENT
 CFDUMP
 CFEXECUTE
 CFLOG
 CFOBJECT
 CFOBJECTCACHE
 CFREGISTRY
 
 
 CF Functions:
 SetProfileString
 CreateObject(COM)
 CreateObject(CORBA)
 CreateObject(JAVA)
 On Aug 30, 2012, at 1:09 PM, Scott Stroz boyz...@gmail.com wrote:
 
 
 Have they disabled createObject() (they probably have, though)
 
 On Thu, Aug 30, 2012 at 3:04 PM, Bruce Sorge sor...@gmail.com wrote:
 
 So I discovered today that the hosting company that I am using has
 disabled CFOBJECT, which sucks because the PayPal API that I am using
 uses
 the CFOBJECT tag. Is there an alternative to this?
 
 Thanks,
 
 Bruce
 
 
 
 
 
 
 
 
 
 

~|
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:352360
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Alternative to CFOBJECT

2012-08-30 Thread Bruce Sorge

I would Ben but the host is the clients choice, I have to live with it. 

Sent from my iPhone 4S. 

On Aug 30, 2012, at 1:45 PM, Ben Forta b...@forta.com wrote:

 
 Bruce,
 
 One word (well, ok, two words) - dump them. Use a host that will give you
 full control over your own instance or virtual machine.
 
 --- Ben
 
 
 -Original Message-
 From: Bruce Sorge [mailto:sor...@gmail.com] 
 Sent: Thursday, August 30, 2012 3:21 PM
 To: cf-talk
 Subject: Re: Alternative to CFOBJECT
 
 
 This is everything that they disabled:
 
 On the shared ColdFusion servers you will have access to all tags and
 functions except for the following:
 
 CF Tags:
 CFCOLLECTION
 CFCONTENT
 CFDUMP
 CFEXECUTE
 CFLOG
 CFOBJECT
 CFOBJECTCACHE
 CFREGISTRY
 
 
 CF Functions:
 SetProfileString
 CreateObject(COM)
 CreateObject(CORBA)
 CreateObject(JAVA)
 On Aug 30, 2012, at 1:09 PM, Scott Stroz boyz...@gmail.com wrote:
 
 
 Have they disabled createObject() (they probably have, though)
 
 On Thu, Aug 30, 2012 at 3:04 PM, Bruce Sorge sor...@gmail.com wrote:
 
 So I discovered today that the hosting company that I am using has
 disabled CFOBJECT, which sucks because the PayPal API that I am using uses
 the CFOBJECT tag. Is there an alternative to this?
 
 Thanks,
 
 Bruce
 
 
 
 
 
 
 
 

~|
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:352366
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Alternative to CFOBJECT

2012-08-30 Thread Bruce Sorge

Thanks Scott, that worked perfectly.

Bruce
On Aug 30, 2012, at 1:24 PM, Scott Stewart webmas...@sstwebworks.com wrote:

 
 How is createObject() being used?
 Based on this list you can use it to call ColdFusion components
 
 cfset blah = createObject(component,dot.notated.path.to.component)
 


~|
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:352367
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Alternative to CFOBJECT

2012-08-30 Thread Bruce Sorge

I'll do that. My sister lives in Alexandria now so when I get to Fort Benning 
GA. in October I plan to visit her soon. I'll hit you up when I am in the area.

Bruce
On Aug 30, 2012, at 2:45 PM, Scott Stewart webmas...@sstwebworks.com wrote:

 
 No problem, buy me a beer next time yer in DC
 


~|
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:352369
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Alternative to CFOBJECT

2012-08-30 Thread Bruce Sorge

I just looked it up and she is in great falls. 

Sent from my iPhone 4S. 

On Aug 30, 2012, at 2:50 PM, Scott Stewart webmas...@sstwebworks.com wrote:

 
 Where at in Alexandria?
 

~|
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:352372
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


OT - JS Question

2012-08-28 Thread Bruce Sorge

Can someone point me to a site or a sample of JS that does the following:

User enters first name, last name and birth date (birthdate is in a specific 
format by using drop downs and not free text).
Once the birth year has been selected, a query is triggered to check for the 
existence of the same information that was just entered. 
If a match is found, a pop up is displayed stating that they have already 
registered.
If no match, nothing happens.


Thanks,

Bruce

~|
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:352328
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Populate Select List from JS

2012-08-16 Thread Bruce Sorge

Actually this code worked once I corrected the spelling of a variable. Sorry I 
did not update the list.

BRuce
 
 Bruce
 
 AJAX might be better here.  


~|
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:352182
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


OT - JS question

2012-08-12 Thread Bruce Sorge

I have a form where I am adding administrators to a site. Site administrators 
and resort administrators. Rather than have two separate forms for this I 
thought that what I would do is when they are adding an admin, if they select a 
resort admin, then another select list appears with a list of resorts. 
Otherwise if they are a site admin they do not need ot select a resort. I have 
looked on line for JS to do this but all I can find is something that shows 
both select lists, and if you select a certain item in the first one then the 
second one populates, otherwise the list is empty. Admittedly I am not all that 
savvy at writing JS code. Has anyone done this before and would you be willing 
to share the code?


Thanks,

Bruce


~|
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:352116
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Populate Select List from JS

2012-08-12 Thread Bruce Sorge

Hello everyone,
So yesterday I figured out the JavaScript for my two selects. In the JS code 
below I have the information I need, Resort Name and Resort ID:

script type = text/javascript
function setOptions(opt) { 
var resortID = document.adminForm.resortID; 
resortID.options.length = 0; 

if ((opt == 0) || (opt == 1)){
resortID.options[resortID.options.length] = new 
Option(); 
}

if ((opt == 2) || (opt == 2)) { 
cfoutput query=qSelectResorts
resortID.options[resortID.options.length] = new 
Option('#Resort_Name#','#resort_ID#');
/cfoutput}

} 

/script 


Here are the select lists:

select name=adminID size=1 style=width: 150px 
onchange=setOptions(document.adminForm.adminID.options[document.adminForm.adminID.selectedIndex].value);
option value=0 
selectedSelect.../option
option value=1Site 
Admin/option
option 
value=2Resort Admin/option
/select
br /
br /
select name=resortID 
size=1 style=width: 150px option value = 0
/option/select

The first list is hard coded as you can see and teh second one is dynamic. When 
you select Resort Admin then the second list populates with the resort names. 
What I need now is to get the resort ID's in the value and I don't know how to 
do that. If anyone can help me with this last part I would really appreciate it.


Thanks in advance,

Bruce

~|
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:352119
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


CFspreadsheet issue

2012-08-10 Thread Bruce Sorge

Hello list,
Long time (years) no post. 

I am trying to read from a spreadsheet that is loaded up onto the server and 
then insert the information into the database. I have three column headers 
called Code, Barcode and ResortID. Code and Barcode have values and ResortID is 
empty. The reason that I did this is because I want to insert the ResortID from 
a formfield called ResortID. The problem is that I am getting the error message:
Columc count doesn't match value count at row 1. Here is my code:

!--- Read the spreadsheet data into a query object ---
cfspreadsheet action=read query=DealsDSN headerrow=1 
src=#ExpandPath(Spreadsheets/#ClientFile#)# /

!--- Loop thorugh the query starting with the first row containing data (row 
2) ---
cfloop query=MahDSN startrow=2

!--- Insert the code and bar code into the database for future use ---
cfquery datasource=DealsDSN result=foobar
INSERT INTO BarCodes
(Code, BarCode, ResortID)
VALUES
(
cfqueryparam cfsqltype=cf_sql_varchar value=#Code#
cfqueryparam cfsqltype=cf_sql_varchar value=#BarCode#
cfqueryparam cfsqltype=cf_sql_int value=#Form.ResortID
)
/cfquery
/cfloop

The error is on cfqueryparam cfsqltype=cf_sql_int value=#Form.ResortID

Any assistance is greatly appreciated.


Bruce

~|
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:352085
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CFspreadsheet issue

2012-08-10 Thread Bruce Sorge

Yeah I picked up on that and still the same issue.
On Aug 10, 2012, at 1:00 PM, Sandra Clark sclarkli...@gmail.com wrote:

 
 I'm seeing a missing # sign after Form.Request
 


~|
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:352088
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


  1   2   3   4   5   6   7   8   9   10   >