Re: mySQL problem... HELPPPPPP
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 the correct (new) userID is in the record, but the query still retrieves it. 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 :-( Anyone any suggestions? I'm running RR version 2.7.2 on OS X, using a mySQL 4.1 database with the MyISAM engine Sounds strange. * You sure that you have SINGLE database which you query from app and CocoaMySQL? * I could think that in APP you not finish transaction, but you use MyISAM. So not a case. * how exactly looks your INCORRECT result? -- Best regards, Ruslan Zasukhin VP Engineering and New Technology Paradigma Software, Inc Valentina - Joining Worlds of Information http://www.paradigmasoft.com [I feel the need: the need for speed] ___ 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: mySQL problem... HELPPPPPP
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 from the message box? Are you using the DB Query builder, harder to troubleshoot, or is this all hand generated? When I've experience something similar it is usually because I use global, local and temporary variables of similar names and occasionally use one out of context: gMyDbSqlQuery,lMyDbSqlQuery,tMyDbSqlQuery gMyDbData,lMyDbData,tMyDbData Those t's and 'ls can be hard to distinguish with a quick glance at the Variable Watcher, but obviously some contain newer data and others older. HTH ___ 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
mySQL problem... HELPPPPPP
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 the Joblines table. When I update a record in Jobs, a few fields get modified in the Jobs table and a new record is created in the Joblines table. What is shown is based on a userID, so when a job is sent to another user, the UserID changes. To refresh the screen I just create a query that shows all relevant jobs of a user, when he clicks on a job, all joblines are retrieved from mySQL. 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 the correct (new) userID is in the record, but the query still retrieves it. 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 :-( Anyone any suggestions? I'm running RR version 2.7.2 on OS X, using a mySQL 4.1 database with the MyISAM engine Warm regards, Ton Kuypers Digital Media Partners bvba Tel. +32 (0)477 / 739 530 Fax +32 (0)14 / 71 03 04 http://www.dmp-int.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
MySQL problem...
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 because there is confusion between quote and apostrophe ... revExecuteSQL IDdata,insert into table1 values (5,'c'est beau l'amour') Sig... ___ 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: MySQL problem...
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 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 because there is confusion between quote and apostrophe ... revExecuteSQL IDdata,insert into table1 values (5,'c'est beau l'amour') Sig... ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: ___ 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
MySQL problem(2) ...
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 record etc... Thanks ... ___ 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: MySQL problem(2) ...
--- 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... How can I jump to record 100 in one step, see it, and go to the next record etc... Thanks ... Hi Jean-Pierre, If you're using the Automated queries and database linked controls, you can use the undocumented command 'revGoToRecordOfQuery'. If your query is named 'foobar' then use: ## on mouseUp revGoToRecordOfQuery foobar,100 end mouseUp ## This will automatically update all the controls linked to that query. If you're using revdb library calls , you'll just have to iterate over the revdb cursor with 'revdb_movenext' until you get there: ## on mouseUp global gCursorID local tCurrentRec -- determine where we are in the cursor put revdb_currentrecord(gCursorID) into tCurrentRec if tCurrentRec 100 then repeat 100 - tCurrentRec times get revdb_movenext(gCursorID) end repeat else repeat tCurrentRec - 100 times get revdb_moveprev(gCursorID) end repeat end if -- now that we're at the right record, do something -- ... end mouseUp ## Hope this helped, Jan Schenkel. Quartam Reports for Revolution http://www.quartam.com = As we grow older, we grow both wiser and more foolish at the same time. (La Rochefoucauld) __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.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: MySQL problem...
--- 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 (:1,:2),5,new word so i can't use c'est beau l'amour as new word because there is confusion between quote and apostrophe ... revExecuteSQL IDdata,insert into table1 values (5,'c'est beau l'amour') Sig... Hi Jean-Pierre, When you're using the data binding option of the revdb library calls, you need to use variable names, not their content: ## on mouseUp global gConnectionID local tQuery, tFirstValue,tSecondValue put INSERT INTO table1 VALUES(:1,:2) into tQuery put 5 into tFirstValue put c'est beau l'amour into tSecondValue get revdb_execute(gConnectionID,tQuery,tFirstValue,tSecondValue) end mouseUp ## Of course, you can always escape the apostrophe in the query by using a backslash, as JBV suggested. Hope this helped, Jan Schenkel. Quartam Reports for Revolution http://www.quartam.com = As we grow older, we grow both wiser and more foolish at the same time. (La Rochefoucauld) __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.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: MySQL problem(2) ...
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 around, would you? Or would that be considered documenting them? -- -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: MySQL problem(2) ...
--- 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. You wouldn't happen to have a list of the undocumented ones around, would you? Or would that be considered documenting them? Heh, they're all there for your perusing, in the 'revDatabase' frontscript. Just open the Message Box, go to the 'Front Scripts' tab, tick the 'Show Revolution UI Front Scripts' checkbox, and doubleclick the line 'revDatabase' in the list that appears. Most of them have a short explanation of what they do. Unfortunately, the fact that they're undocumented means they can change at any given time. On the plus side, this means they can rip it out and improve it at some point in the future, maybe even adding engine-level data bindings? Jan Schenkel. Quartam Reports for Revolution http://www.quartam.com = As we grow older, we grow both wiser and more foolish at the same time. (La Rochefoucauld) __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.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