You searched for the word(s): userid:48394

More Search Options

RSS Available

• Re: Need help - alter time stamps based on time record written

  I need the whole proc and the creation script for the associated tables any other relivant info, then I can have a look at it.

  Posted to MySQL (Forum) by TinyPond on 11/24/2009

• Re: Need help - alter time stamps based on time record written

  That is a standard error and you most likely are missing something in your syntax.

  Posted to MySQL (Forum) by TinyPond on 11/23/2009

• Re: VS versional Support

  Thanks you for keeping everyone up to date on what can and can not be done. Sorry to hear of this limitation.

  Posted to MySQL (Forum) by TinyPond on 11/23/2009

• Re: VS versional Support

  I don't think the problem with MySQL c/NET add-in is with the VS2010 or VS2008 Std or Pro. I would recommend going to http://powershell.com/cs/ and posting your questions on the FORUM there. Regards and best of Luck

  Posted to MySQL (Forum) by TinyPond on 11/20/2009

• Re: Need help - alter time stamps based on time record written

  Time to debug I would suggest the following starting at the SET @newtime I would comment out that line and then compile your stored proc, if success then uncomment and move to the next line and do the same thing. You will find the line that its complaining about. Be sure after the comment -- you have a space. You will get a error if you put --Set vs. -- Set. I see three lines of code so this should be easy for Let me know how it goes CREATE TRIGGER `tr_fixtimes` BEFORE INSERT ON ewise_slice FOR EACH

  Posted to MySQL (Forum) by TinyPond on 11/20/2009

• Re: VS versional Support

  Please post back your findings, because this may help others that go down your same path. Cheers

  Posted to MySQL (Forum) by TinyPond on 11/20/2009

• Re: Plural search in mysql

  try this, not sure if its missing the mark. where description like '%cover%'

  Posted to MySQL (Forum) by TinyPond on 11/20/2009

• Re: Need help - alter time stamps based on time record written

  Try something like this it will work. Also it might be easier to get a procedure working first and then move it to a trigger after you have the syntax working properly. I also believe that you might have some logical errors and datatype problems new.time_text,INTERVAL @newtime SECOND to add them they both need to be cast to the same type. CREATE TRIGGER `tr_fixtimes` BEFORE INSERT ON ewise_slice FOR EACH ROW BEGIN Declare NewTime,GooDTIME DATETIME; SELECT TIMESTAMPDIFF(SECOND,MAX(ewise_slice.slice_timestamp

  Posted to MySQL (Forum) by TinyPond on 11/20/2009

• Re: Need help - alter time stamps based on time record written

  I would need to see you entire MYSQL trigger please post it and I will give it a review.

  Posted to MySQL (Forum) by TinyPond on 11/19/2009

• Re: Need help - alter time stamps based on time record written

  What error are you getting

  Posted to MySQL (Forum) by TinyPond on 11/19/2009