Why CFHTTP not post if data come from multi-part form?
Confucious say: "Why CFHTTP not post if data come from multi-part form?" I have a CFHTTP script which executes perfectly if all the data submitted to it comes from only one form page. However if the data comes from a page that is the result of a multi-page form, for some reason it doesn't execute and post properly. Any idea what could be causing that. Same fields are present on the final page in both cases. I even put them on there in the same order, but no luck. It only will execute if the form is one page, and that doesn't make any sense. Appreciate any insights into this mystery, as perplexing perhaps as the Bermuda Triangle. ~~ 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
RE: SOXML xmlToDom
Well, my File is rather large, minimum 1mb. Would You Still like me to Mail it out? Thanks, Fred -Original Message- From: John Wilker [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 15, 2001 8:31 PM To: CF-Talk Subject: RE: SOXML xmlToDom Also as a side note, you may want to consider using the MS XML parser yourself instead of SoXML. In an application I did, with a 200k XML file, it would take a minute or more to parse with soxml and a few seconds just using the MSxml parser directly. J. John Wilker Web Applications Consultant Macromedia Certified ColdFusion Developer President/Founder, Inland Empire CFUG. www.red-omega.com "With your shield or on it." Spartan mothers would say this to their sons going to battle. It was believed that if you turned to run you'd drop your shield.. If you died in combat your comrades would carry your body home on your shield. So coming home with it or on it were the only options. -Original Message- From: Fred Anderson [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 15, 2001 10:02 PM To: CF-Talk Subject: SOXML xmlToDom While using CF_SOXML xmltoDOM to parse some XML I am having the following issue. When trying to retrieve a node it is giving back all the nodes at that level through the site; here is an example. Shelf -Book --Author --Author --Author -Book --Author --Author -Book --Author --Author --Author --Author Shelf -Book --Author --Author --Author -Book --Author --Author -Book --Author --Author --Author --Author So I looping over shelves then looping over books, then Authors Well it appears to be returning all of the authors in the first Loop. Does anyone have any suggestions? Thanks, Fred ~~ 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: SOXML xmlToDom
Can you send what the XML looks like? J. John Wilker Web Applications Consultant Macromedia Certified ColdFusion Developer President/Founder, Inland Empire CFUG. www.red-omega.com "With your shield or on it." Spartan mothers would say this to their sons going to battle. It was believed that if you turned to run you'd drop your shield.. If you died in combat your comrades would carry your body home on your shield. So coming home with it or on it were the only options. -Original Message- From: Fred Anderson [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 15, 2001 10:02 PM To: CF-Talk Subject: SOXML xmlToDom While using CF_SOXML xmltoDOM to parse some XML I am having the following issue. When trying to retrieve a node it is giving back all the nodes at that level through the site; here is an example. Shelf -Book --Author --Author --Author -Book --Author --Author -Book --Author --Author --Author --Author Shelf -Book --Author --Author --Author -Book --Author --Author -Book --Author --Author --Author --Author So I looping over shelves then looping over books, then Authors Well it appears to be returning all of the authors in the first Loop. Does anyone have any suggestions? Thanks, Fred ~~ 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: SOXML xmlToDom
Also as a side note, you may want to consider using the MS XML parser yourself instead of SoXML. In an application I did, with a 200k XML file, it would take a minute or more to parse with soxml and a few seconds just using the MSxml parser directly. J. John Wilker Web Applications Consultant Macromedia Certified ColdFusion Developer President/Founder, Inland Empire CFUG. www.red-omega.com "With your shield or on it." Spartan mothers would say this to their sons going to battle. It was believed that if you turned to run you'd drop your shield.. If you died in combat your comrades would carry your body home on your shield. So coming home with it or on it were the only options. -Original Message- From: Fred Anderson [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 15, 2001 10:02 PM To: CF-Talk Subject: SOXML xmlToDom While using CF_SOXML xmltoDOM to parse some XML I am having the following issue. When trying to retrieve a node it is giving back all the nodes at that level through the site; here is an example. Shelf -Book --Author --Author --Author -Book --Author --Author -Book --Author --Author --Author --Author Shelf -Book --Author --Author --Author -Book --Author --Author -Book --Author --Author --Author --Author So I looping over shelves then looping over books, then Authors Well it appears to be returning all of the authors in the first Loop. Does anyone have any suggestions? Thanks, Fred ~~ 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
SOXML xmlToDom
While using CF_SOXML xmltoDOM to parse some XML I am having the following issue. When trying to retrieve a node it is giving back all the nodes at that level through the site; here is an example. Shelf -Book --Author --Author --Author -Book --Author --Author -Book --Author --Author --Author --Author Shelf -Book --Author --Author --Author -Book --Author --Author -Book --Author --Author --Author --Author So I looping over shelves then looping over books, then Authors Well it appears to be returning all of the authors in the first Loop. Does anyone have any suggestions? Thanks, Fred ~~ 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
Re: Fw: Query Field with Null Value
At 07:51 PM 12/15/01 -0500, you wrote: >- Original Message - >From: "Anthony Abby" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Friday, December 14, 2001 7:19 PM >Subject: Query Field with Null Value > > > > Silly question but what's the best way of building a query that will > > select records containing a specific WORD, AND also include records that >are > > NULL in the same field? > > > > (TC.Status <> 'Closed') OR (TC.Status = NULL) Try: (TC.Status LIKE '%Closed%') OR (TC.Status IS NULL) Now available in a San Francisco Bay Area near you! http://www.blivit.org/mr_urc/index.cfm http://www.blivit.org/mr_urc/resume.cfm ~~ 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
Fw: Query Field with Null Value
- Original Message - From: "Anthony Abby" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, December 14, 2001 7:19 PM Subject: Query Field with Null Value > Silly question but what's the best way of building a query that will > select records containing a specific WORD, AND also include records that are > NULL in the same field? > > (TC.Status <> 'Closed') OR (TC.Status = NULL) > > Thanks > Anthony > > > _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com ~~ 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
How should I handle this???
I am creating a message board, and have hopes of putting it up for sale once completed. I want the forum to be dynamic in as far as the ability to change the background and font etc etc on the fly. I have a page where the admin can make theses changes etc, but what I want to do is have a preview window of what it will look like once the changes are made. Should I try and attempt this with javascript and put in a then use the innerHTML attribute? I know this will not work with NS but I am not sure of another way. Any suggestion would help!!! Doug ~~ 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
Re: Unique ID Help
make sure the datatype is a varchar (varchar2 if oracle) and that it is long enough. you'll need single quotes around it - Original Message - From: "Gregory Harris" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, December 15, 2001 1:30 PM Subject: Unique ID Help > Ok, say I have a given Unique ID: > > CFE4734A-CEA8-48BE-9D64-88FCBB7E2688 > > That needs to be inserted into a database like so perhaps: > > INSERT INTO ThisTable) > > (GUID Field) > > VALUES > > (CFE4734A-CEA8-48BE-9D64-88FCBB7E2688) > > > How do I get it into the GUID Field? I've tried with and without quotes and > have had no success. Thanks for your help! > > > Gregory Harris > [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: Source Control and Your Dog
visual source safe or teamsite. i've used both of them. only heard good things about pvcs. so i guess any of the three would be ok. my $0.02 - Original Message - From: "Zac spitzer" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, December 15, 2001 5:21 PM Subject: Re: Source Control and Your Dog > Jay Jennings wrote: > > >We're battling at work over whether to switch to Perforce or PVCS for our > >source control. If anyone has any thoughts on whether one or the other is > >better in a CF coding environment, feel free to speak up. We have local and > >remote developers, if that makes a difference. > > > good old cvs I find great > > http://www.wincvs.org windows client > http://www.cvsnt.org windows server > > tortise cvs is a great exporer shell ext which ties cvs directly into > explorer... > > z > ~~ 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: Unique ID Help
At 10:30 AM 12/15/01 -0800, you wrote: >Ok, say I have a given Unique ID: > >CFE4734A-CEA8-48BE-9D64-88FCBB7E2688 > >That needs to be inserted into a database like so perhaps: > >INSERT INTO ThisTable) > >(GUID Field) > >VALUES > >(CFE4734A-CEA8-48BE-9D64-88FCBB7E2688) > > >How do I get it into the GUID Field? I've tried with and without quotes and >have had no success. Thanks for your help! What is the error message? If you've tried with quotes, it might be a "this info will be truncated" message, in which case, the data is too long to fit into the specified field and you need to make the field larger. Now available in a San Francisco Bay Area near you! http://www.blivit.org/mr_urc/index.cfm http://www.blivit.org/mr_urc/resume.cfm ~~ 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
anybody else having tag gallery problems?
Anybody else getting errors when trying to submit a new tag? Don Error Diagnostic Information Error processing CFFILE Error attempting to generate temporary file name for directory '\\uscamspcp002\e$\developer\gallery\components'. Error: An unspecified error occurred. The error occurred while processing an element with a general identifier of (CFFILE), occupying document position (64:2) to (64:138) in the template file C:\PROGRAM FILES\ALLAIRE\SPECTRA\PLP\DEVX\DEVX_SUBMIT\SUBMITPAGES.CFM. Date/Time: 12/15/01 18:40:09 Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0; T312461) Remote Address: 65.100.189.91 HTTP Referer: http://devex.allaire.com/developer/gallery/Submit.cfm ~~ 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: Source Control and Your Dog
Jay Jennings wrote: >We're battling at work over whether to switch to Perforce or PVCS for our >source control. If anyone has any thoughts on whether one or the other is >better in a CF coding environment, feel free to speak up. We have local and >remote developers, if that makes a difference. > good old cvs I find great http://www.wincvs.org windows client http://www.cvsnt.org windows server tortise cvs is a great exporer shell ext which ties cvs directly into explorer... z ~~ 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
CFMAIL
Hey everyone, What kind of options are available for formatting non-html email... I need to format the emails one module of this sytem I am working on sends out. Thanks for any input. Michael T. Tangorre Resident Assistant - Brick Web Applications Developer A.U. Webteam Slave :-) AIM: CrazyFlash4 ~~ 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: Unique ID Help
Well if your table row is a varchar then it should be INSERT INTO yourtable (GUID) VALUES ('#UUID#') - Original Message - From: "Gregory Harris" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, December 15, 2001 10:30 AM Subject: Unique ID Help > Ok, say I have a given Unique ID: > > CFE4734A-CEA8-48BE-9D64-88FCBB7E2688 > > That needs to be inserted into a database like so perhaps: > > INSERT INTO ThisTable) > > (GUID Field) > > VALUES > > (CFE4734A-CEA8-48BE-9D64-88FCBB7E2688) > > > How do I get it into the GUID Field? I've tried with and without quotes and > have had no success. Thanks for your help! > > > Gregory Harris > [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: Unique ID Help
In this case, you GUID field is a TEXT or CHAR or VARCHAR field, so you must put single quotes around the value in the SQL. INSERT INTO thisTable (GUID) VALUES ('CFE4734A-CEA8-48BE-9D64-88FCBB7E2688') Dave - Original Message - From: "Gregory Harris" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, December 15, 2001 1:30 PM Subject: Unique ID Help > Ok, say I have a given Unique ID: > > CFE4734A-CEA8-48BE-9D64-88FCBB7E2688 > > That needs to be inserted into a database like so perhaps: > > INSERT INTO ThisTable) > > (GUID Field) > > VALUES > > (CFE4734A-CEA8-48BE-9D64-88FCBB7E2688) > > > How do I get it into the GUID Field? I've tried with and without quotes and > have had no success. Thanks for your help! > > > Gregory Harris > [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
Unique ID Help
Ok, say I have a given Unique ID: CFE4734A-CEA8-48BE-9D64-88FCBB7E2688 That needs to be inserted into a database like so perhaps: INSERT INTO ThisTable) (GUID Field) VALUES (CFE4734A-CEA8-48BE-9D64-88FCBB7E2688) How do I get it into the GUID Field? I've tried with and without quotes and have had no success. Thanks for your help! Gregory Harris [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: Getting at a datasource on a different machine
One way is to put a stub program on A. The stub program receives a WDDX packet containing the SQL Statements from your program on B, The stub program issues the SQL commands against its db and returns the result set through another WDDX packet. I do this all the time to setup/manipulate client dbs where I don't have admin privileges to the client's site and db. server B: Serialize SQL Commands server B: cfhttp post WDDX to stub on server A server A Stub: Invoked by cfhttp post server A Stub: Deserialize WDDX SQL statements server A Stub: Issue SQL statements against server A db server A Stub: Serialize and return SQL result set to cfhttp request server B: deserialize SQL result set returned from cfhttp request server B: process result set as if normal query HTH Dick At 11:16 AM -0500 12/15/01, Joe Tartaglia wrote: >Here is my problem: > >The code for my main site resides on Web Server A. >This server is running ColdFusion 4.5. > >Some payment forms need to be on a secure server (Server B). >Server B is running ColdFusion 4.0 > >Questions: >1. How can I access a CF datasource that is set up on > Server A from the code on Server B? > >2. What problems might I expect due to the fact that > Server A and B are running different versions of CF. > (My code is very generic and was originally written > and functions under CF Ver. 4.0) > >Thanks in advance. > >Joe Tartaglia >High Caliber Systems >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 ~~ 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: Getting at a datasource on a different machine
On Sat, 15 Dec 2001, Joe Tartaglia wrote: > > Here is my problem: > > The code for my main site resides on Web Server A. > This server is running ColdFusion 4.5. > > Some payment forms need to be on a secure server (Server B). > Server B is running ColdFusion 4.0 > > Questions: > 1. How can I access a CF datasource that is set up on > Server A from the code on Server B? You can't if you mean datasource to be the ODBC connection. You can if you mean datasource to be a database. Then you just setup an ODBC on the serverB ~~ 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
slightly OT: anyone have Excel 97 installed?
Could someone help me out with a problem I'm having with the web query function in Excel? I developed a template for a client to use, tying a web query macro to a button for them to download some data from their CF site. But even though I saved it out as 97 format from my Excel 2000, they're having problems in 97. I think some of the macro code is incompatible. (BTW, I'm on Win 2000 and they're on Win NT 4.) What I'm after is some basic screen shots of all the dialogue boxes involved in doing a web query *manually* in Excel 97 - enough for me to talk the client through the process blow-by-blow for them to do the query manually. Send any grabs you can do off-list! thanks, - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available ~~ 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
Getting at a datasource on a different machine
Here is my problem: The code for my main site resides on Web Server A. This server is running ColdFusion 4.5. Some payment forms need to be on a secure server (Server B). Server B is running ColdFusion 4.0 Questions: 1. How can I access a CF datasource that is set up on Server A from the code on Server B? 2. What problems might I expect due to the fact that Server A and B are running different versions of CF. (My code is very generic and was originally written and functions under CF Ver. 4.0) Thanks in advance. Joe Tartaglia High Caliber Systems 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: XML Schema Validation
Thanks Nick1 >From your reference, and a few others I found, I was able to cobble together a simple CF program that actually works! schemaCache = CreateObject("COM","MSXML2.XMLSchemaCache.4.0"); schemaCache.Add("","c:\test\listschema.xml"); doc = CreateObject("COM","MSXML2.DOMDocument.4.0"); doc.schemas = schemaCache; doc.async = 0; doc.load("c:\tesr\publist_schema.xml"); XMLParsingError = doc.parseError; ErrorCode.|#XMLParsingError.ErrorCode#| Reason|#XMLParsingError.Reason#| I am really "shooting in the dark" though: VBS 5 does not support "Dim ... As" to create an object The Object ClassName "MSXML2.XMLSchemaCache40" in VB, needs to be specified as "MSXML2.XMLSchemaCache.4.0" in cfobject The Object ClassName "MSXML2.DOMDocument40" in VB, needs to be specified as "MSXML2.DOMDocument.4.0" in cfobject So far, I have only been able to validate by loading the XNL document from disk. I would like to do much more, but have been unable to find any info on the MSXML 4.0 objects, methods and properties. Any help will be greatly appreciated! Dick At 4:45 AM -0500 12/15/01, Nick de Voil wrote: >Dick > >Does this help? > >http://www.vbws.com/tutors/xsd/xsdvb.aspx > >The nitty-gritty part seems to be > >Dim schemaCache As MSXML2.XMLSchemaCache40 >Set schemaCache = New MSXML2.XMLSchemaCache40 >schemaCache.Add ìî,îD:\schemas\mySchema.xsdî >Dim doc As MSXML2.DOMDocument40 >Set doc = New MSXML2.DOMDocument40 >Set doc.schemas = schemaCache >doc.async = False >If Not doc.Load(ìD:\docs\myDoc.xmlî) Then > MsgBox "Error loading XML document: " & doc.parseError.reason >End If > >which CFOBJECT could handle I dare say. > >Nick > ~~ 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: XML Schema Validation
Dick Does this help? http://www.vbws.com/tutors/xsd/xsdvb.aspx The nitty-gritty part seems to be Dim schemaCache As MSXML2.XMLSchemaCache40 Set schemaCache = New MSXML2.XMLSchemaCache40 schemaCache.Add ,D:\schemas\mySchema.xsd Dim doc As MSXML2.DOMDocument40 Set doc = New MSXML2.DOMDocument40 Set doc.schemas = schemaCache doc.async = False If Not doc.Load(D:\docs\myDoc.xml) Then MsgBox "Error loading XML document: " & doc.parseError.reason End If which CFOBJECT could handle I dare say. Nick ~~ 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: Query Field with Null Value
Anthony Yes, but use "IS NULL" instead of "= NULL" (TC.Status <> 'Closed') OR (TC.Status IS NULL) Nick ~~ 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: check for double byte (japanese characters)
> For the english only section, I would like to ensure that the user does not > enter any japanese by mistake. > > Is it possible to detect non english characters? if you're using unicode, kinda easy, if not, kinda tough. you might try forcing latin charset so that japanese chars would look "funny". --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.307 / Virus Database: 168 - Release Date: 12/11/2001 ~~ 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