Re: Maintaining the order of HTML tags atrributes.
So on database storage Replace(theString,table,tableplaceholder, ALL), then on output Replace(theStringFromDbase, tableplaceholder, table, ALL)something like that anyway..a bit of a hack but it might save you the hassle till you find something more suitable... Jide. Thanks Jide should have thought of that.. Guys, both didn't work, XStandard is a very cool editor but didn't do the trick. The place holder Jide suggested is fine on initial entry into the database but once it's loaded again for subsequent edits the browser again re orders the atrributes There has got to be a way to re order/maintain HTML attributes...anyone? Thanks, Matt ~| 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:323017 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF7 - Error Trapping CFCs
I have a web application utilizing CF7 and within the Application.cfc file, I have a function called onError to handle the error trapping. This works find for the simple errors but if an error occurs in a CFC, it is not trapped. I have the three error types specified as: cferror type=exception template=/errors/fullhandler.cfm cferror type=request template=/errors/fullhandler.cfm cferror type=validation template=/errors/fullhandler.cfm How can I trap CFC errors (other tran wrapping EACH cfc invoke call with a CFTR/CATCH routine? ~| 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:323018 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF7 - Error Trapping CFCs
What does your onError look like? On Mon, Jun 1, 2009 at 6:09 AM, ColdFusion Developer cfdev2...@gmail.com wrote: I have a web application utilizing CF7 and within the Application.cfc file, I have a function called onError to handle the error trapping. This works find for the simple errors but if an error occurs in a CFC, it is not trapped. I have the three error types specified as: cferror type=exception template=/errors/fullhandler.cfm cferror type=request template=/errors/fullhandler.cfm cferror type=validation template=/errors/fullhandler.cfm How can I trap CFC errors (other tran wrapping EACH cfc invoke call with a CFTR/CATCH routine? ~| 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:323019 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF7 - Error Trapping CFCs
*** Disregard *** I tracked it down to being an issue within the error handler itself. For some reason it does not like the statement: cfif IsStruct(error).. blah blah/cfif It was barking that the variable ERROR does not exists, even though (correct me if I am wrong) but would be a structure of the error data? On Mon, Jun 1, 2009 at 7:43 AM, Raymond Camden rcam...@gmail.com wrote: What does your onError look like? ** Di On Mon, Jun 1, 2009 at 6:09 AM, ColdFusion Developer cfdev2...@gmail.com wrote: I have a web application utilizing CF7 and within the Application.cfc file, I have a function called onError to handle the error trapping. This works find for the simple errors but if an error occurs in a CFC, it is not trapped. I have the three error types specified as: cferror type=exception template=/errors/fullhandler.cfm cferror type=request template=/errors/fullhandler.cfm cferror type=validation template=/errors/fullhandler.cfm How can I trap CFC errors (other tran wrapping EACH cfc invoke call with a CFTR/CATCH routine? ~| 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:323020 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF7 - Error Trapping CFCs
Using application.cfc, you can use the OnError method, ie. cffunction name=OnError access=public returntype=void output=true hint=Fires when an exception occures that is not caught by a try/catch block cfargument name=Exception type=any required=true / cfargument name=EventName type=string required=false default= / cfmodule template=/errors/fullhandler.cfm exception=#arguments.exception# eventname=#arguments.eventname# /!--- or just a cfinclude will do fine --- /cffunction 2009/6/1 ColdFusion Developer cfdev2...@gmail.com: I have a web application utilizing CF7 and within the Application.cfc file, I have a function called onError to handle the error trapping. This works find for the simple errors but if an error occurs in a CFC, it is not trapped. I have the three error types specified as: cferror type=exception template=/errors/fullhandler.cfm cferror type=request template=/errors/fullhandler.cfm cferror type=validation template=/errors/fullhandler.cfm How can I trap CFC errors (other tran wrapping EACH cfc invoke call with a CFTR/CATCH routine? ~| 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:323021 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
IUM Re: IUM Re: IUM Re: Google Map API
Excellent .. thanks Ryan, will let you know how I get on with that, looks
straightforward!
Jenny
-Original Message-
From: Ryan Letulle [mailto:bayous...@gmail.com]
Sent: 30 May 2009 20:03
To: cf-talk
Subject: SPAM-MEDIUM Re: IUM Re: IUM Re: Google Map API
This what I do. Hope it helps:
!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Strict//EN
http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd;
html xmlns=http://www.w3.org/1999/xhtml;
xmlns:v=urn:schemas-microsoft-com:vml
head
meta http-equiv=content-type content=text/html; charset=UTF-8/
script
src=http://maps.google.com/maps?file=apiamp;v=2.xamp;key=cfoutput#reque
st.gmapkey#/cfoutput
type=text/javascript/script
script type=text/javascript
var map = null;
var geocoder = null;
function initialize() {
if (GBrowserIsCompatible()) {
map = new GMap2(document.getElementById(map_canvas));
map.setCenter(new GLatLng(40.78704, -73.965797), 13);
map.setUIToDefault()
geocoder = new GClientGeocoder();
}
}
function showAddress(address) {
if (geocoder) {
geocoder.getLatLng(
address,
function(point) {
if (!point) {
alert(address + not found);
} else {
map.setCenter(point, 13);
var marker = new GMarker(point);
map.addOverlay(marker);
marker.openInfoWindowHtml(address);
}
}
);
}
}
/script
/head
body
onload=initialize();showAddress(document.getElementById('geo').address.valu
e);
return false onunload=GUnload()
cftry
form id=geo action=# onsubmit=showAddress(this.address.value);
return false
p
cfparam name=url.address default=414 East 88th Street, New York
input type=hidden size=50 name=address
value=cfoutput#listfirst(url.address)#, New York/cfoutput /
!---
input type=submit value=Show Map /
---
/p
div id=map_canvas style=width: 400px; height: 500px/div
/form
cfcatch/cfcatch
/cftry
/body
/html
--
Ryan
On Sat, May 30, 2009 at 7:50 AM, Jenny Gavin-Wear
jenn...@fasttrackonline.co.uk wrote:
Hi Ryan,
I looked at the page again in firefox using the Javascript error console
script
src=
http://maps.google.com/maps?file=apiamp;v=2amp;key=#session.GoogleKey
#
type=text/javascript/script
script type=text/javascript
//![CDATA[
function load() {
if (GBrowserIsCompatible()) {
var map = new GMap2(document.getElementById(map));
map.setCenter(new GLatLng(#dLatitude#, #dLongitude#), 14);
map.addControl(new GLargeMapControl());
map.centerAndZoom(new GPoint(#dLatitude#, #dLongitude#),
3);
var point = new GPoint(#dLatitude#, #dLongitude#);
var marker = new GMarker(point);
map.addOverlay(marker);
}
}
//]]
/script
The line:
map.centerAndZoom(new GPoint(#dLatitude#, #dLongitude#), 3);
gives the error:
map.centerAndZoom is not a function
I removed this line assuming if it was bad the script would stop
processing
at this point, but still no marker.
Jenny
-Original Message-
From: Ryan Letulle [mailto:bayous...@gmail.com]
Sent: 28 May 2009 14:06
To: cf-talk
Subject: SPAM-MEDIUM Re: IUM Re: Google Map API
I assume you are not getting any javascript errors?
--
Ryan
~|
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:323022
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Maintaining the order of HTML tags atrributes.
Maybe I am missing something here, but why not just use the order that FCKEditor uses? Then once it is save from FCKEditor, it would be in the order that you want it. You know there is no way to modify FCKEditor's behavior, so why not just make use of it as a known value? Eric On Mon, Jun 1, 2009 at 2:47 AM, Matthew Allen a.matthe...@yahoo.com wrote: So on database storage Replace(theString,table,tableplaceholder, ALL), then on output Replace(theStringFromDbase, tableplaceholder, table, ALL)something like that anyway..a bit of a hack but it might save you the hassle till you find something more suitable... Jide. Thanks Jide should have thought of that.. Guys, both didn't work, XStandard is a very cool editor but didn't do the trick. The place holder Jide suggested is fine on initial entry into the database but once it's loaded again for subsequent edits the browser again re orders the atrributes There has got to be a way to re order/maintain HTML attributes...anyone? Thanks, Matt ~| 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:323023 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
AddSOAPRequestHeader
I'm trying to consume a webservice that expects: soap:Header ApiUserAuthHeader xmlns=namespace UserNamex/UserName Passwordx/Password UserAccessKey/UserAccessKey /ApiUserAuthHeader /soap:Header ...so I wrote: cfset ApiUserAuthHeader = StructNew() cfset ApiUserAuthHeader.UserAccessKey = x cfset ApiUserAuthHeader.Password = x cfset ApiUserAuthHeader.UserName = x cfset AddSOAPRequestHeader(MyWebservice, namespace, ApiUserAuthHeader, ApiUserAuthHeader) ...but this generates: soapenv:Header ns1:ApiUserAuthHeader xmlns:ns1=namespace item xmlns:ns2=http://xml.apache.org/xml-soap; key xsi:type=xsd:stringPASSWORD/key value xsi:type=xsd:stringx/value /item item key xsi:type=xsd:stringUSERNAME/key value xsi:type=xsd:stringx/value /item item key xsi:type=xsd:stringUSERACCESSKEY/key value xsi:type=xsd:stringx/value /item /ns1:ApiUserAuthHeader /soapenv:Header How do I emulate the header that the webservice is expecting? -- John Bliss IT Professional LinkedIn: http://www.linkedin.com/in/jbliss ~| 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:323024 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
mx7 debugger
Hi,
I am getting the following error on the debugger tab in IE7 and Firefox when I
use cfform in a page instead of just form. None of the debugging details
are available when this happens.
Error from Firebug:
unterminated string literal
[Break on this error] document.write('headtitleCol...ascript
src=/CFIDE/scripts/cfform.js
Displayed on debugger tab:
'); } } function writeCloseBody() { if( debugMode ) { document.write(''); } }
//== TREE STATE ==
function setCookie( targetName, value ) { var cookieValue = targetName + = +
escape(value); var exp = new Date(); var nowPlus30Days = exp.getTime() + (30 *
24 * 60 * 60 * 1000); exp.setTime( nowPlus30Days ); document.cookie =
cookieValue + ; expires= + exp.toGMTString() + ;; } function
getCookieValue( name ) { var thisCookie = document.cookie.split(; ) for( i=0;
i ColdFusion MX Debugging
thanks for any help,
Mike
~|
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:323025
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Maintaining the order of HTML tags atrributes.
Maybe I am missing something here, but why not just use the order that FCKEditor uses? Then once it is save from FCKEditor, it would be in the order that you want it. You know there is no way to modify FCKEditor's behavior, so why not just make use of it as a known value? Eric That was the first thing that came to my mind but the source file displays attributes randomly depending on what browser is used by the editor, to add to the complexity the source file is from an external source (XML), so I'm stripping the required text from the source file into the database using xpath, it is the database content that are edited then compared with the content in the xml file to see what was changed. Whichever route I go e.g. changing the atrributes order in the original xml file, I need to have control over the HTML attributes. Matt ~| 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:323026 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Maintaining the order of HTML tags atrributes.
Well this may sound goofy, and if it's a bad idea, say so... But why not use a RegEx to pull the table tag out of both bits of content, then scan over using list functions, using a space as a delimeter to start, then = as the secondary delimeter, build up a structure of attributes and their values for both sides then just loop over the key lists and compare values? ~| 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:323027 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Authentication with Active Directory
Thanks Judah. Our DBAs want to eliminate the generic account that I have my datasources setup with. Like you mentioned, they want to control users access at the DB level. Does CF8 support passing users credentials using integrated security? I think my only option, like you mentioned is to handle the security at the application level but the generic account will still have to exist on the DB server. I think that Dave has basically answered your question but I'll toss out the notion that if it was acceptable in your environment you could do the same sort of permissions but at the application level instead of the db. CF can do authentication with Active Directory via the CFLDAP tag. You could fetch a list of permissions and then proxy the calls to the db and only allow certain queries involving your sprocs and views to people with sufficient privileges. Though it is functionally equivalent to what you are talking about, it may be that they want the roles and permissions enforced down at the SQL Server level. There are some good reasons to do so and then there are some reasons that, well, that's just how an organization has always done it and isn't changing now. Anyway, if you are investigating CF talking to Active Directory, start with the CFLDAP tag. Take care, Judah ~| 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:323028 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Help ColdFusion Output URGENT
I have a query which list all the Team members, their Area MANagers, Region
Managers, Locations and so on .
What i need to do is to display each managers(name)
column2: total number of people in their area
column3: and total number of people completed the course in the area
I came up with code but does not seems to work now
query:
cfquery name=getCareManagers datasource=XX
Select distinct e.employeeid, e.last_name,
er.last_name as erLastName, er.first_name as erFirstName, er.EMployeeID
as REID,
ea.last_name as eaLastName, ea.first_name as eaFirstName,
l.name as locname, l.locationID,ea.Employeeid as
AEID!---,et.CompletionDate---
from employee e
join employeejobhistory h on h.employeeid =
e.employeeid
!--- left outer join EmployeeTraining et on (et.EmployeeID =
e.employeeID andet.COurseID = 1661)---
inner join jobassignment ja on (ja.sequence
= h.sequence)
inner join jobcode_list j on
j.jobcode = h.jobcode
inner join location l on
l.locationid = ja.locationid
inner join area a on
a.areaid = l.areaid
inner join employee ea on ea.employeeid =
a.managerEmpID
inner join region r on r.regionid =
a.regionid
inner join employee er on er.employeeid =
r.managerEmpID
where ja.EndDate is NULL cfif isDefined(form.RC)
and form.RC eq 0and (h.JobCode in ('1024','1005','1059','1009','1014','1001')
and h.DeptName like 'Reminiscence%')cfelseif isDefined(form.RC) and form.RC
eq 1and (h.JobCode in ('1025') and h.DeptName like 'Reminiscence%')
cfelseand (h.JobCode in ('1024','1005','1059','1009','1014','1001','1025')and
h.DeptName like 'Reminiscence%')/cfifand
ja.EmplRcd = 0 and r.ManagerEmpID in
(#SESSION.Admin_Reports_locregmanager#)
order by REID,AEID,l.locationID
/cfquery
The code is below :
table border=1 width=50% align=center
tr
thArea/th
th width=36%Total Number of
people/th
thTotal Employees
Completed/th
th% Completed/th
/tr
cfset lastEmp=''
cfset RegionTotal =0
cfset RegionComplete=0
cfset AreaComplete=0
cfset AreaTotal = 0
cfset lastArea=''
cfset LocationComplete = 0
cfset LocationTotal = 0
cfset lEmp = ''
cfset lastLoc =''
cfset percent2= 0
cfoutput query=getCareManagers
cfset
AreaLastName=getCareManagers.eaLastName
cfset
AreaFirstName=getCareManagers.eaFirstName
cfquery name=getCompletion
datasource=cfelsunrise
Select completionDate from
EmployeeTraining where courseID = 1661 and EmployeeID =
#getCareManagers.EmployeeID#
/cfquery
cfif lastArea is not AEID
cfset AreaTotal = AreaTotal +
1
cfif
isDate(getCompletion.CompletionDate)
cfset
AreaComplete = AreaComplete + 1
/cfif
cfset percent2=(AreaComplete/AreaTotal)*100
tr bgcolor=##AFD8D8
td
align=leftstrong#AreaLastName#,#AreaFirstName#/strong/td
td align=centerfont size=3#AreaTotal#/td
td align=centerfont size=3#AreaComplete#/td
td align=centerfont
Locking Issue - Read value from APPLICATION scope write it to SESSION scope
Having a brain cramp on this one guys... How would one approach locking when reading a value from the APPLICATION scope and subsequently writing it to the SESSION scope..? EXAMPLE -- cfset session.foo = application.bar ~| 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:323030 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Locking Issue - Read value from APPLICATION scope write it to SESSION scope
Having a brain cramp on this one guys... How would one approach locking when reading a value from the APPLICATION scope and subsequently writing it to the SESSION scope..? EXAMPLE -- cfset session.foo = application.bar It depends. What version of CF is this? Is there any likelihood of a race condition with Application.bar? If there is the likelihood of a race condition with that variable, do I care? That is, could the race condition cause an improper value of any significance? Is there any likelihood of a race condition with Session.foo? If there is, do I care? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:323031 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
re: Locking Issue - Read value from APPLICATION scope write it to SESSION scope
Assuming you're on CFMX 7 or 8, you no longer need to LOCK on READ, so if you're concerned about race conditions on the WRITE, just do: cflock scope=session type=EXCLUSIVE timeout=10 cfset session.foo = application.bar /cflock (timeout can be whatever is appropriate) ~| 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:323032 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Locking Issue - Read value from APPLICATION scope write it to SESSION scope
Is there any reason you can't simply lock the app scope, grab application variable and put it into a local variable, unlock, lock session, copy from local var to session var, unlock? ~| 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:323033 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Query Modification
Hi! I have an ORACLE stored proc returning a query back to my CFC using CFProcResult. I pass this query up to Flex and some other places. Works fine but What I'd like to do is remove a column or two before I pass it on. Selected columns are only needed by the CFC so I'd like to remove them and clean up the query before I send it on. I can't find any way to delete a column in the docs and I really don't want to loop over the query or do a query of queries. Is the some other way to delete a column? Maybe via Java? Thanks! Warren Koch ~| 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:323034 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
re: Help ColdFusion Output URGENT
You could do it better with aggregate functions, but this will work, too.
Just make the completionDate lookup part of your base query (note the LEFT
OUTER JOIN), and then use the GROUP attribute of the CFOUTPUT tag to do the
looping for you in one go:
cfquery name=getCareManagers datasource=XX
Select distinct e.employeeid,
e.last_name,
er.last_name as erLastName,
er.first_name as erFirstName,
er.EMployeeID as REID,
ea.last_name as eaLastName,
ea.first_name as eaFirstName,
l.name as locname,
l.locationID,
ea.Employeeid as AEID,
et.completionDate
from employee e join
employeejobhistory h on h.employeeid = e.employeeid inner join
jobassignment ja on (ja.sequence = h.sequence) inner join
jobcode_list j on j.jobcode = h.jobcode inner join
location l on l.locationid = ja.locationid inner join
area a on a.areaid = l.areaid inner join
employee ea on ea.employeeid = a.managerEmpID inner join
region r on r.regionid = a.regionid inner join
employee er on er.employeeid = r.managerEmpID LEFT OUTER JOIN
employeeTraining et ON e.employeeID = et.employeeID
AND et.courseID = 1661
where ja.EndDate is NULL
cfif isDefined(form.RC) and form.RC eq 0
and h.JobCode in ('1024','1005','1059','1009','1014','1001')
and h.DeptName like 'Reminiscence%'
cfelseif isDefined(form.RC) and form.RC eq 1
and h.JobCode in ('1025')
and h.DeptName like 'Reminiscence%'
cfelse
and h.JobCode in
('1024','1005','1059','1009','1014','1001','1025')
and h.DeptName like 'Reminiscence%'
/cfif
and ja.EmplRcd = 0
and r.ManagerEmpID in (#SESSION.Admin_Reports_locregmanager#)
order by REID, AEID, l.locationID
/cfquery
table border=1 width=50% align=center
tr
thArea/th
th width=36%Total Number of people/th
thTotal Employees Completed/th
th% Completed/th
/tr
cfoutput query=getCareManagers group=AEID
cfset AreaTotal = 0 /
cfset AreaComplete = 0 /
cfoutput
cfset AreaTotal = AreaTotal + 1 /
cfif isDate(completionDate)
cfset AreaComplete = AreaComplete + 1 /
/cfif
cfset percent2 = AreaComplete / AreaTotal * 100 /
tr bgcolor=##AFD8D8
td align=leftstrong#AreaLastName#,
#AreaFirstName#/strong/td
td align=centerfont size=3#AreaTotal#/td
td align=centerfont size=3#AreaComplete#/td
td align=centerfont size=3b
style=color:##FF8000#NumberFormat(percent2, 0.00)#%b/td
/tr
/cfoutput
/cfoutput
/table
~|
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:323035
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Help ColdFusion Output URGENT
Come on dude, you've been told before, help us by asking better questions!
What doesn't work?
Format your code so it's easy for us to see what's going on, I can't be
bothered to look through your code because it's all over the place.
If the query is correct and the problem lies in the output, why include the
big ol' query?
Oh and... why oh why do you put 'urgent' in the subject line, it's not
urgent to me?!
Adrian
-Original Message-
From: erik tom [mailto:erik.tso...@jhu.edu]
Sent: 01 June 2009 19:18
To: cf-talk
Subject: Help ColdFusion Output URGENT
I have a query which list all the Team members, their Area MANagers,
Region Managers, Locations and so on .
What i need to do is to display each managers(name)
column2: total number of people in their area
column3: and total number of people completed the course in the area
I came up with code but does not seems to work now
query:
cfquery name=getCareManagers datasource=XX
Select distinct e.employeeid, e.last_name,
er.last_name as erLastName, er.first_name as erFirstName,
er.EMployeeID as REID,
ea.last_name as eaLastName, ea.first_name as eaFirstName,
l.name as locname, l.locationID,ea.Employeeid as AEID!---
,et.CompletionDate---
from employee e
join employeejobhistory h on h.employeeid
= e.employeeid
!--- left outer join EmployeeTraining et on (et.EmployeeID =
e.employeeID andet.COurseID = 1661)---
inner join jobassignment ja on
(ja.sequence = h.sequence)
inner join jobcode_list j
on j.jobcode = h.jobcode
inner join location l
on l.locationid = ja.locationid
inner join area a
on a.areaid = l.areaid
inner join employee ea on
ea.employeeid = a.managerEmpID
inner join region r on
r.regionid = a.regionid
inner join employee er on
er.employeeid = r.managerEmpID
where ja.EndDate is NULL cfif
isDefined(form.RC) and form.RC eq 0and (h.JobCode in
('1024','1005','1059','1009','1014','1001') and h.DeptName like
'Reminiscence%')cfelseif isDefined(form.RC) and form.RC eq 1and
(h.JobCode in ('1025') and h.DeptName like 'Reminiscence%') cfelseand
(h.JobCode in ('1024','1005','1059','1009','1014','1001','1025')and
h.DeptName like 'Reminiscence%')/cfifand
ja.EmplRcd = 0 and r.ManagerEmpID in
(#SESSION.Admin_Reports_locregmanager#)
order by REID,AEID,l.locationID
/cfquery
The code is below :
table border=1 width=50% align=center
tr
thArea/th
th width=36%Total
Number of people/th
thTotal Employees
Completed/th
th% Completed/th
/tr
cfset lastEmp=''
cfset RegionTotal =0
cfset RegionComplete=0
cfset AreaComplete=0
cfset AreaTotal = 0
cfset lastArea=''
cfset LocationComplete = 0
cfset LocationTotal = 0
cfset lEmp = ''
cfset lastLoc =''
cfset percent2= 0
cfoutput query=getCareManagers
cfset
AreaLastName=getCareManagers.eaLastName
cfset
AreaFirstName=getCareManagers.eaFirstName
cfquery name=getCompletion
datasource=cfelsunrise
Select completionDate
from EmployeeTraining where courseID = 1661 and EmployeeID =
#getCareManagers.EmployeeID#
/cfquery
cfif lastArea is not
AEID
cfset AreaTotal =
AreaTotal + 1
cfif
isDate(getCompletion.CompletionDate)
cfset
AreaComplete = AreaComplete + 1
/cfif
cfset percent2=(AreaComplete/AreaTotal)*100
tr bgcolor=##AFD8D8
td align=leftstrong#AreaLastName#,#AreaFirstName#/strong/td
td align=centerfont size=3#AreaTotal#/td
td align=centerfont size=3#AreaComplete#/td
td align=centerfont size=3b
style=color:##FF8000#NumberFormat(percent2,0.00)#%b/td
/tr
Re: Locking Issue - Read value from APPLICATION scope write it to SESSION scope
That would work, but it's unnecessary overhead unless you're still on CF 5. Virtually all that locking has been handled in MX. ~| 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:323037 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
re: Query Modification
Query of Queries would work really well, and would be very efficient ... why not do that? Query 'employees' has: firstName, lastName, title, email, phone, ext cfquery dbtype=query name=employees SELECT firstName, lastName, email FROM employees /cfquery That would get you there with very little overhead ... ~| 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:323038 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
re: mx7 debugger
What does your full CFFORM tag look like? ~| 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:323039 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Query Modification
I 2nd this. I looked through the java stuff and I don't see a way to remove a column. Just add and manipulate them. Jake Churchill CF Webtools 11204 Davenport, Ste. 100 Omaha, NE 68154 http://www.cfwebtools.com 402-408-3733 x103 -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: Monday, June 01, 2009 2:13 PM To: cf-talk Subject: re: Query Modification Query of Queries would work really well, and would be very efficient ... why not do that? Query 'employees' has: firstName, lastName, title, email, phone, ext cfquery dbtype=query name=employees SELECT firstName, lastName, email FROM employees /cfquery That would get you there with very little overhead ... ~| 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:323040 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Locking Issue - Read value from APPLICATION scope write it to SESSION scope
That would work, but it's unnecessary overhead unless you're still on CF 5. Virtually all that locking has been handled in MX. Well, no, that's actually not correct. CF doesn't lock variables unless you use CFLOCK. It simply doesn't crash if you don't lock them, as it used to with CF 5 and earlier. But if you have the potential for a race condition, and you care about the outcome of said condition, you need to lock variables. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information ~| 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:323041 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Query Modification
Well, For two reasons 1) I really didn't want to incur the overhead of creating a new variable and running the query. I know it has to be much slower than simply dleting for the object. Not the best reason but... 2) Maintenenace issues. The columns I wish to delete are fairly static but the other columns may change depending on what the flex app needs. To use a QoQ I would need to use the columnlist to build the query parsing out the unneeded columns. Granted, neither reason is really a show stopper. I figured if there was a way to add a column, there should be a way to remove one so I thought I'd ask. Sometimes you just never know what you'll find out. ~| 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:323042 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: mx7 debugger
cfform action=mainthome.cfm method=post Tried it with id and name attributes set with the same result. thanks, Mike What does your full CFFORM tag look like? ~| 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:323043 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Maintaining the order of HTML tags atrributes.
But why not use a RegEx to pull the table tag out of both bits of content, then scan over using list functions, using a space as a delimeter to start, then = as the secondary delimeter ... Because some evil person could put, for example: table title=This table is really=cool And either make your regex extra complicated, if not impossible. Far better to use DOM parsing for this sort of thing, and a good parser will have the intricacies of HTML built into it, so will be much simpler to use. ~| 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:323044 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Query Modification
On #2, I assume then that you know which column you would be removing, so how about: get the list of current columns, whatever they are: cfset colList = employees.columnList / remove a known column, in this example phone: cfset colList = listDeleteAt(colList, listFindNoCase(colList, phone)) / now, requery QofQ based on the reduced column list: cfquery dbtype=query name=employees SELECT #colList# FROM employees /cfquery That allows the actual list of columns to be entirely dynamic, while still removing whichever known columns you want to remove, AND still re-uses the same variable, so there's no additional server overhead, or at least not anything noticeable. ~| 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:323045 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Query Modification
That's a good way to re-use the variable. Since there doesn't appear to be a simple function, that's the way I'll go. Thanks! ~| 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:323046 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help ColdFusion Output URGENT
Thanks. But what what you suggesting is not working. I need to display. 1 area
manager on one line and get all the calculation on one line
You could do it better with aggregate functions, but this will work, too.
Just make the completionDate lookup part of your base query (note the LEFT
OUTER JOIN), and then use the GROUP attribute of the CFOUTPUT tag to do the
looping for you in one go:
cfquery name=getCareManagers datasource=XX
Select distinct e.employeeid,
e.last_name,
er.last_name as erLastName,
er.first_name as erFirstName,
er.EMployeeID as REID,
ea.last_name as eaLastName,
ea.first_name as eaFirstName,
l.name as locname,
l.locationID,
ea.Employeeid as AEID,
et.completionDate
from employee e join
employeejobhistory h on h.employeeid = e.employeeid inner join
jobassignment ja on (ja.sequence = h.sequence) inner join
jobcode_list j on j.jobcode = h.jobcode inner join
location l on l.locationid = ja.locationid inner join
area a on a.areaid = l.areaid inner join
employee ea on ea.employeeid = a.managerEmpID inner join
region r on r.regionid = a.regionid inner join
employee er on er.employeeid = r.managerEmpID LEFT OUTER JOIN
employeeTraining et ON e.employeeID = et.employeeID
AND et.courseID = 1661
where ja.EndDate is NULL
cfif isDefined(form.RC) and form.RC eq 0
and h.JobCode in ('1024','1005','1059','1009','1014','1001')
and h.DeptName like 'Reminiscence%'
cfelseif isDefined(form.RC) and form.RC eq 1
and h.JobCode in ('1025')
and h.DeptName like 'Reminiscence%'
cfelse
and h.JobCode in
('1024','1005','1059','1009','1014','1001','1025')
and h.DeptName like 'Reminiscence%'
/cfif
and ja.EmplRcd = 0
and r.ManagerEmpID in (#SESSION.Admin_Reports_locregmanager#)
order by REID, AEID, l.locationID
/cfquery
table border=1 width=50% align=center
tr
thArea/th
th width=36%Total Number of people/th
thTotal Employees Completed/th
th% Completed/th
/tr
cfoutput query=getCareManagers group=AEID
cfset AreaTotal = 0 /
cfset AreaComplete = 0 /
cfoutput
cfset AreaTotal = AreaTotal + 1 /
cfif isDate(completionDate)
cfset AreaComplete = AreaComplete + 1 /
/cfif
cfset percent2 = AreaComplete / AreaTotal * 100 /
tr bgcolor=##AFD8D8
td align=leftstrong#AreaLastName#,
#AreaFirstName#/strong/td
td align=centerfont size=3#AreaTotal#/td
td align=centerfont size=3#AreaComplete#/td
td align=centerfont size=3b
style=color:##FF8000#NumberFormat(percent2, 0.00)#%b/td
/tr
/cfoutput
/cfoutput
/table
~|
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:323047
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
DSN-Less connections in CF8
Yeah, this one's been beaten to death but. I need a process where a user can upload an Access db, certain tables can be read and the data inserted into a MySQL DB. The user has to be able to upload a new db once or twice a month, and the name may not always be the same. I know you used to be able to do this pre-MX, but google searches come back with conflicting results. Has anyone gotten this to work successfully\? -- Scott Stewart ColdFusion Developer 4405 Oakshyre Way Raleigh, NC 27616 (h) 919.874.6229 (c) 703.220.2835 ~| 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:323048 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: DSN-Less connections in CF8
Scott, Here's the approach we usually use (it works pretty well). http://www.coldfusionmuse.com/index.cfm/2005/6/3/dsn_cfmx -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Scott Stewart [mailto:sstwebwo...@bellsouth.net] Sent: Monday, June 01, 2009 3:23 PM To: cf-talk Subject: DSN-Less connections in CF8 Yeah, this one's been beaten to death but. I need a process where a user can upload an Access db, certain tables can be read and the data inserted into a MySQL DB. The user has to be able to upload a new db once or twice a month, and the name may not always be the same. I know you used to be able to do this pre-MX, but google searches come back with conflicting results. Has anyone gotten this to work successfully\? -- Scott Stewart ColdFusion Developer 4405 Oakshyre Way Raleigh, NC 27616 (h) 919.874.6229 (c) 703.220.2835 ~| 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:323049 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Maintaining the order of HTML tags atrributes.
Ok, so I decided to throw together a rough example of how comparing changes
using XmlParse/HtmlParse could work.
It only compares attributes - I wasn't sure if children tags needed checking,
nor how best to do that - it could potentially get quite complex!
(But feel free to have a go, and re-post the code if you get anything
interesting!)
If you look at what the code does, I'm sure you can work out how you might
produce a function that converts to string and always puts attributes in
alphabetical order. :)
Oh, and one more note before the code: I haven't actually tested this in CF,
only Railo - but it should work fine in CF8, unless I've left in anything
Railo-specific.
!---
INFO:
Here are some random HTML table stubs.
The code will of course still work with complete tables.
---
cfsavecontent variable=tag0table attr1=this
attr2=that.../table/cfsavecontent
cfsavecontent variable=tag1table attr2=that
attr1=this.../table/cfsavecontent
cfsavecontent variable=tag2table attr2=this attr3=new
attr1=this.../table/cfsavecontent
!---
NOTE:
Railo supports HtmlParse which works on all HTML (not just XHTML).
However, this builds a complete page, so we must re-target the table.
---
cfset Node0 = HtmlParse(Tag0).Html.Body.Table /
cfset Node1 = HtmlParse(Tag1).Html.Body.Table /
cfset Node2 = HtmlParse(Tag2).Html.Body.Table /
cfdump eval=compareTags( OldNode:Node0 , NewNode:Node1 ) /
cfdump eval=compareTags( OldNode:Node0 , NewNode:Node2 ) /
!---
NOTE:
For other engines than Railo, we must use XHTML for XmlParse.
---
cfset Node0 = XmlParse(Tag0).Table /
cfset Node1 = XmlParse(Tag1).Table /
cfset Node2 = XmlParse(Tag2).Table /
cfdump var=#compareTags( OldNode:Node0 , NewNode:Node1 )# /
cfdump var=#compareTags( OldNode:Node0 , NewNode:Node2 )# /
!---
INFO:
And now for the actual function. :)
---
cffunction name=compareTags returntype=Struct output=false
cfargument name=OldNode type=Xml/
cfargument name=NewNode type=Xml/
cfset var Result =
{ Added : []
, Removed : []
, Changed : []
}/
cfset var OldAttrs = Arguments.OldNode.XmlAttributes /
cfset var NewAttrs = Arguments.NewNode.XmlAttributes /
cfset var CurAttr = 0 /
!---
INFO:
Look for attribute changes or removals from old node.
---
cfloop item=CurAttr collection=#OldAttrs#
cfif StructKeyExists( NewAttrs , CurAttr )
cfif NewAttrs[CurAttr] NEQ OldAttrs[CurAttr]
cfset ArrayAppend(Result.Changed,CurAttr)/
/cfif
cfelse
cfset ArrayAppend(Result.Removed,CurAttr)/
/cfif
/cfloop
!---
INFO:
Look for attribute additions in new node.
---
cfloop item=CurAttr collection=#NewAttrs#
cfif NOT StructKeyExists( OldAttrs , CurAttr )
cfset ArrayAppend(Result.Added,CurAttr)/
/cfif
/cfloop
!---
INFO:
Attributes match if no additions/removals/changes.
---
cfset Result.AttributesMatch = NOT
( ArrayLen(Result.Added)
OR ArrayLen(Result.Removed)
OR ArrayLen(Result.Changed)
)/
!--- TODO: Implement children matching, if required. ---
!---
cfset Result.Match = Result.AttributesMatch AND
Result.ChildrenMatch /
---
cfreturn Result /
/cffunction
~|
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:323050
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: DSN-Less connections in CF8
You can also use the Admin API to create DSNs on the fly. cheers, barneyb On Mon, Jun 1, 2009 at 1:26 PM, Mark Kruger mkru...@cfwebtools.com wrote: Scott, Here's the approach we usually use (it works pretty well). http://www.coldfusionmuse.com/index.cfm/2005/6/3/dsn_cfmx -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Scott Stewart [mailto:sstwebwo...@bellsouth.net] Sent: Monday, June 01, 2009 3:23 PM To: cf-talk Subject: DSN-Less connections in CF8 Yeah, this one's been beaten to death but. I need a process where a user can upload an Access db, certain tables can be read and the data inserted into a MySQL DB. The user has to be able to upload a new db once or twice a month, and the name may not always be the same. I know you used to be able to do this pre-MX, but google searches come back with conflicting results. Has anyone gotten this to work successfully\? -- Scott Stewart ColdFusion Developer 4405 Oakshyre Way Raleigh, NC 27616 (h) 919.874.6229 (c) 703.220.2835 ~| 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:323051 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Locking Issue - Read value from APPLICATION scope write it to SESSION scope
@Dave What version of CF is this? CF-8.1 Is there any likelihood of a race condition with Application.bar? It's possible, yes. If there is the likelihood of a race condition with that variable, do I care? That is, could the race condition cause an improper value of any significance? Definitely... Is there any likelihood of a race condition with Session.foo? It's possible, yes. If there is, do I care? Definitely... ~| 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:323052 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: DSN-Less connections in CF8
Second that. The Admin API makes it easy. On Mon, Jun 1, 2009 at 2:36 PM, Barney Boisvert bboisv...@gmail.com wrote: You can also use the Admin API to create DSNs on the fly. cheers, barneyb On Mon, Jun 1, 2009 at 1:26 PM, Mark Kruger mkru...@cfwebtools.com wrote: Scott, Here's the approach we usually use (it works pretty well). http://www.coldfusionmuse.com/index.cfm/2005/6/3/dsn_cfmx -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Scott Stewart [mailto:sstwebwo...@bellsouth.net] Sent: Monday, June 01, 2009 3:23 PM To: cf-talk Subject: DSN-Less connections in CF8 Yeah, this one's been beaten to death but. I need a process where a user can upload an Access db, certain tables can be read and the data inserted into a MySQL DB. The user has to be able to upload a new db once or twice a month, and the name may not always be the same. I know you used to be able to do this pre-MX, but google searches come back with conflicting results. Has anyone gotten this to work successfully\? -- Scott Stewart ColdFusion Developer 4405 Oakshyre Way Raleigh, NC 27616 (h) 919.874.6229 (c) 703.220.2835 ~| 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:323053 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Locking Issue - Read value from APPLICATION scope write it to SESSION scope
@Jason Assuming you're on CFMX 7 or 8, you no longer need to LOCK on READ... Well that's debatable for sure... http://www.horwith.com/index.cfm/2008/4/28/cflock-explained http://www.horwith.com/index.cfm/2008/7/17/CFLOCK-further-explained ~| 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:323054 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Locking Issue - Read value from APPLICATION scope write it to SESSION scope
On Mon, Jun 1, 2009 at 16:59, Jay Greer m...@gobluerocket.com wrote: @Dave What version of CF is this? CF-8.1 Is there any likelihood of a race condition with Application.bar? It's possible, yes. If there is the likelihood of a race condition with that variable, do I care? That is, could the race condition cause an improper value of any significance? Definitely... Is there any likelihood of a race condition with Session.foo? It's possible, yes. If there is, do I care? Definitely... Then lock the application scope with a read-only lock, copy the value into a local variable, then lock the session scope with an exclusive lock, then copy the local variable into the session. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:323055 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Locking Issue - Read value from APPLICATION scope write it to SESSION scope
Then lock the application scope with a read-only lock, copy the value into a local variable, then lock the session scope with an exclusive lock, then copy the local variable into the session. Roger that... Thanks, Dave all. ~| 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:323056 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFDocumentitem strangeness
I am using cfdocument to output mutliple cfdocumentsections and everything works fine...except for the cfdocumentitem header within each section. All of the other code in the section handles the loop iteration correctly, but the cfdocumentitem outputs only data for the last record in the result set. So, if I have records 100, 101, 102, and 103, the cfocumentitem will show 103 for each section. How can I get this to cooperate? All of the examples I have found are very simple things like ouputting page numbers. Thanks in advance, Billy Cox Old World Spices bi...@oldworldspices.com ~| 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:323057 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Locking Issue - Read value from APPLICATION scope write it to SESSION scope
@Jay Yes, fair enough. Granted that CF doesn't guarantee the order of execution when processing threads in a request, does the application in this case really have the possibility of having multiple threads making sequential changes to that specific session variable (which is thread-safe to that user already) on different threads at the same time? Are there Ajax or iframe calls or something that could be making updates to that session var for that user at the same time in a situation where the order of execution could cause an unexpected value to be read back out by the server? That would be a very rare condition, but if it's possible, then, yes, you should lock. As for reading from the application scope, as in the OP example, that's at least going to be covered by the thread-safe nature of MX, as noted in Simon's entry. To me, it just seems that you almost need to prove out that your application is likely to allow a true race condition before locking every call. Even when I used to do some fairly complex apps that happened to be iframe-driven, I only let one frame ever *write* to persistent scope, the others were only reads, so for something like session or client scope, the move from 4.5 to MX was a great relief in that regard. But certainly to each his own :) ~| 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:323058 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: DSN-Less connections in CF8
So I went the API route... cffunction name=dbMerge access=public description=I move the data into the user database returntype=any cfargument name=dbFileName cfset dbfile = D:\Sites\stlouislandscape-v1\clarity\dbStore\#arguments.dbFileName# cfset adminLogin = createObject(component,cfide.adminapi.administrator).login(pil0t) cfset dbCreate = createObject(component,cfide.adminapi.datasource) cfset tempAccessDBDSN = dbCreate.setMSAccess(tempADSN, #dbfile#, MSAccess, macromedia.jdbc.MacromediaDriver, 19998) cfquery name=getData datasource=tempAccessDBDSN SELECT * FROM MEMBERSHIP /cfquery cfreturn getData /cffunction I'm getting this error Element macromedia.jdbc.MacromediaDriver is undefined in a Java object of type class coldfusion.server.ConfigMap. The error occurred on line 1385. Any ideas? -- Scott Stewart ColdFusion Developer 4405 Oakshyre Way Raleigh, NC 27616 (h) 919.874.6229 (c) 703.220.2835 -Original Message- From: David McGuigan [mailto:davidmcgui...@gmail.com] Sent: Monday, June 01, 2009 5:04 PM To: cf-talk Subject: Re: DSN-Less connections in CF8 Second that. The Admin API makes it easy. On Mon, Jun 1, 2009 at 2:36 PM, Barney Boisvert bboisv...@gmail.com wrote: You can also use the Admin API to create DSNs on the fly. cheers, barneyb On Mon, Jun 1, 2009 at 1:26 PM, Mark Kruger mkru...@cfwebtools.com wrote: Scott, Here's the approach we usually use (it works pretty well). http://www.coldfusionmuse.com/index.cfm/2005/6/3/dsn_cfmx -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Scott Stewart [mailto:sstwebwo...@bellsouth.net] Sent: Monday, June 01, 2009 3:23 PM To: cf-talk Subject: DSN-Less connections in CF8 Yeah, this one's been beaten to death but. I need a process where a user can upload an Access db, certain tables can be read and the data inserted into a MySQL DB. The user has to be able to upload a new db once or twice a month, and the name may not always be the same. I know you used to be able to do this pre-MX, but google searches come back with conflicting results. Has anyone gotten this to work successfully\? -- Scott Stewart ColdFusion Developer 4405 Oakshyre Way Raleigh, NC 27616 (h) 919.874.6229 (c) 703.220.2835 ~| 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:323059 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Locking Issue - Read value from APPLICATION scope write it to SESSION scope
@ Jason Are there Ajax or iframe calls or something that could be making updates to that session var for that user at the same time in a situation where the order of execution could cause an unexpected value to be read back out by the server? Yup... To me, it just seems that you almost need to prove out that your application is likely to allow a true race condition before locking every call. Acknowledged. My (admittedly conservative) approach is to prove that the app _doesn't_ need locking rather than the reverse. Don't get me wrong, I'm all in favour of eliminating both the extra coding burden as well as the overhead. That said, the docs seem to lean towards locking when in doubt... that and the fact I've had the whole locking religion hammered home relentlessly over the years. It may take me a while to get with the new program. ;-) ~| 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:323060 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: DSN-Less connections in CF8
Try omitting the driver and the port. On Mon, Jun 1, 2009 at 7:10 PM, Scott Stewart sstwebwo...@bellsouth.netwrote: So I went the API route... cffunction name=dbMerge access=public description=I move the data into the user database returntype=any cfargument name=dbFileName cfset dbfile = D:\Sites\stlouislandscape-v1\clarity\dbStore\#arguments.dbFileName# cfset adminLogin = createObject(component,cfide.adminapi.administrator).login(pil0t) cfset dbCreate = createObject(component,cfide.adminapi.datasource) cfset tempAccessDBDSN = dbCreate.setMSAccess(tempADSN, #dbfile#, MSAccess, macromedia.jdbc.MacromediaDriver, 19998) cfquery name=getData datasource=tempAccessDBDSN SELECT * FROM MEMBERSHIP /cfquery cfreturn getData /cffunction I'm getting this error Element macromedia.jdbc.MacromediaDriver is undefined in a Java object of type class coldfusion.server.ConfigMap. The error occurred on line 1385. Any ideas? -- Scott Stewart ColdFusion Developer 4405 Oakshyre Way Raleigh, NC 27616 (h) 919.874.6229 (c) 703.220.2835 -Original Message- From: David McGuigan [mailto:davidmcgui...@gmail.com] Sent: Monday, June 01, 2009 5:04 PM To: cf-talk Subject: Re: DSN-Less connections in CF8 Second that. The Admin API makes it easy. On Mon, Jun 1, 2009 at 2:36 PM, Barney Boisvert bboisv...@gmail.com wrote: You can also use the Admin API to create DSNs on the fly. cheers, barneyb On Mon, Jun 1, 2009 at 1:26 PM, Mark Kruger mkru...@cfwebtools.com wrote: Scott, Here's the approach we usually use (it works pretty well). http://www.coldfusionmuse.com/index.cfm/2005/6/3/dsn_cfmx -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Scott Stewart [mailto:sstwebwo...@bellsouth.net] Sent: Monday, June 01, 2009 3:23 PM To: cf-talk Subject: DSN-Less connections in CF8 Yeah, this one's been beaten to death but. I need a process where a user can upload an Access db, certain tables can be read and the data inserted into a MySQL DB. The user has to be able to upload a new db once or twice a month, and the name may not always be the same. I know you used to be able to do this pre-MX, but google searches come back with conflicting results. Has anyone gotten this to work successfully\? -- Scott Stewart ColdFusion Developer 4405 Oakshyre Way Raleigh, NC 27616 (h) 919.874.6229 (c) 703.220.2835 ~| 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:323061 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: DSN-Less connections in CF8
Er, all of the optional arguments. Try just the new datasource name and the path to the file. On Mon, Jun 1, 2009 at 8:43 PM, David McGuigan davidmcgui...@gmail.comwrote: Try omitting the driver and the port. On Mon, Jun 1, 2009 at 7:10 PM, Scott Stewart sstwebwo...@bellsouth.netwrote: So I went the API route... cffunction name=dbMerge access=public description=I move the data into the user database returntype=any cfargument name=dbFileName cfset dbfile = D:\Sites\stlouislandscape-v1\clarity\dbStore\#arguments.dbFileName# cfset adminLogin = createObject(component,cfide.adminapi.administrator).login(pil0t) cfset dbCreate = createObject(component,cfide.adminapi.datasource) cfset tempAccessDBDSN = dbCreate.setMSAccess(tempADSN, #dbfile#, MSAccess, macromedia.jdbc.MacromediaDriver, 19998) cfquery name=getData datasource=tempAccessDBDSN SELECT * FROM MEMBERSHIP /cfquery cfreturn getData /cffunction I'm getting this error Element macromedia.jdbc.MacromediaDriver is undefined in a Java object of type class coldfusion.server.ConfigMap. The error occurred on line 1385. Any ideas? -- Scott Stewart ColdFusion Developer 4405 Oakshyre Way Raleigh, NC 27616 (h) 919.874.6229 (c) 703.220.2835 -Original Message- From: David McGuigan [mailto:davidmcgui...@gmail.com] Sent: Monday, June 01, 2009 5:04 PM To: cf-talk Subject: Re: DSN-Less connections in CF8 Second that. The Admin API makes it easy. On Mon, Jun 1, 2009 at 2:36 PM, Barney Boisvert bboisv...@gmail.com wrote: You can also use the Admin API to create DSNs on the fly. cheers, barneyb On Mon, Jun 1, 2009 at 1:26 PM, Mark Kruger mkru...@cfwebtools.com wrote: Scott, Here's the approach we usually use (it works pretty well). http://www.coldfusionmuse.com/index.cfm/2005/6/3/dsn_cfmx -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Scott Stewart [mailto:sstwebwo...@bellsouth.net] Sent: Monday, June 01, 2009 3:23 PM To: cf-talk Subject: DSN-Less connections in CF8 Yeah, this one's been beaten to death but. I need a process where a user can upload an Access db, certain tables can be read and the data inserted into a MySQL DB. The user has to be able to upload a new db once or twice a month, and the name may not always be the same. I know you used to be able to do this pre-MX, but google searches come back with conflicting results. Has anyone gotten this to work successfully\? -- Scott Stewart ColdFusion Developer 4405 Oakshyre Way Raleigh, NC 27616 (h) 919.874.6229 (c) 703.220.2835 ~| 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:323062 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
jQuery Guru guidance needed....
I'm using jQuery Tabs to rebuild my ancient product admin. Trying to slicken it
up a bit. As a product is added, I need the tab .cfm's, and the parent to pass
around the prod ID variable to each other.
The tabs I'm using: http://docs.jquery.com/UI/API/1.7/Tabs
I have a parent page that contains the tabs (disabling 2nd-5th tab until a
product is added:
tabs.cfm
script
$(document).ready(function() {
$(#productAdmin).tabs({ disabled: [1, 2, 3, 4] });
});
/script
div id=productAdmin
ul
lia href=product_add.cfmspanProduct Info/span/a/li
lia href=productBuilder-Categories.cfmspanCategories/span/a/li
lia href=productBuilder-Skus.cfmspanSKUS/span/a/li
lia href=productBuilder-SuggestedProducts.cfmspanSuggested
Products/span/a/li
lia href=productBuilder-prodImage.cfmspanImages/span/a/li
/ul
If someone is using the product info tab, and they add a product, how could I
let the parent, tabs.cfm know, and enable the other tabs at that point.
Thanks,
Will
~|
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:323063
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: jQuery Guru guidance needed....
go here: http://jqueryui.com/demos/tabs/
click on Methods tab. read about the 'URL' method.
presumably, your product_add.cfm page adds a product using ajax post? if
so, the callback function should receive the id of newly added product
and then call the url() method on the other tabs (and maybe load()
method as well - can't remember now if just setting a new url reloads
the tab or not...)
your url(0 method calls will look like this:
$(#productAdmin).tabs('url', 1, 'productBuilder-Categories.cfm?id='+id);
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
On 02/06/2009 09:44, Will Tomlinson wrote:
I'm using jQuery Tabs to rebuild my ancient product admin. Trying to slicken
it up a bit. As a product is added, I need the tab .cfm's, and the parent to
pass around the prod ID variable to each other.
The tabs I'm using: http://docs.jquery.com/UI/API/1.7/Tabs
I have a parent page that contains the tabs (disabling 2nd-5th tab until a
product is added:
tabs.cfm
script
$(document).ready(function() {
$(#productAdmin).tabs({ disabled: [1, 2, 3, 4] });
});
/script
div id=productAdmin
ul
lia href=product_add.cfmspanProduct Info/span/a/li
lia href=productBuilder-Categories.cfmspanCategories/span/a/li
lia href=productBuilder-Skus.cfmspanSKUS/span/a/li
lia href=productBuilder-SuggestedProducts.cfmspanSuggested
Products/span/a/li
lia href=productBuilder-prodImage.cfmspanImages/span/a/li
/ul
If someone is using the product info tab, and they add a product, how could I
let the parent, tabs.cfm know, and enable the other tabs at that point.
Thanks,
Will
~|
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:323064
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: jQuery Guru guidance needed....
go here: http://jqueryui.com/demos/tabs/ click on Methods tab. read about the 'URL' method. presumably, your product_add.cfm page adds a product using ajax post? if so, the callback function should receive the id of newly added product and then call the url() method on the other tabs (and maybe load() method as well - can't remember now if just setting a new url reloads the tab or not...) Ahh... I wasn't posting via AJAX. I was just looking at this: http://malsup.com/jquery/form/#getting-started Thanks for the info. I think I'm on the right track now. Need to post via ajax. Will ~| 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:323065 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Strange query of query behavior.
I am experiencing some very strange behavior from some very strange behavior with a recursive query of a query function. I am using the function to build a tree from a ms-sql table that has a parent-child relationship in its records. This function orders the selected records by a field that in the original query can contain nulls or integers. If I order the query of query by this field, the output loop will only iterate over the first record in the record set, even though I can dump the entire record set. If I remove the fields that can contain nulls from the query of query SQL statement, the output loops over all the records. Does this make sense? Should one expect this behavior from a query-of-query? How can the cfdump... tag loop over all the records but the cfoutput... does not? The output of this page can be seen here: http://www.sierraoutdoorrecreation.com/Geo-Order.cfm ~| 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:323066 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
