Re: Also looking for MSSQL integration person

[Skip Kimpel via use-livecode]

try_cast worked!!!  I converted those fields, using that technique, into a
varchar and BAM!

Thank you, Bob!

SKIP

On Mon, Jul 26, 2021 at 7:29 PM Bob Sneidar via use-livecode <
use-livecode@lists.runrev.com> wrote:

> > MSSQL has a try_cast snf cast function.
>
> That should read MSSQL has a try_cast AND cast function.
>
> Bob S
>
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Also looking for MSSQL integration person

[Bob Sneidar via use-livecode]

> MSSQL has a try_cast snf cast function. 

That should read MSSQL has a try_cast AND cast function. 

Bob S


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Also looking for MSSQL integration person

[Bob Sneidar via use-livecode]

MAX is the argument for maximum VARCHAR size. SQL Server NVARCHAR data type is 
used to store variable-length, Unicode string data. 

MSSQL has a try_cast snf cast function. Try using that to have the SQL server 
convert the data into VARCHAR and see what you get. 

Bob S


> On Jul 26, 2021, at 15:54 , Skip Kimpel via use-livecode 
>  wrote:
> 
> I think it is how I have everything setup something is getting lost in
> translation.  Keep in mind it is only two fields I am getting the "?"
> results back instead of the text contained inside.  The MSSQL data types of
> those two fields are: nvarchar(max).   Interestingly enough, I have other
> nvarchar fields coming through just fine but the difference is the "(max)"
> piece.
> 
> It is a Azure SQL server and because I have not been able to figure out how
> to do a direct connection to it, I am using an ODBC connector with
> 32/64-bit ODBC Driver 13 for SQL server.
> 
> Does this help at all?  I went through all the encoding types but they all
> failed using the textEncode when I say fail, I mean not the desired
> result.
> 
> Maybe I hone in on the "max" piece of that code??
> 
> 
> SKIP


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Also looking for MSSQL integration person

[Skip Kimpel via use-livecode]

Actually, just looked and another field that is nchar(10) is also receiving
the "?" result so it has nothing to do with the "max" parameter.


SKIP

On Mon, Jul 26, 2021 at 6:54 PM Skip Kimpel  wrote:

> I think it is how I have everything setup something is getting lost in
> translation.  Keep in mind it is only two fields I am getting the "?"
> results back instead of the text contained inside.  The MSSQL data types of
> those two fields are: nvarchar(max).   Interestingly enough, I have other
> nvarchar fields coming through just fine but the difference is the "(max)"
> piece.
>
> It is a Azure SQL server and because I have not been able to figure out
> how to do a direct connection to it, I am using an ODBC connector with
> 32/64-bit ODBC Driver 13 for SQL server.
>
> Does this help at all?  I went through all the encoding types but they all
> failed using the textEncode when I say fail, I mean not the desired
> result.
>
> Maybe I hone in on the "max" piece of that code??
>
>
> SKIP
>
> On Mon, Jul 26, 2021 at 5:01 PM Paul Dupuis via use-livecode <
> use-livecode@lists.runrev.com> wrote:
>
>> I can't help you figure it out, but text coming through as questions
>> marks is almost always and text encoding issue.
>>
>> For example, if the text is stored in the mySQL database as UTF8, then
>> after fetching it in LiveCode nd before placing it in a field, you need
>> to textDecode(,"UTF8") (see the textDecode
>> dictionary entry)
>>
>> If you are going the other way, text entered into a LiveCode field needs
>> to be textEncode(,"UTF") before storing in the database.
>>
>> You need to either look up what encoding you table(s) are using or set
>> the encoding of the table(s) in the database to what you want and then
>> perform the appropriate textEncode or textDecode operations in LC
>>
>>
>>
>> On 7/26/2021 4:44 PM, Skip Kimpel via use-livecode wrote:
>> > I have MSSQL data flowing into my project but two data input fields are
>> > coming through as "?" instead of the actual text.
>> >
>> > WIlling to pay someone to help me figure this out.
>> >
>> > Please contact me directly at s...@magicgate.com
>> >
>> >
>> > Thank you!
>> >
>> > SKIP
>> > ___
>> > use-livecode mailing list
>> > use-livecode@lists.runrev.com
>> > Please visit this url to subscribe, unsubscribe and manage your
>> subscription preferences:
>> > http://lists.runrev.com/mailman/listinfo/use-livecode
>>
>>
>> ___
>> use-livecode mailing list
>> use-livecode@lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Also looking for MSSQL integration person

[Skip Kimpel via use-livecode]

I think it is how I have everything setup something is getting lost in
translation.  Keep in mind it is only two fields I am getting the "?"
results back instead of the text contained inside.  The MSSQL data types of
those two fields are: nvarchar(max).   Interestingly enough, I have other
nvarchar fields coming through just fine but the difference is the "(max)"
piece.

It is a Azure SQL server and because I have not been able to figure out how
to do a direct connection to it, I am using an ODBC connector with
32/64-bit ODBC Driver 13 for SQL server.

Does this help at all?  I went through all the encoding types but they all
failed using the textEncode when I say fail, I mean not the desired
result.

Maybe I hone in on the "max" piece of that code??


SKIP

On Mon, Jul 26, 2021 at 5:01 PM Paul Dupuis via use-livecode <
use-livecode@lists.runrev.com> wrote:

> I can't help you figure it out, but text coming through as questions
> marks is almost always and text encoding issue.
>
> For example, if the text is stored in the mySQL database as UTF8, then
> after fetching it in LiveCode nd before placing it in a field, you need
> to textDecode(,"UTF8") (see the textDecode
> dictionary entry)
>
> If you are going the other way, text entered into a LiveCode field needs
> to be textEncode(,"UTF") before storing in the database.
>
> You need to either look up what encoding you table(s) are using or set
> the encoding of the table(s) in the database to what you want and then
> perform the appropriate textEncode or textDecode operations in LC
>
>
>
> On 7/26/2021 4:44 PM, Skip Kimpel via use-livecode wrote:
> > I have MSSQL data flowing into my project but two data input fields are
> > coming through as "?" instead of the actual text.
> >
> > WIlling to pay someone to help me figure this out.
> >
> > Please contact me directly at s...@magicgate.com
> >
> >
> > Thank you!
> >
> > SKIP
> > ___
> > use-livecode mailing list
> > use-livecode@lists.runrev.com
> > Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> > http://lists.runrev.com/mailman/listinfo/use-livecode
>
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Also looking for MSSQL integration person

[Bob Sneidar via use-livecode]

If it helps, I use InnoDB and my encoding is utf8_general_ci. That's probably 
not good for unicode though. I don't localize my app, it's just for use here at 
work. 

Bob S


> On Jul 26, 2021, at 13:59 , Paul Dupuis via use-livecode 
>  wrote:
> 
> I can't help you figure it out, but text coming through as questions marks is 
> almost always and text encoding issue.
> 
> For example, if the text is stored in the mySQL database as UTF8, then after 
> fetching it in LiveCode nd before placing it in a field, you need to 
> textDecode(,"UTF8") (see the textDecode 
> dictionary entry)
> 
> If you are going the other way, text entered into a LiveCode field needs to 
> be textEncode(,"UTF") before storing in the database.
> 
> You need to either look up what encoding you table(s) are using or set the 
> encoding of the table(s) in the database to what you want and then perform 
> the appropriate textEncode or textDecode operations in LC
> 
> 
> 
> On 7/26/2021 4:44 PM, Skip Kimpel via use-livecode wrote:
>> I have MSSQL data flowing into my project but two data input fields are
>> coming through as "?" instead of the actual text.
>> 
>> WIlling to pay someone to help me figure this out.
>> 
>> Please contact me directly at s...@magicgate.com
>> 
>> 
>> Thank you!
>> 
>> SKIP
>> ___
>> use-livecode mailing list
>> use-livecode@lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your subscription 
>> preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
> 
> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Also looking for MSSQL integration person

[Paul Dupuis via use-livecode]

I can't help you figure it out, but text coming through as questions 
marks is almost always and text encoding issue.


For example, if the text is stored in the mySQL database as UTF8, then 
after fetching it in LiveCode nd before placing it in a field, you need 
to textDecode(,"UTF8") (see the textDecode 
dictionary entry)


If you are going the other way, text entered into a LiveCode field needs 
to be textEncode(,"UTF") before storing in the database.


You need to either look up what encoding you table(s) are using or set 
the encoding of the table(s) in the database to what you want and then 
perform the appropriate textEncode or textDecode operations in LC




On 7/26/2021 4:44 PM, Skip Kimpel via use-livecode wrote:

I have MSSQL data flowing into my project but two data input fields are
coming through as "?" instead of the actual text.

WIlling to pay someone to help me figure this out.

Please contact me directly at s...@magicgate.com


Thank you!

SKIP
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode



___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Also looking for MSSQL integration person

[Skip Kimpel via use-livecode]

I have MSSQL data flowing into my project but two data input fields are
coming through as "?" instead of the actual text.

WIlling to pay someone to help me figure this out.

Please contact me directly at s...@magicgate.com


Thank you!

SKIP
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: httpd library

[Tom Glod via use-livecode]

I just got a haircut, was hoping someone would call me a young man .
but it didn't happen.  Next goes the beard. lolz

On Mon, Jul 26, 2021 at 3:58 PM doc hawk via use-livecode <
use-livecode@lists.runrev.com> wrote:

>
> Andre added,
>
>
> > I love when you folks call me a young man :-) I’ve been 41 for a while
> now and no one asks for my ID when I buy a beer anymore.
>
> That’s why I hang around the knights of columbus—it’s the only place I get
> called “young man” any more . . .
>
> :)
>
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>


-- 
Tom Glod
Founder & Developer
MakeShyft R.D.A (www.makeshyft.com)
Mobile:647.562.9411
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: httpd library

[doc hawk via use-livecode]

Andre added,


> I love when you folks call me a young man :-) I’ve been 41 for a while now 
> and no one asks for my ID when I buy a beer anymore.

That’s why I hang around the knights of columbus—it’s the only place I get 
called “young man” any more . . .

:)

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Looking to hire API (SOAP) expert (work for hire)

[Skip Kimpel via use-livecode]

I have a project on my plate that needs some assistance with an API
integration.  Need some help kicking it off and getting
everything connected... from there on out, I can make the "calls" but need
the initial assistance.

Anybody interested in taking this on?  Obviously I will pay you for your
work.  You can contact me directly at s...@magicgate.com.

Best regards,

SKIP KIMPEL
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: httpd library

[Bob Sneidar via use-livecode]

Just hang out at American airports. I'm 65 and they ask ME for ID. :-)

Bob S


> On Jul 25, 2021, at 14:30 , Andre Garzia via use-livecode 
>  wrote:
> 
> I love when you folks call me a young man :-) I’ve been 41 for a while now 
> and no one asks for my ID when I buy a beer anymore.

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

RE: httpd library

[Erik Beugelaar via use-livecode]

Happy to see there are more talented programmers who are not greedy...
Thumbs up to you.

Erik

-Original Message-
From: use-livecode  On Behalf Of Andre 
Garzia via use-livecode
Sent: maandag 26 juli 2021 12:59
To: How to use LiveCode 
Cc: Andre Garzia 
Subject: Re: httpd library

Bernard,

Thanks for the kind words my friend. :-) I can barely believe it has been 15 
years already, it feels like yesterday.

Don’t worry about the database library, I’m just going to relicense it as MIT 
which will make it free to use for all use cases.  I’m no longer providing 
support or selling software, I want to focus on books. So, if you’d like to 
support me, you can grab a book at:

https://andregarzia.com/books.html  

If you don’t want a book, but want to send some money anyway, you can “buy me a 
coffee” at:

https://ko-fi.com/andregarzia 

Warm regards
Andre

> On 26 Jul 2021, at 00:08, Bernard Devlin via use-livecode 
>  wrote:
> 
> Hi Andre
> 
> It was probably 15 years ago when you said "I want to build a http 
> daemon in Revolution".
> 
> You were a young man :)
> 
> BTW I've started using your dblibrary recently. If I pay for a 
> license, will you get the money?  Can you provide a link for where to 
> make the payment?
> 
> Regards, Bernard
> 
> 
>> 
>> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

what is the point of aps.cer?

[Mike Kerner via use-livecode]

in the new APNS regime, you have to create an aps.cer file, but it does not
seem like it is ever used in APNS. You use your .k8 file to do the work,
and i don't see the aps.cer file being bundled or otherwise accessed,
afterwards. you don't compile your app with it, either.

-- 
On the first day, God created the heavens and the Earth
On the second day, God created the oceans.
On the third day, God put the animals on hold for a few hours,
   and did a little diving.
And God said, "This is good."
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Off topic: mySQL collations

[Tiemo via use-livecode]

Hello,

 

I am testing to migrate a mySQL database from 5.7 to 8. I am using PHP code
between my LiveCode program and the db. This PHP code is pretty old and was
actually written by somebody else.

Since mySQL 8 deprecated some charactersets and collations, the following
query in my PHP is not anymore allowed with mySQL 8 because of the
deprecated collation:

 

$query = "(SELECT * FROM lizenzen WHERE seriennr COLLATE latin1_general_ci
='$serial' COLLATE latin1_general_ci LIMIT 1) UNION (SELECT * FROM lizenz2
WHERE seriennr ='$serial' LIMIT 1)";

 

I now can change the collation, but my question is, do you see any reason
for the collation statement in this select statement at all? The content of
the column "seriennr" is unique and doesn't contains any accented or other
special chars and there is just one record selected in one of the two tables
with the requested seriennr. I am not good in mySQL, but I don't see any use
of the collation. Couldn't I just delete the two collation statements for
the same result or do they have a function I don't see?

 

Thanks

 

Tiemo

 

 

 

 

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: OT: What Is Wrong at play.google.com/Android Apps?

[Sannyasin Brahmanathaswami via use-livecode]

It on Firefox! Google Chrome lets me in… problem solved…

On 7/25/21, 4:26 PM, "use-livecode"  
wrote:


What  is wrong with:

(My developers ID is, for this email, has been blocked out)

https://play.google.com/console/u/0/developers/#/app-list#AppListPlace

?

I will be logged into Google as:

Himalayan Academy 

I should see four apps:

SivaSiva
Spiritual Workout
Hinduism Today
Gurudeva

but we are getting

"We're experiencing longer than usual review times"

and I don't see anything at all?

Is the URL correct?

Brahmanathaswami
___
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: httpd library

[Andre Garzia via use-livecode]

Bernard,

Thanks for the kind words my friend. :-) I can barely believe it has been 15 
years already, it feels like yesterday.

Don’t worry about the database library, I’m just going to relicense it as MIT 
which will make it free to use for all use cases.  I’m no longer providing 
support or selling software, I want to focus on books. So, if you’d like to 
support me, you can grab a book at:

https://andregarzia.com/books.html  

If you don’t want a book, but want to send some money anyway, you can “buy me a 
coffee” at:

https://ko-fi.com/andregarzia 

Warm regards
Andre

> On 26 Jul 2021, at 00:08, Bernard Devlin via use-livecode 
>  wrote:
> 
> Hi Andre
> 
> It was probably 15 years ago when you said "I want to build a http daemon
> in Revolution".
> 
> You were a young man :)
> 
> BTW I've started using your dblibrary recently. If I pay for a license,
> will you get the money?  Can you provide a link for where to make the
> payment?
> 
> Regards, Bernard
> 
> 
>> 
>> 
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode