Script for finding duplicate accounts and identifying dups

to be able to identify the user accounts that are exact duplicates but then differentiate them by their unique 6 digit ID. So essentially, create a new list of just the duplicates and ids, i.e. ggarcia, 121212 ggarcia, 131313 Thanks in advance for any ideas! Jo

Re: Script for finding duplicate accounts and identifying dups

d then, why not sort the list, and in a >> "repeat with..." loop check each line with the line following. If they >> match, extract the two indexes. This should take only six lines of code. >> >> >> Craig Newman >> >> >> >>

ArrowKey Handler in LiveCode 8?

Hi All, I was going to use the arrow keys to move an object, something like what Devin wrote up a while ago: on arrowKey pWhich # determine some way to designate which object is to be nudged put the long id of btn "test" into tSelObj # for example switch pWhich case "left" put -1

Infinite LiveCode, APIs and the Google Sheets API?

you may have! John Patten SUSD ___ 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: Infinite LiveCode, APIs and the Google Sheets API?

Thanks Mike… I’m going to go take a look right now :) Cheers! John Patten SUSD > On May 19, 2016, at 11:37 AM, Mike Kerner wrote: > > look at MergGoogle. It's a widget that we paid Monte to write so we could > have all sorts of fun with Google Sheets, and might I say, we ha

Using the MergGoogle with Google Sheets

Hi all! I have the MergGoogle extension and sample stack. I am attempting to get the sample stack included with mergGoogle working. I have gone to Google and created a OAuth 2.0 client ID and client secret. I have exchanged the existing client ID and added my client secret the “on authorize”

Re: Using the MergGoogle with Google Sheets

t;> On 20 May 2016, at 8:17 AM, JOHN PATTEN wrote: >> >> mergGoogelAuth > > ___ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription >

Re: Using the MergGoogle with Google Sheets

putting the “client secret” in quotes like the rest of the mergeGoogleAuth script. And, I am using LiveCode 8.0, Build 13018 on a Mac running OS X 10.11.3. Thank you! John Patten SUSD > On May 19, 2016, at 4:22 PM, Monte Goulding wrote: > > >> On 20 May 2016, at 9:19 AM,

Re: Using the MergGoogle with Google Sheets

, May 20, 2016 at 10:58 AM, JOHN PATTEN wrote: > >> Hi All, >> >> I’m still not getting this to work. I thought maybe it was because I was >> trying to talk to Google through our Google Apps For Education (Enterprise) >> edition at school. I tried with my regul

Re: Using the MergGoogle with Google Sheets

Hi Mike, Oh, Should mention there is no “login” request either. It just shows the “answer” dialogue when the demo app is launched. Thank you! > On May 20, 2016, at 8:49 AM, JOHN PATTEN wrote: > > When I launch the example mergGoogle stack this is what it does: > > https://f

Re: Using the MergGoogle with Google Sheets

folder identified in the Preferences. There must be something else that is not quite right now with published extension, or a change at Google. However, that doesn’t explain why Mike’s is still working. Thank you! John Patten SUSD > On May 20, 2016, at 10:44 AM, Mike Kerner wrote: > >

Re: Using the MergGoogle with Google Sheets

. Thanks! John Patten SUSD > On May 20, 2016, at 11:06 AM, Mike Kerner wrote: > > I just tried 6.7.8 mac with merggoogle 1.0.12 test stack, and it works > fine. if I go up to 7.1.4 Stable or 8.0.1 rc1 I get the answer dialogs of > death. > > Next question: Did you ever ban LC f

Re: Using the MergGoogle with Google Sheets

I submitted a bug report, Bug 17706 <http://quality.livecode.com/show_bug.cgi?id=17706> Thank you! John Patten SUSD > On May 20, 2016, at 2:28 PM, Monte Goulding wrote:. > > >> On 21 May 2016, at 5:53 AM, Roger Eller wrote: >> >> That's so weird

