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