From: Jeff Smith Date: 2011-08-17T04:24:14+09:00 Subject: Re: SQL statement w/ Ruby variables --000e0cd25830896e1604aaa43e3d Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable How do I pass the value of the variable? 2011/8/16 Bartosz Dziewo=C5=84ski > > Connection.Execute > > "Connection" is uppercase and I think it shouldn't. > > Also, you do realize you did not insert values of the variables into > the SQL string, only their names? (Unless the library you're using > does some really heavy magic.) > > > -- Matma Rex > > > > 2011/8/16 Jeff Smith : > > You are absolutely correct, I completely missed that. > > > > Getting a new error that references a method_messing (execute function)= , > so > > the search continues. > > > > Thanks. > > > > > > 2011/8/16 Bartosz Dziewo=C5=84ski > > > >> > sid =3D "12345678' > >> > >> You started the string with a quote and ended it with an apostrophe. > >> > >> > >> > Connection.Execute(=E2=80=9C > >> > >> The last character of this snippet is not a quote. This is a nice > >> Unicode quote, the one Word will insert into your documents. Same with > >> the one at the end of this line. > >> > >> > >> -- Matma Rex > >> > >> > >> > >> 2011/8/16 7stud -- : > >> > \223 ocatal =3D 147 decimal =3D 'o' with circumflex in extended ASCI= I > >> > > >> > It sounds like something isn't happy that it is being fed a non-asci= i > >> > character. > >> > > >> > -- > >> > Posted via http://www.ruby-forum.com/. > >> > > >> > > >> > >> > > > > --000e0cd25830896e1604aaa43e3d--