[cfaussie] Re: encoding and word docs

2006-05-21 Thread Mark Ireland
Its UTF-8 but writeOutput(toString(thisBlob.BLOB_CONTENT,"UTF-8")); does not help word recognise and open the doc without encoding issues. >From: "Blair McKenzie" <[EMAIL PROTECTED]> >Reply-To: cfaussie@googlegroups.com >To: cfaussie@googlegroups.com >Subject: [cfaussie] Re: encoding and word

[cfaussie] Re: encoding and word docs

2006-05-21 Thread Blair McKenzie
What is the encoding for the cf page? The header might effect how the output is interpreted at the client, but the cf setting determines how it is outputed.BlairOn 5/22/06, Mark Ireland <[EMAIL PROTECTED]> wrote: Anyone know why this code returns a microsoft word doc from a blob but withthe wrong

[cfaussie] encoding and word docs

2006-05-21 Thread Mark Ireland
Anyone know why this code returns a microsoft word doc from a blob but with the wrong encoding? value="attachment;filename=supportingdoc.doc"> writeOutput(toString(thisBlob.BLOB_CONTENT)); _ Research and compare new cars

[cfaussie] Re: How do myQuery["columnName"] ?

2006-05-21 Thread Mark Mandel
The only thing I'd be worried about here is certain JDBC drivers returning null from a getString(), which can cause a bit of havoc with CF variables if you aren't looking out for it. But a good technique never the less. Mark On 5/22/06, Patrick Branley <[EMAIL PROTECTED]> wrote: > dunno. > > b

[cfaussie] Re: How do myQuery["columnName"] ?

2006-05-21 Thread Patrick Branley
dunno. but it doesnt really matter, either way you hav access to publich method 'getString(columnName)' and whatever it is internally you can convert back n forth to a jdbc.sql.recordset http://www.petefreitag.com/item/73.cfm PatOn 5/22/06, Barry Beattie <[EMAIL PROTECTED]> wrote: >>  works be

[cfaussie] Re: How do myQuery["columnName"] ?

2006-05-21 Thread Mark Mandel
Thanks everyone. Seems like CF is just a little syntactically confusing - anywhere else you have '.' you can use [''], but not here. Cheers, Mark On 5/22/06, Blair McKenzie <[EMAIL PROTECTED]> wrote: > Cfoutput and cfloop don't change the query, they just create local variables > with the colu

[cfaussie] Re: How do myQuery["columnName"] ?

2006-05-21 Thread Blair McKenzie
Cfoutput and cfloop don't change the query, they just create local variables with the column names (plus query.currentrow). When you refer to query.column, you're refering back to the origonal query. If you aren't using currentrow or the local variables you might as well not have a query loop at al

[cfaussie] Re: How do myQuery["columnName"] ?

2006-05-21 Thread Barry Beattie
>> works because you actually have a java object of type jdbc.recordset are you *sure* it's a recordset, not a hashtable? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, sen

[cfaussie] Re: How do myQuery["columnName"] ?

2006-05-21 Thread Steve Onnis
if your inside the cfoutput you dont need to do that as the query loop increments the row counter with currentRow, so all you need it evaluate(column) to get the value -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] Behalf Of Dale Fraser Sent: Monday, May 22,

[cfaussie] Re: How do myQuery["columnName"] ?

2006-05-21 Thread Barry Beattie
Mark I'm real rusty on this (it's been a while and a lot of C# and Flex code since then)... but (IIRC) a query is a struct of arrays where the struct is the column and each value of that column an element in the array I think the confusion is the way that "CFLOOP query=" written has the implie

[cfaussie] Re: How do myQuery["columnName"] ?

2006-05-21 Thread Patrick Branley
MyQuery.getString("columnName") works because you actually have a java object of type jdbc.recordsetor evaluate("myquery.columnName") works too.Pat On 5/22/06, Mark Mandel <[EMAIL PROTECTED]> wrote: Hey all,This seems like a stupid question, but I can't seem to figure itIf I have a query, called 'm

[cfaussie] Re: How do myQuery["columnName"] ?

2006-05-21 Thread Dale Fraser
Well I don't see what's wrong with (2) that's the best way but you could evaluate("myQuery.#column#") Regards Dale Fraser -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mark Mandel Sent: Monday, 22 May 2006 12:13 PM To: cfaussie@googleg

[cfaussie] How do myQuery["columnName"] ?

2006-05-21 Thread Mark Mandel
Hey all, This seems like a stupid question, but I can't seem to figure it If I have a query, called 'myQuery' I can do: (1) myQuery.column and it will output fine. I can do: (2) myQuery[column][myQuery.currentRow] and it will output fine But if I do: (3) myQuery[column] I

[cfaussie] Re: [OT] Long & Lat query

2006-05-21 Thread Taco Fleur
thanks Adam,   I will have a play with that.  On 5/22/06, Adam Chapman <[EMAIL PROTECTED]> wrote: Enjoy…   SELECT    suburbId, suburbName FROM       suburb WHERE    ROUND((ACOS((SIN(#suburb_latitude#/57.2958) * SIN(suburb_latitude /57.2958)) + (COS(#suburb_latitude#/57.2

[cfaussie] Re: [OT] Long & Lat query

2006-05-21 Thread Adam Chapman
Enjoy…   SELECT    suburbId, suburbName FROM       suburb WHERE    ROUND((ACOS((SIN(#suburb_latitude#/57.2958) * SIN(suburb_latitude /57.2958)) + (COS(#suburb_latitude#/57.2958) * COS(suburb_latitude /57.2958) * COS(suburb_longitude/57.2958 - #suburb_longitude#/5

[cfaussie] [OT] Long & Lat query

2006-05-21 Thread Taco Fleur
Is anyone able to share a query with me that will calculate surrounding suburbs on a longitude and latitude database? I have the database, but not the query. Thanks-- Taco Fleur - http://www.pacificfox.com.au Web Design, Web development, Graphic Design and Complete Internet Solutionsan industry lea