similar to: MySQL Datetime Format confusion

Displaying 20 results from an estimated 1000 matches similar to: "MySQL Datetime Format confusion"

2006 Jun 19
4
DateTimes get converted to Dates in XML-RPC????
Hi all - I have written an XML-RPC app using action-web-service. Mostly works well. Except I just noticed that my :datetime types are coming back as :date types. That is, when in the console I query the record via Foo.find_by_id(123) I get back actual datetimes. If I then do it via XML-RPC, fetching that same record I get back dates (ie. hour/minute/second are set to 00:00:00) Any ideas?
2006 Jul 29
0
SOAP for large datasets
I''ve been playing around with a soap interface to an application that can return large datasets (up to 50mb or so). There are also some nested structures for which I''ve used ActionWebService::Struct with 2-3 nested members of oher ActionWebService::Struct members. In addition to chewing up a ton of memory, cpu ulilization isn''t that great either. My development
2002 Jul 02
1
subscript out of bounds
Hello As I'm beginning to write functions, I decided to have my personnal R library named MyStuff located in /home/fred/R.Lib/MyStuff/ The library file itself is at /home/fred/R.Lib/MyStuff/R/MyStuff evrything seems ok since > library() gives : Packages in library `/usr/lib/R/library': KernSmooth Functions for kernel smoothing for Wand &
2010 Feb 10
0
Folders within folders ...
Our mail setup is as follows: ~/mail/ - This contains single mailboxes (Drafts, Trash, and others) ~/mail-Archives/ - This contains a hierarchy of folders containing mailboxes For example, a tree of ~/mail/ would look like this: ~/mail/ ~/mail/Trash ~/mail/Drafts ~/mail/sent-mail ~/mail/My Stuff ~/mail/Important ~/mail/test/SomeFolder
2009 Oct 27
2
Porting Custom Packages from Linux to Windows
On my linux workstation I have a nice, very little project in a directory called "mystuff" I installed "mystuff" into site-library with R CMD build, R CMD check and R CMD install. This was all with the file mystuff.tar.gz. Now I want to install "mystuff" on my windows workstation. Can I use the same file mystuff.tar.gz. Do I need to do something different with R
2009 Jul 12
11
get DB data to rhtml file
I am trying to get data out of a database to my rhtml file. The files look like this: Model ------- mystuff.rb class Mystuff < ActiveRecord::Base set_table_name "mytable" set_primary_key "id" end Controllers -------------- mystuff_controller.rb require ''Mystuff'' class MystuffController < ApplicationController def read @me =
2006 Feb 28
5
Problem with paginate, include and foreign keys
Hi all, Solaris 10 Ruby 1.8.4 Rails 1.0.0 Postgres 8.1 postgres driver 0.7.1 I''m having a problem with getting paginate() to properly pick up an FK constraint properly. I don''t seem to have this issue with ActiveRecord, however. Consider: create table start_dates ( id bigserial, start_date date unique, max_slots int default 40, primary key (id) ); create
2006 Feb 28
1
Working with date_select ...
I am a little confused about the best way to work with date_select. I see that in my views it generates a simple input form that allows for the entry of year, month and date information. If I just leave it at that, great! But what if now in the controller, I want to work with the date information. I actually want to take the user input date and compute a new date some number of days in the
2007 Jul 08
2
datetime_select, is creating an instance of the Time class
Hello It seems that datetime_select, is creating an instance of the Time class. Why would that be? I found this while building a site where people can create vigils (prayer vigils, peace vigils, etc). When I added a validation method that compared start_date to created_at, it generated the error: ArgumentError (comparison of Time with DateTime failed): I was able to put a breakpoint in the
2006 May 25
3
webservice timeout issue
I am having an issue where I am trying to test a weservice that I wrote by connecting to it from ruby. When I submit my form that calls the webservice it times out. you can see from the lighttpd log that the webservice completes just after the timeout. any ideas? am I doing something wrong? ---- source ---- def validate auth = ActionWebService::Client::Soap.new(AuthApi, "
2007 Feb 21
1
Rendering all the elements when calling Array#to_xml
When I call to_xml on an array, I want it to get the XML for all the elements in it. I''ve defined to_xml in my class. >> r.to_xml => "<video><id>1</id><views>2</views></video>" >> a = [r] => [#<StatisticsReport:0x3259f38 @video_id=1, @views=2>] >> a.to_xml => "<?xml version=\"1.0\"
2006 Mar 22
12
RJS page.replace(_html) problems
For some time now I try to get my code working. This Monday I switched to RJS (first with 1.0 + plugin) and yesterday to Edge Rails, so I guess I''ve been using the most recent version. I have a div with id="detail" which I want to update with a partial. If I''m using page.replace_html the content will be replaced with text, i.e. the javascript won''t become
2006 Apr 15
2
Multi-parameter assignment
Hi, I''m trying to submit data from text boxes on a form to one variable in my controller, in the same way that datetime_select has date(1i), date(2i), etc for day, month, year, etc... I''ve named my variables event[start_date(1i)] event[start_date(2i)] and event[start_date(3i)] but this doesn''t seem to work and event[:start_date] is blank ... any pointers would be
2007 Apr 09
1
help with ActiveRecord joins
I''m working on a fairly complex join query and could use a bit of advice from more expert users of ActiveRecord. I have an events table with quite a lot of data, with has_many relations to categories, age_groups, and event_images. In my first naive implementation, each event had a date, so to load all upcoming events efficiently, I''d do: Event.find(:all,
2009 Jan 09
2
Confused about to_xml() in ActiveRecord::Base subclass
Since all my efforts to control how to_xml() is formatting dates has failed, I''m now considering writing my own to_xml(). However, from the limited examples I''ve found, I just don''t understand how to actually reference the columns for the records in my record set. Here''s a simplified view of my ActiveRecord object: class Errors < ActiveRecord::Base
2007 Sep 11
2
How to search with range when I am using AAF
acts_as_ferret :fields => { :name => {:}, :desc => {}, :start_date => {} } def start_date self.start_datetime.strftime("%Y%m%d") end Now that I am strong start_date in YYYYMMDD format, I want to search for all event in between 20070506 and 20070809 What will my query look like when I am using aaf. This one doesn''t work
2009 Jan 21
1
AR to_xml problem with associations, Builder::XmlMarkup#to_a
When I do a to_xml(with a block) on an association of a model I got a Builder::XmlMarkup#to_ary should return Array Example that does not work. @intervenant = Intervenant.find(params[:id]) output = @intervenant.to_xml( :skip_types => false, :dasherize => false) do |xml| @intervenant.individu.to_xml( :builder => xml, :skip_instruct => true, :skip_types => false,
2006 Dec 03
0
How to best change the default value of dasherize (using Edge Rails, and knowing about :dasherize => false)?
Hi all, I''m trying to turn off dasherize in all cases, since converting underscores to hyphens breaks the way that I want to handle XML (with E4X in Flex 2). I''ve read the other threads about dasherize on this list. I''m on Edge Rails, so I can successfully turn off dasherize for a single usage with something like render :xml => @task.to_xml(:dasherize => false)
2006 Jun 21
3
Simple range question
I have a model with a datetime field called start_date. I''d like to do a find on the model so that it returns only records with the start_date equal to the current day. Something like this: @foos = Foo.find(:all, :conditions => //?? start_date equal to today''s date ??// ] ) Thanks in advance for any help. -------------- next part
2012 Mar 07
2
SSOAP and Chemspider: Security token?
Dear community, has anyone managed to get SSOAP working with the ChemSpider Web APIs, using functions which need the security token? I use SSOAP 0.9-0 from the OmegaHat repository. In the example code from SSOAP there is a sample which uses a token function. Interestingly, it checks if(!is.character(token)) first (and proceeds if the token is NOT character.) I can't test that function since I