Sorry didn't realise your server was Windows. I'm not an expert on Windows but I'm sure you could use a scheduled task in cron's place.

In ruby if you don't know what class an object is you can use it's class method and the docs to find out.


% irb --simple-prompt
>> a = :something
=> :something
>> a.class
=> Symbol

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:...

I think you should look at the LOAD DATA INFILE (http://dev.mysql.com/doc/refman/5.1/en/load-data.html) docs and cron a script to import for you

I misunderstood your first post.

If the column is varchar and you have a comma separated list of IDs there isn't a clean way of joining.

You should review your table design and possibly...

You seem to be getting mixed up with your joins.

You need to do an inner join to get the winning bids. I'd create this as a view:

I just typed this from memory so sorry about the table/column...

I think a self join is required:


select distinct
d1.id
from dtlstbl as d1
inner join dtlstbl as d2
on d1.id = d2.id
and d2.refid = 2
where

Not really sure what you're asking. What column type is sales_categories?

Also your SQL is confusing; try aliasing the table names and aligning it:


SELECT pd.products_name,
...

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?

No problem, its not the most obvious solution

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

Installed rails? I know its not the be-all and end-all of ruby web development but it is decently documented and probably the easiest way of getting an up and running ruby-based webapp.

Sounds like watir (http://wtr.rubyforge.org) will do what you want.

Here (http://wiki.openqa.org/display/WTR/Example+Test+Case) is an example of how to set up a google search

Easiest way is to dist-upgrade to hardy; the latest ipods (i.e. classic) should then work (i use rhythmbox on debian sid and it works fine)

http://en.wikipedia.org/wiki/The_internet

When will people realise that Jabber/XMPP is the future?

A quick and dirty method would be to select into a temp table that has a identity column and then use that as the basis for your query. I wouldn't use this method if performance is high on your...

create database medical_records;


Hope this helps.

select ar.url
from amp a
join ampref ar on a.amp_id = ar.amp_id
where a.name like 'luna'

Books Online (http://msdn2.microsoft.com/en-us/library/aa257103.aspx) is probably a decent way to start.

Also I suggest trying some queries with the Northwind database; work out how to add...

Try starting it and navigating to http://localhost:3000

Vim (http://www.vim.org/) is all you need

Neither language is 'more powerful' - you can achieve the same thing in either.

And while Google use Python heavily afaik they don't use Django (I may be wrong but I don't think they do).

Both...

Thanks Ed :)

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 %>

'starting up' ?

Do you mean the Windows loading screen?

If it gets to the 'Loading Windows XP' screen you may need to do a system repair with an XP disk.

If it doesn't get as far as the...

KDE is not supported because this is a LTS release; KDE 4 will be brand new when Ubuntu 8.04 is released and there is no guarantee that the KDE guys will still be writing security updates etc for...

sqlite (http://www.sqlite.org/) is exactly what you're after.

"...SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite...

I hope you didn't quit your day job.

Although your solution is fine it can be a little more readable (and re-usable) in rails.

In the controller:


def banner(text)
span = String.new
text.split(//).each_with_index do |c, i| ...

I'd actually nominate Dune 2 as the most influential RTS; although TA brought 3D to the table.

Others that would be on my list are:

Civilisation
Super Madio Bros
Sim City
Mario 64
Elite...

From my experience using STI isn't too bad so long as too many models are involved; it can get messy using the rails method with the 'type' column.

Of course you could try with CTI but its...

If you want an bulletproof car you can get them from http://www.edisposals.com

From the description of a bullet proof vauxhall omega 3.0 litre:

" Driver and passengers protected for 7.62. Also...

$condition1 = @$_GET['cond1'] ;
$condition2 = @$_GET['cond2'] ;
$condition3 = @$_GET['cond3'] ;

mysql_connect("dbhost","dbuser","dbpass") or die("Unable to connect to server");...

I find it easier to specify the join as follows and seperate the where clause; if your data is correct the following query should work:


select
ap.name
,ap.add
,p.status
...

You can add as many :has_many and :belongs_to statements to each model as you like.

Then you can access the associated like this:


#in controller
def view
@actor = Actor.find(1)
end

Glad you're so enthusiastic about it - another invaluable resource when you're starting out is IRC; lots of knowledgable people in both #ruby-lang and #rubyonrails on freenode if you get stuck and if...

How do you get experience in development?

What languages do you currently know/use? Find one you like (I suggest reading up, downloading and trying some out).

Once you've picked a starting...

If your site is technical I wouldn't imagine that many would be using 1024x768.

Saying that, it should still look ok in that resolution. If you're using CSS properly your site should look decent...