on-rev queries

[Bob Sneidar]

I think I see what is going on here. The connection is being made with sqlYoga initially, but of course like every good server, on-rev drops the connection after a period of inactivity. Now normally I would execute an SQL statement through sqlYoga, but there is no function or command as yet that allows me to simply execute an SQL statement and return a result, or not that I have been able to find. 

So I have to get the database ID using an sqlYoga function, then use the rev IDE to query the on-rev database. Often, by that point, the connection has been dropped. I think the fix for this for now is for me to issue dbconn_connect every time I access the database. This would be automatic for queries done through sqlYoga, but as I said, I can't use that right now for raw SQL queries. 

One thing I should mention though that I find odd, is that the function revdb_execute() does not generate an error in a try/catch construct, even if the connection has been dropped and the command fails! Maybe someone could pick up on that and update the IDE to incorporate that. 

Bob


On Feb 2, 2010, at 2:04 PM, Sarah Reichelt wrote:

> On Wed, Feb 3, 2010 at 7:59 AM, Bob Sneidar <bobs at twft.com> wrote:
>> Hi all. Executing queries directly with the on-rev mySQL database I have seems to beach ball Revolution at times.
> 
> Hi Bob,
> 
> I haven't been following this thread very closely, but it seems that
> you are allowing odd things to happen, which may be part of the
> problem.
> As I envisage databases on a server, you set up the database & it's
> table manually using phpMyAdmin or the equivalent.
> 
> Web pages then get to read & write records, but do not mess with the
> basic structure of the database.
> 
> If you consider that there may be multiple concurrent connections,
> this makes sense as the table cannot be dropped if someone else is
> actually reading it at the same time.
> 
> I have used a MySQL database via On-Rev and it has seemed very fast
> for both reading & writing, but I did all the setup through cPanel and
> phpMyAdmin first.
> 
> HTH,
> Sarah
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution