from:"\!jeff\!"


Ok, so here's the issue.  A process that was working just fine on CF9 is 
now broken on CF10.  We have a service that we call that requires us to 
submit a client certificate to the server.  In CF9, this worked just fine.  
Use the clientcert and clientcertpass attributes of CFHTTP and you're good 
to go.  It reads the .pfx file fine and everything runs...  This is not a 
cacerts issue as you do not have to have the key in the keystore to use 
it.
Forward to CF10, the exact same code and certificates now gives the error: 

Error while trying to get the SSL client certificate: 
java.security.UnrecoverableKeyException: Could not decrypt key: Could not 
decode key from BER. (Invalid encoding: expected tag not there. ).  
It's like it's unable to open the .pfx certificate file.
I know this is a long shot since there are not many folks out there using 
client certs, but has anyone else run across this issue?
Thanks,
Jeff Garza




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

RE: issue with cfhttp and client certificates


Mark,

On the CF9 Server we're at Java version 1.6.0_17  and the arguments from 
the CFAdmin look like the following: -server -Dsun.io.useCanonCaches=false 
-XX:MaxPermSize=192m -XX:+UseParallelGC -Xbatch 
-Dcoldfusion.rootDir={application.home}/../ 
-Dcoldfusion.libPath={application.home}/../lib 
-Dcoldfusion.spooltimeout=120.

On the CF10 server it's at Java version 1.7.0_15  and the args are: 
-server -XX:MaxPermSize=192m -XX:+UseParallelGC -Xbatch 
-Dcoldfusion.home={application.home} 
-Dcoldfusion.rootDir={application.home} 
-Dcoldfusion.libPath={application.home}/lib 
-Dorg.apache.coyote.USE_CUSTOM_STATUS_MSG_IN_HEADER=true 
-Dcoldfusion.jsafe.defaultalgo=FIPS186Random 
-Dcoldfusion.spooltimeout=120

Though, based on the error, I don't think this is a handshake issue.  It 
looks like an issue where the JVM can't even open the certificate file to 
pass the public key on to the server.  Which is why this is so strange that 
CF9 with the older JVM would be able to do it, but the new one can't.
--Jeff

 Original Message 
 From: Mark A Kruger mkru...@cfwebtools.com
 Sent: Thursday, July 25, 2013 1:25 PM
 To: cf-talk cf-talk@houseoffusion.com
 Subject: RE: issue with cfhttp and client certificates
 
 Jeff,
 
 What JVM version are you using on CF9 and what do the args look like?
 Sometimes it's a matter of the handshake and levels of TLS/SSL - the 
error
 may be not specific enough to tell. You can enable logging to get a grip 
on
 it though. That would tell you more.
 
 -Mark
 
 
 -Original Message-
 From: Jeff Garza [mailto:j...@garzasixpack.com] 
 Sent: Thursday, July 25, 2013 12:25 PM
 To: cf-talk
 Subject: issue with cfhttp and client certificates
 
 
 Ok, so here's the issue.  A process that was working just fine on CF9 is 

 now broken on CF10.  We have a service that we call that requires us to 
 submit a client certificate to the server.  In CF9, this worked just 
fine.  
 Use the clientcert and clientcertpass attributes of CFHTTP and you're 
good 
 to go.  It reads the .pfx file fine and everything runs...  This is not a 

 cacerts issue as you do not have to have the key in the keystore to use 
 it.
 Forward to CF10, the exact same code and certificates now gives the 
error: 
 
 Error while trying to get the SSL client certificate: 
 java.security.UnrecoverableKeyException: Could not decrypt key: Could not 

 decode key from BER. (Invalid encoding: expected tag not there. ).  
 It's like it's unable to open the .pfx certificate file.
 I know this is a long shot since there are not many folks out there using 

 client certs, but has anyone else run across this issue?
 Thanks,
 Jeff Garza
 
 
 
 
 
 
 

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

RE: issue with cfhttp and client certificates


No, the .pfx file has a password.  What's weird is that we even tried
importing to Windows' key repository and re-exporting as a pfx with a
different password and that file wouldn't work either.  It crashed with the
same error.  I'm really thinking that this may be a bug in how this new
version of Java and/or Apache handles client certs...  I guess I'm off to
Adobe support to see what they have to say about it.

--
Jeff

-Original Message-
From: Russ Michaels [mailto:r...@michaels.me.uk] 
Sent: Thursday, July 25, 2013 2:34 PM
To: cf-talk
Subject: Re: issue with cfhttp and client certificates


you don;t by any chance have a blank password/no password on the pfx file do
you ?


On Thu, Jul 25, 2013 at 9:24 PM, Mark A Kruger
mkru...@cfwebtools.comwrote:


 Jeff,

 What JVM version are you using on CF9 and what do the args look like?
 Sometimes it's a matter of the handshake and levels of TLS/SSL - the 
 error may be not specific enough to tell. You can enable logging to 
 get a grip on it though. That would tell you more.

 -Mark


 -Original Message-
 From: Jeff Garza [mailto:j...@garzasixpack.com]
 Sent: Thursday, July 25, 2013 12:25 PM
 To: cf-talk
 Subject: issue with cfhttp and client certificates


 Ok, so here's the issue.  A process that was working just fine on CF9 
 is now broken on CF10.  We have a service that we call that requires 
 us to submit a client certificate to the server.  In CF9, this worked just
fine.
 Use the clientcert and clientcertpass attributes of CFHTTP and you're 
 good to go.  It reads the .pfx file fine and everything runs...  This 
 is not a cacerts issue as you do not have to have the key in the 
 keystore to use it.
 Forward to CF10, the exact same code and certificates now gives the error:

 Error while trying to get the SSL client certificate:
 java.security.UnrecoverableKeyException: Could not decrypt key: Could 
 not decode key from BER. (Invalid encoding: expected tag not there. ).
 It's like it's unable to open the .pfx certificate file.
 I know this is a long shot since there are not many folks out there 
 using client certs, but has anyone else run across this issue?
 Thanks,
 Jeff Garza






 



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

Re: issue with cfhttp and client certificates

The .pfx is a RSA 1024 bit key.  Nothing out of the usual.  And this exact 
key worked just fine in a default install of CF9.
--
Jeff

 Original Message 
 From: Jon Clausen jon_clau...@silowebworks.com
 Sent: Thursday, July 25, 2013 3:29 PM
 To: cf-talk cf-talk@houseoffusion.com
 Subject: Re: issue with cfhttp and client certificates

 Long shot, but what is the key length on the encryption?  Could it be an 
issue with the encryption capabilities currently set on the new JVM for 
CF10?

 Explanation: http://www.petefreitag.com/item/803.cfm

 On Jul 25, 2013, at 4:44 PM, Jeff Garza j...@garzasixpack.com wrote:

  Mark,

  On the CF9 Server we're at Java version 1.6.0_17  and the arguments 
from 
  the CFAdmin look like the following: -server 
-Dsun.io.useCanonCaches=false 
  -XX:MaxPermSize=192m -XX:+UseParallelGC -Xbatch 
  -Dcoldfusion.rootDir={application.home}/../ 
  -Dcoldfusion.libPath={application.home}/../lib 
  -Dcoldfusion.spooltimeout=120.

  On the CF10 server it's at Java version 1.7.0_15  and the args are: 
  -server -XX:MaxPermSize=192m -XX:+UseParallelGC -Xbatch 
  -Dcoldfusion.home={application.home} 
  -Dcoldfusion.rootDir={application.home} 
  -Dcoldfusion.libPath={application.home}/lib 
  -Dorg.apache.coyote.USE_CUSTOM_STATUS_MSG_IN_HEADER=true 
  -Dcoldfusion.jsafe.defaultalgo=FIPS186Random 
  -Dcoldfusion.spooltimeout=120

  Though, based on the error, I don't think this is a handshake issue.  
It 
  looks like an issue where the JVM can't even open the certificate file 
to 
  pass the public key on to the server.  Which is why this is so strange 
that 
  CF9 with the older JVM would be able to do it, but the new one can't.
  --Jeff

   Original Message 
  From: Mark A Kruger mkru...@cfwebtools.com
  Sent: Thursday, July 25, 2013 1:25 PM
  To: cf-talk cf-talk@houseoffusion.com
  Subject: RE: issue with cfhttp and client certificates

  Jeff,

  What JVM version are you using on CF9 and what do the args look like?
  Sometimes it's a matter of the handshake and levels of TLS/SSL - the
  error
  may be not specific enough to tell. You can enable logging to get a 
grip
  on
  it though. That would tell you more.

  -Mark

  -Original Message-
  From: Jeff Garza [mailto:j...@garzasixpack.com] 
  Sent: Thursday, July 25, 2013 12:25 PM
  To: cf-talk
  Subject: issue with cfhttp and client certificates

  Ok, so here's the issue.  A process that was working just fine on CF9 
is

  now broken on CF10.  We have a service that we call that requires us 
to 
  submit a client certificate to the server.  In CF9, this worked just
  fine.  
  Use the clientcert and clientcertpass attributes of CFHTTP and you're
  good 
  to go.  It reads the .pfx file fine and everything runs...  This is 
not a

  cacerts issue as you do not have to have the key in the keystore to 
use 
  it.
  Forward to CF10, the exact same code and certificates now gives the
  error: 

  Error while trying to get the SSL client certificate: 
  java.security.UnrecoverableKeyException: Could not decrypt key: Could 
not

  decode key from BER. (Invalid encoding: expected tag not there. ).  
  It's like it's unable to open the .pfx certificate file.
  I know this is a long shot since there are not many folks out there 
using

  client certs, but has anyone else run across this issue?
  Thanks,
  Jeff Garza

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

Re: Compare Two Lists

2013-07-17 Thread Jeff Garza


What database platform are you on?  I'd import those email addresses in the 
CSV to a temporary table and then just use a sub-select in the where 
clause.  Let the database do the work...  
DELETE FROM someTable WHERE emailaddress in (SELECT email from 
tempImportTable)
Also, if you are on SQL Server and this is a routine that you will need to 
do every so often, create a SSIS Package to run the import from CSV and 
clean up the the table.  They are pretty easy to create and all you need to 
do is refresh the CSV file for it to run.
--Jeff

 Original Message 
 From: i...@markleder.com i...@markleder.com i...@markleder.com
 Sent: Wednesday, July 17, 2013 12:01 PM
 To: cf-talk cf-talk@houseoffusion.com
 Subject: Re: Compare Two Lists
 
 FWIW:  I have 4000 records to delete, with CF 9, throws an error:
 [Macromedia][SQLServer JDBC Driver][SQLServer]The incoming request has 
too many parameters. The server supports a maximum of 2100 parameters. 
Reduce the number of parameters and resend the request.
 
 I can break up the routines into three sets to make it work. 
 
 

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

re: Getting lots of DB Errors: Transaction was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

2013-07-16 Thread Jeff Garza


Absolutely you should have an index on sessionID.  Without that index you 
are forcing a table scan for that id so the engine can do the update.  When 
your table was smaller, SQL could deal with that a lot easier.  Once you 
start getting to 3-4 million rows, the performance starts to slow down on a 
flat table scan.   I have tables with 500 million rows and I can find a 
unique record using a clustered index scan in under a second...  
If you are only indexing the sessionID column you shouldn't see any major 
performance hits on inserts and you should see dramatic performance 
increases on your updates.
--Jeff

 Original Message 
 From: Brook Davies cft...@logiforms.com
 Sent: Tuesday, July 16, 2013 10:03 AM
 To: cf-talk cf-talk@houseoffusion.com
 Subject: Getting lots of DB Errors: Transaction was deadlocked on lock | 
communication buffer resources with another process and has been chosen as 
the deadlock victim. Rerun the transaction.
 
 Hey Guys,
 
 I am getting a lot of these errors today:
 
 Transaction (Process ID 65) was deadlocked on lock | communication 
buffer
 resources with another process and has been chosen as the deadlock 
victim.
 Rerun the transaction.
 
 On a system that is used to track 'views' of a page via an ajax request. 
All
 of the errors are related to updating a specific table with a query like
 this (this is not the CFML query..):
 
 update formAnalytics_view 
 set INLINESTART={ts '2013-07-16 10:04:21'} , 
 INTERACTED=1 
 where sessionid = '5BAC1158-D89E-4CB5-A8FB-1DC06D3E82A9'
 
 The table has 4,925,131 rows and growing. It is has more writes than 
reads.
 Is there something I can do to optimize this table to avoid these 
deadlock
 errors? 
 
 I had added a try/catch around the transactions that were causing these
 deadlocks, and then I was re-running the failed transaction in the catch
 segment, but it looks like the lock was not yet removed and this was 
just
 leading to more errors. What is the best way to resolve this? Would 
adding a
 thread.sleep() statement and then re-trying the transaction work or 
would
 that just lead to more errors?
 
 Note the queries should 9 times out of 10 be updating different rows of 
this
 table. Should I add an index on the sessionID? Or would that make writes
 slower?
 
 Brook
 
 
 
 

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

Form Fields suddenly self validating? Now required?

2013-05-21 Thread Jeff F


Hey everyone,

I have a very old site that has a basic form. All of a sudden, the form is 
requiring all form form fields to be filled out? The form is a basic form 
action=, and I've got required=no on the fields. 

What's interesting is that the validation results are quite nice looking, 
almost Jquery-ish. The form fields get a slight red glow around the edges, and 
the little bubbles that show on the page look great, however I don't want any 
of it. 

I did read about newer versions of CF server validating, so I tried disabling 
that by adding serverSideFormValidation=no to the cfapplication.

What the heck is this? 

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

RE: Space in a Struct Key

2013-03-06 Thread Jeff Garza


If you are going to use bracket notation, you need to use quotes for struct 
keys that are not variables.

#[imageMetaData][exif][Focal Length]# - Coldfusion will be looking for a 
variable called exif.

Try this instead:
#imageMetaData[exif][Focal Length]# should work.

--
Jeff

 Original Message 
 From: Jenny Gavin-Wear jenn...@fasttrackonline.co.uk
 Sent: Wednesday, March 06, 2013 4:14 PM
 To: cf-talk cf-talk@houseoffusion.com
 Subject: RE: Space in a Struct Key
 
 This fails:-
 cfoutput#[imageMetaData][exif][Focal Length]#/cfoutput
 
 and I am sure I tried every other combination except the right one.
 
 You can see the structure here:-
 http://gallery.fasttrackonline.co.uk/admin/images/test.cfm
 
 CF7, if that makes any difference.
 



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

re: jquery forms

2013-02-14 Thread Jeff Garza


Check out the Validity plugin...  you can change the applied styles and 
such as well.

http://validity.thatscaptaintoyou.com/

--
Jeff


 Original Message 
 From: John M Bliss bliss.j...@gmail.com
 Sent: Thursday, February 14, 2013 9:01 AM
 To: cf-talk cf-talk@houseoffusion.com
 Subject: jquery forms
 
 Hi! Time-back-way-back, my favorite way to do client-side form 
validation
 was Adobe Spry. It was super-easy to do color-coded alerts on empty
 required fields, email format validation, etc.
 
 Nowadays, I know that can all be done with roll-your-own JQuery but I'm
 wondering if you have a favorite JQuery plugin / lib that'll handle it 
out
 of the box.
 
 Thanks!
 
 -- 
 John Bliss - http://about.me/jbliss



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

Re: Coldfusion 10 automatic updates not working

2013-02-08 Thread Jeff Carpenter


Thanks for your help.  We have solved the issue, I will post the solution here 
if it helps anyone in the future. The error message logged in the hotfix log 
file  (Eg: C:\ColdFusion10\cfusion\hf-updates\hf-10-7) is the following:

Failed to copy hotfix files:C:\Users\xxx\002873.tmp\dist\cfusion
Status: FATAL ERROR
Additional Notes: FATAL ERROR - Failed to copy the hotfix files to the target 
location:C:\ColdFusion10\cfusion
FATAL ERROR - C:\ColdFusion10\cfusion\bin\coldfusion.exe (The process cannot 
access the file because it is being used by another process)

Several blog posts refer to permission problems, such as making sure the 
account under which CF10 runs has local admin access, or that the cfusion 
directory have appropriate permissions.  We had tried these solutions, and 
several variations without luck. We had also stopped all CF services and 
applied the HF manually but the same error persisted.

In our case, we renamed coldfusion.exe notated in the error log above, applied 
the hotfix, and everything worked. So, I don't believe it was really a 
permissions issue but rather (as the error log was trying to tell us), that the 
coldfusion.exe was in use.


 We are installing CF10 Enterprise on Windows 2008 RC2 with IIS 7.
 We installed using all default selections, straight-forward 
 installation, and applied the mandatory update. So far, so good. When 
 we go to the updates page for automatic updates for the latest current 
 hotfix 7 (at the time of this post), which is cumulative, the install 
 and download process runs fine, the instance restarts, but then when 
 we check again to see the available updates, it shows all the updates 
 from 1 to 7 again, as if we didn't apply the updates at all. Installed 
 updates tab shows no updates having been applied. However, looking at 
 the system info page, the udpate level shows HF7.
 
 We tried a variation, applying one hotfix at a time. This worked 
 through hot fix 2, but after applying HF 4, it 'froze' there with the 
 same problem as described above, not showing any fixes having been 
 applied after HF 2. This is incredibly frustrating. I have no idea if 
 HF's have been applied, and am not sure what to think about the sys 
 info page indicating hotfix level. We are still living in CF update 
 hell. Any ideas appreciated!
 
 Thanks,
 
 Jeff 

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

Coldfusion 10 automatic updates not working


We are installing CF10 Enterprise on Windows 2008 RC2 with IIS 7.
We installed using all default selections, straight-forward installation, and 
applied the mandatory update. So far, so good. When we go to the updates page 
for automatic updates for the latest current hotfix 7 (at the time of this 
post), which is cumulative, the install and download process runs fine, the 
instance restarts, but then when we check again to see the available updates, 
it shows all the updates from 1 to 7 again, as if we didn't apply the updates 
at all. Installed updates tab shows no updates having been applied. However, 
looking at the system info page, the udpate level shows HF7.

We tried a variation, applying one hotfix at a time. This worked through hot 
fix 2, but after applying HF 4, it 'froze' there with the same problem as 
described above, not showing any fixes having been applied after HF 2. This is 
incredibly frustrating. I have no idea if HF's have been applied, and am not 
sure what to think about the sys info page indicating hotfix level. We are 
still living in CF update hell. Any ideas appreciated!

Thanks,

Jeff 

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

Re: Coldfusion 10 automatic updates not working


I am not sure I follow.  The ColdFusion 10 Application Server service is set 
to Log on with the local system account. I tried changing this to log on as my 
own login account, which is a member of the local administrators.  I still was 
not able to logon.

 Steven,
 
 I guess I should have added that once the updates are installed, 
 remove 
 the service account from Administrators.  And this solution is only a 
 
 workaround, mind you.  I don't believe this **should** be necessary, 
 but 
 it has been for me.
 
 I've followed the lockdown guides, including granting the ColdFusion 
 service account full permissions to the entire /ColdFusion10 folder 
 
 structure.  Updates since update 2 have not installed without 
 installing 
 with Administrator group rights.
 
 -Carl V.
 
 On 2/7/2013 7:53 AM, DURETTE, STEVEN J wrote:
  And yet I believe that would go against the lockdown guides... So 
 our options are easy updates or secure systems?
 

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

