[cfaussie] Re: stock exchange web service

2006-03-22 Thread darryl lyons

Here is one. We use IRESS ourselves (as do most of the brokers).

http://www.iress.com.au/information/info_ws_pd.asp

Darryl

On 3/22/06, Steve Onnis [EMAIL PROTECTED] wrote:

 Does anyone know of a webservice that I can use to access the ASX at all?

 As well as this, a site that has a good listing of some interesting web
 services like weather and so on

 Redards

 Steve Onnis



--~--~-~--~~~---~--~~
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

2006-03-22 Thread Shib71
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
On 3/22/06, Brett Payne-Rhodes [EMAIL PROTECTED] wrote:
In fact this should work too...select * from re_property prop, re_agent agent left outer join re_image image on image.imageid = (select max(imageId) from re_image where re_image.propid = prop.propid)
where agent.propID = prop.propIDB)Brett Payne-Rhodes wrote: Hi Seona, A workaround that should work... select * from re_property prop, re_agent agent
 left outer join re_image image on image.propid = prop.propidand image.imageid = (select max(imageId) from re_image where re_image.propid = prop.propid)where agent.propID = prop.propID
 Assuming 'imageId' is the key for your re_image table. This will get you the latest(?) image added for a property. min(imageId) would get you the first(?) image added for a property. You might need a flag on the image to indicate which one is the 'main' image perhaps...
 Cheers, Brett B) Seona Bellamy wrote:Brett and Scott,Thanks for that, I think I'm slowly starting to understand the join thing.
Sadly, however, I've found a small problem with the way we're doingthis. Have a look at http://www.renovate.com.au/realestate/ to see what
this is yielding me - when there's multiple images attached to aproperty, that property appears multiple times in the list.Now, I went and did a bit of reading and as far as I can tell that is
exactly what's supposed to happen. It's not quite what I'd wanted tohave happen, though.Is this a case where I simply have to abandon keeping the images in aseperate table and make them part of the re_property table? I'd always
thought that was a clumsy way of doing it, but I'm willing to if it'sthe only way to achieve the results I want.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: stock exchange web service

2006-03-22 Thread Steve Onnis

Darryl

I just called them up and they told me the min cost per month is $1000 per
month and it goes up from there.  That sound right to you?

Steve

-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of darryl lyons
Sent: Wednesday, March 22, 2006 7:31 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: stock exchange web service


Here is one. We use IRESS ourselves (as do most of the brokers).

http://www.iress.com.au/information/info_ws_pd.asp

Darryl

On 3/22/06, Steve Onnis [EMAIL PROTECTED] wrote:

 Does anyone know of a webservice that I can use to access the ASX at all?

 As well as this, a site that has a good listing of some interesting web
 services like weather and so on

 Redards

 Steve Onnis









--~--~-~--~~~---~--~~
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

2006-03-22 Thread Seona Bellamy
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

2006-03-22 Thread Shib71
Would it be practical to store the image ids as a list and use that?BlairOn 3/23/06, Seona Bellamy [EMAIL PROTECTED]
 wrote: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

2006-03-22 Thread Karen Johnstone



Hi Seona,

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!

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.propidWHERE a.propID = p.propIDAND 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


Thanks,
kj
--
--- 

-- 
Karen Johnstone - Software 
Development Manager 
Web Raven Pty Ltd 

Email: [EMAIL PROTECTED] 
Phone: +61 7 3220 2229 
Web: http://www.webraven.com.au Fax: +61 7 3220 2280 

---




From: cfaussie@googlegroups.com 
[mailto:[EMAIL PROTECTED] 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.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

2006-03-22 Thread Seona Bellamy
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] Dealing with a random number of images

2006-03-22 Thread Scott Thornton

Hello,

Could you insert an integer column in your images table to represent the order 
of the images per property?

That way you could join like
select
i1.imagename,
i2.imagename,
i3.imagename ..

from
re_property p inner join
re_agent a on
   p.prop_id = a.prop_id  LEFT OUTER JOIN 
