Forums
This topic is locked
CDO database email & MP3 download help needed....
27 May 2002 16:50:45 ed p posted:
hello ultradev people... heres a couple of things i need help with :i'm making a website for musicians to store their music and make it easier for them to reach more people...
<u>problem 1:</u>
the mp3 filename is stored in a database, and then the link is just displayed on the screen for visitors to click on. the problem is that how the file is downloaded depends on how the visitors computer is configured. i was wondering if anybody had any idea on how i could control what happens once this link was clicked... ie : is it possible to select what application will run the mp3 ... or can i select to download the file as a 'normal' file as opposed to treating it as a URL and trying to load a page into the browser.
<u>problem 2:</u>
i use CDO mail to send email from the website. i was trying to create a contact page for people who sign up to the site that doesnt display their email. the email addresses are stored in a database. i couldnt manage to get the CDO mail to work with emails that are stored in a database... does anybody know how to do this?
thanx for reading..... hopefully somebody can help
Replies
Replied 27 May 2002 19:17:17
27 May 2002 19:17:17 David Behan replied:
Answer 1:
Goto www.basic-ultradev.com/extensions/index.asp?searchOn=force and download this extension - BUD FORCE DOWNLOAD. It does exactly what it says on the tin.
Answer 2:
Is a mailing list extension you are working with or what? If you can send them an email using request.form("email"
then you can easily send them one using the database value. Filter the database on the record you want and instead of requesting the "TO" address from a form, use the database value. Example code:
Set objCDO = Server.CreateObject("CDONTS.NewMail"
objCDO.To = rsMember.Fields.Item("MEM_EMAIL"
.Value
objCDO.From = "Music Company"
objCDO.Value("Reply-To"
= "
"
objCDO.Subject = "Hello"
objCDO.Body = "This is the body"
objCDO.Send
Set objCDO = Nothing
Hope that helps...
Dave
_________________________
David Behan - www.site-manager.com/af.asp?a=11&l=1tds9p6x2
Goto www.basic-ultradev.com/extensions/index.asp?searchOn=force and download this extension - BUD FORCE DOWNLOAD. It does exactly what it says on the tin.
Answer 2:
Is a mailing list extension you are working with or what? If you can send them an email using request.form("email"

Set objCDO = Server.CreateObject("CDONTS.NewMail"

objCDO.To = rsMember.Fields.Item("MEM_EMAIL"

objCDO.From = "Music Company"
objCDO.Value("Reply-To"

objCDO.Subject = "Hello"
objCDO.Body = "This is the body"
objCDO.Send
Set objCDO = Nothing
Hope that helps...
Dave
_________________________
David Behan - www.site-manager.com/af.asp?a=11&l=1tds9p6x2
Replied 28 May 2002 11:28:41
28 May 2002 11:28:41 ed p replied:
thanx beano... looks like you've sorted my problems ... thanx.
should be OK with this... i'll let ya know. <img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>
should be OK with this... i'll let ya know. <img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>