ds Add Row, Get Key Value

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

ds Add Row, Get Key Value

Justin Dennis-3
Hi all -

Another ds question: what is the most efficient way to insert a row and
immediately get its auto-increment primary key value?

I was doing this:

#classScheduleID = #ds->addrow('modified' = date)->keyvalue

But now addrow is returning a null. (I believe I did recently update ds, so
maybe that's why it worked before.)

What's the "correct" approach to quickly inserting a row and getting its
key value?

Thanks.

- Justin

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

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: ds Add Row, Get Key Value

decorior
We do this

> #classSchedule = #ds->addrow('modified' = date)


id is #classSchedule->find(`id`)



> On Jul 7, 2015, at 11:40 AM, Justin Dennis <[hidden email]> wrote:
>
> Hi all -
>
> Another ds question: what is the most efficient way to insert a row and
> immediately get its auto-increment primary key value?
>
> I was doing this:
>
> #classScheduleID = #ds->addrow('modified' = date)->keyvalue
>
> But now addrow is returning a null. (I believe I did recently update ds, so
> maybe that's why it worked before.)
>
> What's the "correct" approach to quickly inserting a row and getting its
> key value?
>
> Thanks.
>
> - Justin
>
> #############################################################
>
> This message is sent to you because you are subscribed to
>  the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>


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

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: ds Add Row, Get Key Value

stevepiercy
In reply to this post by Justin Dennis-3
Your version works for me, but my ds is fairly old (https://github.com/zeroloop/ds/commit/ea9db5df13f3b12db217e084067876b6e4ff8137).

So I updated to the latest.  It still works.  So check your assumptions.

Is the record added?

Did you change something in the ds connection?  Or if you were
relying on Lasso's Admin for registering datasources, and you
were using that in ds, did you change the connection or tables
in Lasso Admin?

What is the #ds keycolumn, if not the default of id?  If you
changed the keycolumn to something that IS NULL, then a null
might be returned.

--steve


On 7/7/15 at 1:40 PM, [hidden email] (Justin Dennis) pronounced:

>Hi all -
>
>Another ds question: what is the most efficient way to insert a row and
>immediately get its auto-increment primary key value?
>
>I was doing this:
>
>#classScheduleID = #ds->addrow('modified' = date)->keyvalue
>
>But now addrow is returning a null. (I believe I did recently update ds, so
>maybe that's why it worked before.)
>
>What's the "correct" approach to quickly inserting a row and getting its
>key value?
>
>Thanks.
>
>- Justin
>
>#############################################################
>
>This message is sent to you because you are subscribed to
>the mailing list Lasso [hidden email]
>Official list archives available at http://www.lassotalk.com
>To unsubscribe, E-mail to: <[hidden email]>
>Send administrative queries to  <[hidden email]>

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


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

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: ds Add Row, Get Key Value

Justin Dennis-3
Thanks for both of your responses. The ->get / ->find method doesn't work
either because it thinks it's a null.

Is the record added?
>

Yes, record is added with the values expected.


> Did you change something in the ds connection?  Or if you were relying on
> Lasso's Admin for registering datasources, and you were using that in ds,
> did you change the connection or tables in Lasso Admin?
>

Nothing changed here, and the record is added, so this seems to not be the
issue.

What is the #ds keycolumn, if not the default of id?  If you changed the
> keycolumn to something that IS NULL, then a null might be returned.


It's the default of 'id'.

I've simplified the code to consist of purely the following:

local(classSchedule, ds = ds(::atp.classschedule))
#classSchedule = #ds->addrow('modified' = date)
#classSchedule->type

Which returns "null", but the record is still added...

- Justin

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

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: ds Add Row, Get Key Value

Justin Dennis-3
I was in fact not on the latest ds. A git pull, followed by instance
restart has me getting the following error:

near "table": syntax error (Error Code 1)

This error occurs for the previous code sample, and for many, many other
pages and methods throughout the instance. I think I will revert to an
older version... unless this is a sign of a sqlite issue?

- Justin

On Tue, Jul 7, 2015 at 3:10 PM, Justin Dennis <[hidden email]> wrote:

> Thanks for both of your responses. The ->get / ->find method doesn't work
> either because it thinks it's a null.
>
> Is the record added?
>>
>
> Yes, record is added with the values expected.
>
>
>> Did you change something in the ds connection?  Or if you were relying on
>> Lasso's Admin for registering datasources, and you were using that in ds,
>> did you change the connection or tables in Lasso Admin?
>>
>
> Nothing changed here, and the record is added, so this seems to not be the
> issue.
>
> What is the #ds keycolumn, if not the default of id?  If you changed the
>> keycolumn to something that IS NULL, then a null might be returned.
>
>
> It's the default of 'id'.
>
> I've simplified the code to consist of purely the following:
>
> local(classSchedule, ds = ds(::atp.classschedule))
> #classSchedule = #ds->addrow('modified' = date)
> #classSchedule->type
>
> Which returns "null", but the record is still added...
>
> - Justin
>

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

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: ds Add Row, Get Key Value

Steffan A. Cline
What version of Lasso are you using? I know that the latest pull is
designed specifically to address some issues with 9.3. I would have
thought it was reverse compatible.

Perhaps Ke can chime in soon on this.

Thanks,
Steffan

On , Justin Dennis wrote:

> I was in fact not on the latest ds. A git pull, followed by instance
> restart has me getting the following error:
>
> near "table": syntax error (Error Code 1)
>
> This error occurs for the previous code sample, and for many, many
> other
> pages and methods throughout the instance. I think I will revert to an
> older version... unless this is a sign of a sqlite issue?
>
> - Justin
>
> On Tue, Jul 7, 2015 at 3:10 PM, Justin Dennis <[hidden email]>
> wrote:
>
>> Thanks for both of your responses. The ->get / ->find method doesn't
>> work
>> either because it thinks it's a null.
>>
>> Is the record added?
>>>
>>
>> Yes, record is added with the values expected.
>>
>>
>>> Did you change something in the ds connection?  Or if you were
>>> relying on
>>> Lasso's Admin for registering datasources, and you were using that in
>>> ds,
>>> did you change the connection or tables in Lasso Admin?
>>>
>>
>> Nothing changed here, and the record is added, so this seems to not be
>> the
>> issue.
>>
>> What is the #ds keycolumn, if not the default of id?  If you changed
>> the
>>> keycolumn to something that IS NULL, then a null might be returned.
>>
>>
>> It's the default of 'id'.
>>
>> I've simplified the code to consist of purely the following:
>>
>> local(classSchedule, ds = ds(::atp.classschedule))
>> #classSchedule = #ds->addrow('modified' = date)
>> #classSchedule->type
>>
>> Which returns "null", but the record is still added...
>>
>> - Justin
>>
>
> #############################################################
>
> This message is sent to you because you are subscribed to
>   the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>

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

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: ds Add Row, Get Key Value

Justin Dennis-3
This is 9.2.7. I see now in the git log that some of the recent work was
related to 9.3. -Justin

On Tue, Jul 7, 2015 at 3:22 PM, Steffan A. Cline <[hidden email]> wrote:

> What version of Lasso are you using? I know that the latest pull is
> designed specifically to address some issues with 9.3. I would have thought
> it was reverse compatible.
>
> Perhaps Ke can chime in soon on this.
>
> Thanks,
> Steffan
>
>
> On , Justin Dennis wrote:
>
>> I was in fact not on the latest ds. A git pull, followed by instance
>> restart has me getting the following error:
>>
>> near "table": syntax error (Error Code 1)
>>
>> This error occurs for the previous code sample, and for many, many other
>> pages and methods throughout the instance. I think I will revert to an
>> older version... unless this is a sign of a sqlite issue?
>>
>> - Justin
>>
>> On Tue, Jul 7, 2015 at 3:10 PM, Justin Dennis <[hidden email]> wrote:
>>
>>  Thanks for both of your responses. The ->get / ->find method doesn't work
>>> either because it thinks it's a null.
>>>
>>> Is the record added?
>>>
>>>>
>>>>
>>> Yes, record is added with the values expected.
>>>
>>>
>>>  Did you change something in the ds connection?  Or if you were relying
>>>> on
>>>> Lasso's Admin for registering datasources, and you were using that in
>>>> ds,
>>>> did you change the connection or tables in Lasso Admin?
>>>>
>>>>
>>> Nothing changed here, and the record is added, so this seems to not be
>>> the
>>> issue.
>>>
>>> What is the #ds keycolumn, if not the default of id?  If you changed the
>>>
>>>> keycolumn to something that IS NULL, then a null might be returned.
>>>>
>>>
>>>
>>> It's the default of 'id'.
>>>
>>> I've simplified the code to consist of purely the following:
>>>
>>> local(classSchedule, ds = ds(::atp.classschedule))
>>> #classSchedule = #ds->addrow('modified' = date)
>>> #classSchedule->type
>>>
>>> Which returns "null", but the record is still added...
>>>
>>> - Justin
>>>
>>>
>> #############################################################
>>
>> This message is sent to you because you are subscribed to
>>   the mailing list Lasso [hidden email]
>> Official list archives available at http://www.lassotalk.com
>> To unsubscribe, E-mail to: <[hidden email]>
>> Send administrative queries to  <[hidden email]>
>>
>
> #############################################################
>
> This message is sent to you because you are subscribed to
>  the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>
>

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

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: ds Add Row, Get Key Value

Justin Dennis-3
On 9.2.7, all my problems go away with ds commit
831ba0deb600d4c447fe524f978ba0decbba56d6.

My original code works fine, and no more errors. FWIW. Sorry to drag
everyone through my troubleshooting. :-)

- Justin

On Tue, Jul 7, 2015 at 3:23 PM, Justin Dennis <[hidden email]> wrote:

> This is 9.2.7. I see now in the git log that some of the recent work was
> related to 9.3. -Justin
>
> On Tue, Jul 7, 2015 at 3:22 PM, Steffan A. Cline <[hidden email]>
> wrote:
>
>> What version of Lasso are you using? I know that the latest pull is
>> designed specifically to address some issues with 9.3. I would have thought
>> it was reverse compatible.
>>
>> Perhaps Ke can chime in soon on this.
>>
>> Thanks,
>> Steffan
>>
>>
>> On , Justin Dennis wrote:
>>
>>> I was in fact not on the latest ds. A git pull, followed by instance
>>> restart has me getting the following error:
>>>
>>> near "table": syntax error (Error Code 1)
>>>
>>> This error occurs for the previous code sample, and for many, many other
>>> pages and methods throughout the instance. I think I will revert to an
>>> older version... unless this is a sign of a sqlite issue?
>>>
>>> - Justin
>>>
>>> On Tue, Jul 7, 2015 at 3:10 PM, Justin Dennis <[hidden email]> wrote:
>>>
>>>  Thanks for both of your responses. The ->get / ->find method doesn't
>>>> work
>>>> either because it thinks it's a null.
>>>>
>>>> Is the record added?
>>>>
>>>>>
>>>>>
>>>> Yes, record is added with the values expected.
>>>>
>>>>
>>>>  Did you change something in the ds connection?  Or if you were relying
>>>>> on
>>>>> Lasso's Admin for registering datasources, and you were using that in
>>>>> ds,
>>>>> did you change the connection or tables in Lasso Admin?
>>>>>
>>>>>
>>>> Nothing changed here, and the record is added, so this seems to not be
>>>> the
>>>> issue.
>>>>
>>>> What is the #ds keycolumn, if not the default of id?  If you changed the
>>>>
>>>>> keycolumn to something that IS NULL, then a null might be returned.
>>>>>
>>>>
>>>>
>>>> It's the default of 'id'.
>>>>
>>>> I've simplified the code to consist of purely the following:
>>>>
>>>> local(classSchedule, ds = ds(::atp.classschedule))
>>>> #classSchedule = #ds->addrow('modified' = date)
>>>> #classSchedule->type
>>>>
>>>> Which returns "null", but the record is still added...
>>>>
>>>> - Justin
>>>>
>>>>
>>> #############################################################
>>>
>>> This message is sent to you because you are subscribed to
>>>   the mailing list Lasso [hidden email]
>>> Official list archives available at http://www.lassotalk.com
>>> To unsubscribe, E-mail to: <[hidden email]>
>>> Send administrative queries to  <[hidden email]>
>>>
>>
>> #############################################################
>>
>> This message is sent to you because you are subscribed to
>>  the mailing list Lasso [hidden email]
>> Official list archives available at http://www.lassotalk.com
>> To unsubscribe, E-mail to: <[hidden email]>
>> Send administrative queries to  <[hidden email]>
>>
>
>

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

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: ds Add Row, Get Key Value

stevepiercy
I'm on 9.2.7, too, and the latest commit works for me.  Maybe
the cause is how you define your ds?

Here's how I did mine, which bypasses Lasso Admin for speed in
preference to code brevity.

     local(ds) = ds(::mysqlds, 'localhost', ::db.table,
'moose_user', 'pass_hair')

Compared to yours.

     local(ds) = ds(::atp.classschedule)

I'm curious, if you change your ds connection to be like mine,
what would happen?

I can verify that when I change my connection to be like yours,
I get the error you reported.

     local(ds) = ds(::db.table)

An unhandled failure during a web request
Error Code: 1
Error Msg: near "table": syntax error
Error Stack:
217:26 sqlite.lasso
269:19 //var/lasso/instances/default//LassoApps/ds/ds.lasso
241:18 //var/lasso/instances/default//LassoApps/ds/ds.lasso
235:3 //var/lasso/instances/default//LassoApps/ds/ds.lasso
233:4 //var/lasso/instances/default//LassoApps/ds/ds.lasso
105:4 //var/lasso/instances/default//LassoApps/ds/ds.lasso
2:13 //Users/stevepiercy/projects/project/webroot//dbcnxn.lasso

Maybe git blame can reveal where something went sideways?
https://github.com/zeroloop/ds/blame/master/ds.lasso

--steve


On 7/7/15 at 3:25 PM, [hidden email] (Justin Dennis) pronounced:

>On 9.2.7, all my problems go away with ds commit
>831ba0deb600d4c447fe524f978ba0decbba56d6.
>
>My original code works fine, and no more errors. FWIW. Sorry to drag
>everyone through my troubleshooting. :-)
>
>- Justin
>
>On Tue, Jul 7, 2015 at 3:23 PM, Justin Dennis <[hidden email]> wrote:
>
>>This is 9.2.7. I see now in the git log that some of the recent work was
>>related to 9.3. -Justin
>>
>>On Tue, Jul 7, 2015 at 3:22 PM, Steffan A. Cline <[hidden email]>
>>wrote:
>>
>>> What version of Lasso are you using? I know that the latest pull is
>>> designed specifically to address some issues with 9.3. I would have thought
>>> it was reverse compatible.
>>>
>>> Perhaps Ke can chime in soon on this.
>>>
>>> Thanks,
>>> Steffan
>>>
>>>
>>> On , Justin Dennis wrote:
>>>
>>>> I was in fact not on the latest ds. A git pull, followed by instance
>>>> restart has me getting the following error:
>>>>
>>>> near "table": syntax error (Error Code 1)
>>>>
>>>> This error occurs for the previous code sample, and for many, many other
>>>> pages and methods throughout the instance. I think I will revert to an
>>>> older version... unless this is a sign of a sqlite issue?
>>>>
>>>> - Justin
>>>>
>>>> On Tue, Jul 7, 2015 at 3:10 PM, Justin Dennis <[hidden email]> wrote:
>>>>
>>>>  Thanks for both of your responses. The ->get / ->find method doesn't
>>>>> work
>>>>> either because it thinks it's a null.
>>>>>
>>>>> Is the record added?
>>>>>
>>>>>>
>>>>>>
>>>>> Yes, record is added with the values expected.
>>>>>
>>>>>
>>>>>  Did you change something in the ds connection?  Or if you were relying
>>>>>> on
>>>>>> Lasso's Admin for registering datasources, and you were using that in
>>>>>> ds,
>>>>>> did you change the connection or tables in Lasso Admin?
>>>>>>
>>>>>>
>>>>> Nothing changed here, and the record is added, so this seems to not be
>>>>> the
>>>>> issue.
>>>>>
>>>>> What is the #ds keycolumn, if not the default of id?  If you changed the
>>>>>
>>>>>> keycolumn to something that IS NULL, then a null might be returned.
>>>>>>
>>>>>
>>>>>
>>>>> It's the default of 'id'.
>>>>>
>>>>> I've simplified the code to consist of purely the following:
>>>>>
>>>>> local(classSchedule, ds = ds(::atp.classschedule))
>>>>> #classSchedule = #ds->addrow('modified' = date)
>>>>> #classSchedule->type
>>>>>
>>>>> Which returns "null", but the record is still added...
>>>>>
>>>>> - Justin
>>>>>
>>>>>
>>>> #############################################################
>>>>
>>>> This message is sent to you because you are subscribed to
>>>>   the mailing list Lasso [hidden email]
>>>> Official list archives available at http://www.lassotalk.com
>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>> Send administrative queries to  <[hidden email]>
>>>>
>>>
>>> #############################################################
>>>
>>> This message is sent to you because you are subscribed to
>>>  the mailing list Lasso [hidden email]
>>> Official list archives available at http://www.lassotalk.com
>>> To unsubscribe, E-mail to: <[hidden email]>
>>> Send administrative queries to  <[hidden email]>
>>>
>>
>>
>
>#############################################################
>
>This message is sent to you because you are subscribed to
>the mailing list Lasso [hidden email]
>Official list archives available at http://www.lassotalk.com
>To unsubscribe, E-mail to: <[hidden email]>
>Send administrative queries to  <[hidden email]>

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


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

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: ds Add Row, Get Key Value

Ke Carlton-3
In reply to this post by Justin Dennis-3
Hello Justin,

Would be great if you could email me the code snippet + table schema that's
failing. The latest version should be compatible with 9.1 - 9.3 and I run
9.2.7 locally.

Thanks,

Ke

On Wed, Jul 8, 2015 at 7:16 AM Justin Dennis <[hidden email]> wrote:

> I was in fact not on the latest ds. A git pull, followed by instance
> restart has me getting the following error:
>
> near "table": syntax error (Error Code 1)
>
> This error occurs for the previous code sample, and for many, many other
> pages and methods throughout the instance. I think I will revert to an
> older version... unless this is a sign of a sqlite issue?
>
> - Justin
>
> On Tue, Jul 7, 2015 at 3:10 PM, Justin Dennis <[hidden email]> wrote:
>
> > Thanks for both of your responses. The ->get / ->find method doesn't work
> > either because it thinks it's a null.
> >
> > Is the record added?
> >>
> >
> > Yes, record is added with the values expected.
> >
> >
> >> Did you change something in the ds connection?  Or if you were relying
> on
> >> Lasso's Admin for registering datasources, and you were using that in
> ds,
> >> did you change the connection or tables in Lasso Admin?
> >>
> >
> > Nothing changed here, and the record is added, so this seems to not be
> the
> > issue.
> >
> > What is the #ds keycolumn, if not the default of id?  If you changed the
> >> keycolumn to something that IS NULL, then a null might be returned.
> >
> >
> > It's the default of 'id'.
> >
> > I've simplified the code to consist of purely the following:
> >
> > local(classSchedule, ds = ds(::atp.classschedule))
> > #classSchedule = #ds->addrow('modified' = date)
> > #classSchedule->type
> >
> > Which returns "null", but the record is still added...
> >
> > - Justin
> >
>
> #############################################################
>
> This message is sent to you because you are subscribed to
>   the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>
>

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

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: ds Add Row, Get Key Value

Ke Carlton-3
In reply to this post by stevepiercy
OK, I think I know the cause. I merged a pull request recently that was
meant to deal with table aliases — looks like it's screwed other bits...

I've reverted the changes pending further review.

Please try the current version.

Best regards,

Ke

On Wed, Jul 8, 2015 at 9:57 AM Steve Piercy - Website Builder <
[hidden email]> wrote:

> I'm on 9.2.7, too, and the latest commit works for me.  Maybe
> the cause is how you define your ds?
>
> Here's how I did mine, which bypasses Lasso Admin for speed in
> preference to code brevity.
>
>      local(ds) = ds(::mysqlds, 'localhost', ::db.table,
> 'moose_user', 'pass_hair')
>
> Compared to yours.
>
>      local(ds) = ds(::atp.classschedule)
>
> I'm curious, if you change your ds connection to be like mine,
> what would happen?
>
> I can verify that when I change my connection to be like yours,
> I get the error you reported.
>
>      local(ds) = ds(::db.table)
>
> An unhandled failure during a web request
> Error Code: 1
> Error Msg: near "table": syntax error
> Error Stack:
> 217:26 sqlite.lasso
> 269:19 //var/lasso/instances/default//LassoApps/ds/ds.lasso
> 241:18 //var/lasso/instances/default//LassoApps/ds/ds.lasso
> 235:3 //var/lasso/instances/default//LassoApps/ds/ds.lasso
> 233:4 //var/lasso/instances/default//LassoApps/ds/ds.lasso
> 105:4 //var/lasso/instances/default//LassoApps/ds/ds.lasso
> 2:13 //Users/stevepiercy/projects/project/webroot//dbcnxn.lasso
>
> Maybe git blame can reveal where something went sideways?
> https://github.com/zeroloop/ds/blame/master/ds.lasso
>
> --steve
>
>
> On 7/7/15 at 3:25 PM, [hidden email] (Justin Dennis) pronounced:
>
> >On 9.2.7, all my problems go away with ds commit
> >831ba0deb600d4c447fe524f978ba0decbba56d6.
> >
> >My original code works fine, and no more errors. FWIW. Sorry to drag
> >everyone through my troubleshooting. :-)
> >
> >- Justin
> >
> >On Tue, Jul 7, 2015 at 3:23 PM, Justin Dennis <[hidden email]> wrote:
> >
> >>This is 9.2.7. I see now in the git log that some of the recent work was
> >>related to 9.3. -Justin
> >>
> >>On Tue, Jul 7, 2015 at 3:22 PM, Steffan A. Cline <[hidden email]>
> >>wrote:
> >>
> >>> What version of Lasso are you using? I know that the latest pull is
> >>> designed specifically to address some issues with 9.3. I would have
> thought
> >>> it was reverse compatible.
> >>>
> >>> Perhaps Ke can chime in soon on this.
> >>>
> >>> Thanks,
> >>> Steffan
> >>>
> >>>
> >>> On , Justin Dennis wrote:
> >>>
> >>>> I was in fact not on the latest ds. A git pull, followed by instance
> >>>> restart has me getting the following error:
> >>>>
> >>>> near "table": syntax error (Error Code 1)
> >>>>
> >>>> This error occurs for the previous code sample, and for many, many
> other
> >>>> pages and methods throughout the instance. I think I will revert to an
> >>>> older version... unless this is a sign of a sqlite issue?
> >>>>
> >>>> - Justin
> >>>>
> >>>> On Tue, Jul 7, 2015 at 3:10 PM, Justin Dennis <[hidden email]>
> wrote:
> >>>>
> >>>>  Thanks for both of your responses. The ->get / ->find method doesn't
> >>>>> work
> >>>>> either because it thinks it's a null.
> >>>>>
> >>>>> Is the record added?
> >>>>>
> >>>>>>
> >>>>>>
> >>>>> Yes, record is added with the values expected.
> >>>>>
> >>>>>
> >>>>>  Did you change something in the ds connection?  Or if you were
> relying
> >>>>>> on
> >>>>>> Lasso's Admin for registering datasources, and you were using that
> in
> >>>>>> ds,
> >>>>>> did you change the connection or tables in Lasso Admin?
> >>>>>>
> >>>>>>
> >>>>> Nothing changed here, and the record is added, so this seems to not
> be
> >>>>> the
> >>>>> issue.
> >>>>>
> >>>>> What is the #ds keycolumn, if not the default of id?  If you changed
> the
> >>>>>
> >>>>>> keycolumn to something that IS NULL, then a null might be returned.
> >>>>>>
> >>>>>
> >>>>>
> >>>>> It's the default of 'id'.
> >>>>>
> >>>>> I've simplified the code to consist of purely the following:
> >>>>>
> >>>>> local(classSchedule, ds = ds(::atp.classschedule))
> >>>>> #classSchedule = #ds->addrow('modified' = date)
> >>>>> #classSchedule->type
> >>>>>
> >>>>> Which returns "null", but the record is still added...
> >>>>>
> >>>>> - Justin
> >>>>>
> >>>>>
> >>>> #############################################################
> >>>>
> >>>> This message is sent to you because you are subscribed to
> >>>>   the mailing list Lasso [hidden email]
> >>>> Official list archives available at http://www.lassotalk.com
> >>>> To unsubscribe, E-mail to: <[hidden email]>
> >>>> Send administrative queries to  <[hidden email]>
> >>>>
> >>>
> >>> #############################################################
> >>>
> >>> This message is sent to you because you are subscribed to
> >>>  the mailing list Lasso [hidden email]
> >>> Official list archives available at http://www.lassotalk.com
> >>> To unsubscribe, E-mail to: <[hidden email]>
> >>> Send administrative queries to  <[hidden email]>
> >>>
> >>
> >>
> >
> >#############################################################
> >
> >This message is sent to you because you are subscribed to
> >the mailing list Lasso [hidden email]
> >Official list archives available at http://www.lassotalk.com
> >To unsubscribe, E-mail to: <[hidden email]>
> >Send administrative queries to  <[hidden email]>
>
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> Steve Piercy              Website Builder              Soquel, CA
> <[hidden email]>               <http://www.StevePiercy.com/>
>
>
> #############################################################
>
> This message is sent to you because you are subscribed to
>   the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>
>

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

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: ds Add Row, Get Key Value

stevepiercy
I confirm the latest version no longer raises an error for either connection method.

     local(ds) = ds(::mysqlds, 'localhost', ::db.table, 'moose_user', 'pass_hair')
     local(ds) = ds(::db.table)

Sidebar: Do you have a test suite for ds?

--steve


On 7/7/15 at 10:07 PM, [hidden email] (Ke Carlton) pronounced:

> OK, I think I know the cause. I merged a pull request recently that was
> meant to deal with table aliases — looks like it's screwed other bits...
>
> I've reverted the changes pending further review.
>
> Please try the current version.
>
> Best regards,
>
> Ke
>
> On Wed, Jul 8, 2015 at 9:57 AM Steve Piercy - Website Builder <
> [hidden email]> wrote:
>
> > I'm on 9.2.7, too, and the latest commit works for me.  Maybe
> > the cause is how you define your ds?
> >
> > Here's how I did mine, which bypasses Lasso Admin for speed in
> > preference to code brevity.
> >
> >      local(ds) = ds(::mysqlds, 'localhost', ::db.table,
> > 'moose_user', 'pass_hair')
> >
> > Compared to yours.
> >
> >      local(ds) = ds(::atp.classschedule)
> >
> > I'm curious, if you change your ds connection to be like mine,
> > what would happen?
> >
> > I can verify that when I change my connection to be like yours,
> > I get the error you reported.
> >
> >      local(ds) = ds(::db.table)
> >
> > An unhandled failure during a web request
> > Error Code: 1
> > Error Msg: near "table": syntax error
> > Error Stack:
> > 217:26 sqlite.lasso
> > 269:19 //var/lasso/instances/default//LassoApps/ds/ds.lasso
> > 241:18 //var/lasso/instances/default//LassoApps/ds/ds.lasso
> > 235:3 //var/lasso/instances/default//LassoApps/ds/ds.lasso
> > 233:4 //var/lasso/instances/default//LassoApps/ds/ds.lasso
> > 105:4 //var/lasso/instances/default//LassoApps/ds/ds.lasso
> > 2:13 //Users/stevepiercy/projects/project/webroot//dbcnxn.lasso
> >
> > Maybe git blame can reveal where something went sideways?
> > https://github.com/zeroloop/ds/blame/master/ds.lasso
> >
> > --steve
> >
> >
> > On 7/7/15 at 3:25 PM, [hidden email] (Justin Dennis) pronounced:
> >
> > >On 9.2.7, all my problems go away with ds commit
> > >831ba0deb600d4c447fe524f978ba0decbba56d6.
> > >
> > >My original code works fine, and no more errors. FWIW. Sorry to drag
> > >everyone through my troubleshooting. :-)
> > >
> > >- Justin
> > >
> > >On Tue, Jul 7, 2015 at 3:23 PM, Justin Dennis <[hidden email]> wrote:
> > >
> > >>This is 9.2.7. I see now in the git log that some of the recent work was
> > >>related to 9.3. -Justin
> > >>
> > >>On Tue, Jul 7, 2015 at 3:22 PM, Steffan A. Cline <[hidden email]>
> > >>wrote:
> > >>
> > >>> What version of Lasso are you using? I know that the latest pull is
> > >>> designed specifically to address some issues with 9.3. I would have
> > thought
> > >>> it was reverse compatible.
> > >>>
> > >>> Perhaps Ke can chime in soon on this.
> > >>>
> > >>> Thanks,
> > >>> Steffan
> > >>>
> > >>>
> > >>> On , Justin Dennis wrote:
> > >>>
> > >>>> I was in fact not on the latest ds. A git pull, followed by instance
> > >>>> restart has me getting the following error:
> > >>>>
> > >>>> near "table": syntax error (Error Code 1)
> > >>>>
> > >>>> This error occurs for the previous code sample, and for many, many
> > other
> > >>>> pages and methods throughout the instance. I think I will revert to an
> > >>>> older version... unless this is a sign of a sqlite issue?
> > >>>>
> > >>>> - Justin
> > >>>>
> > >>>> On Tue, Jul 7, 2015 at 3:10 PM, Justin Dennis <[hidden email]>
> > wrote:
> > >>>>
> > >>>>  Thanks for both of your responses. The ->get / ->find method doesn't
> > >>>>> work
> > >>>>> either because it thinks it's a null.
> > >>>>>
> > >>>>> Is the record added?
> > >>>>>
> > >>>>>>
> > >>>>>>
> > >>>>> Yes, record is added with the values expected.
> > >>>>>
> > >>>>>
> > >>>>>  Did you change something in the ds connection?  Or if you were
> > relying
> > >>>>>> on
> > >>>>>> Lasso's Admin for registering datasources, and you were using that
> > in
> > >>>>>> ds,
> > >>>>>> did you change the connection or tables in Lasso Admin?
> > >>>>>>
> > >>>>>>
> > >>>>> Nothing changed here, and the record is added, so this seems to not
> > be
> > >>>>> the
> > >>>>> issue.
> > >>>>>
> > >>>>> What is the #ds keycolumn, if not the default of id?  If you changed
> > the
> > >>>>>
> > >>>>>> keycolumn to something that IS NULL, then a null might be returned.
> > >>>>>>
> > >>>>>
> > >>>>>
> > >>>>> It's the default of 'id'.
> > >>>>>
> > >>>>> I've simplified the code to consist of purely the following:
> > >>>>>
> > >>>>> local(classSchedule, ds = ds(::atp.classschedule))
> > >>>>> #classSchedule = #ds->addrow('modified' = date)
> > >>>>> #classSchedule->type
> > >>>>>
> > >>>>> Which returns "null", but the record is still added...
> > >>>>>
> > >>>>> - Justin
> > >>>>>
> > >>>>>
> > >>>> #############################################################
> > >>>>
> > >>>> This message is sent to you because you are subscribed to
> > >>>>   the mailing list Lasso [hidden email]
> > >>>> Official list archives available at http://www.lassotalk.com
> > >>>> To unsubscribe, E-mail to: <[hidden email]>
> > >>>> Send administrative queries to  <[hidden email]>
> > >>>>
> > >>>
> > >>> #############################################################
> > >>>
> > >>> This message is sent to you because you are subscribed to
> > >>>  the mailing list Lasso [hidden email]
> > >>> Official list archives available at http://www.lassotalk.com
> > >>> To unsubscribe, E-mail to: <[hidden email]>
> > >>> Send administrative queries to  <[hidden email]>
> > >>>
> > >>
> > >>
> > >
> > >#############################################################
> > >
> > >This message is sent to you because you are subscribed to
> > >the mailing list Lasso [hidden email]
> > >Official list archives available at http://www.lassotalk.com
> > >To unsubscribe, E-mail to: <[hidden email]>
> > >Send administrative queries to  <[hidden email]>
> >
> > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> > Steve Piercy              Website Builder              Soquel, CA
> > <[hidden email]>               <http://www.StevePiercy.com/>
> >
> >
> > #############################################################
> >
> > This message is sent to you because you are subscribed to
> >   the mailing list Lasso [hidden email]
> > Official list archives available at http://www.lassotalk.com
> > To unsubscribe, E-mail to: <[hidden email]>
> > Send administrative queries to  <[hidden email]>
> >
>
> #############################################################
>
> This message is sent to you because you are subscribed to
>   the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>

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


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

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: ds Add Row, Get Key Value

Ke Carlton-3
Yes, albeit a fairly small one.

Just got a little sloppy reviewing the pull request in this instance.

Ke



On Wed, Jul 8, 2015 at 10:26 AM Steve Piercy - Website Builder <
[hidden email]> wrote:

> I confirm the latest version no longer raises an error for either
> connection method.
>
>      local(ds) = ds(::mysqlds, 'localhost', ::db.table, 'moose_user',
> 'pass_hair')
>      local(ds) = ds(::db.table)
>
> Sidebar: Do you have a test suite for ds?
>
> --steve
>
>
> On 7/7/15 at 10:07 PM, [hidden email] (Ke Carlton) pronounced:
>
> > OK, I think I know the cause. I merged a pull request recently that was
> > meant to deal with table aliases — looks like it's screwed other bits...
> >
> > I've reverted the changes pending further review.
> >
> > Please try the current version.
> >
> > Best regards,
> >
> > Ke
> >
> > On Wed, Jul 8, 2015 at 9:57 AM Steve Piercy - Website Builder <
> > [hidden email]> wrote:
> >
> > > I'm on 9.2.7, too, and the latest commit works for me.  Maybe
> > > the cause is how you define your ds?
> > >
> > > Here's how I did mine, which bypasses Lasso Admin for speed in
> > > preference to code brevity.
> > >
> > >      local(ds) = ds(::mysqlds, 'localhost', ::db.table,
> > > 'moose_user', 'pass_hair')
> > >
> > > Compared to yours.
> > >
> > >      local(ds) = ds(::atp.classschedule)
> > >
> > > I'm curious, if you change your ds connection to be like mine,
> > > what would happen?
> > >
> > > I can verify that when I change my connection to be like yours,
> > > I get the error you reported.
> > >
> > >      local(ds) = ds(::db.table)
> > >
> > > An unhandled failure during a web request
> > > Error Code: 1
> > > Error Msg: near "table": syntax error
> > > Error Stack:
> > > 217:26 sqlite.lasso
> > > 269:19 //var/lasso/instances/default//LassoApps/ds/ds.lasso
> > > 241:18 //var/lasso/instances/default//LassoApps/ds/ds.lasso
> > > 235:3 //var/lasso/instances/default//LassoApps/ds/ds.lasso
> > > 233:4 //var/lasso/instances/default//LassoApps/ds/ds.lasso
> > > 105:4 //var/lasso/instances/default//LassoApps/ds/ds.lasso
> > > 2:13 //Users/stevepiercy/projects/project/webroot//dbcnxn.lasso
> > >
> > > Maybe git blame can reveal where something went sideways?
> > > https://github.com/zeroloop/ds/blame/master/ds.lasso
> > >
> > > --steve
> > >
> > >
> > > On 7/7/15 at 3:25 PM, [hidden email] (Justin Dennis) pronounced:
> > >
> > > >On 9.2.7, all my problems go away with ds commit
> > > >831ba0deb600d4c447fe524f978ba0decbba56d6.
> > > >
> > > >My original code works fine, and no more errors. FWIW. Sorry to drag
> > > >everyone through my troubleshooting. :-)
> > > >
> > > >- Justin
> > > >
> > > >On Tue, Jul 7, 2015 at 3:23 PM, Justin Dennis <[hidden email]>
> wrote:
> > > >
> > > >>This is 9.2.7. I see now in the git log that some of the recent work
> was
> > > >>related to 9.3. -Justin
> > > >>
> > > >>On Tue, Jul 7, 2015 at 3:22 PM, Steffan A. Cline <[hidden email]>
> > > >>wrote:
> > > >>
> > > >>> What version of Lasso are you using? I know that the latest pull is
> > > >>> designed specifically to address some issues with 9.3. I would have
> > > thought
> > > >>> it was reverse compatible.
> > > >>>
> > > >>> Perhaps Ke can chime in soon on this.
> > > >>>
> > > >>> Thanks,
> > > >>> Steffan
> > > >>>
> > > >>>
> > > >>> On , Justin Dennis wrote:
> > > >>>
> > > >>>> I was in fact not on the latest ds. A git pull, followed by
> instance
> > > >>>> restart has me getting the following error:
> > > >>>>
> > > >>>> near "table": syntax error (Error Code 1)
> > > >>>>
> > > >>>> This error occurs for the previous code sample, and for many, many
> > > other
> > > >>>> pages and methods throughout the instance. I think I will revert
> to an
> > > >>>> older version... unless this is a sign of a sqlite issue?
> > > >>>>
> > > >>>> - Justin
> > > >>>>
> > > >>>> On Tue, Jul 7, 2015 at 3:10 PM, Justin Dennis <[hidden email]>
> > > wrote:
> > > >>>>
> > > >>>>  Thanks for both of your responses. The ->get / ->find method
> doesn't
> > > >>>>> work
> > > >>>>> either because it thinks it's a null.
> > > >>>>>
> > > >>>>> Is the record added?
> > > >>>>>
> > > >>>>>>
> > > >>>>>>
> > > >>>>> Yes, record is added with the values expected.
> > > >>>>>
> > > >>>>>
> > > >>>>>  Did you change something in the ds connection?  Or if you were
> > > relying
> > > >>>>>> on
> > > >>>>>> Lasso's Admin for registering datasources, and you were using
> that
> > > in
> > > >>>>>> ds,
> > > >>>>>> did you change the connection or tables in Lasso Admin?
> > > >>>>>>
> > > >>>>>>
> > > >>>>> Nothing changed here, and the record is added, so this seems to
> not
> > > be
> > > >>>>> the
> > > >>>>> issue.
> > > >>>>>
> > > >>>>> What is the #ds keycolumn, if not the default of id?  If you
> changed
> > > the
> > > >>>>>
> > > >>>>>> keycolumn to something that IS NULL, then a null might be
> returned.
> > > >>>>>>
> > > >>>>>
> > > >>>>>
> > > >>>>> It's the default of 'id'.
> > > >>>>>
> > > >>>>> I've simplified the code to consist of purely the following:
> > > >>>>>
> > > >>>>> local(classSchedule, ds = ds(::atp.classschedule))
> > > >>>>> #classSchedule = #ds->addrow('modified' = date)
> > > >>>>> #classSchedule->type
> > > >>>>>
> > > >>>>> Which returns "null", but the record is still added...
> > > >>>>>
> > > >>>>> - Justin
> > > >>>>>
> > > >>>>>
> > > >>>> #############################################################
> > > >>>>
> > > >>>> This message is sent to you because you are subscribed to
> > > >>>>   the mailing list Lasso [hidden email]
> > > >>>> Official list archives available at http://www.lassotalk.com
> > > >>>> To unsubscribe, E-mail to: <[hidden email]
> >
> > > >>>> Send administrative queries to  <
> [hidden email]>
> > > >>>>
> > > >>>
> > > >>> #############################################################
> > > >>>
> > > >>> This message is sent to you because you are subscribed to
> > > >>>  the mailing list Lasso [hidden email]
> > > >>> Official list archives available at http://www.lassotalk.com
> > > >>> To unsubscribe, E-mail to: <[hidden email]>
> > > >>> Send administrative queries to  <[hidden email]
> >
> > > >>>
> > > >>
> > > >>
> > > >
> > > >#############################################################
> > > >
> > > >This message is sent to you because you are subscribed to
> > > >the mailing list Lasso [hidden email]
> > > >Official list archives available at http://www.lassotalk.com
> > > >To unsubscribe, E-mail to: <[hidden email]>
> > > >Send administrative queries to  <[hidden email]>
> > >
> > > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> > > Steve Piercy              Website Builder              Soquel, CA
> > > <[hidden email]>               <http://www.StevePiercy.com/>
> > >
> > >
> > > #############################################################
> > >
> > > This message is sent to you because you are subscribed to
> > >   the mailing list Lasso [hidden email]
> > > Official list archives available at http://www.lassotalk.com
> > > To unsubscribe, E-mail to: <[hidden email]>
> > > Send administrative queries to  <[hidden email]>
> > >
> >
> > #############################################################
> >
> > This message is sent to you because you are subscribed to
> >   the mailing list Lasso [hidden email]
> > Official list archives available at http://www.lassotalk.com
> > To unsubscribe, E-mail to: <[hidden email]>
> > Send administrative queries to  <[hidden email]>
>
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> Steve Piercy              Website Builder              Soquel, CA
> <[hidden email]>               <http://www.StevePiercy.com/>
>
>
> #############################################################
>
> This message is sent to you because you are subscribed to
>   the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>

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

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: ds Add Row, Get Key Value

