Handling Questions
i have a scenario where i have to serve users of my site questions on daily basis,but before they can answer a question they must answer a previous question correctly served previously before the current day .
This means to me that i have to keep a log of each questions served each day and users response whether they attempt the questions or not .i am scared to keep a scenario of a million users each day,their actions on a particular questions.what is the smartest way to achieve this.
View Replies
ADVERTISEMENT
Q1. How do I send 2 dates to a stored query in access. What I have in the
query so far is
Select * from tblOrders where Date_Archived between #3/01/04# and #3/31/04#
What I want is to send to variables to this query that the user inputs.
Q2. I know that this is probably not the right group but I am trying to
trim a string (first name to 1 letter) in an SQL statement.
Does any one know how to do this? I do not want to use ASP as I will be
build a complete CSV file on the file (column names and data)
View Replies
View Related
I never used any ASP or ASP.NET and i want to know if this is something worth learning.
I am about to start learning PHP (i know PHP a litle bit already) but will it be better to learn ASP.NET instead?
How does ASP.NET compares to PHP? I know that PHP is free, what about ASP.NET? Which is easier to learn/implement? Which is faster? Which is more powerful? What are the strong/weak points of each?
View Replies
View Related
i hope no one is getting sick of my server.execute/transfer questions..
does server.execute return a value? im wondering what happens if an error
occurs in the .asp file that i'm calling with the server.execute command??
is there a value/flag i can set in the case of an error that can be seen
once i return to the calling page? if not i was thinking that i would have
to use a session variable for my error handling.
i want to stay true to the model, view, control architecture so i don't want
to simply redirect in the case of an error - i want to send a value back to
my control page which will decide where to go.
View Replies
View Related
First, how can I get asp to create a table in en existing DB that is an atuonumber. Meaning.. If say table 56 exists alrady, I want it to create 58 as the name. Along with this, I need to copy the fields from table temp, into the above DB. Can this be done?
View Replies
View Related
I was reading up on sessions, and on websites they don't mention "passing" session varables. But the guys on this form are asking questions about passing session variables. So what is it? Can you or can you not pass variables? I don't think you can pass session variables, since they are just cookies.
Second, does the session expire when the brower closes? I know it expires with Session.Abandon or it times out.
For my project I need to the user to login and do his/her stuff. The session should expire by timeout, or logout link (Session.Abandon) and when they close the browser. My guess is that when the browser window closes the session expires. I just need to make sure about those two things.
View Replies
View Related
I am trying to create a hashtable in ASP. I need this to be on the application level,
i.e. each page from different users calls the same table. I figured the best way to
do this is through a recordset.
I need it super fast so I want it loaded into memory (RAM) and be altered in memory. What is the best way to do this? I found all these different connection types, but nothing seems to fit this purpose.
View Replies
View Related
I have questions relating to TabView and Tabbed Navigation.
Currently, this is what I have
[code]<DIV id="divTabs" style="LEFT: 5%; WIDTH: 450px; POSITION: absolute; TOP: 10%; HEIGHT: 10px">
<%=strTabs%>
</DIV>
[code]
That displays the tabs...but heres my quesiton
Now what I would like to be able to do, is throw those tabs on the bottom of the page. Is this possible? How do I go about doing this? Could someone supply me with the changes in code I need to make?
View Replies
View Related
<object RUNAT="Server" ID="dbConn" PROGID="adodb.connection"></object>
When using such objects as the one above, where is dbConn actually comming from?
How do I store session variables using the session("") in the code below? Everytime I try doing it, I get an error page.
<object RUNAT="Server" ID="dbConn" PROGID="adodb.connection"></object>
<object RUNAT="Server" ID="spEssRtd_loginValidate" PROGID="adodb.command"></object>
<%@ LANGUAGE=vbscript enablesessionstate=false %> ......
View Replies
View Related
A week or so ago, I needed to find the HTTP_REFERER environment
variable to check and see if a user is coming from a certain website:
If Request.ServerVariables("HTTP_REFERER")_
= "http://localhost/mydir/page1.aspx" then
response.write "Click on a menu choice"
else
response.write "check back later
end if
I have a page nested in an IFRAME (for example framepage1.aspx or
..asp), and I need to check to see if a user is coming to (not coming
from ) a certain page where the framepage1.aspx is (the
framepage1.aspx could appear in not only page1.aspx, but page2.aspx ,
or page3). I'm not sure how to accomplish this given that the
HTTP_REFERER checks on address only incoming.
View Replies
View Related
I have seen sites that have asp searches and have a textbox and a search button and when the search button is clicked a search results field is displayed on the same page. Im having problems grasping how this works.
I am assuming that it states that if search is clicked then display the search results field. But how does it do this? Does the entire page reload? Is it a table that have attributes set to invisible then are change to visible? Anyone with an example or that can point me in the right direction please let me know.
View Replies
View Related
A week or so ago, I needed to find the HTTP_REFERER environment
variable to check and see if a user is coming from a certain website:
If Request.ServerVariables("HTTP_REFERER")_
= "http://localhost/mydir/page1.aspx" then
response.write "Click on a menu choice"
else
response.write "check back later
end if
I have a page nested in an IFRAME (for example framepage1.aspx or ..asp), and I need to check to see if a user is coming to (not coming from ) a certain page where the framepage1.aspx is (the framepage1.aspx could appear in not only page1.aspx, but page2.aspx , or page3). I'm not sure how to accomplish this given that the HTTP_REFERER checks on address only incoming.
View Replies
View Related
I am designing a Web site with about 500 - 600 pages of festivals on it and would like opinions on two ASP subjects. I have designed about 20 pages or so as of now. These are the contact us, FAQ, about us pages and such. I also have a template to go by for each festival's page. But I have two problems I need fixed before I start to replicate.
(1) SSI and styles - There are four sections to each page. I use SSI (ASP virtual version) for the top, bottom and a small section of featured festivals (which is above the bottom) on each page. Between the top and featured festivals is the actual page. This way I can change a link on the top or bottom and it is fixed on all pages.
But, I have an enormous amount of styles listed (all styles on four pages) in the code from each page's fonts. Each page's styles are called something different. For example, the festival page itself has the styles as normal, ".style1." But the styles on the top the links, which once again is an ASP include, would be called ".style1top." I used that approach because .style1 on the festival page and top links could be different.
It works, but I have dirty code and I want the site to be as Google friendly as possible. I have thought about adding all the styles to a page and using it as an ASP include on all pages, but that would have way too many styles each page and be even dirtier. What is the best practice for this? Code:
View Replies
View Related
I keep reading that Session variables are evil things to be avoided. Is it
really that awful to use them? If you shouldn't use them, then what is the
preferred alternate method for accessing data across an entire solution?
Would it really be so bad to set something as simple as Session("login") =
true Session(user)=username when a user logs in and just read those
variables on an include for every page to display the user name?
Is it true that a user has to allow cookies in order for a session variable
to be used? I thought the point of session variables was to set things on
the server side so that you didn't have to worry about cookies being allowed
by the user?
What is the generally preferred method of storing a shopping cart?
Database, cookies or server variables? All I need to save is the product #
and quantity. Would it be evil to store that in a dictionary object or a
collection? My profs at the college said cookies were the way to go. My
co-workers say use a database. My mentor says use a dictionary object.
View Replies
View Related
an idea of the type of ASP questions asked in an interview?
View Replies
View Related
I've made an access script user based for a forum, so, I'm not sure what to store in the cookie. I think to store just the user_id (the one in the users table referred to the logged user) but is this way sure ? is anyway to hack it simple ? I know that nothing is 100% secured, but not too simple to hack.
Have I to store other informations like session id or something other ?
Another question is for the login form... Somebody checks if the session.id of the user is the same between the page containing the login form and the page that checks informations... but is this really useful ? infact is an user stops on the first page (the one where is the login form too) reading something until the session goes to timeout then the check session fails...
View Replies
View Related
I have a voting system that works perfect. It calculates the % of votes and shows the total percentage that people picked 1st, 2nd, and 3rd, and a total.
However, I want to be able to select the top 3 of those, and highlight the row, using a bgColor variable that I have defined. The problem with this is that I am calculating the %'s as I am writing the rows, and do not know how to check to see if that row is one of the top 3.
Here is my code:
View Replies
View Related
ASP And Visual Basic Interview questions and answers
I have listed over 100 ASP and Visual Basic interview questions and
answers
in my website
http://www.geocities.com/myintervie...VisualBasic.htm
So please have a look and make use of it.
View Replies
View Related
I would like to know how many rows and columns are created in the following array. Is it 10 rows and 2 columns or is it 10 columns and 2 rows? Dim Array(9,1)
I have searched for some info about it but not found any consensus. Some sources claim that the first number symbolizes the rows and the second number the columns and other sources claim the opposite. I am confused.
What is it really like? How many rows and columns?
Assume that I need an array with 2 columns and 5 rows then how should it be declared (4,1) or (1,4)?
Which is the first dimension and which dimension it the second one? Horizontally (first/second) vs vertically (first/second)?
How are the various elements called, for example how is the element on the first row in the 5th column called. By using (0,4) or (4,0)?
Assume that I want to store first and last names in two separate columns in an array and then expand the array by using Redim/preserve. The dimension I want to expand is the one with the rows because I view the array as a table with two columns.
I know there are certain rules that apply when it comes to using Redim/preserve on multidimensional arrays. Only the last dimension can be changed etc. How could that be done in this case? I am mainly interested in the declaration (1,x) or (x,1), where 1 is the number of columns and x number of rows (that is increased).
View Replies
View Related
I've got an application setup that uses freightquote.com API to receive XML responses containing shipping information. A basic response example is as follows: Code:
View Replies
View Related
I normally work with MS Access databases using ASP pages. I have been
given the opprotunity to work on some available SQL server space, and
wanted to ask a couple of questions. The following is a simple update
query that I use. It is an ASP page that connects to an MS Access Db:
<%
Set Conn = Server.CreateObject("ADODB.Connection")
myDSN = "DRIVER={Microsoft Access Driver (*.mdb)};"
myDSN = myDSN & "DBQ=xxxxxxxxxxxxxxxdatabase003.mdb"
mySQL="UPDATE SKUList SET SKUList.Department='Furniture' WHERE
SKU='123456'"
Conn.Open(myDSN)
Conn.Execute(mySQL)
Conn.Close
Set Conn = Nothing
%>
I was wondering if someone could tell me (or better yet show me) how
this code would look in a SQL server enviroment. I have no information
on the server itself as the database will be setup for me, and I will
just need to create ASP pages to connect.
View Replies
View Related
I am developing a system for a certain use and now all the major programming is done. The next step is to include error checking for all the forms (there are 9 pages with forms to add data and 7 for editing, so total 16 forms)
I just started with the most simplest and I was wondering if anyone had a good suggestion on how to validate Dates?
I was also wondering if its possible for example to write a data validation script which I can use for all pages, because like one page has 90% date fields.
If so, how can I accomplish that? Won't I need to pass the name of the text fields in some way too?
Is it possible to do that for other similar fields too, like first name, last name, phone number?
Oh yeah, the way the entering of dates works is that there are three separate text boxes, for Month, Day and Year. So a case date is divided into, case_mm, case_dd and case_yyyy.
View Replies
View Related
I have been trying to find a script on the net that would allow me to handle directory listings through ASP. I'm basically looking to change the default generated pages when browsing directories. Eventually I would love to be able to change which directories/files show based on permissions and be able to allow uploads to current directory listings.
View Replies
View Related
I am attempting to use url's on a database driven webpage - the url's are really ugly (created by mapquest) - I have tried to put " quotes " around the urls in the database as well as without - but all i get is a blank about page, can anyone help.
Here is my code:
<td><a href="<%Response.Write(rs("Directions"))%>" target="_blank">Directions</a></td>
View Replies
View Related
How do i do error handling using asp. Like taking an example i am getting this error on trying to save a record twice whihc has a primary key constraint:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.
how can i handle such cases and where do i place the code???
View Replies
View Related
I have a piece of code which causes an exception. Now i don't know why that is. I would like to know the best way to debug the exception.
I know about try and catch statements. However with these you need to have a basic idea of the type of exceptions that could occur. Does someone have a better suggestion on how to debug an exception?
View Replies
View Related
I’m trying to write a script that will select some records from an Access database within a certain date range one of the fields is a date. Code:
View Replies
View Related
sql = "SELECT * FROM Calls WHERE Date BETWEEN " &startdate& " AND " &enddate
Where did I go wrong?????????????
Ugly response:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
View Replies
View Related
I want to error handling in ASP. But i think that ASP is not enough for
error handling. I have got two chance.
1. I can prapare an error page and control throught IIS.
2. I can use on error resume next.
For 1. This is a general handling. I want to handle local error. Maybe i do
special thing when error occured.
For 2. I have to write alot of lines code. I have to control every line.
View Replies
View Related
if I have two strings as follows :
"1,3,45,65,777,89,00
and
"8,9,67,54,89,23
The numbers represent a predefined access permission to a certain file.
I need a function to sift through the first string, and compare it to the second string. What numbers are located in the second string, which are are located in the first string need to be removed (from the second string) leaving only unmatched numbers beind.
View Replies
View Related
how use the array handling in asp
View Replies
View Related
Is there a possiblity that, when an error comes in asp page in server, especially with sql script, to hide that error from user and display just Error, report to admin,
i just want to make a general case where when an error comes i should take the page to report to admin.
View Replies
View Related
im following all single quotes as follows:
email = request.form.item("email")
email = Replace(email, " ' ", " ' ' ")
so as not to crash my database. Only problem is, when i take a value out of the database it now has two quotes instead of one (example Linda D'Agostini --> Linda D''Agostini)
View Replies
View Related
