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