From: "Cameron, Gemma (UK)" <gemma.cameron@...>
Date: 2006-08-15T01:05:55+09:00
Subject: Re: strange dbi


Johnf,

Have you tried using single quotes?

rows = db.select_all('select * from arcust')

Regards

Gem

-----Original Message-----
From: johnf [mailto:jfabiani@yolo.com]
Sent: 14 August 2006 16:45
To: ruby-talk ML
Subject: strange dbi

...

code:
require 'dbi'
db = DBI.connect('dbi:ODBC:mssql','username','password')

rows = db.select_all("select * from arcust")

However, if I change the sql statement to:
rows = db.select_all("select custno,company from arcust")
ALL WORKS.  Does anyone have any thoughts regarding why this is happening? 

John




********************************************************************
This email and any attachments are confidential to the intended
recipient and may also be privileged. If you are not the intended
recipient please delete it from your system and notify the sender.
You should not copy it or use it for any purpose nor disclose or
distribute its contents to any other person.
********************************************************************