include_url extra help

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

include_url extra help

French, Shelane
I am running 8.5.6 on Linux.

I see the option for -SendMIMEHeaders and I have been given this guideline
for a REST API call.

How do I properly send these headers. Also, since he wants a single JSON
object as data, do I just have the json encoded variable in the postparams
as a string?

So I would look something like:
include_url('mybaseurl/usernamevalue/Appointments', -username='xxxx',
-password='xxxx',
-SendMimeHeaders=array('Content-Type'='application/json',
'Accept'='application/json'), -POSTParams=$JSONvar);

Create New Appointment
Creates a new appointment in the given mailbox.
Verb:                         POST
Url:                            /{username}/Appointments
Headers:                 Content-Type: application/json, Accept:
application/json
Body (input):         AppointmentData JSON Object (Do not include ID
property)
Body (return):       New appointment (AppointmentData JSON Object


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

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: include_url extra help

French, Shelane
Well, just by test, it worked like that. :-)

He wants the date/time data in Epoch format with milliseconds. I'm at a
loss here.

On 8/27/13 9:08 AM, "French, Shelane" <[hidden email]> wrote:

>I am running 8.5.6 on Linux.
>
>I see the option for -SendMIMEHeaders and I have been given this guideline
>for a REST API call.
>
>How do I properly send these headers. Also, since he wants a single JSON
>object as data, do I just have the json encoded variable in the postparams
>as a string?
>
>So I would look something like:
>include_url('mybaseurl/usernamevalue/Appointments', -username='xxxx',
>-password='xxxx',
>-SendMimeHeaders=array('Content-Type'='application/json',
>'Accept'='application/json'), -POSTParams=$JSONvar);
>
>Create New Appointment
>Creates a new appointment in the given mailbox.
>Verb:                         POST
>Url:                            /{username}/Appointments
>Headers:                 Content-Type: application/json, Accept:
>application/json
>Body (input):         AppointmentData JSON Object (Do not include ID
>property)
>Body (return):       New appointment (AppointmentData JSON Object
>
>
>#############################################################
>
>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]>


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

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: include_url extra help

French, Shelane
Also, I have one method where he wants the verb "DELETE". All other
actions I've managed simply by using a POST or GET param, but I don't know
how to send the DELETE command.

On 8/27/13 9:25 AM, "French, Shelane" <[hidden email]> wrote:

>Well, just by test, it worked like that. :-)
>
>He wants the date/time data in Epoch format with milliseconds. I'm at a
>loss here.
>
>On 8/27/13 9:08 AM, "French, Shelane" <[hidden email]> wrote:
>
>>I am running 8.5.6 on Linux.
>>
>>I see the option for -SendMIMEHeaders and I have been given this
>>guideline
>>for a REST API call.
>>
>>How do I properly send these headers. Also, since he wants a single JSON
>>object as data, do I just have the json encoded variable in the
>>postparams
>>as a string?
>>
>>So I would look something like:
>>include_url('mybaseurl/usernamevalue/Appointments', -username='xxxx',
>>-password='xxxx',
>>-SendMimeHeaders=array('Content-Type'='application/json',
>>'Accept'='application/json'), -POSTParams=$JSONvar);
>>
>>Create New Appointment
>>Creates a new appointment in the given mailbox.
>>Verb:                         POST
>>Url:                            /{username}/Appointments
>>Headers:                 Content-Type: application/json, Accept:
>>application/json
>>Body (input):         AppointmentData JSON Object (Do not include ID
>>property)
>>Body (return):       New appointment (AppointmentData JSON Object
>>
>>
>>#############################################################
>>
>>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]>
>
>
>#############################################################
>
>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]>


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

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: include_url extra help

Brad Lindsay
On 8/27/13, 12:47 PM, French, Shelane wrote:
> Also, I have one method where he wants the verb "DELETE". All other
> actions I've managed simply by using a POST or GET param, but I don't know
> how to send the DELETE command.

Not possible using include_url in Lasso 8.5.6, but it is possible in
Lasso 9's implementation. (Lasso 9 also has a curl type for even more
fine-grained control.)

For 8.5, you can use [os_process] to call the curl command-line tool.

Brad

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

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: include_url extra help

French, Shelane
If I use os_process to do this... Do you know what I would do in the curl
command to submit all this info:

var('data' = string(include_url('https://url', -username='xxx',
-password='xxx', -SendMimeHeaders=array('Accept'='application/json'),
-getparams=array('id'='itemIDvalue'))));

