Re: StackRunner and MySQL
On Thursday 18 January 2007 06:47, Sieg Lindstrom wrote: > Thanks for the suggestion, Ken. I tried it as follows. StackRunner is in > the same folder that contains the folder "Externals." Here's the syntax I > used... > > revSetDatabaseDriverPath "/Externals/Database Drivers" > > That didn't fix the problem. Any other suggestions? Not sure if you have the right syntax here. Should it be looking relevant to the StackRunner path or the actual stack path (which may be different). Anyway, following your example you would want to drop the leading "/" wouldn't you? try: revSetDatabaseDriverPath "Externals/Database Drivers" Good luck, Rishi. ___ 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
StackRunner and MySQL
Thanks for the suggestion, Ken. I tried it as follows. StackRunner is in the same folder that contains the folder "Externals." Here's the syntax I used... revSetDatabaseDriverPath "/Externals/Database Drivers" That didn't fix the problem. Any other suggestions? Many thanks for your advice. Sieg Lindstrom Ken Ray wrote: > > Have you executed "revSetDatabaseDriverPath" in your stack that opens > before it starts making calls to the database? I believe this is done > automatically by Rev when you launch it, but StackRunner doesn't do > this, so your stack will need to do it before you start calling on > the database... >> >> Sieg Lindstrom wrote: >> Thanks, Ken. >> >> Your suggestion would certainly explain why the database calls sent >> by this >> stack don't work on computers where Revolution is not installed, >> but my >> computer includes the "dbmysql.bundle" file in the "Database Drivers" >> folder, and the problem still occurs. Just to make sure I have >> files in the >> right places, I have StackRunner in the folder that contains the 2.7.4 >> installation. The "Database Drivers" is nested in that same folder, >> and the >> stack I'm trying to run is nested in a folder that's also in the >> main 2.7.4 >> installation folder. Should that 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: StackRunner and MySQL
On Jan 16, 2007, at 12:18 PM, Sieg Lindstrom wrote: Thanks, Ken. Your suggestion would certainly explain why the database calls sent by this stack don't work on computers where Revolution is not installed, but my computer includes the "dbmysql.bundle" file in the "Database Drivers" folder, and the problem still occurs. Just to make sure I have files in the right places, I have StackRunner in the folder that contains the 2.7.4 installation. The "Database Drivers" is nested in that same folder, and the stack I'm trying to run is nested in a folder that's also in the main 2.7.4 installation folder. Should that work? Have you executed "revSetDatabaseDriverPath" in your stack that opens before it starts making calls to the database? I believe this is done automatically by Rev when you launch it, but StackRunner doesn't do this, so your stack will need to do it before you start calling on the database... Ken Ray Sons of Thunder Software, Inc. Web Site: http://www.sonsothunder.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
StackRunner and MySQL
Thanks, Ken. Your suggestion would certainly explain why the database calls sent by this stack don't work on computers where Revolution is not installed, but my computer includes the "dbmysql.bundle" file in the "Database Drivers" folder, and the problem still occurs. Just to make sure I have files in the right places, I have StackRunner in the folder that contains the 2.7.4 installation. The "Database Drivers" is nested in that same folder, and the stack I'm trying to run is nested in a folder that's also in the main 2.7.4 installation folder. Should that work? Many thanks for your help. Sieg Lindstrom Ken Ray wrote: > Well, StackRunner 1.5 was built using the 2.7.2 engine (see the > bottom of the page at http://www.sonsothunder.com/devres/revolution/ > downloads/StackRunner.htm), so it's possible that the mySQL commands > were changed between 2.7.2 and 2.7.4. > > However it's more likely that you don't have the mysQL database > drivers in the right place... StackRunner has the revdb external in > it so you can make database calls, but it is not bundled with all the > database drivers. These drivers should be in the "Database Drivers" > folder of your 2.7.4 installation and include something called > "dbmysql.bundle" which you'll need to connect to in order to use > mysQL from StackRunner. ___ 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: StackRunner and MySQL
On Jan 15, 2007, at 4:38 PM, Sieg Lindstrom wrote: I am trying to use StackRunner 1.5 to run a stack created with Revolution 2.7.4. (on a PPC Mac). I use this stack to manage data in a MySQL database. The stack runs fine when opened with Revolution, but when I open with StackRunner none of the MySQL queries work and instead I get error messages; all other scripts in the stack seem to run OK in StackRunner. Well, StackRunner 1.5 was built using the 2.7.2 engine (see the bottom of the page at http://www.sonsothunder.com/devres/revolution/ downloads/StackRunner.htm), so it's possible that the mySQL commands were changed between 2.7.2 and 2.7.4. However it's more likely that you don't have the mysQL database drivers in the right place... StackRunner has the revdb external in it so you can make database calls, but it is not bundled with all the database drivers. These drivers should be in the "Database Drivers" folder of your 2.7.4 installation and include something called "dbmysql.bundle" which you'll need to connect to in order to use mysQL from StackRunner. HTH, Ken Ray Sons of Thunder Software, Inc. Web Site: http://www.sonsothunder.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
StackRunner and MySQL
I am trying to use StackRunner 1.5 to run a stack created with Revolution 2.7.4. (on a PPC Mac). I use this stack to manage data in a MySQL database. The stack runs fine when opened with Revolution, but when I open with StackRunner none of the MySQL queries work and instead I get error messages; all other scripts in the stack seem to run OK in StackRunner. Can this be solved? How? Thanks for any suggestions! Sieg Lindstrom ___ 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