date:20060321


Ah, I see what you're saying: I should be storing the 'mangled' form of 
the file name?

Our file uploads come via an ASP script which saves the 'proper' name, 
and I recently did a fix to unmangle that on the asp side and it appears 
to have broken the CF side...

I'll have a play with it and see what I can come up with.

Thanks for the tip.

Dale Fraser wrote:
> No it's your file name.
>
> Do what I said last time to work out the proper file name in coldfusion land.
>
> Regards
> Dale Fraser
>
>
>   
>> -Original Message-
>> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
>> Behalf Of Haikal Saadh
>> Sent: Wednesday, 22 March 2006 17:38 PM
>> To: cfaussie@googlegroups.com
>> Subject: [cfaussie] Re: cfcontent and unicode.
>>
>>
>> I can't even cfread the file... with the name of the file hardcoded, it
>> gives me that same error:
>>
>>
>>   An error occurred when performing a file operation read on file
>>   \\some\where\ãƒ‰ãƒªãƒ•ã�®å��æ›²ãƒ¡ãƒãƒ‡ã‚£ãƒ¼.doc.
>>
>>
>> I wonder if it's to do with the encoding of the actual source file?
>>
>>
>> Dale Fraser wrote:
>> 
>>> You can't do that.
>>>
>>> Try this
>>>
>>> 1. Create a page with a file upload box
>>> 2. Pick that japaneese named file
>>> 3. CFDUMP the content of the filename
>>>
>>> You will see it looks like Unicode, not Japanese characters.
>>>
>>> The charset is specifying the charset of the content of the file, not
>>>   
>> the
>> 
>>> content of the filename.
>>>
>>> Regards
>>> Dale Fraser
>>>
>>> Regards
>>> Dale Fraser
>>>
>>>
>>>
>>>   
 -Original Message-
 From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
 Behalf Of Haikal Saadh
 Sent: Wednesday, 22 March 2006 17:16 PM
 To: 'cfaussie@googlegroups.com'
 Subject: [cfaussie] cfcontent and unicode.


 Okay, I've got a chunk of code to enable the downloading the file. The
 code is something like:

 
 

 Yet is doesn't seem to work? Firefox mangles the filename completely,
 and gives me a 0 byte file, whereas IE just sits there.

 The actual file itself does exist, and I can open off the server, but
 the downloads seem to not work. Any ideas?

 /Here's hoping the japanese characters don't get mangled in-transit
 //No, I can't actually read or write japanese... I just copied it from
 some where. Hope it's not an ad for used knickers or something...

 --
 Haikal Saadh, Applications Programmer
 Teaching and Learning Support Services
 K405, Queensland University of Technology, Kelvin Grove Campus
 [EMAIL PROTECTED], 3864 8633
 CRICOS No. 00213J



 
>>>
>>>
>>>   
>> --
>> Haikal Saadh, Applications Programmer
>> Teaching and Learning Support Services
>> K405, Queensland University of Technology, Kelvin Grove Campus
>> [EMAIL PROTECTED], 3864 8633
>> CRICOS No. 00213J
>>
>>
>> 
>
>
>
>
>   


-- 
Haikal Saadh, Applications Programmer
Teaching and Learning Support Services
K405, Queensland University of Technology, Kelvin Grove Campus
[EMAIL PROTECTED], 3864 8633
CRICOS No. 00213J


--~--~-~--~~~---~--~~
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: cfcontent and unicode.


No it's your file name.

Do what I said last time to work out the proper file name in coldfusion land.

Regards
Dale Fraser


