Re: Port 51011

2012-08-14 Thread CF Developer

Try CacheBox
http://wiki.coldbox.org/wiki/CacheBox.cfm


On Tue, Aug 14, 2012 at 1:29 PM, Steve LaBadie slaba...@po-box.esu.eduwrote:


 Cameron, the libraries are coming from Google.

 Steve LaBadie, Web Manager
 East Stroudsburg University
 570-422-3999
 slaba...@esu.edu




 -Original Message-
 From: Cameron Childress [mailto:camer...@gmail.com]
 Sent: Tuesday, August 14, 2012 1:02 PM
 To: cf-talk
 Subject: Re: Port 51011


 On Tue, Aug 14, 2012 at 12:49 PM, Steve LaBadie
 slaba...@po-box.esu.eduwrote:
 
  We deployed a new website several weeks ago.
  The average number of jqueries served before July-19 was ~2000 a day;
  now we are serving ~45,000.
 

 10x more traffic? Yeah that will hit you where it hurts for sure. The
 first advise I would give is to look at changing you code to use the
 Google hosted version of these libraries:

 http://encosia.com/3-reasons-why-you-should-let-google-host-jquery-for-y
 ou/


  Also, the rich format of the new website is taxing the ColdFusion
  engine.
 

 Yes, 10x traffic will do that. :)


  When the website seems to stop, the number of connections to CF's port
  51011 increase from about 5 (average normal) to about 500.
 

 This smells like CF is getting hung and IIS continues to send it
 requests.
 This leads to a dogpile effect on CF where it's still receiving new
 requests from IIS but can no longer respond. This is usually due to a
 problem with something getting hung up in your CF code, or with SQL. For
 example, a SQL call that never comes back from the database, or some
 CFHTTP calls that never hear back from their servers, or a CFLOCK tag
 that's in a deadlock.

 If this is in fact the problem - the best way to troubleshoot this is
 install something like FusionReactor on the server and get a stack trace
 while the error is occurring. This will quite literally give you the
 exact line of ColdFusion code causing the problem. I'd bet a dollar that
 it's one of the three things I mentioned above.

 -Cameron

 --
 Cameron Childress
 --
 p:   678.637.5072
 im: cameroncf
 facebook http://www.facebook.com/cameroncf |
 twitterhttp://twitter.com/cameronc
  | google+ https://profiles.google.com/u/0/117829379451708140985




 

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


simple RegEx?

2009-04-02 Thread CF Developer

This should be simple for all you RegEx Gurus.

I have a textarea field that may contain list numbers such as : (i)  (ii).
What I want to do is convert those to LI statements.

I know you have to escape the parathesis but it produces:  LIi)  and LIii)

How can I change it just to an LI statement (regardless on the list number, 
since it can be i, ii, iii, iv)

I tried:

rereplace(myTextField,'\(*\)','ALL')

TIA!



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321211
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


re: Form Fields

2009-03-05 Thread CF Developer


easy:

cfquery name=qData blah blah/cfquery

select name=selList size=1
cfoutput query=qDataoption 
value=#qData.someFieldName1##qData.someFIeldName2#/option
/select

Or 

 cfselect 
   name = employeeid 
size = 15 
required = Yes
message = Select one of these 
query = qData 
display =someFieldName2 
value =someFieldName1
/cfselect

Might want to look through the CF Docs.
http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=splash.html
CFSelect Tag: 
http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_r-s_14.html



From: Pranathi Reddy rk.prana...@gmail.com
Sent: Wednesday, March 04, 2009 9:25 PM
To: cf-talk cf-talk@houseoffusion.com
Subject: Form Fields 

Hi All,

I have an issue and my brain is not working Actually I am trying to pull 
the data back to the formfield from sql database when there is a selection in 
dropdownlist. I am really not sure of how I could realy implement it. 

Any Help???

Thanks,
Pranathi 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320128
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


re: CF / Javascript question

2008-12-17 Thread CF Developer

Why not place a checkbox on the page (after the textarea) 
indicating: 

[ ] I have read the prescribed text.

If the box is checked, fire off a JS to enable the Continue button, else keep 
it disabled.

Just a thought!



From: Jenny Gavin-Wear 
jenn...@fasttrackonline.co.uk
Sent: Wednesday, December 17, 2008 6:54 AM
To: cf-talk cf-talk@houseoffusion.com
Subject: CF / Javascript question 

Hi all,

In a registration procedure, I need to do a verification that the person
registering has read a large piece of text.

The way I thought about doing is is with a scrolling div area which enables
a continue to next page option when the user has scrolled to the bottom of
the text.

How could I best go about this using CF and/or javascript, please?

Grateful for any ideas ...

Jenny



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316865
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: cfqueryparam and LIKE operator error

2008-12-17 Thread CF Developer

It is as Dave suggested, you can not use CFQUERYPARAM as part 
of the actual SQL query.
You are writting the WHERE clause as a variable, remove the queryparam from 
that since you are declaring the variable.



From: JediHomer jediho...@gmail.com
Sent: Wednesday, December 17, 2008 3:17 AM
To: cf-talk cf-talk@houseoffusion.com
Subject: Re: cfqueryparam and LIKE operator error 

Try wrapping the QueryParams...

i.e.

Change (P.product_code LIKE value=%tents%)

to (P.product_code LIKE (value=%tents%))

HTH

