Re: Parsing an XML file and inserting into Oracle SYS.XMLTYPE

2007-09-28 Thread Carlos Paez Jr
, Carlos Paez Jr [EMAIL PROTECTED] wrote: Hi James, I did try to use cf_sql_clob but I was getting this error: Error casting an object of type to an incompatible type. This usually indicates a programming error in Java, although it could also mean you have tried to use a foreign object

Re: Parsing an XML file and inserting into Oracle SYS.XMLTYPE

2007-09-27 Thread Carlos Paez Jr
. On 9/27/07, Carlos Paez Jr [EMAIL PROTECTED] wrote: Thanks for the replies and ideas. The datatype of my column is SYS.XMLTYPE which I understood to be a CLOB; which is the source of my confusion. CLOBs should hold up to 4 gig of data. I'm thinking that this error might not be referring

Re: Parsing an XML file and inserting into Oracle SYS.XMLTYPE

2007-09-27 Thread Carlos Paez Jr
was forced to use cf_sql_longvarchar On 9/27/07, James Holmes [EMAIL PROTECTED] wrote: If your column is CLOB, use cf_sql_clob as your type (that's what it's for). On 9/27/07, Carlos Paez Jr [EMAIL PROTECTED] wrote: All, problem fixed! Thanks for the help! I changed my Oracle column

Re: Parsing an XML file and inserting into Oracle SYS.XMLTYPE

2007-09-26 Thread Carlos Paez Jr
Thanks for the replies and ideas. The datatype of my column is SYS.XMLTYPE which I understood to be a CLOB; which is the source of my confusion. CLOBs should hold up to 4 gig of data. I'm thinking that this error might not be referring to the datatype of my column, but rather, that oracle is not

Re: GotCFM.com Approaching 1000 Sites - Contest/Prizes

2007-08-10 Thread Carlos Paez Jr
Hi Rey, I submitted iowalum.com/magazine But I didn't give a contact. If it wins one of the prizes let me know :) -Carlos On 8/10/07, Rey Bango [EMAIL PROTECTED] wrote: Hi everyone, I'm very happy to announce that GotCFM.com is just 10 sites shy of reaching 1000 CFML-Powered sites. This

Re: Adobe Nails ColdFusion Cofin

2007-07-31 Thread Carlos Paez Jr
At my group in Motorola we have 5 CF enterprise licenses. We don't pay for upgrades, instead we pay ~1500 per license in maintenance and it lasts for 2 years. And yes, $7,500 is nothing to an enterprise company. On 7/31/07, Billy Cox [EMAIL PROTECTED] wrote: I tend to be skeptical of

Re: unsubscribe

2007-06-20 Thread Carlos Paez Jr
why would you want to? I don't understand the question On 6/20/07, Madenyika, Denford [EMAIL PROTECTED] wrote: How do I unsubscribe from cf-talk ~| ColdFusion 8 beta – Build next generation applications today. Free beta

Re: Web Service Complex Data

2007-03-12 Thread Carlos Paez Jr
This document will help you start to figure out WS for CF. http://hcc.musc.edu/research/shared_resources/xml_complex_types_to_cf_structure_notes.cfm Basically the idea is to replicate the XML you are looking to build with structs. If you have an element that has a max=unbounded then you'll

Re: Web Service Consuming error

2007-03-09 Thread Carlos Paez Jr
Does anyone know how to create the ColdFusion variable for a WS with this kind of complex type, nillable variable? On 3/8/07, Carlos Paez [EMAIL PROTECTED] wrote: Hi, I am trying to call a 'resetPassword' method, a resetPasswordRequest message contains an element of UserReset. Inside