...and the DELETE command.

On 8/27/13 11:12 AM, "Brad Lindsay" <[hidden email]> wrote:

>On 8/27/13, 12:47 PM, French, Shelane wrote:
>> Also, I have one method where he wants the verb "DELETE". All other
>> actions I've managed simply by using a POST or GET param, but I don't
>>know
>> how to send the DELETE command.
>
>Not possible using include_url in Lasso 8.5.6, but it is possible in
>Lasso 9's implementation. (Lasso 9 also has a curl type for even more
>fine-grained control.)
>
>For 8.5, you can use [os_process] to call the curl command-line tool.
>
>Brad
>
>#############################################################
>
>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]>


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

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: include_url extra help

stevepiercy
See:
http://curl.haxx.se/docs/manpage.html

And I'd use shell over os_process.

--steve


On 8/27/13 at 6:17 PM, [hidden email] (French, Shelane) pronounced:

> If I use os_process to do this... Do you know what I would do in the curl
> command to submit all this info:
>
> var('data' = string(include_url('https://url', -username='xxx',
> -password='xxx', -SendMimeHeaders=array('Accept'='application/json'),
> -getparams=array('id'='itemIDvalue'))));
>
> ...and the DELETE command.
>
> On 8/27/13 11:12 AM, "Brad Lindsay" <[hidden email]> wrote:
>
> >On 8/27/13, 12:47 PM, French, Shelane wrote:
> >> Also, I have one method where he wants the verb "DELETE". All other
> >> actions I've managed simply by using a POST or GET param, but I don't
> >>know
> >> how to send the DELETE command.
> >
> >Not possible using include_url in Lasso 8.5.6, but it is possible in
> >Lasso 9's implementation. (Lasso 9 also has a curl type for even more
> >fine-grained control.)
> >
> >For 8.5, you can use [os_process] to call the curl command-line tool.
> >
> >Brad
> >
> >#############################################################
> >
> >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]>
>
>
> #############################################################
>
> 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]>
Reply | Threaded
Open this post in threaded view
|

Re: include_url extra help

French, Shelane
In reply to this post by French, Shelane
Any takers on this question?

On 8/27/13 9:25 AM, "French, Shelane" <[hidden email]> wrote:

>He wants the date/time data in Epoch format with milliseconds. I'm at a
>loss here.


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

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: include_url extra help

Paul Melia-4
Found this via some googling....

http://stackoverflow.com/questions/10839151/convert-mysql-datetime-column-to-epoch-seconds

If you are using MySQL as your database, looks like there's a function (UNIX_TIMESTAMP) that you can use.

Hope this helps,
Paul

On Aug 27, 2013, at 3:47 PM, "French, Shelane" <[hidden email]> wrote:

> Any takers on this question?
>
> On 8/27/13 9:25 AM, "French, Shelane" <[hidden email]> wrote:
>
>> He wants the date/time data in Epoch format with milliseconds. I'm at a
>> loss here.
>
>
> #############################################################
>
> 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]>


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

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: include_url extra help

French, Shelane
Thanks. That would be helpful if I had a single date/time field. I have
three fields: eventDate, startTime, endTime. I will have to submit two
items to the request with startdate/time, enddate/time (end date is same
as start date in our case).

On 8/27/13 12:57 PM, "Paul Melia" <[hidden email]> wrote:

>Found this via some googling....
>
>http://stackoverflow.com/questions/10839151/convert-mysql-datetime-column-
>to-epoch-seconds
>
>If you are using MySQL as your database, looks like there's a function
>(UNIX_TIMESTAMP) that you can use.
>
>Hope this helps,
>Paul
>
>On Aug 27, 2013, at 3:47 PM, "French, Shelane" <[hidden email]> wrote:
>
>> Any takers on this question?
>>
>> On 8/27/13 9:25 AM, "French, Shelane" <[hidden email]> wrote:
>>
>>> He wants the date/time data in Epoch format with milliseconds. I'm at a
>>> loss here.
>>
>>
>> #############################################################
>>
>> 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]>
>
>
>#############################################################
>
>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]>


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

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: include_url extra help

Tim Taplin
It looks like you can  create a date/time string and use the unix_timestamp function in your select statement to create the epoch time that you need.

SELECT UNIX_TIMESTAMP(timestring)
Time format: YYYY-MM-DD HH:MM:SS or YYMMDD or YYYYMMDD

