I have a database of songs listed as Title, Artist,Description, DiscNo and TrackNo with a seperate record in that format for each song.What I would like to do is search through them for the Description, show only the disc numbers in the results.
This I can do easily. Where I am lost is that I only want each individual disc number to show once. If I moveNext through the recordset, it shows the disc number 15 times per disc. Is there a filter I can add to limit this display?
Below is code to display in a drop down menu some addresses. There is two things i need to do. One is to not show if there are no records but also there could be duplicate records, How do i stop duplicates occuring...
I dont have CDONTS support. i am using the following script. with this, even yahoo doesn't consider the email to be HTML and displays all the HTML tags and treats it as TEXT. here is the code i use! Please dont consider it abuse as i dont know how to encloase the code in TAGS!
if Request("__action")="TestEMail" then TestEMail() end if
Sub TestEMail()
Set objMail = Server.CreateObject("CDO.Message") Set objConf = Server.CreateObject("CDO.Configuration") Set objFields = objConf.Fields
With objFields .Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2 .Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = sMailServer .Item("http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout") = 10 .Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25 .Update End With
With objMail Set .Configuration = objConf .From = sFrom .To = sTo .Subject = sSubject .TextBody = sBody End With
Err.Clear on error resume next
objMail.Send if len(Err.Description) = 0 then mes = " Message sent to " + sTo mes = mes + " EMAIL SENT SUCCESSFULLY!" IsSuccess = true else mes = " " + Err.Description + " TESTS FAILED!" end if Set objFields = Nothing Set objConf = Nothing Set objMail = Nothing End sub
Sub Alert(html) if IsSuccess then Response.Write "<div class='testRelults' id='testSuccessful'><span class='testResult'>Success:</span>" & html & "</div>" else Response.Write "<div class='testRelults' id='testFailed'><span class='testResult'>Fail:</span>" & html & "</div>" end if End Sub %>
Im working on an automated email sending script which work real fine. I have to send 2 different list of email ( contact1 and contact2) of an acces database file (.mdb).
The fact is that my script work well but for some reason it only send the second list of email (contact2).
The script process the list contact1 without any error but obviously it isnt sending mail to those email.
It seems to be an easy fix mistake but i cant figure out why the first contact list isnt sending. Must be a "If then" mistake or something with the loop i think.
I have a formview which im using to ammed records in a DB via a gridview. When an item is selected on the gridview its details are shown in the formview. Ive wrote the update statement for the Insert button in the formviews edit mode.
If i edit a record in the formview this updates the DB, but not the gridview striaght away. I have to click on one of the select buttons on the gridview to update this. I have gridview.databind() on the click event of the insert button of the formview and on pageload, if its a callback. Code:
Is there any way to input .asp code so that a specific element isn't show on a page? example: I don't want a menu on a specific product page, but I want it on all the others. Is there any code to input into a site wide includes file to implement this?
I have a ASP application which let user to download their reports in pdf format. I would like to show a progress bar, or change the mouse cursor to a hourglass while the user is waiting for the file. How to acomplish this? In the asp code, I use response.BinaryWrite to create the pdf file directly to the browser. How to detect when the file is ready?
I create a page which will show me all the Regions from the table "RegionTable" where I have no information (empty fields) in on of the fields RegionDescription or RegionRank. It is to make my content managing easier. I do not want to see those records which contain all the necessary info (region description and rank). I tried the following code, but it does not work
qry = "SELECT * FROM RegionTable WHERE RegionDescription="" AND RegionRank="" "
error message is: ([Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1)
I have a query that displays values from a db. The problem is that the value displays like this: R 6.5 instead of like this: R 6.50 How would I get it to show the full value?
I am using a Cdonts e-mail script that e-mails the results of a form to my address. It currently displays the data like:
Amount: 12.00 Percent: 2.00
I need it to say:
Amount: $12.00 Percent: 2.00%
How can I get the $ and % symbols to be included in the e-mail template without getting a 500 error?
Here is what I have:
Body = Body & vbcrlf & "Amount: " & request.form("amount") Body = Body & vbcrlf & "Percent: " & request.form("percent")
I've tried a few diffrent ways but here is one example:
Body = Body & vbcrlf & "Amount: $" & request.form("amount") Body = Body & vbcrlf & "Percent: " & request.form("percent")%
I've tried using / before the symbols and "" but everything I've tried keeps coming up with a 500 error. How can I add these symbols to my template so they will show up in the e-mail?
I know we have this thread somewhere, but I can't seem to find it now
I want to show the first 100 chars of a string, but I don't want a word to be cut in half at the end, it must show the whole word then and go a bit beyond 100 chars.
How do you print out all of the contents of an array if all you know is the array name? FOr example, I am looking at pre existing code that looks like this:Code:
scartItem2 = session("cartItem") arrCart2 = session("MyCart") For Z = 0 to scartItem2 cartfields2="&Email=YES" & "&processed" & z & "=" & arrCart2(cProductid,z) & "&quantity=" & arrCart2(cQuantity,z) What I need to find out is if there are ANY other elements other than cProductid AND cQuantity in this array and what their names would be so I can add them to the code.
I know that I could print out the values of the above by simply doing this:
response.write(cartfields2)
But how do I find out if there's a cFeature or any other element?
i have very strange error.i can not see some of the asp pages on my browser. when i look from view source, all the source is there but browser does not show anything, just an empty page.
im looking to find out how can i make, when the pointer is over a link or picture without clickin on the link an small textbox(something like that) open and show the content of that link. for example in this forum when you go over a thread you can see the content.
I have a ASP page that when a user clicks a link it uses a DLL to stamp a .pdf with a watermark and then display the .pdf in there web browser using the Adobe Reader. This all works fine.
if a user views a pdf and then modifes it if they click the link again it still shows the old version of the file. They have to hit there refresh button to show the changes. How can I make it so my page always displays the lastest version of the PDF and not what is in the cache?
i have a website that users log on to. On one of the pages is a form. What I want to do is only show a certain part of the form for specific users. The way i want to do this is by using their username as a 'show if' command in dreamweaver. What I currently have is this
<% If Session("MM_Username") = "union" %>
all data to be hidden shown is here
<% End If %>
But this doesnt work for me! Any suggestions on how to show this properly?
I want to show the currency like that xxx.00. In my database, i already set the type of column which i want to show to currency. However, the currency can no be shown as my expect. It only show like that XXX..
i m displaying only 4 lines of my main news..and after that there is one link more...if user click on this link then the detail of this news will display....but problem is i want to show the rest of content of this news at same place..i maen to say after clicking more it will display my main news content in place of 4 line and more link Code:
I have some problems with how to show error message. Now I have two asp pages such as page "A" and page "B" and When I click a button on page "A" then the process will check conditions from page "B" ,so if there're some errors it will redirect to page "A" and show error message box.
I would like to know that how to show the message box?
I have clustered IIS 5.0. It is working on a fail-over clustered model (Active-Passive), with one node as a preferred owner and the other only as a failover. I make the changes to IIS from one node, and then synchronize it with the other node.
All of the data is stored on a shared external disk array. I have around 50 websites. All of them work fine and are accessible. Recently I have found out a confusing problem though. Code:
I have a problem. I tried my best but could not solve is. I have a page where user selects the folder name from a drop down list. It takes user to show.asp page, where it how all the files in the folder and also user can click on them and download them. If I select name of the folder from the list, on show.asp it shows all the files and their link.
When I click on the link then most of the file which has long name and have space in their names wont be hyper linked. For example if files name is Virus Control.vsd or file name is INCIDENT-ACCIDENT INVESTIGATION REPORT.htm. If I click on them it will say "The page cannot be found". Code:
I have table that list some companies, when the user selects the company a form comes up that list all the company info, where they can view it and also update some info. One of the fields they update is a drop down list. I'm having trouble populating the menu with the value from the company it comes up blank. Here is the code:
I have a list of requests that I'm displaying. The client wants to be able to display the details of the FIRST request as the page loads.
Right now, as I loop through the recordset, I'm checking the querystring for "rid", and if rid = "" then I do a response.redirect to the page adding the rid value to the querystring from the recordset.
I'm thinking this is not very effecient, but I can't figure out anything better.. anyone have a good solution to show the details of the first item on the list?
1. Can I, say by session, determine if a user logged in can amend/delete data they have entered? But no one else. Say they book a conference room, but only they can delete it
2. I want to prevent cross bookings (in terms) of time.
