RE: previous next alphabetical
BINGO The 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. index = "i" from = "97" to = "122" step = "1"> SELECT * FROM name where name like '#search#%' #name# _ 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: 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=product&product=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: 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: 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
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
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]
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: 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]
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) -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: 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: 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.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] > >-- > >[] > [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: SELECT * FROM searchstaff WHERE lastname LIKE '%Hen%' 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
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]
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
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 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: > > > > > > > > > > > > > > 1 > > 2 > > 3 > > > > > > > > > > > > > > > > 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
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
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: > > > > > > > 1 > 2 > 3 > > > > > > > > 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["
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# > 22 : > 23 : > 24 : > 25 : > > CODE: > > Select partno, shortdesc, longdesc, pic, manf, promos, > dateAdded, ManHand, OverSized, FreightItem, MotorSportsFlag > from inventory > > > > > > > #shortdesc# > #longdesc# > #pic# > #manf# > #promos# > #dateAdded# > #ManHand# > #OverSized# > > #FreightItem# > > #MotorSportsFlag# > > > > > > > > > file="C:\inetpub\wwwroot\cfcs\cfc_2_xml.xml"> > > > > >If you are going to have attributes in your XML they have to be like: > > > > > > > > #shortdesc# > > > > > > > > > > > >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. > > > > > >Select partno, shortdesc, longdesc, pic, manf, promos, dateAdded, > >ManHand, OverSized, FreightItem, MotorSportsFlag > >from inventory > > > > > > > > > > > >#shortdesc# > >#longdesc# > >#pic# > >#manf# > >#promos# > >#dateadded# > >#Manhand# > >#OverSized# > >#FreightItem# > >#MotorSportsFlag# > > > > > > > > > > > > > >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# 22 : 23 : 24 : 25 : CODE: Select partno, shortdesc, longdesc, pic, manf, promos, dateAdded, ManHand, OverSized, FreightItem, MotorSportsFlag from inventory #shortdesc# #longdesc# #pic# #manf# #promos# #dateAdded# #ManHand# #OverSized# #FreightItem# #MotorSportsFlag# [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# 22 : 23 : 24 : 25 : CODE: Select partno, shortdesc, longdesc, pic, manf, promos, dateAdded, ManHand, OverSized, FreightItem, MotorSportsFlag from inventory #shortdesc# #longdesc# #pic# #manf# #promos# #dateAdded# #ManHand# #OverSized# #FreightItem# #MotorSportsFlag# >If you are going to have attributes in your XML they have to be like: > > > > #shortdesc# > > > > > >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. > > >Select partno, shortdesc, longdesc, pic, manf, promos, dateAdded, >ManHand, OverSized, FreightItem, MotorSportsFlag >from inventory > > > > > >#shortdesc# >#longdesc# >#pic# >#manf# >#promos# >#dateadded# >#Manhand# >#OverSized# >#FreightItem# >#MotorSportsFlag# > > > > > > >file="C:\inetpub\wwwroot\cfcs\cfc_2_xml.xml"> > > [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: 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]
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
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]
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: 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. > > > debug> > SELECT ACDReports.ReportID, ACDReports.Site, ACDReports.Section, > ACDReports.ReportName > FROM ACDReports > ORDER BY ACDReports.Site,ACDReports.Section,ACDReports.ReportName > > > 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 : > debug>2 : 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 > telecomSQLSTATE > ... > > 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]
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: CFC 2 XML - ERROR: Whitespace required before attributes
If you are going to have attributes in your XML they have to be like: #shortdesc# 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. Select partno, shortdesc, longdesc, pic, manf, promos, dateAdded, ManHand, OverSized, FreightItem, MotorSportsFlag from inventory #shortdesc# #longdesc# #pic# #manf# #promos# #dateadded# #Manhand# #OverSized# #FreightItem# #MotorSportsFlag# 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
Check this line (just inside the inner CFOUTPUT): Probably want this or something like it: 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. > > > Select partno, shortdesc, longdesc, pic, manf, promos, > dateAdded, ManHand, OverSized, FreightItem, MotorSportsFlag > from inventory > > > > > > #shortdesc# > #longdesc# > #pic# > #manf# > #promos# > #dateadded# > #Manhand# > #OverSized# > > #FreightItem# > > #MotorSportsFlag# > > > > > > > file="C:\inetpub\wwwroot\cfcs\cfc_2_xml.xml"> > > [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: > > > > > > > 1 > 2 > 3 > > > > > > > > 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: 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...
function noDialog (numcopy) {
var i = 1;
for (i; i==numcopy; i++) {
if ((navigator.appName == "Netscape")) {
window.print()
} else {
var mybrowser = "";
document.body.insertAdjacentHTML('beforeEnd', mybrowser);
brwsr.ExecWB(6, -1)
}
}
How many copies: (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?
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]
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. Select partno, shortdesc, longdesc, pic, manf, promos, dateAdded, ManHand, OverSized, FreightItem, MotorSportsFlag from inventory #shortdesc# #longdesc# #pic# #manf# #promos# #dateadded# #Manhand# #OverSized# #FreightItem# #MotorSportsFlag# [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: 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: > > > > > > > > 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: > > > > > > > > > > Tyler S. > _ > > > > _ [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: 1 2 3 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]
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: 1 2 3 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]
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]
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]
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
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]
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?
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 busy reading 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]
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?
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?
> 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?
in IE you can bypass the printer dialogue box without ActiveX or client side Java applet...
function noDialog (numcopy) {
var i = 1;
for (i; i==numcopy; i++) {
if ((navigator.appName == "Netscape")) {
window.print()
} else {
var mybrowser = "";
document.body.insertAdjacentHTML('beforeEnd', mybrowser);
brwsr.ExecWB(6, -1)
}
}
How many copies: (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?
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]
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: 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: 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: > > > > > > > > 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: > > > > > > > > > > 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: 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: Tyler S. _ [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: Tyler S. [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]
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. > > > debug> > SELECT ACDReports.ReportID, ACDReports.Site, ACDReports.Section, > ACDReports.ReportName > FROM ACDReports > ORDER BY ACDReports.Site,ACDReports.Section,ACDReports.ReportName > > > 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 : > debug>2 : 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 > telecomSQLSTATE > ... > > 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: 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]
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: 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. debug> SELECT ACDReports.ReportID, ACDReports.Site, ACDReports.Section, ACDReports.ReportName FROM ACDReports ORDER BY ACDReports.Site,ACDReports.Section,ACDReports.ReportName 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 : debug>2 : 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 telecomSQLSTATE ... 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: 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: 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: 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: 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: 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]
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: 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 Unauthorized Date/Time: 05/10/04 > 10:45:11Browser: Remote > Address: Query String: TASK=omrs_daily_job_check" 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]
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: 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: 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 > > To correct the issue I did the following: > > > > > > > > > > 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]
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]
CFMX 6.1 and Order By Error
I'm having a very strange problem with CFMX. I'm creating a very simply query. debug> SELECT ACDReports.ReportID, ACDReports.Site, ACDReports.Section, ACDReports.ReportName FROM ACDReports ORDER BY ACDReports.Site,ACDReports.Section,ACDReports.ReportName 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 : debug>2 : 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 telecomSQLSTATE ... 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: 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 Unauthorized Date/Time: 05/10/04 10:45:11Browser: Remote Address: Query String: TASK=omrs_daily_job_check" 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]
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: 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
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]
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]
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 www.blissfulessence.com [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]
Re: Microsoft acknowledges CF!
Ignore... just a subscription test msg.. [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!
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!
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!
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!
> 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!
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: 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: 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)
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: 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]
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!
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]
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: 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 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?
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?
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: 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?
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: 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?
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]
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: URL cleansing
> On your third point, I think that pro-actively catching an > attempt and returning a relevant HTTP error code is far > better than just throwing an exception. When you come to > review your server logs from a security standpoint, what do > you look for? Personally, I look for exceptions and for > specific HTTP error codes. Which ones are easier to check > out? The HTTP error codes of course because they are obvious. Why not return an HTTP error code within your exception handler, when you trap a database exception that indicates you had malformed data? 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]