Search found 116 matches

by bbhank
Thu Mar 31, 2016 6:59 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Remove Carriage Returns
Replies: 51
Views: 6638

Re: Remove Carriage Returns

Your last question asked was the DataGrid a form? I've answered it twice. It is a form.
by bbhank
Thu Mar 31, 2016 6:39 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Remove Carriage Returns
Replies: 51
Views: 6638

Re: Remove Carriage Returns

When I took out the linefeeds and carriage returns in Word and pasted that back into the original field in the database, it became "normal" when displayed in LiveCode.
by bbhank
Thu Mar 31, 2016 6:36 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Remove Carriage Returns
Replies: 51
Views: 6638

Re: Remove Carriage Returns

DataGrid is form.
by bbhank
Thu Mar 31, 2016 6:29 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Remove Carriage Returns
Replies: 51
Views: 6638

Re: Remove Carriage Returns

put "SELECT event_state, other_field1, other_field2, other_field3, event_desc FROM wp_my_database WHERE event_state='"& gState &"' ORDER BY event_begin ASC " into tSQL
The state - gState - comes from pull down menu.
DataGrid is form.
by bbhank
Thu Mar 31, 2016 5:39 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Remove Carriage Returns
Replies: 51
Views: 6638

Re: Remove Carriage Returns

This is all in one field. Checked using MS Word to see which caused the problem and found that both line feeds and returns, here, cause this. Also that the tried the methods above to remove them but that so far none have worked. How could this be achieved with a query if these are in one field only?...
by bbhank
Thu Mar 31, 2016 5:12 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Remove Carriage Returns
Replies: 51
Views: 6638

Re: Remove Carriage Returns

Tried these but still no go:

replace cr with " " in field "Description"
replace return with empty in fld "Description"

Used with and without "of me"

:(
by bbhank
Thu Mar 31, 2016 4:44 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Load Image From MySQL Database
Replies: 6
Views: 813

Re: Load Image From MySQL Database

OK. Thank you. That looks like it will work.

Let me get the image to load from the id tho.
by bbhank
Thu Mar 31, 2016 4:25 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Force wrap long word in field
Replies: 1
Views: 324

Re: Force wrap long word in field

Found it. If anybody's interested, it's here:
http://lessons.livecode.com/m/2592/l/12 ... -wrap-text.
It didn't work for me until this line was commented out:
put wordWrapped(myText,the length of line 1 of me) after me
:D
by bbhank
Thu Mar 31, 2016 3:28 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: How to apply Row and Column Templates to Datgagrid
Replies: 46
Views: 5337

Re: How to apply Row and Column Templates to Datgagrid

Deja vu. Since I first found LiveCode on the web, no more than a couple of months ago, there was something strangely familiar about it. When I found out what that was, a lot about using LiveCode became easier, and even possible for me: I was a Mac guy when they were young (Actually starting on the A...
by bbhank
Thu Mar 31, 2016 2:33 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Remove Carriage Returns
Replies: 51
Views: 6638

Re: Remove Carriage Returns

Found this: replaceText(stringToChange, matchExpression, replacementString) from Dictionary. then replaceText("Description","cr"," ") looks like it should work. Does not work. Not enough information. The field is Description. I want to either remove or change carriage returns so that they do not cau...
by bbhank
Thu Mar 31, 2016 1:41 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Put the long date into field
Replies: 10
Views: 1210

Re: Put the long date into field

EXCELLENT! Works.
Thank you. :D

Not being miserly. This was all the relative code. Trying to keep it simple.
Help appreciated.
by bbhank
Thu Mar 31, 2016 1:17 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Load Image From MySQL Database
Replies: 6
Views: 813

Re: Load Image From MySQL Database

I did. Plus went to the samples and tutorials without finding anything like this. Here's what needs to happen: An image in a DataGrid field needs to change according to the id of the listing. The data for the listing is taken from multiple tables in one database. The table that references the images...
by bbhank
Thu Mar 31, 2016 1:16 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Put the long date into field
Replies: 10
Views: 1210

Re: Put the long date into field

The rest of the code doesn't pertain to that.
Check this out:
set the text of field "Begins" of me to pDataArray["label 3"]
put the long date into field "Begins"
by bbhank
Thu Mar 31, 2016 1:13 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Remove Carriage Returns
Replies: 51
Views: 6638

Re: Remove Carriage Returns

This does go in the Row Behavior, right?
If so, it doesn't work.
Also tried in field script and changing fld to field in each.
Doesn't work there either.
Suggestions?

:(
by bbhank
Thu Mar 31, 2016 9:16 am
Forum: Getting Started with LiveCode - Complete Beginners
Topic: Load Image From MySQL Database
Replies: 6
Views: 813

Load Image From MySQL Database

Needing to load images into DataGrid from MySQL database as needed. I have written a query that gets the ID of the needed image. The required image is not in the table. The actual image is in a folder. The table only contains the names of the image and not their locations. The rest of the location n...

Go to advanced search