Re: Using the MergGoogle with Google Sheets

Hi Mike, Depends on what issue you are referring to :) ... I filed a bug report and it appears to be making its way through the process. Thank you! John Patten SUSD Sent from my iPad > On May 25, 2016, at 7:20 AM, Mike Kerner wrote: > > Did you guys get your issue figured out? >

MergeMK at getting Lat and Log on drop of marker?

Hi All, For those of you that have used MergeMk (Google Maps) extension in Livecode, is is possible to get the latitude, longitude of a user’s click on the map? Or, if they drop a marker at a specific location, is it possible to get the latitude and longitude of the marker? Thank you! John

Inconsistent results in simple script

le into cd fld "Upload File" unlock screen end mouseUp Any suggestions would be helpful. Thank you! John Patten SUSD ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage y

Re: Inconsistent results in simple script

of student username and device serial number. I hope that is a little clearer. Thank you! John Patten SUSD > On Nov 16, 2016, at 12:22 PM, dunbarx wrote: > > HI. > > So, a single list. What is the relationship between the fact that a > particular barcode refers both

Re: Inconsistent results in simple script

hoping not to have to weed them out of my lists so that the two lists lined up. Can I use an array and still search be barcode prior to doing the username and serial number? /..Yes Craig, old HyperCard habits are hard to break, at least for me :) …/ Thank you! John Patten SUSD > On Nov 16, 2

Re: Inconsistent results in simple script

ng a find this barcode, but in an array construct? When you don’t use arrays very much, and you have old, slow, brute force scripting skills, arrays are kind of hard to wrap your head around. But I obviously see their advantages :) Thank you! > On Nov 16, 2016, at 1:08 PM, JOHN PATTEN wrot

Colin's Book on Mobile Development - Webscraper Question?

card do not appear. It looks like only a grayish rectangle of the size of the image appears. Anybody know why this might be the case? Thank you! John Patten ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe

Re: Colin's Book on Mobile Development - Webscraper Question?

Stepped away for a while, came back, and tried a: put url pMediaFile into omg “MediaImage” instead of: set the filename of image the number of images to “mediaImage” The put url pMediaFile … worked. :) > On Nov 8, 2014, at 4:05 PM, JOHN PATTEN wrote: > > Hi All, > >

revBrowserOpenCef & revBrowserClose not working

browser again, it thinks the browser is closed, though it appears to be still on the screen. This completely locks Livecode up. You can move windows around, but not other events are triggered. I had to Force Quite out of LiveCode. It doesn’t seem like it should work

"Print link" in PDF using Images?

put it into tRect get the tImageBtnLink of cd fld ("video" & x ) of cd 5 put it into tURL Answer "Print link to url" && tURL && "with rect" && tRect print link to url tURL with rect tRect Thank you! John Patten SUSD

DataGrid Event for change of line highlighted?

HI All, Is there a built in datagrid event that occurs when the user arrows down in a datagrid list and the row is highlighted? on dataGrid-lineHighlighted do something end dataGrid-lineHighlighted Thank you! ___ use-livecode mailing list use

Record Audio in OS X and Windows

Hi All, Is the record audio feature currently broken in LiveCode (7.0.0)? When I do this: on mouseUp set the dontuseQt to false record sound file test.wav answer the result end mouseUp I get message “error 2 starting recording” Thank you! John Patten SUSD

Re: Record Audio in OS X and Windows

tFilename) end mouseUp Saves to your Google Drive and you could create a Google Site with the Google Folder embedded in the Google Site page. This makes your recordings available any play you have Internet access. Nice easy strategy for educators to save elementary school student reading sampl

Sending Google Script Commands via POST?

ting file, say for example, an audio recording, could be uploaded automatically to a specific Google Drive Folder? Any advice? Thank you! John Patten SUSD ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsu

Pasting into browser object web page?

