Re: Quicky question re: cfdocument and fonts

[Lawrence B. Afrin, M.D.]

To Peter Boughton, Christine Davis, Chris Peterson, and Sandra Clark --

Thanks again for the help you provided me regarding my question about how to 
switch fonts within a cfdocument.

In the end, a combination of inline style specifications (not  tags) and 
upgrading my server from 7.0 to 7.0.2
completely fixed the problem.  My app is now producing PDFs in the desired font.

Thank you!

-- Larry Afrin
   Medical University of South Carolina


Sandra Clark wrote:

> Make sure your call to a stylesheet is within the  tags.
> Basically your entire layout.  I'm not sure how Acrobat handles  other obsolete tags, but it does handle most of CSS properly.
>
> Sandra Clark
> ==
> http://www.shayna.com
> Training in Cascading Style Sheets and Accessibility
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 04, 2006 2:07 PM
> To: CF-Talk
> Subject: Re: Quicky question re: cfdocument and fonts
>
> Peter --
>
> Thanks for the idea, but I had also tried (prior to my original posting) the
> inline style stuff such as you suggested -- and got exactly the same result.
>
> Any other ideas?  There has to be some way to use cfdocument to generate a
> PDF with a font other than Times Roman...
>
> -- LBA
>
> Quoting Peter Boughton <[EMAIL PROTECTED]>:
>
> > What about if you try using .. ?
> >
> >
> >> Howdy --
> >>
> >> I'm making my first use of cfdocument (no jokes about being behind
> >> the times, please -- I've been busy with other things), and it seems
> >> that no matter what I specify in the  tag inside the
> >> cfdocument, the resulting PDF displays the content in the same Times
> >> Roman font in whatever the default font size is (looks like about
> >> 12).  I tried lots of the different font faces listed on my CF
> >> Administrator's Font Management page, but I keep getting the same
> >> result.  Have also tried both "yes" and "no" fontembed settings,
> >> makes no difference.
> >> For that matter, I can't even get it to pay attention to  >> size="whatever"> tags.  The size of the type in the PDF is properly
> >> affected by tags like , but  doesn't seem to be having any
> >> effect at all.
> >>
> >> I searched around a bit before writing this post, and I found a
> >> little bit of material alluding to there being some font problems
> >> with cfdocument in 7.0, but it wasn't clear to me that Updater 1
> >> really fixed it, as there seem to be some more recent hotfixes for
> >> the same problem.  I really couldn't find a good summary of the whole
> >> issue.
> >>
> >> Bottom line: I'm running MX 7 (version 7,0,0,91690 -- again, no jokes
> >> about behind the times; I believe in not fixing it if it ain't broke,
> >> but now it's broke) on Linux.  Can anybody tell me what I have to do
> >> to get my cfdocument-produced PDFs to pay attention to my 
> >> tags?
> >>
> >> -- Larry Afrin
> >
> >> Medical University of South Carolina
> >
> >> [EMAIL PROTECTED]
> >
> >
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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

Re: Follow-up re: Quicky question re: cfdocument and fonts

[Lawrence B. Afrin, M.D.]

Christine --

Alright, you've told me twice now, I'll take a hint :-) and upgrade my server.

Thanks!

-- LBA ("Larry," please -- not even my mother calls me "Lawrence")

P.S.  Um, as long as I'm doing a good "stupid" impression in public, I might as 
well also ask: where do I find "the TTF
sfile" to install for the TrueType fonts listed on my server's Font Management 
page?  All of these fonts are listed as
being installed in my server's /usr/share/fonts/default/TrueType directory, but 
I don't see anything that looks like an
"sfile" hanging around in there.  For that matter, I have no idea how those 
TrueType fonts came to be on my server in
the first place; I'm presuming the CFMX 7.0 install put them there for use with 
cfdocument and cfreport.

Christine Davis wrote:

> Lawrence, 7.0.1 and 7.0.2 fix a number of issues related to CFDocument.
>
> 1. ID 60865 PDF files created with the cfdocument tag may not render
> content with the specified fonts. To avoid this issue, install the TTF
> sfile for the font you want to use. In addition, on OS X, if the content
> contains any Unicode characters, the content may not render properly. To
> avoid this issue on OS X, install Arial Unicode MS or any other Unicode
> font in .ttf form.
>
> 2. ID 60212 cfdocument text clipping at bottom/top of page also fixes
> 59991
>
> 3. ID 61378 Threading Issues
>
> And a couple of others I didn't care so much about... It also adds some
> additional functionality to the CFDocument tag.
>
> Our issues with font size and font face decreased significantly after we
> installed the upgrade.  We had examples of the same HTML code showing
> the correct font face on our development (7.0.2) server and our
> production (7.0.0) server.  I cannot tell you what to do with your
> server, but my experience has been that upgrading greatly helped with
> our CFDocument problems.  It's not perfect, and quirks still get
> through.  Even with the upgrades applied styles don't always work as
> expected.. but it is closer now.
>
> Thanks!
> Christine Davis
> ColdFusion Lead
> Nations Technical Services
> Prairie Village, KS
> 913-748-8044 ext 4703
> [EMAIL PROTECTED]
>
> -Original Message-
> From: Lawrence B. Afrin, M.D. [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 04, 2006 5:16 PM
> To: CF-Talk
> Subject: Follow-up re: Quicky question re: cfdocument and fonts
>
> Chris, Christine, Sandra, and everyone else --
>
> A bit of a mea culpa here, with some progress but some persistent
> problems...
>
> Thanks again for your previous efforts to help me with my problem making
> font adjustments in PDFs produced with
> cfdocument in CFMX 7.0 (Linux).  I discovered a typo in my inline style
> font directive that was causing part of the
> problem.  The "" tag still doesn't work, but inline style
> directives are beginning to work.  I now have partial
> control over the font in the PDF, by which I mean I can control font
> sizes using the "font-size" directive and, using
> the "font" directive, I can switch (to some degree) among the fonts of
> font type "ADOBE-BUILT-IN" as listed on the CFMX
> server's Font Management page.  By "some degree" I mean I seem to be
> able to access only the base fonts.  For example,
> font:Times-Roman works, but font:Times-Italic doesn't.  Furthermore,
> whenever I refer to any of the fonts that are
> listed in the Font Management page as being of font type "TRUETYPE", I
> merely get the default Times Roman.
>
> Along the lines of "if it ain't broke, don't fix it," I'm now wondering
> if I really do have to update my server as you,
> Christine, suggested.  Do y'all have any other suggestions for accessing
> the TrueType fonts (e.g., Arioso, Chevara,
> Conga, Helmet) listed on my CFMX server's Font Management page?  Again,
> I've tried this with both fontembed settings
> ("yes" and "no"), to no avail; I just keep getting the default Times
> Roman whenever I reference a TrueType font.  I've
> also verified my font directives are inside the cfdocument structure.
>
> -- LBA
>
> Sandra Clark wrote:
>
> > Make sure your call to a stylesheet is within the  tags.
> > Basically your entire layout.  I'm not sure how Acrobat handles  or
> > other obsolete tags, but it does handle most of CSS properly.
> >
> > Sandra Clark
> > ==
> > http://www.shayna.com
> > Training in Cascading Style Sheets and Accessibility
> >
> > -Original Message-
> > From: [EMAIL

Follow-up re: Quicky question re: cfdocument and fonts

[Lawrence B. Afrin, M.D.]

Chris, Christine, Sandra, and everyone else --

A bit of a mea culpa here, with some progress but some persistent problems...

Thanks again for your previous efforts to help me with my problem making font 
adjustments in PDFs produced with
cfdocument in CFMX 7.0 (Linux).  I discovered a typo in my inline style font 
directive that was causing part of the
problem.  The "" tag still doesn't work, but inline style directives are 
beginning to work.  I now have partial
control over the font in the PDF, by which I mean I can control font sizes 
using the "font-size" directive and, using
the "font" directive, I can switch (to some degree) among the fonts of font 
type "ADOBE-BUILT-IN" as listed on the CFMX
server's Font Management page.  By "some degree" I mean I seem to be able to 
access only the base fonts.  For example,
font:Times-Roman works, but font:Times-Italic doesn't.  Furthermore, whenever I 
refer to any of the fonts that are
listed in the Font Management page as being of font type "TRUETYPE", I merely 
get the default Times Roman.

Along the lines of "if it ain't broke, don't fix it," I'm now wondering if I 
really do have to update my server as you,
Christine, suggested.  Do y'all have any other suggestions for accessing the 
TrueType fonts (e.g., Arioso, Chevara,
Conga, Helmet) listed on my CFMX server's Font Management page?  Again, I've 
tried this with both fontembed settings
("yes" and "no"), to no avail; I just keep getting the default Times Roman 
whenever I reference a TrueType font.  I've
also verified my font directives are inside the cfdocument structure.

-- LBA

Sandra Clark wrote:

> Make sure your call to a stylesheet is within the  tags.
> Basically your entire layout.  I'm not sure how Acrobat handles  other obsolete tags, but it does handle most of CSS properly.
>
> Sandra Clark
> ==
> http://www.shayna.com
> Training in Cascading Style Sheets and Accessibility
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 04, 2006 2:07 PM
> To: CF-Talk
> Subject: Re: Quicky question re: cfdocument and fonts
>
> Peter --
>
> Thanks for the idea, but I had also tried (prior to my original posting) the
> inline style stuff such as you suggested -- and got exactly the same result.
>
> Any other ideas?  There has to be some way to use cfdocument to generate a
> PDF with a font other than Times Roman...
>
> -- LBA
>
> Quoting Peter Boughton <[EMAIL PROTECTED]>:
>
> > What about if you try using .. ?
> >
> >
> >> Howdy --
> >>
> >> I'm making my first use of cfdocument (no jokes about being behind
> >> the times, please -- I've been busy with other things), and it seems
> >> that no matter what I specify in the  tag inside the
> >> cfdocument, the resulting PDF displays the content in the same Times
> >> Roman font in whatever the default font size is (looks like about
> >> 12).  I tried lots of the different font faces listed on my CF
> >> Administrator's Font Management page, but I keep getting the same
> >> result.  Have also tried both "yes" and "no" fontembed settings,
> >> makes no difference.
> >> For that matter, I can't even get it to pay attention to  >> size="whatever"> tags.  The size of the type in the PDF is properly
> >> affected by tags like , but  doesn't seem to be having any
> >> effect at all.
> >>
> >> I searched around a bit before writing this post, and I found a
> >> little bit of material alluding to there being some font problems
> >> with cfdocument in 7.0, but it wasn't clear to me that Updater 1
> >> really fixed it, as there seem to be some more recent hotfixes for
> >> the same problem.  I really couldn't find a good summary of the whole
> >> issue.
> >>
> >> Bottom line: I'm running MX 7 (version 7,0,0,91690 -- again, no jokes
> >> about behind the times; I believe in not fixing it if it ain't broke,
> >> but now it's broke) on Linux.  Can anybody tell me what I have to do
> >> to get my cfdocument-produced PDFs to pay attention to my 
> >> tags?
> >>
> >> -- Larry Afrin
> >
> >> Medical University of South Carolina
> >
> >> [EMAIL PROTECTED]
> >
> >
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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

Quicky question re: cfdocument and fonts

[Lawrence B. Afrin, M.D.]

Howdy --

I'm making my first use of cfdocument (no jokes about being behind the times, 
please -- I've been busy with other
things), and it seems that no matter what I specify in the  tag inside 
the cfdocument, the resulting PDF displays
the content in the same Times Roman font in whatever the default font size is 
(looks like about 12).  I tried lots of
the different font faces listed on my CF Administrator's Font Management page, 
but I keep getting the same result.  Have
also tried both "yes" and "no" fontembed settings, makes no difference.  For 
that matter, I can't even get it to pay
attention to  tags.  The size of the type in the PDF is 
properly affected by tags like , but
 doesn't seem to be having any effect at all.

I searched around a bit before writing this post, and I found a little bit of 
material alluding to there being some font
problems with cfdocument in 7.0, but it wasn't clear to me that Updater 1 
really fixed it, as there seem to be some more
recent hotfixes for the same problem.  I really couldn't find a good summary of 
the whole issue.

Bottom line: I'm running MX 7 (version 7,0,0,91690 -- again, no jokes about 
behind the times; I believe in not fixing it
if it ain't broke, but now it's broke) on Linux.  Can anybody tell me what I 
have to do to get my cfdocument-produced
PDFs to pay attention to my  tags?

-- Larry Afrin
   Medical University of South Carolina
   [EMAIL PROTECTED]


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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

How can I use CF to output a spreadsheet with embedded pictures?

[Lawrence B. Afrin, M.D.]

Howdy --

I've been playing around with making CF output Excel spreadsheets containing 
JPEGs.  As best as I can tell, Excel leaves
the actual JPEGs as external objects and stores only references to the source 
objects in the .xls file itself.  Every
time the spreadsheet is (re-)opened in Excel, the sources are 
re-accessed/re-loaded, too.

Presuming one did a cffile action="read" to read a JPEG file's full datastream 
into a CF variable, is it possible to
directly embed an actual JPEG in the .xls file, and if so, how would the 
following standard code for outputting an Excel
spreadsheet via CF be modified to do so?





  
Applepicture of an apple
Orangepicture of an orange
  


-- Larry Afrin
   Medical University of South Carolina
   [EMAIL PROTECTED]


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:245877
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Need help with tricky XPath syntax

[Lawrence B. Afrin, M.D.]

Already resolved (the final couple of messages in my dialogue with Hua Wei were 
rejected by the list for some reason).  Thanks anyway, though.

-- LBA

Ian Skinner wrote:

