Re: HTML Tag Cleaner Fails

2006-08-08 Thread Bill Marriott
You keep missing the obvious. Whether you call it HTML or FauxML or whatever 
you like...

 is defined to specify boldface text.
 is defined to specify paragraphs
 is defined to indicate metadata that is NOT part of the contents.
 tags are defined to be ignored.

Very simple concept, consistently applied, and not surprising or bizarre in 
the least.

Dar Scott wrote:
> I don't follow this logic:
>
>TextEdit can render HTML.
>TextEdit removes title.
>Rev fields remove title.
>Therefore...
>Rev field can render HTML.



___
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: Codebase Database API

2006-08-08 Thread Ruslan Zasukhin
On 8/9/06 6:52 AM, "Robert Sneidar" <[EMAIL PROTECTED]> wrote:

>> Bob, would the ODBC connection work for you here?
>> 
>> Mark
> 
> I suppose it would. I didn't look very far, but I searched for ODBC
> in the A-Z help section and came up empty. I will look again. I think
> Codebase has ODBC support.

Robert,

ODBC is based on SQL actually.

You dream avoid SQL, so ODBC is not a way for you in this case.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]


___
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


VS: Purchasing Valentina

2006-08-08 Thread Sakari

This is all I needed to know. A happy customer and the schedule of getting
the keys. Thank you Dave!

Sakari

>I recently purchased a license. The response (with all registration  
>keys) was extremely fast.
>
>I noticed that Ruslan has responded to your mail already. He responds  
>with the same speed (or faster) to technical queries too. You'll be  
>amazed.
>
>Cheers
>Dave

___
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: Codebase Database API

2006-08-08 Thread Robert Sneidar
On Aug 8, 2006, at 5:39 PM, [EMAIL PROTECTED]  
wrote:



Bob, would the ODBC connection work for you here?

Mark


I suppose it would. I didn't look very far, but I searched for ODBC  
in the A-Z help section and came up empty. I will look again. I think  
Codebase has ODBC support.


Bob Sneidar
IT Manager
Logos Management
Calvary Chapel CM



___
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: Problems using Send and Functions with 2 parameters

2006-08-08 Thread Ian McKnight

On 09/08/06, Jim Ault <[EMAIL PROTECTED]> wrote:


Why not do the following?

insert the script of group analogClock into back

Now all the scripts are in the message path and you don't need 'send' or use
value, etc.


Ah! I have known about backscripts and frontscripts for some time but
never really understood their utility. Thanks.



Further, write your first handler to know what to do...
moveClockHands "random", 15,2

will tell it to call the random function using 15 & 2, then move the hands



Yes, on reflection I thinks this is perhaps the best course. I was
caught up with making my initial solution work - come what may - to
the exclsion of some simplicity. Still I have learned some new tricks
along the way and received some great help in the process.

Thank you again.


--
Regards

Ian

===
Ian McKnight