text into a separate browser, separate application, say Firefox, it works. Is it not possible, or am I missing some setting on my browser object that needs to be set to allow pasting to the web page in a browser object? Thanks in Advance! John Patten SUSD

INSERT and SQLlite command"

"VALUES(" & return & \ "1:, 2:, 3:)" into tSQL --answer tSQL revExecuteSQL tDatabaseID, tSQL, "$id", "$technology", "$notes” Can anybody point out what I’m missing in the second version? Thank you! John Patten SUS

Re: INSERT and SQLlite command"

Gosh darn it! Nevermind… I had the colon in the wrong spots 1: and 2: instead of :1 and :2 etc…. Thanks anyways! > On Apr 23, 2015, at 9:26 AM, JOHN PATTEN wrote: > > Hi All, > > I have a very simple SQL Lite database consisting of three fields, an ID > (INTEGER PR

iOS Profile Problems..."Could not find a valid identity..."

Hi All, I have messed up my iOS profile settings in Standalone Builder. Two days ago I built a Enterprise iOS standalone app fine. Made some change to the app, and attempted to save out a new standalone version and i got a “could not find a valid identity to use for the selected profile” messa

Re: iOS Profile Problems..."Could not find a valid identity..." (SOLVED)

you! > On Apr 28, 2015, at 12:34 PM, JOHN PATTEN wrote: > > Hi All, > > I have messed up my iOS profile settings in Standalone Builder. > > Two days ago I built a Enterprise iOS standalone app fine. Made some change > to the app, and attempted to save out a new standa

Simple .lc Script to INSERT data...?

empty. I was having the same problem on a much more complex database and script, so I thought I would super simplify but I’m still having the problem. Does anybody see anything I’m missing? Thank you! John Patten SUSD ___ use-livecode m

Re: Simple .lc Script to INSERT data...?

ect_name=“ & > tName) into tResult > > Regards, > > Matthias > > > > >> Am 06.06.2015 um 00:31 schrieb JOHN PATTEN : >> >> Hi All, >> >> I must be missing something simple and I can’t find it… >> >> I have a mysql dat

Re: Simple .lc Script to INSERT data...?

ote: > > You're putting your data to post into ArgList > And you're posting tArgList > > If thats not a typo here, I suspect its the typo culprit there. > > On Fri, Jun 5, 2015 at 5:01 PM, JOHN PATTEN wrote: > >> Thanks Matthias, >> >> I did

Save Image to mySQL and Retrieve Image?

" to tImage RevCloseCursor tRecordSet revCloseDatabase tConID The image turns into a gray fill? No image. I seem to remember this happening in the past but can’t remember the solution? Thank you! John Patten SUSD ___ 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: Save Image to mySQL and Retrieve Image?

t the BLOB data manually using phpMyAdmin (download) and manipulate the data directly in LiveCode? Thanks for the advice! John Patten SUSD > On Jun 8, 2015, at 3:44 PM, Peter Haworth wrote: > > Hi John, > > Couple of things. > > In your call to revExecuteSQL, I think the

Re: Business Application Framework

imary job is K8 education and technology.) A hands on tutorial, where we are using the system collaboratively, on a "Hello World" project might be a good start. For students today, interested in programming and engineering, exposure to this type of system sounds like a primary skill

Browser Widget and loading local files?

tried different flavors of this in the browser widget with no success. Thanks in advance! John Patten SUSD ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription prefer

Re: Browser Widget and loading local files?

Thanks Monte! That was it :) > On Nov 3, 2015, at 9:07 PM, Monte Goulding wrote: > > & specialFolderpath("documents") & "/PanoWeaverFinal/pano3/_html5/pano3.html” ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to s

Reporting the number of duplicates in a list of numbers?

, and this is probably pretty basic, but I can’t remember coding a solution to something like this in the past. Thank you! John Patten SUSD ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage

Re: Reporting the number of duplicates in a list of numbers?