> Larry
>
> If you have not solved this issue yet, I find this a great resource for 
> xslt/xpath questions. 
> [http://www.zvon.org/xxl/XSLTreference/Output/index.html]  I have always been 
> able to figure out what I need from their tutorials and examples.  If I have 
> time later today, I'll take a crack at your issue, but you may very well 
> solve it before I get a chance.
>
> --
> 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:227307
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 tricky XPath syntax

[Lawrence B. Afrin, M.D.]

Hua --

Thanks, but that's not quite right.  I agree that getting the sponsorship 
element is easy with the expression you provided, but what I actually need is 
the parent identity element (along with all of its sponsorship subelements) of 
any sponsorship elements with a status attribute of Active and a text value of 
Provost.

-- LBA

Hua Wei wrote:

> Larry,
> Not sure whether this is what you are looking for:
>
> /IDMS/identity/[EMAIL PROTECTED]'Active' and text()='Provost']
>
> Returns this element:
> Provost
>
> Hua
>
> -Original Message-
> From: Lawrence B. Afrin, M.D. [mailto:[EMAIL PROTECTED]
> Sent: Friday, December 16, 2005 11:25 AM
> To: CF-Talk
> Subject: Need help with tricky XPath syntax
>
> Howdy --
>
> I'm having difficulty crafting a tricky XPath expression and would appreciate 
> help from any XPath gurus out there.
>
> Sample document:
>
> 
>   
> Provost
> Residents
>   
>   
> HR
> Provost
> UMA
>   
> 
>
> I need an XPath expression that will extract the array of  elements 
> with Active Provost sponsorship.
>
> Applying the expression I seek against the above document would yield a 
> one-element array containing only the second  element from the 
> document.
>
> Extracting the  elements with Provost sponsorship is trivial:
>
> /IDMS/identity[sponsorship='Provost']
>
> The tricky part seems to be restricting the selection to only the *Active* 
> Provost sponsorships.
>
> I've tried a zillion permutations on the following as the second argument to 
> my XMLSearch() call, but none of my experiments has worked right yet:
>
> /IDMS/identity[sponsorship='Provost' and [EMAIL PROTECTED]'Active']]
>
> I've looked through all the XPath tutorials I could find but couldn't find an 
> answer to this question (at least, not an answer I could understand).  
> Looking at some complex examples I've found in some tutorials, I've gotten a 
> vague sense that somehow "id()" and "self::" are going to be involved in a 
> solution, but otherwise I'm just totally lost.
>
> Greatly appreciate any help anyone can provide.
>
> -- Larry Afrin
>Medical University of South Carolina
>
> 

~|
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:227190
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 tricky XPath syntax

[Lawrence B. Afrin, M.D.]

Howdy --

I'm having difficulty crafting a tricky XPath expression and would appreciate 
help from any XPath gurus out there.

Sample document:


  
Provost
Residents
  
  
HR
Provost
UMA
  


I need an XPath expression that will extract the array of  elements 
with Active Provost sponsorship.

Applying the expression I seek against the above document would yield a 
one-element array containing only the second
 element from the document.

Extracting the  elements with Provost sponsorship is trivial:

/IDMS/identity[sponsorship='Provost']

The tricky part seems to be restricting the selection to only the *Active* 
Provost sponsorships.

I've tried a zillion permutations on the following as the second argument to my 
XMLSearch() call, but none of my
experiments has worked right yet:

/IDMS/identity[sponsorship='Provost' and [EMAIL PROTECTED]'Active']]

I've looked through all the XPath tutorials I could find but couldn't find an 
answer to this question (at least, not an
answer I could understand).  Looking at some complex examples I've found in 
some tutorials, I've gotten a vague sense
that somehow "id()" and "self::" are going to be involved in a solution, but 
otherwise I'm just totally lost.

Greatly appreciate any help anyone can provide.

-- Larry Afrin
   Medical University of South Carolina



~|
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:227167
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: Consuming web services involving complex parameters

[Lawrence B. Afrin, M.D.]

Gary --

The link must have wrapped in your browser.  Tack ".cfm" onto the end of that 
URL.

-- LBA

Garry Viner wrote:

> Hi Larry
>
> Thanks so much for your response. Glad to know someone else had as much 
> trouble as me. Anyway, I'm going to go through that and try to make some 
> sense of it. However, the link you posted to the formatted docs
>
> http://hcc.musc.edu/research/shared_resources/xml_complex_types_to_cf_structure_notes
>
> does not work - it says the page is not available.
>
> Thanks again, and I'll let you know if I get the damn thing working.
>
> Garry
>
> 

~|
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:221453
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: Consuming web services involving complex parameters

[Lawrence B. Afrin, M.D.]

Garry --

Howdy.  You're welcome to help yourself to the now-shelved pharmacopoeia of 
antipsychotics I amassed while trying myself to solve this problem many moons 
ago.  Alternatively, here are some non-pharmaceutical resources that
may help you:

If you check the LiveDocs for the "Handling complex data types" topic 
(http://livedocs.macromedia.com/coldfusion/7/htmldocs/1554.htm), you'll see 
some helpful starting tips there plus, at the bottom, an added comment of
mine which leads to a support forum thread (one of a few I posted on this topic 
over the last couple of years or so) which again poses the question I think 
you're asking -- and the solution.  However, there are formatting
constraints in the support forums, and a better formatted version of the 
solution is also posted elsewhere 
(http://hcc.musc.edu/research/shared_resources/xml_complex_types_to_cf_structure_notes.cfm).

I hope this helps.  Alternatively, you can let me know whether you'd rather 
have the Haldol or Risperdal out of my medicine cabinet; I don't think they've 
hit their expiration dates yet.  :-)

-- Larry Afrin, M.D.
   Associate Professor of Medicine, Division of Hematology/Oncology
   Director of Information Technology, Hollings Cancer Center
   Medical University of South Carolina
   [EMAIL PROTECTED]


"Garry Viner (GV)" wrote:

> Hi there. I hope someone can help me with this problem before I slowly go
> insane.
>
> I am trying to consume a webservice, where the input parameter is defined as
> a collection.
>
> The documentation looks like this:
>
> 
> http://www.w3.org/2001/XMLSchema-instance";
> xmlns:xsd="http://www.w3.org/2001/XMLSchema";
> xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/";>
>   
> http://www.at2.com.au/Member/webservices/";>
>   
> 
>   <_testStruct>
> string
> boolean
>   
>   <_testStruct>
> string
> boolean
>   
> 
>   
> 
>   
> 
>
> Alternatively, the wsdl file looks like this:
>
> 
>  
>   
>   type="s0:_testCollection" />
> 
>
> 
>
> 
>  
>  type="s0:ArrayOf_testStruct" />
>
> 
>
> 
>  
>  type="s0:_testStruct" />
>
>  
> 
>
> 
>   
> 
>
>  />
>
> 
>
>
>
> I would have assumed that I needed to create the parameter as follows:
>
> 
> 
> 
> 
>  
>  
>  
>  
> 
> 
> 
>
>  webservice="http://www.at2.com.au/member/webservices/wsCreateMember.asmx?wsd
> l"
>method="DummyTestMethod4"
>returnvariable="returnVar">
>
>  
>
> 
>
>
>
> However I get the following error message:
>
> Web service operation "DummyTestMethod4" with parameters
> {testCollection={{TESTCOLLECTION={{TESTSTRUCT={[{STRTEST={foo},BOLTEST={fals
> e}}, {STRTEST={foo},BOLTEST={false}}]}} could not be found.
>
> In fact, no matter how I use structures and arrays to create a parameter for
> this web service, I get the same error. It's driving me insane.
>
> Anyone able to help me here please?
>
> Garry
>
>
>
>
>
> 

~|
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:221330
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

Does CFGRID support copy-and-paste to/from spreadsheets?

[Lawrence B. Afrin, M.D.]

Hello --

A question re: ColdFusion's ability to interact with "the outside world" (i.e., 
the non-web world):

Scenario: I have a spreadsheet (shouldn't matter which spreadsheet product, but 
if you need specifics, let's say it's
Excel) with some data in it, and I would like to build a ColdFusion-based web 
page that looks similar to the spreadsheet
(rows and columns full of input boxes).

Question: Is it possible to build this web page in such a fashion that I can 
literally copy-and-paste a range of cells
from the spreadsheet into an identically sized range of input boxes on the web 
page?  And what about vice versa (i.e.,
can I copy-and-paste a range of input boxes on the web page into an identically 
sized range of cells in the
spreadsheet)?

I can copy-and-paste a range of cells from a Windows spreadsheet to other 
Windows apps and retain the grid model of the
data because, I guess, Windows has an understanding of grid objects.  Does the 
Java that lies behind CFGRID have a
similar understanding?

Thanks for any insights you can provide.

Sincerely,

Larry Afrin
Medical University of South Carolina
[EMAIL PROTECTED]


~|
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:213437
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: Interfacing CFMX to External Web Services Requiring

[Lawrence B. Afrin, M.D.]

Paul (and James) --

I agree.  It didn't come through the forums with as much of the original 
formatting preserved as I would have preferred.  An alternative view is now 
available here:

http://hcc.musc.edu/research/shared_resources/xml_complex_types_to_cf_structure_notes.cfm

A pointer to this alternative view has been added to the forum thread as well.

-- LBA

Paul Hastings wrote:

> Lawrence B. Afrin, M.D. wrote:
> > posted as an Answer in the ColdFusion Developer Support Forum to a
> > question we originally posted in early February 2005.
> >
> > http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=7&threadid=956508&messid=3520969
>
> that kind of doc stuffed into the forums isn't the easiest thing to
> read. can you make this available someplace else in a more readable
> format? maybe even a PDF?


~|
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:201186
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

Interfacing CFMX to External Web Services Requiring

[Lawrence B. Afrin, M.D.]

An open letter to the ColdFusion development community:

Some of you may recall that my associate, Doug James, and I have been 
struggling for some time to get CFMX to talk to
UDDI servers.  (OK, I'll come clean, it was primarily I (Afrin) who was 
struggling, and I dragged Doug into it and he's
the one who ultimately made the breakthroughs.)  While a CF-to-UDDI interface 
was the specific application we needed to
develop, the broader scope of the problem was how to interface CFMX to external 
web services requiring
complex-within-complex XML documents as input parameters.  Judging by postings 
on this listserv in the last month or
two, others have struggled with this problem, too.

As best as we could tell, the root of the problem was not that CFMX could not 
interface in the manner necessary but
rather that the methods of accomplishing such interfacing have not been 
adequately documented yet.

With help from Tom Jordahl of Macromedia, we learned how to address the broader 
problem and we solved our specific
problem.  We then wrote a document encapsulating what we learned.  We thank Tom 
for his assistance with our problem and
for his critical review of our document.  Tom tells us Macromedia is 
considering placing our document, or some version
thereof, on the Macromedia site as a ColdFusion MX Tech Note, but Tom 
graciously encouraged us to disseminate this
information through independent channels as well.

The document (direct URL below; beware potential wrapping) has been posted as 
an Answer in the ColdFusion Developer
Support Forum to a question we originally posted in early February 2005.

http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=7&threadid=956508&messid=3520969

We have also posted a reference to this document in the ColdFusion MX 7 
LiveDocs (English version only).

Although we obviously cannot provide any warranties as to the accuracy or 
utility of this information, we nevertheless
hope it provides some illumination for our colleagues in the ColdFusion 
development community who are working in this
interesting area.

Sincerely,

Larry Afrin, MD ([EMAIL PROTECTED])
Doug James ([EMAIL PROTECTED])
Hollings Cancer Center
Medical University of South Carolina



~|
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:201113
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: Document Literal WebService with CFMX6.1

[Lawrence B. Afrin, M.D.]

Robert --

You're not alone in facing the problem of how to invoke a web service that 
requires as input a complex-within-complex XML document.  The documentation 
does not cover this and, in my opinion, does not even provide any hints as to 
what direction to head in to resolve this sort of a problem.  I've been banging 
my head against this
for quite some time, and more recently I involved my developer, Doug James, who 
quickly came to share my cephalgia.

Fortunately, with a couple of helpful pointers from Tom Jordahl (the guy at 
Macromedia who, it seems, developed the web services piece of CFMX), Doug 
finally figured out last week how to represent a complex-within-complex XML 
document in CF structure form.  Doug is in the process of touching up his work 
and will be posting a
"how to" soon on cf-talk and on the support forum, and perhaps the LiveDocs as 
well.  If you can't wait until Doug posts, you're welcome to contact him at 
[EMAIL PROTECTED], but he may or may not be able to respond depending on how 
tied up he is at the time.

-- Larry Afrin
   Hollings Cancer Center
   Medical University of South Carolina
   [EMAIL PROTECTED]


~|
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:198552
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: Document Literal WebService with CFMX6.1

[Lawrence B. Afrin, M.D.]

Tom --

Recently you noted in this forum that a CFML Struct can be crafted to 
correspond to any arbitrary XML document required as input to any arbitrary 
(i.e., not necessarily CF-based) web service.  However, it remains unclear how
one can craft a CFML Struct that will be transformed by the CF web services 
engine into both the necessary XML element tags, element subtags, element text, 
and element attributes for services that require such complex input.

Would you please give an example of how to create a CFML Struct that would lead 
to the following XML document being passed as an input argument?

the XML document the web service needs to receive as the input1 arg: -

  subtagtext


--cfml struct build and cfinvoke: -




It would be enormously helpful if you could please fill in the "what goes 
here?" part, as the CF documentation doesn't provide an example for this tricky 
variant of complex-within-complex typing that some of us are facing in
our dealings with foreign web services.

Thank you!

-- Larry Afrin
   Medical University of South Carolina

Tom Jordahl wrote:

> Phil,
>
> 1. Yes, CFMX 6.1 can consume document/literal web services.
>
> 2. You would construct CFML variables that match the XML Schema in the WSDL.
> For instance, a complexType would be created as a CFML Struct.
>
> Tom Jordahl
> Macromedia Server Development
>
> -Original Message-
> From: Phillip Duba [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 01, 2005 10:02 AM
> To: CF-Talk
> Subject: Document Literal WebService with CFMX6.1
>
> All,
>
> I'm having difficulty calling a web service that is of type document-literal
> with a binding definition of  transport="http://schemas.xmlsoap.org/soap/http"/> using CFMX6.1. I guess
> there are two questions:
> 1. Is CFMX6.1 capable of consuming this type of webservice?
> 2. If so, the expectation is an argument of XML-mapped object (I'm using
> HR-XML) using marshalling.
>
> Thanks,
>
> Phil
>


~|
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:197494
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: Case-sensitive Struct keys

[Lawrence B. Afrin, M.D.]

Cedric --

As you said, CF structures don't support case-sensitive keynames.  Alternatives 
might include representing the structure
as a case-sensitive XML document object or, if your structure keynames will 
never be anything other than the single
characters you showed in your example, you could use

test[asc(keyname)] = value;

Thus, test.a would become test[asc('a')] and test.A would become 
test[asc('A')], clearly two different keys.

If the keynames might be longer than a single character, one could imagine many 
other schemes that would hash, or map,
the keynames into unique values to be used as substitute keynames.  For 
example, each character in the keyname could be
replaced by its asc() code translated to a 4-digit hexadecimal string.  (I 
guess 4 hex digits are needed now (instead of
the 2 digits that would have sufficed in the pre-Unicode era) since the Java 
UCS-2 character set used by CF gives values
for asc() up to 65535.)  Another example would be to maintain the set of 
keynames as a simple CF list and then use the
position of the keyname in the list as the substitute keyname in the structure. 
 One would just have to be careful to
search the list with ListFind() instead of ListFindNoCase().

-- Larry Afrin
   Medical University of South Carolina


Cedric Villat wrote:

> So I guess CF doesn't support case-sensitive keys in a structure. For
> example, given the following code:
>
> test = StructNew();
> test.a = 5;
> test.A = 10;
>
> I would have hoped that 2 keys would have been made, "a" and "A", but
> instead only 1 key is made, and has a value of 10. Is there anyway to have
> CF use case-sensitive keys so that I could do something like the above to
> get 2 keys?
>
> Thanks,
> Cedric
>
> 

~|
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:195838
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: Webservices Complex data Types

[Lawrence B. Afrin, M.D.]

Umer --

As inferred by Dave Watts, your problem is that ns:DetailLevelCodeType defines 
a complex datatype, not the simple
strings defined by the other parameters.  Thus, the service you are trying to 
talk to requires you pass a
complex-within-complex datatype, and the reason you are having difficulty 
figuring out how to do this is that ColdFusion
can't do it.

Your problem is exactly the same problem I (and my developer Doug James) have 
been pestering the cf-talk list about over
the last few weeks, though the context for our problem (interfacing CF to UDDI 
web services) has been different from
yours.  Regardless, ColdFusion has no way to map ColdFusion 
structures-within-structures to the type of
element-within-element XML messages required by WSDLs that define 
complex-within-complex structures.  Why Macromedia
hasn't yet provided a way to pass CF XML document objects, rather than just CF 
structures, to web services requiring
complex-within-complex input arguments..well, I don't know.

When you define a ColdFusion structure, the structure's keys become the names 
of XML *attributes* which modify the XML
root element of the web service input argument to which you are feeding the 
structure, and the value of each key becomes
the value of that XML attribute.  For example:




is equivalent to



But, if the WSDL requires this...


  2.0


..ah, now you're stuck, for this is a complex-within-complex definition 
within the WSDL, and there is no way to build
a structure within CFMX 6.x (nor within CFMX 7, as it turns out) that will get 
translated by CF into the above XML
snippet as the Axis engine is building the outgoing SOAP message.  Basically, 
you can't set up a CF
structure-within-structure that'll get mapped to an element-within-element XML 
structure to be sent as the body of the
SOAP message going out to the web service.  And if you try to build the input 
XML message yourself and specify the
resulting XML document object as the input argument in a , CF will 
just auto-translate this document object
into a structure -- which will be in the wrong format compared to how Axis, 
after parsing the WSDL, expects to see the
input argument.

Solution?  Yes, there is one.  Basically, you have to bypass CFMX's Axis web 
services package and all the niceties it
provides you.  You need to build your own SOAP input message, HTTP POST it to 
the target web service, and parse the SOAP
output message, as follows:


  
  


  



Then you can dig deeper into the soapoutputbody XML document object to ferret 
out the return info you're really looking
for.

[Notes: (1) Depending on the web service you're tapping into, you may need to 
define the SOAPAction header as something
other than the pair of double-quote marks shown above.  (2) CFMX 6.0 won't 
suffice for this workaround.  You need 6.1 or
later, because it wasn't until 6.1 that the type="Header" and type="XML" 
attributes were added to the cfhttpparam tag,
and these attributes are critical to making this workaround work.]

The tough part to making this work is figuring out exactly what kind of a SOAP 
input message your target web service
requires.  Once you've got that figured out, doing the cfhttp and wading 
through an xmlparsing of the service's output
is pretty straightforward.

Doug and I recently brought this to Macromedia's attention, so we can hope that 
a 7.0 Updater, or 7.1, will correct this
deficiency sometime within the next year or two.

-- Larry Afrin
   Medical University of South Carolina
   [EMAIL PROTECTED]



~|
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:195707
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: Webservices Complex data Types

[Lawrence B. Afrin, M.D.]

Umer --

As inferred by Dave Watts, your problem is that ns:DetailLevelCodeType defines 
a complex datatype, not the simple
strings defined by the other parameters.  Thus, the service you are trying to 
talk to requires you pass a
complex-within-complex datatype, and the reason you are having difficulty 
figuring out how to do this is that ColdFusion
can't do it.  Couldn't do it in 6.0, couldn't do it in 6.1, and still can't do 
it in 7.0.

Your problem is exactly the same problem I (and my developer Doug James) have 
been pestering the cf-talk list about over
the last few weeks, though the context for our problem has been different from 
yours.  Inferring from the tag names in
your code snippet, your application seems to be some sort of error event 
management system, whereas we needed to
interface ColdFusion to W3C/OASIS-standard UDDI web services to find the 
addresses of certain other web services we need
to talk to.  The standard UDDI WSDL defines a number of complex-within-complex 
inputs which can be represented just fine
as XML messages, but ColdFusion has no way to pass XML documents as complex web 
service input arguments, and ColdFusion
has no way to map ColdFusion structures-within-structures to the type of 
element-within-element XML messages required by
WSDLs that define complex-within-complex structures.

If you play with this enough, you'll discover what Doug and I discovered: when 
you define a ColdFusion structure, the
structure's keys become the names of XML *attributes* which modify the XML root 
element of the web service input
argument to which you are feeding the structure, and the value of each key 
becomes the value of that XML attribute.  For
example:




is equivalent to



This is fine if the WSDL requires an input argument that looks like that.  But, 
if the WSDL requires this...


  2.0


.ah, now you're stuck, for this is a complex-within-complex definition 
within the WSDL, and there is no way to build
a structure within CFMX 6.x (nor within CFMX 7, as it turns out) that will get 
translated by CF into the above XML
snippet as the Axis engine is building the outgoing SOAP message.  Basically, 
you can't set up a CF
structure-within-structure that'll get mapped to an element-within-element XML 
structure to be sent as the body of the
SOAP message going out to the web service.  And don't even think about trying 
to build the message required by the WSDL
directly as a CF XML document object, because, again, the only CF datatype that 
CF knows how to translate properly into
a complex datatype as required by a WSDL is a CF structure, not a CF XML 
document object.  So, if you try something like
this:

2.0")#.>

CF will translate the XML document object produced by the xmlparse() into a 
structure which Axis will reject because the
format of the converted structure doesn't match the format of that 
complex-within-complex input argument as specified in
the WSDL.

Solution?  Yes, there is one.  It's not pretty, but it works.  Basically, you 
have to bypass CFMX's Axis web services
package and all the niceties it provides you.  You need to build your own SOAP 
input message and HTTP POST it to the
target web service, as follows:


  
  


and then you can take the SOAP output message (another XML message) and parse 
it, as follows:


  



Then you can dig deeper into the soapoutputbody XML document object to ferret 
out the return info you're really looking
for.

Note that depending on the web service you're tapping into, you may need to 
define the SOAPAction header as something
other than the pair of double-quote marks shown above.

By the way, CFMX 6.0 won't suffice for this workaround.  You need 6.1 or later, 
because it wasn't until 6.1 that the
type="Header" and type="XML" attributes were added to the cfhttpparam tag, and 
these attributes are critical to making
this workaround work.  With 6.0, there is no way directly in CF to muck with 
the HTTP headers in the ways needed to talk
to a SOAP-compliant web service.

So, yes, there is a workaround to your problem.  Not pretty, but it works.  The 
tough work is on the input side.  You'll
have to do some extra work to figure out exactly what kind of a SOAP input 
message your target web service requires.
Once you've got that figured out, doing the cfhttp and wading through an 
xmlparsing of the service's output is pretty
straightforward.

What fascinates me most about this is that CF has had web services 
functionality "built in" since 6.0 but, as of two
versions later (7.0), still has no way to deal with complex-within-complex web 
service input arguments and thus has no
way "built in" to interact with UDDI services, which are critical to robust 
deployments of web services.  Doug and I
recently brought this to Macromedia's attention, so we can hope that a 7.0 
Updater, or 7.1, will correct this deficiency
sometime within the next year or two.

Please understand I'm not castigating Macromedia.  The fact is, no matter what

Re: Webservices Complex data Types

[Lawrence B. Afrin, M.D.]

Umer --

As inferred by Dave Watts, your problem is that ns:DetailLevelCodeType defines 
a complex datatype, not the simple
strings defined by the other parameters.  Thus, the service you are trying to 
talk to requires you pass a
complex-within-complex datatype, and the reason you are having difficulty 
figuring out how to do this is that ColdFusion
can't do it.  Couldn't do it in 6.0, couldn't do it in 6.1, and still can't do 
it in 7.0.

Your problem is exactly the same problem I (and my developer Doug James) have 
been pestering the cf-talk list about over
the last few weeks, though the context for our problem has been different from 
yours.  Inferring from the tag names in
your code snippet, your application seems to be some sort of error event 
management system, whereas we needed to
interface ColdFusion to W3C/OASIS-standard UDDI web services to find the 
addresses of certain other web services we need
to talk to.  The standard UDDI WSDL defines a number of complex-within-complex 
inputs which can be represented just fine
as XML messages, but ColdFusion has no way to pass XML documents as complex web 
service input arguments, and ColdFusion
has no way to map ColdFusion structures-within-structures to the type of 
element-within-element XML messages required by
WSDLs that define complex-within-complex structures.

If you play with this enough, you'll discover what Doug and I discovered: when 
you define a ColdFusion structure, the
structure's keys become the names of XML *attributes* which modify the XML root 
element of the web service input
argument to which you are feeding the structure, and the value of each key 
becomes the value of that XML attribute.  For
example:




is equivalent to



This is fine if the WSDL requires an input argument that looks like that.  But, 
if the WSDL requires this...


  2.0


ah, now you're stuck, for this is a complex-within-complex definition 
within the WSDL, and there is no way to build a
structure within CFMX 6.x (nor within CFMX 7, as it turns out) that will get 
translated by CF into the above XML snippet
as the Axis engine is building the outgoing SOAP message.  Basically, you can't 
set up a CF structure-within-structure
that'll get mapped to an element-within-element XML structure to be sent as the 
body of the SOAP message going out to
the web service.  And don't even think about trying to build the message 
required by the WSDL directly as a CF XML
document object, because, again, the only CF datatype that CF knows how to 
translate properly into a complex datatype as
required by a WSDL is a CF structure, not a CF XML document object.  So, if you 
try something like this:

2.0")#.>

CF will translate the XML document object produced by the xmlparse() into a 
structure which Axis will reject because the
format of the converted structure doesn't match the format of that 
complex-within-complex input argument as specified in
the WSDL.

Solution?  Yes, there is one.  It's not pretty, but it works.  Basically, you 
have to bypass CFMX's Axis web services
package and all the niceties it provides you.  You need to build your own SOAP 
input message and HTTP POST it to the
target web service, as follows:


  
  


and then you can take the SOAP output message (another XML message) and parse 
it, as follows:


  



Then you can dig deeper into the soapoutputbody XML document object to ferret 
out the return info you're really looking
for.

Note that depending on the web service you're tapping into, you may need to 
define the SOAPAction header as something
other than the pair of double-quote marks shown above.

By the way, CFMX 6.0 won't suffice for this workaround.  You need 6.1 or later, 
because it wasn't until 6.1 that the
type="Header" and type="XML" attributes were added to the cfhttpparam tag, and 
these attributes are critical to making
this workaround work.  With 6.0, there is no way directly in CF to muck with 
the HTTP headers in the ways needed to talk
to a SOAP-compliant web service.

So, yes, there is a workaround to your problem.  Not pretty, but it works.  The 
tough work is on the input side.  You'll
have to do some extra work to figure out exactly what kind of a SOAP input 
message your target web service requires.
Once you've got that figured out, doing the cfhttp and wading through an 
xmlparsing of the service's output is pretty
straightforward.

What fascinates me most about this is that CF has had web services 
functionality "built in" since 6.0 but, as of two
versions later (7.0), still has no way to deal with complex-within-complex web 
service input arguments and thus has no
way "built in" to interact with UDDI services, which are critical to robust 
deployments of web services.  Doug and I
recently brought this to Macromedia's attention, so we can hope that a 7.0 
Updater, or 7.1, will correct this deficiency
sometime within the next year or two.

Please understand I'm not castigating Macromedia.  The fact is, no matter what 

CF syntax for representing an XML document as a structure?

[Lawrence B. Afrin, M.D.]

Howdy --

I'm close to solving my UDDI problem, but I've got a syntax problem with 
structures that's stumping me.

The UDDI WSDL/XSD (see excerpts below) says the XML snippet below is a valid 
API call.  Datatype-wise, per the WSDL/XSD,
it's a complex datatype () within another complex datatype 
().  Only the string within the
 element is a simple string datatype.  Now, according to the CF docs, 
the only way to pass a complex datatype
from CF to a web service is to represent it in CF as a structure.  So, I have 
to transform this:


  Microsoft


into a CF structure that I'm going to pass as an input argument to the UDDI web 
service in my cfinvoke.  I discovered
that this structure code:

find_business = StructNew();
find_business.generic = "2.0";

properly defines the attribute "generic" in the outermost complextype.  So it's 
clear that what comes after the dot is
the name of an attribute.  But  isn't an attribute; it's a sub-element. 
 What syntax do I use to define within
the structure this inner "name" complextype element?  Doing this:

find_business.name = "Microsoft";

clearly isn't going to work, as that's just the equivalent of inserting another 
attribute, name="Microsoft", within the
find_business tag.  This doesn't work, either:

find_business.name = StructNew();

since then you're stuck with this syntax question:

find_business.name.whatwouldIputhere = "Microsoft";

So: Is it simply not possible in CF to represent the above 
complex-within-complex XML document as a CF structure?

And one other quick question: the UDDI WSDL specifies document style, not rpc 
style, for all method calls.  Example:



Is there a difference between these two styles in how you have to represent 
input arguments of complex datatype?  For
example, do I pass a complex input argument as a CF structure when the WSDL 
uses document style vs. passing it as an XML
document object when the WSDL uses rpc style?

-- Larry Afrin
   Medical University of South Carolina

UDDI v2 WSDL/XSD excerpts:

Note that the UDDI WSDL and XSD define both "find_business" and "name" as 
complex datatypes:


  
  
  
  
  
  
  
  


  
  
  
  
  
  
  



~|
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:193790
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

Tricky SOAP input problem; need help with cfinvoke syntax

[Lawrence B. Afrin, M.D.]

Hello --

I have been struggling mightily for the past week or so trying to build a CF 
app that will talk to the Microsoft and IBM
UDDI web services registries.  I finally got to the point where I could 
"manually" compose the necessary SOAP input,
talk to the UDDI server via cfhttp, and parse the SOAP output.  For example, 
the following code gets from the Microsoft
UDDI registry a list of all Microsoft-related businesses in that registry:

http://uddi.microsoft.com/inquire";>
  
  



However, as cfinvoke is the "preferred" method in CF for communicating with web 
services, I'd rather use that than my
"lower level" cfhttp method.  However, there's a problem in doing so.  The 
cfinvoke should look like this:

http://yukon.musc.edu/hcc/research/clinical/modified_Microsoft_Public_UDDI_Registry.wsdl";
  method = "find_business"
  body = #UDDI_API_find_business_input_message#
  returnVariable="foo">


where UDDI_API_find_business_input_message should be equivalent to this XML 
message:


  AACI


so that the SOAP message body that ultimately gets generated by CF for POSTing 
via HTTP to the UDDI server is as shown
above in my cfhttp example, BUTI cannot figure out the right way to "set 
up" UDDI_API_find_business_input_message.
Everything I've tried so far results in CF complaining that I'm providing it an 
invalid argument type.  I've tried the
following:

1.   Simple string:

http://yukon.musc.edu/hcc/research/clinical/modified_Microsoft_Public_UDDI_Registry.wsdl";
  method = "find_business"
  body = 'AACI'
  returnVariable="foo">


2. XML document object:


AACI

http://yukon.musc.edu/hcc/research/clinical/modified_Microsoft_Public_UDDI_Registry.wsdl";
  method = "find_business"
  body = #msg#
  returnVariable="foo">


3. And sort of a combination of the above two methods:

http://yukon.musc.edu/hcc/research/clinical/modified_Microsoft_Public_UDDI_Registry.wsdl";
  method = "find_business"
  body = #xmlparse('AACI')#
  returnVariable="foo">


All three of the above ways caused CF to complain that I was causing an 
"argument type mismatch".  (The specific error
message is: Could not perform web service invocation "find_business" because 
java.lang.IllegalArgumentException:
argument type mismatch.)

I read in various on-line resources that complex input types (which this 
certainly is) should be passed into web
services as structures which have been returned by cfcomponents which defined 
one cfproperty for each element of the
structure.  So I thought about setting up the following:

msg.cfc:


  


find_business_struct.cfc:


  


and then doing this:

http://yukon.musc.edu/hcc/research/clinical/modified_Microsoft_Public_UDDI_Registry.wsdl";
  method = "find_business"
  body = #msg#
  returnVariable="foo">


BUTthe problem is that the 'generic="2.0"' and 
'xmlns="urn:uddi-org:api_v2"' attributes to the 
element are required per the UDDI spec.  And I don't see that there's any way 
to attach attributes to elements of a CF
structure, regardless of whether it's created as a StructNew() or created via 
cfcomponents.

Any CF syntax gurus know the trick to this?

One final note: the WSDL I reference in the above cfinvoke examples is a 
locally modified version of the WSDL used by
the Microsoft and IBM UDDI registries because the WSDL used natively by these 
registries does not contain enough
information for CF to find the specific UDDI registry to be queried.  Both 
registries use the standard version 2.04 UDDI
WSDL at http://uddi.org/wsdl/inquire_v2.wsdl, but this WSDL intentionally omits 
any actual port information (i.e.,
specific UDDI server addresses) because that information is totally independent 
of the UDDI communication protocol
itself (which is described in the WSDL).  So, to try to get this WSDL to work 
with cfinvoke, I downloaded the standard
UDDI WSDL to my local system and added the following paragraph (you can see it 
at the bottom of my modified WSDL
referenced above) so that cfinvoke would know exactly where to POST (via HTTP) 
the SOAP query it generates:


  
http://uddi.microsoft.com/inquire"; />
  


So all I need to figure out is how to properly build a cfinvoke input argument 
so that in turn cfinvoke will build the
SOAP query shown above in my cfhttp example.

I'd greatly appreciate any insights anybody can offer.

-- Larry Afrin
   Medical University of South Carolina
   [EMAIL PROTECTED]


~|
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:193244
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 help re: CFMX web services choking on MS Test UDDI Registry WSDL

[Lawrence B. Afrin, M.D.]

Howdy --

I'm trying to get CFMX web services to talk (cfinvoke) to the Microsoft Test 
UDDI Registry.  Step 1, of course, is
getting an error-free WSDL back from the remote service.  I can load the 
following page in IE or Firefox and I get a
nice XML formatting of the returned WSDL:

http://test.uddi.microsoft.com/inquire.asmx?WSDL

but when I run the following CF code:

http://test.uddi.microsoft.com/inquire.asmx?WSDL";
  method = "find_business"
  name = "Microsoft"
  returnVariable="foo">



I get a complicated CF error message that I ultimately figured out was a 
complaint about the returned WSDL.  It seems
that the following line occurs about every tenth line, starting at line 617, 
for about 11 times altogether, in the WSDL
returned by the MS Test UDDI Registry:

  

The CF error message complains repeatedly (11 times) about the four quote-marks 
in a row, says these are all syntax
errors.  So it blows the cfinvoke and I can't get the info I need out of the 
target UDDI registry.  I don't know whether
the four quote-marks in a row is allowable WSDL/XML syntax or not, but that's 
what the MS UDDI server is putting out,
and CF is complaining, and CF's complaint means I can't do any dealings with 
the Microsoft Test UDDI Registry.

Anybody know a way around this?  Is there some way I can tell CF web services 
to keep on going with the cfinvoke even if
the WSDL returned by the remote service looks bad?

For that matter, I'm also having trouble getting any WSDL at all out of the 
main Microsoft UDDI Registry
(http://uddi.microsoft.com/inquire.asmx?WSDL just gets me the same promo page 
that http://uddi.microsoft.com/inquire
gets me), and I can't even find the right addresses to get the WSDL out of 
IBM's Business UDDI Registry or Test Business
UDDI Registry.  (I've tried www.ibm.com/services/uddi/inquiryapi?WSDL and a 
bazillion variations on this theme, and I
get nowhere.)  My problem with Microsoft's Test UDDI Registry might not be the 
showstopper it's looking to be if I could
at least talk to any of the other UDDI registries that are out there.

Can anybody help?

-- Larry Afrin
   Medical University of South Carolina



~|
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:192489
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

Simulated logon failing, unclear reason

[Lawrence B. Afrin, M.D.]

Hello --

I have a need to automatically retrieve a document stored in a secure
remote site.  Thus, I need to simulate a logon to the remote site (which
is driven by ASP.NET, but that shouldn't be relevant). This should be
easy as pie: do a cfhttp POST to simulate a logon, then do a cfhttp GET
to retrieve the document I need.  But it's not working (and it's not
even giving me any error indications), and I can't figure out why.

The logon page my browser is retrieving from the remote site contains
the following login form code:


id="IndividualLogon" name="IndividualLogon">

Please enter your SWOG Roster ID number and Password:
SWOG Roster ID number:

id="Username">
Password:

id="Password">



(I've stripped out a bunch of table and other formatting code so you
could quickly see the bare essence of the form.)  Seems like a
straightforward logon form.  User ID, password, submit.  Simple, right?

(Well, almost.  Turns out the remote site is also returning an
ASPSESSIONID cookie along with this form.  This is the only cookie
the remote site returns.)

So I coded a template on my ColdFusion server like this:






#left(swogsessioncookie,find("=",swogsessioncookie)-1)#>

#mid(swogsessioncookie,find("=",swogsessioncookie)+1,200)#>




value="known-valid-userID">

value="known-valid-password">




When I enter my user ID and password into the login form in my browser,
I get back a normal post-logon congratulatory page.

But when I run the above template, the cfhttp.fileContent that I get
back from the POST is the same logon page I get back from the GET, with
no error messages or any other helpful indicators.  It's as if the
server isn't even seeing the user ID and password that my CF server is
POSTing and instead thinks I'm just repeating the original GET.

I've done bunches of cfdumps, and I know I'm parsing the cookie
properly, so CF should be sending back the ASP session ID OK.

I also tried supplying a normal IE6 userAgent header in both cfhttp's,
to no avail.

I'm at my wit's end.  Why might the remote site not be happy with the
logon I'm POSTing?  Any ideas?  Not that it should make a difference,
but my CF server is 6.0 on Linux.

-- Larry Afrin
   Medical University of South Carolina
   [EMAIL PROTECTED]
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Need help connecting CFMX to IBM/Microsoft UDDI UBR nodes

[Lawrence B. Afrin, M.D.]

Howdy --

I'm trying to figure out how to get my CFMX (6, not 6.1, if that makes any difference) installation to go rooting around
through IBM's and Microsoft's UDDI Business Registry nodes to find the access points for a service of a business which a
colleague has registered.  I've spent many hours now poring over tons of documentation and hacking around, but I'm
totally stuck on the following four points:

(1) I can't get CFMX to like the WSDL that comes back from Microsoft's test registry
(http://test.uddi.microsoft.com/inquire.asmx/WSDL).  I have a simple invocation:


  method = "FindBusiness"
  name = "%businessnamehere%"
  returnVariable="foo">

and this is what it gets me:

[]coldfusion.jsp.CompilationFailedException: Errors reported by Java compiler: Found 11 syntax errors in
"/opt/coldfusionmx/stubs/WS-761256755/uddi_org/api_v2/InquireMessagesSoapStub.java": 557. _call.setSOAPActionURI();
<> *** Syntax:
Unexpected symbol ignored 586. _call.setSOAPActionURI(); <> *** Syntax:
Unexpected symbol ignored 615. _call.setSOAPActionURI(); <> *** Syntax:
Unexpected symbol ignored 644. _call.setSOAPActionURI(); <> *** Syntax:
Unexpected symbol ignored 673. _call.setSOAPActionURI(); <> *** Syntax:
Unexpected symbol ignored 702. _call.setSOAPActionURI(); <> *** Syntax:
Unexpected symbol ignored 731. _call.setSOAPActionURI(); <> *** Syntax:
Unexpected symbol ignored 760. _call.setSOAPActionURI(); <> *** Syntax:
Unexpected symbol ignored 789. _call.setSOAPActionURI(); <> *** Syntax:
Unexpected symbol ignored 818. _call.setSOAPActionURI(); <> *** Syntax:
Unexpected symbol ignored 847. _call.setSOAPActionURI(); <> *** Syntax:
Unexpected symbol ignored .

(2) I can't for the life of me figure out what address gets me the WSDL for Microsoft's production registry.  You'd
think that http://uddi.microsoft.com/inquire.asmx?WSDL would do the trick, a la the situation with the test registry,
but it doesn't.

(3) And that's just Microsoft.  I can't get the WSDL for either the test or production site at IBM.  It oughta be
something like http://uddi.ibm.com/inquiryAPI or http://test.uddi.ibm.com/inquiryAPI, but no matter what I try, I just
keep getting redirected to some UDDI overview page at ibm.com.  On rare occasions I've managed some twist on the URL
which gets me a SOAP message containing some error text saying the server only responds to POST messages, but that's
kind of ridiculous.  I shouldn't have to POST just to GET the WSDL.

I've Googled, I've searched IBM's extensive docs, I've searched MSDN, I've searched a bunch of sites and tutorials that
claim to explain UDDI, I've searched the CF forums, and I'm stuck -- just plain stuck.

Is *nobody* in the CF community doing anything with UDDI?

Anybody have any ideas?

-- Larry Afrin
   Medical University of South Carolina
   [EMAIL PROTECTED]
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Can cftree call my function on item selection or mouseover?

[Lawrence B. Afrin, M.D.]

Howdy --

I'm tellin' ya', mah users er nuthin' but trubble.  :-)

I go to all the effort of giving them a nice cftree that gives them access to a web-based document/image library they
wanted me to let 'em build, and the first thing outa their mouths is that they want to see thumbnails when mousing over,
or clicking on, each image leaf in the tree.  So, obviously, I need access to an onClick() (or preferably onMouseOver())
type of event in association with each cftreeitem.  Except such access isn't supported by cftreeitem, as far as I can
tell.  Drat.  So much for the easy way out.

So I went hunting through the CF forums, and I quickly found an incredibly rich cftree alternative called Tigra Tree
Menu Pro by "U.S./Ukrainian" Soft Complex (http://www.softcomplex.com), and it looks like it'll give me the event access
I need in order to implement what them dumb users er askin' fer, but before I head over to Paypal to plunk down my $29,
I figured it would be worth checking cf-talk to see if anybody knows of any undocumented, or poorly documented,
cftreeitem magic that'll solve my problem, or any other cftree alternative that might also solve my problem.  I checked
all the free cftree alternatives I could find referenced in the CF forums, but none of them support event access.  I
guess I could always take one of the freebie cftree alternatives I found and modify it to support event access, but by
the time I finish such a mod, I will have spent far more than $29 of my time.

Any ideas?

-- Larry Afrin
   Medical Univ. of S.C.
   [EMAIL PROTECTED]


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: Upload file from passed form field doesn't work.

[Lawrence B. Afrin, M.D.]

Are you sure you've included the required parameter

enctype="multipart/form-data"

in your  tag?

I've been doing this for years and I always forget that, then waste a few 
minutes scratching my head as to why my cffile action="upload" doesn't work 
until I suddenly remember this parameter that I otherwise have never needed 
to include in my  tags.

Good luck.

-- Larry Afrin, M.D.
   Medical University of South Carolina
   [EMAIL PROTECTED]

--On Tuesday, September 23, 2003 2:01 PM -0400 Ryan Roskilly 
<[EMAIL PROTECTED]> wrote:

> I have a form where users enter there data, including input type="file".
> This page post to a preview page where the passed form fields are then
> inserted into hidden form fields. If the user is happy with the preview,
> they then hit save and the data inserts into the db. The problem is that
> on the action page. I get an error saying
>
> The form field specified in the CFFILE tag (EMAIL_DOCUMENT) does not
> contain an uploaded file
>
> Even though this cffile is wrapped in
>
> 
>
> Basically it sounds like cffile cannot upload passed documents.
>
> Debug does display: EMAIL_DOCUMENT=C:\WINNT\TEMP\ACF5979.tmp
>
> Any ideas on if it is even possible to upload passed references to a file?
>
> 
~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138164
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm

Need confirmation: does secure cfldap work on CF5 for Linux?

[Lawrence B. Afrin, M.D.]

Howdy --

I've already got this working for CFMX on Linux, but now I need to take
a step backwards (don't ask) and connect a CF5 Pro installation on a
RedHat 7.1 Linux machine to an OpenLDAP secure LDAP server.

Following the instructions in
,
I obtained the secure LDAP server's certificate into my Netscape 4.x
installation on my Windows NT workstation and then transferred my
Netscape cert7.db, key3.db, and secmod.db files to the
/home/coldfusion/ldap directory on the Linux machine using binary-mode
ftp.  After the transfer, I made sure the .db files had the same
permissions (rw-r--r--), owner (root), and group (bin) as the
filter.conf file that was already there.

I then put together a small test template containing a cfldap command as
follows:



I ran the template, and unfortunately got a CF error message saying
"LDAP SSL connection initialization failed."

Ultimately, I found this thread in the ColdFusion forums at
webforums.macromedia.com:

http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=6&threadid=205055

It appears that I'm experiencing the same problem that malmeid first
reported in June 2001, and which Gregory Gauthier, Sr. Technical Support
Engineer at Macromedia confirmed as a bug in CF5 for Linux.  Subsequent
messages in that thread, dating as late as April 2002, suggest that the
bug still had not been fixed by that date.

I cannot find anything in the ColdFusion forums, or in the Macromedia
support material, indicating that this bug was ever fixed.

Before I waste any more time on this, I need to know whether this bug
was ever fixed.  Is it indeed possible for CF5 on Linux to connect to a
secure LDAP server?  If so, how do I get my hands on the patch for my
CF5 Linux installation?

Thank you very much for any information you can provide.

Sincerely,

Larry Afrin, M.D.
Associate Professor of Medicine, Division of Hematology/Oncology
Director of Information Technology, Hollings Cancer Center
Medical University of South Carolina
[EMAIL PROTECTED]


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

Host with the leader in ColdFusion hosting. 
Voted #1 ColdFusion host by CF Developers. 
Offering shared and dedicated hosting options. 
www.cfxhosting.com/default.cfm?redirect=10481

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Does Updater 3 solve the structure-within-structure web services problem?

[Lawrence B. Afrin, M.D.]

Howdy --

Does anybody know if Updater 3, which upgrades the Axis package to 1.0, resolves the 
existing problem CFMX's web
services functionality has with parsing/interpreting return values (from remote web 
services) which contain structures
("complex" data type) within structures?

I've reviewed the 1.0 documentation on the Axis site but can't determine the answer to 
this question.

-- Larry Afrin
   Medical University of South Carolina
   [EMAIL PROTECTED]


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

CFMX problem: undeleteable datasource?

[Lawrence B. Afrin, M.D.]

Howdy --

We've been preparing to upgrade our CF5-Linux production platform to CFMX-Linux, and 
on our test server where we've been
testing the upgrade process, we've run into a curious snag:

Our test CF5-Linux platform included an ODBC datasource -- call it "goober" -- which 
was using the Merant Text Driver.

Following the application of the CFMX Pro upgrade, we found that the new 
JDBC-equivalent "goober" is listing in the CF
Administrator as having a JDBC driver type of "ODBC socket".  Rather curious, since 
"ODBC socket" isn't one of the JDBC
drivers that comes with CFMX-Linux Pro (you only get SQL Server and MySQL).

(Also, not surprisingly,  an attempt to verify a connection to "goober" is failing, 
but we don't care about that at this
point.)

Furthermore, attempts to delete the "goober" datasource simply result in the following 
error:

-
An exception occurred when invoking an external process.
The cause of this exception was that: java.io.IOException: 
\opt/coldfusionmx/db\slserver52\admin\swcla.exe: not found.

The Error Occurred in /home/httpd/html/CFIDE/administrator/datasources/_sl52del.cfm: 
line 10
Called from /home/httpd/html/CFIDE/administrator/datasources/odbcsocket.cfm: line 16
Called from /home/httpd/html/CFIDE/administrator/datasources/odbcsocket.cfm: line 760
Called from /home/httpd/html/CFIDE/administrator/datasources/_sl52del.cfm: line 10
Called from /home/httpd/html/CFIDE/administrator/datasources/odbcsocket.cfm: line 16
Called from /home/httpd/html/CFIDE/administrator/datasources/odbcsocket.cfm: line 760
-

We also tried to delete the "goober" datasource by deleting its XML declaration in
.../servers/default/SERVER-INF/jrun-resources.xml, but regardless of whether we 
restarted the CFMX server or even
rebooted the whole machine, this change didn't seem to affect the continued listing of 
"goober" in the Administrator,
Datasources page.  We tried to figure out (by searching the system and searching JRun 
and JDBC documentation) where else
within the Linux filesystem the JDBC datasources are defined or listed (i.e., where 
does the CF Administrator,
Datasources page get its listing of datasources from?), but it's a mystery to us.

Anybody have any ideas about how we can get rid of "goober"?  It'd be kinda silly to 
have to pay MM the $500 incident
support fee to get a fix for their own upgrade-process bug.

TIA...

-- Larry Afrin
   Medical University of South Carolina
   [EMAIL PROTECTED]


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

New CF5 Linux installation can't connect to SQL Server

[Lawrence B. Afrin, M.D.]

Howdy --

We have CF5Pro working fine on one of our Linux machines, and in the process of 
preparing for an upgrade to MX, we've
installed CF5 (from the same installation package) on another one of our Linux 
machines.  (This latter installation will
be a testbed for testing the upgrade to MX before we upgrade our production machine to 
MX.)

The problem is, we can't get the test machine to connect to any of the databases on 
our SQL Server machine.  The
production machine has many ODBC datasources that connect fine to various databases on 
the SQL Server machine, but I
can't establish an ODBC datasource on the test machine that will connect successfully 
to any database on the SQL Server
machine.

Other info:

(1) All three machines are on the same Class C subnet.
(2) Each of the three machines can ping the other two machines.
(3) Each of the Linux machines can telnet to the other.  Both can telnet to the SQL 
Server machine on port 1433.
(4) The /home/coldfusion/bin/start files are the same on the two Linux machines.
(5) The /home/coldfusion/odbc/odbc.ini files are the same on the two Linux machines.
(6) The /home/coldfusion/lib/CFmsss16.so Merant SQL Server driver files are the same 
on the two Linux machines.
(7) The test machine not only can't establish an ODBC connection to the SQL Server on 
the production machine but also
can't establish ODBC connections to a couple of other SQL Servers we have on other 
machines on the same subnet.
(8) The test machine *can* establish ODBC connections to files on the test machine 
using the Merant Text Driver and the
Merant dBase/FoxPro driver.  I haven't been able to test yet whether the test machine 
can establish an ODBC connection
to a MySQL database on a remote machine.

Any thoughts about why the test machine can't establish an ODBC connection to a remote 
SQL Server database?

-- Larry Afrin
   Medical University of South Carolina
   [EMAIL PROTECTED]


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Re: How to disable MIB Component?

[Lawrence B. Afrin, M.D.]

Jamie --

Regarding disabling the MIB, perhaps a neuralyzer would do the trick.

Sorry, couldn't resist.  :-)

-- LBA

Jamie Jackson wrote:

> I need to either:
>  *disable the CF MIB component entirely
>  *or tell the component the correct URL for getmetricdataXML.cfm and
> serverinfo.cfm (currently, it's looking in the wrong place and filling
> up my logs).
>
> If you could tell me how to do _either_ of these things, I would
> appreciate it.
>
> Thanks,
> Jamie
>
> 
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Access on CFMX Linux?

[Lawrence B. Afrin, M.D.]

David --

Ignoring, for the moment, the raging battle between the purists and practicalists as 
to what distinguishes a "real" database :-) , there are at least
three ways I can think of to solve your problem:

(1) Buy a Linux ODBC driver for Access.  I don't know if such a beast exists; maybe 
Merant has one.

(2) There's a product (sorry, can't remember who makes it or what it costs) for Linux 
called an ODBC bridge that will let you set up an ODBC datasource
on your Linux box that talks to an ODBC datasource on a Windows box.  So you could 
install the bridge on your Linux host, then on the Windows machine
define an ODBC datasource pointing to the Access database, then on the Linux machine 
define an ODBC datasource pointing through the bridge to the
datasource you just defined on the Windows machine.

(3) If you have a SQL Server 2000 available somewhere (SQL Server 7 may even be able 
to do this, I can't remember), then your problem may be solvable
without having to purchase any additional third-party products.  On the SQL Server, 
use Enterprise Manager or the appropriate SQL commands to define a
Linked Server pointing to the Access database in one of two ways: either using the OLE 
DB Provider for Jet databases (Access, dBase, FoxPro, etc.), or
using the OLE DB Provider for ODBC Datasources (which of course would also require 
that you establish an ODBC datasource on that SQL Server machine that
points to the Access database).  Once you have this Linked Server set up, you can use 
CF Linux's (either Pro or Enterprise) SQL Server ODBC driver to set
up an ODBC datasource to the SQL Server.  Then, through that datasource, using the 
appropriate four-part SQL syntax for references to tables addressed
through Linked Server definitions, you can write cfqueries on your Linux machine that 
CF will pass to Linux ODBC, which will pass to the SQL Server,
which will pass to Access.  Sounds (and, admittedly, is) positively Rube Goldbergish, 
but when your budget for additional software purchases is zero and
you happen to have a SQL Server 2000 lying around, I can say from experience that it 
definitely works.  Note also that because the Windows ODBC driver
for Jet databases will let you define a datasource pointing at any machine on the 
network (be sure to use UNC naming conventions in specifying the
filename of the Access database; do not use a mapped drive letter), the Access 
database doesn't even necessarily have to reside on the same machine as
the SQL Server.

-- LBA


David Siew wrote:

> Hi all,
>
> Sorry. I havent got experience with CF on Linux.
>
> Is there anyway that I can set up a MS Access database as a datasource
> on a Linux server installed with CFMX? Any advise is much appreciated.
>
> Thank you and regards
> David
>
> 
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SOT: page breaks

[Lawrence B. Afrin, M.D.]

Short answer?  You can't.  In fact, as my own quest for an answer to this 
problem revealed a few weeks ago, though you're on the right track with the 
page-break-inside: avoid directive, there are few browsers out there that 
recognize it, and no browsers that actually implement it correctly 
(including the latest from Netscape and Opera).

Your best alternative may be to put a page-break-before:always directive 
before you launch into your table, so your table always starts at the top 
of the printed page.

-- LBA

--On Tuesday, July 09, 2002 1:00 PM -0400 Brad Roberts <[EMAIL PROTECTED]> 
wrote:

> Anyone know how I can avoid page breaks within a table?  The following
> isn't working:
>
> 
>   
>   ...
>   
> 
>
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Monitor active requests on CF Linux?

[Lawrence B. Afrin, M.D.]

Howdy --

Does anybody know of a method within CF, or a third-party tool, whereby I can monitor 
or otherwise determine which Linux
process (or which Windows process, for that matter) is handling which active CF 
request?

Some of my developers occasionally write code which runs away, hangs, or otherwise 
fails to terminate as expected.  When
I do a "ps -Af | fgrep coldfusion" on the Linux box hosting my CF 5 Pro server, I 
usually get back at least a couple
dozen CF processes, all of them of course owned by "nobody", and I don't have a clue 
which process is the troublesome
one that needs to be killed, so I usually don't have any choice but to be rude to 
everybody else who's using the site
and do a .../bin/stop and .../bin/start on the whole CF server.

Ick.

What I want, I guess, is sort of a "ps -coldfusion" that tells me, for each CF 
process, which .cfm it's executing and
which IP address made the request.  Then I can easily identify the troublemaker and 
issue a "kill" (unless there's some
more graceful way to do this that I don't know about).

I only have CF Pro, but from what I can see from the docs about the performance 
monitoring tools available with CF
Enterprise, it still doesn't look like I would get the level of detail that I need 
even if I upgraded.

I tried running .../bin/cfstat for the heck of it, to see what it would output, but 
all it said was "Couldn't get access
to shared memory area.  Perhaps CFAS is not running on this machine?  Perhaps 
performance monitoring is not enabled from
the CFAS administrator?  Perhaps CFAS was not restarted after enabling performance 
monitoring?"  This, in spite of the
fact that CFAS is running, performance monitoring is enabled, and CFAS was restarted 
after PM was enabled.

If anybody knows of a solution, I'd sure appreciate a pointer.  Thanks!

-- LBA

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: suwyn.com's SOAP Adhesion limited to Windows CF installations?

[Lawrence B. Afrin, M.D.]

Matt --

Thanks for pointing this out.  I did some more reading about MX on Macromedia's site 
after you pointed this out, and it looks like cfinvoke will do what
I need.  I have been intending to upgrade to MX, but the new fiscal year and new 
budget dollars aren't available to me until Monday.  :-)

-- LBA

Matt Liotta wrote:

> Why don't you just make use of Apache Axis? It's Java based, open
> source, backed by IBM and Macromedia, and is embedded in CFMX.
>
> -Matt
>
>
> > -----Original Message-
> > From: Lawrence B. Afrin, M.D. [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, June 25, 2002 7:37 PM
> > To: CF-Talk
> > Subject: suwyn.com's SOAP Adhesion limited to Windows CF
> installations?
> >
> > Howdy --
> >
> > As some of you may have seen from my posting yesterday, I'm trying to
> > build a SOAP client that's a bit more robust than
> > what cfdev.com's CFX_SOAP supports.  I found suwyn.com's SOAP Adhesion
> > package that looked like it would fit the bill,
> > but upon reviewing it tonight, if I'm reading the code correctly, it
> seems
> > to me that it's dependent on the Microsoft
> > XML package and therefore can't be used on Linux CF installations.
> Has
> > anybody figured out how to use it with a Linux
> > CF installation?
> >
> > -- Larry Afrin
> >Medical University of South Carolina
> >[EMAIL PROTECTED]
> >
> >
> >
> 
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Splitting apart a long form for printing

[Lawrence B. Afrin, M.D.]

Tony et al. --

Has anybody found a browser yet that actually implements "page-break-inside:avoid" 
properly?  Opera claims to, but it's
failed in my testing.  Netscape's docs claim that since 6.0 it's handled this, but it, 
too, has failed on my testing,
all the way up to 7.0PR1.  And Microsoft's docs clearly show IE doesn't support this 
directive yet.

-- Larry Afrin
   Medical University of South Carolina
   [EMAIL PROTECTED]


Tony Weeg wrote:

> using css:
>
> 
>
> mailto:[EMAIL PROTECTED]]
> Sent: Monday, June 24, 2002 4:31 PM
> To: CF-Talk
> Subject: Splitting apart a long form for printing
>
> I have a long long credit application form that clients need to be able
> to print and fax to lending companies, what I need to do is be able to
> print it as say page1, page2 page3 while maintaing a format of sorts.
> How can I accomplish this?
>
> Douglas Brown
> Email: [EMAIL PROTECTED]
>
> 
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Connecting to DB2 without Enterprise Edition

[Lawrence B. Afrin, M.D.]

Andrew --

I've done this sort of thing before, though not with DB2.  Still, the approach should 
be the same and follows along the
lines you've already hinted at.

Fundamentally, you have to have some way of accessing DB2.  If you don't have a native 
driver for DB2, then you can
still make it work as long as you can (1) connect CF to Access and (2) connect Access 
to DB2.

All you have to do is set up an Access database whose tables are nothing but "links" 
to the real DB2 tables (File, Get
External Data, Link Tables, select File Type "ODBC Data Sources", select the data 
source you've set up to connect to the
DB2 database, then select the tables).  Then set up a datasource so that CF can talk 
to that Access database.  At that
point you can execute a CFQUERY against that datasource, and the SQL you specify will 
be interpreted by the Access "Jet"
engine but the tables the SQL is operating on will actually be the DB2 tables.

The other way you can do this, without hardcoding the linked tables into the Access 
database, is to simply send to the
Access database a SQL command with the variant tablename syntax that includes all the 
ODBC parameters you need to drill
through to the datasource you're interested in.  Something like this:

insert into 
[ODBC;DSN=datasourcename;SERVER=dbmsservername;UID=userid;PWD=password;DATABASE=dbname].tablename
values(1,2,3)

More recently, I've had to figure out how to get from my CF Pro (Linux) installation 
to a Sybase database without either
upgrading to Enterprise Edition or buying the pricey Merant drivers.  A bit of a 
challenge since I only had Sybase's
Open Client for the Windows platform and CF Pro for Linux only comes with ODBC drivers 
for SQL Server (our primary
database), mySQL, dBase/FoxPro, and postgreSQL, but I eventually figured out how to 
use SQL Server's "Linked Server"
capability (sort of akin to Access' "linked tables" feature) to make it all come 
together.

Have fun!

-- LBA


Andrew Peterson wrote:

> Well, we just received our version of CF MX - only our purchasing dept
> screwed up and got us the Pro version instead of the Enterprise version.
> According to the docs, you can connect to DB2 using native drivers in the
> Enterprise version, but there is no mention of connecting to DB2 using the
> Pro version. I was wondering if there was a way to connect to DB2 using Pro
> by accessing it in some way other than the native drivers found in
> Enterprise. I figure there must be a way, since our internal users can
> connect to DB2 from Access using DB2's Client Access Enabler and ODBC.
> Forgive my ignorance in this area, but I could have sworn we did something
> like this with CF 3.1 - without Enterprise. Any ideas?
>
> Thanks in Advance,
> Andrew
>
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Anybody extend CFX_SOAP to handle non-string parameters yet?

[Lawrence B. Afrin, M.D.]

Howdy --

Summary: has anybody extended cfdev.com's CFX_SOAP to handle non-string input and 
output parameters?

Details:

I'm making my first foray into SOAP (you'd think they woulda taught us about it as 
part of Handwashing 101 in medical
school, eh? :-), and I'm trying to make use, via CF, of a SOAP service that somebody 
else on campus has published. Using
cfdev.com's CFX_SOAP (thanks, cfdev! -- it was *so* easy to get it to work (excluding 
the time it took me to track down
the fix for CF's complaint that it couldn't find the JVM)), I've got working the 
methods  that only use string input
parameters and string output parameters, but it's bombing when I try to use the 
following methods:

method: search
  Input:
Name to search for, type string
  Output:
Success - structure, type array of hashes(ie associative arrays)
Failure - empty structure, type array

method: status
  Input:
PagerID, type string
  Output:
Success - structure, type hash(name, status, type)
Failure - empty structure, type hash

I've since found the SOAP Adhesion UDF library but haven't had time to try it yet.  My 
question is, before I take the
time to set up and try Adhesion, has anybody out there already extended CFX_SOAP to 
handle the types of parameters noted
above?  I've looked at the source code that cfdev.com kindly includes, but I'm afraid 
neither my Java skills nor my
available time are sufficient to do the extension work that I suspect is needed.

Thanks for any assistance y'all can provide!

-- Larry Afrin, M.D.
   Medical University of South Carolina
   [EMAIL PROTECTED]

__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Answer to my own NOCOUNT question

[Lawrence B. Afrin, M.D.]

Howdy, folks --

Sorry for the public display of brain damage via my "NOCOUNT question"
posting of a few minutes ago.

I now realize that SET NOCOUNT ON must precede an INSERT that's followed
by a SELECT or else the "N records affected" message that comes back
from the INSERT screws up CF's ability to properly pick up the results
that come back from the SELECT.

-- LBA

__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Fixes for these longstanding bugs planned?

[Lawrence B. Afrin, M.D.]

Zac --

Thanks for your other suggested work-arounds (the first one, in particula
r,
looks the more straightforward).

-- LBA

P.S.  But I still feel that nested query-driven loops should work exactly
 the
same way you'd expect nested loops to work in any other setting, and I do
n't
see how implementing this in the CF engine would adversely affect
performance.  If anything, I would expect it's more of a performance burd
en
presently (with either the cfset between the outer loop and the inner loo
p,
or, per your method, the array reference into the query) than if nested
query-driven loops were handled "properly" by the engine, omitting the ne
ed
for a cfset or an array reference.


Zac Spitzer wrote:

> Lawrence B. Afrin, M.D. wrote:
>
> >Howdy --
> >
> >I've recently re-encountered some longstanding bugs in CF and was
> >wondering if there are any plans to fix these in the next version.
> >
> >(1) No (sensible) method to detect whether a given array element
> >exists.  Since IsDefined() won't do this, you have to enclose the
> >reference in a cftry...cfcatch construct, which is just plain silly.
> >Either give me an ArrayElementExists() function or, better yet, enhanc
e
> >IsDefined() to support array element checking.  Or, at a bare minimum,

> >at least note in the array documentation that the only way to do this 
is
> >cftry...cfcatch.  (It ain't a bug if it's documented as a feature. :-)

> >
> >I've always wondered why we aren't given an ArrayElementExists() when,

> >over in Structure Land, there's the handy-dandy StructKeyExists().
> >
> >(2) Going all the way back to CF3, CF has forced us to code nested
> >query-driven loops this way:
> >
> >
> >  
> >  
> > ...some reference to #var1# ( in order to reference
> >  the value of importantcolumn in the *current* row
> >  of query1, since reference to #query1.importantcolumn#
> >  will only get you the value of importantcolumn from
> >  the *first* row of query1)...
> >  
> >
> >
> >instead of the much more logical approach that most programmers would
> >expect any programming language to support:
> >
> >
> >  
> >...references to #query1.whatever# properly
> >  get you the value of whatever from the *current*
> >  row of query1...
> >  
> >
> >
>
> try this...
> 
> 
> #qry1.name[qry1_row]# #qry2.name[qry2_row]#
> 
> 
>
> 
> 
> 
>  
> #qry1.name[qry1_row]# #qry2.name[qry2_row]#
> 
> 
>
> it's done like this because there are too many ways to nest stuff and
> then it can get very confusing to know which point you are at it's 
a
> performance trade off ( CF could do everything, but then it would be
> slow), but at least you know whats going on... the first one is also
> nice becuase you don't end up with lots a white space if you
> cfprocesessingdirectives
>
> 
__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Fixes for these longstanding bugs planned?

[Lawrence B. Afrin, M.D.]

Howdy --

I've recently re-encountered some longstanding bugs in CF and was
wondering if there are any plans to fix these in the next version.

(1) No (sensible) method to detect whether a given array element
exists.  Since IsDefined() won't do this, you have to enclose the
reference in a cftry...cfcatch construct, which is just plain silly.
Either give me an ArrayElementExists() function or, better yet, enhance
IsDefined() to support array element checking.  Or, at a bare minimum,
at least note in the array documentation that the only way to do this is
cftry...cfcatch.  (It ain't a bug if it's documented as a feature. :-)

I've always wondered why we aren't given an ArrayElementExists() when,
over in Structure Land, there's the handy-dandy StructKeyExists().

(2) Going all the way back to CF3, CF has forced us to code nested
query-driven loops this way:


  
  
 ...some reference to #var1# ( in order to reference
  the value of importantcolumn in the *current* row
  of query1, since reference to #query1.importantcolumn#
  will only get you the value of importantcolumn from
  the *first* row of query1)...
  


instead of the much more logical approach that most programmers would
expect any programming language to support:


  
...references to #query1.whatever# properly
  get you the value of whatever from the *current*
  row of query1...
  


I know there's a tech note about this on the support site, but again,
there's nothing mentioned about this problem in the current product
documentation (and it's been there since at least CF3), it's grossly
counter-intuitive, and I don't see that it would break any existing code
(first example above) even if CF6 suddenly started doing it right
(second example above).

Thanks for listening.  Just had to get these items off my chest.

-- LBA

P.S.  It sure would be helpful, too, if there were an array function
that would get me a list of indices from any specified dimension of an
array (e.g., imagine an array Array1 such that Array1[1][1] = 1,
Array1[2][3] = 4 and Array1[2][5] = 6; what I'd like is a function
ArrayIndicesToList(Array1) that would return "1,2" (the list of indices
from the array's first dimension), ArrayIndicesToList(Array1[1]) would
return "1" (the only index from within the Array1[1] subarray), and
ArrayIndicesToList(Array1[2]) would return "2,5" (the indices from
within the Array1[2] subarray).

As inferred above regarding ...Exists(), does it make any sense that
there's a StructKeyList() function but no ArrayIndicesToList() function?

P.P.S.  While I'm B&Ming, I might as well ask, too, why can't I cfloop
over (any given dimension of) an array?  Using the example Array1 above,
 should send me through the loop
twice, the first time with i=3 and the second time with i=5.   should also send me through twice, the first
time with i=1, the second time with i=2.


__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Unwanted extraneous text being inserted by Studio 5?

[Lawrence B. Afrin, M.D.]

Howdy, folks --

A colleague of mine recently upgraded her CF Studio from 4.52 to 5 and
since then has noticed a couple of odd problems:

(1) On some File, Save operations, Studio 5 appears to have added in an
extraneous greater-than sign, changing a " " sequence into
a " >" sequence.

(2) And on some other File, Save operations, Studio 5 appears to have
replaced a substantial chunk of the tail end of the file with an odd
string, "tion/cfoutput23:09:13:13pm  02/06/20029:read only".  There's
really nowhere on her system that she could have accidentally picked up
this string via a copy-and-paste sort of operation.

If it makes a difference, she uses the Allaire FTP Service to move files
back and forth between the server and Studio.

I looked in the Studio section of the Forums, and though some folks have
made non-specific references to Studio 5 as being buggy, I haven't seen
this particular problem described.

Has anyone else encountered something like this yet with Studio 5?

-- Larry Afrin
   Med. Univ. of S.C.
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Can anybody confirm this CFMAIL whitespace behavior?

[Lawrence B. Afrin, M.D.]

Howdy --

Today I discovered (I think) a CFMAIL behavior I didn't previously know
about and which I can't find documented anywhere.  (Unable to check the
forums, as that system appears to be down for maintenance at the
moment.)

Ordinarily, any line breaks that I put in the message body enclosed
between CFMAIL and /CFMAIL tags are reproduced as I've coded them.  In
other words, this code:

CFMAIL TO=... FROM=... SUBJECT=...
body line 1
body line 2
body line 3
/CFMAIL

gives me an e-mail message whose body looks like this:

body line 1
body line 2
body line 3

But today I discovered that when I have a CFLOOP inside a CFMAIL message
body, the line breaks I specify within the CFLOOP have totally vanished
in the final message body that the CF engine generates.  For example,
this code:

CFMAIL TO=... FROM=... SUBJECT=...
body line A
CFLOOP INDEX="i" FROM=1 TO=3
body line #i#
/CFLOOP
body line B
/CFMAIL

produces this message body:

body line A
body line 1 body line 2 body line 3
body line B

instead of the message body I expect to see, namely:

body line A
body line 1
body line 2
body line 3
body line B

Now, I would expect the former output ("...body line 1 body line 2 body
line 3...") if I coded the CFLOOP like this:

CFLOOP INDEX="i" FROM=1 TO=3 body line #i# /CFLOOP

But, with a line break between the #i# and the /CFLOOP, I'd expect to
see each "body line whatever-number" on a separate line in the e-mail
mesage body.

I did find a work-around, however.  If I put the intra-CFLOOP line
breaks that I want to see in the message body inside of their own
CFIF-/CFIF blocks, *then* they show up in the message body.  For
example, this code:

CFMAIL TO=... FROM=... SUBJECT=...
body line A
CFLOOP INDEX="i" FROM=1 TO=3
body line #i#
CFIF TRUE
/CFIF
/CFLOOP
body line B
/CFMAIL

produces the desired output:

body line A
body line 1
body line 2
body line 3
body line B

(Of course, if I had coded CFIF TRUE /CFIF (all on one line, instead of
a line break between TRUE and /CFIF), then, again, there would be no
line break after each "body line whatever-number".)

FWIW, I should note that both the CFMAIL and CFLOOP statements in the
code in which I discovered this behavior are query-based statements.  I
don't know if I'd see this behavior if I didn't have the QUERY=...
parameter in the CFMAIL and/or CFLOOP.

So, are CF whitespace rules, which ordinarily are suspended in a CFMAIL
body, supposed to take effect again within other CF constructs contained
within a CFMAIL body?  If so, I think it's kind of confusing behavior
(which probably should be added to the documentation).  After all, note
that CFOUTPUT isn't required within CF constructs contained within
CFMAIL bodies in order to get CF to substitute #var# constructs with
their values.  So if CFOUTPUT rules don't come back into effect within
these inner constructs, then why do whitespace rules come back into
effect?

And does the ENABLECFOUTPUTONLY setting affect this behavior I've noted?

-- Larry Afrin
   Medical University of South Carolina
   [EMAIL PROTECTED]


__
Why Share?
  Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Is the "Authenticate User" query in Advanced Security User Directory dialog correct?

[Lawrence B. Afrin, M.D.]

Howdy --

Taking my first stab at an Advanced Security config using CF5, have got
it working except for one nagging little problem:

Scenario (all names changed to protect the innocent ;-) :

In the "Users" User Directory (implemented in SQL Server, accessed via
ODBC), I have defined two groups, "Database Users" and "Database
Administrators".  Also have defined two users, "Ulysses User" and "Andy
Admin", the former belonging to the "Database Users" group and the
latter belonging to the "Database Administrators" group.

(P.S.  I've used SQL Server's Query Analyzer to look at the SmUser,
SmGroup, and SmUserGroup tables to verify these entries.)

Security Context #1: "Database"
User Directory "Users"
Only Applications protected
One policy, both "Database Users" and "Database Administrators" allowed
to execute applications.

Security Context #2: "DatabaseAdmin"
User Directory "Users"
Only Applications protected
One policy, only "Database Administrators" allowed to execute
applications.

The Application.cfm that oversees the routine "Database" .cfm's starts
like this (copied straight out of the CF5 docs):




  

  
  



  

and it works just fine, allowing both Users and Administrators to access
the other .cfm's in the same directory.

In another directory I've got another Application.cfm that oversees the
.cfm's only the Admins should get to, and it's essentially identical to
the first Application.cfm except the cfapplication specifies
name="DatabaseAdmin", and in the cfauthenticate tag the securityContext
is specified as "DatabaseAdmin".

The Problem: When I call up admin pages, cfauthenticate in the admin
Application.cfm is authenticating users in both the Database Users as
well as the Database Administrators group, when the policy for the
DatabaseAdmin security context clearly says to allow only those users in
the Database Administrators group.  In other words, Ulysses User is
(inappropriately) getting access to the admin directory.

The only reason I can figure out this is happening is that, in the User
Directory listing for "Users", the "Authenticate User" query is a simple

select Name from SmUser where Name = '%s' and Password = '%s'

(This is the default query.)

In fact, I (think I) verified that this is the problem by changing the
DatabaseAdmin policy for Application protection.  I removed "Database
Administrators" from the list of allowed users and added just "Andy
Admin".  Then I tried again calling up one of the pages in the admin
directory, and when the login form came up, I again tested using
"Ulysses User" as the userid.  Darnit, Ulysses User was authenticated,
even though the policy says to only allow Andy Admin in.

(P.S. Yes, I made sure to flush the Authentication and Authorization
caches in between policy changes and testing attempts.)

If the above SQL is truly all that's required to authenticate a user,
it's clearly inadequate.  It's not valid to authenticate a user simply
by seeing whether the username (with appropriate password) exists in the
User Directory.  Authentication has to take into account group
membership.  That is, cfauthenticate should first run the "Authenticate
User" query and *then*, if the submitted userid isn't explicitly listed
in the list of allowed users for the specified securitycontext, it needs
to go through each of the *groups* that're in the list of allowed users
and execute the "Is Group Member" SQL for each of those groups.  If any
of *those* queries comes back with a hit, *then* the user is
authenticated, otherwise the user is rejected.

But that doesn't seem to be what cfauthenticate/Advanced Security is
doing.  All it seems to be doing is a simple lookup in SmUser, and if
you're listed there, congratulations, you're in.

I seriously doubt CF5 would have been allowed out the door with a flaw
as basic as this in it.  Therefore, I must be missing something, but I
sure can't figure out what.

If anybody (1) has made it this far through this ridiculously long
message, and (2) knows what I'm missing, and (3) cares to help, I sure
would appreciate it

-- Larry Afrin
   Med. Univ. of S.C.
   [EMAIL PROTECTED]



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF 5.0 Installation Problems...

[Lawrence B. Afrin, M.D.]

Philip --

Just wanted to say a big "thank you!" for your July 27th tip I found in
the archive about getting around a hang in the upgrade from 4.5 to 5.0.
I was kind of nervous about trying the uninstall 4.5/install 5.0 route,
so I tried stopping all nonessential services, and bingo, InstallShield
finally was able to run the installation.

-- Larry Afrin
   Med. Univ. of S.C.
   [EMAIL PROTECTED]



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Anyone hear of the "HL7" protocol?

[Lawrence B. Afrin, M.D.]

Probably worth mentioning that HL7 version 3 includes specs not only for "old-style" 
HL7 messages (updated, of
course, to include all the new stuff in version 3) but also a complete DTD for sending 
messages in XML, too.  I
know some of the people on the HL7 committee, and they fully recognize the importance 
of XML.

-- Larry Afrin, M.D.
   Medical University of South Carolina
   [EMAIL PROTECTED]


[EMAIL PROTECTED] wrote:

> Al, this is a very timely question in many ways.  HL7 stands for Health
> Level 7 and is an attempt to bring in standardization into Medical
> Applications. The theory is to create a protocol that can allow one medical
> application to exchange data with another.  It is fairly complex and is
> still evolving.  This may all sound a bit mundane but medical software is
> generally woefully behind most other segments.  As a sidenote, it is also
> very expensive and proprietary.
>
> In reality XML is far more likely to truly enable data-exchange in medicine
> but your client has probably been told that HL7 will be the cure to all
> their connectivity issues.
>
> A major point to bear in mind is that HL7 can operate both in batch and
> real-time modes, this is probably the single most important advantage of the
> HL7 format.
>
> I say that your question is timely because Healthcare applications will
> probably be the next major wave of web based revenue generating
> opportunities for all of us.
>
> This is long winded but I hope it helps you.
>
> Kind Regards - Mike Brunt
> Macromedia Consulting
>
> -Original Message-
> From: Al Musella, DPM
> To: CF-Talk
> Sent: 5/15/01 4:07 PM
> Subject: Anyone hear of   the "HL7" protocol?
>
>I have to create a medical website that communicates with a program
> that
> uses the "HL7" protocol.  I never heard of that, and I have to talk to
> their programmers tomorrow and don't want to look that stupid:)  Anyone
> know what they are talking about?
>
> Al Musella, DPM
> virtualtrials.com
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CFAS Scheduler

[Lawrence B. Afrin, M.D.]

Paul --

FYI, I've seen the same thing happen enough times (4.0, 4.1, 4.5, haven't tried any of 
the 4.5 SP's yet) to know it's a
real bug -- you're not imagining it.  :-)  Don't have the foggiest idea what makes the 
scheduler "stick".  Cycling
(stopping, starting) the App Server and the Executive usually seems to fix it, though 
occasionally I've had to cycle them
more than once to finally get the scheduler to start running scheduled jobs again.

Most of the time the scheduler works fine.  I've seen it run for three months without 
a hiccup (finally had to cycle the
system for other reasons), but sometimes it just sticks, and boy is it irritating to 
try to get it going again.

Sometimes I wonder whether it's having some screwy interaction with my backup package 
(Veritas Backup Exec Enterprise
Edition), but I've never had the time, knowledge, or patience to investigate it.  All 
I've done is to cycle it until it
starts working again.

Again, I have no idea whether 4.5SP1 or SP2 might fix it.

Good luck!

-- Larry Afrin
   Med. Univ. of S.C.
   [EMAIL PROTECTED]


paul smith wrote:

> Yes, I've done that.  That's how I know it's not working.
>
> best,  paul
>
> At 12:22 PM 12/19/00 -0500, you wrote:
> >  Paul, one of the things I do when setting up a scheduled program, until I
> >am sure it is working is have it email me a notice of completion whenever it
> >is executed as the last thing on the template.
> >Then you know if it is running or not.
> >
> >jon
> >- Original Message -
> >From: "paul smith" <[EMAIL PROTECTED]>
> >To: "CF-Talk" <[EMAIL PROTECTED]>
> >Sent: Monday, December 18, 2000 8:49 AM
> >Subject: CFAS Scheduler
> >
> >
> > > Until now, I've never had problems with CFAS Scheduler.
> > >
> > > Now I do.  The template executes when I do it manually.  But not when CFAS
> > > Scheduler is supposed to execute it.  But the CFAS Scheduler log indicates
> > > it was executed.  How is this possible?
> > >
> > > best,  paul
> > >
> > >
> > >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: TWO for the crew

[Lawrence B. Afrin, M.D.]

JP --

Regarding #1, yes, but the target database's path/filename in the ODBC datasource 
definition can't be defined in terms of a
mapped drive letter.  Rather, you have to use the standard UNC pathname, e.g., 


There are additional caveats regarding access permissions, etc.  This subject has been 
covered many times over the past few
years in the Allaire forums (forums.allaire.com).  There may even be a whitepaper 
about it in the knowledgebase.

Good luck.

-- Larry Afrin
   Med. Univ. of S.C.
   [EMAIL PROTECTED]


j p wrote:

> 1) Will CF conect to a mdb DS through a network connection??
>
> If I map a dreve to a network machiene and try to connect using that drive
> letter in the CFA ODBC connection screen - it doesn't seem to like that??
>
> Has anyone done this successfully? How?
>
> 2) The application.cfm template is used on all template under that
> directory... Shouldn't I be able to specify  on a page under
> that same directory - with a different app name and have that template
> function in it's own application scope???
>
> This doesn't appear to be working - but it may be a timeout issue, or
> caching issue.
>
> Off to restrt the service to find out..
>
> JP
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Resolved: including ampersand in NT command line

[Lawrence B. Afrin, M.D.]

This is a multi-part message in MIME format.
--E6E02FE204B286EA6F976EC8
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Howdy, folks --

For those of you who took time to think about my problem (how to include
an ampersand on the NT command line, so that I can pass (via the
QUERY_STRING environment variable) a whole list of parameters to a CF
template being run by a command-line invocation of CFML.EXE), thanks
anyway, but I finally found the answer buried in Microsoft's knowledge
base.

Since the ampersand separates multiple commands on the NT command line,
I knew there had to be some way to "escape" the character, but nothing I
tried worked.

Turns out the escape character simply is the caret (^), which is also
used to transform A through Z into Control-A through Control-Z.

Thus:

SET QUERY_STRING=one=1^&two=2

will get you

QUERY_STRING=one=1&two=2

Thanks again.

-- LBA


--E6E02FE204B286EA6F976EC8
Content-Type: text/x-vcard; charset=us-ascii;
 name="afrinl.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Lawrence B. Afrin, M.D.
Content-Disposition: attachment;
 filename="afrinl.vcf"

begin:vcard 
n:Afrin, M.D.;Lawrence
tel;fax:843-792-3200
tel;work:843-792-4271
x-mozilla-html:FALSE
org:Hollings Cancer Center and the Division of Hematology/Oncology, Medical University 
of South Carolina
version:2.1
email;internet:[EMAIL PROTECTED]
title:Assistant Professor of Medicine
adr;quoted-printable:;;Division of Hematology/Oncology, CSB903=0D=0AP.O. Box 250623, 
96 Jonathan Lucas Street;Charleston;SC;29425;USA
x-mozilla-cpt:;0
fn:Afrin, M.D., Lawrence
end:vcard

--E6E02FE204B286EA6F976EC8--


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

How to include ampersand in NT command line SET statement?

[Lawrence B. Afrin, M.D.]

This is a multi-part message in MIME format.
--E7774448A625D015C2801112
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Howdy --

For reasons not worth going into, I'm trying to run a CF template via a
SQL Server trigger doing an "exec master..xp_cmdshell batchfile.cmd"
where the batchfile invokes cfml.exe to run the template.

My problem is that I need to feed the template a query string with
multiple parameters.

I know that, theoretically, the way to do this is to set the
QUERY_STRING environment variable to the query string I want (e.g., "SET
QUERY_STRING=one=1&two=2&three=3") before running cfml.exe, but my
problem is that the NT cmd interpreter is picking up the ampersand as a
special character and terminating the SET at the first ampersand.

Is there some special "escape" syntax that'll let me include an
ampersand as part of the value for a SET statement?  There are no clues
in HELP SET.  I've tried backslashes, double and single quotes, and
other things, but I can't seem to find the magic combination, and I know
there must be a way to do this.

Anybody?

-- Larry Afrin, M.D.
   Medical University of South Carolina
   [EMAIL PROTECTED]


--E7774448A625D015C2801112
Content-Type: text/x-vcard; charset=us-ascii;
 name="afrinl.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Lawrence B. Afrin, M.D.
Content-Disposition: attachment;
 filename="afrinl.vcf"

begin:vcard 
n:Afrin, M.D.;Lawrence
tel;fax:843-792-3200
tel;work:843-792-4271
x-mozilla-html:FALSE
org:Hollings Cancer Center and the Division of Hematology/Oncology, Medical University 
of South Carolina
version:2.1
email;internet:[EMAIL PROTECTED]
title:Assistant Professor of Medicine
adr;quoted-printable:;;Division of Hematology/Oncology, CSB903=0D=0AP.O. Box 250623, 
96 Jonathan Lucas Street;Charleston;SC;29425;USA
x-mozilla-cpt:;0
fn:Afrin, M.D., Lawrence
end:vcard

--E7774448A625D015C2801112--


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Any web-based message board software that can do this?

[Lawrence B. Afrin, M.D.]

This is a multi-part message in MIME format.
--CD01BFD9EB790CB195C41678
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Howdy --

I have been looking for (preferably but not necessarily commercial)
web-based message board software that meets certain specific
requirements.  I have looked at more than 20 packages but still have
come up empty-handed.  If anybody knows of any packages that can meet
these requirements, I'd sure appreciate it if you would clue me in.

1) Supports an essentially unlimited number of forums and users
(approximately 250,000 new forums and users will be created each year).
2) Because of (1), pricing must be either a flat (reasonable ;-) fee for
unlimited use, or literally no more than a few pennies per forum and/or
user.
3) Web-based *and* programmatic interfaces for creating new forums, new
users, and assigning permissions for users to access forums and for
subscribing users to forums.
4) E-mail notification of a forum's subscribed users that a new message
has been posted to the forum; the e-mail must contain a URL that will
get a subscribed user *directly* to the new message (after the user's
userid/password have been entered), not just to the forum's listing of
messages.  It is imperative that the e-mail notification *not* contain
the actual forum posting.
5) Although this should be transparent to the package, it's an absolute
requirement so I'll mention it anyway: all sessions with the web-based
message board must be in secure (SSL, https://...) mode.
6) Access to any forum requires user authentication.  Default
authentication mechanism can be internal, but hooks must be present to
allow external user authentication mechanism if desired.
7) There must be hooks to allow external processing every time a message
is posted to any forum.
8) Postings can be made to a forum via the web or e-mail.
9) Full audit trail of *all* activity throughout the message board,
preferably with audit trail reporting and analysis tools included.
10) Front-end (i.e., design of the web pages seen by the user) must be
customizable by the system administrator.  Customizability need only
apply to the look and feel of the overall site, not necessarily to the
individual forum/user.