[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


Re: HTML Tag Cleaner Fails

2006-08-08 Thread Dar Scott


On Aug 8, 2006, at 5:52 PM, Mark Schonewille wrote:




bar


Not that the title tags are in the body and still not rendered by  
TextEdit. However, if I replace "title" by "foo", "bar" is visible  
in TextEdit. Revolution does the same, if I set the htmlText of a  
field to above html code.


I don't follow this logic:

   TextEdit can render HTML.
   TextEdit removes title.
   Rev fields remove title.
   Therefore...
   Rev field can render HTML.

Try this (similar to above):



a   b


TextEdit will render the multiple spaces correctly as a single  
space.  Revolution fields will not.


That is because Revolution does not render HTML.  It does not even try.

Dar Scott

___
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: Problems using Send and Functions with 2 parameters

2006-08-08 Thread Jim Ault
On 8/8/06 1:58 PM, "Ian McKnight" <[EMAIL PROTECTED]> wrote:
> Thanks Dar - I revisited your suggestion for a custom command and made
> the handler work.
> 
> A function seemed more appropriate to what I wanted to do as it
> returned a value (thats why I had thought of using the 'get' command
> to get access to the RESULT and it works) but  it's as if the send
> command only accepts one or no paramenters in situations like this.
> 
> send "moveClockHands randomTime(15,2)" to group "analogClock" doesn't work
> 
> but send "moveClockHands randomTime(15)" to group "analogClock"and
> send "moveClockHands randomTime()" to group "analogClock" both work
> 
> My solution was to convert the function randomTime to a custom command
> but retain its RETURN command.
> 
> This gives the following 2 stage solution
> 
> send "randomTime(15,2)" to group "analogClock"
> send "moveClockHands the result" to group "analogClock"
> 

Why not do the following?

insert the script of group analogClock into back

Now all the scripts are in the message path and you don't need 'send' or use
value, etc.

You could do this on openstack,preopenstack,
showAnalogClock, enableAnalogClock. opencard, etc

if you do...

on returnValuesToCallingHandler pFirstFactor, pSecondFactor
   return ((pFirstFactor*10) + pSecondFactor)
end returnValuesToCallingHandler

on processData
   set the itemdel to tab
   returnValuesToCallingHandler 15, 2
   put the result into ansFromAbove
   -- do more work
end processData 

Further, write your first handler to know what to do...
moveClockHands "random", 15,2

will tell it to call the random function using 15 & 2, then move the hands

Hope this helps.


Jim Ault
Las Vegas




___
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


IRC Client

2006-08-08 Thread Bill Marriott
I know there was a contest a while back to write an IRC client in Rev... Did 
anything ever come of that? Does anyone know where one might exist? 



___
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: internal SQL queries

2006-08-08 Thread Jim Ault
Yes, filter is very fast, but not always the fastest, yet rarely far off.

You could do the variable column filter string, perhaps as

put cr & coolDataTable & tab into foundLines
put "*"&tab into C
get item 1 to colNeeded-1 of (C&C&C&C&C&C&C&C&C&C&C&C&C)
filter foundLines with (it & IDnum & tab&"*")


Jim Ault
Las Vegas

On 8/8/06 1:34 PM, "Josh Mellicker" <[EMAIL PROTECTED]> wrote:

> I thought of filter, but the problem is the ID column always has to
> be the first one, right?
> 
> That's fine for data fields where there is only one ID column, but
> there might be several...
> 
> 
> I've been thinking one could ascertain the column number of the
> desired ID column, then make a certain number of tabs, like:
> 
> put itemOffset(locatorColumnHeader,p) into locatorColNo
> 
> 
> 
> REPEAT locatorColNo -1 times
>put tab & "*" after theNumberOfTabsNeededToGetToDesiredColumn
> END REPEAT
> 
> Then filter with
> 
> theNumberOfTabsNeededToGetToDesiredColumn & locatorValue & tab & "*"
> 
> 
> something like that...
> 
> -
> 
> So FILTER is definitely faster than a REPEAT loop going through all
> lines of a variable, right?
> 
> (because FILTER has to look at every line anyway, right?)
> 
> 
> 
> On Aug 7, 2006, at 12:51 PM, Jim Ault wrote:
> 
>> I would try this approach, although not the only one:
>> ---
>> get cr & whichDataFld & tab
>> filter it with ( cr & locatorColNo &tab &"*")
>> -- now you have a list of one line
>> -- this filter pattern will insure only column 1 and
>> --  whole matches between the cr and tab..
>> -- no need to redo your IDs
>> --the last tab is appended to 'it' since you could have a last line
>> table
>> entry with only an ID and you would want to located it.  It is the
>> last line
>> and has empty values, perhaps by mistake.
>> 
>> if the number of lines in it > 1 then
>>answer "Multiple IDs found "& (the number of lines in it)
>>return empty
>> else if the number of lines in it = 0 then
>>answer "ID " & locatorColNo & "  could not be found"
>>return empty
>> else
>>   return item dataColNo of it
>> end if
>> --
>> Jim Ault
>> Las Vegas
>> 
>> On 8/7/06 11:47 AM, "Josh Mellicker" <[EMAIL PROTECTED]> wrote:
>> 
>>> Here is a function I wrote to retrieve data from a table field.
>>> 
>>> All it needs is:
>>> 
>>> whichDataFld -  the long name of the data field
>>> locatorColumnHeader - assumes the top row is a header row with the
>>> column name, this is which column to use to locate the correct row
>>> locatorValue - this is the value in the column with the header
>>> "locatorColumnHeader" that tells you you have the right row
>>> headerOfDataToGet - this is the column containing the data you want
>>> 
>>> 
>>> FUNCTION getDataFromDataFld
>>> whichDataFld,locatorColumnHeader,locatorValue,headerOfDataToGet
>>>  put the text of whichDataFld into p
>>>  set itemdel to tab
>>>  put itemOffset(locatorColumnHeader,p) into locatorColNo
>>>  put itemOffset(headerOfDataToGet,p) into dataColNo
>>>  REPEAT with x = 2 to the number of lines of p
>>>  IF item locatorColNo of line x of p = locatorValue THEN exit
>>> REPEAT
>>>  END REPEAT
>>>  return item dataColNo of line x of p
>>> END getDataFromDataFld
>>> 
>>> 
>>> 
>>> So if your table field is:
>>> 
>>> ID name color food
>>> 5Kenblue cheese
>>> 7   Jerry  greenpizza
>>> 21Sarah  redsushi
>>> 
>>> 
>>> you could say
>>> 
>>> put getDataFromDataFld(whichDataFld,ID,7,"food") into tData
>>> 
>>> RESULT: "pizza"
>>> 
>>> 
>>> What I don't like about this handler is that it must scan every line
>>> to find the right row... there must be a faster way to write this,
>>> no?
>>> 
>>> 
>>> 
>>> 
>>> On Jul 21, 2006, at 1:01 PM, Viktoras Didziulis wrote:
>>> 
 Dear group,
 
 is it possible to query [tab] delimited data stored in fields or
 containers
 within a stack using SQL? e.g. without any external database
 engine or
 database files or connections...
 
 All the best!
 Viktoras
 ___
 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
>> 
>> 
>> ___
>> 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: HTML Tag Cleaner Fails

2006-08-08 Thread Stephen Barncard
Just a suggestion - Derek Bump (Dreamscape Software) did some 
experimenting with css and rev's htmltext a couple of years ago. You 
might want to check it out.


The simple code there did help quite a bit with translating to and 
from (especially to) real web pages and seemed to scale font sizes 
pretty well.


http://www.dreamscapesoftware.com/products/htmltocss.zip


I went in and tweaked a few things for my use on my copy, but it's 
quite useful as is.

--
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: HTML Tag Cleaner Fails

2006-08-08 Thread Dar Scott


On Aug 8, 2006, at 4:51 PM, Dar Scott wrote:


On Aug 8, 2006, at 1:18 PM, [EMAIL PROTECTED] wrote:

There would be no assumption that
a property named "taggedText" would render html pages.


I agree


Whoops.  I think the partial quote might misrepresent Roger.  There  
is an "if" in the previous sentence:


I think that RunTime made a bad choice in naming that property  
"htmlText".
If it was never intended to render the full html spec, then it  
should have
been named something like "taggedText". There would be no  
assumption that

a property named "taggedText" would render html pages. That's my two
cents.


Dar

___
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: HTML Tag Cleaner Fails

2006-08-08 Thread Mark Schonewille

Dar,

No, I opened an html page with the following code in TextEdit while  
not ignoring RTF commands (isn't it funny that TextEdit uses the same  
option to en/disable HTML and RTF?):




bar


Not that the title tags are in the body and still not rendered by  
TextEdit. However, if I replace "title" by "foo", "bar" is visible in  
TextEdit. Revolution does the same, if I set the htmlText of a field  
to above html code.


Best,

Mark

--

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

Download ErrorLib at http://economy-x-talk.com/developers.html and  
get full control of error handling in Revolution.




Op 9-aug-2006, om 1:06 heeft Dar Scott het volgende geschreven:



On Aug 8, 2006, at 5:22 AM, Mark Schonewille wrote:

Apple's TextEdit application behaves exactly like Revolution  
fields in this respect.


Are you looking at clipboardData["html"]?

I don't think TextEdit is creating bad HTML.  I think Revolution is  
using the same function to create htmlText as it does to create  
clipboardData["html"]?


Dar


___
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 set table column width in table fields

2006-08-08 Thread Mark Schonewille

Equal column widths:

set the tabstops of fld 1 to 250

different column widths:

set the tabstops of fld 1 to 24,250,80,80,512


Best,

Mark

--

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

Download ErrorLib at http://economy-x-talk.com/developers.html and  
get full control of error handling in Revolution.




Op 9-aug-2006, om 1:14 heeft David ResSeguie het volgende geschreven:


Hi,
Can anyone tell how to change the width of columns in table fields,  
so that the contents fit?

Thanks,
David



___
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


How do I set table column width in table fields

2006-08-08 Thread David ResSeguie

Hi,
Can anyone tell how to change the width of columns in table fields, so 
that the contents fit?

Thanks,
David

David ResSeguie
Information Services Manager/Ad Co-ordinator
Sundance Natural Foods
748 E. 24th Avenue
Eugene, OR 97405-2936
541 343-9142
541 343-1519 office
541 342-1660 fax
541 687-3010 pager
Store and Office mailto:[EMAIL PROTECTED]
Grocery Store web site http://sundancenaturalfoods.com
Sundance Wine Cellars web site http://orwines.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: HTML Tag Cleaner Fails

2006-08-08 Thread Dar Scott


On Aug 8, 2006, at 2:58 PM, Bill Marriott wrote:


Seriously, this is a stretch.


If people really believe that, where is the outcry over the handling  
of white space?


If you really believe that, then why haven't you submitted such bugs  
to BZ?


If you try submitting a white space bug (I thought one was submitted,  
but that may have been before BZ), what are the chances of it being  
marked "not a bug"?  If you think high, then you know in your heart  
that htmlText is not HTML.


Dar Scott

___
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: Problems using Send and Functions with 2 parameters

2006-08-08 Thread Dar Scott


On Aug 8, 2006, at 1:01 PM, Sean Shao wrote:


put value("randomTime(5,2)", group "analogClock")


There are some limitations to value() when working with sending  
arrays and the result of arithmetic.  At times arrays are simply  
empty values and numbers have numberFormat applies with possible  
resulting loss of info.


Assuming I didn't goof in my tests, it is like this (with  
corresponding send info):


