Pic-a-POD and Wikipedia Picture of the day woes

2007-01-20 Thread Dom
Hi Sarah!
I sent you a message some days ago to the troz address about this...

By going on the Wikipedia web site, it seems that Wikipedia has changed
its scheme for obtaining the Picture of the day as of January 1st; so
Pic-a-POD has some trouble retrieving this image -- it gets an image
some day and not another!

By the way, I am a fan of Pic-a-POD to get great pictures :-)

___
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


altFont etc.

2007-01-20 Thread Klaus Major

Hi friends,

can someone give me a little technical hint about altFont?

I can successfully  load and unload a font, now my question:
How long will the loaded font be available if I do NOT unistall the  
font?


1. As long as Rev is running or
2. as long as Windows/the Mac is running (read: until the next  
restart of either Rev or Win/ the Mac)?



Another question:
I just had a crash with Rev on Windows and the appropriate crashlog  
file is a *.DMP

file of more than 12 (twelve!) MB!!!???

Is this the file I am supposed to attach to my bugzilla, ehm Rev  
quality center report?


Thanks in advance.


Regards

Klaus Major
[EMAIL PROTECTED]
http://www.major-k.de

___
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


OT: Heather Nagey old interview

2007-01-20 Thread Shari
I stumbled across an old interview done with Heather Nagey in the 
early years of Revolution.  I cannot find a date anywhere on the 
interview, but from the Q and A, I'd guess quite early on.  I enjoyed 
every word.  It was quite refreshing to hear Heather's enthusiasm for 
Revolution, and the enthusiasm of everyone involved in its creation. 
My favorite question however, was:


Q:  What single thing do you think Revolution did better than the other clones?

A:  Sold.

If anyone would like to read it, you'll find it here:

http://www.zathras.de/angelweb/xtalkinterviews-heather-nagey.htm

Thank you, Heather, and Kevin, and all the folks who've made 
Revolution possible for us :-D


Shari
--
Gypsy King Software
Mac and Windows shareware games
http://www.gypsyware.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


(no subject)

2007-01-20 Thread Robert Mann
I know there is a way to get the column type using 

revDatabaseColumnTypes(firstcurID)

 

is there also a way to get all the other information about the column such
as PK, and the column type value   int(10)

 

 

Thanks

Rob

___
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


Is this a bug?

2007-01-20 Thread Chipp Walters

Exists function:

Create 2 buttons:

Name the first one taxes
Name the second one UFOs

Group each button independantly and set the name of each group to America
Now you have 2 groups, each named America, each with a differently named
button within.

Now, try the following in the msg box:

put exists(button taxes in group America)
returns 'true'

put exists(button UFOs in group America)
returns 'false'

Furthermore, this statement no longer works either:
edit script of button UFOs in group America

Seems like this should work.
___
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: Is this a bug?

2007-01-20 Thread Mark Schonewille

Chipp,

No, this is not a bug. Revolution takes the first group with the name  
America it finds and that's how it should be IMHO. This is a gentle  
way to force the programmer to structure his/her work and avoids time  
wasting confusion.


Best,

Mark

--

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

Get your store on-line within minutes with Salery Web Store software.  
Download at http://www.salery.biz


Op 20-jan-2007, om 15:17 heeft Chipp Walters het volgende geschreven:


Exists function:

Create 2 buttons:

Name the first one taxes
Name the second one UFOs

Group each button independantly and set the name of each group to  
America
Now you have 2 groups, each named America, each with a  
differently named

button within.

Now, try the following in the msg box:

put exists(button taxes in group America)
returns 'true'

put exists(button UFOs in group America)
returns 'false'

Furthermore, this statement no longer works either:
edit script of button UFOs in group America

Seems like this should work.



___
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: Is this a bug?

2007-01-20 Thread David Bovill

Yes I agree it is not a bug in terms of naming - it would be perhaps be more
natural if the exists function makes an exception here as clearly the
object does exist. I use long ids every where and put them in a varaible:

put the long id of group 1 into firstAmerican
put the long id of group 2 into newRepublican

