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 %> ......
View Replies
ADVERTISEMENT
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 doing some research into the reporting capabilities provided by ..NET by itself and also integration with other programs such as Crystal Reports or thrid party tools. I don't have much experience with .NET technologies but most of the reports will be requested through the web and produced via VB components with a SQL 2k backend.
I am looking for reports either in xls or pdf format and mostly they will be data intensive i.e. no graphics such as bar or pie charts etc.
View Replies
View Related
I have customers that I designed a site for. I am almost complete with the site, and they are saying that the font is too small. However, on my computer it looks just like the font on devshed and everyother site. Are there any suggestions out there, as to maybe their settings are messed up or my scripting is bad .
View Replies
View Related
I have written a COM component who's purpose is to allow a user to change
his Windows (NT/AD) password via a web page. Now the component works fine
when I run it in VB 6, but not via the web page. The component also returns
an integer value that contains a return code from the Component (and the
appropriate Windows API). The result (using the ASP page) is Zero, which
indicates success. However the password doesn't change. (Zero = success, 100
= Invalid Domain, 101 = Invalid User, 102 = Invalid Password). Code:
View Replies
View Related
I have two dates formatted as 'General Dates'....
21/08/2006 21:39:21 and 21/08/2006 21:58:48
How do I find the difference between them in seconds? I take it thats there's 2 ways of doing it: either with ASP or SQL. Anyway of doing it. how would I go about doing this?
View Replies
View Related
I have a field called EndTime in a table called tblSessions. This field is a Date type, with a General Date format (DD/MM/YYYY HH/MM/SS). I want an SQL query which can return entities which are less than 30 minutes old.
View Replies
View Related
I have developed asp application, but never worked with shopping
carts. I was wondering, when a user clicks on Add to Cart for a
product, is it done visa session variable, where item detail and price
is stored, and later on, fetched and added together to show total
price?
View Replies
View Related
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
sometimes but not every time when i upload a fresh copy of my database to my webspace..
i receive this dreaded error..
Provider error '80004005'
Unspecified error
on the line that connects to my database..
Code:
View Replies
View Related
when i run the ip of my web site i get the following error:
HTTP 500 - Internal server error
the log file shows the following error:
The server failed to load application '/LM/W3SVC/1/ROOT'. The error was 'General access denied error '.
View Replies
View Related
Periodically, our entire website will display the following error for all
users when requests are made to ASP pages:
DBMSSOCN General Network Error
HTML pages will load just fine, and I *believe* that ASP pages that don't
access SQL Server will also load. Someone suggested this problem has to do
with named pipes, but I don't have any clue when it comes to networking and
our network admin just resigned. This happens very sporadically (maybe once
a day) and never seemed to occur when he had DSN based connections. We also
have migrated our SQL Server to another machine (used to reside on the same
machine as our webserver).
Any ideas on what could be causing this?
View Replies
View Related
What does a website need in order to send
text messaging to cell phones? Is this something the hosting company will
offer or does the website need servers from Micrsoft? Can you refer me to
where I can get more information on this?
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
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
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
can anyone tell me what i have to do with this error ...
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xeb0 Thread 0x7a0 DBC 0x1110064 Jet'.
everything was ok until i Compact and Repaire the DataBase
i checked google everyone says it is security problem. i am admin on my computer but still i give all users Full Control Permission for both Temp and server folder "C:Inetpubwwwrootcareer" and i Add Everyone with Full Control but there is no use
any ideas ...
View Replies
View Related
I have the following pages...
page1.asp
page2.asp
page3.asp
page4.asp
page5.asp
The following variables are given values on page1.asp:
FirstName
LastName
Address1
Address2
City
State
Zip
The values are not used in pages 2-4, but are used in page5.asp.
Should I put the values in session variables? Or should I put them in form
post data? Or does it really matter?
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
I'm trying to add a user to active directory using ASP and am receiving the
following error:-
Active Directory (0x80070005)
General Access Denied Error
Does anyone know how to get round this problem?
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
