John,
cfmailparam file=TPHRDataExtractGet.xls
Hope this helps!
Daniel
On 7/8/06, John Lucania [EMAIL PROTECTED] wrote:
snake,
The file name is TPHRDataExtractGet.xls. How do you attach it in cfmail??
jl
On 7/8/06, Snake [EMAIL PROTECTED] wrote:
Wrap it in cfsavecontent, then use
You can simply compare now () +7 against toexpire.
Daniel
On 10/14/05, Protoculture [EMAIL PROTECTED] wrote:
I need a query that will return all records that are set to expire ( column
name toexpire - which is just a date ) in the next 7 days.
select * from mytable
where toexpire ???
Have you checked firewall?
Daniel
On 10/13/05, Mark Fuqua [EMAIL PROTECTED] wrote:
I don't know if this will help you, but it sure seems timely (posted early
this morning)
http://www.danvega.org/blog/client/index.cfm/2005/10/12/Sending-mail-with-CF
Mail-A-problem--A-solution
Mark Fuqua
Communications
10983 Granada Lane
Overland Park, KS 66211
(913) 754-4272
On 5/18/05, Daniel Kang [EMAIL PROTECTED] wrote:
When I run cfcharts, I am getting the error below. Please let me
know how to debug this.
tia
Expected = instead of (0x3C) In line:1 position:75. Stack:xmlrow6
=qryAnswerExp
itemcolumn=QNo
valuecolumn=QG
markerStyle = diamond
serieslabel=G
paintStyle=raise
/cfchart
On 5/18/05, Daniel Kang [EMAIL PROTECTED] wrote:
When I run cfcharts, I am getting the error below. Please let me
know how to debug this.
tia
When I run cfcharts, I am getting the error below. Please let me
know how to debug this.
tia
Expected = instead of (0x3C) In line:1 position:75. Stack:xmlrow6
The error occurred in
D:\Inetpub\wwwroot\SafetyClimateSurvey\StatChartQ21.cfm: line 166
164 : markerStyle = diamond
165 :
I am getting these errors from CFMX and cannot get into any apps and
cfmx admin as well.
Server Error
The server encountered an internal error and was unable to complete
your request.
JRun closed connection.
What is wrong and how to fix?
tia
I want to put a scheduled task in either the Scheduled Tasks page in
the CF Administrator or the CFSCHEDULE tag. I like to make the
transactions as real-time as possible, but at the same time I do not
want to bog down the system with a very short interval. What is the
shortest interval that we
Thank you so much for the crystal-clear explanation.
Daniel
On 5/10/05, Dave Watts [EMAIL PROTECTED] wrote:
Can anyone explain what this error means?
tia
7305
Error,jrpp-85,05/09/05,21:07:56,,File not found:
/CFIDE/main/ide.cfm The specific sequence of files included or
Can anyone explain what this error means?
tia
7305
Error,jrpp-85,05/09/05,21:07:56,,File not found:
/CFIDE/main/ide.cfm The specific sequence of files included or
processed is: C:\Inetpub\wwwroot\CFIDE\main\ide.cfm
7306
coldfusion.runtime.TemplateNotFoundException: File not found:
\\localhost\{drive}$\folder or change the
account under which CFMX runs (available via properties for that service in
the Services control panel) to access share points on remote boxes.
J
On 5/5/05, Daniel Kang [EMAIL PROTECTED] wrote:
OK, I created a folder (\\swintranet1\D:\IntranetData
\\swintranet1\d$\Inetpub\wwwroot\RefPosting is the right destination,
but I am getting this error.
What am I missing?
The destination \\swintranet1\d$\Inetpub\wwwroot\RefPosting
specified in the CFFILE tag is invalid.
The destination either does not exist or is not accessible by this tag.
The
definitely have to create a domain account for
CFMX to run under, then give that account privileges to access the file you
want.
Let me know if you need more help.
Laterz,
J
On 5/5/05, Daniel Kang [EMAIL PROTECTED] wrote:
\\swintranet1\d$\Inetpub\wwwroot\RefPosting is the right
I am trying to connect an Excel file. I have tried
http://www.emerle.net/programming/display.cfm/t/cfx_excel2query, but
it does not work for me. Is there another way to connect to Excel
files on the CF Server?
tia
~|
Logware
Also, this (http://www.irs.gov/individuals/article/0,,id=96196,00.html)
will give you an idea.
Daniel
On 4/29/05, Michael Dinowitz [EMAIL PROTECTED] wrote:
Counts on many things. For me with a wife and 3 kids, I pay about 33% or so.
That means around 34k after taxes but various deductions can
The fundamental question is why CF developers get paid less than
others?? Perhaps, I need to switch to the Java arena!
Daniel
On 4/29/05, Rob [EMAIL PROTECTED] wrote:
if I wanted to pay $60-70k I could easily hire a very senior developers
(which seem to be easier to find too!).
A mid
, AboutWeb - http://www.aboutweb.com
Editor-in-Chief, ColdFusion Developers Journal
Member of Team Macromedia
Macromedia Certified Master Instructor
Blog - http://www.horwith.com
Daniel Kang wrote:
The fundamental question is why CF developers get paid less than
others?? Perhaps, I
Rick,
Have you tried with B.TEAM_NAME AS TEAM_NAME?
Daniel
On 4/16/05, Rick Root [EMAIL PROTECTED] wrote:
This is a repost... can nobody help with this?
I'm having some trouble with CFCHART... coldfusion MX 6.1 Enterprise on
Linux ... I've never used it before, but I've got something
Is it possible to set up DSN-Less Connection in MX?
cfset MyConnectString =
Driver={Microsoft Text Driver
(*.txt;*.csv)};Dbq=d:\HospitalFormulary\;Extensions=txt,csv,tab,txt;Persist
SecurityInfo=False;
CFQUERY
name=TheTest
DBType=dynamic
ConnectString=#MyConnectString#
I am getting the
I am using MX. What are the workarounds?
tia
On 4/14/05, Joe Rinehart [EMAIL PROTECTED] wrote:
Dan,
The DSN-less connections from CF 5 don't work in MX and above - there
are, however, workarounds for both. Are you using MX or MX 7?
-Joe
On 4/14/05, Daniel Kang [EMAIL PROTECTED
I want to give users the ability to upload database on CF pages. A
table in SQL Server is already defined, and what they need to do is
just uploading the data from an Excel file into the existing table by
clicking on 'Submit/Upload button'. The Excel file has the same
columns as the table in
Thank you so much.
I got it working.
Daniel
On 4/12/05, S. Isaac Dealey [EMAIL PROTECTED] wrote:
Oops! Sorry -- typo... that should be value=... instead of
name=...
cfparam name=form.categoryid type=string default=
cfloop index=x list=#form.categoryid#
cfset altcatname =
page-break-before works fine on IE 6, which my users are using.
I want to skip certain pages when being printed to save trees. I put
the CSS below for testing. It skips the page, but it still prints a
blank page, which does not let me save trees. Please let me know if I
am missing anything.
The challenge here is that the number of checkboxes are not defined,
meaning the user (to make it simple, let us say a user) can add any
number of checkboxes (20, 40, 50, etc). This also makes very hard
(=whenever the user wants to add one checkbox, I have to add the
checkbox on the CF page and
One issue I am seeing on this is that display:none makes the
specific paragraphs invisible on Web Browser, which makes not to print
the specific page. It seems that there is no way to view the page
but not to print It seems it becomes OT!
div style=display:none;
div
I see your point! I will try that as you suggest.
On Apr 11, 2005 1:18 PM, S. Isaac Dealey [EMAIL PROTECTED] wrote:
These are predefined departments arent they?
Even if they aren't, why would you subject yourself to the horror of
adding a database column each time a user adds a category?
cfparam name=form.categoryid type=string default=
cfloop index=x list=#form.categoryid#
cfset altcatname = form[altcategoryname_#x#]
cfquery name=InsertForms datasource=PhysicianForms
insert into tFormCategory
(formid,categoryid,altcategoryname)
values ('#session.formid#','#x#',
I am looking for a CF functionality, tag, or way that can allow users
add/remove/modify checkboxes/dropdown boxes dynamically.
Checkboxes are preferable if possible than dropdown boxes.
1) Adding checkboxes/ dropdown boxes
In Category section, there are categories like 1 North, 2 North, 2
One CF page contains several document sections (i.e. Index, Content I,
Content II, etc, and Appendix). Is there a way (in CF or something
else) to put print break so that each section can be printed
separate, not as one long document?
tia,
Daniel
cfquery qryAnswer returns three columns (QYesCount, QnoCount, and
QNACount). What I am trying to do is drawing a bar chart with the
itemcolumn QNo (=Question Numbers) against the three columns. What
do you put more than one column onto valuecolumn in cfchartseries? Is
there any other way to
I have a cfquery below:
cfquery name=NumofIntake datasource=foo
select
datepart(mm, DateofReferral) as TheMonth,
count(datepart(mm, DateofReferral)) as TheCount
from Intake
where datepart(mm, DateofReferral) is not null
cfif form.YearSelection eq select
cfelse
and datepart(yy,
rambling? :-)
MIke
On Sat, 19 Mar 2005 11:42:22 -0500, Daniel Kang [EMAIL PROTECTED] wrote:
I have a cfquery below:
cfquery name=NumofIntake datasource=foo
select
datepart(mm, DateofReferral) as TheMonth,
count(datepart(mm, DateofReferral)) as TheCount
from Intake
where datepart
I have a cfquery:
cfquery name=qryYes datasource=CCSurvey
select
sum (case when Q1=1 then 1 else 0 end) as Q1Sum,
sum (case when Q2=1 then 1 else 0 end) as Q2Sum,
sum (case when Q3=1 then 1 else 0 end) as Q3Sum,
sum (case when Q4=1 then 1 else 0 end) as Q4Sum,
sum (case when Q5=1 then 1 else 0
I have cfoutput with cfif eq as below.
tdbdiv align=rightcfoutput query=NumofReasoncfif TheMonth
eq 1 and ReferralReason eq General
Information#TheCount#/cfif/cfoutput/div/b/td
tdbdiv align=rightcfoutput query=NumofReasoncfif
TheMonth eq 2 and ReferralReason eq General
A table (Referral_Action in SQL Server 2000) has Action_Item as below
along with the date of action.
Carried Over (let say CO)
Client/Family Cancelled (CC)
Home Assessment (HA)
Other (OT)
Referred Other Agency/Service (RO)
Volunteer Assigned (VA)
The query will be
cfquery name =foo ….
Select
35 matches
Mail list logo