Re: Why .Net is on its last legs

2010-01-21 Thread Claude Schnéegans
>>Well, its nice to program these elegant elaborate fully object oriented systems in C# and be able to whip out a console application once in a while, as needed. Sure, it makes one feel smart to throw all these fancy acronyms and names and have a full knowledge that the stuff you work on is s

Content-transfer-Encoding: quoted-printable

2010-02-04 Thread Claude Schnéegans
Hi, I have some news letters sent to customers in HTML by some CF code. Although I read them perfectly myself using Thunderbird, some users are complaining that they see the HTML codes instead of a well formated page. So I'm trying to improve the way messages are encoded. I can see in many messa

Re: Content-transfer-Encoding: quoted-printable

2010-02-04 Thread Claude Schnéegans
>>If you're using CFMAIL should be sure to set the type as HTML Sure I declare the type as HTML. My question is about encoding the body in quoted-printable. The text is in French iso-8859-1, and 8bit transfer is said not sure, so I need to use 7bit, then the body needs to be quoted-printable.

Re: Content-transfer-Encoding: quoted-printable

2010-02-04 Thread Claude Schnéegans
>>and 8bit transfer is said not sure I mean 8bit transfer is not safe. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.c

Re: Content-transfer-Encoding: quoted-printable

2010-02-04 Thread Claude Schnéegans
>>If you're using CFMAIL should be sure to set the type as HTML Sure I declare the type as HTML. My question is about encoding the body in quoted-printable. The text is in French iso-8859-1, and 8bit transfer is said not sure, so I need to use 7bit, then the body needs to be quoted-printable.

Re: cfmodule and query of queries

2010-02-09 Thread Claude Schnéegans
>>But I can't figure out how to pass the query from one module to another. You can also set your query in the request scope, ie : request.MyQuery The request scope is visible in any module and sub modules. ~| Want to reach the

Re: SOT: directory protection

2010-02-12 Thread Claude Schnéegans
5. rename all you pdf files with cfm extensions so that if users call them they will be filtered by application.cfm and use some download CF code like GetPdf.cfm?file=MyPdf that will send MyPdf.cfm as a pdf file using CFCONTENT. ~

Re: SOT: directory protection

2010-02-12 Thread Claude Schnéegans
>>I would not include renaming PDF files as an option, since the #3 option in Dave's list is a similar idea that is better. I suppose you mean solution #4, which is not a bad idea indeed, if you can create a non Web accessible directory, which is not always allowed by all providers. My solutio

Re: SOT: directory protection

2010-02-13 Thread Claude Schnéegans
>>Well, if you're going to use CFCONTENT to serve the files, there's no point in renaming them, is there? Yes, if you cannot store them in some non Web accessible directory, which was my case for many years before I got my own dedicated server. By renaming them .cfm, they are automatically pro

The JVM library could not be found.

2010-02-13 Thread Claude Schnéegans
Hi, I've lost my whole day on that problem. I have a CF5 server on my developping WIndows XP desktop, using some Java CFX. Since it was compiled using Java 1.4 I upgraded my Java to version 1.6, everything works fine. Now I'm trying to install the same thing on my Win 3000 server, same copy of

Re: The JVM library could not be found.

2010-02-13 Thread Claude Schnéegans
>>Joking aside, I'll assume 2003 server. He he yeah, 2003 of course ;-) >>Did you try putting the jvm in a place with no spaces in the name? Maybe that is causing issues? Hmmm, if this was an issue, it could not be from CF5 since the same copy of CF5 has no problem with the same name under W

Re: The JVM library could not be found.

2010-02-14 Thread Claude Schnéegans
>>Check your system's PATH environment variable. Ok, but were is it, and what should it contain? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive:

Re: The JVM library could not be found.

