File Versus Database?
Okay, I'm doing a project for someone in which random questions are to be pulled and posted so that the user can complete a test/quiz/exam for a grade.
Well, his host apparently doesn't have any database stuff, but I can probably get him to move to another if it's absolutely necessary.
Personally, I'd prefer to stick with files, just because that's what I'm most accustomed with. But if there's a very compelling reason (performance or reliability?) to move to a database, I suppose I could.
Here's a sample of the type of data I'll be using. The format is as follows: Question, Correct Answer, First Answer, Second Answer, Third Answer (If Any), Fourth Answer (If Any). A question is on each line (in this browser window, it may appear that a question is spanning several lines, but it truly isn't). Code:
View Replies
ADVERTISEMENT
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 Related
I have begun having problems with an entire site that has been using an include file called header.inc The file simply has some html for a nav table.
I had had everything under the root web using this, then I created a directory and had a file in that directory use header.inc This is where my problems began.
I went into the inlude file and changed all the paths to read "http://www.somewebsite.com/default.asp", etc. Is this right? When using an include in this context, what extension on the file is important, and what is the proper way to include the file...
View Replies
View Related
The default ASP generates the HTML response including several IFRAMES. It takes a long time to load this page. I believe a lot of it is round trips to load the IFRAMES. Couldn't include files be used to increase this performance, so everything is done in the initial call instead of multiple round trips?
View Replies
View Related
I'm working on developing (yet another) shopping cart for my work. I was wondering if anybody knows which approach leaves a smaller footprint in memory on a server: an ADODB Recordset which stores arrays one-dimensional arrays or a two-dimensional array?
We are currently hosing our web site on a shared machine at Verio. The cart I have to build needs separate carts because a customer's products can come from different locations. Each location will have a different cart. On the cart page itself, I would like to display each cart in a separate location.
Logically, it make the most sense (to me, anyway) to use an ADODB Recordset to manage each individual cart (array) than to write the code to manage the arrays. What are the disadvantages of using ADODB recordset instead of a two-dimensional array in this case?
Which approach would be easier to manage and manipulate? Are there any reasons why I shouldn't use a two-dimensional array? The nice thing about ADODB is that I will not need to program certain features and have access to FILTERS.
Any suggestions about how each approach would scale as site traffic increases? Will one approach bog down the server more than the other? I'm also open to suggestions about a possible, yet illusive, 3rd way.
View Replies
View Related
what's the differences between readonly and disabled attribute? When I do the post, it couldn't get both values <%= fname %>. any ideas?
<input type="text" name="fname" value="Joe" readOnly>
<input type="text" name="fname" value="Joe" disabled>
View Replies
View Related
When my webserver does not process a user's change because of an invalid password, I inform the user and I want to present them a button for a retry:
<TR id=continuebuttonrow>
<td width="05%"> </td>
<TD width="90%" align=center valign=middle colspan=2>
<BUTTON TYPE=BUTTON
ONCLICK="location.href='<% =Request.ServerVariables("HTTP_REFERER") %>';"
class=btnParms name=btnContinue ID="Button3">Try Again (Back)</BUTTON>
</td>
Yet if this button is clicked, they go back to the server and the page is refreshed with original values.
If I click the browser's BACK button (rather than my button above), I go back to the page (from cache I guess) I want (because it contains the user changes). Here I can correct the password without having to rekey the changes.
So, what is the Request.Servervariable needed for the equivalent of the BACK button?
View Replies
View Related
I encounter a page reload situation in ASP. It is I need a way to differentiate whether the current page - "Application_Result.asp" got reloaded itself when user click on the browserRefresh button or is requested by the previous page "Application_Form.asp".
I tried using
<%if Request.ServerVariables("REQUEST_METHOD") = "POST" then%>
<!--it is requested from "Application_Form.asp, do something-->
<%else%>
<!--Application_Result.asp refreshed itself(such as user clicks on the
browser Refresh button, do something else-->
<%end if%>
However, in both cases, the IF statement above all evaluated as true. how to differentiate this two different behavior (Page Refresh versus Page requested by another Page) ?
View Replies
View Related
I want to understand the difference between submit button and regular button: <input type="submit"> and <input type="button">. My understanding is that submit button will send the entire HTML form to the web server, but regular button won't.
I have a problem that needs to pass HTML elements data back and forth in several ASP pages. I am using regular button to do that. But what's the approaches?
View Replies
View Related
FP2000 | Access2000
How can I make a page that will grab info from my database and make it into a temporary txt file.
I need to do this in order to use a little component on the text after which I will need another page that will grab the txt file (that is now changed), delete the temporary txt file, and post the new txt to the database.
View Replies
View Related
how to convert a database table into an html
file via FSO and whether more seasoned asp programmers recommned this route.
The main reason I am attempting to do this is becuase we are constantly
being told by so-called marketing gurus that 'html' pages are more search
engine friendly. Code:
View Replies
View Related
is there a way i can read into two tables in the same database access file?and if so.. how would i write the code?the code below is already connected to a database reading from table1.. and i wish to read it from table2 as well...
rsMap.Source = "SELECT * FROM table1 WHERE (State = '" + Replace(rsMap__MMColParam, "'", "''") + "') OR (City LIKE '%" + Replace(rsMap__MMColParam2, "'", "''") + "%') ORDER BY City ASC"
View Replies
View Related
I'm simply trying to copy an intranet database file (VesselConfig.mdb) into the same directory but rename it something else (VesselConfig2.mdb).
Here's the code I have so far: Code:
View Replies
View Related
I'm working on an application that I will make use of "constants". I put
contants in quotes becuase they will change periodically (Logo path, css
path, psw expiration times etc). From a system admin standpoint does it make
sense to put them in a constants file, or put them in a database?
My database argument is that they can be modified by the customer via some
web forms.
My contants include file argument is that they can't be modified as easiliy
by a half wit customer, and there is no database overhead.
View Replies
View Related
How can i upload a file from a asp form to a database?
View Replies
View Related
I want to upload either image or word document into either access or SQL server database so far I am doing some small testings and what I can do is upload the file from first page and display at the next page with (both image or word are working fine).
however, I cann't insert them into the database, Plus, what type should I use in access database? Code:
View Replies
View Related
I worked on a database on PWS (Personnal Web Server). But transferring the database and all the files (html is used for inputting "search" words, asp used for results from database table). Here is my code:
View Replies
View Related
Question about the performance of using an include file or reading from a text file compared to hitting the database.
I set up a client's web site so they can post a weekly message and also post a "of special interest" message on their home page. Originally these messages were stored in and retrieved from an Access 2000 database. I decided to try writing the messages to a text file then retrieving it through include file and also tried the text streaming object.
I used netmechanic.com to gauge the download times for all three methods on a 56K modem. According to the results, using the database was around 4 seconds quicker. Does this sound right? The site is on a shared hosting package using Win2000.
View Replies
View Related
Using MSDE database & ASP file through IIS, both are in separate systems. Database is not connecting from IIS-ASP file.
Given error as "[DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not found", Using Provider=SQLOLEDB.1 But VB code is connecting using same provider
View Replies
View Related
Actually, I do not know why i can not add records to my access database table by using asp code, I get an error that tells me that the database file or object is read only file even though the file is not readable only from its proprties, I need some helpful information to solve this problem.
View Replies
View Related
I'm trying to get an ASP to return a zip file to the remote browser from an
Image (BLOB) field in SQL Server 2000 but Internet Explorer keeps saying:
Cannot open C:Documents and SettingsFrostillicusLocal SettingsTemporary
Internet FilesContent.IE5U7GXENGFfile[1].zip
The URL to open the zip file is like this: doc_view.asp?id=1&ver=2
....where id and ver represent the zip file's version in the database. The
code I've pieced together to return the zip file is as follows (note: this
code works fine for PDF, JPG, DOC, XLS, GIF, and all sorts of files - just
not zip - HOWEVER, if I click "save" instead of "open" in the download box
then open the zip file manually, it works fine - Internet Explorer just
won't load WinZip for me automatically) Code:
View Replies
View Related
I'm having this problem with uploading a file and updating the database at the same time the file will get uploaded but nothing will get updated into the database. Can anyone help me out. The third page is where everything is going wrong but i put all my pages in so you can see whats going on.
Here is my first page .....
View Replies
View Related
I am trying to write a page that lets the user upload any file to a server and this also stores the name of the uploaded file in to the database.
So far I'm not having much luck. I am a novice with ASP and really could do with some help.
I have been trying to use ASP Upload but it is confusing me as how to modify the script to allow me to insert the name of the File in to the database.
Here is my form page (you will notice this checks to see if we are uploading/editing or deleting). Code:
View Replies
View Related
I am methodically working my way through the Sitepoint 'Build your own ASP.NET website' and have been successful in every lesson up to page 279. However I've come stuck when trying to add information to an Access Database. When I try to do so I get the message:
Operation must use an updateable query.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: Operation must use an updateable query.
I have tried the solution described in the book but still get the message. I am using IIS and XP Professional. The database works for queries so how do I get it to accept information entries?
View Replies
View Related
I would like some one to help me in how to upload a file at aprticular kind of a file in the server at save it in a database in a feild using an asp.
View Replies
View Related
I had some issues with setting file permissions to write to my database in access. How do I go about, step - by - step setting the file permissions?
View Replies
View Related
I would like to know something about placing a password for a database in an external file, something like a global.asa file or a included file. I'm using an access database and ASP. how do I make this file and how do I attach it to my website. I thought this might be useful for extra database security, is this true?
The database is located in a folder that is protected by the hosting provider and you can only download the database using a login name and password and you can change data trough webpages (update, delete and insert).This has all about database security, I want to make my database as secure as possible, I'm already using SSL certificates.
View Replies
View Related
I would like to know if there are any tutorials out there or websites that can explain more about this? can this be done in asp?
View Replies
View Related
I have two forms, the first of which has a dropdown with which the user specifes how many banner ads he wishes to upload for a client. So say he enters the client info and wants to upload 5 banners. The form passes to another page which uses a loop to output form fields. Each form field name is something like name="msg<%= count%>" or name="url<%=count%>".
In the 3rd-Party script I am using I then have this script ....
View Replies
View Related
I have excel file,from which the all data to store the .mdb database. Any one give an idea.
View Replies
View Related
I want to be able to upload a image to a directory called 'images' on my server and also save the file name in a database. is there anything out there that does this without a COM?
View Replies
View Related
I have a form where a user enters their name, date etc. i also want them to be able to click on a browse button and select a file which will then appear in a textbox. when they press submit i want the file name and path to be put into the database. e.g.
"C:windowsworkwork.doc".
Basically I don't want to UPLOAD the file just enable the user to browse to it and send the filename and path to the database.
View Replies
View Related
I want to provide a function using asp for the users to search for their excel files in their PCs in IE and then upload to my database.
View Replies
View Related