2008/12/16 Mike Little :
 hi guys,

 getting an error using the following syntax...

 WHERE ((P.product_code LIKE ) OR (PD.product_title LIKE ) OR 
 (PD.product_description LIKE ))

 the error i get is...

 You have an error in your SQL syntax; check the manual that corresponds to 
 your MySQL server version for the right syntax to use near ') OR 
 (PD.product_title ' at line 9

 this was working fine till i added the cfqueryparams.

 mike

 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316855
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CF Job Market

2008-11-06 Thread CF Developer
I hope neither of you are making that a stereotype. I have 10 years as a CF 
developer, and EVERYTHING I do is OO, and I have a fundamental understanding of 
it, and use the usual OO frameworks like Mach-ii, ColdSpring, and Transfer 
(although I have developed OO apps without a front controller, too), and even 
built my own (closed, sorry) framework to solve specialized problems that the 
standard frameworks didn't. I have architected high-traffic, high-volume and 
high-revenue enterprise applications. Would you see 10 years on my resume and 
throw it out? I hope not.

I didn't post this looking for work, as I have a fulltime job (parttime 
freelance OK). I just wanted to respond to this thread. 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-jobs-talk/message.cfm/messageid:4113
Subscription: http://www.houseoffusion.com/groups/cf-jobs-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11


Re: Why won't this query run in MySQL 5?

2008-09-08 Thread CF Developer
Try the following: (I think MySQL 5 uses the ( ) within the inner join
statements when using multiple conditions ) ** I could be wrong but can't
hurt to try

CFQUERY Name=Get_Client Datasource=#DSN#
Select  C.*, FG.*, E.*
fromclients C
inner join  family_groups FG, employers E on ( C.Family_ID =
FG.Family_ID and C.Employer_ID = E.Employer_ID )
where   C.Family_ID =
   (Select Family_ID
from   clients
where  Client_ID = '#Session.Client_ID#')
and C.Employer_ID =
   (Select Employer_ID
from   clients
where  Client_ID = '#Session.Client_ID#')
and C.Client_ID = '#URL.Client_ID#'

/CFQUERY


On Mon, Sep 8, 2008 at 8:26 AM, Will Tomlinson [EMAIL PROTECTED] wrote:

  Hi, all...
 
  I've just moved a website from a server running MySQL 4.1 to
  a server running MySQL 5 and now this query is giving me problems.
 

 I think the problem is in your uppercase CFQUERY tags.  Heehhehe...:)

 Seriously though, I've encountered the same kind of problems between MySQL
 versions. Sorry I can't help with your syntax problem. Just letting you know
 this isn't uncommon.

 Will

 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312171
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: cfinvoke webservice

2008-08-25 Thread CF Developer
are you sure the method that you are calling exists in the CFC file?

