RunRev and music

2010-01-09 Thread René Micout
Hello everybody,
I have a project : make a bridge between RunRev and Macintosh Core Audio/Core 
Midi with AppleScript and if successful do benefit the community...
I am searching books, tutorials or “something” (in english or in french [is it 
possible to dream ?]) witch talk about working Macintosh Core audio/Core Midi 
with AppleScript.
Somebody know that ?
Thank you
René___
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: valentina, externals of libdatabase

2010-01-09 Thread Bernard Devlin
Thanks Trevor.  I expect to be on my own with LibDatabase now.  I can
understand your focus is on Sql Yoga right now.

On Fri, Jan 8, 2010 at 9:25 PM, Trevor DeVore  wrote:
> 3rd party externals are traditionally added to the User Extensions folder.
> This folder is usually located in your documents folder. This lesson shows
> how to install an external and shows you how to find the User Extensions
> folder. I would check there for the Valentina files.
>
> 


> libDatabase relies on the Valentina external being loaded and that the
> handlers are available in the message path. When working in the IDE the
> Valentina external should be available in the message path assuming it was
> loaded at startup (see aforementioned lesson for ways to test).

I will have a look at the externals lesson.

> Now I have no idea if libDatabase will work with Valentina 4. I haven't
> looked at the libDatabase code in a looong time and Valentina 4 was not
> around when I did work on it. So you are kind of on your own when it comes
> to troubleshooting actual functionality...

FYI LibDatabase does kind of work with Valentina 4.  But when an array
is returned with a result set, there are no column names.

There is another weird problem with quotation marks.  I'm using Rev on
Vista at the moment.  I see from the zip file containing LibDatabase
that it was prepared on OS X.  LibDatabase relies on multi-item array
names, where some of the items are quoted.  That causes a problem
within LibDatabase when it looks for values by key within arrays.

The quotation marks do not register any problem in the Script Editor.
But they are not the same charToNum on windows i.e. on Windows quote
is something like 34, whereas the quotation marks in the arrray names
are something like char 143 (I don't have Rev installed on this
machine).  So, I think there is a macToISo issue in Rev itself.  I
understand it is supposed to be applied automatically to stacks when
Rev opens.  I seem to have come across an issue like this a couple of
years ago.

I may try to get round this quotation character issue and see if that
fixes the lack of column names (maybe there is some magic going on in
LibDatabase when it looks for Valentina column names).

Bernard
___
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: valentina, externals of libdatabase

2010-01-09 Thread Ruslan Zasukhin
On 1/9/10 1:46 PM, "Bernard Devlin"  wrote:

Hi Bernard,

> Thanks Trevor.  I expect to be on my own with LibDatabase now.  I can
> understand your focus is on Sql Yoga right now.

May be there is sense to use just Valentina API?


-- 
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: Applescrript from Rev

2010-01-09 Thread Yves COPPE


Le 9 janv. 10 à 08:19, Sarah Reichelt a écrit :


on mac OS X(leopard)
I'd like do send an applescript from rev to mail.app
it should be something like this :
open mail.app
open a new message
fill the fields "To", "Object" and "Message" with variables



Here is the script I use:

Here is the Rev part, fill in the recipVar, subjectVar and bodyVar
variables as required:

   put the cMakeEmail of this stack into makeEmail
   replace "*addr*" with quote & recipVar & quote in makeEmail
   replace "*subj*" with quote & subjectVar & quote in makeEmail
   replace "*body*" with quote & bodyVar & quote in makeEmail
   do makeEmail as AppleScript

And here is the AppleScript that I store in a custom property of the
stack, called cMakeEmail:

tell application "Mail"
activate
copy *addr* to recipVar
copy *subj* to subjVar
copy *body* to bodyVar

set newMessage to make new outgoing message with properties
{subject:subjVar, content:bodyVar & return & return}
tell newMessage
set visible to true
make new to recipient at end of to recipients with properties
{address:recipVar}
end tell
end tell

This is a very basic AppleScript that just assumes a single recipient
and no attachments, but it should be enough to get you started anyway.
If the body of the email contains any quotes, you need to escape them,
or replace them with single quotes first.

Regards,
Sarah



Hi Sarah

Works fine
Thanks.

Greetings.

Yves COPPE
yvesco...@skynet.be

___
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: Applescrript from Rev

2010-01-09 Thread Yves COPPE


Le 9 janv. 10 à 08:21, Ludovic Thébault a écrit :



Hello Yves

here a script found on the net :

tell application "Mail"
	set newMessage to (make new outgoing message at end of outgoing  
messages with properties {subject:"@@", content:"##"})

tell newMessage
		make new recipient at end of to recipients with properties  
{address:"§§"}
		make new cc recipient at beginning of cc recipients with  
properties {address:"••"}

send newMessage
delay 45
quit
end tell
end tell

Place it on a field

With Rev, change @@ with the subject, ## with the message, §§ with  
the email and •• with an other email if you  
want.___




Hello Ludovic

Works also fine as the script I've received from Sarah

Thanks for you two ... I have now the choice between 2 scripts



Greetings.

Yves COPPE
yvesco...@skynet.be

___
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 : Crappy Website

2010-01-09 Thread Francis Nugent Dixon

Richmond,

I have a liitle test for you !

Take a look at your desktop. If it is full of little alias
icons, and you spend a few seconds trying to find the right
one when you want to launch an application, then you can stop
reading now. I now know why your sister finds that your site
is like a dogs dinner.

Now - a second test. Get yourself a pack of different coloured
Post-Its, from your local store. You also need a wall .. !

Build yourself a heirarchy of your site on the wall. Each Site
Level is a Post-It MENU, and all the items under each menu
represent either another level of menu, or a HTML page. If you
appear to have too many items in your menu, open another
menu level, but try not to have too many. Always ask the questions :
Is this the right place for this item, or more correctly, all all
the items in this menu siblings ?

I agree with Sarah that you should take a look at those CSS
templates, but I think it unfortunate that we can't see any
drop-down menus there. Using drop-down menus gives you more scope.
And all the menus I see, imply a two level heirarchy only. In
fact, all the templates are the same design, only the colours change.
They all look very nice, but in fact they are forcing you into a
strait-jacket.

Play with your diagram on your wall for a few days.  Sit down
in front of it and contemplate it (use the colours for different
types of function). Think carefully before you assign a Menu
Title, or a Menu Item (Short and Sweet names do the trick).
Extension of your site at a later date should be a piece of cake.

Finally, spend some time on designing a nice background for your
site pages, and use it on every page. It will save you much time.

Your site users should be able to intuitively wander your site.. !
(Oh !! - Don't forget a "Back to Main Menu" menu   : >)

-Francis


___
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: Creating data grids by script

2010-01-09 Thread zryip theSlug
2010/1/9 James Hurley :
> Creating A Data Grid By Hand
> But then the lesson begins:
>
> This lesson will show you how to create a data grid through script.
>
> Perhaps change the "By Hand" to "By Script" ?

It is an expression used by developpers.

If a feature is not automatic or is not provided by the developpment
tool, thus developpers have to develop it manually or by hand.
But don't worry, developpers also use their hands when they script;)

Although if they're bad developers we can say they have developed with
their feet.
An expression of mine to qualify a very bad code: "This is developed
with feet. Unfortunately, they forgot to remove their shoes"...

-- 
-Zryip TheSlug- wish you the best! 8)
http://www.aslugontheroad.co.cc
___
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: If Monks CD-ROM - test download please

2010-01-09 Thread Mark Schonewille

Hi,

I tried to download IMHM and noticed that the DropBox links are  
broken, but the other links still work.


--
Best regards,

Mark Schonewille

Economy-x-Talk Consulting and Software Engineering
Homepage: http://economy-x-talk.com
Twitter: http://twitter.com/xtalkprogrammer

We make software, websites and webware. We are always looking for new  
projects. Feel free to contact us and ask for a quote without any  
further obligations

http://economy-x-talk.com/contact.html

Op 4 jan 2010, om 23:59 heeft Brian Thomas het volgende geschreven:


Hello,


To Download for FREE the classic, Revolution-built Monks CD-ROM visit:

http://rivertext.com/


Please let me know, if you have any issues with the download or
installation, as I plan on sending Press Releases out early tomorrow
morning,




___
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: (Data Grid) How to get the setting of the dgHeaderAlignment["column"] saved

2010-01-09 Thread Andre.Bisseret


Le 8 janv. 10 à 22:17, Trevor DeVore a écrit :


On Jan 7, 2010, at 10:09 AM, Andre.Bisseret wrote:

I have a data grid "DataGrid" defined with the Inspector. The  
columns' headers are aligned to left.


In order to get the columns headers centered I do the following :
--
put the dgProp["columns"] of group "DataGrid" into theColumns
repeat for each line enil in theColumns
   set the dgHeaderAlignment[enil] of grp "DataGrid" of this cd to  
center

end repeat
---
Ok, that works well.

I save the stack
If I close the stack and reopen it, the headers are still centered.

But if I quit Rev, when I reopen the stack, the headers are aligned  
to left again.


What am I missing?


It's a bug. The Data Grid isn't setting alignment when creating the  
headers from scratch.


You can either set the alignment each time your program opens or add  
a 1 line fix to the Data Grid behavior script. Instructions follow.


Thanks Trevor for your answer and the precisely explained procedure to  
add the line to the _tableCreateHeaders command.


But, when I do so, I get a new issue : after quitting Rev, when I  
launch my stack again, the headers of the columns, not only are not  
centered anymore but also some of them are even so shifted to the  
left, that  one can't see the first characters of them; bizarre ;-)


More precisely : could be useful to say that the data grid is on a  
substack;

Even without quitting Rev :
- if I close the substack and re-open it the headers keeps centered
- If I close the substack AND its main stack, then, when I re-open  
them, I get the headers shifted to the left.


Not a big problem anyway (I can set the alignment each time a card  
opens as you suggest); but I am curious about what is happening ;-))


It was the first time I had a look at your scripts in the  
revdatagridlibrary; very impressive; "chapeau bas" ;-))


Best regards from Grenoble
André



==
1) Open Script
==

edit script of btn "Data Grid" of stack "revdatagridlibrary"

==
2) Locate _table.CreateHeaders command
==


==
3) Add line to _table.CreateHeaders command
==


   set the dgTooltip of theGroup to theColsA[theColumn] 
["tooltip"]
   set the dgHilite of theGroup to theColumn is  
sortByThisColumn

   #
   ## ADD FOLLOWING LINE
  #
   set the dgAlignment of theGroup to theColsA[theColumn] 
["header"]["alignment"]

   lock messages
   end if
   end repeat
end _table.CreateHeaders

==
4) save revDataGridLibrary stack
==

In message box execute:

save stack "revDataGridLibrary"


--
Trevor DeVore
Blue Mango Learning Systems
ScreenSteps: http://www.screensteps.com
Releasable Revolution Resources for Developers: 
http://revolution.bluemangolearning.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


Re: valentina, externals of libdatabase

2010-01-09 Thread Bernard Devlin
On Sat, Jan 9, 2010 at 11:51 AM, Ruslan Zasukhin
 wrote:
> On 1/9/10 1:46 PM, "Bernard Devlin"  wrote:
>
> Hi Bernard,
>
>> Thanks Trevor.  I expect to be on my own with LibDatabase now.  I can
>> understand your focus is on Sql Yoga right now.
>
> May be there is sense to use just Valentina API?

Hi Ruslan,

I am indeed considering just using the Valentina API.  I started using
LibDatabase as I'd remembered it was fairly straightforward in the
past - it makes clever use of Rev arrays, getting out of one's way as
an abstraction layer.  I saw from looking through the Rev list in the
past that people had been using it, and that using the SQL with
Valentina had often been recommended as the way to get started with
Valentina.

I'm thinking about the best way to use the Valentina API that would be
smoothest whilst working with Rev.

Bernard
___
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: valentina, externals of libdatabase

2010-01-09 Thread william humphrey
I used to use Trevor's libdatabase with SQLite but now I use valentina with
the Valentina API. It really makes sense and is not that difficult to put in
place.
___
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: Accessing the inaccessible

2010-01-09 Thread James Hurley


James Hurley wrote:

RIght now I have a collection of fields arranged in a grid--5 across
and 31 down. They were created by script and run off the bottom of  
the

screen. I would like to group them and put in a vertical scrollbar,
but I can't get at them to select those off the bottom of the screen.

Any thoughts? Is it possible to select a collection of controls by
script and then group them?


One of the great things about Rev is that if the IDE can do it you can
do it too. :)

repeat with i = 1 to the number of fields
  set the selected of fld i to true
end repeat
group

--
 Richard Gaskin
 Fourth World
 Rev training and consulting: http://www.fourthworld.com
 Webzine for Rev developers: http://www.revjournal.com
 revJournal blog: http://revjournal.com/blog.irv


Well, that was easy. Thanks Richard

Jim

___
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: Applescrript from Rev

2010-01-09 Thread J. Landman Gay

Yves COPPE wrote:



Thanks for you two ... I have now the choice between 2 scripts


There is also the IDE command "revMail" which does it all for you. It's 
in the dictionary.


--
Jacqueline Landman Gay | jac...@hyperactivesw.com
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: Applescrript from Rev

2010-01-09 Thread Yves COPPE


Le 09-janv.-10 à 18:21, J. Landman Gay a écrit :


Yves COPPE wrote:


Thanks for you two ... I have now the choice between 2 scripts


There is also the IDE command "revMail" which does it all for you.  
It's in the dictionary.






Re,

I didn't see it; Thanks !

Now, I have 3 scripts for answering my question !




Greetings.

Yves COPPE
yvesco...@skynet.be

___
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: Porting Lingo scripts to Revtalk

2010-01-09 Thread J. Landman Gay

Alejandro Tejada wrote:


Now, i am looking for guidelines to port code from
Macromedia Director's Lingo to RevMedia's Revtalk.
Every advice is welcome.


The person you need is Colin -- the most incredible Lingo guru I ever 
met, an accomplished x-talker, and a participant on this list. Maybe 
he'll see this. :)


--
Jacqueline Landman Gay | jac...@hyperactivesw.com
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: Porting Lingo scripts to Revtalk

2010-01-09 Thread Troy Rollins


On Jan 9, 2010, at 1:05 PM, J. Landman Gay wrote:

The person you need is Colin -- the most incredible Lingo guru I  
ever met, an accomplished x-talker, and a participant on this list.  
Maybe he'll see this. :)


You didn't mention that he also knows the author of the book pretty  
well.


--
Troy
RPSystems, Ltd.
http://www.rpsystems.net


___
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: Applescrript from Rev

2010-01-09 Thread stephen barncard
revMail will even open up a new mail document for google mail if one has
that extra 'thing' from google to work with "mailto:"s in browsers. It will
take multiple addresses in the to and cc: fields and subject and body but no
bcc: (probably a spammy reason for that)
-
Stephen Barncard
San Francisco
http://houseofcubes.com/disco.irev


2010/1/9 Yves COPPE 

>
> Le 09-janv.-10 à 18:21, J. Landman Gay a écrit :
>
>
>  Yves COPPE wrote:
>>
>>  Thanks for you two ... I have now the choice between 2 scripts
>>>
>>
>> There is also the IDE command "revMail" which does it all for you. It's in
>> the dictionary.
>>
>>
>
>
> Re,
>
> I didn't see it; Thanks !
>
> Now, I have 3 scripts for answering my question !
>
>
>
>
>
> Greetings.
>
> Yves COPPE
> yvesco...@skynet.be
>
> ___
> 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: RunRev and music

2010-01-09 Thread Alejandro Tejada

Hi René

Are you aware of UDI's work in Runrev
with Midi?

Visit his page:
http://homepage.mac.com/udi/stack/tool.html

and download his stacks:
http://homepage.mac.com/udi/stack/makeSMF133.hqx
http://homepage.mac.com/udi/stack/pmdPlayerRR12.hqx
http://homepage.mac.com/udi/stack/pmdKB11.hqx
http://homepage.mac.com/udi/stack/rMusic11.hqx
http://homepage.mac.com/udi/stack/smf2Pmd.hqx

By the way, Does your work allows automatic creation of
music in different styles like the software "Band in a Box"
or just in one style like "Mozart's Musical Dice Game for
Composing a Minuet"?

http://sunsite.univie.ac.at/Mozart/dice/

Automatic music generator are really useful to add
infinite variety to stacks that require constant use.
René, Have you created similar automatic music generator
with Runrev?

Have a nice weekend!

Alejandro

-- 
View this message in context: 
http://n4.nabble.com/RunRev-and-music-tp1010194p1010436.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: Creating data grids by script

2010-01-09 Thread Bob Sneidar
You guys have hands??? ;-)