Thanks Kay! That’s what I needed. I knew it was pretty simple, but my unfamiliarity with arrays prevented me from seeing the solution. Cheers! John Patten SUSD On May 4, 2014, at 8:14 PM, Kay C Lan wrote: > This might get you started, in the msg box: > > put "3,5,6,6,24,24

Mysql UNIQUE and .lc server scripts?

to the fact that the filed is not unique, but it also does not give the user any clue of this fact. Thank you! John Patten ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your

Re: Mysql UNIQUE and .lc server scripts?

how to send the result back to my app in order to act on it? After the revExecuteSQL, would it just be, Put the result or …? Then, on the stack that sent the original data, at the end of the sending script “answer it, or answer the result? Thank you! John patten SUSD On May 8, 2014, at 5:21

Re: Can You Really Install an iOS App outside of Apple's App Store?

Hello! Only other option is to purchase an Apple Enterprise License. Then you can distribute apps within your organization , but not to general public. For example, a school district might purchase an enterprise license to distribute home grown apps to their staff. Cheers! John Patten SUSD

Returning data back from LC server script to the stack?

ere is a way for LC server to send data back to the stack as opposed to creating a web page and displaying it in a browser? Thank you! John Patten SUSD ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, uns

Livecode Server and Repeat Scripts on Server

the script continues on? Thank you! John Patten SUSD ___ 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

Re: Livecode Server and Repeat Scripts on Server

Patten” is on the third line of my csv text file, the resulting “put” will look like the following: John Patten, password, jpat...@bmail.com, Button 1 John Patten, password, jpat...@bmail.com, Button 1 John Patten, password, jpat...@bmail.com, Button 1 Sorry, username ( John Patten) has already

Re: Livecode Server and Repeat Scripts on Server

ld to create an account. In this case John Patten is the first user name listed in my CSV text file and when I enter it to create a new account, it tells me it is already being used. However if I put in the second, third, etc. username, it will not give me the correct message and drops down bel

Re: Livecode Server and Repeat Scripts on Server

Ok, FWIW, this appears to work: Thanks for the prodding Peter :) John Patten SUSD On Jul 31, 2014, at 6:50 PM, JOHN PATTEN wrote: > If I uncomment the repeat, the “Sorry, username already in use…" message does > not get triggered. It just activates the script followin

Missing digits when replacing single digit item with two digit item?

the bottom of this message. Thank you! John Patten SUSD ___ 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

Re: Missing digits when replacing single digit item with two digit item?

Here’s the server script: On Aug 3, 2014, at 7:32 PM, JOHN PATTEN wrote: > Hello! > > I have 15 buttons on a card. They are each named Button 1, Button 2, Button > 3, etc. I have another button that I am using as a game piece. It moves > around the digital game board to the

Re: Missing digits when replacing single digit item with two digit item?

ot;username=" & tUsername &"&ButtonSpot=" & tButtonSpot into tArgList post tArgList to URL "http://jpatten.on-rev.com/superdupergame/moveplayer.lc"; put it --into tData end if end mouseUp On Aug 3, 2014, at 7:32 PM, JOHN PATTEN wrote: > Hello! &g

Wrestling with LC Server and wacky results...?

en I add my changed line as a new line at the bottom of the variable the new line at bottom has the correct two digit button label. So if the player was Luna, and she had just moved to spot “Button 13,” the resulting text file looks like this after the server script runs: John Patten,secre

Sending Terminal Command (Python) Using LiveCode?

? …in need of an example :) Thank you! John Patten SUSD ___ 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

Re: Sending Terminal Command (Python) Using LiveCode?

Awesome! I’m trying to get this working but I think I’m having a problem with providing the path to the Python App. I keep getting the error: python: can’t open file ‘Macintosh HD/Users/jpatten/gam’:[Errno 2] No Such file or directory. Here’s what I have in my button script: on mouseUp put c

Tab Panel Highlights Not Appearing Correctly?