select unix_timestamp(concat(eventDate, " ", startTime)) as startepoch, unix_timestamp(concat(eventDate, " ", startTime)) as endepoch;

assuming your eventDate and start/end time columns have formats that match the documentation above... Otherwise you may need to do some further manipulation.

I thought that there was a similar date format available in lasso, but I could not find it in the lasso8 docs.

Hope its helpful.

Tim Taplin

On Aug 27, 2013, at 2:00 PM, "French, Shelane" <[hidden email]> wrote:

> Thanks. That would be helpful if I had a single date/time field. I have
> three fields: eventDate, startTime, endTime. I will have to submit two
> items to the request with startdate/time, enddate/time (end date is same
> as start date in our case).
>
> On 8/27/13 12:57 PM, "Paul Melia" <[hidden email]> wrote:
>
>> Found this via some googling....
>>
>> http://stackoverflow.com/questions/10839151/convert-mysql-datetime-column-
>> to-epoch-seconds
>>
>> If you are using MySQL as your database, looks like there's a function
>> (UNIX_TIMESTAMP) that you can use.
>>
>> Hope this helps,
>> Paul
>>
>> On Aug 27, 2013, at 3:47 PM, "French, Shelane" <[hidden email]> wrote:
>>
>>> Any takers on this question?
>>>
>>> On 8/27/13 9:25 AM, "French, Shelane" <[hidden email]> wrote:
>>>
>>>> He wants the date/time data in Epoch format with milliseconds. I'm at a
>>>> loss here.
>>>
>>>
>>> #############################################################
>>>
>>> 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]>
>>
>>
>> #############################################################
>>
>> 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]>
>
>
> #############################################################
>
> 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]>


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

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: include_url extra help

stevepiercy
Searching the Language Guide for "UNIX" returns this example:

[(Date: '1970-1-1 00:00:00 GMT')->(Difference: Date,
-SecondsBetween)] ➜ 1171055428

That's in epoch seconds, not milliseconds, but just multiply the
result by 1000 to get "good enough".

--steve


On 8/27/13 at 2:49 PM, [hidden email] (Tim Taplin) pronounced:

>It looks like you can  create a date/time string and use the
>unix_timestamp function in your select statement to create the
>epoch time that you need.
>
>SELECT UNIX_TIMESTAMP(timestring)
>Time format: YYYY-MM-DD HH:MM:SS or YYMMDD or YYYYMMDD
>
>select unix_timestamp(concat(eventDate, " ", startTime)) as
>startepoch, unix_timestamp(concat(eventDate, " ", startTime))
>as endepoch;
>
>assuming your eventDate and start/end time columns have formats
>that match the documentation above... Otherwise you may need to
>do some further manipulation.
>
>I thought that there was a similar date format available in
>lasso, but I could not find it in the lasso8 docs.
>
>Hope its helpful.
>
>Tim Taplin
>
>On Aug 27, 2013, at 2:00 PM, "French, Shelane" <[hidden email]> wrote:
>
>>Thanks. That would be helpful if I had a single date/time field. I have
>>three fields: eventDate, startTime, endTime. I will have to submit two
>>items to the request with startdate/time, enddate/time (end date is same
>>as start date in our case).
>>
>>On 8/27/13 12:57 PM, "Paul Melia" <[hidden email]> wrote:
>>
>>> Found this via some googling....
>>>   http://stackoverflow.com/questions/10839151/convert-mysql-datetime-column-
>>> to-epoch-seconds
>>>   If you are using MySQL as your database, looks like
>>>there's a function
>>> (UNIX_TIMESTAMP) that you can use.
>>>   Hope this helps,
>>> Paul
>>>   On Aug 27, 2013, at 3:47 PM, "French, Shelane"
>>><[hidden email]> wrote:
>>>
>>>> Any takers on this question?
>>>>   On 8/27/13 9:25 AM, "French, Shelane" <[hidden email]> wrote:
>>>>
>>>>> He wants the date/time data in Epoch format with milliseconds. I'm at a
>>>>> loss here.
>>>>    #############################################################
>>>>   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]>
>>>    #############################################################
>>>   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]>
>>
>>
>>#############################################################
>>
>>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]>
>
>
>#############################################################
>
>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]>
Reply | Threaded
Open this post in threaded view
|

Re: include_url extra help

