Entity has incorrect type for being called as a function

2009-05-28 Thread David DiPietro
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

Entity has incorrect type for being called as a function

2009-05-28 Thread David DiPietro
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

Simple RegEx question

2003-09-04 Thread David DiPietro
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

Re: Simple RegEx question - got it :)

2003-09-04 Thread David DiPietro
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

Re: DWMX 2004 - Whats new for us?

2003-08-25 Thread David DiPietro
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

RE: Group by on date/time field

2002-07-22 Thread David DiPietro
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

RE: Form Builder?

2002-07-03 Thread David DiPietro
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

RE: Form Builder?

2002-07-03 Thread David DiPietro
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

RE: Form Builder?

2002-07-03 Thread David DiPietro
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

RE: Form Builder?

2002-07-03 Thread David DiPietro
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

SQLDatasource Wall

2002-06-13 Thread David DiPietro
= 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

RE: SQL query question

2002-05-29 Thread David DiPietro
=#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

RE: SQL query question

2002-05-29 Thread David DiPietro
#) 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

Want to eliminate the Evaluate

2002-05-17 Thread David DiPietro
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

RE: Want to eliminate the Evaluate

2002-05-17 Thread David DiPietro
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

RE: OT : js submit into new window...

2002-05-16 Thread David DiPietro
('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

RE: 10 records per page

2002-05-02 Thread David DiPietro
-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

RE: Determining if a java applet has been loaded in JS?

2002-04-26 Thread David DiPietro
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

RE: javaScript (simple)

2002-04-26 Thread David DiPietro
+ 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

RE: Variable names in CFINPUT

2002-04-26 Thread David DiPietro
.#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

RE: Variable names in CFINPUT

2002-04-26 Thread David DiPietro
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

RE: Variable names in CFINPUT

2002-04-26 Thread David DiPietro
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

RE: Variable names in CFINPUT

2002-04-26 Thread David DiPietro
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

RE: previous cfm page

2002-04-26 Thread David DiPietro
# 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

RE: Determining if a java applet has been loaded in JS?

2002-04-25 Thread David DiPietro
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

RE: At my new job

2002-04-22 Thread David DiPietro
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

RE: Set focus on a CFINPUT field

2002-04-18 Thread David DiPietro
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:

RE: SQL insanity...

2002-04-17 Thread David DiPietro
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

RE: SQL insanity...

2002-04-17 Thread David DiPietro
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

RE: survey trouble

2002-04-15 Thread David DiPietro
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:

RE: Wrapping Text

2002-04-11 Thread David DiPietro
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

RE: ODBC and cvs files

2002-04-09 Thread David DiPietro
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

RE: ODBC and cvs files

2002-04-09 Thread David DiPietro
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

RE: Announcement: New Flash MX component

2002-03-28 Thread David DiPietro
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