Re: Coldfusion 10 automatic updates not working


Sorry, I meant to say that I was still not able to apply updates.

 I am not sure I follow.  The ColdFusion 10 Application Server 
 service is set to Log on with the local system account. I tried 
 changing this to log on as my own login account, which is a member of 
 the local administrators.  I still was not able to logon.
 
  Steven,
  
  I guess I should have added that once the updates are installed, 
  remove 
  the service account from Administrators.  And this solution is only 
 a 
  
  workaround, mind you.  I don't believe this **should** be necessary, 
 
  but 
  it has been for me.
  
  I've followed the lockdown guides, including granting the ColdFusion 
 
  service account full permissions to the entire /ColdFusion10 
 folder 
  
  structure.  Updates since update 2 have not installed without 
  installing 
  with Administrator group rights.
  
  -Carl V.
  
  On 2/7/2013 7:53 AM, DURETTE, STEVEN J wrote:
   And yet I believe that would go against the lockdown guides... 
 So 
  our options are easy updates or secure systems?
  

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

Re: Coldfusion 10 automatic updates not working


@Carl
Thanks, yes I had done this earlier and restarted the service, still same issue.
The HF log indicates the following:


Failed to copy hotfix files:C:\Users\xxx\478130.tmp\dist\cfusion
FATAL ERROR - Failed to copy the hotfix files to the target 
location:C:\ColdFusion10\cfusion
FATAL ERROR - C:\ColdFusion10\cfusion\bin\coldfusion.exe (The process cannot 
access the file because it is being used by another process)

@Andrew, Thanks, I did try what you suggested on your blog, but still seeing 
the same problem.

Since this does appear to be permissions related, I will talk with one of our 
NW admins to see if I am configuring the accounts/permissions correctly.

Thanks

 That's exactly what I was suggesting you do.  After you set the 
 ColdFusion service to run as your account, did you stop and restart 
 the 
 service?  That is necessary for the Administrator permissions to be 
 granted to the ColdFusion service.  Then, after the updates are 
 installed (assuming they do install successfully), switch the service 
 
 back to the local system account and stop/restart it again.
 
 Since you are running as local service, is this your local development 
 
 machine or your production server?  Just curious.
 -Carl V.
 
 On 2/7/2013 2:40 PM, Jeff Carpenter wrote:
  I am not sure I follow.  The ColdFusion 10 Application Server 
 service is set to Log on with the local system account. I tried 
 changing this to log on as my own login account, which is a member of 
 the local administrators.  I still was not able to logon.
  

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

Re: Coldfusion 10 automatic updates not working


It is a test server, we are installing CF enterprise on Windows 2008 RC2. 

 That's exactly what I was suggesting you do.  After you set the 
 ColdFusion service to run as your account, did you stop and restart 
 the 
 service?  That is necessary for the Administrator permissions to be 
 granted to the ColdFusion service.  Then, after the updates are 
 installed (assuming they do install successfully), switch the service 
 
 back to the local system account and stop/restart it again.
 
 Since you are running as local service, is this your local development 
 
 machine or your production server?  Just curious.
 -Carl V.
 
 On 2/7/2013 2:40 PM, Jeff Carpenter wrote:
  I am not sure I follow.  The ColdFusion 10 Application Server 
 service is set to Log on with the local system account. I tried 
 changing this to log on as my own login account, which is a member of 
 the local administrators.  I still was not able to logon.
 

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

re: https connection issues using cfhttp

2013-01-17 Thread Jeff Garza


You are going to have to edit your hosts file and create a pointer for 
hub that directs it to 187.141.14.122.  Then when you call the 
webservice, you'll use https://hub/...; to access it.  I've been through 
this before as well and this should do it after you've imported the 
certificate from the site.

--
Jeff


 Original Message 
 From: Ian Chapman ian.chap...@melodimedia.co.uk
 Sent: Thursday, January 17, 2013 8:13 AM
 To: cf-talk cf-talk@houseoffusion.com
 Subject: https connection issues using cfhttp
 
 Hi Guys,
 
 I've been wrestling with a problem calling a SOAP Web Service using 
cfhttp. The endpoint is an https URL to a server IP, not a host name.
 
 We are running MX7.
 
 Initially when I tried connecting I got the usual error response from an 
untrusted authority source:
 
 ErrorDetail: I/O Exception: peer not authenticated
 
 Usually when this happens we download the certificate (DER format saved 
as a .cer file) from the site using a browser and add it to the Java SDK 
truststore using the keytool -import  command in the jrun/jre/lib 
folder.
 
 This all went ok and I can see the certificate when I list them using the 
keytool - list... command.
 
 This changed the error response to:
 
 ErrorDetail: I/O Exception: Name in certificate `hub' does not match 
host name `187.141.14.122'
 
 My first issue is very common and usually easy to resolve, but the latter 
has caused a lot of head banging.
 
 What I can tell is that it seems to be self signed certificate and feel 
this might be part of the problem.
 
 Any ideas?
 
 Regards,
 
 Ian.
 
 
 
 

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

ORM Relationship Issue

2012-11-26 Thread Jeff Chastain


I am having an issue with one of my ORM relationships and I am hoping somebody 
can point out what I am missing here.  I have the concept of a Client.  Each 
client has an Owner (account manager) which references a User record.  Now, a 
given user may be the owner of more than one client.

The database design here is set, so I can't change column names etc.  In the 
Client table, there is a column 'idOwner' which references the 'idUsers' column 
in the User table.

In my Client object, I have the following property definition:

property name=Owner fieldtype=many-to-one cfc=com.user.User 
fkcolumn=idUsers missingRowIgnored=true;

When I try to retrieve a Client record instance, the error is invalid column 
name 'idUsers'.  How should this relationship be defined to map idOwner on the 
Client table to idUsers on the User table?

TIA! 

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

Streaming PDF in CF8 / Performance Issues

2012-08-01 Thread Jeff Chastain


I am doing some performance test on a site running on ColdFusion 8 using 
FusionReactor.  There is one script that consistently ends up on the top of the 
long running requests list.  The script is very simple - it grabs a PDF file 
that already exists on the files system and streams it to the user.

cfif fileExists( filePath  fileName ) 
cfheader name=Content-Disposition value=attachment; 
filename=#fileName#
cfcontent type=application/pdf file=#filePath##fileName#
cfelse
cfheader statuscode=410 statustext=Gone /
pWe're sorry, but the page you have requested no longer exists on our 
site./p
/cfif

The PDF files in question are pretty small ... 1 to 2 MB.  In some cases (but 
not all), the request logs in FusionReactor are showing this script running for 
200+ seconds.

Does anybody have any ideas why this would be happening and is there a better 
way to stream PDF files that are not web accessible (i.e. the user has to 
register, then they get the file streamed to them)?  I am not looking to change 
the workflow - i.e. copying the file and sending a link by email etc.  I have 
streamed files like this before and have never seen these kinds of performance 
issues.

Thanks for any input! 


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

RE: CFinclude issues

2012-03-02 Thread Jeff Langevin


Aren't they all also relative to the original including templates path though 
even though they're nested?  I feel like I got bitten by that once...

-Original Message-
From: =?ISO-8859-1?Q?Claude_Schn=E9egans 
schneegans@interneti=71?=.outdoors.org 
[mailto:=?ISO-8859-1?Q?Claude_Schn=E9egans 
schneegans@interneti=71?=.outdoors.org] 
Sent: Friday, March 02, 2012 2:21 PM
To: cf-talk
Subject: Re: CFinclude issues


 unless you
include a file that includes the file you're including.

Even this will work, provided you have a test to stop the recursive loop.



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

Best practices: Google mapping

2011-12-14 Thread Jeff Gladnick


Is there a current state of the art for dealing with Google maps and 
coldfusion, especially asynchronously.  I've used cf_googlemap extensively in 
the past, but has anything eclipsed 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:349152
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Exchange 2010 via EWS Java API

2011-10-04 Thread Jeff Martin


I was able to determing that the XML parsing error was caused by fields in the 
Contact Records that contained nothing but a space or multiple spaces.  I was 
able to scrub the spaces from the Contacts by exporting to CSV, searching for 
and removing spaces from otherwise blank fields, then reimporting the CSV file 
to Outlook after deleting all contacts.  This now works without the XML parsing 
error. 

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

Exchange 2010 via EWS Java API

2011-09-27 Thread Jeff Martin


I'm attempting to retrieve a list of contacts from a mailbox on an Exchange 
2010 server.  Here's the code I'm using.


cfset service = 
CreateObject(java,microsoft.exchange.webservices.data.ExchangeService).init()

cfset credentials = 
CreateObject(java,microsoft.exchange.webservices.data.WebCredentials).init(user
 account name@domain name,password) /

cfset returnValue = service.setCredentials(credentials) /
cfset returnvalue = service.getCredentials() /

cfset uri = CreateObject(java,java.net.URI) /

