JEQL on Mac OS X

[gene]

I managed to make psql run on Mac OS X

in the shell
$ export JEQL_HOME=/.../jeql-0.10/
$ export LIB=$JEQL_HOME/lib
$ CLASSPATH=$(JARS=("$LIB"/*.jar); IFS=:; echo "${JARS[*]}")

and apparently this works
$ java -cp $CLASSPATH jeql.JeqlCmd -man

========== Functions ==========

double CRS.DMStoDD( String )
Geometry CRS.inverseProject( Geometry, String )
String CRS.proj4Description( String )
Geometry CRS.project( Geometry, String )
String CRS.projectionName( String )
Geometry CRS.transform( Geometry, String, String )
[....]

I created a bash script named jegl
$ ./jeql -help
**** No script specified ****
Jeql 0.10 ---- (c) 2007-2011 Martin Davis ---- Java 1.6.0_24
jeql [ options ] [ <scriptname> <script_arg> ...]

Options:
-help - prints this message
-man - prints a listing of functions and commands
-mon - display monitor during script execution
-stdin - reads script from standard input
-script <text> - reads script from argument
-verbose - runs in verbose mode

but when I try to run the example of "Convert CSV file of point
locations to KML" i get this error

$ java -cp $CLASSPATH jeql.JeqlCmd donuts.jql
(donuts.jql:18) Variable col0 is not defined

[Martin Davis]

Yes, the scripts in the website documentation are a tiny bit out of date.   To fix the donut.jql script, replace the statement at line 19 with

tData = select
    Val.toDouble(col1) as lat,
    Val.toDouble(col2) as lon,
    col3 as name,
    col4 as address,
    col5 as city,
    col6 as provState,
    col7 as postalZip,
    col8 as country,
    col9 as phone
    from tCSVData;


I'll work on updating the example scripts.

Martin

--
You received this message because you are subscribed to the Google Groups "JEQL Users" group.
To post to this group, send email to jeql-...@googlegroups.com.
To unsubscribe from this group, send email to jeql-users+...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/jeql-users?hl=en.