Brad Lindsay
If I remember correctly, [date_msec] returns the date as epoch in
milliseconds.

Brad

On 8/27/13, 5:14 PM, Steve Piercy - Web Site Builder wrote:

> Searching the Language Guide for "UNIX" returns this example:
>
> [(Date: '1970-1-1 00:00:00 GMT')->(Difference: Date, -SecondsBetween)] ➜
> 1171055428
>
> That's in epoch seconds, not milliseconds, but just multiply the result
> by 1000 to get "good enough".
>
> --steve
>
>
> On 8/27/13 at 2:49 PM, [hidden email] (Tim Taplin) pronounced:
>
>> It looks like you can create a date/time string and use the
>> unix_timestamp function in your select statement to create the epoch
>> time that you need.
>>
>> SELECT UNIX_TIMESTAMP(timestring)
>> Time format: YYYY-MM-DD HH:MM:SS or YYMMDD or YYYYMMDD
>>
>> select unix_timestamp(concat(eventDate, " ", startTime)) as
>> startepoch, unix_timestamp(concat(eventDate, " ", startTime)) as
>> endepoch;
>>
>> assuming your eventDate and start/end time columns have formats that
>> match the documentation above... Otherwise you may need to do some
>> further manipulation.
>>
>> I thought that there was a similar date format available in lasso, but
>> I could not find it in the lasso8 docs.
>>
>> Hope its helpful.
>>
>> Tim Taplin
>>
>> On Aug 27, 2013, at 2:00 PM, "French, Shelane" <[hidden email]> wrote:
>>
>>> Thanks. That would be helpful if I had a single date/time field. I have
>>> three fields: eventDate, startTime, endTime. I will have to submit two
>>> items to the request with startdate/time, enddate/time (end date is same
>>> as start date in our case).
>>>
>>> On 8/27/13 12:57 PM, "Paul Melia" <[hidden email]> wrote:
>>>
>>>> Found this via some googling....
>>>> http://stackoverflow.com/questions/10839151/convert-mysql-datetime-column-
>>>>
>>>> to-epoch-seconds
>>>> If you are using MySQL as your database, looks like there's a function
>>>> (UNIX_TIMESTAMP) that you can use.
>>>> Hope this helps,
>>>> Paul
>>>> On Aug 27, 2013, at 3:47 PM, "French, Shelane" <[hidden email]>
>>>> wrote:
>>>>
>>>>> Any takers on this question?
>>>>> On 8/27/13 9:25 AM, "French, Shelane" <[hidden email]> wrote:
>>>>>
>>>>>> He wants the date/time data in Epoch format with milliseconds. I'm
>>>>>> at a
>>>>>> loss here.
>>>>> #############################################################
>>>>> 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]>
>>>> #############################################################
>>>> 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]>
>>>
>>>
>>> #############################################################
>>>
>>> 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]>
>>
>>
>> #############################################################
>>
>> 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]>

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

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: include_url extra help

stevepiercy
date_msec/(1000*60*60*24*365.25);  // 1000 ms/minute, 60 min/hr,
24 hr/day, 365.25 days/year

=>
0.000299

I don't think so.

Here's the definition:

     [Date_Msec]

     Returns an integer representing the number of milliseconds
recorded on
     the machine's internal clock.

Which is different from a UNIX timestamp.  Not sure what is the
definition of "internal clock", but I would guess it is specific
to the machine.

--steve


On 8/27/13 at 5:53 PM, [hidden email] (Brad Lindsay) pronounced:

>If I remember correctly, [date_msec] returns the date as epoch
>in milliseconds.
>
>Brad
>
>On 8/27/13, 5:14 PM, Steve Piercy - Web Site Builder wrote:
>>Searching the Language Guide for "UNIX" returns this example:
>>
>>[(Date: '1970-1-1 00:00:00 GMT')->(Difference: Date, -SecondsBetween)] ➜
>>1171055428
>>
>>That's in epoch seconds, not milliseconds, but just multiply the result
>>by 1000 to get "good enough".
>>
>>--steve
>>
>>
>>On 8/27/13 at 2:49 PM, [hidden email] (Tim Taplin) pronounced:
>>
>>> It looks like you can create a date/time string and use the
>>> unix_timestamp function in your select statement to create the epoch
>>> time that you need.
>>>
>>> SELECT UNIX_TIMESTAMP(timestring)
>>> Time format: YYYY-MM-DD HH:MM:SS or YYMMDD or YYYYMMDD
>>>
>>> select unix_timestamp(concat(eventDate, " ", startTime)) as
>>> startepoch, unix_timestamp(concat(eventDate, " ", startTime)) as
>>> endepoch;
>>>
>>> assuming your eventDate and start/end time columns have formats that
>>> match the documentation above... Otherwise you may need to do some
>>> further manipulation.
>>>
>>> I thought that there was a similar date format available in lasso, but
>>> I could not find it in the lasso8 docs.
>>>
>>> Hope its helpful.
>>>
>>> Tim Taplin
>>>
>>> On Aug 27, 2013, at 2:00 PM, "French, Shelane" <[hidden email]> wrote:
>>>
>>>> Thanks. That would be helpful if I had a single date/time field. I have
>>>> three fields: eventDate, startTime, endTime. I will have to submit two
>>>> items to the request with startdate/time, enddate/time (end date is same
>>>> as start date in our case).
>>>>
>>>> On 8/27/13 12:57 PM, "Paul Melia" <[hidden email]> wrote:
>>>>
>>>>> Found this via some googling....
>>>>> http://stackoverflow.com/questions/10839151/convert-mysql-datetime-column-
>>>>>
>>>>> to-epoch-seconds
>>>>> If you are using MySQL as your database, looks like there's a function
>>>>> (UNIX_TIMESTAMP) that you can use.
>>>>> Hope this helps,
>>>>> Paul
>>>>> On Aug 27, 2013, at 3:47 PM, "French, Shelane" <[hidden email]>
>>>>> wrote:
>>>>>
>>>>>> Any takers on this question?
>>>>>> On 8/27/13 9:25 AM, "French, Shelane" <[hidden email]> wrote:
>>>>>>
>>>>>>> He wants the date/time data in Epoch format with milliseconds. I'm
>>>>>>> at a
>>>>>>> loss here.
>>>>>> #############################################################
>>>>>> 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]>
>>>>> #############################################################
>>>>> 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]>
>>>>
>>>>
>>>> #############################################################
>>>>
>>>> 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]>
>>>
>>>
>>> #############################################################
>>>
>>> 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]>
>
>#############################################################
>
>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]>
Reply | Threaded
Open this post in threaded view
|

Re: include_url extra help

