Re: mySQL database query

2005-07-06 Thread James Spencer
I think if I saw any one of these variations on "correct data" I could figure out how to do the others but my instinctive answer would be the previous record (or the new first record if the first record were the one deleted.) My first go at this isn't fussy; I just "know" that leaving a re

mySQL database query refreshing

2005-07-06 Thread James Spencer
As long as we are talking about mySQL, is there a way to programatically refresh a database query? I have a master/detail form which includes a button to delete the currently selected record and this works fine insofar as it deletes the record from the database but the fields and table all

Re: mySQL database query

2005-07-05 Thread Dan Shafer
James What constitutes "the correct data" to display after the deletion? Empty fields? Previous record? Next record? In some sort of sort sequence? Once you can define that, I think writing a bit of Transcript to give you what you want is pretty easy but there's no sort of de facto ru

mySQL database query

2005-07-05 Thread James Spencer
As long as we are talking about mySQL, is there a way to programatically refresh a database query? I have a master/detail form which includes a button to delete the currently selected record and this works fine insofar as it deletes the record from the database but the fields and table all

RE: MySQL Database Query Builder Question

2005-04-28 Thread Stephen Barncard
Dreamhost. <$10/month for all goodies. Great dedicated deals too. I host 15 sites there. Even the 'shared' hosting rocks... Can anyone recommend a good ISP with 'proper' database hosting (MySQL PHP etc...) Regards Martin McCarrick ___ use-revolution mai

Re: MySQL Database Query Builder Question

2005-04-28 Thread docmann
Hi Martin, I just had a look at the feature matrix provided by your hosting company and an upgrade may in fact be required, depending on the hosting package you have now Bummer. :( -Doc- On 4/28/05, Martin McCarrick <[EMAIL PROTECTED]> wrote: > Hi Docmann > > It seems that I cant even use p

RE: MySQL Database Query Builder Question

2005-04-28 Thread Martin McCarrick
ODBC connection) cannot be established." I'm moving Host. Can you suggest anyone? Regards Martin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of docmann Sent: 28 April 2005 11:16 To: [EMAIL PROTECTED] Cc: How to use Revolution Subject: Re: MySQL

RE: MySQL Database Query Builder Question

2005-04-28 Thread Martin McCarrick
5 10:49 To: [EMAIL PROTECTED] Cc: How to use Revolution Subject: Re: MySQL Database Query Builder Question Hello Xavier, Actually there is a link directly from the main phpMyAdmin page where you can check and or change the status (assuming you have the right access privilages). I know that on our LAN

Re: MySQL Database Query Builder Question

2005-04-28 Thread docmann
have been taken to the limit > > with > > >> call centre's. I would love to speak to an English speaking person who I > > can > > >> understand & who isn't simply referencing a FAQ (that I've already > > studied) > > >> to provide ans

Re: MySQL Database Query Builder Question

2005-04-28 Thread docmann
p; who isn't simply referencing a FAQ (that I've already > studied) > >> to provide answers. > >> > >> I think id like to simply change ISP (out the frying pan!) > >> > >> Thanks for your help > >> > >> Martin

Re: MySQL Database Query Builder Question

2005-04-28 Thread xbury . cs
t;> >> >> -Original Message- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] On Behalf Of >> [EMAIL PROTECTED] >> Sent: 28 April 2005 09:18 >> To: How to use Revolution >> Subject: RE: MySQL Database Query Builder Question >> >&

Re: MySQL Database Query Builder Question

2005-04-28 Thread docmann
imply change ISP (out the frying pan!) > > Thanks for your help > > Martin > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: 28 April 2005 09:18 > To: How to use Revolution > Subject: R

RE: MySQL Database Query Builder Question

2005-04-28 Thread Martin McCarrick
PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 28 April 2005 09:18 To: How to use Revolution Subject: RE: MySQL Database Query Builder Question Martin, Later I'll be trying to drive the phpmyadmin post and gets to make it run but as you imagine it's not very effi

RE: MySQL Database Query Builder Question

2005-04-28 Thread xbury . cs
ED] >[mailto:[EMAIL PROTECTED] On Behalf Of Sarah Reichelt >Sent: 28 April 2005 05:00 >To: How to use Revolution >Subject: Re: MySQL Database Query Builder Question > >Hi Martin, > >> I'm trying to connect to my database which is hosted by >> oneandone.co.uk

RE: MySQL Database Query Builder Question

2005-04-28 Thread Martin McCarrick
t access. Can anyone recommend a good ISP with 'proper' database hosting (MySQL PHP etc...) Regards Martin McCarrick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sarah Reichelt Sent: 28 April 2005 05:00 To: How to use Revolution Subject:

Re: MySQL Database Query Builder Question

2005-04-28 Thread xbury . cs
Note that some ISPs block this capability... Mine does... cheers Xavier On 28.04.2005 06:00:02 use-revolution-bounces wrote: >Hi Martin, > >> I'm trying to connect to my database which is hosted by >> oneandone.co.uk. I'm >> using the database query builder in RR. >> >> I set the name (Contact),

Re: MySQL Database Query Builder Question

2005-04-27 Thread Sarah Reichelt
Hi Martin, I'm trying to connect to my database which is hosted by oneandone.co.uk. I'm using the database query builder in RR. I set the name (Contact), host (db141.oneandone.co.uk) - this is the actual server name Database (db), User (dbo) Password () When I try to press

MySQL Database Query Builder Question

2005-04-26 Thread Martin
Hi, I'm trying to connect to my database which is hosted by oneandone.co.uk. I'm using the database query builder in RR. I set the name (Contact), host (db141.oneandone.co.uk) - this is the actual server name Database (db), User (dbo) Password () When I try to press