allow kakak2..
saya mu nanya lagi...(hihi perasaan nanya terus deh)
saya mau ngambil *ERRORNUMBER n SQLSTATE *
dari sebuah operasi di sql di rails --> db MySQL
saya sudah nemu, tapi masih pake native gitu
----------------------------------------------------------
require "mysql"
begin
# connect to the MySQL server
dbh = Mysql.real_connect("localhost", "testuser", "testpass", "test")
# get server version string and display it
puts "Server version: " + dbh.get_server_info
rescue Mysql::Error => e
puts "Error code: #{e.errno}"
puts "Error message: #{e.error}"
puts "Error SQLSTATE: #{*e.sqlstate*}" if e.respond_to?("sqlstate")
ensure
# disconnect from server
dbh.close if dbh
end
----------------------------------------------------------
nah *e.sqlstate *itu yang pingin saya ambilll
tapi pake ORM nya rails (pake ActiveRecord mungkin)
misalnya untuk mendeteksi kalo server MySQL down
ato duplicate entry primary key
contohnya :
----------------------------------------------------------------
def create
begin
@item = Item.new(params[:item])
if @item.save
flash[:notice] = 'Item was successfully created.'
redirect_to :action => 'list'
else
render :action => 'new'
end
rescue *# disini harus exception apa?*
flash['notice']="Tdk bs di save"
*# saya ingin mendapatkan SQLSTATE error disini*
redirect_to :action => "new"
end
end
----------------------------------------------------------------
nah..gitu..
mohon bantuannya....trima kasihhhh
--
Regards,
Irvan Setiyanto
[Non-text portions of this message have been removed]
