MySQL vs Postgres for revignitor
Hi folks, I'm just about to install a database behind revServer to start building out a web app and experimenting with revIgnitor. Are there any major LiveCode, revIgnitor or other usability or toolset issues I should be aware of before selecting Postgres over MySQL? Best, Keith.. ___ 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
Is it possible to adjust the border corner radius of a native rounded rectangle graphic?
Hi folks, The title says it all really. I can't find anything in the dictionary or via Google - can we break into this object's attributes somehow? Best, Keith.. ___ 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: Is it possible to adjust the border corner radius of a native rounded rectangle graphic?
Hi Keith, -- on mouseUp set the roundradius of grc 1 to 20 end mouseUp --- Look in the property inspector way down for the roundRadius or Corner Radius. Kind regards Bernd -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/Is-it-possible-to-adjust-the-border-corner-radius-of-a-native-rounded-rectangle-graphic-tp3381324p3381383.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ 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: Is it possible to adjust the border corner radius of a native rounded rectangle graphic?
Hi Bernd, Brilliant, thanks. Wow - I've never even noticed the border section on the basic properties tab before! I guess that's the problem of setting the preference for LiveTalk property names to force some learning - not all the property descriptions (such as 'corner') are in the Dictionary yet! ;-) Note to self: I need to work out why I can't log-in to add Dictionary notes myself (it may be a developer release thing - I'll wait for 4.6 GA) Best, Keith.. On 16 Mar 2011, at 11:00, BNig wrote: Hi Keith, -- on mouseUp set the roundradius of grc 1 to 20 end mouseUp --- Look in the property inspector way down for the roundRadius or Corner Radius. Kind regards Bernd -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/Is-it-possible-to-adjust-the-border-corner-radius-of-a-native-rounded-rectangle-graphic-tp3381324p3381383.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ 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 ___ 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
OT OS9 as a Virtual OS on a MacPro using OSX
Has anyone successfully installed a MacOS9 on an OSX machine as a virtual OS? I'm trying to resurrect some Classic documents and if that can be done it would make my job much easier. Or can I install Rosetta on my MacPro? Sure would be nice. Joe Lewis Wilkins Architect Director of Product Development for GSI www.glsysinc.com ___ 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: OT OS9 as a Virtual OS on a MacPro using OSX
Classic on Mac OS X 10.4 and earlier, SheepShaver on Mac OS X 10.5 and later. -- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software Engineering Homepage: http://economy-x-talk.com Twitter: http://twitter.com/xtalkprogrammer KvK: 50277553 New: Download the Installer Maker Plugin 1.6 for LiveCode here http://qery.us/ce On 16 mrt 2011, at 16:29, Joe Lewis Wilkins wrote: Has anyone successfully installed a MacOS9 on an OSX machine as a virtual OS? I'm trying to resurrect some Classic documents and if that can be done it would make my job much easier. Or can I install Rosetta on my MacPro? Sure would be nice. Joe Lewis Wilkins Architect Director of Product Development for GSI www.glsysinc.com ___ 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: OT OS9 as a Virtual OS on a MacPro using OSX
Hi Mark, I don't understand what you are saying and maybe I wasn't very clear with what I would like to do. I want to be able to run some Classic Mac programs on an OS X 10.6+ MacPro. I think you're saying that I can install SheepShaver and will be able to do that then? TIA, Joe Lewis Wilkins Architect Director of Product Development for GSI www.glsysinc.com On Mar 16, 2011, at 8:46 AM, Mark Schonewille wrote: Classic on Mac OS X 10.4 and earlier, SheepShaver on Mac OS X 10.5 and later. -- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software Engineering Homepage: http://economy-x-talk.com Twitter: http://twitter.com/xtalkprogrammer KvK: 50277553 New: Download the Installer Maker Plugin 1.6 for LiveCode here http://qery.us/ce On 16 mrt 2011, at 16:29, Joe Lewis Wilkins wrote: Has anyone successfully installed a MacOS9 on an OSX machine as a virtual OS? I'm trying to resurrect some Classic documents and if that can be done it would make my job much easier. Or can I install Rosetta on my MacPro? Sure would be nice. Joe Lewis Wilkins Architect Director of Product Development for GSI www.glsysinc.com ___ 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: OT OS9 as a Virtual OS on a MacPro using OSX
Joe, Yes, exactly. SheepShaver is a Mac PPC emulator. -- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software Engineering Homepage: http://economy-x-talk.com Twitter: http://twitter.com/xtalkprogrammer KvK: 50277553 New: Download the Installer Maker Plugin 1.6 for LiveCode here http://qery.us/ce On 16 mrt 2011, at 17:17, Joe Lewis Wilkins wrote: Hi Mark, I don't understand what you are saying and maybe I wasn't very clear with what I would like to do. I want to be able to run some Classic Mac programs on an OS X 10.6+ MacPro. I think you're saying that I can install SheepShaver and will be able to do that then? TIA, Joe Lewis Wilkins Architect Director of Product Development for GSI www.glsysinc.com ___ 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: Best practice for creating a resizable HUD-style widget stack background?
You can probably get away with drag-to-resize a round-cornered window by changing to a square-cornered window when they start to drag, perhaps a transparent one. The round-cornered graphics can still be visible and expanding live. When they let go of the drag, re-calculate the round-cornered mask from the now-resized graphics and re-apply. (Hmmm, there sure were a lot of dashed-words in there...) ~ Chris Innanen ~ Nonsanity On Wed, Mar 16, 2011 at 4:14 AM, Keith Clarke keith.cla...@clarkeandclarke.co.uk wrote: Hi Scott, Thanks for the response, comprehensive clarification and the link to the newsletter and hence, your demo stacks - all really useful stuff. I see now that managing these custom stack window shapes is (without wishing to sound critical of LiveCode) very similar to managing rounded rectangles in web pages for IE compatibility - i.e. the nine-image trick. As I don't need drag-to-resize, I reckon I can create a script-driven, rounded rectangle window shape that grows to fit its contents. If I keep the background colouring simple I reckon I can adapt a trick I've used on web pages into a script: 1. Import the 4 corner images but use LiveCode rectangles for the 5 rectangles that form the central cross; 2. Setting the HUD contents to a group and use the group's dimensions (plus margins) to set the size of the cross' component rectangles; Thanks again - oh, and item 8 in the newsletter http://runrev.com/newsletter/may/issue70/newsletter3.php has inspired me to have a go with adding a resizing preferences drawer, too! Best, Keith.. On 15 Mar 2011, at 21:51, Scott Rossi wrote: For a resizable custom window, you must create a mask image for every size/orientation of window that you'll need. But a window that a user can drag-to-resize is out of the question because you'd have to generate a mask image each step of the way during the drag and redraw the window repeatedly. ___ 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 ___ 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: OT OS9 as a Virtual OS on a MacPro using OSX
Thanks Mark. Joe Lewis Wilkins Architect Director of Product Development for GSI www.glsysinc.com On Mar 16, 2011, at 9:27 AM, Mark Schonewille wrote: Joe, Yes, exactly. SheepShaver is a Mac PPC emulator. -- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software Engineering Homepage: http://economy-x-talk.com Twitter: http://twitter.com/xtalkprogrammer KvK: 50277553 New: Download the Installer Maker Plugin 1.6 for LiveCode here http://qery.us/ce On 16 mrt 2011, at 17:17, Joe Lewis Wilkins wrote: Hi Mark, I don't understand what you are saying and maybe I wasn't very clear with what I would like to do. I want to be able to run some Classic Mac programs on an OS X 10.6+ MacPro. I think you're saying that I can install SheepShaver and will be able to do that then? ___ 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
SHOW TABLES
Someone was asking about the Show Tables command and not getting anything back from the query. I got this out of the mySQL manual: If you have no privileges for a base table or view, it does not show up in the output from SHOW TABLES or mysqlshow db_name. I cannot imagine that you don't have privileges to any of the tables, but it's something to check first. Bob ___ 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: Best practice for creating a resizable HUD-style widget stack background?
Thanks for the ideas Chris. I'm now convinced that for this particular HUD, the window shape size should not be too flexible but resize automatically, based on its contents. The user shouldn't have to worry about resizing the HUD - and this approach will also mitigate any risk of problems caused by users with 'fiddling fingers'! Best, Keith.. On 16 Mar 2011, at 16:29, Nonsanity wrote: You can probably get away with drag-to-resize a round-cornered window by changing to a square-cornered window when they start to drag, perhaps a transparent one. The round-cornered graphics can still be visible and expanding live. When they let go of the drag, re-calculate the round-cornered mask from the now-resized graphics and re-apply. (Hmmm, there sure were a lot of dashed-words in there...) ~ Chris Innanen ~ Nonsanity ___ 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
Sort of OT: mysql and select from two tables...?
Hi All... Thanks for the previous help on the on-rev php/mysql question. I have a question about the mysql select command, session_register, and selecting from two tables. I have one database with two tables. The tables are teacher_user and student_user. Each table has a unique teacher-id stored in a fields. So students with the teacher_id value of 0001 stored in their student_user record all belong to the same teacher. Teacher_tableStudent_table id - 0001 teacher_id = 0001 first first last last title grade I also have the teacher login with their username and password comparing what is stored in their db record for username and password. If they match, then their username and password is then session_register(username); session_register(password); . What i would like to be able to do is query the database and return a list of students to the individual teacher based on some unique information about the teacher's record, say their username. is there some way I can get at the session_register(username) and use it in my select query? Something like: select username from teacher_table and put id of table teacher_table into tTeacher_id then select tTeacher_id from student_table and loop through the student printing each record I suppose if the teacher new their id value I could just have them type that into a form and do a simple query the student_table and teacher_id field by that id value. But I was trying to make it a little more automatic and did not want teachers trying to guess other teachers' ids. 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://lists.runrev.com/mailman/listinfo/use-livecode
Re: Sort of OT: mysql and select from two tables...?
You can use SELECT session_user() to get the currently logged in user. It's a synonym for USER(). That help? Bob On Mar 16, 2011, at 12:15 PM, John Patten wrote: Hi All... Thanks for the previous help on the on-rev php/mysql question. I have a question about the mysql select command, session_register, and selecting from two tables. I have one database with two tables. The tables are teacher_user and student_user. Each table has a unique teacher-id stored in a fields. So students with the teacher_id value of 0001 stored in their student_user record all belong to the same teacher. Teacher_tableStudent_table id - 0001 teacher_id = 0001 first first last last title grade I also have the teacher login with their username and password comparing what is stored in their db record for username and password. If they match, then their username and password is then session_register(username); session_register(password); . What i would like to be able to do is query the database and return a list of students to the individual teacher based on some unique information about the teacher's record, say their username. is there some way I can get at the session_register(username) and use it in my select query? Something like: select username from teacher_table and put id of table teacher_table into tTeacher_id then select tTeacher_id from student_table and loop through the student printing each record I suppose if the teacher new their id value I could just have them type that into a form and do a simple query the student_table and teacher_id field by that id value. But I was trying to make it a little more automatic and did not want teachers trying to guess other teachers' ids. 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://lists.runrev.com/mailman/listinfo/use-livecode ___ 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: Sort of OT: mysql and select from two tables...?
hmmm... maybe SELECT current_user() Bob On Mar 16, 2011, at 12:15 PM, John Patten wrote: Hi All... Thanks for the previous help on the on-rev php/mysql question. I have a question about the mysql select command, session_register, and selecting from two tables. I have one database with two tables. The tables are teacher_user and student_user. Each table has a unique teacher-id stored in a fields. So students with the teacher_id value of 0001 stored in their student_user record all belong to the same teacher. Teacher_tableStudent_table id - 0001 teacher_id = 0001 first first last last title grade I also have the teacher login with their username and password comparing what is stored in their db record for username and password. If they match, then their username and password is then session_register(username); session_register(password); . What i would like to be able to do is query the database and return a list of students to the individual teacher based on some unique information about the teacher's record, say their username. is there some way I can get at the session_register(username) and use it in my select query? Something like: select username from teacher_table and put id of table teacher_table into tTeacher_id then select tTeacher_id from student_table and loop through the student printing each record I suppose if the teacher new their id value I could just have them type that into a form and do a simple query the student_table and teacher_id field by that id value. But I was trying to make it a little more automatic and did not want teachers trying to guess other teachers' ids. 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://lists.runrev.com/mailman/listinfo/use-livecode ___ 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: [ANN] RunRevPlanet Search
Hi Bob, Just wanted to point out that your web site has the same copy for RRP-Gradient Explorer.rev as it does for RRP-Grid-Share-Price-Demo.rev. Do you mean you found the links on the download page were to the same file? I checked and they appear correct, but perhaps I have misunderstood your comment. Thanks, Scott. - -- Scott McDonald Components, Controls, Tools and Resources for LiveCode www.runrevplanet.com -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/ANN-RunRevPlanet-Search-tp3353007p3383217.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ 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: Sort of OT: mysql and select from two tables...?
Hi Bob... session_user() appears to give me something other than the current logged in user. It returns: myaccount_nameofdatabase This is what I did to test it out: $result = mysql_query( SELECT session_user() FROM teacher_user ) or die(SELECT Error: .mysql_error()); $num_rows = mysql_num_rows($result); print There are $num_rows records.P; print table width=600 border=1\n; while ($get_info = mysql_fetch_row($result)){ print tr\n; foreach ($get_info as $field) print \ttd$field/td\n; print /tr\n; } print /table\n; I think even if I could return just the current user's profile (fields in their record) using the session_register command in mySQL I'd be making progress :-) Any other ideas? Thank you! John Patten SUSD On Mar 16, 2011, at 1:24 PM, Bob Sneidar wrote: You can use SELECT session_user() to get the currently logged in user. It's a synonym for USER(). That help? Bob On Mar 16, 2011, at 12:15 PM, John Patten wrote: Hi All... Thanks for the previous help on the on-rev php/mysql question. I have a question about the mysql select command, session_register, and selecting from two tables. I have one database with two tables. The tables are teacher_user and student_user. Each table has a unique teacher-id stored in a fields. So students with the teacher_id value of 0001 stored in their student_user record all belong to the same teacher. Teacher_tableStudent_table id - 0001 teacher_id = 0001 first first last last title grade I also have the teacher login with their username and password comparing what is stored in their db record for username and password. If they match, then their username and password is then session_register(username); session_register(password); . What i would like to be able to do is query the database and return a list of students to the individual teacher based on some unique information about the teacher's record, say their username. is there some way I can get at the session_register(username) and use it in my select query? Something like: select username from teacher_table and put id of table teacher_table into tTeacher_id then select tTeacher_id from student_table and loop through the student printing each record I suppose if the teacher new their id value I could just have them type that into a form and do a simple query the student_table and teacher_id field by that id value. But I was trying to make it a little more automatic and did not want teachers trying to guess other teachers' ids. 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://lists.runrev.com/mailman/listinfo/use-livecode ___ 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 ___ 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
SQL Gotchas
Hi kids. Just a little info. Seems that DEFAULT can be used with text types in sqLite, but NOT mySQL! biting tongue to refrain from ranting. Also sqLite allows a data length to be defined for DATETIME but mySQL does NOT! I am beginning to understand why a lot of software vendors will only support one engine. Because the SQL between different engines is neither STANDARD nor is it SIMPLE. Just saying. Does anyone know of any reference work done on the differences between engine syntaxes? I am trying to take the SQL for a table in sqLite and massage it to create the exact same table in mySQL. This is proving to be a snake pit, and I'd like to know what kind of snakes are in the pit before I jump in feet first. Bob ___ 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: Sort of OT: mysql and select from two tables...?
session_register is not a mySQL function, it is php. It is also deprecated, so it may or may not work depending on the version of php being used. I thought you were trying to get Livecode to tell you who the current logged in user was? current_user() or just user() works for me. Bob on mouseUp pMouseBtnNo put select current_user() into theSQL put dbconn_get(connection id, priconn, primary) into thePriID -- sqlYoga function try put revDataFromQuery(comma, return, thePriID, theSQL) into theSQLData -- RevDB function catch theError answer theError exit to top end try put theSQLData end mouseUp This returns my on-rev user login@the ip I am connecting from as in mydatabase_mylogin@69.227.63.5 (I made that up). Wouldn't that do it for you? Or are you using some kind of internal authentication and you are trying to get what the user typed into a form? Bob On Mar 16, 2011, at 4:10 PM, John Patten wrote: Hi Bob... session_user() appears to give me something other than the current logged in user. It returns: myaccount_nameofdatabase This is what I did to test it out: $result = mysql_query( SELECT session_user() FROM teacher_user ) or die(SELECT Error: .mysql_error()); $num_rows = mysql_num_rows($result); print There are $num_rows records.P; print table width=600 border=1\n; while ($get_info = mysql_fetch_row($result)){ print tr\n; foreach ($get_info as $field) print \ttd$field/td\n; print /tr\n; } print /table\n; I think even if I could return just the current user's profile (fields in their record) using the session_register command in mySQL I'd be making progress :-) Any other ideas? Thank you! John Patten SUSD On Mar 16, 2011, at 1:24 PM, Bob Sneidar wrote: You can use SELECT session_user() to get the currently logged in user. It's a synonym for USER(). That help? Bob On Mar 16, 2011, at 12:15 PM, John Patten wrote: Hi All... Thanks for the previous help on the on-rev php/mysql question. I have a question about the mysql select command, session_register, and selecting from two tables. I have one database with two tables. The tables are teacher_user and student_user. Each table has a unique teacher-id stored in a fields. So students with the teacher_id value of 0001 stored in their student_user record all belong to the same teacher. Teacher_tableStudent_table id - 0001 teacher_id = 0001 first first last last title grade I also have the teacher login with their username and password comparing what is stored in their db record for username and password. If they match, then their username and password is then session_register(username); session_register(password); . What i would like to be able to do is query the database and return a list of students to the individual teacher based on some unique information about the teacher's record, say their username. is there some way I can get at the session_register(username) and use it in my select query? Something like: select username from teacher_table and put id of table teacher_table into tTeacher_id then select tTeacher_id from student_table and loop through the student printing each record I suppose if the teacher new their id value I could just have them type that into a form and do a simple query the student_table and teacher_id field by that id value. But I was trying to make it a little more automatic and did not want teachers trying to guess other teachers' ids. 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://lists.runrev.com/mailman/listinfo/use-livecode ___ 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 ___ 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 ___ 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: Best practice for creating a resizable HUD-style widget stack background?
List, Sorry if this comes thru twice. JimL ScottR wrote: For round-rect windows, you need create the mask as nine separate objects, scaling top/sides appropriately, and generating the mask from that. I've done it, and as I mentioned, it works best when you have fixed sizes you expand or collapse to, not with a drag-to-resize behavior You can also generate a rounded appearance with just one object. 1 - create a rounded rectangle graphic with the corner radii you want, say 30. 2 - name it myMask 3 - make it opaque invisible 4 - set its rect to the card's rect 5 - set its geometry to scale with the window 6 - put this script in the card: command maskMe import snapshot from grc myMask set the windowshape of this stack to the id of last image delete last image end maskMe a window that a user can drag-to-resize is out of the question because you'd have to generate a mask image each step of the way during the drag and redraw the window repeatedly. True. If you are willing to subject your users to some non-standard funkiness you can set the windowshape to 0 while they liveresize then use the above to make a rounded windowshape at whatever rect they end up with. Jim Lambert ___ 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: [ANN] RunRevPlanet Search
I will email you a private message with a screen shot. Bob On Mar 16, 2011, at 3:29 PM, Scott McDonald wrote: Hi Bob, Just wanted to point out that your web site has the same copy for RRP-Gradient Explorer.rev as it does for RRP-Grid-Share-Price-Demo.rev. Do you mean you found the links on the download page were to the same file? I checked and they appear correct, but perhaps I have misunderstood your comment. Thanks, Scott. - -- Scott McDonald Components, Controls, Tools and Resources for LiveCode www.runrevplanet.com -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/ANN-RunRevPlanet-Search-tp3353007p3383217.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ 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 ___ 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: Best practice for creating a resizable HUD-style widget stack background?
Is that exercise for the liver? Bob On Mar 16, 2011, at 4:40 PM, Jim Lambert wrote: you can set the windowshape to 0 while they liveresize ___ 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
LC-using Educators
I'm in a bit of a pickle... can LC-using educators please contact me off-list? TIA, Judy ___ 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: LC-using Educators
I'm in a bit of a pickle... can LC-using educators please contact me off-list? Yes? -- Nicolas Cueto ___ 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
More regex madness
Hi all. I read over the regex specifications, and I am more confused than ever. I want to find, say any text and varchar and any text and default and any text. I would think that: matchText(varchar(255) default `Yes`, *varchar*default*) would return true, but no. I get: Message execution error: Error description: matchChunk: error in pattern expression Hint: bad escape sequence However: put matchText(varchar(255) default `Yes`, varchar) returns true. How do I use wild cards?? I really thought I understood at least the basics of regex, but I see I do not. Bob ___ 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: Best practice for creating a resizable HUD-style widget stack background?
Recently, Jim Lambert wrote: You can also generate a rounded appearance with just one object. 1 - create a rounded rectangle graphic with the corner radii you want, say 30. 2 - name it myMask 3 - make it opaque invisible 4 - set its rect to the card's rect 5 - set its geometry to scale with the window 6 - put this script in the card: command maskMe import snapshot from grc myMask set the windowshape of this stack to the id of last image delete last image end maskMe [forehead smack] Jim's right, I should have mentioned this is the easy way to do a round rect window. I'm used to the pre-graphic effects days of LC (Rev) where the only way to create a shadow for a custom window was to create a mask shape in an image-editing app along with its dropshadow and slice that into 9 tiles. Now one can simply add a dropshadow to a round rect graphic, place the graphic in a group with a suitably large margin, and import the windowshape mask image as a snapshot of the group. Good call Jim. Regards, Scott Rossi Creative Director Tactile Media, UX Design ___ 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: [ANN] RunRevPlanet Search
Thanks very much. - -- Scott McDonald Components, Controls, Tools and Resources for LiveCode www.runrevplanet.com -- View this message in context: http://runtime-revolution.278305.n4.nabble.com/ANN-RunRevPlanet-Search-tp3353007p3383550.html Sent from the Revolution - User mailing list archive at Nabble.com. ___ 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: More regex madness
the * matches any number of chars matching the preceeding char. so *varchar*will try to match varcharrr To do what you want, use the period which stand for any char. So.. .*varchar.*default.* might be closer to what you want. Can be some weird results depending on whats in the string that is being regexed, but should get you a start. On Wed, Mar 16, 2011 at 6:20 PM, Bob Sneidar b...@twft.com wrote: Hi all. I read over the regex specifications, and I am more confused than ever. I want to find, say any text and varchar and any text and default and any text. I would think that: matchText(varchar(255) default `Yes`, *varchar*default*) would return true, but no. I get: Message execution error: Error description: matchChunk: error in pattern expression Hint: bad escape sequence However: put matchText(varchar(255) default `Yes`, varchar) returns true. How do I use wild cards?? I really thought I understood at least the basics of regex, but I see I do not. Bob ___ 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 ___ 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: More regex madness
Oh, also, there is a regex builder plugin thingy that is pretty useful, and should be installed in the ide by default. On Wed, Mar 16, 2011 at 8:09 PM, Mike Bonner bonnm...@gmail.com wrote: the * matches any number of chars matching the preceeding char. so *varchar*will try to match varcharrr To do what you want, use the period which stand for any char. So.. .*varchar.*default.* might be closer to what you want. Can be some weird results depending on whats in the string that is being regexed, but should get you a start. On Wed, Mar 16, 2011 at 6:20 PM, Bob Sneidar b...@twft.com wrote: Hi all. I read over the regex specifications, and I am more confused than ever. I want to find, say any text and varchar and any text and default and any text. I would think that: matchText(varchar(255) default `Yes`, *varchar*default*) would return true, but no. I get: Message execution error: Error description: matchChunk: error in pattern expression Hint: bad escape sequence However: put matchText(varchar(255) default `Yes`, varchar) returns true. How do I use wild cards?? I really thought I understood at least the basics of regex, but I see I do not. Bob ___ 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 ___ 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: est practice for creating a resizable HUD-style widget stack background?
BobS wrote: Is that exercise for the liver? I'll drink to that! Jim Lambert ___ 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: Sort of OT: mysql and select from two tables...?
I was just trying to get this to work straight with php and mysql, at least first off. I remember hearing others say the revmobile does not allow for LiveCode 's mySQL commands to work from within a mobile app. I thought I had heard, if you can just call post commands from within your revmobile app, you could still access mysql from your revmobile app. I keep trying to think of php and mysql commands the same way i think of LiveCode. That's my problem :-) The user log in I was referring to in the earlier post was just a mysql query that compares what the user types in on the form for username and password. If they match they move on, if they don't match, they get to try again. A username and password match instigates a session_start() and that code is placed at the top of each html page. I think this was a pretty typically way to create a basic form based login using php and mysql. My attempt to query the student_user table for all students associated to that teacher via an entry in the teacher_user table, the teacher's unique id, was what i was after. It would be much easier to do this in a rev app. I could just store all the teacher data from the table teacher_user, and pull it out when querying tables other than teacher_user, such as the student_user table. Thanks! John Patten SUSD On Mar 16, 2011, at 4:36 PM, Bob Sneidar wrote: session_register is not a mySQL function, it is php. It is also deprecated, so it may or may not work depending on the version of php being used. I thought you were trying to get Livecode to tell you who the current logged in user was? current_user() or just user() works for me. Bob on mouseUp pMouseBtnNo put select current_user() into theSQL put dbconn_get(connection id, priconn, primary) into thePriID -- sqlYoga function try put revDataFromQuery(comma, return, thePriID, theSQL) into theSQLData -- RevDB function catch theError answer theError exit to top end try put theSQLData end mouseUp This returns my on-rev user login@the ip I am connecting from as in mydatabase_mylogin@69.227.63.5 (I made that up). Wouldn't that do it for you? Or are you using some kind of internal authentication and you are trying to get what the user typed into a form? Bob On Mar 16, 2011, at 4:10 PM, John Patten wrote: Hi Bob... session_user() appears to give me something other than the current logged in user. It returns: myaccount_nameofdatabase This is what I did to test it out: $result = mysql_query( SELECT session_user() FROM teacher_user ) or die(SELECT Error: .mysql_error()); $num_rows = mysql_num_rows($result); print There are $num_rows records.P; print table width=600 border=1\n; while ($get_info = mysql_fetch_row($result)){ print tr\n; foreach ($get_info as $field) print \ttd$field/td\n; print /tr\n; } print /table\n; I think even if I could return just the current user's profile (fields in their record) using the session_register command in mySQL I'd be making progress :-) Any other ideas? Thank you! John Patten SUSD On Mar 16, 2011, at 1:24 PM, Bob Sneidar wrote: You can use SELECT session_user() to get the currently logged in user. It's a synonym for USER(). That help? Bob On Mar 16, 2011, at 12:15 PM, John Patten wrote: Hi All... Thanks for the previous help on the on-rev php/mysql question. I have a question about the mysql select command, session_register, and selecting from two tables. I have one database with two tables. The tables are teacher_user and student_user. Each table has a unique teacher-id stored in a fields. So students with the teacher_id value of 0001 stored in their student_user record all belong to the same teacher. Teacher_tableStudent_table id - 0001 teacher_id = 0001 first first last last title grade I also have the teacher login with their username and password comparing what is stored in their db record for username and password. If they match, then their username and password is then session_register(username); session_register(password); . What i would like to be able to do is query the database and return a list of students to the individual teacher based on some unique information about the teacher's record, say their username. is there some way I can get at the session_register(username) and use it in my select query? Something like: select username from teacher_table and put id of table teacher_table into tTeacher_id then select tTeacher_id from student_table and loop through the student printing each record I suppose if the teacher new their id value I could just have them type that into a form and do a simple query the student_table and teacher_id field by that id value. But I was
Re: On-Rev mySQL-PHP
JB Who should be contacted to resolve this problem? I have used http://on-rev.com/support/contact-us/ or email to on-...@runrev.com to get assistance with on-rev. Peter ___ 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
Share this Stack
I seem to remember a way to 'remove' some special setting or tag from a stack that was shared on RevOnline. Does anyone remember how to remove that? -- Tom McGrath III http://lazyriver.on-rev.com 3mcgr...@comcast.net ___ 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: On-Rev mySQL-PHP
Thank you for the info. I will give it a try. -=JB=- On Mar 16, 2011, at 8:03 PM, Peter W A Wood wrote: JB Who should be contacted to resolve this problem? I have used http://on-rev.com/support/contact-us/ or email to on-...@runrev.com to get assistance with on-rev. Peter ___ 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 ___ 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
secure comm between app and server
I want to make the communication secure between my desktop app (and later a mobile app) and a LC CGI script on my server. I have HTTPS turned on and certificate in place, but don't know how much of that is needed. How do I do it? I have no clue. If it's easier to do it with revServer (aka irev) code, I'm open. I just want to keep it in LC if possible. Many thanks - -- Phil Davis PDS Labs Professional Software Development http://pdslabs.net ___ 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: secure comm between app and server
Phil, Would it suffice to encrypt the data? Paul Looney On Mar 16, 2011, at 9:51 PM, Phil Davis wrote: I want to make the communication secure between my desktop app (and later a mobile app) and a LC CGI script on my server. I have HTTPS turned on and certificate in place, but don't know how much of that is needed. How do I do it? I have no clue. If it's easier to do it with revServer (aka irev) code, I'm open. I just want to keep it in LC if possible. Many thanks - -- Phil Davis PDS Labs Professional Software Development http://pdslabs.net ___ 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 ___ 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: secure comm between app and server
I dunno. I think I would still want to send the data through the SSL tunnel that HTTPS uses, or something like it. The data will contain commands that make things happen from remote locations. I'm just now reading a Wikipedia article about HTTPS - good stuff! http://en.wikipedia.org/wiki/Https Phil On 3/16/11 9:59 PM, Paul Looney wrote: Phil, Would it suffice to encrypt the data? Paul Looney On Mar 16, 2011, at 9:51 PM, Phil Davis wrote: I want to make the communication secure between my desktop app (and later a mobile app) and a LC CGI script on my server. I have HTTPS turned on and certificate in place, but don't know how much of that is needed. How do I do it? I have no clue. If it's easier to do it with revServer (aka irev) code, I'm open. I just want to keep it in LC if possible. Many thanks - -- Phil Davis PDS Labs Professional Software Development http://pdslabs.net ___ 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 ___ 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 -- Phil Davis PDS Labs Professional Software Development http://pdslabs.net ___ 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