Getting the row number depends on the DB you're using; Oracle supports this (via ROWNUM) but MySQL for example does not.

Your statement is invalid; if you want to update a row you should be doing:...

In your controller do you have


@user = User.find(:first)


or something similar? Could you post your controller code?

Why revive a 2 year old thread?

Did your source file definitely have a .rb extension? Did anything at all appear in the output window?

Looking at your code I can't see whats wrong.

What happens if in your view you do


<% for st in @stocks -%>
<%= h(st.inspect) %><br />
<% end %>

select id,
( cast(current_timestamp as date) - cast(return_date as date) ) * 3 as fine
from books
where
return_date > current_timestamp


This is how to do the select in postgresql however...

Have you read the postgresql docs?

http://www.postgresql.org/docs/8.2/static/libpq.html

Digg uses script.aculo.us; if jquery doesn't do what you need it may also be worth a shot.

http://script.aculo.us

You should find the method described here (http://www.kanthak.net/opensource/file_column/) suitable. It works for any file type.

Matt is right; try to get used to closing a tag right after you open it then typing between them (this way you won't leave any tags unclosed). Some html editors do this for you (bluefish, quanta,...

'Costs more money' does not automatically mean better.

LOL stands for 'Laugh Out Loud'

I think the pencil icon means that you are subscribed (or have contributed to) that particular thread.

I'm no PHP expert but do you have to have a complete comparison for each item in the expression?

eg

if ( ($variable == "GBP") || ($variable == "EUR") ){
$display = "my text here";
}

Teens statistically are more likely to have an accident due to inexperience on the road but its wrong to say all teens are bad drivers.

I'm 24 now, I have 6 years no claims and my insurance is...

"w+" is a mode string; it truncates the file (or creates a new one if it doesn't exist)

|f| is a block. Basically it means that in the following code f refers to the file.

A quick example of a...

For some reason the rubycentral site seems to be down so the original (http://www.rubycentral.com/book/ospace.html) article I'd link to isn't available, however it's in the google cache...

UNIQUE is a constraint applied to tables that ensures that all values in the given columns are unique. If you try to insert a existing value the you will get an error (along the lines of 'insert...

The rails framework is based on Basecamp

You need to give more information. What do you want to be selected and when?

If you want a default value put
t.column :favourite_colour_id, :integer, :default => 1
in your migration.

If you...

Vim is all you will ever need.

I don't think it is possible; javascript has no control over the cursor.

Or you could just use Firefox or Opera?

quick example using action_mailer.

If you don't have it already gem install 'action_mailer'



require 'action_mailer'

ActionMailer::Base.server_settings = {
:address =>...

Do you have a c compiler installed?

if not do :


sudo apt-get install build-essential

duplicate of what? all duplicates? why don't you have a unique identifier? do you have any validation? why are you here? why am i answering you?

Your problem is that you are not specifying a column to join on.

What do the two tables have in common? What is it about a record in table A that means it should be placed next to a record in...

What version of wine are you using?

Does autodetect in winecfg work?

Does TDate not provide the functionality you require?

What exactly was the problem you're having with FCKEditor?

Of the open-source ones FCKEditor and TinyMCE seem to be the best for general development and Kupu is geared at Zope/Plone and that...

right click file -> properties -> open with -> select firefox (if its not there click add and find it)

also check out the preferred applications option in desktop -> preferences menu.

dunno why...

if you can't find it try


whereis irssi


or


locate irssi

application.terminate;

select *
from table
where date >= [start date] and date <= [end date]

or (i'm not 100% sure if this works in mysql but it does in postgres!)

select *
from table
where date between [start...

this (http://windirstat.info/) open source app may be of use to you.

similar programs for mac (http://www.derlien.com/) and linux (http://www.methylblue.com/filelight/)

>cls

It actually boots linux from the CD. It won't touch your Windows install but will simply mount your hard drive as a desktop icon. From there you just need to navigate to my documents (or wherever...

My advice would be to get hold of a knoppix (http://www.knoppix.com) cd, obviously as your computer is in a state you may need a friend with broadband to download and burn it.

You can then boot...

No problem. I when you said 'i have two servers' I assumed you were talking about work.

If you're starting I recommend this (http://php.about.com/od/learnphp/p/learn_php_free.htm). Also, the php...

$connection = mysql_connect(IP_ADDRESS_OF_DATABASE_SERVER:PORT_YOU_SET_MYSQL_TO_LISTEN_ON, DB_USER, DB_PASS)
or die("Query failed : " . mysql_error());
$db = mysql_select_db(DB_NAME,...

Just set the host parameter of the mysql_connect function to the IP address of the other server. You'll also need to open the MySQL port (3306) on the other server if it's closed