syntax error in this mysql code

Question

This is the mysql code written for ruby on rails application

Model.find_by_sql(["SELECT * FROM domainurls WHERE domaindetail_id = ?",@id ,"and count IN (SELECT Max( count ) FROM domainurls WHERE domaindetail_id =?",@id,")"])

It gives me error

"error is: wrong number of arguments (0 for 1)"

Can anybody have idea what's wrong in the code?

May be you should add a space before "and count in..."

Pavan
– Pavan

2012-01-04 10:26:48 +00:00
Commented Jan 4, 2012 at 10:26 — Pavan
– Pavan, Commented Jan 4, 2012 at 10:26

Code Lღver · Accepted Answer · 2012-01-04 10:26:26Z

1

Here you require data in two query because of IN can search data within an array. Either your query

(SELECT Max( count ) FROM domainurls WHERE domaindetail_id =?",@id,")

will return many column.

So first execute this query and take counts in a array and after that execute second query.

I think you have understood.

answered Jan 4, 2012 at 10:26

Code Lღver

15.6k16 gold badges61 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mahmoud Gamal · Accepted Answer · 2012-01-04 10:26:29Z

1

The keyword count is a reserved word, so you have to escape it with `` like:

... and `count` IN (SELECT Max( `count` ) FROM domainurls ...

answered Jan 4, 2012 at 10:26

Mahmoud Gamal

80.2k18 gold badges143 silver badges168 bronze badges

Collectives™ on Stack Overflow

syntax error in this mysql code

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related