Suggestions For Storing Variables OTHER THAN A Database
I am creating a page that will help college students to determine what schedule they should follow when choosing classes for the next semesters. I will have a database in Access that will list all the different courses they need to graduate & the info surrounding them (including what classes they need to take before they can take specific classes).
Students will fill in their current grades of classes on a form with all the classes listed & then based on what they have taken, this will provide a schedule for the remainder of their classes. I plan to use ASP, VB,& SQL to achieve this.
This is my question: It would be much easier to simply have the student's grades be placed in another table HOWEVER, due to security reasons, I cannot do that. I will need to store the grades (as well as the classes that they were for) in an array of some sorts.
Any suggestions? I was debating putting them in a database & then deleting or clearing that database upon them leaving but I do not know if that is the best solution. HelP? Code:
View Replies
ADVERTISEMENT
I need to write a script that will be able to calculate monthly totals and yearly totals. My database stores the date as "16-Apr-02" and I initially thought I'd just use greater than/less than calculations.
But, this page will need to be generic enough to hold up for a couple years so this option wouldn't work for monthly totals as soon as I get into 2003 right?
So would the best way to go be to parse the date and just look to extract the "Apr", "May", etc for the monthly totals and use the greater/less thans for the yearly totals, or is there even a better way of doing what I'm looking to do?
View Replies
View Related
I'm trying to store a filename to in a variable from aspfreeupload file. Once the file is uploaded I can't seem to fine the variable it's stored in so that I can store it in the database without typing the filename in manually.
View Replies
View Related
I'm currently building my site using ASP and javascript. I found i have a few functions and variables and some javascripts that are required on every pages in my site.
I was wondering if i can store all these commonly used functions/variable/scripts in one location, so i can cut down my codes and for easy maintenence too.
Other than the global.asa file which is used to store global variable, so i create another global file?
View Replies
View Related
Is anyone know how I can store Word Docs and PDF's in database, and how I can make link for visitor to download these files.
View Replies
View Related
i am developing an application using ASP.I have to get product picture from user and store it in to database. i am getting the file path of the picture.
How to read this image and store it in database and retrieve it back for display in another page ?
View Replies
View Related
I am using the code below to add a date input into an access database.
Quote: rs.Addnew
rs("Date")= Request.Form("Date")
Instead of inserting a date with the format dd/mm/yy, a date format of yy/mm/dd will be inserted into the database.
I entered the following code before the insertion Quote: response.write request.form("Date") and it displayed the correct date format as dd/mm/yy.
Pls how do I insert the date into the database for it to store the date as dd/mm/yy instead of as yy/mm/dd. The date format in the date field of the database is dd/mm/yy.
View Replies
View Related
I have an asp contact from which gets data and generates an email containing the users contact details it also send the user a confirmation email.
I was wondering if anyone could explain in simple terms how i would send the form data to be stored in a database?
I know i would have to set up a databse conenction.
how would the form fields be sent to the database?
View Replies
View Related
How can I accomplish the following:
I want to upload image files (jpg) into a sub-directory of a website root directory using a web interface allowing the user to browse their drive and select the jpg file to upload.
Also, is there a way to parse the information from the jpg file and insert the information into a SQL database table which would hold the file name, image height, and image width?
I'm new to handling binary files, so I'm not sure how to accomplish this?
View Replies
View Related
i want to have tree view navigation in my site.Anyone who has come across a good tool that is easy to code and maintain (and with good performance of course)? I don't mind invest to get a really good treeview utility.
Ones I have found so far are treeview.net and projectseven's. One thing important, it has to support unicode well. Most data are in chinese characters.
View Replies
View Related
I am looking for suggestions on book titles. I want great books for:
ASP (VbScript)
SQL
PHP
CSS
XML
Suggestions for or against any titles?
View Replies
View Related
reworking some security for an intranet. need to know if this will do it. user logs in and a session variable is set to true. also a time snapshot is take when they login. if the time has been over 10 minutes without visiting another page its set to false. aslo if they log out its set to false. are there any holes that i should be aware of?
View Replies
View Related
Can anyone suggest a good shopping cart they have had experience with in ASP? I have a client looking for something and I don't want to take the time to write my own (actually they have a pretty short deadline and I'm not good enought at asp to write one that quick). I'm looking for something that I can customize with a XHTML/CSS site.
View Replies
View Related
I currently have a few asp pages linking together. On one page (postNew1.asp) it has a form that allows administrative users to enter a new form.
When creating a new form, there is also a file input box for the user to upload a filename.
If the user does not enter a correct filename, I have an alert box showing "invalid filename" when ever the user presses the "OK". It will not allow him to go anywhere until he enters a valid filename. Code:
View Replies
View Related
I would like to have it to use the variable "Id" in the bit which says where Subject = having set the variable earlier. This is for updating replies in a forum script. Code:
View Replies
View Related
I am connected to a database which is perfect, and I am displaying the values of the database on my initial ASP page which is cool aswell. However I am trying to also pass these values to other ASP pages. THus I am keeping away from opening up the database connection on the other pages to retrieve the same values.
I have been doing alot of searching on the net but it all seems to be about passing user input between forms. There is no user input in my site. I want to pass database values. I have been using the Form Get or Post methods but cant get it to work. Am I going the right way?
View Replies
View Related
I want to upload a file then add a record in a database using info from the uploaded file. I can't figure this out. If anyone has something working that isn't this please let me know. I would rather have this working as I don't want to recode the whole thing.
First the upload doesn't work. The MBRequest(file1).Save isn't supported in this manner. I know you can use .save to upload a file.
Second You'll see that MBRequest is called to form a filename. The filename is called in another page to form a link to the file......
View Replies
View Related
I am creatiung a track record website which displays a list of branches and how many people are available at each individual time slot.
I thought the best way to update would be to create a link which passed two variables, the branch and what time slot. This would then be retrieved int he book.asp page which then would knock one of the current count. I came up with the below page: Code:
View Replies
View Related
I'm having a problem with passing variables inserting to my database. Here's what I'm doing. I have a page where the user selects a team member (this is fine) Once the team member is selected I have the variables on the form send and email to all supervisors and the member selected (this is fine also) BUT, I'm having problems inserting the emailed information to my access 2000 database after is email. Can someone guide me in the right direction.
View Replies
View Related
I am using a customized version of the XML RSS Content Feed VBScript Class (available at:
XML RSS Content Feed VBScript Class to show an XML-feed on my web site. Since the web site are based on a CMS that uses an MS SQL - database, I will try to store the XML-feed in the database instead of just displaying it using a XML/RSS-parser.
I know Microsoft have several tools for this, but they seems to sofisticated and complicated for my use. I just wants an simple ASP-script that reads thought the XML-feed, and store the differnt news-items straight into my MS-SQL DB.
View Replies
View Related
Anyone know of any special issues with storing cookies with ASP? I'm
trying this with two browsers: One is IE 6.0 with cookies set to
'prompt'. This has been working properly as any new site I goto seems
to prompt me to store their cookie. The other is Pocket IE on Pocket
PC 2002, with the cookies set to 'enabled'.
My problem is that the cookies dont seem to be being written with my
ASP. I dont get the prompt to store the cookie when I should. My
storage code looks like this:
Response.Cookies("AcctNbr")= nAcctNbr
Response.Cookies("MsgStart")= nMsgStart
Response.Cookies("MsgEnd")= nMsgEnd
Response.Cookies("AcctNbr").Expires= DateAdd("h", 15, Now)
Response.Cookies("MsgStart").Expires= DateAdd("h", 15, Now)
Response.Cookies("MsgEnd").Expires= DateAdd("h", 15, Now)
And the read code looks like this:
View Replies
View Related
I have run into a unique issue, what I want to be able to do is store a collection or array into a database or xml file. The main reason for doing this, is I don't want to use Sessions as they are volatile to server hiccups or resets. I don't want to use cookies as they are insecure, but I will use one cookie to store a UniqueID to relate to the data in the database or XML file.Can anyone think of a way to store an array in Access, MySQL, or XML file?
View Replies
View Related
I'm writing a vbscript application that reads UTF-8 XML containing Chinese
characters and stores the data in MySql 4.0.x.
Does anybody have any experience in this area with regarding codepage and
character sets? Ideally I want the scripts to be able to handle Standard
European characters and Chinese characters as well.
Are there any special considerations for using MySql/ODBC and ADO to get and
put the data.
View Replies
View Related
I've read that you shouldn't store objects in Session variables.
I've read these reasons:
- The object takes up memory that may not be freed until the session times
out. Better to create the object only when you actually use it.
- Causes poor performance because the thread that created the object has to
service all requests for it.
Assuming I can live with the memory and performance implications (a big if,
but let's assume it for a minute), what other reasons are there?
View Replies
View Related
I have a page which reads the contents from a certain table. The displayed text is followed by a link which is also stored in that table. They can just click the link belonging to a certain newsitem and the page with that news will display. But, for every new item I make a new page. What I want is that the link every time opens the same newspage but with only the selected newsitem. Something like "SELECT description FROM tblNews Where ID= [the ID belonging to the link I pressed on the previous page]"
View Replies
View Related
When I'm creating database driven asp applications, I store my constants,including my connection string to the database within an asp file calledconstants.asp. All constants are stored inside asp coding <% ... %> so people can't save the data through the web.
I've been told this is an insecure way of storing the connect string becuase my connect string would also store the username and password to connect to the db.what is the current standard for storing an connect string to a database for asp applications?
View Replies
View Related
developing a small application, user logs into a page, as soon as user logs into the page, the time(incl seconds) of the page opens has to store in database(time-in), and also the page closing time has to store in db (time-out).
once the time-in and time-out time is stored and it has to calculate the how much time user spend and the total time has to store in db?. i am using sql.
View Replies
View Related
how to store information after the ? in the url in form fields. i.e. http://url/test.asp?User=Rob in Form Field UserName .
View Replies
View Related
Code:
<%
Dim rsDB
Dim strSQL
Dim name
Dim price
Set rsDB = Server.CreateObject("ADODB.Recordset" )
strSQL = "SELECT ProductName, ProductPrice FROM Products WHERE ProductID=" & Request("ProductID" )
rsDB.Open strSQL, Application("strConn" )
' put fields into variables
name=rsDB("ProductName" )
price=rsDB("ProductPrice" )
%>
I am trying to store some data from my database (access) into some variables so that I don't have to keep on opening up the database everytime I want to display the data. Dont know what I am doing wrong but i keep getting an internal server error 500.
View Replies
View Related
I am not too familiar with arrays or recordsets, but I am trying to store ids from database records into an array in an ASP file.
I opened the recordset object in the ASP file, and the stored procedure in the SQL Server pulls back ids from multiple records. I want to store these ids in an array. But I am not sure how to do it. The recordset now seems to be only giving me one id (the id of the last record only) when the stored procedure is made to give ids from multiple records.
View Replies
View Related
I am new to web design and ASP, I am developing a site which has a logon script, what I want to do is return a user to the location they were at after login. Some of the pages will have query-string information in the address bar so need capture that as well.
<script language="JavaScript">
x = window.location.href
document.cookie=x
</script>
Appears to do what I want as I can pick up the href out of the cookie after login and return user to page, prob is I don't seem to be able to include it in my server side scripting which is doing the login it falls over at the script tag.....
View Replies
View Related
I have a wast databse of records, where there are so many Images assiociated with each record. I store the Image paths, record's primary key in the database and retrive them as and when required to display the records and the necessary images corresponding to the records. the image path as of now contains a relative path from the root directoy.
Problem:
The main problem is ..what happenes when the hard disk is full and if i add another harddisk.. and add images into that new hard disk. how will i be able to address the images?? as they are in a separate hard disk hence cannot be addressed relative to the web site's root directory..
How to secure images,Docs from anonymous preying Eyes?
View Replies
View Related
I am trying to store currency symbols in my ms-sql database using an ASP script. But it just wouldnt save them or even submit the form. Has anyone done this before?
View Replies
View Related
