Re: mySQL problem... HELPPPPPP

2006-09-24 Thread Kay C Lan
On 9/23/06, Ton Kuypers <[EMAIL PROTECTED]> wrote: I even removed all extra stuff and just sent the query (giving the correct result in CocoaMySQL) using the revDataFromQuery command, but I keep on getting the same (incorrect) result :-( Do you get incorrect data when you run revDataFromQuery

Re: mySQL problem... HELPPPPPP

2006-09-24 Thread Ruslan Zasukhin
On 9/23/06 8:18 PM, "Ton Kuypers" <[EMAIL PROTECTED]> wrote: Hi Ton, > The strange thing is, that when I update the jobs, the old ones are > still there, even when the UserID is not correct anymore. > Using the same query in CocoaMySQL gives the correct result. > When I click on a Job, I can see

mySQL problem... HELPPPPPP

2006-09-23 Thread Ton Kuypers
Hi, I've ran into a very strange problem and tried everything to solve it but no luck so far. Maybe someone else can shed a light on what's happening here... I have an application that connects to a mySQL database. I have a record in the Jobs table, containing various related records in t

Re: MySQL problem(2) ...

2006-08-22 Thread Jan Schenkel
--- Mark Wieder <[EMAIL PROTECTED]> wrote: > Jan- > > Tuesday, August 22, 2006, 11:10:33 AM, you wrote: > > > If you're using the Automated queries and database > > linked controls, you can use the undocumented > command > > 'revGoToRecordOfQuery'. > > I hate all these undocumented db commands.

Re: MySQL problem(2) ...

2006-08-22 Thread Mark Wieder
Jan- Tuesday, August 22, 2006, 11:10:33 AM, you wrote: > If you're using the Automated queries and database > linked controls, you can use the undocumented command > 'revGoToRecordOfQuery'. I hate all these undocumented db commands. You wouldn't happen to have a list of the undocumented ones aro

Re: MySQL problem...

2006-08-22 Thread Jan Schenkel
--- Jean-Pierre Soto <[EMAIL PROTECTED]> wrote: > hello, > > I have a some problem with MySQL , > > this line work fine : > > revExecuteSQL IDdata,"insert into table1 values > (5,'new word')" > > but this one doesn't work , why ? > > revExecuteSQL IDdata,"insert into table1 values >

Re: MySQL problem(2) ...

2006-08-22 Thread Jan Schenkel
--- Jean-Pierre Soto <[EMAIL PROTECTED]> wrote: > Sorry ... I have too big finger ... > > I have another problem ... > > I can access to any data in the database but when I > want to see > complete record one by one, I have just > FIRST,PREVIOUS,NEXT and LAST > with built-in manager... > > H

MySQL problem(2) ...

2006-08-22 Thread Jean-Pierre Soto
Sorry ... I have too big finger ... I have another problem ... I can access to any data in the database but when I want to see complete record one by one, I have just FIRST,PREVIOUS,NEXT and LAST with built-in manager... How can I jump to record 100 in one step, see it, and go to the next

Re: MySQL problem...

2006-08-22 Thread jbv
Jean-Pierre, have tou tried putting a backslash before the apostrophe : revExecuteSQL IDdata,"insert into table1 values (5,'c\'est beau l\'amour')" Jb > hello, > > I have a some problem with MySQL , > > this line work fine : > > revExecuteSQL IDdata,"insert into table1 values (5,'new wo

MySQL problem...

2006-08-22 Thread Jean-Pierre Soto
hello, I have a some problem with MySQL , this line work fine : revExecuteSQL IDdata,"insert into table1 values (5,'new word')" but this one doesn't work , why ? revExecuteSQL IDdata,"insert into table1 values (:1,:2)",5,"new word" so i can't use "c'est beau l'amour" as new word