I have created a quiz with 14 questions that the user can click a yes radiobutton or no radiobutton. In the code-behind I have set a varable to store the selected items.
What I have taking place is if yesRadiobutton is selected the variable is incremented by 1. then after all the radiobuttons have been added up. i check the variable using an if statement. Code:
I am trying to build a page in ASP/MSsql with the aid of dreamweaver, the page contains total of 6 Questions, each question has 3 choices, of which one of the choice contains the right answer with a hidden value = to 1 and the wrong choice hidden value = to 0.
What i am trying to achieve is to collect the values and insert it to a database and at the same time display the results on the confirmation page.
Collecting data’s and inserting to the database is not a problem which i am able to do it. The area that i am stuck is the possibility to collect the values, adds the number of right answers (e.g. 1+1+0+0+1+0 = 3) and displays it on the confirmation page.
I was thinking if it was possible to use cookies for this, like storing the values Q1 = 1 when it is correct and Q1 = 0 when it is wrong while submitting the form and the confirmation page retrieves the values from the cookies, addition the number of right answers ( Q1+Q2+….Q6) and display it on the page.
E.g. the confirmation page displays: Your score is 2 out of 6.
I am reading information from a sql db and would like for the information to display, which i had working, until i tried making it so that if there was no information in the db field, that it would not display any results. Here is a snippet of the code. Any thoughts.
if name <> "" then
Response.Write("Name: " & recordset("name")& "<br>")
end if
if company <> "" then
Response.Write("Company: " & recordset("company")& "<br>")
end if
if title <> "" then
Response.Write("Title: " & recordset("title")& "<br>")
end if
I'm stuck on trying to display a single row from a query I'm executing.. it was fairly easy in PHP and I'm sure it is in ASP too, I'm just not sure what to code.. I couldn't find anything on the web that was simple.
If anybody has some suggestions on how to display just the one row that is returned from the query that would be great for now. I'm looking to eventually add 'LIKE' to the query to allow for similar names/passwords to be displayed.. but for now this should do. Here's the code:
Well I was able to build a simple search page, that would search a database and give the results on the restuls page from the criteria on the search page....
However I am having a issue with the data that's shows in the results. I'm getting the ID Column of the table in stead of the Column with the names. Eg:
<%=(births.Fields.Item("DName").Value)%>
Is there a way to change the data to be displayed to another column?
I am still trying to get my feet wet with ASP, VBScript, and MS SQL here and I am trying to create a very useful page where I can eaisly view my SQL tables and the columns within those tables.
I have two SQL scripts that work well, one to display the tables within my database and one that shows me the column names in that table.
I created a form, added a drop down selection and coded it so the table names appear in the drop down, then added a "Submit" button.
What I am trying to do is get the page to display the column names below based on the table name I select from the drop down list.
ISSUE #1: I cannot seem to get the table name when chosen from the drop down to pass it's value to the second query so it can display the results.
ISSUE #2: How do I display these results from the chosen table name based on the column script below? Code:
I am trying to design a page that displays data from a query in groups of a field in the where clause and then displays a 'total' per each group. Code:
View Replies View Relatedi run a classified ads site that allows people to post ads, and stores the results in a ms access database.
2 of the imput fields are: price and quantity
What i am trying to do is the following:
To add all the prices and and quantities together and be able to display the results on my site for example my database has the following:
Price | Quantity
2.00 | 300
1,50 | 1
10.00 | 10
140,00 | 7
and on the website i can display the results like so:
Current ads worth: 1681.50
I need the script to ignore letters as in the quantity field people have also added word such as packs and VE ETC so i need it to ignore letters, however in the price field some people have placed the ( , ) sign in there price so the code must recognize ( , and . )
Has anyone experience with rendering CrossTab Query results with ASP?
For example, using this SQL:
TRANSFORM Count(threads.threadid) AS CountOfthreadid
SELECT threads.threadSeverity, Count(threads.threadid) AS [Total Of threadid]
FROM threads
GROUP BY threads.threadSeverity
PIVOT threads.threadStatus;
This returns the following in Access:
[threads_Crosstab] [threadSeverity] [Total Of threadid] [Analyzing] [Closed] [Coding] [Open] [Re-Testing]
[Medium ] [1] [1]
[Not Set] [160] [1] [122] [1] [35] [1]
I want to create a HTML table to display the results in my webpage. However, I don't belive the output from a "Transform" is a true recordset. When I request the names of the fields in the recordset, I am getting data from the "rows".
Is there standard way to display these types of queries? How does one access the data in a crosstab query? Are there ojbect classes to handle this?
I am building a shopping cart where orders are send by email. Even though it says it's sent, I receive nothing. So I did a test script to send an email using CDO since we are using an exchange server for email and it's on the same network as the site. Code:
View Replies View RelatedI'm pretty sure this is possible in ASP, something about making CPU time markers and then taking the difference and switching it into seconds/minutes I just don't recall how to go about doing it.
View Replies View RelatedI use the ASP page to test whether the connection of SQL Server is fine. I use windows authentication. I get fail when I attempt to use hostname of the destination server. Contrary, I get success when I attempt to use IP address of the destination server. Does anyone know how to fix this issue?
View Replies View RelatedI've been trying to create a test site - The site uses ASP with VBscript and talks to SQL Server 2000. I was able to complete and test it on my locally on my computer using Microsoft’s IIS 5.1. The website communicated fine with the database on the webserver/network server
However, when I tried to save the site from my local computer to the wwwroot folder in the server’s IIS hoping to make the internal site available to everyone here the resulting error comes up when we try to open a page with a recordset connected to the database: -
Our Error: -
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'AUMBSDDSSIUSR_AUMBCOMP'.
/mysite/htm/test2.asp, line 8
The page calls on an include file
Code: ....
I want to find a Quiz example in ASP with random questions from a database and a score.I find many quiz examples in internet but not with random questions.
View Replies View RelatedHow do I test a "timeout" error when pulling an .asp page? How do I
raise a "timeout"? How do I "catch" a time out using VBScript with
ASP?
I've got a product database with some pretty heafty table joins. At the moment if I return all products, the script often times out since there can be 10,000 + products per search result.
What is the best way to retrieve only, say, 100 results per page?
I currently have a script which loops through the entire recordset and only writes the appropriate records (say, records 300-400) but it would be nice only to pull the correct records from the database as people page through. Basically I need to have the least amount of memory usage during pulling these results from the database.
Does that make sense? What do you guys suggest?
I'm doing pretty well with my SE and getting all my results but I'm trying to come up with a way to have a maximum of 10 results per page. Code:
View Replies View RelatedI have a ASP page that triggers a db-side stored procedure.At the end of the procedure, it spits out a log file, that this ASP page reads and displays for the users.
But the problem is that the database-stored Proc could take anything between 10 secs - to - 10 mins. I dont want the page to time out [But I dont want to increase the time out in the IIS webserver]. Is there a way, like the airlines websites do, where I can just show an animated gif while the procedure runs and redirect the page to results at the end of the procedure run.
ex: like orbitz or hotwire.... or anything like that, but not as complicated as them.
I have a page with some search criteria at the top. On submit, I am displaying my query results for this criteria. I need the user to just be able to print the results without the search criteria. Whats the best/easiest way to achieve this? Frames? Printable version?
View Replies View RelatedDoes anyone have a clue have to make a quiz in asp using an xml file? I found a good quiz but the code is in asp.net so we can't use it
View Replies View Relatedhow to create a search option that would search the recordsets in my database table.
I would be allowing users to search by name or date. I'd like the results in the same page. Any suggestions or tutorials?
i have been trying to create a search and result page. - (The same page if possible) using both Dreamweaver and Frontpage. But keeps returning a provider failure code. i know want to just code it to see if that will work but am a newbie when it comes to coding. I wish to do a search on 1 field in a SQL database if at all possible using a trusted connection, but return more fields from various tables.
View Replies View Related<form action="a.asp" method="get" >
<input type="image" border="0" src="IMAGES/oklar.jpg">
</form>
im usnig this codes to submit form when a user click on oklar.jpg(an image)
... but it submits form ***a.asp?x=6&y=8*** like this.. x and y takes
randomize values... how can i remove x and y variables from my string... if
it cant be possible how can submit a form when a user click my image file...
i m trying to create a true and false quiz which accesses the questions from a access database processes the results and then writes back to the database
I dont know how to structure the code for the radio buttons,i also need to give the user immediate feedback, but i cant use pop up boxes
I want to create a online quiz where in each page i have a question and 4 choices to select for the user. Now what i want is that each page(ie each question) have a time limit(eg. 5 secs). Now after the time limit has passed, the page should get disabled ie even if the user clicks back or refresh button the form response buttons should get disabled or the browser should display that the page has expired.
i want to have 2 tables in my database. One for the questions and answers and correct ansers.. and another table for users who register and their individual scores. Now how can i handle these two tables in one ASP file .
I am trying to debug a problem with some ASP pages when accessed via IIS on
Windows 2003 Server SP1.
In summary, the pages are structured as follows:
Root page
Page loaded via IMG SRC
Root Page extract Code:
I am attempting to only show 10 results per page in my results page. I keep on getting the following error. Wrong number of arguments or invalid property assignment: 'MoveFirst'
Does someone know where i am going wrong? Code:
Here's what I want to do (i'm kind of there in JavaScript, but want to move it to ASP).
I have 17 different html pages. quiz1.html > quiz17.html.
The user says take a quiz and it pops up a window holding quiz1.html.
Within each page is a true/false question. Upon answering the user is told:
1. what they answered.
2. if that is correct or not
3. a corresponding sentence about the question.
4. an image the corresponds to if they were corect or not.
(This is all done in javascript).
----
However, now I want to take these 17 questions and randomize them and choose 6 questions.
For example:
The window pops up and it's question 1 they do that then move to the next one. 1-6 (random out of 17.
I'd like to do this in ASP.
I have set up Index Server in IIS to search my intranet. I've installed the Adobe PDF filter so that words from PDF files are included.
I can get results from PDFs when querying the catalogue in the Windows console. However, I have tried various ASP Search pages and they all ignore PDF files from a browser (even though the scripts include the pdf extension).
Following is a function on button click event to display the details of an user.if i include this function page is not displaying.can u tell me where the mistake is? Code:
View Replies View RelatedI have IIS 5.0 configured in win2k server. When I browse a html I have no problem. But when I browse an asp page, the browser is hanging around.
View Replies View RelatedI am trying to create an XML file but i want to create an ASP page that will eventually save the XML file to the site, but to get the formatting of the file correct first, i want the ASP page to display the XML in the browser window. as an example: Code:
Response.write "<graph caption='Feburary Track Listend To' xAxisName='Date' yAxisName='Total Tracks Listened Too' showNames='1' decimalPrecision='0' formatNumberScale='0'>"
as i have it i can see the line if i view source but its not displaying on the actual page. Once i have the format of the file correct i will need to save it to the disk on the web server but for now i just need to see what will be saved.
I have an XML file, which is a phone list of staff for the firm i work with. I need to display this in an ASP page. Is there a code which will do this? As it will be live and update as the XML file is updated.
View Replies View Related