Many Cards vs. Lists vs. XML

[Peter Alcibiades]

Sivakatirswami, thanks for a most interesting and thought provoking post and 
approach that would never have occurred to me.  Perhaps the disadvantage of 
it might be that exporting the data in a way that can be used by another 
application might require extra work, if you feel the need to provide for 
that?   

But apart from that, its very interesting and I'll try it.

Peter
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Re: UPDATE table and quote in a text

[Horst]

Good morning Trevor,

Thanks for that. I´ll try tomorrow and let you know here

best regards

Horst


Trevor DeVore wrote:
> 
> On Feb 17, 2008, at 5:23 PM, Horst wrote:
>> I know, the easiest way would be to encode the data with  
>> base64encode. But
>> there must also be a way to  save a text f.e. like 1234'5'6öä'ioup"#  
>> in a
>> varchar or text type. With base64encode it will f.e. not be possible  
>> to use
>> the "fulltext" indexing, which I will need. No, there must be  
>> another way.
>> SQL is not that silly and I learned, that RR is a a powerfull tool,  
>> if you
>> (or someone else) knows the "tricks". Once again the question: How  
>> to save
>> any text via RR to a SQL-Table as described before.
> 
> 
> Hi Horst,
> 
> You can definitely insert any text into a database using Rev as long  
> as you cleanse the input first. I've attached a modified handler from  
> libDatabase that you can use to escape strings you want to use in an  
> UPDATE clause.
> 
> SQLite only requires for single quote to be escaped. MySQL has a  
> slightly more complex escape sequence as does PostGreSQL. I haven't  
> tested the postgresql code myself but I based the code off of some  
> docs I found somewhere.
> 
> Here is an example of how you could use it:
> 
> ...
> put escapeStringForSQL("mysql", the text of field "UserSuppliedData")  
> into theData
> put format("UPDATE my_table SET user_data = '%s' WHERE ID = %u",  
> theData, theID) into theSQL
> 
> 
> 
> Regards,
> 
> -- 
> Trevor DeVore
> Blue Mango Learning Systems
> www.bluemangolearning.com-www.screensteps.com
> 
> 
> 
> function escapeStringForSQL pDBType, pString
>  switch pDBType
>  case "mysql"
>  replace numtochar(92) with numtochar(92) & numtochar(92)  
> in pString --> \ to \\
>  replace numtochar(39) with numtochar(92) & numtochar(39)  
> in pString --> ' to \'
>  replace numtochar(34) with numtochar(92) & numtochar(34)  
> in pString --> " to \"
>  replace numtochar(0) with numtochar(92) & numtochar(48)  
> in pString --> NULL to \0
>  replace numtochar(26) with numtochar(92) & numtochar(90)  
> in pString --> Control-Z to \Z
>  replace numtochar(10) with numtochar(92) & numtochar(110)  
> in pString --> newline to \n
>  replace numtochar(13) with numtochar(92) & numtochar(114)  
> in pString --> carriage return to \r
>  replace numtochar(9) with numtochar(92) & numtochar(116)  
> in pString --> tab to \t
>  replace numtochar(8) with numtochar(92) & numtochar(98)  
> in pString --> backspace to \b
>  break
>  case "postgresql"
>  replace numtochar(92) with numtochar(92) & numtochar(92)  
> in pString --> \ to \\
>  replace numtochar(39) with numtochar(39) & numtochar(39)  
> in pString --> ' to ''
>  replace numtochar(12) with numtochar(92) & numtochar(102)  
> in pString --> formfeed to \f
>  replace numtochar(10) with numtochar(92) & numtochar(110)  
> in pString --> newline to \n
>  replace numtochar(13) with numtochar(92) & numtochar(114)  
> in pString --> carriage return to \r
>  replace numtochar(9) with numtochar(92) & numtochar(116)  
> in pString --> tab to \t
>  replace numtochar(8) with numtochar(92) & numtochar(98)  
> in pString --> backspace to \b
>  break
>  case "sqlite"
>  default
>  replace numtochar(39) with numtochar(39) & numtochar(39)  
> in pString --> ' to ''
>  break
>  end SWITCH
> end lib escapeStringForSQL___
> use-revolution mailing list
> use-revolution@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
> 
> 

-- 
View this message in context: 
http://www.nabble.com/UPDATE-table-and-quote-in-a-text-tp15529083p15540022.html
Sent from the Revolution - User mailing list archive at Nabble.com.

___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Re: UPDATE table and quote in a text

[Trevor DeVore]

On Feb 17, 2008, at 5:23 PM, Horst wrote:
I know, the easiest way would be to encode the data with  
base64encode. But
there must also be a way to  save a text f.e. like 1234'5'6öä'ioup"#  
in a
varchar or text type. With base64encode it will f.e. not be possible  
to use
the "fulltext" indexing, which I will need. No, there must be  
another way.
SQL is not that silly and I learned, that RR is a a powerfull tool,  
if you
(or someone else) knows the "tricks". Once again the question: How  
to save