***
value()
  array number
parameter OKOK
resultOKfail
***

value(, )
  array number
parameter -- --
resultfail   OK
***

send to 
 array number
parameterfail  fail
result   OKOK
***
send to  in time
 array number
parameterfail  fail
result   ----


This is bug 699 which RunRev has changed to an enhancement request.

Dar Scott

___
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: HTML Tag Cleaner Fails

2006-08-08 Thread Dar Scott


On Aug 8, 2006, at 5:22 AM, Mark Schonewille wrote:

Apple's TextEdit application behaves exactly like Revolution fields  
in this respect.


Are you looking at clipboardData["html"]?

I don't think TextEdit is creating bad HTML.  I think Revolution is  
using the same function to create htmlText as it does to create  
clipboardData["html"]?


Dar



___
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: HTML Tag Cleaner Fails

2006-08-08 Thread Dar Scott


On Aug 8, 2006, at 1:18 PM, [EMAIL PROTECTED] wrote:


There would be no assumption that
a property named "taggedText" would render html pages.


I agree.  -- Dar
___
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: HTML Tag Cleaner Fails

2006-08-08 Thread Dar Scott


On Aug 8, 2006, at 2:58 PM, Bill Marriott wrote:



What do you base this assumption on?


Oh, I dunno, the name of the function beginning with "HTML?" The
documentation which states, "Specifies the contents of a field,  
with its
text formatting represented as HTML tags and special characters  
represented

as HTML entities."


Look at what that actually says.

It says "with its text formatting represented as HTML tags".

It never ever says the field displays HTML.

It is clear that htmlText was never intended to have to do with  
HTML.  What is the lowest most functionality of HTML?  The handling  
of white space.  The htmlText property does not do that in output or  
input.  Metacard and RunRev were clear some time ago in that this is  
not a bug.


BUT, I think it would be a good idea to expand htmlText (when  
fetched) to be a string that would display the same content (or very  
similar) content when dumped into an HTML display.  I suspect that  
anything that can be displayed in a field can be represented in  
HTML.  This enhancement will probably break scripts, though.  (Links  
have completely separate semantics, though, and will not transfer  
completely.)



Links are handled.


They are?

There can be no doubt that the intention of the function is to a)  
export the

styled content of a text field as faithfully as possible using HTML


A candidate for an enhancement request.  I'd vote for this.  I'm not  
sure how it should handle dontWrap.



and b)
to render incoming HTML as properly as possible.


Nonsense.  It can't render HTML.

No, it's exactly the right thing to do if you're implementing a  
function

named HTMLText() that is designed to process HTML tags at best-effort.


It is clear from its behavior that that was not what it was designed  
for.  No effort was made to make that happen.  Would you have  
released htmlText the way it is if you made it to render HTML?


So removing  is bizarre.  Somebody complained or asked for it  
and it was tacked on.


Dar Scott


___
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: SQL, shared access to db // Codebase Database API

2006-08-08 Thread Ruslan Zasukhin
On 8/8/06 11:36 PM, "Robert Sneidar" <[EMAIL PROTECTED]> wrote:

> My Holy Grail for my project would be if a driver could be written,
> perhaps for something like a Codebase server which can access xBase
> tables directly, where I could open shared tables and indexes, and
> then peruse through the data in precicely the same way as I did in
> Foxpro. I personally think t his would be very advantageous for
> Revolution in general, as there must be a lot of users who don't want
> to learn SQL, they just want to:

> open a table
> sort it
> find some data
> stuff some variables
> get user input
> check for data validity
> lock the record/table
> check that the record has not been updated
> write the data back
> unlock the table.

Robert, all this present right now in Valentina 2.
And let me repeat, IMHO in better way then Fox did have.

> All in a shared environment. (meaning multiple users can open the
> file at once)
 
> In SQL sorting, finding, and rewriting data in any kind of complex
> way forces the developer to learn complex SQL syntax, which is what
> Revolution promises to avoid.

* When Revolution did promise this?
RevDB is built around SQL as I see.

* why you say SQL it is complex. It is s simple actually.

SELECT f1, f2, f3
FROM T1
WHERE f1 > 5 and f1 < 25 or f3 LIKE 'Pet%'
ORDER BY f2 Desc

4 lines of code on natural English.
Try this write in API style. Will be about 10-20 lines of code.
As for Fox so for Valentina's API style.

And the main advantage of SQL over API style is -- SQL was invented for
access to REMOTE dbs.

Above SQL is just few bytes which will be sent via inet. All work is done on
SERVER, and back you get data. Now tell me please scenario for API style?
You must issue many commands between client and server computers, load to
client may be even indexes, do calculations on client side and send it to
server

SQL wins on client-server environment. No doubts here.


> Valentina seems to provide this using it's API methodology,

right

> but I was given to understand that the files
> created using the non-sql method are not opened shared.

Hmm, not right.

> This is  critical for my application. I suppose I can create a stack that can
> open tables and return data to the user's runtime apps, but I am  still
> bottlenecking the traffic, and any request for a lot of data  will inevitably
> bring other users to a halt.

You have told me about Code Base SERVER. Right? So you are ready to use
SERVER? I.e. You are ready to use Client Server model in your app. Right?

Then you talk NOT about SHARED access to db files,
but about CLIENT - SERVER access.

And Valentina is able do this with help of V4REV and Valentina Server.

What we do not support in Valentina and never wont - is SHARED ACCESS.

SHARED ACCESS means that
* db files are on some server computer,
* there is no SERVER application
* client applications open db files in shared mode.

This is much slower then client/server model.
Mainly because in this way not exists cache on server side.

 
>   I can learn SQL alright, but time is my enemy. Already people are
> talking about "the future of SBT" around the office, meaning they
> want to get rid of it. I want to port it and make it what they want
> it to be. I am stuck at the database model, and I need a solution
> soon. If Valentina can provide a non-sql way to access tables and
> indexes directly, in a relational model, I would be very interested
> in knowing how. Since I already purchased Valentina, I am willing to
> give it another go.

Robert, 

In Valentina for Revolution Examples folder exists API_Way folder,
Where we have examples more than in SQL way. :)

Please check this API example.
They show all major operations.

-
About indexes:

to create index with some complex expression, you need create in the
table so called Method = aka Calculated field = aka Virtual field.

E.g. On Valentina list present Jon (jda), he make in table index that join
all other fields, and mark it as indexed by words. In this way he get
ability do search by all fields of table. It is very reach feature. By
features exactly like as in Fox.

Also you can note that exists RAM tables - for tmp data.

Also you can create these Methods marked as Temporary. Then they will not be
stored into system tables.

In 2.4 we have add also ability to create in a Table - Temporary field. Nice
thing here is again - it is not stored into sys tables, and its data are
stored on .tmp volume. So in case of any failure, you main .dat file is not
touched at all.   


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]


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

Re: HTML Tag Cleaner Fails

2006-08-08 Thread Dan Shafer

