Re: varScoper menu not shown in CFBUILDER

2012-01-19 Thread Raymond Camden

No idea than - sorry man. You could call Adobe tech support, but I'd
assume they would put the blame on the extension. If you want to hop
into a Connect room or Google Hangout, let me know.


On Wed, Jan 18, 2012 at 10:29 PM, Brook Davies cft...@logiforms.com wrote:

 Yeah, I can right click on both.. CFB2, yeah. And I see other extensions, I
 think, like apply CF Nature...

 Brook

 -Original Message-
 From: Raymond Camden [mailto:raymondcam...@gmail.com]
 Sent: January-18-12 6:23 PM
 To: cf-talk
 Subject: Re: varScoper menu not shown in CFBUILDER


 But to be clear, you can right click on a .cfm file in the navigator, just
 not a folder?

 CFB2?


 On Wed, Jan 18, 2012 at 5:10 PM, Brook Davies cft...@logiforms.com wrote:

 Hi Ray,

 I do see that bit, inside of some other XML:

 application
        namevarScoper/name
        authorMike Schierberl/author
        version1.0/version
        emailm...@schierberl.com/email
        descriptionintr



 

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


ridiculously cheap CFML conference next month

2012-01-19 Thread Jason Blum

Hi folks,

I know http://OpenCFSummit.org has been mentioned a few times on this list.  I 
just wanted to share that the schedule is up and registrations are pouring in: 
http://opencfsummit.org/index.cfm/schedule/

Also wanted to clarify that the reason this conference is so cheap is obviously 
because of our amazing sponsors - but the idea behind it is to grow our 
community by trying to attract programmers from other technologies.

This year's conference has a strong emphasis on options for super affordable 
Cloud Computing hosting options and getting ColdFusion programmers more 
involved in Civic Hacktivism and the whole Gov 2.0 movement.

For $72 you know this isn't one of those cruise ship conferences, where you 
can wander around lost for days.  http://OpenCFSummit.org is all about keeping 
things intimiate and attendee-centric, with only one track of sessions, tons of 
free training, a great hackfest, lightening talks, unconference space and more.

Forgive the sales pitch - but since CFUnited shut down, our community just has 
so few opportunities to get together and grow.  Sure there's the amazing 
http://cfobjective.com/

I just wanted to make sure folks hadn't missed this one...

Thanks!

-Jason Blum
@phenotypical 

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


Programattically CREATE DATABASE in MySQL

2012-01-19 Thread HCI

Hi all:

I've been presented with an interesting problem for which I seem to have hit a 
wall.  I have an app wherein it would be very handy to be able to have the CF 
code create a new database as needed IN MySQL.  I've tried the straight CREATE 
DATABASE AAA in a CFQUERY with an existing datasource and get an exception 
error reading Encountered DATABASE at line xxx.  I've tried doing the 
entire SQL string as a variable.  I'm considering putting it in as a stored 
proc on an existing database and passing in the new database name...but nothing 
works.

I saw an earlier thread here that seemed to allude to being able to do this but 
with no specific examples.  Any help would be greatly appreciated.

Thanks in advance! 

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


RE: varScoper menu not shown in CFBUILDER

2012-01-19 Thread Brook Davies

I appreciate the offer Raymond, but I am okay just running it from the CFM
code base directly. Again thanks Jedi!

Brook

-Original Message-
From: Raymond Camden [mailto:raymondcam...@gmail.com] 
Sent: January-19-12 6:31 AM
To: cf-talk
Subject: Re: varScoper menu not shown in CFBUILDER


No idea than - sorry man. You could call Adobe tech support, but I'd assume
they would put the blame on the extension. If you want to hop into a Connect
room or Google Hangout, let me know.


On Wed, Jan 18, 2012 at 10:29 PM, Brook Davies cft...@logiforms.com wrote:

 Yeah, I can right click on both.. CFB2, yeah. And I see other 
 extensions, I think, like apply CF Nature...

 Brook

 -Original Message-
 From: Raymond Camden [mailto:raymondcam...@gmail.com]
 Sent: January-18-12 6:23 PM
 To: cf-talk
 Subject: Re: varScoper menu not shown in CFBUILDER


 But to be clear, you can right click on a .cfm file in the navigator, 
 just not a folder?

 CFB2?


 On Wed, Jan 18, 2012 at 5:10 PM, Brook Davies cft...@logiforms.com