any text via RR to a SQL-Table as described before.



Hi Horst,

You can definitely insert any text into a database using Rev as long  
as you cleanse the input first. I've attached a modified handler from  
libDatabase that you can use to escape strings you want to use in an  
UPDATE clause.


SQLite only requires for single quote to be escaped. MySQL has a  
slightly more complex escape sequence as does PostGreSQL. I haven't  
tested the postgresql code myself but I based the code off of some  
docs I found somewhere.


Here is an example of how you could use it:

...
put escapeStringForSQL("mysql", the text of field "UserSuppliedData")  
into theData
put format("UPDATE my_table SET user_data = '%s' WHERE ID = %u",  
theData, theID) into theSQL




Regards,

--
Trevor DeVore
Blue Mango Learning Systems
www.bluemangolearning.com-www.screensteps.com



function escapeStringForSQL pDBType, pString
switch pDBType
case "mysql"
replace numtochar(92) with numtochar(92) & numtochar(92)  
in pString --> \ to \\
replace numtochar(39) with numtochar(92) & numtochar(39)  
in pString --> ' to \'
replace numtochar(34) with numtochar(92) & numtochar(34)  
in pString --> " to \"
replace numtochar(0) with numtochar(92) & numtochar(48)  
in pString --> NULL to \0
replace numtochar(26) with numtochar(92) & numtochar(90)  
in pString --> Control-Z to \Z
replace numtochar(10) with numtochar(92) & numtochar(110)  
in pString --> newline to \n
replace numtochar(13) with numtochar(92) & numtochar(114)  
in pString --> carriage return to \r
replace numtochar(9) with numtochar(92) & numtochar(116)  
in pString --> tab to \t
replace numtochar(8) with numtochar(92) & numtochar(98)  
in pString --> backspace to \b

break
case "postgresql"
replace numtochar(92) with numtochar(92) & numtochar(92)  
in pString --> \ to \\
replace numtochar(39) with numtochar(39) & numtochar(39)  
in pString --> ' to ''
replace numtochar(12) with numtochar(92) & numtochar(102)  
in pString --> formfeed to \f
replace numtochar(10) with numtochar(92) & numtochar(110)  
in pString --> newline to \n
replace numtochar(13) with numtochar(92) & numtochar(114)  
in pString --> carriage return to \r
replace numtochar(9) with numtochar(92) & numtochar(116)  
in pString --> tab to \t
replace numtochar(8) with numtochar(92) & numtochar(98)  
in pString --> backspace to \b

break
case "sqlite"
default
replace numtochar(39) with numtochar(39) & numtochar(39)  
in pString --> ' to ''

break
end SWITCH
end lib escapeStringForSQL___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Re: removing ask/answer/msg substacks from old mc stacks

[J. Landman Gay]

Jeff Reynolds wrote:

I'm sorry i have done this in the past, but have forgotten how to do it.

I have some old mc stacks from like 8 years ago that have the ask and 
answer dialog substacks in them. i removed them in rev 2.6.1, but now i 
keep getting a message box error (message box is already open in rev) 
when i open the stack in rev 2.8.1. so it seems that there is still a 
message box substack hiding in my stack, but it doesnt show up in 
application browser with my stack.


The easiest way to get rid of those is to open the stack in the MC IDE 
and use its resource mover to delete the stacks. You can download the MC 
IDE from Yahoo groups here:




If you aren't a member of the group, you'll have to join. Once you are 
in the Files section, also download the metacard_setup10.mc.zip stack 
(it's the last one in the Files listing.) This utility automatically 
sets up the MC IDE to work with the current Rev engine and installs 
everything you need with one click. Open this utility stack from inside 
Revolution. (Actually, this little utility can auto-download the MC IDE 
for you, so really all you need is a copy of the setup stack.)


If you don't want to go the MC route, then you can set Rev's preferences 
to show rev stacks in lists and look for the duplicate stacks in the App 
Brower. I don't know if they will show up but it is worth a try. I think 
they should.


If that doesn't work, you'll have to find them manually. Start issuing 
commands like this in the message box:


  put there is a stack "answer dialog" of stack "myStack"

If the result is true, then be careful how you delete it; make sure you 
provide a full reference to the stack so that you don't accidentally 
delete Revolution's copy instead of your own:


  delete stack "answer dialog" of stack "myStack"

--
Jacqueline Landman Gay | [EMAIL PROTECTED]
HyperActive Software   | http://www.hyperactivesw.com
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Re: Record sound no longer works in XP with Rev 2.7.1

[J. Landman Gay]

Richard Miller wrote:
I just updated to Quicktime 7.4.1 on an XP Home and a Vista computer. 
Using Rev 2.7.1, the record sound command appears dead. Has this been 
reported by others? It's certainly a serious problem for a few of my 
programs. The MCI alternative still works, but I find that not nearly as 
flexible.


Yeah. It's been coming into the support queue. 



--
Jacqueline Landman Gay | [EMAIL PROTECTED]
HyperActive Software   | http://www.hyperactivesw.com
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Re: Many Cards vs. Lists vs. XML

[Sivakatirswami]

Like Richard said: depends on your project.

For die-hard "only language I know or ever want to learn..." xTalkers... 
"many cards" still works for read only, single editor at a time projects 
with relatively small data sets where an open source back end is not a 
requirement.


I have several projects that use stacks with 3000-5000 cards. They have 
the advantage that you stay entirely in a Revolution environment, 
rapidly code the UI, easily distribute to volunteers (bundle with a 
standalone loader)  etc.. your GUI *is* your data base... you don't have 
to build a data base and then build another application to "talk" to 
it... they are one and the same.  You can just drop this stack on your 
web server and talk to it with a CGI, "as easy as pecan pie" . This is 
very sweet.


accessing the data then becomes as simple as

start using stack "my4000CardStack.rev"

The key to doing this efficiently, at least in my "baby xTalk" way of 
doing things
is to make sure that the primary key (ID, etc... whatever you are using) 
is not only 1 of the fields in the records, but you also set the card 
name to that same value.


Then the internal global "the card names of this stack" becomes a super 
fast index to your data. And you can do all kinds of smart stuff, very 
easily, with marking cards to create sets etc... build arrays from the 
data in the cards...blinding fast search and displays and you never  
actually "go to card x" except for data entry.


e.g. the back end data container for this little dictionary:

http://www.himalayanacademy.com/resources/lexicon/

is a stack with about 3,500 hundred cards...

Everything works almost instantaneously. Putting all the data into 
custom properties also works if you prefer a 1 card "single window on my 
data" approach to stackware...


The Pros and the limitation of this model comes from fact that the 
entire stack is loaded into memory. I have one stack that contains 
73,000 records (simple name and address and a few more pieces of info 
for each person) in a single custom property. That stack is 10 
megabytes... this is a threshold where the disk I/O starts to feel a 
little sluggish if you have to do a lot of open and saves... but even at 
this size, if  you load it once and the rest of usage is primarily just 
reading the data... it sparkles. It's pretty much a free form dbase with 
pipe delimiter "|" between each records... With Revolution's text 
parsing power I can write complex queries against that custom 
property... in just 10-15 line of code...


Just to do the same thing with SQLite and dbase drivers and all that oh 
boy. why bother when you can do the same thing in 20-30 lines of code?


Of course there's the "nag" that says "its so much cooler to use open 
source"  "Web 2.0 MySql SQLLite  and Dbase drivers and javascript and 
ajax... but if  you were  weaned on Hypercard as a "kid" and know the 
simplicity of the stack-cards model, why go down a path that's going to 
take upmpteen hours when you can do the same thing in 30 minutes? Just 
because it is open source, doesn't mean it's a better or more efficient 
way to get the job done.


I see a lot of things that are "moving forward" but from a production 
manager's point of view (that's me).. .are moving backward in terms of 
productivity... 


End of Revolution

"stacks and cards are still a 2nd Millenium gold standard for lots of 
projects"


Advocacy...

If only the world knew...



Björnke von Gierke wrote:
If no one else needs to read your files, you can use return delimited 
lists, and enter htmltext there. Rev doesn't care if there's returns 
between the  tags, so you can just strip it. Added bonus: 
Styled text is preserved.



On 16 Feb 2008, at 22:04, Russell Martin wrote:


So, I've been reading up on Rev's XML features and I'm wondering if
that isn't a better route to go than using lists? Any thoughts?

Also, for those that use lists to store data, how do you handle placing
multiline data into your list structure?

And, what do you do to deal with data that might contain instances of
your delimiter before you place it in your list? Or, is there some
perfect delimiter that I just haven't thought of?






___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Re: md5

[Mark Smith]

Malte, thanks, but I need to get the md5 of potentially very large  
files on disc. I'm hoping to avoid having to load them into memory in  
order get the digest.



Best,

Mark

On 18 Feb 2008, at 00:18, Malte Brill wrote:


Hi Mark,

Rev has MD5 build in. However you will need to do some conversion  
of it, to match the way other languages display MD5 (like PHP)


Here is a snippet:

local tVar,tDigest
put md5digest("Malte") into tVar
get binarydecode("H*",tVar,tDigest)
put tDigest

Hope that helps,

Malte



___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your  
subscription preferences:

http://lists.runrev.com/mailman/listinfo/use-revolution


___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Re: Record sound no longer works in XP with Rev 2.7.1

[Richard Miller]

I should note this was tested with an external USB mic. Perhaps it  
still works with an internal mic?

Richard Miller



On Feb 17, 2008, at 8:28 PM, Richard Miller wrote:

I just updated to Quicktime 7.4.1 on an XP Home and a Vista  
computer. Using Rev 2.7.1, the record sound command appears dead.  
Has this been reported by others? It's certainly a serious problem  
for a few of my programs. The MCI alternative still works, but I  
find that not nearly as flexible.


Richard Miller
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your  
subscription preferences:

http://lists.runrev.com/mailman/listinfo/use-revolution


___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Record sound no longer works in XP with Rev 2.7.1

[Richard Miller]

I just updated to Quicktime 7.4.1 on an XP Home and a Vista computer.  
Using Rev 2.7.1, the record sound command appears dead. Has this been  
reported by others? It's certainly a serious problem for a few of my  
programs. The MCI alternative still works, but I find that not nearly  
as flexible.


Richard Miller
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Re: removing ask/answer/msg substacks from old mc stacks

[Stephen Barncard]

 in Rev it's the preference "revolution UI Elements appear in lists of stacks"
is there a similar pref in Metacard?   (sorry if this is obvious...)


I'm sorry i have done this in the past, but have forgotten how to do it.

I have some old mc stacks from like 8 years ago that have the ask 
and answer dialog substacks in them. i removed them in rev 2.6.1, 
but now i keep getting a message box error (message box is already 
open in rev) when i open the stack in rev 2.8.1. so it seems that 
there is still a message box substack hiding in my stack, but it 
doesnt show up in application browser with my stack. i remember a 
similar problem in the past with old mc cards like this, but ive 
forgotten what i did last time to loose all the old substack assets 
to make it clean with rev.


thanks

jeff reynolds


--


stephen barncard
s a n  f r a n c i s c o
- - -  - - - - - - - - -


___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Re: md5

[Malte Brill]

Hi Mark,

Rev has MD5 build in. However you will need to do some conversion of  
it, to match the way other languages display MD5 (like PHP)


Here is a snippet:

local tVar,tDigest
put md5digest("Malte") into tVar
get binarydecode("H*",tVar,tDigest)
put tDigest

Hope that helps,

Malte



___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

removing ask/answer/msg substacks from old mc stacks

[Jeff Reynolds]

I'm sorry i have done this in the past, but have forgotten how to do it.

I have some old mc stacks from like 8 years ago that have the ask and  
answer dialog substacks in them. i removed them in rev 2.6.1, but now  
i keep getting a message box error (message box is already open in  
rev) when i open the stack in rev 2.8.1. so it seems that there is  
still a message box substack hiding in my stack, but it doesnt show up  
in application browser with my stack. i remember a similar problem in  
the past with old mc cards like this, but ive forgotten what i did  
last time to loose all the old substack assets to make it clean with  
rev.


thanks

jeff reynolds



___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

md5

[Mark Smith]

On OS X (and linux, I'd imagine), if I want to get the md5 digest of  
a file, I can pretty much rely on the presence of openssl and it's  
command line.
Is this true on Windows? If it isn't, does anyone know if there is  
another 'built-in' command for it in Windows?


Thanks,

Mark
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Re: Many Cards vs. Lists vs. XML

[Sivakatirswami]

(sitting here cranking out PDFs... got time...)

Like Richard said: depends on your project.

For die-hard "only language I know or ever want to learn..." xTalkers... 
"many cards" still works for read only, single editor at a time projects 
with relatively small data sets where an open source back end is not a 
requirement.


I have several projects that use stacks with 3000-5000 cards. They have 
the advantage that you stay entirely in a Revolution environment, 
rapidly code the UI, easily distribute to volunteers (bundle with a 
standalone loader)  etc.. your GUI *is* your data base... you don't have 
to build a data base and then build another application to "talk" to 
it... they are one and the same.  You can just drop this stack on your 
web server and talk to it with a CGI, "as easy as pecan pie" . This is 
very sweet.


accessing the data then becomes as simple as

start using stack "my4000CardStack.rev"

The key to doing this efficiently, at least in my "baby xTalk" way of 
doing things
is to make sure that the primary key (ID, etc... whatever you are using) 
is not only 1 of the fields in the records, but you also set the card 
name to that same value.


Then the internal global "the card names of this stack" becomes a super 
fast index to your data. And you can do all kinds of smart stuff, very 
easily, with marking cards to create sets etc... build arrays from the 
data in the cards...blinding fast search and displays and you never  
actually "go to card x" except for data entry.


e.g. the back end data container for this little dictionary:

http://www.himalayanacademy.com/resources/lexicon/

is a stack with about 3,500 hundred cards...

Everything works almost instantaneously. Putting all the data into 
custom properties also works if you prefer a 1 card "single window on my 
data" approach to stackware...


The Pros and the limitation of this model comes from fact that the 
entire stack is loaded into memory. I have one stack that contains 
73,000 records (simple name and address and a few more pieces of info 
for each person) in a single custom property. That stack is 10 
megabytes... this is a threshold where the disk I/O starts to feel a 
little sluggish if you have to do a lot of open and saves... but even at 
this size, if  you load it once and the rest of usage is primarily just 
reading the data... it sparkles. It's pretty much a free form dbase with 
pipe delimiter "|" between each records... With Revolution's text 
parsing power I can write complex queries against that custom 
property... in just 10-15 line of code...


To do the same thing with SQLite and dbase drivers and all that... oh 
boy. why bother when you can do the same thing in 20-30 lines of code?


Of course there's the "nag" that says "its so much cooler to use open 
source"  "Web 2.0 MySql SQLLite  and Dbase drivers and javascript and 
ajax... but if  you were  weaned on Hypercard as a "kid" and know the 
simplicity of the stack-cards model, why go down a path that's going to 
take upmpteen hours when you can do the same thing in 30 minutes? Just 
because it is open source, offical "database" doesn't mean it's a better 
or more efficient way to get the job done.


I see a lot of things that are "moving forward" but from a production 
manager's point of view (that's me).. .are moving backward in terms of 
productivity... 