2010-02-14 Thread Claude Schnéegans
Ok, I uninstalled Java, reinstalled it under C:\Java, set the Java Virtual Machine Path in the CF Administrator, ... and still the same problem :-( ~| Want to reach the ColdFusion community with something they want? Let them kn

Re: The JVM library could not be found.

2010-02-14 Thread Claude Schnéegans
>>I think Dave meant to also check the windows _environment_ variable named PATH. Ok, I did, but what should be in there? Here is what I have on my production server wher the JVM is not found: C:\Program Files\Mail Enable\BIN;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem And h

Re: The JVM library could not be found. SOLVED

2010-02-14 Thread Claude Schnéegans
Ok, I checked the path variable using the ECHO command line, and it showed many paths that were not shown in the Windows computer management properties. This time, I see many paths to java versions used by Oracle, MySQL, etc. This is why it works on my destop. So I added paths to my new instal

Re: The JVM library could not be found. SOLVED

2010-02-15 Thread Claude Schnéegans
>>and you wouldn't want all of them to set global environment variables. Well, actually I don't care, all I want is that a piece of soft I do not want installs itself correctly if it is needed by some other soft I want. The problem was also (as very often) that the error message was inappropr

Re: Using CFHTTP to access a website

2010-02-19 Thread Claude Schnéegans
>>CFHTTP can access anything a browser on the same machine can access, ... except if the site checks if the IP address requested the form before it receives the action request. In this case, one should at least request the form page first. ~~

Re: CFIF within CFmail?

2010-02-22 Thread Claude Schnéegans
>>You can easily put CFIF inside of your cfmail tag. You can have CF statements between the opening http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331024 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_list

Re: CFBuilder RDS Query Viewer max rows

2010-03-25 Thread Claude Schnéegans
>>Inside a cfquery, right click and do SQL Editor. Thanks for the tip. The video show how to build a select with an ORDER BY clause. Is there any provision for more complex clauses and queries like WHERE, GROUP BY, UNION, or JOINs ? ~

Re: CFBuilder RDS Query Viewer max rows

2010-03-25 Thread Claude Schnéegans
>>You can write _anything_. Ok, so, if I understand well the editor will just help you to select tables and column names, the rest of the syntax, commands, parenthesis and clauses is up to you. ~| Want to reach the ColdFusion

Re: cfhttp Connection Failure

2010-04-19 Thread Claude Schnéegans
>>http://xmlfeed.laterooms.com/index.aspx?aid=1000&rtype=4&kword=cardiff"; method="get"> but despite getting status code 200 OK the content is 'Connection Failure'. I had this problem too, with CF 7 and 8 and never been able to find a solution. It is such a problem for my applications that I'

Re: cfhttp Connection Failure

2010-04-19 Thread Claude Schnéegans
>>It looks like they are trying to set a cookie for authentication or at least to maintain a session. If they check for a cookie and do not find it, they would return some error message, but not a 200 status and a connection failure in the same time. And if it works under CF 5 and not under C

Re: cfhttp Connection Failure

2010-04-19 Thread Claude Schnéegans
>>Have you tried CF9? Actually no. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messag

Re: cfhttp Connection Failure

2010-04-20 Thread Claude Schnéegans
>>It is true that cfhttp can't handle compressed responses and if you are hitting a web server that is gzipping the HTTP response you will get a "Connection Failure" Again, if CF5 can receive the page with no problem, and CFMX cannot, the problem is not on the server side, it is with CFMX. The

Re: cfhttp Connection Failure

2010-04-20 Thread Claude Schnéegans
>>Your sure it's compressed responses and not something else? No, I,m not sure. The only thing I'm sure is that CFMX is doing the HTTP request differently and the way it does it causes it to fail. With CF 5 there is no problem. >>s it a secure URL? No, it is not. ~~

Re: Anyone done this before???

2010-05-07 Thread Claude Schnéegans
>>how the heck can I get this to run online??? Reprogram the whole report in CF. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusio

Re: Convert to number

2010-05-13 Thread Claude Schnéegans
>>I was assuming CF would not choke on something so commonplace. Programing languages obey syntax rules, not commonplace. I've worked with tens of different languages in my career, I've never seen one taking commas in numbers. ~~~

Re: listgetat problem...

2010-05-16 Thread Claude Schnéegans
>>I currently have the same problem. Same as what? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusi

Re: Is it time for Adobe to Rebrand Cold Fusion?

2010-06-25 Thread Claude Schnéegans
>>Java Fusion Please NO ! Enough Java con-fusion with Java and Javascript. ;-) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Arc

Re: Order By question

2010-06-30 Thread Claude Schnéegans
>>I respectfully disagree with this approach. Doing it in the db will be much faster. Not so sure: If the query has to be ordered by the name, it could use an internal index. If it has to be sorted by some artificial column, there is no index and the query could be much longer. So IMO this ap

Query returning a list for a JOIN