put exists(button taxes of firstAmerican)
put exists(button UFOs of newRepublican)
___
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: calling a remote function..

2007-01-20 Thread David Bovill

Chipp I have been using send and command and function calls for several
years now - like Andre I do not use functions but send commands - even
better in my opinion is to use getprop and setprop handlers - in your case
that would look like this:

put 1,000 into line 1 of marshalledData
put Soldiers into line 1 of marshalledData
-- get value(foo(param1,param2),btn bar)
get the foo [marshalledData] of btn bar

Where instead of a function the btn contains:

getprop foo [marshalledData]
 put line 1 of marshalledData into param1
 put line 1 of marshalledData into param2
 return param1 cr param2
end foo

Now what would be great would be if you could use arrays to marshall the
data, but unfortunately arrays cannot be passed as params

on mouseUp pMouseBtnNum
   put 1,000 into dataArray[num]
   put soldiers into dataArray[name]
put the foo [dataArray] of btn bar
   pass mouseUp
end mouseUp

getprop foo [dataArray]
   put dataArray[num] into param1
   put dataArray[name] into param2
   return param1 cr param2
end foo

This would ore than overcome the limitation of 1 param + rev control passed
to the called object (2 param2 + rev control for setprops).
___
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: Is this a bug?

2007-01-20 Thread Chipp Walters

Well then,

At least it's a bug in the documentation, where it clearly states:

Returns true if the specified object exists, false if it does not.

I, personally think it is a bug. If the goal is to force uniqueness and
'avoid time wasting confusion', then why even allow controls or objects with
the same name? I certainly understand if you have two fields with the same
name, and you reference the second one and you 'get' the first one. But to
say a control does not exist seems wrong, especially when 'object
instancing' is not allowed.

It's not a big deal, I, too use the id property to get around it. I can
certainly see the potential for a lot of confusion and broken scripts,
especially since the documentation also states:

Description
Use the exists function to make sure an object exists before you try to
perform an action on it, or to determine whether to create an object.
___
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: Is this a bug?

2007-01-20 Thread David Bovill

Chipp if you file it - I'll vote for it :) Existence is not to be quibbled
with.

By the way my understanding is that bug is not the official term -
according to the documentation:

the term 'bug' has been deprecated an the term anomaly is now the

preferred term. Errors or other anomalies within the Revolution programming
environment should be reported to the quality control department where they
will be dealt with appropriately.


___
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: (no subject)

2007-01-20 Thread Trevor DeVore

On Jan 20, 2007, at 6:18 AM, Robert Mann wrote:


I know there is a way to get the column type using

revDatabaseColumnTypes(firstcurID)

is there also a way to get all the other information about the  
column such

as PK, and the column type value   int(10)


I think you need to use the database specific queries for this  
information.  Here are ones for mysql, sqlite and postgresql (I  
*think* the postgresql one is right):


put mytable into pTable

SWITCH theDBType# get query to extract table info
CASE mysql
put SHOW FULL COLUMNS FROM `  pTable  ` into theSQL
break
CASE sqlite
put PRAGMA table_info(  quote  pTable  quote  ) into 
theSQL
break
CASE postgresql
		put SELECT column_name FROM information_schema.columns WHERE  
table_name = '  pTable  ' into theSQL

break
END SWITCH

Using one of the above queries and open a cursor.  You should then  
get one record for each field.