End of Revolution (or hypercard or supercard..)

"stacks and cards are still a 2nd Millenium gold standard for lots of 
projects"


Advocacy...

Björnke von Gierke wrote:
If no one else needs to read your files, you can use return delimited 
lists, and enter htmltext there. Rev doesn't care if there's returns 
between the  tags, so you can just strip it. Added bonus: 
Styled text is preserved.



On 16 Feb 2008, at 22:04, Russell Martin wrote:


So, I've been reading up on Rev's XML features and I'm wondering if
that isn't a better route to go than using lists? Any thoughts?

Also, for those that use lists to store data, how do you handle placing
multiline data into your list structure?

And, what do you do to deal with data that might contain instances of
your delimiter before you place it in your list? Or, is there some
perfect delimiter that I just haven't thought of?






___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Re: UPDATE table and quote in a text

[Horst]

Holá Mark,

ik wil u danken. 

I know, the easiest way would be to encode the data with base64encode. But
there must also be a way to  save a text f.e. like 1234'5'6öä'ioup"# in a
varchar or text type. With base64encode it will f.e. not be possible to use
the "fulltext" indexing, which I will need. No, there must be another way.
SQL is not that silly and I learned, that RR is a a powerfull tool, if you
(or someone else) knows the "tricks". Once again the question: How to save
any text via RR to a SQL-Table as described before.

best regards

Horst




Mark Schonewille-3 wrote:
> 
> Hallo Horst,
> 
> You could write a function to escape all special characters, but the  
> easiest and most reliable way is to encode the data with base64encode 
> () before storing it.
> 
> Best regards,
> 
> Mark Schonewille
> 
> --
> 
> Economy-x-Talk Consulting and Software Engineering
> http://economy-x-talk.com
> http://www.salery.biz
> 
> Convert colours between different colour spaces with Color Converter.  
> Download at http://economy-x-talk.com/cc.html
> 
> 
> 
> Op 17-feb-2008, om 17:09 heeft Horst het volgende geschreven:
> 
>>
>> Holá Mark,
>>
>> The main question seems to be: How to "include" a textfile for  
>> example:
>> ..
>> put "1234'5'6öä'ioup"#" into mytext ## I know, this text is  
>> senseless, but
>> never mind, it should be able to be saved
>> replace quote with "\" & quote in mytext ## and then, how to  
>> replave the '
>> ???
>> put "UPDATE table set textfile = '" & mytext & "'... into sql_messqage
>> revexecutesql (my_ID), sql_message
>> put the result  ## shows an SQL-Error message and mytext will not  
>> be saved
>> ..
>>
>> best regards and, as usual, a big thank You for answering
>>
>> Horst
>>
> ___
> use-revolution mailing list
> use-revolution@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
> 
> 

-- 
View this message in context: 
http://www.nabble.com/UPDATE-table-and-quote-in-a-text-tp15529083p15535637.html
Sent from the Revolution - User mailing list archive at Nabble.com.

___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Re: How do I create a group of buttons on the fly

[mfstuart]

Hi all,
Thanx Chipp for the pointers, they helped me clarify what I was aiming for
in this little application.

I've finished this and it's working how I want for now. Variations may apply
as I work on it.
I've placed the stack on the RevOnline under Programming category, if any
one is interested.
RunRev version: 2.8.1
Developed on: WINXP
Search for...
 username: mfstuart
 revfilename: ShortcutBar Sytem Menu

Any comments as to how it could be improved most welcome.
What else is most welcome: if it doesn't work, let me know with a reply, and
I'll fix it and update it to RevOnline.

Thanx,
Mark Stuart
-- 
View this message in context: 
http://www.nabble.com/How-do-I-create-a-group-of-buttons-on-the-fly-tp15519011p15535389.html
Sent from the Revolution - User mailing list archive at Nabble.com.

___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Re: revolution on the web

[Chipp Walters]

Hi Eric,

I'll try and answer as many as I can.