Bob


On Jan 9, 2010, at 5:40 AM, zryip theSlug wrote:

> It is an expression used by developpers.
> 
> If a feature is not automatic or is not provided by the developpment
> tool, thus developpers have to develop it manually or by hand.
> But don't worry, developpers also use their hands when they script;)

___
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: RunRev and music

2010-01-09 Thread René Micout
Alejandro,
Thank you for answer.
Yes I know UDI's work. It is about Midi File Format (that is a part of my 
work)...
But my new research is about direct access to Core Audio / Core Midi (in real 
time...)
Exagofon my application is not a sequencer like Logic or ProTools, it is very 
much easy to play with, it is like a game for a child (my small-son — yes I am 
a grand-father ! — play with it and he is 4) but it is powerful and old many 
possibilities.
For my own (pour ma part) my musical projects turn around contemporary music 
like american minimalists (John Cage, Morton Felman, Terry Riley, la Monte 
Young, Steve Reich, Philip Glass, etc...) and rock few special like Soft 
Machine, Fripp & Eno, Robert Wyatt. But there is no exclusive, all is open...
If you have not already, watch part 6 of the presentation of Exagofon towards 
the end, there are some more interesting musical examples than the beginning 
(witch is more didactic) ; it is not really "compositions", but...

http://www.youtube.com/watch?v=YgdRplS1wZE

I wish you also a good (half) week-end.
Bon souvenir de Paris
René

Le 9 janv. 2010 à 21:53, Alejandro Tejada a écrit :

> 
> Hi René
> 
> Are you aware of UDI's work in Runrev
> with Midi?
> 
> Visit his page:
> http://homepage.mac.com/udi/stack/tool.html
> 
> and download his stacks:
> http://homepage.mac.com/udi/stack/makeSMF133.hqx
> http://homepage.mac.com/udi/stack/pmdPlayerRR12.hqx
> http://homepage.mac.com/udi/stack/pmdKB11.hqx
> http://homepage.mac.com/udi/stack/rMusic11.hqx
> http://homepage.mac.com/udi/stack/smf2Pmd.hqx
> 
> By the way, Does your work allows automatic creation of
> music in different styles like the software "Band in a Box"
> or just in one style like "Mozart's Musical Dice Game for
> Composing a Minuet"?
> 
> http://sunsite.univie.ac.at/Mozart/dice/
> 
> Automatic music generator are really useful to add
> infinite variety to stacks that require constant use.
> René, Have you created similar automatic music generator
> with Runrev?
> 
> Have a nice weekend!
> 
> Alejandro
> 
> -- 
> View this message in context: 
> http://n4.nabble.com/RunRev-and-music-tp1010194p1010436.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


PostgreSQL/On-Rev Database Tables

2010-01-09 Thread Rick Harrison
Hi there,

I created PostgreSQL database on On-Rev
using the PostgreSQL Database Wizard which seemed
to work fine. 

Then I was trying to use phpPgAdmin to create tables
for the database. It told me that I couldn't do it because 
I wasn't a "SuperUser" which to me seemed crazy because 
I was logged in as the user who created the database in the first place.

Does anyone have any ideas or has anyone ever done this
successfully on On-Rev?

I've also noticed that documentation on how to do these
things is lacking. Suggestions?

Thanks in advance,

Rick
___
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: PostgreSQL/On-Rev Database Tables

2010-01-09 Thread Pierre Sahores

Hi Rick,

I got exactly the same problems when i tried to setup my on-rev  
postgresql db (loki.on-rev.com) :


OK to create the db in using the PostgreSQL Database Wizard

No luck in trying to setup its contents in using the phpPgAdmin lib.

To avoid to have to setup the table in using the shell under SSH  
(because my standard DSL web acces use dynamic IPs), i switched to  
MySQL instead. It must not be so difficult (some files rights and  
users access to correct or so)


It would be great to have some one at Edimburg to reconfigure the  
phpPgAdmin config to let us use it as we can use the phpMyAdmin one.


Best Regards,

Pierre


Le 9 janv. 10 à 23:18, Rick Harrison a écrit :


Hi there,

I created PostgreSQL database on On-Rev
using the PostgreSQL Database Wizard which seemed
to work fine.

