>
> What error do you get ?
>
> Fred
sorry fred i'm unable to reproduce same error.
So i start with another one..........
params[:album]="Bust a Move (12\" Remixes) - EP"
TempRoyaltyReport.update_all("artist_name...@artist},album_name
=...@album},upc = #{params[:upc]},status = 'corrected'", "artist_name =
\"#...@corrected_artist.artist_name}\" and album_name =
\"#...@corrected_artist.album_name}\" and upc =
'#...@corrected_artist.upc}'")
And I get following error
Mysql::Error: #42000You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'Remixes) - EP",upc = 829357903914,status =
'corrected' WHERE (artist_name = "VAR' at line 1: UPDATE
temp_royalty_reports SET artist_name="Young MC",album_name ="Bust a Move
(12" Remixes) - EP",upc = 829357903914,status = 'corrected' WHERE
(artist_name = "VARIOUS ARTISTS" and album_name = "RMXXOLOGY DELUXE" and
isrc = 'USDE10801060')
--
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 rubyonrails-talk@googlegroups.com
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
