Search found 116 matches

by bbhank
Sat Apr 02, 2016 12:53 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Put the long date into field
Replies: 10
Views: 1212

Re: Put the long date into field

That works fine.
Thank you.
by bbhank
Fri Apr 01, 2016 6:08 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Remove Carriage Returns
Replies: 51
Views: 6649

Re: Remove Carriage Returns

You got it! :D Here's what I'm thinking about. Export the database. Clean the Description field. Re-import. That'll fix what's there. All new entries have to go through the admin process anyway for approval. Now,thanks to you folks, that I know way more about what's happening, I can manually clean t...
by bbhank
Fri Apr 01, 2016 5:21 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Remove Carriage Returns
Replies: 51
Views: 6649

Re: Remove Carriage Returns

That's what I've been asking all along. pDataArray["label 11"] already contains "corrupted" data (only the first LINE of the actual db field "Description") - I was already aware of how this works and this is why I asked the question about that specific field and not about the whole query in the orig...
by bbhank
Fri Apr 01, 2016 5:05 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Put the long date into field
Replies: 10
Views: 1212

Re: Put the long date into field

At this point to convert that date to the long date is needed. Your solution on putting "of me" did the trick, now I just need the date "humanized" to the long date. It's in yyyy-dd-mm.
by bbhank
Fri Apr 01, 2016 4:58 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Remove Carriage Returns
Replies: 51
Views: 6649

Re: Remove Carriage Returns

Looks like you did not really understand your problem so far, please read up my long answer again. I DO UNDERSTAND!! You all keep telling me how to change the query and I'm asking how to change the data in one of the fields returned from the query. The original question specifically asked about the...
by bbhank
Fri Apr 01, 2016 3:44 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Remove Carriage Returns
Replies: 51
Views: 6649

Re: Remove Carriage Returns

REPLACE(event_desc, char(13) + char(10), '---') This is posted as a way to remove these characters in several different SQL forums and is said to consistently work. There were a lot of forums using this who say it works. Tried to get this to work in LiveCode. The "apply" button says there are no er...
by bbhank
Fri Apr 01, 2016 2:28 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Remove Carriage Returns
Replies: 51
Views: 6649

Re: Remove Carriage Returns

Seems like this should work: put pDataArray["label 11"] into dText replace CRLF with "---" in dText set the text of field "Description" of me to dText It doesn't. Here's possibly, why. LiveCode can't see the line feed and carriage return characters in the field - Only in the record itself. If these ...
by bbhank
Fri Apr 01, 2016 1:45 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Remove Carriage Returns
Replies: 51
Views: 6649

Re: Remove Carriage Returns

Yes, I understand how fields are delimited. The data coming from the database is fine except for the Description field. This is the only field that needs changing.
by bbhank
Fri Apr 01, 2016 11:11 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Remove Carriage Returns
Replies: 51
Views: 6649

Re: Remove Carriage Returns

I think so. IF I'm understanding you correctly, looks like we're taking the returns out of the whole query results, then splitting that up. It's the Description field only I'm asking about. Taking them out of tData wrecks everything. The problem only happens when the Description field is loaded. rep...
by bbhank
Thu Mar 31, 2016 10:43 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Remove Carriage Returns
Replies: 51
Views: 6649

Re: Remove Carriage Returns

Here ya go: on FillInData pDataArray set the text of field "City" of me to pDataArray["label 1"] set the text of field "State" of me to pDataArray["label 2"] convert pDataArray["label 3"] to long date set the text of field "Begins" of me to pDataArray["label 3"] set the text of field "Title" of me t...
by bbhank
Thu Mar 31, 2016 9:36 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Remove Carriage Returns
Replies: 51
Views: 6649

Re: Remove Carriage Returns

Please excuse delay. Had to run out. And thank you all. I've been trying both in the query, as per stuff I found outside LiveCode, and from the Row Behavior - set the text of field "Description" of me to pDataArray["label 11"] . I only updated the database to see if that was the issue. If I change r...
by bbhank
Thu Mar 31, 2016 7:47 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Remove Carriage Returns
Replies: 51
Views: 6649

Re: Remove Carriage Returns

Yes. Here: put revDataFromQuery(tab, cr, gConnectionID, tSQL) into tData in the query part.
:?
by bbhank
Thu Mar 31, 2016 7:43 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Put the long date into field
Replies: 10
Views: 1212

Re: Put the long date into field

That put today's date in every field. Solved part of the issue.
I am trying to change the date format in the field from year, day, the date format for MySQL, to the long date.
I didn't make that clear. :? Terminology.
by bbhank
Thu Mar 31, 2016 7:19 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Remove Carriage Returns
Replies: 51
Views: 6649

Re: Remove Carriage Returns

set the text of field "Description" of me to pDataArray["label 11"]

is used to populate the Description field in the Row Behavior. The event_description is the 11th item in the array.

Hope that helps some.
by bbhank
Thu Mar 31, 2016 7:16 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Remove Carriage Returns
Replies: 51
Views: 6649

Re: Remove Carriage Returns

OK, that is the SQL command. What about the LC command you are using the SQL in?

The one posted was it. The SQL and LC are all together.

Go to advanced search