Postgres .find doesn't work

[fiestacasey]

Using any of my models, I can use findOne but not find.

Example:

#define
User = pg_db.define('User', {
    name: { type: String, length: 255 }
    username: { type: String, length: 255 }
    token:  { type: String, length: 255 }
    email:  { type: String, length: 255 }
  }, {table: 'users'})


User.find {where: {name: 'name'}},(err,users)->
  if err?
    console.log err

Gives me:

{ [error: syntax error at or near "["]
  length: 83,
  name: 'error',
  severity: 'ERROR',
  code: '42601',
  detail: undefined,
  hint: undefined,
  position: '46',
  internalPosition: undefined,
  internalQuery: undefined,
  where: undefined,
  file: 'scan.l',
  line: '1001',
  routine: 'scanner_yyerror' }

[1602]

Model.find is for searching by id, Model.all - for querying collection,
Model.findOne - querying single record. Check api docs for abstract-class
at makedoc.node-js.ru

On Tue, Apr 3, 2012 at 1:15 AM, kcsobo <
reply@reply.github.com

wrote:

Using any of my models, I can use findOne but not find.

Example:

#define
User = pg_db.define('User', {
name: { type: String, length: 255 }
username: { type: String, length: 255 }
token: { type: String, length: 255 }
email: { type: String, length: 255 }
}, {table: 'users'})

User.find {where: {name: 'name'}},(err,users)->
if err?
console.log err

Gives me:

{ [error: syntax error at or near "["]
length: 83,
name: 'error',
severity: 'ERROR',
code: '42601',
detail: undefined,
hint: undefined,
position: '46',
internalPosition: undefined,
internalQuery: undefined,
where: undefined,
file: 'scan.l',
line: '1001',
routine: 'scanner_yyerror' }

---

Reply to this email directly or view it on GitHub:
#55

Thanks,
Anatoliy Chakkaev

[fiestacasey]

awesome. thank you for pointing me in the right direction.