cfset returnValue = uri.init(https://ExchangeServerName/ews/Exchange.asmx)
cfset returnValue = service.setUrl(uri) /

cfset WellKnownFolderName = 
CreateObject(java,microsoft.exchange.webservices.data.WellKnownFolderName) 
/

cfset ViewResults = 
service.findItems(CreateObject(java,microsoft.exchange.webservices.data.FolderId).init(WellKnownFolderName.Contacts,
 
CreateObject(java,microsoft.exchange.webservices.data.Mailbox).init(mailbox
 email 
address,SMTP)),CreateObject(java,microsoft.exchange.webservices.data.ItemView).init(1000))
 /

cfdump var=#ViewResults#

The error message I'm receiving is as follows:
The request failed. Could not read value from START_ELEMENT.Could not find 
CHARACTERS 

with stack trace of the following:
microsoft.exchange.webservices.data.ServiceRequestException: The request 
failed. Could not read value from START_ELEMENT.Could not find CHARACTERS
at 
microsoft.exchange.webservices.data.SimpleServiceRequestBase.internalExecute(Unknown
 Source)
at 
microsoft.exchange.webservices.data.MultiResponseServiceRequest.execute(Unknown 
Source)
at 
microsoft.exchange.webservices.data.ExchangeService.findItems(Unknown Source)
at 
microsoft.exchange.webservices.data.ExchangeService.findItems(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at coldfusion.runtime.StructBean.invoke(StructBean.java:511)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2300)
at cfscribble2ecfm14055155.runPage(C:\path to cfml template:57)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at 
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:279)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
at coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:27)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
at 
coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:74)
at 
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:175)
at 
coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
at 
coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
at 
coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
at jrun.servlet.FilterChain.service(FilterChain.java:101)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at 
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
at 
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
at 
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
at 
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
Caused by: 
microsoft.exchange.webservices.data.ServiceXmlDeserializationException: Could 
not read value from START_ELEMENT.Could not find CHARACTERS
at microsoft.exchange.webservices.data.EwsXmlReader.readValue(Unknown 
Source)
at 
microsoft.exchange.webservices.data.EwsXmlReader.readElementValue(Unknown 
Source)
at 
microsoft.exchange.webservices.data.EwsXmlReader.readElementValue(Unknown 
Source)
at

Google Oauth Authentication - getting contacts

2011-06-24 Thread Jeff Gladnick


I've used the oauth project on Riaforge to authenticate with Google, but I 
cannot connect to the API to get the contacts out.

Has anyone done this successfully and has the code? 

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

generating hmac-sha1 signatures w/ coldfusion


I've scoured google for hours now and cannot seem to find what I am looking for.

I am trying to build a library to connect to Yahoo's API and import contacts 
via their REST API using oAuth.

I have the oAuth authentication done and working, but the final step, making 
the API request won't seem to work no matter what I do.

1) This is how yahoo says I must make API calls:
http://developer.yahoo.com/oauth/guide/oauth-make-request.html

The problem is is requires me to generate an hmac-sha1 signature, and I am 
unsure of how to go about doing this, or what variables must be used to 
construct it?  

Can anyone explain this to 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:344788
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: generating hmac-sha1 signatures w/ coldfusion


@Gabriel:

I am using that.  For the signmessage I am passing in something that looks 
similar to this:

POSThttps%3A%2F%2Fapi.login.yahoo.com%2Foauth%2Fv2%2Fget_request_token
oauth_consumer_key%3Ddj0yJmk9YmxIanRLOGQybWFCJmQ9WVdrOUxWbFBVMWRUTmpRbWNHbzlNQ1o1UFRFLSZzPWNvbnN1bWVyc2VjcmV0Jng9YTc-
%26oauth_nonce%3DJsZywH
%26oauth_signature_method%3DHMAC-SHA1
%26oauth_timestamp%3D1221089876
%26oauth_version%3D1.0
%26xoauth_lang_pref%3Den-us

for the signkey, i pass in:
cfset signkey = #consumerSecret#%26#session.oauth_token_secret# /

It gives me back gobbly-gook when i pass that into the hmac encrypt function:
ï¿½.Ñ{3lï¿½ï¿½ï¿½Ó´ï¿½NoHï¿½9ï¿½


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

Re: generating hmac-sha1 signatures w/ coldfusion


code I am currently using:
http://pastebin.com/pJK3m6SW 

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

Re: generating hmac-sha1 signatures w/ coldfusion


Might be getting close with this code:

http://pastebin.com/uwbkGCVP

Now its producing reasonable characters at least, using slightly different 
hmac-sha1 function. 

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

Re: generating hmac-sha1 signatures w/ coldfusion


I'm so close...

Latest code
http://pastebin.com/iJxYGJeL

error returned:
Please provide valid credentials. OAuth oauth_problem=parameter_rejected: 
oauth_signature

I must be constructing my signature wrong but I can seem to figure it out :( 

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

RE: Can anyone decode this?

2011-05-13 Thread Jeff Garza


Put this in your SQL Query analyzer tool and change the EXEC at the end to
PRINT.  It should print out the SQL Statement for you to see what they were
trying to do.

Cheers,

Jeff 

-Original Message-
From: Che Vilnonis [mailto:ch...@asitv.com] 
Sent: Friday, May 13, 2011 7:31 AM
To: cf-talk
Subject: Can anyone decode this?


Can anyone decode this? This was a URL attack that was caught by some custom
code. I tried decoding the string at
http://meyerweb.com/eric/tools/dencoder/ but had no luck.

113|736;DECLARE @S CHAR(4000);SET
@S=CAST(0x4445434C415245204054207661726368617228323535292C404320766172636861
72283430303029204445434C415245205461626C655F437572736F7220435552534F5220464F
522073656C65637420612E6E616D652C622E6E616D652066726F6D207379736F626A65637473
20612C737973636F6C756D6E73206220776865726520612E69643D622E696420616E6420612E
78747970653D27752720616E642028622E78747970653D3939206F7220622E78747970653D33
35206F7220622E78747970653D323331206F7220622E78747970653D31363729204F50454E20
5461626C655F437572736F72204645544348204E4558542046524F4D20205461626C655F4375
72736F7220494E544F2040542C4043205748494C4528404046455443485F5354415455533D30
2920424547494E20657865632827757064617465205B272B40542B275D20736574205B272B40
432B275D3D5B272B40432B275D2B2727223E3C2F7469746C653E3C736372697074207372633D
22687474703A2F2F73646F2E313030306D672E636E2F63737273732F772E6A73223E3C2F7363
726970743E3C212D2D272720776865726520272B40432B27206E6F74206C696B652027272522
3E3C2F7469746C653E3C736372697074207372633D22687474703A2F2F73646F2E313030306D
672E636E2F63737273732F772E6A73223E3C2F7363726970743E3C212D2D2727272946455443
48204E4558542046524F4D20205461626C655F437572736F7220494E544F2040542C40432045
4E4420434C4F5345205461626C655F437572736F72204445414C4C4F43415445205461626C65
5F437572736F72 AS CHAR(4000));EXEC(@S); 

Thanks, Che






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

Re: Question about API wrapper design

2011-04-16 Thread Jeff Gladnick


@Mark Drew:

So just to be clear, your recommendation is:

1) One single file
2) separate methods for each functionality (instead of using arguments)

that sounds reasonable. 

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

Re: Question about API wrapper design

2011-04-16 Thread Jeff Gladnick


hmm.  This sounds too complicated for the average user, but I am curious to 
know more about this.

For the same reason I am hesitant to have multiple files extending a base 
class.  For that I like mark's suggestion about the single cfc.  I want this to 
be as plug and play as possible for people.

What I did in some of my projects was to have a base method person that
the other methods used. Enforce type or variable checking in
getPersonByType, but have the bulk of the work done in the getPerson method.


andy

Hi there Jeff

I think this depends. Who are you writing the API for? I.e is this
something you are going to use then let other people use it via RiaForge?
Or Are you just developing it to be open source from the get go?

I am inclined to have one big file as then it's simple to use as you
instantiate it and check out the methods. On the other hand, you might
want to return sub objects from your methods (such as arrays of people
etc) 


With regards to Question 2, I simpler methods that are more descriptive
would help, such as:

getPerson(id)
getPeople(Since [optional])
getPeopleByTitle(title)
getPeopleByTag(tag)
getPeopleByCompany(companyid)
getPeopleBySearch(searchterm)
getPeopleByCriteria(criteriaStruct)
createPerson()
savePerson()
deletePerson()



I hope that helps. 

Regards

Mark Drew




On 16/04/2011 08:08, Jeff Gladnick jeff.gladn...@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:343800
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Question about API wrapper design

2011-04-15 Thread Jeff Gladnick


I'm one of the developers working on a CFML wrapper for the highrise 
API (highrise.riaforge.org) and we're starting to plan out how we're 
going to organize the file structure. 

We have a few choices: 
1) Separate file for each type of object (people, task, note, etc) 
2) One big CFC file containing functions for each. 

Although it seems like a no brainer to go with #1, I figured it might 
be easier for CF developers to integrate into their projects if there 
was just a single file to include, rather then a big library. 
Advanced users could just strip out what they didn't want/need. 

The 2nd question is about function encapsulation.  On the people 
object, http://developer.37signals.com/highrise/people, there seem to 
be 7 different variations of GET person that could all be combined 
into a single getPerson() function that had (at least) 7 different 
arguments.  It seems like we could shrink the codebase a lot more this 
way. 

Any suggestions for file  function organization? 

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

I hate CFScript and I'm willing to pay for a CFScript -- CFtag parser


I actually don't hate cfscript, but I do hate that we have both tags and script 
based syntax for CFML.  And since it started off as tags, I firmly believe 
that's the way it should stay.

I understand lots of people feel differently, but it really sucks (for me) 
seeing all the new great open source projects being released in cfscript.

Therefore I have created a $1000 bounty (I have pledged $250) to the first 
developer who can deliver a working cfscript -- cftag based parser for eclipse.

http://www.pledgebank.com/CFScriptSucks

People can still write in cfscript if they want to, but people who feel like me 
won't have to deal with it anymore.

Please post flames below. 

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

Re: I hate CFScript and I'm willing to pay for a CFScript -- CFtag parser


First flame!

And I'm willing to pay for a C-64 version of Halo 3.


On Thu, Apr 7, 2011 at 7:20 PM, Jeff Gladnick jeff.gladn...@gmail.comwrote:

 

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

