Entity has incorrect type for being called as a function
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 works fine. However, once I try to get it through a webservice it breaks. I am creating a webservice object. http://ckm-dev.osumc.edu/webservices/edu/osu/twomdtools/ems/ems.cfc?wsdl";> I can create the object by connecting to the webservice Upon creation I dump the object and see everything in it including the method "getBookingWithDetail" that I am looking for in the struct on the "Methods" line. object of webservices.edu.osu.twomdtools.ems.EmsCfcSoapBindingStub Class Name webservices.edu.osu.twomdtools.ems.EmsCfcSoapBindingStub MethodsMethod Return Type getBookingWithDetail(java.lang.String, double, java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String) coldfusion.xml.rpc.QueryBean Upon dumping the methods I get this error Element METHODS is undefined in WSOBJECT. When I call the method in the invoke I get the following error Entity has incorrect type for being called as a function. The symbol you provided getBookingWithDetail is not the name of a function. This is the function SELECT TOP 100 PERCENT so.ID AS ServiceOrderID, bk.ID as BookingID, bk.ReservationID, bk.TimeBookingStart, bk.TimeBookingEnd, bk.EventName, bk.RoomID, bk.StatusID, st.Description AS StatusDescription, rsv.TempContact, rsv.Phone AS TempContactPhone, rsv.AltTempContact, bk.TimeEventStart, bk.TimeEventEnd, rsv.AltPhone AS AltTempContactPhone, rm.Room, bld.Description AS BuildingDescription, sod.ResourceID, sod.Quantity, sod.Notes, rsc.ResourceDescription, g.groupName FROM dbo.tblBooking AS bk INNER JOIN dbo.tblStatus AS st ON bk.StatusID = st.ID INNER JOIN dbo.tblReservation AS rsv ON bk.ReservationID = rsv.ID LEFT OUTER JOIN dbo.tblServiceOrder AS so ON bk.ID = so.BookingID LEFT OUTER JOIN dbo.tblRoom AS rm ON bk.RoomID = rm.ID LEFT OUTER JOIN dbo.tblBuilding AS bld ON rm.BuildingID = bld.ID LEFT OUTER JOIN dbo.tblServiceOrderDetail AS sod ON so.ID = sod.ServiceOrderID LEFT OUTER JOIN dbo.tblResource AS rsc ON sod.ResourceID = rsc.ID LEFT OUTER JOIN dbo.tblGroup g on rsv.groupID = g.ID where 0=0 AND bk.ID IN () AND bk.ReservationID = AND g.GroupName = AND rm.Room = AND bk.TimeBookingStart >= AND bk.TimeBookingEnd <= AND bk.StatusID IN () Order by bk.TimeBookingStart ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322916 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Entity has incorrect type for being called as a function
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 works fine. However, once I try to get it through a webservice it breaks. I am creating a webservice object. http://ckm-dev.osumc.edu/webservices/edu/osu/twomdtools/ems/ems.cfc?wsdl";> I can create the object by connecting to the webservice Upon creation I dump the object and see everything in it including the method "getBookingWithDetail" that I am looking for in the struct on the "Methods" line. object of webservices.edu.osu.twomdtools.ems.EmsCfcSoapBindingStub Class Name webservices.edu.osu.twomdtools.ems.EmsCfcSoapBindingStub MethodsMethod Return Type getBookingWithDetail(java.lang.String, double, java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String) coldfusion.xml.rpc.QueryBean Upon dumping the methods I get this error Element METHODS is undefined in WSOBJECT. When I call the method in the invoke I get the following error Entity has incorrect type for being called as a function. The symbol you provided getBookingWithDetail is not the name of a function. This is the function SELECT TOP 100 PERCENT so.ID AS ServiceOrderID, bk.ID as BookingID, bk.ReservationID, bk.TimeBookingStart, bk.TimeBookingEnd, bk.EventName, bk.RoomID, bk.StatusID, st.Description AS StatusDescription, rsv.TempContact, rsv.Phone AS TempContactPhone, rsv.AltTempContact, bk.TimeEventStart, bk.TimeEventEnd, rsv.AltPhone AS AltTempContactPhone, rm.Room, bld.Description AS BuildingDescription, sod.ResourceID, sod.Quantity, sod.Notes, rsc.ResourceDescription, g.groupName FROM dbo.tblBooking AS bk INNER JOIN dbo.tblStatus AS st ON bk.StatusID = st.ID INNER JOIN dbo.tblReservation AS rsv ON bk.ReservationID = rsv.ID LEFT OUTER JOIN dbo.tblServiceOrder AS so ON bk.ID = so.BookingID LEFT OUTER JOIN dbo.tblRoom AS rm ON bk.RoomID = rm.ID LEFT OUTER JOIN dbo.tblBuilding AS bld ON rm.BuildingID = bld.ID LEFT OUTER JOIN dbo.tblServiceOrderDetail AS sod ON so.ID = sod.ServiceOrderID LEFT OUTER JOIN dbo.tblResource AS rsc ON sod.ResourceID = rsc.ID LEFT OUTER JOIN dbo.tblGroup g on rsv.groupID = g.ID where 0=0 AND bk.ID IN () AND bk.ReservationID = AND g.GroupName = AND rm.Room = AND bk.TimeBookingStart >= AND bk.TimeBookingEnd <= AND bk.StatusID IN () Order by bk.TimeBookingStart ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322915 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Simple RegEx question - got it :)
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 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 > > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
Simple RegEx question
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 ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Re: DWMX 2004 - Whats new for us?
I'll jump on the band wagon. I use the column mode of UltraEdit 3-4 times a day because I write my code in such a was as to take advantage of its speed. It's tag completion (including CF tags) and macros make it a very fast development tool. It's seemingly unlimited (not really but nearly 100 steps back) undo and timed backup to a separate directory (defacto though limited sourcesafe) have saved me many a time. The ability to color code HTML, JavaScript, and ColdFusion tags, attributes and declarations granularly makes it very easy to research code I wrote 3 years ago as changes need 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 Message - From: "Mark W. Breneman" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, August 25, 2003 3:40 PM Subject: RE: DWMX 2004 - Whats new for us? > I hate to do a "me too" but I keep Ultraedit 32 on my computer just for > that Vertical select feature. I use it at least 2-5 a week. > > Mark W. Breneman > -Cold Fusion Developer > -Network Administrator > Vivid Media > [EMAIL PROTECTED] > www.vividmedia.com > 608.270.9770 > > -Original Message- > From: Jerry Barnes [mailto:[EMAIL PROTECTED] > Sent: Monday, August 25, 2003 2:27 PM > To: CF-Talk > Subject: RE: DWMX 2004 - Whats new for us? > > Vertical select would be a nice feature. Also allowing the user to > insert spaces for tabs and indicating the cursor column position in code > view would make good additions. > > J > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Monday, August 25, 2003 2:32 PM > To: CF-Talk > Subject: Re: DWMX 2004 - Whats new for us? > > > What I'd like to know is if they've finally added the ability to mark a > column of text in "code view" mode just like UltraEdit32 can. Until I > see that feature added, UltraEdit will probably remain my editor of > choice. > > That's not to say that I don't used DWMX at all. I just find myself > using UltraEdit more than DWMX. > > > > ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Group by on date/time field
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) 292-0745 -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 4:59 PM To: CF-Talk Subject: Group by on date/time field I have a query that needs to be output in groups based on a datetime value (SQL Server 7.0/2000). The trouble I'm having is with the time value. I need to group on the date alone. Do I need to store the values seperately, or can SQL parse it in the query as only the date portion so CF can use it in the ? Jeff Beer Director of Application Development Digital Stormfront, Inc http://www.digitalstormfront.com <http://www.digitalstormfront.com> __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Form Builder>?
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 Pilles penned: >Anyone know if any coldfusion based HTML form generators exist??? > >I need one but would like to avoud building it if at all possible.. Here's one you can play with. http://www.twcreations.com/makeform/ It will generate your insert and update queries also. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Form Builder>?
cfelse>
cfquery name='update#TTableName#'
datasource='#DatasourceName#'>
update #TTableName#
Set
cfif
isdefined('attributes.#x#') and attributes.#x# neq ''>#x#='##attributes.#x###'
/cfif> cfif
isdefined('attributes.#x#') and attributes.#x# neq ''>,#x#='##attributes.#x###'
/cfif>
Where
ID=##attributes.ID##
/cfquery>
cfset update=1>
/cfif>
cfelse>
cfif not isdefined('attributes.Action') or
(isdefined('attributes.Action') and attributes.Action neq 'D')>
cfquery name='Insert#TTableName#'
datasource='#DatasourceName#'>
INSERT into #TTableName#(
cfif
isdefined('attributes.#x#') and attributes.#x# neq ''>#x#
/cfif> cfif
isdefined('attributes.#x#') and attributes.#x# neq ''>,#x#
/cfif>
)
Values (
cfif
isdefined('attributes.#x#') and attributes.#x# neq ''>'##attributes.#x###'
/cfif> cfif
isdefined('attributes.#x#') and attributes.#x# neq ''>,'##attributes.#x###'
/cfif>
)
/cfquery>
cfset insert=1>
/cfif>
/cfif>
cfif not isdefined('attributes.Action') or
(isdefined('attributes.Action') and attributes.Action neq 'D')>
cfquery name='GetID'
datasource='#DatasourceName#'>
Select ID
From#TTableName#
Where 0 = 0
cfif
isdefined('attributes.#x#') and attributes.#x# neq ''>AND #x#='##attributes.#x###'
/cfif>
/cfquery>
/cfif>
cfoutput>
cfif 0 eq 0>
cfif GetID.recordcount gt 0 and
GetID.recordcount gt 0>
cfif
isdefined('cgi.Http_Referer') and insert eq 0 and update eq 1>
cflocation
URL='##cgi.Http_Referer##' addtoken="No">
cfelse>
cflocation
URL='../display/DSP_whatever.cfm?view=E&CompID=##GetID.ID##' addtoken="No">
/cfif>
cfelse>
cflocation
URL='../display/DSP_whatever.cfm?view=N' addtoken="No">
/cfif>
/cfif>
/cfoutput>
END CODE
David DiPietro
Systems Developer / Engineer
OSU College of Medicine & Public Health
Voice (614) 292-5960
Fax (614) 292-0745
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Form Builder>?
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 Builder>? Here is a very elementry one I made Simply set the table name and Datasource name And you are on your way. View source and copy where it says to. Search and insert the "<"s for the display page. Copy the action page directly and again search and insert the "<"s Tweak the display for different types 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 To: CF-Talk Subject: Form Builder>? Anyone know if any coldfusion based HTML form generators exist??? I need one but would like to avoud building it if at all possible.. KP __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Form Builder>?
Here is a very elementry one I made Simply set the table name and Datasource name And you are on your way. View source and copy where it says to. Search and insert the "<"s for the display page. Copy the action page directly and again search and insert the "<"s Tweak the display for different types 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 To: CF-Talk Subject: Form Builder>? Anyone know if any coldfusion based HTML form generators exist??? I need one but would like to avoud building it if at all possible.. KP __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQLDatasource Wall
I'm running into a wall with my sql Datasource on the StudentAvail Query. I need to know if the SSNs found in the query are already in MyStudentAssignmentTable this will eventually be rolled in as a sub query to add only those who are not yet in the table. However, If I use the #DSN# as the datasource the #tbl# does not appear and if I use query, MyStudentAssignmentTable does not appear. Is there a way to do a join on an existing query as well as a table in an existing datasource in the same query or will I need to loop through? Thanks in Advance SELECT a.SSN, a.#tMonth#, b.CCF,b.NameDotN,b.LNAME, b.FNAME,b.SSN FROM #M4Scheduletable# a INNER JOIN Studs b ON a.SSN = b.SSN WHERE (b.SSN=b.SSN) And ( a.#tMonth# = '#y#' OR a.#tMonth# = '#y#' ) SELECT #tbl#.SSN, MyStudentAssignmentTable.StudSSN FROM#tbl# LEFT OUTER JOIN MyStudentAssignmentTable ON MyStudentAssignmentTable.EventItemID = #tID# AND #tbl#.SSN = MyStudentAssignmentTable.StudSSN Where StudSSN is Null 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 with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL query question
let's try again Select DocID,AttribID,AttribValue >From attrib_xref Where 0 = 0 And ( ( (attrib_xref.DocID = #x# and attrib_xref.AttribID = #y#) OR (attrib_xref.DocID = #x# and attrib_xref.AttribID = #y#) ) AND ( (attrib_xref.DocID = #x# and attrib_xref.AttribID = #y#) OR (attrib_xref.DocID = #x# and attrib_xref.AttribID = #y#) ) ) Order by attrib_xref.DocID Now that's a Kludge! David DiPietro Systems Developer / Engineer OSU College of Medicine & Public Health Voice (614) 292-5960 Fax (614) 292-0745 -Original Message- From: Dirk Sieber [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 2:02 PM To: CF-Talk Subject: SQL query question Hi everyone, Okay, I've been struggling with this one for a while, and I'm sure there's a solution, but I'm just not seeing it. I've got a collection of tables, among which are document, and attrib_xref. In the attrib_xref table, there's (among others) the following columns: DocID AttribID AttribValue Each document can have multiple attributes, so there may be many lines in this table, with the same DocID, but different AttribID/AttribValue pairs. What I'd like to be able to do is an "and" search for multiple attributes, so I'd like to be able to say that I'm looking for the document with DocID=x, where AttribID=12 and it's corresponding value is 'some text', AND where there's also a second Attrib_XRef record with DocID=x, where AttribID=24 and it's corresponding value is 'some other text' I also need this to be extensible - ie, a person may specify one attribute pair, or 2, or 3, or... etc. Any suggestions (short of re-designing the DB - that's out of my control, unfortunately). If someone can point me in the right direction, I'd really appreciate it... Thanks, Dirk __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL query question
perhaps something like this
I'm sure there is a better way but this may be a start.
HTH
Select AttribValue
>From MyTable
Where 0 = 0
And (
(MyTable.AttribID = #x# and MyTable.DocID = #y#)
OR (dbo.personnel_appointment.department_id = #x#)
)
David DiPietro
Systems Developer / Engineer
OSU College of Medicine & Public Health
Voice (614) 292-5960
Fax (614) 292-0745
-Original Message-
From: Dirk Sieber [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 29, 2002 2:02 PM
To: CF-Talk
Subject: SQL query question
Hi everyone,
Okay, I've been struggling with this one for a while, and I'm sure there's a
solution, but I'm just not seeing it.
I've got a collection of tables, among which are document, and attrib_xref.
In the attrib_xref table, there's (among others) the following columns:
DocID
AttribID
AttribValue
Each document can have multiple attributes, so there may be many lines in
this table, with the same DocID, but different AttribID/AttribValue pairs.
What I'd like to be able to do is an "and" search for multiple attributes,
so I'd like to be able to say that I'm looking for the document with
DocID=x, where AttribID=12 and it's corresponding value is 'some text', AND
where there's also a second Attrib_XRef record with DocID=x, where
AttribID=24 and it's corresponding value is 'some other text'
I also need this to be extensible - ie, a person may specify one attribute
pair, or 2, or 3, or... etc.
Any suggestions (short of re-designing the DB - that's out of my control,
unfortunately).
If someone can point me in the right direction, I'd really appreciate it...
Thanks,
Dirk
__
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Want to eliminate the Evaluate
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 to eliminate the Evaluate Yes Use form[x] Kevin -Original Message- From: David DiPietro [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 2:04 PM To: CF-Talk Subject: Want to eliminate the Evaluate There's got to be another way to do this. Any ideas? #fieldname# = #fieldValue# David DiPietro Systems Developer / Engineer OSU College of Medicine & Public Health Voice (614) 292-5960 Fax (614) 292-0745 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Want to eliminate the Evaluate
There's got to be another way to do this. Any ideas? #fieldname# = #fieldValue# David DiPietro Systems Developer / Engineer OSU College of Medicine & Public Health Voice (614) 292-5960 Fax (614) 292-0745 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT : js submit into new window...
function PopUpWindow(TargetURL, WindowName, wWidth, wHeight)
{
var newPop = window.open(TargetURL, WindowName, width='+wWidth+',
height='+wHeight+', menubar, scrollbars, resizable, status, toolbar, location');
}
*Pictures of this rotation.
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, May 16, 2002 12:43 PM
To: CF-Talk
Subject: OT : js submit into new window...
Is there a way to submit a form into a new window, on somebody else's server, and
control it's properties (size, status bars, etc)? Right now, I'm using the target
attribute in the form tag, but I'd like to have more control over the the
window...TIA->
Tyler Silcox
email | [EMAIL PROTECTED]
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: 10 records per page
-- something similar for last
Next
..I know evaluate police are around the corner
If you're looking for printing
P
{
COLOR: black;
FONT-FAMILY: Arial, Tahoma, Helvetica;
FONT-SIZE: 12pt;
FONT-STYLE: normal;
FONT-WEIGHT: normal
}
P.breakhere {page-break-before: always}
with
David DiPietro
Systems Developer / Engineer
OSU College of Medicine & Public Health
Voice (614) 292-5960
Fax (614) 292-0745
-Original Message-
From: Carlisle, Eric [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 02, 2002 1:30 PM
To: CF-Talk
Subject: RE: 10 records per page
Also...
Ultradev has some utilities built in for creating "next page, last page"
functionality for ColdFusion.
I don't use Ultradev, but that's another option.
Eric
-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 02, 2002 1:10 PM
To: CF-Talk
Subject: Re: 10 records per page
You can download one from our site http://www.quilldesign.com/qdnext
Or go to http://devex.macromedia.com/developer and do a search for next or
previous and there are a number of them in there too!
Good Luck
Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirect Commerce Builder
> I've got one... you want it?
>
> +---+
> Bryan Love
> Macromedia Certified Professional
> Internet Application Developer
> Database Analyst
> Telecommunication Systems
> [EMAIL PROTECTED]
> +---+
>
> "...'If there must be trouble, let it be in my day, that my child may have
> peace'..."
> - Thomas Paine, The American Crisis
>
>
>
> -Original Message-
> From: Will Swain [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 02, 2002 6:46 AM
> To: CF-Talk
> Subject: 10 records per page
>
>
> brain spasm going on here
>
> isn't there a custom tag for limiting the number of records outputted per
> page to 10 or whatever?
>
> can't remember the name.
>
> cheers
>
> Will
>
>
>
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Preventing IE 6 from submitting a form on click of Enter
Do what you want in my function and then document.formname.submit(); David DiPietro Systems Developer / Engineer OSU College of Medicine & Public Health Voice (614) 292-5960 Fax (614) 292-0745 -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 9:18 AM To: CF-Talk Subject: Preventing IE 6 from submitting a form on click of Enter I have tried some code on IRT .org that is supposed to prevent IE from submitting a form on hitting enter, however it is not working. Can someone shoot me a snippet of code to prevent IE from submitting on click of enter. Thanks in advance Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. [EMAIL PROTECTED] CONFIDENTIALITY NOTICE The information contained in this e-mail is intended only for the use of the individual or entity to which it is addressed. This e-mail may contain information that is privileged, confidential, and/or personal. If the reader of this message is not the intended recipient (or the employee or agent responsible to deliver it to the intended recipient), you are hereby notified that any dissemination, distribution, or copying of this communication is prohibited. If you have received this communication in error, please notify us at the email listed above. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: previous cfm page
here's a bunch of cgi's #cgi.Http_Referer# referer #cgi.HTTP_WHOIS_ID# --> OSU User #cgi.HTTP_WHOIS_ID# #cgi.Remote_Addr# #cgi.Auth_Type# Auth Type #cgi.Auth_User# Auth user #cgi.Content_Length# Con Len #cgi.Content_Type# Con Type #cgi.Document_Root# Root #cgi.GateWay_Interface# I Face #cgi.Http_Accept# accept #cgi.Http_From# From #cgi.Http_Referer# referer #cgi.Http_User_Agent# Agent #cgi.Path_Info# Path info #cgi.Path_TransLated# Path trans #cgi.Query_String# Q Str #cgi.Remote_Addr# R Addrs #cgi.Remote_Host# host #cgi.Remote_Ident# Ident #cgi.HTTP_WHOIS_ID# User #cgi.Request_Method# Method #cgi.Script_Name# Script Name #cgi.Server_Name# Server name #cgi.Server_Port# S Port #cgi.Server_Protocol# S Protocol #cgi.Server_Software# S Software David DiPietro Systems Developer / Engineer OSU College of Medicine & Public Health Voice (614) 292-5960 Fax (614) 292-0745 -Original Message- From: Ryan Pieszak [mailto:[EMAIL PROTECTED]] Sent: Friday, April 26, 2002 3:35 PM To: CF-Talk Subject: previous cfm page Hello all, Is there a cgi variable I could use to tell what page a user came from? Or maybe a way to pull that from the history through javascript? I'm trying to find out what page a user has come from when they pop onto an error page. Thank you. Ryan Pieszak Ryan J. Pieszak Applications Engineer Marker Systems, Inc. Ziphany, LLC. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Variable names in CFINPUT
Which of these is best? 1. 2. 3. 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: Friday, April 26, 2002 3:29 PM To: CF-Talk Subject: RE: Variable names in CFINPUT 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 > > > Help me out. I don't get it. > Why isn't this an evaluative action? In the strictest sense, it is - you're evaluating a variable to get a value. However, what Ray is referring to is the use of the Evaluate function, which takes a string, and evaluates this string as if it were an expression. This string evaluation done with Evaluate is relatively expensive, and in this case, unnecessary. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Variable names in CFINPUT
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 > > > Help me out. I don't get it. > Why isn't this an evaluative action? In the strictest sense, it is - you're evaluating a variable to get a value. However, what Ray is referring to is the use of the Evaluate function, which takes a string, and evaluates this string as if it were an expression. This string evaluation done with Evaluate is relatively expensive, and in this case, unnecessary. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Variable names in CFINPUT
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-
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 26, 2002 2:12 PM
To: CF-Talk
Subject: RE: Variable names in CFINPUT
> Add a counter
>
>
>
>
> SELECT #GetFields.FieldName#
> FROM #TableName#
> WHERE ID=#ID#
>
> DefaultValue=evaluate("GetValues.#GetFields.FieldName#")>
Oops, no - time for the evaluate police. To get a dynamic column/row
from a query, just do:
> value="#DefaultValue#">
>
>
===
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia
Email: [EMAIL PROTECTED]
Yahoo IM : morpheus
"My ally is the Force, and a powerful ally it is." - Yoda
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Variable names in CFINPUT
Add a counter SELECT #GetFields.FieldName# FROM #TableName# WHERE ID=#ID# 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]] Sent: Friday, April 26, 2002 12:47 PM To: CF-Talk Subject: RE: Variable names in CFINPUT take it out of the cfinput and see what it's producing -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED]] Sent: 26 April 2002 17:33 To: CF-Talk Subject: RE: Variable names in CFINPUT At 05:16 PM 4/26/02 +0100, Adrian Lynch wrote: >post more of your code please I'll have to get it from home. Basically, I have a set of variable names and values that I get from a query. So it's something like this: SELECT FieldName FROM Fields WHERE TableID=#TableID# SELECT #GetFields.FieldName# FROM #TableName# WHERE ID=#ID# I'd like it to loop through the inputs and create a form, but it gives the error about duplicate names, even though the names are different (though the variable name is the same.) T __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: javaScript (simple)
I do it this way
function confirmDuplication(type,ID)
{
var msg = "\n You are about to COPY\n\n"+
" **\n"+
" "+type+" \n" +
" **\n\n"+
"FROM: "+ID+"\n\n" +
" 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; }
}
do this
David DiPietro
Systems Developer / Engineer
OSU College of Medicine & Public Health
Voice (614) 292-5960
Fax (614) 292-0745
-Original Message-
From: Deborah Curley [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 26, 2002 7:16 AM
To: CF-Talk
Subject: javaScript (simple)
Hi all,
Anyone have the code readily available for an OnClick action to make sure a
customer wants to delete the record (i.e., click the delete button, get
prompted for whether you really want to delete and don't do the action
unless you.
TIA,
Deb
_
Chat with friends online, try MSN Messenger: http://messenger.msn.com
__
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Determining if a java applet has been loaded in JS?
How about something like this at the end of the page
var aExists = 0;
function checkForApplet(thisApplet)
{
if(aExists != 1)
{
if(thisApplet)
{
aExists = 1;
break();
}
}
}
setInterval("checkForApplet('appletName')",3000);
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: CF-Talk
Subject: RE: Determining if a java applet has been loaded in JS?
I am sure that there is nothing vanilla with .js and browser which
uniquely identifies how much of the applet byte code has been loaded at
the loading time of the applet.
One solution would be to have two applets: one the continous progress
bar applet, and the other the actual applet. Once the actual applet is
loaded completely in the init() method of the applet you will have to
communicate to the other progress bar applet that the actual applet is
completely loaded and now it should stop showing the status "Loading
completed.."
The applet tag doesn't have an onLoad event handler, Its possible in
Netscape provided you are willing to tweak the Java applet's code to
call JavaScript using the JSObject of Netscape. Doesn't sound very
practical to be of any use though.
The JavaScript code can however look for the existence of the applets
array. It gets populated when the applet is loaded. The JS code can poll
for the loading status of the applet this way. But there's no event
driven mechanism to achieve the same that I can think of.
N
__
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Determining if a java applet has been loaded in JS?
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-
From: Shawn Grover [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 25, 2002 4:01 PM
To: CF-Talk
Subject: OT: Determining if a java applet has been loaded in JS?
we have a case where a java applet may take a few seconds to load, but need
to use JS to set/adjust the applet when the page loads. We are finding that
sometimes the JS code will execute before the applet has been loaded,
therefore causing errors (cuz the applet doesn't exist yet).
We have toyed with the idea of building in a delay on our page before this
initialization code runs, but have decided that this is not a good idea.
How long should the delay be? What if the user is on a 28.8 modem? or a DSL
line? the delay would need to change.
So, we are looking for ideas/methods on how to check if the applet has
infact loaded before doing any processing. We think something like:
if (document.all.AppletName) { do something }
But are not sure if this reference to the applet would cause an error if the
applet isn't loaded yet.
Are there any other methods? Thanks in Advance.
Shawn Grover
__
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: At my new job
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 (614) 292-0745 -Original Message- From: Bill Wheatley [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 11:00 AM To: CF-Talk Subject: At my new job Well i'm now settled in at my new job :) WHOO HOO!! After my boss tried to have me arrested for "HACKING" his servers and all that was fun my old boss was a threatster :) OK OK now to the point i need to find a win32 textbased editor that does not have to load the whole damn file into memory first. I remember it being on here before so i'm curious. Any help would be appreciated! Bill Wheatley Senior Database Developer Ediets.com Macromedia Certified Coldfusion Developer 954.360.9022 X159 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Set focus on a CFINPUT field
Try setting it through a function.
That is how I do onload events.
function focusme()
{
document.PracticeDetail.PName.focus();
}
-Original Message-
From: Larry Juncker [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 10:52 AM
To: CF-Talk
Subject: Set focus on a CFINPUT field
Can someone point me to how to properly set focus on a CFINPUT field?
I have tried document.FORMNAME.FIELDNAME.focus();
and it just does not acknowledge the code.
document.FORMNAME.FIELDNAME.VALUE will give me the preset value that I set for
the field.
Thanks in Advance
Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.
[EMAIL PROTECTED]
CONFIDENTIALITY NOTICE
The information contained in this e-mail is intended only for the use of the
individual or entity to which it is addressed. This e-mail may contain
information that is privileged, confidential, and/or personal. If the reader of
this message is not the intended recipient (or the employee or agent responsible
to deliver it to the intended recipient), you are hereby notified that any
dissemination, distribution, or copying of this communication is prohibited.
If you have received this communication in error, please notify us at the email
listed above.
__
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL insanity...
perhaps something like this would work
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
Inner join sermons on sermons_details.sermon_num = sermons.ID
Inner join speakers on sermons.speaker = speakers.full_name
WHERE sermons_details.date_stamp >= #Last30Days#
AND sermons_details.subject = 'SERMONACCESS'
GROUP BY sermons_details.sermon_num, sermons.title, sermons.tape, sermons.name,
speakers.initials,sermons.size
ORDER BY count(sermons_details.sermon_num) DESC
OR...
You could drop the group by
Then for output
some code
-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:
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 INNER JOIN sermons
ON sermons_details.sermon_num = sermons.tape)
INNER JOIN speakers ON sermons.speaker = speakers.full_name
WHERE sermons_details.date_stamp >= #Last30Days#
AND sermons_details.subject = 'SERMONACCESS'
GROUP BY sermons_details.sermon_num
ORDER BY count(sermons_details.sermon_num) DESC
..and I got this error:
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that
does not include the specified expression 'title' as part of an aggregate
function.
ideas?
David
David Grabbe
Manager, Information Systems
Church of the Great God
[EMAIL PROTECTED]
http://www.cgg.org
-Original Message-
From: Brian Scandale [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 3:32 PM
To: CF-Talk
Subject: Re: SQL insanity...
Why not do a join... something like this I expect...
>
>SELECT sermons_details.sermon_num,
count(sermons_details.sermon_num) AS
>tally
sermons.title etc, speakers.initials
>FROM sermons_details
JOIN sermons ON sermons_details.sermon_num = sermons.sermon_num
JOIN speakers ON sermons.speaker = speaker.full_name
>WHERE sermons_details.date_stamp >= #Last30Days#
>AND sermons_details.subject = 'SERMONACCESS'
>GROUP BY sermons_details.sermon_num
>ORDER BY count(sermons_details.sermon_num) DESC
>
>
>This counts up the number of detail records, and orders them. Works like a
At 03:07 PM 4/17/02 -0400, you wrote:
>I need some help from your SQL gurus out there :)
>
>Here's the deal: we are keeping a running tally of the sermons which have
>been downloaded the most over the past 30 days. Every time a sermon is
>downloaded, I write a record out to a sermons_details table, where the
>primary key is the sermon number. This is working fine:
>
>
>
>
>SELECT sermons_details.sermon_num,
count(sermons_details.sermon_num) AS
>tally
>FROM sermons_details
>WHERE sermons_details.date_stamp >= #Last30Days#
>AND sermons_details.subject = 'SERMONACCESS'
>GROUP BY sermons_details.sermon_num
>ORDER BY count(sermons_details.sermon_num) DESC
>
>
>This counts up the number of detail records, and orders them. Works like a
>champ. The difficulty comes in when I try to get the info from the header
>record for each sermon:
>
>
>SELECT sermons.title, sermons.tape, sermons.name,
speakers.initials,
>sermons.size
>FROM sermons, speakers
>WHERE tape IN ('#sermon_num#'nums.currentrow LT 5>,)
>AND sermons.size > 0 --->
>AND speakers.full_name = sermons.speaker
>
>
>This gets the right info, but now the ordering is off -- the second query
>isn't ordered according to which sermon was downloaded most.
>
>I'm assuming there is a way to do all of this with a single query, but so
>far I haven't been able to figure it out. Oh yeah, I'm (still) using
>Access2000, so the functionality of the DB is a bit limited too. Ideas?
>
>TIA,
>David
>
>
>David Grabbe
>Manager, Information Systems
>Church of the Great God
>[EMAIL PROTECTED]
>http://www.cgg.org
>
>
>
__
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL insanity...
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:
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 INNER JOIN sermons
ON sermons_details.sermon_num = sermons.tape)
INNER JOIN speakers ON sermons.speaker = speakers.full_name
WHERE sermons_details.date_stamp >= #Last30Days#
AND sermons_details.subject = 'SERMONACCESS'
GROUP BY sermons_details.sermon_num
ORDER BY count(sermons_details.sermon_num) DESC
..and I got this error:
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that
does not include the specified expression 'title' as part of an aggregate
function.
ideas?
David
David Grabbe
Manager, Information Systems
Church of the Great God
[EMAIL PROTECTED]
http://www.cgg.org
-Original Message-
From: Brian Scandale [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 3:32 PM
To: CF-Talk
Subject: Re: SQL insanity...
Why not do a join... something like this I expect...
>
>SELECT sermons_details.sermon_num,
count(sermons_details.sermon_num) AS
>tally
sermons.title etc, speakers.initials
>FROM sermons_details
JOIN sermons ON sermons_details.sermon_num = sermons.sermon_num
JOIN speakers ON sermons.speaker = speaker.full_name
>WHERE sermons_details.date_stamp >= #Last30Days#
>AND sermons_details.subject = 'SERMONACCESS'
>GROUP BY sermons_details.sermon_num
>ORDER BY count(sermons_details.sermon_num) DESC
>
>
>This counts up the number of detail records, and orders them. Works like a
At 03:07 PM 4/17/02 -0400, you wrote:
>I need some help from your SQL gurus out there :)
>
>Here's the deal: we are keeping a running tally of the sermons which have
>been downloaded the most over the past 30 days. Every time a sermon is
>downloaded, I write a record out to a sermons_details table, where the
>primary key is the sermon number. This is working fine:
>
>
>
>
>SELECT sermons_details.sermon_num,
count(sermons_details.sermon_num) AS
>tally
>FROM sermons_details
>WHERE sermons_details.date_stamp >= #Last30Days#
>AND sermons_details.subject = 'SERMONACCESS'
>GROUP BY sermons_details.sermon_num
>ORDER BY count(sermons_details.sermon_num) DESC
>
>
>This counts up the number of detail records, and orders them. Works like a
>champ. The difficulty comes in when I try to get the info from the header
>record for each sermon:
>
>
>SELECT sermons.title, sermons.tape, sermons.name,
speakers.initials,
>sermons.size
>FROM sermons, speakers
>WHERE tape IN ('#sermon_num#'nums.currentrow LT 5>,)
>AND sermons.size > 0 --->
>AND speakers.full_name = sermons.speaker
>
>
>This gets the right info, but now the ordering is off -- the second query
>isn't ordered according to which sermon was downloaded most.
>
>I'm assuming there is a way to do all of this with a single query, but so
>far I haven't been able to figure it out. Oh yeah, I'm (still) using
>Access2000, so the functionality of the DB is a bit limited too. Ideas?
>
>TIA,
>David
>
>
>David Grabbe
>Manager, Information Systems
>Church of the Great God
>[EMAIL PROTECTED]
>http://www.cgg.org
>
>
>
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: survey trouble
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: survey trouble wouldn't this mandate a table to store totals for each question? -Original Message- From: James Maltby [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 9:17 AM To: CF-Talk Subject: RE: survey trouble What about giving each a letter value = e.g. Strong A = A Agree = B Neutral = C Etc. Then on "landing" page converting the "val" via a "switch" statement into a value and inserting it into the database. UPDATE table SET Valcolumn_A = Valcolumn_A + 1 SET Valcolumn_B = Valcolumn_B + 1 SET Valcolumn_C = Valcolumn_C + 1 Etc. I think this should work, but it may be worth a try - mainly due to being a little flaky inside J -Original Message- From: Craig Thomas [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 14:04 To: CF-Talk Subject: survey trouble I am having trouble creating a 'simple' survey with answers like the following: 'Strongly Agree' 'Agree' 'Neutral' 'Disagree' 'Strongly Disagree' I cannot conceptualize how to store and make sense of the answers without a huge amount of code. We do not care to record individual answers (but will/can), but want to know how many people agree/disagree with each question. (There are 10 questions.) All the questions have the same possible answers. Any help is greatly appreciated, Craig Thomas www.worldcupbicycles.com __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Wrapping Text
Alternately (if HTML)
Put it in a table
#yourText#
No one sees the tables and you have a 20px margin on your page
This will wrap the text without having to figure out what the last word
is and assuring that it doesn't break in the middle of the word without
having to search for the nearest space etc...
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 11, 2002 2:20 PM
To: CF-Talk
Subject: RE: Wrapping Text
Function to wrap a string before a specific number of characters.
function WrapText(string, count){
var start = 1;
var stringlen = len(string);
while(start LTE stringlen){
newstring = reverse(trim(mid(string, start,
count)));
spaceat = refind("[[:space:]]", newstring, start);
where = start + (count - spaceat);
if(where LTE stringlen){string = insert("",
string, where);}
amount = count - spaceat;
if(amount EQ 0){amount = count;}
start = start + amount;
}
return string;
}
#WrapText(string, 90)#
Anthony Petruzzi
Webmaster
954-321-4703
[EMAIL PROTECTED]
http://www.sheriff.org
-Original Message-
From: Greg [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 11, 2002 2:05 PM
To: CF-Talk
Subject: Wrapping Text
I'm trying to get a long text string to wrap properly in a printable
report. Anyone have a graceful way of finding the last space before a
certain character, say 90? Also, I could use fixedsys font to be sure
that 90 is always a good wrapping point. Is that the best option?
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC and cvs files
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 The user then clicks the form button and it appears HIH David -Original Message- From: Mario Martinez R. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 1:49 PM To: CF-Talk Subject: ODBC and cvs files Hi friends: I'm trying to make a query from a csv file (test1.csv). The way I thought was to make an ODBC entry for text files . In the ODBC entry I only can specify the directory not the file name. So I guessed I had to include that in the final query. There is something I'm missing . I will appreciate your help.Any new ideas could be great too. Down the code and what I see in my browser . Thanks for any help Mario //my code SELECT * FROM test1.cvs //What I get in my browser Error Diagnostic Information ODBC Error Code = 42000 (Syntax error or access violation) [Microsoft][ODBC Text Driver] Cannot update. Database or object is read-only. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (199:1) to (199:75). Date/Time: 03/11/02 12:20:20 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 66.109.35.50 _ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias. Visítanos en http://noticias.espanol.yahoo.com __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: ODBC and cvs files
This is how I do it The user then clicks the form button and it appears HIH David -Original Message- From: Mario Martinez R. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 09, 2002 1:49 PM To: CF-Talk Subject: ODBC and cvs files Hi friends: I'm trying to make a query from a csv file (test1.csv). The way I thought was to make an ODBC entry for text files . In the ODBC entry I only can specify the directory not the file name. So I guessed I had to include that in the final query. There is something I'm missing . I will appreciate your help.Any new ideas could be great too. Down the code and what I see in my browser . Thanks for any help Mario //my code SELECT * FROM test1.cvs //What I get in my browser Error Diagnostic Information ODBC Error Code = 42000 (Syntax error or access violation) [Microsoft][ODBC Text Driver] Cannot update. Database or object is read-only. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (199:1) to (199:75). Date/Time: 03/11/02 12:20:20 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 66.109.35.50 _ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias. Visítanos en http://noticias.espanol.yahoo.com __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Announcement: New Flash MX component
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 This is a little OT, but I'm very excited to be able to announce the introduction of a new Flash MX component. Everyone's been hearing from MM about how Flash MX will save the world; here's a little demonstration. "DaVinci" is a component that can be used by itself, or within a larger Flash application, for capturing user input in a way that would be, well, difficult with just HTML. "Fig Leaf Software Announces 'DaVinci' 'DaVinci' is the first of a series of Flash MX components being developed by Fig Leaf Software. Using DaVinci, you can add image annotation capabilities to your web-based applications. End-users may add lines, text, scribbles, and other geometric forms that sit in layers on top of a background JPEG image. The vector drawings are represented as XML and can be saved into a database for future reference. The component can be dropped into any HTML-based web page, or included as part of a complete Flash MX solution. Because the component was developed using Flash MX from Macromedia, it is cross-browser compatible with any device running the Flash 6 player. Fig Leaf Software will soon begin soliciting feedback from beta testers. If you want to join the beta, or get more information, go to http://davinci.figleaf.com"; Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