2010-07-06 Thread Claude Schnéegans
Hi, There is something I cannot figure a simple way of doing it, either in SQL or in CF. JOINS in SQl are relly handful, but sometimes, they can generate qute big queries for nothing. Suppose I have this: SELECT , table2.justOneColumn FROM table1 LEFT JOIN table2 ON table1.column1 = table2.colum

Re: Query returning a list for a JOIN

2010-07-06 Thread Claude Schnéegans
>>you would get Exactly, thanks, I'll see If I can migrate the database to SQL-Server. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffus

Re: (ot) Mail servers

2010-07-07 Thread Claude Schnéegans
>>I'm curious what you're running and how happy you are with it. I'm using MailEnable. Works well except for infinite loops from time to time, very hard to know why. It is an interesting question, I'd like to know if some one is using a solution that allows creation of new accounts from CF ?

Re: Looking for a CF Recipe script!

2010-07-07 Thread Claude Schnéegans
>>What do you mean by recipe script? Yeah, a script to manage a database of recipes ? or a recipe for a good script ? ;-) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Din

Re: Looking for a CF Recipe script!

2010-07-09 Thread Claude Schnéegans
>>Nobody calls their thumb their "zeroth" finger. Sure, but computers do not count on their fingers... ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155

Re: Something about Regular Expressions that I have never understood

2010-07-16 Thread Claude Schnéegans
>>But what I have never understood how to do is find a match and then a second match and extract or replace what's inbetween. I had the same problem, so I wrote a custom tag to do exactly this easyly: See http://www.cftagstore.com/tags/cfreextract.cfm ~~~

Re: Extracting part of a string

2010-07-20 Thread Claude Schnéegans
>>What I need is simple Try a simple solution : CF_REextract : http://www.cftagstore.com/tags/cfreextract.cfm ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/143

Re: Extracting part of a string

2010-07-21 Thread Claude Schnéegans
This crap how you call it, is nevetheless the seventh most sold CF tag at tagstore, with hundreds of satisfied buyers, and many positive comments. Many developers are not as good with regex as you are, this is for sure. If you don't need the tag, you're free not buying it, but please stop insulti

Re: Extracting part of a string

2010-07-21 Thread Claude Schnéegans
>>http://acoderslife.com I may spam every regex question as you claim, but I don't advertise my site in EVERY message like you. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Mich

Re: Extracting part of a string

2010-07-22 Thread Claude Schnéegans
>>CS is smart enough to write a regex for returning 123 from str123str in his sleep On the other hand, if you were so smart, you would have noticed that the tag does not "write a regex", but returns all strings in between TWO regex directly in a querry or a list that can be found in a large s

Is attributeCollection broken in CF 9 ?

2010-07-28 Thread Claude Schnéegans
Hi, I have a custom tag which is calling another CFX tag, and passing attributes via the attributeCollection attribute, ie: It has been working for years under CF 7 and 8, but now under CF 9, I get an error: "The tag does not have an attribute called attributecollection. " which means that the

Re: Is attributeCollection broken in CF 9 ?

2010-07-28 Thread Claude Schnéegans
>>I tried a simple test and got the error in both CF8 and CF9 when attributeCollection was used. Hmmm. May be I did not try it under CF 8. But I'm sure it worked for years under CF 7. ~| Order the Adobe Coldfusion Anthology no

Re: Is attributeCollection broken in CF 9 ?

2010-07-28 Thread Claude Schnéegans
>>At first glance seems identical to your issue. It is indeed, except for the error message itself. In this thread, the message is that "attributeCollection" is an attribute being used that is not supposed to be used in conjunction with other attributes in the tag. Which is weird since there is

Re: Is attributeCollection broken in CF 9 ?