re_image i1 ON 
i1.propid = p.propid and
i1.image_order = 1  LEFT OUTER JOIN 
re_image i2 ON 
i2.propid = p.propid and
i2.image_order = 2 LEFT OUTER JOIN 
re_image i3 ON 
i3.propid = p.propid and
i3.image_order = 3 etc etc etc



Scott Thornton, Programmer
Application Development
Information Services and Telecommunications
Hunter-New England Area Health Service
p: +61 2 49813589
m: 0413800242
e: scott.thornton at hnehealth.nsw.gov.au

 [EMAIL PROTECTED] 23/03/2006 10:01 am 
Hi Seona,
 
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!
 
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
WHERE a.propID = p.propID
AND i1.imageID  i2.imageID
AND i1.imageID  i3.imageID
AND i1.imageID  i4.imageID
AND i1.imageID  i5.imageID
AND i2.imageID  i3.imageID
AND i2.imageID  i4.imageID
AND i2.imageID  i5.imageID
AND i3.imageID  i4.imageID
AND i3.imageID  i5.imageID
AND i4.imageID  i5.imageID
 
Thanks,
kj
--
--- 
-- 
Karen Johnstone - Software Development Manager 
Web Raven Pty Ltd 
Email: [EMAIL PROTECTED]Phone: +61 7 3220 2229 
Web: http://www.webraven.com.au http://www.webraven.com.au/  Fax: +61
7 3220 2280 
---
 
 

  _  