Thanks for any help you can provide!

-- Larry Afrin, M.D.
   Medical University of South Carolina
   [EMAIL PROTECTED]


--CD01BFD9EB790CB195C41678
Content-Type: text/x-vcard; charset=us-ascii;
 name="afrinl.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Lawrence B. Afrin, M.D.
Content-Disposition: attachment;
 filename="afrinl.vcf"

begin:vcard 
n:Afrin, M.D.;Lawrence
tel;fax:843-792-3200
tel;work:843-792-4271
x-mozilla-html:FALSE
org:Hollings Cancer Center and the Division of Hematology/Oncology, Medical University 
of South Carolina
version:2.1
email;internet:[EMAIL PROTECTED]
title:Assistant Professor of Medicine
adr;quoted-printable:;;Division of Hematology/Oncology, CSB903=0D=0AP.O. Box 250623, 
96 Jonathan Lucas Street;Charleston;SC;29425;USA
x-mozilla-cpt:;0
fn:Afrin, M.D., Lawrence
end:vcard

--CD01BFD9EB790CB195C41678--

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Mass emailing (but not spamming :)

[Lawrence B. Afrin, M.D.]

This is a multi-part message in MIME format.
--BF62D841560ABF1CDA72296B
Content-Type: multipart/alternative;
 boundary="2F89920B7ADB091BE7EBEC9D"


