Array to list function - works in ACF not in Lucee

dev google-group-archive
1

Hello all,

I have a file that uses this function…

67:

And it’s getting this error

Lucee 4.5.1.000 Error (java.sql.SQLException) Message method is not
implemented Cause java.sql.SQLException

This works fine is Adobe ColdFusion but not in Lucee - any suggestions on
what might need to be changed? The database is MySQL

Thanks

Larry

2

You may want to check that getColumnLabels() is available in getMetadata().
I’ve run into issues that worked under ACF the failed under Railo calling
getMetadata() functions.

But ArrayToList should be working just fine if you’re getting an array
back. :wink:

Chip.On Monday, March 23, 2015 at 4:02:21 PM UTC-4, localtel...@gmail.com wrote:

Hello all,

I have a file that uses this function…

67:

And it’s getting this error

Lucee 4.5.1.000 Error (java.sql.SQLException) Message method is not
implemented Cause java.sql.SQLException

This works fine is Adobe ColdFusion but not in Lucee - any suggestions on
what might need to be changed? The database is MySQL

Thanks

Larry

3

Got it.

Lucee, and Railo didn’t like

So using this instead…

Lucee is happy now!

Thanks for the help folks!On Monday, March 23, 2015 at 2:02:15 PM UTC-7, Chip Pinkston wrote:

I meant dump that function call:

Under ACF you’ll see a bunch of methods there - including getColumnLabels.
I’m just trying this on a quick temp query locally and Lucee is throwing
an error of ‘method is not implemented’.

<cfset qry = QueryNew(‘testing’)>

Here are some notes about how getMetaData was different under Railo from
ACF - this looks like it’s your issue:
https://issues.jboss.org/browse/RAILO-1283

On Monday, March 23, 2015 at 4:35:44 PM UTC-4, localtel...@gmail.com wrote:

Sorry, this let me more confused than I was… How would I check to see
if this is available? This is my first venture into Lucee so admittedly a
novice here.

Thank you

On Monday, March 23, 2015 at 1:09:55 PM UTC-7, Chip Pinkston wrote:

You may want to check that getColumnLabels() is available in
getMetadata(). I’ve run into issues that worked under ACF the failed under
Railo calling getMetadata() functions.

But ArrayToList should be working just fine if you’re getting an array
back. :wink:

Chip.

On Monday, March 23, 2015 at 4:02:21 PM UTC-4, localtel...@gmail.com wrote:

Hello all,

I have a file that uses this function…

67:

And it’s getting this error

Lucee 4.5.1.000 Error (java.sql.SQLException) Message method is not
implemented Cause java.sql.SQLException

This works fine is Adobe ColdFusion but not in Lucee - any suggestions
on what might need to be changed? The database is MySQL

Thanks

Larry

4

Sorry, this let me more confused than I was… How would I check to see if
this is available? This is my first venture into Lucee so admittedly a
novice here.

Thank youOn Monday, March 23, 2015 at 1:09:55 PM UTC-7, Chip Pinkston wrote:

You may want to check that getColumnLabels() is available in
getMetadata(). I’ve run into issues that worked under ACF the failed under
Railo calling getMetadata() functions.

But ArrayToList should be working just fine if you’re getting an array
back. :wink:

Chip.

On Monday, March 23, 2015 at 4:02:21 PM UTC-4, localtel...@gmail.com wrote:

Hello all,

I have a file that uses this function…

67:

And it’s getting this error

Lucee 4.5.1.000 Error (java.sql.SQLException) Message method is not
implemented Cause java.sql.SQLException

This works fine is Adobe ColdFusion but not in Lucee - any suggestions
on what might need to be changed? The database is MySQL

Thanks

Larry

5

I meant dump that function call:

Under ACF you’ll see a bunch of methods there - including getColumnLabels.
I’m just trying this on a quick temp query locally and Lucee is throwing
an error of ‘method is not implemented’.

<cfset qry = QueryNew(‘testing’)>

Here are some notes about how getMetaData was different under Railo from
ACF - this looks like it’s your issue:
https://issues.jboss.org/browse/RAILO-1283On Monday, March 23, 2015 at 4:35:44 PM UTC-4, localtel...@gmail.com wrote:

Sorry, this let me more confused than I was… How would I check to see
if this is available? This is my first venture into Lucee so admittedly a
novice here.

Thank you

On Monday, March 23, 2015 at 1:09:55 PM UTC-7, Chip Pinkston wrote:

You may want to check that getColumnLabels() is available in
getMetadata(). I’ve run into issues that worked under ACF the failed under
Railo calling getMetadata() functions.