Ke Carlton-3
define date->unixtime => {
local(now = .ascopy)
#now->settimezone('GMT')
return (#now -  date('1970-01-01 00:00:00 GMT'))->asinteger
}



On 27 August 2013 23:20, Steve Piercy - Web Site Builder <
[hidden email]> wrote:

> date_msec/(1000*60*60*24*365.**25);  // 1000 ms/minute, 60 min/hr, 24
> hr/day, 365.25 days/year
>
> =>
> 0.000299
>
> I don't think so.
>
> Here's the definition:
>
>     [Date_Msec]
>
>     Returns an integer representing the number of milliseconds recorded on
>     the machine's internal clock.
>
> Which is different from a UNIX timestamp.  Not sure what is the definition
> of "internal clock", but I would guess it is specific to the machine.
>
> --steve
>
>
> On 8/27/13 at 5:53 PM, [hidden email] (Brad Lindsay) pronounced:
>
>
>  If I remember correctly, [date_msec] returns the date as epoch in
>> milliseconds.
>>
>> Brad
>>
>> On 8/27/13, 5:14 PM, Steve Piercy - Web Site Builder wrote:
>>
>>> Searching the Language Guide for "UNIX" returns this example:
>>>
>>> [(Date: '1970-1-1 00:00:00 GMT')->(Difference: Date, -SecondsBetween)] ➜
>>> 1171055428
>>>
>>> That's in epoch seconds, not milliseconds, but just multiply the result
>>> by 1000 to get "good enough".
>>>
>>> --steve
>>>
>>>
>>> On 8/27/13 at 2:49 PM, [hidden email] (Tim Taplin)
>>> pronounced:
>>>
>>>  It looks like you can create a date/time string and use the
>>>> unix_timestamp function in your select statement to create the epoch
>>>> time that you need.
>>>>
>>>> SELECT UNIX_TIMESTAMP(timestring)
>>>> Time format: YYYY-MM-DD HH:MM:SS or YYMMDD or YYYYMMDD
>>>>
>>>> select unix_timestamp(concat(**eventDate, " ", startTime)) as
>>>> startepoch, unix_timestamp(concat(**eventDate, " ", startTime)) as
>>>> endepoch;
>>>>
>>>> assuming your eventDate and start/end time columns have formats that
>>>> match the documentation above... Otherwise you may need to do some
>>>> further manipulation.
>>>>
>>>> I thought that there was a similar date format available in lasso, but
>>>> I could not find it in the lasso8 docs.
>>>>
>>>> Hope its helpful.
>>>>
>>>> Tim Taplin
>>>>
>>>> On Aug 27, 2013, at 2:00 PM, "French, Shelane" <[hidden email]>
>>>> wrote:
>>>>
>>>>  Thanks. That would be helpful if I had a single date/time field. I have
>>>>> three fields: eventDate, startTime, endTime. I will have to submit two
>>>>> items to the request with startdate/time, enddate/time (end date is
>>>>> same
>>>>> as start date in our case).
>>>>>
>>>>> On 8/27/13 12:57 PM, "Paul Melia" <[hidden email]> wrote:
>>>>>
>>>>>  Found this via some googling....
>>>>>> http://stackoverflow.com/**questions/10839151/convert-**
>>>>>> mysql-datetime-column-<http://stackoverflow.com/questions/10839151/convert-mysql-datetime-column->
>>>>>>
>>>>>> to-epoch-seconds
>>>>>> If you are using MySQL as your database, looks like there's a function
>>>>>> (UNIX_TIMESTAMP) that you can use.
>>>>>> Hope this helps,
>>>>>> Paul
>>>>>> On Aug 27, 2013, at 3:47 PM, "French, Shelane" <[hidden email]>
>>>>>> wrote:
>>>>>>
>>>>>>  Any takers on this question?
>>>>>>> On 8/27/13 9:25 AM, "French, Shelane" <[hidden email]> wrote:
>>>>>>>
>>>>>>>  He wants the date/time data in Epoch format with milliseconds. I'm
>>>>>>>> at a
>>>>>>>> loss here.
>>>>>>>>
>>>>>>> ##############################**##############################**#
>>>>>>> Attend the Lasso Developer Conference 2013!
>>>>>>> Sept 12-14, 2013 in Niagara Falls, Canada
>>>>>>> http://www.lassosoft.com/LDC-**niagara-falls-2013<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: <Lasso-unsubscribe@lists.**lassosoft.com<[hidden email]>
>>>>>>> >
>>>>>>> Send administrative queries to <Lasso-request@lists.**lassosoft.com<[hidden email]>
>>>>>>> >
>>>>>>>
>>>>>> ##############################**##############################**#
>>>>>> Attend the Lasso Developer Conference 2013!
>>>>>> Sept 12-14, 2013 in Niagara Falls, Canada
>>>>>> http://www.lassosoft.com/LDC-**niagara-falls-2013<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: <Lasso-unsubscribe@lists.**lassosoft.com<[hidden email]>
>>>>>> >
>>>>>> Send administrative queries to <Lasso-request@lists.**lassosoft.com<[hidden email]>
>>>>>> >
>>>>>>
>>>>>
>>>>>
>>>>> ##############################**##############################**#
>>>>>
>>>>> Attend the Lasso Developer Conference 2013!
>>>>> Sept 12-14, 2013 in Niagara Falls, Canada
>>>>> http://www.lassosoft.com/LDC-**niagara-falls-2013<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: <Lasso-unsubscribe@lists.**lassosoft.com<[hidden email]>
>>>>> >
>>>>> Send administrative queries to <Lasso-request@lists.**lassosoft.com<[hidden email]>
>>>>> >
>>>>>
>>>>
>>>>
>>>> ##############################**##############################**#
>>>>
>>>> Attend the Lasso Developer Conference 2013!
>>>> Sept 12-14, 2013 in Niagara Falls, Canada
>>>> http://www.lassosoft.com/LDC-**niagara-falls-2013<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: <Lasso-unsubscribe@lists.**lassosoft.com<[hidden email]>
>>>> >
>>>> Send administrative queries to <Lasso-request@lists.**lassosoft.com<[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<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: <Lasso-unsubscribe@lists.**lassosoft.com<[hidden email]>
>>> >
>>> Send administrative queries to <Lasso-request@lists.**lassosoft.com<[hidden email]>
>>> >
>>>
>>
>> ##############################**##############################**#
>>
>> Attend the Lasso Developer Conference 2013!
>> Sept 12-14, 2013 in Niagara Falls, Canada
>> http://www.lassosoft.com/LDC-**niagara-falls-2013<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: <Lasso-unsubscribe@lists.**lassosoft.com<[hidden email]>
>> >
>> Send administrative queries to  <Lasso-request@lists.**lassosoft.com<[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<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: <Lasso-unsubscribe@lists.**lassosoft.com<[hidden email]>
> >
> Send administrative queries to  <Lasso-request@lists.**lassosoft.com<[hidden email]>
> >
>

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

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: include_url extra help

stevepiercy
Shelane needs to set up a Lasso 9 server and build an API on it
so that her Lasso 8.5.6 server can fire off a command to it.  ;)

Also Ke's example returns seconds, not millis, although it could
still be multiplied by 1000 to be "good enough".

--steve


On 8/28/13 at 12:00 AM, [hidden email] (Ke Carlton) pronounced:

>define date->unixtime => {
>local(now = .ascopy)
>#now->settimezone('GMT')
>return (#now -  date('1970-01-01 00:00:00 GMT'))->asinteger
>}
>
>
>
>On 27 August 2013 23:20, Steve Piercy - Web Site Builder <
>[hidden email]> wrote:
>
>>date_msec/(1000*60*60*24*365.**25);  // 1000 ms/minute, 60 min/hr, 24
>>hr/day, 365.25 days/year
>>
>>=>
>>0.000299
>>
>>I don't think so.
>>
>>Here's the definition:
>>
>>[Date_Msec]
>>
>>Returns an integer representing the number of milliseconds recorded on
>>the machine's internal clock.
>>
>>Which is different from a UNIX timestamp.  Not sure what is the definition
>>of "internal clock", but I would guess it is specific to the machine.
>>
>>--steve
>>
>>
>>On 8/27/13 at 5:53 PM, [hidden email] (Brad Lindsay) pronounced:
>>
>>
>>If I remember correctly, [date_msec] returns the date as epoch in
>>> milliseconds.
>>>
>>> Brad
>>>
>>> On 8/27/13, 5:14 PM, Steve Piercy - Web Site Builder wrote:
>>>
>>>> Searching the Language Guide for "UNIX" returns this example:
>>>>
>>>> [(Date: '1970-1-1 00:00:00 GMT')->(Difference: Date, -SecondsBetween)] ➜
>>>> 1171055428
>>>>
>>>> That's in epoch seconds, not milliseconds, but just multiply the result
>>>> by 1000 to get "good enough".
>>>>
>>>> --steve
>>>>
>>>>
>>>> On 8/27/13 at 2:49 PM, [hidden email] (Tim Taplin)
>>>> pronounced:
>>>>
>>>>  It looks like you can create a date/time string and use the
>>>>> unix_timestamp function in your select statement to create the epoch
>>>>> time that you need.
>>>>>
>>>>> SELECT UNIX_TIMESTAMP(timestring)
>>>>> Time format: YYYY-MM-DD HH:MM:SS or YYMMDD or YYYYMMDD
>>>>>
>>>>> select unix_timestamp(concat(**eventDate, " ", startTime)) as
>>>>> startepoch, unix_timestamp(concat(**eventDate, " ", startTime)) as
>>>>> endepoch;
>>>>>
>>>>> assuming your eventDate and start/end time columns have formats that
>>>>> match the documentation above... Otherwise you may need to do some
>>>>> further manipulation.
>>>>>
>>>>> I thought that there was a similar date format available in lasso, but
>>>>> I could not find it in the lasso8 docs.
>>>>>
>>>>> Hope its helpful.
>>>>>
>>>>> Tim Taplin
>>>>>
>>>>> On Aug 27, 2013, at 2:00 PM, "French, Shelane" <[hidden email]>
>>>>> wrote:
>>>>>
>>>>>  Thanks. That would be helpful if I had a single date/time field. I have
>>>>>> three fields: eventDate, startTime, endTime. I will have to submit two
>>>>>> items to the request with startdate/time, enddate/time (end date is
>>>>>> same
>>>>>> as start date in our case).
>>>>>>
>>>>>> On 8/27/13 12:57 PM, "Paul Melia" <[hidden email]> wrote:
>>>>>>
>>>>>>  Found this via some googling....
>>>>>>> http://stackoverflow.com/**questions/10839151/convert-**
>>>>>>>
>mysql-datetime-column-<http://stackoverflow.com/questions/10839151/convert-mysql-
>datetime-column->
>>>>>>>
>>>>>>> to-epoch-seconds
>>>>>>> If you are using MySQL as your database, looks like there's a function
>>>>>>> (UNIX_TIMESTAMP) that you can use.
>>>>>>> Hope this helps,
>>>>>>> Paul
>>>>>>> On Aug 27, 2013, at 3:47 PM, "French, Shelane" <[hidden email]>
>>>>>>> wrote:
>>>>>>>
>>>>>>>  Any takers on this question?
>>>>>>>> On 8/27/13 9:25 AM, "French, Shelane" <[hidden email]> wrote:
>>>>>>>>
>>>>>>>>  He wants the date/time data in Epoch format with milliseconds. I'm
>>>>>>>>> at a
>>>>>>>>> loss here.
>>>>>>>>>
>>>>>>>> ##############################**##############################**#
>>>>>>>> Attend the Lasso Developer Conference 2013!
>>>>>>>> Sept 12-14, 2013 in Niagara Falls, Canada
>>>>>>>>
>http://www.lassosoft.com/LDC-**niagara-falls-2013<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:
><Lasso-unsubscribe@lists.**lassosoft.com<[hidden email]>
>>>>>>>> >
>>>>>>>> Send administrative queries to
><Lasso-request@lists.**lassosoft.com<[hidden email]>
>>>>>>>> >
>>>>>>>>
>>>>>>> ##############################**##############################**#
>>>>>>> Attend the Lasso Developer Conference 2013!
>>>>>>> Sept 12-14, 2013 in Niagara Falls, Canada
>>>>>>>
>http://www.lassosoft.com/LDC-**niagara-falls-2013<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:
><Lasso-unsubscribe@lists.**lassosoft.com<[hidden email]>
>>>>>>> >
>>>>>>> Send administrative queries to
><Lasso-request@lists.**lassosoft.com<[hidden email]>
>>>>>>> >
>>>>>>>
>>>>>>
>>>>>>
>>>>>> ##############################**##############################**#
>>>>>>
>>>>>> Attend the Lasso Developer Conference 2013!
>>>>>> Sept 12-14, 2013 in Niagara Falls, Canada
>>>>>>
>http://www.lassosoft.com/LDC-**niagara-falls-2013<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:
><Lasso-unsubscribe@lists.**lassosoft.com<[hidden email]>
>>>>>> >
>>>>>> Send administrative queries to
><Lasso-request@lists.**lassosoft.com<[hidden email]>
>>>>>> >
>>>>>>
>>>>>
>>>>>
>>>>> ##############################**##############################**#
>>>>>
>>>>> Attend the Lasso Developer Conference 2013!
>>>>> Sept 12-14, 2013 in Niagara Falls, Canada
>>>>>
>http://www.lassosoft.com/LDC-**niagara-falls-2013<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:
><Lasso-unsubscribe@lists.**lassosoft.com<[hidden email]>
>>>>> >
>>>>> Send administrative queries to
><Lasso-request@lists.**lassosoft.com<[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<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:
><Lasso-unsubscribe@lists.**lassosoft.com<[hidden email]>
>>>> >
>>>> Send administrative queries to
><Lasso-request@lists.**lassosoft.com<[hidden email]>
>>>> >
>>>>
>>>
>>> ##############################**##############################**#
>>>
>>> Attend the Lasso Developer Conference 2013!
>>> Sept 12-14, 2013 in Niagara Falls, Canada
>>>
>http://www.lassosoft.com/LDC-**niagara-falls-2013<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:
><Lasso-unsubscribe@lists.**lassosoft.com<[hidden email]>
>>> >
>>> Send administrative queries to
><Lasso-request@lists.**lassosoft.com<[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<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:
><Lasso-unsubscribe@lists.**lassosoft.com<[hidden email]>
>>>
>>Send administrative queries to
><Lasso-request@lists.**lassosoft.com<[hidden email]>
>>>
>>
>
>#############################################################
>
>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]>
Reply | Threaded
Open this post in threaded view
|

Re: include_url extra help

Ke Carlton-3
On 28 August 2013 00:42, Steve Piercy - Web Site Builder <
[hidden email]> wrote:

> "Shelane needs to set up a Lasso 9 server and build an API on it so that
> her Lasso 8.5.6 server can fire off a command to it."
>

Seems reasonable. :)

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

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]>