Just configue the Oracle JDBC using the "Other" Option. Yes, i think
CFMX Standard might Not come with Data Direct Oracle JDBC Drivers
but you can download the ORACLE Driver and just Configure it.
Joe Eugene
-Original Message-
From: Arden Weiss [mailto:[EMAIL PROTECTED]
Sent: Sunday,
> I'm doing some research on ColdFusion add on tools such as
> high performance in chart graphic and report tools for my
> project. Any information would be greatly appreciated.
Without more clarification, it is hard to tell what exactly you are looking
for. I have used Corda's POPCHART alongs
well that is pretty generic.
do you have any requirements or any more information on what you are
looking for? Are you looking for info on coldfusions built-in charting
or on alternatives to it? If looking for the former, check out
livedocs.macromedia.com...if the latter, I don't have any firs
Hi
I'm doing some research on ColdFusion add on tools such as high performance in chart graphic and report tools for my project. Any information would be greatly appreciated.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
> If I recall what I was told correctly, you had to be running
> the Enterprise version of CFMX to support Oracle with direct
> drivers -- hence the reason going with the ORA92 ODBC drivers
> for version 9.2 of Oracle -- I am running CFMX
> Standard/Professional or what it is now called and it
If I recall what I was told correctly, you had to be running the Enterprise version of CFMX to support Oracle with direct drivers -- hence the reason going with the ORA92 ODBC drivers for version 9.2 of Oracle -- I am running CFMX Standard/Professional or what it is now called and it works great wi
> Would you tell me how to set up the JDBC driver?
There's very little to it. If you're using CFMX Enterprise, just select
"Oracle" from the database list within CF Administrator, then fill in the
blanks appropriately. You don't need to install the Oracle client beforehand
to use this.
If you don
I have a project where a site administrator would fill in a web based form
and I'd process it using CF - posting content to a database (either SQL or
Access) and send that out by CFMail. The issue is this - the admin would
enter their content using a Russian font (windows encoded True Type font
> Unfortuately doesn't really help John with a cross-platform
> desktop application. Yeah I know it should run everywhere,
> but nothing is ever quite that simple and in this instance
> cf/php/etc are all a little on the heavy side. Mini flash app
> should be more than sufficient. (he says sti
> > ahhh ... if only we had CFAnywhere. :)
> >
> ~cough~ bluedragon
> Thats what CFAnywhere became.
CFAnywhere was a product of Live Software, the makers of Jrun, who were
purchased by Allaire.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-54
> I have a CF site that I developped in DWMX. As it is a
> freebie, I made use of a lot of the automatic code
> generation features of DWMX to save time.
I would recommend that you avoid the DWMX server behaviors for login/logout
functionality. In general, most of the server behaviors work well
Which version of Oracle are you running -- what I did for Oracle 9.2 is download the ORA92 ODBC driver from Oracle (the one with CFMX is for Oracle 8 I believe) and installed it.
Next I went to the Control Panel/Administrative Tools/Data Sources (ODBC).
In this screen click on the System DSN tab
David Brown wrote:
> We are looking to upgrade to CF MX (6.1) from CF 5.0 professional.
> We are also considering using FarCry CMS. Does anyone know if Farcry
> will work with CF MX 6.1 standard or do we need enterprise version?
The team behind FarCry (http://farcry.daemon.com.au/) have worked ve
Would you tell me how to set up the JDBC driver?
Jim Watkins
- Original Message -
From: Joe Eugene
To: CF-Talk
Sent: Sunday, April 04, 2004 5:13 PM
Subject: RE: Help! can't get Oracle connection
Why NOT just use the JDBC Driver that comes with Oracle Or
the one that come
> I have installed CF 6.1 professional on Win 2003 and
> installed the Oracle 9i client. Created the TNS names
> file and datasource. Used the MS ODBC Data Source
> Administrator on Win2003 and created the Oracle ODBC
> Driver Configuration and tested connection good. My
> problem:
>
> The Or
> Sequelink (the access service for Jrun I think) locks up
> quickly trying to service hundreds of requests at once to
> the same access file.
As a short-term fix, have you considered a more aggressive caching strategy?
That might be pretty easy to implement.
> Each site has a pretty well thoug
I've emailed it to you.
Just in case you don't get it (or anybody else wants it as well) I've also
posted it here:
ftp://ftp.depressedpress.com/UserAgents.zip
I haven't gone through the new entries in a long while. there were
three-thousand more rows (there's around 6.5 thousand now). I've just
Why NOT just use the JDBC Driver that comes with Oracle Or
the one that comes with CFMX. The JDBC driver is much more
stable and faster... from tests i did a while ago.
HTH
Joe Eugene
-Original Message-
From: Jim Watkins [mailto:[EMAIL PROTECTED]
Sent: Sunday, April 04, 2004 12:58 PM
Jim,
Thanks - that might be a good place to start. Can you send it to my email? thanks!
-Mark
-Original Message-
From: Jim Davis [mailto:[EMAIL PROTECTED]
Sent: Sunday, April 04, 2004 1:27 PM
To: CF-Talk
Subject: RE: user agent checking and spidering...
I'm not sure if it's
I'm not sure if it's the best way to do things but I may be able to help
with the user agents. Basically what I've done is capture all the user
agents to hit my sites over the past few years. I go through periodically
and (using a bit column in the table) mark whether the agents are bots or
not.
Cf talkers,
I have a client with many many similar sites on a single server using CFMX. Each of the sites is part of a "network" of
sites that all link together - about 150 to 200 sites in all. Each home page has links to other sites in the network.
Periodically, it appears that google or a simi
JT wrote:
> This did it.
>
>
>
>
>
>
> select * from Skills.completedtest
> where week(date) = #week#-1
> order by date,time
>
>
> But I am confused . why doesnt set this week to
> this weeks number?
Because week numbering is locale dependent.
Jochem
--
I don't get it
immigrants don't
I have installed CF 6.1 professional on Win 2003 and installed the Oracle 9i
client. Created the TNS names file and datasource. Used the MS ODBC Data
Source Administrator on Win2003 and created the Oracle ODBC Driver
Configuration and tested connection good. My problem:
The Oracle datasource d
This did it.
select * from Skills.completedtest
where week(date) = #week#-1
order by date,time
But I am confused . why doesnt set this week to
this weeks number?
I had to use where week(date) = #week# -1
to get correct records
-Original Message-
From: Dick Applebaum [mailto:[EM
Jake,
Alright, didn't know that you were on Access. it's been a while since I've
used Access but I'm pretty sure that you want to parse out each part of your
date, concatenate it together and return it as a string using CStr(). The
whole SQL query would look like this.
SELECT theTitle CStr(Mont
Oops, forgot the best part---
you can use
WHERE WEEK(BuyDate)
But be careful ---
WEEK("1998-01-01") AS WK, gives 0
WEEK("2000-12-31") AS WK1, gives 53
If you have an interactive db client, you might want to experiment.
HTH
Dick
On Apr 4, 2004, at 9:00 AM, Dick Applebaum wrote
I just happen to be playing with some MySQL dbs with an interactive db
client ---
I tried the syntax
>
> EXTRACT(WEEK FROM testdate)
and get the same error, while:
EXTRACT(DAY FROM testdate)
works fine
Checking the MySQL docs at:
http://webdocs.math.univ-rennes1.fr/MySQL/mysql-3.23.52/
m
JT said:
>
>
> SELECT testdate
> FROM completedtest
> WHERE EXTRACT(WEEK FROM testdate) = EXTRACT(WEEK FROM
> CURRENT_DATE)
> AND
> EXTRACT(YEAR FROM testdate) = EXTRACT(YEAR FROM
> CURRENT_DATE)
> GROUP BY EXTRACT(DAY FROM testdate)
>
>
> The ERROR is :
> Error E
Okay I did it .. still does not work
new code is
SELECT testdate
FROM completedtest
WHERE EXTRACT(WEEK FROM testdate) = EXTRACT(WEEK FROM CURRENT_DATE)
AND
EXTRACT(YEAR FROM testdate) = EXTRACT(YEAR FROM CURRENT_DATE)
GROUP BY EXTRACT(DAY FROM testdate)
The ERROR
JT said:
> I get this error
>
> Syntax error or access violation: You have an error in your SQL
> syntax near 'WEEK FROM datefld) = EXTRACT(WEEK FROM CURRENT_DATE)
> AND EXT' at line 3
>
> SELECT date as datefld
Date is a reserved word. Change it while you still can.
> FROM completedtest
Jake:
What's the query look like now?
> -Original Message-
> From: Jake . [mailto:[EMAIL PROTECTED]
> Sent: Sunday, April 04, 2004 5:09 AM
> To: CF-Talk
> Subject: Re: Grouping help
>
>
> Not sure if that would help. I'll have to check it out, since
> I'm using Access. Thanks!
>
> >I
I get this error
Syntax error or access violation: You have an error in your SQL syntax near
'WEEK FROM datefld) = EXTRACT(WEEK FROM CURRENT_DATE) AND EXT' at line 3
this is the code
SELECT date as datefld
FROM completedtest
WHERE EXTRACT(WEEK FROM datefld) = EXTRACT(WEEK FROM CURR
JT said:
> I have a MySQL database table that has a date column , how can I
> query for all records in this week and group on day of week.
Define "this week" :-)
This week of this year:
SELECT datefld
FROM table
WHERE EXTRACT(WEEK FROM datefld) = EXTRACT(WEEK FROM CURRENT_DATE)
>>Any ideas how I might do this?
Yes, (if I understand well). I've done something similar, and even more complex.
The trick is to generate from _javascript_ the code in _javascript_ to create the variables and their content, then store the code in a hidden field and send it to CF.
The next time it
I have a MySQL database table that has a date column , how can I query for
all records in this week and group on day of week.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Not sure if that would help. I'll have to check it out, since I'm using Access. Thanks!
>If you are using dates to group by, make sure to get rid of any extraneous
>information from the datefield. If you are using SQL Server, a datetime
>field will return the date, hours, minutes, seconds, and mi
I've an article on my site here that might help:
http://www.depressedpress.com/DepressedPress/Content/ColdFusion/Essays/GIFAs
Pipe/Index.cfm
Basically it describes a simple technique (and offers sample code) to allow
you to write information back to the server without needed a page refresh.
This
37 matches
Mail list logo