2010-07-28 Thread Claude Schnéegans
>>Google = friend: Usually yes, but a search for exactly "not have an attribute called attributecollection" returns noting in any search engine :-( Kind of weird. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.

Re: Is attributeCollection broken in CF 9 ?

2010-07-28 Thread Claude Schnéegans
>>Why don't you paste the full error message and the code. I already posted it in my first post. The full error message is "The tag does not have an attribute called attributecollection. " on the line: This line is inside a standard CF_custom tag, then the attributes scope exists. The error c

Re: Is attributeCollection broken in CF 9 ?

2010-07-28 Thread Claude Schnéegans
>>Are you use that is supported in CFX tags? At least it was in CF 7. I've been using this tool I developed myself for years. First under CF 5 which called directly the tag for information about ODBC. When I installed CF 7, may be 5 years ago, I added an extra level to get information about JD

Re: Is attributeCollection broken in CF 9 ?

2010-07-28 Thread Claude Schnéegans
>>You don't have robust exception handling enabled? Yes I have, I always have on my development machine. I had it disabled, and it makes no difference. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Co

Re: Is attributeCollection broken in CF 9 ?

2010-07-28 Thread Claude Schnéegans
>>You are probably just going to have to explicitly set the name of the incoming structure. Now's probably a good time to change that custom tag The problem is that many of the attributes are optional, so I would need CFIFs inside the call to the CFX, which is not possible as far as I know. Usi

Read only text datasource?

2010-08-04 Thread Claude Schnéegans
Hi, I want to read records from a tab delimited log file, so I have defined an ODBC datasource on the directory, and a DSN on the ODBC socket in the CF administrator (CF 9). All I want to do is read the records: SELECT * FROM [#file#.log] I get this error: [Macromedia][SequeLink JDBC Drive

Handling errors under CF 9

2010-08-04 Thread Claude Schnéegans
Hi, I have this code in Application.cfm Under CF 5 and untill CF 8, the application scope was not changed when running requestError.cfm even if it is in the virtual directory \commun But now in CF 9, the Application.cfm in the commun directory is executed first, and the application scope is r

Re: Read only text datasource?

2010-08-05 Thread Claude Schnéegans
OK, I found the problem. Since some update, for "security reason", the Microsoft text ODBC driver does not read files with extensions other that .txt, .tab, or .csv... First, I do not see why it could be dangerous to read files with .log extension, and last but not least, it would have been so s

Re: Handling errors under CF 9

2010-08-05 Thread Claude Schnéegans
>>But now in CF 9, the Application.cfm in the commun directory is executed first, and the application scope is reset. I solved the problem by putting the error precessing file in some special directory having an empty Application.cfm file. But IMO there is still some inconsistency in the proce

Re: Upgrade CF5 to CF8 and undefined session

2010-08-09 Thread Claude Schnéegans
Salut collègue ! ;-) >>The problem is that session management seems not to work. Do you some more precise diagnostic? Any error message? What makes you think session management does not work? One of the problems you will encounter with applications in French is that CF and CF-Studio used to w

ResolveURL with CFX_HTTP5

2010-08-19 Thread Claude Schnéegans
Hi, Any one here using CFX_HTTP5? I do not see any equivalent for the attribute ResolveURL in the CF CFHTTP tag. Am I missing something? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Antho

Re: ResolveURL with CFX_HTTP5

2010-08-19 Thread Claude Schnéegans
>>You mean this CF CFHTTP Tag? No, I mean the Custom Tab CFX_HTTP5 which is supposed to be a replacement for CFHTTP. But there is no RESOLVEURL attribute. By the way, there used to be a bug in previous versions of CF : the RESOLVEURL process was missing links in CSS declarations like images i

Re: Number of site using ColdFusion

2010-08-25 Thread Claude Schnéegans
>>If I Google index.cfm and home.cfm the numbers exceed 1 billion. Of course, you are getting all pages like index.cfm?whatever ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Micha

Activating CF 9 server

2010-08-25 Thread Claude Schnéegans
Hi, I recently upgraded my server to CF 9, my current edition is: ColdFusion Enterprise (Trial). I bought the standard official version and just received the disk today. Where should I enter the serial number on my trial version so it becomes an official version? I tried to enter it in the "New

Re: Activating CF 9 server

2010-08-25 Thread Claude Schnéegans
>>Click on the "I" .. you should need both the old and new serials. I have no old serial, this is a new installation. I did click on the I, entered the serial # I have on the back of the disk, in the "New licence" field, but is says "The Serial Number entered is not valid" ~~~

Re: Activating CF 9 server

2010-08-25 Thread Claude Schnéegans
>>who did you the cd from? Adobe? Sure, a plain legal paid version. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http:

Re: Activating CF 9 server

2010-08-25 Thread Claude Schnéegans
>>who did you the cd from? Adobe? Actually, I installed the trial version from Adobe's site. Then I bought the product, and choose to hae it on disk. To day I got the disk, now I'm trying to unlock the trial version by providing the serial number. At least this is the way I thought it should be

Re: optimizing CFIDE for cfform

2010-08-31 Thread Claude Schnéegans
>>If jQuery is too difficult for a dev May be "too difficult" is not the right term, I would say "needlessly complex". Personally I do all my Ajax stuff with only two functions, on for method GET, one for a POST. About 40 lines of code, including a function to display a dump in a new window in

Problem with Paypal since CF 9

2010-09-01 Thread Claude Schnéegans
Hi, I recently upgraded an old CF site from version 5 to version 9. Since then, my Instant Payment Notification from Paypal is broken. It CFHTTP the Paypal server, but the response is now INVALID instead of VERIFIED as it used to be. There must be something changed in the CFHTTP which makes th

Re: Problem with Paypal since CF 9

2010-09-01 Thread Claude Schnéegans
>>If you cfdump the cfhttp results in CF5 and CF9 and compare them then you will see the difference. Not easy to to. The template is called by the Paypal server for every transaction. The template should return all form fields IN SAME ORDER in another CFHTTP request to Paypal. If everything

Re: Problem with Paypal since CF 9

2010-09-01 Thread Claude Schnéegans
I'm pretty sure its it some sort of encoding problem. I've found this on the Paypal site: "PayPal's IPN server expects that your script will POST back all variables that were posted to it and more importantly, that they are encoded the same way as they were sent to your script. If your script

Re: Problem with Paypal since CF 9

2010-09-01 Thread Claude Schnéegans
>>There are two dates the come over encoded but aren't when you look at your string back that caused my issues initially Yeah, I've seen that. Fields ending with _date are not listed in form.fieldnames. Curiously enough, this bug was already in CF 5, but Paypal would accept the verification

Re: CFParam vs. IsDefined

2010-09-02 Thread Claude Schnéegans
>>Also using isDefined() is also bad as this search every single scope for your variable CFPARAM will also search for the variable exactly the same way in order to create it if it does not exist. What's the big differrence? >> and can potentially cause timeouts. Wow! Where do you hide your

Re: WHERE Left(str,5) = 'string' VS WHERE str LIKE 'string%'

2010-09-15 Thread Claude Schnéegans
>>The answer is "it depends", Frankly, according to your results, I would rather answer "the difference is marginal". ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinow

Looking for the right SMTP server

2010-09-28 Thread Claude Schnéegans
Hi, I run several sites specialized for associations. They send thousand of mails to their members. Presently I'm using Mail-enable, but I'm looking for a better tool to help me manage all these mails. What I'd like is to be able to assign an Id to each mail and be able to trace it through a

Re: Looking for the right SMTP server

2010-09-29 Thread Claude Schnéegans
>>Take a look at JangoSMTP and SMTP2Go Thanks, but these are external mail services. I'm more looking for a true SMTP server software I can install on my own server. ~| Order the Adobe Coldfusion Anthology now! http://www.amaz

Re: Looking for the right SMTP server

2010-09-29 Thread Claude Schnéegans
>>SendGrid is a third part smtp host. Thanks, but I'm not looking for a hosted service, but for a true server software. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Din

Drivers for Access databases under CF 9

2010-09-29 Thread Claude Schnéegans
Hi, There are two drivers for Access database in CF9 : - Microsoft Access - Microsoft Access with unicode If I choose the first one, the query below works and yield the same results as when run in Access itself. However, If I use the driver with Unicode, the LEFT JOIN returns no data. The tab

Re: Drivers for Access databases under CF 9

2010-09-29 Thread Claude Schnéegans
>>Both are JDBC, in that CF only knows JDBC. The first driver is part of SequeLink, which is a DataDirect product that acts as a JDBC-ODBC bridge. The second driver is a JDBC-to-Jet driver and doesn't rely on anything else - Jet is the "native" protocol for MS Access. I believe it's open-source,

Re: Drivers for Access databases under CF 9

2010-09-29 Thread Claude Schnéegans
>>thats because cf5 used ODBC datasources as it was written in C++ CF6+ is a java app and thus uses JDBC Of course, I know that. When I updated from CF5 to CF9, I was able to redefine all my datasources in CF9 with no problem. but now I have a new I want to add, the ODBC connection is created

Re: Drivers for Access databases under CF 9

2010-09-29 Thread Claude Schnéegans
>> You could look at the SequeLink logs, which are not enabled by default - but I'm sure there's some option to enable them. I'm trying to find where. I've checked for the occurrence of two datasource names in all files under \ColdFusion9, one for a datasource which works, the othe one for the

Re: Drivers for Access databases under CF 9

2010-09-29 Thread Claude Schnéegans
Ok, according to this page : http://kb2.adobe.com/cps/186/tn_18644.html ColdFusion MX ODBC Agent errors are typically logged to the Windows Event Log So I went into the Windows Event Log and I found this indeed : " The description for Event ID ( 0 ) in Source ( ColdFusion 9 ODBC Server ) cannot

Re: Drivers for Access databases under CF 9

2010-09-29 Thread Claude Schnéegans
>>I get the impression that he's trying to create new Access datasources from the CF Administrator without having existing ODBC datasources pointing to those Access databases. That should work fine. Exactly. First, CF 9 installation does not import automatically CF 5 databases. I had to redef

Re: Drivers for Access databases under CF 9

2010-09-29 Thread Claude Schnéegans
>>If you look in C:\ColdFusion9\lib\neo-datasource.xml you will find all the DSN's defined in here. Check all the connection properties of the working DSN's and compare them to the non working DSN's and see if there is anything different. I've already done this, and everything about the new DSN

Re: Drivers for Access databases under CF 9

2010-09-29 Thread Claude Schnéegans
>>how about the rest of things I suggested, there was more? Regarding the [DataSource_n] records, I have only 4 of them in here, about datasource I don't even have in my system. I think these are example datasources used for the documentation which I didn't install on my production server.

Re: Looking for the right SMTP server

2010-09-29 Thread Claude Schnéegans
>>Pretty easy to trace individual messages through their logs, and search utilities in the console. Ok, but are the log stored in a database in real time? I've written a small application to convert MailEnable text files into a database, but I have to reread the whole file every time I want to

Re: Looking for the right SMTP server

2010-09-29 Thread Claude Schnéegans
Thanks. I've seen a couple of them, some store accounts in a database indeed, but no one clearly states that the logs go in it as well. Having accounts in a database is fine if you need to have customers manage their own mail boxes from their application, but what I'm looking for more specifi

Re: Drivers for Access databases under CF 9

2010-09-29 Thread Claude Schnéegans
>>well then there is your problem, if the datasources don't exist Then this is certainly not crucial, as I have about 25 other databases, most of them using the same Access driver, none of them is registered in this file, and all of them work perfectly. ~~

Re: Drivers for Access databases under CF 9

2010-09-29 Thread Claude Schnéegans
>>Can you create a new data source using an existing Access file? Actually no. I already have 25 datasources, all with the same driver, all created with the same Access version, all work fine, but no new datasource is recognized. ~~

Re: Drivers for Access databases under CF 9

2010-09-29 Thread Claude Schnéegans
... I even tried this: - delete an old datasource which worked. - redefine it, no problem, still works. - made a copy of the same file in another directory, create a new datasource on it... doesn't work :-( ~| Order the Adobe

Re: Drivers for Access databases under CF 9

2010-09-30 Thread Claude Schnéegans
Furthermore, I've noticed that if I define a new datasource in CF9, I still have the same error, but the same datasource gets also defined in CF5 in the same operation, and it works fine under CF5! ~| Order the Adobe Coldfusi

Re: Drivers for Access databases under CF 9

2010-09-30 Thread Claude Schnéegans
>>Do you have CF9 and CF5 installed on the same box? Sure, otherwise I could not say that defining a datasource in CF 9 autimatically defines it in CF 5. Since CF 6, I've always used both version on my development desktop with no problem, they are completely independant products. I didn't up

Re: Drivers for Access databases under CF 9

2010-09-30 Thread Claude Schnéegans
CF5 uses ODBC data sources directly so will of course be able to see any that exist on the system. CF5 will be able to SEE it so you can create a DSN under CF5, but here, creating the DSN under CF9 also creates it in CF5. Kind of weird. But I created and deleted these DSN so often, that nothi

Re: Drivers for Access databases under CF 9

2010-09-30 Thread Claude Schnéegans
>>As you have multiple versions of CF installed you are going to have multiple versions of the ODBC service as well, Really? I can see the " ColdFusion 9 ODBC Server" and the "ColdFusion 9 ODBC Agent" in the services but to my knowledge, CF 5 does not use any ODBC service. >>each one will be

Re: Drivers for Access databases under CF 9

2010-09-30 Thread Claude Schnéegans
>>CF5 is not JAVA, it doesn't use JDBC, it uses ODBC. Of course, I know. >>If you create an ODBC DSN in the windows control panel, then it will also show up in the CF5 admin. You're right, I thought you still had to define it in CF 5, but apparently it is automatic. Anyway, this does not t

Re: Looking for the right SMTP server

2010-09-30 Thread Claude Schnéegans
>>Damn I miss IMS! Question is: does it store its logs in a database? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: ht

Re: Drivers for Access databases under CF 9

2010-09-30 Thread Claude Schnéegans
>>My guess is that you'd previously installed another version of CF (6, 7, 8) Actually no previous version. But I had to install CF 9 twice, in two different configurations. The first time the installer wont take my registration key. So I have bothe ColdFusion9 and Jrun4 directories. The last

Re: Drivers for Access databases under CF 9

2010-09-30 Thread Claude Schnéegans
>>u have CF 5/6/7/8/9 installed. On my development desktop yes, but not on my production server on which I'm having the problems. >>as your setup seems to change from 1 post to the next. No, nothing was changed either on my desktop, nor on my server. I installed CF9 on my server August 25,

Re: Drivers for Access databases under CF 9

2010-09-30 Thread Claude Schnéegans
>>> Is CF 9 installed under ColdFusion9 supposed to use also C:\JRun4 ? >>No. OK, so we have the begining of an answer here. I noticed that I'm having CF 9 ODBC agent and ODBC server running from C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\cfusion\db\slserver54\bin\ They should u

Re: Drivers for Access databases under CF 9

2010-09-30 Thread Claude Schnéegans
>>C:\jrun4 is a multi-server install. Yeah, I tried this one first (last July), but it wont accept my serial number, so I re-installed the other version last August >>I think I'd go with Dave's suggestion, uninstall, delete all files and folders and start from scratch. Yurk... ~~~

Re: Drivers for Access databases under CF 9 SOLVED!

2010-10-01 Thread Claude Schnéegans
>>My guess is that you'd previously installed another version of CF (6, 7, 8) and that there's a conflict between whatever that left on your system Your guess was right. Not 6, 7 or 8 versions, but I installed first the trial version with the J2EE configuration. For some mysterious reason, whe

Reading text files

2010-10-01 Thread Claude Schnéegans
Hi, One of the new things I find interesting in CF 9 (coming from CF 5) is the fileRead and the FileReadLine functions. I need to periodically (say once every hour) read a daily log file and get what was added to it since last time. Beside counting the number of lines and looping on that cou

Re: Reading text files

2010-10-01 Thread Claude Schnéegans
No, CF isn't that low-level. But you could do this in Java, then call your Java class from CF. I've found fileSeek () and FileSkipBytes (), that might do the trick. ~| Order the Adobe Coldfusion Anthology now! http://www.amaz

Re: Microsoft rumored to be buying Adobe

2010-10-07 Thread Claude Schnéegans
>>I cant see this as positive in any way for coldfusion. Microsoft bought FoxPro 8 years ago, and Foxpro is still alive. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Din

Re: Microsoft rumored to be buying Adobe

2010-10-07 Thread Claude Schnéegans
>>That's not living. That's barely existing. May be, but this is more because FoxPro is one generation older (dBase) than other products on the market now than directly because of Microsoft. ~| Order the Adobe Coldfusion Anth

Importing from CSV to a database

2010-10-20 Thread Claude Schnéegans
Hi, I have to create a new database from a CSV text file. I have an ODBC datasource defined for the CSV file and I can read the file with a query like: SELECT * FROM membersImport.csv The problem is that column names have blanks and special characters that makes them illegal variable names.

Re: Catching "Invalid CFML construct found" in OnError

2010-10-20 Thread Claude Schnéegans
>>I am trying to catch this error type but it is not passing through onError >>in the Application Class. It simply is evaluated and thrown as is. How do I >>catch it without a try/catch? I don't think you can. onError will only catch execution errors. Invalid CFML construct is a compilation

<    1   2   3   4   5   6   >