Hi All, I think i must be using the Tab Panel object incorrectly. The tabs do not highlight correctly when clicked on. Tab Panel consists of: “Info, Create Account, Preferences, Minimize,” four panels. Here’s the script I have in my Tab Panel object: on mouseUp get the selectedText of me i

MergMicrophone And Exporting .caf files?

how I’d go about that though…? Any ideas are welcome... Thanks in Advance! John Patten SUSD ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http

Snapping To A Grid of TopLefts?

Hi All, I’m trying to figure out a way to have objects snap to a grid on the mouseUp. I have a list of TopLeft coordinates. 500,50 500,125 500,200 500,275 400,50 400,125 … I want the object to snap to the closest topLeft coordinate in the list upon a mouseUp. I was tried subtracting current x

Re: Snapping To A Grid of TopLefts?

Thanks Martin and Ali, I figured I was making it more difficult than it needed to be :) I’ll give those a try. Thanks again! John Patten SUSD On Oct 19, 2014, at 11:21 AM, Martin Koob wrote: > This will snap to a 100 X 75 grid anywhere on the card. It does not restrict > the boun

Extended ASCII Characters Showing Up Where Not Wanted...

variable to a text editor and showing invisibles. Is this a bug? Thanks for any advice! John Patten SUSD ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription

Re: Extended ASCII Characters Showing Up Where Not Wanted...

Never mind…. I just downloaded LiveCode 7 and reopened project. The upside down questions marks are gone now. Coincidence, the weather, spirits…? :) Thank you! On Oct 23, 2014, at 2:50 PM, JOHN PATTEN wrote: > Hi All… > > I have a list of names in a field. > > John Doe &g

Animation Via Repeated Loop calls?

rrupt the loop don't quite cut it as the trigger doesn't get implemented until after the command. What would be the proper way to interrupt a repeat? Anybody of some simple examples of animating objects via loops? Thank you! John Patten SUSD __

Web Plugin Question?

setting its script? Thank you! John Patten SUSD ___ 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

Question about "Send in" command for animation?

can facilitate moving multiple items on the screen smoothly? I have an example of what I'm describing here: http://jpatten.on-rev.com/arcade/ Thank you! John Patten SUSD ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit t

Text Exchange Functionality (like chat) Question?

t sure how that might complicate matters...? Thanks for any ideas in advance! John Patten SUSD ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription prefere

Why No Built in GetMyIP call in LiveCode?

sktop machine, as opposed to a laptop on wireless. It just seems like it would be nice to have a built in function for reporting local machine's IP... Such as, "put localIP of current stack into tIP" or "get LocalIP of current stack." Is this available in the

Re: Why No Built in GetMyIP call in LiveCode?

the shell script. Thank you! John Patten SUSD On Jun 10, 2011, at 10:41 AM, Devin Asay wrote: John, Look at the hostName and hostNameToAddress functions put the hostNameToAddress of the hostName into fld "info" HTH Devin On Jun 10, 2011, at 11:05 AM, John Patten wrote: Hi All..

Re: Why No Built in GetMyIP call in LiveCode?

Actually Chris I wanted the local network, behind the firewall IP address. The project I have in mind is just using sockets in a single classroom. All computers have 10.x.x.x. addresses. Thanks! John Patten SUSD On Jun 10, 2011, at 11:15 AM, Nonsanity wrote: Neither of the solutions

Re: Why No Built in GetMyIP call in LiveCode?

I settled on Mark's shell script process to get IP address. I managed to kludge together a case for Linux (Ubuntu Netbook) too. I did not quite understand the matchtext line with its (?s) and (.*?)'s but the Mac OSX case and Linux case almost worked without any changes. The Linux shell is s

Re: Why No Built in GetMyIP call in LiveCode?