Re: I hate CFScript and I'm willing to pay for a CFScript -- CFtag parser


 On Thu, Apr 7, 2011 at 4:20 PM, Jeff Gladnick jeff.gladnick@gmail.
 com wrote:
  I actually don't hate cfscript, but I do hate that we have both tags 
 and script based syntax for CFML.  And since it started off as tags, I 
 firmly believe that's the way it should stay.
 
 You won't like the new version of FW/1 then... 2.0 is all cfscript :)

Just threw up in my mouth!  Actually this doesn't bother me as much as you 
might think because I typically shy away from modifying frameworks.

 
  Therefore I have created a $1000 bounty (I have pledged $250) to the 
 first developer who can deliver a working cfscript -- cftag based 
 parser for eclipse.
 
 I assume you mean any utility that can take cfscript and translate it
 into cftags? CFEclipse already has a working cfscript parser that 
 does
 syntax coloring.

Yes, but can it highlight a snippet of fugly cfscript and convert it into 
beautiful tag based CFML

 -- 
 Sean A Corfield -- (904) 302-SEAN
 An Architect's View -- http://corfield.org/
 World Singles, LLC. -- http://worldsingles.com/
 Railo Technologies, Inc. -- http://www.getrailo.com/
 
 Perfection is the enemy of the good.
 -- Gustave Flaubert, French realist novelist 
(1821-1880

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

Re: I hate CFScript and I'm willing to pay for a CFScript -- CFtag parser


That's funny. Actually I created a tags -- script converter a few weeks
ago, kind of for fun, kind of for upgrading to CF9. It works for basic
stuff, components, functions, some loops, try/catch, etc, but gets confused
with queries or anything else complicated.

nathan strutz
[http://www.dopefly.com/] [http://hi.im/nathanstrutz]


On Thu, Apr 7, 2011 at 4:20 PM, Jeff Gladnick jeff.gladn...@gmail.comwrote:



Post to RIA forge!!! 

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

Re: I hate CFScript and I'm willing to pay for a CFScript -- CFtag parser


The translation is actually rather easy. It's just a bunch of RegEx for
parsing and rules for understanding. The limitations of cfscript are perfect
here as there are not many rules. The only thing would be the loops that are
available in cfscript but do not exist in standard cf. Also, if someone is
taking advantage of how cfscript handles loops (check per loop instance),
they will probably have a problem with the normal from/to cfloop.


Seems like a few rules could be setup to handle for looks, just change to 
cfloop from=1 to=#var# index=i.

If you want it to be a cfeclipse feature then I'd need someone who is more
knowledgeable in that area. It's easier as a cfbuilder extension though. I
think that more specifications are needed.

I thought about that, but I'd prefer it to be part of eclipse or (worse) its 
own stand alone tool.  CFbuilder is great, but I want this parser to be 
available for free, without having to pay the entry fee for CFB.


p.s. please don't flame here. Tech talk only. Flames on the cf-community
list.
Thanks

That was meant to be sarcastic :)  Obviously I don't want flames on my own 
topic! 

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

RE: Storing Arrays or Structures in a database

2011-04-06 Thread Jeff Garza


Arrays are easy as you can simply use Arraytolist() to convert it to a
delimited text string and then use ListtoArray() to convert back once you
get it out.  Though, CF has some really nice list functions, so you might
not even have to do that.  Also, select boxes return comma separated lists
back to CF when a form is submitted (ditto for checkboxes with the same
name)... So that might work in your favor.  

For structures though, WDDX is your friend, and quite easy to do...

Try cfwddx action=CFML2WDDX input=#workweek# output=workweekXML

Then stuff workweekXML into the database field.

When you retrieve the data back out of the database, use cfwddx again to
convert back to a CF structure

cfwddx action=WDDX2CFML input=queryname.databaseWDDXField
output=localStructVariable

Just make sure that your db field can handle a decent sized chunk of data,
especially if  you are allowing user defined data in this column as the WDDX
format can get kinda bloated.


-Original Message-
From: Adam Bourg [mailto:adam.bo...@gmail.com] 
Sent: Wednesday, April 06, 2011 10:41 AM
To: cf-talk
Subject: Storing Arrays or Structures in a database


I've got really large sets of data that are related to each day of the week
and the hour. Rather then creating a massive table containing these values,
I have stored them in a Structure, but I can't seem to get Structures or
Arrays to insert into a database. How can I store an array or structure in a
MS 2008 SQL server? 

Array Code: 

cfset name=Adam /
cfscript
// 7 days, day 0 = Mon, Day 7 = sun
workWeek=[t,t,f,t,f,t,f];
/cfscript

cfinvoke method=injectData component=anubis 
cfinvokeargument name=name value=#name# /
cfinvokeargument name=workWeek value=#workWeek# /
/cfinvoke

cffunction name=injectData access=public returntype=void
hint=Injects the Employee App form data

cfquery datasource=DSN name=insertData INSERT INTO
mod_employmentAppProfile(
name, 
workWeekendsEvenings
)
VALUES ( 
#ARGUMENTS.name#,
#ARGUMENTS.workWeek#
)
/cfquery





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

RE: Storing Arrays or Structures in a database

2011-04-06 Thread Jeff Garza

True.  I used wddx to serialize some multidimensional arrays just the other
day...

Jeff 

-Original Message-
From: Bobby Hartsfield [mailto:bo...@acoderslife.com] 
Sent: Wednesday, April 06, 2011 2:39 PM
To: cf-talk
Subject: RE: Storing Arrays or Structures in a database

Assuming you are dealing with one dimensional arrays, sure, converting it to
a list could work.

.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com

-Original Message-
From: Jeff Garza [mailto:j...@garzasixpack.com]
Sent: Wednesday, April 06, 2011 2:02 PM
To: cf-talk
Subject: RE: Storing Arrays or Structures in a database

Arrays are easy as you can simply use Arraytolist() to convert it to a
delimited text string and then use ListtoArray() to convert back once you
get it out.  Though, CF has some really nice list functions, so you might
not even have to do that.  Also, select boxes return comma separated lists
back to CF when a form is submitted (ditto for checkboxes with the same
name)... So that might work in your favor.  

For structures though, WDDX is your friend, and quite easy to do...

Try cfwddx action=CFML2WDDX input=#workweek# output=workweekXML

Then stuff workweekXML into the database field.

When you retrieve the data back out of the database, use cfwddx again to
convert back to a CF structure

cfwddx action=WDDX2CFML input=queryname.databaseWDDXField
output=localStructVariable

Just make sure that your db field can handle a decent sized chunk of data,
especially if  you are allowing user defined data in this column as the WDDX
format can get kinda bloated.

-Original Message-
From: Adam Bourg [mailto:adam.bo...@gmail.com] 
Sent: Wednesday, April 06, 2011 10:41 AM
To: cf-talk
Subject: Storing Arrays or Structures in a database

I've got really large sets of data that are related to each day of the week
and the hour. Rather then creating a massive table containing these values,
I have stored them in a Structure, but I can't seem to get Structures or
Arrays to insert into a database. How can I store an array or structure in a
MS 2008 SQL server? 

Array Code: 

cfset name=Adam /
cfscript
// 7 days, day 0 = Mon, Day 7 = sun
workWeek=[t,t,f,t,f,t,f];
/cfscript

cfinvoke method=injectData component=anubis 
cfinvokeargument name=name value=#name# /
cfinvokeargument name=workWeek value=#workWeek# /
/cfinvoke

cffunction name=injectData access=public returntype=void
hint=Injects the Employee App form data

cfquery datasource=DSN name=insertData INSERT INTO
mod_employmentAppProfile(
name, 
workWeekendsEvenings
)
VALUES ( 
#ARGUMENTS.name#,
#ARGUMENTS.workWeek#
)
/cfquery

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

coldfusion htaccess duplicate Google entries

2011-04-02 Thread Jeff InsuranceInventory


Hey guys/gals,
I use one host (Shared CrystalTech) to serve up multiple separate domains.

Trouble is Google has indexed:
1) http://MAINDOMAIN1.com/test.cfm
AND
2) http://MAINDOMAIN1.com/MAINDOMAIN1/test.cfm

I only want the first url to be indexed... but both urls above return 200 and 
dup. content.

My current htaccess implementation is:
RewriteCond %{HTTP_HOST} ^www\.MAINDOMAIN1\.com$ [NC]
RewriteRule ^(.*)$ http://MAINDOMAIN1.com/$1 [R=301,L]

RewriteCond %{HTTP_HOST} MAINDOMAIN1.com
RewriteCond %{REQUEST_URI} !MAINDOMAIN1/
RewriteRule ^(.*)$ MAINDOMAIN1/$1 [L]


Any ideas on how I can modify my htaccess to allow Link 1 but not allow Link 2. 
 I was unable to do it in cfapplication as the CGI and arguments.targetPage 
look exactly the same for both links 1) and 2).

Any thoughts for solving via htaccess?? 

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

Re: coldfusion htaccess duplicate Google entries

2011-04-02 Thread Jeff InsuranceInventory


Thanks Dave, I went your route.

After stepping away from the problem for half a day, I did think that perhaps 
changing the line of:
RewriteCond %{REQUEST_URI} !MAINDOMAIN1/
to
RewriteCond %{REQUEST_URI} !notexist/

might get the job done as well... basically shoving every request for that 
domain into that subfolder.. but for some reason it didn't like that.

Any other thoughts, the robots.txt will work according to Google's Webmasters 
blog... but thought I would still pose the question on properly structuring my 
htaccess.  Any idea why my change above didn't work.

Thanks for the help\! 

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

Re: ColdFusion 9 cflayout ajax errors

2011-03-28 Thread Jeff Carpenter


And if you copy that response link, can you browse it the browse. My bet you
can't.


