Database Usage
i have an access database which iv'e designed for my 'client' (ok, he's my friend) and now i'm also in the process of designing a website for his company - so his customers can log on and see their order status.
what's the best (and most secure) way to update the site - we don't host the site - it's hosted by someone else.
i'm totally at loss with this - since iv'e never worked with networks or servers and i just want someone to point me in the right direction. i don't want to get lock errors and the like.
iv'e heard a bit about ADO and i know some of the syntax although i'm not really sure how it applies to me here (i'm not exactly exposed to ADO since iv'e been learning asp.net 2.0 from which i understand, has totally eliminated ADO)
View Replies
ADVERTISEMENT
I have a client that wants a web form to send credit card information and other personal information to an email address. (such as name@aol.com) Now I am uncertain on how to do this. I know SSL must be involve, but what is the process with this and how to use it with ASP ? How do you use SSL with ASP .
View Replies
View Related
I am building a small Web app that will allow end users to visit a Web page, click a button which will in turn execute a batch file on the Web server which will migrate code from the development environment to QA. The Web app will also capture logins and execution requests, and the batch file currently emails the robocopy log to me.
In researching ways to get the ASP page to execute the batch file, I came across ASPExec from Server Objects - http://www.serverobjects.com/products.htm#free. It seemed straightforward enough, however I have not been able to get the permissions in sync for it to work.
View Replies
View Related
I have just figured out how to use the global.asa file to track sessions on my site. However it relies on users logging off correctly. Is there no way that I can know that the user has closed the browser WITHOUT logging off my site? I am finding users registered as being logged in when they may not be
Could anyone show me some code that I could put in Session_OnEnd that would clean up my database table of active users? Say if a user has been in-active for 60 minutes, clean him out. I have tried to do this but it hasn't worked. I cannot seem to connect to my access db from the global.asa file!
View Replies
View Related
What is the proper way of using html in asp
Response .write "<td>"& variable & "</td>"
or
<td><% Response.write (variable)%></td>
What difference does it make?I am building a table whose number of rows keep changing
When i use the second method the space above my table keeps increasing.I just want to know which method is better..I had posted a similiar question....I'm still trying to figure out.
View Replies
View Related
I'm currently working on a survey system that allowes users take the survey and then review/change their answeres in any order. The system uses 3 frame (Header,Body,Footer).
As it stands the system uses 3 sessions to get this done. One for the project they are in, one for the step they are in and one for their answers.
My question is at what point do I end up over whealming the system with sessions? I truly do not want to slow the system down that much. how I could optimize the usage of this?
View Replies
View Related
Is there a way to use a Session Variable to prevent the successful resubmission of a form if the user uses the Back button and tries to submit it again?
View Replies
View Related
Does anyone have working ASP code that shows CPU usage on the server where it's running from?
View Replies
View Related
Hi's there any concerns or disadvantages of using alot of respose write's (50) in a ASP page for calculations and is it better than using the recordsets to do the calculations?
Also, we are looking at moving to a secure server, will this cause any problems apart from changing all references to https?
View Replies
View Related
Can anyone point me in the right direction for dealing with a dynamically created table of shopping cart items? Each row (or Item) has a column where the user can change the quantity. Is there an easy way to grab and use these changed values when they hit the form submit button?
Or, do I need to bite the bullet and write code that filters through the form fields named "quantity1," "quantity2," "quantity3," etc... And then determine which one goes with which cart item?
View Replies
View Related
I have a problem with our web servers and memory etc.
We have one application pool with a few websites in it and the w3wp.exe is
consuming about 800 mb memory now.
First we had a rule for recycling the application every x minutes or when
it's using more than 600 mb memory but when the recycle is activated the
w3wc.exe process hangs and the cpu usage goes to 100% until we execute an
iisreset.exe.
That's the reason why we disabled all the recycling options and configured
only one worker process for that application.
All the websites in the application pool use the same code, only they have a
different skin.
The website also uses xml/xsl transformations.
Is it normal for an application to push the w3wc.exe process to about 1GB???
If this is the case i really want to know how much memory dedicated hosting
companies need in their webservers :-)
We are storing some information in the application cache, but this is only
for the entire website and not per user... in plain text so the amount of
data would be no greater than 100KB at most.
The application is in classic ASP.
We walked thru the entire code and checked for correctly closing all sql
recordsets, email components etc etc etc...
What is the best approach to find out what is using so much memory and why
the recycle does not work correctly?
View Replies
View Related
I have 4 ASP pages where an user can update some fields and submit the page, so that the fields are updated in the Database(Sqlserver), I need to handle one situation.
1) At a time I need to allow only one user to update the details in a page.
2) I need to stop other users who are trying to access the same page concurrently(probably with a message or Redirecting to other page where he can see the details in a report format).
3) Session timeout in my application is 60, So if the first user leaves the page open for a long time , I think it would be a problem....the other session has to wait for a long time.
I have no choice in decreasing the session timeout interval.
Please suggest , How can I handle this in ASP.
View Replies
View Related
I am in the process of writing a simple web server monitor (ASP.Net with
VB.Net). One piece of useful information for me to gather would be the
amount of memory used by objects stored in the cache, since objects are
thrown in there left and right.
Items in the cache are either custom objects or are Hashtables. How can I
get the memory size of these objects.
Marshal.SizeOf(object) does not work in this case because .Net cannot
Marshal Managed objects. I thought that I might be able to pull out the
component items in each object and build the total size from their aggregate
sizes, however that would require me to determine each objects type so that I
can correctly gather size info from the internal attributes, something that I
do not want to do.
Is there a generic way to either:
1) get the size of Managed Objects
2) convert Managed Objects into Unmanaged Objects that can be marshaled?
OR
3) some other way to get memory sizes of cached objects
View Replies
View Related
I am trying to get a thorough understanding of a code where a addition or
deletion of records can be done from a list of records. For addition part of
the form, data is being obtained from set of input boxes. Code:
View Replies
View Related
When using cookies in classic asp, is it safe to assume that using a comma delimited list of values in one cookie is much more efficient than using multiple cookies? (example below)
Response.Cookies("someCookie") = "101,102,103,104,105,106"
If InStr(Request.Cookies("someCookie"),"103") 0 Then.......
vs.
Response.Cookies("101") = "True"
Response.Cookies("102") = "True"
Response.Cookies("103") = "True"
Response.Cookies("104") = "True"
Response.Cookies("105") = "True"
Response.Cookies("106") = "True"
If Request.Cookies("103") = "True"
Then.....
View Replies
View Related
How can a measure server session memory usage?
I have a 20-30 session variables and I would like to know how much they memory they consume then multplied with my projected user load.
View Replies
View Related
I have just started using ASP, I am normaly using PHP but I thought ASP might be a good road to go down. I am having a few problems, I am trying to limit the number of records I take out the database but I keep getting errors.
<%
'connection string
datapath=Server.Mappath("guest.mdb")
strconn="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & datapath & ";"
Set CONN = Server.CreateObject("ADODB.Connection")
CONN.Open strconn
'select all records row by row
DBquery="SELECT * FROM Guests LIMIT 10"
set query=Conn.execute(DBquery)
do while not query.eof
'get a variable from the table
guest_id = query("ID")
guest_name = query("Name")
guest_msg = query("Mesg")
guest_date = query("DateTime")
'print the variable to the screen
response.write guest_id & "<br />"
response.write guest_name & "<br />"
response.write guest_msg & "<br />"
response.write guest_date & "<br />"
response.write "<br />"
'move to the next record
set conn = nothing
query.movenext
loop
%>
I am getting this error;
Microsoft JET Database Engine error '80040e14'
Syntax error in FROM clause.
/guestbook/guest.asp, line 11
can anyone help me?
View Replies
View Related
I had made a form name 'dform.html' which asks idno, name and phone from the user and after the user clicks on button "save data" sdata.asp is executed. sdata.asp is written to save the values entered for idno,name and phone in dform.html into table "myfriends" in the mydata.mdb (access database). but when i am clicking on save data button i am getting error saying
"Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
/SDATA.ASP, line 9"
can please anyone tell me why i am getting this error.
View Replies
View Related
I work with ASP for several weeks now and i really like it! But until now i have just used it in connection with my localhost. I made connections to a SQL Database and to an ACESS Database with using the ODBC Tool from WIndows!!
Now i want to publish my website but i don't know how to handle the connection string kind of thing. My MySQL-Database is on a different server than the website and i need a connection string where i can type in the server, a password and a username and it should then connect.
View Replies
View Related
I'm current working on a project which need to upload local data to
live server database.
Meanings that, i'm current having a server in my local mechine. I need
upload data from local database to live database which host at oversea
company. But i really have no idea how to do this in asp.
View Replies
View Related
Error Type:
Microsoft JET Database Engine (0x80040E21)
Cannot update. Database or object is read-only.
/q_maker/aero_admin/delete.asp, line 12
what is wrong! i checked the db and its not readonly.
View Replies
View Related
i wrote a shopping cart using cookies found out thatIE 7 won't let me add more cookies after a certian number. decided to use DB along with cookies and now i have very weired problem never encountered before Code:
View Replies
View Related
Products ---> Products|Customer <--Customer
With regardst the above many-to-many relationship:
Is there any advantage in creating seperate access databases for:
- Customer
- Products
....Rather than keeping them as three tables in one database.
The reason I ask is that I have found that if I am using a ftp approach to
overwriting or updating the remote database there are sometimes problems
with synchronizing data .....This seems to be a better solution?
Am I off base?
View Replies
View Related
does any one know a simple free database driven website tutorial that i could learn? i need it for when someone searches a name ionformation on that name comes up along with photographs realating to them.
I have built several websites before but none are database driven so is there any dummy proof versions?
View Replies
View Related
How do I do a Do While loop to display rows of information out of a database. Here's my code, and it seems like its in an infinite loop. Code:
View Replies
View Related
I have a Access DB with two tables (Users and tblpersons). Users are stored in table Users and their records in tblpersons. They are able to login, Enter, Search, Update their data.
I want users to be able to Enter and update only their data not other users data.
Example:User_Id 1 when logged in, is able to enter data for any user(1,2,3......) and able to modify their data.
View Replies
View Related
I can make a simple database file and name it database.mdb, all I need to do is name a single field email and save it. But I dont know how to make it so that my page will become active and the emails submitted will be saved either to the mdb file or a text file, im not sure what goes on there.
View Replies
View Related
i have 2 tables and i only want the records where which arent in the one database eg.
table 1
idnum
1
2
3
4
table two
idnum
1
2
3
4
5
6
out of these two tables i only want from table two idnum 5 and 6 cause they arnt in the 1st table.
View Replies
View Related
They are on Windows 2000 IIS 5.0 and currently have an older version
of their job database using Access hosted on a Brinkster server.
The new server that they are on, when I contacted the host, they advised me
against creating any new applications using Access, as the server is not meant
for multi-users.
So, I am thinking that they need to get their host to upgrade to a SQL database
and have the job database developed using that.
My question to this forum is: What do you think is the best combination for
improvement here, SQL or MySQL or what, considering that their site is using asp
and hosted on Win2000 IIS 5.0?
Also, any recommendations on scripts that might be already available that could
be customised to their site?
View Replies
View Related
What we have is our own (in house) Windows 2000 Server which runs MS SQL for our data storage and we have writen our own VB6.0 Application which runs of the SQL DB to manange our stock, ordering, price's etc etc. Also we have our own Website with a Web Hosting Company which is also a Windows 2000 Server but can only Run access databases.
What we what to do is somehow have the Access database and the SQL database sync together to have some of the same data in both database's. But I don't know where to start.
View Replies
View Related
I have the following code to execute a SQL query.Code:
SQL = "INSERT INTO teams (`teama`, `teamb`, `pot`, `winner`, `finished`, `start`) VALUES ('" & teama & "', '" & teamb & "', 0, '', False, '" & gdate & "')"
teamrs.Open SQL, conn
all works fine.
I just want to know what result it gives.because once i add it, the form submits, and its a blank page. I want it so it does this Code:
if sql = worked
redirect
else
error
end if
so how can i make sure the query was executed successfully.
View Replies
View Related
This is probably a stupid question (I'm good at those)...
I would like to enable a user to be able to browse to a picture on their local machine and upload that picture to a remote directory where it can then be displayed along with it's other pertinent data.
I thought it might be a good idea to use Front Page's "file upload" feature which includes a "browse" button and prompts me for a storing location - but I can't get it to work and am not even sure if that's its intended purpose.
So my question is two-part, what should my insert or update page look like regarding an upload process, and then how would I link to or display that picture?
View Replies
View Related
I have some questions in a database, i showed in the web page, for each questions i gave 3 (Yes, No, Not Applicable) options via select - option. when i get the variable with select name, it is showing with comma.
Example :
If they select for like that
Ist question - Yes
IInd question - No
IIIrd question - Yes
IVth question - Not applicable
The variable is coming like (Yes, No, Yes, Not applicable)
but i want to get with separate variables.
View Replies
View Related