Good thing I read this explanation of regex Saturday morning ;-) ... I think? Seems like matchtext/regex would be useful for HTML scraping strategies too. Thanks for the explanation Jim! John Patten SUSD Sent from my iPad On Jun 10, 2011, at 9:20 PM, Jim Ault wrote: > > On Jun 10, 20

Re: Wondering about LC and HTML5

Hi All... FWIW, Nice site with some folks developing specific tools and API for html5 here: http://popcornjs.org/ Might be useful for someone trying to develop RevTool ;-) John Patten SUSD On Jun 21, 2011, at 2:23 PM, Richard Gaskin wrote: Michael Kann wrote: > I would like to

Re: Wondering about LC and HTML5

file type to HTML5. Cheers! John Patten SUSD On Jun 21, 2011, at 4:08 PM, John Patten wrote: Hi All... FWIW, Nice site with some folks developing specific tools and API for html5 here: http://popcornjs.org/ Might be useful for someone trying to develop RevTool ;-) John Patten SUSD On

Snapshot command and non-rect polygon selections?

works with four coordinates, the points of a rect... or can they work with any group of points on a polygon? Thanks in advance! John Patten SUSD ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe

Re: Snapshot command and non-rect polygon selections?

Hi Andre... The issue is the "L" shape is inside a larger image. So essentially I only want a part of the image and the part I want is in the shape of the letter L. Thanks! John Patten SUSD On Jun 29, 2011, at 12:24 PM, Andre Garzia wrote: John export snapshot from graphic &

LiveCode mySQL calls and iOs?

S (in LiveCode)? If the answer is yes, how would I go about doing that in the best way? Thank you! John Patten SUSD ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscri

Re: LiveCode mySQL calls and iOs?

er = mysql_numrows($result); > > // Print the songs for return to LC > for ($i=0; $i<$number; $i++) { > $songtitle = mysql_result($result,$i,"songtitle"); > $filesize = mysql_result($result,$i, "filesize"); > $desc = mysql_result($result,$i, "

Set image/data/source via an image on web?

geData put tImageData into last image ... It appears to create the correct target file "http://webserver.on-rev.com/conference/images/11.jpg"; Anybody have a tip on how to go about doing this? Thank you! John Patten SUSD ___ use-livecode

Viewing Large Images Using Groups and Adding Buttons to the Map Group?

me). In order to do what I want to do, is it only possible by assigning the buttons to the map group (?) and then using the scroll bars of the group to navigate the map? Would that work inside iOS and Android (that = group scroll bars) too? Thank you! John Patten SUSD ___

Floating City and K12 Game Theory Model...

ttempting to do here if interested: http://edutonica.blogspot.com/ Thanks everyone! John Patten SUSD ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences

Accessing mySQL DB from stack utilizing revserver/irev/on-rev?

ck, and then put the data back into the database. Is there and example of this available? Thank you! John Patten SUSD ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your su

iRev mySQL and a Revdberr?

x27;" & txcoord & "', ycoord='" & tycoord & "' WHERE id='" & tTargetID & "'" into tSQL Anything jump out a miss? Wondering why it would be a successful query either creating a new record or updating and existing record but still return an error??? Thank you! John Patten SUSD ___ 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: iRev mySQL and a Revdberr?

Ah! Thanks Dave! They are. I'll make the change and see if that helps. John Patten SUSD Sent from my iPad On Jul 29, 2011, at 5:40 PM, Dave Cragg wrote: > > On 30 Jul 2011, at 00:28, John Patten wrote: > >> Hi All! >> >> I have a basic insert mysql quer

re: iREv mysql and revexecuteSQL problem?

tp://myaccount.on-rev.com/conference/offertrade.irev " put it into tData if tData is a number then answer info "New record added." else answer error "There was a problem updating the record to the database:" & cr & tData end if end mouseUp John Patten

On-rev and irev file problem?

typos over and over but don't see anything. Here is what I have in its most basic form: I'm at the point now I'm just trying to see what the connection contents is in tResult, and it still throws up the server error??? Any advice? Tha