I'm not sure if some of your post was cut off,  but specifying source= will 
result in the expected source not found error.   Browsing directly to the 
'selectpage.cfm' url will return the page fine with no errors.  
If I start taking off part of the CF generated ajax URL until it succeeds or 
fails, I get the following:
This will fail:
http://machinename.asu.edu/test/selectpage.cfm?_cf_containerId=selectpage

This will succeed (of course): http://machinename.asu.edu/test/selectpage.cfm

The 'NET' tab in firebug indeed provides more info than Chrome, 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:343343
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: ColdFusion 9 cflayout ajax errors

2011-03-28 Thread Jeff Carpenter


 Is selectpage.cfm in a directory called test? Is that the same
 directory used above for the page that refers to selectpage.cfm?

Yes on both counts.  I can browse selectpage.cfm directly no problems.  Also, I 
should mention that the server is running the latest CHF 9.0.1 

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

Re: ColdFusion 9 cflayout ajax errors

2011-03-28 Thread Jeff Carpenter


I found the error, which was due to server-side config and IIS 7 security 
settings. In the move from IIS 6 to IIS 7 on a new server, the server admin did 
not correctly copy the SQL Injection exception terms from the previous config.  
So, II 7 then denied certain keywords in the query string which had the only 
'symptom' of a 404. Thanks for your help. 

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

Re: ColdFusion 9 cflayout ajax errors

2011-03-27 Thread Jeff Carpenter


Dave, Yes, I can access CFIDE / CF admin fine.  Imported the cfajax tags as 
well on selectpage.cfm but still see the error.  Thanks

  We are upgrading from CF 8 Ent to 9 Ent - the following example runs 
 fine on CF 8, but once in CF 9 it fails with
  Error retreiving markup for selected element.. not found, the page 
 returns a 404. Here's the interesting part - as
  soon as I remove the source= argument in cflayoutarea, the error 
 goes away. It only happens when I specify a
  source.  Does anyone have any suggestion on what might be going on? 
  The basic stuff already set:
 
  * selectpage.cfm exists and is valid and is is same directory.
  * CFIDE is in a virtual directory
 
 
  cfajaximport  tags=cfform,cfwindow,cfdiv,cflayout-tab,cfmenu,
 cflayout-border /
 
  cfoutput
 
  !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Strict//EN http://www.
 w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd
  html
 
  head
  meta http-equiv=Content-Type content=text/html; charset=UTF-8
  titleTest Title/title
  /head
 
  body
 
  cflayout type=vbox
 
  cflayoutarea  overflow=hidden name=selectpage 
 source=selectpage.cfm  /
 
                 cflayoutarea size=25 name=layoutbottom
     Here is the layout bottom
                 /cflayoutarea
 
  /cflayout
 
  /body
  /html
 
  /cfoutput
 
 Are you also using CFAJAXIMPORT in selectpage.cfm?
 
 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 
cent

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

Re: ColdFusion 9 cflayout ajax errors

2011-03-27 Thread Jeff Carpenter


 What does Firebug tell you?

I use the Chrome console, but I ran it in FF w/ firebug as well and get the 
same '404' response:  

GET 
http://machineaddresshere.asu.edu/test/selectpage.cfm?_cf_containerId=selectpage_cf_nodebug=true_cf_nocache=true_cf_clientid=EE835B64871E4BDA8BF645C28C2EC7EF_cf_rc=0
 404 (Not Found) 

Thanks for the suggestions.



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

Re: ColdFusion 9 cflayout ajax errors

2011-03-26 Thread Jeff Carpenter


Thanks, Yes, we already tried that.  It should pickup the file location from 
the default current directory search. This app was working fine in CF8.  I 
think it is some sort of server configuration problem, I just don't see what it 
could be. 

perhaps it is looking for the file in the wrong location, trying specifying
the path relative to the website root and see if that works.



On Sat, Mar 26, 2011 at 2:10 AM, Jeffrey Carpenter
jeff.carpen...@asu.eduwrote:

 

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

DaysInMonth issue

2011-03-01 Thread Jeff Epstein


I just had a failure of the DaysInMonth function. For a report running on 
February data, from 2010-02-(01 hardcoded), to being DaysInMonth, the 
date result was 2010-02-31!!

I had to hard-code 2010-02-28 as to to make the report work. 

Anybody else having February problems today with DaysInMonth?



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

Google Checkout integration

2011-01-20 Thread Jeff Gladnick


Does anyone have any code they'd like to share concerning Google checkout 
integration?  The only thing on riaforge is several years old.  Anyone out 
there with newer code, particularly concerning the new subscription features 
added recently? 

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

Multiple Coldfusion positions

2010-12-29 Thread Jeff Spangler


Great company located in Greensboro NC is seeking multiple coldfusion 
developers with skill levels ranging from junior all the way to 
senior/architect level. 

Excellent benefits, compensation, and company culture.

For those thinking I'm not really looking... I have a stable job... you 
should still consider talking with us.  Our company has been experiencing 
explosive growth for the last several years (even in the current economy) and 
we are motivated to bring in good developers.

If Interested, please contact me at: six_mil_dlr_...@yahoo.com.  FYI - I am not 
a recruiter. 

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

JRun 404 without index.cfm (Win2008 R2 / CF9)

2010-12-20 Thread Jeff Chastain


I could use some help pointing out the obvious here.  I have a Win2008 R2 
server that I have been working through the Adobe CF9 lock down guide on and 
have setup ColdFusion in multi-server mode.

For some reason, I cannot browse the CF admin or web sites without appending 
/index.cfm to the url.  If I go to 
https://127.0.0.1/CFIDE/administrator/index.cfm, everything works.  If I go to 
https://127.0.0.1/CFIDE/administrator/, I get a JRun 404 error (not an IIS 404).

I have checked the web.xml file and the default index.cfm document is listed 
there.  What am I missing here?

Thanks
-- Jeff 

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

Re: JRun 404 without index.cfm (Win2008 R2 / CF9)

2010-12-20 Thread Jeff Chastain


Did you add index.cfm to the 'list' of default files in IIS?


Not quite that obvious Scott ;-)  Yeah, IIS has the index.cfm setup as the 
first default document and the 404 page I am getting is not the IIS page, thus 
my assumption that it is the JRun 404.  The layout is very basic, dark grey 
shades, etc. rather than the bright blue of IIS 7. 

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

Re: Hosted VPS recommendations

2010-12-07 Thread Jeff Gladnick


I have used Viviotech for a number of clients and for my own sites and my 
business.  Although there has been some down time periodically (and this has 
happened to me even with tier 1 hosting companies for fortune 500 corps), their 
customer service has remained top notch.

Their people are knowledgeable and can help you out with server problems, and 
their prices are good.  I'll continue to be a customer 

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

Gigya?

2010-12-06 Thread Jeff Gladnick


Anyone integrated Gigya with CF yet? 

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

Detect users based on country???

2010-11-22 Thread Jeff F


I need to hide pricing data on a few web pages for one country, Canada.  I've 
got a range of IP address blocks as in:

  41.206.160.0/19
  24.36.0.0/16
  24.37.0.0/16
 24.38.144.0/20
 24.57.0.0/16
  24.64.0.0/13
  24.72.0.0/17
 24.72.128.0/20

(the list is much longer).

At first I was looking at using .htaccess to detect IP then redirect to a page 
that plants a cookie for future detection on other pages. 

Is there a better idea? I'm open to anything. 



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

Re: Uploading photos to Facebook - ColdFusion REST API

2010-10-12 Thread Jeff Gladnick

I think there is a function in the facebook graph API that you can use:
http://facebookgraph.riaforge.org/

Howdy folks,

I'm working on a ColdFusion application that creates events in
Facebook. I have no trouble authenticating users and creating simple
events, but as soon as I add a picture with CFHTTPPARAM, I get a blank
response from Facebook.

Here's the code I have that works:

cfset params = 'access_token=#client.
access_token#event_info={page_id: #uid#, start_time:
1295578547, name: Test Event, location: Test,privacy:
OPEN,description: Test Event}'

cfhttp url=https://api.facebook.com/method/events.create?#params#;
method=get/cfhttp

Given the correct permissions and authentication, this works great.
But as soon as I change my CFHTTP statement, the code fails. This is
the code I'm using:

cfhttp url=https://api.facebook.com/method/events.create?#params#;
method=post multipart=yes

cfhttpparam file=E:\test\sampleimage.jpg type=file name=image.
jpg mimetype=image/jpeg
/cfhttp

Anyone have any ideas? It might be that Facebook is looking for some
kind of a header, but I'm not sure what that would be.

Thanks in advance!
David Six

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

For those who present at conferences (or want to)

2010-10-12 Thread Jeff Gladnick


Consider using www.prezi.com instead of powerpoint/etc for your next 
presentation.  I've recently started experimenting with it (you can see my 
first attempt to convert my resume to a prezi here: 
http://www.jeffgladnick.com/).

It allows for some really dynamic, interested presentation styles.  What I did 
is barely scratching the surface. 

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

For those who present at conferences (or want to)

2010-10-12 Thread Jeff Gladnick


Consider using www.prezi.com instead of powerpoint/etc for your next 
presentation.  I've recently started experimenting with it (you can see my 
first attempt to convert my resume to a prezi here: 
http://www.jeffgladnick.com/).

It allows for some really dynamic, interested presentation styles.  What I did 
is barely scratching the surface.


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

Microsoft rumored to be buying Adobe

2010-10-07 Thread Jeff Gladnick


http://sanfrancisco.cbslocal.com/2010/10/07/adobe-shares-soar-on-rumor-of-microsoft-bid/

What's that mean for Coldfusion!? 

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

Re: Microsoft rumored to be buying Adobe

2010-10-07 Thread Jeff Gladnick