From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Seona Bellamy
Sent: Thursday, 23 March 2006 8:46 AM
To: cfaussie@googlegroups.com 
Subject: [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.

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

2006-03-22 Thread Karen Johnstone



Hi Seona,Scott's idea to have the property'simage 
number (1-5) stored with image would reduce complexity of ensuring each joined 
record is for a different image.Did some testing  it looks like the 
check to get unique images needs to go with the LEFT JOIN constraints as I 
thinkScott was suggesting. 
Don't know how you'd do it without Scott's idea - you'd have to 
play around with it yourself.
My tables: RE_Properties 
(PropertyID, PropertyName, 
AgentID) RE_Agents (AgentID, 
AgentName) RE_PropertyImages 
(ImageID, PropertyID, ListOrder, ImageName)Query (same as 
Scott's):SELECT 
p.PropertyName, a.AgentName, 
i1.ImageName AS Image1, 
i2.ImageName AS Image2, 
i3.ImageName AS Image3, 
i4.ImageName AS Image4, 
i5.ImageName AS Image5 
[...]FROM RE_Properties 
p INNER JOIN RE_Agents 
a 
 ON ( p.AgentID = a.AgentID 
) LEFT JOIN RE_PropertyImages 
i1 
 ON ( p.PropertyID = i1.PropertyID AND 
i1.ListOrder = 1 ) LEFT JOIN 
RE_PropertyImages i2 
 ON ( p.PropertyID = i2.PropertyID AND 
i2.ListOrder = 2 ) LEFT JOIN 
RE_PropertyImages i3 
 ON ( p.PropertyID = i3.PropertyID AND 
i3.ListOrder = 3 ) LEFT JOIN 
RE_PropertyImages i4 
 ON ( p.PropertyID = i4.PropertyID AND 
i4.ListOrder = 4 ) LEFT JOIN 
RE_PropertyImages i5 
 ON ( p.PropertyID = i5.PropertyID AND 
i5.ListOrder = 5 )[WHERE 
...]Thanks,kj---Karen 
Johnstone - Software Development ManagerWeb Raven Pty LtdEmail: 
[EMAIL PROTECTED] Phone: +61 7 
3220 2229Web: http://www.webraven.com.au Fax: +61 7 3220 
2280---
--~--~-~--~~~---~--~~
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: Help me save CF!

2006-03-22 Thread Mike Kear
SInce this is for senior management, perhaps you should google for the following: 

See John run. Run John run + ColdFusion CheersMike KearWindsor, NSW, AustraliaCertified Advanced ColdFusion DeveloperAFP Webworkshttp://afpwebworks.com
ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month 


On 3/23/06, Barry Beattie [EMAIL PROTECTED] wrote:
this is mostly second hand info (until the boss gets back) but itseems some Dilbert-type (up high)manager is having a swipe at CF
because of the need to have it work with JavaWTF? they obviously haven't any tech knowledge worth cred so I'masking for help to combat ignorance:can any one point me to some really simple articles that are easy (for
managers to read) something along the lines ofColdfusion *IS* JAVAColdFusion is the 4GL implementation OF JAVAColdFusion is the Productivity layer FOR JAVAwe've already mobilised the troops to deal with how well CF works with
Java so this is like a second front. The best form of defence isATTACKI've got a couple:http://www.macromedia.com/devnet/coldfusion/articles/intro_cf7_08.html
http://discuss.joelonsoftware.com/default.asp?joel.3.32052.6but it really needs something with big flashy lights and small words.
Can anyone suggest better links?thanxbarry.b

--~--~-~--~~~---~--~~
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: Help me save CF!

2006-03-22 Thread Barry Moore

Well Barry if you look at who are the really big players in the
commercial Java world you have

BEA with WebLogic
http://www.actionscript.org/press/archives/000135.shtml

IBM with Websphere
http://whitepapers.techrepublic.com.com/abstract.aspx?docid=134896promo=400222kw=ColdFusion
http://www-03.ibm.com/press/us/en/pressrelease/509.wss
http://www-03.ibm.com/press/us/en/pressrelease/768.wss

and SUN themselves
http://www.sun.com/emrkt/innercircle/newsletter/spotlight0203.html
http://www.sun.com/smi/Press/sunflash/2002-04/sunflash.20020429.2.xml
http://www.sun.com/smi/Press/sunflash/2002-06/sunflash.20020619.3.xml
http://www.sun.com/smi/Press/sunflash/2003-06/sunflash.20030605.3.xml

all of whom have offical support in the ColdFusion world. Not sure how
you can argue against that.
http://www.macromedia.com/software/coldfusion/productinfo/systemreqs/
http://www.javalobby.org/articles/coldfusion/
http://cfdj.sys-con.com/read/42036.htm


Barry M



Barry Beattie wrote:
 this is mostly second hand info (until the boss gets back) but it
 seems some Dilbert-type (up high)  manager is having a swipe at CF
 because of the need to have it work with Java

 WTF? they obviously haven't any tech knowledge worth cred so I'm
 asking for help to combat ignorance:

 can any one point me to some really simple articles that are easy (for
 managers to read) something along the lines of

 Coldfusion *IS* JAVA
 ColdFusion is the 4GL implementation OF JAVA
 ColdFusion is the Productivity layer FOR JAVA

 we've already mobilised the troops to deal with how well CF works with
 Java so this is like a second front. The best form of defence is
 ATTACK

 I've got a couple:
 http://www.macromedia.com/devnet/coldfusion/articles/intro_cf7_08.html
 http://discuss.joelonsoftware.com/default.asp?joel.3.32052.6


 but it really needs something with big flashy lights and small words.
 Can anyone suggest better links?
 
 thanx
 barry.b


--~--~-~--~~~---~--~~
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: Link States - Cities - Suburbs

2006-03-22 Thread Joel Cass

You can use the auspost database.. It's a bit rough but a good starting
point.

http://www1.auspost.com.au/postcodes/index.asp?sub=2

-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED]
Behalf Of Jonas H
Sent: Thursday, 23 March 2006 1:44 PM
To: cfaussie
Subject: [cfaussie] Link States - Cities - Suburbs



Hi,

What I want to achieve is when someone registering they choose state
and then you get a list will all cities in that state - then they
select city and you get list of the suburbs in that city etc.

Does anyone know if it possible to get (or buy) a database with cities
and there suburbs in Australia??

Regrads

Jonas







--~--~-~--~~~---~--~~
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
-~--~~~~--~~--~--~---