Showing Records For Each ID
I'm really trying to make this work. I have a dbtabel with following fields.
ID
PlayerID
Date
Point
I want to show each players point like this "1,2,5,6,4,8,9", but i want the script to first add up which player who has the most points, and then list them in order of wich player who has the most points...
1,3,5,6,4,5,9
2,1,1,3,2,3,6
2,5,6,4,1,1,0
Each row is each PlayerID's row. Is this possible.
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Records Not Showing
I inherited a database driven site, which displays events pulled directly from an access 2000 database. when these events are edited in the admin system, or when a new record is added (again via the admin system), the record will no longer show up as being editable on the choose_event.asp page. I checked the database, and the changes are being made.
View Replies !
View Related
Showing Records For Each User...
I have a Golf leaderboard based on points given to each player after each match. That works fin, but is it possible to show everys players record after his or hers name. At the time it looks like this. Mike 7,50 Peter 5,45 etc. My code is like this Code:
View Replies !
View Related
Showing XML
Can anybody help me with displaying two xml content in a asp page. i want it to be shown with collape and expand feature (with those + and - feature when an xml file is opened in explorer). i tried having html frames but i am not able to add menu in the same html page. right now i have menu and two text boxes to display this xml content. i want to use something else instead of text boxes to display xml in indented form. i thought i could use browser component in asp page but it doesnt work.
View Replies !
View Related
Systematic Updating Of Records Depending On Amount Of Records In Another Table
The problem concerns 2 tables, cart_products and cart_shoppingcart. Cart_products contains all the product data (eg, prices, product's key name, etc), but most importantly, it contains the quantity of stock (prod_quantity) for each item. cart_shoppingcart contains all of the user's items in their shoppingcart, including those that are part of an (customer) order; these have the order_number to differentiate from those that aren't in any order (their Order_number is 'no_order', the others have the order number). Now, what I want to do is this: For every item in the order (ie, every entry in cart_shoppingcart that matches the username and order number), take the quantity (x) the customer is ordering, then take the quantity of stock remaining (y), then subtract x from y to create the new stock level (z) and update the appropriate record in cart_products with z (all this with SQl preferably). I was thinking of using a Do while loop, but realised that it wouldn't work as I'd have to use several SQL statements and then I'd run into a problem the minute ASP reads "objrec.movenext".
View Replies !
View Related
Video Showing
I have an active-x control on my asp that loads a wmv video file.But i have a problem viewing the video until i have download the whole video on the active-x control. Is there a way to see a portion of the video without complete download?
View Replies !
View Related
Showing Tif Files
I have a strange problem on WindowsXP proffessional with IE6 ,when i try to display a tiff file ,it is not showing ,small red x is comming up. I tried by dowloading latest IE from microsoft but no use. This is working fine on win2k IE6.Here is the html file I am using to display the tif file. <html> <head> <img SRC="http://192.168.0.30/test/test.tif" BORDER="1"> </head> </html>
View Replies !
View Related
Showing Reminders
I make a intranet Project For a Company.In that Project i make some reminders that can send each other users.When the Reminder come it should be alert like yahoo or Msn means Reminder should be show right side of the Taskbar and it's come like fade.
View Replies !
View Related
New Pages Not Showing Up
i have just uploaded the new files to a website i have rebuilt. I have refreshed IIS and restarted the website but the new files are not showing through on directories that existed before eg subscribe etc. The new directories that didnt exist before work fine but would the internet connection in our office be caching previous pages that are no longer there and trying to access them?
View Replies !
View Related
Updates Not Showing
my problem is The updates on my asp files are not reflected in the browser. Till recently everything was working fine. Today I installed new updates on my windows 2000. After all the cached asp contents are appearing and the updates are not getting refreshed. I dont know if this is becoz of the updates on my OS. I had a file addfield.asp. It was working fine, I made some changes and they worked. But after that my updates are not reflected. If I rename the file to addfield1.asp. I am getting the desired results. Again if I change the contents of this file, they are not appearing.
View Replies !
View Related
Images Not Showing Up
why some of my graphics wouldn't be showing up? I'm using css and everything looks fine in dreamweaver until I upload it then half my graphics are not visible on the page but they are there because I can still click on them, I just cant see them. Any reasons?
View Replies !
View Related
Showing Companyname In URL
ok so I wrote a template based CMS.... A small company requires a website, they come to my site www.mutedesigns.co.uk/sbs and choose a template, pay, register, edit ther details and pages and then view their site simple and it all works yay! Code:
View Replies !
View Related
Showing Shared Dir
I'm working on a Intranet, and found this code to list the contents of a directory. However, the only directory I've been able to show is the dir where the script itself is (Inetpub/Scripts). How can I redirect to a directory somewhere else on the network ? Code:
View Replies !
View Related
Showing Birthdays In ASP
I have a table called 'players2005' with fields of 'player' and 'pdob' The 'pbod' is a DATE realted to the players date of birth. Using ASP how can I call the access database to show members that date of birth is today. I have the rest of the script but just nedd a SQL statement Code:
View Replies !
View Related
Code Showing
I've been working on a page at work, which has been fine, yet when ive come to try it at home, i load the page (the page loads fine) but i see all the code etc that was hidden before. example what i see at the top of the page: <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%<% OPTION EXPLICIT %<% 'dim oCdoMsg, oCdoConfg, st but i see tons more than that, basically all the code to the next %>
View Replies !
View Related
Pulling Records From End Of A Database Or Inserting New Records To The Beginning
I'm trying to pull the last 5 records from my database. <% j=5 rs.MoveLast While ((j>0) AND (NOT rs_article.BOF))%> ''Execute HTML and data insertion here <%rs_article.MovePrevious j=j-1 Wend%> Everytime I attempt to run this code, I recieve an HTTP 500- Internal Server Error. It tells me no more than that. I know that my connection settings are OK because when I move forward through the database (first five records), the code executes without error. And yes, my Cursor type is Dynamic. Alternatively, I would also like to know how to add new recordset to the beginning of a database rather than the end.
View Replies !
View Related
Showing Only Null Fields
What to only show the Null fields on an ASP Update form. eg. <% If "Recordset1.Fields.Item("B15-1").Value" = IsNull then %><input type="text" name="B151" value="<%=(Recordset1.Fields.Item("B15-1").Value)%>" size="32"> ...etc get what i mean? Needs to be per field - as the exact fields will differ from record to record Any ideas?
View Replies !
View Related
Showing Different Pages (AbsolutePage)
I'm using AbsolutePage to show the results of my recordset in different pages; of course if there is a lot of data, it's gonna show all the links (for example 100 pages, 100 links) So I want to do something like this: pag. 1 2 3 4 ... 97 98 99 100 and of course without showing "..." if there are less than 4 pages. What's the easiest way?
View Replies !
View Related
Some Data Not Showing In A Form
I am using SQL 2000 database and MS Server 2003. I am pulling in data from a sql table. For some reason, when I include the following line: <tr><td><b><%if rs("Street_dir")<> "" then response.write rs("Street_dir") & " " end if%> <%=rs("Street_num")%> <%=rs("Street_name")%> <%=rs("Street_suf fix")%></b></td></tr> then the following line does not display: <tr><td><%=rs("remarks")%></td></tr> The REMARKS data is blank. But, if I remove the upper address line, then the REMARKS appears. The address is 1111 Main so that does not seem to be the issue. The address information is VARCHAR fields, 255 characters. This works fine on another server where my files used to be, but I just moved to a new server.
View Replies !
View Related
Pictures Not Showing After Upload
I have an upload facility which is working fine. uploads to a folder (photos) through aspsmartupload and database. Ive checked the folder, n database to see if the file is being uploaded and it is. ITs just not being displayed properly on the site. ALl the pictures come up with a little white box with a red cross in it, in the top left had corner.. so its identidied as an image , but its not showing the actual image. .
View Replies !
View Related
Showing All Spaces Without Using The
I am using ASP to read code from a text file that I am displaying on my page. Because I do not want the code from the text file to be executed, I used the Server.HTMLEncode() method to display it as it is in the file. However, the spaces used to indent lines is still removed by the browser. I cannot use VBScript's replace function to replace all spaces with because that would replace all spaces, including ones that I do not want replaced as well as majorly increasing the size of my file. Is there any way to display the spaces used to indent the lines without manually writing a function to do it?
View Replies !
View Related
Showing An Include File
I would like to have the option to show and include file which has a one line table with a red background and printing to pull info out of a SQL database but only if there is data in the table. Basically it is to show breaking news when it happens before there is an article. The SQL table is called breakingnews and the column is called brknews. If the column brknews has nothing in it, I don't want the table to show up on the page but if there is data in it, I want the colored table and text to show up on the page.
View Replies !
View Related
Showing File Extension
If you'll notice, there's a comment in this snippet that drops the extension. How can this be modified so that the extension IS shown? Set myFileSys = Server.CreateObject("Scripting.FileSystemObject") Set Folder = myFileSys.GetFolder(Server.MapPath("/meetings")) for each file in Folder.Files If Not file.name = "index.asp" Then FileName = Left(file.name, (Len(file.name) - 4)) 'drop the extension FileSize = cint(file.size / 1024) 'convert into kilobytes and drop the decimal Response.Write("<li><a href='/meetings/" & file.name & "'>" & FileName & "</a> - " & FileSize & " K<br>" & chr(13)) End If next Set myFileSys = nothing
View Replies !
View Related
Showing An HTML File
Showing an HTML file in part of a Webform.I have a Webform with some buttons on the left side of the form. What I want when clicking one of the buttons is to show an HTML document in a part of the Webform (as if it was a Frame page).
View Replies !
View Related
Showing Default Option
How do I display 'Please Select' as the default value my code is below.Code: <option selected>Please select</option> <%SQLStmt = "SELECT magcode FROM Magazine ORDER BY Magcode" Set rsDistMags = Connection.Execute(SQLStmt) Do WHILE NOT rsDistMags.EOF%> <option value="<%=Trim(rsDistMags("magcode"))%>"<%If Request("magcode") = Trim(rsDistMags("magcode")) Then Response.Write " Selected" End If%>><%=Trim(rsDistMags("magcode"))%></option> <%rsDistMags.MoveNext Loop%> </select>
View Replies !
View Related
Pivot Table Not Showing
I see a similar unanswered post here, I face the same issue.Does Win XP have some bug with Microsoft Office Web Components 11.0 ?I am unable to see a pivot table which I added, in my web page.Strangely enough, this control is showing perfectly in Win 2K with the sameweb page.
View Replies !
View Related
Pages Showing Codes In IE
when i try to view an ASP page in my IE web browser, all i see are the codes used to design the page but when i preview 'em in Dreamweaver its okay.Why is it so ?does it mean if i publish my asp pages to the web; thats how they'll be on other people's browsers ?what do i do to be able to see the actual web page and not the codes in an ASP page.
View Replies !
View Related
Dynamically Showing Datediff
I have a datediff comparision value on my form. Since one of the dates inside the datediff is: now(), I'd like to know if there's a way to show the result dinamically (without reloading the page..). I can't see how to do it from server side...It's possible to use js to fill the field or reload only the field value? detail: I'll need to submit the current diftime value along the other input values on my form at the end of process.
View Replies !
View Related
Without Record - Page Not Showing Up
I have an ASP page in a table style (heading and data). At the beginn of each month (actually only the first day) there is no data in my database and so-with nothing to show up on the ASP page. If I would like to open the ASP page over the net IE is telling me that it cannot find my page. Is it possible that, even if there are no records to show, at least the heading is shown on the Internet?
View Replies !
View Related
Showing HTML As Text
I am sending out an HTML email using CDOSYS and want to include some HTML code within the text of the email. So, it's something like: Hi Your link is <a href="www.domain.com/subfold">Link</a> But it includes the code within the HTML. How do I just show it as it's written?
View Replies !
View Related
Showing Files In A Folder
Am developing a website, thats only allows user with permission to acces certain file. What I have is a webpage that list all different projects available. When a user clicks on a project, he is asked to enter username and password. If succesful the user is then taken to a webpage displaying all files available to download for that particular project. Note: All the files asssociated with particular project are in necessary folder. So project London, has a folder called london with all its files in that folder. How do I get all the files displayed on the webpage for that particular project?
View Replies !
View Related
Showing Only X Number Of Characters
I am using a WYSIWYG editor for articles and the article text is being inserted into a SQL db field called ARTICLEBODY. Question: On my homepage, I only want to display the first 400 characters of ARTICLEBODY field. I am using the LEN function and it does what I want. BUT, is there a way to not have it cutoff in the middle of a word?
View Replies !
View Related
Images Not Showing When Include Navbar
I have an application that has many different look and feels(?) based on the client. Currently my site uses frames with top_navbar appearing in the top (which appears based on the stylesheet of the client) The main frame houses the welcome page which is stored in a directory relating to that client) or other pages stored in a generic directory (VC) which holds all pages that are common to all clients. In this directory is an IMAGES directory which strangely holds all client's images together....there are some common ones...thats prob why its done like that. In order to improve the accessibility of the site, I decided to do an include of the top_navbar, to get rid of frames. This works fine when included in the welcome page as the file paths to the images is correct, but when i do it to from a page that is held in the generic directory (VC) the image path is obviously not now correct. My question is this...How can i get top_navbar to check where it is before setting the filepath to the images? Is this possible?
View Replies !
View Related
Showing Calculated Fields In The Form
I have a asp input form of a financial report. Here most of the fields are text boxes where the user need to input the values corresponding to an item. However, there are few items which are calcuated field. Prior to submission of the information, I would like the user to know what the calculated field be (based on the information input in text boxes) before submission of the form. Is there any way to display the calculated value before submission in ASP?
View Replies !
View Related
Sending Emails And Showing Progress
I need a way to show the client that the emails are being sent and how many are left. The way I want to do this, is by opening a window which will send the emails and display the status. The problem is how do I pass it the subject, body and so on. I don't want to use a querystring. I thought of doing it like so: onSubmit = progress() - this will call a js script which will open the progress window action = (the page that gets all the values from the form and sends the email) Is there a way to update the popup window from the "action" page? for example: everytime an email is sent... increase a variable and send it to the popup window, and then close it when its done.
View Replies !
View Related
Why Are My HTML Tage Showing In EMAIL?
When I send this code (using CDONTS) I had expected just the title to appear on the email but ALL of the text - including the HTML tags are coming though. Do I need a line setting something to HTML so it knows it's HTML? Any ideas??? CODE IN QUESTION: Body= Body & "<HTML>" Body = Body & "<HEAD>" Body = Body & "<TITLE>Send Mail with HTML</TITLE>" Body = Body & "</HEAD>" Body = Body & "<BODY bgcolor=""lightyellow"">" RESULTING EMAIL: <HTML><HEAD><TITLE>Send Mail with HTML</TITLE></HEAD><BODY bgcolor="lightyellow">
View Replies !
View Related
IIS5 Not Showing ASP Files, Shows Others
Annoying problem on a server with IIS 5. [We have other IIS 5 that show asp files just fine. I'm at a loss. ] I can open htm, html, gif, jpg, all files except asp files. The message when opening an asp file is: "The page cannot be found... blah blah blah HTTP 404 - File not found" I've looked everywhere. Permissions are okay with IUSR and security since we can browse other files. The asp files in question are NOT marked Hidden... What can I do to make it render the asp files? Ideas?
View Replies !
View Related
Showing Password In Encrypted Form In SQL
I have seen one table in which while selecting records from that table and viewing the resultset in Grid format the passwords was coming in encrypted form means suppose the password was 'super' but in the resultset set it seen as n or some other letter. But if the same resultset was viewed in Text format then the actual password was seen...
View Replies !
View Related
Access Tables Not Showing Up In Dreamweaver
I have the following connection string: "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("../_database/MOO_ACCESS.mdb") & ";" Which tests successfully. When I try to view the tables within Dreamweaver of the access database though, it shows none. There are definitely 2 tables built in the database. anyone have any ideas?
View Replies !
View Related
Showing An Image From A Database Problem
I have a test table Named Pictures with only one column which is named Picture and the data type obviously is set to 'Image', now i have no problem inserting an image into the database... Now i wish to simply show the picture. The way in which i am doing this is by dragging a grid view on to the web form. Now when i load up the page i get the below error:- "The data source for GridView with id 'GridView1' did not have any properties or attributes from which to generate columns. Ensure that your data source has content. " It doesn't matter if i has anything in the table or not, i get the same error. Is this because i can't just directly show the image through a gridview or wot?
View Replies !
View Related
Showing An ASP Page As A Continuing Data Table
I would like to show my data in a ASP table. I do not want a sort of record selector on that page. So I did the following: Please be as kind and look the attachment I would like to see a table header like "tradeid,clearingnumber" etc - and underneath the list of records. can someone tell me how to get this because in the moment I only see one record always it's not continuing writing the list.
View Replies !
View Related
Include Files Not Showing In Design View - WHY?
I have 2 include files on my page which are both navigation bars. When i view my pages in IE they look fine and everything is in the correct place, however the problem is that when i look at the pages in design view in Dreamweaver i can only see my first include file. the rest of the page is not displayed so makes designing hard as i cant really see what i am doing until i view my page in IE. WHY IS IT DOING THIS???????????????? Or is this meant to happen, i have never used include files before, but im assuming this shouldnt happen?
View Replies !
View Related
Showing UNICODE (Chinese) From SQL Server On An ASP Page Using Dreamweaver
I have a simple ASP form in which I am reading and showing the data from SQL Server database. This database has a nVarchar field, which stores some data in Chinese language. When reading and printing the data using a SELECT query it shows ??? (Question Marks) instead of the Chinese data. I have checked using Query Analyzer that the data is correctly stored in Chinese only. I have looked up for this problem and it looks like many have faced the same before. But the only solution which seems to be provided for this is using the FORMS 2.0 controls, because VB converts the Unicode to ASCII and that corrupts the data. But is there any other solution to this? I am using Dreamweaver to write the ASP pages. Dreamweaver is capable of showing the Unicode data, but can’t do much if it gets corrupted data from the VB itself. So Please any help will be highly appreciated. That’s the sample code which I am using if it helps: .....
View Replies !
View Related
|
TRACKER