wrote:

 Hi Ray,

 I do see that bit, inside of some other XML:

 application
        namevarScoper/name
        authorMike Schierberl/author
        version1.0/version
        emailm...@schierberl.com/email
        descriptionintr



 



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


Re: Programattically CREATE DATABASE in MySQL

2012-01-19 Thread Matt Quackenbush

I think you'll want to look into the ColdFusion Administrator API. There
are hooks for doing just these types of tasks programmatically. If you are
on Railo, it also has an API exposed that allows these tasks (cfadmin
tag, I think?). I've never used OpenBD, but I assume that it exposes
something of the sort as well.

HTH


On Thu, Jan 19, 2012 at 11:54 AM, HCI cf.contrac...@gmail.com wrote:


 Hi all:

 I've been presented with an interesting problem for which I seem to have
 hit a wall.  I have an app wherein it would be very handy to be able to
 have the CF code create a new database as needed IN MySQL.  I've tried the
 straight CREATE DATABASE AAA in a CFQUERY with an existing datasource and
 get an exception error reading Encountered DATABASE at line xxx.  I've
 tried doing the entire SQL string as a variable.  I'm considering putting
 it in as a stored proc on an existing database and passing in the new
 database name...but nothing works.

 I saw an earlier thread here that seemed to allude to being able to do
 this but with no specific examples.  Any help would be greatly appreciated.

 Thanks in advance!

 

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


Re: CF and Quickbooks

2012-01-19 Thread Elliott Kayne

 If your CF cart can handle auth.net as the payment gateway, you can 
 get QB integration. Rates are reasonable, I have an 800 number if you 
 want to get more info, just contact me offlist.
 
 Steve - Please contact me regarding getting QUICKBOOKS payment services 
 intergrated into my CART software.  Elliott 570-686-2300 or ek @ 
 onlinecorp.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:349548
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: CF and Quickbooks

2012-01-19 Thread Vincent Cannady

If anyone has any questions about whether this client will pay them please 
contact me. I have dealt with this Elliot Kane before and I did not receive all 
the money from my work. It may be different for you but I do not think it will 
be so since he has enough to hire a CF programmer he prefers these not so 
binding contract workers from another state_very hard to collect your money

I have a client that wants to integrate her Cart with her Quickbooks.
I dont currently have a cart set up yet so I'm looking for  suggestions.

I'd like  easily to implament one with:
--CFMX7
--Quickbooks 2005
--SQL Server 2005
--Windows 2003 Server

I have total controll of the box.

-- 
Richard Dillman
rdill...@gmail.com
(317) 916-8341

The most important step is always the first one. 

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


This actually works!

2012-01-19 Thread Rick Faircloth

I'm working with XML for my first time and I ran
into an issue.

This is one of the Categories, Products, Product Details
hierarchies.

