From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ken
Barker
Sent: 18 April 2006 15:40
To: [email protected]
Subject: Image - Audio file
> I have a SQL database that contains an audio file as an image. I am
attempting to pull it out and create an
> ASF file. The script does pull it out - but the file is un-playable.
Anyone have any ideas? Code snippet
> below.
>
> TIA
>
> $dbh1->{LongReadLen} = 1024 * 1024;
> my $sql0 = "select convert(binary(4000),recording)
> from databasetablename
> where convert(varchar(8),reportdate,112) = '20060414'
> and recording is not null
> and intcode = '19077'";
> my $sth0 = $dbh1->prepare($sql0);
> $sth0->execute || die "Can't perform select\n";
> my $var = $sth0->fetchrow;
>
> my $file = "rec.asf";
> open(FILE1,">$file") || die "Can't open $file\n";
> print FILE1 "$var";
> close FILE1;
> $sth0->finish;
This looks like a FAQ. See 'perldoc -q "binary data"', also 'perldoc -f
binmode'.
HTH
--
Brian Raven
=================================
Atos Euronext Market Solutions Disclaimer
=================================
The information contained in this e-mail is confidential and solely for the
intended addressee(s). Unauthorised reproduction, disclosure, modification,
and/or distribution of this email may be unlawful.
If you have received this email in error, please notify the sender immediately
and delete it from your system. The views expressed in this message do not
necessarily reflect those of Atos Euronext Market Solutions.
L'information contenue dans cet e-mail est confidentielle et uniquement
destinee a la (aux) personnes a laquelle (auxquelle(s)) elle est adressee.
Toute copie, publication ou diffusion de cet email est interdite. Si cet e-mail
vous parvient par erreur, nous vous prions de bien vouloir prevenir
l'expediteur immediatement et d'effacer le e-mail et annexes jointes de votre
systeme. Le contenu de ce message electronique ne represente pas necessairement
la position ou le point de vue d'Atos Euronext Market Solutions.
_______________________________________________
ActivePerl mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