> -Original Message-
> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
> Behalf Of Haikal Saadh
> Sent: Wednesday, 22 March 2006 17:38 PM
> To: cfaussie@googlegroups.com
> Subject: [cfaussie] Re: cfcontent and unicode.
> 
> 
> I can't even cfread the file... with the name of the file hardcoded, it
> gives me that same error:
> 
> 
>   An error occurred when performing a file operation read on file
>   \\some\where\ãƒ‰ãƒªãƒ•ã�®å��æ›²ãƒ¡ãƒãƒ‡ã‚£ãƒ¼.doc.
> 
> 
> I wonder if it's to do with the encoding of the actual source file?
> 
> 
> Dale Fraser wrote:
> > You can't do that.
> >
> > Try this
> >
> > 1. Create a page with a file upload box
> > 2. Pick that japaneese named file
> > 3. CFDUMP the content of the filename
> >
> > You will see it looks like Unicode, not Japanese characters.
> >
> > The charset is specifying the charset of the content of the file, not
> the
> > content of the filename.
> >
> > Regards
> > Dale Fraser
> >
> > Regards
> > Dale Fraser
> >
> >
> >
> >> -Original Message-
> >> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
> >> Behalf Of Haikal Saadh
> >> Sent: Wednesday, 22 March 2006 17:16 PM
> >> To: 'cfaussie@googlegroups.com'
> >> Subject: [cfaussie] cfcontent and unicode.
> >>
> >>
> >> Okay, I've got a chunk of code to enable the downloading the file. The
> >> code is something like:
> >>
> >> 
> >> 
> >>
> >> Yet is doesn't seem to work? Firefox mangles the filename completely,
> >> and gives me a 0 byte file, whereas IE just sits there.
> >>
> >> The actual file itself does exist, and I can open off the server, but
> >> the downloads seem to not work. Any ideas?
> >>
> >> /Here's hoping the japanese characters don't get mangled in-transit
> >> //No, I can't actually read or write japanese... I just copied it from
> >> some where. Hope it's not an ad for used knickers or something...
> >>
> >> --
> >> Haikal Saadh, Applications Programmer
> >> Teaching and Learning Support Services
> >> K405, Queensland University of Technology, Kelvin Grove Campus
> >> [EMAIL PROTECTED], 3864 8633
> >> CRICOS No. 00213J
> >>
> >>
> >>
> >
> >
> >
> >
> 
> 
> --
> Haikal Saadh, Applications Programmer
> Teaching and Learning Support Services
> K405, Queensland University of Technology, Kelvin Grove Campus
> [EMAIL PROTECTED], 3864 8633
> CRICOS No. 00213J
> 
> 


--~--~-~--~~~---~--~~
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: cfcontent and unicode.


Hmm... opening the file with the original code stub file (cfcontent and 
all) in notepad, saving it again as utf-8 seemed to at least let firefox 
download the file contents download OK, but the filename still shows up 
as ---.doc. Same with Safari... exept the name is all .doc

IE just dumps the unicode mess out to browser.. how annoying the 
digging continues.

Haikal Saadh wrote:
> I can't even cfread the file... with the name of the file hardcoded, it 
> gives me that same error:
>
>
>   An error occurred when performing a file operation read on file
>   \\some\where\ãƒ‰ãƒªãƒ•ã�®å��æ›²ãƒ¡ãƒãƒ‡ã‚£ãƒ¼.doc.
>
>
> I wonder if it's to do with the encoding of the actual source file?
>
>
> Dale Fraser wrote:
>   
>> You can't do that.
>>
>> Try this
>>
>> 1. Create a page with a file upload box
>> 2. Pick that japaneese named file
>> 3. CFDUMP the content of the filename
>>
>> You will see it looks like Unicode, not Japanese characters.
>>
>> The charset is specifying the charset of the content of the file, not the
>> content of the filename.
>>
>> Regards
>> Dale Fraser
>>
>> Regards
>> Dale Fraser
>>
>>
>>   
>> 
>>> -Original Message-
>>> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
>>> Behalf Of Haikal Saadh
>>> Sent: Wednesday, 22 March 2006 17:16 PM
>>> To: 'cfaussie@googlegroups.com'
>>> Subject: [cfaussie] cfcontent and unicode.
>>>
>>>
>>> Okay, I've got a chunk of code to enable the downloading the file. The
>>> code is something like:
>>>
>>> 
>>> 
>>>
>>> Yet is doesn't seem to work? Firefox mangles the filename completely,
>>> and gives me a 0 byte file, whereas IE just sits there.
>>>
>>> The actual file itself does exist, and I can open off the server, but
>>> the downloads seem to not work. Any ideas?
>>>
>>> /Here's hoping the japanese characters don't get mangled in-transit
>>> //No, I can't actually read or write japanese... I just copied it from
>>> some where. Hope it's not an ad for used knickers or something...
>>>
>>> --
>>> Haikal Saadh, Applications Programmer
>>> Teaching and Learning Support Services
>>> K405, Queensland University of Technology, Kelvin Grove Campus
>>> [EMAIL PROTECTED], 3864 8633
>>> CRICOS No. 00213J
>>>
>>>
>>> 
>>>   
>>
>>   
>> 
>
>
>   


