Re: Flex Builder 2 and the CFadapter
Chris Velevitch wrote: On 10/26/05, Joshua O'Connor-Rose [EMAIL PROTECTED] wrote: Is this ok to post on this list? You could also try posting uqestions to http://groups.yahoo.com/group/flexcoders/ also ray's got a flex2dev list setup on cfczone.org which i *think* (as i can't seem to find that email) you can subscribe to using subscribe flex2dev in the subject of an email to [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:74 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Flex Builder 2 and the CFadapter
http://ray.camdenfamily.com/index.cfm/2005/10/20/Flex-2-List On 10/25/05, Paul Hastings [EMAIL PROTECTED] wrote: Chris Velevitch wrote: On 10/26/05, Joshua O'Connor-Rose [EMAIL PROTECTED] wrote: Is this ok to post on this list? You could also try posting uqestions to http://groups.yahoo.com/group/flexcoders/ also ray's got a flex2dev list setup on cfczone.org http://cfczone.orgwhich i *think* (as i can't seem to find that email) you can subscribe to using subscribe flex2dev in the subject of an email to [EMAIL PROTECTED] ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:75 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
New version of CFAJAX
For those not also on the CFAJAX list; Arjun has just released a new version. CFAJAX 1.2.1 includes the new suggest component, as show here: http://www.indiankey.com/cfajax/examples/suggest.htm It provides a custom autocomplete based on data from your CF function similar to the email address completion in GMail etc. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:76 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cfcatching timeouts
Hi, I have a stored procedure running which can take ages. I've set the page time out 20seconds, but now was to be able to catch the error. The following code works and displays error cftry cfstoredproc datasource=#application.dsn# procedure=spQry cfprocparam type=in cfsqltype=cf_sql_varchar value=#var# / cfprocresult name = qryName resultset=1 / /cfstoredproc cfcatch type=any ERROR cfabort /cfcatch /cftry But by replacing error with cfoutputcfcatch.message/cfoutput just throws back a CF error The request has exceeded the allowable time limit Tag: cfoutput Is there any way to gracefully catch the stroed procedure timing out? or page timeout? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:77 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: New version of CFAJAX
Nice. I may have to familiarize myself with this version. Hopefully not too much will change in terms of core structure. On 10/26/05, James Holmes [EMAIL PROTECTED] wrote: For those not also on the CFAJAX list; Arjun has just released a new version. CFAJAX 1.2.1 includes the new suggest component, as show here: http://www.indiankey.com/cfajax/examples/suggest.htm It provides a custom autocomplete based on data from your CF function similar to the email address completion in GMail etc. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:78 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Recursion anyone?
Hi I keep returning to this problem in order to build an infinite DHTML menu (a task which has now become a quest and a matter of honour). Does anyone know how to recurse through an adjacency list model table, of the following setup ID CategoryName ParentItemID Also, I hear you can use CFTREE format=xml or format=object and then use that to make a DHTML menu? anyone have any experience Muchos Thank You's Steve ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:79 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFTREE Object - Looping through structure
On Tuesday 25 October 2005 17:51, Stephen Whiteley wrote: I always seem to have a way of wording questions, that inspire no answers, does anyone want any clarification or more information? You're not sure how to write a recursive function in CF ? You've tried and it craps out ? -- Tom Chiverton Advanced ColdFusion Programmer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:80 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFTREE Object - Looping through structure
On Tuesday 25 October 2005 17:51, Stephen Whiteley wrote: I always seem to have a way of wording questions, that inspire no answers, does anyone want any clarification or more information? You're not sure how to write a recursive function in CF ? You've tried and it craps out ? -- Tom Chiverton Advanced ColdFusion Programmer Yes I am, sorry I cross-posted thinking that this thread was dead. In the following thread I think I explain myself better I hope. http://www.houseoffusion.com/cf_lists/messages.cfm/forumid:4/threadid:42965 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:81 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFTREE Object - Looping through structure
http://www.houseoffusion.com/cf_lists/messages.cfm/forumid:4/threadid:42965
startNodeId=somethingOrOther; (you know where you are staring from)
while hasParent(startNodeId){
listAdd(aList,nameOfNode(startNodeId)
startNode=getParentOfNode(startNodeId)
}
aList=listReverse(aList);
print aList;
hasParent() and getParentOfNode() are then fairly trivial.
--
Tom Chiverton
Advanced ColdFusion Programmer
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:82
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Recursion anyone?
On Wednesday 26 October 2005 11:15, Stephen Whiteley wrote:
know how to recurse through an adjacency list model table, of the following
setup
ID CategoryName ParentItemID
topLevel=getNodesWithNoParent()
foreach thisNode in topLevel{
print thisNode
getChildren(thisNode)
}
function getChildren(aNode){
childList=getChildrenOf(aNode);
foreach aNode on childList{
print aNode
getChildren(aNode)
}
}
getNodesWithNoParent() is easy.
--
Tom Chiverton
Advanced ColdFusion Programmer
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:83
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Recursion anyone?
There are loads and loads of DHTML menus out there, e.g.
http://www.dynamicdrive.com/dynamicindex1/hvmenu/
with the actual menu code taken care of, all you have to do is recurse over
your database and write out the menu items.
last time i checked, cftree outputs a java applet, not javascript.
do you not know how to recurse?
heres some pseudo code
variables.inst.menuqry = getAllCategories();
function buildmenu(currentid){
var i=0;
for(i=1; i lte variables.inst.menuqry.recorcount; i=i+1){
if(variables.inst.menuqry.parent_id[i] eq arguments.currentID)
writeoutput(your javascript);
buildmenu(variables.inst.menuqry.id[i]);
}
}
}
buildmenu(yourrootid);
-Original Message-
From: Stephen Whiteley [mailto:[EMAIL PROTECTED]
Sent: 26 October 2005 11:15
To: CF-Talk
Subject: Recursion anyone?
Hi
I keep returning to this problem in order to build an infinite DHTML menu (a
task which has now become a quest and a matter of honour). Does anyone know
how to recurse through an adjacency list model table, of the following setup
ID CategoryName ParentItemID
Also, I hear you can use CFTREE format=xml or format=object and then use
that to make a DHTML menu? anyone have any experience
Muchos Thank You's
Steve
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:84
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Recursion anyone?
Depending on your DB you may be able to do the recursion there rather than in the CF or JS code: http://www.oreilly.com/catalog/sqlpr/chapter/ch01.pdf On 10/26/05, Stephen Whiteley [EMAIL PROTECTED] wrote: Hi I keep returning to this problem in order to build an infinite DHTML menu (a task which has now become a quest and a matter of honour). Does anyone know how to recurse through an adjacency list model table, of the following setup ID CategoryName ParentItemID Also, I hear you can use CFTREE format=xml or format=object and then use that to make a DHTML menu? anyone have any experience ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:85 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Recursion anyone?
Why not use one of the nice DHTML menus that already exists. I have built a tag that creates an DHTML explorer tree, and all I do is query my category's, putitng them in the correct order, then recursively loop over that query to check for child items of the current node. -- Russ -Original Message- From: Stephen Whiteley [mailto:[EMAIL PROTECTED] Sent: 26 October 2005 11:15 To: CF-Talk Subject: Recursion anyone? Hi I keep returning to this problem in order to build an infinite DHTML menu (a task which has now become a quest and a matter of honour). Does anyone know how to recurse through an adjacency list model table, of the following setup ID CategoryName ParentItemID Also, I hear you can use CFTREE format=xml or format=object and then use that to make a DHTML menu? anyone have any experience Muchos Thank You's Steve ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:86 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Recursion anyone?
Hi Yes the problem is the recursion can't get my head round it, never used CFSCRIPT before being a bit of a newbie. Not trying to build a DHTML menu from scratch and would use an off the shelf one. CFTREE in CFMX 7 will output xml or a structure depending on format= used. I'll keep playing with the code provided thanks, but if anyone can expand for a dummy, much appreciated Steve ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:87 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Flex Builder 2 and the CFadapter
For all Flex 2 discussion, these 6 forums are where all the discussions are happening now: http://labs.macromedia.com/community/ For Flex Builder 2 + CF Adapter discussion: http://labs.macromedia.com/wiki/index.php/Talk:CF_Adapter Damon ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:88 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Recursion anyone?
OK, this is my database setup ItemID,ParentItemID,AdCategoryName What I want to be able to do is output something like this (before I go to the DHTML menu stage, walk before I can run) Accommodation Self Catering Farmhouse Rustic Farmhouse Activities Walking Walking Routes Walking Shops etc. etc... I'm sure once a get the hang of it I'll be ok but any help much appreciated Thanks Steve ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:89 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Scheduler Goes Nutty
I have about 10 scheduled tasks that run nightly to do a bunch of maintenance stuff. These have been running correctly for about 18 months. Last night, for some reason every single one of the tasks ran twice simultaneuously, causing a bunch of problems. Has anyone seen the scheduler do this before? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:90 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Scheduler Goes Nutty [solved]
Stupid, stupid me. I had recently taken this server out of service and replaced it. I put the old server back in service yesterday as a development machine and had neglected to remove all the scheduled tasks from that machine. So both machines were instantiating the tasks. Blah. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:91 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Cookie Checking
If a user comes to a page that needs a login, I give them an error
and a link to a login page. I have the login set a cookie and then
returns the user to the original page that needed a login:
cfcookie name=fsnep_login value=#validate_user.login_id[1]#
cfset the_loc = #session.return_url##del#login_return=true
cflocation url=#the_loc# addtoken=no
It returns to the url with a url variable. With the return variable
attached, the page then checks for the cookie and allows the user
in. And if the user chooses to use the logout button, it works fine
(foreshadowing).
Unfortunately without the url variable attached, it doesn't correctly
find the cookie and says that the user must log in again. So if
they're returned to the page with the url variable attached, they are
logged in, otherwise, it appears that they're not, even though they
are. I do the check like this:
cfif NOT isDefined('cookie.fsnep_login')
Now, if I change it to cfif NOT structKeyExists(cookie,'fsnep_login')
, it works fine. I can go to the page, it asks for a login, I
login and am returned, works fine. I then type in the page, without
the url variable appended and it still works fine. The cookie is
there and it sees it. Unfortunately with this scenario, when the
logout button is clicked, and then I return to the page, it still
acts as if I'm logged in, unless I append a url variable sigh. ???
Here's the logout code:
cfset j = structDelete(cookie,'fsnep_login',true)
cfcookie name=fsnep_login expires=now
cfset k = structDelete(session,'return_url',true)
cfset i = structDelete(session,'fsnep_login',true)
This is on PC IE
thanks for any help.
_
Daniel Kessler
College of Health and Human Performance
University of Maryland
Suite 2387 Valley Drive
College Park, MD 20742-2611
Phone: 301-405-2545
http://hhp.umd.edu
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:92
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Scheduler Goes Nutty [solved]
On Wednesday 26 October 2005 13:43, [EMAIL PROTECTED] wrote: Stupid, stupid me. Been there, done that :-) -- Tom Chiverton Advanced ColdFusion Programmer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:93 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Recursion anyone?
Stephen... Here's some code for you. Create the table first: CREATE TABLE links ( link_id smallint(5) unsigned NOT NULL auto_increment, link_childof smallint(5) unsigned NOT NULL default '0', link_name varchar(100) NOT NULL default '', ) TYPE=MyISAM; Then here's the SQL to pull 3 levels of links. cfquery name=getLinks dataSource=#Application.DSN# dbType=#Application.DBType# username=#Application.username# password=#Application.password# SELECT top.link_id AS top_id, top.link_name AS top_name, mid.link_id AS mid_id, mid.link_name AS mid_name, sub.link_id AS sub_id, sub.link_name AS sub_name FROM links top LEFT OUTER JOIN links mid ON mid.link_childof = top.link_id LEFT OUTER JOIN links sub ON sub.link_childof = mid.link_id WHERE top.link_childof = 0 GROUP BY top_name, mid_name, sub_name ORDER BY top_name, mid_name, sub_name /cfquery I use this method all the time and it works beautifully. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Stephen Whiteley [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 26, 2005 6:11 AM To: CF-Talk Subject: Re: Recursion anyone? Hi Yes the problem is the recursion can't get my head round it, never used CFSCRIPT before being a bit of a newbie. Not trying to build a DHTML menu from scratch and would use an off the shelf one. CFTREE in CFMX 7 will output xml or a structure depending on format= used. I'll keep playing with the code provided thanks, but if anyone can expand for a dummy, much appreciated Steve ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:94 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Recursion anyone?
Kerry
I'm trying to get you code to work but will be making a real hash of it, I
wonder if you take a look at this, I think getting the query in is the problem.
cfquery datasource=#DSN# name=getAllCategories
SELECT itemid,parentitemid,adcategoryname FROM tblAdvertTypes
/cfquery
cfscript
variables.inst.menuqry = getAllCategories();
function buildmenu(currentid){
var i=0;
for(i=1; i lte parentitemid.menuqry.recorcount; i=i+1){
if(variables.inst.menuqry.parentitemid[i] eq arguments.currentID)
writeoutput(variables.menuqry.adcategoryname);
buildmenu(variables.inst.menuqry.itemid[i]);
}
}
/cfscript
cfset returnValue=buildmenu(10)
cfoutput#returnvalue#/cfoutput
thanks
Steve
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:95
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Simple SQL
Hi guys, I'm trying to do a simple query but am having a blank and pulling multiples. !--- get all event details and their corresponding music genre type --- cfquery datasource=user020 name=GetEvents SELECT e.eventID, e.eventName, e.eventTeaser, e.eventDate, m.musicGenreID, m.musicGenreName FROM tbl_020eventDetails e, tbl_020musicGenres m WHERE e.eventDate = #DateAdd(d, -1, UKtodayDate)# ORDER BY e.eventDate ASC /cfquery What i'd like it to do is pull each event and the corresponding music genre but instead each record is getting pulled multiple times all with the same musicGenreID details. Any help I'd be grateful, Thanks, Saturday ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:96 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Simple SQL
cfquery datasource=user020 name=GetEvents SELECT e.eventID, e.eventName, e.eventTeaser, e.eventDate, m.musicGenreID, m.musicGenreName FROM tbl_020eventDetails e, tbl_020musicGenres m WHERE e.eventDate = #DateAdd(d, -1, UKtodayDate)# !--- join tables --- AND e.musicGenreID = m.musicgenreid ORDER BY e.eventDate ASC /cfquery Try this. I think you are getting mulitple records because you're original query did not join the two tables in you're 'From' clause. rgds, Charlie Hanlon - Original Message - From: Saturday (Stuart Kidd) [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, October 26, 2005 9:49 AM Subject: Simple SQL Hi guys, I'm trying to do a simple query but am having a blank and pulling multiples. !--- get all event details and their corresponding music genre type --- cfquery datasource=user020 name=GetEvents SELECT e.eventID, e.eventName, e.eventTeaser, e.eventDate, m.musicGenreID, m.musicGenreName FROM tbl_020eventDetails e, tbl_020musicGenres m WHERE e.eventDate = #DateAdd(d, -1, UKtodayDate)# ORDER BY e.eventDate ASC /cfquery What i'd like it to do is pull each event and the corresponding music genre but instead each record is getting pulled multiple times all with the same musicGenreID details. Any help I'd be grateful, Thanks, Saturday ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:97 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Simple SQL
How about this: SELECT e.eventID, e.eventName, e.eventTeaser, e.eventDate, m.musicGenreID, m.musicGenreName FROMtbl_020eventDetails e INNER JOIN tbl_020musicGenres m ON e.musicGenreID = m.musicGenreID WHERE e.eventDate = #DateAdd(d, -1, UKtodayDate)# ORDER BYe.eventDate ASC Steve Bryant. Bryant Web Consulting LLC http://www.BryantWebConsulting.com/ http://steve.coldfusionjournal.com/ Hi guys, I'm trying to do a simple query but am having a blank and pulling multiples. !--- get all event details and their corresponding music genre type --- cfquery datasource=user020 name=GetEvents SELECT e.eventID, e.eventName, e.eventTeaser, e.eventDate, m.musicGenreID, m.musicGenreName FROM tbl_020eventDetails e, tbl_020musicGenres m WHERE e.eventDate = #DateAdd(d, -1, UKtodayDate)# ORDER BY e.eventDate ASC /cfquery What i'd like it to do is pull each event and the corresponding music genre but instead each record is getting pulled multiple times all with the same musicGenreID details. Any help I'd be grateful, Thanks, Saturday ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:98 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Simple SQL
On 10/26/05, Saturday (Stuart Kidd) [EMAIL PROTECTED] wrote: Hi guys, I'm trying to do a simple query but am having a blank and pulling multiples. !--- get all event details and their corresponding music genre type --- cfquery datasource=user020 name=GetEvents SELECT e.eventID, e.eventName, e.eventTeaser, e.eventDate, m.musicGenreID, m.musicGenreName FROM tbl_020eventDetails e, tbl_020musicGenres m WHERE e.eventDate = #DateAdd(d, -1, UKtodayDate)# ORDER BY e.eventDate ASC /cfquery What i'd like it to do is pull each event and the corresponding music genre but instead each record is getting pulled multiple times all with the same musicGenreID details. Are you getting a cross join? Sounds like it -- I don't see what relates the tables in your query. I'd *always* use the SQL standard of explictly stating the joins instead of just letting the db figure it out SELECT e.eventID, e.eventName, e.eventTeaser, e.eventDate, m.musicGenreID, m.musicGenreName FROM tbl_020eventDetails e, INNER JOIN tbl_020musicGenres m ON (whatever relates the tables) WHERE e.eventDate = #DateAdd(d, -1, UKtodayDate)# ORDER BY e.eventDate ASC -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:99 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL 5 release
On 10/25/05, John C. Bland II [EMAIL PROTECTED] wrote: Just so you know, I upgraded from 4.1 to 5 earlier and all I did was install 5, copy db's to 5's directory, setup all users (could've probably found an easier way but I only needed two...strictly a dev db), That's what the fix_privileges script is for -- all that info is stored in your mysql database (the database *named* mysql). Recreating a couple of users is easy, as you suggest, but for production systems, you want to guarentee everything is the same, so an in-place upgrade of the db is a much better choice. You could amend your approach to Copy all of the databases to 5's directory, ran the fix_privileges on the mysql database, and was ready to go. That way, you've still got both dbs available. Of course it gets trickier if you're dealing with innodb tables or anything else other than MyISAM. and remove the 4.1instance. Oh, I had to restart 5 after that but no sweat. All-in-all, without my forgetting to restart 5, it took like 20 minutes including download time. I understand your hesitation though. If this was a live box I probably would've felt the same way. On 10/25/05, Matt Robertson [EMAIL PROTECTED] wrote: On 10/25/05, John Paul Ashenfelter [EMAIL PROTECTED] wrote: Not sure if you're asking about upgrading MySQL itself from 4-5 or using the MySQL JDBC drivers on CF7 Actually, both although the questions were poorly worded. Thanks. You told me what I needed to know. I hate to say it but I'll probably leave my main mysql server alone for the simple reason its running like 40 web sites and ... well, its working fine. I'd like the new functionality but I can't risk the consequences of a mistake, even for a weekend afternoon or so. I'll save this for when I add a new server. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com http://mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222300 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Simple SQL
Yes, I forgot that - doh! Can't believe I forgot that. Thanks Charlie! :) cfquery datasource=user020 name=GetEvents SELECT e.eventID, e.eventName, e.eventTeaser, e.eventDate, m.musicGenreID, m.musicGenreName FROM tbl_020eventDetails e, tbl_020musicGenres m WHERE e.eventDate = #DateAdd(d, -1, UKtodayDate)# !--- join tables --- AND e.musicGenreID = m.musicgenreid ORDER BY e.eventDate ASC /cfquery Try this. I think you are getting mulitple records because you're original query did not join the two tables in you're 'From' clause. rgds, Charlie Hanlon - Original Message - From: Saturday (Stuart Kidd) [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, October 26, 2005 9:49 AM Subject: Simple SQL Hi guys, I'm trying to do a simple query but am having a blank and pulling multiples. !--- get all event details and their corresponding music genre type --- cfquery datasource=user020 name=GetEvents SELECT e.eventID, e.eventName, e.eventTeaser, e.eventDate, m.musicGenreID, m.musicGenreName FROM tbl_020eventDetails e, tbl_020musicGenres m WHERE e.eventDate = #DateAdd(d, -1, UKtodayDate)# ORDER BY e.eventDate ASC /cfquery What i'd like it to do is pull each event and the corresponding music genre but instead each record is getting pulled multiple times all with the same musicGenreID details. Any help I'd be grateful, Thanks, Saturday ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222301 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Recursion anyone?
1) in my original code, getallcategories is a function, not a query.
change to: variables.inst.menuqry = getAllCategories;
2) note that the buildmenu function does not return anything, so this:
cfset returnValue=buildmenu(10)
Is going to give you null.
3) writeoutput(variables.menuqry.adcategoryname);
This is just going to give you one big indecipherable string.
cfscript
function buildmenu(currentid,depth){
var i=0;
for(i=1; i lte parentitemid.menuqry.recorcount; i=i+1){
if(variables.inst.menuqry.parentitemid[i] eq arguments.currentID)
writeoutput(repeatstring(,arguments.depth)variables.menuqry.adcategoryna
me[i]br);
buildmenu(variables.inst.menuqry.itemid[i],arguments.depth+1);
}
}
buildmenu(10,0)
/cfscript
!---
these lines dont make sense
cfset returnValue=buildmenu(10)
cfoutput#returnvalue#/cfoutput
---
3.2) variables.menuqry.adcategoryname
This will always give you the first record's categoryname.
when doing a for() loop, you _must_ use the counter
variables.menuqry.adcategoryname[i]
Good luck!
-Original Message-
From: Stephen Whiteley [mailto:[EMAIL PROTECTED]
Sent: 26 October 2005 14:51
To: CF-Talk
Subject: Re: Recursion anyone?
Kerry
I'm trying to get you code to work but will be making a real hash of it, I
wonder if you take a look at this, I think getting the query in is the
problem.
cfquery datasource=#DSN# name=getAllCategories
SELECT itemid,parentitemid,adcategoryname FROM tblAdvertTypes
/cfquery
cfscript
variables.inst.menuqry = getAllCategories();
function buildmenu(currentid){
var i=0;
for(i=1; i lte parentitemid.menuqry.recorcount; i=i+1){
if(variables.inst.menuqry.parentitemid[i] eq arguments.currentID)
writeoutput(variables.menuqry.adcategoryname);
buildmenu(variables.inst.menuqry.itemid[i]);
}
}
/cfscript
cfset returnValue=buildmenu(10)
cfoutput#returnvalue#/cfoutput
thanks
Steve
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222302
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL 5 release
When comparing Navicat and EMS, I'd certainly say that if you can justify the price difference you should go with EMS. Navicat works well, but there are just some little things that make it too frustrating for me to use. I don't like to move my hands from the keyboard when I'm working, but the control keys in Navicat are extremely flaky, especially when the results window is docked. It's not a bad tool and it can certainly handle any task you need handled, but the EMS Manager is more of a joy to use. --Ferg Adkins, Randy wrote: I second - NaviCat.. Well worth the small price. -Original Message- From: Kevin Aebig [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 25, 2005 3:03 PM To: CF-Talk Subject: RE: MySQL 5 release I'm a huge fan of Navicat... great tool. !K -Original Message- From: Nathan Strutz [mailto:[EMAIL PROTECTED] Sent: October 25, 2005 12:55 PM To: CF-Talk Subject: Re: MySQL 5 release Ken, or anybody, Are there any really good GUI apps for managing MySQL 5? Preferably OSS and for windows, but I'll bet people on the list will want all the other platforms. -nathan On 10/25/05, Ken Ferguson [EMAIL PROTECTED] wrote: I've been using version 5 in beta for some time now and was happy to see the production release yesterday. You should all check it out. It's really working well for me. Cutter (CF-Talk) wrote: By the way, if you missed Ben Forta's Blog this morning then you may have missed this item. This blurb is from the MySQL.org website: MySQL 5.0 delivers the enterprise features the community has been asking for, including Stored Procedures, Triggers, Views, Information Schema, XA Distributed Transactions, and new Storage Engines... ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222303 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Anyone writing an ActiveRecord (Rails component) port for CF?
Folks, I'm doing a fair bit of Rails work lately and am really liking the ActiveRecord component -- the database/model layer of Rails. I'd really like to see something similar for CF. I am NOT talking about porting *Rails* to CF, just ActiveRecord. I repeat, I'm not talking about porting Rails to CF -- I'm a happy Fusebox user with some MachII and growing onTap experience. I just want a simple model layer that requires very little coding. I'm not interested in a Rails vs CF Framework X discussion (well, I am, but I gave a talk on my view of that at FBFrameworks 2005) -- so at least not on this thread :) If anyone is doing this sort of thing, please contact me off-list ([EMAIL PROTECTED])-- I've done a some initial work on such a port myself and would like to have a set of folks to bounce ideas off. For those of you not familiar with Rails or ActiveRecord, the ActiveRecord pattern basically wraps a single database table as an object with each row being an instance of that class. As an aside, I have looked at Reactor. While it may implement the ActiveRecord pattern, I'm after an implementation that's much more similar to the one in Ruby/Rails. -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222304 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Problem with MySQL
Claude Schneegans May be, but this one was not: converting a database to a form usable under CF is a problem many of us had to deal with. Scenario 1: I have a nasty virus on my PC, and I can't code in CF until its fixed...will you help me? Scenario 2: I couldn't get my car to run this morning, so I couldn't come in to work, which means I couldn't get to my CF projects...will you help me fix my car? Yes, these are both issues many of us have dealt with, and yes there may be a lot of folks on this list that could and probably would help me. But there are better places to ask these questions than a ColdFusion list. Again, as I stated in my last post in this thread, I am obviously in the minority on this issue so I'll just shutup and live with it. [INFO] -- Access Manager: This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A2 ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222305 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Simple SQL
John Paul, You stated I'd *always* use the SQL standard of explictly stating the joins instead of just letting the db figure it out Is this a best practice that I should adopt. I am self-taught and am not aware that explictly joining the tables is more efficient than joining the tables in the 'Where' clause'. thanks in advance for your clarification/confirmation... rgds, Charlie Hanlon - Original Message - From: John Paul Ashenfelter [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, October 26, 2005 9:59 AM Subject: Re: Simple SQL On 10/26/05, Saturday (Stuart Kidd) [EMAIL PROTECTED] wrote: Hi guys, I'm trying to do a simple query but am having a blank and pulling multiples. !--- get all event details and their corresponding music genre type --- cfquery datasource=user020 name=GetEvents SELECT e.eventID, e.eventName, e.eventTeaser, e.eventDate, m.musicGenreID, m.musicGenreName FROM tbl_020eventDetails e, tbl_020musicGenres m WHERE e.eventDate = #DateAdd(d, -1, UKtodayDate)# ORDER BY e.eventDate ASC /cfquery What i'd like it to do is pull each event and the corresponding music genre but instead each record is getting pulled multiple times all with the same musicGenreID details. Are you getting a cross join? Sounds like it -- I don't see what relates the tables in your query. I'd *always* use the SQL standard of explictly stating the joins instead of just letting the db figure it out SELECT e.eventID, e.eventName, e.eventTeaser, e.eventDate, m.musicGenreID, m.musicGenreName FROM tbl_020eventDetails e, INNER JOIN tbl_020musicGenres m ON (whatever relates the tables) WHERE e.eventDate = #DateAdd(d, -1, UKtodayDate)# ORDER BY e.eventDate ASC -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222306 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cf code doesn't work inside the custom tag's calling tag?
Hi, If you call custom tag using cfimport, you don't seem to be able to use cf code inside the calling tag. For example: cfimport prefix=my taglib=/my/custom/tags/library// my:tag cfif structKeyExists(attributes, view)view=#attributes.view/cfif/ This will throw an error because the custom tag doesn't recognize cfif as a valid attribute name. Does anyone has a work-around that? Johnny ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222307 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Recursion anyone?
Thanks Kerry
I'm starting to understand, got no experience of cfscript but it seems a lot
like actionscript.
Unfortunately I've tried to run the code and I'm getting the following error.
Context validation error for tag cfscript.
The start tag must have a matching end tag. An explicit end tag can be provided
by adding /cfscript. If the body of the tag is empty you can use the shortcut
cfscript .../.
This is the exact code
cfquery datasource=#DSN# name=getAllCategories
SELECT itemid,parentitemid,adcategoryname FROM tblAdvertTypes
/cfquery
cfscript
variables.inst.menuqry = getAllCategories;
function buildmenu(currentid,depth){
var i=0;
for(i=1; i lte parentitemid.menuqry.recorcount; i=i+1){
if(variables.inst.menuqry.parentitemid[i] eq arguments.currentID)
writeoutput(repeatstring(,arguments.depth)variables.menuqry.adcategoryname[i]br);
buildmenu(variables.inst.menuqry.itemid[i],arguments.depth+1);
}
}
buildmenu(10,0)
/cfscript
Steve
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222308
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFMail Undelivr Folder
Hi I am developing a mail campaign application that amongst the stats on mail-outs shows the number of undeliveable mails (or at least I'm hoping it will) To try and fill the C:\CFusionMX\Mail\Undelivr with some files in order to begin coding, I added some addresses to the mailing list that I knew to be incorrect and sent out the mail. For example, I sent on to [EMAIL PROTECTED], to which I got a message through to [EMAIL PROTECTED] saying user unknown from our mailserver, as I always do as I administer the mail server. But there was no record of this in the undeliverable folder. I then altered the address to read .oc.uk, but still nothing in the undeliverable folder. So, my question is, under what circumstances is the undeliverable folder populated? Does it take a while for files to appear there whilst email messages are attempted to be delivered? I thought it may have something to do with internal dev servers and sending the mail through our external mail server, but I've tested remotely and still nothing in the folder! Any advice welcome Thanks Dave ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222309 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Recursion anyone?
You're missing a semicolon at the end of the last expression in the cfscript
tag. This:
buildmenu(10,0)
should be this:
buildmenu(10,0);
!//--
andy matthews
web developer
ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--//-
-Original Message-
From: Stephen Whiteley [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 26, 2005 9:30 AM
To: CF-Talk
Subject: Re: Recursion anyone?
Thanks Kerry
I'm starting to understand, got no experience of cfscript but it seems a lot
like actionscript.
Unfortunately I've tried to run the code and I'm getting the following
error.
Context validation error for tag cfscript.
The start tag must have a matching end tag. An explicit end tag can be
provided by adding /cfscript. If the body of the tag is empty you can use
the shortcut cfscript .../.
This is the exact code
cfquery datasource=#DSN# name=getAllCategories
SELECT itemid,parentitemid,adcategoryname FROM tblAdvertTypes
/cfquery
cfscript
variables.inst.menuqry = getAllCategories;
function buildmenu(currentid,depth){
var i=0;
for(i=1; i lte parentitemid.menuqry.recorcount; i=i+1){
if(variables.inst.menuqry.parentitemid[i] eq arguments.currentID)
writeoutput(repeatstring(,arguments.depth)variables.menuqry.adcategoryna
me[i]br);
buildmenu(variables.inst.menuqry.itemid[i],arguments.depth+1);
}
}
buildmenu(10,0)
/cfscript
Steve
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222310
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cf code doesn't work inside the custom tag's calling tag?
Johnny, You can't embed CF code inside of tags (CF or imported custom)...try this: cfif structKeyExists(attribute, view) my:tag view=#attributes.view# cfelse my:tag /cfif On 10/26/05, Johnny Le [EMAIL PROTECTED] wrote: Hi, If you call custom tag using cfimport, you don't seem to be able to use cf code inside the calling tag. For example: cfimport prefix=my taglib=/my/custom/tags/library// my:tag cfif structKeyExists(attributes, view)view=#attributes.view/cfif/ This will throw an error because the custom tag doesn't recognize cfif as a valid attribute name. Does anyone has a work-around that? Johnny ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222311 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cf code doesn't work inside the custom tag's calling tag?
my:tag cfif structKeyExists(attributes,
view)view=#attributes.view/cfif/
This will throw an error because the custom tag doesn't recognize cfif as a
valid attribute name. Does anyone has a work-around that?
Would something like this work?
my:tag #iif(structKeyExists(attributes,'view'), DE(attributes.view), DE(''))#/
--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
C code. C code run. Run code run. Please!
- Cynthia Dunning
Confidentiality Notice: This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222312
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cf code doesn't work inside the custom tag's calling tag?
cfimport prefix=my taglib=/my/custom/tags/library// cfif structKeyExists(attributes, view) my:tag view=#attributes.view#/ cfelse my:tag / /cfif On 10/26/05, Johnny Le [EMAIL PROTECTED] wrote: Hi, If you call custom tag using cfimport, you don't seem to be able to use cf code inside the calling tag. For example: cfimport prefix=my taglib=/my/custom/tags/library// my:tag cfif structKeyExists(attributes, view)view=#attributes.view/cfif/ This will throw an error because the custom tag doesn't recognize cfif as a valid attribute name. Does anyone has a work-around that? Johnny ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222313 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFMail Undelivr Folder
The Undelivr folder is meant for garbled up and mangled messages, or those where a communication failure occurred. It is not meant for mailbox does not exist at destination messages, where no communication or malformed messages occurred. -Original Message- From: Dave Ashworth [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 26, 2005 09:29 To: CF-Talk Subject: CFMail Undelivr Folder Hi I am developing a mail campaign application that amongst the stats on mail-outs shows the number of undeliveable mails (or at least I'm hoping it will) To try and fill the C:\CFusionMX\Mail\Undelivr with some files in order to begin coding, I added some addresses to the mailing list that I knew to be incorrect and sent out the mail. For example, I sent on to [EMAIL PROTECTED], to which I got a message through to [EMAIL PROTECTED] saying user unknown from our mailserver, as I always do as I administer the mail server. But there was no record of this in the undeliverable folder. I then altered the address to read .oc.uk, but still nothing in the undeliverable folder. So, my question is, under what circumstances is the undeliverable folder populated? Does it take a while for files to appear there whilst email messages are attempted to be delivered? I thought it may have something to do with internal dev servers and sending the mail through our external mail server, but I've tested remotely and still nothing in the folder! Any advice welcome Thanks Dave ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222314 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFMail Undelivr Folder
Mails only end up in the Undelivr folder if it is so malformed that it cannot be validated in the first place OR your mail server is down. Bounces will appear in the mailbox of the account set in the reply headers of the mail you send. You should use CFPOP or equivalent to process the bounce messages. Paul ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222315 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Credit card verification
Anyone who is doing this kind of work -- make sure you read all the details available from your Gateway provider. I work with Verisign PayFlowPro and, according to their docs, when you do this kind of authorize it DOES place a hold on the funds. Then, depending on whether you VOID or CREDIT the authorization, it could be 1-3 days or MORE before the hold is taken back off the funds again. Just an FYI. Different Gateway providers have different rules, I think. Read carefully. J Matthew Small wrote: You should be able to authorize the charge. This is typically done at gas stations - they authorize up to $75, then cancel the transaction. It should never show up unless you actually charge the amount or if you forget to remove the authorization. Matthew Small Web Developer American City Business Journals 704-973-1045 [EMAIL PROTECTED] -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Monday, October 24, 2005 1:32 PM To: CF-Talk Subject: Credit card verification Is there a way to verify that a credit card exists and is assigned to a person short of charging them? In the past we had to set a refundable dollar to do this but I'm hoping that there is a new solution, maybe using paypal. Thanks ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222316 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: Posting relevancy or JMunson, please modify your subject [WAS Re: Problem with MySQL]
My pet peeve with the CF-Talk list? Folks who go way off the topic of the original post but leave the subject heading intact. On 10/26/05, Munson, Jacob [EMAIL PROTECTED] wrote: Yes, these are both issues many of us have dealt with, and yes there may be a lot of folks on this list that could and probably would help me. But there are better places to ask these questions than a ColdFusion list. I find that managing the CF-Talk list as nested conversations through gmail is very easy. And I also take advantage of the filtering capability to flag messages I'm likely to be interested in. Thanks in no small part to JMunson's response to the previous thread, a whole bunch of messages with a topic I'm interested in (MySQL) wer flagged as relevant when it's just someone complaining about a topic and others (rightly) refuting the post. So I'd suggest getting a Gmail account, using filters, and keeping post subjects somewhat in the right ballpark about the content if you take the thread off-topic. Course maybe I'm in the minority as well. -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222317 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Import CustomTag Dir with Subdirs
The names of the folders don't change, but the path of the application could change. If I develop an application that has multiple functions and I want to break out a part of that functionality and move it somewhere else, then I have to go through and change the cfimport of all of my pages. Or another what if, what if my boss decides that part of the application that previously wasn't secure needs to be secure. Normally I would have a few options in securing that application, with cfimport I now have the added headache of not being able to move the files that need to be secured without having to potentially change the paths of cfimport. Not every solution can be thought of well in advance. Planning for unexpected changes is what I try to do and without having the flexibility of being able to point to where the root of my application is then cfimport becomes unusable for me and for many others. Bob Everland You shouldn't be randomly changing the names of folders within your application anyway. If your custom tags are in a folder called tags then that's where they should stay. If the name of this fodler is changing then you have not developed your application very well. -- Russ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222318 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
context feature in Verity CF7
Been using the new context feature in verity CF7. The problem i have is that when verity grabs a section of text from an article to use as the output for the context, it also grabs parts of the surrounding HTML. So that when i go to ouput the results of a search it can totally skew the display of ther result set. i.e. huge html tables and images appearing. Any way to get around this? as of now i have disabled the context ouput, which is a shame because it look quite good otherwise. Paul Stewart Site Developer [EMAIL PROTECTED] www.whichfranchise.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222319 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Simple SQL
On 10/26/05, Charlie Hanlon [EMAIL PROTECTED] wrote:
John Paul,
You stated
I'd *always* use the SQL standard of explictly stating the joins instead of
just letting the db figure it out
Is this a best practice that I should adopt. I am self-taught and am not
aware that explictly joining the tables is more efficient than joining the
tables in the 'Where' clause'.
Short answer is yes, you should. While most databases accept the older
format of just listing the tables in the FROM clause, you have a lot
more flexibility with the SQL-92 syntax of
{INNER|LEFT|RIGHT|FULL|OUTER|CROSS} JOIN that specifically sets what
columns/criteria you're joining *on*. That standard's been around
since, well, 1992, so its rare to find a db that doesn't support it.
Not only is it easier to read what's going on (for example, you'd have
to explicitly do a CROSS JOIN to get the results you were getting --
which would be a dead giveaway that somethings wrong) but you can also
do non-equi joins if you need to and the db supports it (non-equijoins
allow you to join using two columns and an expression, like 10
instead of just the = sign).
Under the hood, the SQL parser in your database will translate two
equivalent queries to the same execution plan, so it's not more
efficient to use this syntax per se, but it is more standard, more
readable, and more flexible -- and less prone to errors as your
problems shows :)
thanks in advance for your clarification/confirmation...
rgds,
Charlie Hanlon
- Original Message -
From: John Paul Ashenfelter [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Wednesday, October 26, 2005 9:59 AM
Subject: Re: Simple SQL
On 10/26/05, Saturday (Stuart Kidd) [EMAIL PROTECTED] wrote:
Hi guys,
I'm trying to do a simple query but am having a blank and pulling
multiples.
!--- get all event details and their corresponding
music genre type ---
cfquery datasource=user020 name=GetEvents
SELECT e.eventID, e.eventName, e.eventTeaser,
e.eventDate, m.musicGenreID, m.musicGenreName
FROM tbl_020eventDetails e, tbl_020musicGenres m
WHERE e.eventDate = #DateAdd(d, -1, UKtodayDate)#
ORDER BY e.eventDate ASC
/cfquery
What i'd like it to do is pull each event and the corresponding music
genre but instead each record is getting pulled multiple times all
with the same musicGenreID details.
Are you getting a cross join? Sounds like it -- I don't see what
relates the tables in your query.
I'd *always* use the SQL standard of explictly stating the joins
instead of just letting the db figure it out
SELECT e.eventID, e.eventName, e.eventTeaser, e.eventDate,
m.musicGenreID, m.musicGenreName
FROM tbl_020eventDetails e,
INNER JOIN tbl_020musicGenres m ON (whatever relates the tables)
WHERE e.eventDate = #DateAdd(d, -1, UKtodayDate)#
ORDER BY e.eventDate ASC
--
John Paul Ashenfelter
CTO/Transitionpoint
(blog) http://www.ashenfelter.com
(email) [EMAIL PROTECTED]
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222320
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: Posting relevancy or JMunson, please modify your subject [WAS Re: Problem with MySQL]
My pet peeve with the CF-Talk list? Folks who go way off the topic of the original post but leave the subject heading intact. On 10/26/05, Munson, Jacob [EMAIL PROTECTED] wrote: Yes, these are both issues many of us have dealt with, and yes there may be a lot of folks on this list that could and probably would help me. But there are better places to ask these questions than a ColdFusion list. I find that managing the CF-Talk list as nested conversations through gmail is very easy. And I also take advantage of the filtering capability to flag messages I'm likely to be interested in. Thanks in no small part to JMunson's response to the previous thread, a whole bunch of messages with a topic I'm interested in (MySQL) wer flagged as relevant when it's just someone complaining about a topic and others (rightly) refuting the post. So I'd suggest getting a Gmail account, using filters, and keeping post subjects somewhat in the right ballpark about the content if you take the thread off-topic. Course maybe I'm in the minority as well. -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222321 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFMail Undelivr Folder
The problem with using the CF Undelivr folder is that the folder will contain mails that were not delivered to *your* email server. If you want to track mails that were not delivered to the final destination then you will need to either set a bounce-back address and monitor the bounces from your email server or implement an alternative mail system that provides delivery notifications. Regards, Howie --- On Wednesday, October 26, 2005 10:28 AM, Dave Ashworth scribed: --- Hi I am developing a mail campaign application that amongst the stats on mail-outs shows the number of undeliveable mails (or at least I'm hoping it will) To try and fill the C:\CFusionMX\Mail\Undelivr with some files in order to begin coding, I added some addresses to the mailing list that I knew to be incorrect and sent out the mail. For example, I sent on to [EMAIL PROTECTED], to which I got a message through to [EMAIL PROTECTED] saying user unknown from our mailserver, as I always do as I administer the mail server. But there was no record of this in the undeliverable folder. I then altered the address to read .oc.uk, but still nothing in the undeliverable folder. So, my question is, under what circumstances is the undeliverable folder populated? Does it take a while for files to appear there whilst email messages are attempted to be delivered? I thought it may have something to do with internal dev servers and sending the mail through our external mail server, but I've tested remotely and still nothing in the folder! Any advice welcome Thanks Dave ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222322 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Recursion anyone?
Here's a use of treeview.nets treeview with recursion.
http://fullcitymedia.com/apps/treeview
You can download the code here.
http://fullcitymedia.com/apps/treeview/treeview.zip
Take a look, might be similar to what you're looking for.
Emmet
-Original Message-
From: Stephen Whiteley [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 26, 2005 10:30 AM
To: CF-Talk
Subject: Re: Recursion anyone?
Thanks Kerry
I'm starting to understand, got no experience of cfscript but it seems a lot
like actionscript.
Unfortunately I've tried to run the code and I'm getting the following
error.
Context validation error for tag cfscript.
The start tag must have a matching end tag. An explicit end tag can be
provided by adding /cfscript. If the body of the tag is empty you can use
the shortcut cfscript .../.
This is the exact code
cfquery datasource=#DSN# name=getAllCategories
SELECT itemid,parentitemid,adcategoryname FROM tblAdvertTypes
/cfquery
cfscript
variables.inst.menuqry = getAllCategories;
function buildmenu(currentid,depth){
var i=0;
for(i=1; i lte parentitemid.menuqry.recorcount; i=i+1){
if(variables.inst.menuqry.parentitemid[i] eq arguments.currentID)
writeoutput(repeatstring(,arguments.depth)variables.menuqry.adcategoryna
me[i]br);
buildmenu(variables.inst.menuqry.itemid[i],arguments.depth+1);
}
}
buildmenu(10,0)
/cfscript
Steve
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222323
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: Posting relevancy [WAS Re: Problem with MySQL]
My pet peeve with the CF-Talk list? Folks who go way off the topic of the original post but leave the subject heading intact. Very good point, I'll do that in the future. As far as using Gmail, I agree that its pretty sweet for the reasons you stated. I use it at home, but not on this list. I'm at work (hence the stupid corporate disclaimer on all my posts), and my company monitors our Internet usage. People have been reprimanded for too much online activity, and I am hoping that getting emails locally instead of reading them on Gmail will avoid that problem. I guess I could just read this list at home at night, but that would be a huge chore considering the volume of emails this list produces. This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222325 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Recursion anyone?
Thanks, missed that
Still throwing an error though
Variable PARENTITEMID is undefined.
The error occurred in C:\Inetpub\wwwroot\bigtripper\recurse\testfunction.cfm:
line 11
9 : function buildmenu(currentid,depth){
10 : var i=0;
11 : for(i=1; i lte parentitemid.menuqry.recordcount; i=i+1){
12 : if(variables.inst.menuqry.parentitemid[i] eq arguments.currentID)
The code is below:
cfquery datasource=#DSN# name=getAllCategories
SELECT itemid,parentitemid,adcategoryname FROM tblAdvertTypes
/cfquery
cfscript
variables.inst.menuqry = getAllCategories;
function buildmenu(currentid,depth){
var i=0;
for(i=1; i lte parentitemid.menuqry.recordcount; i=i+1){
if(variables.inst.menuqry.parentitemid[i] eq arguments.currentID)
writeoutput(repeatstring(,arguments.depth)variables.menuqry.adcategoryname[i]br);
buildmenu(variables.inst.menuqry.itemid[i],arguments.depth+1);
}
}
buildmenu(1,0);
/cfscript
Thanks
Steve
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222324
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFMail Undelivr Folder
Ok, thanks for that so far so, if the mail is sent from an account on a server I don't have access to, would it be impossible for me to report on undelivered mail, for whatever reason that it might be undeliveable well that's the impression I get from CFPOP anyway Dave On 10/26/05, Paul Vernon [EMAIL PROTECTED] wrote: Mails only end up in the Undelivr folder if it is so malformed that it cannot be validated in the first place OR your mail server is down. Bounces will appear in the mailbox of the account set in the reply headers of the mail you send. You should use CFPOP or equivalent to process the bounce messages. Paul ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222326 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: Posting relevancy [WAS Re: Problem with MySQL]
My pet peeve with the CF-Talk list? Folks who go way off the topic of the original post but leave the subject heading intact. Very good point, I'll do that in the future. Er, what I meant was that I'll change the thread's subject if I change the subject in the future. This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222327 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFChart and MX 6.1
I need to embed the chart image generated by CFCHART into a Word doc or some other format with additional text and data and such. I'm having a hard time getting it to work where the image is completed embedded and no longer referencing the external server. Has anyone played with this? It has to be done on 6.1, the slick new CFDOCUMENT tags in 7 are not an option, unfortunately. Thanks! -Mel ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222328 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Recursion anyone?
11 : for(i=1; i lte parentitemid.menuqry.recordcount; i=i+1){
My original post contains:
variables.inst.menuqry.recordcount
You changed it to:
parentitemid.menuqry.recordcount
Change it back.
p.s.
dude, I dont mind helping with the overall how do i do this, but asking me
to debug simple errors in your code is pushing it.
-Original Message-
From: Stephen Whiteley [mailto:[EMAIL PROTECTED]
Sent: 26 October 2005 15:52
To: CF-Talk
Subject: Re: Recursion anyone?
Thanks, missed that
Still throwing an error though
Variable PARENTITEMID is undefined.
The error occurred in
C:\Inetpub\wwwroot\bigtripper\recurse\testfunction.cfm: line 11
9 : function buildmenu(currentid,depth){
10 : var i=0;
11 : for(i=1; i lte parentitemid.menuqry.recordcount; i=i+1){
12 : if(variables.inst.menuqry.parentitemid[i] eq arguments.currentID)
The code is below:
cfquery datasource=#DSN# name=getAllCategories
SELECT itemid,parentitemid,adcategoryname FROM tblAdvertTypes
/cfquery
cfscript
variables.inst.menuqry = getAllCategories;
function buildmenu(currentid,depth){
var i=0;
for(i=1; i lte parentitemid.menuqry.recordcount; i=i+1){
if(variables.inst.menuqry.parentitemid[i] eq arguments.currentID)
writeoutput(repeatstring(,arguments.depth)variables.menuqry.adcategoryna
me[i]br);
buildmenu(variables.inst.menuqry.itemid[i],arguments.depth+1);
}
}
buildmenu(1,0);
/cfscript
Thanks
Steve
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222329
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Simple SQL
Thanks for that JP, that helped me too. I'll try and make the
gradual change-over to the standard sql-92.
On 26 Oct 2005, at 15:47, John Paul Ashenfelter wrote:
On 10/26/05, Charlie Hanlon [EMAIL PROTECTED] wrote:
John Paul,
You stated
I'd *always* use the SQL standard of explictly stating the joins
instead of
just letting the db figure it out
Is this a best practice that I should adopt. I am self-taught and
am not
aware that explictly joining the tables is more efficient than
joining the
tables in the 'Where' clause'.
Short answer is yes, you should. While most databases accept the older
format of just listing the tables in the FROM clause, you have a lot
more flexibility with the SQL-92 syntax of
{INNER|LEFT|RIGHT|FULL|OUTER|CROSS} JOIN that specifically sets what
columns/criteria you're joining *on*. That standard's been around
since, well, 1992, so its rare to find a db that doesn't support it.
Not only is it easier to read what's going on (for example, you'd have
to explicitly do a CROSS JOIN to get the results you were getting --
which would be a dead giveaway that somethings wrong) but you can also
do non-equi joins if you need to and the db supports it (non-equijoins
allow you to join using two columns and an expression, like 10
instead of just the = sign).
Under the hood, the SQL parser in your database will translate two
equivalent queries to the same execution plan, so it's not more
efficient to use this syntax per se, but it is more standard, more
readable, and more flexible -- and less prone to errors as your
problems shows :)
thanks in advance for your clarification/confirmation...
rgds,
Charlie Hanlon
- Original Message -
From: John Paul Ashenfelter [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Wednesday, October 26, 2005 9:59 AM
Subject: Re: Simple SQL
On 10/26/05, Saturday (Stuart Kidd) [EMAIL PROTECTED] wrote:
Hi guys,
I'm trying to do a simple query but am having a blank and pulling
multiples.
!--- get all event details and their corresponding
music genre type ---
cfquery datasource=user020 name=GetEvents
SELECT e.eventID, e.eventName, e.eventTeaser,
e.eventDate, m.musicGenreID, m.musicGenreName
FROM tbl_020eventDetails e, tbl_020musicGenres m
WHERE e.eventDate = #DateAdd(d, -1, UKtodayDate)#
ORDER BY e.eventDate ASC
/cfquery
What i'd like it to do is pull each event and the corresponding
music
genre but instead each record is getting pulled multiple times all
with the same musicGenreID details.
Are you getting a cross join? Sounds like it -- I don't see what
relates the tables in your query.
I'd *always* use the SQL standard of explictly stating the joins
instead of just letting the db figure it out
SELECT e.eventID, e.eventName, e.eventTeaser, e.eventDate,
m.musicGenreID, m.musicGenreName
FROM tbl_020eventDetails e,
INNER JOIN tbl_020musicGenres m ON (whatever relates the tables)
WHERE e.eventDate = #DateAdd(d, -1, UKtodayDate)#
ORDER BY e.eventDate ASC
--
John Paul Ashenfelter
CTO/Transitionpoint
(blog) http://www.ashenfelter.com
(email) [EMAIL PROTECTED]
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222330
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
adApplication.cfm and Application.cfm
Hi all, I know how the Application.cfm file works and that it is a reserved name for CF. However, when I used the filename adApplication.cfm in a recent project, the server refused to execute that page claiming that Application.cfm was a reserved name (even though my filename contained the word application, the full name was different from the reserved name). Have you encountered this, and if so, what setting did you change in the CF server to allow for adApplication.cfm to exist and be executed normally? Thanks in advance, Roberto Perez [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222331 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CFMail Undelivr Folder
On 10/26/05, Dave Ashworth [EMAIL PROTECTED] wrote: so, if the mail is sent from an account on a server I don't have access to, would it be impossible for me to report on undelivered mail, for whatever reason that it might be undeliveable Since you need an account username and password for cfpop to be able to do its job, the answer would be yes assuming that info is unavailable. Of the previous people who responded on this list, Paul Vernon sells an inexpensive and very much more robust CFPOP replacement (you'll know why you need it if you get really serious about large-scale CFPOP usage). Howie Hamlin sells a replacement mail server that can be configured to provide bounce information to ColdFusion. You won't need both solutions, depending on what you wind up doing, but one or the other will fix you up. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222332 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
ColdFusion Bug :- functions return additional spaces(!)
When a function is called and the result outputted directly, an extra space is prepended! For Example: cffunction name=spaceTest cfargument name=s type=string cfreturn -SPACE HERE /cffunction cfoutputpre What is the space doing at the start of this string: #spaceTest()#. It works the way it should assigned to a variable first: cfset o = spaceTest() No space here - #o# /pre/cfoutput Tested in ColdFusion 6.1 and ColdFusion 7. In CF7 its worse, a carriage return and a space are inserted. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222333 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ColdFusion Bug :- functions return additional spaces(!)
Yes, I found this as well. I did my own work-around, but it is not fit for public reading! Mike -Original Message- From: Peter Coppinger [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 26, 2005 10:22 AM To: CF-Talk Subject: ColdFusion Bug :- functions return additional spaces(!) When a function is called and the result outputted directly, an extra space is prepended! For Example: cffunction name=spaceTest cfargument name=s type=string cfreturn -SPACE HERE /cffunction cfoutputpre What is the space doing at the start of this string: #spaceTest()#. It works the way it should assigned to a variable first: cfset o = spaceTest() No space here - #o# /pre/cfoutput Tested in ColdFusion 6.1 and ColdFusion 7. In CF7 its worse, a carriage return and a space are inserted. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222334 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ColdFusion Bug :- functions return additional spaces(!)
Peter, Could you post your exact code please? The whole test script without the little space here hint? -Mark -Original Message- From: Peter Coppinger [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 26, 2005 10:22 AM To: CF-Talk Subject: ColdFusion Bug :- functions return additional spaces(!) When a function is called and the result outputted directly, an extra space is prepended! For Example: cffunction name=spaceTest cfargument name=s type=string cfreturn -SPACE HERE /cffunction cfoutputpre What is the space doing at the start of this string: #spaceTest()#. It works the way it should assigned to a variable first: cfset o = spaceTest() No space here - #o# /pre/cfoutput Tested in ColdFusion 6.1 and ColdFusion 7. In CF7 its worse, a carriage return and a space are inserted. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222335 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: adApplication.cfm and Application.cfm
thats odd. as i have a file called, myapplication.cfm in a site, and it works fine. tw On 10/26/05, Roberto Perez [EMAIL PROTECTED] wrote: Hi all, I know how the Application.cfm file works and that it is a reserved name for CF. However, when I used the filename adApplication.cfm in a recent project, the server refused to execute that page claiming that Application.cfm was a reserved name (even though my filename contained the word application, the full name was different from the reserved name). Have you encountered this, and if so, what setting did you change in the CF server to allow for adApplication.cfm to exist and be executed normally? Thanks in advance, Roberto Perez [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222336 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ColdFusion Bug :- functions return additional spaces(!)
Hi Mark, The whole script is below. Copy from the - to the next -- and run it. Dan. Mark A Kruger wrote: Peter, Could you post your exact code please? The whole test script without the little space here hint? -Mark -Original Message- From: Peter Coppinger [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 26, 2005 10:22 AM To: CF-Talk Subject: ColdFusion Bug :- functions return additional spaces(!) When a function is called and the result outputted directly, an extra space is prepended! For Example: cffunction name=spaceTest cfargument name=s type=string cfreturn -SPACE HERE /cffunction cfoutputpre What is the space doing at the start of this string: #spaceTest()#. It works the way it should assigned to a variable first: cfset o = spaceTest() No space here - #o# /pre/cfoutput Tested in ColdFusion 6.1 and ColdFusion 7. In CF7 its worse, a carriage return and a space are inserted. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222337 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ColdFusion Bug :- functions return additional spaces(!)
Not a bug. Just normal CF creation of white space. Simlpy add output=false to your cffunction. Problem solved. On 10/26/05, Peter Coppinger [EMAIL PROTECTED] wrote: When a function is called and the result outputted directly, an extra space is prepended! For Example: cffunction name=spaceTest cfargument name=s type=string cfreturn -SPACE HERE /cffunction cfoutputpre What is the space doing at the start of this string: #spaceTest()#. It works the way it should assigned to a variable first: cfset o = spaceTest() No space here - #o# /pre/cfoutput Tested in ColdFusion 6.1 and ColdFusion 7. In CF7 its worse, a carriage return and a space are inserted. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222338 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: adApplication.cfm and Application.cfm
Roberto, Maybe its because you have Application capitalized in your filename? Maybe if you change it to adapplication.cfm or ad_application.cfm. -Original Message- From: Tony [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 26, 2005 9:31 AM To: CF-Talk Subject: Re: adApplication.cfm and Application.cfm thats odd. as i have a file called, myapplication.cfm in a site, and it works fine. tw On 10/26/05, Roberto Perez [EMAIL PROTECTED] wrote: Hi all, I know how the Application.cfm file works and that it is a reserved name for CF. However, when I used the filename adApplication.cfm in a recent project, the server refused to execute that page claiming that Application.cfm was a reserved name (even though my filename contained the word application, the full name was different from the reserved name). Have you encountered this, and if so, what setting did you change in the CF server to allow for adApplication.cfm to exist and be executed normally? This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222339 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ColdFusion Bug :- functions return additional spaces(!)
When a function is called and the result outputted directly, an extra space is prepended! It looks like the space isn't being prepended to the return value, but ColdFusion is outputting whitespace from within the CFFUNCTION tag when it is called. Even more interesting, it's only outputting whitespace AFTER the last CFARGUMENT tag. So if you put a CFSILENT within the CFFUNCTION immediately after the last CFARGUMENT tag, it will suppress the whitespace. Close the CFSILENT right after the CFRETURN is called. This appears to be a viable workaround. Plug this into your previous example... cffunction name=spaceTest cfargument name=s type=stringcfsilent cfreturn -NO MORE SPACE HERE /cfsilent /cffunction Tested in CF 7. -Justin Scott ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222340 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: context feature in Verity CF7
What I do is use a marker for context, like __000___. Then strip it
out. Here is an example:
cfscript
function contextFix(str) {
str = rereplace(str, .*?,,all);
str = rereplace(str, .*$,,all);
// str = htmlEditFormat(str);
str = replace(str, ___000___, span style=background-color:
yellow; , all);
str = replace(str, ___999___, /span, all);
str = str brbr;
return str;
}
/cfscript
cfsearch collection=foo criteria=#lCase(form.searchTerms)#
type=simple name=mainresults status=status suggestions=always
contextPassages=3 contextHighlightBegin=___000___
contextHighlightEnd=___999___
On 10/26/05, Paul Stewart [EMAIL PROTECTED] wrote:
Been using the new context feature in verity CF7. The problem i have is that
when verity grabs a section of text from an article to use as the output for
the context, it also grabs parts of the surrounding HTML. So that when i go
to ouput the results of a search it can totally skew the display of ther
result set. i.e. huge html tables and images appearing.
Any way to get around this? as of now i have disabled the context ouput,
which is a shame because it look quite good otherwise.
Paul Stewart
Site Developer
[EMAIL PROTECTED]
www.whichfranchise.com
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222341
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Recursion anyone?
buildmenu(10,0);
/cfscript
-Original Message-
From: Stephen Whiteley [mailto:[EMAIL PROTECTED]
Sent: 26 October 2005 15:30
To: CF-Talk
Subject: Re: Recursion anyone?
Thanks Kerry
I'm starting to understand, got no experience of cfscript but it seems a lot
like actionscript.
Unfortunately I've tried to run the code and I'm getting the following
error.
Context validation error for tag cfscript.
The start tag must have a matching end tag. An explicit end tag can be
provided by adding /cfscript. If the body of the tag is empty you can use
the shortcut cfscript .../.
This is the exact code
cfquery datasource=#DSN# name=getAllCategories
SELECT itemid,parentitemid,adcategoryname FROM tblAdvertTypes
/cfquery
cfscript
variables.inst.menuqry = getAllCategories;
function buildmenu(currentid,depth){
var i=0;
for(i=1; i lte parentitemid.menuqry.recorcount; i=i+1){
if(variables.inst.menuqry.parentitemid[i] eq arguments.currentID)
writeoutput(repeatstring(,arguments.depth)variables.menuqry.adcategoryna
me[i]br);
buildmenu(variables.inst.menuqry.itemid[i],arguments.depth+1);
}
}
buildmenu(10,0)
/cfscript
Steve
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222342
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: ColdFusion Bug :- functions return additional spaces(!)
This isn't a bug...add output=false to your cffunction tag (and your cfcomponent tag) to suppress output inside of them. Cheers, Joe On 10/26/05, Peter Coppinger [EMAIL PROTECTED] wrote: When a function is called and the result outputted directly, an extra space is prepended! For Example: cffunction name=spaceTest cfargument name=s type=string cfreturn -SPACE HERE /cffunction cfoutputpre What is the space doing at the start of this string: #spaceTest()#. It works the way it should assigned to a variable first: cfset o = spaceTest() No space here - #o# /pre/cfoutput Tested in ColdFusion 6.1 and ColdFusion 7. In CF7 its worse, a carriage return and a space are inserted. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222343 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CF Standard and CF Multi-Server on Same Hardware
Is it possible to run CF7 Standard (with license) and CF7 Developer version (running in multi-instance mode) on the same server hardware (Windows 2003/IIS6) at the same time? On a development server, I currently have CF7 Standard installed and running with the license. That, obviously, gives me the ability to allow more than two users to access the site. This site contains some heavy-processing scripts that I want to keep off of our primary web server. The two-user developer mode will prevent all users that need to access this web site. In addition, I want to install CF7 Enterprise/Developer on the same server, but make sure CF7 Standard still runs by itself. Does this seem feasible? M!chael A Dawson Database Administrator and Manager of Web Applications Office of Technology Services University of Evansville 1800 Lincoln Avenue Evansville, IN 47722 812-488-2581 MSN Messenger ID: [EMAIL PROTECTED] There are 10 types of people in the world: Those who understand binary numbers and those who don't. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222344 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ColdFusion Bug :- functions return additional spaces(!)
might i suggest output=false? cffunction name=spaceTest output=false -Original Message- From: Justin D. Scott [mailto:[EMAIL PROTECTED] Sent: 26 October 2005 16:29 To: CF-Talk Subject: RE: ColdFusion Bug :- functions return additional spaces(!) When a function is called and the result outputted directly, an extra space is prepended! It looks like the space isn't being prepended to the return value, but ColdFusion is outputting whitespace from within the CFFUNCTION tag when it is called. Even more interesting, it's only outputting whitespace AFTER the last CFARGUMENT tag. So if you put a CFSILENT within the CFFUNCTION immediately after the last CFARGUMENT tag, it will suppress the whitespace. Close the CFSILENT right after the CFRETURN is called. This appears to be a viable workaround. Plug this into your previous example... cffunction name=spaceTest cfargument name=s type=stringcfsilent cfreturn -NO MORE SPACE HERE /cfsilent /cffunction Tested in CF 7. -Justin Scott ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222345 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF Standard and CF Multi-Server on Same Hardware
On Wednesday 26 October 2005 16:39, Dawson, Michael wrote: Is it possible to run CF7 Standard (with license) and CF7 Developer version (running in multi-instance mode) on the same server hardware (Windows 2003/IIS6) at the same time? Yes. Run them on different ports, and installed into different directories. -- Tom Chiverton Advanced ColdFusion Programmer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222346 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF Standard and CF Multi-Server on Same Hardware
Yup, you can do this. Just run the installer again. Andy On 26/10/05, Dawson, Michael [EMAIL PROTECTED] wrote: Is it possible to run CF7 Standard (with license) and CF7 Developer version (running in multi-instance mode) on the same server hardware (Windows 2003/IIS6) at the same time? On a development server, I currently have CF7 Standard installed and running with the license. That, obviously, gives me the ability to allow more than two users to access the site. This site contains some heavy-processing scripts that I want to keep off of our primary web server. The two-user developer mode will prevent all users that need to access this web site. In addition, I want to install CF7 Enterprise/Developer on the same server, but make sure CF7 Standard still runs by itself. Does this seem feasible? M!chael A Dawson Database Administrator and Manager of Web Applications Office of Technology Services University of Evansville 1800 Lincoln Avenue Evansville, IN 47722 812-488-2581 MSN Messenger ID: [EMAIL PROTECTED] There are 10 types of people in the world: Those who understand binary numbers and those who don't. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222347 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ColdFusion Bug :- functions return additional spaces(!)
Simply add output=false to your cffunction. Problem solved. Simple as that, I feel thick - Thanks Ray!!! RTFM eh! lol -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 26 October 2005 16:33 To: CF-Talk Subject: Re: ColdFusion Bug :- functions return additional spaces(!) Not a bug. Just normal CF creation of white space. Simlpy add output=false to your cffunction. Problem solved. On 10/26/05, Peter Coppinger [EMAIL PROTECTED] wrote: When a function is called and the result outputted directly, an extra space is prepended! For Example: cffunction name=spaceTest cfargument name=s type=string cfreturn -SPACE HERE /cffunction cfoutputpre What is the space doing at the start of this string: #spaceTest()#. It works the way it should assigned to a variable first: cfset o = spaceTest() No space here - #o# /pre/cfoutput Tested in ColdFusion 6.1 and ColdFusion 7. In CF7 its worse, a carriage return and a space are inserted. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222348 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Flex Builder 2 and the CFadapter
Also last night an update to the CFAdapter as well as 2 simple examples were posted on the wiki. I would download the samples and take a look at those. ---nimer -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 26, 2005 7:13 AM To: CF-Talk Subject: Re: Flex Builder 2 and the CFadapter For all Flex 2 discussion, these 6 forums are where all the discussions are happening now: http://labs.macromedia.com/community/ For Flex Builder 2 + CF Adapter discussion: http://labs.macromedia.com/wiki/index.php/Talk:CF_Adapter Damon ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222349 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CF-Administrator CFMX 6.1 - Schedule a task for every two weeks
I don't see how to schedule a task to run every two weeks, rather than every week, in the CFAdmin. Can I set the task to run daily, every 288 hours? Thanks, Matt Small ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222350 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Recursion anyone?
On Wednesday 26 October 2005 16:03, Kerry wrote: dude, I dont mind helping with the overall how do i do this, but asking me to debug simple errors in your code is pushing it. This is why most of the time I will only post pseudo-code, unless there is some important point the code needs to get across. I'm all for offering 'how to' and the odd bit of skeleton code, but I don't develop ColdFusion code for free :-) Although, OTOH the list does need to cater for all ability types, and sometimes that does mean a fully worked up example, I suppose. -- Tom Chiverton Advanced ColdFusion Programmer ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222351 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF Standard and CF Multi-Server on Same Hardware
So, if I run the single-server install first, license it, then run the multi-instance install, will CF automatically find the next-available port? Or, will I need to edit some xml file? Thanks for your help M!ke -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 26, 2005 10:45 AM To: CF-Talk Subject: Re: CF Standard and CF Multi-Server on Same Hardware On Wednesday 26 October 2005 16:39, Dawson, Michael wrote: Is it possible to run CF7 Standard (with license) and CF7 Developer version (running in multi-instance mode) on the same server hardware (Windows 2003/IIS6) at the same time? Yes. Run them on different ports, and installed into different directories. -- Tom Chiverton Advanced ColdFusion Programmer ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222352 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: Yet another regex question
Hi, Sorry for OT, but stumped. I need a regex (or any CF5 solution) to change all uuid's within a txt file to uppercase. They are all in quotes and preceded by id=. ie. id=38d4db48-7a05-491a-b258-675ddb02fd0e Thanks in advance to all and any advice Dave ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222353 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF Standard and CF Multi-Server on Same Hardware
The installer will detect that Server Config mode is installed and tell you that you can only install using Multi-Server or EAR/WAR. If you go with the Multi-server it will install on port 8300 by default. On 26/10/05, Dawson, Michael [EMAIL PROTECTED] wrote: So, if I run the single-server install first, license it, then run the multi-instance install, will CF automatically find the next-available port? Or, will I need to edit some xml file? Thanks for your help M!ke -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 26, 2005 10:45 AM To: CF-Talk Subject: Re: CF Standard and CF Multi-Server on Same Hardware On Wednesday 26 October 2005 16:39, Dawson, Michael wrote: Is it possible to run CF7 Standard (with license) and CF7 Developer version (running in multi-instance mode) on the same server hardware (Windows 2003/IIS6) at the same time? Yes. Run them on different ports, and installed into different directories. -- Tom Chiverton Advanced ColdFusion Programmer ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222354 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Recursion anyone?
Just had a read of the code, it does 2 queries for every parent in the
database?
Did I read that correctly?
-Original Message-
From: Emmet McGovern [mailto:[EMAIL PROTECTED]
Sent: 26 October 2005 15:49
To: CF-Talk
Subject: RE: Recursion anyone?
Here's a use of treeview.nets treeview with recursion.
http://fullcitymedia.com/apps/treeview
You can download the code here.
http://fullcitymedia.com/apps/treeview/treeview.zip
Take a look, might be similar to what you're looking for.
Emmet
-Original Message-
From: Stephen Whiteley [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 26, 2005 10:30 AM
To: CF-Talk
Subject: Re: Recursion anyone?
Thanks Kerry
I'm starting to understand, got no experience of cfscript but it seems a lot
like actionscript.
Unfortunately I've tried to run the code and I'm getting the following
error.
Context validation error for tag cfscript.
The start tag must have a matching end tag. An explicit end tag can be
provided by adding /cfscript. If the body of the tag is empty you can use
the shortcut cfscript .../.
This is the exact code
cfquery datasource=#DSN# name=getAllCategories
SELECT itemid,parentitemid,adcategoryname FROM tblAdvertTypes
/cfquery
cfscript
variables.inst.menuqry = getAllCategories;
function buildmenu(currentid,depth){
var i=0;
for(i=1; i lte parentitemid.menuqry.recorcount; i=i+1){
if(variables.inst.menuqry.parentitemid[i] eq arguments.currentID)
writeoutput(repeatstring(,arguments.depth)variables.menuqry.adcategoryna
me[i]br);
buildmenu(variables.inst.menuqry.itemid[i],arguments.depth+1);
}
}
buildmenu(10,0)
/cfscript
Steve
~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222355
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF Standard and CF Multi-Server on Same Hardware
Thanks! -Original Message- From: Andy Allan [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 26, 2005 11:21 AM To: CF-Talk Subject: Re: CF Standard and CF Multi-Server on Same Hardware The installer will detect that Server Config mode is installed and tell you that you can only install using Multi-Server or EAR/WAR. If you go with the Multi-server it will install on port 8300 by default. On 26/10/05, Dawson, Michael [EMAIL PROTECTED] wrote: So, if I run the single-server install first, license it, then run the multi-instance install, will CF automatically find the next-available port? Or, will I need to edit some xml file? Thanks for your help M!ke -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 26, 2005 10:45 AM To: CF-Talk Subject: Re: CF Standard and CF Multi-Server on Same Hardware On Wednesday 26 October 2005 16:39, Dawson, Michael wrote: Is it possible to run CF7 Standard (with license) and CF7 Developer version (running in multi-instance mode) on the same server hardware (Windows 2003/IIS6) at the same time? Yes. Run them on different ports, and installed into different directories. -- Tom Chiverton Advanced ColdFusion Programmer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222356 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Recursion anyone?
make that 1 query for every parent, + 1 query for each child of each parent.
-Original Message-
From: Emmet McGovern [mailto:[EMAIL PROTECTED]
Sent: 26 October 2005 15:49
To: CF-Talk
Subject: RE: Recursion anyone?
Here's a use of treeview.nets treeview with recursion.
http://fullcitymedia.com/apps/treeview
You can download the code here.
http://fullcitymedia.com/apps/treeview/treeview.zip
Take a look, might be similar to what you're looking for.
Emmet
-Original Message-
From: Stephen Whiteley [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 26, 2005 10:30 AM
To: CF-Talk
Subject: Re: Recursion anyone?
Thanks Kerry
I'm starting to understand, got no experience of cfscript but it seems a lot
like actionscript.
Unfortunately I've tried to run the code and I'm getting the following
error.
Context validation error for tag cfscript.
The start tag must have a matching end tag. An explicit end tag can be
provided by adding /cfscript. If the body of the tag is empty you can use
the shortcut cfscript .../.
This is the exact code
cfquery datasource=#DSN# name=getAllCategories
SELECT itemid,parentitemid,adcategoryname FROM tblAdvertTypes
/cfquery
cfscript
variables.inst.menuqry = getAllCategories;
function buildmenu(currentid,depth){
var i=0;
for(i=1; i lte parentitemid.menuqry.recorcount; i=i+1){
if(variables.inst.menuqry.parentitemid[i] eq arguments.currentID)
writeoutput(repeatstring(,arguments.depth)variables.menuqry.adcategoryna
me[i]br);
buildmenu(variables.inst.menuqry.itemid[i],arguments.depth+1);
}
}
buildmenu(10,0)
/cfscript
Steve
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222357
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
REGEX Repository
I recently found a repository of over 500 canned REGEX expressions that might help those of us who only use it once every six months, and forget it all in the meantime: http://regexlib.com/ Rick Colman ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222358 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
SOT: Source Control Theory.....
Hey all, We recently moved from VSS to SVN (please quit with the applause) and while we are using it we aren't taking full advantage of it. Ie branching, merging etc. Right now it's just a update, commit thing for us to keep our code sync'd between developers. I'm looking to see if anyone out there has a best practices guide, or better yet can share your corporate policy on how source control is to be used in your office. We are a small development shop (4 developers full time) and we work on multiple sites at once. I'm not sure if the who merging and branching is really for us but i'd like to see how other development shops are doing it, so we can get an idea of what we might be missing. feel free to post public or private. TIA jonese ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222359 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: REGEX Repository
been there many times. Its an invaluable resource. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222360 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Recursion anyone?
You're correct. It simply reincludes itself till it no longer finds a
dependency. I know there are more efficient ways to do it but it works for
this example.
This discussion forces me to revisit. One day I'll purty it up a bit more
and put it up for download somewhere. Haven't looked at it for some time.
Emmet
-Original Message-
From: Kerry [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 26, 2005 12:23 PM
To: CF-Talk
Subject: RE: Recursion anyone?
make that 1 query for every parent, + 1 query for each child of each parent.
-Original Message-
From: Emmet McGovern [mailto:[EMAIL PROTECTED]
Sent: 26 October 2005 15:49
To: CF-Talk
Subject: RE: Recursion anyone?
Here's a use of treeview.nets treeview with recursion.
http://fullcitymedia.com/apps/treeview
You can download the code here.
http://fullcitymedia.com/apps/treeview/treeview.zip
Take a look, might be similar to what you're looking for.
Emmet
-Original Message-
From: Stephen Whiteley [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 26, 2005 10:30 AM
To: CF-Talk
Subject: Re: Recursion anyone?
Thanks Kerry
I'm starting to understand, got no experience of cfscript but it seems a lot
like actionscript.
Unfortunately I've tried to run the code and I'm getting the following
error.
Context validation error for tag cfscript.
The start tag must have a matching end tag. An explicit end tag can be
provided by adding /cfscript. If the body of the tag is empty you can use
the shortcut cfscript .../.
This is the exact code
cfquery datasource=#DSN# name=getAllCategories
SELECT itemid,parentitemid,adcategoryname FROM tblAdvertTypes
/cfquery
cfscript
variables.inst.menuqry = getAllCategories;
function buildmenu(currentid,depth){
var i=0;
for(i=1; i lte parentitemid.menuqry.recorcount; i=i+1){
if(variables.inst.menuqry.parentitemid[i] eq arguments.currentID)
writeoutput(repeatstring(,arguments.depth)variables.menuqry.adcategoryna
me[i]br);
buildmenu(variables.inst.menuqry.itemid[i],arguments.depth+1);
}
}
buildmenu(10,0)
/cfscript
Steve
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222361
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF Standard and CF Multi-Server on Same Hardware
And while we're at it, you can map individual vhosts / directories in your web server to different CF instances, so you can run them all through your web server on port 80, even though they're hitting different CF. We do this so we can easily test our codebase on both CF6.1 and CF7. cheers, barneyb -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222362 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Credit card verification
May also depend on the clearing network and card type with regards to how long an authorization is held. Cheers, Stace -Original Message- From: Jann E. VanOver [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 26, 2005 10:42 AM To: CF-Talk Subject: Re: Credit card verification Anyone who is doing this kind of work -- make sure you read all the details available from your Gateway provider. I work with Verisign PayFlowPro and, according to their docs, when you do this kind of authorize it DOES place a hold on the funds. Then, depending on whether you VOID or CREDIT the authorization, it could be 1-3 days or MORE before the hold is taken back off the funds again. Just an FYI. Different Gateway providers have different rules, I think. Read carefully. J Matthew Small wrote: You should be able to authorize the charge. This is typically done at gas stations - they authorize up to $75, then cancel the transaction. It should never show up unless you actually charge the amount or if you forget to remove the authorization. Matthew Small Web Developer American City Business Journals 704-973-1045 [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222363 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Yet another regex question
rereplace(str, 'id=(.*?)', 'id=\U\1', 'all') if you have any other id= attributes it will convert those too... something like div id=mydiv so if your UUIDs are all 4 parts separated by a hyphen...use this rereplace(str, 'id=(.*?-.*?-.*?-.*?)', 'id=\U\1', 'all') ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Dave Francis [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 26, 2005 12:20 PM To: CF-Talk Subject: OT: Yet another regex question Hi, Sorry for OT, but stumped. I need a regex (or any CF5 solution) to change all uuid's within a txt file to uppercase. They are all in quotes and preceded by id=. ie. id=38d4db48-7a05-491a-b258-675ddb02fd0e Thanks in advance to all and any advice Dave ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222364 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: SOT: Source Control Theory.....
Basically a branch is a way to work on two things in parallel, without stepping on each other's toes, but with an 'easy' way to reconcile the two end products back into a single version. So if you and I need to work on the same code, I can launch a branch from our starting point while you work on the trunk (main branch). When I'm done, I can merge my changes into the trunk, often with no manual intervention. As I see it, there are two main uses for branches: 1) releases. When you do a release of your software and need to fix a bug, you'd launch a branch of the exact release code, and fix the bug there. That way any subsequent mods you've made on the trunk don't get in the way when you're making your patch for the bug, but it's still easy to merge the bugfix into your trunk so it's there for the next release 2) concurrent development. When you've got two things that need to be done, and both of them need to happen in isolation (because working on them at the same time will be problematic, or one of them is experimental and might not actually be used, or whatever), a branch is perfect. You launch a branch, do you stuff, and if/when it comes time to integrate back into the trunk, it's easy to do. Where I work, we maintain the trunk, and a 'staging' branch, which is current production codebase. We split off branches from the trunk as needed (for scenario 2), and all dev work that happens to the staging branch is done in subbranches, thereby ensuring that the actual staging branch is always an exact mirror of production. I'd highly recommend the SVN book (http://svnbook.red-bean.com), as it's got some good foundation knowledge about SVN, as well as some good examples. cheers, barneyb On 10/26/05, jonese [EMAIL PROTECTED] wrote: Hey all, We recently moved from VSS to SVN (please quit with the applause) and while we are using it we aren't taking full advantage of it. Ie branching, merging etc. Right now it's just a update, commit thing for us to keep our code sync'd between developers. I'm looking to see if anyone out there has a best practices guide, or better yet can share your corporate policy on how source control is to be used in your office. We are a small development shop (4 developers full time) and we work on multiple sites at once. I'm not sure if the who merging and branching is really for us but i'd like to see how other development shops are doing it, so we can get an idea of what we might be missing. feel free to post public or private. TIA jonese -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222365 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Best Practices for Multiple Instances/Sites on IIS (was RE: CF Standard and CF Multi-Server on Same Hardware)
This is what I did: * In addition to the default IIS web site, I created two new web sites. They are named: Default Web Site, Dev and Test * I installed CF stand-alone only on Dev. It works fine. * I installed CF multi-server instance only on Test. It works fine. * Default Web Site cannot yet serve CF pages. That is expected. Now, can someone show me any best practices for web sites/instances? I've read many articles about this, but none really say which web site should host the first/primary instance. By Primary Instance, when I used the instance manager in CF6.1, I remember having to administer all intances from the first-created instance. In other words, if I created Instance2, I could *not* use Instance2 to create other instances. If that is still the same issue, how do you recommend I configure the IIS sites and CF instances? I have full control of this server. I use a separate IP address for each IIS site. I want to be able to create instances as needed, but not have the Jrun Admin and Jrun Cfusion services running all the time. I'm going to go through the livedocs for the CF multi-server install for the details, but they don't really show how sites/instances are configured according to best practices. I'm not against completely uninstalling CF or even rebuilding the entire server. After a couple times of building a server and installing CF I can create some good documentation for later installs. Thanks M!ke -Original Message- From: Andy Allan [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 26, 2005 11:21 AM To: CF-Talk Subject: Re: CF Standard and CF Multi-Server on Same Hardware The installer will detect that Server Config mode is installed and tell you that you can only install using Multi-Server or EAR/WAR. If you go with the Multi-server it will install on port 8300 by default. On 26/10/05, Dawson, Michael [EMAIL PROTECTED] wrote: So, if I run the single-server install first, license it, then run the multi-instance install, will CF automatically find the next-available port? Or, will I need to edit some xml file? Thanks for your help M!ke ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222366 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: Yet another regex question
Unfortunately, the CF5 regex engine is a bit lacking in some areas. You can find the string with this: id=[a-z0-9-]+ Please note that that captures the id= and quotes as well. At this point, you can either use the ReExtract function (found on CFLib.org) or extract the string manually. ucase() the string, and re-insert into the original. Also, if these text files are big, please keep in mind that CF5 had a pretty strict limit on the size of file it could work with -- I think for refind() it was around 20k, so you may need to split them up if they're big. --Ben Dave Francis wrote: Hi, Sorry for OT, but stumped. I need a regex (or any CF5 solution) to change all uuid's within a txt file to uppercase. They are all in quotes and preceded by id=. ie. id=38d4db48-7a05-491a-b258-675ddb02fd0e Thanks in advance to all and any advice Dave ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222367 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: MySQL 5 release
That's coo. I didn't actually know about the script or I would've used it. Thx for the tid bit. On 10/26/05, John Paul Ashenfelter [EMAIL PROTECTED] wrote: On 10/25/05, John C. Bland II [EMAIL PROTECTED] wrote: Just so you know, I upgraded from 4.1 to 5 earlier and all I did was install 5, copy db's to 5's directory, setup all users (could've probably found an easier way but I only needed two...strictly a dev db), That's what the fix_privileges script is for -- all that info is stored in your mysql database (the database *named* mysql). Recreating a couple of users is easy, as you suggest, but for production systems, you want to guarentee everything is the same, so an in-place upgrade of the db is a much better choice. You could amend your approach to Copy all of the databases to 5's directory, ran the fix_privileges on the mysql database, and was ready to go. That way, you've still got both dbs available. Of course it gets trickier if you're dealing with innodb tables or anything else other than MyISAM. and remove the 4.1instance. Oh, I had to restart 5 after that but no sweat. All-in-all, without my forgetting to restart 5, it took like 20 minutes including download time. I understand your hesitation though. If this was a live box I probably would've felt the same way. On 10/25/05, Matt Robertson [EMAIL PROTECTED] wrote: On 10/25/05, John Paul Ashenfelter [EMAIL PROTECTED] wrote: Not sure if you're asking about upgrading MySQL itself from 4-5 or using the MySQL JDBC drivers on CF7 Actually, both although the questions were poorly worded. Thanks. You told me what I needed to know. I hate to say it but I'll probably leave my main mysql server alone for the simple reason its running like 40 web sites and ... well, its working fine. I'd like the new functionality but I can't risk the consequences of a mistake, even for a weekend afternoon or so. I'll save this for when I add a new server. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com http://mysecretbase.com http://mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222368 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Recursion anyone?
Hi Thanks everyone, there's lots of different approaches here which I'll look at over time. Brain got tired in the end! I just thought that with the new CFTREE format options i.e. xml and object, that there could be a quick (and easy) way to do DHTML menus. But I've learnt quite a bit, sorry if I hacked anyone off - the ease of basic Coldfusion means that not everyone who uses it is a full-on programmer with a computer-science degree. So difficult to debug code when you're not 100% sure what it does! I eventually found an off the peg DHTML and recursion solution here http://www.xtreeme.com/dhtml/dynamic-creation/ which although not directly supporting coldfusion does work really well and solves my immediate problem. Thanks again Steve ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222369 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Perpetual List of Holidays
Hi. Our website needs to show a page that says: No Service offered on Weekends and Holidays. I want to make this process dynamic for every year. I know how to check for weekends with weekofday function. However, is there a way to calculate holidays for each year in the future? Without having to keep a holidays table in the database. Are there any customs tags or functions to get the Thanksgiving Day in 2010, for instance? Any ideas please. - Ken ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222370 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Perpetual List of Holidays
There was a nice set of date functions at cflib.org that had such things. It also figures out daylight savings time. Don't remember the name. On 10/26/05, Ken [EMAIL PROTECTED] wrote: Hi. Our website needs to show a page that says: No Service offered on Weekends and Holidays. I want to make this process dynamic for every year. I know how to check for weekends with weekofday function. However, is there a way to calculate holidays for each year in the future? Without having to keep a holidays table in the database. Are there any customs tags or functions to get the Thanksgiving Day in 2010, for instance? Any ideas please. - Ken ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222371 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: Roll out menus
Trying to make a roll out menu system that works on a center-aligned site. Not asking for the code, just looking for some good references for dynamic menu systems. Any takers? What's your favorites? Ray ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222372 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Perpetual List of Holidays
check out http://www.wsdlfeeds.com/samplecode/call/2/ webservice. you pass it a year and it returns all holiday dates for that year. On 10/26/05, Ken [EMAIL PROTECTED] wrote: Hi. Our website needs to show a page that says: No Service offered on Weekends and Holidays. I want to make this process dynamic for every year. I know how to check for weekends with weekofday function. However, is there a way to calculate holidays for each year in the future? Without having to keep a holidays table in the database. Are there any customs tags or functions to get the Thanksgiving Day in 2010, for instance? Any ideas please. - Ken ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222373 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