--2F89920B7ADB091BE7EBEC9D
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Dana --

I have very consistently run into trouble trying to use cfmail to send large batches 
of mail (more than about 50-100 messages at a time).  Fortunately, I very rarely have 
to do this,
so it hasn't prompted me to search for a better solution yet.  I run CF4.5Pro on NT 
Server SP5, with CFMAIL targeted against a standard "sendmail" SMTP server on a 
Solaris box
elsewhere in my institution.  I suspect the problem is in the Dart Communications' 
dart.dll that the CF server uses for SMTP sending, but I've been unable to prove it.  
I have
reported the problem to Allaire but have never heard any response back and have never 
heard of anybody else having this problem.

-- Larry Afrin, M.D.
   Medical University of South Carolina
   [EMAIL PROTECTED]


Dana Larose wrote:

> Hey everyone,
>
> One of my clients has a database of about 2500 clients, each of whom is
> subscribed to recieve a report that is generated once a month.  The want to
> move towards sending a PDF via email, instead of the heavy faxing.
>
> Before I give them a quote on this thing, I would like to know if 
> is up to the job.  I've used it successfully emailing a few dozen people,
> but will I run into problems using it to send 2500 emails, each with a PDF
> attachment?
>
> Dana Larose
> ColdFusion Monkey
> Canadian Web Design & Consulting Inc.
>
> A: 701-281 McDermot Avenue (McDermot & King)
> P: 204-946-5155
> C: 204-291-7140
> F: 204-946-5156
> E: [EMAIL PROTECTED]
> W: http://www.cdnwebdesign.com
>
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

