Hi,
I need to adapt the code below which works ok.It consists of two
select boxes where one is populated based on what is chosen in the
other.
What I need is to show all the items in the second select menu when none
of the options from the first select menu has been chosen.
What is the best way
I have set up a scheduled task to run on CF5 and though it runs fine
when I hit 'Go' in the administrator, it does not set off when its
supposed to.
I first set it daily at 16.00 but has failed to run after a day.I then
triedDaily every5 minutes, from 14.00.00 to 18.00.00 but this hasn't
run today
Solved that problem. Was using eurodate format while administrator using
US Date Format.
Cheers,
Declan
-Original Message-
From: Declan Maher
Sent: 15 April 2004 16:03
To: CF-Talk
Subject: RE: scheduled task fails to run
I have set up a scheduled task to run on CF5 and though it runs
Could be a number of reasons. What database are you using?
Try
cfquery name=update_funds datasource=#request.dsn#
insert into fundprevious
{
thisday,
fundid,
fundvalue,
timeofchange
}
values
{
#thisfundday#,
#get_funds.fundid#,
'#previousValue#',
#CreateODBCDate( Now())#
}
/cfquery
Is there just one form submitting from one form or from multiple
forms/pages in site?
If you've ruled out this then ensure the enctype and method in the form
are set correctly.
I had problems with these before.
-Original Message-
From: Nick Han [mailto:[EMAIL PROTECTED]
Sent:
Select * fromTABLE
whereinvoice_date BETWEEN#CreateODBCDate(Now())# and
#Createodbcdate(Dateadd(d,30,DateFormat(now(#
-Original Message-
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]
Sent: 25 January 2004 16:57
To: CF-Talk
Subject: DateDiff and MS Access
In an access db I have
A great site for oracle stufflike this is :
http://asktom.oracle.com/
Theres a great search engine and Tom seems to spend a lot of his time
answering questions.
-Original Message-
From: Ryan Geesaman [mailto:[EMAIL PROTECTED]
Sent: 02 October 2003 04:46 PM
To: CF-Talk
Subject:
I am exporting to excel using the custom tag cf_html2Excel. Although
all the correct data shows on the include page I am using, in other
words the query that selects the data is correct, when I actually do the
export all that shows in excel is every second row.
Any help would be apprectiated.
This (below) won't refresh the query. It'll merely take the data from
the cache.
To update the query do the following.
Flushing Cached Queries
You can immediately refresh the queries that use the cachedwithin or
cachedafter attribute by inserting all zero values in the
CreateTimeSpan( )
?
Kola
-Original Message-
From: Declan Maher [mailto:[EMAIL PROTECTED]
Sent: 31 July 2003 10:43
To: CF-Talk
Subject: RE: Export to Excel - only alternate rows exported WHy?...
I am exporting to excel using the custom tag cf_html2Excel.
Although
all the correct data shows on the include
the html generated?
Kola
-Original Message-
From: Declan Maher [mailto:[EMAIL PROTECTED]
Sent: 31 July 2003 11:39
To: CF-Talk
Subject: RE: Export to Excel - only alternate rows exported WHy?...
Kola,
Here's how it does it.
This custom tag creates a dynamic Excel file from
I am using a float datatype in the database and calculating some numbers
on the page.
The calculation seems to round up the numbers to the nearest integer,
even when I use
numberformat or decimal format. How can I prevent it doing this?
Example below
cfif isdefined(P90) and P90 gt 0
cfif
Figured it out.
Thanks anyway!!
-Original Message-
From: Declan Maher
Sent: 24 September 2002 14:40
To: CF-Talk
Subject: Rounding numbers in coldfusion
I am using a float datatype in the database and calculating some numbers
on the page.
The calculation seems to round up the numbers
Can anybody point to a resouces for figuring out why errors are occuring
in the upgrade from cf5 to CFMX?
e.g. the evaluate function
The Error Occurred in
D:\dev.nobleenergy-nepat.com\www_root\input\newscardaction.cfm: line 58
56 :/cfif
57 : WHERE prospects_id =
I am attempting to build a dynamic scheduling system.
At the moment I have a system based over time where a user can enter
colours for a particular number of months to reflect when an action took
place. So say you had spent 3 months doing a certain task you input the
start date and end date,
Go to http://www.cfcomet.com/cfcomet/excel/
and check out the -- Use Excel files as datasources -- basic to advanced
section.
-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]]
Sent: 18 April 2002 10:08
To: CF-Talk
Subject: querying an xls file
Greetings,
could anyone
I took both. The differences are with the BB one you can keep your books
and studio open if you want to and nobody knows so it may not be worth
the paper its written on. If you do it genuinely then it is a difficult
exam (CF4 version). You are asked unusual questions of stuff you may
never have
I like this one:
http://www.cfcode.com/cfforum2000/index.cfm
-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: 11 April 2002 03:46
To: CF-Talk
Subject: Re: Suggestion for a good message forum to add to our CF SITE
Direct link:
-Original Message-
From: Declan Maher [mailto:[EMAIL PROTECTED]]
Sent: April 11, 2002 6:04 AM
To: CF-Talk
Subject: RE: Coldfusion Cert?
I took both. The differences are with the BB one you can keep your books
and studio open if you want to and nobody knows so it may not be worth
the paper its
may write it soon to get an
idea
of what I should work on
Yves
-Original Message-
From: Declan Maher [mailto:[EMAIL PROTECTED]]
Sent: April 11, 2002 8:54 AM
To: CF-Talk
Subject: RE: Coldfusion Cert?
Brainbench Certification(tm) Test Overview
Your Brainbench Certification(tm) test
Just confirming that you are correct in saying that webtrends tracks by
IP address for each unique user, so it is inaccurate if you have
multiple users coming from behind a proxy server. They won't be shown.
We had a student app that was showing loads of hits but a ridiculously
low number of
I think the term you are looking for is ..localisation or
localization (US).
-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: 29 March 2002 14:04
To: CF-Talk
Subject: Internationalization
We are makers of SiteDirector a commerce application and
Joshua,
If you look at www.cfcomet.com or
http://www.cfcomet.com/cfcomet/sql_server/
it shows how to execute SQL Server DTS packages from ColdFusion.
-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: 26 March 2002 17:10
To: CF-Talk
Subject: SQL Question
Sorry didn't read your question right
-Original Message-
From: Declan Maher
Sent: 26 March 2002 17:13
To: CF-Talk
Subject: RE: SQL Question
Joshua,
If you look at www.cfcomet.com or
http://www.cfcomet.com/cfcomet/sql_server/
it shows how to execute SQL Server DTS packages from
Check out http://www.webtricks.com/SourceCode/
Heres the code. If you need further details go there.
!--- Select the states and area codes. ---
CFQUERY DATASOURCE = States NAME = GetStates
SELECT S.State, S.StateCode, AC.AreaCode
FROM States S, AreaCodes AC
WHERE S.StateCode = AC.StateCode
ORDER
This is a really good site for what you need and other good stuff:
http://www.webtricks.com/SourceCode/relatedselects.cfm
Regards,
Declan
-Original Message-
From: Graham Pearson [mailto:[EMAIL PROTECTED]]
Sent: 13 March 2002 12:29
To: CF-Talk
Subject: Select Boxes Populating another
We use Visio.
-Original Message-
From: Matt Kornguth [mailto:[EMAIL PROTECTED]]
Sent: 13 March 2002 16:36
To: CF-Talk
Subject: OT: Storyboarding software?
Any suggestions on software to use for storyboarding? If not specific
software for that purpose, what are you using that makes your
its hard to find but here it is...
http://devex.macromedia.com/developer/gallery/index.cfm
-Original Message-
From: Mike Kear [mailto:[EMAIL PROTECTED]]
Sent: 05 March 2002 11:18
To: CF-Talk
Subject: What happened to the tag gallery
I have spent the last 30 minutes looking
http://www.microsoft.com/net/
-Original Message-
From: Nick McClure [mailto:[EMAIL PROTECTED]]
Sent: 04 March 2002 16:57
To: CF-Talk
Subject: RE: a little about the future
This .NET stuff you speak of, tell me more.
At 11:51 AM 3/4/2002 -0500, you wrote:
Tech related to CF and which
use the upsizing wizard in Access after you grt username and pass from
the person in charge of sql server.
-Original Message-
From: Louis Klepner [mailto:[EMAIL PROTECTED]]
Sent: 27 February 2002 15:44
To: CF-Talk
Subject: RE: Access - MS SQL script?
Thanks for the advice, and I wish
I am using CFExecute to run the dtsrun utility which then runs a
DTSPackage on Sql Server.
When I run it from the command prompt(cmd.exe) it runs fine with the
following line:
C:\dtsrun /S portland /U username /P password /N DTS_prediction
However when I use code (below) on the server it doesn't
: Declan Maher [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 10:48 AM
To: CF-Talk
Subject: RE:using CFEXECUTE
I am using CFExecute to run the dtsrun utility which then runs a
DTSPackage on Sql Server.
When I run it from the command prompt(cmd.exe) it runs fine with the
following
There was a site where it looks like you can do this. But I haven't used
it. Can't remember where I got a previous emulator but there are others
out there.
The www.gelon.net WebSite allows you to view a WAP page by submitting a
link to their emulator located in their server to process.
Coldfusion is not like ASP in that session variables are not killed when
the browser is closed.
YOu can also kill session vars by creating a page with this code and
opening it in your browser.
cfscript
StructClear(session);
/cfscript
cfscript
StructClear(application);
/cfscript
such as Open Forums
http://www.stickshiftsolutions.com/index.cfm?jumpto=29
Regards,
Declan
-Original Message-
From: Declan Maher
Sent: 09 January 2002 11:08
To: CF-Talk
Subject: RE: Using a DTS package
Can anybody advise me what is the best/simplest way of converting a SQL
Server
This is an email (from an ASP mailing list called 4guysfromrolla.com)
which discusses checking where a user is from.
Hope it helps.
One question that is often asked on the ASPMessageboard is: How can I
determine where someone is located, by grabbing their IP, either so the
page can be
Can anybody advise me what is the best/simplest way of converting a SQL
Server database to Access in the following instance.
My user needs to be able to just go to the website click on a button and
the database needs to be converted.
Then the user can just download the Access db and analyse it
CFQUERY NAME=INSOBJ
DATASOURCE=uspc
INSERT INTO t_sectest
(cal_date_start,
cal_date_end)
VALUES ('#CreateODBCDate(form.cal_date_start)#',
'#CreateODBCDate(form.cal_date_end)#')
/cfquery
-Original Message-
From: Mark Leder
Other attributes of cfquery which may be of help in speeding up a
query is to try using
blockfactorwhick specifies the max number of rows to fetch at a time
from the server
or maxrows if you want to limit the number of rows returned.
Regards,
Declan
-Original Message-
From: Tracy
Hi database experts,
I have just migrated a database from Access to SQL Server however I need
to have a system in place that automatically makes a copy of the latest
data in the SQL Server db back to Access when the user requests this.The
access db will then be downloaded by the user. The
Hi,
No matter what I try this will not work for me.
Can anybody point out what is wrong with this code.
cfset targ=#DateFormat(01/12/2001,dd/mm/)#
cfoutput#targ#/cfoutput
cfset compare=DateDiff(d,#targ#,#DateFormat(Now(),dd/mm/)#)
It gives me weird output dates - of -233.
Thanks,
Declan
, Belgium
Tel +32 2 639 68 70
Fax +32 2 639 68 99
Email [EMAIL PROTECTED]
Web www.lrt.be
-Original Message-
From: Declan Maher [mailto:[EMAIL PROTECTED]]
Sent: dinsdag 4 december 2001 13:22
To: CF-Talk
Subject: I hate DateDiff!
Hi,
No matter what I try this will not work for me
Have you thought of using url.variables or passing vars in
form.variables.
-Original Message-
From: Won Lee [mailto:[EMAIL PROTECTED]]
Sent: 29 November 2001 17:19
To: CF-Talk
Subject: 10 Step Program
Hi my name is Won Lee and I'm addicted to session variables.
In an attempt to rid
Can anybody help me with an Alter statement in Access.
I am trying to put a default date of 01/01/2000 in the database and
anything I have tried has failed.
Heres the code I've tried
ALTER TABLE implementation ADD COLUMN #form.target_date# date default
01/01/2000
But it fails.
Thanks in
#)#,#DayofYear(#implm#)#)#
cfset comparison_list=#ListAppend(comparison_list,#compare#)#
I have tried other means of doing this but with no success.
Can somebody suggest the correct code to use to compare dates that
overlap years?
Thanks in advance,
Declan maher
-Original Message-
From: Carlisle
#)#,#DayofYear(#implm#)#)#)
Im not sure on the pounds, but play with it.
Lemme know if this helps.
Mike
-Original Message-
From: Declan Maher [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 20, 2001 11:11 AM
To: CF-Talk
Subject: RE: Datediff
I am having problems comparing two dates.
My
the difference: compar=
DateDiff('d',targ,implm)
Datediff works on entire dates.
Pascal
-Original Message-
From: Pascal Peters
Sent: dinsdag 20 november 2001 17:24
To: CF-Talk
Subject: RE: Datediff
datecompare(date1,date2)
-Original Message-
From: Declan Maher [mailto:[EMAIL
and use a generalisation, if you have a personal site you can
get on enough engines for free but it may take months, but if you have
money to spend then you can get a better ranking, much faster, and can
have your site automatically re-submitted regularly when you pay.
Declan Maher
Web
and it
will work in both Access and SQL Server
datatype
Yes/No Bit
When converted if you use TRUE/FALSE this will throw an error.
Instead use 1/0 to determine if it should be switched on/off.
Also Delete * from Table needs to be changed to Delete from Table.
Declan Maher
Web
However the error message I am getting is as follows.
Cookies are not enabled or a Coldfusion Error has occurred.Be sure that
Cookies are enabled on your browser and that all the ActiveEdit
attributes are correct.
Any suggestions or help greatly appreciated.
Cheers,
Declan Maher
Web Applications
Hi,
I am getting an error when using ListAppend function.
Can anybody see whats wrong with this code?
I cannot figure out what the problem is.
cfif cgi.http_referer CONTAINS Corex1
cfparam name=mychanges default=
cfif isDefined(Form.Programme_name) AND GetContent.Programme_name NEQ
CFIF parameterexists(url.order) and url.order
eq ascASCcfelseDESC/cfif
/cfif
/cfif
/cfquery
thanks,
Regards,
Declan Maher
Web Applications Developer
Head Office
133-137 Lisburn Road
Belfast
Northern Ireland
BT9 7AG
T: +44 (0) 28 9022 3224
F: +44 (0) 28 9022 3223
E: [EMAIL PROTECTED
Hi,
I have created a pdf dynamically on the server with an image inside and when I open
it on the server it shows the image fine. However when I try to open it through a
browser it fails to show the image.
Can anybody suggest what the problem might be?
of the info is on the site above.
Cheers,
Declan Maher
Web Applications Developer
Head Office
133-137 Lisburn Road
Belfast
Northern Ireland
BT9 7AG
T: +44 (0) 28 9022 3224
F: +44 (0) 28 9022 3223
E: [EMAIL PROTECTED]
W: biznet-solutions.com
-Original Message-
From: Edward Chanter
Aidan,
If you like you can purchase a copy of coldfusion server from us in
Northern Ireland!
BizNet Solutions 133-137 Lisburn Road
Belfast, BT09 7AG
Ireland
+ 44 (028) 90 223224
+ 44 (028) 90 223223
[EMAIL PROTECTED]
http://www.biznet-solutions.com
-Original Message-
From: Darren
in Adobe Acrobat. Can
anybody tell me what is causing this and suggested solutions?
Thanks,
Declan Maher
Web Applications Developer
Biznet-Solutions
133-137 Lisburn Road
Belfast
BT9 7AG
Tel:(0)28 9022 3224
Fax:+44 (0)28 9022 3223
Email:[EMAIL PROTECTED]
Web: http://www.biznet-solutions.com
56 matches
Mail list logo