Displaying 20 results from an estimated 10000 matches similar to: "Using varchar() and/or concatented pks"
2006 Jul 25
3
Ruby hangman (was Re: List etiquette question)
"Beast" is more appropriate than you know. It''s definately Frankenstein
code. (read: it ain''t pretty, but it works - some of the time). Anyway, it
entertains my wife; not sure if hardcore programmers will get anything out
of it or not.
You might find it interesting (or pointless) that in a complete
bastardization of rails'' main reason for being it
2006 Jul 13
4
script injection/cross-site scripting protection
When is it possible to set <script>while(true){}</script> as the value of
project.name, what it the best way to escape the output of the following?
<td><%= project.name %></td>
Dennis Byrne
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060713/bbdedb86/attachment.html
2006 Jul 05
3
override created_on column name
We are using Rails for a project that must integrate with a legacy
database. Is there a way to get Rails to automatically set the timestamp
for a column named something other created_on or updated_on ?
Also, how does one manipulate the size of the database connection pool?
Dennis Byrne
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
2006 Jun 27
2
Transaction syntax for > 1 table/model
If I want to wrap two account updates, the syntax is ...
Account.transaction(dennis, david) do
dennis.withdraw(10);
david.deposit(10);
end
.. where both dennis and david are instances of Account.
Can someone please let me know what the syntax is for starting and ending
a *single* database transactions which spans two *different* kinds of
models/tables ?
Dennis Byrne
-------------- next
2006 Jul 11
1
session state w/ >1 processes
When routing requests to more than one fcgi process, what are my options
with Rails? Are most people in the community just using some form of
session affinity?
Dennis Byrne
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060711/2a366faa/attachment.html
2006 Jun 28
20
Rails Vs JBoss Seam
I have been frustrated with J2EE technology just like any other developer who has worked in that
technology for a long time. This made me learn about Rails and I was excited about RoR. Today I
came across JBoss Seam framework and I am not able to contain my excitement.
My passion for JEE development is back. It seems like it is better than RoR. I would like to hear
differnt opinions about this
2006 Mar 12
5
AR - Migrations - how to use a varchar as primary key instead of int ?
Hi
I''d like to have a varchar primary key named id instead of the default int
id. Does anyone knows how to specify this from migrations ?
Should I also specify something in the model class ?
thanks!
Thibaut
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060312/797bca4b/attachment.html
2006 May 22
2
Inserting data in a table with a varchar key field
Hi all,
I have some problems inserting data into a legacy table. the key field
of this table is a field named CIN which is a varchar(15).
when I try insert into this table using a form (generated by the
scaffold generator) I get this Error :
_____________________________________________________________________
undefined method `CIN_before_type_cast'' for #<Candidat:0x370d8c8> |
2006 Jun 12
0
Varchar not valid parameter ?
Is the type varchar not valid for migrations scripts ?
I kept getting migration failures until I changed it to type :string.
Stuart
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060612/407e17bf/attachment.html
2008 May 13
0
SqlServer Activerecord Adaptor + VARCHAR(MAX) Woes
I seem to be running into various issues between SqlServer and Rails,
and so far have been able to solve everything save for a particular
quirk when running unit tests.
When I run "rake test:units" on my app, it gets so far as to run
db:schema:load. I''m dealing with a legacy database, so it''s loading all
sorts of tables that I don''t care about, but
2007 Nov 29
2
sqlQuery of variable of type varchar - confusion with "."
Dear list,
I have a rather large dataset in SAS which I export to a SQLite database for subsequent use in R.
One of the columns is
cowidp
1881501224.2
1881501224.2
and the column is stored as a character in SAS. It becomes a varchar in the database (it should be - it is an identifier; not a number). Reading this into R gives
cowidp
1 1881501224
2 1881501224
....
- i.e. the
2008 Sep 02
2
MySQL lookups on VARCHAR with accents
I am running into problems with MySQL and lookups. The table has character
set utf8, but:
mysql> select id, token from tokens where token = ''esta'';
+-------+-------+
| id | token |
+-------+-------+
| 83417 | está |
+-------+-------+
1 row in set (0.00 sec)
How do I configure things so MySQL doesn''t ignore accents?
TIA,
Jeffrey
2006 Jan 18
1
using unique varchar instead of id
Hi,
I just signed up so ''hello everybody''.
As the title suggests, I was wondering if there was an easy way to specify that I want all actions/controls to be based upon a particular parameter rather than :id (in this case :unique_name). I don''t :id to appear in URLs or elsewhere, I want it all to work from :unique_name.
It seems like something that I should be able to
2005 Feb 15
1
Trellis barchart, column display order issue
I have searched the archives and instructions high and low but have not
found what I need.
I have a dataframe named Data with columns:
AdjResND0 - the numeric result
Parameter - the classification (chemical name)
Sort - the order I want the chemical names to appear, with leading zeros
so all are the same length
Client.Name - the sample name
I am trying to generate a series of 1 page barcharts,
2015 Sep 18
1
CentOS-6 Logwatch 7.3.6 behaviour
After some experimenting I have observed that overriding settings from
/usr/share/logwatch/default.conf/logwatch.conf in
/etc/logwatch/conf/logwatch.conf does not produce consistent results.
For example, if I replace the default detail configuration in
etc/logwatch/conf/logwatch.conf with:
Detail = High
It does indeed change the level of detail from the default Low set in
2006 Jun 26
0
DBI question. How do I load a database with data parsed from REXML?
I wrote a rexml script that parses rather big xml files (DOM parsing) and
builds an object out of them. This is what it looks like after i parse the
xml file and display the object:
[#<Article:0xb79e7428 @brand="This is a story from ", @id=5337,
@fblurb="burb", @ntype="news type here", @copy="Copyright \302\251 2006 ",
@source="source",
2002 Oct 10
3
pks for openssh
I was directed to the following site by one of our customers regarding
a keyserver built into openssh. There's a patch for 3.4p1 on their
site, but the license isn't very clear, nor is it clear if they have
approached the openssh team regarding the inclusion of this subsystem
into openssh proper.
I've been asked to patch Mandrake's openssh with this feature, but I'm
2000 Sep 05
0
[PATCH] Added features for AIX authentication
Please find attached a patch I put together to provide some useful extras
using
OpenSSH 2.2.0p1 under AIX. I have been forced to write these to allow
OpenSSH to
conform to our local security policy and to aid our user administration
department.
Please note that in testing of this latest release we found "useLogin yes"
to be
broken again. Since login provides no extra functionality in
2006 May 18
8
Concatenated key
Hi all,
I started playing a couple days ago with Rails and it find it very
interesting.
But I''m a bit stuck with making it work with a concatenated primary key.
I want to use my own names for the DB fields and I''m using SQL Server
2005.
My tables look roughly like this:
CREATE TABLE USERS (
USR_ID VARCHAR(25) NOT NULL PRIMARY KEY,
USR_PASS VARCHAR(25)
)
CREATE TABLE
2004 Dec 01
1
rsync transfers whole content when a new hardlink is created
Hi,
I detected a silly behaviour of rsync when new hardlinks of already synced
files are created:
Scenario:
There are a local directory and a equal remote directory created by former run
of rsync.
Create a hardlink from a already existing file (both inside the local
directory).
If this hardlink has a filename with comes before the original filename when
both are sorted in
alphabetic order,