-- 
Haikal Saadh, Applications Programmer
Teaching and Learning Support Services
K405, Queensland University of Technology, Kelvin Grove Campus
[EMAIL PROTECTED], 3864 8633
CRICOS No. 00213J


--~--~-~--~~~---~--~~
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] Adobe licensing

2006-03-21 Thread Ryan Sabir





Heya,
 
Is anyone else baffled by the 
new Adobe licensing scheme? From a few days research this is what we have come 
up with. Please tell me if I've misunderstood something along the 
way:
 
There are 2 ways to purchase 
CF7 "Box Product", and "Volume License".
Box Product sells for $1970 inc 
gst from the Adobe store
Box Product includes CDs and 
manuals
Box Product is NOT eligible for 
a maintenence plan
Volume License cost depends on 
how many Adobe products you already own. 
Say you own none, then the 
license cost is around $2400.00  inc GST for a copy of 
CF7

Volume License does not include the media, 
this costs an extra $173.75 
Volume License does not include the 
manuals, this costs an extra $245.13 

2yr Maintenence costs 
$1050
Total cost of 1 CF7 license 
with manuals and media and 2yr maint. = $3870 
 
 
It appears that the price of 
this has jumped up quite significantly under the new licensing scheme. I'm sure 
I purchased the very same setup for under $2000 at the start of the 
year?
 
Has anyone traversed this maze 
yet? What's the secret combo to get the most CF bang for your 
buck?
 
seeya
 

  
  

Ryan 
  SabirTechnical Directorp: (02) 9274 
  8030f: (02) 9274 8099m: 0411 512 
  454w: www.newgency.com

Newgency Pty 
  LtdWeb | Multimedia | eMarketing224 Riley StSurry 
  Hills NSW 2010Sydney, Australia
 
--~--~-~--~~~---~--~~
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: cfcontent and unicode.


I can't even cfread the file... with the name of the file hardcoded, it 
gives me that same error:


  An error occurred when performing a file operation read on file
  \\some\where\ãƒ‰ãƒªãƒ•ã�®å��æ›²ãƒ¡ãƒãƒ‡ã‚£ãƒ¼.doc.


I wonder if it's to do with the encoding of the actual source file?


Dale Fraser wrote:
> You can't do that.
>
> Try this
>
> 1. Create a page with a file upload box
> 2. Pick that japaneese named file
> 3. CFDUMP the content of the filename
>
> You will see it looks like Unicode, not Japanese characters.
>
> The charset is specifying the charset of the content of the file, not the
> content of the filename.
>
> Regards
> Dale Fraser
>
> Regards
> Dale Fraser
>
>
>   
>> -Original Message-
>> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
>> Behalf Of Haikal Saadh
>> Sent: Wednesday, 22 March 2006 17:16 PM
>> To: 'cfaussie@googlegroups.com'
>> Subject: [cfaussie] cfcontent and unicode.
>>
>>
>> Okay, I've got a chunk of code to enable the downloading the file. The
>> code is something like:
>>
>> 
>> 
>>
>> Yet is doesn't seem to work? Firefox mangles the filename completely,
>> and gives me a 0 byte file, whereas IE just sits there.
>>
>> The actual file itself does exist, and I can open off the server, but
>> the downloads seem to not work. Any ideas?
>>
>> /Here's hoping the japanese characters don't get mangled in-transit
>> //No, I can't actually read or write japanese... I just copied it from
>> some where. Hope it's not an ad for used knickers or something...
>>
>> --
>> Haikal Saadh, Applications Programmer
>> Teaching and Learning Support Services
>> K405, Queensland University of Technology, Kelvin Grove Campus
>> [EMAIL PROTECTED], 3864 8633
>> CRICOS No. 00213J
>>
>>
>> 
>
>
>
>   


-- 
Haikal Saadh, Applications Programmer
Teaching and Learning Support Services
K405, Queensland University of Technology, Kelvin Grove Campus
[EMAIL PROTECTED], 3864 8633
CRICOS No. 00213J