On Feb 17, 2008 10:53 AM, Eric A. Engle <[EMAIL PROTECTED]> wrote:

> I signed up for the 2.9 beta :) iHope I get accepted I
> think I have some ability to contribute.


Not sure, but I think all existing users who sign-up are automatically
included.


>
>
> I would like to see revolution able to
> a) generate video (see my hypercard videokit built
> with udi's external, it's on Alain's pantechnicon


Currently you can do this just fine using Trevor's excellent Quicktime
externals.



>
> c) develop a browser capability (see my iFunctions
> stack, it's on Alain's free gui site)
> I got a copy of altBrowser complimentary from altuit,
> sort of as an incentive to stop working on my own
> browser. It's not on their website. Did altBrowser get
> directl integrated into the more recent releases of
> rev (the way I think it should be :) ?


Yes, altBrowser is now revBrowser. It was sold to RunRev awhile back. I
don't remember your complimentary version, but then we did hand out a few
complimentary versions. That said, I certainly don't remember giving it to
you as an incentive to stop working on your own. That doesn't sound like
something we do. Perhaps you got it elsewhere?


>
> What I really would love is a way for stacks to be
> served into a browser (i.e. a rev plugin like
> shockwave or flash). I know 3 years ago that wasn't in
> the works. I'm hoping it is now.
>

This topic has been discusses ad infinitum on this list. I suggest you do
some GMANE searches and you can find out for yourself the ongoing thinking
on this subject.


>
> Also I'm interested in investor relations =)


If you're interested in purchasing RunRev stock, you should contact RunRev
directly.

best, Chipp
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

revolution on the web

[Eric A. Engle]

I signed up for the 2.9 beta :) iHope I get accepted I
think I have some ability to contribute. 

I would like to see revolution able to 
a) generate video (see my hypercard videokit built
with udi's external, it's on Alain's pantechnicon
b) become an alternative to javascript 

Re: UPDATE table and quote in a text

[Mark Schonewille]

Hallo Horst,

You could write a function to escape all special characters, but the  
easiest and most reliable way is to encode the data with base64encode 
() before storing it.


Best regards,

Mark Schonewille

--

Economy-x-Talk Consulting and Software Engineering
http://economy-x-talk.com
http://www.salery.biz

Convert colours between different colour spaces with Color Converter.  
Download at http://economy-x-talk.com/cc.html




Op 17-feb-2008, om 17:09 heeft Horst het volgende geschreven:



Holá Mark,

The main question seems to be: How to "include" a textfile for  
example:

..
put "1234'5'6öä'ioup"#" into mytext ## I know, this text is  
senseless, but

never mind, it should be able to be saved
replace quote with "\" & quote in mytext ## and then, how to  
replave the '

???
put "UPDATE table set textfile = '" & mytext & "'... into sql_messqage
revexecutesql (my_ID), sql_message
put the result  ## shows an SQL-Error message and mytext will not  
be saved

..

best regards and, as usual, a big thank You for answering

Horst


___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Re: UPDATE table and quote in a text

[Horst]

Holá Mark,

The main question seems to be: How to "include" a textfile for example:
..
put "1234'5'6öä'ioup"#" into mytext ## I know, this text is senseless, but
never mind, it should be able to be saved
replace quote with "\" & quote in mytext ## and then, how to replave the '
??? 
put "UPDATE table set textfile = '" & mytext & "'... into sql_messqage
revexecutesql (my_ID), sql_message
put the result  ## shows an SQL-Error message and mytext will not be saved
..

best regards and, as usual, a big thank You for answering

Horst
 

Mark Schonewille-3 wrote:
> 
> Dear Horst,
> 
> Single quotes should be escaped the way you do and this should work  
> fine. I have seen reports of commands starting with revdb being  
> unable to escape single quotes, but this can be solved by using  
> revExecuteSQL -- I don't know whether there really is a bug with  
> escaping characters, I didn't encounter this problem myself. Make  
> sure that you only replace single quotes that are part of the data  
> and not the two single quotes that surround the string.
> 
> Best regards,
> 
> Mark Schonewille
> 
> --
> 
> Economy-x-Talk Consulting and Software Engineering
> http://economy-x-talk.com
> http://www.salery.biz
> 
> Convert colours between different colour spaces with Color Converter.  
> Download at http://economy-x-talk.com/cc.html
> 
> 
> 
> Op 17-feb-2008, om 13:24 heeft Horst het volgende geschreven:
> 
>>
>> Hi there,
>>
>> A  question to all SQL-Masters:
>> To update a record in a SQL-Table and to store text which includes  
>> the "
>> sign in an SQL-Syntax I learnd, that it is necessary to use
>>
>> replace quote with "\" & quote in zText
>> Well, that works fine, but what about The ' sign?
>>
>> replace "'" with "\'" in zText
>> seems NOT to work.
>>
>> Thanks a lot to all of you and best regards
>>
>> Horst
>> -- 
>> View this message in context: http://www.nabble.com/UPDATE-table- 
>> and-quote-in-a-text-tp15529083p15529083.html
>> Sent from the Revolution - User mailing list archive at Nabble.com.
>>
>> ___
>> use-revolution mailing list
>> use-revolution@lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your  
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-revolution
> 
> ___
> use-revolution mailing list
> use-revolution@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
> 
> 

-- 
View this message in context: 
http://www.nabble.com/UPDATE-table-and-quote-in-a-text-tp15529083p15530593.html
Sent from the Revolution - User mailing list archive at Nabble.com.

___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Re: Mashups in REV

[Thomas McGrath III]

Append: As Javascript on Mac and I think "SignedJavaScript" on  
windows??? I think JScript was different than JavaScript.


put alternateLanguages()  on my windows machine
XML
VBScript
VBScript.Encode
Python.AXScript.2
JScript
JScript.Encode
"SignedJavaScript"
"SignedVBScript"

put alternateLanguages() on my macintosh machine
javascript
applescript




On Feb 17, 2008, at 10:08 AM, Thomas McGrath III wrote:


Just a question?


Is anyone using Rev with the current level of Mashups as in Google  
Gadgets etc. It seems to me a library of wrappers could be put in  
that would house a gadget and Rev could handle that? I know Rev  
could handle the as Javascript.



Tom



Thomas McGrath III
[EMAIL PROTECTED]

Mac OS10.5.1 2.4 GHz Intel Core 2 Duo
4 GB 667 MHz DDR2 SDRAM



___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your  
subscription preferences:

http://lists.runrev.com/mailman/listinfo/use-revolution


___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Mashups in REV

[Thomas McGrath III]

Just a question?


Is anyone using Rev with the current level of Mashups as in Google  
Gadgets etc. It seems to me a library of wrappers could be put in that  
would house a gadget and Rev could handle that? I know Rev could  
handle the as Javascript.



Tom



Thomas McGrath III
[EMAIL PROTECTED]

Mac OS10.5.1 2.4 GHz Intel Core 2 Duo
4 GB 667 MHz DDR2 SDRAM



___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Re: selecting lines in a field

[Thomas McGrath III]

Tim,

You might want to change this script to include this line:  or line  
(item i of tHilitedLines) of me = "Clear" -- That way the Clear line  
won't be highlighted in a multi-line highlight either.


As in:

on mouseDown
 local tHilitedLines
 -
 lock screen
 put the hilitedlines of me into tHilitedLines
 if tHilitedLines = 1 then
   set the hilitedlines of me to empty
   -- clear
 else
   repeat with i = the number of items in tHilitedLines down to 0
 if line (item i of tHilitedLines) of me = "---" or line (item i  
of tHilitedLines) of me = "Clear" then

   delete item i of tHilitedLines
 end if
   end repeat
   set the hilitedlines of me to tHilitedLines
 end if
 unlock screen
end mouseDown


HTH TOM
On Feb 17, 2008, at 5:52 AM, Eric Chatonet wrote:ne


Hi Tim,

Assuming a field I put in:

Clear
---
Choice 1
Choice 2
Choice 3
---
Choice 4
Choice 5
etc.

And in the script of the field:

on mouseDown
 local tHilitedLines
 -
 lock screen
 put the hilitedLines of me into tHilitedLines
 if tHilitedLines = 1 then
   set the hilitedLines of me to empty
   -- clear
 else
   repeat with i = the number of items in tHilitedLines down to 1
 if line (item i of tHilitedLines) of me = "---" then
   delete item i of tHilitedLines
 end if
   end repeat
   set the hilitedLines of me to tHilitedLines
 end if
 unlock screen
end mouseDown

Hope this helps.
BTW if the above works, I'm not sure it's really compliant with  
usual guidelines on any platform ;-)


Best regards from Paris,
Eric Chatonet.

Le 17 févr. 08 à 01:43, Timothy Miller a écrit :


Hi,

After all these years, still a beginner... sigh...

A multi-line field. Locked. Focusable. Autohilite and listbehavior  
are true. Normally, I'd turn on "multi-line" and "non-continguous"  
and I'd be good to go. Later on, a script will get the hilitedlines  
of this field.


Except...

I use "---" as a separator, and some lines are deliberately blank,  
for the sake of readability.


If I click on "---" or a blank line, I'd like to leave that line un- 
hilited, without disturbing the other hilitedlines in the field.


--also--

Line 1 = "Clear"

If I click on line 1, I'd like to set all the hilitedlines to  
false, including the hilite of line 1.


I think I know the necessary commands and properties, though one  
can't be certain in my case. I've realized I might need to turn off  
the mulit-line or non-contiguous property and script some field  
behavior manually. I've tried various possibilities by trial and  
error, but I can't seem to put the pieces together. Now I'm stuck.


Please advise.

Thanks in advance,

Tim



