Can I access databases from Lasso Command Line?

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Can I access databases from Lasso Command Line?

Carl Ketterling
I have a small bit of code I'm trying to use to get Lasso v9 running on Mac OS X Server v10.7 to access my FileMaker Server v11.  This is what I found on the Lasso web site that looks like it should work:

<?LassoScript
        inline(
                -host=Array(
                -datasource='filemakerds',
                -name='localhost',
                -port='80',
                -username='username',
                -password='password' ),
                -database='database', -table='table', -findall ) => {^
                found_count;
        ^} // Close inline
?>

When I load the file from the web server, it returns the number of records in that database.  When I load it using the lasso9 command, it looks like this:

> lasso9 commandlinetest.lasso
> A Failure
> Error Code: 14
> Error Msg: unable to open database file
> Error Stack:
>
> 39:46 sqlite.lasso
> 46:14 sqlite.lasso
> 117:10 database.lasso
> 144:17 inline.lasso
> 134:5 inline.lasso
> 90:17 inline.lasso
> 4:1 commandlinetest.lasso
> 73:12 lasso9.lasso
> 68:3 lasso9.lasso
> 66:3 lasso9.lasso
> 60:3 lasso9.lasso
> 58:15 lasso9.lasso
> 46:3 lasso9.lasso
> 19:8 lasso9.lasso
> 182:2 error.lasso
> 182:2 error.lasso
> 176:2 error.lasso
> 175:2 error.lasso
> 45:2 lasso9.lasso
> 14:25 lasso9.lasso


Any ideas if this should work?  If so, any ideas what I might be doing wrong?

Carl

#############################################################

Attend the Lasso Developer Conference 2013!
Sept 12-14, 2013 in Niagara Falls, Canada
http://www.lassosoft.com/LDC-niagara-falls-2013

#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Can I access databases from Lasso Command Line?

stevepiercy
See:
http://lasso.2283332.n4.nabble.com/Lasso-9-on-command-line-syntax-tt4637586.html#a4637597

    The lasso9 tool by default does not start up any of the "heavy" systems
    but you can initialize the database/inline functionality by calling
    'database_initialize' at the top of your code.

--steve


On 8/21/13 at 8:56 PM, [hidden email] (Carl Ketterling) pronounced:

> I have a small bit of code I'm trying to use to get Lasso v9 running on Mac OS X
> Server v10.7 to access my FileMaker Server v11.  This is what I found on the Lasso
> web site that looks like it should work:
>
> <?LassoScript
>   inline(
>       -host=Array(
>       -datasource='filemakerds',
>       -name='localhost',
>       -port='80',
>       -username='username',
>       -password='password' ),
>       -database='database', -table='table', -findall ) => {^
>       found_count;
>   ^} // Close inline
> ?>
>
> When I load the file from the web server, it returns the number of records in that
> database.  When I load it using the lasso9 command, it looks like this:
>
> > lasso9 commandlinetest.lasso
> > A Failure
> > Error Code: 14
> > Error Msg: unable to open database file
> > Error Stack:
> >
> > 39:46 sqlite.lasso
> > 46:14 sqlite.lasso
> > 117:10 database.lasso
> > 144:17 inline.lasso
> > 134:5 inline.lasso
> > 90:17 inline.lasso
> > 4:1 commandlinetest.lasso
> > 73:12 lasso9.lasso
> > 68:3 lasso9.lasso
> > 66:3 lasso9.lasso
> > 60:3 lasso9.lasso
> > 58:15 lasso9.lasso
> > 46:3 lasso9.lasso
> > 19:8 lasso9.lasso
> > 182:2 error.lasso
> > 182:2 error.lasso
> > 176:2 error.lasso
> > 175:2 error.lasso
> > 45:2 lasso9.lasso
> > 14:25 lasso9.lasso
>
>
> Any ideas if this should work?  If so, any ideas what I might be doing wrong?
>
> Carl
>
> #############################################################
>
> Attend the Lasso Developer Conference 2013!
> Sept 12-14, 2013 in Niagara Falls, Canada
> http://www.lassosoft.com/LDC-niagara-falls-2013
>
> #############################################################
> This message is sent to you because you are subscribed to
>   the mailing list Lasso
> [hidden email]
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Steve Piercy               Web Site Builder               Soquel, CA
<[hidden email]>                  <http://www.StevePiercy.com/>


#############################################################

Attend the Lasso Developer Conference 2013!
Sept 12-14, 2013 in Niagara Falls, Canada
http://www.lassosoft.com/LDC-niagara-falls-2013

#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>