--~--~-~--~~~---~--~~
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: cfcontent and unicode.

You can't do that.

Try this

1. Create a page with a file upload box
2. Pick that japaneese named file
3. CFDUMP the content of the filename

You will see it looks like Unicode, not Japanese characters.

The charset is specifying the charset of the content of the file, not the
content of the filename.

Regards
Dale Fraser

Regards
Dale Fraser


> -Original Message-
> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
> Behalf Of Haikal Saadh
> Sent: Wednesday, 22 March 2006 17:16 PM
> To: 'cfaussie@googlegroups.com'
> Subject: [cfaussie] cfcontent and unicode.
>
>
> Okay, I've got a chunk of code to enable the downloading the file. The
> code is something like:
>
> 
> 
>
> Yet is doesn't seem to work? Firefox mangles the filename completely,
> and gives me a 0 byte file, whereas IE just sits there.
>
> The actual file itself does exist, and I can open off the server, but
> the downloads seem to not work. Any ideas?
>
> /Here's hoping the japanese characters don't get mangled in-transit
> //No, I can't actually read or write japanese... I just copied it from
> some where. Hope it's not an ad for used knickers or something...
>
> --
> Haikal Saadh, Applications Programmer
> Teaching and Learning Support Services
> K405, Queensland University of Technology, Kelvin Grove Campus
> [EMAIL PROTECTED], 3864 8633
> CRICOS No. 00213J
>
>


--~--~-~--~~~---~--~~
これは、お客様が次の Google グループに申し込まれたことを確認するメッセー
ジです。 Google Groups "cfaussie" group.
 To post to this group, send email to cfaussie@googlegroups.com
 このグループから退会するには、次へメールをお送りください。 [EMAIL PROTECTED]
 For more options, visit this group at http://groups.google.com/group/cfaussie
-~--~~~~--~~--~--~---

[cfaussie] Re: cfcontent and unicode.


To reply to myself, seeing these in the application logs:

The cause of this output exception was that:
java.io.FileNotFoundException:
\\some\where\\ãƒ‰ãƒªãƒ•ã?®å??æ›²ãƒ¡ãƒãƒ‡ã‚£ãƒ¼.doc (The system
cannot find the file specified).


So this is something wrong with the encoding of the files on the server?

But if actually cfdump the values as they come out of the database, it 
seems to work OK.

Haikal Saadh wrote:
> Okay, I've got a chunk of code to enable the downloading the file. The 
> code is something like:
>
> 
> 
>
> Yet is doesn't seem to work? Firefox mangles the filename completely, 
> and gives me a 0 byte file, whereas IE just sits there.
>
> The actual file itself does exist, and I can open off the server, but 
> the downloads seem to not work. Any ideas?
>
> /Here's hoping the japanese characters don't get mangled in-transit
> //No, I can't actually read or write japanese... I just copied it from 
> some where. Hope it's not an ad for used knickers or something...
>
>   


-- 
Haikal Saadh, Applications Programmer
Teaching and Learning Support Services
K405, Queensland University of Technology, Kelvin Grove Campus
[EMAIL PROTECTED], 3864 8633
CRICOS No. 00213J


--~--~-~--~~~---~--~~
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] stock exchange web service

2006-03-21 Thread Steve Onnis




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] cfcontent and unicode.


Okay, I've got a chunk of code to enable the downloading the file. The 
code is something like:




Yet is doesn't seem to work? Firefox mangles the filename completely, 
and gives me a 0 byte file, whereas IE just sits there.

The actual file itself does exist, and I can open off the server, but 
the downloads seem to not work. Any ideas?

/Here's hoping the japanese characters don't get mangled in-transit
//No, I can't actually read or write japanese... I just copied it from 
some where. Hope it's not an ad for used knickers or something...

-- 
Haikal Saadh, Applications Programmer
Teaching and Learning Support Services
K405, Queensland University of Technology, Kelvin Grove Campus
[EMAIL PROTECTED], 3864 8633
CRICOS No. 00213J


--~--~-~--~~~---~--~~
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: Flex 2 Beta 2 and the Adobe Flex Developer Derby

2006-03-21 Thread Jon Austin


Hmmm.. wonder if I can submit one of the example apps..

