[cfaussie] Re: Trying to create a threading system
On 13/02/06, Chad Renando [EMAIL PROTECTED] wrote: To me, Basic threading is a single post system where you have onetopic, and users can post responses to that one topic.As soon as youhave multiple threads from the one topic, it goes beyond Basic. Fair call. It's all a matter of definition, I guess. :) Compared to most of the message boards I'm used to, this counts as basic. What I did was something like:TOPIC_TABLETopicIDTopicWhateverElse POST_TABLEPostIDTopicIDParentPostIDPostWhateverElse Yep, this is pretty much what I have, save some minor name changes (use of thread instead of topic, and replyTo instead of parentPostID). Good to know I'm on the right track with this much, at least. *grin* For the given Topic, you get all recursive-like with your posts. Yeah, and that's where I'm coming unstuck, I think. I'm having trouble getting appropriately recursive-like with my posts. There's a few open source php boards that are pretty easy to customizeand hack into.I just got through the learning curve with osCommerce, a php shopping cart system.It's not too painful, I've had brokenbones that were worse. I'll have another look, but I hadn't had much luck with this option. Cheers, Seona. who can't currently think of anything witty to say after her name...
[cfaussie] Re: Trying to create a threading system
On 13/02/06, Carl Vanderpal [EMAIL PROTECTED] wrote: Seona, you may want to check out Ray Camden's forum software (to either use or look at to get the ideas) http://ray.camdenfamily.com/projects/galleon/ :) Thanks for that, Carl. The whole 'having a forum' thing is a little experimental at the moment, so I might stick with what I have, but I like the look of this one. I've bookmarked it in case the thing takes off and we need something more sophisticated. :) Cheers, Seona.
[cfaussie] Re: WebDu Who's going ?
On 22/02/06, M@ Bourke [EMAIL PROTECTED] wrote: It's one week till day zero, so who from the list is going this year?\m/(-_-)\m/ Sadly, I'm not. :( Still recovering financially from last years interstate move. *sigh* Maybe next year... Seona. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Two Selects in a Flash cfform not working right
On 17/03/06, Chris Velevitch [EMAIL PROTECTED] wrote:
Show us how you created the query q_getStates and show us theactionPopulate code.
Okay, here's both of my queries and the actionPopulate code:
cfquery datasource=#application.misc.dsn# name=q_getStates
SELECT DISTINCT state
FROM postcoderaw
/cfquery
cfquery datasource=#application.misc.dsn# name=q_getSuburbs
SELECT DISTINCT BSPName, state
FROM postcoderaw
WHERE comments = ''
/cfquery
cfsavecontent variable=actionPopulate
if(_global.arrCities == undefined) _global.arrCities = selectCity.dataProvider.slice(0);
var arrCities:Array = _global.arrCities;
selectCity.removeAll();
for(var i = 0; i arrCities.length; i++)
{
var item = arrCities[i].data.split('|');
if(item[1] == selectState.value )
{
selectCity.addItem(arrCities[i].label,item[0]);
}
}
selectCity.enabled = (selectCity.length 0) ? true:false;
/cfsavecontent
Hope it helps...
Cheers,
Seona.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Dealing with a random number of images
Hi guys, Putting together a real estate listing for our website, and thought that this might be a good place to use a simple (relatively) Flash Form. Good in theory, but causing problems in practise. The problem I currently have is twofold: PROBLEM 1: Trying to get all the necessary data is doing my head in! Whenever I have to work with all but the simplest relationships between two tables, I just tie myself in knots. I currently have the following basic structure in my database: re_property (propID, agentID, propName, ...) re_agent (agentID, agentName, ...) re_image (imageID, propID, imageURL) Each property comes under one agent, and can have between 0 and 5 images associated with it. I've tried using the ideas in some of my other queries (which some of the clever folk on this list helped me with a while back) but they don't seem to allow for the possibility of the zero-relationship. I have one test property record with no assocaited images, and all my attempts at a query have either omited it from the recordset or associated it with the three images from the other test property. If anyone can set me on the right track with this, it would be greatly appreciated. As far as I can tell, to use it in a binding between a cfgrid and a details panel, I need all of the data to come out of one query. PROBLEM 2: Once I get these elusive images, I want to display them in the details panel. I've searched around quite a bit, but I can't seem to find what I'm looking for. Ideally, I would prefer not to just display them all marching down the page, but in a nice little thumbnail arrangement where there is one big image and then a list of other images that, when clicked on, will replace the current main image. Did that sentence make any sense? Hope so. :) Anyway, if anyone understands what I'm trying to do and has any suggestions about where I could look for answers, that would be great. Oh, also feel free to let me know if what I want to do isn't possible with Flash Forms and I should be looking at working on my _javascript_ skills or something instead. Cheers, Seona. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Dealing with a random number of images
On 22/03/06, Haikal Saadh [EMAIL PROTECTED] wrote:
If I'm reading you right, all your concerns are serverside..Problem 1Seems simple enough...cfquery name=images SELECT * FROM re_Image WHERE propID = #whatever#--Use cfqueryparam... too lazy to type
/cfqueryOnce you have that,if images.recordcount gt 0{ //you have images, display them}else{ // No images. Sorry.}
And if I wasn't using Flash Forms and trying to bind the detail
display to a grid, I would do it pretty much like that. But, as I said,
from everything I've tried and read about, I believe I need to have
everything coming out of one query so that it is all known by the grid.
I haven't found a way to make the grid accept details from more than
one query, and I haven't found ways to introduce a sub-query into a
bound element on the form.
If you know if one, however, I'm all ears. :)
Problem 2 Have a look at some of the other sites for inspiration. Used Car sites
are also good. I like drive.com.au. and carsales.com.au
Oh, I have the inspiration. Like I said, I know what I want to achieve. I just don't know how to.
I suppose there are workarounds if it's not possible, but it would
certainly be the preferred solution since it takes up less space. :)
Cheers,
Seona.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Dealing with a random number of images
On 22/03/06, Scott Thornton [EMAIL PROTECTED] wrote: Hello,If you wish to use one query only, and have to deal with 0-n images, then you will have to left outer join your Image table.egselect*fromre_property prop left outer joinre_image image on prop.propid = image.propid Ah! I've never understood the whole outer/inner join bit, so I tend not to use them. Probably why I tie my brain in knots trying to find an alternative. :) So if I then also wanted to get the agent data (which is easier since each property must have 1 agent) would that involve another join of some sort, or would it be like this: select * from re_property prop left outer join re_image image on prop.propid = image.propid, re_agent agent where agent.propID = prop.propID That's the way I've always handled such things in the past, but I'd like to learn how to use joins properly if they're a better way of working it. :) Cheers, Seona. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Dealing with a random number of images
On 22/03/06, Chad Renando [EMAIL PROTECTED] wrote: Just jumping in from left field here and may not be of help, but haveyou ever used MS Access?I find it quite handy as a drag and drop SQLgenerator.I tend to recreate all my databases in Access so I canhack and play and have it create the SQL for me.I know Enterprise does the same, but I find Access a quick and dirty means to an end.Chadwho spends most of his time in left field. Interesting idea. I might have a play with that tomorrow if I haven't found a solution by then. Too late to go setting up databases today. :) Cheers, Seona who's a city girl at heart and tries to stay out of the fields - they tend to be distressingly rural --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Dealing with a random number of images
On 23/03/06, Shib71 [EMAIL PROTECTED] wrote: This is a situation where the group property of cfoutput comes in very handy:cfoutput query=qImages group=prop !--- Do stuff with a property ---cfoutput!--- Do stuff with each instance of the property, eg process an image field --- /cfoutput/cfoutputCheersBlair Okay, so how would I actually get the query, though? To do it the way you're suggesting, I would have to run the query when the user clicks a row in the grid. The query would get all of the images linked to the ID of the selected row, and then I could output them. The question is: how do I pass the ID to the query and make it run every time a new row is clicked? I believed that was what bindings were supposed to offer a solution to? And that, of course, brings us back to needing everything to be in one query so I can bind it to the grid. The sub-selects that have been selected won't work - the server I'm on is running MySQL 4.0.26 and apparently that can't handle them. So can anyone else come up with a way I can write this query so that I get the following criteria filled?: * Each property appears in the recordset, regardless of whether or not it has images * Each property knows the details for it's agent, referenced by agentID * Properties with more than one image will appear only once in the recordset, but will know about all of their images. Cheers, Seona. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Dealing with a random number of images
On 23/03/06, Karen Johnstone [EMAIL PROTECTED] wrote: To have all images returned as a column value for the property, I think you'd have to LEFT JOIN the image table N times, and make sure that each joined record was for a different image. Something like below (probably not correct syntax - just wanted to give you the idea). Might require too much processing tho! Hi Karen, Hmm... Well, I think you might be right about it not being the correct syntax - I tried it, cleared up the few discrepencies with names of things, and stopped getting errors. Sadly, I stopped getting anything else either - nothing is being returned. I'd like to play with it a bit more, though, so I'm going to walk through it here and trust you to tell me if I'm understanding what it's doing correctly. :) I'm going to ask a lot of questions, so please bear with me as I try and work through this. SELECT ...FROM re_property p, re_agent a LEFT OUTER JOIN re_image i1 ON i1.propid = p.propid LEFT OUTER JOIN re_image i2 ON i2.propid = p.propid LEFT OUTER JOIN re_image i3 ON i3.propid = p.propid LEFT OUTER JOIN re_image i4 ON i4.propid = p.propid LEFT OUTER JOIN re_image i5 ON i5.propid = p.propid Okay, I changed the order of the top two bits in the FROM - the images are in reference to the property not the agent. Am I right in thinking that this means the joins should be between the property table and the image table? (since it's the propID that's joining them, and that doesn't even exist in the agent table) So why do we join essentially the same information each time? Just to give it a different name? Why can't this be done through aliasing in the SELECT line? WHERE a.propID = p.propID Minor change... it's agentID that joins these two, but that's kinda immaterial for the sake of this problem. AND i1.imageID i2.imageIDAND i1.imageID i3.imageIDAND i1.imageID i4.imageIDAND i1.imageID i5.imageIDAND i2.imageID i3.imageIDAND i2.imageID i4.imageIDAND i2.imageID i5.imageIDAND i3.imageID i4.imageIDAND i3.imageID i5.imageIDAND i4.imageID i5.imageID Err... is not equal to , right? So we're saying only get it where none of the imageID's match? I think this is the bit that is stopping the query from returning anything. Despite the fact that you have given each one a diiferent name, I'm pretty sure it's still all pointing at the same data. So I think this means you'll never have a case hwere none of them match, because there all the same. Or have I missed something here? I can definitely see the logic in what I think you're trying to do, I just don't think it's working in its current form. Damned if I know what form it needs to be in, though! *sigh* Cheers, Seona. From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Seona BellamySent: Thursday, 23 March 2006 8:46 AMTo: cfaussie@googlegroups.comSubject: [cfaussie] Re: Dealing with a random number of images ... So can anyone else come up with a way I can write this query so that I get the following criteria filled?:* Each property appears in the recordset, regardless of whether or not it has images* Each property knows the details for it's agent, referenced by agentID* Properties with more than one image will appear only once in the recordset, but will know about all of their images. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Dealing with a random number of images
I hadn't thought of doing it that way, but it makes a whole lot of sense. Thanks for that, I'll have a fiddle with it and see if I can get it going this way. :) Cheers, Seona.On 28/03/06, Steve Onnis [EMAIL PROTECTED] wrote: the thing is your doing queries where they are not neededall you needed to do was do what your doing with the query, but create awhole new query instead of populating a new fieldfor example //!--- Get all the properties and any images relating to them ---cfquery datasource=#application.misc.dsn# name=q_getProperties SELECTre_property.*, re_image.imageURLFROMre_property LEFT OUTER JOIN re_image ON re_property.propID = re_image.propID,re_agentWHERE re_agent.agentID = re_property.agentID ORDER BYpropPrice,propSuburb/cfquery!--- create a new query object to populate ---cfset properties = queryNew(#q_getProperties.columnList#,Images)!--- Output the query grouping by the property so we don't get doubles --- cfoutput query=q_getProperties group=propID!-- add a row to the query object ---cfset queryAddRow(properties)!--- loop over the columns in the r cfloop list=#q_getProperties.columnList# index=ccfif c NEQ imageURLcfset querySetCell(properties, c, evaluate(c))/cfif/cfloop!--- rest the property images value ---cfset propertyImages = !--- add the properties together ---cfoutputcfset propertyImages = listAppend(propertyImages, imageURL)/cfoutput!--- set the property image cell with the total list of images ---cfset querySetCell(properties, Images, propertyImages) /cfoutput//That's how I would have done it anyway, otherwise your hitting the databaseover and over just to get the images for the property.Just think, you have 20 properties with say 5 images each, that's 101 database queries to do whatyou need to do.This way is only a single query and your letting CF do thegrunt work to put it into the format you need.Steve --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Popups from a Flash Form?
Hi guys, I've been butting my head against this one for a bit, so I'm hoping that someone else knows where I can find the information I need. I have a Flash Form, and amongst other things it displays some thumbnail images. My boss wants these to be clickable, opening up the full-sized version of the image. I can see the need for this, but I can't figure out how to make it happen. I've tried adding the usual code I'd use to the binding, and the image is now clickable, but nothing happens when you do. I've gone and looked through the CF documentation, the Flash documentation, and the Flex documentation, plus Googled extensively. I just cannot seem to find anything that will make this work. Does anyone know of a way to do this? Or is it just not possible with Flash Forms? Cheers, Seona. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Popups from a Flash Form?
On 13/04/06, Justin Raymond [EMAIL PROTECTED] wrote: I recently used this article to get flash to call a JS function to open up a pop up. (the article shows how to open a browser alert) http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_15683 Is this what you are after?? Let me know and I can post the code I used. Hi Justin, An interesting article, but it relies on actually creating Flash movies in Flash itself - so you can attach a bunch of actionscript to them. I'm not sure how I translate that into attaching that actionscript to the dynamically generated swf created by the Flash Form though. If you know a way, I'd love to see the code because it would probably be the solution I'm looking for. Cheers, Seona. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Need an extra set of eyes on this
Ah. No, aparently you can't. I could have sworn I'd done it before, but I guess I'm wrong. Changing the cfinput to an input solved the problem. *sigh* I could have sworn I'd done it before... Cheers, Seona.On 27/04/06, Joel Cass [EMAIL PROTECTED] wrote: You have a ColdFusion tag inside a ColdFusion tag. I've never done that. Is that possible? -Original Message-From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com]On Behalf Of Blair McKenzieSent: Thursday, 27 April 2006 9:22 AMTo: cfaussie@googlegroups.comSubject: [cfaussie] Re: Need an extra set of eyes on thisI usually use checked=true. Could having checked in that string cause your problem?Blair On 4/27/06, Seona Bellamy [EMAIL PROTECTED] wrote: Hi guys,Can someone please look at this and tell me what's wrong with it? I'm sure it's something really simple, but I just can't see it.I have the following piece of code:cfinput class=chkb name=advertising id=advertising type=checkbox value=1cfif form.advertising checked=checked/cfifIt gives me the following error:-Invalid token 'c' found on line 194 at column 121. The CFML compiler was processing: * a cfinput tag beginning on line 194, column 38. * a cfinput tag beginning on line 194, column 38. * a cfinput tag beginning on line 194, column 38. * a cfinput tag beginning on line 194, column 38.The error occurred on line 18. If I remove the cfif bit, the error goes away. Can I not have a cfif in a cfinput? I'm sure I've done it before.Cheers,Seona. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Slightly OT - I hate inherited queries
Ah, brilliant! Thank you so much. I knew it was going to be something simple, but I couldn't think of what. Didn't think of indenting though. I'll remember that one in future. :) Cheers, Seona.On 05/05/06, Blair McKenzie [EMAIL PROTECTED] wrote: Indenting is your friend. As you can see from the following, the first paranthesis matches the second last. You need to add another bracket to the front. I just did the first query, not the one being combined, but I wouldn't be surprised if you have a similar problem there. Anyway, that's why the error came up at the last bracket. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Slightly OT - I hate inherited queries
On 05/05/06, Patrick Branley [EMAIL PROTECTED] wrote: get rid of the brackets on the inner join, from what i can tell they are doing sweet FA.inner joins are eqivalent to a WHERE join , dont use join unless you are doing OUTERs .you should also consider creating a VIEW in the db so you dont have to do all the joins for every query. You're probably right, but this the query I was given and I'm not familiar enough with SQL syntax to be game to change it more than I absolutely have to. *grin* As you can see, I run into all sorts of problems when I try. Thanks for the advice though. :) Cheers, Seona. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Slightly OT - I hate inherited queries
On 05/05/06, Steve Onnis [EMAIL PROTECTED] wrote: Yeah thats rightfor a union to work all the columns in each union query have to be the same-Original Message-From: cfaussie@googlegroups.com [mailto: cfaussie@googlegroups.com]OnBehalf Of Scott ThorntonThe name of the column is taken from the first query of union query.This name can be referenced in an order by statement which is quite useful. Yeah, I've got that fixed now. There were still a few that had slipped through when I was changing stuff over from the old structure. I seem to have it more or less working now, but it is doing something strange when you try and filter by postcode. Have a look at: http://www.renovate.com.au/index.cfm?page=test Enter a postcode in the box underneath the scrolling panel, and submit it. What should happen is that the list is now broken into two pieces: one headed In your area and once headed Outside your area. Each directory entry appears in EITHER the first section or the second section. Instead, everything is appearing multiple times in both sections. :( Since there's quite a lot of code making up the full thing, I've tried to attach the file to this email rather than copying and pasting. It will probably make it easier to read. Any ideas about why this thing is playing silly buggers would be greatly appreciated. Cheers, Seona. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~--- d_teaserPane.cfm Description: application/cfm
[cfaussie] Re: DISTINCT not so distinct
On 08/05/06, Chris Velevitch [EMAIL PROTECTED] wrote: Can a document have more than one category or type? A document will only ever have 1 type, but it can have more than 1 category. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: DISTINCT not so distinct
On 08/05/06, Chris Velevitch [EMAIL PROTECTED] wrote: I think might have to use the distinct in a subqueryselect ... where d.id = (SELECT DISTINCT(d.ID) from r_document AS d,r_docByType AS dt WHERE dt.docTypeID= 1 ANDdt.documentID = d.ID ... LIMIT 3)and then use the that to get the records you need. Are we able to do this? I seem to remember running into this recently and finding that our version of mySQL didn't support subqueries? Or have we upgraded? Cheers, Seona. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: DISTINCT not so distinct
On 08/05/06, Lucas [EMAIL PROTECTED] wrote: Ok, that is what is playing up for you - ask you can have more than one category per article, dc.categoryID will make two records that appear the same to be different (two different categoryIDs)you may want to wrap it in a Max() so you only get one categoryID. L.Ah, good call. I hadn't considered that aspect of it. I tried changing the query to this: SELECT DISTINCT(d.docTitle), d.docIntro, d.docContent, d.docImage, MAX(dc.categoryID), d.ID FROMr_document AS d,r_docByType AS dt,r_docByCategory AS dc WHERE dt.docTypeID = 1 ANDdt.documentID = d.ID ANDdc.documentID = d.ID ORDER BY d.dateEntered DESC LIMIT 3 The error it gave me said something about a problem with the GROUP BY clause - which is strange, because there isn't one. Does there need to be? I've looked in the online manual, and I can't see anything that suggests Max() can only be used with a GROUP BY. Cheers, Seona. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: DISTINCT not so distinct
On 08/05/06, Lucas [EMAIL PROTECTED] wrote: yeah, as you are using a MAX() you are going to need a group by...try...group by d.docTitle, d.docIntro, d.docContent, d.docImage, d.ID Hmm I changed the query to this: SELECT DISTINCT(d.docTitle), d.docIntro, d.docContent, d.docImage, MAX(dc.categoryID), d.ID FROM r_document AS d,r_docByType AS dt,r_docByCategory AS dc WHERE dt.docTypeID = 1 ANDdt.documentID = d.ID ANDdc.documentID = d.ID GROUP BY d.docTitle, d.docIntro, d.docContent, d.docImage, d.ID ORDER BY d.dateEntered DESC LIMIT 3 What I got was the following error: Variable CATEGORYID is undefined. brThe error occurred on line 22. This is referring to the place where I try and insert the category ID into the Read more link in the display. So it looks as though the Max bit is stopping the query from finding that one properly. Any suggestions? Seona. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Someone help with this bit of code?
On 05/09/06, Andrew Scott [EMAIL PROTECTED] wrote: cfquery datasource=#DSN# name=qMyDiscountApprovalsSELECT *FROM Bookings, BookingItemsWHERE BO_DeleteDate IS NULLAND BO_ID = BI_BookingID AND BI_ParentItem IS NULLcfif Client.Authenticate eq 2and BO_Discount = 0.03cfelseif Client.Authenticate eq 3 and BO_Discount = 0.03 AND BO_Discount = 0.07/cfifand BO_DiscountApproval is NULL/cfquery Now the above code returns 23 and the actual query above returns 73, I knowit has something to do with the group=bo_id just can't work it out?Just a thought, but when you are using cfoutput with the group attribute, don't you usually include a GROUP BY clause in your query? Not sure if that's helpful or not...Cheers,Seona. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Someone help with this bit of code?
Is it? Ah well, I usually end up putting both, so I wasn't sure. :)On 05/09/06, Andrew Mercer [EMAIL PROTECTED] wrote: ORDER BY rather than GROUP BY. On 9/5/06, Seona Bellamy [EMAIL PROTECTED] wrote: On 05/09/06, Andrew Scott [EMAIL PROTECTED] wrote: cfquery datasource=#DSN# name=qMyDiscountApprovalsSELECT *FROM Bookings, BookingItemsWHERE BO_DeleteDate IS NULL AND BO_ID = BI_BookingID AND BI_ParentItem IS NULLcfif Client.Authenticate eq 2and BO_Discount = 0.03cfelseif Client.Authenticate eq 3 and BO_Discount = 0.03 AND BO_Discount = 0.07/cfifand BO_DiscountApproval is NULL/cfquery Now the above code returns 23 and the actual query above returns 73, I knowit has something to do with the group=bo_id just can't work it out?Just a thought, but when you are using cfoutput with the group attribute, don't you usually include a GROUP BY clause in your query? Not sure if that's helpful or not...Cheers,Seona. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Query picking up an odd value from somewhere
On 27/09/06, Joel Cass [EMAIL PROTECTED] wrote: My own take on it would be that there is an issue with your joins. You could either get rid of all the brackets and join each table sequentially, OR grab tables and join in the where clause This might make things easier to see.. Good call. I went with the second option, and I think I've got it figured now. At any rate, it's a lot easier for me to see what's going on.Cheers, Seona. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: webDU 2007: 22-23 March 2007, Hilton Sydney
I hope to attend. Pretty sure I can save up enough by then. :)~Seona.On 12/10/06, Mark Mandel [EMAIL PROTECTED] wrote:I'll be there.. for sure.Not missing it this year, no way. MarkOn 10/12/06, Barry Beattie [EMAIL PROTECTED] wrote: so, Scott, are you going? and (to all) who else, come hell or high water? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: ColdFusion trend?
Do you know anyone who can? (Not putting up my hand here, I'd just like to point out, because I can't.) If you could write the CF version and then pass it off to a sympathetic friend, maybe that would help you get your two versions? Just a thought...On 18/10/06, George Lu [EMAIL PROTECTED] wrote: Thanks Dale. I'll try it although I've never written ASP.NET. On 18/10/06, Dale Fraser [EMAIL PROTECTED] wrote: You should sit down and write some simple program in CF ASP.NET and print out the code (including the hidden code behind stuff in .NET) and see which one he would rather pay someone to write. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Coldfusion and Micrsoft Love.
I'd likely be interested in coming along to something like this. Especially if it's free. ;) I spent the last few months seriously under-employed, so there isn't a great deal of spare cash around if I want to keep being able to pay my rent. *sigh* Cheers, Seona. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: outputting recordset
On 05/04/07, Dale Fraser [EMAIL PROTECTED] wrote: So are you saying a fixed number of rows 6 Or a fixed number of columns 3? I believe the line in the original email was: I need to output a recordset in a table, infinite rows, and maximum 3 columns in width. I'm more interested in knowing if there was a reason for the number of empty cells in the third column. Because I'm pretty sure that the columns could have been closer to even in length, and that would be easier to do I think. The maths is making better sense in my head, anyway. Then again, knowing my history with maths, I'm not sure that's saying much... Basically, what I'm thinking is something along these lines: * Divide your number of records by 3 and round it off to an integer (I'll call this divisor). This is the number of records you will have in each of the first two (complete) columns. The third column may or may not have this many records. * Loop over your recordset this many times, with a counter of some sort to count the iterations. * In the loop, get the three cells as follows: * count * count + divisor * count + (divisor * 2) I haven't tested this, so it's purely theoretical and may or may not work. Oh, and you'd probably want to test if the value exists in the third column because that one may not be full. Cheers, Seona. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Formal Testing (was: Hack ColdFusion Application)
On 04/05/07, Chris Velevitch [EMAIL PROTECTED] wrote: On 5/2/07, Mike Kear [EMAIL PROTECTED] wrote: Isn't testing work worth the hire? Shouldnt they get paid regardless? Mike comments brings up an interesting thought: who is doing formal testing and employs testers (either full time or on a contract basis)? What I mean by formal testing is once the requirements and specifications are in place whilst the developers are coding, the testers are creating test cases/scenarios in readiness for the testing phase of the project. We handle ours in-house. We don't actually have dedicated testers, but test cases are drawn up from the various requirements documents and then once the site's on the testing server they get handed around the office for people to run through. Not sure if that's as formal as you're asking about, though. ~Seona --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: CFAussie Community Head Count
I'm here. I don't talk much these days, but I read most of what comes through. :) Cheers, Seona. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] [SOT] Left join not behaving as expected
Hi guys, I'm playing around with recursion this afternoon, and I've hit a snag which I think is due to my less-than-perfect SQL skills. I have the following tables: CATEGORY - cat_id - cat_name - parent_id ITEM - id - title - category_id I've managed to get it working where I pull out a list off all the categories, sort them by parent_id, and then run a recursive function over the query to transform them into a nested list. Now I want to add another level of complexity, where if a category has items attached to it, those items will nest in under the relevant list item. So you might end up with something like: Category 1 - Subcategory 1 - Subcategory 2 -- -- Sub-Subcategory 1 --- --- --- Item 1 --- --- --- Item 2 -- -- Sub-Subcategory 2 --- --- --- Item 3 -- -- Item 4 -- -- Item 5 - Item 6 So I have the following query: SELECTcat_id, cat_name, parent_id, title, id FROMcategory c LEFT JOIN item i ON c.cat_id = i.category_id ORDER BY parent_id, cat_name, title From the way I understand LEFT JOIN, this should give me all of the categories, whether they have an item directly attached to them or not. That's not what's happening, however. Judging by the dump of the query results, I only seem to be returning information for the items, including their category information. Have I misunderstood the way it works? Or have I just constructed it wrongly? Any advice would be greatly appreciated. Cheers, Seona. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Is there a delete version of queryAddRow()?
Oh yeah! Thanks. :) *slaps forehead and walks away muttering about forests and trees* On 11/10/2007, Blair McKenzie [EMAIL PROTECTED] wrote: select * from yourquery where primarykey not in (list,of,items,to,remove) Blair On 10/11/07, Seona Bellamy [EMAIL PROTECTED] wrote: Heya, Working with a large cached query here (it's used several different times on the page in several different ways, so we've cached the whole big query and then just perform QoQ's on it to get the various sub-sets we need). I've run into a situation where I want to be able to selectively remove certain records from the recordset under specific circumstances. Is this possible? I thought there might have been a function to do it, along the lines of queryAddRow(), but there doesn't seem to be. Anyone ever done this before? Any advice would be appreciated. Cheers, Seona. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Is there a delete version of queryAddRow()?
Heya, Working with a large cached query here (it's used several different times on the page in several different ways, so we've cached the whole big query and then just perform QoQ's on it to get the various sub-sets we need). I've run into a situation where I want to be able to selectively remove certain records from the recordset under specific circumstances. Is this possible? I thought there might have been a function to do it, along the lines of queryAddRow(), but there doesn't seem to be. Anyone ever done this before? Any advice would be appreciated. Cheers, Seona. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: cfdocument and css styles
On 05/11/2007, Taco Fleur [EMAIL PROTECTED] wrote: Hello all, I'm trying to generate a PDF with cfdocument in CF7 It generates the PDF, and has the content, but the css styles do not come across, see code Even the inline style doesn't come across, I have no idea why not. I'm not 100% certain, but I seem to remember finding that cfdocument only likes very simple inline CSS - no linked external documents, no @media or anything fancy like that. Just simple style tags with rules in them. A bit of a pain, but you can at least keep them in a separate file and just cfinclude it. Cheers, Seona. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Update your details with Adobe
You're lucky that you got that far! For some reason, it doesn't want to accept my email address... E-mail address:* [EMAIL PROTECTED] enter your email. Please use the e-mail format [EMAIL PROTECTED]. Confirm email address:* [EMAIL PROTECTED] Please confirm your email. Confirm email does not match email address. Methinks something's gone a little screwy with it's logic. Or have I just missed something?? On 14/11/2007, AJ Mercer [EMAIL PROTECTED] wrote: what is the prize?? Thanks for registering your details. We look forward to bringing you the latest information on Adobe(R) products and upgrades in the future. Good luck in our prize draw! Visit the Adobe website http://www.adobe.com/au/ Terms Conditions http://www.updateadobe.com/termscon.htm On Nov 14, 2007 11:42 AM, Mark Blair [EMAIL PROTECTED] wrote: Hey folks, The data quality in the customer database Adobe has for Australia and New Zealand appears to have some significant issues. This is causing problems where people are not being made aware of events that they would definitely be interested in. For example CFCAMP where long time registered CF users have not received invites. I'd encourage everyone to go to the following URL and update your details with Adobe. Please go to http://www.updateadobe.com/ When doing this make sure you indicate which products you are interested in Thanks Mark Mark Blair Technical Director, Pacific Adobe Systems -- AJ Mercer Web Log: http://webonix.net --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Fixing up HTML Entities
Hi guys, Hopefully a quick and easy one for someone - I'm sure this is going to be one of those things with an easy fix I'm just not seeing! I'm pulling in an XML file via an RSS feed. It has some 's which are not encoded as amp; and some which are (as well as a smattering of quot;'s and other entities). Apparently, those unencoded 's are what is preventing me running this data through xmlParse(). Is there a way in which I can isolate those unencoded 's and change them to amp; but leave every other (ie, the ones already used as part of an entity) alone? I tired running htmlEditFormat() over it, but that translated everything including the structural stuff and so I couldn't parse it anyway. :( Cheers, Seona. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Fixing up HTML Entities
A big thank you to Barry Kym and Joel for your suggestions. As it turns out, when I did a bit more digging I discovered that the problem was in the way the data was being compiled in the first place. Once I fixed that up, the problem went away entirely. *sigh* On the other hand, I now have a host of tricks up my sleeve for this sort of thing in the future, which is always to the good. I'll be playing with them once this deadline is behind me to see if I can put together a bit of a library. Cheers everyone! :) Seona. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Linkedin and similar - any one finds them useful?
2008/7/8 Zac Spitzer [EMAIL PROTECTED]: One thing about Linkedin I know for sure is that recuiters just love it... Yes, I've been contacted by a few recruiters who found my LinkedIn profile. Sadly, they only found it after I'd found a full-time gig through other means, but they're now in my network in case I need them. :) ~Seona --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Getting users who haven't made an entry today
Hi all! Have a system that people are supposed to log into every day and make an entry. I've been asked to created a scheduled task that every evening will look for all of the users who haven't made an entry today and send them a reminder email, but I'm having trouble getting me head around how to get that information. I have the following query, called qReminders, that gets all of the entries: SELECT u.emailaddress, u.firstname, u.surname, u.rec_id, bde.bde_entrydate FROMusers u INNER JOIN body_diaries bd ON u.rec_id = bd.bdi_usr_id INNER JOIN body_diary_entries bde ON bd.bdi_id = bde.bde_bdi_id WHERE u.user_level = 1 ORDER BY u.rec_id, bde.bde_entrydate So then I thought I'd do a query-of-query on this one to get the details of all the people who haven't made an entry today, but I can't figure out what the filtering clauses would be. Just getting the records that aren't today's won't work. I need a way to say where bde_entrydate does not include today's date in one of the records returned for this user. Is this even a good way to go about it? I'm concerned that doing an initial query that gets everything could become quite stupidly large over time. Cheers, Seona. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Getting users who haven't made an entry today
2008/8/22 Barry Beattie [EMAIL PROTECTED]: would it be more a simpler way to do a straight query? select * from users where userID not in (select userId from those that posted today) Oh yeah. *slaps forehead* I didn't even thing of doing it that way. That works just fine. And so simple! :) Thanks to Brett and Andrew for your suggestions, too. Cheers, Seona. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Getting users who haven't made an entry today
Thanks for the suggestion, Scott. I must admit, I hadn't thought about putting the date restriction into a join clause. Another trick to add to my arsenal. :) Cheers, Seona. 2008/8/25 Scott Thornton [EMAIL PROTECTED]: Hi Seona, I like to use a LEFT OUTER JOIN for a query like this. It would look something like SELECT u.emailaddress, u.firstname, u.surname, u.rec_id, bde.bde_entrydate FROMusers u INNER JOIN body_diaries bd ON u.rec_id = bd.bdi_usr_id left outer join JOIN body_diary_entries bde ON bd.bdi_id = bde.bdi_id where bde.bdi_id is null which should return users that have body_diaries, but NO body_diary_entries. you can add in the left outer join clause the date parameter for that day. eg left outer join JOIN body_diary_entries bde ON bd.bdi_id = bde.bdi_id and entry_date #CreateODBCDate( todays_date )# --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Getting users who haven't made an entry today
2008/8/25 Scott Thornton [EMAIL PROTECTED]: Hi, Lots of things can go into the join clause... and placing more criteria into the join clauses can often speed-up your queries (especially for large data sets) where the initial number of records can be reduced significantly. That said however, the query optimizer is the ultimate decider and it just may place the criteria into the where clause. (I am referring to query plans ). I guess its just what you are used to my background is in database development, application development came a bit later That makes sense, I guess - about reducing the initial number of queries grabbed, I mean. Not sure about the query plans bit, though. My background is the exact opposite of yours. I learned DB stuff through needing it for application development. And since the DB subject at uni was pretty much a joke, there's a lot of little tricks and suchlike that I just never learned. Getting better slowly, though. :) Thanks, Seona. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Constant query injection attacks
Instead of just blocking them, we send them off to http://www.cybercrime.gov/ I doubt it makes much difference, but there's an irony there that I like. :) Cheers, Seona. 2008/8/27 Matthew [EMAIL PROTECTED]: Hi Kevin: Just what I was thinking - thanks! Hi Andrew: we are co-located so do you mean go to the ISP of the nocs center provider? Anyway, I doubt the AFP would even lift a pen/batton. I was hoping that there'd be some sort of international internet body that investigates complaints. Oh well, I'll just have to block the buggers. Cheers Matthew --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Constant query injection attacks
*grin* Was a decision made by someone higher up the food chain, though, so I get to just sit back and appreciate the irony. 2008/8/27 Andrew Scott [EMAIL PROTECTED]: Careful there That seems so wrong on so many levels, as nice as it would be to do. -- Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 9015 8628 Mobile: 0404 998 273 -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Seona Bellamy Sent: Wednesday, 27 August 2008 2:31 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Constant query injection attacks Instead of just blocking them, we send them off to http://www.cybercrime.gov/ I doubt it makes much difference, but there's an irony there that I like. :) Cheers, Seona. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Orientation of x-axis labels in a bar graph
2008/11/12 Cassie Woolley [EMAIL PROTECTED]: You can create an XML definition file using the cfchart wizard tool (can't remember the exact name). It will come up with something like this. You can see orientation=Slanted on row 5. There are heaps of options, and I've not found a good reference guide to them, so I just use the wizard. ?xml version=1.0 encoding=UTF-8? frameChart is3D=false frame xDepth=12 yDepth=11 outline=black/ xAxis isAntialiased=true labelStyle orientation=Slanted color=black/ /xAxis yAxis scaleMin=0 isAntialiased=true labelStyle color=black/ /yAxis legend allowSpan=true equalCols=false placement=Bottom halign=Right isAntialiased=true isMultiline=true decoration style=None/ /legend elements place=Stacked drawShadow=true morph morph=Grow/ /elements decoration style=RoundShadow/ paint palette=Fiesta isVertical=true min=47 max=83/ insets right=5/ /frameChart Do you mean the one in Dreamweaver? Because I've just had a look in it, and it doesn't give me any nice simple options for changing the orientation of labels - it only seems to give the options that are direct attributes of the cfchart and cfchartseries tags. On the other hand, copying your xml at least got me a change without an error... part of the problem seems to be that the solutions I was finding online were fragments (presumably in the erroneous assumption that the person reading would know what they were doing!) and didn't have the frameChart bit. So now at least it knows what the xAxis is... Even when I strip out most of your options, though, it still substantially changed the look and feel of the graph. So now I need to play with the settings to figure out how to bring it back into line with everything else. But at least I'm closer than I was. Thanks. :) Cheers, Seona. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Orientation of x-axis labels in a bar graph
Thanks Cassie and Steve. I'd never even known that was there! Time to start playing I guess. :) Cheers, Seona. 2008/11/12 Cassie Woolley [EMAIL PROTECTED]: You'll find the wizard in your ColdFusion8/charting directory called webcharts.bat. Cheers Cassie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Seona Bellamy Sent: Wednesday, 12 November 2008 1:42 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Orientation of x-axis labels in a bar graph Do you mean the one in Dreamweaver? Because I've just had a look in it, and it doesn't give me any nice simple options for changing the orientation of labels - it only seems to give the options that are direct attributes of the cfchart and cfchartseries tags. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
Re: [cfaussie] Digest for cfaussie@googlegroups.com - 1 Message in 1 Topic
Err... I am using Fusebox. The only plugin I can find means that you end up with a url along the lines of: http://www.myserver.com/index.cfm/action/main.home/variable1/value1 I'm not really keen on the whole idea of having the index.cfm stuck in the middle of the URL like that - I think it looks kludgy. On the other hand, the plugin I found was a few years old. If you can point me at a more recent one that fixes this problem, then I'd be thrilled! :) And yeah, I do get what you're saying about real rewriting needing to happen at the webserver level. That's how I've worked with it in the past but was just playing around with the idea to see fi I could find an alternative. Thanks for your input! :) Cheers, Seona. 2009/12/19 Daniel Punton compas...@gmail.com I honesty doubt you can find one solution for both IIS and apache. That is the crux as the redirection/aliasing (rewrite) has to happen at the webserver level. If you were only using fusebox you could of course use a plugin. Dan Seona Bellamy seon...@gmail.com Dec 18 02:34PM +1100 ^#125a5cc7a1b1c722_125a47f3d3ce7a5c_digest_top Hi guys, I'm using my time off work to play around with some old half-finished projects that have been knocking around my hard-drive for a few years, seeing what I can bring to them with the new techniques and perspectives I learned in my last job. One of these projects in a half-built Fusebox 4 app and the issue I've been thinking about today is friendly URLs. In my last job, we used ISAPI Rewrite to handle the URL rewiring for our CMS. It was very effective and relatively easy to customise once you got your head around the syntax, but the main problem I see with it is that it's only feasible when you have control over the server and can make sure that the necessary software is installed and suchlike. (That's my understanding of it, anyway, so please correct me if I'm wrong!) I'm looking to create something that can be taken and uploaded to any CF server, including shared hosting providers, and just work. That's the theory anyway. So I was thinking about ways that you could write something in CF to handle this. I've done some searching and the only options I can find are rather old (most seemed to date around 2005 as far as I could tell) and so I'm not sure how relevant they would still be. So is this something that anyone has done or knows of being done and can point me to? Is there a way to handle it in Fusebox so that you don't need to keep the index.cfm in the middle of the URL (as all the examples I found seem to do)? Am I just indulging in a pipe dream here and sound give up and play with something else? Any thoughts and/or suggestions would be welcome on this. I'm tired to going around in circles. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] email attachments
When I've had to do this sort of thing in the past, I've always found that the easiest way was to create the file, attach it, then delete it from the server if I had no need to keep it. From a conceptual point of view, I'm not sure that attaching a file that hasn't been created actually makes sense. The attachment is a file, therefore I can't think of any way to get around actually creating a file to attach. Does that thought still make sense now that it's outside my head? Having an odd morning so I'm not sure... Cheers, Seona. On 13 April 2010 10:14, KNOTT, Brian brian.kn...@suncorp.com.au wrote: Presently there is no file. I want to do it on the fly with out creating a file. Brian *From:* cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] *On Behalf Of *Kevin Pepperman *Sent:* Tuesday, 13 April 2010 10:13 AM *To:* cfaussie@googlegroups.com *Subject:* Re: [cfaussie] email attachments Yes, just add cfmailparam between your cfmail tags with a path to the file. It will attach it to the email. cfmailparam file = #thisFilePath# type=text/plain On Mon, Apr 12, 2010 at 8:01 PM, KNOTT, Brian brian.kn...@suncorp.com.au wrote: attachment -- /Kevin Pepperman They who can give up essential liberty to obtain a little temporary safety, deserve neither liberty nor safety. - Benjamin Franklin -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.comcfaussie%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or one of its related entities Suncorp. Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on 13 11 55 or at suncorp.com.au. The content of this e-mail is the view of the sender or stated author and does not necessarily reflect the view of Suncorp. The content, including attachments, is a confidential communication between Suncorp and the intended recipient. If you are not the intended recipient, any use, interference with, disclosure or copying of this e-mail, including attachments, is unauthorised and expressly prohibited. If you have received this e-mail in error please contact the sender immediately and delete the e-mail and any attachments from your system. If this e-mail constitutes a commercial message of a type that you no longer wish to receive please reply to this e-mail by typing Unsubscribe in the subject line. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.comcfaussie%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] email attachments
Hey, cool, I didn't know about this option. Thanks! :) ~Seona On 13 April 2010 10:24, Blair McKenzie shi...@gmail.com wrote: To simplify this, you can set remove=true on cfmailparam to indicate that the file should be deleted after the email is sent. Blair On Tue, Apr 13, 2010 at 10:21 AM, Seona Bellamy seon...@gmail.com wrote: When I've had to do this sort of thing in the past, I've always found that the easiest way was to create the file, attach it, then delete it from the server if I had no need to keep it. From a conceptual point of view, I'm not sure that attaching a file that hasn't been created actually makes sense. The attachment is a file, therefore I can't think of any way to get around actually creating a file to attach. Does that thought still make sense now that it's outside my head? Having an odd morning so I'm not sure... Cheers, Seona. On 13 April 2010 10:14, KNOTT, Brian brian.kn...@suncorp.com.au wrote: Presently there is no file. I want to do it on the fly with out creating a file. Brian *From:* cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] *On Behalf Of *Kevin Pepperman *Sent:* Tuesday, 13 April 2010 10:13 AM *To:* cfaussie@googlegroups.com *Subject:* Re: [cfaussie] email attachments Yes, just add cfmailparam between your cfmail tags with a path to the file. It will attach it to the email. cfmailparam file = #thisFilePath# type=text/plain On Mon, Apr 12, 2010 at 8:01 PM, KNOTT, Brian brian.kn...@suncorp.com.au wrote: attachment -- /Kevin Pepperman They who can give up essential liberty to obtain a little temporary safety, deserve neither liberty nor safety. - Benjamin Franklin -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.comcfaussie%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or one of its related entities Suncorp. Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on 13 11 55 or at suncorp.com.au. The content of this e-mail is the view of the sender or stated author and does not necessarily reflect the view of Suncorp. The content, including attachments, is a confidential communication between Suncorp and the intended recipient. If you are not the intended recipient, any use, interference with, disclosure or copying of this e-mail, including attachments, is unauthorised and expressly prohibited. If you have received this e-mail in error please contact the sender immediately and delete the e-mail and any attachments from your system. If this e-mail constitutes a commercial message of a type that you no longer wish to receive please reply to this e-mail by typing Unsubscribe in the subject line. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.comcfaussie%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.comcfaussie%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.comcfaussie%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
[cfaussie] Recursive function giving me 500 null error
Hi guys,
Trying to make a little helper tool for an online game that I play. The game
has a very complex crafting system, and I'm trying to put together something
to allow me to select an item I can craft and find out:
a) all the things I need to make that item, all the way back to the raw
materials, and
b) all the things I can then make from that item.
I've accomplished (b) no problem. Works beautifully. I can accomplish (a)
back one step. Then I try to make that recursive to step all the way back to
the beginning of the sequence and it throws a 500 null error. So I did
some reading and found out that this is an error that means something has
gone wrong so fundamentally early in the code that it doesn't even know how
to display the error. I found a suggestion of putting a cfflush just after
the application setting, but that hasn't helped.
Here are the two functions at play here. If someone can give me any
suggestions about what I may have done wrong, I'd be very grateful.
cffunction name=downTree hint=Returns the details of everything
needed to make an item access=public returntype=array output=no
cfargument name=aItems type=array required=no default=
cfscript
var result = arrayNew(1);
var i = 1;
var qItem = ;
qItem = getItemMadeBy(aItems[1].id);
if (qItem.recordcount) {
result[1] = structNew();
result[1].id = qItem.id;
result[1].item = qItem.item;
result[1].skill = qItem.skillname;
result[1].makes = arguments.aItems;
downTree(result);
}
/cfscript
cfreturn result
/cffunction
cffunction name=getItemMadeBy hint=Gets the items needed to make a
given item access=public returntype=query output=no
cfargument name=item type=string required=no default=
cfquery datasource=#application.dsn# name=qResults debug=yes
result=qItemResult
SELECTi.id, i.item, s.skillname
FROMdi_item i
INNER JOIN di_itemItem ii ON i.id = ii.madeWithID
INNER JOIN di_skill s ON i.skill = s.id
WHEREii.itemID = cfqueryparam cfsqltype=cf_sql_integer
value=#arguments.item#
/cfquery
cfreturn qResults
/cffunction
I've removed the recursive call at the end of the first function so that you
can see the thing in (sort of) action at
http://frontandback.com.au/DarkIsles/index.cfm?do=main.craftTree - select an
item such as a wooden spool of thick thread (the last item in the list).
It will dump out all of the things that you can make from this item, and the
things you can make from those items and so on.It will also show the item
that the thread is made from. What I need is for it to go multiple steps
back, however.
Hope this all makes sense...
Cheers,
Seona.
--
You received this message because you are subscribed to the Google Groups
cfaussie group.
To post to this group, send email to cfaus...@googlegroups.com.
To unsubscribe from this group, send email to
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Recursive function giving me 500 null error
On 12 August 2010 16:27, Sean Corfield seancorfi...@gmail.com wrote: On Wed, Aug 11, 2010 at 9:34 PM, Seona Bellamy seon...@gmail.com wrote: cffunction name=downTree hint=Returns the details of everything needed to make an item access=public returntype=array output=no cfargument name=aItems type=array required=no default= ... downTree(result); Bear in mind that this copies result so changes made inside downTree() are on a copy, not the original, so after calling downTree(), result won't have changed. Aha! Turns out this was the missing piece. Changing that line to: result = downTree(result); has made everything play nicely. Thanks for all the responses and clarifications. I understand what's going on better now, and why it originally screwed itself up. It was indeed caught in a never-ending loop as the first value in the array never changed and so it never got to the beginning of the tree. Cheers, Seona. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
