similar to: >>>mysql and php >>>

Morning everyone, I was going to ask someone here about how to reverse engineer a schema diagram from Mysql and visio because its hard to locate such information (http://techpanacea.blogspot.com/2008/07/creating-entity-relationship-diagram.html and the one place where its listed by google requires payment or registration) So i put it up here :

If you are attending the MySQL User Conference 2006, you are encouraged to come attend my session about Applied Ruby on Rails and AJAX. The session information is as follows: Applied Ruby on Rails and AJAX Farhan Mashraqi Track: LAMP, Community Projects Date: Thursday, April 27 Time: 2:20pm - 3:05pm Location: Ballroom B Adoppt (http://adoppt.com) is a fully

i just deployed my app on ubuntu with passenger. i installed the mysql gem as follows: $ sudo gem install mysql Select which gem to install for your platform (i486-linux) 1. mysql 2.7.3 (mswin32) 2. mysql 2.7.1 (mswin32) 3. mysql 2.7 (ruby) 4. mysql 2.6 (ruby) 5. Skip this gem 6. Cancel installation > 3 Building native extensions. This could take a while... Successfully installed

As ip''m only entreprener and not develoer, i''ll request you some help on the following subject : Ruby VS PHP for my new web start-up. I''m compiling all information there, you can add your contribution and i''ll edit asap my post. http://gregorytalon.blogspot.com/2007/04/ruby-on-rails-vs-php.html Cheers, Greg <a

I have some problems with php and Prototype.I am trying to implement listbox population (second dropdown box values depend on first dropdown) using php,Mysql and Prototype.But i have no idea how to implement . I hope you all have sucessfully done this, please show me an example --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the

Hi I''ll get to it right away: 1. I have a simple page with a form, in this form there is a "select" box with a number of options. On the right i also have a "input" field with a submit option. 2. When the user puts something in the input field and hits submit, a php script is run, that puts that entry in mysql table. Question: 3. How do i with Ajax update the

I just did an unwanted mysql upgrade and am now unable to start the mysql service. After doing some searching the common solution is to just create a symlink ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock The issue for me is I don''t have the file I am trying to symlink to (/var/run/mysqld/mysqld.sock) If I try to start mysql manually (mysql start) I get the error: # mysql start

I have been trying to connect to MySQL thru rails. Initially I had rails 2.1.2 and upgraded to rails 2.2 to use RestAPI in sproutcore. Once I have upgraded my rails version to 2.2, I have been getting this error. All I did is the following: 1. rails addressbook 2. cd addressbook 3. script/generate scaffold Contact first_name:string lastname:string 4. rake db:migrate I also change the

Hi, Just running a simple unit test and trying to save an object gives me this error. test_validations(FriendTest): NoMethodError: undefined method `each'' for #<Mysql:0x38f60d0> c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/mysql_a dapter.rb:292:in `columns'' .... .... Rails 1.1.6 mysql 5 mysql gem 2.71 After I

Hi, I have a multiple checkbox of values 1 to 7 for selecting weekdays. What is the possibility of storing the selected weekdays array in mysql and what type of field should i create in the table for storing the array. Any suggestions??? Regards, Vimal Das --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups

def self.up execute("delimiter ^ ") sql = <<-_SQL CREATE TRIGGER customer_bi BEFORE INSERT ON customers FOR EACH ROW BEGIN SET NEW.sndx = SOUNDEX(NEW.lname) ; END ^ _SQL sql.split(''^'').each do |stmt| execute(stmt) if (stmt.strip! && stmt.length > 0) end execute("delimiter ;

Hi, When I try to install "gem install mysql" it throwing error. For your ref, bash-2.05b$ gem install mysql -- --with-mysql-dir=/opt/etrade/p6/share/mysql5 ERROR: http://gems.rubyforge.org/ does not appear to be a repository ERROR: could not find gem mysql locally or in a repository bash-2.05b$ gem install mysql -- --with-mysql-config=/opt/etrade/p6/share/mysql5/bin/mysql_config

I''m having problem trying to get the app running properly due to it not finding MySQL.It seems that the app can''t find mysql. This error shows up on my production log: MissingSourceFile (no such file to load -- mysql) -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the

Hi, I have just started using Ruby on Rails with cPanel. I can set up my application ok but I am having problems with linking the application with a mysql database. I have run ruby sctipt/generate model and created the table through the migration. The table appears in the database correctly. The original settings were for sqlite3 but I want to use mysql so that may be the issue. I have changed

I have a rails app serving up XML on an infrequent basis. This is being run with mongrel and mysql. I''ve found that if the app does not get exercised for longer than a few hours it goes dead ("Lost Connection to MySQL") and starts throwing Errno::EPIPE errors. It seems that the mysql connection gets timed out for inactivity or something like that. It can be restarted with

My app consists of receiving emails with image attachments from its users so I have been employing the MMS2R gem and Fetcher. Every 60 seconds the app goes to the email server to fetch emails. Under Rails 2.1.1 things worked fine - when I received an email, the email was fetched, parsed and saved to the database. However I needed to upgrade to Rails 2.2.2 for unrelated reasons and now I get the

I got my first taste today of dealing with the default values in MySQL. It seems that Rails loads the default values for fields based on the database (seems reasonable, specify in one place and let if flow through). The problem is that if I say NOT NULL and do not specify a default value, MySQL inserts a default value anyway. See http://dev.mysql.com/doc/refman/5.0/en/data-type-defaults.html

Hi! I have ran on problem with collations. In database.yml I have set: encoding: utf8, but when in console run: >> ActiveRecord::Base.connection.collation => "latin1_swedish_ci" It is Rails 2.1, mysql gem 2.7, mysql 5.1.22. This leads to errors like: Mysql::Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation

Hi I''m a noob to RoR. I have everything setup but can''t figure out to get the list display as I would like. I''m sure this is very simple stuff. I just haven''t figured it out yet :( I hope someone can point me in the right direction :) I have a mysql table "websites". In it I have the following columns - Name, Url, Banner, Description I created

Hi, I got Mac OS X 15.6 installed, Locomotive 2.0.8 and MYSQL 5.0.67 running. I''m having this problem when I try to install mysql gem: Last login: Mon Feb 9 13:37:37 on ttys001 source /var/folders/be/bexGvm9pHdq0vcEmR8-WWk+++TM/-Tmp-//39E424DB-A260-4E41-AA2E-30B64FB46F3C-7395-00002254065EA712.environment.bash You have mail. MBPEduCirilo:~ eduardocirilo$ source