stevepiercy
If you make the tests available in the repo, developers could
run them prior to submitting a PR.  We could also supplement
them with more tests to get full coverage if you don't have it
already, and write new tests for new features should they be developed.

--steve


On 7/7/15 at 10:28 PM, [hidden email] (Ke Carlton) pronounced:

>Yes, albeit a fairly small one.
>
>Just got a little sloppy reviewing the pull request in this instance.
>
>Ke
>
>
>
>On Wed, Jul 8, 2015 at 10:26 AM Steve Piercy - Website Builder <
>[hidden email]> wrote:
>
>>I confirm the latest version no longer raises an error for either
>>connection method.
>>
>>local(ds) = ds(::mysqlds, 'localhost', ::db.table, 'moose_user',
>>'pass_hair')
>>local(ds) = ds(::db.table)
>>
>>Sidebar: Do you have a test suite for ds?
>>
>>--steve
>>
>>
>>On 7/7/15 at 10:07 PM, [hidden email] (Ke Carlton) pronounced:
>>
>>>OK, I think I know the cause. I merged a pull request recently that was
>>>meant to deal with table aliases — looks like it's screwed other bits...
>>>
>>>I've reverted the changes pending further review.
>>>
>>>Please try the current version.
>>>
>>>Best regards,
>>>
>>>Ke
>>>
>>>On Wed, Jul 8, 2015 at 9:57 AM Steve Piercy - Website Builder <
>>>[hidden email]> wrote:
>>>
>>>>I'm on 9.2.7, too, and the latest commit works for me.  Maybe
>>>>the cause is how you define your ds?
>>>>
>>>>Here's how I did mine, which bypasses Lasso Admin for speed in
>>>>preference to code brevity.
>>>>
>>>>local(ds) = ds(::mysqlds, 'localhost', ::db.table,
>>>>'moose_user', 'pass_hair')
>>>>
>>>>Compared to yours.
>>>>
>>>>local(ds) = ds(::atp.classschedule)
>>>>
>>>>I'm curious, if you change your ds connection to be like mine,
>>>>what would happen?
>>>>
>>>>I can verify that when I change my connection to be like yours,
>>>>I get the error you reported.
>>>>
>>>>local(ds) = ds(::db.table)
>>>>
>>>>An unhandled failure during a web request
>>>>Error Code: 1
>>>>Error Msg: near "table": syntax error
>>>>Error Stack:
>>>>217:26 sqlite.lasso
>>>>269:19 //var/lasso/instances/default//LassoApps/ds/ds.lasso
>>>>241:18 //var/lasso/instances/default//LassoApps/ds/ds.lasso
>>>>235:3 //var/lasso/instances/default//LassoApps/ds/ds.lasso
>>>>233:4 //var/lasso/instances/default//LassoApps/ds/ds.lasso
>>>>105:4 //var/lasso/instances/default//LassoApps/ds/ds.lasso
>>>>2:13 //Users/stevepiercy/projects/project/webroot//dbcnxn.lasso
>>>>
>>>>Maybe git blame can reveal where something went sideways?
>>>>https://github.com/zeroloop/ds/blame/master/ds.lasso
>>>>
>>>>--steve
>>>>
>>>>
>>>>On 7/7/15 at 3:25 PM, [hidden email] (Justin Dennis) pronounced:
>>>>
>>>>>On 9.2.7, all my problems go away with ds commit
>>>>>831ba0deb600d4c447fe524f978ba0decbba56d6.
>>>>>
>>>>>My original code works fine, and no more errors. FWIW. Sorry to drag
>>>>>everyone through my troubleshooting. :-)
>>>>>
>>>>>- Justin
>>>>>
>>>>>On Tue, Jul 7, 2015 at 3:23 PM, Justin Dennis <[hidden email]>
>>wrote:
>>>>>
>>>>>>This is 9.2.7. I see now in the git log that some of the recent work
>>was
>>>>>>related to 9.3. -Justin
>>>>>>
>>>>>>On Tue, Jul 7, 2015 at 3:22 PM, Steffan A. Cline <[hidden email]>
>>>>>>wrote:
>>>>>>
>>>>>>> What version of Lasso are you using? I know that the latest pull is
>>>>>>> designed specifically to address some issues with 9.3. I would have
>>>>thought
>>>>>>> it was reverse compatible.
>>>>>>>
>>>>>>> Perhaps Ke can chime in soon on this.
>>>>>>>
>>>>>>> Thanks,
>>>>>>> Steffan
>>>>>>>
>>>>>>>
>>>>>>> On , Justin Dennis wrote:
>>>>>>>
>>>>>>>> I was in fact not on the latest ds. A git pull, followed by
>>instance
>>>>>>>> restart has me getting the following error:
>>>>>>>>
>>>>>>>> near "table": syntax error (Error Code 1)
>>>>>>>>
>>>>>>>> This error occurs for the previous code sample, and for many, many
>>>>other
>>>>>>>> pages and methods throughout the instance. I think I will revert
>>to an
>>>>>>>> older version... unless this is a sign of a sqlite issue?
>>>>>>>>
>>>>>>>> - Justin
>>>>>>>>
>>>>>>>> On Tue, Jul 7, 2015 at 3:10 PM, Justin Dennis <[hidden email]>
>>>>wrote:
>>>>>>>>
>>>>>>>>  Thanks for both of your responses. The ->get / ->find method
>>doesn't
>>>>>>>>> work
>>>>>>>>> either because it thinks it's a null.
>>>>>>>>>
>>>>>>>>> Is the record added?
>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>> Yes, record is added with the values expected.
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>  Did you change something in the ds connection?  Or if you were
>>>>relying
>>>>>>>>>> on
>>>>>>>>>> Lasso's Admin for registering datasources, and you were using
>>that
>>>>in
>>>>>>>>>> ds,
>>>>>>>>>> did you change the connection or tables in Lasso Admin?
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>> Nothing changed here, and the record is added, so this seems to
>>not
>>>>be
>>>>>>>>> the
>>>>>>>>> issue.
>>>>>>>>>
>>>>>>>>> What is the #ds keycolumn, if not the default of id?  If you
>>changed
>>>>the
>>>>>>>>>
>>>>>>>>>> keycolumn to something that IS NULL, then a null might be
>>returned.
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> It's the default of 'id'.
>>>>>>>>>
>>>>>>>>> I've simplified the code to consist of purely the following:
>>>>>>>>>
>>>>>>>>> local(classSchedule, ds = ds(::atp.classschedule))
>>>>>>>>> #classSchedule = #ds->addrow('modified' = date)
>>>>>>>>> #classSchedule->type
>>>>>>>>>
>>>>>>>>> Which returns "null", but the record is still added...
>>>>>>>>>
>>>>>>>>> - Justin
>>>>>>>>>
>>>>>>>>>
>>>>>>>> #############################################################
>>>>>>>>
>>>>>>>> This message is sent to you because you are subscribed to
>>>>>>>>   the mailing list Lasso [hidden email]
>>>>>>>> Official list archives available at http://www.lassotalk.com
>>>>>>>> To unsubscribe, E-mail to: <[hidden email]
>>>
>>>>>>>> Send administrative queries to  <
>>[hidden email]>
>>>>>>>>
>>>>>>>
>>>>>>> #############################################################
>>>>>>>
>>>>>>> This message is sent to you because you are subscribed to
>>>>>>>  the mailing list Lasso [hidden email]
>>>>>>> Official list archives available at http://www.lassotalk.com
>>>>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>>>>> Send administrative queries to  <[hidden email]
>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>#############################################################
>>>>>
>>>>>This message is sent to you because you are subscribed to
>>>>>the mailing list Lasso [hidden email]
>>>>>Official list archives available at http://www.lassotalk.com
>>>>>To unsubscribe, E-mail to: <[hidden email]>
>>>>>Send administrative queries to  <[hidden email]>
>>>>
>>>>-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
>>>>Steve Piercy              Website Builder              Soquel, CA
>>>><[hidden email]>               <http://www.StevePiercy.com/>
>>>>
>>>>
>>>>#############################################################
>>>>
>>>>This message is sent to you because you are subscribed to
>>>>the mailing list Lasso [hidden email]
>>>>Official list archives available at http://www.lassotalk.com
>>>>To unsubscribe, E-mail to: <[hidden email]>
>>>>Send administrative queries to  <[hidden email]>
>>>>
>>>
>>>#############################################################
>>>
>>>This message is sent to you because you are subscribed to
>>>the mailing list Lasso [hidden email]
>>>Official list archives available at http://www.lassotalk.com
>>>To unsubscribe, E-mail to: <[hidden email]>
>>>Send administrative queries to  <[hidden email]>
>>
>>-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
>>Steve Piercy              Website Builder              Soquel, CA
>><[hidden email]>               <http://www.StevePiercy.com/>
>>
>>
>>#############################################################
>>
>>This message is sent to you because you are subscribed to
>>the mailing list Lasso [hidden email]
>>Official list archives available at http://www.lassotalk.com
>>To unsubscribe, E-mail to: <[hidden email]>
>>Send administrative queries to  <[hidden email]>
>
>#############################################################
>
>This message is sent to you because you are subscribed to
>the mailing list Lasso [hidden email]
>Official list archives available at http://www.lassotalk.com
>To unsubscribe, E-mail to: <[hidden email]>
>Send administrative queries to  <[hidden email]>

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


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

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: ds Add Row, Get Key Value

