Re: Selecting the Nth Record in Derby

[GArlington <garlington@xxxxxxxxxxxxx>]

On Feb 25, 2:58 am, "Jesdisciple" <webforumsu...@xxxxxxxxxxxxxx>
wrote:
> Derby rejects the attached code, saying that it "Encountered '1' at line 1,
> column 12".  I haven't renamed my index (and I don't really want to mess with
> it at this level, as I consider it a more advanced concept), so what is the
> default prefix for the number (or am I thinking about indexes in a completely
> wrong way)?

I think you ARE (completely wrong about the index).
What do YOU think it is, and what are you trying to do?

>  Thanks!
>
>  <CFQUERY NAME="remove" DATASOURCE="Example">
>      DROP INDEX #URL.remove#
>  </CFQUERY>