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 so

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

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:

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 solution

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

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

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 Win

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

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

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

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

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 CFMAIL tag and the closing /CFMAIL, or inside an HTML tag, but never embedded inside another CF tag. ~| Want to reach the

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
cfhttp url=http://xmlfeed.laterooms.com/index.aspx?aid=1000rtype=4kword=cardiff; method=get/cfhttp 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

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 CF

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:

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=houseoffusion

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:

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

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

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 table1.many columns, table2.justOneColumn FROM table1 LEFT JOIN table2 ON

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!

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!

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!

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!

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

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!

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

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: CFX_MyCFX attributeCollection=#attributes# 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

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

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!

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: CFX_MyCFX attributeCollection=#attributes# This line is inside a standard CF_custom tag, then

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

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!

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.

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: CFQUERY DATASOURCE=logSMTP NAME=getLogs SELECT * FROM [#file#.log] /CFQUERY I

Handling errors under CF 9

2010-08-04 Thread Claude Schnéegans
Hi, I have this code in Application.cfm CFERROR TYPE = Exception template = /commun/requestError.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

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

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

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

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!

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 in

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!

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:

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 case

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

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!

Looking for the right SMTP server

2010-09-29 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

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!

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!

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

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

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

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

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

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

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 tell

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:

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, and

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 use

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, when

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

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!

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!

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

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: CFQUERY NAME=getMembers DATASOURCE=Import SELECT * FROM membersImport.csv /CFQUERY The problem is that column names have blanks and special

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   >