--
Trevor DeVore
Blue Mango Learning Systems - www.bluemangolearning.com
[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: Open and Closing MySQL

2007-01-20 Thread Jim Schaubeck


Found the answer...open an closing db in mysql after each script is 
fine...sorry for the newbie question.  The learning is going just fine!

Jim...

 
On Friday, January 19, 2007, at 01:51PM, Jim Schaubeck [EMAIL PROTECTED] 
wrote:
Folks,
Is it good practice to close a connection to a database right after you use it 
(MySQL)?  I don't have a problem writing the SQL every time, I just want to 
make sure it doesn't hurt anything if I did it that way.

Also, is there any more documentation somewhere on the rev commands for SQL?

Thanks for the help,
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


___
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: Open and Closing MySQL

2007-01-20 Thread Mark Schonewille

Hi Jim,

It won't hurt to open and immediately close a database after using  
it, but if you keep it open, you are able to refer to queries made  
earlier. My advise would be to keep the database open until you have  
finished working with it.


Best,

Mark

--

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

Get your store on-line within minutes with Salery Web Store software.  
Download at http://www.salery.biz


Op 20-jan-2007, om 16:17 heeft Jim Schaubeck het volgende geschreven:




Found the answer...open an closing db in mysql after each script is  
fine...sorry for the newbie question.  The learning is going just  
fine!


Jim...


On Friday, January 19, 2007, at 01:51PM, Jim Schaubeck  
[EMAIL PROTECTED] wrote:

Folks,
Is it good practice to close a connection to a database right  
after you use it (MySQL)?  I don't have a problem writing the SQL  
every time, I just want to make sure it doesn't hurt anything if I  
did it that way.


Also, is there any more documentation somewhere on the rev  
commands for SQL?


Thanks for the help,
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: Is this a bug?

2007-01-20 Thread Scott Rossi
Recently, Chipp Walters wrote:

 Furthermore, this statement no longer works either:
 edit script of button UFOs in group America

That's weird -- I didn't even know this syntax was permitted.  I always
thought one had to use of group not in group.  But of course, this
exposes the partial superfluousness in the language regarding of, because
the following also works:

  edit script of btn UFOs grp America this cd

Regards,

Scott Rossi
Creative Director
Tactile Media, Multimedia  Design
-
E: [EMAIL PROTECTED]
W: http://www.tactilemedia.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


Drag-Scrolling

2007-01-20 Thread Scott Morrow
 As an alternative to grabbing the scroll bars of the group I would  
like to be able to scroll a group of objects by clicking in the  
middle of the group and dragging.  This hadn't seemed like it should  
be that tricky but I'm bumping my head.  Any suggestions?


-Scott Morrow

Elementary Software
(Now with 20% less chalk dust !)
web http://elementarysoftware.com/
email   [EMAIL PROTECTED]

-

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


RE: (no subject)

2007-01-20 Thread Robert Mann
Thanks Trevor, 
I got this working but is there a way to do this for selected columns
Something like

gfields is a list of fields separated by comma


put SHOW  gfields  COLUMNS FROM `  gtable  ` into theSQL

this does not work get

revdberr,You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
'(addyrmodperm_id,tunername)COLUMNS FROM `addyrmodsize_permission`' at line
1

Thanks
Rob

___
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: Drag-Scrolling

2007-01-20 Thread Ken Ray
On Sat, 20 Jan 2007 11:02:49 -0800, Scott Morrow wrote:

  As an alternative to grabbing the scroll bars of the group I would 
 like to be able to scroll a group of objects by clicking in the 
 middle of the group and dragging.  This hadn't seemed like it should 
 be that tricky but I'm bumping my head.  Any suggestions?

Well, the first thing to know is that if you click in an area of the 
group that doesn't contain any other objects, you won't get the 
mouseDown event you want trap. So my suggestion would be to create a 
button or graphic that matches your background color and put it behind 
everything else in the group so you can trap the event.

Ken Ray
Sons of Thunder Software, Inc.
Email: [EMAIL PROTECTED]
Web Site: http://www.sonsothunder.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: Is this a bug?

2007-01-20 Thread Mark Wieder
Chipp-

Saturday, January 20, 2007, 6:57:21 AM, you wrote:

 'avoid time wasting confusion', then why even allow controls or objects with
 the same name?

Yep - this has bothered me for a long time, too. I'd certainly support
a referendum to disallow objects with the same name, but I'm afraid it
would break backward compatibility. VB supports object instancing in
the form of group America[2], but I don't care much for the syntax.

-- 
-Mark Wieder
 [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: Drag-Scrolling

2007-01-20 Thread Scott Rossi
Recently, Scott Morrow wrote:

 As an alternative to grabbing the scroll bars of the group I would
 like to be able to scroll a group of objects by clicking in the
 middle of the group and dragging.  This hadn't seemed like it should
 be that tricky but I'm bumping my head.  Any suggestions?

Hey Scott:

I just found the following among some test stacks -- maybe it's close to
what you're looking for.

  go url http://www.tactilemedia.com/download/dragscroll.rev;

Regards,

Scott Rossi
Creative Director
Tactile Media, Multimedia  Design
-
E: [EMAIL PROTECTED]
W: http://www.tactilemedia.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: Is this a bug?

2007-01-20 Thread Ken Ray
On Sat, 20 Jan 2007 12:23:16 -0800, Mark Wieder wrote:

 Chipp-
 
 Saturday, January 20, 2007, 6:57:21 AM, you wrote:
 
 'avoid time wasting confusion', then why even allow controls or 
 objects with
 the same name?
 
 Yep - this has bothered me for a long time, too. I'd certainly support
 a referendum to disallow objects with the same name, but I'm afraid it
 would break backward compatibility. VB supports object instancing in
 the form of group America[2], but I don't care much for the syntax.

Maybe if there was an instance property of an object, so you could do:

  put the number of instances of group America
  put 10 into field 1 of instance 1 of group America
  put the long id of instance 2 of group America into tID

(etc.)

Just a thought...

Ken Ray
Sons of Thunder Software, Inc.
Email: [EMAIL PROTECTED]
Web Site: http://www.sonsothunder.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: Is this a bug?

2007-01-20 Thread Phil Davis

Mark Wieder wrote:

Chipp-

Saturday, January 20, 2007, 6:57:21 AM, you wrote:


'avoid time wasting confusion', then why even allow controls or objects with
the same name?


Yep - this has bothered me for a long time, too. I'd certainly support
a referendum to disallow objects with the same name, but I'm afraid it
would break backward compatibility. VB supports object instancing in
the form of group America[2], but I don't care much for the syntax.


But the same-named object thing can sometimes be used to advantage. Consider 
this:

on mouseUp
  put the groupIDs of this cd into tGroupList
  repeat for each line tTargetID in tGroupList
switch (short name of grp id tTargetID)
case Section
  doSectionStuff tTargetID
  break
case Page
  doPageStuff tTargetID
  break
case Chapter
  doChapterStuff tTargetID
  break
end switch
  end repeat
end mouseUp

Admittedly, basing processing on the object name isn't the only way to do the 
above - just thought I would put my signature positive spin on yet another thing 
that can be an issue in certain contexts.  :o)


Phil Davis
___
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: Is this a bug?

2007-01-20 Thread Dave Cragg


On 20 Jan 2007, at 20:23, Mark Wieder wrote:



'avoid time wasting confusion', then why even allow controls or  
objects with

the same name?


Yep - this has bothered me for a long time, too. I'd certainly support
a referendum to disallow objects with the same name,


I assume any restriction on duplicate names would only apply at the  
same level within an object. Otherwise we'd have trouble with re- 
usable widgets made of grouped objects. For example, two table  
widgets on the same card should be named differently, but presumably  
not their component fields/buttons/sub-groups/etc. I.e. both tables  
can have buttons named header.


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: Is this a bug?

2007-01-20 Thread Chipp Walters

And Dave has demonstrated EXACTLY my problem with this. The simple fact is,
I am creating grouped widgets, which I have differently named components
within, which I would like to be able to address.

Mark, your example also demonstrates the power of same named instances of
object. I guess it all boils down to each of us trying our best to create
reusable grouped components, each with the same codebase. A most difficult
task.

For instance, take altFldHeader which creates column headers for fields.
( go URL http://www.gadgetplugins.com/altplugins/altFldHeader.rev; )

While it's been stable now for years, modifying old altFldHeaders still is a
problem as each instance has all of the code embedded in the group. The same
is true for many of my so called 'objects.' A benefit of this approach is
it's easy to do exception programming and track code as well with everything
being neatly packaged in a group. A big drawback is when you want to modify
the codebase, you have to replace each group, especially if you end up
adding a new control.

Separating the 'object' into a GUI library group and a background library
has it's own set of problems as well. You need to carefully track what
libraries are still being used. For instanec, they have to be inited from a
startup handler, so now you have at the minimum 3 different places for
custom object 'pieces': the library stack script, the GUI control group, and
a piece of init code in startup. You also need to be very careful using 'the
target' and if you have other system handlers, you'll need to make sure they
don't interfere, as they're called ALL THE TIME, instead of only when
needed. I'm not crazy about this approach, unless you're coding something
like libURL.

(Note: this could be simplified a bit by inserting the script of the object
into back, but the severe limitation on numbers of these makes it a poor
idea. All you need is 10 altFldHeaders and you've used up all your allowed
control inserts).

Perhaps a dynamic pseudo-instancer scripted from an installer might be an
interesting way to go. I don't know, I guess waiting until we get real
objects is the best way to go.

-Chipp

On 1/20/07, Dave Cragg [EMAIL PROTECTED] wrote:




I assume any restriction on duplicate names would only apply at the
same level within an object. Otherwise we'd have trouble with re-
usable widgets made of grouped objects. For example, two table
widgets on the same card should be named differently, but presumably
not their component fields/buttons/sub-groups/etc. I.e. both tables
can have buttons named header.

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



___
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: Drag-Scrolling

2007-01-20 Thread Chipp Walters

Scott Rossi,

I think it works, but I just keep seeing spots no matter where I scroll.
Getting dizzy now.
___
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: Pic-a-POD and Wikipedia Picture of the day woes

2007-01-20 Thread Sarah Reichelt

Hi Dom,

I got your email and answered it. Then I wrote a fix and emailed you
again asking if you would test it for me. I guess they got lost in
some spam filter, so hopefully this will get through...

If this gets to youand you don't mind, I will email you a new OS X
version. Do you want UB or PPC?

Cheers,
Sarah



On 1/20/07, Dom [EMAIL PROTECTED] wrote:

Hi Sarah!
I sent you a message some days ago to the troz address about this...

By going on the Wikipedia web site, it seems that Wikipedia has changed
its scheme for obtaining the Picture of the day as of January 1st; so
Pic-a-POD has some trouble retrieving this image -- it gets an image
some day and not another!

By the way, I am a fan of Pic-a-POD to get great pictures :-)

___
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: altFont etc.

2007-01-20 Thread Chipp Walters

Hi Klaus,

altFont on Windows installs the font as long as the app is running, but then
removes it when it quits. I forget how the Mac works, but I expect the
documentation has the info.

best,
Chipp

On 1/20/07, Klaus Major [EMAIL PROTECTED] wrote:


Hi friends,

can someone give me a little technical hint about altFont?

I can successfully  load and unload a font, now my question:
How long will the loaded font be available if I do NOT unistall the
font?

1. As long as Rev is running or
2. as long as Windows/the Mac is running (read: until the next
restart of either Rev or Win/ the Mac)?


Another question:
I just had a crash with Rev on Windows and the appropriate crashlog
file is a *.DMP
file of more than 12 (twelve!) MB!!!???

Is this the file I am supposed to attach to my bugzilla, ehm Rev
quality center report?

Thanks in advance.


Regards

Klaus Major
[EMAIL PROTECTED]
http://www.major-k.de

___
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: (no subject)

2007-01-20 Thread Trevor DeVore

On Jan 20, 2007, at 11:34 AM, Robert Mann wrote:


Thanks Trevor,
I got this working but is there a way to do this for selected columns
Something like

gfields is a list of fields separated by comma


put SHOW  gfields  COLUMNS FROM `  gtable  ` into theSQL

this does not work get

revdberr,You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to  
use near
'(addyrmodperm_id,tunername)COLUMNS FROM `addyrmodsize_permission`'  
at line

1


I haven't tried filtering before but maybe you can get some ideas  
from this page:


http://dev.mysql.com/doc/refman/5.0/en/show-columns.html

--
Trevor DeVore
Blue Mango Learning Systems - www.bluemangolearning.com
[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