RE: does cf choke on database nulls?
You need to alias it, Select sum(stoptime) as stoptime from reports jb -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 10 May 2004 14:13 To: CF-Talk Subject: does cf choke on database nulls? select sum(stopTime) from reports where vehicleNumberoni = 58444 returns a null in sql server query analyzer. same query ran from cfmx, gives this error: [Macromedia][SQLServer JDBC Driver][SQLServer]Arithmetic overflow error converting _expression_ to data type int. 22001 there are no values in that column for that vehicleNumberoni they are all null, however, why would cfmx choke, its just null? thanks! ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Microsoft acknowledges CF!
You know, I'm probably biased, but you have to love the fact that almost every code comparison shows CF having about half the lines .Net does. I like .Net, a lot, and yes, we all know the # of lines isn't the most important thing in the world, but it was funny how much this stood out, especially in the DB examples. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: does cf choke on database nulls?
Duh! Ignore me...more coffee! -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED] Sent: 10 May 2004 14:11 To: CF-Talk Subject: RE: does cf choke on database nulls? You need to alias it, Select sum(stoptime) as stoptime from reports jb -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 10 May 2004 14:13 To: CF-Talk Subject: does cf choke on database nulls? select sum(stopTime) from reports where vehicleNumberoni = 58444 returns a null in sql server query analyzer. same query ran from cfmx, gives this error: [Macromedia][SQLServer JDBC Driver][SQLServer]Arithmetic overflow error converting _expression_ to data type int. 22001 there are no values in that column for that vehicleNumberoni they are all null, however, why would cfmx choke, its just null? thanks! ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: JVM settings for OS X - was: Re: Blue Dragon / Coral / CFMX
In the JMC, you need to change the JDK path to /System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Home. Matt Liotta R337 Consulting LLC http://r337.com On May 10, 2004, at 7:46 AM, Dick Applebaum wrote: Matt With my changes to your startup script I get the following results: -- The CFMX admin shows that the JVM 1.4.2-34 is being used for CFMX (this is the correct version) -- The JMC console shows that JVM 1.3.1is being used for JRun (this is not the correct version) In the past, I have been able to accomplish the above with info from Christian Cantrell's blog But I am concerned that the use of 2 different JVMs may cause problems. In response to an earlier thread, I tested some versions of a JRun updater that tried to address this issue. We were able to get JRun to use the latest JVM, but: -- we could not get CFMX to use the latest JVM with the JRun Updater -- there were other problems with the JMC with the JRun Updater installed Your script is probably adequate for development. I am trying to decide what to recommend to a client who wants to install CFMX (or possibly BD) on an XServe for production in a multi-homed environment. Each of the client's customers will use a unique domain to manage his private web and multimedia files (created by my client) The big issue is that CFMX is not supported for production on the OS X platform. Steven Erat clarified Macromedia's policy, quoted below. To minimize problems and maximize the potential for vendor support, it seems to make sense to run both JRun and CFMX on JVM 1.3.1 until Macromedia provides a solution that allows both to run on the latest JVM. Thanks for your help Start quote To the specific support question regarding CFMX on Mac OSX, while it continues to be policy that Macromedia doesn't support that configuration for production systems at this time, I believe that the spirit of the policy can be interpreted to mean that problems that are specific to Mac OSX and cannot be reproduced on other platforms will not qualify for escalated status or bug fixes, although I think it would be fair to say that Macromedia will in fact support such customers to the extent that the reported problem or question is not restricted to the Mac OSX platform. In fact, the support staff maintains a cohort of Mac OSX systems that are configured with CFMX and JRun to be used for this very scenario. Should anyone have an experience to the contrary when officially logging a support ticket, then I invite you to contact me so that I can help rectify the situation and perhaps even assist in providing the technical support myself. -Steven Erat Macromedia Server Product Support End Quote On May 8, 2004, at 10:25 AM, Matt Liotta wrote: My start script is as follows, which correctly uses Java 1.4.2. There is some stuff in this script that you obviously won't need, but I thought I would share it as is. cd /Applications/JRun4/bin PATH=$PATH:/Applications/JRun4/bin export PATH CLASSPATH=/Applications/JRun4/lib/jrun.jar:/Applications/JRun4/ servers/ lib/alchemy-jaas.jar:/Applica tions/JRun4/servers/lib/cfmx-j2ee.jar:/Applications/JRun4/servers/ lib/ cfmx-ssl.jar export CLASSPATH java -cp $CLASSPATH jrunx.kernel.JRun -start admin /Applications/JRun4/logs/default.out.log java -cp $CLASSPATH jrunx.kernel.JRun -start default /Applications/JRun4/logs/default.out.log java -cp $CLASSPATH jrunx.kernel.JRun -start bluedragon /Applications/JRun4/logs/default.out.log [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: does cf choke on database nulls?
that isnt ... altho' that wont return anything to cf either, however... the problem, I found out, is that there was a value in one of the fields that was longer than 9 characters, its actually 10 characters, numbers I mean and therefore a sum() on that doesn't jive, in query analyzer or cfmx. makes sense. thanks! tony -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 9:11 AM To: CF-Talk Subject: RE: does cf choke on database nulls? You need to alias it, Select sum(stoptime) as stoptime from reports jb -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 10 May 2004 14:13 To: CF-Talk Subject: does cf choke on database nulls? select sum(stopTime) from reports where vehicleNumberoni = 58444 returns a null in sql server query analyzer. same query ran from cfmx, gives this error: [Macromedia][SQLServer JDBC Driver][SQLServer]Arithmetic overflow error converting _expression_ to data type int. 22001 there are no values in that column for that vehicleNumberoni they are all null, however, why would cfmx choke, its just null? thanks! ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: does cf choke on database nulls?
its all good man! thanks anyway. tw -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 9:14 AM To: CF-Talk Subject: RE: does cf choke on database nulls? Duh! Ignore me...more coffee! -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED] Sent: 10 May 2004 14:11 To: CF-Talk Subject: RE: does cf choke on database nulls? You need to alias it, Select sum(stoptime) as stoptime from reports jb -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 10 May 2004 14:13 To: CF-Talk Subject: does cf choke on database nulls? select sum(stopTime) from reports where vehicleNumberoni = 58444 returns a null in sql server query analyzer. same query ran from cfmx, gives this error: [Macromedia][SQLServer JDBC Driver][SQLServer]Arithmetic overflow error converting _expression_ to data type int. 22001 there are no values in that column for that vehicleNumberoni they are all null, however, why would cfmx choke, its just null? thanks! ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: does cf choke on database nulls?
Looks like a driver error. Interesting that I am having a null problem in CFML (not the driver) with BlueDragon. I have been on this list for years and don't recall any posts where DB nulls were improperly handled by a driver or CFML.(there have been issues with how to logically handle nulls). But your issue and mine, both cause the program to crash. Dick On May 10, 2004, at 6:12 AM, Tony Weeg wrote: select sum(stopTime) from reports where vehicleNumberoni = 58444 returns a null in sql server query analyzer. same query ran from cfmx, gives this error: [Macromedia][SQLServer JDBC Driver][SQLServer]Arithmetic overflow error converting _expression_ to data type int. 22001 there are no values in that column for that vehicleNumberoni they are all null, however, why would cfmx choke, its just null? thanks! ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: does cf choke on database nulls?
dick, I happened to figure out that it wasn't a null issue tho' :) that's good! not for your problem tho. but, what I did figure out, is that I had bad data coming from the db, and the db wouldn't do the sum(), that was the problem.cfmx handled it great, from what I can tell. so what Ive done now, is put this: and len(lngStoppedTime) = 9 to prevent the issue. now to my backend developer, ill have to handle him later!! adios tw -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 9:26 AM To: CF-Talk Subject: Re: does cf choke on database nulls? Looks like a driver error. Interesting that I am having a null problem in CFML (not the driver) with BlueDragon. I have been on this list for years and don't recall any posts where DB nulls were improperly handled by a driver or CFML.(there have been issues with how to logically handle nulls). But your issue and mine, both cause the program to crash. Dick On May 10, 2004, at 6:12 AM, Tony Weeg wrote: select sum(stopTime) from reports where vehicleNumberoni = 58444 returns a null in sql server query analyzer. same query ran from cfmx, gives this error: [Macromedia][SQLServer JDBC Driver][SQLServer]Arithmetic overflow error converting _expression_ to data type int. 22001 there are no values in that column for that vehicleNumberonithey are all null, however, why would cfmx choke, its just null? thanks! ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Microsoft acknowledges CF!
The one thing that still sticks out to me (I went from ASP to CF almost 5 years ago) is just how much more difficult database interaction is when you're not using CF.I also explicitly DON'T like the presentation layer control that the display objects take away; that's fine if you're a developer with no HTML skills, but for us designer/developer/control freak types, it's pretty annoying. Pete Raymond Camden wrote: You know, I'm probably biased, but you have to love the fact that almost every code comparison shows CF having about half the lines .Net does. I like .Net, a lot, and yes, we all know the # of lines isn't the most important thing in the world, but it was funny how much this stood out, especially in the DB examples. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Microsoft acknowledges CF!
Boy isn't that the truth! They also only talked about the general functionality of CF. There are so many built in functions in CF that I think we all take for granted because they've been in there so long. Things like manipulating lists, queries, dates, display formatting. The list of CF's *real development benefits, IMHO, is huge. But these things are never discussed in comparisons with other languages. Steve _ From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 9:17 AM To: CF-Talk Subject: RE: Microsoft acknowledges CF! You know, I'm probably biased, but you have to love the fact that almost every code comparison shows CF having about half the lines .Net does. I like .Net, a lot, and yes, we all know the # of lines isn't the most important thing in the world, but it was funny how much this stood out, especially in the DB examples. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
homesite+ (how to stop a find search)
hi there. really a homesite+ question, but how do you stop the find/replace finder from finding things?lets say it locates what I wanted it to find for me, how do I say STOP, Look no more.I restart homesite+ now to do this, is there a better way? thanks! ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: JVM settings for OS X - was: Re: Blue Dragon / Coral / CFMX
Aha! That does it -- setting the JVM in the JMC, along with your startup script, gets both JRun and CFMX running under the latest JVM. What is odd, is that JRun and CFMX can't do this automatically-- OS X will default to the latest JVM unless the applications (JRun and CFMX) specifically request a prior version -- this was implemented to allow OS X apps to gracefully implement the latest JVM changes. Thanks Matt Dick On May 10, 2004, at 6:21 AM, Matt Liotta wrote: In the JMC, you need to change the JDK path to /System/Library/Frameworks/JavaVM.framework/Versions/1.4.2/Home. Matt Liotta R337 Consulting LLC http://r337.com On May 10, 2004, at 7:46 AM, Dick Applebaum wrote: Matt With my changes to your startup script I get the following results: -- The CFMX admin shows that the JVM 1.4.2-34 is being used for CFMX (this is the correct version) -- The JMC console shows that JVM 1.3.1is being used for JRun (this is not the correct version) In the past, I have been able to accomplish the above with info from Christian Cantrell's blog But I am concerned that the use of 2 different JVMs may cause problems. In response to an earlier thread, I tested some versions of a JRun updater that tried to address this issue. We were able to get JRun to use the latest JVM, but: -- we could not get CFMX to use the latest JVM with the JRun Updater -- there were other problems with the JMC with the JRun Updater installed Your script is probably adequate for development. I am trying to decide what to recommend to a client who wants to install CFMX (or possibly BD) on an XServe for production in a multi-homed environment. Each of the client's customers will use a unique domain to manage his private web and multimedia files (created by my client) The big issue is that CFMX is not supported for production on the OS X platform. Steven Erat clarified Macromedia's policy, quoted below. To minimize problems and maximize the potential for vendor support, it seems to make sense to run both JRun and CFMX on JVM 1.3.1 until Macromedia provides a solution that allows both to run on the latest JVM. Thanks for your help Start quote To the specific support question regarding CFMX on Mac OSX, while it continues to be policy that Macromedia doesn't support that configuration for production systems at this time, I believe that the spirit of the policy can be interpreted to mean that problems that are specific to Mac OSX and cannot be reproduced on other platforms will not qualify for escalated status or bug fixes, although I think it would be fair to say that Macromedia will in fact support such customers to the extent that the reported problem or question is not restricted to the Mac OSX platform. In fact, the support staff maintains a cohort of Mac OSX systems that are configured with CFMX and JRun to be used for this very scenario. Should anyone have an experience to the contrary when officially logging a support ticket, then I invite you to contact me so that I can help rectify the situation and perhaps even assist in providing the technical support myself. -Steven Erat Macromedia Server Product Support End Quote On May 8, 2004, at 10:25 AM, Matt Liotta wrote: My start script is as follows, which correctly uses Java 1.4.2. There is some stuff in this script that you obviously won't need, but I thought I would share it as is. cd /Applications/JRun4/bin PATH=$PATH:/Applications/JRun4/bin export PATH CLASSPATH=/Applications/JRun4/lib/jrun.jar:/Applications/JRun4/ servers/ lib/alchemy-jaas.jar:/Applica tions/JRun4/servers/lib/cfmx-j2ee.jar:/Applications/JRun4/servers/ lib/ cfmx-ssl.jar export CLASSPATH java -cp $CLASSPATH jrunx.kernel.JRun -start admin /Applications/JRun4/logs/default.out.log java -cp $CLASSPATH jrunx.kernel.JRun -start default /Applications/JRun4/logs/default.out.log java -cp $CLASSPATH jrunx.kernel.JRun -start bluedragon /Applications/JRun4/logs/default.out.log [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
re: homesite+ (how to stop a find search)
I haven't tried this in Homesite+, but in Homesite and CF Studio, hitting ESC usually does it. Scott --- Scott Brady http://www.scottbrady.net/ Original Message: From: Tony Weeg Date: Mon, 10 May 2004 09:38:47 -0400 hi there. really a homesite+ question, but how do you stop the find/replace finder from finding things?lets say it locates what I wanted it to find for me, how do I say STOP, Look no more.I restart homesite+ now to do this, is there a better way? thanks! ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: homesite+ (how to stop a find search)
works GREAT! thanks. tony -Original Message- From: Scott Brady [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 9:43 AM To: CF-Talk Subject: re: homesite+ (how to stop a find search) I haven't tried this in Homesite+, but in Homesite and CF Studio, hitting ESC usually does it. Scott --- Scott Brady http://www.scottbrady.net/ Original Message: From: Tony Weeg Date: Mon, 10 May 2004 09:38:47 -0400 hi there. really a homesite+ question, but how do you stop the find/replace finder from finding things?lets say it locates what I wanted it to find for me, how do I say STOP, Look no more.I restart homesite+ now to do this, is there a better way? thanks! ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: homesite+ (how to stop a find search)
Press the ESC key. Steve Nelson _ From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 9:39 AM To: CF-Talk Subject: homesite+ (how to stop a find search) hi there. really a homesite+ question, but how do you stop the find/replace finder from finding things?lets say it locates what I wanted it to find for me, how do I say STOP, Look no more.I restart homesite+ now to do this, is there a better way? thanks! ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Microsoft acknowledges CF!
I have done some ASP coding -- mainly converting programs to CF. Not only is a lot more work (in ASP) to put together a SQL query, there are a lot of things to keep track of -- if you forget to close the connection it can affect performance, etc, Number of lines is not everything -- but a more compact, concise procedure is easier to understand. Also, CF tags tend to be less granular, less cryptic (more self-documenting) -- this is significant in maintaining the code over time. Dick On May 10, 2004, at 6:33 AM, Pete Ruckelshaus - CFList wrote: The one thing that still sticks out to me (I went from ASP to CF almost 5 years ago) is just how much more difficult database interaction is when you're not using CF. I also explicitly DON'T like the presentation layer control that the display objects take away; that's fine if you're a developer with no HTML skills, but for us designer/developer/control freak types, it's pretty annoying. Pete Raymond Camden wrote: You know, I'm probably biased, but you have to love the fact that almost every code comparison shows CF having about half the lines .Net does. I like .Net, a lot, and yes, we all know the # of lines isn't the most important thing in the world, but it was funny how much this stood out, especially in the DB examples. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Microsoft acknowledges CF!
They also only talked about the general functionality of CF. There are so many built in functions in CF that I think we all take for granted because they've been in there so long. Things like manipulating lists, queries, dates, display formatting. The list of CF's *real development benefits, IMHO, is huge. But these things are never discussed in comparisons with other languages. When comparing CF to classic ASP, this was true. However, the .Net framework provides a much richer environment. You're no longer limited so a small number of VBScript or JScript functions. To a certain extent, you can achieve this in CF with Java. However, CF's Java support is relatively shallow. Additionally, it requires knowing a second, much more complicated language. In contrast, VB, Jscript, and C# are all first class .Net languages. You can utilize just about anything in the .Net framework. -ben [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Microsoft acknowledges CF!
What do you mean by shallow support? Honestly I almost never used Java in CF since CF has almost everything I ever needed. Once should also look at what is needed, not what can be done. Sure C#.Net offers a lot, but you only really need a fraction of that for the web. The specialization of a language is good thing, the stripping down of C/C++ into C# is all about that. However, in my opinion, they don't much CF specialization. TK -Original Message- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 10:11 AM To: CF-Talk Subject: RE: Microsoft acknowledges CF! When comparing CF to classic ASP, this was true. However, the .Net framework provides a much richer environment. You're no longer limited so a small number of VBScript or JScript functions. To a certain extent, you can achieve this in CF with Java. However, CF's Java support is relatively shallow. Additionally, it requires knowing a second, much more complicated language. In contrast, VB, Jscript, and C# are all first class .Net languages. You can utilize just about anything in the .Net framework. -ben [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Microsoft acknowledges CF!
One thing nice about the .NET Framework is that if an application is designed well it is easy (fairly) to make it available in many formats (web site, windows app, pocket pc app), I think that is one of the reasons it is built like it is.It is nice to have that ability to port the software to different platforms easily like that, just have to change the UI and everything else works the same.ASP.NET is definitely better then classic ASP, but CF still has better and easier coding.Just like everyone has said, CF is the best thing I have seen yet for getting information in and out of a database. Bernd VanSkiver [EMAIL PROTECTED] 801.520.5957 -Original Message- From: Tom Kitta [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 8:26 AM To: CF-Talk Subject: RE: Microsoft acknowledges CF! What do you mean by shallow support? Honestly I almost never used Java in CF since CF has almost everything I ever needed. Once should also look at what is needed, not what can be done. Sure C#.Net offers a lot, but you only really need a fraction of that for the web. The specialization of a language is good thing, the stripping down of C/C++ into C# is all about that. However, in my opinion, they don't much CF specialization. TK -Original Message- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 10:11 AM To: CF-Talk Subject: RE: Microsoft acknowledges CF! When comparing CF to classic ASP, this was true. However, the .Net framework provides a much richer environment. You're no longer limited so a small number of VBScript or JScript functions. To a certain extent, you can achieve this in CF with Java. However, CF's Java support is relatively shallow. Additionally, it requires knowing a second, much more complicated language. In contrast, VB, Jscript, and C# are all first class .Net languages. You can utilize just about anything in the .Net framework. -ben [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Microsoft acknowledges CF!
Is there a way to use CF code outside of a server, stand alone executable (without any server like software including that mini server offered for presentation purposes)? In other words can I compile a cf page and save it in cgi directory? I am just curious since now CF page is compiled before it executes, could code compiled by CF server be used? TK -Original Message- From: Bernd VanSkiver [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 10:44 AM To: CF-Talk Subject: RE: Microsoft acknowledges CF! One thing nice about the .NET Framework is that if an application is designed well it is easy (fairly) to make it available in many formats (web site, windows app, pocket pc app), I think that is one of the reasons it is built like it is.It is nice to have that ability to port the software to different platforms easily like that, just have to change the UI and everything else works the same.ASP.NET is definitely better then classic ASP, but CF still has better and easier coding.Just like everyone has said, CF is the best thing I have seen yet for getting information in and out of a database. Bernd VanSkiver [EMAIL PROTECTED] 801.520.5957 -Original Message- From: Tom Kitta [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 8:26 AM To: CF-Talk Subject: RE: Microsoft acknowledges CF! What do you mean by shallow support? Honestly I almost never used Java in CF since CF has almost everything I ever needed. Once should also look at what is needed, not what can be done. Sure C#.Net offers a lot, but you only really need a fraction of that for the web. The specialization of a language is good thing, the stripping down of C/C++ into C# is all about that. However, in my opinion, they don't much CF specialization. TK -Original Message- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 10:11 AM To: CF-Talk Subject: RE: Microsoft acknowledges CF! When comparing CF to classic ASP, this was true. However, the .Net framework provides a much richer environment. You're no longer limited so a small number of VBScript or JScript functions. To a certain extent, you can achieve this in CF with Java. However, CF's Java support is relatively shallow. Additionally, it requires knowing a second, much more complicated language. In contrast, VB, Jscript, and C# are all first class .Net languages. You can utilize just about anything in the .Net framework. -ben [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Microsoft acknowledges CF!
From: Tom Kitta Is there a way to use CF code outside of a server, stand alone executable (without any server like software including that mini server offered for presentation purposes)? In other words can I compile a cf page and save it in cgi directory? I am just curious since now CF page is compiled before it executes, could code compiled by CF server be used? CFMX natually compiles it's code into Java classes, but I don't think these are transportable to another stand alone machine I believe BlueDragon does something towards this though [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Microsoft acknowledges CF!
CFSTARTIgnore... just a subscription test msg.. CFEND [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Web services that return/set multiple variables.
Update,
>From searching google for a couple of hours, the only suggested answer
I've seen is to write a .NET webservice and use that as a proxy, anybody
got a better idea or workaround?
To be honest CF's ws stuff appears to be about as compatible with other
scripting languages as a large square peg and small round whole. VERY
frustrating to say the least.
-Original Message-
From: Craig Dudley
Sent: 10 May 2004 11:00
To: CF-Talk
Subject: Web services that return/set multiple variables.
We're trying to consume a suppliers webservice, described as follows;
GetNumberOfEntries(
[in] STR account,
[in] STR password,
[out] LONG* longOutCount,
[out] STR* OutErrorMessage,
[out,retval] LONG* longOutStatus
);
No matter how I call the webservice we get the following back;
Web service operation getNumberOfEntries with parameters
{account={blah},password={blah},RETURN={},} could not be found.
I can only assume that it's the fact that this service can return
multiple variables, and this is something which doesn't appear possible
with coldfusion webservices.
I have tried all sorts, passing in all 5 of the params etc, but no luck.
Anyone have an experience with this sort of thing? Any work arounds? I
don't fancy doing the SOAP manually as this is just one of a dozen
functions, the rest of which are much more complex.
Craig Dudley
Senior Developer
Netstep Corporate Communications Ltd
Direct Line: +44(0) 1422 319712
Phone: +44(0) 1422 200308
Fax: +44(0) 1422 200306
e-mail: [EMAIL PROTECTED]
MS Messenger: [EMAIL PROTECTED]
www: www.netstep.co.uk
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Search solution.
Hey guys I want to set up a search on my personal site for my products. I have tried to use the verity collection but it just does not seem to do what I want. I need something that can simply spider my site and collect the information and links to the products. The site is very dynamic and it uses SES urls. Is there something that can do this already or can this be done with Verity? My site uses a lot of templates and includes files and this seems to mess up the verity search. Thanks for any ideas... Neal Bailey http://www.blissfulessence.com/ www.blissfulessence.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Stand alone CF application on a laptop
hey everyone. i would like to setup a cf application on a laptop running sql server as the backend db and iis as the webserver. does anyknow know of a good resource that laysout how to set this type of environment up? is there a copy of a personal cf application server out there for download? thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Stand alone CF application on a laptop
The 30 day free trial version of CF server reverts to a local host only developers version after the trial period.It would be exactly what you want. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Stand alone CF application on a laptop
Looks like that is for MX, is there one for cf 5? -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 11:57 AM To: CF-Talk Subject: RE: Stand alone CF application on a laptop The 30 day free trial version of CF server reverts to a local host only developers version after the trial period.It would be exactly what you want. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Stand alone CF application on a laptop
This is how it has worked since at least 4.5.It is how I have gotten my developer version of CF sever since I started in 1997.You just need to find the proper download on the Macromedia Site.That, at times, has been a lot harder then it should have been. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: schedule admin and SSL
Hi, Here is more information from the application log. This job is setup as https://cfm and port = 443 in cfadmin. This is on w2k server and cf is assigned to the system account. The entire web server has a certificate, so i guess everything must use 'https' aaa web server name,application,Error,1092,05/10/04,10:45:11,,, , 401 UnauthorizedP PPDate/Time: 05/10/04 10:45:11BRBrowser: BRRemote Address: BRQuery String: TASK=omrs_daily_job_checkP TIA, Patrick Whittingham United Space Alliance AES - Data Warehouse -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 5:09 AM To: CF-Talk Subject: Re: schedule admin and SSL On Friday 07 May 2004 17:25 pm, Whittingham, P wrote: I try to schedule a cfm page in cfadmin on a web server which has ssl. I even use port 443 with no success. Any help would be appreciated. Do you get an error in the CF logs ? What outputs if you tick the box to dump the request to a file ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX 6.1 and Order By Error
I'm having a very strange problem with CFMX. I'm creating a very simply query. cfquery name=GetACDReports datasource=telecom dbtype=ODBC debug SELECT ACDReports.ReportID, ACDReports.Site, ACDReports.Section, ACDReports.ReportName FROM ACDReports ORDER BY ACDReports.Site,ACDReports.Section,ACDReports.ReportName /cfquery However, when I add more than one field to the Order By portion of SQL statement I get a rather nondescript database error: Error Executing Database Query.The error occurred in D:\inetpub\wwwroot\Telecom\ACD_Reports\ACD_Report_TOC_new.cfm: line 1 1 : cfquery name=GetACDReports datasource=telecom dbtype=ODBC debug2 : SELECT ACDReports.ReportID, ACDReports.Site, ACDReports.Section, ACDReports.ReportName3 : FROM ACDReportsSQLSELECT ACDReports.ReportID, ACDReports.Site, ACDReports.Section, ACDReports.ReportName FROM ACDReports ORDER BY ACDReports.Site,ACDReports.Section,ACDReports.ReportName DATASOURCE telecomSQLSTATEnbsp; ... Exceptions 08:31:44.044 - Database Exception - in D:\inetpub\wwwroot\Telecom\ACD_Reports\ACD_Report_TOC_new.cfm : line 1 Error Executing Database Query.Any ideas? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Flash Speed?
I know you can determine if someone has Flash installed. Is there anyway to determine the speed of the connection, where it is Dial-up? DSL? LAN? Basically I need to find out if their speed is fast enough to use Flash or Static images. TIA [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: XMLParse() Throwing Error - Shared Hosting
You can just call listRest twice (or use listDeleteAt() if you prefer), passing chr(10) as the delimiter.Exactly the same thing as you do, just minus the array conversions. Cheers, barneyb -Original Message- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] Sent: Sunday, May 09, 2004 6:16 PM To: CF-Talk Subject: RE: XMLParse() Throwing Error - Shared Hosting snip / To correct the issue I did the following: cfset NewsFeed = CFHTTP.FileContent cfset ConvertFeed = ListToArray(NewsFeed, #CHR(10)#) cfset temp = ArrayDeleteAt(ConvertFeed, 2) cfset temp = ArrayDeleteAt(ConvertFeed, 2) cfset NewsFeed = ArrayToList(ConvertFeed, #CHR(10)#) cfset ThisNewsListing = XMLParse(NewsFeed) That converts the feed to an array, takes out the first two lines (which are the DTD lines) and then converts it back to a list.I tried doing a simple replace first and it didn't work. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Flash Speed?
Give the user the option! HTH Dick On May 10, 2004, at 9:15 AM, Adkins, Randy wrote: I know you can determine if someone has Flash installed. Is there anyway to determine the speed of the connection, where it is Dial-up? DSL? LAN? Basically I need to find out if their speed is fast enough to use Flash or Static images. TIA [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Flash Speed?
Yeah that was the only option I came up with. -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 12:37 PM To: CF-Talk Subject: Re: Flash Speed? Give the user the option! HTH Dick On May 10, 2004, at 9:15 AM, Adkins, Randy wrote: I know you can determine if someone has Flash installed. Is there anyway to determine the speed of the connection, where it is Dial-up? DSL? LAN? Basically I need to find out if their speed is fast enough to use Flash or Static images. TIA _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: schedule admin and SSL
Here is more information from the application log. This job is setup as https://cfm and port = 443 in cfadmin. This is on w2k server and cf is assigned to the system account. The entire web server has a certificate, so i guess everything must use 'https' aaa web server name,application,Error,1092,05/10/04,10:45:11,,, , 401 UnauthorizedP PPDate/Time: 05/10/04 10:45:11BRBrowser: BRRemote Address: BRQuery String: TASK=omrs_daily_job_checkP It looks to me like you're not allowing anonymous access to that page. If you're using Basic Authentication, you'll need to pass the username and password within your scheduled task request. If you're using something other than Basic Authentication, the scheduled task won't work. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Client Variables not written to database
We're starting the process of upgrading our server from CF5 to MX 6.1 and am running into problems with client variables not sticking. We are storing client variables in an Oracle database.I have a test script which first dumps the client variables, then sets a test client variable, and then dumps the client again. When I run the page once, the first dump doesn't have the new variable, but the second one does (as expected). If I run it again, however, the first dump still doesn't have the new variable. If I look at the data in the database, that variable is not in the data, either. So, it appears the new client info isn't getting set in the database. I haven't been able to find a technote on this, so was wondering if anyone had some ideas. Thanks. Scott --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Flash Speed?
Yep...go with allowing the user to chose. I just went through browser detection scenarios for a site we just launched and chose to warn users with browsers we have not yet tested (although they use browser engines that are used in browsers we've tested).We simply re-direct them to a warning page that tells them we haven't tested the site with their browser but we think it should work fine...so if something does go wrong it's most likley a result of their browser. Well all we are doing is covering our butt because we don't want any negative word of mouth.So far I've found that even that warning is cheesing off some people!!So ya..if possible...don't just take controlexplain the situation and leave it up to the user. my 2 cents Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Flash Speed?
You can load a flash movie, start a timer in the movie, load an image from your server, check how long it took, and then decided based on that. 'course that's probably not really how you want to approach the situation, but it'll work. Cheers, barneyb -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 9:15 AM To: CF-Talk Subject: Flash Speed? I know you can determine if someone has Flash installed. Is there anyway to determine the speed of the connection, where it is Dial-up? DSL? LAN? Basically I need to find out if their speed is fast enough to use Flash or Static images. TIA [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Named anchor
On May 10, 2004, at 7:37 AM, Pascal Peters wrote: Is it possible to find a named anchor passed in the url (if there is one) in ColdFusion? I don't think there is a way.The named anchor (anything after the hash symbol in a URL) does not get sent to the server, and therefore does not show up in variables like CGI.SCRIPT_NAME. If you really need it, you might have to do something like this: http://localhost/tests/index.cfm?anchorName=foo#foo The anchor name is then available as the value of the variable url.anchorName. Christian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMAIL 6.1 ARRGH!
Does anybody know if the hot fix for this problem is out yet? If so where can I find it at. Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Microsoft acknowledges CF!
I think you can do this a few different ways, but essentially you still need a local application server to execute the pages. With CFMX you could use the developer copy which I think is free for localhost usage. BD offers a free version that I think is only CF5 compatible. Maybe I'm wrong. Coral offers a standalone server specifically for this reason. It has a shorter list of tags/functions but a few new ones that are specific to local applications. http://www.pcaonline.com/coral/index.cfm Steve _ From: Tom Kitta [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 11:02 AM To: CF-Talk Subject: RE: Microsoft acknowledges CF! Is there a way to use CF code outside of a server, stand alone executable (without any server like software including that mini server offered for presentation purposes)? In other words can I compile a cf page and save it in cgi directory? I am just curious since now CF page is compiled before it executes, could code compiled by CF server be used? TK -Original Message- From: Bernd VanSkiver [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 10:44 AM To: CF-Talk Subject: RE: Microsoft acknowledges CF! One thing nice about the .NET Framework is that if an application is designed well it is easy (fairly) to make it available in many formats (web site, windows app, pocket pc app), I think that is one of the reasons it is built like it is.It is nice to have that ability to port the software to different platforms easily like that, just have to change the UI and everything else works the same.ASP.NET is definitely better then classic ASP, but CF still has better and easier coding.Just like everyone has said, CF is the best thing I have seen yet for getting information in and out of a database. Bernd VanSkiver [EMAIL PROTECTED] 801.520.5957 -Original Message- From: Tom Kitta [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 8:26 AM To: CF-Talk Subject: RE: Microsoft acknowledges CF! What do you mean by shallow support? Honestly I almost never used Java in CF since CF has almost everything I ever needed. Once should also look at what is needed, not what can be done. Sure C#.Net offers a lot, but you only really need a fraction of that for the web. The specialization of a language is good thing, the stripping down of C/C++ into C# is all about that. However, in my opinion, they don't much CF specialization. TK -Original Message- From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 10:11 AM To: CF-Talk Subject: RE: Microsoft acknowledges CF! When comparing CF to classic ASP, this was true. However, the .Net framework provides a much richer environment. You're no longer limited so a small number of VBScript or JScript functions. To a certain extent, you can achieve this in CF with Java. However, CF's Java support is relatively shallow. Additionally, it requires knowing a second, much more complicated language. In contrast, VB, Jscript, and C# are all first class .Net languages. You can utilize just about anything in the .Net framework. -ben _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX 6.1 and Order By Error
It's hard to tell from the line wrapping, but it looks like you're trying to do a union of two selects, but you left out the union operator. Is that what you're doing? Also, try removing the table names from the order by clause. Steve Nelson _ From: Eric Davis [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 12:14 PM To: CF-Talk Subject: CFMX 6.1 and Order By Error I'm having a very strange problem with CFMX. I'm creating a very simply query. cfquery name=GetACDReports datasource=telecom dbtype=ODBC debug SELECT ACDReports.ReportID, ACDReports.Site, ACDReports.Section, ACDReports.ReportName FROM ACDReports ORDER BY ACDReports.Site,ACDReports.Section,ACDReports.ReportName /cfquery However, when I add more than one field to the Order By portion of SQL statement I get a rather nondescript database error: Error Executing Database Query.The error occurred in D:\inetpub\wwwroot\Telecom\ACD_Reports\ACD_Report_TOC_new.cfm: line 1 1 : cfquery name=GetACDReports datasource=telecom dbtype=ODBC debug2 : SELECT ACDReports.ReportID, ACDReports.Site, ACDReports.Section, ACDReports.ReportName3 : FROM ACDReportsSQLSELECT ACDReports.ReportID, ACDReports.Site, ACDReports.Section, ACDReports.ReportName FROM ACDReports ORDER BY ACDReports.Site,ACDReports.Section,ACDReports.ReportName DATASOURCE telecomSQLSTATEnbsp; ... Exceptions 08:31:44.044 - Database Exception - in D:\inetpub\wwwroot\Telecom\ACD_Reports\ACD_Report_TOC_new.cfm : line 1 Error Executing Database Query.Any ideas? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFTicket 2 released
Just wanted to let everyone know that we have released CFTicket 2. I want to thank everyone on the list who helped us out in the beta testing. Because of all the great people, I am giving 20% off the current price as a thank you to everyone here. You can get more details at http://www.cornfeed.com or email me off-list if you have any questions. Cedric [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Microsoft acknowledges CF!
What do you mean by shallow support? There's a good deal of Java that simply can't be used directly from within CF. A lack of support for null values is a big reason. There's also a good deal that requires workarounds or hacks. It's certainly possible to use a lot of Java from within CF, but it requires 1) knowing a second language and 2) knowing Java well enough to be able to workaround the implementation details. In contrast, Visual Basic, Jscript and C# are all first class .Net languages. This means that they can treat anything in the .Net Framework as a native object (with a few exceptions). So, a VB programmer doesn't have to learn a new language to implement something in the .Net Framework. Honestly I almost never used Java in CF since CF has almost everything I ever needed. I agree for the most part. I can program most Web sites completely in ColdFusion, and in most cases that is perfectly reasonable. However, for example, there are many times where it would be preferable to use a data type other than a struct or an array. I can now create my own data types using CFCs, but that's not nearly as nice as having every common (and some not so common) data types pre-built for me. My point isn't that I can't do most of what I need to in ColdFusion. It's just that the old arguments no longer apply. It used to be the case that ColdFusion offered an environment that was much richer than other competing platforms such as ASP. I do not believe this to be the case anymore. I believe ColdFusion is on par with most other platforms and that it offers most of the functionality that I need to develop most Web applications without resorting to coding COM objects or Java classes, or purchasing third party components. As a side note, the biggest notable exception from my perspective is image manipulation. I'd love some native image tags. I'm hoping that the jimg tag off the resource kit makes it into the next release of ColdFusion. Once should also look at what is needed, not what can be done. Sure C#.Net offers a lot, but you only really need a fraction of that for the web. I only need a fraction for any given Web site, yes. However, I need different pieces for different Web sites. In some Web sites, image manipulation is a big deal. In others, COM interoperability is important. -ben [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX 6.1 and Order By Error
section is a reserved word. That bit us recently. Is that the column that kills it? -d - Original Message - From: Eric Davis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 10, 2004 11:14 AM Subject: CFMX 6.1 and Order By Error I'm having a very strange problem with CFMX. I'm creating a very simply query. cfquery name=GetACDReports datasource=telecom dbtype=ODBC debug SELECT ACDReports.ReportID, ACDReports.Site, ACDReports.Section, ACDReports.ReportName FROM ACDReports ORDER BY ACDReports.Site,ACDReports.Section,ACDReports.ReportName /cfquery However, when I add more than one field to the Order By portion of SQL statement I get a rather nondescript database error: Error Executing Database Query.The error occurred in D:\inetpub\wwwroot\Telecom\ACD_Reports\ACD_Report_TOC_new.cfm: line 1 1 : cfquery name=GetACDReports datasource=telecom dbtype=ODBC debug2 : SELECT ACDReports.ReportID, ACDReports.Site, ACDReports.Section, ACDReports.ReportName3 : FROM ACDReportsSQLSELECT ACDReports.ReportID, ACDReports.Site, ACDReports.Section, ACDReports.ReportName FROM ACDReports ORDER BY ACDReports.Site,ACDReports.Section,ACDReports.ReportName DATASOURCE telecomSQLSTATEnbsp; ... Exceptions 08:31:44.044 - Database Exception - in D:\inetpub\wwwroot\Telecom\ACD_Reports\ACD_Report_TOC_new.cfm : line 1 Error Executing Database Query.Any ideas? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX 6.1 and Order By Error
Adding to that, in that case it was specifically in a QueryOfQuery and referencing section as [section] made it work. -Kevin - Original Message - From: Deanna Schneider section is a reserved word. That bit us recently. Is that the column that kills it? -d [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Namespaces in XMLParse() file...
Are there any tricks to get CFMX to parse a XML file with referenced or unreferenced namespaces in them? I have a XML file that I can read just fine, but when I try to run a XMLParse() on the variable, it throws me a NAMESPACE_ERR error. And if I take out the tag with the namespace in it, it works just fine: tests one name=something value=else / test:uno test=oh no /!-- this throws an error -- two name=something value=else / /tests Tyler S. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Namespaces in XMLParse() file...
As usual, I figured out part of this right after I hit sent on my message: tests xmlns:test=http://www.test.com one name=something value=else / test:uno test=oh no / two name=something value=else / /tests If I add the namespace declaration to the root element, it won't throw an error. I know it is not quite proper, but is there a way to get around declaring the namespace in the root element? I'd like to declare before the root element if I couldis this possible or is CF pretty stringent about it's only one root element rule? Tyler S. _ From: Tyler Silcox [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 1:58 PM To: CF-Talk Subject: Namespaces in XMLParse() file... Are there any tricks to get CFMX to parse a XML file with referenced or unreferenced namespaces in them? I have a XML file that I can read just fine, but when I try to run a XMLParse() on the variable, it throws me a NAMESPACE_ERR error. And if I take out the tag with the namespace in it, it works just fine: tests one name=something value=else / test:uno test=oh no /!-- this throws an error -- two name=something value=else / /tests Tyler S. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Namespaces in XMLParse() file...
Namespaces apply to the current tag, and all decendants, you the tag that declares the namespace can be from that namespace: test:myTag xmlns:test= test:myOtherTag / /test:myTag XML is stringent about single root elements, and since CF's implementation adheres, it won't let you have multiple ones.However, if you need to add it dynamically, it's simple.Check if there is an xml declaration, check if there's a DOCTYPE declaration, and the first that's not part of either of those is the end of the root element.Just replace it with the namespace you need, plus the bracket. Cheers, barneyb -Original Message- From: Tyler Silcox [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 11:04 AM To: CF-Talk Subject: RE: Namespaces in XMLParse() file... As usual, I figured out part of this right after I hit sent on my message: tests xmlns:test=http://www.test.com one name=something value=else / test:uno test=oh no / two name=something value=else / /tests If I add the namespace declaration to the root element, it won't throw an error. I know it is not quite proper, but is there a way to get around declaring the namespace in the root element? I'd like to declare before the root element if I couldis this possible or is CF pretty stringent about it's only one root element rule? Tyler S. _ From: Tyler Silcox [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 1:58 PM To: CF-Talk Subject: Namespaces in XMLParse() file... Are there any tricks to get CFMX to parse a XML file with referenced or unreferenced namespaces in them? I have a XML file that I can read just fine, but when I try to run a XMLParse() on the variable, it throws me a NAMESPACE_ERR error. And if I take out the tag with the namespace in it, it works just fine: tests one name=something value=else / test:uno test=oh no /!-- this throws an error -- two name=something value=else / /tests Tyler S. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF sending data to a local printer?
It's been requested that I create this form that when gets submitted sends the content to a printer ( in the persons place of business ). I've never done anything like that before. Was wondering if it was even possible. Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF sending data to a local printer?
This is not possible unless you use ActiveX or a client side Java applet.Trust me.We tried.The closest you can get is something like doing a body onload() event in _javascript_ and have it call the print() function; this would bring up the print applet, so it would require the user to click the print button. Pete Daniel Farmer wrote: It's been requested that I create this form that when gets submitted sends the content to a printer ( in the persons place of business ). I've never done anything like that before. Was wondering if it was even possible. Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF sending data to a local printer?
in IE you can bypass the printer dialogue box without ActiveX or client side
Java applet...
script
function noDialog (numcopy) {
var i = 1;
for (i; i==numcopy; i++) {
if ((navigator.appName == Netscape)) {
window.print()
} else {
var mybrowser = OBJECT ID='brwsr' WIDTH=0 HEIGHT=0
CLASSID=''/OBJECT;
document.body.insertAdjacentHTML('beforeEnd', mybrowser);
brwsr.ExecWB(6, -1)
}
}
/script
form name=prnform
How many copies: input type=text name=prnumber
input type=button >
/form
(but is it a bug, or is it a feature?) :)
- Original Message -
From: Pete Ruckelshaus - CFList [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, May 10, 2004 11:24 AM
Subject: Re: CF sending data to a local printer?
This is not possible unless you use ActiveX or a client side Java
applet.Trust me.We tried.The closest you can get is something like
doing a body onload() event in _javascript_ and have it call the print()
function; this would bring up the print applet, so it would require the
user to click the print button.
Pete
Daniel Farmer wrote:
It's been requested that I create this form that when gets submitted
sends the content to a printer ( in the persons place of business ).
I've never done anything like that before. Was wondering if it was even
possible.
Thanks
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: CF sending data to a local printer?
From: Daniel Farmer It's been requested that I create this form that when gets submitted sends the content to a printer ( in the persons place of business ). I've never done anything like that before. Was wondering if it was even possible. Because it's on the client's machine, you only have a certain amount of control - it requires some user intervention to get it to work 100% Use the _javascript_ function document.print() and it will open the print dialog, but that's as far as you can go [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF sending data to a local printer?
You mean an applet that is always on, always running right? and checks for print alerts? - Original Message - From: Pete Ruckelshaus - CFList To: CF-Talk Sent: Monday, May 10, 2004 2:24 PM Subject: Re: CF sending data to a local printer? This is not possible unless you use ActiveX or a client side Java applet.Trust me.We tried.The closest you can get is something like doing a body onload() event in _javascript_ and have it call the print() function; this would bring up the print applet, so it would require the user to click the print button. Pete Daniel Farmer wrote: It's been requested that I create this form that when gets submitted sends the content to a printer ( in the persons place of business ). I've never done anything like that before. Was wondering if it was even possible. Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF sending data to a local printer?
Yes, the page to be printed would contain this applet.We are using this method for one of our applications. Pete Daniel Farmer wrote: You mean an applet that is always on, always running right? and checks for print alerts? - Original Message - From: Pete Ruckelshaus - CFList To: CF-Talk Sent: Monday, May 10, 2004 2:24 PM Subject: Re: CF sending data to a local printer? This is not possible unless you use ActiveX or a client side Java applet.Trust me.We tried.The closest you can get is something like doing a body onload() event in _javascript_ and have it call the print() function; this would bring up the print applet, so it would require the user to click the print button. Pete Daniel Farmer wrote: It's been requested that I create this form that when gets submitted sends the content to a printer ( in the persons place of business ). I've never done anything like that before. Was wondering if it was even possible. Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF sending data to a local printer?
My guess here is that you envision someone on the internet is browsing a web site and fills out a form. You want that form to print on the web site owners printer? I think that's a WILD idea... however it is only possible if the CF server has network access to the printer.Is the CF server in the web site owners offices or on his intranet?If not, is the web site owners printer exposed to the internet?(...bad idea!) If there is no direct access by CF to the web site owners network perhaps some work around where CF writes files to an ftp directory and then some process runs in the web site owners offices (a delphi or vb program or script or some other windows routine), that is busyreading that ftp directory and downloads and prints the forms... doable yes... practical... that depends upon the value of the information in the form. At 11:24 AM 5/10/04, you wrote: It's been requested that I create this form that when gets submitted sends the content to a printer ( in the persons place of business ). I've never done anything like that before. Was wondering if it was even possible. Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Error with CFINPUT
Hi gang, I have a form using the 'required' attribute of CFINPUT for form validation. It works on one server but not another. By not working, I mean it does not prompt the user to fill out a field. Both servers are running 6.0. Any ideas? Dan Phillips CFXHosting.com [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Error with CFINPUT
Does the 2nd site have the CFIDE mapping in IIS?If not, the cfform.js script will not be loaded and the validation won't take place. -- Marlon Moyer, Sr. Internet Developer American Contractors Insurance Group phone: 972.687.9445 fax: 972.687.0607 mailto:[EMAIL PROTECTED] www.acig.com -Original Message- From: Dan Phillips [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 2:06 PM To: CF-Talk Subject: Error with CFINPUT Hi gang, I have a form using the 'required' attribute of CFINPUT for form validation. It works on one server but not another. By not working, I mean it does not prompt the user to fill out a field. Both servers are running 6.0. Any ideas? Dan Phillips CFXHosting.com [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF sending data to a local printer?
The question is though is how does that applet see the printer ? - Original Message - From: Pete Ruckelshaus - CFList To: CF-Talk Sent: Monday, May 10, 2004 3:01 PM Subject: Re: CF sending data to a local printer? Yes, the page to be printed would contain this applet.We are using this method for one of our applications. Pete Daniel Farmer wrote: You mean an applet that is always on, always running right? and checks for print alerts? - Original Message - From: Pete Ruckelshaus - CFList To: CF-Talk Sent: Monday, May 10, 2004 2:24 PM Subject: Re: CF sending data to a local printer? This is not possible unless you use ActiveX or a client side Java applet.Trust me.We tried.The closest you can get is something like doing a body onload() event in _javascript_ and have it call the print() function; this would bring up the print applet, so it would require the user to click the print button. Pete Daniel Farmer wrote: It's been requested that I create this form that when gets submitted sends the content to a printer ( in the persons place of business ). I've never done anything like that before. Was wondering if it was even possible. Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Error with CFINPUT
Thanks Marlon. That did it! -Original Message- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 3:09 PM To: CF-Talk Subject: RE: Error with CFINPUT Does the 2nd site have the CFIDE mapping in IIS?If not, the cfform.js script will not be loaded and the validation won't take place. -- Marlon Moyer, Sr. Internet Developer American Contractors Insurance Group phone: 972.687.9445 fax: 972.687.0607 mailto:[EMAIL PROTECTED] www.acig.com -Original Message- From: Dan Phillips [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 2:06 PM To: CF-Talk Subject: Error with CFINPUT Hi gang, I have a form using the 'required' attribute of CFINPUT for form validation. It works on one server but not another. By not working, I mean it does not prompt the user to fill out a field. Both servers are running 6.0. Any ideas? Dan Phillips CFXHosting.com [EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
BlogMX.zip
Benorama site seems to down most of the time. Can someone please send me the example BlogMX.zip file offlist. TIA Nikhil [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
COM and WDDX
Hi Folks,
I recently outsourced a project to some developers and am having some
issues and would appreciate any advice you may be able to offer. Basically
they were contracted to develop a client side app (Written in Delphi) that
would connect to a CFMX webservice and download recordset data. Thats it in
a nutshell.
On the server side, I was originally using the script at the bottom of this
email to convert the recordset to XML and send it to the client. This
worked fine, but it started to take a real long time to convert large
recordsets (anything over 500 records) to XML.The script is below, I
can't seem to make it run any faster.
So, I tried using a WDDX implementation, which was way faster on the server
side. The problem is, that the developers are saying that the COM object
provided at www.openwddx.org fails when the recordset is larger than
approx. 100 records and that it would take them a month ($$) to write a
custom parser. I find this a bit hard to believe! Has anyone used the COM
object to parse large recordsets? Has anyone written a custom parser? Would
it take a month.
This is what the developer wrote to me:
--
As deserializer throwed exception I've tried to create an instance of
WDDXRecordset object.I created WDDXRecordset with 1 column and 5 rows and
added some data to it. Everything worked fine.
Then I serialized recordset to WDDX packet using WDDXSerializer object. It
worked fine. I've got following packet:
wddxPacket version=1.0
header/
data
recordset rowCount=5 fieldNames=Testcol
field name=Testcol
string1/string
string2/string
string3/string
null/
null/
/field
/recordset
/data
/wddxPacket
Then I've created WDDXRecordset back from this packet using
WDDXDeserializer object. And it worked again !!! Then I've compared this
XML with what I've recieved from Brook's service. And they had similar
structure !!! Then I've supposed that problem can be in size of processing
packet. I've done my tests with 152 records and size of WDDX packet was
about 105K. When I've requested only 3 records, the returned WDDX packet
was 1.6K in size and everything worked just perfect. I could deserialize
WDDX packet into WDDXRecordset. So my worst suspicions came to true: this
COM implementation can't handle large amounts of data ( and there are
exists forms even bigger then Contact Us), so it's not very usable for
us. And as it's internal problem in implementation we can't fix it. The
only way ( if we still wish to use it ) is to write custom WDDX parser. But
it will take about month ...
And FYI, this is the Script I was using to convert to XML that ran really slow:
function queryToXML(query){
var root = query;
var row = row;
var cols = listToArray(query.columnList);
var nodeMode = values;
var ii = 1;
var rr = 1;
var thisColumn = ;
var thisValue = ;
var xml = xmlNew();
if(structCount(arguments) GTE 2)
root = arguments[2];
if(structCount(arguments) GTE 3)
row = arguments[3];
if(structCount(arguments) GTE 4)
nodeMode = arguments[4];
xml.xmlRoot = xmlElemNew(xml,root);
xml[root].xmlAttributes[columns] = arrayLen(cols);
xml[root].xmlAttributes[rows] = query.recordCount;
for(rr = 1; rr LTE query.recordCount; rr = rr + 1){
arrayAppend(xml[root].xmlChildren,xmlElemNew(xml,row));
for(ii = 1; ii LTE arrayLen(cols); ii = ii + 1){
thisColumn = lcase(cols[ii]);
thisValue = query[cols[ii]][rr];
switch(nodeMode){
case rows:
xml[root][row][rr].xmlAttributes[thisColumn] = thisValue;
break;
case columns:
arrayAppend(xml[root][row][rr].xmlChildren,xmlElemNew(xml,thisColumn));
xml[root][row][rr][thisColumn].xmlAttributes[value] = thisValue;
break;
default:
arrayAppend(xml[root][row][rr].xmlChildren,xmlElemNew(xml,thisColumn));
xml[root][row][rr][thisColumn].xmlText = thisValue;
}
}
}
return xml;
}
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
COM and WDDX
Hi Folks, I recently outsourced a project to some developers and am having some issues and would appreciate any advice you may be able to offer. Basically they were contracted to develop a client side app (Written in Delphi) that would connect to a CFMX webservice and download recordset data. Thats it in a nutshell. On the server side, I was originally using the script at the bottom of this email to convert the recordset to XML and send it to the client. This worked fine, but it started to take a real long time to convert large recordsets (anything over 500 records) to XML. So, I tried using a WDDX implementation, which was way faster on the server side. The problem is, that the developers are saying that the COM object provided at www.openwddx.org fails when the recordset is larger than approx. 100 records and that it would take them a month ($$) to write a custom parser. I find this a bit hard to believe! Has anyone used the COM object to parse large recordsets? Has anyone written a custom parser? Would it take a month. This is what the developer wrote to me: -- As deserializer throwed exception I've tried to create an instance of WDDXRecordset object.I created WDDXRecordset with 1 column and 5 rows and added some data to it. Everything worked fine. Then I serialized recordset to WDDX packet using WDDXSerializer object. It worked fine. I've got following packet: wddxPacket version=1.0 header/ data recordset rowCount=5 fieldNames=Testcol field name=Testcol string1/string string2/string string3/string null/ null/ /field /recordset /data /wddxPacket Then I've created WDDXRecordset back from this packet using WDDXDeserializer object. And it worked again !!! Then I've compared this XML with what I've recieved from Brook's service. And they had similar structure !!! Then I've supposed that problem can be in size of processing packet. I've done my tests with 152 records and size of WDDX packet was about 105K. When I've requested only 3 records, the returned WDDX packet was 1.6K in size and everything worked just perfect. I could deserialize WDDX packet into WDDXRecordset. So my worst suspicions came to true: this COM implementation can't handle large amounts of data ( and there are exists forms even bigger then Contact Us), so it's not very usable for us. And as it's internal problem in implementation we can't fix it. The only way ( if we still wish to use it ) is to write custom WDDX parser. But it will take about month ... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Namespaces in XMLParse() file...
Thanks Barney, that all makes total sense.The whole issue of namespaces in XML has been iffy for me for a little while...mainly, because the URI doesn't really mean anything.But this time, my fault was that I wasn't thinking about descendents. I'm going to working with a fixed root element 100% of the time with this project, so I won't have a problem working around this one.I'll probably just make it a RegEx in the future. Thanks for the help- Tyler S _ From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 2:10 PM To: CF-Talk Subject: RE: Namespaces in XMLParse() file... Namespaces apply to the current tag, and all decendants, you the tag that declares the namespace can be from that namespace: test:myTag xmlns:test= test:myOtherTag / /test:myTag XML is stringent about single root elements, and since CF's implementation adheres, it won't let you have multiple ones.However, if you need to add it dynamically, it's simple.Check if there is an xml declaration, check if there's a DOCTYPE declaration, and the first that's not part of either of those is the end of the root element.Just replace it with the namespace you need, plus the bracket. Cheers, barneyb -Original Message- From: Tyler Silcox [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 11:04 AM To: CF-Talk Subject: RE: Namespaces in XMLParse() file... As usual, I figured out part of this right after I hit sent on my message: tests xmlns:test=http://www.test.com one name=something value=else / test:uno test=oh no / two name=something value=else / /tests If I add the namespace declaration to the root element, it won't throw an error. I know it is not quite proper, but is there a way to get around declaring the namespace in the root element? I'd like to declare before the root element if I couldis this possible or is CF pretty stringent about it's only one root element rule? Tyler S. _ From: Tyler Silcox [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 1:58 PM To: CF-Talk Subject: Namespaces in XMLParse() file... Are there any tricks to get CFMX to parse a XML file with referenced or unreferenced namespaces in them? I have a XML file that I can read just fine, but when I try to run a XMLParse() on the variable, it throws me a NAMESPACE_ERR error. And if I take out the tag with the namespace in it, it works just fine: tests one name=something value=else / test:uno test=oh no /!-- this throws an error -- two name=something value=else / /tests Tyler S. _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFC 2 XML - ERROR: Whitespace required before attributes
I Does anyone know anything about this error.I can't figure it out.Here's my code. CFQUERY name=get_info datasource=#datasource# maxrows=10 Select partno, shortdesc, longdesc, pic, manf, promos, dateAdded, ManHand, OverSized, FreightItem, MotorSportsFlag from inventory /CFQUERY CFXML variable=inventoryXML dbtable name=Inventory CFOUTPUT query=get_info partno_id=#partno# shortdesc#shortdesc#/shortdesc longdesc#longdesc#/longdesc pic#pic#/pic manf#manf#/manf promos#promos#/promos dateadded#dateadded#/dateadded Manhand#Manhand#/Manhand OverSized#OverSized#/OverSized FreightItem#FreightItem#/FreightItem MotorSportsFlag#MotorSportsFlag#/MotorSportsFlag /partno_id /CFOUTPUT /dbtable /CFXML CFDUMP var=#inventoryXML# CFFILE action="" output=#tostring(inventoryXML)# file=C:\inetpub\wwwroot\cfcs\cfc_2_xml.xml [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF sending data to a local printer?
Pete - could you describe this applet/process in a bit more detail? - Original Message - From: Pete Ruckelshaus - CFList To: CF-Talk Sent: Monday, May 10, 2004 3:01 PM Subject: Re: CF sending data to a local printer? Yes, the page to be printed would contain this applet.We are using this method for one of our applications. Pete Daniel Farmer wrote: You mean an applet that is always on, always running right? and checks for print alerts? - Original Message - From: Pete Ruckelshaus - CFList To: CF-Talk Sent: Monday, May 10, 2004 2:24 PM Subject: Re: CF sending data to a local printer? This is not possible unless you use ActiveX or a client side Java applet.Trust me.We tried.The closest you can get is something like doing a body onload() event in _javascript_ and have it call the print() function; this would bring up the print applet, so it would require the user to click the print button. Pete Daniel Farmer wrote: It's been requested that I create this form that when gets submitted sends the content to a printer ( in the persons place of business ). I've never done anything like that before. Was wondering if it was even possible. Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF sending data to a local printer?
This is great and will keep for future reference, but I need to print on a printer that is at my client's business. The client won't be printing this.
- Original Message -
From: Charlie Griefer
To: CF-Talk
Sent: Monday, May 10, 2004 2:42 PM
Subject: Re: CF sending data to a local printer?
in IE you can bypass the printer dialogue box without ActiveX or client side
Java applet...
script
function noDialog (numcopy) {
var i = 1;
for (i; i==numcopy; i++) {
if ((navigator.appName == Netscape)) {
window.print()
} else {
var mybrowser = OBJECT ID='brwsr' WIDTH=0 HEIGHT=0
CLASSID=''/OBJECT;
document.body.insertAdjacentHTML('beforeEnd', mybrowser);
brwsr.ExecWB(6, -1)
}
}
/script
form name=prnform
How many copies: input type=text name=prnumber
input type=button >
/form
(but is it a bug, or is it a feature?) :)
- Original Message -
From: Pete Ruckelshaus - CFList [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, May 10, 2004 11:24 AM
Subject: Re: CF sending data to a local printer?
This is not possible unless you use ActiveX or a client side Java
applet.Trust me.We tried.The closest you can get is something like
doing a body onload() event in _javascript_ and have it call the print()
function; this would bring up the print applet, so it would require the
user to click the print button.
Pete
Daniel Farmer wrote:
It's been requested that I create this form that when gets submitted
sends the content to a printer ( in the persons place of business ).
I've never done anything like that before. Was wondering if it was even
possible.
Thanks
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: COM and WDDX
Hrmmm... that quiet intresting. Have you tried using the COM object yourself to confirm what they are saying? I'm a bit suprised that openwddx can't handle a recordset larger that a couple hundred records.
-Adam
-Original Message-
From: Brook Davies [mailto:[EMAIL PROTECTED]
Sent: Monday, May 10, 2004 08:27 PM
To: 'CF-Talk'
Subject: COM and WDDX
Hi Folks,
I recently outsourced a project to some developers and am having some
issues and would appreciate any advice you may be able to offer. Basically
they were contracted to develop a client side app (Written in Delphi) that
would connect to a CFMX webservice and download recordset data. Thats it in
a nutshell.
On the server side, I was originally using the script at the bottom of this
email to convert the recordset to XML and send it to the client. This
worked fine, but it started to take a real long time to convert large
recordsets (anything over 500 records) to XML.The script is below, I
can't seem to make it run any faster.
So, I tried using a WDDX implementation, which was way faster on the server
side. The problem is, that the developers are saying that the COM object
provided at www.openwddx.org fails when the recordset is larger than
approx. 100 records and that it would take them a month ($$) to write a
custom parser. I find this a bit hard to believe! Has anyone used the COM
object to parse large recordsets? Has anyone written a custom parser? Would
it take a month.
This is what the developer wrote to me:
--
As deserializer throwed exception I've tried to create an instance of
WDDXRecordset object.I created WDDXRecordset with 1 column and 5 rows and
added some data to it. Everything worked fine.
Then I serialized recordset to WDDX packet using WDDXSerializer object. It
worked fine. I've got following packet:
wddxPacket version=1.0
header/
data
recordset rowCount=5 fieldNames=Testcol
field name=Testcol
string1/string
string2/string
string3/string
null/
null/
/field
/recordset
/data
/wddxPacket
Then I've created WDDXRecordset back from this packet using
WDDXDeserializer object. And it worked again !!! Then I've compared this
XML with what I've recieved from Brook's service. And they had similar
structure !!! Then I've supposed that problem can be in size of processing
packet. I've done my tests with 152 records and size of WDDX packet was
about 105K. When I've requested only 3 records, the returned WDDX packet
was 1.6K in size and everything worked just perfect. I could deserialize
WDDX packet into WDDXRecordset. So my worst suspicions came to true: this
COM implementation can't handle large amounts of data ( and there are
exists forms even bigger then Contact Us), so it's not very usable for
us. And as it's internal problem in implementation we can't fix it. The
only way ( if we still wish to use it ) is to write custom WDDX parser. But
it will take about month ...
And FYI, this is the Script I was using to convert to XML that ran really slow:
function queryToXML(query){
var root = query;
var row = row;
var cols = listToArray(query.columnList);
var nodeMode = values;
var ii = 1;
var rr = 1;
var thisColumn = ;
var thisValue = ;
var xml = xmlNew();
if(structCount(arguments) GTE 2)
root = arguments[2];
if(structCount(arguments) GTE 3)
row = arguments[3];
if(structCount(arguments) GTE 4)
nodeMode = arguments[4];
xml.xmlRoot = xmlElemNew(xml,root);
xml[root].xmlAttributes[columns] = arrayLen(cols);
xml[root].xmlAttributes[rows] = query.recordCount;
for(rr = 1; rr LTE query.recordCount; rr = rr + 1){
arrayAppend(xml[root].xmlChildren,xmlElemNew(xml,row));
for(ii = 1; ii LTE arrayLen(cols); ii = ii + 1){
thisColumn = lcase(cols[ii]);
thisValue = query[cols[ii]][rr];
switch(nodeMode){
case rows:
xml[root][row][rr].xmlAttributes[thisColumn] = thisValue;
break;
case columns:
arrayAppend(xml[root][row][rr].xmlChildren,xmlElemNew(xml,thisColumn));
xml[root][row][rr][thisColumn].xmlAttributes[value] = thisValue;
break;
default:
arrayAppend(xml[root][row][rr].xmlChildren,xmlElemNew(xml,thisColumn));
xml[root][row][rr][thisColumn].xmlText = thisValue;
}
}
}
return xml;
}
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: CFC 2 XML - ERROR: Whitespace required before attributes
Check this line (just inside the inner CFOUTPUT): partno_id=#partno# Probably want this or something like it: partno id=#partno# Cheers, barneyb -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 1:39 PM To: CF-Talk Subject: CFC 2 XML - ERROR: Whitespace required before attributes I Does anyone know anything about this error.I can't figure it out.Here's my code. CFQUERY name=get_info datasource=#datasource# maxrows=10 Select partno, shortdesc, longdesc, pic, manf, promos, dateAdded, ManHand, OverSized, FreightItem, MotorSportsFlag from inventory /CFQUERY CFXML variable=inventoryXML dbtable name=Inventory CFOUTPUT query=get_info partno_id=#partno# shortdesc#shortdesc#/shortdesc longdesc#longdesc#/longdesc pic#pic#/pic manf#manf#/manf promos#promos#/promos dateadded#dateadded#/dateadded Manhand#Manhand#/Manhand OverSized#OverSized#/OverSized FreightItem#FreightItem#/FreightItem MotorSportsFlag#MotorSportsFlag#/MotorSportsFlag /partno_id /CFOUTPUT /dbtable /CFXML CFDUMP var=#inventoryXML# CFFILE action="" output=#tostring(inventoryXML)# file=C:\inetpub\wwwroot\cfcs\cfc_2_xml.xml [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFC 2 XML - ERROR: Whitespace required before attributes
If you are going to have attributes in your XML they have to be like: part_no id=#partno# shortdesc#shortdesc#/shortdesc /part_no Ben -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 4:39 PM To: CF-Talk Subject: CFC 2 XML - ERROR: Whitespace required before attributes I Does anyone know anything about this error.I can't figure it out. Here's my code. CFQUERY name=get_info datasource=#datasource# maxrows=10 Select partno, shortdesc, longdesc, pic, manf, promos, dateAdded, ManHand, OverSized, FreightItem, MotorSportsFlag from inventory /CFQUERY CFXML variable=inventoryXML dbtable name=Inventory CFOUTPUT query=get_info partno_id=#partno# shortdesc#shortdesc#/shortdesc longdesc#longdesc#/longdesc pic#pic#/pic manf#manf#/manf promos#promos#/promos dateadded#dateadded#/dateadded Manhand#Manhand#/Manhand OverSized#OverSized#/OverSized FreightItem#FreightItem#/FreightItem MotorSportsFlag#MotorSportsFlag#/MotorSportsFlag /partno_id /CFOUTPUT /dbtable /CFXML CFDUMP var=#inventoryXML# CFFILE action="" output=#tostring(inventoryXML)# file=C:\inetpub\wwwroot\cfcs\cfc_2_xml.xml [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
WDDX, CFMX, and NULLs
I managed to figure out how to fix our client variable problem with MX/Oracle (we're going to have to drop and rebuild the cdata and cglobal tables in the database), but am running into WDDX problems for converting from CF5 to MX6.1 and, again, can't find anything online.
So, here's our issue.
We have a query in one frame that loads data, some of which can be null. We send it to another frame as JS WDDX data and go from there.However, the null data, instead of being converted to an empty string ('') [as it does in CF5], it goes through as null, which causes problems in our JS code where we check the length of a column.
Aside from searching through all of our code and changing it to take this into account, is there some other fix someone can suggest?We use this a lot and it will be a very extensive change.
Thanks!
Scott
---
Scott Brady
http://www.scottbrady.net/
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: CFMX 6.1 and Order By Error
Yep.I noticed when I took out 'section' the query worked just fine. Any idea what the keyword 'Section' relates to in either CF or SQL? -e [EMAIL PROTECTED] 5/10/04 10:51:10 AM section is a reserved word. That bit us recently. Is that the column that kills it? -d - Original Message - From: Eric Davis [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 10, 2004 11:14 AM Subject: CFMX 6.1 and Order By Error I'm having a very strange problem with CFMX. I'm creating a very simply query. cfquery name=GetACDReports datasource=telecom dbtype=ODBC debug SELECT ACDReports.ReportID, ACDReports.Site, ACDReports.Section, ACDReports.ReportName FROM ACDReports ORDER BY ACDReports.Site,ACDReports.Section,ACDReports.ReportName /cfquery However, when I add more than one field to the Order By portion of SQL statement I get a rather nondescript database error: Error Executing Database Query.The error occurred in D:\inetpub\wwwroot\Telecom\ACD_Reports\ACD_Report_TOC_new.cfm: line 1 1 : cfquery name=GetACDReports datasource=telecom dbtype=ODBC debug2 : SELECT ACDReports.ReportID, ACDReports.Site, ACDReports.Section, ACDReports.ReportName3 : FROM ACDReportsSQL SELECT ACDReports.ReportID, ACDReports.Site, ACDReports.Section, ACDReports.ReportName FROM ACDReports ORDER BY ACDReports.Site,ACDReports.Section,ACDReports.ReportName DATASOURCE telecomSQLSTATEnbsp; ... Exceptions 08:31:44.044 - Database Exception - in D:\inetpub\wwwroot\Telecom\ACD_Reports\ACD_Report_TOC_new.cfm : line 1 Error Executing Database Query.Any ideas? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFMX 6.1 and Order By Error
Thanks for the additional info.I tried the square brackets, and they work for straight database queries as well. -Eric [EMAIL PROTECTED] 5/10/04 11:00:23 AM Adding to that, in that case it was specifically in a QueryOfQuery and referencing section as [section] made it work. -Kevin - Original Message - From: Deanna Schneider section is a reserved word. That bit us recently. Is that the column that kills it? -d [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: WDDX, CFMX, and NULLs
WDDX changed between CF5 and CFMX.Bottom line, CF5 WDDX and CFMX WDDX are
incompatible.They might be really similar, but they're different enough to
pretty much break everything.I think you're going to have to change your
code throughout, or perhaps write a custom serialization routine that mimics
the CF5 serialization.
Cheers,
barneyb
-Original Message-
From: Scott Brady [mailto:[EMAIL PROTECTED]
Sent: Monday, May 10, 2004 2:05 PM
To: CF-Talk
Subject: WDDX, CFMX, and NULLs
I managed to figure out how to fix our client variable
problem with MX/Oracle (we're going to have to drop and
rebuild the cdata and cglobal tables in the database), but am
running into WDDX problems for converting from CF5 to MX6.1
and, again, can't find anything online.
So, here's our issue.
We have a query in one frame that loads data, some of which
can be null. We send it to another frame as JS WDDX data and
go from there.However, the null data, instead of being
converted to an empty string ('') [as it does in CF5], it
goes through as null, which causes problems in our JS code
where we check the length of a column.
Aside from searching through all of our code and changing it
to take this into account, is there some other fix someone
can suggest?We use this a lot and it will be a very
extensive change.
Thanks!
Scott
---
Scott Brady
http://www.scottbrady.net/
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
previous next alphabetical
What's the best way to do a prev - next records output using the alphabet instead of page numbers? Thanks. Emmet [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: WDDX, CFMX, and NULLs
Original Message: From: Barney Boisvert WDDX changed between CF5 and CFMX.Bottom line, CF5 WDDX and CFMX WDDX are incompatible.They might be really similar, but they're different enough to pretty much break everything.I think you're going to have to change your code throughout, or perhaps write a custom serialization routine that mimics the CF5 serialization. Ay carumba!Well, I better get started to prepare for a mid-June deployment then :) Thanks. (for confirming my fear) It's a shame the MX Code Analyzer doesn't seem to include this little nugget of useful info. Scott --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
re: previous next alphabetical
Original Message: From: Emmet McGovern What's the best way to do a prev - next records output using the alphabet instead of page numbers? I'd probably use the ASCII values of the letters to easily move up/down the alphabet. Scott --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFC 2 XML - ERROR: Whitespace required before attributes
I've tried all these suggestions and here's what the code look like now. NEW ERROR: Illegal character or entity reference syntax. Illegal character or entity reference syntax. The error occurred in D:\Inetpub\wwwroot\New_Product_Submission\cfcs\CFC_2_XML.cfm: line 23 21 : MotorSportsFlag#MotorSportsFlag#/MotorSportsFlag 22 : /partno 23 : /cfoutput 24 : /dbtable 25 : /cfxml CODE: cfquery name=getinfo datasource=datasource Select partno, shortdesc, longdesc, pic, manf, promos, dateAdded, ManHand, OverSized, FreightItem, MotorSportsFlag from inventory /cfquery cfxml variable=inventoryXML dbtable name=Inventory cfoutput query=getinfo partno id=#partno# shortdesc#shortdesc#/shortdesc longdesc#longdesc#/longdesc pic#pic#/pic manf#manf#/manf promos#promos#/promos dateAdded#dateAdded#/dateAdded ManHand#ManHand#/ManHand OverSized#OverSized#/OverSized FreightItem#FreightItem#/FreightItem MotorSportsFlag#MotorSportsFlag#/MotorSportsFlag /partno /cfoutput /dbtable /cfxml cfdump var=#inventoryXML# cffile action="" output=#tostring(inventoryXML)# file=C:\inetpub\wwwroot\cfcs\cfc_2_xml.xml If you are going to have attributes in your XML they have to be like: part_no id=#partno# shortdesc#shortdesc#/shortdesc /part_no Ben -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 4:39 PM To: CF-Talk Subject: CFC 2 XML - ERROR: Whitespace required before attributes I Does anyone know anything about this error.I can't figure it out. Here's my code. CFQUERY name=get_info datasource=#datasource# maxrows=10 Select partno, shortdesc, longdesc, pic, manf, promos, dateAdded, ManHand, OverSized, FreightItem, MotorSportsFlag from inventory /CFQUERY CFXML variable=inventoryXML dbtable name=Inventory CFOUTPUT query=get_info partno_id=#partno# shortdesc#shortdesc#/shortdesc longdesc#longdesc#/longdesc pic#pic#/pic manf#manf#/manf promos#promos#/promos dateadded#dateadded#/dateadded Manhand#Manhand#/Manhand OverSized#OverSized#/OverSized FreightItem#FreightItem#/FreightItem MotorSportsFlag#MotorSportsFlag#/MotorSportsFlag /partno_id /CFOUTPUT /dbtable /CFXML CFDUMP var=#inventoryXML# CFFILE action="" output=#tostring(inventoryXML)# file=C:\inetpub\wwwroot\cfcs\cfc_2_xml.xml [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFC 2 XML - ERROR: Illegal character or entity reference syntax.
Help, Now I get this error.Code is listed after code.Ahh! ERROR: Illegal character or entity reference syntax. Illegal character or entity reference syntax. The error occurred in D:\Inetpub\wwwroot\New_Product_Submission\cfcs\CFC_2_XML.cfm: line 23 21 : MotorSportsFlag#MotorSportsFlag#/MotorSportsFlag 22 : /partno 23 : strong/cfoutput/strong 24 : /dbtable 25 : /cfxml CODE: cfquery name=getinfo datasource=datasource Select partno, shortdesc, longdesc, pic, manf, promos, dateAdded, ManHand, OverSized, FreightItem, MotorSportsFlag from inventory /cfquery cfxml variable=inventoryXML dbtable name=Inventory cfoutput query=getinfo partno id=#partno# shortdesc#shortdesc#/shortdesc longdesc#longdesc#/longdesc pic#pic#/pic manf#manf#/manf promos#promos#/promos dateAdded#dateAdded#/dateAdded ManHand#ManHand#/ManHand OverSized#OverSized#/OverSized FreightItem#FreightItem#/FreightItem MotorSportsFlag#MotorSportsFlag#/MotorSportsFlag /partno /cfoutput /dbtable /cfxml cfdump var=#inventoryXML# cffile action="" output=#tostring(inventoryXML)# file=C:\inetpub\wwwroot\cfcs\cfc_2_xml.xml [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFC 2 XML - ERROR: Whitespace required before attributes
Use xmlFormat() around all those variables to escape any legal chars. Cheers, barneyb -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 2:37 PM To: CF-Talk Subject: Re: CFC 2 XML - ERROR: Whitespace required before attributes I've tried all these suggestions and here's what the code look like now. NEW ERROR: Illegal character or entity reference syntax. Illegal character or entity reference syntax. The error occurred in D:\Inetpub\wwwroot\New_Product_Submission\cfcs\CFC_2_XML.cfm: line 23 21 : MotorSportsFlag#MotorSportsFlag#/MotorSportsFlag 22 : /partno 23 : /cfoutput 24 : /dbtable 25 : /cfxml CODE: cfquery name=getinfo datasource=datasource Select partno, shortdesc, longdesc, pic, manf, promos, dateAdded, ManHand, OverSized, FreightItem, MotorSportsFlag from inventory /cfquery cfxml variable=inventoryXML dbtable name=Inventory cfoutput query=getinfo partno id=#partno# shortdesc#shortdesc#/shortdesc longdesc#longdesc#/longdesc pic#pic#/pic manf#manf#/manf promos#promos#/promos dateAdded#dateAdded#/dateAdded ManHand#ManHand#/ManHand OverSized#OverSized#/OverSized FreightItem#FreightItem#/FreightItem MotorSportsFlag#MotorSportsFlag#/MotorSportsFlag /partno /cfoutput /dbtable /cfxml cfdump var=#inventoryXML# cffile action="" output=#tostring(inventoryXML)# file=C:\inetpub\wwwroot\cfcs\cfc_2_xml.xml If you are going to have attributes in your XML they have to be like: part_no id=#partno# shortdesc#shortdesc#/shortdesc /part_no Ben -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 4:39 PM To: CF-Talk Subject: CFC 2 XML - ERROR: Whitespace required before attributes I Does anyone know anything about this error.I can't figure it out. Here's my code. CFQUERY name=get_info datasource=#datasource# maxrows=10 Select partno, shortdesc, longdesc, pic, manf, promos, dateAdded, ManHand, OverSized, FreightItem, MotorSportsFlag from inventory /CFQUERY CFXML variable=inventoryXML dbtable name=Inventory CFOUTPUT query=get_info partno_id=#partno# shortdesc#shortdesc#/shortdesc longdesc#longdesc#/longdesc pic#pic#/pic manf#manf#/manf promos#promos#/promos dateadded#dateadded#/dateadded Manhand#Manhand#/Manhand OverSized#OverSized#/OverSized FreightItem#FreightItem#/FreightItem MotorSportsFlag#MotorSportsFlag#/MotorSportsFlag /partno_id /CFOUTPUT /dbtable /CFXML CFDUMP var=#inventoryXML# CFFILE action="" output=#tostring(inventoryXML)# file=C:\inetpub\wwwroot\cfcs\cfc_2_xml.xml [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: COM and WDDX
Brook
In the past, I have often used WDDX to exchange large recordsets
(thousands of records) between remote hosts.It becomes somewhat slow
with large recordsets because WDDX is quite verbose.(e.g. moving a 33
million character Access db to SQL-Server, then moving that to another
remote host).
In addition I have used WDDX to send recordsets to a client using CFs
WDDX _javascript_ code.This is much slower on the client because of the
way WDDX encodes the packet and regenerates the recordset in
_javascript_.
But in no case did a large number of records cause the WDDX routines to
break.
It has been my experience that WDDX adds approximately 256% overhead to
the amount of real data in a packet.Worse, the deseialization or
regeneration of a record on a client (_javascript_) is terribly
inefficient.
If I were do to do server to client record set exchange today, I would
use thinArrays.This adds only 13% overhead and the regeneration of
the array on the client (_javascript_) is done with a single instruction
-- much much faster.
Now, I don't know anything about Delphi, but would suspect it can
approximate the capabilities of _javascript_ on the client.
In any case, use of thinArrays will significantly reduce the size and
bandwidth of data exchange and the shear size of the data on the
client.
There have been several threads abut this recently Rob Rohan has
published (open source) his Neuromancer product which uses _javascript_
on a client to consume web services (including but not limited to
thinArrays).
It may be worth your while to look at this technology and modify your
client app to incorporate it.
HTH
Dick
On May 10, 2004, at 1:27 PM, Brook Davies wrote:
Hi Folks,
I recently outsourced a project to some developers and am having some
issues and would appreciate any advice you may be able to offer.
Basically
they were contracted to develop a client side app (Written in Delphi)
that
would connect to a CFMX webservice and download recordset data. Thats
it in
a nutshell.
On the server side, I was originally using the script at the bottom
of this
email to convert the recordset to XML and send it to the client. This
worked fine, but it started to take a real long time to convert large
recordsets (anything over 500 records) to XML. The script is below, I
can't seem to make it run any faster.
So, I tried using a WDDX implementation, which was way faster on the
server
side. The problem is, that the developers are saying that the COM
object
provided at www.openwddx.org fails when the recordset is larger than
approx. 100 records and that it would take them a month ($$) to write
a
custom parser. I find this a bit hard to believe! Has anyone used the
COM
object to parse large recordsets? Has anyone written a custom parser?
Would
it take a month.
This is what the developer wrote to me:
--
As deserializer throwed exception I've tried to create an instance of
WDDXRecordset object.I created WDDXRecordset with 1 column and 5 rows
and
added some data to it. Everything worked fine.
Then I serialized recordset to WDDX packet using WDDXSerializer
object. It
worked fine. I've got following packet:
wddxPacket version=1.0
header/
data
recordset rowCount=5 fieldNames=Testcol
field name=Testcol
string1/string
string2/string
string3/string
null/
null/
/field
/recordset
/data
/wddxPacket
Then I've created WDDXRecordset back from this packet using
WDDXDeserializer object. And it worked again !!! Then I've compared
this
XML with what I've recieved from Brook's service. And they had similar
structure !!! Then I've supposed that problem can be in size of
processing
packet. I've done my tests with 152 records and size of WDDX packet
was
about 105K. When I've requested only 3 records, the returned WDDX
packet
was 1.6K in size and everything worked just perfect. I could
deserialize
WDDX packet into WDDXRecordset. So my worst suspicions came to true:
this
COM implementation can't handle large amounts of data ( and there are
exists forms even bigger then Contact Us), so it's not very usable
for
us. And as it's internal problem in implementation we can't fix it.
The
only way ( if we still wish to use it ) is to write custom WDDX
parser. But
it will take about month ...
And FYI, this is the Script I was using to convert to XML that ran
really slow:
function queryToXML(query){
var root = query;
var row = row;
var cols = listToArray(query.columnList);
var nodeMode = values;
var ii = 1;
var rr = 1;
var thisColumn = ;
var thisValue = ;
var xml = xmlNew();
if(structCount(arguments) GTE 2)
root = arguments[2];
if(structCount(arguments) GTE 3)
row = arguments[3];
if(structCount(arguments) GTE 4)
nodeMode = arguments[4];
xml.xmlRoot = xmlElemNew(xml,root);
xml[root].xmlAttributes[columns] = arrayLen(cols);
xml[root].xmlAttributes[rows] = query.recordCount;
for(rr = 1; rr LTE query.recordCount; rr = rr + 1){
Re: previous next alphabetical
I would convert the first letter of each record control field (the alphabetic field) to upper case. Then I would group by first letter -- throwing all non- A-Z records into a separate group (or bunched in with the As). You can even do groups of groups, eg A-C D-G H-K etc. HTH Dick On May 10, 2004, at 1:58 PM, Emmet McGovern wrote: What's the best way to do a prev - next records output using the alphabet instead of page numbers? Thanks. Emmet [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: COM and WDDX
Thanks Dick for your reply. At this point we need to get the app out the door, at least version 1. I am also surprised it can't handle a couple of hundred records. The average recordset size will likely be about 100 and could range to 5000, but not very often, so although WDDX adds the extra weight, I think for the amount of data being transferred it should still be okay. The wddx_com.dllpackaged with CFMX has a last modification date of Friday, March 17, 2000 while the one from openwddx.org is Thursday, October 21, 1999. I just sent this new dll to the developers and have my fingers crossed that it will solve the problem Brook At 02:50 PM 5/10/2004, you wrote: Brook In the past, I have often used WDDX to exchange large recordsets (thousands of records) between remote hosts.It becomes somewhat slow with large recordsets because WDDX is quite verbose.(e.g. moving a 33 million character Access db to SQL-Server, then moving that to another remote host). In addition I have used WDDX to send recordsets to a client using CFs WDDX _javascript_ code.This is much slower on the client because of the way WDDX encodes the packet and regenerates the recordset in _javascript_. But in no case did a large number of records cause the WDDX routines to break. It has been my experience that WDDX adds approximately 256% overhead to the amount of real data in a packet.Worse, the deseialization or regeneration of a record on a client (_javascript_) is terribly inefficient. If I were do to do server to client record set exchange today, I would use thinArrays.This adds only 13% overhead and the regeneration of the array on the client (_javascript_) is done with a single instruction -- much much faster. Now, I don't know anything about Delphi, but would suspect it can approximate the capabilities of _javascript_ on the client. In any case, use of thinArrays will significantly reduce the size and bandwidth of data exchange and the shear size of the data on the client. There have been several threads abut this recently Rob Rohan has published (open source) his Neuromancer product which uses _javascript_ on a client to consume web services (including but not limited to thinArrays). It may be worth your while to look at this technology and modify your client app to incorporate it. HTH Dick On May 10, 2004, at 1:27 PM, Brook Davies wrote: Hi Folks, I recently outsourced a project to some developers and am having some issues and would appreciate any advice you may be able to offer. Basically they were contracted to develop a client side app (Written in Delphi) that would connect to a CFMX webservice and download recordset data. Thats it in a nutshell. On the server side, I was originally using the script at the bottom of this email to convert the recordset to XML and send it to the client. This worked fine, but it started to take a real long time to convert large recordsets (anything over 500 records) to XML.The script is below, I can't seem to make it run any faster. So, I tried using a WDDX implementation, which was way faster on the server side. The problem is, that the developers are saying that the COM object provided at www.openwddx.org fails when the recordset is larger than approx. 100 records and that it would take them a month ($$) to write a custom parser. I find this a bit hard to believe! Has anyone used the COM object to parse large recordsets? Has anyone written a custom parser? Would it take a month. This is what the developer wrote to me: -- As deserializer throwed exception I've tried to create an instance of WDDXRecordset object.I created WDDXRecordset with 1 column and 5 rows and added some data to it. Everything worked fine. Then I serialized recordset to WDDX packet using WDDXSerializer object. It worked fine. I've got following packet: wddxPacket version=1.0 header/ data recordset rowCount=5 fieldNames=Testcol field name=Testcol string1/string string2/string string3/string null/ null/ /field /recordset /data /wddxPacket Then I've created WDDXRecordset back from this packet using WDDXDeserializer object. And it worked again !!! Then I've compared this XML with what I've recieved from Brook's service. And they had similar structure !!! Then I've supposed that problem can be in size of processing packet. I've done my tests with 152 records and size of WDDX packet was about 105K. When I've requested only 3 records, the returned WDDX packet was 1.6K in size and everything worked just perfect. I could deserialize WDDX packet into WDDXRecordset. So my worst suspicions came to true: this COM implementation can't handle large amounts of data ( and there are exists forms even bigger then Contact Us), so it's not very usable for us. And as it's internal problem in implementation we can't fix it. The only way ( if we still wish to use it ) is to write custom WDDX
CFMAILPART wrap attribute
Here's a snip from a plain text message that is sent with CFMAILPART's wrap attribute set to 72: -- The level was changed by Barney Boisvert (userID: 4985) You are being sent this notice because you are the registered site administrator on the site. -- In addition to the paragraph break, there should be line breaks between 'The' and 'level', between 'sent' and 'this', and finally between 'the' and 'site'.Do these seemingly random mid-line wraps happen to anyone else? They seem to be based on number of characters from the top of the message, rather than from the beginning of the line. Cheers, barneyb --- Barney Boisvert, Senior Development Engineer AudienceCentral [EMAIL PROTECTED] voice : 360.756.8080 x32 fax: 360.647.5351 cell: 360.319.6145 www.audiencecentral.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: COM and WDDX
Well, if that doesn't fix the problem and the alternative is to custom rewrite the WDDX_COM, then have a look at thinArrays. The source is available at: http://rohanclan.com/products/neuromancer/ this includes: --The CFCs to do recordset (query, array) thinArray conversion --Robs Neuromancer _javascript_ system (including client-side thinArray serialization, deserialization, record access. -- several examples passing thinArrays with web services There is nothing difficult about the thinArray process -- you can learn/implement it within an hour or so. Dick On May 10, 2004, at 3:06 PM, Brook Davies wrote: Thanks Dick for your reply. At this point we need to get the app out the door, at least version 1. I am also surprised it can't handle a couple of hundred records. The average recordset size will likely be about 100 and could range to 5000, but not very often, so although WDDX adds the extra weight, I think for the amount of data being transferred it should still be okay. The wddx_com.dll packaged with CFMX has a last modification date of Friday, March 17, 2000 while the one from openwddx.org is Thursday, October 21, 1999. I just sent this new dll to the developers and have my fingers crossed that it will solve the problem Brook [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: QofQ with Like returns nullnull error
Sorry, I don't think you can use LIKE on QofQ I couldn't find any citations to confirm it.Anyone care to contradict me? J -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Monday, May 03, 2004 11:28 AM To: CF-Talk Subject: QofQ with Like returns nullnull error Hey all, So, I have a big nasty query, and I need to do some like searches on it. So, I wanted to cache it and then do query of query. However, I can't get the like clause to work. I just keep getting a java.lang.NullPointerException error. Anyone else encountered this? Here's the QofQ: cfquery name=trysearch dbtype=query SELECT * FROM searchstaff WHERE lastname LIKE '%Hen%' /cfquery If I do WHERE lastname = 'Henert' it works just fine, so I know it's not that lastname isn't a correct column name. Yes, I've tried it with queryparams. Yes, I've tried selecting specific columns. But, for brevity of code, I eliminated that for posting. This is 6.1, but we're using the 3.1 drivers, because the 3.3 drivers bring our whole system to a crashing halt. Thoughts? -- Deanna Schneider UWEX-Cooperative Extension Interactive Media Developer [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: COM and WDDX
I certainly will, thanks again! BTW, what is the list etiquette in regard to posting 'Thank you's' , something I've always been unsure of. Should they just go direct to the users email instead of the list? Brook At 03:24 PM 5/10/2004, you wrote: Well, if that doesn't fix the problem and the alternative is to custom rewrite the WDDX_COM, then have a look at thinArrays. The source is available at: http://rohanclan.com/products/neuromancer/ this includes: --The CFCs to do recordset (query, array) thinArray conversion --Robs Neuromancer _javascript_ system (including client-side thinArray serialization, deserialization, record access. -- several examples passing thinArrays with web services There is nothing difficult about the thinArray process -- you can learn/implement it within an hour or so. Dick On May 10, 2004, at 3:06 PM, Brook Davies wrote: Thanks Dick for your reply. At this point we need to get the app out the door, at least version 1. I am also surprised it can't handle a couple of hundred records. The average recordset size will likely be about 100 and could range to 5000, but not very often, so although WDDX adds the extra weight, I think for the amount of data being transferred it should still be okay. The wddx_com.dllpackaged with CFMX has a last modification date of Friday, March 17, 2000 while the one from openwddx.org is Thursday, October 21, 1999. I just sent this new dll to the developers and have my fingers crossed that it will solve the problem Brook -- [http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads] [http://www.houseoffusion.com/lists.cfm/link=i:4:162787This Message] [http://www.houseoffusion.com/lists.cfm/link=s:4Subscription] [http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=905.825.4Fast Unsubscribe] [http://www.houseoffusion.com/signin/User Settings] -- http://www.houseoffusion.com/banners/view.cfm?bannerid=36 [] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: QofQ with Like returns nullnull error
Sorry, I don't think you can use LIKE on QofQ I couldn't find any citations to confirm it. Anyone care to contradict me? Sure, I'll contradict you! According to the CFMX documentation, LIKE is supported, along with the most common wildcards: http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/using_26.htm Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: QofQ with Like returns nullnull error
Cool ... is that only in MX?(I work mostly in 4.5 5.0) -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 4:13 PM To: CF-Talk Subject: RE: QofQ with Like returns nullnull error Sorry, I don't think you can use LIKE on QofQ I couldn't find any citations to confirm it. Anyone care to contradict me? Sure, I'll contradict you! According to the CFMX documentation, LIKE is supported, along with the most common wildcards: http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/using_26.htm Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF sending data to a local printer?
You could take the form output, write it to a text file using CFFILE.If you've got an Mac OS X box handy, have it dump the files into a folder on there, and attach an Applescript to the folder using folder actions to print all files to the printer (and then delete them). Some people are unfortunate enough not to have access to an OS X box though (can you tell what I use?).In that case, you could probably accomplish something similar using a cron job (*nix) or some Scheduled task (Win). If you're feeling really ambitious, you could even write out an RTF or Postscript file instead of just a plain text file. Jon It's been requested that I create this form that when gets submitted sends the content to a printer ( in the persons place of business ). I've never done anything like that before. Was wondering if it was even possible. Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: QofQ with Like returns nullnull error
Cool ... is that only in MX?(I work mostly in 4.5 5.0) No, it's in CF 5 also: http://livedocs.macromedia.com/coldfusion/5.0/Developing_ColdFusion_Applicat ions/queryDB11.htm#1117238 Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
http_referer
Is there an alternative to cgi.http_referer when checking that a form submission originated from the form page? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: http_referer
Stick a uuid in a hidden field and check that you get the same one back. cgi.http_referer can't be trusted as it can be easily spoofed. Andrew Grosset wrote: Is there an alternative to cgi.http_referer when checking that a form submission originated from the form page? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: http_referer
You can't rely on cgi.http_referer.Not all browsers pass it.Either because the software just doesn't, or because the users disable it for privacy reasons. If you really need to pass that across, then I'd suggest creating a hidden field on the previous page containing cgi.Script_Name that gets passed across.That way you're controlling it yourself, and can guarantee the information. Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com _ From: Andrew Grosset [mailto:[EMAIL PROTECTED] Sent: Tuesday, 11 May 2004 11:23 AM To: CF-Talk Subject: http_referer Is there an alternative to cgi.http_referer when checking that a form submission originated from the form page? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: http_referer
That's just as easy to spoof as http_referer.Better to do what Jerry suggested and use a UUID in a hidden field that is also stored in the session/client scope for validation on submit. Cheers, barneyb -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 7:26 PM To: CF-Talk Subject: RE: http_referer You can't rely on cgi.http_referer.Not all browsers pass it.Either because the software just doesn't, or because the users disable it for privacy reasons. If you really need to pass that across, then I'd suggest creating a hidden field on the previous page containing cgi.Script_Name that gets passed across.That way you're controlling it yourself, and can guarantee the information. Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com _ From: Andrew Grosset [mailto:[EMAIL PROTECTED] Sent: Tuesday, 11 May 2004 11:23 AM To: CF-Talk Subject: http_referer Is there an alternative to cgi.http_referer when checking that a form submission originated from the form page? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: http_referer
I don't follow...couldn't I just copy the uuid and place it in a hidden field in MY form and submit that? Stick a uuid in a hidden field and check that you get the same one back. cgi.http_referer can't be trusted as it can be easily spoofed. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: COM and WDDX
On Mon, 2004-05-10 at 15:24, Dick Applebaum wrote: Well, if that doesn't fix the problem and the alternative is to custom rewrite the WDDX_COM, then have a look at thinArrays. The source is available at: http://rohanclan.com/products/neuromancer/ this includes: --The CFCs to do recordset (query, array) thinArray conversion --Robs Neuromancer _javascript_ system (including client-side thinArray serialization, deserialization, record access. -- several examples passing thinArrays with web services There is nothing difficult about the thinArray process -- you can learn/implement it within an hour or so. If you are in a bind I'll give you a copy of cfx_xml that takes a query and turns it into an xml document. It all java (well I guess everything in cf is java now hehehe) but I have had good luck with it and it's pretty fast. You can see a demo here: http://www.rohanclan.com/index.cfm?mode=productproduct=cfxtoxml I normally charge for it, but the guy who processes my credit cards is no longer available - let me know if you want to try it. documentation: http://www.rohanclan.com/library/cfxToXML.cfm Or Dick or I can help you with the thinarrys if you want. But to join the crowd, wddx should work - I wouldn't trust those guys. -- Rob [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: previous next alphabetical
BINGOThe ascii was the trick.Glad you mentioned it.I never seem to see the simple solution. I ended up doing this.Since my records will never include any other characters this works like a charm. cfparam name=search default= cfloop index = i from = 97 to = 122 step = 1 cfoutputa href="" /cfloop cfif len(search) CFQUERY NAME=temp DATASOURCE=#dsn# SELECT* FROMname where name like '#search#%' /CFQUERY brbr cfoutput query=temp #name#br /cfoutput /cfif _ From: Scott Brady [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 5:33 PM To: CF-Talk Subject: re: previous next alphabetical Original Message: From: Emmet McGovern What's the best way to do a prev - next records output using the alphabet instead of page numbers? I'd probably use the ASCII values of the letters to easily move up/down the alphabet. Scott --- Scott Brady http://www.scottbrady.net/ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: URL cleansing
Paul Vernon wrote: I've just been playing around with some ideas for cleansing URLs especially with regards to the injection of SQL code and I came up with the following piece of code on my test rig: cfloop collection=#URL# item=field cfset tmp = REReplaceNoCase(trim(evaluate(URL. field)), \;(.*)(SELECT|DROP|UPDATE|DELETE|TRUNCATE)(.*)$, , ALL) cfif CompareNoCase(tmp, trim(evaluate(URL. field))) NEQ 0 cfthrow type=URLCleanser message=Unsafe data detected in URL /cfif /cfloop Other than the fact that I haven't added in all the SQL keywords that I intend to look for, are there any obvious flaws in using this approach to look for SQL code injections? Looking for incorrect input is a mistake by itself: http://www-106.ibm.com/developerworks/linux/library/l-sp2.html#IDADE4KC Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: XMLParse() Throwing Error - Shared Hosting
Thanks for the notice there, I'm forwarding your message on to the owner of the feed to see if they'll fix it.However in this instance there was a double issue - The host blocks outgoing calls to those that have been improved ahead of time.That is what was causing the error.CF simply ignored the DTD when it couldn't find it on my local server (which does not block). Glad to see you solved the problem and thanks for sharing your finding Massimo [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
