-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Thanks for the reply but Hmm.. have tried that but still wont work.
On Tuesday 01 April 2003 02:13, you wrote: > Hi - > > On 1 Apr 2003 at 1:20, Jasmine wrote: > > -----BEGIN PGP SIGNED MESSAGE----- > > Hash: SHA1 > > > > > > Hi > > > > Is there any way to pass variables into MySQL statements for execution? I > > m using the DBI package. Thanks! > > > > Heres my snippet and it doesnt work. > > dbconnect(); > > prepare the query for execution > > my ($sql01) = join "select description from table where > > host=", "$abc;"; > > Why not make that simple? As: > my $sql01 = "select description from table where > host='$abc';"; > > Baring syntax errors, etc, that should work. > > > print "$sql01 \n"; > > my $query01 = $dbh -> prepare($sql01) || die "Prepare > > failed: $DBI:: errstr \n"; > > $query01 -> execute; > > > > > > > > Jasmine Chua > > > > -----BEGIN PGP SIGNATURE----- > > Version: GnuPG v1.2.1 (GNU/Linux) > > > > iD8DBQE+iHj3NgvTa7Hj2AURAh2tAJ9fDIZ40/9CI9ZhCDncYh7B+8BBEQCgqPoI > > VA22fTtDlaYIEL3gXu0PgJM= > > =x2jl > > -----END PGP SIGNATURE----- > > > > > > -- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] - -- Jasmine Chua Security Engineer SecureCiRT Pte Ltd Blk 750C Chai Chee Road #04-01 [EMAIL PROTECTED] Singapore 469003 Tel: 6243 6800 DID: 6243 6802 Fax: 6441 5119 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQE+iIhmNgvTa7Hj2AURAiF7AKCcvKhDEEZjcek9SH9PoOPvUorB4gCeNftp REpAts/lKns/rDBLZjo2SNY= =84l9 -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]