Re: On-rev and irev file problem?

would be relevant if I'm using the MySQl on the on-rev server too? Thank you! John Patten SUSD On Sep 30, 2011, at 11:22 AM, stephen barncard wrote: > Also check your MySQL account for any IP or cross-domain restrictions. > > On 30 September 2011 11:20, stephen barncard

Re: On-rev and irev file problem?

to return mymessage it spits out: file"/home//public_html/norms/enternormdata.lc@quot; Would that be what is expected? (As opposed to the URL formatted text submitted by the actual stack.) Thank you! John Patten SUSD On Sep 30, 2011, at 11:43 AM, John Patten wrote: > Hi Stephen... &g

Re: On-rev and irev file problem?

Found it! I left a "&" inside my quotes here: ¬ >>>>> --put "INSERT INTO norms " & "(" & tFields & ") & VALUES (:1, :2, :3, :4)" Thanks! John Patten SUSD On Sep 30, 2011, at 12:0

On-Rev: irev to mysql to html charset (apostrophes, etc.) confusion?

anging the charset only results in different characters. It's almost as if I have not found the correct charset? But yet, if my LC project pulls the content from the DB everything appears as it should??? Thanks for any tips! John Patten SUSD _

Standalones and Opening stack via go url...?

en it runs from the standalone the second stack never opens the stack stored on the server. It also appears to save itself (Main App) as opposed to the stack I'm attempting to open??? Is what I'm attempting not possible in this fashion? (standalone --> stack --> go url "

Re: Standalones and Opening stack via go url...?

not getting it. Seems from now on it's best to guess which inclusions are needed and select those manually if you have a project working in the IDE but not as a standalone? Is this a common issue? Thanks! John Patten SUSD On Oct 12, 2011, at 3:26 PM, John Patten wrote: > Hi All! &g

SqLite to MySQL and back or ?

"MainData" into tTable1 copy tTable1 to (new or update) table on remote mysql database "Maindata"" ;-) end mouseUp Thank you! John Patten SUSD ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url

Question regarding K12 Education pricing...

program for finically struggling schools, still valid? Thank you! John Patten SUSD ___ 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

Export and Import SQLite data from LC Project?

e LC application and import into that app's SQLite database. Is there some SQLite statement that creates a query that I then can have LC save out as a file, and then do the reverse, and import it and run the query on the second machine? Thank you! John P

Re: [OT] Interesting Read On Tech In Classrooms vs None

t…which in my opinion is a good thing, conversation, discussion, awareness, appreciation, opposition, etc. etc. Cheers! John Patten SUSD On Oct 24, 2011, at 11:58 PM, Scott Morrow wrote: > Thanks for the link. I'm always surprised the media doesn't talk this up &g

On CloseField and textStyle/textColor changes?

seField handler work and update the record. Any advice? Thank you! John Patten SUSD ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://list

iOS and Go Stack URL?

Hello All! Is it possible to open a remote stack in iOS via Go Stack URL …? I'm thinking no…but I thought I'd ask :-) Thank you! John Patten SUSD ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to

Re: So Who Has Tried the Kindle Fire Yet (with LiveCode building)?

Hi All… Just for clarification… Colin you were able to create a LiveCode app, save it as a standalone for Android. Then upoad the newly created app to a web site, and from the KindleFire access the web site and download and install the app onto your KindleFire? Thanks! John Patten SUSD

Re: What about Apple's new ebook app and text book efforts?

Who needs it if you have LiveCode? You would not need to be tied to Apple ULA in terms of their iAuthor format, etc. Or, am I missing something? What would be great is if LiveCode of a LiveCode developer turned around and created templates for the newbie LiveCoders to publish their eTextBooks

Combining some lines of text in a list?

put tFormattedData end mouseUp But I'm thinking there must be an easier way? Any suggestions? Thank you! John Patten SUSD ___ 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

  1   2   3   >