Sorry I ever mentioned I found it bizarre. Nothing we can do about it. It is
what it is.

I don't use htmlText because it's too limited and limiting.

Dan
___
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: Problems using Send and Functions with 2 parameters

2006-08-08 Thread Dar Scott


On Aug 8, 2006, at 2:58 PM, Ian McKnight wrote:


Thanks Dar - I revisited your suggestion for a custom command and made
the handler work.

A function seemed more appropriate to what I wanted to do as it
returned a value (thats why I had thought of using the 'get' command
to get access to the RESULT and it works) but  it's as if the send
command only accepts one or no paramenters in situations like this.


Yeah, I don't think sending a 'get' is supported.

send "moveClockHands randomTime(15,2)" to group "analogClock"  
doesn't work


This should eval randomTime(15,2) before sending.  If it is in your  
message path, you will be OK.


I made something in the path, but I get something wrong, too.


but send "moveClockHands randomTime(15)" to group "analogClock"and
send "moveClockHands randomTime()" to group "analogClock" both work


weird.  Something is amiss.

Though, I would consider the 'get' as outside of what is intended,  
this is a bug.



My solution was to convert the function randomTime to a custom command
but retain its RETURN command.

This gives the following 2 stage solution

send "randomTime(15,2)" to group "analogClock"


For a command, remove the parens.  Are you working with an old  
version?  What you have will create a single parameter for the  
randomTime command.



send "moveClockHands the result" to group "analogClock"


Since things are acting weird, try

send "randomTime 15,2" to group "analogClock"
get the result
send "moveClockHands it" to group "analogClock"

I tend to keep the send parameter to a single command plus a comma  
delimited list of variable parameters, like this:


send "advancePen m,n,x" ...

This looks like a good place for a setProp in the group, if  
'moveClockHands' will set the time rather than advance some amount.


Dar Scott



___
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: API Style + Navigational Model // was Codebase Database API

2006-08-08 Thread Ruslan Zasukhin
On 8/8/06 11:36 PM, "Robert Sneidar" <[EMAIL PROTECTED]> wrote:

> 3. A typical methodology of Visionpoint 2000 is to set an index
> (ordering the table), seek for a record, and then stepping through
> the table one record at a time, or issuing some kind of statement
> that uses REST (from the current point through the rest of the table)
> and a WHILE clause or FOR clause which are sometimes themselves
> complex expressions.

> But I am working with the actual table data
> directly, and so am not limited by the constraints of a cursor.

> To  switch to SQL would mean rewriting my data access methodologies  almost
> from scratch, and that through thousands of code module files.  The task is
> daunting.

Well, 

In Valentina 2 this methodology also is supported via

ArraySet - that keep your ordered records
and
Table.RecID = ArraySet.Nth item

We do not have like FoxPro - current filter on the whole table,
Because you can have only one such filter

Using ArraySets you are free to have several such sets in the same time..


--
>From other side:

I do not see where SQL way beat you:

curs = db.SqlSelect( "SELECT * FROM T ORDER BY f5" )

Now you have virtually table sorted by f5 and its index.

Do your steps one by one ... Where is difference in methodology?


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]


___
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: Codebase Database API

2006-08-08 Thread Ruslan Zasukhin
On 8/8/06 11:36 PM, "Robert Sneidar" <[EMAIL PROTECTED]> wrote:

Robert,

This question can be interesting to all, so I will CC it to both lists.

> 2. Although virtually every SQL solution I have seen declares it is a  true
> Relational database, I have seen NOTHING which refers to  creating relations
> between tables (except perhaps in Valentina) and  in Foxpro these relations
> are created on the fly, again using  existing indexes created with the complex
> expressions briefly  described above.

Let me clarify here.

Relational database simple uses Tables (aka Relations).

Pure Realtional Database model do not have indexes, and do not have anything
between tables.

Relation between records of 2 tables, you establish simply BY VALUE.

Later was invented such feature as FOREING KEY, and it is now in SQL
standard.

Yes, Valentina 2 extend this feature - FK and name it as LINK,
as well as add two other kind of links to link records.

So me point, that DBMS you mention above really have right say that they
support Relational model.

Valentina support Object-Relational model.

FoxPro - was relational, but with a lots of low level API methods, which did
allow you control db without SQL. In fact, I remember times when FoxPro was
without any SQL..Or may be they was other DBF dialect (Clipper?)

 
> I have gathered I think, that sub-queries, or joins  are the method for doing
> this, but again, what kind of performance hit do I take?
> 
> And to do this I will have to learn the very decidedly  non-friendly SQL join
> syntax.

Again to be fair...I not think that join is so unfriendly.

And I can say that without joins and SQL to get the same result you will
need write much more code in Fox, or even in Valentina 2 using its new API
way. But in Valentina 2 this API way may result in some performance
benefits..

So I think here is not so black and white. Exists trade-off

Btw, just in case I give you this WIKI urls on few articles and LINK
feature. 

http://www.valentina-db.com/dokuwiki/doku.php?id=paradigma:public:en:documen
tation:vkernel:vlink:vlink


Here about Database models:

http://www.valentina-db.com/dokuwiki/doku.php?id=paradigma:public:en:documen
tation:articles:articles



Note, that in Valentina 2 we have introduce reach API, which allow control
database totally without SQL.

I claim that we have give new life to Navigational Model.

If somebody have work with dbVista - one on famous db with Naviational
model, will see how many cool things we have resolve in Valentina 2.

But I cannot say that Navigational Model is best for every task. For example
GROUP BY task is nightmare for it.

And this is why it is so great that Valentina give you way easy use ANY form
SEVERAL supported database models in your code in the same time!


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]


___
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: HTML Tag Cleaner Fails

2006-08-08 Thread Bill Marriott
Dar Scott wrote:
> You are assuming that a field and htmlText has something to do with  HTML.
>
> What do you base this assumption on?

Oh, I dunno, the name of the function beginning with "HTML?" The 
documentation which states, "Specifies the contents of a field, with its 
text formatting represented as HTML tags and special characters represented 
as HTML entities." And the detailed list of supported, unsupported, and 
custom HTML tags which follows?

Seriously, this is a stretch.

Consider the Rev text field the equivalent of a WAP 1.0 browser, or 
something like that. It is a bonafide HTML presentation, to the extent of 
what Rev text fields are capable of rendering. A relatively complete set of 
text formatting is available. Images are incorporated as appropriate. Links 
are handled. And so on. I assume the only reason the rendering is not more 
complete are the limitations of the field control and Rev itself.

There can be no doubt that the intention of the function is to a) export the 
styled content of a text field as faithfully as possible using HTML and b) 
to render incoming HTML as properly as possible. The  element is 
specifically defined in the HTML specification: "The TITLE element is not 
considered part of the flow of text."

> Stripping  is bizarre.

No, it's exactly the right thing to do if you're implementing a function 
named HTMLText() that is designed to process HTML tags at best-effort. 



___
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: Problems using Send and Functions with 2 parameters

2006-08-08 Thread Ian McKnight

Hi

Thanks Dar - I revisited your suggestion for a custom command and made
the handler work.

