Questions Asked In An Interview?
an idea of the type of ASP questions asked in an interview?
View Replies
ADVERTISEMENT
Visual Basic Interview Questions
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.
Idea's And Code Asked
i receive from all over the world TXT files.
in the name of those files will be the name of the customer and the date
the customer must be able to see the data in the txt file
but the data must be orderd nicely on the page, the txt files are structured like this:
1;12;23;blabla;256;5;6;9;l;qdsf:546;
the startscreen for the customer must be the last file
and he must be able to scroll back trought the files
no databases are alowed, ne editing or deleting is alowed
how to get the data out of the txt file into variables?
how to determin witch file is the last one and witch file is previous one etc... ?
how to get the customers name out of the filename?
what's the best way to make the customer browes through his data?
ASP And Visual Basic Interview
ASP And Visual Basic Interview questions and answers
I have listed over 100 ASP and Visual Basic interview questions and
answers in my website
2 Questions. ASP & SQL
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)
ASP.NET Questions
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?
Transfer Questions
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.
A Few Questions About Creating Using Asp
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 RelatedSessions (two Questions)
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.
Recordset Questions
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.
TabView Questions.
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?
General Questions
<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 %> ......
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.
HTTP_REFERER Questions
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.
Seaching Questions
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.
HTTP Referrer Questions
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.
Two ASP Related Questions - SSI And Links
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:
Session Variable Questions
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.
Login Panel Questions
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...
Grab Top 3 Vote Questions
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:
Various Basic Questions Regarding Two-dimensional Arrays
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).
Displaying XML Data With XMLDOM Questions
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 RelatedGeneral Questions About SQL Db Connection Using ASP Pages.
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.
Validating Dates And Other Validation Questions
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.