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.
ASP And Visual Basic Interview questions and answers
I have listed over 100 ASP and Visual Basic interview questions and
answers in my website
an idea of the type of ASP questions asked in an interview?
View Replies View RelatedI 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).
I've read hundreds of posts regarding this, but haven't got a working solution yet. Does anyone have a working snippet of code from an ASP page that can be used to upload a file to an FTP server? I read all about INET, but due to some licensing issues it won't work....
View Replies View RelatedIs there one? I need to hash a sensative string before inserting it into the sql server database. It HAS to be done in the ASP code, because it is also stored in a cookie. Any ideas? Server asp code is vbscript.
View Replies View RelatedI need source code for a simple MSN API example, something that interacts between MSN's controls. I want to break it down test it and use it for my own applications.
Or can people even suggest free source code sites for VB. I can search for them there. Planet-source-code had an AMAZING app, but it wanted an ocx file which I obviously didn't have.
I would like to know the Pros and cons for using ASP VS Visual Basic for intranet, in terms of time development and customization. The project that we will use it is a basic Information Management System.That could be used for offline and online using IIS and MYSQL.
View Replies View RelatedI know we can write ASP with VB Script. Some people told me the big ASP
projects usually use Visual Basic for the business logic. Is that the case?
What I mean is an ASP project is the combination of server-side ASP code and
Visual Basic components (.cls)
I heard that there are two ways of coding with ASP. If I'm not wrong then it is by the use of VB or C.
What do these two terms mean?
When should one be used as opposed to the other?
How do I recognize a current website that is coded with either one?
Please explain. I'm new to all these technologies and ASP altogether.
i've written a program, where is the compile button? I can only save it as a script.
View Replies View RelatedNot sure if this is the right group for this but anyways...
I've got an ASP web application that uses a Visual Basic component to do
some work. I instantiate the component in asp and then attempt to call the
subroutine. The subroutine is actually invoked maybe 2 out of 10 times run.
What could possibly be the reason for this?? Why the inconsistency in
running the subroutine?
It's now 3 years I work with ASP writing it with VBScript. I would like to learn Visual Basic to be able to write ASP components. Anyone knows good free resources, tutorials to learn Visual Basic? I already have a book for ASP components, but I first need to learn the basics of VB.
View Replies View RelatedI want to insert the data into the MS Access Database using Visual Basic 6.0. Anybody please heplp me to tell the steps to insert the data into the database.
asp (visual basic script) break long text lines into several lines.
This line of my guestbook (visual basic script) - response.write "message: " & Recordset ("message") & "<br><br>" displays access database field "message" in one line in web browser.
How do I break this text line into several lines? I know in asp.net there is datagrid. Is there something like datagrid in asp. Or perhaps this problem can be solved with htm?
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)
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?
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.
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 RelatedI 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.
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.
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?
<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 %> ......
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.
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.
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.
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.
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:
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.
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...
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:
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 RelatedI 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.