--2F89920B7ADB091BE7EBEC9D
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit



Dana --
I have very consistently run into trouble trying to use cfmail to send
large batches of mail (more than about 50-100 messages at a time). 
Fortunately, I very rarely have to do this, so it hasn't prompted me to
search for a better solution yet.  I run CF4.5Pro on NT Server SP5,
with CFMAIL targeted against a standard "sendmail" SMTP server on a Solaris
box elsewhere in my institution.  I suspect the problem is in the
Dart Communications' dart.dll that the CF server uses for SMTP sending,
but I've been unable to prove it.  I have reported the problem to
Allaire but have never heard any response back and have never heard of
anybody else having this problem.
-- Larry Afrin, M.D.
   Medical University of South Carolina
   [EMAIL PROTECTED]
 
Dana Larose wrote:
Hey everyone,
One of my clients has a database of about 2500 clients, each of whom
is
subscribed to recieve a report that is generated once a month. 
The want to
move towards sending a PDF via email, instead of the heavy faxing.
Before I give them a quote on this thing, I would like to know if <cfmail>
is up to the job.  I've used it successfully emailing a few dozen
people,
but will I run into problems using it to send 2500 emails, each with
a PDF
attachment?
Dana Larose
ColdFusion Monkey
Canadian Web Design & Consulting Inc.
A: 701-281 McDermot Avenue (McDermot & King)
P: 204-946-5155
C: 204-291-7140
F: 204-946-5156
E: [EMAIL PROTECTED]
W: http://www.cdnwebdesign.com">http://www.cdnwebdesign.com
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/">http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or send a message to [EMAIL PROTECTED] with 'unsubscribe'
in the body.


--2F89920B7ADB091BE7EBEC9D--

--BF62D841560ABF1CDA72296B
Content-Type: text/x-vcard; charset=us-ascii;
 name="afrinl.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Lawrence B. Afrin, M.D.
Content-Disposition: attachment;
 filename="afrinl.vcf"

begin:vcard 
n:Afrin, M.D.;Lawrence
tel;fax:843-792-3200
tel;work:843-792-4271
x-mozilla-html:FALSE
org:Hollings Cancer Center and the Division of Hematology/Oncology, Medical University 
of South Carolina
version:2.1
email;internet:[EMAIL PROTECTED]
title:Assistant

Re: HTTP request and CGI variables

[Lawrence B. Afrin, M.D.]

I had some difficulties with this problem recently, too, when I needed to
implement a monitor that checks on another site.  Some things to be aware
of:

1) The USERAGENT param to CFHTTP did not become available until CF4.5.  I
don't believe trying to set the user agent via CFHTTPPARAM in earlier
version of CF will accomplish the desired effect.  If you're not at 4.5,
upgrade, then use CFHTTP USERAGENT=...

2) Note that there is a problem in the cfhttp.dll with 4.5 that causes
buggy CFHTTP METHOD=POST operations (such that the receiving server will
misunderstand/reject the request).  A hotfix (basically, an updated
cfhttp.dll) is available at
http://www.allaire.com/handlers/index.cfm?ID=14140&Method=Full, or you can
upgrade to 4.5.1, which includes this and all other 4.5 hotfixes, I believe.