On 3/22/06, Robin Hilliard <[EMAIL PROTECTED]> wrote:
>
> RocketBoots is proud to announce the Rest of World Flex Developer
> Space Race:
>
> http://www.rocketboots.com.au/blog/index.cfm?
> mode=entry&entry=1FE5E366-E081-51EF-A77343DE45041D0E

--~--~-~--~~~---~--~~
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: Flex 2 Beta 2 and the Adobe Flex Developer Derby

2006-03-21 Thread Robin Hilliard


RocketBoots is proud to announce the Rest of World Flex Developer  
Space Race:

http://www.rocketboots.com.au/blog/index.cfm? 
mode=entry&entry=1FE5E366-E081-51EF-A77343DE45041D0E

Good Luck!

__

Robin Hilliard
Director - RocketBoots Pty Ltd
Professional Services for Macromedia Technologies
http://www.rocketboots.com.au

For schedule/availability call Pamela Higgins:
w+61 7 5451 0362
m+61 419 677 151
f+61 3 9923 6261
e[EMAIL PROTECTED]

or Direct:
m+61 418 414 341
e[EMAIL PROTECTED]

  *** Worldwide Adobe Licensing - Volume discounts now start at one  
point ***


On 21/03/2006, at 4:37 PM, Brett Payne-Rhodes wrote:

>
> After reading "OPEN ONLY TO LEGAL RESIDENTS OF THE UNITED STATES" I  
> figured that posting this to cfaussie was a bit of a waste of  
> time... BUT, if anybody from Adobe Australia happens to be reading  
> this then perhaps take the hint... A bit of motivation will go a  
> long way here. I know there are a lot of CF developers (well CFUG- 
> WA members anyway!) who are very keen to have a look at Flex. And a  
> 42-inch plasma TV would be a whole lot of motivation! And maybe  
> even just an Xbox 360!
>
> Cheers,
>
> Brett
> B)
>
> Darren Tracey wrote:
>> Flex 2 Beta 2 is out.
>>
>> Need a reason to finally give Flex 2 a try?  How about getting a shot
>> at being one of 6 (yes 6) developers who will receive:  42-inch  
>> Samsung
>> plasma TV plus a Microsoft Xbox 360.
>>
>> Details at:
>> http://labs.macromedia.com/showcase/special/flexderby/
>>
>>
>> Take note of the part of the terms and conditions that say this:
>> CONTEST IS OPEN ONLY TO LEGAL RESIDENTS OF THE UNITED STATES OR  
>> CANADA,
>> EXCLUDING QUEBEC, WHO ARE AGE 18 YEARS OR OLDER.
>>
>> Regards
>> Darren
>>
>>
>>
>>
>


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

2006-03-21 Thread Brett Payne-Rhodes


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.propID

B)


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.propid
>and 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 doing 
>>this. Have a look at http://www.renovate.com.au/realestate/ to see what 
>>this is yielding me - when there's multiple images attached to a 
>>property, 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 to 
>>have happen, though.
>>
>>Is this a case where I simply have to abandon keeping the images in a 
>>seperate 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's 
>>the 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: Dealing with a random number of images

2006-03-21 Thread Brett Payne-Rhodes


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.propid
   and 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 doing 
> this. Have a look at http://www.renovate.com.au/realestate/ to see what 
> this is yielding me - when there's multiple images attached to a 
> property, 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 to 
> have happen, though.
> 
> Is this a case where I simply have to abandon keeping the images in a 
> seperate 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's 
> the 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: Dealing with a random number of images

2006-03-21 Thread Chad Renando


Just jumping in from left field here and may not be of help, but have
you ever used MS Access?  I find it quite handy as a drag and drop SQL
generator.  I tend to recreate all my databases in Access so I can
hack 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.

Chad
who spends most of his time in left field.

On 3/22/06, Seona Bellamy <[EMAIL PROTECTED]> wrote:
> Hi,
>
>  No probs. Thanks for your help anyway, and thanks for the pointer to the
> forum. I'm headed over there now. :)
>
>  Cheers,
>
>  Seona.
>
>
> On 22/03/06, Scott Thornton
> <[EMAIL PROTECTED]> wrote:
> >
> > Hi,
> >
> > maybe you could ask over at macromedia exchange, there is a forum there
> exclusive to flash-forms within the coldfusion topic.
> >
> >
> http://www.macromedia.com/cfusion/webforums/forum/categories.cfm?forumid=1&catid=22&entercat=y
> >
> > I guess you need a sort of multiple detail section to display all of the
> photos, but only once for the property details.
> >
> > I don't know much about these new fandangled forms, sorry.
> >
>
>
>
>

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

