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
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
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]
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
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:
SELECTdatefld
FROMtable
WHERE EXTRACT(WEEK FROM datefld) = EXTRACT(WEEK FROM CURRENT_DATE)
AND
EXTRACT(YEAR FROM
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
cfset today = #now()#
cfset week = #week(today)#
cfquery name=weekly datasource=#application.ds#
SELECTdate as
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!
If you are
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
cfquery name=weekly datasource=#application.ds#
SELECTdate as datefld
Date is a reserved word. Change it while you
Okay I did it .. still does not work
new code is
cfset CURRENT_DATE = #now()#
cfset today = #now()#
cfset week = #week(today)#
cfquery name=weekly datasource=#application.ds#
SELECTtestdate
FROMcompletedtest
WHERE EXTRACT(WEEK FROM testdate) = EXTRACT(WEEK FROM CURRENT_DATE)
AND
EXTRACT(YEAR
JT said:
cfquery name=weekly datasource=#application.ds#
SELECTtestdate
FROMcompletedtest
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)
/cfquery
The ERROR is :
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/
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
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
This did it.
cfset CURRENT_DATE = #now()#
cfset today = #now()#
cfset week = #week(today)#
cfset type = ww
!--- cfset lastweek =---
cfquery name=weekly datasource=#application.ds#
select * from Skills.completedtest
where week(date) = #week#-1
order by date,time
/cfquery
But I am confused . why
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 does
JT wrote:
This did it.
cfset CURRENT_DATE = #now()#
cfset today = #now()#
cfset week = #week(today)#
cfset type = ww
!--- cfset lastweek =---
cfquery name=weekly datasource=#application.ds#
select * from Skills.completedtest
where week(date) = #week#-1
order by date,time
/cfquery
But
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 similar
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.
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 the best
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
To:
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
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 thought
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
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 comes with CFMX.
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 very
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 8I 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
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
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-5444
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 sticking
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)
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't
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
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
Hi
I'm doing some research on ColdFusionadd 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]
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 first
I'm doing some research on ColdFusionadd 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 alongside
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, April
37 matches
Mail list logo