A function seemed more appropriate to what I wanted to do as it
returned a value (thats why I had thought of using the 'get' command
to get access to the RESULT and it works) but  it's as if the send
command only accepts one or no paramenters in situations like this.

send "moveClockHands randomTime(15,2)" to group "analogClock" doesn't work

but send "moveClockHands randomTime(15)" to group "analogClock"and
send "moveClockHands randomTime()" to group "analogClock" both work

My solution was to convert the function randomTime to a custom command
but retain its RETURN command.

This gives the following 2 stage solution

send "randomTime(15,2)" to group "analogClock"
send "moveClockHands the result" to group "analogClock"

Thanks to everyone for your help.

Regards
___
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: internal SQL queries

2006-08-08 Thread Josh Mellicker
I thought of filter, but the problem is the ID column always has to  
be the first one, right?


That's fine for data fields where there is only one ID column, but  
there might be several...



I've been thinking one could ascertain the column number of the  
desired ID column, then make a certain number of tabs, like:


put itemOffset(locatorColumnHeader,p) into locatorColNo



REPEAT locatorColNo -1 times
  put tab & "*" after theNumberOfTabsNeededToGetToDesiredColumn
END REPEAT

Then filter with

theNumberOfTabsNeededToGetToDesiredColumn & locatorValue & tab & "*"


something like that...

-

So FILTER is definitely faster than a REPEAT loop going through all  
lines of a variable, right?


(because FILTER has to look at every line anyway, right?)



On Aug 7, 2006, at 12:51 PM, Jim Ault wrote:


I would try this approach, although not the only one:
---
get cr & whichDataFld & tab
filter it with ( cr & locatorColNo &tab &"*")
-- now you have a list of one line
-- this filter pattern will insure only column 1 and
--  whole matches between the cr and tab..
-- no need to redo your IDs
--the last tab is appended to 'it' since you could have a last line  
table
entry with only an ID and you would want to located it.  It is the  
last line

and has empty values, perhaps by mistake.

if the number of lines in it > 1 then
   answer "Multiple IDs found "& (the number of lines in it)
   return empty
else if the number of lines in it = 0 then
   answer "ID " & locatorColNo & "  could not be found"
   return empty
else
  return item dataColNo of it
end if
--
Jim Ault
Las Vegas

On 8/7/06 11:47 AM, "Josh Mellicker" <[EMAIL PROTECTED]> wrote:


Here is a function I wrote to retrieve data from a table field.

All it needs is:

whichDataFld -  the long name of the data field
locatorColumnHeader - assumes the top row is a header row with the
column name, this is which column to use to locate the correct row
locatorValue - this is the value in the column with the header
"locatorColumnHeader" that tells you you have the right row
headerOfDataToGet - this is the column containing the data you want


FUNCTION getDataFromDataFld
whichDataFld,locatorColumnHeader,locatorValue,headerOfDataToGet
 put the text of whichDataFld into p
 set itemdel to tab
 put itemOffset(locatorColumnHeader,p) into locatorColNo
 put itemOffset(headerOfDataToGet,p) into dataColNo
 REPEAT with x = 2 to the number of lines of p
 IF item locatorColNo of line x of p = locatorValue THEN exit
REPEAT
 END REPEAT
 return item dataColNo of line x of p
END getDataFromDataFld



So if your table field is:

ID name color food
5Kenblue cheese
7   Jerry  greenpizza
21Sarah  redsushi


you could say

put getDataFromDataFld(whichDataFld,ID,7,"food") into tData

RESULT: "pizza"


What I don't like about this handler is that it must scan every line
to find the right row... there must be a faster way to write this,  
no?





On Jul 21, 2006, at 1:01 PM, Viktoras Didziulis wrote:


Dear group,

is it possible to query [tab] delimited data stored in fields or
containers
within a stack using SQL? e.g. without any external database  
engine or

database files or connections...

All the best!
Viktoras
___
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



___
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: Codebase Database API

2006-08-08 Thread mfstuart

Bob, would the ODBC connection work for you here?

Mark
-- 
View this message in context: 
http://www.nabble.com/Codebase-Database-API-tf2069423.html#a5713445
Sent from the Revolution - User forum 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: HTML Tag Cleaner Fails

2006-08-08 Thread Peter T. Evensen
Unless I misunderstand what you are saying, setting the htmlText of a field 
*should* process the (Revolution-supported) HTML in the text, otherwise 
setting the htmlText of a field would not be useful.  The whole point is 
being able to use the supported html tags to mark up text and then have it 
displayed properly in a field.  If you look at the documentation entry for 
htmlText, it is clear that this is exactly what this property is intended 
to do.


If you are saying it shouldn't process unsupported HTML tags, that is 
something different.  I'm not sure what it's behavior is.


I use htmlText in a project to strip out html by setting the htmlText of a 
hidden field and then getting the text of that field (instead of 
htmlText).  This neatly strips out the tags.  I am, however, only using the 
Revolution-supported tags in my text. I don't know why it is striping out 
text between  the  tags.


At 01:45 PM 8/8/2006, you wrote:


On Aug 8, 2006, at 4:56 AM, Bill Marriott wrote:


Except that  has a defined, special meaning that Rev knows
about --
which is to specify the title of a document -- and that is by
definition
distinct from the content. The  tag however, is undefined.

I believe that it's appropriate to "strip" out the information
between title
tags and to preserve the information between "foo" tags.

By reference, see:

http://www.w3.org/MarkUp/html3/HTMLandSGML.html


That is an HTML document.

You are assuming that a field and htmlText has something to do with
HTML.

What do you base this assumption on?

It is clear that htmlText is a view that is html-like.  There is no
reason to expect it to process HTML when it is dumped into the property.

(Now, I do think htmlText when retrieved might be closer to HTML,
such as the handling of white space, but that is a different issue.
Maybe it is even possible for retrieved htmlText to closely render in
HTML.)

There is no reason to expect a field to process HTML when it is
dumped into the field's htmlText property.

Stripping  is bizarre.

Dar Scott
___
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


Peter T. Evensen
http://www.PetersRoadToHealth.com
314-629-5248 or 888-682-4588 



___
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


An:New stacks uploaded to Rev Online

2006-08-08 Thread Glenn E. Fisher

All,

I have uploaded two stacks to Rev OnLine for your inspection.

Catagory   Stack

Utilities FileUtility

Games WarOfRoses

The FileUtility stack allows for you to develop tools to be attached  
together in a layout that can operate on files in folders on your  
disks.  It's pretty simple now but has a future.


The Game is an educational and historical simulation of the War of  
the Roses of 15th century England.


Enjoy,
Glenn
--
Glenn E. Fisher University of Houston - Retired
22402 Diane Dr. Spring, Tx 77373
[EMAIL PROTECTED]   http://www.uh.edu/~fisher
http://home.houston.rr.com/thegefishers/
http://homepage.mac.com/gefisher


___
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: Problems using Send and Functions with 2 parameters

2006-08-08 Thread Dar Scott


On Aug 8, 2006, at 8:24 AM, Ian McKnight wrote:


get randomTime(5,2)
put the result




send "get randomTime(5,2)" to group "analogClock"
put the result


