Hi all,
I am stuck. I have never had this happen before and I cannot figure it out.
Hopefully there is enough info below to see what I am not seeing
Any help would be greatly appreciated.
First of all when I connect to this directly through the cfc
, i.e. not through a webservice
everything
Hi all,
I am stuck. I have never had this happen before and I cannot figure it out.
Hopefully there is enough info below to see what I am not seeing
Any help would be greatly appreciated.
First of all when I connect to this directly through the cfc
, i.e. not through a webservice
everything
Hi,
I'm using cffile to read a .txt file.
I need to Replace the Carriage Return Line feed with a '|' when the new line
begins with a '0' or a '1'
and a '*' when the new line begins with a ''.
I am just too unfamiliar with RegEx to do it.
Any Ideas?
David DiPietro
OSU College of Medicine
Got it thanks
- Original Message -
From: David DiPietro [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, September 04, 2003 12:50 PM
Subject: Simple RegEx question
Hi,
I'm using cffile to read a .txt file.
I need to Replace the Carriage Return Line feed
to be made.
I have also enjoyed the use of its macro writing and text manipulation
features to process
the CSV files we get from various sources.
Those are the features that I am looking for in any other text editor before
I abandon
UltraEdit32
David DiPietro
OSU College of Medicine
- Original
The Convert function may do the trick
SELECT Title, CONVERT(CHAR(10), BDate, 101) AS formattedDate, ID
FROM YOURTABLE
GROUP BY CONVERT(CHAR(10), BDate, 101), Title, ID
David DiPietro
Systems Developer / Engineer
OSU College of Medicine Public Health
Voice (614) 292-5960
Fax (614
of forms
and you've saved yourself some time.
Hope this helps
David DiPietro
Systems Developer / Engineer
OSU College of Medicine Public Health
Voice (614) 292-5960
Fax (614) 292-0745
-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 03, 2002 2:46 PM
Sorry no attachments
David DiPietro
Systems Developer / Engineer
OSU College of Medicine Public Health
Voice (614) 292-5960
Fax (614) 292-0745
-Original Message-
From: David DiPietro [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 03, 2002 3:16 PM
To: CF-Talk
Subject: RE: Form
Here's the code if you want it.
Beware of wrapping
START CODE
cf_expire
!-- *** David DiPietro *** --
!-- *** Last updated 07/03/2002 *** --
!-- *** Feel Free to use and modify this and pass it to friends. *** --
!-- *** Hope it makes your lives easier. *** --
!-- *** This is being run
Very nice!
David DiPietro
Systems Developer / Engineer
OSU College of Medicine Public Health
Voice (614) 292-5960
Fax (614) 292-0745
-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 03, 2002 4:22 PM
To: CF-Talk
Subject: Re: Form Builder?
On 7/3/02, Kris
= MyStudentAssignmentTable.StudSSN
Where StudSSN is Null
/cfquery
/cfloop
David DiPietro
Systems Developer / Engineer
OSU College of Medicine Public Health
Voice (614) 292-5960
Fax (614) 292-0745
__
Signup for the Fusion Authority news alert and keep up
=#attributes.DocID# index='y'
cfset lc = #lc#+1
cfif lc eq 1
(MyTable.AttribID = #x# and MyTable.DocID = #y#)
cfelse
OR (dbo.personnel_appointment.department_id = #x#)
/cfif
/cfloop
/cfloop)
/cfif
David DiPietro
Systems Developer / Engineer
OSU College
#)
cfelse
OR (attrib_xref.DocID = #x# and attrib_xref.AttribID = #y#)
/cfif
/cfloop
)
/cfif
/cfloop)
/cfif
Order by attrib_xref.DocID
Now that's a Kludge!
David DiPietro
Systems Developer / Engineer
OSU College of Medicine Public
There's got to be another way to do this.
Any ideas?
cfloop list='#form.fieldNames#' index=x
cfset fieldName = '#x#'
cfset fieldValue = #evaluate('form.#x#')#
#fieldname# = #fieldValue#br
/cfloop
David DiPietro
Systems Developer / Engineer
OSU College of Medicine Public
You are the Man!
Thanks
David DiPietro
Systems Developer / Engineer
OSU College of Medicine Public Health
Voice (614) 292-5960
Fax (614) 292-0745
-Original Message-
From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 17, 2002 3:07 PM
To: CF-Talk
Subject: RE: Want
('yourFile.cfm','Pictures','600','450');font
color=##00*Pictures/font/a of this rotation.br
David DiPietro
Systems Developer / Engineer
OSU College of Medicine Public Health
Voice (614) 292-5960
Fax (614) 292-0745
-Original Message-
From: Tyler Silcox [mailto:[EMAIL PROTECTED]]
Sent: Thursday
-before: always}
/STYLE
with
cfoutput query='Stats'
Output
cfif some multiple of 10 code
P CLASS=breakhere
/cfif
/cfoutput
David DiPietro
Systems Developer / Engineer
OSU College of Medicine Public Health
Voice (614) 292
setInterval(checkForApplet('appletName'),3000);
/script
David DiPietro
Systems Developer / Engineer
OSU College of Medicine Public Health
Voice (614) 292-5960
Fax (614) 292-0745
-Original Message-
From: Neil Clark - =TMM= [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 26, 2002 5:46 AM
+
TO: Its Immediate Sub-Events\n\n +
Are you sure that is what you intend to do?
if (confirm(msg))
{ window.location=../actions/act_ActionPage.cfm; }
}
/script
A HREF=javascript:confirmDuplication('STUDENTS',#attributes.id#);do this/A
David DiPietro
Systems Developer
.#GetFields.FieldName#)
CFINPUT Name=#GetFields.FieldName##i# value=#DefaultValue#
/CFLOOP
David DiPietro
Systems Developer / Engineer
OSU College of Medicine Public Health
Voice (614) 292-5960
Fax (614) 292-0745
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED
cfset x = getValues[colname][rownum]
CFINPUT Name=#x# value=#DefaultValue#
Help me out. I don't get it.
Why isn't this an evaluative action?
David DiPietro
Systems Developer / Engineer
OSU College of Medicine Public Health
Voice (614) 292-5960
Fax (614) 292-0745
-Original Message
Thanks
David DiPietro
Systems Developer / Engineer
OSU College of Medicine Public Health
Voice (614) 292-5960
Fax (614) 292-0745
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 26, 2002 2:45 PM
To: CF-Talk
Subject: RE: Variable names in CFINPUT
Which of these is best?
1.
cfset x = getValues[colname][rownum]
CFINPUT Name=#x# value=#DefaultValue#
2.
cfset x = #x#+1
CFINPUT Name=#getValues.ColName##x# value=#DefaultValue#
3.
CFINPUT Name=#getValues[colname][rownum]# value=#DefaultValue#
David DiPietro
Systems Developer / Engineer
OSU
# Identbr
#cgi.HTTP_WHOIS_ID# Userbr
#cgi.Request_Method# Methodbr
#cgi.Script_Name# Script Namebr
#cgi.Server_Name# Server namebr
#cgi.Server_Port# S Portbr
#cgi.Server_Protocol# S Protocolbr
#cgi.Server_Software# S Softwarebr
/cfoutput
David DiPietro
Systems Developer / Engineer
OSU College of Medicine
I believe the onload=checkForMyApplet('appletName')
With some function would do the trick since onload happens at the end
of the page loading.
David DiPietro
Systems Developer / Engineer
OSU College of Medicine Public Health
Voice (614) 292-5960
Fax (614) 292-0745
-Original Message
I am a fan of Ultra Edit32
http://www.ultraedit.com/
It is a fantastic text editor with CF, HTML, JS etc... style sheets
and most useful to me Column Editing.
Take a peek. I love it.
David DiPietro
Systems Developer / Engineer
OSU College of Medicine Public Health
Voice (614) 292-5960
Fax
Try setting it through a function.
That is how I do onload events.
script language=Javascript
function focusme()
{
document.PracticeDetail.PName.focus();
}
/script
BODY onload='focusme()' bgcolor=white
-Original Message-
From: Larry Juncker [mailto:[EMAIL PROTECTED]]
Sent:
Every item in the select statement other than the count needs to be in the group by
statement
-Original Message-
From: David Grabbe [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 4:01 PM
To: CF-Talk
Subject: RE: SQL insanity...
I tried this:
cfquery name=sermon_nums
perhaps something like this would work
cfquery name=sermon_nums datasource=maindsn maxrows=5
SELECT sermons_details.sermon_num, count(sermons_details.sermon_num) AS tally,
sermons.title, sermons.tape, sermons.name, speakers.initials,sermons.size
FROM sermons_details
We do it this way
Table for responses
ID
EventID
ParticipantID
EvaluationID
EvalQuestionID
Response
Then we query total by EvaluationID and EvalQuestionID
-Original Message-
From: Craig Thomas [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 15, 2002 9:47 AM
To: CF-Talk
Subject: RE:
Alternately (if HTML)
Put it in a table
TABLE bgcolor=white border=0 cellpadding=0 cellspacing=0 width=640
TR
TD align=center
TABLE bgcolor=white border=0 cellpadding=0 cellspacing=0 width=600
TR
TD
#yourText#
/TD
/TR
/TABLE
This is how I do it
cfset RostersOut='#session.userID#''PreceptorRosters.csv'
cfset RostersFile='DriveLetter:\Path\Path\Path\Path\#RostersOut#'
cfset RostersPath='\Path\Path\Path\Path\#RostersOut#'
cfset RostersFileName='#RostersOut#'
form action='../GeneratedFiles/#RostersFileName#' method=Get
Oops The datasource thing is what you're after.
Sorry
-Original Message-
From: David DiPietro [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 4:37 PM
To: CF-Talk
Subject: RE: ODBC and cvs files
This is how I do it
cfset RostersOut='#session.userID#''PreceptorRosters.csv
Dave
You should be excited about this.
Great work. I hope this is just the tip of
the Figleaf Flash MX component Iceberg.
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 11:44 AM
To: CF-Talk
Subject: Announcement: New Flash MX component
34 matches
Mail list logo