Re: Also looking for MSSQL integration person

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_

Re: Also looking for MSSQL integration person

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

Re: Also looking for MSSQL integration person

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

Re: Also looking for MSSQL integration person

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

Re: Also looking for MSSQL integration person

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 nvar

Re: Also looking for MSSQL integration person

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

Re: Also looking for MSSQL integration person

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 te

Also looking for MSSQL integration person

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

Re: httpd library

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 b

Re: httpd library

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 . . . :) __

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

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 wo

Re: httpd library

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. ___

RE: httpd library

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,

what is the point of aps.cer?

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, G

Off topic: mySQL collations

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 any

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

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 Go

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 sell