I have this sql statement which picks up the corresponding rating from the Rating table and matches it up to the artist from the Song table:
SELECT rating, song.artist, song.delid, song.date, song.id, rating.id, song FROM rating INNER JOIN song ON rating.artist = song.artist
I want to make another page though that'll only show the songs which have no rating.
I run a travel web site and would like to have an asp application/script which lists a selection of restaurants and hotels with a rating functionality. Can anyone suggest anything that could work? Been looking around but nothing quite seems to meet my requirements.
View Replies View RelatedIn a table I have an unlimited number of items - each unique item has it's own unique ID. One of the fields in the table is a Rating field. The table stores records submitted by users for items that they Rate (on a scale of 1 - 5, with values of 10,20,30,40 or 50 inserted in the db). I would like to sort this info and display the five most favorite items among users via the rating scale. In other words the five unique items that have been rated 50 (best) most often.
I'm able to create a record set of all unique items that carry a 50 rating using the statement:
strRated="Select DISTINCT RList.BID FROM RLIST where RList.Rating=50". How do I then use this record set to find the ID's of the five items that are rated most often with the 50 rating and then display those?
Originally, I thought I could use the values 10,20,30,40 or 50 to calculate an average or a total among these records and then display the items with the hightest calculation. At least that was the intention - though I do not know exacly how to accomplish this either.
i need a ASP Rating Script!,
in which my visitors will Rate Song/Article etc,, i search in alot sites such as google, yahoo, and also i visit aspin.com, and hotscripts..
but did not get,,,
how to create a simple rating system just like the ones on Amazon.com? I found a link which i tried and i think it is flawed. No attemp was made to provide the source files
View Replies View Relatedi need a rating system on my website were people would be able to vote out of to topics and once say 10 votes have been made it adds up the totals and inputs the result of the topic which won
View Replies View RelatedI am using Access database for my site's songs,
I have used 4 fields in tbl_song:: song, artist, url, and pic
See this image:
And I am displaying them for a link to a page like:
<a href="newplayer.asp?so=<%=rs("song")%>&s=<%=rs("artist")%>&pl=<%=rs("url")%>&p ic=<%=rs("pic")%>">
Check this page, click on any song in this page and you will see how I used newplayer.asp
Well, I need a rating system for each songs, Where users can rate each songs, ( five stars rating ) I need help, How can I make a rating system?
any tutorials about how to create a rating system using ASP and access. I found this one.but it requires you to set-up ODBC and draw up the databse using DSN. I'm using Frontpage and just want to draw from the database directly.
View Replies View RelatedI am creating a store and I'm looking for a ASP rating software. Something like Amazon where you write your comments, rate the product and see how many stars. I need it to have features where I can accept the comments or at least it gets reviewed. Is there such a forum like this? Anyone know of any?
View Replies View RelatedHow to make asp site rating system? i want to make it as:
1. A List menu with 5 sterics
2. When u select any one, it submits
3. Next page should display results in images, Like 1 to 5 stars, the rated stars should be in one color and the unrated in other color.
I am using CDONTS to send mail to the user from my ASP application.
However, the code doenst works all the time. I am able to get mails but
nothing happnes most of the time. The code works maybe once in 20 tries.
What could be the reason?
I have a query in ASP that does a select * from table
It doesnt retun all columns!
When i use objRS("columnname") I get blank. This only effects some colums and I fix it by using
select *,missingcolumn1,missingcolumn2 from table
i posted earlier, and the response seemed to be there is
another dll i need to use the cdonts object, i used it
fine for awhile on my old setup, i upgraded to 2k3 and it
errors up as if cdonts isnt an object. So is there a dll
i need to have to use the cdonts object in iis 6 or do i
need to rewrite my code to use cdo? (if so, please provide
asp 3 example on how to send an email with recepient,
sender, body and subject)
I wrote the code for Members of Register. and i use cookie in this code, My database is SQL server. SQL server dosent support the cookies in my codes i dont know why this cause but my codes are working without any cause .
View Replies View RelatedI have got a problem wit da FILESYSTEM in ASP coding. Before I use window 98 installing PWS. Everything works fine....
And now, I use Window XP professional ( Laplop ), everything is updated ( Service Pack, .NET component, ASP.net stuff...
All my ASP code with FileSystem which used to be properly ran cant be executed on my XP server.
There is no message error on da page, but the browser icon keeps spinning and da content is blank, it means u dont see anything happens. I wanna ensure dat all da code is right, cos it work properly with PSW and other servers. I even tested with a simple code, but It still doesnt work..... Code:
My ASP page contains the following VBScript code:
<%
zipCode = Request.Form("zip")
%> <br>zip: <%= zipCode %>, rf: <%= Request.Form("zip") %>
When I enter "abc" into the "zip" field on the form, I get the
following output:
zip: , rf: abc
Why doesn't the first statement assign the "abc" string to the
variable "zipCode"? What am I not seeing?
My friedn is using PWS on NT4 machine, its a local machine, whenever he directs to an .asp page, visual interdev starts.
How can we over ocme this.I had solved this problem long time ago. Now i dont remember. Also to install IIS4.0 do we need to install MTS? if yes, where can we get
it?
I'm using SQL Server and I decided to convert one of the fields from nvarchar to ntext. The transition in the manager was all right, but my ASP pages wouldn't display the ntext and there is no error message. I use Code:
<%=rs("Text")%>
to display the ntext...and there is nothing.
I have a database table with several records. Now I am filtering some data based on the "where" statement. If I run the query in analyzer then I get 20 rows. If I run the same query in asp and assign GetRows() to an array, then the array returns only 4. I am not sure if I am using the GetRows wrong. Here is a snipp of my code:
View Replies View RelatedWhen we send a mail using the code below,we do not get simplified chinese characters if they are present in the body but we get junk in the mail and we need to change the mails encoding to simplified chinese to see the Chinese characters.
'CDONTS object
set objMail = Server.CreateObject("CDONTS.NewMail")
objMail.MailFormat = 0
objMail.SetLocaleIDs(65001)
objMail.From = sFromEmail
objMail.To = sToEmail
objMail.Subject = sSubject
objMail.Body = sMessage
objMail.Send
set objMail = Nothing
I have one field char type data length 1.. It has data either 1 or 2 in all the field tht I have checked through enterprise manager.
I'm running query:
"select * from table" and fetching all the records and displaying...
It display all the data except data from this field..Doesnt display anything..
I had put Response.write rs("fieldname")
What could be the problem?
If I need to check if a certain value does exist in a field, and return either "yes" or "not" which query would be the most effestive?
View Replies View RelatedHow do I find out if an url exists? Whar I want is a function like this:
If UrlExists("http://www.test.com/test.html") Then
Response.Write("Yeah!!")
Else
Response.Write("No file :-(")
End If
Can anyone help?
IS there a way I can do an If exist to determin if a graphic is displayed?
something like this;
<p align="center">
if file exist "fileone.jpg"
<img border="0" src="fileone.jpg">
if File exist "filetwo.jpg"
<img border="0" src="fileone.jpg">
</p>
What I am trying to do is post JPGs from a folder structure, the files may
or maynot be there, but I don't want to have the blank picture reference to
be displayed as if I where to just hard code the graphics in the Html!
Everything was working fine on my website until last night we started getting the following error message while viewing to see the pages. Website is running on asp and sql server.
Microsoft OLE DB Provider for ODBC Driverserror '80004005'[Microsoft][ODBC SQL Server Driver][Named Pipes]SQL Server does not exist or access denied.
reports/penaltyrankingreport_web.asp, line 19
I checked the line in my code and its the line when the code is opening the recordset...
"objconn.open"
i already referred the following article on microsoft but not exactly sure in which direction to troubleshoot because i didn't make any changes to code, servername, database properties.
http://support.microsoft.com/default.aspx/kb/328306
internet information server does not work. when i try to open any website
from iis it gives error :"Class does not exist"
Moved from Windows 2000 to Window 2003, and now receive this error sporradically. It only happens a couple times per day, so the connection string is fine.
This issue seems to be server related, becuase all the same code and database ran fine on Windows 2000.
On my local pc all goes well,when i upload it to the server i get a file does not exist error , both the server and my pc have exactly the same folder tree and the same files ( ive checked it over 100 times now ) but the error still persists.
I have a folder called DirEscrita in wich i have put the dbf file to scan
for data , and i get this error when trying to do a simple select on it:
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC Visual FoxPro Driver]File 'trf.dbf' does not exist.
/exporta.asp, line 12
I know that it cant be a prob with the code , cause it works fine locally
( im on a XP PRO IIS 5.1) , could it be the server? ( IIS 5.0 )
I need a way to check if a certain folder exists. If it doesn't exist i want to create it. How can i do this?
View Replies View RelatedI am running WinXP Pro and have IIS 5.1. I am developing a web site locally - everything was fine until today when I tried to preview the site I got a 'class does not exist' error (in case you ask I have turned off friendly http errors and this is the message I get). This message is also displayed when I try to access my local host.
View Replies View RelatedI have an ASP script that checks results from a SQL query. The SQL query contains a CASE statement, so I have to perform a check to see if the object exists. Right now I have something like this: Code:
If objRs("TotPaid") = "" Then
But that just spits out a:
Item cannot be found in the collection corresponding to the requested name or ordinal Any takers?
if there is a function i can use within asp to check whether or not a file exist. Basically i have a list of products and i want to check if the file exists for the image and if it doesn't display an image i want to be able to dispaly a No Image Available image.
View Replies View RelatedI'm getting the following error on my locahost at work when I browse in IIS. "Class does not exist. " I created a web site in classic asp but I get this error. When I check IIS for the web logs it gives me 18:52:07 127.0.0.1 GET /PatientPortal/blank.asp 500