Ke Carlton-3
Perhaps, but prefer to keep it with the other skunkworks components of DS
for now.

On Wed, Jul 8, 2015 at 12:59 PM Steve Piercy - Website Builder <
[hidden email]> wrote:

> If you make the tests available in the repo, developers could
> run them prior to submitting a PR.  We could also supplement
> them with more tests to get full coverage if you don't have it
> already, and write new tests for new features should they be developed.
>
> --steve
>
>
> On 7/7/15 at 10:28 PM, [hidden email] (Ke Carlton) pronounced:
>
> >Yes, albeit a fairly small one.
> >
> >Just got a little sloppy reviewing the pull request in this instance.
> >
> >Ke
> >
> >
> >
> >On Wed, Jul 8, 2015 at 10:26 AM Steve Piercy - Website Builder <
> >[hidden email]> wrote:
> >
> >>I confirm the latest version no longer raises an error for either
> >>connection method.
> >>
> >>local(ds) = ds(::mysqlds, 'localhost', ::db.table, 'moose_user',
> >>'pass_hair')
> >>local(ds) = ds(::db.table)
> >>
> >>Sidebar: Do you have a test suite for ds?
> >>
> >>--steve
> >>
> >>
> >>On 7/7/15 at 10:07 PM, [hidden email] (Ke Carlton) pronounced:
> >>
> >>>OK, I think I know the cause. I merged a pull request recently that was
> >>>meant to deal with table aliases — looks like it's screwed other bits...
> >>>
> >>>I've reverted the changes pending further review.
> >>>
> >>>Please try the current version.
> >>>
> >>>Best regards,
> >>>
> >>>Ke
> >>>
> >>>On Wed, Jul 8, 2015 at 9:57 AM Steve Piercy - Website Builder <
> >>>[hidden email]> wrote:
> >>>
> >>>>I'm on 9.2.7, too, and the latest commit works for me.  Maybe
> >>>>the cause is how you define your ds?
> >>>>
> >>>>Here's how I did mine, which bypasses Lasso Admin for speed in
> >>>>preference to code brevity.
> >>>>
> >>>>local(ds) = ds(::mysqlds, 'localhost', ::db.table,
> >>>>'moose_user', 'pass_hair')
> >>>>
> >>>>Compared to yours.
> >>>>
> >>>>local(ds) = ds(::atp.classschedule)
> >>>>
> >>>>I'm curious, if you change your ds connection to be like mine,
> >>>>what would happen?
> >>>>
> >>>>I can verify that when I change my connection to be like yours,
> >>>>I get the error you reported.
> >>>>
> >>>>local(ds) = ds(::db.table)
> >>>>
> >>>>An unhandled failure during a web request
> >>>>Error Code: 1
> >>>>Error Msg: near "table": syntax error
> >>>>Error Stack:
> >>>>217:26 sqlite.lasso
> >>>>269:19 //var/lasso/instances/default//LassoApps/ds/ds.lasso
> >>>>241:18 //var/lasso/instances/default//LassoApps/ds/ds.lasso
> >>>>235:3 //var/lasso/instances/default//LassoApps/ds/ds.lasso
> >>>>233:4 //var/lasso/instances/default//LassoApps/ds/ds.lasso
> >>>>105:4 //var/lasso/instances/default//LassoApps/ds/ds.lasso
> >>>>2:13 //Users/stevepiercy/projects/project/webroot//dbcnxn.lasso
> >>>>
> >>>>Maybe git blame can reveal where something went sideways?
> >>>>https://github.com/zeroloop/ds/blame/master/ds.lasso
> >>>>
> >>>>--steve
> >>>>
> >>>>
> >>>>On 7/7/15 at 3:25 PM, [hidden email] (Justin Dennis) pronounced:
> >>>>
> >>>>>On 9.2.7, all my problems go away with ds commit
> >>>>>831ba0deb600d4c447fe524f978ba0decbba56d6.
> >>>>>
> >>>>>My original code works fine, and no more errors. FWIW. Sorry to drag
> >>>>>everyone through my troubleshooting. :-)
> >>>>>
> >>>>>- Justin
> >>>>>
> >>>>>On Tue, Jul 7, 2015 at 3:23 PM, Justin Dennis <[hidden email]>
> >>wrote:
> >>>>>
> >>>>>>This is 9.2.7. I see now in the git log that some of the recent work
> >>was
> >>>>>>related to 9.3. -Justin
> >>>>>>
> >>>>>>On Tue, Jul 7, 2015 at 3:22 PM, Steffan A. Cline <[hidden email]>
> >>>>>>wrote:
> >>>>>>
> >>>>>>> What version of Lasso are you using? I know that the latest pull is
> >>>>>>> designed specifically to address some issues with 9.3. I would have
> >>>>thought
> >>>>>>> it was reverse compatible.
> >>>>>>>
> >>>>>>> Perhaps Ke can chime in soon on this.
> >>>>>>>
> >>>>>>> Thanks,
> >>>>>>> Steffan
> >>>>>>>
> >>>>>>>
> >>>>>>> On , Justin Dennis wrote:
> >>>>>>>
> >>>>>>>> I was in fact not on the latest ds. A git pull, followed by
> >>instance
> >>>>>>>> restart has me getting the following error:
> >>>>>>>>
> >>>>>>>> near "table": syntax error (Error Code 1)
> >>>>>>>>
> >>>>>>>> This error occurs for the previous code sample, and for many, many
> >>>>other
> >>>>>>>> pages and methods throughout the instance. I think I will revert
> >>to an
> >>>>>>>> older version... unless this is a sign of a sqlite issue?
> >>>>>>>>
> >>>>>>>> - Justin
> >>>>>>>>
> >>>>>>>> On Tue, Jul 7, 2015 at 3:10 PM, Justin Dennis <[hidden email]>
> >>>>wrote:
> >>>>>>>>
> >>>>>>>>  Thanks for both of your responses. The ->get / ->find method
> >>doesn't
> >>>>>>>>> work
> >>>>>>>>> either because it thinks it's a null.
> >>>>>>>>>
> >>>>>>>>> Is the record added?
> >>>>>>>>>
> >>>>>>>>>>
> >>>>>>>>>>
> >>>>>>>>> Yes, record is added with the values expected.
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>>  Did you change something in the ds connection?  Or if you were
> >>>>relying
> >>>>>>>>>> on
> >>>>>>>>>> Lasso's Admin for registering datasources, and you were using
> >>that
> >>>>in
> >>>>>>>>>> ds,
> >>>>>>>>>> did you change the connection or tables in Lasso Admin?
> >>>>>>>>>>
> >>>>>>>>>>
> >>>>>>>>> Nothing changed here, and the record is added, so this seems to
> >>not
> >>>>be
> >>>>>>>>> the
> >>>>>>>>> issue.
> >>>>>>>>>
> >>>>>>>>> What is the #ds keycolumn, if not the default of id?  If you
> >>changed
> >>>>the
> >>>>>>>>>
> >>>>>>>>>> keycolumn to something that IS NULL, then a null might be
> >>returned.
> >>>>>>>>>>
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>>> It's the default of 'id'.
> >>>>>>>>>
> >>>>>>>>> I've simplified the code to consist of purely the following:
> >>>>>>>>>
> >>>>>>>>> local(classSchedule, ds = ds(::atp.classschedule))
> >>>>>>>>> #classSchedule = #ds->addrow('modified' = date)
> >>>>>>>>> #classSchedule->type
> >>>>>>>>>
> >>>>>>>>> Which returns "null", but the record is still added...
> >>>>>>>>>
> >>>>>>>>> - Justin
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>> #############################################################
> >>>>>>>>
> >>>>>>>> This message is sent to you because you are subscribed to
> >>>>>>>>   the mailing list Lasso [hidden email]
> >>>>>>>> Official list archives available at http://www.lassotalk.com
> >>>>>>>> To unsubscribe, E-mail to: <[hidden email]
> >>>
> >>>>>>>> Send administrative queries to  <
> >>[hidden email]>
> >>>>>>>>
> >>>>>>>
> >>>>>>> #############################################################
> >>>>>>>
> >>>>>>> This message is sent to you because you are subscribed to
> >>>>>>>  the mailing list Lasso [hidden email]
> >>>>>>> Official list archives available at http://www.lassotalk.com
> >>>>>>> To unsubscribe, E-mail to: <[hidden email]>
> >>>>>>> Send administrative queries to  <[hidden email]
> >>>
> >>>>>>>
> >>>>>>
> >>>>>>
> >>>>>
> >>>>>#############################################################
> >>>>>
> >>>>>This message is sent to you because you are subscribed to
> >>>>>the mailing list Lasso [hidden email]
> >>>>>Official list archives available at http://www.lassotalk.com
> >>>>>To unsubscribe, E-mail to: <[hidden email]>
> >>>>>Send administrative queries to  <[hidden email]>
> >>>>
> >>>>-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> >>>>Steve Piercy              Website Builder              Soquel, CA
> >>>><[hidden email]>               <http://www.StevePiercy.com/>
> >>>>
> >>>>
> >>>>#############################################################
> >>>>
> >>>>This message is sent to you because you are subscribed to
> >>>>the mailing list Lasso [hidden email]
> >>>>Official list archives available at http://www.lassotalk.com
> >>>>To unsubscribe, E-mail to: <[hidden email]>
> >>>>Send administrative queries to  <[hidden email]>
> >>>>
> >>>
> >>>#############################################################
> >>>
> >>>This message is sent to you because you are subscribed to
> >>>the mailing list Lasso [hidden email]
> >>>Official list archives available at http://www.lassotalk.com
> >>>To unsubscribe, E-mail to: <[hidden email]>
> >>>Send administrative queries to  <[hidden email]>
> >>
> >>-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> >>Steve Piercy              Website Builder              Soquel, CA
> >><[hidden email]>               <http://www.StevePiercy.com/>
> >>
> >>
> >>#############################################################
> >>
> >>This message is sent to you because you are subscribed to
> >>the mailing list Lasso [hidden email]
> >>Official list archives available at http://www.lassotalk.com
> >>To unsubscribe, E-mail to: <[hidden email]>
> >>Send administrative queries to  <[hidden email]>
> >
> >#############################################################
> >
> >This message is sent to you because you are subscribed to
> >the mailing list Lasso [hidden email]
> >Official list archives available at http://www.lassotalk.com
> >To unsubscribe, E-mail to: <[hidden email]>
> >Send administrative queries to  <[hidden email]>
>
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> Steve Piercy              Website Builder              Soquel, CA
> <[hidden email]>               <http://www.StevePiercy.com/>
>
>
> #############################################################
>
> This message is sent to you because you are subscribed to
>   the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>

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

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: ds Add Row, Get Key Value