-- LBA

--On Sunday, April 23, 2000, 1:26 AM -0700 Dick Applebaum <[EMAIL PROTECTED]>
wrote:

> 
> Andrea
> 
> 
> I never had the need to examine this before, so I wrote a little 
> program to check it out.
> 
> CF passes a HTTP_USER_AGENT of:
> 
>ColdFusion 4.0
> 
> I can understand arguments for and against allowing you to spoof the 
> user agent.
> 
> (Tango does).
> 
> I couldn't find anything in any CFDocs that says you can't but 
> that probably means... you can't.
> 
> 
> In your case, maybe you can convince the ASP programmer to accept 
> ColdFusion 4.0 as a valid browser???
> 
> 
> HTH
> 
> Dick
> 
> 
> 
> At 7:23 PM + 4/21/2000, Andrea W wrote:
>> I am sending an http request using cfhttp to register a user on a remote
>> site - the remote site is using asp. The asp code is looking for the
>> browser type in the cgi variables. I am sending it the browser type as
>> follows:
>> 
>> > url="http://remote.server.com/signup/signup.asp?username=andrea&passw 
>> ord=sesame"
>> method="post" resolveurl="true">
>> 
>> 
>> 
>> 
>> 
>> But the remote app is still balking and claiming that I have an old
>> browser version. Does anyone know if there is some way that using the
>> cfhttp tag can tack on some cgi variables that cannot be overridden by
>> the cfhttpparam? I have shown this code to the asp developer who wrote
>> the code that accepts the user registration, and he said the
>> HTTP_USER_AGENT variable looked correct and is what his app is looking
>> for.
>> 
>> Thanks,
>> 
>> Andrea Wasik
>> 
>> 
>> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>> 
>> 
>> -- Archives: http://www.eGroups.com/list/cf-talk
>> To Unsubscribe visit 
>> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_tal 
>> k or send a message to [EMAIL PROTECTED] with 
>> 'unsubscribe' in the body.
> 
> -
> - Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> or send a message to [EMAIL PROTECTED] with 'unsubscribe'
> in the body.


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Are 4.5 mail spooler woes fixed in 4.5.1?

[Lawrence B. Afrin, M.D.]

This is a multi-part message in MIME format.
--5FF5C233E81C0983FD7E1B4C
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Howdy --

I've been having a very frustrating time with the CF 4.5 mail spooler
since I wrote my first app a few weeks ago that sends out bursts of
large volumes of e-mail.

I have a choice of two outgoing SMTP servers I can direct the spooler
to, and I'm getting the same problem with either one.  After processing
a burst of anywhere from a few dozen to two or three hundred messages,
the spooler hangs on trying to deliver the next message to the SMTP
server and ultimately reports a time-out message in
cfusion\log\mail.log.  All remaining messages are then moved from
cfusion\mail\spool to cfusion\mail\undelivr and the spooler notes a log
entry for each one, saying it can't send it until "pending mail
operations are completed."

I've tried *EVERYTHING* to fix this.  I've tried moving the messages
from undelivr back to spool.  No dice, they just get moved back to
undelivr with the same damn entries dumped into the log.  I've tried
cycling CF.  No dice.  Hell, I've tried *rebooting*.  No dice.  Like I
said above, I tried switching SMTP servers.  No dice.  I've gone into
the Allaire\Cold Fusion\CurrentVersion\Mail key in the registry and
changed the ReuseOpenConnection setting from default 1 to 0.  No dice
(so I set it back to 1).  I deduced from the registry that CF is using
dart.com's Internet connectivity package (dart.dll) to talk to the SMTP
server.  Is this a bug in dart.dll?

And the absolute damndest thing of all is that every day or two, as I
happen to be tinkering around with this problem, all of a sudden it'll
start working again and process another couple hundred or so messages
before hanging again.  For the life of me, I can't figure out any
pattern to this (i.e., what the hell I'm doing to get it working again).

I'm *sorely* tempted to junk CFMAIL and the CF spooler and switch to
anything that'll talk directly to the SMTP server, like fuseware.com's
CFX_Mail2, except then my templates will have to hang around actively
executing for as long as it takes the SMTP server to respond, and so you
start complicating the picture with template timeout issues, etc. etc.
etc.  Technically, it's a lot cleaner solution to use the spooler, but I
need a spooler that works!

Does anybody have any advice?  I've just downloaded the 4.5.1 update but
I can't find the release notes anywhere so I can't tell if 4.5.1 fixes
this or not.

TIA,

-- Larry Afrin
   [EMAIL PROTECTED]


--5FF5C233E81C0983FD7E1B4C
Content-Type: text/x-vcard; charset=us-ascii;
 name="afrinl.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Lawrence B. Afrin, M.D.
Content-Disposition: attachment;
 filename="afrinl.vcf"

begin:vcard 
n:Afrin, M.D.;Lawrence
tel;fax:843-792-3200
tel;work:843-792-4271
x-mozilla-html:FALSE
org:Hollings Cancer Center and the Division of Hematology/Oncology, Medical University 
of South Carolina
version:2.1
email;internet:[EMAIL PROTECTED]
title:Assistant Professor of Medicine
adr;quoted-printable:;;Division of Hematology/Oncology, CSB903=0D=0AP.O. Box 250623, 
96 Jonathan Lucas Street;Charleston;SC;29425;USA
x-mozilla-cpt:;0
fn:Afrin, M.D., Lawrence
end:vcard

--5FF5C233E81C0983FD7E1B4C--

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Check Ip

[Lawrence B. Afrin, M.D.]

This is a multi-part message in MIME format.
--71B1E349269CF0F5FFC63B76
Content-Type: multipart/alternative;
 boundary="830DD7D2B0271BA74B23A838"


--830DD7D2B0271BA74B23A838
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Um, if you used "contains" like that, then you would improperly accept IP addresses of 
the form *.206.162.74, wouldn't you?

Instead, how about using GetToken() as follows?

cfset ip = #cgi.remote_addr#
cfset lastoctet = gettoken(ip,4,".")
cfif #left(ip,11)# is "206.162.74." and #lastoctet# ge 1 and #lastoctet# le 255
...

Plenty of other ways you could do this, too -- they all boil down to having to isolate 
the last octet of the IP address if you want to make numerical comparisons against it.

-- LBA

Jay Jennings wrote:

> >   > '206.162.74.255'>
> > However, since the IP is not really a number, I am getting an
> > error when it
> > tried to evaluate. Is there a way to trim the address to seperate pieces
>
> Try something like:
> cfif cgi.remote_addr contains "206.162.74"
>
> Or, instead of using CONTAINS you could use one of the string comparison
> functions in CF.
>
>  Jay Jennings
>
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

--830DD7D2B0271BA74B23A838
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit



Um, if you used "contains" like that, then you would improperly accept
IP addresses of the form *.206.162.74, wouldn't you?
Instead, how about using GetToken() as follows?
cfset ip = #cgi.remote_addr#
cfset lastoctet = gettoken(ip,4,".")
cfif #left(ip,11)# is "206.162.74." and #lastoctet# ge 1 and #lastoctet#
le 255
...
Plenty of other ways you could do this, too -- they all boil down to
having to isolate the last octet of the IP address if you want to make
numerical comparisons against it.
-- LBA
Jay Jennings wrote:
>  <cfif #cgi.remote_addr# GT '206.162.74.1'
AND #cgi.remote_addr# LT
> '206.162.74.255'>
> However, since the IP is not really a number, I am getting an
> error when it
> tried to evaluate. Is there a way to trim the address to seperate
pieces
Try something like:
    cfif cgi.remote_addr contains
"206.162.74"
Or, instead of using CONTAINS you could use one of the string comparison
functions in CF.
 Jay Jennings
--
Archives: http://www.eGroups.com/list/cf-talk">http://www.eGroups.com/list/cf-talk
To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or send a message to [EMAIL PROTECTED] with 'unsubscribe'
in the body.


--830DD7D2B0271BA74B23A838--

--71B1E349269CF0F5FFC63B76
Content-Type: text/x-vcard; charset=us-ascii;
 name="afrinl.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Lawrence B. Afrin, M.D.
Content-Disposition: attachment;
 filename="afrinl.vcf"

begin:vcard 
n:Afrin, M.D.;Lawrence
tel;fax:843-792-3200
tel;work:843-792-4271
x-mozilla-html:FALSE
org:Hollings Cancer Center and the Division of Hematology/Oncology, Medical University 
of South Carolina
version:2.1
email;internet:[EMAIL PROTECTED]
title:Assistant Professor of Medicine
adr;quoted-printable:;;Division of Hematology/Oncology, CSB903=0D=0AP.O. Box 250623, 
96 Jonathan Lucas Street;Charleston;SC;29425;USA
x-mozilla-cpt:;0
fn:Afrin, M.D., Lawrence
end:vcard

--71B1E349269CF0F5FFC63B76--

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.