Re: isdefined on a web service?

2006-04-07 Thread Anthony Prato
nope that didn't work either :(

Element FIRM is undefined in ARESPONSEARR.


The error occurred in C:\Inetpub\wwwroot\address_verify.cfm: line 37

36 :if (isdefined(aResponseArr.Firm)
37 :and len (aResponseArr.Firm))
38 :{aResponse.Firm = aResponseArr.Firm;}


its so wierd that isdefined is returning true in the first have of the
IF statement, but then its undefined when I try to do len()... Same
results if I remove the len(), the assignment errors because its
undefined.



On 4/6/06, Tony [EMAIL PROTECTED] wrote:
 try, and (isDefined() and len()) scenario
 since the existence of it doesnt necessarily
 mean the presence of it.

 make sense?

 i dont know how to do this in cfscript, but in cfmx code
 its quite easy.  let me know if the above works, if not
 i can show you how in cfmx code (but you may already know this)

 tony


 On 4/6/06, Anthony Prato [EMAIL PROTECTED] wrote:
  I'm working on using an address validation web service. It's giving me
  trouble because if it doesn't find something, it just doesn't return
  that field at all. I wrapped isdefined around everything but now I get
  this error...
  
 
  Element FIRM is undefined in ARESPONSEARR.
 
  The error occurred in C:\Inetpub\wwwroot\address_verify.cfm: line 36
 
  34 :if (isdefined(aResponseArr.LLCertainty))
  {aResponse.LLCertainty = aResponseArr.LLCertainty;}
  35 :if (isdefined(aResponseArr.CountyNum)) {aResponse.CountyNum =
  aResponseArr.CountyNum;}
  36 :if (isdefined(aResponseArr.Firm)) {aResponse.Firm = 
  aResponseArr.Firm;}
 
   ---
 
  Why am i getting a undefined error when using isdefined? isn't that
  the point of the function?
 
  I guess I'll have to use try/catch... whats the syntax for that in
  cfscript again?
 
 
  Anthony
 
 

 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237184
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: isdefined on a web service?

2006-04-07 Thread Anthony Prato
try {} catch (any e) {;} works fine, i'll just chalk this up as wierd
and move along.

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237185
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


isdefined on a web service?

2006-04-06 Thread Anthony Prato
I'm working on using an address validation web service. It's giving me
trouble because if it doesn't find something, it just doesn't return
that field at all. I wrapped isdefined around everything but now I get
this error...


Element FIRM is undefined in ARESPONSEARR.

The error occurred in C:\Inetpub\wwwroot\address_verify.cfm: line 36

34 :if (isdefined(aResponseArr.LLCertainty))
{aResponse.LLCertainty = aResponseArr.LLCertainty;}
35 :if (isdefined(aResponseArr.CountyNum)) {aResponse.CountyNum =
aResponseArr.CountyNum;}
36 :if (isdefined(aResponseArr.Firm)) {aResponse.Firm = 
aResponseArr.Firm;}

 ---

Why am i getting a undefined error when using isdefined? isn't that
the point of the function?

I guess I'll have to use try/catch... whats the syntax for that in
cfscript again?


Anthony

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237154
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: OT: mail to fax?

2006-04-06 Thread Anthony Prato
Working on automating faxes myself. I plan to generate and store pdf's
of invoices and use one of the following services: (cut and paste from
an internal email)


Fax Services

Innoport
http://www.innoport.com/services_features_business.asp
Outbound Web Service 8 cents/page. Corporate customers get a discount
based on total amount spent the previous month.
They also have a bulk service which supports mail merge although I
don't think the mail merge will support our invoices.
They support html and pdf but I can't find info about html support of CSS
Inbound they fax=email and fax=ftp.
There is a monthly fee that increases based on the number of inbound fax lines.

InterFAX
http://www.interfax.net/scripts/prices.asp?lang=en
Outbound Web Service. Tiered pricing with a number of included pages.
The per page overage cost varies (11c-7c) between the tiers. See the
link above for details.
Inbound fax=email and ??? waiting for a call back
Inbound has a monthly fee and 15 cents per page after receiving 200
pages in a month

Data on Call
http://www.dataoncall.com/internet-fax-service/ent-pricing.jsp?rcvtype=3
(enterprise inbound prices)
Outbound supports email, web post, and xml post and Inbound supports
email, ftp and xml post (xml post would be the most desirable if we go
with a service)
The url lists inbound prices
outbound is 9 cents/page 5000 pages/month and 7 cents/page 5000 pages/month



On 4/5/06, Andy Matthews [EMAIL PROTECTED] wrote:
 I've got a client with a loan application form on her site. She'd like the
 processing of the form to be sent to her as a fax. Not really sure why, but
 does anyone know of, or have, something like this?

 I think it can be done, but I've never used anything of this nature before.

 !//--
 andy matthews
 web developer
 ICGLink, Inc.
 [EMAIL PROTECTED]
 615.370.1530 x737
 --//-


 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237155
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Update on eolas/cfform/cfchart fixes

2006-03-30 Thread Anthony Prato
depends how you are displaying the resulting document from a cf
document tag; If you are using an object tag... yes.
If you follow the advice from the links in the Active Content
developer center then no.
If you provide a link to a cfm file which contains cfheader,
cfcontent, cfdocument.. no worries. The way I understand it is only
content directly imbeded in the html will need to be rewritten.

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236624
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Update on eolas/cfform/cfchart fixes

2006-03-29 Thread Anthony Prato
let me start by saying please don't post in this thread about
IE/ActiveX being good or bad. Yes most of us hate it, but this change
is coming in less than 2 weeks.

I've been to the Active Content Center.
http://www.macromedia.com/devnet/activecontent/

Unfortunately it does not provide any fixes for the flash
automatically generated by Coldfusion. Nor does it provide any info on
a forthcoming fix. Can someone from Adobe please respond to this! I'm
amazed I have to say this, but I think Dave is wrong. :p  From
everything i have read the change will be included in a security
update on April 11. This means people WILL install it. Most
organizations have become very diligent in installing these security
patches.

I downloaded the IE update to test myself and all the CF generated
flash loads inactive. I've already rewritten the code to display my
cfdocuments using the Microsoft workaround example. (document.write()
in included javascript) However, cfdocument is easy because it will
leave the actual flash/pdf binary in its place. When CF processes a
cfform tag it only leaves the html to load the flash in its place.
Because of this I do not know how to use and of the included
JavaScript workarounds for flash forms. Has anyone found a workaround?
Can someone from Adobe comment?

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236487
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Update on eolas/cfform/cfchart fixes

2006-03-29 Thread Anthony Prato
Agreed... especially since there is no date on this page, it may have
been posted months ago.

I'm glad I didn't expose flash forms to external users...

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236491
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: is this thing on?

2005-12-29 Thread Anthony Prato
cool, my other thread got answered, thanks for replying, it works! :)