But ArrayToList should be working just fine if you’re getting an array
back. :wink:

Chip.

On Monday, March 23, 2015 at 4:02:21 PM UTC-4, localtel...@gmail.com wrote:

Hello all,

I have a file that uses this function…

67:

And it’s getting this error

Lucee 4.5.1.000 Error (java.sql.SQLException) Message method is not
implemented Cause java.sql.SQLException

This works fine is Adobe ColdFusion but not in Lucee - any suggestions
on what might need to be changed? The database is MySQL

Thanks

Larry

6

Larry,

What happens if run a similar query in some test code and dump

myQuery.getMetadata().getColumnLabels() ? (I think it would error in the
same way)

What happens if you dump myQuery.getMetadata() ?

Since you need a list of columns, perhaps you could use the function
querycolumnlist() - http://www.luceedocs.org/function/querycolumnlist

Aria Media Sagl
Via Rompada 40
6987 Caslano
Switzerland

+41 (0)91 600 9601
+41 (0)76 303 4477 cell
skype: ariamediaOn Mon, Mar 23, 2015 at 9:35 PM, <@localtelmarketing> wrote:

Sorry, this let me more confused than I was… How would I check to see
if this is available? This is my first venture into Lucee so admittedly a
novice here.

Thank you

On Monday, March 23, 2015 at 1:09:55 PM UTC-7, Chip Pinkston wrote:

You may want to check that getColumnLabels() is available in
getMetadata(). I’ve run into issues that worked under ACF the failed under
Railo calling getMetadata() functions.

But ArrayToList should be working just fine if you’re getting an array
back. :wink:

Chip.

On Monday, March 23, 2015 at 4:02:21 PM UTC-4, localtel...@gmail.com wrote:

Hello all,

I have a file that uses this function…

67:

And it’s getting this error

Lucee 4.5.1.000 Error (java.sql.SQLException) Message method is not
implemented Cause java.sql.SQLException

This works fine is Adobe ColdFusion but not in Lucee - any suggestions
on what might need to be changed? The database is MySQL

Thanks

Larry

–
You received this message because you are subscribed to the Google Groups
“Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/f3dab7d0-3774-4ff8-a7e2-48cbde47c6eb%40googlegroups.com
https://groups.google.com/d/msgid/lucee/f3dab7d0-3774-4ff8-a7e2-48cbde47c6eb%40googlegroups.com?utm_medium=email&utm_source=footer
.

For more options, visit https://groups.google.com/d/optout.

7

You need to know that Lucee <> ACF.

So there are some/many implementations that are different. And the thing you are using is an undocumented feature. If the getColumnLabels() Method is a method of the Adobe query resultset then you cannot rely that we have implemented the resultset in Lucee in the same way ACF has done it.

So you could work around this by checking what methods the Lucee resultset has in the underlying java collection class, but then again you are on an undocumented path.

Sincerely
Gert Franz

RASIA GmbH

Spittelgasse 7

5103 Moeriken-Wildegg

Email: mailto:Gert_Franz @Gert_Franz
Skype: gert.franz

Phone Switzerland: +41 76 5680 231Von: lucee@googlegroups.com [mailto:lucee@googlegroups.com] Im Auftrag von @localtelmarketing
Gesendet: Montag, 23. März 2015 23:19
An: lucee@googlegroups.com
Betreff: [Lucee] Re: Array to list function - works in ACF not in Lucee

Got it.

Lucee, and Railo didn’t like

So using this instead…

Lucee is happy now!

Thanks for the help folks!

On Monday, March 23, 2015 at 2:02:15 PM UTC-7, Chip Pinkston wrote:

I meant dump that function call:

Under ACF you’ll see a bunch of methods there - including getColumnLabels. I’m just trying this on a quick temp query locally and Lucee is throwing an error of ‘method is not implemented’.

<cfset qry = QueryNew(‘testing’)>

Here are some notes about how getMetaData was different under Railo from ACF - this looks like it’s your issue:

https://issues.jboss.org/browse/RAILO-1283

On Monday, March 23, 2015 at 4:35:44 PM UTC-4, localtel...@gmail.com wrote:

Sorry, this let me more confused than I was… How would I check to see if this is available? This is my first venture into Lucee so admittedly a novice here.

Thank you

On Monday, March 23, 2015 at 1:09:55 PM UTC-7, Chip Pinkston wrote:

You may want to check that getColumnLabels() is available in getMetadata(). I’ve run into issues that worked under ACF the failed under Railo calling getMetadata() functions.

But ArrayToList should be working just fine if you’re getting an array back. :wink:

Chip.

On Monday, March 23, 2015 at 4:02:21 PM UTC-4, localtel...@gmail.com wrote:

Hello all,

I have a file that uses this function…

67:

And it’s getting this error

Lucee 4.5.1.000 Error (java.sql.SQLException)

Message

method is not implemented

Cause

java.sql.SQLException

This works fine is Adobe ColdFusion but not in Lucee - any suggestions on what might need to be changed? The database is MySQL

Thanks

Larry

–
You received this message because you are subscribed to the Google Groups “Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an email to lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/4d186620-18c0-4981-9e9a-a15a20d0f009%40googlegroups.com https://groups.google.com/d/msgid/lucee/4d186620-18c0-4981-9e9a-a15a20d0f009%40googlegroups.com?utm_medium=email&utm_source=footer .
For more options, visit https://groups.google.com/d/optout.

8

Good info Gert, Thanks!

I developed this site and application in ACF and it was a nearly painless
process to to move to Lucee - there were some differences, obviously, but
none that could not be overcome. The core of ACF and Lucee are close enough
that having an app that works well under both is certainly doable. Over
time it will be interesting to see if this remains the case. It will also
be interesting to see if Lucee, among the non-enterprise user community,
grows large enough where it will make sense to target Lucee and no longer
worry about CF compatibility… Frankly, with the direction that Adobe
appears to be taking CF, I think I’m hoping it will!

LarryOn Tuesday, March 24, 2015 at 2:25:47 AM UTC-7, Gert Franz wrote:

You need to know that Lucee <> ACF.

So there are some/many implementations that are different. And the thing
you are using is an undocumented feature. If the getColumnLabels() Method
is a method of the Adobe query resultset then you cannot rely that we have
implemented the resultset in Lucee in the same way ACF has done it.

So you could work around this by checking what methods the Lucee resultset
has in the underlying java collection class, but then again you are on an
undocumented path.

Sincerely
Gert Franz

RASIA GmbH

Spittelgasse 7

5103 Moeriken-Wildegg

Email: @Gert_Franz <javascript:>
Skype: gert.franz

Phone Switzerland: +41 76 5680 231

Von: lu...@googlegroups.com <javascript:> [mailto:lu...@googlegroups.com
<javascript:>] *Im Auftrag von *localtel…@gmail.com <javascript:>
Gesendet: Montag, 23. März 2015 23:19
An: lu...@googlegroups.com <javascript:>
Betreff: [Lucee] Re: Array to list function - works in ACF not in Lucee

Got it.

Lucee, and Railo didn’t like

So using this instead…

Lucee is happy now!

Thanks for the help folks!

On Monday, March 23, 2015 at 2:02:15 PM UTC-7, Chip Pinkston wrote:

I meant dump that function call:

Under ACF you’ll see a bunch of methods there - including getColumnLabels.
I’m just trying this on a quick temp query locally and Lucee is throwing
an error of ‘method is not implemented’.

<cfset qry = QueryNew(‘testing’)>

Here are some notes about how getMetaData was different under Railo from
ACF - this looks like it’s your issue:

https://issues.jboss.org/browse/RAILO-1283

On Monday, March 23, 2015 at 4:35:44 PM UTC-4, localtel...@gmail.com wrote:

Sorry, this let me more confused than I was… How would I check to see
if this is available? This is my first venture into Lucee so admittedly a
novice here.

Thank you

On Monday, March 23, 2015 at 1:09:55 PM UTC-7, Chip Pinkston wrote:

You may want to check that getColumnLabels() is available in
getMetadata(). I’ve run into issues that worked under ACF the failed under
Railo calling getMetadata() functions.

But ArrayToList should be working just fine if you’re getting an array
back. :wink:

Chip.

On Monday, March 23, 2015 at 4:02:21 PM UTC-4, localtel...@gmail.com wrote:

Hello all,

I have a file that uses this function…

67:

And it’s getting this error

Lucee 4.5.1.000 Error (java.sql.SQLException)

Message

method is not implemented

Cause

java.sql.SQLException

This works fine is Adobe ColdFusion but not in Lucee - any suggestions on
what might need to be changed? The database is MySQL

Thanks

Larry

–
You received this message because you are subscribed to the Google Groups
“Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to lucee+un...@googlegroups.com <javascript:>.
To post to this group, send email to lu...@googlegroups.com <javascript:>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/4d186620-18c0-4981-9e9a-a15a20d0f009%40googlegroups.com
https://groups.google.com/d/msgid/lucee/4d186620-18c0-4981-9e9a-a15a20d0f009%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.