No probs. Thanks for your help anyway, and thanks for the pointer to the forum. I'm headed over there now. :)

Cheers,

Seona.On 22/03/06, Scott Thornton <[EMAIL PROTECTED]> wrote:
Hi,maybe you could ask over at macromedia exchange, there is a forum there exclusive to flash-forms within the coldfusion topic.
http://www.macromedia.com/cfusion/webforums/forum/categories.cfm?forumid=1&catid=22&entercat=yI guess you need a sort of multiple detail section to display all of the photos, but only once for the property details.
I don't know much about these new fandangled forms, sorry.


--~--~-~--~~~---~--~~
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-21 Thread Scott Thornton


Hi,

maybe you could ask over at macromedia exchange, there is a forum there 
exclusive to flash-forms within the coldfusion topic.

http://www.macromedia.com/cfusion/webforums/forum/categories.cfm?forumid=1&catid=22&entercat=y

I guess you need a sort of multiple detail section to display all of the 
photos, but only once for the property details.

I don't know much about these new fandangled forms, sorry.

>>> [EMAIL PROTECTED] 22/03/2006 2:01:38 pm >>>
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 doing this.
Have a look at http://www.renovate.com.au/realestate/ to see what this is
yielding me - when there's multiple images attached to a property, 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 to have
happen, though.

Is this a case where I simply have to abandon keeping the images in a
seperate 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's the
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: Dealing with a random number of images

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 doing
this. Have a look at http://www.renovate.com.au/realestate/ to see what
this is yielding me - when there's multiple images attached to a
property, 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 to
have happen, though.

Is this a case where I simply have to abandon keeping the images in a
seperate 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's
the 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: Dealing with a random number of images

2006-03-21 Thread Brett Payne-Rhodes


Hi Seona,

Almost right...

If you are sure there will always be an agent for a property then use:

select *
  from re_property prop, re_agent agent
  left outer join re_image image 
on image.propid = prop.propid
 where agent.propID = prop.propID


Use 'left outer join' when you're not sure that there will always be a 'join' 
but you always want to return the selected item - 'property' in this case...

select *
  from re_property prop
  left outer join re_image image 
on image.propid = prop.propid
  left outer join re_agent agent
on agent.propID = prop.propID


I also like a bit more structure in my queries ;)

HTH

Brett
B)

Seona Bellamy wrote:
> 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.
> eg
> 
> select
> *
> from
> re_property prop left outer join
> re_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: Call Java Class

2006-03-21 Thread Elliot


You  can also drop class files into class folder and they will be
picked up automatically - which is a bit easier than adding the class
path - if you have access

\wwwroot\WEB-INF\classes

Elliot


--~--~-~--~~~---~--~~
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-21 Thread Scott Thornton


Hello,

select
*
from
re_agent agent inner join
re_property prop on
   agent.agent_id = prop.agent_id left outer join
re_image image on
  prop.propid = image.propid

In practice, inner join first, then outer join, or there can be unintended 
consequences.

Once you use an inner join (or outer) you have to be consistent through-out the 
query.

These types of queries are faster than the antiquated where clause style. 
(particularly so if using MS SQL)

PS left outer joins can be performed with the old method. you use the =* syntax 
(or is it *=). I don't use it so I don't know for sure. 



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

>>> [EMAIL PROTECTED] 22/03/2006 11:10:14 am >>>
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.
> eg
>
> select
> *
> from
> re_property prop left outer join
> re_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, 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

2006-03-21 Thread Scott Thornton


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.

eg

select
*
from
re_property prop left outer join
re_image image on
prop.propid = image.propid

>>> [EMAIL PROTECTED] 22/03/2006 10:22:22 am >>>
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 
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... SELECT * FROM re_Image WHERE propID = #whatever#  --Use cfqueryparam... too lazy to type
Once 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: OT: Flash behind a firewall


Usually the simplest explanation is best

Can they view other flash sites?
Can you get a screenshot of the 'white box'?
What browser they using? Maybe you have a js bug?