Then I was trying to use phpPgAdmin to create tables
for the database. It told me that I couldn't do it because
I wasn't a "SuperUser" which to me seemed crazy because
I was logged in as the user who created the database in the first  
place.


Does anyone have any ideas or has anyone ever done this
successfully on On-Rev?

I've also noticed that documentation on how to do these
things is lacking. Suggestions?

Thanks in advance,

Rick
___
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



--
Pierre Sahores
mobile : (33) 6 03 95 77 70

www.wrds.com
www.sahores-conseil.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


Simple Arrays

2010-01-09 Thread Bob Sneidar
Hi all. 

Apparently I am not getting arrays AT ALL. I would think that given:

put "1" & comma & "A" & comma & "Green" & return into theData
put "2" & comma & "B" & comma & "Blue" & return after theData
put "3" & comma & "C" & comma & "Orange" & return after theData
put "4" & comma & "D" & comma & "White" & return after theData

which would get me:
1,A,Green
2,B,Blue
3,C,Orange
4,D,White

I could then split by column (or by row I get confused) and get a simple array 
where:
theData[1,1] = "1"
theData[1,2] = "A"
theData[2,1] = "2"
theData[4,3] = "White" 

And so forth. However, this is NOT the case! If it were, I could issue a 
command:

put transpose(theData) into myArray

and:
myArray[1,2] = 2
myArray[1,3] = 3