I cant see this as positive in any way for coldfusion.  I would imagine it 
would just be a slow death of coldfusion as it's merged into .net.  bleh. 

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

Re: Extracting data from Java ByteArrayOutputStream

2010-08-13 Thread Jeff Chastain


  Pete,

This does have me an ASCII string of the contents of the byte array.  
After a lot of string parsing, I can get the SOAP envelope out and 
convert it to XML.  However, the binary images that are also included 
here are apparently encoded some how and I have yet to be able to use 
any form of ColdFusion decoding process to get them into a readable format.

Is there a better way to covert this byte array / string into something 
usable within ColdFusion without a bunch of string parsing and decoding?

Thanks
-- Jeff


On 8/13/2010 10:34 AM, Pete Freitag wrote:
 This should give you the cfhttp response as a string, when you get
 back a byte array:

 cfhttp.filecontent.toString(UTF-8)


 --
 Pete Freitag
 http://foundeo.com/ - ColdFusion Consulting  Products
 http://petefreitag.com/ - My Blog
 http://hackmycf.com - Is your ColdFusion Server Secure?


 On Thu, Aug 12, 2010 at 12:22 PM, Jeff Chastain
 jeff.chast...@admentus.com  wrote:
 Dave,

 Per my message earlier this week 
 (http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336189), 
 when I trycfinvoke or createObject( webservice ..., I am getting an 
 AxisFault error that I cannot get around.  When I usecfhttp to post, I am 
 getting the expected response back, but in a ByteArrayOutputStream.

 Thanks
 -- Jeff


   I am working with a SOAP web service in CF 8.0.1 and the filecontent
 attribute of the cfhttp response is a java.io.ByteArrayOutputStream.  If
 I use the toString() method to convert this to text, I can see the XML
 response data plus the binary image strings that I was expecting.  The
 problem is, I am not sure how to get this information out of the
 ByteArrayOutputStream.
 Out of curiosity, is there a reason why you're using CFHTTP to invoke
 a SOAP service instead of CFINVOKE? If you can't use CFINVOKE, you can
 probably just invoke the underlying Axis classes using Java.

 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 onsi

 

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

Extracting data from Java ByteArrayOutputStream

2010-08-12 Thread Jeff Chastain


  I am working with a SOAP web service in CF 8.0.1 and the filecontent 
attribute of the cfhttp response is a java.io.ByteArrayOutputStream.  If 
I use the toString() method to convert this to text, I can see the XML 
response data plus the binary image strings that I was expecting.  The 
problem is, I am not sure how to get this information out of the 
ByteArrayOutputStream.

So far, Google has not proved real helpful.  Can anybody offer some 
pointers?

Thanks.

-- 
Jeff Chastain

http://www.admentus.com
http://ams.admentus.com

Admentus is a custom web based solutions provider, delivering
business software applications, systems integration, strategic
consulting, and ColdFusion application maintenance services
which allow our clients to grow their business and plan for
the future.


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

Re: Extracting data from Java ByteArrayOutputStream

2010-08-12 Thread Jeff Chastain


Dave,

Per my message earlier this week 
(http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336189), 
when I try cfinvoke or createObject( webservice ..., I am getting an 
AxisFault error that I cannot get around.  When I use cfhttp to post, I am 
getting the expected response back, but in a ByteArrayOutputStream.

Thanks
-- Jeff


  I am working with a SOAP web service in CF 8.0.1 and the filecontent
 attribute of the cfhttp response is a java.io.ByteArrayOutputStream.  If
 I use the toString() method to convert this to text, I can see the XML
 response data plus the binary image strings that I was expecting.  The
 problem is, I am not sure how to get this information out of the
 ByteArrayOutputStream.

Out of curiosity, is there a reason why you're using CFHTTP to invoke
a SOAP service instead of CFINVOKE? If you can't use CFINVOKE, you can
probably just invoke the underlying Axis classes using Java.

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 onsi

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

AxisFault Error (CF 8.0.1) on web service returning binary image string

2010-08-11 Thread Jeff Chastain

I am running into a wall here with a SOAP web service call whose
results contain a binary image string. I have found several other
references to this error on various discussion forums, but none have any
replies.

The web service in question accepts some search criteria and returns
metadata for various image assets matching the search criteria including
a thumbnail of the image in binary format. I have queries against the
web service using SOAPSonar and the envelopes being sent and received
all appear to be valid.

Once I attempt to make the exact same query using ColdFusion, I am
getting the following error.

The fault returned when invoking the web service operation is AxisFault
faultCode:
{http://schemas.xmlsoap.org/soap/envelope/}Server.userException
faultSubcode: faultString: org.xml.sax.SAXException: SimpleDeserializer
encountered a child element, which is NOT expected, in something it was
trying to deserialize. faultActor: faultNode: faultDetail:
{http://xml.apache.org/axis/}stackTrace:org.xml.sax.SAXException:
SimpleDeserializer encountered a child element, which is NOT expected,
in something it was trying to deserialize. at
org.apache.axis.encoding.ser.SimpleDeserializer.on
StartChild(SimpleDeserializer.java:145) ...

I have worked with SOAP web services via CF on numerous occasions
without issue. The only difference here is the inclusion of the binary
image string. Has anybody seen or dealt with something like this?

Thanks.

--
Jeff Chastain

http://www.admentus.com
http://ams.admentus.com

Admentus is a custom web based solutions provider, delivering
business software applications, systems integration, strategic
consulting, and ColdFusion application maintenance services
which allow our clients to grow their business and plan for
the future.

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

CFBuilder Server Setup with CF Multiserver Installation

2010-08-05 Thread Jeff Chastain

I am trying once again to setup the servers panel in ColdFusion
Builder and I am still running into configuration issues.

I have ColdFusion 9.0.1 installed in a multiserver configuration such
that the default server is 'cfusion' on HTTP port 8300 and the JRun
admin server is 'admin' on HTTP port 8000 / JNDI port 2910. It is setup
with IIS 7.5 such that the default web site (c:\inetpub\wwwroot) is the
home for ColdFusion 9 and contains the CFIDE directory.

Then, I had the ColdFusion 8 installer create an EAR file which was
deployed as a new instance through the ColdFusion 9 Instance Manager.
This new instance is named 'cfusion8' and is on port HTTP 8301. Under
IIS 7, I have two web sites representing different projects. I used the
Web Configuration tool to connect the cfusion8 instance to each of these
sites and then manually added a virtual directory called 'CFIDE' which
points to 'C:\JRun4\servers\cfusion8\cfusion.ear\cfusion.war\CFIDE'.

Now, in CFBuilder, I have created a new server to represent the
ColdFusion 9 instance (cfusion). In the server settings, the
application server is 'JRun', the host name is [machine name], and the
webserver port is 8300. I have tried the machine name, localhost, and
ip address for the host and it does not make any difference.

I added the RDS username and password and enabled SSL. On the remote
server settings tab, the naming port is 2910 and the CF Admin / JRun
admin username and password are entered with the document root as
'C:\inetpub\wwwroot'. Then I click Finish to close the wizard.

At this point, I can right click on the server in the servers panel and
attempt to start it, but I shortly get a message in the console saying
that the server is not responsive. If I open the JRun management
console, I can see that the cfusion server has started, but apparently
CF Builder does not think so.

Moving on to the ColdFusion 8 server, I attempt to create a new server
in the servers panel. The server settings are all the same with the
exception that the webserver port is now 8301. On the remote server
settings, all of the settings are the same until I get down to the
document root. I have tried using
'C:\JRun4\servers\cfusion8\cfusion.ear\cfusion.war' and I have tried
creating a dummy wwwroot folder and pointing to that. After clicking
next, I get the 'install extensions' window. It is not clear what paths
to enter here as there is no default website for the ColdFusion 8 server.

Has anybody been able to successfully set this up? Is there a problem
in my multiserver installation or a problem with what I am doing in
CFBuilder?

Thanks
-- Jeff

--
Jeff Chastain

http://www.admentus.com
http://ams.admentus.com

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

NoClassDefFoundError with flash form

2010-07-27 Thread Jeff Martin


The error message I'm getting is as follows.  I've not been able to find the 
flexapi mentioned anywhere in similar NoClassDefFoundError messages online.  
Please Help.

Error,jrpp-5,07/27/10,14:52:40,{ApplicationName},'' The specific 
sequence of files included or processed is: {path to cfml file}, line: 106 
java.lang.NoClassDefFoundError
at coldfusion.tagext.html.form.CFFlexApi.initCache(CFFlexApi.java:276)
at coldfusion.tagext.html.form.CFFlexApi.init(CFFlexApi.java:89)
at 
coldfusion.tagext.html.form.MxmlOutput.compileMXML(MxmlOutput.java:61)
at coldfusion.tagext.html.form.MxmlOutput.compile(MxmlOutput.java:53)
at coldfusion.tagext.html.form.FormTag.doEndTag(FormTag.java:858) 

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

Re: coverting string to a numeric value

2010-07-22 Thread Jeff Gladnick


I think you want the val() function

so val (123) would return 123

val(jeff) would return 0 (all non numerics return 0)

 Hi All-
 
 is there a way I can convert a string to number in coldfusion. I could 
 not see any related functions to do this?
 
 Thanks 


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

Re: mod_rewrite question: redirecting to www.domain.com from domain.com with dynamic domain names

2010-07-21 Thread Jeff Gladnick


tried to no avail - damn!

 On Fri, Jul 16, 2010 at 11:20 AM, Jeff Gladnick wrote:
 
  Unfortunately, that didn't quite work :(
 
  Any other suggestions?
 
 Maybe something like this (untested):
 
 RewriteCond %{HTTP_HOST} !^www\.[a-z-]+\.[a-z]{2,6} [NC]
 RewriteCond %{HTTP_HOST} ([a-z-]+\.[a-z]{2,6})$ [NC]
 RewriteRule ^/(.*)$ http://www\.%1/$1 [R=301,L]
 
 Got the idea from here:
 
 http://www.askapache.com/htaccess/mod_rewrite-tips-and-tricks.
 html#require-www-no-hardcoding
 
 :Den
 
 -- 
 A man of courage flees forward, in the midst of new things.
 Jacques 
Maritain 

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

Re: mod_rewrite question: redirecting to www.domain.com from domain.com with dynamic domain names

2010-07-21 Thread Jeff Gladnick


Inexplicably, the OPPOSITE works!!

RewriteEngine On
RewriteBase /
RewriteCond %{HTTP_HOST} \.([^\.]+\.[^\.0-9]+)$
RewriteRule ^(.*)$ http://%1/$1 [R=301,L]

tried to no avail - damn!

Maritain 

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

Re: mod_rewrite question: redirecting to www.domain.com from domain.com with dynamic domain names

2010-07-21 Thread Jeff Gladnick


Got it!!

RewriteCond %{HTTP_HOST} !^www\.[a-z-]+\.[a-z]{2,6} [NC]
RewriteCond %{HTTP_HOST} ^([a-zA-Z0-9_-]+)\.([a-zA-Z0-9_-]+)
RewriteRule ^(.*)$ http://www.%0/$1 [r=301,L]


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

Re: Facebook Connect and coldfusion

2010-07-20 Thread Jeff Gladnick


Glad you liked it.  Let me know if you (or anyone else) would like commit 
privelages to contribute to the project.

We still need to build out the post-to-facebook functionality.


Awesome! Thank you for posting this!

Rick Sanders
Webenergy
www.webenergy.ca

I finally got this roughly working using some different code:

http://facebookgraph.riaforge.org/ 

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

Re: Facebook Connect and coldfusion

2010-07-19 Thread Jeff Gladnick


I finally got this roughly working using some different code:

http://facebookgraph.riaforge.org/ 

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

Re: mod_rewrite question: redirecting to www.domain.com from domain.com with dynamic domain names

2010-07-16 Thread Jeff Gladnick

Unfortunately, that didn't quite work :(

Any other suggestions?

On Thursday 15 Jul 2010 06:24:21 you wrote:
I get how to redirect from domain.com to www.domain.com like this:

rewritecond %{http_host} ^domain.com [nc]
rewriterule ^(.*)$ http://www.domain.com/$1 [r=301,nc]

BUT, what if I do not know the domain name in advance, is there a
way I can
make it dynamic

Something like
rewritecond %{http_host} ^([a-zA-Z]).com [nc]
rewriterule ^(.*)$ http://www.$2.com/$1 [r=301,nc]
but I'd have to read the docs...

if it already has a subdomain, ignore this rule. So...

How can you determine this ?

--
Tom Chiverton
Helping to carefully participate eligible principle-centered products
as part
of the IT team of the year 2010, '09 and '08

This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in
England and Wales under registered number OC307980 whose registered
office address is at Halliwells LLP, 3 Hardman Square, Spinningfields,
Manchester, M3 3EB. A list of members is available for inspection at
the registered office together with a list of those non members who
are referred to as partners. We use the word partner to refer to a
member of the LLP, or an employee or consultant with equivalent
standing and qualifications. Regulated by the Solicitors Regulation
Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above
and may be confidential or legally privileged. If you are not the
addressee you must not read it and must not use any information
contained in nor copy it nor inform any person other than Halliwells
LLP or the addressee of its existence or contents. If you have
received this email in error please delete it and notify Halliwells
LLP IT Department on 0870 365 2500.

For more information about Halliwells LLP visit www.halliwells.
co

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

Re: mod_rewrite question: redirecting to www.domain.com from domain.com with dynamic domain names

2010-07-15 Thread Jeff Gladnick


  if it already has a subdomain, ignore this rule.  So...
 
 How can you determine this ?

Couldn't you say if there was [any alphanumeric text].[any alphanumeric 
text].[any alphanumeric text] then we already have a subdomain (or a www) and 
theres no need to forward... not sure how to do the mod_rewrite for that


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

Re: Facebook Connect and coldfusion

2010-07-14 Thread Jeff Gladnick


Anyone else have any luck with this? 

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

mod_rewrite question: redirecting to www.domain.com from domain.com with dynamic domain names

2010-07-14 Thread Jeff Gladnick


I get how to redirect from domain.com to www.domain.com like this:

rewritecond %{http_host} ^domain.com [nc]
rewriterule ^(.*)$ http://www.domain.com/$1 [r=301,nc] 

BUT, what if I do not know the domain name in advance, is there a way I can 
make it dynamic

AND

if it already has a subdomain, ignore this rule.  So...

domain.com -- www.domain.com
fred.domain.com -- DOES NOT REDIRECT to www.domain.com 

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

Re: Facebook Connect and coldfusion

2010-07-08 Thread Jeff Gladnick


Unfortunately, its being demanded here, so its gotta be done.  Anyone else have 
any success with facebook connect?


And that's why I'm pretty negative on integrating with Facebook.  We created
an app 2 years ago and could never get the functionality of processing some
of our code after someone removed our app to work.  The API for that was
always broken. Or, we'd finally see that it had been fixed, but by the time
we got to it, it was broken again. (I expect someone to tell me here it
works now, but by the time I would get to it again, it would be broken. ) )

The lack of stability in their integration apparently isn't any better now
with FB Connect.

On Tue, Jun 22, 2010 at 10:05 AM, Kris Jones kris.jon...@verizon.netwrote:


 We're using FBConnect for a site in development now. It works fine, no
 problem. Except when FB does something stupid and breaks the API.
 Which happens every couple of weeks.

 --
-
Scott Brady
http://www.scottbrady.net/ 

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

Re: Facebook Connect and coldfusion

2010-07-06 Thread Jeff Gladnick


No problem, looking forward to it!

Sorry guys, I'm happy to post something, I'm just completely
underwater with work ramping up for a launch. I hope to have time to
scrub-up some code to post this weekend.

Cheers,
Kris


On Thu, Jul 1, 2010 at 2:28 PM, Dustin Wardlow dustinward...@gmail.com wrote:
 

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

spreadsheetSetColumnWidth ingnored

2010-07-05 Thread Jeff Battershall


Hi,

It seems that setting spreadsheetSetColumnWidth(myXLS,1,50) has no effect if 
the cell contents would be visually clipped. 

Anyone encountered this?

Jeff 

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

slurping data from an asp.net site

2010-06-30 Thread Jeff Gladnick


There is an asp.net site that I access in order to download a CSV file report.  
The report is generated on the fly, and I don't want to have to manually click 
around to get it.  

I am trying to submit the form via coldfusion, but the site is setup in a 
strange way.  Instead of submitting some normal form data, its submitting (when 
I view it in live headers) a 30,000 byte string of view state information.

The process is relatively simple:  browse the site, 2-3 mouseclicks to apply 
filters, and then generate report.

Perhaps there is another way I could do this automatically? 

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

Contact for FullAsAGoog?

2010-06-28 Thread Jeff Chastain


  Is it just me or is there no contact information on the FullAsAGoog 
web site?  I was looking for a way to register a new RSS feed, but I am 
missing something here.  Anybody know how or have a contact for the 
aggregator?

Thanks
-- Jeff

-- 
Jeff Chastain
President/CEO, Admentus, Inc.
http://www.admentus.com
http://ams.admentus.com

Admentus is a custom web based solutions provider, delivering
business software applications, systems integration, strategic
consulting, and ColdFusion application maintenance services
which allow our clients to grow their business and plan for
the future.


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

Re: Contact for FullAsAGoog?

2010-06-28 Thread Jeff Chastain


  Thanks.

On 6/28/2010 5:03 PM, Alan Rother wrote:
 Geoff Bowers
 http://twitter.com/modius

 =]
-- 

Jeff Chastain
President/CEO, Admentus, Inc.
http://www.admentus.com
http://ams.admentus.com

Admentus is a custom web based solutions provider, delivering
business software applications, systems integration, strategic
consulting, and ColdFusion application maintenance services
which allow our clients to grow their business and plan for
the future.


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

Re: Facebook Connect and coldfusion


Chris, 

would you mind sharing your code?  I'm having a hell of a time dealing with the 
fb connect api

We're using FBConnect for a site in development now. It works fine, no
problem. Except when FB does something stupid and breaks the API.
Which happens every couple of weeks.

Cheers,
Kris 


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

Re: Facebook Connect and coldfusion


Kris,

Would you be willing to share some code?  I'm having a hell of a time 
interfacing with the API


We're using FBConnect for a site in development now. It works fine, no
problem. Except when FB does something stupid and breaks the API.
Which happens every couple of weeks.

Cheers,
Kris 


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

Re: Facebook Connect and coldfusion


Kris,

Would you be willing to share some code?  I'm having a hell of a time 
interfacing with the API


We're using FBConnect for a site in development now. It works fine, no
problem. Except when FB does something stupid and breaks the API.
Which happens every couple of weeks.

Cheers,
Kris 


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

Re: Facebook Connect and coldfusion


Kris, would you be willing to share some code.  I'm having a hell of a time 
integrating with the facebook connect API

We're using FBConnect for a site in development now. It works fine, no
problem. Except when FB does something stupid and breaks the API.
Which happens every couple of weeks.

Cheers,
Kris



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

Re: Facebook Connect and coldfusion


Kris,

Would you be willing to share some code?  I'm having a hell of a time 
interfacing with the API


We're using FBConnect for a site in development now. It works fine, no
problem. Except when FB does something stupid and breaks the API.
Which happens every couple of weeks.

Cheers,
Kris 


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

Re: Facebook Connect and coldfusion