On 12/28/05, Rick Faircloth [EMAIL PROTECTED] wrote:
 I got your message, but have no idea how
 to answer your questionsorry...

 Rick


  -Original Message-
  From: Anthony Prato [mailto:[EMAIL PROTECTED]
  Sent: Wednesday, December 28, 2005 7:51 PM
  To: CF-Talk
  Subject: is this thing on?
 
 
  I've posted a few questions in the past month, some were out there,
  but one was easy (i think) and I'm not sure if my mail is getting to
  the list. Can you see this?
 
  My question was, how do you tell the default jvm charset when using
  cffile action=write?
 



 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227877
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: cfxml/cffile character set?

2005-12-29 Thread Anthony Prato
Thanks that worked... I found another easy way too after reading here
how to change the default:
http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentationfile=1207.htm

Just go into the administrator and check out settings summary. There
is a JVM section that tells the default file encoding.

On 12/29/05, Paul Hastings [EMAIL PROTECTED] wrote:
 Anthony Prato wrote:
  I'm assuming character set doesn't matter internally when you use
  CFXML, but when converting it to string in generates the xml start for

 it matters coming  going.

  something to add the encoding= into the xml start sting?
  i.e. ?xml version=1.0 encoding=ISO-8859-1 ?

 i guess that depends on how you're creating the xml doc. you can easily
 slip into the text stream if you're building it from a string or
 converting it to a string prior to writing it out.

  The docs for cffile say charset is defaulted to: JVM default file character 
  set

 but you can  should control that as needed via the charset option.

  What is that? is there a way to programmaticly return that for a JVM?

 cfscript
 sys=createObject(java,java.lang.System);
 fileEncoding=sys.getProperty(file.encoding);
 writeoutput(file encoding: #fileEncoding#br);
 /cfscript

 cfdump var=#sys.Properties#

 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227938
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: SSL Noob

2005-12-28 Thread Anthony Prato
SSL requires a secure certificate to be setup on the web server. Are
you trying to set one up for development or a site/app? Which web
server are you using?

On 12/28/05, John Wilker [EMAIL PROTECTED] wrote:
 I've searched and read, but all the conversations start at a point I'm not
 at yet :)

 I've never had to implement SSL before, and now need to set up my dev
 machine for SSL.

 I'm running CF 7, Jrun

 Any one point me in the right direction?

 Thanks!

 J

 --
 John Wilker
 Writer/Web Consultant
 www.johnwilker.com / www.red-omega.com

 The measure of success is not whether you have a tough problem to deal
 with,
 but whether it's the same problem you had last year.
 ~John Foster Dulles, Former US Sec. of State.


 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227762
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


cfxml/cffile character set?

2005-12-28 Thread Anthony Prato
I'm assuming character set doesn't matter internally when you use
CFXML, but when converting it to string in generates the xml start for
you. I've read about the charset attribute on the cffile tag, I'm
guessing this will work, but for the xml do I have to use regex or
something to add the encoding= into the xml start sting?
i.e. ?xml version=1.0 encoding=ISO-8859-1 ?

The docs for cffile say charset is defaulted to: JVM default file character set

What is that? is there a way to programmaticly return that for a JVM?

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227792
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Running a DTS package with CF

2005-12-28 Thread Anthony Prato
try searching google for DTS and asp, I think I saw a solution that
way that may be applicable to CF too.

On 12/28/05, Mickael Elmalem [EMAIL PROTECTED] wrote:
  Hello All,

 I am hoping that someone help me with this one.  We have a server in our 
 local network that synchronizes to a remote website.  This is done by a DTS 
 package running on a machine in our network at scheduled intervals.  The 
 issue is for what ever reason the DTS package that is supposed to run 
 everyhour does not.  If I log on to the machine and run the package it works 
 then keeps on working.  My question is.  Is there a way to have a user click 
 on a CFM page to run a DTS package on the local machine?  The idea is that 
 the staff know right away that the sync is not working and if they could 
 invoke it, then escalate to IT that would help the service level.

 Thanks.

 Mike

 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227802
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


is this thing on?

2005-12-28 Thread Anthony Prato
I've posted a few questions in the past month, some were out there,
but one was easy (i think) and I'm not sure if my mail is getting to
the list. Can you see this?

My question was, how do you tell the default jvm charset when using
cffile action=write?

Thanks,
Anthony

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227820
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Flash Forms - Why Not?

2005-12-21 Thread Anthony Prato
speed is my number 1
i've also had a hard time when trying to be picky about positioning
a combo box would be nice
ability to rotate grid headers
ability to put tabs down the side
some sort of page stack (or just turn off the tabs on tab pages)

On 12/21/05, tbuntel @ macromedia. com tbuntel @ macromedia. com
[EMAIL PROTECTED] wrote:
 Hello -
 Beside faster loading and a WYSWYG designer of some sort, I'd be interested 
 in hearing any *specific* enhancement requests to Flash Forms.  We can best 
 improve the feature when we know exactly what you'd like to see.
 Thanks,
 Tim Buntel
 Sr. Product Manager, ColdFusion

 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227454
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Flash Forms - Why Not?

2005-12-21 Thread Anthony Prato
what is this preloader and how do you set it to false?
i'd love 5 more seconds

On 12/21/05, Felipe Fernandes [EMAIL PROTECTED] wrote:
 One thing I do that does make it loads i little faster (nothing that
 would make you say wow, now its fast) is to set the preloader to
 false, in my tests it got about 5 sec faster.

 Felipe

 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227455
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


[SOT] HTTP 400 error has me stumped

2005-12-20 Thread Anthony Prato
details are below my hail marry question... does anyone have any
experience with http 400 errors?

I'm completely lost on what to do to help one of our clients. They
frequently (not always) cause a 400 error to show up in the IIS
(win2k) logs when submitting a specific form. The form is in an iframe
and works for all users except them. Other forms seem to post fine,
but this is the main form so it may be coincendce. They don't see the
ifram do anything. It wasn't until I saw the 400 errors in the web
server log that I realized there was an error occuring. (even after
turning off friendly IE errors on the browser) I've found a few posts
talking about spyware and proxy servers. I talked to their IT
consultant and he assures me the firewall is very basic, no proxy and
that he's scanned for spyware. Some of the posts I found suggested
doing a packet trace, but that isn't possible because the site uses
SSL. And it isn't until windows 2003 that IIS can dump a few more
error details.

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227372
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Calling a CF webservice VB6

2005-12-14 Thread Anthony Prato
Can't help but I am interested in what you find. I want to have my VB
guys rewrite a few batch programs to post to web services rather than
the database directly. Got any good links?

On 12/14/05, Snake [EMAIL PROTECTED] wrote:
 Got a web service running CFMX7.
 It works fine when called via .NET using SOAP, but we need to call it via a
 VB6 application, which gives the following error. Anyone got any ideas?

 SoapMapper:The schema definition with a targetnamespace of
 http://schemas.xmlsoap.org/soap/encoding/ for SoapMapper string could not be
 found HRESULT=0x80004005: Unspecified error
  - SoapMapper:The SoapMapper for element string could not be created
 HRESULT=0x80004005: Unspecified error
  - WSDLOperation:Initialization of a SoapMapper for operation getMappings
 failed HRESULT=0x80004005: Unspecified error
  - WSDLOperation:Initializing of the input message failed for operation
 getMappings HRESULT=0x80004005: Unspecified error
  - WSDLPort:An operation for port cf7adminapinew.cfc could not be
 initialized HRESULT=0x80004005: Unspecified error
  - WSDLPort:Analyzing the binding information for port cf7adminapinew.cfc
 failed HRESULT=0x80004005: Unspecified error
  - WSDLService:Initialization of the port for service cf7Adminapi failed
 HRESULT=0x80004005: Unspecified error
  - WSDLReader:Analyzing the WSDL file failed HRESULT=0x80004005: Unspecified
 error
  - Client:One of the parameters supplied is invalid. HRESULT=0x80070057: The
 parameter is incorrect.


 --
 Russ



 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227018
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


No buffer space available (maximum connections reached?)

2005-12-13 Thread Anthony Prato
We recently had our application server crash around 11am pst. starting
around 10 I see many errors saying:
No buffer space available (maximum connections reached?)

I found a number of threads in the coldfusion forums on mac... adobe's
site but none have an answer. Some places in the logs it stated the
above was returned from the jdbc driver. If this was a database
problem, why would the server crash completely? Before we did a hard
reboot, we were able to see 100% cpu utilization but the process list
would not load so I'm not sure what was doing it. Does anyone have any
ideas?


both servers are win2k, app server is mx 7,0,1,116466   the database
server is sql2000 sp4

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226952
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


need advice on advanced datasource setttings

2005-12-13 Thread Anthony Prato
I've been having a problem with an error:
No buffer space available (maximum connections reached?)

Which has me wondering if the connections are being kept open too long
with the default settings. Rather than turn off Maintain Connections
all together I wanted to try lowering the timeout. Any suggestions on
values here? (we use sql server) Does anyone have a better explanation
of the Interval parameter?

Timeout (min)
The number of minutes that ColdFusion MX maintains an unused
connection before destroying it.

Interval (min)
The time (in minutes) that the server waits between cycles to check
for expired data source connections to close.

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226964
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CFEclipse

2005-12-06 Thread Anthony Prato
been said by others, but the multi line find/replace from HS is the
best. Its saved me manual labor more times than I can count.
The results are much better too.

On 12/6/05, Simon Horwith [EMAIL PROTECTED] wrote:
 what's wrong with the extended find and replace in Eclipse?  It's not
 called that, but you can do the same thing.

 ~Simon

 Ben Nadel wrote:

 I think the only reason that would stop me from totally leaving homesite is
 that Homesite's extended find/replace has not been paralleled in any other
 application that I have seen.
 
 ...
 Ben Nadel
 Web Developer
 Nylon Technology
 6 West 14th Street
 New York, NY 10011
 212.691.1134
 212.691.3477 fax
 www.nylontechnology.com
 
 Vote for Pedro
 
 
 

 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226331
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CFEclipse

2005-12-06 Thread Anthony Prato
Do you have any links or postings that give some tips on searching? Do
you use searchsearch... or editfind/replace...?
I am very very new to eclipse and I can't seem to get it do anything I
like. Can you show the context of the results? Can you get the search
results window to come up for just the current file or all open files?

To add a comment about multi-line search  replace, I know you can use
the regex to handle the tabs, newlines etc but the main benefit to me
about the multiline is being able to cut and paste. I think my most
common task is using it to reformat a file.

On 12/6/05, Nathan Strutz [EMAIL PROTECTED] wrote:
 On 12/6/05, Anthony Prato [EMAIL PROTECTED] wrote:
  been said by others, but the multi line find/replace from HS is the
  best. Its saved me manual labor more times than I can count.
  The results are much better too.

 My opinion is that the multi-line facet of HS's search  replace is
 the only thing it has going for it, against Eclipse, plus you can fake
 it in Eclipse with a regular expression like \s (any whitespace
 character), \n (newline), \r (carriage return) and \t (tab). Eclipse's
 regular expression searching is a LOT more powerful and precise than
 HS's. Eclipse can display results in a flat layout like HS or in a
 folder tree. Eclipse will save previous searches in the current
 session (and my sessions tend to last for days, so i can see what i
 searched for on monday). Also, you can define a working set, or a
 group of folders and projects, possibly spanning multiple projects,
 and search just them. All in all, I think the searching in HS is nice,
 maybe easier, but Eclipse is better.

 Maybe we should call Mike Dinowitz's emergency-only cell and ask him
 what he thinks.

 -nathan strutz
 http://www.dopefly.com/

 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226340
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Bar Code Scanners ColdFusion

2005-12-01 Thread Anthony Prato
Most bar code scanners are HID devices and act like a keyboard. They
scan the bar code and output it's contents. Ours allows for different
options and we have it configured to output a tab after scanning so a
javascript event can be triggered.

Anthony

On 12/1/05, jonese [EMAIL PROTECTED] wrote:
 Anyone have experiance with tying in a bar code scanner and an online
 inventory app in CF? Basicaly i have a prospect who is looking to use
 the speed of a bar code reader to fill orders for there online shop.

 don't really know where to begin so any help would be awesome.

 jonese

 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225841
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


unbelievable flash form problem

2005-11-22 Thread Anthony Prato
I'm not even sure what to say about this, or how anyone else can
replicate it. I've got a flash form with a bunch of different
elements. It has two buttons. I was styling one button, got it looking
how I wanted and copied the style to the other button.
reload the browser: Nothing
wtf?
tried again, same result
wtf?
copied and renamed the good button to below the problem button,
changed the onclick to be the same. Now I have two buttons where I
wanted one, but at least the second looks right.
thats good
tried to comment out the problem button, reload the browser: nothing
wtf?
uncomment it, form loads 2 buttons
try deleting it, reload the browser: nothing
wtf!
restart coldfusion... same problem
rename the file... same problem
wtf!

anyone got any ideas?

it hasn't been a good morning

Anthony

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224974
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: unbelievable flash form problem

2005-11-22 Thread Anthony Prato
Ok, debugging is on now, it gets more wierd... here are the buttons:
-
cfinput type=button name=filterIt value=Apply Filter
onclick=getHistoryData();
cfinput type=button name=thissucks value=Apply Filter
onclick=getHistoryData(); style=cornerRadius: 0; borderThickness:
0; color: ##44;
--
the bottom is the one styled how I like. I've given up on commenting
out, I am just trying to delete the first button (remember it works
fine with both) I get the flash debugging message:
---
1 Error found.

Error
Branch between 6380 and 39329 around line 0 exceeds 32K span. If
possible, please refactor this component.

not sure what i'm supposed to do with that now :) I just don't see how
deleteing something could increase the size of the form. CRTL+Z and
the form loads again.

UPDATE! it gets better! I am now able to copy the style to the first
button, but now when I delete either I get the message above.

-soon to be bald

On 11/22/05, Paul Hastings [EMAIL PROTECTED] wrote:
 Anthony Prato wrote:
  anyone got any ideas?

 turn on flash debugging.

 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224987
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: unbelievable flash form problem

2005-11-22 Thread Anthony Prato
I'd also like to add that the entire file, html and all is only 15k. I
deleted both buttons listed before and replaced them with  an unstyled
button. Then I copied/renamed the unstyled button 20 times. The move
loads fine with all 20 buttons but breaks again if I try to add a
style to any of them.
below the bottons I put a formgroup=panel with a ton of styles and the
form still loads fine. It's only styling the buttons when I have a
problem.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224992
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


SOLVED Re: unbelievable flash form problem

2005-11-22 Thread Anthony Prato
well sort of solved, more like hacked

found this post saying something about flex making wierd compile
decisions and one solution is to add a bunch of junk code
http://groups.google.com/group/macromedia.flex.general_discussion/browse_thread/thread/a12575ea5ea1c758/506b79e825fe4116?lnk=stq=around+line+0+exceeds+32K+spanrnum=2hl=en#506b79e825fe4116

so that is what I did and it works fine, i now have 1 styled button
followed by a bunch of junk code



On 11/22/05, Anthony Prato [EMAIL PROTECTED] wrote:
 I'd also like to add that the entire file, html and all is only 15k. I
 deleted both buttons listed before and replaced them with  an unstyled
 button. Then I copied/renamed the unstyled button 20 times. The move
 loads fine with all 20 buttons but breaks again if I try to add a
 style to any of them.
 below the bottons I put a formgroup=panel with a ton of styles and the
 form still loads fine. It's only styling the buttons when I have a
 problem.


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224996
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: unbelievable flash form problem

2005-11-22 Thread Anthony Prato
actually the function is pretty short
function getHistoryData() {
!--- get all the search criteria items ---
var filterArguments = {};
!--- grids ---
filterArguments.clinicid = 
clinicList.selectedItem.clinicid
filterArguments.drugid = drugList.selectedItem.drugid
!--- dates ---
filterArguments.startDate = startDate.text;
filterArguments.endDate = endDate.text;
!--- radio button ---
filterArguments.tranTypes = tranTypes.selectedData;
!--- show clock cursor ---
mx.managers.CursorManager.setBusyCursor();
!--- call service ---

drug_history.myGlobalObjects.drug_history.getDrugHistory(filterArguments);
!--- change the current pane ---
explorer.selectedIndex=2;
}


Those who have the problem, my workaround was to add bogus code after
the button. I did not change the function, the line of code with the
button or the style.

On 11/22/05, Felipe Fernandes [EMAIL PROTECTED] wrote:
 I had some problem like yours a time ago, what i learned is the the
 32K (or 64K sometimes) refer to i single line of mxma script.
 So lets understend what´s going under the hood here:
 When you do a flash form, coldfusion gets your code, process it and
 passes to it´s internal flex compiler (yes coldfusion has a flex
 compiler inside) and that´s where it can´t have a component with more
 than 32K.
 Looks like your getHistoryData() function is almost at that limit so
 when you set any style it get´s over (to change the style flex has to
 call the style method).
 One solution, is to clean (if possible) your getHistoryData() function
 or break it in two diferent functions. Paste it here so we can help
 you. Or take your button out of any cfformgroup tag type horizontal or
 vertical.

 Felipe

 On 11/22/05, Anthony Prato [EMAIL PROTECTED] wrote:
  I'd also like to add that the entire file, html and all is only 15k. I
  deleted both buttons listed before and replaced them with  an unstyled
  button. Then I copied/renamed the unstyled button 20 times. The move
  loads fine with all 20 buttons but breaks again if I try to add a
  style to any of them.
  below the bottons I put a formgroup=panel with a ton of styles and the
  form still loads fine. It's only styling the buttons when I have a
  problem.
 
 

 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225011
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: unbelievable flash form problem

2005-11-22 Thread Anthony Prato
wow nice! very cool trick
thanks felipe

On 11/22/05, Felipe Fernandes [EMAIL PROTECTED] wrote:
 If you got a workaround, it´s ok, but if you want to find th problem
 you can try do dump the form with pre cfdump var=#myform#/pre
 (or whatever is your form name) and look to the code pointed by the
 error message and find what is getting so big.

 Felipe

 On 11/22/05, Anthony Prato [EMAIL PROTECTED] wrote:
  actually the function is pretty short
  function getHistoryData() {
  !--- get all the search criteria items ---
  var filterArguments = {};
  !--- grids ---
  filterArguments.clinicid = 
  clinicList.selectedItem.clinicid
  filterArguments.drugid = 
  drugList.selectedItem.drugid
  !--- dates ---
  filterArguments.startDate = startDate.text;
  filterArguments.endDate = endDate.text;
  !--- radio button ---
  filterArguments.tranTypes = tranTypes.selectedData;
  !--- show clock cursor ---
  mx.managers.CursorManager.setBusyCursor();
  !--- call service ---
  
  drug_history.myGlobalObjects.drug_history.getDrugHistory(filterArguments);
  !--- change the current pane ---
  explorer.selectedIndex=2;
  }
  
 
  Those who have the problem, my workaround was to add bogus code after
  the button. I did not change the function, the line of code with the
  button or the style.
 
  On 11/22/05, Felipe Fernandes [EMAIL PROTECTED] wrote:
   I had some problem like yours a time ago, what i learned is the the
   32K (or 64K sometimes) refer to i single line of mxma script.
   So lets understend what´s going under the hood here:
   When you do a flash form, coldfusion gets your code, process it and
   passes to it´s internal flex compiler (yes coldfusion has a flex
   compiler inside) and that´s where it can´t have a component with more
   than 32K.
   Looks like your getHistoryData() function is almost at that limit so
   when you set any style it get´s over (to change the style flex has to
   call the style method).
   One solution, is to clean (if possible) your getHistoryData() function
   or break it in two diferent functions. Paste it here so we can help
   you. Or take your button out of any cfformgroup tag type horizontal or
   vertical.
  
   Felipe
  
   On 11/22/05, Anthony Prato [EMAIL PROTECTED] wrote:
I'd also like to add that the entire file, html and all is only 15k. I
deleted both buttons listed before and replaced them with  an unstyled
button. Then I copied/renamed the unstyled button 20 times. The move
loads fine with all 20 buttons but breaks again if I try to add a
style to any of them.
below the bottons I put a formgroup=panel with a ton of styles and the
form still loads fine. It's only styling the buttons when I have a
problem.
   
   
  
  
 
 

 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225021
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: unbelievable flash form problem

2005-11-22 Thread Anthony Prato
Let me now take back what I said about fixing the problem. It turns
out I was using the debug=true url paramter like the post I mentioned
suggested. When I remove this url parameter the form breaks and gives
the same message. I used Felipe's trick to dump out both forms. I then
did a diff and the only difference is the line:
formScope.send(/occmeds/intranet/drug_history_A.cfm, _self, POST);
formScope.send(/occmeds/intranet/drug_history_A.cfm?debug=true,
_self, POST);

The files are the same size otherwise, the one with debug works. Any ideas?

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225023
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


OT: moving to cfeclipse... troubles

2005-11-18 Thread Anthony Prato
I've been making my move to cfeclipse from homesite and I'm happy so
far. There are two major things I always use that I can't find in
eclipse.
The first it the CTRL+ and CTRL+ shortcuts to make  and /
respectively. I'm guessing I could setup a snippet for this...

The major thing I noticed was now extended find/replace. It is the
main reason I use homesite and really hope you can do something very
similar in eclipse. Any suggestions?

Anthony

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224663
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: cfdocument and footer troubles

2005-11-15 Thread Anthony Prato
Great Idea Ben! It worked!

On 11/15/05, Ben Nadel [EMAIL PROTECTED] wrote:
 Anthony Try something like this:

 cfdocumentitem type=footer

style type=text/css

div.footer {}

div.footer p.seenextpage {
display: none ;
}

div.footer div.instance1 p.seenextpage {
display: block ;
}

/style

div align=center class=footer
div class=instance#CFDOCUMENT.CurrentPageNumber#

p class=seenextpage
See Next Page
/p

/div
/div

 /cfdocumentitem

 What this does is default the paragraph class SeeNextPage to NOT display,
 however, when the inbetween div is instance1 (as it is created via the
 CurrentPageNumber), it will show on the first page.

 For this to work, the style tags MUST be in the Footer item.

 I haven't tested this specifically, but I have gotten things like this to
 work.

 -Ben
 ...
 Ben Nadel
 Web Developer
 Nylon Technology
 6 West 14th Street
 New York, NY 10011
 212.691.1134
 212.691.3477 fax
 www.nylontechnology.com

 Always confident, seldom correct.


 -Original Message-
 From: Anthony Prato [mailto:[EMAIL PROTECTED]
 Sent: Monday, November 14, 2005 3:47 PM
 To: CF-Talk
 Subject: cfdocument and footer troubles

 I'm working on a document that sometimes requires two pages. This is
 based on the number of items returned by a query. When two pages are
 needed I would like both pages to have page x of 2 on the right
 footer and something like See next page on the center of the footer
 on the first page only. The page number part is easy, event though i
 need to use a cfoutput (livedocs example doesn't use cfoutput)
 The problem I'm having is trying to use:
 cfif cfdocument.currentpagenumber EQ 1see next page/cfif
 I don't get the text on either page. I tried putting pound signs
 around it, and quotes. I also tried using the query.recordcount but
 then the page doesn't load at all. I also tried moving the doc item
 footer tag around with no luck. I also tried moving it to after my
 pagebreak which livedocs says:
 If the tag is in the middle of the document, it applies to the rest of
 the document
 But even though its after my page break it still shows on the first page.

 Anyone gotten any something like this to work?


 Anthony



 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224209
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


cfdocument and footer troubles

2005-11-14 Thread Anthony Prato
I'm working on a document that sometimes requires two pages. This is
based on the number of items returned by a query. When two pages are
needed I would like both pages to have page x of 2 on the right
footer and something like See next page on the center of the footer
on the first page only. The page number part is easy, event though i
need to use a cfoutput (livedocs example doesn't use cfoutput)
The problem I'm having is trying to use:
cfif cfdocument.currentpagenumber EQ 1see next page/cfif
I don't get the text on either page. I tried putting pound signs
around it, and quotes. I also tried using the query.recordcount but
then the page doesn't load at all. I also tried moving the doc item
footer tag around with no luck. I also tried moving it to after my
pagebreak which livedocs says:
If the tag is in the middle of the document, it applies to the rest of
the document
But even though its after my page break it still shows on the first page.

Anyone gotten any something like this to work?


Anthony

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224136
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: formatting a date in cfgrid

2005-11-09 Thread Anthony Prato
Just figured this problem out last night. I lost your original email,
but from your screen shot it looks the same. It's not in the docs but
put a type=date on the cfgridcolumn

On 11/4/05, Alexander Hinkley [EMAIL PROTECTED] wrote:
 i did the update this morning.. i still get the same results..

 http://single-dads.us/grid.jpg

 the petid field shows the format of the date as it comes from the
 db... via remoting..

 On 10/28/05, Mike Nimer [EMAIL PROTECTED] wrote:
  Upgrade to 7.0.1, we fixed some bugs in cfgrid in the updater. I think
  this was fixed as well.
  ---nimer
 
 
 

 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223691
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


code-128 Barcode and cfdocument

2005-11-08 Thread Anthony Prato
Anyone have any success creating code 128 barcodes within cfdocument?
What did you use? I found some fonts online, but they aren't working.
The specs talk about encoding; Anyone have a function to do the
encoding?

Anthony

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223607
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: code-128 Barcode and cfdocument

2005-11-08 Thread Anthony Prato
Good news, I was able to get this working with a free barcode font I found at:
http://freebarcodefonts.dobsonsw.com/

the check code is a pain to calculate, but other than that it worked fine.

The other little trick is that the startcode is asc(353) and the
endcode is asc(339)


On 11/8/05, Alan Rother [EMAIL PROTECTED] wrote:
 Just in my experience, I would generate a static jpg file for the barcode
 and then embed it into the cfdocument.
  You can use many of the image creation tools like image flare or in java
 the alagad image component to make the static jpg file.

 --
 Alan Rother
 Macromedia Certified Advanced ColdFusion MX 7 Developer


 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223627
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


binding in flash forms... I could swear I saw this here already but...

2005-11-03 Thread Anthony Prato
none of my searches are returning what I want.

I have no problem binding inputs to a selected datagrid column; labels
are also easy to bind too. My problem now is binding inside formatted
text. I've got a grid with a bunch of different items in it. When an
item is selected I want a panel to the right to show the name, size,
description and item number. I want this text to be centered with the
first line being larger than the rest with the name (bold) and size.
On the next line I want item number; next description. I can't get
this to work at all. The only thing I have working is the bold tag and
the line breaks. If I use the {} notation it just prints that out. Is
there some way to create a preview/detail panel like this? If not
binding is there some equivalent to innerHTML? What about the
formatting? The cfdocs say to see the flash docs... still looking
through that now.

Anthony

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223140
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: How would I send an XML file to another server/application?

2005-10-27 Thread Anthony Prato
I had a client who could not figure out how to send and xml post like
Andy's example. On my recieving page I put this code to allow them to
post as a named form field or an xml post.

cftry
cfset RequestXML = FORM.xmlbody
cfcatch
cfset RequestXML = GetHTTPRequestData().content
/cfcatch
/cftry

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222453
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


still having server admin problems - semaphore

2005-10-24 Thread Anthony Prato
Hi all,
I'm still having problems with my server locking up. I'm still waiting
to hear from some people about this but I thought I'd ask here too.
When doing a thread dump it seams like I have a lot of threads from a
page that uses cfdocument saying the following:

at java.lang.Object.wait(Native Method)
- waiting on 0x15594c58 (a coldfusion.util.Semaphore)
at java.lang.Object.wait(Unknown Source)
at coldfusion.util.Semaphore.acquire(Semaphore.java:31)
- locked 0x15594c58 (a coldfusion.util.Semaphore)
at coldfusion.tagext.lang.DocumentTag.doStartTag(DocumentTag.java:1091)


Anyone have any experience with this?

Anthony

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222135
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: more coldfusion 7.01 problems, Macromedia folks please read! I just want to cry

2005-10-21 Thread Anthony Prato
Thanks mark, I'll check those posts out. I guess I was thinking MaxPermSize=128m
ment that was the minimum.

Thanks to everyone here for all the help, macromedia's help has been
great too.  I'll keep working at it with all the new system admin
advice I've been getting.

Anthony

On 10/21/05, Mark A Kruger [EMAIL PROTECTED] wrote:
 Anthony,

 I don't see 150 minimum anywhere here.  I should see a line that looks like

 -Xms512m -Xmx640m

 Xms meaning minim and Xmx meaning maximum.  When you don't set a minimum
 size you are telling the JVM to scale back it's memory - always looking for
 the least amount it needs. This can cause it to work a lot harder and
 combined with the use of CFdocument (which we have found uses a lot of
 resources) you may be locking it up.  There's a really good blog here:

 http://www.sargeway.com/blog/index.cfm?mode=entryentry=27

 And another can't live without blog by robi Sen here:

 http://www.robisen.com/index.cfm?mode=entryentry=39E0B0C6-55DC-F2B1-FBBDB70
 CEC963D6D


 Using these blogs I now use an args that are something like this:

 java.args=-server  -DJINTEGRA_NATIVE_MODE -DJINTEGRA_PREFETCH_ENUMS -Xms512m
  -Xmx640m -Dsun.io.useCanonCaches=false -XX:MaxPermSize=128m -XX:PermSize=64
 m -XX:+UseConcMarkSweepGC -XX:NewSize=48m -Dcoldfusion.rootDir={application.
 home}/../ -Dcoldfusion.libPath={application.home}/../lib -Dcoldfusion.classP
 ath={application.home}
 ...

 Notice some extra switches and the alternate Garbage Collector.

 One more thing. I've taken to editing this file manually. CF Admin doesn't
 seems to screw it up when you do anything extra.

 I'm not saying this is your problem, but getting that JVM tuned well saves
 a lot of headaches.

 -Mark

 Mark A. Kruger, CFG, MCSE
 www.cfwebtools.com
 www.necfug.com
 http://mkruger.cfwebtools.com



 -

   150 is the min setting... It's usually
 more around 400. Thats what
 makes me think jrun was either idle or deadlocked. But since I can't
 get perfmon to work, i couldn't see how many requests it had going.
 here's my jvm args

 java.args=-server -Xmx512m -Dsun.io.useCanonCaches=false
 -XX:MaxPermSize=128m -XX:+UseParallelGC -DJINTEGRA_NATIVE_MODE
 -DJINTEGRA_PREFETCH_ENUMS -Dcoldfusion.rootDir={application.home}/../
 -Dcoldfusion.classPath={application.home}/../lib/updates,{application.home}/
 .../lib,{application.home}/../gateway/lib/,{application.home}/../wwwroot/WEB-
 INF/cfform/jars
 -Dcoldfusion.libPath={application.home}/../lib



 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221827
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Fastrack Methods (I'm a horrible teacher)

2005-10-21 Thread Anthony Prato
hijack
well sort of...

I actually have people who have been programming web apps, but now
that I'm getting them to switch to CF I'm starting to see they don't
quite understand what they're doing. I'm guessing before they were
just copying code and skating by. There are big holes in their logic. 
Anyone have any suggestions for sites to help with that? Thumping my
algorithm book or my old discreet math textbook would be way to
intimidating.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221831
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: SOT: data structure for unlimited nested items

2005-10-21 Thread Anthony Prato
If you use oracle the whole id,parentid setup can work ok. If it gets
slow you can just generate an xml file for the site to use for
menus/sitemap each time an update is done in the admin panel, or if
it's really slow, leave it to a manual button push. Personally what
I've used in the past is a method of storing a nested structure in a
relational database called Nested Sets. Its very cool once you get the
hang of it. Don't have my links with me but try googling it. Pretty
sure it's been brought up here before too. There used to be a great
overview slideshow out there but i can't find it at the moment

Anthony

On 10/21/05, Bobby Hartsfield [EMAIL PROTECTED] wrote:
 I've been racking my brain trying to come up with a feasible solution to a
 dynamic site map for a current project. Normally it would be a no-brainer
 but this time, the site is HUGE and has nested section after section after
 section...

 Once the client receives the final application, they will be adding even
 more sections (and undoubtedly subsections).

 I'd like to come up with a way to build the site map dynamically so I (and
 eventually they) can just add any new section's title and URL to the
 database.

 Without knowing exactly how deep the nests will go, it's proving to be
 tough.

 I'm curious to know if anyone else has done something similar with a site
 map or a menu or something that dynamically gave the ability to add
 unlimited nested items and if so what your database structure looked like.

 Thanks for any ideas.

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

 --
 No virus found in this outgoing message.
 Checked by AVG Anti-Virus.
 Version: 7.0.344 / Virus Database: 267.12.4/143 - Release Date: 10/19/2005




 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221871
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: SOT: data structure for unlimited nested items

2005-10-21 Thread Anthony Prato
http://www.calacademy.org/research/informatics/taf/proceedings/ballew/sld035.htm

this is what i was thinking of. starting somewhere around the
beginning walks you through how to build a nested set. The  slide
referenced above shows you how to generate a breadcrumb list for a
given page.

On 10/21/05, Anthony Prato [EMAIL PROTECTED] wrote:
 If you use oracle the whole id,parentid setup can work ok. If it gets
 slow you can just generate an xml file for the site to use for
 menus/sitemap each time an update is done in the admin panel, or if
 it's really slow, leave it to a manual button push. Personally what
 I've used in the past is a method of storing a nested structure in a
 relational database called Nested Sets. Its very cool once you get the
 hang of it. Don't have my links with me but try googling it. Pretty
 sure it's been brought up here before too. There used to be a great
 overview slideshow out there but i can't find it at the moment

 Anthony

 On 10/21/05, Bobby Hartsfield [EMAIL PROTECTED] wrote:
  I've been racking my brain trying to come up with a feasible solution to a
  dynamic site map for a current project. Normally it would be a no-brainer
  but this time, the site is HUGE and has nested section after section after
  section...
 
  Once the client receives the final application, they will be adding even
  more sections (and undoubtedly subsections).
 
  I'd like to come up with a way to build the site map dynamically so I (and
  eventually they) can just add any new section's title and URL to the
  database.
 
  Without knowing exactly how deep the nests will go, it's proving to be
  tough.
 
  I'm curious to know if anyone else has done something similar with a site
  map or a menu or something that dynamically gave the ability to add
  unlimited nested items and if so what your database structure looked like.
 
  Thanks for any ideas.
 
  ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.
  Bobby Hartsfield
  http://acoderslife.com
 
  --
  No virus found in this outgoing message.
  Checked by AVG Anti-Virus.
  Version: 7.0.344 / Virus Database: 267.12.4/143 - Release Date: 10/19/2005
 
 
 
 
  

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221873
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: SOT: data structure for unlimited nested items

2005-10-21 Thread Anthony Prato
As far as I know, using mysql and the parentid setup you'll have to
make a recursive function to go an unlimited number of levels.

the nested sets are tricky at first, but worth checking out. You can
get queries of subtrees and geneology in one sql statement each.



On 10/21/05, Bobby Hartsfield [EMAIL PROTECTED] wrote:
 Thanks for the response.

 I guess I should have mentioned that it's MySQL.

 I'm thinking that I could do something like...

 itemID
 ItemTitle
 ItemURL
 ItemParentID

 And parent ID would just point to another record in the same table if the
 item was indeed a sub item of another item. That items 'parent' could then
 also point to another item as its parent, etc...

 And maybe just a 0 for parentID when the item is 'top level'.

 I've used this before but I've always known exactly how deep the nests would
 go which in turn let me know exactly how many nested loops I would need to
 build everything

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

 -Original Message-
 From: Anthony Prato [mailto:[EMAIL PROTECTED]
 Sent: Friday, October 21, 2005 5:19 PM
 To: CF-Talk
 Subject: Re: SOT: data structure for unlimited nested items

 If you use oracle the whole id,parentid setup can work ok. If it gets
 slow you can just generate an xml file for the site to use for
 menus/sitemap each time an update is done in the admin panel, or if
 it's really slow, leave it to a manual button push. Personally what
 I've used in the past is a method of storing a nested structure in a
 relational database called Nested Sets. Its very cool once you get the
 hang of it. Don't have my links with me but try googling it. Pretty
 sure it's been brought up here before too. There used to be a great
 overview slideshow out there but i can't find it at the moment

 Anthony

 On 10/21/05, Bobby Hartsfield [EMAIL PROTECTED] wrote:
  I've been racking my brain trying to come up with a feasible solution to a
  dynamic site map for a current project. Normally it would be a no-brainer
  but this time, the site is HUGE and has nested section after section after
  section...
 
  Once the client receives the final application, they will be adding even
  more sections (and undoubtedly subsections).
 
  I'd like to come up with a way to build the site map dynamically so I (and
  eventually they) can just add any new section's title and URL to the
  database.
 
  Without knowing exactly how deep the nests will go, it's proving to be
  tough.
 
  I'm curious to know if anyone else has done something similar with a site
  map or a menu or something that dynamically gave the ability to add
  unlimited nested items and if so what your database structure looked like.
 
  Thanks for any ideas.
 
  ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.
  Bobby Hartsfield
  http://acoderslife.com
 
  --
  No virus found in this outgoing message.
  Checked by AVG Anti-Virus.
  Version: 7.0.344 / Virus Database: 267.12.4/143 - Release Date: 10/19/2005
 
 
 
 
 



 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221875
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


more coldfusion 7.01 problems, Macromedia folks please read! I just want to cry

2005-10-20 Thread Anthony Prato
Its not a good morning when you come in and your production CF server
is not taking requests again. Its even worse when you can't post
to the macromedia CF forums because you get a 404 error on submit. :( 
GRR well its pretty close to what I posted here yesterday, but
I'll give it another go since I don't know what else to do.

Here's what i tried to post to the forum:

Mostly a classic ASP environment, IIS W2K. I convinced them to buy
CFMX7. (standard) It's been in production for a few months now.
Tuesday Night I upgraded to 7.01. The next day the server stopped
taking requests around noon. The jrun process was idle, taking only
150mb of memory. (it averages much higher than that when in use) A
suggestion was given to check the install log and I noticed there was
a problem upgrading the jrun connnector. That made sense since it
didn't seam like Jrun was doing anything. I found a post on the forum
here about what version the dll should be after the patch. Mine didn't
match and I followed the directions provided to upgrade the connector.
Bounced both CF and IIS and everything worked fine again.

But now, this morning I came in to find the same problem, jrun idle,
only CF not responding to the requests... I bounced the cf server and
everything started working again, jrun started taking its normal
amount of memory. Before restarting (and after) I noticed another
problem. I can't load the CF information into performance monitor. The
event viewer says:
[Q]The data buffer created for the ColdFusion MX 7 Application
Server service in the C:\WINNT\system32\cfperfmon_mx.dll library is
not aligned on an 8-byte boundary. This may cause problems for
applications that are  trying to read the performance data buffer.
Contact the manufacturer of this  library or service to have this
problem corrected or to get a newer version  of this library. [/Q]

So here are my questions:
How can I see whats going on with the server?
Where can I look for the errors as to why this is happening???
How can I test the CF server without going through the jrun connector?
How can I test the jrun connector itself?

Some additional notes...
We are using CFDOCUMENT to generate PDF's quite frequently.
We've been making use of the new Flex features in 7.01 lately.
We've been using flash remoting lately.
colfusion-err.log has a lot of [Q] Request timed out waiting for an
available thread to run.[/Q] messages, but they don't have a date on
them so I am not sure if they are from when the server hung. But like
I said, the jrun process was using no CPU and hardly any memory, so I
don't see how it could be the same problem, but I can't tell because
perfmon won't work. I set the timeout requests after X in the
cfadministrator. I set it to 90.


Thanks for any help

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221684
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: more coldfusion 7.01 problems, Macromedia folks please read! I just want to cry

2005-10-20 Thread Anthony Prato
 1.  Start new CF log files so that you know which error messages are
 really current.
Does this require a restart or can i just rename the existing files?
(the ones in cfadmin are easy, but what about the jrun files?)

 2.  Have you checked your IIS logs?  Is anything unusual happening
 at the time the server crashes?
Just checked, nothing unusual

 Where is your traffic coming from?  Is
 it primarily from one location?  What pages are they hitting?  This
 should tell you whether it is a particular script / function that might
 be causing your problem.
It's intranet only at the moment. There are less than 8 users total.
(my thread count is 8 too)

I did inquire with the person who first noticed the problem. She said
before recently (the update) she was able to generate a few faxes at a
time. (pdf's created with cfdocument) but now she can only do one at a
time.  I'm starting to wonder if the PDF generation is causing the
problem but I don't have the slightest idea how to debug that. I'll
check the release notes to see if any upgrades were made with the
patch.

 3.  Has the server received any attention aside from CF?  I had a
 Windows 2003 AS go down a few days ago because of one of the MS patches
 --sometimes these outside things can seem to be CF, but aren't.
Nope, there haven't been any recent changes besides the 7.01 patch.
Also, the server didn't go down, CF stopped taking requests. IIS and
asp pages calling the same database continued to work properly.

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221699
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: more coldfusion 7.01 problems, Macromedia folks please read! I just want to cry

2005-10-20 Thread Anthony Prato
150 is the min setting... It's usually more around 400. Thats what
makes me think jrun was either idle or deadlocked. But since I can't
get perfmon to work, i couldn't see how many requests it had going.
here's my jvm args

java.args=-server -Xmx512m -Dsun.io.useCanonCaches=false
-XX:MaxPermSize=128m -XX:+UseParallelGC -DJINTEGRA_NATIVE_MODE
-DJINTEGRA_PREFETCH_ENUMS -Dcoldfusion.rootDir={application.home}/../
-Dcoldfusion.classPath={application.home}/../lib/updates,{application.home}/../lib,{application.home}/../gateway/lib/,{application.home}/../wwwroot/WEB-INF/cfform/jars
-Dcoldfusion.libPath={application.home}/../lib



On 10/20/05, Mark A Kruger [EMAIL PROTECTED] wrote:
 Jillian,

 What are your JVM settings. JRUN is only taking 150 megs of Memory - seems
 pretty lean to me. Can you post the contents of your
 cfusionmx7/runtime/bin/jvm.config file? It might be helpful.

 -Mark

 -Original Message-
 From: Jillian Koskie [mailto:[EMAIL PROTECTED]
 Sent: Thursday, October 20, 2005 11:52 AM
 To: CF-Talk
 Subject: RE: more coldfusion 7.01 problems, Macromedia folks please
 read! I just want to cry


 Anthony,

 I wish I could tell you how to fix your problem, but I thought I might
 share some thoughts on where I would start were it me.

 1.  Start new CF log files so that you know which error messages are
 really current.

 2.  Have you checked your IIS logs?  Is anything unusual happening
 at the time the server crashes?  I've seen instances where CF has
 crashed because my server was taking a LOT of traffic from a DOS attack
 that had nothing to do with CF.  Where is your traffic coming from?  Is
 it primarily from one location?  What pages are they hitting?  This
 should tell you whether it is a particular script / function that might
 be causing your problem.

 3.  Has the server received any attention aside from CF?  I had a
 Windows 2003 AS go down a few days ago because of one of the MS patches
 --sometimes these outside things can seem to be CF, but aren't.

 Barring that, I would look at turning all of the sites off in IIS --and
 run the server with no traffic--.  Once you determine whether the server
 can run without any traffic and stay stable, turn the sites back on one
 by one and see if any of them bring the server down.  If it is only one
 site, bring aspects of the site back piece at a time.

 I hope that helps.

 --
 Jillian

 -Original Message-
 From: Anthony Prato [mailto:[EMAIL PROTECTED]
 Sent: Thursday, October 20, 2005 10:30 AM
 To: CF-Talk
 Subject: more coldfusion 7.01 problems, Macromedia folks please read! I
 just want to cry

 Its not a good morning when you come in and your production CF server
 is not taking requests again. Its even worse when you can't post
 to the macromedia CF forums because you get a 404 error on submit. :(
 GRR well its pretty close to what I posted here yesterday, but
 I'll give it another go since I don't know what else to do.

 Here's what i tried to post to the forum:

 Mostly a classic ASP environment, IIS W2K. I convinced them to buy
 CFMX7. (standard) It's been in production for a few months now.
 Tuesday Night I upgraded to 7.01. The next day the server stopped
 taking requests around noon. The jrun process was idle, taking only
 150mb of memory. (it averages much higher than that when in use) A
 suggestion was given to check the install log and I noticed there was
 a problem upgrading the jrun connnector. That made sense since it
 didn't seam like Jrun was doing anything. I found a post on the forum
 here about what version the dll should be after the patch. Mine didn't
 match and I followed the directions provided to upgrade the connector.
 Bounced both CF and IIS and everything worked fine again.

 But now, this morning I came in to find the same problem, jrun idle,
 only CF not responding to the requests... I bounced the cf server and
 everything started working again, jrun started taking its normal
 amount of memory. Before restarting (and after) I noticed another
 problem. I can't load the CF information into performance monitor. The
 event viewer says:
 [Q]The data buffer created for the ColdFusion MX 7 Application
 Server service in the C:\WINNT\system32\cfperfmon_mx.dll library is
 not aligned on an 8-byte boundary. This may cause problems for
 applications that are  trying to read the performance data buffer.
 Contact the manufacturer of this  library or service to have this
 problem corrected or to get a newer version  of this library. [/Q]

 So here are my questions:
 How can I see whats going on with the server?
 Where can I look for the errors as to why this is happening???
 How can I test the CF server without going through the jrun connector?
 How can I test the jrun connector itself?

 Some additional notes...
 We are using CFDOCUMENT to generate PDF's quite frequently.
 We've been making use of the new Flex features in 7.01 lately.
 We've been using flash remoting lately.
 colfusion-err.log

Re: Problem creating user for CF

2005-10-20 Thread Anthony Prato
I'm trying to remember if I did anything special when setting this up,
the one thing I remember is giving the account log on as a service
rights in the local security policy.

On 10/20/05, Tom McNeer [EMAIL PROTECTED] wrote:
 Hi,

 On a new install of CFMX 7, I am attempting to run CF under a non-system
 user account, as recommended for security.

 I have created a user following the instructions in Macromedia's document
 Configuring ColdFusion MX 7 Server Security (which was published in
 February but now seems to have disappeared from the site) regarding the User
 account and its necessary permissions. I have checked several times to make
 sure that I have followed the steps correctly, but once the service is
 restarted under the new account, all that's returned by the browser is JRUN
 servlet error NULL 500.

 The Windows application log reports Win32 API routinue 'CreateFile' failed:
 Access is denied, which seems to indicate a permissions error.

 The Macromedia doc does not indicate the need for write permissions
 anywhere, though that seems to be the problem. But I don't want to grant
 write permissions anywhere that's not necessary, since that's part of the
 point of using a non-system account.

 Can anyone give me any guidance, please?

 --
 Thanks,

 Tom

 Tom McNeer
 MediumCool
 http://www.mediumcool.com
 530 Means St NW, Suite 110
 Atlanta, GA 30318
 404.589.0560


 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221707
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: more coldfusion 7.01 problems, Macromedia folks please read! I just want to cry

2005-10-20 Thread Anthony Prato
Your message is a reply to anothers post and is more than 100 lines of
text. Unless you are a major writer, your probably adding a lot of the
previous replies. Please trim your posts when replying. Thank you.

   150 is the min setting... It's usually
more around 400. Thats what
makes me think jrun was either idle or deadlocked. But since I can't
get perfmon to work, i couldn't see how many requests it had going.
here's my jvm args

java.args=-server -Xmx512m -Dsun.io.useCanonCaches=false
-XX:MaxPermSize=128m -XX:+UseParallelGC -DJINTEGRA_NATIVE_MODE
-DJINTEGRA_PREFETCH_ENUMS -Dcoldfusion.rootDir={application.home}/../
-Dcoldfusion.classPath={application.home}/../lib/updates,{application.home}/../lib,{application.home}/../gateway/lib/,{application.home}/../wwwroot/WEB-INF/cfform/jars
-Dcoldfusion.libPath={application.home}/../lib

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221709
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Server Just Hung after 7.01 update, administration help

2005-10-19 Thread Anthony Prato
Our CF standard server just hung, and I don't know why. I'm trying to
find out in the error logs but I'm not sure where to look. Also,
besides the CF error logs where should I be checking? I looked at the
event log (win2k) and didn't see anything. I can't figure out why it
hung! Any admin tips would be great.

Anthony

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221532
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Server Just Hung after 7.01 update, administration help

2005-10-19 Thread Anthony Prato
pages just were not loading, cf admin wasn't loading, jrun wasn't
taking much memory, jrun had 0 CPU time. A restart of the service
fixed the problem. I know it was working at 10:30, the problem was
reported to me around 11 but there is nothing suspicious in the error
logs. Are there any other ways to see what coldfusion is doing besides
task manager and just opening a page? Are there any logs to look at
besides the ones listed in the cf administrator?

On 10/19/05, Dan Phillips [EMAIL PROTECTED] wrote:
 Our CF standard server just hung, and I don't know why. I'm trying to
 find out in the error logs but I'm not sure where to look. Also,
 besides the CF error logs where should I be checking? I looked at the
 event log (win2k) and didn't see anything. I can't figure out why it
 hung! Any admin tips would be great.
 
 Anthony

 Are you getting any errors at all or are the pages just never loading?


 Dan Phillips
 [EMAIL PROTECTED]
 CFXHosting.com
 a division of Hosting.com

 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221543
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Server Administration/Diagnostic Help needed Was: Server Hung...

2005-10-19 Thread Anthony Prato
I reread my message and realized I rushed to much when writing it.
Convinced management a few months ago to get Coldfusion. Most
everything is still ASP classic. Last night I upgraded to 7.01. I know
it was working after the update and before 10:30 am.  Around 11am I
was told pages just were not loading. Checked cf admin, it wasn't
loading either, jrun wasn't taking much memory, jrun had 0 CPU time. A
restart of the service fixed the problem. There is nothing suspicious
in the error logs.

Are there any other ways to see what coldfusion is doing besides task
manager and just opening a page?

Can I test Coldfusion without using the JRun connector?

Can I test the JRun connector itself?

How can I reinstall just the jrun connector?

Are there any logs to look at besides the ones listed in the cf
administrator and the windows event viewer?


Anthony

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221544
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Server Administration/Diagnostic Help needed Was: Server Hung...

2005-10-19 Thread Anthony Prato
Yeah its something like that :)  Actually your response to my other
thread was on to something, There was an issue during the patch. It
says there was a non-fatal error:

Execute ANT Script:   Script: cfmx-patch-wsconfig-update.xml
  Status: ERROR
  Additional Notes: ERROR -
cfmx-patch-wsconfig-update.xml:26: Java returned: 1

So I'm wondering if there is a way to just reinstall the connector
dll. (or can i just copy it from another installation?) I'll need to
schedule a window before I can try to reinstall the patch, hopefully
that will work this time. Now I'm wondering if I need to do a complete
uninstall... yuk.

Does anyone know, if this happens again, how to test coldfusion
without going through the jrun connector?

Can I turn on the built in web server even though I originally did not
choose that as an option?

Anthony

On 10/19/05, Snake [EMAIL PROTECTED] wrote:
 To add/remov ethe connectors goto start -- program files -- macromedia --
 coldfusauon mx 7 -- web server configuration
 Or somehting like that, I forget the exact name of the program.
 Although this relaly wont make any diference as all your doing is mapping
 the file extension to the .dll file.



 -Original Message-
 From: Anthony Prato [mailto:[EMAIL PROTECTED]
 Sent: 19 October 2005 21:08
 To: CF-Talk
 Subject: Server Administration/Diagnostic Help needed Was: Server Hung...

 I reread my message and realized I rushed to much when writing it.
 Convinced management a few months ago to get Coldfusion. Most everything is
 still ASP classic. Last night I upgraded to 7.01. I know it was working
 after the update and before 10:30 am.  Around 11am I was told pages just
 were not loading. Checked cf admin, it wasn't loading either, jrun wasn't
 taking much memory, jrun had 0 CPU time. A restart of the service fixed the
 problem. There is nothing suspicious in the error logs.

 Are there any other ways to see what coldfusion is doing besides task
 manager and just opening a page?

 Can I test Coldfusion without using the JRun connector?

 Can I test the JRun connector itself?

 How can I reinstall just the jrun connector?

 Are there any logs to look at besides the ones listed in the cf
 administrator and the windows event viewer?


 Anthony



 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221561
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Server Administration/Diagnostic Help needed Was: Server Hung...

2005-10-19 Thread Anthony Prato
google is such a good friend... from the macromedia forums
1. Check to see the connector is the right version. It should be 92909.
/cfusionmx7/runtime/lib/wsconfig/1

Depending on the IIS version, check either jrun.dll or jrun_iis6_wildcard.dll)

If wsconfig didn't update the ISAPI connector correctly:

cd /cfusionmx7/runtime/lib
java -Dtrace.ci=1 -jar wsconfig.jar -upgrade -v

2. If you're doing a CFFILE action=upload with specifying a FILE
NAME (vs a directory) in the DESTINATION param of CFFILE, we know
about this and are publishing a hotfix probably Monday.

Look for it here:
http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_17883

Stephen Dupre
Macromedia QA

On 10/19/05, Anthony Prato [EMAIL PROTECTED] wrote:
 Yeah its something like that :)  Actually your response to my other
 thread was on to something, There was an issue during the patch. It
 says there was a non-fatal error:

 Execute ANT Script:   Script: cfmx-patch-wsconfig-update.xml
  Status: ERROR
  Additional Notes: ERROR -
 cfmx-patch-wsconfig-update.xml:26: Java returned: 1

 So I'm wondering if there is a way to just reinstall the connector
 dll. (or can i just copy it from another installation?) I'll need to
 schedule a window before I can try to reinstall the patch, hopefully
 that will work this time. Now I'm wondering if I need to do a complete
 uninstall... yuk.

 Does anyone know, if this happens again, how to test coldfusion
 without going through the jrun connector?

 Can I turn on the built in web server even though I originally did not
 choose that as an option?

 Anthony

 On 10/19/05, Snake [EMAIL PROTECTED] wrote:
  To add/remov ethe connectors goto start -- program files -- macromedia --
  coldfusauon mx 7 -- web server configuration
  Or somehting like that, I forget the exact name of the program.
  Although this relaly wont make any diference as all your doing is mapping
  the file extension to the .dll file.
 
 
 
  -Original Message-
  From: Anthony Prato [mailto:[EMAIL PROTECTED]
  Sent: 19 October 2005 21:08
  To: CF-Talk
  Subject: Server Administration/Diagnostic Help needed Was: Server Hung...
 
  I reread my message and realized I rushed to much when writing it.
  Convinced management a few months ago to get Coldfusion. Most everything is
  still ASP classic. Last night I upgraded to 7.01. I know it was working
  after the update and before 10:30 am.  Around 11am I was told pages just
  were not loading. Checked cf admin, it wasn't loading either, jrun wasn't
  taking much memory, jrun had 0 CPU time. A restart of the service fixed the
  problem. There is nothing suspicious in the error logs.
 
  Are there any other ways to see what coldfusion is doing besides task
  manager and just opening a page?
 
  Can I test Coldfusion without using the JRun connector?
 
  Can I test the JRun connector itself?
 
  How can I reinstall just the jrun connector?
 
  Are there any logs to look at besides the ones listed in the cf
  administrator and the windows event viewer?
 
 
  Anthony
 
 
 
  

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221564
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Server Administration/Diagnostic Help needed Was: Server Hung...

2005-10-19 Thread Anthony Prato
I was able to get it updated, hopefully that was the problem, Still
wish I knew more ways to debug the connector though.

On 10/19/05, Snake [EMAIL PROTECTED] wrote:
 Did you stop the cf service and www service when u installed the update. If
 not, try that, the connector may not have been updated.

 Russ

 -Original Message-
 From: Anthony Prato [mailto:[EMAIL PROTECTED]
 Sent: 19 October 2005 22:34
 To: CF-Talk
 Subject: Re: Server Administration/Diagnostic Help needed Was: Server
 Hung...

 Yeah its something like that :)  Actually your response to my other thread
 was on to something, There was an issue during the patch. It says there was
 a non-fatal error:

 Execute ANT Script:   Script: cfmx-patch-wsconfig-update.xml
  Status: ERROR
  Additional Notes: ERROR -
 cfmx-patch-wsconfig-update.xml:26: Java returned: 1

 So I'm wondering if there is a way to just reinstall the connector dll. (or
 can i just copy it from another installation?) I'll need to schedule a
 window before I can try to reinstall the patch, hopefully that will work
 this time. Now I'm wondering if I need to do a complete uninstall... yuk.

 Does anyone know, if this happens again, how to test coldfusion without
 going through the jrun connector?

 Can I turn on the built in web server even though I originally did not
 choose that as an option?

 Anthony

 On 10/19/05, Snake [EMAIL PROTECTED] wrote:
  To add/remov ethe connectors goto start -- program files --
  macromedia -- coldfusauon mx 7 -- web server configuration Or
  somehting like that, I forget the exact name of the program.
  Although this relaly wont make any diference as all your doing is
  mapping the file extension to the .dll file.
 
 
 
  -Original Message-
  From: Anthony Prato [mailto:[EMAIL PROTECTED]
  Sent: 19 October 2005 21:08
  To: CF-Talk
  Subject: Server Administration/Diagnostic Help needed Was: Server Hung...
 
  I reread my message and realized I rushed to much when writing it.
  Convinced management a few months ago to get Coldfusion. Most
  everything is still ASP classic. Last night I upgraded to 7.01. I know
  it was working after the update and before 10:30 am.  Around 11am I
  was told pages just were not loading. Checked cf admin, it wasn't
  loading either, jrun wasn't taking much memory, jrun had 0 CPU time. A
  restart of the service fixed the problem. There is nothing suspicious in
 the error logs.
 
  Are there any other ways to see what coldfusion is doing besides task
  manager and just opening a page?
 
  Can I test Coldfusion without using the JRun connector?
 
  Can I test the JRun connector itself?
 
  How can I reinstall just the jrun connector?
 
  Are there any logs to look at besides the ones listed in the cf
  administrator and the windows event viewer?
 
 
  Anthony
 
 
 
 



 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221578
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


flash form expired... again... can anyone help confirm this is a bug

2005-10-17 Thread Anthony Prato
I think I understand the timeout parameter of cfform. It works as
expected in situations like the documentation says, when clicking the
back button. The problem I see as a bug is this:
Form A- a flash form used to drill down.
Form B- a flash form to edit details.

Case 1
Select Category on Form A
Submit
Form B loads
Click Back button
expired as expected (since no timeout is set)

Case 2
Select Category on Form A
Submit
Form B loads
Click Cancel button (redirects to Form A with getURL)
Form A expired
*this should have reloaded Form A just like clicking an html link.

Case 3
submit Form A
Form B checks for required data, since it's not found, cflocation to Form A
Form A expired
*this should have reloaded Form A just like clicking an html link.

whats even worse is:
Select Category on Form A
Submit
Form B loads
Get back to Form A without it expiring
select the same category as before
Submit
Form B expired!

I'm frustrated... has anyone found any workarounds for this?
is there any way to catch the expired exception and reload the form?

Anthony

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221239
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CFFTP thru Corporate Firewall

2005-10-12 Thread Anthony Prato
Have you tried playing with the passive attribute?

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220821
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Why doesn't this query return more than 1 record?

2005-10-03 Thread Anthony Prato
My first instinct is to say... cause thats whats in the table. Try
doing a select FG.*, C.*

That should show the differences between the two rows and possibly
shed some light on the situation.

Which db is this?

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219904
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


[OT] choosing a printer on the client side with code (printing barcode labels)

2005-10-03 Thread Anthony Prato
We've got a website that generates labels with a bar code. Currently
the printing is handled with an activeX control. The user clicks a
print button, javascript uses the object to print based on fields
filled out by the user. I can generate the labels server side with
Async JS and CF then display it in the browser, the problem is we
don't want the user to have to select the label printer every time and
then click print. (plus we are keeping track of the number of copies
they print) Does anyone know of any other way to do this besides
activeX? The active X sometimes gives us grief. Hopefully something
more cross browser/platform. I'm guessing java can do it. Does anyone
know of a component like this?

Anthony

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219929
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Flash form looks with CSS?

2005-09-29 Thread Anthony Prato
I'm working on redesigning our intranet which has a ton of forms.
Flash forms will be great for many of them but not all. I don't have a
lot of time to do the actual design part so i was wondering if anyone
has created any image/css combinations to give html forms close to the
look of the flash forms. The first element that comes to mind is an
image/rollover to look like the flash form submit buttons. Anyone done
something like this or are you restyling the flash forms to look like
the html?

Anthony

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219711
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Enforcing 128-bit SSL

2005-09-13 Thread Anthony Prato
well it can differ between web servers but among the CGI variables the
webserver will pass to CF there should be a CERT_KEYSIZE variable in
the CGI scope. That's if you can't get it to happen on the server end,
which should be possible. It was still called Netscape Enterprise
Server the last I used that web server though :)

On 9/13/05, Barney Boisvert [EMAIL PROTECTED] wrote:
 Yeah, that's exactly what happens, the connection is denied.  An you
 can only do it at the vhost level, I believe.  N'mind then.  ;)  Just
 thought I'd throw it out there.
 
 cheers,
 barneyb
 
 On 9/13/05, Mike Chabot [EMAIL PROTECTED] wrote:
  Removing support for anything other than 128-bit connections is
  another option. The two concerns that come to mind are the error
  message that the user sees and whether or not I can lock down specific
  directories, as opposed to the entire site. The last time I tested
  removing support for 56-bit SSL, the user got a browser-generated
  error, as opposed to my custom error page. It was like the user was
  prevented from establishing any connection to the server, instead of
  connecting but being shown a friendly error message.
 
  Thank you,
  Mike Chabot
 
 
 --
 Barney Boisvert
 [EMAIL PROTECTED]
 360.319.6145
 http://www.barneyb.com/
 
 Got Gmail? I have 100 invites.
 
 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218090
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: XML, XSD, XSL

2005-09-08 Thread Anthony Prato
  2.XSD's don't seem to provide much benefit in a stand-alone
  application besides helping create test data via tools like xmlSpy.  I
  don't
  even see how in ColdFusion you can validate an XML using an associated
  XSD.
  And it doesn't look like XSL documents are based off of an XSD, so you
  still
  have to validate if field lengths, etc using code.  Am I missing something
  here?
 
 Nope... XSDs are far from a panacea... they check structure and dialect.
 Dat's it.
 
 CF 7 can validate an XSD and previous versions can do with outside help (COM
 or Java).


This is incorrect. you can validate a number of things with a proper
XSD. Beyond the actual document struction validation XSD supports many
native data types. You can define your own and use them within your
document. You can validate on ranges and numeric values. It supports
enumerations, and most importantly you can validate on REGEX patterns.

Check out w3schools for a good intro on creating XSD files. (then as
has been said use xml validate)  But just to warn you, the results
aren't always pretty :) Also FYI coldfusion use XERCES from
xml.apache.org for the validation.

Anthony

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217630
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


[OT] transparent source control

2005-09-08 Thread Anthony Prato
I was hoping to hear what the list thinks on an issue I have. 
I'm trying to make a number of changes at the place I've been working
for a few months. The small group of programmers has a disorganized
development process. I'm trying to work in some standard source
control but until that point I want to at least be able to, when
tracking bugs, to find out what changes where made to a file and when.
Backups somewhat help but what would be really nice is, like source
control, if I could look at the revision history for a single file. Is
there some sort of way to point a utility at a directory and have it
automatically check in files as they change on the server? (I know,
event gateways, but we don't have enterprise) The easier to install
and config the better.

Anthony

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217640
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: [OT] transparent source control

2005-09-08 Thread Anthony Prato
I am pretty set on subversion already, my problem's been getting the
developers to break their bad habits. The process here seems to be
someone talks about a bug or something they don't like. A programmer
jumps on it with very little planning and starts coding. They think it
works, through it into production. I can't tell you how bad my stomach
turns when they say lets just see what breaks when referring to
putting things in production. And unfortunately these habits aren't
yet seen as problems by management either. I know its not pretty but I
need something for damage control until I can get a handle on things
here.

:(



On 9/8/05, Barney Boisvert [EMAIL PROTECTED] wrote:
 You can set up Subversion with Apache and access it over webDAV, which
 is really slick.  Best of all, you can use both Subversion clients
 (that understand the SVN extensions to webDAV), and normal webDAV
 clients.  For normal clients, Subversion will just do a commit for any
 files saved to the folders, giving entirely transparent versioning.
 If you've got a Subversion client, then you can do all the other stuff
 like pull revision histories.
 
 It's really a very elegant setup; the Subversion guys definitely got
 their stuff together.
 
 cheers,
 barneyb
 
 On 9/8/05, Anthony Prato [EMAIL PROTECTED] wrote:
  I was hoping to hear what the list thinks on an issue I have.
  I'm trying to make a number of changes at the place I've been working
  for a few months. The small group of programmers has a disorganized
  development process. I'm trying to work in some standard source
  control but until that point I want to at least be able to, when
  tracking bugs, to find out what changes where made to a file and when.
  Backups somewhat help but what would be really nice is, like source
  control, if I could look at the revision history for a single file. Is
  there some sort of way to point a utility at a directory and have it
  automatically check in files as they change on the server? (I know,
  event gateways, but we don't have enterprise) The easier to install
  and config the better.
 
  Anthony
 
 
 
 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217659
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


problem loading a JSP tag library into CF

2005-09-01 Thread Anthony Prato
I've had a problem loading a JSP tag library. (CFMX7 developer) The
livedocs say:
Put the tag library, consisting of the taglibname.jar file, and the
taglibname.tld file, if one is supplied, in the web_root/WEB-INF/lib
directory. The JSP custom tag library must be in this directory for
you to use the cfimport tag.
Restart ColdFusion. 
In the ColdFusion page that uses a JSP tag from the tag library,
specify the tag library name in a cfimport tag; for example:
cfimport taglib=/WEB-INF/lib/random.jar prefix=random
If the TLD file is not included in the JAR file, use the .tld suffix
in place of the .jar suffix.

(i restarted CF between all of these steps)
The jar I'm trying to load (http://209.61.157.8:8080/taglibs/) has a
tld file in it. I first tried the above and got the message:
Could not import the tag library specified by
/WEB-INF/lib/ditchnet-tabs-taglib.jar.
The following error was encountered: Tag Library Descriptor not found.
Please ensure that you have specified a valid tag library.
I then pulled the tld out of the jar and put it into the lib directory
too... same error
I then downloaded the jstl.jar and standard.jar from apache (as the
taglib's docs instruct) and i get... same error
I tried the last comment from the livedocs and changed my cfimport to
cfimport taglib=/WEB-INF/lib/ditchnet-tabs-taglib.tld prefix=tab
at which point i get a 500 error:
500 javax/servlet/jsp/tagext/SimpleTagSupport

I downloaded the random taglib from apache and used the code from
livedocs and that worked :(

The docs for this taglib say that:
The Tabs Taglib has only been tested with the Apache Tomcat servlet
container v5.0.28. A servlet container that implements at least the
JSP 2.0 spec and the Servlet 2.3 spec will be required.

What version jsp and servlet does CF7 support?

Does anyone have any ideas on how to get this taglib to work? (or any
other taglibs that will provide an html equivalent of what the flash
forms tabs provide)

Anthony

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217114
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: problem loading a JSP tag library into CF

2005-09-01 Thread Anthony Prato
I've cycled it SO many times now :) I'm wondering if this is a version
problem. Does anyone know what version JSP and servlet CF7 supports?

Do I need to add anything to my web.xml?


Anthony


On 9/1/05, Dave Watts [EMAIL PROTECTED] wrote:
  I've had a problem loading a JSP tag library. (CFMX7 developer) ...
 
 My experience has been that I've had to cycle CFMX after adding taglib JAR
 and/or TLD files.
 
 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 
 Fig Leaf Software provides the highest caliber vendor-authorized
 instruction at our training centers in Washington DC, Atlanta,
 Chicago, Baltimore, Northern Virginia, or on-site at your location.
 Visit http://training.figleaf.com/ for more information!
 
 
 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217126
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: problem loading a JSP tag library into CF

2005-09-01 Thread Anthony Prato
Not sure if this went through, got some response saying the mail
server's antivirus detected something...


I've cycled it SO many times now :) I'm wondering if this is a version
problem. Does anyone know what version JSP and servlet CF7 supports?

Do I need to add anything to my web.xml?


Anthony

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217128
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: who on this list works for nmha.org

2005-09-01 Thread Anthony Prato
I'm getting the same thing all of the sudden.

On 9/1/05, Tim Laureska [EMAIL PROTECTED] wrote:
 I keep getting these replies sent back from nmha.org when I post to
 CFTALK:
 
 
 FROM: [EMAIL PROTECTED]
 Subject: Symantec Mail Security detected prohibited content in a message
 sent from your address
 
 Body:
 Subject of the message: RE: retaining checkbox selections Recipient of
 the message: CF-Talk cf-talk@houseoffusion.com
 
 What's up with this?
 
 
 
 
 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217131
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: LEFT AND RIGHT OUTER JOIN?

2005-09-01 Thread Anthony Prato
Ugly on so many levels but this may work...

SELECT t1.Loc_CD, t1.Loc_Name, t2.A_Number
FROM t1
left Join t2 on t1.Loc_CD=t2.Loc_CD
UNION
SELECT t2.loc_CD, null AS Loc_Name, t2.A_Number
FROM t2
WHERE t2.loc_CD NOT IN (SELECT DISTINCT Loc_CD FROM t1)



On 9/1/05, Gaulin, Mark [EMAIL PROTECTED] wrote:
 Hmm that is nasty
 
 One solution would be to do a union of three selects, one selecting just
 the case of being in both tables, the next for those records in table 1
 only, the last for those records in table 2 only.  Kinda lame, but
 better than nothing.
 
Mark
 
 -Original Message-
 From: Ian Skinner [mailto:[EMAIL PROTECTED]
 Sent: Thursday, September 01, 2005 2:24 PM
 To: CF-Talk
 Subject: LEFT AND RIGHT OUTER JOIN?
 
 I think I have solidly walked into the realm of why are you trying to
 do this?  So any suggestions on alternate ways to look at this problem
 are welcome.
 
 Say I have two tables something like these:
 
 TABLE ONE
 Loc_CD  Loc_Name
 ABC This
 DEF That
 DFE The Other
 
 TABLE TWO
 Loc_CD  A_Number
 DEF 123
 ALT 456
 
 I need a combined table that would look like this.
 Loc_CD  Loc_NameA_Number
 ABC This
 DEF That123
 DFE The Other
 ALT 456
 
 Please presume I did not create the base table and have little control
 over their structure and data.  But I need to somehow derive the
 combined table.
 
 How would one do this, is there such a thing as a double/leftright
 join?
 
 
 --
 Ian Skinner
 Web Programmer
 BloodSource
 www.BloodSource.org
 Sacramento, CA
 
 C code. C code run. Run code run. Please!
 - Cynthia Dunning
 
 Confidentiality Notice:  This message including any attachments is for
 the sole use of the intended
 recipient(s) and may contain confidential and privileged information.
 Any unauthorized review, use, disclosure or distribution is prohibited.
 If you are not the intended recipient, please contact the sender and
 delete any copies of this message.
 
 
 
 
 
 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217142
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: producing large PDF documents

2005-09-01 Thread Anthony Prato
How bout just try it with lorum ipsum. Try making a 10 page, 100,
1000, 5000 and see how long it takes.

I'd be very interested in the results and solution you come up with.
We may be looking at doing something like this in a few months.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217153
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


[SOT] Finding which files in a site aren't used anymore

2005-08-31 Thread Anthony Prato
I'm back to a problem that I run into a lot. I started working at a
place that does not do a good job of cleaning up files in a websites
directory. (as well as tons of unused stored procedures and views)
I've found plenty of tools to track down database objects, even some
that check your files for calls to the DB objects; I just can't find
anything for cleaning up the files. I know I can get a list of all the
files in all sub directories and grep for each, but I'm hoping someone
can recommend me a nicer GUI utility instead. Another nice feature
would be smarter than grep and if file A calls file B but nothing
calls file A then they are both obsolete. Does anyone know of a
utility like this. In the past I've used grep or similar but in this
case there are just too many files.

Anthony

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217045
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: [SOT] Finding which files in a site aren't used anymore

2005-08-31 Thread Anthony Prato
ooo.. very good point on the href=#approot#/path/to/file.cfm but
there are some good (relative to this issue) circumstances. Everything
here is pretty simplistic in terms of server side processing. There
aren't any urls in the database, (just tons of business logic) and I
haven't seen any places where dynamic URLs are constructed. There are
however many iFrames and frames where javacript functions load content
into new windows or iframes. There are also a lot of ASP include
files. Heck at this point I'd even settle for something that does all
the greping for me.

On 8/31/05, S. Isaac Dealey [EMAIL PROTECTED] wrote:
  I'm back to a problem that I run into a lot. I started
  working at a
  place that does not do a good job of cleaning up files in
  a websites
  directory. (as well as tons of unused stored procedures
  and views)
  I've found plenty of tools to track down database objects,
  even some
  that check your files for calls to the DB objects; I just
  can't find
  anything for cleaning up the files. I know I can get a
  list of all the
  files in all sub directories and grep for each, but I'm
  hoping someone
  can recommend me a nicer GUI utility instead. Another nice
  feature
  would be smarter than grep and if file A calls file B but
  nothing
  calls file A then they are both obsolete. Does anyone know
  of a
  utility like this. In the past I've used grep or similar
  but in this
  case there are just too many files.
 
 You also need to consider the possibility of template names being
 stored in the database -- in url columns if not columns indicating
 include template paths... Unfortunately I don't have any
 recommendations -- I use regular expression searches in dreamweaver if
 I want to check for more than one file name, but that obviously
 doesn't handle the semantic user-interface you're talking about where
 you want the IDE to know when it's looking for file a that file b
 should be removed if only file a references it. I would think also
 that for the tool to be really effective, it mind need to have some
 comprehension of the syntax of the language... though even then it may
 be questionable if there are variables used in paths, i.e.
 href=#approot#/path/to/file.cfm. An IDE that isn't tied _directly_
 to CF and/or knows the web-root and uses an http engine to figure out
 how those url's resolve won't be able to know what file is being
 referenced. Which ultimately may be a good part of the reason why you
 haven't found any good tools to perform this task.
 
 Sorry I couldn't be more helpful...
 
 I would recommend checking the db(s) for any columns with the terms
 URL or HREF or link in the column name...
 
 s. isaac dealey   954.522.6080
 new epoch : isn't it time for a change?
 
 add features without fixtures with
 the onTap open source framework
 
 http://www.fusiontap.com
 http://coldfusion.sys-con.com/author/4806Dealey.htm
 
 
 
 
 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217051
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CF Execute Error... Silly Java....

2005-08-29 Thread Anthony Prato
I may be shooting in the dark here but...
does the account(cf runs under) also have domain rights to change passwords?
does the account have interactive system rights? I think it's called
log on locally which might be needed because its a command line app.

Anthony

On 8/29/05, Brian Polackoff [EMAIL PROTECTED] wrote:
 Trying to use cfexecute to change an AD password.  Works no problem from the
 command prompt however when I load the page it get:
 
 
 
 The cause of this exception was that: java.io.IOException: CreateProcess:
 net user.exe MYUSERNAME MYPASSWORD /domain error=2
 
 
 
 -  or -
 
 -
 
 The cause of this exception was that: java.io.IOException: CreateProcess:
 net user.exe MYUSERNAME MYPASSWORD /domain error=3
 
 
 
 My psuedocode is:
 
 
 
 cfset args = #Trim(MYUSERNAME)# #Trim(MYPASSWORD)# /domain
 
 
 
 cfsavecontent variable=results
 
cfexecute name=net user.exe arguments=#args# timeout=10 /
 
 /cfsavecontent
 
 
 
 I have verified that the account that runs the Coldfusion service has the
 appropriate rights to access net user.exe and verified that the cfexecute
 tag is not disabled in cfadmin.
 
 
 
 Any Ideas would be greatly appreciated.
 
 
 
 Thanks,
 Brian R. Polackoff
 
 
 
 Coldfusion Version 6.1
 
 
 
 
 
 
 
 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216694
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: load balanced configuration

2005-08-25 Thread Anthony Prato
The ideal setup would be...
The web servers (serving graphics and static html) in the dmz behind a
load balancer with isapi rewrite or jrun connector or mod_rewrite to
connect through a firewall to a load balancer connecting to the two
coldfusion servers. Then the coldfusion servers would be connected to
the database server through another firewall.

Anthony

On 8/25/05, Russ [EMAIL PROTECTED] wrote:
 We are getting 5 servers.  One db server, 2 web servers and 2 cf servers.
 Is it possible to have a configuration where the web servers do all the
 communication with the client, and only access the CF servers when they need
 CF content (possibly through a load balancer)?  Is this a recommended
 solution?
 
 
 
 
 
 
 
 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216363
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: load balanced configuration

2005-08-25 Thread Anthony Prato
although i haven't ran in distributed mode with CF7 yet, I think
things are mostly the same. (I know Sean runs this config at
macromedia so he should have a final answer)

 If I recall correctly, you would have to have all of the CF pages on both
 the web and CF servers, although the work done to generate output from those
 pages would be done only by the CF servers. 

You are part correct. Only files that are directly requested need to
be on the web server. (eg files that are only cfinclude'd don't need
to be there, neither does application.cfm) However the files do not
need to have any content. (all mine said placeholder) The web server
just needs to see a file in the location that the browser is
requesting before it proxies the request to whatever you are using to
forward to the cf server. You may even be able to get around this if
you tell the web server not to validate a file's existence, but I'm
not sure, never tried that.

 will need licenses for CF on all web and CF servers, even though you won't
 actually be running the CF engine on the web servers. 

I don't think that's correct, but that's a question for someone at Macromedia

 presumably be sparing CPU cycles on your web servers this way, they'll still
 have to wait until the CF server finishes generating a request before
 sending that response to the client, so I can't say whether you'll buy
 yourself any significant performance increase by doing this.

I agree, if this is your only concern Dave's solution of having a
static content only web server would be cheaper and easier. IMO the
main benefit of running in distributed mode is saving money on
licenses and better security by having multiple instances on your cf
servers, some for internal apps, some for external apps because the
distributed mode lets cf run behind another layer of firewall/LB.



Anthony


 
 If you just want to take the load of handling static files off of the CF
 servers, you can do that without all this work - just put all your images on
 a separate web server, and point to them within your HTML and CF pages
 appropriately.
 
 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 
 Fig Leaf Software provides the highest caliber vendor-authorized
 instruction at our training centers in Washington DC, Atlanta,
 Chicago, Baltimore, Northern Virginia, or on-site at your location.
 Visit http://training.figleaf.com/ for more information!
 
 
 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216424
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: load balanced configuration

2005-08-25 Thread Anthony Prato
I'm pretty sure your correct...
found sean's post:

If it's any help, Macromedia runs the built-in web server on JRun for
its public-facing website. Here's how we have it set up:

Cisco Load Balancer (clustered pair, round robin) - macromedia.com
   |
Apache 2.0.x (web server cluster; Solaris)
   |
Cisco Load Balancer (clustered pair, sticky session)
   |
CFMX 7 / JRun (cluster: two instances per server, six servers; Solaris)
   |
Oracle 9i (Solaris)

We use mod_proxy / mod_rewrite to pass .cfm / .cfc requests to the
second tier. You can probably do something like that with IIS so that
you don't have to directly expose the JWS.


On 8/25/05, Dave Watts [EMAIL PROTECTED] wrote:
  although i haven't ran in distributed mode with CF7 yet, I think
  things are mostly the same. (I know Sean runs this config at
  macromedia so he should have a final answer)
 
 Actually, I don't think this is how macromedia.com runs. I recall them using
 a reverse proxy configuration through Apache - similar in some respects
 (they're not running CF on the public-facing server directly I guess), but
 not distributed mode.
 
 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 
 Fig Leaf Software provides the highest caliber vendor-authorized
 instruction at our training centers in Washington DC, Atlanta,
 Chicago, Baltimore, Northern Virginia, or on-site at your location.
 Visit http://training.figleaf.com/ for more information!
 
 
 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216438
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: load balanced configuration

2005-08-25 Thread Anthony Prato
I wish it wasn't so long since I tested this config out but from what
I can remember you only need mod_proxy/mod_rewrite if you are going to
have a hardware load balancer between the web and application servers.
This DevNet article explains how to use the jrun connector on
different subnets:
http://www.macromedia.com/support/coldfusion/administration/cfmx_in_distributed_mode/cfmx_in_distributed_mode02.html

When I last used the config mentioned before, I was using a Cisco CSS
and I guess they now have an article (with links to the older
articles) here:
http://www.macromedia.com/support/coldfusion/administration/cfmx_in_distributed_mode/cfmx_in_distributed_mode02.html

The main benefit we found using hardware load balancers with sticky
sessions was that we could shut off new connections to a server and
wait for the load to go away before taking it down for
rollouts/maintenance.

Anthony

On 8/25/05, Russ [EMAIL PROTECTED] wrote:
 I'm a little confused about why mod_proxy/mod_rewrite are needed?  Following
 is a configuration of CF from apache.  Why not just change the ip address of
 the bootstrap? Or does it only allow requests from 127.0.0.1?
 
 LoadModule jrun_module C:/JRun4/lib/wsconfig/2/mod_jrun20.so
 IfModule mod_jrun20.c
JRunConfig Verbose false
JRunConfig Apialloc false
JRunConfig Ssl false
JRunConfig Ignoresuffixmap false
JRunConfig Serverstore C:/JRun4/lib/wsconfig/2/jrunserver.store
JRunConfig Bootstrap 127.0.0.1:51020
#JRunConfig Errorurl optionally redirect to this URL on errors
#JRunConfig ProxyRetryInterval 600
#JRunConfig ConnectTimeout 15
#JRunConfig RecvTimeout 300
#JRunConfig SendTimeout 15
AddHandler jrun-handler .jsp .jws .cfm .cfml .cfc .cfr .cfswf
 /IfModule
 
 
 
 -Original Message-
 From: Anthony Prato [mailto:[EMAIL PROTECTED]
 Sent: Thursday, August 25, 2005 6:32 PM
 To: CF-Talk
 Subject: Re: load balanced configuration
 
 I'm pretty sure your correct...
 found sean's post:
 
 If it's any help, Macromedia runs the built-in web server on JRun for
 its public-facing website. Here's how we have it set up:
 
 Cisco Load Balancer (clustered pair, round robin) - macromedia.com
   |
 Apache 2.0.x (web server cluster; Solaris)
   |
 Cisco Load Balancer (clustered pair, sticky session)
   |
 CFMX 7 / JRun (cluster: two instances per server, six servers; Solaris)
   |
 Oracle 9i (Solaris)
 
 We use mod_proxy / mod_rewrite to pass .cfm / .cfc requests to the
 second tier. You can probably do something like that with IIS so that
 you don't have to directly expose the JWS.
 
 
 On 8/25/05, Dave Watts [EMAIL PROTECTED] wrote:
   although i haven't ran in distributed mode with CF7 yet, I think
   things are mostly the same. (I know Sean runs this config at
   macromedia so he should have a final answer)
 
  Actually, I don't think this is how macromedia.com runs. I recall them
 using
  a reverse proxy configuration through Apache - similar in some respects
  (they're not running CF on the public-facing server directly I guess), but
  not distributed mode.
 
  Dave Watts, CTO, Fig Leaf Software
  http://www.figleaf.com/
 
  Fig Leaf Software provides the highest caliber vendor-authorized
  instruction at our training centers in Washington DC, Atlanta,
  Chicago, Baltimore, Northern Virginia, or on-site at your location.
  Visit http://training.figleaf.com/ for more information!
 
 
 
 
 
 
 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216447
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: load balanced configuration

2005-08-25 Thread Anthony Prato
oops that last link was supposed to be:
http://www.macromedia.com/devnet/coldfusion/articles/css_multi.html

On 8/25/05, Anthony Prato [EMAIL PROTECTED] wrote:
 I wish it wasn't so long since I tested this config out but from what
 I can remember you only need mod_proxy/mod_rewrite if you are going to
 have a hardware load balancer between the web and application servers.
 This DevNet article explains how to use the jrun connector on
 different subnets:
 http://www.macromedia.com/support/coldfusion/administration/cfmx_in_distributed_mode/cfmx_in_distributed_mode02.html
 
 When I last used the config mentioned before, I was using a Cisco CSS
 and I guess they now have an article (with links to the older
 articles) here:
 http://www.macromedia.com/support/coldfusion/administration/cfmx_in_distributed_mode/cfmx_in_distributed_mode02.html
 
 The main benefit we found using hardware load balancers with sticky
 sessions was that we could shut off new connections to a server and
 wait for the load to go away before taking it down for
 rollouts/maintenance.
 
 Anthony
 
 On 8/25/05, Russ [EMAIL PROTECTED] wrote:
  I'm a little confused about why mod_proxy/mod_rewrite are needed?  Following
  is a configuration of CF from apache.  Why not just change the ip address of
  the bootstrap? Or does it only allow requests from 127.0.0.1?
 
  LoadModule jrun_module C:/JRun4/lib/wsconfig/2/mod_jrun20.so
  IfModule mod_jrun20.c
 JRunConfig Verbose false
 JRunConfig Apialloc false
 JRunConfig Ssl false
 JRunConfig Ignoresuffixmap false
 JRunConfig Serverstore C:/JRun4/lib/wsconfig/2/jrunserver.store
 JRunConfig Bootstrap 127.0.0.1:51020
 #JRunConfig Errorurl optionally redirect to this URL on errors
 #JRunConfig ProxyRetryInterval 600
 #JRunConfig ConnectTimeout 15
 #JRunConfig RecvTimeout 300
 #JRunConfig SendTimeout 15
 AddHandler jrun-handler .jsp .jws .cfm .cfml .cfc .cfr .cfswf
  /IfModule
 
 
 
  -Original Message-
  From: Anthony Prato [mailto:[EMAIL PROTECTED]
  Sent: Thursday, August 25, 2005 6:32 PM
  To: CF-Talk
  Subject: Re: load balanced configuration
 
  I'm pretty sure your correct...
  found sean's post:
 
  If it's any help, Macromedia runs the built-in web server on JRun for
  its public-facing website. Here's how we have it set up:
 
  Cisco Load Balancer (clustered pair, round robin) - macromedia.com
|
  Apache 2.0.x (web server cluster; Solaris)
|
  Cisco Load Balancer (clustered pair, sticky session)
|
  CFMX 7 / JRun (cluster: two instances per server, six servers; Solaris)
|
  Oracle 9i (Solaris)
 
  We use mod_proxy / mod_rewrite to pass .cfm / .cfc requests to the
  second tier. You can probably do something like that with IIS so that
  you don't have to directly expose the JWS.
 
 
  On 8/25/05, Dave Watts [EMAIL PROTECTED] wrote:
although i haven't ran in distributed mode with CF7 yet, I think
things are mostly the same. (I know Sean runs this config at
macromedia so he should have a final answer)
  
   Actually, I don't think this is how macromedia.com runs. I recall them
  using
   a reverse proxy configuration through Apache - similar in some respects
   (they're not running CF on the public-facing server directly I guess), but
   not distributed mode.
  
   Dave Watts, CTO, Fig Leaf Software
   http://www.figleaf.com/
  
   Fig Leaf Software provides the highest caliber vendor-authorized
   instruction at our training centers in Washington DC, Atlanta,
   Chicago, Baltimore, Northern Virginia, or on-site at your location.
   Visit http://training.figleaf.com/ for more information!
  
  
  
 
 
 
  

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216448
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: SQL/Oracle Indexing a temporary view.

2005-08-24 Thread Anthony Prato
I think what you are looking for in oracle is called a materialized view 

Anthony

On 8/24/05, Ian Skinner [EMAIL PROTECTED] wrote:
 Adrian
 
 Can you share what that SQL might look like, under the hope that Oracle may 
 use the same syntax.  Not a large hope, but hope none the less.
 
 I looked up the Oracle (8i) CREATE INDEX documentation and quickly got very 
 lost on all the variations and convolutions.
 
 
 --
 Ian Skinner
 Web Programmer
 BloodSource
 www.BloodSource.org
 Sacramento, CA
 
 C code. C code run. Run code run. Please!
 - Cynthia Dunning
 
 Confidentiality Notice:  This message including any
 attachments is for the sole use of the intended
 recipient(s) and may contain confidential and privileged
 information. Any unauthorized review, use, disclosure or
 distribution is prohibited. If you are not the
 intended recipient, please contact the sender and
 delete any copies of this message.
 
 
 
 
 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216281
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: SQL/Oracle Indexing a temporary view.

2005-08-24 Thread Anthony Prato
While you have your book open...

is it true that clustered index views are only supported in the
enterprise edition of SQL server?

On 8/24/05, Adrian Lynch [EMAIL PROTECTED] wrote:
 Good question! I was just reading about it today while studying for MS's
 70-229 exam, so here goes nothing...
 
 Taking an example from the book:
 
 CREATE VIEW MyView WITH SCHEMABINDING AS
SELECT MyColumn, MyOtherColumn
FROM dbo.MyTable
WHERE MyColumn = 'Some Value'
 
 Some notes on creating indexed views:
 - The view must specify SCHEMABINDING
 - You must use owner.object syntax
 - You can't use * (ALL)
 - You can't have derived tables
 - No UNION, OUTTER JOIN, sub queries or self joins
 - No TOP or ORDER BY
 - No COUNT(*), instead use COUNT_BIG(*), although I'm not sure if it's the
 use of the * or COUNT() that's the problem
 - No aggregate functions AVG, MAX, MIN
 - The following need also be true:
- NUMERIC_ROUNDABORT set to OFF
- ANSI_NULLS set to ON
- ANSI_PADDING set to ON
- ARITHABORT set to ON
- CONCAT_NULL_YIELDS_NULL set to ON
- QUOTED_IDENTIFIER set to ON
 - The first index created on the view must be unique clustered
 - There after non-clustered can be added
 - Removing the clustered index will remove the non-clustered indexes
 
 Then to create the index:
 
 CREATE CLUSTERED INDEX MyClusteredIndex ON MyView (MyColumn, MyOtherColumn)
 
 Now how's that for simplicity?!
 
 Probably of no help to you but it's revision for me :OD
 
 Ade
 
 -Original Message-
 From: Ian Skinner [mailto:[EMAIL PROTECTED]
 Sent: 24 August 2005 22:57
 To: CF-Talk
 Subject: RE: SQL/Oracle Indexing a temporary view.
 
 
 Adrian
 
 Can you share what that SQL might look like, under the hope that Oracle may
 use the same syntax.  Not a large hope, but hope none the less.
 
 I looked up the Oracle (8i) CREATE INDEX documentation and quickly got very
 lost on all the variations and convolutions.
 
 
 --
 Ian Skinner
 Web Programmer
 BloodSource
 www.BloodSource.org
 Sacramento, CA
 
 C code. C code run. Run code run. Please!
 - Cynthia Dunning
 
 Confidentiality Notice:  This message including any
 attachments is for the sole use of the intended
 recipient(s) and may contain confidential and privileged
 information. Any unauthorized review, use, disclosure or
 distribution is prohibited. If you are not the
 intended recipient, please contact the sender and
 delete any copies of this message.
 
 
 
 
 
 
 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216287
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: folder query to XML?

2005-08-23 Thread Anthony Prato
can you sort your query by the depth? thats the easiest way because
you can just loop over the query adding a node at a time. (group by
parentFolder order by depth) When you order by depth you don't need to
worry if the parrent exists in the XML DOM yet because the parent will
always apear before the child in the query. Otherwise you'll need to
find the root create it, find the children of root, create them, find
their children... etc. (you'll need either a recursive function or a
whole bunch of loops

On 8/23/05, Paul Hastings [EMAIL PROTECTED] wrote:
 Larry Lyons wrote:
  Paul,
 
  You could try converting the query to XML using Nathan Dintenfass's
  QueryToXML udf, http://www.cflib.org/udf.cfm/querytoxml.
 
 thanks but that's the first place i checked actually. it's not the
 conversion to XML that's my problem it's the structure that cftree will
 swallow via remoting that i need to work out in my XML challenged brain.
 
 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216093
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: determining darkness/lightness of hex colors

2005-08-18 Thread Anthony Prato
do you know the other formula's for working with colors? for whatever
reason I haven't had the best luck in the past with google.

On 8/18/05, Charles Polisher [EMAIL PROTECTED] wrote:
 Here's a formula that gives the approx. brightness
 for an RGB value: Y=0.299R+0.587G+0.114B
 
 
 
 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215708
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: getAuthUser() displays Windows OS login ID?

2005-08-15 Thread Anthony Prato
turn it off on iis (properties = directory security tab = anon
access and auth control) or stop using IE :)

On 8/15/05, Johnny Le [EMAIL PROTECTED] wrote:
 If this is the case, how does he fix it?  How does he disable the NTLM 
 authentication?
 
 Johnny
 
  Could NTLM authentication be enabled and he isn't aware of it?
 
  http://livedocs.macromedia.
  com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.
  htm?context=ColdFusion_Documentationfile=0287.htm#2991147
 
  It says A request that uses NTLM or Digest authentication. In this
  case,
  the username and password are hashed using a one-way algorithm in the
 
  Authorization header; ColdFusion gets the username from the web server
  and
  sets the cflogin.password value to the empty string.
 
  On 8/15/05, Johnny Le [EMAIL PROTECTED] wrote:
  
   Hi,
  
   My co-worker has a problem. His getAuthUser() keeps displaying his
  Windows
   OS login ID. The cflogout doesn't seem to do anything. So he can't
  log out,
   which means he can't get the cflogin to run again.
  
   The only difference in the way he uses cflogin than I do is that he
  didn't
   use cflogin.name http://cflogin.name and leave the password
  attribute's
   value blank. He uses user_id (numeric) from the database for the
  name
   attribute. So getAuthUser() should display the user ID, but it
  displays the
   Windows OS login ID instead.
  
   We deleted the client cookies. We restarted Coldfusion server. We
  did very
   much everything we could think of, but the value of getAuthUser()
  remains
   the same.
  
   When I downloaded his code to my computer, it works fine. I can log
  in,
   log out and all the info display correctly. Anyone has any ideas
  what's
   going on?
  
   Apparently Mike Rolfes has the same problem. He posted it at
   http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p73.
  htm#wp2991147.
   Although he used CFC, we don't. Any help would be appreciated.
  
   Johnny
  
  
 
 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215081
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


cfprocparam

2005-08-09 Thread Anthony Prato
I'm confused about cfprocparam. (mx7pro) The documentation states you
have to specify them in order relative to the stored proc. There is no
way to bind them to the proc's variable. However the debugging output
generates a table for each proc call and there is a column for
dbVarName, which makes me think that binding to a named parameter is
possible. Has anyone written a replacement cfstoredproc tag? Can I use
the underlying java to do this? Does anyone have any good links for
this. Mostly what i've found so far just repeats that you must pass
all db vars in order.

TIA
Anthony

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214207
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: cfprocparam

2005-08-09 Thread Anthony Prato
ugh... and it doesn't even pass the dbvarname parameter to the table
generated in the debugging output.

On 8/9/05, Dave Watts [EMAIL PROTECTED] wrote:
  I'm confused about cfprocparam. (mx7pro) The documentation
  states you have to specify them in order relative to the
  stored proc. There is no way to bind them to the proc's
  variable. However the debugging output generates a table
  for each proc call and there is a column for dbVarName,
  which makes me think that binding to a named parameter is
  possible. Has anyone written a replacement cfstoredproc
  tag? Can I use the underlying java to do this? Does anyone
  have any good links for this. Mostly what i've found so far
  just repeats that you must pass all db vars in order.
 
 You must pass all db vars in order.
 
 Sorry, but I couldn't resist. You must, in fact, do so. The DBVARNAME
 attribute used to work prior to CFMX using some databases, but it doesn't
 work with CFMX and is there for backward compatibility - you can still have
 it, but it doesn't actually do anything I guess. I don't think you can do
 this from Java; I believe this is a limitation of either the database
 drivers or of JDBC itself.
 
 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 
 Fig Leaf Software provides the highest caliber vendor-authorized
 instruction at our training centers in Washington DC, Atlanta,
 Chicago, Baltimore, Northern Virginia, or on-site at your location.
 Visit http://training.figleaf.com/ for more information!
 
 
 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214220
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Physical Address Verification.

2005-08-02 Thread Anthony Prato
The only one I've heard of is the postal service one. But I was just
thinking, what about the google maps api? If you type in a bad address
on their site it complains. I would imagine the API does something
similar.

Anthony

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213551
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: XML XSL / XSLT

2005-08-01 Thread Anthony Prato
What would really be nice if you could use XSLT and CFINCLUDE together.
something like:
cfinclude template=myBizXml.cfxml xsl=xml2cfml.xsl
so that the xsl could be run on the xml before being loaded as CFML
like a regular cfm page. right now all you can do is open the xml, run
the tranformation and then I guess you would have to use evaluate().
(yuk)

On 8/1/05, Andy [EMAIL PROTECTED] wrote:
 I am working through a similar set of questions.  I've determined that there
 is value in converting my standard data format into and out of my
 classes/cfc's into XML.  Now I am wondering about the advantages of
 
 1.  Creating XSD's for each format
 2.  Using XSLTs versus CFMX to render
 
 Besides liking to see a general dialog on the pros and cons of creating XSDs
 and using XSLTs, I am also interested in whether field size limits put into
 the XSD get automatically added to the HTML Input ... Size= generated
 in an XSLT or whether I need to add code to do so like I would for name and
 value.  If I need to add code, how do I reference XSD info?
 
 Andy
 
 
 
 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213417
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: need help with a coldfusion install problem

2005-07-29 Thread Anthony Prato
well i think they definitely need a technote. I found a bunch of
threads with the same problem but no solution. I finally found one
talking about permissions. It turns out that for whatever reason the
sys admins removed the permissions for the SYSTEM account, which
coldfusion is run as by default. I added permissions for SYSTEM and it
worked.

Thanks again for looking out.

Anthony

On 7/28/05, S. Isaac Dealey [EMAIL PROTECTED] wrote:
  Thanks Isaac. Unfortunatly it didn't work.
  I'm having the same problem. After
  uninstalling and installing again I still
  get the File not found error. Has anyone
  else seen this?
 
 It's not an issue I'm familiar with personally... it sounds oddly
 familiar tho... You might want to check the mm site for a technote if
 you don't get a response from someone who's more familiar with it.
 
 
 s. isaac dealey 954.522.6080
 new epoch : isn't it time for a change?
 
 add features without fixtures with
 the onTap open source framework
 
 http://www.fusiontap.com
 http://coldfusion.sys-con.com/author/4806Dealey.htm
 
 
 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213252
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: need help with a coldfusion install problem

2005-07-29 Thread Anthony Prato
Cool, thanks Dave. You are correct, there are reasons to remove
SYSTEM. (I was only changing permissions on the dev server so far)
From what I've researched since my last post it seams that removing
SYSTEM is good because the SYSTEM account has the same internal id on
every installation which makes it a vulnrability. I'm working on
setting up a local user right now. It's been a long time since I've
done any sysadmin work, but will the coldfusion user account need log
on as service rights? Are there any other special permissions the cf
server may need?

Anthony

On 7/29/05, Dave Watts [EMAIL PROTECTED] wrote:
  well i think they definitely need a technote. I found a bunch
  of threads with the same problem but no solution. I finally found
  one talking about permissions. It turns out that for whatever
  reason the sys admins removed the permissions for the SYSTEM
  account, which coldfusion is run as by default. I added permissions
  for SYSTEM and it worked.
 
 I have two comments on this.
 
 First, there might be a good reason why your sysadmins removed those
 permissions from SYSTEM, although the SYSTEM security context can always
 take ownership of whatever it wants anyway, and grant itself permissions.
 You might want to check with them before you change things around.
 
 Second, and more importantly, you would be better served by running CF as a
 less privileged user instead of SYSTEM. You can create a user account just
 for CF, and grant it the necessary permissions and user rights.
 Alternatively, if you're using Windows Server 2003, you can use the Local
 Service (or Network Service if you need to access remote shares, etc)
 security context which is considerably less privileged than SYSTEM.
 Macromedia has a technote about how to do this with CFMX, and it's pretty
 easy actually.
 
 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 
 Fig Leaf Software provides the highest caliber vendor-authorized
 instruction at our training centers in Washington DC, Atlanta,
 Chicago, Baltimore, Northern Virginia, or on-site at your location.
 Visit http://training.figleaf.com/ for more information!
 
 
 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213277
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


need help with a coldfusion install problem

2005-07-28 Thread Anthony Prato
I finially got the company I'm working for to buy coldfusion and now
I'm having trouble installing it. I connected to the server with
remote desktop and started the install. Everything went fine until it
tried to kick over to the web based portion of the install. My account
hadn't used IE yet so it made me do the internet setup wizard. When
that was complete i was left with the IE start page. Now I don't know
the URL to complete the install and when i try and connect to the
administrator I get
Error Occurred While Processing Request 
File not found: /cfide/administrator/index.cfm 

Permissions on the drive all seam ok.  The only other weird thing is
that in the IIS admin the CFIDE subfolder of the site is a read stop
sign error icon. But if I expand the directory all the files are
there, so I assume this means IIS sees the file and my guess is that
this has something to do with the setup not finishing.

Please Help, its been a very long day :)

Anthony

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213246
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: need help with a coldfusion install problem

2005-07-28 Thread Anthony Prato
Thanks Isaac. Unfortunatly it didn't work. I'm having the same
problem. After uninstalling and installing again I still get the File
not found error. Has anyone else seen this?

On 7/28/05, S. Isaac Dealey [EMAIL PROTECTED] wrote:
 I would recommend simply running the installer again from the
 beginning... I don't believe it will hurt anything. I'm not certain
 (been a while since I installed it) but it might also give you a
 couple of repair/uninstall options. Maybe try uninstall first if
 you're really concerned aobut it.
 
  I finially got the company I'm working for to buy
  coldfusion and now
  I'm having trouble installing it. I connected to the
  server with
  remote desktop and started the install. Everything went
  fine until it
  tried to kick over to the web based portion of the
  install. My account
  hadn't used IE yet so it made me do the internet setup
  wizard. When
  that was complete i was left with the IE start page. Now I
  don't know
  the URL to complete the install and when i try and connect
  to the
  administrator I get
  Error Occurred While Processing Request
  File not found: /cfide/administrator/index.cfm
 
  Permissions on the drive all seam ok.  The only other
  weird thing is
  that in the IIS admin the CFIDE subfolder of the site is a
  read stop
  sign error icon. But if I expand the directory all the
  files are
  there, so I assume this means IIS sees the file and my
  guess is that
  this has something to do with the setup not finishing.
 
  Please Help, its been a very long day :)
 
  Anthony
 
 
 s. isaac dealey 954.522.6080
 new epoch : isn't it time for a change?
 
 add features without fixtures with
 the onTap open source framework
 
 http://www.fusiontap.com
 http://coldfusion.sys-con.com/author/4806Dealey.htm
 
 
 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213248
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Using CFLDAP to change the password of a user in Active Directroy...

2005-07-27 Thread Anthony Prato
it can be don't but since I've done it I lost my code. The short end
of what you need to do is search for two different things. Setting an
AD password with LDAP must use SSL. This involves having a certificate
on your network (certificate authority i think is what microsoft calls
it) to allow SSL with LDAP. Since the password needs to be in a byte
array (if i remember correctly) I came to the conclusion I couldn't
set a password with CFLDAP. So the next thing you need to search for
is setting an AD password with java. I found java code on some
Sun/Java message board and pretty much translated it line for line
into a CFSCRIPT block. To use the certificate your network certificate
authority has created in coldfusion you must import it into the
keystore. See macromedia docs for doing that. You should now be setup
to set passwords, just make sure the account you are using for the
LDAP connection has the appropriate permissions to connect via LDAP
and reset passwords. (see your sys admin for that, thats what i did)

Hope that helps. Sorry I don't have my code or documentation any more.
Microsoft also has some helpful tools on the windows server cd.
ldp.exe and... well there's another but I forgot :)

Anthony

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213043
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: HTTP Request Question

2005-07-22 Thread Anthony Prato
I would guess CFHTTPPARAM with a type = header
I'm just not sure on the correct header syntax. your sniffing should
tell you that or the HTTP spec is out there on the net.

Anthony

On 7/22/05, John Stanley [EMAIL PROTECTED] wrote:
 Thanks dave. Is there a setting somewhere in CFMX that allows Connection
 Headers to be Keep-Alive? If so, what is the default setting?
 
 -Original Message-
 From: Dave Watts [mailto:[EMAIL PROTECTED]
 Sent: Friday, July 22, 2005 11:26 AM
 To: CF-Talk
 Subject: RE: HTTP Request Question
 
 
  Does CFMX use IIS (if that is our webserver) to make CFHTTP
  requests? I say yes. Am I right?
 
 CFMX acts as an HTTP client when you use CFHTTP. It uses whatever HTTP
 server you connect to, just like any browser would use that server.
 
 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 
 Fig Leaf Software provides the highest caliber vendor-authorized
 instruction at our training centers in Washington DC, Atlanta,
 Chicago, Baltimore, Northern Virginia, or on-site at your location.
 Visit http://training.figleaf.com/ for more information!
 
 
 
 
 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212589
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: thin array / cfbam.cfc

2005-07-19 Thread Anthony Prato
Well if you just want it to be generic, CFGRID with type XML will
return the xml string of a grid to a variable.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212214
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Coldfusion7, cfprocparam blank date fields!

2005-07-15 Thread Anthony Prato
If I understand correctly you are trying to have these date parameters
of your stored procedure optional. Why not make them optional in the
stored procedure? In your stored procedure when you define for example
@DOB datetime, Just change it to @DOB datetime=null This will set
the parameter @DOB to null if it is not passed into the SP. (this is
for SQL server, that is what you are using correct?)

Anthony

On 7/15/05, Andy Mcshane [EMAIL PROTECTED] wrote:
 OK, the code below is used to call the function
 
 invoke object=application.playerreport methodcall=InsertPageOne( 
 argumentcollection=DataFields ) returnVariable=InsertPageOne /
 
 All of my form fields are within the structure 'DataFields' and I know that 
 they are all there when it is passed to the CFC.
 
 Within my CFC my CFSTOREDPROC is as follows
 
cffunction name=InsertPageOne access=public returntype=query 
 hint=Insert page one player report details
cfstoredproc procedure=usp_insert_player_report_page_one
datasource=#request.datasource#
returncode=Yes debug=Yes
cfprocresult name=insertpageone resultset=1
cfprocparam type=IN
value=#arguments.clubid#
cfsqltype = CF_SQL_INTEGER
[EMAIL PROTECTED]
cfprocparam type=IN
value=#arguments.PLAYERID#
cfsqltype = CF_SQL_INTEGER
[EMAIL PROTECTED]
 ..other stuff here 
cfif len(arguments.dob)
cfprocparam type=IN
value=#arguments.DOB#
cfsqltype = CF_SQL_DATE
[EMAIL PROTECTED]
cfelse
cfprocparam type=IN
null=yes
cfsqltype = CF_SQL_DATE
[EMAIL PROTECTED]
/cfif
cfif len(arguments.fixdate)
cfprocparam type=IN
value=#arguments.FIXDATE#
cfsqltype = CF_SQL_DATE
[EMAIL PROTECTED]
cfelse
cfprocparam type=IN
null=yes
cfsqltype = CF_SQL_DATE
[EMAIL PROTECTED]
/cfif
/cfstoredproc
cfreturn insertpageone
/cffunction
 
 The last part is giving me the problem. I have tried using 'isDate' as well 
 as the above which is just checking if there is any data there. If there is 
 nothing then I need to pass null. Unfortunately using the code above simply 
 loses the parameter so instead of my stored procedure receiving 19 parameters 
 as expected every blank date field loses one off the total i.e. 1 blank field 
 and then only 18 parameters are passed. I am going mad trying to solve this, 
 please help.
 
 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212009
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Simple XML cfscript question

2005-07-13 Thread Anthony Prato
queryname.columnlist is what you are looking for. use listlen() to set
your upper bound. You may also want to check out cflib.org for some
helpful functions like converting query rows to structs, structs to
xml, etc. (there are tons of handy functions there)

Anthony

On 7/13/05, Merrill, Jason [EMAIL PROTECTED] wrote:
 Well, I got it working, didn't realize I could use the Array access
 operator like I can in Flash and Javascript - gotta love ECMA.
 
 Here is the script, but how can I make it cleaner  - i.e. get names of
 fields and then loop over those?
 
 cfscript
lrXML = XmlNew();
lrXML.xmlRoot = XmlElemNew(lrXML,lData);
for (i = 1; i LTE #qAllLessons.RecordCount#; i = i + 1){
lrXML.lData.XmlChildren[i] =
 XmlElemNew(lrXML,Content);
lrXML.lData.XmlChildren[i].XmlChildren[1] =
 XmlElemNew(lrXML,ID);
lrXML.lData.XmlChildren[i].XmlChildren[2] =
 XmlElemNew(lrXML,Lesson);
lrXML.lData.XmlChildren[i].XmlChildren[3] =
 XmlElemNew(lrXML,Required);
lrXML.lData.XmlChildren[i].XmlChildren[4] =
 XmlElemNew(lrXML,Time);
lrXML.lData.XmlChildren[i].ID.XmlText =
 #qLessons.ID[i]#;
lrXML.lData.XmlChildren[i].Lesson.XmlText =
 #qLessons.Lesson[i]#;
lrXML.lData.XmlChildren[i].Required.XmlText =
 #qLessons.Required[i]#;
lrXML.lData.XmlChildren[i].Time.XmlText =
 #qLessons.Time[i]#;
}
 /cfscript
 
 Jason Merrill   |   E-Learning Solutions   |  icfconsulting.com
 
 
 
 
 
 
 
 
 
 -Original Message-
 From: Merrill, Jason [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, July 13, 2005 11:31 AM
 To: CF-Talk
 Subject: Simple XML cfscript question
 
 New here - Flash-guy, also new to ColdFusion and SQL (CF-Newbies
 doesn't
 seem to be populated with anybody)
 
 (...and before I ask the question, I'm also looking for a cleaner way
 to
 write this, like not having to hard code the field column names)
 
 How do I insert each subsequent record from a database into my XML
 file?
 I got this working, but it of course repeats the first record in each
 child node,which is not what I want.
 
 cfquery name=qAllLessons datasource=coursesDB
   SELECT * FROM Lessons
 /cfquery
 cfquery name=qLessons datasource=coursesDB
   SELECT ID, Lesson, Required, Time FROM Lessons
 /cfquery
 
 cfscript
   lrXML = XmlNew();
   lrXML.xmlRoot = XmlElemNew(lrXML,lData);
   for (i = 1; i LTE #qAllLessons.RecordCount#; i = i + 1){
   lrXML.lData.XmlChildren[i] =
 XmlElemNew(lrXML,Content);
   lrXML.lData.XmlChildren[i].XmlChildren[1] =
 XmlElemNew(lrXML,ID);
   lrXML.lData.XmlChildren[i].XmlChildren[2] =
 XmlElemNew(lrXML,Lesson);
   lrXML.lData.XmlChildren[i].XmlChildren[3] =
 XmlElemNew(lrXML,Required);
   lrXML.lData.XmlChildren[i].XmlChildren[4] =
 XmlElemNew(lrXML,Time);
   lrXML.lData.XmlChildren[i].ID.XmlText = #qLessons.ID#;
   lrXML.lData.XmlChildren[i].Lesson.XmlText =
 #qLessons.Lesson#;
   lrXML.lData.XmlChildren[i].Required.XmlText =
 #qLessons.Required#;
   lrXML.lData.XmlChildren[i].Time.XmlText =
 #qLessons.Time#;
   }
 /cfscript
 cfdump var=#lrXML#
 cfset XMLText = ToString(lrXML)
 cffile action=write
 file=C:\CFusionMX7\wwwroot\com\macromedia\test\myTextXml_3.xml
 output=#XMLText#
 
 
 This outputs:
 
 ?xml version=1.0 encoding=UTF-8 ?
 lData
Content
  ID1/ID
  LessonbIntroduction to Spatial Analysis/Lesson
  RequiredTrue/Required
  Time2/Time
   /Content
   Content
  ID1/ID
  LessonbIntroduction to Spatial Analysis/Lesson
  RequiredTrue/Required
  Time2/Time
   /Content
 ...etc...
 
 How do I write the query to insert each record into each subsequent
 node
 instead of inserting the first record each time?
 
 Or, is there a cfscript out there that will take a table and convert
 its
 contents to XML with the nodes being named what the field names are
 named?  I have searched the web, but haven't found one yet.
 
 Thanks.
 
 Jason Merrill   |   E-Learning Solutions   |  icfconsulting.com
 
 
 
 
 
 
 
 
 
 
 
 NOTICE:
 This message is for the designated recipient only and may contain
 privileged or
 confidential information. If you have received it in error, please
 notify the sender
 immediately and delete the original. Any other use of this e-mail by
 you is
 prohibited.
 
 
 
 
 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211758
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: 

Re: Simple XML cfscript question

2005-07-13 Thread Anthony Prato
i'm a bit rusty on my syntax, i've been working on some asp projects
recently (yuk)

try this out
cfscript
   lrXML = XmlNew();
   lrXML.xmlRoot = XmlElemNew(lrXML,lData);
   for (ii = 1; ii LTE qAllLessons.RecordCount; ii = ii + 1){
   lrXML.lData.XmlChildren[ii] =
XmlElemNew(lrXML,Content);

 for (kk = 1; kk LTE listlen(qAllLessons.columnlist); kk = kk + 1) {
 lrXML.lData.XmlChildren[ii].XmlChildren[kk] =
XmlElemNew(lrXML,#listgetat(qAllLessons.columnlist,kk)#);

lrXML.lData.XmlChildren[ii].XmlChildren[kk].XmlText =
qAllLessons[#listgetat(qAllLessons.columnlist,kk)#][ii]
 }
}
/cfscript

Anthony

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211761
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: How to authenticate using cf 4.5

2005-07-13 Thread Anthony Prato
I've never seen any way to do this and I'm pretty sure you can't. Even
going right to active directory all you can do is set passwords, you
can't return their value. Most of the time on intranets I only allow
NT auth and just use the username in the queries. If only NTauth is
active they should (never know its M$) be valid users to even start
processing your CF page.

Anthony

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211766
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: How to authenticate using cf 4.5

2005-07-13 Thread Anthony Prato
I think I've seen a trick where you use an html form and then
authenticate(programmatic, using headers or something, can't remember)
so you have the password that way, but I've never seen the password
grabbed from the NT auth popup. If you find that code please share it
either on list or directly to me. That would be handy.

Anthony

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211769
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


insert one xml object as the child of another?

2005-07-07 Thread Anthony Prato
Is there any way to insert one xml object as a child node in another xml object?

Right now I'm doing an xml search, which returns an array with xml
objects. I want to loop through the array, process each xml object
individually. (during which I add nodes to each object) Then I want to
combine all the objects in the array as children of another xml
object.
So far I have only been able to combine these by converting each array
element to it's xml string, replace the xml definition and insert the
xml string into the destination xml string. Then finally parse the
destination xml string. Why can't I get this to work without strings
or a recursive UDF? I tried:
ArrayAppend(destXML.DispenseFile.XmlChildren,
XmlElemNew(destXML,XML_SearchResultsArray[1].xmlName));
destXML.DispenseFile.XmlChildren[arraylen(destXML.DispenseFile.XmlChildren)]
= XML_SearchResultsArray[1];
but I get the error:
WRONG_DOCUMENT_ERR: A node is used in a different document than the
one that created it.
Only thing I can find with google is that the DOM1 doesn't support
this so am I correct in assuming this has to do with the underling
java?

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211361
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


[SOT] regex to validate SQL Server datetime type (for xsd pattern restriction)

2005-07-07 Thread Anthony Prato
I'm working on using the xmlvalidate() function in MX7 but I'm finding
the standard for datetime that xsd uses annoying since CF doesn't
recognize it as a date. I would rather setup a custom type in my xsd
using a pattern restriction. Pattern restrictions use regex to
validate the element. Does anyone have regex to validate a datetime
for sql server? preferably where the time portion is optional.

Anthony

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211363
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


  1   2   >