On 8/25/08, Bosky, Dave [EMAIL PROTECTED] wrote:

 Trying to invoke a webservice using CF but it keeps failing due to some
 error. Is there a common problem related to this error msg?

 Cannot perform web service invocation myMethodName.
 The fault returned when invoking the web service operation is:

 AxisFault
 faultCode: {http://xml.apache.org/axis/}HTTP
 faultSubcode:
 faultString: (500)Internal Server Error
 faultActor:
 faultNode:
 faultDetail: {}:return code:  500

 Thanks,

 Dave

 **
 HTC Disclaimer:  The information contained in this message may be
 privileged and confidential and protected from disclosure. If the reader of
 this message is not the intended recipient, or an employee or agent
 responsible for delivering this message to the intended recipient, you are
 hereby notified that any dissemination, distribution or copying of this
 communication is strictly prohibited.  If you have received this
 communication in error, please notify us immediately by replying to the
 message and deleting it from your computer.  Thank you.
 **


 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311496
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


(ot) Stupid HTML Question

2008-07-23 Thread Experienced CF Developer
Okay, I must be having a brain fart today - I'm trying to get a cell in a
table to NOT wrap.  I actually want the text that doesn't fit to be hidden.
What am I missing? (btw, I'm coding only for IE for an internal app).  I've
done this before, just can't remember what I did.  I want the second cell to
NOT wrap.  Here's some test code:

table border=1 cellspacing=0 cellpadding=0 width=150
style=table-layout: fixed; 
col width=50/ 
col width=50/ 
col width=50/ 
tr 
tdnbsp;/td 
tdTest Test Test Test Test Test Test Test Test Test Test Test Test Test
Test Test Test Test Test Test Test Test Test /td
tdnbsp;/td 
/tr 
/table

What am I missing?

Dave Phillips


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309507
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: (ot) Stupid HTML Question

2008-07-23 Thread Experienced CF Developer
Wim,

This didn't work for me.  I still get the following:

http://www.zarts.com/test.cfm

Dave

-Original Message-
From: Wim Lemmens [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 23, 2008 8:04 AM
To: CF-Talk
Subject: Re: (ot) Stupid HTML Question

td style=width: 100px; overflow: hidden; nowrapTest Test Test Test Test
Test Test Test Test Test Test Test Test Test
Test Test Test Test Test Test Test Test Test /td

On Wed, Jul 23, 2008 at 3:00 PM, Experienced CF Developer 
[EMAIL PROTECTED] wrote:

 Okay, I must be having a brain fart today - I'm trying to get a cell in a
 table to NOT wrap.  I actually want the text that doesn't fit to be
hidden.
 What am I missing? (btw, I'm coding only for IE for an internal app).
I've
 done this before, just can't remember what I did.  I want the second cell
 to
 NOT wrap.  Here's some test code:

 table border=1 cellspacing=0 cellpadding=0 width=150
 style=table-layout: fixed;
 col width=50/
 col width=50/
 col width=50/
 tr
 tdnbsp;/td
 tdTest Test Test Test Test Test Test Test Test Test Test Test Test Test
 Test Test Test Test Test Test Test Test Test /td
 tdnbsp;/td
 /tr
 /table

 What am I missing?

 Dave Phillips


 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309513
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: (ot) Stupid HTML Question

2008-07-23 Thread Experienced CF Developer
This did exactly what I want.  Thanks!  That's not how I did it before
because I didn't even know about this tag. LOL.  But hey, I'm not
complaining. :)

Thanks!

Dave

-Original Message-
From: Robert Harrison [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 23, 2008 8:13 AM
To: CF-Talk
Subject: RE: (ot) Stupid HTML Question

You could also wrap the contents in the nobrwill not wrap/nobr tag.


Robert B. Harrison
Director of Interactive services
Austin  Williams
125 Kennedy Drive, Suite 100 Hauppauge NY 11788
T : 631.231.6600 Ext. 119 
F : 631.434.7022
www.austin-williams.com

Great advertising can't be either/or... It must be .
-Original Message-
From: Experienced CF Developer [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 23, 2008 9:00 AM
To: CF-Talk
Subject: (ot) Stupid HTML Question

Okay, I must be having a brain fart today - I'm trying to get a cell in a
table to NOT wrap.  I actually want the text that doesn't fit to be hidden.
What am I missing? (btw, I'm coding only for IE for an internal app).  I've
done this before, just can't remember what I did.  I want the second cell to
NOT wrap.  Here's some test code:


Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309507
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=28801.20441.4


__ NOD32 3290 (20080723) Information __

This message was checked by NOD32 antivirus system.
http://www.eset.com






~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309514
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: (ot) Stupid HTML Question

2008-07-23 Thread Experienced CF Developer
Wim,

The nobr tag did what I wanted.  The code below did not work as you would
think it should (I had already tried those options myself).  If you look at
the page at http://www.zarts.com/test.cfm you will see the code you gave me
below but you will also see that the cell still wraps.

Thanks though!

Dave

-Original Message-
From: Wim Lemmens [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 23, 2008 8:52 AM
To: CF-Talk
Subject: Re: (ot) Stupid HTML Question

That's what you wanted, no?

You say I actually want the text that doesn't fit to be hidden.
That's what you get.

Please explain correctly what you want.

Wim.

On Wed, Jul 23, 2008 at 3:49 PM, Experienced CF Developer 
[EMAIL PROTECTED] wrote:

 Wim,

 This didn't work for me.  I still get the following:

 http://www.zarts.com/test.cfm

 Dave

 -Original Message-
 From: Wim Lemmens [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, July 23, 2008 8:04 AM
 To: CF-Talk
 Subject: Re: (ot) Stupid HTML Question

 td style=width: 100px; overflow: hidden; nowrapTest Test Test Test
Test
 Test Test Test Test Test Test Test Test Test
 Test Test Test Test Test Test Test Test Test /td

 On Wed, Jul 23, 2008 at 3:00 PM, Experienced CF Developer 
 [EMAIL PROTECTED] wrote:

  Okay, I must be having a brain fart today - I'm trying to get a cell in
a
  table to NOT wrap.  I actually want the text that doesn't fit to be
 hidden.
  What am I missing? (btw, I'm coding only for IE for an internal app).
 I've
  done this before, just can't remember what I did.  I want the second
cell
  to
  NOT wrap.  Here's some test code:
 
  table border=1 cellspacing=0 cellpadding=0 width=150
  style=table-layout: fixed;
  col width=50/
  col width=50/
  col width=50/
  tr
  tdnbsp;/td
  tdTest Test Test Test Test Test Test Test Test Test Test Test Test
Test
  Test Test Test Test Test Test Test Test Test /td
  tdnbsp;/td
  /tr
  /table
 
  What am I missing?
 
  Dave Phillips
 
 
 



 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309517
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: (ot) Stupid HTML Question

2008-07-23 Thread Experienced CF Developer
Ah, that's it.  I'm only developing for IE for an internal app.

Dave

-Original Message-
From: Wim Lemmens [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 23, 2008 9:00 AM
To: CF-Talk
Subject: Re: (ot) Stupid HTML Question

I only checked in FireFox. There it works correctly.
IE messes it up...

On Wed, Jul 23, 2008 at 3:56 PM, Experienced CF Developer 
[EMAIL PROTECTED] wrote:

 Wim,

 The nobr tag did what I wanted.  The code below did not work as you
would
 think it should (I had already tried those options myself).  If you look
at
 the page at http://www.zarts.com/test.cfm you will see the code you gave
 me
 below but you will also see that the cell still wraps.

 Thanks though!

 Dave

 -Original Message-
 From: Wim Lemmens [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, July 23, 2008 8:52 AM
 To: CF-Talk
 Subject: Re: (ot) Stupid HTML Question

 That's what you wanted, no?

 You say I actually want the text that doesn't fit to be hidden.
 That's what you get.

 Please explain correctly what you want.

 Wim.

 On Wed, Jul 23, 2008 at 3:49 PM, Experienced CF Developer 
 [EMAIL PROTECTED] wrote:

  Wim,
 
  This didn't work for me.  I still get the following:
 
  http://www.zarts.com/test.cfm
 
  Dave
 
  -Original Message-
  From: Wim Lemmens [mailto:[EMAIL PROTECTED]
  Sent: Wednesday, July 23, 2008 8:04 AM
  To: CF-Talk
  Subject: Re: (ot) Stupid HTML Question
 
  td style=width: 100px; overflow: hidden; nowrapTest Test Test Test
 Test
  Test Test Test Test Test Test Test Test Test
  Test Test Test Test Test Test Test Test Test /td
 
  On Wed, Jul 23, 2008 at 3:00 PM, Experienced CF Developer 
  [EMAIL PROTECTED] wrote:
 
   Okay, I must be having a brain fart today - I'm trying to get a cell
in
 a
   table to NOT wrap.  I actually want the text that doesn't fit to be
  hidden.
   What am I missing? (btw, I'm coding only for IE for an internal app).
  I've
   done this before, just can't remember what I did.  I want the second
 cell
   to
   NOT wrap.  Here's some test code:
  
   table border=1 cellspacing=0 cellpadding=0 width=150
   style=table-layout: fixed;
   col width=50/
   col width=50/
   col width=50/
   tr
   tdnbsp;/td
   tdTest Test Test Test Test Test Test Test Test Test Test Test Test
 Test
   Test Test Test Test Test Test Test Test Test /td
   tdnbsp;/td
   /tr
   /table
  
   What am I missing?
  
   Dave Phillips
  
  
  
 
 
 
 



 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309521
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Consuming a Web Service with CF8

2008-07-23 Thread Experienced CF Developer
Steve,

Try hitting it with CFHTTP and see what you get:

cfhttp url=https://devurl.asmx?method=ZNAPing;/cfhttp
cfdump var=#cfhttp#

See what you get.  Maybe it's not written as a 'real' web service and simply 
just returns xml?

Dave
-Original Message-
From: Steve Sequenzia [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, July 23, 2008 1:41 PM
To: CF-Talk
Subject: Consuming a Web Service with CF8

Just to get this out of the way. I am pretty much brand new to web services so 
please excuse my lack of knowledge.

I have been working on a real small web app that allows the customer to input 
an invoice then it kicks out a csv of the invoices. My problem is that the 
vendor just added an additional step that requires that I check the invoice 
against a web service that will tell me if it is valid.

The vendor gave me a basic document that lays out the web services. There are 2 
web services one is just a ping and the other actually checks the invoice. I 
cannot get either of them to work and I am not sure why. Here is the info for 
the ping web service that they sent:

ZNAPing

Purpose:This web service was created to give an external customer an 
opportunity to verify availability of the ZNA Claims Web Services before 
calling in with actual request.

Signature:string ZNAPing( void );

Input:NONE

Result:string.

Note:Successful return will contain an XML fragment with the following 
information

ZNAPingResult
timeStamp9/24/2004 8:24:58 AM/timeStamp
Version0.61/Version
/ZNAPingResult

Client can parse this string to extract some information - timeStamp element 
contains date and time of the call, Version element – contains the 
version of the web services.


I have been trying to consume it using cfinvoke like this:

cfinvoke webservice = https://devurl.asmx; 
method = ZNAPing
returnVariable = getBack
username=username
password=password

cfoutput#getBack#/cfoutput

I am getting this error when I run it:

 Unable to parse WSDL as an XML document.
Parsing error: Fatal Error: URI=null Line=69: The element type p must be 
terminated by the matching end-tag 

Again, I am very new to web services so I am sure I am doing something wrong. 
If anyone could help point me in the right direction that would be very helpful.

Thanks in advance for any help.




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309540
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: DataSource Events like Before Commit?

2008-07-22 Thread Experienced CF Developer
Joseph,

I don't think what you are trying to do is possible.  Can you give us some
more details of what you are trying to accomplish to see if we can help you
come up with an alternative solution?

Sincerely,

Dave Phillips

-Original Message-
From: Joseph Bugeja [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 22, 2008 4:50 AM
To: CF-Talk
Subject: DataSource Events like Before Commit?

Dear ColdFusion Users,

Is there a way that I can attach to a datasource through an event like
before_commit or before_update?

So, if I have a cfquery tag, and I would ColdFusion to automatically, before
ColdFusion executes the code found in the cfquery I would like it to
automatically execute another query for example to set the user id to the
database? In this way I do not need to make any modification to the existing
code except that of creating new code to do something before executing my
main query?
   
Thanks in advance for your assistance.

Regards,
Joseph. 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309432
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: DataSource Events like Before Commit?

2008-07-22 Thread Experienced CF Developer
Joseph,

I think Gert's suggestion earlier could work for you.  You could design a
trigger to fire the stored procedure prior to any Inserts or Updates.  Check
out this page on oracle site for some direction:

http://tinyurl.com/5sjhlg

I haven't done anything with triggers myself.  But if you want to avoid
re-coding your CFML, I think this is your route to go.

Of course, this will only work for you if the only thing changing your
tables is your CF app.  Any manual changes to the database, or any other
application accessing the same database would fire the triggers as well,
unless you can figure out a way to make them fire only when your app
accesses the database.

Hope this helps,

Dave Phillips

-Original Message-
From: Joseph Bugeja [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 22, 2008 6:51 AM
To: CF-Talk
Subject: Re: DataSource Events like Before Commit?

Thanks for your reply. Let me explain our scenario.

We have a number of cfquery tags that insert, update and delete data from
our Oracle database. Basically, before each query is run I need to execute a
stored procedure. This stored procedure sets the userid (the user currently
logged in) in the database for auditing purposes. We have hundreds of
queries and it is not good from a design perspective to rewrite each query
to call the same central piece of code before each query gets executed. 

So my original query should be:
  Original Query:
   cfquery
  DML Operation
   /cfquery

New requirement should be:
   cftransaction
 cfstoredproc   
Set the user id 
 /cfstoredproc   
 cfquery
DML Operation
 /cfquery 
   /cftransaction

As shown above, I need to call the cfstoredproc before each query is
executed. Personally, I would prefer if I keep my original design and before
the original query is run the ColdFusion engine automatically injects the
new call in a transaction to set the clientid.

Do you have any suggestions?

Joseph,

I don't think what you are trying to do is possible.  Can you give us some
more details of what you are trying to accomplish to see if we can help you
come up with an alternative solution?

Sincerely,

Dave Phillips

Dear ColdFusion Users,

Is there a way that I can attach to a datasource through an event like
before_commit or before_update?

So, if I have a cfquery tag, and I would ColdFusion to automatically,
before
ColdFusion executes the code found in the cfquery I would like it to
automatically execute another query for example to set the user id to the
database? In this way I do not need to make any modification to the
existing
code except that of creating new code to do something before executing my
main query?
   
Thanks in advance for your assistance.

Regards,
Joseph. 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309439
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: DataSource Events like Before Commit?

2008-07-22 Thread Experienced CF Developer
Got it.  Now I understand better.  You want to pass the userid of your
'logged in user' to track the change in the database instead of using the
user id that the datasource is logged in as.

I don't see any way for you to do this without changing your code.  Maybe
someone else can come up with something, but I just don't see any way around
it.  Whether you change it to implement the idea you had below or do it some
other way, bottom line is, you will need to change your code to make Oracle
aware of each individual user's ID.

You might still be able to find a way to use the triggers, but I still think
you'll need a code change.

Sorry, no help.

Dave
-Original Message-
From: Joseph Bugeja [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 22, 2008 7:28 AM
To: CF-Talk
Subject: Re: DataSource Events like Before Commit?

Thanks again for your reply.

Unfortunately, I need to pass the userid prior to executing each query as
otherwise the auditing function would not know the userid. We have triggers
on tables but triggers need the read the userid apriori.

ColdFusion does not allow us to build our connection string dynamically or
to dynamically inject connection string variables (such as the userid), as
is the case with VB.NET and C#. This is why I am looking for an alternative.

Joseph,

I think Gert's suggestion earlier could work for you.  You could design a
trigger to fire the stored procedure prior to any Inserts or Updates.
Check
out this page on oracle site for some direction:

http://tinyurl.com/5sjhlg

I haven't done anything with triggers myself.  But if you want to avoid
re-coding your CFML, I think this is your route to go.

Of course, this will only work for you if the only thing changing your
tables is your CF app.  Any manual changes to the database, or any other
application accessing the same database would fire the triggers as well,
unless you can figure out a way to make them fire only when your app
accesses the database.

Hope this helps,

Dave Phillips

Thanks for your reply. Let me explain our scenario.

We have a number of cfquery tags that insert, update and delete data from
our Oracle database. Basically, before each query is run I need to execute
a
stored procedure. This stored procedure sets the userid (the user currently
logged in) in the database for auditing purposes. We have hundreds of
queries and it is not good from a design perspective to rewrite each query
to call the same central piece of code before each query gets executed. 

So my original query should be:
  Original Query:
   cfquery
  DML Operation
   /cfquery

New requirement should be:
   cftransaction
 cfstoredproc   
   Set the user id 
 /cfstoredproc   
 cfquery
   DML Operation
 /cfquery 
   /cftransaction

As shown above, I need to call the cfstoredproc before each query is
executed. Personally, I would prefer if I keep my original design and
before
the original query is run the ColdFusion engine automatically injects the
new call in a transaction to set the clientid.

Do you have any suggestions?

before
ColdFusion executes the code found in the cfquery I would like it to
automatically execute another query for example to set the user id to the
database? In this way I do not need to make any modification to the
existing
code except that of creating new code to do something before executing my
main query?
   
Thanks in advance for your assistance.

Regards,
Joseph. 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309445
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: DataSource Events like Before Commit?

2008-07-22 Thread Experienced CF Developer
Joseph,

I did some googling and found that Oracle has 'proxy user authentication'.
See this Ask Tom article (someone wanting to do the same thing as you are,
but in java):

http://tinyurl.com/6qe8xk

Although I don't know if you can do it with the ColdFusion setup directly,
but maybe you can access some underlying java component to do it.  Hopefully
this might give you another alternative.  Let me know how it turns out.

Dave 

-Original Message-
From: Joseph Bugeja [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 22, 2008 7:57 AM
To: CF-Talk
Subject: Re: DataSource Events like Before Commit?

Exactly!

You perfectly understood my concern. If ColdFusion supported dynamic
connection parameter injection or proxy authentication then we can identify
the connection pool users but there is no straightforward solution to this.
Through pooling we are connected through one db user which for security
complaince (PCI) we need to remove this hole while keeping the benefits of
pooling. Triggers can help certainly help us for auditing but again at db
level I do not want have the same user showing up in my logs. 

Got it.  Now I understand better.  You want to pass the userid of your
'logged in user' to track the change in the database instead of using the
user id that the datasource is logged in as.

I don't see any way for you to do this without changing your code.  Maybe
someone else can come up with something, but I just don't see any way
around
it.  Whether you change it to implement the idea you had below or do it
some
other way, bottom line is, you will need to change your code to make Oracle
aware of each individual user's ID.

You might still be able to find a way to use the triggers, but I still
think
you'll need a code change.

Sorry, no help.

Dave
Thanks again for your reply.

Unfortunately, I need to pass the userid prior to executing each query as
otherwise the auditing function would not know the userid. We have triggers
on tables but triggers need the read the userid apriori.

ColdFusion does not allow us to build our connection string dynamically or
to dynamically inject connection string variables (such as the userid), as
is the case with VB.NET and C#. This is why I am looking for an
alternative.

Joseph,

I think Gert's suggestion earlier could work for you.  You could design a
trigger to fire the stored procedure prior to any Inserts or Updates.
Check
a
before 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309453
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: (ot) URL Hack Attempt Leaves Me Scractching My Head... For Mark Kruger

2008-07-22 Thread Experienced CF Developer
Okay, stupidly, I clicked on rent.com (? Used to avoid perpetuation) to
see what Brian was talking about and now I see the reference to a .js file
on one of the pages.  I didn't just infect my pc with something, did I?

I surely hope that we are not perpetuating some virus with these e-mails.  

Also, Brian, IMHO, I think your comment would have been more appropriate to
make off-list.

Sincerely,

Dave Phillips


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309469
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: ('1,1') * 1 = 39448

2008-07-22 Thread Experienced CF Developer
Looked like it could be a ColdFusion date value to me.  So I did a
dateFormat() on that and came up with 01/01/2008:

cfset nValue = 1,1 * 1
cfoutput#dateFormat(nValue,mm/dd/)#brbr/cfoutput

It's assuming 1,1 is the current month and year.  I did the same for
5,23 * 1 and got 05/23/2008.

What's really fun is if you do 1,1 * 2..

Go ahead... see what you get.  10/15/2116

Now go figure THAT one out!

Dave Phillips

-Original Message-
From: Bert Dawson [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 22, 2008 5:08 PM
To: CF-Talk
Subject: ('1,1') * 1 = 39448

I tracked down a defect to a piece of code which basically did the
following:

total = form.quantity * form.itemamount

In some cases, form.quantity is commong through as *1,1* which is presumably
due to an HTML issue with duplicate form fields with the same name.

But rather than getting a CF error cos 1,1 isn't a number, it evaluates to
39448!

i.e.
cfoutput'1,1' * 1 = #'1,1' * 1#/cfoutput
produces:
   '1,1' * 1 = 39448

I'm not worried about the original problem with the form.quantity coming
though as *1,1* rather than the expected *1* since I can fix that, but i'm
curious as to any reason for this odd result.

It looks like (x,y) * 1 is the same as (y,x) * 1
In other words
cfoutput#'5,23' * 1# = #'23,5' * 1# = 39591/cfoutput

As i say, i'm not worried about fixing the defect, but i'm just curious if
there is an underlying explanation for the apparently wierd behaviour. Or is
it just a bug in the way CF does the conversion?

Cheers
Bert

p.s. FWIW here's a snippet which will create a 101 square grid of all the
combinations:

table border=1
cfloop from=0 to=100 index=i
tr
cfloop from=0 to=100 index=j
td nowrap=true#wtf(i,j)#/td
/cfloop
/tr
/cfloop
/table

cfscript
function wtf(a,b) {
var x = '#a#,#b#';
try {
return '#x#*1 = '  x*1;
}
catch(Any E) {
return '#x#*1 pukes';
}
}
/cfscript




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309490
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Mystery Character

2008-07-21 Thread Experienced CF Developer
Robert,

Can't see the character, but check out http://www.asciitable.com and see if
you can find it there.

Dave

-Original Message-
From: Robert Harrison [mailto:[EMAIL PROTECTED] 
Sent: Monday, July 21, 2008 3:17 PM
To: CF-Talk
Subject: Mystery Character

Does anyone know the character code for this character: .

My Mac users are uploading files with this character and it does not work in
a URL string... I'd kill it but I don't know what character it is. Using .
in a regex replace does not work. 



Robert B. Harrison
Director of Interactive services
Austin  Williams
125 Kennedy Drive, Suite 100 Hauppauge NY 11788
T : 631.231.6600 Ext. 119 
F : 631.434.7022
www.austin-williams.com

Great advertising can't be either/or... It must be .





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309392
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Mystery Character

2008-07-21 Thread Experienced CF Developer
Doesn't asc('x') do that?  Or am I missing something?

Dave

-Original Message-
From: Brad Wood [mailto:[EMAIL PROTECTED] 
Sent: Monday, July 21, 2008 3:53 PM
To: CF-Talk
Subject: RE: Mystery Character

I've ran into things like this before.  Is there a CF function (or even
a way in Java) to take a character and return the ASCII code for it?
(Or whatever is appropriate, I don't know if ASCII is really the right
term)

~Brad

-Original Message-
From: morgan l [mailto:[EMAIL PROTECTED] 
Sent: Monday, July 21, 2008 3:49 PM
To: CF-Talk
Subject: Re: Mystery Character

Try here:
http://www.miniguidez.com/macosx/keystrokesguide/specialcharacters/speci
alcharacters.html
It lists decimal and hex values for corresponding mac keystrokes.



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309403
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Mystery Character

2008-07-21 Thread Experienced CF Developer
Actually, I just looked it up:

http://livedocs.adobe.com/coldfusion/6/CFML_Reference/functions-pt121.htm

According to this page, starting in MX 6, asc() supports values up to 65536,
so it should work for you.

Output your character value to the screen with asc(sFunkyCharacter) and
you'll find out the value of it.

Another thing you could do, if you really wanted to, was check all asc()
values if each character in your string and if they exceed 255, then leave
them out.  That will ensure it works properly on Windows File System (which
I'm assuming is the issue you are having).

Dave

-Original Message-
From: Brad Wood [mailto:[EMAIL PROTECTED] 
Sent: Monday, July 21, 2008 3:53 PM
To: CF-Talk
Subject: RE: Mystery Character

I've ran into things like this before.  Is there a CF function (or even
a way in Java) to take a character and return the ASCII code for it?
(Or whatever is appropriate, I don't know if ASCII is really the right
term)

~Brad

-Original Message-
From: morgan l [mailto:[EMAIL PROTECTED] 
Sent: Monday, July 21, 2008 3:49 PM
To: CF-Talk
Subject: Re: Mystery Character

Try here:
http://www.miniguidez.com/macosx/keystrokesguide/specialcharacters/speci
alcharacters.html
It lists decimal and hex values for corresponding mac keystrokes.



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309404
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: (ot) URL Hack Attempt Leaves Me Scractching My Head...

2008-07-21 Thread Experienced CF Developer
And for those of you who take this advice and DO use cfqueryparam
***always*** make sure you NEVER use SELECT * (which you shouldn't do
anyway).

I inherited an application that had a ton of SELECT * all over it and no
cfqueryparam tags.  Over the years I added cfqueryparam tags as I worked on
the application, adding new features, and updated old ones/fixing bugs.
Then I ran into a situation.  If I didn't update the SELECT * to include
actual column names, and one of the column names got dropped from the table
I was referencing in my SELECT query with a cfqueryparam, then BAM, the
application would break.  

Two hard and fast rules to live by:

1.  Use cfqueryparam - ALWAYS
2.  Use SELECT * - NEVER

I'm sure someone will now provide some comment as when generalizations are
usually made, someone has a dissenting opinion (to which, of course, you are
fully entitled!) :)

Sincerely,

Dave Phillips

-Original Message-
From: Matt Quackenbush [mailto:[EMAIL PROTECTED] 
Sent: Monday, July 21, 2008 4:21 PM
To: CF-Talk
Subject: Re: (ot) URL Hack Attempt Leaves Me Scractching My Head...

Did I really just read that?  Please, someone, anyone, tell me that I
didn't.

Claude, you're certainly free to do what you wish to do in your own
applications, so this comment is not directed to you at all.

For those of you who are actually trying to learn and become better
programmers/developers, please, do yourselves, your bosses, your fellow
developers, and your clients a HUGE favor and completely ignore the advice
of anyone that tells you not to use cfqueryparam.  If you have read this
thread, or any thread like it and you're not using it, you deserve what you
get.

Bottom line: ***always*** use cfqueryparam.  Period.  There are no
acceptable exceptions to the rule.

On Mon, Jul 21, 2008 at 3:54 PM, Claude Schneegans wrote:

 CFQUERYPARAM is a nice and powerful feature, but it makes SQL code more
 difficult to read,
 so the best is to use it only when it is really necessary.
 For me, using CFQUERYPARAM systematically for every parameter is as stupid
 as never using it at all.





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309411
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: unoffical ahphosting thread

2008-02-28 Thread CF Developer
I am not going to blame Greg for SWSoft's F-up
 
Is AHP just one guy? What were you guys expecting? Greg chose to use SWSoft 
software. They may be at fault but he is responsible. Also if he makes an 
upgrade and doesn't have enough help if things go wrong, that is also his 
fault. SWSoft isn't to blame for over a week of downtime. That was Greg.
 
 Subject: re: unoffical ahphosting thread From: [EMAIL PROTECTED] To: 
 cf-talk@houseoffusion.com Date: Wed, 27 Feb 2008 11:14:04 -0600  I a have 
 been with them for a while and don't plan on leaving anytime soon. While 
 this is a major ouch...I too have enjoyed the one on one relationship with 
 greg and the speed at which he normally gets things done. My sites are all 
 still down as of last night. He is normally very quick to address problems 
 when they occur. Much like I don't blame MS for hardware manufacturer's 
 failings, I am not going to blame Greg for SWSoft's F-up ;-). THough I do 
 agree with some of theother comments...it would be nice to have emails sent 
 out periodically even if just to say it's still broke, but I am working on 
 it. Doing that would provide a good diversion from trying to fix the 
 code...sometimes that helps get it done faster.  Eric   

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300101
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


re: Getting the data time from an unfamiliar returned value

2007-11-28 Thread CF Developer

Initial thought is the date /time would be:  11/21/2007 @ 7:35 
(PM)  ( 28 seconds as well).
The 000Z would probable reference the date/time is in a Zulu Time.

Now using CF to format it, if you can use RegEx and parse the T and .000Z 
and see if it validates as a date/time object.
Other than that, may have to parse it more.

My 2 cents. Maybe someone else has already done this or something easier



From: Che Vilnonis [EMAIL PROTECTED]
Sent: Wednesday, November 28, 2007 11:38 AM
To: CF-Talk cf-talk@houseoffusion.com
Subject: Getting the data  time from an unfamiliar returned value 

Here is the value: 2007-11-21T19:35:28.000Z
It comes from the eBay REST API. It is in a format I have not seen. What can
I do (with CF) to pull a valid date and time?

Thanks, Che



~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293927
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Is FigLeaf down?

2007-11-15 Thread CF Developer
Is the FigLeaf site down? I can't seem to get to any of their sites?
 
_
Discover the new Windows Vista
http://search.msn.com/results.aspx?q=windows+vistamkt=en-USform=QBRE

~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293363
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Is FigLeaf down?

2007-11-15 Thread CF Developer
It's still up for me here (offsite) so maybe there's something
else going on. My guess is some DNS problem earlier today.
 
Maybe so, one of your dns servers seems to be down right now and the other is 
throwing errors.
 
http://www.dnsreport.com/tools/dnsreport.ch?domain=figleaf.com
 
_
Windows Live Hotmail and Microsoft Office Outlook – together at last.  Get it 
now.
http://office.microsoft.com/en-us/outlook/HA102225181033.aspx?pid=CL100626971033

~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293436
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: OT: CFEclipse / SVN problem

2007-11-13 Thread CF Developer

ok I can deal with that, however, do you have a link or 
something I can look at how to setup the host name to be mapped to a directory 
(client code)?

TIA!



From: Tom Chiverton [EMAIL PROTECTED]
Sent: Tuesday, November 13, 2007 11:23 AM
To: CF-Talk cf-talk@houseoffusion.com
Subject: Re: OT: CFEclipse / SVN problem 

On Tuesday 13 Nov 2007, ColdFusion wrote:
 That way I can always use: http://localhost for each client as a top level
 domain.

Unrelated aside: most* people normally* setup http://projectname.localdomain 
or something, so each project has a different host name.

-- 
Tom Chiverton
Helping to biannually exploit out-of-the-box infrastructures
on: http://thefalken.livejournal.com



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 St 
James's Court Brown Street Manchester M2 2JF. A list of members is available 
for inspection at the registered office. Any reference to a partner in relation 
to Halliwells LLP means a member of Halliwells LLP. 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.com.



~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293232
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: OT: CFEclipse / SVN problem

2007-11-13 Thread CF Developer

Disregard:

I found the following link to work like a charm:
http://devlicio.us/blogs/ziemowit_skowronski/archive/2007/03/01/multiple-sites-and-host-headers-on-localhost-with-iis7.aspx



From: CF Developer [EMAIL PROTECTED]
Sent: Tuesday, November 13, 2007 12:16 PM
To: CF-Talk cf-talk@houseoffusion.com
Subject: Re: OT: CFEclipse / SVN problem 

ok I can deal with that, however, do you have a link or something I can look at 
how to setup the host name to be mapped to a directory (client code)?

TIA!



From: Tom Chiverton 
Sent: Tuesday, November 13, 2007 11:23 AM
To: CF-Talk 
Subject: Re: OT: CFEclipse / SVN problem 

On Tuesday 13 Nov 2007, ColdFusion wrote:
 That way I can always use: http://localhost for each client as a top level
 domain.

Unrelated aside: most* people normally* setup http://projectname.localdomain 
or something, so each project has a different host name.

-- 
Tom Chiverton
Helping to biannually exploit out-of-the-box infrastructures
on: http://thefalken.livejournal.com



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 St 
James's Court Brown Street Manchester M2 2JF. A list of members is available 
for inspection at the registered office. Any reference to a partner in relation 
to Halliwells LLP means a member of Halliwells LLP. 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.com.



~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293238
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


CFStoredProc

2007-11-09 Thread CF Developer


This should have been simple as making a PBJ. 

I am calling a SP (SQL Server 2005) using the 
CFStoredProc function and to get the result set returned as nextval.
Basically it should return an interget value. 

cfstoredproc 
datasource=#application.datasource# procedure=usp_select_nextval
   cfprocparam type=In cfsqltype=CF_SQL_VARCHAR value=DataTrack_Block
   cfprocresult name = nextval
/cfstoredproc 

Now if I try to use CFDump to 
dump the results set nextval it indicates the variable does not exist.

What is it I am missing? It has ot be something I can say DOH about. 





~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293036
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CFStoredProc

2007-11-09 Thread CF Developer

The storedProc only returns a single interget value not a 
database object or field.
It runs a Query, gets a value, increments the value, updates the table and 
returns the new calculated value.

such as:  database table as a field called: thisVal and that field is set to 1
It will increment it to 2, updates the table
and set to return 2

as:  return @nextVal

I thought the dbvarname is used to specify the FIELD that you would want to be 
returned.



From: Bruce Sorge [EMAIL PROTECTED]
Sent: Friday, November 09, 2007 8:24 AM
To: CF-Talk cf-talk@houseoffusion.com
Subject: Re: CFStoredProc 

It looks like you are missing the DBVAR name.

CF Developer wrote:
 This should have been simple as making a PBJ. 

 I am calling a SP (SQL Server 2005) using the CFStoredProc function and to 
 get the result set returned as nextval.
 Basically it should return an interget value. 

 
 
 
 

 Now if I try to use CFDump to dump the results set nextval it indicates the 
 variable does not exist.

 What is it I am missing? It has ot be something I can say DOH about. 

 

 



~|
ColdFusion is delivering applications solutions at at top companies 
around the world in government.  Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293043
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


CFGrid issue

2007-11-02 Thread CF Developer
I am having an issue with using a CFGRID. I am display the  grid with maybe 4 
columns of data.
My first column is an ID column. 

My goal is to click on a row and it will send the user to a new page with the 
ID value being part of the URL.
such as:  onClick url would be:  test.cfm?id=1  or 2 whichever the ID value is.

Any idea why this will not work and will just add a # to the existing URL?

cfgrid 
  name=datatrack 
  format=HTML 
  query=qGetAllDataTracks 
  selectmode=row 
  onchange=getURL('test.cfm?ID=' + 
datatrack.dataProvider[datatrack.selectedIndex]['ID']);





~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292572
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Fusebox session wackiness in WWW.domainname.com and domainname.com

2007-02-07 Thread CF Developer
I have a problem that I've never seen before concerning fusebox sessions and 
wondered if anyone has any input/advice.

My application is built using Fusebox 5. Several session variables are set when 
a user first visits the site (in fusebox.init.cfm), after a check is performed 
to see if they already exist or not, including a persistent shopping cart.

Sessions work fine when someone is on http://www.domainname.com. However, the 
Flash developer added a link to an ad on the home page that uses 
http://domainname.com (without the WWW).

When someone clicks that link, sessions get completely hosed. I dumped all the 
session vars on that particular page under both WWW.domainname.com and 
domainname.com. WWW.domainname.com shows a session ID and URLtoken. 
domainname.com does not. It's like sessions are not even being created when 
someone is on domainname.com.

Also, I'm using fusebox.appinit.cfm to set some app variables. I have a URL 
string I use to reload the app vars whenever I make a change to appinit. I've 
noticed that if I make a change, upload appinit, and reload the app on 
WWW.domainname.com, the vars are reset just fine. However, they are NOT reset 
on domainname.com -- I'll click the link in the Flash ad, view source, and the 
app vars have not been reloaded.

The DNS set up looks fine. The hosting administrator doesn't have a clue. 
They're sure both domains are on the same server. I've tried using the 
persistent session var methods (setting them as client vars) described in the 
tech docs with no luck (same thing).

Has anyone run across this before? TIA!

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269044
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Fusebox session wackiness in WWW.domainname.com and domainname.com

2007-02-07 Thread CF Developer
Yes, I tried that as well. No dice.

I think this issue can be addressed by setting setdomaincookies = true in 
your cfapplication tag.

-- Josh

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269051
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Fusebox session wackiness in WWW.domainname.com and domainname.com

2007-02-07 Thread CF Developer
Or, I guess I should say, it works to a point ... when I go to the page via the 
domainname.com link, the session is not apparent ... I have to refresh the page 
to get the session information to display -- it doesn't require this on any 
other page under WWW.domainname.com

Yes, I tried that as well. No dice.

I think this issue can be addressed by setting setdomaincookies = true in 
your cfapplication tag.

-- Josh

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269052
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Fusebox session wackiness in WWW.domainname.com and domainname.com

2007-02-07 Thread CF Developer
Yes, there's a dns record for both.

Are you sure that there is a dns record for both or a wildcard * ?

Dan Vega
http://www.danvega.org/blog/

On 2/7/07, CF Developer [EMAIL PROTECTED] wrote:


~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269053
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


webroot level?

2004-07-22 Thread CF Developer
i know there is a way, just not coming to mind.

what I want to be able to do is specify the root level of an application 
w/o having to set a request variable.

such as:
request.images = images/

or if i am one folder down:
request.images = ../images/

isn't there a way to specify something like:

img src="">

and it point to the root of the web app regardless of how many folders 
down you are within the application???

TIA
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]




Re: webroot level?

2004-07-22 Thread CF Developer
will that work for cfincludes?
such as:cfinclude template=/includes/thisfile.cfm

since this is a shared hosting, i do not have access to
establish cf mappings


- Original Message -
From: Jason L. West, Sr. [EMAIL PROTECTED]
Date: Thu, 22 Jul 2004 11:11:16 -0400
Subject: Re: webroot level?
To: CF-Talk [EMAIL PROTECTED]

 isn't there a way to specify something like:

 img src="">

Yes this does pull from the root of your url:

ex: http://www.site.com/images/image.gif
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]