and so on. If I got the entire row (I think there's a function for that) then I 
would have effectively gotten the column of the original data. Seems reasonable 
eh?

So can someone please explain to me why I cannot get a simple x,y row,column 
grid-like array using these simple commands? Revolution seems to think that the 
first column MUST be the key! I would LIKE for revolution to simply create it's 
OWN numerical keys and let my data be my data. Maybe in the future add an 
argument to the split and combine commands to tell it whether or not I WANT 
Revolution to treat my first column as the key?

If arrays worked like I described above, it would be a simple matter to get a 
single column of an array, just by transposing it and getting an entire row, 
instead of writing complex repeat loops to get a column of data. Am I missing 
something here? 

Thanks for any wisdom you can give. I can save some helpful souls the trouble 
of responding by saying I am capable of making repeat loops to accomplish this. 
I was just hoping that maybe I was missing something and I can in fact do what 
I thought I could. 

Bob___
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: Simple Arrays

2010-01-09 Thread Michael Kann
Bob, Maybe we can learn something about arrays together.

First, the format for a multi-dimensional array is

theData[1][1] = "1"   NOT  theData[1,1] = "1"

---
-- as an example, put your 4 lines into fld 1
---
1,A,Green
2,B,Blue
3,C,Orange
4,D,White
---
-- to get those 4 lines into a multi-dimensional
-- array called myArray I think you need code
-- like below (which you already know)
-- There might be an easier way.
---
on mouseUp
put fld 1 into v
set itemDelimiter to comma
put zero into countLine
repeat for each line curLine in v
add 1 to countLine
put zero into countItem
repeat for each item curItem in curLine
add 1 to countItem
put curItem into myArray[countLine][countItem]
  end repeat
end repeat
put myArray[1][2] into fld 2
end mouseUp
---
-- will end up with "A" in fld 2

Now for the transpose function.

>From the dictionary:

-- The array is a two-dimensional array variable whose elements are numbers, 
and whose keys are sequential numbers. --

So it looks like transpose will only work for two-dimensional arrays. It won't 
work for your example. 








--- On Sat, 1/9/10, Bob Sneidar  wrote:

> From: Bob Sneidar 
> Subject: Simple Arrays
> To: "How to use Revolution" 
> Date: Saturday, January 9, 2010, 7:12 PM
> Hi all. 
> 
> Apparently I am not getting arrays AT ALL. I would think
> that given:
> 
> put "1" & comma & "A" & comma & "Green"
> & return into theData
> put "2" & comma & "B" & comma & "Blue"
> & return after theData
> put "3" & comma & "C" & comma & "Orange"
> & return after theData
> put "4" & comma & "D" & comma & "White"
> & return after theData
> 
> which would get me:
> 1,A,Green
> 2,B,Blue
> 3,C,Orange
> 4,D,White

 
> I could then split by column (or by row I get confused) and
> get a simple array where:
> theData[1,1] = "1"
> theData[1,2] = "A"
> theData[2,1] = "2"
> theData[4,3] = "White" 
> 
> And so forth. However, this is NOT the case! If it were, I
> could issue a command:
> 
> put transpose(theData) into myArray
> 
> and:
> myArray[1,2] = 2
> myArray[1,3] = 3
> 
> and so on. If I got the entire row (I think there's a
> function for that) then I would have effectively gotten the
> column of the original data. Seems reasonable eh?
> 
> So can someone please explain to me why I cannot get a
> simple x,y row,column grid-like array using these simple
> commands? Revolution seems to think that the first column
> MUST be the key! I would LIKE for revolution to simply
> create it's OWN numerical keys and let my data be my data.
> Maybe in the future add an argument to the split and combine
> commands to tell it whether or not I WANT Revolution to
> treat my first column as the key?
> 
> If arrays worked like I described above, it would be a
> simple matter to get a single column of an array, just by
> transposing it and getting an entire row, instead of writing
> complex repeat loops to get a column of data. Am I missing
> something here? 
> 
> Thanks for any wisdom you can give. I can save some helpful
> souls the trouble of responding by saying I am capable of
> making repeat loops to accomplish this. I was just hoping
> that maybe I was missing something and I can in fact do what
> I thought I could. 
> 
> Bob___
> 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: Simple Arrays

2010-01-09 Thread Phil Davis

Hi Bob,

On 1/9/10 5:12 PM, Bob Sneidar wrote:

Hi all.

Apparently I am not getting arrays AT ALL. I would think that given:

put "1"&  comma&  "A"&  comma&  "Green"&  return into theData
put "2"&  comma&  "B"&  comma&  "Blue"&  return after theData
put "3"&  comma&  "C"&  comma&  "Orange"&  return after theData
put "4"&  comma&  "D"&  comma&  "White"&  return after theData

which would get me:
1,A,Green
2,B,Blue
3,C,Orange
4,D,White
   


Actually either of these:

split theData with cr
split theData by row -- where the rowDelimiter is CR

would get you this:

theData[1] = "1,A,Green"
theData[2] = "2,B,Blue"
theData[3] = "3,C,Orange"
theData[4] = "4,D,White"


I could then split by column (or by row I get confused) and get a simple array 
where:
theData[1,1] = "1"
theData[1,2] = "A"
theData[2,1] = "2"
theData[4,3] = "White"

And so forth. However, this is NOT the case!


Right. Technically speaking, comma is not an array index separator. 
Commas in our array keys help us conceptually represent multiple array 
dimensions in our own minds, but Rev sees an array with such keys as a 
simple one-dimensional array with alphabetic keys (since commas are not 
numerals).


Until version 3.0, Rev couldn't handle true multi-dimensional arrays. 
Since then, the thing that tells Rev "this is a multi-dimensional array" 
is multiple keys per element, with each key in its own bracket. Like this:


theData[1][1] = "1"
theData[1][2] = "A"
theData[1][3] = "Green"


Now do you see why 'transpose()' wouldn't work with your array? In part 
it's because your keys aren't numeric - they contain commas. (Also they 
have to be sequential numbers.)


Welcome to array re-education camp!  ;-)

Phil Davis



  If it were, I could issue a command:

put transpose(theData) into myArray

and:
myArray[1,2] = 2
myArray[1,3] = 3

and so on. If I got the entire row (I think there's a function for that) then I 
would have effectively gotten the column of the original data. Seems reasonable 
eh?

So can someone please explain to me why I cannot get a simple x,y row,column 
grid-like array using these simple commands? Revolution seems to think that the 
first column MUST be the key! I would LIKE for revolution to simply create it's 
OWN numerical keys and let my data be my data. Maybe in the future add an 
argument to the split and combine commands to tell it whether or not I WANT 
Revolution to treat my first column as the key?

If arrays worked like I described above, it would be a simple matter to get a 
single column of an array, just by transposing it and getting an entire row, 
instead of writing complex repeat loops to get a column of data. Am I missing 
something here?

Thanks for any wisdom you can give. I can save some helpful souls the trouble 
of responding by saying I am capable of making repeat loops to accomplish this. 
I was just hoping that maybe I was missing something and I can in fact do what 
I thought I could.

Bob___
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

   


--
Phil Davis

PDS Labs
Professional Software Development
http://pdslabs.net

___
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