Justin Dennis-3
In reply to this post by Ke Carlton-3
Current version works great. Thank you! -Justin

On Tue, Jul 7, 2015 at 6:07 PM, Ke Carlton <[hidden email]> wrote:

> OK, I think I know the cause. I merged a pull request recently that was
> meant to deal with table aliases — looks like it's screwed other bits...
>
> I've reverted the changes pending further review.
>
> Please try the current version.
>
> Best regards,
>
> Ke
>
> On Wed, Jul 8, 2015 at 9:57 AM Steve Piercy - Website Builder <
> [hidden email]> wrote:
>
> > I'm on 9.2.7, too, and the latest commit works for me.  Maybe
> > the cause is how you define your ds?
> >
> > Here's how I did mine, which bypasses Lasso Admin for speed in
> > preference to code brevity.
> >
> >      local(ds) = ds(::mysqlds, 'localhost', ::db.table,
> > 'moose_user', 'pass_hair')
> >
> > Compared to yours.
> >
> >      local(ds) = ds(::atp.classschedule)
> >
> > I'm curious, if you change your ds connection to be like mine,
> > what would happen?
> >
> > I can verify that when I change my connection to be like yours,
> > I get the error you reported.
> >
> >      local(ds) = ds(::db.table)
> >
> > An unhandled failure during a web request
> > Error Code: 1
> > Error Msg: near "table": syntax error
> > Error Stack:
> > 217:26 sqlite.lasso
> > 269:19 //var/lasso/instances/default//LassoApps/ds/ds.lasso
> > 241:18 //var/lasso/instances/default//LassoApps/ds/ds.lasso
> > 235:3 //var/lasso/instances/default//LassoApps/ds/ds.lasso
> > 233:4 //var/lasso/instances/default//LassoApps/ds/ds.lasso
> > 105:4 //var/lasso/instances/default//LassoApps/ds/ds.lasso
> > 2:13 //Users/stevepiercy/projects/project/webroot//dbcnxn.lasso
> >
> > Maybe git blame can reveal where something went sideways?
> > https://github.com/zeroloop/ds/blame/master/ds.lasso
> >
> > --steve
> >
> >
> > On 7/7/15 at 3:25 PM, [hidden email] (Justin Dennis) pronounced:
> >
> > >On 9.2.7, all my problems go away with ds commit
> > >831ba0deb600d4c447fe524f978ba0decbba56d6.
> > >
> > >My original code works fine, and no more errors. FWIW. Sorry to drag
> > >everyone through my troubleshooting. :-)
> > >
> > >- Justin
> > >
> > >On Tue, Jul 7, 2015 at 3:23 PM, Justin Dennis <[hidden email]>
> wrote:
> > >
> > >>This is 9.2.7. I see now in the git log that some of the recent work
> was
> > >>related to 9.3. -Justin
> > >>
> > >>On Tue, Jul 7, 2015 at 3:22 PM, Steffan A. Cline <[hidden email]>
> > >>wrote:
> > >>
> > >>> What version of Lasso are you using? I know that the latest pull is
> > >>> designed specifically to address some issues with 9.3. I would have
> > thought
> > >>> it was reverse compatible.
> > >>>
> > >>> Perhaps Ke can chime in soon on this.
> > >>>
> > >>> Thanks,
> > >>> Steffan
> > >>>
> > >>>
> > >>> On , Justin Dennis wrote:
> > >>>
> > >>>> I was in fact not on the latest ds. A git pull, followed by instance
> > >>>> restart has me getting the following error:
> > >>>>
> > >>>> near "table": syntax error (Error Code 1)
> > >>>>
> > >>>> This error occurs for the previous code sample, and for many, many
> > other
> > >>>> pages and methods throughout the instance. I think I will revert to
> an
> > >>>> older version... unless this is a sign of a sqlite issue?
> > >>>>
> > >>>> - Justin
> > >>>>
> > >>>> On Tue, Jul 7, 2015 at 3:10 PM, Justin Dennis <[hidden email]>
> > wrote:
> > >>>>
> > >>>>  Thanks for both of your responses. The ->get / ->find method
> doesn't
> > >>>>> work
> > >>>>> either because it thinks it's a null.
> > >>>>>
> > >>>>> Is the record added?
> > >>>>>
> > >>>>>>
> > >>>>>>
> > >>>>> Yes, record is added with the values expected.
> > >>>>>
> > >>>>>
> > >>>>>  Did you change something in the ds connection?  Or if you were
> > relying
> > >>>>>> on
> > >>>>>> Lasso's Admin for registering datasources, and you were using that
> > in
> > >>>>>> ds,
> > >>>>>> did you change the connection or tables in Lasso Admin?
> > >>>>>>
> > >>>>>>
> > >>>>> Nothing changed here, and the record is added, so this seems to not
> > be
> > >>>>> the
> > >>>>> issue.
> > >>>>>
> > >>>>> What is the #ds keycolumn, if not the default of id?  If you
> changed
> > the
> > >>>>>
> > >>>>>> keycolumn to something that IS NULL, then a null might be
> returned.
> > >>>>>>
> > >>>>>
> > >>>>>
> > >>>>> It's the default of 'id'.
> > >>>>>
> > >>>>> I've simplified the code to consist of purely the following:
> > >>>>>
> > >>>>> local(classSchedule, ds = ds(::atp.classschedule))
> > >>>>> #classSchedule = #ds->addrow('modified' = date)
> > >>>>> #classSchedule->type
> > >>>>>
> > >>>>> Which returns "null", but the record is still added...
> > >>>>>
> > >>>>> - Justin
> > >>>>>
> > >>>>>
> > >>>> #############################################################
> > >>>>
> > >>>> This message is sent to you because you are subscribed to
> > >>>>   the mailing list Lasso [hidden email]
> > >>>> Official list archives available at http://www.lassotalk.com
> > >>>> To unsubscribe, E-mail to: <[hidden email]>
> > >>>> Send administrative queries to  <[hidden email]>
> > >>>>
> > >>>
> > >>> #############################################################
> > >>>
> > >>> This message is sent to you because you are subscribed to
> > >>>  the mailing list Lasso [hidden email]
> > >>> Official list archives available at http://www.lassotalk.com
> > >>> To unsubscribe, E-mail to: <[hidden email]>
> > >>> Send administrative queries to  <[hidden email]>
> > >>>
> > >>
> > >>
> > >
> > >#############################################################
> > >
> > >This message is sent to you because you are subscribed to
> > >the mailing list Lasso [hidden email]
> > >Official list archives available at http://www.lassotalk.com
> > >To unsubscribe, E-mail to: <[hidden email]>
> > >Send administrative queries to  <[hidden email]>
> >
> > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> > Steve Piercy              Website Builder              Soquel, CA
> > <[hidden email]>               <http://www.StevePiercy.com/>
> >
> >
> > #############################################################
> >
> > This message is sent to you because you are subscribed to
> >   the mailing list Lasso [hidden email]
> > Official list archives available at http://www.lassotalk.com
> > To unsubscribe, E-mail to: <[hidden email]>
> > Send administrative queries to  <[hidden email]>
> >
>
> #############################################################
>
> This message is sent to you because you are subscribed to
>   the mailing list Lasso [hidden email]
> Official list archives available at http://www.lassotalk.com
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>
>

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

This message is sent to you because you are subscribed to
  the mailing list Lasso [hidden email]
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>