Plugins and tutorials for Revolution: http://www.sosmartsoftware.com/
Email: [EMAIL PROTECTED]/



___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your  
subscription preferences:

http://lists.runrev.com/mailman/listinfo/use-revolution


___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Re: UPDATE table and quote in a text

[Mark Schonewille]

Dear Horst,

Single quotes should be escaped the way you do and this should work  
fine. I have seen reports of commands starting with revdb being  
unable to escape single quotes, but this can be solved by using  
revExecuteSQL -- I don't know whether there really is a bug with  
escaping characters, I didn't encounter this problem myself. Make  
sure that you only replace single quotes that are part of the data  
and not the two single quotes that surround the string.


Best regards,

Mark Schonewille

--

Economy-x-Talk Consulting and Software Engineering
http://economy-x-talk.com
http://www.salery.biz

Convert colours between different colour spaces with Color Converter.  
Download at http://economy-x-talk.com/cc.html




Op 17-feb-2008, om 13:24 heeft Horst het volgende geschreven:



Hi there,

A  question to all SQL-Masters:
To update a record in a SQL-Table and to store text which includes  
the "

sign in an SQL-Syntax I learnd, that it is necessary to use

replace quote with "\" & quote in zText
Well, that works fine, but what about The ' sign?

replace "'" with "\'" in zText
seems NOT to work.

Thanks a lot to all of you and best regards

Horst
--
View this message in context: http://www.nabble.com/UPDATE-table- 
and-quote-in-a-text-tp15529083p15529083.html

Sent from the Revolution - User mailing list archive at Nabble.com.

___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your  
subscription preferences:

http://lists.runrev.com/mailman/listinfo/use-revolution


___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

UPDATE table and quote in a text

[Horst]

Hi there, 

A  question to all SQL-Masters:
To update a record in a SQL-Table and to store text which includes the "
sign in an SQL-Syntax I learnd, that it is necessary to use

replace quote with "\" & quote in zText
Well, that works fine, but what about The ' sign?

replace "'" with "\'" in zText
seems NOT to work. 

Thanks a lot to all of you and best regards

Horst
-- 
View this message in context: 
http://www.nabble.com/UPDATE-table-and-quote-in-a-text-tp15529083p15529083.html
Sent from the Revolution - User mailing list archive at Nabble.com.

___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

cgi load & access speed

[Richard Miller]

This may not have any consequence at all, but it's hard to test, so I  
wanted an opinion or two.


My cgi Rev stack (I'm using only one) has "ballooned" up to about  
350k... certainly not large, but I could reduce it to 100k or so by  
moving a number of fields (which contain html formatting data) to  
text files. Is there any reason to think that the user's experience  
when accessing a cgi link will be noticeably quicker if the stack is  
100k vs 350k? I realize I'm probably talking about a savings of less  
than one second, at best, but with constant accessing to the server  
by numerous users, would this be worth making the change?


Thanks.
Richard Miller
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Re: selecting lines in a field

[Eric Chatonet]

Hi Tim,

Assuming a field I put in:

Clear
---
Choice 1
Choice 2
Choice 3
---
Choice 4
Choice 5
etc.

And in the script of the field:

on mouseDown
  local tHilitedLines
  -
  lock screen
  put the hilitedLines of me into tHilitedLines
  if tHilitedLines = 1 then
set the hilitedLines of me to empty
-- clear
  else
repeat with i = the number of items in tHilitedLines down to 1
  if line (item i of tHilitedLines) of me = "---" then
delete item i of tHilitedLines
  end if
end repeat
set the hilitedLines of me to tHilitedLines
  end if
  unlock screen
end mouseDown

Hope this helps.
BTW if the above works, I'm not sure it's really compliant with usual  
guidelines on any platform ;-)


Best regards from Paris,
Eric Chatonet.

Le 17 févr. 08 à 01:43, Timothy Miller a écrit :


Hi,

After all these years, still a beginner... sigh...

A multi-line field. Locked. Focusable. Autohilite and listbehavior  
are true. Normally, I'd turn on "multi-line" and "non-continguous"  
and I'd be good to go. Later on, a script will get the hilitedlines  
of this field.


Except...

I use "---" as a separator, and some lines are deliberately blank,  
for the sake of readability.


If I click on "---" or a blank line, I'd like to leave that line un- 
hilited, without disturbing the other hilitedlines in the field.


--also--

Line 1 = "Clear"

If I click on line 1, I'd like to set all the hilitedlines to  
false, including the hilite of line 1.


I think I know the necessary commands and properties, though one  
can't be certain in my case. I've realized I might need to turn off  
the mulit-line or non-contiguous property and script some field  
behavior manually. I've tried various possibilities by trial and  
error, but I can't seem to put the pieces together. Now I'm stuck.


Please advise.

Thanks in advance,

Tim



Plugins and tutorials for Revolution: http://www.sosmartsoftware.com/
Email: [EMAIL PROTECTED]/



___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution