mysql and ruby 1.8

[Stefan Schmiedl]

Greetings, everyone.

Does anybody have the ingredients at hand to get a working
connection between Ruby 1.8 and (MySQL and PostgreSQL) on
a Windows XP box?

Thanks,
s.

[Matt Lawrence]

On Mon, 17 Nov 2003, Stefan Schmiedl wrote:

> Does anybody have the ingredients at hand to get a working
> connection between Ruby 1.8 and (MySQL and PostgreSQL) on
> a Windows XP box?

Install Linux? :-)

Actually, I suggest you look at the ruby-dbi package.

-- Matt
Boredom isn't the root of _all_ evil, but it tries.

[Sabyasachi Mustafi]

--Next_1069059200---0-202.54.124.152-28271
Content-type: text/plain;
charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

You may try this. =0A1. You have to connect to Mysql with dbh=0A2. Then pre=
pare, execute and fetch=0A=0AFollowing is a method from our project in the =
PHED department (Govt. of West Bengal, India) =0A=0Adef take_blockname #MET=
HOD FOR TAKE BLOCK NAME FROM THE TABLE BLOCK=0A dbh =3D DBI.connect($va=
rDataBase,$varUser,$varPass)=0A=0A #dbh =3D DBI.connect('dbi:Mysql:PHE1:=
100.100.100.1','test','')=0A sql =3D "SELECT block_name FROM BLOCK where=
dcode =3D '#{$blockDCode}';"=0A #print sql=0A dbh.prepare(sql)=0A t=
b =3D dbh.execute(sql)=0A str =3D tb.fetch()=0A get_block =3D str.to_a=
=0A =0A while(str!=3Dnil)=0A str =3D tb.fetch()=0A get_block<<str.to_=
a=0A end =0A dbh.disconnect =0A #print get_block=0A $cmbBlockBName.e=
ntries =3D get_block #SENDING BLOCK NAMES TO THE COMBO BOX=0A =0A=0Aend #=
ENDING METHOD FOR TAKING BLOCK NAMES=0A=0AOn Mon, 17 Nov 2003 Matt Lawrence=
wrote :=0A>On Mon, 17 Nov 2003, Stefan Schmiedl wrote:=0A>=0A> > Does anyb=
ody have the ingredients at hand to get a working=0A> > connection between =
Ruby 1.8 and (MySQL and PostgreSQL) on=0A> > a Windows XP box?=0A>=0A>Insta=
ll Linux? :-)=0A>=0A>Actually, I suggest you look at the ruby-dbi package.=
=0A>=0A>-- Matt=0A>Boredom isn't the root of _all_ evil, but it tries.=0A>=
=0A>=0A
--Next_1069059200---0-202.54.124.152-28271--