I've got everything figured out so far, but ran into a
product node which didn't contain what's called in the
document, a OneLiner child node. (Now, I was under the
impression that all XML nodes were supposed to be alike
in the nodes they contain, even if they don't contain content...)

But, nope, sure enough this product node had a
Product Name node, a Product Manufacturer node, etc.,
but no OneLiner node as did all the rest.

I searched on the internet for how to test for the
existence of an xml child node and coldfusion 9 test
for for existence of xml node, etc.

Finally, I just tried this:

cfif structKeyExists(productsArray[index], 'OneLiner') 

   p class=product_oneliner#productsArray[index].OneLiner.xmlText#/p

/cfif

And what do you know... it worked!

Just FYI, for anyone struggled with XML and CF.

Rick



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349550
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: This actually works!

2012-01-19 Thread Nathan Strutz

Yeah, thanks Rick, good tip. You'll find that working with CF XML nodes is
a lot like working with structs and arrays, so most of those array*() and
struct*() built-in functions will work with your XML.

nathan strutz
[www.dopefly.com] [hi.im/nathanstrutz] [about.me/nathanstrutz]


On Thu, Jan 19, 2012 at 2:08 PM, Rick Faircloth r...@whitestonemedia.comwrote:


 I'm working with XML for my first time and I ran
 into an issue.

 This is one of the Categories, Products, Product Details
 hierarchies.

 I've got everything figured out so far, but ran into a
 product node which didn't contain what's called in the
 document, a OneLiner child node. (Now, I was under the
 impression that all XML nodes were supposed to be alike
 in the nodes they contain, even if they don't contain content...)

 But, nope, sure enough this product node had a
 Product Name node, a Product Manufacturer node, etc.,
 but no OneLiner node as did all the rest.

 I searched on the internet for how to test for the
 existence of an xml child node and coldfusion 9 test
 for for existence of xml node, etc.

 Finally, I just tried this:

 cfif structKeyExists(productsArray[index], 'OneLiner') 

   p class=product_oneliner#productsArray[index].OneLiner.xmlText#/p

 /cfif

 And what do you know... it worked!

 Just FYI, for anyone struggled with XML and CF.

 Rick



 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349551
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Programattically CREATE DATABASE in MySQL

2012-01-19 Thread Rex

I have something similar working so, maybe it's a permissions issue.  
Try the CREATE DATABASE AAA code with a DSN that's using the root user.  
Once you've confirmed it works, lock it down from there.

- Rex

On 1/19/2012 9:54 AM, HCI wrote:
 Hi all:

 I've been presented with an interesting problem for which I seem to have hit 
 a wall.  I have an app wherein it would be very handy to be able to have the 
 CF code create a new database as needed IN MySQL.  I've tried the straight 
 CREATE DATABASE AAA in a CFQUERY with an existing datasource and get an 
 exception error reading Encountered DATABASE at line xxx.  I've tried 
 doing the entire SQL string as a variable.  I'm considering putting it in as 
 a stored proc on an existing database and passing in the new database 
 name...but nothing works.

 I saw an earlier thread here that seemed to allude to being able to do this 
 but with no specific examples.  Any help would be greatly appreciated.

 Thanks in advance!

 

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


Mac - Oracle - CF

2012-01-19 Thread Gerald Weir

Hello,

I know this is stretching the forum topic a bit but I'm a CF Developer that 
finds himself switching back to Oracle DB after using SQL Server for several 
years.  I'm trying to install Oracle (10g) on my new Mac Book Pro with Lion OS 
and running into problems with the requirement that either XCode or gcc be 
installed.

Well, XCode doesn't want to install because it gets hung up trying to extract 
one of the files that is the package for iPhoneSDK5_0.pkg.  So, I thought I 
would try installing gcc on it's own but it looks like the info on their site 
is fairly old and I'm not keen to try it out on my new Mac.

Anyone out there have any experience with this that they can share.

Sorry for being off-topic but I need to get my stored procedures on Oracle 
running from ColdFusion which is why I thought possibly someone here would have 
an idea.

Thanks in advance,
Gerald 

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


Re: Programattically CREATE DATABASE in MySQL

2012-01-19 Thread AJ Mercer

Hi Matt,

Are you thinking of the admin API to create the dsn?



On 20 January 2012 02:39, Matt Quackenbush quackfu...@gmail.com wrote:


 I think you'll want to look into the ColdFusion Administrator API. There
 are hooks for doing just these types of tasks programmatically. If you are
 on Railo, it also has an API exposed that allows these tasks (cfadmin
 tag, I think?). I've never used OpenBD, but I assume that it exposes
 something of the sort as well.

 HTH


 On Thu, Jan 19, 2012 at 11:54 AM, HCI cf.contrac...@gmail.com wrote:

 
  Hi all:
 
  I've been presented with an interesting problem for which I seem to have
  hit a wall.  I have an app wherein it would be very handy to be able to
  have the CF code create a new database as needed IN MySQL.  I've tried
 the
  straight CREATE DATABASE AAA in a CFQUERY with an existing datasource and
  get an exception error reading Encountered DATABASE at line xxx.
  I've
  tried doing the entire SQL string as a variable.  I'm considering putting
  it in as a stored proc on an existing database and passing in the new
  database name...but nothing works.
 
  I saw an earlier thread here that seemed to allude to being able to do
  this but with no specific examples.  Any help would be greatly
 appreciated.
 
  Thanks in advance!
 
 

 

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


Re: Programattically CREATE DATABASE in MySQL

2012-01-19 Thread Matt Quackenbush

Oops. Ayep, that's exactly what I was thinking. That's what I get for
skimming! Sorry! I'll go back to sleep now. ;-)


On Thu, Jan 19, 2012 at 4:47 PM, AJ Mercer ajmer...@gmail.com wrote:


 Hi Matt,

 Are you thinking of the admin API to create the dsn?



 On 20 January 2012 02:39, Matt Quackenbush quackfu...@gmail.com wrote:

 
  I think you'll want to look into the ColdFusion Administrator API. There
  are hooks for doing just these types of tasks programmatically. If you
 are
  on Railo, it also has an API exposed that allows these tasks (cfadmin
  tag, I think?). I've never used OpenBD, but I assume that it exposes
  something of the sort as well.
 
  HTH
 
 
  On Thu, Jan 19, 2012 at 11:54 AM, HCI cf.contrac...@gmail.com wrote:
 
  
   Hi all:
  
   I've been presented with an interesting problem for which I seem to
 have
   hit a wall.  I have an app wherein it would be very handy to be able to
   have the CF code create a new database as needed IN MySQL.  I've tried
  the
   straight CREATE DATABASE AAA in a CFQUERY with an existing datasource
 and
   get an exception error reading Encountered DATABASE at line xxx.
   I've
   tried doing the entire SQL string as a variable.  I'm considering
 putting
   it in as a stored proc on an existing database and passing in the new
   database name...but nothing works.
  
   I saw an earlier thread here that seemed to allude to being able to do
   this but with no specific examples.  Any help would be greatly
  appreciated.
  
   Thanks in advance!
  
  
 
 

 

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


Re: This actually works!

2012-01-19 Thread Justin Scott

 Yeah, thanks Rick, good tip. You'll find that working with CF XML
 nodes is a lot like working with structs and arrays, so most of
 those array*() and struct*() built-in functions will work with your XML.

When you use XMLParse(), the resulting variable is a set of arrays and
structures, so it's not just a lot like working with them, you
actually are, so all of the relevant functions are applicable.
Whenever I'm working with parsing XML I tend to make judicious use of
CFDUMP which will show the entire set of ColdFusion data structures
and makes navigating them a lot easier.  Glad this got brought up as
I've run into a lot of people that didn't realize this was the case.


-Justin

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


Re: ridiculously cheap CFML conference next month

2012-01-19 Thread Justin Scott

 Forgive the sales pitch - but since CFUnited shut down, our
 community just has so few opportunities to get together and
 grow.  Sure there's the amazing http://cfobjective.com/

Unfortunately I won't be able to make OpenCF Summit, but I am
beginning to plan for cf.Objective.  I also wanted to mention NCDevCon
while we're on the topic (a regional ColdFusion conference).  It was
only $70 and provided world-class value, so if you're on the fence
don't shrug off a conference like OpenCF Summit just because it's
inexpensive to register.


-Justi

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


RE: ridiculously cheap CFML conference next month

2012-01-19 Thread andy matthews

But will NCDevCon be taking place this year? I've heard different stories.



andy 

-Original Message-
From: Justin Scott [mailto:leviat...@darktech.org] 
Sent: Thursday, January 19, 2012 11:11 PM
To: cf-talk
Subject: Re: ridiculously cheap CFML conference next month


 Forgive the sales pitch - but since CFUnited shut down, our community 
 just has so few opportunities to get together and grow.  Sure there's 
 the amazing http://cfobjective.com/

Unfortunately I won't be able to make OpenCF Summit, but I am beginning to
plan for cf.Objective.  I also wanted to mention NCDevCon while we're on the
topic (a regional ColdFusion conference).  It was only $70 and provided
world-class value, so if you're on the fence don't shrug off a conference
like OpenCF Summit just because it's inexpensive to register.


-Justi



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


Re: ridiculously cheap CFML conference next month

2012-01-19 Thread Justin Scott

 But will NCDevCon be taking place this year? I've heard different stories.

I am not involved in the conference aside from attending, so I do not
know what their plans are for 2012.  As an attendee I certainly hope
they choose to continue with NCDevCon if it's feasible to do so.  The
College of Textiles was am amazing host location and everyone involved
with the conference did a wonderful job.  If they do run it again in
2012 I will definitely be making the trip.


-Justin Scott

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