Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About musicradiolive

  • Rank
  1. www.faceangels.comThe new community social networking site.Register for free. First 30 sign ups are currently getting FREE gold membership.Lots of new features being introduced to the site over the coming weeks.Register for free now!www.faceangels.com
  2. Hi.I'm trying to work out how to use www.blat.netIt's a command line program for sending mail.Can anyone tell me how to set it up.I want to use smtp.gmail.com as the sending server.But you have to give them a login for it.How do i specify my gmail login info?ThanksJon
  3. Hi All,I need some help with Parent & Child data.Basically, all my pages are stored in a database. The website contains sections and then in each section is the pages for that part of the site.The database is laid out like this:ID - The page ID NumberPName - The Page NamePCon - The Page ContentPType - Page Type (EITHER PARENT/CHILD)PParent - Parent of the page (If child).If the page is a parent then i just set the PParent to 0000.I want to display all the pages within the site as a table, in the layout of: <table width="100%" border="0"><tr><td>ID</td><td>Nam
  4. Hi.I'm using the script from http://javascript.internet.com/cookies/cookie-redirect.htmli cant work out how to remove the cookie.I've had no probs setting it,. I've used an image map. The user selects where they live, it redirects to that area page when they re-visit.But say it's a shared pc etc, they need to be able to remove the cookie.How do i do it?ThanksJon
  5. Any ideas on re-writing the processing page then?How would you have done it?
  6. Thanks for that, it worked a treat to create the table and form.I'm still having problems getting the processing page to work.FORM NOW LOOKS LIKE THIS: <form method="post" action="sendhere.asp?chart=<% =request.querystring("chart") %>&tracks=<% =Request.QueryString("tracks") %>"><font class="style1">Chart Date:</font> <input class="style1" type="text" name="ChartDate" value="DD.MM.YYYY" /><table class="style1" width="530" border="1" cellpadding="0" cellspacing="0"><tr><td width="60"> Position</td><td> Artist</td><t
  7. Hi.I need some help working out how to do something.As part of my radio stations website re-development, the new website management system will allow the Dj's to manage pages within the site, which i have aced .The only problem i've ran into is our chart editor. The system will allow Dj's to update their charts on the site.In the database is a table that has the following fields:ID - AUTO NUMBERNAME - NAME OF THE CHARTTRACKS - THE NUMBER OF TRACKS IN THE CHART-----------------------The next table contains the chart data.ID - AUTO NUMBERCHART - NUMBER (CORRESPONDING TO ID IN THE PREVIOUS TABLE)
  8. How do i write the code for the maths though!!I know the calculations, but i cant work out how to make the code take each item within the invoice to make them add together etc.
  9. Hey,Thanks for the reply.I'm stuck with the calculations.Basically, i am pulling the tblItems recordset to create the invoice, so it create the invoice list.For each item i have managed to use a calculation (shown in the above code) to create the total for that items. The calculation takes the QTY * the UnitPrice to create the answer, the total amount is then put into a text box which is read only.To make each text box unique i have made it so it names it using the rs("id") from tblItems. <input readonly="yes" style="background-color:#FFFFCC" size="4" name="<% =rs("id") %>" type="tex
  10. musicradiolive


    Hi.I'm creating an online payment system for my company, but i am encountering a few problems.DATABASEtblItems¦- id (Auto Number)¦- ItemNumber¦- IDescription¦- Qty¦- UnitPrice¦- Invoice¦- TDatetblInvoices¦- id (Auto Number)¦- IDate¦- Amount¦- Client¦- AmountDue¦- DueDate¦- InvoiceNumber¦- Rep¦- Shipping¦- Tax1¦- Tax2tblPayments¦- id (Auto Number)¦- IDate¦- InvoiceNumber¦- Amount¦- Method¦- RunningTotal <%strSQL = "Select * FROM tblItems WHERE Invoice = '" & Request.QueryString("id") & "'"rs.Open strSQL, strCondo while not rs.eoftheVarA = rs("Qty")theVarB = rs("UnitPrice")theOperato
  11. Hi All,I need a bit of help with some code.Brief:On the homepage of my site i have got 2 sections, 1 shows the latest news and the other will show the latest forum posts.I use Snitz for forums and KustomPage for Content Management System.The news one i have done without any problems, but the forums one i am having a few problems with.HERE IS THE CODE I USE FOR THE NEWS (SUPPLIED BY KUSTOM PAGE BUT TWEAKED BY ME) <% strSQL = "Select * FROM tblNews ORDER BY tblNews.pDate DESC" rs.Open strSQL, strCon for i = 1 to newsItems if not rs.eof then dim desc, tmp 'desc = removeHTML(desc) desc
  12. strsql= SELECT AdName, Forward FROM tblAds WHERE AdName = 'Connect' GIVES:Microsoft VBScript compilation (0x800A03EA)Syntax errorstrsql= "SELECT AdName, Forward FROM tblAds WHERE AdName = 'Connect' "GIVES:ADODB.Recordset (0x800A0BB9)Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
  13. str_sql = "SELECT tblAds.AdName, tblAds.Forward FROM tblAds WHERE AdName ='" & which & "'"Still gives the same error though....Or have i mis-understood?
  14. Changed bottom of through.asp str_sql = "SELECT tblAds.AdName, tblAds.Forward FROM tblAds WHERE AdName = " & which & "" 'rs.Open str_sql, conn, 1, 2 response.Write(str_sql)'Response.Redirect =rs("Forward") GENERATES::SELECT AdName, Forward FROM tblAds WHERE AdName = Connect
  • Create New...