Java
http://cflib.org/udf/ZipFileNew
http://cflib.org/udf/ZipFileNew=]
On Wed, Dec 16, 2009 at 10:54 AM, coldfusion.develo...@att.net wrote:
I'm stuck with CFMX6.1 for our Intranet and need to zip up a csv file after
I created it from a query output. Anyone have any ideas how zip
http://www.newsight.de/2005/06/28/finished-work-on-zip-cfc/
Haven't used it, so can't vouch for it... but I do have a CFMX7 gig I'm
working on, and will be looking to implement this in the next few days
myself.
On Wed, Dec 16, 2009 at 9:54 AM, coldfusion.develo...@att.net wrote:
I'm stuck
Haven't used it, so can't vouch for it...
I have. Works fine on CF 7. At least I have not had any problems with it.
The doc header sez that it works on 6.x:
Support: ColdFusion MX 6.0, ColdFusion MX 6.1, ColdFusion MX 7
HTH
G!
On Wed, Dec 16, 2009 at 12:59 PM, Charlie Griefer
: Charlie Griefer [mailto:charlie.grie...@gmail.com]
Sent: Wednesday, December 16, 2009 1:00 PM
To: cf-talk
Subject: Re: CF MX 6.1 - zipping files
http://www.newsight.de/2005/06/28/finished-work-on-zip-cfc/
Haven't used it, so can't vouch for it... but I do have a CFMX7 gig I'm
working
Well, I can't now because I reinstalled CF 7. I would like to try to figure
out how to install them seperately. Just put a '7' in the CF template for the
install?
Thanks
~|
Adobe® ColdFusion® 8 software 8 is the most
Well, I can't now because I reinstalled CF 7. I would like to try to figure
out how to install them seperately. Just put a '7' in the CF template for the
install?
Thanks
On Tuesday 22 Jan 2008, Email Test wrote:
Setup\RemoveSequeLink.bat fails to remove them, probably because
the
On Tuesday 22 Jan 2008, Email Test wrote:
Setup\RemoveSequeLink.bat fails to remove them, probably because the
...bat file which was included in the CF 7 install, is looking for the
correct MX 7 services.
Did you try editing the names in the batch file ?
--
Tom Chiverton
Helping to
Matthew Smith wrote:
that offers CF MX or CF 8 with MSSQL server for around $16.95/month? We
don't need a huge amount or space or transfer.
cfdynamics.
~|
Download the latest ColdFusion 8 utilities including Report Builder,
Actually, you can still get CFMX with MSSQL for 26.95 at CrystalTech, and as
they offer a discount to not-for-profits, you may be back down close to the
16.95 you seek. Drop a line to their sales to see what the not-for-profit
discount would do for you.
HTH,
James
On 8/14/07, Matthew Smith
Excuse me, I meant CF8 with MSSQL.
On 8/14/07, James Edmunds [EMAIL PROTECTED] wrote:
Actually, you can still get CFMX with MSSQL for 26.95 at CrystalTech, and
as they offer a discount to not-for-profits, you may be back down close to
the 16.95 you seek. Drop a line to their sales to see what
On 2/9/07, dsmith @ psea. org dsmith @ psea. org [EMAIL PROTECTED] wrote:
Is it possible to create an access datasource on 6.1 w/o having the ODBC
service running? There appears to be an access native driver but when I try
to use it it tells me that the ODBC service isn't running.
Thanks,
I don't know if this is it but have you checked if Coldfusion MX 7 ODBC Server
is running
In windows:
Start Programmes Administrative Tools Services
~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 MX7 integration
Once upon a time, I seem to remember hearing that you could use OLEDB to
connect to access: cfquery dbtype=oledb ... /cfquery
However, I've never tried that :). If it works out, let me know.
~|
Upgrade to Adobe ColdFusion MX7
Once upon a time, I seem to remember hearing that you could
use OLEDB to connect to access: cfquery dbtype=oledb ...
/cfquery
However, I've never tried that :). If it works out, let me know.
OLEDB is not supported in CFMX or newer versions.
Dave Watts, CTO, Fig Leaf Software
Is it possible to create an access datasource on 6.1 w/o
having the ODBC service running? There appears to be an
access native driver but when I try to use it it tells me
that the ODBC service isn't running.
Are you using the Access w/Unicode driver? That doesn't rely on the ODBC
If you want to try a jdbc driver, we use the jtopen driver. We have
used it for several years. Download the jtopen.zip file, put the
jt400.jar file with the rest of your drivers - jrun/servers/lib I think.
You can dload it here https://sourceforge.net/projects/jt400
-Original Message-
Unchecking the 'Maintain Database Connnections' check box seems to have fixed
the problem. Our AS/400 was unavailable for a significant time this w/e for an
offline backup. In the past this would have definitely killed the datasource.
But Monday morning everything was OK.
We recently moved
-Original Message-
From: Smith, Daron [PA] [mailto:[EMAIL PROTECTED]
Sent: Friday, March 03, 2006 9:46 AM
To: CF-Talk
Subject: CF MX 7 and DB2 connection timeout
We recently moved our web site to a CF MX7 box. Ever since we
occasionally get the following error Error Executing
-Original Message-
I'm a little confused why'd you'd be using the ODBC connection for this -
isn't there a Native (type 4) driver available from IBM? The same driver
available for WebSphere should work just fine with CF and you'll get a lot
more support from IBM.
There is a generic
We recently moved our web site to a CF MX7 box. Ever since we
occasionally get the following error Error Executing Database
Query.[Macromedia][SequeLink JDBC Driver][ODBC Socket][IBM][iSeries
Access ODBC Driver]Communication link failure. comm rc=10054 - CWBCO1047
- The iSeries server application
If one exists, you should use a JDBC driver for the DB2 database. We
have a JDBC driver for our AS400/DB2 and it has worked w/o any problems.
Also, who is to say that CF is at fault? I have seen the AS400/DB2
connection go down for many reasons, and they were never the fault of
CF. Chances are
I still have a problem with caching. I don't have any caching turned
on in CF. I'm not behind a proxy server so I'm not seeing cached error
pages. I've made sure my browser isn't caching the error pages. Now I
can't think of any else to try.
Is there a no cache tag in CF that would prevent it
On 12/20/05, Phill B [EMAIL PROTECTED] wrote:
I'm writing an app that uses CFCs on a Win2K3 and CF MX 6.1. I have
never noticed this before but today it is caching all the files I am
working on. I'll upload the page, run it, make a change, upload it,
page runs using the previous code instead
On 12/20/05, Phill B [EMAIL PROTECTED] wrote:
Check your CFMX Administrator and make sure the Use Trusted Cache
option is not selected. When it's selected, the CF engine will not
check the file timestamps for an updated file.
Regards,
Dave.
If you apply any updaters make sure you go back into
I did have to deselect it but I didn't notice anything. I restarted
the server so I'll see if that makes things better.
Thanks
On 12/20/05, Dave Carabetta [EMAIL PROTECTED] wrote:
On 12/20/05, Phill B [EMAIL PROTECTED] wrote:
I'm writing an app that uses CFCs on a Win2K3 and CF MX 6.1. I have
@[EMAIL PROTECTED]
Still have the problem.
I have to delete each page, call it, then upload it before CF sees a
new file. I made sure my CF admin cache options were turned off. Is
there a tag or some thing I can put in my code to stop caching?
On 12/20/05, Phill B [EMAIL PROTECTED] wrote:
I
You only had to go back one day in the archives.
http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18289
--Ferg
Jim Curran wrote:
Hi all,
Is there any way to get CF to process .php files? I have a site we acquired
that has a flash form submitting to a PHP file. Also, there
I saw that, but didn't realize it addressed this issue... Thought it was DBM
specific.
THNX.
- j
-Original Message-
From: Ken Ferguson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 23, 2005 3:42 PM
To: CF-Talk
Subject: Re: CF MX 7 processing .PHP extension - IIS 6
You only had
If you mean can you write CFML code, save the file as .php, and have CF
execute it, then yes you can. If you mean can the CF server read and process
PHP code written in files with a .php extension, then the answer is of
course not.
On 11/23/05, Jim Curran [EMAIL PROTECTED] wrote:
Hi all,
Is
: Re: CF MX 7 processing .PHP extension - IIS 6
If you mean can you write CFML code, save the file as .php, and have CF
execute it, then yes you can. If you mean can the CF server read and process
PHP code written in files with a .php extension, then the answer is of
course not.
On 11/23/05, Jim
PROTECTED]
Sent: 23 November 2005 22:51
To: CF-Talk
Subject: RE: CF MX 7 processing .PHP extension - IIS 6
If it's just one file, I recommend rewriting it in CF... Otherwise your only
choice is to get another server and put PHP on it... (or shared space
somewhere)..
-Original Message-
From
Anybodyconfirm? deny? don't know? don't care? ;-)
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 -
Its been that way since cf 6.1 as far as I know. bout the most
information I have...
On 9/30/05, Bryan Stevenson [EMAIL PROTECTED] wrote:
Anybodyconfirm? deny? don't know? don't care? ;-)
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
Yes I noticed this as well. The numbers never add up and the sum of the
parts is almost always *vastly* higher than the total given at the bottom.
Many times the sum adds up to a number so completely wrong it's laughable.
I'm now looking at a page than executed in about 1.5 seconds and the sum of
Its been that way since cf 6.1 as far as I know. bout the most
information I have...
Wow...reallyguess I haven't been paying close enough attention ;-)
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
Yes I noticed this as well. The numbers never add up and the sum of the
parts is almost always *vastly* higher than the total given at the bottom.
Many times the sum adds up to a number so completely wrong it's laughable.
I'm now looking at a page than executed in about 1.5 seconds and the
, September 30, 2005 4:41 PM
To: CF-Talk
Subject: Re: CF MX 7 and execution time
Yes I noticed this as well. The numbers never add up and
the sum of the
parts is almost always *vastly* higher than the total given
at the bottom.
Many times the sum adds up to a number so completely wrong
it's
Yep Steve.I think the total is probably accurate and the individual
times are derived from a hamster running laps on a wheel ;-)
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:
On 7/23/05, Graham Pearson [EMAIL PROTECTED] wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I am teaching a Coldfusion Class next week and have been trying to
create a CD that will install Coldfusion in Quiet mode with a default
administrator password and every time I perform this,
Graham,
Frankly, I can't recall if that silent install procedure will add the
ODBC services or not, but I can tell you that if the reason you want to
install them is so that you can connect to MS Access, then you can
actually just use the Microsoft Access with Unicode driver from the
drop
What do you mean the page is missing?
-Original Message-
From: Dave Nixon [mailto:[EMAIL PROTECTED]
Sent: Friday, July 08, 2005 7:59 PM
To: CF-Talk
Subject: cf mx exception error messages
Can anyone explain below why you get a SQL query error for a page that is
possibly missing???
I am
What do you mean the page is missing?
-Original Message-
From: Dave Nixon [mailto:[EMAIL PROTECTED]
Sent: Friday, July 08, 2005 7:59 PM
To: CF-Talk
Subject: cf mx exception error messages
Can anyone explain below why you get a SQL query error for a page that is
possibly missing???
I am
I know that those pages are not there yet
Thanks Dave
What do you mean the page is missing?
-Original Message-
From: Dave Nixon [mailto:[EMAIL PROTECTED]
Sent: Friday, July 08, 2005 7:59 PM
To: CF-Talk
Subject: cf mx exception error messages
Can anyone explain below why you get a
CF sometimes gets a little weird with templates that once existed, but
no longer exist. This is by design if you have the template cache
enabled, but it can happen even with it off. Clear your cfclasses
directory (inside WEB-INF) and restart and it'll probably go away.
cheers,
barneyb
On
Has anyone upgraded to the JVM 1.4.2_08? If so, would you
recommend it?
I am running the default JVM included w/ MX 6.1 and are
getting JVM errors about 2-3 times a week.
The latest JVM I've been able to use without any problems whatsoever is
1.4.2_05. I've had problems with newer
ditto what Dave said. Of course we still get issues with CFLDAP under load,
but JVM _06 and _07 killed CFLDAP completely.
DK
On 5/10/05, Dave Watts [EMAIL PROTECTED] wrote:
Has anyone upgraded to the JVM 1.4.2_08? If so, would you
recommend it?
I am running the default JVM included
not conform to the log settings max...
TIA!
- j
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 10, 2005 1:55 PM
To: CF-Talk
Subject: RE: CF MX 6.1 and JVM 1.4.2_08
Has anyone upgraded to the JVM 1.4.2_08? If so, would you recommend
it?
I am
-Original Message-
From: David Brown [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 02, 2005 1:06 PM
To: CF-Talk
Subject: Re: CF MX 7 stopping IIS 5.0 service
RANT ON
I have never called in to Macromedia for support and I have used their
products since CF 3.x. We currently own 5 copies
Do you need to change the virtual mapping in IIS to point to the CF7
webroot's CFIDE directory?
cheers,
barneyb
On Fri, 4 Mar 2005 10:20:54 -0800, Bryan Stevenson
[EMAIL PROTECTED] wrote:
Hey All,
Well my CF MX 7 install on my Win XP SP2 laptop with CF MX 6.1 already on it
went just fine
Do you need to change the virtual mapping in IIS to point to the CF7
webroot's CFIDE directory?
Nope...my webroot is on another drive...and the mapping is correctI can
access other files in the cfide directoryjust no index.cfm under
administrator
Bryan Stevenson B.Comm.
VP Director
That's because 6.1 had no knowledge of 7 and uninstalled the admin.
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Friday, March 04, 2005 11:21 AM
To: CF-Talk
Subject: CF MX 7 missing admin index.cfm
Hey All,
Well my CF MX 7 install on my Win XP SP2 laptop
You'll need to reinstall CFMX7.
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Friday, March 04, 2005 11:35 AM
To: CF-Talk
Subject: Re: CF MX 7 missing admin index.cfm
Do you need to change the virtual mapping in IIS to point to the CF7
webroot's CFIDE
That's because 6.1 had no knowledge of 7 and uninstalled the admin.
Huh? As I understand it CF 7 can co-exist with a 6.1 install. From that I
assumed they each used their own CF admin? but perhaps not?
I guess because of my setup (both pointed to the same webroot on another
drive) I screwed
You can also just copy the CFMX 7 CFIDE from a working install on another
machine if you have one.
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Friday, March 04, 2005 1:53 PM
To: CF-Talk
Subject: Re: CF MX 7 missing admin index.cfm
That's because 6.1 had
Thanks Calvinbut this is the 1st install around herenumber 2 will be
tonight whilst watching the tube ;-)
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]
Having both versions side by side is normal and by design. You need to
uninstall 6.1 if you no longer need it. The catch is you can only have one
on port 80 which could explain why IIS is getting killed.
-Original Message-
From: David Olimpio [mailto:[EMAIL PROTECTED]
Sent:
@houseoffusion.com
Sent: Wednesday, March 02, 2005 12:11 PM
Subject: RE: CF MX 7 stopping IIS 5.0 service
Having both versions side by side is normal and by design. You need to
uninstall 6.1 if you no longer need it. The catch is you can only have
one
on port 80 which could explain why IIS
the
second one truly is.
-Original Message-
From: David Brown [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 02, 2005 10:24 AM
To: CF-Talk
Subject: Re: CF MX 7 stopping IIS 5.0 service
Ok, how do you uninstall cfmx 6.1 without removing your cfide folders in
your root web?
The last time
MX 6.1 without removing the data sources?
- Original Message -
From: Connie DeCinko [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Wednesday, March 02, 2005 12:38 PM
Subject: RE: CF MX 7 stopping IIS 5.0 service
Hmm, I would assume it would be smart enough to leave those
But I use variables within the clientdb that tells me if the
user is logged in and what permissions they have. Plus keep
track of how long they've been idle, so we can log them off,
but not lose any of the data they were working on.
Unfortunately, there aren't any especially good
to know
about the data in the other.
:-\
-Original Message-
From: Steven Erat [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 24, 2005 11:41 PM
To: CF-Talk
Subject: Re: CF MX and CF 5 accessing the same client database storage
for one big application.
On Thu, 24 Feb 2005 22:17:21 -0500
Craig Benner wrote:
Here is a little back ground before I get into my problem. I have 3
production web servers. 2 of them are running CF 5 which is load
balanced. They are using client variables to keep state and login
information. This is working perfectly. Next I am adding a standalone
: Re: CF MX and CF 5 accessing the same client database storage
for one big application.
Craig Benner wrote:
Here is a little back ground before I get into my problem. I have 3
production web servers. 2 of them are running CF 5 which is load
balanced. They are using client variables to keep
On Thu, 24 Feb 2005 22:17:21 -0500, Craig Benner
[EMAIL PROTECTED] wrote:
So to use 2 cfclientdb, I will have to write my code to keep the data up
to date as the jump back and forth between the servers / cfclientdbs.
Sounds like a pain.
Just use two databases on the same database server,
Not knowing what your query is doing and also not knowing what the original
query result set is and its properties makes this a difficult question to
answer. Both of the links you provided seem to generate on html output so I
can't see any debug info but what I will say is that they both took
The second link for me did take a noticeably longer time to load than
the first. The first kind of came up almost immediately.
On Tue, 8 Feb 2005 03:12:12 -, Paul Vernon
[EMAIL PROTECTED] wrote:
Not knowing what your query is doing and also not knowing what the original
query result set
The second link for me did take a noticeably longer time to load than the
first. The first kind of came up almost immediately.
Strange, I tested 2 or 3 times and it was about the same... I test now and
there is a marked difference My comments however still stand. Without
knowing how big the
I agree that it is hard to answer the question, just wanted to point
out that I was noticing the differences in speed.
On Tue, 8 Feb 2005 03:31:09 -, Paul Vernon
[EMAIL PROTECTED] wrote:
The second link for me did take a noticeably longer time to load than the
first. The first kind of
Try the 2 links again.
I had forgotten that cfttrace doesn't work unless you have debug priveledges.
Ive populated the execution times for the qoqs during runtime and used
cfflush to spit them out in realtime
Here is the app running on 6.1 (same server)
Those times look like overheads to me... Out of interest, how big is your
original dataset? Do these times differ significantly if the size of the
result set changes? How wide is the result set and how many rows does it
have in general?
The next thing to ask is Is there a good solid reason
LOL, i found out what it was.
You can specify 'columntypelist' in the queryNew function. Its
optional, but not specifying any data type put a significant increase
in load time.
Insteresting.good to know.
On Mon, 7 Feb 2005 21:21:33 -0700, Jay McEntire [EMAIL PROTECTED] wrote:
Try the 2
That sounds like a new best practice - always specify a columntypelist for
CF7 queryNew() calls.
-Original Message-
From: Jay McEntire [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 8 February 2005 12:30
To: CF-Talk
Subject: Re: CF MX Performance Hit -- Amy I the first to notice? QoQ
LOL, i
:[EMAIL PROTECTED]
Sent: Tuesday, 8 February 2005 12:30
To: CF-Talk
Subject: Re: CF MX Performance Hit -- Amy I the first to notice? QoQ
LOL, i found out what it was.
You can specify 'columntypelist' in the queryNew function. Its optional,
but not specifying any data type put a significant increase
We are successfully using Verity on RH 2.1AS. (More info below).
Doug James
IT Developer / Webmaster
MUSC - Hollings Cancer Center
http://hcc.musc.edu
paris lundis wrote:
I was wondering if anyone out there is using CF MX6.1 release on any Red Hat
version while depending on Verity to provide
I am running CF MX developer edition on my laptop. The
problem I have is that when I try to start CF without a
network connection, CF will not start.
Not a problem at home, but when I am on a plane, or a hotel,
hard to do some work... ;-)
Any way I can get CF MX to run without a
I am running CF MX developer edition on my laptop. The problem I have is
that when I try to start CF without a network connection, CF will not
start.
Not a problem at home, but when I am on a plane, or a hotel, hard to do
some work... ;-)
Any way I can get CF MX to run without a network
Windows 2003 server under IIS 6.0. Running it as a service.
At 12:03 PM 12/1/2004, you wrote:
I am running CF MX developer edition on my laptop. The problem I have is
that when I try to start CF without a network connection, CF will not
start.
Not a problem at home, but when I am on a
I am going to try the loop back adapter. That sounds like it may work.
Thanks
Jacob
At 12:10 PM 12/1/2004, you wrote:
I am running CF MX developer edition on my laptop. The
problem I have is that when I try to start CF without a
network connection, CF will not start.
Not a problem at
I run CFMX that way w/o a network connection on my laptop. Not sure
that helps, but I wanted to state that it can be done.
Perhaps your config has CFMX looking for something on a remote computer?
-Original Message-
From: Jacob [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 01,
I have to say I'm running XP, not server.
-Original Message-
From: Jacob [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 01, 2004 2:33 PM
To: CF-Talk
Subject: Re: CF MX developer edition with no network connection.
Windows 2003 server under IIS 6.0. Running it as a service.
At 12
Yeah, that one threw me too...2k server on a laptop? That's pretty awesome.
I have to say I'm running XP, not server.
-Original Message-
From: Jacob [mailto:[EMAIL PROTECTED]
Windows 2003 server under IIS 6.0. Running it as a service.
Yeah, that one threw me too...2k server on a laptop? That's
pretty awesome.
Lots of developers run server OSs on their laptops. Up until last month, I
ran Windows Server 2003 on my laptop. Before that, it was Windows 2000
Server. If you have an MSDN subscription, it's a good way to familiarize
I am wondering if there could be some difference between the
way CF MX and CF MX 6.1 function that could be preventing the
creating of PDF documents? It will take some doing to get the
actual CF server install disk (which appears to be my only
way to upgrade to CF MX 6.1) and I would
It would simplify troubleshooting if you run the 6.1 updater. It's
free right? Then you could compare the 2 instances of CF a little
better.
Greg
- Original Message -
From: Dave Watts [EMAIL PROTECTED]
Date: Thu, 9 Sep 2004 16:41:09 -0400
Subject: RE: CF MX Problem
To: CF-Talk [EMAIL
You have to recompile the connector to eliminate that error.The connector
source is included in the ColdFusion installation.
>From a (slightly old) CFMX Connector FAQ:
Where is the Apache connector source located and how can I compile my own
Apache EAPI connector?
For ColdFusion MX, the code
Hello Steve,
Thank you for your help, however, I received a syntax error in the httpd.conf file when restarting Apache with the recompiled connector: (Cannot load ...mod_jrun.so into server... Undefined symbol: removePathParms)
Any ideas where I went wrong, the new recompiled mod_jrun.so was
Try using createODBCDateTime() to specify a dateobject, instead of to_date()
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]
On Tue, 20 Jul 2004 09:51:37 +0200, Steff [EMAIL PROTECTED] wrote:
Hello
I have a request like
insert into toolbox
(idtoolbox,label,descr,language,idlinktype,idsource,creatingdate,updatingdat
e,publish,delstatus,orderby) values (2,'services et
catgories','','FR',0,0,to_date('2004-07-19
I try and I obtain ORA-00932: inconsistent datatypes
Can you help me?
thanks
steff
-Message d'origine-
De : Micha Schopman [mailto:[EMAIL PROTECTED]
Envoy : Tuesday, July 20, 2004 10:06 AM
: CF-Talk
Objet : RE: cf mx and oracle 8i
Try using createODBCDateTime() to specify a dateobject
obtain ORA-00932: inconsistent datatypes
Can you help me?
thanks
steff
-Message d'origine-
De : Micha Schopman [mailto:[EMAIL PROTECTED]
Envoy : Tuesday, July 20, 2004 10:06 AM
: CF-Talk
Objet : RE: cf mx and oracle 8i
Try using createODBCDateTime() to specify a dateobject, instead
We need more info from you, we can only guess at the moment
-Is the datetime value you are inserting between the boundaries of the datetime type you have set with Oracle? (small datetime, large datetime, etc)
- On which column does the error occur (take away cols, add cols, to your command)
-
d'origine-
De : Micha Schopman [mailto:[EMAIL PROTECTED]
Envoy : Tuesday, July 20, 2004 10:24 AM
: CF-Talk
Objet : RE: cf mx and oracle 8i
We need more info from you, we can only guess at the moment
-Is the datetime value you are inserting between the boundaries of
the datetime type you have set
On Tue, 20 Jul 2004 10:32:35 +0200, Steff [EMAIL PROTECTED] wrote:
I think where is the problem, I get date values with a query. The table
valueis like 19-JUL-04. Coldfusion gives me a date like '2004-07-19
00:00:00.0' to_date can't convert. So I should certainly before insert
query, modify
Well you can create a new date object using CreateDateTime, CreateODBCDateTime, after stripping out the wanted values with Left, Right and Mid.
So for DD-MM- you could do
cfset datevar = 20-07-2004
cfset tmp = createODBCDate(createDate(ListGetAt(datevar,3,-), ListGetAt(datevar,2,-),
Steff wrote:
insert into toolbox
(idtoolbox,label,descr,language,idlinktype,idsource,creatingdate,updatingdat
e,publish,delstatus,orderby) values (2,'services et
cat¿½gories','','FR',0,0,to_date('2004-07-19 00:00:00.0',
'dd/mm/'),to_date('2004-07-19 00:00:00.0', 'dd/mm/'),1,0,)
Thanks, it works well.
cordialy
Steff
-Message d'origine-
De : Simon Whittaker [mailto:[EMAIL PROTECTED]
Envoy : Tuesday, July 20, 2004 10:37 AM
: CF-Talk
Objet : Re: cf mx and oracle 8i
On Tue, 20 Jul 2004 10:32:35 +0200, Steff [EMAIL PROTECTED] wrote:
I think where is the problem, I
We are running MX 6.1.MX seems to run fine, but about every
8 - 12 hours it crashes.Our site will come back with a
coldfusion datasource error after a while.The datasource
can connect to the database no problem even while the error
is occuring.The only way to fix it is to restart the mx
We have a prod server setup as follows:
-Linux RedHat 9.1
-Apache
-CF MX 6.1 Standard
Intermittently we are having the contents of various cookies
spit out to the screen (and that screen does not display as
intended).The cookies hold queries (some empty and some
with 1 record per
On Wednesday 07 Apr 2004 16:39 pm, Bryan Stevenson wrote:
I'm still pretty new to a Linux/Apache setup and am wondering if mabye
header info is the culprit??
Are you using cfheader or something ?
(Traffic-Server/5.2.4 [cMs f ])
What's that ?
--
Tom Chiverton
Advanced ColdFusion Programmer
Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder Director
www.cfug-vancouverisland.com
- Original Message -
From: Thomas Chiverton
To: CF-Talk
Sent: Wednesday, April 07, 2004 8:44 AM
Subject: Re: CF MX/Linux
1 - 100 of 400 matches
Mail list logo
