RE: Access alternatives (WAS: Security gurus out there?)
The point in the whole discussion is not whether to use MySQL for your projects, but WHEN to choose MySQL for your projects. Running a simple website is pretty much a MySQL job, but when you are doing some serious development whereas business processes heavily rely on database data, data integrity and maintaining (even forcing) it is of such an importance you have those features available. Still people say, hey that list is outdated. Sure it is, it has been created in if I recall, about autumn of 2003 on a dutch IT forum as a result of months of MySQL gibberish and a person called ACM had written it out but still most of the points still affect current releases. Most companies lack updates, not upgrading to newer versions, still suggesting older versions are more mature, and thus the result is the posted listing. Using InnoDB overcomes some of the MySQL behaviour but still out of the box The whole point about MySQL is actually only one: The software doesn't have capabilities of maintaining AND forcing constraints or relationships. ;) Somebody asked what database to choose then, I would suggest looking at PostgreSQL if you need a free solution. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Anyone looking for a java WYSIWYG online textarea replacement...
Bonjour Claude I think we are both coming at this thing the same, but just from a slightly different direction. I agree with almost everything you say, but personally I would prefer to see the standard layed down agree by all before it is implemented. Implementing something without telling anyone else first is where the problems come from. I agree the standard should be expanded and improved upon, of course as technology so the standard in to expand to include new things, but simply sitting there and going, oh this is a good idea i'll stick that in simply isn't a good way forward for the developer community. I think the W3C need to take more external advice from developer how actually have to use their standards in day to work, not just from the people that make the browser products like MS and Mozilla. BTW, you English is excellent... Andrew. - Original Message - From: Claude Schneegans [EMAIL PROTECTED] Date: Thu, 02 Sep 2004 18:05:56 -0400 Subject: Re: Anyone looking for a java WYSIWYG online textarea replacement... To: CF-Talk [EMAIL PROTECTED] I agree that the Mozilla documentation is poor, maybe if you feel that strongly you could offer to help write some, If I were one of the author, I sure would do. But not being one of them, I would need docs to learn how it works first. ;-) The problem with Mozilla is that they refer you to the W3C docs, but these are even worse. I don't agree that sticking to the standard should mean expanding upon it. I stick to the French language standard as much as I can. But I'm also able to use English, ... well at least I do my best ;-) The standard is there so the people like us whole program DHTML in the browser know that if you use a command in one browser it will work in all browsers that comply with the standard in the same way. Exact, this is why those who write standard have a big responsability: make a standard that makes sense. W3C standard does not. Just to cite a few flaws: - no block elements are not resizable (ie: span) Why? Is it so difficult to implement? IE was able to resize non block elements even before the standard was written. - no integer values for element dimensions (ie: pixelLeft, etc.). in order to work on them, one must parse text properties that include units at the end. Now this is really ridiculous, DHTML is supposed to be done by programming or what? Expanding on the standard only causes problem as IE has shown. Adding extra stuff only causes programmers problem, Again, I agree with that, but not when adding extra stuff is need to palliate a lack of functionality in the standard. Take for instance WYSIWYG HTML editors, the unbeilivable number of available species proves there is a need for them, it is a shame there is nothing in the standard to make one. Microsoft has implemented HSTML editing with the execCommand method. Now Mozilla has implemented similar facilities (although not as functional), and this is not in the standard. And last but not least (See my English, wow! ;-) the role of any standard is NOT to show the way, it is to set a common basic practice for everybody. If everybody was strictly complying to standard, there would be NO standard, and nothing to standardize. It is thanks to developers who make extras that new ideas can come and enrich standards. When Netscape -- a great company before it was swallowed by AOL -- brought us _javascript_, it was NOT standard, now _javascript_ is part of the standard, for the benefit of all of us. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: XML verity indexing problem
I'm not 100% sure about this, but I think the version of Verity shipped with CF is so old that it does understand that your page with the extension .xml is rendered like an HTML page in the browser and therefore doesn't know how to parse it. I had a similar problem with PDF file recently. The Verity with CFMX can only read PDF up one created with version 4 of Acrobat so when I asked Verity to index about 300 PDFs created with Acrobat 6 it simply ignored them. The solution I came up with was to use a third party Java API (pdfbox) to extract the text from the PDF file and then pass that text to verity. Worked like a treat. Maybe you will need to do something similar to extract the text from your XML pages and pass that to Verity with the filename of the page. Also, I'm not Verity can index CFM page either, as it would need to call the CFM and get the returned page. I'm pretty sure that Verity only reads files. So it will index you HTML pages as it simply reads the file, removes the HTML tags and indexes the remaining text. Verity can be very good, but it need some tweaking. Also, if you have a good budget, and I mean good, you could look at using Verity Ultraseek as that will spider a site and index pages, pdf, etc and all you do is give it the base URL. You can connect to it with CF as a web service, it is pretty easy. But like a say Ultraseek is not cheap. Hope that helps. Andrew. - Original Message - From: Charles Chen [EMAIL PROTECTED] Date: Thu, 02 Sep 2004 18:27:38 -0400 Subject: XML verity indexing problem To: CF-Talk [EMAIL PROTECTED] Hi All. I'm a fairly new CF developer. I'm having weirdness indexing a website that is mostly a collection of XML pages. I'm really stumped. Can someone help me? If I create the verity collection via the colfusion administrator and add .XML to the extension types, it will properly create and index the site and the XML files will show up in my search. However, I need to use the programmatic method rather than the administrator because content on the site changes frequently and I want to schedule a CFM page to index the collection automatically at intervals. So, I programmed CFM pages to create a collection and then index it. In the cfindex, I have specified .xml as an extension type in addition to the standard HTML, CFM, etc. However, when I do a search the indexed collection only returns HTML files. even though XML and CFM has been declared as extensions to index as well. I tried using action="" and action="" I even tried action="" followed by action="" but no dice. Any idea why this is the case? I've cut and paste my code for creating an collection and for indexing it. Thank you for any generous help! - Charles Create collection action page (takes values from form): cfoutput cfswitch _expression_=#Form.collectionaction# cfcase value=Create cfcollection action=""> collection=#Form.CollectionName# path=c:\cfusionmx\verity\collections\ pThe collection #Form.CollectionName# is created. /cfcase cfcase value=Repair cfcollection action=""> collection=#Form.CollectionName# pThe collection #Form.CollectionName# is repaired. /cfcase cfcase value=Optimize cfcollection action=""> collection=#Form.CollectionName# pThe collection #Form.CollectionName# is optimized. /cfcase cfcase value=Delete cfcollection action=""> collection=#Form.CollectionName# pCollection deleted. /cfcase /cfswitch /cfoutput Index collection page (takes collection name value from form): cfindex collection=#Form.IndexColl# action=""> extensions=.htm, .html, .cfm, .cfml, .xml key=c:\InetPub\wwwroot\www.vsarts.org\ type=path urlpath=http://www.vsarts.org recurse=Yes language=English cfoutput The collection #Form.IndexColl# has been indexed. /cfoutput [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Auto-Login
Great! Can anyone tell me how to configure IIS to do this? Thanks. If I'm logged onto my local machine in the local domain, is there a way that ColdFusion can identify my username? Is there a way of identifying if the user is logged onto the local domain already? And who the user is? Basically, I want to avoid making users log on to an internal system, and for the system to identify the person automatically. If you're using Windows and Internet Explorer on your client machines, and IIS on your server, and the clients and server are within the same domain, you can configure IE to automatically provide domain login credentials to IIS, which can then be accessed via CGI or CFLOGIN within CFMX. 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] [Donations and Support]
Re: Access alternatives (WAS: Security gurus out there?)
Wow! Which version did you use last? I really want to hear an explanation of this one Cutter Micha Schopman wrote: MySQL is out of the question for sensitive information. MySQL is missing to much functionality to maintain data integrity on db level. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Auto-Login
You need to disable Anonymous access under the security tab of the website under IIS. This will populate the cgi variable cgi.auth_user This will only work on your intranet though. Taco Fleur Tell me and I will forget Show me and I will remember Teach me and I will learn -Original Message- From: Tony Pimm [mailto:[EMAIL PROTECTED] Sent: Friday, 3 September 2004 5:48 PM To: CF-Talk Subject: Re: Auto-Login Great! Can anyone tell me how to configure IIS to do this? Thanks. If I'm logged onto my local machine in the local domain, is there a way that ColdFusion can identify my username? Is there a way of identifying if the user is logged onto the local domain already? And who the user is? Basically, I want to avoid making users log on to an internal system, and for the system to identify the person automatically. If you're using Windows and Internet Explorer on your client machines, and IIS on your server, and the clients and server are within the same domain, you can configure IE to automatically provide domain login credentials to IIS, which can then be accessed via CGI or CFLOGIN within CFMX. 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] [Donations and Support]
RE: Access alternatives (WAS: Security gurus out there?)
I quote, for foreign keys, transactions and triggers. Correct me If I am wrong but this comes from the MySQL site. Note that, for the moment, only InnoDB tables support foreign keys. See section 16.7.4 FOREIGN KEY Constraints http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html . Foreign key support in MyISAM tables is scheduled for implementation in MySQL 5.1. Using the InnoDB or Berkeley DB (BDB) storage engines, the MySQL database server supports transactions. Upcoming Features - Support for stored procedures was added in version 5.0, and support for triggers will be added in version 5.1. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Cold Fusion and Oracle Unsupported Data Conversion
On Thursday 02 Sep 2004 22:04 pm, Adrocknaphobia wrote: This is def a driver/cfmx issue as you will not see this error in any form in SQL*Plus. Do you still see the error with the updated drivers from the Updater ? -- 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] [Donations and Support]
Re: Access alternatives (WAS: Security gurus out there?)
Matt Robertson wrote: Jochem wrote: After doing a simple division by 2.20371, your balance doesn't quite balance anymore. You mean do the division in the sql?Thats something I would never do, personally. Where else can you do it and have control over precision and rounding? In CF we have no control over the datatype, which means there is no way we can control precision if there is an int to float conversion in an unexpected place. In databases we have exact numeric types of arbitrary scale and precision that have a behaviour that is exactly specified by the SQL standard. Except in MySQL. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Awkward SQL
I have a query I need which is nothing short of awkward.I have a field which is a date/time type storing data as a full date/time i.e.: 2004-09-03 10:37 I need to select them so that the value returned is 2004-09-03 00:00 but more than this I need 3pm to be the date change. For example. 2004-09-03 08:00 -- 2004-09-03 00:00 2004-09-03 14:00 -- 2004-09-03 00:00 2004-09-03 15:01 -- 2004-09-04 00:00 Now I can do this by looping over a query and stinking the values into an array but is it possible to do this directly in the SQL? I am using CFMX 6.1 and MySQL 4.1.3. -- James Smith [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Awkward SQL
James Smith wrote: I have a query I need which is nothing short of awkward.I have a field which is a date/time type storing data as a full date/time i.e.: 2004-09-03 10:37 I need to select them so that the value returned is 2004-09-03 00:00 but more than this I need 3pm to be the date change. For example. 2004-09-03 08:00 -- 2004-09-03 00:00 2004-09-03 14:00 -- 2004-09-03 00:00 2004-09-03 15:01 -- 2004-09-04 00:00 Now I can do this by looping over a query and stinking the values into an array but is it possible to do this directly in the SQL? SELECT CAST(your_datetime_field + INTERVAL '11 hours' AS DATE) FROM table Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Access alternatives (WAS: Security gurus out there?)
there's an idea (i don't want to say generally held but it sometimes seems so) among folks serious about their databases that mysql isn't quite right-in-the-head. a few years ago the developers of mysql had this funny publicly stated attitude about transactions as being a fancy, unnecessary function. they used to brag about it. i've always been suspicious of it since then--maybe a reformed harlot is more zealous but i can't help thinking deep down there's something still loose zany lurking. and of course it currently doesn't do unicode which makes it kind of useless to me even for the most trivial applications. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Awkward SQL
SELECT CAST(your_datetime_field + INTERVAL '11 hours' AS DATE) FROM table or if you're not fortunate enough to have standards compliant db like postgres,say sql server: SELECT CAST(CONVERT(char(12),DATEADD(minute,541,yourDateColumn),101) AS smalldatetime) AS yourNewDateTime [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Awkward SQL
2004-09-03 08:00 -- 2004-09-03 00:00 2004-09-03 14:00 -- 2004-09-03 00:00 2004-09-03 15:01 -- 2004-09-04 00:00 SELECT CAST(your_datetime_field + INTERVAL '11 hours' AS DATE) FROM table At first glance this looks good and the MySQL docs seem to support this theory but it just throws an error.When I run... SELECTSELECT CAST(MessageDate + INTERVAL '11 hours' AS DATE) FROMtable I get the error... Syntax error or access violation: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT CAST(MessageDate + INTERVAL '11 hours' AS DATE) FROM table' at line 1 I have also tried using the DATE_ADD() syntax but with no better results. -- Jay [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Awkward SQL
James Smith wrote: 2004-09-03 08:00 -- 2004-09-03 00:00 2004-09-03 14:00 -- 2004-09-03 00:00 2004-09-03 15:01 -- 2004-09-04 00:00 SELECT CAST(your_datetime_field + INTERVAL '11 hours' AS DATE) FROM table At first glance this looks good and the MySQL docs seem to support this theory but it just throws an error. Which version are you running? Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Awkward SQL
SELECT CAST(your_datetime_field + INTERVAL '11 hours' AS DATE) FROM table or if you're not fortunate enough to have standards compliant db like postgres,say sql server: SELECT CAST(CONVERT(char(12),DATEADD(minute,541,yourDateColumn),101) AS smalldatetime) AS yourNewDateTime Unfortunately even after converting the DATEADD function to DATE_ADD (as used by MySQL) this solution produces the same error as Jochems solution. -- Jay [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Awkward SQL
2004-09-03 08:00 -- 2004-09-03 00:00 2004-09-03 14:00 -- 2004-09-03 00:00 2004-09-03 15:01 -- 2004-09-04 00:00 SELECT CAST(your_datetime_field + INTERVAL '11 hours' AS DATE) FROM table At first glance this looks good and the MySQL docs seem to support this theory but it just throws an error. Which version are you running? 4.1.3 -- Jay [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Anyone looking for a java WYSIWYG online textarea replacement...
I think the W3C need to take more external advice from developer how actually have to use their standards in day to work, not just from the people that make the browser products like MS and Mozilla. I'll second that. Now, as far as HTML and _javascript_ standards are concerned, and about the way they have been settled, I think one must not forget a long history of more or less fair competition between Netscape and Microsoft. Both these compagnies were members in the standard comitees, and both were defending their approach. And at the time it happened, it was really a war between them. But Netscape was still strong enough, and a couple of things they were not able to do have been specified as should not do in the standard. I remember in another life, I used to be a member in an ISO comitee for vocabulary in computer graphics. Microsoft was not even a project, and Bill Gates was probabily still sucking his Pablum in these days, but IBM, Xerox, etc. were omnipresent and fighting each others every minute. BTW, you English is excellent... Thanks, I do my best to stick to standards and I have a good documentation ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Awkward SQL
James Smith wrote: 2004-09-03 08:00 -- 2004-09-03 00:00 2004-09-03 14:00 -- 2004-09-03 00:00 2004-09-03 15:01 -- 2004-09-04 00:00 SELECT CAST(your_datetime_field + INTERVAL '11 hours' AS DATE) FROM table At first glance this looks good and the MySQL docs seem to support this theory but it just throws an error. Which version are you running? 4.1.3 Does the following work: SELECT MessageDate + INTERVAL 11 HOUR AS DATE FROM table Then you can use date_format to set the hours to zero. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SQL Query Problem
My problem is with is piece of code in QueryB. It is creating an ODBC error. If your query contains quotes, you have to use #preserveSingleQuotes(SQLQUERY)# in your query B -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Anyone looking for a java WYSIWYG online textarea replacement...
Same old same old... commercial differences always get in the way of progress. If everyone in the world worked together on everything and shared all knowledge the we would probably have made more advances then we have and be a much better place. Vive La Monde!!! (not sure that is completely right!!!) Andrew. - Original Message - From: Claude Schneegans [EMAIL PROTECTED] Date: Fri, 03 Sep 2004 07:05:20 -0400 Subject: Re: Anyone looking for a java WYSIWYG online textarea replacement... To: CF-Talk [EMAIL PROTECTED] I think the W3C need to take more external advice from developer how actually have to use their standards in day to work, not just from the people that make the browser products like MS and Mozilla. I'll second that. Now, as far as HTML and _javascript_ standards are concerned, and about the way they have been settled, I think one must not forget a long history of more or less fair competition between Netscape and Microsoft. Both these compagnies were members in the standard comitees, and both were defending their approach. And at the time it happened, it was really a war between them. But Netscape was still strong enough, and a couple of things they were not able to do have been specified as should not do in the standard. I remember in another life, I used to be a member in an ISO comitee for vocabulary in computer graphics. Microsoft was not even a project, and Bill Gates was probabily still sucking his Pablum in these days, but IBM, Xerox, etc. were omnipresent and fighting each others every minute. BTW, you English is excellent... Thanks, I do my best to stick to standards and I have a good documentation ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Awkward SQL
Jochem van Dieten wrote: Does the following work: SELECT MessageDate + INTERVAL 11 HOUR AS DATE FROM table That should be: SELECT MessageDate + INTERVAL 11 HOUR FROM table Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Awkward SQL
Now I can do this by looping over a query and stinking the values into an array but is it possible to do this directly in the SQL? My feeling is that it would probabily be rather difficult with MySQL. I would do it in a loop in CF. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Chaning debug output in CF5
Is there anyway to do this? I do a lot of fusebox and I wanted to change the colours so I can see what files are being called. I KNOW how do do this is CFMXbut I need a solution for CF5 Any ideas? -- Mark Drew coldfusion and cfeclipse bloged: http://cybersonic.blogspot.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Anyone looking for a java WYSIWYG online textarea replacement...
Vive La Monde!!! (not sure that is completely right!!!) Almost: LE monde ;-)) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Access alternatives (WAS: Security gurus out there?)
7. What does zerofill do to a integer field? A database is meant to store data, not to format it while storing. Actually I find this to be a nice feature...if necessary. For instance you are using Auto_Increment INT field and you are using it as your order number.Maybe you want all of your order numbers to be a specific length. I actually found it usefull with barcodes which in the US are only 12 digits but in Europe are exactly the same format but 13 digits long.Adding a zero to the beginning of a US code makes it a European compatible code. -- Jay [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Awkward SQL
Finally... After much messing about I finally got a modified version of Jochem's solution working... Jochem's original: SELECT CAST(your_datetime_field + INTERVAL '11 hours' AS DATE) FROM table Working: SELECT CAST((your_datetime_field + INTERVAL 9 HOUR) AS DATE) FROM table Note the extra parenthesis around the MessageDate + INTERVAL 9 HOUR and the removed quotes around the time interval. I have also dropped it to 9 hours as the cut off is 3pm not 13:00 but that was the least of my troubles! Thanks go to Jochem and all others. -- Jay -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: 03 September 2004 12:17 To: CF-Talk Subject: Re: Awkward SQL Now I can do this by looping over a query and stinking the values into an array but is it possible to do this directly in the SQL? My feeling is that it would probabily be rather difficult with MySQL. I would do it in a loop in CF. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Anyone looking for a java WYSIWYG online textarea replacement...
Ok... only a guess anyway!!! Andrew. - Original Message - From: Claude Schneegans [EMAIL PROTECTED] Date: Fri, 03 Sep 2004 07:21:52 -0400 Subject: Re: Anyone looking for a java WYSIWYG online textarea replacement... To: CF-Talk [EMAIL PROTECTED] Vive La Monde!!! (not sure that is completely right!!!) Almost: LE monde ;-)) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Awkward SQL
Ok, extension of this problem SELECT CAST((MessageDate + INTERVAL 9 HOUR) AS DATE) AS Purchase_Date, ItemCount FROMtable Works just fine and returns the dates exactly as I want, unfortunately I need to be using sum(ItemCount) giving me... SELECTCAST((MessageDate + INTERVAL 9 HOUR) AS DATE) AS Purchase_Date, sum(ItemCount) AS TotalItems FROMtable GROUP BY Purchase_Date And unfortunately as soon as I group on the date it gets mutated into binary data instead of the date. Any ideas on why and how to get round it? -- Jay [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT- netstat report
If I open it as a localhost from the same machine, yes then the website opened, but if I open it with domain, the website is not getting open from this machine, and rest of the world can open. There is no firewall on this computer, the only thing is I installed the sp2 and after disabling the firewall still the website was not opening for the rest of the world so, I uninstalled the sp2, no effect, then I restore the system on old date(before sp2) then it start serving website and it can open from outside and localhost, but not with the domain on same machine. I can ping the ip no problem, i can ping the domain no problem. I still don't understand what can be the cause of this. it was fine before please advise. could someone tell me that whats wrong with this netstat report the website is not opening from the same machine, the rest of the world can open easily but not getting open from the same machine. Is your web server configured to accept requests to the localhost address? My guess is that it isn't. 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] [Donations and Support]
RE: Awkward SQL
With a bit of experimenting... SELECTCAST(DATE_FORMAT((MessageDate + INTERVAL 9 HOUR),'%d/%m/%Y') AS CHAR) AS Purchase_Date, sum(ItemCount) AS TotalSales FROMtable Works for my purposes this time, but it would still be nice to know why the group by clause caused MySQL to convert the Date column to Binary data if any one knows. -- Jay -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: 03 September 2004 12:58 To: CF-Talk Subject: RE: Awkward SQL Ok, extension of this problem SELECT CAST((MessageDate + INTERVAL 9 HOUR) AS DATE) AS Purchase_Date, ItemCount FROMtable Works just fine and returns the dates exactly as I want, unfortunately I need to be using sum(ItemCount) giving me... SELECTCAST((MessageDate + INTERVAL 9 HOUR) AS DATE) AS Purchase_Date, sum(ItemCount) AS TotalItems FROMtable GROUP BY Purchase_Date And unfortunately as soon as I group on the date it gets mutated into binary data instead of the date. Any ideas on why and how to get round it? -- Jay [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: XML verity indexing problem
Judging by your paths I am going to guess that you are on Windows. You might want to take a look at the verity spider. Just a thought. Doug Charles Chen wrote: Hi All. I'm a fairly new CF developer. I'm having weirdness indexing a website that is mostly a collection of XML pages. I'm really stumped. Can someone help me? If I create the verity collection via the colfusion administrator and add .XML to the extension types, it will properly create and index the site and the XML files will show up in my search. However, I need to use the programmatic method rather than the administrator because content on the site changes frequently and I want to schedule a CFM page to index the collection automatically at intervals. So, I programmed CFM pages to create a collection and then index it. In the cfindex, I have specified .xml as an extension type in addition to the standard HTML, CFM, etc. However, when I do a search the indexed collection only returns HTML files. even though XML and CFM has been declared as extensions to index as well. I tried using action="" and action="" I even tried action="" followed by action="" but no dice. Any idea why this is the case? I've cut and paste my code for creating an collection and for indexing it. Thank you for any generous help! - Charles Create collection action page (takes values from form): cfoutput cfswitch _expression_=#Form.collectionaction# cfcase value=Create cfcollection action=""> collection=#Form.CollectionName# path=c:\cfusionmx\verity\collections\ pThe collection #Form.CollectionName# is created. /cfcase cfcase value=Repair cfcollection action=""> collection=#Form.CollectionName# pThe collection #Form.CollectionName# is repaired. /cfcase cfcase value=Optimize cfcollection action=""> collection=#Form.CollectionName# pThe collection #Form.CollectionName# is optimized. /cfcase cfcase value=Delete cfcollection action=""> collection=#Form.CollectionName# pCollection deleted. /cfcase /cfswitch /cfoutput Index collection page (takes collection name value from form): cfindex collection=#Form.IndexColl# action=""> extensions=.htm, .html, .cfm, .cfml, .xml key=c:\InetPub\wwwroot\www.vsarts.org\ type=path urlpath=http://www.vsarts.org recurse=Yes language=English cfoutput The collection #Form.IndexColl# has been indexed. /cfoutput [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: XML parsing in ColdFusion
I have never tried to do it. I am hard pressed to think of why I would ever want to maybe MM developers were the same way. Any chance you could give me a real world application for this? Maybe I am missing out on some revolutionary concept :) Adam H On Thu, 2 Sep 2004 13:01:42 -0700, Rob [EMAIL PROTECTED] wrote: It really is that difficult http://www-106.ibm.com/developerworks/xml/library/x-tipmvdom.html On Thu, 2 Sep 2004 12:39:53 -0700, Ian Skinner [EMAIL PROTECTED] wrote: Thanks, that worked, now I just need to decide if I want to use undocumented features or an UDF. Is this really supposed to be this difficult?Or am I just being difficult again? -- Ian Skinner Web Programmer BloodSource file:///C:\Documents%20and%20Settings\iskinner\Application%20Data\Microsoft\Signatures\www.BloodSource.org www.BloodSource.org http://www.BloodSource.orgSacramento Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice:This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT- netstat report
On Friday 03 Sep 2004 13:10 pm, Asim Manzur wrote: If I open it as a localhost from the same machine, yes then the website opened, but if I open it with domain, the website is not getting open from this machine, and rest of the world can open. Check the DNS. Can this machine 'ping' it's own real world address (as both an IP and a name) ? -- 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] [Donations and Support]
Re: Cold Fusion and Oracle Unsupported Data Conversion
I'd found that out, too, and ended up adding error catching in the PL/SQL to always make sure that I opened the ref cursor and passed it back, even if it was empty. - Original Message - From: Adrocknaphobia ** this is a response to a post from 3/9/2004 which never seemed to be resolved ** Explanation of CFMX Oracle JDBC database error Unsupported Data Conversion This issue occurs when using RefCursors to return queries from oracle via a stored procedure. When you declare a RefCursor it is NULL until it is populated with the OPEN ... FOR syntax. If any sort of error or premature return from the stored procedure occurs, Oracle still passes the RefCursor to CFMX. CFMX cannot convert the NULL RefCursor to an empty query. Now, if oracle performed and OPEN...FOR on the cursor and no rows were returned, then the RefCursor is successfully passed back to CFMX as it is no longer considered NULL. This one can be a little tricky to debug, especially you have good exception handling. In my case I was catching and returning an error before it got to populate the RefCursor. But CFMX threw it's Unsupported Data Conversion before it threw the actual error. This is def a driver/cfmx issue as you will not see this error in any form in SQL*Plus. Adam [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT- netstat report
Yes I ping the domain from the same machine, and got response. I ping the external static ip, got response. I ping the internal ip, got response. I ping the computer name, got response. infact I ping outside the network and got response as well. thanks On Friday 03 Sep 2004 13:10 pm, Asim Manzur wrote: If I open it as a localhost from the same machine, yes then the website opened, but if I open it with domain, the website is not getting open from this machine, and rest of the world can open. Check the DNS. Can this machine 'ping' it's own real world address (as both an IP and a name) ? -- 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] [Donations and Support]
Re: Cold Fusion and Oracle Unsupported Data Conversion
Not Adrocknaphobia, but as far as we'er concerned Don't know - the updated drivers crash our whole system. :( - Original Message - From: Thomas Chiverton Do you still see the error with the updated drivers from the Updater ? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
DHTML Drag and Drop to reorder record set
Hi, I'm not a DHTML guy by any means. Could someone point me in the right direction to figuring out how to use DHTML to take a record from within a record set, drag it to a higher or lower position, and have it change its position within the record set? Basically what I have is like a to do list. But lets say I want to take item #5 and drop it between item #2 and #3 so it becomes the new #3 and the old #3 becomes #4 and so on. I've got the logic basically but not the code. Any good tutorials or examples of something similar? TIA, Guy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT- netstat report
Can you use the domain names on other PCs on the network and see the sites properly? Here, we're behind a firewall using NAT... port forwarding... Presently, I cannot use domain nameswith other PCs on the network. If I do, I just get the firewall box. But the external world has access without trouble. (I'm waiting for this to be fixed) I was told we needed another DNS server to serve internal requests. As I am not the network admin, I have not resolved this problem. So, on the webserver here, I cannot access the site by domain name, even if I'm on the server (the actual box the request comes to) because of the NAT box. Just thought I would throw that out there... Yves - Original Message - From: Asim Manzur [EMAIL PROTECTED] Date: Fri, 03 Sep 2004 09:40:23 -0400 Subject: Re: OT- netstat report To: CF-Talk [EMAIL PROTECTED] Yes I ping the domain from the same machine, and got response. I ping the external static ip, got response. I ping the internal ip, got response. I ping the computer name, got response. infact I ping outside the network and got response as well. thanks On Friday 03 Sep 2004 13:10 pm, Asim Manzur wrote: If I open it as a localhost from the same machine, yes then the website opened, but if I open it with domain, the website is not getting open from this machine, and rest of the world can open. Check the DNS. Can this machine 'ping' it's own real world address (as both an IP and a name) ? -- 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] [Donations and Support]
CFHTTP Alternatives
Since CFHTTP support is broken in all versions since CF 4.5 (as in CFHTTPPARAM automatically urlencodes all the names and values, and there's nothing we can do about it), I was wondering if there are any CFMX alternatives to CFHTTP, short of writing your own java classes every time you need to post something.Isn't there a way to extend the CFHTTPPARAM tag or something and modify certain methods not to URLEncode the data? Russ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT- netstat report
Thanks Yves, I am not on that location now, but thats a good point. I will test this in the eveing and post the reply tomorrow. - Asim Can you use the domain names on other PCs on the network and see the sites properly? Here, we're behind a firewall using NAT... port forwarding... Presently, I cannot use domain nameswith other PCs on the network. If I do, I just get the firewall box. But the external world has access without trouble. (I'm waiting for this to be fixed) I was told we needed another DNS server to serve internal requests. As I am not the network admin, I have not resolved this problem. So, on the webserver here, I cannot access the site by domain name, even if I'm on the server (the actual box the request comes to) because of the NAT box. Just thought I would throw that out there... Yves - Original Message - From: Asim Manzur [EMAIL PROTECTED] Date: Fri, 03 Sep 2004 09:40:23 -0400 Subject: Re: OT- netstat report To: CF-Talk [EMAIL PROTECTED] Yes I ping the domain from the same machine, and got response. I ping the external static ip, got response. I ping the internal ip, got response. I ping the computer name, got response. infact I ping outside the network and got response as well. thanks On Friday 03 Sep 2004 13:10 pm, Asim Manzur wrote: If I open it as a localhost from the same machine, yes then the website opened, but if I open it with domain, the website is not getting open from this machine, and rest of the world can open. Check the DNS. Can this machine 'ping' it's own real world address (as both an IP and a name) ? -- 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] [Donations and Support]
RE: OT- netstat report
If you're on windows, you can modify your hosts file and map the domain name to an ip manually in there. The file is in C:\WINDOWS\system32\drivers\etcand it's called hosts Just add a line in there such as 192.168.0.5 www.mysite.com http://www.mysite.com/ and it should work from your computer. You can do the same thing on other people's pc's.If this needs to be done on a lot of people's computers, probably the best bet would be to have an internal DNS server. Russ _ From: Yves Arsenault [mailto:[EMAIL PROTECTED] Sent: Thursday, September 02, 2004 10:18 AM To: CF-Talk Subject: Re: OT- netstat report Can you use the domain names on other PCs on the network and see the sites properly? Here, we're behind a firewall using NAT... port forwarding... Presently, I cannot use domain nameswith other PCs on the network. If I do, I just get the firewall box. But the external world has access without trouble. (I'm waiting for this to be fixed) I was told we needed another DNS server to serve internal requests. As I am not the network admin, I have not resolved this problem. So, on the webserver here, I cannot access the site by domain name, even if I'm on the server (the actual box the request comes to) because of the NAT box. Just thought I would throw that out there... Yves - Original Message - From: Asim Manzur [EMAIL PROTECTED] Date: Fri, 03 Sep 2004 09:40:23 -0400 Subject: Re: OT- netstat report To: CF-Talk [EMAIL PROTECTED] Yes I ping the domain from the same machine, and got response. I ping the external static ip, got response. I ping the internal ip, got response. I ping the computer name, got response. infact I ping outside the network and got response as well. thanks On Friday 03 Sep 2004 13:10 pm, Asim Manzur wrote: If I open it as a localhost from the same machine, yes then the website opened, but if I open it with domain, the website is not getting open from this machine, and rest of the world can open. Check the DNS. Can this machine 'ping' it's own real world address (as both an IP and a name) ? -- 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] [Donations and Support]
Re: CFHTTP Alternatives
On Fri, 3 Sep 2004 10:16:17 -0400, Russ [EMAIL PROTECTED] wrote: Since CFHTTP support is broken in all versions since CF 4.5 (as in CFHTTPPARAM automatically urlencodes all the names and values, and there's nothing we can do about it), I was wondering if there are any CFMX alternatives to CFHTTP, short of writing your own java classes every time you need to post something.Isn't there a way to extend the CFHTTPPARAM tag or something and modify certain methods not to URLEncode the data? Dude, you just have to read the docs: http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p59.htm#wp1100049 We use it extensively just fine. Look at the encoded attribute. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Problem with accented character in file names and CFFILE
Hi. I have have problem with accented characters in file names when they are uploaded using CFFILE. The file name in question was: Lonidas.pdf And the with changed to a question mark (L?onidas.pdf), however the variables returned by CFFILE had it create, so when the code used the file name returned by CFFILE to do a CFDIRECTORY to get the file size it failed to find the and therefore the file size. Is this a CF problem or any OS problem, either way anyway know a way round it? CFMX6.1 / Redhat 7.2 / Apache 1.3.27 Thanks. Andrew. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Access alternatives (WAS: Security gurus out there?)
Jochem... I second that.Use the database handle data manipulation. I've worked on lots of sites where the original developers where not knowledgable about SQL and they wrote good CF code, but handled EVERYTHING in CF ... not a good solution. It's like trying to change a tire with a pliers. -mk -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Friday, September 03, 2004 4:03 AM To: CF-Talk Subject: Re: Access alternatives (WAS: Security gurus out there?) Matt Robertson wrote: Jochem wrote: After doing a simple division by 2.20371, your balance doesn't quite balance anymore. You mean do the division in the sql?Thats something I would never do, personally. Where else can you do it and have control over precision and rounding? In CF we have no control over the datatype, which means there is no way we can control precision if there is an int to float conversion in an unexpected place. In databases we have exact numeric types of arbitrary scale and precision that have a behaviour that is exactly specified by the SQL standard. Except in MySQL. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: XML parsing in ColdFusion
I have never tried to do it. I am hard pressed to think of why I would ever want to maybe MM developers were the same way. Any chance you could give me a real world application for this? Maybe I am missing out on some revolutionary concept :) Adam H Never tried to copy a node from one XML document to another?The reason would be to do just that, combine related data from two separate XML data sources into one.We are using XML as a data source so that the data is easily shareable between servers that are otherwise separated from each other by firewalls and other security.So we need the ability to add/edit/remove data from the XML generated on each server. -- Ian Skinner Web Programmer BloodSource file:///C:\Documents%20and%20Settings\iskinner\Application%20Data\Microsoft\Signatures\www.BloodSource.org www.BloodSource.org http://www.BloodSource.orgSacramento Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice:This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: OT- netstat report
If you have a NAT type scheme you may have an external address and an internal address.It's pretty comon for DNS administrators to not keep the internal zones up to date.Add an entry to your host file. -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Friday, September 03, 2004 8:28 AM To: CF-Talk Subject: Re: OT- netstat report On Friday 03 Sep 2004 13:10 pm, Asim Manzur wrote: If I open it as a localhost from the same machine, yes then the website opened, but if I open it with domain, the website is not getting open from this machine, and rest of the world can open. Check the DNS. Can this machine 'ping' it's own real world address (as both an IP and a name) ? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Problem with accented character in file names and CFFILE
I believe this is a multilanguage issue. Check on multilanguage settings in your CF Admin if you have access. Or, if it is expected that people will be naming things using accents frequently, parse out accented letters and replace with the corresponding unaccented letters prior to executing your CFFILE. Much like you would do should you not want people to use numbers or such. Hope this points you in the right direction. ~Guy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: DHTML Drag and Drop to reorder record set
I'm not a DHTML guy by any means. Could someone point me in the right direction to figuring out how to use DHTML to take a record from within a record set, drag it to a higher or lower position, and have it change its position within the record set? Guy, I recently set up a drag-and-drop system for moving terms around within a taxonomy structure at a library.I used _javascript_.Requires a bit of doing, but it works really well.I won't go into all the detail, but hopefully I can give you enough to get you started.If you need more, let me know. The basic idea is that each drag and drop event triggers a location.replace() to a new page which processes data in the URL and location.replace()s back to the start page.To the user, the effect is that an operation takes place without leaving the start page. To make this work, you need to understand the _javascript_ drag-and-drop events, paying particular attention to which element fires the event. onDragOver onDragEnter onDragStart onDragEnd onDrop There might be a couple of others, but these are the ones I used. On entering the page, I set a global variable that stores the ID of the element being dragged, first with a dummy value (var dragID = -1;).This global ID is intended to be the place to check what element is being dragged.So, you have to set the onDragStart event to trigger a change in that global variable.If, for example, you have a hyperlinked task item with unique ID 645, you can add > to the a tag.In enableTermDrop(), you set that global variable (dragID) to #TaskItemID#, or 645.Similarly, onDragEnd, you run a routine like disableTermDrop() that sets dragID back to -1.Now, whatever is happening, you always have the ID of the item currently being dragged in dragID. Next, you set the onDrop event of the target elements (those onto which other elements are dropped) to fire something like launchTermDrop().Pass the ID of the target element as an argument.That way, launchTermDrop() has the target (from that argument) and the element that is being dragged and dropped (by reading global variable dragID), and you are in business.Build a URL to a page that knows what to do and location.replace() to that URL. You can make this much more sophisticated by adding more global variables to store other parameters pertaining to the term being dragged.This will usually involve adding many more arguments to the event-driven function calls. VERY IMPORTANT: develop a naming convention early, and stick to it religiously.With the terms drag and drop flying around, and with seven total events that are triggered by different items, this will get confusing very fast.I used the convention drag{VARIABLENAME} for the item being dragged, and target{VARIABLENAME} for the target element. Finally, to get really fancy, you can add keypress sensitivity to the launchTermDrop() routine.This will let you handle the drop differently if the user is holding down the Ctrl key, for example. A bit confusing, but VERY MUCH WORTH IT.You end up with a very slick app. If the tasks being performed are at all repetitive, you get a huge increase in productivity.What used to take several mouse clicks and keystrokes will now take one drag and drop. Good luck! Matthieu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: DHTML Drag and Drop to reorder record set
Hi Matthieu, That's exactly the launching pad I was hoping for. Not to mention the exact same functionality that I am going for. Your description is excellent and concise. Might you think of doing a tutorial on it for other folks? Thanks again. ~Guy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT- netstat report
That thing works well. and problem is gone. But I don't understand one thing. Can this entry could be removed when I un-install the sp2? i mean it was working fine 2 days ago. and suddenly it stops serving locally. What could be the cause of this. removal of sp2 or something else. If you're on windows, you can modify your hosts file and map the domain name to an ip manually in there. The file is in C:\WINDOWS\system32\drivers\etcand it's called hosts Just add a line in there such as 192.168.0.5 www.mysite.com http://www.mysite.com/ and it should work from your computer. You can do the same thing on other people's pc's.If this needs to be done on a lot of people's computers, probably the best bet would be to have an internal DNS server. Russ _ From: Yves Arsenault [mailto:[EMAIL PROTECTED] Sent: Thursday, September 02, 2004 10:18 AM To: CF-Talk Subject: Re: OT- netstat report Can you use the domain names on other PCs on the network and see the sites properly? Here, we're behind a firewall using NAT... port forwarding... Presently, I cannot use domain nameswith other PCs on the network. If I do, I just get the firewall box. But the external world has access without trouble. (I'm waiting for this to be fixed) I was told we needed another DNS server to serve internal requests. As I am not the network admin, I have not resolved this problem. So, on the webserver here, I cannot access the site by domain name, even if I'm on the server (the actual box the request comes to) because of the NAT box. Just thought I would throw that out there... Yves - Original Message - From: Asim Manzur [EMAIL PROTECTED] Date: Fri, 03 Sep 2004 09:40:23 -0400 Subject: Re: OT- netstat report To: CF-Talk [EMAIL PROTECTED] Yes I ping the domain from the same machine, and got response. I ping the external static ip, got response. I ping the internal ip, got response. I ping the computer name, got response. infact I ping outside the network and got response as well. thanks On Friday 03 Sep 2004 13:10 pm, Asim Manzur wrote: If I open it as a localhost from the same machine, yes then the website opened, but if I open it with domain, the website is not getting open from _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: DHTML Drag and Drop to reorder record set
Basically what I have is like a to do list. But lets say I want to take item #5 and drop it between item #2 and #3 so it becomes the new #3 and the old #3 becomes #4 and so on. I think in your case, I wouldn't use true drag'n drop, I mean drag events. Drag events are really to copy some content and paste it some where else. In your case, what you want to do is just identify an element in an array and rearrange that array depending where you drop the element. Just use mousedown event to identify the element being dragged, change the cursor, and use a mouseup event to identify where the drop occurs, But do not use drag events for this, it is much too complicated for what you need. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFHTTP Alternatives
I did read the docs. The docs state: encoded Optional Yes Applies to FormField and CGI types; ignored for all other types. Specifies whether to URLEncode the form field or header. I am using it on a cookie type. Russ _ From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: Thursday, September 02, 2004 10:52 AM To: CF-Talk Subject: Re: CFHTTP Alternatives On Fri, 3 Sep 2004 10:16:17 -0400, Russ [EMAIL PROTECTED] wrote: Since CFHTTP support is broken in all versions since CF 4.5 (as in CFHTTPPARAM automatically urlencodes all the names and values, and there's nothing we can do about it), I was wondering if there are any CFMX alternatives to CFHTTP, short of writing your own java classes every time you need to post something.Isn't there a way to extend the CFHTTPPARAM tag or something and modify certain methods not to URLEncode the data? Dude, you just have to read the docs: http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-p59.htm#wp110004 9 We use it extensively just fine. Look at the encoded attribute. Regards, Dave. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Problem with accented character in file names and CFFILE
Is this a CF problem or any OS problem Looks like an OS issue, does Linux support accents in file names? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Horoscope Custom tag or UDF
Hi everyone, Does somebody have a reference to any custom tag or udf written to get the zodiac sign from a day and month. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFHTTP Alternatives
There is an alternative written in c++ http://www.cftagstore.com/tags/cfxhttp5.cfm I havn't used it but the claims made on the website are impressive. Andrew. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Cold Fusion and Oracle Unsupported Data Conversion
I'll post back with more information about drivers. I'm going to be running test against oracle's drivers, as well as the latest ones MM released with the updater. (I'm still struggling with a thread locking issues, on another system, that seem to be related to the DataDirect 3.2 drivers not dealing with Oracle deadlocks very well) -Adam - Original Message - From: Deanna Schneider [EMAIL PROTECTED] Date: Fri, 3 Sep 2004 08:45:29 -0500 Subject: Re: Cold Fusion and Oracle Unsupported Data Conversion To: CF-Talk [EMAIL PROTECTED] Not Adrocknaphobia, but as far as we'er concerned Don't know - the updated drivers crash our whole system. :( - Original Message - From: Thomas Chiverton Do you still see the error with the updated drivers from the Updater ? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Horoscope Custom tag or UDF
Please disregard this email. I found one on www.cflib.org On Fri, 3 Sep 2004 11:19:43 -0400, Qasim Rasheed [EMAIL PROTECTED] wrote: Hi everyone, Does somebody have a reference to any custom tag or udf written to get the zodiac sign from a day and month. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFHTTP Alternatives
On Fri, 3 Sep 2004 11:18:05 -0400, Russ [EMAIL PROTECTED] wrote: I did read the docs. The docs state: encoded Optional Yes Applies to FormField and CGI types; ignored for all other types. Specifies whether to URLEncode the form field or header. I am using it on a cookie type. Ah, you never mentioned you were using it on cookies. However, is this really an issue for you? We have a PDF engine written in Python that runs on Linux that does a callback to a CF page, and the cookies transfer fine for us (and if they weren't, our stuff would break because it relies on the CFID/CFTOKEN values in the user's cookie for client variable stuff). Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Problem with accented character in file names and CFFILE
I did think about parsing the file name and replacing the characters, but the people the site is for will not allow the file name to be changed. It is a government funded project and therefore everything has not be exactly right!!! Andrew. - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Fri, 3 Sep 2004 10:59:32 -0400 Subject: Re: Problem with accented character in file names and CFFILE To: CF-Talk [EMAIL PROTECTED] I believe this is a multilanguage issue. Check on multilanguage settings in your CF Admin if you have access. Or, if it is expected that people will be naming things using accents frequently, parse out accented letters and replace with the corresponding unaccented letters prior to executing your CFFILE. Much like you would do should you not want people to use numbers or such. Hope this points you in the right direction. ~Guy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFHTTP Alternatives
Yes, it really is an issue, as several sites that I'm pulling the data from require login, and they don't recognize the URLEncoded session cookies sent by CF. Russ _ From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: Friday, September 03, 2004 11:31 AM To: CF-Talk Subject: Re: CFHTTP Alternatives On Fri, 3 Sep 2004 11:18:05 -0400, Russ [EMAIL PROTECTED] wrote: I did read the docs. The docs state: encoded Optional Yes Applies to FormField and CGI types; ignored for all other types. Specifies whether to URLEncode the form field or header. I am using it on a cookie type. Ah, you never mentioned you were using it on cookies. However, is this really an issue for you? We have a PDF engine written in Python that runs on Linux that does a callback to a CF page, and the cookies transfer fine for us (and if they weren't, our stuff would break because it relies on the CFID/CFTOKEN values in the user's cookie for client variable stuff). Regards, Dave. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Problem with accented character in file names and CFFILE
Looks like an OS issue, does Linux support accents in file names? If I FTP the file up it works ok, so I guess Linux is ok with the accented file name. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Cold Fusion and Oracle Unsupported Data Conversion
I'd be interested to hear how the Oracle drivers work for you. We had to roll back from the latest MM drivers. But, I don't think they've tried any of the Oracle ones. Are there new drivers with this latest release? It hasn't been installed here yet. - Original Message - From: Adrocknaphobia I'll post back with more information about drivers. I'm going to be running test against oracle's drivers, as well as the latest ones MM released with the updater. (I'm still struggling with a thread locking issues, on another system, that seem to be related to the DataDirect 3.2 drivers not dealing with Oracle deadlocks very well) -Adam [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Problem with accented character in file names and CFFILE
On Fri, 3 Sep 2004 16:41:01 +0100, Andrew Dixon [EMAIL PROTECTED] wrote: I did think about parsing the file name and replacing the characters, but the people the site is for will not allow the file name to be changed. It is a government funded project and therefore everything has not be exactly right!!! Is this just an encoding issue though? Your OS's encoding might be ISO-8859-1, which would mangle the special characters, whereas you might need UTF-8 to have them come through OK. I don't really know what the OS-level solution is, but for CF, search the archives for setEncoding, as there's been a bunch of threads related to this. Don't know how much help that is, but thought I'd throw it out there. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Capture cflocations/redirects
I'm experiencing some kind of redirect/cflocation endless loop.Is there some easy way to trap the iterations of this loop so that I can see what is trying to redirect to where? -- Ian Skinner Web Programmer BloodSource file:///C:\Documents%20and%20Settings\iskinner\Application%20Data\Microsoft\Signatures\www.BloodSource.org www.BloodSource.org http://www.BloodSource.orgSacramento Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice:This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFHTTP Alternatives
Thanks Andrew, I'll try it. Seems impressive. Russ _ From: Andrew Grosset [mailto:[EMAIL PROTECTED] Sent: Friday, September 03, 2004 11:22 AM To: CF-Talk Subject: Re: CFHTTP Alternatives There is an alternative written in c++ http://www.cftagstore.com/tags/cfxhttp5.cfm I havn't used it but the claims made on the website are impressive. Andrew. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Capture cflocations/redirects
Ian Skinner wrote: I'm experiencing some kind of redirect/cflocation endless loop.Is there some easy way to trap the iterations of this loop so that I can see what is trying to redirect to where? Recording proxy or the FireFox LiveHTPHeaders plugin. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: DHTML Drag and Drop to reorder record set
Guy, Thanks for the kind words.The truth is that I learned by reading some tutorial somewhere myself.If I could have remembered where it was, I would have just sent you the link, because it was quite good. That said, my application of what I learned was more specifically geared toward interaction with a ColdFusion-generated database list.If this is something that would be of interest as an article somewhere (Mr. Dinowitz?), I might try putting it together. In any case, thanks again for the praise. Matthieu -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, September 03, 2004 11:09 AM To: CF-Talk Subject: RE: DHTML Drag and Drop to reorder record set Hi Matthieu, That's exactly the launching pad I was hoping for. Not to mention the exact same functionality that I am going for. Your description is excellent and concise. Might you think of doing a tutorial on it for other folks? Thanks again. ~Guy _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Problem with accented character in file names and CFFILE
I had the same problem with CF and BlueDragon and I had to write something like this to change the file name on the server.. I kept the original name in my database and when I serve the file with cfcontent I rename to the original name. Since my variable name are in french, the first one is all caracter capitalize and not with accent and the second variable are there equivalent without accent. cfset accentminmaj = Chr(193) , Chr(194) , Chr(195) , Chr(196) , Chr(197) , Chr(224) , Chr(225) , Chr(226) , Chr(227) , Chr(228) , Chr(229) , Chr(200) , Chr(201) , Chr(202) , Chr(203) , Chr(232) , Chr(233) , Chr(234) , Chr(235) , Chr(204) , Chr(205) , Chr(206) , Chr(207) , Chr(236) , Chr(237) , Chr(238) , Chr(239) , Chr(210) , Chr(211) , Chr(212) , Chr(213) , Chr(214) , Chr(242) , Chr(243) , Chr(244) , Chr(245) , Chr(246) , Chr(217) , Chr(218) , Chr(219) , Chr(220) , Chr(249) , Chr(250) , Chr(251) , Chr(252) , Chr(209) , Chr(241) , Chr(199) , Chr(231) , Chr(221) , Chr(253) cfset sansaccentminmaj = Chr(97) , Chr(97) , Chr(97) , Chr(97) , Chr(97) , Chr(97) , Chr(97) , Chr(97) , Chr(97) , Chr(97) , Chr(97) , Chr(101) , Chr(101) , Chr(101) , Chr(101) , Chr(101) , Chr(101) , Chr(101) , Chr(101) , Chr(105) , Chr(105) , Chr(105) , Chr(105) , Chr(105) , Chr(105) , Chr(105) , Chr(105) , Chr(111) , Chr(111) , Chr(111) , Chr(111) , Chr(111) , Chr(111) , Chr(111) , Chr(111) , Chr(111) , Chr(111) , Chr(117) , Chr(117) , Chr(117) , Chr(117) , Chr(117) , Chr(117) , Chr(117) , Chr(117) , Chr(110) , Chr(110) , Chr(99) , Chr(99) , Chr(121) , Chr(121) cfset nom_fichier2 = #replacelist(lcase(replace(getfilefrompath(form.nom_fichier), ,_,ALL)),accentminmaj,sansaccentminmaj)# Pat _ From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: September 3, 2004 11:47 To: CF-Talk Subject: Re: Problem with accented character in file names and CFFILE On Fri, 3 Sep 2004 16:41:01 +0100, Andrew Dixon [EMAIL PROTECTED] wrote: I did think about parsing the file name and replacing the characters, but the people the site is for will not allow the file name to be changed. It is a government funded project and therefore everything has not be exactly right!!! Is this just an encoding issue though? Your OS's encoding might be ISO-8859-1, which would mangle the special characters, whereas you might need UTF-8 to have them come through OK. I don't really know what the OS-level solution is, but for CF, search the archives for setEncoding, as there's been a bunch of threads related to this. Don't know how much help that is, but thought I'd throw it out there. Regards, Dave. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Capture cflocations/redirects
I'm experiencing some kind of redirect/cflocation endless loop.Is there some easy way to trap the iterations of this loop so that I can see what is trying to redirect to where? Create a custom tag to wrap the cflocation tag. Replace all instances of cflocation with cf_location or whatever the name of your tag is. Within the tag, add a line to a text file with cffile action="" to show a log of what's been redirected and to where. Run your page, check the log. hth s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 http://www.sys-con.com/story/?storyid=45569DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Capture cflocations/redirects
I'm experiencing some kind of redirect/cflocation endless loop.Is there some easy way to trap the iterations of this loop so that I can see what is trying to redirect to where? Ian, I don't know if this applies, but when I have confusing and unplanned page-to-page routing, I add a dummy URL variable to suspect statements that do the routing.That allows me to see whether that statement is in fact the one doing the redirecting, since the page it arrives at will have the variable in the URL.Since you have a loop, I would both add this dummy variable and cut the loop somewhere, so that it stops in its tracks.By trial-and-error, you should be able to test each of the redirects. I'm afraid that it's not the easiest way in the world.Still, it shouldn't take more than a few minutes to find the problem. HTH, Matthieu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFHTTP Alternatives
Russ wrote: I did read the docs. The docs state: encodedOptional Yes Applies to FormField and CGI types; ignored for all other types. Specifies whether to URLEncode the form field or header. I am using it on a cookie type. IIRC you can use the CGI type to send cookies as well: cfhttpparamtype=cgi name=Cookie value=cfid=123456 encoded=No Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CF version?
Hi, is there a tag or something to know exactly what is the CF version on our hosting? Thanks Pat [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Capture cflocations/redirects
S.Isaac Dealey wrote: I'm experiencing some kind of redirect/cflocation endless loop.Is there some easy way to trap the iterations of this loop so that I can see what is trying to redirect to where? Create a custom tag to wrap the cflocation tag. Replace all instances of cflocation with cf_location or whatever the name of your tag is. Within the tag, add a line to a text file with cffile action="" to show a log of what's been redirected and to where. Run your page, check the log. There may be an easier way to do that, but please think twice before you use it: http://www.spike.org.uk/blog/index.cfm Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Problem with accented character in file names and CFFILE
I did think about parsing the file name and replacing the characters, but the people the site is for will not allow the file name to be changed. Then keep the original file name in you db, store the document under any file name you want, store this on as well in you db, then restitute the original file name when some one downloads it. How are you handle duplicates in names anyway? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CF version?
#server.coldfusion.productversion# I think... Hi, is there a tag or something to know exactly what is the CF version on our hosting? Thanks Pat s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 http://www.sys-con.com/story/?storyid=45569DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CF version?
server.ColdFusion.ProductVersion Should tell you what you need to know Spike Stephen Milligan Code poet for hire http://www.spike.org.uk Do you cfeclipse? http://cfeclipse.tigris.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of CFDEV Sent: Friday, September 03, 2004 9:03 AM To: CF-Talk Subject: CF version? Hi, is there a tag or something to know exactly what is the CF version on our hosting? Thanks Pat [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CF version?
It's one of the SERVER scoped vars I think try a page with CFDUMP var=#SERVER# and you should see it...it's part of the debugging output. Of course you could just ask the ISP ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com - Original Message - From: CFDEV To: CF-Talk Sent: Friday, September 03, 2004 9:03 AM Subject: CF version? Hi, is there a tag or something to know exactly what is the CF version on our hosting? Thanks Pat [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: DHTML Drag and Drop to reorder record set
I was going to suggest something similar.You could use a + and - button to move the item up or down.Then _javascript_ just needs to find the currently selected item(s) and then add or subtract one to the index and adjust the other indexes accordinly to move the others into the right place.I guess my other question would be, how are you going to make these changes stick in the database or wherever you store these? John -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Friday, September 03, 2004 11:17 AM To: CF-Talk Subject: Re: DHTML Drag and Drop to reorder record set Basically what I have is like a to do list. But lets say I want to take item #5 and drop it between item #2 and #3 so it becomes the new #3 and the old #3 becomes #4 and so on. I think in your case, I wouldn't use true drag'n drop, I mean drag events. Drag events are really to copy some content and paste it some where else. In your case, what you want to do is just identify an element in an array and rearrange that array depending where you drop the element. Just use mousedown event to identify the element being dragged, change the cursor, and use a mouseup event to identify where the drop occurs, But do not use drag events for this, it is much too complicated for what you need. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Tool for data conversion
is there any tool out there to convert the infobase data to access or MSSQL or maybe excel. Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CF version?
Pat, Charlie Arehart wrote a tag that checked the server for the CF version.Info on it can be found here: http://www.findarticles.com/p/articles/mi_m0MLU/is_5_5/ai_101527468 I can't find anything online that shows he has updated it in the last 18 months or so. Rick Mason - Original Message - From: CFDEV [EMAIL PROTECTED] Date: Fri, 3 Sep 2004 12:03:16 -0400 Subject: CF version? To: CF-Talk [EMAIL PROTECTED] Hi, is there a tag or something to know exactly what is the CF version on our hosting? Thanks Pat [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CF version?
Try this code: CFOUTPUT Product: #Server.ColdFusion.ProductName#BR Version: #Server.ColdFusion.ProductVersion#BR Level: #Server.ColdFusion.ProductLevel#BR CFOUTPUT Or just dup the SERVER scope. _ From: Rick Mason [mailto:[EMAIL PROTECTED] Sent: Friday, September 03, 2004 12:46 PM To: CF-Talk Subject: Re: CF version? Pat, Charlie Arehart wrote a tag that checked the server for the CF version.Info on it can be found here: http://www.findarticles.com/p/articles/mi_m0MLU/is_5_5/ai_101527468 I can't find anything online that shows he has updated it in the last 18 months or so. Rick Mason - Original Message - From: CFDEV [EMAIL PROTECTED] Date: Fri, 3 Sep 2004 12:03:16 -0400 Subject: CF version? To: CF-Talk [EMAIL PROTECTED] Hi, is there a tag or something to know exactly what is the CF version on our hosting? Thanks Pat _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFHTTP Alternatives
On Fri, 03 Sep 2004 18:01:25 +0200, Jochem van Dieten [EMAIL PROTECTED] wrote: Russ wrote: I did read the docs. The docs state: encodedOptional Yes Applies to FormField and CGI types; ignored for all other types. Specifies whether to URLEncode the form field or header. I am using it on a cookie type. IIRC you can use the CGI type to send cookies as well: cfhttpparamtype=cgi name=Cookie value=cfid=123456 encoded=No Jochem's correct, as usual. I just re-checked our code (we wrote it a long time ago), and that is, in fact, how we pass the values. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Unicode Problem [solved]
Jillian Koskie wrote: I'm moving an application from CF 5 to CFMX... and I'm having a problem with some of my data. The database is PostgreSQL. For posterity: The database was originally using the encoding SQL-ASCII. With CF 5 this results in characters with accents being treated as opaque, while in CF MX this will throw exceptions in the driver. The solution is to convert the database from SQL-ASCII to unicode. In order to do that: - use pg_dump to dump the current database to a flat file - open the flat file in an encoding aware text editor and save it as UTF-8 (or use a dedicated conversion utility) - create a new database with encoding unicode - use pg_restore to load the dump into the new database - verify that everything works well from the new database - verify again :) - rename the old and the new databases Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Cold Fusion and Oracle Unsupported Data Conversion
Yeah, according to Forta one of the major reasons they relased the 6.1 Updater was because they got some new drivers made for Blackstone and didnt want to make us wait for them. Previously the lastest dataDirect driver they released was 3.3, so I assume that the ones included with the 6.1 Updater are 3.4. NEway, I got one task in between me and deploying different drivers to our test servers. I'll let you know what I find. There is also a 3rd reason I'm testing other drivers... LOBs. We keep running into issues using BLOBs with CFMX. Currently I have java classes in place for each application to manage clobs, but I'd like to get it to work with stored procedures. -Adam - Original Message - From: Deanna Schneider [EMAIL PROTECTED] Date: Fri, 3 Sep 2004 10:46:28 -0500 Subject: Re: Cold Fusion and Oracle Unsupported Data Conversion To: CF-Talk [EMAIL PROTECTED] I'd be interested to hear how the Oracle drivers work for you. We had to roll back from the latest MM drivers. But, I don't think they've tried any of the Oracle ones. Are there new drivers with this latest release? It hasn't been installed here yet. - Original Message - From: Adrocknaphobia I'll post back with more information about drivers. I'm going to be running test against oracle's drivers, as well as the latest ones MM released with the updater. (I'm still struggling with a thread locking issues, on another system, that seem to be related to the DataDirect 3.2 drivers not dealing with Oracle deadlocks very well) -Adam [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Cold Fusion and Oracle Unsupported Data Conversion
On Fri, 3 Sep 2004 13:15:31 -0400, Adrocknaphobia [EMAIL PROTECTED] wrote: Yeah, according to Forta one of the major reasons they relased the 6.1 Updater was because they got some new drivers made for Blackstone and didnt want to make us wait for them. Previously the lastest dataDirect driver they released was 3.3, so I assume that the ones included with the 6.1 Updater are 3.4. NEway, I got one task in between me and deploying different drivers to our test servers. I'll let you know what I find. There is also a 3rd reason I'm testing other drivers... LOBs. We keep running into issues using BLOBs with CFMX. Currently I have java classes in place for each application to manage clobs, but I'd like to get it to work with stored procedures. The Updater is still using the 3.3 driver family, but just a later build (I *believe* it's build 48). We are actually still using the Updater 3 Plus Oracle drivers because all drivers released after that set have issues (removeOnExceptions in pre-Rollup releases and dropping client variables in the latest Updater Rollup). Since we've downgraded the drivers, we haven't had to re-boot our instances once for performance reasons. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
SOT: More drag and drop
Ok, I know this is off topic, but the previous questions about the onDrag and onDrop events got me curious and since most government employees (my customers) are off today, I'm kinda piddling around with some ideas.With that said, I got some onDrag and onDrop events working with images dropping one on another.However, I can't seem to get it to work with text unless I select the text and then drag the selection. I'm basically trying to make a webmail program along the lines of what Microsoft did with the new Outlook Web Access where you can select a message from the list (From, Date, Subject) and drag it to a folder and have it move.I think the basic problem is that any time I click to drag, it selects the text.Anyone have any ideas on how to make the text so it's non-selectable or some way to make this work?I would appreciate any ideas that you would have. John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: More drag and drop
not 100% surebut the text could be in a div and the div could have somehting along the lines of onFocus(this.blur;);of course that may stop you from dragging it as well ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com - Original Message - From: Burns, John D To: CF-Talk Sent: Friday, September 03, 2004 10:20 AM Subject: SOT: More drag and drop Ok, I know this is off topic, but the previous questions about the onDrag and onDrop events got me curious and since most government employees (my customers) are off today, I'm kinda piddling around with some ideas.With that said, I got some onDrag and onDrop events working with images dropping one on another.However, I can't seem to get it to work with text unless I select the text and then drag the selection. I'm basically trying to make a webmail program along the lines of what Microsoft did with the new Outlook Web Access where you can select a message from the list (From, Date, Subject) and drag it to a folder and have it move.I think the basic problem is that any time I click to drag, it selects the text.Anyone have any ideas on how to make the text so it's non-selectable or some way to make this work?I would appreciate any ideas that you would have. John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SOT: More drag and drop
Check out the dragdrop library at http://www.walterzorn.comWe've used it for a couple things, and it's pretty slick. cheers, barneyb On Fri, 3 Sep 2004 13:20:13 -0400, Burns, John D [EMAIL PROTECTED] wrote: Ok, I know this is off topic, but the previous questions about the onDrag and onDrop events got me curious and since most government employees (my customers) are off today, I'm kinda piddling around with some ideas.With that said, I got some onDrag and onDrop events working with images dropping one on another.However, I can't seem to get it to work with text unless I select the text and then drag the selection. I'm basically trying to make a webmail program along the lines of what Microsoft did with the new Outlook Web Access where you can select a message from the list (From, Date, Subject) and drag it to a folder and have it move.I think the basic problem is that any time I click to drag, it selects the text.Anyone have any ideas on how to make the text so it's non-selectable or some way to make this work?I would appreciate any ideas that you would have. John Burns -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
request scope and grouped output
Hi All, I have a table that I would like to replicate each time the output loops through, based on grouping. However, within the table there are outputs that call to the request scope variables. That in turn throws an error as the request scope variables aren't a part of the grouped query's record set. Help? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SOT: More drag and drop
Check out the dragdrop library at http://www.walterzorn.comWe've used it for a couple things, and it's pretty slick. yeah we use walter's stuff (he's got a nifty js drawing lib too) for many clientside functions. its the bee's knees. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: request scope and grouped output
You can definitely call request-scoped variables from inside loops. Are you scoping the variable call with request.? cheers, barneyb On Fri, 3 Sep 2004 13:46:11 -0400, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi All, I have a table that I would like to replicate each time the output loops through, based on grouping. However, within the table there are outputs that call to the request scope variables. That in turn throws an error as the request scope variables aren't a part of the grouped query's record set. Help? -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Cold Fusion and Oracle Unsupported Data Conversion
Dave which version of the Oracle JDBC drivers are you using? -Adam - Original Message - From: Dave Carabetta [EMAIL PROTECTED] Date: Fri, 3 Sep 2004 13:23:19 -0400 Subject: Re: Cold Fusion and Oracle Unsupported Data Conversion To: CF-Talk [EMAIL PROTECTED] On Fri, 3 Sep 2004 13:15:31 -0400, Adrocknaphobia [EMAIL PROTECTED] wrote: Yeah, according to Forta one of the major reasons they relased the 6.1 Updater was because they got some new drivers made for Blackstone and didnt want to make us wait for them. Previously the lastest dataDirect driver they released was 3.3, so I assume that the ones included with the 6.1 Updater are 3.4. NEway, I got one task in between me and deploying different drivers to our test servers. I'll let you know what I find. There is also a 3rd reason I'm testing other drivers... LOBs. We keep running into issues using BLOBs with CFMX. Currently I have java classes in place for each application to manage clobs, but I'd like to get it to work with stored procedures. The Updater is still using the 3.3 driver family, but just a later build (I *believe* it's build 48). We are actually still using the Updater 3 Plus Oracle drivers because all drivers released after that set have issues (removeOnExceptions in pre-Rollup releases and dropping client variables in the latest Updater Rollup). Since we've downgraded the drivers, we haven't had to re-boot our instances once for performance reasons. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Need Function or UDF that does this...
I need a function or udf that is like find() or findNoCase() except that it searches backward from a starting point instead of forward. In other words, it finds the first occurance of a substring within a string but searches backwards from a starting point. Josen GoMotorbids.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Cold Fusion and Oracle Unsupported Data Conversion
On Fri, 3 Sep 2004 13:51:20 -0400, Adrocknaphobia [EMAIL PROTECTED] wrote: Dave which version of the Oracle JDBC drivers are you using? Using the script at the below URL, this is what I get: [Macromedia][Oracle JDBC Driver]Driver Version: 3.1.003921002406001721 Script: http://www.bpurcell.org/blog/index.cfm?mode=entryentry=988 Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Need Function or UDF that does this...
Still use Find() or FindNoCase()...but reverse the string using Reverse()...like so FindNoCase(Reverse(MyString)) HTH Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com - Original Message - From: Josen Ruiseco To: CF-Talk Sent: Friday, September 03, 2004 10:59 AM Subject: Need Function or UDF that does this... I need a function or udf that is like find() or findNoCase() except that it searches backward from a starting point instead of forward. In other words, it finds the first occurance of a substring within a string but searches backwards from a starting point. Josen GoMotorbids.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Need Function or UDF that does this...
On Fri, 03 Sep 2004 13:59:31 -0400, Josen Ruiseco [EMAIL PROTECTED] wrote: I need a function or udf that is like find() or findNoCase() except that it searches backward from a starting point instead of forward. In other words, it finds the first occurance of a substring within a string but searches backwards from a starting point. If there isn't one at cflib.org already, it wouldn't be very hard to write yourself. The key part would be something like: find(substring, reverse(myString)) reverse() is built in to CF, so nothing special needed. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Need Function or UDF that does this...
How about passing the string to reverse() first.Won't be perfect, because you'll need to reverse your search string as well, and then subtract the returned index from the length, and unreverse everything to use it, but it'll function.YOu can wrap all that up in a UDF pretty easily. Or, if you're on CFMX and feeling adventurous, you can use the lastIndexOf() method of the String class like this: str = this is a test string; i = str.lastIndexOf(is) + 1; I'm finding the last index of the string is.Make sure you add one to the result though, because Java is zero-indexed while CF is one-indexed. cheers, barneyb On Fri, 03 Sep 2004 13:59:31 -0400, Josen Ruiseco [EMAIL PROTECTED] wrote: I need a function or udf that is like find() or findNoCase() except that it searches backward from a starting point instead of forward. In other words, it finds the first occurance of a substring within a string but searches backwards from a starting point. Josen GoMotorbids.com -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: DHTML Drag and Drop to reorder record set
It doesn't do everything you want, but the core of it can be accomplished easily using my ObCollectionOrdered _javascript_ abstraction here (long URL alert!): http://www.depressedpress.com/depressedpress/Content/Development/_javascript_/ Extensions/ObCollectionOrdered/Index.cfm The collection object allows you to store object while maintaining order and provides full rank and sorting functions to move elements around, promote them, demote them, sort them, swap positions, etc. There a sample on the site than shows you how to do this in a Select list. I've used it to do something similar to what you're asking about - I populate a div by looping over the collection and displaying it's elements (how you do that is up to you).Then the interface determines how to order them - for example if you drag onto an element you can easily insert that object into the collection.Then all you have to do is rerun the display function. In essence all you're doing is making changes the abstraction object based on interface events and then redisplaying it.Don't bother trying to modify the display to represent your object manipulations: just redisplay the whole thing from scratch._javascript_ is so fast it makes no difference and it's much, much simpler. Jim Davis From: Guy McDowell [mailto:[EMAIL PROTECTED] Sent: Friday, September 03, 2004 10:13 AM To: CF-Talk Subject: DHTML Drag and Drop to reorder record set Hi, I'm not a DHTML guy by any means. Could someone point me in the right direction to figuring out how to use DHTML to take a record from within a record set, drag it to a higher or lower position, and have it change its position within the record set? Basically what I have is like a to do list. But lets say I want to take item #5 and drop it between item #2 and #3 so it becomes the new #3 and the old #3 becomes #4 and so on. I've got the logic basically but not the code. Any good tutorials or examples of something similar? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Need Function or UDF that does this...
These suggestions are all good. The problem I have is that I am searching out text from an cfhttp call. When I reverse the cfhttp.filecontent it becomes a huge mess and is difficult to work with. Thanks for the ideas... Josen How about passing the string to reverse() first.Won't be perfect, because you'll need to reverse your search string as well, and then subtract the returned index from the length, and unreverse everything to use it, but it'll function.YOu can wrap all that up in a UDF pretty easily. Or, if you're on CFMX and feeling adventurous, you can use the lastIndexOf() method of the String class like this: str = this is a test string; i = str.lastIndexOf(is) + 1; I'm finding the last index of the string is.Make sure you add one to the result though, because Java is zero-indexed while CF is one-indexed. cheers, barneyb On Fri, 03 Sep 2004 13:59:31 -0400, Josen Ruiseco [EMAIL PROTECTED] wrote: I need a function or udf that is like find() or findNoCase() except that it searches backward from a starting point instead of forward. In other words, it finds the first occurance of a substring within a string but searches backwards from a starting point. Josen GoMotorbids.com -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb. com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]