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
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
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
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
) 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
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
-
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
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
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
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
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
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
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!
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
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
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
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
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%
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
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
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
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
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
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
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.
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:
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
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.
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
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
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
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
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
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,
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
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
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
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
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
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
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
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 ---
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
-
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
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
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
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
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
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.
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
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
51 matches
Mail list logo