Maybe the link is dead to him (Hey, seen it happen a few times)

Ryan Sabir wrote:
> Heya, Sorry for the OT post, but FUGLI seems to be AWOL at the moment...
>  
> We set up a site that uses JavaScript to detect if Flash is installed, 
> and if not, it displays a static graphic, otherwise it displays the Flash.
>  
> When we test it locally by uninstalling Flash it works fine. However 
> our client is saying that one of their users isn't getting a static 
> graphic, or the Flash, all they get is a white square where the Flash 
> should be. This particular user is at Macquarie Bank so I expect 
> there's some sort of firewall there.
>  
> Does anyone know what the firewall setup is like at Macq Bank? Is 
> there a better way to detect this problem and offer alternative content?
>  
> thanks.
>  
>  
>   Ryan Sabir
> Technical Director
>
> *p:* (02) 9274 8030
> *f:* (02) 9274 8099
> *m:* 0411 512 454
> *w:* www.newgency.com   *Newgency Pty 
> Ltd*
> Web | Multimedia | eMarketing
>
> 224 Riley St
> Surry Hills NSW 2010
> Sydney, Australia
>
>  
>
>


-- 
Haikal Saadh, Applications Programmer
Teaching and Learning Support Services
K405, Queensland University of Technology, Kelvin Grove Campus
[EMAIL PROTECTED], 3864 8633
CRICOS No. 00213J


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


If I'm reading you right, all your concerns are serverside..

Problem 1
Seems simple enough...

 SELECT *
 FROM re_Image
 WHERE propID = #whatever#  --Use cfqueryparam... too lazy to type


Once you have that,
if images.recordcount gt 0{
 //you have images, display them
}else{
 // No images. Sorry.
}

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

Seona Bellamy wrote:
> 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 
>  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.
>
>


-- 
Haikal Saadh, Applications Programmer
Teaching and Learning Support Services
K405, Queensland University of Technology, Kelvin Grove Campus
[EMAIL PROTECTED], 3864 8633
CRICOS No. 00213J


--~--~-~--~~~---~--~~
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] OT: Flash behind a firewall

2006-03-21 Thread Ryan Sabir





Heya, Sorry for the OT post, but FUGLI seems to be AWOL at 
the moment...
 
We set up a site that uses 
_javascript_ to detect if Flash is installed, and if not, it displays a static 
graphic, otherwise it displays the Flash.
 
When we test it locally by 
uninstalling Flash it works fine. However our client is saying that one of their 
users isn't getting a static graphic, or the Flash, all they get is a white 
square where the Flash should be. This particular user is at Macquarie Bank so I 
expect there's some sort of firewall there.
 
Does anyone know what the 
firewall setup is like at Macq Bank? Is there a better way to detect this 
problem and offer alternative content?
 
thanks.
 
 

  
  

Ryan 
  SabirTechnical Directorp: (02) 9274 
  8030f: (02) 9274 8099m: 0411 512 
  454w: www.newgency.com

Newgency Pty 
  LtdWeb | Multimedia | eMarketing224 Riley StSurry 
  Hills NSW 2010Sydney, Australia
 
--~--~-~--~~~---~--~~
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
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.

[cfaussie] Re: DB field with a space in it

2006-03-21 Thread Shib71

#qContacts["First Name"][currentRow]#On 3/21/06, 
Dale Fraser <[EMAIL PROTECTED]> wrote:
How aboutFirst_Name> -Original Message-> From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com
] On> Behalf Of Ryan Sabir> Sent: Tuesday, 21 March 2006 6:20 PM> To: 'cfaussie@googlegroups.com'> Subject: [cfaussie] Re: DB field with a space in it
 I'm writing a reusable module that can take a query object and dump it to> a CSV file, and looking at ways to make the header row of the CSV file> more user friendly.>
