--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 Dziewoski <matma.rex / gmail.com> > > 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 <jesmith2095 / gmail.com>: > > 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 Dziewoski <matma.rex / gmail.com> > > > >> > sid = "12345678' > >> > >> You started the string with a quote and ended it with an apostrophe. > >> > >> > >> > Connection.Execute(> >> > >> 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 -- <bbxx789_05ss / yahoo.com>: > >> > \223 ocatal = 147 decimal = 'o' with circumflex in extended ASCII > >> > > >> > It sounds like something isn't happy that it is being fed a non-ascii > >> > character. > >> > > >> > -- > >> > Posted via http://www.ruby-forum.com/. > >> > > >> > > >> > >> > > > > --000e0cd25830896e1604aaa43e3d--