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] > -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