It seems Rev has a limited compiler when it comes to 'send'.  I'm not  
even sure what the meaning of 'get' would be in the above situation.


Your best bet would be to go with something more traditional.

First decide whether you want a function or a custom command.

For a function you would do this:

put randomTime(5,2)
  -- or
get randomTime(5,2)
put it

(You might be able to use value() to eval in the group, but that is  
to distracting for this email.)


For a custom command (made with 'on') you would do this:

randomTime 5,2 -- No Parens!
put the result

send "randomTime 5,2" to group "analogClock"
put the result -- will not work with 'in time'

Normally, 'the result' is used for errors, but it doesn't have to  
be.  It is a handy way to get results from objects you send to.  You  
can also return values with globals or with getProp.


The description of the function sounds like something that should be  
a function, so I'd wonder why it isn't in the message path of the  
object that needed it.  If it is used by a control in the group, then  
the group is in the message path.


Dar Scott

___
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: HTML Tag Cleaner Fails

2006-08-08 Thread Roger . E . Eller
Dar Scott wrote:
> You are assuming that a field and htmlText has something to do with
> HTML.
> 
> What do you base this assumption on?
> 
> It is clear that htmlText is a view that is html-like.  There is no
> reason to expect it to process HTML when it is dumped into the property.

I think that RunTime made a bad choice in naming that property "htmlText". 
If it was never intended to render the full html spec, then it should have 
been named something like "taggedText". There would be no assumption that 
a property named "taggedText" would render html pages. That's my two 
cents.

Roger Eller <[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


Re: Problems using Send and Functions with 2 parameters

2006-08-08 Thread Sean Shao

Take a look at the "value" function, it's like "send" for functions :-)

put value("randomTime(5,2)", group "analogClock")

_
Express yourself instantly with MSN Messenger! Download today - it's FREE! 
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/


___
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: HTML Tag Cleaner Fails

2006-08-08 Thread Dar Scott


On Aug 8, 2006, at 4:56 AM, Bill Marriott wrote:

Except that  has a defined, special meaning that Rev knows  
about --
which is to specify the title of a document -- and that is by  
definition

distinct from the content. The  tag however, is undefined.

I believe that it's appropriate to "strip" out the information  
between title

tags and to preserve the information between "foo" tags.

By reference, see:

http://www.w3.org/MarkUp/html3/HTMLandSGML.html


That is an HTML document.

You are assuming that a field and htmlText has something to do with  
HTML.


What do you base this assumption on?

It is clear that htmlText is a view that is html-like.  There is no  
reason to expect it to process HTML when it is dumped into the property.


(Now, I do think htmlText when retrieved might be closer to HTML,  
such as the handling of white space, but that is a different issue.   
Maybe it is even possible for retrieved htmlText to closely render in  
HTML.)


There is no reason to expect a field to process HTML when it is  
dumped into the field's htmlText property.


Stripping  is bizarre.

Dar Scott
___
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: Problems using Send and Functions with 2 parameters

2006-08-08 Thread Jim Ault
On 8/8/06 7:24 AM, "Ian McKnight" <[EMAIL PROTECTED]> wrote:
> Can anyone shed some light on this please?
> I could keep the function and calling handler together but would
> prefer to have all important scripts in one place.

why are you sending
"get randomTim(5,2)"
instead of 
"randomTime(5,2)"

I am not sure what you expect the group script container to do.

Jim Ault
Las Vegas

On 8/8/06 7:24 AM, "Ian McKnight" <[EMAIL PROTECTED]> wrote:

> Hi
> 
> I have a function 'randonTime' which accepts two parameters, the first
> specifies whether a time should be in 5, 10 15 etc minute intervals,
> the second specifies 12 or 24 hour clock and returns a valid time in
> the form hh:mm.
> 
> With the function handler in the same script as the calling handler ( a
> button)
> 
> get randomTime(5,2)
> put the result
> 
> works as expected.  -- 12:45  6:15  21:55 19:25 etc
> 
> However, when the function is placed in a group on the same card
> 
> send "get randomTime(5,2)" to group "analogClock"
> put the result
> 
> only the minutes are return.  -- :45  :15  :55  :25
> 
> The second parameter is ignored so the fuinction doesn't create an hour.
> 
> Can anyone shed some light on this please?
> I could keep the function and calling handler together but would
> prefer to have all important scripts in one place.
> 
> Thanks.


___
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: Rev app to pull data from Amazon

2006-08-08 Thread Mark Schonewille

RGould8,

Are you sure you have set the permissions of the script to 755, i.e.  
correct execution rights, and does the script have line endings  
compatible with the operating system it is running on?


Best,

Mark

--

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

Download ErrorLib at http://economy-x-talk.com/developers.html and  
get full control of error handling in Revolution.




Op 8-aug-2006, om 17:50 heeft [EMAIL PROTECTED] het volgende geschreven:


Dan,

 Well, I have followed the instructions and have put the PERL  
script on

my web-server like the Amazon API instructions say:







The part I'm having trouble with is how to get Revolution to talk  
to this

PERL script and pass data to it.   I try things like:

put URL "www.mywebserver.com/itemsearch_rest.pl?Elvis" into databack


but I get this error back:

Internal Server Error
The server encountered an internal error or misconfiguration and  
was unable

to complete your request.
Please contact the server administrator, [EMAIL PROTECTED]  
and
inform them of the time the error occurred, and anything you might  
have done that

may have caused the error.
More information about this error may be available in the server  
error log.


Additionally, a 404 Not Found error was encountered while trying to  
use an

ErrorDocument to handle the request.



___
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: Rev app to pull data from Amazon

2006-08-08 Thread RGould8
Dan,

 Well, I have followed the instructions and have put the PERL script on 
my web-server like the Amazon API instructions say:


#!/usr/local/bin/perl -w

# This program shows how to use LWP::Simple to make an Amazon Web
# Services (AWS) REST request, and how to process the response with
# XML::XPath.

use strict;
use LWP::Simple qw($ua get);
use XML::XPath;

# Retrieve command line arguments and combine them with escaped space 
characters.
die "Usage: $0 \n"
 unless @ARGV;
my $keywords = join "%20", @ARGV;

# Define parts of the REST request.
my $baseurl = "http://webservices.amazon.com/onca/xml";;
my $service = "AWSECommerceService";
my $accesskey = "";
my $operation = "ItemSearch";
my $searchindex = "Books";
my $responsegroup = "Request,Small";
my $version = "2005-10-13";

# Assemble the REST request URL.
my $request =
 "$baseurl?" .
 "Service=$service&" .
 "AWSAccessKeyId=$accesskey&" .
 "Operation=$operation&" .
 "Keywords=$keywords&" .
 "SearchIndex=$searchindex&" .
 "ResponseGroup=$responsegroup&" .
 "Version=$version" ;

# Send the request using HTTP GET.
my $ua = new LWP::UserAgent;
$ua->timeout(30);
my $response = get($request);

# Process XML response with XPath.
my $xp = XML::XPath->new(xml => $response);

if ( $xp->find("//Error") )
{
 print "There was an error processing your request:\n", 
   "   Error code: ", $xp->findvalue("//Error/Code"), "\n",
   "   ", $xp->findvalue("//Error/Message"), "\n\n";
}
else
{
 for (my $i = 1; $i <= 10; $i++)
 {
 if ( ! $xp->find("/ItemSearchResponse/Items/Item[$i]") )
 {
 last;
 }
 my @authors;
 for (my $j = 1;
  $j <= $xp->
findvalue("count(/ItemSearchResponse/Items/Item[$i]/ItemAttributes/Author)");
  $j++)
 {
 push @authors, $xp->
findvalue("/ItemSearchResponse/Items/Item[$i]/ItemAttributes/Author[$j]");
 }
 
 print "Title: ", $xp->
findvalue("/ItemSearchResponse/Items/Item[$i]/ItemAttributes/Title"), "\n",
 "Author: ", join(", ", @authors), "\n",
 "ASIN: ", $xp->findvalue("/ItemSearchResponse/Items/Item[$i]/ASIN"), 
"\n\n";
 }
}




The part I'm having trouble with is how to get Revolution to talk to this 
PERL script and pass data to it.   I try things like:

put URL "www.mywebserver.com/itemsearch_rest.pl?Elvis" into databack


but I get this error back:

Internal Server Error
The server encountered an internal error or misconfiguration and was unable 
to complete your request.
Please contact the server administrator, [EMAIL PROTECTED] and 
inform them of the time the error occurred, and anything you might have done 
that 
may have caused the error.
More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an 
ErrorDocument to handle the request.


I'm wondering if perhaps the ?Elvis part isn't really what the PERL script is 
expecting for a parameter.   Do you know if there's another way to pass 
parameters to that PERL script?   My ISP doesn't give me SSH Telnet capability, 
so 
I need to pass/receive data via URLs.




In a message dated 8/3/06 6:13:51 PM, [EMAIL PROTECTED] writes:


> I've done a bit of work in this area but nothing ambitious. But I can 
> answer
> your other question below. Yes, you do need a developer account.
> 
> On 8/3/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> >
> > Do I need to get one
> > of the Amazon security-service certificates in order to do this?
> > ___
> > 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
> >
> 
> 
> 
> --
> ~~
> Dan Shafer, Information Product Consultant and Author
> http://www.shafermedia.com
> Get my book, "Revolution: Software at the Speed of Thought"
> >From http://www.shafermediastore.com/tech_main.html
> ___
> 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


Problems using Send and Functions with 2 parameters

2006-08-08 Thread Ian McKnight

Hi

I have a function 'randonTime' which accepts two parameters, the first
specifies whether a time should be in 5, 10 15 etc minute intervals,
the second specifies 12 or 24 hour clock and returns a valid time in
the form hh:mm.

With the function handler in the same script as the calling handler ( a button)

get randomTime(5,2)
put the result

works as expected.  -- 12:45  6:15  21:55 19:25 etc

However, when the function is placed in a group on the same card

send "get randomTime(5,2)" to group "analogClock"
put the result

only the minutes are return.  -- :45  :15  :55  :25

The second parameter is ignored so the fuinction doesn't create an hour.

Can anyone shed some light on this please?
I could keep the function and calling handler together but would
prefer to have all important scripts in one place.

Thanks.

--
Regards

Ian

===
Ian McKnight

[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


Re: Droplet app with AppleEvent

2006-08-08 Thread Jim Ault
This is just a shot to help you quickly, but you might try to add the
repeating test 

MyAppName is among the processes

If true, it is now up and running.  Don't the exact way of doing this, but
hopefully this helps to with the timing.

Jim Ault
Las Vegas


On 8/8/06 6:46 AM, "Zax" <[EMAIL PROTECTED]> wrote:

> [sorry if I made double-post, I encountered mail problems]
> 
> Hello,
> 
> I would like my app made with Revolution 2.51 to react like a droplet when
> dropping files or folders on the app icon.
> I set "" as file type and it's ok: dropping something on my app icon
> launches my app.
> 
> For testing purpose, I wrote this code in my main stack:
> 
> on appleEvent eClass,eID,eSender
>   request appleEvent data
>   answer eClass & return & "id =" && eID & return & "sender =" && eSender &
> return & "data =" && quote & it & quote
>   pass appleEvent
> end appleEvent
> 
> Everything is OK when I drop something onto the app icon *and* my app is
> *already opened*. In this case, "it" contains needed data.
> But when I drop something onto the app icon *and* my app is *not opened*,
> then my app is launched but no AppleEvent is sended :(
> Maybe because the app is not loaded, so it can't receive the AppleEvent?
> 
> So, can somebody help me? A droplet must work even the app is not launched,
> otherwise it's not really a droplet! Do I have to add something in my
> "openstack" handler? Or maybe add a "startup" handler with some special code
> in it?
> 
> Thanks in advance.


___
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: Droplet app with AppleEvent

2006-08-08 Thread Mark Schonewille

Hi Zax,

Maybe, the answer dialog is not available yet. What happens if you  
try the following in the mainstack of a standalone?


on appleEvent
  beep
end appleEvent

If you don't hear a beep, it looks (sounds) like a bug. I don't  
remember seeing this bug in later versions, you might want to  
download a trial version and try building your application with the  
latest version.


If above script works, you can try the following:

on appleEvent eClass,eID,eSender
  request appleEvent data
  put eClass & return & "id =" && eID & return & "sender =" &&  
eSender & ¬

  return & "data =" && quote & it & quote into myEventData
  send "showEventData myEventData" to me in 10 millisecs
end appleEvent

on showEventData theData
  answer theData
end showEventData

Note that this is just a long shot. I'd have to try myself to be sure  
about this.


Best,

Mark

--

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

Download ErrorLib at http://economy-x-talk.com/developers.html and  
get full control of error handling in Revolution.




Op 8-aug-2006, om 15:46 heeft Zax het volgende geschreven:


[sorry if I made double-post, I encountered mail problems]

Hello,

I would like my app made with Revolution 2.51 to react like a  
droplet when

dropping files or folders on the app icon.
I set "" as file type and it's ok: dropping something on my app  
icon

launches my app.

For testing purpose, I wrote this code in my main stack:

on appleEvent eClass,eID,eSender
  request appleEvent data
  answer eClass & return & "id =" && eID & return & "sender =" &&  
eSender &

return & "data =" && quote & it & quote
  pass appleEvent
end appleEvent

Everything is OK when I drop something onto the app icon *and* my  
app is

*already opened*. In this case, "it" contains needed data.
But when I drop something onto the app icon *and* my app is *not  
opened*,

then my app is launched but no AppleEvent is sended :(
Maybe because the app is not loaded, so it can't receive the  
AppleEvent?


So, can somebody help me? A droplet must work even the app is not  
launched,

otherwise it's not really a droplet! Do I have to add something in my
"openstack" handler? Or maybe add a "startup" handler with some  
special code

in it?

Thanks in advance.

--
Zax


___
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


Droplet app with AppleEvent

2006-08-08 Thread Zax
[sorry if I made double-post, I encountered mail problems]

Hello,

I would like my app made with Revolution 2.51 to react like a droplet when
dropping files or folders on the app icon.
I set "" as file type and it's ok: dropping something on my app icon
launches my app.

For testing purpose, I wrote this code in my main stack:

on appleEvent eClass,eID,eSender
  request appleEvent data
  answer eClass & return & "id =" && eID & return & "sender =" && eSender &
return & "data =" && quote & it & quote
  pass appleEvent
end appleEvent

Everything is OK when I drop something onto the app icon *and* my app is
*already opened*. In this case, "it" contains needed data.
But when I drop something onto the app icon *and* my app is *not opened*,
then my app is launched but no AppleEvent is sended :(
Maybe because the app is not loaded, so it can't receive the AppleEvent?

So, can somebody help me? A droplet must work even the app is not launched,
otherwise it's not really a droplet! Do I have to add something in my
"openstack" handler? Or maybe add a "startup" handler with some special code
in it?

Thanks in advance.

-- 
Zax 


___
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: Purchasing Valentina

2006-08-08 Thread Dave Cragg


On 8 Aug 2006, at 12:36, Sakari wrote:


If there's someone who has bought Valentina, could you help me please?

I've been planning to buy Valentina for Revolution, but there's a few
obstacles I've come by, so I'm asking here if you don't mind.

First thing I came across is the website Valentina or the Paradigma  
Software
has. It is absolutely weak. Won't go into details, but when I go to  
website
with this kind of quality I start to wonder if the product itself  
is same

quality.

I wanted to ask someone in Paradigma if I would get registration  
key after
ordering the product and there's not a single e-mail I could  
forward my

problem.

I'm still planning to buy the product, but really can't do that  
before I get

answers to these questions.


I recently purchased a license. The response (with all registration  
keys) was extremely fast.


I noticed that Ruslan has responded to your mail already. He responds  
with the same speed (or faster) to technical queries too. You'll be  
amazed.


Cheers
Dave
___
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: Purchasing Valentina

2006-08-08 Thread Ruslan Zasukhin
On 8/8/06 2:36 PM, "Sakari" <[EMAIL PROTECTED]> wrote:

Hi Sakari,

> If there's someone who has bought Valentina, could you help me please?

> I've been planning to buy Valentina for Revolution, but there's a few
> obstacles I've come by, so I'm asking here if you don't mind.

> First thing I came across is the website Valentina or the Paradigma Software
> has. It is absolutely weak. Won't go into details, but when I go to website
> with this kind of quality I start to wonder if the product itself is same
> quality. 

What you mean with weak ?


> I wanted to ask someone in Paradigma if I would get registration key after
> ordering the product and there's not a single e-mail I could forward my
> problem.

We do not provide emails on site to avoid spam.
Right Lynn?

We give on support pages ways to subscribe to Valentina main list and/or
beta list

> I'm still planning to buy the product, but really can't do that before I get
> answers to these questions.

You can ask me any tech issues,
And you can ask Lynn any license issues.
And you can ask any other question on Valentina lists.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]


___
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


Purchasing Valentina

2006-08-08 Thread Sakari
If there's someone who has bought Valentina, could you help me please?

 

I've been planning to buy Valentina for Revolution, but there's a few
obstacles I've come by, so I'm asking here if you don't mind. 

 

First thing I came across is the website Valentina or the Paradigma Software
has. It is absolutely weak. Won't go into details, but when I go to website
with this kind of quality I start to wonder if the product itself is same
quality. 

 

I wanted to ask someone in Paradigma if I would get registration key after
ordering the product and there's not a single e-mail I could forward my
problem.

 

I'm still planning to buy the product, but really can't do that before I get
answers to these questions.

 

Sakari Ruoho

Programmer

Academica Information Oy

___
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: HTML Tag Cleaner Fails

2006-08-08 Thread Mark Schonewille
Exactly, Bill. Nothing bizarre about it. Thank you for looking up the  
reference.


In reply to Dar's list of applications that do or don't: Apple's  
TextEdit application behaves exactly like Revolution fields in this  
respect.


Best,

Mark

--

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

Download ErrorLib at http://economy-x-talk.com/developers.html and  
get full control of error handling in Revolution.




Op 8-aug-2006, om 12:56 heeft Bill Marriott het volgende geschreven:

Except that  has a defined, special meaning that Rev knows  
about --
which is to specify the title of a document -- and that is by  
definition

distinct from the content. The  tag however, is undefined.

I believe that it's appropriate to "strip" out the information  
between title

tags and to preserve the information between "foo" tags.

By reference, see:

http://www.w3.org/MarkUp/html3/HTMLandSGML.html

"The behavior of WWW applications reading HTML documents and  
discovering tag

or attribute names which they do not understand should be to behave as
though, in the case of a tag, the whole tag had not been there but its
content had, or in the case of an attribute, that the attribute had  
not been

present."

In this case, Rev "understands" the title tag, and correctly does not
include it in the content. It does not understand the "foo" tag and
therefore renders it as if the tag were not there.


Dar Scott wrote:


Actually, Dan is right.  It is bizarre!

My word processor doesn't do it.  My calculator doesn't do it.   
The  IP

address field in preferences doesn't do it.

A Revolution field is not a browser and it is not even an HTML   
displayer.
It has a simple html-like markup view that covers the   
capabilities of of
the field.  Though it is similar to HTML, htmlText  doesn't even  
attempt

to be like HTML even in little things like  representing whitespace.

The title is way outside the scope of what htmlText does.

Stripping  and not  is bizarre.

It might be a clue that htmlText will become closer to HTML, but I
suspect it is an ancient artifact.





___
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: HTML Tag Cleaner Fails

2006-08-08 Thread Bill Marriott
Except that  has a defined, special meaning that Rev knows about --  
which is to specify the title of a document -- and that is by definition 
distinct from the content. The  tag however, is undefined.

I believe that it's appropriate to "strip" out the information between title 
tags and to preserve the information between "foo" tags.

By reference, see:

http://www.w3.org/MarkUp/html3/HTMLandSGML.html

"The behavior of WWW applications reading HTML documents and discovering tag 
or attribute names which they do not understand should be to behave as 
though, in the case of a tag, the whole tag had not been there but its 
content had, or in the case of an attribute, that the attribute had not been 
present."

In this case, Rev "understands" the title tag, and correctly does not 
include it in the content. It does not understand the "foo" tag and 
therefore renders it as if the tag were not there.


Dar Scott wrote:
> On Aug 7, 2006, at 2:27 AM, Mark Schonewille wrote:
>
>> No, it is what I expect. My internet browser behaves exactly the same.
>
> Actually, Dan is right.  It is bizarre!
>
> My word processor doesn't do it.  My calculator doesn't do it.  The  IP 
> address field in preferences doesn't do it.
>
> A Revolution field is not a browser and it is not even an HTML  displayer. 
> It has a simple html-like markup view that covers the  capabilities of of 
> the field.  Though it is similar to HTML, htmlText  doesn't even attempt 
> to be like HTML even in little things like  representing whitespace.
>
> The title is way outside the scope of what htmlText does.
>
> Stripping  and not  is bizarre.
>
> It might be a clue that htmlText will become closer to HTML, but I 
> suspect it is an ancient artifact.



___
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