passing binary data to MySQL BLOB field

" prepended before the open quote, etc. In each case, MySQL still gags on the binary data. Help! While this may sound like a misplaced MySQL syntax question, it's not. What I'm missing is how to properly prepend "*b" so LC sends the variable as binary data. ??? Thanks

vexing MySQL query problem

e null should be inserted into the auto-incrementing fields. Hence I've tried the following query. do "revExecuteSQL headlinesDB," & quote & "INSERT INTO RelevantTable VALUES (null, '" & thisURL & "', null, '" & thisText & "&

Re: clickability in a DataGrid

x27;m just trying to duplicate the functionality, so I don't want the user to have to edit rows in the datagrid, but rather select a row to edit, and then the editing will take place on a different card set up to mimic fields and buttons in the old admin tool. Now I'm on the right trac

Re: clickability in a DataGrid

Thanks, Peter. This script works. Thank you and apologies for my earlier confusion. Sieg Lindstrom On Jan 22, 2013, at 7:21 PM, Peter Haworth wrote: > Hi Craig, > I tried your mouseUp Script and all I got was a reference to graphic > "dgalternatingrows" no matter which row o

Re: clickability in a DataGrid

Alas, I spoke too soon. The output on this handler correctly identifies the column by column name but the four digit integer that follows does not correspond to the row number. Sieg Lindstrom On Jan 22, 2013, at 7:21 PM, use-livecode-requ...@lists.runrev.com wrote: > Hi. > > >

Re: clickability in a DataGrid

Minor sidebar question, which isn't remotely relevant for the stack in question: Does this mean DataGrids are limited to rows? Sieg Lindstrom On Jan 22, 2013, at 7:21 PM, Craig Newman wrote: > Hi. > > > There are a few ways to do this. The old fashioned way is to write in

clickability in a DataGrid

tab-delimited data in each row, I'd use the ClickText and the ClickLine in the field script to determine what the user clicked and trigger the appropriate actions. How would one achieve this in a DataGrid? Thanks in advance! Sieg Lindstrom ___ us

Re: MySQL standalone issues

gConnectionID answer info "Connected to the database." & cr & "Connection ID = " & gConnectionID else put empty into gConnectionID answer error "Unable to connect to the database:" & cr & tResult end if end mouseUp Thanks,

Re: MySQL standalone issues

x27;t have .txt extensions. Now wondering if that is the root of the problem, even though this app has worked in the IDE for 7 years. Sieg Lindstrom On Mar 20, 2012, at 1:20 PM, Pete wrote: > Hi Sieg, > I don't know of such an article but people on this list can probably help &g

MySQL standalone issues

, from which they return a variety of error messages depending on the specific query involved. Thanks in advance, Sieg Lindstrom ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your

Re: "can't find handler" error in script that worked before

there were other put commands in the script in which a semi-colon led a literal, and they compiled OK. 2) Eventually, simply retyping the lines solved the problem. Sieg Lindstrom On Mar 3, 2012, at 9:29 PM, Kay C Lan wrote: > Is this in a standalone or a stack you are running in the IDE.

"can't find handler" error in script that worked before

"unfindable" handler into the button script, but shouldn't a button be able to call a handler in the stack script? It worked before, hasn't been modified and all variables are properly made global. Thanks. Sieg Lindstrom __

en- & em-dash paste from Word (followup)

n an ever-more complicated trail of unintended consequences in multiple handlers, and misparsed data. This copy and paste worked fine in RunRev. Thank you. Sieg Lindstrom ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url t

Re: characters lost pasting from Word To LiveCode field

Might work. Any idea if WordLib handles OSX Word 2004? I'm using that version until I'm forced not to because I have use scores of Word macros I'd have to recreate with AppleScript if I were to upgrade. Can't quite fathom why Microsoft decided to make macros in Word for the Mac incompatible with Wi

RE: characters lost pasting from Word To LiveCode field

Thanks Bob & Mark. Bob's fix sounds like the ticket. As to whether I'd blame Microsoft or RunRev, my first inclination is to blame Microsoft. However, this is the third time I've had to retool for different handling of characters like the em dash over several updates of RunRev/LiveCode, always past

Re: use-livecode Digest, Vol 99, Issue 23

Thanks Bob & Mark. Bob's fix sounds like the ticket. As to whether I'd blame Microsoft or RunRev, my first inclination is to blame Microsoft. However, this is the third time I've had to retool for different handling of characters like the em dash over several updates of RunRev/LiveCode, always past

characters lost pasting from Word To LiveCode field

I use a LiveCode app (OSX) to parse text taken from Word files, glean relevant data, write records to a database and also reformat the original text in certain ways. I copy and paste text from Word into a field in my app, click a button and it does the rest, until I upgraded to 5.0x. I'll say up f

Re: connecting to MySQL database thru SSH tunnel

Thanks, Bob. I have to confess that I'm not well educated in networking. I'm a regular guy who uses livecode to facilitate tasks I perform at work. Here's a wikipedia article (yeah, know its limitations as a reference source) that includes an explanation of SSH tunneling. http://en.wikipedia.org/

connecting to MySQL database thru SSH tunnel

I have an app for managing data in a MySQL database on a remote server. It¹s worked fine for years but now I would like to route the connection thru an SSH tunnel. It uses a port number other than 3306 (PortNumberHere in the function example below). So I¹ve changed the relevant function from this..