I try what Venu suggests and it is working fine ... Send it to you to know about it , may be you need it in future thanks venu.....
Abdulrahman. --- Venu <[EMAIL PROTECTED]> wrote: > Hi, > > > -----Original Message----- > > From: Delphi Guy's > [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, November 22, 2001 2:06 PM > > To: [EMAIL PROTECTED] > > Subject: HOW TO : Run wave files stored in BLOB > field ??? > > > > > > Hi all, This the first post for me to this lists I > > appreciate If I take a good picture as I hear... > > > > I creat table in MySQL like this > > CREATE TABLE test > > ( > > ItemID INT NOT NULL > AUTO_INCREMENT, > > FirstName CHAR(50), > > LastName CHAR(50) NOT NULL, > > Sound LONGBLOB, > > PRIMARY KEY (ItemID) > > ); > > > > the Sound field is for storing wave files , it is > > stored ok .... > > now I want to run this wave from this field . > > I'm trying to use this methode by using ASP with > > MySQL... > > > > ============== Listenwav.asp File ============== > > > > <%@ LANGUAGE="VBSCRIPT" %> > > <% > > ' Clear out the existing HTTP header > information > > Response.Expires = 0 > > Response.Buffer = TRUE > > Response.Clear > > > > ' Change the HTTP header to reflect that an > audio > > is being passed. > > Response.ContentType = "audio/wave" > > > > StrConnection = > > "driver={MySQL};server=127.0.0.1;database=test" > > Set ADODataConn = > > Server.CreateObject("ADODB.Connection") > > ADODataConn.Open strConnection > > > > Set rs = ADODataConn.Execute("SELECT Sound FROM > > Test WHERE ItemID=1 ;") > > Response.BinaryWrite rs("Sound") > > Response.End > > %> > > > > ================================================ > > > > the HTML File will be > > > > ============== Listen.htm FILE ============== > > > > <HTML> > > <BODY> > > <EMBED > > src="ListenWav.asp" > > autostart=true > > loop=false > > > > > </EMBED> > > </BODY> > > </HTML> > > > > ============================================= > > > > this way is not working ... I don't know way ... > > > > Can any one tell me way , or how can I do it with > > another way... > > > > NOTE THAT I DO SAME WAY TO DISPLAY IMAGE AND IT IS > > WORKING FINE !!! > > > > I am not quite sure of ASP. As per the comments from > > another MyODBC user, the following code works fine > to play back your wav file. > > <HTML> > <BODY> > <bgsound src="listenwav.asp" loop="-1"> > </BODY> > </HTML> > > Can you try whether it works with you ? > > Regards, venu > -- > For technical support contracts, go to > https://order.mysql.com > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Mr. Venu > <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer > /_/ /_/\_, /___/\___\_\___/ California, USA > <___/ www.mysql.com > __________________________________________________ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