> I tried the array format and thought it didn't work, but there's a bunch> of 'evaluate()'s and whatnot around it. I'll give it another go.>> Bye!>>> -Original Message-
> From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On> Behalf Of Dale Fraser> Sent: Tuesday, 21 March 2006 6:13 PM
> To: cfaussie@googlegroups.com> Subject: [cfaussie] Re: DB field with a space in it>>> Two ideas.>> 1. Don't put a space in, the as Can be AS 'FirstName'
>> Or>> 2. You can probably access it in the array format.>> #qContacts['First Name']#>> But I really don't see why you can't do 1.>> Regards> Dale Fraser
>>> > -Original Message-> > From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com
] On> > Behalf Of Ryan Sabir> > Sent: Tuesday, 21 March 2006 18:05 PM> > To: 'cfaussie@googlegroups.com'> > Subject: [cfaussie] DB field with a space in it
> >> > Heya,> >> > How would I go about accessing the value of a query object, where> > there is a space in the field name?> >> > e.g.> >
> > > > SELECT firstName AS 'First Name'> > FROM contacts> > > >> > #qContacts.First Name#
> >> > This code breaks obviously. But is there a different way to access> > this field?> >> > thanks...> >> >> >  <
http://www.newgency.com/footerImages/logo.gif>Ryan Sabir> > Technical Director> >> > p: (02) 9274 8030> > f: (02) 9274 8099> > m: 0411 512 454> > w: 
www.newgency.com > >   Newgency Pty Ltd> > Web | Multimedia | eMarketing> >> > 224 Riley St> > Surry Hills NSW 2010> > Sydney, Australia> >> >> >>>

--~--~-~--~~~---~--~~
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: Flex 2 Beta 2 and the Adobe Flex Developer Derby

2006-03-21 Thread Barry Beattie


"EXCLUDING QUEBEC"

gee, and I thought it was only the English that were such Frank-a-phobes



On 3/21/06, Brett Payne-Rhodes <[EMAIL PROTECTED]> wrote:
>
> After reading "OPEN ONLY TO LEGAL RESIDENTS OF THE UNITED STATES" I figured 
> that posting this to cfaussie was a bit of a waste of time... BUT, if anybody 
> from Adobe Australia happens to be reading this then perhaps take the hint... 
> A bit of motivation will go a long way here. I know there are a lot of CF 
> developers (well CFUG-WA members anyway!) who are very keen to have a look at 
> Flex. And a 42-inch plasma TV would be a whole lot of motivation! And maybe 
> even just an Xbox 360!
>
> Cheers,
>
> Brett
> B)
>
> Darren Tracey wrote:
> > Flex 2 Beta 2 is out.
> >
> > Need a reason to finally give Flex 2 a try?  How about getting a shot
> > at being one of 6 (yes 6) developers who will receive:  42-inch Samsung
> > plasma TV plus a Microsoft Xbox 360.
> >
> > Details at:
> > http://labs.macromedia.com/showcase/special/flexderby/
> >
> >
> > Take note of the part of the terms and conditions that say this:
> > CONTEST IS OPEN ONLY TO LEGAL RESIDENTS OF THE UNITED STATES OR CANADA,
> > EXCLUDING QUEBEC, WHO ARE AGE 18 YEARS OR OLDER.
> >
> > Regards
> > Darren
> >
> >
> >
> >
>
>
>

--~--~-~--~~~---~--~~
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: Call Java Class (Java Code Attached)

Yeah,

This is a standard Java routine for encryption off the net, Coldfusion is
supposed to talk to Java easily and if I have to modify the java code, then
that's useless to me.

It would be just as easy to write this in CF as a component. I didn't want
to reinvent the wheel.

Regards
Dale Fraser

> -Original Message-
> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
> Behalf Of darryl lyons
> Sent: Tuesday, 21 March 2006 8:33 PM
> To: cfaussie@googlegroups.com
> Subject: [cfaussie] Re: Call Java Class (Java Code Attached)
> 
> 
> Frankly, I think you should get the Java guys to write you a wrapper
> class. I think Mark is right, the problem is with the class.
> 
> Darryl
> 
> On 3/21/06, Dale Fraser <[EMAIL PROTECTED]> wrote:
> >
> > Actually,
> >
> > Once I replaced the

[cfaussie] Re: Call Java Class (Java Code Attached)

2006-03-21 Thread darryl lyons


Frankly, I think you should get the Java guys to write you a wrapper
class. I think Mark is right, the problem is with the class.

Darryl

On 3/21/06, Dale Fraser <[EMAIL PROTECTED]> wrote:
>
> Actually,
>
> Once I replaced the

[cfaussie] Re: DB field with a space in it