similar to: uniform handling of timestamps

looking at the unit tests of activerecord leads me to think the db is completely responsible for auto-incrementing the id field and rails does no magic here. can someone confirm that this is a true statement? that being the case - what is the preferred way to write database agnostic sql for one''s schema since each of the dbs has slightly different syntax for this functionality... does

anyone? -a -- =============================================================================== | EMAIL :: Ara [dot] T [dot] Howard [at] noaa [dot] gov | PHONE :: 303.497.6469 | When you do something, you should burn yourself completely, like a good | bonfire, leaving no trace of yourself. --Shunryu Suzuki ===============================================================================

i''ve got a little rails app i''m messing with the schema is create table timedatevalidates ( id serial, timedatetovalidate timestamp, primary key (id) ); the mvc was initialized using rails scripts/generate scaffold timedatevalidate i''ve got this in a subdir of webroot and have modified .htaccess and config/routes.rb like so .htaccess :

i''ve been bashing my head against the screen for about two hours... for the life of me i could not figure out why connections to mysql were failing when view through browser but NOT from the command line as user apache... i confirmed that all connection parameters were correct and still no go. eventually i disabled selinux and all is well. there was a configuration section that claimed

line 212 of postgresql_adapter.rb is return Time.now.to_s if value =~ /^\(''now''::text\)::(date|timestamp)/ i don''t think this will work. in postgresql the field ''now'' is pinned to the SAME TIME for the duration of a transaction. eg. if you do begin transaction; insert into t values(42, ''now''); # sleep one minute

Greetings all-- Humble newbie requesting help here. I''ve just installed Ruby 1.8.2, Rake 0.4.15, and RubyGems 0.8.8. When I try to get Rails into place via "gem install rails," I get the error below. What have I done wrong? Can anybody throw me a rope? Attempting local installation of ''rails'' Local gem file not found: rails*.gem Attempting remote

I went to RedHats' page and found hardware requirements and it said that the Dell Poweredge 6300 is a supported hardware. Then I went to linuxcare.com and it does not list the machine. Before I look like a buffoon, or continue to, Redhat will run on this machine, right? I appreciate the help. Thanks, --------------------------------------------------- Tony Ricker Technology Coordinator

Hi, I''m using SQL Server. I have a BIT field. I have a fix and a question. This is a patch for a bug in the SQL Server adapter that causes any insert or update to fail: lib/active_record/connection_adapters/sqlserver_adapter.rb @@ -239,2 +239,2 @@ - when TrueClass then (column && column.type == :boolean ? "''t''" : "1")

All, I was hoping someone could point me in the right direction in obtaining a solution to the the following; I want to have the log in script map not only their home directory, but also the group folders as well. For instance, I would have a share with valid users=@usergroup and would want the script to map the directory based on this criteria. Would I have to have a log on script for each

I''m having a problem converting a date retrieved from my MySQL database and I''m hoping someone can help. MySQL stores the date/time as this: 2005-03-08 17:00:34.0 and according to my Pickaxe book Ruby stores times as "the number of seconds and microseconds since [...] January 1, 1970". All well and good. Unfortunately, RoR is converting my date to this:

I''ve used mysql for quite some time now. Other than crashing when the partition gets full, I''ve had no problems with it. But I''ve heard great things about postgres and have seen some people say it''s much superior to mysql. So, with a Rails application, is there any reason why I would want to learn/use another DB besides mysql? Any pragmatic benefits?

I think my rails app has a slow memory leak that degrades performance over the course of several days. I''d like to get to the bottom of it but in the meantime I''d prefer to just bandage it and force the fcgi library to start a new instance of my app every so often. Is there a clean way to do this? Calling break in the each_cgi loop causes an error. Sending SIGUSR1, which

I need a few pointers for the import of data into Samba. Here is the set up... I will be getting the data from an NT box that is on the same network more or less (they are our PDC and WINS, we are the DNS). I was told that once Redhat and Samba was set up, it was a simple copy and paste. If I have learned anything, nothing in computers is simple. I have about 200 users private folders being

Arne, With regard to your log on script not working, that ususally means permissions issues. Does everybody have permissions for the full path for the log on script? Hope this helps. Cheers, Tony Arne Van Renterghem wrote: > Hi, > > I 've been following the list for some time now and the question of the > profiles has been put forward several times, but I havn't seen a

All, I have the following in my smb.comf for printing commands... # NOTE: If you have a BSD-style print system there is no need to # specifically define each individual printer [printers] comment = All Printers path = /var/spool/samba browseable = no print ok = yes print command = /usr/bin/lpr -P%p -r %s lpq command = /usr/bin/lpq -P%p lprm command = /usr/bin/lprm -P%p %j

I hacked a forking FCGI dispatcher for Rails. I have no idea if this is the correct way to do it, but it seems to work fine. It improves memory usage a bit; after it is started the processes share almost 10 MB (of 12 MB total), but unfortunately it drops to 2 MB after a few requests. ===================================== #!/usr/local/bin/ruby require File.dirname(__FILE__) +

Hello all. I have a question about setting up samba to serve windows printing. I have been trying to research this but keep coming up with conflicting howto's. Can someone give me directions to an up-to-date print howto? It would be greatly appreciated as I am stuck on this. Cheers, Tony -- ------------------------------- Tony Ricker Technology Coordinator SLUCare - P.M.O. St. Louis

Hi all, Last night, I wrote a web-based syntax highlighter that takes Ruby and produces nice HTML of the code, ready for including on web pages, or in blog posts, or whatever. I don''t know how useful it will be for other people, but feel free to use it. Anyway, the URL is : http://syntax.carldr.com/ Any comments/suggestions would be gratefully received. Enjoy!

Dear all, I would like to know how to keep primary gid status when using ssh command. We know that, with sg command in ssh command line, it is successful in this case. If there is the setting on sshd, I want to know the way. Can you please advise me. I show a example as below. $ id uid=1002(taro) gid=1002(suzuki) groups=10(wheel),1002(suzuki),8001(tanaka) $ newgrp tanaka $ id uid=1002(taro)

I am a relatively new user to R, and I am trying to learn more about converting data in an XML document into "2-dimensional format" such as a table or array. I might eventually wish to export this data into a relational database such as SQL, and/or to work with this data within the R package. My sample XML document is located at "