Frederick Cheung wrote: > That sort of state is done on a per connection basis. > Secondly my understanding is that the point of changing the delimiter > to $$ is because you don't want a ; in your function to be interpreted > as the end of your create function statement. However if multiple > statement handling isn't turned on, do you need to change the > delimiter at all ? (you would need to separate the drop and the > create since those are two separate statements) > > Fred
I'm way out of my league here, but I believe you need to set the delimiters when you store a function: SQL requires ';' termination at the end of individual statements within the function, but unless you modify the delimiters, the client will interpret ';' as the end of the CREATE FUNCTION ... call. There's an explanation for the delimiter munging[*] on the mysql site: http://dev.mysql.com/tech-resources/articles/mysql-storedproc.html ... but heck, I'm willing to try it w/o the delimiters. Just not today -- client deadline. - ff [*] MUNG: (verb and acronym), recursively defined as "Mung Until No Good" -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
